The 21st Minute


Transaction Analysis



One of the largest independent oil and gas acquisition, development and production companies in the United States wanted to assess and automate the account transaction approval process.


The process of tracking, validating and resolving payments required more than 60 fields of data, which needed to be joined and matched to identify potential infractions. Auditors needed a way to quickly identify invoices that were processed and approved by only one person, and calculate spending changes between approvers and vendors between a two-year period.


The Solutions Development team imported and verified all data. Once the data was imported into CaseWare IDEA®, the team worked to isolate duplicate records within the master file. Invoice data was segmented by region, approver and vendor to look for approvals that did not follow company policy. An IDEAScript was developed to automate the process of capturing accounts payable transactions that were approved by one person. Results are segmented by region and exported to an Excel workbook for further investigation and resolution.


By reaching out to Audimation Services for their expertise using analytics, the client gained a deeper understanding of their own approval process, including instances where the policy was not followed. The client now has the ability to join data systems and compare data from different locations into a single tool for analysis. The new process helped automate the vendor payment process, which was reduced from a two-week process to less than 10 minutes.


Automate Procedures , Success Story

Posted By

By Team Audimation

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