# QuickBooks Desktop

## Overview

The **QuickBooks Desktop Connector** in **DBSync Cloud Workflow** enables secure integration between **QuickBooks Desktop** (Pro, Premier, and Enterprise editions) and other enterprise systems such as CRM, ERP, eCommerce platforms, payment gateways, and reporting tools.

This connector allows organizations to automate the synchronization of accounting and financial data — including customers, invoices, payments, and inventory — between QuickBooks Desktop and external applications, eliminating manual imports and reducing accounting errors.

## Key Benefits

**For Business Users:**

* **Accurate Financial Data:** Keep accounting records synchronized across systems.
* **Reduced Manual Effort:** Eliminate CSV imports and repetitive data entry.
* **Faster Financial Close:** Ensure timely availability of financial data for reporting.

**For Technical Teams:**

* **Bi-Directional Sync:** Supports both inbound and outbound data flows.
* **Controlled Data Operations:** Fine-grained control over objects and sync direction.

## Uses

1. Eliminate manual data entry by connecting QuickBooks to other systems that are supported by DBSync.
2. Automate business processes to increase efficiency across departments by reducing data reconciliation.
3. Maintain accurate customer, item, vendor, and invoice records when synchronizing data with QuickBooks Desktop.

## Supported Versions

* QuickBooks Desktop 2010 onwards.
* Pro, Premier, and Enterprise Editions.
* US, Canada, and the UK.

NOTE

QuickBooks Desktop integration is supported on Windows only.

## Supported QuickBooks Desktop Objects

The QuickBooks Desktop Connector supports a wide range of accounting and operational objects, including:

* Customers & Vendors
* Items / Products & Services
* Invoices & Sales Receipts
* Payments & Credits
* Bills & Bill Payments
* Purchase Orders
* Inventory & Non-Inventory Items
* Chart of Accounts

These objects can be used as sources or targets in workflows for automated financial integrations.

## Prerequisites

{% stepper %}
{% step %}

### DBSync Cloud Workflow Access

* A valid license for the QuickBooks Desktop connector and access to the DBSync Cloud Workflow platform.
  {% endstep %}

{% step %}

### QuickBooks Web Connector on Local

