How do you create a single source of truth in financial data?

A single source of truth in financial data emerges when definitions, assumptions, and changes are clear and traceable. It's a way of working — not a single system.

Why the lack of a single source of truth is so common

A lack of a single source of truth is rarely about the numbers being "wrong." It stems from the fact that they are produced in different contexts, based on different assumptions, and across different systems — without that being clear to everyone. In many organizations, planning evolves gradually: new systems are introduced, local adjustments are made, and Excel models continue to exist alongside them. Each part may work well on its own, but the overall picture becomes hard to grasp. Three causes stand out:

• Data is spread across multiple systems. Transactions sit in the ERP, forecasts in another tool, analyses in Excel. When information is extracted, adjusted, and combined manually, discrepancies arise even when intent is aligned.

• Definitions are interpreted differently. What counts as "revenue"? What's included in "cost"? Is the forecast before or after adjustments? Undocumented definitions create parallel interpretations.

• Assumptions change without traceability. When assumptions change without clarity on who changed them and why, trust erodes and the discussion shifts from strategy to version control.

What it costs

When different numbers are used in different forums, meetings become debates about the numbers rather than decisions. This slows the organization down and undermines the finance function's role. In Confessions of a Nordic CFO, 41% of Nordic CFOs say double-checking data consumes most of their day — much of that effort exists only because there is no agreed single source of truth.

How to create a single source of truth

A single source of truth is built through a way of working, supported by the right structure. In practice it rests on four things:

• Shared, documented definitions. Agree — and write down — what each key term means (revenue, cost, margin, headcount), so every report starts from the same basis.

• Integrated data. Connect actuals and plans so figures are drawn from consistent sources rather than reconciled by hand. The fewer manual hops between systems, the fewer places for discrepancies to appear.

• Transparent, traceable assumptions. Make the drivers behind a forecast visible and versioned, so anyone can see what changed, when, and why.

• One place people trust. When leadership, finance, and the business all draw on the same numbers, the conversation can move from "whose figure is right?" to "what do we do about it?"

The point isn't to force everything into a single tool. It's to make the numbers consistent, traceable, and trusted — so that when a decision is on the table, no one is arguing about which version of the truth to use.
‍

Related questions in FP&A Explainer

• Why don’t CFOs fully trust their forecasts?
• When do spreadsheets stop being sufficient for FP&A?
• How is AI used in FP&A in practice?