Cliniko and Salesforce: A 90-Day Revenue Forecast for an Allied Health Clinic

A finance manager rebuilding the forecast every Monday in a spreadsheet is a clear signal that the business has outgrown its forecasting tools. Past a certain size the spreadsheet is no longer the tool, it is the bottleneck.

Take an illustrative example: Southbank Integrated Health, a hypothetical single large clinic with 19 practitioners across physiotherapy, dietetics, psychology, and exercise physiology, and around $3.1M in annual revenue. The finance manager rebuilds the 90-day forecast by hand every Monday. Cliniko holds the invoices. Salesforce holds the pipeline. Nobody fully trusts the projection. Funded care plans add a layer of recurring billable activity that the spreadsheet handles inconsistently. Leadership meetings spend a chunk of every Tuesday arguing about which number is right rather than acting on what the right number says.

Why the Monday spreadsheet is holding you back

A spreadsheet forecast at this scale fails on three fronts:

• It goes stale fast. It is accurate the moment it is built and out of date within a day.
• It is slow to slice. Pivoting by practitioner or service line takes hours, and the columns never agree on naming.
• It misses funded-plan limits. Funded care plans have a ceiling on how much can be billed. A spreadsheet rarely models that correctly, so it either over-projects funded revenue that is already capped, or under-projects renewals that are about to come up.

The result is a forecast leadership debates rather than acts on. The real cost is not the finance manager’s hours, real as those are. It is decisions made slowly.

Why other approaches fall short

Putting accounting software between Cliniko and Salesforce gives you tax-grade revenue figures but not an operational forecast, because the accounting view is based on invoices already issued, not appointments already booked. A standalone reporting dashboard on a Cliniko export gives leadership a chart but no working surface inside Salesforce, where the sales pipeline and program activity already live. And splitting forecasting out into its own tool just creates two systems that disagree.

How a self-updating forecast works

When CRMConnect connects Cliniko to Salesforce, your Cliniko invoices and appointments flow into Salesforce automatically, alongside care-plan information like session limits and billing caps. Your forecast becomes a Salesforce report built on three layers, and it refreshes itself. The Monday rebuild disappears.

The three layers:

Confirmed revenue. Paid invoices dated in the period. This is money already recognized.

Highly likely revenue. Booked and arrived appointments dated in the period, multiplied by your historical rate of turning an arrived appointment into a paid bill, plus pending invoices weighted by how reliably they get paid.

Renewable, capacity-limited revenue. Active funded care plans, with forecasted revenue capped at the amount still billable on the plan. This is the piece that matters most: funded plans have a ceiling, and the forecast should never project past it.

Once those three layers are in place, you can slice the forecast by practitioner and by service line (first assessments, follow-ups, group programs, packages). That is the view that shows leadership where the forecast is concentrated and where capacity is sitting idle.

The reporting cadence

Send the leadership team a weekly forecast that refreshes on its own, with no manual rebuild. Hold a monthly variance review with finance, comparing the forecast from a few weeks earlier against what actually happened. That comparison is how the forecast keeps getting more accurate.

What you get from this

A clinic matching Southbank’s profile typically lifts forecast accuracy from the spreadsheet baseline of 75 to 82 percent into the low 90s once the three-layer Salesforce forecast is running. The finance manager gets back 4 to 6 hours a week. Leadership stops arguing about the forecast and starts acting on it. And funded revenue gets projected correctly rather than over or understated, which is the single biggest source of forecast error in many allied health practices.

Handling funded plans responsibly

Funded care plan tracking is what makes this forecast accurate, but it comes with a responsibility. The plan, the funding source, and a patient’s eligibility status are sensitive operational details, not marketing data. Surface them in finance and operations reports. Keep them out of marketing reports. Because you choose what gets shared item by item, you can draw that line cleanly.

Why this matters for your clinic

When the forecast is rebuilt by hand, it is a snapshot that is wrong by Tuesday and an argument by Wednesday. When it is built on live Cliniko invoices, appointments, and funded-plan limits inside Salesforce, it is a current, trusted number leadership can plan staffing, capacity, and growth around. Your finance manager stops being a spreadsheet operator and starts being an analyst.

Want to see CRMConnect Cliniko to Salesforce in action? View the API App page.