← Stripe Churn and Cohort Analyzer
Connected subscription-analytics products read your billing account and keep a dashboard current. If all you need is MRR, churn and cohort retention from the subscriptions you have, a Stripe CSV export and a local analysis answers it for free, with no account and no read access handed to anyone. Here is where each approach fits.
| Question | Connected analytics product | This CSV analyzer |
|---|---|---|
| Setup | Connect your Stripe account (read access to billing data) and wait for the import | Export a CSV from the Stripe Dashboard, drop it in the page or run node cli.mjs |
| Where your data goes | To the vendor, under its terms and security practices | Nowhere. Read in your browser tab or local process; the page makes no network requests with your file |
| Cost | Check each vendor's current pricing page | Free, MIT licensed |
| MRR, new and churned MRR, logo and revenue churn | Yes | Yes, from start and cancel dates and amounts |
| Cohort retention by start month | Yes | Yes |
| Expansion and contraction MRR (upgrades, downgrades) | Yes, from invoice and event history | No. Each subscription's MRR is held constant |
| Discounts, refunds, trials, failed-payment recovery | Typically yes | No. A subscription export does not carry them |
| Always-current dashboard, alerts, team access | Yes | No. You re-export when you want a fresh reading |
| Price-rise what-if with break-even cancellation share | Varies by product | Yes, built in, labelled as assumptions rather than a forecast |
| Scriptable alert when churn passes a limit | Varies by product | Yes: --max-churn exits 1 in a cron or CI job |
The right-hand column describes this tool exactly. The middle column describes the general category from the vendors' public descriptions; check a product's own documentation for what it supports today.
A CSV is enough when you are an early-stage founder checking whether churn is concentrated in the first months, comparing plans, sizing a price rise, or preparing a board or investor note once a month and you would rather not give a third party billing access to do it.
Use a connected product when expansion revenue is a large part of your story (seat-based or usage-based pricing), when discounts and refunds distort your real revenue, when several people need a live dashboard, or when you want failed-payment recovery and alerts without lifting a finger. Those need history a subscriptions export does not contain.
node cli.mjs subscriptions.csv --cohorts node cli.mjs subscriptions.csv --max-churn 5 # exit 1 if monthly logo churn > 5%
Export labels in the Stripe Dashboard change over time. The analyzer recognises the common header names and lists any row it cannot read with a line number and reason.
For a one-off or monthly look at MRR, churn and cohort retention, yes: export your subscriptions from the Stripe Dashboard as CSV and analyze the file in your browser or with the command-line version. Nothing is uploaded and no account or API key is needed. It reads start and cancel dates and amounts, so it cannot see upgrades, discounts, refunds or failed payments the way a connected product that reads your full billing history can.
Products that connect to your billing account can read invoice and event history, so they can report expansion and contraction MRR, discounts, refunds, trials and failed-payment recovery, keep the dashboard current without a monthly export, and join billing data with other sources. A subscriptions export carries only the dates and amounts on each subscription, so this tool holds each subscription's MRR constant and shows new and churned MRR only.
Yes. The command-line version reads a CSV from a file or stdin and can exit with status 1 when monthly logo churn passes a threshold you choose, so a cron job or CI step can flag a spike. You still need to export the CSV from Stripe; it does not connect to your account.
No. This project is not affiliated with, endorsed by or sponsored by ChartMogul, Baremetrics, Paddle or Stripe. Their names are used only to describe what each kind of tool does.
Free, open source (MIT). Estimates from the dates and amounts in your file; not legal, tax, or financial advice. No warranty. Sponsor.