Spreadsheet template

Home Renovation Budget Tracker

Estimate against actual, room by room. Builder and contractor bids compared on true all-in cost instead of headline price. A change-order log that revises the budget line it affects, and a contingency meter that turns amber before your bank account does.

It works in any currency and in any country. The currency is a dropdown of eleven codes on the Setup tab, or your own symbol typed in, and every money heading and both chart axes follow it. No tax rate, no permit regime and nobody else’s prices are written into the arithmetic.

€13one-time · not on sale yet

One .xlsx file 6 tabs No macros Excel · Google Sheets · LibreOffice Any currency
Checkout opens shortlyEmail support@vendwright.com to be told when this template goes on sale. Try the free calculator

Checkout is not open yet, so this file cannot be bought today. When it opens, checkout and delivery are handled by our payment processor and the download link appears as soon as payment clears. No account, no subscription.

Product cover: the Home Renovation Budget Tracker dashboard, showing four KPI tiles, a room summary table and two charts.

Renovations do not go over in one line. They bleed.

It goes in small amounts, in three places, over months. The workbook is built around those three.

The bid that was never comparable

One contractor includes materials, one does not, one absorbs the permit fee. The cheapest base bid is often the most expensive job. The Quote Comparison tab normalises all three to a true all-in cost before you sign anything.

The change nobody logged

Verbal changes add up to a number you first meet on the final invoice. Log each one, mark it approved, and the revised budget on the line it affects moves with it.

The contingency you spent by March

Most people set a contingency and never look at it again. The dashboard tile turns amber once 75% of the buffer is committed, and red when scope growth has eaten the lot.

What it does

  • Tracks up to 200 budget lines, each tagged with a room and a trade, with estimated cost, contracted price, revised budget, paid to date and remaining side by side.
  • Colours the variance column automatically: green under estimate, amber within 5% over, red beyond that.
  • Compares up to three builder or contractor bids per work package on true all-in cost (base bid, plus excluded materials, plus permit, planning and disposal fees) and names the best value in writing.
  • Rolls approved change orders into the revised budget of the line they affect, so the budget you are looking at is the current one.
  • Logs 300 payments with payee, method and invoice reference, and highlights any invoice reference that appears twice.
  • Rolls paid-to-date up per budget line, per room and per trade without you writing a single formula.
  • Shows revised budget, paid to date, contingency remaining and percent complete by spend on one dashboard, plus estimate-versus-paid by room and where the money went by trade.
  • Ships with a full 12-month sample project you can read, understand, and then clear in about a minute.

Who it is for

A homeowner's tool, written from the side that pays the invoices.

A good fit if

  • You are renovating your own home, or a rental, and you are the one paying the invoices.
  • You have more than one contractor quoting, or one contractor and several trades.
  • The project runs over months, not a weekend, so the difference between estimated, contracted and paid actually matters.
  • You are comfortable typing numbers into a spreadsheet. That is the whole skill requirement.

Not a good fit if

  • You want it to tell you what a kitchen costs. It holds no price data at all. You supply the quotes and it does the arithmetic. Use the free contingency calculator for a planning number.
  • You are a contractor billing clients. It is written from the paying side, with no invoicing, retention or margin tracking.
  • You want bank feeds, receipt scanning or a phone app. It is a spreadsheet you type into.
  • You want to run the whole project from a phone. It opens in the Google Sheets app, but it is laid out for a laptop screen.

What is inside, tab by tab

Six linked tabs. Nothing hidden, locked or password protected.

1. Instructions

One page: what to fill in first, what each tab is for, how to import into Google Sheets, and how to clear the sample project.

2. Setup

Project name, dates, total budget, and a contingency percentage validated to 5–30% so a stray keystroke cannot quietly break the meter. The rooms, trades and statuses are ordinary editable lists. Overwrite them with your own.

3. Budget Lines

The master sheet. One row per piece of work, 200 of them, with your estimate, the contracted price, approved changes, what has been paid and what is left. Most of the row is formulas. Empty rows look empty instead of showing a wall of zeros.

4. Quote Comparison

Twenty blocks of three bids. Enter the base bid, whether materials are in it, the permit and disposal fees and the timeline. The block gives you a true all-in cost per bidder and names the best value in writing, which is usually not the cheapest bid.

5. Change Orders + Payment Register

Two registers on one tab. Approved change orders flow into the revised budget of the line they hit; rejected ones grey out and stay on the record. Underneath, 300 payment rows, where an invoice reference entered twice is highlighted in amber.

6. Dashboard

Revised budget, paid to date, contingency remaining and percent complete by spend, over a room table, a trade table and two charts. The contingency tile changes colour on its own as the buffer goes.

Screenshots

From the sample project the file ships with. Every number here is sample data you type over.

