Time Record Details report

Owned by Rose Eliff (Unlicensed)
Last updated: Aug 25, 2022 by Alger Alama
5 min read

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

  • 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 to filter report for name(s) selected 

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. 

 

Related articles

Time Records: Acknowledge Adjustments 

Time Records Adjustments report