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

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
17 26-Nov-2021 10:22 9 KB lurtan to previous
16 26-Nov-2021 10:22 10 KB kparrott to previous | to last
15 26-Nov-2021 10:22 10 KB kparrott to previous | to last
14 26-Nov-2021 10:22 10 KB kparrott to previous | to last
13 26-Nov-2021 10:22 10 KB kparrott to previous | to last
12 26-Nov-2021 10:22 10 KB kparrott to previous | to last
11 26-Nov-2021 10:22 10 KB eyeung to previous | to last
10 26-Nov-2021 10:22 9 KB jmyers to previous | to last
9 26-Nov-2021 10:22 9 KB jmyers to previous | to last
8 26-Nov-2021 10:22 9 KB jmyers to previous | to last
7 26-Nov-2021 10:22 10 KB jmyers to previous | to last
6 26-Nov-2021 10:22 10 KB jmyers to previous | to last
5 26-Nov-2021 10:22 10 KB jmyers to previous | to last
4 26-Nov-2021 10:22 10 KB jmyers to previous | to last
3 26-Nov-2021 10:22 10 KB jmyers to previous | to last
2 26-Nov-2021 10:22 10 KB jmyers to previous | to last
1 26-Nov-2021 10:22 10 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 3 added 3 lines
!!What's New in Wage Reporting for Tax Year 2011
*There are no noted file format changes in state UI wage reporting for tax year 2011.
*The state of Nevada has no state income tax.
At line 16 changed one line
*Annual Form Code’ – use the standard supplied form code HL$US-W2-2017. You will have to enter The ‘Variables’ will need to be entered into this Form Code for specific use in the installation.
*Annual Form Code’ – use the standard supplied form code HL$US-W2-2012. You will have to enter The ‘Variables’ will need to be entered into this Form Code for specific use in the installation.
At line 18 changed one line
*Period End Date: Enter the quarter end date, i.e. 30-Jun-2016.
*Period End Date: Enter the quarter end date, i.e. 30-Jun-2011.
At line 24 removed 25 lines
||Column||Description||Source
|1-2|Record Identifier|Constant "RA"
|3-11|Submitter’s Employer ID number (EIN)|Numeric only\\ \\Derived from [IDFDV] Field Identifier: ‘SUB-ER-EIN’ (seq 1000)
|12-216 NV|Not Required|
|217-273|Submitter Name|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
|274-295|Submitter Location Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
|296-317|Submitter Delivery Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
|318-339|Submitter City|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
|340-341|Submitter State Abbreviation|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
|342-346|Submitter ZIP Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
|347-350|Submitter ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
|351-355 NV|Blanks|Not required
|356-378|Submitter Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
|379-393|Submitter Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
|394-395|Submitter Country Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
|396-422|Contact Name|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
|423-437|Contact Phone Number|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
|438-442|Contact Phone Extension|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
|443-445 NV|Blanks|Not required
|446-485|Contact E-mail|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
|486-488 NV|Blanks|Not required
|489-498|Contact FAX|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
|499-499|Filler|
|500-500|Preparer Code|Derived from [IDFDV] Field Identifier: ‘SUB-PREPARER’ (seq 1310)
|501-512 NV|Not Required|
At line 28 added 70 lines
Column Description
1-2 - Record Identifier
- Constant "RA"
3-11 - Submitter’s Employer ID number (EIN)
- Numeric only
- Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’ (seq 1000)
12-216 NV - Not Required
217-273 - Submitter Name
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
274-295 - Submitter Location Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
296-317 - Submitter Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
318-339 - Submitter City
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
340-341 - Submitter State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
342-346 - Submitter ZIP code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
347-350 - Submitter ZIP code extension
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
351-355 NV - Blanks, not required.
356-378 - Submitter Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
379-393 - Submitter Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
394-395 - Submitter Country Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
396-422 - Contact Name
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
423-437 - Contact Phone Number
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
438-442 - Contact Phone Extension
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
443-445 NV - Blanks. Not required.
446-485 - Contact E-mail
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
486-488 NV - Blanks, Not required.
489-498 - Contact FAX
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
499-499 - Preferred Method of Problem Notification Code
- Not Required.
500-500 - Preparer Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-PREPARER’ (seq 1310)
501-512 NV - Not required.
At line 51 removed 17 lines
||Column||Description||Source
|1-2|Record Identifier|Constant "RE"
|3-25 NV|Not Required|
|26|Terminating Business Indicator|Derived from [IDFDV] Field Identifier: ‘W2-ER-TERM-BUS’ (seq 1520)
|27-39 NV|Not Required|
|40-96|Employer Name|Derived from [IDFDV] Field Identifier: ‘W2-ER-NAME’ (seq 2010)
|97-118|Employer Location Address|Derived from [IDFDV] Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
|119-140|Employer Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
|141-162|Employer City|Derived from [IDFDV] Field Identifier: ‘W2-ER-CITY’ (seq 2040)
|163-164|Employer State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-ER-STATE’ (seq 2050)
|165-169|Employer ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
|170-173|Employer ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
|174-178 NV|Not Required|
|179-201|Employer Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
|202-216|Employer Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
|217-218|Employer Country Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-COUNTRY’ (seq 2100)
|219-512 NV|Not Required|
At line 100 added 46 lines
Column Description
1-2 - Record Identifier
- Constant "RE"
3-25 NV - Not Required.
26 - Terminating Business Indicator
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’ (seq 1520)
27-39 NV - Not Required.
40-96 - Employer Name
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-NAME’ (seq 2010)
97-118 - Employer Location Address
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
119-140 - Employer Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
141-162 - Employer City
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-CITY’ (seq 2040)
163-164 - Employer State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-STATE’ (seq 2050)
165-169 - Employer ZIP Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
170-173 - Employer ZIP Code Extension
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
174-178 NV - Not required
179-201 - Employer Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
202-216 - Employer Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
217-218 - Employer Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’ (seq 2100)
219-512 NV - Not Required.
At line 70 removed 20 lines
||Column||Description||Source
|1-2|Record Identifier|Constant "RS"
|3-4|State Code|Appropriate FIPS postal numeric code\\ \\Derived from the State being reported, from IDFDV sequence 7000\\ \\ e.g. Nevada is code "32"
|5-8|Taxing Entity Code|Constant ‘WAGE’
|9-9|Blank|
|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-196 NV|Not Required|
|197-202|Reporting Period MMCCYY|From user specified Period End Date converted to MMCCYY for the quarter\\ \\ e.g. Period End Date = ‘31-Dec-2016’, then reporting period is ‘122016’
|203-213|State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’\\ \\Note that the [IDFDV] Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in [UPCALC] and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. [RPYEU] will then be using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages
|214-247 NV|Not Required|
|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-337 NV|Not Required|
|338-346 NV|Quarterly Tip Wages|State Specific Data\\ \\If not used, enter blanks
|347-350 NV|Hours Paid|Optional, not currently required
|347-512 NV|Zip Code of Work Site|Optional, not currently required
|347-512 NV|Not Required|
At line 148 added 60 lines
Column Description
1-2 - Record Identifier
- Constant "RS"
3-4 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported, from IDFDV sequence 7000.
- e.g. Nevada is code "32"
5-8 - Taxing Entity Code
- Constant ‘WAGE’.
9-9 - Blank.
10-18 - Social Security Number
- Derived from IDFDV screen, 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 screen, Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
34-48 - Employee Middle Name or Initial
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
49-68 - Employee Last Name
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
69-72 - Employee Suffix
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
73-196 NV - Not Required.
197-202 - Reporting Period MMCCYY
- From user specified Period End Date converted to MMCCYY for the quarter
- e.g. Period End Date = ‘31-Dec-2007’, then reporting period is ‘122007’
203-213 - State Quarterly Unemployment Insurance Total Wages
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
- note that the IDFDV Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in UPCALC and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages, therefore RPYEU is using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages
214-247 NV - Not Required.
248-267 - State Employer Account Number
- Derived from IDFDV screen, 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-337 NV - Not Required.
338-346 NV - Quarterly Tip Wages
- State Specific Data. If not used, enter blanks.
347-350 NV - Hours Paid.
Optional, not currently required.
347-512 NV - Zip Code of Work Site,
Optional, not currently required.
347-512 NV - Not Required.
At line 92 removed 27 lines
||Column||Description||Source
|1-2 NV|Record Identifier|Constant ‘RS’
|3-4 NV|State FIPS Code|Nevada = ‘32’
|5-8 NV|State Record Type|Constant ‘SUMM‘
|9-10 NV|Blank|
|11-19 NV|Federal Tax ID Number|State Registration Number stored in [IDGV]
|20-20 NV|Blank|
|21-29 NV|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
|30-30 NV|Blank|
|31-36 NV|Reporting Period (MMCCYY)|From user specified Period End Date converted to MMCCYY for the quarter\\ \\e.g. Period End Date = ‘31-Dec-2016’, then reporting period is ‘122016’
|37-37 NV|Blank|
|38-44 NV|Number of RS Wage Records|Total number of code "RS" wage records reported since last code "RE" record
|45-45 NV|Blank|
|46-59 NV|Total Wages, Tips and Other Compensation this Quarter|Total of all code ‘RS’ wage records since last ‘RE’ record
|60-60 NV|Blank|
|61-74 NV|Non-Taxable Wages|Wages in excess of the Taxable wages portion paid during this quarter\\ \\Total of all code ‘RS’ wage records since last ‘RE’ record
|75-75 NV|Blank|
|76-89 NV|Taxable Wages Paid This Quarter|Total of all code ‘RS’ wage records since last ‘RE’ record
|90-103 NV|Blank|
|104-110 NV|Month-1 Employment for Employer|Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month.\\ \\Total of all ‘S’ records after the last ‘E’ record
|111-111 NV|Blank|
|112-118 NV|Month-2 Employment|Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month\\ \\Total of all ‘S’ records after the last ‘E’ record
|119-119 NV|Blank|
|120-126 NV|Month-3 Employment|Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month\\ \\Total of all ‘S’ records after the last ‘E’ record
|127-127 NV|Blank|
|128-128 NV|No Workers/No Wages Indicator|Enter a ‘Y’ if there were no workers/wages for the quarter being reported, otherwise leave blank
|129-512 NV|Not Required|
At line 210 added 74 lines
Column Description
1-2 NV - Record Identifier
- Constant ‘RS’
3-4 NV - State FIPS Code
- Nevada = ‘32’.
5-8 NV -State Record Type
- Constant ‘SUMM‘.
9-10 NV -NBlanks
11-19 NV - Federal Tax ID Number.
- State Registration Nukber stored in the IDGV screen.
20-20 NV - Blank.
21-29 NV - State Employer Account Number
- Derived from IDFDV screen, 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
30-30 NV - Blank.
31-36 NV - Reporting Period (MMCCYY).
- From user specified Period End Date converted to MMCCYY for the quarter
- e.g. Period End Date = ‘31-Dec-2008’, then reporting period is ‘122008’
37-37 NV - Blank.
38-44 NV - Number of RS Wage Records
- Total number of code "RS" wage records reported since last code "RE" record
45-45 NV - Blank.
46-59 NV - Total Wages, Tips and Other Compensation this Quarter.
- Total of all code ‘RS’ wage records since last ‘RE’ record
60-60 NV - Blank.
61-74 NV - Non-Taxable Wages
Wages in excess of the Taxable wages portion paid during this quarter.
Total of all code ‘RS’ wage records since last ‘RE’ record.
75-75 NV - Blank.
76-89 NV - Taxable Wages Paid this Quarter.
- Total of all code ‘RS’ wage records since last ‘RE’ record
90-103 NV - Blanks
104-110 NV - Month-1 Employment for employer.
- Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month.
- Total of all ‘S’ records after the last ‘E’ record.
111-111 NV - Blank.
112-118 NV - Month-2 Employment.
- Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month.
- Total of all ‘S’ records after the last ‘E’ record.
119-119 NV - Blank.
120-126 NV - Month-3 Employment.
- Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month.
- Total of all ‘S’ records after the last ‘E’ record.
127-127 NV - Blank.
128-128 NV - No Workers/No Wages indicator.
- Enter a ‘Y’ if there were no workers/wages for the Quarter being reported, otherwise leave blank.
129-512 NV - Not Required.
At line 285 added one line
At line 122 removed 2 lines
|1-2|Record Identifier|Constant "RF"
|3-512 NV|Blanks|Not required
At line 288 added 2 lines
1-2 - Record Identifier
- Constant "RF"
At line 291 added 3 lines
3-512 NV - Not Required, enter blanks.