In short
- Duplicate vendors come from name variations, a new remit-to address, mergers and acquisitions, and setup without a search.
- Matching vendors on tax ID, bank account, address and a normalized name finds most of them.
- Once found, comparing invoices across the paired records shows what was paid twice.
- Credits on one record and bills on the other are a second leak from the same cause.
- Merging or deactivating the duplicate, and searching before every new setup, stops it.
How it happens
Duplicate vendor records rarely arrive as a clean error. They come from name variations, a new remit-to address, mergers and acquisitions, and setup without a search. A clerk receives an invoice showing Northline Packaging Co. while the vendor master has Northline Packaging. The search returns nothing obvious, so the clerk creates a new record. The next invoice under the original record is entered and paid. The duplicate check tied to a vendor record compares only within that record, so the duplicate is invisible.
A new remit-to address is a common trigger. The supplier changes its bank or lockbox, and AP adds a new vendor instead of updating the existing record because the old record has open items, belongs to another entity, or the clerk does not have change rights. Invoices then split across the records. A supplier statement or a re-sent invoice can be keyed to the other record and paid again. Mergers and acquisitions create the same pattern: a legacy record stays active while the surviving supplier is set up under a new name, and invoices arrive under each.
Setup without a search is the everyday mistake. Different punctuation, a legal suffix, a DBA, or a bank detail can make a search miss. Not every duplicate-looking record is wrong. Separate records can be legitimate for different legal entities, currencies, withholding, or remit-to arrangements. The risk is an uncontrolled duplicate with no link and no review. Credits create another leak: a supplier credit memo sits on the old record while bills arrive on the new record, so the credit stays unapplied while the bills are paid.
Finding it in your payment history
Start with the vendor master, then test the payments. Match records on tax ID, bank account, address and a normalized name. Normalize by removing punctuation, legal suffixes, and extra spacing, then compare. Bank account and tax ID are the strongest matches; address and name variations catch the rest. Create a list of suspected pairs with the evidence, and do not merge anything yet.
Once you have pairs, compare invoices across the paired records. Pull invoice number, invoice date, amount, PO number, description, payment reference, and payment status. Look for the same supplier invoice number or the same supplier reference under each record. Then search payment history for the same invoice number across vendor records, the same amount within a close date window, and the same bank account. A packaging supplier with an old and a new remit-to record is a typical case. An invoice for corrugated cartons appears under each record in the same week. Each entry passed the duplicate check because the check saw only its own vendor record. In the payment history, the invoice number and amount match, but the payment references differ. A payment cleared under the original record and a payment was released under the duplicate. That is the duplicate to recover.
Check credits at the same time. If a supplier credit memo sits on the old record and open bills sit on the new record, the credit may be unapplied while the bills are paid. Compare open debit and credit items across the pair and confirm against the supplier statement. A credit for returned cartons on the old record and a replacement invoice on the new record can look like an ordinary open credit, but the replacement invoice may already have been paid under the other record.
Watch for false positives. Recurring rent, monthly services, installments, and separate shipments can produce the same amount and similar descriptions. The same amount alone is not proof. Match invoice number, supplier reference, PO, service period, and payment reference. If the supplier uses a new invoice number for a re-issued invoice, get the supplier statement and the original invoice before you treat it as a duplicate.
Getting the money back
Validate before you contact the supplier. Pull the invoice copy, payment confirmation, remittance advice, bank statement, and supplier statement. Confirm whether the duplicate payment cleared, is still outstanding, or was returned. If it has not cleared, follow your treasury and bank process to stop or recall it. If it cleared, contact the supplier with the evidence and ask for a refund or a credit. Log the case with the invoice references, payment references, vendor records, and owner.
If the supplier agrees to a credit, get written confirmation with the invoice references and apply it to the correct vendor record. If the supplier refunds, apply the cash to the duplicate invoice and clear it. Do not leave the credit unapplied on the duplicate record, or it becomes another orphaned item. Where a credit sits on the old record and bills sit on the new record, reconcile the supplier statement and apply the credit to specific invoices. Avoid netting across unrelated legal entities. Any tax treatment of a refund or credit depends on the jurisdiction and your adviser.
Clean up after recovery. Merge or deactivate the duplicate, move open items and credits to the surviving record, and update the remit-to and bank details. Keep the history intact and document why the records existed. If the records are legitimate for separate entities or remit-to arrangements, link them and review invoices across the pair rather than merging. If the supplier offers to net the refund against future invoices, compare the financing cost of waiting with your own cost of funds and get approval before agreeing.
Stopping the next one
Search before every new vendor setup. Search tax ID, bank account, address, and normalized name. If a bank account matches an existing vendor, stop and route the request to the vendor master owner. Do not let a name spelling difference justify a new record. The setup request should carry the legal name, tax ID, remit-to address, and bank verification, so the reviewer can test it against the master.
Change the existing record when the remit-to or bank changes. Do not create a new vendor to avoid touching open items. Update the bank details with verification, review open invoices and credits, and confirm the change with the supplier through a known contact. For mergers and acquisitions, map legacy records to the surviving supplier and merge or deactivate the old records after open items are moved. Give the vendor master a named owner and review new records against tax ID, bank account, address, and normalized name on a regular schedule.
At invoice entry, search the supplier invoice number across vendor records when the vendor is new or the remit-to has changed. The per-vendor duplicate check is not enough. AP should flag any invoice whose supplier invoice number appears under another record, and a reviewer should look at invoices from known paired records before release. Use supplier statements to catch credits and re-issued invoices. Keep a recovery log and use the findings to tighten the setup form and the change process.
Questions
How do duplicate vendor records cause duplicate payments?
The same supplier invoice can be entered under each record, and the duplicate check tied to a vendor record only compares within that record. If the invoice arrives again or is sent to a different inbox, AP may key it to the other record and release payment. Matching vendor records and invoice numbers across records catches it.
How can I find duplicate vendors in my vendor master?
Match records on tax ID, bank account, address and normalized name. Start with bank account and tax ID because they are the strongest matches, then review name variations and remit-to addresses. Build a list of suspected pairs before merging anything.
What should I do if a supplier was paid twice under duplicate records?
Confirm with invoice copies, payment confirmations and the supplier statement whether the duplicate cleared. If it did, ask the supplier for a refund or credit and apply it to the correct record. If it has not cleared, follow your bank and treasury process to stop or recall it.
Should I merge or deactivate a duplicate vendor record?
Merge or deactivate only after open items, credits and payment history are moved or linked to the surviving record. Keep history intact and document why the records existed. If the duplicate is legitimate for separate entities or remit-to arrangements, link them and review invoices across the pair instead.
Updated Nov 8, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.