On this page
- Step 1: Gather the inputs
- Step 2: Spread cost by month
- Step 3: Bill it
- Step 4: Move billings to the month you’re paid
- Step 5: Time cash out by type of cost
- Step 6: Run the cumulative total
- Step 7: Test the terms, then keep it current
- Worked example: a six-month, $1.2 million job
- Common mistakes
- How os.construction handles it
- FAQ
To build a construction cash flow projection, spread the job’s cost by month, bill it, then move every dollar to the month it’s actually paid: owner receipts after the payment lag and less retainage, payroll in the month, suppliers on their terms, and subs under their terms or pay-when-paid. Run cash in minus cash out as a cumulative total; the lowest point is the job’s peak cash need.
Profit tells you what a job will earn; cash flow tells you when. The guide to getting paid in construction explains where the gap comes from. This post is the build. The free cash flow projection template does the same steps in Excel (download the .xlsx), and the cash flow S-curve calculator stacks several jobs.
Step 1: Gather the inputs
You need the contract value, the estimated cost (so the margin), the duration, and the payment terms on both sides:
- Owner side: billing cycle, how long after billing you’re paid, retainage rate, and when retainage is released. These are in the prime contract; see how to read construction contract payment terms.
- Cost side: how cost splits between self-performed labor, material and subcontracts, your supplier terms, the retainage you hold on subs, and whether your subcontracts are pay-when-paid.
Step 2: Spread cost by month
Use a cost-loaded schedule if you have one. If not, spread cost along an S-curve: light at mobilization, heavy through the middle, tapering through finishes and closeout. The monthly percentages must add to 100%.
Step 3: Bill it
Most jobs bill progress monthly against the schedule of values. For a projection, the simplest assumption is that billing follows cost at the contract’s margin: billing = cost ÷ (1 − margin). If you plan to bill differently, for example front-loaded mobilization, model it.
Step 4: Move billings to the month you’re paid
Shift each month’s billing by the owner’s payment lag, and take off retainage. Put the retainage release in its own month, usually some time after completion, once closeout conditions are met. This is cash in.
Step 5: Time cash out by type of cost
- Payroll: in the month the work is done.
- Material: on supplier terms, for example the month after delivery.
- Subcontractors: on their terms, less the retainage you hold. Under pay-when-paid, they’re paid after you are, so their timing follows the owner’s.
- Sub retainage: released when the owner releases yours, if your subcontracts tie them together.
Step 6: Run the cumulative total
Net cash each month is cash in minus cash out. The running total is the job’s cash position. Its lowest point is the peak cash need: the amount of working capital or credit line the job needs. At the end it should equal the job’s profit.
Step 7: Test the terms, then keep it current
Change one term at a time: a longer owner lag, higher retainage, subs on fixed terms. That shows what each term is worth, which is useful at contract negotiation. Once the job starts, replace projected months with actual receipts and payments every month after billing.
Worked example: a six-month, $1.2 million job
Inputs
- Contract $1,200,000; cost $1,080,000; margin $120,000 (10%).
- Cost curve over six months: 10%, 15%, 25%, 25%, 15%, 10%.
- Cost split: labor 30%, material 20%, subcontracts 50%.
- Owner pays one month after each billing and holds 10% retainage, released in month 8.
- Labor paid in the month; material paid the following month; subs paid when the GC is paid (pay-when-paid), less 10% retainage released in month 8.
Cost and billing
| Month | Cost | Billing (cost ÷ 0.9) | Labor | Material | Subs |
|---|---|---|---|---|---|
| 1 | $108,000 | $120,000 | $32,400 | $21,600 | $54,000 |
| 2 | $162,000 | $180,000 | $48,600 | $32,400 | $81,000 |
| 3 | $270,000 | $300,000 | $81,000 | $54,000 | $135,000 |
| 4 | $270,000 | $300,000 | $81,000 | $54,000 | $135,000 |
| 5 | $162,000 | $180,000 | $48,600 | $32,400 | $81,000 |
| 6 | $108,000 | $120,000 | $32,400 | $21,600 | $54,000 |
| Total | $1,080,000 | $1,200,000 | $324,000 | $216,000 | $540,000 |
Cash by month
Cash in is last month’s billing × 90%. Subs paid is last month’s sub cost × 90%. Material paid is last month’s material.
| Month | Cash in | Labor paid | Material paid | Subs paid | Net | Cumulative |
|---|---|---|---|---|---|---|
| 1 | $0 | $32,400 | $0 | $0 | −$32,400 | −$32,400 |
| 2 | $108,000 | $48,600 | $21,600 | $48,600 | −$10,800 | −$43,200 |
| 3 | $162,000 | $81,000 | $32,400 | $72,900 | −$24,300 | −$67,500 |
| 4 | $270,000 | $81,000 | $54,000 | $121,500 | +$13,500 | −$54,000 |
| 5 | $270,000 | $48,600 | $54,000 | $121,500 | +$45,900 | −$8,100 |
| 6 | $162,000 | $32,400 | $32,400 | $72,900 | +$24,300 | +$16,200 |
| 7 | $108,000 | $21,600 | $48,600 | +$37,800 | +$54,000 | |
| 8 | $120,000 retainage | $54,000 retainage | +$66,000 | +$120,000 |
The peak cash need is $67,500, at the end of month 3. The job turns cash-positive in month 6 and ends at +$120,000, the margin, once both retainages are settled in month 8. Total cash in is $1,200,000 and total cash out $1,080,000, so the columns tie.
One term changed. If the owner pays two months after billing instead of one, and the subs, being pay-when-paid, move with it, the low point becomes $202,500 at the end of month 4: three times as deep, from one extra month of owner lag on the same job. Labor and material don’t wait for the owner, which is why the hole deepens.
Common mistakes
- Treating billing as cash. A pay app is a receivable until it’s paid, less retainage.
- Forgetting retainage on both sides. Owner retainage delays cash in; sub retainage delays cash out.
- Assuming pay-when-paid covers everything. Payroll and many suppliers don’t wait, and pay-when-paid clauses aren’t enforceable the same way everywhere.
- A straight-line cost spread. Most jobs spend fastest in the middle; a flat spread understates the peak.
- One job at a time. Several jobs hitting their low points together is what strains a credit line. Add them up.
- Building it once. Update it monthly with actuals, or it drifts from the bank balance.
General information, not legal or financial advice. Payment terms, retainage and the enforceability of pay-when-paid and pay-if-paid clauses depend on the contract and the law where the project sits.
How os.construction handles it
In Accounting, Financial Reports include a cash forecast 13 weeks or 12 months ahead that starts from your bank balances. Inflows come from open receivables timed by each customer’s days to pay, retainage released after completion and unbilled contract value; outflows from open payables, commitments, payroll, debt and leases. Scenarios overlay changes without altering the base, and a stored snapshot reports forecast vs actual. Remaining contract and commitment value is spread evenly to completion today; cost-loaded project cash curves like the one above are planned. See Cash forecasting.
FAQ
How do you make a cash flow projection for a construction project?
Spread the job's cost by month, from the estimate or a cost-loaded schedule. Bill it each month, then move each billing to the month the owner pays it, less retainage. Time each kind of cost by its own terms: payroll in the month, suppliers on their terms, subcontractors when their terms or a pay-when-paid clause say. Cash in minus cash out, run as a cumulative total, is the job's cash position.
What is peak cash need on a construction job?
The lowest point of the job's cumulative cash position: the most of your own cash or credit line the job uses at one time. It usually falls in the first half of the job, before collections catch up with spending.
What has the biggest effect on a construction job's cash flow?
Timing terms: how long the owner takes to pay, how much retainage is held and when it's released, and how quickly you have to pay labor, suppliers and subs. Changing one term at a time in the projection shows what each is worth on that job.
How often should a cash flow projection be updated?
At least monthly, after billing and the cost review, replacing projected months with actual receipts and payments. Many contractors also keep a short-term company cash forecast by week.
Is a cash flow projection the same as a WIP schedule?
No. The WIP schedule measures earned revenue and billing position at a date; the cash flow projection is about when money actually moves. A job can be under-billed on the WIP and still cash-positive, or the reverse.
Share this article