> ## Content Index
> Fetch the complete content index at: https://www.antoinebuteau.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Systems of Record Series #6: Identifiers, Hierarchies, and Reconciliation
- URL: https://www.antoinebuteau.com/systems-of-record-series-6-identifiers-hierarchies-and-reconciliation/
- Published: 2026-05-11T03:40:01.000Z
- Updated: 2026-07-19T00:13:44.000Z
- Description: Reliable identifiers and explicit hierarchy rules connect competing system views without forcing false uniformity. Authoritative mappings, decision-specific structures, and owned reconciliation queues protect reporting, billing, routing, and accountability from hidden manual matching.
- Author: Antoine Buteau
- Tags: #Systems Of Record, #Master Data, Business Systems, Series

Identifiers and hierarchies are boring until they break reporting, billing, routing, and accountability.

Every system wants its own ID. CRM has account IDs. Billing has customer IDs. Product has workspace or tenant IDs. Support has organization IDs. Finance has legal entity IDs. None of that is inherently bad. The trouble starts when the company cannot reliably connect them.

Hierarchy makes it harder. A global parent has regional subsidiaries. A customer has multiple workspaces. A reseller buys on behalf of an end customer. A legal entity pays invoices for several operating units. Sales wants one view, finance another, product another. Again, nobody is automatically wrong. The business needs named hierarchy rules.

Systems of record should define the identifiers that matter, how they map, who can merge or split records, and which hierarchy is used for which decision. Revenue reporting may follow legal entity. Customer success may follow operating account. Product usage may follow workspace. The semantic layer can label those meanings, but systems of record decide where the authoritative structures live.

Reconciliation should be routine. If records cannot be matched, create a queue with an owner. If two systems disagree on parentage, use a rule and keep an exception log. If a merge changes history, note which reports or workflows are affected.

The worst pattern is hidden manual matching. It works until the person who understands it leaves or the volume doubles.

Good identifier discipline feels fussy. It is also what lets the business answer simple questions without three exports and a prayer.

---

**This is part 6 of 10 in** [**Systems of Record**](https://www.antoinebuteau.com/systems-of-record-series-index/)**.**

- Previous: [Synchronization Failure and Shadow Truth](https://www.antoinebuteau.com/systems-of-record-series-5-synchronization-failure-and-shadow-truth/)
- Next: [Buying, Building, and Integration Boundaries](https://www.antoinebuteau.com/systems-of-record-series-7-buying-building-and-integration-boundaries/)
- [View the full series index](https://www.antoinebuteau.com/systems-of-record-series-index/)