คู่มือโดยละเอียดเร็วๆ นี้
เรากำลังจัดทำคู่มือการศึกษาที่ครอบคลุมสำหรับ เครื่องคิดเลขรายได้ที่สูญเสีย กลับมาเร็วๆ นี้เพื่อดูคำอธิบายทีละขั้นตอน สูตร ตัวอย่างจริง และเคล็ดลับจากผู้เชี่ยวชาญ
Revenue churn measures how much recurring revenue a business loses during a period because customers cancel, downgrade, or reduce usage. That makes it different from simple customer churn, which counts accounts rather than dollars. A company can lose only a few customers and still have a serious revenue problem if those customers were large accounts. The reverse can also happen: customer churn might look high, but revenue churn remains manageable if the lost customers were low-value self-serve users and larger accounts stayed or expanded. This is why finance teams, founders, SaaS operators, investors, and customer-success leaders watch revenue churn so closely. The calculator helps translate cancellations into money. In its simplest form, gross revenue churn looks at recurring revenue lost from the starting revenue base. A more advanced view, net revenue churn, also considers expansion revenue from the remaining customers. That distinction matters because a company with strong upsells can offset the damage from cancellations and downgrades. In some cases, net revenue churn can even turn negative, which means the existing customer base is growing in value despite some losses. Revenue churn is useful for forecasting cash flow, evaluating retention strategy, and understanding whether a business model is becoming more durable over time. It is especially important in subscription software, memberships, managed services, telecom, and other recurring-revenue businesses. Still, it should be used carefully. Definitions vary by company, especially around pauses, delinquent accounts, contractions, reactivations, and one-time fees. The best practice is to define the inputs clearly, measure them the same way every month, and analyze the result by plan tier, cohort, and acquisition channel rather than relying on a single blended number.
Gross revenue churn = Revenue lost from cancellations and downgrades during the period / Recurring revenue at the start of the period x 100. Net revenue churn = (Churned revenue + contraction revenue - expansion revenue) / Starting recurring revenue x 100. Worked example: if starting MRR is $120,000 and you lose $6,000 from cancellations plus $2,000 from downgrades, gross revenue churn = ($8,000 / $120,000) x 100 = 6.67%. If the remaining customers also expand by $5,000, net revenue churn = (($6,000 + $2,000 - $5,000) / $120,000) x 100 = 2.5%.
- 1Choose a consistent period, usually a month or a quarter, and record the recurring revenue you had at the start of that period.
- 2Add up the recurring revenue lost from customers who fully cancel during the period.
- 3Add any contraction revenue from customers who stay but downgrade, reduce seats, or lower usage.
- 4If you want net revenue churn, subtract expansion revenue earned from existing customers who upgraded or expanded during the same period.
- 5Divide the final lost-revenue figure by starting recurring revenue and multiply by 100 to express the result as a percentage.
- 6Interpret the result by segment because enterprise, SMB, annual-contract, and usage-based customers can behave very differently.
Gross churn ignores any upsell revenue from existing customers.
The lost revenue is $5,000 and the starting base is $100,000, so 5,000 / 100,000 x 100 = 5.0%. This is the basic version most teams calculate first.
Expansion revenue softens the damage but does not erase the underlying losses completely.
Gross lost revenue is $8,000, which is 6.67% of starting MRR. After subtracting $5,000 in expansion, net lost revenue is $3,000, or 2.5%.
Negative net churn means the existing base grew despite some losses.
Net lost revenue is $8,000 - $14,000 = -$6,000. Dividing by $200,000 gives -3.0%, which is generally a strong sign of expansion inside the retained base.
Revenue churn is often more informative than customer count alone for B2B businesses.
This example shows why account-level churn can understate financial risk. Losing only two enterprise customers can have a much larger impact than losing many small accounts.
Board reporting and SaaS financial planning. — This application is commonly used by professionals who need precise quantitative analysis to support decision-making, budgeting, and strategic planning in their respective fields
Customer success prioritization for high-value accounts. — Industry practitioners rely on this calculation to benchmark performance, compare alternatives, and ensure compliance with established standards and regulatory requirements, helping analysts produce accurate results that support strategic planning, resource allocation, and performance benchmarking across organizations
Investor analysis of recurring-revenue quality. — Academic researchers and students use this computation to validate theoretical models, complete coursework assignments, and develop deeper understanding of the underlying mathematical principles, allowing professionals to quantify outcomes systematically and compare scenarios using reliable mathematical frameworks and established formulas
Pricing and packaging reviews after downgrade patterns emerge.. Financial analysts and planners incorporate this calculation into their workflow to produce accurate forecasts, evaluate risk scenarios, and present data-driven recommendations to stakeholders
Annual prepaid contracts
{'title': 'Annual prepaid contracts', 'body': 'If customers pay annually, monthly revenue churn can look delayed unless you normalize the recurring value rather than waiting for cash timing alone.'} When encountering this scenario in churn revenue calculations, users should verify that their input values fall within the expected range for the formula to produce meaningful results. Out-of-range inputs can lead to mathematically valid but practically meaningless outputs that do not reflect real-world conditions.
Usage-based pricing
{'title': 'Usage-based pricing', 'body': 'A spending drop in usage-based billing may reflect lower customer demand rather than an actual account churn event, so interpretation needs extra care.'} This edge case frequently arises in professional applications of churn revenue where boundary conditions or extreme values are involved. Practitioners should document when this situation occurs and consider whether alternative calculation methods or adjustment factors are more appropriate for their specific use case.
Reactivations in period
{'title': 'Reactivations in period', 'body': 'When customers cancel and later return in the same period, some finance teams net the behavior while others track churn and reactivation separately.'} In the context of churn revenue, this special case requires careful interpretation because standard assumptions may not hold. Users should cross-reference results with domain expertise and consider consulting additional references or tools to validate the output under these atypical conditions.
| Metric result | What it suggests | Useful follow-up |
|---|---|---|
| Gross churn under 3% | Revenue leakage is relatively controlled for the period | Check whether gains are consistent across segments. |
| Gross churn 3% to 8% | Meaningful recurring-revenue pressure | Review downgrade reasons, onboarding, and support quality. |
| Net churn near 0% | Expansion is offsetting most losses | Protect high-expansion cohorts and renewal process. |
| Negative net churn | Existing customer base is growing in value | Study why upgrades are happening and where they are strongest. |
| Gross churn above 10% | Revenue base is shrinking quickly | Prioritize root-cause analysis and renewal risk management. |
What is revenue churn?
Revenue churn is the percentage of recurring revenue lost during a period from cancellations, downgrades, or reduced usage. It focuses on dollars rather than customer counts. In practice, this concept is central to churn revenue because it determines the core relationship between the input variables. Understanding this helps users interpret results more accurately and apply them to real-world scenarios in their specific context.
How do you calculate revenue churn?
For gross revenue churn, divide lost recurring revenue by recurring revenue at the start of the period and multiply by 100. For net revenue churn, also subtract expansion revenue from existing customers before dividing. The process involves applying the underlying formula systematically to the given inputs. Each variable in the calculation contributes to the final result, and understanding their individual roles helps ensure accurate application.
What is the difference between gross and net revenue churn?
Gross revenue churn looks only at revenue lost. Net revenue churn adjusts that loss by expansion revenue from retained customers, so it shows whether the existing base is shrinking or growing overall. In practice, this concept is central to churn revenue because it determines the core relationship between the input variables. Understanding this helps users interpret results more accurately and apply them to real-world scenarios in their specific context.
What is a good revenue churn rate?
A good rate depends heavily on pricing model, market, maturity, and customer mix. In general, lower gross churn and net churn near zero or below zero are stronger signs of a durable recurring-revenue model. In practice, this concept is central to churn revenue because it determines the core relationship between the input variables. Understanding this helps users interpret results more accurately and apply them to real-world scenarios in their specific context.
Can net revenue churn be negative?
Yes. Negative net revenue churn means expansion revenue from existing customers exceeded the revenue lost from churn and downgrades during the period. This is an important consideration when working with churn revenue calculations in practical applications. The answer depends on the specific input values and the context in which the calculation is being applied. For best results, users should consider their specific requirements and validate the output against known benchmarks or professional standards.
Should one-time fees be included in revenue churn?
Usually no, because churn analysis is designed for recurring revenue streams such as MRR or ARR. Mixing one-time project fees into the calculation can distort trend analysis. This is an important consideration when working with churn revenue calculations in practical applications. The answer depends on the specific input values and the context in which the calculation is being applied. For best results, users should consider their specific requirements and validate the output against known benchmarks or professional standards.
How often should revenue churn be recalculated?
Most recurring-revenue businesses calculate it every month and then roll it up quarterly and annually for trend analysis. Monthly reviews are useful because they let teams react faster to billing issues, downgrades, and account risk. The process involves applying the underlying formula systematically to the given inputs. Each variable in the calculation contributes to the final result, and understanding their individual roles helps ensure accurate application.
เคล็ดลับโปร
Always verify your input values before calculating. For churn revenue, small input errors can compound and significantly affect the final result.
คุณรู้ไหม?
A company can have positive customer growth and still have dangerous revenue churn if the accounts leaving are much larger than the new ones being added.