Two forecasts, one method
The 13-week forecast answers one question: will cash cover every obligation, payroll, splits, rent, remittances, debt, over the next quarter, week by week. It is built at the bank-account level, updated weekly in under an hour, and its job is to make bad weeks visible while there is still time to move something. Thirteen weeks is the standard horizon because it is long enough to see a quarter's obligations and short enough to stay honest.
The 12-month model answers a different question: what will the year produce, and what should we do about it. It runs monthly rather than weekly, and it is where the planning decisions live: how much salary and dividend the corporation can sustain, what instalments should be, whether the equipment purchase happens this year, whether a second location is fundable. The weekly forecast keeps you safe; the annual model makes you money.
Both are driver-based. The forecast starts from the provider schedule, because in a clinic the schedule is the revenue: bookable hours, expected utilization, average collections per hour, then each payor's payment lag layered on top. A spreadsheet does this job perfectly well; the value is in the logic and the weekly habit, not the software. What makes clinic forecasting genuinely easier than most industries is that the order book is the appointment book, and you can read it six weeks ahead.
The weekly update is where the forecast becomes a system instead of a document. Each week, replace the oldest forecast week with actuals, note the variance, and adjust only the assumptions the variance disproves. Over a quarter this does two things: the forecast gets steadily more accurate because its lags and utilization figures are being trained on your own data, and you build an early-warning habit, because a variance you explain in week two is a problem you fix in week five instead of discovering in the bank balance.
Build revenue from the schedule up
Forecast revenue as hours times utilization times collections per hour, provider by provider, because that is how the revenue is actually made. Clinic-level extrapolation smuggles in the assumption that the provider mix is static, and the provider mix is exactly what changes: an associate joins, a provider cuts a day, a maternity leave arrives, a hygienist resigns. Building per provider means each of those events becomes an edit to one row instead of a shrug at the total.
Three refinements make the revenue build reliable:
- Ramp curves for new providers. A new associate reaches mature billings over months, not weeks. Forecast the ramp explicitly, and the model will tell you what the guarantee period really costs before you sign it.
- Seasonality from your own history. Recall-driven practices see benefit-deadline surges late in the year; school calendars and summer holidays carve predictable dips. Two or three years of your own monthly collections give you the shape; apply it to the driver math rather than guessing.
- Net of no-shows. Utilization assumptions should be booked hours that actually happen. A clinic with a measured no-show rate should forecast with it, and treat improving it as upside rather than baking optimism into the base case.
Capacity changes deserve explicit modelling too, because they are the cheapest revenue moves a clinic has. Opening a Saturday morning, converting a storage room to an operatory, or extending a strong provider's week each changes the hours driver directly, and the model prices the move in minutes: incremental hours, a realistic utilization ramp, incremental staffing cost. Testing capacity moves in the model first is how clinics avoid the pattern of hiring for growth before the schedule proves the demand exists.
If you already run a monthly KPI page, the drivers are sitting on it: utilization, revenue per provider hour and realization come straight from the numbers a clinic should already be tracking. Forecasting is those same numbers pointed forward instead of backward.
Map when the cash actually lands
Revenue timing is where clinic forecasts go wrong, because each payor pays on its own clock and the forecast must model the clock, not the invoice date. The mapping looks like this:
| Revenue stream | When the cash typically lands | Forecasting note |
|---|---|---|
| Provincial fee-for-service billings | On the plan's regular monthly remittance cycle after claim submission | Highly predictable; model the fixed lag and watch rejected claims, which silently extend it |
| Insurer claims assigned to the clinic | Days to weeks after submission, varying by insurer and claim type | Model from your own receivable-days history per insurer, not from plan brochures |
| Patient out-of-pocket balances | At the visit if collected at point of service; slowly and partially if invoiced | Split the stream in two: point-of-service cash at full value, invoiced balances lagged and discounted for collectability |
| Uninsured programs and block fees | Up front, in a lump | Smooth the cash across the service period in the model so a strong January does not disguise a weak spring |
| Product and retail sales | Immediately | Small but instant; remember HST obligations ride along with the taxable stream |
Practices paid under alternate arrangements have a different, easier mapping. Rostered or program-based payments arrive as scheduled amounts rather than claim-by-claim remittances, which smooths the revenue line considerably; the forecasting risk shifts from timing to composition, the fee-for-service and premium components layered on top of the base payment. The principle holds either way: model each stream on its own clock instead of blending them into one revenue line.
The honest inputs here are your own numbers: receivable days by payor, measured from your ledger, converted into lag assumptions. When the forecast misses, it is almost always because the lag assumption was aspirational, and the fix is to recalibrate the lag from the last three months of actual collections, not to adjust the revenue.
Layer the outflows in the order they bite
Forecast outflows by their real dates and their real rigidity, starting with the ones that cannot move. Payroll and source deduction remittances are immovable, and a missed remittance is the most expensive miss in Canadian small business, so they anchor the weekly forecast. Rent and debt service come next, contractual and dated. Provider splits follow their contracts: some clinics pay splits on billings in the month after production, others on collections, and the forecast must copy whichever the contracts actually say, because the difference is a full payment cycle of cash.
Then the variable and lumpy layers. Supplies and lab costs track activity, so tie them to the same driver math as revenue rather than a flat monthly figure. Equipment purchases, leasehold work and software renewals are lumpy and mostly steerable, which makes them the natural release valve when the 13-week view shows a tight stretch. The forecast's quiet job is to reveal which weeks can afford the lumpy items, so timing choices become deliberate.
Tax gets its own layer because its clock is unlike anything else in the model. Corporate instalments run on the corporation's own schedule; the balance due lands months after year-end; HST filings apply only to taxable streams like cosmetic services and product sales, since core health services are exempt. The exemption also means HST paid on rent, supplies and equipment is a true cost the forecast should carry at full freight, with no input tax credit coming back.
A line of credit belongs in the model as a timing tool, never as revenue. Its correct job is bridging the gap between production and collection, drawn when a receivable-heavy month meets a payroll-heavy week, repaid when the remittances land. The forecast makes the distinction visible: a draw the model shows repaying itself within the cycle is financing working capital, while a draw with no repayment path in the next thirteen weeks is a loss being papered over, and it is far better to learn that from the spreadsheet than from the banker.
Owner compensation and tax make or break the model
The largest discretionary line in a clinic forecast is what the owner takes out, so the forecast and the compensation plan must be built together. Inside a professional corporation, profit retained is taxed at Ontario's combined small-business rate of 12.2 percent on the first 500,000 dollars of active income, while everything paid out attracts personal tax now, so the annual model is where the salary-versus-dividend mix gets sized against real cash. Salary commits the corporation to monthly payroll cash and remittances; dividends can flex with the year; most owners run a planned blend, and the model shows what blend the clinic can sustain in its weakest quarter rather than its best.
The model also has to carry the shadow calendar of personal tax: instalments or a spring balance for the owner, family shareholder dividends where the structure and the tax on split income rules genuinely permit them, and the corporate instalment reset after a strong year. A clinic that forecasts only the business's cash and forgets the owner's tax calendar rediscovers it every March. This interlock between the forecast, compensation and the corporate tax plan is the core of what we do as a CPA for incorporated healthcare professionals in Ontario, and it is why we build the forecast and the tax plan as one document rather than two.
Stress it, use it, and the facts that change the answer
A forecast earns its keep when you break it on purpose. Run three stresses annually and after any major change: a key provider leaving with a realistic replacement gap, a payor lag stretching by a few weeks, and the next planned investment landing over budget. What you learn is the size of the cash buffer the clinic actually needs, which turns weeks-of-cover from a vague comfort number into a policy. The same machinery prices growth: a new associate's ramp, a renovation, or a second site all get tested in the model first, and for expansion specifically the forecast is the financial spine of preparing a clinic to open another location.
The forecast is also the strongest document in a financing package. Lenders underwriting a clinic want to see debt service covered in the weak months, not the average months, and a driver-based model with visible assumptions reads as management depth. We build financing packages around exactly this through our financing support service, pairing the forecast with statements a credit committee can move on.
What changes the answer for your clinic comes down to a short list:
- Payor mix. Mostly provincial billings makes timing tight and predictable; insurer- and patient-heavy clinics need harder receivable assumptions and a bigger buffer.
- How providers are paid. Salaries make outflows rigid and predictable; splits make them variable but tied to collections, which self-hedges a slow month.
- Debt structure. Heavy equipment and build-out debt raises the fixed floor the forecast must clear every single week.
- Growth posture. A stable clinic forecasts to protect; a growing one forecasts to decide, and the model needs scenario branches, not just a base case.
- Entity structure. Groups with multiple corporations need a forecast per entity plus a combined view, because cash trapped in the wrong company is a real liquidity problem, part of the wider reporting design in financial reporting for multi-provider clinics.
- Taxable revenue streams. Cosmetic and retail lines add HST collection and filing to the calendar the forecast must track.
We set these models up and then run them with clients month after month, because a forecast maintained by nobody is a spreadsheet, not a system. A free 15-minute discovery call is enough to tell you which forecast your clinic is missing and what it would take to stand it up.
