Duplicate Customer Records: How They Happen and How to Stop Them

Search your customer list for a common last name. If you find "Maria Lopez", "M. Lopez" and "Lopez, Maria - 14 Oak St", you have duplicate customer records. Every service business has them. They're rarely anyone's fault, but they quietly cost you in ways that show up at the worst moment.

Here's where they come from, what they cost, and how to stop new ones.

How duplicates happen

Duplicates come from any place a customer enters your system without someone checking whether they're already there:

• Phone bookings under pressure. The phone's ringing, and the dispatcher types a new customer rather than searching for the old one.
• Web forms and booking apps. A customer fills in a form on your website or a separate booking app. Someone retypes it into your software, and it's easier to create a new record than to hunt for a match.
• Different names for the same account. "Maria Lopez" books the tune-up. "Carlos Lopez" calls about the water heater. Same house, two records.
• Property managers and landlords. One manager, twelve properties, and a new customer record every time a tenant calls.
• Typos and formatting. "Oak St" vs "Oak Street", a missing apartment number, a phone number with and without the area code.

The more places customers can come in, the more duplicates you get. Adding online booking in a separate app, without a check for existing customers, adds one more door.

What duplicates cost

Nobody tracks "duplicate record cost" on a P&L, but you pay it:

• Split service history. Half the history is on one record and half on the other. The technician going out today doesn't see that the last visit found a cracked heat exchanger.
• Wrong agreement coverage. If a customer's maintenance agreement is on one record and today's visit is on the other, the office may bill for work the agreement covers. That's an unhappy customer right before renewal.
• Double mailings and reminders. Two seasonal reminders to the same house looks careless.
• Bad reporting. Your "new customers this month" number is inflated, and your repeat-customer rate looks worse than it is.
• Wasted office time. Every time someone notices a duplicate, they stop and sort it out.

This isn't only a small-business problem. In Validity's 2025 survey of 602 CRM users, 76% said less than half of their organization's CRM data is accurate and complete, and 37% said they'd lost revenue as a direct result of poor data quality. In a Harvard Business Review study where 75 executives scored their own data, on average, 47% of newly created data records had at least one critical error. New records are where errors start.

Cleaning up what you have

You won't fix years of duplicates in an afternoon, and you don't need to. Start where it matters:

1. Start with your best customers. Pull your agreement customers and your top repeat customers, and check each one for a twin.
2. Search by phone number and service address, not by name. Names vary. Phone numbers and addresses usually don't.
3. Merge into the record with the most history. Keep the older record and move visits, notes and equipment onto it. Use your software's merge tool if it has one.
4. Decide how to handle households and property managers. One account with several service locations is usually cleaner than one record per person.
5. Do a little every week. Fifteen minutes on Friday beats a cleanup project nobody finishes.

Stopping new ones at the door

Cleanup helps, but duplicates keep coming unless you close the doors they come through.

Search before you create. Make "search by phone first" the rule for every phone booking. It takes five seconds.

Standardize how you enter things. Pick one format for phone numbers and addresses. Many duplicates are formatting differences.

Don't retype web bookings. This is the big one. If online requests arrive in a separate booking app and get copied into your field service software by hand, every one is a chance to create a duplicate. The fix is booking that happens inside the same system as your customer list, where each request is checked against your existing customers instead of copied over. Why your booking app and field service software should be the same tool covers the rest of that problem.

Use service locations. If your software lets one customer account hold several properties, set property managers up that way.

Write the rules down

Duplicates come back when the rules live in one person's head. A half-page policy the whole office follows does more than any cleanup. Here's a starting point to adapt:

1. Every new booking starts with a search. Phone number first, then service address. Only create a customer if both come up empty.
2. One format for phone numbers. Ten digits, no spaces or dashes. Your software may do this for you.
3. One format for addresses. Spell out or abbreviate street types, but pick one. Always include the unit number.
4. Households are one account. Add the second person as a contact on the same account, not as a new customer.
5. Property managers get one account with multiple locations. Each property is a service location, not a new customer.
6. Found a duplicate? Merge it the same day, or flag it for Friday's cleanup. Don't leave it for "later".
7. No retyping from other systems. If a booking has to be copied from another app, that's the process to fix first.

Share it with anyone who answers the phone or books visits, including the owner. The owner is often the one creating records from the truck at 6 PM.

How FSM Navigator handles it

FSM Navigator's online booking page (Pro and Enterprise plans) is part of the same system as your customer list, so there's no separate booking app to copy from. Website requests land in your Service Requests list, and your staff get an email when one arrives.

When staff approve a request, they link it to an existing customer or create a new one, and FSM Navigator checks for an existing customer with the same contact details. The request then becomes a scheduled visit, and the customer is emailed that it's approved. You can build the page and preview it in the app during a 14-day Pro trial, and it goes live after the trial. New to the category? Start with what field service management software does.