Stripe is one of ChartMogul's supported billing systems. Connect your Stripe account with ChartMogul to quickly bring together all your customer and billing data into ChartMogul’s subscription analytics platform. Seeing all your billing data in one place allows you to perform a deeper analysis on your subscription data so you can make informed decisions to grow your business.
Here's what we cover in this article:
- Adding Stripe as a source
- Connecting Stripe
- Importing historical data
- What you need to know
- Using CMRR with Stripe
- Next Steps
Adding Stripe as a source
- Navigate to Data Platform > Sources.
- Click ADD A SOURCE.
- Select Stripe.
- Enter a unique name and click Next.
Select the data you would like to import from the Environment drop-down. Select Include deleted customers in Stripe to import them to ChartMogul. Learn more about importing deleted Stripe customers. Then, click CONNECT WITH STRIPE.
If you are logged into Stripe, select the account you'd like to connect to ChartMogul and click Connect.
If you don't see the Stripe account you'd like to sync with ChartMogul, click the email address and then Switch user. Log in and click Connect.
Once connected, you will be redirected back to ChartMogul and your data will begin importing.
Importing historical data
Include deleted customers in Stripe
If this option is enabled, ChartMogul will include deleted customers in Stripe during the import. If a customer in ChartMogul is deleted in Stripe, ChartMogul will cancel all of the customer’s active subscriptions and remove any personal information such as name, company, email, and address.
If this option is disabled, ChartMogul will skip any deleted customers in Stripe during import. Also, ChartMogul will delete the customer if it has been deleted in Stripe. Learn more about importing deleted Stripe customers.
Invoiced customer handling
Stripe allows you to send open invoices to your customers. In ChartMogul, the Invoiced customer handling setting enables you to control when a subscription is considered active in order for it to contribute to MRR.
This setting has the following options:
- Classify invoiced customers as active the moment their first invoice is opened. But if their invoice fails to be paid then exclude them. (default)
- Invoiced customers will be reported active when a subscription invoice for an amount above $0 is opened. If the invoice enters a past due or failed state the invoice will be reported failed and if the customer does not have a successful subscription invoice, their subscription will be removed.
- Only include invoiced customers when they have at least one successfully paid/closed invoice.
- Invoiced customers will be reported active when a subscription invoice for an amount above $0 is successfully closed (i.e. paid).
- Classify invoiced customers as active the moment their first invoice is opened.
- Invoiced customers will be reported active when a subscription invoice for an amount above $0 is opened. If the invoice enters a past due or failed state, the invoice will NOT be reported as failed; and if this customer does not have a successful subscription invoice, their subscription will NOT be removed.
Initiating the import
After configuring the above settings click Import Data.
A progress bar will appear displaying the amount of time remaining until your import is complete. Once the import has been completed, your ChartMogul account will stay up-to-date automatically with data from Stripe.
If you alter one of the settings in your source or a data setting requiring a re-sync, you will need to re-import your data to make the behavior consistent historically and going forward. You can do so by clicking on Re-sync data.
What you need to know
- ChartMogul supports Stripe’s multi-plan subscriptions. If your data appears differently, contact support.
- To import your test data into ChartMogul, select Test data as the environment. Once you have selected the environment and started the import, you cannot change it. If you need to import your data from a different environment, you will need to create a new source.
- If you're using the latest version of our Stripe integration, ChartMogul imports customers when they are created in Stripe. If you're using previous versions, ChartMogul imports customers when they have a trial or invoice in Stripe.
- ChartMogul automatically imports metadata from the customer object as custom attributes.
- ChartMogul allows you to import deleted customers in Stripe. Learn more.
- No payment method is required to create a subscription with a trial period. An immediate invoice is created for $0. Learn more about using trial periods on subscriptions.
- ChartMogul uses Stripe’s Events API to retrieve trial-related customer data. Stripe doesn’t allow events older than 30 days to be retrieved. Because of this, ChartMogul can only map trial dates that happened 30 days before the date of the initial import.
- It is possible to create a subscription with a trial period without adding the customer’s billing details. Learn more about this by reading the Stripe Docs here.
- ChartMogul limits the number of imported invoices to 2,000 per customer.
Using CMRR with Stripe
Committed Monthly Recurring Revenue (CMRR) is a projection of MRR into the future. It’s calculated using subscription events, which Stripe imports automatically. Learn more about CMRR.
Here’s what you need to know about using CMRR with Stripe:
- CMRR is only available with the latest version of ChartMogul’s Stripe integration. To check if you’re using the latest version, navigate to Data Platform > Sources and select your Stripe source. If you’re able to view a series of tables with customer and invoice data, you’re using the latest version. If you’re only able to view a setup screen, you’re using a previous version. Contact support to migrate your account to the latest version.
- ChartMogul begins importing subscription events on the date Stripe is added as a source. Historical subscription events are not supported.
- Subscription events dated prior to June 30, 2022 may be unavailable.
- For each subscription, ChartMogul only reports the next scheduled subscription event when viewing CMRR. For example, on May 27, a customer signs up for a subscription that begins on June 1 and will be upgraded on June 15. From May 27 to May 31, only the Start (Scheduled) event will be reported. On June 1, when the Start (Scheduled) event becomes New Business, the Update (Scheduled) event dated for June 15 will be reported.
- Stripe supports Started and Updated events. These events happen when:
- Started — a customer signs up, and their subscription begins immediately before an invoice is generated. This invoice will be generated at the start of the next billing cycle.
- Updated — a customer’s subscription is upgraded or downgraded and the change is effective immediately before an invoice is generated. This invoice will be generated at the start of the next billing cycle.
- View your key ChartMogul metrics in Stipe by installing the ChartMogul Stripe App.