Duplicate vendors in QuickBooks Online: finding and merging them

Why duplicate vendors happen

Duplicate vendors usually start as a shortcut. A clerk cannot find the supplier under the name on the invoice, so creates a new record. The same supplier ends up as Northline Supply and Northline Supply Inc., or with punctuation and spacing differences. Both records look valid, and bills, payments and credits split between them.

Re-keyed invoice numbers make it worse. A supplier prints INV-1043; one clerk enters 1043, then later another clerk enters INV-1043 and uses a second vendor record. In QuickBooks Online, the preference under Account and Settings > Advanced > Other preferences warns when a bill number already used for that vendor is entered again. It warns; it does not stop the bill being saved. The warning is tied to the vendor, so a second record can hide the repeat.

Statements paid as well as invoices and re-sent payment runs add more copies. If AP pays from a statement and then pays the invoice, or re-sends a payment run after a bank file issue, the same bill or payment can appear twice. Under duplicate vendor records, the second item sits under a different name, so statement reconciliation and vendor balance review do not line up. The common mistake is treating a statement as a bill; the catch is to match every statement line to an open bill before paying.

Finding them

Start with a normalized vendor list. Compare names with case, punctuation and suffixes ignored, and look for the same remit-to address or tax ID under two records. Search exact invoice strings such as INV-1043 and 1043. If INV-1043 sits under Northline Supply and 1043 sits under Northline Supply Inc., with the same amount and nearby dates, you likely have a duplicate vendor and a duplicate bill. Matching on vendor, amount and date windows is the practical test.

Reconcile supplier statements to open bills. When a statement total does not agree with open bills in QuickBooks Online, do not pay the difference. Trace each statement line to a bill; a line with no open bill may already have been paid under a duplicate vendor. Check re-sent payment runs the same way: compare payment date, amount and vendor, and investigate any payment that appears twice under two vendor records.

Use the preference warning as a prompt, not a control. In QuickBooks Online, the preference under Account and Settings > Advanced > Other preferences warns when a bill number already used for that vendor is entered again. It warns; it does not stop the bill being saved. Train clerks to stop and search both the vendor record and the invoice number when the warning appears. Also check unapplied vendor credits; a credit under the duplicate vendor is easy to miss.

Merging vendors in QuickBooks Online

Before merging, decide which vendor to keep. The kept record should have the correct remit-to address, terms and the transactions you want to retain. Pull open bills, payments and credits for both records. Because a merge cannot be undone, note what you expect to move, including any unapplied credit.

In QuickBooks Online, duplicate vendors are merged from the vendor's Edit menu with Merge contacts: the duplicate becomes inactive and its transactions move to the vendor you keep. A merge cannot be undone. If you merge the wrong way, the transactions still move, but to the wrong record, and correcting that is manual cleanup. Verify the direction before you merge.

A merge moves transactions; it does not resolve duplicate bills or duplicate payments. If INV-1043 and 1043 both sit under the kept vendor after the merge, one bill still needs a void or a supplier credit. If two payments went out, ask the supplier for a credit back and apply it to the next bill. Do not net the credit silently against unrelated invoices.

Keeping the vendor list clean

Control vendor creation at the source. Before adding a vendor, search partial names, the name on the invoice and the remit-to name. Standardize naming for suffixes and punctuation. Enter invoice numbers exactly as printed: if the supplier sends INV-1043, do not also enter 1043. That one habit prevents many duplicate vendor and duplicate bill pairs.

Match statements to open bills before paying, and never pay a statement total without tracing the lines. On re-sent payment runs, compare the new run with the prior run on vendor, amount and date before releasing it. Review vendor credits regularly; an unapplied credit under a duplicate vendor is money sitting idle. When a duplicate payment is found, ask the supplier for a credit back and apply it to the next bill.

Run a periodic vendor master review for near-duplicate names, the same tax ID and the same remit-to address. Merge only after checking open transactions. Keep a note of each merge, because a merge cannot be undone. Train new clerks to search first and to treat the bill-number warning as a reason to stop and look, not as approval to save.

Questions