This page (revision-14) was last changed on 26-Nov-2021 10:22 by lurtan

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
14 26-Nov-2021 10:22 4 KB lurtan to previous
13 26-Nov-2021 10:22 4 KB lurtan to previous | to last
12 26-Nov-2021 10:22 4 KB kparrott to previous | to last
11 26-Nov-2021 10:22 4 KB kparrott to previous | to last
10 26-Nov-2021 10:22 4 KB eyeung to previous | to last
9 26-Nov-2021 10:22 4 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
8 26-Nov-2021 10:22 4 KB jmyers to previous | to last
7 26-Nov-2021 10:22 4 KB jmyers to previous | to last
6 26-Nov-2021 10:22 2 KB jmyers to previous | to last
5 26-Nov-2021 10:22 2 KB jmyers to previous | to last
4 26-Nov-2021 10:22 4 KB jmyers to previous | to last
3 26-Nov-2021 10:22 4 KB jmyers to previous | to last
2 26-Nov-2021 10:22 4 KB jmyers to previous | to last
1 26-Nov-2021 10:22 2 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 3 changed one line
!!!South Dakota Annual and Quarterly Reporting
!!!Colorado Annual and Quarterly Reporting
At line 5 added 3 lines
!!What's New for Tax Year 2011
There are no file format changes in wage reporting in tax year 2011 for the state of Colorado.
At line 6 changed one line
This document contains abbreviated set up requirement for the state of Georgia only, please refer to the general document ([Tax Reporting - US General]) for other setup procedure that may also be required.
IDGV - State Registration
At line 8 changed 4 lines
!IDGV - State Registration
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up for State Registration for State/Province: South Dakota.
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for State Registration for State/Province: South Dakota.
**W2 STATE MEDIA FILING- Must be 02 to generate SD State magnetic media file for SD State only
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up for ‘State Registration’ for State/Province: Colorado.
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up for ‘State Registration’ for State/Province: Colorado.
**‘W2 STATE MEDIA FILING’ must be ‘02’ to generate CO State magnetic media file for CO State only.
At line 13 removed 5 lines
!IDGV - State SUI Registration
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with State SUI Registration for State/Province: South Dakota
*The [IDGV Variables|IDGV#VariablesTab] tab must be set up with State SUI Registration for State/Province: South Dakota
**W2 STATE MEDIA FILING- Must be 02 to generate UI wage magnetic media file for South Dakota.
At line 19 changed 2 lines
*South Dakota does not have state personal income tax.
*The South Dakota Department of Labor accepts filing of UI quarterly wages via magnetic media using the [ICESA] format.
*The Colorado Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 (formerly MMREF1) format
*Record Codes required are: Code RA,RE,RS,RF
*Colorado State requires to file the CO State file by itself, therefore [IDGV] must be set up as follows:
**for State Registration of Colorado, the [IDGV Variable|IDGV#VariablesTab]:
***‘W2 STATE MEDIA FILING’ 02 – State requires its own file, do not include other State information in the State file
At line 22 changed 2 lines
!State Quarterly UI Wage Reporting ICESA format
[RPYEU] must be run and the following selected to generate South Dakota state file information:
!Annual W2 Wage Reporting – EFW2 (formerly MMREF-1) format
[RPYEU] must be run and the following selected to generate Colorado State file information:
|Media Format:|State File Format
|Select State:|Colorado, USA
!!State Media Magnetic Media Reporting – EFW2 (Formerly MMREF1) Format
Colorado state accepts W2 Wage Reporting in the standard Social Administration MMREF-1 specification.
;Record name: Code RA - Transmitter Record
!!Quarterly UI Wage Reporting – ICESA format
[RPYEU] must be run and the following selected to generate Colorado State file information:
|Media Format:|State SUI File Format
|Select State:|Colorado, USA
At line 25 changed 4 lines
*The state of South Dakota 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.
*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.
At line 30 changed one line
*Period End Date:Enter the quarter end date, i.e. 30-Jun-2016
*Period End Date:Enter the quarter end date, i.e. 30-Jun-2011
At line 34 changed 30 lines
!!Quarterly UI Wage Magnetic Media Reporting ICESA Format
%%information Please note that the following Not Required fields may or may not always contain blanks.%%
%%information Note: Columns with SD indicates it is a South Dakota specific requirement which is not the standard record format%%
!Record Name: Code E - Employer Record
||Column||Description||Status
|1-1|Record Identifier|Constant E
|2-5 SD|Payment Quarter|Enter the month and year for which the report is being prepared (enter 0307 for 1st quarter in 2007)
|6-23|Blank|
|24-73|Employer Name|Enter the first 50 positions of the employers name exactly as registered with the state UI agency\\ \\Derived from the Entity
|74-170|Blank|
|171-172|State Identifier Code|Enter the state FIPS postal numeric code for the state to which wages are being reported\\ \\Enter 46 for South Dakota
|173-181|Blank|
|182-187|State Unemployment Insurance Account Number|Enter state UI employer account number\\ \\Derived from the [IDGV] State SUI Registration
|188-275 SD|Blank|
!Record Name: Code S Employee Wage Record
||Column||Description||Status
|1-1|Record Identifier|Constant S
|2-10|Social Security Number|Employees social security number; if not known, enter I in position 2 and blanks in position 3-10
|11-30|Employee Last Name|
|31-42|Employee First Name|
|43-43|Employee Middle Initial|Enter employee middle initial. Leave blank if no middle initial
|44-45|State Code|Enter the state FIPS postal numeric code for the state to which wages are being reported\\ \\Enter 46 for South Dakota
|46-49 SD|Reporting Quarter and Year|Enter the last month and year for the calendar period for which this report applies (i.e. 0616 for Apr-June 2016)
|50-63|Blank|
|64-77|State QTR Unemployment Insurance Total Wages|Enter quarterly wages subject to unemployment taxes
|78-91|Blank|
|92-105| State QTR Unemployment Insurance Taxable Wages|State QTR UI total wages less state QTR UI excess wages
|106-275 SD|Blank|
!!ICESA for Colorado
* The format details are found at the [Colorado Department of Labor and Employment|http://www.colorado.gov/cs/Satellite/CDLE-UnempBenefits/CDLE/1248095315811]
At line 68 removed 17 lines