Cash Flow Forecasting for Canadian Small Business: The 13-Week Model That Works

If your income statement says you made money last month and your bank balance says otherwise, nothing is broken. Profit is an accounting opinion about when revenue and expense belong; cash is a fact about what cleared the bank. A 13-week rolling cash flow forecast is the tool that reconciles the two, and for a Canadian small business the single biggest reason the two diverge is the money sitting in the account that already belongs to the Receiver General.

The 60-second version

• Forecast cash by the week it moves, not the week it is earned. A 13-week grid starting from the real cleared bank balance beats any monthly budget for operating decisions.
• GST/HST collected is not revenue. Net tax is calculated and remitted each reporting period under section 228 of the Excise Tax Act [2], so it must appear as a scheduled outflow from the day you invoice.
• Corporate tax instalments keep leaving the account in bad months. Section 157 of the Income Tax Act bases them on prior-year or estimated tax, not on how this month went [1].
• Unsubmitted expense claims are invisible liabilities. They arrive in clumps, distort the forecast, and delay the input tax credit attached to them.
• Roll it weekly. A forecast built once and admired is a document; a forecast rebuilt every Monday is a control.

Why is my business profitable but out of cash?

Four mechanics account for almost every case, and none of them is an error.

Timing of collection. Revenue is recognized when you invoice. Cash arrives when the customer pays, which in most Canadian B2B work is thirty to sixty days later and sometimes longer. A month of record sales is a month of record receivables, and receivables do not make payroll.

Tax you are holding. When you charge GST or HST, that amount lands in your operating account and looks exactly like revenue on the bank statement. It is not. You calculate net tax for the reporting period and remit it [2]. If you are on the quick method of accounting for GST/HST, the arithmetic changes but the principle does not.

Capital purchases. A vehicle or a server leaves the bank in full on the day you buy it, while the deduction is spread over years through capital cost allowance. The income statement barely notices; the bank account absolutely does. Our guide to CCA classes for Canadian small business covers which class a purchase lands in.

Principal repayments. Only the interest portion of a loan payment hits the income statement. The principal is a pure cash outflow that never appears in profit.

What is a 13-week cash flow forecast?

It is a grid: thirteen columns, one per week, and rows for every category of money movement. The top row is the opening bank balance, which must be the actual cleared balance, not the balance in your accounting system. Below it sit receipts, then each class of payment, then a closing balance that becomes next week's opening balance.

Thirteen weeks is not arbitrary. It is one quarter, which is long enough to contain a full GST/HST reporting cycle for a quarterly filer, a quarter of instalment payments, and most of a receivables cycle, while short enough that you can still name the individual invoices you expect to collect. Past week thirteen you are guessing, and guessing belongs in an annual operating budget, not in a cash forecast.

How do I build the 13-week model?

Work in this order. The order matters because each step constrains the next.

1. Start from the bank, not the books. Take the cleared balance. Subtract cheques issued but not cashed and any pre-authorized debits already in flight.

2. Schedule receipts invoice by invoice for the first six weeks. Do not use average days-sales-outstanding for the near weeks. Name the customer, name the invoice, name the week you actually expect payment based on how that customer has behaved, not on your stated terms.

3. Lay in the fixed outflows. Payroll dates, source deduction remittance dates, rent, insurance, loan payments, software renewals. These are the most predictable numbers in the model and the least negotiable.

4. Add the statutory outflows. GST/HST net tax by reporting period, corporate tax instalments by their due dates, and any payroll source deduction remittance schedule. These get their own rows. Never bury them inside a general expenses line, because the moment they are invisible they stop being planned for.

5. Add variable supplier spend and expense reimbursements. This is where most forecasts fail, and it is covered below.

6. Compute the closing balance and mark the minimum. The number that matters is not the week 13 balance. It is the lowest closing balance anywhere in the thirteen weeks, and the week it occurs.

How do GST/HST remittances and tax instalments wreck a healthy month?

