If you’ve been using Xero for a while you’re probably familiar with their use of tracking categories to categorise transactions such as Invoices and Bills to suit your business needs and allow you to generate reports by tracking category. For example you might setup tracking categories for different areas of your business (e.g. departments, cost centres, or locations) so you can track their performance over time.
A typical Xero tracking category might be named Sales Regions and have the following tracking category options:
- West Coast
There are some limitations to tracking categories in Xero – a Xero organisation can have a maximum of two ACTIVE tracking categories and four tracking categories in total (ACTIVE and ARCHIVED). You can enter up to 100 category options for each category.
We’ve always had some basic support for tracking categories in the fmAccounting Link (Xero Edition) solution – you could download all your tracking categories from Xero at the click of a button and also add them to Invoices and Bills when uploading to Xero. Over the past 12 months we’ve had more and more customers request additional support for tracking categories, including the ability to manage tracking categories completely in FileMaker.
We’ve just released an update to the fmAccounting Link (Xero Edition) solution that includes full support for Xero Tracking Categories. You can now enter two tracking categories for the following items:
- Purchase Orders
Both tracking categories are also downloaded from Xero for each of the above items. We’ve also added the ability to do the following from the fmAccounting Link file:
- create a new tracking category and upload it to Xero (as well as update existing ones, e.g. change the name or status)
- add new tracking category options and upload them to Xero
- delete a tracking category from both FileMaker and Xero
- delete a tracking category option from both FileMaker and Xero
- download an individual tracking category, including all tracking category options
We currently support a single tracking category in our Timesheets module – we’re working on a few changes to Timesheets and tracking categories which will be included in the next update to fmAccounting Link (Xero Edition). Timesheets uses the Payroll API and you enable Timesheet tracking categories separately to the general tracking categories, but we expect them to work in a similar way to Invoices, Bills etc.