Yes. Xero’s built-in Products & services feature tracks both stock quantity and stock value, updating automatically whenever you raise an invoice or enter a bill. It suits straightforward sellers with one location and a manageable catalogue, but it caps out at 4,000 tracked items and has no native multi-location support. This guide walks through setup, day-to-day management, reporting and when to bring in extra software.
TL;DR:
- Xero’s inventory tracking supports up to 4,000 items and is ideal for single-location retailers or wholesalers, but it does not support multiple warehouses or manufacturing.
- Inventory updates live and automatically with each invoice and bill, using an average cost method that recalculates margins for each stock purchase.
- Proper setup requires careful selection of the opening balance date, accurate account creation, and validation through stock counts to avoid reconciliation issues.
- The system’s limitations suggest that businesses with multiple locations, over 4,000 SKUs, or complex manufacturing processes should plan for third-party apps or upgrades.
- Regular use of key reports like stock on hand and item details helps monitor stock health, turnover, and overstock issues, especially when combined with manual stock adjustments.
Table of Contents
- How does Xero inventory tracking actually work?
- Is native Xero inventory right for your business?
- How do you set up tracked inventory in Xero?
- Managing inventory items without creating a mess
- How buying and selling affect stock and COGS
- When and how to run stock adjustments and stocktakes
- Which inventory reports matter and why
- Where native Xero inventory falls short
- Choosing and connecting a Xero inventory integration
- Final checklist before going live
- Why a dedicated accountant makes Xero inventory less risky
- Get your Xero inventory set up properly, once
- Sources
- FAQ
How does Xero inventory tracking actually work?
Xero’s tracked inventory is a perpetual system. Every time you raise a sales invoice for a tracked item, stock quantity drops immediately. Every time you enter a bill or receive stock, it rises. There’s no end-of-month batch update. Xero updates the count in real time, which is what makes it usable for day-to-day decisions like reordering.
Behind that quantity sits a value. Xero holds inventory on an asset account on your balance sheet, and when stock sells, it moves the cost across to a cost of goods sold (COGS) account using an average cost method. That average recalculates every time you buy more stock at a different price, so your margins reflect a blended cost rather than the price of the very last delivery.
A few practical points worth knowing before you start:
- Tracked inventory lives under Business > Products and services, not in a separate inventory module.
- Full functionality, including purchase orders and channel sync, sits behind Xero’s Grow plan or the Inventory Plus product.
- Only items marked with “Track inventory item” behave this way. Untracked items are treated as simple line descriptions with no stock effect.
Is native Xero inventory right for your business?
Xero’s native tracking works well for retailers and wholesalers who buy stock, sell it through standard invoices, and operate from one location. If that’s your model, you’ll rarely need anything else.
It starts to strain under specific conditions:
- You’re approaching or exceeding the managed item limit.
- You operate from more than one warehouse or store location, since native Xero has no location field.
- You manufacture goods or assemble kits, where stock needs a bill of materials rather than a simple buy/sell record.
- You sell across several ecommerce channels and need real-time stock sync to avoid overselling.
If any of those apply, don’t force it. Trying to hack multi-location tracking with workarounds (such as separate item codes per site) creates messy reconciliations within a few months. The sensible move is planning for Inventory Plus or a specialist app from the outset, rather than migrating mid-year once the spreadsheets have taken over.
How do you set up tracked inventory in Xero?
Setup rewards a bit of patience upfront. Rush it and you’ll spend weeks untangling opening balances later.
- Pick your opening balance date. Choose a date that lines up with a physical stock count, ideally your financial year start or the start of a clean month. Xero Central is explicit that this date matters because it anchors your entire opening journal, so don’t pick it arbitrarily.
- Check your lock dates. If you’ve already locked periods for VAT or year-end, make sure your chosen opening date sits after the lock, or Xero will block the import.
- Create the right accounts. You’ll need an inventory asset account (type: Current Asset) and a COGS account (type: Direct Costs) in your chart of accounts if they don’t already exist.
- Add items via Products and services. For each item, populate the SKU, description, purchase price, sale price, and tick “I track this item.” Assign the inventory and COGS accounts you just created.
- Download and complete Xero’s opening balance import template. This spreadsheet asks for item code, quantity on hand, and unit cost at your chosen date.
- Import and validate. Once uploaded, cross-check the resulting journal total against your physical stock count valuation. Any mismatch usually points to a unit cost error or a duplicated SKU.
Pro Tip: Run your physical stock count on the same day you set the opening balance date, not a week either side. A gap of even a few days introduces sales and deliveries you’ll have to manually reconcile afterwards, and that reconciliation is far more tedious than doing the count on the right day in the first place.
Managing inventory items without creating a mess
Good inventory records start with boring discipline: consistent naming and clean SKUs. If you’re planning to connect Shopify, Amazon, or a POS system later, mismatched SKUs between platforms are the single biggest cause of failed syncs and duplicated stock lines.
A few habits worth adopting early:
- Use a fixed SKU format (category prefix plus sequential number) rather than free text, so nothing gets typed twice with a stray space.
- Set default purchase and sale prices on each item, but understand that editing a price only affects future transactions, not historical costing already posted.
- For catalogues running into hundreds of lines, use Xero’s bulk import rather than adding items one by one. It’s faster, but validate the file carefully first. A single blank required field can silently fail the whole batch.
Pro Tip: Before a bulk import, add two or three test items manually and check they behave as expected in a sale and a purchase. It’s a five-minute check that saves you re-importing four hundred lines because the account mapping was wrong.
How buying and selling affect stock and COGS
Every transaction that touches a tracked item does one of two things: it reduces stock or it adds to it. Sales invoices reduce quantity on hand the moment they’re approved. Bills and stock receipts increase it. There’s no separate “confirm delivery” step required for the accounting to move.
Financially, the mechanics work like this:
- When you sell, Xero posts the item’s average cost from the inventory asset account into COGS, alongside the sale value hitting revenue.
- When you buy, the cost sits in the inventory asset account until it’s sold, at which point it flows through to COGS.
- Partial deliveries need care. If a supplier ships half an order, only record the bill for what’s actually arrived. Recording the full purchase order value against a partial delivery inflates your stock quantity and understates your average cost.
- Returns and backorders don’t have a dedicated automatic workflow. A returned item typically needs a manual credit note plus a stock adjustment if the goods are unsellable.
When and how to run stock adjustments and stocktakes
Manual adjustments exist for the gaps that transactions don’t cover: damage, shrinkage, theft, or correcting a data entry mistake from months back. These post directly to the inventory asset and COGS accounts without a sale or purchase attached, so they should be used sparingly and always with a note explaining why.
A workable stocktake process looks like this:
- Freeze new stock movements for the count window, even if that just means pausing dispatch for an afternoon.
- Count physical stock and record it against each SKU on a spreadsheet.
- Compare the count to Xero’s stock on hand report and list every variance.
- Enter manual adjustments in Xero for each variance, tagging them clearly (for example, “Q3 stocktake shrinkage”).
- Reconcile the inventory asset account balance on your balance sheet to the total value shown on the stock valuation report. They should match exactly. If they don’t, something has been posted to the inventory account outside the normal buy/sell flow.
Which inventory reports matter and why
Three reports do most of the work: inventory item summary, item details, and stock on hand. The item summary gives you a fast overview of quantity and value by product, useful for a quick health check before a board meeting or VAT return. Item details drills into every movement for a single SKU, which is where you go hunting when a number looks wrong. Stock on hand is your live snapshot for reordering decisions.
Stock valuation from these reports feeds directly into your balance sheet figure for inventory and, cumulatively, your COGS on the profit and loss account. Run them regularly, not just at year-end.
- Watch stock turnover to spot items tying up cash unnecessarily.
- Flag slow-moving stock sitting for more than 90 days, a common trigger for write-down conversations with your accountant.
- Track stock value trends month to month. A steadily rising value with flat sales usually means overbuying, not growth.
Pro Tip: If your stock value on the balance sheet jumps without a matching rise in sales, check the item details report before assuming it’s a stocktaking error. Sometimes it’s simply a large restock that hasn’t sold through yet, and that’s fine.
Where native Xero inventory falls short
Xero’s own positioning is candid about this: the core inventory tool is deliberately simple, built to keep basic stock and accounting together rather than replace a dedicated inventory system. Know the boundaries before you hit them.
- Single location only. There’s no field for warehouse or store, so multi-site businesses need a workaround or an app.
- 4,000 item ceiling. Growing catalogues will eventually outgrow this.
- No bill of materials. Manufacturers assembling finished goods from components get no native support.
Once multi-channel ecommerce, multiple warehouses, or automated reordering become part of daily life, it’s worth adding Inventory Plus or a third-party platform. Expect a subscription fee on top of your Xero plan, some time spent mapping SKUs and cost fields between systems, and a proper test sync before going live.
Choosing and connecting a Xero inventory integration
Three broad categories of app extend Xero’s inventory: ecommerce connectors that sync stock levels from storefronts, full inventory platforms like Unleashed and Cin7 that handle multi-warehouse and manufacturing, and POS or barcode systems for physical retail. Each solves a different gap, so match the app to the actual constraint rather than picking the most popular one.
Whichever category you choose, the sync only works cleanly if SKUs, units of measure, and cost mappings match exactly between Xero and the app. A product coded “SKU001” in Xero and “sku-001” in your ecommerce platform will simply fail to reconcile.
- Clean up SKUs in Xero before connecting anything.
- Confirm units match (each vs. box vs. kilogram) on both sides.
- Run a trial sync on a handful of items first, not your whole catalogue.
Pro Tip: Check the Xero App Store listing for an app before committing. It’s not just a directory. Reviews there often flag exactly the sync quirks (duplicate orders, delayed stock updates) you’d otherwise only discover after go-live.
Final checklist before going live
Before calling inventory “live,” confirm: opening balances imported and reconciled to a physical count, inventory and COGS accounts correctly mapped on every item, SKUs cleaned and consistent, and lock dates set correctly.
- Run stock on hand and cross-check against your last count.
- For mid-year starts, double-check the opening date doesn’t fall inside an already-filed VAT period.
- Retailers adding POS integration should run a full day’s trading through the sync before switching over completely, watching for duplicated sales or missed stock decrements.
Most import errors trace back to one thing: a SKU typed differently in two places.
Why a dedicated accountant makes Xero inventory less risky
Setting this up alone is entirely possible, but the mistakes are quiet ones. Wrong account types, a badly timed opening balance date, duplicate SKUs that only surface three months later. An accountant who’s done this repeatedly checks controls and naming conventions before they become embedded problems, and keeps ongoing bookkeeping aligned so stock records don’t drift from the accounts. It’s part of why E-accounts built ecommerce specialism into its service from the start.
Get your Xero inventory set up properly, once
Getting tracked inventory right the first time saves hours of reconciliation later, and that’s exactly where a specialist pays for itself against DIY setup. A dedicated accounting service can support you with Xero setup, ongoing bookkeeping, and ecommerce integrations for sellers on popular platforms, helping ensure stock records and accounts stay aligned.
If you’re running an online store and want inventory, VAT, and reconciliations handled properly from day one, the ecommerce accounting service is built exactly for that, with all-inclusive packages from £29 per month. For general small business support with Xero setup and bookkeeping, the accounting packages page covers pricing from the same starting point. Get in touch for a setup review and a straight answer on what your inventory needs before you commit to anything.
Sources
FAQ
Can I track inventory with Xero?
Yes. Xero’s Products and services feature supports tracked inventory, updating both quantity and value automatically whenever you raise an invoice or bill. It suits single-location retailers and wholesalers, though full functionality including purchase orders sits on Xero’s higher-tier plans.
Why is Xero’s share price falling?
This is a stock market question unrelated to the accounting software’s functionality, and share price movements depend on broader market and company performance factors outside the scope of inventory tracking. If you’re asking because you’re worried about product reliability, note that Xero’s inventory tools continue to be actively developed and supported regardless of share price fluctuations.
How can I keep track of my inventory in Xero?
Enable “Track inventory item” on each product in Products and services, then let sales invoices and bills automatically adjust quantity and value. Run the stock on hand and item summary reports regularly, and reconcile your inventory asset account against a physical stocktake at least quarterly.
How do I add a tracked inventory item in Xero?
Go to Business, then Products and services, and create a new item. Enter the SKU, purchase price, and sale price, tick “I track this item,” then assign your inventory asset and COGS accounts before saving.
