Quantitative Reporting Templates (QRTs) form the core of Solvency II regulatory reporting. This guide explains the QRT framework, template structure, and reporting requirements for insurers.
Key Takeaways
- QRTs cover assets, liabilities, capital, and risks
- Solo and group templates have different requirements
- Annual and quarterly frequencies apply
- EIOPA taxonomy defines the data model
- Validation rules check data consistency
QRT Framework
QRTs provide standardized reporting:
• Balance sheet information
• Own funds calculation
• Solvency Capital Requirement (SCR)
• Minimum Capital Requirement (MCR)
• Technical provisions
• Asset portfolios
Templates are harmonized across EU member states.
Template Categories
QRT template groups:
• S.01-S.05: Basic information
• S.06-S.11: Balance sheet items
• S.12-S.17: Technical provisions
• S.22-S.25: Own funds and SCR
• S.26-S.31: SCR components
• S.32-S.36: Reinsurance
Group templates (G prefix) have similar structure.
Reporting Frequencies
Frequency requirements:
• Quarterly: S.01, S.02, S.05, S.06, S.12, S.17, S.23
• Annual: All solo templates
• Group: Similar pattern with G prefix
Quarterly reports are due within 5-8 weeks of quarter end.
Data Quality
Ensure data quality: • Source data reconciliation • Calculation verification • Cross-template consistency • Trend analysis vs prior periods • Documentation for audit Poor data quality triggers supervisory attention.
Submission Process
QRT submission workflow:
1. Extract data from source systems
2. Apply calculations and transformations
3. Generate XBRL instance
4. Validate against EIOPA rules
5. Submit to national supervisor
6. Address any rejection feedback
Checklist
- Applicable templates identified
- Reporting calendar confirmed
- Source data extracted
- Calculations verified
- XBRL generated
- Validation passed
- Submitted on time
- Confirmation received