QuickBooks integration for billing: Troubleshooting
Table of Contents
- View QuickBooks sync errors
- Common issues and their solutions
- Invoice/payment/account/service has unsynced
- Can’t find an exact match for Account name in your QuickBooks account
- Duplicate invoices/payments appear
- Payment fails to sync to a closed-period invoice in QuickBooks
- Duplicate Name Exists Error: The name supplied already exists
- Invalid Customer: The customer you have specified has been deleted. You cannot create or edit a transaction with a deleted customer
- Duplicate Document Number Error: You must specify a different number. This number has already been used.
- Invalid Reference Id: Line.SalesItemLineDetail.ItemRef
- Business Validation Error: The Amount Received (plus credit) can’t be less than the selected charges. Also, the selected charges can’t be less than the selected credit.
- Invalid account type: Check your account details before you continue. You may need to select a different type of account for your transaction.
- Invalid account type: You can’t associate a product or service with accounts of certain types (such as Accounts Receivable and Accounts Payable)
- String length is either shorter or longer than supported by specification: string length specified does not match the supported length. Min:0 Max:100 supported
- Different service errors
- Service name appears in the line item description
- Invoice description syncs to the Memo field
- Buttons are unavailable
- No option to resync an invoice after deleting it from QuickBooks
- Credit note not syncing to QuickBooks
This guide covers common sync issues in the QuickBooks integration for billing, including how to identify and resolve them.
Note
This article covers sync issues with QuickBooks integration for billing (invoices, payments, services). For issues with QuickBooks integration for bookkeeping transactions, see this article .View QuickBooks sync errors
Right after you connect QuickBooks Online in TaxDome, TaxDome starts continuously analyzing the sync status. If something goes wrong, you will see the following error message at the top:
Click the link in the message or go to Settings from the sidebar menu and open Integrations > QuickBooks. In the QuickBooks errors section, you’ll see the number of errors per category. You can review the errors on each tab and select how to handle them.
Reference: sync error types
| Error type | Cause |
|---|---|
| Accounts | Errors caused by TaxDome and QuickBooks client data not matching |
| Invoices | Errors caused by TaxDome Invoices and QuickBooks Invoices data not matching. For example, if you have manually changed a TaxDome invoice number , you may have to duplicate the invoice number in QuickBooks |
| Payments | Errors caused by TaxDome and QuickBooks Payments data not matching |
| Refunds | Errors caused by TaxDome and QuickBooks Refunds data not matching |
| Expenses | Errors caused by Stripe Transaction Fees and QuickBooks Expenses data not matching |
| Services | Errors caused by TaxDome and QuickBooks Product/Services data not matching |
Common issues and their solutions
Invoice/payment/account/service has unsynced
An invoice, payment, service or account can become Not synced when an associated entity is deleted from QuickBooks Online—for invoices and payments, that includes any linked invoice, payment, service or account; for services and accounts, only the entity itself.
To solve the issue:
-
For invoices/payments: Open the three-dot menu next to invoice/payment in the list and hover over Sync to QuickBooks. You will see what exactly has been deleted. Go to that entity, resync it and create a new corresponding entity in QuickBooks.
-
For services/accounts: Go to service/account, resync it and create a new corresponding entity in QuickBooks.
Can’t find an exact match for Account name in your QuickBooks account
| Reason | Solution |
|---|---|
| You haven’t created this customer in QuickBooks yet. | In QuickBooks errors > Accounts, select Create new customer in QuickBooks for all accounts missing in QuickBooks and click Submit. |
| You manually created this customer in QuickBooks after syncing TaxDome with QuickBooks. | Manually sync the account in TaxDome. |
Duplicate invoices/payments appear
| Reason | Solution |
|---|---|
| During bank transaction reconciliation in QuickBooks Online, manually creating entries like invoices, payments and expenses for Stripe fees can lead to duplicates if automatic creation is enabled in the settings. | Avoid manually creating these entries in QuickBooks. Instead, match the transactions automatically generated by the integration. |
| Duplication can occur if both Stripe and TaxDome are integrated directly with QuickBooks Online, as both systems create payment transactions independently. | Turn off the Stripe integration in QuickBooks or disable the sync of payment transactions from Stripe. This ensures only TaxDome handles payment transaction syncing. |
| Duplication may appear because of the bank payment processing specifics. | Manually delete duplicated payments in QuickBooks or contact Intuit to resolve the issue. |
Payment fails to sync to a closed-period invoice in QuickBooks
QuickBooks Online does not allow modifications to transactions that belong to a closed accounting period.
If you need to sync to a closed-period invoice in QuickBooks, go to Settings > Account and settings > Advanced, select Edit in the Accounting section, then uncheck Close the books or change the closing date to a date before the invoice date. Once done, re-sync the payment from TaxDome.
Duplicate Name Exists Error: The name supplied already exists
- For payment sync errors:
The error occurs when the payment method in QuickBooks is selected incorrectly.
To fix the issue, in QuickBooks, navigate to Accounting > All lists > Payment Methods > ACH payment method. Clear the This is a credit or debit card checkbox if it is selected. Then, log in to TaxDome as the Firm owner and resync the sync errors on the QuickBooks tab of the Settings > Integrations page.
- For account sync errors:
| Reason | Solution |
|---|---|
| When trying to sync an account manually from the QuickBooks errors section, you select Create new customer in QuickBooks, but a customer with this name already exists in QuickBooks. | If the customer with the same name in QuickBooks is the client you want to sync in TaxDome, in the QuickBooks errors section, type their name in the Action column in the search field and select it. Then, click Submit. If the customer with the same name in QuickBooks is not your client in TaxDome, you’ll need to edit their name because both TaxDome and QuickBooks don’t allow duplicate names for customers. |
| Another vendor is already using this name. | Before creating a new account, check if a vendor with that name exists in your QuickBooks database. If it exists, create a scheme to distinguish them and create a new name. For example, John Doe may be a client and vendor: store their names in the customer object as John Doe (client) and in the vendor object as John Doe (vendor). |
Invalid Customer: The customer you have specified has been deleted. You cannot create or edit a transaction with a deleted customer
It happens when the account has been removed from QuickBooks. You may have had a customer with the same name, but deleted it. Try reconnecting to QuickBooks.
Duplicate Document Number Error: You must specify a different number. This number has already been used.
| Reason | Solution |
|---|---|
| Invoice with the same number already exists in QuickBooks. | Change the invoice number in TaxDome and resync the invoice. To avoid such issues in the future:
|
| The invoice number is identical to the Credit memo number in QuickBooks, and this causes this error. | Assign a unique Credit memo number and reattempt sync. |
Invalid Reference Id: Line.SalesItemLineDetail.ItemRef
It might happen when a service or item used in a transaction was deleted in QuickBooks.
To fix this issue, restore the deleted service or item in QuickBooks (do not create a new one). After restoring, resync the entities with this error.
Business Validation Error: The Amount Received (plus credit) can’t be less than the selected charges. Also, the selected charges can’t be less than the selected credit.
This error occurs when a vendor credit is applied to an invoice in TaxDome and that application is trying to sync to QuickBooks Online, but the open balance of the invoice in QuickBooks Online is less than the credit amount applied. If the invoice is already marked as paid in QuickBooks Online, review payments in both QuickBooks Online and TaxDome to ensure they match. Void the payment and/or remove the credit in QuickBooks Online if necessary.
Invalid account type: Check your account details before you continue. You may need to select a different type of account for your transaction.
This error occurs when the wrong account is selected in the Expenses settings in QuickBooks.
Change the Expenses account type in QuickBooks to Credit Card. Then, in TaxDome, select Resync for the error in the QuickBooks errors section and click Submit.
Invalid account type: You can’t associate a product or service with accounts of certain types (such as Accounts Receivable and Accounts Payable)
This error occurs when an item attempts to sync from TaxDome to QuickBooks Online, but the account type associated with the provided service isn’t correct.
To fix the issue, in TaxDome, edit the provided service to the correct account type and sync again. If the product or service is something you sell, choose an Income account; if it’s something you purchase, choose an Expense account. Learn more here .
String length is either shorter or longer than supported by specification: string length specified does not match the supported length. Min:0 Max:100 supported
This error message appears when the text in a field is too long for QuickBooks Online. This usually happens in fields like Invoice ID, Item Name, Notes, or any other field that sends information to QuickBooks Online.
Read the message text and adjust the field value accordingly. Note that the maximum values can be different depending on the field. Then, select Resync for the error in the QuickBooks errors section and click Submit.
Different service errors
There may be various reasons for these errors. For example, it may happen because of technical issues.
To fix the issue, delete the service from the QuickBooks tab of the Settings > Integrations page. Also, edit the Service income account, then create a new service and sync it with QuickBooks.
Service name appears in the line item description
This happens when services are not synced with QuickBooks Online or when the service name is manually typed into invoices in TaxDome.
Check the syncing settings to ensure services are properly synced with QuickBooks. Use the list of services in TaxDome rather than manually entering service names to avoid this issue.
Invoice description syncs to the Memo field
The invoice description in TaxDome is intended to act as a memo to identify invoice contents, not as a service.
Use line items to specify services on invoices. Customize line items to simplify filling them out and ensure the correct information syncs to QuickBooks.
Buttons are unavailable
| Reason | Solution |
|---|---|
| You may be unable to perform some actions because you lack the required permissions . | Review the permissions and ask your firm owner or admin to perform the required actions. |
| You may be unable to perform some actions because of your browser. | Try general troubleshooting steps. |
No option to resync an invoice after deleting it from QuickBooks
To fix the issue, delete the invoice from TaxDome and create a new one.
Credit note not syncing to QuickBooks
A credit note on its own represents a balance, not a completed transaction. Since there is no transaction amount for QuickBooks to process, it causes the sync to fail with error code 6000.
To fix the issue, apply the credit to an invoice. Once the payment status shows Invoice paid, both the invoice and payment will sync to QuickBooks.
Was this article helpful?
Table of Contents
- View QuickBooks sync errors
- Common issues and their solutions
- Invoice/payment/account/service has unsynced
- Can’t find an exact match for Account name in your QuickBooks account
- Duplicate invoices/payments appear
- Payment fails to sync to a closed-period invoice in QuickBooks
- Duplicate Name Exists Error: The name supplied already exists
- Invalid Customer: The customer you have specified has been deleted. You cannot create or edit a transaction with a deleted customer
- Duplicate Document Number Error: You must specify a different number. This number has already been used.
- Invalid Reference Id: Line.SalesItemLineDetail.ItemRef
- Business Validation Error: The Amount Received (plus credit) can’t be less than the selected charges. Also, the selected charges can’t be less than the selected credit.
- Invalid account type: Check your account details before you continue. You may need to select a different type of account for your transaction.
- Invalid account type: You can’t associate a product or service with accounts of certain types (such as Accounts Receivable and Accounts Payable)
- String length is either shorter or longer than supported by specification: string length specified does not match the supported length. Min:0 Max:100 supported
- Different service errors
- Service name appears in the line item description
- Invoice description syncs to the Memo field
- Buttons are unavailable
- No option to resync an invoice after deleting it from QuickBooks
- Credit note not syncing to QuickBooks