Cash-flow forecast template

What’s inside

Opening balance, receipts, payments, closing balance — month by month.

How to interpret the result

A completed forecast is only useful if the closing balance line is read in context, not in isolation. A single month showing a low or negative closing balance matters less than the trend across several consecutive months — a temporary dip that recovers as receipts land is a very different signal to a closing balance that keeps drifting downward month after month. Directors get more value from watching the direction of travel than from fixating on any one figure.

It also helps to separate timing issues from underlying profitability issues. A forecast can show a cash squeeze even in a business that is fundamentally profitable, simply because payments fall due before the matching receipts arrive. Distinguishing a timing gap from a genuine shortfall in trading performance changes what action is appropriate — one calls for smoothing the timing of cash movements, the other calls for a harder look at pricing, costs or sales volume.

Limitations and good practice

A 12-month forecast is a planning tool, not a guarantee — it is only as reliable as the assumptions behind each month's receipts and payments, and those assumptions should be revisited regularly rather than set once and forgotten. Sense-checking each line against what has actually happened in recent months, and updating the template as soon as new information emerges (a new contract, a slower-paying customer, a change in supplier terms), keeps the forecast useful rather than decorative.

It's also good practice to build in a degree of caution on the receipts side and realism on the payments side, since income tends to be less certain than committed outgoings. Where a company wants a shorter, more operationally focused view alongside this 12-month version, the 13-week cash flow forecast template gives a rolling short-horizon perspective, while the cash flow statement template is useful for separating real cash movements from accounting profit once the year is underway.