Versions Compared

Key

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

The Time Records report reports employee hours, wages, tips and sales information. 

  • By default, records are shown expanded to show detailed information for each employee.Columns can be sorted in ascending or descending order. 
  • 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. 

Operation

The Time Records report can be run by site(s), site group(s), job(s)

...

, start and end date and by employee name(s)

  • 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 names selected
  • Click Refresh Report to run the report

Image RemovedImage Added

The right-facing caret above each employee's records can be used to expand or collapse the records as needed. 

...

Site(s), Group(s), Job(s), Business DateSelect site(s), site group(s) and job(s); specify date range for report 
2
Name

Select employee name(s) from list to show report for name(s) selected 

Image Added

Site #Site number
3
Emp #Employee number
4
Name Employee name
5
Job Job(s) assigned to employee
6
Job External CodeExternal code for job type used in time record 
7
Labor Cat Labor Category (if set in ECM)
8
Clock
In
-inClock-in date and time
9
Clock
Out 
-out Clock-out date and time
10
Reg HrsTotal regular hours worked between clock-in and clock-out
11
OT HrsOvertime hours worked
12
DT HrsDouble-time hours worked
13
Total HrsTotal hours: Regular + overtime + double time 
14
Reg. Wages Wages based on pay rate and regular hours worked
15
OT WagesWages based on overtime pay rate for overtime hours worked
16
DT WagesWages based on double-time pay rate for double-time hours worked
17
Total Wages Total wages for all hours worked
18
Pay RateEmployee rate of pay 
19
Declared TipsTips declared
20
Net SalesNet sales
21
Gross SalesGross sales
22
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


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. 

...