The 21st Minute


CPA Firm Uses IDEA to Import & Analyze Brokerage Statements

OCR Technology Converts 40 Printed Pages into Electronic Files


Top U.S. CPA firm providing audit, investigations and consulting services. The firm analyzes both financial and non-financial evidence to assist with interrogations, document requests and depositions to help clients recover losses.  


The firm needed to perform cash flow analysis on 40 pages of brokerage statements. They lacked the ability to get the statements imported into a tool where the data could be segmented, verified, analyzed and prepared for a court trial.


Audimation Services used Optical Character Recognition (OCR) technology to convert the paper statements into electronic data files, which were then imported into IDEA. The data was scrubbed to correct OCR interpretation errors and verify data for accuracy. With the data in electronic format, individual cash flow information was easily segregated into separate files for further analysis.


The brokerage statements were successfully imported, verified and sorted, which helped the client quickly detect missing information. The data import and verification process gave the client confidence in presenting material evidence during the trial.

Automate Procedures , Success Story

Posted 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...

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