Quarterly Unemployment Report

The Quarterly Unemployment report provides information to the Michigan UIA (Unemployment Insurance Agency) about monthly wages paid to each employee for the specified quarter. If Group Life Insurance Paycodes are specified on the Human Resources Profile - State page and the employee receives a Group Life Insurance benefit in the reporting quarter, the benefit amount is added to the reportable wages.

Menu Path

Choose Human Resources from the main navigation menu, then choose State. Click Quarterly Unemployment Report.

Submission Period

The report is due on the 25th day of the month following the end of a quarter.

Selection Rule

The report includes all employees who were paid wages for the specified quarter.

Prerequisites

Before creating the Quarterly Unemployment report, verify the following fields on the Human Resources Profile - State page have valid information:

• UIA Quarterly Wage Account Number

• Group Life Insurance Paycodes

Load Data

1. Choose Load.

2. Select the Reporting Year and Reporting Quarter.

3. Select the Check Issue Date Range and choose an end date from the To field.

4. Select the Type Of Gross Wages.

5. Enter the Excess Wages Limit.

6. Select Add in Group Life Benefit to add the group life benefit amount to the reported wages.

   

   If selected, the employer contribution amount for the deduction code set up on the Defined Window page 31999 – Employee Group Life Over 50K is added to the gross wages.

7. Select the pay run(s):

   • Pay Run(s) For 1st Month - Pay runs, including the 12^th of the first month of the reporting period.

   • Pay Run(s) For 2nd Month - Pay runs, including the 12^th of the second month of the reporting period.

   • Pay Run(s) For 3rd Month - Pay runs, including the 12^th of the third month of the reporting period.
     The monthly wages for each employee with wages for these pay runs are included in the report.

8. Enter Retirement Codes to load retirement codes information.

   

   When entering retirement codes, only employees who have the same retirement code(s) specified in the Retire Code field on the Michigan Retirement page are loaded.

9. Click Load, then Yes.

10. Save the file, then click OK.

11. Navigate to the folder containing the summary report file.

12. Inspect the file and update the data, if needed.

13. Repeat steps 1 to 11 until all the data is loaded.

Maintain Data

You can correct loaded data before submitting the report. However, any corrections to application information must also be updated in the source data.

1. On the MI Quarterly Unemployment Report page, you can filter records using the filter criteria.

2. To specify filter criteria, select a criterion from the list, and enter a keyword or select an option.

3. To add a record, click Add Record. Fill out the information, click Save, then click Yes.

4. To edit or delete a record, click the ellipsis in the Actions column, and select the appropriate option.

Create File

1. Choose Report.

2. Select the Reporting Year and Reporting Quarter.

3. Select Final Report or Apportionment.

4. Create a hard copy of the report to verify data before you create the electronic file:

   1. Under File Type, select Hard Copy.

   2. Under File Format, select PDF or Excel.

   3. Under Report Sort, select Sort by Name or Sort by Location.

   4. If you have security to view the entire Social Security number (without masking) and want to include the entire Social Security number, select Print Full Social Security Number.

   5. Click Create, then Yes to create the MI Quarterly Unemployment Report.

5. Save the file and navigate to the folder containing the report file.

6. Inspect the file, and update the data if needed.

7. Repeat steps 1 to 6 until all the data is included.

8. Create the electronic file:

   1. Under File Type, select Electronic File.

   2. Click Create, then Yes.

9. Save the file and click OK.

Follow the State's submission procedures.

Purge Data

You can purge the data for the report when:

• You want to discard the data for the report completely.

• You want to change the setup or employee data and reload the data.

To purge report data:

1. Choose Purge.

2. Select the Reporting Year and Reporting Quarter.

3. Click Submit.

4. Click Yes, then OK.