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

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 63 removed one line
At line 208 added 26 lines
|1-2|Record Identifier|Constant "RT"
|3-9|Number of RW Records\\ \\Total number of code "RW" records reported since last code "RE" record|
|10-24|Wages, Tips and Other Compensation|Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
|25-39|Federal Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
|40-54|Social Security Wages|Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
|55-69|Social Security Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
|70-84|Medicare Wages and Tips|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
|85-99|Medicare Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
|100-114|Social Security Tips|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
|115-129|Advanced Earned Income Credit|Derived from [IDFDV] Field Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
|130-144|Dependent Care Benefits|Derived from [IDFDV] Field Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
|145-159|Deferred Compensation Contributions to Section 401(k)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-D’, total of all code "RW" records since last "RE" record
|160-174|Deferred Compensation Contributions to Section 403(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-E’, total of all code "RW" records since last "RE" record
|175-189|Deferred Compensation Contributions to Section 408(k)(6)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-F’, total of all code "RW" records since last "RE" record
|190-204|Deferred Compensation Contributions to Section 457(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-G’, total of all code "RW" records since last "RE" record
|205-219|Deferred Compensation Contributions to Section 501(c)(18)(D)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
|220-234|Military Employee’s Basic Quarters and Combat Pay|Derived from [IDFDV] Field Identifier: ‘W2-CODE-Q’, total of all code ‘RW’ records since last ‘RE’ record
|235-249|Non-Qualified Plan Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
|250-264|Employer Contribution to a Health Savings Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-W’, total of all code ‘RW’ records since last ‘RE’ record
|265-279|Non-Qualified Plan Not Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
|280-294|Blank|
|295-309|Cost of Employer-Sponsored Health Coverage|Derived from [IDFDV] Field Identifier: ‘W2-CODE-DD’, total of all code "RW" records since last "RE" record
|310-324|Employer Cost of Premiums for Group Term Life Insurance over $50000|Derived from [IDFDV] Field Identifier: ‘W2-CODE-C’, total of all code "RW" records since last "RE" record
|325-339|Income Tax Withheld by Third-Party Payer|Derived from [IDFDV] Field Identifier: ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
|340-354|Income from Non-statutory Stock options|Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
|355-512|Blank|
At line 210 removed 54 lines
1-2 - Record Identifier
- Constant "RT"
3-9 - Number of RW Records
- Total number of code "RW" records reported since last code "RE" record
10-24 - Wages, Tips and Other Compensation|Derived from [IDFDV] Field Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
25-39 - Federal Income Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
40-54 - Social Security Wages|Derived from [IDFDV] Field Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
55-69 - Social Security Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
70-84 - Medicare Wages and Tips|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
85-99 - Medicare Tax Withheld|Derived from [IDFDV] Field Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
100-114 - Social Security Tips|Derived from [IDFDV] Field Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
115-129 - Advanced Earned Income Credit|Derived from [IDFDV] Field Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
130-144 - Dependent Care Benefits|Derived from [IDFDV] Field Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
145-159 - Deferred Compensation Contributions to Section 401(k)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-D’, total of all code "RW" records since last "RE" record
160-174 - Deferred Compensation Contributions to Section 403(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-E’, total of all code "RW" records since last "RE" record
175-189 - Deferred Compensation Contributions to Section 408(k)(6)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-F’, total of all code "RW" records since last "RE" record
190-204 - Deferred Compensation Contributions to Section 457(b)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-G’, total of all code "RW" records since last "RE" record
205-219 - Deferred Compensation Contributions to Section 501(c)(18)(D)|Derived from [IDFDV] Field Identifier: ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
220-234 - Military Employee’s Basic Quarters and Combat Pay|Derived from [IDFDV] Field Identifier: ‘W2-CODE-Q’, total of all code ‘RW’ records since last ‘RE’ record
235-249 - Non-Qualified Plan Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
250-264 - Employer Contribution to a Health Savings Account|Derived from [IDFDV] Field Identifier: ‘W2-CODE-W’, total fo all code ‘RW’ records since last ‘RE’ record
265-279 - Non-Qualified Plan Not Section 457|Derived from [IDFDV] Field Identifier: ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
280-294|Blank|
295-309 - Cost of Employer-Sponsored Health Coverage|Derived from [IDFDV] Field Identifier: ‘W2-CODE-DD’, total of all code "RW" records since last "RE" record
310-324 - Employer Cost of Premiums for Group Term Life Insurance over $50000|Derived from [IDFDV] Field Identifier: ‘W2-CODE-C’, total of all code "RW" records since last "RE" record
325-339 - Income Tax Withheld by Third-Party Payer|Derived from [IDFDV] Field Identifier: ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
340-354 - Income from Non-statutory Stock options|Derived from [IDFDV] Field Identifier: ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
355-512|Blank|
At line 237 added 4 lines
|1-2|Record Identifier|Constant "RF"
|3-7|Blank|
|8-16|Number of RW Records\\ \\Total number of code "RW" records on file|
|17-512|Blank|
At line 267 removed 10 lines
1-2 - Record Identifier
- Constant "RF"
3-7|Blank|
8-16 - Number of RW Records
- Total number of code "RW" records on file
17-512|Blank|
At line 258 added 18 lines
|1-2|Record Identifier|Constant ‘RA’
|3-13|Submitter’s Employer ID number (EIN)\\ \\Numeric only|Derived from [IDFDV] Field Identifier: ‘SUB-ER-EIN’
|14-216|Blank|
|217-273|Submitter Name|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-NAME’
|274-295|Submitter Location Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-LOCN’
|296-317|Submitter Delivery Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-DELIV’
|318-339|Submitter City|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-CITY’
|340-341|Submitter State Abbreviation|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-STATE’
|342-346|Submitter ZIP Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP’
|347-350|Submitter ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP-EXT’
|351-395|Blank|
|396-422|Contact Name|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-NAME’
|423-437|Contact Phone Number|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL’
|438-442|Contact Phone Extension|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL-EXT’
|443-445|Blank|
|446-485|Contact E-mail|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-EMAIL’
|486-488|Blank|
|489-512|Contact FAX|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-FAX’
At line 294 removed 38 lines
1-2 - Record Identifier
- Constant ‘RA’
3-13 - Submitter’s Employer ID number (EIN)
- Numeric only|Derived from [IDFDV] Field Identifier: ‘SUB-ER-EIN’
14-216|Blank|
217-273 - Submitter Name|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-NAME’
274-295 - Submitter Location Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-LOCN’
296-317 - Submitter Delivery Address|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-DELIV’
318-339 - Submitter City|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-CITY’
340-341 - Submitter State Abbreviation|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-STATE’
342-346 - Submitter ZIP Code|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP’
347-350 - Submitter ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘SUB-SUBM-ZIP-EXT’
351-395|Blank|
396-422 - Contact Name|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-NAME’
423-437 - Contact Phone Number|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL’
438-442 - Contact Phone Extension|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-TEL-EXT’
443-445|Blank|
446-485 - Contact E-mail|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-EMAIL’
486-488|Blank|
489-512 - Contact FAX|Derived from [IDFDV] Field Identifier: ‘SUB-CONT-FAX’
At line 279 added 11 lines
|1-2|Record Identifier|Constant ‘RE’
|3-7|Blank|
|8-18|Employer/Agent EIN|System derived the applicable Federal reporting EIN, from [IDGV] or [IDGR]
|19-39|Blank|
|40-118|Employer Name|Derived from [IDFDV] Field Identifier: ‘W2-ER-NAME’
|119-140|Employer Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-ER-DELIV-ADDR’
|141-162|Employer City|Derived from [IDFDV] Field Identifier: ‘W2-ER-CITY’
|163-164|Employer State FIPS Postal Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-ER-STATE’
|165-169|Employer ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP’
|170-173|Employer ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP-EXT’
|174-178|Quarter and Year Being Reported\\ \\Format should be QYYYY with Q values of 1,2,3, or 4. and YYYY values being the tax year
At line 335 removed 25 lines
1-2 - Record Identifier
- Constant ‘RE’
3-7|Blank|
8-18 -Employer/Agent EIN
- System derived the applicable Federal reporting EIN, from IDGV or IDGR
19-39|Blank|
40-118 - Employer Name|Derived from [IDFDV] Field Identifier: ‘W2-ER-NAME’
119-140 - Employer Delivery Address|Derived from [IDFDV] Field Identifier: ‘W2-ER-DELIV-ADDR’
141-162 - Employer City|Derived from [IDFDV] Field Identifier: ‘W2-ER-CITY’
163-164 - Employer State FIPS postal Abbreviation|Derived from [IDFDV] Field Identifier: ‘W2-ER-STATE’
165-169 - Employer ZIP Code|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP’
170-173 - Employer ZIP Code Extension|Derived from [IDFDV] Field Identifier: ‘W2-ER-ZIP-EXT’
174-178 - Quarter and Year being reported
- Format should be QYYYY with Q values of 1,2,3, or 4. and YYYY values being the tax year.
At line 294 added 16 lines
|1-2|Record Identifier|Constant "RS"
|3-4|State Code\\ \\Appropriate FIPS postal numeric code|Derived from the State being reported, from [IDFDV] sequence 7000\\ \\e.g. New York numeric code is "36"
|5-9|Blank|
|10-18|Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’\\ \\If an invalid SSN is encountered, this field is entered with zeroes
|19-33|Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’
|34-48|Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’
|49-68|Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’
|69-72|Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’
|73-202 NY|Blank|
|203-213|State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’\\ \\Note that the [IDFDV] Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in [UPCALC] and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. [RPYEU] would be using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages.
|214-242|Blank|
|243-243 NY|Wage Type\\ \\Wages type identifier\\ \\‘W’ for regular wages, and ‘O’ for other wages|Derived from [IDGV] setup (‘Variables’ tab).
|244-275|Blank|
|276-286|Gross Wages subject to withholding\\ \\Enter zeros for Quarter 1, Quarter 2, and Quarter 3\\ \\Enter Annual Amount for Quarter 4 only|Derived from [IDFDV], Annual Amount, Field Identifier: ‘W2-ST-WAGE-HOME’ (seq 7020) plus ‘W2_ST_WAGE_WORK’ (sequence 7030)
|287-297|Total Tax Withheld\\ \\NYS, NYC, and Yonkers income tax withheld (lump sum)\\ \\Enter zeros for Quarter 1, Quarter 2, and Quarter 3\\ \\Enter Annual Amount for Quarter 4 only|Derived from [IDFDV], Annual Amount, Field Identifier: ‘W2-ST-TAX-HOME’ (seq 7040) plus ‘W2_ST_TAX_WORK’ (sequence 7050)
|298-512 NY|Blank|
At line 364 changed 2 lines
1-2 - Record Identifier
- Constant "RS"
;Multiple Code RS records:Multiple code RS records are generated for an employee if there are applicable county, city or school district tax information to be reported for a state. In this case, the state wages and tax will be zero for the subsequent code RS records.
At line 367 removed 44 lines
3-4 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported, from IDFDV sequence 7000.
- e.g. New York numeric code is "36"
5-9|Blank|
10-18 - Social Security Number|Derived from [IDFDV] Field Identifier: ‘W2-EE-SSN’
- if an invalid SSN is encountered, this field is entered with zeroes.
19-33 - Employee First Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-FIRST-NAME’
34-48 - Employee Middle Name or Initial|Derived from [IDFDV] Field Identifier: ‘W2-EE-MIDDLE’
49-68 - Employee Last Name|Derived from [IDFDV] Field Identifier: ‘W2-EE-LAST-NAME’
69-72 - Employee Suffix|Derived from [IDFDV] Field Identifier: ‘W2-EE-SUFFIX’
73-202 NY|Blank|
203-213 - State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
- note that the IDFDV Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in UPCALC and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages, therefore RPYEU is using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages
214-242|Blank|
243-243 NY - Wage Type
- Wages type Identifier. ‘W’ for regular wages, and ‘O’ for other wages.
- Derived from IDGV setup (‘Variables’ tab).
244-275|Blank|
276-286 - Gross Wages subject to withholding
- Enter zeros for Quarter 1, Quarter 2, and Quarter 3. Enter Annual Amount for Quarter 4 only.
- Derived from IDFDV screen, Annual Amount, Field Identifier: ‘W2-ST-WAGE-HOME’ (seq 7020) plus ‘W2_ST_WAGE_WORK’ (sequence 7030)
287-297 - Total tax withheld
- NYS, NYC, and Yonkers income tax withheld (lump sum).
- Enter zeros for Quarter 1, Quarter 2, and Quarter 3. Enter Annual Amount for Quarter 4 only.
- Derived from IDFDV screen, Annual Amount, Field Identifier: ‘W2-ST-TAX-HOME’ (seq 7040) plus ‘W2_ST_TAX_WORK’ (sequence 7050)
298-512 NY|Blank|
;Multiple Code RS records:Multiple code RS records are generated for an employee if there are applicable county, city or school district tax information to be reported for a State. In this case, the State wages and tax will be zero for the subsequent code RS records.
At line 413 changed 2 lines
1-2 - Record Identifier
- Constant ‘RU’
|1-2|Record Identifier|Constant ‘RU’
|3-9|Number of RS Records\\ \\Total number of code "RS" records reported for this employer|
|10-512|Blank|
At line 416 removed 5 lines
3-9 - Number of RS Records
- Total number of code "RS" records reported for this employer
10-512|Blank|