When your numbers don't agree, the problem is almost never the math — it's that each system is measuring a slightly different thing. Your P&L, your CRM, and your ops log were each built to answer a different question, so they will never reconcile to the penny. The job isn't to force them to match. It's to find the single largest gap, trace it to its source, and act on that one thing. This post gives owner-operators a five-day diagnostic for doing exactly that.
Your P&L shows $4.2M in revenue. Your CRM says you closed $3.8M. Your ops log counts 410 completed jobs that should add up to something in between. None of them is wrong. They're answering different questions, on different timelines, with different definitions of "done."
Most reporting gaps trace back to timing and definitions, not errors. Revenue is recognized when invoiced; the CRM logs the deal when it's marked closed-won; the ops log records the work when it's delivered. Three honest systems, three different clocks. This is also why bad data quietly drains time: sales teams reportedly lose over 500 hours a year — roughly 27% of selling time — chasing invalid or outdated records (SpurIQ RevOps research, 2026). The fix isn't more dashboards. It's knowing which gap to act on.
Step 1 — Identify the largest gap first. Don't try to reconcile everything. Line up the three numbers and find the single biggest discrepancy. That gap is where your decisions are most at risk.
Step 2 — Trace the gap to its source. Most gaps live in one of three places: a timing difference, a definition mismatch, or a handoff where data is re-entered by hand. Follow the largest gap back until you can name which one it is.
Step 3 — Act on the gap, not the average. Once you know the source, you can decide with confidence — without waiting for the systems to magically agree. For the pattern behind definition mismatches, see Three Teams, Three Definitions of 'Qualified Lead' and why your CRM and ops log will never agree.
The sprint we run at Brookwood Growth takes one number you can't currently defend and traces it to a source you can. You finish the week able to say, in plain language, why the number is what it is and what to do about it. If you want to understand the leak it usually surfaces, read The One Number That Tells You Where Your Business Is Leaking.
Three honest systems, three different answers — the diagnostic finds which gap to act on.Because each was built to answer a different question on a different timeline. The P&L recognizes revenue when invoiced, the CRM logs deals when closed-won, and the ops log records delivered work. They aren't supposed to reconcile to the penny.
Trust the one tied to the decision you're making. For cash decisions, follow the P&L; for pipeline decisions, the CRM; for capacity, the ops log. Then trace the largest gap to its source before acting.
Five working days. One day to line up the numbers, two to trace the largest gap to its source, and two to decide and document the action.
No. The gap is almost always a timing difference, a definition mismatch, or a manual handoff — process problems, not tooling problems.