Construction Sales Forecast Template

Start with the two foundation sheets before touching the forecast. First, populate the Backlog Schedule with every project you have under signed contract — enter the project name, total contract value, start month, and estimated duration. This is your committed revenue, and it's the most accurate part of the model. Then move to the Project Pipeline sheet and enter your active bids with estimated contract values and your honest probability of winning each one. If you're not sure on probabilities, a reasonable starting point: proposals submitted and under review are 30–40%, finalists under negotiation are 60–70%, and verbal awards awaiting contract are 85–90%. Budget about 30–45 minutes for this initial setup.

Once the pipeline and backlog are entered, review the Monthly Forecast sheet to check whether the projections look realistic month by month. Construction revenue is lumpy by nature — large project starts create spikes, and scheduling gaps create troughs — so a forecast that shows perfectly smooth monthly revenue is usually wrong. Apply any seasonal adjustments for months where your region typically slows (winter weather, holiday shutdowns) or accelerates (spring construction season). The Scenario Comparison sheet is worth filling in early too: set a downside where your win rate drops 20% and two or three backlog projects slip by a quarter. If the downside still covers your fixed overhead, your pipeline is in good shape.

The ongoing value is the monthly review against actuals. After each month closes, pull your billing summary from your job costing software or accounting system and enter it in the Actual vs Forecast sheet. The variance calculations will show whether you're billing on pace and which project types are running ahead or behind. If you're consistently missing your commercial forecast but beating residential, your probability estimates for commercial bids might need recalibration. If backlog revenue is coming in light, that's usually a billing timing issue — projects are progressing but invoices haven't gone out — and a signal to tighten up your progress billing cycle.

Construction revenue forecasting is harder than most industries because revenue isn't generated daily — it arrives in chunks tied to project milestones, progress billing cycles, and contract close dates that shift. A restaurant can forecast Tuesday dinner with reasonable confidence; a general contractor's October revenue depends on whether three projects that were supposed to start in September actually broke ground, whether a commercial client signed the contract they've been sitting on for six weeks, and whether the project manager got the September billing out before month-end. The result is that most construction companies are flying on gut feel, discovering their revenue shortfall in the last week of the month. A structured forecast — built from actual backlog and weighted pipeline — doesn't eliminate that uncertainty, but it makes it visible weeks earlier.

The two metrics that define construction revenue health are backlog coverage ratio and pipeline close rate. Backlog coverage ratio is your total contracted backlog divided by your annual revenue target — most healthy contractors carry six to nine months of backlog at any given time. Below three months means you're dependent on pipeline wins to hit your year, which is fine if your pipeline is strong and your close rate is known. Pipeline close rate is how much of your weighted pipeline actually converts to signed contracts — if you're weighting bids at 50% but only winning 30%, your forecast will systematically overstate revenue by 20%. Tracking both metrics monthly, which this template does automatically, is what separates contractors who manage their pipeline from those who react to it.

The most practical use of a construction sales forecast is capacity planning. If your forecast shows a $2.1M revenue month in April but your field crews can realistically bill $1.6M, one of three things is wrong: the forecast is too aggressive, you need to hire, or some of those projects will slip. Running the forecast alongside a simple capacity check — total field hours available × your average billing rate per hour — catches that misalignment in January instead of April. It also works in reverse: if your forecast shows a slow August, you know four months in advance that you need to accelerate pipeline activity, renegotiate a project start date, or plan a crew utilization project to fill the gap.