Income and work

Maintenance and society charges on a rented-out flat: logging each

A simple log for a rented-out flat showing each society and maintenance charge, who paid it, what was reimbursed and what it really cost you.

Editorial illustration for Maintenance and society charges on a rented-out flat: logging each

When you rent out a flat, charges like society maintenance, water and repairs can be paid by you, by the tenant or split between the two. The agreement decides who pays what, so keep a log with one row per charge: the amount, who paid, how much came back from the tenant, and your net cost. That makes your real cost of owning the flat visible.

Which charges should I list?

  • Monthly society maintenance
  • Sinking fund or repair fund contributions
  • Water or tanker charges
  • Electricity and gas, if the connection is in your name
  • Parking charges
  • Repairs and replacements
  • One-off charges such as a society transfer fee

Which of these the tenant bears is written in your rent agreement. If something is not covered, note how you and the tenant agreed to treat it, ideally in a message you can save.

What does the log look like?

ColumnWhat to enter
MonthThe bill month
ChargeMaintenance, sinking fund, repair and so on
Billed toYou or the tenant, as shown on the bill
Paid byWho actually paid the society or vendor
Amount in ₹The bill amount
Reimbursed in ₹What the tenant paid back to you
Net cost to you in ₹Amount minus reimbursed

In the last column, use =E2-F2, with Amount in E and Reimbursed in F, and copy down.

What does one month look like?

Hypothetical: you pay the society ₹3,200 for maintenance and ₹500 for the sinking fund. Your agreement says the tenant pays maintenance. The geyser needed a ₹4,200 repair, which you paid and the tenant did not reimburse.

ChargePaid by you in ₹Reimbursed in ₹Net cost to you in ₹
Maintenance3,2003,2000
Sinking fund5000500
Geyser repair4,20004,200
Total7,9003,2004,700

Check: 3,200 + 500 + 4,200 = 7,900 paid, and 7,900 − 3,200 = ₹4,700 net. Without a log you would see a ₹7,900 outflow and ₹3,200 coming back as separate things, and might not notice the net.

How do I total the year?

  • Net cost for the month, with months in column A as dates and the first of the month in K1: =SUMIFS($G$2:$G$500, $A$2:$A$500, $K$1)
  • Net cost by charge type for the year: =SUMIFS($G$2:$G$500, $B$2:$B$500, "Repair")

Run totals for the April to March year, because that is the period your CA will look at. Filing rules and what costs may be allowed are theirs to say, so give them the log.

How can an expense tracker help?

Payments to the society and repairmen are on your bank statement. In SpendixAI you pick the account, upload the statement and review the rows. You can use categories and sub-categories, such as Rented flat with sub-categories for maintenance and repairs, and keep each receipt with its transaction. The tenant's reimbursements arrive as credits, so you can see both sides.

What if the society bill is in the tenant's name?

Some societies bill the occupant, others bill the owner. If the bill comes to the tenant but you are responsible under the agreement, note that in the Billed to column and record the reimbursement you make. If bills arrive late, log them in the month they relate to, not the month you paid, so that your yearly totals line up with the period they cover.

A monthly routine

  1. Enter each bill when it arrives, with the due date.
  2. Record who paid it.
  3. When the tenant reimburses, fill the Reimbursed column.
  4. At month end, check net cost and chase any unpaid share.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports