You may notice differences between the subscription metrics in your billing system and ChartMogul due to variations in how each system calculates metrics.
In this article, we explore these differences in-depth and provide resources to help you understand what may be happening with your data behind the scenes.
Read more about how we calculate individual metrics. For a more in depth analysis, export customer and subscription metric data to CSV to compare them with data exported from your billing system.
Here’s what we cover in this article:
- Differences in MRR
- Differences in customer counts
- Differences in customer statuses
- Differences in cash flow
- MRR vs. Revenue
Resources and further reading:
Differences in MRR
MRR reported by your billing system may differ from what you see in ChartMogul due to differences in how data is handled and processed. Here are the most common reasons:
Time zones
Different time zones can cause MRR reported by ChartMogul and your billing system to vary. For example, if the time zone in your billing system is set to Pacific Standard Time (PST), and in ChartMogul, it's set to Australian Eastern Standard Time (AEST), an invoice issued by your billing system on one day may be reported as MRR the following day in ChartMogul. Read more about setting your time zone in ChartMogul.
Invoiced Customer Handling Setting
Your Invoiced Customer Handling setting controls when a customer’s subscriptions becomes Active in ChartMogul and, therefore, when the subscription starts contributing to MRR. The timing of this may differ from billing system.
Failed invoices
Some billing system excludes customers with failed invoices when calculating MRR. ChartMogul includes these when calculating MRR, even if a transaction is marked as failed.
Refunds
Only Stripe sources deduct refunds from MRR calculations. For all other billing systems, refunded transactions are not deducted from MRR. Read more about configuring refund handling.
One-time payments
One-time (i.e., non-recurring) payments do not contribute to MRR in ChartMogul, however, your billing system may include one-time payments when calculating MRR. View these payments using Net Cash Flow.
Discounts
ChartMogul deducts discounts before calculating MRR.
Taxes
ChartMogul does not include taxes that are specified on invoices when calculating MRR.
Currencies
Invoices issued outside of your account's primary currency are automatically converted using exchange rates. Learn more about how we handle foreign currencies.
Customer status
ChartMogul classifies customers who have at least one active subscription and no past-due subscriptions as Active.
Customers who switch to a free plan or are given a 100% discount are classified as Active using the Free Customer Handling setting.
When a customer has a past-due payment, ChartMogul assumes good faith and classifies customers as Past Due and they continue to contribute to metrics.
ChartMogul does not classify customers as Cancelled until their invoice is closed or their subscription is canceled in your billing system.
ChartMogul classifies customers with only non-recurring payments as Leads.
Churn recognition
Your Churn Recognition setting may differ from how your billing system treats cancellations, which can lead to differences in MRR calculations.
Differences in customer counts
The most common reason for a difference in customer counts is the way ChartMogul handles customers who haven't paid. For a customer to be classified as Active and included in the customer count in ChartMogul, you must have successfully billed them an amount over $0.00. Customers on a free trial or with a 100% discount do not appear as paying customers in ChartMogul.
Customers invoiced outside of a subscription contribute to Non-Recurring Cash Flow and are classified as Leads.
To compare the difference in counts, export a filtered list of customers and compare it with your billing system.
Differences in customer statuses
ChartMogul has four customer statuses: Lead, Active, Past due, and Cancelled. Read more.
Filter your customer list in ChartMogul by Subscription status to see which customers have each status. Or, export customers with a specific status to a CSV file and compare it to data in your billing system.
Differences in cash flow
ChartMogul calculates Net Cash Flow by adding revenue from subscriptions, one-time (non-recurring), and metered charges, then subtracting refunds. Transaction fees are not deducted. Payments from customers you've manually created do not contribute to Net Cash Flow.
For Gross Cash Flow, ChartMogul includes revenues from subscriptions, one-time, and metered charges. Refunds and credit card transaction fees are not deducted. Payments from customers you've created manually do not contribute to Gross Cash Flow.
Check how your billing system calculates and presents cash flow. If it handles refunds or credit card fees differently, the cash flow value may be different.
MRR vs. Revenue
MRR and revenue are related, but there are important differences between them:
- MRR is the sum of all currently active subscriptions normalized (amortized) to a 30.45-day period.
- Revenue is the sum of all billings successfully paid (cash) or recognized (accrual) in the month, depending on your basis of accounting (cash or accrual).
For example (using cash accounting), if you have 100 customers who you bill $10 per month, your MRR would be the sum of all committed revenue ($1,000). This is what your customers committed to pay, so this is your MRR. If 10 of your customers didn't pay their invoices, your MRR would still be $1,000, but your (cash accounting) revenue for the month would be $900.
MRR may differ from revenue when subscriptions are not billed monthly — often the case for yearly subscriptions.
To calculate MRR, ChartMogul recognizes revenue from an annual subscription over 12 months. For example, when you bill a customer $12 for a yearly subscription, ChartMogul recognizes $1 of MRR each month and reports revenue as $12 in the first month and $0 in the following 11 months.
Lastly, invoice line items types in ChartMogul are either subscription or non-recurring. A $100 payment can consist of a $20 setup fee (non-recurring) and a $80 (subscription) payment. In this case, MRR is $80 while revenue is $100.
If your billing system shows a different MRR, one way of determining what's causing the difference is by identifying a specific customer with a different MRR in ChartMogul. From there, you should be able to see what is driving the difference.
If you feel the MRR in ChartMogul is inaccurate, please contact our support team.