Finance Transformation
Cash Flow Forecasting That Actually Works
1 July 2025
Most cash flow forecasts are wrong. Not slightly wrong, materially wrong, in ways that matter for business decisions. The forecast says the business has comfortable headroom for the next quarter. The actual cash position three months later tells a different story.
The forecasts are wrong not because the people building them are incompetent, but because they are built on assumptions that feel reasonable and turn out not to be. Collecting from debtors in thirty days when actual collection runs at fifty-two. Paying suppliers in sixty days when key suppliers demand thirty. Including revenue that is expected but not contracted. Excluding costs that are coming but have not yet been invoiced.
These errors compound. A forecast that is built on optimistic assumptions in four places can be off by six figures in a business that turns over a few million.
The two types of cash flow forecast
The thirteen-week rolling forecast is an operational tool. It is built bottom-up from actual expected receipts and payments: specific customer invoices expected to be collected, specific supplier invoices expected to be paid, payroll, tax, and other commitments that are known and dated. It should be updated weekly. It is the early warning system for liquidity problems and the tool used to manage working capital week by week.
The twelve-month forecast is a strategic planning tool. It is built from the P&L budget, ideally from well-structured management accounts, converted to cash by adjusting for timing of receipts and payments, capital expenditure, loan repayments, and other non-P&L movements. It is less granular than the thirteen-week and less accurate at the individual transaction level, but it gives the visibility needed for decisions about investment, hiring, and financing. This is what boards need to see on cash in a well-structured board pack.
Both are needed. Most businesses that do cash flow forecasting at all have one or the other. The businesses that manage cash well have both, understand what each is for, and do not conflate them.
Where forecasts go wrong
Debtor days based on terms rather than reality. Payment terms of thirty days do not produce collection in thirty days. Actual debtor days for most businesses are longer than the headline terms. The forecast needs to use actual historical collection patterns, not the terms on the invoice.
Treating expected revenue as banked. A signed contract is closer to cash than a verbal commitment, but it is not the same as cash in the bank. Forecasts that include revenue before it is invoiced and collected are building on sand.
Missing lumpy costs. Annual insurance premiums, rates bills, professional fees, capital expenditure: these costs are known in advance but get missed from rolling forecasts because they do not appear in the monthly run rate. A complete forecast maps all known costs regardless of frequency.
VAT and payroll tax timing. VAT returns and payroll taxes are large periodic payments with fixed due dates. Missing them from the forecast is a common error that produces a nasty surprise when the payment falls due.
Ignoring the seasonality of the business. A business with seasonal revenue patterns has seasonal cash patterns. A forecast that uses average monthly revenue will misrepresent both the peak and the trough.
The working capital conversation
Cash flow forecasting surfaces a conversation that many growing businesses avoid: the working capital cycle. How long does cash sit in inventory before it becomes a sale? How long after a sale does cash actually arrive? How long can the business delay payment to its own suppliers?
These three numbers, inventory days, debtor days, and creditor days, determine the working capital requirement. A business that improves its working capital cycle frees up cash without borrowing. A business that lets it deteriorate needs more cash to fund the same level of trading. This deterioration is one of the signs you need a Finance Director who can manage the working capital cycle actively.
The cash flow forecast makes these dynamics visible. That visibility is what allows them to be managed.
Maebh Collins is a Chartered Accountant (FCA, ICAEW) with twenty years of operational experience managing cash flow in businesses ranging from early-stage startups to multi-entity international groups.
Maebh Collins is a Chartered Accountant (FCA, ICAEW), Big 4 trained, with twenty years of experience building and running international businesses. She specialises in finance transformation, ecommerce operations, and digital strategy.