Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

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.

Operation

The Time Records report can be run by site(s), site group(s), job(s) and start and end date. 

  • 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 dropddown list
  • Business Start/End Date - Enter or select date range from the calendar control
  • Click Refresh Report to run the report

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

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


References:
State of California - Department of Industrial Relations FAQhttps://www.dir.ca.gov/dlse/faq_overtime.htm 




  • No labels