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.