Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.
Info
titleOptional 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. 

...

  • Select Time Record Details from the list of of reports 

...

  • Select report options

Image Added

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 

Image Modified

...

Show deleted records

...

 The deleted time records are shown with a strikethrough on the values

Image Modified

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

Image Added

  • Use the right-facing caret to expand/collapse each level 

Image Modified

...

Image Removed

  • 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. 

Image Removed

Report Fields

Image Added

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

Image Modified

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

Image Added


  • 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. 

Image Added


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. 

...