ScholarMatic | 24/7 Homework Help

ScholarMatic Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Audting ACL Verion 9

by | Nov 30, 2023 | questions

This question would need ACL software an I do have the ACL files which are currently on my Uni Login ID.Please note that its Version 9 only that needs to be used. Thanks

Document Preview:

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…

Attachments:


ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99


  

Click Order Now to get 100% Original Answer Customized to your instructions!

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

ScholarMatic: Get Started

Assignment Writing Service

Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!