Quarterly Contribution and Wage Report
The Quarterly Contribution and Wage report provides the following employee information for the selected quarter:
Monthly contributions
Monthly wages
Multiple worksite information
Menu Path
From the Human Resources menu, select State. From the State - MO menu, select Quarterly Contribution and Wage Report.
Submission Period
January - March: Due by April 30
April - June: Due by July 31
July - September: Due by October 31
October - December: Due by January 31
Selection Rule
Includes employees who received wages in the selected quarter.
Excludes employees with Y in the Excl Qtr Wage field on the Employee Information - State Required II page.
Prerequisites
Set up Locations.
Select locations in the following fields on the Employee Information page:
Department and Base Location fields on the Employment tab.
Location field on the Personnel tab.
Check Location field on the Payroll tab.
Enter valid information in the:
District Number field on the Human Resources Profile - State page.
Separate Date field on the Employee Information - State Required page.
Excl Qtr Wage and Worksite ID fields on the Employee Information - State Required II page.
Complete the Setup procedures.
Setup
Before generating the Quarterly Contribution and Wage report, set up the following:
Employer
On the MO Quarterly Contribution and Wage Report page, select Setup, and then select Employer.
When setting up an Employer for the first time, the default information from the W-2 employer information is displayed. You can update the default information.
Refer to the Field Descriptions and update the employer information.
To discard updates, select Reset.
To save updates, select Save, and then Yes.
Field Descriptions
Field | Description |
|---|---|
Name | The name of the school or district. The limit is 30 characters. |
Street Address 1 | The first line of the employer's address. The limit is 30 characters. |
Street Address 2 | The second line of the employer's address. This is used for the apartment, unit, or suite numbers. The limit is 30 characters. |
City | The city where the district is located. The limit is 15 characters. |
State | The two-character code identifying the state where the district is located. |
Zip | The five-digit zip code of the district's location. |
Zip Ext | The four-digit zip code extension. |
Contact Phone Number | The employer's ten-digit phone number. |
Employer Account | The state-assigned employer organization code. |
Maximum Taxable Earnings | The employees' annual maximum taxable wages. |
Contact Information
On the MO Quarterly Contribution and Wage Report page, select Setup, and then select Contact Information.
Refer to the Field Descriptions and update the contact information.
Select Save, and then Yes.
Field Descriptions
Field | Description |
|---|---|
Contact Name | The employer contact person's name. The limit is 50 characters. |
Contact Title | The employer contact person's title. The limit is 50 characters. |
Employer Name | The name of the employer. The limit is 35 characters. |
Street Address | The employer's address. The limit is 35 characters. |
City | The city where the employer contact is located. The limit is 30 characters. |
State | The two-character code identifying the state where the employer contact is located. |
Zip | The five-digit zip code of the employer contact’s location. |
Zip Ext | The four-digit zip code extension. |
Phone Number | The employer contact's ten-digit phone number. |
U.I. Number | The employer's Unemployment Insurance number. |
Site ID | The employer's Supervisory Union (SU) number. |
Worksite Location | The location to use as the employee's worksite. Refer to Worksite Location Options for more information. |
Worksite Location Options
The worksite location options determine the source field from where the employee’s location is retrieved.
The following table describes the source fields for the worksite location options:
Option | Source Field |
|---|---|
Base Location | Base Location field on the Employment tab of the Employee Information page. |
Personnel Location | Location field on the Personnel tab of the Employee Information page. |
Check Location | Check Location field on the Payroll tab of the Employee Information page. |
State Required Worksite | Worksite ID field on the Employee Information - State Required II page. |
Department | Department field on the Employment tab of the Employee Information page. |
Worksite Information
On the MO Quarterly Contribution and Wage Report page, select Setup, and then select Worksite Information.
Filter records using the filter criteria. To enter filter criteria:
Select an option in the first field.
Select an operator if the field displays.
Select or enter a value.
Select Add if the button displays.
Refer to Searching for Records for more information.
To manage records:
To add, select Add Record. Refer to the Field Descriptions and enter valid information in the required fields. Select Save, and then Yes.
To edit, select the ellipsis in the Actions column, and then select Edit. Update the information and select Save.
To delete, select the ellipsis in the Actions column, select Delete, and then select Yes.
Field Descriptions
Field | Description |
|---|---|
Worksite Code | A worksite code of your choice. The limit is 21 characters. The Worksite Code corresponds to the Worksite ID on the Employee Information - State Required II page. |
Reporting Unit Number | A five-digit reporting unit number of your choice. |
Legal Name | The legal name of the worksite. The limit is 35 characters. |
Trade Name | The trade name of the worksite. The limit is 35 characters. |
Street Address | The worksite's address. The limit is 35 characters. |
City | The city where the worksite is located. The limit is 30 characters. |
State | The two-character code identifying the state where the worksite is located. |
Zip | The five-digit zip code of the worksite's location. |
Zip Ext | The four-digit zip code extension. |
Worksite Description | The description of the worksite. |
Primary Comment Code | The two-digit primary comment code. |
Secondary Comment Code | The two-digit secondary comment code. |
Third Comment Code | The two-digit third comment code. |
Comments | The comments for the worksite. |
Include Locations | Use this option to associate one or more worksite locations with a worksite code. For example, if the Worksite Location selected on the MO Quarterly Contribution and Wage Report - Setup - Contact Information page is Base Location, refer to the Location Table page and find the Location Codes associated with the base location. Enter the location codes for the base location in this field and select Add. |
Load Data
On the MO Quarterly Contribution and Wage Report page, select Load.
Select the Reporting Year and Reporting Quarter.
Enter the Taxable Wage Base and Employer Account.
Select the pay runs:
Pay Run(s) For 1st Month - Pay runs, including the 12th of the first month of the reporting period.
Pay Run(s) For 2nd Month - Pay runs, including the 12th of the second month of the reporting period.
Pay Run(s) For 3rd Month - Pay runs, including the 12th of the third month of the reporting period.
Employees with wages in these pay runs are included in the report.
Select Load, and then Yes.
If data for the selected criteria is loaded, select Yes to delete and reload the data.
Save the Load Summary report and select OK.
Inspect the file. Update data if errors are encountered. You must also update the application source data, as required.
Repeat these steps until all required data is loaded.
Maintain Data
Before creating the final submission, update data if errors were encountered. You must also update the application source data, as required.
On the MO Quarterly Contribution and Wage Report page, filter records using the filter criteria. To enter filter criteria:
Select an option in the first field.
Select an operator if the field displays.
Select or enter a value.
Select Add if the button displays.
Refer to Searching for Records for more information.
To manage records:
To add, select Add Record. Refer to the Field Descriptions and enter valid information in the required fields. Select Save, and then Yes.
To edit, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
To delete, select the ellipsis in the Actions column, select Delete, and then select Yes.
Field Descriptions
Field | Description |
|---|---|
Year | The fiscal reporting year. |
Quarter | The report quarter. |
Employee Number | The employee number. Select Lookup to find a valid employee number. |
Social Security Number | The employee's social security number. The value is retrieved from the Employee Information page. |
Last Name | The employee's last name. The value is retrieved from the Employee Information page. |
First Name | The employee's first name. The value is retrieved from the Employee Information page. |
Probationary Flag | Indicates whether the employee is on probation. |
Quarterly Wages | The employee's quarterly wages. |
Excess Wages | The employee's excess quarterly wages. |
Separation Date | The employee’s probationary date. The value is retrieved from the Separate Date field on the Employee Information - State Required page. |
Paid in Month 1 | Indicates whether the employee received wages in the first month of the quarter. |
Paid in Month 2 | Indicates whether the employee received wages in the second month of the quarter. |
Paid in Month 3 | Indicates whether the employee received wages in the third month of the quarter. |
Create Files
Quarterly Contribution and Wage Report
On the MO Quarterly Contribution and Wage Report page, select Reports, and then select Quarterly Contribution and Wage Report.
Select the Reporting Year and Reporting Quarter.
Create a hard copy of the report to verify data before you create the electronic file:
Select Hard Copy.
Select PDF or Excel.
If you have the security permission to view the entire Social Security Number (without masking) and want to include the entire Social Security Number, select Print Full Social Security Number.
Select Create, and then Yes.
Save the file and select OK.
Inspect the file. Update data if needed.
Repeat these steps until all the required data is included.
Create the electronic file:
Select Electronic File.
Select Create, and then Yes.
Save the file and select OK.
Follow the state's submission procedures.
Multiple Worksite
On the MO Quarterly Contribution and Wage Report page, select Reports, and then select Multiple Worksite.
Select the Year and Quarter Number.
Create a hard copy of the report to verify data before you create the electronic file:
Select Hard Copy.
Select Create, and then Yes.
Save the file and select OK.
Inspect the file. Update data if needed.
Repeat these steps until all the required data is included.
Create the electronic file:
Select Electronic File.
Select Create, and then Yes.
Save the file and select OK.
Follow the state's submission procedures.
Purge Data
If you need to correct setups or employee data, purge the existing records and reload the data.
On the MO Quarterly Contribution and Wage Report page, select Purge.
Select the Reporting Year and Reporting Quarter.
Select Submit.
Select Yes, and then OK.