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

A florist working at the counter of a shop filled with plants

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.
One

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.

Core lines in a practical 13 week cash flow forecast. Method as described by BDC, read November 2026.
Forecast lineWhat to includeEvidence to review
Opening cashUsable bank balances at the start of the weekReconciled bank records and any restricted cash
Customer receiptsExpected collections by likely receipt dateOpen receivables, payment terms, customer history and confirmed orders
Operating paymentsPayroll, suppliers, rent, tax, insurance and other expected outflowsPayables, payroll calendar, contracts, tax accounts and recurring commitments
Financing and owner activityLoan advances or repayments, contributions, withdrawals and approved dividendsFinancing agreements, corporate records and authorized plans
Ending cashOpening cash plus receipts less paymentsA formula check and a comparison with minimum operating needs
A smiling designer on the phone at her studio desk
Two

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.

CRA due dates to place in the forecast. Sources: CRA, When to remit (pay); CRA, Reporting requirements and deadlines for GST/HST; CRA, Due dates for corporate income tax payments. Read November 2026.
PaymentDue dateNote
Payroll remittances, regular remitterThe 15th day of the next monthAverage monthly withholding under $25,000
Payroll remittances, quarterly remitterApril 15, July 15, October 15 and January 15Eligible small employers with a perfect compliance record
Payroll remittances, accelerated remitterThe 25th of the same month and the 10th of the next monthAverage monthly withholding from $25,000 to under $100,000
GST/HST, monthly or quarterly filerOne month after the reporting period endsPayment is due on the same date as the return
GST/HST, annual filerThree months after the fiscal year end, for most businessesFiling and final payment share the date
Corporate tax instalments, monthlyThe last day of each month for a calendar year corporationThe first payment falls one month less a day after the tax year starts
Corporate tax balance dueTwo months after year end, or three months for some CCPCsThe T2 return itself is due six months after year end
Three

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.
Four

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.

Five

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.

Six

Related pages

Official sources

  1. BDC: Cash flow calculator
  2. BDC: 4 key steps to plan your cash flow in the coming year
  3. BDC: Taking Control of Your Cash Flow - Free Guide
  4. CRA: When to remit (pay)
  5. CRA: Reporting requirements and deadlines - File your GST/HST return
  6. CRA: Due dates for payments - Corporate income tax payments

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.