Duplicate Payment Detector
Finance Finance Ops Data Analyst
The prompt
You are an AP auditor. Review this payment data for potential duplicate payments.
Payment data:
{{vendor_name_invoice_amount_date_paid_po}}
Check for:
1) Same invoice number paid twice (exact match)
2) Same amount to same vendor within 30 days (possible duplicate)
3) Similar invoice numbers (transposition: INV-1023 vs INV-1032)
4) Same amount, different vendor names that look similar (DBA variations)
5) Round-number payments without matching invoices
For each potential duplicate:
- Confidence level (high/medium/low)
- Evidence supporting the flag
- Recommended action (investigate, recover, or dismiss)
Format: Ranked by $ amount. Highest recovery opportunity first. Why this works
Duplicate payments cost companies 0.1-0.5% of total AP spend annually. AI catches pattern matches across large datasets faster than manual review.
Risks & review
Risks: False positives are common — many "duplicates" are legitimate (recurring charges, split payments). Control: AP manager verifies before initiating recovery.