The bank reconciliation prepared by Gemma Tours on March 31, 2020, appeared as follows: GEMMA TOURS Bank Reconciliation March 31, 2020 Bank statement balance $15,700 Book balance Add: Deposit of March 31 in transit 22,328 38,028 Deduct: Outstanding cheques: #79 $ 1,322 884 2,007 3,329 Adjusted bank balance $34,699 Adjusted book balance $34,699 $34,699 The Cash account in the General Ledger appeared as follows on April 30: Cash Explanation PR Debit Credit Acet. No. 101 Balance Dat 2020 March April Balance 31 30 30 CR1136, 101.00 CD14 46,073.00 34,699.00 70,300.00 24,722.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 13 18 23 22 30 $15,055.00 904.00 14,464.00 1,008.00 2.007.00 2.663.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 $15,055.00 13 904.09 18 14, 464.00 23 1,000.00 27 2,067.00 30 2.663.00 Total April Cash Receipts $36, 101.00 Cheques Weitten No. 1 92 93 94 96 97 98 99 100 Total April Cash Disbursements $ 1,272 5,545 2,590 3,659 2,071 1,919 8,974 3,071 9,094 5,878 $46,073 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 April 30, 2020 Bank of Montreal Balance 15,700 35,519 93 04/02 2,509 04/03 22,328 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 Tot Geena Tours cheques/Charges Deposits/Credits #93 22,328 15,855 904 04/02 #92 04/07 #84 04/13 NSE 04/18 a95 04/23 #99 04/27 #96 04/30 497 04/30 3194 04/30 04/30 INT 04/30 SC 04/30 NSF = Not Sufficient Funds 2,509 5,545 2,007 6,972 3,021 9,894 1,919 8,974 3,659 9,987 35 55 SC Service Charte 04/03 04/07 04/13 64/18 04/23 04/27 04/30 INT 14,464 1,008 2,607 2,663 46 April 30, 2020 Bank of Montreal Balance 15,700 35,519 45,029 43,926 51,418 49,355 42,268 43,012 34,084 38,425 20,438 20,403 20,348 INT = Interest PNT 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 Saved Help GEMMA TOURS Bank Reconciliation April 30, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add: Deduct: Outstanding cheques Deduct: Adjusted bank balance Adjusted 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 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
