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
- Take the cash book and the bank statement for the same period, ending on the same date.
- Tick off every entry that appears in both, matching on cheque number or reference first, then on date and amount.
- List what is left on each side. Those unticked lines are the reconciling items.
- 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.
- 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.
- 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.
| Item | ₹ | ₹ |
|---|---|---|
| Balance as per cash book | 1,25,000 | |
| Add: cheque no. 456 issued, not yet presented | 18,000 | |
| Add: cheque no. 459 issued, not yet presented | 7,500 | |
| Add: interest credited by the bank, not in the cash book | 1,240 | |
| Add: NEFT received from a customer, not in the cash book | 9,000 | 35,740 |
| Less: cheque deposited, not yet credited by the bank | 12,000 | |
| Less: bank charges, not in the cash book | 590 | (12,590) |
| Balance as per bank statement | 1,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.
Terms in this guide
Sources
- Principles and Practice of Accounting, Module 1, chapter 3: Bank Reconciliation Statement The Institute of Chartered Accountants of India (Foundation course study material)