
How to calculate net revenue retention
Net revenue retention shows how much revenue your existing customers bring in today. Here is the formula, a worked example and how to work it out from CRM data.
Short answer
Net revenue retention shows how much revenue you earn today from the customers you already had a year ago. The formula is starting revenue plus expansion, minus contraction and churn, divided by starting revenue. Above 100 percent, your existing customers grow the business even if you win no one new.
What is net revenue retention?
Net revenue retention is the revenue a fixed group of customers brings in at the end of a period, divided by what the same group brought in at the start. New customers won during the period are left out. It only looks at the accounts you already have.
That makes it answer a question separate from new business: are your existing customers growing or slowly fading away?
How do you calculate net revenue retention?
You calculate it by adding up four figures separately. The formula is:
(Starting revenue + Expansion − Contraction − Churn) ÷ Starting revenue × 100
- Starting revenue: what the customers on your list at the start of the period paid you over the previous 12 months.
- Expansion: extra revenue from the same customers through more products, more locations or bigger orders.
- Contraction: the drop when a customer stays but buys less.
- Churn: last year's revenue from customers who stopped buying entirely.
A worked example: last year 40 customers paid you 1,000,000. This year 8 of them added 250,000 in new orders, 6 bought 90,000 less, and 3 stopped buying. Those 3 had paid 110,000 last year. The result: (1,000,000 + 250,000 − 90,000 − 110,000) ÷ 1,000,000 = 105 percent.
How is it different from gross revenue retention?
Gross revenue retention ignores expansion and only subtracts contraction and churn. With the same numbers it comes to (1,000,000 − 90,000 − 110,000) ÷ 1,000,000 = 80 percent.
Read the two together. A net rate of 105 with a gross rate of 80 means a handful of growing accounts is covering a leak everywhere else. If those few accounts slow down, the picture flips quickly.
Why does it matter more than new customer count?
Because revenue from an existing customer costs less to earn than revenue from a new one. A new account needs an introduction, a demo, a proposal and a negotiation. With an existing account the relationship is already there.
A company at 90 percent has to replace a tenth of its revenue with new customers every year just to stand still. A company at 110 percent grows before it signs anyone new. With the same sales team, their year-end results look very different.
Why can't you calculate it from your CRM as it is?
In most companies the four figures don't sit cleanly in your CRM or ERP. Invoices live in the ERP, but nobody has written down why a customer shrank.
Three problems show up again and again:
- Customers are split across records. The same company exists under two legal names, or each branch is a separate record. When one branch leaves and another grows, churn and expansion blur together.
- There is no churn date. Nobody marks a customer as lost; orders just stop coming. Months pass before anyone notices.
- Contraction has no reason attached. Did they switch to a competitor, cut budget, outgrow the product? The rep hears it on a call, but it never reaches the CRM.
How do you work it out step by step?
Clean the customer list first, then split the four figures customer by customer:
- List every customer invoiced at least once before the period started.
- Merge duplicate records and branches under one parent account.
- Put last year's and this year's revenue side by side for each customer.
- Mark the difference as expansion if positive, contraction if negative, churn if this year is zero.
- Plug the four totals into the formula and write the gross rate next to it.
- Add a one-line reason for every customer that shrank or left.
The last step is the one most teams skip, and it is the one that makes the number useful. Without reasons, the rate is just a number.
Where should you look first if the rate is low?
Start by checking whether the loss sits in a few accounts or across the base. If the five biggest losses make up more than half of all churn, it usually points to account management; if it is spread wide, look at product or pricing.
Next, check the last contact date for shrinking customers. If nobody has spoken to them in 90 days, it is a sales attention problem. That is why spotting churn early with CRM data matters.
Finally, look at where expansion comes from. If it always comes from the same product line, cross-sell potential in other lines may be sitting idle. Tracking repeat orders in your CRM makes that visible.
FAQ
What is a good net revenue retention rate?
Anything above 100 percent means existing customers grow the business on their own. Below that, compare it with the gross rate to find where the leak is.
Should it be measured monthly or yearly?
For B2B companies with irregular orders, yearly is more reliable. Monthly figures swing with seasonal orders and can mislead.
Do price increases count as expansion?
Yes, they land in expansion. In high-inflation periods, track price and volume growth on separate lines to see real growth.
Is a customer opening a new branch a new customer?
No. A new branch of the same company counts as expansion. Counting it as a new customer makes your rate look lower than it is.
Do you need a separate tool for this?
No. Invoice data from your CRM or ERP and a clean customer list are enough. The hard part is not the math, it is clean data.
Closync AI is a decision partner that connects to your CRM and ERP: it points out missing and inconsistent records, tells you which deals are at risk and turns your team's call notes into the right CRM fields.
Last updated: 18 November 2026


