Cash Flow Forecast

What is a cash flow forecast?

A cash flow forecast is a forward-looking estimate of the money moving into and out of a business over a future period, showing the projected bank balance at the end of each week or month. It is the rolling, best-estimate view of liquidity that a business keeps updated, mapping expected receipts, mainly customer payments, against expected payments like payroll, suppliers, rent, and tax. The output is a single running balance that answers one question: will there be enough cash, and when.

For anyone selling on credit, the forecast stands or falls on accounts receivable. Revenue does not become cash on the invoice date; it becomes cash when customers actually pay. So the timing of collections, not the size of sales, is the variable that swings the whole forecast. A profitable business can still run dry if its receipts land later than its bills, which is why a cash flow forecast is really a collections forecast in disguise.

What goes into a cash flow forecast

A cash flow forecast is built from four parts: an opening cash balance, expected cash inflows, expected cash outflows, and the closing balance that carries forward into the next period. Everything in a forecast is one of those four things. Get the inflows and their timing right and the rest is arithmetic.

The art is almost entirely in step two. It is tempting to book every invoice as cash on its due date, but customers rarely oblige. A sharper forecast pushes expected receipts out to when money genuinely arrives, using your real days sales outstanding rather than your stated terms. You can pull the timing and aging detail you need straight from your accounts receivable reporting, which turns the inflow line from a guess into something grounded in how customers actually behave.

How to build a cash flow forecast

To build a cash flow forecast, choose a time horizon, enter your opening balance, schedule expected inflows by realistic payment dates, list outflows by due date, then calculate each closing balance and roll it forward. The mechanics take minutes in a spreadsheet; the accuracy lives in the assumptions, above all the timing of customer payments.

Pick a horizon that fits the purpose. A short-term operational forecast often runs 13 weeks to manage day-to-day liquidity, while a strategic forecast usually covers 12 months. Whichever you choose, the forecast is a living document, not a one-off. The discipline that separates a useful forecast from a decorative one is updating it: compare each period against what actually happened, correct your assumptions, and roll the window forward. A forecast written in January and never touched is just a guess by March. This is the same habit behind a rolling forecast, which always keeps a fixed window of future periods in view.

Direct vs indirect cash flow forecast

The direct method builds the forecast from actual expected cash receipts and payments, while the indirect method starts from forecast profit and adjusts for non-cash items and changes in working capital. Both arrive at the same closing cash figure; they differ in where they start and what they are best at.

For most small and mid-sized businesses managing week-to-week cash, the direct method is the practical choice: it shows precisely which week runs short and why. The indirect method is more common in formal financial planning, because it ties cleanly to the profit and loss and balance sheet. Many finance teams use both, a direct short-term forecast for operations and an indirect long-term one for the board. A close cousin worth knowing is the cash flow projection, which in everyday use means much the same thing, though people sometimes reserve "projection" for a single what-if scenario and "forecast" for the rolling base case.

Cash flow forecast template and common mistakes

A simple cash flow forecast template has one row per cash line, mainly opening cash, customer receipts, total inflows, each major outflow, total outflows, and closing cash, with one column per week or month. You can build it in any spreadsheet; the structure matters far more than the tool. Lay the periods across the top, the cash lines down the side, and let the closing balance of one period feed the opening balance of the next.

The mistakes that wreck a cash flow forecast are predictable, and almost all of them come down to timing. Three errors catch people out again and again.

The deepest fix is upstream. The more reliably customers pay close to terms, the more accurate and healthier the whole forecast becomes, which is why reducing DSO does more for cash planning than any spreadsheet refinement.