The State Unemployment Wages report produces a .txt file used for reporting unemployment insurance wages. Employees must have a Payroll address or Main Home address for the state chosen for them to populate in the report.
NOTE: This report only applies to the state(s) available under Options.
This Section Includes:
ØStandard Magnetic Format For Quarterly Wage Reporting
Filters allow you to reduce the number of entries that appear on the report. Select from the following fields to filter your report.
•Quarter:
•Calendar Year:
The Options tab allows you to change the appearance and set the sort order for your report.
•Choose the State.
•Enter the State Account Number.
Click the Run Report button to generate a preview of the report.
•Click the Clear Preferences link to reset all of your report preferences to their default values.
•Click the Close Report button to return to the dashboard.
The report displays on the Report Preview page. Refer to the Report Preview help page for more information.
Standard Magnetic Format For Quarterly Wage Reporting
RECORD NAME: S RECORD – EMPLOYEE RECORD RECORD LENGTH = 275
DATA TYPES: A/N = ALPHANUMERIC; LEFT JUSTIFIED AND BLANK FILLED. N = NUMERIC; RIGHT JUSTIFIED, ZERO FILLED, UNSIGNED DO NOT INCLUDE DECIMAL IN FIELDS CONTAINING DOLLARS AND CENTS.
Location |
Field Name |
Field Length |
Type |
Description and Remarks |
1-1 |
Record Identifier |
1 |
A/N |
Constant "S" |
2-10 |
Social Security Number |
9 |
A/N |
Employee’s social security number, if not known enter the letter “I” in position 2 and blanks in positions 3-10. |
11-30 |
Employee Last Name |
20 |
A/N |
Enter employee last name. |
31-42 |
Employee First Name |
12 |
A/N |
Enter employee first name. |
43-43 |
Employee Middle Initial |
1 |
A/N |
Enter employee middle initial. If no middle initial, enter blank. |
44-45 |
State Code |
2 |
A/N |
Enter the state FIPS postal numeric code for the state to which wages are being reported. |
50-63 |
State QTR Total Gross Wages |
14 |
N |
Enter quarterly wages subject to all taxes, as reported on UI-2 form, line 5. NOTE: Less Cafeteria Wages. |
147-161 |
State Unemployment Insurance Account Number |
15 |
A/N |
Enter state UI employer account number. Mississippi’s account number is 10 digits without dashes or slashes. |
215-220 |
Reporting Quarter and Year |
6 |
A/N |
Enter the last month and year for the calendar quarter for which this report applies, e.g., “032000” for Jan-Mar of 2000. |