Payroll fraud tends to hide in small, repeated amounts and in records nobody looks at after set-up.
Common payroll fraud red flags include employees with no HR record, leavers still being paid, several employees sharing one bank account, unexplained pay rate changes, overtime or allowances far above peers, and payroll changes made and approved by the same person. Test a payroll export against the HR list in Excel each month and investigate every exception.
Two exports for the same pay period:
Put them on separate sheets named Payroll and HR, with employee ID in column A of each, in the order listed (so bank account is column C and overtime column E on Payroll, and leaving date column C on HR).
=IF(COUNTIF(HR!A:A,A2)=0,"NOT IN HR","")
Every hit needs an explanation. Contractors paid through payroll should still have an HR record.
With the pay period end date in a cell named PeriodEnd and the leaving date pulled from HR:
=XLOOKUP(A2,HR!A:A,HR!C:C,0)
Put that in column K. XLOOKUP returns 0 when the leaving date is blank or the employee isn't on the HR list (Test 1 catches those), so the flag only looks at real dates:
=IF(AND(K2>0,K2<PeriodEnd-31),"PAID AFTER LEAVING","")
The 31-day allowance covers a final payment in the month after leaving. Adjust it to how your payroll handles final pay.
=IF(COUNTIF(C:C,C2)>1,"SHARED ACCOUNT","")
Couples who both work for you can share an account legitimately. Most other hits deserve a call. Run the same test against your supplier bank details too: an employee's account appearing in the supplier master is a serious red flag. See ghost vendor fraud detection.
=IF(E2>3*MEDIAN(IF($L$2:$L$500=L2,$E$2:$E$500)),"HIGH OT",""). In older Excel versions enter it with Ctrl+Shift+Enter. If most of a department works no overtime the median is zero, so review those departments with a pivot instead.Payroll is also a cash-out route, so link it into your wider payment fraud prevention controls.
UK payroll runs through PAYE reporting to HMRC; US payroll involves federal and state withholding and IRS reporting. Reporting rules don't stop internal fraud on their own, so the tests above apply in both. Check current HMRC or IRS rules for any reporting obligations if you find a fraud.
Audits the supplier master file with an on-device AI and 28 tests: lookalike duplicates written differently, bank-detail changes before payments, vendors matching employees, and a risk score for every vendor. Runs in your browser on your own computer: nothing is uploaded.
Score a payment request against the warning signs of fraud. Free to use online.
The Invoice & Payment Fraud Defence Kit puts every payment through a Release, Hold or Pulled-from-run decision, with a bank detail change verification log, supplier checks, an incident log, a staff training record and a Fraud Defence Playbook (PDF). Excel, no macros, one-time price.
A person on the payroll who doesn't work for the business, either invented or a former employee, with pay going to an account the fraudster controls.
Run the HR comparison every pay period and the wider tests at least quarterly. They take minutes once the sheet is built.
Someone independent of payroll processing, such as the financial controller or an HR manager who can't change pay.
Last updated 28 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.