ACL Case Project

Audit Program Step

Approach

To Begin

Open a new project by choosing File, New, Project or click the New Project icon. Name the project Husky AR.

Import the following tables (files) and change the field type for CUSTNUM and INVNUM from Numeric to ASCII using Edit, Table Layout and double-clicking on the field name. This must be done so files can be joined using these fields.

HUSKY Unpaid Invoices 2013, name it Unpaid

HUSKY Shipping File 2013, name it Shipping File

HUSKY Credit Limit 2013, name it Credit Limit.

1.

Objective: Foot the file and agree to the general ledger.

With the Unpaid file as the active window, choose Analyze, Statistical, Statistics and choose to get statistics on AMOUNT.

Results: Students enter answer here

2.

Objective: Identify customer balances greater than their credit limit or for which there are no credit limits.

Summarize amounts in the Unpaid file by customer number by choosing Analyze, Summarize. Summarize on CUSTNUM and select AMOUNT for the subtotal field. Click the Output tab at the top of the window and choose “File.” Name this file Customer Balances.

Using the Customer Balances file, click the Join icon. Select the Credit Limit file as the secondary table. Click to presort the secondary table. Select CUSTNUM for the primary keys and the secondary keys. Select the primary fields CUSTNUM and AMOUNT and select the secondary fields CRLIMIT and CUSTNUM. Name the new file Balances with Credit Limits.

Using the Balances with Credit Limits file, choose DATA, Extract Data, If and enter the expression AMOUNT > CRLIMIT. Name the new file Over Limit.

Results: Students enter answer here

3.

Objective: Perform sales cutoff test.

Using the Unpaid file, click the JOIN icon. Select the Shipping File as the secondary file. Select INVNUM as the primary keys and secondary keys. Select INVNUM, INVDATE, CUSTNUM, and AMOUNT as the primary fields. Select INVNUB, SHIPNUM, and DATESHIP as the secondary fields. Name the new file Unpaid with Shipping Info.

Using the Unpaid with Shipping Info file, choose DATA, Extract Data, IF and enter the expression SHIPNUM > 62050 (The auditor has verified that this is the last shipping number used.) Name the new file Cutoff Errors.

Results: Students enter answer here

4.

Objective: Identify unpaid invoices over 45 days old.

Use the Unpaid file. Choose ANALYZE, Age, and age on INVDATE. Set the cutoff date to December 31, 2013. Choose the AMOUNT field to total. Set the Aging Periods to 0 and 45. Print the Age Analysis Report

To get a list of these 4 records, double-click on the > 45 box.

Results: Students enter answer here

5.

Objective: Stratify customer balances and describe how this information could be used to help determine which balances to confirm.

Using the Customer Balances file, choose ANALYZE, Stratify, stratify on AMOUNT. Set the minimum at 0 and maximum at 50,000.

Results: Students enter answer here