A step-by-step guide to setting up and running your first payroll
Settings are shared across every payroll run. Fill these in once — ClinicFlow will pre-fill every workbook for you.
123456789 RT00012026Up to 30 contractors. For each one:
60 for 60%)60 means 60%, not 0.60.
Maps each Jane service name to a ClinicFlow billing category. Common ones are pre-loaded. Add any custom services from your Jane account.
.csv file in Excel or a text editor.ClinicFlow expects these exact column headers in your Jane export:
ClinicFlow_[ClinicName]_[Month].xlsx.Your downloaded Excel file contains 10 tabs. Here's what each one does:
| Tab | Purpose | What to do |
|---|---|---|
| Cover / Instructions | Overview of the workbook, contact info, and tab guide. | Read only |
| ⚙ Settings | Clinic details, contractor rate card, and service type mapping — pre-filled from your portal settings. | Review; yellow cells are editable |
| 📋 Raw Data | Every invoice row from your Jane CSV, with date, patient, item, payer, and amounts. | Review; add/remove rows if needed |
| 🚦 Payment Status | Auto-flags each invoice as Paid, Partial, or Unpaid based on Balance column. | Review only — formula-driven |
| 📊 Contractor Summary | Per-contractor payroll: T1/T2 therapy, reports, court, VAC, supervision — auto-calculated from Raw Data. | Review payouts; confirm against Jane |
| 🧾 Invoices | Printable invoice for each contractor showing session counts, gross, rate, and payout. | Print or save; invoice #s editable |
| 🏦 Clinic Revenue | Total gross revenue by payer (Blue Cross, Medavie, WCB, VAC, Private) and by service type. | Review monthly revenue breakdown |
| 📈 P&L Dashboard | 12-month P&L: gross revenue, contractor payouts, net. Auto-fills current month. | Archive each month with Paste Special → Values |
| ⚠ Unpaid Clients | List of all client invoices with outstanding balances for follow-up. | Follow up on collections |
| 📬 Invoice Status | Tracks which contractors have been emailed and whether they have approved. | Updated by the portal when you send invoices |
After your trial period, subscribe on the Pricing page. You can update your payment method, download receipts, or cancel anytime via the Billing link in the top navigation (powered by Stripe — no card details are stored by ClinicFlow).
Check that the Staff Member names in your Jane CSV exactly match the contractor names in Settings. ClinicFlow matches on name — even a trailing space or different capitalisation will cause a mismatch. Copy the name directly from Jane.
Go to Settings → Service Type Mappings and add the Jane service name exactly as it appears in your CSV (copy-paste from the Item column to be safe). Assign it to the correct category and save.
Re-check your Settings: confirm Tier 1 % and threshold are correct for each contractor, and that the fiscal year matches. Regenerate the workbook after saving any changes.
Confirm contractor email addresses are correct in Settings. Check your spam folder. If you are testing locally, SMTP must be configured in your .env file. Contact support if the issue persists.
Contact us at admin@imentalhealth.ca — we can accommodate even larger clinics.
ClinicFlow is designed to work with the invoice CSV export from Jane (jane.app). It is an independent tool and is not affiliated with or endorsed by Jane. If your scheduling system can export the same column structure, it will also work. Contact us for help mapping your export.
Create your account and configure settings in under 10 minutes.
Create Account See Pricing