You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > moovs > Xero - using Tracking Categories in an IIF (tab delimited) moov
Xero - using Tracking Categories in an IIF (tab delimited) moov
print icon

This article describes how to use the CLASS and LOCATION fields in an IIF file to map to Tracking Categories in Xero.

 

Mapping the IIF CLASS Field

 

In this example, we will use a Xero Tracking Category called 'Benefit' that has the following Tracking Category options:

 

Retirement

Tax

 

In the IIF file below, we have the CLASS field set on rows 5 and 6 to these tracking category options:

 

 

Since the tracking category name is not provided in the IIF file, we will need to provide a field override to include this in the file imported to Xero.

 

To provide a field override, access the IIF moov definition and then edit the client in the moov configuration section:

 

Then click Next and locate the Action - Transform section and expand the Field Overrides section.  Click the ADD button, select the Cost Center 1 Name field from the Output Field dropdown and enter in the Tracking Category name in the Override value field.

 

 

This will place the tracking category of 'Benefit' into the correct field needed to map the tracking category in Xero.

 

To complete the configuration, scroll to the bottom of the page and click Next and then Save on the next page.

 

After the manual journal has been uploaded to Xero, we can see that the correct category options have been assigned to the 'Benefit' Tracking Category:

 

 

Mapping the IIF LOCATION Field

 

Say you want to use a second Xero Tracking Category for a transaction in a manual journal.  You can use the LOCATION field in the IIF file to map to the second Tracking Category option in Xero.

 

In this example, we will use a second Xero Tracking Category called 'Department' that has the following Tracking Category options:

 

Executive

Other

 

In the IIF file below, we have the LOCATION field set on row 5 and 6 to these Tracking Category options:

 

 

To provide a field override for the LOCATION field, Click the ADD button, select the Cost Center 2 Name field from the Output Field dropdown and enter in the Tracking Category name in the Override value field.

 

 

To complete the configuration, scroll to the bottom of the page and click Next and then Save on the next page.

 

After the manual journal has been uploaded to Xero, we can see that the correct category options have been assigned to the 'Department' Tracking Category:

 

 

scroll to top icon