Blog

Bank Reconciliation Statement: Practical Problems and Solutions

Bank Reconciliation_ Practical Solutions

A business checks its bank balance and discovers something confusing. Its Cash Book shows ₹85,000, but the bank statement shows ₹1,02,000. Does this mean the accountant made a mistake?

Not necessarily.

The difference may arise because certain transactions have been recorded in the Cash Book but have not yet appeared in the bank statement, or vice versa.

A Bank Reconciliation Statement (BRS) helps identify and explain these differences.

For CA, CMA and commerce students, learning to solve bank reconciliation statement problems is an important part of financial accounting. The key is to understand how each transaction affects the Cash Book and bank statement instead of memorising addition and subtraction rules.

This guide explains the BRS format, common adjustments and five practical problems with step-by-step solutions.

What Is a Bank Reconciliation Statement?

A Bank Reconciliation Statement is a statement prepared to reconcile the bank balance shown in a business’s Cash Book with the balance shown in its bank statement on a particular date.

The Cash Book records bank transactions from the business’s perspective. The bank statement records those transactions from the bank’s perspective.

Although both relate to the same bank account, their balances may differ temporarily.

For example, a business may issue a cheque to a supplier on 28 March. The payment is immediately recorded in the Cash Book, but the supplier may deposit the cheque in April.

Until the cheque is presented and processed, the bank statement may show a higher balance than the Cash Book.

A BRS explains this difference.

Why Do Cash Book and Bank Statement Balances Differ?

The most common reasons are timing differences, transactions recorded directly by the bank and accounting errors.

ReasonEffect on Reconciliation
Cheques issued but not presentedBank statement balance is generally higher
Cheques deposited but not clearedBank statement balance is generally lower
Bank charges not recorded in Cash BookBank statement balance is lower
Interest credited directly by bankBank statement balance is higher
Customer deposits money directly into bankBank statement balance is higher
Standing instructions paid by bankBank statement balance is lower
Cheque dishonoured by bankBank statement balance is lower if the Cash Book has not been updated
Errors in either recordEffect depends on the nature of the error

These effects assume the starting point is a positive Cash Book bank balance and that the relevant transaction has not yet been adjusted in the Cash Book.

Bank Reconciliation Statement Format

A common examination format begins with the balance as per Cash Book and adjusts the differences to arrive at the balance as per bank statement.

ParticularsAmount (₹)
Balance as per Cash BookXXX
Add: Cheques issued but not presentedXXX
Add: Interest credited directly by bankXXX
Add: Direct deposits by customersXXX
Less: Cheques deposited but not cleared(XXX)
Less: Bank charges not recorded(XXX)
Less: Direct payments made by bank(XXX)
Balance as per Bank StatementXXX

This format is suitable for the listed items when starting with a favourable Cash Book balance.

If the problem begins with the bank statement balance, the direction of adjustments is reversed.

If the account has an overdraft, it is safer to work with signed balances or carefully identify whether the balance is favourable or unfavourable.

Problem 1: Bank Reconciliation Statement with Unpresented and Uncleared Cheques

ABC Traders has a Cash Book bank balance of ₹80,000 on 31 March.

The accountant identifies the following differences:

  • Cheques issued but not presented: ₹25,000.
  • Cheques deposited but not cleared: ₹15,000.
  • Bank charges not recorded in Cash Book: ₹2,000.
  • Interest credited by bank but not recorded: ₹3,000.

Prepare a Bank Reconciliation Statement.

Solution

Start with the Cash Book balance of ₹80,000.

Step 1: Add cheques issued but not presented.

The business has already reduced its Cash Book balance, but the bank has not yet processed the payment.

Add ₹25,000.

Step 2: Deduct cheques deposited but not cleared.

The Cash Book includes the deposit, but the bank has not yet credited the amount.

Deduct ₹15,000.

Step 3: Deduct bank charges.

The bank has deducted ₹2,000, but the Cash Book has not been updated.

Step 4: Add bank interest.

The bank has credited ₹3,000, but the Cash Book does not yet include it.

Bank Reconciliation Statement of ABC Traders

As at 31 March

ParticularsAmount (₹)
Balance as per Cash Book80,000
Add: Cheques issued but not presented25,000
Add: Interest credited by bank3,000
Less: Cheques deposited but not cleared(15,000)
Less: Bank charges(2,000)
Balance as per Bank Statement91,000

Answer: ₹91,000 favourable balance.

The difference of ₹11,000 is fully explained by the listed reconciling items.

Problem 2: Bank Reconciliation Statement Starting with Bank Statement Balance

XYZ Enterprises has a bank statement balance of ₹1,20,000 on 31 March.

