Xero Tracking Categories: Track Profitability by Department

Xero Tracking Categories: Analyse Profitability by Segment

As your business grows, knowing your overall profit is not enough. You need to know which departments, locations, or projects are profitable and which are dragging you down. Xero tracking categories give you this visibility without needing separate accounting entities.

What Are Tracking Categories?

Tracking categories are tags you can apply to transactions in Xero to segment your financial data. They do not change your chart of accounts or affect your overall financial statements - they add an additional dimension of analysis.

Xero allows up to two tracking categories, each with multiple options. Common uses include:

• Department: Sales, Marketing, Operations, Admin
• Location: Sydney, Melbourne, Brisbane, Perth
• Project: Project Alpha, Project Beta, Client ABC
• Service line: Consulting, Training, Support

Setting Up Tracking Categories

Step 1: Navigate to Settings

Go to Accounting then Advanced then Tracking Categories.

Step 2: Create Your Categories

Click "Add Tracking Category" and give it a name (e.g., "Department"). Then add the options within that category (e.g., Sales, Marketing, Operations).

Step 3: Decide on Required vs Optional

You can make tracking categories required, which means users must assign a tracking option to every transaction. This ensures complete data but can slow down data entry. For most businesses, making it optional is more practical - you can always go back and tag transactions later.

Using Tracking Categories

On Transactions

When you categorise a transaction during reconciliation, you will see dropdown fields for your tracking categories. Select the appropriate option for each transaction.

For example, if you are paying a marketing agency invoice, you might assign it to the "Marketing" department.

On Invoices and Bills

When creating invoices or entering bills, each line item can be assigned to a tracking category. This is especially useful for invoices that cover multiple departments or projects.

On Manual Journals

Tracking categories can also be applied to manual journal entries, ensuring your adjustments are properly segmented.

Reporting with Tracking Categories

The real power of tracking categories comes through in reporting.

Profit and Loss by Tracking Category

Navigate to Accounting then Reports then Profit and Loss. Click the "Compare" option and select your tracking category. This generates a P&L broken down by each option.

For example, a P&L by department might show:

| | Sales | Marketing | Operations | Admin | Total |

| Revenue | $150,000 | $0 | $0 | $0 | $150,000 |

| Expenses | $45,000 | $30,000 | $50,000 | $25,000 | $150,000 |

This immediately tells you that your business is breaking even overall, but you can see exactly where costs are concentrated.

Budget by Tracking Category

You can create budgets for each tracking category option, allowing you to track actual versus budget performance by department, location, or project.

Balance Sheet by Tracking Category

While less commonly used, you can also view balance sheet items by tracking category if you assign assets and liabilities to specific segments.

Practical Examples

Multi-Location Business

A cafe chain with three locations uses tracking categories to compare profitability by location:

• Category: Location
• Options: CBD, Suburbs, Airport

Each transaction is tagged with the location it relates to. Monthly reports show which locations are profitable and which need attention.

Professional Services Firm

A consulting firm tracks profitability by service line:

• Category: Service Line
• Options: Strategy, Technology, Training, Managed Services

This reveals that strategy consulting generates the highest margins while managed services is barely breaking even - insight that drives resource allocation decisions.

Construction Company

A builder tracks profitability by project:

• Category: Project
• Options: Smith Residence, Jones Office, Council Library

Job costing reports show which projects are on budget and which are overrunning, allowing mid-project adjustments.

Best Practices

Choose Categories That Drive Decisions

Only create tracking categories for segments where the data will actually influence decisions. If knowing profitability by department will not change anything you do, it is not worth the effort of tagging every transaction.

Be Consistent

The value of tracking categories depends on consistent application. If some transactions are tagged and others are not, your segment reports will be incomplete and misleading.

Use Automation

Set default tracking categories on contacts, bank rules, and recurring transactions to minimise manual tagging. If all invoices from a particular supplier relate to one department, set the default on their contact record.

AI tools like SortBooks can automatically assign tracking categories based on transaction context, ensuring consistent tagging without manual effort.

Limit Options

Keep the number of options within each category manageable. Five to ten options is usually sufficient. Too many options make tagging slow and reporting cluttered.

Review Quarterly

Use tracking category reports in your quarterly business reviews. Compare segment performance over time, identify trends, and make strategic decisions based on actual data rather than assumptions.

Limitations

• Xero limits you to two tracking categories. If you need more dimensions, consider third-party tools like WorkflowMax for project tracking or dedicated business intelligence tools.
• Not all transaction types support tracking categories (e.g., some payroll transactions).
• Tracking categories cannot be applied retrospectively in bulk - though third-party tools can help with bulk updates.

Tracking categories are a simple feature that delivers significant strategic insight. For any business with multiple departments, locations, or projects, they are well worth the small effort of setting up and maintaining.