A landlord's annual summary is a single page showing, for each flat, the rent received over the financial year, the costs you paid, the months it sat empty and the net. It comes from your tracker in an hour if the categories were consistent through the year, and it is the page your CA or a lender will ask for first.
What goes on the page?
- One column per flat, plus a total column.
- Rent received, from the bank statements, not the agreement.
- Society charges paid, repairs paid, and property tax paid, each on its own line.
- Vacancy: the months the flat was empty and the rent not received because of it.
- Net: rent received less the costs listed.
- The period at the top, April to March, and the date you prepared it.
Can we see a worked example?
Take two flats, with invented numbers. Flat A lets at ₹20,000 a month and was occupied all year. Flat B lets at ₹15,000 and was empty for one month.
| Line | Flat A | Flat B | Total |
|---|---|---|---|
| Rent received | ₹2,40,000 | ₹1,65,000 | ₹4,05,000 |
| Society charges paid | ₹26,400 | ₹21,600 | ₹48,000 |
| Repairs paid | ₹9,500 | ₹4,000 | ₹13,500 |
| Property tax paid | ₹5,500 | ₹4,200 | ₹9,700 |
| Total costs | ₹41,400 | ₹29,800 | ₹71,200 |
| Net | ₹1,98,600 | ₹1,35,200 | ₹3,33,800 |
| Vacant months | 0 | 1 | 1 |
The arithmetic: Flat A rent is 12 × ₹20,000 = ₹2,40,000 and Flat B is 11 × ₹15,000 = ₹1,65,000. Society charges are 12 × ₹2,200 = ₹26,400 and 12 × ₹1,800 = ₹21,600. Costs for A are 26,400 + 9,500 + 5,500 = ₹41,400; for B, 21,600 + 4,000 + 4,200 = ₹29,800. Net for A is 2,40,000 − 41,400 = ₹1,98,600 and for B it is 1,65,000 − 29,800 = ₹1,35,200. Together, ₹3,33,800. The month Flat B stood empty cost ₹15,000 in rent not received, which is useful to see on its own.
Where does each number come from?
Rent comes from tagged credits, so the summary is only as good as the tagging. Costs come from the expense side: bills, receipts and statement lines. Vacancy comes from the rent roll. If a number cannot be traced to a record, mark it as an estimate on the page.
How do you build it each year?
- Fix the period: April to March of the financial year.
- Tag every rent credit with its flat and month.
- Make sure each cost has a flat tag, or a split between flats if it covers both.
- Total by flat, then check the grand total against the account statements.
- Note anything unusual: a large repair, a deposit refund, a rent revision.
Add two small extras to the page. First, a line for deposits held, which are not income but are money you owe back, so they should never be mixed with rent received. Second, a line for large one-off items such as a renovation, kept apart from routine repairs, so that a single big bill does not make a normal year look bad when you compare it with the next.
Where does SpendixAI fit in?
The costs side is where a tracker saves time. SpendixAI can take your bank and card statements, categorise the rows and let you review them, and its Report builder lets you filter and group spending, with CSV download for the sheet that holds the summary. Rent per flat is easier to total from your own tagged sheet.
Before you close the year
- Look for untagged credits and costs.
- Check each flat has twelve months accounted for, as rent, vacancy or an explained gap.
- File the bills for each cost line behind the summary.
- Save the summary and the statements together, named by financial year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

