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 filtered to show a subset of records. (Timestamp column cannot be filtered.)
- Report can be exported to Excel, PDF or CSV formats.
| Info |
|---|
| title | 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 to filter report for names selected
- Click Refresh Report to run the report
Image Added
The right-facing caret above each employee's records can be used to expand or collapse the records as needed.
Image Added
| Site(s), Group(s), Job(s), Business Date | Select site(s), site group(s) and job(s) |
and | ; specify date range for report |
2| Name | Select employee name(s) from list to show report for name(s) selected  Image Added
|
| Site # | Site number |
| Emp # | Employee number |
3 | 4 |
| Job | Job(s) assigned to employee |
5 |
| Job External Code | External |
Code | code for job type used in time record |
6 | | Labor Cat | Labor Category (if set in ECM) |
7 | In In 8 | Out Out 9 | | Reg Hrs | Total regular hours |
of work | worked between clock-in and clock-out |
10 | | OT Hrs | Overtime hours worked |
11 |
| DT Hrs | Double-time hours worked |
12 | | Total Hrs | Total hours: Regular + overtime + double time |
13 | Based | Wages based on pay rate and |
total 14Overtime wages | 15 | | Wages based on overtime pay rate for overtime hours worked |
| DT Wages |
Double time wages | 16 | | Wages based on double-time pay rate for double-time hours worked |
| Total Wages | Total wages |
paid 17 | Pay 18 | | Declared Tips | Tips declared |
19 | 20 | 21 |
| Export Report | Save file in Excel, PDF |
, EXCEL or CSV format - PDF will appear in either expanded or collapsed view, depending on the view shown before exporting to PDF
|
Image Removed
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
...