Dates on PENTA Legacy Payroll Reports

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.