Skip to content

Data

Single source of truth

A named authoritative system for each piece of data, so disagreement has an answer.

Also called

  • SSOT
  • System of record

When the CRM, the billing system and the spreadsheet each hold a customer record, all three drift, and every meeting that compares them spends its first fifteen minutes reconciling. The fix is not technical first — it is deciding, per field, which system is authoritative.

Once decided, the technical work follows: everything else reads from the authority rather than keeping its own copy, or copies are clearly derived and timestamped.

The failure mode to watch is a 'temporary' spreadsheet that becomes load-bearing. It is usually where the real process lives, which makes it worth understanding rather than banning.

It is the difference between a reporting question taking an hour and taking a week of reconciliation.
Why it matters

Commonly misunderstood

What people get wrong

The claim

One source of truth means one system.

What is actually true

It means one *authority per field*. Billing can own invoice state while the CRM owns contact details, as long as it is written down which is which.

Next step

Working through a single source of truth decision?

Tell us the situation. We will give you the tradeoffs as we see them, including when the answer is that you do not need what you are being sold.

No pitch deck. A 30-minute conversation about what you are trying to achieve.