Home Renovation Budget Excel - Free Template

1. Open the Renovation Budget sheet and review the sample rows before replacing them with your own project records. The examples include kitchen cabinets, electrical rewiring and a bathroom suite.
2. Give each line an Item ID and enter the planned date, room or area, category, description, supplier or contractor and town or city.
3. Enter the budget ex VAT in column H and the actual ex VAT in column I. Use the decimal validation on these fields and enter amounts as numbers rather than text.
4. Select a category from the list in column D. The VAT Rate is looked up from Lists & Guidance, while Budget VAT, Actual VAT and totals including VAT are calculated automatically.
5. Record payments in Amount Paid and add useful information, such as a deposit or invoice reference, in Notes. Outstanding balance and payment status then update from the entered figures.
6. Review the Summary sheet during the project. Check total variance, percentage of budget spent, paid items and the category table, supported by the two summary charts.
7. Before relying on the VAT figures, review the editable reference rates and confirm the VAT treatment and quoted prices with each supplier. Keep quotes, invoices and receipts with the project records.

A homeowner can use this workbook to control a kitchen, bathroom or whole-property project without mixing supplier quotes, deposits and final invoices in separate notes. A project manager, landlord or property investor can also use it to compare planned and actual commitments across rooms, trades and professional fees.

The Renovation Budget sheet is suited to a weekly project review. You can filter the records by the planned date, room or area, category, supplier or contractor, or town or city, then check which costs have changed since the last review. The sample data demonstrates the intended level of detail: item 1001 covers kitchen cabinets and installation in Birmingham, with a budget ex VAT of £8,500, an actual ex VAT cost of £8,750 and £4,000 recorded as paid.

Use it before work starts

Before approving a quotation, enter the planned cost in Budget ex VAT and describe exactly what it covers. For example, a bathroom line with a planned ex VAT cost of £3,900 can remain separate from a flooring line, even if both will be installed during the same phase. This gives you a more useful category view than one broad renovation total.

Use Room/Area to distinguish a kitchen from a whole-property job, while Category gives the consistent classification used by the Summary sheet. Supplier/Contractor and Notes provide context when two quotes appear similar but cover different work or payment stages.

Use it during contractor payments

At each payment review, update Actual ex VAT and Amount Paid rather than overwriting the original budget. In the sample electrical row, the budget is £5,250 ex VAT, the actual is £5,100 ex VAT and £6,120 has been paid including the workbook's calculated VAT treatment. The payment and variance fields then show how that line stands against its plan.

This approach is useful when a project has deposits, staged invoices and final balances. It also gives a homeowner a record of whether an apparent underspend is a genuine saving or simply an item where the final invoice has not yet arrived.

The workbook separates entered values from calculated outputs. You enter the planned and actual amounts exclusive of VAT in columns H and I, then select a category in column D. The VAT Rate in column J uses a VLOOKUP against the category and rate list on Lists & Guidance, so the rate is not repeatedly typed into every renovation row.

For a category with a reference rate of 20%, a budget ex VAT entry of £8,500 produces £1,700 of Budget VAT and £10,200 of Budget inc VAT. If the actual ex VAT entry is £8,750, Actual VAT becomes £1,750 and Actual inc VAT becomes £10,500. These are workbook calculations based on the editable reference list, not a determination of the correct treatment for a particular purchase.

Keep inputs and outputs distinct

Do not type over formula columns J to S. Columns K and L calculate VAT from the two ex VAT inputs; M and N add the relevant VAT to the budget and actual amounts. This structure is technically preferable to manually entering totals because changing one underlying cost updates the dependent figures consistently.

Amount Paid in column O is an input. Outstanding in column P subtracts it from Actual inc VAT, treating a blank payment as zero. Status in column Q then returns Not paid, Part paid or Paid. For example, if Actual inc VAT is £10,500 and Amount Paid is £4,000, the outstanding balance is £6,500 and the status is Part paid.

Read the variance correctly

