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 are raised once in the inventory system and pushed across to Xero, and reference data comes back the other way
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 keeps them in step 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 be ready to go straight to Xero as an accounts receivable entry, with no re-keying involved. In Frostbyte Pro a single sync from the integrations page sends it across. 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)
Once that sync runs, your accounts receivable in Xero is up to date and nobody has typed the invoice twice.
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 be ready to push to Xero as an accounts payable entry. In Frostbyte Pro that is the same one action from the integrations page, and completed or received orders go across together. This includes:
- Supplier name (matched to the Xero contact)
- Line items with product codes, quantities, and costs
- GST
- Bill reference number
- Due date
Once the bills are across, your accounts payable in Xero is current, and you can schedule payments through Xero's normal payment processes.
Payments
Flow: Stays in Xero on most setups
Payments are the one area that usually stays on the accounting side. You reconcile customer payments and pay supplier bills in Xero, against the invoices and bills your inventory system has already created there, and Xero remains the record of who has paid and who hasn't.
Some platforms do read payment status back into the inventory system. Frostbyte Pro does not sync payments in either direction, so if you want paid and unpaid status in front of your warehouse team rather than your finance team, ask each vendor about it specifically.
Cost of Goods Sold (COGS)
Flow: Inventory system --> Xero, on some platforms
Some inventory platforms calculate COGS from the actual cost of the specific units (or batches) sold and post a journal entry to Xero. That entry is typically:
- Debit: Cost of Goods Sold (expense account)
- Credit: Inventory (asset account)
Where a platform posts those journals, your Xero profit and loss shows gross margins without anyone touching a spreadsheet. Where it doesn't, and that includes Frostbyte Pro today, costing and margin reporting live in the inventory system and your accountant handles the COGS journal in Xero the way they do now. Ask which of the two you're buying, because it changes what month end looks like.
Inventory Adjustments
Flow: Inventory system --> Xero, on some platforms
Inventory adjustments (stock take variances, damage write-offs, expired stock disposal) have a financial impact, and some platforms push that impact to Xero as a journal. 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
Frostbyte Pro records these adjustments in full on the inventory side, with the quantity, the reason and the user against every adjustment, but it does not post an adjustment journal into Xero. If you want the write-off value in your accounts, that stays a job for your accountant.
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 goes to Xero from there instead of being retyped. This saves time (typically 5-10 hours per week for a mid-sized business) and eliminates transcription errors.
2. Receivables and Payables You Can Trust
Invoices and bills are built once, in the system that knows the stock, and they carry their line items, quantities, prices and tax codes across to Xero exactly as raised. Run the sync as often as suits you, daily or at the end of a picking run, and your receivables and payables in Xero are as current as your last push rather than as current as the last typing session. Nothing is waiting in a pile at month end.
3. Accurate COGS and Margins
When your inventory system tracks actual costs at the batch or product level, 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 rather than an average that was last reviewed a year ago.
4. Correct Inventory Valuations
Your inventory system holds a current value of stock on hand, updated as stock is received, sold, adjusted, or written off, so the closing figure you hand your accountant is a real number rather than an estimate. This matters for accurate financial reporting and, for some businesses, for meeting bank covenant requirements.
5. Simpler 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
Native Xero integration that works in both directions. Sales invoices and purchase bills push across to Xero in one action from the integrations page, with full line detail and GST, contacts match and create both ways, and products, customers and existing invoices import from Xero on a half-hourly schedule when you switch auto sync on. Payments and COGS journals are not synced. 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, and in which direction? Ask about the two directions separately, because they rarely work the same way. Imports from Xero are often scheduled or triggered by Xero itself, while sending invoices and bills the other way may be something a person runs. In Frostbyte Pro, imports run every half hour once you switch auto sync on, contact and invoice changes made in Xero come through in real time, and pushes to Xero are always yours to trigger. If a vendor just says "real time", ask which half of the integration they mean.
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.
- Vague answers about what syncs. Every integration has a boundary somewhere. A vendor who can name theirs is easier to trust than one who says everything syncs, because then you find the gap in month two.
- 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:
- Revenue accounts, where sales income is posted. You might keep one revenue account or several (by product category, by channel, etc.), but check how many your inventory system can actually post to. Frostbyte Pro posts sales to a single revenue code you choose, so any finer split is done in Xero.
- A purchase or direct costs account, where supplier bills land. This is the account your synced bills will code to by default.
- Inventory asset account, typically "Inventory" under Current Assets. This is where the value of stock on hand sits on your balance sheet, and you'll need it if your platform posts COGS or adjustment journals.
- Expense accounts for adjustments, such as a "stock write-off" or "inventory adjustment" account, again only if your platform posts those journals for you.
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?
- Purchase bills --> which expense or direct costs account?
- Tax codes --> check your GST codes come across correctly
- Journals for COGS and adjustments --> only if the platform posts them, which account codes?
In Frostbyte Pro this step is short, because there are two codes to set: one for sales revenue and one for purchases and cost of goods. There is no mapping per product or per category, and for invoices and bills there is no inventory asset or bank account to nominate.
Step 4: Sync Contacts
Your customers and suppliers need to exist in both systems. Most integrations offer:
- Create on sync. When a contact exists in the inventory system but not in Xero, the sync creates it in Xero rather than failing
- Match by name or code. Link existing contacts between the two systems
- Manual mapping. For contacts the matching rules can't place
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. Run the sync from the integrations page, 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 test the other direction: import a contact or a product from Xero and check it lands in the inventory system with the right code, price and tax treatment.
If all three tests pass, your integration is working.
Step 6: Go Live
Start processing all transactions through the inventory system, and make the push to Xero part of someone's routine, whether that is end of day or end of week. For the first week, spot-check daily that everything you pushed landed 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, carries data both ways, and is built for NZ businesses:
- Sales invoices push across to Xero as accounts receivable with full line item detail, GST, and customer matching. When you invoice a sales order in Frostbyte Pro it is ready to go to Xero, and a single sync from the integrations page sends it across with the right line items, quantities, prices and tax codes
- Purchase bills push across as accounts payable, with the Frostbyte Pro order number carried across as the bill reference so the two systems tie up
- Contact sync matches customers and suppliers to your Xero contacts and creates the ones that don't exist yet, one at a time or in bulk
- Bulk pushes cover the orders that are actually finished: dispatched and completed sales orders, and completed or received purchase orders, so nothing half-done lands in your accounts
- Imports from Xero bring your products and items, customers, inventory, and existing Xero invoices into Frostbyte Pro, with imported invoices arriving as sales orders
- Account codes are yours to choose from your live Xero chart of accounts: one code for sales revenue and one for purchases and cost of goods, so both sides post where your accountant expects them
- GST handling supports inclusive, exclusive, and zero-rated transactions as per NZ requirements, with tax applied by jurisdiction and each document carrying its own currency code
Imports from Xero run on a half-hourly schedule when you switch auto sync on, and you can run any of them on demand instead. Changes you make in Xero to contacts and invoices also come through in real time, because Xero notifies Frostbyte Pro directly. Pushes are the other way around: nothing leaves Frostbyte Pro for Xero on its own, so you run them from the integrations page and you decide when a batch of invoices or bills goes across.
Two things it deliberately does not do. Payments are not synced in either direction, so Xero stays the single record of what has been paid. COGS and stock adjustment journals are not posted to Xero either, so costing and margin reporting sit in Frostbyte Pro and your accountant handles the journal side. We would rather tell you that up front than have you find it in your first month end.
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 a native Xero integration? Start a free trial of Frostbyte Pro and connect it to your Xero account in minutes. No credit card required.