Import employees into QuickBooks

You can import employees into QuickBooks from text or Excel files 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 employee list that you want to import.
  3. Set up the a Mapping of the columns in your employee list import file to the corresponding fields in QuickBooks
  4. Click Import and your employees will be directly added to your QuickBooks company file:

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

Download a sample employee list template

 

Employee List

QuickBooks Field TypeDescription 
 Is Activetrue or false Whether the employee record is enabled in QuickBooks, default true
 Salutation str 15Title used for the employee,ie Mr, Ms, Mrs etc...
 First Name str 25First name of the employee
 Middle Name str 5Middle name of the employee
 Last Name str 25Last name of the employee
SupervisorFullNamestr 209Supervisors Full Name (Match name of Employee or Vendor already in QuickBooks)
Departmentstr 31Department for the employee
Descriptionstr 64Role description for the employee
TargetBonusamountDollar value target to achieve bonus (eg. 10000.00)
 EmployeeAddr.... strAddress for the employee. More information on importing addresses into QuickBooks 
 Print As str 41Name used when printing on forms
 Phone str 21Phone number
 Mobile str 21Mobile phone number
 Pager str 21Pager number
 Pager PIN str 10Pager PIN
 Alt Phone str 21Alternative phone number
 Fax str 21Fax Number
 SSN str 15Social security number, accept dashes or non dashed
 Email str 1023Email address
EmergencyPrimaryContactNamestr 40Name of the primary emergency contact
EmergencyPrimaryContactValuestr 255Telephone number of the primary emergency contact
EmergencyPrimaryContactRelationenumRelation of the contact (Values: Spouse, Partner, Mother, Father, Sister, Brother, Son, Daughter, Friend, Other)
EmergencySecondaryContactNamestr 40Name of the secondary emergency contact
EmergencySecondaryContactValuestr 255Telephone number of the secondary emergency contact
EmergencySecondaryContactRelationenumRelation of the contact (Values: Spouse, Partner, Mother, Father, Sister, Brother, Son, Daughter, Friend, Other)
Employee TypeenumEmployee type from QuickBooks list, (values: Officer, Owner, Regular [DEFAULT], Statutory)
PartOrFullTimeenumWhether the employee is part time or full time (values: PartTime, FullTime)
ExemptenumIf the employee is exempt or not (values: Exempt, NonExempt )
KeyEmployeeenumIf the employee is a key employee (values: Yes, No)
Genderenum(values: Male or Female)
Hired DatedateDate the employee was hired
OriginalHireDatedateDate employee was originally hired
AdjustedServiceDatedateDate service was adjusted
Released Datedatedate the employee was released
Birth DatedateDate the employee was born
USCitizenenumWhether the employee is a US citizen (values: Yes, No)
EthnicityenumEthnic origin of employee (values: AmericianIndian, Asian, Black, Hawaiian, Hispanic, White, TwoOrMoreRaces )
DisabledenumWhether the employee as a disability (values: Yes, No)
DisabilityDescstrDescription of the disability
OnFileenum(values: Yes, No)
WorkAuthExpireDatedateDate work authority expires
USVeteranenum(values: Yes, No)
MilitaryStatusenum(values: Active, Reserve)
Account Number str 99Employee reference number
Notesstr 4095Employee notes
Billing Ratestr 31Rate that the employees time is billed at
 Emp Pay Period enumPay period for the employee, match list in QuickBooks (Weekly, fortnightly, etc...)
 Class str 159Class list as appears in QuickBooks
 Clear Earnings true or falseIf set to true then the earnings will be deleted for this employee
 Payroll Item str 31Default payroll item for employee, must match QuickBooks list 
 Earning Rate priceRate the employee is paid at
 Use TimeData to create Paychecks enumIf the employee is paid based on the time entered into a QuickBooks timesheet (values: NotSet, UseTimeData, DoNotUseTimeData)
 Sick Hours Availble timeamount of sick leave available in hours
 Sick Hours Accrual Period enumperiod for which accrual is calculated
Values: BeginningOfYear, EveryHourOnPaycheck, EveryPaycheck
 Sick Hours Accrued timehours that are accrued in accrual period
 Sick Hours Maximum Accrual timemaximum hours that can be accrued
 Sick Hours is Reset true or falseShould the accrued amount be reset each year 
 Sick Hours Used timehours used in
 Sick Hours Accrual Start Date dateDate the accrual period started 
 Vacation Hours Availble timeamount of vacation leave available
 VacationHours Accrual Period enumperiod for which accrual is calculated
Values: BeginningOfYear, EveryHourOnPaycheck, EveryPaycheck
 Vacation Hours Accrued timehours that are accrued in accrual period
 Vacation Hours Maximum Accrual timemaximum hours that can be accrued
 Vacation Hours is Reset true or falseShould the accrued amount be reset each year
 Vacation Hours Used timehours used in
 Vacation Hours Accrual Start Date dateDate the accrual period started

 


Troubleshooting:
Error: Missing lived in or worked in State

 

Add Feedback