Reconciliation means explaining a difference
A reconciliation compares two independently maintained records. For a bank account, one is the business ledger and the other is the bank statement. Mobile-money merchant statements and payment-processor reports need the same discipline. A matching final balance is useful only when the difference has been explained transaction by transaction.
Choose a clear cut-off date and use a complete statement. Confirm the opening balance first. If the previous month was never reconciled, this month's unexplained difference may be inherited. Do not begin by posting a miscellaneous adjustment simply to make the closing number look right.
Match like with like
Tick off transactions using reference, date and amount. A customer payment may appear in the ledger on the day advice was received and in the bank a day later. A batch settlement may combine many sales and deduct fees. Match the underlying sales report to the settlement report before assuming a short deposit means a missing sale.
Use a separate list for outstanding payments, outstanding receipts, statement items missing from the ledger and ledger entries that lack independent evidence. Keep the original currency attached to every amount; reconciling a USD statement against an unlabelled mixed-currency cashbook produces confusion, not assurance.
An original example
Suppose the ledger shows 920 while the bank statement shows 985 at month-end. An outstanding supplier payment of 100 has been recorded in the ledger but has not reached the bank. A customer receipt of 50 appears only on the statement, and bank charges of 15 also appear only on the statement.
Adjust the statement comparison for the outstanding payment: 985 minus 100 equals 885. Update the ledger for the missing receipt and fee: 920 plus 50 minus 15 equals 955. These numbers do not agree, so another 70 remains unexplained. A reconciliation is not complete because several plausible items were found; the residual must still be investigated.
Cash and merchant settlements
For physical cash, count the float independently and compare it with the expected balance after receipts, payments and cash banking. Record the denominations and obtain a second-person check where possible. Cash shortages should be documented and investigated under a consistent policy.
For merchant accounts, distinguish gross customer payments, reversals, transaction fees, transfers to bank and the unsettled closing balance. Record fees as fees rather than reducing reported sales without explanation. Keep the provider's export and settlement references with the reconciliation.
Close the loop
Where an unexplained movement may indicate fraud, preserve the records and restrict changes while obtaining appropriate professional help. A reconciliation is an early-warning control, not permission to conceal a difference under a convenient account name.
- Investigate duplicates using transaction IDs, not amount alone.
- Follow up old outstanding items rather than carrying them indefinitely.
- Record approved corrections with dates and reasons.
- Have someone other than the preparer review high-risk accounts.
- Save the statement, reconciliation and evidence together.
Sources & further reading
Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.
This guide is general information. Source notes are not a claim of independent professional review.