1 / 22

Florida Audit Forum

Florida Audit Forum. Brent Godshalk Assistant City Auditor City of Gainesville, Florida. User Survey. Participant Usage of Audit Software? ACL, IDEA, Access, Excel, Monarch, Others Extent of Usage Data Extraction and Analysis Statistical Sampling Fraud Detection Continuous Monitoring

paprika
Download Presentation

Florida Audit Forum

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Florida Audit Forum Brent Godshalk Assistant City Auditor City of Gainesville, Florida Computer Assisted Audit Techniques

  2. User Survey • Participant Usage of Audit Software? • ACL, IDEA, Access, Excel, Monarch, Others • Extent of Usage • Data Extraction and Analysis • Statistical Sampling • Fraud Detection • Continuous Monitoring • August 2001 IIA Survey • ACL usage 13/1 over IDEA usage Computer Assisted Audit Techniques

  3. Gainesville’s History With Computerized Audit Software • Small Shop with Limited Resources • Began Evaluating Mainframe-Based CAAT’s in mid-1980’s • EasyTrieve, PanAudit, etc. • Purchased PC-Based IDEA software in 1988 from CICA/AICPA • Immediately found uses for software, but training and support were limited • Accessing data was difficult Computer Assisted Audit Techniques

  4. Gainesville’s HistoryWith IDEA • Marketing and Training for IDEA improved in mid-1990’s • Audimation Services, Inc. • Window’s Version of IDEA released – improved functionality and ease of use • Window’s version 2.0 in 1999 added print report extraction capability • Training Offered Computer Assisted Audit Techniques

  5. IDEA’s RecentBusiness History • IDEA Software Sold to Private Company by CICA 2 years ago • Caseware International, Inc. appears to be moving to try to compete with ACL • Benford’s Law analysis to be added to IDEA this year • ACL versus IDEA Computer Assisted Audit Techniques

  6. IDEA Functionality • Importing and Exporting Files • Numerous file formats supported, print reports • Extracting Records – exception testing • Duplicate and gap detection • Statistical Sampling • sample planning and results analysis • random, stratified, monetary, systematic Computer Assisted Audit Techniques

  7. Importing Print Files – Selecting File Computer Assisted Audit Techniques

  8. Importing Print Files – Creating a Mask Computer Assisted Audit Techniques

  9. Importing Print Files – Opening Saved Mask Computer Assisted Audit Techniques

  10. IDEA Import Assistant Demo – Masked View Computer Assisted Audit Techniques

  11. Importing Print Files – Importing Data Computer Assisted Audit Techniques

  12. Importing Print Files – Resulting Data File Computer Assisted Audit Techniques

  13. Summarizing Data Computer Assisted Audit Techniques

  14. Extracting Exceptions – Regular Hours > 80 Computer Assisted Audit Techniques

  15. IDEA’s Equation Editor Computer Assisted Audit Techniques

  16. Sorted Exceptions to Evaluate Computer Assisted Audit Techniques

  17. Duplicate Detection – Direct Deposit Accounts Computer Assisted Audit Techniques

  18. Joining Databases – Salary Comparisons Computer Assisted Audit Techniques

  19. Gainesville’s Usage of IDEA • Payroll Processing Reviews • Disbursements/Purchasing • Utility Billing and Receipting • Work Order Completion • County Traffic Fine Collections • Overtime Reviews Computer Assisted Audit Techniques

  20. Summary • IDEA has been a powerful and productive tool for the Gainesville City Auditor’s Office • With tools like this, auditors are only limited by our creativity • Acquiring and using the tools available is a great way to improve audit coverage, productivity and effectiveness Computer Assisted Audit Techniques

  21. Where to Get More Information • IDEA website - www.audimation.com/ • ACL website - www.acl.com/en/ • Monarch website - www.datawatch.com/ Computer Assisted Audit Techniques

  22. Questions and Comments Computer Assisted Audit Techniques

More Related