The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2020 $ 9,564.35 Book balance $20,0 Bank statement balance Add: Deposit of May 31 in transit Deduct: Outstanding cheques : W876 W882 Adjusted bank balance 982.17 $10,546.52 Deduct: NSF cheque plus service charge 2,455.99 Bank service charge $ 8,090.53 Adjusted book balance $11, 900.50 $ 655.99 1,800.00 65.00 11,9 $ 8,0 The Cash account in the G transactions): ral Ledger appeared as follows on June 30 Gatz uses only a General Journal to record The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions): Cash Acct. No. 101 Balance PR Debit Credit Date Explanation 2020 May 31 Balance June 1 Cheque #883 1 Cheque #884 3 Cheque #885 4 Cheque #886 9 Deposit 12 Cheque #887 12 Cheque #888 12 Cheque #889 18 Deposit 20 Cheque 1890 21 Cheque #891 24 Cheque #892 26 Cheque 1893 29 Deposit GJ16 GJ16 GJ16 GJ16 GJ16 4,285.26 GJ16 GJ16 GJ16 GJ16 3,515.60 GJ16 GJ16 GJ16 GJ16 GJ16 1,845.35 8,090.53 1,865.30 6,225.23 112.70 6, 112.53 650.84 5,461.69 2,018.45 3,443.24 7,728.50 425.15 7.303.35 3,040.60 4,262.75 974.12 3,288.63 6, 804.23 2,640.00 4,164.23 1,406.24 2.757.99 2,590.81 167.18 75.99 91.19 1,936.54 The following bank statement is available for June: Bank Statement To: Gatz Company Cheques/Charges Deposits/Credits 05/31 06/01 982.17 06/09 4,285.26 #884 06/01 #883 06/04 #876 06/09 #889 06/12 #882 06/14 #887 06/18 #885 06/20 #891 06/21 #886 06/29 SC 06/30 NSF = Not Sufficient Funds 06/18 June 30, 2020 Bank of Montreal Balance 9,564.35 10, 433.82 8,568.52 12,197.79 11, 223.67 9, 423.67 12,694.12 12,043.28 10,997.04 8,978.59 8,903.59 INT = Interest 112.70 1,865.30 655.99 974.12 1,800.00 245.15 650.84 1,046.24 2,018.45 75.00 SC = Service Charge 3,515.60 06/30 PMT = Principal Payment Required: a. Prepare a bank reconciliation at June 30, 2020. Assume that any errors made were by the bookkeeper (cheque #887 was for office supplies; cheque #891 was for utilities expense). (Round your answers to 2 decimal places.) Check my work Dan reconciation June 30, 2020 Bank Statement Company's Books Bank statement balance Add: Book balance Add: $ $ 0.00 0.00 Deduct: Deduct: Outstanding cheques Adjusted bank balance 0.00 Adjusted book balance View transaction list :X: 1 Record to account for error in Cheque #887. 2 Record to account for error in Cheque #891. 3 Record bank service charges for June. Credit Note : journal entry has been entered
