A 6-month cash flow forecast for a building project or contractor: client payments in; materials, labour, plant, site overheads, admin and taxes out. Opening, net and closing balances roll forward each month. Negative months show in red, so you can see a funding gap before it stops work on site.
Preview — filled-in example
Open full screen ↗In the Excel file, blue cells are for your figures. Grey cells are formulas and update automatically.
Prefer not to use a spreadsheet?
Do the same job in one of our free online tools — no formulas to maintain.