How to Add a Tracked Inventory Item in Xero

If your business sells physical products, you already know the pain: you think you have stock, then you don’t. Or you sell something, forget to update your records, and your accounting is a mess by month-end.

Xero’s tracked inventory feature fixes that. It connects your stock levels directly to your accounting — so every sale, purchase, and adjustment updates automatically.

This guide walks you through exactly how to add a tracked inventory item in Xero, what settings matter, and how to keep your inventory running without constant manual updates.

What Is a Tracked Inventory Item in Xero?

In Xero, inventory items can be either tracked or untracked.

• Untracked items are simple — they appear on invoices and bills but Xero doesn’t monitor how many you have in stock.
• Tracked items go further. Xero records every unit sold, purchased, and adjusted. You always know your current stock level and the cost of goods sold (COGS) without lifting a finger.

Tracked inventory in Xero uses the weighted average cost method to value your stock. That means Xero recalculates the average cost of each item every time you purchase more — keeping your financials accurate without manual cost tracking.

According to a 2023 report by Wasp Barcode Technologies, 43% of small businesses either use manual processes or don’t track inventory at all — which leads directly to overselling, cash flow problems, and accounting errors. Tracked inventory in Xero is built specifically to solve that.

Before You Start: What You Need

Before adding a tracked inventory item, make sure:

• You are on Xero’s Standard or Premium plan (tracked inventory is not available on the Starter plan)
• You have Adviser or Standard user permissions in Xero
• You have set up at least one Inventory Asset account and one Cost of Goods Sold (COGS) account in your chart of accounts
• You know your opening stock quantity and value so Xero can correctly calculate your starting balance

If you haven’t set up these accounts yet, go to Accounting → Chart of Accounts and create them before proceeding.

How to Add a Tracked Inventory Item in Xero — Step by Step

Go to the Inventory Section

Log in to your Xero account. In the top navigation bar, click Business, then select Products and Services from the dropdown menu.

This is your inventory hub. All your items — tracked and untracked — live here.

Click “New Item”

In the top-right corner of the Products and Services page, click the + New Item button.

A new item form will open. This is where you configure everything about the product.

Enter Your Item Details

Fill in the basic details:

• Item Code — A short, unique reference code for the item (e.g., SHOE-BLK-42). Keep these consistent across your catalogue.
• Item Name — The full product name that will appear on invoices and purchase orders.
• Description — Optional, but useful for customer-facing documents. You can set different descriptions for sales (what customers see on invoices) and purchases (what appears on bills to your supplier).

Enable Tracking

This is the critical step. In the item form, locate the “I track this item” checkbox and tick it.

Once enabled, two new fields appear:

• Inventory Asset Account — Select the balance sheet account where the value of your stock is held (typically labelled “Inventory” or “Stock on Hand”).
• Cost of Goods Sold Account — Select the expense account that captures the cost of items when they are sold.

Both accounts are required for tracked items. If you haven’t created them yet, you’ll need to do so in your chart of accounts first.

Set Up the Sales Details

Under the Sales section, configure:

• Sales Price — The price you charge customers. You can leave this blank if pricing varies.
• Sales Account — The revenue account that sales of this item will be posted to (e.g., “Sales” or “Product Revenue”).
• Tax Rate — Select the applicable tax rate for sales transactions.

Set Up the Purchase Details

Under the Purchase section, configure:

• Purchase Price — Your cost price from the supplier. Xero uses this to calculate initial inventory value and COGS.
• Purchase Account — This is automatically set to your Inventory Asset Account when tracking is enabled. You don’t need to change this.
• Tax Rate — Select the applicable tax rate for purchases.

Set a Reorder Point (Optional but Recommended)

Scroll down to find the “Reorder Level” field. Enter the minimum stock quantity at which you want Xero to flag that it’s time to reorder.

This won’t automatically place an order — but Xero will highlight items that have fallen below this threshold in your inventory reports, so you never get caught off guard.

Research from the National Retail Federation shows that out-of-stock situations cost retailers an estimated 4% of annual revenue. A well-set reorder level is one of the simplest ways to protect against that.

Enter Your Opening Stock Balance

If you already have units of this item in stock, you need to record them. Click “Add Opening Balance” and enter:

