How to Read a Bank Statement: AI-Assisted Reconciliation

Most SMB owners look at their bank statement once a month, mentally check that "money is in there", and move on. That's reconciliation theatre, not actual reconciliation. Real reconciliation catches errors that compound over months and protects you from fraud, miscategorisation, and tax-time chaos.

What a bank statement actually shows you

Every bank statement has the same anatomy:

• Opening balance — what you started with on day 1.
• Credits (deposits) — money in. Customer payments, refunds, transfers from savings.
• Debits (withdrawals) — money out. Supplier payments, salaries, bank charges, card transactions.
• Closing balance — what's left on day 30.

The reconciliation process (manual)

Traditionally, reconciliation means:

• Open your bank statement and your accounting records side by side.
• For each statement transaction, find the matching entry in your books.
• Tick off matches. Investigate mismatches. Add missing entries.
• Confirm the closing balance matches.

For a 100-transaction month, this takes 2–4 hours. Most SMB owners skip it.

The AI-assisted process

Here's what bank reconciliation looks like with ereQa's AI:

• Upload the PDF or CSV statement (drag and drop).
• AI parses every transaction, extracts dates, amounts, and descriptions.
• AI categorises each transaction (Rent, Salaries, Software, Bank Fees, etc.).
• AI matches credits to your existing invoices and debits to your existing expenses.
• You review a clean dashboard showing matched/unmatched/needs-review.

Total time: 5–10 minutes for a typical month. The AI does the tedious work; you make the judgement calls.

What to look for during review

• Duplicate charges — software you signed up for and forgot to cancel. AI flags repeats.
• Bank fees you didn't expect — international wire fees, ATM charges, account maintenance fees.
• Refunds or chargebacks — these need to be linked to the original transaction.
• Missing income — payments received but never invoiced. Time to send the invoice.
• Personal expenses on the business account — separate them now to avoid tax-time problems.

Nigerian statement formats and what trips the parser

Each bank lays out its statement differently, and the differences matter more than they should. GTBank and Zenith issue clean PDFs with one transaction per row and a running balance. Access and First Bank wrap long narrations onto a second line, which is where a naive parser splits one transaction into two. UBA and Fidelity offer CSV export from the app, which is the format to prefer whenever it exists — no layout to interpret, and the dates arrive as dates rather than text. If a statement is a scanned image rather than a generated PDF, no parser will read it reliably; request the electronic version.

The lines that never match an invoice

A good share of “unmatched” transactions are not errors; they are bank mechanics that no invoice or expense will ever explain. Knowing them by sight turns reconciliation from an investigation into a tagging exercise.

• Electronic money transfer levy. ₦50 on each inbound transfer of ₦10,000 or more. Appears as “EMTL” or “stamp duty”. A bank charge, deductible.
• SMS alert and maintenance fees. A few Naira per alert, debited monthly in one line, plus 7.5% VAT in a separate line a day later.
• Transfer fees. ₦10 to ₦50 per outbound transfer, often batched. Match to the transfers they belong to, or tag the batch as bank charges.
• Withholding tax short-payments. An invoice for ₦100,000 arrives as ₦95,000 or ₦90,000. Not a partial payment: the client deducted WHT. Match the receipt to the invoice and record the difference as tax credit.
• Reversals. A failed transfer debited and credited back, sometimes days apart. Match the pair to each other and nothing else.
• Interest and charges on overdrafts. Deductible if the facility is for the business; tag them as finance costs, not bank charges.

A month-end checklist

1. Upload the statement for every business account, including the one you only use for the POS terminal.
2. Confirm the opening balance matches last month's closing balance. If it does not, a statement is missing or overlapping.
3. Accept the automatic matches, then work the unmatched list from largest to smallest.
4. Tag the bank mechanics above without investigating them individually.
5. Raise an invoice for any income that arrived without one, and record any expense that was paid without a receipt — then go and get the receipt.
6. Move personal transactions to drawings and resolve to stop making them from this account.
7. Export the reconciled month and file it. Next month you will only need to look at this one if a figure changes.

Make it a monthly habit

Set a recurring 30-minute calendar block for the 5th of every month. Upload last month's statement, review the AI matches, file the reconciliation report. Within 6 months, you'll have clean, audit-ready books and a real understanding of where your money goes.

See the full feature: Bank Reconciliation in ereQa.