Which Number Is Right? Why One Source of Truth Comes First

Early in my career, I ran sales for a B2B solutions business. Before I could fix anything else, I had to answer a simple question: which information was right?

It wasn’t easy. Customer contacts lived in ACT!. Orders and accounting lived in SAP. Pricing, equipment specs and customer details were scattered across spreadsheets and Word documents. On top of that, we collected usage data from customers that had to be checked carefully before every bill went out.

The same information was duplicated in different places, and each department kept its own version. Finding the correct answer often took hours of comparing records and fact-checking. Even then, billing errors happened far too often.

So that’s where I started.

The hidden cost of “which one is right?”

Scattered data rarely looks like a crisis. It looks like small delays, all day long:

Time lost hunting. People search two or three places before they trust an answer.
Double entry. The same information gets typed in more than once, and every extra copy is another chance for an error.
Billing mistakes. When the numbers behind an invoice don’t match, customers get the wrong bill, and fixing it costs time and goodwill.
Decisions on bad numbers. Quotes, forecasts and reports are only as good as the data behind them.

Each one seems minor. Add them up across a team and a year, and it’s a lot of hours spent checking work instead of doing it.

Why it happens

Nobody sets out to build a mess. A business grows, and each team picks a tool that solves its own problem. A spreadsheet here, a new system there. Each one makes sense on its own.

Over time, the same information ends up living in several places, and none of them match. No one owns the whole picture, so no one fixes it.

What we built

We didn’t have a modern CRM, so I built what we needed in Excel: one central database for pricing, equipment models, specs and the consumables for each piece of equipment, with costs. Then I set up a digital filing system for customer records, so anyone could find what they needed in seconds.

It wasn’t fancy. But for the first time, everyone worked from the same numbers.

With that foundation in place, I rebuilt our pricing, streamlined the proposals and automated the reporting that used to eat hours every week. Over the next four years, my department’s revenue doubled from $7M to $14M. Over the following six, it grew to $25M.

Clean data didn’t do that on its own. But none of the other improvements would have held up on top of numbers nobody trusted.

Same problem, bigger scale

Years later, as VP of Sales & Marketing for a national franchisor with more than 50 locations, I ran into the same problem. Sales data was spread across dozens of independent franchisees, and headquarters couldn’t see the full picture.

This time the tools were better. I implemented Salesforce so every franchisee’s sales data flowed to headquarters, while each franchisee’s data stayed secure from their peers. One source of truth for HQ, and privacy for every owner.

How to start building one source of truth

The tool matters less than you’d think. I did it in Excel. You don’t need a big software project. Start here:

List the information everyone depends on. Customers, pricing, jobs, inventory. Keep it short.
Find every place it lives. Every system, spreadsheet and document. You’ll probably be surprised.
Pick one home for each piece. One place is the official version. Everything else reads from it or goes away.
Ask the people who use it. They know which copies they trust and which ones they work around.
Build it into the work. Make the official source the easiest place to look, so no one is tempted to keep a side copy.

A question worth asking

Ask your team one question this week: how long does it take you to find the right answer?

If the answer involves checking more than one place, you’ve found a bottleneck worth fixing.

That’s the work I do at Younify: find where the business depends on memory, workarounds and duplicate data, then build simple systems into the daily work so the right information is always one click away.

Not sure where your bottlenecks are? Take the 2-Minute Bottleneck Check. No sign-up. Instant results.