Prompt
For this assignment, in the sample data files of the ACL software, find the data sets from two accounts payable tables, Veltronics_Unpaid_Invoices and Veltronics_Master_File, and export them to Excel. An Excel template is provided to assist in the completion of this assignment.
Your final product should demonstrate how Excel can be used to determine that all vendors included on the unpaid invoices are included in the accounts payable master list.
Specifically, the following critical elements must be addressed:
- On the Aging Schedule tab of the template, create an aging accounts payable schedule that includes 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days.
- On the >90 days tab, prepare a table of all unpaid vendors’ invoices more than 90 days old, including the vendors’ names, invoice numbers, invoice dates, and invoice amounts.
- On the >7 invoices tab, prepare a table that indicates vendors with seven or more outstanding invoices.
- On the Duplicates tab, explain how the duplicates can be found in the Trans table.
What to Submit
Your activity must be submitted as a Microsoft Excel spreadsheet. Different tabs should be created in the Excel workbook for each critical element. All comments can be inserted into Excel.
Module Six Activity Rubric
| Criteria | Proficient (100%) | Needs Improvement (75%) | Not Evident (0%) | Value |
|---|---|---|---|---|
| Aging Accounts | Creates an aging accounts payable schedule that includes 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days | Creates an aging accounts payable schedule that includes 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days, but payable schedule is incomplete or contains errors | Does not create an aging accounts payable schedule that includes 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days | 23 |
| Unpaid Vendors’ Table | Prepares a table of all unpaid vendors’ invoices more than 90 days old, including the vendors’ names, invoice numbers, invoice dates, and invoice amounts | Prepares a table of all unpaid vendors’ invoices more than 90 days old, including the vendors’ names, invoice numbers, invoice dates, and invoice amounts, but table does not include all the requirements | Does not prepare a table of all unpaid vendors’ invoices more than 90 days old | 23 |
| Outstanding Invoices Table | Prepares a table that indicates vendors with seven or more outstanding invoices | Prepares a table that indicates vendors with seven or more outstanding invoices, but table is missing information | Does not prepare a table that indicates vendors with seven or more outstanding | 22 |
| Duplicates | Explains how the duplicates can be found in the Trans table | Explains how the duplicates can be found in the Trans table, but explanation is unclear or miscalculated | Does not explain how the duplicates can be found in the Trans table | 22 |
| Articulation of Response | Submission has no major errors related to citations, grammar, spelling, syntax, or organization | Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas | Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas | 10 |
| Total: | 100% |