You can import vendor lists from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. Download and install the Zed Axis software on your computer.

Open your QuickBooks company file as Administrator and open Zed Axis
Select your text file or spreadsheet which contains the vendor list that you want to import.
Set up the a Mapping of the columns in your vendor list import file to the corresponding fields in QuickBooks
Click Import and your vendors will be directly added to your QuickBooks company file:

For more information about importing vendor lists into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support

QuickBooks field	Type	Description
Name	Str 41	Name of the vendor - Mandatory
IsActive	Bool	Whether the name is active in QuickBooks
Salutation	Str 15	Mr, Mrs etc..
FirstName	Str 25	First name
MiddleName	Str 5	Middle initial
LastName	Str 25	Last name
VendorAddress...	Str	Address block see importing addresses for more
Phone	Str 21	Telephone number
AltPhone	Str 21	Alternative telephone number
Fax	Str 21	Fax number
Email	Str 1023	Email address
Contact	Str 41	Contact
AltContact	Str 41	Alternative contact
NameOnCheck	Str 41	Name that appears on Checks
AccountNumber	Str 99	Account number
Notes	Str 4095	Notes for the vendor
VendorType	Str 159	Category of the vendor, must match QuickBooks list
Terms	Str 31	Payment terms
CreditLimit	Amt	Credit limit amount
VendortaxIndent	Str 15
IsVendorEligible1099	Bool	true or false
OpenBalance	Amt	IOpening balance
OpenBalanceDate	Date	Date of opening balance
BillingRate	Str 31	Billing rate for vendor, must match QuickBooks list
ExternalGuid	GUID	GUID that can be applied to record
SalesTaxCode	Str 3	CA, UK & AU only
SalesTaxCountry	Enum	CA, UK & AU only, must match list
IsSalesTaxAgency	Bool	CA, UK & AU only, true or false
SalesTaxReturn	Str	CA, UK & AU only
TaxRegistrationNumber	Str 30	CA, UK & AU only
ReportingPeriod	Enum	CA, UK & AU only
IsTaxTrackedOnPurchases	Bool	CA, UK & AU only, true of false
TaxOnPurchaseAccount	Str 159	CA, UK & AU only
IsTaxTrackedOnSales	Bool	CA, UK & AU only
TaxOnSalesAccount	Str 159	CA, UK & AU only
IsTaxOnTax	Bool	CA, UK & AU only
PrefillAccount	Str 159	Account to use with prefill transactions
Currency	Str 64	Currency for the vendor

Article ID: 135, Created: October 21, 2011 at 6:28 AM, Modified: December 12, 2016 at 10:29 PM

Importing vendor lists into QuickBooks

Add Feedback

Was this article helpful?

Share this article