Single Source of Truth

The moment a fact lives in two places, the two drift apart and nobody can say which is right. Forecasts built on a rep's private spreadsheet become guesses. Meetings turn into arguments about whose number is correct. The problem grows with automation. An AI agent or workflow reads whatever it is pointed at, so a stale copy leads to confident wrong action at speed.

• List the facts the business depends on and name one owning system for each.
• Point dashboards and automations at that system directly, never at an export.
• Treat a second copy of a fact as a bug to fix, not a convenience to tolerate.
• Give agents read access to the live source.
• Every quarter, look for spreadsheets and trackers quietly duplicating a record.
• Write down definitions as well as numbers. "Active customer" should mean one thing everywhere.

For any fact a business relies on, such as the value of a deal, the price of a plan or the status of an invoice, one system is named as the owner. Everything else reads from it or is rebuilt from it. The CRM owns deals. The accounting system owns revenue. Copies are allowed only when they refresh automatically from the owner, like a dashboard built on live data.

The opposite is a shadow copy: a spreadsheet exported last month, a figure typed into a slide, a private tracker kept because the official tool feels slow.

• Naming no owner. If two systems can both be edited, both will be, and they drift.
• Exporting instead of connecting. A CSV is a copy from the moment it is saved.
• Tolerating the "convenient" private tracker. Each one is a second source, and a future argument.
• Fixing the numbers but not the definitions. If "active customer" means different things in different tools, a single source still gives conflicting answers.
• Pointing automations at copies. An AI agent or workflow acts on whatever it reads, so a stale copy leads to confident wrong action.
• Treating it as one-off. Without a regular check, copies grow back.