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