Downloads
Home Page | Tutorials | Contact

These commonly used analytical functions provide population statistics, frequency distributions, histograms, Benford's Law analysis, highlighting data outliers, gap identification, selecting random samples, searching for “same same same” patterns (duplicate payments), and other analytical procedures. Because this processing can be done unattended overnight, it is feasible to analyze large files containing millions of records, even on a PC platform. Benford's Law analysis is included as part of all three products. It is a powerful tool for both error and fraud detection. View further details regarding Benford's Law.

 The product installers allow you to install the product in any directory. The installers also make any registry settings required. The installation also includes the un-install option in order that the product may be easily removed, if so desired at a later time. Product documentation is available in PDF format, or as a compiled HTML help file.Use Excel for auditing and analysis ? Why not try our Analytic software for the the most common functions - Benford's Law, outliers, univariate statistics, CMA sampling, interval sampling, sample size calculation, stratification, classification, holiday date checking, duplicates, gaps, analytic review, trend analysis, credit card validation (luhn-10) etc. This desktop version operates from within Excel (an add-in). Want to learn more? Visit the Analytics home page (or click the link to the Operation Guide below for screen shots).

Description Approx Size Type
Date
Installation Guide
.8 MB
11 - 2007
Installation tutorial  
1 - 2008
Setup Program
11.9 MB
Setup exe
4-22-2008
Operation Guide (included with setup)
4.3 MB
4-22-2008
Example macros used with XL Audit Commander
.6 MB
4-20-2008
Example workbooks and datafile used with XL Audit Commander tutorials
.3 MB
7-21-2008
Help File
2.4 MB
Compiled HTML
11 - 2007
White papers
Link Description Type
Data Integrity testing Data Conversion / Data Integrity testing
Data conversion codes Example conversion codes and values
HTML
SQLite Auditors' Guide to the use of SQLite
File Format Converting data to the tab separated values (tsv) format
Benford's Law Auditors Guide to the Use of Benford's Law
Duplicate Payments Auditors Guide to Duplicate Payments
Internal Audit Software Presentation to the Office of Internal Audit
Sorting, Merging Detection of duplicates, preparation of sub-totals
Analysis Procedures Commonly required data analysis procedures for auditors
Link IIA Fraud Forum - Detection of Fraud Patterns using digital analysis Type
Narration - Part 1 (25 MB) Overview - (part 1) (requires high speed connection)
Narration - Part 2 (15 MB) Statistical Basis - (part 2) (requires high speed connection)
Narration - Part 3 (40 MB) Auditor's "Top 10" - (part 3) (requires high speed connection)
Narration - Part 4 (11 MB) Excel and Continuous Fraud Pattern Detection - (part 4) (requires high speed connection)
Fraud Pattern Detection Detection of fraud patterns using a statistical approach
Presentation at the IIA Fraud Forum, May 16, 2008, "Detection of Fraud Patterns using digital analysis"
Comments, suggestions and user experiences are welcomed and can posted on the audit blog. RSS feeds are available to advise of updates and new releases.

 

Links | Privacy Policy | FAQ | Trademarks

 
Complete Auditor resources
Web Page last updated on 7-25-2008
© EZ-R Stats, LLC 2005-2008