Cash flow forecasting for Ontario small businesses: a guide

A cash flow forecast tells you, in dollars, whether your business will have enough money in the bank to cover payroll, suppliers, and CRA remittances over the coming weeks. Start with a rolling 13-week forecast built from today’s cleared bank balance. Add every expected receipt and every scheduled payment, then update it weekly.

Here’s what to do in the next three days:

• Pick your starting number. Use today’s cleared bank balance, not what your accounting software says is “in the pipeline.”
• List the next 13 weeks of money in and money out. Include GST/HST remittances and payroll dates.
• Book a recurring 30-minute slot each week to update the numbers and check for a negative balance ahead.

Most cash crunches come from money arriving later than expected, not from spending more than planned.*

Key Takeaways

A useful cash flow forecast for an Ontario small business starts from today’s cleared bank balance, runs 13 weeks forward, and gets updated every single week without exception.

Table of Contents

• What is cash flow forecasting, and what does it actually predict?
• Why cash flow forecasting matters for Ontario small businesses
• Direct vs indirect cash flow forecasting: which method fits your business?
• How do you forecast cash flow? Seven steps to build your first model
• Common cash flow forecasting mistakes that make the numbers useless
• What to do when your forecast shows a shortfall or a surplus
• Templates and tools that work for Canadian small businesses
• How often should you update your cash flow forecast?
• When should you bring in an adviser or a virtual CFO?
• Sources
• FAQ

What is cash flow forecasting, and what does it actually predict?

Cash flow forecasting is the practice of estimating when money will actually land in and leave your bank account over a set period, so you can see shortfalls or surpluses before they happen. It’s not the same as a profit and loss statement, and it’s not the same as a historical cash flow statement either. Cash flow forecasting works as an early-warning system, flagging cash shortages weeks or months before they hit.

Three things to keep straight:

• Cash flow forecast looks forward. It predicts future bank balances based on expected timing of receipts and payments.
• Cash flow statement looks backward. It reports what already happened, usually as part of your financial statements.
• Profit is an accounting concept. A profitable month can still leave you cash-poor if a big invoice hasn’t been paid yet.

Horizon matters too. Short-term forecasts (1 to 13 weeks) manage day-to-day survival. Medium-term forecasts (3 to 12 months) support budgeting and hiring decisions. Long-term forecasts (a year or more) inform expansion, financing, and lease commitments.

Why cash flow forecasting matters for Ontario small businesses

Forecasting isn’t a paperwork exercise. It changes decisions you make this month. A clear forecast lets you:

• Time payroll runs so you’re never scrambling two days before a pay date.
• Protect supplier relationships by paying on schedule instead of asking for extensions.
• Avoid expensive short-term borrowing by seeing a shortfall coming with enough lead time to arrange financing on better terms.
• Support hiring and growth decisions with real numbers instead of gut feel.

For Ontario businesses, GST/HST and payroll remittances deserve their own line items. These aren’t optional outflows, and they arrive on a fixed CRA schedule regardless of how your receivables are behaving that month. Treat them the same way you treat rent: non-negotiable, and dated.

As a buffer target, the Financial Consumer Agency of Canada recommends holding 3 to 6 months of essential operating expenses in reserve. Your forecast is what tells you whether you’re building toward that cushion or eating into it.

Direct vs indirect cash flow forecasting: which method fits your business?

If you run a straightforward operation with predictable receipts and payments, use the direct method. If you’re managing complex projects with long billing cycles, an indirect approach layered on top of accrual data often serves you better.

Direct forecasting tracks actual expected cash receipts and disbursements by date. You list what money is coming in, when, and what’s going out, when. It’s simple, intuitive, and the standard choice for most small businesses and sole proprietors because it maps directly to your bank account.

Indirect forecasting starts from your accrual-based income statement and adjusts for non-cash items and timing differences. It’s more useful for larger or project-based businesses that need to reconcile forecasts against formal financial statements, but it takes more accounting know-how to build and maintain.

For cadence, the pattern that works across most Ontario small businesses is this: run a weekly 13-week rolling forecast for operational decisions, and pair it with a monthly 12-month projection for planning and lender conversations. Rolling means you drop last week and add a new one every time you update, so you always have a full 13 weeks ahead of you.

Pro Tip: Lenders often prefer the 13-week view specifically because it mirrors how payments actually clear, not how invoices are dated. If you’re heading into a financing conversation, have that model ready.

How do you forecast cash flow? Seven steps to build your first model

Use a 13-week rolling model that starts from your cleared bank balance today. Here are the seven steps, in order:

