Penta Payroll Reports - Date Range Basis


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

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