Employee 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
|
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.
Employee Time Report Breaks and Setup
The ECM Time Report does not display and break time reports only the application does.
Setting up breaks in ECM for application reports:
- Account feature to allow breaks must be turned on first by ECM Admin
- Navigate to sites in ECM and click on Time Clock tab.
- Breaks - Break times, durations, intervals, and alerts can be set up here
- Break Permisions - Jobs allowed and Jobs that manage breaks are flagged here
...
References:
State of California - Department of Industrial Relations FAQ: https://www.dir.ca.gov/dlse/faq_overtime.htm
...