For product businesses running stock inside Xero

Outgrown Xero Inventory? What It Does Well, Where It Stops, and How to Move On

Xero tracked inventory is a good starting point. It keeps a quantity on hand, values stock at average cost, and posts cost of goods sold automatically every time you invoice. For a business with one location, a few hundred products and no manufacturing, it is often all you need. The trouble starts when the business grows sideways: a second location, a Shopify store and a POS selling the same stock, products built from components, batches with expiry dates, or freight that needs to land on the cost of the goods.

This page is for the point where Xero inventory starts to feel like the wrong tool. It covers the limits at a general level, the symptoms that tell you it is time, the three realistic options, what changes in Xero when an inventory app takes over, and how to cut over without double counting stock or losing your cost history. It also covers the cases where you have not outgrown anything and a tidy up is the right answer.

Book an Inventory Review (03) 9003 0111

The Shape of the Decision

3 options

Tidy up, add an inventory app, or move to an ERP

Most growing Australian product businesses land on the middle option, but not all of them should

1 stock master

Is the rule after cutover

Two systems both tracking stock is a common and costly mistake in this move

1 stocktake

At the cutover date, not before or after

Opening balances are only as good as the count they come from

Weeks, not days

For a careful cutover

Rough guide: four to ten weeks for a typical inventory app move, longer with manufacturing or several locations

What Xero Inventory Does Well, and Where It Stops

Xero is an accounting system that includes some inventory features. That explains most of its limitations, and also why it works well when your needs are simple.

The good part: tracked items, average cost and automatic COGS

When an item is tracked in Xero, a bill increases quantity and the inventory asset account, a sales invoice reduces quantity and posts cost of goods sold at the current average cost. No month end journal, no separate valuation report. For a single location wholesaler or a small online store, this gives you a perpetual inventory and a gross margin you can trust, inside the system your accountant already uses.

One pool of stock, no locations

Xero holds one quantity per item for the whole organisation. It has no concept of a warehouse, a shop, a 3PL or stock in transit between them. Tracking categories can split revenue and costs by location, but they do not split quantity on hand, so the moment stock lives in two places you are back to spreadsheets for the question that matters most: where is it?

No batches, serials, assemblies or landed cost

Xero does not track batch or lot numbers, expiry dates or serial numbers. It has no bill of materials, so it cannot consume components when you build a finished product or a kit. Purchase orders exist, but there is no warehouse style receiving against partial deliveries, and no way to allocate freight, duty and customs charges across the lines of a shipment so they land in the unit cost.

Limits on tracked items and volume

Xero’s own guidance says tracked inventory is not suitable for an organisation with more than 4,000 items to track, and opening balances can only be imported for up to 4,000 tracked items. The same guidance lists ecommerce order channels, purchase order receipting and assembling goods from tracked components as cases it does not suit. Limits change from time to time, so check the current Xero documentation rather than relying on this page. If you are close to the ceiling, that alone is a reason to plan rather than wait.

Six Things That Change When an Inventory App Takes Over

Adding Cin7, Unleashed, Katana or a similar system moves responsibilities between systems, and each one has to be moved deliberately.

One source of quantity

Stock master moves out of Xero

The inventory app becomes the only system that knows quantity on hand, by location, batch and serial where relevant. Shopify, the POS and any marketplace read availability from it. Xero stops tracking quantity entirely, because two systems each holding a quantity will drift apart within days and you will not be able to say which is right.

Cost calculated once

COGS master moves with it

Cost of goods sold is calculated in the inventory app, using its costing method and including landed costs, then sent to Xero as journals or as cost lines on the posted transactions. Xero no longer calculates COGS itself. If both systems post COGS, margin is understated by exactly the cost of everything you sold, which is an alarming but easily diagnosed result.

Invoices, bills, GST

Xero keeps the money

Xero remains the ledger: sales invoices or daily summaries, supplier bills, payments, bank reconciliation, GST and BAS. The inventory app pushes these across, usually with untracked item codes or account codes only. Your accountant still works entirely in Xero, and BAS preparation does not change, provided the tax codes on synced transactions are mapped correctly.

Receive, then bill

Purchasing moves to the inventory app

Purchase orders are raised, received (including partial deliveries) and costed in the inventory app. The supplier bill is created in Xero once the invoice arrives, either pushed from the app or matched against the receipt. Freight and duty bills are allocated to the shipment in the app before they hit the ledger, so unit costs include them.

Shopify to app to Xero

Order flow is re-routed

Before the move, orders often flow straight from Shopify or the POS into Xero. Afterwards they flow into the inventory app first, which allocates stock, drives fulfilment and then posts the financial result to Xero. Any existing direct Shopify to Xero connector has to be switched off or reconfigured on the cutover date, or every sale lands in Xero twice.

App value equals ledger

Valuation is reconciled monthly

