Report: Certified Payroll – 3 (CERTIFIEDPR3)
- Claire Aleman
Issue/Symptom/Question
Report: Certified Payroll – 3 (CERTIFIEDPR3)
Applies To
Penta for Windows
Payroll
Reports
Resolution/Fix/Answer
Prerequisites
A PENTA user processed timecards that have the Include on Cert PR Rpts flag set to Y and Jobs where the Certified Report Required box contains a checkmark.
There are eight possible “include on certified payroll reports” flag setting combinations, two of which result in the earnings/hours being included on the report.
Window – Flag | Flag setting combinations: | |||||||
|---|---|---|---|---|---|---|---|---|
Job Information window – Certified Report Required box | Y | Y | Y | Y | N | N | N | N |
Employee Payroll Information window – Include on Cert. PR Rpts field | Y | Y | N | N | N | N | Y | Y |
Timecards by Employee window, Timecards by Job window, Timecards by Selected Attributes window, and Time/Equipment/Production Units Entry window – Include on Cert Report | N | Y | Y | N | N | Y | Y | N |
Result: Does PENTA include the Timecard on this Certified Payroll Report? | N | Y | Y | N | N | N | N | N |
Note: The Include on Cert. PR Rpts flag on the Employee Payroll Information window does not control data appearing on this report. It provides the default for timecard processing.
Review the following System Options to ensure they are set according to your reporting preferences:
#118 – Prorate Amts On Certified PR (set to Y if you want amounts prorated on this report).
#119 – Certified PR, Print Check Num (set to Y if you want check numbers printed).
Selection
You can limit record selection for this report by:
End Date (Pay Period End Date)
Employee Legal Entity Organizational Unit (Employee LE OU ID)
Group Fringe #s as OTHER – Groups fringe benefits together under an “OTHER” category.
Job Id
Print Address?
Print Cash Fringe? Use for reporting associated with payroll processed via the Cash Fringe method of prevailing wage. When this is Y, the report includes two additional columns: Cash Fringe and Hourly Fringe.
Print Employee Hire Date?
Print Employee Phone #
Print Last 4 Digits of Tax Id?
Print SS#?
Separate FICA/MEDI? – When Y, the FIT/FICA/FED EX column becomes FIT/FICA/MEDI/FED EX, separately reporting MEDI and FICA amounts. When N (or null), the reported FICA amount includes MEDI and FICA.
Sort
Records sort in order by:
Project
Week-ending Date
Last Name
First Name
Middle Name
Check Type
Pay Rate – Payroll Class
Totals
This report has totals for:
Project Wages
Regular
1.5 Times
Double
Other (Add to Gross Fringes)
Total
Project Hours
Regular
1.5 Times
Double
Total
Fields
Project ID
PENTA prints the Job Id and name above the listing of employees who worked on the job.
Payroll Class Pay Rate
PENTA classifies employees on this report by printing the employee’s Payroll Class description and Pay Rate description.
Name
The full name of the employee that worked on the project.
When you generate this report with the Print Address? Selection criteria set to Y, this field is “Name and Address” followed by “City, St/Prov, and Zip Code.” PENTA then prints the address from the employee’s main record below the employee name.
Gender and Race
The Gender and Race assigned to the employee’s main record (in Employee Payroll Information window’s Reporting tab).
When you generate this report with:
the Print SS? Selection criteria set to Y – this field is “SS#, Gender and Race” and PENTA prints the employee’s full Tax Id.
the Print Last 4 Digits of Tax Id? Selection criteria set to Y – this field is “Tax Id, Gender, and Race” and PENTA prints only the last four digits of the Tax Id.
Hours Worked This Project
The day, date, and type of hours worked on the job per check issued in the pay period. Possible hour types are:
S – Straight time (regular) hours
1 –Premium 1 hours
2 – Premium 2 hours
Hours for Other Projects print below hours for the reported project if the employee worked on multiple jobs in the week.
Total Hours
The total number of hours per type of hour worked on the project.
Pay Rate
The rate paid for the hour type worked on the reported project.
In the Other Projects section, the report calculates 1 and 2 type hour rates as 1.5 and 2.0 times that section’s S (regular) hour rate.
Project Wage / Tot Gross
Two values print in this column. The first value is the Project Wage amount. The second value is the Total Gross amount for the check, including Add to Gross Fringe amount and wages for other projects.
FIT / FICA / Fed Ex
This column displays any or all of the following values:
FIT = Federal income tax amount withheld.
FICA = Social Security and Medicare tax amounts withheld.
Fed Ex = Number of withholding exemptions. The Number of Dependents field (on the Employee Payroll Information window’s Withholding tab) provides this value.
When the System Option #118 (“Prorate Amts On Certified PR”) value is:
N – the FIT and FICA are check amounts.
Y – FIT and FICA are project amounts.
State / Local
The SIT and Local tax amounts withheld.
When the System Option #118 (“Prorate Amts On Certified PR”) value is:
N – the SIT and Local tax are check amounts.
Y – SIT and Local tax are project amounts.
SDI / SUI
This column displays either or both of the following values:
SDI = State disability tax withheld.
SUI = State unemployment insurance withheld.
Total Deductions
The total of FIT, FICA, State tax (SIT), Local tax, SDI, SUI, deductions, and fringes deducted from the employee’s check.
When the System Option #118 (“Prorate Amts On Certified PR”) value is:
N – Total Deductions is the amount for the check.
Y – Total Deductions is check gross less prorated Net.
Net
The net amount of the check.
When the System Option #118 (“Prorate Amts On Certified PR”) value is:
N – Net is check amount.
Y – Net is project amount.
Fringe Detail – Desc
The description of employer-paid fringe benefits associated with the check.
Fringe Detail – Amt
The amount of employer-paid fringe benefits associated with the check.
Cash Fringe column
The per-hour rate of the Cash Fringe payment made to the employee when the pay rate + employer-paid benefits equal less than the total job prevailing wage determination.
Hourly Fringe column
The total per hour value of employer-paid benefits (PTO Accrual Schedules and Deductions with Prevailing Wage Comparison Benefit flag = Y) PENTA used in the prevailing wage rate comparison to determine whether a Cash Fringe payment was needed to ensure the employee’s pay met the job’s prevailing wage determination.
Related content