Free Excel tool · with dashboard

Find duplicate invoices before they're paid

Paste in your invoice list and get a clear dashboard in five minutes: what's at risk, what to hold, and what to check first — including the duplicates your accounting system lets through.

  • Same invoice number typed differently — "INV-00123" vs "123"
  • Same supplier, same amount, same date under a new invoice number
  • The same amount billed again within 30 days
  • One invoice keyed under two supplier records
  • Dashboard with value at risk, charts and a prioritised action list

Get the free checker

Works in Excel with exports from SAP, NetSuite, Xero, QuickBooks or Sage. Up to 1,000 invoices.

You'll also receive occasional short emails on AP and month-end controls. Unsubscribe any time. See our privacy policy.
Excel fileNo macrosFormulas locked

Your results, on one dashboard

The first tab you open. Headline figures, the duplicate tests at a glance, and an action list of the invoices to hold before your next payment run.

Duplicate Invoice Checker dashboard showing invoices scanned, action required, value at risk, flags by test, result mix and an action list
Value at riskThe total you could pay twice, in one number.
Action listThe invoices to hold, most serious first.
Four testsThe patterns behind most duplicate payments.
Locked formulasPaste, read, act. Nothing to break.

How it works

1ExportPull supplier, invoice number, date and amount from your system or payment run.
2PasteDrop the list into the light teal columns. The four tests run instantly and are locked, so nothing breaks.
3ActOpen the Overview tab. HIGH flags are almost certainly duplicates: hold them. REVIEW flags need a quick check.
Accounts Payable Control System

Stop duplicates before they're paid, every run

The full system adds a payment release gate, approvals and a sign-off block, so flagged items can't slip into a payment run unchecked.

See the AP Control System
More free tools

Spot fake supplier emails, score a risky payment, test your month-end close and measure cash tied up in late payers.

See all free tools