Home  >   Integration   >  QuickBooks Desktop Version Integration

QuickBooks Desktop Version Integration

Learn how to install and use QuickBooks with Vtiger CRM.
B
Bindu Rekha Babu
21 Dec, 2023 - Updated 2 months ago
Table of Contents

Introduction

Are you a QuickBooks and Vtiger CRM user?

Then integrate your QuickBooks data with Vtiger CRM today. Sync your contacts, products, and service today, and see how easy it is to manage your inventory, payments, etc.

Vtiger’s integration creates an automatic 2-way sync of data between the CRM and QuickBooks every time a record is updated or created.

Note: Though this feature is currently intended for our customers from the USA, UK, India, Australia, and Canada, other customers can also access the feature.

About QuickBooks

QuickBooks is accounting software for small and medium-sized businesses. It comes in both on-premise and cloud-based versions. QuickBooks covers a wide range of accounting functions, such as:

  • Track expenses
  • Manage payroll
  • Generate reports
 

The Vtiger Benefit!

When you integrate Vtiger CRM with Quickbooks, you will be able to:

  • Eliminate double data entry or errors that might occur during an exchange of information between the sales and accounting teams.
  • Access your customers’ billing status, payment details, shared documents, directly within Vtiger CRM.
  • Create invoices, with just a few clicks, right from a Quote or Sales order in Vtiger, and then sync with Quickbooks, ensuring data accuracy.

Feature Availability

 

Sales/Help Desk Starter

Sales/Help Desk Professional

Sales/Help Desk Enterprise

All-in-One Professional

All-in-One Enterprise

Feature Availability

QuickBooks Integration

Getting Started

Let's get started! 

So what do you do first? Well, you need to have the following downloaded and installed before you can start syncing Vtiger CRM with QuickBooks (Desktop Version). 

  • Install the Quickbooks Desktop Software
  • Install the Quickbooks Web Connector app and download the .QWC file from Vtiger
  • Install Vtiger CRM On-Demand

Quickbooks Desktop Software

Follow these steps to download the QuickBooks installation file to your desktop:

  1. Sign in to your Intuit account with the email address you used to purchase QuickBooks Desktop.
  2. Select QuickBooks Desktop under Manage your QuickBooks.
  3. Find the version you need.
  4. Select Details to see your license number, product number, and the download link.
  5. Select Download to get the install file.

QuickBooks Web Connector

QuickBooks Web Connector helps in syncing data from QuickBooks to Vtiger and vice versa.
You need to first install the QWC app and match the file location. Only then you will be able to add the organization (your company name) in QuickBooks.

Download and Install the QuickBooks Web Connector App (Installer)
The Quickbooks Web Connector app exchanges data between QuickBooks and Vtiger CRM.  Follow these steps to install the Web Connector:

  1. Download the Connector from here
    • The .exe file will be in your Downloads folder
  2. Double-click and run the .exe file to install the Web Connector 
  3. Locate the Quickbooks Web Connector in your local computer
  1. Click Start 
  2. Click All Programs 
  3. Click QuickBooks 
  4. Click Web Connector

Download QuickBooks Web Connector File (.QWC)

The .QWC file helps you to establish a connection between your QuickBooks account and your Vtiger CRM account.

Follow these steps to download the .QWC file from Vtiger CRM:

  1. Log in to your CRM account
  2. Click the User Menu on the top right corner of the CRM screen
  3. Click Settings
  4. Go to the Extensions section
  5. Click QuickBooks
  6. Choose the Quickbooks edition you are using from the dropdown - Quickbooks Desktop Edition

​​

  1. Click the Proceed button

  1. Read the pre-requisites and click Next
 
  1. To download the .QWC file, add the following information in the Download .QWC File window:
  • Vtiger User Name - Enter your Vtiger user name
  • Secret Key - Add the desired secret key in the Choose your secret key window
    • Note: Remember this key as you have to enter this information in the QuickBooks Web Connector
  1. Full Company Path - Provide the full path of your QuickBooks Company File. Here's where QuickBooks normally saves company files
    • For normal QuickBooks installations, the default path is mentioned in the above link. For example:
    • Default path in XP: C:\Documents and Settings\All Users(Shared) Documents\Intuit\QuickBooks\Company Files\Vtiger Inc.qbw
    • Default path in Windows Vista and Windows 7: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files\Vtiger Inc.qbw

The company path should end with .qbw extension.
If your QuickBooks Desktop software is installed on the server, then you can get the company path by hitting the F2 button once the software is open on your machine. This displays a pop-up window with the company information on the company path.

  1. Click Download QWC file.

