This page (revision-30) 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
30 26-Nov-2021 10:22 14 KB Meg McFarland to previous
29 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
28 26-Nov-2021 10:22 9 KB mmcfarland to previous | to last
27 26-Nov-2021 10:22 9 KB mmcfarland to previous | to last
26 26-Nov-2021 10:22 9 KB mmcfarland to previous | to last
25 26-Nov-2021 10:22 9 KB mmcfarland to previous | to last
24 26-Nov-2021 10:22 9 KB mmcfarland to previous | to last
23 26-Nov-2021 10:22 9 KB kparrott to previous | to last
22 26-Nov-2021 10:22 9 KB kparrott to previous | to last
21 26-Nov-2021 10:22 10 KB eyeung to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 23 changed one line
!!Annual W2 Magentic Media Wage Reporting - EFW2 Format
!Annual W2 Magentic Media Wage Reporting - EFW2 Format
At line 38 changed 2 lines
!Annual W2 Electronic File Specifications
__Note:__ Columns coded with AL indicates it is a Alabama specific requirement which is not the standard record format
!!Annual W2 Electronic File Specifications
%%information 1. __The only required Record Code for W2 filing is RS__ \\2. Columns coded with AL indicates it is a Alabama specific requirement which is not the standard record format%%
At line 64 changed 2 lines
!RPYEU
[RPYEU] must be run with the following report parameters and filters selected to generate the Alabama State file information: \\
[RPYEU] must be run with the following report parameters and filters selected to generate the Alabama State file information: \\ \\
At line 101 changed 4 lines
|2-5|Reporting Period\\Enter the month end date of the quarter this report is being prepared for. Example: 0916 for third quarter of 2016|
|6-14|Transmitters Federal EIN\\ \\Enter only numeric characters\\ \\BASIC EIN|
|15-22|Computer\\ \\Enter the manufacturers name|Derived from [IDFDV] Field Identifier: BASIC COMPUTER
|23-24|Internal Label\\ \\ SL, NS, NL, AL, or blank for diskette|Derived from [IDFDV] Field Identifier: BASIC INTERNAL LABEL (seq 2100, first 2 characters)
|2-5|Reporting Period|Enter the month end date of the quarter this report is being prepared for. Example: 0916 for third quarter of 2016
|6-14|Transmitters Federal EIN|Enter only numeric characters. BASIC EIN
|15-22|Computer|Enter the manufacturers name. \\Derived from [IDFDV] Field Identifier: BASIC COMPUTER
|23-24|Internal Label|SL, NS, NL, AL, or blank for diskette.\\Derived from [IDFDV] Field Identifier: BASIC INTERNAL LABEL (seq 2100, first 2 characters)
At line 106 changed 2 lines
|26-27|Density\\ \\16, 62, 38, or blank for diskette|Derived from [IDFDV] Field Identifier: BASIC DENSITY (seq 2110)
|28-30|Recording Code (Character Set)\\ \\EBC, or ASC. Always ASC for diskette|Derived from [IDFDV] Field Identifier: BASIC RECORDING MODE (seq 2120, first 3 characters)
|26-27|Density|16, 62, 38, or blank for diskette. \\Derived from [IDFDV] Field Identifier: BASIC DENSITY (seq 2110)
|28-30|Recording Code (Character Set)|EBC, or ASC. Always ASC for diskette. \\Derived from [IDFDV] Field Identifier: BASIC RECORDING MODE (seq 2120, first 3 characters)
At line 113 changed 2 lines
|2-5 AL|Year\\Enter the year this quarterly report is being prepared for (YYYY).
|6-15|Federal EIN\\Enter only numeric characters|Derived from the [IDGV] State SUI Registration
|2-5 AL|Year|Enter the year this quarterly report is being prepared for (YYYY).
|6-15|Federal EIN|Enter only numeric characters. \\Derived from the [IDGV] State SUI Registration
At line 116 changed one line
|24-74|Employer Name\\Enter the first 50 positions of the employer's name exactly as registered with the state UI agency|Derived from the Entity
|24-74|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 119 changed one line
|141-166|Blank
|141-166|Blank|
At line 121 changed 3 lines
|172 AL|Blank
|173-183 AL|Employer Account Number
|184-187 AL|Blank
|172 AL|Blank|
|173-183 AL|Employer Account Number| |
|184-187 AL|Blank|
At line 125 changed one line
|191-275|Blank
|191-275|Blank|
At line 130 changed 6 lines
|2-10|Social Security Number \\Employee's social security number; if not known, enter 'I' in position 2 and blanks in position 3-10|
|11-30 AL|Employee Last Name
|31-42 AL|Employee First Name
|43 AL|Middle Initial
|44-45 AL|State Code\\Use the standard FIPS postal abbreviation. \\Constant "AL" for Alabama
|46-49|Quarter and Year|Enter the two digit month of the last quarter followed by the last two digits of the year this report is being prepared for. Example 0916 means 3rd quarter 2016
|2-10|Social Security Number|Employee's social security number. If not known, enter 'I' in position 2 and blanks in position 3-10
|11-30 AL|Employee Last Name| |
|31-42 AL|Employee First Name| |
|43 AL|Middle Initial| |
|44-45 AL|State Code|Use the standard FIPS postal abbreviation. \\Constant "AL" for Alabama
|46-49|Quarter and Year|Enter the two digit month of the last quarter followed by the last two digits of the year this report is being prepared for. \\Example 0916 means 3rd quarter 2016
At line 138 changed 2 lines
|147-156 AL|State Unemployment Insurance Account Number\\ \\Enter the DIR tax account number\\ \\SUI Registration Number from [IDGV]|
|157-275 AL|Blank|
|147-156 AL|State Unemployment Insurance Account Number|Enter the DIR tax account number. Derived from the SUI Registration Number from [IDGV]|
|157-275 AL|Blank| |
At line 144 changed 2 lines
|2-8|Reported Total Number of Employees\\ \\The total number of 'S' records since the last 'E' record|
|13-26 AL|State QTR Total Gross Wages for employer. QTR gross wages subject to all taxes. No decimals\\Total of this field on all 'S' records since the last 'E' record|
|2-8|Reported Total Number of Employees|The total number of 'S' records since the last 'E' record
|13-26 AL|State QTR Total Gross Wages for employer|QTR gross wages subject to all taxes. No decimals.\\Total of this field on all 'S' records since the last 'E' record
At line 151 changed one line
|2-11 AL|Reported Total Number of Employees.\\Enter the total number of 'S' records in the entire file|
|2-11 AL|Reported Total Number of Employees|Enter the total number of 'S' records in the entire file