XBRL Tool for Undertakings (T4U)

​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​Latest New​s​​​​

Bug fix release available for 2.1.0 taxonomy (VER 2017.01.31)

Date: 9th February 2017

A new bug fix release of the tool supporting the 2.1.0 taxonomy is now available for download: 

  • ClickOnce Setup: Full Solvency II Reporting supporting DPM and XBRL Taxonomy version 2.1.0
  • Standalone package for Full Solvency II available here
  • Release notes available here
  • User manual available here

Important Notes: 

  • This release should be used to generate reports using the 2.1.0 taxonomy only (with reference date Dec. 31st 2016 or later). For the 2.0.1 taxonomy please use the previous release.
  • Please check the list of known issues (updated on 9th March 2017)
  • Please find here the 2.1.0 Enumeration file

​For reporting of bugs or any other issues please use our mailbox: ToolForUndertakings@eiopa.europa.eu

Source Code Publication

The source code for the Tool for Undertakings has been made available on Github.

To request access please send an e-mail with subject "T4U source code request" and the following information to ToolForUndertakings@eiopa.europa.eu:

Please note that as indicated in the Terms and Conditions, the software is distributed without any warranty and EIOPA does not provide any technical support for the source code.

Meet the Market Events

T4U Meet the Market Event

​​Date: 30th May 2016 

Location: EIOPA, Westhafenplatz 1, 60327 Frankfurt am Main

​ ​
Objective
The aim of the workshop was to provide participants detailed technical information about the T4U. In addition, EIOPA collected feedback to better understand questions the market may have and whether alternative solutions are being developed by the industry. The event also offered participants the opportunity to meet and exchange views with EIOPA staff and its service providers.
 
Contents
Topics addressed included: 
•           Detailed information on the latest public release
•           In-depth technical presentations on the T4U’s software components
•           Q&A Session​
 
Target audience
Software suppliers and other market participants with an interest in using the T4U as a basis for their own software developments.
 
Find out more about the programme and presentations on our website​

Meet-the-Market Workshop

Date: 8 July 2015

Location: EIOPA, Westhafenplatz 1, 60327 Frankfurt am Main​

EIOPA will have to decommission the T4U after undertakings have conducted the first Solvency II reporting exercise in the second​​ half of 2016 due to EIOPA's budget restrictions (see roadmap​ below). EIOPA expects that market providers will be able to reuse and support the solutions developed by ​the T4U project and is therefore planning to make the tool available through an open source model.​

The aim of the workshop was to provide participants detailed technical information about the T4U. In addition, EIOPA was interested in collecting feedback to better understand questions the market may have. The event also offered participants the opportunity to meet and exchange views with EIOPA staff and its service providers.
  

​What is​ the XBRL Tool for Undertakings?

The objective of EIOPA's Tool for Undertakings project is to provide insurance firms with a simple and basic software tool to create and validate XBRL instances from Solvency II harmonized quantitative reporting templates.

The tool is oriented toward small and medium sized undertakings to create, edit, correct, complete and validate XBRL instance documents. It is designed to help firms without XBRL knowledge to implement Solvency II harmonized quantitative reporting in XBRL. In particular, the T4U aims to assist undertakings that might suffer from a lack of resources to create XBRL in time for the first submission. 

​The core functionalities of the T4U are:

  • Provide a user friendly interface for displaying Solvency II templates, 
  • Support manual data input and validation;
  • Create, read and validate XBRL reports;
  • Validate and view XBRL reports created by the tool using a third-party viewer and validator (Arelle);
  • Support simple export/import capabilities for Microsoft Excel (plain files).​
  • The tool is database-driven: Validations are implemented at database level (i.e. not based on XBRL assertions) built around a database with an architecture similar to CRDIV, and with structures to facilitate extensive data migrations.

​​​Roadmap​​

Current rel​​ease​​

9th February 2017 (VER 2017.01.31)​

Down​​load current T4U release (Full solvency II 2.1.0 taxonomy)​

Previous rel​​ease​​s

29th April 2016 (VER 2016.04.29)​

Down​​load previous T4U release (Full solvency II 2.0.1 taxonomy)​ 

18th April 2016 (VER 2016.04.18)​

​Download previous T4U release​ (Full solvency II 2.0.1 taxonomy)

29th February 2016 (VER 2016.02.29​)

​Download previous T4U release​ (Full solvency II 2.0.1 taxonomy)

Download previous T4U release (Preparatory phase version, 1.5.2.b and 1.5.2.c taxonomies)

2nd February 2016 (VER 2016.02.01)

​Download previous T4U release​ (Full solvency II 2.0.1 taxonomy)

Download previous T4U release (Preparatory phase version, 1.5.2.b and 1.5.2.c taxonomies)

28th August 2015​ (VER 2015.08.28)

Download previous Preparatory T4U release​​ (supporting DPM and XBRL Taxonomy versions 1.5.2.b and 1.5.2.c)

Upcoming rele​ases

Important: Due to budget restrictions EIOPA will have to decommission the T4U from the second half of 2017 after undertakings have conducted the first Solvency II reporting exercise. The Tool will not be updated to support the 2.2.0 or following taxonomies. EIOPA expects that market providers will be able to reuse and support the solutions developed by the T4U project and has made the tool available through an open source model.
 
Please consult the following announcements for further details:
 
July 8th 2016  Final release of the T4U
April 22nd 2016 – Prospects on the T4U​​ 

Past re​leases​

  • December 2014: First public ​beta release
  • February 2015: Beta release based on Preparatory Taxonomy v1.5.2.b
  • March 2015: Beta release based on Preparatory Taxonomy v1.5.2.c
  • May 2015: Technical bug fix release​​​ based on Preparatory Taxonomy v1.5.2.c​. 
  • June 2015: Beta releases based on Preparatory DPM and XBRL Taxonomy versions 1.5.2.b and 1.5.2.c and second version supporting the Public Working Draft Taxonomy v1.7​ for demonstration purposes
  • August 2015: Technical bug fix release​​​ based on Preparatory Taxonomy v1.5.2.c​.
  • February 2016: Beta release and corrective release based on Taxonomy 2.0.1​​
  • April 2016: Final release and corrective release based on Taxonomy 2.0.1​
  • October 2016: Release based on Taxonomy 2.1.0
  • February 2017: Bug fix version based on Taxonomy 2.1.0

Technical information​​​

Technical information about the T4U project can be found at http://t4u.eurofiling.info​.

Background​

Solvency II cre​​​​ates the need for all affected undertakings and supervisors in Europe to adapt their reporting processes. XBRL is the mandatory technical format to be used for reporting from National Competent Authorities (NCAs) to EIOPA (so-called 'second level reporting'). A number of countries will also request submissions in XBRL from undertakings to the relevant NCA ('first level reporting').​​