How to prepare a clear maintenance bill for a housing society
04 Nov 2026
Quick answer
Getting opening balances right in society accounting software decides whether the new system is trusted. Every opening figure should come from the old books as closed on the cut-over date, member dues and advances should be entered flat by flat and total exactly to the books, and the committee should approve the opening position before any bill goes out from the new system.
This guide is for treasurers moving from registers or spreadsheets to software. The law does not prescribe how to migrate, so most of it is recommended practice. What the law does fix is the co-operative year, which begins on 1 April (s.4(23) of the West Bengal Co-operative Societies Act 2006), the books a society must keep (Rule 67 of the 2011 Rules), and an annual audit (s.97).
Choose the cut-over date
Start on 1 April if you can. The old books then cover a complete co-operative year and are audited as one, and the new system starts with balances only. If you start mid-year, carry forward the year-to-date income and expenditure by head as well as balances, or the year-end accounts will not be complete.
What to gather before you enter anything
- The last closed balance sheet and trial balance, audited if available.
- Bank statements to the cut-over date, with a reconciliation listing uncleared cheques and deposits.
- Cash in hand, counted and signed on the cut-over date.
- A list of every flat with the member's name, billable area and balance (due or advance).
- Balances of any funds (repair fund, sinking fund) as approved by the general body.
- Unpaid bills to suppliers and deposits held or paid (for example with the electricity supplier).
- Share capital per member from the share ledger.
Worked example: a 24-flat society on 1 April
Example only. All figures are invented to show the method. They are not real data.
| Opening item (example) | Amount | Source |
|---|---|---|
| Bank balance per books | Rs 4,67,700 | Statement Rs 4,86,200 less uncleared cheque Rs 18,500 |
| Cash in hand | Rs 3,200 | Signed cash count |
| Member dues, 5 flats | Rs 62,300 | Member ledger, flat by flat |
| Deposit with electricity supplier | Rs 25,000 | Supplier receipt |
| Total assets | Rs 5,58,200 | |
| Repair fund | Rs 4,10,000 | Fund account; general body resolution |
| Member advances, 2 flats | Rs 10,570 | Member ledger; shown separately, not netted |
| Unpaid March security bill | Rs 48,000 | Supplier invoice |
| Share capital, 24 members | Rs 12,000 | Share ledger |
| Accumulated surplus | Rs 77,630 | Balance sheet |
| Total funds and liabilities | Rs 5,58,200 |
The two checks that matter: the five flats' dues add up to exactly Rs 62,300, and the two advances to exactly Rs 10,570. If the old books show net dues of Rs 51,730, that is the same position, but enter the two sides separately so each flat's statement is right.
Pitfalls to avoid
- Entering the bank statement balance instead of the reconciled book balance.
- Netting advances against dues so some flats show the wrong figure.
- Putting an unexplained difference into "opening adjustment" with no note.
- Re-entering last year's bills as new bills, so members appear to owe twice.
- Changing member names or areas during migration without the underlying approval.
An unexplained difference is not a reason to delay go-live, but it must be named. Use a suspense line called something specific, for example "Unidentified receipts before 1 April", and clear it using the reconciliation checklist.
Approve, tell members, keep the old books
- Put the opening position before the committee and minute its approval.
- Send each member their opening balance with a short explanation and a date for queries.
- Keep the old registers, spreadsheets and vouchers; the auditor and members may still need them.
- Issue the first bill from the new system only after queries close, following a clear bill format.
- Give the auditor a one-page bridge from the old closing balance sheet to the new opening figures; see audit preparation.
Doing this on COOPMAN
A treasurer can start with a free account at /register; society roles such as committee access are added through approval workflows, not chosen at sign-up. Once the society is claimed and set up, COOPMAN keeps a maintenance ledger and payments per unit, and the society can give its accountant scoped finance access to enter and check opening figures. See the society management guide.
This article is general information, not legal advice.
Opening balances: frequently asked questions
What is the best date to switch to new software?
The first day of a co-operative year, 1 April under s.4(23) of the West Bengal Co-operative Societies Act 2006, is the cleanest, because the old books close and are audited as one year. A mid-year switch works too, but you must carry forward the year's income and expense totals as well as balances.
Our last year's audit is not finished. Can we start?
Yes, on provisional figures. Mark them as provisional, keep a list of items the auditor may change, and post adjusting entries dated after the cut-over once the audit is final, with a note referring to the audit report.
Should we enter every old bill or just each flat's balance?
For most societies, one opening balance per flat is enough, with the old ledger kept and accessible for history. If a flat has a disputed item, enter the disputed part separately so it can be tracked on its own.
What if the member balances do not add up to the books?
Do not force them to agree with a balancing figure. Find the difference: usually an unallocated receipt, an advance netted against dues, or an old write-off not reflected in the ledger. Park anything unresolved in a named suspense line with a note and clear it within the first months.
Should members see their opening balance before the first bill?
Yes. Send each member their opening balance with a short statement of how it was arrived at and a date to raise queries. It is easier to correct before the first bill than after the first reminder.
Sources and review
- West Bengal Co-operative Societies Act 2006, Gazette copy (FAOLEX) faolex.fao.org
- West Bengal Co-operative Societies Rules 2011, notification copy (ICMAI) icmai.in
- Extract of the Act including s.97 (audit) – ICMAI Annexure icmai.in
Facts checked against the sources listed on 3 October 2026.
Next step: create a free account at /register or read the society management guide.
