Vermont UI QTD Report Page 2: Completing the VT C-147 Quarterly Wage Report

Employers filing Vermont’s quarterly unemployment wage report — Form C-147 — through QuickBooks often find that while the software handles most of the data population automatically, several fields on Page 2 require manual attention before the form is ready to submit.

Page 2 of the Vermont UI QTD (Quarter-to-Date) report is where each employee’s quarterly wage detail is recorded. QuickBooks draws on existing company, payroll, and employee records to prefill the majority of the fields. In a well-maintained file where all employee data is current and complete, most users will need to do little beyond reviewing what the software has generated. However, gaps do appear, and understanding how to handle them ensures the form meets Vermont’s filing requirements.

What QuickBooks Fills In Automatically

For each employee, QuickBooks populates total gross wages for the quarter, taxable wages for the quarter, and the employee’s gender — provided that information was entered during employee setup. The software also designates whether an employee is hourly or salaried: it enters “H” if you are tracking regular hours for that employee and “S” if you are not.

Fields That Require Manual Entry

The most common stumbling block is the hourly wage field. QuickBooks does not prefill this value, so employers must enter it manually for every employee classified as hourly. Employee hours worked are prefilled only for hourly employees, and only if that data was provided during employee setup.

New employees who have not yet been added to QuickBooks will not appear on the form at all. They must be entered in the Employee Center before the report can capture their wage data.

Handling Missing Social Security Numbers

Vermont requires a social security number for every employee on the quarterly filing. When an SSN is unavailable, QuickBooks has a specific convention: enter a designated marker in the Employee Center for that individual. The software then generates a substitute number on the form using a sequential system — eight zeros followed by a final digit starting at 1 for the first employee with a missing SSN, then 2 for the next, and so on. This sequencing satisfies the state’s formatting requirement.

For any employee with a missing or unknown SSN, you must also manually select the employee’s gender, since QuickBooks cannot cross-reference that data without the identifying number.

The Hourly Employee Exception

One situation catches employers off guard. If an hourly employee earned no regular hours during the quarter but did accrue vacation or sick pay, QuickBooks may not assign the “H” indicator correctly. The employer needs to manually select “H” in the classification column for that employee so the form accurately reflects their employment type.

Reviewing and Editing

Every field on Page 2 is editable. QuickBooks recommends reviewing all fields the software did not fill automatically and entering any missing information before filing. For employers trying to trace where specific numbers originated, the Help button within the form window provides guidance on how QuickBooks calculated particular figures from the underlying payroll data.

The key takeaway: QuickBooks does the heavy lifting on Vermont’s quarterly wage report, but hourly wage rates, missing SSN handling, and the hourly classification for employees with only vacation or sick pay remain manual responsibilities. A careful review of the prefilled data against payroll records will catch most issues before filing.