Report: Certified Payroll (CERTIFIEDPR)
- Claire Aleman
Issue/Symptom/Question
Report: Certified Payroll (CERTIFIEDPR)
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)
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 Project Totals for:
Total Project Hours by Day
Project Wages
Regular
1.5 Times
Double
Other (Add to Gross Fringes)
Total
Project Hours
Regular
1.5 Times
Double
Total
Project FICA/MEDI
Project Wages Subject To:
FICA/MEDI
Fed UC
State UC
Fields
Project ID
PENTA prints the Job Id and name above the listing of employees who worked on the job.
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’s name.
Trade Type and Race
The description associated with the Trade Type # assigned to the Payroll Class in which the employee worked the reported time, and the Race Code assigned to the employee’s main record.
When you generate this report with:
The Print SS? Selection criteria set to Y, this field is “Trade Type, SS# and Race.” PENTA then prints the employee’s full Tax Id.
The Print Last 4 Digits of Tax Id? Selection criteria set to Y, this field is “Trade Type, Tax Id, 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:
R – Regular hours
H –Premium 1 hours
D – Premium 2 hours
T – Total hours
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.
Earnings / Other Pay / (All Work)
This column displays any or all of the following values:
Earnings = total of regular wages, Premium 1 wages, Premium 2 wages, and Add To Gross Fringe amounts paid on the check for the project.
Other pay = all Add To Gross Fringes paid on the check.
(All Work) = wages for all projects paid on the check.
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 – 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 the System Option #118 (“Prorate Amts On Certified PR”) value is:
N – Net is the check amount.
Y – Net is the project amount.
Other Information
If the System Option #119 (“Certified PR, Print Check Num”) value is Y, PENTA prints the check’s number below the Pay Rate and Earnings information. Deductions, reimbursements, and deduct-from-check fringes also print in this area.
Related content