Xero Inventory: How to Set Up and Manage Tracked Items

What Xero Inventory Actually Does

Xero has two kinds of inventory items, and choosing between them is the decision that matters most. Get it wrong and you either lose visibility over your stock or you create a maintenance burden your business does not need.

Untracked items are effectively saved templates. You define a name, a code, a description, a sale price, and default account codes. When you add the item to an invoice or bill, Xero fills in those details for you. It does not count anything. It does not know how many you have. It is a typing shortcut with accounting defaults attached.

Tracked items maintain a real quantity and value. Xero records stock in when you enter a bill, records stock out when you raise an invoice, and posts the cost of goods sold automatically at the moment of sale. The remaining stock sits on your balance sheet as an inventory asset.

Most small businesses need untracked items. Tracked inventory is for businesses that hold physical stock they buy and resell, where knowing the quantity on hand and the true margin per product actually changes decisions.

When to Use Tracked Inventory

Use tracked items when all of the following are true:

• You buy physical goods and resell them without transforming them.
• You need to know how many units you hold at any moment.
• You want cost of goods sold posted automatically rather than estimated at year end.
• You are willing to keep the data accurate, which means recording every receipt, sale, adjustment, and write-off.

Use untracked items when any of these apply:

• You sell services, or time, or anything without a unit count.
• You manufacture or assemble, so raw materials become something else. Xero does not handle bills of materials, and forcing it to will not end well.
• Your stock turns over so fast, or is so low value, that counting it costs more than the insight is worth.
• You already run a dedicated inventory or point of sale system. In that case, let it own the stock data and push summary figures into Xero.

That last scenario is common and worth stating plainly. If you run Cin7, Unleashed, DEAR, Shopify, or a proper retail point of sale, that system should be the source of truth for inventory. Duplicating tracked items in Xero creates two sets of numbers that will disagree, and you will spend your evenings working out which one lied.

Setting Up Tracked Items

Go to Business, then Products and services, then New item. Tick "I track this item" and Xero asks for three account codes.

Inventory asset account. A current asset account on your balance sheet where the value of unsold stock sits. Xero creates one called Inventory by default.

Cost of goods sold account. Where the cost of the item posts when you sell it. This is what drives your gross margin.

Sales account. Where the revenue posts.

Set your purchase and sale prices, and confirm the tax rates on both sides. A wrong tax rate on an inventory item repeats itself across every transaction until someone notices, which is usually at BAS time.

Entering Opening Stock

If you already hold stock when you start tracking, do not enter it by raising fake bills. Use Business, then Products and services, then Import, and load a CSV with quantity and total value per item. Date the opening balance at the start of the period so it does not distort a month you have already reported on.

Value opening stock at what you actually paid, not at what you hope to sell it for. Overstating opening inventory inflates your balance sheet and then quietly destroys your gross margin the moment you sell any of it.

How Xero Calculates Cost of Goods Sold

Xero uses the average cost method. Every time you receive stock, Xero recalculates the average unit cost across everything you hold.

Buy 100 units at $10 and your average cost is $10. Buy another 100 at $14 and your average across 200 units becomes $12. Sell one unit and Xero posts $12 to cost of goods sold, regardless of which physical unit left the shelf.

This matters in two ways. First, Xero does not offer FIFO or specific identification. If your accountant expects FIFO, discuss it before you commit, because the difference in a rising cost environment is real. Second, average cost only stays honest if you enter purchases in the order they happened. Entering a bill from six weeks ago today will recalculate the average from that point forward, and every sale in between was costed at the old figure.

Stocktakes and Adjustments

Xero's tracked quantity is a running calculation, not a physical count. Breakage, theft, samples, and miscounts all cause drift. Count your stock at least annually, and quarterly if it is valuable or fragile.

To correct a variance, use an inventory adjustment through a manual journal, or a purchase or credit note that moves the quantity and value. Do not simply overwrite the number. Every adjustment needs a matching accounting entry, otherwise your balance sheet inventory figure and your physical count part ways permanently.

Post write-offs to a dedicated stock loss or shrinkage account rather than burying them in cost of goods sold. Separating them tells you whether your margin problem is pricing or wastage, and those need different fixes.

Common Mistakes

• Tracking everything, including low value consumables, so maintenance overwhelms the benefit.
• Running tracked items alongside a separate inventory system, guaranteeing two conflicting sets of numbers.
• Entering bills late, which distorts average cost and misstates margin on every sale in the gap.
• Never doing a stocktake, so the balance sheet inventory figure becomes fiction.
• Using tracked items for manufacturing, where components become a different product and Xero has no way to model it.

How SortBooks Fits

Inventory accounting is only as reliable as the transactions underneath it. If supplier bills sit in draft for weeks and your bank feed is unreconciled, average cost is wrong, gross margin is wrong, and the stock figure on your balance sheet is a guess.

SortBooks connects to your Xero file and handles the categorisation layer, suggesting the account and GST code for each transaction based on your history, with nothing written back until you approve it. That keeps purchases current and coded, so your inventory valuation rests on data that is actually up to date.

Final Thoughts

Xero inventory is not a warehouse management system and does not pretend to be. What it does well is give a small business holding a manageable range of resale products an accurate stock value and automatic cost of goods sold, without a separate subscription.

Set it up for the items where unit counts genuinely inform decisions, leave everything else untracked, enter bills promptly, and count your stock on a schedule. Do that and your gross margin becomes a number you can act on rather than one you discover at year end.