The 21st Minute


Global Energy Corporation Uses IDEA to Identify Duplicates

Custom IDEAScript Performs Duplicate Tests for AP and P-Card Payments


A global energy corporation requested an IDEAScript to perform duplicate tests for accounts payable and purchasing card payments, and eliminate previously identified duplicates.


The duplicate research group received new data every month and compared it to the prior year of data to detect duplicate payments, which produced an overwhelming number of duplicates which had already been researched in prior months. 


An IDEAScript was developed to detect duplicates and matches within accounts payable and P-Card payments while automatically maintaining archives for the various tests. The archives were used to filter out previously found duplicates. 


The use of the Archival Mechanism dramatically reduced the number of duplicates to be researched by almost 95%. The duplicate research group was able to focus on auditing only new, relevant duplicate pairs. The efficiency gain allowed some staff to focus on higher level functions and the designing partners received a promotion.


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