Systems of Record

The set of systems that each hold authoritative data for part of the business, and the map of which owns what. The architectural decision underneath every reporting question.

Also called: System of Record, SOR

The concept

For each domain of data, one system is authoritative and the rest hold copies. The designation matters more than the tooling: where no authority is named, disagreements are settled by whoever argues most recently rather than by rule, and the same disagreement recurs indefinitely.

A typical map

Domains and their usual authority
DomainUsual authorityWhere it commonly goes wrong
Account ownershipCRMTerritory tool writes back and overwrites
Contract value and termsBilling or CLMCRM amount edited after signature
Product usageProduct databaseAggregated copy in CRM goes stale
Support historyService deskPartial sync creates a misleading subset
Person and consentMarketing platformConsent state diverges between systems

Source: Common patterns; verify against your own stack

Boundaries are where money leaks

Revenue leakage concentrates at the contract-to-billing boundary precisely because each system is internally consistent. Nothing errors when the two disagree — the invoice simply differs from the entitlement, and only a deliberate comparison finds it.

Making the map operational

  1. List fields present in more than one system. This alone is usually revealing.

  2. Name the authority for each, based on where the value is created or verified by the party who owns it.

  3. Define sync direction and conflict behaviour explicitly. "Last write wins" is a choice and should be a deliberate one.

  4. Instrument divergence: sample matched records on a schedule and count disagreements against the authority. Rising divergence indicates an integration degrading before anyone notices.

  5. Re-examine after any structural change — an acquisition or a new billing system silently creates a second authority.

Where the model strains

  • Fields that are genuinely co-owned, such as a lifecycle state both marketing and sales drive, need a stated precedence rather than a single authority.

  • Real-time needs can force a cached copy to be treated as authoritative in practice, which should be acknowledged rather than denied.

  • A system of record that is hard for consumers to query gets copied informally into spreadsheets, which recreates the problem outside the map.

RELATED TERMS

COMMON QUESTIONS

What is a system of record?
The system designated authoritative for a domain of data — the CRM for account ownership, billing for contract value, the product database for usage. Every other system holding those values is a copy.
Can there be more than one system of record?
Yes, one per domain. The requirement is that each field has exactly one authority, not that a single platform holds everything — which is a common and expensive misreading.
Why do problems concentrate at system boundaries?
Because each system is internally consistent and nothing validates across them. A value transcribed from one to another can diverge silently, and no error is raised on either side.
How do you detect divergence between systems?
Sample matched records periodically and compare the fields that exist in both. The divergence rate is the health measure for the integration, and it is almost never monitored.

WHERE THIS HAS BEEN APPLIED

Client work and research from RevOps HQ, our consulting practice.

FURTHER READING

Learn how to apply this: CRM Admin 101

Definitions are the vocabulary. The courses are where you learn to operate it, with the interactive audit tools.

See the course