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 16th February 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

New release available for 2.1.0 taxonomy (VER 2016.10.17)

Date: 19th October 2016

A new 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 5th December 2016)

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

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 beta 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​

New source code update

 

Date: 19th May 2016

The source code of two additional components was uploaded to Github:

  • Mechanism for automatically generating controls for the visualizing table forms​
  • Mechanism for automatically generating Business Excels​​
If you would like to request access please follow the instructions under the previous entry of January 12th 2016.​​

​New source code update for version 2016.04.29

 

Date: 4th​ May 2016

The source code for version 2016.04.29 was uploaded to​ Github.​
If you would like to request access please follow the instructions under the previous entry of January 12th 2016.

New release available for 2.0.1 taxonomy (VER 2016.04.29)

 

Date: 29th April  2016

A new release of the tool supporting the 2.0.1 taxonomy is now available for download: 

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

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

New release available for 2.0.1 taxonomy (VER 2016.04.18)

 

Date: 18th April 2016​

A new release of the tool supporting the 2.0.1 taxonomy is now available for download: 
ClickOnce Setup: Full Solvency II Reporting supporting DPM and XBRL Taxonomy version 2.0.1
Standalone package for Full Solvency II available here
Release notes available here

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

Source Code Publication

 

Date: 21st March 2016

 
The source code for the latest release of the Tool for Undertakings (VER 2016.02.29) has been uploaded to Github. If you would like to request access please follow the instructions under the previous entry of January 12th 2016.

New corrective release available for 2.0.1 taxonomy (VER 2016.02.29)

 

Date: 29th February 2016

 
A new corrective release of the tool supporting the 2.0.1 taxonomy is now available for download: 
  • ClickOnce Setup: Full Solvency II Reporting supporting DPM and XBRL Taxonomy version 2.0.1
  • Standalone package for Full Solvency II available here
  • Release notes available here

A new release of the Preparatory version supporting level 2 entry points has also been published:​

  • ClickOnce Setup​Preparatory phase Reporting supporting taxonomies 1.5.2.b and 1.5.2.c
  • ​​Standalone package for Preparatory Phase available here
  • Release notes available here
For reporting of bugs or any other issues please use our mailbox: ToolForUndertakings@eiopa.europa.eu.

Beta release available for 2.0.1 taxonomy (VER 201​6.02.01)

Date: 2nd February 2016

 
A new beta release of the tool supporting the 2.0.1 taxonomy was published, as well as a new beta release for the Preparatory version supporting level 2 entry points.

Source Code Publication

Date: 12th January 2016

The source code for the current release of the Tool for Undertakings (VER 2015.08.28) 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.

Be​ta​ release available (VER 2015.08.28)

Date: 28 August 2015

Two versions of the tool are available:

Important: Different error margins applied by the database-based validations (relative error with tolerance of 0.000001) and XBRL assertions (interval arithmetic) may result in inconsistent evaluations (compared to XBRL validators).

Beta release available (VER 2015.06.30)

Date: 30 June 2015

The version supported the Preparatory DPM and XBRL Taxonomy versions 1.5.2.b and 1.5.2.c with the following entry points: solo quarterly (QRS), solo annual (ARS), groups quarterly (QRG), groups annual (ARG) for 'level 1' reporting by undertakings to National Competent Authorities.

​A second version supported the current Public Working Draft Taxonomy v1.7​ for demonstration purposes.​​

Meet-the-Market Workshop

Date: 8 July 2015
Venue: 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​​

April 2016 (VER 2016.04.29)​

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

Upcoming rele​ases

July 8th 2016  Final release of the T4U
April 22nd 2016 – Prospects on the T4U​
 
Important: 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. 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.

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​

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').​​