undefined
The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows: 5 GATZ COMPANY Bank Reconciliation May 31, 2020 $ 9,464.35 Book balance Bank statement balance $19,849.00 Add: Dints Deposit of May 31 in transit 969.00 $10,433.35 01:58:27 Deduct: NSF cheque plus service charge $11,780.65 Deduct: Outstanding cheques : #876 #882 Adjusted bank balance $ 650.00 1,782.00 67.00 Skipped 2,432.00 $ 8,001.35 Bank service charge Adjusted book balance 11,847.65 $ 8,001.35 eBook The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions): Print Acct. No. 101 Balance PR Debit Credit Cash Date Explanation 2020 May 31 Balance June 1 Cheque #883 1 Cheque #884 3 Cheque #885 GJ16 GJ16 GJ16 8,001.35 1,853.00 6, 148.35 107.00 6,041.35 618.00 5,423.35 UT 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 10 points 8 01:58:22 Skipped 4,593.00 Cash Date Explanation PR 2020 May 31 Balance June 1 Cheque #883 GJ16 1 Cheque #884 GJ16 3 Cheque #885 GJ16 4 Cheque #886 GJ16 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 GJ16 24 Cheque #892 GJ16 26 Cheque #893 GJ16 29 Deposit GJ16 8,001.35 1,853.00 6,148.35 107.00 6,041.35 618.00 5,423.35 1,917.00 3,506.35 8,099.35 425.15 7,674.20 3,148.00 4,526.20 938.00 3,588.20 7,481.20 2,543.00 4,938.20 1,406.24 3,531.96 2,498.00 1,033.96 71.00 962.96 2,713.96 eBook 3,893.00 Print 1,751.00 The following bank statement is available for June: The following bank statement is available for June: 5 Bank Statement To: Gatz Company Cheques/Charges Deposits/Credits 05/31 06/01 969.00 10 points 06/09 4,593.00 01:58:17 06/18 June 30, 2020 Bank of Montreal Balance 9,464.35 10,326.35 8,473.35 12,416.35 11,478.35 9,696.35 13,344.20 12,726.20 11,679.96 9,762.96 9,690.96 INT = Interest 3,893.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 Skipped 107.00 1,853.00 650.00 938.00 1,782.00 245.15 618.00 1,046.24 1,917.00 72.00 SC = Service Charge eBook 06/30 PMT = Principal Payment Print 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.) GATZ COMPANY
