April 22, 2008 by Mike.Blakley.

Version 1.56 includes faster sorting speeds for files of up to 2 billion rows with sorting by up to 200 columns. Also included is the ability to run XL Audit Commander using either Excel macros or through the Windows Scripting Host. A paper on the topic is available which describes the process. An Excel macro workbook named Macros.xls is included with the installation software. Note that version 1.56 is required in order to run these macros or scripts. The setup program (11.9 MB) is available for download.

Hope to see you at the IIA Fraud Forum in Bonita Springs, FL on May 16th. Topic is the use of digital analysis for the detection of fraud patterns.

Posted in Data Extraction, Data Classification, Audit Software | 2 Comments »

February 23, 2008 by Mike.Blakley.

Support is now provided for both comma separated value format files (CSV), as well as “print” files through the use of file specifications. Further information is available. Also, there are now a variety of tutorials available in shockwave format to demonstrate the system in action. Information about system limitations is now available.

Posted in Data Extraction, Error identification, Audit sampling, Data Classification, Audit Software, Data Validation and conversion, Data Validation | No Comments »

November 27, 2007 by Mike.Blakley.

The latest version, released 11/24/2007, includes support for CSV files and “print” files and also includes a “help” button on the forms screen. Further, there are several  examples demonstrating its use: 1) interval sampling, 2) testing Benford’s law in MS-Access database, 3) Data Stratification and 4) Date checking. Other examples and articles have been added.

A demo of the system is available for viewing.

Posted in Data Extraction, Audit sampling, Data Classification, Audit Software | No Comments »

October 28, 2007 by Mike.Blakley.

Updates

Version 1.34 adds chart results for certain of the audit commands, such as population statistics, weekday analysis, Benford’s Law, etc. These charts are produced in industry standard GIF format and may optionally be saved or stored on the computer for inclusion in reports or used as the basis for editing.

Version 1.34 also includes two additional audit commands used for running a series of command language statements at once. This facilitates performing a series of analytical procedures in a documented and standard manner. The new audit command is called “bc” for batch command, and executes a series of commands on consecutive rows in a worksheet. There are examples provided in the QuickStart workbook at http://ezrstats.com/online/inno/QS.xls.

Version 1.36 adds three commands: query, graphics and trendline. The purpose of the query command is to import data from databases to a worksheet for further analysis. The trendline command is used to chart a series of points. Also, in version 1.36, the charts have been made a little larger, along with the option to specify a title, using the title= parameter. The graphics command is used to set the color theme of the charts displayed

Software is an Excel addin, which is available for free download.

Posted in Data Extraction, Audit sampling, Audit Software | No Comments »

October 5, 2007 by Mike.Blakley.

The latest version has been upgraded to include the ability to obtain cross-tabulations, test for round numbers, do data extractions and perform calculations. Several mini “Audit Guides” have been released - including “Round Numbers” , “Holiday Date testing“, and “Data Stratification“. There is no charge for the software which can be downloaded and installed using a standard setup.exe. An Operation Guide is available with details, as well as online help.

Posted in Data Extraction, Audit Software | No Comments »

September 7, 2007 by Mike.Blakley.

Several users have pointed out that the Chi Square statistics obtained using Benford’s law differ from that obtained using the chi square command alone - this has been corrected, details are available. I have also had several requests to “streamline” the entry of commands and provide a logging facility in order to maintain an audit trail of the commands processed. These features have been included in version 1.22 which can be downloaded. Details on the upgrade can be viewed. As always, I welcome all comments, suggestions and ideas for making this a more useful tool.

Posted in Audit sampling, Audit Software | No Comments »

September 2, 2007 by Mike.Blakley.

Today I have posted three “how to” articles which describe tools and techniques for automating audits such as fixed assets, procurement fraud and insurance claims. The articles have accompanying data which can be downloaded.

There is also a new version of software for the desktop, compatible with Excel, which is available at no cost. I welcome any suggestions for additional commands to implement (they should be of general interest, please).

Posted in Audit Software | No Comments »

June 29, 2007 by Mike.Blakley.

I have established a web page devoted to sharing articles and ideas on IT auditing. Part of it consists of tutorial modules as shown below. Some are VBA classes for use within Excel, others pertain to use of the XL Audit Commander.

Posted in Data Extraction, Data Classification, Audit Software, Data Validation | No Comments »

June 3, 2007 by Mike.Blakley.

XL Audit Commander provides a variety of audit tools which can be run from within Excel, all at no cost. An operation guide explains the commands available and the procedures to perform them.The software uses a very minimal portion of your spreadsheet area and can easily be invoked only when needed by pressing Control-E. Download the software to try. Also included is the capability to perform a variety of data extracts for audit tests, and examples are included in a sample workbook for download.

These include such tests as searching for close matches on names, data extraction using conditions, etc. More details.

Posted in Audit Software | No Comments »

April 8, 2007 by Mike.Blakley.

Excel is among the most common platforms for analysis by auditors, analysts and researchers. I have established a beta site for development/testing of various types of data extracts using PHP. In order to use this, upload your Excel data to the server and then code and test the PHP script to perform the analysis. Results are returned in a format that can then be pasted back into Excel. Examples and help screens are provided.

Posted in Data Extraction, Audit Software, Validation | No Comments »