# Set up CRM to QuickBooks integration

With the help of this section, the user can enable the required feature namely Dynamics 365 CRM's customers (Contact/Account), Product, Quote, Order, Invoices that needs to be synced with QuickBooks companies. 

As shown in below image you need to select the required Company in the Companies tab for which you want to configure the settings.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuujE1LonEA_OPP5lP%2FCRM%20to%20QB_1.png?alt=media\&token=380cc714-8b5e-4b8b-b2e1-d61849ca5d1a)

### Customer - (Account/Contact)

Using this option you can enable the feature to sync the details from Dynamics 365 CRM **Accounts/Contacts** to QuickBooks. 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-MeuomcAsx-sgBAVzFIx%2F-MeuutGxD_nTW0QHmRoJ%2FCRM%20to%20QB_Cust_1.png?alt=media\&token=e10f4d8c-37f6-4e47-bbfb-fdd970caceb6)

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. 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 **Primary Contact** field from **Dynamics 365 CRM** to be synced to **Contact** field in **QuickBooks.**

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 QuickBooks from Dynamics 365 CRM and vice versa. In that case, set this option as ‘**Do not Allow**’.

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-MeuomcAsx-sgBAVzFIx%2F-Meuv6cv_qHEk1irD3bC%2FCRM%20to%20QB_Cust_2.png?alt=media\&token=061ad60d-d82a-4bf3-90fe-7898768bc0f1)

### **Product**

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

**Product feature Setting For US QuickBooks Company**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuvGSW_KDWjsmo4paU%2FCRM%20to%20QB_Prod_1.png?alt=media\&token=87f70fe1-5395-4b22-b116-0cbe7aa855e4)

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.

#### **Base Price List:**

In Base Price List you need to set the required **Base Price List** to be selected while syncing the Products from Dynamics CRM to QuickBooks.

{% hint style="info" %}
**Note: While selecting the Base Price List user needs to verify if the currency of the price list to be matched with the country of QuickBooks. If user selects different price list then they will get below error message.**
{% endhint %}

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuvP0vd3PivoiVvYnB%2FCRM%20to%20QB_Prod_2.png?alt=media\&token=c73f91b8-7f54-458f-972c-22e4e0a46888)

#### **Product Mappings:**

In this section, you need to select the type of **products** along with the **Account** type that is to be selected for Product sync feature.

#### **Asset Account / Income Account / Expense Account:**

All type of Product in QuickBooks – **Inventory, Non-Inventory, Service** needs to have the following accounts provided for correct handling of the accounting transactions against these products.

* **Asset Account** 
* **Income Account** 
* **Expense Account**

You can look for these accounts in **Chart of Accounts** in QuickBooks.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuvXgJ7wbc4dU7Bdmi%2FCRM%20to%20QB_Prod_3.png?alt=media\&token=f789428c-9214-4caf-a329-2e93bc2bd103)

When a Product is moved from Dynamics 365 CRM to QuickBooks it will set above Accounts as follows:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuveJn0TxqW_YZsL2J%2FCRM%20to%20QB_Prod_4.jpg?alt=media\&token=bdcda430-3456-40c6-85ad-dac55d127c5d)

After selecting all the values in Product Mapping feature and 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-MeuomcAsx-sgBAVzFIx%2F-Meuvm607Y5ObNuxWlTI%2FCRM%20to%20QB_Prod_5.png?alt=media\&token=b79c0f69-50c7-48b5-958c-ddd4de177377)

### Quote

Using this option you can enable the feature to move the **Quotes** from Dynamics 365 CRM to QuickBooks. After clicking on Quotes you will get the below displayed window.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuvxiFDeVGScaiyXAW%2FCRM%20to%20QB_Quote_1.png?alt=media\&token=99aaad8e-8247-4492-ab24-cc535b3f6309)

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-MeuomcAsx-sgBAVzFIx%2F-Meuw4cJW3aiy_bRppCE%2FCRM%20to%20QB_Quote_2.png?alt=media\&token=881b149e-a9d2-4caa-b762-b19bacc3add5)

#### Auto Create Missing Customer:

Set this option to **Yes** if you would like to **automatically** create a **missing customer** in **QuickBooks** when a transaction is promoted from Dynamics 365 CRM to QuickBooks.

