Difference between revisions of "Hours Reports"
m (→Paragon Hours Export (Excel)) |
m (→Approaching Overtime (Excel)) |
||
| Line 5: | Line 5: | ||
===Approaching Overtime (Excel)=== | ===Approaching Overtime (Excel)=== | ||
| + | |||
| + | Displays employees that are within one shift of reaching period overtime (if given another shift, will get paid overtime on that shift). This report can be used to see which employees should not be asked for another shift as it will incur OT. | ||
| + | |||
| + | Date Range should be set to Current Week (if paid weekly OT). This report will usually be empty at the start of the week (as no employee has yet worked enough shifts to get close to overtime). At the end of the week it will usually include everyone who worked the full week. | ||
===Employee Hours=== | ===Employee Hours=== | ||
Revision as of 14:49, 16 August 2017
Contents
- 1 Approaching Overtime
- 2 Approaching Overtime (Excel)
- 3 Employee Hours
- 4 Employee Productive / Non-Productive Hours
- 5 Employees With Hours
- 6 Hours Analysis Data
- 7 Hours Pivot Grid
- 8 Hours Summary (Excel)
- 9 Long Shift (Excel)
- 10 No Hours
- 11 Payroll Hours Summary (File)
- 12 Payroll Hours Summary (Folder)
- 13 Total Hours Detail
- 14 See Also
Approaching Overtime
Approaching Overtime (Excel)
Displays employees that are within one shift of reaching period overtime (if given another shift, will get paid overtime on that shift). This report can be used to see which employees should not be asked for another shift as it will incur OT.
Date Range should be set to Current Week (if paid weekly OT). This report will usually be empty at the start of the week (as no employee has yet worked enough shifts to get close to overtime). At the end of the week it will usually include everyone who worked the full week.
Employee Hours
Displays the hour totals by pay type with a total per employee. There are many options in this report. You can break out the hour totals by shift and labor level, filter by pay type, and summarize by the payroll pay type. If you want an hours summary for key entry into a payroll system, then this is the best report to use.
Employee Productive / Non-Productive Hours
Employees With Hours
Hours Analysis Data
Provides row based hours data in Excel format. The fields include the employee ID, employee name, pay date, shift, labor levels, pay type and the number of hours. The data can be used in Excel as the data source for pivot tables or charts. It can also be used by other external systems for import or analysis.
Hours Pivot Grid
Allows you to analyze the hours data using a built-in pivot grid.
See Pivot Grid for more detail.
Hours Summary (Excel)
Displays total hours by pay type with additional options to break out the hours by shift and labor level. This report is commonly used as a comparison to the hours imported into a payroll software.
Long Shift (Excel)
No Hours
Display employees that have no hours within the specified date range. This may be an indication that the employee is no longer active, or is not working and requires payment for non-worked time such as vacation.
