Subscription Revenue Analyzer

Calculate monthly recurring-revenue movements and subscription retention from explicit dated MRR state events.

On-device No sign-up Free to use

Analyze MRR movements controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Track MRR movements and opening-cohort retention by currency.

    January closes at USD 100.00. February opens at 100.00, adds 50.00 new MRR and 20.00 expansion, and closes at 170.00, with gross retention 100.00 and net retention 120.00. March subscription churn is 50.00 percent.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/subscription-revenue-analyzer · 20 November 2026

    Was this helpful?

    How to use Subscription Revenue Analyzer

    1. 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.
    2. Include the earlier events needed to establish opening balances. Set the first and last reporting months in YYYY-MM format.
    3. Run the report and compare new, expansion, contraction, churn and reactivation movements within each currency. Retention uses the subscriptions active at each month opening.
    4. 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.

    You add
    Subscription state events: id,subscription,date,mrr,currency E1,S1,2026-01-01,100.00,USD E2,S1,2026-02-01,120.00,USD E3,S2,2026-02-10,50.00,USD E4,S1,2026-03-01,0.00,USD First reporting month (YYYY-MM): 2026-01 Last reporting month (YYYY-MM): 2026-03
    You get
    January closes at USD 100.00. February opens at 100.00, adds 50.00 new MRR and 20.00 expansion, and closes at 170.00, with gross retention 100.00 and net retention 120.00. March subscription churn is 50.00 percent.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Subscription Revenue Analyzer