Net revenue retention when CRM and billing disagree

Net revenue retention measures how recurring revenue changes within an existing customer cohort. CRM and billing reports can disagree because they use different dates, account identities and revenue definitions. Reconcile those choices before choosing a result, then distinguish contracted expansion, billed activity and recognized revenue when discussing retention with finance.

By SIGNLD Editorial · · 7 min read · Core Concepts
CRM, support and accounting records compared to examine net revenue retention calculation.

What is covered?

What does net revenue retention measure?

Net revenue retention, or NRR, measures how much recurring revenue remains from customers present at the start of a period, after their expansion, contraction and churn. It answers whether the existing customer base is growing or shrinking in revenue terms. It does not measure acquisition, gross profit or cash collection.

A net revenue retention calculation needs a fixed opening cohort and a consistent recurring revenue basis. Keep new customers outside the numerator even when the sales team includes them in a period total. Retain customers that leave during the period in the cohort so their lost revenue is visible.

Retention is only part of the commercial picture. The guide to which customers cost more than they pay explains why retained revenue can still carry an unattractive service burden. A growing account is not automatically a profitable account.

How do you calculate NRR?

Use this formula on comparable recurring revenue amounts:

NRR = ((Starting recurring revenue + Expansion recurring revenue - Contraction recurring revenue - Churned recurring revenue) / Starting recurring revenue) × 100%.

Every movement belongs to the opening cohort. Expansion is additional recurring revenue from those customers; contraction is a reduction among customers that remain; churn is the loss from customers that leave. Do not count the same reduction as both contraction and churn. If starting recurring revenue is zero, the ratio is undefined.

In an illustrative example, starting monthly recurring revenue is an illustrative 100,000 currency units. Expansion is an illustrative 12,000, contraction an illustrative 5,000, and churn an illustrative 7,000. Ending cohort revenue is an illustrative 100,000, producing an illustrative NRR of 100%. New customer revenue is excluded regardless of its amount.

Choose monthly or annual recurring revenue and use that basis throughout. An annual invoice should not appear as an isolated monthly expansion simply because the invoice was issued in that month. Document treatment of credits, pauses, usage charges and reactivations before calculation.

Why do CRM and billing disagree?

The CRM often describes a commercial commitment. Billing describes charges under an operational schedule. A signed expansion may appear in the CRM before the service starts, while billing may show a credit after a cancellation has already been recorded elsewhere. Different timestamps create different period boundaries.

Identity is another common cause. Sales may manage a parent company while billing maintains separate subsidiaries or subscriptions. Counting an account transfer as churn in one place and a new customer elsewhere distorts the cohort. Preserve a mapping between commercial accounts, billing customers and the agreed reporting entity.

Also check whether the reports compare recurring contract value, invoices or payment receipts. These are different measures. An unpaid invoice is not automatically churn, and collected cash can reflect old balances rather than current recurring business. Currency conversion policies can introduce another difference even when the underlying customer activity matches.

Which number should you trust for which purpose?

Use CRM-based recurring commitments for a clearly labeled forward commercial view, provided contract status and effective dates are reliable. It can help account teams see what has been agreed and what remains uncertain. An opportunity marked likely is not the same as an executed recurring commitment.

Use billing-based recurring amounts for a view of active charges when that is your agreed retention definition. Exclude nonrecurring items and normalize billing schedules. Billing still needs validation against contract terms, particularly when credits or delayed administration cross reporting boundaries.

Use accounting records to reconcile the financial treatment, not to silently redefine the metric as recognized revenue. If finance publishes retention on a recognized revenue basis, label that explicitly and explain its relationship to the operational measure. There is no universal winner between applications. The right report is the one whose definition fits the question and whose bridge to the other reports can be explained.

How should you reconcile the opening cohort?

Freeze the opening customer list, revenue basis, period and currency policy. Then build a customer-level bridge from opening revenue to closing revenue. Give each movement a category, effective date and supporting record. Keep unresolved differences in an exception list rather than hiding them in an adjustment.

Ask finance and account operations to review the largest differences together. Check mergers, duplicate accounts, backdated changes and temporary suspensions. Record whether a returning customer counts as a reactivation within the cohort or follows another published policy. Consistency matters more than choosing a flattering treatment.

After corrections, rerun the opening and closing totals and preserve the original version. A restatement should explain what changed and why. Compare the retention review with renewal risk before the renewal date, since an upcoming renewal and a completed revenue movement answer different questions.

How can SIGNLD support the review?

SIGNLD's Knowledge Graph builds automatically from connected sources. For this review, agree the account mappings and revenue definitions before interpreting the results. A Decision Brief should distinguish the chosen retention basis, supporting records and unresolved exceptions rather than blending contract value with collections.

HubSpot, Salesforce, Stripe, QuickBooks and Xero are listed connectors; confirm available fields before planning a cohort reconciliation. A listing does not establish that every historical contract amendment or billing status needed for your policy is available. Check source coverage and effective dates with the people responsible for those systems.

Your data stays yours: read-only connections, a private LLM powered by AWS Bedrock on a single-tenant instance, and we never train on it.

Keep the first review narrow: one reporting period, one currency policy and a documented cohort. Review customer concentration risk alongside retention so that expansion from a large customer does not conceal dependence on that relationship.

Key takeaways

  • NRR tracks an opening customer cohort and excludes revenue from newly acquired customers.
  • CRM, billing and accounting reports can each be correct while measuring different events.
  • Reconcile customer identity, dates and revenue policy before comparing retention figures.

FAQ

Is NRR the same as gross revenue retention?

No. Gross revenue retention excludes expansion and focuses on losses from the opening cohort. NRR includes expansion from that same cohort. Both require consistent revenue definitions and customer identity rules. Looking at them together helps separate the ability to retain existing revenue from the ability to grow surviving accounts.

Should new customers enter the calculation?

Customers acquired after the opening date do not belong in that period’s NRR cohort. Their revenue belongs in acquisition reporting. Decide how to treat subsidiaries added under an existing parent before calculating the metric, because changing the account grouping midway can make acquisition look like expansion without an underlying change in economics.

Does a late payment count as churn?

Not by itself. A late payment is a collections event, while churn concerns the loss of recurring business under your defined policy. Investigate whether service ended, a cancellation became effective or the balance is simply overdue. Keep payment risk visible separately rather than treating every unpaid invoice as lost recurring revenue.

How often should the definition change?

Change the definition when the business model or reporting purpose requires it, not because a period looks weak. Document the reason, owner and effective date. Where practical, provide a comparable prior period under the revised policy and retain the old calculation so readers can understand the effect of the change.

Related reading

Try SIGNLD free

Start with the Free Forever plan or a 14-day Growth trial, no credit card. Create your account, then choose a narrow commercial question and agree the definitions with finance before reviewing the result. Explore the underlying concepts to see where this review fits your team.