BI4Cloud + Xero : Tracking Category Hierarchy

Using Xero Tracking Categories is a great way to capture divisions or segments in a business while keeping a simple Chart of Accounts. Tracking Categories allow you to report on sales and the profitability of each division and not just the total business.

The challenge however is how to then report efficiently by Tracking Category. Xero allows up to 100 Tracking Options to be created in each of the two Tracking Categories.  The Tracking Options are just a long list of names with no way to group similar Options together.

BI4Cloud solves this by automatically creating a Tracking Category hierarchy for Xero.

Levels are determined  by analysing the Tracking Option names for  ' - ' or ":" separator in the name and these treat the Left Side of the separator as the parent of the Right side. 

Up to 4 levels of hierarchy are supported.

Example 1 - Tracking Category called Venue
  Northern - Boston
  Northern - Scranton

Become Levels -

Level 1                              Northern
                                           /          \
Level2                     Boston        Scranton


Example 2 - Tracking Category called Events

Classic - King Lear

Classic - Swan Lake

Classic - Fundraising - Event 1

Classic - Fundraising - Event 2

Becomes -

Level 1                                             Classic
                                                 /             |               \
Level 2                  Fundraising       King Lear      Swan Lake
                                /        \
Level3        Event 1      Event 2

Reporting in BI4Cloud, the Tracking Category and the Levels appear as they are named in Xero. 

Simply choose this as a dimension to appear in reports or to Filter or Group any data by.


Xero_TC_Levels.png

Profit & Loss - Pivot by Event as Columns

Displays each individual Tracking Option as a column across the page. With a large number of Tracking Options this can quickly become a challenge to report on.

P_L_by_TC.png

 

Profit & Loss - Pivot by Event Level 1 as Columns

Displays each Event Level 1 as a column across the page. This groups together data for all of the individual Events that appear together under each Level based on the name e.g. all of the Classic events group together.

P_L_by_TC_Level_1.png

Profit & Loss - Filter for Classic and Pivot by Event Level 2 as Columns

By Filtering for only where Event Level 1 = Classic and pivoting on the Event Level 2 as a column across the page this groups together all of the Fundraising Events ( Level 3) together. 

Classic_-_by_Level_2.png

See also Xero : Tracking Category for Reporting and Budgets

 

Sign up for your free 14 day trial at Bi4Cloud.com and try it with your Xero company today.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk