How to detect duplicate invoices before and after payment
A duplicate invoice is a second document for something that has already been billed. Exact duplicates share supplier, invoice number and gross amount and are found by comparing a normalised invoice number. Near duplicates carry a different number but the same supplier, amount and date, and need a look at the order before anyone decides. A credit note over the same amount cancels the match. A duplicate found before payment is avoided, one found after payment is recovered once, by refund or credit note.
A duplicate invoice is a second document for a delivery or service that has already been billed. Often no fraud is involved: a supplier resends an unpaid invoice, a reminder carries a copy, the same PDF arrives by post and by email. They are found by comparing each invoice with the earlier ones of the same supplier, on rules strict enough to be automatic and loose enough to see through different spellings.
How duplicates get into the books
| Route | What it looks like |
|---|---|
| Two channels | The same invoice by post and by email, entered by two people |
| Reminder with a copy | The copy attached to a dunning letter is entered as a new invoice |
| Resent on request | "Please send it again" produces a second original, sometimes with a new date |
| Corrected invoice | A new number for the same delivery, without a credit note for the first |
| Two supplier records | The same supplier exists twice in the master data, so each invoice looks new |
| Two entities or sites | Head office and the plant both receive and enter it |
The last two matter for the method: a duplicate check that runs per supplier record only works when one supplier is one record. Match suppliers by VAT identification number first and by a normalised name second, with legal forms such as GmbH or Ltd removed.
Exact duplicates: supplier, number, amount
The first rule is strict: same supplier, same invoice number, same gross amount. Its weak point is the number, because people and scanners write it differently. Normalise it before comparing:
- Lower case, and accented letters to their base letters.
- Everything that is not a letter or a digit becomes a separator.
- Leading zeros of each part are dropped.
- The parts are joined.
RE-2026/0042 → re202642
re2026 42 → re202642
RE 2026-042 → re202642
RE-2026/0042-K → re202642k (a different document: check what K means)Keep the amount in the key. Two documents with the same number and different amounts are usually an invoice and its correction, and belong to the arithmetic and price checks, not to this one.
Near duplicates: same amount, same date, different number
The second rule finds what the first cannot: the same supplier, the same gross amount and the same invoice date under two different numbers. This is the typical trace of one delivery billed twice by two people at the supplier, or of an invoice reissued under a new number.
It is a candidate, not a verdict. Two genuine deliveries on one day at the same price exist. So the rule ends in a question, answered from the order and the delivery note: were there two deliveries? Treat the result with less confidence than an exact match and never deduct on it without that look.
Rules that go further, such as "similar amount within a few days", produce many candidates and few duplicates. Monthly fees would match every month. If you add such a rule, restrict it to suppliers without recurring billing.
What cancels a match
A credit note from the same supplier over the same amount means the supplier has already taken the second document back. Pair each credit note with one duplicate and remove that pair from the list. Without this step the list fills with cases that are settled, and people stop reading it.
Also outside the rule:
- Instalments and part invoices. Same order, different numbers, amounts that add up to the order value.
- Recurring fees. Same amount every month under a new number and a new date.
- Invoices of zero or negative amount. They are corrections, not claims.
Before payment and after payment
The same match has two meanings, depending on when it is found.
| Found | The amount is | What to do |
|---|---|---|
| Before the second document is paid | Avoided | Reject the copy with a reference to the original, so it leaves the payment proposal |
| After both were paid | Recoverable, once | Ask the supplier for a refund or a credit note and track it until it arrives |
A worked example with invented figures: a supplier's invoice over 4,760.00 gross arrives by email in March and again in April as an attachment to a reminder. Both are entered. The amount billed more than once is 1 × 4,760.00. Had a third copy been entered, it would be 2 × 4,760.00: every copy after the first.
That amount is found once. It is not a yearly saving and must not be multiplied by twelve in any report. How to keep one-off recoveries apart from recurring savings is covered in proving procurement savings.
Fixing the cause
- Give invoices one way in. A shared mailbox or an ingest address is better than five personal inboxes.
- Recognise the same file. Identical bytes are the same document, whatever the file is called.
- Clean the supplier master data and merge double records.
- Ask suppliers who send many copies to stop attaching invoices to reminders.
- Prefer structured e-invoices: the number arrives as data and nobody mistypes it.
The duplicate check is one of six on the invoice audit checklist. It sits next to the check for changed bank details, because a "resent" invoice with a new account is a different matter altogether.
How Cureman does it
Cureman recognises the same file uploaded twice as one invoice. Across the invoices on record, it matches suppliers by VAT identification number and then by normalised name, and looks for duplicates on the two rules above: same supplier, normalised number and gross amount, or same supplier, gross amount and invoice date under a different number. The second kind is shown with lower confidence and a note that it needs a look at the order. A credit note over the same amount cancels a match.
Each finding lists the documents in the order they were received and shows the calculation: number of copies after the first times the gross amount. The amount is labelled as recoverable once and never added to yearly savings. Payments are not known to the system, so the finding says that the amount is recoverable if the copy was paid and avoidable if it was not. If one of the documents was read by a model and has not been reviewed by a person, the finding says so and asks for the reading to be checked first. A person rejects the copy or claims the money; the module is described under invoice audit and spend analysis.
Questions and answers
How do you find duplicate invoices?
- Compare every new invoice with the earlier invoices of the same supplier on two keys. The first is the invoice number in a normalised form, without separators and leading zeros, together with the gross amount. The second is the gross amount together with the invoice date, for documents whose numbers differ. The first key gives near-certain duplicates, the second gives candidates that a person checks against the order.
Why does the accounting system not catch every duplicate invoice?
- Many systems compare the invoice number exactly as typed. A number entered once with a hyphen and once without, a supplier that exists under two master records, or a resent invoice with a new number all pass that test. A comparison on normalised numbers and on amount and date closes most of these gaps.
What should be done when a duplicate invoice has already been paid?
- Write to the supplier, name both documents with their numbers, amounts and payment dates, and ask for a refund or a credit note. A credit note is the usual answer and is set off against the next invoice. Record the request and the reply, because the amount counts as recovered only when the credit note or the money has arrived.
Are two invoices with the same amount always duplicates?
- No. Monthly fees, instalments and repeat orders produce equal amounts legitimately. That is why the amount alone is no rule. Same supplier, same amount and same invoice date under two different numbers is a strong hint, and even then the order and the delivery note decide.