Spreadsheets

Home renovation budget in Excel: room-wise sheet with quotes

A room-wise home renovation budget in Excel with contractor quote, revised quote, paid, balance, separate material cost and a contingency cell.

Editorial illustration for Home renovation budget in Excel: room-wise sheet with quotes

A renovation budget works best with one row per work item, grouped by room, and columns for the contractor's quote, any revised quote, what you have paid, the balance and the material you bought yourself. Add a contingency percentage and a total, and you can see the real cost, not just the headline quote. Here is a layout for a flat repaint with a modular kitchen.

What columns does the sheet need?

  • A Room, B Work item, C Original quote, D Revised quote (blank if unchanged).
  • E Current quote: =IF(D2="",C2,D2)
  • F Paid so far, G Balance: =E2-F2
  • H Material bought separately, I Total cost: =E2+H2
  • J Increase over original: =E2-C2

The Current quote column is the one to trust; the Original column stays untouched so you can see how much a job has grown. Material bought separately is the trap: the contractor's labour quote may exclude tiles, paint, fittings or the sanitaryware you buy at a shop, and these never show up in the quote.

Can you show an example?

RoomWorkOriginal (₹)Revised (₹)Paid (₹)Balance (₹)Material (₹)
KitchenModular kitchen3,20,0003,40,0001,00,0002,40,0000
Living and bedroomsRepaint labour60,000None20,00040,00035,000
BathroomPlumbing and tiling45,00052,00052,000028,000

Current quotes: 3,40,000 plus 60,000 plus 52,000 is ₹4,52,000. Paid so far is 1,00,000 plus 20,000 plus 52,000, or ₹1,72,000, so the balance is ₹2,80,000. Material bought separately is 35,000 plus 28,000, which is ₹63,000. Total committed is 4,52,000 plus 63,000, or ₹5,15,000. Quotes have risen by 20,000 in the kitchen and 7,000 in the bathroom, ₹27,000 in all.

How do I add the contingency and room subtotals?

Put a contingency percentage in a cell, say L1. Use a figure you are comfortable with; 10 percent is only an example, and old flats with hidden plumbing or wiring may deserve more. Then:

  • L2, committed total: =SUM(I2:I30)
  • L3, contingency: =L1*L2. At 10 percent of 5,15,000, that is ₹51,500.
  • L4, planned total: =L2+L3, which gives ₹5,66,500.
  • L5, your budget ceiling, typed in by you, say ₹5,50,000.
  • L6, over or under: =L4-L5, which gives ₹16,500 over.
  • Room subtotal: =SUMIFS($I$2:$I$30,$A$2:$A$30,"Kitchen")

Use the same SUMIFS for each room. The subtotals tell you where the money is going, and a room you have not started should look like a quote, not a surprise.

What do I do when the contractor revises a quote?

Do not overwrite the old figure. Type the new one in Revised quote, and put the reason in a notes column: "chimney added", "wall repair". Ask for the revision in writing or by message so you have a record. A pattern of revisions on the same work item is a reason to ask questions. It is also a reason to raise the contingency percentage for the jobs not yet started.

Add a Status column with Not started, In progress and Done. A balance of zero on work that has not begun usually means an advance was paid in full, which deserves a second look, and a Done row with a balance deserves a conversation.

A weekly review

  1. Update Paid and Balance after every payment.
  2. Add material receipts as you buy them.
  3. Check Increase over original; if it grows each week, talk to the contractor early.
  4. Compare the planned total with your ceiling.

The payments will also show up on your bank statement. SpendixAI can import it, keep receipts with their transactions and give you a category such as Home, which is a handy cross-check on the Paid column.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports