Tracking your renovation costs doesn't require expensive software — a well-set-up spreadsheet can do the job brilliantly. Whether you're refreshing a kitchen or tackling a full home renovation, using a spreadsheet from day one helps you stay on budget, spot cost blowouts early, and keep records that a tradesperson or quantity surveyor can review if needed.
The Best Spreadsheet Tools for NZ Homeowners
There are three main options worth considering:
- Google Sheets – Free, cloud-based, and accessible from any device. Ideal if you want to share the budget with a partner or builder in real time. Google Sheets also autosaves, so you won't lose data.
- Microsoft Excel – The industry standard for cost tracking. If you already have Microsoft 365, Excel offers more advanced formulas and pivot tables for larger, more complex projects. Templates are available through Microsoft's template library.
- LibreOffice Calc – A free, open-source desktop alternative to Excel. Works well offline and opens Excel files without issues.
For most homeowners managing a single renovation, Google Sheets is the easiest starting point — it's free, shareable, and works on your phone.
Key Columns to Include in Your Renovation Budget Spreadsheet
A good renovation cost tracker should capture the following information. Here's a simple structure to get you started:
| Column | What to Record |
|---|---|
| Category | E.g. Framing, Plumbing, Painting, Tiling |
| Description | Specific item or task |
| Supplier / Tradesperson | Who you're buying from or hiring |
| Quoted Amount (excl. GST) | Original quote |
| GST | 15% of quoted amount |
| Total Quoted (incl. GST) | Full cost |
| Actual Paid | What you actually spent |
| Variance | Difference between quoted and actual |
| Notes | Consent required? Variation approved? |
Keep a running total row at the bottom using a SUM formula, and add a separate cell showing your overall budget so you can see at a glance how much headroom you have left.
Setting Up Your Budget Categories
Organise your spreadsheet by trade or work area. Common categories for a NZ renovation include:
- Consents & fees (building consent, council fees — always check with your local council whether consent is required; some work falls under Schedule 1 exemptions, but confirm this before starting)
- Demolition & site preparation
- Structural / framing
- Roofing & cladding
- Plumbing & drainage
- Electrical
- Insulation
- GIB / plasterboard & stopping
- Tiling & waterproofing
- Painting & decorating
- Joinery & cabinetry
- Flooring
- Fixtures & fittings
- Landscaping
- Contingency (typically 10–15% of total budget)
Always include a contingency allowance. Renovations in New Zealand — particularly in older homes — frequently uncover unexpected issues such as substandard framing, moisture damage, or asbestos-containing materials. BRANZ research consistently highlights that cost overruns are common, especially in pre-1980s housing stock.
Tracking Quotes vs Actuals
One of the most valuable habits is recording every quote you receive and then updating the spreadsheet when invoices arrive. This lets you:
- Identify which trades are running over budget
- Spot variations (changes to the original scope) before they add up
- Have accurate records if a dispute arises
Create a separate tab in your spreadsheet for variations — any changes to the agreed scope of work should be documented in writing and reflected in your budget tracker.
Tracking Materials Separately
If you're supplying some materials yourself (for example, buying paint from Resene or Dulux, or picking up timber from PlaceMakers or Mitre 10), keep a separate tab for owner-supplied materials. Record the receipt date, supplier, product, and cost. This prevents double-counting if your tradesperson also quotes for materials.
Consent and Compliance Costs — Don't Forget These
Building consent fees, engineering reports, and code compliance certificates are real costs that homeowners often overlook. Check MBIE Building Performance for guidance on what work requires consent, and always confirm with your local council. Restricted building work — such as structural, weathertightness, and certain other work — must be carried out or supervised by a Licensed Building Practitioner (LBP), and their fees should be included in your budget.
A Note on Restricted Work
Some renovation work in New Zealand is legally restricted to licensed professionals:
- Electrical work must be carried out by a registered electrician (check EWRB). Homeowners can do very limited DIY electrical work — confirm what's permitted before starting.
- Plumbing, gasfitting, and drainlaying must be done by a licensed tradesperson registered with the PGDB.
- Restricted building work requires an LBP.
Always include the cost of licensed tradespeople in your spreadsheet — attempting restricted work yourself is illegal and can affect your insurance and ability to sell your home.
When to Call a Professional
A spreadsheet is a great self-help tool, but for larger or more complex renovations — particularly those over $100,000 or involving multiple trades — consider engaging a quantity surveyor (QS). A QS can prepare a detailed cost plan, review contractor quotes for reasonableness, and help you manage variations. You can find qualified quantity surveyors and other tradespeople on tradedirectory.co.nz.
If your project requires building consent, your local council or a licensed building practitioner can advise on compliance costs you may have missed.
Site Safe
Licensed Building Practitioner (LBP)
ISO 9001 / 45001 / 14001
NZ Institute of Building (NZIOB)
