Churn Analysis: Find the Customers and Changes Behind Lost Revenue
A month-end method for churn analysis: compare opening and closing MRR by customer, classify each change, and tie the totals out before you explain the result.
Published
·
Updated

At month-end, a churn analysis has one question to answer: which customers reduced recurring revenue, by how much, and on what evidence? Compare opening and closing MRR customer by customer and classify each change. Make the totals tie out before you explain anything.
What churn analysis should explain at month-end
For each customer, record opening and closing monthly recurring revenue (MRR). Add the date the change took effect, the source record and how you classified it. Keep documented cancellation reasons apart from guesses.
MRR is the normalized recurring subscription base. It is a different number from invoices, cash or recognized revenue. An annual prepayment does not add its full amount to one month’s MRR, and one-time payments stay out. A refund needs a decision. A one-off goodwill credit leaves the subscription alone, while a full refund of a prepaid plan removes the months that payment covered. See recurring revenue analysis.
Set the rules before calculating churn
Logo churn counts the opening customers who leave completely. Revenue churn measures the recurring value lost from that same opening base. A customer who drops from $300 to $240 has contracted by $60 and is still a customer, so they do not count toward logo churn.
Before you calculate, write down the period boundaries and the currency. Write down how you match customer records and how you spread annual contracts across months. Work from the date a change took effect, not the invoice date.
Classify each movement
The list below is one workable policy, and there are others. Pick yours, write it down and apply it the same way every month.
Full cancellation. Churn: the opening customer’s recurring MRR falls to zero. Ask: did the paid entitlement actually end by the end of the period?
Contraction. Lost MRR on a continuing customer. Ask: was the lower recurring amount effective in this period?
Pause. A separate negative movement, not a cancellation in this example. Ask: is billing suspended temporarily, and when can service resume?
Failed payment. No MRR change while the subscription record stays active. Ask: do you hold subscription status, or only payments?
Refund or credit. Depends on what it undoes: a one-off credit changes nothing, a refund of the payment covering these months removes them. Ask: which charge does the refund undo, and which months did that charge pay for?
Reactivation. Positive movement from a previously inactive customer. Ask: is this the same customer identity as before?
New customer. Positive movement from a customer with no prior active subscription. Ask: does another source already hold this customer?
Publish your pause and missed-payment policy next to the metrics, because a change in policy can look like better retention. Report excluded pauses on their own line.
Billing systems differ on what happens after payment retries run out. Some cancel the subscription, some mark it unpaid and some leave it past due. If your data holds only payments, a missed payment looks the same as a customer who stopped. In that case, say plainly that your churn figure means payments stopped, not confirmed cancellations.
Calculate rates from the opening base
Both rates divide by where the month started.
Logo churn = fully churned opening customers ÷ active opening customers
Gross revenue churn = (cancellation MRR + contraction MRR) ÷ opening MRR
Show pauses separately. Expansion, reactivation and new business belong in the full MRR bridge and stay out of gross churn.
Worked example: reconcile January to February MRR
This US dollar example compares snapshots from January 31 and February 28, 2025. The amounts are monthly MRR, not February invoices.
Customer | MRR, Jan to Feb | Change | What happened |
|---|---|---|---|
A | $400 → $0 | −$400 | Service ended Feb 12. Cancellation. |
B | $300 → $240 | −$60 | Price reduced Feb 18, plus a one-off $30 refund. Contraction, refund excluded. |
C | $200 → $200 | $0 | Payment failed Feb 20, subscription still active. No movement. |
D | $100 → $0 | −$100 | Billing paused Feb 5. Pause, tracked separately. |
E | $0 → $150 | +$150 | Past customer resumed Feb 10. Reactivation. |
F | $0 → $100 | +$100 | First subscription Feb 14. New. |
G | $0 → $50 | +$50 | First subscription Feb 22. New. |
Total | $1,000 → $740 | −$260 |
|
The MRR bridge is $1,000 opening − $400 cancellation − $60 contraction − $100 pause + $150 reactivation + $150 new = $740 closing.
The cancellation and the contraction add up to $460 of gross revenue churn, or 46% of opening MRR. The $100 pause is another 10%, reported separately. One of four opening customers cancelled completely, so logo churn is 1 ÷ 4, or 25%. D is paused and does not count as a churned logo.
The net decline of $260 hides $560 of losses and pauses, offset by $300 of additions.
Customers B and C show how much the policy decides. B’s $30 refund is a one-off credit, so it sits on its own refunds line and leaves MRR alone. C stays at $200 only because the subscription record says the plan is still active. With payment data alone, C would look like a customer who stopped paying.
Check the bridge against the closing snapshot
The closing snapshot shows $740 of MRR, and opening MRR plus the classified changes also comes to $740. Confirm four distinct opening customers, and trace every change that is not zero back to a dated record. Matching totals are not proof, since two classification errors can cancel each other out.
Investigate exceptions across billing sources
When an export disagrees with a snapshot, keep both records and open an exception. Match customers on stable IDs and a reviewed mapping. Names and emails can merge unrelated accounts. Add up all of an organization’s subscriptions before you call it fully churned. See the monthly recurring revenue review workflow.

