Mon – Sat: 9:00 AM – 7:00 PM IST
Finance

Cash flow forecasting

Two methods answering two different questions — and the receipt assumptions that decide whether either is right.

In short

Direct cash flow forecasting builds from expected receipts and payments over a short horizon, typically thirteen weeks. Indirect forecasting derives cash from projected profit adjusted for working capital movement, over longer periods. Short-term liquidity needs the direct method; planning uses the indirect.

Why It Matters

Why this matters in practice

A short-term forecast is only as good as its assumption about when customers actually pay. Using invoice terms rather than observed payment behaviour produces a forecast that is consistently optimistic by however many days your customers habitually run late — and that error compounds across every week in the horizon.

Direct method answers whether cash covers the next thirteen weeks
Indirect method supports annual planning and funding decisions
Receivables ageing and payment history are the critical inputs
Variance analysis is what makes the next forecast better
How It Works

How it works in practice

Open receivables

Invoice by invoice with due dates, aged, and adjusted by observed payment behaviour per customer rather than by stated terms.

Open payables

Due dates and your own payment runs. Discretionary timing is a lever the forecast should show explicitly.

Committed outflows

Payroll, tax, loan repayments, rent — the fixed, dated items that anchor the forecast.

Rolling horizon

Thirteen weeks is the common convention, rolled forward weekly so the near term is always detailed.

Variance review

Forecast against actual each week. Persistent bias means an assumption is wrong and can be corrected.

Worked example

A worked example: a thirteen-week forecast that was wrong in a useful way

A business builds a thirteen-week direct cash forecast. In week one it is accurate within two percent. By week six the variance is nineteen percent, and the instinct is to conclude that forecasting does not work here.

Examining the variance by line shows something more useful. Payments are forecast accurately throughout, because the business controls them. Receipts are accurate for two weeks and then degrade sharply, because the forecast assumes customers pay on terms and in practice a group of them consistently pays fifteen to twenty days late.

Re-forecasting receipts on actual historical payment behaviour per customer rather than on contractual terms cuts the week-six variance to around six percent. This is the general lesson: forecast variance is information about which assumption is wrong, not evidence that forecasting is futile. A forecast nobody compares against actuals never improves, which is why most abandoned forecasting exercises were abandoned before the second iteration.

Key terms

The vocabulary, briefly

Term What it means
Direct forecast Built from expected receipts and payments. Accurate short-term, laborious long-term.
Indirect forecast Derived from projected profit and balance sheet movements. Better for longer horizons.
Rolling forecast Continuously extended rather than fixed to a period end.
Forecast variance Actual against forecast, which is the only way the forecast improves.
Headroom Available facility plus cash, which is what determines whether a gap is a problem.
What Goes Wrong

Common mistakes worth avoiding

Due dates used as payment dates

Customers pay on their behaviour, not your terms. Use observed days-to-pay per customer.

No variance review

Without it the same optimistic assumption is repeated indefinitely.

One payment profile for all customers

Large and small customers pay very differently. Segment them.

Ignoring tax and payroll timing

These are the largest dated outflows and the ones that cause the squeeze when mistimed.

What to measure

Numbers worth tracking

Metric What it tells you What distorts it
Forecast variance by week Where accuracy degrades, which points at which assumption is weak.
Variance by line Receipts, payments, payroll, tax. Usually one line carries most of the error.
Days sales outstanding trend The single largest driver of receipt timing accuracy.
Headroom at the lowest forecast point The number that actually matters for decisions.
FAQ

Questions we are asked about this

It covers a quarter, which is long enough to see a liquidity problem forming and short enough that invoice-level detail is still meaningful. It is a convention rather than a rule.
It holds the raw inputs — open receivables, payables, payment history. It generally will not apply customer-specific payment behaviour without that logic being built, which is why forecasts are often finished in a separate model.
Thirteen weeks is the common operational horizon, and it works because it is short enough to be built directly from known receipts and payments while long enough to give time to act on a gap. Longer horizons — twelve months or more — are better built indirectly from projected profit and balance sheet movements, because a direct forecast that far out is mostly assumption presented as detail.
Open receivables with expected payment dates based on actual customer behaviour, open payables with their due dates, payroll, tax payment dates, loan repayments, and any known one-off items. The two inputs that most affect accuracy are customer payment behaviour and the timing of large irregular payments such as tax, and both are knowable from your own history.
Weekly for a thirteen-week rolling forecast, with a variance review at each update. The variance review is the part that gets dropped first and matters most — it is what converts forecasting from an exercise in producing a document into a process that gets better. A forecast updated weekly without variance analysis will be as inaccurate in month six as in month one.
You have the time the forecast bought you, which is the entire point of building it. The levers are collections acceleration on specific overdue accounts, payment timing within terms, facility drawdown, deferring discretionary spend, and in the worst case talking to your lender early. All of these are substantially easier eight weeks ahead than eight days ahead, which is why the forecast's value lies in lead time rather than in precision.
Related

Where to read next

What is budgetary control?

Read more

What is order to cash?

Read more

What is period close?

Read more

Need this applied to your own systems?

We build and support the systems this page describes. Start with a free working proof of concept — no cost, no commitment.