Salaries summary

This widget aims to represent the average salary of your employees, compared depending on several criteria:

• Gender: Determines what is the average salary of your Male/Female employees
• Age range: Determines the average salaries of your employees depending on their age
• Job title: Determines the average salaries of your employees depending on their title in your organization

Calculation 

The widget displays data based on your processed payroll: it does not include employees for whom payroll has never been processed, like new employees.

If some of your employees are paid on a hourly basis while some other are paid on an hourly basis, the widget is going to recalculate the corresponding salaries so that they will be compared on an equivalent basis. For example, if you have only one employee which is paid 70,000 AUD annually, and you want to represent your Workforce summary on an Hourly basis, the average hourly salary in your company will be:

average hourly salary = 70,000 AUD / ( 52 * 38 ) = 35.43 AUD

38 is here taken as the default number of hours worked per week, except if you have specified it in your HR application.

If then you have a second employee which is paid on an hourly basis, 30.00 AUD per hour, 25 hours per week, and you want to represent the average yearly salary in your company, the calculation would be:

average yearly salary = (70,000 AUD + ( 25 * 52 * 30.00 AUD )) / 2 = 54,500.00 AUD

Settings 

The workforce can be filtered on the chart following 3 different criteria: gender, age range, or job title.

You can also chose on which period interval you want your workforce calculations to be based on: Yearly, Monthly, Weekly, Hourly.

You can find in the employee tab (left panel), at the top of your screen, a summary of your workforce cost for the on going fiscal year. 

Noticeable differences with the Impac!™ widget

Impac!™ widget allows you to filter your data with a different level of granularity, so you need to make sure the same filters are applied to view consistent data between reporting in Quickbooks QuickBooks Online and Impac!™

In OrangeHRM, you can check per employee each details, by going in the PIM (Personal Information Management) tab, select each employee and click on the salary menu in the left menu.

Noticeable differences with the Impac!™ widget

There is no consolidated report available in OrangeHRM with a summary of workforce cost.