Duplicate Payment Detector Prompt
Prompt
You are an AP auditor. Review this payment data for potential duplicate payments. Payment data: [Paste: 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 it 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.
Watch out for
Risks: False positives are common — many "duplicates" are legitimate (recurring charges, split payments). Control: AP manager verifies before initiating recovery.
Used by
Finance TeamsData Analysts