This page (revision-23) 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
23 26-Nov-2021 10:22 17 KB Meg McFarland to previous
22 26-Nov-2021 10:22 17 KB Meg McFarland to previous | to last
21 26-Nov-2021 10:22 17 KB Meg McFarland to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - NE
Tax Reporting - NE

Version management

Difference between version and

At line 6 changed one line
This document contains abbreviated set up requirement for the state of Nebraska only, please refer to the general document ([Tax Reporting - US General]) for other setup procedure that may also be required.
This document contains abbreviated set up requirements for the State of Nebraska only. Please refer to the general document ([Tax Reporting - US General]) for other setup procedures that may also be required.
At line 9 changed 3 lines
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up for 'State Registration' for State/Province: Nebraska.
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for 'State Registration' for State/Province: Nebraska.
*‘W2 STATE MEDIA FILING’ - The state of Nebraska accepts W2 wage report with federal and other state information, therefore, the Media Filing variable can be set to ‘01’, which will include state information in the Federal File. (However it must be set to ‘02’ if a W2 magnetic media file is required for the state of NE only)
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up for 'State Registration' for State/Province: Nebraska
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for 'State Registration' for State/Province: Nebraska
*‘W2 STATE MEDIA FILING’ - The state of Nebraska accepts W2 wage report with federal and other state information, therefore, the Media Filing variable can be set to ‘01’, which will include state information in the Federal File.
**However it must be set to ‘02’ if a W2 magnetic media file is required for the State of Nebraska only
At line 14 changed 3 lines
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with 'State SUI Registration' for State/Province: Nebraska.
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with 'State SUI Registration' for State/Province: Nebraska.
**'W2 STATE MEDIA FILING' - Must be ‘02’ to generate State UI wage file for state of Nebraska.
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with 'State SUI Registration' for State/Province: Nebraska
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with 'State SUI Registration' for State/Province: Nebraska
**'W2 STATE MEDIA FILING' - Must be ‘02’ to generate State UI wage file for State of Nebraska
At line 19 changed 5 lines
*The Nebraska Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 format, and the filing of Quarterly UI wages via magnetic media using the [ICESA] format.
*Records required for the W2 reporting are: Codes RA,RE,RW,RS,RT,RV,RF; and for the UI wage reporting: Code ‘E’, ‘S’ and ‘T’.
*The State of Nebraska requires to file the NE state file by itself, therefore [IDGV] must be set up as follows:
**for State Registration of Nebraska, the IDGV Variable:
***'W2 STATE MEDIA FILING' 02 - Nebraska state requires its own file, do not include other state information in the state file.
The Nebraska Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 format.
*Records required for the W2 reporting are: Codes RA, RE, RW, RS, RT, RV and RF.
\\
At line 25 changed 4 lines
!Annual W2 Wage Reporting - EFW2 File Format
[RPYEU] must be run and the following selected to generate Nebraska state file information:
|Media Format:|State File Format
|Select State:|Nebraska, USA
The Nebraska Department of Labor accepts filing of Quarterly UI wages via magnetic media using the 512 Byte format. \\
*Records required for the UI wage reporting: Codes RE and RS. \\ \\
The State of Nebraska requires to file the Nebraska State file by itself, therefore [IDGV] must be set up as follows:
*for State Registration of Nebraska, the IDGV Variable:
**'W2 STATE MEDIA FILING' 02 - Nebraska state requires its own file, do not include other state information in the state file.
At line 30 changed 2 lines
!!State Media Magnetic Media Reporting - EFW2 File Format
STATE MAGNETIC MEDIA REPORTING – EFW2 File Format
!!Annual W2 Wage Reporting - EFW2 File Format
[RPYEU] must be run with the following report parameters and filters defined to generate the Nebraska State file information:\\ \\
At line 34 added 15 lines
__RPYEU Report Parameters__
|Annual Form Code|Use standard form code, such as 'HL$US-W2-YYYY'
|Period Type|Mandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period. Enter in DD-MMM-YYYY format
|Media Format|Mandatory. Set to State File Format \\Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
|Media File Name|Mandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced
__RPYEU Report Filters__ \\
Select State: Nebraska, USA
!State Media Magnetic Media Reporting - EFW2 File Format
At line 41 changed 46 lines
||Column||Description||Source
|1-2|Record Identifier|Constant "RW"
|3-11|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
|12-26|Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
|27-41|Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
|42-61|Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
|62-65|Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
|66-87|Employee Location Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
|88-109|Employee Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
|110-131|Employee City|Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’ (seq 2620)
|132-133|Employee State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’ (seq 2630)
|134-138|Employee ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP’ (seq 2640)
|139-142|Employee ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
|143-147|Blank|
|148-170|Employee Foreign State/Province|Derived from [IDFDV] Field Identifier: ‘W2-EE-F-STATE’ (seq 2660)
|171-185|Employee Foreign Postal Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-F-POSTAL’ (seq 2670)
|186-187|Employee Country Code|Derived from [IDFDV] Field Identifier: ‘W2-EE-COUNTRY’ (seq 2680)
|188-198|Wages, Tips and other compensation|Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’ (seq 3000)
|199-209|Federal Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’ (seq 3010)
|210-220|Social Security Wages|Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’ (seq 3020)
|221-231|Social Security Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’ (seq 3030)
|232-242|Medicare Wages & Tips|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’ (seq 3040)
|243-253|Medicare Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-TAX’ (seq 3050)
|254-264|Social Security Tips|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TIP’ (seq 3060)
|265-275|Advanced Earned Income Credit|Derived from [IDFDV] Field Identifier: ‘W2-EIC’ (seq 3080)
|276-286|Dependent Care Benefits|Derived from [IDFDV] Field Identifier: ‘W2-DEP-CARE’ (seq 3090)
|287-297|Deferred Compensation contribution to Section 401(k)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-D’ (seq 4030)
|298-308|Deferred Compensation contribution to Section 403(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-E’ (seq 4040)
|309-319|Deferred Compensation contribution to Section 408(k)(6)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-F’ (seq 4050)
|320-330|Deferred Compensation contribution to Section 457(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-G’ (seq 4060)
|331-341|Deferred Compensation contribution to Section 501(c)(18)(D)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-H’ (seq 4070)
|342-352|Filler
|353-363|Non-qualified Plan section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-457’ (seq 3102)
|364-374|Employer Contribution to a Health Savings Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-W’ (seq 4190)
|375-385|Non-qualified Plan Not section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-N457’ (seq 3104)
|386-407|Blank|
|408-418|Employer cost of premiums for Group Term Life insurance over $50000|Derived from [IDFDV] Field Identifier: ‘W2-CODE-C’ (seq 4020)
|419-429|Income from Non-statutory Stock Options|Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’ (seq 4180)
|430-462|Blank|
|463-473| Cost of Employer-Sponsored Health Coverage|Derived from [IDFDV] Field Identifier: ‘W2-CODE-DD’ (seq 4250)
|474-485|Blank|
|486|Statutory Employee Indicator|Derived from [IDFDV] Field Identifier: ‘W2-STAT-EE’ (seq 6000)\\ \\If the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
|487|Blank|
|488|Retirement Plan Indicator|Derived from [IDFDV] Field Identifier: ‘W2-RETIRE-PLAN’ (seq 6020)\\ \\If the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
|489|Third-Party Sick Pay Indicator|Derived from [IDFDV] Field Identifier: ‘W2-3PARTY-SICK’ (seq 6060)\\ \\If the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
|490-512|Blank|
[{InsertPage page='W2_EFW2_RECORD_RW'}]
At line 59 added one line
\\
At line 91 changed 10 lines
|3-4|State code, appropriate FIPS postal numeric code|Derived from the State being reported, from [IDFDV] sequence 7000\\ \\ e.g. Nebraska numeric code is “31”
|5-9|Taxing Entity Code|If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAXING ENTITY' field for the County, City or School district tax being reported
|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)
|3-4|State code|Enter the appropriate FIPS postal numeric code \\Nebraska numeric code is “31” \\Derived from the State being reported, from [IDFDV] sequence 7000
|5-9 NE|Taxing Entity Code|Fill with blanks
|10-18|Social Security Number|Enter the employee's SSN \\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|Enter the employee's first name. Left justify and fill with blanks. \\Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
|34-48|Employee Middle Name or Initial|Enter the employee's middle name or initial, if applicable. Left justify and fill with blanks. \\Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
|49-68|Employee Last Name|Enter the employee's last name. \\Left justify and fill with blanks. \\Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
|69-72|Employee Suffix|Enter the employee's alphabetical suffix, if applicable. \\Left justify and fill with blanks. \\Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
|73-94|Employee Location Address|Enter the employee's location address \\Derived from [IDFDV] Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
|95-116|Employee Delivery Address|Enter the employee's delivery address \\Derived from [IDFDV] Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
|117-138|Employee City|Enter the employee's city \\Derived from [IDFDV] Field Identifier: ‘W2-EE-CITY’ (seq 2620)
At line 102 changed 10 lines
|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-154|Blank|
|155-247 NE|Blank|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-273|Not Required, Reserved by SSA\\ \\Fill with blanks
|274-275|State Code, Appropriate FIPS Postal Numeric Code|Derived from the State being reported\\ \\ e.g. Nebraska numeric code is "31"
|276-286|State Taxable Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
|287-297|State Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
|298-512 NE|Not Required by the State of Nebraska|Fill with blanks
|141-145|Employee ZIP Code|Enter the employee's ZIP Code \\Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP’ (seq 2640)
|146-149|Employee ZIP Code Extension|Enter the employee's ZIP Code extension, if applicable. \\Derived from [IDFDV] Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
|150-154|Blank|Fill with blanks. Reserved for SSA use.
|155-247 NE|Blank|Not required. Fill with blanks.
|248-267|State Employer Account Number|Enter the employer's account number \\Left justify and fill with blanksDerived 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|Fill with blanks. Reserved for SSA use.
|274-275|State Code|Enter the appropriate FIPS Postal Numeric Code \\Nebraska's numeric code is "31" \\Derived from the State being reported
|276-286|State Taxable Wages|nter the total State taxable wages \\Enter dollar and cents \\Omit decimals \\Right justify and zero fill \\Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
|287-297|State Income Tax Withheld|Enter the total State income tax withheld \\Enter dollar and cents \\Omit decimals \\Right justify and zero fill \\Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
|298-512 NE|Blank|Fill with blanks.
At line 114 changed 27 lines
||Column||Description||Source
|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
|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
|85-99|Medicare Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
|100-114|Social Security Tips|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
|115-129|Advanced Earned Income Credit|Derived from [IDFDV] Field Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
|130-144|Dependent Care Benefits|Derived from [IDFDV] Field Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
|145-159|Deferred Compensation Contributions to Section 401(k)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-D’, total of all code "RW" records since last "RE" record
|160-174|Deferred Compensation Contributions to Section 403(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-E’, total of all code "RW" records since last "RE" record
|175-189|Deferred Compensation Contributions to Section 408(k)(6)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-F’, total of all code "RW" records since last "RE" record
|190-204|Deferred Compensation Contributions to Section 457(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-G’, total of all code "RW" records since last "RE" record
|205-219|Deferred Compensation Contributions to Section 501(c)(18)(D)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
|220-234|Filler
|235-249|Non-Qualified Plan Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
|250-264|Employer Contribution to a Health Savings Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-W’, total of all code ‘RW’ records since last ‘RE’ record
|265-279|Non-Qualified Plan Not Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
|280-294|Blank|
|295-309|Cost of Employer-Sponsored Health Coverage|Derived from [IDFDV] Field Identifier: ‘W2-CODE-DD’, total of all code "RW" records since last "RE" record
|310-324|Employer Cost of Premiums for Group Term Life Insurance over $50000|Derived from [IDFDV] Field Identifier: ‘W2-CODE-C’, total of all code "RW" records since last "RE" record
|325-339|Income Tax Withheld by Third-Party Payer|Derived from [IDFDV] Field Identifier: ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
|340-354|Income from Non-statutory Stock Options|Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
|355-512|Blank|
[{InsertPage page='W2_EFW2_RECORD_RT'}]
At line 88 added one line
At line 145 changed 4 lines
|3-9|Number of ‘RS’ records in file|
|10-24|Total State Taxable Wages|Total as reported in all RS records positions 276-286 in this file
|25-39|Total State Income Tax Withheld|Total as reported in all RS records positions 287-297 in this file
|40-512|Leave Blank|
|3-9|Total RS Records|Enter the total number of ‘RS’ records in file
|10-24|Total State Taxable Wages|Enter the total State taxable wages \\Derived from the total as reported in all RS records positions 276-286 in this file
|25-39|Total State Income Tax Withheld|Enter the total State income tax withheld \\Derived from the total as reported in all RS records positions 287-297 in this file
|40-512|Blank|Fill with blanks
At line 151 changed 5 lines
||Column||Description||Source
|1-2|Record Identifier|Constant "RF"
|3-7|Blank|
|8-16|Number of RW Records|Total number of code "RW" records on file
|17-512|Blank|
[{InsertPage page='W2_EFW2_RECORD_RF'}]
At line 157 removed 13 lines
!Quarterly UI Wage Reporting - ICESA Format
[RPYEU] must be run and the following selected to generate Nebraska state file information:
|Media Format:|State SUI File Format
|Select State:|Nebraska, USA
*To produce a SUI file format in the [ICESA] format, the Quarterly Form Code must be entered.
* The state of Nebraska must be selected in the 'Report List Filters'.
*Annual Form Code - Use the standard supplied form code HL$US-W2-2017. The Variables need to be entered in this form code for specific use in the installation.
*The 'Quarterly Form Code' must be entered in order to produce the UI wage file in [ICESA] format.
*Use the supplied form code 'HL$US-QTR-2012'. The Variables need to be entered in this form code for specific use in the installation.
*Period Type:Quarter
*Period End Date:Enter the quarter end date, i.e. 30-Jun-2016
*Media File Type:State SUI File Format\\ \\
*If the Directory Name/Media File Name is not supplied, an output file will not be produced.
At line 171 changed 2 lines
!!State Quarterly UI Wage Reporting – ICESA Format
Required record codes are ‘E’, ‘S’, and ‘T’.
!!Quarterly UI Wage Reporting - 512 Byte Format
The Nebraska Department of Labor accepts filing of Quarterly UI wages via magnetic media using the 512 Byte format. \\
*Records required for the UI wage reporting: Code RE and RS. \\ \\
At line 174 changed one line
!Record Name: Code E - Employer Record
[RPYEU] must be run with the following parameters and filters defined to generate the Nebraska State file information:
__RPYEU Report Parameters__
|Annual Form Code|Use standard form code, such as 'HL$US-W2-20YY'
|Quarterly Form Code|Use the standard form code ‘HL$US-QTR-20YY. \\Must be entered in order to produce the UI wage file in [ICESA] format.
|Govt Interface Format|Mandatory. Enter HL$US-QTR-MM20YY
|Period Type|Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period. Enter in DD-MMM-YYYY format
|Media Format|Mandatory. Set to State SUI File Format \\Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
|Media File Name|Mandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced
__RPYEU Report Filters__
|Select State: Nebraska, USA
!State Quarterly UI Wage Reporting – 512 Byte Format
!Record Name: Code RE - Employer Record
At line 176 changed 8 lines
|1-1|Record Identifier|Constant ‘E’
|2-158|Not Required for Nebraska reporting|
|159-159|Name Code|Indicates surname appears first in the employee name field of the following code S records\\ \\System derived, always ‘S’
|160-166|Not required|
|167-170|Taxing Entity Code|Constant ‘ B ’ (‘B’ in position 168)
|171-172|State Identifier Code|Enter the state FIPS postal numeric code for the state to which wages are being reported
|173-187|State Unemployment Insurance Account Number|Enter state UI employer account number in positions 176 to 187 only\\ \\Derived from the [IDGV] State SUI Registration (first 3 characters must be blank)
|188-275|Not Required|Enter blanks if no other EIN was used\\ \\Derived from [IDFDV] Field Identifier: ‘OTHER EIN’ (seq 3060)
|1-2|Record Identifier|Constant ‘RE’
|3-6 NE|Year|Enter the year that is being reported, in YYYY format
|7 NE|Agent Indicator Code|If applicable, enter one of the following codes: \\* 1 = 2678 Agent \\* 2 = Common Pay Master. \\Otherwise, fill with blanks
|8-16|Employer/Agent Employer Identification Number|If an Agent Indicator Code was defined in position 7, enter the Agent's FEIN. \\Otherwise, enter the employer's FEIN \\Numeric characters only \\Derived from the [IDGV] State SUI Registration
|17-25|Agent for EIN|If a “1” was entered in the Agent Indicator Code field, (position 7), enter the Employer’s EIN for which you are an Agent. \\Otherwise, fill with blanks
|26 NE|Terminating Business Indicator|Enter '1' if you have terminated your business during this tax year. Otherwise, enter '0' (zero).
|27-30 NE|Establishment Number|If this file contains multiple Code RE records with the same EIN, use this field to designate various store or factory locations or types of payroll. \\Otherwise, fill with blanks. \\Enter any combination of blanks, numbers or letters. \\Certain military employers must use this field.
|31-39 NE|Other EIN|For this tax year, if you submitted Form 941 or 943 to the IRS or W-2 data to SSA and a different EIN was used from the positions 8-16, enter the other EIN. \\Otherwise, fill with blanks.
|40-96|Employer Name|Enter the employer’s name. \\Derived from the Entity.
|97-118|Location Address|Enter the employer's location address \\Derived from the Entity Location.
|119-140|Delivery Address|Enter the employer's delivery address (Street or Post Office Box). \\Left justify and fill with blanks. \\Derived from the 'W2-ER-DELIV-ADDR' [IDFDV] Field Identifier (seq 2030).
|141-162|City|Enter the employer's city. \\Left justify and fill with blanks. \\Derived from the 'W2-ER-CITY' [IDFDV] Field Identifier (seq 2040).
|163-164|State Abbreviation|Enter the employer's State postal abbreviation. \\For a foreign address, fill with blanks. \\Derived from the 'W2-ER-STATE' [IDFDV] Field Identifier (seq 2050).
|165-169|ZIP Code|Enter the employer's zip Code. \\For a foreign address, fill with blanks. \\Derived from the 'W2-ER-ZIP' [IDFDV] Field Identifier (seq 2060).
|170-173|ZIP Code Extension|Enter the employer's four-digit extension of the zip code, if applicable. If not applicable, fill with blanks. \\Derived from the 'W2-ER-ZIP-EXT' [IDFDV] Field Identifier (seq 2070).
|174-178 NE|Blank|Fill with blanks
|179-201|Foreign State/Province|Enter the employer's foreign State/Province, if applicable. \\ Left justify and fill with blanks. Otherwise, fill with blanks.
|202-216|Foreign Postal Code|If applicable, enter the company's foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks.
|217-218|Country Code|If one of the following applies, fill with blanks: \\ \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code.
|219|Employment Code|Enter the appropriate employment code. Options are: \\* A = Agriculture (Form 943)\\* H = Household (Schedule H)\\* M = Military (Form 941) \\* Q = Medicare Qualified Government Employment (Form 941)\\* X = Railroad (CT-1) \\* F = Regular (Form 944)\\* R = Regular (all others) (Form 941). \\ NOTE: Railroad reporting is not applicable for Puerto Rico and territorial employers.
|220|Tax Jurisdiction Code|Required. Enter the code that identifies the type of income tax withheld from the employee's earnings. \\Options are: \\* Blank (W-2) \\* V = Virgin Islands (W-2VI) \\* G = Guam (W-2GU) \\* S = American Samoa (W-2AS) \\* N = Northern Mariana Islands (W-2CM) \\* P = Puerto Rico (W-2PR/499R-2)
|221-512 NE|Blank|Fill with blanks
At line 185 changed one line
!Record Name: Code S – Employee Wage Record
!Record Name: Code RS – Employee Wage Record
At line 187 changed 28 lines
|1-1|Record Identifier|Constant ‘S’
|2-10|Social Security Number|Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10
|11-37|Employee Name|Surname first
|38-91|Not required|
|92-105|State QTR Unemployment Insurance Taxable Wages|State QTR UI total wages less state QTR UI excess wages
|106-120|Quarterly State Disability Insurance Taxable Wages|State Specific Data\\ \\If not used, enter zero
|121-129|Quarterly Tip Wages|Include all tip wages
|130-131|Number of Weeks Worked|The number of weeks worked in the reporting period\\ \\Derived from [IDFDV] Field Sequence: 3080\\ \\This can either be ‘Plugged’ as a constant, be picked up from a Pay Component that is previously populated by a UserCalc, or if left null the P2K will compute the value.
|132-134|Number of Hours Worked|The number of hours worked in the reporting period\\ \\Derived from [IDFDV] Field Sequence: 3300
|135-142|Blank|
|143-146|Taxing Entity Code|Constant ‘UTAX’
|147-161|State Unemployment Insurance Account Number|The state UI employer account number\\ \\SUI Registration Number from [IDGV]
|162-176|Unit/Division Location/Plant Code|The ID assigned to identify wages by work site
|177-190|State Taxable Wages|
|191-204|State Income Tax withheld|
|205-206|Seasonal Indicator|Derived from [IDFDV] Field Sequence: 3270
|207-207|Employer Health Insurance Code|State Specific Data\\ \\If not used, enter blank
|208-208|Employee Health Insurance Code|State Specific Data\\ \\If not used, enter blank
|209-209|Probationary Code|State Specific Data\\ \\If not used, enter blank
|210-210|Officer Code|Enter ‘1’ for officers of the corporation, else enter ‘0’
|211-211|Wage Plan Code|State Specific Data\\ \\If not used, enter blank
|212-212|Month-1 Employment|Enter ‘1’ if employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month, else enter ‘0’
|213-213|Month-2 Employment|Enter ‘1’ if employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month, else enter ‘0’
|214-214|Month-3 Employment|Enter ‘1’ if employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month, else enter ‘0’
|215-220|Reporting Quarter and Year|Enter the last month and year for the calendar period for which this report applies (i.e. 062016 for Apr-June 2016)
|221-226|Date First Employed|Enter the month and year (i.e. 072016)
|227-232|Date of Separation|Enter the month and year (i.e. 112016)
|233-275|Blank|
|1-2|Record Identifier|Constant ‘RS’
|3-4|State code|Enter the appropriate FIPS postal numeric code \\Nebraska numeric code is “31” \\Derived from the State being reported, from [IDFDV] sequence 7000
|5-9|Taxing Entity Code|Defined by State/Local Agency
|10-18|Social Security Number|Enter the employee's SSN \\If an invalid SSN is encountered, this field is entered with zeroes \\Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’ (seq 2500)
|19-33|Employee First Name|Enter the employee's first name \\Left justify and fill with blanks \\Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’
|34-48|Employee Middle Name or Initial|Enter the employee's middle name or initial, if applicable. Leave blank if no middle initial \\Left justify and fill with blanks \\Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’
|49-68|Employee Last Name|Enter the employee's last name \\Left justify and fill with blanks \\Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’
|69-72|Employee Suffix|If applicable, enter the employee’s alphabetic suffix. Otherwise, fill with blanks \\Left justify and fill with blanks
|73-94|Location Address|Enter the employee's location address \\Derived from the Entity Location.
|95-116|Delivery Address|Enter the employee's delivery address (Street or Post Office Box). \\Left justify and fill with blanks. \\Derived from the 'W2-EE-DELIV-ADDR' [IDFDV] Field Identifier (seq 2030).
|117-138|City|Enter the employee's city. \\Left justify and fill with blanks. \\Derived from the 'W2-EE-CITY' [IDFDV] Field Identifier (seq 2040).
|139-140|State Abbreviation|Enter the employee's State postal abbreviation. \\For a foreign address, fill with blanks. \\Derived from the 'W2-ER-STATE' [IDFDV] Field Identifier (seq 2050).
|141-145|ZIP Code|Enter the employee's zip Code. \\For a foreign address, fill with blanks. \\Derived from the 'W2-EE-ZIP' [IDFDV] Field Identifier (seq 2060).
|146-149|ZIP Code Extension|Enter the employee's four-digit extension of the zip code, if applicable. If not applicable, fill with blanks. \\Derived from the 'W2-EE-ZIP-EXT' [IDFDV] Field Identifier (seq 2070).
|150-154 NE|Blank|Fill with blanks
|155-177 NE|Foreign State/Province|Enter the employee's foreign State/Province, if applicable. \\ Left justify and fill with blanks. Otherwise, fill with blanks.
|178-192|Foreign Postal Code|If applicable, enter the employee's foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks.
|193-194|Country Code|If one of the following applies, fill with blanks: \\ \\* One of the 50 States of the U.S.A. \\* District of Columbia \\* Military Post Office (MPO) \\* American Samoa \\* Guam \\* Northern Mariana Islands \\* Puerto Rico \\* Virgin Islands \\ \\Otherwise, enter the applicable Country Code.
|195-196|Optional Code|Defined by State/Local Agency
|197-202|Reporting Period|Enter the last month number and 4 digit year for the calendar quarter being reported, in MMYYYY format. \\ Example: 0320YY for January-March of 20YY
|203-213|State Quarterly Unemployment Insurance Total Wages|Enter the total State QTR wages \\Right justify and zero fill
|214-224|State Quarterly Unemployment Insurance Total Taxable Wages|Enter the total State QTR taxable wages \\Right justify and zero fill
|225-226|Number of Weeks Worked|Defined by State/Local Agency
|227-234|Date First Employed|Enter the month, day, and four digit year the employee was first employed, in MMDDYYYY format
|235-242|Date of Separation|Enter the month, day, and four digit year the employee separated from your organization, in MMDDYYYY format
|243-247|Blank|Fill with blanks
|248-267|State Employer Account Number|Enter the State UI employer account number \\Derived from the SUI Registration Number defined on [IDGV]
|268-273|Blank|Fill with blanks
|274-275|State Code|Enter the appropriate FIPS postal numeric code \\Nebraska numeric code is “31” \\Derived from the State being reported, from [IDFDV] sequence 7000
|276-286|State Taxable Wages|Enter the total State taxable wages. \\Right justify and zero fill
|287-297|State Income Tax Withheld|Enter the total State income tac withheld \\Right justify and zero fill
|298-307|Other State Data|Defined by State/Local Agency
|308|Tax Type Code|Tax Type Code|Enter the appropriate code for entries in fields 309-330: \\* C = City Income Tax \\* D = County Income Tax \\* E = School District Income Tax \\* F = Other Income Tax. \\ __Applies to income tax reporting.__
|309-319|Local Taxable Wages|Defined by State/Local Agency
|320-330|Local Income Tax Withheld|Defined by State/Local Agency
|331-337|State Control Number|Optional
|338-341 NE|Employee Hours Paid|Optional. Enter the employee's total quarterly hours paid \\Include regular, vacation and sick hours paid \\ If not applicable, zero fill. \\Right justify and zero fill
|342-466 NE|Employee Job Title|Optional. Enter the employee's primary job title. \\ If not applicable, fill with blanks
|467-487 NE|Supplemental Data
|488-512|Blank|Fill with blanks. Reserved for SSA use.
At line 216 removed 31 lines
!Record Name: Code T - Total Record
||Column||Description||Source
|1-1|Record Identifier|Constant ‘T’
|2-8|Total Number of Employees|The total number of ‘S’ records since the last ‘E’ record
|9-12|Taxing Entity Code|Constant ‘UTAX’
|13-26|State QTR Total Gross Wages for employer|The QTR gross wages subject to all taxes\\ \\Total of this field on all ‘S’ records since the last ‘E’ record
|27-40|State QTR Unemployment Insurance Total Wages for employer|The QTR wages subject to state unemployment taxes\\ \\Total of this field on all ‘S’ records since the last ‘E’ record
|41-54|State QTR Unemployment Insurance Excess Wages for employer|The QTR wages in excess of the state UI taxable wage base\\ \\Total of all ‘S’ records since the last ‘E’ record
|55-68|State QTR Unemployment Insurance Taxable Wages for employer|The QTR UI total wages less state QTR UI excess wages\\ \\Total of all ‘S’ records since the last ‘E’ record
|69-81|Quarterly tip wages for employer|Enter all tip income\\ \\Total of this field on all ‘S’ records since the last ‘E’ record
|82-87|UI tax rate this quarter|The employer UI rate for this reporting period\\ \\One decimal point followed by 5 digits e.g. 2.8%=’.02800’
|88-100|State QTR UI taxes due|UI taxes due\\ \\QTR state UI taxable wages times UI tax rate
|101-111|Previous Quarter(s) underpayment|State Specific Data\\ \\If not used, enter zero
|112-122|Interest|State Specific Data\\ \\If not used, enter zero
|123-133|Penalty|State Specific Data\\ \\If not used, enter zero
|134-144|Credit/Overpayment|State Specific Data\\ \\If not used, enter zero
|145-148|Employer Assessment Rate|State Specific Data\\ \\If not used, enter zero
|149-159|Employer Assessment Amount|State Specific Data\\ \\If not used, enter zero
|160-163|Employee Assessment Rate|State Specific Data\\ \\If not used, enter zero
|164-174|Employee Assessment Amount|State Specific Data\\ \\If not used, enter zero
|175-185|Total Payment Due|State Specific Data\\ \\If not used, enter zero
|186-198|Allocation Amount|State Specific Data\\ \\If not used, enter zero
|199-212|Wages subject to State Income Tax|State Specific Data\\ \\If not used, enter zero
|213-226|State Income Tax withheld|State Specific Data\\ \\If not used, enter zero
|227-233| 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
|234-240|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
|241-247|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 for all ‘S’ records after the last ‘E’ record
|248-250|Country Code|State Specific Data\\ \\If not used, enter zero
|251-257|Outside Country Employees|State Specific Data\\ \\If not used, enter zero
|258-267|Document Control Number|State Specific Data\\ \\If not used, enter zero
|268-275|Blank|
At line 248 removed one line
This page (revision-23) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop