Cash flow forecasting is the single most underused financial tool in dental practice management. Most practice owners track revenue and expenses after the fact, but a forward-looking cash flow model — even a simple one — prevents the late-payroll panics, deferred equipment purchases, and missed growth opportunities that plague practices operating month to month.
As of August 2026, dental practice economics in Ontario have shifted enough that backward-looking bookkeeping is no longer sufficient. The Canadian Dental Care Plan (CDCP) has changed payment timing and reimbursement rates. Supply costs have risen. Staffing expenses remain the largest line item, and they keep climbing. A practice that managed cash flow by feel in 2023 may find that approach failing in 2026. This guide walks through building a cash flow forecasting system designed specifically for the realities of Canadian dental practice.
What Cash Flow Forecasting Actually Is (and Is Not)
Cash flow forecasting is not profit-and-loss accounting. Your P&L tells you whether your practice is profitable on paper. Cash flow forecasting tells you whether you will have money in the bank when the rent, payroll, and supply invoices come due.
The distinction matters because dental practices routinely show positive net income while experiencing cash crunches. Insurance reimbursements arrive 2-6 weeks after treatment. CDCP claims can take longer. Patients on payment plans pay over months. Meanwhile, payroll happens every two weeks, rent is due on the first, and suppliers expect payment within 30 days. Profitable practices run out of cash when the timing of inflows and outflows diverges.
A cash flow forecast maps your expected inflows and outflows across a future time horizon — typically 13 weeks (one quarter) for operational planning and 12 months for strategic planning. It answers one question: will there be enough cash, in the right accounts, at the right time?
Step 1: Map Your Cash Inflows
Dental practice revenue arrives through several channels, each with different timing characteristics. Mapping these accurately is the foundation of your forecast.
Patient Copays and Out-of-Pocket Payments
These are your fastest cash. Money collected at the front desk on the day of treatment (debit, credit, or cash) hits your account within 1-3 business days. For forecasting purposes, estimate this based on your average daily collection rate multiplied by scheduled patient days.
Pull your practice management software's collection report for the past 90 days. Calculate your average daily point-of-service collection. If your practice collects $3,200 CAD per day at the desk and you have 20 clinical days per month, that is $64,000 CAD per month in near-immediate cash.
Insurance Reimbursements
Insurance payments are the largest inflow for most Ontario practices, and the timing varies by carrier. Sun Life, Manulife, and Great-West Life typically process electronic claims within 10-15 business days. Smaller carriers and government programs can take longer.
For forecasting, use your AR aging report. Claims submitted this week will likely produce cash in 2-4 weeks. Claims already in the 30-day bucket should convert to cash within the next 1-2 weeks. Claims past 60 days need active follow-up — they will not self-resolve.
CDCP Reimbursements
The CDCP has introduced a new reimbursement timeline that many Ontario practices are still calibrating. Claims processing times have been variable, and the reimbursement rates differ from provincial fee guides. For forecasting purposes, treat CDCP claims conservatively — assume 4-6 weeks for payment and budget at the CDCP fee schedule, not your standard rates.
Pro Tip: Track CDCP reimbursement timing separately from private insurance for the first six months of participation. Build a CDCP-specific average payment lag into your forecast model. Practices that blend all insurance into a single lag estimate will consistently overestimate near-term cash.
Payment Plans and Financing
If your practice offers in-house payment plans, map each plan's remaining payments across the forecast period. If you use third-party financing (like iFinance or Medicard), the lump-sum payment from the financing company arrives within days of treatment — treat it like a point-of-service collection.
Step 2: Map Your Cash Outflows
Outflows are more predictable than inflows, which is why they form the more reliable side of your forecast. List every recurring expense by week.
Payroll (Largest Expense)
Payroll typically represents 25-35% of gross revenue in a dental practice. This includes associate compensation (whether salary, per diem, or percentage of production), hygienist wages, dental assistant wages, front desk staff, and office management. Include employer-paid benefits, CPP contributions, and EI premiums in the payroll line — these are real cash outflows that hit on payroll dates.
For practices paying bi-weekly, there are two months per year with three pay periods instead of two. These "three-payroll months" catch practices off guard every time. Identify them in your forecast now.
Rent and Occupancy
Fixed monthly expense. If your lease includes a percentage rent clause (rare in dental, but present in some mall locations), estimate the variable portion based on trailing revenue. Include common area maintenance (CAM) charges if applicable.
Dental Supplies
Supply costs typically run 5-8% of gross revenue. These are somewhat controllable in timing — you can stock up when cash is strong and defer non-urgent orders during tight weeks. Map your regular supply orders by their payment terms (typically net 30) rather than by order date.
Lab Fees
Lab fees are procedure-driven and somewhat predictable based on your schedule. If you have ten crown preps scheduled over the next two weeks, you can estimate the lab fees and their payment timing (typically net 30 from delivery).
Equipment Loans and Leases
Fixed monthly payments. Map these to their exact dates.
Insurance, Taxes, and Professional Fees
Malpractice insurance, commercial liability, RCDSO registration fees, CDA dues, accounting fees, and legal fees are often annual or quarterly. They create predictable but lumpy outflows. Plot them on the calendar so they do not surprise you.
Pro Tip: Create a "lumpy outflows" calendar at the start of each year. Plot every non-monthly expense — insurance renewals, RCDSO fees, equipment maintenance contracts, property tax installments, HST remittances — on a 12-month timeline. Then build reserves for the heavy months.
Step 3: Build the 13-Week Rolling Forecast
A spreadsheet is sufficient. You do not need specialized software for this — Google Sheets or Excel works fine.
Structure
Create 13 columns (one per week), with rows for each inflow and outflow category:
- Row 1: Opening cash balance (bank balance at start of week)
- Rows 2-6: Inflows (point-of-service collections, insurance payments, CDCP payments, financing proceeds, other income)
- Row 7: Total inflows
- Rows 8-15: Outflows (payroll, rent, supplies, lab fees, equipment payments, insurance/fees, HST remittance, other)
- Row 16: Total outflows
- Row 17: Net cash flow (total inflows minus total outflows)
- Row 18: Closing cash balance (opening + net cash flow)
- Row 19: Minimum cash threshold (your safety buffer — see below)
- Row 20: Surplus/deficit (closing balance minus minimum threshold)
Setting Your Minimum Cash Threshold
Your minimum cash threshold is the amount of cash you need in the bank at all times to cover unexpected shortfalls. A common starting point is one month of fixed costs (payroll + rent + loan payments). For a practice with $120,000 CAD per month in fixed costs, the minimum threshold is $120,000 CAD.
Conservative practices set this at six weeks of fixed costs. Aggressive practices set it at two weeks. Start at four weeks and adjust based on how variable your inflows actually are.
Populating the Forecast
Week 1 uses actual numbers — your current bank balance, known incoming payments, and confirmed outflows. Weeks 2-4 use near-certain estimates — scheduled patients, submitted claims with expected payment timing, and confirmed payroll dates. Weeks 5-13 use trend-based estimates — historical averages for collections, seasonal adjustments for patient volume, and known future expenses.
The forecast becomes less precise further out. That is expected and acceptable. The value is not in predicting week 13 to the dollar — it is in spotting a cash crunch in week 6 while you still have five weeks to respond.
Step 4: The Weekly Review Ritual
A forecast is worthless if it sits in a file. The practice owner or office manager must review and update it weekly. This takes 20-30 minutes.
- Update week 1 with actuals. Replace estimates with real numbers from last week. How did actual collections compare to forecast?
- Shift the window forward. Drop last week, add a new week 13.
- Adjust assumptions. If a large insurance payment you expected in week 2 has not arrived, push it to week 3 or 4. If you scheduled an emergency equipment repair, add the outflow.
- Check the threshold line. Does any week show a closing balance below your minimum? If yes, act now: accelerate collections, defer a discretionary purchase, or arrange a line of credit draw.
Pro Tip: Schedule the weekly forecast review for the same day and time every week — Monday morning before the first patient is a natural fit. Treat it with the same discipline as your morning huddle. Financial surprises in dental practice are almost always preventable with 4-6 weeks of visibility.
Common Cash Flow Traps in Dental Practice
The Production-Collection Gap
High production does not equal high cash flow. A practice that produces $800,000 CAD per month but collects only $680,000 CAD has a 15% collection gap. Over a year, that is $1.44 million in revenue that was produced but never converted to cash. Track your collection rate (collections divided by production) monthly. Anything below 95% deserves investigation.
Accounts Receivable Aging
Research across dental practices shows that the probability of collecting an account drops significantly after 90 days. Past 120 days, a substantial portion of outstanding balances is effectively uncollectible. If your AR aging report shows more than 15% of outstanding balances past 90 days, your collection process needs immediate attention.
Seasonal Patterns
Dental practices in the GTA experience predictable seasonal variations. September and January see spikes as insurance benefits reset. July and August often dip as patients (and staff) take vacations. December production drops in the last two weeks. Build these patterns into your forecast — a practice that treats every month as average will be caught short in slow periods.
CDCP Volume Surge Without Cash Surge
Practices that have significantly increased CDCP patient volume may see production numbers climb while cash flow stagnates. CDCP reimbursement rates are lower than provincial fee guide rates, and payment timing is less predictable than private insurance. If CDCP now represents more than 20% of your patient mix, model its cash flow impact separately.
Using the Forecast for Strategic Decisions
Once the 13-week model is running, extend it to 12 months for strategic planning. A 12-month forecast helps you answer questions like:
- Can we afford to hire an additional hygienist in Q4?
- When is the optimal month to purchase that new intraoral scanner?
- Do we have enough cash runway to renovate an operatory without financing?
- What happens to our cash position if we lose our largest insurance contract?
The 12-month model uses broader assumptions and is less precise week-to-week, but it prevents the capital expenditure surprises that force practices into unfavorable financing terms. A practice that knows six months in advance that it needs $85,000 CAD for equipment can plan. A practice that discovers the need next month scrambles.
Frequently Asked Questions
Q: How long does it take to set up a cash flow forecast for a dental practice?
The initial setup takes 2-4 hours: gathering bank balances, pulling AR aging reports, listing recurring expenses, and building the spreadsheet structure. Once the template is built, the weekly update takes 20-30 minutes. Most practice owners report that the forecast pays for itself in prevented cash crunches within the first quarter of use.
Q: Do I need special software for dental practice cash flow forecasting?
No. Google Sheets or Microsoft Excel provides everything you need for a 13-week rolling forecast. Your practice management software (Dentrix, Tracker, ClearDent, ABELDent) generates the AR and production reports that feed the forecast. Specialized cash flow tools exist but are unnecessary for most single-location practices.
Q: How should Ontario dental practices account for CDCP reimbursement in their cash flow forecast?
Track CDCP claims separately from private insurance. Use a conservative payment lag assumption of 4-6 weeks and budget at CDCP fee schedule rates, not your standard rates. As you accumulate data on actual CDCP payment timing, refine your assumptions. Blending CDCP with private insurance in a single reimbursement estimate will consistently overstate near-term cash availability.