Duplicate supplier invoices: how they get keyed twice and how to stop it
The same supplier invoice gets keyed twice when it arrives twice: by email and on paper, as a copy and an original, re-sent with a new date, or keyed by two people. One check stops it: before you key an invoice, look for that supplier’s own invoice number in what you have already keyed for them.
Last checked against eStream’s SQL Accounting documentation (the Supplier usage guide).
Five ways one invoice comes in twice
- The supplier emails a PDF, and the original arrives later with the goods. Each looks new to whoever opens it.
- A faxed or photographed copy is keyed so the bill is not late, and then the original turns up.
- The supplier sends the invoice again with a reminder when it is overdue, sometimes with a new date printed on it.
- One clerk keys it from the shared inbox while another keys it from the paper file, or a branch keys what head office already has.
- The supplier’s statement lists the invoice again, and someone keys that line as if it were a new invoice.
The one number that catches it
Every supplier numbers its own invoices. That number, together with the supplier, is what makes an invoice unique. The amount is not enough: two invoices from the same supplier can be for the same amount, and one invoice re-sent can carry a different date.
So the check is always the same. Before you key an invoice, look for that supplier’s invoice number among what you have already keyed for them. If it is there, stop and compare the two papers.
Watch for the same number written differently: INV-0045, INV 0045 and inv0045 are one invoice.
Habits that stop it
- Send supplier invoices to one inbox or one tray, and file the paper that arrives later with the email it repeats.
- Make the number check the first step, before any typing.
- Mark each invoice as keyed the moment it is in: write your own document number on the paper, or move the PDF to a “keyed” folder.
- When two people key, split the work by supplier, so the same invoice cannot reach both of them.
- Use the supplier’s statement as a checklist. Tick each line against what you have keyed, and key a missing invoice only from the invoice itself.
When it has already happened
Find both entries for the supplier’s invoice number. Keep the one that matches the paper you file, and do not delete the other on your own: ask the person who looks after your accounts how they want it reversed, because a payment may already be knocked off against it.
Then find out which of the five ways let it in, and close that gap.
The full checklist for a supplier invoice puts this check third, after the buyer and the supplier, and before the sums.