Table of Contents
- Texas Annual and Quarterly Reporting
- What's New for W2 Wage Reporting for Tax Year 2011
- Set Up
- IDGV - State Registration
- IDGV - State SUI Registration
- State File Procedures
- Annual W2 Wage Reporting - EFW2 File Format
- State Media Magnetic Media Reporting - EFW2 File Format
- Quarterly UI Wage Reporting - ICESA Format
- ICESA for the State of North Dakota
- Notes
Texas Annual and Quarterly Reporting#
What's New for W2 Wage Reporting for Tax Year 2011#
Texas does not have state personal income tax.- There is no Quarterly Wage Reporting File Format changes
Set Up#
This document contains abbreviated set up requirement for the state of Texas only, please refer to the general document (US_Annual_Qtrly_Reporting_GEN) for other setup procedure that may also be required.IDGV - State Registration#
- The IDGV Definitiontab must be set up for 'State Registration' for State/Province: North Dakota.
- The IDGV Variables tab must be set up for 'State Registration' for State/Province: North Dakota.
- 'W2 STATE MEDIA FILING'- The state of North Dakota 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.
IDGV - State SUI Registration#
- The IDGV Definitiontab must be set up with 'State SUI Registration' for State/Province: North Dakota.
- The IDGV Variables tab must be set up with 'State SUI Registration' for State/Province: North Dakota.
- 'W2 STATE MEDIA FILING' - Must be ‘02’ to generate State UI wage file for state of North Dakota.
State File Procedures#
- The North Dakota 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.
- The State of North Dakota requires to file the ND state file by itself, therefore IDGV must be set up as follows:
- for State Registration of North Dakota, the IDGV Variable:
- 'W2 STATE MEDIA FILING' 02 - North Dakota state requires its own file, do not include other state information in the state file.
- for State Registration of North Dakota, the IDGV Variable:
Annual W2 Wage Reporting - EFW2 File Format#
RPYEU must be run and the following selected to generate North Dakota state file information:Report List Filters, Select State: | North Dakota, USA |
Parameters, Annual Form Code: | (example: use standard form code‘HL$US-W2-2012’) |
Parameters, Period Type: | Year |
Parameters, Period End Date: | Year End Date (i.e. 31-Dec-2011) |
Parameters, Media Format: | Federal File Format |
The Directory and Media File Name parameters must be populated or an output file will not be produced.
State Media Magnetic Media Reporting - EFW2 File Format#
- Record name
- Code RA - Transmitter Record (same as federal code RA)
Quarterly UI Wage Reporting - ICESA Format#
RPYEU must be run and the following selected to generate North Dakota state file information:- The state of North Dakota 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 Record name: Code A - Transmitter Record
ICESA for the State of North Dakota#
- The format details are found at the Job Service North Dakota website.
Notes#
Click to create a new notes pageIDGV - State Registration
- IDGV Definition Tab must be set up for ‘State Registration’ for State/Province: Texas
- IDGV Variables Tab must be set up ‘State Registration’ for the state of Texas; it must also setup ‘W2 State Media Filing’ with value 02.
‘W2 STATE MEDIA FILING’ - Must be ‘02’ to generate TX State magnetic media file for TX State only IDGV - State SUI Registration
- IDGV Definition Tab must be set up with ‘State SUI Registration’ for State/Province: Texas
- IDGV Variables Tab must be set up with ‘State SUI Registration’ for State/Province: Texas
W2 STATE MEDIA FILING - Must be ‘02’ to generate UI wage magnetic media file for state of Texas W2 TAXING ENTITY - Must contain the County Code of the county with the greatest number of employees - this is reported on ICESA format code T record position 248-250
- IDGV Variables Tab must also be set up with ‘State SUI Registration’ for QTR information such as:
QTR TAXES DUE - Must contain the State Quarterly UI Taxes Due - this is reported on ICESA format code T record position 88-100 - Taxes Due = Quarterly State UI taxable wages * UI Tax rate - client must compute this field manually and enter in QTR TAXES DUE every quarter
QTR ER ASSESS RATE - Must contain the UI Tax Rate for this quarter - this is reported on ICESA format code T record position 82-87
STATE FILE PROCEDURES
- Texas does not have state personal income tax. - The Texas Workforce accepts filing of UI quarterly wages via magnetic media using the ICESA format
Quarterly UI Wage Reporting – ICESA format
- The user must run RPYEU and select the following to generate Texas State file information: Media Format: - State SUI File Format Select State: - Texas, USA
- You must select state TEXAS in the ‘Report List Filters’. - Annual Form Code’ – use the standard HighLine supplied form code HL$US-W2-2012. You will have to enter the ‘Variables’ in this Form Code for use specifically in your installation. - The ‘Quarterly Form Code’ must be entered in order to produce UI wage file in ICESA format. – use the HighLine supplied Form Code ‘HL$US-QTR-2012’.. You will have to enter the ‘Variables’ in this Form Code for use specifically in your installation. - Period Type: Quarter. - Period End Date: Enter the quarter end date, i.e. 30-Jun-2011. - Media File Type: State SUI File Format. - The Directory Name/Media File Name must be supplied or an output file will not be produced.
QUARTERLY UI Wage MAGNETIC MEDIA REPORTING – ICESA format
ICESA File Format for Texas (Multiple Work-sites not supported)
(Please not that the following ‘Not Required’ field may or may not always contains BLANKS).
Note: Columns with TX indicates it is a Texas specific requirement which is not the standard record format
Record name: Code A - Transmitter Record