Every residents association should reconcile estate payments regularly instead of waiting until the AGM or the end of the year to discover that its bank balance does not match its records.
Reconciliation simply means comparing what the estate says happened with what actually happened at the bank.
If the resident ledger says N12 million was collected during June but the bank statement shows N11.6 million, management needs to explain the N400,000 difference.
That difference could be a missing transaction, bank charge, failed payment, duplicate entry, transfer still waiting to be identified or an accounting mistake.
Finding it in June is much easier than finding it nine months later.
What does estate payment reconciliation mean?
Payment reconciliation compares different records until they agree.
For an estate, the main records are usually:
- bank statement;
- resident payment ledger;
- payment platform statement;
- receipts issued;
- wallet or app transactions;
- cash records where cash is still accepted;
- and records of refunds or reversals.
Suppose House 12 owes N400,000.
Management's system shows the resident paid the full amount on 15 June.
The bank statement should contain the corresponding money.
If it does not, management needs to investigate.
The reverse can also happen.
The bank statement may contain a N400,000 transfer, but no resident account has been credited.
That means the money exists but has not yet been properly identified.
The Central Bank of Nigeria's electronic payments regulation emphasises reliable audit trails as an important part of electronic collections and payments. (CBN)
That principle matters for estate collections too.
Every payment should be traceable from the resident obligation through to the estate's financial records.
What records should you collect before reconciling?
Do not start by looking only at the bank statement.
Gather all the records covering the same period.
For example, for June reconciliation, collect:
- bank statement from 1 June to 30 June;
- resident payment report for June;
- payment gateway or platform statement;
- refund records;
- reversal records;
- transfer charges;
- cash deposits if applicable;
- and previous month's reconciliation.
Also confirm the opening balance.
The closing reconciled balance from May should become the starting point for June.
If you keep changing the opening figure until the numbers fit, you are not reconciling.
You are hiding an error.
The estate should also maintain clear records of what each resident was charged.
A payment cannot be reconciled properly if nobody knows what the money was intended to settle.
For example:
House 15 may have:
Annual service charge: N500,000
Security levy: N100,000
Previous credit: N50,000
If the resident pays N450,000, management needs to know how that payment should be allocated.
Use the estate payment receipts and records guide to make sure the underlying transaction records are complete.
How do you match bank transfers to residents?
Start with transactions that are easy to identify.
Match them using information such as:
- amount;
- payment date;
- resident name;
- house number;
- transaction reference;
- bank narration;
- and payment platform reference.
Then mark each successful match.
Problems usually arise when the name on the transfer does not match the resident.
For example, House 31 may belong to Ada Okeke but the bank transfer arrives from:
Chinedu Okeke.
Another resident may pay from a company account.
Someone else may ask a relative to make the transfer.
This is why relying only on payer names creates problems.
Where possible, the payment process should capture the property or resident account before the transaction is made.
If that is not possible, place unmatched transactions into an unidentified payments list.
Do not simply credit a random household because the amount looks similar.
Contact the likely payer or wait for supporting information.
Likewise, do not assume every screenshot represents a successful payment.
Check that the corresponding credit actually reached the estate's account.
Residents using digital payments should follow a structured process such as the one explained in how to pay estate dues online in Nigeria.
What should you do with failed, duplicate or reversed payments?
Not every attempted payment is successful.
Your reconciliation process needs separate treatment for:
- failed payments;
- pending transactions;
- duplicate payments;
- reversals;
- excess payments;
- refunds;
- and charge disputes.
Failed payment
If the transaction did not successfully settle, it should not remain recorded as though the resident paid.
Pending payment
Do not treat it as final until settlement is confirmed.
Duplicate payment
If a resident pays twice, record both transactions.
The second payment may become a credit or be refunded according to the estate's approved process.
Reversed payment
If money initially appears successful and is later reversed, the resident account needs to reflect that change.
Excess payment
An extra amount may be retained as prepaid credit if properly agreed, or refunded.
CBN's electronic payment regulation specifically addresses duplicate and excess electronic payments and requires wrongfully received or excess funds to be made available for refund through the appropriate financial institution. (CBN)
The important rule is:
Do not silently delete transactions.
Keep the history.
If N500,000 was paid and later N500,000 was reversed, both events should remain visible.
That creates a clearer audit trail than editing the original transaction until it looks as though nothing happened.
How do you know the month has reconciled correctly?
At the end of the process, management should be able to explain the movement between the opening and closing bank balance.
A simplified calculation is:
Opening bank balance
plus
money received
minus
money paid out
plus or minus
valid reconciling adjustments
equals
closing reconciled balance
Suppose:
Opening bank balance: N10,000,000
Resident collections: N8,000,000
Other income: N500,000
Estate expenditure: N5,500,000
Expected closing balance:
N13,000,000
If the bank statement shows N12,950,000, there is a N50,000 difference.
Management should identify it.
Perhaps the bank deducted charges.
Perhaps a transfer was recorded twice in the estate ledger.
Perhaps one outgoing payment was never entered.
The answer should not be:
Close enough.
Every unexplained difference should remain on a reconciliation list until it is resolved.
This process should also connect to the estate's bank account and treasury controls.
The person reconciling the account should ideally not be the only person who can initiate and approve every payment.
That separation makes errors and irregular transactions easier to detect.
What should the monthly reconciliation report show?
The final report does not need to be complicated.
It should show management:
Opening bank balance
The confirmed starting balance.
Collections received
Resident dues, levies and other estate income.
Other credits
Refunds, interest or other legitimate money received.
Payments made
Estate expenditure during the month.
Bank charges
Where applicable.
Unidentified payments
Money received but not yet matched to a household or purpose.
Uncleared items
Transactions requiring further investigation.
Closing bank balance
The actual bank position.
Closing reconciled balance
What the estate records say should exist after valid adjustments.
Then add a short list of unresolved items.
For example:
N250,000 received on 18 June - payer not identified.
N75,000 resident payment recorded - bank credit not located.
N20,000 duplicate payment - refund awaiting approval.
These items should remain visible the following month until resolved.
Do not remove an unexplained difference merely because a new month has started.
The reconciled figures should eventually feed into the estate budget vs actual report and the estate financial report for the AGM.
If monthly reconciliation is clean, preparing the AGM accounts becomes much easier.
How does Kompound make payment reconciliation easier?
The easiest way to reconcile estate payments is to reduce the number of unidentified transactions before reconciliation even begins.
Kompound starts with the resident's account.
Management creates the charge.
The household sees the amount owed.
Payments then remain connected to the resident's estate record rather than beginning as an unexplained transaction on a bank statement.
Kompound's current platform includes:
- automatic dues billing;
- one-off levies;
- payments;
- resident wallets;
- statements;
- exemptions;
- prepaid credits;
- reminders;
- and reporting. (Kompound)
Kompound describes its payment system as documenting every charge and payment so the estate can maintain statements that balance instead of reconstructing transactions during EXCO handovers. (Kompound)
Residents can fund their wallets using card or transfer and then use the wallet for dues, bills and services.
That creates a clearer chain:
Household
Charge
Funding transaction
Payment
Statement
The platform's current pricing also says that Kompound does not take a percentage from estate dues. The amount residents pay toward estate obligations belongs to the estate, while Kompound is paid through a separate software subscription. (Kompound Pricing)
That makes the accounting easier to understand because the estate does not have to calculate an undisclosed platform percentage before deciding what a resident has paid.
But Kompound should not replace bank reconciliation.
The bank account remains an independent financial record.
Management should still compare:
Kompound payment records
against:
the estate's bank and payment-provider records.
The difference is that much of the resident-level matching has already happened.
Instead of spending hours asking who sent each transfer, the treasurer can focus on genuine exceptions.
That is what good reconciliation should become.
Not a monthly investigation.
A routine financial control.