Construction Cash Flow Forecast for Contractors: Free 13-Week Template & Guide

Construction cash flow is the movement of money into and out of a construction company over time. Cash comes in from deposits, customer payments, progress billings, approved change orders and retainage releases. Cash goes out through payroll, materials, subcontractors, equipment, trucking, overhead, taxes, insurance and debt payments.

A company can report a profit while still experiencing a cash shortage, because the outgoing payments frequently happen before the customer cash is received. Profit is a measure of whether a job earned more than it cost. Cash flow is a measure of whether the money is in the bank when the obligation comes due.

That distinction is the whole reason this page exists separately from job costing. Job costing answers whether an individual job was profitable against its estimate. Cash flow forecasting answers whether the company can fund operations while waiting to get paid.

A construction cash flow forecast estimates when cash is expected to arrive and compares it with when cash obligations must be paid.

The purpose is not to predict every dollar perfectly. The purpose is to identify upcoming periods where the contractor may have significantly more cash leaving the business than entering it — while there is still time to bill sooner, delay a purchase, reschedule a mobilization, or arrange credit.

A rolling 13-week forecast is the common format because it gives management a detailed near-term view without trying to predict an entire year at weekly detail. Thirteen weeks is roughly one quarter: long enough to see a payroll-heavy stretch coming, short enough that the numbers are still worth something.

The downloadable construction cash flow template at the top of this page is a normal Excel workbook — no macros, no add-ins, no account, and no email gate. It opens in Excel, Google Sheets, LibreOffice and Numbers.

Each week's beginning cash pulls the prior week's ending cash automatically, so week 1 is the only beginning balance you enter. You also set your own minimum desired cash balance; any week projected to end below it is flagged and shaded. There is deliberately no default value in that cell — see the working capital section below for why.

The forecast is only as good as the timing assumptions behind it. Work through it in this order.

Consider a hypothetical contractor with $150,000 of beginning cash and $100,000 of customer receipts expected during the week.

The company may still be profitable on every one of those jobs. That week still drains $85,000 of cash. Nothing here is a costing error — it is entirely a timing problem, and timing problems are only visible in a forecast.

The calculator below runs the same arithmetic for one period. It is not a substitute for the 13-week workbook — a single week cannot show you a payroll cycle landing two weeks before a retainage release — but it answers the immediate question quickly.

Everything is calculated in your browser. Nothing is saved, and nothing is sent anywhere.

Suppose a contractor completes a profitable $100,000 project. Field payroll is paid weekly. Materials were purchased at the beginning of the project. Subcontractors are due. The customer pays in 45 days. Retainage is being withheld.

The income statement may eventually show a profit on that job. The contractor still has to survive the gap between paying the costs and collecting the revenue — and has to do it while starting the next job, which opens another gap.

That gap is one of the main reasons working capital matters in construction, and it is why a growing contractor can feel poorer every month while the profit-and-loss statement improves.

Most contractor cash-flow trouble comes from a short list of recurring causes.

The solution is usually not "sell more work." More work can increase cash requirements before it increases collections — see the growth section below.

Accounts receivable represents customer money owed to the company. It is not cash. A contractor may have $500,000 in accounts receivable and still struggle to make payroll if none of those invoices will be collected for several weeks.

Track each invoice by customer, project, invoice number, amount, invoice date, retainage, approval status, dispute status and — most importantly — the expected cash date. The AR sheet in the workbook does this and totals the net receivable by forecast week.

A signed contract is not cash. Completed work is not cash. An invoice is not cash. Accounts receivable is not cash. Cash becomes available when the customer payment is actually collected.

That sounds obvious, and forecasting still becomes unreliable the moment a company starts treating expected revenue as though it is already in the bank.

Retainage is money withheld from otherwise earned construction payments until contract requirements are met. From a cash-flow perspective, it creates a long gap between paying project costs and receiving the final portion of project revenue.

Track retainage separately from normal accounts receivable. Lumping it in overstates what is actually collectable in the near term, which is exactly the error a forecast exists to prevent. In the workbook, retainage is entered per invoice and excluded from the net receivable, with releases forecast on their own row when the contract actually allows them.

Retainage rules vary considerably by state, contract type and project owner, and this page covers it only as a cash-flow issue rather than as a full treatment of how retainage works.

Progress billing reduces the amount of project cost a contractor has to finance before receiving payment. Depending on the contract, contractors may bill monthly, by percentage complete, by milestone, or by completed quantity — the exact rules depend on the project and the contract.

The cash-flow principle is simple: invoice eligible work as promptly and accurately as possible. Every unnecessary billing delay extends the period the contractor is financing the project out of its own cash.

Do not let completed work sit unbilled. An invoice that goes out nine days late is nine days of financing the contractor absorbed for nothing.

Extra work may require immediate labor, materials, equipment, trucking and subcontractors, while the additional revenue is not approved or collected for weeks or months.

Track requested amount, submitted date, approval status, work status, expected billing and expected payment. Do not treat unapproved change orders as guaranteed cash in the forecast — a change order that is being worked but not approved is a cost with no scheduled collection.

Working capital is the financial capacity available to fund day-to-day obligations — payroll, materials, mobilization, equipment, subcontractors and overhead — while waiting for customer cash.

There is no universal amount every contractor should maintain, and any figure presented as a universal target should be treated with suspicion. What a given company needs depends on project size, payroll, payment terms, number of concurrent jobs, supplier terms, debt, existing cash reserves, access to credit and the risk profile of the work.

This is why the workbook asks you to set your own minimum cash balance rather than shipping with a default. The forecast can tell you which weeks fall below your floor. Only you can set the floor.

Growth usually increases cash requirements before it increases available cash. Consider a contractor that doubles the amount of work under construction. The company immediately needs more field employees, payroll, material, trucks, subcontractors, supervision and equipment.

Customer payment terms, meanwhile, generally do not change. Costs can double while collections stay on the same 30- or 45-day cycle.

That is how a company can grow revenue, grow backlog, remain profitable, and still experience increasing cash pressure every month. Growth is funded out of working capital until collections catch up.

Cash-flow management is a recurring operating process, not a one-time spreadsheet build. A contractor should regularly review current cash, upcoming payroll, expected material payments, subcontractor obligations, accounts receivable, retainage, expected collections, taxes, debt payments and upcoming project mobilizations.

A rolling forecast works by moving forward. At the end of each week: replace forecasted amounts with actual results, update expected customer payment dates, add newly awarded projects, update payroll assumptions, update material and subcontractor obligations, and add another week to the end of the forecast.

The company should always be looking roughly 13 weeks ahead. A forecast that is created once and never updated has limited value — and it can be worse than no forecast, because it produces confidence in numbers that stopped being true a month ago.

Some patterns deserve attention well before they become a crisis.

A single bad week may not indicate a structural problem — weather alone can produce one. Repeated patterns are the signal worth acting on.

Use the checklist below on a weekly cycle, before starting a new project, and monthly. It is printable, so it can live with the forecast.

A contractor does not need a complicated financial model to improve cash awareness. Four questions cover most of it: what cash do we have now, what money is realistically expected to arrive, what must be paid, and when does each of those events occur?

A simple rolling 13-week construction cash flow forecast can expose financial pressure early enough for management to respond — bill sooner, reschedule a purchase, delay a mobilization, or arrange credit — before a temporary cash shortage becomes an operating crisis.

For more contractor operations guidance, browse Contractor Resources. To close out individual jobs against their estimates, use the construction job costing spreadsheet. For the material assumption that most often moves a forecast, see asphalt price per ton, and for haul costs the asphalt trucking calculator.