Import employees into QuickBooks Online

You can import a list of employees from and Excel file or text file into QuickBooks Online using Zed Axis.  Please follow these steps:
  1. Open Zed Axis on your desktop and connect to QuickBooks Online
  2. Click on the import tab and open the file that contains the Employees that you would like to import
  3. Create a map for and map the columns in your import file to the matching fields in QuickBooks Online
  4. Click import and the Employees will be imported directly into QuickBooks Online
Here is sample template of an Employee list.
  • If payroll is enabled it is only possible to export not import, or update.
The following is a description of the fields that you can map and import into QuickBooks Online
QuickBooks Online Type Description
Employee Number Date Id for the Employee, use if you are modifying
Organization Bool true or false - Whether the entity represents and organisation or individual
Title   Title of the employee
Given Name Str25 Mandatory, Given name of first name of the employee
Middle Name Str25 Middle name of the employee
Family Name Str25 Mandatory, family name of the employee
Suffix Str10 Suffix of the name ie MD, Sr or Jr
Display Name Str100 Must be unique - name of the employee as displayed
Print On Check Name Str100 Employee name as printed on checks
Active Bool true or false, whether currently enable in QuickBooks
Primary Phone   Primary Phone number
Mobile   Mobile phone number
Primary Email Addr   Primary email address
PrimaryAddrLine1   Physical Address Line see more on importing address into QuickBooks
SSN Str100 Social security number of the employee
BillableTime Bool true or false, currently enable for use in QuickBooks
BillRate BigDec Only set if above true, rate used for billing
BirthDate date Birth date of the employee
Gender enum Male or Female
HiredDate Date Hire date of the employee
ReleasedDate Date Release date of the employee

Add Feedback