Monthly Bank Reconciliation for Housing Societies — A Treasurer's Process

What is bank reconciliation

Bank reconciliation is the monthly process of matching every transaction in your society's books with every transaction in the bank statement, identifying any differences, and resolving them.

It catches:

• Missing payments (resident paid but invoice not marked)
• Bounced cheques (money never landed but recorded as paid)
• Bank charges (fees deducted but not booked)
• Wrong-amount payments (resident paid less / more than invoice)
• Fraudulent transactions (rare but possible)

Without reconciliation, your books drift further and further from reality each month.

The 5-step monthly process

### Step 1: Download bank statement (1st of next month)

Most banks let you download monthly statements as CSV / Excel from net banking:

• HDFC: Statements → Download → Choose period → CSV
• ICICI: Account Summary → Download → Excel
• SBI: Statement → Choose period → Download

Save with a clean filename (e.g. HDFC_2026-04.csv).

### Step 2: Import into HiSociety

Bank Reconciliation module → Import CSV → upload your statement.

HiSociety auto-detects the format (works with SBI/ICICI/HDFC/Axis/Kotak/PNB), parses the date, debit/credit columns, and reference numbers.

### Step 3: Run auto-match

Click "Auto-match". The system finds bank credits that match recorded payments by:

• Exact amount
• Date within ±3 days
• Reference / UTR number (if matching)

Most credits auto-match in seconds. Reconciled = green.

### Step 4: Manually review unmatched

Some credits won't auto-match because:

• Resident paid an unusual amount (₹4,503 instead of ₹4,500 — bank rounding)
• Description text was different
• Cheque was deposited but received from a different account

For these, manually link to the right invoice. HiSociety suggests likely matches based on amount + month.

### Step 5: Investigate exceptions

Once 95%+ of transactions are matched, you'll have a small "exceptions" list:

• Bank charges — book as expense
• Interest credit — book as income
• Bounced cheques — mark invoice as unpaid + send notice
• Unknown credits — investigate; could be a member who paid but didn't tell you
• Unknown debits — could be unauthorised; alert bank immediately

Common reconciliation issues

### Issue 1: UTR mismatch

Resident says they paid via UPI on 28 April. Your bank shows the credit on 30 April (UPI sometimes takes 2 days). Both are correct; just mark the payment date as 28 April but reconcile against 30 April credit.

### Issue 2: Lump-sum payment

A resident pays for 3 months at once (e.g. ₹15,000 covering Jan + Feb + Mar). Bank shows one credit; your invoices are 3 separate. In HiSociety, click "Apply to multiple invoices" → select the 3 → distribute amount.

### Issue 3: Partial payment

Resident pays ₹3,000 against a ₹5,000 invoice. Mark invoice as "Partially paid" with ₹2,000 outstanding. Don't close it.

### Issue 4: Bounced cheque

Bank statement shows a cheque deposit followed 3 days later by a debit (the bounce). Both transactions need to net out, and the original payment marked as cancelled. The resident should be sent a fresh demand notice + bank charges (typically ₹250-₹500) added.

### Issue 5: Razorpay settlement

Razorpay settles in lump sums (T+2). One settlement on Tuesday includes payments from 47 residents on Sunday + Monday. Razorpay's daily report breaks this down — match each Razorpay settlement to multiple invoices.

HiSociety's Razorpay integration auto-handles this — you don't need to manually distribute.

Why reconcile monthly (not quarterly)

Quarterly reconciliation makes problems exponentially harder:

• 3× more transactions to review
• Members forget what they paid 60 days ago
• Bank's online statement only goes back 90 days for some accounts
• Late discovery of fraud means more loss

Monthly = 30 minutes. Quarterly = 4-6 hours. Annually = a weekend of stress.

Sign of a healthy reconciliation

• 95%+ auto-match rate
• Time to reconcile: under 30 minutes
• Bank balance per books = bank balance on statement (no "stale outstanding cheques")
• Outstanding cheques < 1 month old
• No unidentified transactions for more than 30 days

Audit prep

Auditors will ALWAYS ask for:

• Monthly bank reconciliation statements (12 of them)
• List of outstanding cheques as of 31 March
• Bank statements for full FY
• Bounced cheque register
• Razorpay settlement statements

If you've reconciled monthly, this is a 1-hour audit prep. If you haven't, it's a week of catch-up.

How HiSociety helps

• One-click CSV import (any major Indian bank)
• Auto-match algorithm (95%+ accuracy in real societies)
• Razorpay direct integration (no manual settlement reconciliation)
• Monthly reconciliation status dashboard (see at-a-glance which months are clean)
• Audit-ready reports (export PDF for CA)

Conclusion

Bank reconciliation is unsexy but it's the foundation of trust between your committee and your residents. Get this right monthly, and your audit goes smoothly, defaulter notices are accurate, and treasurer transitions are painless.

Read next