Most companies that get into trouble are profitable on paper. The problem is not the result but the timing: the supplier invoice is due in 14 days, the customer pays in 60. An annual plan doesn't show that. A weekly forecast does.
Why exactly 13 weeks?
Thirteen weeks are one quarter. The period is short enough to know the numbers quite precisely – open items, salaries, tax dates – and long enough to still react: negotiate a credit line, adjust payment terms, postpone an investment. Banks and restructuring advisers ask for exactly this format in a crisis, because it shows soberly how much time is left.
The structure in four blocks
- Opening balance: balances of all bank accounts at the start of the week.
- Receipts: customer payments from open items (based on actual payment behaviour, not payment terms), expected payments from new orders, other income such as grants or tax refunds.
- Payments: suppliers, wages and salaries, rent, taxes and social security, loan instalments, leasing, planned investments.
- Closing balance and headroom: closing balance of the week plus unused credit line gives the headroom.
| €k | Wk 1 | Wk 2 | Wk 3 | Wk 4 |
|---|---|---|---|---|
| Opening balance | 120 | 134 | 88 | 41 |
| Customer receipts | 65 | 48 | 52 | 90 |
| Suppliers | −38 | −44 | −41 | −35 |
| Wages and salaries | 0 | 0 | −58 | 0 |
| Taxes and social security | −13 | −50 | 0 | −22 |
| Closing balance | 134 | 88 | 41 | 74 |
In the example, week 3 is the critical one: salaries and suppliers coincide, and the balance falls to 41. If the internal minimum reserve is 50, action is needed now – three weeks in advance, not on payday.
Where the numbers come from
The good news: for the first four to six weeks almost all data is already in the system. The accounts receivable and payable lists, payroll and the tax calendar cover most of it. For the weeks after that it gets fuzzier – order backlog, purchase commitments and experience from previous years help here.
Keep it rolling
The value of the forecast comes from routine. Every Monday the past week is replaced with actuals, and a new week 13 is added at the end. After a few weeks you see where your planning is systematically off – and that is the real insight. A small plan-vs-actual comparison per week shows whether you are too optimistic on receipts or too cautious on payments.
Levers when things get tight
- Accelerate receipts: invoice immediately, agree on down payments, chase consistently.
- Stretch payments: use supplier payment terms (weigh early-payment discounts against liquidity), postpone investments.
- Reduce inventory: stock is tied-up money.
- Secure headroom: talk to the bank before things get tight – with the 13-week forecast as the basis.
Common mistakes
- Planning revenue instead of cash receipts.
- Forgetting quarterly payments such as VAT, social security or insurance premiums.
- Calculating only one scenario. A cautious case with 20% lower receipts takes ten minutes and brings a lot of peace of mind.
- Only one person maintains the file. When they are on holiday, there is no forecast.
Conclusion
A 13-week cash flow forecast doesn't need expensive software. It needs a clear structure, honest assumptions and a fixed half hour per week. In return you get something no annual report can deliver: time to act.
Frequently asked questions
What is a 13-week cash flow forecast?
A rolling forecast of all receipts and payments on a weekly basis for the next 13 weeks. It shows early in which weeks liquidity becomes tight.
How often should the cash forecast be updated?
Weekly. The past week is replaced with actuals and a new week is added at the end.
Is Excel enough for liquidity planning?
For most small and medium-sized companies, yes. What matters is a clear structure, clean data sources and a fixed routine.