Work the exception queue in this order:
Unmatched customer. Check the other source. If there is still no match, leave the identity unresolved. An ID change is not evidence of new business or of churn.
Duplicate recurring line. Count the entitlement once and keep both the invoice and the subscription reference.
Date mismatch. Compare the created, billed and effective dates. Note whether you restated the earlier month or moved the change to the next cycle.
Value mismatch. Check normalization, discounts and currencies, and whether a credit changes the ongoing price.
Status ambiguity. Look at cancellation, pause and payment status together. A failed charge does not prove churn.
Save each ruling with its evidence, reviewer and period, and reuse it next month unless the facts change. When a ruling changes, show its effect on prior reports as well as the current one.
Turn the bridge into reporting someone can challenge
On a churn dashboard, put opening and closing MRR beside a movement waterfall. Show the opening-base denominators, the customers behind each movement, whether the bridge ties out, and any unresolved exceptions. State the pause and failed-payment policy on the page. Keep a trace from each figure to its records.
Once the bridge ties out, split the opening base by plan, tenure or segment, and divide each segment by its own opening figure. Billing records tell you what changed. Cancellation notes and account context can help explain why, though a pattern does not prove a cause.
Review the narrative before sharing
Here is client or board commentary for the example figures, after review:
“February closing MRR was $740, down $260. A’s cancellation removed $400, B’s contraction $60 and D’s separately reported pause $100. Reactivation added $150 and new customers added $150. One of four opening customers fully canceled. The bridge reconciles to the closing snapshot; A’s cancellation reason remains unverified.”
Review the movement schedule before any AI drafts commentary from it. Have a finance reviewer sign off on the ambiguous classifications and the wording.
Morevy connects read-only or accepts uploads, matches customers, calculates MRR movements, checks that the totals tie out and retains rulings. Teams can share signed reports, charts, decks and workbooks without replacing billing systems. For how its ratios are worked out, see retention and churn.
Month-end churn analysis checklist
Freeze the opening and closing dates, the source exports and the customer-identity mapping.
Set the recurring-MRR policy, including effective dates, pauses, refunds and missed payments.
Calculate opening and closing MRR by customer, and classify every difference against a source record.
Separate cancellation, contraction and pause from new, expansion and reactivation movements.
Reconcile the customer-level movements to the independent closing snapshot, then investigate exceptions and errors that cancel out.
Calculate logo and revenue churn from the opening base, and break out the largest customers and segments.
Save rulings and unresolved items, review any drafted explanation, and sign off before sharing.
Frequently asked questions
What is a customer churn analysis?
+
It identifies which starting customers stopped paying, which continuing customers reduced their recurring spend, and the evidence behind each change. At month-end, it should tie customer-level MRR movements out to the closing recurring base.
What does "churn" mean?
+
Customer churn is the loss of an active customer. Revenue churn is the loss of recurring value from the opening customer base. Define how you treat pauses and missed payments before calculating either one.
What is a churn ratio?
+
It is a loss divided by an opening base over a stated period. Logo churn divides fully lost customers by opening active customers. Gross revenue churn divides cancellation and contraction MRR by opening MRR.
What does 5% churn mean?
+
It depends on the metric and the period. A 5% monthly logo churn means five of every 100 opening customers left completely in that month. A 5% gross revenue churn rate means cancellation and contraction removed 5% of opening MRR, before any gains from new business or reactivations.
Is a failed payment churn?
+
Not on its own. A failed charge does not prove churn, and MRR does not change while the subscription record stays active. If your data holds only payments, a missed payment looks the same as a customer who stopped, so say plainly that your churn figure means payments stopped, not confirmed cancellations.