Advertisements
Advertisements
Question
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
| Particulars | Amount (₹) | Amount (₹) |
| Bank Balance as per pass book | 14,000 | |
| Add: (1) Insurance Premium paid and debited only in the pass book | 500 | |
| (2) Commission debited in the pass book but not credited in the Cash Book | 75 | |
| (3) Cheque dishonored and recorded only in the pass book | 900 | |
| (4) Cheque deposited into the bank wrongly recorded twice in the Cash Book MaharashtraBoardSolutions.in | 1,500 | |
| (5) Cheque deposited but not credited in the pass book | 10,000 | 12,975 |
| 26,975 | ||
| Less: (1) Dividend collected by the bank but not recorded in the Cash Book | 1,000 | |
| (2) Cheques issued but not presented for payment | 12,000 | 13,000 |
| Bank Balance as per Cash Book | 13,975 |
Working Notes:
| Cash Book (With Bank Column) | |||||
| 2. | Dividend collected | 1,000 | 3. | Insurance Premium | 500 |
| 4. | Commission debited | 75 | |||
| 5. | Cheque dishonoured | 900 | |||
| 6. | Cheque recorded twice | 1500 | |||
| (-) | (+) | ||||
| Pass Book | |||||
| 2. | Cheques issued | 12,000 | 1. | By Balanced b/d | 14,000 |
| Cheque deposited | 10,000 | ||||
| (+) | (+) | ||||
APPEARS IN
RELATED QUESTIONS
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 ____________
| Dr. | Cash Book (Bank column only) | Cr. | |||
| Date | Receipts | Amount (₹) | Date | Payments | Amount (₹) |
| 2018 Oct | 2018 Oct | ||||
| 01 | To Balance b/d | 10,000 | 07 | By Dipak | 12,000 |
| 05 | To Shruti | 5,000 | 10 | By Anil | 3,000 |
| 08 | To Priti | 6,000 | 15 | By Bank charges | 200 |
| 12 | To Diwakar | 3,000 | 17 | By Advertisement | 2,000 |
| 20 | To Jayesh | 4,000 | 20 | By Drawings | 1,000 |
| 31 | By Balance c/d | 9,800 | |||
| 28,000 | 28,000 | ||||
In the books of Bank
| Dr. | Pass Book | Cr. | |||
| Date | Payments | Amount (₹) | Date | Payments | Amount (₹) |
| 2018 Oct | 2018 Oct. | ||||
| 07 | To Interest | 500 | 01 | By Balance b/d | 10,000 |
| 10 | To Insurance premium | 2,000 | 10 | By Priti | 6,000 |
| 13 | To Anil | 3,000 | 22 | By Sunil | 4,000 |
| 20 | To Telephone bill | 2,000 | 24 | By Raju | 2,000 |
| 20 | To Drawings | 1,000 | 27 | By Swanand | 3,000 |
| 31 | To Balance c/d | 16,500 | |||
| 25,000 | 25,000 | ||||
From the following extract of Cash Book and Pass Book prepare Bank Reconciliation Statement as of 31st March 2019.
In the books of ____________
| Dr. | Cash Book (Bank Column only) | Cr. | |||
| Date | Receipts | Amount (₹) | Date | Payments | Amount (₹) |
| 2019 Mar. | 2019 Mar. | ||||
| 01 | To Balance b/d | 79,500 | 04 | By Rent | 36,000 |
| 04 | To Avinash | 18,000 | 06 | By Mansi | 20,100 |
| 09 | To Dhananjay | 25,500 | 12 | By Nikhil | 9,600 |
| 15 | To Meenal | 10,800 | 17 | By Drawings | 15,000 |
| 20 | To cash | 24,000 | 24 | By Nishant | 27,600 |
| 27 | To Prasad | 14,700 | 31 | By Balance c/d | 64,200 |
| 1,72,500 | 1,72,500 | ||||
In the books of Bank
| Dr. | Bank Pass Book | Cr. | ||
| Date | Particulars | Withdrawals Dr. ₹ |
Deposits Cr. ₹ |
Balance ₹ |
| 2019 Apr. | ||||
| 01 | By Balance b/d | 86,400 | ||
| 04 | By Keerti | 10,800 | 97,200 | |
| 06 | By Pramod | 14,700 | 1,11,900 | |
| 10 | To Salary | 24,000 | 87,900 | |
| 13 | To Nilesh | 27,600 | 60,300 | |
| 18 | By Omkar | 11,400 | 71,700 | |
| 23 | To Dipak | 6,600 | 65,100 | |
| 27 | To Vaishali | 20,100 | 45,000 | |
| 30 | By Jaydeep | 18,000 | 63,000 | |
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.
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.
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.
