The 'Single Source of Truth' Dashboard Is Usually a Myth

Every client I've worked with describes some dashboard, warehouse table, or reporting tool as 'the single source of truth' at some point in a kickoff call. Almost none of them actually have one. What they have is the dashboard that currently wins arguments, which is a different thing wearing the same label.

I asked a client once to show me the single source of truth for revenue. They pulled up three different numbers from three different systems — the billing system, the CRM, and a finance-maintained spreadsheet that reconciled the other two with manual adjustments nobody outside finance understood. All three were called the single source of truth by the people who used them, depending on which room the conversation was happening in.

Why the phrase persists anyway

'Single source of truth' is comforting to say in a meeting. It implies the disagreement everyone's actually navigating has already been resolved somewhere, by someone, and you just need to go check. Naming it that way lets people avoid the harder conversation about why three systems disagree and which discrepancies actually matter enough to reconcile.

The phrase 'single source of truth' usually means 'the number we've all agreed to stop arguing about,' not 'the number that's actually correct.'

What's actually more useful than pretending

• Naming each system's number for what it actually measures, rather than which one deserves the crown — billing revenue and CRM-reported revenue answer different questions and both can be right
• Documenting known discrepancies explicitly, with the reason they exist, instead of quietly picking a winner and hoping nobody asks why the other number differs
• Reserving reconciliation effort for discrepancies that actually change a decision, not chasing every number into agreement for its own sake
• Being explicit in any report about which system a number came from, so the inevitable 'why doesn't this match' question has an immediate, honest answer

The org that admits it has multiple partially-overlapping sources of truth, each useful for a specific question, ends up with far less confusion than the one insisting it has achieved a single one. The myth doesn't prevent disagreement. It just makes the disagreement harder to talk about honestly.