How to use Subscription Revenue Analyzer
- Paste or choose a CSV with id, subscription, date, mrr and currency headers. Each unique event ID records the subscription's normalized monthly recurring amount after that event; zero cancels it.
- Include the earlier events needed to establish opening balances. Set the first and last reporting months in YYYY-MM format.
- Run the report and compare new, expansion, contraction, churn and reactivation movements within each currency. Retention uses the subscriptions active at each month opening.
- Download the report with its source event history. Monthly ending MRR is a run-rate measure, without invoice recognition, currency conversion or mid-month proration.
Example: Subscription Revenue Analyzer
Track MRR movements and opening-cohort retention by currency.
Supported inputs and limits
- Up to 2,000 event rows, 80 columns, 2 MiB and 60 reporting months.
- Each event replaces a subscription’s nonnegative two-place normalized MRR; zero cancels.
- Currency is fixed per subscription and currencies are grouped separately.
- No invoice recognition, annual-plan conversion, exchange rate or proration is inferred.
- Same-day events use CSV order.
More details
Opening-cohort retention excludes new/reactivated subscriptions outside that opening cohort; zero denominators are blank.
Complete pre-window events are needed for opening balances.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Subscription Revenue Analyzer
Should I enter the amount of each invoice?
Enter the subscription’s normalized monthly recurring amount after each event. An annual invoice must be converted to a monthly recurring amount in your source before this calculation.
How are mid-month cancellations prorated?
They are not prorated. Events change the ending MRR state; this is a recurring run-rate report, not recognized revenue or a cash collection schedule.
What is the churn denominator?
Subscription churn divides opening active subscriptions that end the month at zero by the number active at the opening. It is not a count of customers or every cancellation event.