Product Download Purchase Support Deals Online Solution  Cart  Sign In
 

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

    export employee list
    Click to view larger image

    qb export file into csv format

    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.

    W2 software

    ezW2 software: SSA Approved. Trusted By Thousands for Two Decades.

  • Print and eFile Form W2, W3, 1099-NEC & 1096 in House.
  • Unlimited Company Accounts! Unlimited Forms!
  • Compatible with Windows 11, 10, 8.1, 8, 7, Vista, XP and other Windows computers.

    • Try it free today. No obligation. No credit card required.

            

    Related Links

  • How can I roll forward my previous ezW2 data to the new version?
  • W2 and 1099 forms filing deadline

    W2 W3

  • How to fill out and print Form W2
  • How to print Form W2 W3 on white paper
  • How to print multiple copies on the same page for employee
  • How to print W-2 data on red forms
  • How to convert W2's into PDF format files
  • How to eFile W2 W3 forms
  • How to print Form W3

    1099-nec, 1096 (For ezW2 latest version)

  • How to fill out and print Form 1099-nec
  • How to eFile 1099-nec forms
  • How to print 1099-nec forms on red forms
  • How to convert 1099-nec forms into PDF file
  • How to print Form 1096

    1099-misc, 1096 (for ezW2 2019 and earlier version)

    To print the current 1099-misc forms, please use ez1099 software.

    (Note: ezW2 2019 and previous versions support 1099-MISC forms. You need to use the new Form 1099-NEC to report nonemployee compensation during the current tax season..)

    W2C, W3c

    - Learn more about W2C and W3C

    More Forms

    - Learn more about 1099s software (1099A, 1099B, 1099C, 1099CAP, 1099DIV, 1099G, 1099H, 1099INT, 1099LTC, 1099MISC, 1099-nec, 1099OID, 1099PATR, 1099Q, 1099R, 1099S, 1099SA)

    - Learn more about 1098s software (1098, 1098C, 1098E, 1098 T) software

    - Learn more about 5498s(5498, 5498ESA, 5498SA) software

    - Learn more about W2G, 1097BTC, 8935, 3921, 3922 software

    - Learn more about how to file ACA Form 1095 & 1094 to federal and states