In the ACFE's 2024 Report to the Nations, billing schemes appeared in 22% of the 1,921 occupational fraud cases studied, with a median loss of $100,000. The median fraud of any kind ran for 12 months before anyone found it, and 43% were uncovered by a tip rather than by a control.
That last figure is the uncomfortable one for internal audit. Accounts payable is where most companies have the most controls, yet billing fraud still gets through. In my experience leading fraud investigations, the warning signs were usually in the data all along. Nobody had run the right test.
A billing scheme makes the company pay a false invoice. The fraudster might set up a shell company, inflate a real supplier's invoice, or charge personal purchases to the business. These seven red flags catch most of them.
The seven red flags
Bank details changed without a call-back
A change to a supplier's bank account is the single riskiest edit in the vendor master. It is how both internal fraud and external payment diversion work. Every change should be confirmed by phoning a known contact on a number already on file, never one given in the change request.
Duplicate vendors under different names
Look for different supplier names that share a bank account, an address, a phone number or a tax registration number (the TRN in the UAE). A legitimate supplier rarely needs two records. A shell company often hides behind a name close to a real one.
Vendors that match employee data
Compare supplier bank accounts, addresses and phone numbers with the payroll and HR master files. A match is not proof of fraud, but every one needs an explanation.
Invoices split just under approval limits
If invoices above AED 50,000 need a director's sign-off, look for several invoices of AED 45,000 to 49,999 from the same supplier within a few days. Splitting purchases to dodge an approval limit is one of the oldest tricks there is.
Round amounts and sequential invoice numbers
Real invoices for goods rarely come to exact round sums. Watch for a supplier whose invoices to you run 1041, 1042, 1043 over several months. It suggests you are their only customer, which is unusual for a genuine business.
Services with no proof of delivery
Goods have delivery notes and goods received records. Services such as consultancy, maintenance, marketing and "facilitation" often have nothing but the invoice. Ask for the report, the timesheet or the site visit record. Also check for purchase orders raised after the invoice arrived.
Dormant vendors that suddenly wake up
A supplier with no activity for a year or more that suddenly receives payments deserves a look, especially if its bank details changed shortly before. The same goes for "one-time" vendor records that get used again and again.
How to test for them in your ERP
You do not need specialist software to start. Most of these tests can be run on an export of three tables: the vendor master, the payment history and the employee master.
| Red flag | Data needed | Test |
|---|---|---|
| Bank detail changes | Vendor master change log | List every bank change in the period and trace each to call-back evidence |
| Duplicate vendors | Vendor master | Group by bank account, TRN, address and phone; flag any group with two or more names |
| Employee matches | Vendor and employee masters | Join on bank account, address and phone |
| Split invoices | Invoice register | Same vendor, within 7 days, each invoice 90 to 99.9% of an approval limit |
| Round sums and sequences | Invoice register | Amounts divisible by 1,000; invoice numbers with gaps of one |
| Proof of delivery | Service invoices, PO dates | Sample service invoices and request evidence; flag POs dated after the invoice |
| Dormant vendors | Payment history | Vendors with no payment for 12 months, then a payment in the period |
The controls that prevent most of this
- Segregation of duties. The person who can create or edit a vendor should not be able to approve or release payments.
- Independent call-back for every bank detail change, documented.
- Three-way match of purchase order, goods or service receipt and invoice before payment.
- Periodic vendor master clean-up, blocking suppliers inactive for 12 months or more.
- A whistleblowing channel that suppliers can use too. Since tips find more fraud than any other method, it is worth making sure the people outside your company know how to reach you.
Where to start
If you only run one test this quarter, run the duplicate vendor test on bank account numbers. It is quick, it needs one table, and it is the test I have seen uncover the most problems.
Figures from the Association of Certified Fraud Examiners, Occupational Fraud 2024: A Report to the Nations. The AED 50,000 approval limit is an example; use your own delegation of authority.
