To find every housing payment in a year, gather all twelve statements, list the words each payment uses in your narration, and sort the rows into a few housing categories. Add them up by category and you have your annual housing cost, which most people have never actually seen as one number.
Which payments count as housing?
- Rent, or the EMI of a home loan
- Society maintenance and any sinking fund or repair levy
- Property tax
- Electricity, water and gas
- Home internet and cable, if you treat them as housing
- Repairs, servicing and small fixes
- Domestic help, if you want it in the same total
Decide the list once and write it down. A total that quietly changes its meaning each year is useless for comparison.
What words should I look for?
Open one statement and read it slowly. Note exactly how each housing payment appears in your own narration; wording differs by bank and by how you paid. Typically you will find one or two of these patterns per payment.
| Payment | Where to look | What to note |
|---|---|---|
| Rent | A fixed amount to one name, same date each month | Payee name as printed |
| EMI | A fixed debit with the lender's name or a loan reference | Loan reference |
| Society | A transfer to the association, often the same amount | Whether it is monthly or quarterly |
| Property tax | One or two larger debits a year | Month it usually falls |
| Utilities | Varying amounts on a steady date, often a bill payment line | Biller name if shown |
How do I do this in a spreadsheet?
If your statements are in Excel or Google Sheets, put the narration in column B and the debit amount in column C, rows 2 to 3000. Then this adds every row whose narration contains the word maint:
=SUMIF($B$2:$B$3000,"*maint*",$C$2:$C$3000)
The asterisks are wildcards, so it matches any text around the word. Change the word for each housing payment. Check the count with =COUNTIF($B$2:$B$3000,"*maint*") to confirm it caught twelve, not eleven. Search words are only as good as your narration, so a payment under a different spelling will be missed.
What does the total look like?
Hypothetical numbers: say rent is ₹18,000 a month, so ₹2,16,000 a year. Say society is ₹2,400 a month, so ₹28,800. Electricity across the year is ₹21,500, water ₹4,800 and repairs ₹6,700. Add them: 2,16,000 plus 28,800 is 2,44,800, plus 21,500 is 2,66,300, plus 4,800 is 2,71,100, plus 6,700 is ₹2,77,800. That is about ₹23,150 a month once spread across the year.
What if a payment went missing from my list?
If rent shows eleven times, the twelfth is hiding somewhere. Look at the statement of any other account you used that month, at UPI payments made from a wallet, and at the month before and after in case it moved across a boundary. A payment made on the last day of one statement period can appear on the next.
Write each gap on your list with the month and the reason once you find it. After one year of doing this, you will know which payments are most likely to wander.
Can SpendixAI do this faster?
If you do not want to build search words yourself, the app lets you upload statements in PDF, CSV or Excel, in batches, and review the rows before saving. You pick the account before each import, and the import history shows the status of each file. Then the housing categories and a Report builder filter total the year by category, and you can download the result as CSV.
A short plan
- Collect twelve months of statements from every account that pays housing bills.
- Write down the narration pattern for each payment.
- Tag each row with a housing category.
- Total by category and check the rent or EMI count.
- Save the sheet as your baseline for next year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


