A home maintenance expense tracker works best as a log with one row per job rather than a monthly total. Record the date, room, job, who did it, amount, how you paid and where the bill is. With those seven columns you can answer which room costs most, which contractor you used last time, and whether a repair is still under warranty.
What columns should the log have?
| Column | Example entry | Why it earns its place |
|---|---|---|
| Date | 18/06/2026 | Lets you sort by month and financial year |
| Room | Kitchen | Shows which area keeps costing money |
| Job | Chimney motor replaced | Searchable later |
| Who | Raju, electrician | You will want the number again |
| Amount | ₹2,800 | The only column you add up |
| Paid by | UPI | Helps you find it on a statement |
| Bill or photo | Folder name or file | Proof for warranty and for yourself |
How do you total it by room and by year?
Say dates sit in column A, rooms in column B and amounts in column D, with rows 2 to 500 in use. These work in Excel and Google Sheets.
- Kitchen total: =SUMIFS($D$2:$D$500, $B$2:$B$500, "Kitchen")
- Kitchen in the April 2026 to March 2027 year: =SUMIFS($D$2:$D$500, $B$2:$B$500, "Kitchen", $A$2:$A$500, ">="&DATE(2026,4,1), $A$2:$A$500, "<="&DATE(2027,3,31))
- Number of jobs this year: =COUNTIFS($A$2:$A$500, ">="&DATE(2026,4,1), $A$2:$A$500, "<="&DATE(2027,3,31))
- Total for the year across all rooms: =SUMIFS($D$2:$D$500, $A$2:$A$500, ">="&DATE(2026,4,1), $A$2:$A$500, "<="&DATE(2027,3,31))
Keep the room names consistent. A sheet with Kitchen, kitchen and Kitchen followed by a stray space will give three different totals. A drop-down list in the Room column, made with data validation, prevents it.
What does a few months look like?
Say four jobs are logged: a ₹2,800 chimney motor in the kitchen, a ₹450 tap washer fix in the bathroom, ₹1,200 for repairing a switchboard in the bedroom, and ₹3,600 for a geyser element in the bathroom. The Bathroom SUMIFS returns 450 + 3,600 = ₹4,050. The kitchen returns ₹2,800, and the all-rooms total is 2,800 + 450 + 1,200 + 3,600 = ₹8,050. The bathroom, not the kitchen, is the costly room that quarter, which is a fact you would not have noticed from a monthly total.
What about cash payments to a handyman?
Cash is where logs go missing, because there is no statement line to rebuild from. Enter it the same evening, with the handyman's name, in the same row format. If you pay several people in one trip, such as a plumber and a helper, write one row each so the contractor column stays truthful.
How do you keep bills and warranty details?
- Photograph the bill or take a photo of the service sticker the same day.
- Name the file with the date and job, such as 2026-06-18-kitchen-chimney-motor.
- Write the warranty period, if the job has one, in an extra column called Warranty till.
- Once a year, filter that column and see what is about to expire.
When does an app make more sense than a sheet?
A sheet is perfect for a hundred rows a year. It gets tiring when you also want your bank statements to feed the log. In SpendixAI, payments from your statement are imported, you add cash jobs manually (several at once if you are catching up), and receipts stay with each transaction. A Home upkeep category with sub-categories by room gives the same breakdown without formulas, and the report builder can filter and group the result. The sheet remains useful for the contractor and warranty columns.
Before you start
- Pick the seven columns and freeze the header row.
- Add a drop-down for Room.
- Back-fill the last six months from your statements.
- Set a calendar note for the first week of April to total the year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

