Learn how to import and manage your subscription billing data in ChartMogul.
Here’s what we cover in this article:
- Types of billing systems
- The building blocks of subscription data
- Importing data from a supported billing system
- Importing data from other billing systems
- Reviewing your subscription data as it exists in ChartMogul
- Reviewing your metrics after importing data
Resources and further reading
Before you begin
- Configure your data settings to ensure ChartMogul calculates metrics and analytics based on the needs of your business.
- Consider adding sample data to get familiar with how ChartMogul calculates metrics and analytics before importing actual data.
- Depending on the amount of data, an initial import may take several hours. You’ll receive a confirmation email once your import is complete. Check our status page for real-time maintenance updates.
Types of billing systems
A billing system is the system(s) you use to generate and issue invoices to customers and track and collect payments. This could be a third-party system such as Stripe or Reculy, your custom-built solution, or a set of manual processes. Each system is added, configured, and managed as a data source in Data Platform. Each ChartMogul account supports up to 100 individual data sources.
There are two ways of setting up a billing system in ChartMogul: as a supported billing system or as a custom data source.
Supported Billing System — ChartMogul has out-of-the-box integrations with leading billing system software providers, which we refer to as our supported billing systems. Connect them to ChartMogul without writing a single line of code and keep your metrics up-to-date automatically.
Custom Data Source — To import data from a billing system for which a supported integration doesn’t yet exist, ChartMogul offers custom data sources. You may need to format your data in specific ways before importing it into ChartMogul using our API, CSV, or directly within the app.
The building blocks of subscription data
It’s important to understand how ChartMogul uses your billing data to generate subscriptions and calculate metrics. Here’s an overview of each of the types of data needed:
Customer data must include the name and unique ID of companies or consumers with a current or past relationship with your business.
Plan data must include the name, unique ID, and frequency of the products or services (or sets thereof) you offer on a subscription (recurring) basis.
Invoice data must include invoice line items with details of the service (or products) you’ve sold, including customer name, plan (or product), service period, the subscription’s unique ID, and amount billed. Based on this data and as part of its internal dataset, ChartMogul generates subscriptions. From there, it calculates all metrics and analytics (except for cash flow reports, which require transaction data).
Transactions (payments and refunds)
Transactions are attempted payments and refunds to invoices and are needed for ChartMogul to generate cash flow reports.
Transaction data must include date, invoice number or unique ID, type (payment or refund), and result (successful or failed).
Refunds contribute to cash flow metrics but don’t impact MRR (except for Stripe). Issue a refund by adding a refund transaction to the invoice used to issue the subscription. Refunding the total amount charged doesn’t cause the subscription to churn automatically. However, you can configure the Free customer handling setting to have ChartMogul classify these customers as canceled/churned. Learn more.
Cancellation data must include the name and unique ID of a customer, their subscription ID, and the subscription’s cancellation date. Subscriptions churn according to your churn recognition setting.
ChartMogul relies on cancellation events to definitively know when the subscription has ended. This is in part because subscriptions can remain active indefinitely — even after all payment attempts for an invoice have failed.
If a customer cancels their subscription, they’re no longer a subscriber (and the resulting loss in MRR is known as churn). Customers can also churn as a result of your auto-churn of delinquent subscriptions setting. When a subscription auto-churns, the status of the subscription changes in ChartMogul but not your billing system.
Importing data from a supported billing system
- Click Data Platform > Data Sources.
- Click ADD A DATA SOURCE.
- Select your billing system and follow the relevant setup instructions.
Importing data from other billing systems
- Click Data Platform > Data Sources.
- Click ADD A DATA SOURCE.
- Select Custom Data Source.
- Follow the instructions to import your subscription data using our API, CSV files, or our app interface.
Reviewing your subscription data as it exists in ChartMogul
Once imported, ChartMogul gives you complete visibility into your data as it exists in our platform through a series of data tables. To view these tables, navigate to Data Platform > Data Sources, then select the data source you want to view. Learn more about the data stored in each table and table column.
Reviewing your metrics after importing data
Once you’ve connected your billing system(s) to ChartMogul and have imported data, we recommend reviewing your metrics. Review what to do if you are experiencing issues importing your data.
Here’s a recommended checklist of things to review:
- Ensure the values ChartMogul displays in the MRR, Subscribers, and Customer Churn Rate charts are similar to any existing calculations you may have.
- Check that your existing subscription changes have been imported, as these changes generate MRR movements. Navigate to MRR > Chart Data, then select a cell to view the Activity table. Learn more about Chart Data.
- Spot check customer profiles, checking that their customer status and details, MRR, and transactions are accurate and up-to-date.
If you’ve gone through the preceding checklist and find discrepancies in your metrics or data (as it exists in ChartMogul), here are several more tips and resources:
- Review your data settings. You may need to adjust your churn recognition, smart activity classification, auto-churn, or time zone settings.
- Your billing system software may handle data and calculate metrics differently. Learn more about why metrics in ChartMogul may differ from your billing system, and then complete an audit of your subscription data.
- If your metrics are inflated or overstated (e.g., MRR is too high), check that this isn’t due to duplicate customer profiles. Sort your Customers list alphabetically to locate duplicate names or export your customer list as a CSV for further analysis.
- Find duplicate transaction data or ensure transaction data isn’t missing by downloading a detailed export CSV of the Net Cash Flow report.
- Customers contribute to MRR until their subscriptions are canceled, and their status is also set to Cancelled. If your business doesn’t have a dunning process to recover lost revenue, you may have customers with a Past Due status. To review this, navigate to Customers. Select ADD FILTER > Customer status > Past Due. To review which customers have had a Past Due status for an extended period of time, select ADD FILTER > Next payment, then select a date before your current dunning period. These customers may need to have their subscriptions canceled.