A weekly cash flow forecast is a short-term liquidity planning tool, typically covering 13 weeks. Done well, it is one of the most useful tools a finance team can maintain. Done poorly, it creates a false sense of security at exactly the wrong moment.

The most common failure is overstating available cash. This is almost never deliberate — it is driven by three specific and recurring blind spots.

1. Timing receivables as booked, not as collected

When a sale is made, the revenue is recognized and the receivable appears on the balance sheet. Many forecasts treat this as cash — but it isn't. Cash arrives when the customer pays, not when the invoice is issued.

The gap between invoice date and collection date is your actual exposure. For companies with net-30 or net-60 terms, this gap can represent weeks of overstated liquidity. If your largest customer habitually pays on day 45 against net-30 terms, your forecast needs to reflect that — not the contract terms.

The fix is simple: build your receivables forecast from historical collection patterns, not invoice dates. Segment by customer if collection behavior varies significantly across your book.

2. Treating government receivables as reliable cash

SR&ED credits, grants, and government subsidies appear on the balance sheet as receivables. They are real — but they are not liquid. The timing of these receipts is notoriously difficult to predict, and the amounts are sometimes adjusted during review.

Including government receivables in a 13-week cash forecast at face value and expected timing is one of the fastest ways to create a cash crisis. These should be modeled conservatively — or excluded from short-term forecasts entirely — with a separate longer-range view for when and how much to expect.

3. Missing the payroll and payables lag

Payroll is typically the largest weekly or bi-weekly cash outflow in a growing company. It is also predictable. Yet it is frequently underweighted in forecasts because it is entered as a monthly aggregate rather than mapped to actual pay dates.

The same applies to accounts payable. If your forecast shows average monthly payables outflow divided by four, it is almost certainly wrong. Supplier payment terms, early payment discounts, and the timing of large vendor invoices all create real cash flow asymmetry that a smoothed weekly average will miss entirely.

What a reliable forecast actually looks like

A useful 13-week cash flow forecast is built from the bottom up — not from the income statement down. It maps specific expected inflows against specific expected outflows, week by week, with clear assumptions documented for each major line.

It is reviewed weekly, updated as actuals come in, and used as a decision-making tool — not a reporting artifact. If your forecast is accurate to within 5% over a rolling 13-week period, it is working. If it regularly surprises you, the model needs to be rebuilt, not adjusted.