Payroll Dashboard
The Payroll Dashboard captures data such as Total Payroll Per Year, Payroll for Current Week, Payroll by Category, and OT Payroll, among other figures. As with other dashboards, the Payroll Dashboard includes filters and indicator widgets to assist in obtaining specific information.
This section covers the Payroll Dashboard in its entirety from key terms and formulas to descriptions and functionality of each widget section.
The four graph widgets at the bottom illustrate trends for Payroll by Category, Payroll by Discipline, Overtime Payroll Percentage by Contract Type, and the Overtime Payroll Percentage by Coordinator. Clicking on any segment of these graphs provides a summary of selected point. All graphs in this section are drillable.
In the Payroll Dashboard, the indicator numbers correspond to the selected Office and Batch Date. In this dashboard, the Average Pay Rate (Non-Skilled and Skilled) indicators are drillable.
At the top, the summary widget of the Payroll Dashboard shows a weekly payroll trend for the past 6 months by Office. This line graph shows a comparison between offices. Hovering over any part of the coordinates in the graph displays a pop-out window indicating information for that precise point.
Right underneath, to the left, the line graph indicates the weekly percentage of the Overtime Total Payroll Amount and Overtime Hours for the past quarter. The stack graph to the right, provides a summary of Current Week Payroll Amount versus Previous Payroll Week Amount for the past quarter. Clicking on any segment of these graphs provides a summary of the selected point.
The following tables describe key terms, indicator definitions, and formulas used in context with the Payroll Dashboard.
| KPIs as defined in the Payroll Dashboard: | |
|---|---|
|
Total Payroll |
Total Payroll for selected Office and Batch Date | Total Hours for selections |
|
Regular Hours |
Regular Payroll for selected Office and Batch Date | Regular Hours for selections |
|
OT Hours |
OT Payroll for selected Office and Batch Date |OT Hours for selections |
|
Non-Skilled Average Pay Rate |
Average Non-Skilled Regular Pay Rate for selected Office and Batch Date |Average Non-Skilled OT Pay Rate for selections |
|
Skilled Average Pay Rate |
Average Skilled Regular Pay Rate for selected Office and Batch Date | Average Skilled OT Pay Rate for selections |
| Formulas used to calculate the various widgets in Payroll Dashboard: | |
|---|---|
|
Non-Skilled Average Pay Rate |
Total Regular Payroll Amount divided by the Total Regular Hours of all Non-Skilled Visits |
|
Skilled Average Pay Rate |
Total Regular Payroll Amount divided by the Total Regular Hours for all Skilled Visits |
|
Non-Skilled OT Average Pay Rate |
Total OT Payroll Amount divided by the Total OT Hours for all Non-Skilled Visits |
|
Skilled OT Average Pay Rate |
Total OT Payroll Amount divided by the Total OT Hours for all Skilled Visits |
|
OT Payroll Percentage |
Total OT Payroll Amount divided by the (Total OT Pay Amount + Total Regular Pay Amount + Total Holiday Pay Amount) |
|
OT Hour Percentage |
Total OT Payroll Hours divided by the (Total OT Hours + Total Regular Hours + Total Holiday Hours) |
| Key Terms as defined in the Payroll Dashboard | |
|---|---|
|
Total Payroll |
Total Paid Hours for a defined period |
|
Payroll for Current Week |
Total Payroll Amount for a defined period |
|
Payroll for Prior Week |
Total Payroll Amount for previous week |
|
Payroll Category |
Describes the type of Payroll: Visit, In-Service |
|
Holiday / OT Payroll/Hours |
Worked/Paid Hours outside of Regular Hours |
|
Regular Hours |
Paid Hours excluding OT/Holiday; paid at a regular rate |