Developing an automated and efficient validation & publication pipeline in GitLab
Zorginstituut Nederland
WPM reporting with reliable data
We bring together leasing, expense claims and travel data, check them and make submission repeatable, as with the validation pipeline for Zorginstituut Nederland.
For Zorginstituut Nederland, we developed an automated and efficient validation and publication pipeline in GitLab
In the KIK-V programme, organisations in nursing home care are streamlining the exchange of accountability data, reducing the administrative burden on care providers. CI/CD pipelines enabled the project to scale more effectively and sustainably, with controlled releases of KIK-V products.
Why do we have to gather all the kilometres again each year for WPM reporting?
The kilometres are recorded in lease records, expense claims, payroll records and sometimes an employee survey. Connect and check these sources once, and you can report figures calculated in the same way each year.
A WPM dataset brings together company cars, mobility services, expense claims and commuting
Company cars
Annual mileage from lease or fleet records, by fuel type. If only litres or kWh are available, convert them using the RVO table.
Mobility services and expense claims
Mileage from mobility providers and journeys claimed as expenses. For public transport claims, the form asks for the total amount claimed.
Commuting
Data from the travel expenses policy or an employee survey, broken down by mode of transport. For Zorginstituut Nederland, we built a pipeline that validates and publishes the data.
Checks and a dashboard
Checks for missing and implausible values, a comparison with the previous year and a dashboard showing mileage by category.
Connect the sources once, then follow the same process every year
-
Map the sources
Which systems hold mileage data, who owns them and where a survey or conversion is needed.
-
Connect and check
Bring the data together by mode of transport and fuel, with checks and an explanation for each decision.
-
Submit and repeat
The totals ready for the RVO form, a dashboard and a set process for next year.
Do we need a data project, or is the RVO worksheet enough for our reporting?
A good fit if
You have 100 or more employees, your mileage data is spread across several systems or locations, and you want to submit well-supported figures consistently each year.
Not a good fit if
You have a small fleet and a straightforward travel expenses policy. In that case, the RVO worksheet and survey are often enough. We’re also not the right people to turn to for legal or tax advice.
What determines the scope
The number of data sources and administrative systems, whether a survey is needed, how well modes of transport and fuel types are currently recorded, and whether you also want a dashboard.
Will our organisation still be subject to the requirement?
RVO reports that the ministry wants to raise the threshold to 250 employees, if the government decides to do so. Until a decision is made, RVO recommends collecting data for 2026 as well.
The RVO worksheet, separate exports or a linked dataset: how do you collect the kilometres?
The RVO worksheet
Choose this if you have few data sources. The worksheet includes an optional employee survey and uses the responses to calculate the figures you need to report.
Separate exports from each system
Choose this if your leasing, expense claims and payroll systems each provide a usable export, and one designated colleague combines them annually and documents the decisions made.
A linked dataset
Choose this if you need to include multiple systems and locations. Our advice: document your sources and checks once, so next year is mainly a matter of refreshing the data.
We turn scattered administrative records into one dataset you can substantiate
Data Science Lab has worked with data and AI since 2016, from data platforms to dashboards. For Zorginstituut Nederland, we developed an automated validation and publication pipeline. We are a Databricks Partner and Microsoft Partner.
Your leasing arrangements, expense claims and travel expense reimbursements form the basis of our first conversation
Stef Stoelwinder
Business DevelopmentStef is your first point of contact. In our first conversation, we’ll discuss which systems hold mileage data, what’s missing and how you can provide the data in a repeatable way.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
Where can you find the mileage data for WPM reporting?
Tell us what arrangements and systems you have. We’ll reply by email or arrange an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
The work-related passenger mobility reporting obligation comes from the Decree on CO2 Reduction in Work-Related Passenger Mobility. Organisations with 100 or more employees that are registered with the Dutch Chamber of Commerce (KvK) report annually on their employees’ business travel and commuting.
We help with the data as part of data governance: sources, checks and documentation. If you have questions about whether or how the obligation applies to you, contact RVO or your legal adviser.
According to RVO, someone counts if their contract guarantees 20 or more hours of paid work per month. Agency workers, seconded workers and self-employed contractors do not count. Since 2025, RVO has assessed employee numbers on 1 January each year.
If you are unsure whether your organisation is covered, ask RVO.
For each calendar year, you need to submit the total kilometres travelled by all your employees combined, broken down by mode of transport and fuel: petrol, diesel, hybrid or electric cars; motorcycles; mopeds; cycling or walking; and public transport. You report these separately for company cars, mobility services, expense claims and commuting.
This covers journeys that start or end in the Netherlands. Air travel is excluded.
You submit it through RVO’s online form, using eHerkenning at a minimum of level eH2+ and authorisation for RVO services. In 2026, organisations with 100 or more employees had to report on 2025 before 1 July.
You do not need to calculate CO2 emissions yourself; the form does that. A regional environmental authority checks whether you have reported and whether the data is credible.
If your records only contain litres of fuel purchased or kWh charged, you can convert these into annual kilometres using the table in RVO’s guidance.
Document which conversion you use and for which cars. That way, next year’s figures will be calculated in the same way, and you can explain them if the regional environmental authority asks.
According to RVO, you do not: you can probably get much of the data from your existing records, sometimes with small adjustments. For commuting, you can use an employee survey.
We connect these sources and apply checks based on our work on data quality: missing journeys, duplicate expense claims and implausible distances.
Yes. We use the same dataset to build a dashboard showing kilometres by mode of transport, fuel and category, and changes year by year. This lets you see where your mobility policy makes a difference, independently of the reporting deadline.
Read more about Power BI dashboards.
RVO reports that the Ministry of Infrastructure and Water Management wants to amend the decree so that organisations with fewer than 250 employees no longer have to report. This will only happen if the government approves it, in which case it will apply retroactively from 1 January 2026.
For 2025, the obligation applied from 100 employees. Until a decision is made, RVO advises organisations to continue collecting data for 2026.