Wage and Contribution Report - CSV and Excel File Layout and Data Mapping

The default file names for the Wage and Contribution report CSV and Excel formats are:

CSV format: VT Quarterly Wage_Wage And Contribution Report_<MMDDYYYY_hhmmss>.csv
Excel format: VT Quarterly Wage_Wage And Contribution Report_<MMDDYYYY_hhmmss>.xlsx

Both formats contain the same columns in the following order. The Social Security Number is always full and unmasked in both formats.

Column	Field Name	Description	Data source and Valid values
A	SSN	The employee's Social Security number. Always full and unmasked.	Retrieved from the Social Security field on the Employee Information page.
B	Last Name	The employee's last name.	Retrieved from the Last Name field on the Employee Information page.
C	First Name	The employee's first name.	Retrieved from the First Name field on the Employee Information page.
D	Middle Initial	The employee's middle initial.	Retrieved from the Middle Name field on the Employee Information page.
E	Gross Wages	The total gross wages paid to the employee during the quarter.	Retrieved from the Gross Wages field on the Employee Information form of the VT Quarterly Wage Report page.
F	Pay Type	Indicates whether the employee is paid on an hourly or salary basis.	Valid values: Hourly Salary Derived from the Hourly/Salaried Flag field on the Employee Information form of the VT Quarterly Wage Report page.
G	Quarterly Hours Worked	The total hours the employee worked during the reporting quarter.	Retrieved from the Hours Worked field on the Employee Information form of the VT Quarterly Wage Report page.
H	Gender	The employee's gender.	Valid values: Male Female Retrieved from the Sex at Birth field on the Employee Information page.