Audimation Services has been acquired by Caseware International Learn More.


Blog Image

A Simple Approach to Fighting Fraud

Applying Data Analysis to Uncover an Ongoing Fraud Scheme


Truth can often be found in simplicity. The Association of Certified Fraud Examiners (ACFE) 2008 Report to the Nation on Occupational Fraud & Abuse cited that, “…occupational frauds are much more likely to be detected by a tip than by audits, controls or other means.” The report also stated fraud schemes often continue for years before they are detected. Such was the case with an east-coast company that discovered a six-year fraud scam, totaling $860,000 in losses.

Just as the ACFE report indicates, the $750 million company had its share of office rumors and tips provided during employee exit interviews. Since the company did not have an internal audit function, the CEO and CFO were notified and instructed accounts payable to investigate. Each time, the designated accounts payable “investigator” would report back to the c-suite that all was well and the rumors were simply spread by disgruntled employees. After six years of rumors and yet another exit interview tip pointed towards fraud in the accounts payable department, company executives turned to a Certified Fraud Examiner (CFE) to investigate the issue.

The fraud investigator applied an Occam’s Razor principle of simplicity and data analysis technology to his work by asking three simple questions:

  1. How many employees are in accounts payable?
  2. How long has each employee been in accounts payable?
  3. Can you provide 100 percent of accounts payable data for the years the longest-term employee has worked in accounts payable?

Armed with the information that there were five accounts payable employees, and the longest-term employee had worked for the company six years, the company provided six years of accounts payable data. The fraud investigator imported the data into IDEA – Data Analysis Software using a simple 10-step process, designed for importing PDFs:

  1. Highlight detail line
  2. Define trap statements
  3. Define fields
  4. Green check to apply layer
  5. Create second layer if necessary
  6. Scan for errors
  7. Preview database
  8. File – Save As – Template (allows you to automate the import process for additional documents)
  9. Import into IDEA
  10. Check control totals

Note: When you install IDEA on your PC, there are three comprehensive tutorials loaded onto your hard drive. Choose Start button ► All programs ► IDEA ► Documentation

CaseWare IDEA's Report Reader - Setting Up Columns for a PDF Import

Fig. 1. IDEA Report Reader – Create IDEA databases from PDF files


View of Database Created from Doing PDF Import with Report Reader

Fig. 2. PDF file imported into IDEA. Data can now be analyzed.


Once the accounts payable data was imported into IDEA, the fraud investigator summarized the data using the Amount field, showing the number of occurrences of each check amount in the six-year data file. The fraud investigator, together with the c-level executives, reviewed the results that very same afternoon and decided the best approach was to ask the company’s bank to re-image the checks appearing in the highest repeating check dollar amounts. Had they merely checked the accounts payable file, which of course contained the same data as the extract provided to the fraud investigation, everything would have appeared to be in order. The bank was instructed to look for patterns, and if found, stop the re-image process and report their findings.


View of Summarization Report of Checks with Same Amount

Fig. 3. File summarized by checks of the same amount.


The bank easily detected a pattern where many checks were made payable to, and were endorsed by, the accounts payable employee who had worked for the company six years. In that time, she had swindled an astonishing $860,000 from her employer. You guessed it – it was the same accounts payable employee the c-suite had tapped to investigate when rumors or tips of fraud occurred. The case clearly involved a separation of duties issue in addition to a deep fraud scheme. The employee was arrested and convicted for her fraud crimes. At that moment, the fraud investigator knew he had secured a “client for life,” and worked collectively together to put internal controls in place to help prevent future infractions. Since then, the fraud investigator has been called upon the client and associates of the client company to provide data analysis on other problems, beyond fraud-related issues.


History Report Detailing All Tasks Performed in IDEA

Fig 4. History of all operations performed while detecting fraud.


Data analysis tools can simplify the process of sharing audit findings with management or clients. IDEA Version Eight includes a Project Overview feature that presents a graphical representation of the entire audit or investigation process. The graphical overview includes all the actions performed within a Working Folder, including the creation, deletion, and modification of databases as well as recording all actions performed. It provides the ability to independently review the workflows including drill-down capabilities for additional history.


Screenshot of Project Overview - A Graphical Display of Your Task History

Fig 5. Project Overview


Simple approach. Big impact. Don Sparks (CIA, CISA, ARM), an experienced internal auditor and fraud detection expert concludes, “The take away from this real-world case study is that fraud investigators and auditors add value when they find anomalies not previously detected,” said Sparks, vice president with Audimation Services, Inc. “Consultants of any specialty have learned that nothing earns respect faster in the c-suite than the ability to inform management of facts they did not already know, but need to know.”

The fastest and most effective way to perform analytical procedures, such as summarization, which was used in this particular instance, is to harness the power of data analysis technology. Data mining and analysis tools like IDEA have been used by accountants, auditors and financial professionals for more than 20 years. They are designed to improve risk assessment, uncover fraud and identify control issues. Even if you pursue rumors or tips, and scan data for instances of fraud, imagine how much more you could find by using data analysis tools and techniques – simply by adding available technology to your knowledge of audit or fraud investigation work.

IDEA is a registered trademark of CaseWare International Inc.

Best Practices , CaseWare IDEA , Tech Tip

Posted By

By Sarah Palombo
Sarah Palombo founded Avery Public Relations in 2007 and took on Audimation Services as her first client. She has more than 20 years of experience developing communications programs and creating content.

Related Posts
Developing a Preventative & Sustainable P-Card Program
Dec 15 Published in College & University Auditor - Fall 2015 Purchasing card (P-Card) spending is on the rise, particularly among colleges and universities...
Using Editable Fields in IDEA
Feb 27 One of the best features in IDEA is that the data you import is record-locked. In other words, you cannot accidentally overtype the source data. Sometimes, say ...
We Have IDEA, Now What?
Aug 24 Long after the angst of choosing the right software has passed, you may be uncertain about what to do with it. Sometimes, new IDEA users find themselves in a ru...

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