eBook: Top Audit Tests Using ActiveData for Excel

Need to get measurable results for your organization and get the most from your ActiveData for Excel investment?

Want to learn how to practically apply ActiveData for Excel to top audit areas with a minimal learning curve?

Then take a look at Top Audit Tests Using ActiveData for Excel. It walks you through popular audit tests in the most popular audit areas: Accounts Payable, Accounts Receivable and General Ledger

The guide provides sample data to test your skills prior to using "live" company data.

It is a manual is to assist auditors, fraud examiners, and management in implementing data analysis routines using ActiveData for Excel.

Use these techniques to proactively detect organizational inefficiency, ineffectiveness, fraud and provide measurable cash recoveries.

The book provides guidance as to which of the ActiveData for Excel's features can be used in an audit setting.

It walks you through 16 common audit tests within the accounts payable, accounts receivable and general ledger audit areas.

Armed with this document, users can no longer say that audit software is difficult to use. For now, even a tool as simple as a spreadsheet can and should be used as an audit software. With the “curtain exposed” users can now focus their time on the more critical activities of creatively dreaming up new tests and improving their business intelligence.

Select below to download a PDF sample chapter of Top Audit Tests Using ActiveData for Excel


The sample contains the table of contents, describes why to Audit Accounts Payable and shows one of the 16 tests that are in the full book.

Self Study Course - Auditing, Fraud Detection and Cash Recovery using ActiveData

The purpose of this course is to assist auditors, fraud examiners, and management in implementing audit data analysis routines, and fraud detection and cash recovery techniques using ActiveData For Microsoft Excel.

For accountants and auditors, Microsoft Excel provides a comfortable environment to work within and for many data analysis tasks, Excel can easily do the job. However when more complex data analysis and manipulation is needed, as is the case with fraud detection and cash recovery, more complex tools and techniques are needed. This is where the combination of Excel and ActiveData creates dramatic results.

This course will:

  • Introduce you to the powerful combination of ActiveData and Excel
  • Walk you through basic audit, fraud detection and cash recovery reporting concepts
  • Map out each step for the most common of fraud detection, cash recovery and audit tests
  • Equip you with sample data, providing a glimpse of the resulting report prior to the (crunch time) situation
  • Suggest audit procedures and fraud detection to perform on the resulting reports

This course will give you all the information you need to produce fraud detection, cash recovery and audit reports immediately for the most common accounting areas: accounts payable, accounts receivable, and the general ledger. To help practice the concepts, sample data are also provided, giving you an immediate "hands on" experience

Please note that these materials require Adobe PDF Reader Version 6 or better and ActiveData Professional Edition Version 5.0 or later.

To determine your version of the Adobe PDF Reader, select Help -> About from your reader. To get the latest version of the free reader, click on the button at right.

To determine your version of ActiveData, use ActiveData -> Help -> About.

Some of our users include:

Free Utility: QB2Excel

QuickBooks to Excel Converter

Free Utility: Text Analytics

ActiveData Text Analytics