Cash Flow Forecast

A cash flow forecast projects the money entering and leaving a business over a future period, usually week by week in the short term and month by month beyond it. It forecasts timing, not profit — and timing is what fails first.

Profitable businesses fail on timing. A company can hold a full order book, sound margins and no way to pay salaries in the third week of the month, and only a cash forecast shows that in advance.

Accuracy decays fast with distance. The first six weeks can be built from known invoices and commitments; anything beyond a quarter rests on assumptions about sales that have not happened.

The forecast earns trust by being compared to what actually occurred. A team that reviews last week’s variance every week produces better forecasts within two months, without changing the model at all.

Key takeaways

• The forecast projects timing of cash movements, not profitability.
• Short horizons are built from commitments; long horizons rest on assumptions.
• Weekly variance review improves accuracy faster than model sophistication.
• Receipts are the uncertain side; most payments are already known.

How it works

Short-term forecasts are built bottom-up from the ledgers: confirmed invoices with expected payment dates, payroll dates, tax dates, rent, and known supplier commitments. Very little of this is genuinely uncertain.

The receipts side carries almost all the risk. Customers pay late, disputes delay settlement, and a forecast that assumes every invoice pays on terms will be wrong in the same direction every single month.

Scenarios beat precision. Running a base case alongside a version where the largest three customers each pay two weeks late shows the point at which the business needs a facility, which is the decision the forecast exists to inform.

Invoicing obligations shape the timing. UK guidance on invoicing and taking payment notes a business must give an invoice by law “if both you and the customer are registered for VAT”.

Direct and indirect methods answer different needs. The direct method lists actual receipts and payments and is what an operator wants; the indirect method reconciles from profit and is what an accountant produces.

One forecast is not enough for a group. Cash trapped in a subsidiary or a currency is not available centrally — and a consolidated total can look comfortable while one entity runs out.

Basic bookkeeping is the foundation. The Small Business Administration advises that a balance sheet “helps you keep track of your capital and provide a cash flow projection for future years”.

Examples

Forecasts prove their worth at the moment they show a gap early enough for somebody to close it. Three short cases below show where that actually happened.

A services firm moves to a thirteen-week rolling forecast. Its finance manager spots a payroll gap eight weeks out and arranges a facility calmly.

A distributor applies judgmental forecasting to two large accounts with unpredictable payment habits. Statistical averages had hidden the lumpy behaviour entirely.

A manufacturer tracks forecast accuracy rate weekly. Within a quarter the systematic optimism in its collections assumptions is visible and corrected.

Related terms

Cash forecasting depends on the transaction processing underneath it and on the people who run that work day to day. The entries below cover those supporting functions rather than the forecast.

• Accounts payable outsourcing: controls the timing of the outflow side.
• Finance and accounting outsourcing: the broader function a forecast sits inside.
• Certified public accountant (CPA): the qualification often behind the assumptions.
• Digital payment: faster settlement that compresses the uncertainty window.

FAQ

How far ahead should a forecast run?

Thirteen weeks in detail and twelve months at a summary level suits most businesses. Detail beyond a quarter adds effort without adding reliability.

How often should it be updated?

Weekly for the short horizon. A monthly forecast is already stale in its most useful section — by the time it is circulated.

What is the most common error?

Assuming customers pay on terms. Use each customer’s actual payment behaviour instead, because the historical pattern is a far better predictor than the contract.

Should it be built in a spreadsheet?

For most small and mid-sized businesses, yes. Tooling helps at scale or across currencies, but it does not fix assumptions that were wrong to begin with.

How does it differ from a budget?

A budget sets planned income and spend for a period. A forecast projects when cash will actually move, which can be months away from when the revenue was recognised.

Who should own it?

Finance builds it, but sales and operations own the assumptions inside it. A forecast finance produces alone will keep being wrong in the same place.

Find finance and accounting partners in the Outsource Accelerator directory.