Xero Inventory Management: A Practical Guide for UK Businesses

Rates and thresholds current as at 17 May 2026. Subject to change. Take independent tax advice for your specific circumstances.

Xero inventory management is a usable but deliberately basic stock-tracking layer built into the Xero accounting platform. It works well for small UK businesses with a few hundred SKUs and a single warehouse, and it stops working well roughly the moment you need multi-location stock, manufacturing assemblies, or serial-number tracking. The sections below cover what Xero native inventory does, where it stops, when to graduate to a dedicated inventory management system (IMS) such as Unleashed or Cin7, and how the choice maps to UK VAT and tax accounting.

Most UK trading businesses turning over between £150,000 and £3 million reach a point where they have either outgrown spreadsheet stock control or have been quietly mis-using Xero’s tracked inventory for longer than is comfortable. A worked example runs through (an electrical wholesaler in Greater Manchester running 200 SKUs), alongside a comparison of the four IMS options that come up in almost every conversation on this topic.

What Xero native inventory actually does

Xero ships with two inventory features. The first is the basic Inventory Items list, available on every Xero plan. Items here are essentially saved templates for sales and purchase lines, with default account codes, tax rates, and prices. No quantity is held, no cost of sales is posted, and no stock value sits on the balance sheet.

The second is Tracked Inventory, available on Xero Growing and Established plans (UK pricing as at May 2026 is £40 and £59 per month respectively). Tracked items maintain a perpetual quantity-on-hand and an average cost. When you invoice a customer for a tracked item, Xero automatically posts the cost of goods sold (COGS) journal: debit COGS, credit Inventory Asset. The stock value on the balance sheet updates in real time.

What Xero native inventory does well:

• Perpetual stock for a single location with quantity-on-hand visible on the item card and in reports.
• Automatic COGS posting using average cost (AVCO), so management accounts show gross margin without month-end stock-count adjustments.
• Stock adjustments for shrinkage, write-offs, and revaluations, with full audit trail and an attached reason field.
• Inventory item reports: Item Details, Inventory Item Summary, and the Inventory Item List, which between them cover most owner questions about what is selling and what is sitting.
• Integration with Xero quotes, sales invoices, purchase orders, and bills. Selecting a tracked item on any of these documents pulls the cost and updates the stock count when the document is approved.

Tracked vs untracked items in Xero

This distinction trips up roughly four out of five new Xero users. An untracked item is convenient but invisible to the balance sheet. A tracked item carries a real stock value but commits you to the discipline that goes with perpetual inventory: opening counts, accurate goods-in postings, no negative quantities, and a willingness to do a physical stocktake at least annually.

You should use tracked items if you sell physical goods, you carry more than £5,000 of stock at cost, and you need accurate gross margin per item or per category. You should use untracked items if you are a service business, your stock is consumables (cleaning supplies, stationery) that you expense as purchased, or if your stock turns so fast that a periodic stocktake is both feasible and cheaper than the perpetual discipline.

Switching an untracked item to tracked after the fact requires an opening stock journal at AVCO, which Xero will walk you through. Switching a tracked item back to untracked is harder and usually means writing the remaining stock value off through a manual journal.

Worked example: an electrical wholesaler with 200 SKUs

Greater Manchester electrical wholesaler. Three years trading. Annual turnover £1.4 million. 200 SKUs across cables, switchgear, lighting, and consumables. Single warehouse in Trafford Park. Five staff including the owner. The owner moved from spreadsheets to Xero tracked inventory in month 14 and has been running it for 12 months. The figures below contrast the year before and the year after.

The headline saving is £37,630 in a single year, more than half of which comes from fewer stock-outs (the revenue side) rather than the cost side. The owner also gained accurate monthly gross margin reporting, which surfaced two slow-moving SKU categories that were quietly absorbing £18,000 of working capital. Those lines were discounted out in month 18 and the cash redeployed.

Where Xero stopped being adequate for this wholesaler was the introduction of a second warehouse in month 22. Xero tracked inventory is single-location only. The owner ran a Cin7 trial in months 23 and 24 and migrated in month 25.

Xero native vs DEAR vs Unleashed vs Cin7

