Customer retention rate calculator and formula
Use this customer retention rate calculator to enter starting customers, ending customers, and new customers, then check the formula and reporting assumptions.
Is it right for you?
- Use the same reporting period and customer definition each time.
- Count only new customers acquired within the period in the new-customer field.
- Reconcile the three inputs to the underlying customer list.
- Compare like-for-like cohorts before drawing conclusions.
Quick verdict
Customer retention rate shows how much of the customer base you kept during a defined period after removing customers acquired during that same period. Enter the start count, end count, and new-customer count below. The arithmetic is simple; using the same customer definition and date boundaries every period is what makes the number useful.
Customer retention rate calculator
Enter customer counts for one period
Formula: CRR = ((E - N) / S) × 100. S is customers at the start of the period, E is customers at the end, and N is customers newly acquired during the period.
Check the calculation with a worked example
Suppose a business begins a quarter with 250 customers. It ends with 285 customers and acquired 85 new customers during that quarter. The retained customers from the starting group are 285 minus 85, which equals 200.
The retention rate is therefore (200 / 250) × 100, or 80.0%. The starting group lost 50 customers during the quarter. The new customers still matter to growth, but they do not belong in this customer-count retention result.
Fit Small Business uses the same three inputs and explains that subtracting new customers avoids confusing acquisition with retention. CUFinder also states the formula as ending customers minus new customers, divided by starting customers [Fit Small Business; CUFinder, accessed 2026-08-10].
Define each input before you open a spreadsheet
| Input | What to include | Common reporting error |
|---|---|---|
| Starting customers (S) | Customers active at the first instant of the period | Using a month-end count from a different date |
| Ending customers (E) | Customers active at the last instant of the same period | Counting prospects, paused accounts, or unpaid accounts inconsistently |
| New customers (N) | Customers first acquired during the period | Subtracting reactivations in one month but not the next |
| Retained starting customers | E minus N, after the list has been reconciled | Assuming every ending customer was part of the starting cohort |
Choose the customer definition before calculating. A subscription business might define an active customer by a paid account. A retailer might use a customer who made a purchase in a defined window. A service business may use a signed client. The definition can differ by business model; changing it mid-report makes the trend hard to interpret.
Use validation checks before sharing the percentage
First, make sure the reporting period is identical for all three inputs. A start count on January 1, an end count on March 31, and new customers counted through April 2 will distort the calculation.
Second, compare the derived loss number with the cancellation or inactive-account list. In the worked example, 50 lost customers should have a traceable explanation in the underlying records. If it does not, inspect reactivations, merges, duplicate contacts, and changes to the definition of active.
Third, flag an unusual result. A negative retention rate is mathematically possible when the reported end count is smaller than the number of customers newly added, but it usually signals heavy loss from the starting group or a data-definition problem. A rate above 100% in this customer-count formula signals a counting problem. Net revenue retention is a different measure and can exceed 100% because expansion revenue is included.
Customer retention rate, churn, and revenue retention are different
| Metric | Question it answers | Do not substitute it for |
|---|---|---|
| Customer retention rate | How many starting customers remained? | Revenue expansion or contraction |
| Customer churn rate | What share of the starting group left? | A count of new customers gained |
| Gross revenue retention | How much starting recurring revenue remained before expansion? | Customer-count retention |
| Net revenue retention | How much starting recurring revenue remained after expansion and contraction? | A customer count or logo-retention rate |
The customer-count retention rate and churn rate can be complements when both use the same cohort and definition. In the 250-customer example, 80% were retained and 20% were lost. Do not use that shortcut if your company measures churn on revenue or uses a different active-customer rule.
Once the number is stable enough to act on, the follow-up question is what to change. Our customer retention software guide covers the tool categories small teams use for that work.
A reporting rhythm for a small team
Keep a monthly or quarterly customer list with a stable account ID, start status, end status, acquisition date, cancellation date, and reason where available. The calculator can produce a percentage, but the account list explains it.
Review the result with support, sales, and operations. Ask which customers failed to reach first value, encountered unresolved friction, or changed their buying pattern. Then compare those patterns with the following period. A single percentage tells you where to look; it does not diagnose the cause.
Frequently asked questions
Q: What is the customer retention rate formula?
A: CRR = ((E - N) / S) × 100, where E is ending customers, N is customers acquired during the period, and S is starting customers.
Q: Why do I subtract new customers?
A: New customers increase the ending count but were not part of the starting cohort. Subtracting them isolates the customers you retained.
Q: Can this calculator show customers lost?
A: Yes. It calculates retained starting customers as E minus N, then calculates lost starting customers as S minus that retained count.
Q: Can customer retention rate exceed 100%?
A: Not under this customer-count formula. If it does, review the dates and definitions. Net revenue retention can exceed 100% because it includes expansion revenue.
Q: Should I calculate retention monthly or annually?
A: Use the period that matches the buying and renewal cycle, then keep it consistent. Monthly and annual rates should not be compared as if they mean the same thing.
Q: How should I treat paused or reactivated customers?
A: Define the rule before reporting and apply it consistently. Keep a separate field for reactivation so you can audit how it affects the count.