Issue/Symptom/Question

Report: Certified Payroll – 4 (CERTIFIEDPR4)

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:

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
Separate FICA/MEDI? – This splits FICA into two components—FICA and Medicare.

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.

Gender and Race

The Gender and Race assigned to the employee’s main record (in the Employee Payroll Information window’s Reporting tab).

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.

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 (Employee Payroll Information window’s Withholding tab) 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 net amount of the check.

When System Option #118 (“Prorate Amts On Certified PR”) is:

N – the 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

For situations where you manually provide the starting and ending times of the employee’s work days, PENTA prints Starting Time and Ending Time field labels for your convenience.

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.

Penta Knowledge Base