Using Xero tracking categories on invoices

If you use tracking categories in Xero, you can include those on your Projectworks invoices and have them flow through to Xero.

Tracking categories can be set up in Xero and be used as a way to categorise (or tag) invoices and expenses. They allow another level of reporting such as identifying which geographic region or division the revenue or expenses are reported against.

You are able to allow the use of tracking categories on invoices within Projectworks, letting you do the categorising at the point of creating your invoice.

How to activate tracking categories

Once you have successfully connected Projectworks and Xero you can simply activate the use of tracking categories for the organisations that require it.

You do this in the Settings > Integration > Accounting > Invoices

image-20230110-013442

2023-01-10_15-44-53 (1)

Maintaining Category Mappings

Once enabled, you can see the tracking category names listed as part of your integration mappings. Changes to the tracking categories in Xero aren't automatically pulled through to Projectworks. If you add a new option in Xero you need to go back into Settings > Integration > Accounting and click “Refresh Tracking categories”. Note this update will also apply to expenses if you have tracking categories enabled for expenses.

2023-01-10_15-47-03 (1)

Setting tracking categories on projects

Once tracking categories have been activated you are able to set default selections for each project on the settings > invoicing screen.

Xero - tracking categories defaults

Setting tracking categories on invoices

When raising an invoice for the project the default tracking categories set for the project will be used for each invoice line.

You are also able to change the tracking category on invoice lines as required.

Xero - tracking categories invoice defaults

Tracking categories are optional and become locked (non-editable) in the following state:

  • Manager Approved

  • Finance Approved

The selected tracking categories are included as part of the invoice export process removing the need to manually set these within Xero.