Restructuring · Liquidity
The 13-week cash flow forecast: from spreadsheet to decision rhythm
A useful short-term cash forecast does not try to predict the whole business perfectly. It makes receipts, payments, assumptions and accountability visible soon enough to act.
Key takeaways
- Use direct cash receipts and payments by week.
- Start from bank balances that reconcile.
- Distinguish committed, probable and unsupported cash.
- Update actuals and forecast variance every week.
- Assign an owner to every material assumption and action.
Why thirteen weeks
Thirteen weeks is long enough to show payroll, tax, debt-service and supplier peaks but short enough to forecast at payment-level detail. It complements—not replaces—the annual budget, integrated financial model and statutory cash-flow statement.
The model should answer when the lowest cash point occurs, what drives it, which payments are critical, which actions are controllable and when additional funding or specialist advice is required.
Core structure
| Block | Examples | Control |
|---|---|---|
| Opening liquidity | Bank balances and available committed facilities | Reconcile to evidence |
| Receipts | Customer collections, asset proceeds, committed funding | Probability and owner |
| Operating payments | Payroll, suppliers, rent, logistics, technology | Due date and criticality |
| Other payments | Tax, debt service, capex, professional costs | Legal and contractual status |
| Closing liquidity | Opening plus net movement | Minimum headroom |
Build it in five passes
- 01
Reconcile the opening position
Map every bank account, restricted balance and committed facility.
- 02
Construct the receipts schedule
Use invoice- or customer-level evidence for material collections and avoid treating overdue amounts as certain.
- 03
Construct the payments schedule
Capture due dates, payment runs, taxes, payroll, debt and essential operating commitments.
- 04
Create scenarios and actions
Keep the base view separate from measures such as accelerated collections, negotiated terms or new funding.
- 05
Install weekly governance
Lock actuals, explain variance, refresh assumptions and record decisions on the same day each week.
Signals that require escalation
- The downside case crosses minimum liquidity headroom.
- A material receipt has no accountable owner or evidence.
- Tax, payroll, regulated obligations or critical suppliers may not be paid when due.
- The plan depends on funding that is not committed.
- Management lacks the authority or operating capacity to implement the assumed measures.
What the model must not do
A 13-week forecast is not a legal insolvency assessment and should not delay qualified advice. It should not hide uncertainty by forcing every line into one confident case. Its value lies in a common, current basis for decisions.
The weekly process, ownership rules and escalation tests in this guide are practitioner methodology. IAS 7 provides financial-reporting context; ICAEW and Turnaround Management Association materials support the use of short-term direct cash forecasting and variance discipline in stressed situations.
Frequently asked questions
Should the model be weekly or daily?
Weekly is usually the governing view; a daily schedule may be necessary around an immediate liquidity event or concentrated payment run.
Is the indirect cash-flow method enough?
Not for short-term payment control. A direct receipts-and-payments view is normally more actionable at thirteen weeks.
How often should it be updated?
At least weekly, with actual-versus-forecast variance and a consistent cut-off. Acute situations may require more frequent cash calls.
Sources
- ICAEW: Liquidity management for businesses at times of stress
- Turnaround Management Association: 13-week cash-flow forecasting
- IFRS Foundation: IAS 7 Statement of Cash Flows
General information only. This content is not legal, tax or investment advice. Specialist legal and tax advisers may be required for a transaction or restructuring.