X
Icon

The 21st Minute


Blog

Challenging Imports

Success Story


 

Client:

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.

Challenge:

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.

Solution:

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.

Results:

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


Related Posts
Turn Your Data into a Competitive Advantage
Nov 05 Download the eBook 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. Y...
Infusing Python into Your Analysis with IDEA
Oct 06 The tech community often refers to Python as the official programming language for non-programmers. It’s free and easy to learn (even if you don’t know wher...
Exploring IDEA's Built-In Power of Python
Aug 20 In December of 1989, Dutch programmer Guido van Rossum was looking for a hobby programming project to keep him occupied during a slow work week around Christmas...
BROWSER NOT SUPPORTED

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

×