Author- Sonia Dhillon, CPA, MBA
As a business leader, you know that truly understanding your finances means more than just a total profit number. You need to know which business segments are winning or which need attention.
While Xero’s standard chart of accounts is powerful, sometimes you need an extra layer of detail to truly slice and dice your financial data. That’s where Xero Tracking Categories come in!
For DhillonMarty CPA Advisory clients, setting up Xero Tracking Categories correctly is a game-changer for detailed reporting and financial analysis. Here’s a simple guide to getting them set up and working for your business segments.
What Are Xero Tracking Categories? (The Power of Tracking Codes)
Xero Tracking Categories are customizable labels (often called Tracking Codes by users) you can apply to transactions. Think of them like organizational tags that go beyond the basic account codes (like Sales or Rent). They allow you to run a Segmented P&L report on specific business segments.
The Power of Tracking:
- See Performance by Product Type: How profitable is your clothing business versus your jewellery accessory line?
- Track Regional Performance: Which sales territory or operational hub is generating the best returns (Multi-location Reporting)?
- Monitor Specific Engagements/Jobs: Track income and expenses for a major client project or compliance engagement.
How It Works: Categories, Options, and Limits
Xero’s tracking system replaces traditional methods like department codes or cost centers with a highly flexible system for analyzing revenue and expenses.
| Component | Definition | Xero Limits & Recommendations |
| Tracking Category | The high-level grouping (e.g., Location, Department, Project). | Maximum of four tracking categories in total, but only two can be active at any time. |
| Tracking Option | The specific sub-label or value within a category (e.g., Shop A, Online Sales). | Each category needs at least one option. We recommend no more than 100 tracking options per category to ensure reports load quickly and remain manageable. |
The limit of two active categories forces you to focus on the two most crucial ways you need to segment your data (e.g., Location and Product Line).
Example Workflow: Tracking Profitability by Shop
To illustrate, consider a retail business with seven shops. The owner wants to track the performance of each.
- Goal: Track sales and costs for seven different shops.
- Strategy: Use one of the two active slots for Location tracking.
- Setup: Set the Category Name as Location, and add seven specific Tracking Options (one for each shop) underneath.
Step-by-Step Setup in Xero
- In the Accounting menu, select Accounting settings.
- Click Tracking categories.
- Click Add Tracking Category.
- Enter the Category Name: Location.
- Under Category options, enter each shop location (e.g., Downtown, North Side, Online Warehouse).
- Click Save.
Need help defining the right business segments to track? Contact DhillonMarty CPA Advisory.
Using Xero Tracking Codes in Transactions
Once your categories and options are saved, Xero automatically adds a new column or field to your transaction screens.
When entering a Bill, Invoice, Expense Claim, or Manual Journal, you will now see fields for your tracking categories. Simply select the appropriate Tracking Option from the drop-down menu (e.g., “Downtown”) for each line item.
Efficiency Tip: Using Tracking Categories cleans up your Chart of Accounts. Instead of creating redundant accounts (e.g., “Rent – Downtown,” “Rent – North Side”), you use a single “Rent” account and apply the relevant Location option, making data entry and reconciliation faster.
Reporting and Analysis: For a Business Segment
This is where the power of tracking categories is realized. Consistency in applying tracking options allows your reports to become dynamic and insightful decision-making tools.
- Profit and Loss (P&L): When running this report, you can choose to Filter or Compare your results By Tracking Category. You can see the revenue, cost, and profit for only your ‘Online Warehouse’ or perform a side-by-side comparison of all seven shops.
- Balance Sheet: You can filter your Balance Sheet to analyze assets and liabilities tied to a specific project or location.
- Business Intelligence: Xero Tracking Categories and Options are essential for moving beyond simple bookkeeping to accurate service line profitability or multi-location reporting. They empower you to identify which areas of your firm are thriving and which may need attention.
Partner with DhillonMarty CPA Advisory
Do you need help structuring your Xero data for better reporting? As your CPA Advisory, we specialize in customizing Xero to meet the unique reporting needs of your operations, turning raw data into actionable strategic insight.
Ready to gain better control over your business’s profitability with better Xero reporting? Let’s schedule a time to review your current structure and map out the ideal Tracking Categories and Tracking Options for maximum clarity and strategic guidance!