See the cash gap before it becomes a crisis. Forecast, post actuals, track variance, react.
12-month rolling cash flow forecast for a single construction company. Income across multiple projects, expenditure across the standard categories, post actuals month-by-month, auto-calculated variance, dashboard with traffic-light liquidity status.
Cash flow is not the same as profit. A company can be profitable on paper and still run out of cash — it happens regularly in construction because of the gap between paying subcontractors (often 30 days) and being paid by clients (often 60+ days, longer with retention). When you add corporation tax payment dates, VAT quarters, PAYE / NIC monthlies, and the seasonality of construction receipts, even a healthy business can hit a liquidity squeeze without realising it until the bank account tells you.
This template is a 12-month rolling cash flow forecast for a single company. It tracks income from multiple projects plus other sources (advisory, retention releases, VAT receipts, sundry), and expenditure across the seventeen standard categories every UK construction business has — wages, CIS subcontractors, suppliers, plant, premises, insurance, professionals, software, marketing, finance, all three flavours of HMRC payment, pensions, director drawings.
Forecast at year start. Post the actuals at month-end. The variance tab calculates the difference automatically and flags where forecast accuracy needs improving. The dashboard shows the headline KPIs — opening balance, lowest projected balance, total variance — and a traffic-light status that reads CRITICAL if any month projects negative, WARNING if any month projects below your minimum target, HEALTHY if it stays above target throughout.
