In: Accounting
The bank reconciliation prepared by Gemma Tours on March 31,
2020, appeared as follows:
| GEMMA TOURS | ||||||||||
| Bank Reconciliation | ||||||||||
| March 31, 2020 | ||||||||||
| Bank statement balance | $ | 14,600 | Book balance | $ | 32,268 | |||||
| Add: | ||||||||||
| Deposit of March 31 in transit | 20,764 | |||||||||
| 35,364 | ||||||||||
| Deduct: | ||||||||||
| Outstanding cheques: | ||||||||||
| #79 | $ | 1,229 | ||||||||
| #84 | 1,867 | 3,096 | ||||||||
| Adjusted bank balance | $ | 32,268 | Adjusted book balance | $ | 32,268 | |||||
The Cash account in the General Ledger appeared as follows on April
30:
| Cash | Acct. No. 101 | ||||||||
| Date | Explanation | PR | Debit | Credit | Balance | ||||
| 2020 | |||||||||
| March | 31 | Balance | 32,268.00 | ||||||
| April | 30 | CR11 | 33,574.00 | 65,842.00 | |||||
| 30 | CD14 | 43,030.00 | 22,812.00 | ||||||
A list of deposits made and cheques written during April, taken
from the Cash Receipts Journal and Cash Disbursements Journal, is
shown below:
| Deposits Made | |||||
| April | 7 | $ | 14,001.00 | ||
| 13 | 841.00 | ||||
| 18 | 13,456.00 | ||||
| 23 | 938.00 | ||||
| 27 | 1,867.00 | ||||
| 30 | 2,471.00 | ||||
| Total April Cash Receipts | $ | 33,574.00 | |||
| Cheques Written | |||||
| No. | 91 | $ | 1,183 | ||
| 92 | 5,157 | ||||
| 93 | 2,590 | ||||
| 94 | 3,403 | ||||
| 95 | 2,856 | ||||
| 96 | 1,785 | ||||
| 97 | 8,347 | ||||
| 98 | 2,856 | ||||
| 99 | 8,457 | ||||
| 100 | 6,396 | ||||
| Total April Cash Disbursements | $ | 43,030 | |||
The following bank statement is available for April: (Note: The
bank deposits interest into the bank account at the end of every
month.)
| Bank Statement | ||||||||||
| To: Gemma Tours | April 30, 2020 Bank of Montreal |
|||||||||
| Cheques/Charges | Deposits/Credits | Balance | ||||||||
| 14,600 | ||||||||||
| #93 | 04/02 | 2,509 | 04/03 | 20,764 | 32,855 | |||||
| #92 | 04/07 | 5,157 | 04/07 | 14,001 | 41,699 | |||||
| #84 | 04/13 | 1,867 | 04/13 | 841 | 40,673 | |||||
| NSF | 04/18 | 6,488 | 04/18 | 13,456 | 47,641 | |||||
| #95 | 04/23 | 2,856 | 04/23 | 938 | 45,723 | |||||
| #99 | 04/27 | 8,457 | 04/27 | 1,867 | 39,133 | |||||
| #96 | 04/30 | 1,785 | 04/30 | 2,471 | 39,819 | |||||
| #97 | 04/30 | 8,347 | INT | 43 | 31,515 | |||||
| #94 | 04/30 | 3,403 | 28,112 | |||||||
| PMT | 04/30 | 9,288 | 18,824 | |||||||
| INT | 04/30 | 33 | 18,791 | |||||||
| SC | 04/30 | 52 | 18,739 | |||||||
| NSF = Not Sufficient Funds |
SC = Service Charge | PMT = Principal Payment | INT = Interest | |||||||
In reviewing cheques returned by the bank, the bookkeeper
discovered that cheque #93, for delivery expense, was recorded in
the Cash Disbursements Journal incorrectly as $2,590. The NSF
cheque was that of customer Laura Clark, deposited in April.
Required:
a. Prepare a bank reconciliation at April
30.
b. Prepare the necessary journal entries to bring
the General Ledger Cash account into agreement with the adjusted
balance on the bank reconciliation.
a.
| GEMMA TOURS | |||||
| Bank Reconciliation | |||||
| April 30, 2020 | |||||
| Bank statement balance | 18739 | Book balance | 22812 | ||
| Add: | Add: | ||||
| Interest credited by bank | 43 | ||||
| Cheque #93 recorded incorrectly ($2590 - $2509) | 81 | 124 | |||
| 18739 | 22936 | ||||
| Deduct: | Deduct: | ||||
| Outstanding cheques | NSF cheque | 6488 | |||
| #79 | 1229 | Principal payment | 9288 | ||
| #91 | 1183 | Interest | 33 | ||
| #98 | 2856 | Bank service charge | 52 | 15861 | |
| #100 | 6396 | 11664 | |||
| Adjusted bank balance | 7075 | Adjusted book balance | 7075 | ||
b.
| Date | General Journal | Debit | Credit |
| Apr. 30 | Cash | 43 | |
| Interest revenue | 43 | ||
| (To record interest earned) | |||
| Apr. 30 | Cash | 81 | |
| Delivery expense | 81 | ||
| (To rectify error in cheque #93) | |||
| Apr. 30 | Accounts receivable-Laura Clark | 6488 | |
| Cash | 6488 | ||
| (To reinstate customer account for NSF cheque) | |||
| Apr. 30 | Payable* | 9288 | |
| Cash | 9288 | ||
| (To record payment of principal amount) | |||
| Apr. 30 | Interest expense | 33 | |
| Cash | 33 | ||
| (To record payment of principal amount) | |||
| Apr. 30 | Miscellaneous expense | 52 | |
| Cash | 52 | ||
| (To record bank service charges) |
*It is not given in the question to what the principal payment pertains. Kindly select appropriate accounts or write under comments for any clarifications required.