Add-On Settings

QuickBooks Online Sync Error Messages

Below is a list of common QuickBooks Online Sync Errors and how to fix them. 

Errors are organized by the item they apply to:

  • Clients
  • Invoices
  • Payments
  • Other

 

Clients
  


  

    
Two "John Doe" clients in Jobber, but only one can be in sync with QuickBooks.
This means you have a duplicate client of this client in Jobber, so the system can’t send over the information to QuickBooks. You will need to delete the client with no Sync Icon on it (this is found in the right hand side of the Client’s Profile). If neither have a sync icon, you can choose either to delete.

    
1000000) Error Exporting Client 'John Doe’s Business Corporation' to QuickBooks: - String length specified does not match the supported length. Min:0 Max:25 supported. Supplied length:32

    
This error refers to a limitation in the amount of characters that can be synced for the Client Name. The maximum is 25 characters (this is the combined ‘Display Name’). You will need to make this shorter in Jobber then run the sync again.

  

    
1000000) Error Exporting Client 'John Doe' to QuickBooks: - String length specified does not match the supported length. Min:0 Max:21 supported. Supplied length:22

    
This error refers to a limitation in the amount of characters that can be synced for the Phone Number field. The maximum is 21 characters. You will need to make this shorter in Jobber then run the sync again.

  

  

    
1000000) Error Exporting Client 'John Doe' to QuickBooks: - String length specified does not match the supported length. Min:0 Max:100 supported. Supplied length:120

    
This error refers to a limitation in the amount of characters that can be synced for the Email field. The maximum is 100 characters. You will need to make this shorter in Jobber then run the sync again.

  
 

    
1000000) Error Exporting Client 'John Doe' to QuickBooks: - String length specified does not match the supported length. Min:0 Max:50 supported. Supplied length:80

    
This error refers to a limitation in the amount of characters that can be synced for the Address field. The maximum is 50 characters. You will need to make this shorter in Jobber then run the sync again.
 

   
 

    
1000000) Error Importing Subcustomer 'John Smith' into Jobber: Parent customer could not be found

    
This is caused when you're trying to sync a Client from QuickBooks that is a sub customer, but does not have a parent (main) client that exists in Jobber. You'll need to create this parent client in Jobber in order to have this sync over. When this sub customer syncs over Jobber from QuickBooks, it will take the ship-to address and add it into the parent (main) client as a property.

  
 


Invoices

 


  

    
Could not find tax 'Tax (10.0%)’ for Invoice #123. Sync was successful but 'Sales Tax (10.0%)’ will be used instead.

    
This error means the invoice synced from Jobber to Quickbooks, but the names for this tax rate do not match between Jobber and Quickbooks. In this example, the tax rate in Jobber is called 'Tax, while in Quickbooks it is called 'Sales Tax'. To avoid this error you will need to make the names for the tax rates match. You can change either the tax rate name in Jobber or the one in Quickbooks. To change the tax rate name in Jobber, go to the Gear in the top right > Settings > General, and you can edit the tax rate name on this page.

  

  

    
1000000) Error Exporting Invoice #100 to QuickBooks: - Invalid Reference Id : One of the list elements assigned to this transaction has been deleted. Before you can modify this transaction, you must restore Example Product (deleted).

    
One of the work items that you are using for this invoices is no longer in your Products and Services in Jobber. You will have to either a) Add the line item into Jobber again or b) change the work item on the invoice to an existing one in Jobber.

  
 

    
1000000) Error Exporting Invoice #100 to QuickBooks: - Errors with Customer "John Doe”

    
If you have a sync error on a client, then all Invoices and Payments associated with that client will not be able to sync. You will have to resolve the error on the client, then the invoice will be able to sync.

  

    
Skipping push of Invoice #100 to QuickBooks: That DocNumber already exists in QuickBooks

    
This issue is caused when the Invoice number is already in use in QuickBooks. There are two reason this could be in QuickBooks already: a) If you’ve been using QuickBooks for awhile, and the invoice number has already been used in QuickBooks. If this is the case, you will have to update your invoice number in Jobber to higher than the last used number in QuickBooks. To change an invoice number in Jobber go to the invoice, click Actions > Edit, then click the invoice number to change it. Jobber will continue counting up from the highest invoice number in the account. b) The invoices that were in Jobber have successfully synced but are trying to sync over again. If this is the cause, then you will have to contact our Support Team at 1 888 721 1115, by chat, or by support@getjobber.com, to get our developers to clear the error.

  

    
1000000) Error Exporting Invoice #100 to QuickBooks: - Operation failed with errors: CustomerRef must be active

    
This error occurs when either a customer in QuickBooks that was previously in sync has been merged into another customer, or if the customer was made INACTIVE in QuickBooks. You will have to ‘un-merge’ the client or make it ACTIVE again in QuickBooks.

  

    
1000000) Error Exporting Invoice #100 to QuickBooks: Tax Error - check QuickBooks US/Global settings in Jobber

    
This is an issue that only comes up when you are have set the wrong Integration Details (this is found under the Sync details in Jobber). This means if you’re using US QBO and you are set to Global QBO settings or visa versa. To fix, select the correct type of QuickBooks Account you are syncing with.

  

    
1000000) Error Exporting Invoice #100 to QuickBooks: - Non-taxable item on invoice, but no TaxCode with a rate of 0% was found in QuickBook

    
QuickBooks is unable to accept discounts when they are applied to the entire invoice. To get around this, go back to the invoice, and delete the discount. You can then re-make it as a negative line item. Negative line items are able to synch to QuickBooks.

  

  
1000000) Error Exporting Invoice #100 to QuickBooks: - TaxCode with a rate of 5% was not found in QuickBooks.
This means that this tax rate is not set up in your QuickBooks account. To fix this, all you need to do it go to your QuickBooks Online account, go into your tax settings and add this tax rate in.
 
 

    
1000000) Invoice #1493 to QuickBooks: Business Validation Error: Make sure all your transactions have a GST/HST rate before you save

    
You’re set to QBO US instead of QBO Global in Jobber. This can be changed by going to the QB icon at the top > Sync and Settings > then on this page change the QBO settings from US to Global.

  

  

    
1000000) Error Exporting Invoice #121 to QuickBooks: String length specified does not match the supported length. Min:0 Max:4,000 supported. Supplied length:5,103

    
This is caused by a line item's description within an invoice being more than 4000 characters long. You will need to edit these to be less than this limit in order for this Invoice to sync.

  

  

    
Rounding Error Pushing Invoice #111 to QuickBooks: $100.44 VS $100.45

    
This is caused by a discrepancy on how we round up our tax values as compared to QuickBooks. In QB they use one less decimal space to round up their tax amounts causing a difference in tax totals sometimes. The invoice will still go over to QuickBooks, but the error is letting you know that the totals are different in each program, so you will have to update the QB Invoice to the different amount.

  

