Audit Software

The Audit Commander software is currently in "alpha" release and as such is a "work in progress". Some testing has been performed on both the Windows XP and Vista platforms using Excel, Access, SQLite and text files (comma separated and tab separated values). The software is free software (open source- (license) and is not intentionally "crippled". The software will remain free software (although training and support will not be free). Plans call for full "beta" testing starting in January, 2009. All comments, suggestions and recommendations are welcome.

The software has almost all of the functionality of the XL Audit Commander. It is designed for use with both Microsoft Access and Excel, as well as make use of other free software such as the "R" statistical system and SQLite.

Much of the statistical computation done by the system is through the use of the "R" system which is also open source software. The "R" system is used to develop plots and charts, as well as perform various statistical functions such as linear regression. An example document which illustrates this software shows various charts developed with "R". Although "R" runs on both Vista and XP, there are some limitations apparently imposed by Vista® (32 MB memory limitation) and thus not all "R" functionality is available under Vista®.

There is an alpha version of the software available for evaluation and testing. A registration form must be completed in order to obtain a copy. This registration form also provides access to the hand-out materials at the joint IIA/ISACA meeting held in Raleigh, NC on November 11, 2008.

I welcome all comments, questions and suggestions. I can be reached at 919-219-1622 on Fridays 8:00 a.m. to 5:00 p.m. EST and by e-mail at Mike.Blakley@ezrstats.com.

 
Audit Commander System - Documents / Screen Shots
Description Approx Size Type
Last Update
Main Menu
4.1 MB
PDF
11-2008
System Configuration
< 100K
PDF
11-2008
System Report Examples
< 100K
PDF
10-2008
Cost Recovery
Identifying "Suspicious" invoices in Excel
< 100K
PDF
11-2008
Identifying "Suspicious" invoices in Access
< 100K
PDF
11-2008
Example Reports
< 100K
PDF
11-2008
Audit Tests
Testing data in Excel format
110 K
PDF
10-2008
Testing data in Access databases
< 100K
PDF
10-2008
Testing data in Text File format
< 100K
PDF
10-2008
Ageing Data in MS Access
< 100K
PDF
10-2008
Ageing Data in Excel worksheets
< 100K
PDF
10-2008
Top N Data in Excel worksheets
< 100K
PDF
10-2008
Top N Data in Access databases
< 100K
PDF
10-2008
Data Extraction
Data extraction - Excel files
< 100K
PDF
10-2008
Data extraction - Access databases
< 100K
PDF
10-2008
Data extraction - SQLite databases
< 100K
PDF
10-2008
Data extraction - text files
< 100K
PDF
10-2008
Data extraction and computation- Excel files
< 100K
PDF
11-2008
Specifying extraction criteria
< 100K
PDF
11-2008
Fraud / Error Detection
Pattern detection with SQLite
< 100K
PDF
10-2008
Pattern detection with MS Access
< 100K
PDF
10-2008
Plotting data in Excel
< 100K
PDF
10-2008
Reports relating to Benford's Law
< 100K
PDF
10-2008
Extracting rows with holiday dates from Excel (US and Canada only)
< 100K
PDF
11-2008
Access - Identifying Duplicates, Summarization and "Same, Same, Different"
< 100K
PDF
11-2008
Excel - Identifying Duplicates, Summarization and "Same, Same, Different"
< 100K
PDF
11-2008
Extracting rows with holiday dates from Access (US and Canada only)
< 100K
PDF
11-2008
Analytical Review Procedures
Linear Regression - Data in Excel
< 100K
PDF
10-2008
Linear Regression - Data in Access
< 100K
PDF
10-2008
Linear Regression - data in text files
< 100K
PDF
10-2008
Stepwise Linear Regression
110 K
PDF
10-2008
Other Databases
Audit tests on data in MySQL
< 100K
PDF
10-2008
Testing data in SQLite databases
< 100K
PDF
10-2008
Audit Commander System - Flash Demonstrations
Description Approx Size Type
Feedback
Five Minute System Overview
5 minutes
Flash
Linear Regression
9 minutes
Flash

Excel special commands

13 minutes
Flash
Data extract and calculation
5 minutes
Flash
Audit Commander System - Software
License
2K
Text
10-2008
Obtain software (free, but requires registration)
32 MB
Setup EXE
11-2008


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.

Web Page last updated on 11-20-2008
© EZ-R Stats, LLC 2005-2008
 

© EZ_R Stats

Visit EZ_R Stats on the web at:

www.ezrstats.com