Employee Pay Summary

Ad Hoc Reporting Guide
Version
R2025.2.1
ft:lastPublication
2025-11-10T19:54:31.807000
Employee Pay Summary

The Employee Pay Summary report uses the Employee Pay Summary topic to show details about employee pay. You can report on multiple locations at once and include information such as pay code, category, labor metrics, and clock entries.

Fields

Fields included in the report template
Field Name Group by Sort Order Totals
Employee Number Yes A to Z  
Employee Name   Ascending  
Pay Date   Z to A  
Pay Code   Ascending  
Pay Category   Ascending  
Location      
Department      
Job      
Pay Period      
Hours      
Pay Amount      
Rounded In Out Time Entries      
Employee Comments      
Manager Comments      

Custom Fields

Pay Period

The Pay Period custom field displays the numeric value that designates a pay period sequence. It uses the following expression:

ISNULL(PayGroupCalendar.PayPeriod, '') + ' ' + ISNULL(PayGroupCalendar.PayPeriodSuffix, '') + ' ' + ISNULL(CONVERT(NVARCHAR, PayGroupCalendar.EffectiveStart, 101), '') + ' - ' + ISNULL(CONVERT(NVARCHAR, PayGroupCalendar.TransmitByDate, 101), '')

Pay Date

The Pay Date custom field shows the employee pay date. It uses the following expression:

ISNULL(CONVERT(VARCHAR(10), EmployeePaySummary.PayDate, 120), '')

Rounded In Out Time Entries

The Rounded In Out Time Entries custom field shows the rounded clock entry time sequence. It uses the following expression:

CASE
    WHEN EmployeePaySummary.TimeStart IS NULL
         AND EmployeePaySummary.TimeEnd IS NULL THEN ''
    ELSE ISNULL(FORMAT(EmployeePaySummary.TimeStart, 'hh:mm tt', 'en'), '') + ' - ' + ISNULL(FORMAT(EmployeePaySummary.TimeEnd, 'hh:mm tt', 'en'), '')
END

Employee Comments

The Employee Comments custom field shows the employee’s time entry comment. It uses the following expression:

CASE
    WHEN EmployeePaySummary.PunchId IS NOT NULL THEN ISNULL(EmployeePunch.EmployeeComment, '')
    WHEN EmployeePaySummary.EmployeePayAdjustId IS NOT NULL THEN ISNULL(EmployeePayAdjust.EmployeeComment, '')
END

Manager Comments

The Manager Comments custom field shows the manager’s time entry comment. It uses the following expression:

CASE
    WHEN EmployeePaySummary.PunchId IS NOT NULL THEN ISNULL(EmployeePunch.ManagerComment, '')
    WHEN EmployeePaySummary.EmployeePayAdjustId IS NOT NULL THEN ISNULL(EmployeePayAdjust.ManagerComment, '')
END

Filters

The template includes the following filters:

Report filters.