Import employees into QuickBooks Online

You can import a list of employees from an 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.
 
 
Note:
  • 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 OnlineTypeDescription
Employee NumberDateId for the Employee, use if you are modifying
OrganizationBooltrue or false - Whether the entity represents and organisation or individual
Title Title of the employee
Given NameStr 25Mandatory, Given name of first name of the employee
Middle NameStr 25Middle name of the employee
Family NameStr 25Mandatory, family name of the employee
SuffixStr 10Suffix of the name ie MD, Sr or Jr
Display NameStr 100Must be unique - name of the employee as displayed
Print On Check NameStr 100Employee name as printed on checks
ActiveBooltrue or false, whether currently enable in QuickBooks
Primary Phone Primary Phone number
Mobile Mobile phone number
Primary Email Addr Primary email address
Primary Addr Line 1 Physical Address Line see more on importing address into QuickBooks
Primary Addr Line 2  
Primary Addr Line3  
PrimaryAddrCity  
PrimaryAddrCountry  
PrimaryAddrSubDivisionCode  
PrimaryAddrPostalCode  
PrimaryAddrNote  
PrimaryAddrLine4  
PrimaryAddrLine5  
PrimaryAddrLat  
PrimaryAddrLong  
SSNStr100Social security number of the employee
Billable TimeBooltrue or false, currently enable for use in QuickBooks
Bill RateBigDecOnly set if above true, rate used for billing
Birth DatedateBirth date of the employee
GenderenumMale or Female
Hired DateDateHire date of the employee
Released DateDateRelease date of the employee
 

Add Feedback