Table of Contents
Note
This article covers the sync errors and warnings from the legacy integration between Jobber and QuickBooks. The NEW integration between Jobber and QuickBooks has a different method of resolving errors than what is shown here.
If you are integrating Jobber and QuickBooks for the first time, you will be using the new Jobber and QuickBooks integration. Click the buttons below to learn more.
NEW QuickBooks Integration:
Connect Jobber and QuickBooks Online
How to navigate this page
Below is a list of common QuickBooks Online sync errors and how to fix them. This isn't a comprehensive list of all the possible errors, but some of the more frequent ones. If you need a hand, please reach out to our Success Team at 1-888-721-1115 or start a live chat.
Tip: Search this page by clicking ctrl + F and copying into the search bar part of the error that you see on the QuickBooks sync and settings page in Jobber. Make sure not to include any unique information in your search as this article just shows the generic messaging, so unique names won't match.
Copy from Jobber:
Press ctrl + F on your keyboard to open your browser's search, then paste in the error:
If the error matches, it will be highlighted on the page and you will see the number of matching phrases:
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.
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.
Error Exporting Client 'John Doe' to QuickBooks: String length specified does not match the supported length. Min:0 Max:30 supported. Supplied length:34
This error refers to a limitation in the amount of characters that can be synced for the Phone Number field. The maximum is 30 characters. You will need to make this shorter in Jobber then run the sync again.
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.
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.
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.
Error Exporting Client ‘John Smith’ to QuickBooks: The name supplied already exists. : null
A client with this same name already exists in QuickBooks. This can be resolved by deleting the client with that same name in QuickBooks, then running the sync again.
If the client cannot be deleted from QuickBooks, temporarily change the name of the client in Jobber to differentiate it (for example, 'John Smith 1'), then run a sync with QuickBooks. Once the client has synced and appears in QuickBooks, change the name back to the client's original name. Since there is already a client with that name in QuickBooks, you will be asked to merge the clients. Click Yes.
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 Icon > Settings > Company Settings, and you can edit the tax rate name on this page.
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 invoice is no longer in your Products and Services in Jobber. You will have to either:
a) Add the line item into Jobber again
b) change the work item on the invoice to an existing one in Jobber.
It's also possible that you might have two products or services with the same name. In this case, one will need to be deleted.
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.
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.
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 QuickBooks Online and you are set to Global QuickBooks Online settings or visa versa. To fix, select the correct type of QuickBooks Account you are syncing with.
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.
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 is go to your QuickBooks Online account, go into your tax settings and add this tax rate in.
Invoice #1493 to QuickBooks: Business Validation Error: Make sure all your transactions have a GST/HST rate before you save
You’re set to QuickBooks Online US instead of QuickBooks Online Global in Jobber. This can be changed by going to the QuickBooks icon > Sync and Settings. On this page change the QuickBooks Online settings from US to Global.
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 error can appear for two different reasons:
- There is a discrepancy in how we round up our tax values in Jobber compared to QuickBooks. In QuickBooks they use one less decimal space to round up their tax amounts which can cause a difference in totals.
- If you have an invoice with both taxable and non-taxable items, and a discount, QuickBooks will calculate the tax differently than we do in Jobber, which may lead to different totals in Jobber and QuickBooks.
In both of these scenarios the invoice will still sync 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 QuickBooks invoice to match the amount in Jobber.
Error Exporting Invoice #12428 to QuickBooks: String length specified does not match the supported length. Min:0 Max:1,000 supported. Supplied length:1,179
This is caused by the client message on this invoice being over 1,000 characters long. Shortening it to less than 1,000 characters will allow the invoice to sync to QuickBooks. To do this, go into the invoice, hit Actions > Edit, and scroll down to the bottom of the invoice where you can edit the client message.
Payments
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.
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.
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.
Error Exporting Payment For John Doe (3333333) to QuickBooks: Accounting::Adapters::IDSAdapter::ModelNotFound
This error occurs when the invoice that the payment is applied to was edited after syncing (invoices only sync one-time), or if the invoice was removed from QuickBooks altogether.
To resolve this error, start in Jobber and navigate to the client's billing history box. Then click on the payment to open the payment details. From the "applied to" dropdown, select to apply the payment to the account balance instead of with an invoice. Then click Save.
Note: If this payment was processed through Jobber Payments or another payment integration, let our team know and we can give you a hand with updating the "applied to" dropdown.
Next, run a sync with QuickBooks. This payment should now sync to QuickBooks, but it will be associated with the customer and be "unapplied" since it was switched to be associated with the account balance rather than an invoice. Since the payment has now synced to QuickBooks, it can be edited in both Jobber and QuickBooks to apply it to the correct invoice.
If the payment does not sync, let our Success Team team know and we can dig into this further.
Error Exporting Payment For John Doe (4509887) to QuickBooks: TxnID Cannot Be Linked : 51484
The payment is trying to be linked to an invoice that did not get synced. Since the invoice does not exist in QuickBooks yet, there isn't a transaction to associate the payment with in QuickBooks.
This might mean that an error for the invoice will need to be resolved before this payment can sync successfully.
It might also mean that the invoice the payment is associated with hasn't been pushed to QuickBooks yet. If this is the case, navigate to the invoice and click More Actions > Push to QuickBooks. Then run a sync. This will either push the invoice to QuickBooks and bring the payment along with it, or it will return an error that will hint at why the invoice did not sync successfully.
Sync Failed: Critical error during sync: undefined method `name’ for nil:NilClass
This error means that there is no "undeposited funds" account set up in QuickBooks. This account is created automatically when you sign up for QuickBooks, so if this error appears it means the account might have been renamed or removed. To resolve this error, create an account in QuickBooks called "undeposited funds".
Payouts
Error pushing Payout #1234 to QuickBooks Online. Payment(s) in this payout are already associated with a bank deposit in QuickBooks Online.
This error can occur when the bank account deposit has already been recorded in QuickBooks from another source and then the associated payments were already applied to the bank deposit.
You might run into this error if:
- You have manually adjusted the “Deposit to” account on payments in QuickBooks that were synced from Jobber.
To resolve, in QuickBooks, revert the “Deposit to” accounts on these payments back to “Undeposited Funds” and then run the sync again. Going forward, the sync will automatically make journal entries to move funds from “Undeposited Funds” to your checking account when payouts are deposited.
- You are manually associating payments to bank deposits in QuickBooks when reconciling your accounts.
To resolve, delete the entire bank deposit from QuickBooks and then run a sync again. Going forward, the sync will automatically create payout bank deposits and associate payments to them.
If neither of these reasons and troubleshooting steps resolve your error, please reach out to our Success Team as there may be another reason this error is appearing.
Error pushing Payout #1234 to QuickBooks Online. Payment(s) from the following invoices have not been pushed to QuickBooks Online: 1234, 5678, ...
This error can happen for a couple of different reasons, but what it comes down to is that the payments that compose a payout have not synced to QuickBooks Online. Anything that breaks the related invoice or payments from syncing would cascade down to breaking the payout sync. You might be seeing this error because:
- The payout is from before the payout sync settings were turned on. If this is the case, reach out to our Success Team and they can help you backdate the payout sync.
- Invoice numbers might have been changed in QuickBooks which meant the payments couldn't map to the correct invoice since the invoice number had changed.
Other Errors
Updating the taxable status of item "EXAMPLE" to be taxable. This will not affect tax calculations on existing invoices but will affect 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.
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.
Critical Error during sync: Permission Denied Error: You do not have the access to use this feature. Missing Permission on customer to read
This is caused when an Administrator is deactivated or changed in QuickBooks after connecting with Jobber. If the administrator was recently deactivated or changed in QuickBooks, reach out to the Success Team for next steps to resolve this error.
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 by chat, phone (1 888 721 1115), or support@getjobber.com and we can help look into it for you.