The Time Record Details report expands on the information provided by the Time Records report–employee hours, wages, tips, sales information–and includes breaks and adjustments made to the time record.
The user role must have permission to access this report:
- By default, records are shown expanded at the job level to show detailed information for each employee.
- Record level hierarchy:
- Employee name
- Employee number
- Job
- Site number
- Breaks and adjustments
- Site number
- Job
- Employee number
- Employee name
- Record level hierarchy:
- 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 | ||
|---|---|---|
| ||
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. |
...
- Select Time Record Details from the list of of reports
- Select report options
| 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 name(s) selected
|
| Show deleted records | The deleted time records are shown with a strikethrough on the values
|
Refresh Report |
|
...
|
Expand All/Collapse All |
...
|
...
- View breaks and adjustments details - Click the caret next to the break or adjustment to expand the detail view.
In this example, the Paid Break is expanded to show the adjustment made, who it was adjusted by, the reason and time and the employee acknowledgment status.
Report Fields
| Site(s), Group(s), Job(s), Business Date | Select site(s), site group(s) and job(s); specify date range for report |
| Site # | Site number |
| Name | Employee name |
| Emp # | Employee number |
| Job | Job(s) assigned to employee |
| Job External Code | External code for job type used in time record |
| 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
|
EXPANDED ADJUSTMENT/BREAK DETAILThe following job permissions are required to perform certain types of adjustments:
| |
| Record Type | Record types:
|
| Clock-in | Clock-in date and time |
| Clock-out | Clock-out date and time |
| Clock-in Before Adj. | Clock-in date and time prior to adjustment |
| Clock-in After Adj. | Clock-in date and time after adjustment |
| Clock-out Before Adj. | Clock-out date and time prior to adjustment |
| Clock-out After Adj. | Clock-out date and time after adjustment |
| Break Type Before Adj. | Break types:
Break type before adjustment |
| Break Type After Adj. | Break type after adjustment |
| Job Before Adj. | Job before adjustment |
| Job After Adj. | Job after adjustment |
| Adjusted By | Name of user that performed the time record adjustment |
| Reason | Adjustment reason (configure in Adjustments in ECM) |
| Date/Time Adj. | Date and time adjustment was performed |
| Record Deleted | Shows if a record was deleted (Yes/No) |
| Acknowledgment | Status of adjustment acknowledgment by employee:
|
- View breaks and adjustments - Click the caret next to the employee number
- View breaks and adjustments details - Click the caret next to the break or adjustment to expand the detail view.
In this example, the Paid Break is expanded to show the adjustment made, who it was adjusted by, the reason and time and the employee acknowledgment status.
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.
...