When Sarbanes-Oxley was passed in 2002, many companies were forced to take an in-depth look at internal Accounts Payable controls. Implementing internal controls takes time, but may prove to be a very cost-effective measure if any fraud or leakages are found. Here are a few approaches you can try to tighten up your A/P audit. They require some degree of data mining and programming capability but are fairly straightforward to implement.
1) Duplicate Payments
Duplicate payments in most cases may not be fraud-related, but continue to be a significant A/P leakage that is both preventable and recoverable. Mark Van Holsbeck, Director of Enterprise Network Security for Avery-Dennison, estimates that corporations make duplicate payments at the rate of 2%. Two percent may not sound like much, but if your company’s A/P invoices total $75 million, duplicate payments may account for $1.5 million. Take a look at the statistics:
Medicare - The Dept of Health & Human Services’ Inspector General estimated that Medicare made $89 million of duplicate payments in 1998.
Cingular - We have once again discovered that payments made online as an Electronic funds payment for TDMA accounts, have been deducted twice from the customer's checking account.
Medicaid - We identified at least $9.7 million in such duplicate payments during our two-year audit period, and estimated that as much as $31.1 million in additional duplicate payments may have been made.”
In a rush to find the overpayments, many companies have emerged: A/P Recap, Automated Auditors, AP Recovery, ACL, Cost Recovery Solutions, and more. That these companies are thriving is a testament to the fact that duplicate payments still occur at an alarming rate.
Many software packages have some controls over duplicate invoices but it usually takes some in-depth querying to find them all. For example, many accounting packages do a duplicate invoice check and prevent you from keying in a duplicate invoice number for the same vendor. But just add an “A” to the invoice number or change a penny and you are on your way to a duplicate payment. Another common mistake is found in vendor files; duplicate vendor numbers for the same vendor is the number one cause of duplicate payments.
A programmer in your IT department will be able to help you with the SQL code for these joins. The SQL code will look something like this to create the first report “EEEE”:
CREATE TABLE DUPES_EEEE AS
FROM INVOICES A, INVOICES B
WHERE A.VENDORID=B.VENDORID AND
A.ID <> B.ID
The ID field should be a unique record identifier to distinguish one record from another. In Microsoft Access, these fields are usually created by using the data type “AutoNumber”. In open code, a field such as this can be easily created using a counter and incrementing it by 1 for every record (COUNTER = COUNTER + 1).
2) Implement some fuzzy-matching
Implementing “similar” fuzzy-matching instead of exact matching is what makes this approach more accurate and powerful than many. We define “similar” to mean the following:
Invoice numbers are considered similar if they are exact after stripping out any
zeros and any alphabetic characters as well as punctuation characters.
Invoice dates are considered similar if the difference between the dates is less than a designated amount such as 7 days. For example, if you entered "7" days for the date tolerance, then all invoices with a date different of 7 or less would be considered similar. We generally set the date tolerance to 21 days to catch duplicate payments made 3 weeks apart; this often eliminates catching legitimate rent payments.
Amounts are considered similar if they meet one of three criteria:
- the amounts are 5% +/- the other amount
- one amount is exactly twice as much as the other, i.e. $220.15 and $440.30
- the amounts start with the same first 4 digits, i.e. $123.45 and $1,234.55
Try using similar matching on the invoice number, date, and amount fields when you conduct your next duplicate payment audit – your reports will be shorter and more accurate!
2) Benford’s Law
What is it?
Benford's Law (which was first mentioned in 1881 by the astronomer Simon Newcomb) states that if we randomly select a number from a table of physical constants or statistical data, the probability that the first digit will be a "1" is about 0.301, rather than 0.1 as we might expect if all digits were equally likely. In general, the "law" says that the probability of the first digit being a "d" is
Where ln refers to the natural log (base e). This numerical phenomenon was published by Newcomb in a paper entitled "Note on the Frequency of Use of the Different Digits in Natural Numbers", which appeared in The American Journal of Mathematics (1881) 4, 39-40. It was re-discovered by Benford in 1938, and he published an article called "The Law of Anomalous Numbers" in Proc. Amer. Phil. Soc 78, pp 551-72. 
You can actually re-create this function in Excel quite easily. In one column, type 1, 2, 3, through 9, making 9 rows in cells A1 through A9. In the second column, cell B1, type the function “=ln(1 + 1/A1) / ln(10)” and copy this function for cells B2 through B9 and it will create the probabilities.
How is it used to identify fraud?
If we know the normal frequency of digits, then we can identify digit frequencies that violate that normal behavior. For example, Benford concluded that, out of a group of numbers, the first digit will be “1” about 30% of the time. Similarly, using the same function, we can expect the first digit to be “8” about 5.1% of the time. Expected frequencies for each first-digit of the invoice amount are shown in the graph below:
If we review Accounts Payable invoices and determine the first digit of the invoices is “8” 50% of the time, then we may have either many legitimate payments that start with “8”; or we may have fictitious invoice amounts. Fraudsters will often create an amount that starts with a higher number, like 8 or 9, not knowing that auditors are now equipped to identify these abnormal payments.
3) Rounded-Amount Invoices
People who commit fraud often create invoices with rounded amounts, which are invoices without pennies. Yes, you would think the fraudster would have “cents” enough to do otherwise. An easy way to identify rounded-amount invoices is to use the MOD function in Excel. Suppose your invoice amount is $150.17; then MOD(150.17,1) gives you the remainder of dividing 150.17 by 1, which is .17. So, using the MOD function with a divisor of 1 on a no-pennies amount would leave us a remainder of 0. Additionally, try to rank your vendors by those with a high percentage of rounded-amount invoices. To do this, just calculate each vendors’ number of rounded-amount invoices and divide it by the total number of invoices for that vendor, obtaining the percentage. Then rank by descending percentage to review the most suspicious vendors first.
4) Invoices Just Below Approval Amounts
People who commit fraud are not always the “sharpest knife in the drawer.” Suppose an A/P clerk knows the different dollar thresholds for management approval. For example, a supervisor may only be allowed to approve invoices of $3,000 or less, while a manager may be allowed to approve invoices of $10,000 or less, and so on.
Suppose this A/P clerk and a manager decide to skim off some extra dollars together. What is the easiest way to get the most money? Create an invoice just below the approval level of that manager: $9,998 when the approval level is $10,000; or $2,978 when the approval level is $3,000.
To identify these potentially fraudulent invoices, try this: identify invoices that are 3% (or less) LESS THAN the approval amount. For example, if your approval amount is $3,000, then any invoice that is between $2,910 and $2,999 would be flagged as suspicious.
5) Check Theft Search
Most Accounts Payable departments conduct a reconciliation of Accounts Payable with the monthly Bank Statement to identify any discrepancies between the two. This process can also be instrumental in identifying check fraud. One simple way to spot potential check fraud is to identify missing check numbers or gaps in reconciled checks numbers. This is usually indicated on the bank statement with a ‘*” or ‘#’ to indicate the check number is not sequential.
Another more advanced way is to conduct a reverse Positive Pay electronically. By merging your check register, A/P file, and bank statements together, you have the power to identify stolen checks. Better yet, if your bank has OCR (Optical Character Recognition) abilities, then you can identify the actual payee on the check.
Speaking in technological terms, you have 3 different data bases describing 1 activity. Use the 3 data sources to find any discrepancies in the 1 payment. If your check numbers are unique, try merging all 3 data sources by the check number and compare each of the following fields:
Using SQL code or another programming language, identify all of the checks that are in one data base and not the other. In addition, identify all of the checks that are in all 3 data sources but have different payee names or different amounts and dates.
6) Abnormal Invoice Volume Activity
Monitoring vendor invoice volume is one way to alert you to abnormal behavior. Rapid invoice volume increases may indicate a legitimate increase in business, but also may indicate that a fraudster has become more confident in stealing money. Either way, the increase may warrant further investigation. Suppose a vendor has 2 invoices one month and 70 the next – you may want to know why even if the reason is not a fraudulent one.
To calculate the percent increase in invoice volume from month to next month, find the difference in number of invoices and then divide by the number of invoices in the first month. In our example, going from 2 invoices to 70, the difference (68) divided by the number of invoices in the first month (2) represents a 3,400% increase. Setting the threshold percentage is the key here; when doing audits, we like to set the threshold percentage at 300% or higher. Setting the threshold at 300% will catch increases from 3 to 13, which may not be interesting, so you may also want to set a minimum number of records that you are interested in, such as 50 as your second month’s number of invoices. Setting the threshold at 300% will also catch more interesting increases, such as 50 to 220.
7) Vendors with Cancelled or Returned Checks
Cancelled and returned checks do occur in the course of a normal Accounts Payable month. What is more uncommon is a vendor with many cancelled checks or a regular pattern of cancelled checks. Cancelled checks are usually legitimate transactions; however, a cancelled check can be returned to the wrong hands and re-written to the fraudster. Below is a true story of how a clerk turned a returned check into a fraudulent one:
“An uncashed disbursement check was returned to an accounts payable clerk for disposition because she originated the invoice entry. The clerk put the check in her desk and forgot about it for several months. Upon cleaning her desk, she discovered the returned check. When she checked the paid history, she realized the supplier had returned the check when it was determined to be a duplicate payment of an invoice.
She also noticed that the payee name had been printed slightly below "Payee" on the check. With a bit of effort she managed to align the check and insert her name above the original payee in a print similar to the original, along with an "or" designation following her name. The fraud was caught by an accounts payable auditor searching for duplicate payments and who was asked by the supplier to furnish proof of duplicate payments by providing copies of both cancelled checks. “
This algorithm is easy to implement. Calculate the number of cancelled or returned checks for each vendor and divide by the total number of checks for that vendor. Then, sort this list by descending percent so that your most suspicious vendors are at the top of the report
8) Above Average Payments per Vendor
This algorithm identifies invoices that are way above average for a particular vendor. Suppose a vendor normally has invoices ranging from $1,000 to $3,000; suddenly an invoice shows up for $25,000. You may want to investigate this abnormality and can do so using this alert pattern.
This algorithm is also easy to implement: For each vendor, calculate the average and standard deviation of the invoice amount. Then, calculate a z-score for each invoice amount
z-score = (invoice amount – average amount) / standard deviation
Then, flag all vendors with a z-score above 2.5, indicating the payment is more than 2.5 standard deviations above the mean. If your report is still too large, try increasing the z-score threshold to 3.0 or higher.
Using this algorithm alone, we were able to catch employee fraud occurring in a mid-size health manufacturing company. The fraudulent employee was receiving a paycheck every other week in the amount of $500 to $1,000 when, all of the sudden, 3 invoices for $40,000 each appeared. Because $40,000 was significantly greater than this employee’s average payment, the payments were flagged for further research.
What made the invoices even more suspect was that they occurred on or near the same date and had no invoice number. After alerting the new controller of the suspect payments, the new controller was aware that an employee had left in a legal “scuffle” but was not aware of the $40,000 checks that were stolen.
9) Vendor / Employee Cross-Check
“Trust but verify”. Most employees are generally trustworthy! But it does not hurt to conduct some data mining to make sure they are. Here is a simple approach to cross-check your vendor and employee files to see if perhaps an employee has set up a fictitious vendor.
Try merging your vendor file and employee file by the following variables:
Tax ID Number
Bank Routing Number
If you have a good programmer, try doing some fuzzy-matching on these fields as well. For address, try extracting JUST THE NUMBERS in the street plus the zip code, and then compare these numbers. This eliminates matching on noise words such as “Drive” and “Suite”.
Also, try doing some fuzzy-matching on tax ID number as well, just in case there was a typo in the data entry. If you specify that the tax IDs are equal if they are even 1 digit off, you may catch a vendor/employee ring!
This algorithm made it possible to detect a real employee (“Kathy”) whose SSN was the same as a company EIN (tax ID number). The company name, which we will call “ABC Inc”, happened to be on the same street, city, and state as a person with the same last name as the employee (presumably her spouse). Without this pattern, the employee fraud may have gone undetected.
10) Vendors with a Mail Drop as an Address
This algorithm compares vendor addresses with mail-box drop address such as “Mail Boxes, Etc”. Some fraudsters will use mail drops as their address instead of a P.O. Box, to hide their fraudulent activity. Not all of the vendors appearing on this list will be fraudulent, because a vendor may in fact be right next to a Mail Boxes, Etc. However, the list provides a unique approach to reviewing vendors who also may show up on another alert list.
(To obtain a copy of the mail-drop table, contact the author of this document). Or, if you have time, you can also search for Mail Boxes, Etc. on www.411.com and put the addresses in a database and then conduct your address matching accordingly.
Occupational fraud is a growing problem. In fact, the Association of Certified Fraud Examiners (ACFE) estimates that 5% of all revenue is lost to occupational fraud every year. Fraud is not 100%preventable but there ARE steps you can take to both prevent and detect fraud on an ongoing basis. At a minimum, scan for duplicate payments every 6 months, and perform an annual cross-check between your vendor file and employee file. With these two steps alone, you may be able to pinpoint leakages that otherwise may go unnoticed.
About the Author
Christine L. Warner is the President of Automated Auditors, LLC, and has over 20 years of experience in data mining, fraud detection, statistical analysis, and complex customized programming. She has authored several articles on using data mining to detect fraud, such as "Death Fraud: This Identity Theft is Alive and Kicking", co-authored with Cheryl Hyder, for which they received the Hubbard award in 2011 for most influential article published in Fraud Magazine (ACFE). Christine has served as the Deputy Project Director of a Medicaid Integrity Contractor audit for the entire Northeast region of the U.S., and has personally developed over 50 healthcare fraud algorithms, as well as an entire suite of Accounts Payable fraud algorithms.