QuickBooks Online Export & Sync Errors Follow
This article lists common error messages which you may encounter when exporting to Quickbooks Online. These errors can be found on the Export page.
Error: QuickBooks had a problem receiving an Expense Item from us. The response from the application was: QBO Failed with ValidationException was thrown. Details: The account period has closed and the account books cannot be updated through the QBO Services API. Please use the QBO website to make these changes.
Reason:
The accounting period in Quickbooks is closed.
Solution:
- Determine the date you've set for the transaction by navigating to Integration & Sync > Export Settings > In the When Creating Payables and When Creating Transactions drop-down menu, choose between the Export Date, the Prompted Date (the date the admin chooses on export), or the Transaction Date (for credit card charges).
- Open your books in QuickBooks to include the date that Tallie is attempting to assign. Do this in QuickBooks by clicking the Gear icon > Accounts and Settings > Advanced > Accounting > Closing Date > Change the date or uncheck the Close Books box > Done.
- Once the books have been opened, you can export again.
Note: You can specifically choose a date that is after your Closing Date in QuickBooks. You can change the date in Tallie by going to Integration & Sync > Export Settings > When Creating Payables and When Creating Transactions > Switch to Prompt for the date to be used > Save.
Error: QuickBooks had a problem receiving an Expense Item from us. The response from the application was: QBO Failed with ValidationException was thrown. Details Business ValidationError: An account you chose for a billable expense doesn't have an income account associated with it. Before you save this transaction, you need to make that associated, or the income won't be reported correctly...
Reason:
You may encounter this error when you have "Track billable expenses and items as income in Multiple Accounts" enabled in Quickbooks. This is because when you have Multiple Accounts set as opposed to a single account, you must map an income account to every expense account that will be used for billable expenses.
Solution:
- In Quickbooks click the Gear icon > Chart of Accounts > Click to edit the Expense Account that was mapped on the Expense Category in Tallie.
- Check the box for Use for billable expenses > Income Account > Map an account > Save.
- Re-export the report from Tallie.
Note: If you do not want to use Multiple Income Accounts, you can switch to a single account. In QuickBooks, click the Gear icon > Accounts and Settings > Expenses > Bills and Expenses > Track billable expenses and items as income > Choose in a Single Account > Save. This will prevent you from having to map an income account to every expense account individually.
Error: QuickBooks had a problem receiving an Expense Item from us. The response from the application was: QBO Failed with ValidationException was thrown. Details: Invalid Reference ID: One of the list elements assigned to this transaction has been deleted. Before you can modify this transaction, you must restore (name of the list that's been deleted).
Reason:
List data on the transaction has been deleted in Quickbooks.
Solution:
- Identify the list object from the error message.
- Make the list object active in Quickbooks Online.
- Re-export the report.
Error: Unfortunately, Tallie has experienced a communication error with Quickbooks and an export must be initiated again. In order to prevent duplicates, please check your Quickbooks...
Reason:
The connection between Quickbooks and Tallie needs to be refreshed.
Solution:
- Navigate to Settings >Integration & Sync > Sync Settings > Click Disconnect QuickBooks.
- Click Connect to QuickBooks > sign in using your QuickBooks Online login credentials > Authorize.
- Once Quickbooks Online is reconnected, re-export the reports.
Error: Account [Name of Account] has not been properly mapped to QuickBooks Online. This is required for QuickBooks online exports.
Reason:
The list data has not been synced with QuickBooks Online. List data will need to be synced with QuickBooks Online before the report can be exported.
Solution:
- Navigate to Settings > Integration & Sync > Sync now.
- Re-try Export.
- If it fails, then in QuickBooks, find the list data and add an "x" > Save > Remove the "x" Save.
- Click Sync Now in Tallie.
- Re-export the report.
Error: Quickbooks had a problem receiving a Expenseitem from us. The response from the application was: The "billable status" field has an invalid value "NotBillable". Quickbooks error message. Target is not reimbursable.
Reason:
This error indicates that the GL account these expenses are mapped to cannot be billed, if the expense is tagged as either 'billable' or 'non-billable' an export error will occur.
Solution:
- Change the GL account type in Quickbooks Online to an Expense type, Other expenses or Cost of Goods sold.
- In Tallie, navigate to Integration & Sync > Sync now.
- Export the report.
Error: QuickBooks had a problem receiving a Expenseltem from us. The response from the application was: QBO Failed with "Validation Exception was thrown Details: Invalid account type: You need to select a different type of account for this transaction.
Reason:
This error occurs when you are trying to export a credit card refund expense and the Corporate card is mapped to a Bank type GL account. You cannot input a negative amount into a GL account which is a Bank type account.
Solution:
- Navigate to Manage lists > Corporate cards > Liability Account.
- Change to a Credit Card type GL account.
- Re-export the report.
Error: This account has a type that is not appropriate for a corporate card. Please choose a different account. The corporate credit card "XXXX" must be linked to a valid account of "Credit Card" type. This is required for QuickBooks exports.
Reason:
The corporate card associated with the expense has not been mapped to a liability account in Quickbooks.
Solution:
- Navigate to Manage lists>Corporate cards >Liability Account.
- Map the associated corporate card > Save.
- Re-export the report.
Error: XXX must be mapped to a Vendor.
Reason:
The user is not mapped to a vendor in Quickbooks online.
Solution:
1. Navigate to Manage Lists > People > User's name > Mapping > Vendor Name in Accounting System > Save.
2. Re-export the report.