Features - Connectors Framework - QuickBooks Desktop
QuickBooks Desktop
Overview

Learn how to set up QuickBooks Desktop to MobiWork. Please note that the MobiWork QuickBooks Desktop connector is compatible with the following third-party hosting solutions: Summit Hosting and Right Networks.

Important: To set up a QuickBooks Desktop connector to MobiWork, you will first need to contact MobiWork so we can set it up on your behalf.

The QuickBooks Connector provides the following integration touch points:

From QuickBooks Desktop to MobiWork:

  • Products

  • Customers

  • Vendors

From MobiWork to QuickBooks Desktop:

  • Invoices

  • Quotes

  • Sales Orders

Note: For invoices, quotes, and sales orders, we do not push edits. MobiWork will only create the invoice/quotes/sales order in QuickBooks Desktop once.

Also, please note that there is no payment integration.

Overview - QuickBooks Integration Process
  1. We will send you the QuickBooks Desktop questionnaire to capture your requirements

  2. Based on the feedback you indicate on the questionnaire, we will see if there are any unique conditions when setting up your QuickBooks version

  3. We will schedule a call with a MobiWork QuickBooks Specialist, to discuss how the quickbooks connector is installed and confirm a day and time to perform the installation

  4. After the call, we will then send an email that contains the next steps on how to load the connector and login credentials requests.

  5. The QuickBooks Desktop Expert will update you when it is active

  6. We will then schedule another call to review how the data is imported and how to set-up the integration push

Note: We cannot provide a sandbox.

QuickBooks Desktop Questionnaire

Please answer the following questions to the best of your knowledge:

  1. Data touchpoints available in the MobiWork QuickBooks Desktop connector:

    • From QuickBooks Desktop to MobiWork:
      • Sync customers?- YES or NO
        • Do customers in QuickBooks Desktop have sub-customers? Ship-to addresses?- YES or NO
      • Sync vendors?- YES or NO
      • Sync products?- YES or NO
    • From MobiWork to QuickBooks Desktop:
      • Sync invoices?- YES or NO
      • Sync estimates?- YES or NO
      • Sync sales orders?- YES or NO

Note: Data touchpoints mentioned below are not available in the MobiWork connector:

      • Pull A/R open balances from QuickBooks Desktop
      • Sync employees and pull timecard data
      • Sync Inventory and project orders
      • Commission tracking
      • Payments not being pulled into QuickBooks Desktop from MobiWork

  1. Which version of QuickBooks Desktop do you have? (e.g., year, edition, etc.). For example, QuickBooks Desktop Plus Annual Subscription Premier

  2. Is your QuickBooks Desktop running on your local network or hosted in the cloud by a cloud provider? If hosted who is the host provider? We can also host QuickBooks Desktop on our own server

Specific questions/options for integration:

  1. We will need the QuickBooks Company name and QuickBooks Desktop file

  2. Should products be used in the invoices? Or should we use NON-STOCK items?
    • If yes, what is the name of the NON-STOCK item?
  3. Is this a Canadian or US version of QuickBooks Desktop?

  4. Should we ignore customer updates and only add new customers from QuickBooks Desktop into MobiWork?

  5. Should we ignore sub-customers / jobs? Or add sub-customers / jobs as customers into MobiWork?

Latest questionnaire as of 09/2021

Integration Approved Next Steps
  1. Have a copy of the QuickBooks Desktop file

  2. Have access to the server running QuickBooks Desktop (e.g., Teamviewer, or a remote desktop connector)

    • If you have Teamviewer set up as "unattended" then the password will not expire
  3. Login credentials for the QuickBooks Desktop Administrator

  4. Setting up the QuickBooks Connector (this will be completed after hours)

  5. Add an icon on the desktop to run integration manually

Note: There is an option on-screen to choose which integration items will run; this improves speed in certain cases.

Integration Finished Running

When installing the connector, QuickBooks desktop will be in single-user mode. After the integration process finishes running, please change QuickBooks Desktop to the multi-user mode.

The subsequent new icon will then appear on your desktop:

If you would like to run the integration, please double-click the icon. The following pop-up window will then appear:

On this pop-up window specify the data you need to integrate:

  • If you only need to integrate customers, you can select only customers.

  • You can choose to integrate only new customers / entities. To edit existing customers, then leave the "Sync Only New Entities" unchecked.

