A 13 week cash flow forecast gives a weekly view of roughly the next quarter. It is useful when the business needs to manage immediate commitments, uncertain collections or a temporary funding gap. Its purpose is to support decisions before a difficult week arrives.
In this article
- Set out the next 13 weeks
- Enter dated receipts and payments
- Test late receipts and unexpected costs
- Update and extend the forecast weekly
The format is deliberately short-term. Near-term entries should be specific and evidence-based; later weeks can include documented estimates. Keep a longer view alongside it where seasonal spending or major commitments fall beyond the thirteen weeks.
Build a direct cash view
Start with verified available cash and organise actual expected receipts and payments by week. Use debtor and supplier records, payroll plans, finance schedules and confirmed tax dates rather than deriving every line from a profit budget.
List major customer receipts individually. For smaller recurring amounts, group them only where the timing pattern is supported. Separate disputed debt, tentative sales and confirmed collection promises.
Identify payments that cannot be casually moved: scheduled payroll, contractual commitments and approved finance payments. Show proposed renegotiations separately until the relevant party agrees them.
Give uncertainty a visible place
Use a base case and at least one named downside. Record the source and confidence of significant receipts. “Customer says Friday” provides different evidence from “usually pays eventually”.
Keep assumptions understandable:
- Which customer receipts depend on outstanding approval?
- Which costs could increase because work is incomplete?
- Which payment arrangements are agreed, and which are proposals?
- Is any opening cash restricted or unavailable?
- Are facilities usable within their actual conditions?
These questions make the forecast a working tool rather than a spreadsheet that appears certain because it contains exact dates.
Find the first difficult week
Illustrative example: a company’s base case remains positive through week thirteen, but its lowest expected balance is £2,000 in week five. An £8,000 customer receipt included in week five is disputed. If it moves to week eight, week five instead shows a £6,000 shortfall.
The company should focus on that timing risk immediately. The week-thirteen balance does not protect week-five payroll or supplier payments. The figures are invented to show the issue; they are not a funding offer or a solvency assessment.
Ask whether the disputed payment can genuinely be resolved in time. If not, test specific alternatives and their timing. Avoid inserting “extra funding” as a receipt before the facility is agreed and available.
Make an action register beside the forecast
| Action | Evidence needed before relying on it |
|---|---|
| Collect an overdue invoice | Customer confirmation and resolved query |
| Change a supplier payment date | Agreed arrangement, not an internal assumption |
| Defer discretionary spending | Approval and check for cancellation commitments |
| Introduce owner funding | Documented decision, availability and treatment |
| Review finance options | Terms, timing, costs and conditions understood |
Assign each action an owner and completion date before the affected week. Record whether it is proposed, agreed or completed. This avoids several managers counting the same hoped-for improvement.
Review second-order effects. Deferring a stock purchase might preserve cash but prevent delivery of a confirmed order. A collection discount might accelerate a receipt but reduce the project’s return. The forecast should make trade-offs visible.
Update weekly without hiding misses
Replace the completed week with actual movements, reconcile the new opening cash and add a week at the far end. Keep a dated copy before updating.
Explain differences: missing receipts, earlier supplier payments, new costs or inaccurate estimates. A customer payment repeatedly moved forward should be escalated, not treated as routine forecast maintenance.
Hold a short review focused on the next few weeks, the lowest cash point and action progress. Give enough attention to later weeks that a known tax payment or finance maturity does not become a surprise when it enters the immediate horizon.
Recognise when planning alone is insufficient
If the forecast shows obligations the business may not meet, seek professional support promptly. A forecast can identify pressure; it cannot grant permission to ignore commitments or establish that a company is legally solvent.
Provide the adviser with reconciled balances, debts, contracts and current scenarios. EPOS cash flow support can be discussed around maintaining the forecast and evaluating actions. For broader funding and trading decisions, explore outsourced CFO support, with the actual scope agreed rather than assuming every crisis-related task is included.