Help Center

QuickBooks Online Export & Sync Errors

Follow

QuickBooks Online Closed

You may experience QuickBooks Online locking up when attempting to post data from Tallie and it may unexpectedly close. If that happens, you may see one of the following error messages:

  • 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.
  • 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.

To solve, first determine the date you've set for the transaction. To find this out, go to Integration & SyncExport Settings > In the When Creating Payables and When Creating Transactions drop-down menu, choose between the Export Date, the Prompted Date (date the admin chooses on export), or the Transaction Date (for credit card charges).

QuickBooks_1.png

Once you know which date Tallie is attempting to populate, you can determine if that date is on or before the date in the error message. If it is, 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 SettingsAdvanced AccountingClosing DateChange the date or uncheck the Close Books boxDone. Once the books have been opened, you can export again.

Lastly, 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 & SyncExport SettingsWhen Creating Payables and When Creating TransactionsSwitch to Prompt for the date to be used Save.

Expense Account does not have an Income Account mapped for Billable Expense

If you have "Track billable expenses and items as income in Multiple Accounts" setup in their QuickBooks Online settings, the below error message may appear:

  • QuickBooks had a problem receiving an Expense Item from us. The response from the application was: QBO Failed with ValidationException was thrown. Details Business Validation Error: 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...

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. 

To solve, in QBO click the Gear icon > Chart of Accounts > Click to edit the Expense Account that was mapped on the Expense Category in Talie > Check the box for Use for billable expenses Income AccountMap an account Save. Once saved, you can re-export the report.

Alternatively, 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. 

List Data on Transaction has been Deleted in QBO

If you've deleted a list object in QBOTallie may be attempting to use that deleted list object on the expense report when sending it over to QBO. When this happens, you may receive the error message below:

  • 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 list that's been deleted).

To solve, you can activate the deleted list data in QBO by finding the list object that is detailed in the error message. Once found, click Make Active in QBO. Alternatively, swap out the detailed list object in Tallie for one that is not deleted. 

General Sync Issue between QuickBooks Online and Tallie

If you're having trouble syncing between QBO and Tallie, start by Disconnecting and Reconnecting QBO in Tallie. Navigate to Integration & Sync Sync Settings

List Data Mapping

You may receive the below error message if the list data has not been synced with QuickBooks Online:

  • Account [Name of Account] has not been properly mapped to QuickBooks Online. This is required for QuickBooks online exports.

List data will need to be synced with QuickBooks Online before the report can be exported. To do this, click Sync Now. Once the sync has completed, test the report by clicking Export. If it fails, then in QuickBooks, find the list data and add an "x" > SaveRemove the "x"  Save. Click Sync Now. Once the sync has completed, click Export to test.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments