For a flat you rent out, keep one record with rent received on one side and every cost of holding the flat on the other, month by month. At year end, subtract costs from rent, and remember to count the months when it was vacant. The result is the net figure you actually earn, which is usually lower than rent times twelve.
What goes on the income side
- Monthly rent received, with the date and mode (UPI, bank transfer, cheque).
- Any maintenance or utility charge the tenant reimburses to you.
- The security deposit. Record it separately, because it is not income and is usually returnable.
- Late payments and any deductions agreed with the tenant.
What goes on the cost side
- Society maintenance, whichever of you pays it, including months the flat is empty.
- Repairs and painting between tenants.
- Property-related dues levied on the flat. Take the amounts from your actual bills.
- Brokerage or listing costs when you find a new tenant.
- Insurance, if any, and electricity or water minimums during vacancies.
- Loan EMI, if any, tracked on its own line so you can see the flat's results with and without it.
A worked example with hypothetical numbers
Say rent is ₹25,000 a month. In a year the flat is occupied for 11 months and vacant for 1 while a new tenant is found. Rent received is 11 x 25,000 = ₹2,75,000.
| Line | Amount for the year |
|---|---|
| Rent received (11 months) | ₹2,75,000 |
| Society maintenance paid by you (12 x ₹3,000) | ₹36,000 |
| Repairs and painting | ₹14,000 |
| Property-related dues | ₹8,000 |
| Brokerage for the new tenant | ₹12,500 |
| Total costs | ₹70,500 |
| Net result before any loan EMI | ₹2,04,500 |
Costs are 36,000 + 14,000 + 8,000 + 12,500 = ₹70,500, and 2,75,000 - 70,500 = ₹2,04,500. Dividing by twelve, that is about ₹17,042 a month, compared with the headline rent of ₹25,000. If the flat has an EMI of ₹15,000 a month, which is ₹1,80,000 a year, the remaining figure would be 2,04,500 - 1,80,000 = ₹24,500. Whether any of this affects your tax is a question for your CA.
How do you treat vacancy months?
Count them. A flat that is vacant for two months has produced ten months of rent, but twelve months of costs. Track a vacancy line even if it is zero, so you can see what a typical year looks like after two or three of them, and plan for the gap while looking for the next tenant.
What should a tidy rental record look like?
One sheet works: one row per month, with columns for rent due, rent received, date received, maintenance, repairs and other costs, and a net column. The net for a month is rent received minus all costs that month. A year total sits at the bottom. A separate tab can hold the deposit, so it does not mix with income.
Where an expense tracker helps
If the rent arrives in an account whose statement you import into SpendixAI, the credits are already there, and costs paid from that account or your card sit alongside. Custom categories for rental income and rental costs make the yearly report straightforward, and receipts can be attached to the repair transactions. It is a personal expense tracker, not property-management software, so tenant agreements and reminders stay in your own system.
Year-end checklist
- Rent received for each month matched to bank credits.
- All repair and maintenance invoices filed.
- Vacancy months and brokerage recorded.
- Deposit noted separately and any deductions documented.
- Net result worked out, with and without any loan EMI.
- Figures given to your CA for advice on how they apply to you.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


