Churned ARR

Churned ARR is the annualized recurring revenue eliminated when a customer cancels their contract. It measures the leak in the bucket. A company generating $10M in new ARR with $4M in churned ARR is growing at a net 60%. The metric isolates pure revenue loss from acquisition gains.

How Churned ARR Is Calculated

The formula sums the annualized contract value of all canceled accounts:

Churned ARR = Sum of (Canceled Account MRR * 12)

A cancellation means the contract ends entirely. If a customer reduces spend from $100,000 to $50,000, that is $50,000 in Contraction MRR, not churned ARR. If a customer cancels entirely, the full $100,000 is churned ARR. RevOps teams calculate this monthly but report it annually. The metric excludes Expansion MRR by definition. It represents pure destruction of existing revenue.

Churned ARR Worked Example

A SaaS company starts Q1 with $10,000,000 in ARR. Three customers cancel during the quarter.

Customer A and B canceled entirely, generating $70,000 in lost MRR. Multiply by 12 to annualize. The Churned ARR is $840,000. Customer C contracted, generating $60,000 in Contraction ARR. The Gross Revenue Retention drops from 100% to 91.6%. The company must replace $840,000 in new sales just to break even.

When Sales Teams Use Churned ARR

CEOs use the metric to board meetings to prove product-market fit. High churned ARR means the product fails to deliver value. CROs use it to align sales and customer success. If a rep closes $1M in new ARR but those customers churn within 90 days, the rep's Quota Attainment is a liability. CFOs use it to model runway. If churned ARR exceeds new ARR for three consecutive quarters, the company burns cash. Account Executives care because churned ARR directly impacts their Sales Quota. If 30% of the book of business churns annually, the rep must sell 130% of their quota just to grow the account base by 100%.

Common Churned ARR Gaming Patterns

The metric is manipulated by reclassifying cancellations as pauses or downgrades. A customer stops paying, but the Account Manager marks the account as "on hold" instead of churned. The Churned ARR stays at zero. The Churn Rate looks pristine. The customer never returns. Six months later, the account is quietly deleted during a CRM cleanup. Another exploit involves shifting the cancellation date. A customer cancels in December, but the rep marks the churn date in February to protect the previous year's Net Revenue Retention metric. A third pattern involves offering massive discounts to prevent cancellation. The customer signs a new one-year contract at 80% off. The churned ARR is zero. The Average Selling Price collapses. The company retains the logo but destroys its margin. Finance catches this by auditing the ratio of churned ARR to total lost logos. If churned ARR drops but logo count stays flat, the team is discounting to survive. The metric must be calculated via automated billing system data, not manual CRM inputs.