Penta Payroll Reports - Date Range Basis
Issue/Symptom/Question
What field is the date range based on when I run a Penta Report?
Applies To
Penta Reports by Module
Resolution/Fix/Answer
General Rule
Unless otherwise specified by the report description, the date range in the Report Initiation window is based on the following:
Earnings reports are run based on Check Date
Labor distribution reports are run based on Timecard Distribution Date
Union and insurance reports are run based on Period End Date
For the full list of dates used, see chart below.
Report Description | Report Code | Date Basis |
|---|---|---|
Schedule of Bond Purchases | BONDPURCHSCHD | N/A |
Certified Payroll | CERTIFIEDPR | Period End Date |
Certified Payroll-2 | CERTIFIEDPR2 | Period End Date |
Certified Payroll-3 | CERTIFIEDPR3 | 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 | Check Date |
Deduction Register - DR by OU, Deduction, Emp | DEDREG-DROUDED | Check Date |
Labor & OH - Actual Burden | DIRECTBURDEN | Timecard Distribution Dates |
EEO Report | EEO | Timecard Date |
Employee Deduction Master | EMPDEDUCTION | N/A |
Employee Earnings History | EMPEARNINGS | Check Date |
Emp Earnings History by LE OU | EMPEARNINGSLEOU | 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 |
Employer's Quarterly Wage Report | EMPQTRWAGE | Entire quarter of date entered; earnings selected by Check Date |
Employee Reimbursement Master | EMPREIMB | N/A |
Employee Utilization | EMPUTILIZATION | Work Date |
Federal Unemployment Compensation | FEDERALUC | Check Date |
Labor Distribution By Work Date | LABDISTEMPID_WD | Timecard Distribution Dates |
Labor Distribution By Employee Name | LABDISTEMPNAME | Timecard Distribution Dates |
Labor Hours By Project Manager & Employee Name | LABHRSPMNAME | Timecard Distribution Dates |
Labor & Overhead | LABOR&OVERHEAD | Timecard Distribution Dates |
Labor Distribution By Employee ID | LABOR_DIST_EMP | Timecard Distribution Dates |
Labor Hours Distribution | LABORHOURS | Timecard Distribution Dates |
Labor Hours Distribution By Employee Name | LABORHOURSNAME | Timecard Distribution Dates |
Labor Hours Distribution By Project Manager | LABORHOURSPMGR | Timecard Distribution Dates |
Labor Hours Distribution By PR Class | LABORHOURSPRC | Timecard Distribution Dates |
Labor Productivity By Employee | LABORPRODBYEMP | Work Date |
Labor Productivity By Emp OU | LABORPRODBYOU | Work Date |
Labor Productivity By Sub-Dept | LABORPRODBYSUB | Work Date |
Labor & Overhead By Employee Name | LABOVRHDNAME | Timecard Distribution Dates |
Labor & Overhead By Manager & Employee Name | LABOVRHDPMNAME | Timecard Distribution Dates |
Labor & Overhead By Project Manager | LABR&OVRHRPMGR | Timecard Distribution Dates |
Layoff Check Reconciliation | LAYOFFRECON | Work Date from layoff check entry timecards |
Local Withholding | LOCALWH | Entire month of date entered; earnings selected by Check Date |
Manual Payroll Check Audit | MANUALCHKAUDIT | N/A |
Monthly State Tax | MTHLYSTTAX | Entire month of date entered; earnings selected by Check Date |
Pay Group Master | PAYGROUPS | N/A |
Public Liability Premiums Due | PLPREMIUMS | Period End Date (checks processed within same month) |
Public Liability Rates | PLRATES | Effective Date at PL Rate Level |
Public Liability - Unidentified | PL-UNIDENTIFIED | Period End Date (checks processed within same month) |
Public Liability - Wage Details | PLWAGES | Period End Date (checks processed within same month) |
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 |
PR Check Register - Earn Type | PRCHKREGBYEARN | Check Date |
PR Check Register - Control Date | PRCHKREGCTRLDT | Control Date |
PR Check Register by Earn Type - DR | PRCHKREGEARN-DR | Check Date |
Payroll Check Register | PRCHKREGISTER | Check Date |
PR Register Major Summary | PRCHKSMY | Check Date |
PR Register Summary - Control Date | PRCHKSMYCTRLDT | Control Date |
Payroll Class - Payrate Master | PRCLASSES | N/A |
Payroll Audit by Pay Group | PRPAYGROUPAUDIT | Period End Date |
Payroll Register Totals | PRTOTALS | Check Date |
Payroll Register Totals - Completion Date | PRTOTALSCMPLDT | Completion Date |
Quarter Tax Status Report - State | QTR_ST_TAXSTAT | Entire quarter of date entered; earnings selected by Check Date |
Reimbursement Register - Date Range | REIMBREG-DR | Check Date |
Reimbursement Master | REIMBURSEMENTS | N/A |
State Disability Insurance Report | SDIRPT | Check Date |
State Unemployment Tax Report | STATEUC | Check Date |
State Unemployment Insurance Report | SUIRPT | Check Date |
Time Card Audit Summary | TCAUDITSMY | Week Ending Date associated with timecard entries |
Time Analysis By Employee | TIMEANALREP | Work Date |
Time Analysis By Department | TIMEANALREPD | Work Date |
Quarterly SUT Report | UCCONTR | Entire quarter of date entered; earnings selected by Check Date |
Union Contribution Report | UNIONCONTRIB | Period End Dates |
Union Report | UNIONRPT | Period End Dates |
WC/PL Accounts | WCPLACCTS | N/A |
Workers Comp - Premiums Due | WCPREMIUMS | Period End Date (checks processed within same month) |
Workers Compensation Rates | WCRATES | Effective Date at WC Rate Level |
Workers Comp - Unidentified | WC-UNIDENTIFIED | Period End Date (checks processed within same month) |
Workers Comp - Wage Details | WCWAGES | Period End Date (checks processed within same month) |
Workers Comp - Wage Detail Summary | WCWAGESSMY | Period End Date (checks processed within same month) |
YTD Deduction Register | YTDDEDREG | Date determines payroll year; always reports Year-to-Date |
Year To Date Earnings | YTDEARNINGS | Date determines payroll year; always reports Year-to-Date |
YTD Reimbursement Register | YTDREIMBREG | Date determines payroll year; always reports Year-to-Date |