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 Contacts CSV

🥦

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.

No API required

Browser-based processing

Run on Google Cloud Platform

Download Sample

Sample QBO vendor export CSV

Download

Tool Rating

4.6 / 5 (98 votes)

How It Works

Export Vendors

QBO → Reports → Vendor Contact List → Export to Excel/CSV

Upload File

Upload the exported vendor list CSV or Excel file

Configure Options

Select region and duplicate handling preferences

Import to Xero

Settings → Import → Contacts → Upload converted file

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 Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

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 Tool?

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

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.

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.