To find out what your flat really cost in its first year, pull twelve months of bank statements, group every flat-related debit into a handful of heads, and compare each total with what you planned before buying. The groups that usually matter are EMI, society charges, property tax, repairs and fit-out. The gap between plan and actual is the lesson.
Which groups should I sort the statement lines into?
- EMI: the monthly instalment, which holds interest and principal. Your loan statement splits the two, so use it if you want to see the cost of borrowing separately.
- Society: maintenance, sinking fund, parking, and any one-off levy.
- Property tax and similar dues, paid annually or in parts.
- Repairs and upkeep: plumber, electrician, painter, pest control.
- Fit-out: furniture, modular kitchen, wardrobes, appliances, curtains.
- Utilities for the flat: electricity, water, gas, internet, if you want them included.
How do I do the sorting?
Download your statements for the year, or the card statements if you paid some bills by card. Add a column called Group and fill it in for each flat-related line. Then total each group. In a sheet with the group in column B and the amount in column C, =SUMIFS($C$2:$C$800, $B$2:$B$800, "Repairs") gives the repair total. Cash spending is not in the statement, so add it from your notes.
A worked review with made-up numbers
| Group | Planned | Actual | Difference |
|---|---|---|---|
| EMI (12 × ₹32,000) | ₹3,84,000 | ₹3,84,000 | ₹0 |
| Society (planned 12 × ₹2,500, actual 12 × ₹2,400) | ₹30,000 | ₹28,800 | -₹1,200 |
| Property tax | ₹9,000 | ₹9,000 | ₹0 |
| Repairs | ₹10,000 | ₹14,500 | +₹4,500 |
| Fit-out | ₹2,00,000 | ₹2,20,000 | +₹20,000 |
| Total | ₹6,33,000 | ₹6,56,300 | +₹23,300 |
The arithmetic: planned 3,84,000 + 30,000 + 9,000 + 10,000 + 2,00,000 = ₹6,33,000, actual 3,84,000 + 28,800 + 9,000 + 14,500 + 2,20,000 = ₹6,56,300, so 6,56,300 minus 6,33,000 is ₹23,300 over. Nearly all of it is fit-out, which says that is where the plan was thinnest. Every figure here is made up.
What should I look for in the totals?
- Which group went over, and why: a one-off or a habit.
- Which costs repeat every year and should go into next year's plan.
- Which were one-time and will not come back, such as most fit-out.
- Whether anything you expected, like a deposit refund, has still not arrived.
How can an app speed this up?
If sorting twelve months by hand is a chore, SpendixAI can take the statement files, let you review the rows before saving, and apply your own categories and rules. The Report builder can filter and group your transactions, and a CSV download lets you keep a copy of the totals. Whatever you use, glance through the grouped lines yourself, because a lumped transaction such as a bulk payment to a contractor may need splitting.
What if my statements are messy?
Flat-related debits often hide behind vague descriptions: a UPI handle for the plumber, a gateway name for society maintenance, a shop name for the paint. Go through the year once and write the real payee beside each, then use the same label next time. For cash, add a line from your notes or from the bills you kept. An imperfect review is still far more useful than none, as long as you say which numbers are estimates.
A short plan for next year
- Carry forward the repeating groups at their actual amounts.
- Add a small repairs line larger than this year's, since flats need upkeep.
- Write down what you would do differently on fit-out.
- Set a reminder for the annual property tax date.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


