Adding historical invoices to Import API customers

The steps in this article also apply to customers which were imported from other integrations except for Stripe, Braintree, Recurly, Chargify, and PayPal. Click here if you would like to add historical invoices to customers imported from Stripe, Braintree, Chargify, Recurly or PayPal.

It's sometimes necessary to add additional invoices to your customers after they have been imported from your billing system. For example, if a customer has been billed in multiple systems, their full billing history may not be reflected in ChartMogul.

This article will demonstrate how to manually add additional invoices to your customers in ChartMogul with our Google Sheets app without needing to make changes in your billing system.


  1. Installing the Google Sheets app
  2. Setting up the Google Sheets app
  3. Adding historical invoices to customers 

Installing the Google Sheets app

Please note that it is also possible to add additional invoices to your customers using ChartMogul's Import API.

Install the Google Sheets app by navigating to the ChartMogul app page in the Google Apps Web Store and then click on Install.

Next, create a new Google Sheet and open the ChartMogul app by clicking Add-ons > ChartMogul > Open app.

This will open the ChartMogul Google Sheets app in the sidebar of the Google Sheet.

Setting up the Google Sheets app

You will need to be an admin to access your API Keys.

1. Enter your ChartMogul API Keys

You can find your API Keys in ChartMogul > Admin > API. Enter your ChartMogul API Account Token and Secret Key in the fields provided in the ChartMogul Google Sheets app.

2. Select Billing Data

Select the tab for Billing Data from the ChartMogul Google Sheets app navigation menu.

3. Select your Data Source

In the ChartMogul Google Sheets app, select the data source that your existing customers are associated with. For example, if you would like to add invoices to a customer imported from Chargebee, you would select your Chargebee site from the list of data sources. If you cannot find your data source, ensure that it is among the ones listed at the top of this article.

Adding historical invoices to customers

Let's say your customer John Smith has a $10/month subscription to the Gold Monthly plan. They were billed in January and February for their monthly subscription in another billing system until you began billing them through your current billing system in March.

To add these historical invoices from January and February to ChartMogul using the Google Sheets app, you would: 

  1. Import two invoices of type "subscription". 
  2. The Email or External id would be the Email or External id of the customer in your account (e.g. the customer's Chargebee account ID). 
  3. The invoice amount in cents for both invoices would be 1000. 
  4. The plan name would be Gold Monthly.
  5. Once you have completed the mandatory fields, click on Send invoices to ChartMogul.  

The cells will turn green once the export succeeded. 

If there is a large backlog of invoices waiting to be processed on your servers, it might take a few minutes for the data to become visible in the UI.

Learn step by step how to add invoices to Import API customers using the Google Sheets app.


Was this article helpful?