For the annual salary statistics of the Confederation of Finnish Industries, it is possible to compile a csv file of the records to be reported from Netvisor. 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.

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

CONTENT

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

You can extract the necessary data for statistics from Netvisor using the working hours report, pay period statistics, and employee listing.

Information regarding the number of hours can be reported from the working hours reports, monetary salary information can be reported from the pay period statistics, and information about employees and employment relationships can be found in the employee listing. Not all data fields required for statistics are directly available from Netvisor, but additional information fields can be created in the employee's basic data, which can be reported through the employee listing after being added.

Please note that some data is obtained from Netvisor in text form in a csv file, but EK requires the data to be reported in numerical form. You can use Excel's find and replace function to convert the data into the format required by EK. For example, gender information is obtained from Netvisor in text form. This text form should be replaced with a numerical value for EK's inquiry (male = 1 and female = 2).

Creating an additional information field

New employee additional information fields can be created from the payroll settings. Fill in the name of the additional information field and select the location as “employee information: basic data”.  (Pay > Settings > Payroll settings > Employee additional information fields > New additional information field)

After saving, the desired value/text can be filled in the created additional information field in the employee's basic data.

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

The working hours report can be utilized for reporting the number of hours. Select the desired time period, salary model, and record types to be reported for the working hours report. The retrieved report can be saved as an Excel file, which can be edited as needed. (Working hours > Working hours > Working hours reports)

Utilizing the pay period statistics

The pay period statistics can be utilized for reporting paid salaries and fringe benefits.

Select the report format as pay period statistics, then choose the desired time period, salary model, and 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. The retrieved report can be saved as an Excel file, which can be edited as needed. (Pay > Reports > Payroll reports)

Utilizing the employee listing

The employee listing can be utilized for reporting employee-specific information. Select the “Show columns” dropdown menu from the view to display employee-specific information. After this, the selected information to be displayed on the view can be saved as an Excel file. (Pay > Personnel > Employee listing)

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.