Variance in column R compares Actual inc VAT with Budget inc VAT, while Variance % divides that difference by the budget including VAT. In the kitchen example, the £300 difference between £10,500 actual including VAT and £10,200 budget including VAT is a £300 variance, or approximately 2.94%.

The Summary sheet uses SUM for total budget, actual cost, paid amount, outstanding balance and variance. It uses AVERAGE for average project item cost, COUNTIF for item and paid-item counts, and SUMIF for category totals. The two charts use the category budget and actual ranges, so their figures change when the detailed records change.

A renovation budget becomes unreliable when a quote, invoice and payment are treated as the same figure. If a kitchen contractor receives a £4,000 deposit against an actual including VAT cost of £10,500, entering £4,000 as the actual cost would make the project appear £6,500 cheaper than it is. The correct place for that deposit is Amount Paid, while the full known cost belongs in Actual ex VAT or the appropriate cost input.

Mixing VAT bases distorts comparisons

Another costly error is entering a quoted total including VAT into the ex VAT column. For example, entering £10,200 into Budget ex VAT when £10,200 is already the intended total including the workbook's 20% reference rate causes Excel to add VAT again. The resulting Budget inc VAT would be £12,240 rather than the intended £10,200.

Use the Notes field to record whether a supplier's figure was quoted as ex VAT or including VAT, then enter it on the correct basis. The Lists & Guidance sheet specifically advises you to confirm quoted prices and VAT treatment with each supplier.

Category drift hides overspending

If one bathroom purchase is entered as Bathroom and another as Other, the category analysis no longer represents the project. A hypothetical project with £6,000 of bathroom work split into £4,500 under Bathroom and £1,500 under Other would understate the Bathroom total by 25% of that category's spend and weaken the two Summary charts.

Use the validated category list instead of free-text variations such as Bathrooms, bathroom work or Bath. The available categories are Kitchen, Bathroom, Electrical, Plumbing, Flooring, Decorating, Professional Fees and Other. If the list does not suit the project, edit the reference list deliberately rather than creating spelling variations in the detail sheet.

Payments can be entered against the wrong line

A single payment covering several invoices can also mislead the outstanding total if it is assigned entirely to one item. For instance, a £6,120 payment recorded against a £5,100 actual ex VAT electrical item may show that line as Paid while another completed item remains Not paid. Allocate payments to the relevant rows and use Notes to explain deposits, combined invoices or staged work.

Set one fixed review point each week, such as the evening after the contractor's progress update. Spend 10 minutes matching new quotes, invoices and receipts to Item IDs, then update only the relevant actual cost and payment fields. A project with 25 active items is easier to maintain through five weekly updates than through one large catch-up after three months.

Use a fixed review sequence

• Start with new commitments: enter the planned date, category, description, supplier or contractor and budget ex VAT.
• Next match completed work to invoices and update Actual ex VAT without deleting the original budget.
• Then record payments in Amount Paid and check Outstanding and Status for each affected line.
• Finish on Summary by reviewing total actual cost, total outstanding, total variance and percentage of budget spent.

This order prevents a common routine failure: recording the bank payment but forgetting to record the invoice value. It also means the Summary sheet is reviewed after the underlying records have been updated, rather than being treated as a separate manual report.

Keep reference data stable

Review Lists & Guidance before the first supplier comparison and only change categories or reference rates when you have a clear project reason. The category lookup depends on the text in column D matching the list, so changing a category name after entries exist can affect the lookup result.

Keep quotes, invoices and receipts with the project records as instructed on the guidance sheet. The workbook does not store those documents, so use the Item ID, supplier name and Notes field to create a reliable link to your separate paperwork.

Know when to move on

This workbook is appropriate while one person or a small project team can keep the 100 detail rows complete and reviewed. Consider a dedicated project-cost system when you need purchase-order approval, document attachments, multiple users editing simultaneously, formal audit trails or detailed cash-flow scheduling that is not provided by these three sheets.