Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lab 13 Data Analytics in Auditing The purpose of this lab is to help you identify relevant questions that may be answered using data analytics

image text in transcribed
image text in transcribed
Lab 13 Data Analytics in Auditing The purpose of this lab is to help you identify relevant questions that may be answered using data analytics in auditing. Let's evaluate how we might use master and transaction data from an enterprise resource planning system to perform some simple data analytics to assist the nancial statement audit. Company Summary ABC Company is a large retailer that collects its order-to-cash data 'm a large ERP system that was recently updated to comply with the AICPA's audit data standards. ABC Company currently collects all relevant data in the ERP system and digitizes any contracts= orders= or receipts that are completed on paper. The credit department reviews customers who request credit. Sales orders are approved by managers before being sent to the warehouse for preparation and shipment. lCash receipts are collected by a cashier and applied to a customer's outstanding balance by an accounts receivable clerk. You have been assigned to the audit team that will perform the internal controls audit of ABC Company. Technique Familiarity with database structure and primary-foreign key relationships may be helpful. Software needed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Law, Business And Society

Authors: Tony McAdams, Kiren Dosanjh Zucker, Kristofer Neslund, Kari Smoker

12th Edition

1259721884, 978-1259721885

More Books

Students also viewed these Accounting questions

Question

6. What information processes operate in communication situations?

Answered: 1 week ago

Question

3. How can we use information and communication to generate trust?

Answered: 1 week ago