Advertisements
Advertisements
Question
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 | |
Solution
Bank Reconciliation Statement as of 31st March 2019
| Particulars | Amount (₹) | Amount (₹) |
| Bank balance as per Cash Book | 64,200 | |
| Add : (1) Cheque issued to Mansi not presented for payment | 20,100 | |
| (2) Cheque issued to Nishant not presented for payment | 27,600 | 47,700 |
| Less : (1) Cheque received from Meenal deposited into the bank but not collected by the bank | 10,800 | 1,11,900 |
| (2) Cheque received from Prasad deposited into the bank but not collected by the bank MaharashtraBoardSolutions.in | 14,700 | 25,500 |
| Bank balance as per pass book | 86,400 |
Working Notes:
When a Cashbook and Passbook extract is given for the same period, i.e. for the month of April 2011, we must consider only unusual entries when adding and subtracting from the Bank Reconciliation Statement. The following working notes demonstrate this.
To determine which items should be added and which should be deducted in the Bank Reconciliation Statement, we must prepare a Cash Book and a Passbook using the accounting information provided in the problem:
| Cash Book | ||
| To Balance b/d | 64,200 | |
| (+) | (-) | |
| Bank Pass Book | |||
| To Vaishali's A/c | 20,100 | By Minal's A/c | 10,800 |
| To Nilesh A/c | 27,600 | By Prasad's A/c | 14,700 |
| (+) | (-) | ||
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 | ||||
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.
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.
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.
