Timesheets

The Timesheets report uses the Timesheets topic to show timesheet data by employee, including raw clock entry information, and employee and manager comments. It contains information such as net hours, raw and rounded clock entries, comments, and salary details.

Note: This report contains information for primary and non-primary work assignments. If the job worked isn’t the primary assignment, the Job field is blank in the report.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number	Yes	A to Z
Pay Date		Newest to Oldest
Employee Name
Original Hire Date
Rehire Date
Employment Status
Adjusted Net Hours
Department
Raw Time Entry Start
Raw Time Entry End
Rounded Time Entry Start
Rounded Time Entry End
Manager Comments
Employee Comments
Pay Group
Job
Location
Base Salary
Base Rate

Custom Fields

Raw Time Entry Start

The Raw Time Entry Start custom field shows the employee clock in time, without rounding rules. It uses the following expression:

ISNULL(FORMAT(EmployeePunch.TimeStartRaw,'hh:mm:ss tt','en'),'')

Raw Time Entry End

The Raw Time Entry End custom field shows the employee clock out time, without rounding rules. It uses the following expression:

ISNULL(FORMAT(EmployeePunch.TimeEndRaw,'hh:mm:ss tt','en'),'')

Filters

The template includes the following filters: