What QuickBooks export file format does this tool accept?

This tool accepts QuickBooks Online Products CSV files. Export from QuickBooks and upload the CSV file directly.

Can I convert QuickBooks CSV to Xero Inventory Items?

Yes, this tool converts QuickBooks Online Products CSV exports directly to Xero Inventory Items CSV format compatible with Xero Inventory Items.

How do I import QuickBooks online products to Xero Inventory Items?

Export your online products from QuickBooks, upload the CSV file to this converter, then import the converted file to Xero Inventory Items.

Convert QuickBooks Online Products to Xero Inventory

🥦

Xero Inventory Items CSV Format

valid rows

Migrate your QuickBooks Online product catalog to Xero. Convert products and services with pricing, SKUs, and account mappings.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample

Sample QBO product export CSV

Download

Tool Rating

4.5 / 5 (42 votes)

How to Convert QBO Products → Xero

Export from Quickbooks Online

Gear icon → Products and Services → Export to Excel

Upload and Configure

Upload QBO Products & Services Export CSV and choose Inventory Item format

Preview and Download

Review converted data, download Xero-ready file

Import to Xero

Accounting → Inventory → Import → Upload CSV

Output is in Xero Inventory Items CSV format — ready to import directly, no manual reformatting needed.

QBO Products → Xero Conversion Questions

What product fields are converted?

We convert name, SKU, description, sales price, purchase price, sales account, purchase account, inventory asset account, COGS account, and taxable status. Quantity on hand is not transferred - use opening balances.

How are services handled?

QuickBooks services convert to Xero items with IsSold=TRUE but IsTrackedAsInventory=FALSE. They appear in Xero's item list but don't track inventory levels.

What happens to inventory quantities?

Current stock quantities are not transferred. After importing items, use Xero's inventory adjustment feature to set opening stock levels with appropriate dates.

Common Inventory Item Import Errors

Issues you might encounter when importing QBO Products & Services Export data to Inventory Item - and how we solve them

Duplicate Item Code

Xero requires unique item codes

WIDGET (appears twice)

WIDGET, WIDGET-2

We auto-append numbers to duplicate codes

Review item codes after import

Item Code Exceeds 30 Characters

Xero limits item code to 30 chars

Codes are truncated automatically

Use shorter SKUs in source data

Account Codes Not Mapped

Account names don't translate to Xero codes

Set default account codes in options

Import CoA first, then re-run with correct codes

Why QuickBooks Product Exports Need Conversion for Xero

Item Code Requirements

Xero requires a unique ItemCode (max 30 characters) for each inventory item. QuickBooks uses product names and optional SKUs. Our converter generates valid Xero item codes from your SKUs or product names, ensuring compatibility.

Inventory vs Service Items

QuickBooks has Inventory, Non-Inventory, and Service item types. Xero uses "IsTrackedAsInventory" to distinguish tracked items from non-tracked items. Our converter maps QBO inventory items to tracked Xero items, and services to non-tracked items.

How People Use QBO Products → Xero

Migrating our product catalog from QuickBooks Online to Xero was the most dreaded part of switching platforms. The converter generated valid item codes from our existing SKUs and set up inventory tracking automatically. All 1,800 products imported on the first try without a single duplicate code error.

We sell across multiple channels and needed our QBO product list in Xero for a new fulfillment integration. The price mapping carried over both our sales and purchase prices, and the account code defaults matched our Xero chart of accounts. Saved us a full day of manual product entry.

My retail clients always have a mix of inventory items and service items in QuickBooks Online. The converter correctly maps inventory products to tracked items and services to non-tracked items in Xero. The item code generation from product names handles items without SKUs gracefully.

Field Mapping

How Quickbooks_Online Product_List fields map to Xero Inventory Item

Quickbooks_Online Product_List	Source Value		Xero Inventory Item	Target Value	Note
`Product/Service Name`	`Widget Pro - Blue / Large`	→	`ItemName`	`Widget Pro - Blue / Large`	Item display name
`Sales Description`	`Professional grade widget, blue color, large size`	→	`SalesDescription`	`Professional grade widget, blue color, large size`	Description for invoices
`Sales Price/Rate`	`49.99`	→	`SalesUnitPrice`	`49.99`	Selling price
`Income Account`	`Sales of Product Income`	→	`SalesAccountCode`	`Sales of Product Income`	Revenue account code
`Purchase Description`	`Widget Pro for resale`	→	`PurchaseDescription`	`Widget Pro for resale`	Description for POs
`Purchase Cost`	`25.00`	→	`PurchaseUnitPrice`	`25.00`	Cost price
`Expense Account`	`Cost of Goods Sold`	→	`PurchaseAccountCode`	`Cost of Goods Sold`	Expense/COGS account
`Type`	`Inventory`	→	`IsTrackedAsInventory`	`TRUE`	Inventory tracking flag
`Quantity on Hand`	`150`	→	`QuantityOnHand`	`150`	Current stock level

Why Use the QBO Products → Xero Converter?

Item Code Generation

Creates valid Xero item codes from SKU or product name (max 30 chars).

Price Mapping

Sales and purchase prices mapped to Xero's unit price fields.

Inventory Tracking

QBO Inventory items become tracked items in Xero.

Account Mapping

Sales and COGS accounts mapped with configurable defaults.

Tax Code Handling

Taxable items get OUTPUT tax code, non-taxable get NONE.

Browser Privacy

All processing happens locally. Your product data never leaves your device.

Data Transformation

Each QBO product/service becomes one Xero inventory item

One row per product from QBO products list

Key columns: Name, SKU, Sales Price/Rate, Type, Quantity on Hand

1:1 — One input row creates one output row

One item record with sales/purchase details

Item Record QBO Inventory/Non-inventory/Service → Xero tracked/untracked items

ItemCode unique and ≤30 chars; tracked inventory requires asset/COGS accounts

Your QBO Products → Xero Conversion is Secure

Local Processing Engine

Your QBO Products → Xero files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your QBO Products → Xero files are never cached, logged, or stored anywhere. Every session is ephemeral.

Privacy-First Architecture

Designed for data sovereignty. No third-party trackers or analytics touch your QBO Products → Xero files.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

By default, we use your SKU if available. If SKU is missing or you choose 'Generate from Name', we create a code from the product name (first 30 characters, alphanumeric). Auto-generate creates sequential codes like ITEM001.

QuickBooks bundles are not supported by this converter as Xero handles bundles differently. You'll need to set up bundled products manually in Xero.

QuickBooks services convert to Xero items with IsSold=TRUE but IsTrackedAsInventory=FALSE. They appear in Xero's item list but don't track inventory levels.

Current stock quantities are not transferred. After importing items, use Xero's inventory adjustment feature to set opening stock levels with appropriate dates.

Xero allows up to 3,000 items per import file. If you have more products, you'll need to split the export into multiple files.

Yes, product pricing is converted during migration. Standard pricing and tiered pricing can be transferred, though you should verify all prices after import to ensure accuracy.

Duplicates can cause import errors. Ensure each product has a unique name before migration. Products with identical names will fail to sync properly in Xero.

Tax codes need manual mapping during migration. QBO tax codes don't automatically convert to Xero's tax codes, so plan for configuration after import.

Product categories in QBO become tracking categories in Xero. You may need to reorganize or reconfigure categories to match Xero's system structure.