* QuickBooks Web-Connector installed and running on your machine. To download, click the [link](https://developer.intuit.com/app/developer/qbdesktop/docs/get-started/get-started-with-quickbooks-web-connector).
  {% endstep %}

{% step %}

### QuickBooks Desktop Admin rights

* QuickBooks Desktop administrative rights to make required changes.
  {% endstep %}
  {% endstepper %}

## Connector Configuration

Each QuickBooks Desktop connector instance represents a connection to a single QuickBooks company file. To integrate multiple company files, configure separate connector instances.

| Property           | Description                                                                                                                                                                                                                                                                                                        | Required |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | -------- |
| QuickBooks File    | <p>The path of the QuickBooks file where it is hosted. </p><p>To obtain the file path: </p><p>1. Open the QuickBooks file </p><p>2. Press the function <strong>F2</strong> key from your keyboard </p><p>In the pop-up, the QuickBooks file path can be seen in the <strong>File Information</strong> section.</p> | Yes      |
| QuickBooks Version | Select the relevant version of your QuickBooks Desktop from the available values.                                                                                                                                                                                                                                  | Yes      |
| Number of Retries  | From the dropdown, select the total number of retry attempts for the failed operations                                                                                                                                                                                                                             | Yes      |

This authorization ensures secure and controlled access to accounting data.

## Quick Setup Guide

Follow these steps to configure the QuickBooks Desktop Connector:

{% stepper %}
{% step %}

### 1. Login to DBSync Cloud Workflow

* Use your DBSync credentials to access the platform.
  {% endstep %}

{% step %}

### 2. Add the QuickBooks Desktop Connector

* Navigate to the connectors list in the Apps pane and select QuickBooks Connector from the connectors list.
  {% endstep %}

{% step %}

### 3. Enter values in the required fields

* **QuickBooks File:** To know the path, open the QuickBooks app and press the function F2 (or Fn+F2) key from your keyboard. File path is mentioned in the 'File Information' section.
* **QuickBooks Version:** Choose the version as 2014 and more
* **Number of Retries:** Select the Number of Retry Count, usually 2.
* Click **Save Connection**.

  <figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FNrQyxoDrDcF3wmFtfU88%2Funknown.png?alt=media&#x26;token=6a4a35cc-66dc-4ef2-b65b-3adf284d04a9" alt=""><figcaption></figcaption></figure>

{% endstep %}

{% step %}

### 4. Download WebConnector and configure

* Click **Download WebConnector**.&#x20;

  <figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FhHvv5B19cBZYhCP8wR6b%2Fimage.png?alt=media&#x26;token=44f82664-acde-48f9-94fc-d038d6af9cc1" alt=""><figcaption></figcaption></figure>

Enter the&#x20;

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FrmWd6YNhf7F7otxWbLEW%2Funknown.png?alt=media&#x26;token=2476561c-9cf2-4da1-be77-27bf1dfa1ef5" alt=""><figcaption></figcaption></figure>

* Enter the Download Web Connector
  * **Project Name:** From the dropdown, ensure that you select the required project.
  * **Process Name:** From the dropdown, select the process that needs to be automated.
  * Click **Download**.
* Using the browser **Download** option, double-click the .qwc file that got downloaded to your system.
* Ensure your QuickBooks Desktop file is open.
* Select *Yes, always; allow access even if QuickBooks is not running*.
* Next, select **Admin**.
* Click **Continue**.

DBSync integration process will be added to your QuickBooks Web-Connector.

* Once the process is added to the web-connector, add the DBSync account password in the Password section of the Web-Connector. Then press **ENTER** and click **yes**.
  {% endstep %}

{% step %}

### 5. Run the Web Service

* Select the DBSync WebConnector application and click **Update Selected**.
* The WebConnector will start updating the information and the progress bar will show the status of completion.

After setup, QuickBooks Desktop objects become available within workflows.
{% endstep %}
{% endstepper %}

## Common Use Cases

The QuickBooks Desktop Connector supports a wide range of financial automation scenarios:

* **CRM to Accounting Sync** — Automatically sync customers, invoices, and payments from CRM systems into QuickBooks.
* **eCommerce Order Processing** — Push orders, customers, and payment details into QuickBooks Desktop.
* **Inventory Synchronization** — Keep item and inventory data aligned across sales and accounting systems.
* **Financial Reporting** — Extract accounting data into data warehouses or BI tools.
* **Multi-System Accounting Automation** — Centralize accounting operations while supporting multiple upstream systems.

## Summary

The **QuickBooks Desktop Connector** in **DBSync Cloud Workflow** provides a robust and secure solution for integrating on-premise accounting systems with cloud applications. By automating financial data flows and leveraging the DBSync Agent architecture, organizations can eliminate manual processes, improve data accuracy, and streamline accounting operations across systems.

## Frequently Asked Questions (FAQ)

<details>

<summary>Is this connector secure?</summary>

Yes - all communication between DBSync Cloud, the Agent, and QuickBooks Desktop is encrypted.

</details>

<details>

<summary>Can I sync multiple company files?</summary>

Yes - configure a separate connector for each company file.

</details>

<details>

<summary>Can this connector be used for Bi-Directional sync?</summary>

Yes. Workflows can be configured for one-way or bi-directional synchronization.

</details>

<details>

<summary>Is this connector available with On-Demand or On-Premise Versions?</summary>

Yes, it is available for both versions.

</details>

<details>

<summary>How Frequently can we perform Sync?</summary>

Sync can be performed every minute.

</details>

<details>

<summary>Does this support Enterprise features?</summary>

Yes - Enterprise-specific objects are supported where available in the QuickBooks API.

</details>

## Useful Links

[QuickBooks Website](https://quickbooks.intuit.com/)

[Intuit Developer Portal](https://developer.intuit.com/)

[QuickBooks Desktop User Guide](http://http-download.intuit.com/http.intuit/CMO/quickbooks/2016/docs/QuickBooks_2016_User_Guide.pdf)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-workflow/2026_connectors_new/quickbooks-desktop.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.