The four options below are the ones that come up in almost every conversation with UK small-business owners considering an inventory upgrade. DEAR was rebranded to Cin7 Core in 2023; the underlying product is the same and we still hear the DEAR name most weeks. All four integrate with Xero as the accounting back-end.

Cin7 Omni and Cin7 Core are two separate products despite the shared name. Omni is the enterprise-grade EDI and multi-channel platform; Core is the rebranded DEAR product and sits one tier down in cost and complexity. Get the distinction wrong in your sales call and you will either overpay or under-buy.

Decision helper: which option fits your business

The right choice is almost always about SKU count, sales-channel complexity, and whether you assemble anything. Cost is a secondary filter once you are above 500 SKUs because the cost of getting it wrong dwarfs the subscription difference.

• If you have under 200 SKUs, a single warehouse, no manufacturing, and turnover under £750,000: stay on Xero native tracked inventory. The upgrade cost is not justified.
• If you have 200 to 500 SKUs, a single warehouse, mostly recurring lines, and turnover £750,000 to £1.5 million: Xero native is still the right answer. Spend the budget on a stock-control discipline (weekly cycle counts) rather than software.
• If you have 500 to 2,000 SKUs, one or two locations, simple assemblies (kitting), and turnover £1.5 million to £3 million: DEAR / Cin7 Core is the best price-to-feature fit. Budget £4,000 for setup and 4 weeks of parallel running.
• If you have 1,000 to 10,000 SKUs, multiple warehouses, batch and serial tracking required, and turnover £2 million to £8 million: Unleashed is the strongest pick. Its UK-based support and Xero-native heritage matter for the kind of clean GL postings UK accountants want.
• If you have 5,000+ SKUs, multi-channel sales (Shopify, Amazon, EDI to retailers), 3PL warehousing, and turnover £5 million+: Cin7 Omni. The price is real and the setup is real. Do not approach this without an experienced implementation partner.
• For any food, pharma, alcohol, or regulated electronics business: you need batch tracking and expiry-date tracking from day one. Xero native cannot do this; start with DEAR / Cin7 Core or above.

UK VAT thresholds, FIFO/AVCO and tax accounting

Three UK-specific rules shape every inventory decision a small business makes. They are the VAT registration threshold, the choice of stock costing method, and the Making Tax Digital quarterly filing cadence.

VAT registration threshold (as at 17 May 2026): £90,000 of taxable turnover in any rolling 12-month period. Once you are over the threshold and selling physical goods, your inventory system must be able to apply the correct VAT rate per item (standard 20%, reduced 5%, zero, exempt, outside the scope). Xero native handles this well at the item level. The complication arises if you sell into multiple VAT regimes (UK plus EU under the One Stop Shop, plus US sales-tax states) because Xero native cannot manage parallel tax rules. DEAR / Cin7 Core can.

Stock costing for UK tax purposes. HMRC accepts FIFO (first-in, first-out) and weighted-average cost (AVCO) for both accounts and tax. LIFO (last-in, first-out) is not permitted under UK GAAP (FRS 102 section 13) or under IFRS, and HMRC will not accept it for tax computations. A handful of US-developed IMS platforms still default to LIFO on installation; if you accept the default you will then have to maintain a separate FIFO or AVCO computation for the UK accounts every year. Switch the costing method to FIFO or AVCO on day one.

Making Tax Digital for VAT. Every VAT-registered business must keep digital records and file VAT returns through MTD (Making Tax Digital with HMRC compatible software). Xero is fully compliant. All four IMS options above push the inventory journal into Xero, which then files the VAT return. The IMS itself does not file. For more on MTD (Making Tax Digital compliance regime) see our sister site mtd.digital.

Annual stocktake and the year-end stock value. A perpetual inventory system still requires a physical stocktake at least once a year for audit and tax purposes. The stocktake reconciles the book stock to the floor stock and the difference is posted as a stock adjustment. Persistent shortfalls above 2% of stock value attract scrutiny from HMRC and from any external accountant or auditor.

Plain English glossary of inventory terms

