2-DAN RELS 1 Save Help Save & E Check The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS Bank Reconciliation March 31, 2020 $14,500 Book balance $32,047 Bank statement balance Add: Deposit of March 31 in transit 20,622 35,122 Deduct: Outstanding cheques: #79 #84 Adjusted bank balance $1,221 1,854 3,075 $32,047 Adjusted book balance $32,047 The Cash account in the General Ledger appeared as follows on April 30: Cash Explanation Acct. No. 101 Balance PR Debit Credit Date 2020 March April Balance 31 30 30 CR11 33, 346.00 CD14 32,047.00 65,393.00 22,633.00 42,760.00 oprey search ot Check myt 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 13 18 23 27 30 Total April Cash Receipts $13,906.00 835.00 13,360.00 931.00 1,854.00 2,460.00 $33,346.00 Cheques written No. 91 92 93 94 95 96 97 98 99 100 Total April Cash Disbursements $ 1,175 5,122 2,590 3,380 2,837 1,773 8,291 2,837 8,401 6,354 $42,760 O RI to search IN Check my work 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: Gema Tours Cheques/Charges Deposits/Credits 284 04/03 04/07 04/12 64/18 04/23 04/27 04/3e 393 04/02 #92 04/07 84/13 NSF 04/18 04/23 399 04/27 #96 04/30 #97 84/30 #94 84/30 PMT 84/30 INT 04/30 SC 84/30 NSF - Not Sufficient Funds 395 2,509 5,122 1,854 6,440 2,837 8,401 1,773 8,291 3,380 9.225 33 52 SC - Service Charge 20,622 13,906 835 13,360 931 1,854 2,460 43 April 30, 2020 Bank of Montreal Balance 14,500 32,613 41,397 40,378 47.298 45,392 38,845 39,532 31,284 27,904 18,679 18,646 18,594 INT - Interest INT 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 ENG . 2020 to search ot & 12 IA 19 FO RO/ 13:14 EJ 0 16 Saved Help Save & Exit Submit Check my work 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: ces 0 0 0 Deduct: Deduct: Outstanding cheques 0 Adjusted bank balance Adjusted book balance 400 ENG to search 0 0 TO RA FIO Help Save & Exit Submit Check my work 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 1 2 3 4 5 6 > Record interest earned. Note: Enter debits before credits Credit Debit Date General Journal Apr 30 404 ENG o c e to search 112 IA 9 o OR F103 Help Save & Exh Submit Check my work Journal entry worksheet earch O IT 4) ENG 3:34 AM 2020-10-05 KON Er 16 12 IA 0 Check my wo Journal entry worksheet 1 3 4 5 6 ON Record to account for error in Cheque #93. Note: Enter debits before credits. General Journal Debit Credit Date Apr 30 Record entry Clear entry View general journal earch 4) ENC Help Save & Exit Check my Journal entry worksheet 1 5 6 Record to reinstate customer account. Note: Enter debits before credits. Date General Journal Debit Credit Apr 30 Record entry Clear entry View general journal search o c AO 40 Check my Journal entry worksheet 1 2 3 5 6 Record April loan payment. Note: Enter debits before credits. Date General Journal Debit Credit Apr 30 Record entry Clear entry View general Journal o search O RI Sub Check my world Journal entry worksheet 1 2 3 4 5 6 Record April interest expense. Note: Enter debits before credits Date General Journal Debit Credit Apr 30 Record entry Clear entry View general Journal 40 EN search O RI 12 IN RO 19 o Check my world Journal entry worksheet 400 ENG earch O E FROID 19 fo RIA