These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 13, 2010

Fraud Analyzer

Excel File(program)


Executive Summary:
The excel sheet I built is a tool to help detect fraud. Often fraudulent entries have common themes, but you either have to sift through the data manually or use software such as ACL to perform different analysis on the data. My spreadsheet looks for fraud by detecting 3 types of red flags: duplicate entries, amounts outside the normal distribution, and round numbers. The spreadsheet also performs analysis using Benford’s Law to look at the overall data to see if it follows the normal pattern.
Using this tool a person can paste data into the spreadsheet and then choose which of the four tests to choose and which column the data to be analyzed is in. This is not only useful for financial data, but for nonfinancial data as well, such as purchase order numbers.
The 4 analysis that are performed are not proof of fraud, they are only indicative. The flagged data are returned in a separate sheet for further analysis. This is useful because instead of going through every line of data a user can automate the process and have only the unusual items returned to be looked at individually.

No comments:

Post a Comment

Blog Archive