This page (revision-54) 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
54 26-Nov-2021 10:22 18 KB Meg McFarland to previous
53 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
52 26-Nov-2021 10:22 35 KB eyeung to previous | to last
51 26-Nov-2021 10:22 37 KB lurtan to previous | to last
50 26-Nov-2021 10:22 38 KB eyeung to previous | to last
49 26-Nov-2021 10:22 38 KB kparrott to previous | to last
48 26-Nov-2021 10:22 38 KB kparrott to previous | to last
47 26-Nov-2021 10:22 38 KB kparrott to previous | to last
46 26-Nov-2021 10:22 38 KB kparrott to previous | to last
45 26-Nov-2021 10:22 38 KB kparrott to previous | to last
44 26-Nov-2021 10:22 43 KB eyeung to previous | to last
43 26-Nov-2021 10:22 46 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
42 26-Nov-2021 10:22 46 KB jmyers to previous | to last
41 26-Nov-2021 10:22 46 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 171 changed one line
|23-33|Uncollected Employee Tax on Tips\\ \\The combination of uncollected social security tax and the uncollected medicare tax|Derived from [IDFDV] Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’ (seq 4010)
|23-33|Uncollected Employee Tax on Tips|The combination of uncollected social security tax and the uncollected medicare tax\\ \\Derived from [IDFDV] Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’ (seq 4010)
At line 184 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 196 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 203 changed one line
|3-4|State Code, Appropriate FIPS Postal Numeric Code|Derived from the State being reported\\ \\e.g. Ohio is code "39"
|3-4|State Code|Appropriate FIPS Postal Numeric Code|Derived from the State being reported\\ \\e.g. Ohio is code "39"
At line 223 changed one line
|195-196|Optional code\\ \\Blank|
|195-196|Optional code|Blank
At line 236 changed one line
|274-275|State code, appropriate FIPS postal numeric code|Derived from the state being reported\\ \\e.g. Ohio is code "39"
|274-275|State code|Appropriate FIPS postal numeric code\\ \\Derived from the state being reported\\ \\e.g. Ohio is code "39"
At line 240 changed one line
|308|Tax Type Code\\ \\This field is used to report the School District tax\\ \\If the school district requires to report taxes along with the State Tax information, then the following values are used for this field:\\E – School District Income Tax\\ \\[IDGV] must be set up for the School Registration by school district for the following fields on the [Variables|IDGV#VariablesTab] tab:\\ \\*'W2 STATE MEDIA FILING'- Indicates that the school should report taxes with the state\\*'W2 TAX TYPE CODE' - Must contain the valid Tax Type Code ‘E’\\*'W2 TAXING ENTITY' - Contains the School District number|
|308|Tax Type Code|This field is used to report the School District tax\\ \\If the school district requires to report taxes along with the State Tax information, then the following values are used for this field:\\E – School District Income Tax\\ \\[IDGV] must be set up for the School Registration by school district for the following fields on the [Variables|IDGV#VariablesTab] tab:\\ \\*'W2 STATE MEDIA FILING'- Indicates that the school should report taxes with the state\\*'W2 TAX TYPE CODE' - Must contain the valid Tax Type Code ‘E’\\*'W2 TAXING ENTITY' - Contains the School District number|
At line 244 changed 2 lines
|338-412|Supplemental Data 1\\ \\Blank|
|413-487|Supplemental Data 2\\ \\Blank|
|338-412|Supplemental Data 1|Blank
|413-487|Supplemental Data 2|Blank
At line 253 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 285 changed one line
|3-9|Number of RO Records\\ \\Total number of code "RO" records reported since last code "RE" reocrd|
|3-9|Number of RO Records|Total number of code "RO" records reported since last code "RE" record
At line 296 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 311 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 328 changed one line
|3-4|State code, appropriate FIPS postal numeric code|Derived from the state being reported\\ \\ e.g. Ohio is code "39"
|3-4|State code|Appropriate FIPS postal numeric code\\ \\Derived from the state being reported\\ \\ e.g. Ohio is code "39"
At line 349 changed one line
|195-196|Optional code\\ \\Blank|
|195-196|Optional code|Blank
At line 362 changed 3 lines
|274-275|State code, appropriate FIPS postal numeric code|Derived from the State being reported\\ \\e.g. Ohio is code "39"
|276-286|State Taxable Wages\\ \\If State [IDGV] ‘W2 STATE MEDIA FILING’ = ‘03’, then State Taxable Wages is reported|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
|287-297|State Income Tax Withheld\\ \\If State IDGV ‘W2 STATE MEDIA FILING’ = ‘03’, then State Taxable Wages is reported|Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
|274-275|State code|Appropriate FIPS postal numeric code|Derived from the State being reported\\ \\e.g. Ohio is code "39"
|276-286|State Taxable Wages|If State [IDGV] ‘W2 STATE MEDIA FILING’ = ‘03’, then State Taxable Wages is reported\\ \\Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
|287-297|State Income Tax Withheld|If State IDGV ‘W2 STATE MEDIA FILING’ = ‘03’, then State Taxable Wages is reported\\ \\Derived from [IDFDV] Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
At line 371 changed 2 lines
|338-412|Supplemental Data 1\\ \\Blank|
|413-487|Supplemental Data 2\\ \\Blank|
|338-412|Supplemental Data 1|Blank
|413-487|Supplemental Data 2|Blank
At line 429 changed one line
|6-14| Transmitter's Employer ID number \\ \\Numeric only|Derived from the [IDGV] State SUI Registration
|6-14| Transmitter's Employer ID number|Numeric only\\ \\Derived from the [IDGV] State SUI Registration
At line 447 changed one line
|190-190|No Workers/No Wages\\ \\Enter ‘0’ to indicate that no ‘S’ records follow the ‘E’ record; otherwise enter ‘1’|
|190-190|No Workers/No Wages|Enter ‘0’ to indicate that no ‘S’ records follow the ‘E’ record; otherwise enter ‘1’
At line 462 changed one line
|92-105|State Qtr UI Taxable Wages\\ \\State Quarter UI Total Wages LESS State Quarter UI Excess Wages|
|92-105|State Qtr UI Taxable Wages|State Quarter UI Total Wages LESS State Quarter UI Excess Wages
At line 464 changed one line
|130-131|Number of Weeks Worked\\ \\The number of weeks worked in the reporting period|Derived from [IDFDV], US Quarterly File definition Field sequence 3080\\ \\This value is determined in one of three ways\\ \\(1)Be ‘plugged’ as a constant\\ \\(2)Be picked up from a Pay Component that is previously populated by a UserCalc\\ \\(3) Or if left as null, the P2K/eP system will compute the value
|130-131|Number of Weeks Worked|The number of weeks worked in the reporting period|Derived from [IDFDV], US Quarterly File definition Field sequence 3080\\ \\This value is determined in one of three ways\\ \\(1)Be ‘plugged’ as a constant\\ \\(2)Be picked up from a Pay Component that is previously populated by a UserCalc\\ \\(3) Or if left as null, the P2K/eP system will compute the value
At line 468 changed one line
|162-176|Unit/Division/Location/Plant Code\\ \\Presently P2K inserts all zeroes, if a client want otherwise, then this can be enhanced to pick up a ‘User Field’ attached to the location|
|162-176|Unit/Division/Location/Plant Code|Presently P2K inserts all zeroes, if a client want otherwise, then this can be enhanced to pick up a ‘User Field’ attached to the location
At line 470 changed 3 lines
|212-212|Month 1Employment\\ \\1’ if the employee received pay (TAXABLE WAGES) in the pay period that spans the 12th of the first month in the quarter|
|213-213|Month 2 Employment\\ \\’1’ if the employee received pay (TAXABLE WAGES) in the pay period that spans the 12th of the second month in the quarter|
|214-214|Month 3 Employment\\ \\1’ if the employee received pay (TAXABLE WAGES) in the pay period that spans the 12th of the third month in the quarter|
|212-212|Month 1Employment|1’ if the employee received pay (TAXABLE WAGES) in the pay period that spans the 12th of the first month in the quarter
|213-213|Month 2 Employment|’1’ if the employee received pay (TAXABLE WAGES) in the pay period that spans the 12th of the second month in the quarter
|214-214|Month 3 Employment|1’ if the employee received pay (TAXABLE WAGES) in the pay period that spans the 12th of the third month in the quarter
At line 489 changed 2 lines
|112-122|Interest|From the Identifier (INTEREST)\\ \\Decimal followed by 5 digits (i.e. 1.267%=00000.01267)
|123-133|Penalty|From the Identifier (PENALTY)\\ \\Decimal followed by 4 digits (i.e. 0.25%=000000.0025)
|112-122|Interest|From the Identifier (INTEREST)|Decimal followed by 5 digits (i.e. 1.267%=00000.01267)
|123-133|Penalty|From the Identifier (PENALTY)|Decimal followed by 4 digits (i.e. 0.25%=000000.0025)
At line 503 changed 2 lines
|2-11|Total Number of Employees in File\\ \\The total number of ‘S’ records in the entire file|
|12-21|Total Number of Employers in File\\ \\The total number of ‘E’ records in the entire file|
|2-11|Total Number of Employees in File|The total number of ‘S’ records in the entire file
|12-21|Total Number of Employers in File|The total number of ‘E’ records in the entire file
At line 506 changed 4 lines
|26-40|Quarterly Total Gross Wages in File\\ \\QTR gross wages subject to all taxes\\ \\Total of this field for all ‘S’ records in the file|
|41-55|Quarterly State Unemployment Insurance Total Wages in File\\ \\QTR wages subject to state UI tax\\ \\Total of this field for all ‘S’ records in the file|
|56-70|Quarterly State Unemployment Insurance Excess Wages in File\\ \\QTR wages in excess of the state UI taxable wage base\\ \\Total of this field for all ‘S’ records in the file|
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File\\ \\State UI gross/total wage less quarterly state UI excess wages\\ \\Total of this field for all ‘S’ records in the file|
|26-40|Quarterly Total Gross Wages in File|QTR gross wages subject to all taxes\\ \\Total of this field for all ‘S’ records in the file
|41-55|Quarterly State Unemployment Insurance Total Wages in File|QTR wages subject to state UI tax\\ \\Total of this field for all ‘S’ records in the file
|56-70|Quarterly State Unemployment Insurance Excess Wages in File|QTR wages in excess of the state UI taxable wage base\\ \\Total of this field for all ‘S’ records in the file
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File|State UI gross/total wage less quarterly state UI excess wages\\ \\Total of this field for all ‘S’ records in the file
At line 521 removed one line