Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Accounting questions

Question

What is the difference between a perpetuity and an annuity?

Answered: 1 week ago

Question

What are the degrees of freedom associated with ????e.

Answered: 1 week ago

Question

Define Administration?

Answered: 1 week ago

Question

Define Decision making

Answered: 1 week ago

Question

What are the major social responsibilities of business managers ?

Answered: 1 week ago