Features - Connectors Framework - QuickBooks Desktop Web Connector
QuickBooks Desktop Web Connector
Overview

MobiWork can easily integrate with QuickBooks Desktop. Whether your database is on-premise or hosted by a third-party IT vendor (e.g., Right Networks, Summitt Hosting, Apps4Rent, etc.) the integration process is seamless.


Integration Details

MobiWork will provide a QuickBooks Desktop Web Connector (QWC) file to load on to your QuickBooks Desktop (QBD) server/computer. This integration process will allow for the exchange of data between the two systems.

The QuickBooks Desktop Web Connector will synchronize the following data:

  • From QBD to MobiWork: Customers, Items/Parts, Services, and Vendors

  • From MobiWork to QBD: Invoices, Quotes, Payments, New Customers, and Customer updates

Data That Does not Sync:

  • For invoices, quotes, and sales orders, MobiWork does not push edits. MobiWork will only sync an invoice, estimate, and sales order once.

Synchronizing data is a 2-step process:

  1. Select and mark items to export. Items can be selected individually or in bulk and placed in a "pending" status that identifies items are ready to sync.

  2. Run the QWC connector. All items that have a "pending" status will then be pushed to QBD.

Note: MobiWork will only sync invoices, quotes, and sales orders once. After being pushed from MobiWork to QuickBooks Desktop, any additional updates or edits will need to be done in directly in QuickBooks Desktop.


How to Set Up the Connector

Once you have subscribed to MobiWork, our Success Team will assist you with your QuickBooks Desktop connector set-up. The steps listed below describe the process:

    Step 1: Request a QWC file by sending an email to success@mobiwork.com. Our team will provide a QWC file and password that is specific to your account.

    Step 2: Install the QWC file on the QuickBooks Desktop local server/computer. This means you must be logged in as the local administrator to successfully install the file. If your QuickBooks Desktop application is hosted by a third party, they will need to install the file and confirm the connection.

    Step 3: Run the QWC connector. Please note that the first time you run the connector, ALL of your customers, items/parts, services, and vendors will be pulled into MobiWork. Services and non-inventory items will pull into MobiWork as Services. Inventory parts will pull into MobiWork as Parts. All items will be marked as taxable.

    Step 4: Confirm the data; all of your QuickBooks Desktop data can be viewed in MobiWork. Each entry pulled from QuickBooks Desktop will have an external ID confirming the connection.


Synchronization Rules

After the first synchronization runs, and all of your data is pulled from QuickBooks Desktop to MobiWork, you will be able to manually sync your data based on the following rules:

  • MobiWork allows manual syncs in no less than 15-minute increments (15 minutes is the default minimum).

  • Each time a sync is performed, the following data transfer will take place:

    • From QBD to Mobiwork: Each sync will only return records that were ADDED in the last 7 days (7 days is the default minimum; 28 days is the maximum or you can select to run a full sync).

    • From MobiWork to QBD: Each sync will push invoices, customers, items, vendors, and payments that have been marked/selected to export. This includes NEW and UPDATED entries.

  • Marking a customer custom field as "Required" will prevent the QWC file from integrating customers from QuickBooks Desktop.

  • Please note that we do not recommend setting the connector to autorun, as this can implement unwanted or accidental changes; setting the connector to manual synchronization will prevent this.

  • When syncing, only new entries from QuickBooks Desktop are transferred to MobiWork. Any changes made in MobiWork to customers, parts, and services remain unaffected and will not be overwritten.

Install QuickBooks Desktop Web Connector

Step 1: Request QWC file from MobiWork

  • MobiWork will send you an email with the MobiWork Desktop Web Connector file and password. Below is a sample email that you will receive from us:

    • Subject New QBD Client: (Your Company Name)

      Contact Name,

      Please find the QWC file attached.

      The password is: XXXXXX

      Please let me know if you have any questions.

      Thank you


Step 2: Place File on Server

  • Place the received attachment on your QuickBooks Desktop Connector server or computer.

  • Once you confirm that QuickBooks Desktop is running, double-click to install the file:

Step 3: Authorize New Web Service

  • In the Authorize New Web Service pop-up window that appears, click on the Ok button:


Step 4: QuickBooks Application Certificate

  • For the QuickBooks Application Certificate pop-up window that appears, select the "Yes, always, allow access even if QuickBooks is not running" option:


Step 5: Access Confirmation

  • In the Access Confirmation pop-up window, click on the Done button:

  • The QuickBooks Desktop Web Connector pop-up window will then appear:


