Why a spreadsheet beats a carrier bag of receipts

Most renovation budgets don't fail in one dramatic moment. They leak. Forty pounds here for extra adhesive, a hundred and eighty for a skip you'd forgotten to budget, a plumber's invoice that's slightly higher than the figure you remember agreeing. Six weeks later you're standing in a builder's merchant trying to work out whether you can afford the tiles you actually want, and you genuinely don't know.

A single spreadsheet, updated little and often, solves most of that. It won't stop the surprises, but it gives you one number you can trust: how much of your budget is left, and how much of your contingency you've already eaten. That's the difference between making calm decisions and making panicked ones.

Set up your tracker before the first skirting board comes off

Build the file on the weekend before work starts, not the day the invoices begin arriving. One workbook, four tabs is plenty:

• Costs — every actual and committed cost, one line per item.
• Quotes — every quote you've received, with the date and how long it's valid for.
• Contingency — a running log of anything paid for out of your reserve.
• Suppliers — names, phone numbers, and notes on who's been reliable.

The Costs tab is the workhorse. Useful columns: date, supplier, category (structural, electrics, plumbing, kitchen, decoration, waste), description, quoted amount, invoiced amount, paid amount, whether VAT is included or on top, payment method, and a yes/no column for whether it came out of contingency. Add a free-text notes column for invoice references and anything you might need to query later.

Set up a folder on your phone or laptop with a subfolder for each month. Every receipt goes in there, photographed the day you get it. Paper receipts fade; a photo doesn't.

Log quotes, invoices and receipts the day they land

A quote isn't a cost — but it's a commitment waiting to happen, so it belongs in the Quotes tab with the date and expiry. When you accept it, it moves to Costs as a committed figure. When the invoice arrives, you record that. When the money actually leaves your account, you date it.

Those three stages matter because "we've spent twelve grand" can mean three very different things. Keeping them separate also means you spot the gap between what was quoted and what was invoiced while it's still small enough to question politely.

Once a month, download your bank statement and tick every payment off against a line in the tracker. Anything unaccounted for gets investigated that week, not in three months' time.

Track variations separately — they are where budgets die

An extra socket. A boiler upgrade. A joist that turns out to be rotten behind the plaster. These are variations, and they are the single biggest reason renovations overshoot. Give them their own block of rows, or a tab if you prefer, with the date, who instructed the change, the agreed price, and whether it's coming out of contingency.

Get every variation confirmed in writing — an email or a text message is fine, as long as the price and the scope are clear. Never let one sit as "we'll sort it out at the end". By then nobody remembers the number, and you'll pay whatever's asked.

Review your contingency at every milestone

Most people set a contingency of 10–15% of build cost. For period properties, anything involving a loft conversion, or any project where you're opening up walls you've never seen inside, 20% is more honest.

Then check it at fixed points, not randomly. Sensible milestones:

• Strip-out and structural work complete
• First fix signed off (electrics, plumbing, heating)
• Plastering done and floors down
• Second fix, kitchen and bathrooms installed
• Snagging and handover

At each one, total your committed and actual spend, compare it with the plan, and look at how much contingency is left. A useful rule of thumb: if you've burned through more than a third of your reserve before first fix, pause and reassess. It's much easier to downgrade a worktop than to run out of money with no working shower.

Keep it going when the project gets messy

Renovations have a way of turning orderly plans into chaos by week three. The trick is to make the tracking small enough that you'll actually do it. Fifteen minutes every Sunday evening is usually enough: log the week's invoices, file the receipts, update the contingency total, and note anything you're waiting on.

If you're using a main contractor, ask for a monthly cost report and check it against your own sheet — it's not distrust, it's just sensible. If you're managing trades yourself, your spreadsheet is the only report that exists. Make it a rule: no payment without a line in the tracker first.

Do that, and you'll finish the job knowing not just what it cost, but why. That's a surprisingly rare feeling — and a genuinely good one.