Quarterly Wage Report

The Quarterly Wage report provides the following information to the Connecticut Department of Labor:

• Monthly wages paid to each employee for the specified quarter.

• Multiple worksite data for the specified quarter.

Menu Path

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

Submission Period

At the end of every quarter.

Selection Rule

Includes all the employees who were paid wages and the worksite location data.

Setup

Employer

Before generating the Wage or Multiple Worksite report, enter valid information on the CT Quarterly Wage Report - Employer Information page.

1. Select Setup, then Employer.

   

   When setting up an employer for the first time, the default information from the W-2 employer information is displayed. You can change the default information.

2. Refer to Field Descriptions and update the employer information if required.

3. Select Save, then Yes.

   

   Before saving, you can revert your changes by clicking Reset.

Field Descriptions

Worksite Information

Before generating the Wage or Multiple Worksite report, enter valid information on the CT Quarterly Wage Report - Multiple Worksite Information page.

1. Select Setup, then Worksite Information.

2. Filter records using the filter criteria. To enter filter criteria, select an option from the list, enter a keyword or select an option in the following field, and select Add. The filter is added.

3. To add a new record, select Add Record. Refer to Field Descriptions and enter valid information in the required fields. Select Save, then Yes.

4. To edit a record, select the ellipsis in the Actions column and select Edit.

5. To delete a record, select the ellipsis in the Actions column and select Delete. Select Yes.

Field Descriptions

Load Data

1. Select Load.

2. Select the Reporting Year, Reporting Quarter, Check Issue Start Date, and Check Issue End Date.

3. 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.

4. Select Load, then Yes.

5. Save the CT Quarterly Wage Load Summary Report file, then select OK.

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

7. Inspect the file. Update data if needed.

8. Repeat these steps until all the required 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 CT Quarterly Wage Report page, filter records by the filter criteria.
   To enter filter criteria, select an option from the list, enter a keyword or select an option in the following field, and select Add. The filter is added.

2. To add a record, select Add Record. Enter valid information in the required fields, and select Save. Select Yes.

3. To edit a record, select the ellipsis in the Actions column and select Edit.

4. To delete a record, select the ellipsis in the Actions column and select Delete. Select Yes.

Create Files

Wage Report

1. Select Reports, then Wage Report.

2. Select the Reporting Year and Reporting Quarter.

3. Select the Pay Group(s).

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. 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.

   4. Select Create, then Yes.

5. Save the file and select OK.

6. Navigate to the folder containing the report file.

7. Inspect the file. Update data if needed.

8. Repeat these steps until all the required data is included.

9. Create the electronic file:

   1. Under File Type, select Electronic File.

   2. Select Create, then Yes.

10. Save the file and select OK.

Follow the state's submission procedures.

Multiple Worksite Report

1. Select Reports, then Multiple Worksite.

2. Select the Reporting Year and Reporting Quarter.

3. 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. 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.

   4. Select Create, then Yes.

4. Save the file and select OK.

5. Navigate to the folder containing the report file.

6. Inspect the file. Update data if needed.

7. Repeat these steps until all the required data is included.

8. Create the electronic file:

   1. Under File Type, select Electronic File.

   2. Select Create, then Yes.

9. Save the file and select OK.

Follow the state's submission procedures.

Wage Report Processing

Information for each employee who meets the following criteria is extracted and reported:

1. The employee's gross wages for the quarter are not equal to zero.

2. The employee's primary pay group matches one of the pay groups selected.

If the employee's total gross wages for the quarter are less than zero, the employee is not included in the electronic file. Still, they will be included on the hard copy report, with the message * Negative Earnings *. Only positive gross wages are included in the total. The number of employees with total gross wages greater than zero is printed as the Valid Employee Count.

On the hard copy report, there are counts for the total number of employees and the female employees paid in the pay period, including the 12th of the month for each quarter. If an employee has a paycheck in check history matching the selected pay runs for each month (including manual checks), then the employee will be counted for that month. On the electronic file, there is no count for the female employees, but there is a count for the total employees paid on the 12th of the month.

Purge Data

You can purge the data for the report in the following scenarios:

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

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

1. Select Purge.

2. Select the Reporting Year and Reporting Quarter.

3. Select Submit.

4. Select Yes, then OK.