Time Worked |
  
|
Time Worked |
|
Time & Attendance > Reports - Time & Attendance > Time Worked
The Time Worked Report shows detailed time information for employees who worked during a specified time period.
The following information is included on the report: Keep in mind that the information available is contingent upon the information we poll for your enterprise.
oEmployee Name
oRegular Hours
oRegular Rate
oRegular Amount
oService Charges Paid
oCash Tips
oCredit Card Tips Paid
oCredit Card Tips Withheld
oTotal Sales
oEmployee ID
oPOS Code
oJob
oOvertime Hours
oOvertime Rate
oOvertime Amount
oService Charges Withheld
oPercent of Cash Sales
oPercent of Credit Card Sales
oCash Sales
oCredit Card Sales
1.Fill in the date range for the report.
2.Select the appropriate report options.
3.To open the report in a new window, check the Open in a new window checkbox.
4.Click the Run Report button.
Several options are available for filtering the report. The only required fields are the date range fields.
You can further restrict the data on the report by choosing to populate any or a combination of the following fields:
To select a specific employee, click on the magnifying glass icon and either begin typing a name or scroll through the list to find them. Once located, highlight the name and click the OK button. |
|
To restrict the report to one job, select it from the drop-down. |
|
To restrict the report to one entity, select it from the drop-down. |
|
If you have established store groups and you want to restrict the report to a store group, select it from the drop-down. |
|
If you have established two store groups and you want to restrict the report by this field, select the store group from the drop-down. |
|
You may elect to change the sort order of the report by employee ID, employee POS code or employee name. The default is by employee ID. |
|
Regular Hours Under |
If you would like to see data for employees who have regular hours under a specific amount of time, fill in the time for this field. |
Regular Hours Over |
If you would like to see data for employees who have regular hours over a specific amount of time, fill in the time for this field. |
Overtime Hours Under |
If you would like to see data for employees who have overtime hours under a specific amount of time, fill in the time for this field. |
Overtime Hours Over |
If you would like to see data for employees who have overtime hours over a specific amount of time, fill in the time for this field. |
Total Hours Under |
If you would like to see data for employees who have total hours under a specific amount of time, fill in the time for this field. |
Total Hours Over |
If you would like to see data for employees who have total hours over a specific amount of time, fill in the time for this field. |
Show Job Details |
To expand the report to include job details, check the Show Jobs Details check box. |
Show Shift Details |
To expand the report to include shift details, check the Show Shift Details check box. |
Exclude Inactive Employees |
To remove inactive employees from the results, check this box. |
Note that you can click on any employee name to filter the report to only that employee.
If you run the report with the Show Job Details box checked, you can also isolate the data for any job of a specific employee by clicking on the job name.
|
|
If after running the report, you want to change the criteria, click on the downward pointing arrow in the upper left of your screen and redefine the options.
For information on the report icons and how to print or export the report, please visit the Report Icons section under Tools.
1.Did you create a Time Worked Report to include shift details but see that there is overtime reported in an odd place? For instance, if your entity has an active weekly overtime rule where employees begin accruing overtime after working 40 hours in a workweek and you see overtime hours reported in the middle of the week, but not the end toward the end of the week.
oKeep in mind that this report allows you to select any date range. The range you set in the report options may not correspond to the workweek established for your entity. To match the report to a workweek, make sure to set the date range to match how the workweek is set up for your entity. To verify the start of the workweek, visit the Labor Definitions or Default Labor Definitions screen.
2.Want to reconcile your payroll export data with the Time Worked Report?
oKeep in mind that all payroll exports will exclude any inactive employees. Therefore, if you run the Time Worked Report with a date range that corresponds with the dates in your export, check the Exclude Inactive Employees check box to remove inactive employees from the report and compare the figures to the information in your export data.
3.Is the Regular Rate different than what you expected to see? Did the employee work a job with a wage less than the minimum wage for the entity? Did they make enough in tips to meet minimum wage? If not, their wage may have been adjusted. For more information, please see the Minimum Wage and Tips information in the Concepts section.
4.Is the Overtime Rate different than what you expected to see? Did the employee work multiple jobs with different wages that are in the same wage group which is set to include weighted average overtime? If so, please see the Weighted Average Overtime information in the Concepts section.
5.Are tips or service charges missing? Are you importing into Daily Employee Totals on a weekly basis? If so, please check the Use Weekly Job Totals setting in Labor Definitions. This allows tips and service charge totals assigned to a date with no associated time punch to be included.
Send feedback on this topic.