A single source of truth is one place everyone takes the number from. Every important piece of business information (customers, products, prices, jobs, sales, costs) has one agreed home, and every system, report and spreadsheet takes its copy from there. Some people call it "one source of truth"; it means the same thing: one set of numbers everyone trusts. For most growing businesses it doesn't mean buying one big system. It means deciding where each piece of information lives, connecting the systems so it flows instead of being retyped, and building reports from those connected systems. This guide explains why numbers end up disagreeing, what it looks like in different industries, and the practical steps to fix it.
Why your numbers disagree
Most businesses don't plan to have several versions of the truth. It happens gradually:
- New systems are added one at a time: accounts first, then a job or stock system, a CRM, payroll, maybe an online store. Each holds its own copy of customers, products or jobs.
- Spreadsheets fill the gaps: where systems don't connect, someone exports, copies and builds a spreadsheet. Then someone else builds a slightly different one.
- Information is retyped: this is double entry (the same information typed into two systems). Every time it's typed again, there's a chance it's typed differently. Timesheets are a common example: the same data entered three times, on site, into payroll and into job costing.
- Timing differs: one system is updated daily, another at month-end, a spreadsheet whenever someone remembers.
Over time each system becomes its own island of information. These are called data silos (separate pockets of information that don't share with each other), and they're the main reason a business ends up with several answers to the same question.
The result is familiar: sales and finance have different revenue figures, stock in the system doesn't match the shelf, and meetings start by arguing about whose numbers are right. If that sounds like your business, see when your systems give different numbers.
What it looks like when it's fixed
You know you have a single source of truth when:
- each important type of information has one agreed home and an owner,
- other systems take their copy from that home automatically,
- reports draw on the connected systems and match the accounts,
- and nobody keeps a private spreadsheet because they don't trust the official numbers.
In practice, it looks like this: on Monday morning the operations manager and the finance manager open the same report and see the same margin for every job or customer from last week. Nobody has spent Friday afternoon rebuilding it, because the hours, materials, invoices and costs all came from the systems where they were first entered. The meeting is about what to do next, not whose figure is right.
How this shows up in different industries
The idea is the same everywhere, but every industry feels it differently. Some short examples:
- Wholesale and distribution: the sales report says a customer is profitable, but rebates, freight, credits and landed cost sit in other places, so nobody can say what that customer really earns you. See why you can't see margin by customer.
- Manufacturing and fabrication: the quote lives in one place, the hours on the floor in another and the material costs in the accounts, so the real job cost is a guess until the job has shipped. See why job cost is a guess until it's shipped.
- Transport and logistics: freight revenue sits in the transport system while fuel cards, tolls, wages, subcontractor payments and repairs land elsewhere, so profit per run stays hidden. See why you can't see profit per run.
- Professional services: time is recorded in one system and fees billed from another, so a fixed-fee project can lose money for months before anyone notices. See why fixed-fee projects lose money.
- Grain, timber, hay and quarry: the weighbridge ticket, the contract tonnage and the invoice each tell a slightly different story about the same load. See weighbridge tickets, contracts and invoices.
- Online and B2B sales: the online store, the stock system and the accounts each hold their own stock and order figures, so they drift out of step. See online store, stock and accounts out of step.
- Any business with credit customers: accounts puts a customer on hold, but sales and dispatch work in other systems and keep supplying them. See customer on hold across systems.
In each case the fix is the same pattern: agree where each figure is first recorded, and let every other system and report take it from there.
Step by step: getting there
1. Start with the arguments
List the figures people argue about or rebuild by hand. Revenue, job profitability, stock and debtors are common. Fix the one that matters most first.
2. Trace each figure to its source
For each figure, find where the information is first entered, where it's copied, and where the versions start to differ.
3. Agree one home for each piece of information
For example: customers live in the CRM, products and prices in the stock system, invoices and payments in the accounts. Give each an owner who's responsible for keeping it right.
4. Connect the systems
Make the other systems take their copy from the agreed home automatically, instead of being retyped. Where information has to be reconciled, have differences flagged automatically rather than found at month-end. Our page on ending double data entry covers this step in more detail.
5. Build reports from the connected systems
Once the data flows, reports and dashboards can be built from it and refresh themselves, so nobody rebuilds them by hand.
6. Retire the risky spreadsheets
Move the spreadsheets that run part of the business into proper systems, or at least connect them, so key figures don't depend on one person's file.
Do you need one big system?
Usually not. Replacing everything with one system is expensive and disruptive, and businesses often end up with spreadsheets around the new system too. Connecting the systems you already have, with clear agreement on where each piece of information lives, gets most businesses to one set of numbers faster and with less risk. A single source of truth is an agreement about where each figure lives, backed by connections between systems. It isn't a product you buy.
When to get help
You can usually do steps 1 to 3 yourselves. Steps 4 to 6 involve connecting systems and building reporting, which is where outside help pays off, especially when several systems or entities are involved. If your systems were added one at a time and never joined up, see disconnected business systems. For how we approach the fix, see one set of numbers and when the problem is between your systems.
Once each number has one home, a near-real-time financial picture becomes possible: you know on Tuesday what last week made. New to some of these terms? Our plain-English glossary explains them in a sentence or two each.
Frequently asked questions
What is a single source of truth?
One place everyone takes the number from. Each important piece of business information, such as customers, products, jobs, sales and costs, has one agreed home, and every system and report uses that version instead of keeping its own copy.
Is "one source of truth" the same as "single source of truth"?
Yes. Both phrases mean one trusted, agreed home for each piece of information, so everyone in the business works from the same numbers.
What are data silos?
Information stuck in separate systems or spreadsheets that don't share it. They're the main reason figures disagree and reports have to be rebuilt by hand. Our guide to why your systems disagree explains the common causes.
Can spreadsheets be part of a single source of truth?
They can be used for analysis, but they make a poor home for important information that several people update. Business-critical spreadsheets are usually better moved into a proper system or connected to one.
Where should we start?
With the figure that causes the most arguments or manual work. Fixing one area properly shows the way, and builds trust, for the rest.
If your team spends meetings arguing about whose numbers are right, book a free initial chat. We'll help you work out where the versions part ways and what it would take to fix it.