👁 Preview — Study, Practice and Revise are open; mock tests and the rest of the syllabus unlock on subscription. Unlock all · ₹4,999
← Back to Financial Accounting
Study mode

Bank Reconciliation

Study Practice Revise 🔒 Test

Introduction to Bank Reconciliation

Imagine you have a personal bank account. You keep a record of all your deposits and withdrawals in your own notebook, while the bank also maintains its own record of your account activities. Sometimes, the balance you calculate from your notebook doesn't match the balance shown in the bank statement. This difference can be confusing and needs to be resolved to ensure your records are accurate.

Similarly, in business, companies maintain a cash book to record all cash and bank transactions. The bank also sends a bank statement showing all transactions processed on their side. Due to various reasons, the balances in the cash book and bank statement often differ. The process of comparing these two records and explaining the differences is called Bank Reconciliation.

Why is bank reconciliation important?

  • It helps detect errors or omissions in either the company's books or the bank's records.
  • It identifies fraudulent transactions or unauthorized withdrawals.
  • It ensures that the cash book reflects the true cash position of the company.
  • It aids in maintaining accurate financial statements for decision-making and audits.

In this chapter, we will learn why differences arise, how to prepare a bank reconciliation statement, and how to adjust the books accordingly.

Causes of Differences in Bank and Cash Book

Before we reconcile, it is essential to understand why the cash book balance and bank statement balance may not match. These differences mainly arise due to timing issues, errors, or bank-related charges and credits.

Causes of Differences Between Cash Book and Bank Statement
Cause Example Effect on Balances
Timing Differences Cheques issued but not yet presented to bank; deposits made but not yet credited by bank Bank statement balance differs as transactions appear at different times
Errors in Books Wrong amount recorded in cash book; omission of a transaction Cash book balance incorrect; needs correction
Bank Charges and Interest Bank charges debited by bank; interest credited by bank but not recorded in cash book Bank statement shows these amounts; cash book does not until adjusted
Unpresented Cheques Cheques issued to suppliers but not yet cleared by bank Cash book shows payment; bank statement does not yet reflect deduction
Deposits in Transit Cash or cheques deposited but not yet processed by bank Cash book shows deposit; bank statement does not yet include it

Format and Preparation of Bank Reconciliation Statement

The Bank Reconciliation Statement (BRS) is a statement prepared to reconcile the difference between the balance as per cash book and the balance as per bank statement.

The process involves starting from one balance (usually cash book balance), then adding or subtracting items that explain the difference, to arrive at the other balance (bank statement balance).

graph TD    A[Start with Balance as per Cash Book] --> B[Add: Deposits in Transit]    B --> C[Less: Unpresented Cheques]    C --> D[Add/Less: Bank Errors]    D --> E[Add: Interest Credited by Bank]    E --> F[Less: Bank Charges Debited]    F --> G[Add/Less: Errors in Cash Book]    G --> H[Reconciled Balance = Balance as per Bank Statement]

Steps to Prepare Bank Reconciliation Statement:

  1. Identify the starting balance: Choose either the cash book balance or the bank statement balance as the starting point.
  2. List timing differences: Add deposits in transit and subtract unpresented cheques.
  3. Account for bank errors: Add or subtract any errors made by the bank.
  4. Adjust for bank charges and interest: Deduct bank charges and add interest credited by the bank, if not recorded in cash book.
  5. Correct errors in cash book: Adjust for any mistakes found in the company's records.
  6. Calculate the adjusted balance: After all adjustments, the balance should match the other record.

Once the reconciliation statement is prepared, necessary adjusting journal entries are passed in the books to correct the cash book balance.

Adjusted Cash Book Balance

\[Adjusted\ Cash\ Book\ Balance = Cash\ Book\ Balance \pm Adjustments\]

Adjust cash book for bank charges, interest, and errors

Cash Book Balance = Closing balance as per cash book
Adjustments = Additions or deductions for unrecorded items

Bank Reconciliation Statement Equality

\[Balance\ as\ per\ Cash\ Book \pm Adjustments = Balance\ as\ per\ Bank\ Statement \pm Adjustments\]

Balances match after adjusting for timing differences and errors

Adjustments = Unpresented cheques, deposits in transit, bank errors, etc.