At each month end the stock valuation report from the inventory app should equal the inventory asset account balance in Xero. A small explained difference is normal during the first months, an unexplained and growing one is not. The detailed method for chasing variances is covered on our stock ledger reconciliation page, the point here is that the check exists from the first month.

Symptoms You Have Outgrown Xero Inventory, and What Fixes Each One

Task	Traditional	Done Properly	Notes
Stock counts live in a spreadsheet	Xero quantity ignored, sheet is the truth	Counts done in the stock system, posted as adjustments	If nobody believes the Xero quantity, the inventory feature is costing you effort without giving you anything back.
Overselling on Shopify	Shopify and Xero quantities disagree	One stock master feeding every channel	Sometimes the fix is making Shopify the master for a simple single location business, not buying anything new.
A second location or a 3PL	Location split kept by hand	Quantity by location, transfers recorded	This is a common trigger. Xero has no locations for stock, and tracking categories do not solve it.
COGS fixed by month end journal	Bookkeeper estimates cost of sales	COGS posted from the stock system at actual cost	A recurring COGS journal usually means tracked items were abandoned quietly some time ago.
Products built from components	Components adjusted out manually	Bill of materials consumes stock on build	Kits and bundles sold online are a lighter version of the same problem, see our bundles and kits page.
Batches, expiry dates or serials	Recorded on paper or not at all	Tracked from receipt to sale	Food, cosmetics, supplements and electrical goods often need this for recalls and warranty claims.
Freight and duty on imports	Expensed, so margins look wrong	Landed cost allocated to the unit cost	Without landed cost, imported lines look more profitable than they are and local lines look worse.
Partial supplier deliveries	PO edited or bill raised early	Partial receipts against the PO	Raising the bill before the goods arrive inflates stock on hand and causes overselling.

Where the Move Off Xero Inventory Goes Wrong

Both systems tracking stock after cutover

A common error. The inventory app is live, but the items are still tracked in Xero, so every synced sale reduces stock twice and posts COGS twice. Before go live, decide that the inventory app is the only stock and COGS master, stop tracking the items in Xero, and make sure every synced invoice and bill uses untracked item codes or account codes. Check the first week of postings line by line.

Untracking items in Xero without a plan for the value

Xero locks the untrack option on any tracked item that has been used in a transaction or adjusted. Its documented route is to create a new untracked item with a new code, adjust the tracked item’s quantity to zero (the value moves to the account you choose on the adjustment), then archive the old item. Xero’s inventory asset account type is a system account that cannot be journalled to, so inventory apps usually post to a separate stock asset account. Agree the treatment with your accountant before you touch a single item. The usual aim is that total stock value on the balance sheet is the same before and after, now held in the account the inventory app maintains, and that the integration posts with the new item codes.

Opening balances taken from Xero quantities nobody trusts

If Xero quantities were already wrong, importing them into the new system just moves the problem. Do a full stocktake as close to the cutover date as practical, load counted quantities by location, and post the difference between counted value and the Xero inventory balance as a single, documented stocktake adjustment on cutover day. That is one explainable entry instead of a year of unexplained ones.

Losing average cost history

Your current average costs in Xero are the starting cost for every item in the new system. Load them as the opening unit cost, not the latest supplier price, otherwise the first month of COGS will be wrong and margins will jump for no real reason. Export the Xero inventory valuation at cutover, keep it with the opening balance file, and check that the opening value in the app matches it after any stocktake adjustment.

Old connectors left running

A Shopify or POS connector that posts directly to Xero will keep running unless someone switches it off. On cutover day, orders must route through the inventory app only. List every integration that writes to Xero before you start, decide which ones stay, which are reconfigured and which are retired, and confirm the switch in writing. Duplicate revenue is easy to create and tedious to unwind.

Choosing the system before the requirement

Inventory apps differ meaningfully: some are strong at multichannel retail and wholesale, some at manufacturing, some at warehouse operations. A demonstration of features you will never use tells you little. Write down your locations, channels, whether you manufacture or assemble, whether you need batches or serials, and your monthly order volume, then test candidates against those scenarios with your own data.

How Yes AI Helps With the Move

An honest outgrown or not assessment

We look at how you actually use Xero inventory today, your channels, locations and products, and tell you whether you need a new system at all. Sometimes the answer is a tidy up of item setup and a correctly configured Shopify connection, and we will say so.

Requirements and option comparison

A short, specific requirements list and a comparison of the realistic options for your business: staying on Xero, adding an inventory app such as Cin7, Unleashed or Katana, or moving to an ERP. We are not resellers of any of them, so the recommendation follows the requirement.

The integration and the cutover plan

We configure the sync between the inventory app, Xero and your sales channels, design the account and tax code mapping with your accountant, and run the cutover: stocktake, opening balances, untracking, connector switch over and the first postings checked line by line.

