How to make a weekly construction cash-flow forecast
Build a dated cash forecast and separate likely receipts from money already in the bank.
By ENRO team
A weekly construction cash forecast shows when cash is expected to enter and leave, not just whether the project is profitable. Begin with available cash, then add dated receipts and subtract dated payments.
A worked week
Illustrative figures: opening cash is ₹8 lakh. Expected customer receipts are ₹5 lakh. Planned payments are ₹4 lakh for materials, ₹3 lakh for a contractor and ₹1 lakh for wages. Forecast closing cash is ₹8 + ₹5 − ₹8 = ₹5 lakh.
If the customer receipt slips one week, closing cash becomes zero. The original forecast looked comfortable only because the receipt was assumed to arrive on time. Record that assumption explicitly and examine a delayed-receipt scenario before committing more cash.
Build a useful weekly sheet
- Week ending and opening available balance.
- Each expected receipt, payer, invoice reference and expected date.
- Each payment, payee, project, due date and approval status.
- Restricted funds shown separately from cash available for general use.
- Base forecast, delayed-receipt scenario and agreed minimum cash buffer.
- Owner of each uncertain assumption and next update date.
Do not add an approved invoice and its related expected receipt twice. Keep forecast entries distinct from bank-confirmed transactions. For a company-wide view, avoid counting an internal transfer between company accounts as new income.
Compare forecast with actual cash
At week end, explain differences by timing, amount and missing entries. A delayed bill may improve this week's closing balance while increasing next week's requirement. Carry it forward rather than deleting it.
Update the forecast when a significant delivery, collection or payment date changes. Link it to procurement and site plans so a revised work sequence reaches finance.
For the broader method, see RICS cash-flow forecasting practice information. The figures and suggested sheet above are ENRO's own illustrative example.