Technology tools like IDEA can

also be used to help audit teams identify items with potentially

higher risks within an entire population of items in an efficient and effective manner.

With this in

mind, complete the following steps.

a.

The SalesOrder database was used to produce a Tableau

visualization of

three

-

way match in

the revenue cycle as described in the previous requirement.

Using IDEA, verify the accuracy of

the SalesOrder database by creating a

three

-

way match on your own using the SalesOrder,

Shipments, and CustomerInvoices datab

ases.

Are your conclusions the same?

If so, how does

this increase your assurance about the accuracy of the SalesOrder database?

If not, why not?

Did you identify any specific transaction that you believe should be considered higher risk for

the audit?

b.

Ana

lyze the sales revenue file using IDEA to determine whether any sales were made to

distributors without an established credit limit. Are there any exceptions? If there are

exceptions, what further testing would you perform on these exceptions?

c.

Analyze the

accounts receivable and related credit authorization limits using IDEA to determine

whether any customers have account balances as of 12/31/17 that exceed their existing credit

limit.

Are there any exceptions to the credit limit control as of 12/31/17?

Do

you notice any

pattern

in the exceptions? What further testing would you perform on these exceptions?