For the salary statistics of the Confederation of Finnish Industries (EK), the data is compiled from Netvisor by combining different reports into a csv file. Some of the data to be reported requires manual processing before the data is in a reportable form, and reporting is done by combining search results from different reports. We recommend allocating sufficient time to compile the data for the statistics.

CONTENT

EK's salary inquiries are submitted through EK's service portal. The data can either be filled in on the form in the service portal or provided using the csv data model template in the service portal. For more information on submitting data, please contact EK.

Please note that EK's data model templates are industry-specific, and each sector has its own csv data model template. You can download the correct data model template and read the detailed data content instructions here: instructions for responding to the September salary inquiry

How can I get all the information I need for the EK statistics?

Extract the data required for the statistics in Netvisor from the working hours report, pay period statistics, and employee listing as follows:

  • Report information on the number of hours from the working hours reports.
  • Report monetary salary information from the pay period statistics.
  • Extract information on employees and employment relationships from the employee listing.

Not all data fields required for statistics are directly available from Netvisor, but employee additional information fields can be created in the employee basic data for this purpose, and these can be reported via the employee listing after being added. Please note that some data (e.g. gender) is obtained from Netvisor in text form, but EK requires it in numerical form (e.g. male = 1, female = 2). Use Excel's "Find and Replace" function to convert the data. If all required fields are not directly available, create employee additional information fields in the employee basic data.

Creating an additional information field

You can perform this function by selecting Pay > Settings > Payroll settings > Employee additional information fields > New additional information field

  1. Enter the name of the additional information field.
  2. Select the location as “employee information: basic data”.
  3. Save the data.
  4. Go to the employee basic data and enter the desired value or text in the created field.

Tip! It is advisable to enter the value directly in the employee additional information field in the numerical form to be given to the EK statistics without extra text, so that filling in the statistics is faster, as there is no need to remove extra characters from the csv file cell.

Utilizing the working hours report

You can perform this function by selecting Working hours > Working hours > Working hours reports

  1. Select the desired time period and salary model for the report.
  2. Select the record types to be reported.
  3. Save the retrieved report as an Excel file, which you can edit as needed.

Utilizing the pay period statistics

The pay period statistics can be utilized for reporting paid salaries and fringe benefits. You can perform this function by selecting Pay > Reports > Payroll reports

  1. Select the report format as pay period statistics.
  2. Select the desired time period and salary model.
  3. Select the salary types to be reported. Multiple report searches need to be done to fill in EK's statistics, as the reporting accuracy may in some cases only concern one reportable salary type.
  4. Save the retrieved report as an Excel file, which you can edit as needed.

Utilizing the employee listing

You can perform this function by selecting Pay > Personnel > Employee listing

  1. Open the “Show columns” dropdown menu.
  2. Select the employee-specific data to be displayed and "Update view".
  3. Save the selected data as an Excel file.

Frequently asked questions

Where can I find information on the number of hours?
The number of hours is reported from Netvisor's working hours reports.

What should I do if the data obtained from Netvisor is in text form, but EK requires numbers?
You can use Excel's find and replace function to convert, for example, the text "male" to the number 1 and the text "female" to the number 2.

How can I get data for the EK statistics if there is no ready-made field for it in Netvisor?
Create a new additional information field in the payroll settings in the employee basic data and report it via the employee listing.

Why do I need to perform multiple searches from the pay period statistics?
Because EK's reporting accuracy may require only a specific salary type at a time, multiple searches help in compiling the data accurately.

Keywords: EK statistics, Confederation of Finnish Industries, salary statistics, csv data model, additional information field, working hours report, pay period statistics, employee listing, payroll reports.

This article has been translated using an AI-based translation tool. The contents or wording of these instructions may differ from those in other instructions or in the software.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.