The instructions below show you how to prepare a new XBRL report based on the Solvency II XBRL taxonomy available in Altova Solvency II XBRL add-in for Excel. This XBRL taxonomy is installed by default on your computer when you install the add-in. Additional taxonomies can be installed separately. For details, see Installation of XBRL Taxonomies.
To create a new report, take the following steps:
1.Click the Solvency II tab in the Excel ribbon.
2.Click Insert New Report.
3.Select the taxonomy entry point corresponding to the report you want to create (see screenshot below). Use the filter at the top of the dialog box to filter entry points by keywords. By default, only the most current entry points for the current version of the add-in are shown. To show all the XBRL taxonomies available for download, select the check box Show entry points available for download. To show all versions, clear this check box. Entry points shown in red are not installed. To install the respective XBRL taxonomies, select the entry point and click OK. This opens the XBRL Taxonomy Manager, where you can complete the installation. For more information, seeManage XBRL Taxonomies. Because of memory requirements, some entry points cannot be loaded in the 32-bit version of the add-in, in which case they appear as grayed out in the dialog box above. To make the loading of such entry points possible, use Excel 64-bit and install the 64-bit version of the add-in.
4.Wait while the report tables are loaded into Excel. During this operation, a dialog box informs you about the progress. Once the report tables have finished loading, notice the Tables section in the Solvency II Report Pane.
5.Select the check boxes next to the tables you want to include in the report. Each included table appears on a new sheet in the Excel book. Please note that tables checked for inclusion will generate a true filing indicator, and tables that are left unchecked will generate a false filing indicator. The filing indicators are set by checking/unchecking the respective table in the Tables section of the pane. Each table that has been checked will be added to the report and set as filed; all the others will not be added to the report.
You can now start entering data in tables, validate it, and export it to XBRL format. See the following topics for more information:
The Solvency II Report Pane is the area where you can include or exclude tables from the report, view information about each cell, and view or set various report properties. By default, this pane is visible. You can show or hide it by clicking the Toggle Solvency II Report Pane command in the ribbon. As illustrated above, the Solvency II Report Pane has two main sections: Properties and Tables, which are described in the subtopics below.
The properties displayed in the Solvency II Report Pane directly affect the content of the XBRL instance file that will be created when you export the XBRL instance. To view what each property does, click it and observe the description displayed in the gray box under the grid. Grayed out properties are read-only. Otherwise, you can edit a property by typing text or selecting a value, as applicable.
The Scheme and Identifier properties under Reporting Entity are usually provided by the relevant competent authorities.
Also note that, even though some property values begin with http (for example, XSD Entry Point URI), they do not necessarily point to live web resources and thus should not be considered dead links. To resolve entry point URIs, the add-in uses a catalog mechanism that maps URIs to files on the local system. This is largely due to the size of the taxonomies and the fact that they contain thousands of files. Accessing the taxonomy files on the Internet would result in extremely slow performance, even if their issuing organizations served them that way.
Properties are grouped into the following three tabs:
•The Report tab displays properties applicable to the entire report: One report corresponds to one Excel workbook.
•The Table tab only displays properties of the currently selected table. A table normally corresponds to a single Excel worksheet. Therefore, whenever you click inside a new Excel sheet, the properties are re-drawn to reflect the new worksheet.
•The Cell tab displays only properties of the currently selected cell. Whenever you click a new cell, the cell properties are re-drawn accordingly.
You can set the accuracy-related properties at report, table, or cell level. For more information, see Control Accuracy of Cells.
To include a table in the report, select its corresponding check box in the pane. Each included table appears on a new sheet in the Excel book. To go to a specific sheet, navigate to it using the standard Excel way or click the corresponding table in the Solvency II Report Pane. To remove a particular table from the report, clear the check box next to it. Tables that are not selected will not be included in the report.
Some tables support a z-axis (a third dimension). For information about adding a z-axis to a table, see Enter Data into 3D Tables.
Each report table displayed in the Solvency II Report Pane is XBRL-bound, which means that data you enter directly in the table cells will be reflected in the XBRL instance file when the report is ready. For more information, see Export Data to XBRL. While the report data is work in progress, you can save the Excel workbook and reopen it later.
Any sheets that contain tables are bound to the XBRL taxonomy. Therefore, these tables must not be deleted. It is not recommended to rename such sheets. If necessary, you can add new sheets to the workbook. However, such sheets will not be bound to the XBRL taxonomy. As a result, these sheets will be ignored when you generate the XBRL instance file.