Reconciling spend and revenue: a walkthrough

Reconciling spend and revenue is less glamorous than it sounds. There’s no clever model. It’s three disciplined steps, and the value is entirely in doing each one honestly.

Here’s the walkthrough we run for every new account, in order.

Step one: pull both sides in full

Spend from every ad channel; revenue from the billing system or CRM. Not summaries: the raw events, with their timestamps and identifiers intact. If you start from someone else’s rollup, you inherit their definition of “return” before you’ve even begun.

Step two: join on the actual customer

This is where reconciliation lives or dies. A click, an install, and a paying account have to resolve to the same person, and a single signup must never be counted by more than one channel. Deduplication isn’t a cleanup step; it’s the whole point. Get this wrong and every downstream number inherits the error.

Step three: hold one definition

With both sides joined, apply a single definition of return (one revenue window, one cost base) across every channel at once. Now the comparison is fair, and the number reconciles: total spend and total revenue tie out to the same reality your finance team already trusts. That tie-out is what makes the ROI defensible in the room where budgets get decided.