Xero is brilliant accounting software. According to industry estimates, over 70% of NZ small businesses use it, and for good reason. It handles invoicing, bank reconciliation, payroll, GST returns, and financial reporting exceptionally well. Your accountant loves it. Your bookkeeper loves it. It's a cornerstone of most NZ business operations.
But Xero is not inventory management software. And trying to use it as one is a common mistake that causes real problems as your business grows. This guide explains what Xero inventory management really involves: what Xero can and can't do for inventory, why you need a dedicated system alongside it, and how the two work together.
What Xero Does for Inventory
Xero has basic inventory features built in. It's important to understand what they are, and their limitations.
What Xero Can Do
- Track a simple product list. You can create "inventory items" in Xero with a name, code, description, purchase price, and sell price
- Track quantities. Xero maintains a quantity on hand for each inventory item, updated as you create invoices and bills
- Calculate basic COGS. When you sell an item, Xero reduces the inventory quantity and records a cost of goods sold entry based on the weighted average cost
- Inventory valuation. Your balance sheet shows the total value of inventory on hand
- Include items on invoices and bills. You can add inventory items to sales invoices and purchase bills, and Xero adjusts quantities accordingly
- Create purchase orders. Xero does have a purchase order feature. You can create and send POs to suppliers, and Xero Inventory Plus (an add-on tier) includes an enhanced PO experience with improved receipting workflows
What Xero Can't Do (or Does Poorly)
This is where the limitations become apparent:
Purchase orders are basic. Xero does have purchase orders, and you can create and send them to suppliers. However, the standard PO workflow is limited: there's no three-way matching between PO, goods receipt, and bill, no goods-in-transit tracking, and receipting stock against a PO requires manual steps rather than a guided workflow. Xero Inventory Plus adds some improvements here, but it still falls well short of what a dedicated inventory system provides. For a deeper look at what proper PO management looks like alongside Xero, see our guide to purchase order software in NZ.
No warehouse or location tracking. Xero has one quantity per product. It doesn't know if your stock is in Auckland or Christchurch, on the shelf or in the cold store, in the pick face or in bulk storage. If you have stock in multiple locations, Xero can't tell you where.
No batch tracking. Xero doesn't track batch numbers, serial numbers, or expiry dates. For food manufacturers, cosmetics producers, and anyone subject to MPI traceability requirements, this is a non-starter. You can't trace a product back to its raw material batches in Xero. See our batch tracking guide for what proper traceability looks like.
No manufacturing or BOM support. Xero doesn't understand bills of materials, production orders, or work-in-progress. If you manufacture or assemble products, Xero can't track the conversion of raw materials into finished goods.
Limited stock take support. Xero's standard plan lets you manually adjust inventory quantities, but there's no structured stock take process, variance reporting, or audit trail. Xero Inventory Plus adds basic inventory count assistance, but it lacks the zone-based counting, cycle count scheduling, and approval workflows that a dedicated inventory system provides.
No reorder points or low-stock alerts. Xero doesn't tell you when you're running low on a product. There are no automated reorder points, no alerts when stock drops below a threshold, and no purchase order generation.
No barcode scanning. There's no way to scan barcodes for receiving, picking, or counting. Everything is manual data entry.
No pick-pack-dispatch. Xero doesn't manage the fulfilment process. You can create an invoice, but there's no pick list, no packing slip workflow, and no dispatch tracking.
Limited reporting. Xero's inventory reports cover basic stock on hand and inventory value. You can't run detailed movement reports, slow-moving stock analysis, demand forecasting, or supplier performance analysis.
Limited scale. Xero's tracked inventory has a hard ceiling of around 4,000 items. Beyond that, you'll need to move products to untracked. More practically, the operational limitations (single location, no batch tracking, basic POs) become painful long before you hit that item limit, typically once you have multiple staff, multiple warehouses, or any manufacturing complexity.
The Core Issue
Xero is accounting software that happens to have basic inventory tracking. It's not inventory management software that happens to do accounting. The inventory features exist so that COGS and inventory valuations flow correctly into your financial reports, not to manage warehouse operations, production, or supply chain logistics.
This is an important distinction, and it's not a criticism of Xero. Xero is excellent at what it's designed to do. But trying to stretch it into a role it wasn't built for creates workarounds, manual processes, and data gaps that grow more painful over time.
Why You Need a Dedicated Inventory System Alongside Xero
The Problems That Build Up
When businesses try to manage inventory solely in Xero, several problems typically emerge:
Manual workarounds multiply. You start tracking batch numbers in a spreadsheet. Then reorder points. Then warehouse locations. Then production orders. Before long, you have a constellation of spreadsheets, notes, and manual processes surrounding Xero, each maintained by a different person, none of them integrated, and all of them fragile.
Data entry doubles. When you receive goods, you enter the details into your spreadsheet AND create a bill in Xero. When you ship an order, you update your spreadsheet AND create an invoice in Xero. Every transaction is entered twice, which means twice the effort and twice the opportunity for errors.
Stock levels drift. Because Xero only updates quantities through invoices and bills, any inventory movement that doesn't involve a financial transaction (internal transfers, production consumption, damage write-offs, samples) doesn't get captured. Your Xero stock levels gradually diverge from reality.
COGS becomes unreliable. If your stock quantities in Xero are wrong, your cost of goods sold is wrong, your gross margin is wrong, and your profit and loss statement is wrong. You're making business decisions based on inaccurate financials.
Compliance gaps appear. For regulated industries (food, cosmetics, supplements), the combination of Xero plus spreadsheets doesn't provide the traceability audit trail that MPI or other regulators require. In an audit or recall situation, you need purpose-built traceability, not a collection of spreadsheets.
The Right Architecture
The solution isn't to replace Xero. It's to complement it. The right architecture for a NZ product business is:
- Xero handles accounting: financial reporting, bank reconciliation, payroll, GST returns, accounts receivable, accounts payable
- Inventory management software handles operations: stock levels, warehouse management, purchasing, sales fulfilment, manufacturing, batch tracking
- Integration connects the two: financial transactions flow from the inventory system into Xero automatically
This gives you the best of both worlds. Your operations run through a system designed for operations. Your accounting runs through a system designed for accounting. And the integration ensures they stay in sync without double entry.
How Inventory Software Integrates with Xero
Good Xero integration isn't just "it connects to Xero." The quality and depth of integration varies significantly between platforms. Here's what should sync and how.
Sales Invoices
Flow: Inventory system --> Xero
When you complete a sales order and generate an invoice in your inventory system, that invoice should automatically appear in Xero as an accounts receivable entry. The invoice should include:
- Customer name (matched to the Xero contact)
- Line items with product codes, descriptions, quantities, and prices
- GST calculated correctly
- Due date and payment terms
- Invoice number (either generated by the inventory system or following Xero's numbering)
Your accounts receivable in Xero is now up to date without any manual entry.
Purchase Bills
Flow: Inventory system --> Xero
When you receive goods against a purchase order and confirm the supplier bill in your inventory system, the bill should sync to Xero as an accounts payable entry. This includes:
- Supplier name (matched to the Xero contact)
- Line items with product codes, quantities, and costs
- GST
- Bill reference number
- Due date
Your accounts payable in Xero stays current, and you can schedule payments through Xero's normal payment processes.
Payments
Flow: Xero --> Inventory system (or bi-directional)
When a customer pays an invoice and you reconcile it in Xero, the payment status should flow back to your inventory system so you can see which invoices are paid. Similarly, when you pay a supplier bill in Xero, the payment status updates in the inventory system.
This two-way payment sync means you don't need to check two systems to see if a customer has paid or if a supplier has been paid.
Cost of Goods Sold (COGS)
Flow: Inventory system --> Xero
When a product is sold, the inventory system calculates the COGS based on the actual cost of the specific units (or batches) sold and posts a journal entry to Xero. This is typically:
- Debit: Cost of Goods Sold (expense account)
- Credit: Inventory (asset account)
If your inventory system does this correctly, your Xero profit and loss shows accurate gross margins, and your balance sheet shows the correct inventory asset value.
Inventory Adjustments
Flow: Inventory system --> Xero
When you make inventory adjustments (stock take variances, damage write-offs, expired stock disposal), the financial impact should sync to Xero. Typically:
- Positive adjustments (found more stock than expected): Credit adjustment account, Debit inventory
- Negative adjustments (less stock than expected): Debit adjustment account (or write-off/shrinkage account), Credit inventory
What Shouldn't Sync
Not everything needs to go to Xero. Operational data like:
- Warehouse locations and bin assignments
- Pick lists and dispatch details
- Production order specifics
- Batch numbers and expiry dates
- Stock transfer details between warehouses
These stay in your inventory system. Xero doesn't need this level of operational detail. It needs the financial transactions that result from these operations.
Key Benefits of Integration
1. No Double Entry
This is the biggest benefit. Every transaction is entered once, in the inventory system, and the financial data flows to Xero automatically. This saves time (typically 5-10 hours per week for a mid-sized business) and eliminates transcription errors.
2. Real-Time Financial Accuracy
Because transactions sync as they happen (or at short intervals), your Xero financials are always current. You can run a P&L at any time and trust that the COGS and inventory values are accurate. No waiting for end-of-month reconciliation.
3. Accurate COGS and Margins
When your inventory system tracks actual costs at the batch or product level and syncs COGS to Xero correctly, your gross margin data is reliable. You can see which products are profitable and which aren't, and make pricing decisions based on real numbers.
4. Correct Inventory Valuations
Your Xero balance sheet shows the current value of inventory on hand, updated in real time as stock is received, sold, adjusted, or written off. This is critical for accurate financial reporting and, for some businesses, for meeting bank covenant requirements.
5. Streamlined GST Returns
When all sales and purchase transactions flow through a single integrated system, GST is calculated consistently and your GST returns (filed through Xero) are accurate. No manual reconciliation of GST across multiple systems.
6. Audit Trail
The integration creates a clear audit trail: every transaction in Xero can be traced back to the originating transaction in the inventory system (and vice versa). Auditors and accountants can verify the trail from a sales invoice in Xero back to the dispatch note, pick list, and sales order in the inventory system.
Popular Xero-Integrated Inventory Options in NZ
Several inventory management platforms integrate with Xero and are used by NZ businesses. Here's a brief overview of the most common options:
Frostbyte Pro
Deep, bi-directional Xero integration with real-time sync. Sales invoices, purchase bills, payments, COGS, and inventory adjustments all flow automatically. NZ-built, NZD pricing, designed for manufacturers and food producers. Strong batch tracking and manufacturing capabilities. See features for details.
Unleashed (by MYOB)
One of the original Xero-integrated inventory platforms in NZ. Solid integration for sales, purchasing, and financial data. Now owned by MYOB, so there's a natural pull toward MYOB integration, but Xero integration remains available and functional.
Cin7 Core (formerly DEAR Systems)
Comprehensive Xero integration covering invoices, bills, payments, and inventory. Feature-rich platform with strong multi-channel capabilities. USD pricing.
Katana MRP
Xero integration for syncing financial data from manufacturing operations. Good for small manufacturers who need production planning alongside inventory management. USD pricing.
inFlow Inventory
Xero integration for invoices and financial data. Straightforward inventory management without manufacturing features. USD pricing.
Zoho Inventory
Limited Xero integration that works best with Zoho Books (Zoho's own accounting software). If you're committed to Xero, the integration may not be as deep or reliable as other options.
For a detailed comparison of all these options, see our Best Inventory Management Software in NZ for 2026 guide.
How to Evaluate Xero Integration Quality
Not all Xero integrations are equal. When evaluating an inventory platform, test the integration specifically:
Questions to Ask
Is the integration native or through a third party? Native integrations (built by the software provider) are typically more reliable and better maintained than third-party connectors like Zapier.
What syncs, exactly? Get a specific list: invoices, bills, payments, credit notes, COGS journals, inventory adjustments. If something you need doesn't sync, you'll be entering it manually.
How often does it sync? Real-time (within seconds), near-real-time (every few minutes), or batch (hourly/daily)? For most businesses, near-real-time is fine. Daily batch sync can cause issues with intraday reporting.
How are contacts matched? Does the system match customers and suppliers between the inventory system and Xero by name, email, or code? What happens when there's no match? Does it create a new contact, or does it error?
How is GST handled? Does the integration correctly handle GST-inclusive and GST-exclusive pricing, zero-rated exports, and GST-exempt items?
What happens when the integration breaks? It will happen eventually (a sync error, a Xero API change, a network issue). How does the system notify you? Is there a retry mechanism? Can you manually re-sync? How quickly does the provider fix integration issues?
Can you disconnect and reconnect? If you need to change Xero organisations (e.g., restructuring your business), can you disconnect the integration and reconnect to a different Xero org without losing data?
Red Flags
- "We integrate with Xero via Zapier." This means they don't have a native integration. Zapier works but it's slower, less reliable, and limited in what data it can sync.
- One-directional sync only. If invoices go to Xero but payment statuses don't come back, you're checking two systems.
- Manual mapping required for every transaction. If you have to manually map accounts and tax codes for each sync, the integration isn't mature.
- No error handling or notifications. If a sync fails silently and you don't find out until your accountant notices a discrepancy weeks later, that's a problem.
Setting Up the Integration: A Practical Walkthrough
When you're ready to connect your inventory system to Xero, here's the typical process:
Step 1: Prepare Xero
Before connecting, make sure your Xero chart of accounts is set up correctly:
- Inventory asset account, typically "Inventory" under Current Assets. This is where the value of stock on hand sits on your balance sheet.
- Cost of goods sold account, under Direct Costs or Expenses. This is where COGS is recorded when stock is sold.
- Revenue accounts, where sales income is posted. You might have one revenue account or several (by product category, by channel, etc.).
- Expense accounts for adjustments, such as a "stock write-off" or "inventory adjustment" account for non-sale stock movements.
Step 2: Authorise the Connection
Your inventory system will guide you through an OAuth authorisation flow:
- In the inventory system, go to Settings > Integrations > Xero
- Click "Connect to Xero"
- You'll be redirected to Xero to log in and authorise the connection
- Select the Xero organisation you want to connect to
- Confirm the permissions
This typically takes 2 minutes.
Step 3: Map Accounts
Configure which Xero accounts your transactions should post to:
- Sales invoices --> which revenue account(s)?
- Purchase bills --> which expense or inventory account(s)?
- COGS --> which cost of goods sold account?
- Inventory value --> which asset account?
- Tax codes --> map your GST codes
Step 4: Sync Contacts
Your customers and suppliers need to exist in both systems. Most integrations offer:
- Auto-create. When a contact exists in the inventory system but not in Xero, automatically create it in Xero
- Match by name or code. Link existing contacts between the two systems
- Manual mapping. For contacts that don't match automatically
Clean up duplicates before syncing. "Fresh Mart Ltd" and "Freshmart Limited" in Xero will cause issues if the inventory system knows them as "Fresh Mart Ltd."
Step 5: Test with a Real Transaction
Create a test sales order in the inventory system, complete it, and generate an invoice. Then check Xero:
- Did the invoice appear?
- Is the customer correct?
- Are the line items, quantities, and prices correct?
- Is GST calculated correctly?
- Is it posted to the right revenue account?
Repeat with a purchase bill. Then mark the invoice as paid in Xero and verify the payment status updates in the inventory system.
If all three tests pass, your integration is working.
Step 6: Go Live
Start processing all transactions through the inventory system and let the integration handle the Xero side. For the first week, spot-check daily that transactions are syncing correctly. After that, a weekly check is usually sufficient.
Common Integration Mistakes
1. Entering Transactions in Both Systems
After connecting the integration, stop creating invoices and bills directly in Xero. If you create an invoice in the inventory system AND create it manually in Xero, you'll have duplicates. All sales and purchase transactions should originate in the inventory system and sync to Xero.
2. Not Reconciling After Go-Live
In the first month, check that your Xero bank reconciliation, P&L, and balance sheet look correct. The integration changes how data flows into Xero, and if account mappings are slightly wrong, the impact compounds over time. Catching it in week one is much easier than untangling it in month six.
3. Ignoring Sync Errors
When a sync fails (and it will occasionally, whether from a network timeout, Xero rate limit, or data validation error), don't ignore it. Investigate, fix the issue, and re-sync the failed transaction. Unsynced transactions create discrepancies between your inventory system and Xero.
4. Mismatching Opening Balances
When you go live, your inventory value in the inventory system and your inventory asset in Xero should match. If they don't, every subsequent transaction compounds the discrepancy. Reconcile the opening position before you start transacting.
How Frostbyte Pro Integrates with Xero
Frostbyte Pro's Xero integration is native, bi-directional, and designed for NZ businesses:
- Sales invoices sync to Xero in near-real-time with full line item detail, GST, and customer matching
- Purchase bills sync when goods are receipted and the bill is confirmed
- Payments flow back from Xero, updating invoice and bill statuses in Frostbyte Pro
- COGS journals are posted automatically when goods are dispatched, using actual batch costs for accurate margin reporting
- Inventory adjustments (stock take variances, write-offs, production consumption) are reflected in Xero's inventory asset account
- Contact sync with automatic matching and creation for new customers and suppliers
- GST handling supports inclusive, exclusive, and zero-rated transactions as per NZ requirements
The integration is maintained by our development team and updated promptly when Xero releases API changes. Support is available during NZ business hours.
Explore the full feature set or check pricing to see how Frostbyte Pro fits alongside your Xero setup.
Ready to stop fighting with spreadsheets and start managing your inventory properly, with seamless Xero integration? Start a free trial of Frostbyte Pro and connect it to your Xero account in minutes. No credit card required.