Because they are indifferent to the month. A quarterly GST/HST filer spends three months accumulating tax inside an operating balance that feels like available cash, then owes the net amount shortly after quarter end. The remittance deadline does not care that you hired two people in month three.

Corporate instalments are worse in a downturn. Section 157 of the Income Tax Act requires most corporations to pay tax during the year in instalments computed on the previous year, the year before that, or an estimate of the current year [1]. The CRA instalment guide sets out the options and the conditions under which some small Canadian-controlled private corporations may pay quarterly rather than monthly [4]. A business coming off a strong year and into a weak one is required to fund the strong year's tax out of the weak year's cash, unless it chooses the current-year estimate option and estimates carefully. Under-remit and interest accrues at the prescribed rate, which changes quarterly and should always be read from the CRA page rather than from memory [5]. The mechanics and the choice between calculation options are unpacked in our article on corporate tax instalments for Canadian small business.

The practical move is simple and almost nobody does it: separate the tax. Move the estimated GST/HST net tax and the instalment amount into a second account on a fixed cadence, and forecast against the operating account only. What remains is genuinely yours to spend.

How do unrecorded expense claims distort the picture?

An employee pays for a client dinner, a flight, or a parts run on a personal card. Until that claim is submitted, three things are true at once: the business owes the money, the accounting system does not know, and the forecast shows cash you do not have. When six weeks of claims finally land in one batch, the reimbursement run hits a single week that the model had marked as comfortable.

The distortion is not only in the outflow. The GST/HST on those purchases cannot be claimed as an input tax credit until you hold the supporting information required for the claim, so a claim backlog is also an input tax credit backlog, which is real money delayed. Our input tax credit guide covers the documentation requirements in detail.

This is the cleanest argument for capturing an expense at the moment of purchase rather than at month end. MapleExpense lets the person who spent the money photograph the receipt on the spot and file the claim from their phone, so the liability and the recoverable tax both enter the system on the day they arise instead of in a batch six weeks later. A forecast is only as good as the payables it knows about. If you have not yet set the ground rules for what employees may spend and how fast they must file, start with our employee expense reimbursement policy guide.

How do I keep the forecast honest week to week?

Update it on a fixed day, and start every update with variance: what did I forecast for last week, what actually happened, and why the difference. Variance is the whole point. A forecast that is never compared to reality never improves, and after a quarter of honest variance review most owners can predict their own collections within a few percent.

Two discipline points. First, forecast the outflows you control at the amount you will actually spend, not the amount you hope to. Second, close the books monthly so the forecast is anchored to something real. A rolling forecast sitting on top of books that were last reconciled in March is fiction with a spreadsheet around it. The month-end close checklist is the companion process to this one.

What do I do when the model shows a shortfall?

You have the weeks before the gap to act, which is the only reason the forecast exists. Work the levers in order of least damage: collect the largest overdue receivable, delay discretionary spend already scheduled in the intervening weeks, negotiate a supplier date rather than quietly missing it, and use an operating line you arranged before you needed it.

What not to do is fund the gap with remittance money. Interest on late GST/HST and on late instalments accrues at the prescribed rate [5], and unremitted payroll source deductions expose directors personally. The forecast exists precisely so that the temptation never becomes a decision made at eleven at night with a remittance due the next morning.

Frequently asked questions

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a rolling schedule of every dollar expected to enter and leave a business bank account over the next quarter, listed by the week the cash actually moves rather than the week the sale or expense was recorded. It starts with the real cleared bank balance, adds expected customer receipts by week, subtracts payroll, suppliers, rent, debt payments, GST/HST remittances and tax instalments, and shows the closing balance each week. Thirteen weeks is used because it covers a full quarter of remittance and instalment cycles while still being close enough to forecast individual invoices accurately.

Why is my business profitable but has no cash?

Profit and cash diverge for four common reasons: revenue is recognized when invoiced but collected 30 to 60 days later; GST/HST collected on sales sits in the bank account as if it were revenue but belongs to the Receiver General; capital purchases leave the bank in full while only a portion is deducted as capital cost allowance; and principal repayments on loans consume cash without ever appearing on the income statement. A profitable month with negative cash flow is normal, not a bookkeeping error.

