Building a Single Source of Truth in Modern Finance

Most finance leaders have sat in the meeting where two people quote two different numbers for the same thing. Sales has one revenue figure, finance has another; the board pack says one margin, the operational dashboard says something else. Everyone is looking at real data — it just doesn’t agree. That is the problem a “single source of truth” is meant to solve: one trusted set of numbers the whole business works from. It sounds like a systems question, and vendors will happily sell you a systems answer. But in practice, getting a business onto a single source of truth is a finance-leadership job before it is a technology one, and it is one of the quieter things a good FD or CFO is actually there to do.

Why the numbers conflict in the first place

Conflicting numbers rarely come from bad data. They come from the same underlying reality being measured slightly differently in different places. Sales counts a deal when it’s signed; finance counts it when it’s invoiced; the cash view counts it when it’s paid. None is wrong — they’re answering different questions — but if nobody has defined which number is “revenue” for the purpose of the board pack, three teams will bring three answers and each will defend theirs. Multiply that across margin, headcount, pipeline, churn and cost allocation, and you get an organisation where every important figure has a small cloud of competing versions around it.

The cost of hat isn’t just irritation. It’s the time finance spends reconciling versions before every board meeting; it’s decisions delayed while people argue about whose number is right instead of what to do; and, worst, it’s the slow erosion of trust in the finance function’s output. Once a board has been shown two different versions of the same figure, it starts quietly discounting all of them. A single source of truth is really about protecting the credibility of the numbers finance puts in front of decision-makers.

Why this is the finance leader’s job, not just IT’s

It is tempting to treat this as a data-systems problem — buy the right platform, integrate the systems, and the numbers will agree. Technology matters, and we’ll come to it, but the reason so many system implementations fail to deliver a single source of truth is that the hard part isn’t technical. The hard part is agreeing the definitions: what counts as revenue, how a customer is defined, when a cost is recognised, which entity a shared resource belongs to. Those are judgement calls with commercial and accounting implications, and they can only be made by someone with the authority and the financial understanding to make them stick. That is the FD or CFO. A data team can build whatever the business specifies; it cannot decide what “revenue” means. Left to systems alone, you simply automate the disagreement.

This is why a single source of truth tends to arrive when a capable finance leader decides it matters, and stalls when it’s delegated purely to IT. The finance leader is the only person positioned to arbitrate the definitions, impose them across functions, and hold the line when a department wants to keep reporting its own flattering version. It is an exercise of financial authority as much as data architecture.

What actually gets a business onto one set of numbers

Agree the definitions first

Before any tooling, the finance leader has to pin down what the key figures mean and get the business to accept those definitions. What is revenue, and at what point is it recognised? How do we count an active customer? Which costs sit where? This is unglamorous and occasionally contentious — departments often prefer their own definitions — but it is the foundation. Without agreed definitions, no system produces a single source of truth; it just produces a faster argument.

Pick where the truth lives

For each key figure, there has to be one system that owns it — the place the authoritative version comes from. Revenue from the finance system, pipeline from the CRM, headcount from the HR system, and clear rules about how those reconcile. The point isn’t which tool; it’s that everyone knows which one is definitive for what, so nobody is quietly maintaining a rival spreadsheet. Much of the finance leader’s work here is stopping the proliferation of shadow versions — the side spreadsheets where the “real” numbers supposedly live.

Make the trusted numbers the easy ones to use

People build their own versions when the official ones are hard to get at or slow to arrive. If the board pack figures are three weeks old and locked in finance’s systems, teams will make their own. A large part of sustaining a single source of truth is making the trusted numbers accessible and timely enough that there’s no incentive to go around them. That is where the technology genuinely helps — not as the source of truth itself, but as the means of getting the agreed, defined numbers in front of people quickly.

Hold the line

A single source of truth decays without maintenance. New systems get bought, new metrics get invented, a department starts reporting its own cut again, and the clouds of competing versions reform. Keeping the business on one set of numbers is an ongoing discipline the finance leader has to own — revisiting definitions as the business changes, and pushing back when fragmentation creeps back in. It is never quite finished.

Where technology fits

None of this means systems don’t matter — they do, particularly as a business grows and manual reconciliation stops being viable. Modern finance systems, data warehousing and reporting tools are what make a single source of truth practical at scale, by automating the flow of agreed numbers and cutting the manual effort that invites error. But the sequence matters: technology executes the definitions finance has already agreed; it does not supply them. Businesses that buy the platform first and expect it to resolve the disagreements almost always end up disappointed, because the tool faithfully reproduces whatever ambiguity it was fed. Get the definitions and the ownership right, and the technology becomes genuinely powerful. Skip them, and it becomes an expensive way to produce the same conflicting numbers faster.

For growing businesses, this is often exactly the point at which a strong finance leader earns their keep — someone who has done it before, knows which definitions matter and which battles to fight, and can get the organisation onto one trusted set of numbers without a two-year systems programme. It is a capability question as much as a tooling one, and it is frequently why a business brings in an experienced FD or CFO in the first place.

The signs a business has this problem

It is usually easy to spot an organisation that lacks a single source of truth, because the symptoms are consistent. Board meetings open with people reconciling whose figures are right before any actual discussion can start. The same metric carries different values in different reports, and nobody can quickly say which is correct. Finance spends the back half of every month rebuilding numbers that already exist elsewhere, because they can’t be trusted as they stand. Departments maintain their own private spreadsheets because they don’t believe the official numbers — or find them too slow. And decisions stall not because the answer is hard but because the inputs are contested. If several of those are familiar, the business doesn’t have a data problem so much as a definitions-and-ownership problem, and it is the finance leader who is positioned to fix it. Recognising the pattern is the first step; the discipline set out above is what resolves it.

Related finance leadership insights

Adrian Lawrence

Adrian Lawrence FCA is the founder of FD Capital and a Fellow of the Institute of Chartered Accountants in England and Wales (ICAEW). He holds a BSc from Queen Mary College, University of London, and has over 25 years of experience as a Chartered Accountant and finance leader working with private, PE-backed and owner-managed businesses across the UK. He founded FD Capital to connect growing businesses with the Finance Directors and CFOs they need to scale — and personally interviews candidates for senior finance appointments.