Your own repair bills give the answer. Add up what you spent on repairs in the last three years, divide by three, then divide that by twelve to get a monthly set-aside. Because it comes from your bills and not a rule of thumb, it fits your flat, your fittings and the repairs that keep coming back.
Where do the three years of figures come from?
Look through bank and UPI statements, cash receipts and contractor bills for anything spent on fixing or maintaining the home itself: plumbing, electrical, painting, carpentry, waterproofing, pest control, appliance servicing. Leave out new purchases and renovations, since those are projects, not repairs. If you track expenses in an app, filter by a Home repairs category; where you do not, search statements for the plumber's or electrician's name or the shop that supplied materials.
How do you add them up by category?
Make one row per bill with date, category and amount. Then total each category for each year. Here is a made-up example.
| Category | Year 1 (₹) | Year 2 (₹) | Year 3 (₹) | 3-year total (₹) | Yearly average (₹) |
|---|---|---|---|---|---|
| Plumbing | 6,500 | 3,800 | 9,200 | 19,500 | 6,500 |
| Electrical | 4,200 | 7,500 | 2,000 | 13,700 | 4,567 |
| Painting | 0 | 18,000 | 0 | 18,000 | 6,000 |
| Carpentry | 3,000 | 2,500 | 6,000 | 11,500 | 3,833 |
| All repairs | 13,700 | 31,800 | 17,200 | 62,700 | 20,900 |
In a sheet, with category in column B, amount in column C and the year in column A, the total for one category and year is =SUMIFS($C$2:$C$500, $B$2:$B$500, "Plumbing", $A$2:$A$500, 1). Divide by three for the average.
What is the monthly figure?
On the made-up numbers, the three-year total is 62,700, so the yearly average is 62,700 divided by 3, which is ₹20,900. Divided by 12 months, that is ₹1,741.67, so call it ₹1,742 a month. Moving that amount to a separate savings account or a marked-off balance on the first of each month means a ₹18,000 painting year does not hit one month's budget.
What if you have fewer than three years of bills?
If you have one or two years, use what you have, and mention in the sheet that the average is thin. If you have just moved in, get two or three quotes for the jobs you already know are coming, such as repainting, and divide each quote by the number of months until the job is due. Review the figure after the first year with real bills.
When does one big repair distort the average?
A single one-off, such as repairing a leaking terrace, can drag the average up, and a quiet year can pull it down. Keep rare large jobs in a separate line, with their own date and quote, and let the monthly set-aside cover the regular items. Then when a big job comes, you know whether you are drawing on the repair pot or planning a project.
How should you review it each year?
- Add the new year's bills to the sheet.
- Drop the oldest year so the average still covers three years.
- Compare new monthly figure with the amount you actually set aside; if the pot grew, you can lower it, and if you dipped into savings, raise it.
- Note any repair you expect next year, for example painting after five years.
If you import your statements into SpendixAI, a Home repairs category with a monthly report gives you the yearly total without hunting through PDFs, and a savings goal on Pro can show progress toward the repair pot. Cash repairs still need to be added by hand.
Quick checklist
- Three years of repair bills by category
- Yearly average and monthly figure worked out
- Large one-offs kept separate
- Annual review set for the same month each year
Useful ideas start with a clearer picture of your own spending.
Explore your reports
