![QuickBooks Help](https://uxfabric.intuitcdn.net/web-app/sh-exp-sbg-app-experience/sbg_ohh_icon.19f2ae89.png)
Import employee data into QuickBooks Online
by Intuit• Updated 9 months ago
Importing employee data from a XLSX or CSV file is a great way to get set up quickly.
Note: You can also follow this process to perform bulk updates of employee data.
Step 1: Download an employee template from the Data Extracts page
- Select Payroll.
- Select the Payroll Settings tab then select Data Extracts (Located under Business Management).
- Under Data Type select Employee Data and Empty Template.
- Select the File format, then select Download.
You can then paste or enter the data into Microsoft Excel template. Once you've saved the template, you can proceed to upload the data into QuickBooks Payroll powered by Employment Hero.
Step 2: Import the employee template into QuickBooks Payroll
- Select Payroll.
- Select the dropdown arrow next to Add Employees and choose Import Employees.
- Select Select File, choose your completed template then select Open.
- Select Confirm Upload.
Note: Tick Automatically create missing locations. This will automatically create any locations names listed in the PrimaryLocation and Locations columns that are not already set up in the system. If this setting is not selected, an import error will occur.
When the import is complete, the results will be displayed on the screen advising the status of each employee updated.
Delete employee data using the import function
If you want to use an import file to remove data from the employee records, in bulk, use the value (clear) in the appropriate field/s on your import file.
File Specification
There are quite a few fields in the import file, however, they are broken into sections, and not all sections need to be present.
Content sourced from Employment Hero
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- How to set up an employee in QuickBooks Payroll powered by Employment Heroby QuickBooks•63•Updated 1 year ago
- Matching payroll payments in QuickBooks Onlineby QuickBooks•88•Updated May 08, 2024
- Export your payroll databy QuickBooks•5•Updated September 14, 2023
- Set up and process a pay run in QuickBooks Payroll powered by Employment Heroby QuickBooks•26•Updated September 13, 2023