What Is a 13-Week Cash Flow Forecast?
Key Takeaways
- A 13-week cash flow forecast tracks weekly cash inflows and outflows for a rolling quarter.
- It is the standard tool for managing liquidity in tight cash situations.
- Weekly granularity reveals timing mismatches that monthly forecasts miss.
- It should be updated weekly as actual data replaces estimates.
Why 13 weeks?
A 13-week cash flow forecast covers a rolling 13-week period — exactly one quarter — on a week-by-week basis. The 13-week horizon is long enough to see significant cash events coming (a large VAT payment, a loan repayment, a seasonal trough) while being short enough that the weekly estimates are sufficiently accurate to act on. It is the standard cash management tool used by turnaround advisors, lenders, and CFOs when a business is under cash pressure, and it is equally valuable as a routine discipline for any SME operating with limited liquidity headroom.
What goes into a 13-week forecast
The forecast lists every expected cash inflow and outflow, week by week. Inflows include customer receipts (not invoices raised — actual cash expected in the bank), any loan drawdowns, and asset disposals. Outflows include supplier payments, payroll, rent, tax payments (PAYE, VAT, corporation tax), debt service, and any capital expenditure. The forecast calculates the net cash movement each week and the cumulative cash balance, revealing the low-water mark — the lowest your cash balance will reach — and when it will occur.
Managing the low-water mark
The low-water mark is the most important number in a 13-week forecast. If the lowest projected cash balance is uncomfortably close to zero — or goes negative — you need to act before that point arrives, not after. Options include accelerating customer collections, delaying discretionary payments, drawing on an overdraft facility, or arranging short-term financing. The value of the 13-week forecast is that it gives you several weeks of advance warning, which is enough time to take corrective action if you respond promptly.
Keeping the forecast accurate
A 13-week forecast is a living document. Each week, replace estimates with actuals for the week just passed, add a new 13th week to maintain the rolling horizon, and update the remaining weeks based on any new information — a large customer paying early, a supplier extending terms, a new order received. Track forecast accuracy as a discipline: if your weekly receipts consistently differ from estimates, the issue may be in how you are predicting payment timing from customers, which is itself a valuable insight into your receivables management.