Find duplicate payments in a QuickBooks or Excel export

Exact duplicates are easy. The costly ones are near matches: same vendor and amount, invoice number typed differently.

Steps

1. Export bills or bill payments for the period to CSV (vendor, invoice number, date, amount).
2. Normalize invoice numbers: strip spaces, dashes, leading zeros and "INV".
3. Sort by vendor, then amount. Flag rows with the same vendor and amount within 30 days.
4. Flag same normalized invoice number under one vendor.
5. Review each flag with the invoice PDF before asking for a credit.

Do steps 2-4 free in your browser

Want a person to review it? The $149 one-time review shows the evidence for every flag.

FAQ

What counts as a duplicate invoice?

Same vendor with the same invoice number, or the same amount and date under slightly different numbers (e.g. INV-1001 vs 1001).

Do I have to upload my data?

No. The free checker runs in your browser.