The 21st Minute


Challenging Imports

Success Story



An accounting and consulting network operating in 137 countries employs more than 27,000 people offers forensic, litigation and valuation services. The firm often receives client data in a variety of formats, and requires time-consuming clean up before it can be analyzed.


The firm needed to import a receivables trial balance, displaying important accounts by date with details, into CaseWare IDEA® for analysis. Some text and PDF files are difficult to import due to layout and alignment issues. Traps or markers must be placed within the document to extract the appropriate text and numeric data. IDEA’s Report Reader feature helps convert typewritten or printed text into machine-encoded text, however additional assistance was needed to prepare the data for import.


The Audimation Services Solutions Development team identified headers and important sum-information, such as account numbers, by using a “pattern match” approach to align the columns. The team also specified the start and end of the document to export data from the PDF into IDEA. All data was validated against established control totals.


By working with the Solutions Development team to sort, set traps and prepare data for import, the firm was not only able to import the data with ease, but the team also provided a template for future imports with similar challenges. Additionally, the firm has saved time on subsequent work for their client by using the template import, thereby increasing their validation rate on their projects.


Automate Procedures , Success Story

Posted By

By Team Audimation

Related Posts
Task Automation Using IDEA
Apr 16 Audit scenarios rarely require an entirely unique process. Having a preferred set of tests ready to go is a great time-saver, but that can be further improved i...
Gain Productivity with RPA
Apr 16 Leaders of professional associations are urging auditors to embrace emerging technologies to advance the industry, create audit efficiencies and manage organiza...
Turn Your Data into a Competitive Advantage
Nov 05 We are in the midst of a data explosion where every action is collected, from a credit card swipe to the vibration of a factory machine. You have been collectin...

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