The bank reconciliation prepared by Gatz Company on May 31, 2020. appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2020 $8,964,35 Book balance $18,799.ee Sank Statement balance Add: Deposit of May 31 in transit 919.00 $9,883.35 $11,155.65 Deduct Outstanding cheques: R76 8882 Adjusted bank balance $ 615.00 162.00 Deduct: NSF cheque plus service charge Bank service charge Adjusted book balance 62.ee 2,302.00 $9,581.35 11 217.65 $ 7,581.35 The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions): Cash Date Explanation PR 2ee May 31 Balance June 1 Cheque 1883 G316 Cheque G16 3 Cheque #685 6716 4 Cheque 1886 6316 9 Deposit G316 12 Cheque #882 6216 12 Cheque 1888 GJ16 12 Cheque 889 G16 18 Deposit 16 ReCheque te 616 21 Cheque 24 Cheque 692 16 26 Cheque 16 29 Deposit 16 Acct. No. 101 Debit Credit Balance 7.581.35 1,838.00 5,743.35 107.ee 5,636.35 618.69 5,818.35 1,917.00 3,181.35 4,558.00 7,659.35 425.15 7,234.20 3,123.00 4,111.20 933.ee 3.178.20 3,858.00 7,836.20 2,528.00 4.588.28 1486.243.181.95 2.483.00 618.96 71.00 547.96 1,216.00 2,283.96 316 The following bank statement is available for June: Bank Statement To: Gatz Company Cheques/Charges Deposits/Credits e5/31 26/01 919.00 26/09 4.558.80 06/18 June 30, 2020 Bank of Montreal Balance 8.964.35 9,276.35 2,938.35 11,881.35 10,948.35 9.251.35 12,874.20 12.256.20 11.209.96 292296 9.228.56 INI Interest #884 86/81 #883 86/80 826 06709 889 06/12 882 66/14 882 86/18 88 26720 86/21 26/29 de se NSE Not sufficient Hunds 3858.00 107.00 1.838.00 615.ee 933.80 1,687.ee 215.15 518.80 1.646.24 1.317.ee 12.00 5 Service Charge LOR 988 OS 26/30 PMI Principal Payment Required: o. 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) GATZ COMPANY Bank Reconciliation Jun 10 2020 Bank Statement Company's Books Bank statement balance Add Book balance Add Deduct Deduct Outstanding cheques Adjusted band balance Red COOR balance b. Prepare the necessary entries resulting from the bank reconciliation View transaction list Journal entry worksheet A 1 2 3 > Record to account for error in Cheque #887. Note Enceito Durundi Date General Joumal Debit Credit June 30 Record entry Centry Vi general joumal