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


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