PowerSchool ERP Vermont

Quarterly Wage and Multiple Worksite Report

The Vermont Quarterly Wage and Multiple Worksite Report is a state-mandated employer filing used to report employee wages, employment counts, and business location details to support unemployment insurance (UI) administration and labor market analysis.

This report enables the Vermont Department of Labor to:

  • Administer Unemployment Insurance (UI) programs

  • Track employer payroll and employment trends

  • Produce statewide labor statistics

  • Ensure employer compliance with state wage reporting laws

Who Must File

All Vermont employers subject to unemployment insurance laws must file this report.

Employers operating in multiple locations (worksites) within Vermont must also complete the Multiple Worksite Report (MWR) portion.

Report Components

Quarterly Wage Report

Captures employee-level wage detail for the reporting quarter:

  • Employee name and Social Security Number (SSN)

  • Total wages paid during the quarter

  • Number of employees for each month in the quarter

  • Total quarterly payroll

Multiple Worksite Report (MWR)

Required for employers with more than one worksite. It includes:

  • Worksite-specific employment counts

  • Physical location addresses

  • Industry classification (NAICS code)

  • Monthly employment by location

This data supports federal reporting requirements under the Bureau of Labor Statistics.

From the Human Resources menu, select State. From the State menu, select Quarterly Wage and Multiple Worksite Report.

Submission period

  • Q1 (Jan–Mar): April 30

  • Q2 (Apr–Jun): July 31

  • Q3 (Jul–Sep): October 31

  • Q4 (Oct–Dec): January 31

Reports must be submitted even if no wages were paid (zero-wage filing may be required).

Selection rule

The system selects employees in two stages: an initial employee pool is built during the Load Data step, then a zero-wage filter removes employees with no reportable wages before the extract is written.

Stage 1: Initial Employee Pool (Load Data)

The system selects every employee who has at least one paycheck in the Check History table with an issue date that falls within the Check Issue Start Date and Check Issue End Date (inclusive) selected on the VT Quarterly Wage Report - Load page.

After the date-range query, the system applies one common exclusion. Employees with an employee number greater than the system's configured maximum employee number are removed from the pool.

Stage 2: Wage Extraction and Qualification

For each employee in the pool, the system calculates the following values. Employees are included in the extract only if they have a non-zero result in at least one wage field.

Gross Wages

The system sums pay amounts (checkhi2.amt, earn_ded = 'P') for all checks with issue dates within the Check Issue Start Date and Check Issue End Date (inclusive) selected on the VT Quarterly Wage Report - Load page. It then subtracts any voided check amounts (checkrec.man_void = 'V', cleared within the same date range). Pay codes with UI Exempt selected on the Pay Codes page are excluded from the sum. Gross Wages cannot be negative (floor of $0).

Excess Wages

Excess Wages represent the portion of year-to-date wages that exceeds the UI Wage Base on the VT Quarterly Wage Report - Setup - Employer page. If the employee's year-to-date total exceeds the wage base, UI Taxable Wages = Gross Wages − Excess Wages.

Zero-Wage Exclusion

After the wage calculation, an employee is excluded if both of the following are true:

  • Gross Wages = $0

  • UI Taxable Wages = $0

These employees are silently skipped. They are not reported and do not appear in the output file.

Monthly Employment Indicators (Month 1 / Month 2 / Month 3)

The report includes a monthly employment indicator for each of the three months in the quarter. An employee is marked as employed in a given month if they have at least one check associated with a pay run selected in the corresponding Pay Run(s) For Month field on the VT Quarterly Wage Report - Load page.

Multiple Worksite Report

All employees who appear in the wage extract are also included in the Multiple Worksite Report. Employees are grouped by worksite using the Worksite Location on the VT Quarterly Wage Report - Setup - Employer page.

Prerequisites

  • Ensure the Employee Information records are complete, and the following fields are populated correctly:

    • General section: Social Security, First Name, Middle Name, Last Name, Sex at Birth

    • Personnel tab: Location

  • The employee must have check history data for the reporting quarter.

  • Ensure the Pay Rate records are complete, and the following fields are populated correctly:

    • Pay Method

    • Pay Rate

  • To report hours worked, you must load Affordable Care Act (ACA) Hours Tracking before loading data for the Quarterly Wage and Multiple Worksite report.

  • To exclude pay codes from the Gross Wages calculation, select UI Exempt on the Pay Codes page.

  • Complete the Setup procedures.