Pay Breakdown Report

Description:

This report gives you a detailed breakdown of employee hours and pay.  The following information can be displayed for each hours total: Department, Worked Department, Date, Hours Type, Job, Task, Premium Pay Code, Category, Pay Rate, Regular and Overtime Hours, etc.

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 Employees field allows you to select which employees will be included in this report.  By default all employees are included.  Click on the down arrow icon located to the right of the Show Employees header to select employees.

    1. To view employees from a specific department only, select the desired department from the Department drop-down menu.

    2. All of your employees are listed in the Unused Employees box.  The Viewed Employees box lists the employees that will be reported on.  Select the desired employees from the Unused Employees box and click on the [>>] icon to assign them to the report.  The selected employee names are moved to the Viewed Employees box.

    3. To unassign employees from a report, select the desired employee names in the Viewed Employees box and click on the [<<] icon.  The selected employees are moved to the Unused Employees box.
      Note: If you leave the Viewed Employees box empty, the report will display all employees.

  • 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.

  • If you would like to view hours for a specific pay period type only (as in "Daily," "Weekly," "Bi-Weekly," etc.), make the desired selection from the Pay Period drop-down menu.

  • If you would like to view employees assigned to a specific supervisor only, make the desired selection from the Supervisor drop-down menu.

  • The Type field allows you to select the type of employee that you would like the report to include (as in "Full Time," "Part Time," "Seasonal," etc.).

  • 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 "Employee Name" is selected in the second.  The report will be sorted first by the department level that the employees are assigned to, and then alphabetically by employee name.

  • 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 Employee column displays the employee's full name.

  • The ID column displays the employee ID specified in the employee's profile.

  • The Card # column displays the card number that the employee uses to punch at the time clock.

  • The Department column displays the default department level that the employee is assigned to in their employee profile.

  • The Supervisor column displays the name of the supervisor that the employee is assigned to.

  • The W. Department column shows the department level that the displayed hours total is assigned to.  This setting will be different from the setting in the "Department" column if the employee has specified a department number at the time clock.

  • The Date column displays the date of the displayed hours and pay totals.

  • The Hour Type column displays the "type" of hours total (as in "Worked," "Absence," "Holiday," etc.).

  • The Job column displays the job that the displayed hours total is assigned to.

  • The Task column displays the task that the displayed hours total is assigned to.

  • If the hours total is assigned to a Premium Pay Code, the code is displayed in the Premium column.

  • The Category column displays the "type" of awarded hours (as in "Regular," "Overtime 1," "Overtime 2," etc.).

  • The Rate column displays the rate of pay that the employee receives for the above hours "Category."  If the displayed hours type is "Regular," the employee's base pay rate is displayed.  If the hours type is "Overtime," the figure is calculated accordingly, based on the applicable overtime settings.

  • The Hours column displays the total number of hours.

  • The Reg column displays the dollar amount that the employee has earned for working the number of hours shown.  This column is only used when the displayed hours are "Regular" hours.

  • The OT 1-4 columns display the dollar amount that the employee has earned for working the number of hours shown.  These columns are only used when the displayed hours are specified as the corresponding level of overtime.
    Example: If the Category field displays "Overtime 1," the dollar amount will be shown in the OT1 column.  If the hours category is "Overtime 2," the dollar amount will be shown in the OT2 column.

  • All hours and dollar amounts are totaled at the bottom of the report.

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.