Audit software a review of audit programs for your practice and your client operations
Download
1 / 29

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


  • 189 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

PowerPoint Slideshow about 'AUDIT SOFTWARE: A REVIEW OF AUDIT PROGRAMS FOR YOUR PRACTICE AND YOUR CLIENT OPERATIONS' - daniel_millan


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
Audit software a review of audit programs for your practice and your client operations l.jpg

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 l.jpg
AGENDA

  • Introduction & Overview

  • Types of Audit Software

  • Evaluating Software

  • Recent IIA Survey

  • Questions and Answers

  • Conclusion



Joel s paradigm l.jpg
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


Benefits of using audit software l.jpg
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)


Perceived challenges to achieving the benefits l.jpg
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


What s the real challenge l.jpg
WHAT’S THE REAL CHALLENGE ?

GETTING TO THE DATA




General l.jpg
GENERAL

  • Word Processing

  • Text Search and Retrieval

  • Spreadsheets

  • Presentation Software

  • Flowcharting Software

  • Utilities


Sample products l.jpg
SAMPLE PRODUCTS

  • Excel

  • Access

  • Visio

  • Powerpoint

  • Crystal Reports

  • Monarch

  • SQL


Specialized audit applications l.jpg
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


Sample products13 l.jpg
SAMPLE PRODUCTS

  • ACL

  • IDEA

  • Magnum

  • CSA Pro

  • Audit Leverage

  • AppScan


Audit management and administration l.jpg
AUDIT MANAGEMENT AND ADMINISTRATION

  • Audit Risk Assessment

  • Electronic Document Management

  • Audit Scheduling, Time Reporting & Billing

  • Project Management

  • Audit early warning Systems


Sample products15 l.jpg
SAMPLE PRODUCTS

  • AutoAudit

  • ADM Plus

  • Pentana

  • TeamMate


Network testing tools l.jpg
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


Sample products17 l.jpg
SAMPLE PRODUCTS

  • Tripwire

  • Snort

  • John the Ripper

  • Getadmin

  • NMap

  • ISS

  • Nessus

  • Telesweep



General capabilities l.jpg
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?


Reporting and graphics capabilities l.jpg
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?


File manipulation and type capabilities l.jpg
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?


Vendor supoprt l.jpg
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?



2002 audit software usage survey l.jpg
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.


Data extraction l.jpg

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


Data analysis l.jpg

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


Other surveyed areas l.jpg
OTHER SURVEYED AREAS

  • Fraud Detection/Prevention

  • E-Commerce Control

  • Network Security Assessment

  • Automated Workpapers

  • Continuous Monitoring

  • Audit Management/Risk Analysis

  • CSA Software



In case you re in a rush to leave and have a question l.jpg
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