Program Description
This report can be found on the Payroll Reports Tax Reports menu (PAY-4-3-1). This page is currently under development. It allows the user to list the Social Security number, name, QTD FICA wages, QTD wages, QTD Federal Tax withheld, QTD Employee FICA tax withheld, total FICA, and QTD State Tax withheld for the company selected. This report prints in employee number order with totals at the end.
Results
The following fields in the results screen are described below:
EMPL #
This is the employee number from the EMPLD data file.
SOC.SEC. #
This is the social security number from the EMPLD file.
NAME
This is the employee name from the EMPLD file.
QTD FICA1/ FICA2 WAGES
This field has been changed from QTD FICA WAGES.
FICA1:
If the FICA wages + QTD FICA wages is greater than or equal to the FICA limit this amount is zero. If the FICA wages is greater than the FICA limit this is the FICA limit minus (FICA wages – QTD FICA wages). If the FICA wages less than or equal to the FICA limit this will be set to equal the QTD FICA wages.
FICA2:
If (employee YTD FICA wage 2 minus employee QTD FICA wage 2) is greater than or equal to the FICA limit 2, then this will be zero. If the employee YTD FICA wage 2 is greater than FICA limit 2, then this is FICA limit 2 minus (employee YTD FICA wage 2 minus employee QTD FICA wage 2). If the employee YTD FICA wage 2 is less than or equal to FICA limit 2, then this is equal to the employee QTD FICA wage 2.
QTD FED WAGES
This field has been changed from QTD WAGES. This is calculated by deducting the QTD café (or the S132) and the 401k from the QTD Gross.
QTD FED TAX
This field has been changed from QTD FED. This is the quarterly federal tax withheld from the employee (EMPLD) file.
EMPLOYEE QTD FICA%
This is the employee FICA1 and FICA2 percentage from the Federal Tax File. This is the percentage for the FICA deduction.
$ This is the employee QTD FICA1 and FICA2 dollar amount from the EMPLD File.
EMPLOYER FICA%
This is the employer FICA1 and FICA2 percentage from the Federal Tax File. This is the percentage for the FICA deduction.
$ This is the employer FICA1 and FICA2 dollar amount from the EMPLD File.
TOTAL FICA1/FICA2
This heading has been changed from TOT FICA. The calculation adds the Employee FICA1 and Employer FICA1 for the total FICA1 tax and does the same for the FICA2 tax total.
Rev 13 Changes
The totals for QTD FICA Wages and QTD Wages were enlarged to handle larger numbers. Because of this, the other fields were shifted over to the right two places.