Time Record Details

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 .

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
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 Record Details report can be run by site(s), site group(s), job(s) and start and end date.

Select Time Record Details from the list of of reports

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
Click Refresh Report to run the report
Expand All/Collapse All - Expand All will expand the records to show all levels (employee name, employee number, job, site number, breaks and adjustments) ; Collapse All will collapse records to the employee name level.
- Use the right-facing caret to expand/collapse each level
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.

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 PDF will appear in either expanded or collapsed view, depending on the view shown before exporting to PDF
EXPANDED ADJUSTMENT/BREAK DETAIL The following job permissions are required to perform certain types of adjustments: Can change the break type a user clocked out for Can change the job a user clocked in to work Can change the time punched in or out
Record Type	The type of record, e.g., Paid Break, Adjustment, etc.
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 Type After Adj.
Job Before Adj.
Job After Adj.
Adjusted By
Reason
Date/Time Adj.
Record Deleted
Acknowledgment

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.

Time Record Details

Operation

EXPANDED ADJUSTMENT/BREAK DETAIL

Related articles