Report: Certified Payroll – 2 (CERTIFIEDPR2)
- Claire Aleman
Issue/Symptom/Question
Report: Certified Payroll – 2 (CERTIFIEDPR2)
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 and printing of certain values 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 Last 4 Digits of Tax Id?
Print SS#?
Separate FICA/MEDI? – This splits FICA into two components—FICA and Medicare.
Sort
Records sort in order by:
Project
Week-ending Date
Employee Id
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.
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 area, the report calculates 1 and 2 type hour rates as 1.5 and 2.0 times that section’s S (regular) hour rate.
Proj 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’s main record provides this value.
When the System Option #118 (“Prorate Amts On Certified PR”) value is:
N – 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 – SIT and Local tax are check amounts.
Y – SIT and Local tax are project amounts.
Net
The check’s net amount.
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.
Other Information
If the System Option #119 (“Certified PR, Print Check Num”) value is Y, PENTA prints the check’s number below the Proj Wage/Tot Gross information. Deductions, reimbursements, and deduct-from-check fringes also print in this area.
Related content