Countdown to 'An Introduction to Xenon Connect' Webinar: - Register For Next Webinar

Unexpected Account Used

Overview

The Unexpected Account Used bookkeeping data check feature identifies transactions in Xero that have been coded to an account that is not the default account for the particular contact.

Transactions checked include:

  • Customer Invoice Line Items (checked against the default sales account)
  • Supplier Bill Line Items (checked against the default purchases account)
  • Money In (checked against the default sales account)
  • Money Out (checked against the default purchases account)

Note that transactions are only marked as unexpected where the applicable default account has been specified for the contact (either directly in Xero, or by using the Contact Defaults bookkeeping check feature in Xenon Connect).

Therefore, if the contact’s default account is blank, then transactions will not show up as unexpected for that contact.

Of course, some contacts will have transactions that have been legitimately coded to an account code other than the default account for the contact. The purpose of the check is to verify that any differences are in fact correct.

The Unexpected Account Used data check feature is different to that of the Multi-Account Suppliers data check. The Multi-Account Suppliers data check compares the account used within transactions against other transactions of a particular contact, whereas the Unexpected Account Used data check compares each transaction’s account code against the default account code set up for the contact (if available).

blank

Details provided for each transaction include:

  • Type (e.g. invoice, bill, money in or money out)
  • Contact name
  • Date of transaction
  • Details/description
  • Net Amount of transaction
  • Account used
  • “Change to” value (Default account for contact, i.e. the expected account)

Changing the transaction’s account

If you decide that the account currently given to the transaction in Xero is inappropriate, you can quickly and easily change it using one of the following methods:

  1. Select an account in the “Change to” column. The top value shown is the default account set up for the contact. The bottom drop-down menu allows you to pick any account, if appropriate. Then, click the “Save Changes” button.
  2. If the transaction is reconciled (bank item) or has a payment or credit note allocated to it (invoice or bill) within Xero, then the account value cannot currently be updated directly from Xenon Connect (although we hope to allow this if Xero API constraints are updated in the future). Therefore, currently, such transactions must be updated using the “Edit in Xero” button.

View transaction in Xero

For each unexpected account used item found, you are able to click the View button after which you will be taken directly to the applicable transaction within your Xero account. This will allow you, for example, to investigate the item further.

Dismiss Item

If you decide that a particular transaction already has the correct account code used, then you can click the “Dismiss” button to hide the item and prevent that transaction from appearing in the list again.

Show Dismissed Items

You can quickly include all previously dismissed transactions, by enabling the “Show dismissed items” toggle.

This allows you to recheck and edit any accounts that have previously been dismissed in error.

Bulk Process Options

The following bulk actions can be taken by using the check boxes and Bulk Process Options drop down menu:

  • Multiple transactions can be dismissed in bulk