ACL project

a)

Number of payroll transactions =

b)

Largest: $ Smallest: $

c)

$

d)

Number of different pay periods:

e)

Number of exceptions:

f)

Number of gaps:

If you were to identify gap in the sequence, what would be your concern?

a)

Total amount of invoices generated during the year =

_______ invoice has a negative value

b)

Total amount of invoices still outstanding = $

c)

a)

The total of the Amount column for all Pcard purchases is $

b)

Number of Pcard transactions that are >$1,000 each:

c)

Vendor Name Count Amount

d)

How many transactions are exceeded $1,000?

e)

How many transactions are between $990.00 and $999.99?

a)

Total amount of all purchases = $

b)

The stratum accounts for the greatest number of purchases is

c)

Number of duplicate in purchase order number:

Number of gaps:

Number of missing purchase order numbers:

Possible explanation:

d)

_____________ purchase orders do not have a requisition number.

The total dollar amount of purchases made without a requisition = $

Concerns:

e)

_________ vendor accounts for more than 5% of total purchases.

a)

Number of outstanding invoices =

Total dollar amount of the outstanding invoices = $

b)

Total outstanding amount is

The customer number _______________has the largest balance due.

c)

The smallest account balance outstanding = $

The largest account balance outstanding = $

d)

_________invoices are more than 90 days outstanding.

How will the auditors use the aging information in the audit of accounts receivable?

e)

Join the sales_order, invoice and shipment then create a three-way-match form. What’s the total sales order amount of 2014?

f)

Analyze the data of account receivable outstanding and identify any suspicious outstanding receivables using Benford’s Law.

Present your chart comparing Expect% and Actual% below