Create a Solvency II reporting operating model: QRTs, SFCR/RSR, XBRL pipeline, and…
- User
Create a Solvency II reporting operating model: QRTs, SFCR/RSR, XBRL pipeline, and assurance.
- Assistant
Solvency II Reporting Operating Model
Executive Summary
This operating model outlines an end-to-end framework for Solvency II Pillar 3 reporting, covering Quantitative Reporting Templates (QRTs), Solvency and Financial Condition Report (SFCR), Regular Supervisory Report (RSR), XBRL pipeline, and assurance processes. It ensures compliance with EIOPA regulations (e.g., Delegated Acts, ITS), timely submissions (quarterly/annual), data quality, and audit readiness.
The model is built on four pillars: People (roles/R&R), Processes (workflows), Technology (integrated pipeline), and Governance (controls/assurance). It assumes a mid-sized insurer with actuarial, finance, and IT teams, scalable for larger entities.
Key Benefits:
- Automated 80%+ of QRTs via validated models.
- XBRL validation reducing errors by 95%.
- Assurance embedded for clean audit opinions.
1. Governance and Responsibilities
A central Solvency II Reporting Committee (SRC) oversees the model, chaired by CFO/Head of Finance, meeting monthly.
Role Responsibilities Key Deliverables SRC Chair (CFO) Strategic oversight, sign-off Final submission approval Reporting Manager End-to-end coordination Reporting calendar, issue log Actuarial Team Reserves, SCR/MCR calcs, QRTs (S.02, S.12-23) Validated templates Finance Team Balance sheet, P&L, SFCR/RSR drafting Narrative reports IT/Data Team Data warehouse, XBRL pipeline Automated feeds, submissions Risk/Compliance Validation, ORSA integration Control attestations External Auditor Independent assurance Audit report 1st/2nd/3rd LoD Self-testing, peer review, external audit Sign-off cascade RACI Matrix (excerpt for QRTs):
Activity Reporting Mgr Actuarial Finance IT Compliance Data Extraction R C I A I Calc/Validation A R C I R XBRL Filing R I I A C 2. Reporting Calendar
Aligns with EIOPA deadlines (e.g., QNBE ref dates: 31-Dec, 31-Mar, etc.).
Report Frequency Ref Date Submission Deadline Lead Time QRTs (Full regime) Quarterly 31-Mar/Jun/Sep/Dec +45 days (PubRe) / +20 days (Solwency) 30 days prep SFCR Annual 31-Dec 4 months (PubRe) 90 days RSR Annual 31-Dec 4-6 months (confidential) 120 days Critical Path Milestones (Annual Cycle):
- T-90: Data close.
- T-60: QRTs draft/validation.
- T-30: XBRL tagging/assurance.
- T-0: Submission to EIOPA/NCAs.
3. End-to-End Processes
3.1 Data Collection and Aggregation
- Sources: GL (SAP/Oracle), Actuarial models (MoSes/Prophet), Risk systems (RMS/IGNITE), ORSA.
- Process:
- Automated ETL from source systems to Central Data Warehouse (CDW) (e.g., Snowflake).
- Reconciliation: Balance sheet vs. QRT S.02.02.
- Cut-off controls: Period-end close +5 days.
Source Systems → ETL (Alteryx/Talend) → CDW → Staging Layer → Golden Source3.2 QRTs Production
- Templates: S.01 (BS), S.02 (P&L), S.12-23 (Reserves, SCR/MCR), S.32 (Concentration).
- Process:
- Calculation Layer: Run standard formula SCR (Excel/VBA or Python/R), internal model if approved.
- Validation: Automated checks (e.g., Moody's AXIS validator), manual peer review.
- Reconciliation: Vs. prior period, audited FS.
CDW → Actuarial Engine (Python/MoSes) → QRT Templates (Excel/DPM D2.1) → Validation Rules → Output3.3 SFCR/RSR Preparation
- SFCR (Public): Business/performance, system of governance, risk profile, valuation, capital, narrative.
- RSR (Private): Detailed supervisory info, projections.
- Process:
- Draft from QRTs data + narrative inputs.
- Board approval (SFCR).
- XBRL tagging for SFCR sections.
Section Input Source Owner A. Business Annual Report Finance D. Risk Profile QRTs S.12-23 + ORSA Risk E. Valuation QRT S.02.01 Actuarial 3.4 XBRL Pipeline
- Tech Stack: Arezzo/IXPlatform or Workiva for DPM validation; Python libraries (arelle) for custom.
- End-to-End Flow:
1. QRTs/SFCR Excel → XBRL Taxonomy Mapping (DPM 3.2+) ↓ (Arezzo auto-tagging 90%) 2. Validation: Taxonomy checks, business rules (EIOPA VAL Tool) ↓ 3. Package: ZIP with XHTML, XSD, CALC links ↓ 4. Test Submission: EIOPA Sandbox ↓ 5. Live Filing: BIRT/EBA Gateway (API integration) ↓ 6. Acknowledgement & Reconciliation- Automation: 95% via API; error log dashboard (Tableau).
- Version Control: Git for mappings.
4. Technology Architecture
┌─────────────────┐ ┌──────────────────┐ ┌─────────────────┐ │ Source Systems │───▶│ CDW (Snowflake)│───▶│Calc/Validation │ │ (ERP/Act/Risk) │ │ ETL (Talend) │ │ (Python/MoSes)│ └─────────────────┘ └──────────────────┘ └─────────────────┘ │ ▼ ┌─────────────────┐ │ XBRL Pipeline │───▶│ EIOPA Gateway │ │ (Arezzo/Python) │ └─────────────────┘ └─────────────────┘- Key Tools:
Component Tool Data Snowflake + dbt Calcs Python (Pandas/NumPy) + Moody's AXIS QRTs Excel + EBSILA DPM Viewer XBRL Arezzo, Arelle Reporting Power BI/Tableau Workflow Jira/Confluence
5. Assurance Framework
Three Lines of Defense (3LoD) embedded:
LoD Activities Evidence 1st (Business) Self-testing (e.g., QRT reconciliations >95% auto-pass) Checklists, logs 2nd (Compliance/Risk) Independent validation (sample 20% QRTs), process walkthroughs Attestation reports 3rd (Internal Audit) Annual deep-dive Audit findings log External EY/PwC: Full scope on SFCR/QRTs Clean opinion - Key Controls:
- Data lineage traceability.
- Change management for models/DPM updates.
- Dry-runs quarterly.
- KPIs:
KPI Target On-time Submission 100% XBRL Errors <1% Validation Pass Rate >98% Audit Findings Zero material
6. Risks, Controls, and Continuous Improvement
Risk Control Owner Data Quality Automated reconciliations IT DPM Changes EIOPA subscription + quarterly testing Reporting Mgr Resource Shortage Cross-training, outsourcing peak SRC Cyber/Access RBAC, SOC2 compliance IT Improvement: Annual model review; post-mortem after each cycle.
This model is ready for implementation. For customization (e.g., internal model firm), provide entity-specific details. Contact for diagrams in Visio/PowerPoint.