The following differences are identified:

  • Cheques issued but not presented: ₹30,000.
  • Cheques deposited but not cleared: ₹18,000.
  • Bank charges not entered in Cash Book: ₹2,500.
  • Direct deposit by a customer not entered in Cash Book: ₹12,000.

Calculate the balance as per Cash Book.

Solution

When starting with the bank statement balance, reverse the adjustments used when starting with the Cash Book.

ParticularsAmount (₹)
Balance as per Bank Statement1,20,000
Less: Cheques issued but not presented(30,000)
Add: Cheques deposited but not cleared18,000
Add: Bank charges not entered in Cash Book2,500
Less: Direct deposit by customer(12,000)
Balance as per Cash Book98,500

Answer: ₹98,500 favourable balance.

A useful way to verify the answer is to start with ₹98,500 and apply the adjustments in the opposite direction.

₹98,500 + ₹30,000 − ₹18,000 − ₹2,500 + ₹12,000 = ₹1,20,000.

Both balances reconcile correctly.

Problem 3: Bank Reconciliation Statement with Overdraft

An overdraft occurs when a bank account has a negative balance, subject to the bank’s overdraft arrangement.

Suppose Sunrise Traders has an overdraft of ₹50,000 as per its Cash Book on 31 March.

The following differences are identified:

  • Cheques issued but not presented: ₹20,000.
  • Cheques deposited but not cleared: ₹12,000.
  • Bank charges not recorded: ₹3,000.
  • Interest credited by bank but not recorded: ₹1,000.

Calculate the overdraft as per bank statement.

Solution Using Signed Balances

The easiest way to avoid confusion is to treat the overdraft as a negative balance.

Opening Cash Book balance = −₹50,000

ParticularsEffect (₹)Running Balance (₹)
Overdraft as per Cash Book−50,000
Add: Cheques issued but not presented+20,000−30,000
Less: Cheques deposited but not cleared−12,000−42,000
Less: Bank charges−3,000−45,000
Add: Interest credited+1,000−44,000

Answer: ₹44,000 overdraft as per bank statement.

The negative closing balance represents an overdraft.

This signed-balance approach is particularly useful in examination questions because it avoids the confusion caused by treating an overdraft as an ordinary positive balance.

Problem 4: Bank Reconciliation Statement with Errors

Errors can also cause differences between the Cash Book and bank statement.

Consider a fictional company, Greenfield Services.

Its Cash Book shows a favourable bank balance of ₹65,000 on 31 March.

The accountant discovers:

  1. A cheque payment of ₹8,000 was correctly processed by the bank but recorded in the Cash Book as ₹800.
  2. A customer deposited ₹10,000 directly into the bank account.
  3. Bank charges of ₹1,500 were not recorded in the Cash Book.
  4. Cheques issued for ₹12,000 have not yet been presented.

Calculate the balance as per bank statement.

Solution

The first transaction contains a Cash Book error.

The business recorded only ₹800 as a payment instead of ₹8,000.

The Cash Book therefore overstates the bank balance by:

₹8,000 − ₹800 = ₹7,200

This amount must be deducted when reconciling to the bank statement.

ParticularsAmount (₹)
Balance as per Cash Book65,000
Less: Payment recorded short by ₹7,200(7,200)
Add: Direct deposit by customer10,000
Less: Bank charges(1,500)
Add: Cheques issued but not presented12,000
Balance as per Bank Statement78,300

Answer: ₹78,300 favourable balance.

This problem illustrates why BRS is not merely a calculation exercise. It also helps identify errors that require correction.

Problem 5: Bank Reconciliation Statement with Adjusted Cash Book

Some examination problems require students to prepare an adjusted Cash Book before preparing the Bank Reconciliation Statement.

This is useful when the Cash Book has not yet recorded certain transactions already processed by the bank.

Question

ABC Manufacturing Ltd. has a Cash Book bank balance of ₹90,000 on 31 March.

The accountant identifies:

  • Bank charges: ₹2,000.
  • Interest credited by bank: ₹4,000.
  • Direct deposit by customer: ₹15,000.
  • Insurance premium paid by bank under standing instructions: ₹6,000.
  • Cheques issued but not presented: ₹20,000.
  • Cheques deposited but not cleared: ₹12,000.

Prepare an adjusted Cash Book and Bank Reconciliation Statement.

Step 1: Prepare the Adjusted Cash Book

The adjusted Cash Book includes transactions already processed by the bank but not yet recorded by the business.

ParticularsAmount (₹)
Balance as per original Cash Book90,000
Add: Interest credited by bank4,000
Add: Direct deposit by customer15,000
Less: Bank charges(2,000)
Less: Insurance premium paid by bank(6,000)
Adjusted Cash Book Balance1,01,000

