How to connect Zuora to ChartMogul

You will need to be an Admin in both ChartMogul and Zuora to complete the following steps and initiate a data import from Zuora to ChartMogul.

Connecting your Zuora account

1. Create a read-only API user in your Zuora account following these instructions on their support site.

2. Head to Data Platform > (Home) Data Source and click Add a data source.


  • In the dialogue that opens, select Zuora.Screenshot_2020-03-10_at_15.10.22.png
  • Enter a name for your connection into the Name field. Screenshot_2020-03-10_at_15.13.07.png
  • Click on Next to continue.



3. Enter the username and password for the API user that you created in step 1, and the Tenant ID of your Zuora account (found here).


4. Choose whether you want to include usage-based charges in subscription revenue, and whether or not to import customer accounts that are marked Cancelled in Zuora.


5. Finally, click IMPORT DATA to start the import from Zuora. The import can take some time but its progress will be displayed on the same page.

Re-Syncing your data

Your ChartMogul account will automatically update about once an hour with new activity from your Zuora account. You can also manually re-sync all Zuora data to your ChartMogul account if you wish. To re-sync your Zuora data with ChartMogul, navigate to the Zuora data source and click IMPORT DATA again. This will completely remove and re-import all your Zuora data into your ChartMogul account.

What you need to know:

  • Zuora's RatePlanCharge objects are used to generate Subscription Plan objects in ChartMogul. A subscription in Zuora with several rate plan charges will be represented as several subscriptions in ChartMogul - one ChartMogul subscription for each Zuora rate plan charge.
  • We currently don't support the Zuora Orders feature. Enabling this feature in Zuora may result in in-accurate metrics in ChartMogul. 
  • A subscription must have invoices raised against it, for ChartMogul to calculate its MRR. If no invoices are raised, then the customer will be reported as a Lead and will have no MRR reported in ChartMogul.
  • ChartMogul currently does not support Zuora's Suspend a Subscription feature. Active subscriptions can only be canceled in ChartMogul.
  • You can choose to have usage-based charges reported as recurring or non-recurring revenue before initiating the data import. The default behavior is to have usage-based charges reported as non-recurring revenue.
  • Custom fields on Zuora's Customer Accounts are imported and added as custom fields to customers in ChartMogul for use with our segmentation features.
  • Zuora's decimal quantities are rounded to integer quantities in ChartMogul.
  • Zuora Invoices that are Cancelled are ignored.
  • If a Zuora invoice is deleted ChartMogul won't reflect it until a full re-sync is run.
  • When a Zuora Customer Account is imported into ChartMogul, the contact information imported is the BillTo contact information from Zuora.
  • If a customer has only One Time charges, they will have the status Lead in ChartMogul. Learn more about customer statuses in ChartMogul.
  • We currently only support one method of managing free trials in Zuora, as described in Example 1 in this Zuora support article
  • "Subscription Term" billing period is currently not supported.
  • Invoice Item Adjustments and Invoice Adjustments in Zuora impact MRR in ChartMogul.
  • Invoice Item Adjustments impact the item that they are applied to. Invoice Adjustments are applied using a weighted distribution method to all items in the invoice.
  • Partial payment and refunds are not yet supported. This only affects cashflow reports and revenue recognition features in ChartMogul.
  • If the billing cycle of any your customers is different from their subscription plan service cycle, then ChartMogul's reports will be incorrect for those customers.
  • Zuora's Invoice Subscriptions to Different Accounts (Owner Transfer Amendment) feature is currently not supported by the Chartmogul integration.
  • Since plans cannot be changed in ChartMogul, you may notice that editing a plan in Zuora may result in importing its variants as separate plans (eg. if you change billing period).
  • Post-paid charges result in back-dated MRR changes because ChartMogul aligns MRR reporting with the service periods. If you offer products or services with post-paid charges in Zuora, we recommend invoicing them on a monthly basis, so that the back-dating doesn't go too far back.