80.2K

Verified Solution

Link Copied!

roblem #5After reviewing ATG Company Ltd.s bank statement for the month of September 2022, the company accountant noted the following:Deposits in transitA deposit of $450.00 was made to the bank account on September 29th but is not yet reflected on the bank statement. Outstanding chequesThree outstanding cheques (cheque #134, $54.54; cheque #135, $440.05 and cheque #136, $121.12) were recorded in the company's accounting records but not yet shown on the bank statement.Bank errorsA bank charge of $60.00 is shown on the bank statement for a new cheque printing order. The company has not ordered new cheques and is planning to have this charge removed. EFT receiptsUnrecorded electronic receipts were identified on the bank statement. These were for $500.00 on September 2 and $150.00 on September 22. InterestInterest charges of $65.00 were shown on the bank statement. EFT paymentsUnrecorded electronic payments are shown on the bank statement. These included: $69.56 paid to the cable company for internet service on September 5th and $120.45 paid to the local office supply store on September 12th. NSF chequesA returned cheque plus NSF fee was shown on the bank statement (Cheque date September 19th, $560.00 plus $40.00 NSF fee).Service feesService fees shown on the bank statement but not recorded in the company accounts totalled $120.00.Company errorsThe bank statement shows a payment on September 9th for utilities of $165.85. The company books show $156.85. After investigation, $165.85 is determined as the correct payment. Note: the cash balance on the bank statement is showing $7,853.57.InstructionsPrepare the Bank Reconciliation for ATG Company for the month of September.(18 marks)Please note: There are no missing numbers. As such, you have to figure out the cash balance per books

Answer & Explanation Solved by verified expert

See Answer