How to Build a 13-Week Cash Flow Forecast for a Small Business
A readable, evidence-based process for creating and maintaining a rolling 13-week cash-flow forecast using actual cash timing, documented assumptions, and regular variance review.
Quick answer
What Calgary business owners should know
- A 13-week forecast tracks when cash is expected to enter and leave the bank, not merely when revenue or expenses appear in accounting reports.
- Begin with the verified opening cash balance, then list expected receipts and payments by week using supportable timing assumptions.
- Keep operating cash separate from financing, owner contributions, and transfers so management can see what is driving the result.
- Update the forecast every week, compare forecast to actual cash movement, and revise assumptions rather than preserving an outdated plan.
What the forecast should show
A 13-week forecast provides a short, rolling view of liquidity. It begins with cash available at the start of the first week, adds cash expected to be received, subtracts payments expected to clear, and calculates the ending balance. That ending balance becomes the next week's opening balance. The purpose is to identify timing pressure early enough for management to respond.
This forecast is not the same as a profit-and-loss statement. A sale can be recorded before a customer pays, and an expense can be recognized before cash leaves the account. Loan proceeds, principal repayments, tax remittances, equipment purchases, and owner transactions may also affect cash differently from reported profit. Use actual expected banking dates and label uncertain amounts rather than 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 limitations |
| 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 dividends when approved | Financing agreements, corporate records, and authorized plans |
| Ending cash | Opening cash plus receipts less payments | Formula check and comparison with minimum operating needs |
Build the first version from reliable records
Start with reconciled bank balances and a complete list of accounts. 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 service, rent, subscriptions, and planned capital purchases.
Create a base case first. Then add a clearly labelled downside case for material uncertainties, such as slower collections, lower sales, a delayed project, or an unexpected repair. A scenario is useful only when the assumption and the management response are visible. Do not use unsupported optimism to force a positive ending balance.
Practical checklist
- Confirm every bank and credit facility balance before week one.
- List cash 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.
- Document the source and owner of every material assumption.
- Test formulas and trace a sample of totals back to records before relying on the result.
Turn the schedule into a weekly management habit
At the start of each week, replace the completed 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 may include accelerating billing, resolving disputed invoices, changing purchase timing, reducing optional spending, discussing financing early, or revising the operating plan. These choices depend on contracts, tax obligations, employment responsibilities, and the business's facts; a cash forecast does not authorize management to defer a legal obligation.
- What if the books are not current enough to build the forecast?
Begin by reconciling the bank, receivables, payables, payroll, tax, and debt records needed for the opening position. HBT Accounting can help define a practical cleanup and forecasting sequence rather than projecting from incomplete balances.
Review HBT Accounting's bookkeeping support
Official sources
This guide was prepared from the official sources below. Open them to verify the current rule and review exceptions relevant to your situation.
