Stripe: get a MRR or ARR summary

Always know what you current MRR is

The process

Try It for Yourself

What do I get out of it?

If you're a SaaS business, your MRR is the heartbeat of your business. Have your team always know what it is.

How does it work?

  1. Import the Subscriptions table in a sheet called "Stripe Subscriptions". See how to import your data in Actiondesk here.
  2. In the "Stripe Subscriptions" table, you have a column "Status" that will tell you if a subscription is cancelled, active, trial, etc.
  3. You also have the "plan amount" column that gives you the price of the subscription. Now the complexity comes from the fact that you may have yearly plans and monthly plans (maybe even weekly or daily plans). Handily, you have the "Plan interval" column which will give you this information: "year", "month", etc
  4. Let's add a calculated column called "monthly contribution" with the formula =IFS(#plan Interval="yearly", #plan amount/12, #plan interval="monthly", #plan amount) We assume here only have yearly and monthly plans, if you have week and / or daily, you'll have to add these to the formula.
  5. To calculate your MRR, you just have to use the formula =SUMIFS(#monthly contribution, #status, "active")

You could go further, and break your MRR down by geography, plan, cohort, or any other relevant dimension for your business.

What do I get out of it?

If you're a SaaS business, your MRR is the heartbeat of your business. Have your team always know what it is.

How does it work?

  1. Import the Subscriptions table in a sheet called "Stripe Subscriptions". See how to import your data in Actiondesk here.
  2. In the "Stripe Subscriptions" table, you have a column "Status" that will tell you if a subscription is cancelled, active, trial, etc.
  3. You also have the "plan amount" column that gives you the price of the subscription. Now the complexity comes from the fact that you may have yearly plans and monthly plans (maybe even weekly or daily plans). Handily, you have the "Plan interval" column which will give you this information: "year", "month", etc
  4. Let's add a calculated column called "monthly contribution" with the formula =IFS(#plan Interval="yearly", #plan amount/12, #plan interval="monthly", #plan amount) We assume here only have yearly and monthly plans, if you have week and / or daily, you'll have to add these to the formula.
  5. To calculate your MRR, you just have to use the formula =SUMIFS(#monthly contribution, #status, "active")

You could go further, and break your MRR down by geography, plan, cohort, or any other relevant dimension for your business.

Read more
Create My First Report
see all Stripe use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your Stripe data. Analyze it alongside data from other sources, and build custom Stripe dashboards and reports.

View and organize your Stripe data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your Stripe data. Analyze it alongside data from other sources, and build custom Stripe dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within Stripe are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.