You’ll be prompted to save the .QWC file in the desired location in your machine. After the save, you’ll be redirected to the actual QuickBooks sync view in Vtiger CRM.

Note: If you have configured the company path incorrectly, you can download the file again by clicking on the Download .qwc file button.

Adding the .QWC file to QuickBooks Web Connector

After successfully downloading the .QWC file from Vtiger, you’ll need to add it to QuickBooks Web Connector. Follow these steps to add the .QWC file to QuickBooks Web Connector.

  1. Click Start.
  2. Select All Programs.
  3. Select QuickBooks.
  4. Select Web Connector.
  5. Click Add an application in the QuickBooks Web Connector window. 
  1. Browse and select the .QWC file that was downloaded from Vtiger CRM in the Select a .QWC file window.
  2. Click OK in the Authorize New Web Service popup window.
  1. Select the last option: ‘Yes, always; allow access even if QuickBooks is not running’ in the QuickBooks – Application Certificate window. 
  2. Click Continue.
  1. Click Done in the Access Confirmation window. 

Now, review the Vtiger CRM application that was added to the Web Connector, and provide the password you’ve chosen earlier.

Now that the application is added to QuickBooks Web Connector, you are all set to sync data between Vtiger and QuickBooks Desktop.

Note: Before you perform every sync, remember to clear the current log.

 

But how do you know if the sync process was successful? You can check if the sync process was a success by viewing the sync log in the Web Connector.

  • Viewing the sync log
    • Click on the View Log button at the top right corner of the screen. This will help you find if the sync worked and the data was transferred successfully. If a sync process fails, the log displays the errors using which you can correct the configuration and run the sync again.  
    • For example, if a sync process failed since authentication was not carried out properly, view the log to see if the configuration was correctly. 
  • Downloading the sync log
    • The log is displayed in Notepad. You can download and save the log on your system for reference purposes. 
  • Clearing the current log, click on the Clear Log button.
    • Always remember to clear the current log whenever you run a fresh sync.

Synchronization Between Vtiger CRM and QuickBooks

Vtiger CRM integration with QuickBooks Desktop helps you sync data between Contacts, Products, Services, and the Invoices modules.  

So what does this involve? Syncing is a simple process. Field mapping occurs when you select the modules you want to sync and choose the sync direction. You hit the sync button to update the data, and you are ready to go.

 

Note:

  • Vtiger does not delete records from your QuickBooks account after synchronization and vice-versa. For example, consider ‘Contact A’ which exists in both Vtiger CRM and QuickBooks. Now if you delete this Contact A from Vtiger and then perform a sync operation, Contact A still remains in QuickBooks. This operation holds good for vice-versa also.
  • When contacts, vendors, products, and services are synced from Vtiger to Quickbooks, duplicate records will also be linked.
 

During the sync process, data from the following modules are updated:

 

Vtiger CRM

QuickBooks Desktop

Contacts

Customers

Products

Items

Services

Items / Services

Invoices

Invoices

Field Mapping

Field Mapping ensures that important information is transferred mutually between Vtiger CRM and QuickBook during the data synchronization processs. Peruse these tables below. They list the data that is synced between Vtiger and QuickBooks for each module. 

You can now configure and map custom fields for your Quickbooks Desktop application. You can use the Configure option to view and modify Vtiger and QuickBook field mapping.

Synchronization of Contacts 

 

Vtiger

QuickBooks

First Name

First Name

Last Name

Last Name

Organization Name

Company Name

Office Phone

Phone

Fax

Fax

Primary Email

Email

Mailing Street

Street

Mailing City

City

Mailing State

State

Mailing Zip

Zip

Mailing Country

Country

Synchronization of Products and Services 

 

Vtiger

Quickbooks

Product Name

Inventory/Non-Inventory Item Name

Service Name

Service Item Name

Unit Price

Price/Rate

Description

Description

Synchronization of Invoices 

Vtiger

Quickbooks

Product Name

Inventory/Non-Inventory Item Name

Service Name

Service Item Name

Contact Name

Customer Name

QB Invoice No

Invoice No

Invoice Date

Invoice Date

Invoice Due Date

Invoice Due Date

Billing Address

Bill Address

Shipping Address

Ship Address

Products

Products

Services

Products

Quantity

Quantity

List Price

List Price

Tax

Tax

Discount

Discount

Shipping Charges

Shipping

Shipping Tax

Vtiger Shipping Tax

Adjustment Add

Vtiger Adjustment Add

Adjustment Deduct

Vtiger Adjustment Deduct

Selecting Modules and Sync Direction

Sync direction

