Home Renovation Cost Spreadsheet: Plan the Overrun

Hey folks, it's Ren here. Right now I'm picturing a kitchen with no kitchen in it. The cupboard doors are stacked in the hallway, the kettle is plugged in on the floor, and there's a printed quote taped to the one wall still standing.

That quote felt like a plan when it was signed. Three weeks in, it feels like a fairytale.

This is the moment most people wish they had started a home renovation cost spreadsheet before the first wall came down, not after the first surprise invoice.

"A budget is telling your money where to go instead of wondering where it went." — John Maxwell

🧾 Why isn't a renovation quote a budget?

A quote is a snapshot of one moment, priced on assumptions that start changing the day work begins. It is the starting line, not the finish.

The trouble is that a quote reads like a total. One confident number at the bottom, signed and filed, and the planning stops there.

Then real life happens.

The plumber opens the wall and finds pipes that should have been replaced a decade ago. You fall for a benchtop that costs more than the one the quote assumed. A light switch moves half a metre and becomes a variation. None of these are anyone behaving badly, they are just the normal texture of a renovation, and a single-number quote has nowhere to record them.

• Quotes bundle a dozen trades into one figure, so you cannot see which part is drifting.
• Prime-cost items are placeholder prices, not your actual choices.
• Variations get agreed verbally on site and forgotten until the invoice.
• There is no contingency inside a quote, so the first surprise comes straight out of your savings.

Please do not be hard on yourself if you signed a quote and called it a budget. Almost everyone does. The fix is simply to give every one of those moving parts a row of its own.

📐 What does a home renovation cost spreadsheet track?

A home renovation cost spreadsheet breaks the job into rooms and trades, then holds three numbers against each one: what it was quoted, what it actually cost, and the gap between them. That gap is the whole point.

Add a contingency line and a running total, and the sheet stops being a record of the past and becomes an early warning system.

Here is the shape of it. Every line is a trade or an item, and the columns do the thinking for you.

Column	What it does
Room / trade	One line each: cabinetry, benchtop, plumbing, electrical, tiling, painting, rubbish.
Quoted	The figure from the quote, locked and never edited.
Actual	What the invoice really said, entered the day it lands.
Variance	Actual minus quoted, so an overrun shows in red the moment it happens.
Type	Fixed, prime-cost, or variation, so you can see where the drift clusters.
Contingency	A separate 15 to 20 percent buffer that absorbs the surprises.

💸 Where the overrun actually comes from

The overrun on a renovation almost never comes from the fixed-price trade labour, it comes from the items you choose and the changes you ask for. Once you see it split that way, the whole budget behaves differently.

Let me show you with a real shape of numbers. A modest kitchen, quoted at $23,900, that finished at $28,600. A $4,700 overrun, just under 20 percent.

Trade or item	Quoted	Actual	Variance
Cabinetry (fixed)	$8,500	$8,500	$0
Stone benchtop (prime cost)	$3,200	$4,050	+$850
Appliances (prime cost)	$4,000	$5,600	+$1,600
Tapware and sink (prime cost)	$900	$1,450	+$550
Plumbing (moved sink, variation)	$1,800	$2,350	+$550
Electrical (extra points, variation)	$1,500	$1,950	+$450
Tiling and splashback	$2,200	$2,600	+$400
Painting (fixed)	$1,200	$1,200	$0
Rubbish removal	$600	$900	+$300
Totals	$23,900	$28,600	+$4,700

Look at the two fixed lines. Cabinetry and painting came in exactly on quote, to the dollar. The tradespeople priced their labour and honoured it.

Every cent of the $4,700 overrun sits in three places. The prime-cost items you picked yourself, the benchtop, appliances and tapware, ran $3,000 over on their own. The variations you asked for mid-job, the moved sink and extra power points, added $1,000. And the odds and ends of a job in progress, extra tile cuts and a second skip, made up the last $700.

Here is the part that changes how you budget. A standard 10 percent contingency on that quote is $2,390. It would have covered barely half the overrun. The people who finish near budget are not luckier, they simply hold 15 to 20 percent and they price the prime-cost items at the top of a real range, not at the placeholder the quote used.