1. Set your starting cash truth. Pull today’s actual bank balance, reconciled, not an estimate from memory.
2. List inflows by expected deposit date. Go through accounts receivable and note when each invoice is realistically likely to be paid, not its due date.
3. List outflows by withdrawal date, including rent, payroll, supplier payments, and CRA remittances (GST/HST and payroll source deductions).
4. Build weekly totals and a running balance. Each week’s closing balance becomes next week’s opening balance.
5. Add scenarios. Build a base case, a downside case, and an upside case by adjusting a few key levers.
6. Validate against historical AR and AP behaviour. If customers typically pay 10 days late, your forecast should assume that, not the invoice terms.
7. Set a review cadence and assign an owner. Someone specific updates it every week, on the same day.

Before you start, gather these inputs:

• Current bank balance (reconciled)
• Accounts receivable aging report
• Accounts payable schedule with due dates
• Payroll calendar and CRA remittance due dates
• Any planned one-time costs (equipment, capital expenditure, tax instalments)

Here’s a simplified worked example for one week. Say your opening cash balance is $18,000. You expect $12,000 in customer payments and a $5,000 supplier deposit refund, for total inflows of $17,000. Outflows include $9,500 in payroll, $4,200 to suppliers, and a $2,800 GST/HST remittance, for total outflows of $16,500. Your closing balance for that week is $18,500, which becomes next week’s opening number.

Run that same logic forward 13 weeks and you’ll see exactly which week, if any, your running balance dips below zero, giving you time to act instead of reacting. Building this from your cleared bank balance forward is what separates a useful forecast from a spreadsheet nobody trusts.

Scenario testing doesn’t need to be complicated. Adjust a handful of simple levers, such as accounts receivable days, gross margin, payroll hours, or inventory timing, and watch how each one moves your closing balance. That’s usually enough to see where your real risk sits.

Pro Tip: When in doubt about timing, push receipts later and payments earlier in your model. A forecast that’s wrong in the conservative direction gives you a pleasant surprise. A forecast that’s wrong the other way gives you a crisis.

Common cash flow forecasting mistakes that make the numbers useless

A forecast only works if it reflects how your business actually moves money, not how you wish it did. The most common errors:

• Treating it as a one-time exercise. A forecast built once and never updated is a snapshot, not a forecast. Fix: update weekly, minimum.
• Confusing profit with cash. A profitable invoice sitting unpaid for 60 days doesn’t pay your rent. Fix: forecast on expected payment date, not invoice date.
• Ignoring seasonality. A retailer that does 40% of annual sales in November and December can’t use a flat monthly average. Fix: build seasonal patterns into both the 13-week and 12-month models using last year’s actuals.
• Assuming optimistic AR timing. Customers paying “on time” is the exception, not the rule. Fix: use actual historical payment behaviour, not stated terms.
• Excluding tax remittances. GST/HST and payroll deductions are cash outflows just like payroll itself. Fix: add them as fixed line items tied to CRA due dates.

Pro Tip: If your business has a slow season, build two versions of your 12-month monthly template, one weighted for peak months and one for the trough, then blend them into your 13-week rolling view as you approach each transition.

What to do when your forecast shows a shortfall or a surplus

Timing fixes come first, because they’re usually free. Tighten your invoicing process so bills go out the day work is done, not a week later. Offer a small early-payment incentive to your best customers. Match your own supplier payment terms to when your receivables actually land, rather than paying everyone on day one.

If timing alone doesn’t close the gap, move to cost and liquidity levers:

• Defer discretionary spending (equipment upgrades, non-essential subscriptions) until the shortfall clears.
• Access an operating line of credit or overdraft facility before you need it, not during a crisis.
• Negotiate a payment plan with suppliers rather than missing a payment outright.

In Ontario, CRA remittance timing is where shortfalls hit hardest, because those dates don’t move for anyone. If your forecast shows a shortfall in a remittance week, talk to your bank about an operating line ahead of time rather than after the payment bounces.

On the surplus side, resist the urge to spend it immediately. Build toward that 3 to 6 month operating expense reserve first.

Pro Tip: Run a quick liquidity check monthly: divide your cash on hand by your average weekly outflow. If the answer is under four weeks, treat every new commitment as a forecast decision, not a routine one.

Templates and tools that work for Canadian small businesses

You don’t need expensive software to start. A simple spreadsheet with weeks as columns and cash line items as rows will get you a working 13-week forecast today. List your opening balance, every expected inflow by date, every expected outflow by date, and a running closing balance formula at the bottom of each column.

Once you outgrow a spreadsheet, here’s how the common Canadian options compare:

• Excel or Google Sheets: Free, flexible, and fully under your control. Best for businesses just starting out or with simple, predictable cash flows. Downside: manual updates and no automatic bank feed.
• QuickBooks Online Canada: Strong bank feed integration and built-in cash flow projection tools. Best for businesses already using it for bookkeeping who want forecasting tied directly to real transactions.
• Xero: Clean interface with short-term cash flow visibility and solid multi-currency support. Good for businesses working with international clients or suppliers.
• Wave: Free accounting software suited to freelancers and very small operations, though forecasting features are more limited than QuickBooks or Xero.

