Indian RWA Maintenance & Audit Ledger Template (Excel)

Most RWAs and housing societies start their accounts in a spreadsheet kept by the treasurer. It works until the treasurer changes, a member disputes a balance, or the auditor asks for the trail behind a number. This template is built to survive all three: one row per flat per month, every receipt tied to a bank reference, every expense tied to a bill and an approval, and nothing overwritten.

Housing bodies in India are registered under different laws: co-operative housing societies under the state's co-operative societies Act and bye-laws; many RWAs under the Societies Registration Act, 1860 as applied in the state; apartment owners' associations under a state apartment ownership Act; a few as section 8 companies. Periods, quorums and rates differ — the workbook keeps them as settings for that reason.

What is in the workbook

• Settings: billing basis (per square foot or per flat), maintenance rate, sinking-fund charge if collected separately, interest on late payment, bill due day and a GST review threshold.
• Flats: flat number, owner or member, area, contact details and opening balance.
• Ledger: one row per flat per month — the bill, any interest or other charges, the receipt with date, mode and reference, and the running balance due.
• Expenses: date, head, vendor, bill number, amount, GST, TDS deducted, amount paid, payment reference, approver and voucher number.
• Summary: billed, collected, collection rate, expenses and surplus by month for the managing committee.
• Audit checklist: twelve year-end checks an auditor will ask about.

How the ledger works

1. Enter the month as the first day of the month and pick the flat from the list.
2. The bill calculates from the flat's area and your rate (or the per-flat amount), plus any separate sinking-fund charge.
3. Add interest or other charges in their own column, so the member can see what was billed and why.
4. When money arrives, enter the date it reached the bank, the mode and the reference (UTR or cheque number) and the amount.
5. The balance after each row is the flat's opening balance plus every bill and charge up to that month minus every receipt — calculated from the rows, not typed, so it cannot drift.

Billing basis and rates

Your general body decides whether maintenance is charged per square foot or per flat, and the rate. Some bye-laws require certain charges (such as sinking fund or repair fund) to be calculated on a particular basis — see our sinking-fund calculator. Enter what your resolution says and keep a copy of the resolution with the workbook.

Interest on late payment

Interest on overdue maintenance is charged only if your bye-laws or a general body resolution allow it, at the rate they set. Some model bye-laws for co-operative housing societies allow simple interest up to a stated maximum; RWAs registered as societies rely on their own rules. Enter your rate as a setting and use the defaulter tracker to work out interest by days overdue.

The GST check

Contributions collected by an RWA from its members for common services can be exempt from GST up to a per-member monthly limit, and an RWA whose turnover is below the registration threshold need not register. The government has clarified that if the monthly contribution exceeds the limit, the exemption is lost on the whole amount, not just the excess. The ledger flags any bill above the threshold you set (₹7,500 per month in the template, the limit as notified at the time of writing) — verify the current notification and your RWA's turnover with your adviser.

The committee summary

Each month the summary shows billed, collected, the collection rate (collected ÷ billed), expenses paid and the surplus or deficit. A falling collection rate is the earliest warning of a dues problem; a monthly deficit funded from reserves needs a general body decision.

Year-end audit

The audit checklist covers bank reconciliation, receipts and vouchers, member balances agreeing with the ledger, defaulters and interest, separate investment of sinking and repair funds as resolved, TDS deducted and deposited where applicable, GST position, fixed deposits, AGM approval of budgets and rates, statutory registers and closure of earlier audit points. Your auditor may add items required under your Act.

Practical tips

• One bank account for maintenance and separate accounts (or deposits) for sinking and project funds.
• No cash payments to vendors; if cash is collected from members, deposit it intact.
• Two signatories for payments, as most bye-laws require.
• Share each member's ledger with them every quarter — disputes are cheaper to fix early.

When the spreadsheet becomes too much for one person, SocietyOne in Bebaak keeps the same ledger with bills, receipts, reminders, a member portal and books an auditor can follow — see the SocietyOne billing guide.