Import data from almost any source – spreadsheets, PDFs, ERPs and plain text files.
IDEA's Report Reader feature allows you to bring data from different sources and file types into a single format for comparison and analysis. This feature reads characters and encoding to create properly aligned text and automatically eliminates leading or trailing spaces for better matching capabilities. You can preview the data before importing, save import templates and edit previously-created templates using simple point-and-choose tools.
Analyze every transaction using powerful queries and calculations.
Once the data is imported into IDEA...the powerful analytics begin. Whether you're looking for fraud and errors, or identifying and analyzing risk, IDEA gives you 100% data analysis coverage. With a 360° view of data sets, you can quickly see the big picture, identify relationships and patterns, and explore transactional data in depth. Plus, the History Log feature automatically records all analyses performed to maintain validity. Examples of IDEA's analysis capabilities.
Review and communicate your results with reports, charts and graphs.
Reporting and presenting your findings is one of the most important steps in your workflow. IDEA helps you achieve your data sharing and reporting needs with a variety of export options including Excel, Access, XML, Text, RTF (Microsoft Word) and PDF. IDEA's Report Assistant walks you through simple customization steps to set, view and print reports, then share with others.
The Project Overview feature presents a graphical representation of the entire audit or investigation process, which may be shared with management and clients, or used to meet documentation requirements. The graphical overview includes all the actions performed within a Working Folder or IDEA Server project, including the creation, deletion, and modification of databases. It also records all actions performed so the process used can be repeated on next period's or next year's files. This feature provides the ability to independently review the workflows including drill-down capabilities for additional history. With IDEA, you can view and review work done on a project, so go ahead and show them how it was done.
Automate repeatable tasks without writing code.
If you've ever attempted to automate tasks using macros, DIM statements or other programming, but abandoned your efforts out of frustration, we have a solution for you. The Visual Script feature in IDEA allows you to build your own scripts without any coding. Visual Scripts can be used to re-run standard analysis processes and build continuous monitoring applications. Simply select the task in the Visual Script Editor window, then select "Task – Edit." The dialog box for the selected task will appear and you can make your desired changes.
Once you've tried your hand at using Visual Scripts, you can begin using (and developing your own) IDEAScripts. IDEAScript is an advanced scripting language that can be used to standardize routine analyses or basic procedures for consistent results. IDEAScripts can address complex processes that are repeated periodically, such as import and normalization of data from different sources to prepare for comparison. Additionally, the maximum length of an IDEAScript is 32,000 lines, which provides you with the power to create longer, more complex automated processes within a single IDEAScript. You can also automate the analysis process by scheduling IDEAScripts to run during off hours. Save time and effort by creating your own standard test routines or use some that we have written by accessing the CaseWare IDEA Support Site, which is available to supported users.
Additionally, Project Overview allows you to create Visual Scripts and IDEAScripts to save ad-hoc tasks and complex repetitions that you can reuse or modify and reuse.