Bank reconciliation: steps and common errors to avoid

Bank reconciliation compares two views of the same reality: the bank account recorded in the company's accounting system and the statement produced by the bank. The balances are not always identical at the same moment. A cheque may be recorded but not yet cleared, a transfer may appear on the statement before it is entered, or bank charges may be missing from the books.

The purpose is not to change a number until both columns look alike. The purpose is to explain every difference with a date, an amount and supporting evidence. A successful reconciliation leaves a clear trail of matched items, transactions still in circulation and corrections that need to be posted.

Before you begin, take CMCG's free accounting level quiz to review the logic of the bank account, debit and credit.

Documents you need

Prepare the complete file before matching lines. You will normally need:

• the bank-account ledger or trial balance detail;
• the bank statement for the same period;
• the previous month's reconciliation;
• support for transfers, cheques, deposits and direct debits;
• notices for fees, interest and other bank transactions;
• a list of entries already identified as outstanding.

Confirm that the accounting account and the statement refer to the same bank account, currency and period. A simple mix-up between accounts or months makes the entire matching exercise inconsistent.

Why do the balances differ?

Differences usually fall into three families.

This distinction matters. A timing difference is not necessarily an error. In contrast, a missing entry should not remain on reconciliation after reconciliation; it should be processed with appropriate support.

Step 1: bring forward the previous reconciliation

Begin with unmatched transactions from the previous month. Search for them on the new statement. An old cheque may now have cleared, or a deposit in transit may now appear.

If an item remains unmatched for several periods, do not copy it forward mechanically. Ask why it has not cleared. Was it cancelled, rejected, duplicated or genuinely still outstanding? Age is a control signal.

Step 2: match exact correspondences

Compare the statement lines with the ledger. Start with the simplest matches: the same amount, a close date and a consistent description. Mark each pair with one clear matching reference.

Work in a stable order:

1. opening balance and brought-forward items;
2. receipts and incoming transfers;
3. supplier payments and direct debits;
4. fees, interest and commissions;
5. unusual transactions or exceptional amounts.

Never match two lines only because the amounts are equal. Different transactions can share the same value. The date, beneficiary, reference and source document should confirm the connection.

Step 3: isolate unmatched lines

After the first pass, some lines remain on the statement and in the ledger. Ask a specific question for each one.

• Statement only: is an accounting entry missing?
• Ledger only: is the transaction still outstanding?
• Similar but different amount: is there a fee, withholding or entry error?
• Same amount appears several times: which reference identifies the correct transaction?

Write a short explanation for every difference. “To check” is not a useful conclusion. Name the person, document or action needed to resolve it.

Step 4: post missing transactions

Bank fees, direct debits, incoming transfers or rejected payments may first become visible on the statement. Before posting anything, obtain the evidence or information that explains the transaction's nature.

Then record it in the appropriate journal. Do not post one general “bank difference” entry simply to make the balance work. An accounting entry must describe the real economic event.

Reconciliation does not manufacture agreement. It demonstrates why two sources reach the same balance after justified timing items are considered.

Step 5: calculate the reconciled balance

Present a clear bridge between the two balances. Depending on the template, start from the statement balance or the ledger balance, then add or subtract justified items. The result should reach the other source after necessary entries have been posted.

Check the direction of every adjustment. A common error is to add an item that should be subtracted. Explain each adjustment in words before including it in the calculation.

Common errors

• matching two lines simply because the amount is equal;
• forgetting items from the previous reconciliation;
• carrying an old difference without investigation;
• posting a transaction without support;
• forcing the balance with a plug entry;
• reversing debit and credit because the statement uses the bank's point of view;
• finishing without dating and documenting the review.

Final review checklist

Before treating the reconciliation as complete, confirm that:

• every matched line has an identifiable counterpart;
• missing entries have evidence and were posted;
• outstanding items are real, dated and still relevant;
• old items have been investigated;
• the bridge reaches the expected balance;
• the document states the period, account, preparation date and review.

Turn a control into a practical skill

Bank reconciliation combines several abilities: reading a statement, understanding the ledger, tracing evidence, analysing a difference and supporting a correction. It becomes easier when you work with a complete set of documents instead of one isolated line.

Begin with a short statement, then add outstanding cheques, fees and a rejected transfer. CMCG's practical accounting training connects this control with entries, documents and Sage work inside a coherent accounting file.