How to Export Employees from QuickBooks

You can export Employees data from QuickBooks then import them into ezW2, ezPaycheck or ezAccounting to process paychecks and print tax forms.

1. Start QuickBooks

2. Export Employee List

You can click top menu "Employees" then "Employee Center" to view employee list screen

Click menu "Excel" then select "Export Employee List" from dropdown.

Save export file in .csv format


Click to view larger image

3. Open the .csv file with MS Excel application and edit it if needed

4. Import Data into ezW2 to print or efile tax forms

If you need to print W2 form, please check this link

ezW2: How to import W2 data and file tax form - with sample data file
(Available with Enterprise version and Multiple-user version)

If you need to print 1099-misc form, please check this link

ezW2: How to import 1099 data and file tax form, with sample data file
(Available with Enterprise version and Multiple-user version)

- ezW2 can print ALL W-2 forms (copy A, B, C, D, 1 and 2) and W-3 forms on plain paper. The black and white substitute forms of W-2 Copy A and W-3 are SSA-approved (Vendor ID: 1335).

- ezW2 can print W2 recipeint copies in 4-up formats. It can also print 2 red forms on the same sheet.

- ezW2 can print 1099 misc forms Copy 1, 2, B and C on white paper. IRS does not certify the substitute forms right now. You need to use the red-ink forms for 1099 MISC copy A and 1096.

- ezW2 also supports PDF and efile features.

---