Payroll analysis¶
The Payroll Analysis report displays the total net wage for the company, for the last 365 days. This report allows companies to view their payroll costs and identify any trends.
To view the Payroll Analysis report, navigate to .
Net Wage is the default metric displayed in the report, but other measures can be displayed if desired, such as gross wage or days of paid time off. Click the Measures button to view a drop-down menu of other metrics to display. Click on the desired measure to display the results.
View multiple metrics¶
It is possible to view multiple metrics at one time by viewing the report in the pivot table view. This can aid management to determine other trends, such as which departments do not take time off, or which departments have the highest payroll costs.
Bemerkung
Only one measure is able to be displayed in the default Graph view. Multiple measures are only possible in the Pivot view.
To display the data in a pivot table, click on the Pivot button.
The default information displayed includes the number of payslips (# Payslip), the number of Days of Paid Time Off and Days of Unpaid Time Off, along with the Net Wage and Gross Wage. All the information is organized by department.
To display more information on the report, click the Measures button to reveal a drop-down menu. Click on any metric to display it on the pivot table.
Use case: comparing payroll costs¶
Managers can compare payroll costs, and determine which departments have raised their payroll costs, either by hiring more employees, or by raising salaries.
To compare previous periods of time, first view the Payroll Analysis report in a pivot table. Then, click the (Toggle Search Panel) icon in the search bar, and click Start Date to reveal a list of time periods (months, quarters, and years). Click on a desired time period, and a Comparison section appears in the search bar. Click on one of the two available options, either Start Date: Previous Period, or Start Date: Previous Year.
The report now displays three columns of information for every displayed measure: a column for the current time period, a column for the previous time period, and a Variation column, which displays the difference between the two time periods in a color-coded percentage (green for increases, red for decreases.)
Example
In this example, the data shows an overall increase in the number of payslips. Since the company pays all employees every two weeks, an increase in the number of payslips (# Payslips) means that more employees were hired, in this example, a 500% increase.
Additionally, both the Net Wage and Gross Wage increased. The department RD US showed the largest growth, with both metrics increasing by approximately 350%.
Siehe auch