Bank reconciliation: formulas, shortcuts & solved examples
What it is
A Bank Reconciliation Statement (BRS) explains the difference between the bank balance shown in the business's cash book and the balance shown in the bank's passbook or statement on the same date. Differences arise from timing gaps, entries known to only one side, and errors. Tally offers a bank reconciliation screen where you enter the bank date for each voucher.
Key rules
Why balances differ
- Cheques issued but not yet presented for payment
- Cheques deposited but not yet cleared (collected)
- Bank charges or interest debited by the bank but not yet in the cash book
- Interest or direct deposits credited by the bank but not yet in the cash book
- Dishonoured cheques not yet recorded
- Errors on either side
Starting from a cash book debit balance (favourable)
- Add: cheques issued but not presented; amounts credited by bank only (interest, direct deposits)
- Less: cheques deposited but not cleared; amounts debited by bank only (charges, dishonoured cheques)
- Result = balance as per passbook
Overdraft
An overdraft is a credit balance in the cash book (a debit balance in the passbook). Treat it as a negative number, or reverse every add/less rule.
Adjusted cash book method
First correct the cash book for items the business did not know (charges, interest, direct credits, dishonours). Then reconcile only the timing items (unpresented and uncleared cheques).
Errors
- An amount wrongly recorded in the cash book is corrected in the adjusted cash book.
- A wrong entry made by the bank is shown as a reconciling item and reported to the bank for correction; the cash book is not changed.
Good practice
Reconcile at least monthly, tick every matching entry on both records, and investigate any item that stays unreconciled for more than one cycle. Old unpresented cheques may need to be reversed or re-issued, and unexplained bank debits can indicate fraud or errors that should be raised with the bank quickly.
Shortcuts
- Think "would the bank balance be higher or lower?" For every item, ask whether the bank already knows it. If the bank has not yet paid a cheque you issued, the bank balance is higher, so add.
- Use signs for overdrafts: write an overdraft of ₹20,000 as −20,000, apply the normal rules, and read the sign of the answer.
- Starting from the passbook? Reverse every rule. Add becomes less, less becomes add.
Solved examples
Example 1: Favourable cash book balance
Cash book shows a debit balance of ₹45,000. Cheques issued but not presented ₹8,000; cheques deposited but not cleared ₹5,000; bank charges ₹300 not in cash book; interest credited ₹700 not in cash book. Find the passbook balance.
- Start: ₹45,000
- Add unpresented cheques: +₹8,000
- Add interest: +₹700
- Less uncleared cheques: −₹5,000
- Less bank charges: −₹300
- Passbook balance = ₹48,400
Example 2: Overdraft
Overdraft as per cash book ₹20,000. Cheques issued but not presented ₹6,000; cheques deposited but not cleared ₹4,000.
- Start: −₹20,000
- Add unpresented cheques: +₹6,000 gives −₹14,000
- Less uncleared cheques: −₹4,000 gives −₹18,000
- Overdraft as per passbook = ₹18,000
Example 3: Starting from the passbook
Passbook shows a credit balance of ₹62,500. A customer deposited ₹3,000 directly (not in cash book); cheques issued ₹7,500 not presented; cheques deposited ₹2,000 not cleared. Find the cash book balance.
- Start: ₹62,500
- Less direct deposit (bank knows, cash book does not): −₹3,000
- Less unpresented cheques: −₹7,500
- Add uncleared cheques: +₹2,000
- Cash book balance = ₹54,000
Example 4: Adjusted cash book, then BRS
Cash book debit balance ₹30,000. Bank charges ₹250, a customer's cheque of ₹4,000 dishonoured, interest credited ₹600, direct credit from a customer ₹2,500, none recorded in the cash book. Cheques issued but not presented ₹5,000.
- Adjusted cash book = 30,000 − 250 − 4,000 + 600 + 2,500 = ₹28,850
- Passbook balance = 28,850 + 5,000 = ₹33,850
Common mistakes
- Reversing the add/less logic when starting from the passbook instead of the cash book.
- Treating an overdraft as a positive balance and adding items in the wrong direction.
- Including adjusted items twice: once in the adjusted cash book and again in the BRS.
- Ignoring dishonoured cheques, which reduce the bank balance even though the deposit was already recorded.
- Confusing debit and credit sides: a debit in the cash book is a credit in the passbook, because the bank sees your deposit as its liability to you.
Practice now: https://www.testsworld.com/mocks