Home Insert Draw Page Layout Formulas Data Review View Help O PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing 09 X A B C M N The bank reconciliation prepared by Gentle Tours on March 31, 2021, appeared as follows: 2 3 4 5 GENTLE TOURS Bank Reconciliation 6 March 31, 2021 14,600 41,418 Bank statement balance Add Deposit of March 31 in transit Book balance Add: receipt from J. Smith 20,764 35,364 150 41,568 Deduct Outstanding cheques: #79 #84 Adjusted barik balance Deduct service charges Loan payment 1.229 1,867 50 9250 9,300 3,096 32,268 Adjusted book balance 32.268 8 9 10 11 12 13 14 15 76 17 19 19 20 21 22 23 24 25 26 27 The Cash account in the General Ledger appeared as follows on April 30 Cash PR Acct. No. 101 Balance Explanation Debit Credit Date 2020 March April 31 Balance 30 30 CR11 33,574.00 CD 14 32,268.00 65,842.00 23,682.00 42,160.00 Monika Ready Type here to search o up O PROTECTED VIEW Be careful-files from the internet can contain viruses. Unless you need to edit it's sales to stay in Protected View Enable Editing 09 A B D G N A list of deposits made and cheques written during April, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below 31 Deposits Made Cheques Written April 17 No 33 34 35 13 18 23 $ 14,001.00 841 13.456.00 938 1,867.00 2,471.00 S 33.574.00 191 92 93 94 95 96 97 27 30 Total April Cash Receipts 180 5.157 2,590 3,403 2,856 1,785 8,347 2.856 8,590 6,396 42.160 38 39 40 11 12 + 98 99 100 Total April Cash Disbursements $ 4 5 The following bank statement is available for April: 6 Bank Statement To Gentle Tours Cheques/Charges Deposits/Credits 30-Apr-20 Bank of Montreal Balance 14,600 32,855 41,699 20 #84 02-Apr #92 07-Apr 40 An Monika 1,867 5,157 03-Apr 07-Apr 20,764 14,001 ady Type here to search CM File Home Insert Page Layout Formulas Data Review View O PROTECTED VIEW Be careful-iles from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View Enable Editing 09 A F 1 . 03-Apr 07-Apr 20,764 14,001 55 F 1.867 5,157 1,200 2,856 6,488 2,509 1,229 1,785 8,347 3,403 9,288 33 52 32 855 41,599 40,499 39.473 46,441 44,523 13-Apr 18 Apr 23-Apr 27-Apr B #84 02-Apr #92 07-Apr #164 08-Apr #95 13 Apr NSE 18-Apr 293 23 Apr #79 27-Apr #96 30-Apr #97 30-Apr #94 30-Apr PMT 30-Apr INT SC 30-Apr NSF = Not Sufficient Funds 841 13,456 938 57 58 59 60 61 62 63 64 1867 45,161 43,376 INT 43 30-Apr 35,072 31,669 22,381 22,348 22,296 INT = Interest 65 66 67 68 SC = Service Charge PMT = Principal Payment 69 70 In reviewing cheques returned by the bank, the bookkeeper discovered that cheque #93, for delivery expense, was recorded in the Cash Disbursements Journal incorrectly. The NSF cheque was that of customer Joey Gagnon deposited in April. Also cheque #164 was written by Gentle Ben Tours Required: a. Prepare a bank reconciliation at April 30 72 73 74 75 76 77 78 b. Prepare the necessary journal entries for the end of the month Monika Ready - Type here to search