Meridian Health Supply: Turning Duplicate-Payment Flags into Defensible Findings
Meridian Health Supply distributes medical consumables and processes 1.1 million vendor invoices a year through a shared-services center. An analytics team ran a duplicate-payment test on invoice number, amount, and posting date and flagged 2,300 invoices totaling $4.7 million. The team proposes sending the full list to accounts payable for validation. AP managers say many flags are legitimate split shipments, recurring service fees, or credits reissued under a new number. Separately, a first-two-digits Benford test shows deviations for vendors registered at virtual-office addresses. The analytics lead wants to label the findings as fraud in the quarterly risk report. The CFO is concerned about false positives damaging vendor relationships and has asked for a defensible approach before any vendor is contacted. The team has SQL access, 30 days, and no additional budget. No single flagged invoice has yet been reviewed.
1. Distinguish an anomaly from fraud in this fact pattern and design a validation approach for the 2,300 flags.
Read the worked answer
Treat the 2,300 flags as anomalies, not fraud. A duplicate-payment test on invoice number, amount, and posting date will produce false positives from split shipments, recurring fees, credits reissued, and legitimate multiple invoices. Sending the full list to AP invites inconsistent, undocumented clearing and possible tip-offs. Instead, define validation criteria in advance: exact duplicate vendor, invoice number, amount, and date; same vendor with near-duplicate invoice numbers and same amount within a short window; same bank account across vendors; and payment status. Review a stratified sample of high-value and high-risk flags first, then expand. Require each disposition to cite evidence, such as receiving documents, contract terms, or vendor confirmation, and have a reviewer independent of AP sign off. Keep the fraud label out of the risk report until cases are substantiated. Track false-positive rates by rule so the analytics improve. This approach is defensible, protects vendor relationships, and uses the 30 days to resolve the highest-risk items rather than all 2,300.
2. How would you refine the duplicate-payment analytics and prioritize the review queue?
Read the worked answer
Refine matching by using invoice line detail, purchase order number, vendor tax ID, bank account, and free-text normalization; exact invoice numbers are easily reused. Add fuzzy matching for vendor names and addresses, and compare payment date to invoice date for split payments. Prioritize by risk score: amount, vendor created recently, vendor bank account changed near payment, employee linked to vendor, sequential invoice numbers from one vendor, and invoices just below approval thresholds.
Run the test against historical paid files, not just the current period, to find repeat patterns. Assign each flag to a queue with an owner and service-level deadline. For the Benford deviation, do not conclude fraud: first-two-digit tests fit naturally occurring amounts, not assigned or recurring fees, and virtual-office addresses are common for legitimate small vendors. Use Benford as a triage signal only. Combine it with vendor master change logs, employee-vendor address matches, and bid-rigging indicators such as losing bidders that later become subcontractors.
3. What additional analytics would you combine to assess vendor risk, and what biases should the team avoid?
Read the worked answer
Combine duplicate payment testing with vendor master analytics: vendors sharing addresses, phone numbers, tax IDs, or bank accounts with employees or other vendors; vendors created outside normal hours; changes to bank details shortly before payment; and vendors with no purchase order history. Add spend analytics for split purchases below approval thresholds, price variance against contract, and sequential invoice numbers. Link AP data to HR master data to detect shared addresses and bank accounts, subject to privacy rules.
Avoid confirmation bias: the team wants a fraud finding because the test produced volume. Avoid base-rate neglect by recognizing that most vendors are legitimate and most flags are process noise. Avoid labeling vendors as fraudulent before validation, which can cause defamation and relationship harm. Document rule logic, sampling, and dispositions for reproducibility. Finally, present findings as control weaknesses plus validated exceptions, not as a single dollar estimate of loss.