The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS Bank Reconciliation March 31, 2020 $15,800 Book balance Bank statement balance Add: Deposit of March 31 in transit $34,920 22,470 38,270 Deduct: Outstanding cheques: #79 #84 Adjusted bank balance $1,330 2,820 3,350 $34,920 Adjusted book balance $34,920 The Cash account in the General Ledger appeared as follows on April 30: Cash Explanation PR Debit Credit Acct. No. 101 Balance Date 2020 March April Balance 31 30 30 CR11 CD14 36, 329.00 34,920.00 71,249.00 24,906.00 46,343.00 A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Joum shown below: Deposits Made 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 $15,150.00 13 910.00 18 14,560.00 23 1.015.00 27 2,020.00 30 2,674.00 Total April Cash Receipts $36,329.00 Cheques written No. 91 92 93 94 95 196 97 98 99 100 Total April Cash Disbursements $ 1,280 5.580 2,590 3,602 3,000 1,931 9,030 3.090 9,150 6.920 $46,343 The following bank statement is available for April (Note: The bank deposits interest into the bank account at the end of every more 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 Cheques/Charges Deposits/Credits 893 04/02 392 04/07 284 04/13 NSE 04/18 95 04/23 299 04/27 296 04/30 397 04/30 194 04/30 04/30 INT 04/30 SC 04/30 NSF - Not Sufficient Funds 2,509 5,580 2,920 7,020 3,090 9,150 1,931 9,030 3,682 10,050 35 55 SC Service Charge 04/03 03/02 04/13 04/18 04/23 04/27 04/30 INT 22,470 15,150 910 14,560 1,015 2,020 2,674 46 April 30, 2020 Bank of Montreal Balance 15,800 35,761 45,331 44,221 51,761 49.686 42,556 43,299 34,315 30,633 20,583 20,548 20,493 INT - Interest PHT - Principal Payment 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: o. Prepare a bank reconciliation at April 30. GEMMA TOURS Denti Required: a. Prepare a bank reconciliation at April 30. GEMMA TOURS Bank Reconciliation April 30, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add: Deduct: Deduct: Outstanding cheques Adjusted bank balance Adusted book balance b. Prepare the necessary journal entries to bring the General Ledger Cash account into agreement with the adjusted balance on the bank reconciliation View transaction list Journal entry worksheet 2 4 5 6 > Record interest earned. Note: Enter debits before credits General Journal Debit Credit Date Apr 30 View transaction list View journal entry worksheet X X Debit Credit 1 Record interest earned. 2 Record to account for error in Cheque #93. 3 Record to reinstate customer account, 4 Record April loan payment. 5 Record April interest expense. 6 Record April bank charges. Note : = journal entry has been entered