Duplicate vendors in Xero: finding and merging them

Why duplicate vendors happen

Duplicate vendors usually start with a shortcut at data entry. A clerk receives a bill, does not find the supplier on the first search, and creates a new contact instead of checking variations. The same supplier ends up as Northwind Supply and Northwind Supply Co., or Acme and Acme Inc. Punctuation, spacing, abbreviations, legal suffixes and misspellings all create separate records. Different people set up vendors from different documents, such as a remittance address, an email signature or a statement, which compounds the problem.

Re-keyed invoice numbers are a related trap. A supplier sends INV-1043, and a later bill or credit note is keyed with 1043. Those are different strings, so a check that compares references exactly will miss the pair. The supplier invoice number appears in the Reference column when you export bills, which helps only if AP normalizes the values before comparing. If the same supplier also has two vendor records, the duplicate is harder to see because the bills sit under different contacts.

Statements paid as well as invoices are another source of duplicate payments that duplicate vendors make worse. AP pays the individual invoices, then pays the supplier statement total, or pays a statement under one vendor record while the invoices sit under another. Re-sent payment runs add to the risk: a supplier re-sends the same invoice after a query, and the bill is entered again with a new reference or no reference. These mistakes need a second check that matches on vendor, amount and date windows, not just one field.

Finding them

Start with a vendor list export from Xero or your ERP and sort it by name. Read for near matches: punctuation, spacing, "The" at the start, Inc, LLC, Co., a location suffix, or a misspelling. Then compare contact details across suspicious pairs. Shared identifiers such as a remit-to address, email domain, phone number or bank details are stronger evidence than a similar name. Do not merge on name alone; two different legal suppliers can have almost identical names.

Next, match bills and payments on vendor, amount and a date window. Export the bill list and use the Reference column, where the supplier invoice number appears. Normalize references before you compare: strip spaces, hyphens and leading prefixes so INV-1043 and 1043 are treated as the same reference. Then look for the same amount under the same vendor or similar vendor names within a short date window. This catches duplicates that an exact reference check will miss.

Use the duplicate bill review in Xero as one layer, not the whole process. Xero flags possible duplicate bills and credit notes when the Contact, Reference and Total all match. You review them from a notification or the Review duplicate bills option and choose to keep, void or delete. It does not block saving, and bills created from the same repeating template are not compared. A flagged item is a prompt to investigate; an unflagged item is not proof of cleanliness. A worked situation: one bill sits under Northwind Supply with reference INV-1043, and another under Northwind Supply Co. with reference 1043, same amount and close dates. The flag did not catch them because the contact and reference differ.

Merging vendors in Xero

Before merging, decide which record to keep. Pick the record with the correct legal supplier name, remit-to address and payment details, and the one that holds the open bills, credits and payments you want to continue using. If you are unsure whether two records are the same legal supplier, ask for a supplier statement or a remittance confirmation before you merge. A merge is easier to prevent than to unwind, even though Xero keeps an archive.

In Xero, go to Contacts > All contacts: select the contacts, choose Merge and pick the one to keep. The merged contact is archived rather than deleted and can be restored. Treat the archive as a recovery option, not a substitute for cleanup. Review open bills, unapplied credits and payments on both records first, and deal with duplicate bills through the duplicate bill review. That review is separate from the contact merge: keep, void or delete as appropriate, then confirm the kept vendor record shows the history you expect.

Do not merge records just because the names look similar. A supplier and its parent company, two divisions, or two legal entities with a shared brand can have different registration and remit-to details. Merging them can bury a real liability or a real credit under the wrong supplier. If the evidence is thin, keep both records for now and resolve the identity with the supplier. After the merge, check open bills, credits, payments and any bills still waiting for approval. If a duplicate payment went out under the archived record, ask the supplier for a credit or refund and apply it to the vendor record.

Keeping the vendor list clean

Prevent duplicates at the point of entry. Require AP to search for the supplier by name, email domain and remit-to address before creating a contact. If a new vendor request arrives, have a second person check for near matches. Standardize the naming convention: use the legal supplier name, drop trailing punctuation and avoid optional suffixes unless they are needed to tell two real entities apart. The goal is a list a clerk can scan without guessing.

Normalize invoice references on receipt. Treat INV-1043 and 1043 as the same supplier invoice number, and record the supplier's exact reference in the Reference field so exports are usable. The supplier invoice number appears in the Reference column in the export. Run a periodic match on vendor, amount and date window across bills and payments, not only on exact reference. This is how you catch re-keyed references, statement payments and re-sent payment runs before they become overpayments.

Reconcile supplier statements to the vendor record and to open bills every statement cycle. If the statement total is paid as well as the individual invoices, you have a duplicate payment waiting to happen. Use the duplicate bill review in Xero: Xero flags possible duplicate bills and credit notes when the Contact, Reference and Total all match, and you review them from a notification or the Review duplicate bills option and choose to keep, void or delete. It does not block saving, and bills from the same repeating template are not compared, so AP must still check recurring bills manually. Keep a simple recovery log for duplicate vendors and duplicate payments, and review the vendor list on a regular cadence.

Questions