Cash flow planning
How to Build a 13 Week Cash Flow Forecast for a Small Business
A 13 week forecast tracks expected cash in and out by week from a verified opening balance, and is updated every week against actual bank movement.
By HBT AccountingSources checked 5 min read

Key points
- A 13 week forecast tracks when cash reaches or leaves the bank, not when revenue or expenses appear in the books.
- BDC describes a rolling 13 week forecast as a simple and effective way to preserve cash, using a three month window that is updated every week.
- Start from a reconciled opening balance and place CRA payments, such as payroll remittances, GST/HST and corporate instalments, in the weeks they fall due.
- Each week, replace the finished week with actual cash, explain the largest differences and add a new thirteenth week.
What the forecast shows
A 13 week forecast is a short, rolling view of cash. It starts with the cash available at the beginning of week one. It adds the receipts expected that week, subtracts the payments expected to clear and arrives at an ending balance. That balance becomes the next week's opening balance. BDC's template forecasts a business's cash inflows and outflows over a quarter, and BDC describes the result as a three month window updated at the beginning of every week.
It is not a profit and loss statement, and BDC's cash flow guide points out that profitable companies often face a cash crunch. A sale can be recorded before the customer pays, and an expense can be recorded before the cash leaves the account. Loan advances, principal repayments, tax payments, equipment purchases and owner transactions also move cash differently from profit. BDC tells owners to consider their credit policy and when customers actually pay. Use expected banking dates and mark uncertain amounts instead of treating an invoice date as a payment date.
| Forecast line | What to include | Evidence to review |
|---|---|---|
| Opening cash | Usable bank balances at the start of the week | Reconciled bank records and any restricted cash |
| Customer receipts | Expected collections by likely receipt date | Open receivables, payment terms, customer history and confirmed orders |
| Operating payments | Payroll, suppliers, rent, tax, insurance and other expected outflows | Payables, payroll calendar, contracts, tax accounts and recurring commitments |
| Financing and owner activity | Loan advances or repayments, contributions, withdrawals and approved dividends | Financing agreements, corporate records and authorized plans |
| Ending cash | Opening cash plus receipts less payments | A formula check and a comparison with minimum operating needs |

Dates the CRA sets
Some outflows have fixed dates. Place each one in the week it falls, even if no bill has arrived. Which payroll schedule applies depends on the average monthly withholding amount, so check the remitter type on the CRA account.
The cost of missing a date is known in advance. The CRA charges a 3% penalty on a payroll remittance that is 1 to 3 days late. The rate is 5% at 4 or 5 days, 7% at 6 or 7 days and 10% beyond 7 days or when nothing is remitted. Interest on overdue taxes is a separate charge. A forecast shows when cash will be short, but it does not make deferring a legal payment acceptable.
| Payment | Due date | Note |
|---|---|---|
| Payroll remittances, regular remitter | The 15th day of the next month | Average monthly withholding under $25,000 |
| Payroll remittances, quarterly remitter | April 15, July 15, October 15 and January 15 | Eligible small employers with a perfect compliance record |
| Payroll remittances, accelerated remitter | The 25th of the same month and the 10th of the next month | Average monthly withholding from $25,000 to under $100,000 |
| GST/HST, monthly or quarterly filer | One month after the reporting period ends | Payment is due on the same date as the return |
| GST/HST, annual filer | Three months after the fiscal year end, for most businesses | Filing and final payment share the date |
| Corporate tax instalments, monthly | The last day of each month for a calendar year corporation | The first payment falls one month less a day after the tax year starts |
| Corporate tax balance due | Two months after year end, or three months for some CCPCs | The T2 return itself is due six months after year end |
Building the first version
Start with reconciled bank balances and a list of every account. Review receivables by customer and use a realistic collection date based on terms, disputes and payment history. Review payables by due date. Then add obligations that may not appear in payables, such as payroll, source deductions, GST/HST, corporate tax instalments, debt payments, rent, subscriptions and planned equipment purchases.
Build a base case first. BDC suggests projecting optimistic, most likely and pessimistic scenarios. For a weekly forecast, one downside case is usually enough. It might assume slower collections, lower sales, a delayed project or an unexpected repair. A scenario helps only when the assumption and the management response are written beside it. Do not force a positive ending balance with unsupported optimism.
- Confirm every bank and credit facility balance before week one.
- List receipts by expected collection date, not invoice date alone.
- Capture payroll, tax, debt, supplier and recurring obligations even when no bill has arrived.
- Separate committed, probable and optional payments where the distinction helps a decision.
- Record the source and owner of every material assumption.
- Trace a sample of totals back to records before relying on the result.
A weekly routine
At the start of each week, replace the finished week's estimates with actual cash movement. Explain the largest differences and add a new thirteenth week. Repeated collection delays, cost overruns or missed obligations are management signals, not spreadsheet noise. Assign follow up actions and carry them into the next review.
The forecast should support a decision before cash becomes critical. Possible responses include faster billing, resolving disputed invoices, changing purchase timing, cutting optional spending, discussing financing early or revising the operating plan. Contracts, tax obligations and employment duties limit these choices.
Quick answers
What is a 13 week cash flow forecast?
It is a week by week projection of cash receipts, payments and bank balance for the next three months. BDC describes it as a rolling window that is updated at the beginning of every week.
How is a cash flow forecast different from a profit and loss statement?
A profit and loss statement follows when revenue and expenses are recorded. A cash forecast follows when money is expected to reach or leave the bank, which can be weeks later.
Which CRA payments belong in the forecast?
Payroll remittances, GST/HST payments, corporate tax instalments and any balance due. The CRA sets the due date for each, and a payroll remittance that is 1 to 3 days late draws a 3% penalty.
How often should the forecast be updated?
Every week. Replace the finished week with actual bank movement, explain the largest differences and add a new thirteenth week.
What if the books are not current enough to build one?
Reconcile the bank, receivables, payables, payroll, tax and debt records first. A forecast built on an unverified opening balance carries the error into every later week.
Related pages
Official sources
Call or email and we will tell you which records we need and what the work costs, in writing, before anything starts.
Important. This article provides general educational information, not legal or tax advice for a specific business. Rules, administrative policies, rates and deadlines can change. Confirm your facts and current obligations with the responsible government agency and a qualified adviser.