Why nobody trusts the number anymore
A report wrong once is rarely trusted again, even after the cause is found and fixed.
Once a figure has been wrong, people quietly start checking it, and now the business is paying for two versions of the truth.
Not every business has this problem, and some should leave it alone.
Most of these can be done better. Whether it's worth doing is a separate question. What follows is one common form of the problem, described in general terms, because your version will differ. These are possible challenges, not a description of your business, and some should be left exactly as they are. If it sounds like your week, that's worth a conversation.
Watch: The Decision Nobody Wrote Down
Watch: The Count, and What It Was Trying to Tell You
Watch: Nobody Is Watching This
Sound familiar?
- Somebody keeps a personal spreadsheet just to double-check the real numbers.
- Two people in the same meeting confidently state two different figures.
- A decision got made slower than usual because the number needed verifying first.
- A shadow record has outlived the reason it was created.
The idea in short
A report is wrong once, the cause gets found, the number gets corrected, and everyone moves on. Except the report is never quite believed again: the one or two people who have to act on it start pulling the underlying numbers to confirm, quietly, as diligence rather than as a cost.
What that turns into
The checking becomes a second set of records: a spreadsheet someone keeps alongside the system, more accurate in the narrow sense that someone who cares maintains it. The business now pays for one set of numbers, maintains two, and treats the unofficial one as true. When the two disagree, there is no procedure for deciding which is right; the answer depends on who is in the room.
Why it is rarely repaired
Fixing this requires establishing that the report is reliable again, and there is no event that does that. Confidence returns from a long run of the report being right, which nobody is measuring, so nobody notices when it happens. The shadow spreadsheet outlives the problem that created it, sometimes by years.
What changes
A standing comparison between the two records that are supposed to agree, run on a schedule and reporting every difference, produces evidence instead of a feeling. A difference found and explained is a repaired piece of trust. A week with none is a quiet argument that the number is good, and that accumulating record is what eventually makes the shadow spreadsheet unnecessary.
Questions worth asking about your own operation
- Is there a spreadsheet anyone keeps 'just to be sure' of a number the system already produces?
- When two people quote different figures, is there an agreed way to settle it?
- What report was wrong once, and has anyone actually re-earned trust in it since?
If this sounds familiar
Bring me the version you actually have. I'll learn how the process really works before I suggest anything. If it isn't worth changing, or isn't a fit for me, I'll say so. Talk through a problem