Whichever platform you pick, run through this integration checklist: connect live bank feeds so your opening balance updates automatically, set up accounts receivable aging reports to feed the receipts side, sync accounts payable so nothing gets missed, connect your payroll system for accurate payroll dates, and add a dedicated line for CRA remittances that pulls from your payroll and GST/HST filing calendar. A comparison like QuickBooks versus Xero can help you decide which platform fits your bookkeeping setup before you build your forecast on top of it.

How often should you update your cash flow forecast?

Update your 13-week rolling forecast every week. Refresh your 12-month planning projection every month. Finance or the business owner owns the weekly update; operations weighs in monthly on demand assumptions and hiring plans.

A simple weekly checklist keeps the 13-week model honest:

1. Update the actual bank balance from this week’s bank statement.
2. Record which invoices were actually collected, and compare against what you forecast.
3. Adjust accounts payable for anything that shifted timing.
4. Re-run the closing balance and flag any week ahead showing a shortfall.

Structure your spreadsheet with weeks running across the top as columns and categories (opening balance, receipts, payroll, supplier payments, CRA remittances, closing balance) down the side as rows. That layout makes the running balance easy to scan at a glance and easy to hand off if someone else needs to update it while you’re away.

When should you bring in an adviser or a virtual CFO?

Hire outside help when your forecast keeps showing shortfalls that timing adjustments alone can’t fix, when you’re negotiating credit and need someone who speaks the bank’s language, or when a growth decision demands real scenario modelling instead of a guess.

Watch for these trigger points:

• Repeated cash shortages that reappear month after month despite your best timing fixes.
• Project-based work with complex, staggered cash timing across multiple contracts.
• Planned expansion, a new hire wave, or a lease commitment that changes your cash profile.
• A lender or investor asking for forecasts more detailed than what you currently produce.

A typical virtual CFO engagement starts with a diagnostic of your current cash position, moves into setting up a proper rolling 13-week model, and continues with monthly advisory sessions to interpret results and adjust assumptions. T-Ledgers’ virtual CFO service is built around exactly that structure, starting with a diagnostic conversation before any commitment.

An accountant’s quick perspective for Ontario small businesses

The businesses that struggle most with cash flow aren’t the ones with bad months. They’re the ones surprised by predictable ones. Payroll remittance dates don’t move. Seasonal slowdowns repeat every year. Yet forecasts still get built once in January and forgotten by March.

The fix isn’t more sophisticated software. It’s rhythm. A 13-week forecast updated every single week, even roughly, beats a perfect model touched twice a year. Start this week: block 30 minutes on your calendar, same day, same time, and treat it as non-negotiable as payroll itself.

How T-Ledgers takes the friction out of cash flow forecasting

Building a forecast is one thing. Keeping it accurate every week while running a business is another. T-Ledgers handles the pieces that feed your forecast, bookkeeping, payroll, GST/HST filing, and tax remittances, so the numbers going into your 13-week model are already reconciled and current.

Under T-Ledgers’ flat-rate model, you know the cost of that support upfront, no hourly surprises tacked onto your invoice mid-project. Clients working with T-Ledgers’ CPAs get bookkeeping that’s audit-ready and payroll that lands on time, which means the inputs to your forecast are trustworthy from day one, not something you’re chasing down every Friday.

If your forecast keeps flagging shortfalls you can’t solve with timing alone, or you simply want your first 13-week model built properly, request a diagnostic through T-Ledgers’ virtual CFO page and start from a forecast you can actually rely on.

Sources

• Setting up emergency funds — Financial Consumer Agency of Canada
• Cash Flow 101: Forecasts, planning, statements and strategy — RBC Royal Bank

FAQ

How do you forecast cash flow?

Start from your current reconciled bank balance, list expected receipts and payments by realistic date rather than invoice date, and calculate a running weekly balance across a 13-week horizon.

What is the best cash flow forecasting tool for a small business?

A simple spreadsheet works well when you’re starting out; QuickBooks Online Canada and Xero add automatic bank feeds and built-in projection features once your transaction volume grows. T-Ledgers can help set up whichever platform fits your bookkeeping.

How do you do a 12-month cash flow forecast?

Build a monthly version of the same model used for the 13-week forecast, incorporating seasonality from prior-year actuals, and refresh it monthly rather than weekly since it’s meant for planning, not daily cash decisions.

What are the seven steps of cash flow forecasting?

Set your starting cash balance, list inflows by expected date, list outflows by date including CRA remittances, build weekly running totals, add scenario cases, validate against historical AR and AP behaviour, and set a weekly review cadence with a named owner.

How often should a small business update its forecast?

Update the 13-week operational forecast every week and the 12-month planning projection every month, adjusting both whenever a major assumption changes, such as a new contract or a lost customer.

Recommended

• Best Accounting Software: Small Business Guide (Canada Edition)
• Break even analysis for small businesses: how to calculate it
• Accounts payable process for small businesses: a step-by-step guide
• QuickBooks vs Xero: which route for Canadian small businesses?