Common mistakes in bank reconciliation (and how to avoid them)

Bank reconciliation is a reliable topic to score on, because the method is fixed and the question types are limited. Yet it trips students up more than it should, usually because of the order they work in and the side they put items on. Here are the mistakes we see most often in lessons, and the habits that fix them.

Starting from the wrong balance

The biggest error is starting from the uncorrected cash book balance. First update the cash book for items on the bank statement that are not yet in your records.

Examples are bank charges, standing orders, direct debits and dividends received. Then start the reconciliation statement from the corrected cash book balance.

Think of two separate stages and leave a gap between them on your page. Stage one is the cash book update. Start with the cash book balance.

Add anything the bank credited that you had not recorded, and deduct anything the bank debited that you had not recorded. Stage two is the reconciliation statement, which starts from the corrected figure. Students who blur the two stages into one column end up reconciling to a number that means nothing.

Adding what should be subtracted

Start from the corrected cash book balance. Unpresented cheques (written and recorded, but not yet paid by the bank) are added. Uncredited lodgements (paid in and recorded, but not yet on the statement) are subtracted.

This gives the bank statement balance. Students often swap them.

To remember: with an unpresented cheque, the bank still shows more money than your corrected cash book, so you add to reach the bank’s figure.

A worked mini-illustration

These figures are invented to show the method. A business has an uncorrected cash book balance of RM4,200.

The bank statement shows bank charges of RM60, a standing order for insurance of RM240 and interest received of RM30, none yet recorded. Stage one: RM4,200 - RM60 - RM240 + RM30 = RM3,930, the corrected cash book balance.

Now stage two. Two cheques totalling RM800 have been written and recorded but not yet paid by the bank. A lodgement of RM500 has been recorded but is not yet on the statement.

• Balance as per corrected cash book: RM3,930
• Add unpresented cheques: RM800
• Less uncredited lodgement: RM500
• Balance as per bank statement: RM4,230

If you can reproduce this flow on figures you have never seen (update first, then add unpresented, then subtract uncredited), the topic is secure.

Confusing timing differences with errors

Unpresented cheques and uncredited lodgements are timing differences. They will clear on their own and need no entry in the books. Bank charges, direct debits and interest are items to record in the cash book.

Mixing these up leads students to “correct” a timing difference in the cash book, or to leave a real charge out of it. Ask one question of each item: has the business already recorded this? If yes, and the bank has not caught up, it is a timing difference and stays out of the cash book. If it first appeared on the statement, record it in the cash book update.

Forgetting that the bank’s view is the mirror of yours

On a bank statement, a deposit shows as a credit and a payment as a debit. That is the opposite of how the business records them, because the money is a liability the bank owes you.

Do not try to match the signs directly. You only need to reconcile the two closing balances.

This is the same two-sided thinking you use everywhere in double entry. The same money is an asset in your books and a liability in the bank’s.

The overdraft edge case

When the account is overdrawn, the business owes the bank, so the corrected cash book balance is a minus figure. Students often panic and flip every sign.

Keep the overdraft marked as negative throughout. Apply the usual rule (add unpresented cheques, subtract uncredited lodgements), then check that the final bank statement figure is also an overdraft of a sensible size.

Not dealing with a dishonoured cheque

If a customer’s cheque is dishonoured, the money never arrived. Reduce the cash book by that amount and reinstate the customer’s account as a receivable. Forgetting this throws the whole reconciliation out by exactly that amount.

Ignoring errors in the cash book itself

Sometimes the difference comes from an arithmetic error or a transposed figure in the cash book, not a timing item. If the reconciliation will not balance and every timing item is dealt with, check the additions and individual entries. A difference of RM90, which divides by nine, often signals a transposition.

Presentation that loses easy marks

Label the statement clearly: “Balance as per corrected cash book”, then the adjustments, then “Balance as per bank statement”. Show a plus or minus against each item. A tidy statement earns presentation marks and makes your own slips easier to spot.

Why this matters in the real accounts

The corrected cash book balance is the figure that appears under current assets in the statement of financial position. It is not the raw bank statement balance. This is why the update stage exists: it produces the number the business controls at the year end.

Drilling the method

Work through several questions. Each time, update the cash book first and sort items into timing differences and items to record. After a few, the order becomes automatic.

If bank reconciliation still causes confusion, one of our teachers can go through the two-stage method with your child and isolate the exact step that trips them up. Book a trial class to get started.

Syllabus reference: Cambridge 0452 and 0985, syllabus for 2027 to 2029, sub-topic 3.3 Bank reconciliation (page 13).