Loyola Marymount University ACCT 6170 KPMG Case Requirements 1)Based on the tests of controls and other Information Technology General Controls (ITGC) testing, your firm has concluded that the data files supplied to you for your procedures are complete and accurate

Subject:AccountingPrice:3.01 Bought3

Share With

Loyola Marymount University

ACCT 6170

KPMG Case Requirements

1)Based on the tests of controls and other Information Technology General Controls (ITGC) testing, your firm has concluded that the data files supplied to you for your procedures are complete and accurate. The conclusion was based on tests of controls over data input risks, including all relevant data elements (e.g., invoice date), data integrity risks, and the relevant automated application controls. However, it is also important to confirm that the data, once imported into IDEA or Tableau, was transferred into the technology tool in a complete and accurate manner prior to working with the data within the technology tool. Import all supplied data into IDEA/Excel and then reconcile the data with the supplied trial balance and check figures from the case. Simply stated, you must check that the data has been transferred in a complete and accurate manner at each step in the process. Thus, to ensure that you are working with the set of transactions and balances that the client used to calculate Sales Revenue and Accounts Receivable, answer the following questions:

 

1. 1. What are the total number of valid sales that comprise the $84,867,855 sales revenue shown on the trial balance as of 12/31/2017?
   2. What are the total number of unpaid invoices that comprise the $11,988,886 gross accounts receivable balance shown on the trial balance as of 12/31/2017?

 

ANS: Assume that Urgent has no outstanding accounts receivable from 2016.

 

2.                Data visualization tools such as Tableau can be used to help audit teams identify items or specific areas of higher risk within an entire population. Your data and analytics center has provided you with a set of

Tableau visualizations to consider during your substantive testing procedures:

1. Three-way match of SalesOrderID, InvoiceID, and ShipID based solely on SalesOrders database

2. Sales by territory

3. Sales by distributor

4. Sales by quarter

5. Sales by territory by quarter

6. Product sales by territory

7. Fourth quarter sales by territory

8. Sales vs. sales goals for fourth quarter by territory

9. Sales by quarter by territory vs fourth quarter sales goals

1. 3. Using the data visualizations provided in Tableau, compose a memo to be included in the audit documentation file that identifies any pattern in the data that you believe may be indicative of specific audit risks. In your memo, be sure to link the identified risks to the appropriate significant account and relevant assertions.

1. 4. Based on the analysis completed above, what further testing, if any, needs to be performed over the identified risks and the remaining population? Stated differently, do any further tests need to be performed or does the three-way match visualization, combined with your tests of controls and additional visualizations, provide you with sufficient appropriate evidence to conclude about the occurrence of revenue at Urgent?