How to add historic invoices to your customers imported from Stripe, Braintree, Chargify, Recurly and PayPal – Help Center

Click here if you would like add historic invoices to customers imported via the Import API, Google Sheets app, Chargebee, Chargeover, GoCardless, BillForward or Cleverbridge.

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.

Contents

Installing the Google Sheets app
Setting up the Google Sheets app
Adding historic invoices to customers

Installing the Google Sheets app

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

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

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 Billing Data from the ChartMogul Google Sheets app navigation menu.

3. Creating a Data Source

In the ChartMogul Google Sheets app, enter a memorable name for your Data Source (such as "Google Sheets") and click Create Data Source. You will only need to do this once. Next time you open the Billing Data section of the app you will be prompted to select a data source.

Adding historic 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 Stripe in March.

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

Create a new customer
Create a new plan called Gold Monthly
Add the historic invoices to the new customer
Merge the newly created customer into the existing customer record

You currently cannot add the invoice directly to existing customers that were created by our native integrations (Stripe, Braintree, Chargify, Recurly and PayPal). Data coming from these integrations lives in a different application than customers that have been created via our API to which you can add invoices to. Hence, you need to take this approach to create a second API customer that you can modify and then combine with the customer coming from the native integration.

Create a new customer

Enter your customer details into a Google sheet according to the requirements and then click on Send customer to ChartMogul.

Create a new plan

Create a new plan according to the requirements. In this example scenario with the plan_name of "Gold Monthly", an interval_count of "1", and an interval of "month". When ready to load your plan, hit Send to ChartMogul.

Add historic invoices

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

To import these historic invoices from January and February to ChartMogul you would:

Import two "subscription" type invoices.
The invoice Email or External id would be the Email or External id of the customer you just created through Google Sheets.
The invoice amount in cents for both invoices would be 1000.
The plan name would be Gold Monthly.
You would also need to import a "subscription_cancellation" type invoice. To cancel a customer's subscription, use the customer's email address or ID in the Email or External id field, enter "subscription_cancellation" in the Type field, also add the Date and the Subscription number. If the customer only has one subscription, or if you left this field blank when creating a customer's subscription, enter "1" for the Subscription number field, otherwise enter the corresponding subscription number that you would like to cancel.
Click on Send invoices to ChartMogul

Merge the customer records

You would need to merge the Google Sheets customer record into the customer record imported from Stripe to complete this process.

The Stripe customer in this example scenario would look like this:

The Google Sheets customer in this example scenario would look like this:

You can merge the two customers by:

Navigating to the Google Sheets customer.
Clicking MERGE at the top right of the profile page.
Finding and selecting the Stripe customer.
Clicking Next > Confirm and Merge.

The end result will look like this:

Please note that the churn of this customer will not contribute to your Net MRR Churn Rate or your Customer Churn Rate as cancellations followed by a reactivation in the same month are excluded from the calculation. However, you will see a cancellation activity as well as reactivation activity listed in the data table and on the customer profile. We are planning to release data editing tools in a future update that will allow you to correct these movements.