=XTRACKR extends our add-in for Xero, by allowing you to specify a range of Xero GL account codes, tracking category, and tracking option. The syntax looks like this

=XTRACKR (Begin Account Code, Ending Account Code, Tracking Category,Tracking Option,Start Date,End Date)

Some “use cases” of =XTRACKR include

  • building a matrix P&L with departments or stores in one column, and varying financial periods in the other columns.
  • percentage comparisons from one Tracking Option to another.

Here’s a two minute video that walks you through the new function.

Give it a try, and create some beautiful, financial art!

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed