Setup
Control File Maintenance
Financial Integration: External
Foreign Currency Enabled: Tick if foreign currency is enabled in Xero
Note: Xero will import all transaction amounts as local currency. If the amount is in foreign currency, the currency will have to be manually changed on the imported draft transaction within Xero.
Control Parameter Maintenance
Confirm that 'Use Legacy Disbursements Export' is No.
GST Types Maintenance
The tax codes in Xero use a name only, rather than a name and description. Therefore all the Workbench export files use the GST Type Description, rather than GST Type Code. If Xero can't match the tax description when importing a file, the tax code is left blank and must be completed before being able to approve the transaction.
Below is a list of the standard tax codes used in Xero.
Description |
Tax Rate |
BAS Excluded |
0.00% |
GST on Expenses |
10.00% |
GST on Income |
10.00% |
GST on Capital |
10.00% |
GST Free Capital |
0.00% |
GST Free Expenses |
0.00% |
GST Free Exports |
0.00% |
GST Free Income |
0.00% |
GST on Imports |
0.00% |
Input Taxed |
0.00% |
Tracking Options
Xero allows the use 2 user definable tracking categories. The use of these is optional. Each tracking category is given a name and a list of valid options. The options for each category must be mapped from Workbench using a field out of the Jobs table or Description from the JobTypes table.
Where tracking options are being used the following control parameters must be completed, to determine the mapping.
Parameter Name |
Valid Value |
XERO TrackingName1 |
Must be exactly the same as the Tracking Name of Category 1 in XERO |
XERO TrackingName2 |
Must be exactly the same as the Tracking Name of Category 2 in XERO |
XERO TrackingOption1 |
Must be a valid field name on the Jobs or JobTypes Table. Must Prefix Jobs fields with j. and JobTypes fields with t. |
XERO TrackingOption2 |
Must be a valid field name on the Jobs or JobTypes Table. Must Prefix Jobs fields with j. and JobTypes fields with t. |
Where the tracking name or tracking option provided can't be matched the field is left blank and must be selected manually in Xero.