ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Blog / Accounting · Procura team · Updated November 18, 2026 · 9 min read
Accounting

Bank reconciliation: definition, a 6-step method and a worked example

Why the bank balance and the book balance differ, the step-by-step method, a complete reconciliation statement with the entries to post, and the checks that stop differences from lingering.

Once
a month per account, at least
2 columns
Adjusted statement, adjusted books
0
Unexplained difference targeted at month end
÷ 9
The transposed-digits test

01Bank reconciliation in one sentence

Bank reconciliation means comparing, at a given date, the balance of the bank account in your books with the balance on the statement sent by the bank, then explaining each difference. The document holding that explanation is the bank reconciliation statement.

The account depends on the framework: 512 « Banques » in the French chart of accounts (PCG), 521 « Banques locales » (class 52) in revised SYSCOHADA, and a Cash or Bank account in whatever chart you use in Canada. The logic is the same everywhere.

The two balances are almost never equal, and that is not an anomaly: the bank and your books do not record the same transactions on the same day. The anomaly is a difference nobody can explain.

02The five causes of a difference

First cause, transactions booked but not yet through the bank: a cheque handed to a supplier who has not cashed it yet, a customer cheque deposit made on the 30th and credited on the 2nd. They adjust the statement balance.

Second cause, transactions through the bank but not yet booked: fees and commissions, overdraft interest, direct debits (insurance, subscriptions), customer transfers whose receipt nobody has entered yet. They adjust the book balance, and each one needs an entry.

Third cause, entry errors: transposed digits (1,524 instead of 1,254), a transaction entered twice, an entry on the wrong bank account. A simple clue: when the remaining difference divides by 9, look for two transposed digits first. 1,524 minus 1,254 is 270, which is 9 times 30.

Fourth cause, bank errors, rare but real: another customer's transaction, a duplicated debit. They are settled with the bank, not with an entry.

Fifth cause, the cut-off date: a statement closed on the 31st compared with books entered up to the 3rd of the next month. Always reconcile two balances at the same date.

03The 6-step method

Step 1, gather the documents: the month's bank statement, the general ledger of the bank account for the same period, and the previous month's reconciliation statement, whose outstanding items must be found first.

Step 2, tick off last month's outstanding items: the cheque not cashed at the end of September must appear on the October statement. If it still does not, it stays outstanding and needs following up.

Step 3, tick line by line: each statement movement against a ledger entry for the same amount. Start with exact matches, then handle grouped amounts (one deposit of five cheques against five receipts).

Step 4, list what remains: statement lines without an entry on one side, entries without a statement line on the other.

Step 5, build the two-column reconciliation statement: the statement balance adjusted for transactions booked but not yet through the bank, and the book balance adjusted for bank transactions not yet booked and for errors. Both adjusted balances must be equal.

Step 6, post the adjusting entries in the books (fees, direct debits, transfers received, corrections), then file the signed statement with the bank statement. That file is one of the first documents an accountant or auditor asks for.

04Worked example: the reconciliation statement at 31 October

At 31 October, the bank account in the books shows a debit balance of 18,450.00. The bank statement shows 22,380.00 in the company's favour. Gross difference: 3,930.00. Ticking leaves six items.

Statement side: cheque no. 4512 for 2,400.00 handed to a supplier on 28 October has not been debited yet; a customer cheque deposit of 1,150.00 made on 30 October has not been credited yet. Adjusted statement balance: 22,380.00 - 2,400.00 + 1,150.00 = 21,130.00.

Book side: 38.00 of bank fees and an insurance direct debit of 412.00 were not entered; a customer transfer of 2,860.00 arrived on the 31st without being recorded; finally, a supplier transfer of 1,254.00 was entered as 1,524.00, so 270.00 too much credited to the bank. Adjusted book balance: 18,450.00 - 38.00 - 412.00 + 2,860.00 + 270.00 = 21,130.00.

Both adjusted balances are equal: the reconciliation is done. Now the entries. Under the French PCG: debit 627 Bank services 38.00 and debit 616 Insurance premiums 412.00, credit 512; debit 512 for 2,860.00, credit customer 411; debit 512 for 270.00, credit supplier 401. Under SYSCOHADA, the same entries use 631 Bank charges, 625 Insurance premiums and 521 Local banks.

The two statement-side items (the cheque and the deposit) need no entry: they simply have to appear on the November statement. That is the first check of the following month.

05The checks that stop differences from lingering

Never park a difference in a suspense account to « close » the reconciliation. A difference forced in October becomes an untraceable difference in March, when nobody remembers the documents any more.

Track the age of outstanding items: a cheque issued and not cashed for more than two months deserves a call to the supplier (lost, forgotten, or to be cancelled and reissued). A deposit not credited after a few days must be raised with the bank.

Separate roles when the team allows it: the person who enters payments is not the one who signs the reconciliation. It is a basic internal control, because reconciliation is where a diverted payment would eventually show.

Reconcile every account, including rarely used ones, foreign-currency accounts and e-money or Mobile Money accounts, which work exactly like a bank. An account nobody reconciles is an account where errors pile up.

Finally, document it: the reconciliation statement carries its cut-off date, the name of the person who prepared it, the name of the reviewer, and the itemised list of outstanding items with their original dates. A statement without a date or a signature proves nothing in a review.

06In Excel or in software

For a few dozen movements a month, a spreadsheet is enough, provided you are rigorous. Our bank reconciliation Excel template ticks every statement line against your registers and shows the total of unexplained lines, which you bring to zero at month end.

Beyond that, manual ticking becomes the bottleneck of the close. In Comptia, the statement is imported (CSV file), obvious matches are proposed automatically (same amount, close dates or a reference in the description), the others are matched by hand, and the reconciliation statement is produced at any date: book balance, entries not yet on the statement, statement lines not yet booked.

Bank reconciliation is also a step of the month-end close: without it, neither VAT, nor cash, nor the month's result can be trusted.

Frequently asked questions

How often should you reconcile the bank?

At least once a month per account, at the statement end date. Companies with many movements do it weekly, or even daily: the shorter the interval, the easier differences are to explain.

What is the difference between bank reconciliation and matching (lettrage)?

Reconciliation compares the bank and the books. Matching (lettrage) pairs, inside the books, an invoice with its payment on a customer or supplier account. They complement each other: a transfer received is first reconciled with the statement, then matched with the invoice it pays.

What do you do with a difference you cannot explain?

Redo the month's ticking starting from the last correct reconciliation, test divisibility by 9, check grouped amounts and transactions posted to another bank account. If the difference persists, ask the bank for the detail rather than posting it to a suspense account.

Does every unbooked statement item need an entry?

Yes, except bank errors. Fees, direct debits, transfers received and interest are real transactions the books must record. Transactions booked but not yet through the bank need no entry.


Sources & references

Free guide

The P2P Playbook for Africa.

Seven concrete levers to digitise your procure-to-pay cycle, SYSCOHADA, MeCEF, FNE, Mobile Money. PDF, 12 pages, free.

No spam, ever. One-click unsubscribe.

See Procura on your real data.

From need to payment, your purchasing cycle in a 30-minute demo.