Does this sound familiar?
These are the signs that your departments are working from different numbers because they are working from different copies of the data.
Sales, operations, and finance each bring their own figures to the meeting, and no two of them match.
The first part of every review is spent reconciling numbers instead of deciding anything.
Each team maintains its own spreadsheet, pulled from its own system, updated on its own schedule.
The same metric has different definitions in different departments, so revenue or units mean different things.
Someone is asked to go away and reconcile the numbers, and the answer arrives days after the decision was needed.
Leadership no longer knows which report to believe, so decisions wait for a tiebreaker that never fully settles it.
People keep private versions of the data because they do not trust the official one.
A number that everyone agreed on last month cannot be reproduced this month, because the source it came from has already changed.
Why each team ends up with its own version
No one sets out to create three conflicting versions of the truth. It happens because each department has its own system and its own copy of the data. Sales lives in the CRM. Operations runs on a warehouse or production spreadsheet. Finance works from the accounting system. Each team exports what it needs, filters it, and shapes it to answer its own questions.
So when everyone says they are using the same data, they are not. They are using separate extracts, pulled at different moments, adjusted with different assumptions about what counts and when. Sales counts a booking the day the deal is signed. Finance counts the revenue when it is recognized. Operations counts the units when they ship. All three are reasonable, and all three produce different numbers from what is supposedly the same reality.
That is why it never resolves through better communication or more careful analysts. As long as the data lives in separate places and gets assembled separately, the versions will keep diverging, no matter how capable or well-intentioned the people are.
The real cost is measured in meetings and trust
The first cost shows up on the calendar. When each department arrives with different numbers, the meeting stops being about what to do and becomes about whose figure is correct. Time that should go to deciding goes to reconciling, and the actual decision gets pushed to the next meeting, after someone has gone away to sort out the discrepancy.
The second cost is deeper and harder to reverse. Every time leadership acts on a number that later turns out to be wrong, a little trust in the reporting dies. Eventually no report is taken at face value. Everything gets double-checked, decisions slow to a crawl, and people start keeping their own private spreadsheets so they at least trust their own copy. That instinct is understandable, and it makes the fragmentation worse, because now there are even more versions of the truth in circulation.
A business cannot move quickly when it does not trust its own numbers. The disagreement between departments is not a personality issue to be smoothed over. It is a tax on every decision the leadership team tries to make.
What a single source of truth actually requires
A single source of truth is not a better report or a shared folder. It is a structural condition: sales, operations, and finance all reading from the same live system instead of from separate copies. When that condition is met, the numbers agree on their own, because there is only one set of numbers.
In practice that means a transaction is entered once and is immediately visible to everyone with the right access, rather than re-keyed into each department's system. It means reports are generated from that shared data instead of rebuilt from exports that were current at different times. And it means the definitions of key metrics, what counts as revenue, what counts as a unit, when something is recognized, are consistent across teams rather than quietly different.
That is the shift: from three departments defending three versions to one organization looking at one picture. It does not come from asking people to try harder to agree. It comes from removing the separate copies that made agreement impossible.
Questions we hear most often
Why does each department end up with different numbers?
Because each department keeps its own copy of the data. Sales works from the CRM, operations from a warehouse spreadsheet, and finance from the accounting system, and each one exports, filters, and adjusts that data in its own way. Even when everyone believes they are using the same data, they are actually using separate extracts pulled at different moments and shaped by different assumptions. The numbers do not match because there is no shared system underneath them, only copies.
Is this a people problem or a systems problem?
It is almost always a systems problem. When capable people who trust each other still show up with different numbers, the issue is not effort or honesty. It is that the organization has no single source of truth, so each team is left to assemble its own version. You cannot train your way out of that. As long as the data lives in separate places, the numbers will keep diverging no matter how careful everyone is.
What does this cost beyond the awkward meetings?
The most visible cost is meeting time spent reconciling instead of deciding. Instead of debating what to do, the room debates whose number is right. The deeper cost is eroded trust: once leadership has been burned by a number that turned out to be wrong, every report gets second-guessed, decisions slow down, and people start keeping their own private spreadsheets to feel safe, which makes the fragmentation worse.
What does a single source of truth actually require?
It requires that sales, operations, and finance all read from the same live system rather than from separate copies. Transactions are entered once and are immediately visible to everyone with the right access, reports are generated from that shared data instead of rebuilt from exports, and definitions like revenue, margin, and units are consistent across teams. When the underlying data is shared, the numbers match on their own, without a reconciliation step before every meeting.
Related problems
- Why a simple report takes days to pull togetherThe manual assembly that leaves every report stale before it is read.
- Consolidating multiple entities and companiesWhy multi-entity reporting drags on and breaks down as you grow.
- Why your month end close takes two weeksThe specific tasks that eat the time, and what actually shortens a close.
- When running your business on spreadsheets stops workingThe point where spreadsheets quietly turn into a liability.
Find out why your numbers do not line up
See where your data is fragmenting across teams. The free readiness tools cover reporting, system integration, and data trust in just a few minutes.
No sales pitch. No vendor push. Just a clear picture of where your systems stand.