A tracking category in Xero is a reporting dimension you attach to transaction lines so you can slice the profit and loss by something other than account. Sales Channel is a category. Amazon, Shopify, Walmart, eBay, and TikTok Shop are its options. Once the option is on the line, Xero can produce a profit and loss column for each one from the same set of accounts.
Categories are not accounts. They do not change the double entry. They add a label that reports can group by, and that label is the difference between a profit and loss you can act on and one you can only file.
Xero's tracking documentation sets two numbers you should memorize before designing anything:
Two is a hard planning constraint. You get channel and one other thing. Sellers routinely want channel, brand, and warehouse, and Xero will give them two of the three.
One hundred options is generous for a channel list and tight for anything resembling a project or customer list. If you are contemplating a category with 400 options, tracking is the wrong tool and you need the dimension to live upstream in whatever system produces the transactions.
A tracking option attaches at the line level, not the transaction level, which is more useful than it sounds. You can apply it to:
Line level means a single bill can be split across options. That is how shared costs get distributed, and it is covered in the worked example below.
One option per category per line. You cannot tag a line as both Amazon and Shopify. If a cost genuinely belongs to both, it needs to be split into two lines.
Accounts answer what kind of money this is. Tracking answers where it happened. Sellers who invert this end up with a category called "Fees" containing options for referral, fulfillment, and storage, which produces a report nobody can reconcile and destroys the natural grouping of the profit and loss.
Tracking in Xero is built around profit and loss reporting. Do not plan on producing a full tracked balance sheet by channel. If you need inventory value by warehouse, that lives in the inventory system, not in a Xero tracking category.
A tracking option on a bill line tells you which channel bore a cost. It tells you nothing about which units bore it. Allocating landed cost to specific inventory is a different operation entirely, performed against quantities and unit values, and no amount of tracking category discipline substitutes for it.
For a multichannel seller, the first slot is almost always Sales Channel. The second depends on the question you ask most often.
Use Brand or Product Line if you sell more than one brand and make buying decisions at the brand level. This is the most common second choice.
Use Warehouse or Fulfillment Method if you run your own fulfillment alongside marketplace fulfillment and want to see the cost difference in the profit and loss.
Use Customer Type if you have a wholesale or B2B side, because wholesale margin and direct to consumer margin are different businesses wearing the same brand.
Leave the second slot empty rather than filling it with something you will not report on. An unused category still shows up on every entry screen and still invites inconsistent tagging.
Your 3PL invoices 18,400.00 for the month, covering pick, pack, and handling across every channel. The invoice does not break out by channel. Your shipment report does.
Units shipped in the month:
Enter the bill in Xero as four lines against the same expense account, each tagged with a Sales Channel option:
The four lines total 18,400.00 exactly. Your Shopify column now carries its share of fulfillment labor, and the Shopify gross margin you read at month end includes a cost most sellers never allocate.
Pick a driver and stay with it. Units shipped works for pick and pack. Cubic volume works better for storage. Order count works for customer service. Changing the driver mid year makes your channel trend meaningless, so choose once and write it down.
Two do most of the work.
Profit and Loss with tracking columns. Select the category and Xero produces a column per option plus a total. This is the report the whole exercise exists for.
Tracking Summary. A compact view of activity by option, useful for spotting an option that is collecting transactions it should not be.
Budget by tracking option is also available, which lets you set a target for a channel and read variance against it. Most sellers skip this and should not.
Untagged transactions. Xero does not force a tracking option, so any line entered without one falls into an unassigned bucket. A profit and loss where the unassigned column carries 30 percent of costs is not a channel report. Review the unassigned column every month and drive it toward zero.
Tagging revenue but not cost. Marketplace data usually arrives with channel attached, so revenue tags itself. Overheads, software, contract labor, and freight get entered by a person, and that person forgets. The result is a report showing high margin on every channel and a large untagged pile of cost that makes the totals correct and the columns fiction.
Creating options for things that are not channels. "Amazon FBA" and "Amazon FBM" as separate options seems reasonable until you want total Amazon and have to add two columns by hand. Keep the category clean and put fulfillment method in the second category if you need it.
Deleting options. Archive instead. Historical transactions keep the archived option, so your prior year reports still make sense.
Review the option list quarterly. Archive channels you have exited. Confirm the unassigned column is small. Spot check ten bills to see whether the person entering them is tagging consistently, and fix the process rather than the transactions if they are not.
Tracking categories are cheap to set up and expensive to retrofit. Every month you run without them is a month you cannot slice later without re coding history, and nobody re codes history.
Tracking categories are one of three pieces that make a Xero file readable for a multichannel seller. The other two are a chart of accounts that separates cost types properly, covered in the Xero chart of accounts guide, and cost of goods sold computed at the SKU level so the margin in each column is real. See how the channel data reaches Xero on the integration page, what the resulting reports look like on the profit reporting page, and the wider picture in the ecommerce accounting overview.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
