Why Is the Math Off?
When business numbers don’t match, nothing wakes up my CFO brain quite like figuring out why.
Especially when they are almost right.
Wildly wrong is easy.
If one report says you made $400,000 and another says $40,000, nobody has to convince anybody there is a problem.
We have a problem.
Everyone agrees.
But let two numbers be off by just enough that a reasonable person could shrug and say, “Eh, close enough,” and suddenly I am interested.
Because I am not particularly gifted at shrugging when numbers are pretending to agree.
And that is how I ended up looking at four different versions of revenue for the exact same business.
An email had one number.
The owner’s spreadsheet had another.
QuickBooks had its own opinion.
Because apparently three versions of the truth were not enough, we also had the bank activity.
Four sources. One business.
The revenue should have matched.
It did not.
So I asked the question that has probably ruined more perfectly pleasant financial meetings than I can count:
“Where is that number coming from?”
It sounds ridiculously simple.
It is also one of the most useful questions you can ask about your business.
Because when business numbers don’t match, choosing your favorite number is not a financial strategy.
You have to figure out what each number is actually telling you.
When Business Numbers Don’t Match, Start With the Source
At first, the difference was small.
Annoyingly small.
The kind of discrepancy that tempts you to say, “We are not wasting an hour on this.”
Sometimes that is exactly the right decision.
But you cannot decide a number doesn’t matter until you understand why it is different.
So we started digging.
What dates did the spreadsheet cover?
When was the QuickBooks report run?
Was one number gross revenue, while the other excluded reimbursable expenses?
Maybe something had been deposited but not coded yet.
Perhaps money landed in another account.
One report could have included a transaction the other did not.
And my personal favorite:
Were we even using the word “revenue” to mean the same thing?
These are not sexy questions.
Nobody is making a Netflix documentary called Venus Checks the Date Range.
I am clicking reports, opening transactions, and comparing totals.
Then I go back to the spreadsheet.
Then back to QuickBooks.
“Nope. Still doesn’t match.”
The glamorous life of strategic finance.
Eventually, we got close enough to understand what was happening.
Part of the difference appeared to be connected to reimbursable activity.
Okay.
Now we knew something.
The reports were not randomly disagreeing. They were measuring things a little differently.
And this is one reason business numbers don’t match more often than owners realize.
Sometimes nothing has disappeared.
Two reports are simply answering two different questions.
Mystery mostly solved.
Except that while we were investigating the small number, we found a much larger one.
And that number changed the conversation.
The Number That Looked Terrible
The business owner was trying to understand how the company was performing year-to-date.
So we pulled up the profit-and-loss statement.
It was ugly.
Not:
“Hmmm. I want that margin to be a little better.”
Ugly.
More like:
“Did I accidentally create a charity for my customers and forget to tell myself?”
That kind of ugly.
If you have ever opened a financial report and immediately felt your stomach drop, you know exactly what happens next.
Your brain skips right past analysis and heads directly to:
OH MY GOD.
This is where I want business owners to develop a different reflex.
Before you panic, make the report prove itself.
The report looked bad, but it also wasn’t complete.
There was missing revenue in the view we were discussing.
Additional revenue was sitting elsewhere and had not yet been properly reflected.
Once we found it, the picture improved.
Good news.
Except…
It still wasn’t good enough.
And that may have been the most important part of the entire conversation.
Finding an Error Does Not Make the Bad News Disappear
There are two very human ways to react when a financial report looks terrible.
The first is:
Panic before verifying it.
The second is almost the exact opposite:
Find one error and use it as permission to dismiss everything you didn’t want to hear.
“Well, see? The report was wrong.”
Maybe.
But how wrong?
That matters.
If a report says you lost $100,000 and we find $5,000 of missing revenue, we have absolutely improved the report.
We have not magically created a profitable company.
Correcting the report and correcting the business are two different things.
That was the real issue here.
Some of what looked scary was a reporting problem. Another part was a real operating problem.
My job was to separate the two.
That distinction is critical when business numbers don’t match.
The discrepancy may be an accounting issue.
What you discover underneath it may be a business issue.
I could have told the owner:
“Don’t worry. We found the missing revenue.”
Technically, that would have been true.
It also would have been incomplete.
If the current cost structure still doesn’t work after we correct the revenue, I have made the owner feel better without helping her make a better decision.
That is not useful.
I am not interested in financial reports that make you feel better.
I am interested in financial information that helps you run the business better.
A Financial Report Is Not Automatically the Truth
We give software a lot of authority.
QuickBooks says it.
The CRM says it.
The dashboard says it.
The spreadsheet says it.
So it must be true.
Except software does not know whether your number makes sense.
Software knows how to total whatever you gave it.
That is not the same thing.
Every financial report has a chain behind it.
A real transaction happened. Someone captured it and categorized it. A date was assigned. A reporting method was selected. Eventually, somebody ran the report and looked at the result.
If something breaks anywhere in that chain, you can have a report that is mathematically perfect and operationally misleading.
When business numbers don’t match, software can help us find transactions.
It cannot decide which number makes sense in the context of what is actually happening in your business.
That is where judgment enters the room.
Curiosity Is a Financial Control
One of the most underrated financial controls in your business is not another piece of software.
It is curiosity.
If revenue suddenly drops and you don’t know why, ask.
A payroll jump that makes no sense deserves another question.
If a margin looks completely disconnected from what happened operationally, investigate it.
And if the books say you had an incredible month, but your bank account looks like it needs emotional support?
Definitely ask.
Where is that number coming from?
You do not need an accounting degree to ask that question.
You need enough ownership in your business to refuse to make an important decision based on a number no one can explain.
After you have looked at enough businesses, you develop a strange little internal alarm.
A number can be technically possible and still make me think:
Nope. I don’t believe you yet.
That is not magic.
It is pattern recognition.
Possible and probable are not the same thing.
I would much rather spend ten minutes investigating a suspicious number that turns out to be right than train myself to ignore something that doesn’t fit.
Then I Had to Stop Chasing the Wrong Number
Now we had another problem.
Me.
Because once I know something doesn’t tie, there is a part of my brain that would happily keep going.
And going.
And going.
I could spend another hour getting three sources to agree down to the dollar.
There is something deeply satisfying about finally finding the transaction and thinking:
THERE YOU ARE.
But eventually, financial accuracy has to meet business judgment.
So I had to ask:
If I find the remaining difference, will it change the decision we need to make?
That question changed the investigation.
Accurate books matter.
I am never going to tell you accuracy doesn’t matter.
But materiality matters too.
There is a point where you can spend $1,000 worth of time solving a $700 mystery while a $70,000 problem sits three rows below, waving both arms.
This Is Where Bookkeeping Becomes Advisory
Bookkeeping asks:
What happened, and is it recorded correctly?
Advisory adds:
What does it mean, and what are we going to do about it?
You need both.
You cannot make good decisions from unreliable information.
At the same time, you can waste an impressive amount of time making an immaterial number prettier while the actual problem continues merrily along.
The owner in this story did not really need me to win a financial scavenger hunt.
She needed to know whether the business, with its current revenue and its current cost structure, was working.
That was the bigger question.
That was the CEO question.
And suddenly the tiny mismatch that started this whole thing had done its job.
It made us look closer.
What to Check When Business Numbers Don’t Match
The next time a financial number surprises you, resist the urge to immediately decide whether it is good or bad.
Start with:
Where did this number come from?
Then ask:
- What time period does this number represent?
- Is the report on a cash or accrual basis?
- Are we looking at invoiced revenue or collected revenue?
- Does the number include reimbursements or pass-through money?
- Were all transactions entered and categorized?
- Is anything sitting uncategorized?
- Was the report run before something was updated?
- Is one report using a different definition than another?
- What changed from the previous period?
- Can we trace the number back to the underlying transactions?
- If we correct the discrepancy, does it change the decision we need to make?
That last question matters more than people realize.
The goal when business numbers don’t match is not simply to force every report into agreement.
The goal is to understand the difference well enough to know whether it changes what you do next.
This Is the Part CEOs Need to Get Good At
As your business grows, you will have more numbers, systems, reports, and accounts.
More people will engage with the information, too.
That creates more opportunities for two perfectly intelligent people to walk into the same meeting with two completely different answers.
The answer is not for you to check every transaction yourself.
Please don’t.
The answer is to develop enough financial fluency to know when something deserves another question.
You should be able to look at a report and say:
“That doesn’t fit with what I know happened this month.”
Maybe the question is:
“Why is revenue up but cash is down?”
Another month, it might be:
“Why did payroll increase faster than revenue?”
Sometimes all you need is:
“Show me where that came from.”
That is CEO behavior.
It is not memorizing accounting rules.
It is refusing to outsource your understanding of your own business.
There is a big difference.
Venus’ Bottom Line
The best financial report is not the prettiest one.
It does not need the fanciest dashboard either.
And not every number has to tie perfectly the first time for the report to be useful.
The best financial report is the one you can trust enough to make a decision from.
Trust does not come from the fact that QuickBooks generated it.
Trust comes from being able to explain:
Where did this number come from?
What does it mean?
Does it make sense based on what is happening in the business?
Does it change what we do next?
In this case, the math being off was not really the story.
It was the clue.
We started by chasing a number that didn’t match.
We ended up asking whether the business itself did.
And that is usually how these things go.
You think you called me because something in the spreadsheet looks weird.
Then we pull on the thread.
Suddenly we are talking about how the business actually works.
Somehow, this stuff always becomes my problem.
Good thing I like problems.
Think Your Numbers May Be Hiding Something?
You do not need another financial report you never look at.
You need to know what your numbers are trying to tell you.
Take the Profit Hiding Quiz to find out where money may be disappearing inside your business and what to look at first.
Next Episode
Sometimes the problem is not one number being wrong.
Sometimes the books have to be taken apart like a piece of furniture somebody assembled without reading the instructions.