There is a rhythm to when the overruns land, and it is worth knowing. The structural surprises tend to show up early, when walls open and floors come up, so if you clear that stage without a shock you can breathe a little. The choose-it-yourself blowouts come later, at fit-off, when the benchtop and tapware finally get ordered. Knowing that order is useful, because it lets you hold most of your contingency back for the second half of the job instead of spending it in week one and hoping.

🛠️ How do you set it up, room by room?

Setting up a home renovation cost spreadsheet takes about twenty minutes and one honest look at the quote. Do it before the first invoice, while every line is still just a plan.

1. List every room and trade on its own row. Break the quote apart into cabinetry, benchtop, plumbing, electrical, tiling, painting and rubbish, so nothing hides inside a bundled figure.
2. Put the quote in one column and leave an actual column blank. The quoted number gets locked and never edited, and the blank actual column is what you will fill in as invoices arrive.
3. Flag the prime-cost and provisional-sum items. Mark the lines where the price is a placeholder for something you still have to choose, because those are the rows most likely to run over.
4. Add a contingency line at 15 to 20 percent. Give the buffer its own row so it is visible and deliberate, not a vague hope that the savings will stretch.
5. Log actuals the day each invoice lands. Enter the real figure while the paperwork is in your hand, because a renovation moves too fast to reconstruct from memory later.
6. Watch the variance total, not the quote. The running gap between quoted and actual is your true position, so read that number and let the original quote fade into history.

⚠️ Mistakes to sidestep

• Treating the quote as the budget. Fix it: copy the quote into a locked column and budget against the variance, not the total.
• Setting contingency at 10 percent. Fix it: start at 15 to 20 percent on a renovation with any prime-cost items, and be glad if you do not need it.
• Pricing prime-cost items at the placeholder. Fix it: go and get the real price of the benchtop and appliances you actually want before you commit the budget.
• Agreeing variations on site and not writing them down. Fix it: add a row the same day, even a rough figure, so the total stays honest.
• Only checking the numbers at the end. Fix it: a five minute update each week catches a blowout while you can still choose a cheaper tile.

One more habit is worth building while the walls are open. The renovation is adding real value to your home, new cabinetry, better appliances, a benchtop worth insuring, and it is the perfect moment to note all of it down in a home inventory spreadsheet so your cover keeps pace with what the house now holds.

🎯 Your action steps this week

• Open the quote and break it into one row per trade, quoted figure only.
• Add a variance column and a contingency line at 15 to 20 percent.
• Get real prices for the benchtop, appliances and tapware before you lock the budget.
• Set a five minute Sunday reminder to log any new actuals.
• When the dust settles, roll the finished renovation into your ongoing house expenses spreadsheet so the new running costs do not surprise you either.

⚡ Quick answers

How much should I budget for a home renovation?

Budget the full quote plus a contingency of 15 to 20 percent, and price the prime-cost items, the ones you choose yourself, at the top of a realistic range. Most overruns come from those choose-it-yourself items and mid-job changes, so the contingency is where the real budget lives.

What is a good contingency for a renovation?

For a renovation with any prime-cost items, start at 15 to 20 percent rather than the usual 10. Older homes and structural work sit at the higher end, because opening a wall often reveals work that was never in the quote.

Do I need a spreadsheet if the builder gave me a fixed-price quote?

Yes, because a fixed-price quote still carries prime-cost allowances and variations that move the final figure. The spreadsheet tracks the actual invoices against the quote so you can see exactly which lines drifted and by how much.

What are prime cost and provisional sum items?

They are placeholder prices for things not yet chosen or fully scoped, such as tapware, tiles or the exact plumbing run. The quote assumes a number, and your real choice usually costs more, which is why they are the lines to watch.

How do I stop a renovation going over budget?

Track quoted versus actual on every line, log each invoice the day it lands, and read the variance total rather than the original quote. Catching a small drift early lets you choose a cheaper option before it becomes a locked-in cost.

Back to that kitchen in the hallway. The cupboards will go back on the wall, and the kettle will find a bench again.

The difference between the renovations that land near budget and the ones that haunt people is not luck, it is a column that shows the overrun while there is still time to steer.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.