Duplicate Invoice Checker

Upload your AP or payment export. Find likely duplicates, review the evidence, and download the flagged pairs.

Free to use · No signup · Your records stay in your browser

No file selected

Start with an invoice or payment export.

Include vendor, date and amount. Invoice numbers strengthen the match. Import invoices or payments separately, or map a record-type column to distinguish them.

Drop your spreadsheet hereor choose a file from your deviceCSV or XLSX · Up to 20 MB, 50,000 rows and 60 columns

(synthetic data)

How the matching works.

Vendor names are normalized for case, accents, punctuation and spacing. Invoice numbers are normalized for case and punctuation, preserving leading zeros. Currencies use recognized ISO codes, and amounts are compared exactly at each currency’s decimal precision.

Candidate groups use vendor, reference, currency, record type and amount. Close-date rules use a fixed seven-day window. A spelling variant means one inserted, deleted or substituted character, with at least five characters in each name or reference.

For manual checks, read how to find duplicate invoices in Excel.

  1. High risk

    Same normalized vendor, invoice reference, currency and amount, with dates no more than seven days apart.

  2. Medium risk

    Same vendor and reference with different amounts or dates farther apart; or exact amount and close dates with a one-character invoice variant; or exact reference and amount with a one-character vendor variant and close dates.

  3. Low risk

    Same vendor, currency and amount within seven days, with different or missing references. Legitimate repeat purchases can trigger this rule.

Before you review.

What about recurring monthly charges?

The same vendor charging $500 in successive months with different invoice numbers is not flagged on amount alone. If a reference is reused, the pair appears at medium risk when dates are more than seven days apart. Confirm the billing periods before deciding.

Can I check duplicate payments?

Yes. Import a payment export and map the underlying invoice number when available. A repeated invoice may represent a partial payment or a repeated export row, not two payments. Confirm payment IDs and bank evidence. Keep invoice and payment rows separate, or map a consistently named record-type column.

Are my records uploaded or saved?

No. Files are read by a worker in your browser. Records are never sent to Beckmont or saved in browser storage. Clear the session or close the tab to release the tool’s data. Downloaded files remain on your device.

What can this miss?

It cannot prove fraud or find every duplicate. Unrelated vendor aliases, multi-character typos, different amounts and different references can be missed. It excludes zero amounts and comparisons between different currencies, signs or record types. Very dense candidate groups stop with an error rather than incomplete results: split the export by vendor or period. Limits are one million comparisons and 10,000 flagged pairs.