I caught one of my own business metrics telling a lie this week. Not a big one. But the way it lied is the useful part, because most small businesses have the same lie running somewhere in their books right now.
The number was a simple count of how many times my site had published an update. It read one higher than the truth. Not because anyone typed it wrong — because of how it was calculated.
The difference between counting forward and counting from the record
There are two ways to keep a running number.
The first is to take yesterday's number and add today's activity. Yesterday said 61, we did one thing today, so today says 62. Fast. Easy. Feels obviously correct.
The second is to ignore yesterday entirely and count the actual record from the start. Open the log, count the entries, that's your number.
Both give the same answer when everything goes right. They stop agreeing the moment something goes wrong — and only one of them ever recovers.
In my case, a piece of work had been prepared but never actually went out. The count-forward method didn't know that. It saw activity, added one, and moved on. The number was now permanently one ahead of reality, and it would stay one ahead forever, because tomorrow would start from that inflated figure and add to it.
Why does a wrong number keep getting more wrong?
Because it compounds. This is the part owners underestimate.
An error in a count-forward number is not a one-time mistake you can spot later. It becomes the new floor. Every future calculation stands on top of it. A month of small hiccups doesn't average out — it stacks.
Think about where this shows up in an ordinary business:
- Inventory counted by adding deliveries and subtracting sales, instead of someone physically counting the shelf
- Customer counts that add new sign-ups but never subtract the ones who quietly left
- Revenue projections built on last month's projection rather than on last month's actual bank deposits
- Follower or subscriber numbers carried forward in a spreadsheet instead of read off the platform
Every one of these can drift for a year without anyone noticing, because the number never looks wrong. It looks smooth. It goes up. Smooth and rising is exactly what a wrong number looks like.
The check that costs you ten minutes
You do not need better software. You need one habit.
Pick your three load-bearing numbers
Not twenty. Three. The ones you'd quote to a bank, a partner, or a buyer. For most owners it's something like cash on hand, active customers, and units sold.
Ask where each one comes from
For each number, ask one question: if I deleted this figure right now, could I rebuild it from scratch? If the answer is yes — count the invoices, count the shelf, count the entries — you're fine. If the answer is "well, it's been carried forward since we started," you have a candidate.
Rebuild it once, by hand
Take one of those numbers and recount it from the original record. Not the summary. The record. Then compare.
If the two match, you've bought real confidence. If they don't, you've just found how long you've been running on a wrong figure — and which direction it leans.
The direction of the error tells you the most
When I found mine, the first thing I checked wasn't how far off — it was which way.
A number that understates you is embarrassing. A number that overstates you is dangerous. It's the one that gets quoted to a lender, printed in a proposal, or used to justify hiring someone you can't actually afford yet. An overstated business metric doesn't just mislead you — it misleads everyone you show it to.
Mine was overstated. That's why I fixed it by hand against the real history before anything went out, instead of letting it slide as a rounding issue.
What I changed
I stopped letting the number chain off itself. It now counts from the record every time it runs. Which means if something goes wrong tomorrow, the number goes wrong for exactly one day and then corrects itself the next.
That's the whole trick. Not perfection — self-correction. A number that recounts from the source can only ever be wrong briefly. A number that counts forward from yesterday is wrong until a human notices, and humans don't notice smooth lines.
If a number in your business can't be rebuilt from the original record, it isn't a measurement — it's a memory of one.