~/construction-budget-tracker invoice margin ☕ Support me apps ← about me

🏗 Construction Budget Tracker

Drop in your Excel file and see budget vs actual per trade, spending over time against plan, open invoices and what needs attention. Edit here, export back to the same simple Excel file. Saved in your browser, never uploaded.
⬇ Template
● saved in this browser
Show
Amounts
Budgets are excl. VAT, so invoices are compared excl. VAT too.

Budget vs actual — by trade

paidpendingoverduebudget
Click a trade to see its invoices, change its phase 1 and phase 2 budget, move budget to phase 2 or add an invoice for it.

Spending over time

invoiced (cumulative)paidplan: budget spread over the build

Needs attention

Where the money goes

share of invoiced cost

Trades & budgets

edit in place
TradePhase 1Phase 2

Invoices

DateSupplierTradePhase Excl. VATVATIncl. VAT StatusNotes

+ Add invoice

Tip: click a row to edit it, click a status badge to switch paid → pending → overdue.

Guide — from Excel file to overview in a minute

Five steps to see where your build budget stands.
1Get the template

Press Template for the empty Excel file, or keep using one you exported from here earlier. Fill in Setup, your trades with their budgets, and your invoices.

2Import it

Press Import Excel or drop the .xlsx anywhere on the page. A short report shows how many trades and invoices were read and what was skipped.

3Read the overview

Bars show budget vs actual per trade, split into paid, pending and overdue. The timeline compares spending with the plan; the alerts list what needs action.

4Click and edit

Click a trade for its invoices, change a budget in place or move part of it to phase 2, add invoices, or click a status badge to mark an invoice paid.

5Export back to Excel

Press Export Excel to get the same simple four-sheet file, ready to share with your partner, architect or bank.

What the Excel file contains

SHEETSFour plain sheets

No macros, no hidden tabs. Columns you add yourself are ignored on import.

Setup
project name, total budget, currency, VAT %, start and end date of phase 1 and phase 2
Categories
one row per trade with its phase 1 and phase 2 budget excl. VAT
Invoices
date, supplier, trade, amount excl. VAT, VAT %, status, notes, phase
Summary
totals, written on export
STATUSPaid, pending, overdue

Every invoice has one of three states.

paid
money has left your account
pending
received, not yet due or not yet paid
overdue
past its due date; shown first under Needs attention
VATExcl. or incl. VAT

Budgets are entered excl. VAT, so invoices are compared excl. VAT by default.

excl.
like-for-like with the contractor's quote
incl.
what actually leaves your bank account
PHASESPhase 1 and phase 2

Every trade has a budget for each phase, so costs you postpone move to the next chapter instead of disappearing.

Show
Phase 1, Phase 2 or Whole project; every number follows
→ Phase 2
moves budget from phase 1 to phase 2; the trade's total stays the same
⇥
moves what phase 1 has not invoiced yet
P1 / P2
the phase of an invoice; click to switch

How to track a construction budget, explained

A construction budget tracker answers three questions while you build or renovate: how much of each trade's budget is already used, how much is still to be paid, and whether the project as a whole is heading over budget. This page reads those answers from a plain Excel file. You keep the file as the record you share and archive; the page turns it into an overview you can click through.

Budget vs actual per trade

Each trade (shell, roofing, windows, electrics, plumbing, kitchen and so on) gets one bar. The bar's length is what has been invoiced so far, split into paid, pending and overdue, and the thin vertical marker is the trade's budget. When invoices pass the marker, the part above budget is hatched in red. Sort the bars by largest budget, percentage used, most over budget or most remaining, and click one to see its invoices and stats.

Spending over time against plan

The timeline adds up invoices by date: the cyan line is everything invoiced, the green line what has been paid. The dashed plan line spreads the total budget evenly from the start date to the end date. That is a simple reference, not a forecast: real builds spend unevenly, with big invoices for the shell and roof early on and finishes at the end. The dotted projection extends the average spending pace so far to the end date. Use both as a prompt to look closer, not as a prediction.

Two phases: push costs to a next chapter

Many builds happen in two steps: the house first, and the garden, driveway or attic a year or two later when the budget allows. Each trade therefore has a phase 1 and a phase 2 budget, and each invoice belongs to one phase. When you postpone part of the work, open the trade and press → Phase 2, or press ⇥ in Trades & budgets to move everything phase 1 has not invoiced yet. The trade's total stays the same, so the project budget does not change. When phase 1 is finished, ⇥ Push unspent phase 1 to phase 2 does this for every trade at once; undo reverses it.

The Show switch above the overview picks Phase 1, Phase 2 or the whole project. The KPIs, trade bars, timeline, donut, alerts and invoice list then count only that phase, while the strip under the switch keeps both phase totals in view. Each phase has its own start and end date: in a phase view the plan line spreads that phase's budget over its own dates, and in the whole-project view the plan line is phased, with the phase 2 period shaded. In the bars of the whole project, the hatched part of a trade's budget is reserved for phase 2.

Excl. or incl. VAT

Quotes and budgets are usually compared excluding VAT, because that is how contractors price their work and because VAT rates can differ per invoice (in Belgium, for example, renovations of homes older than ten years can qualify for 6% instead of 21%). The overview therefore compares invoices excl. VAT with budgets excl. VAT by default. Switch to incl. VAT to see what will actually leave your bank account; budgets are then raised by the project VAT rate from Setup.

Keep a contingency

Almost every build meets surprises: soil conditions, price rises, a change of mind about the tiles. A separate Contingency trade of roughly 5–10% of the budget for a new build, and more for renovations of older houses, keeps those costs visible instead of hiding them inside other trades. If the project has no such trade, the alerts suggest one.

Importing your own Excel file

The importer looks for sheets named Setup, Categories and Invoices and finds the header row on its own, so title rows, a TOTAL row and instruction lines are skipped. Dates may be real Excel dates or text such as 14/03/2026 (day first); amounts may use a decimal comma such as 12.500,50 or dots for thousands such as 12.500. A total line under your invoices (TOTAL, Totaal, or a row with only an amount) is skipped, so it is not counted twice. The exported file compares invoices with budgets excl. VAT, like the dashboard, and adds the incl. VAT totals next to them. Invoices for a trade that is not in Categories are kept and the trade is added with budget 0, so nothing goes missing. Optional phase columns are read when present: Phase 2 budget in Categories, Phase (1 or 2) in Invoices, and Phase 2 Start Date and Phase 2 End Date in Setup. A file without them loads with everything in phase 1. After the import a report lists what was read; Undo import restores the previous state.

Privacy

The Excel file is read and written in this browser tab with the open-source SheetJS library, which loads from cdnjs. Your project is saved in this browser's local storage so it is still there next time; it is not sent to a server and there is no account. The page also loads cookie-free page-view analytics, which receive no budget data. Clearing the browser's site data removes the project, so export to Excel now and then as a backup.

More money tools

Make invoices with the invoice generator, or count the days between two dates with the days between dates calculator.

Invoice GeneratorMake a PDF invoice Percentage CalculatorIncreases, discounts, shares All tools →Every free tool on jasperbernaers.com
⬆ Drop your Excel fileSetup, Categories and Invoices sheets are read in this browser