QuickBooks Customer Mapping

Introduction

If you would like to start using Chargebee with QuickBooks Online, or have been using QuickBooks Online and have invoices present, we recommend migrating the customers to Chargebee and mapping them to avoid duplicates during invoice sync.

This document will walk you through the process of migrating and mapping the customer records.

Migrate customers from QuickBooks

If you are connecting a brand new Chargebee site or an existing Chargebee site to your QuickBooks Company which has customers and invoices already created, you can migrate the customers into Chargebee.

For information on how to migrate your customers to Chargebee, see our migration documentation.

Customer Mapping

If you have manually imported invoices into QuickBooks from Chargebee, the customers present in Chargebee will have been created in QuickBooks. So, once you start the sync, there is a possibility of creating duplicates.

To avoid duplicates, you can map the customers. Here's how:

Step 1: Download customer mapping file

The customer mapping process can be initiated after connecting your QuickBooks company to Chargebee. Chargebee will prompt you to map customer records if it finds customers in QuickBooks.

Download the file containing customer information. Chargebee will automatically match the customers and show the equivalent match if the customers have the following:

• Customers have the same Email address
• Customers have the same Company Name
• Customers have the same First name + Last name

Step 2: Update the customer mapping file

You can review the details of the customers in the mapping file and view customers which match or not. If the customers don't match, you can update the mapping in the file.

Reviewing the file provides you the opportunity to:

• Confirm that there are no false matches
• Manually match customers that don't have a match in Chargebee
• If customer information from QuickBooks matches with more than one customer from Chargebee, decide which Chargebee customer you want to map with the one in QuickBooks.

You can update the document by updating the customer mapping as shown below:

Step 3: Upload the updated customer mapping file

Once reviewed, you can upload the updated customer mapping file. The customers in QuickBooks and Chargebee, as matched in the file, will be mapped in Chargebee. When the sync runs, customers already present in QuickBooks will not be created.

Ignore Mapping

If you want to skip the mapping step, you can choose to Ignore and proceed. Later during the sync, if Chargebee finds duplicates, the customers will be created with a suffix such as 'XYZ Company_2'. Chargebee will check for duplicates based on Customer display name in QuickBooks.

FAQ

1. Are UTF-8 characters supported in customer email field?

No, QuickBooks does not support UTF-8 encoding for the customer email field.