QuickBooks Customer Display Name

Why Acme Inc and Acme, Inc. are two different customers

To a person, Acme Inc, Acme, Inc. and Acme Incorporated are the same company. To any system matching on a name, they are three strings. One comma, one period or one extra space is enough to make them different.

QuickBooks itself is fine with that. All three can exist as separate customers, because none of them is an exact repeat of another. The uniqueness rule only blocks identical names, so near-duplicates sail through and sit side by side in the customer list.

The cost shows up later, in reports. Sales by Customer splits the company’s revenue across three lines. An ageing report shows three small balances instead of one real one. A customer statement run against one record leaves out the invoices on the other two. Nothing is wrong with any single record. The relationship is just spread across records nobody meant to create.

The fix is a naming convention decided once, before the list grows. Pick a form for legal suffixes, a rule for punctuation, and whether individuals are First Last or Last, First. Then hold every system that creates customers to the same rule, because a convention that only the bookkeeper follows still leaves the other systems creating near-duplicates.

The uniqueness rule, and the fixes Intuit suggests

The collision that stops people is the exact one: a supplier already called Acme Inc when you try to add a customer called Acme Inc. QuickBooks will not allow it, because the display name is shared across customers, suppliers and employees.

Intuit’s suggested ways out are practical. Find the existing record, then either rename it, for example by adding “a middle initial or a [1] at the end”, or make it inactive if it is no longer used.

Intuit also lists a cause that surprises people: turning on payroll after adding employees. The employee names then count against the same pool as customer and supplier names.

Any suffix you add changes the string. That is fine for a human picking from a dropdown. It matters as soon as another system is matching names, because a record called Acme Inc [1] no longer matches Acme Inc.

Merging duplicate customers runs through the display name

In QuickBooks, merging two customers runs through the display name itself. Intuit’s steps are to open the customer you do not want to keep, choose Merge contacts, note its display name, and “change the Display name to be an exact match of the duplicate customer profile you want to merge.” On save, QuickBooks asks you to confirm, and the two become one record with both histories.

Two cautions come with it. Intuit says to “check that neither customer has sub-customers before you merge them”, and that includes projects linked to the customer. And the merge “is permanent and can’t be undone”, so a wrong merge is fixed by hand, transaction by transaction.

Before merging a pair that a sync created, check why there are two. If the second record exists because a source system spells the name differently, merging cleans up the past and changes nothing about the next transaction, which will arrive with the same spelling.

One currency per customer, and the suffix it creates

With multicurrency switched on, QuickBooks lets you assign a single currency to each customer. Intuit’s note is that you can assign a single currency to most types of accounts, “including customers”. A customer you invoice in USD cannot also be invoiced in CAD on the same record.

Intuit’s own answer is a second customer record in the second currency, and the uniqueness rule then forces a second display name. Intuit’s instructions for that new record include the step “Add a currency to their display name, then select Save.”

So a customer list with Acme Inc and Acme Inc - CAD in it is not a duplicate to clean up. It is QuickBooks requiring one record per currency, and merging the two would undo the reason they exist.