Our numbers live in eight tools and no two agree
The fix is never a ninth tool. Pick one system as the truth — almost always billing — and make every other number explain its difference from that one. Reconcile before you visualise, because a beautiful dashboard built on unreconciled sources just spreads the disagreement faster.
The grandmother version
A house with five clocks. The kitchen one is fast, the hallway one stopped, the car is on a different time zone, and nobody agrees about when dinner is.
You don't buy a sixth clock. You decide which one is right — the one on the wall that the trains run by — and you set the others to it.
And when the kitchen clock runs four minutes fast, you don't rip it out. You write "four minutes fast" on a bit of tape and stick it on the front. Now it's useful.
Choose the system of record, out loud
One system is the truth, and everyone must know which. In almost every business it is billing or the orders table — the place where money actually moved. That number is not an estimate.
Everything else is an instrument pointed at reality, with its own bias. That is fine, as long as the bias is known and written down.
Reconcile first, visualise second
Totals must agree with the system of record before a single chart is drawn. If they cannot be made to agree, the difference goes in the report, with its cause, rather than being quietly absorbed.
This is the step teams skip, because a dashboard is visible progress and reconciliation is not. It is also the step that decides whether anyone trusts the dashboard in six months.
Definitions travel with the numbers
Every metric carries its definition and its period, next to the number: hover text, a footnote, an adjacent panel. A number without its period is not reportable.
Add a freshness marker to every panel — and remember that every value in a ratio needs its own marker. A stale numerator over a fresh denominator is a wrong number that looks perfectly healthy.
The short version
Eight disagreeing tools is not a data problem, it is a governance problem wearing a data costume. Nobody decided which one was right, so all of them are.
Decide. Write it down. Label the others with how far off they run, and re-check that label monthly.
The Measurement Spec (€900) settles the definitions; The Report Nobody Rebuilds (€3,500) reconciles the sources and ships the pack.
See prices →