Does GST/HST collected count as my money?

No. GST/HST you charge customers is collected on behalf of the Crown. Under section 228 of the Excise Tax Act you calculate net tax for each reporting period and remit it with your return. Treating collected tax as working capital is one of the most common causes of a cash crisis in a small Canadian business, because the remittance falls due at exactly the moment the cash has already been spent on payroll or inventory.

How do corporate tax instalments affect cash flow?

A corporation that owed more than a small threshold of tax in either of the two prior years generally has to pay its tax in instalments during the year under section 157 of the Income Tax Act, rather than in one payment after year end. Instalments are usually monthly, and some small Canadian-controlled private corporations qualify to pay quarterly. Because instalments are based on prior-year or estimated current-year tax, they keep leaving the bank account even in a slow month when there is little current profit to fund them.

How far ahead should a small business forecast cash?

Thirteen weeks is the practical horizon for operating decisions, updated weekly so the window always rolls forward. Beyond thirteen weeks the individual receipt and payment estimates stop being reliable and a monthly or annual budget is the better tool. Businesses in a genuine cash squeeze usually shorten the first section to a daily view for the next two weeks while keeping the weekly view for the remaining eleven.

Do unsubmitted employee expense claims really matter to a forecast?

Yes. An expense claim that has been incurred on a personal card but not yet submitted is a real liability that is invisible to the accounting system, so it never appears in the forecast until it lands, often several claims at once. It also delays the input tax credit on those purchases, because the GST/HST cannot be claimed until the supporting documentation is in hand. A backlog of unsubmitted claims makes a forecast optimistic in two directions at the same time.

What should I do when the forecast shows a shortfall in week seven?

Act in the weeks before it, not the week of it. The usual levers, in order of how little damage they do: accelerate collection on the largest overdue invoices, defer discretionary spending scheduled in the intervening weeks, shift a supplier payment by agreement rather than silently, and draw on an operating line arranged in advance. Never fund a shortfall by deferring a GST/HST remittance or a payroll source deduction, because those carry interest and, for source deductions, potential director liability.

Sources cited in this article

1. Income Tax Act, s. 157 (corporate tax instalments)
   Sets the obligation for a corporation to pay tax in monthly or, where eligible, quarterly instalments during the year rather than after year end.
   https://laws-lois.justice.gc.ca/eng/acts/I-3.3/section-157.html
2. Excise Tax Act, s. 228 (calculation and remittance of net tax)
   Requires a registrant to calculate net tax for each reporting period and remit any positive amount with the return for that period.
   https://laws-lois.justice.gc.ca/eng/acts/E-15/section-228.html
3. CRA, RC4022 General Information for GST/HST Registrants
   Explains reporting periods, filing and remittance due dates, and how net tax is calculated. Carries the current thresholds for assigned reporting periods.
   https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/rc4022.html
4. CRA, T7B-CORP Corporation Instalment Guide
   The working guide to corporate instalment calculation options, due dates, and the eligibility conditions for quarterly instalments.
   https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/t7b-corp.html
5. CRA, Prescribed interest rates
   The quarterly rates used for arrears and instalment interest. Check here rather than relying on a rate quoted in any article.
   https://www.canada.ca/en/revenue-agency/services/tax/prescribed-interest-rates.html
6. CRA, T4002 Self-employed Business, Professional, Commission, Farming, and Fishing Income
   Covers deductible business expenses and capital cost allowance for unincorporated businesses, including the distinction between a cash outlay and a deduction.
   https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/t4002.html
7. CRA, Keeping records
   The CRA landing page on the books and records obligation, including electronic records and retention periods.
   https://www.canada.ca/en/revenue-agency/services/tax/businesses/topics/keeping-records.html

All sources verified 2026-09-23. Spotted a link that has moved? Email [email protected] and we will correct it.