Step 6: QuickBooks Desktop Web Connector Pop-up Window

  • In the QuickBooks Desktop Web Connector pop-up window, click on the "MobiWork Web Service" option:

  • This will prompt you to input the password.

  • Note: Please note that the password requested here can be found in the email you received from MobiWork (please see Step 1).

  • After entering the password and clicking on the Ok button, you will be asked if you would like to save the password:
  • Click the Yes button to save the password. If you select the No button, you will then be prompted for the password everytime you run the integration.
  • Once you have successfully entered the password, you will be able to fill in the checkmark for the MobiWork Web Service:
  • Make sure that the "Auto-Run" option is NOT checked, so that the application can run manually. Setting the connector to autorun, can implement/cause unwanted or accidental changes.

Step 7: Upload Selected Items

  • Click on the "Update Selected" option (located on the top of the QuickBooks Desktop Web Connector 2.2.0.93 pop-up window). This will download your customers, parts, and services:

  • Depending on the number of customers, parts, and services you have to download, this process could run for a while.

  • Note: Both active and inactive customers will be pulled into MobiWork.

  • You can watch the progress of the data pull by viewing the "Application Progress" bar and reading the notifications below the total progress bar:
  • Customers Note: You can log into your MobiWork account, select the Customers feature and watch as the customers post into your account. You can scroll to the bottom of the page to see the number of customers that have imported and continue to refresh the page to determine how many customers are importing per second:

Step 8: Confirm Import

  • Once the import is complete, please confirm that all the customers, parts, and services have imported successfully from QuickBooks Desktop Web Connector.

  • All the imported customers, parts, and services will have an "Integration Status ID" and or an "External ID" that confirms the data was pulled from QuickBooks Desktop Web Connector.

  • The examples below shown an imported customer and part from QuickBooks Desktop:

  • View Customer Pop-up Window:

    View Part Pop-up Window:

Syncing Invoices With QuickBooks Desktop

For more information about how to sync your invoices with the QuickBooks Desktop Web Connector, please see the Export Invoices page.

Troubleshooting

The subsections below will go into more detail regarding some of the more common troubleshooting errors that you might encounter.


Error Code 1039

If you receive the error, "QBWC1039: There was a problem adding the application. Check QWCLog.txt for details. Error connecting to QuickBooks. Error message received from QuickBooks was If you do not have QuickBooks installed on this system, you would need to install it before running the web connector," this means that the admin must grant access to the user when the user first logs in:

To resolve this issue, ask the user to log in using the admin credentials on their system first, before attempting to use their own login credentials.


Error Code 1048 and 1051

If you receive the error, "QBWC1048: QuickBooks Web Connector could not verify the web application server certificate. / QBWC: The new application was not added," this means that a third-party hosting issue is blocking the QuickBooks Web Connector certificate:

To fix this error, you may need to whitelist MobiWork or access security settings on your host firewall.


Invalid Argument

If you receive the error, "The specified record does not exist in the list," this means that the account number entered in the MobiWork QuickBooks Desktop account settings does not match the account number in QuickBooks:

To fix this error, please ensure that the number in the MobiWork QuickBooks Desktop account settings matches the account number of the desired item, service, etc. in QuickBooks.


Invalid Reference

The error, "There is an invalid reference to QuickBooks Account in the item inventory," means there was no account number entered in the MobiWork Item settings:

To fix this error, please ensure that the designated text field in the MobiWork Item settings section has the matching account number of the desired item, service, etc. from QuickBooks.


Saving an Invoice Error

The error, "There was an error when saving [an] invoice. QuickBooks error message: The transaction is empty," means the invoice has no line items to push to QuickBooks Desktop:

To resolve this issue, please add line items to your invoice. For more information on how to add line items to your invoice, please see the Add an Invoice section.


Could Not Find Term

The error, "Error: Could not find in QuickBooks a sales term that matches: "6," Please add the matching sales term in QuickBooks," means there is no existing term in QuickBooks that matches the MobiWork term.

To resolve this issue, please create the term in QuickBooks.


Saving an Invoice Error

The error, "There was an error when saving [an] invoice. QuickBooks error message: The transaction is empty," means the invoice has no line items to push to QuickBooks Desktop:

To resolve this issue, please add line items to your invoice. For more information on how to add line items to your invoice, please see the Add an Invoice section.

Getting in Touch With Us

If you have any questions or need further assistance, please let us know. We'd be happy to help!