Business

Expense tracker for a property manager in India: what to record

How a property manager in India can track owner-wise rent, repairs paid, management fees and running costs without mixing owners' money with their own.

Editorial illustration for Expense tracker for a property manager in India: what to record

A property manager should keep a separate ledger for each owner: rent collected, repairs and bills paid on their behalf, your management fee and the amount sent to them. Only the fee is your income; the rest is the owner's money passing through your hands. A manager who tracks it owner by owner can answer any owner's question in a minute.

What is your money and what is the owner's?

When a tenant pays rent to you, that rent belongs to the owner until you deduct what was agreed. Your income is the management fee, and perhaps a tenant-finding fee. Repairs, electricity or society dues you pay on the owner's behalf are recoverable from them. If these are all thrown into one sheet, it looks as if you earned far more than you did, and your own costs get buried.

What categories do you need?

CategoryWhose moneyWhat goes in it
Rent collectedOwner'sRent received per flat, with date and mode
Repairs and maintenance paidOwner's, recoverablePlumber, electrician, painter, with the flat named
Utility and society dues paidOwner's, recoverableElectricity, water, maintenance paid for the owner
Management feeYoursThe fee you deduct per owner
Tenant-finding feeYoursFee for placing a new tenant
Staff and caretakersYours or sharedPay for people you employ, split by agreement
Travel to propertiesYoursFuel, auto or cab for inspections
Phone, software and adsYoursRecharge, listing ads, tools
Amount sent to ownerOwner'sTransfers made, with date

What does one hypothetical month look like?

Say you manage three flats. Owner A's flat pays ₹18,000 rent, you spent ₹2,200 on a plumber and your fee is ₹1,800. Owner B's flat pays ₹25,000, you paid a ₹1,300 electricity bill and your fee is ₹2,500. Owner C's flat pays ₹12,000 with a fee of ₹1,200 and no other costs.

OwnerRentPaid for ownerYour feeSent to owner
A18,0002,2001,80014,000
B25,0001,3002,50021,200
C12,00001,20010,800
Total55,0003,5005,50046,000

Owner A receives 18,000 minus 2,200 minus 1,800, or ₹14,000. The three amounts sent out are 14,000 plus 21,200 plus 10,800, which is ₹46,000, and 46,000 plus 3,500 plus 5,500 gives back the ₹55,000 collected. If that last check does not tie, something is missing. In this month your income is only the ₹5,500, not ₹55,000.

Which items get missed?

  • Small repairs paid from your own pocket and never billed to the owner.
  • Tenant security deposits, which are held for the tenant and are not income to you or the owner until adjusted.
  • Rent received late or in two parts for the same month.
  • Society dues or a one-time charge paid on an owner's behalf.
  • Cash rent from a tenant who has no bank link, which needs a receipt number and a date.

How should you keep your own books separate?

Use a separate bank account for owners' money if you can. At minimum, record every owner transfer, and never use rent balances to meet your own costs, even for a day. Your own costs, such as fuel, phone and a caretaker's pay, go in a separate list against only your fee income. That is how you learn whether the fee per flat covers the work.

What monthly routine keeps owners happy?

  1. On the day rent arrives, enter it against the flat and the owner.
  2. Enter every repair or bill the same day, with a photo of the invoice.
  3. By your agreed date, prepare a one-page statement for each owner showing rent, costs paid, your fee and the amount sent.
  4. Send the money and note the transfer date.

When a new owner joins, write down the agreed fee, the repair approval limit and the date money is sent. That one line prevents most disputes later, because both sides can see what was agreed before any rent was collected.

SPENDIXAI JOURNAL

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

Explore your reports