How to import Other Names List into QuickBooks desktop

If you need to import Other Names List into QuickBooks desktop from text or Excel files then that is possible using Zed Axis.  Follow these steps to import:

  1. Open your QuickBooks company file as Administrator and open Zed Axis
  2. Connect Zed Axis to your company file
  3. Browse to the file that contains the Other Names List
  4. Set up a new mapping for the columns in your import file and the corresponding fields in QuickBooks
  5. Click Import and your Other Names List will be imported directly into QuickBooks company file.
Below is a detailed description of all the fields that you can import on a Other Name List and also a template you can use to arrange your import data.
Sample import template Other Names.txt

QuickBooks fieldType (max length)Description
NameText 41 CharactersName in the other name list
Is Activetrue or falseWhether the name is active or not
Company NameText 41 CharactersCompany name
SalutationText 15 charactersGreeting or salutation
First NameText 25 charactersFirst name
Middle NameText 5 charactersMiddle initial
Last NameText 25 charactersLast Name
Other Name Address .....Address typeOther Name Address block see here for details
PhoneText 21 charactersPhone number
Alt PhoneText 21 charactersAlternative phone number
FaxText 21 charactersFax number
EmailText 1023 charactersEmail address
ContactText 41 charactersContact name
Alt ContactText 41 charactersAlternative contact name
Account NumberText 99 charactersAccount Number
NotesText 4095 charactersNotes