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 10 lines
!!!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).
!!!Nebraska Annual and Quarterly Wage Reporting
At line 15 changed one line
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.
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 18 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 23 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 28 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 34 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 39 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 42 changed 4 lines
!Record Name: Code RA - Transmitter Record (same as the Federal code RA)
||Column||Description||Source
1-2 - Record Identifier
- Constant "RA"
__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
At line 47 changed 3 lines
3-11 - Submitter’s Employer ID number (EIN)
- Numeric only
- Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’ (seq 1000)
__RPYEU Report Filters__ \\
Select State: Nebraska, USA
At line 51 removed 4 lines
12-28 - Personal Identification Number (PIN) and Software Vendor Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-PIN-NUMBER’ (seq 1010)
- Please note that this field consists of an 8-character PIN code in positions 12-19, a
4 character Software Vendor Code in positions 20-23, and 5 blanks in positions 24-28.
At line 56 changed 2 lines
29 - Resub Indicator
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-IND’ (seq 1020)
!State Media Magnetic Media Reporting - EFW2 File Format
At line 59 removed 2 lines
30-35 - Resub WFID
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-WFID’ (seq 1030)
At line 62 changed 2 lines
36-37 - Software Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-SOFTWARE’ (seq 1040)
!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'}]
\\
At line 65 changed 2 lines
38-94 - Company Name
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-NAME’ (seq 1050)
!Record Name: Code RW - Employee Wage Record (Same as Federal Code RW)
[{InsertPage page='W2_EFW2_RECORD_RW'}]
At line 68 changed 303 lines
95-116 - Location Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-LOCN’ (seq 1060)
117-138 - Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-DELIV’ (seq 1070)
139-160 - Company City
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-CITY’ (seq 1080)
161-162 - Company State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-STATE’ (seq 1090)
163-167 - Company ZIP code
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP’ (seq 1100)
168-171 - Company ZIP code extension
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP-EXT’ (seq 1110)
172-176 - Blanks
177-199 - Company Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-STATE’ (seq 1120)
200-214 - Company Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130)
215-216 - Company Country Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140)
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 - Blanks.
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 - Blanks
446-485 - Contact E-mail
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
486-488 - Blanks
489-498 - Contact FAX
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
499-499 - Preferred Method of Problem Notification Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-METH’ (seq 1300)
500-500 - Preparer Code
- Derived from IDFDV screen, Field Identifier: ‘SUB-PREPARER’ (seq 1310)
501-512 - Blanks
!Record Name: Code RE - Employer Record (same as the Federal code RE)
||Column||Description||Source
1-2 - Record Identifier
- Constant "RE"
3-6 - Tax year CCYY
- From user specified FROM-TO period converted to CCYY
7 - Agent Indicator Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-AGENT-IND’ (seq 1500)
8-16 -Employer/Agent EIN
- System derived the applicable Federal reporting EIN, from IDGV or IDGR
17-25 - Agent for EIN
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-FOR-EIN’ (seq 1510)
26 - Terminating Business Indicator
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’ (seq 1520)
27-30 - Establishment Number
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ESTAB’ (seq 1530)
31-39 - Other EIN
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-OTHER-EIN’ (seq 1540)
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-174 - Kind of Employer
- Derived from IDFDV screen, Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)
175-178 - Blanks
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 - Country Code
- Derived from IDFDV screen, Field Identifier ‘W2-ER-COUNTRY’ (seq 2100)
219 - Employment Code
- from IDGR ‘W2 Employment Type’ or IPRLU FICA and Medicare method
- If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting
- otherwise the W2 Type of employment is derived from IDGR screen
- a set of code RE, RW/RO/RS, RT/RU records will be generated for different Type of employment
220 - Tax Jurisdiction Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TAX-JURIS’ (seq 2110)
221 - Third-Party Sick Pay Indicator
- Derived from IDFDV screen, Field Identifier: ‘SUB-3RD-PARTY-SICK’ (seq 1480)
222-512 - Blanks.
!Record Name: Code RW - Employee Wage Record (same as Federal code RW)
||Column||Description||Source
1-2 - Record Identifier
- Constant "RW"
3-11 - 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.
12-26 - Employee First Name
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510)
27-41 - Employee Middle Name or Initial
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520)
42-61 - Employee Last Name
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530)
62-65 - Employee Suffix
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540)
66-87 - Employee Location Address
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
88-109 - Employee Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
110-131 - Employee City
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’ (seq 2620)
132-133 - Employee State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’ (seq 2630)
134-138 - Employee ZIP Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’ (seq 2640)
139-142 - Employee ZIP Code Extension
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
143-147 - Blanks
148-170 - Employee Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’ (seq 2660)
171-185 - Employee Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’ (seq 2670)
186-187 - Employee Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’ (seq 2680)
188-198 - Wages, Tips and other compensation
- Derived from IDFDV screen, Field Identifier: ‘W2-FIT-WAGE’ (seq 3000)
199-209 - Federal Income Tax Withheld
- Derived from IDFDV screen, Field Identifier: ‘W2-FIT-TAX’ (seq 3010)
210-220 - Social Security Wages
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-WAGE’ (seq 3020)
221-231 - Social Security Tax Withheld
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TAX’ (seq 3030)
232-242 - Medicare Wages & Tips
- Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-WAGE’ (seq 3040)
243-253 - Medicare Tax Withheld
- Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-TAX’ (seq 3050)
254-264 - Social Security Tips
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TIP’ (seq 3060)
265-275 - Advanced Earned Income Credit
- Derived from IDFDV screen, Field Identifier: ‘W2-EIC’ (seq 3080)
276-286 - Dependent Care Benefits
- Derived from IDFDV screen, Field Identifier: ‘W2-DEP-CARE’ (seq 3090)
287-297 - Deferred Compensation contribution to Section 401(k)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-D’ (seq 4030)
298-308 - Deferred Compensation contribution to Section 403(b)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-E’ (seq 4040)
309-319 - Deferred Compensation contribution to Section 408(k)(6)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-F’ (seq 4050)
320-330 - Deferred Compensation contribution to Section 457(b)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-G’ (seq 4060)
331-341 - Deferred Compensation contribution to Section 501(c)(18)(D)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-H’ (seq 4070)
342-352 - Military Employee’s Basic Quarters and Combat Pay
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’ (seq 4140)
353-363 - Non-qualified Plan section 457
- Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-457’ (seq 3102)
364-374 - Employer Contribution to a Health Savings Account
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-W’ (seq 4190)
375-385 - Non-qualified Plan Not section 457
- Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-N457’ (seq 3104)
386-407 - Blanks
408-418 - Employer cost of premiums for Group Term Life insurance over $50000
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-C’ (seq 4020)
419-429 - Income from Non-statutory Stock Options
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-V’ (seq 4180)
430-462 - blank
463-473 - Cost of Employer-Sponsored Health Coverage
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-DD’ (seq 4250)
474-485 - blank
486 - Statutory Employee Indicator
- Derived from IDFDV screen, 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 screen, 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 screen, Field Identifier: ‘W2-3PARTY-SICK’ (seq 6060)
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
490-512 - blank
\\
At line 62 added 22 lines
|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.
At line 374 changed 2 lines
1-2 - Record Identifier
- Constant "RS"
!Record Name: Code RT - Total Record (Same as the Federal Code RT)
[{InsertPage page='W2_EFW2_RECORD_RT'}]
At line 377 removed 3 lines
3-4 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported, from IDFDV sequence 7000.
- e.g. Nebraska numeric code is “31”
At line 381 changed 63 lines
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 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-94 - Employee Location Address
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’ (seq 2600)
95-116 - Employee Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’ (seq 2610)
117-138 - Employee City
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’ (seq 2620)
139-140 - Employee State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’ (seq 2630)
141-145 - Employee ZIP Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’ (seq 2640)
146-149 - Employee ZIP Code Extension
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’ (seq 2650)
150-154 - Blanks.
155-247 NE - Blanks. 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-273 - Not Required, reserved by SSA
- Fill with Blanks.
274-275 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported
- e.g. Nebraska numeric code is "31"
276-286 - State Taxable Wages
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
287-297 - State Income Tax Withheld
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
298-512 NE - Not Required by the state of Nebraska
- Fill with Blanks
!Record Name: Code RT - Total Record (same as the Federal code RT)
!Record Name: Code RV – State Total Record (Required by State of Nebraska)
At line 445 changed 2 lines
1-2 - Record Identifier
- Constant "RT"
|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
At line 448 changed 2 lines
3-9 - Number of RW Records
- Total number of code "RW" records reported since last code "RE" record
!Record Name: Code RF - Final Record (Same as the Federal Code RF)
[{InsertPage page='W2_EFW2_RECORD_RF'}]
At line 451 removed 2 lines
10-24 - Wages, Tips and Other Compensation
- Derived from IDFDV screen, Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
At line 454 changed 2 lines
25-39 - Federal Income Tax Withheld
- Derived from IDFDV screen, Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
!!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 457 changed 2 lines
40-54 - Social Security Wages
- Derived from IDFDV screen, Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
[RPYEU] must be run with the following parameters and filters defined to generate the Nebraska State file information:
At line 460 changed 2 lines
55-69 - Social Security Tax Withheld
- Derived from IDFDV screen, Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
__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
At line 463 removed 2 lines
70-84 - Medicare Wages and Tips
- Derived from IDFDV screen, Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
At line 466 changed 2 lines
85-99 - Medicare Tax Withheld
- Derived from IDFDV screen, Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
__RPYEU Report Filters__
|Select State: Nebraska, USA
At line 469 removed 2 lines
100-114 - Social Security Tips
- Derived from IDFDV screen, Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
At line 472 changed 2 lines
115-129 - Advanced Earned Income Credit
- Derived from IDFDV screen, Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
!State Quarterly UI Wage Reporting – 512 Byte Format
At line 475 changed 48 lines
130-144 - Dependent Care Benefits
- Derived from IDFDV screen, 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 screen, 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 screen, 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 screen, 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 screen, 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 screen, Field Identifier ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
220-234 - Military Employee’s Basic Quarters and Combat Pay
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’, total of all code ‘RW’ records since last ‘RE’ record
235-249 - Non-Qualified Plan Section 457
- Derived from IDFDV 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 screen, Field Identifier: ‘W2-CODE-W’, total fo all code ‘RW’ records since last ‘RE’ record
265-279 - Non-Qualified Plan Not Section 457
- Derived from IDFDV 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 screen, 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 screen, 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 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 screen, Field Identifier ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
355-512 - blank
!Record Name: Code RV – State Total Record (required by state of Nebraska)
!Record Name: Code RE - Employer Record
At line 126 added 22 lines
|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 525 removed 2 lines
1-2 - Record Identifier
- Constant "RV"
At line 528 changed 70 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.
!Record Name: Code RF - Final Record (same as the Federal code RF)
||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
!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.
!!State Quarterly UI Wage Reporting – ICESA Format
Required record codes are ‘E’, ‘S’, and ‘T’.
!Record Name: Code E - Employer Record
||Column||Description||Source
1-1 - Record Identifier.
- Constant ‘E’.
2-158 - Not Required for Nebraska reporting.
159-159 - Name Code. System derives, always ‘S’
- indicates surname appears first in the employee name field of the following code S records
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 screen, Field Identifier: ‘OTHER EIN’ (seq 3060)
!Record Name: Code S – Employee Wage Record
!Record Name: Code RS – Employee Wage Record
At line 152 added 40 lines
|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 600 removed 2 lines
1-1 - Record Identifier.
- Constant ‘S’
At line 603 removed 173 lines
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 screen, 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 screen, Field sequence 3300
135-142 - Blanks.
143-146 - Taxing Entity Code.
- Constant ‘UTAX’.
147-161 - State Unemployment Insurance Account Number.
- Enter 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.
- Enter wages subject to state income tax.
191-204 - State Income Tax withheld
- Enter wages subject to state income tax.
205-206 - Seasonal Indicator
- Derived from IDFDV screen, 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. 062003 for Apr-June 2003).
221-226 - Date First Employed.
- Enter the month and year (i.e. 072003).
227-232 - Date of Separation.
- Enter the month and year (i.e. 112003).
233-275 - Blanks.
!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
- 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.
- 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.
- 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.
- 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 blank.
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 blanks.
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 fo 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 fo 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 blanks.
251-257 - Outside Country Employees.
- State Specific Data. If not used, enter blanks.
258-267 - Document Control Number.
- State Specific Data. If not used, enter blanks.
268-275 - Blanks.
At line 780 removed one line
This page (revision-23) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop