Cash Flow Forecast Template for Construction Companies

Construction companies often run out of cash while their order books are full. Crews, subcontractors and materials are paid weeks before a progress payment is approved, and clients hold back retainage until the job is finished. A cash flow forecast built around billing and payment timing is how contractors stay solvent while they grow.

Why construction cash flow is different

• You pay first, bill later. Labour and materials go out during the month; the progress claim is submitted at month end and paid 30 to 60 days later.
• Retainage holds back profit. Clients commonly withhold 5 to 10 percent of each payment until practical completion. On a busy year that can be your whole margin.
• Jobs overlap. Mobilisation costs for a new project often land in the same weeks as retainage is still held on the last one.
• Weather and seasons. Winter slows work and billing in many regions, while overheads keep running.
• Change orders. Extra work is often done before it’s priced or approved, so the cash comes late.

A worked example

A contractor bills $200,000 in March. The client pays 10 percent in the month, 55 percent the following month and 35 percent the month after, and retains 10 percent of everything.

The contractor paid $150,000 in March but collected just $18,000 of that month’s billing. The rest arrives over the next two months, and $20,000 waits until handover. A forecast built this way shows the working capital gap before it becomes an overdraft emergency.

How to build a construction cash forecast

1. Schedule billings by project and month from your programme.
2. Apply how each client actually pays, not the contract terms.
3. Deduct retainage and schedule its release after completion.
4. Schedule subcontractor payments, materials, field payroll, equipment and bonding.
5. Remember retainage you hold back from your own subcontractors.
6. Review weekly, since one late payment certificate moves everything.

Common mistakes

Forecasting on the contract value instead of the billing schedule. Forgetting retainage entirely. Paying subcontractors on 14-day terms while clients pay on 60. And treating unapproved change orders as cash.

What the template gives you

The Construction template includes a Progress Billing tab: enter what you bill each month and how fast clients pay, and it calculates cash collected, retainage held and retainage released, feeding the 12-month forecast automatically. A 13-week view keeps payroll weeks under control. Read more about why profit and cash differ.

Key assumptions built into the Construction template

• The Progress Billing tab turns what you invoice into cash actually collected for “Progress payments”. The example assumes 10% is paid in the month invoiced, 55% the following month and 30% two months later, with 10% retainage held back until it is released. Invoices sent before the start date are entered separately so the first months are right, and anything never collected shows as bad debt, so you can see what slow payers cost you.
• 5 cash in lines and 8 cash out lines are already named for construction businesses, and every one can be renamed or extended.
• The example figures follow a typical construction year, busiest in June and July and quietest in December and January, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Construction template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Construction cash flow forecasting: questions

What is retainage in construction cash flow?

Retainage is a percentage of each progress payment, often 5 to 10 percent, that the client holds back until the job is complete. It should be forecast as cash received months later, not with the progress payment.

How do contractors forecast cash flow?

Start from the billing schedule for each project, apply the client’s real payment delay and retainage, then schedule subcontractor, material and payroll payments against it.

Why do profitable construction companies run out of cash?

Because costs are paid during the work while progress payments arrive 30 to 60 days later and retainage months later. Growth widens that gap.