Unit: IV Bank Reconciliation Statement
Unit: IV Bank Reconciliation Statement
Unit: IV Bank Reconciliation Statement
1
Unit: IV
Bank Reconciliation Statement
Introduction
You operate a bank account in which you deposit money and withdraw money from time to time. You
maintain a record with yourself of these deposits and withdrawals. One day when you got your pass-book
(statement issued by the bank) updated you were surprised to find that the balance shown by the pass book
was different from what it should have been as per your records. What will you do in this case? It is obvious
that you will compare the two sets of records and find out items which are recorded in one but not in the
other. Similar situation may arise in case of a business concern which operates a bank account. These
business concerns maintain record of all of their banking transactions in their bank column of the cash book.
On any particular date the bank balance shown by the bank column of cash book and that shown by the pass
book should be the same. But if there is difference between the two, the business concern will find out the
reasons to reconcile the balance. In this unit you will learn about reasons for difference and prepare the
reconciliation statement called Bank Reconciliation Statement.
Meaning of Bank Reconciliation Statement
A bank reconciliation statement is a document that compares the cash balance on a company’s balance sheet
to the corresponding amount on its bank statement. Reconciling the two accounts helps identify whether
accounting changes are needed. Bank reconciliations are completed at regular intervals to ensure that the
company’s cash records are correct. They also help detect fraud and any cash manipulations.
2
the bank, the bank credits the firm’s account with the amount deposited but the same amount is not recorded
in the cash book on the day it is deposited. As a result the balance in the cash book will be less than the
balance shown in the Pass book.
iv) Bank charges charged by the Bank: The bank charges, fees or commission from time to time for
various services provided to the customer and debits the customers’ account without intimation to the
firm/customer. As a result, the balance of the cash book will be more than the balance of the pass book.
v) Interest and dividend received by the bank on behalf of the customer: The interest on debentures or
dividend on shares held by the account holder is directly deposited by the company in the bank account of
customer through Electronic Clearing System (ECS). But there may not be any entry in the cash book for
such items because the firm does not get the information till it receives the bank statement. As a
consequence, the firm enters it in its cash book on a date later than the date on which it is recorded by the
bank. As a result, the balance as per cash book and pass book will differ.
vi) Direct payments made by the bank on behalf of the customer: The firm may give standing
instructions to its banker to make payment of telephone bills, rent, insurance premium, taxes, etc. On
making such payments, the bank will debit the firm’s account immediately, but the firm will record the
same on receiving information from the bank in the form of Pass Book or bank statement. As a result, the
balance of the pass book is less than that of the balance shown in the bank column of the cash book.
vii) Dishonour of cheques deposited with bank: A firm may receive a number of cheques from its
customers. Some of the cheques deposited by the firm with the bank may be dishonoured. In this case, the
Bank debits firm’s account. But the firm records the same when it receives the information from the bank.
As a result, the balance as per cash book and that of pass book will differ.
viii) Errors committed in recording transactions by the firm: The firm may commit certain errors e.g.,
omission or wrong recording of transactions relating to cheques deposited, cheques issued and wrong
balancing etc. In this case, there would be a difference between the balances as per Cash Book and as per
Pass Book.
ix) Errors committed in recording transactions by the Bank: The bank may also commit errors while
recording transactions in the customer’s account, e.g., omission or wrong recording of transactions relating
to cheques deposited etc. As a result, the balance of the bank pass book and cash book will not agree.
3
column of cash book, the business firm will identify the causes for such difference. It becomes necessary to
reconcile them. To reconcile the balances of Cash Book and Pass Book a statement is prepared. This
statement is called the ‘Bank Reconciliation Statement. It can be said that Bank Reconciliation Statement is
a statement prepared to reconcile the difference between the balances as per the bank column of the cash
book and pass book on any given date.
4
error in the payment side of cash book
Balance as per Pass Book(Cr.) -
From the following particulars of M/s XYZ Limited. prepare bank reconciliation statement as on 31.7.2023.
5
i. Balance as per pass book i.e. Rs.70,700 as the starting point.
ii. Cheques deposited into bank but not credited up to 31.7.2023 Rs.8,900
iii. Cheques issued but not presented for payment till 31.7.2023 Rs.12,500.
iv. Bank credited Rs.5,000 for receiving dividend.
v. Bank charges debited by Bank Rs.400
Sum 5: From the following information, prepare BRS as on 31st March, 2023
i. Cheques from Raman Rs. 2500, Vivek Rs. 3000 and Mohan Rs. 2400 were deposited into
account on 29th March, 2023 but were credited by the bank on 3rd April, 2023.
ii. Cheques issued to Kabir Rs. 5000 and Sameer Rs. 6000 on 27 th March, 2023 were presented for
6
payment on 7th April, 2023.
iii. A cheque for Rs. 1000 which was received from a customer was recorded in the Cash Book on
29th March, 2023 but was deposited in bank on 5th April, 2023.
iv. Bank statement shows a credit of Rs. 2500 for interest and a debit of Rs. 500 for bank charges.
v. Balance as per cash book was Rs. 1,80,000(Dr.) whereas the bank statement showed a credit
balance of Rs. 1,84,100
Sum 6: On 31st March, 2023, the Cash Book of Mahesh showed a debit balance of Rs. 49,000. Bank
statement
or bank pass book showed credit balance of Rs. 37,400. Entries I the cash book and bank pass book
were compared and the following differences were identified.
i. Cheques of Shyam Rs. 9000 and of Mohan Rs. 15,000 were deposited but were not collected up
to 31st March, 2023.
ii. Ramesh, a debtor, deposited a cheque of Rs. 8000 directly into the bank.
iii. Bank allowed an interest of Rs. 500.
iv. Cheque for Rs. 10,000 issued to Ramesh was not presented for payment.
v. Bank debited Rs. 6000, being insurance premium paid as per standing instructions.
vi. Bank debited Rs. 100 being bank charges
Prepare BRS as on 31st March, 2023.
Sum. 7: From the following information, prepare BRS as on 31st March 2023.
i. Debit balance of bank column as per cash book as on 31st March, 2023 Rs. 12,000
ii. Balance (credit) as per bank statement as on that date Rs. 16,500
iii. Out of the total cheques issued of Rs. 7000, cheques of Rs. 4000 were debited on 5 th April, 2023
and the remaining have not been presented yet.
iv. Cheques deposited of Rs. 3500 were credited on 4th April, 2023
v. Bank had debited Rs. 100 as bank charges and had collected Rs. 200 as interest on investments
vi. A cheque issued to S Ltd. for Rs. 3400 was recorded in the cash book as Rs. 4300
When there is overdraft/ unfavorable balance as per Cash Book or Pass Book:
A simple format of Bank Reconciliation Statement is given as follows:
7
5. Dividend on shares collected by the bank -
6. Cheques issued returned unpaid(dishonored) -
7. Any wrong entry on Cr. side of the pass book/ wrong -
credit given by bank
8. Undercasting error in the receipt side and overcasting
error in the payment side of cash book
9. Cheques deposited in bank but not recorded in cash
book
Add: 1. Cheques deposited into bank but not yet collected or -
credited by bank
2. Cheques recorded but not yet deposited
3. Cheques issued but not recorded in cash book
4. Bank charges -
5. Insurance premium/ rent/ taxes paid by bank -
6. Interest on overdraft charged by the bank -
7. Dishonored bills or cheques -
8. Discounted cheque or Bill dishonoured
9. Drawings made by partner not entered in cash book -
10. Any wrong entry on Dr. side of the pass book/ wrong -
debit given by bank
11. Overcasting error in the receipt side and undercasting
error in the payment side of cash book
Balance as per Pass Book (Dr.) -
8
Overdraft as per Cash Book (Cr.) 4,299
Less: Cheques issued but not yet presented for payment 1151
Add: 1. cheques paid into Bank but not collected 858
2. Bank Charges recorded in Pass Book 40 898
Overdraft as per Pass-Book (Dr.) 4046
9
iv. Cheques amounting to Rs...60,000 sent to the bank for collection, which though entered in the Cash
Book have not been credited by the bank.
v. Bank charges of Rs.1,750 as per Bank Statement have not been recorded in the Cash Book.
vi. Payment side of the Cash Book was by under cash Rs.1,500.
vii. Rs.35,000 dividend was collected by the bank on behalf of the customer.
Less: 17,500
i. Cheques drawn on saving account but wrongly shown as
drawn on Current Account 70,000
ii. Cheques issued but not yet presented for payment 35,000 1,22,500
iii. Direct payment of dividend into the bank
Overdraft as per Pass Book (Cr.) 14,250
10
Bank charges 65
Interest charged by bank 35
Insurance premium paid by bank 1500 6100
Less: Cheques issued but not enchased till date (Rs.6,500 – Rs.2,650) 3,850
Amount directly deposited by some customer 2400 6250
Sum 12: Following information is of Roshan who requires you to reconcile his cash book with the pass
book balance
Balance as per Cash Book (Cr.) Rs. 2800
Cheques issued but not presented for payment Rs. 3440
Cheques deposited but not credited Rs. 2260
Additional information:
a. Debit side of the cash book (bank column) is undercasted by Rs. 500
b. A cheque of Rs. 200 paid to a creditor has been entered by mistake in the cash column
c. Bank charges Rs. 80 have not been entered in the cash book
Sum 13: From the following information, determine the balance of the Bank Pass book of Amrit as on 31 st
March, 2023:
i. Bank overdraft of Rs. 63,400 as per cash book on 31st March, 2023
ii. Interest on overdraft for 6 months ended 31 st March, 2023 Rs. 1600 entered in the bank pass
book was not recorded in the cash book
iii. Bank charges of Rs. 300 are debited in the pass book but are not recorded in cash book.
iv. Cheques issued but not presented for payment prior to 31st March, 2023 were Rs. 11,680
v. Cheques deposited in the bank but not collected before 31st March, 2023 were Rs. 21,700
vi. Interest on investments collected by the bank and credited in the bank passbook Rs. 12,000
vii. Credit side of the bank column of the cash book was undercast by Rs. 1000
Sum 14: Prepare BRS as on 30th April, 2023 for Jyoti Sales Private Ltd. from the information
Given below:
i. Bank overdraft as per cash book on 30th April, 2023 Rs. 1,10,450
ii. Cheques issued on 20th April, 2023 but noy yet presented Rs. 15,000
iii. Cheques deposited but not yet credited by the bank Rs. 22,750
iv. Cheque deposited by a customer credited in account was not advised by the bank Rs. 47,200
v. Interest debited by the bank on 27th April, 2023 but no advice received. Rs. 12,115
11
vi. Subsidy received from the authorities by the bank on our behalf, credited to the account Rs.
22,000
vii. Amount wrongly debited by the bank Rs. 2400
viii. Amount wrongly credited by the bank Rs. 5000
When starting point is Balance as per bank statement/passbook (Favourable/Credit)
Sum 15: On 31st march, 2023, bank statement of Rajeev showed a credit balance of Rs. 15,650 whereas the
cash book showed a debit balance of Rs. 15,200. The reasons for the differences were;
i. Cheques issued to Roshan for Rs. 6000 and to Daniel for Rs. 3840 were not presented for
payment.
ii. Bank charged Rs. 350 for bank charges, which was not recorded in the cash book.
iii. Nitesh directly deposited Rs. 8160 into the bank account of the trader which was not entered in
the cash book
iv. Two cheques one from shyam for Rs. 5150 and another from Kailash Rs. 12,500 were collected
by bank on 2nd April, 2023 although they were deposited on 29th march, 2023
v. Interest credited by bank was Rs. 450, which was not recorded in the cash book.
Prepare BRS as on 31st March, 2023
Sum 16: Prepare BRS as on 31st March, 2023 from the following information
Bank statement showed a credit i.e. favourable balance of Rs. 9214
i. On 29th March, 2023 bank credited a sum of Rs. 1650 in error
ii. Cheques totalling Rs. 4500 issued on 29th March, 2023 were not cleared
iii. Life insurance premium Rs. 950 paid by a standing order was not recorded in the cash book
iv. A cheque of Rs. 600 received, deposited and credited by bank, was accounted as a receipt in the
cash column of the cash book.
v. Other cheques for Rs. 8500 were deposited on 27 th March, 2023 but cheques for Rs. 6000 were
collected by the bank on 31st March, 2023 and remaining on 2nd April, 2023
Sum 17: Prepare a BRS as on 31st March, 2023 from the following information.
i. Bank balance as per pass book Rs. 25,000
ii. Cheque deposited into bank, but entry was not passed in the cash book. Rs. 1250
iii. Cheque received but not sent to bank Rs. 3000
iv. Credit side of the bank column cast short Rs. 500
v. Insurance premium was paid directly by the bank under the standing advice Rs. 1500
vi. Cheque issued but not presented for payment Rs. 1250
vii. Cheque discounted dishonoured not recorded in the cash book. Rs. 12,500
Sum 18: On 31st March, 2023, bank statement of Gurman shows credit balance of Rs. 33,570 whereas cash
book showed a debit balance of Rs. 53,000
i. Cheques and drafts sent to the bank but not collected and credited, amounted to Rs. 7900 while
cheque for Rs. 2000 was received unpaid.
12
ii. Three cheques drawn for Rs. 3000, Rs. 1500 and Rs. 2000 respectively were not presented for
payment till 30th April, 2023
iii. Bank has paid a cheque of Rs. 10,000 but it has not been entered in the cash book and a cheque
of Rs. 5000 which was discounted with the bank was dishonoured by the drawee on the due date.
iv. Bank has charged Rs. 130 as its commission for collecting outstation cheques and had credited
an interest of Rs. 100 in the account
v. A wrong debit of Rs. 5000 was made by the bank, which was reversed on 4th April, 2023.
Prepare BRS as on 31st March, 2023
When starting point is Overdraft/ Unfavourable balance as per bank statement/ pass book (Debit)
Sum 19: On 31st March, 2023, the bank pass book of Surya Enterprises showed an overdraft of Rs. 7700.
On the basis of the following particulars, prepare BRS:
i. Cheques issued before 31st March, 2023 but not yet presented for payment amounted to Rs. 3500
ii. Cheques paid into the bank but a cheque amounting to Rs. 2600 has not been collected yet.
iii. Interest on loan amounting to Rs. 554, debited by the bank was not recorded in the cash book
iv. A debtor deposited Rs. 4800 directly into the bank but the information was received on 3 rd April,
2023
v. Payment side of Cash Book was totalled Rs. 1000 short
Sum 20: From the following information provided by Gurman, prepare BRS as on 31st March, 2023:
i. Bank overdraft as per bank pass book Rs. 16,500
ii. Cheques issued but not presented for payment Rs. 8750
iii. Cheques deposited with the bank but not collected Rs. 30,500
iv. Cheques recorded in the cash book but not sent to the bank for collection Rs. 2000
v. Payments received from customers directly by the bank Rs. 3500
vi. Bank charges debited in the pass book Rs. 200
vii. Premium on life policy of Gurman paid by the bank on standing instructions Rs. 1980
1. From the following particulars, prepare Bank Reconciliation Statement as on December 31, 2021:
i. Balance as per Cash Book Rs.4,200.
ii. Cheques issued but not presented for payment Rs.2,000.
iii. Cheques deposited but not collected Rs.3,000.
iv. Bank Charges debited by the Bank Rs.250
13
v. Cheques of Rs.17,500 were paid into bank but of Rs.8,500 were realised in the month of
April, 2021.
3. From the following particulars, ascertain the balance as would appear in the Pass Book of Ambani
Industrial works on 31st January, 2021.
i. Balance as per Cash Book on 31st January 2021 was Rs.4,000
ii. Cheques issued but not cashed prior to 31st January, 2010 amounted to Rs.1,000
iii. Cheques paid into Bank but not collected before 31st January amounted to Rs.800.
iv. There was a debit of Rs.400 for Bank charges in the Pass Book.
4. From the following particulars prepare Bank Reconciliation statement as on 31st March, 2021:
i. Overdraft as per Cash Book Rs.12,500.
ii. Cheques of Rs.18,000 were issued but were not presented for payment.
iii. Cheques of Rs.24,000 were paid into bank but wore not credited till 31 March 2021.
iv. Bank charges Rs.1,500.
5. You are required to prepare a Bank Reconciliation Statement as on June 30, 2021.
i. The bank column of a Cash Book showed a debit balance of Rs.1,49,000 on June 30, 2021.
Entries in the Cash Book and the Pass Book were compared and the following differences
were noticed:
ii. Cheques of Shyam Rs.9,000 and of Mohani Rs.15,000 were deposited but were not collected
upto June 30, 2021.
iii. Ram, a creditor, deposited a cheque of Rs.8,000 directly into the bank.
iv. Bank allowed an interest of Rs.1,500.
v. Cheque for Rs.10,000 issued to Radhey was not presented for payment.
vi. Bank debited the account by Rs.8,000, being insurance premium.
vii. Bank debited the account by Rs.700, being bank charges.
6. From the following particulars ascertain the balance that would appear in the Bank Pass Book of
Aman on 31st March, 2021.
i. The bank overdraft as per Cash Book on 31st March, 2021 Rs.60,200.
ii. Interest on overdraft for 6 months ending 31st March, 2021, Rs.10,000 entered in the Pass
Book.
iii. Bank charges of Rs.1,300 for the above period are debited in the Pass Book.
iv. Cheques issued but not cashed prior to 31st March, 2021, amounted to Rs.10,620.
v. Cheques paid into the bank but not cleared before 31st March, 2021, were for Rs.16,500.
vi. Interest on investment collected by the bank and credited in the Pass Book, Rs.11,000
14
iv. Out-station cheques for Rs.21,000 lodged in the bank on 30th March, 2021 but credited in
April, 2021.
v. Rs.100 being chamber of commerce subscription paid by the bank under a standing order on
31/3/ 2021 was not entered in the cash book.
vi. A hundi of Rs.2,500 due on 31st March, 2021 was sent to the bank for collection on 29th
March, 2021 and entered in the cash book forthwith, but the proceeds thereof were not
credited in the pass book till 2nd April, 2021.
13. Find out the balance as per cash book and ascertain the correct balance of cash book as on 31-5-
2021.
i. The pass book of Rita & Sons showed a balance of Rs.8,500 on 31st May, 2021.
ii. Cheques amounting to Rs.2,750 were deposited into the bank on 27th May but Cheque worth
Rs.510 were credited on 2nd June and one cheque of Rs.150 was returned by them as dishonored
on 5th June.
iii. Cheques drawn but not presented for payment amounted to Rs. 6,000.
iv. A B/P paid by the bank but not entered in the cash book Rs.1,500.
v. Credit side of bank column of cash book was cast Rs.100 short.
vi. Preeti Bros. the firm’s agent were requested to remit Rs.4,000 through telegraphic transfer but
they have remitted only Rs.2,500 for which there was no entry in the cash book.
15
i. Bank balance as per pass book (overdraft) Rs.3,000.
ii. A cheque of Rs.2,000 was credited in the pass book on 28-3-2021, later dishonored and was
debited in the pass book on 1-4-2021. There was no entry of this dishonored cheque in the
cash book within the date.
iii. The bank collected Rs.1,000 by way of interest and credited the amount but the same was not
recorded in the cash book within 31st March, 2021.
iv. A cheque of Rs.25,000 was lodged in the bank on 31st March, 2021 but the same was
credited in the pass book only on 7th April, 2021.
v. Of the cheques drawn on 28th March, 2021 for Rs.8,000, a cheque of Rs.2,000 was presented
for payment on 7th April, 2021.
vi. On scrutiny it was further found that the banker has given a wrong credit for Rs.500 and a
wrong debit for Rs.200 in the pass book which have not been recorded in the cash book
within 31st March, 2021.
16. Tanishq Limited received its bank statement for the period ended 30th June 2021 but this does not
agree with the balance shown in the Cash Book of Rs. 29720 in Company’s favour. Examination of
the two records, revealed the following:
i. A deposit of Rs. 4920 paid in on 29th June 2021 had not been credited by the bank until 1st
July 2021.
ii. Bank charges amounting to Rs. 170 had not been entered in the Cash Book.
iii. A debit of Rs. 420 appeared on the bank statement for an unpaid cheque, which had been
returned marked “Out of date”. The cheque had been re-dated by the customer of Tanishq
Ltd. and paid into the bank again on 3rd July 2021.
iv. A standing order for payment of an annual subscription amounting to Rs. 100 had not been
entered in the Cash Book.
v. On 25th June, the Managing Director had given the cashier a cheque for Rs. 1000 to pay into
his personal account at the bank. The cashier had paid it into the company’s account by
mistake.
vi. On 27th June, two customers of Tanishq Ltd. had paid direct to the company’s bank account
Rs. 4990 and Rs. 1570 for goods supplied. The advices were not received by the company
until 1st July and were entered in the Cash Book under that date.
vii. On 30th March 2021, the company had entered into a hire purchase agreement to pay by
Banker’s order a sum of Rs. 260 on the 10th day of each month commencing from April. No
entries had been made in the Cash Book.
viii. Rs. 3640 paid into the Bank had been entered twice in cash book.
ix. Cheque issued amounted to Rs. 46,720 had not been presented to the bank for payment until
after 30th June.
x. A customer of the company, who received a cash discount of 2.5% on his account of Rs.
2000, paid the company a cheque on 10th June. The Cashier, in error, entered the gross
amount in the bank col. of the cash book.
You are required:
a. To show the necessary adjustments in the Cash Book of Tanishq Limited bringing down the
correct balance on 30th June 2021.
16
b. To prepare a reconciliation statement.
17. From the following particulars, ascertain the Bank Balance as per Pass Book as on 31st March 2021.
(a) without correcting the Cash Book balance and (b) after correcting the Cash Book balance
i. The bank Balance as per Cash Book on 31st March 2021 Rs.40,000
ii. Cheques issued but not encashed up to 31st March 2021 amounted to Rs.10,000
iii. Cheques paid into the bank but not cleared up to 31st March 2021 amounted to Rs.15,000
iv. Interest on Investments collected by the bank but not entered in the Cash Book Rs.500
v. Cheques deposited in the bank but not entered in Cash Book Rs.12,500
vi. Bank charges debited in Pass book but not entered in Cash Book Rs.100
Answers:
1. Balance as per Pass Book Rs.2,950.
2. 2.Balance as per Cash Book Rs.18,000.
3. 3. Balance as per Pass Book Rs.4,600.
4. Overdrafts per Pass Book Rs.20,000.
5. Balance as per Pass Book Rs.1,35,800.
6. Overdraft as per Pass Book Rs.66,380.
7. Overdrafts as per Cash Book Rs.2,404.8.
8. Overdrafts as per Cash Book Rs.8300.
9. Balance as per Cash Book Rs.2,260.
10. Balance as per Pass Book Rs.5,460.
11. Balance as per Cash Book Rs.19,300.
12. Balance as per Amended Cash Book Rs. 3154, Balance as per Pass Book Rs.7392.
13. Balance as per Amended Cash Book Rs. 52,000, Balance as per Pass Book Rs.47,900.
17
18