Oops! Something went wrong while submitting the form.
Sign in
Get a Demo
Talk with an accountant.
Learn how to calculate NDR with clear steps, practical examples, and tips for accurate tracking to measure your company’s customer revenue growth.
Acquiring new customers is expensive. What if you could measure your company's growth without even factoring in new sales? That's exactly what Net Dollar Retention (NDR) does. It’s a powerful metric that shows you how much your revenue from existing customers has grown or shrunk over a period. An NDR over 100% means your current customer base is so successful with your product that their expansion revenue is outpacing any losses from churn. It’s the ultimate proof of customer loyalty and product value. In this article, we’ll break down the components of this metric and show you how to calculate NDR step-by-step.
Think of Net Dollar Retention (NDR) as a health report for your relationship with your existing customers. It’s a metric that shows you how much your recurring revenue has grown or shrunk from your current customer base over a specific period, usually a month or a year. It completely ignores any revenue from new customers you acquired during that time.
Instead, NDR focuses on the journey of the customers you already have. It starts with your recurring revenue at the beginning of the period, then adds any extra revenue from those customers—like upgrades or new product purchases (this is called expansion revenue). Finally, it subtracts any revenue you lost from customers who downgraded their plans or canceled their subscriptions altogether (this is churn and contraction). The final number gives you a clear picture of whether your existing customers are, on average, spending more with you over time. It’s a powerful way to measure customer loyalty and the value your product delivers long after the initial sale.
For any subscription-based company, NDR is more than just a number on a dashboard; it’s a critical indicator of sustainable growth. A high NDR (over 100%) means your business is growing from your existing customers alone, even without signing up a single new one. This is a huge signal to investors and your internal team that you have a strong product-market fit and a happy, engaged customer base.
A healthy NDR shows that your upselling and cross-selling strategies are working. It proves that customers find so much value in what you offer that they’re willing to invest more over time. This kind of growth is often more efficient and profitable than constantly spending money to acquire new customers. Ultimately, NDR helps you understand your company's growth potential and risk, highlighting how well you’re not just keeping customers, but also making them more successful with your product. You can find more insights on financial metrics on our blog.
It’s easy to mix up NDR with other retention metrics, but the differences are important. For instance, customer retention simply tells you the percentage of customers you kept over a period. You could have 95% customer retention, but if your highest-paying customers left, your revenue could still take a major hit.
NDR is different because it’s dollar-based. You might lose a few small customers, but if your remaining ones upgrade to higher-tier plans, your NDR can still be well over 100%. It also differs from Gross Dollar Retention (GDR), which only accounts for the revenue you keep, factoring in churn and downgrades but ignoring any expansion revenue. GDR tells you how well you retain your existing revenue baseline, while NDR shows you the full picture of revenue growth from your customer base, often driven by strong product integrations that add more value.
To get an accurate Net Dollar Retention rate, you need to track four key pieces of your revenue puzzle. Think of it as a financial story that unfolds over a specific period, like a month or a quarter. You start with your initial revenue from existing customers and then account for all the changes—the good, the bad, and the in-between. This means tracking new revenue from happy customers who want more, as well as revenue lost from customers who downgrade or leave entirely.
Getting these four components right is non-negotiable for a meaningful NDR. Each one tells you something different about your customer relationships and the value you’re providing. When you put them all together, you get a clear, comprehensive picture of your company's health and its potential for sustainable growth. Let's break down exactly what you need to measure.
Think of this as your starting line. Your starting revenue baseline is the total monthly recurring revenue (MRR) you have from your existing customers at the beginning of the period you're measuring. For example, if you're calculating NDR for April, your baseline is your MRR on April 1st. This figure is the foundation of your entire calculation; it’s the constant against which all other changes are measured. It’s crucial that this number is accurate, as any error here will throw off your final NDR percentage. Proper revenue recognition practices are essential to ensure you’re starting with a clean, reliable number.
This is the growth you generate from within your current customer base. Expansion revenue is any additional recurring revenue you earn from existing customers who spend more with you. This can happen in a few ways: they might upgrade to a more premium plan, add more users to their account, or purchase an add-on or a different product (a cross-sell). Expansion is a powerful indicator of customer satisfaction and loyalty. It shows that your customers are finding so much value in your service that they’re willing to invest even more, which is a fantastic sign for the long-term health of your business.
On the other side of the coin, you have churn. Churned revenue is the MRR you lose when a customer cancels their subscription and leaves for good. This is a direct deduction from your revenue baseline. Every subscription business experiences some level of churn, but the goal is to keep this number as low as possible. Tracking churn is critical because it highlights potential issues with your product, pricing, or customer service. When a customer leaves, you don't just lose their revenue; you also lose the opportunity for any future expansion from them. Understanding why churn happens is the first step to preventing it.
Contraction is a bit more subtle than churn, but it still represents a loss in revenue. This happens when an existing customer reduces their spending without canceling their subscription entirely. They might downgrade to a cheaper plan, remove a few user licenses, or drop an add-on service they no longer need. While it’s certainly better than losing the customer completely, contraction still negatively impacts your NDR. Accurately tracking these small reductions is a common challenge, but it's essential for a true financial picture. This is where having solid data integrations becomes incredibly important to catch every change.
Calculating your Net Dollar Retention might sound complicated, but it’s really about tracking how your revenue from existing customers changes over time. Think of it as a health check for your customer base. It tells you if you're successfully growing accounts, holding steady, or losing ground, all without factoring in any new customers. Getting this number right is key to understanding your company's long-term growth potential. Let's break down how to do it, step by step.
The formula for NDR is straightforward. You take your starting revenue, add any growth from existing customers, subtract any losses, and then divide it by your starting revenue. This gives you a percentage that shows your revenue growth from the customers you already have.
Here’s the formula in plain English:
(Starting Revenue + Expansion Revenue – Churn Revenue – Contraction Revenue) / Starting Revenue
Let’s put the formula into action with a simple scenario. Imagine you start the month with a Monthly Recurring Revenue (MRR) of $50,000 from your existing customers.
Over the month:
Here’s the calculation: ($50,000 + $7,000 - $3,000 - $1,000) / $50,000 = $53,000 / $50,000 = 1.06
To get the percentage, you multiply by 100. So, your NDR for the month is 106%. This means your existing customer base grew by 6%, which is a great sign of a healthy business.
While the formula is simple, small errors can throw off your results. One common mistake is only tracking upgrades and forgetting about downgrades (contraction). Every dollar lost from a customer scaling back is just as important as a dollar gained from an upsell. Another pitfall is inconsistent tracking. If your team doesn't have a standard way to define and record MRR, churn, and expansion, your data will be unreliable. This is often a symptom of disconnected systems, where your CRM, billing platform, and accounting software aren't speaking the same language. Using tools with solid data integrations is essential for getting a single, accurate view of your revenue.
So, you've calculated your Net Dollar Retention. Now comes the big question: is your number any good? While the definition of "good" can vary a bit depending on your industry and who you sell to, there are some solid benchmarks you can use to see how you stack up. The simplest rule of thumb is that an NDR of 100% or higher is a sign of a healthy, growing business. Anything over 100% means your existing customers are generating more revenue for you over time, which is exactly what you want to see. An NDR below 100%, on the other hand, signals that you're losing revenue from your current customer base. Let's break down what these numbers mean in more detail.
For most subscription-based companies, especially in SaaS, a good NDR falls somewhere between 100% and 111%. Hitting that 100% mark is the baseline—it shows you’re retaining the revenue you have. Anything above that indicates you’re successfully getting customers to spend more through upgrades or add-ons. If you really want to impress investors and stakeholders, aim for the "best-in-class" tier, which is typically 120% or higher. This is especially true for businesses that serve mid-market and enterprise clients with larger contracts. For companies with a high volume of smaller customers, staying consistently above 100% is still a strong indicator of success. You can find more insights on SaaS metrics on our blog.
Your NDR score is more than just a number; it’s a story about your relationship with your customers. An NDR over 100% tells a great story: your customers are happy, they see value in your product, and they’re willing to invest more. It’s a direct reflection of successful upselling strategies and strong product engagement. A high NDR is also a huge nod to your customer success and support teams, showing they’re doing an excellent job keeping customers satisfied. Conversely, an NDR below 100% is a warning sign that you’re losing revenue from your existing base, likely due to churn or downgrades. This tells you it’s time to dig into your customer experience and find out what’s going wrong. Getting a clear view of this data is the first step, and we can help you schedule a demo to see how.
On the surface, the formula for Net Dollar Retention seems straightforward. But as anyone in finance or operations knows, the real challenge isn't the math—it's getting the right numbers to plug into the formula in the first place. Calculating an accurate NDR requires pulling together precise data from different parts of your business, and that’s where things get complicated. While NDR is a fantastic metric for monitoring how healthy your business is, its value is completely dependent on the quality of the data you use.
The main hurdles come down to data. Your customer information, billing records, and revenue data are often spread across multiple systems that don’t talk to each other, like your CRM, your payment processor, and your accounting software. This creates a messy, fragmented picture that makes it tough to track customer behavior accurately. To get a reliable NDR, you need a single source of truth. Without it, you’re left trying to piece together a puzzle with mismatched pieces, leading to a metric you can't fully trust. The three biggest culprits behind a difficult NDR calculation are poor data integration, complex revenue recognition rules, and inconsistent tracking methods across your company.
To calculate NDR, you need several key figures: your starting recurring revenue, expansion revenue from upgrades, contraction revenue from downgrades, and churned revenue from lost customers. The problem is, this data rarely lives in one place. Your starting revenue might be in your billing system, upgrade information in your CRM, and churn data in a customer support platform. Manually exporting, cleaning, and combining these datasets every month is not only a huge time sink but also a recipe for human error. A single copy-paste mistake or a misaligned spreadsheet column can throw off your entire calculation. This is why having seamless integrations between your systems is so critical for creating a unified view of your revenue data.
Another major challenge is aligning your NDR calculation with proper accounting standards like ASC 606. Revenue isn't just about the cash you collect; it's about when you actually earn it. This gets tricky with subscription changes. If a customer upgrades mid-month or you offer a prorated credit for a downgrade, how do you accurately reflect that in your revenue figures for the period? Misinterpreting these events can easily inflate or deflate your NDR, giving you a false sense of security or causing unnecessary panic. A high NDR should reflect genuine customer satisfaction and growth, but that's only true if the underlying revenue is recognized correctly and in compliance with accounting principles.
Even if you manage to pull data from all your systems, you might find that different departments define key terms differently. Your sales team might log an "upsell" in the CRM, while your billing system processes it as a new, separate subscription. What exactly counts as churn? Is it when a customer clicks "cancel," or when their subscription period officially ends? These inconsistencies create data discrepancies that make a reliable NDR calculation impossible. Ultimately, net dollar retention is a key metric for monitoring how healthy your business is. But to be a truly useful health check, everyone in the company needs to be working from the same playbook with standardized definitions and tracking.
Improving your Net Dollar Retention isn't about a single magic bullet; it's about a focused, two-part strategy: keeping the customers you have and helping them grow with you. Think of it as playing both offense and defense. Your defense is minimizing churn—stopping revenue from walking out the door. Your offense is driving expansion revenue—finding opportunities for upsells and cross-sells within your happy customer base. When you get both of these motions right, your NDR will climb.
A high NDR is more than just a vanity metric; it's a clear signal that your business is healthy. It shows that you're not just acquiring new customers, but you're also delivering so much value that your existing ones are sticking around and spending more over time. This reflects positively on everything from your product's stickiness to your customer satisfaction. If your NDR is low, it’s a red flag that something is off. It could be an issue with your onboarding process, a gap in your customer support, or even a sign that you're attracting the wrong type of customer in the first place. By digging into the "why" behind your number, you can build a solid plan to strengthen customer relationships and grow your revenue from the inside out.
The first step to improving NDR is to plug the leaks in your revenue bucket. If customers are leaving, you need to understand why. A low NDR often points to underlying issues that need attention. Are customers struggling during onboarding? Is your technical support team overwhelmed? Perhaps the product itself isn't meeting expectations, or maybe your marketing is attracting customers who aren't a good fit for what you offer. To get answers, you need to create feedback loops. Talk to your customers, send out surveys, and analyze usage data to pinpoint where they're getting stuck or losing interest. Reducing churn is all about being proactive and solving problems before they lead to a cancellation.
Once you've shored up your defenses against churn, it's time to go on offense. Expansion revenue is the engine that drives your NDR above 100%. This comes from upselling and cross-selling to your existing customers. The key is to make it a natural next step in their journey with you. Your customer success team plays a huge role here by ensuring customers are getting the most out of your product. When they see real success, they're more open to adding new features or upgrading to a higher tier. Make the benefits of upgrading crystal clear and align your pricing tiers with the value customers receive as they grow.
Ultimately, both reducing churn and increasing expansion revenue come down to one thing: a strong customer success program. A great NDR is proof that your customer-facing teams are doing their jobs well. It all starts with a smooth and effective onboarding process that sets customers up for success from day one. From there, it's about maintaining that relationship. Regularly check in, ask for feedback on what they like and what could be better, and then actually use that information to make improvements. When customers feel heard and supported, they don't just stick around—they become your biggest advocates and a reliable source of growth.
If you’ve ever tried to calculate Net Dollar Retention using a patchwork of spreadsheets, you know how quickly it can turn into a data nightmare. Manually pulling numbers from different systems is not only tedious but also a recipe for errors that can give you a completely skewed view of your business's health. The truth is, getting NDR right isn't about being a spreadsheet wizard; it's about having the right tools in your corner.
To track NDR accurately and efficiently, you need a system that does the heavy lifting for you. This means moving away from manual data entry and embracing technology that can handle the complexities of subscription revenue. The right software will not only save you countless hours but also provide the reliable data you need to make smart strategic decisions. Specifically, you should focus on two key areas: automated revenue recognition and solid data integrations. These two components work together to create a seamless flow of information, ensuring every upgrade, downgrade, and churn is captured correctly and reflected in your NDR.
Relying on manual processes to track revenue changes is like trying to count raindrops in a storm—you’re bound to miss a few. This is where automated revenue recognition platforms become a game-changer. These tools are designed to automatically track all the financial events that impact your NDR, including monthly recurring revenue (MRR), expansion from upsells, contraction from downgrades, and customer churn.
Instead of spending days reconciling numbers, you get an accurate, real-time picture of your revenue streams. This automation eliminates human error and ensures your NDR calculation is based on clean, reliable data. It gives you confidence that the metric you’re reporting to investors and using for internal planning is a true reflection of your company's performance and customer satisfaction.
Your customer data doesn't live in a single place. It’s spread across your CRM, billing platform, and other business systems. Without a way to connect these dots, you’re left with data silos that make accurate NDR tracking nearly impossible. This is why having solid integrations is non-negotiable.
When your tools talk to each other, you create a single source of truth for all your customer and revenue data. A change in a customer’s subscription in your billing system is automatically reflected in your financial analytics, ensuring nothing falls through the cracks. This seamless data flow is essential for tracking customer success metrics accurately and understanding the story behind your NDR number, whether it’s soaring high or needs a little help.
Can my NDR really be over 100% if I lost some customers this month? Yes, absolutely! This is what makes NDR such a powerful metric. It means that the extra revenue you earned from your remaining customers—through upgrades, add-ons, or new purchases—was more than enough to cover the revenue you lost from the customers who left or downgraded. It’s a strong signal that your product is delivering so much value that your happiest customers are growing with you.
What's the difference between Net and Gross Dollar Retention again? Think of it this way: Gross Dollar Retention (GDR) is purely about defense. It measures how much of your starting revenue you held onto, only accounting for losses from churn and downgrades. Your GDR can never be higher than 100%. Net Dollar Retention (NDR) includes both defense and offense. It starts with that same baseline but also adds in all the expansion revenue you generated, giving you the full picture of growth from your existing customer base.
How often should we be calculating our NDR? For most subscription companies, calculating NDR on a monthly basis is a great rhythm. It gives you a frequent and consistent pulse on the health of your customer relationships, allowing you to spot trends or potential issues before they become major problems. Many businesses also track it quarterly for board meetings and higher-level strategic planning, as this can smooth out any short-term fluctuations.
Why is using a spreadsheet to track NDR such a bad idea? While it might seem like the easiest option, tracking NDR in a spreadsheet is risky because the data you need lives in different systems. Manually pulling numbers from your CRM, billing platform, and accounting software every month is not only tedious but also opens the door to human error. A single copy-paste mistake or a misaligned formula can give you a number you can't trust, leading you to make decisions based on faulty information.
My NDR is below 100%. What's the first thing I should investigate? If your NDR is dipping below 100%, your first step is to dig into the "why" behind your churn and contraction numbers. You need to understand the reasons customers are leaving or reducing their spending. Start by looking for patterns in customer feedback, support tickets, and product usage data. A low NDR is often a symptom of a deeper issue, such as a difficult onboarding experience, a missing feature, or a disconnect between what your product promises and what it delivers.
Former Root, EVP of Finance/Data at multiple FinTech startups
Jason Kyle Berwanger: An accomplished two-time entrepreneur, polyglot in finance, data & tech with 15 years of expertise. Builder, practitioner, leader—pioneering multiple ERP implementations and data solutions. Catalyst behind a 6% gross margin improvement with a sub-90-day IPO at Root insurance, powered by his vision & platform. Having held virtually every role from accountant to finance systems to finance exec, he brings a rare and noteworthy perspective in rethinking the finance tooling landscape.
Meet with an expert in revenue recognition and order-to-cash accounting and automate revenue close.
*Or watch 2 minute demo here.
Power your high-volume business's revenue compliance and reporting needs with one platform.
