The KPI Reconciliation Problem: Why Marketing and Finance Numbers Never Match

Two correct numbers that disagree

This shows up in almost every company past a handful of people. Marketing reports revenue attributed to a campaign. Finance reports revenue recognized in the general ledger. The two numbers don't match — and neither team made a mistake. They're measuring genuinely different things: attribution timing vs. recognition timing, gross bookings vs. net revenue, self-reported platform data vs. reconciled bank deposits. Both get called "revenue," without the qualifier that would make the difference obvious.

The usual culprits

• Timing — marketing counts revenue when a deal closes or a platform reports a conversion; finance counts it when it's recognized under accounting rules, which can be weeks or months later
• Scope — marketing's number often includes one-time or trial revenue that finance excludes from recurring revenue metrics
• Currency and refunds — platform-reported revenue rarely nets out refunds, chargebacks, or currency conversion the way a finance system does

The fix isn't picking a winner

The instinct is to declare one team's number the "real" one and make the other team adopt it. Usually backfires. Both numbers serve a real purpose — marketing needs attribution-timed data to judge campaign performance while it's still actionable, finance needs recognition-timed data for accurate reporting. The real fix is naming both numbers explicitly, documenting exactly how each is calculated, and being clear in every report which one you're actually looking at.

Reconciling instead of arguing

Once both definitions are documented, reconciliation stops being a debate and becomes a mechanical check. Do the two numbers differ by roughly the expected timing gap? Or is the gap growing in a way that suggests something's actually broken? You answer that by comparing the two datasets on a schedule — same idea as reconciling a dashboard against a direct platform export. Treat it as a routine check, not a recurring argument.

The same pattern shows up everywhere data crosses a team boundary

Marketing vs. finance is the most common version, but the same pattern repeats anywhere two teams calculate a shared concept independently: sales vs. marketing on "qualified lead," product vs. support on "active user," a client's internal team vs. the agency running their campaigns on "conversion." Same fix every time — name both definitions explicitly, then check the gap on a schedule instead of waiting for someone to happen to notice.

Treat it as a recurring, mechanical check, not a one-time cleanup. That's what keeps it from resurfacing as a surprise every time someone new joins either team and rebuilds a report from a slightly different assumption.

Who should own the reconciliation

This works best with one owner responsible for running the check and surfacing discrepancies — not necessarily someone from either team whose numbers are being compared. Easier to stay neutral about who needs to explain a gap when you didn't produce either number. In smaller teams, that's usually whoever owns the KPI dictionary generally. In bigger ones, name it explicitly. Don't assume it happens by default.