Practical Problems
Question 1.
Following is the extract of the Cash Book (Bank Column only) and passbook. Prepare Bank Reconciliation Statement as of 31st Oct. 2018.
In the books of ____________
In the books of Bank
Solution:
Bank Reconciliation Statement as of 31st October 2018.
Working Notes:
When extract of Cashbook and passbook are given for the same period i.e. for the month of April 2018, we have to consider only uncommon entries for adding and deducting from Bank Reconciliation Statement. This is shown in the following working notes.
In order to find out items to be added and items to be deducted in the Bank Reconciliation Statement, we have to prepare Cash Book and passbook on the basis of accounting information given in the problem:
Cash Book
Bank Pass Book
Explanation:
1. First record the opening balance in the appropriate book i.e. either in Cashbook or passbook.
2. Bank balance of ₹ 9,800 as per Cashbook is recorded on the debit side of Cashbook in a box.
3. In this problem, the entries which are passed on the debit side of the Cashbook and passbook are to be added in the Bank Reconciliation Statement and the entries passed on the credit side of the Cashbook and passbook are to be deducted in the Bank Reconciliation Statement. This is because the opening balance appears on the debit side of the Cash Book.
Question 2.
From the following extract of Cash Book and Pass Book prepare Bank Reconciliation Statement as of 31st March 2019.
In the books of ____________
In the books of Bank
Bank Pass Book
Solution:
Bank Reconciliation Statement as of 31st March 2019
Working Notes:
When extract of Cashbook and passbook are given for the same period i.e. for the month of April 2011, we have to consider only uncommon entries for adding and deducting from Bank Reconciliation Statement. This is shown in the following working notes.
In order to find out items to be added and items to be deducted in the Bank Reconciliation Statement, we have to prepare Cash Book and passbook on the basis of accounting information given in the problem:
Cash Book
Bank Pass Book
Question 3.
On 31st August 2018 bank passbook of Mr. Ravi showed a credit balance of ₹ 33,600, but Cash Book showed a different balance. On comparing the two books following differences were noticed:
1. Cheques paid into the bank but not credited before 31st Aug 2018 amounted to ₹ 24,500.
2. Direct deposit by the customer through NEFT ₹ 33,000 recorded in the passbook only.
3. Cheques issued on 28th Aug 2018 were presented for payment on 5th Sep. 2018 amounted to ₹ 38,800.
4. A bill receivable for ₹ 15,000 discounted with the bank was dishonored on 30th Aug 2018. Intimation of the same was received only on 3rd Sep 2018.
5. Passbook credit side was overcast ₹ 2,000.
6. Bank debited ₹ 400 for bank charges in the passbook, which was not recorded in Cash Book.
Prepare Bank Reconciliation Statement as of 31st August 2018.
Solution:
Bank Reconciliation Statement as of 31st August 2018.
Working Notes:
In order to find out items to be added and items to be deducted in the Bank Reconciliation Statement, we have to prepare Cash Book and passbook on the basic information given in the problem:
Cash Book (With Bank Column)
Bank Pass Book
Explanation:
1. First record the opening balance in the appropriate book and at the appropriate side i.e. either in Cashbook or passbook.
2. In the above problem Bank balance of ₹ 33,600 as per the passbook is recorded on the credit side of the passbook in a box.
3. In this problem, the entries which are passed on the credit side of the Cashbook and passbook are to be added in the Bank Reconciliation Statement and the entries passed on the debit side of the Cash Book and passbook are to be deducted in the Bank Reconciliation Statement. This is because the opening balance appears on the credit side of the passbook.
4. Pass the entry of the given transactions in the book in which entry is not passed due to one or another reason, e.g. cheque of ₹ 24,300 is deposited but not collected. In this case, entry is not passed in the passbook, as the cheque is not collected by the bank. Now draft the entry for the given transaction on the credit side of the passbook. This is because, after the collection of cheques, the bank balance is increased. In the same way for remaining transactions pass the entry in that book where entry is not passed corresponding.
Question 4.
From the following details prepare Bank Reconciliation Statement as of 31st Dec. 2018.
1. Bank overdraft as per Cash Book on 31st Dec. 2018 was ₹ 48,450.
2. Bank charges for SMS alerts ₹ 370 were debited in passbook but not recorded in Cash Book.
3. Interest in overdraft ₹ 2,870 did not appear in Cash Book.
4. A bill for ₹ 12,000 discounted with bank appears in Cash Book at the full amount but the bank has deducted ₹ 200 discounting charges.
5. Cheques issued but not presented for payment before 31st Dec. 2018 amounted to ₹ 32,300.
6. Cheques amounting to ₹ 24,000 were deposited into the bank but only a cheque of ₹ 8,000 was collected by the bank before 31st Dec. 2018.
7. Paid stationary bill ₹ 11,300 by debit card. It was not recorded in Cash Book.
Solution:
Bank Reconciliation Statement as of 31st December 2018.
Working Notes:
Cash Book (With Bank Column)
Bank Pass Book
Question 5.
From the following particulars prepare Rank Reconciliation Statement as of 30th June 2019.
1. Credit balance as per pass book ₹ 20,000.
2. A cheque for ₹ 3,500 was issued and paid by the bank, recorded in Pass Book as ₹ 5,300.
3. Cheque deposited ₹ 9,700 collected by the bank was not recorded in Cash Book.
4. Payment side of the Cash Book was undercast by ₹ 100.
5. Electricity bill paid by bank ₹ 6,200 was recorded twice in Pass Book.
Solution:
Bank Reconciliation Statement as of 30th June 2019.
Working Notes:
Cash Rook (With Rank Column)
Bank Pass Book
Question 6.
Prepare Bank Reconciliation Statement from the following information as of 31st March 2019.
1. Balance as per Cash Book ₹ 10,000.
2. Cheque of ₹ 2,000 issued but not presented to Bank for payment.
3. Our debtor directly deposited ₹ 3,500 to our Bank account by NEFT, not recorded in the Cash Book.
4. Bank paid electricity bill on our behalf ₹ 450 and charged Bank charges ₹ 100.
5. Paid ₹ 1,500 to ABC & company, our supplier by business debit card but recorded in Cash Book as ₹ 150.
6. Bank credited interest on Investment ₹ 500.
7. Cheque of ₹ 885 issued and presented to Bank but wrongly entered in the Pass Book as ₹ 865.
Solution:
Bank Reconciliation Statement as on 31st March 2019
Working Notes:
Cash Book (With Bank Column)
Bank Pass Book
Question 7.
On 31st January 2018 Bank balance as per Cash Book was ₹ 40,000 but Pass Book was showing some other balances following were the causes of the difference.
1. Cheques were issued for ₹ 1,00,000 in January 2018 but cheques of ₹ 50,000 were only presented to the Bank for payment before January 31st, 2018
2. Cheques were sent to the Bank for collection of ₹ 2,00,000 out of which cheques of ₹ 80,000 were only credited by the Bank in January 2018.
3. Following entries were shown in the passbook in January 2018, but no corresponding entries were made in the Cash Book.
(i) Payment of ₹ 6,400 by Bank for Electricity Bill by ECS.
(ii) Interest credited by Bank ₹ 12,000
(iii) Bank debited commission ₹ 1,000 and Bank charges for ₹ 600.
(iv) Direct deposit made by customer ₹ 1,000 by NEFT to our account.
Prepare Bank Reconciliation Statement as of 31st January 2018.
Solution:
Bank Reconciliation Statement as of 31st January 2018
Working Notes:
Cash Book (With Bank Column)
Bank Pass Book
Question 8.
In January 2018, the Pass Book of Mr. Girish Kumbhar showed a bank balance of ₹ 14,000. A comparison of the Cash Book with the Pass Book revealed the following.
1. Cheque deposited but not credited by Bank ₹ 10,000
2. Dividend on shares collected by Bank but not recorded in the Cash Book ₹ 1,000
3. Bank paid Insurance premium as per standing instruction by ECS ₹ 500, no corresponding entry was passed in the Cash Book.
4. Bank debited Commission ₹ 75.
5. A debit of ₹ 900 in respect of cheque dishonored appears in Pass Book only.
6. Cheque of ₹ 1,500 deposited into Bank wrongly recorded twice in the Cash Book.
7. Total cheques of ₹ 20,000 were issued during the month of January 2018, but cheques of ₹ 8,000 only were presented for payment in January 2018.
Prepare Bank Reconciliation Statement as of 31st January 2018.
Solution:
Bank Reconciliation Statement as of 31st March 2019
Working Notes:
Cash Book (With Bank Column)
Pass Book
Question 9.
Form the following details provided by Prasharit enterprises, prepare a Bank Reconciliation Statement as of 31st March 2018.
1. Overdraft as per Cash Book ₹ 28,000
2. Cheque issued of ₹ 2,000 and presented to Bank returned dishonored but the effect of dishonored is not recorded in the Cash Book.
3. Bank debited Bank charges ₹ 150.
4. Bank transferred ₹ 2,500 to the savings account of the proprietor but not recorded in the Cash Book.
5. Cheque issued to the supplier but not presented to Bank before 21st March 2018, ₹ 1,600
6. Cheques of ₹ 3,000 and ₹ 2,000 were deposited into Bank but cheques of ₹ 3,000 were only credited by Bank before 31st March 2018.
7. Out customer directly deposited ₹ 1,500 in our Bank account but wrongly recorded it in the cash column of the Cash Book.
8. Bank debited interest on overdraft ₹ 750.
Solution:
Bank Reconciliation Statement as of 31st March 2018.
Working Notes:
Cash Book (Bank column)
Pass Book
Question 10.
Prepare Bank Reconciliation Statement as of 31st Dec. 2018
1. Debit balance as per pass book ₹ 16,000
2. Customer directly deposited in our Bank account by NEFT ₹ 8,000.
3. Cheques deposited into Bank but not credited by Bank ₹ 10,500.
4. Pass Book shows a debit entry for Bank commission ₹ 300, not recorded in Cash Book.
5. A Bill of Exchange of ₹ 3,500 was discounted with the Bank in December 2018, returned dishonored in January 2019.
6. As per standing instructions Bank paid the Telephone bill of ₹ 650, not recorded in the Cash Book.
7. Cheque of ₹ 975 deposited into the Bank but wrongly recorded on ₹ 795 in Cash Book.
Solution:
Bank Reconciliation Statement as of 31st December 2018.
Working Notes:
Cash Book (with Bank column)
Bank Pass Book