Province of South Holland Develops New System for the Financial Supervision Department
Results
Eliminated Excel-based documents and processes
Automated large datastreams
Intuitive data entry
Financially healthy
Municipalities and partnered initiatives are responsible for their own financial management. The task of the Financial Supervision team of the province of South Holland is to supervise these organizations within the province with the aim of promoting a healthy financial ecosystem in the province.
“The EsperantoXL team thought along with us and provided valuable suggestions. In the end they offered even more than we expected.”
An aging system
Financial supervision is not a process where reliable off the shelf application options (such as an accounting package or a payroll system) are available. The process is simply too specific for that.
The Financial Supervision Department of the province of South Holland worked with an old system that did not optimally match the work processes. In addition, this system was not very user-friendly and it made transferring data much harder. This resulted in many manual actions that had to be performed across many separate Excel files.
Large amounts of data
The province wanted to develop an app for these specific business processes for which no standard packages existed. The new system would be built with Betty Blocks. EsperantoXL’s team started building the desired parts and looked critically at where there were possible areas for improvement.
One of the major challenges was that a large number of documents and data needed to be processed by the system. The Financial Supervision department works with many snapshots such as annual accounts and budgets of municipalities and joint regulations. This requires a lot of data to be entered manually. It was EsperantoXL's job to find a way in which entering and retyping would be less time-consuming and error-prone.
Development facts
Together with Betty Blocks and implementation partner EsperantoXL, the province of South Holland was able to set up a future-proof system at a rapid pace.
Development time
2 months
Development hours
200
Building blocks used
240
Digital card index
Supervisors can log in to the new system that EsperantoXL has built. On the municipal dashboard, supervisors can see an overview of their municipalities and joint regulations. They can then quickly navigate to any required documents at different levels in the system. The documents are organized like a large card catalog and numbers can be entered and managed by category. The structure of the new system is intuitive and data entry has become easier. Within the system, calculations are carried out for statutory key figures, but also for determining a risk profile.
In the back-office, the system offers new possibilities for the province. Unlike in the past, connections can be drawn and trends established by the multi-year recording and data analysis. This allows the province to draw up reports and see for each municipality how this is developing over time. This makes supervision easier for the province of South Holland.
Developed applications
Financial supervision
A self-built system that precisely meets the needs of the province
Overarching system
A system that can be used by several provinces and municipalities
Automation
Complex calculations for statutory key figures and determine risk profile
A comprehensive system for provinces
The system can also be applied to other provinces. The province of Gelderland was also looking for a new system and heard about the project from the province of South Holland. Gelderland was already involved in the development phase and was present at the demos. As a result, EsperantoXL has been able to develop a system that connects to both provinces.
Several provinces have already indicated that they are interested and the system may even be used throughout the Netherlands. The provinces want more cooperation and this IT project is a good example of joining forces and looking for a joint solution.