Set this option to **No**, if you would like to manually control the customer records being created in QuickBooks. In this case, the transaction would not be created in QuickBooks if associated customer record is not found in QuickBooks.

In case if you have **not saved the Transaction Settings** then after clicking on **Save** button you will get the below message.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuwFBaB0y5JrPlENy8%2FCRM%20to%20QB_Quote_3.png?alt=media\&token=06b47c94-e564-44ff-9d2a-2f04ec3cc082)

### Transaction Settings 

Then, you to first save the **Transaction Settings** by selecting the **Transaction Settings feature** option. You will get to see the following options displayed as shown below.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuwPQFWrTBIfW--lEh%2FCRM%20to%20QB_Tran_1.png?alt=media\&token=739d428d-d215-44aa-a1d6-08a33b149033)

QuickBooks and Dynamics 365 CRM handle some accounting concepts like **Discounts, Write-In Products,** and **Shipping Product** differently. To allow for **error-free syncing** between Dynamics 365 CRM and QuickBooks, we ask to set up the products that need to be used for specific accounting features, namely, **Write-In, Line Discount,** and **Shipping Product.**

#### Write-In Product:

Dynamics 365 CRM allows for adding a **write-in product** in **Quote, Order** and **Invoice.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuwYljyuvI8fhvtxiR%2FCRM%20to%20QB_Tran_2.png?alt=media\&token=3d75092e-0803-4a0b-af7e-d459bf197acc)

**QuickBooks** however, does not allow entering a line item without specifying the product. To avoid this conflict we request a service type of product to be created in QuickBooks that we can use when transferring write-in lines from CRM Quote, Order and Invoice to QuickBooks. QuickBooks side user needs to create the write-in product in case of **US Company** they need to select **Is Taxable** option. If they want to calculate tax on write-in then they should select is taxable **true** while creating write-in product in QuickBooks.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuwlFA1EA_qifQlb4w%2FCRM%20to%20QB_Tran_3.png?alt=media\&token=52d38ddf-78fb-460a-b20f-d9af46672613)

In case of **UK/Canada/Australia** based QuickBooks company, user needs to define the Tax code on QuickBooks side as shown below to bring the tax in Dynamics 365 CRM while syncing the product. Thus, based on tax code the CRM will calculate the tax for write-in product on Quote/Order/Invoice.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuws9gf1xVsoz33-TB%2FCRM%20to%20QB_Tran_4.png?alt=media\&token=3b980201-0c7f-49b2-adbe-3954872725f4)

After this, any **write-in line** from Dynamics 365 CRM would be carried over in QuickBooks as shown in the screenshots below:

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meux-o_TJbqkYLJ_V0o%2FCRM%20to%20QB_Tran_5.png?alt=media\&token=cc6c65a1-ce1b-4294-a77d-f4192151d07f)

#### Line Discount product:

Dynamics 365 CRM allows you to specify discounts for line-items by specifying the discount amount in the **Discount** and **Volume Discount** fields on the line item form.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meux8j-MK327_0JCUdE%2FCRM%20to%20QB_Tran_6.png?alt=media\&token=87716105-ff64-4000-aced-621063b18c3c)

QuickBooks on the other hand requires products to be created of the type **'Discount'** and add it as a separate line item in the transaction.

With the above mapping, line item discount in Dynamics 365 CRM as shown below;

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuxGpHakbiapfcW3w_%2FCRM%20to%20QB_Tran_7.png?alt=media\&token=0a421433-32e8-47c1-b00a-0073502ff54e)

would be carried over to QuickBooks as shown below.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuxNoRIiRy4iY4sXDp%2FCRM%20to%20QB_Tran_8.png?alt=media\&token=3304f9bc-d6e1-455f-8df6-15c6688050bf)

#### Shipping product:

Dynamics 365 CRM allows for entering a **Shipping product** in **Quote** and **Invoice.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuxZ71Q0-OIhbFFZrp%2FCRM%20to%20QB_Tran_9.png?alt=media\&token=2c76dbed-4e5a-472d-9acf-a3fa6054289f)

**Dynamics 365 CRM doesn’t calculate tax on freight amount.** Thus, we request a service type of product to be created in QuickBooks that we can use while transferring **Freight Amount** from Dynamics 365 CRM Quote/Order/Invoice to QuickBooks.

