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.
Optional feature - Account feature toggle required
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
- 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.
| Site(s), Group(s), Job(s), Business Date | Select site(s), site group(s) and job(s); specify date range for report |
| Name | Select one or more employee names from list
|
| 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
|
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