Saved Help The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS Bank Reconciliation March 31, 2020 $14,200 Book balance Bank statement balance Add: Deposit of March 31 in transit $31, 384 20, 196 34,3967 ed Deduct: Outstanding cheques : #79 #84 Adjusted bank balance $ 1,197 1,815 3,012 $31,384 Adjusted book balance $31,384 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 32,662.00 CR11 CD14 31, 384.00 64,046.00 22,096.00 41,950.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 V 13 18 23 27 30 $13,621.00 817.00 13,072.00 910.00 1,815.00 2,427.00 $32,662.00 Total April Cash Receipts Cheques Written No. 91 92 93 94 95 96 97 98 99 100 $ 1,151 5, 017 2,590 3, 311 2,780 1, 737 8, 123 2,780 8, 233 6, 228 $41,950 ed Total April Cash Disbursements 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 #93 04/02 #92 04/07 #84 04/13 NSF 04/18 #95 04/23 #99 04/27 #96 04/30 #97 84/30 #94 84/30 PMT 04/30 INT 04/30 SC 04/30 NSF = Not Sufficient Funds 2,509 5,017 1,815 6,296 2,780 8,233 1,737 8,123 3,311 9,036 33 52 SC = Service Charge 04/03 04/07 04/13 04/18 04/23 04/27 04/30 INT 20,196 13,621 817 13,072 910 1,815 2, 427 43 April 30, 2020 Bank of Montreal Balance 14, 200 B1,887 40 491 39.493 46,269 44, 399 37,981 38.671 B0,591 27.280 18, 244 18, 211 18, 159 INT - Interest PMT 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: a. Prepare a bank reconciliation at April 30. GEMMA TOURS Bank Reconciliation April 30. 2020 Bank Statement Company's Books Bank statement balance Book balance Add: Add: 0 0 0 Deduct: Deduct: Outstanding cheques: 0 Adjusted bank balance Adjusted book balance ent 7 - Ch 7 Saved 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 d 2 3 4 5 6 Record terest earned. Note: Enter debits before credits. Date General Journal Debit Credit Apr 30 Record entry Clear entry View general journal 2 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 ints Journal entry worksheet Skipped 1 3 4 5 no 6 Record to account for error in Cheque #93. Print Note: Enter debits before credits. Date General Journal Debit Credit Apr 30 Record entry Clear entry View general journal 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 ed Mc Graw Hill . - Ch 7 Saved Help Sas 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 Mc Graw Hill . - Ch 7 Saved Help Sas 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