IDEA Data Analysis

The most user-friendly and high performance audit software


Data Analysis Made Easy

IDEA® is a powerful and user-friendly data analysis tool designed to help auditors, accountants and other finance professionals perform data analysis quickly to help improve audits and identify control breakdowns.  IDEA allows you to analyze 100% of your data, guarantees data integrity and provides easy analysis with over 100 audit-relevant tasks.

Get the Complete Picture with One Click

When your data comes from different sources and in a variety of formats, data analysis can sometimes be a challenge. The use of audit specific technology allows you to import multiple data sets and view them as though they were one lets you to see the big picture. You are able to identify relationships, patterns and anomalies as well as conduct a comprehensive analysis of transactional data.

Import Data from Practically Any Source

IDEA allows you to quickly import an infinite amount of records from practically any source, including spreadsheet and database software, mid-range accounting programs, ERP systems, legacy mainframes, telecom switches, travel and expenses applications, flat and printed files such as PDFs, plain text (.txt), and print-report (.prn) files.

Simplified Analysis

Instead of programming macros, you can use over 100 audit-specific tasks that effortlessly look for duplicates, detect gaps in numeric sequences, group data by categories and filter numerous rows and columns of information in seconds. IDEA® allows you to record every analytic step and repeat for future use, via a graphical drag-and-drop interface.

Ensure Data Integrity & Communicate Your Results

With read-only access to data, IDEA will help to ensure the accuracy of audit assessments and disclosures in published financial statements. With IDEA, you can export information to a variety of formats including Microsoft® Access®, XML, Text, Microsoft® Word, PDF, Microsoft® Excel® and pre-defined reports.

Pre-built Routines. Smarter Analysis.

IDEA SmartAnalyzer is a collection of queries and tasks that can be used on every audit engagement to improve audit quality and consistency. IDEA SmartAnalyzer offers an extensive set of routines for the analysis of general ledger, accounts receivable, inventory, fixed assets and accounts payable transactions.

Easy to Use, Easy to Implement

1. Import Data




2. Select the Desired Routines









3. Review and Report Results








Get started now with these routines.

Analyse SAP Data

SAP® is an extremely efficient, potent and multi-faceted enterprise resource planning (ERP) solution. However, business process and application controls can deteriorate over time due to change in regulations, business practices or employee attrition, and as such, this ever changing landscape can present unforeseen risks. The ongoing analysis of core data systems can prevent threats and address risks at an early stage.

The extraction of SAP data is simplified allowing for easy review and analysis. SmartExporter resolves many common issues associated with transferring SAP data outside of the software’s environment such as security, data capacity and timing of data downloads. Once you configure the data request by defining the tables, fields and filters, you can save it as a favorite and reuse in the future.

Convenient Analysis

The data request is not generated in SAP®, but on your local hard-drive or enterprise server. Data requests are scheduled for immediate download or for a specific time during off-peak business hours and saved for repeat use. Output formats include IMD (IDEA), CSV, Access, TXT, AIS, and files formatted according to the default data structure.

Safe and Secure

SmartExporter is compatible with existing SAP® access privileges. Therefore, the SAP tables for which you do not have access rights within the ERP, will not be accessible through this solution. The original SAP® data cannot be edited as the SmartExporter solution produces read-only content. All actions can be traced at any time, as they are recorded by a unique ID. This ensures maximum transparency.

Basic Steps