Table of Contents

Create salary and employee statistics

SwissSalary provides various salary and employee reports. Select the report that fits your question, and use a consistent reference date and traceable filters.

Prerequisites

  • The payroll runs for the reporting period are posted, or the population as of the reference date is stable.
  • Filter criteria such as active status, department, and allocation group are agreed for the business purpose.

Plan the report

Before you start, define:

  • the business Reference Date or period;
  • the employee population;
  • allocation groups, departments, or functions;
  • the salary base and level of detail;
  • the output format and storage location.
Wichtig

A report with Only Active Employees can contain a different population than a report based on a reference date. Check the filter logic before comparing results.

Create Salary Statistics

  1. Open Salary Statistics.
  2. Enter the Reference Date.
  3. Under Salary Base, select Annual Salary or Monthly Salary.
  4. Under Statistics Type, select Statistics or Salary Class Employee Card.
  5. If needed, select a Statistics Group.
  6. Specify whether Print Details is enabled.
  7. Check the age groups, and change their limits only in accordance with a documented reporting concept.
  8. If needed, filter by gender or Employment Date for Payroll.

The report shows, among other values, the number of employees, total payroll, and average salary by the selected groups.

Check the average or base salary

Use Average Salary to analyze salary as of a Reference Date based on a selected salary type. Specify whether to include the 13th Month Salary.

Use Base Salary to:

  1. set a Reference Date;
  2. report on All Employees or employees with Employee Salary < Base Salary;
  3. show up to two additional choice fields;
  4. include only active employees;
  5. export the result to Excel.

Create employee statistics

Select the report that fits your question:

Report Typical use
Employee Statistics A4L Analyze assignments to a configured statistic and group, and select up to four information columns and detailed output.
Age Distribution Analyze employees by age group as of a Reference Date, and select the detail level Summary, Function, or Employee.
Turnover Rate Group employment starts and ends within a period by department, posting group, salary class, function, or place of work.

For Turnover Rate, also set Period Counting and Calculation Type. Don't change these options between reports that you want to compare.

Check whether the result is plausible

Check:

  1. the number of employees against an independent employee list;
  2. employment starts and ends around the reference date;
  3. employment percentages or FTE if the report shows them;
  4. the salary base and inclusion of the 13th monthly salary;
  5. grouping and blank statistics assignments;
  6. the total payroll against an appropriate Payroll Register or Salary Entries report.
Hinweis

Different reports answer different questions. A difference isn't automatically an error when the reference date, active filter, grouping, or salary base differs.

Store the report so that it can be reproduced

Store the following information with the output:

  • report name;
  • creation date;
  • reference date or period;
  • all filters;
  • selected options;
  • responsible person;
  • explanation of significant differences.

Use Export to Excel only for reports that provide this option. Protect exported employee data in accordance with your permission and data-protection policy.

Good to know

  • You enable Only Active Employees and expect the same population as in a report based solely on a reference date—the totals differ.
  • You immediately treat differences between reports as errors—often only the filters, base, or grouping differs.
  • You don't store the reference date, filters, and salary base with the report—the result can't be reproduced later.

See also