Building a 13-week cash flow forecast

Most finance teams steer on the annual budget and the monthly figures. For profit that works fine. For cash it doesn't. Cash moves by the week, sometimes by the day, and an annual budget hides exactly that. This is why the 13-week cash flow forecast is the single most useful instrument a growing company can have. It shows whether you can meet your obligations over the next three months, and when it gets tight.

Why 13 weeks, not 12 months

Thirteen weeks is one quarter. Long enough to see financing needs and seasonal effects coming, short enough to stay reliable week by week. A 12-month projection is useful for planning, but too coarse to steer on: the timing of a large receivable or a VAT payment disappears into a monthly total. The 13-week forecast works precisely on that timing.

It is also a rolling instrument. Each week one week drops off and a new one is added. That keeps you looking a quarter ahead at all times, and lets you spot deviations while you can still act on them.

What you need

No expensive tooling. A well-structured spreadsheet is enough to start. What you do need:

• →Your current bank balance as a starting point, per account
• →Expected inflows with realistic timing: open receivables plus new sales, not on invoice date but on expected payment date
• →Expected outflows: salaries, suppliers, rent, taxes (VAT, payroll tax), interest and repayments
• →A fixed update rhythm: one set moment each week to refresh the forecast

Building it step by step

Put the 13 weeks side by side in columns. Start each week with the expected opening balance, add expected inflows, subtract expected outflows, and the closing balance becomes the opening balance of the next week. Group the lines logically: inflows, payroll, suppliers, taxes, financing. Keep it readable; not every cost line needs its own row.

The craft is in the timing, not the amounts. A customer with 30-day terms who structurally pays on day 45 goes in week six, not week four. A quarterly VAT payment goes in the actual payment week. The more honest you are about when money really comes in and goes out, the more useful the forecast.

The mistakes to avoid

• →Overly optimistic receivables timing: use your real average payment term, not the agreed one
• →Forgetting inventory and purchasing: in a growing business cash often leaks into stock before revenue arrives
• →Underestimating taxes: VAT and payroll tax are large, predictable outflows, put them in from the start
• →Not updating the forecast: a 13-week forecast you build once is worthless, the value is in the weekly rhythm

From forecast to action

A forecast is not an end in itself. The value appears when you act on it. If you see a dip below zero seven weeks out, you still have time now: collect a receivable faster, move a payment, draw on a credit line or arrange financing. Work with a few scenarios, a cautious one and an expected one, so you know how much margin you have.

In practice this is exactly what makes the difference between a company that is profitable on paper yet collapses, and one that can carry its growth. See how that played out in the case Profit is opinion, cash is reality.