Quarterly Wage Withholding By State is a new program in Rev 15 that can be found on the Payroll Reports Tax Reports menu (10-4-3-5). This report can be used to send to some states to report Quarterly (QTD) UI Wages, Year-To-Date (YTD) Gross Wages, and Year-To-Date (YTD) State Tax Withheld. Some states require companies to send in these reports with only the QTD UI Wage totals quarterly and to include the year-to-date totals on the fourth quarterly report. This report will use actual Payroll Labor (PAYD) records in order to do the calculations instead of using the Employee QTD / YTD information from the Employee File (EMPLD). This means, that if you are currently in the third quarter of the year, you can run the report to get the first quarter information. The report is sorted by Company Number and Employee Number. This report assumes that the first Payroll of the year has a Week Number of 1. It also assumes that the Employee will be in the same company number throughout the year. If the employee does change company numbers within the year, the employee will show up twice on the report, one total for each company.
Location: 10 Payroll> 4 Reports> 3 Tax Reports> 5 Quarterly Wage Withholding By State
Filename: PARP305
Beginning State, A’ll Or E’nd
Ending State
Enter the range of States that should be included on the report, or enter “A” for all States. This is the Tax State (field 48) in the Employee File (EMPLD).
Beginning QTD Week Number Or A’ll
Ending QTD Week Number
Enter the range of Week Numbers that should be included in the QTD UI Wages total. Since this is a quarterly total, the number of weeks entered here should make up a full three months.
Beginning Employee Number Or A’ll
Ending Employee Number
Enter the range of Employee Numbers that should be included on the report, or enter “A” for all Employees.
Do You Wish To Include YTD Information (Y/N)
Enter Y if the report should calculate and print the YTD Gross Wage and the YTD State Tax totals. Enter an N to not calculate and print these fields. If an N for no is entered, the range of YTD Week Numbers will not be asked.
Beginning YTD Week Number Or A’ll
Ending YTD Week Number
Enter the range of Week Numbers that should be included in the YTD Gross Wage and YTD State Tax totals. Since this is a year-to-date total, the beginning week number should be 1 and the ending should be the current week number.
Enter Report Heading
Since this report can be printed for various states, and each state has a different name for this type of report, the operator can enter what they would like the heading of the report to say. This is a 70 character field, and will be centered on the first line of the report.
Federal ID Number
Enter your company’s Federal ID Number. This will appear on the first line of the report. If this report is not going to be sent to the State, you can just return at this prompt, and the Federal ID Number will print as blank. The report will allow up to 20 characters to be entered at this prompt.
Quarter End Date
Enter the date that is the last day of the quarter. This field is only used to print in the heading and will be used by the State to determine what quarter the data reflects.
Report Sample without YTD Information:
Soc Sec Num
This is the Employee’s Social Security Number from the Employee File (EMPLD).
Name
This is the Employee Name from the Employee File (EMPLD).
Qtrly UI Wages
This is the QTD UI Wages. This is the total of the Gross minus Café Deduction for all Payroll Labor (PAYD) records for that Company / Employee Number for week numbers that are in the range of QTD Week Numbers entered.
YTD W/H Wages
This is the YTD Withholding Wages. This is the total of the Gross minus Café Deduction minus 401K deduction for all Payroll Labor (PAYD) records for that Company / Employee Number for week numbers that are in the range of YTD Week Numbers entered.
YTD State W/H
This is the YTD State Tax Withheld. This is the total of the State Tax for all Payroll Labor (PAYD) records for that Company / Employee Number for week numbers that are in the range of YTD Week Numbers entered.
The report will total the UI Wages, W/H Wages and State W/H columns.
Report Sample with YTD Information:
