Importing vendor lists into QuickBooks

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.

  1. Open your QuickBooks company file as Administrator and open Zed Axis
  2. Select your text file or spreadsheet which contains the vendor list that you want to import.
  3. Set up the a Mapping of the columns in your vendor list import file to the corresponding fields in QuickBooks
  4. 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

 

Add Feedback