The 21st Minute


O&G Supplier Uses IDEA to Test Controls Across Multiple ERP Systems

Analytic Toolbox Helps Test Revenue & Receivables Controls


A Global 500 supplier of technology, integrated project management and information solutions to the oil and gas industry needed to process data from their ERP systems to test controls for revenues and receivables.


Large amounts of data, stored in multiple ERP systems and formats, created a challenge for auditors to effectively test critical financial areas. The company also needed a way to produce, manage and share results.


The Solutions Development team created a suite of customized tests designed to interrogate financial data for outliers and anomalies. A custom IDEAScript was developed to automate the testing process and deliver consistent results.


The Analytic Toolbox enabled the client to process seven different data sets in multiple locations, and import the data into IDEA for testing. Results were presented in pivot table format and included color codes to quickly identify key areas of interest.  The Toolbox also helped automatically configure date formats for global consistency. The new solutions provided consistent results and improved preparation of revenue data to assist field auditors with performing inspections.


Automate Procedures , Success Story

Posted By


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

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