Duplicate Invoice Detection: Best Practices

Duplicate invoices cost businesses an estimated 0.1% to 0.5% of annual disbursements. For a company processing $10 million in vendor payments, that’s $10,000 to $50,000 in preventable losses.

Here’s how to catch duplicates before they become duplicate payments.

Why Duplicate Invoices Happen

Understanding the root causes helps prevent them:

Vendor-Side Causes

• System glitches: Vendor’s billing system sends the same invoice twice
• Multiple submission channels: Same invoice sent via email AND portal
• Follow-up invoices: Vendor resends “in case you didn’t receive it”
• Format variations: Same invoice as PDF and paper mail

Internal Causes

• Multiple entry points: Different team members enter the same invoice
• Email forwarding: Invoice forwarded to AP multiple times
• Department silos: Each location enters invoices independently
• Rush processing: Month-end pressure leads to careless entry

The Three-Point Duplicate Check

At minimum, check these three fields together:

1. Invoice Number + Vendor

The most basic check. Same invoice number from the same vendor = probable duplicate.

Watch out for: - Invoice numbers with different formatting (INV-001 vs INV001) - Leading zeros (00123 vs 123) - Vendor name variations (Acme Inc. vs ACME Incorporated)

2. Invoice Amount + Vendor + Date Range

Catches duplicates when invoice numbers vary or are missing.

Watch out for: - Recurring invoices with identical amounts (legitimate) - Invoices split and resubmitted (partial duplicates) - Currency conversions that create slight variations

3. PO Number + Line Items

For PO-based invoices, the same PO line item shouldn’t be invoiced twice.

Watch out for: - Partial shipments invoiced separately (legitimate) - Service invoices against the same PO (may be legitimate)

Duplicate Detection Methods

Manual Review (Small Volume)

For fewer than 50 invoices/month:

1. Sort invoices by vendor, then by amount
2. Visually scan for identical amounts
3. Check invoice numbers for patterns
4. Flag anything within 5% of another invoice from the same vendor

Pros: No software needed, catches nuanced duplicates Cons: Time-consuming, human error risk, doesn’t scale

Spreadsheet Matching (Medium Volume)

For 50-500 invoices/month:

=IF(COUNTIFS(A:A,A2,B:B,B2,C:C,C2)>1,"DUPLICATE","OK")

Where columns are: A=Vendor, B=Invoice#, C=Amount

Pros: Low cost, customizable rules Cons: Reactive (finds after entry), requires discipline

Automated Detection (High Volume)

For 500+ invoices/month, automated systems are essential:

Building a Duplicate Prevention Program

Step 1: Standardize Invoice Entry Points

Problem: Invoices arriving via email, mail, portal, and fax create chaos.

Solution: Funnel all invoices through a single intake point: - Dedicated AP email address - Vendor submission portal - Single scanning location for paper

This is exactly what BillerPlus does—creates one front door for all vendor invoices, automatically flagging duplicates before they enter your workflow.

Step 2: Normalize Vendor Data

Create a master vendor file with: - Single, consistent vendor name - Primary vendor ID - Known invoice number patterns - Typical invoice amounts (for anomaly detection)

Step 3: Implement Matching Rules

Configure your system to check:

Step 4: Review Flagged Items Quickly

Duplicate flags lose value if they sit in a queue. Set SLAs: - Exact matches: Review within 4 hours - Probable matches: Review within 24 hours - Possible matches: Review within 48 hours

Step 5: Close the Loop with Vendors

When you catch a duplicate: 1. Document the duplicate in your system 2. Notify the vendor (prevents future resubmissions) 3. Track repeat offenders (may indicate vendor system issues)

Common Mistakes to Avoid

1. Relying Only on Invoice Numbers

Invoice numbers can vary, be missing, or be non-unique across vendors. Always use multiple matching criteria.

2. Ignoring Partial Duplicates

A $10,000 invoice and a $9,800 invoice for the same items might be duplicates with a credit applied. Check line items, not just totals.

3. Blocking All Matches Automatically

Legitimate recurring invoices (rent, subscriptions) will match. Use “flag for review” rather than “auto-reject” for amount-based matches.

4. Not Tracking Duplicate Metrics

If you’re not measuring duplicates caught, you don’t know if your controls are working. Track: - Duplicates caught per month - Duplicate rate (% of total invoices) - Duplicates that slipped through - Recovery rate for duplicate payments

Recovering Duplicate Payments

If a duplicate payment escapes:

1. Identify the duplicate through bank reconciliation or vendor statement review
2. Document everything including both invoice copies and payment records
3. Contact the vendor with specific payment references
4. Request refund or credit (credit against future invoices is often faster)
5. Update controls to prevent recurrence

Key Takeaways

• Duplicate invoices are common and costly—expect 0.1-0.5% of disbursements
• Check invoice number + vendor + amount together, not in isolation
• Centralize invoice intake to reduce entry-point duplicates
• Automate detection for volumes over 500 invoices/month
• Track metrics to measure your duplicate prevention effectiveness

BillerPlus automatically detects duplicate invoices at the point of submission—before they ever reach your approval queue. See how it works →