Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help getting answers to the following attachments ACC 693 Module Six Activity Guidelines and Rubric Overview: This assignment will demonstrate another use of
I need help getting answers to the following attachments
ACC 693 Module Six Activity Guidelines and Rubric Overview: This assignment will demonstrate another use of Microsoft Excel to perform similar commands as Audit Command Language (ACL). You will use accounts payable files to identify anomalies. 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. 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: Create an aging accounts payable schedule that includes 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. Prepare a table of all unpaid vendors' invoices more than 90 days old, including the vendors' names, invoice numbers, invoice dates, and invoice amounts. Prepare a table that indicates vendors with seven or more outstanding invoices. Explain how the duplicates can be found in the Trans table. Guidelines for Submission: 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. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Aging Accounts Proficient (100%) Creates an aging accounts payable schedule that includes 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days 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 Needs Improvement (75%) 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 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 Not Evident (0%) 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 Value 23 Does not prepare a table of all unpaid vendors' invoices more than 90 days old 23 Outstanding Invoices Table Duplicates Articulation of Response Prepares a table that indicates vendors with seven or more outstanding invoices Explains how the duplicates can be found in the Trans table Submission has no major errors related to citations, grammar, spelling, syntax, or organization Prepares a table that indicates vendors with seven or more outstanding invoices, but table is missing information Explains how the duplicates can be found in the Trans table, but explanation is unclear or miscalculated Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Does not prepare a table that indicates vendors with seven or more outstanding invoices 22 Does not explain how the duplicates can be found in the Trans table 22 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas 10 Total 100%Step 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