Cliniko and HubSpot: A Revenue Forecast a Sports Medicine Clinic Can Trust

There is a moment in every growing clinic when the Monday morning forecast spreadsheet stops being a tool and becomes a liability. The owner or finance lead rebuilds it by hand. Practitioners are out of sync with what it says. Leadership argues about the wrong numbers because the right ones are four days stale. Decisions get made on instinct.

Take an illustrative example. Northpoint Sports Medicine is a hypothetical single high-volume clinic with 8 practitioners and around $2.4M in annual billings. The billing happens in Cliniko. The forecasting and dashboards live in HubSpot. Every Monday, the finance lead exports both, stitches them together in a spreadsheet, builds the 30/60/90 view, and emails it around. By Wednesday the numbers are wrong. By Friday nobody trusts them.

Why the usual fixes do not work

The standard advice in this situation is to put accounting software, Xero or QuickBooks, between Cliniko and HubSpot, and build a forecast on top of it. That works for tax. It does not work for steering the business, because accounting records what has already been invoiced or collected, not what is on the calendar. By the time revenue lands in the accounting system, the chance to do anything about it has passed.

The other common approach is a separate reporting dashboard built from Cliniko data. That gives leadership a nice chart but nowhere to act. HubSpot is where your patient activity, marketing, and pipeline actually live. Splitting the forecast out into a second system just creates two sets of numbers nobody fully trusts.

How it works once Cliniko and HubSpot stay in step

CRMConnect Cliniko to HubSpot keeps your appointments and your invoices in step with HubSpot automatically, as two separate streams. Appointments are your leading indicator: they show what revenue is on the calendar. Invoices are your confirmed revenue: they show what was billed, paid, or written off. Put the two together and you get a real 30/60/90 forecast that updates every time something changes in Cliniko, not every time someone opens a spreadsheet.

Here is what that gives you:

• Every Cliniko invoice appears in HubSpot with its issue date, status, net amount, tax, total, any discounts, and the patient, so confirmed revenue is always current.
• Every Cliniko appointment appears with its date, practitioner, clinic location, type, and expected value, so you can see booked revenue building on the calendar.
• Each patient’s care plan details, such as session limits and remaining capacity, are visible too, which keeps the forecast from double-counting a patient whose insurer plan is about to run out.

From there, the 30/60/90 forecast becomes the sum of three things: revenue already paid in the period, revenue invoiced and pending in the period, and booked appointments in the period adjusted by your historical arrival-to-billing rate. You can slice it by practitioner and by service line, initial assessments, follow-ups, treatment blocks, package visits, and watch it move against forecast week over week. And because each patient’s record carries the campaign that brought them in, you can finally produce a true marketing return report: ad spend in, billed revenue out.

What the numbers tend to look like

A clinic matching Northpoint’s profile typically sees forecast accuracy improve from the spreadsheet baseline of 75 to 80 percent into the low 90s once appointments and invoices are flowing through. These figures are illustrative, but the pattern holds.

More important than the accuracy is the timing. The forecast updates through the week, so leadership stops arguing about last Monday’s numbers and starts acting on Thursday morning. The finance lead recovers four to six hours a week that used to go into the manual rebuild. And marketing return conversations finally use billed revenue as the measure, instead of form fills.

Recurring-care packages without double counting

Sports medicine sells a lot of multi-visit packages: a 6-pack of treatment sessions, a 12-week return-to-sport program, a post-surgical rehab block. Because each patient’s care plan details, including session limits and remaining capacity, are visible in HubSpot, the forecast can recognise package revenue when it is actually billed, usually up front, and avoid forecasting future session revenue that has already been paid for. Without that care-plan visibility, package patients tend to get counted twice, once at the sale and again at every booked session.

Why this matters for your practice

A trustworthy forecast is the join of two things: booked appointments as your leading indicator, and invoices as your confirmed revenue, with each patient’s care-plan capacity acting as a sanity check. Get all three flowing before you worry about dashboards.

Spreadsheets are not slow because spreadsheets are bad. They are slow because they need a person to refresh them. Move that refresh into the integration and the Monday ritual disappears. And marketing return conversations only get serious when the measure is billed revenue, not form fills.

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