• SKU (Stock Keeping Unit). A unique identifier for one specific product variant. A blue medium t-shirt and a blue large t-shirt are two SKUs. The SKU is what the inventory system counts.
• COGS (Cost of Goods Sold). The cost value of the stock you sold in a period. Sales minus COGS equals gross profit. A tracked inventory system posts COGS automatically when an invoice is raised.
• Perpetual inventory. Stock counts update in real time as sales and purchases happen. The book stock is meant to match the floor stock at any moment. Requires discipline at goods-in and goods-out.
• Periodic inventory. Stock value is only known after a physical count, usually at month-end or year-end. COGS is calculated as opening stock plus purchases minus closing stock. Simpler but slower.
• FIFO (First-In, First-Out). Stock is treated as sold in the order it was bought, so the cost of sale uses the oldest purchase price. Acceptable under UK GAAP.
• AVCO (Average Cost). Each new purchase blends into a running average cost per unit. Xero native uses AVCO. Acceptable under UK GAAP.
• LIFO (Last-In, First-Out). Stock is treated as sold newest-first. Not permitted under UK GAAP or for HMRC tax computations. Avoid any IMS configuration that uses it.
• Opening stock and closing stock. The stock value at the start and end of an accounting period. Used in periodic inventory and in year-end accounts.
• Reorder level. The quantity-on-hand threshold below which a purchase order is automatically suggested. Xero shows reorder levels on the item card; the more advanced IMS options auto-generate purchase orders.
• Bill of materials (BOM). The recipe for an assembled product, listing the component SKUs and quantities. Required for any business that manufactures or kits.

Edge cases: multi-currency, bonded, dropship, consignment, FBA

• Multi-currency stock purchases. If you buy stock in US dollars or euros and sell in sterling, the cost basis must be locked at the sterling spot rate on the date of the purchase invoice. Xero handles this for tracked items via the Multi-Currency add-on (£25/month on the Established plan). DEAR / Cin7 Core handle it more cleanly because foreign-currency landed costs (freight, duty, insurance) can be added at the line level before the stock is posted.
• Bonded warehousing and excise goods. Alcohol, tobacco, and energy products held under bond do not attract excise duty until they leave the bonded warehouse. Xero native cannot model the bonded/duty-paid split. You need either a specialist excise IMS or a Cin7 Omni implementation with custom rules. This is a regulated area and you should not improvise.
• Dropshipping. Stock is never physically held by you; the supplier ships directly to the customer. Xero native cannot represent this cleanly because there is no goods-in event. DEAR / Cin7 Core and Cin7 Omni both have dropship workflows that post a zero-cost goods-in followed by an immediate goods-out at the supplier’s cost.
• Consignment stock. Stock held at a customer site that you still own until they sell it. The economic ownership is yours; the physical location is theirs. Xero native treats this as your stock at your single location and is wrong; the IMS options can model a customer-location warehouse to keep the data honest. Critical if your insurance asks for an accurate location split.
• Amazon FBA (Fulfillment by Amazon). Stock is held in Amazon’s warehouses, often spread across several countries. Sales, returns, and adjustments all flow through Amazon’s reports. Xero native cannot reconcile FBA stock movements directly; an A2X or Link My Books bridge is the usual answer for SME sellers, with a full IMS only justified above £1.5 million of Amazon revenue.

Our view: when to graduate from Xero to a dedicated IMS

The honest commercial line is that most UK small businesses sit on Xero native tracked inventory for too long because the switch feels expensive and the daily pain is tolerable. The owner notices the friction at month-end (chasing variance), at year-end (large stocktake adjustments), and at the bank covenant check (margins that move 4 to 8 points between quarters without explanation). By the time the case for a dedicated IMS becomes obvious to the owner, the business has usually carried 18 to 24 months of avoidable cost.

Our threshold for recommending a graduation conversation is any two of the following five conditions:

• A second physical stock location is on the horizon within 12 months.
• SKU count is above 500 and growing more than 20% year on year.
• Manufacturing or kitting is now a regular activity, even at low volume.
• Year-end stocktake adjustments are routinely above 2% of carried stock value.
• You sell on more than one channel (your own site plus Amazon plus a marketplace) and reconciliation between them eats more than four hours per week.

