# Set up QuickBooks to CRM integration

In this section, we will dive deep into the process of syncing data from QuickBooks to Dynamics 365 CRM.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevBzlJWVXaAuMUw5UA%2FQB%20to%20CRM_1.png?alt=media\&token=167a5903-081c-4603-9f34-0f46467a1da8)

### Customer

Using this option you can enable the feature to sync the data from QuickBooks to Dynamics 365 CRM **Accounts/Contacts**. After clicking on **Customer** you will get the below displayed window.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevCB0P_sqpOCSRrJb6%2FQB%20to%20CRM_Cust_1.png?alt=media\&token=f5beba16-5a36-4fc9-a5a7-7d96d75079bc)

Here, you need to enable the feature by switching **ON** the button at top right corner which will then turn green.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevCLX1_BoFxuBq3jUb%2FQB%20to%20CRM_Cust_2.png?alt=media\&token=dec168e1-5010-4954-94bf-d3622b72a982)

#### Name Matching Criteria:

You have two options here:-

* **Exact** – It will look for an exact name match. 
* **Pattern** – It will perform a pattern match to cover for any typos in data entry in the two systems. E.g. **InfoMedia** and **IfnoMedia** will be treated as the same record and updated instead of creating duplicates.

#### Deadlock Win:

You have two options here i.e. **CRM** or **QuickBooks.**

If you have configured a two-way sync, use this property to define the application that will hold the last change, in case changes are made in both systems to the same record.

#### Allow Primary contact to sync:

Set this as **Allow** if you would like the **Contact** from **QuickBooks** to be Synced with the **Account or Contact** field in **Dynamics 365 CRM**.

Given that Accounting Contact may be different from the Business Contact stored in Dynamics 365/CRM, you may not want to override the Primary contact set in Dynamics CRM from QuickBooks and vice versa. In that case, set this option as **‘Do not Allow’.**

#### Last Modified From:

Only those Customer records would sync from QuickBooks to CRM which were created or modified after the specified date.

After clicking on Save button, depending on whether you have services on or off, you’ll get pop-up message**.** If your services are off, you’ll get the below message:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevCdGqgrJxgCBSv405%2FQB%20to%20CRM_Cust_3.png?alt=media\&token=86a611bf-7693-4ba9-90cc-ebf6c5d7a68c)

On clicking **No**, this screen will be closed. On clicking **Yes,** **Service Scheduling** screen would open.

If your services are on, you’ll get success message.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevCkcqGRgIHZ-CLIOi%2FQB%20to%20CRM_Cust_4.png?alt=media\&token=4d2405d4-6e02-472b-a144-66e4829d7bb1)

There are **3 cases** that will help you to analyze and understand how the data will be replicated in Dynamics 365 CRM when the data is synced from QuickBooks to Dynamics 365 CRM.

#### Case 1 – Let’s take an example of a customer that is having Company, First name and Last name details in QuickBooks.

This customer is saved as an **Account** same as that of the **company** name and **Primary contact** same as that of the First name and Last name of the customer.

QuickBooks side the customer with **Company, First and Last name** looks like:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevCulvYWeb0Iftz3Ha%2FQB%20to%20CRM_Cust_5.1.png?alt=media\&token=042330f3-82c7-4bc8-b76b-4bffc513e279)

Dynamics 365 CRM side after syncing the **Account** along with the **Primary** contact looks like:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevD4GYHCnai_VcZQSw%2FQB%20to%20CRM_Cust_5.2.png?alt=media\&token=dc68b659-90a0-4f02-a9f8-a6668ff10644)

#### Case 2 - Let’s take an example of a customer having Company and sub-customer details in the record.

This customer is saved as an **Account** with the same details as that of the **Company** and **Parent Account** field is populated with the details same as that of the **sub-customer.**

QuickBooks side the customer with **Company** and **sub-customer** looks like:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevDGn9XFoLw2-lp_Aj%2FQB%20to%20CRM_Cust_6.1.png?alt=media\&token=02c49996-9541-45b4-9849-f8ef0065feab)

Dynamics 365 CRM side after syncing the **Account** along with **Parent Account** will look like:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevDOUk1Z2ug0XglCPG%2FQB%20to%20CRM_Cust_6.2.png?alt=media\&token=dad2ffbd-1954-40ab-9573-a12ac0d46f47)

#### Case 3 - Let’s take an example of a customer having a first and last name details in the record.

The customer is saved as **Contact** in Dynamics 365 CRM with the same details as that of the first and last name.

QuickBooks side the customer with **First and Last name** looks like:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevDYEa0kPDGsqOMOFE%2FQB%20to%20CRM_Cust_7.1.png?alt=media\&token=32d241f4-3024-4cf6-a8e0-f34ce9110745)

