This page (revision-32) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
32 26-Nov-2021 10:22 19 KB Meg McFarland to previous
31 26-Nov-2021 10:22 19 KB Meg McFarland to previous | to last
30 26-Nov-2021 10:22 19 KB Meg McFarland to previous | to last
29 26-Nov-2021 10:22 22 KB kparrott to previous | to last
28 26-Nov-2021 10:22 23 KB kparrott to previous | to last
27 26-Nov-2021 10:22 23 KB kparrott to previous | to last
26 26-Nov-2021 10:22 23 KB kparrott to previous | to last
25 26-Nov-2021 10:22 28 KB eyeung to previous | to last
24 26-Nov-2021 10:22 29 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
23 26-Nov-2021 10:22 29 KB jmyers to previous | to last
22 26-Nov-2021 10:22 29 KB jmyers to previous | to last
21 26-Nov-2021 10:22 28 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - ID
Tax Reporting - ID

Version management

Difference between version and

At line 196 changed one line
Record Mame: Code RS - State Wage Record
!Record Name: Code RS - State Wage Record
At line 198 removed one line
At line 200 removed one line
At line 200 added 20 lines
|5-9 ID|Taxing Entity Code\\ \\Not used, fill with blanks|
|10-18|Social Security Number|Derived from [IDFDV], Field Identifier:‘W2-EE-SSN’ (seq 2500)\\ \\If an invalid SSN is encountered, this field is entered with zeroes.|
|19-33|Employee First Name|Derived from [IDFDV], Field Identifier:‘W2-EE-FIRST-NAME’ (seq 2510)|
|34-48|Employee Middle Name or Initial|Derived from [IDFDV], Field Identifier:‘W2-EE-MIDDLE’ (seq 2520)|
|49-68|Employee Last Name|Derived from [IDFDV], Field Identifier:‘W2-EE-LAST-NAME’ (seq 2530)
|69-72|Employee Suffix|Derived from [IDFDV], Field Identifier:‘W2-EE-SUFFIX’ (seq 2540)
|73-94|Employee Location Address|Derived from [IDFDV], Field Identifier:‘W2-EE-LOCN-ADDR’ (seq 2600)
|95-116|Employee Delivery Address|Derived from [IDFDV], Field Identifier:‘W2-EE-DELIV-ADDR’ (seq 2610)
|117-138|Employee City|Derived from [IDFDV], Field Identifier:‘W2-EE-CITY’ (seq 2620)
|139-140|Employee State Abbreviation|Derived from [IDFDV], Field Identifier:‘W2-EE-STATE’ (seq 2630)
|141-145|Employee ZIP Code|Derived from [IDFDV], Field Identifier:‘W2-EE-ZIP’ (seq 2640)
|146-149|Employee ZIP Code Extension|Derived from [IDFDV], Field Identifier:‘W2-EE-ZIP-EXT’ (seq 2650)
|150-247 ID|Not used, fill with blanks|
|248-267|State Employer Account Number|Derived from [IDFDV], Field Identifier:‘W2-STATE-REGIST’ for the reporting State\\ \\When [RPYEU] is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from [IDGV] for the SUI Registration of the State
|268-273|Blank|
|274-275|State code, appropriate FIPS postal numeric code|Derived from the State being reported\\ \\e.g. Numeric Code for Idaho is "16"
|276-286|State Taxable Wages|Derived from [IDFDV], Field Identifier: ‘W2-ST-WAGE-HOME’(7020) and ‘W2-ST-WAGE-WORK’ (7030)
|287-297|State Income Tax Withheld|Derived from [IDFDV], Field Identifier: ‘W2-ST-TAX-HOME’ (7040) and ‘W2-ST-TAX-WORK’ (7050)
|298-512 ID|Not used, fill with blanks|
;Multiple Code RS records:Multiple code RS records are generated for an employee if there is applicable county, city or school district tax information to be reported for a state. In this case, the state wages and tax will be zero for the subsequent code RS records.
At line 203 changed 60 lines
|5-9 ID|Taxing Entity Code
- Not used, fill with blanks
|10-18|Social Security Number|Derived from [IDFDV], Field Identifier:‘W2-EE-SSN’ (seq 2500)
- if an invalid SSN is encountered, this field is entered with zeroes.
|19-33|Employee First Name|Derived from [IDFDV], Field Identifier:‘W2-EE-FIRST-NAME’ (seq 2510)
|34-48|Employee Middle Name or Initial|Derived from [IDFDV], Field Identifier:‘W2-EE-MIDDLE’ (seq 2520)
49-68 - Employee Last Name
|Derived from [IDFDV], Field Identifier:‘W2-EE-LAST-NAME’ (seq 2530)
69-72 - Employee Suffix
|Derived from [IDFDV], Field Identifier:‘W2-EE-SUFFIX’ (seq 2540)
73-94 - Employee Location Address
|Derived from [IDFDV], Field Identifier:‘W2-EE-LOCN-ADDR’ (seq 2600)
95-116 - Employee Delivery Address
|Derived from [IDFDV], Field Identifier:‘W2-EE-DELIV-ADDR’ (seq 2610)
117-138 - Employee City
|Derived from [IDFDV], Field Identifier:‘W2-EE-CITY’ (seq 2620)
139-140 - Employee State Abbreviation
|Derived from [IDFDV], Field Identifier:‘W2-EE-STATE’ (seq 2630)
141-145 - Employee ZIP Code
|Derived from [IDFDV], Field Identifier:‘W2-EE-ZIP’ (seq 2640)
146-149 - Employee ZIP Code Extension
|Derived from [IDFDV], Field Identifier:‘W2-EE-ZIP-EXT’ (seq 2650)
150-247 ID - Not used, fill with blanks.
248-267 - State Employer Account Number
|Derived from [IDFDV], Field Identifier:‘W2-STATE-REGIST’ for the reporting State
- When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from IDGV screen for the SUI Registration of the State
268-273 |Blank|
274-275 - State code, appropriate FIPS postal numeric code|Derived from the State being reported
- e.g. Numeric Code for Idaho is "16"
276-286 - State Taxable Wages
|Derived from [IDFDV], Field Identifier: ‘W2-ST-WAGE-HOME’(7020) and ‘W2-ST-WAGE-WORK’ (7030)
287-297 - State Income Tax Withheld
|Derived from [IDFDV], Field Identifier: ‘W2-ST-TAX-HOME’ (7040) and ‘W2-ST-TAX-WORK’ (7050)
298-512 ID - Not used, fill with blanks.
Multiple Code RS records:
Multiple code RS records are generated for an employee if there are applicable county, city or school district tax information to be reported for a State. In this case, the State wages and tax will be zero for the subsequent code RS records.
Record name: Code RT - Total Record (same as Federal code RT)
!Record Name: Code RT - Total Record (same as Federal code RT)
This page (revision-32) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop