Understanding QuickBooks Online Export Errors Follow

This article lists common error messages you may encounter when exporting to Quickbooks Online. These errors can be found on the Export page.

 

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 Online > once disconnected, click Connect to QuickBooks > Sign in using your QuickBooks Online login credentials > Authorize

Once Quickbooks Online is reconnected, re-export the reports.

 

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:

1. Navigate to Manage lists > Corporate cards > Liability Account
2. Ensure this is mapped to a Credit Card type GL account.
3. 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 Credit Card Type Liability Account > Save and try your export again

See: Mapping Company Cards for more details.

 

Error: XXX must be mapped to a Vendor

Reason:

The user is not mapped to a vendor in Quickbooks online.

Solution:

Navigate to Manage Lists > People > Click on the user's name > Mapping > Vendor Name in Accounting System > select the appropriate Vendor from QuickBooks >  Save & Exit and try your export again.

 

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:
Open your books in QuickBooks to include the date that Tallie is attempting to assign. Do this in QuickBooks Online 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 them again.

or 

Adjust the Export date used for the report by navigating to Integration & Sync > Export Settings > When Creating Payables and/or When Creating Transactions and select Prompt for the Date to be Used > Save

Once you have adjusted this setting, you can enter a date after your Closing Date in QuickBooks. on the report(s) you need to export. 

 

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 instead of a single account, you must map an income account to every expense account that will be used for billable expenses. 

Solution:

1. In Quickbooks, click the Gear icon > Chart of Accounts
2. Click to edit the Expense Account mapped to the applicable Expense Category in Tallie
3. Check the box for Use for billable expenses > Income Account > Map an account > Save. 
4. 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:

1. Identify the list object from the error message.
2. Make the list object active in Quickbooks Online.
3. Re-export the report

 

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 must be synced with QuickBooks Online before the report can be exported.

To avoid this error, always ensure that you create Account list items within QBO and bring them over to Tallie via sync.

Solution: 

Since Tallie's sync is bi-directional by default, you can run a sync to attempt to populate the data within QBO to do this, Navigate to Settings > Integration & Sync and click Sync now and try your export again. If this fails, you can contact Support to initiate a full sync on your account to align the list data in both systems.

 

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:

1. Change the GL account type in Quickbooks Online to an Expense type, Other expenses or Cost of Goods sold.
2. In Tallie, navigate to Integration & Sync > Sync now
3. Export the report.