The single most common mistake we see is over-buying. A business with 800 SKUs and one location does not need Cin7 Omni. DEAR / Cin7 Core at £245 per month does the job and integrates with Xero in a few hours of work. The second most common mistake is under-buying: trying to stretch Xero native to cover a 3,000-SKU multi-channel operation by adding a stack of bolt-ons. That route compounds rather than solves the problem.

The ROI test we use is a simple payback calculation: if the IMS subscription plus implementation cost is less than the avoided stock write-offs plus avoided lost sales plus reclaimed owner hours, switch. For most businesses that cross the thresholds above, payback is under 6 months. We are happy to walk through this calculation in a free 30-minute review.

Frequently asked questions

Does Xero have inventory management built in?

Yes. Xero includes basic untracked items on every plan and Tracked Inventory on the Growing and Established plans. Tracked Inventory maintains a perpetual quantity-on-hand and posts cost of goods sold automatically using average cost. It works well for a single location with under 500 SKUs.

What is the difference between tracked and untracked items in Xero?

Untracked items are saved templates for invoice and bill lines, with no quantity and no balance sheet impact. Tracked items hold a real stock quantity and value, post COGS automatically on sale, and appear in inventory reports. You can convert an untracked item to tracked by entering an opening stock count.

Can Xero handle multiple warehouses or locations?

No. Xero native inventory is single-location only. If you need multi-location stock you have to either run a workaround using separate item codes per location (not recommended) or move to a dedicated inventory management system such as DEAR, Unleashed, or Cin7 that holds the stock and pushes the accounting journals into Xero.

Does Xero use FIFO or AVCO costing?

Xero uses average cost (AVCO) only. Each new purchase blends into a running average cost per unit. AVCO is acceptable under UK GAAP (FRS 102) and for HMRC tax purposes. If you specifically need FIFO you have to use a third-party IMS that supports it and pushes the costed journal into Xero.

What is the UK VAT registration threshold and how does it affect inventory?

The UK VAT registration threshold is £90,000 of taxable turnover in any rolling 12-month period as at 17 May 2026. Once registered, every stocked item must be coded with the correct VAT rate. Xero handles this at the item level, but if you sell into multiple VAT regimes (UK plus EU One Stop Shop plus US sales tax) you will likely need a dedicated IMS to manage the parallel rules.

When should I move from Xero inventory to DEAR, Unleashed, or Cin7?

We recommend a graduation conversation when any two of these five conditions are met: a second location within 12 months; more than 500 SKUs growing 20% year on year; regular manufacturing or kitting; year-end stocktake adjustments routinely above 2% of stock value; or multi-channel sales with reconciliation eating more than four hours a week.

How does Making Tax Digital affect my inventory accounting?

Making Tax Digital for VAT requires digital records and digital filing through MTD (Making Tax Digital approved third-party software). Xero is fully MTD-compatible, and all four IMS options push the inventory journal into Xero, which files the VAT return. The IMS itself does not file. For a fuller MTD walkthrough see our sister site mtd.digital.

Further reading

• gov.uk: VAT registration thresholds
• ICAEW: UK GAAP (FRS 102) financial reporting
• Xero Central: Inventory documentation (UK)
• gov.uk: Making Tax Digital for VAT

Related Xero guides

• Xero bookkeeping services for UK businesses
• Running multiple businesses through Xero
• Find a Xero bookkeeper in Manchester and the UK
• Jack Ross Chartered Accountants: parent firm services

Book a Xero inventory review

If you are running Xero native tracked inventory and beginning to feel the friction at month-end, the right next step is usually a one-hour review rather than a software purchase. We will look at your SKU count, your stock movement patterns, your sales channels, and your year-end stocktake history, and tell you whether to stay on Xero, move to DEAR / Cin7 Core, move to Unleashed, or move to Cin7 Omni. The review is free and there is no obligation to engage us for the implementation.

JacRox is the Xero cloud accounting arm of Jack Ross Chartered Accountants, an ICAEW-regulated chartered firm founded in 1948 and based in Manchester. We are a Xero Silver Partner with implementation experience across DEAR / Cin7 Core, Unleashed, and Cin7 Omni. If you would like to discuss your Xero inventory setup, get in touch via our contact page or call us on 0161 832 4451.