When your reporting gives three answers to one question

Ask a simple question and watch what happens

How many orders did we do last month. It is not a difficult question, and in a lot of businesses it takes three days and produces three answers. One from the sales sheet. One from the invoice book, which is lower. One from the platform dashboard, which is higher and includes things that were cancelled.

Sometimes it is worse than disagreement. You get one number, delivered confidently, and nobody in the room actually believes it, including the person who assembled it. They believe it is roughly right, which is a different thing, and roughly right numbers cannot be used to make a decision that costs money.

The instinctive response is to ask for a better report. That is almost always the wrong first move, because the report is not what is broken.

Why the figures disagree

Four causes explain nearly every version of this, and none of them is a software problem.

The first is that the definition was never written down. Does a sale count when the order is placed, when the payment lands, when it is dispatched, or when the return window has closed. All four are defensible. If two people picked different ones, they will disagree forever and both will be right.

The second is that there are several sources and no agreed source of truth. The sheet, the invoice book, a marketplace dashboard and the bank statement each hold a partial version of the same month, and whichever one a person opens first becomes their answer. The third is period drift, where the calendar month and the month somebody actually counted are not the same fourteen days apart.

The fourth is assembly. When a number is produced by a human being cleaning up data by hand, that person makes dozens of small judgement calls about duplicates, cancellations and odd rows. None of those calls are recorded, so the figure cannot be reproduced, not even by the same person a week later.

• No written definition, so two reasonable people count different things
• Several sources, none of them named as the one that decides
• Periods that do not line up between systems or between people
• Manual cleanup whose decisions nobody wrote down
• Numbers arriving so late that they describe a month you can no longer change

The two person test

Run this once and it will teach you more than a quarter of reports. Pick one number that matters, ask two people to produce it for the same period independently, and tell them not to speak to each other while they do it.

Then put both answers on a table and reconcile the gap out loud. The gap is not carelessness. It is your definition problem made visible, and every line of the reconciliation is a rule your business has been running without.

Do the same for the timing question. Ask when each number is available and what decision it feeds. A figure that arrives on the fourteenth, describing a month that ended on the thirty first, can inform planning but cannot change anything that already happened, and pretending otherwise is how businesses end up steering by a rear view mirror and calling it reporting.

The free fix: one page of definitions

Choose five numbers. Not fifteen. Five is roughly the count a small business can actually keep honest, and a small set that everyone trusts beats a wide set that nobody does.

For each one, write five things on a single page: the exact definition in a sentence, the single source that decides it, the person who produces it, the day it is due, and the decision it feeds. Circulate the page, argue about it once, and then treat it as settled until someone proposes a change in writing.

That last column does more work than it looks like it should. Numbers with no decision attached quietly disappear from the page, and they are usually the ones that were taking the longest to assemble. What remains is a short, defended list where a disagreement can be resolved by pointing at a sentence rather than by seniority.

One more habit, which costs nothing. When someone does a manual cleanup to produce a figure, they write one line underneath saying what they excluded and why. Three months of those lines is a specification for how the number should be produced automatically, written by the person who actually knows.

• The definition, in one sentence, agreed by everyone who uses it
• One source, named, which wins when sources disagree
• One person who produces it, by name rather than by department
• The day of the month it is due
• The decision it feeds, or its removal from the page

What a dashboard adds, and when it is the wrong answer

Once definitions and sources are settled, a dashboard is straightforward and genuinely useful. It removes the assembly work, which removes the unrecorded judgement calls. It produces the same answer every time it is opened. It shortens the gap between something happening and somebody being able to see it, which is the only part of reporting that changes outcomes rather than describing them.

Built in the wrong order, it does harm. A dashboard sitting on top of disagreeing definitions does not resolve the disagreement, it publishes one side of it in a large font and gives it the authority of a screen. People stop questioning a number once it is on a dashboard, which is exactly the wrong moment to stop questioning it.

There are also businesses that should not buy one yet. If five numbers and one owner cover your whole operation, a written page each month is more reliable than a live screen nobody opens, and reliability is the thing you were short of. If your important decisions are made monthly, real time reporting adds cost without adding a single decision. And if no person will own each number, a dashboard simply automates the production of figures nobody stands behind.

A number nobody can reproduce is an opinion with a decimal point in it.

After the definitions page, what wiring it up actually involves

The one page of definitions is free and it is the whole fix, so do it with your own team before anybody quotes for anything. There is no price on this site, and what moves the number afterwards is how many sources have to be read, whether each of them permits a read, and who maintains the definitions when the business changes shape. A supplier quoting before the definitions exist is quoting to wire together numbers that still disagree with each other.

Once the five definitions are agreed the work is short. The audit takes the first week and its output is the source map: which system is authoritative for each of the five, and what each will and will not permit. One number is live inside a fortnight, deliberately the one that caused the argument. The parallel run against the manual report follows for a full cycle, because a dashboard that has never been checked against the thing it replaced is an opinion with a chart on it.

Reporting reports. Where a figure moves far enough to matter it hands it to a person with the rows behind it rather than acting on it, and any decision taken from a number waits for human approval. The unrecorded judgement calls described above do not disappear when the assembly is automated. They move into the definitions, which is exactly why the definitions are the deliverable and the wiring is the detail.

The published work here is operational rather than a reporting product: Quillon's delivery line as a single audited automation of 34 AI nodes, and Big Texas Land Buyers, where voice agents categorise into the CRM automatically, which is a reporting problem solved at the point of capture instead of at the point of assembly. Ibrahim owns build and workflows at Wobble, which works from Karachi, bills month to month and carries 25 engagements across six countries.

Common questions

Why do my sales numbers never match my accounts?

Almost always because the two are counting at different moments. Sales tends to count orders placed and accounts tends to count money received or invoices raised, so the same month legitimately produces two figures. Write down which one you mean when you say sales, and state the other as a separate line rather than trying to make them agree.

How many numbers should a small business track?

Around five, each with an owner and a decision attached. A short list everybody trusts beats a long list nobody checks. If a number has been on your report for six months and has never changed anything you did, it is a habit rather than a measure, and removing it costs you nothing.

Do I need real time reporting?

Only for decisions you make in real time, such as staffing a shift or reordering fast moving stock. For decisions taken monthly, a reliable monthly figure is worth far more than a live one, and chasing live data usually delays the more valuable work of agreeing what the figures mean.

Our reports take days to assemble. Where do I start?

Start with the assembly notes rather than with the tooling. Ask whoever produces the report to write down every exclusion and correction they make while producing it, for one cycle. That list is both the reason it takes days and the specification for making it take minutes.

Who should own a number in a small team?

The person closest to the work it describes, not the most senior person in the room. Ownership means they produce it, they defend the definition and they are the one asked when it looks wrong. A number owned by everybody is owned by nobody, which is how figures end up unchallenged for a year.