Department Summary Report

Description:

This report allows you to view a summary of the number of “Regular,” “Overtime” and “Total” hours worked in each department. Select the “Pay Information” option to view the dollar amounts spent in each department based on employee pay rates and the number of hours worked.

Report Criteria:

The Report Criteria screen opens when you click on the report name from the main "Reports" section of the software.  This screen is where you tell the system what data you would like it to report on.

• The Time Reports field allows you to select a different report from the drop-down menu.

• Put a check mark in the Launch Report in Separate Window box if you would like the report to open in a new web browser window.  With this option de-selected the report is displayed directly below the Report Criteria section of the screen.

• Use the Date Range fields to enter the range of days for which you would like to view changes to time card data.  Click on the icons to select the dates from a calendar.

• The Worked Department field allows you to select which departments will be included in this report.  By default all departments are included.  Click on the down arrow icon located to the right of the Show Departments header to select departments.

1. All of your departments are listed in the Unused Departments box.  The Viewed Departments box lists the departments that will be reported on.  Select the desired departments from the Unused Departments box and click on the [>>] icon to assign them to the report.  The selected department levels are moved to the Viewed Departments box.

2. To unassign departments from a report, select the desired department levels in the Viewed Departments box and click on the [<<] icon.  The selected departments are moved to the Unused Departments box.
   Note: If you leave the Viewed Departments box empty, the report will display all departments.

• Use the Sort by field to select how the information on the report will be sorted.  Two sort levels can be specified.
  Example: "Department" is selected in the first field, and "Department Number" is selected in the second.  The report will be sorted first by the department level that the employees are assigned to, and then numerically by department number.

• The Options section allows you to select how much information is to be displayed on this report.  Put a check mark in the box next to each type of information that you would like the report to display.

Click on the [DISPLAY REPORT] icon located directly below the Options section of the screen to generate the report.

Report Output:

The report is separated into columns.  The header at the top of the report lists the type of information that is displayed in the column below.

Note: The report output depends greatly upon what you selected in the Options section of the Report Criteria screen.

• The Department column displays the name of the department that is being reported on.

• The Department # column displays the number that the displayed department level is assigned to in the software.  This is also the number that employees use to punch in to and out from this department at the time clock.

• The Regular Hours column displays the total number of regular hours assigned to this department level for the specified date range.

• The OT 1-4 columns display the total number of overtime hours for each overtime level assigned to this department for the specified date range.

• The Total Hours column displays the total number of regular and overtime hours assigned to this department for the specified date range.

• The Reg Pay column displays the dollar amount of regular hours "paid out" to employees who have worked this department level.
  Note: This figure is calculated from the number of hours assigned to this department level, and the "regular" pay rate of the applicable employees.

• The OT 1-4 Pay columns display the dollar amount of overtime hours "paid out" to employees for each overtime level.
  Note: This figure is calculated from the number of "overtime" hours assigned to this department level, and the pay rate awarded to the applicable employees as defined by the overtime policies that they are assigned to.

• The Total Pay column displays the total dollar amount "paid out" to employees who have worked this department level.

Click on the [SAVE] icon in the upper right-hand corner of the screen to save this report to a separate file.  Click on the [PRINT] icon to print the report.