Most societies keep two separate records of the same money: the internal ledger — bills raised, payments logged, expenses recorded — and whatever the bank statement actually shows. In theory the two always match. In practice they drift: a payment logged against the wrong bill, a bank charge nobody entered, an expense paid by cheque that cleared three weeks after it was recorded. Nobody notices until an annual audit, months later, when tracing a single mismatch back to its cause is nearly impossible.
Upload a statement, get a match — not a spreadsheet exercise
Nivas Portal lets a society upload its bank statement as a CSV export directly from net banking. Every line on that statement is automatically compared against the society’s own ledger — bills collected, expenses paid, and other income — and matched by amount, date proximity, and reference. What matches cleanly is confirmed in one pass; what doesn’t is surfaced separately as an ambiguous or unmatched line, instead of being silently ignored or requiring someone to manually tally two hundred rows by eye.
- Confident matches (amount, date and reference all line up) are suggested automatically, not decided in the dark.
- Ambiguous lines — more than one plausible ledger entry for a bank line — are shown with every candidate, so a human makes the final call instead of a silent auto-match guessing wrong.
- Unmatched bank lines stay visible as open items until someone resolves them, rather than quietly falling off the bottom of a spreadsheet.
Why this can’t wait for the annual audit
A mismatch that surfaces the week it happens is a two-minute fix — check the reference, correct the entry, move on. The same mismatch found eleven months later, during an audit, means reconstructing what happened from memory or a paper trail that may not even exist anymore. Reconciling continuously, not annually, is what actually keeps a society’s books trustworthy between one AGM and the next.
None of this replaces a proper annual audit or a chartered accountant’s sign-off — it makes sure the books that eventually reach the auditor already match the bank, instead of the audit being the first time anyone checked.
Reconcile your society’s bank statement automatically, every month — start a free trial or read the step-by-step setup guide at nivasportal.com. Related read: a fund balance that answers itself.