Question

P-7-2. Rock Castle Construction-Collections on Accounts Receivable The management of Rock Castle Construction wants a listing of cash receipts from collections on accounts receivable in excess of $1,000 for the last fiscal quarter (07/01/2019 to 09/30/2019). The listing is to be sorted by invoice date from 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 Required Prepare and print a list of the cash receipts from collections on accounts receivable in the format requested by management.

I just need the steps to get me to this in QuickBooks.

Answer 1

Steps:

1) Extract invoice wise details for the last fiscal quarter (07/01/2019 to 09/30/2019) from earliest to latest

2) Extract collection data from cash receipts on accounts receivable till date

3) Take out collection figures greater than $1000 from Step 2 above

4) Prepare schedule in the following format

Rock Castle Construction - Collections on accounts receivables - (Your name)

Invoice details	Invoice amount	Customer	Collection amount	Collection date
Invoice no. 1	XXX	ABC	XXX	XX/XX/XXXX