Time Records

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 sorted in ascending or descending order.
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.

Operation

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

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 dropddown list
Business Start/End Date - Enter or select date range from the calendar control
Click Refresh Report to run the report

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

1	Site(s), Group(s), Job(s), Business Date	Select site(s), site group(s) and job(s); specify date range for report
2	Site #	Site number
3	Emp #	Employee number
4	Name	Employee name
5	Job	Job(s) assigned to employee
6	Job External Code	External code for job type used in time record
7	Labor Cat	Labor Category (if set in ECM)
8	Clock In	Clock-in date and time
9	Clock Out	Clock-out date and time
10	Reg Hrs	Total regular hours worked between clock-in and clock-out
11	OT Hrs	Overtime hours worked
12	DT Hrs	Double-time hours worked
13	Total Hrs	Total hours: Regular + overtime + double time
14	Reg. Wages	Wages based on pay rate and regular hours worked
15	OT Wages	Wages based on overtime pay rate for overtime hours worked
16	DT Wages	Wages based on double-time pay rate for double-time hours worked
17	Total Wages	Total wages for all hours worked
18	Pay Rate	Employee rate of pay
19	Declared Tips	Tips declared
20	Net Sales	Net sales
21	Gross Sales	Gross sales
22	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