The templates come with a range of technical validations to help ensure data integrity throughout the data capture phase including closed lists and data type conformity. The workbooks make use of macros to make it easier for users to input data into open tables, such as the list of assets.

Once the templates are populated, users can simply upload the files to the Seahorse file directory. If preferred, this step can even be automated using Seahorse’s API. All file uploads are date and user stamped, which provides the much-needed transparency between multiple data preparers.

XBRL files are generated prior to processing of validation rules. Because the checks take place on the actual XBRL file, business can have even great confidence that final XBRL submissions will pass all regulator checks. The validations checks are comprehensive and cover the business rules and filing rules for the chosen jurisdiction and taxonomy.

Additionally, the interface provides a comprehensive and organised checklist of all of the rules that have been evaluated, as well as a pass or fail indicator for each. The details of each rule are exactly consistent with the XBRL taxonomy.

Users can download the validation checks back into Excel, with the validation checks and results embedded in the templates. The issues tab provides an index of all validation failures, with links back to the individual data points. This is particularly useful for users who need to drill-down into the issues and identify the appropriate actions to remedy the errors.

Don’t forget to read our Solvency II Buyer’s Guide.