This page (revision-39) 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
39 26-Nov-2021 10:22 16 KB Meg McFarland to previous
38 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
37 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
36 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
35 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
34 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
33 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
32 26-Nov-2021 10:22 27 KB kparrott to previous | to last
31 26-Nov-2021 10:22 28 KB kparrott to previous | to last
30 26-Nov-2021 10:22 33 KB eyeung to previous | to last
29 26-Nov-2021 10:22 34 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
28 26-Nov-2021 10:22 34 KB jmyers to previous | to last
27 26-Nov-2021 10:22 34 KB jmyers to previous | to last
26 26-Nov-2021 10:22 34 KB jmyers to previous | to last
25 26-Nov-2021 10:22 35 KB jmyers to previous | to last
24 26-Nov-2021 10:22 35 KB jmyers to previous | to last
23 26-Nov-2021 10:22 35 KB jmyers to previous | to last
22 26-Nov-2021 10:22 35 KB jmyers to previous | to last
21 26-Nov-2021 10:22 35 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 15 changed one line
This document contains abbreviated set up requirement for the state of Illinois 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 requirement for the state of Kansas only, please refer to the general document ([US_Annual_Qtrly_Reporting_GEN]) for other setup procedure 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: Illinois
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for ‘State Registration’ for State/Province: Illinois
**‘W2 STATE MEDIA FILING’ - The State of Illinois 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 Illinois only)
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up for ‘State Registration’ for State/Province: Kansas
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for ‘State Registration’ for State/Province: Kansas
**‘W2 STATE MEDIA FILING’ - Must be ‘01’ to generate KS state wage file for KS state that includes the federal employee record types ‘RW’, “RO’,’RT’, and ‘RU’.
At line 23 changed 6 lines
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up with ‘State SUI Registration’ for State/Province: Illinois
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with ‘State SUI Registration’ for State/Province: Illinois
**‘W2 STATE MEDIA FILING’- Must be ‘02’ to generate Quarterly UI wage magnetic media file for state of Illinois
*For every quarter, the [IDGV Variables|IDGV#VariablesTab] tab amounts must be reviewed for all the QTR amounts to reflect the current reporting quarter’s correct amounts.
*The [IDGV] QTR amounts are reported on [ICESA] code T Total record.
*The IDGV Govt Rate Type ‘US SUI ER Rate’ may need to be set up if Code T ‘US Tax Rate’ is reported. Please read [ICESA] Code T record for detail.
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up with ‘State SUI Registration’ for State/Province: Kansas
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with ‘State SUI Registration’ for State/Province: Kansas
**‘W2 STATE MEDIA FILING’- Must be ‘02’ to generate UI wage magnetic media file for state of Kansas.
At line 30 removed 4 lines
!IDLN – Location Plant Code
*If the Location Plant code needs to be reported on the [ICESA] code S record, the user can set up the Location Plant code can be set up on the [IDLN]screen User Defined field.
When [RPYEU] is run the first time, this UDF will be generated on [IMUF] for [P2K_CM_LOCATIONS] ‘LOCATION PLANT CODE’; this does not be set up manually.
At line 35 changed 4 lines
*The Illinois Department of Revenue accepts magnetic media filing of State W2 wage information using the EFW2 file format (required records are RA,RE,RW,RS,RT,RV and RF), and the Quarterly UI wages via magnetic media using the ICESA format.
*When using the EFW2 file format to file for the state of Illinois, the [IDGV] must be set up as follows:
**for State Registration of Illinois, the [IDGV Variables|IDGV#VariablesTab]:
***‘W2 STATE MEDIA FILING’ 01 – State requires media file in SSA format, which includes the ‘RW’,’RO’,’RU’ record types.
*The Kansas Department of Revenue accepts filing of state W2 wages via magnetic media using the EFW2 file format, and the filing of Quarterly UI wages via the NASWA/ICESA format.
*Records required for the W2 reporting are codes RA,RE,RW,RS,RT,RF; and for UI wage reporting are codes A,B,E,S
*When the EFW2 format to file for the state of Kansas, the [IDGV] must be set up as follows:
**for State Registration of Kansas, the [IDGV Variables|IDGV#VariablesTab]:
***‘W2 STATE MEDIA FILING’ 01 – Federal Format with state information (if selected), including record types RW,RO,RT, and RU.
At line 41 changed 2 lines
[RPYEU] must be run and the following selected to generate Illinois state file information:
|Report List Filters, Select State:|Illinois, USA
[RPYEU] must be run and the following selected to generate Kansas state file information:
|Report List Filters, Select State:|Kansas, USA
At line 41 added one line
The Directory and Media File Name parameters must be populated or an output file will not be produced.
At line 48 removed 3 lines
The Directory and Media File Name parameters must be populated or an output file will not be produced.\\ \\
Media Format: Use ‘Federal File Format’ (in combination of the state selection of ‘Illinois’) to produce an EFW2 file for the state of Illinois that includes ‘RW’,’RO’,’RU’ records.
At line 67 changed 2 lines
!!Quarterly UI Wage Magnetic Media Reporting - ICESA Format
Record name: Code A – Transmitter Record
!!State Magnetic Media Reporting – EFW2 Format
Record name: Code RA - Transmitter Record (same as the federal code RA)
At line 70 changed one line
%%information Note: Numeric fields are zero filled and right justified. Alphanumeric fields are filled with spaces.%%
!State Quarterly UI Wage Reporting – NASWA/ICESA format
At line 64 added 16 lines
- The user must run RPYEU and select the following to generate Kansas state file information:
- You must select state Kansas 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.
- If the Directory Name/Media File Name is not supplied, an output file will not be produced.
!!QUARTERLY UI Wage MAGNETIC MEDIA REPORTING – NASWA/ICESA format
Record name: Code A - Transmitter Record
At line 80 removed 2 lines
!!SET UP
At line 83 removed 21 lines
- This document contains abbreviated set up requirement for the state of Kansas only, please refer to the general document (US_Annual_Qtrly_Reporting_GEN) for other setup procedure that may also be required.
IDGV - State Registration
- IDGV Definition Tab must be set up with ‘State Registration’ for State/Province: Kansas
- IDGV Variables Tab must be set up with ‘State Registration’ for State/Province: Kansas
‘W2 STATE MEDIA FILING’ - Must be ‘01’ to generate KS state wage file for KS state that includes the federal employee record types ‘RW’, “RO’,’RT’, and ‘RU’.
IDGV - State SUI Registration
- IDGV Definition Tab must be set up with ‘State SUI Registration’ for State/Province: Kansas
- IDGV Variables Tab must be set up with ‘State SUI Registration’ for State/Province: Kansas
‘W2 STATE MEDIA FILING’ - Must be ‘02’ to generate UI wage magnetic media file for state of Kansas
At line 105 removed one line
!!STATE FILE PROCEDURES
At line 107 removed one line
- The state of Kansas Department of Revenue accepts filing of state W2 wages via magnetic media using the EFW2 file format, and the filing of Quarterly UI wages via the NASWA/ICESA format.
At line 109 removed 6 lines
- Records required for the W2 reporting are codes RA,RE,RW,RS,RT,RF; and for UI wage reporting are codes A,B,E,S
- Use the EFW2 format to file for the state of Kansas, the user must set up IDGV as follows:
- for State Registration of Kansas, the IDGV Variable:
‘W2 STATE MEDIA FILING’
01 – Federal Format with state information (if selected), including record types RW,RO,RT, and RU.
At line 116 removed one line
!!ANNUAL W2 WAGE REPORTING – EFW2 format
At line 118 removed 11 lines
- The user must run RPYEU and select the following to generate Kansas state file information:
Report List Filters, Select State: - Kansas, 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.
At line 130 removed one line
!!STATE MAGNETIC MEDIA REPORTING – EFW2 Format
At line 132 removed one line
Record name: Code RA - Transmitter Record (same as the federal code RA)
At line 135 removed one line
!State Quarterly UI Wage Reporting – NASWA/ICESA format
At line 137 removed one line
- The user must run RPYEU and select the following to generate Kansas state file information:
At line 139 removed 6 lines
- You must select state Kansas 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.
At line 146 removed 4 lines
- If the Directory Name/Media File Name is not supplied, an output file will not be produced.
At line 151 changed one line
!!QUARTERLY UI Wage MAGNETIC MEDIA REPORTING – NASWA/ICESA format
At line 153 removed one line
(Please note that the following ‘Not Required’ fields may or may not always contain BLANKS).
At line 155 removed one line
Note: Columns with KS indicates it is a state of Kansas specific requirement which is not the standard record format
At line 157 removed one line
Record name: Code A - Transmitter Record
At line 161 removed 3 lines