To start the integration click on the Run button

Note: The integration from MobiWork to QuickBooks Desktop will happen regardless of which options you select.

Please have a look at the customers created in MobiWork and let us know your comments. Thank you!

Post QuickBooks Desktop Integration

The MobiWork QuickBooks Desktop connector has now been successfully installed on your server. At your earliest convenience, please confirm that all your customers, products, and *vendors have been imported successfully into your MobiWork account.

      *The ability to import vendors will depend on the initial agreement or discussion. MobiWork can change settings to only send customers vs customer, products, and vendors for example.

Please see the important information below, regarding how new customers, products, and vendors are pushed from QuickBooks Desktop to MobiWork:

  • Going forward, new customers, products, and vendors created in QuickBooks Desktop will be pushed to MobiWork every hour as well as any edits* made to existing customers, products, or vendors.

    • *There is a setting to not sync updates from QuickBooks Desktop to MobiWork. Instead it will only sync new records; this option depends on your requirements.

  • Also, please note that the integration from QuickBooks Desktop and MobiWork is an one-way update. Customer information will not be updated in MobiWork and automatically back to QuickBooks Desktop. It is a one-way process that does not update information in MobiWork back to QuickBooks desktop (except for quotes, invoices, etc.).

How to Prepare Invoices for QuickBooks Desktop Integration
  1. To prepare your invoices for QuickBooks Desktop integration, you will first need to be on the Invoices page. For more information on how to access this page, please see the Invoices List.

  2. From the Invoices List page, select the invoice(s) that you want to sync to QuickBooks Desktop. Once you have selected your desired invoice(s) click on the More Actions button and from the drop-down select the "Edit Selected" option:

  3. The New Status is the status of the invoice. The Integration Status MUST be set to "Ready for Integration." Once this is done, the QuickBooks Desktop connector will recgonize the invoice(s) will be ready to be pulled.

    • You can manually run the sync yourself or set up a time for the QuickBooks Desktop integrator to pull automatically (e.g., every hour, once a day, etc.):

    • All invoices in the "Ready For Integration" status can be viewed from the Saved Search. Click on the More Tab and you will see the panel labeled "Ready For Integration":

  4. Once the integration is competed the invoices set to “ready for integration” will no longer appear in the Saved Search.

Syncing Invoices with QuickBooks Desktop

When you are ready to sync your MobiWork invoices to QuickBooks Desktop, please follow these subsequent steps:

  1. Mark the desired invoices in MobiWork as “Ready for Integration”

  2. Go to the QuickBooks Desktop app (the orange one) located on your desktop

  3. Click on the Run button

  4. If the invoices do not appear in QuickBooks Desktop, look for the QuickBooks log file in c:mobiwork integrationlogs. After locating this file, send it to support@MobiWork.com for further assistance.

Integration of Data

Please see the important information below on how new invoices, estimates, and sales orders are pushed from MobiWork to QuickBooks Desktop:

Invoices, estimates, sales order will only sync from MobiWork to QuickBooks if they are marked in MobiWork. To mark an invoice, estimate, or sales order update the "Integration Status" in MobiWork to the "Ready for Integration" status.

The next time you run the integration in your system, QuickBooks Desktop will verify if there are any "Ready for Integration" transactions. If there are any "Ready for Integration" transactions these will be integrated into QuickBooks Desktop.

Note: QuickBooks Desktop integration does not push items or customers to QuickBooks Desktop. QuickBooks Desktop is the master of information; an invoice, sales order, or estimate will not be pushed into the system. It is using a customer or item only exists in MobiWork and not in QuickBooks Desktop.



Connector Information

The connector will continue running on your environment as long as it is listed in Windows Task Scheduler as an active task.

To create a task to run automatically in Windows Task Scheduler, we would need a Windows username and password.

If a client removes or disables the Inbound REST API and/or the QuickBooks Desktop Connectors from the Connectors page in MobiWork, the integration will stop running.

If the client upgrades their QuickBooks version or uninstall/re-install, we will need to verify the connector in QuickBooks Desktop again.

Errors

If the integration does not run or work for any reason other than the above, there are log files contained in the installation path of the QuickBooks Desktop connector on your server. You can access these files in C:MobiWork QBD IntegrationLogs

The latest log file needs to be sent to support@MobiWork.com so the errors can be accessed.

Getting in Touch With Us

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