Saving and Completing the Import File
- Click on the Import Data button.
- Choose Import via Excel.
- Click the W-2 Transactions type.
- Click OK.
- Click Excel Template and Instructions.
- Choose where to save the file.
- Name the file.
- Click Save.
- The import file will open automatically. Make changes to the import file to enter the applicable information.
Editing the Import File
Some guidelines to keep in mind while completing the W-2 import file:
- Column headings in the import file cannot be changed.
- Red column headings are required in order to successfully import data.
- While some columns can be safely deleted without impacting the import, it is suggested that you simply hide unused columns to prevent import errors.
- Sample Payer/Recipient data, codes, and dollar values in the template should be removed before importing.
- Each row is equivalent to one transaction.
- Recipient transactions must be in a row.
- Payer information should be repeated on each row.
- Only the first worksheet/tab in the Excel file will be imported.
- Format all fields as Text.
- For checkboxes, enter a value of True, 1, or X in the cell. To leave the box blank, enter a value of 0, False, or leave the cell blank.
Two fields required to import W-2 transactions are "Kind of Payer" and "Kind of Employer". Use the following codes when completing the import file:
Kind of Payer
Kind of Payer | Value |
---|---|
941 | R |
944 | F |
Agriculture | A |
Household | H |
Military | M |
Medicare Qualified Government Employee | Q |
Railroad | X |
Kind of Employer
Kind of Employer | Value |
---|---|
Federal Government | F |
State/Local non 501c | S |
501c non-gvt | T |
State/Local 501c | Y |
None of the above | N |
Importing the Completed File
- Click on the Import Data button.
- Choose Import via Excel.
- Choose the Import W-2 Transactions type.
- Click OK.
- Click the Browse For File button.
- Locate the saved import file.
- Click Open.
- If there are errors on the import file, the errors will be displayed on the Audit Report screen. Go to the next section if errors are found when importing.
Fixing Errors on the Excel File
- On the Audit Report screen, click on the Export Error File button.
- Choose where to save the file.
- Name the file.
- Click Save. The file will open automatically.
- Refer to column A: "Error Description".
- Errors found on the import file will appear in the row the error was found in.
- For example, if there is an error description in row 2, the error will be found in row 2.
- Review the file for any fields highlighted in yellow.
- Fields in yellow contain errors.
- After making the applicable changes, save the file.
- Attempt the import again, this time with the errors file saved in step 4.
For more steps on how to correct errors on the import file, please see the Troubleshooting Common Import Errors article.