Give Your Data One Home: The Single Source of Truth

This is step three of setting up business data. You have your numbers, and you capture them clean. Now they need one place to live.

The same number, three different answers

A number that lives in three places soon disagrees with itself.

Two weeks ago you chose your shortlist. Last week you sealed the doorway so each number is entered clean. This week is where clean data either stays clean or quietly falls apart: where it actually lives once it is in.

Here is the trap. A number gets captured well, then copied. Someone pastes it into their own sheet, a second person exports it into theirs, and within a month you have three versions of the truth that no longer match. These separate, disconnected pockets of data have a name, data silos, and every small business grows them without meaning to.

The evidence on scattered copies is not gentle. A review of field audits by researcher Raymond Panko found errors in at least 86% of the spreadsheets audited. That is a general finding, not a verdict on your business, but the direction is clear. Every extra copy is one more place an error can hide and one more version that can drift.

One home per number, not one home for everything

Each number should have exactly one place it truly lives.

The principle here is called a single source of truth. In plain terms, every important number is mastered in one place, and everywhere else points to that place instead of keeping its own copy. It is the difference between one address and a rumour passed around the office.

You do not need a large central system to do this. The enterprise version of this idea is expensive software. The small business version is one agreed home per data type, and nothing more. Leads and pipeline live in one place. Hours live in one place. Invoices live in one place.

The test is simple. For each number on your list, can you name the one place it lives, without a comma in the answer? If you cannot, that number does not have a home yet.

Copies are where the truth goes to die

The moment you copy a number, you have started a second version.

This is the habit that undoes everything. A figure is captured cleanly, then someone pastes it into a slide, a personal tracker, or a file called something like report_final_v7. The copy is right on the day it is made. It is wrong the day the original changes and the copy does not.

The rule that fixes it is short. Reference, do not copy. When you need a number somewhere else, link to its home or pull it live, rather than pasting a static value that will silently go stale. A copied number is a photograph of the past pretending to be the present.

Give each number an owner and a door

A home with no owner and no lock drifts back into chaos.

One home per number is the structure. Two small rules keep it standing. The first is ownership. The second is access. Set both once, when you choose the home.

For the agency, the fix took one meeting. The shared pipeline became the single home, the account manager owned it, everyone else got view access, and the two private copies were deleted. After that the pipeline number stopped depending on who you asked.

Your fifteen minute start, and what comes next

You do not need to reorganise everything today. You need to give one number a home.

Take your shortlist and pick the number that most often causes an argument, the one where people quote different figures. Then do three things.

That is one number housed. Next week is step four, cleaning the data you can now trust, the checks that catch the duplicates, the typos, and the definitions that quietly drift even inside a single home.