Cash-Flow Forecasting for Creditors

Why cash-flow forecasting is different from your P&L

A profit and loss statement works on the accruals basis: revenue is recognised when the invoice is raised, and an expense is recognised when it is incurred. This is correct for measuring profitability — but it can be dangerously misleading when it comes to cash. A business can be technically profitable and simultaneously unable to pay its own bills, because the income it has "earned" has not yet arrived in the bank.

A cash-flow forecast models timing: not when revenue is earned, but when cash actually changes hands. For a credit-granting business, the gap between those two events — between issuing an invoice and receiving payment — is exactly where financial distress lives.

Understanding this distinction is not a bookkeeping technicality. It is the foundation of solvent business management. Many small business insolvencies are caused not by unprofitability but by a failure to manage the timing of cash flows.

Building a 13-week rolling forecast

The 13-week rolling forecast is the standard tool for working-capital management. Thirteen weeks corresponds to one financial quarter and gives you enough forward visibility to take corrective action before a gap becomes a crisis. "Rolling" means you update it weekly — as each week closes, you add a new week at the far end, so you always have 13 weeks of visibility ahead.

A basic forecast layout has the following columns for each week: the week commencing date; invoiced amounts (new invoices raised that week); expected receipts (the cash you expect to receive, based on when existing invoices are likely to be paid); actual receipts (filled in as the week closes); and the variance between expected and actual.

The critical column is expected receipts. This is where your accounts receivable ageing data feeds directly into your forecast. Each outstanding invoice gets assigned to a week based on when you realistically expect it to be paid — not when it is due, but when it is likely to arrive.

Modelling payment behaviour

To assign realistic expected receipt dates, you need to understand your actual customer payment behaviour — not what your terms say, but what your history shows. If your terms are Net 30 but your average customer pays at 45 days, your forecast must reflect 45 days, not 30.

A simple approach is to apply probability weights to your outstanding invoices based on their age. By way of illustrative example only: for a 30-day invoice, you might expect 70% to be received on time, 20% within 60 days, 8% within 90 days, and 2% ultimately written off. These numbers will differ for every business — the right weights for your forecast come from your own ageing history, not a generic rule. Look at the last 12 months of your accounts receivable data and calculate what percentage of invoices at each age bracket were ultimately collected, and at what typical lag.

Once you have your weights, applying them across your debtor ledger gives you a probabilistic cash-flow picture: not an exact prediction, but a realistic estimate that accounts for the fact that not every invoice will be paid on time.

Stress-testing the forecast

A forecast that only models the expected case is incomplete. Stress-testing means asking: what if my assumptions are wrong in a bad direction?

A useful stress test is to model the impact of your top three customers each paying 30 days later than expected. For most small businesses, the top three customers represent a significant share of total receivables. If all three slip simultaneously — which is possible in an economic downturn or sector-specific difficulty — the cash impact may be severe. Running this scenario through your forecast lets you see how large the gap would be and prompts you to ask what you would do about it: draw on a credit facility, reduce your own expenditure, accelerate collection from other debtors, or some combination.

Other useful stress tests: what if your bad-debt rate doubles? What if a customer currently 60 days overdue pays nothing in the next 30 days? Stress-testing is not about predicting disaster — it is about being prepared to respond.

DSO: the key metric linking your forecast to credit control

Days Sales Outstanding (DSO) measures how long, on average, it takes you to collect your receivables. The formula is: DSO = (accounts receivable balance ÷ total credit sales) × number of days in the period. For example: if your AR balance is $90,000 and your credit sales over the last 90 days were $270,000, your DSO is ($90,000 ÷ $270,000) × 90 = 30 days.

A DSO close to your stated payment terms is healthy. If your terms are Net 30 and your DSO is 30, you are collecting well. If your terms are Net 30 and your DSO is 55, you are giving your customers an additional 25 days of free credit — and your cash-flow forecast will reflect that gap as a persistent shortfall.

Track DSO monthly and trend it over time. A rising DSO is one of the earliest indicators that your credit control is slipping. It will show up in your forecast as a widening gap between expected and actual receipts long before individual large debts become visible problems.

Using forecast data to drive credit decisions

A cash-flow forecast is not just a financial reporting exercise — it is a credit control tool. When your forecast shows an upcoming shortfall, the right response is to review your ageing report immediately and act on any accounts that are 30 days or more overdue. Do not wait for the shortfall to arrive. The time to chase a 30-day debt is before the cash gap opens, not after.

If the forecast shows a surplus — more cash expected than needed — this is also useful information. It may give you the confidence to offer a customer a short-term extension without endangering your own position, or to invest in growth without straining working capital.

The forecast and the ageing report should be reviewed together, ideally weekly. They are two views of the same underlying problem: the timing gap between delivering value and receiving payment.

Related tools and resources

• Free calculators at tools.merion.com.au — late payment cost, recovery ROI, and net recovery estimator
• Credit Control Playbook — Merion's full guide to proactive receivables management