Find duplicate supplier invoices without blocking valid repeat bills

A repeated supplier, amount, and date can flag a duplicate, but it can also describe legitimate recurring work. Compare the invoice number, legal supplier, service period, purchase order, currency, and source document. Normalize superficial differences such as spaces in invoice numbers while preserving the original value for review.

Watch for the same supplier entered under two vendor records or a revised invoice uploaded as a new bill. An email reminder may attach the original invoice again. The accounting import should not assume every attachment represents a new obligation.

A suspected duplicate can be unpaid, scheduled, in transit, or already paid. Review the payment system as well as the ledger. Canceling a bill record does not necessarily cancel a scheduled bank payment, and a payment that has left the bank should not be treated as if it never happened.

For an illustrative pair of $2,400 bills, one may cover March and the other April despite identical descriptions. If both use the same supplier invoice number and attach the same March document, the duplicate case is stronger. Confirm with the responsible buyer or supplier when the evidence remains ambiguous.

Have an authorized reviewer approve the correction and preserve the reason. Where payment has already occurred twice, track the supplier refund or credit as a separate recovery item. Do not reduce a future bill informally without agreement and supporting records.

If the duplicate affects a closed period, follow the accounting correction process. Avoid deleting a complete payment batch that contains legitimate invoices. The repair should identify exactly which obligation was duplicated and how the associated cash movement is being resolved.

Record whether the duplicate came from multiple inboxes, overlapping integrations, a manual re-entry, or a supplier revision. Add a check at that point, such as a stable external reference or a review of duplicate vendor records. A monthly spreadsheet search helps detect errors but should not be the only protection before cash leaves.

During the next payment review, inspect new candidates and confirm that the corrected record has not been imported again. Keep legitimate exceptions documented so the control does not repeatedly block ordinary monthly invoices with the same amount.