How much cash will your business actually have in its account on a Friday morning thirteen weeks from now? If you cannot answer that within a few hundred dollars, you are flying your most important instrument blind — and the second half of 2021 is precisely the wrong time to do it. Reopening is uneven, customer demand is recovering at different speeds across sectors, and the federal wage and rent subsidies that propped up so many BC employers are now scheduled to end in late October. A 13-week cash flow forecast is the single most useful tool you can build this month to navigate that transition.
The profit and loss statement tells you whether you are earning a margin. It does not tell you whether you can make payroll on the 15th. Those are different questions, and in a recovery they diverge sharply: you can be profitable on paper and still run dry because a customer pays in 60 days while your suppliers and your staff are paid in days. The 13-week forecast exists to answer the cash question directly.
Why 13 weeks, and why now?
Thirteen weeks is one quarter. It is long enough to capture a full cycle of receivables, payroll runs, rent, GST/PST remittances, and loan payments, yet short enough that you can forecast each week with real granularity rather than guessing a monthly average. Treasury teams at large companies have used the rolling 13-week model for decades during turnarounds; it scales down perfectly for an owner-managed BC business.
The timing matters. As of mid-2021, the Canada Emergency Wage Subsidy (CEWS) and Canada Emergency Rent Subsidy (CERS) are in their final claim periods, both ending October 23, 2021. For many employers that support has been worth real money each four-week period. When it stops, the cash that was quietly filling the gap stops with it. A forecast built now lets you see the cliff before you reach it, while you still have time to act.
What goes into the model
Build it in a spreadsheet with one column per week for 13 weeks. You need three blocks:
- Opening cash — the actual bank balance at the start of week one. Use the real figure, not the accounting balance.
- Cash in — receipts by week: customer collections (timed to when they actually pay, not when you invoice), any remaining subsidy receipts, GST input tax credit refunds, financing draws.
- Cash out — disbursements by week: payroll and source deductions, supplier payments, rent, lease and loan payments, PST and GST remittances, owner draws, tax instalments.
Closing cash for each week becomes the opening cash for the next. The discipline is in the timing. A $40,000 invoice issued today on net-30 terms is not week-one cash; it is week-five cash, and only if the customer is reliable.
A worked example: Coastal Fabrication Ltd.
Consider a fictional but realistic Vancouver Island metal-fabrication shop. It runs payroll of $48,000 every two weeks, pays roughly $22,000 a month in rent and fixed overhead, and has been receiving about $9,000 per CEWS period. Its bank balance today is $61,000.
Scenario A — assuming subsidies continue. Management mentally pencils in the $9,000 every four weeks straight through the quarter and feels comfortable. On that basis the lowest weekly balance over 13 weeks looks like roughly $34,000. Comfortable.
Scenario B — modelling the real October 23 wind-down. Once the forecast reflects that the final CEWS period ends in October and no further subsidy lands, the picture shifts. A large customer is also on net-45 terms, pushing a $58,000 receipt from week six into week eight. The model now shows the balance dipping to about $7,500 in week nine — the week a quarterly PST remittance and a payroll run collide. That is not insolvency, but it is a genuinely tight week that would have been invisible without the forecast.
The value is not the precise number; it is that Scenario B surfaces week nine as the pinch point eight weeks early. With that warning the owner has cheap options: ask the slow-paying customer for partial progress billing, defer a discretionary equipment purchase, or arrange a modest operating line as a backstop. Without the forecast, the same owner discovers the problem on the morning of the payroll run, when every option is expensive.
Layering scenarios onto the base case
A single forecast line is useful; three are powerful. Once your base case is built, copy it into two variants so you can see the range of outcomes rather than a single guess:
- Base case — your honest best estimate of collections, sales, and payments.
- Downside case — what happens if your two largest customers each pay two weeks late and revenue comes in 15% below plan. This is the case that tells you how much liquidity headroom you actually need.
- Stress case — a genuine shock: a major customer pays 60 days late or a key contract slips. You are not predicting this will happen; you are pressure-testing whether the business survives it without emergency financing.
The discipline of scenarios is that it converts anxiety into specifics. "What if things get worse?" becomes "in the downside case we touch $7,500 in week nine and need a $25,000 buffer." That is a number you can plan around, arrange a line of credit against, or design away by tightening terms. Owners who run only a base case are repeatedly surprised; owners who run three are rarely caught off guard, because the bad week was already on the page.
Turning the forecast into action
A forecast that only describes the future is half a tool. Its real value is the menu of levers it lets you pull before a tight week arrives, while each lever is still cheap:
- Accelerate inflows — offer a small early-payment discount to slow-paying customers, switch large jobs to progress billing, or deposit-bill new work.
- Smooth outflows — negotiate longer supplier terms, align large payments away from payroll weeks, and time discretionary spending into cash-rich weeks.
- Pre-arrange a backstop — a modest operating line arranged now, while the Bank of Canada overnight rate sits at 0.25%, is cheap insurance you may never draw.
The forecast tells you which lever to pull and when. Pulling a lever eight weeks early is a routine business decision; pulling the same lever the morning of a missed payroll is an emergency that costs far more.
How to make the forecast trustworthy
A forecast nobody updates is worse than none, because it breeds false confidence. Three habits keep it honest:
- Roll it weekly. Every Monday, drop off the week that just ended, add a new week 13 at the far end, and replace your estimates for the coming weeks with what you now know. The model stays a true 13 weeks ahead at all times.
- Compare forecast to actual. Each week, record what you predicted for cash-in and cash-out against what really happened. If your collections forecast is consistently optimistic by 15%, you learn that and adjust your assumptions. This feedback loop is what turns a guess into a tool.
- Forecast by name for big items. For your ten largest customers and your ten largest payments, forecast each one individually by expected date. Everything else can be a sensible weekly average.
Common mistakes that sink the model
- Recording revenue when invoiced rather than cash when collected. The forecast is about money in the bank, not accruals.
- Forgetting the lumpy outflows — quarterly GST and PST remittances, annual insurance, corporate tax instalments. These are exactly the items that cause the surprise tight weeks.
- Treating the subsidy as permanent. With CEWS and CERS ending October 23, any week-by-week plan that assumes them past that date is fiction.
- Building it once and never opening it again.
Key takeaways
- A 13-week cash flow forecast answers the question your P&L cannot: will the cash be there when each obligation falls due.
- Time every receipt and payment to the week it actually moves cash, not the week it is invoiced or accrued.
- Model the October 23, 2021 end of CEWS and CERS explicitly so the post-subsidy cash gap appears early, while you can still act on it.
- Roll the forecast every week and compare forecast to actual; the feedback loop is what makes it reliable.
- The point is foresight: spotting the tight week eight weeks out turns an emergency into a manageable decision.
Cash flow forecasting is not about predicting the future perfectly — it is about being surprised on paper, in a spreadsheet you control, rather than at the bank.
If your team is rebuilding its cash discipline for the post-subsidy environment, RN Canada's advisory practice helps BC owners stand up rolling forecasts and fractional CFO oversight that turn numbers into decisions. We would be glad to talk it through.