Cashflow Forecasting for Clients

A forecast is not a budget

A budget tells a client what they hope to earn and spend over a year; a cash forecast tells them what will actually be in the bank, week by week, in the near term. The difference matters because a business does not fail when it misses budget — it fails when it cannot pay wages on Friday.

A short-term cash forecast answers exactly that question. It lists the cash expected in and out over the coming weeks and shows the running balance, so the client can see a shortfall before they hit it rather than after. For advisers, it is the single most direct way to convert accounting data into a decision the owner can act on this week.

The thirteen-week rolling forecast

A thirteen-week horizon — roughly a quarter — is the practical sweet spot: long enough to see trouble coming, short enough to forecast with confidence. Each week lists expected receipts, expected payments, and the closing bank balance carried into the next week.

Make it rolling: at the end of each week, drop the week just gone and add a new week at the far end, updating actuals as they land. This keeps the forecast honest and turns it into a living instrument rather than a one-off spreadsheet. The discipline of updating it weekly is where most of the value sits, because it surfaces small variances before they compound.

Modelling receivables honestly

The receipts line is where forecasts most often go wrong, because owners enter invoices on their due date rather than the date they realistically expect payment. A customer who always pays at sixty days should be forecast at sixty, not thirty, however the invoice reads.

Use the client's own debtor-days history to phase expected receipts, and discount or delay any balances already aged past terms. The Merion calculator suite can sense-check the cash impact of those payment patterns, so the forecast reflects how customers actually behave rather than how the client wishes they would. A simple habit helps here: forecast each significant customer at their own historical payment behaviour, and treat anything already overdue as cash that may not arrive within the horizon at all.

Acting on what it shows

A forecast earns its keep when it triggers action ahead of a squeeze. A projected shortfall three weeks out is a problem with options — accelerate collections, defer a discretionary payment, arrange finance — whereas the same shortfall discovered on the day is a crisis.

The discipline is to treat each forecast shortfall as a decision point rather than a prediction to be endured. Where the forecast shows the gap is driven by overdue accounts, recovering them is the most direct fix. A client can refer an aged debt without upfront cost at refer a debt, bringing forecast cash forward into the bank. This is general information, not advice tailored to a client.