Back to Property Dash Guides

construction tracker

How to Track Your Home Build Budget Without a Spreadsheet You'll Abandon

Self-build budgets don't fail in one dramatic moment - they drift, one variation at a time. Here's how to structure a build budget, what to track weekly, and why most spreadsheets get abandoned by month three.
6 min read
How to Track Your Home Build Budget Without a Spreadsheet You'll Abandon

Almost nobody blows a build budget in a single decision. It goes in forty small ones: an upgraded window spec here, an extra ยฃ900 for drainage there, a tile choice that seemed like a rounding error, a two-week delay that quietly adds another month of rent. Each is defensible on its own. Together they're the reason self-builds routinely land 15โ€“25% over the original figure.

What separates the builds that stay on plan isn't discipline about individual choices. It's knowing the running total on the day you make each one.

Build the budget in four layers, not one number

A single "budget: $310,000" tells you nothing when you're deciding about underfloor heating in month five. Break it into layers that let you see where the pressure actually is.

Layer 1 โ€” hard costs. Everything physically built: groundwork and foundations, structural frame, roof, external envelope, windows and doors, first fix plumbing and electrics, insulation, plaster, second fix, kitchen, bathrooms, flooring, decoration, landscaping.

Layer 2 โ€” soft costs. The 10โ€“15% that people forget entirely: architect and engineer fees, planning applications, building control, surveys, warranty and insurance, utility connections, legal fees, skip hire and site facilities, scaffolding, and finance costs while you build.

Layer 3 โ€” contingency. Ten percent minimum on a new build, and 20% on a renovation, because you cannot see behind existing walls until you open them. This money is not for upgrades. Naming it explicitly is what protects it.

Layer 4 โ€” living costs during the build. Rent or a mortgage on your current home, storage, and the extra commuting. Multiply your realistic monthly figure by your programme plus three months. Almost every build overruns and this is the cost that quietly eats contingency without producing anything.

The four numbers that actually matter

For every category, track four figures rather than one:

  • Budgeted โ€” what you allowed at the start.
  • Committed โ€” what you've signed or ordered, whether or not it's been invoiced. This is the number that predicts trouble, and the one spreadsheets usually omit.
  • Spent โ€” what has actually left your account.
  • Forecast at completion โ€” spent, plus committed, plus your best estimate of what's left to buy.

Forecast at completion is the only figure that answers "are we going to make it?" Spend-to-date always looks reassuring in month three, because you haven't bought the kitchen yet.

Variation orders: where budgets actually die

A variation is any change from what was priced โ€” a spec upgrade, a design change, or something unforeseen once the ground was opened. Three rules keep them under control:

  1. Nothing verbal. Every variation gets written down with a description, a price, and a date, before the work happens. "We'll sort it at the end" is how a build ends up with $18,000 of disputed extras.
  2. Log the cumulative total, not the individual one. Each variation should be recorded against a running figure. The eleventh $1,200 change reads very differently when you can see it takes the total to $14,000.
  3. Decide against the forecast. Before approving anything, look at forecast at completion. If it's already above budget, the question is not "can we afford $1,200" but "what comes out to pay for it."

Payments and cash flow

Agree a payment schedule tied to completed stages โ€” foundations complete, frame up, roof watertight, first fix done โ€” rather than dates. Never let payments run ahead of work done on site; that's the exposure that hurts if a contractor fails mid-build. Hold a retention of around 5% until snagging is finished, and keep every invoice, receipt, and warranty in one place as you go rather than reconstructing it later for your warranty provider or an eventual sale.

If you're drawing down a self-build mortgage, map the release dates against your payment schedule at the start. A stage payment due three weeks before the lender's valuer visits is a cash-flow problem you can only solve in advance.

Track the programme alongside the money

Time and cost aren't separate problems. A trade that can't start because the previous one overran doesn't just delay you โ€” it adds another month of rent, storage, and finance, and it often means paying a premium to get someone back at short notice.

Keep a simple stage list with planned and actual dates, plus who is on site each week and what they're waiting for. Most delays trace back to a decision the client hadn't made yet: a tile choice, a socket position, a final door schedule. Knowing which decisions are blocking work next week is worth more than any Gantt chart.

Why the spreadsheet gets abandoned in month three

Nearly everyone starts with a spreadsheet, and nearly everyone stops updating it. Not from laziness โ€” the structure just doesn't survive contact with a real build. Committed costs don't have an obvious column. Variations get appended in a growing block at the bottom. Receipts live in a phone camera roll. Formulas break when a row gets inserted. Editing it on a phone while standing on a site with no signal is unpleasant enough that you tell yourself you'll do it tonight, and then you don't.

By month four you have a spreadsheet that's six weeks stale, which is worse than none at all, because you'll trust a number that isn't true.

Our Home Construction Project & Budget Tracker is built around exactly these failure points. Budget, committed, and spent per category with a live forecast at completion; a variation log with a running total; a stage-by-stage timeline; contractor and payment tracking; and a materials list with a moodboard for the decisions you're being chased on. It's a single HTML file that works offline on a PC or tablet โ€” no account, no subscription, and your build data stays on your own machine.

The weekly review that keeps it honest

Fifteen minutes, same day each week:

  1. Enter every invoice and receipt from the last seven days.
  2. Add anything newly committed โ€” ordered, not yet paid.
  3. Log any variation agreed on site, with its price.
  4. Update actual stage dates against planned.
  5. Read the forecast at completion and the contingency remaining.
  6. Write down the decisions you must make before next week.

Fifteen minutes a week is the entire discipline. It won't stop costs rising โ€” nothing does โ€” but it means you find out in week nine instead of week thirty, while you still have choices.

Not building yet? See our guides to comparing houses side by side and planning a move in eight weeks.

Get the Home Build Tracker โ€” $25.00, instant download, works offline

Share X Facebook LinkedIn