The default file names for the Wage Report are:
-
CSV Layout: NY QWR Report_<Reporting Year>_<Reporting Quarter>.CSV
-
Flat File Layout: NY QWR Report_<Reporting Year>_<Reporting Quarter>.txt
For the latest file layout information, search for and refer to the current file specification document, NYS-45 Web File instructions on the New York State Department of Taxation and Finance website.
The following table shows the columns, column names, descriptions, and data sources or valid values for the Wage Report’s CSV Layout file.
|
Column |
Column Name |
Description |
Data Source or Valid Values |
|---|---|---|---|
|
A |
Social Security number (SSN)
|
The employee's social security number. |
Retrieved from the Social Security Number field on the Employee Information form of the NY Quarterly Wage Report page. |
|
B |
Last name |
The employee's last name. |
Retrieved from the Last Name field on the Employee Information form of the NY Quarterly Wage Report page. |
|
C |
First name |
The employee's first name. |
Retrieved from the First Name field on the Employee Information form of the NY Quarterly Wage Report page. |
|
D |
Middle initial |
The employee's middle initial. |
Retrieved from the Middle Name field on the Employee Information form of the NY Quarterly Wage Report page. |
|
E |
Total UI remuneration paid this quarter |
The total unemployment insurance (UI) subject wages for the quarter. |
Retrieved from the UI Wages field on the Employee Information form of the NY Quarterly Wage Report page. |
|
F |
Gross wages or distribution |
The total wages paid to the employee during the quarter. |
Retrieved from the Gross Wages field on the Employee Information form of the NY Quarterly Wage Report page. |
|
G |
Total NYS tax withheld |
The total NY state taxes for the quarter. |
Retrieved from the Total NYS tax withheld field on the Employee Information form of the NY Quarterly Wage Report page. |
|
H |
Total NYC tax withheld |
The total NYC local taxes for the quarter. |
Retrieved from the Total NYC tax withheld field on the Employee Information form of the NY Quarterly Wage Report page. |
|
I |
Total Yonkers tax withheld |
The total Yonkers local taxes for the quarter. |
Retrieved from the Total Yonkers tax withheld field on the Employee Information form of the NY Quarterly Wage Report page. |
|
J |
Wage type |
The type of wages. |
The valid value is R. |