Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Enterprise Information Systems A Pattern Based Approach

Authors: Cheryl Dunn, J. Owen Cherrington, Anita Hollander

3rd Edition

0072404299, 978-0072404296

More Books

Students also viewed these Accounting questions