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 3 changed one line
!!!Nebraska Annual and Quarterly Wage Reporting
!!!Nebraska Annual and Quarterly Reporting
!!What's New for Tax Year 2011
The following changes have been noted for reporting W2 wages to the Federal Government:using the EFW2 file format:
*(W2 Form) The ‘Advance Earned Income Credit Payment’ field is eliminated for tax year beginning after December 31, 2010. Box 9, Advance EIC payments, has been deleted from the 2011 Form W2.
*(W2 Form) Code DD is added to box 12 of the 2011 form W2 to report the cost of employer-sponsored health coverage. However, this reporting will not be mandatory for 2011.
*(W2 Form) Code EE, Designated Roth contributions under a government section 457(b) plan, has been added to the list of codes in box 12 of Form W2.
*(W2 File) A new field, 'Kind of Employer' has been added to the RE Employer Record (position 174). This is a required field.
*(W2 File) A new field, 'Cost of Employer-Sponsored Health Coverage' has been added to the RW Employee Record (positions 463-473) and the RT Total Record (positions 295-309).
*(W2 File) A new field, 'Designated Roth Contributions Under a Governmental Section 457(b) Plan' has been added to the RO Employee Record (positions 111-121) and the RU Total Record (positions 145-159).
At line 6 changed one line
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.
This document contains abbreviated set up requirement for the state of Nebraska only, please refer to the general document ([US_Annual_Qtrly_Reporting_GEN]) for other setup procedure that may also be required.
At line 9 changed 4 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 Nebraska 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 NE only)
At line 15 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 20 changed 3 lines
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.
\\
*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.
At line 24 changed 6 lines
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.
!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
At line 31 changed 2 lines
!!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:\\ \\
!!State Media Magnetic Media Reporting - EFW2 File Format
;Record name:Code RA - Transmitter Record (same as federal code RA)
At line 34 changed 7 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
!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-2012. 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-2011
*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 42 changed 2 lines
__RPYEU Report Filters__ \\
Select State: Nebraska, USA
State Quarterly UI Wage Reporting – ICESA Format
Required record codes are ‘E’, ‘S’, and ‘T’.
At line 45 changed 149 lines
!State Media Magnetic Media Reporting - EFW2 File Format
!Record Name: Code RA – Submitter Record (Same as the Federal Code RA)
[{InsertPage page='W2_EFW2_RECORD_RA'}]
\\
!Record Name: Code RE – Employer Record (Same as the Federal Code RE)
[{InsertPage page='W2_EFW2_RECORD_RE'}]
\\
!Record Name: Code RW - Employee Wage Record (Same as Federal Code RW)
[{InsertPage page='W2_EFW2_RECORD_RW'}]
\\
!Record Name: Code RS - State Record
||Column||Description||Source
|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 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)
|139-140|Employee State Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-EE-STATE’ (seq 2630)
|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.
!Record Name: Code RT - Total Record (Same as the Federal Code RT)
[{InsertPage page='W2_EFW2_RECORD_RT'}]
!Record Name: Code RV – State Total Record (Required by State of Nebraska)
||Column||Description||Source
|1-2|Record Identifier|Constant "RV"
|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
!Record Name: Code RF - Final Record (Same as the Federal Code RF)
[{InsertPage page='W2_EFW2_RECORD_RF'}]
!!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. \\ \\
[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
||Column||Description||Source
|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
!Record Name: Code RS – Employee Wage Record
||Column||Description||Source
|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.
!!ICESA for the State of Nebraska
* The format details are found at the ......
At line 66 added one line
[cleanup]
This page (revision-23) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop