What to do when your books do not match your bank balance

What to do when your books do not match your bank balance | Business Elites Africa

A mismatch between your accounting records and your actual bank balance is more than an administrative headache. For a growing business, unexplained discrepancies can distort cash flow projections, lead to overpaying taxes, or result in costly compliance penalties.

When books do not match bank balance figures, the issue often stems from timing differences, unrecorded fees, or simple manual entry errors. Left unresolved, these gaps make it difficult to secure external credit, attract investors, or file accurate returns with tax authorities like Nigeria’s Federal Inland Revenue Service.

Identify the common culprits in African business transactions

In many African markets, payment processing ecosystems introduce unique reconciliation challenges that are easily overlooked during manual data entry.

A frequent source of discrepancy is the treatment of payment gateway fees. Providers such as Paystack, Flutterwave, or Moniepoint often settle transactions net of their processing fees, meaning an invoice of ₦100,000 might appear on your bank statement as ₦98,500.

If your team records the full invoice value as the cash received without booking the ₦1,500 processing charge as an expense, your ledger and bank balance will immediately diverge.

Withholding tax deductions present a similar challenge. Corporate clients in Nigeria frequently deduct withholding tax at source before paying invoices, meaning your bank receipt will be lower than the invoiced amount.

Additionally, local banks routinely levy charges such as the Electronic Money Transfer Levy, account maintenance fees, and SMS charges that do not appear in your daily ledger until you manually import your monthly bank statements.

Run a structured reconciliation process

To resolve the discrepancy, you must systematically compare your general ledger against your physical bank statements for the affected period.

Start by aligning the timeframes, ensuring that you are comparing transactions within the exact same opening and closing dates.

Tick off every cleared transaction on your bank statement against the corresponding entry in your accounting books. This process will isolate items that appear in one record but not the other.

List all outstanding checks or outgoing bank transfers that your business has authorised but which the bank has not yet processed. These represent timing differences that will resolve themselves in the next billing cycle.

Next, identify deposits in transit. These are payments received and recorded by your business, such as weekend cash sales or late-Friday bank transfers, that have not yet cleared the banking system.

Adjust the ledger and establish preventive controls

Once you have identified the specific transactions causing the mismatch, you must update your accounting records to reflect the actual cash position.

Prepare adjusting journal entries for all unrecorded bank fees, interest earned, tax deductions, and payment gateway charges. Do not adjust your bank statement, as that remains the immutable record of truth.

To prevent future mismatches, transition from monthly reconciliations to a weekly or daily schedule. Frequent checks allow your team to spot duplicate transactions or unauthorised debits before they compound.

Whenever possible, integrate your business bank accounts with modern accounting software. Automated bank feeds pull transaction data directly into your ledger, reducing the manual entry errors that typically cause book balances to drift from actual bank balances.

Handle failed transactions and POS reversals

In countries with volatile banking networks, failed Point of Sale (POS) transactions and delayed bank transfers are common. Merchants often face situations where a customer’s account is debited but the funds do not reflect in the merchant’s settlement account.

These disputed transactions should be logged in a separate suspense account rather than being booked as successful sales. This prevents your sales revenue from looking artificially high while your actual bank balance remains short.

Related Business Elites Africa Coverage

Leave a Reply