This page (revision-96) 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
96 26-Nov-2021 10:22 66 KB Meg McFarland to previous
95 26-Nov-2021 10:22 66 KB Meg McFarland to previous | to last
94 26-Nov-2021 10:22 66 KB Meg McFarland to previous | to last
93 26-Nov-2021 10:22 65 KB mmcfarland to previous | to last
92 26-Nov-2021 10:22 81 KB mmcfarland to previous | to last
91 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
90 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
89 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
88 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
87 26-Nov-2021 10:22 105 KB mmcfarland to previous | to last
86 26-Nov-2021 10:22 105 KB mmcfarland to previous | to last
85 26-Nov-2021 10:22 105 KB eyeung to previous | to last
84 26-Nov-2021 10:22 105 KB eyeung to previous | to last
83 26-Nov-2021 10:22 102 KB eyeung to previous | to last
82 26-Nov-2021 10:22 100 KB eyeung to previous | to last
81 26-Nov-2021 10:22 100 KB eyeung to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - US General
Tax Reporting - US General

Version management

Difference between version and

At line 374 changed 13 lines
2000 W2-ER-EIN Employer Identification Number|Data Base Column|DGV.GOVT_REGIST_NUMBER
2010 W2-ER-NAME Employer Name|Data Base Column|DED.ENTITY_NAME
2020 W2-ER-LOCN-ADDR Employer Location Address|Data Base Column|Enter employer’s location address (i.e. Attention, Suite, Room Num etc. use DLN.ADDRESS_LINE_1 or DLN.ADDRESS_LINE_2)
2030 W2-ER-DELIV-ADDR Employer Delivery Address|Data Base Column|Enter employer’s delivery address (i.e. Street or Post Office Box, use DLN.ADDRESS_LINE_1 or DLN.ADDRESS_LINE_2)
2040 W2-ER-CITY Employer City|Data Base Column|Enter employer’s city DLN. LOCALITY
2050 W2-ER-STATE Employer State Abbrev|Data Base Column|Enter employer’s State abbreviation
2060 W2-ER-ZIP Employer ZIP Code|Data Base Column|Enter employer’s ZIP Code DLN.ZIP_POSTAL
2070 W2-ER-ZIP-EXT Employer ZIP Extension|Data Base Column|Enter employer’s ZIP Code DLN.ZIP_POSTAL, use derivation expression substr(~,6) for ZIP extension
2080 W2-ER-F-STATE Employer foreign State/province|Data Base Column or Constant|Enter Employer foreign state
2090 W2-ER-F-POSTAL Employer foreign postal code|Data Base Column or Constant|Enter Employer foreign state
2100 W2-ER-COUNTRY Employer country if applicable|Constant|Enter Employer country if applicable
2110 W2-ER-TAX-JURIS Tax Jurisdiction Code|Constant|Enter Employer country if applicable
2120 W2-KIND-OF-EMPLOYER Kind of Employer|Constant|
|2000|W2-ER-EIN|Employer Identification Number|Data Base Column|DGV.GOVT_REGIST_NUMBER
|2010|W2-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|2020|W2-ER-LOCN-ADDR|Employer Location Address|Data Base Column|Enter employer’s location address (i.e. Attention, Suite, Room Num etc. use DLN.ADDRESS_LINE_1 or DLN.ADDRESS_LINE_2)
|2030|W2-ER-DELIV-ADDR|Employer Delivery Address|Data Base Column|Enter employer’s delivery address (i.e. Street or Post Office Box, use DLN.ADDRESS_LINE_1 or DLN.ADDRESS_LINE_2)
|2040|W2-ER-CITY|Employer City|Data Base Column|Enter employer’s city DLN. LOCALITY
|2050|W2-ER-STATE|Employer State Abbrev|Data Base Column|Enter employer’s State abbreviation
|2060|W2-ER-ZIP|Employer ZIP Code|Data Base Column|Enter employer’s ZIP Code DLN.ZIP_POSTAL
|2070|W2-ER-ZIP-EXT|Employer ZIP Extension|Data Base Column|Enter employer’s ZIP Code DLN.ZIP_POSTAL, use derivation expression substr(~,6) for ZIP extension
|2080|W2-ER-F-STATE|Employer foreign State/province|Data Base Column or Constant|Enter Employer foreign state
|2090|W2-ER-F-POSTAL|Employer foreign postal code|Data Base Column or Constant|Enter Employer foreign state
|2100|W2-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country if applicable
|2110|W2-ER-TAX-JURIS|Tax Jurisdiction Code|Constant|Enter Employer country if applicable
|2120|W2-KIND-OF-EMPLOYER|Kind of Employer|Constant|
At line 388 changed 17 lines
2500 W2-EE-SSN Employee Social Security Number|Data Base Column|EID.GOVERNMENT_CODE
2510 W2-EE-FIRST-NAME Employee First Name|Data Base Column|EID.FIRST_NAME
2520 W2-EE-MIDDLE Employee Middle Name|Data Base Column|EID.MIDDLE_NAME
2530 W2-EE-LAST-NAME Employee Last Name|Data Base Column|EID.LAST_NAME
2540 W2-EE-SUFFIX Employee Suffix Name|Data Base Column|EID.RANK with derivation expression Decode(~,’01’,’JR’,’02’,’SR’,NULL)
2600 W2-EE-LOCN-ADDR Employee Location Address|Data Base Column|Enter employee’s location address (i.e. Attention, Suite, Room Num etc., use EPS.ADDRESS_LINE_1 or EPS.ADDRESS_LINE_2)
2610 W2-EE-DELIV-ADDR Employee Delivery Address|Data Base Column|Enter employee’s delivery address (i.e. Street or Post Office Box, use EPS.ADDRESS_LINE_1 or EPS.ADDRESS_LINE_2)
2620 W2-EE-CITY Employee City|Data Base Column|Enter employee’s city EPS.LOCALITY
2630 W2-EE-STATE Employee State Abbrev|Data Base Column|Enter employee’s State abbreviation DSP.STATE_PROVINCE_CODE
2640 W2-EE-ZIP Employee ZIP Code|Data Base Column|Enter employee’s ZIP Code EPS.ZIP_POSTAL
2650 W2-EE-ZIP-EXT Employee ZIP Extension|Data Base Column|Enter employee’s ZIP Code EPS.ZIP_POSTAL-use derivation expression substr(~,6) for ZIP extension
2660 W2-EE-F-STATE Employee foreign State/province|Data Base Column or Constant|Enter Employee foreign state
2670 W2-EE-F-POSTAL Employee foreign postal code|Data Base Column or Constant|Enter Employee foreign postal code
2680 W2-EE-COUNTRY Employee country if applicable|Constant|Enter Employee country if applicable
2800 W2-CONTROL-PRT Print Control Number on Form|Constant|
2810 W2-CONTROL-NUM Control Number on Form|Data Base Column|Person Code
2900 W2-EXCLUDE-EE Exclude Employee|Data Base Column|Enter your company data
|2500|W2-EE-SSN|Employee Social Security Number|Data Base Column|EID.GOVERNMENT_CODE
|2510|W2-EE-FIRST-NAME|Employee First Name|Data Base Column|EID.FIRST_NAME
|2520|W2-EE-MIDDLE|Employee Middle Name|Data Base Column|EID.MIDDLE_NAME
|2530|W2-EE-LAST-NAME|Employee Last Name|Data Base Column|EID.LAST_NAME
|2540|W2-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|2600|W2-EE-LOCN-ADDR|Employee Location Address|Data Base Column|Enter employee’s location address (i.e. Attention, Suite, Room Num etc., use EPS.ADDRESS_LINE_1 or EPS.ADDRESS_LINE_2)
|2610|W2-EE-DELIV-ADDR|Employee Delivery Address|Data Base Column|Enter employee’s delivery address (i.e. Street or Post Office Box, use EPS.ADDRESS_LINE_1 or EPS.ADDRESS_LINE_2)
|2620|W2-EE-CITY|Employee City|Data Base Column|Enter employee’s city EPS.LOCALITY
|2630|W2-EE-STATE|Employee State Abbrev|Data Base Column|Enter employee’s State abbreviation DSP.STATE_PROVINCE_CODE
|2640|W2-EE-ZIP|Employee ZIP Code|Data Base Column|Enter employee’s ZIP Code EPS.ZIP_POSTAL
|2650|W2-EE-ZIP-EXT|Employee ZIP Extension|Data Base Column|Enter employee’s ZIP Code EPS.ZIP_POSTAL-use derivation expression substr(~,6) for ZIP extension
|2660|W2-EE-F-STATE|Employee foreign State/province|Data Base Column or Constant|Enter Employee foreign state
|2670|W2-EE-F-POSTAL|Employee foreign postal code|Data Base Column or Constant|Enter Employee foreign postal code
|2680|W2-EE-COUNTRY|Employee country if applicable|Constant|Enter Employee country if applicable
|2800|W2-CONTROL-PRT|Print Control Number on Form|Constant|
|2810|W2-CONTROL-NUM|Control Number on Form|Data Base Column|Person Code
|2900|W2-EXCLUDE-EE|Exclude Employee|Data Base Column|Enter your company data
At line 406 changed 13 lines
3000 W2-FIT-WAGE Wages, Tips, Other Compensation Element W2-BOX-01
3010 W2-FIT-TAX Federal Income Tax Withheld Element W2-BOX-02
3020 W2-SSN-WAGE Social Security Wages Element W2-BOX-03,- use derivation expression LEAST(~,80400.00) for year 2001 max
3030 W2-SSN-TAX Social Security Tax Withheld Element W2-BOX-04,- use derivation expression LEAST(~,4984.80) for year 2001 max
3040 W2-MEDI-WAGE Medicare Wages and Tips Element W2-BOX-05
3050 W2-MEDI-TAX Medicare Tax Withheld Element W2-BOX-06
3060 W2-SSN-TIP Social Security Tips Element W2-BOX-07
3070 W2-ALLOC-TIP Allocated Tips Element W2-BOX-08
3080 W2-EIC Advanced EIC Credit Element W2-BOX-09
3090 W2-DEP-CARE Dependent Care Benefit Element W2-BOX-10
3100 W2-NQUAL Non Qualified Plans Element W2-BOX-11
3102 W2-NQUAL-457 Non Qualified Plans Sect 457 Element W2-BOX-11-457
3104 W2-NQUAL-N457 Non Qualified Plans Not Sect 457 Element W2-BOX-11-N457
|3000|W2-FIT-WAGE|Wages, Tips, Other Compensation|Element|W2-BOX-01
|3010|W2-FIT-TAX|Federal Income Tax Withheld|Element|W2-BOX-02
|3020|W2-SSN-WAGE|Social Security Wages|Element|W2-BOX-03,- use derivation expression LEAST(~,80400.00) for year 2001 max
|3030|W2-SSN-TAX|Social Security Tax Withheld|Element|W2-BOX-04,- use derivation expression LEAST(~,4984.80) for year 2001 max
|3040|W2-MEDI-WAGE|Medicare Wages and Tips|Element|W2-BOX-05
|3050|W2-MEDI-TAX|Medicare Tax Withheld|Element|W2-BOX-06
|3060|W2-SSN-TIP|Social Security Tips|Element|W2-BOX-07
|3070|W2-ALLOC-TIP|Allocated Tips|Element|W2-BOX-08
|3080|W2-EIC|Advanced EIC Credit|Element|W2-BOX-09
|3090|W2-DEP-CARE|Dependent Care Benefit|Element|W2-BOX-10
|3100|W2-NQUAL|Non Qualified Plans|Element|W2-BOX-11
|3102|W2-NQUAL-457|Non Qualified Plans Sect 457|Element|W2-BOX-11-457
|3104|W2-NQUAL-N457|Non Qualified Plans Not Sect 457|Element|W2-BOX-11-N457
At line 420 changed 27 lines
4000 W2-CODE-A Un-collect SSA/RRTA tax on tips Pay Component Enter your company data
4010 W2-CODE-B Un-collect Medicare tax on tips Pay Component Enter your company data
4020 W2-CODE-C Group Term Life Ins > 50000 Pay Component Enter your company data
4030 W2-CODE-D Deferred 401(k) cash Pay Component Enter your company data
4040 W2-CODE-E Deferred 401(b) Salary reduction Pay Component Enter your company data
4050 W2-CODE-F Deferred 408(k)(6) Salary reduction Pay Component Enter your company data
4060 W2-CODE-G Deferred 457(b) compensation Pay Component Enter your company data
4070 W2-CODE-H Deferred 501(c)18(D) tax exempt Pay Component Enter your company data
4080 W2-CODE-J Non taxable sick pay Pay Component Enter your company data
4090 W2-CODE-K 20% excise parachute payment Pay Component Enter your company data
4100 W2-CODE-L EE business expense reimbursement Pay Component Enter your company data
4110 W2-CODE-M Un-collect SSA/RRTA group ins Pay Component Enter your company data
4120 W2-CODE-N Un-collect Medicare group insurance Pay Component Enter your company data
4130 W2-CODE-P Moving expense Pay Component Enter your company data
4140 W2-CODE-Q Military compensation Pay Component Enter your company data
4150 W2-CODE-R Employer Contribution to MSA Pay Component Enter your company data
4160 W2-CODE-S Salary reduction to 408(p) Pay Component Enter your company data
4170 W2-CODE-T Adoption benefits Pay Component Enter your company data
4180 W2-CODE-V Income of nonstat stock option Pay Component Enter your company data
4190 W2-CODE-W ER cont. to Health Savings Acct Pay Component Enter your company data
4200 W2-CODE-Y Deferrals 409A Non-qualify plan Pay Component Enter your company data
4210 W2-CODE-Z Income 409A Non-qualify plan Pay Component Enter your company data
4220 W2-CODE-AA Roth Contribution 401(k) Pay Component Enter your company data
4230 W2-CODE-BB Roth Contribution 403(b) Pay Component Enter your company data
4240 W2-CODE-CC HIRE Act Wages Pay Component Enter your company data
4250 W2-CODE-DD ER sponsored Health Coverage Pay Component Enter your company data
4260 W2-CODE-EE Roth Contribution 457(b) Pay Component Enter your company data
|4000|W2-CODE-A|Un-collect SSA/RRTA tax on tips|Pay Component|Enter your company data
|4010|W2-CODE-B|Un-collect Medicare tax on tips|Pay Component|Enter your company data
|4020|W2-CODE-C|Group Term Life Ins > 50000|Pay Component|Enter your company data
|4030|W2-CODE-D|Deferred 401(k) cash|Pay Component|Enter your company data
|4040|W2-CODE-E|Deferred 401(b) Salary reduction|Pay Component|Enter your company data
|4050|W2-CODE-F|Deferred 408(k)(6) Salary reduction|Pay Component|Enter your company data
|4060|W2-CODE-G|Deferred 457(b) compensation|Pay Component|Enter your company data
|4070|W2-CODE-H|Deferred 501(c)18(D) tax exempt|Pay Component|Enter your company data
|4080|W2-CODE-J|Non taxable sick pay|Pay Component|Pay Component|Pay Component|Enter your company data
|4090|W2-CODE-K|20% excise parachute payment|Pay Component|Enter your company data
|4100|W2-CODE-L|EE business expense reimbursement|Pay Component|Enter your company data
|4110|W2-CODE-M|Un-collect SSA/RRTA group ins|Pay Component|Enter your company data
|4120|W2-CODE-N|Un-collect Medicare group insurance|Pay Component|Enter your company data
|4130|W2-CODE-P|Moving expense|Pay Component|Enter your company data
|4140|W2-CODE-Q|Military compensation|Pay Component|Enter your company data
|4150|W2-CODE-R|Employer Contribution to MSA|Pay Component|Enter your company data
|4160|W2-CODE-S|Salary reduction to 408(p)|Pay Component|Enter your company data
|4170|W2-CODE-T|Adoption benefits|Pay Component|Enter your company data
|4180|W2-CODE-V|Income of nonstat stock option|Pay Component|Enter your company data
|4190|W2-CODE-W|ER cont. to Health Savings Acct|Pay Component|Enter your company data
|4200|W2-CODE-Y|Deferrals 409A Non-qualify plan|Pay Component|Enter your company data
|4210|W2-CODE-Z|Income 409A Non-qualify plan|Pay Component|Enter your company data
|4220|W2-CODE-AA|Roth Contribution 401(k)|Pay Component|Enter your company data
|4230|W2-CODE-BB|Roth Contribution 403(b)|Pay Component|Enter your company data
|4240|W2-CODE-CC|HIRE Act Wages|Pay Component|Enter your company data
|4250|W2-CODE-DD|ER sponsored Health Coverage|Pay Component|Enter your company data
|4260|W2-CODE-EE|Roth Contribution 457(b)|Pay Component|Enter your company data
At line 448 changed 3 lines
5000 W2-OTHER-01 Your company description Pay Component Enter your company data
5nnn W2-OTHER-02/19 Your company description Pay Component Enter your company data
5190 W2-OTHER-20 Your company description Pay Component Enter your company data
5000 W2-OTHER-01 Your company description|Pay Component|Enter your company data
5nnn W2-OTHER-02/19 Your company description|Pay Component|Enter your company data
5190 W2-OTHER-20 Your company description|Pay Component|Enter your company data
At line 452 changed 3 lines
5500 W2-USER-01 User Amount Pay Component Enter your company data
5xxx W2-USER-02/19 User Amount Pay Component Enter your company data
5690 W2-USER-20 User Amount Pay Component Enter your company data
5500 W2-USER-01 User Amount|Pay Component|Enter your company data
5xxx W2-USER-02/19 User Amount|Pay Component|Enter your company data
5690 W2-USER-20 User Amount|Pay Component|Enter your company data
At line 456 changed 3 lines
5700 W2-HL-01 HL Reserved Amount Pay Component Enter your company data
57yy W2-HL-02/19 HL Reserved Amount Pay Component Enter your company data
5790 W2-HL-20 HL Reserved Amount Pay Component Enter your company data
5700 W2-HL-01 HL Reserved Amount|Pay Component|Enter your company data
57yy W2-HL-02/19 HL Reserved Amount|Pay Component|Enter your company data
5790 W2-HL-20 HL Reserved Amount|Pay Component|Enter your company data
At line 460 changed 3 lines
6000 W2-STAT-EE Statutory employee Statistics Enter your company data
6020 W2-RETIRE-PLAN Retirement plan employee Statistics Enter your company data
6060 W2-3PARTY-SICK Third-party sick pay Statistics Enter your company data
6000 W2-STAT-EE Statutory employee|Statistics|Enter your company data
6020 W2-RETIRE-PLAN Retirement plan employee|Statistics|Enter your company data
6060 W2-3PARTY-SICK Third-party sick pay|Statistics|Enter your company data
At line 469 changed 4 lines
7020 W2-STATE-WAGE-HO State Wages and Tips (Home State) Element W2-STATE-WAGE-H
7030 W2-STATE-WAGE-WO State Wages and Tips (Work State) Element W2-STATE-WAGE-W
7040 W2-STATE-TAX-HOM State Income Tax (Home State) Element W2-STATE-TAX-H
7050 W2-STATE-TAX-WOR State Income Tax (Work State) Element W2-STATE-TAX-W
7020 W2-STATE-WAGE-HO State Wages and Tips (Home State)|Element|W2-STATE-WAGE-H
7030 W2-STATE-WAGE-WO State Wages and Tips (Work State)|Element|W2-STATE-WAGE-W
7040 W2-STATE-TAX-HOM State Income Tax (Home State)|Element|W2-STATE-TAX-H
7050 W2-STATE-TAX-WOR State Income Tax (Work State)|Element|W2-STATE-TAX-W
At line 474 changed 12 lines
7200 W2-SUI-WAGE-EE State SUI Wages (Employee) Element W2-SUI-WAGE-EE
7210 W2-SUI-WAGE-ER State SUI Wages (Employer) Element W2-SUI-WAGE-ER
7220 W2-SUI-TAX-EE SUI Tax (Employee contribution) Element W2-SUI-TAX-EE
7230 W2-SUI-TAX-ER State SUI Tax (Employer contribution) Element W2-SUI-TAX-ER
7240 W2-SDI-WAGE-EE State SDI Wages (Employee) Element W2-SDI-WAGE-EE
7250 W2-SDI-WAGE-ER State SDI Wages (Employer) Element W2-SDI-WAGE-ER
7260 W2-SDI-TAX-EE State SDI Tax (Employee contribution) Element W2-SDI-TAX-EE
7270 W2-SDI-TAX-ER State SDI Tax (Employer contribution) Element W2-SDI-TAX-ER
7280 W2-SUI-HRS-WRK Regular Hours Element
7500 W2-TIP-WAGE-WORK Work State Tip Wages Element
7510 W2-ST-TIP-WORK Work State Tips Element
7600 W2-WC-WORK Workers Compensation Contribution Element
7200 W2-SUI-WAGE-EE State SUI Wages (Employee)|Element|W2-SUI-WAGE-EE
7210 W2-SUI-WAGE-ER State SUI Wages (Employer)|Element|W2-SUI-WAGE-ER
7220 W2-SUI-TAX-EE SUI Tax (Employee contribution)|Element|W2-SUI-TAX-EE
7230 W2-SUI-TAX-ER State SUI Tax (Employer contribution)|Element|W2-SUI-TAX-ER
7240 W2-SDI-WAGE-EE State SDI Wages (Employee)|Element|W2-SDI-WAGE-EE
7250 W2-SDI-WAGE-ER State SDI Wages (Employer)|Element|W2-SDI-WAGE-ER
7260 W2-SDI-TAX-EE State SDI Tax (Employee contribution)|Element|W2-SDI-TAX-EE
7270 W2-SDI-TAX-ER State SDI Tax (Employer contribution)|Element|W2-SDI-TAX-ER
7280 W2-SUI-HRS-WRK Regular Hours|Element|
7500 W2-TIP-WAGE-WORK Work State Tip Wages|Element|
7510 W2-ST-TIP-WORK Work State Tips|Element|
7600 W2-WC-WORK Workers Compensation Contribution|Element|
At line 488 changed 4 lines
8010 W2-CN-WAGE-HOME County Wages (Home County) Element W2-CNTY-WAGE-H
8020 W2-CN-WAGE-WORK County Wages (Work County) Element W2-CNTY-WAGE-W
8030 W2-CN-TAX-HOME County Tax (Home County) Element Element W2-CNTY-TAX-H
8040 W2-CN-TAX-WORK County Tax (Work County) Element Element W2-CNTY-TAX-W
8010 W2-CN-WAGE-HOME County Wages (Home County)|Element|W2-CNTY-WAGE-H
8020 W2-CN-WAGE-WORK County Wages (Work County)|Element|W2-CNTY-WAGE-W
8030 W2-CN-TAX-HOME County Tax (Home County) Element|Element|W2-CNTY-TAX-H
8040 W2-CN-TAX-WORK County Tax (Work County) Element|Element|W2-CNTY-TAX-W
At line 494 changed 4 lines
8510 W2-CI-WAGE-HOME City Wages (Home City) Element W2-CITY-WAGE-H
8520 W2-CI-WAGE-WORK City Wages (Work City) Element W2-CITY-WAGE-W
8530 W2-CI-TAX-HOME City Tax (Home City) Element W2-CITY-TAX-H
8540 W2-CI-TAX-WORK City Tax (Work City) Element W2-CITY-TAX-W
8510 W2-CI-WAGE-HOME City Wages (Home City)|Element|W2-CITY-WAGE-H
8520 W2-CI-WAGE-WORK City Wages (Work City)|Element|W2-CITY-WAGE-W
8530 W2-CI-TAX-HOME City Tax (Home City)|Element|W2-CITY-TAX-H
8540 W2-CI-TAX-WORK City Tax (Work City)|Element|W2-CITY-TAX-W
This page (revision-96) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop