Audit Commander 1.70

Audit Commander 1.70 is a software that can be used to support a variety of audit applications. This software includes some of the most common audit techniques which can be applied.  Each technique has a brief description of the procedure that could be used. In some cases a short video tutorial is also provided. These video tutorials vary in length from about 90 seconds up to a little more that three minutes. For best results, a high speed internet connection is recommended (although not required).

The auditor should keep in mind that for many of the test objectives, there are additional approaches which can be taken. All of the topics assume that the data being audited is available in either Excel, Access or as a text file.

The software has the familiar "look and feel" of Windows and does not require specific knowledge of Access, Excel or other data source in order to use. Audit Commander software can be used to support a variety of audit applications. The software is can produce a variety of charts to help visualize the analytical results.

The audit tests can be grouped into five categories:

1. Audit tests include basic population statistics, data stratification, checks for gaps in numeric sequences, testing for federal holidays, classifying transaction dates by day of week and tests using Benford's Law.
2. Cost recovery procedures include identification of potential duplicate invoice payments.
3. Data extraction includes a comprehensive suite of functions to enable the auditor to focus on the specific data relevant for the procedure.
4. Fraud and error detection includes a variety of tests designed to hi light "outliers" as well as detect potential duplicates using either the "same, same, same" test or "same, same, different".
5. Analytic review procedures include various linear regression tests, "napkin" tests and "mini-max.
6. Databases supported include both MS-Access, SQLite and MySQL.

Major Features:

1.  Audit identification of duplicates, gaps, audit for outliers, population summaries, data classification and stratification, univariate statistics, audit sample size computations, percentiles/quartiles, Federal holiday dates, histograms and other....
2.  Testing Benfords law, cumulative monetary amount sampling for audits, interval sampling, cross tabulations, account ageing, audit summarization, day of week analysis
3.  Otaining Chi Square, audit credit card numbers (Luhn-10), round numbers, top/bottom 5,
4. Producing charts - histograms, trend lines, Pareto charts...
5. There is no license cost for the audit software. 
6.  The software can be used for any purpose, including personal, commercial and educational, without any restriction.

Enhancements: Fraud pattern detection

Requirements: 4.2B disk

WareSeeker Editor