Worked Examples

Example 1: Basic Bank Reconciliation Easy
The balance as per cash book of XYZ Ltd. on 31st March 2024 was Rs.50,000. The bank statement showed a balance of Rs.52,000 on the same date. On investigation, the following were found:
- Cheques issued but not yet presented amounted to Rs.4,000.
- Deposits made but not yet credited by the bank amounted to Rs.6,000.
Prepare a bank reconciliation statement.

Step 1: Start with balance as per cash book: Rs.50,000.

Step 2: Add deposits in transit (not yet credited): +Rs.6,000.

Step 3: Less unpresented cheques (issued but not yet cleared): -Rs.4,000.

Step 4: Calculate adjusted balance:

\( 50,000 + 6,000 - 4,000 = 52,000 \)

Step 5: This matches the bank statement balance, so reconciliation is complete.

Answer: The difference is explained by timing differences of Rs.6,000 deposits in transit and Rs.4,000 unpresented cheques.

Example 2: Bank Charges and Interest Adjustments Medium
ABC Ltd. has a cash book balance of Rs.75,000 on 30th June 2024. The bank statement shows Rs.74,200. The following were noted:
- Bank charges of Rs.500 were debited by the bank but not recorded in the cash book.
- Interest of Rs.700 was credited by the bank but not recorded in the cash book.
- Cheques issued but not presented total Rs.2,000.
Prepare a bank reconciliation statement.

Step 1: Adjust cash book for bank charges and interest.

Bank charges reduce cash book balance: Rs.75,000 - Rs.500 = Rs.74,500.

Interest credited increases cash book balance: Rs.74,500 + Rs.700 = Rs.75,200.

Step 2: Start with adjusted cash book balance: Rs.75,200.

Step 3: Less unpresented cheques (Rs.2,000): Rs.75,200 - Rs.2,000 = Rs.73,200.

Step 4: Compare with bank statement balance of Rs.74,200.

Difference of Rs.1,000 remains, possibly deposits in transit or errors.

Step 5: If no other information, state difference unexplained; otherwise, investigate further.

Answer: After adjusting cash book, the reconciled balance is Rs.73,200, which is Rs.1,000 less than bank statement balance.

Example 3: Error Correction in Cash Book Medium
The cash book of DEF Ltd. shows a balance of Rs.40,000 on 31st July 2024. The bank statement shows Rs.39,500. It was discovered that a cheque for Rs.1,000 received from a customer was recorded as Rs.100 in the cash book. Cheques issued but not presented amounted to Rs.1,200. Prepare a bank reconciliation statement.

Step 1: Correct the error in cash book.

Cheque recorded as Rs.100 instead of Rs.1,000 means Rs.900 less recorded.

Adjust cash book balance: Rs.40,000 + Rs.900 = Rs.40,900.

Step 2: Start with adjusted cash book balance: Rs.40,900.

Step 3: Less unpresented cheques: Rs.40,900 - Rs.1,200 = Rs.39,700.

Step 4: Compare with bank statement balance: Rs.39,500.

Difference of Rs.200 remains, possibly due to other timing differences or errors.

Answer: After correction and adjustments, the reconciled balance is Rs.39,700, Rs.200 more than bank statement balance.

Example 4: Complex Bank Reconciliation with Multiple Adjustments Hard
On 31st August 2024, the cash book of GHI Ltd. showed a balance of Rs.1,20,000, while the bank statement showed Rs.1,15,000. The following information was available:
- Cheques issued but not presented: Rs.10,000.
- Deposits in transit: Rs.8,000.
- Bank charges debited by the bank but not recorded in cash book: Rs.1,200.
- Interest credited by bank but not recorded in cash book: Rs.500.
- A cheque for Rs.2,000 paid to a supplier was recorded as Rs.200 in cash book.
- The bank had wrongly debited Rs.300 from the account.
Prepare a bank reconciliation statement.

Step 1: Adjust cash book for errors and bank charges/interest.

  • Cheque under-recorded by Rs.1,800 (Rs.2,000 - Rs.200): add Rs.1,800 to cash book balance.
  • Bank charges reduce cash book balance: subtract Rs.1,200.
  • Interest credited increases cash book balance: add Rs.500.

Adjusted cash book balance:

