ACCT 300 - Problem 5-4 guide

profileputul
 (Not rated)
 (Not rated)
Chat

Aztec Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of May 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account.

CASH ACCOUNT

Balance as of May 1                                                            $9,578.00

CASH RECEIPTS FOR MONTH OF May $5,948.81

DUPLICATE DEPOSIT TICKETS:

Date and amount of each deposit in May:

 

Date

Amount

2-May

 $     569.50

5-May

 $     701.80

9-May

 $     819.24

12-May

 $     580.70

16-May

 $     600.10

19-May

 $     701.26

23-May

 $     331.45

26-May

 $     601.50

31-May

 $  1,043.26

 

 

 

 

 

 

 

 

CHECKS WRITTEN:

   Number and amount of each check issued in May:

 

Check Number

Amount

614

 $            243.50

615

 $            350.10

616

 $            279.90

617

 $            395.50

618

 $            435.40

619

 $            320.10

620

 $            328.87

621

 $            309.50

622

 VOID

623

 VOID

624

 $            707.01

625

 $            158.63

626

 $            550.03

627

 $            318.73

628

 $            837.70

629

 $            329.90

630

 $            882.80

631

 $         1,081.56

632

 $               62.40

633

 $            310.08

634

 $            503.30

Total Amount of checks issued in May

 $         8,405.01

Instructions

1.   Prepare a bank reconciliation as of May 31. If errors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales except for the note receivable of $4,000 and interest of $160 collected on May 14. All checks are written to satisfy accounts payable.

2.   Illustrate the effects on the accounts and financial statements of the bank reconciliation.

3.   What is the amount of Cash that should appear on the balance sheet as of May 31?

4.         Assume that a canceled check for $180 has been incorrectly recorded by the bank as $1,800. Briefly explain how the error would be included in a bank reconciliation and how it should be corrected.

    • 11 years ago
    ANSWER FOR U - use this as a guide
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      acct300_5-04.xlsx