Issue/Symptom/Question
What dates to use for specific Payroll Legacy Reports.
Applies To
PENTA for Windows
Payroll Reports
PENTA Legacy Reports
Resolution/Fix/Answer
Dates on PENTA Payroll Reports
As a general rule (unless otherwise specified by the Report Description), Earnings reports are run based on Check Date, and Labor Distribution reports are run based on the Timecard Distribution Date, and Union and Insurance reports are based on Pay Period End Date.
Report Description | Report Code | Dates |
---|---|---|
Certified Payroll | CERTIFIEDPR | Pay Period End Date |
Certified Payroll-2 | CERTIFIEDPR2 | Pay Period End Date |
Certified Payroll-3 | CERTIFIEDPR3 | Pay Period End Date |
Deduction Master | DEDMASTER | N/A |
Deduction Reg- Control Date by OU, Deduction | DEDREG-CROUDED | Check Date |
Deduction Register-Date Range | DEDREG-DR | Based on System Option 102 (check date or period end date) |
Deduction Register-DR by OU, Deduction, Emp | DEDREG-DROUDED | Check Date |
EEO Report | EEO | Timecard Date |
Emp Earnings History by LE OU | EMPEARNINGSLEOU | Check Date |
Employee Deduction Master | EMPDEDUCTION | N/A |
Employee Earnings History | EMPEARNINGS | Check Date |
Employee Efficiency Analysis | EMPEFFANAL | Timecard Distribution Dates |
Employee List | EMPLIST | N/A |
Employee Local Tax Report | EMPLOCALTAX | Check Date |
Employee Master | EMPMASTER | Hired Date |
Employee Master By Name | EMPMASTERBYNAME | Hired Date |
Employee NCC YTD Summary | EMPNCCSMY | N/A |
Employee Reimbursement Master | EMPREIMB | N/A |
Employee Utilization | EMPUTILIZATION | Work Date |
Employer's Quarterly Wage Rpt | EMPQTRWAGE | Check Date Report runs for the entire quarter of the date entered. |
Federal Unemployment Comp | FEDERALUC | Check Date |
Hours by Hour Class | HRBYHRCLS | Check Date |
Hours by Hour Class – (WA IND) | HRBYHRCLS-WAIND | Check Date |
Labor & OH - Actual Burden | DIRECTBURDEN | Timecard Distribution Dates |
Labor & Overhead | LABOR&OVERHEAD | Timecard Distribution Dates |
Labor & Overhead By Emp Name | LABOVRHDNAME | Timecard Distribution Dates |
Labor & Overhead By Manager &Emp Name | LABOVRHDPMNAME | Timecard Distribution Dates |
Labor & Overhead By Proj Manager | LABR&OVRHRPMGR | Timecard Distribution Dates |
Labor Distribution By Employee Id | LABOR_DIST_EMP | Timecard Distribution Dates |
Labor Distribution By Employee Name | LABDISTEMPNAME | Timecard Distribution Dates |
Labor Distribution By Work Date | LABDISTEMPID_WD | Timecard Distribution Dates |
Labor Hours Distribution | LABORHOURS | Timecard Distribution Dates |
Labor Hours Distribution By Emp Name | LABORHOURSNAME | Timecard Distribution Dates |
Labor Hours Distribution by PR Class | LABORHOURSPRC | Timecard Distribution Dates |
Labor Hours Distribution By Proj Manager | LABORHOURSPMGR | Timecard Distribution Dates |
Labor Hr By Project Manager & Emp Name | LABHRSPMNAME | Timecard Distribution Dates |
Labor Productivity By Emp OU | LABORPRODBYOU | Work Date |
Labor Productivity By Employee | LABORPRODBYEMP | Work Date |
Labor Productivity By Sub-Dept | LABORPRODBYSUB | Work Date |
Local Withholding | LOCALWH | Report runs for the entire month of the date entered. |
Manual Payroll Check Audit | MANUALCHKAUDIT | N/A |
Monthly State Tax | MTHLYSTTAX | Report runs for the entire month of the date entered. |
Pay Group Master | PAYGROUPS | N/A |
Payroll Audit by Pay Group | PRPAYGROUPAUDIT | Pay Period End Date |
Payroll Check Register | PRCHKREGISTER | Check Date |
Payroll Class – Payrate Master | PRCLASSES | N/A |
Payroll Register Totals | PRTOTALS | Check Date |
Payroll Register Totals – Completion Date | PRTOTALSCMPLDT | Completion Date |
PR Check Reg By Earn Type – DR | PRCHKREGEARN-DR | Check Date |
PR Check Register – Earn Type | PRCHKREGBYEARN | Check Date |
PR Check Register-Control Date | PRCHKREGCTRLDT | Control Date |
PR Reg Summary-Control Date | PRCHKSMYCTRLDT | Control Date |
PR Register Major Summary | PRCHKSMY | Check Date |
PR Tax Status Report – Federal | PR_FEDTAXSTATUS | Check Dates |
PR Tax Status Report – Local | PR_LCLTAXSTATUS | Check Dates |
PR Tax Status Report – State | PR_ST_TAXSTATUS | Check Dates |
Print 941S | 941-S | Check Date |
Public Liability Premiums Due | PLPREMIUMS | Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). |
Public Liability Rates | PLRATES | Effective Date At the PL Rate Level |
Public Liability-Unidentified | PL-UNIDENTIFIED | Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). |
Public Liability-Wage Details | PLWAGES | Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). |
Qtr Tax Status Report-State | QTR_ST_TAXSTAT | Report runs for the entire quarter of the date entered. |
Quarterly UC Report | UCCONTR | Check Date |
Reimbursement Master | REIMBURSEMENTS | N/A |
Reimbursement Register-Date Range | REIMBREG-DR | Check Date |
Schedule of Bond Purchases | BONDPURCHSCHD | N/A |
State Disability Insurance Rpt | SDIRPT | Check Date |
State Unemployment Ins Rpt | SUIRPT | Check Date |
State Unemployment Tax Rpt | STATEUC | Check Date |
Time Analysis By Department | TIMEANALREPD | Work Date |
Time Analysis By Employee | TIMEANALREP | Work Date |
Time Card Audit Summary | TCAUDITSMY | Week Ending Date associated with the timecard entries. |
Union Contribution Report | UNIONCONTRIB |
|
Union Report | UNIONRPT |
|
WA Ind. Ins. Premiums Due | WAINDPREM | Check Date |
WC/PL Accounts | WCPLACCTS | N/A |
Workers Comp – Unidentified | WC-UNIDENTIFIED | Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). |
Workers Comp - Wage Detail Summary | WCWAGESSMY | Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). |
Workers Comp - Wage Details | WCWAGES |
|
Workers Compensation Rates | WCRATES | Effective Date At the WC Rate Level. |
Workers Comp-Premiums Due | WCPREMIUMS |
|
Year To Date Earnings | YTDEARNINGS | Date determines the payroll year. Information reported is always to year to date. |
YTD Deduction Register | YTDDEDREG | Date determines the payroll year. Information reported is always to year to date. |
YTD Reimbursement Register | YTDREIMBREG | Date determines the payroll year. Information reported is always to year to date. |