Payments


  

    
1000000) Error Exporting Payment For John Doe to QuickBooks: - Operation failed with errors: Invalid Invoice ID

    
This is caused when a payment is directly applied to an invoice in Jobber that is already in sync with QuickBooks, and the Invoice has either been deleted or edited in QuickBooks, so the payment can no longer find the invoice. To resolve this, delete the payment in Jobber for this invoice in the client’s Billing History Box and then re-apply it directly to the client’s profile from the Billing History Box > New > Record Payment. The next time you sync this payment will show in QuickBooks as unapplied on the client’s profile. You can then manually apply it to the invoice in QuickBooks.

  

  

    
1000000) Error Exporting Payment For John Doe to QuickBooks: - Operation failed with errors: Invalid field value CustomerRef: Invalid Customer ID

    
This is caused when a Payment is applied to a customer or Invoice but that customer has either a) been merged into another customer b) been made Inactive, or c) been edited so it can’t find the customer anymore.

  

  

    
1000000) Error Exporting Payment to QuickBooks: - Errors with Customer "John Doe”

    
If you have a sync error on a client, then all invoices and payments associated with that client will not go over either. You will have to clear the initial error for the payment to go over.

  
 

    
1000000) Error Exporting Payment For John Doe (3333333) to QuickBooks: Accounting::Adapters::IDSAdapter::ModelNotFound

    
This error is either caused by the client or the invoice that the payment is being associated with being changed or deleted. Check the client first by going to their profile page in Jobber. In the top right of their page will be an 'In Sync' icon. Click this. Jobber will then take you to their profile in QuickBooks. If it is unable to link to their profile in QuickBooks then the QuickBooks client profile is what is causing the issue. In this case, find the client in QuickBooks and check if their profile was merged into another customer or is now inactive in QuickBooks. You will have to ‘un-merge’ the client or make it active again. If the 'In Sync' icon does take you to the client in QuickBooks, then likely there is a problem with the invoice. Check to see if the invoice has been deleted in QuickBooks. If the invoice has been deleted from QuickBooks, contact our support team.

  
1000000) Error Exporting Payment For John Doe (4509887) to QuickBooks: - TxnID Cannot Be Linked : 51484

    
The payment is trying to be linked to an invoice which did not get synced and does not currently exist in QBO. Creating the invoice this payment is for will allow you to sync this over.
Other Errors

  

    
Updating the taxable status of item "EXAMPLE" to be taxable. This will not effect tax calculations on existing invoices but will effect all new invoices.

    
This issue is caused by the tax status in Jobber and in QuickBooks not matching. This work item is set to non-taxable on one side and taxable in another. You will have to update the tax status in QuickBooks and run the sync to correct the issue.

  

    
1000000) 1000000) Error Exporting Product 5” Piping to QuickBooks: Business Validation Error: You cannot use " in a name, use a single quote instead

    
This is caused by the character “ - this is an unsupported character and cannot be used. You will have to either take the character out, use a single quote ‘, or use the word inch.

  
 
This error list is not exhaustive. If you run into an error that is not on this list feel free to contact our Success Team as by chat, phone 1 888 721 1115, or support@getjobber.com and we can help look into it for you. 
 
 

Was this article helpful?

Send Feedback

Jobber on your Phone

The Jobber Glossary

Confused by language we use in Jobber? Definitions right this way.

Get Reading!
Jobber on your Phone

Sign up for a Webinar

Tutorials for both those new to Jobber and long-time power users.

Sign Me Up!
Jobber on your Phone

Instructional Videos

We walk you through our biggest features and point out the essentials.

Let’s Watch!

Jobber Academy is your hub for everything small business. From residential cleaners to plumbers and contractors, if you work in the field, you’ll found the right resources.