Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone please explain step by step how to create report -2. Collections on Accounts Receivable The management of Craig's Design and Landscaping Services wants
Can someone please explain step by step how to create report
-2. Collections on Accounts Receivable The management of Craig's Design and Landscaping Services wants a listing of all collections on accounts receivable (Payments) in excess of $200 for the last 365 days (default time period). The listing is to be sorted by collection date from earliest to latest and is to include only the following columns in the order listed, from left to right: Customer, Collection Amount, Collection Date and Type. The final report should only include collections on accounts receivable (not all cash receipts). 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. Hint: Start with the All Sales page. Use the Filter button to isolate cash receipts and then do remaining requirements in Excel. You can either leave the payment amounts as negative in the report or use Excel functions to convert the negative amounts to positive amounts. Required Prepare and print a list of the cash receipts from collections on accounts receivable in the format requested by management. -2. Collections on Accounts Receivable The management of Craig's Design and Landscaping Services wants a listing of all collections on accounts receivable (Payments) in excess of $200 for the last 365 days (default time period). The listing is to be sorted by collection date from earliest to latest and is to include only the following columns in the order listed, from left to right: Customer, Collection Amount, Collection Date and Type. The final report should only include collections on accounts receivable (not all cash receipts). 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. Hint: Start with the All Sales page. Use the Filter button to isolate cash receipts and then do remaining requirements in Excel. You can either leave the payment amounts as negative in the report or use Excel functions to convert the negative amounts to positive amounts. Required Prepare and print a list of the cash receipts from collections on accounts receivable in the format requested by managementStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started