Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Communications had a computer failure on August 1, 2020, which resulted in the loss of data, including the balance of its Cash account and

Excel Communications had a computer failure on August 1, 2020, which resulted in the loss of data, including the balance of its Cash account and its bank reconciliation from July 31, 2020. The accountant, Brad Eyers, has been able to obtain the following information from the records of the company and its bank:

  1. An examination showed that two cheques (#461 for $645.00 and #492 for $225.00) had not been cashed as of August 1. Eyers recalled that there was only one deposit in transit on the July 31 bank reconciliation but was unable to recall the amount.
  2. The cash receipts and cash payments journal contained the following entries for August 2020:

Cash Receipts Cash Payments

Amounts Cheque# Amount

876.00 499 678.00

1,230.00 500 651.00

1,545.00 501 2,578.50

612.00 502 846.00

2,460.00 503 327.00

6,723.00 504 820.00

505 void

506 314.00

507 543.00

6,757.50

3.The bank provided the following as of august 31,2017.

Date Cheques and other debits Deposits and other credits Balance

Aug1#500 651.00 660.00 3,579.00

3 #492 225.00 3,354.00

5 #501 2,578.50 775.50

8 876.00 1,651.50

16 #499 678.00 585.00 1,558.50

17 EFT 442.50 1,116.00

19 EFT 720 1,836.00

21 #503 327.00 1,230.00 2,739.00

22 #504 860.00 EFT 336.50 2,215.50

24 EFT 471.00 2,686.50

26 NSF 1,792.50 1,545.00 2,439.00

27 SC 37.50 2,401.50

31 #507 543.00 612.00 2,470.50

4.The deposit made on August 16 was for the colection of a note receivable ($540.00) plus interest.

5. The EFTs had not yet been recorded by Excel Communications since the bank statement was the first notification of them.

.The August 17 EFT was for the monthly payment on an insurance policy for Excel Communications.

.The August 19 and 24 EFTs were collections on accounts receivable.

.The August 22 EFT was in errorthe transfer should have been to Accel Communications.

6.The NSF cheque on August 26 was received from a customer as payment of $1,792.50 for installation of a satellite purchased from Excel.

7.Cheque #504 was correctly written for $860.00 for the purchase of inventory (assume a perpetual system) but incorrectly recorded by the cash payments clerk.

Required

  1. bank reconciliation as of August 31, 2020, including the calculation of the book balance of August 31, 2020.
  2. all journal entries that would be required by the bank reconciliation. Explanations are not required.

I spend too much time be able to put this question here.

Thanks in advance!

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

College Accounting Chapters 1-9

Authors: James Heintz

22nd Edition

1305888537, 978-1305666184

More Books

Students also viewed these Accounting questions