Import vendor lists into QuickBooks Online

With Zed Axis you can import vendor (supplier) lists into QuickBooks Online from text, Excel or IIF files.
 
Zed Axis is a more powerful way of importing Vendor list as it; 
  • Import more fields
 
To import using Zed Axis please follow these steps:
  1. Open Zed Axis and connect to your QuickBooks Online company file
  2. Once connected click on the Import module tab
  3. Open the Excel, text or IIF file that contains the Vendor list details that you want to import into QuickBooks Online.
  4. Next create a map between the columns in your import file and the corresponding fields in QuickBooks, for more information on the fields refer to the table at the end of this article.
  5. Finally click the Import button and Axis will import the vendors and details directly into QuickBooks Online.
 
Click to download a Sample Vendor List Template
 
Vendor list fields
 
QuickBooks Field Format Description
Title str 15 Title of the person
Given Name str 25 First name of the individual
Middle Name str 25 Middle name
Family Name str 25 Family name of individual
Suffix str 10 Suffix of the name (ie Jr)
Display Name str 100 MANDATORY The name of the person or organization displayed in QBO, must be unique
Company Name str 50 The name of the company or organization
PrintOnCheckName str 50 The name of the company or organization, as printed on a check
Active bool Whether vendor is enabled in QBO (true or false)
Primary Phone str 30 Primary telephone number
Alternate Phone str 30 Alternate telephone number
Mobile str 30 Mobile telephone number
Fax str 30 Fax number
Primary Email Addr str 100 Primary email address, must contain @ and be a standard email address format
Web Addr str 1000 Web site address
BillAddr....   Billing Address for the customer, more here
OtherContactInfo str Other telephone contact number
TaxIdentifier Str 20 Tax ID of the vendor
TermsRef str Purchase Terms for the vendor (must match Terms list in QBO)
Balance Decimal Opening balance when creating vendor
AcctNum Str 100 Name or number of the account associated with the vendor
Vendor1099 Bool Whether the vendor is an independent contractor; someone who is given a 1099-MISC form at the end of the year (values true of false)
Currency Ref Str 3 Currency to be used for transactions for this vendor (must match currency abbreviations ie USD, GBP, AUD, EUR)
APAccountRef str 15 FR Only - accounts payable account to be used for this vendor
 

Add Feedback