ACC3118/5218 Auditing/Auditing Practice
ACL Case Study Assignment S2 2013
REQUIREMENTS
You are a member of a team involved in the audit of accounts payable for ABC Distribution Company. A computer-based accounts payable system is used by the company. You are provided with three data files (access using ACL105 Foundations project):
VENDOR Vendor Master File as at 31 December 2000.
AP_TRANS Vendor Transaction File for the year 2000.
You are to produce an audit memorandum to the partner-in-charge dealing with each of the following issues. You should support your findings with appropriately labelled and totalled reports generated with the ACL package.
You are to submit your audit memorandum in a Word document
You are to submit your findings for each of the objectives in htm files (no other format will be accepted. Do not attempt to embed your htm files in the Word document).
Report headers should identify the client, the year-end, your name and the title of the report. Present your reports and extracts from logs in the appendices accompanying your memorandum.
Audit Objectives
Produce a vendor invoice report showing the vendor number, vendor name, invoice number, invoice date and invoice amount for each accounts payable transaction. Sort this report by invoice number within vendor and subtotal this report by vendor.
Produce a report showing the details of vendors with no transactions.
Produce a report showing any duplicate vendor records. Also, search for duplicate transactions, e.g. with the same vendor number, date, amount, product, etc.
Prepare a vendor purchases summary, showing the percentage for each vendor (in descending order) of total purchases. Which vendors are the top 4?
Stratify invoice amounts. Identify the larger transactions.
Discuss the relevance of objectives 1-6 to detecting accounts payable fraud.
Input Files
According to the client’s system documentation, the vendor master file (VENDOR) and…





