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 service name from your CSV to a ClinicFlow billing category. Common names are pre-loaded. Add any custom service names from your platform.
.csv file directly onto the Payroll page,
or open it in a text editor, select all (Ctrl+A), copy, and paste into the portal.
ClinicFlow recognises these columns (and common aliases from any platform):
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 session row from your CSV import, with date, patient, item, payer, and amounts — parsed by ClinicFlow. | 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 — all calculated by ClinicFlow from your session data. | Review; ClinicFlow does the math |
| 🧾 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 works with CSV exports from Jane, Owl, Cliniko, and any platform that exports session or invoice data. It auto-detects column headers, so no manual mapping is needed for common platforms. For unusual column names, use the Universal CSV Importer to define your own mapping and save it as a template.
Create your account and configure settings in under 10 minutes.
Create Account See Pricing