The 21st Minute


Data Validation and Script Implementation Automates Workflows

Continuous Monitoring Solution Helps Identify Fraud & Recover Costs


A financial services and systems administration division of a major media corporation providing solutions for its parent company’s back-office operations. The company is working to standardize and centralize administrative functions to minimize transactional inefficiencies.


In an effort to centralize financial transaction processing to cut costs and gain efficiencies, the client implemented CaseWare Monitor to identify fraudulent activity, processing errors and recovery opportunities. Data provided by IT needed to be verified prior to analysis for areas such as Accounts Payable, Payroll, General Ledger and Travel and Entertainment.


A data matrix was developed to match input files with the required fields, to ensure the supplied data was complete, accurate and ready for analysis. The SQL code developed by IT was checked for accuracy to ensure delivery and data objectives would be met.


The custom IDEAScript provided rapid identification of mismatched data fields within key accounts, in addition to incomplete accounts payable and payroll data omitted by IT. The process was adjusted to include a complete data capture, which allowed the audit team to acquire more raw data for testing.  Additionally, the scripts enabled the identification of duplicate payments and errors in payroll before payments were processed. The implementation of a unified, standardized process is helping save millions annually.


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