The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2020 $ 9,664.35 Book balance Bank statement balance Add: Deposit of May 31 in transit $20,265.00 992.00 $10,656.35 Deduct: NSF cheque plus service charge -8 $12,024.65 Deduct: Outstanding cheques: #876 #882 Adjusted bank balance $ 663.00 1,819.00 66.00 2,482.00 $ 8,174.35 Bank service charge Adjusted book balance 12,090.65 $ 8,174.35 The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions) Acct. No. 101 Balance Debit Credit Cash Date Explanation PR 2020 May 31 Balance June 1 Cheque #883 G316 1 Cheque #884 GJ16 3 Cheque #885 GJ16 4 Cheque #886 G]16 9 Deposit GJ16 12 Cheque #887 GJ16 12 Cheque #888 GJ16 12 Cheque #889 GJ16 18 Deposit GJ16 20 Cheque #890 GJ16 21 Cheque #891 G116 24 Cheque #892 G916 26 Cheque #893 GJ16 29 Deposit GJ16 8,174.35 1,860.00 6,314.35 112.00 6,202135 647.00 5,555.35 2,007.00 3,548.35 4,620.00 8,168.35 425.15 7,743.20 3,164.00 4,579. 20 944.00 3,635.20 3,929.00 7,555.20 2,558.00 4,997.20 1,406.24 3,590.96 2,511.00 1,079.96 74.00 1,005.96 1,758.00 2,763.96 The following bank statement is available for June: The following bank statement is available for June: Bank Statement To: Gatz Company Cheques/Charges Deposits/credits 05/31 06/01 992.ee 26 06/09 4,620.00 #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 June 30, 2020 Bank of Montreal Balance 9,664.35 10,544.35 8,684.35 12,641.35 11,697.85 119,878.35 13,553.20 12,906.20 11,859.96 19,852.96 9,777.96 INT. - Interest 06/18 112.00 1,860.00 663.00 944.00 1,819.00 245.15 647.ee 1,046.24 2,007.00 75.00 SC = Service Charge 3,920.00 06/20 PMT = Principal Payment Required: 8. Prepare a bank reconciliation at June 30, 2020. Assume that any errors made were by the bookkeeper(cheque =827 was for OFFICE supplies, cheque #891 was for utllites expenses. (Round your answers to 2 decimal places.) GATZ COMPANY Bank Reconeiliation June 30, 2020 Bank Statement Company's Books ant statement balance Book balance Add: Add: 0.00 s 0:00 Deduct: Deduct: Outstanding cheques. 0.00 Adjusted book balance Adjusted bank balance b. Prepare the necessary entries resulting from the bank reconciliation. 21 View transaction list Journal entry worksheet