IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.


Data Extraction Tools

Bring in Your Data from Any Source or File Type for Analysis

  • Import virtually limitless amounts of data from practically any source.

  • Correct formatting and alignment.

  • Save hours of data preparation work.


File Imports

  • Obtain data from more than 99 accounting packages including QuickBooks, SAGE, ACCPAC and more, and standardizes them into a single output that is consumable by IDEA®.

  • Use the Open Database Connectivity (ODBC) to import IDEA data from third-party applications such as Tableau, Power BI, MS Excel and many more.

  • Convert any file type, including ERP systems, spreadsheets, database software, legacy mainframes, financial applications, flat or print files (PDFs) and more, into an IDEA database file.

  • Compatible with any locally-installed spreadsheet software associated with the .XLS extension, beyond just Microsoft Office.

  • Automatic detection of files with international characters encoded in UTF-8 format to import data correctly without the need to change the encoding of the source files.

  • Save time when importing multiple files of the same type by using the rerun feature.

  • Individually select records to extract for more in-depth review.


GDPR Compliance

Comply with the General Data Protection Regulation (GDPR) with a complementary tool that reviews the data within IDEA and analyzes it to determine the risk factor based on GDPR laws.


Instantly Familiar

With its Windows-based user interface, IDEA is instantly familiar. You don't need to be a data scientist or programmer to navigate its powerful functionality. It offers a multitude of features to ease navigation and put commonly-used audit commands within reach.

Need Assistance Gathering the Right Data?

Let Our Experts Help!


This website has been designed for modern browsers. Please update. Update my browser now