Dynamics 365 CRM side after syncing the **contact** looks like:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevDfnRumrL_4LFxnch%2FQB%20to%20CRM_Cust_7.2.png?alt=media\&token=9a24089d-1a23-4c1b-a4dc-1fca1974d389)

### Product

Using this option you can enable the feature to move and sync the data of **Products** from QuickBooks to Dynamics 365 CRM. After clicking on **Product** you will get the below displayed window.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevDsmyqNkGrUPi0kir%2FQB%20to%20CRM_Prod_1.png?alt=media\&token=cd0408d3-843a-49bc-b4b8-2cb21bc8467a)

**Product feature Setting for US QuickBooks Company**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevE0-5dimlLNdhzekW%2FQB%20to%20CRM_Prod_2.png?alt=media\&token=94072809-cca2-4afd-969c-4b618f24a215)

{% hint style="info" %}
**Note: User should select the Base Price List based on the Country of QuickBooks Company.**
{% endhint %}

Here, you need to enable the feature by switching ON the button at top right corner which will then turn green.

#### Name matching criteria:

You have two options here:-

* **Exact** – It will look for an exact name match. 
* **Pattern** – It will perform a pattern match to cover for any typos in data entry in the two systems.

#### Deadlock Win:

You have two options here i.e. **CRM** or **QuickBooks.**

If you have configured a two-way sync, use this property to define the application that will hold the last change, in case changes are made in both systems to the same record.

#### Unit Group & Unit:

Products in Dynamics 365 CRM need to have the Unit Group and Unit specified. Provide the default Unit Group and Unit to be set for new products created in Dynamics 365 CRM from QuickBooks.

#### Base Price List:

Products in Dynamics 365 CRM need to have a Default Price List provided. This default value will be used for Products created from QuickBooks. Price List Items for the Products would be created for this Price List.

{% hint style="info" %}
**Note: While selecting the Base Price List user needs to verify if the currency of the price list is matching with the country of QuickBooks.**
{% endhint %}

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevE9Mbr8xFBmcJKjWT%2FQB%20to%20CRM_Prod_3.png?alt=media\&token=4873f63e-e476-4fe8-9dfa-1d6b0d69926b)

{% hint style="info" %}
**Note: User needs to select same price list that is defined as a Base Price List in Product feature for Dynamics 365 CRM to QuickBooks or else user will get the below error message.**
{% endhint %}

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevEHvVrR9StmwCI4TU%2FQB%20to%20CRM_Prod_4.png?alt=media\&token=753db347-24ea-43d1-af1b-597c948bbdc8)

{% hint style="info" %}
**Note: If you are already using Price List in Dynamics 365 CRM, specify the Price List you have created to store the product prices.**
{% endhint %}

#### Decimal Supported:

The Default value to be set for the Decimal supported attribute of the Product in Dynamics 365 CRM.

#### Last Modified From:

Only those Product records would sync from QuickBooks to CRM which were created or modified after the specified date.

After clicking on **Save** button you will get below success message.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevERSE8CFzVtLaEq6D%2FQB%20to%20CRM_Prod_5.png?alt=media\&token=f1fc3fdc-727d-4ad9-9a56-9f010bb6e123)

### Transaction History

Using this option you can enable the feature to create and update the details from QuickBooks histories within the Dynamics 365 CRM. After clicking on **Transaction History** you will get the below displayed window.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevEa2TF2HNy0NKeeKU%2FQB%20to%20CRM_Tran_1.png?alt=media\&token=f6103b62-f759-498d-85f4-1416c1138141)

**InoLink** brings in all of the transaction types from **QuickBooks** like **Credit Memos Estimates, Received Payments, Sales Receipt, Estimate, Invoices,** etc. to **Dynamics 365 CRM.** These are visible on each of the Dynamics 365 CRM **Account** and **Contact** record as shown below.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevEhm-RcQDCvp1-Ndr%2FQB%20to%20CRM_Tran_2.png?alt=media\&token=2c71d79c-9e33-4563-960a-531272549165)

This is the same view as can be seen on the **Customer Card** in **QuickBooks.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-Mev9Za6nRnuTawVfvVR%2F-MevEqQD9l0lhcNQJDEw%2FQB%20to%20CRM_Tran_3.png?alt=media\&token=927682c6-e137-4015-bb44-80004f22fcee)

{% hint style="info" %}
**Note: All of the transactions are imported and stored within the Dynamics 365 CRM database. This allows you to implement Field Level Security to handle access to Accounting Details by only authorized Dynamics 365 CRM users.**
{% endhint %}

{% hint style="success" %}
For further queries, reach out to us at <crm@inogic.com>
{% endhint %}