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-in | Clock-in date and time |
| 9 | Clock Out -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
|
...