Vtiger CRM provides you with the option of syncing your CRM data with QuickBooks in three ways:

  • From Vtiger to QuickBooks
  • From QuickBooks to Vtiger
  • Sync both ways
 

Selecting modules to sync

Vtiger CRM gives you the ability to sync only desired modules and configure the direction of the sync.

Follow these steps to initiate the sync process:

  1. Log in to your CRM account
  2. Click QuickBooks from the Inventory app
  3. Click on Sync Settings
  4. Click on the corresponding check-boxes to select desired modules
  5. Select the direction of sync
    • Sync QuickBooks data with Vtiger
    • Sync Vtiger data With QuickBooks
    • Sync both ways
 
  1. Click Save Settings
  2. Open your QuickBooks Web Connector, click on the check-box on the left side of the Vtiger Application that was added earlier
  3. Click Update Selected

The selected modules will be updated.

A new column called Filter in the Quickbooks Setting page will let you select the picklist, multi-picklist, and status field values for the sync. This enhancement is not available for the Products and Services modules.

 

Troubleshooting Tips

Here are few prerequisites for the sync to work.

Before syncing data between Vtiger and QuickBooks, you’ll need to enable the following:

  1. Enable Sales Tax in Vtiger. Click icon > CRM Settings > Other Settings > Tax Calculations > enable Sales tax under Product & Service Taxes
  2. Enable inventory in QuickBooks. Click Edit > Preferences > Items & Inventory > Company Preferences > Click the checkbox Inventory and Purchase orders are active > Click OK.
  3. Create an account of type Income in Quickbooks with the name Vtiger Account. Click Lists > Chart of Accounts > Right Click your Mouse > New > Select type Income > Continue > Provide Vtiger Account > Save and Close. Products and Services created in QuickBooks from Vtiger will be linked to this account.
  4. Enable Sales Tax in QuickBooks. Click Edit > Preferences > Sales Tax > Company Preferences > Click on the radio button Yes > Click Add sales tax item > Select Sales Tax Item > Provide desired Sales Tax Name and Tax Rate > Click OK.
     

After the sync happens, some things may appear different on your screen. Read the following and you will know what they are! 

Vtiger to QuickBooks

  1. QuickBooks accept only a certain number of characters for some fields. If you exceed the limit, the field values are truncated. This persists when you sync UTF-8 characters.
  2. Products from Vtiger will be synced as items of type Inventory Part in QuickBooks.
  3. Services from Vtiger will be synced as items of type Service in QuickBooks.
  4. While syncing invoices from Vtiger to QuickBooks, you will be adding line items in your QuickBooks account.
    • Vtiger Invoice Tax: Taxes from Vtiger will be linked to this line item.
    • Vtiger Discount Amount: Discounts from Invoices in Vtiger are calculated as a single discount amount and mapped to this line item.
    • Vtiger Adjustment Add: Adjustments like add from Invoices in Vtiger will be linked to this line item.
    • Vtiger Adjustment Deduct: Adjustments like deductions from invoices in Vtiger will be linked to this line item.
    • Vtiger Shipping Charges: Shipping charges provided in Vtiger will be mapped to this line item.
    • Vtiger Shipping Taxes: Shipping taxes from Vtiger will be mapped to this line item.
 

Note: Modifications made to the above line items will affect the actual value in Vtiger after records are synced. For example, changes made to the Vtiger Shipping Charges line item in QuickBooks will affect the shipping charges in Vtiger Invoice.

  1. Make sure you do not sync QuickBooks’ invoices that have both Vtiger Adjustment Add and Vtiger Adjustment Deduct line items.
  2. On sync, Vtiger Contact Number will be appended to Vtiger Contact Name in Quickbooks. For example, Jessie Stokes CON123.
  3. Deleting a record: If you delete a record in the CRM after sync, you won’t be able to update the record from QuickBooks to Vtiger. So do not delete a record unless you really want to.
 

Note:

  • If you delete a record from the CRM after sync, then the record won’t be available for:
    • The next update
    • The next sync
  • If you try to update a deleted record from QuickBooks to Vtiger, then the sync process skips the deleted record
 

QuickBooks to Vtiger

  1. Items of the type Inventory Part and Non- inventory Part will be synced as Products in Vtiger.
  2. Items of the type Service and Other Charge types in QuickBooks will be added as services in Vtiger.
  3. Other types of items in QuickBooks are not synced with Vtiger. For example, Group, Sub Total, Payment, etc.
Was this article helpful?
0  out of  0  found this helpful.
Comments 0
Be the first to comment
© Copyright 2023 Vtiger. All rights reserved.