View Source

The Time Records report reports employee hours, wages, tips and sales information.

By default, records are shown expanded to show detailed information for each employee.
Columns can be filtered to show a subset of records. (Timestamp column cannot be filtered.)
Report can be exported to Excel, PDF or CSV formats.

Note: An optional feature allows Admin users to select the number of decimal places to use when rounding employee hours on time record reports. See Employee Reports for more information.

Operation

The Time Records report can be run by site(s), site group(s), job(s), start and end date and by employee name(s).

Site(s) - Select site(s) from the dropdown list
Group(s) - Select site group(s) from the dropdown list
Job(s) - Select job(s) from the dropdown list
Business Start/End Date - Enter or select date range from the calendar control
Name - Select employee name(s) from list to filter report for names selected
Click Refresh Report to run the report

Order Entry Documentation > Time Records > image2022-4-5_15-56-27.png

The right-facing caret above each employee's records can be used to expand or collapse the records as needed.

Site(s), Group(s), Job(s), Business Date	Select site(s), site group(s) and job(s); specify date range for report
Name	Select employee name(s) from list to show report for name(s) selected
Site #	Site number
Emp #	Employee number
Name	Employee name
Job	Job(s) assigned to employee
Job External Code	External code for job type used in time record
Labor Cat	Labor Category (if set in ECM)
Clock -in	Clock-in date and time
Clock-out	Clock-out date and time
Reg Hrs	Total regular hours worked between clock-in and clock-out
OT Hrs	Overtime hours worked
DT Hrs	Double-time hours worked
Total Hrs	Total hours: Regular + overtime + double time
Reg. Wages	Wages based on pay rate and regular hours worked
OT Wages	Wages based on overtime pay rate for overtime hours worked
DT Wages	Wages based on double-time pay rate for double-time hours worked
Total Wages	Total wages for all hours worked
Pay Rate	Employee rate of pay
Declared Tips	Tips declared
Net Sales	Net sales
Gross Sales	Gross sales
Export Report	Save file in Excel, PDF or CSV format PDF will appear in either expanded or collapsed view, depending on the view shown before exporting to PDF

Note: The clock-in data is stored in the cloud on ECM when a user clocks in, but is not immediately shown on the Time Records report when there is only a clock-in record. The Time Records report will display this data when there is a clock-in AND a clock-out record.

References:
State of California - Department of Industrial Relations FAQ: https://www.dir.ca.gov/dlse/faq_overtime.htm