IRS Release Status: FINAL

Sample Excel Import File (W-2 Professional): W2 2023.xlsx

Sample Excel Import File (Corporate Suite): W2 2023 (CS).xlsx

Sample Excel Import File with internal recipient fields (Corporate Suite) : W2 2023 with rcp fields.xlsx


What's New for 2023

  • The Social Security Wage Base is $160,200 for Tax Year 2023
  • For Tax Year 2023, the Social security tax withheld amount should not exceed $9,932.40 ($160,200 × 6.2%).
  • The Tax Year 2023 Social Security and Medicare coverage threshold for Household wages is now $2,600 ($200 increase from 2022).
  • The W-2 is one of the forms subject to the electronic filing threshold change that has been implemented beginning with tax year 2023.  As a result, if your business has an aggregate total of 10 or more W-2, 1099, 1042-S or 1095 forms you will now be required to file electronically.  See this article for all of the details on this change.

Import Form Fields:

Field NameSizeType DescriptionNotes
See Form Filer Common FieldsFiler fields common to all form types.
See Recipient Common FieldsRecipient fields common to all form types.

Box 1 Amount

12Amount

Box 1: Wages, tips, other compensation


Box 2 Amount12AmountBox 2: Federal income tax withheld
Box 3 Amount12AmountBox 3: Social security wages
Box 4 Amount12AmountBox 4: Social security tax withheld
Box 5 Amount12AmountBox 5: Medicare wages and tips
Box 6 Amount12AmountBox 6: Medicare tax withheld
Box 7 Amount12AmountBox 7: Social security tips
Box 8 Amount12AmountBox 8: Allocated tips
Box 10 Amount12AmountBox 10: Dependent care benefits
Box 11 Amount12AmountBox 11: Nonqualified plans
Box 11 is Sect 4571CheckboxBox 11: Sec 457 checkboxX / Y / T / 1 = Checked
Box 12a Amount12AmountBox 12a: See instructions.
Box 12a Code2TextBox 12a: See instructions.
Box 12b Amount12AmountBox 12b: See instructions.
Box 12b Code2TextBox 12b: See instructions.
Box 12c Amount12AmountBox 12c: See instructions.
Box 12c Code2TextBox 12c: See instructions.
Box 12d Amount12AmountBox 12d: See instructions.
Box 12d Code2TextBox 12d: See instructions.
Box 13 Checkbox 11CheckboxBox 13: Statutory employee checkboxX / Y / T / 1 = Checked
Box 13 Checkbox 21CheckboxBox 13: Retire plan checkboxX / Y / T / 1 = Checked
Box 13 Checkbox 31CheckboxBox 13: Third-party sick pay checkboxX / Y / T / 1 = Checked
Box 14 Line 114TextBox 14: Other
Box 14 Line 214TextBox 14: Other
Box 14 Line 314TextBox 14: Other
Box 15(1) State2TextBox 15: Withholding StateUse state abbreviation
Box 15(1) ID Number20TextBox 15: Employer's state ID numberProvided by State
Box 16(1) Amount12AmountBox 16: State wages, tips, etc
Box 17(1) Amount12AmountBox 17: State income tax
Box 18(1) Amount12AmountBox 18: Local wages, tips, etc
Box 19(1) Amount12AmountBox 19: Local income tax
Box 20(1) Locality8TextBox 20: Locality name
See Form Common FieldsForm fields common to all form types

Additional Import Form Fields for W-2 Corporate Suite only:


Field NameSizeType DescriptionNotes

Rcp Acct/Identifier

25Character

Recipient Account Number

Optional Account / Import match ID (as displayed on UI manual entry)
Alt Rcp Account60CharacterAlternate Recipient Account The Alternate Account/Info field is a secondary, internal reference value and does not print on the tax form.

W-2 Form: 


IRS W-2 Form:  https://www.irs.gov/pub/irs-pdf/fw2.pdf

IRS W-2 Instructions:  https://www.irs.gov/pub/irs-pdf/iw2w3.pdf


  • No labels