Why Every System Shows a Different Number (and What to Do About It)

End of the month. The owner of a small studio wants to know one simple thing: how was the month? He opens three systems and gets three different numbers. Which is the question I get asked more than any other: why does every system show a different number?

He opens the calendar: it shows this many sessions. He opens the invoicing software: a different number, because some sessions haven't been billed yet and some were cancelled after they were booked. He opens the spreadsheet he keeps on the side "for order's sake", and there sits a third number, because he stopped updating it mid-month when things got busy.

Three sources, three answers. Then comes the question I hear in almost every business: "So which one do we look at?"

The answer most businesses live with is "gut feeling". This post is about the alternative: what the systems world calls a "single source of truth", one place everyone agrees is the correct one, with everything else measured against it.

Why every system shows a different number

Nobody plans to have three contradictory reports. They grow out of exactly the same process that creates double data entry: every tool in the business arrived at a different time, for a different purpose, and each one counts the world its own way.

The calendar counts appointments that were booked. The invoices count money that was billed. The spreadsheet counts whatever someone remembered to type into it. All three are right, each about its own question. The trouble is that nobody says the questions out loud, so everyone assumes they're answering the same one and there's simply "a mistake somewhere". Put plainly: conflicting data between systems is almost never a bug. It is the result of how the business was assembled, one tool at a time.

And when systems hold conflicting data, something quietly damaging happens: people stop believing all of them. I've seen it again and again: a business owner who stops looking at reports altogether, because "they're not accurate anyway". That's the point where the business goes back to running on feeling. And feeling, in my experience, remembers last week and forgets the quarter.

What "one source of truth" means, without the mysticism

The idea is almost disappointingly simple: you decide that one place, one system, one table, is the official record of the business. Every important piece of data is born there or flows there, and when that place contradicts another, that place wins and the other gets corrected.

Notice what this does not mean. It doesn't mean one tool that does everything: the calendar can stay a calendar and the invoicing software can keep doing invoices. It means there is one address all the tools report to, and the report is born from it. The difference is between "one piece of software" and "one truth", and the second matters far more than the first.

Something else it doesn't mean: that the numbers will always be pleasant. A trustworthy report shows weak months too, without softening them, and that is exactly its value. A business that sees a dip in real time can respond in real time; a business that discovers it after the fact, through the bank statement, responds months late.

Once a source like that exists, a "report" stops being a whole-evening project. It becomes a glance: you open one screen and see how many inquiries came in, how many became clients, what was paid and what's stuck. No collecting, no cross-checking, no guessing.

The common mistakes on the way to one truth

Building the report before fixing the flow. This is the most common mistake. You invest in a beautiful dashboard that pulls data from three unsynchronized sources. The result: a fourth report, prettier than the others and just as wrong. The right order is the reverse: first decide where each piece of data is born, and only then draw it.

Measuring everything that moves. You get excited and build a report with twenty metrics. Two weeks later nobody opens it, because twenty numbers are noise, not a picture. A small business needs to track a handful of numbers that actually change decisions: how many inquiries came in, how many closed, how much money arrived, what's stuck. The rest can wait.

Defining metrics in a fog. "How many clients did we have this month?" Wait, who counts as a client? Someone who paid? Someone who booked? Someone who actually showed up? If two people in the business answer differently, the report will contradict itself forever. One sharp definition is worth more than any software.

Fixing the report instead of the source. An error shows up, you correct it by hand in the report, and a week later it's back, because the source is still broken. Every manual fix in the report is a debt postponed to next week.

What you can do today

Even without connecting a single system, you can make real progress:

• Pick three numbers. Not twenty. Three numbers that, if you knew them every week, you would manage differently. For most businesses I meet it's something like: inquiries that came in, deals that closed, money that arrived.
• Define them in writing. One sentence per number: "An inquiry = any new person who made contact, on any channel". The written definition is eighty percent of the work, and it's also free.
• Set an official source for each number. Even if it's manual for now: "The inquiry count comes from the inquiries table, period". From that moment on, a contradiction is not an argument: it's a sign that something didn't flow into the table.
• Fifteen fixed minutes a week. Same day, same hour, in front of your three numbers. After a month you'll have something most small businesses don't: a line. A direction. Not a feeling, knowledge.

These four steps don't require a single new tool, only a decision. And that's deliberate: the habit is worth building before the technology, because a report nobody reads is just a pretty screen. Wiring the systems together, the work I do, comes after that decision, not instead of it.

When this isn't the solution

If your business is very small and you genuinely feel every movement inside it, your gut may still be more accurate than any report, and the weekly ritual will be plenty. Reports are a tool for the moment a business grows beyond your ability to feel it.

And a second reason, a more important one: if the data itself isn't being collected, if WhatsApp inquiries aren't recorded anywhere, no report in the world can show them. First every inquiry has to land in one place, and only then is there something to summarize. Collection before presentation, always.

One report is not a luxury

Big companies have people whose entire job is producing reports. In a small business, the only report that exists is whatever the owner manages to glance at between one client and the next, which is exactly why one truth is worth so much there: it restores the ability to decide based on what is happening, not on what is remembered.

On my site there are real examples of what it looks like when a small business's data is connected to one screen. And if you want to check how far your business is from the point where every system shows the same number, the short questionnaire will give you an honest answer, no commitment.