audit software a review of audit programs for your practice and your client operations l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
AUDIT SOFTWARE: A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS PowerPoint Presentation
Download Presentation
AUDIT SOFTWARE: A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS

Loading in 2 Seconds...

play fullscreen
1 / 29

AUDIT SOFTWARE: A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS - PowerPoint PPT Presentation


  • 204 Views
  • Uploaded on

AUDIT SOFTWARE: A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS . 2002 NEW YORK CPA, BUSINESS & TECHNOLOGY SHOW AND CONFERENCE AUGUST 7, 2002 Joel Lanz, Principal JOEL LANZ, CPA, P.C. AGENDA. Introduction & Overview Types of Audit Software Evaluating Software

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

AUDIT SOFTWARE: A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript
    1. AUDIT SOFTWARE:A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS 2002 NEW YORK CPA, BUSINESS & TECHNOLOGY SHOW AND CONFERENCE AUGUST 7, 2002 Joel Lanz, Principal JOEL LANZ, CPA, P.C.

    2. AGENDA • Introduction & Overview • Types of Audit Software • Evaluating Software • Recent IIA Survey • Questions and Answers • Conclusion

    3. INTRODUCTION AND OVERVIEW

    4. JOEL’S PARADIGM • Over 20 years of IT risk management experience • Practicing CPA with prior experience as a Big 5 Partner and an Internal Audit Vice President • Graduate school adjunct faculty member • CISA, CISSP, CFE, CITP • Publications • Member, NYSSCPA Technology Assurance Committee

    5. BENEFITS OF USING AUDIT SOFTWARE • Enhanced data analysis • Increased coverage • Better use of resources • Improved results • Reduced costs • More time for thinking (e.g. value add)

    6. PERCEIVED CHALLENGES TO ACHIEVING THE BENEFITS • Too costly to purchase and maintain • Too technical and complex • Only for use by IT Auditors or Programmers • Hands-on approach to auditing • Client systems and data compromised

    7. WHAT’S THE REAL CHALLENGE ? GETTING TO THE DATA

    8. TODAY’S OBJECTIVE

    9. TYPES OF AUDIT SOFTWARE

    10. GENERAL • Word Processing • Text Search and Retrieval • Spreadsheets • Presentation Software • Flowcharting Software • Utilities

    11. SAMPLE PRODUCTS • Excel • Access • Visio • Powerpoint • Crystal Reports • Monarch • SQL

    12. SPECIALIZED AUDIT APPLICATIONS • Data Access, Analysis, Testing & Reporting • Standardized Extractions and Reports • Electronic Questionnaires and Audit Programs • Control Self Assessment • Parallel Simulation • Data Warehouse • Data Mining

    13. SAMPLE PRODUCTS • ACL • IDEA • Magnum • CSA Pro • Audit Leverage • AppScan

    14. AUDIT MANAGEMENT AND ADMINISTRATION • Audit Risk Assessment • Electronic Document Management • Audit Scheduling, Time Reporting & Billing • Project Management • Audit early warning Systems

    15. SAMPLE PRODUCTS • AutoAudit • ADM Plus • Pentana • TeamMate

    16. NETWORK TESTING TOOLS • File Integrity Checkers • Network Sniffers • Password Crackers • Privilege Escalation and Back Door Tools • Scanning and Enumeration Tools • Vulnerability Scanning Tools • War Dialing Tools

    17. SAMPLE PRODUCTS • Tripwire • Snort • John the Ripper • Getadmin • NMap • ISS • Nessus • Telesweep

    18. EVALUATING SOFTWARE

    19. GENERAL CAPABILITIES • Does the software meet a specific identified requirement? • Is the software compatible with current hardware, systems and data? • What is the quality of documentation and other user support features? • What is the total cost of ownership?

    20. REPORTING AND GRAPHICS CAPABILITIES • Does the software support user-defined reporting capabilities? • Can report definitions be modified and saved? • Can ad hoc be easily created? • Does the software support a variety of presentation styles?

    21. FILE MANIPULATION AND TYPE CAPABILITIES • Can you sort on more than one key field? • Does the software support filtering? • Can you extract records to create a new file? • Can you work with more than one file (e.g., merge)? • Can the software read variable length records?

    22. VENDOR SUPOPRT • Are technical staff available and cost-effective? • Does the vendor provide training and consulting services? • Are regular software updates distributed? • Does a solid company stand behind the software?

    23. RECENT IIA SURVEY

    24. 2002 AUDIT SOFTWARE USAGE SURVEY • IIA annual poll • Published in the August 2002 edition of “Internal Auditor” • 2706 internal auditors surveyed of which 610 responded • Results need to be considered in light of the fact that sample sizes varied across products.

    25. PRODUCTS USED ACL 24% OTHER 24% EXCEL 14% ACCESS 9% IDEA 9% AS/400 QUERY 7% OVERALL SATISFACTION IDEA 4.5 ACL 4.0 ACCESS 3.5 EXCEL 3.0 DATA EXTRACTION

    26. PRODUCTS USED EXCEL 43% ACL 24% IDEA 10% ACCESS 10% OTHER 7% AS/400 QUERY 2% OVERALL SATISFACTION IDEA 4.4 ACL 4.1 ACCESS 3.4 EXCEL 3.3 DATA ANALYSIS

    27. OTHER SURVEYED AREAS • Fraud Detection/Prevention • E-Commerce Control • Network Security Assessment • Automated Workpapers • Continuous Monitoring • Audit Management/Risk Analysis • CSA Software

    28. WHERE’S THE RISK?

    29. IN CASE YOU’RE IN A RUSH TO LEAVE AND HAVE A QUESTION Joel Lanz Principal Joel Lanz, CPA, P.C. P.O. Box 597 Jericho, NY 11753-0597 (516) 637-7288 www.systemscpa.com jlanz@itriskmgt.com