Time Record Details report

Owned by Rose Eliff (Unlicensed)
Last updated: Aug 25, 2022 by Alger Alama
4 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 DateEnter 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 DateSelect 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 CodeExternal code for job type used in time record 
Clock -inClock-in date and time
Clock-out Clock-out date and time
Reg HrsTotal regular hours worked between clock-in and clock-out
OT HrsOvertime hours worked
DT HrsDouble-time hours worked
Total HrsTotal hours: Regular + overtime + double time 
Reg. Wages Wages based on pay rate and regular hours worked
OT WagesWages based on overtime pay rate for overtime hours worked
DT WagesWages based on double-time pay rate for double-time hours worked
Total Wages Total wages for all hours worked
Pay RateEmployee rate of pay 
Declared TipsTips declared
Net SalesNet sales
Gross SalesGross 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-inClock-in date and time
Clock-outClock-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 ByName of user that performed the time record adjustment 
ReasonAdjustment reason (configure in Adjustments in ECM)
Date/Time Adj.Date and time adjustment was performed
Record DeletedShows if a record was deleted (Yes/No)
AcknowledgmentStatus 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 Records: Acknowledge Adjustments 

Time Records Adjustments report