Customer Retention Rate Calculator

What this calculator estimates

Customer retention rate measures the share of the customers you had at the start of a period who are still active at the end. It is a cohort-based measure: customers acquired during the period are removed from the ending count before the retained share is calculated. That separation matters because acquisition can make an ending customer total look healthy even while many earlier customers have left.

The calculator also reports attrition rate, retained customers, and lost customers. Attrition is the inverse of retention for the same customer cohort. A 72% retention rate therefore corresponds to 28% attrition. The count outputs make the percentage easier to audit and connect the rate to operational activity.

How to complete each input

Existing customers at start

Enter the number of active customers immediately before the reporting period begins. This field is required and must be greater than zero. Use one consistent definition of “active,” such as an account with a current subscription, a customer who purchased within a defined window, or a contract that had not expired. A larger starting base changes the denominator and usually makes each retained or lost customer have a smaller percentage-point effect.

New customers acquired

Enter customers whose first qualifying activity occurred during the period. This field is required and may be zero. Do not include reactivated customers unless your reporting policy consistently treats them as new. Overstating new customers reduces the implied retained count and can understate retention.

Total customers at end

Enter all active customers at the end of the period, including new customers acquired during that same interval. This field is required. The ending total cannot be lower than new customers, and the implied retained count cannot exceed the starting base. Those conditions protect the calculation from contradictory cohort data.

Understanding the results

Customer retention rate

The primary result is the percentage of the starting cohort that remained. A higher rate means fewer starting customers left during the selected period, but “high” must be judged against your business model, contract cadence, purchase frequency, and comparable historical periods. A zero rate means none of the starting cohort remained. This calculator prevents negative rates and rates above 100% by flagging inconsistent counts rather than presenting an impossible cohort result.

Attrition rate

Attrition, often called customer churn, is the percentage of the starting cohort that was lost. It equals 100% minus retention when the same population and period are used. The Investopedia overview of churn rate provides additional context on how attrition is used in subscription and service businesses.

Retained and lost customers

Retained customers equal ending customers minus newly acquired customers. Lost customers equal starting customers minus retained customers. These counts are often more actionable than a percentage alone because they can be connected to cancellation reasons, customer-success outreach, renewal pipelines, and revenue analysis.

Reading the chart and table

The donut chart divides the starting customer base into retained and lost segments. The center shows the starting cohort total, while the legend shows exact counts and percentages. New customers are not charted because they were not available to be retained at the start. When all inputs are empty or invalid, the visual is replaced by a compact message rather than a decorative or misleading chart.

The calculation table provides an audit trail. The first three rows restate the inputs. The next two rows show the derived retained and lost counts. The final two rows show the rate formulas. Use the table to confirm that the retained and lost counts add back to the starting cohort and that retention plus attrition equals 100%.

The Excel download captures the current state, including inputs, outputs, breakdown data, and assumptions. It is useful for period-to-period reporting, management reviews, or reconciling the metric to CRM and billing-system extracts.