When product retention and invoice cohorts refuse to match

Retention debates rarely start with malice. Product counts “active paying accounts” from an events table; finance counts invoices that cleared. Both feel right until a board slide shows two numbers.

Start from cash, then walk upstream

In our SaaS KPI control reviews we begin with invoice lines for the cohort month, then ask which product identifier can join without fuzzy email matching. If the join key is weak, we stop and fix identity before debating churn formulas.

Document exclusions aloud

Paused contracts, courtesy credits, and migrated legacy plans distort both sides. Write the exclusion list once, attach it to the KPI dictionary, and refuse ad-hoc slide footnotes.

Sample, do not boil the ocean

Pull thirty accounts that disagree across systems. Classify each mismatch: timing, identity, or definition. Patterns in that sample usually explain most of the variance without a six-month data cleanse.

If your diligence pack is stuck on retention, the SaaS KPI Control Review is built for this exact deadlock.