What QuickBooks export file format does this tool accept?

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

Can I convert QuickBooks CSV to Xero Contacts?

Yes, this tool converts QuickBooks Online Vendors CSV exports directly to Xero Contacts CSV format compatible with Xero Contacts.

How do I import QuickBooks online vendors to Xero Contacts?

Export your online vendors from QuickBooks, upload the CSV file to this converter, then import the converted file to Xero Contacts.

Convert QuickBooks Online Vendors to Xero Supplier

🥦

Xero Contacts CSV Format

valid rows

Migrate your QuickBooks Online vendor list to Xero. Convert vendor details and addresses to Xero-ready supplier contact CSV.

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 vendor export CSV

Download

Tool Rating

4.6 / 5 (98 votes)

How to Convert Your File

Export from Quickbooks Online

Settings → Export data → Lists → Vendors → Export to Excel

Upload and Configure

Upload QBO Vendor Export CSV and choose Contact format

Preview and Download

Review converted data, download Xero-ready file

Import to Xero

Contacts → All Contacts → Import → Upload CSV

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

How People Use This

When our company switched from QuickBooks Online to Xero, my biggest worry was losing vendor contact details and tax IDs. The converter mapped all 280 vendors as Xero supplier contacts with the IsSupplier flag already set. The address handling put our vendor addresses in both PO and street fields, which Xero needs for purchase orders.

Several of my clients had vendors that were also listed as customers in QBO. The duplicate name handling with the 'Append Vendor' option added the right suffix so Xero accepted both the customer and vendor records without collisions. It is a subtle detail that prevents hours of troubleshooting.

We have hundreds of subcontractor vendors in QuickBooks Online, each with tax IDs that need to carry over for 1099 reporting prep. The converter preserved every vendor tax ID and mapped the contact fields cleanly into Xero supplier format. I imported customers first, then vendors with the suffix option enabled.

Our nonprofit migrated from QBO to Xero for better grant tracking. Converting our vendor list was critical because each vendor ties to specific grant expenditures. The tool converted all vendor details to Xero contacts and kept the account numbers intact for our audit trail.

Common Conversion Questions

What vendor fields are converted?

We convert display name, company name, email, phone, fax, website, address, tax ID, account number, and notes. The vendor's default expense account is not transferred as Xero handles this differently.

What if a vendor has the same name as a customer?

Use the 'Append Vendor' duplicate handling option. This adds '- Vendor' to the contact name, making it unique and clearly identifying suppliers.

Can I import vendors and customers together?

Yes, but import them separately. Xero's contact import processes one file at a time. Import customers first, then vendors with the 'Append Vendor' option to avoid duplicates.

Why QuickBooks Vendor Exports Need Conversion for Xero

Supplier vs Contact Distinction

In Xero, vendors are contacts with the "IsSupplier" flag set to TRUE. QuickBooks doesn't have this concept - vendors are a separate entity. Our converter automatically sets the IsSupplier flag so your vendors import correctly as suppliers in Xero.

Preventing Customer-Vendor Collisions

If you have a company that's both a customer and vendor in QuickBooks, they may have the same name. Xero requires unique contact names. Our tool can append identifiers like "- Vendor" to distinguish suppliers from customers when you import both.

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 Vendor_List fields map to Xero Contact

Quickbooks_Online Vendor_List	Source Value		Xero Contact	Target Value	Note
`Email`	`accounts@officesupplies.com`	→	`EmailAddress`	`accounts@officesupplies.com`	Primary email address
`First Name`	`Jane`	→	`FirstName`	`Jane`	Contact first name
`Last Name`	`Doe`	→	`LastName`	`Doe`	Contact last name
`Address Line 1`	`456 Business Ave`	→	`POAddressLine1`	`456 Business Ave`	Address line 1
`City`	`Chicago`	→	`POCity`	`Chicago`	City
`State`	`IL`	→	`PORegion`	`IL`	State/province
`Postal Code`	`60601`	→	`POPostalCode`	`60601`	ZIP/postal code
`Country`	`United States`	→	`POCountry`	`United States`	Country
`Phone`	`(555) 123-4567`	→	`PhoneNumber`	`(555) 123-4567`	Primary phone
`Mobile`	`Sample Text`	→	`MobileNumber`	`Sample Text`	Mobile phone
`Fax`	`Sample Text`	→	`FaxNumber`	`Sample Text`	Fax number
`Website`	`https://officesupplies.com`	→	`Website`	`https://officesupplies.com`	Website URL
`Tax ID`	`12-3456789`	→	`TaxNumber`	`12-3456789`	Tax identification number
`Account Number`	`CUST-12345`	→	`AccountNumber`	`CUST-12345`	Your account with this vendor
`Currency`	`USD`	→	`DefaultCurrency`	`USD`	Default currency code

Why Use This Converter?

Auto Supplier Flag

Automatically sets IsSupplier=TRUE for all converted vendors.

Field Mapping

QBO vendor fields mapped to Xero contact format accurately.

Address Handling

Vendor address mapped to both PO and SA address in Xero.

Duplicate Detection

Prevents name collisions with existing customers.

Tax ID Preservation

Vendor tax ID / ABN / VAT numbers preserved in conversion.

Browser Privacy

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

Data Transformation

Each QBO vendor becomes one Xero contact

Vendor with address and contact details

Key columns: Vendor, Company, Email

1:1 — One input row creates one output row

Contact Record Direct field mapping with normalization

Name required, addresses optional

Common Contact Import Errors

Issues you might encounter when importing QBO Vendor Export data to Contact - and how we solve them

Duplicate Contact Name

Xero requires unique contact names across ALL contacts

Office Supplies Inc (exists as customer too)

Office Supplies Inc (Vendor)

Add '(Vendor)' suffix if name conflicts with customer

Review after import to merge if same entity

Missing Vendor Name

Contact must have a name to import

Rows without any name identifier are skipped

Add vendor name in source file before converting

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.

Unlike customers who have separate billing and shipping addresses, QBO vendors typically have one address. We map this to both PO (Postal) and SA (Street) addresses in Xero.

Use the 'Append Vendor' duplicate handling option. This adds '- Vendor' to the contact name, making it unique and clearly identifying suppliers.

The 1099 status is not exported in QBO's standard report. You'll need to set up contractor status manually in Xero after import.

QBO payment terms (Net 30, etc.) are not included in the standard vendor export. You'll need to set payment terms manually in Xero.

Yes, but import them separately. Xero's contact import processes one file at a time. Import customers first, then vendors with the 'Append Vendor' option to avoid duplicates.

Yes, customize the Vendor Contact List report in QBO by clicking the Gear icon and checking the Tax ID field to view and export vendor tax IDs.

Inactive vendors are migrated to Xero and can be reactivated if needed. Review your vendor list after import to manage inactive suppliers.

Payment terms are typically transferred, but verify them in Xero after import as formatting may differ between systems.

Reconcile bank accounts, ensure A/R and A/P balances match your balance sheet, and clean up duplicate or outdated vendor records.