Free template · CSV download · No sign-up
The 13-week cash-flow forecast, done properly
A weekly, cash-basis view of the next quarter: what comes in, what goes out, and where the operating line sits at the end of every week. This is the near-term liquidity tool Canadian lenders expect, and the one most borrowers have never built.
What is a 13-week cash-flow forecast and why do lenders ask for one?
It is a weekly projection of cash in and cash out over one quarter, built on when money actually moves rather than when revenue is earned. Lenders ask for it because covenants are breached in cash, not in accruals: the forecast shows whether payroll, remittances and debt service can be met without exceeding the operating line.
Structure
The eleven lines that belong in it
Columns are weeks. Rows are these. Anything more elaborate usually reduces the frequency with which it gets updated.
| Line | How to populate it | Where files go wrong |
|---|---|---|
| Opening cash | Closing balance from the prior week | Must tie to the bank, not the ledger |
| Receipts from customers | By customer where material, based on observed payment behaviour | Not invoice terms — actual days to pay |
| Other receipts | Tax refunds, asset sales, shareholder injections | Flag anything non-recurring |
| Payroll and source deductions | Actual pay dates, including the remittance | A common omission |
| Trade payables | By vendor, on the date you intend to pay | Show stretched terms honestly |
| GST/HST and other remittances | On the filing calendar | Arrears rank ahead of most lender security |
| Debt service | Every facility, on its payment date | Include leases treated as debt |
| Capital expenditure | Committed spend only | Discretionary items shown separately |
| Net cash movement | Receipts less disbursements | — |
| Operating line drawn / available | Position against the authorized limit | The line most lenders read first |
| Closing cash | Carried to the following week | — |
Method
Four steps, then a weekly habit
Anchor to the bank
Open from the actual bank balance and the authorized operating line. If it does not tie to the bank, nothing downstream is credible.
Forecast receipts on behaviour
Use observed days-to-pay by customer, not stated terms. A customer on net 30 who consistently pays in 52 days belongs in week eight.
Schedule every outflow
Payroll and source deductions, GST/HST, trade payables by vendor, debt service, leases, insurance, property tax, committed capex.
Roll it weekly
Enter actuals, explain variance against forecast, extend one week. Three months of accurate variance is a genuine credibility asset with a lender.
Questions people ask
13-week forecasting, answered directly
What is a 13-week cash-flow forecast?+
A 13-week cash-flow forecast is a weekly projection of cash receipts and disbursements covering one quarter, built from actual expected timing rather than accrual accounting. It shows the closing cash and operating-line position at the end of each week, so liquidity pressure appears weeks before it reaches the bank account.
Why 13 weeks?+
Thirteen weeks is one quarter — long enough to capture payroll cycles, remittances, seasonal collections and a debt payment or two, but short enough that the assumptions are grounded in known invoices and commitments rather than forecast revenue. It is the standard horizon in lending, restructuring and treasury practice.
Why does a lender ask for one?+
Because financial statements report the past on an accrual basis, and covenants are breached on a cash basis. The forecast tells an adjudicator whether the business can meet payroll, remittances and debt service over the next quarter without exceeding its operating line, and whether the requested facility is sized correctly.
How is it different from a budget?+
A budget is annual, accrual-based and organized by department. A 13-week forecast is weekly, cash-based and organized by when money actually moves. A profitable month in the budget can still be a negative cash week once collections lag and a quarterly remittance lands.
How often should it be updated?+
Weekly, rolling forward one week each time, with the prior week's actuals compared against the forecast. The variance analysis is the valuable part: it shows whether your collection assumptions are realistic, which is exactly what a lender wants to see demonstrated over time.
What are the most common mistakes?+
Forecasting collections on invoice terms rather than customer behaviour, omitting GST/HST and payroll remittances, forgetting annual or quarterly items such as insurance and property tax, and never comparing forecast to actual. The last one is what removes credibility with a lender.
This page is educational and does not constitute accounting, tax or legal advice. Treatment of specific items should be confirmed with your accountant.
Related: receivables and collection behaviour, covenant headroom monitoring, and the Capital Health Monitor.
A forecast is only useful if someone maintains it.
The Capital Health Monitor keeps the rolling forecast, covenant calculations and early-warning indicators current every month.
Request a Confidential Capital Review