You can populate a report with data either by entering data into cells manually or by pasting values. With some cells, you can select a value from a predefined list (such as countries or currencies). Also, in some report tables, you may need to add new rows or columns. The following is a list of tips and best practices for entering data.
Editable versus non-editable cells
As a general rule, gray cells must not be edited. Only cells that are included in the XBRL-bound area (delimited by the table boundaries) are to be edited. For guidance with respect to the purpose of the cell, and data expected to be entered, consult the cell information (properties) displayed in the Solvency II Report Pane, in the Cell tab.
If you paste data from multiple columns, the number of pasted columns should correspond to the number of columns in the predefined sheet. If you accidentally paste a larger number of columns, or if you type text outside the default table, unwanted columns may appear outside the XBRL-bound area. To delete unwanted columns, right-click the cell and select Delete > Table Columns. To prevent Excel from adding new columns and rows automatically, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type > Apply as you work, and click to clear the Include new rows and columns in table check box.
When pasting data, it is recommended to keep only the values (and not the formatting). Namely, select the Paste Values option when pasting cells or rows.
Actual versus displayed cell value
While generating the XBRL instance file, the add-in ignores any cell formatting information and exports the actual value of the Excel cell. However, bear in mind that, as part of Excel functionality, the actual value may be different from the value displayed in the cell, because of the cell formatting information. You can view at any time the actual value (the one that will be written to the XBRL instance) in the formula bar of Excel. Consider this example:
In the example above, the value that will be written to the XBRL instance is 12345. Note that the number accuracy reported in the XBRL instance file also depends on the value you selected for the "Accuracy" properties (see Controlling Accuracy of Cells).
Some cells expect a fixed predetermined value (for example, cells that represent currencies or countries). In this case, the add-in displays a small tooltip when you click the cell. You can pick up the required value from the drop-down list:
To view the full list of all possible values, click the cell and observe the cell properties in the Cell tab of the Solvency II Report Pane.
In some tables, you must first fill out a cell value in other to make other cells of the table editable. For example, in the table below, the cells A5 and B5 must first be filled out before all the other cells in the same row become editable.
Conditional cells can unlock cells not only from the same row, but also from the same column. For example, in the table below, cell C7 must first be filled out in order to make cells C9-C11 editable:
Cells with multiple values
Depending on the XBRL taxonomy, some reports might have facts that represent an arbitrary list of comma-separated multiple values. Consequently, in Excel, the corresponding cell also requires multiple values to be entered in the same cell. For example, the table "S.18.104.22.168.0.3" available through the entry point 21 - Annual Solvency II public disclosure Solo contains cells that take multiple values.
To enter data for such cells, first expand the drop-down list, and then click all items that qualify.
Alternatively, you can type all the numeric values, separated by a comma, as shown below. Remember that you can view all possible values of a cell in the Cell tab of the Solvency II ReportPane.
After you exit a multi-valued cell, it is automatically re-drawn to display all selected values in a readable form (even though you may have entered only numbers).
Adding new rows
With some tables, you may need to create new rows. For example, this is the case for table "S 01.03.01.01" available through the entry point Solvency II 2.3 - Annual Solvency II Reporting Solo. You can add new rows either using the standard Excel commands or shortcuts, or by clicking the Add Row button in the ribbon. For example, to add a new row to the table "C 10.02" of the entry point mentioned above, do one of the following:
|•||In the Excel ribbon, click the Solvency II tab, and then click Add Row | Insert Row Below. Note that the commands to insert or delete rows are enabled only if the table supports adding new rows.|
|•||Click the rightmost cell of the last row in the table, and press Tab.|
|•||Right-click a cell in the empty row, and select Insert | Table Row Below from the context menu.|
Note: Any newly added rows must be within the XBRL-bound area of the table, clearly delimited by black lines.
Adding new columns
Some tables may need extra columns to be added. In other words, they can grow horizontally. For example, this is the case for table "S.04.01.01.03" available through the entry point Solvency II 2.3 - Annual Solvency II Reporting Solo. You can add new columns to such tables in one of the following ways:
|•||In the Excel ribbon, click the Solvency II tab, and then click Add Column. Note that this command is enabled only if the table supports adding new columns according to the XBRL taxonomy.|
|•||Click the Add button that appears next to the rightmost column of a table.|
|•||Right-click a table cell, and then select Insert | Table Columns to the Right from the context menu.|
© 2019 Altova GmbH