Login  |  Navigation  |  Tutorials & Videos  |  Security Setup  |  Utilities  |  Applications  |  Resources  |  Release Notes

Applications > Payroll > Reports > State Unemployment Wages

 

 

 

 

State Unemployment Wages


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:

ØFilters

ØOptions

ØReport

ØStandard Magnetic Format For Quarterly Wage Reporting

 

Filters

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

Options

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.

Report

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.