\( 1,20,000 + 1,800 - 1,200 + 500 = 1,20,000 + 1,100 = 1,21,100 \)

Step 2: Start with adjusted cash book balance: Rs.1,21,100.

Step 3: Less unpresented cheques: Rs.1,21,100 - Rs.10,000 = Rs.1,11,100.

Step 4: Add deposits in transit: Rs.1,11,100 + Rs.8,000 = Rs.1,19,100.

Step 5: Add bank error (wrong debit by bank): Rs.1,19,100 + Rs.300 = Rs.1,19,400.

Step 6: Compare with bank statement balance of Rs.1,15,000.

Difference of Rs.4,400 remains, indicating possible further investigation needed.

Answer: After adjustments, the reconciled balance is Rs.1,19,400, Rs.4,400 more than bank statement balance.

Example 5: Reconciliation from Bank Statement Balance Medium
The bank statement of JKL Ltd. shows a balance of Rs.85,000 on 31st December 2024. The cash book shows Rs.80,000. The following were noted:
- Cheques issued but not presented: Rs.3,000.
- Deposits in transit: Rs.4,000.
- Bank charges debited by bank but not recorded in cash book: Rs.500.
Prepare a bank reconciliation statement starting from the bank statement balance.

Step 1: Start with bank statement balance: Rs.85,000.

Step 2: Less deposits in transit (since bank has not recorded them yet): Rs.85,000 - Rs.4,000 = Rs.81,000.

Step 3: Add unpresented cheques (since bank has not deducted them): Rs.81,000 + Rs.3,000 = Rs.84,000.

Step 4: Adjust cash book for bank charges (reduce cash book balance): Rs.80,000 - Rs.500 = Rs.79,500.

Step 5: Compare adjusted cash book balance (Rs.79,500) with adjusted bank balance (Rs.84,000).

Difference of Rs.4,500 remains, requiring further investigation.

Answer: The reconciliation shows a difference of Rs.4,500 after adjustments, indicating possible errors or omissions.

Tips & Tricks

Tip: Always start reconciliation from the balance you are given (cash book or bank statement) to avoid confusion.

When to use: At the beginning of any bank reconciliation problem.

Tip: List unpresented cheques and deposits in transit separately; remember unpresented cheques reduce bank balance, deposits in transit increase it.

When to use: While identifying timing differences.

Tip: Use a flowchart or checklist to systematically identify all possible causes of differences.

When to use: For complex reconciliation problems with multiple adjustments.

Tip: Double-check arithmetic calculations after each adjustment to avoid cumulative errors.

When to use: Throughout the reconciliation process, especially under exam pressure.

Tip: Memorize common bank charges and interest scenarios to quickly spot adjustments.

When to use: When bank statements include charges or interest not recorded in cash book.

Common Mistakes to Avoid

❌ Confusing unpresented cheques with deposits in transit.
✓ Remember unpresented cheques reduce bank balance; deposits in transit increase it.
Why: Both are timing differences but have opposite effects on bank statement balance.
❌ Failing to adjust cash book for bank charges and interest.
✓ Always update cash book balance with bank charges and interest before reconciliation.
Why: Bank charges and interest appear in bank statement but not in cash book initially.
❌ Starting reconciliation from the wrong balance (e.g., bank statement when cash book balance is given).
✓ Identify the starting point clearly and adjust the other balance accordingly.
Why: Starting from incorrect balance leads to wrong adjustments and final figure.
❌ Ignoring errors in cash book or bank statement.
✓ Check for errors in both records and include corrections in reconciliation.
Why: Errors cause discrepancies and must be accounted for to reconcile accurately.
❌ Not listing all adjustments separately, leading to confusion.
✓ Maintain clear lists of each adjustment type (timing differences, errors, charges).
Why: Separating adjustments helps in systematic reconciliation and reduces mistakes.
Curated videos per subtopic
Top YouTube explainers, AI-ranked for your exam and language. Unlocks with subscription.
Unlock

Try Practice next.

Progress tracking is paywalled — subscribe to mark subtopics as understood and save your streak.

Go to practice →
Ask a doubt
Bank Reconciliation · 10 free messages
Ask me anything about this subtopic. You have 10 free messages this session — chat history isn't saved in preview.