Business

Bank reconciliation statement: four reasons books and bank differ

A bank reconciliation statement bridges your books and the bank balance. See four reasons they differ in a worked example, from cheques to errors.

Editorial illustration for Bank reconciliation statement: four reasons books and bank differ

A bank reconciliation statement is a short list that explains the gap between the balance in your books and the balance on your bank statement. The gap almost always comes from a handful of causes: a cheque that has not cleared, a deposit still on its way, a charge you did not know about, or a mistake in your own entry. Listing them turns a worry into arithmetic.

Why do the two balances differ?

Your books record things when you decide them. The bank records them when they happen. That timing gap, and the odd mistake, explains almost every difference. Here are the four reasons you will meet most often.

  1. A cheque you wrote has not yet been presented to the bank, so the bank balance is still higher than your books.
  2. A deposit you made is still in transit, so your books show it but the statement does not yet.
  3. The bank charged a fee or interest that you have not recorded.
  4. You made an error, such as entering ₹5,400 when the true figure was ₹4,500.

What does a worked example look like?

All the numbers are invented. The bank statement shows ₹84,500 at month end. A cheque for ₹6,000 you issued has not cleared. A deposit of ₹10,000 was made late in the day and is not on the statement yet. The bank charged ₹236 which you have not recorded. And you recorded a ₹4,500 payment as ₹5,400.

Bank sideAmount (₹)Books sideAmount (₹)
Balance per bank statement84,500Balance per your books87,836
Add deposit in transit+10,000Less bank charge not recorded-236
Less cheque not yet cleared-6,000Add back the entry error (5,400 - 4,500)+900
Adjusted bank balance88,500Adjusted book balance88,500

Work through each side. The bank side is 84,500 plus 10,000 minus 6,000, which is 88,500. The books side is 87,836 minus 236, which is 87,600, plus 900, which is 88,500. The two adjusted balances agree, so the difference is fully explained.

How do you do it step by step?

  1. Tick every line that appears in both the statement and your books.
  2. List the lines in your books with no tick: these are cheques and deposits still in motion.
  3. List the lines on the statement with no tick: these are charges or credits you have not recorded.
  4. Adjust the bank balance for the timing items, and your book balance for the items you did not know about.
  5. If the two adjusted figures still differ, look for an error: a transposed number, a payment recorded twice or a missing entry.

What if the difference will not go away?

A difference that divides exactly by 9 often points to two digits swapped, such as 5,400 written for 4,500, whose gap is 900. Otherwise, check for a duplicated entry, an entry on the wrong side, or a month boundary where one item landed in the next month.

Where a tracker fits in

Importing your statement into SpendixAI, with the right account chosen, gives you the bank's side of the story row by row, and you review each row before saving. Possible duplicate imports are flagged, which catches one common cause of a mismatch. Your own record of cheques not yet cleared still needs a note of its own.

If you lose track of a cheque, check its date and number against your cheque book stub, not your memory. A stale cheque that never clears is worth a call to the person you paid, and it may need a fresh cheque or a UPI transfer instead.

A short monthly checklist

  • Statement balance noted, with the date.
  • Cheques and deposits in motion listed.
  • Unrecorded charges added to your books.
  • Both adjusted balances written down, and agreeing.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports