Configuring the Accounts Interface to Xero

AbtracOnLine links to Xero directly via the Xero API.

You can set up the link between Abtrac and Xero in less than 10 minutes following the instructions below, or if you call the support team we’d be happy to help you get underway.

Read this article for an overview on how the accounts link works

before you start to configure your accounts link with Xero.

Once you are ready to set up the integration: From Administration > Settings > Invoice Settings > choose Accounting Interface Settings.

Create or Edit Accounts Interface

Create or Edit Accounts Interface

Then choose the option for Xero.

2073_accountinginterfacesettings2_xero

To configure your integration you’ll need to set some more specific preferences for Xero.

2075_interfacesettings

Organisation

2075_organisationdetails

Your Organisation name will need to be specified. This organisation name and your Xero account login are used to create the link between AbtracOnLine and your accounts.

2075_xero-signin

Xero Interface Preferences

2075_xerointerfacesettings

Delivery Status

Choose the delivery status of invoices uploaded: Draft, Submitted, or Authorised.

Adding Clients and Projects

You can choose to add clients entered in Abtrac to Xero at the same time as invoices are uploaded.

Matching your Abtrac Client invoices to your Xero Contacts.

Clients can be matched using:

  • Abtrac’s Client Name to Xero Customer Name*
  • Abtrac’s Name on Invoice to Xero Customer Name*
  • Abtrac Client ID to Xero Contact Number

*When choosing either name option you will need to be aware that any minor misspellings/spelling changes on client names (or names on invoices) could result in duplicate records in Xero.

Tax Codes

2075_xero_managetaxcodes

You can enter as many tax codes and associated tax rates as required, however only two codes will apply to invoices by default (those for revenue and those for tax free revenue).

Any additional tax codes entered can be selected for individual invoices, or individual invoice lines from the tax code drop down. In some instances you may need to change the tax settings for individual invoices from edit invoice details first.

2075_includetax2075_tax-codes-on-invoices

Account Codes & Invoice Settings

For the accounts upload to function you must link an invoice setting with an accounts interface setting. An invoice setting may only be linked to one accounts interface setting.

2075_manage-account-codes

You can enter as many accounts codes as required, however only one code will apply to invoices by default.

Any additional accounts codes entered can be selected for individual invoices, or individual invoice lines from the GL code drop down. You can apply GL codes to all invoice lines by choosing from edit invoice details, or on a line by line basis as required.

2075_change-gl-codes

2075_account-codes-on-invoices

Once your accounts integration is set up this article on using the Abtrac-Accounts link is also a useful read.

Notes on the Xero integration

  • Xero does not allow negative value invoices to be uploaded. So any Credit Notes/Adjustment Notes from Abtrac you will need to enter into Xero manually.
  • As Xero doesn’t manage or report on Jobs(Projects) you cannot import project information relating to your invoices.

Abtrac KB# 2075