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 by Check Date
Manual Payroll Check Audit	MANUALCHKAUDIT	N/A
Monthly State Tax	MTHLYSTTAX	Report runs for the entire month of the date entered by Check Date
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	Pay Period End Dates Additional Selection Criteria “WORK_DATE” limits to work dates within the pay period
Union Report	UNIONRPT	Pay Period End Dates Additional Selection Criteria “WORK_DATE” limits to work dates within the pay period.
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	Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). The “Use Check Date” Selection Criterion overrides Pay Period End Date
Workers Compensation Rates	WCRATES	Effective Date At the WC Rate Level.
Workers Comp-Premiums Due	WCPREMIUMS	Pay Period End Date (reports processed checks that have a Pay Period End Date in the same month as the report date entered). The “Use Check Date” Selection Criterion overrides Pay Period End Date
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.

Browser not supported