=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!