Most business owners' eyes glaze over the moment a spreadsheet full of numbers lands in their inbox labelled “cashflow forecast.” That's a shame, because a forecast is one of the most useful things you can look at — it's the difference between finding out about a cash problem three months before it happens and finding out on the day it happens. You don't need to be a numbers person to read one properly. You just need to know what to actually look at.
What a cashflow forecast is actually for
A forecast isn't trying to predict your profit. Profit and cash are different things, and it's entirely possible to be profitable on paper while running out of money in the bank — because cash gets tied up in stock, unpaid invoices, or a tax bill landing at an awkward moment. A cashflow forecast is specifically about timing: when money is actually expected to come in and go out, month by month, so you can see where the gaps might open up before they do.
The three numbers that matter
Ignore the detail for a moment and look for three things: the opening balance for each month, the closing balance, and the lowest point the balance is expected to hit within that month. The closing balance tells you where you'll end up. The lowest point tells you whether you'll actually get there without running short somewhere in between — which matters, because a healthy month-end balance can still hide a genuinely tight week or two in the middle of the month.
A useful forecast is usually built from three moving parts: confirmed income already invoiced, expected income you're reasonably confident about, and fixed outgoings like rent, salaries and loan repayments that happen regardless of how trading goes. Separating those out matters, because it shows you how much of your forecast is solid ground and how much is an assumption that could still move.
Reading the trend, not just the total
A single month's number tells you very little on its own. What matters is the direction over several months. Is the closing balance broadly stable, climbing, or steadily eroding? A forecast that shows cash quietly shrinking month after month is telling you something important, even if none of the individual months look alarming in isolation. Catching that trend early is the entire point — it gives you months of runway to act, rather than weeks.
Where forecasts usually go wrong
The most common mistake is treating a forecast as a one-off document rather than something that gets updated. A forecast built in January and never touched again is only ever going to be as accurate as the assumptions you made in January — and those assumptions are usually wrong within a few weeks, in one direction or another. The forecasts that are actually useful get revisited regularly against what's really happened, so the picture stays current rather than becoming a work of fiction by month three.
The other common issue is being too optimistic on timing — assuming invoices get paid exactly on their due date, when in reality a portion always lands late. Building in a realistic buffer for late payment, rather than the payment terms you wish applied, makes the forecast far more useful when it matters.
Who should actually be looking at it
A forecast that only the accountant ever sees isn't doing its job. It's genuinely most useful in the hands of whoever's making the day-to-day calls in the business — deciding whether to place a big order, whether now's the right time to hire, or whether a supplier payment can wait a week. That doesn't mean you need to build it yourself from scratch. It means understanding it well enough to act on it, which is a very different bar to being able to construct one in a spreadsheet.
Making it a habit, not a one-off
A forecast is only valuable if someone's actually looking at it regularly and using it to make decisions — whether that's holding off on a purchase, chasing a debtor a little harder, or timing a tax payment around when cash is genuinely available. This is exactly the kind of thing we build into management accounts — regular cashflow reporting alongside profit and loss, so you're seeing where things are heading every month rather than finding out after the event. If your current view of cashflow is a spreadsheet nobody's opened since it was built, that's worth fixing before it becomes a bigger problem than it needs to be.