Monthly valuation check after go live

For the first months we compare the inventory app valuation against the Xero inventory asset account each month end, explain any difference, and fix the cause rather than journalling it away. The check runs on a managed cloud automation layer we operate, with alerts when it drifts.

From Xero Tracked Items to a Clean Cutover

Five steps. The order matters more than the speed: most problems in this move come from doing step four before step two.

Assess and decide

Review current Xero item setup, channels, locations and volumes. Decide between tidy up, inventory app or ERP, and write the requirement down before looking at any demonstrations.

Design the responsibilities

Agree which system owns stock, COGS, purchasing, pricing and customers, how sales post to Xero (per order or summary), and the account and tax code mapping, with your accountant signing it off.

Build and test in parallel

Configure the inventory app and its Xero and channel connections, load products and costs, and test with a sample of real orders, bills and returns against a Xero demo or test organisation where practical.

Cut over on a count

Stocktake at the cutover date, load counted opening balances at Xero average cost, replace tracked items in Xero with untracked ones using the agreed treatment, switch order flow to the inventory app and retire the old direct connectors.

Reconcile and settle in

Check the first week of postings line by line, then reconcile the app valuation to the Xero inventory account at each month end until the difference is consistently small and explained.

FAQ

How do I know if I have outgrown Xero inventory?

The clearest signs are practical rather than technical. Stock counts are kept in a spreadsheet because nobody trusts the Xero quantity. You hold stock in more than one place. Shopify or the POS regularly disagrees with Xero and you oversell. You build or assemble products. You need batch, expiry or serial tracking. Your bookkeeper posts a cost of goods sold journal at month end instead of relying on Xero. You import goods and freight is distorting your margins. Any two of these together usually means it is time to plan the move.

What are the main Xero inventory management limitations?

At a general level: one stock quantity per item with no locations, no batch or serial tracking, no bill of materials or assembly builds, no warehouse style receiving of partial deliveries against purchase orders, no landed cost allocation, and limits on the number of tracked items. Xero adds and changes features over time, so check the current Xero documentation and plan limits rather than relying on an older article, including this one. Xero also sells a separate Inventory Plus product with multi-location stock in the United States; check whether it is offered in Australia when you read this. The underlying point stays the same: Xero is an accounting system with inventory features.

Should we add an inventory app or move to an ERP?

An inventory app that syncs to Xero suits most growing product businesses: multiple locations, several sales channels, purchasing and landed cost, with Xero staying as the ledger your accountant already knows. Katana and similar tools suit light manufacturing, while Cin7 and Unleashed cover multichannel retail, wholesale and assembly in different ways. An ERP such as MYOB Acumatica, NetSuite or Dynamics 365 Business Central becomes worth considering when you need everything in one system, have several entities, complex manufacturing or project costing, or the number of integrated apps has become a burden of its own.

Can we keep Xero and just make Shopify the stock master?

For a simple case, yes. A single location business selling mainly through Shopify, or Shopify plus Shopify POS, with no manufacturing and no batches, can let Shopify hold quantities and use Xero untracked items or account codes for the financials, with COGS posted from a periodic valuation. It is cheap and it works. It stops working when you add a wholesale channel, a second warehouse, purchase orders with partial deliveries or a need for accurate perpetual COGS, which is usually when a dedicated inventory app earns its cost.

What happens to GST when we move stock management out of Xero?

Moving stock management does not change your GST position in itself, because GST arises on sales and purchases, not on internal stock movements or system changes. What does need checking is that the invoices and bills synced from the inventory app carry the correct tax codes in Xero, including GST free lines, imported goods where GST was paid at the border, and freight. Agree the mapping with your accountant before go live and review the first BAS period after cutover carefully.

How much does it cost to move off Xero inventory?

It varies widely. Inventory app subscriptions generally run from a few hundred to a few thousand dollars a month depending on users, locations, channels and order volume, so check current vendor pricing. Implementation by the vendor or a partner, including data load, configuration and training, is a separate cost that depends on your products, locations and integrations, so ask for a written quote. Integration work, cutover and reconciliation support sit on top. An ERP is a materially larger project. We price our part once the scope is written down.

What if we have not really outgrown it?

Then do not move. Many businesses blame Xero for problems caused by setup: items created as untracked by mistake, bills raised before goods arrive, inventory adjusted through journals instead of inventory adjustments, a Shopify connector posting with the wrong item codes, or no stocktake for two years. Fixing those, doing a proper count and agreeing a simple monthly routine often restores trust in the Xero numbers for a fraction of the cost of a new system, and buys time to plan properly when the real triggers arrive.

Find Out Whether You Have Actually Outgrown It

Book a call. We review how you use Xero inventory today, tell you plainly whether to tidy up, add an inventory app or look at an ERP, and give you a priced cutover plan if a move makes sense. The review is yours either way.