This page (revision-28) was last changed on 26-Nov-2021 10:22 by kparrott

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
28 26-Nov-2021 10:22 25 KB kparrott to previous
27 26-Nov-2021 10:22 25 KB kparrott to previous | to last
26 26-Nov-2021 10:22 25 KB kparrott to previous | to last
25 26-Nov-2021 10:22 26 KB kparrott to previous | to last
24 26-Nov-2021 10:22 31 KB eyeung to previous | to last
23 26-Nov-2021 10:22 31 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
22 26-Nov-2021 10:22 31 KB jmyers to previous | to last
21 26-Nov-2021 10:22 31 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - ND
Tax Reporting - ND

Version management

Difference between version and

At line 211 added 5 lines
|227-234|Date First Employed MMDDCCYY|From system derived latest Employment Hired Date
|235-242|Date of Separation MMDDCCYY| From system derived latest Employment Termination Date that is greater than the Employment Hired Date
|243-247|Blank|
|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|
At line 212 changed 2 lines
227-234 - Date First Employed MMDDCCYY
- From system derived latest Employment Hired Date
;Location 274 to 337:Apply to Income Tax Reporting
||Column||Description||Source
|274-275|State code, appropriate FIPS postal numeric code|Derived from the State being reported\\ \\e.g. North Dakota is code "38"
|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-307|Other State Data, to be defined by each state|
|308|Tax Type Code\\ \\This field is used to report County, City or School district tax\\ \\If the County, City or School district requires to report taxes along with the State Tax information, then the following values are used for this field:\\C – City Income Tax\\D – County Income Tax\\E – School District Income Tax\\F – Other Income Tax\\ \\[IDGV] must be set up for the Local or School Registration by County/City or School district for the following fields on the [Variables|IDGV#VariablesTab]tab\\- 'W2 STATE MEDIA FILING'\\- 'W2 TAX TYPE CODE'\\- 'W2 TAXING ENTITY'\\ \\- 'W2 STATE MEDIA FILING' indicates whether the County/City or School should report taxes with the state or not\\- 'W2 TAX TYPE CODE' must contain the valid Tax Type Code as defined above\\- 'W2 TAXING ENTITY' contains the Taxing Entity code supplied by the County/City or School govt. booklet|If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAX TYPE CODE' field
|309-319|Local Taxable Wages|If School Tax is reported, this field is derived from Identifier ‘W2-SCHL-WAGE’ (seq 6500)\\ \\If County Tax is reported, this field is derived from Identifier ‘W2-CN-WAGE-HOME’ and ‘W2-CN-WAGE-WORK’\\ \\If City Tax is reported, this field is derived from: ‘W2-CI-WAGE-HOME’ and ‘W2-CI-WAGE-WORK’
|320-330|Local Income Tax Withheld|If School Tax is reported, this field is derived from Identifier ‘W2-SCHL-TAX’ (seq 6510)\\ \\If County Tax is reported, this field is derived from Identifier ‘W2-CN-TAX-HOME’ and ‘W2-CN-TAX-WORK’\\ \\If City Tax is reported, this field is derived from: ‘W2-CI-TAX-HOME’ and ‘W2-CI-TAX-WORK’
|331-337|State Control Number (optional)\\ \\Blank|
|338-412|Supplemental Data 1\\ \\State Specific Data\\ \\If not used, enter blanks
|413-487|Supplemental Data 2\\ \\State Specific Data\\ \\If not used, enter blanks
|488-512|Blank|
At line 215 removed 67 lines
235-242 - Date of Separation MMDDCCYY
- From system derived latest Employment Termination Date that is greater than the Employment Hired Date
243-247|Blank|
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|
Location 274 to 337 apply to INCOME TAX REPORTING.
274-275 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported
- e.g. North Dakota is code "38"
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-307 - Other State Data, to be defined by each State
308 - Tax Type Code
- this field is used to report County, City or School district tax
- if the County, City or School district requires to report taxes along with the State Tax information, then the following values are used for this field:
C – City Income Tax
D – County Income Tax
E – School District Income Tax
F – Other Income Tax
- the user must set up IDGV screen for the Local or School Registration by County/City or School district for the following fields on the Variables Tab:
- 'W2 STATE MEDIA FILING'
- 'W2 TAX TYPE CODE'
- 'W2 TAXING ENTITY'
- 'W2 STATE MEDIA FILING' indicates whether the County/City or School should report taxes with the state or not
- 'W2 TAX TYPE CODE' must contain the valid Tax Type Code as defined above
- 'W2 TAXING ENTITY' contains the Taxing Entity code supplied by the County/City or School govt. booklet
- if County, City or School district tax is reported, this field is derived from IDGV 'W2 TAX TYPE CODE' field
309-319 - Local Taxable Wages
- if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-WAGE’ (seq 6500)
- if County Tax is reported, this field is derived from Identifier
‘W2-CN-WAGE-HOME’ and ‘W2-CN-WAGE-WORK’
- if City Tax is reported, this field is derived from :
‘W2-CI-WAGE-HOME’ and ‘W2-CI-WAGE-WORK’
320-330 - Local Income Tax Withheld
- if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-TAX’ (seq 6510)
- if County Tax is reported, this field is derived from Identifier
‘W2-CN-TAX-HOME’ and ‘W2-CN-TAX-WORK’
- if City Tax is reported, this field is derived from :
‘W2-CI-TAX-HOME’ and ‘W2-CI-TAX-WORK’
331-337 - State Control Number (optional)
- blank
338-412 - Supplemental Data 1
- State Specific Data. If not used, enter blanks.
413-487 - Supplemental Data 2
- State Specific Data. If not used, enter blanks.
488-512|Blank|
At line 284 changed 2 lines
1-2 - Record Identifier
- Constant "RT"
|1-2|Record Identifier|Constant "RT"
|3-9|Number of RW Records\\ \\Total number of code "RW" records reported since last code "RE" record|
|10-24|Wages, Tips and Other Compensation|Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
|25-39|Federal Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
At line 287 changed 2 lines
3-9 - Number of RW Records
- Total number of code "RW" records reported since last code "RE" record
|40-54|Social Security Wages|Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
At line 290 changed one line
10-24 - Wages, Tips and Other Compensation|Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
|55-69|Social Security Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
At line 292 changed one line
25-39 - Federal Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
|70-84|Medicare Wages and Tips|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
At line 294 removed 6 lines
40-54 - Social Security Wages|Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
55-69 - Social Security Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
70-84 - Medicare Wages and Tips|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
This page (revision-28) was last changed on 26-Nov-2021 10:22 by kparrottTop