If that sounds familiar, here's the good news: it's almost never a broken formula. It's an undefined one. And once you see the real cause, it's fixable — permanently.

The number isn't wrong. It's ambiguous.

Two reports disagree because the people who built them quietly answered a definitional question in different ways. "Revenue" sounds precise, but underneath it hides a stack of decisions:

  • Is it booked when the order is signed, when it ships, or when the invoice is paid?
  • Do we count returns and credits? Net of discounts, or gross?
  • Does it include the intercompany transfer, the deposit, the deferred portion?

Finance answers those one way because they're closing the books to a standard. Operations answers them another way because they're tracking what actually moved. Neither is lying. They're measuring two different things and calling them the same word.

Most reporting arguments aren't about numbers. They're about definitions nobody wrote down.

Why it gets worse as you grow

When a company is small, one person holds all the definitions in their head, so the numbers agree. As you add systems — a CRM here, an ERP there, a warehouse app, a pile of spreadsheets — each system encodes its own version of the definition. Now the mismatch is baked into the tools, and every new report inherits it. That's why "let's just build a dashboard" so often makes it worse: a dashboard on top of conflicting definitions just renders the conflict faster.

How to fix it for good

The durable fix has three steps, and none of them is "buy new software":

  • Agree on the definition. Get finance and operations in a room and write down, in plain language, what each key metric means and when it's counted. This is the hard part, and it's a business conversation, not a technical one.
  • Encode it once. Put that definition into a shared data model — a single layer the reports draw from — instead of re-implementing it in every spreadsheet and tool.
  • Point every report at that model. Now finance and operations can slice the data however they like, and the top-line number still reconciles, because it's computed in exactly one place.

The result isn't just matching numbers. It's meetings that start from a figure everyone trusts, so the conversation moves straight to the decision.