Time Record Details report

he 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
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
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
Show deleted records	The deleted time records are shown with a strikethrough on the values
Refresh Report	Click 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

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 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	Record types: Adjustment Paid Break Unpaid Break Break Adjustment
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: Shift End Paid Break Unpaid Break 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: Requires acknowledgement - Employee has not acknowledged the adjustment Confirmed - Employee has confirmed the adjustment Declined - Employee has declined the adjustment

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.

Time Record Details report

Operation

Report Fields

EXPANDED ADJUSTMENT/BREAK DETAIL

Related articles