How to Track Renovation Costs in Excel: Crew Work, Materials and Budget

A renovation almost always costs more than planned. The usual reason is not one huge surprise but a hundred small ones: a receipt in a jacket pocket, a verbal agreement about extra work, a delivery paid in cash. By the end nobody can say where the money went.

A tracker in Excel gives you a single place for everything. This guide shows how to record work and materials, compare plan and actual by section, work out what you owe the crew, and forecast the final cost. It suits people renovating an apartment or house, and site managers running small projects.

Step 1: Set the budget by section

Divide the project into sections: demolition, electrics, plumbing, walls, flooring, finishing. For each, set a budget for work and a separate budget for materials.

Splitting work and materials matters because they behave differently: work is agreed with the crew, materials depend on prices and how much you buy.

Step 2: Log the crew's work

One row per job: date, section, type of work, quantity, unit, rate, cost, paid. Cost is calculated:

=E2*G2

Debt to the crew for each job:

=H2-I2

Example: tiling 40 sq m at $12 per sq m costs $480. If you have paid $300 so far, you still owe $180.

Total owed to the crew for the project is =SUM(debt column). This is the number people most often cannot answer, and it is the one that matters when the crew asks for a payment.

Step 3: Log the purchases

One row per purchase: date, material, quantity, price, amount, supplier, receipt number.

=C2*D2

The receipt number is optional but saves you when you need to return something or prove a price. Make sure each purchase has a section so it lands in the right budget line.

Step 4: Compare plan and actual by section

For each section:

• Work spent: =SUMIFS(WorkCost,WorkSection,A2)
• Materials spent: =SUMIFS(Amount,MatSection,A2)
• Remaining: =Budget-Spent

A negative remaining value is an overrun. Highlight it in red.

One section can hide an overrun behind another's savings, so look at them separately as well as in total.

Step 5: Forecast the final cost

The remaining budget tells you where you are; the forecast tells you where you will end up. A simple approach: divide work spent by the section completion percentage, and for materials take actual or budget, whichever is higher.

If electrics work spent is $2,000 and the section is 80% complete, forecast work is 2,000 / 0.8 = $2,500. This is an estimate, not an exact cost, but it warns you early when completion lags behind spending.

Common mistakes

• Expenses without a section. They vanish from the totals. Add a catch-all line "Not allocated" to see them.
• Paying the crew without logging it. The debt figure becomes useless.
• Mixing VAT-inclusive and exclusive prices. Choose one basis.
• Ignoring small purchases. Fasteners and consumables add up to a real number.
• No contingency. Set aside an explicit reserve in the budget, often a tenth or more, rather than hoping.

Ready-made renovation tracker

The Renovation and Construction Project Tracker template implements this approach. You keep a crew work log and a purchase log, and the summary compares plan and actual for each section, shows what you owe the crew and warns about an overrun before the renovation is over.

It has four sheets. "Settings" holds the project, dates, budget by section separately for work and materials, and section completion. "Work" is a log of up to 500 records with date, section, type of work, quantity, unit, rate, cost, paid and remaining debt to the crew. "Materials" is a purchase log of up to 500 records with material, quantity, price, amount, supplier and receipt number. "Summary" shows plan and actual by section, remaining budget, the amount owed to the crew, the forecast final cost and two charts. Expenses assigned to an incorrect section are highlighted in red and appear on a "Not allocated to sections" line.

It suits people renovating or building a home with a hired crew, site managers and foremen running several projects, and small renovation companies. It runs in Excel 2007 and later and LibreOffice, with no macros. This is a paid template. Rates and values are kept in the settings, and the calculation is approximate, so check them against your own contracts and local requirements.

FAQ

How much contingency should I add?

Many people set aside around 10 to 15 percent for unforeseen work, more for old buildings. Treat it as a separate line, not as a cushion hidden in other budgets.

Should I log verbal agreements?

Yes. Add a row with a short description and the agreed rate as soon as the work is agreed. It is much easier than reconstructing it later.

What if the crew is paid by the day rather than per unit?

Record quantity as the number of days and the rate as the daily rate. The cost formula is the same.

Can I use it for several projects?

Keep one file per project. It keeps totals clean and makes it easy to hand the file over.