Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Lab 1-3 Part 1 Identify the Questions Your audit team has been tasked with identifying potential internal control weaknesses within the ordertocash process. You have

image text in transcribed
Lab 1-3 Part 1 Identify the Questions Your audit team has been tasked with identifying potential internal control weaknesses within the ordertocash process. You have been asked to consider what the risk of internal control weakness might look like and how the data might help identify it. Lab 1-3 Part 1 Analysis Questions AQi. Use what you know about internal controls over the ordertocash process (or search the web if you need a refresher} to identify three different questions that might indicate internal control weakness. For example= if you suspect that a manager may be delaying approval of shipments sent to customers, your question might be \"Are any shipping managers approving shipments more than 2 days after they are received?" AQ2. Next to each question generate a hypothetical answer to help you identify what your expected output would be. You may use some insight or intuition or search the Internet for ideas on how to inform your hypothesis. For example: "Hypothesis: Only one or two shipping managers are approving shipments more than 2 days after they are received." AQ3. Finally, identify the data that you would need to answer each of your questions. For example, to determine the timing of approval and who is involved. you might need the approver ID: the order date. and the approval date. Lab 1-3 Part 2 Master the Data To answer your questions, you'll need to evaluate the data that are available. As a starting point, you should look at attributes listed in the AICPA's audit data standards. The AICPA set these standards to map common data elements that should be accessible in any modern enterprise system and make it possible for auditors to create a common set of analytic models and tools. To access the audit data standards, complete the following steps: 1. Open your web browser and search for \"Audit data standards order to cash." Follow the link to the \"Audit Data Standards Library1551CPA,"= then look for the \"Audit Data StandardOrder to Cash Subledger Standard\" PDF document. 2. Quickly scroll through the document and evaluate the tables [e.g., Sales_Orders_YYYYMMDD_YYYYMMDD), field names [e.g., Sales_0rder_ID), and descriptions (e.g., \"Unique identier for each sales order\"). 3. As you skim the tables, make note of any data elements you identified in Part 1 that don't appear in the list of elds in the audit data standard. Lab 1-3 Part 2 Analysis Questions AQi, List some of the tables and elds from the audit data standard that relate to each question you identified in Part 1. For example. if youire looking for the shipment timing and approval data, you would need the Shipments_Made_YYYimiMDD_YYYYMMDD table and Approved_By, Entered_Date. and Approved_Date elds. AQ2. Are there data values you identied in Part 1 that don't exist in the tables? Explain how you might collect the missing data or where you might locate them

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

Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

27th edition

978-1337272094, 1337272094, 978-1337514071, 1337514071, 978-1337899451

Students also viewed these Accounting questions