How Do I Connect With QuickBooks Online?

It's easy to connect your JobNimbus account with QuickBooks Online.

With the QuickBooks integration, you will not need to enter customers and other records manually into both systems. We offer a two-way sync or a one-way sync to QuickBooks Online.  

There are a few things that need to be addressed before integrating QuickBooks Online with JobNimbus.

The supported QuickBooks Online versions are:

• Simple Start

• Essentials

• Advanced

• Plus

Self-employed is not supported.

Pre-Setup steps:

1. Be sure you have set up your workflows and understand their relationship to the QuickBooks sync: QuickBooks Workflow Setup.

   1. “Sync to QuickBooks” should be turned off for all Contacts listed as vendors or they will be created in QuickBooks as a Customer.

2. If you have records already entered in both JobNimbus and QuickBooks:

   1. Contacts and Jobs will look to link by display name.  If the display names are not identical, duplicates will be created in both systems: Contact Display Name

   2. Financial records will link by document number and amount and must be associated with the same Contact or Job in both systems.

3. When syncing from QuickBooks, all active Customers and Jobs from QuickBooks will be created in your JobNimbus.  By making old records “Inactive” in QuickBooks, you can keep them from being created in JobNimbus.  (Please note: records can always be made active again in QuickBooks if needed.  They will then sync to JobNimbus.)

These fields will sync to QuickBooks: What fields sync to Quickbooks Online? Please note that expenses, including Work Orders, Material Orders, and Bills 

Paid do not sync.

Setup Steps: 

In JobNimbus:

1. Enable the Quickbooks Sync, in "settings", "features" tab,  "3rd Party Features", toggle on the Quickbooks feature.

2. Go to Settings =>  QuickBooks

3. Select the radio dial button "Quickbooks Online"

4. Open a tab in your browser and log into your Quickbooks Online account

5. In JobNimbus: Select "Connect to Quickbooks"
   

6. Login to your QuickBooks account
   
7. Verify the name and company you will integrate your JobNimbus account with
   

8. Select "Connect"

9. Choose Sync Type

   1. 2-way: systems communicate back and forth.

   2. 1-way: Import from QuickBooks to JobNimbus

   3. 1-way: Export from  JobNimbus to QuickBooks

10. Choose Conflicts and merging preference

11.  Select which "[record types]" you would like to sync. You do not need to choose them all, however, in order for invoices/estimates to sync, products and taxes need to sync (they will be checked automatically when you select estimates or invoices). All active records in Quickbooks will sync to JobNimbus on a two-way sync.

    1. Select which type and status you would like all contacts and jobs coming from QuickBooks to be created under in JobNimbus.  You can only choose a single type and status for each record type.  Once the contact is created in  JobNimbus, you can change them to any status you wish.

12. Check the “ Before proceeding, I confirm that I have created a recent backup of my QuickBooks data.” box

    1. QuickBooks Online does not store backups.  If you’d like to make a backup, you will need to export data from  QuickBooks to a PDF or spreadsheet. 

13. Click Enable Sync

14. A report will be generated showing what will be linked, added, modified, and deleted in each record type.

    1. Click the blue “view records” in each box to view the records

    2. If changes need to be made before syncing, click Start Over

    3. If the changes being made are acceptable, click Continue and the sync will complete

       

15. Once the sync is complete, you will get an email saying it has finished. You will also see a timestamp at the top of the sync page (you may need to refresh your browser to see timestamp)

16. You may also get a pink box at the top of the page.  Click on Show Sync Errors to view which records were unable to sync.  This is a list of records that are not following a rule they need to follow in order to sync.  The error will list what needs to be corrected and then the record will sync.