Solvency II Solutions
User Guide
Table of Contents
Solvency II Solutions
User Guide
Welcome
Read Before Starting
Quick Start Guide
Architecture of Application
Installation
Return Setup
Create a New Return
Company Overview
Company Details
SETUP
COMPANY
BS CUR
SCR
BS OTHER
COUNTRY
FAC
IE BRANCH
IE CLAIMS (AY)
IE CLAIMS (UY)
IE COUNTRY
IE NST
INV
LI LOB
NL
NST
PART
RFF
UK NST
UK NST LIAB (AY)
UK NST LIAB (UY)
UK NST CFs
Select Your Return Type
QRT Selection
Roll Forward
H.HV Sheet (Historical Value Template)
Change Your Return
Change Company
Remove a QRT
Add a QRT
Managing Multiple Companies
The Workbook
Contents Tab
QRTs
Calculations
Data Points
Formatting
Edit Links
“Tabular helper” QRT Data points
Unregistered Tabular Workbooks
DB Settings
Upgrading a workbook
Edit return recovery automation
Action tracker
Sensitivity labels
QRT Navigator
QRTs
Narrative Report
Your Audit Logs
QRT Drill Down
Reference / Regulatory Hub
Importing Data
CSV
CSV Specifications
XML
Excel
XBRL Import
Structured file import
Database Connection
Data model
Ways to collaborate in Tabular
Team
Create
Carved out files
Main return of carved out files
Manager
Refresh carved-out model entry
Redefine
Notes and Procedure Notes
Add Note
Show All Notes
Edit Note
Add Procedure Note
Edit Procedure Note Template
Checklist
Edit Checklist item
Show All Procedure Notes
Consolidation
PCC Consolidate
Group Consolidate
Compartment IORP consolidation
Investment QRT Group consolidation
Model entry PCC consolidation
Audit
Validations
Validation Report
Validation Error Types
Validation Comments
Hide/Auto-unhide validation result in report
Whitelist/Blacklist/Greylist rules setup
SCR – SII Data Model
Setting up Tabular Standard Formula SCR calculations
Tabular return checklist
SCR – Model guidance
V10.0.0.0 model changes
SCR – SII Model functionality
Refresh
Import RFR term structure
Investment cash flow generation
Refresh standing data helper sheets
Auto-fill calculation sheet
Risk Margin
Config
Export – XBRL & More
Export CSV
Export Excel
Export XBRL
Export XML
Export NST & SFCR
Non-ECB specific output
Non-ECB Excel output
Non-ECB XBRL output
Other
Malta ANST 08 A specific
XBRL Details
How Tabular Generates XBRL
XBRL Introduction
XBRL Glossary
Taxonomy
Instance Document
Reporting Fact/ Fact
Context
Unit
Reporting Entity / Entity
Period
Dimension
Dimensional analysis
Dimension Member
Explicit dimensions
Typed dimensions
Enumerations
Dimension Domain
Reporting Concept
Breaking Down An XBRL File
XBRL Support
XBRL Support Documents
XBRL Troubleshooting
PRA
FSC
DMB
CBI
Narrative Reporting
Data Source Manager
Data Links
Chart or Table Object
Format Manager
Manage Fields
Custom Fields
Siimplify
Tools
Manage custom sheets
Reset Tool
About
QRT Sign Off
Analytics report generator
Analytic Reports
Auto-generation of Central Bank of Ireland NST 13
Adding/Editing/Removing custom NST.13 rules
Retrieve timestamped return workbook
S.19.01 data entry interface
Convert S.19.01.01.LISTV to QRT layout
Import from S.19.01.01.LISTV QRT layout file
QRT visibility
Validations for visible QRTs
Hidden QRT settings
Return workbook cell formatting
Formula auditing
Unlock data entry cell
Delete erroneous worksheet
Auto return create
System Admin
Administer Users/Roles
Create/Edit User
Create/Edit Role
One Click Upgrade
Settings
System Options
Dynamic tolerances
Reduced network load (RNL)
Disable Zip Compression
Support Options
Logging
Logging level
Environment logging
DB Options
Update goldencopy return variant
Known Tabular issues
Troubleshooting
I Can’t Get Started
I Can’t Login to Tabular
Tabular is too Slow
I Made a Mistake
I Made a Mistake, How Can I Revert Back?
I Have a Problem with Excel
I See Some Strange Effects in Non-Tabular Workbooks
I Have a Problem with a QRT
I’m Missing a QRT
S.06.02 *
I Have an Extra QRT
A QRT is Missing Data Points
The QRT Structure Looks Incorrect
I Have a Problem with a Formula
A Formula is Incorrect
A Formula is Missing
I Want to Add my Own Formulas
I Want to Link to an External Workbook
C0170 is showing 0 in S.06.02.01.01/SE.06.01.16.01 etc..
I Have a Problem Importing
I Have a Problem with a Validation
I Don’t See the Validation that I am Expecting
I Have a Problem with Reg Hub
I Can’t View Regulatory Hub
I Have a Problem with XBRL
My XBRL File will not Load into our Regulator Portal
I Have a Problem with Tables
I can’t create a return
I can’t create a return because it says I have opened workbooks
Corrupted workbooks that need repair
Useful Information
Download as PDF
Troubleshooting
Known Tabular issues
I Can’t Get Started
Feedback
Was this helpful?
Yes
No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
×
Thanks for your feedback.
Post your comment on this topic.
Your name *
Your e-mail address *
Comment *
Post Comment
Post your comment on this topic.