Every company says it wants a single source of truth. Few can say what it is. The phrase suggests one giant system that holds everything, and building that is rarely the answer.
A single source of truth is not one system. It is one agreed definition for each number that matters, calculated in one place, that everyone reads from.
What it is not
It is not one database that contains all your data. Most businesses will always have an ERP, a CRM, a few specialist tools and some spreadsheets. It is also not a dashboard. A dashboard displays numbers. If the logic that produces them is rebuilt inside each dashboard, you have many sources of truth with one logo on top.
Why numbers disagree
When two reports show different revenue, it is almost never because someone made an arithmetic mistake. The two reports apply different rules. One includes credit notes and one does not. One uses invoice date and one uses ship date. One filters out internal customers and one forgets to. Each rule was reasonable when it was written, and nobody wrote them down together.
That is why reconciliation meetings happen. People are not arguing about facts, they are comparing definitions.
How to build one
Pick the ten or so numbers your business runs on. For each, write a plain-language definition: what is counted, what is excluded, which date is used, and who owns the definition. Get the owner to agree to it in writing.
Then implement each definition once, in one layer, such as a metrics layer or a reporting database, and have every dashboard, report and export read from that layer instead of recalculating. If a number has to change, change it in one place and every report updates.
Keep it alive
A single source of truth decays unless there is a change process. When someone wants to change a definition, record why, who approved it, and the date, and decide whether to restate history. When someone builds a new report, they use the existing definitions instead of making up their own.
A simple test
Ask two people in different departments the same question, such as last month's revenue by customer. If they get the same answer without a meeting, you have a single source of truth for that number. If they do not, you know where to start.
This is also why, in our experience, the BI tool is rarely the problem. The tool shows whatever the data layer feeds it.
If your teams keep arguing about whose numbers are right, reach out. Agreeing the definitions is usually the fastest win, and it does not need new software.
Have a question about this topic? We work with businesses worldwide.
Get in Touch