From XU Magazine, 
Online News

Data Dimensions: How to get 6 additional Tracking Categories

November 28, 2024

This article originated from the Xero blog. The XU Hub is an independent news and media platform - for Xero users, by Xero users. Any content, imagery and associated links below are directly from Xero and not produced by the XU Hub.
You can find the original post here:
https://www.translucent.io/blog/data-dimensions

Tracking Categories are a key feature of Xero and very powerful. They enable the accounting data to be segmented into branches, products, costs centres, geographies or any other segmentation required. They are a key part of a good data model.

Xero enables 4 Tracking Categories but only 2 can be active at any one time. This means that a business effectively has 2 Tracking Categories with each limited to 100 Options. For some businesses this isn’t enough…

How many Tracking Categories or Data Dimensions do you need?

The limited number of Tracking Categories is the #1 reason for leaving Xero cited by businesses that have migrated to an ERP. These businesses needed reporting in more dimensions. For each business this need is specific:  

Example 1: The business currently uses Tracking Categories to report by #1 ‘branch’ and #2 ‘customer type’. When launching a new product line they need a third Tracking Category / Data Dimension - #3 ‘product’.

Example 2: The business currently uses Tracking Categories to report by #1 ‘cost centre’ and #2 ‘product type’. The business has won a grant but now needs to track the data by ‘project’ to ensure they meet the grant’s rules so they need a third Tracking Category / Data Dimension - #3 ‘project’.

The need for additional Tracking Categories and Data Dimensions is particularly acute in multi-entity businesses where there is often a need for segmenting the data for intra-company needs as well as group needs

6 more Tracking Categories / Data Dimensions!

We’ve built Data Dimensions to solve this problem. Data Dimensions gives you 6 additional Tracking Categories across your group.

Just like with Tracking Categories you can use them however you wish and personalise as you require. Each Data Dimension comes with up to 250 Options.

This allows you to do much more with your data!

Your group can now segment your data by ‘Branch’ and ‘Cost Centre’ and ‘Product’ and ‘Project’ and ‘Geo’ and ‘Customer Type’ and whatever else you need!

How to use Data Dimensions

Create your new Data Dimensions and Options

Data Dimensions allows you to quickly and easily create and edit your new Data Dimensions and Options:

Create rules to automatically allocate transactions to your Options

Data Dimensions has a sophisticated rules engine that allows you to allocate past, present and future transactions by Supplier, Customer, Entity, Account, etc.:

See how your Data Dimensions are being applied across your group

Data Dimensions enables you to review how your Data Dimensions are used by volume, by value and by percentage:

Use your Data Dimensions in Consolidation, Intercompany and other workflows

Unfortunately there isn’t a way of sending the Data Dimensions into Xero in a way that would appear in Xero’s reporting but you can use your data across the Apps and Workflows in Translucent:

Using Data Dimensions in Single-Entity Businesses

Although it was designed for multi-entity businesses, Data Dimensions can be used for single entity business and works in exactly the same way: you get 6 additional Data Dimensions / Tracking Categories and each one comes with up to 250 Options.

Why leave it there?

To find out more about Translucent

Straight to your inbox

Subscribe to our newsletter for updates as they happen
We hate spam too. We NEVER sell our mailing list.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.