• Quantity on Hand — How many units you currently hold.
• Unit Cost — The average cost per unit.
• Date — The date from which Xero will start tracking (usually your go-live or financial year start date).

Xero will use this information to set your opening inventory value in the Inventory Asset Account. This step ensures your balance sheet is accurate from day one.

Important: Opening balances can only be entered once. If you make an error, you’ll need to process a manual adjustment later via Inventory Adjustments.

Save the Item

Click Save in the top-right corner. Your tracked inventory item is now live in Xero.

From this point forward, every sales invoice that includes this item will automatically reduce your stock quantity and post the COGS. Every purchase bill will increase your stock and update your weighted average cost.

How Xero Tracks Inventory Automatically

Once your item is set up, here’s what happens in the background:

When you raise a sales invoice: Xero deducts the quantity from stock, calculates the COGS at the current weighted average cost, and posts the entry to your COGS account.

When you raise a purchase bill: Xero increases your stock quantity and recalculates the weighted average cost based on the new purchase price and quantity.

When you run an inventory adjustment: You can manually add or remove units (e.g., for stock shrinkage, write-offs, or stock takes) via Business → Products and Services → Inventory Adjustments. Xero records these adjustments against a nominated adjustment account, keeping your financials clean.

According to McKinsey, companies that implement automated inventory tracking see an average 15–35% reduction in inventory carrying costs compared to those using manual methods. The time savings alone are significant for lean teams.

Common Mistakes to Avoid

Skipping the opening balance. If you add a tracked item without entering an opening balance and then start processing transactions, your stock levels and COGS figures will be wrong from day one. Always set opening stock before using the item on any document.

Using the wrong accounts. Your Inventory Asset Account must be a Balance Sheet asset account, and your COGS account must be an Expense account. Using income accounts or bank accounts in these fields will corrupt your reports.

Not reconciling regularly. Xero tracks inventory based on what’s entered in invoices and bills — not what’s physically on your shelves. Run a regular stock take and use Inventory Adjustments to keep the two in sync. Industry benchmarks suggest that businesses doing monthly stock reconciliations have 60% fewer inventory discrepancies than those that reconcile quarterly.

Deleting transactions instead of voiding them. Deleting a sales invoice removes the COGS entry and adds the stock back, which can create misleading audit trails. Always void or credit note transactions rather than deleting them.

Viewing and Managing Your Inventory

Once items are set up, Xero gives you several ways to stay on top of your stock:

• Inventory Item Summary Report — Found under Accounting → Reports. Shows quantity on hand, cost of goods sold, and inventory value for every tracked item.
• Products and Services List — Your real-time view of current stock levels. Items below reorder point are flagged automatically.
• Inventory Adjustment History — A full audit log of every manual adjustment made, useful for accountability and reconciliation.

Tips to Get More Out of Xero Inventory Tracking

Use item codes consistently. A clear, structured naming convention (e.g., category-colour-size) makes filtering, reporting, and bulk updates far easier as your catalogue grows.

Set purchase prices accurately. Because Xero uses weighted average costing, your opening and purchase prices directly affect your COGS and gross margin reports. Inaccurate cost prices lead to misleading profitability data.

Review the Inventory Item Summary monthly. This is your fastest way to spot slow-moving stock, items with unexpected cost changes, or lines where margin has dropped.

Use Xero’s Purchase Orders. Raising purchase orders in Xero (rather than tracking them externally) means your expected stock arrivals are visible in the system before the bill is processed — giving your team early visibility on incoming inventory.

Connect a dedicated inventory app for complex needs. For businesses with multiple warehouses, serial number tracking, or high-volume stock movements, Xero’s native tracking has limits. Apps like DEAR Inventory, Cin7, or Unleashed integrate directly with Xero and extend its capabilities significantly.

Conclusion

Adding a tracked inventory item in Xero takes less than five minutes once your accounts are set up — but the value it delivers compounds over time. Every transaction automatically updates your stock levels, your COGS, and your balance sheet. No spreadsheets. No manual reconciliation. No end-of-quarter surprises.

The key steps are simple: navigate to Products and Services, create a new item, tick “I track this item,” link the right accounts, enter your opening balance, and save. From that point forward, Xero does the heavy lifting.

Get your inventory set up correctly from the start, reconcile it monthly, and you’ll have the financial clarity to make faster, more confident business decisions.