Transcript Presentation on Preparatory Submission of Information

Preparatory Solvency II Reporting
Industry Presentation
Preparatory Solvency II Reporting
Online Reporting Demo
Brian Dooley
Project Manager
Solvency II Data & Reporting
13th April 2015
2
Agenda
• Welcome
• Introductions
• Today’s objective
• What is not being covered today
• System demonstration
• Key timelines
• Further support
• Q&A
Preparatory Solvency II Reporting
Online Reporting Demo
Barry Murray
Information Management and Technology Directorate
13th April 2015
4
Assumptions
Key Assumptions
• All attendees have access or are familiar with Online Reporting platform.
• All attendees are aware that XBRL has been mandated as only reporting
format for Preparatory Solvency II reporting.
• All attendees are familiar with XBRL and constructs.
• All XBRL instance files will be generated against taxonomy v.1.5.2c.
• All XBRL instance files will reference level 1 entry points of taxonomy.
13th April 2015
5
Return Types
Preparatory Solvency II Return Types
•
•
Individual Return Types
Return Type
Reporting Format
Solvency II Preparatory Annual Report - Individual
.xbrl
Solvency II Preparatory Quarterly Report - Individual
.xbrl
Solvency II Preparatory Narrative Report - Individual
.xls, .xlsx, .doc, .docx or pdf
Group Return Types
Return Type
Reporting Format
Solvency II Preparatory Annual Report - Group
.xbrl
Solvency II Preparatory Quarterly Report - Group
.xbrl
Solvency II Preparatory Narrative Report - Group
.xls, .xlsx, .doc, .docx or pdf
13th April 2015
6
File naming Standards
File Naming Convention
For all return types, the name of the file must be in the following format:
“CCCCCCC_YYYYMMDD_XXXXXX_XXXXX.ext”
where
•
CCCCCCC is the institution code (The 6/7 institution alphanumeric code used for logging
into Online Reporting)
•
YYYYMMDD is the return reporting date (not submission date) e.g. 20141231
•
XXXXXX_XXXXX is the Solvency II “Return File type” on the ONR system (see next slide
for individual Return type file names)
•
.ext is the file extension.
–
For XBRL files it must be either ‘.xbrl’ or ‘.zip’
–
For Narrative files it must be either .xls, .xlsx, .doc, .docx or pdf.
13th April 2015
7
File Naming Standards
File Naming Examples
Return Type
File name Example
Solvency II Preparatory Annual Report - Individual
C997105_20141231_SolvencyIIPrepAnnualReturn_Individual.xbrl
Solvency II Preparatory Quarterly Report - Individual
C997105_20141231_SolvencyIIPrepQuarterlyReturn_Individual.xbrl
Solvency II Preparatory Narrative Report - Individual
C997105_20141231_SolvencyIIPrepNarrativeReport_Individual.xbrl
Solvency II Preparatory Annual Report - Group
C997105_20141231_SolvencyIIPrepAnnualReturn_Group.xbrl
Solvency II Preparatory Quarterly Report - Group
C997105_20141231_SolvencyIIPrepQuarterlyReturn_Group.xbrl
Solvency II Preparatory Narrative Report - Group
C997105_20141231_SolvencyIIPrepNarrativeReport_Group.xbrl
The above examples use:
•
Institution Code – C997105
•
Reporting Date – 31st December 2014
13th April 2015
8
Online Reporting XBRL Submission
Online Reporting XBRL Submission
• The look and feel of Online Reporting will not change
• New return types will be added to the system for Preparatory Solvency II
• Existing return types will remain unchanged
• User Access will be automatically granted to firm administrators for the new
return types
• Data for the Preparatory Solvency II return types can only be submitted using
the file upload functionality i.e. no alternative input methods will be provided
• For XBRL return types, validation errors from the validation engine will be
displayed to the user on the Online Reporting system
13th April 2015
9
Online Reporting XBRL Submission
XBRL Submission – Return Types
13th April 2015
10
Online Reporting XBRL Submission
XBRL Submission – Return Type Options
13th April 2015
11
Online Reporting XBRL Submission
XBRL Submission – Returns
13th April 2015
12
Online Reporting XBRL Submission
XBRL Submission - Sections
13th April 2015
13
Online Reporting XBRL Submission
XBRL Submission – Section Files
13th April 2015
14
Online Reporting XBRL Submission
XBRL Submission – File Upload
13th April 2015
15
Online Reporting XBRL Submission
XBRL Submission – View Uploaded Files
13th April 2015
16
Online Reporting XBRL Submission
XBRL Submission – File Upload Status
13th April 2015
17
Online Reporting XBRL Submission
XBRL Submission – Section Files
13th April 2015
18
Online Reporting XBRL Submission
Key Points
• Preparatory Solvency II XBRL returns must be submitted in XBRL format only
• No web form solution will be available for data input
• Firm’s responsibility to create valid XBRL instance files
• No partial XBRL uploads will be accepted
• Direct visualisation of submission will be through Excel only.
• N.B All XBRL instances should be validated against the relevant taxonomy
before being uploaded to the Online Reporting system
• Only fully validated XBRL instances will be accepted
13th April 2015
19
XBRL Instance Files
•
The schema reference must refer to a valid entry point for level 1 reporting for taxonomy
v1.5.2c as in following table.
XBRL Return Type
Module/Entry Point
Solvency II Preparatory Annual Report - Individual
http://eiopa.europa.eu/eu/xbrl/s2md/fws/solvency/solvency2/
2015-02-28/mod/ars.xsd
Solvency II Preparatory Quarterly Report - Individual
http://eiopa.europa.eu/eu/xbrl/s2md/fws/solvency/solvency2/
2015-02-28/mod/qrs.xsd
Solvency II Preparatory Annual Report - Group
http://eiopa.europa.eu/eu/xbrl/s2md/fws/solvency/solvency2/
2015-02-28/mod/arg.xsd
Solvency II Preparatory Quarterly Report - Group
http://eiopa.europa.eu/eu/xbrl/s2md/fws/solvency/solvency2/
2015-02-28/mod/qrg.xsd
Please note that the all contexts referenced in the XBRL instance file must contain the
following details:
The identifier scheme – http://www.centralbank.ie.
The entity identifier – This refers to the institution code used for logging into Online
Reporting.
The period must refer to a valid reporting date for the institution and return type being
submitted.
13th April 2015
20
Online Reporting Validations
Types of Validation
Narrative Returns
•
File Validation Errors – examples include the following:
– Adhere to standard file naming standards
– Valid content type for file type
– Valid reporting date for institution and return type
XBRL Returns
•
File Validation Errors – as for narrative returns
•
Filing Rules – awaiting finalised set from EIOPA
•
Formula Assertions – published in taxonomy
13th April 2015
21
Online Reporting Validations
XBRL Submission – File Error Example
13th April 2015
22
Online Reporting Validations
XBRL Submission – Filing Rule Example
13th April 2015
23
Online Reporting Validations
XBRL Submission – Assertion Error Example
13th April 2015
24
Submitting Returns
Submitting a Return
For valid files, the following tasks will be performed:
•
For XBRL returns
– One to confirm acceptance of file
– Second to confirm Excel file generated.
• For Narrative Returns
– No email as redirected to section files page if file valid.
•
Final Steps
– Finalise Return
– Separate user to sign off return.
– Email sent to confirm receipt of return.
13th April 2015
25
Key Dates
Key Dates (subject to change)
Test Environment: (https://test.onlinereporting.cbfsai.ie)
•
Available from Wednesday 15th April 2015.
•
Full set of Preparatory Solvency II Returns
•
All returns will use reporting date of 31st December 2014.
Live Environment: (https://onlinereporting.cbfsai.ie)
•
Available from Wednesday 13th May 2015.
•
Full set of Preparatory Solvency II Returns
•
All returns will use your year-end date as reporting date.
•
The submission/due date will be 3rd June 2015.
13th April 2015
26
Useful Links
Online Reporting User Guides
•
General System Guidance Material
–
http://www.centralbank.ie/regulation/processes/onlinereporting/Pages/Introduction.aspx
•
Preparatory Solvency II XBRL & Narrative Upload Manuals
•
http://www.centralbank.ie/regulation/industry-sectors/insurance-companies/solvency2/Pages/default.aspx
Preparatory Solvency II Taxonomy
•
https://eiopa.europa.eu/Pages/Supervision/Insurance/Reporting-formats.aspx
–
Taxonomy package and documentation
–
DPM Dictionary and Annotated Templates
–
Filing Rules – Draft version with final version still to be published by EIOPA.
–
•
Rule identifiers implemented are different from those in latest draft published
•
No rules implemented for section V Codes and Types of Codes.
•
Rules 1.4, 1.5(a), 1.5(b) , 2.8(a), 2.8(b) and 3.4 have been disabled. May be enabled when final version published and implemented (TBC).
Business Validation Rules (Active and Deactivated)
T4U – Tool for Undertakings
•
http://t4u.eurofiling.info/
13th April 2015
27
Key Contact Points
Technical Queries - [email protected]
•
Online Reporting Access Queries
•
XBRL Validation Errors Queries
•
Other technical Issues
Business Queries - [email protected]
•
How to complete templates
•
Any other business related issues
13th April 2015
28
Questions.
13th April 2015
29