New home construction budget spreadsheet: trades, bids, change orders and draws
A new home construction budget spreadsheet has one job: tell you, every week, what the house is now expected to cost, not what you hoped it would cost when you signed. That means one line per trade with seven columns (planned, selected bid, committed, paid, forecast, variance, status), a bid comparison on identical scope, a change-order log that feeds the forecast, and a draw schedule with a cap per stage. This article shows how to set that up in Excel, with a fictitious example, and what the Consumer Financial Protection Bureau says about construction loans that pay out in stages.
What the budget must answer every week
Four questions, in this order:
- What did I plan? The budget by trade you set before bids came in, plus a contingency reserve on its own line.
- What have I signed? Committed money: contracts and approved change orders only, never a verbal quote.
- What have I paid? Draws released to the builder or to subcontractors, with the date and the stage.
- What will it cost in the end? The forecast: for each trade, the selected bid (or the plan if no bid is selected yet) plus approved change orders.
If the spreadsheet cannot produce the fourth number by formula, it is a list of expenses, not a budget. The forecast is what you compare with your financing, and its gap with the plan is what the reserve has to absorb.
Budget by trade
Group the lines the way a builder's schedule of values does, so that bids and invoices map onto them without translation. A workable list for a single-family home has about thirty lines in a dozen groups: design and engineering; permits and fees; site work; foundation; framing; roofing; windows and exterior doors; mechanical, electrical and plumbing; insulation and drywall; interior finishes; driveway and landscaping; general conditions. Each line carries the same columns:
| Column | Typed or calculated | Rule |
|---|---|---|
| Planned | Typed | Your estimate before bids; frozen once the contract is signed |
| Selected bid | Picked from the bid comparison | The bid you chose, not necessarily the lowest |
| Committed | Calculated | Selected bid if the contract is signed, plus approved change orders; otherwise zero |
| Paid | Sum of draws | Only money that has left your account or the lender's |
| Forecast | Calculated | Selected bid (or planned if none) + approved change orders |
| Variance | Calculated | Forecast − planned; positive means over |
| Status | Calculated | Not started, bidding, signed, in progress or complete, derived from dates and amounts |
Three bids, same scope
A bid comparison only works if the three contractors priced the same thing. Before you enter a number, check that each bid names the same drawings revision, the same allowances for finishes, the same exclusions (site access, debris removal, permit fees) and the same payment terms. In the sheet, one block per trade with up to three bids: the lowest is highlighted, the selected one is flagged, and two differences are calculated, against the lowest bid and against your plan. Selecting a higher bid is sometimes the right call; the sheet simply makes the cost of that choice visible.
Change orders and the expected final cost
A change order is any signed modification of the contract: a scope change you asked for, an unforeseen condition (rock during excavation, a failed soil test), or a selection above its allowance. Log each one with its trade, amount, schedule impact in days, status (requested, approved, rejected) and whether both parties signed. Only approved change orders enter the forecast. The formula is short:
Forecast = selected bid (or plan) + approved change orders. The reserve remaining is the reserve minus the amount by which the total forecast exceeds the total plan. When it turns negative, the dashboard should say so before the next draw, not after. How to keep a change-order log readable over a long project is covered in Renovation budget template: how to handle change orders without losing track.
Draw schedule and caps
When a new build is financed by a construction loan, the money is paid out in several advances. The Consumer Financial Protection Bureau's TILA-RESPA Integrated Disclosure FAQs (construction-loan questions updated 31 May 2019, page last modified 15 March 2024) describe construction-only loans as usually shorter-term loans with "several fund disbursements", the consumer paying only accrued interest until construction is completed, and construction-permanent loans as loans that convert to permanent financing once construction is completed. The same FAQs state that most closed-end consumer mortgage loans to finance home construction that are secured by real property are covered by the TRID rule; in that case you receive a Loan Estimate and a Closing Disclosure. Ask the lender for its disbursement stages in writing and copy them into the spreadsheet.
In the sheet, each draw request carries its stage (foundation, framing, dry-in, rough-ins, finishes, final), the amount requested, the percentage of that stage you or the inspector verified on site, and whether a lien waiver came with it. Two checks protect you: the amount requested should not exceed the cap you set for the stage, and the cumulative paid should not run ahead of the work verified. Lien-waiver rules differ from state to state, so the sheet only records whether you received one. The stage logic, inspections and caps are detailed in Construction draw schedule explained: stages, inspections and caps.
Example (fictitious data)
Four trades of a fictitious single-family build, mid-project. The plan for the whole house was $420,000 with a 10% reserve of $42,000, so a total budget of $462,000.
| Trade | Planned | Selected bid | Committed | Paid | Approved change orders | Forecast | Variance |
|---|---|---|---|---|---|---|---|
| Site work | $22,000 | $24,500 | $26,300 | $24,500 | +$1,800 | $26,300 | +$4,300 |
| Foundation | $38,000 | $36,500 | $38,900 | $36,500 | +$2,400 | $38,900 | +$900 |
| Framing | $62,000 | $65,800 | $65,800 | $32,900 | $0 | $65,800 | +$3,800 |
| Roofing (not signed) | $18,000 | $17,200 | $0 | $0 | $0 | $17,200 | −$800 |
| Four trades | $140,000 | $144,000 | $131,000 | $93,900 | +$4,200 | $148,200 | +$8,200 |
Reading: the four trades are $8,200 over plan, so if the other trades stay on plan the reserve remaining is $33,800 of $42,000. Committed includes the approved change orders on site work and foundation; roofing is not committed yet, so its $17,200 bid is only a forecast. Framing is half paid and 50% of the work is verified, which justifies $32,900: a further request of $12,100 would bring the cumulative paid to $45,000, ahead of the work, and the sheet flags it. None of these figures is a benchmark; they exist to show the mechanics.
Building in the United Kingdom instead? The same logic, with quotes, variations, stage payments and the VAT rules to check, is in Self-build budget spreadsheet (UK): trades, quotes, variations and stage payments.
FAQ
How much contingency should a new home construction budget include?
No single percentage fits every build, and your lender may set its own requirement in the loan terms. The spreadsheet described here uses 10% of the planned trades as an editable default; what matters is that the reserve sits on its own line, is consumed only when the total forecast exceeds the total plan, and shows how much remains on the dashboard.
Should the spreadsheet track the construction loan too?
Yes, at the level of the draw schedule. Your Loan Estimate and Closing Disclosure give the loan terms. Copy the lender's stages and amounts into the draw tab and compare each request with the stage cap and the verified progress.
Where do national housing figures fit in a personal build budget?
Only as context. The U.S. Census Bureau's New Residential Construction release (consulted 19 October 2026) reports new privately-owned housing units authorized by permits, started, under construction and completed, nationally and by region; it says nothing about your lot or your builder. Only your bids and change orders belong in the forecast.