Three Contact Lists in Three Places (And Nobody Knows Which One Is Right)

A client called me because her team was missing follow-ups on sales leads. Not a policy problem. Not a motivation problem. They simply didn't know who had been contacted and who hadn't.

I asked where they kept their leads.

"Everywhere," she said.

That was accurate.

QuickBooks had customers and historical transactions, so new leads sometimes got entered there first. Mailchimp had an old list from a campaign they'd run three years ago, which had never been fully migrated or archived. Google Sheets had the current pipeline — well, current as of last Tuesday, maybe — because someone had built a tracking system there when the team outgrew their memory.

A prospect who came in through an email sequence would be in Mailchimp. Same person as a potential customer would be in the Sheets. The same person as an existing customer (if they'd ever bought anything) would be in QuickBooks.

Three systems. Three sources of truth. Three places to get contradictory answers.

What this actually costs

It's not the data entry time, though there was plenty of that.

It's the follow-ups that never happened because nobody was sure if they'd already happened. It's the person who saw the lead, thought they'd passed it to someone else, and nobody ever did. It's the prospect who got contacted twice in three days from different team members who didn't know the other person had already called.

It's the proposal that got built on outdated information because the email list and the spreadsheet were two weeks out of sync.

How it happens

It never starts as a mess. It starts with one system that works fine, then a new tool gets added for a specific need. That tool doesn't talk to the first one, so you keep both. Then a third tool comes along that seems like a better fit for another piece of the workflow, and you add it without fully decommissioning the second.

By the time someone notices there's a problem, the data has diverged enough that you can't just pick one system and move everything over. You'd lose information. So you keep using all three, which means you're now maintaining three separate datasets about the same people.

This is exactly how "contacts v4 FINAL-new" gets created: it's not that the spreadsheet is the real system. It's that the spreadsheet is the most recent attempt to make sense of the three systems that didn't work.

The consolidation problem

The honest answer is: it's complicated to fix once it's scattered.

You can't just export everything from QuickBooks, Mailchimp, and Sheets and throw it all into one place. They structure data differently. Email records don't match. Customer names are inconsistent — "John Smith" vs "J Smith" vs "JS Consulting." Phone numbers have different formats.

You need someone to do the matching. Someone to decide which record is the real one. Someone to build the transition without losing the historical information.

That's time. That's frustration. That's why most businesses don't do it.

What prevents this

The only real prevention is deciding early: one system is the source of truth. Everything else pulls data from it or syncs to it.

Not every business needs a full CRM. But every business needs one place where "who is this person and what have we said to them" has a clear answer.

If you're at three or fewer people, that can be a well-maintained spreadsheet and a stack of discipline.

If you're at more than three people, you need something that the whole team can see in real time. And you need to commit to not starting a fourth system "just for this one thing."

The other cost

There's also the second-order cost: the team stops trusting the data. When nobody's sure if a contact exists in the right place, people start remembering things manually. They store phone numbers in their own notes. They keep email addresses in a personal file. You've now solved the fragmentation problem by adding five more fragmented sources.

This is why the audit matters. Not to judge anyone for "letting it get messy." But to see: where is the truth right now? And what would it take to make sure the next decision doesn't multiply it again?