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

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
28 26-Nov-2021 10:22 25 KB kparrott to previous
27 26-Nov-2021 10:22 25 KB kparrott to previous | to last
26 26-Nov-2021 10:22 25 KB kparrott to previous | to last
25 26-Nov-2021 10:22 26 KB kparrott to previous | to last
24 26-Nov-2021 10:22 31 KB eyeung to previous | to last
23 26-Nov-2021 10:22 31 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
22 26-Nov-2021 10:22 31 KB jmyers to previous | to last
21 26-Nov-2021 10:22 31 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 4 added one line
At line 5 removed 14 lines
!!What's New for Tax Year 2013
The following changes have been noted for reporting W2 wages to the Federal government:
*W2 File - RA Record – Submitter Record: New specifications have been added to the ‘Contact
E-Mail/Internet’ (positions 446-485) field.
* W2 File - RE Record – Employer Record: The ‘Other EIN’ (positions 31-39) is now applicable
to all tax jurisdiction codes.
* W2 File - RE Record – Employer Record: Five new fields have been added to the RE Employer
Record (position 222-318)
\\o Employer Contact Name (positions 222-248)
\\o Employer Contact Phone Number (positions 249-263)
\\o Employer Contact Phone Extension (positions 264-268)
\\o Employer Contact Fax Number (positions 269-278)
\\o Employer Contact E-Mail/Internet (positions 279-318)
At line 41 changed one line
|Parameters, Annual Form Code:|(example: use standard form code‘HL$US-W2-2014’)
|Parameters, Annual Form Code:|(example: use standard form code‘HL$US-W2-2017’)
At line 43 changed one line
|Parameters, Period End Date:|Year End Date (i.e. 31-Dec-2013)
|Parameters, Period End Date:|Year End Date (i.e. 31-Dec-2016)
At line 119 changed 8 lines
|266-274|Spouse’s SSN\\ \\Blank|
|275-285|Wages Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|286-296|Commissions Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|297-307|Allowances Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|308-318|Tips Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|319-329|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax\\ \\Stored as zeroes|
|330-340|Puerto Rico Tax Withheld\\ \\Stored as zeroes|
|341-351|Retirement Fund Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|266-274|Spouse’s SSN|Blank
|275-285|Wages Subject to Puerto Rico Tax|Stored as zeroes
|286-296|Commissions Subject to Puerto Rico Tax|Stored as zeroes
|297-307|Allowances Subject to Puerto Rico Tax|Stored as zeroes
|308-318|Tips Subject to Puerto Rico Tax|Stored as zeroes
|319-329|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax|Stored as zeroes
|330-340|Puerto Rico Tax Withheld|Stored as zeroes
|341-351|Retirement Fund Subject to Puerto Rico Tax|Stored as zeroes
At line 131 changed 2 lines
|363-373|Total wages, tips and other compensation subject to Virgin Islands income tax\\ \\Stored as zeroes|
|374-384|Virgin Islands, etc… Income Tax Withheld\\ \\Stored as zeroes|
|363-373|Total wages, tips and other compensation subject to Virgin Islands income tax|Stored as zeroes
|374-384|Virgin Islands, etc… Income Tax Withheld|Stored as zeroes
At line 158 changed 2 lines
|195-196|Optional code\\ \\State Specific Data\\ \\If not used, enter blanks|
|197-202|Reporting Period MMCCYY|From user specified Period End Date converted to MMCCYY for the quarter\\ \\e.g. Period End Date = ‘31-Dec-2003’, then reporting period is ‘122003’
|195-196|Optional code|State Specific Data\\ \\If not used, enter blanks
|197-202|Reporting Period MMCCYY|From user specified Period End Date converted to MMCCYY for the quarter\\ \\e.g. Period End Date = ‘31-Dec-2016’, then reporting period is ‘122016’
At line 161 changed one line
|214-224|State Quarterly Unemployment Insurance Taxable Wages\\ \\This amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the state government\\ \\Please read document [PR_US_QTR_MMREF_Generic.doc] for detail for quarterly reporting|
|214-224|State Quarterly Unemployment Insurance Taxable Wages|This amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the state government\\ \\Please read document [PR_US_QTR_MMREF_Generic.doc] for detail for quarterly reporting
At line 171 changed one line
|274-275|State code, appropriate FIPS postal numeric code|Derived from the State being reported\\ \\e.g. North Dakota is code "38"
|274-275|State code|Appropriate FIPS postal numeric code\\ \\Derived from the State being reported\\ \\e.g. North Dakota is code "38"
At line 175 changed one line
|308|Tax Type Code\\ \\This field is used to report County, City or School district tax\\ \\If the County, City or School district requires to report taxes along with the State Tax information, then the following values are used for this field:\\C – City Income Tax\\D – County Income Tax\\E – School District Income Tax\\F – Other Income Tax\\ \\[IDGV] must be set up for the Local or School Registration by County/City or School district for the following fields on the [Variables|IDGV#VariablesTab] tab:\\ \\*'W2 STATE MEDIA FILING'- Indicates whether the County/City or School should report taxes with the state or not\\*'W2 TAX TYPE CODE' - Must contain the valid Tax Type Code as defined above\\*'W2 TAXING ENTITY' - Contains the Taxing Entity code supplied by the County/City or School government booklet|If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAX TYPE CODE' field
|308|Tax Type Code|This field is used to report County, City or School district tax\\ \\If the County, City or School district requires to report taxes along with the State Tax information, then the following values are used for this field:\\C – City Income Tax\\D – County Income Tax\\E – School District Income Tax\\F – Other Income Tax\\ \\[IDGV] must be set up for the Local or School Registration by County/City or School district for the following fields on the [Variables|IDGV#VariablesTab] tab:\\ \\*'W2 STATE MEDIA FILING'- Indicates whether the County/City or School should report taxes with the state or not\\*'W2 TAX TYPE CODE' - Must contain the valid Tax Type Code as defined above\\*'W2 TAXING ENTITY' - Contains the Taxing Entity code supplied by the County/City or School government booklet\\ \\If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAX TYPE CODE' field
At line 178 changed 3 lines
|331-337|State Control Number (optional)\\ \\Blank|
|338-412|Supplemental Data 1\\ \\State Specific Data\\ \\If not used, enter blanks|
|413-487|Supplemental Data 2\\ \\State Specific Data\\ \\If not used, enter blanks|
|331-337|State Control Number (optional)|Blank
|338-412|Supplemental Data 1|State Specific Data\\ \\If not used, enter blanks
|413-487|Supplemental Data 2|State Specific Data\\ \\If not used, enter blanks
At line 186 changed one line
|3-9|Number of RW Records\\ \\Total number of code "RW" records reported since last code "RE" record|
|3-9|Number of RW Records|Total number of code "RW" records reported since last code "RE" record
At line 214 changed one line
|3-9|Number of RO Records\\ \\Total number of code "RO" records reported since last code "RE" record|
|3-9|Number of RO Records|Total number of code "RO" records reported since last code "RE" record
At line 223 changed 9 lines
|355-369|Wages Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|370-384|Commissions Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|385-399|Allowances Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|400-414|Tips Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|415-429|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax\\ \\Stored as zeroes|
|430-444|Puerto Rico Tax Withheld\\ \\Stored as zeroes|
|445-459|Retirement Fund Subject to Puerto Rico Tax\\ \\Stored as zeroes|
|460-474|Total wages, tips and other compensation subject to Virgin Islands income tax\\ \\Stored as zeroes|
|475-489| Virgin Islands, or Guam, or American Samoa, or Northern Mariana Islands Income Tax Withheld\\ \\Stored as zeroes|
|355-369|Wages Subject to Puerto Rico Tax|Stored as zeroes
|370-384|Commissions Subject to Puerto Rico Tax|Stored as zeroes
|385-399|Allowances Subject to Puerto Rico Tax|Stored as zeroes
|400-414|Tips Subject to Puerto Rico Tax|Stored as zeroes
|415-429|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax|Stored as zeroes
|430-444|Puerto Rico Tax Withheld|Stored as zeroes
|445-459|Retirement Fund Subject to Puerto Rico Tax|Stored as zeroes
|460-474|Total wages, tips and other compensation subject to Virgin Islands income tax|Stored as zeroes
|475-489| Virgin Islands, or Guam, or American Samoa, or Northern Mariana Islands Income Tax Withheld|Stored as zeroes
At line 238 changed one line
|8-16|Number of RW Records\\ \\Total number of code "RW" records on file|
|8-16|Number of RW Records|Total number of code "RW" records on file
At line 244 changed one line
*Annual Form Code - Use the standard supplied form code HL$US-W2-2013. 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-2017. The Variables need to be entered in this form code for specific use in the installation.
At line 248 changed one line
*Period End Date:Enter the quarter end date, i.e. 30-Jun-2012
*Period End Date:Enter the quarter end date, i.e. 30-Jun-2016
At line 260 changed 2 lines
|221-228 ND|Provider ID\\ \\Identifier assigned to the entity transmitting the media|Derived from [IDFDV] Field Identifier: ‘TRAN MEDIA NUMBER’
|229-229 ND|Media Type\\ \\Use ‘I’ for Internet; ‘D’ for Diskette, and ‘T’ for Tape, ‘C’ for CD-ROM|
|221-228 ND|Provider ID|Identifier assigned to the entity transmitting the media\\ \\Derived from [IDFDV] Field Identifier: ‘TRAN MEDIA NUMBER’
|229-229 ND|Media Type|Use ‘I’ for Internet; ‘D’ for Diskette, and ‘T’ for Tape, ‘C’ for CD-ROM
At line 267 changed 4 lines
|2-5|Payment Year\\ \\Enter the year for which the report is being prepared|
|6-14|Federal EIN\\ \\Enter only numeric characters|Derived from the [IDGV] State SUI Registration
|15-23|Not Required|
|24-73|Employer Name\\ \\Enter the first 50 positions of the employer’s name exactly as registered with the state UI agency|Derived from the Entity
|2-5|Payment Year|Enter the year for which the report is being prepared
|6-14|Federal EIN|Enter only numeric characters\\ \\Derived from the [IDGV] State SUI Registration
|15-123|Not Required
|124-173|Employer Name|Enter the first 50 positions of the employer’s name exactly as registered with the state UI agency\\ \\Derived from the Entity
At line 272 changed one line
|171-172|State Identifier Code.\\ \\Enter the state FIPS postal numeric code for the state to which wages are being reported\\ \\Code ‘38’ for North Dakota|
|171-172|State Identifier Code|Enter the state FIPS postal numeric code for the state to which wages are being reported\\ \\Code ‘38’ for North Dakota
At line 274 changed one line
|188-189|Reporting Period\\ \\‘03’, ‘06’, ‘09’, or ‘12’|
|188-189|Reporting Period|‘03’, ‘06’, ‘09’, or ‘12’
At line 280 changed one line
|2-10|Social Security Number\\ \\Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10|
|2-10|Social Security Number|Employee’s social security number; if not known, enter ‘I’ in position 2 and blanks in position 3-10
At line 283 changed 2 lines
|43-43|Employee Middle Initial\\ \\Leave blank if no middle initial|
|44-45|State Code\\ \\The state FIPS postal numeric code for the state to which wages are being reported\\ \\Enter ‘38’ for North Dakota|
|43-43|Employee Middle Initial|Leave blank if no middle initial
|44-45|State Code|The state FIPS postal numeric code for the state to which wages are being reported\\ \\Enter ‘38’ for North Dakota
At line 286 changed one line
|64-77|State QTR Unemployment Insurance Total Wages\\ \\Quarterly wages subject to unemployment taxes|
|64-77|State QTR Unemployment Insurance Total Wages|Quarterly wages subject to unemployment taxes
At line 292 changed one line
|2-8|Total Number of Employees\\ \\The total number of ‘S’ records since the last ‘E’ record|
|2-8|Total Number of Employees|The total number of ‘S’ records since the last ‘E’ record
At line 294 changed 3 lines
|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|
|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
At line 298 changed 3 lines
|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 of 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 of 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 of all ‘S’ records after the last ‘E’ record|
|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 of 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 of 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 of all ‘S’ records after the last ‘E’ record
At line 314 removed one line