Insights
Why your numbers never match between departments
Published · ARTEC INT
When two departments report different figures for the same indicator, the cause is rarely technical. In the large majority of cases each one is calculating correctly — just not the same thing: sales counts an order at signature, logistics at dispatch, finance at invoicing. Three definitions, three results, none of them wrong. The cure is therefore not to buy an analytics tool, it is to write down the definition of each indicator, have the departments concerned sign it off, and then implement it exactly once, in exactly one place. The tool comes afterwards, and it fixes nothing on its own.
The symptom: the meeting that derails
The committee meets to decide. Ten minutes later the discussion is no longer about the decision but about the method of calculation, and it ends with "let's revisit this when the numbers are reliable". That meeting will repeat, identically, next month.
The real cost is not the time lost in the room. It is that the decision is deferred — or worse, taken on the figure belonging to whoever argued hardest.
Why an analytics tool isn't enough
A reporting tool wired to vague definitions produces the same disagreements, faster and with better-looking charts. It moves the problem without treating it: departments will keep contesting the figure, and the tool becomes one more source among many.
The sequence that works is the reverse: define, get sign-off, then tool up. That is the unglamorous part, and the only one that produces lasting agreement.
The KPI dictionary
For each indicator that matters, a written entry: what it measures, the exact formula, the source of each input, the time grain, the exclusions, and the name of the person who arbitrates when there is doubt. Thirty or so indicators are usually enough to cover a mid-sized company.
The document is only worth anything signed. A definition approved by one department and ignored by another fixes nothing — the agreement, not the writing, is the deliverable.
One implementation only
Once definitions are settled, each indicator must be calculated in one place and distributed everywhere from there. The moment a formula is reimplemented in a second spreadsheet, the two versions diverge — not immediately, but at the first rule change one applies and the other doesn't.
It is also what makes the result auditable: when a figure surprises someone, you trace it back to the single source instead of arbitrating between two files.
Written by the engineers of ARTEC INT, a software and industrial engineering firm based in Algiers and Annaba.