Xero Export & Sync Errors

This article lists common error messages which may be returned when exporting to Xero. You can view these errors on the Accounting Sync History Page via Company Settings > Accounting Sync History. 

Note: Bank Debit errors will not indicate the specific transaction within the batch that is causing the error.\

Export and Sync Errors

• Error Code:

  Token does not match an expected OAuth token

  Reason:

  The login token has expired or is invalid.

  Solution:

  Please re-connect Xero and Spend to update the Token. 

  • Login to Spend and navigate to Account & Settings
  • Select the Accounting Sync screen 
  • On the top right side click Reconnect to re-authenticate
  • Enter your Xero credentials

• Error Code:

  The Total for this document must be greater than zero

  Reason:

  Xero made changes to their system and Spend was unable to sync negative value/refunds from a corporate card.

  Solution:

  Spend updated the settings to meet the requirements for Xero.

• Error Code:

  Account code XXX is not a valid code for this document

  Reason:

  This error message is because the 'Show in expense claims' box for the category has not been ticked in your Chart of Accounts in Xero.

  Solution: 

  • Please login to Xero and go into your 'Settings'
  • Select 'Chart of Accounts'. 
  • Click into each category and then tick 'Show in expense claims' box.
  • Reload your categories afterward

• Error Code:

  Refresh Token is out of date and must be manually reconnected

  Reason:

  Refresh tokens expire after 30 days if not used. Your app will need to a manual refresh at least every 30 days to keep the offline connection alive.

  Solution:

  Please re-connect Xero and Spend to update the Token. 

  • Login to Spend and navigate to Account & Settings
  • Select the Accounting Sync screen 
  • On the top right side click Reconnect to re-authenticate
  • Enter your Xero credentials

• Error Code:

  syncing_card_txes_in_multi_gl_account_mode_requires_card_to_be_mapped_to_GL_account

  Reason:

  One or more corporate cards have not yet been mapped to a GL account in your accounting software. If a card is not mapped, transactions from that card cannot be synced by Emburse Spend to your accounting software.

  Solution: 

  1. Log in to Emburse Spend and select the Gear in the upper right corner to access Company Settings.
  2. In the Company Settings menu, select Accounting Integration.
  3. Scroll down to the list of corporate cards and look for those with blank drop-downs.
  4. Use the drop-downs to select the correct GL account for each unmapped card, then select Save.
  5. Scroll back up to the top right corner of the Accounting Integration screen and select Accounting Sync History.
  6. Filter the list by Corporate Card Expenses and Errors Only, then select Re-sync Record.