Quarterly Wage and Multiple Worksite Report

The Quarterly Wage and Multiple Worksite report provides the following information:

• 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 and Multiple Worksite Report.

Submission Period

At the end of every quarter.

Selection Rule

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

Process

To create a report:

If needed, update the related setup to reflect any changes.

1. Load the data for the report.
2. Create the report file and verify that data was loaded correctly.
   
   • Review the log file for possible errors, if any.

   • Use the maintenance options to add or delete records or to correct data. Note that any changes that you make here must be duplicated in the source data.

     

     If errors require changes to the setup or source data, you must purge the loaded data, then repeat steps 1 and 2.

3. Once the data is correct, create the AL Quarterly Wage report.

Download the AL Quarterly Wage Report and follow the State's submission procedures.

Setup

Employer

Before generating the AL Quarterly Wage report, ensure that valid information is specified in the required fields on the Employer page.

1. Choose Setup, then Employer.

   

   When setting up an Employer for the first time, the default information from the W2 employer information is displayed. You can change the default information.

2. Update the employer information, if required.

3. Click Save.
   
4. Click Yes. The updated employer information is saved.
   

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

Transmitter

Before generating the AL Quarterly Wage report, ensure that valid information is specified in the required fields on the Transmitter page.

1. Choose Setup, then Transmitter.

2. Ensure that valid information is specified in the required fields.

3. If you need to update the information on the Transmitter page, click Reset.

4. Specify valid information in the required fields.
   
5. Click Save.
   
6. Click Yes. The updated transmitter information is saved.

Worksite Information

1. Choose Setup, then Worksite Information.
2. Filter records using the following criteria:
   • Worksite Code
   • Reporting Unit Number
   • Legal Name
   • Street Address
     To specify filter criteria, select an option from the list, enter a keyword or select an option in the following field, and click Add. The filter is added.
3. To add a new record, click Add Record. Specify valid information in the required fields, click Save. Click Yes.
4. To edit a record, click the ellipsis in the Actions column and select Edit.
5. To delete a record, click the ellipsis in the Actions column and select Delete. Click Yes.

Load Data

You can load data based on the Reporting Year, Reporting Quarter, Check Issue Start Date, Check Issue End Date, and monthly pay runs.

1. Choose Load.
2. Select the Reporting Year, Reporting Quarter, Check Issue Start Date, Check Issue End Date, and pay runs for all the three months.

3. Click Load, then Yes. The AL Quarterly Wage Load Summary Report is created.

4. Save the file, then click OK.
5. Navigate to the folder containing the summary report file.
6. Inspect the file. Update data, if needed.
7. Repeat steps 1 to 6 until all the required data is loaded.

Maintain Data

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

1. On the AL Quarterly Wage Report page, you can filter records by the following criteria:
   • Year
   • Quarter
   • Employee Number
   • Social Security Number
   • Last Name
   • First Name
   • Gross Wages
2. To specify filter criteria, select an option from the list, enter a keyword or select an option in the following field, and click Add. The filter is added.
3. To add a record, click Add Record. Specify valid information in the required fields, and click Save. Click Yes.
4. To edit a record, click the ellipsis in the Actions column and select Edit.
5. To delete a record, click the ellipsis in the Actions column and select Delete. Click Yes.

Create Files

Wage Report

1. Choose Report, then Wage Report.

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. Click Create, then click Yes.
      The Wage Report is created.

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

5. Inspect the file. Update data, if needed.
6. Repeat steps 1 to 5 until all the required data is included.
7. Create the electronic file:
   1. Under File Type, select Electronic File.
   2. Select the Name Order.
   3. Click Create, then click Yes.
      The electronic file is created.
8. Save the file and click OK.

Multiple Worksite Report

1. Choose Report, then Multiple Worksite Report.

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. Click Create, then click Yes.
      The Multiple Worksite Report is created.

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

5. Inspect the file. Update data, if needed.
6. Repeat steps 1 to 5 until all the required data is included.
7. Create the electronic file:
   1. Under File Type, select Electronic File.
   2. Click Create, then click Yes.
      The electronic file is created.
8. Save the file and click OK.

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. Choose Purge.
2. Select the Reporting Year and Reporting Quarter, Check Issue Start Date, and Check Issue End Date for which you want to purge records.
3. Click Submit.
4. Click Yes, then OK.