The adjusted Cash Book balance is ₹1,01,000.

Step 2: Prepare the Bank Reconciliation Statement

Only the remaining timing differences need to be reconciled.

ParticularsAmount (₹)
Balance as per Adjusted Cash Book1,01,000
Add: Cheques issued but not presented20,000
Less: Cheques deposited but not cleared(12,000)
Balance as per Bank Statement1,09,000

Answer: ₹1,09,000 favourable balance.

This two-stage method is useful because it separates transactions requiring Cash Book entries from temporary timing differences.

How to Decide Whether to Add or Subtract an Item in BRS

Instead of memorising rules without understanding them, ask one question:

Has the transaction already increased or decreased the Cash Book balance, and has the bank processed it?

The following table provides a quick reference when starting with a favourable Cash Book balance.

TransactionAdjustment
Cheque issued but not presentedAdd
Cheque deposited but not clearedSubtract
Bank charges not recordedSubtract
Interest credited by bankAdd
Direct deposit by customerAdd
Standing instruction paymentSubtract
Dishonoured cheque not yet recordedSubtract
Bank interest charged but not recordedSubtract

If starting with the bank statement balance, reverse these adjustments.

For overdraft problems, the signed-balance method is generally more reliable than memorising separate rules.

Common Mistakes in Bank Reconciliation Statement Problems

Confusing Cheques Issued with Cheques Deposited

Cheques issued are payments made by the business.

Cheques deposited are amounts the business expects to receive.

They affect reconciliation differently.

Ignoring the Starting Balance

Always identify whether the question begins with the Cash Book balance or bank statement balance.

The direction of adjustments depends on the starting point.

Treating an Overdraft as a Positive Balance

An overdraft represents a negative bank balance from the business’s perspective.

Using signed amounts can prevent calculation errors.

Recording Timing Differences as Cash Book Errors

A cheque issued but not presented does not automatically require a new Cash Book entry.

The original payment has already been recorded.

The difference arises because the bank has not yet processed it.

Forgetting to Adjust the Cash Book

Bank charges, direct deposits and standing instructions may require Cash Book entries if they have not already been recorded.

These should be distinguished from timing differences.

Assuming Every Difference Is an Accounting Error

Many reconciliation differences are temporary and arise from normal banking processes.

The purpose of BRS is to explain the difference and identify items requiring further investigation.

Why Bank Reconciliation Matters in Real Businesses

Bank reconciliation is an important internal control activity.

Businesses regularly compare accounting records with bank statements to identify missing transactions, posting errors and unusual payments.

For example, an accountant may discover that a customer payment has reached the bank but has not been recorded in the accounting software.

Similarly, an unexplained withdrawal may require investigation.

Regular reconciliation helps businesses maintain accurate cash records and identify discrepancies promptly.

However, a completed BRS does not automatically prove that every transaction is correct or that fraud has not occurred. Unusual items still require appropriate supporting evidence and review.

Why CA and CMA Students Should Understand BRS

For CA students, Bank Reconciliation Statements are an important foundation for accounting, financial reporting and auditing.

During articleship, students may encounter bank reconciliations while examining cash and bank balances, outstanding cheques and supporting bank records.

For CMA students, BRS supports accurate cash management, financial control and working capital analysis.

Commerce students preparing for accounting jobs should also understand how to identify unreconciled transactions and prepare adjusting entries.

The most valuable skill is not memorising the BRS format. It is understanding why a particular transaction causes the Cash Book and bank statement to show different balances.

Strengthen Your Accounting Skills with Master Minds India

Learning to solve bank reconciliation statement problems helps students connect accounting records with actual banking transactions. It also develops accuracy, logical thinking and practical skills useful in accounting, auditing and financial management.

Master Minds India provides educational resources for commerce students and aspiring CA and CMA professionals. Explore the available Master Minds courses to learn more about the educational programmes.

MasterMinds Admin

About MasterMinds

Founded in 2002 offering CA and CMA classes in Guntur (Andhra Pradesh), Master Minds Institute is a source of hope for many students striving to achieve their dreams of becoming professionals and advancing in their careers. Master Minds stands out as one of India’s finest coaching institutes in Commerce offering online CA classes. Over the past 22 years, we’ve guided students in professional courses like CA, CMA, MEC & CEC etc. Initiated by three visionary educators, Mr. M.S.N Mohan, Mr. M.S.S Prakash, and Ms. M.Radha, under the guidance of Mr. M.Siva Prasad, Master Minds aims to be a comprehensive commerce coaching center accessible to all aspiring commerce professionals.