Fix common QuickBooks errors - QBO

Below are common errors that you might experience when exporting from ServiceTitan to QuickBooks Online (QBO). The resolution to each error is listed to help you quickly resolve any identified issues.

Who uses this feature

Feature configuration

• Account configuration is required to use this feature. Please contact Technical Support for details.

Things to know

• The errors below are generalized. For example, where it says "Business Unit Name" the specific name of the business unit experiencing the error would appear. Likewise, the number sign (#) indicates where a number would appear in the error.

• Sometimes QuickBooks won't accept the information on the first export or Web Connector run. Try to export again if your first attempt fails. If the error persists, see the error message solutions below.

• If you're looking for the solution to a specific error on this page, press Ctrl + F and search for it.

• If a bill shows as exported but isn't showing in the accounting software, make sure the vendor is active in ServiceTitan and QuickBooks.

Where you see exporting errors

• QuickBooks Online: Exporting errors in QuickBooks Online (QBO) shows as a pop-up within QBO or on the Pending Export Report.

• QuickBooks Desktop: Exporting errors in QuickBooks Desktop (QBD) shows on the Export Error Report in ServiceTitan.

Read errors in QuickBooks

Typically, the first part of a QuickBooks error will generally specify where the error is occurring (Customer list, Item list, etc.) and what item is causing the error (the specific service, customer, business unit, and so on). The second part of the QuickBooks error will generally explain why the error occurred.

Errors and solutions for QuickBooks Online

"Accounts Receivable" in the Item Service. QuickBooks error message: You cannot associate an item with Sales Tax Payable, Undeposited Funds, accounts receivable, accounts payable, or non-posting accounts. Usually, if you sell the item, use an income account; if you buy it, use an expense account."

The issue usually happens when the Retainage line item had the GL account as "Asset - Accounts Receivable" which QBO doesn't allow (it is a limitation). Either change the type of the GL account or change the GL account of the item to resolve.

Attempt to add QBO Invoice has failed with the following error: 400 - BadRequest ValidationException was thrown. 2500 - Invalid Reference ID : Categories cannot be used in transactions. Invalid Reference ID

This error may occur if the QBO category name has the same name as the task (Pricebook service) on the invoice.

To fix this error, you can:

• In QBO, delete the category. [Settings > All lists > Product Categories]

• In QBO, change the name of the category.

• In ServiceTitan, change the name of the task in the Pricebook. Then, remove and re-add the task to the invoice.

Can't export Invoice(ID=######). Attempt to add QBO Invoice has failed with the following error: 400 - BadRequest ValidationException was thrown. 2050 - String length specified does not match the supported length. Min:0 Max:1,000 supported. Supplied length:1,023 String length is either shorter or longer than supported by specification

This error occurs when a field exceeds QuickBooks' maximum allowed characters in a given field.

You need to see what field is exceeding the character limit, usually the invoice summary, pricebook item description, or vendor document number, and edit it to fall within the specifications.

For more information, see QBD Onboarding Step 3: Map pricebook items to a QuickBooks general ledger account and Character limitations for fields in QuickBooks.

Can't export Invoice (ID=######). Attempt to add QBO invoice has failed with the following error: 400 - BadRequest ValidationException was thrown. 6140 - Duplicate Document Number Error: You must specify a different number. This number has already been used. Duplicate Document Number Error.

You may receive this error if an invoice already exists in QuickBooks with this number.

1. Search your QuickBooks company file for this invoice number. If the invoice found is identical to the one you are attempting to export from ServiceTitan, it may have been entered manually and must be bypassed from the Pending Export Report.

2. If this is a different invoice, one from previous software for example, retain this number in QuickBooks and update the invoice number in ServiceTitan.        

   1. Open the invoice and click Update Invoice Details.

   2. Edit the invoice number to be a unique sequence and click save.

Note: Make sure your search filters in QBO match the date range of the transaction.

Can't export Payment(ID=#######). Attempt to add QBO Payment has failed with the following error: 400 - BadRequest ValidationException was thrown. 620 - TxnID Cannot Be Linked : ##### TxnID Cannot Be Linked

This usually happens when the customer was changed on the invoice after it was exported to QuickBooks and ServiceTitan can no longer link the payment to the invoice.

In QuickBooks, search for the invoice by invoice number and reassign it to the same exact customer name as it appears in ServiceTitan.

Can't export Payment(ID=#######). Attempt to add QBO JournalEntry has failed with the following error: 400- BadRequest Validation Exception was thrown. 2020 - Required parameter AccountRef is missing in the request. Required param missing, need to supply the required value for the API

You may receive this error if you have not specified a general ledger account for that payment type in ServiceTitan.

You need to enter an asset or liability account for the payment type in ServiceTitan.

1. Go to the navigation bar and click Settings.

2. In the side panel, click Invoicing > Payment and Invoice Types.

3. Click Edit on a payment type to change the GL account.

Note: If your payment type's Export As: is set to Payment, you can't assign a GL account to it. It exports to Undeposited Funds in QBO.

For more information, see Set up payment types in ServiceTitan.

Can't export Payment(Id=#######). Attempt to add QBO Payment has failed with the following error: Validation Exception was thrown.Details:TxnID Cannot Be Linked : 13911. 620 - TxnID Cannot Be Linked : 13911 TxnID Cannot Be Linked

There are multiple instances of an invoice's details in ServiceTitan or QBO.

1. Check QuickBooks Online and ServiceTitan to make sure that the invoice details match exactly in both systems (customer, total, date, tax, line items, and so on). There can only be one instance of each of these details in ServiceTitan and QBO.

2. After merging or deleting any duplicate details, re-export the batch.

3. If there are no duplicates and the error persists, manually add the payment in QBO and bypass the batch in ServiceTitan.

Can't export Payment(Id=94348984). Attempt to add QBO JournalEntry has failed with the following error: Validation Exception was thrown.Details:Required parameter AccountRef is missing in the request. 2020 - Required parameter AccountRef is missing in the request Required param missing, need to supply the required value for the API.

You need to change the Payment type to Journal Entry for negative payments.

Cannot Change Who Customer Bills With Error : You cannot change who this customer bills with because there are invoices for the parent that include charges for this customer, or there are payments from the parent that pay off invoices for this customer.

1. In QuickBooks Online, check to see if the customers are sub-customers.

2. Make sure the sub-customers have parent customers.

3. You can either:        

   1. Clear the Is a sub-customer option in QuickBooks Online

   2. Change the name of the customer in ServiceTitan to the [parent]:[child] format.

4. Export the batches again.

Couldn't export the batch (batch #), the error: Throttle Exception was thrown.

You can export the batch after breaking it down into smaller batches and exporting it multiple times.

Couldn't export business unit "Business Unit Name" the error: Can't export Payment(ID= #######). Attempt to add QBO Payment has failed with the following error: 400 - BadRequest. ValidationException was thrown. 610 - Object Not Found: Something you're trying to use has been made inactive. Check the fields with accounts, customers, items, vendors, or employees. Object Not Found.

The invoice was originally exported from ServiceTitan to QuickBooks and was subsequently deleted. If the invoice was manually re-entered into QBO, this error appears because the payment is looking for the ID number associated with the exported invoice, which no longer exists.

Bypass payments from the Pending Export Report and manually enter them into QuickBooks since they can't attach to the invoice.

Couldn't export business unit "Business Unit Name", the error: Account "Payment type" is not found.

This error can occur when you don't have a general ledger account assigned to your payment types in ServiceTitan or your payment type is set to a GL account that does not exist in QuickBooks.

You need to enter an asset or liability account for the payment type in ServiceTitan.

1. Go to the navigation bar and click Settings  .

2. In the side panel, click Invoicing > Payment and Invoice Types.

3. Click Edit on a payment type to change the GL account.

Note: If your payment type's Export As: is set to Payment, you can't assign a GL account to it. It will export to Undeposited Funds in QBO.

For more information, see Set up payment types in ServiceTitan.

Couldn't export business unit "Business Unit Name", the error: Export finished with errors. See Pending Export Report in ServiceTitan for more details

This error may occur if there is another item named the same way in QuickBooks. Check the customer, vendor, and employee lists for duplicates.

This error can also occur if you have a GL account missing in QuickBooks Online. If your GL account is missing in QuickBooks Online, follow the steps outlined here.

Couldn't export business unit "BusinessUnit", the error: Payment of invoice #xxxxxx cannot be exported. Payment type should be active.

1. Go to the invoice that is causing the error message to appear.

2. Check the payment type that was used for the payment.

3. If the payment type is inactive, go to the payment type settings and activate it.

4. Go back to the invoice and update the payment type to the active payment type.

5. Save the changes to the invoice.

6. Attempt to export the payments again.

Note: The payment type must be active in both QuickBooks Online and ServiceTitan.

Couldn't export business unit "Business Unit Name", the error: Tax code for invoice ######### is not specified.

This error indicates you have not set a tax zone for that customer's location in ServiceTitan.

An address must have a zip code in order for tax zones to be successfully applied automatically through your settings.

1. Search for the customer's service location and click Edit .

2. Validate the address by clicking the orange ? to the right of the street field and selecting the correct address from the pop-up. If the address is not found or unable to be validated, ensure the location's zip code is correct.

3. If a tax zone already exists for this zip code, assign it to this location by clicking the Tax Zone dropdown.

Once the address is entered correctly, you need to set your tax zones.

1. To set a tax zone in ServiceTitan, go to the navigation bar and click Settings  .

2. In the side panel, click Invoicing > Tax Zones.

3. Assign the zip code to an existing tax zone or create a new one. Click Set Tax Zones when you're finished. For more information, see Set up QuickBooks Desktop for sales tax (US).

Couldn't export business unit "THC", the error: Can't export PurchaseOrder(ID=2096540). Attempt to add QBO PurchaseOrder has failed with the following error: 400 - BadRequest Validation Exception was thrown.Details:Type field is required for Item CREATE/UPDATE requests for Minor Version 33 or above. 9032 - Type field is required for Item CREATE/UPDATE requests for Minor Version 33 or above. ItemType required in Minor Version requests.

You are attempting to export Summary Purchase Orders without a certain item having been manually created in QuickBooks Online.

In QBO, create an item by navigating to Products and Services > New > Service. The item is classified as a service and named Service Titan PO Item.

Couldn't export business unit "Business Unit Name", the error: Can't export ISku(ID=####,Code=##). Attempt to update QBO Item has failed with the following error: 400 - BadRequest ValidationException was thrown. 6200 - The account period has closed. Account Period Closed

This error occurs if you have set a date in QuickBooks Online that does not allow transactions from posting before that date.

In QuickBooks Online:

1. Go to Settings > Accounts and Settings.

2. Select the Advanced tab.

3. Select Edit in the Accounting section.

4. Change the Closing date in the Close the books section.        

   Note: To change your password, enter a new password and confirm it.

5. Click Save and then Done.

Couldn't export business unit "YYYYYYYY", the error: Throttle Exception was thrown

The error occurs when the batch contains too many invoices. To resolve this, split the batch into smaller batches of 3 or 4 and export them.

Couldn't export business unit. The error: Validation Exception was thrown.Details:Permission Denied Error : You do not have the access rights to use this feature. Missing permission on Account to Read.

This error occurs if you do not have sufficient permissions in QuickBooks. Set your permissions in QuickBooks to the correct level to resolve this error. For more, see QuickBooks export permissions.

Duplicate name already exists

You may receive this error if a customer name already exists in QuickBooks.

Search across all lists in QuickBooks for the customer name. If the customer name found is identical to the one you are attempting to use, change the existing customer name, and you'll be able to successfully export the batch.

Export error on invoice: Invoice ####-##-### // item: {{NAME}}

QuickBooks is unable to link the payment to this invoice or to this customer when exporting.

To fix this error:

• Make sure the customer profile and the invoice match up exactly with ServiceTitan

• If everything is matching, check for duplicate customer profiles

GL account "GL Account Name" does not exist in QuickBooks.

QuickBooks is not recognizing the GL account. To fix this error, you can:

In ServiceTitan:

• In your pricebook, change the item's GL account to an account already existing in QuickBooks

In QuickBooks:

• Create the account in the Chart of Accounts within QuickBooks Online

GL account "____" does not exist in QB. Please change this item's GL account to an existing account in QB or create this account in QB

Possible reason 1: QuickBooks is not recognizing the GL account. To fix this error, you can:

In ServiceTitan:

1. In your pricebook, change the item's GL account to an account already existing in QuickBooks

In QuickBooks:

1. Create the account in the Chart of Accounts within QuickBooks Online

Possible reason 2: A GL account in ServiceTitan isn't notated as a sub-account

In QBO:

1. Confirm the account referenced in the error is a sub-account and is related to an active GL account.

In ServiceTitan:

1. Navigate to Settings > General Ledger Accounts.

2. Edit the name of the GL account and include a colon to notate the parent-child relationship of the two accounts.

3. Change the subtype to Other Liability.

ServiceTitan is going to access your QuickBooks Online (production) data for the business unit "YYYYYYY". Continue?

To resolve, first check the business unit in Settings > QuickBooks Online and make sure it is connected. If not, change the BU of the invoice and try exporting again.

"Success" when attempting to export a bill/"Couldn't export business unit "XXXXX", the error: Failed to export purchase (Id=XXXXX). There is an existing bill with this document number

To resolve, first cancel the bill. Then edit the vendor document number to a unique number on the receipt and generate a new bill for the receipt.

Note: If the receipt doesn't have a vendor document number, add a placeholder. This will let you complete the steps.

Validation Exception was thrown.Details:The name supplied already exists. : null. 6240 - The name supplied already exists. : null Duplicate

This error occurs because there is a customer record with the same name in QBO.

1. Go to Quickbooks Online and search for the customer with the same name as the technician on the bill.

2. Rename the customer's name in Quickbooks Online to something unique.

3. Go back to ServiceTitan and attempt to export the bill to Quickbooks Online again.

This error can also occur when a service location exports to QuickBooks Online as a sub-customer and a record with the same name already exists. Search across all customer, vendor, and employee lists in QuickBooks for the matching name. Rename the conflicting record in QuickBooks Online or update the service location name in ServiceTitan, then retry the export.

Validation Exception was thrown. 2500 - Invalid Reference Id : An item in this transaction is set up as a category instead of a product or service. Invalid Reference Id

Check the service in error and see if that service exists in QuickBooks Online as a category. You may need to change your service name since categories cannot have the same name as a pricebook service, material, or equipment.

Validation Exception was thrown.Details:Business Validation Error: Enter a transaction amount that is 0 or greater.. 6000 - Business Validation Error: Enter a transaction amount that is 0 or greater. A business validation error has occurred while processing your request

This error is due to a $0 or negative total on an invoice. The $0 or negative total could be due to non-taxable tasks bringing the balance down to $0 or negative by taxable tasks.

To export the invoice correctly, the subtotal must be greater than $0. A Liability task in this case cannot be marked as taxable and the income items need to be marked as non-taxable to prevent the invoice from having a subtotal/total of $0.

Call to the endpoint returned a 500 - Internal Server Error response

This is typically a temporary server glitch. Unpost the batch, wait a few moments, then repost and re-export. If the error persists, contact Technical Support.

Account '[Account Name]' is not found

The GL account referenced doesn't exist in QuickBooks or the parent account structure is missing. Either create the missing account in QuickBooks or update the GL account mapping in ServiceTitan. For sub-accounts, ensure parent accounts exist in both systems.

String length specified does not match the supported length

Identify which field exceeds QuickBooks' character limits (usually invoice summary, item description, or vendor document number) and edit to fall within specifications.

Sub-customer export failed: parent customer not found in QuickBooks Online

This error occurs when a service location sub-customer or its associated invoice exports before the parent customer record syncs to QuickBooks Online. Verify the parent customer exists in QuickBooks Online. If the parent customer failed to sync, resolve the parent customer error first, then retry the sub-customer export.

Want to learn more?

• See QuickBooks Online