End-to-End Automation Across Solvency II and Solvency UK
Tabular by Solvency II Solutions enables full automation of the Solvency II and Solvency UK reporting process. From data ingestion and SCR calculation to QRT population, validation, XBRL generation, and submission, every step can be streamlined and controlled within a single on-premises platform. Designed for ease of use and rapid deployment, Tabular eliminates manual processes, reduces operational risk, and ensures auditability without the need for bespoke IT development or external consultants.
Automating SCR Outputs
Tabular automates the processing of SCR results. Pre-built templates allow users to map outputs from actuarial software or internal spreadsheets directly into the relevant QRTs. The system supports scheduled import of results and can automatically trigger population of downstream reports. This ensures consistency across reports and eliminates re-keying errors.
ORSA and Projections Integration
The platform supports projections. These can be automated in the same way as SCR results, with projection data feeding into ORSA-specific templates. Version control is maintained throughout, and all reporting logic is reusable, making re-runs and scenario comparisons fully automated and reproducible.
Data Mapping and Validation
Tabular includes a configurable mapping engine for aligning internal data structures with EIOPA and PRA formats. Once mappings are set up, the process becomes fully automatic. Validation rules—including those from the latest taxonomies—are run as part of the workflow, and issues are flagged with full traceability. This removes the need for separate validation tools or manual checking.
QRT Population and Cross-Linking
All QRTs, including asset-level templates (e.g., S.06.02) and group-specific reports (e.g., S.32.01), are generated automatically based on source data and rule logic. Tabular maintains cross-linking rules between templates, ensuring consistency and alignment. For example, own funds declared in S.23.01 are automatically tied to movements shown in S.25.01 and S.29.01. This helps catch discrepancies early and enforces internal consistency without manual intervention.
XBRL Generation and Submission
Once QRTs are completed and validated, Tabular generates XBRL files in the correct format for EIOPA or PRA submission. This process is one-click and includes embedded validations against the current taxonomy. Submission-ready files are archived, versioned, and logged automatically, ensuring a full audit trail. The submission package can be exported and transferred through your preferred regulatory gateway with zero rework.
Reconciliation and Audit Trail
Every automated process step—from data load to final output—is logged with timestamps, user information, and data version references. This ensures that all outputs can be traced back to their source, and every action is reproducible. Built-in reconciliation reports allow for automated checking of internal data vs reported totals, highlighting gaps or mismatches before submission.
Example Automation Scenarios
- Monthly SCR Refresh: A scheduled import from the actuarial model triggers auto-population of S.25.01, S.28.01, and related templates, followed by validation and XBRL packaging—all without user input.
- ORSA Run with Projections: A set of projection scenarios are batch-imported, triggering automated generation of ORSA documents and associated QRTs, each scenario tagged and versioned for governance purposes.
- Quarter-End Reporting Cycle: Finance data, asset data, and capital figures are uploaded or linked to staging locations. Tabular then automatically generates all solo and group QRTs, validates them, applies the latest taxonomy rules, and outputs submission-ready XBRL—all in one repeatable flow.
Summary: What Tabular Automates
Process Step | Automated in Tabular | Notes |
---|---|---|
SCR Results to QRT Mapping | Yes | Supports both standard and internal |
ORSA Projection Ingestion | Yes | Scenario-driven with full traceability |
Data Validation | Yes | Based on taxonomy and custom rules |
QRT Population | Yes | Full solo and group templates |
Cross-Template Reconciliation | Yes | Ensures consistency across QRTs |
XBRL Generation | Yes | Submission-ready format |
Audit Trail / Versioning | Yes | Full traceability for each cycle |
Submission File Packaging | Yes | Final files zipped and logged |
Conclusion
Tabular delivers full-cycle automation for Solvency II and Solvency UK reporting without the typical complexity, overhead, or reliance on third parties. It gives actuarial, finance, and compliance teams a fast, secure, and auditable way to handle reporting obligations—on time, every time.