A rep pulls out of a customer's yard and says the company's name into their phone. They know exactly which customer they mean: the one with the shop by the interstate and the parts order that's been slipping. The system they're talking to has three companies with that name. Which one gets the note?
Sometimes the wrong one. Notes land on the wrong account when a system matches on a name, and names repeat. Duplicate customer records are where that starts. For the manager, it shows up on Monday: the owner asks how the week went, and you can't tell which of the week's records to trust.
How one customer becomes three records
Nobody plans for duplicates. They show up one at a time, and each one made sense the day it was created.
The customer with more than one location
Picture a fleet with yards in two towns and a shop in a third. The parts counter at one dealer location opens a record. Months later, someone at another location searches, misses it because the name was abbreviated, and opens a second one. A rep adds a third from a business card that spells the name out in full. Now the same buyer, the same trucks, and the same standing parts order live in three places.
Some duplicates are there on purpose. A dealer may keep a parts account and a service account for the same company, with the same name and the same address, because the work is billed differently. That's a sound setup. It just means the name alone can't tell the two apart.
Add a second system and it gets harder. The name in your business system is spelled one way. The name in your sales records is spelled another. Both are correct, and neither matches.
The name that sounds like a word
Some companies are named after a place, a landmark, or an everyday word. Say one out loud at the end of a stop and it could fit several customers in the territory. A rep can tell them apart by the street, the trucks, and the person at the counter. A system matching on the name can't.
None of this is anyone's mistake. It's what happens when a name has to do the job of an ID.
What a manager loses when the note is on the wrong account
The duplicate record is a nuisance. The bigger cost shows up in the weekly review.
- The visit counts for the wrong account. The customer you were worried about looks like nobody has been there in weeks, even though the rep stopped by Tuesday.
- The follow-up goes to the wrong place. A task to send a quote lands on a record nobody watches, so the quote doesn't go out.
- The review turns into an argument. The rep says they were there. The record says they weren't. Now you're debating whose list is right instead of coaching.
The rep loses too. They made the stop, drove the miles, and heard the news at the counter. If the note lands on a record that isn't the account, their work doesn't show up where it counts. Watch that happen a few times and anyone would start skipping the write-up. It's one reason reps stop trusting their notes.
For a manager, it changes what you can see. A clear view of the week depends on every visit sitting on the account it belongs to. When some don't, you coach from a picture that's partly wrong, and you can't tell which part.
Why cleanup by hand doesn't last
If you run a Friday merge, a shared spreadsheet, or a "search before you create" rule, you're not doing it wrong. Those fixes work for a while.
The trouble is that cleanup happens after the fact, and new duplicates keep arriving. Someone opens a record at the counter. A rep adds one from the road. A new location comes online with its own spellings. The person doing the merging rarely has time to spare, and a merge can lose history when two records disagree.
And merging can't help with the parts account and the service account. Those are supposed to stay separate.
So hand cleanup is a stopgap. It helps to know how big the gap is before you decide how much effort to put in.
Check your own records in 15 minutes
All it takes is a Monday morning and your own data.
- Pick your five biggest fleet or distributor accounts.
- Pull the last 20 visit notes logged to those five accounts. Add any note a rep says they wrote that you can't find.
- Check each note against the account number in the system you bill from, whether that's your DMS, your ERP, or something else. That number is the one thing that doesn't repeat.
- Count the misses. A miss is a note on the wrong account, a note on a duplicate, or a note you can't find at all.
- Write down the cause of each miss. Was it a second location, a spelling, a name that's an everyday word, two accounts kept apart on purpose, or a record someone created twice?
When you're done, you'll have a miss count that belongs to your team and a short list of causes. If one or two causes keep coming up, that's where to point the cleanup. It also gives you something concrete to bring to your parts manager or sales ops lead.
Do it with a rep alongside you if you can. Reps know which customer is which. Ask how they'd say each name at the end of a stop. That's the version your records have to cope with.
What an account number changes
A name repeats. An account number doesn't. Two customers can share a name, two locations can share a street, and one customer can go by three spellings. But each account has its own number in the system you bill from.
So the lasting fix for duplicate customer records starts with a key that doesn't repeat, not a better guess at the name. A guess will sometimes be wrong, and it's easy to miss the visit you most wanted on the record.
Where Voze puts the account number
Dealer teams told us they keep same-name companies separate on purpose, and their reps only know which is which by the account number. Some reps were typing that number into memo fields just to keep accounts straight. So we put it where reps can see it.
In Voze Pro, when a company comes from your third-party system with an account ID, that ID shows on the company card in Find and in the list when you pick a company. It's also under the name on Company details and on the Info tab. Reps can search Find by the number, or part of it, and check which account is which before they log the note. Companies without an account ID look the same as before. Read the account ID update.
Capture the visit at the stop, on the account it belongs to, and it's on the record after.
If you run parts or service sales at a heavy-duty dealer and want more posts like this, follow Voze on LinkedIn.