Construction Cash Flow Forecasting: A Quick-Start Guide
Construction cash flow starts with a real forecast, not a spreadsheet guess. A 2026 playbook for tying pursuits, WIP, and billings into one rolling view.
Edward Gonzalez
Co-Founder
If your construction cash flow forecast still lives in a spreadsheet, the math is already lying to you. Pursuit data sits in one tab, the work-in-progress (WIP) schedule sits in another, and the 13-week cash flow sits in a third that nobody opens until the bank asks. Meanwhile, the industry is carrying $280 billion in delayed payments and Days Sales Outstanding (DSO) that regularly runs 60 to 90 days or more. That gap between pursuit and paycheck is where most general contractors (GCs) lose sleep, margin, and sometimes the company.
Construction cash flow forecasting is the process of projecting when money will come in and when it will go out on every active and upcoming project, rolled up across pursuits, backlog, and WIP. Billings net of retainage on the inflow side, subcontractor draws and vendor AP on the outflow side. Done well, it runs off the same model as your revenue forecast, just filtered for timing instead of earned value.
Key Takeaways
- Cash flow and revenue forecasting run off the same model. Earned revenue drives billings, and billings drive cash. A unified model beats two disconnected reports every time.
- 94% of business spreadsheets contain critical errors (Poon et al., 2024). When WIP, billings, and pursuit data live in three separate tabs, you are not forecasting; you are guessing in formula format.
- Retainage is the quietest cash killer. Five to ten percent of every draw sits with the owner until closeout, sometimes for a year. A cash flow model without retainage as its own line consistently overstates available cash.
- The 13-week rolling cash flow forecast falls out of a real revenue model for free. Once pursuits, backlog, and WIP share one record, the weekly refresh rebuilds itself every Monday instead of taking three people half a week.
- Preconstruction is a cash flow problem. McKinsey found preconstruction excellence can drive up to 20% NPV uplift. If finance cannot see a pursuit until it becomes backlog, half the forecasting window is already gone.
How construction cash flow actually works (and where it breaks)
Most finance teams build earned revenue with the cost-to-cost method: revenue earned equals total contract value multiplied by costs-to-date divided by estimated costs at completion. That number drives billings, and billings drive the cash coming in. Clean in theory. In practice, the inputs come from three places that never agree. Project managers update cost-to-date in the project management tool. Estimators adjust estimated costs at completion in a buyout spreadsheet. The controller retypes both into the WIP schedule on the 25th of the month and hopes nothing moved.
The WIP schedule is a backward look, not a forecast. It tells you what you earned through last period, not what cash is landing next quarter, and it has no idea a $40M pursuit just moved from “submitted” to “verbal award.” So the Project Executive (PX) trying to plan cash for Q3 is reading a document built for the bonding agent, not the business.
Generic sales CRMs make this worse. They assume revenue lands on one date: the close date, or groundbreak. A Salesforce opportunity for a $20M project drops $20M into the month the job starts, which is exactly zero percent correct for construction. Real revenue arrives as an S-curve: a slow start during mobilization, a heavy middle during structure and rough-in, a long tail through commissioning and closeout. Cash arrives on an even slower curve once you factor in billing cycles, approvals, and retainage. Forecasting without either curve is not forecasting; it is wishful accounting.
Why spreadsheets can’t forecast cash flow (WIP, billings, retainage)
A 2024 review by Pak-Lok Poon and colleagues found that 94% of business spreadsheets contain critical errors. Link a WIP tab to a billings tab to a pursuit tab, copy last month’s formulas down, and you have just built a machine for profit fade. Sureties want monthly WIP. Lenders want rolling 13-week cash flow. Spreadsheets give you both, badly, and rarely on the same day.
Over/under billing is the first place it goes sideways. If you have billed $600K against $500K of earned revenue, you are overbilled by $100K. That money feels like cash but it is really a liability, and pretending otherwise is how a GC finds itself funding next month’s payroll out of last month’s overbilling. Retainage is the second landmine: 5 to 10% of every draw sits with the owner until closeout, sometimes for a year after the last punch item. A cash flow forecast that does not model retainage release as its own line is not a forecast; it is a mood. A centralized forecast catches both gaps per project, per period, before the surety or the bank does.
| Aspect | Spreadsheet WIP | Centralized Forecast |
|---|---|---|
| Source of truth | Three tabs, three owners, monthly retyping | One record per project, updated by the team that owns it |
| Pursuit visibility | Pipeline lives in business development’s head or CRM, not in the forecast | Weighted pursuits flow into the revenue curve automatically |
| Period close | Profit fade discovered after billing is locked | Cost-to-cost auto-reforecasts remaining periods at close |
| Over/under billing | Caught at month-end, sometimes by the surety first | Visible per project, per period, every time cost updates |
| Error rate | 94% contain critical errors (Poon et al., 2024) | One model, validated inputs, audit trail |
Closing the preconstruction-to-cash gap
Cash flow visibility does not start at contract signing. It starts when a pursuit enters the pipeline. McKinsey found that preconstruction excellence can drive up to 20% net present value (NPV) uplift on a project, and most of that value (and the cash timing behind it) is won or lost before the guaranteed maximum price (GMP) is signed. If finance cannot see a pursuit until it becomes a backlog item, half the forecasting window is already gone, and the first draw is three months closer than anyone in the bid room realized.
Think of it like a relay race where the estimating team finishes their leg, drops the baton, and walks off the track. Finance picks up whatever paperwork is left and tries to sprint the last lap. The handoff is the problem. On Buildr’s Forecasting module, a pursuit carries its own revenue curve (S-curve, linear, front-loaded, or back-loaded) from the day it enters the pipeline. When it moves to Won, then Active, then Backlog, the cash flow model comes with it. No retyping. No version drift. For the deeper view on how precon data should feed finance, see our guide on tracking project profitability from preconstruction.
The 13-week rolling cash flow forecast
Finance teams outside construction live by the 13-week cash flow forecast. It is the standard treasury and restructuring tool: one quarter out, refreshed weekly, always covering the next thirteen weeks. Construction finance teams mostly do not run one, because cobbling it together from a WIP schedule, an accounts receivable aging report, and a subcontractor draw schedule takes three people and half a week. By the time it is done, two weeks of the forecast are already in the past.
Think of it like the fuel gauge on a pickup truck. A WIP schedule tells you how much fuel you burned last trip. A 13-week forecast tells you whether you can make it to the next gas station. Different question, different tool, same tank.
When the revenue model already knows each project’s curve, backlog conversion, and pursuit probability, the 13-week cash flow falls out of it almost for free. Layer billing cadence and retainage release on the inflow side, then pay-when-paid timing and vendor terms on the outflow side, and the forecast rebuilds itself every Monday morning. That is the version bank relationship managers actually want to see, and the version that keeps Friday payroll from becoming a Thursday night phone call.
How AI tightens the cash flow loop
Gartner predicts that by 2026, 90% of finance functions will deploy at least one AI-enabled solution. In construction cash flow, that shows up in three places. First, weighted revenue: pursuits are multiplied by win probability so the cash outlook reflects a realistic range, not a wishful one. Second, auto-reforecasting: when cost-to-date updates mid-month, the system recalculates earned revenue, pushes the delta to remaining periods, and re-times the billings it drives instead of waiting for the controller. Third, report segmentation: the Buildr Platform lets you pull views for All projects, In Construction, Pursuits, Backlog, WIP, WIP + Pursuits, or Pursuits + Backlog, so the PX, CFO, and bonding agent each get the cut they need from the same data.
Kit: the preconstruction agent that knows your cash flow
The fourth lever is the one that changes the day-to-day: Kit, Buildr’s preconstruction agent. Kit has access to the same data the forecast runs on, which means a PX can ask “pull a 13-week cash flow by project for tomorrow’s leadership meeting” and get the answer in the same session, not three days later from the controller.
Recurring asks can be saved as Skills: the Monday pipeline summary, the quarterly WIP review, the list of pursuits whose curves need updating. Save it once, run it with one prompt, get the same format every time. That is the difference between AI that writes marketing copy and AI that actually runs finance.
With the ABC Construction Backlog Indicator falling to 8.1 months in November 2025, knowing which pursuits to chase is not optional. It is survival.
The Project Executive’s cash flow playbook
Five moves to get from “spreadsheet wrong” to “cash flow trusted”:
- Pull pursuits into the cash model. If your pipeline is in a CRM and your WIP is in Excel, you do not have a cash flow forecast; you have two reports and a guess. Connect them or replace them.
- Pick the right curve per project. A tenant improvement is front-loaded. A ground-up hospital is an S-curve. Linear is a fallback, not a default, and it quietly overstates early cash every time.
- Model retainage as its own line. Five to ten percent of every draw is not cash yet. Pretending otherwise is how GCs run into a Q4 wall they saw coming in Q1.
- Reforecast at close, not at crisis. Let cost-to-cost run on actuals every period so profit fade and the cash delta behind it surface while you can still fix it.
- Weight pursuits honestly. Multiply by win probability, not by ambition. Tie it to go/no-go criteria so the math is consistent across the BD team. Pair the cash model with workforce forecasting so a staffing decision in Q1 is not a payroll scramble in Q3.
The spreadsheet era is ending because the math outgrew it, not because somebody finally built a prettier UI. When pursuit, backlog, and WIP share one record, cash flow stops being a monthly fire drill and starts being a planning tool. That is the whole job.
Frequently Asked Questions
What is construction cash flow forecasting?
Construction cash flow forecasting is the process of projecting when money will come in and go out on every active and upcoming project, rolled up across pursuits, backlog, and work-in-progress. Billings net of retainage drive the inflow side; subcontractor draws and vendor accounts payable drive the outflow side. Done well, it runs off the same model as a revenue forecast, filtered for timing instead of earned value.
How is cash flow forecasting different from a WIP schedule?
A WIP schedule is a backward look at earned revenue through the last period, built for sureties and bonding agents. A cash flow forecast is a forward-looking view of inflows and outflows over the next 13 weeks or more. The WIP tells you what happened. The cash flow tells you what is about to happen and what to do about it.
What is a 13-week cash flow forecast in construction?
A 13-week rolling cash flow forecast is a weekly-refreshed view of expected cash inflows and outflows over the next quarter. Treasury teams outside construction have relied on it for decades. For general contractors, it layers billing cadence and retainage release on the inflow side with pay-when-paid timing and vendor terms on the outflow side, so finance always has a one-quarter runway.
How does retainage affect construction cash flow?
Retainage withholds 5 to 10 percent of every draw until project closeout, sometimes for a year after the last punch item. That money is earned but not yet cash. A forecast that does not model retainage release as its own line consistently overstates available cash and sets up Q4 crunches that were visible in Q1.
Why does preconstruction affect cash flow forecasting?
Cash flow visibility starts when a pursuit enters the pipeline, not when the contract is signed. McKinsey found preconstruction excellence can drive up to 20 percent NPV uplift on a project. If finance cannot see a pursuit until it becomes backlog, half the forecasting window is gone and the first draw is three months closer than anyone in the bid room realized.
How does AI improve construction cash flow forecasting?
AI improves construction cash flow forecasting in three ways: weighting pursuits by win probability so the outlook reflects reality, auto-reforecasting when cost-to-date updates mid-month, and surfacing the right segmentation (pursuits, backlog, WIP, or combinations) for different stakeholders. Gartner predicts 90 percent of finance functions will deploy at least one AI-enabled solution by 2026.
Ready to see what a unified cash flow forecast looks like on your own pipeline? Schedule a demo.