Hours Reports

From sbv.wiki
Jump to: navigation, search

Approaching Overtime

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 Sun-Sat). 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. If your OT period is mid-week to mid-week then the Date Range on the report should be set accordingly.

(This report requires the OT pay types to be set in configuration as an Overtime Type).

Approaching Overtime (Excel)

This is the same as the Approaching Overtime report, but in an Excel format.

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

A summary of each employee per pay period, with productive (worked) and non-productive (unworked) hours separated.

Employees With Hours

A listing of employee names that have hours in the selected date range. Also provides a count of employees based on their gender.

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)

Displays employees that worked and were paid more than their daily hours in a day. This report is based on paid hours and ignores punched time.

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.

Payroll Hours Summary (File)

Excel based summary of payroll hours using a file as the template. This is used to get hours into an excel file that has other information pre filled (formulas, budget totals, custom formatting). Contact SBV to get a sample template. The template uses name-ranges to identify which cells to fill in ("Hours"), and which cells are used for filtering ("PayTypes" and "Department"). All 3 of these are required.

The name and location for the template should be entered on the Options tab. When the report is run it will display a copy of the template file with Hours from the software added to it.

The software can also populate multiple sheets in the same Excel file.

Payroll Hours Summary (Folder)

This is the same as the Payroll Hours Summary (File) report but will populate all Excel files in a designated folder. The name of the folder should be "PayrollSummary" and should be located in the Time & Attendance program directory (in the TA folder).

Total Hours Detail

Summarized hours by employee with group totals. This report uses Pay Type Tags (Configuration/Schedule/Pay types/Pay Type Tag) for the hours.

See Also