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 Your File

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.

How People Use This

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.

I was brought in to migrate a manufacturing client from QBO to Xero. Their product export had inconsistent SKU formatting. I used the auto-generate option to create clean sequential item codes, then the converter mapped sales and COGS accounts to the right Xero defaults. The whole product catalog transferred in one batch.

Our QBO product catalog included taxable and non-taxable items with different pricing tiers. The converter applied the correct OUTPUT and NONE tax codes and preserved our purchase prices for cost tracking. Moving our product data to Xero inventory was the smoothest part of the migration.

Common 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.

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.

Your Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

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

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 This 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

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

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

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.