This article provides information about the Equinox Xero integration which enables any invoices generated within Equinox to be easily transferred to a Xero account.
When this functionality is enabled you will have a new option in the Finance tab called ‘Export to Xero’.
Here, you can periodically select any invoices from a list within Equinox and click a button which will send them over to your Xero account as Draft invoices.
You can also choose to send a copy of the Equinox invoice whilst exporting which will then attach as a document in Xero.
Any invoices that have been sent to Equinox will be updated to show they are ‘Transferred’ to prevent them from being exported to Xero more than once.
Before this functionality is enabled, some configuration is required to ensure the information is transferred to your Xero account correctly.
1. Default Charge Mapping
To ensure the charge information is transferred correctly to Xero your Equinox charge categories (Time, Fixed, Cost) will need to be mapped to your Xero account codes. This is something our support team will assist with during the initial setup and can be amended at a later date if necessary.
The default mapping for the Equinox charge categories is as follows:
Equinox Charge Category | Xero Account Code |
Time | 200 |
Fixed | 201 |
Cost | 202 |
Note: Equinox charge categories and sub-categories can only be mapped to one Xero account code.
It is possible for charges to be mapped to a Xero account code based on the Equinox charge sub-category as well. The charge sub-category list can be customised to add extra charge options. Please contact our support team who can add the extra sub-category options for you.
Mapping charges by sub-category is often used where certain types of charges should be mapped to more specific account codes in Xero OR if or if you need to map charge to an account depending on the charge user.
2. Tax Type Mapping
When charges are exported from Equinox to Xero the charges will be mapped to Xero Tax Types depending on the country of the billing contact in Equinox. This determines the amount of tax calculated in Xero and how the transaction is reported on the Tax return.
Typical Mapping for a GB System
Billing Contact Country | Xero Tax Type | Tax Rate and Name |
GB (With VAT) | OUTPUT2 | 20% (VAT on Income) |
GB (Without VAT) | ZERORATEDOUTPUT | 0% (Zero Rated Income) |
EU | ECZROUTPUTSERVICES | 0% (Zero Rated EC Services) |
Rest Of World | ZERORATEDOUTPUT | 0% (Zero Rated Income) |
More information about UK Tax Types is available here: https://central.xero.com/s/article/Default-tax-rates-UK
Typical Mapping for an Australian System
Billing Contact Country | Xero Tax Type | Tax Rate and Name |
AU (With GST) | OUTPUT | 10% (GST on Income) |
AU (Without GST) | EXEMPTOUTPUT | 0% (GST Free Income) |
EU | NONE | 0% (Tax Exempt) |
Rest Of World | NONE | 0% (Tax Exempt) |
More information about Australian Tax Types is available here: https://central.xero.com/s/article/Default-tax-rates-AU
The full list of Xero Tax Codes can be found here: https://developer.xero.com/documentation/api/types#TaxTypes
3. Invoice Due Dates
To ensure the Invoice Due Dates are recorded correctly when exported to Xero, you will need to record your client’s Payment Terms in the Address Book. To set payment terms:
- Go to the Address Book
- Search and click on the client Organisation
- Go to the Finance Settings
- In the ‘Tax Date +’ field enter the number of days the client has to pay following the invoice issue date
Our Support team are happy to help with bulk updates to set Payment Terms.
4. Additional Preferences
There are some additional preferences that can be enabled when exporting charges to Xero.
Please let our Support team know if you want to use any of these options.
Option | Description |
Add the Case Code to the Reference Field in Xero | When charges are exported to Xero, the Reference field in Xero will be populated with your Equinox Case Code instead of the billing reference when exporting to Xero. |
Add the Case Code as a pre-fix to the line item description in Xero | When charges are exported to Xero, the Equinox Case Code will be pre-fixed to the charge description in Xero. |