Money tips

Expense tracking for a housing society treasurer: a simple system

A simple system for a housing society treasurer in India: flat-wise collections, common categories, a sample month and a routine that fits a busy week.

Editorial illustration for Expense tracking for a housing society treasurer: a simple system

A housing society treasurer can keep things clear with a flat-wise collection sheet, a handful of cost categories, a bill or voucher for every payment and a monthly match against the bank statement. The hard part is not the spending, it is matching each UPI or cheque credit to the right flat, so start there.

How does money flow in a housing society?

Income is mostly monthly maintenance from each flat, arriving by UPI, NEFT, cheque or occasionally cash, and often a few days late. Costs cluster around a few vendors: the security agency, housekeeping, the lift contractor, common-area electricity, water, repairs and festival events. Between the two sit things that are easy to lose: arrears, advance payments, bounced cheques and one-time levies.

How do I match payments to flats?

Ask residents to write the flat number in the payment remarks, and keep one master sheet with one row per flat and one column per month. When a credit appears on the statement, tick that flat's cell. Anything that does not match goes into a short list called Unmatched, to be resolved by the end of the week.

  • Name the columns by month and mark each cell Paid, Part-paid or Pending.
  • Record the date of credit, not the date the resident says they paid.
  • Write down any advance of several months separately so it is not counted twice.
  • Note cheques that bounced and the follow-up.

Which categories do most societies need?

  • Security
  • Housekeeping and cleaning
  • Lift annual maintenance
  • Common-area electricity
  • Water and pump
  • Garden
  • Repairs and plumbing
  • Festival and events
  • Professional fees, such as the auditor
  • Admin, printing and bank charges
  • Sinking or repair fund, tracked apart from running costs

Keeping the sinking fund separate stops a big repair from being mistaken for a deficit, and the other way round.

What does a sample month look like?

Say a society has 60 flats and charges ₹2,500 a month each, so ₹1,50,000 is due. In this made-up month 54 flats pay, which is ₹1,35,000, and six are pending.

LineAmount
Maintenance collected, 54 flats₹1,35,000
Pending, 6 flats₹15,000
Security₹55,000
Housekeeping₹22,000
Lift maintenance₹9,000
Common electricity₹18,000
Water₹7,000
Garden₹4,000
Repairs₹10,000
Admin₹3,000

The expenses add up to ₹1,28,000, so the month closes with ₹1,35,000 minus ₹1,28,000, which is ₹7,000 in hand. If all six pending flats pay later, ₹22,000 would be available, but treat the ₹15,000 as pending until it lands.

What routine works for a volunteer?

  1. Every evening or two, tick new credits against the flat sheet.
  2. Pay vendors only against a bill, and record the payment on the same day.
  3. On a fixed date each month, tally the sheet against the bank statement.
  4. Send a one-page summary to the committee: collected, pending, spent, balance, and sinking fund position.

What should residents see each month?

Residents trust a treasurer who is open. A monthly notice does not need to be long, and it should not publish anyone's personal details beyond the flat number.

  • Total collected and total spent for the month
  • Closing balance of the running account and of the sinking fund
  • Number of flats with dues, and the total pending
  • Any large repair approved or planned

For arrears, show flat number, months pending and amount. A flat that is two months behind owes ₹5,000 at ₹2,500 a month, and writing the months next to the amount avoids arguments about what the total means. Keep the reminders polite and consistent for every flat, so nobody feels singled out.

Where does a personal tool help?

If you front small payments from your own pocket and wait to be reimbursed, record those in your personal expense tracker so you can see what the society owes you. SpendixAI lets you add cash expenses by hand and keep receipts with them. It is built for one personal workspace and does not keep a flat-wise ledger, so the society's own register stays in its own sheet or accounting book.

SPENDIXAI JOURNAL

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

Explore your reports