Skip to content
Practical support for UK subcontractors A subsidiary service of QS and Estimating Consultants Ltd (opens in a new tab)
Get a Free WebsiteTender Notifications

QS tool 10

Cash flow forecast

Compare your planned valuations and receipts over the contract.

The pre-filled 24-day lag reflects the England and Wales Scheme fallback of due date +7 and final date +17 from a relevant period end. Replace it with the signed contract timetable. The S-curve is only a planning illustration; use manual values when a programme or valuation forecast exists.

Monthly gross valuations
Assumptions and calculation guidance
Calculated in this browser. Nothing is saved by this tool.
Worked example and related working sheet
Using this calculator

How to Use This Calculator

Enter the total contract value, first valuation month and number of months. Use your monthly valuation forecast when one exists. Select the approximate S-curve only for an initial illustration. Enter the expected delay between valuation and cash receipt from your project timetable, then add the retention percentage.

Worked Example

A £6,000 forecast with 5% retention produces £5,700 of expected receipts before retention release. Moving the receipt lag changes when money arrives; it does not change the value of work.

Before You Use the Result

This tool forecasts receipts. It does not deduct wages, supplier payments or overheads, so it is not a net cash balance or a profit forecast. Review the forecast when the programme or payment position changes.

For a project that needs a wider review, explore QSEC commercial management support alongside The Subbie QS support.

Return to the full QS tools library for related calculators. You can also read about our variation and project support or use the free QS templates to organise the underlying records.

Free working resources

Use The Working Sheet For This Task

Keep budgets, costs, commitments and the forecast together. Replace the example entries with your job figures.

Download the Cost Value Reconciliation Sheet (Excel)

Each Excel link takes you to the matching sheet preview. Enter your work email to download, replace the example entries and start using the file on your job. Marketing is optional.