For **UK/Canada/Australia,** you need to create the **Shipping product** as a **service type** product in QuickBooks with the **Tax code** defined and tax as **zero rated.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuxhd--Lv-ba0nBopu%2FCRM%20to%20QB_Tran_10.png?alt=media\&token=1c814ce1-9b0a-407b-9e43-ca48e28ee387)

After this, if you select the **Freight Amount** in Quotes/Orders/Invoice records of **Dynamics 365 CRM** it would be carried over in **QuickBooks** as a **Shipping amount.**

The product mappings accept the products of the following types in QuickBooks.

| **Dynamics 365 CRM**  | QuickBooks Item type |
| --------------------- | -------------------- |
| Line Discount Product | Service Product      |
| Write-In Product      | Service Product      |
| Shipping Product      | Service Product      |

After selecting the details in Transaction Settings and saving it you will be redirected to **Quote** feature.

#### Enable Tax Calculation:

With the help of this option you can select whether you want to automatically calculate the tax for Quote/Order/Invoice in Dynamics 365 CRM or not.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuxt_ufsyGkq1j_Jxn%2FCRM%20to%20QB_Tran_11.png?alt=media\&token=1ffb0c92-9560-41a3-8be6-66eeba449e70)

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuy1XGN2lfUd5xNsVX%2FCRM%20to%20QB_Tran_12.png?alt=media\&token=a5e8ddfa-5925-4624-bc89-cd5c39b70c69)

**Sync Tax** option allows you to sync the tax details automatically in case if there are changes made in tax within the QuickBooks systems or if your tax was not synced previously.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuy99wKo8CfkFgim2R%2FCRM%20to%20QB_Tran_13.png?alt=media\&token=ec8dfe97-9b05-4eb7-9512-aaf6da823fbe)

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuyP_zbW_RSn0Tampj%2FCRM%20to%20QB_Tran_14.png?alt=media\&token=dc183684-411f-42e6-89a9-7edf853c4c5d)

### Order

Using this option you can enable the feature to move the **Order** from Dynamics 365 CRM to QuickBooks. After clicking on Order you will get the below displayed window.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-MeuyYQ3NiGxe1rcOKet%2FCRM%20to%20QB_Order_1.png?alt=media\&token=3f55ad40-475e-46dd-883b-a8cc3b15b501)

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-MeuomcAsx-sgBAVzFIx%2F-MeuyhueynxkhHCiGpxb%2FCRM%20to%20QB_Order_2.png?alt=media\&token=85bf022a-afe8-43f4-a73f-9f08d5bd26ed)

#### Auto Create Missing Customer:

Set this option to **Yes** if you would like to automatically create **a missing customer** in **QuickBooks** when a transaction is promoted from Dynamics 365 CRM to QuickBooks.

Set this option to **No**, if you would like to manually control the customer records being created in QuickBooks. In this case, the transaction would not be created in QuickBooks if associated customer record is not found in QuickBooks.

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-MeuomcAsx-sgBAVzFIx%2F-MeuyrH8UisPtZMucaXk%2FCRM%20to%20QB_Order_3.png?alt=media\&token=acb4f653-d454-4dc4-bb12-acc4fd08e5c2)

### Invoice

Using this option you can enable the feature to move the **Invoice** from Dynamics 365 CRM to QuickBooks. After clicking on Invoice you will get the below displayed window.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuz1DI2CtYT8VKZm-n%2FCRM%20to%20QB_Inv_1.png?alt=media\&token=68e25460-79e1-4658-a127-a65e5413a4e8)

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

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MeuomcAsx-sgBAVzFIx%2F-Meuz8GQWeO0ZF81ZGH6%2FCRM%20to%20QB_Inv_2.png?alt=media\&token=4f809c63-a19a-4b39-9422-654acbe6731b)

#### Auto Create Missing Customer:

Set this option to **Yes** if you would like to automatically create **a missing customer** in **QuickBooks** when a transaction is promoted from Dynamics 365 CRM to QuickBooks.

Set this option to **No**, if you would like to manually control the customer records being created in QuickBooks. In this case, the transaction would not be created in QuickBooks if associated customer record is not found in QuickBooks.

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-MeuomcAsx-sgBAVzFIx%2F-MeuzFwXMOXLWxZyRiTX%2FCRM%20to%20QB_Inv_3.png?alt=media\&token=98e19687-8c23-416d-b084-2ea00d74e7c5)

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