The 21st Minute


Blog Image

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

By Audimation Team

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