Finding and merging duplicate customers and vendors in QuickBooks

Duplicates are one of the quietest problems in QuickBooks. Nothing breaks — balances just split, aging reports mislead, and a customer who owes you money looks like two customers who each owe half. Here’s how to find them and clean them up safely.

How duplicates happen

• Imports that didn’t de-duplicate the source first — “ABC Ltd” and “ABC Limited” land as two records.
• Manual entry where a name was typed slightly differently the second time.
• Trailing spaces and punctuation that make identical-looking names technically different.

Why they matter

A split customer means split receivables and a broken aging report. A split vendor means payables that don’t reflect what you actually owe. Reporting, statements and collections all quietly go wrong.

How to find them

1. Sort your customer and vendor lists alphabetically and scan for near-matches sitting next to each other.
2. Run a report grouped by name and look for two entries that clearly belong to the same party.
3. Watch specifically for spacing, abbreviations (Ltd vs Limited, Co vs Company) and punctuation.

How to merge safely

QuickBooks merges two names by renaming one to exactly match the other — the records then combine, moving all history onto the survivor. Two cautions: merging is permanent and can’t be undone, and you can only merge names of the same type at the same list level. Decide which record survives, confirm both belong to the same party, then merge.