Xero Tracking Categories for Appendix 5B: The Setup That Makes Automation Possible

If you have been preparing your Appendix 5B manually each quarter, the problem almost certainly starts in Xero. Not in the report itself, and not in your understanding of what goes where. The problem is that your chart of accounts and tracking categories were never designed to produce a 5B. They were designed to tell you how much you spent on exploration last month.

Those are two different questions. The chart of accounts answers the first. A correctly configured Xero, with the right tracking categories, answers both.

With the June quarter 5B due on 31 July, this is the setup to get right before you close the quarter.

Why tracking categories, not the chart of accounts

The Appendix 5B classifies cash flows in two dimensions: by activity (operating vs. investing vs. financing) and by purpose (exploration, production, development, corporate). Your GL codes capture the nature of the expense. Tracking categories capture the context.

A payment to a drilling contractor, coded to 6100 Exploration Expenditure, tells Xero what you spent. It does not tell Xero which tenement the spend relates to, or whether it qualifies for capitalisation under AASB 6 (investing) or goes to the operating section as expensed E&E. Without that second dimension, every classification decision is made manually at quarter end by a human reading invoices.

Tracking categories are how you encode that second dimension at the point of transaction, not at the point of reporting.

Xero's constraint: two categories only

Xero allows a maximum of two active tracking categories, each with up to 100 options. For an ASX junior explorer, the design choice is straightforward.

Category 1: Tenement
One option per active tenement, plus one option for corporate or administration costs that are not tenement-specific. For example: E32/456, E63/1204, P63/891, Corporate.

Category 2: Activity Type
The options here map directly to the 5B sections. This is the category that drives automation.

Activity Type option	5B section	AASB 6 treatment
Exploration and evaluation	Section 2.1 (Investing)	Capitalise if entity's policy is to capitalise E&E
Development	Section 2.2 (Investing)	Capitalise
Production	Section 2.3 (Investing)	Capitalise
Property, plant and equipment	Section 2.4 (Investing)	Capitalise
Administration and corporate	Section 1.7 (Operating)	Operating
Staff costs	Section 1.1 (Operating)	Operating
Regulatory and compliance	Section 1.7 (Operating)	Operating

When both categories are applied to every transaction, a report filtered by Activity Type produces the raw numbers for each 5B section. The tenement dimension gives you the detail for the exploration expenditure schedule and any future JORC or disclosure obligations.

The AASB 6 decision point

The operating versus investing split in the 5B is driven primarily by your entity's accounting policy for exploration and evaluation expenditure under AASB 6. Most junior explorers adopt the area-of-interest method and capitalise E&E expenditure, which means exploration costs flow to Section 2.1 (investing outflows), not Section 1 (operating). Some entities expense E&E to the income statement, which reverses this classification.

This policy choice needs to be made once, documented in your accounting policies note, and then encoded into the Activity Type options your team applies to transactions. The tracking category setup is the mechanism; the accounting policy is the rule that governs it.

If different team members are applying Activity Type options inconsistently, your 5B will have classification errors regardless of how good the automation is. The tracking category setup only works when the tagging discipline is consistent at the point of entry.

The most common mistake

The most common configuration problem in ASX explorer Xero files is using tracking categories for internal cost centres or project phases rather than for tenement and activity classification. This makes sense for a mining services business reporting profitability by project. It does not work for a junior explorer preparing a 5B.

If your current Category 1 is something like "Department" with options like "Geology", "Management", "IR", you have cost-centre tracking, not 5B tracking. These two purposes are not compatible in Xero's two-category limit. Switching to 5B tracking requires rebuilding the category structure and re-tagging historical transactions if you want a clean quarter-by-quarter comparison.

What a 5B-ready Xero looks like

Before you can automate the 5B preparation, three things need to be in place in Xero:

1. Tracking Category 1 set to Tenement, with one option per active tenement and a Corporate option for non-tenement costs.
2. Tracking Category 2 set to Activity Type, with options that map directly to 5B sections as shown in the table above.
3. All transactions tagged with both categories at the point of entry, not retrospectively at quarter end. This includes bills entered via HubDoc or Dext, bank transactions, and any manual journal entries.

With these three elements in place, producing a 5B becomes a reporting exercise rather than a classification exercise. The hard decisions were made when the transactions were entered. Quarter end is just the output.

Without them, you are doing the classification work manually each quarter: reading 150 to 300 transactions, making a determination on each, building a workpaper to support the section totals, and then entering the numbers into the ASX lodgement form. That is the process most junior explorer finance teams are still running today.

Setting up for the June quarter

The June quarter ends 30 June and the 5B is due 31 July. That gives you roughly six weeks from now. If your Xero is not currently set up for 5B tracking, the options are:

1. Configure now and tag April to June manually. If you have 50 to 100 transactions in the quarter, this is a one-day exercise. The benefit is a fully automated September quarter.
2. Prepare June quarter manually, configure for September. Lower effort now, but you carry the manual burden for one more quarter.

The right answer depends on transaction volume and how much capacity your finance team has in July. For explorers with fewer than 200 transactions per quarter, option one is almost always worth it.

If you want a second opinion on your current Xero setup before committing to a reconfiguration, get in touch. We work with ASX and NSX junior explorers on exactly this kind of Xero configuration and can usually assess a file within a day.

---

For a detailed walkthrough of what each 5B section requires and how the operating versus investing split works in practice, see our earlier guide: Preparing the June Quarter Appendix 5B: A Practical Guide for ASX/NSX Junior Explorers.