Dashboard tab: four dark KPI tiles reading total revised budget, paid to date, contingency remaining and percent complete, above a room summary table, a trade summary table, a clustered bar chart of estimate versus paid by room and a pie chart of spend by trade.
Budget Lines tab: a wide table of renovation line items grouped by room and trade, with columns for estimated cost, contracted price, approved change orders, revised budget, paid to date, remaining, variance versus estimate and status.
Quote Comparison tab: three comparison blocks, each listing contractor names, base bid, whether materials are included, estimated materials, permit and disposal fees, timeline in weeks, a bold true all-in cost row and a best-value line naming one contractor.
Change Orders and Payment Register tabs side by side: a change-order table with cost impacts in red for increases and green for credits, one rejected row greyed out, next to a long payment register listing payee, line ID, method, invoice reference and amount.

Specifications

Everything you are buying, in one table.
Format One .xlsx workbook, 6 tabs. No macros, no add-ins, nothing to install.
Works in Excel 2010 or later (Windows and Mac), Google Sheets via File › Import › Replace spreadsheet, and LibreOffice Calc. Only cross-compatible formulas are used: SUMIF, SUMIFS, INDEX/MATCH, COUNTIF.
Capacity 200 budget lines, 20 quote comparison blocks of 3 bids each, 100 change orders, 300 payments.
Charts Two: estimate versus paid by room, and paid by trade. Both native spreadsheet charts that survive the Google Sheets import.
Currency A dropdown on the Setup tab (EUR, GBP, USD, CAD, AUD, CHF, SEK, NOK, DKK, PLN, NZD), plus a cell for a symbol that is not on the list. Every money heading and both chart axes follow it. Not one cell carries a hard-coded currency, so nothing goes stale when you switch.
Sample data A complete 12-month project, “Maple Street House”, with 34 budget lines, 6 change orders and a full payment history. Clearing it is a documented two-minute job.
Delivery Not on sale yet. When checkout opens: instant download after payment, no account to create.
Price and updates €13 once, with no subscription. There is no update service: what you download is the file as it stands on the day you buy it. If we ever publish a corrected version of a file you already bought, email us and we will send it.
Licence Buy once, use it on your own projects for as long as you like. Not for resale or redistribution. See the terms.
Support Email support@vendwright.com and you will get a fix or a straight answer.

Questions

Does it tell me what my renovation should cost?

No, and be wary of anything that claims to for your street. The workbook holds no price data. You enter your own quotes; it does the tracking and the arithmetic. If you want a planning number before the quotes arrive, the free renovation contingency calculator will size a buffer for you.

Will it really work in Google Sheets?

Yes. Open Sheets, choose File › Import › Upload, pick the file and select “Replace spreadsheet”. Every formula is from the cross-compatible set, so the dropdowns, conditional colours and both charts come across. There are no macros to be stripped out, because there are none.

Can I change the rooms and trades?

Yes. They are ordinary lists on the Setup tab, and they feed every dropdown in the workbook. Type over the entries. One rule: blank a row rather than deleting it, or the list shrinks under the dropdowns.

What happens if I need more than 200 budget lines?

Most home projects use 30 to 60. If you really need more, copy the last row down and widen the SUM ranges on the Dashboard, which is a find-and-replace of one row number. It is a chore. 200 lines is a deliberate ceiling rather than a technical limit.

How does the contingency meter actually work?

You set a total budget and a contingency percentage on Setup, and the contingency amount is calculated from those two. The Dashboard tile then subtracts the amount your revised budget has grown beyond your original estimates, in other words the approved change orders. The tile turns amber when less than 25% of the buffer is left and red when the growth exceeds it.

Is the sample project in the way?

It is there so you can see a filled-in project behave before you trust it with yours. The Instructions tab names the ranges to clear, it takes a couple of minutes, and nothing breaks: the formula columns are not part of what you delete.

Does it handle VAT or sales tax?

Not as a separate calculated column. Enter your quotes the way you received them. If they are tax-inclusive, the whole workbook is tax-inclusive and stays consistent. Mixing inclusive and exclusive quotes in the same budget is the one thing that will mislead you, and no template can fix that for you.

Can I use it on my phone?

It opens in the Google Sheets and Excel mobile apps, and logging a payment on site works fine. Reading a 13-column budget table on a phone does not. It is laid out for a laptop screen.

Refunds?

It is a digital file that downloads instantly, so it cannot be returned in the usual sense. If it does not do what this page says it does, email support@vendwright.com and you will get your money back without an argument. Full detail on the refunds page.

Are there reviews I can read?

Not yet. It is a new product and we are not going to invent any. The screenshots above are the real file, the specifications table is exact, and the free calculator shows you how we think before you spend anything.

Home Renovation Budget Tracker

One .xlsx file, six tabs, no macros, no subscription. €13, and a refund if it is not what this page described.

Checkout opens shortlyEmail support@vendwright.com to be told when this template goes on sale. Size your contingency first