P7-2

The management of Rock Castle Construction wants a listing of collections on accounts receivable (Received Payments) in excess of $5,000 for last year (01/01/2021 to 12/31/2021). The listing is to be sorted by invoice date from the earliest to latest and is to include only the following three columns in the order listed, from left to right: Customer, Collection Amount, and Collection Date. The total of collections on the listing should be included. The schedule should have proper headings and your name. Export the information to Excel to complete the requirement. You may need to edit some of the column headings after exporting to Excel.

Required

What is this ? Prepare and print a list of cash receipts from collections on accounts receivable in the format requested by management.