Skip to content
Guide 03 · Books & closing

How to prepare a bank reconciliation statement

Your cash book and your bank statement record the same money, but rarely agree on the same day. A bank reconciliation statement explains every difference between them.

Updated
Reading time
4 min
The figure

₹1,48,150

The bank balance it ties to

Worked through below

The short answer

Start from the balance in your cash book. Add cheques you have issued that the bank has not yet paid, and credits the bank has given you that you have not recorded. Take off cheques you have deposited that the bank has not yet credited, and charges the bank has taken that you have not recorded. The result should equal the balance on the bank statement.

Why the two balances differ

Most differences are timing: one side has recorded something the other has not caught up with yet. A few are omissions that need an entry in your books, and occasionally one is a mistake on one side or the other.

  • Cheques issued but not yet presented: you have written them and recorded the payment, but the payee has not cashed them.
  • Cheques deposited but not yet credited: you have recorded the receipt, but the bank has not finished clearing them.
  • Bank charges, interest and direct debits: the bank has recorded them and you have not, usually because you learn of them only from the statement.
  • Direct credits: money a customer sent by NEFT, RTGS or UPI that reached the bank before it reached your books.
  • Errors: an amount typed wrongly, a transposed figure or an entry made twice, on either side.

One thing to know before you start

Your cash book and the bank’s statement are mirror images. Money in your account is an asset to you, so a deposit is a debit in your cash book. To the bank it is money it owes you, so the same deposit is a credit on its statement. A debit balance in your cash book and a credit balance on the bank statement are the same healthy position.

Step by step

  1. Take the cash book and the bank statement for the same period, ending on the same date.
  2. Tick off every entry that appears in both, matching on cheque number or reference first, then on date and amount.
  3. List what is left on each side. Those unticked lines are the reconciling items.
  4. Put through your books anything the bank has recorded correctly that you have not, such as bank charges, interest and direct credits. Those are now in both records.
  5. Start the statement from one balance, add and deduct the items that are still timing differences, and check that you arrive at the other balance.
  6. If it does not tie, look for an amount entered twice, a figure with its digits swapped, or a decimal point in the wrong place.

A worked example

On 31 March the cash book shows ₹1,25,000 in the bank. The bank statement for the same date shows ₹1,48,150. Ticking the two off against each other leaves six items unmatched.

Bank reconciliation statement as at 31 March
Item₹₹
Balance as per cash book1,25,000
Add: cheque no. 456 issued, not yet presented18,000
Add: cheque no. 459 issued, not yet presented7,500
Add: interest credited by the bank, not in the cash book1,240
Add: NEFT received from a customer, not in the cash book9,00035,740
Less: cheque deposited, not yet credited by the bank12,000
Less: bank charges, not in the cash book590(12,590)
Balance as per bank statement1,48,150

The interest, the NEFT receipt and the bank charges should now be entered in the cash book, which brings its balance to ₹1,34,650. After that, the only differences left are the two cheques not yet presented and the one deposit not yet cleared, which will clear on their own in the next few days.

The same method, for any two ledgers

Reconciling a customer’s ledger with their statement of account, or a supplier’s ledger with the supplier’s statement, works the same way: match the entries, list what is left, and explain each one as timing, omission or error.

Sources

  1. Principles and Practice of Accounting, Module 1, chapter 3: Bank Reconciliation Statement The Institute of Chartered Accountants of India (Foundation course study material)

Questions

What people ask next.

Can I start from the bank statement balance instead of the cash book?

Yes. Starting from the bank statement, you reverse every adjustment: deduct what you would have added and add what you would have deducted, and you should arrive at the cash book balance.

What if the bank statement shows an overdraft?

The method is the same, but start from the overdraft and remember that it is a debit balance on the bank statement and a credit balance in the cash book. Additions and deductions swap round.

How often should I reconcile the bank?

At least once a month, when the statement arrives. The longer you leave it, the more items there are to match and the harder an error is to find.

Which differences need an entry in my books?

Anything the bank recorded correctly and you did not: bank charges, interest, direct debits and direct credits. Cheques not yet presented or not yet cleared need no entry; they clear on their own.

Do it with Ledger Reconciliation

Let the tool do the working.

Ledger Reconciliation does what this guide describes, on your own figures, with the same rules.