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.
To create a new report:
1.In the Excel ribbon, click the Solvency II tab.
2.Click Insert New Report.
3.When prompted, select the taxonomy entry point corresponding to the report that you wish to create.
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 on the dialog box above. To make loading of such entry points possible, use Excel 64-bit and install the 64-bit version of the add-in.
4.Be patient while the report tables are loaded into Excel. During this operation, a dialog box informs you of the progress, for example:
Once the report tables have finished loading, notice the Tables section in the Solvency II Report Pane.
5.Select the check boxes next to tables that you want to include in the report. Notice that each included table appears on a new sheet in the Excel book.
You can now start entering data in tables, validate it, and export it to XBRL format. See the following topics for more information:
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 Toggle Solvency II Report Pane command in the ribbon. As illustrated above, the Solvency II Report Pane consists of two main sections: Properties and Tables.
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. Properties that are grayed out 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 typically provided by the relevant competent authorities.
Also note that, even though some property values begin with "http" (for example, Entry Point URI, Scheme), 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 in large part due to the size of the taxonomies and the fact that they contain thousands of files. Accessing the taxonomy files over 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:
•Report - This tab displays properties applicable to the entire report (one report corresponds to one Excel workbook).
•Table - This tab displays only 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.
•Cell - This 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 Controlling Accuracy of Cells.
To include a table in the report at any time, select its corresponding check box in the Solvency II Report Pane. Each included table appears on a new sheet in the Excel book. To go to a specific sheet, either 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 Entering Data into Three-Dimensional Tables (Z-Axis) .
Each report table displayed in the Solvency II Report Pane is XBRL-bound, meaning that data you enter directly in the table cells will be reflected in the XBRL instance file when the report is ready, see Exporting Data to XBRL. While the report data is work in progress, you can save the Excel workbook and reopen it at any time later, just like a standard Excel workbook.
Any sheets that contain tables are bound to the XBRL taxonomy, so they must not be deleted. It is also not recommended to rename such sheets. If necessary, you can add new sheets to the workbook; however, such sheets would not be bound to the XBRL taxonomy and consequently be ignored when you generate the XBRL instance file.