We live in a world where time and resources are at a premium. As a result, some responsibilities get pushed to the “back burner.” However, we also live in a world where the possibility for employee fraud is real, but the process to uncover such fraud could be difficult and time consuming. One way to get some high quality return on time investment is by using simple Excel functions.
As an auditor, I’ve had the privilege of being involved in thorough data mining projects designed to detect fraudulent activity. During these projects, data mining software is used to perform a suite of complex tests that can comb through significant amounts of data and summarize it to obtain leads related to suspicious activity. This software can produce amazing results; however, owning this type of software can be expensive and it takes time to learn the more difficult tests.
Luckily, as long as you have the ability to export certain data to Excel, then you will be able to perform the following Excel functions in seconds and the results only require minor follow-up. These tests will never replace data mining or other internal audit procedures that your organization is already doing, but if you don’t have any internal audit procedures in place, the following steps would be a good place to start:
Non-Payroll Check Register
Payroll Check Register/ACH listing
All of these tests provide information on where to dig deeper to identify fraudulent activity. Even if these tests don’t specifically find a fraud, they could help to prevent one.
There are several elements that are consistent among people who commit fraud. These elements are often referred to as the fraud triangle. One part of the fraud triangle is that the individual committing the fraud needs to have “an opportunity” for the fraud to take place. By simply asking questions of staff members related the results of the Excel tests listed above, you are letting your employees know that some degree of internal audit function is being performed. This could cause employees to perceive less of “an opportunity” to commit fraud.
Of course, the purpose of these tests is not to accuse your employees of committing fraud. The messaging related to the follow-up on the Excel results is important. Part of that messaging could be that procedures such as these can help find mistakes or inefficiencies that should be corrected moving forward. This would make the jobs of the people working in the department better on an ongoing basis.
Just think: by devoting as much time as you devoted to reading this article, you could have exported a check register to Excel and subtotaled it. It makes you wonder what clues you could have uncovered related to errors, inefficiencies or potentially even fraudulent activity.