Please enable JavaScript to view this site.

Altova Solvency II XBRL add-in for Excel, ver. 2022 Basic Edition

You can control the accuracy of monetary and other numeric values in the XBRL report by setting the following properties:

 

1.Accuracy of monetary cells;

2.Accuracy of numeric cells;

3.Accuracy of percentage cells.

 

These properties are available in the Solvency II Report Pane in the Properties section.

inc-xa-slv-accuracy1

Accuracy of monetary cells

The property Accuracy of Monetary Cells applies to numeric cells that represent a monetary value.  By default, the property Accuracy of Monetary Cells is set to Cents (2), which sets the value of the decimals attribute in the XBRL instance to 2.

 

Accuracy of numeric cells

The property Accuracy of Numeric Cells applies to numeric values that have no unit except for percentage values, which have their own data type.  By default, the property Accuracy of Numeric Cells is set to Exact (INF), which sets the value of the decimals attribute in the XBRL instance to INF.

 

Accuracy of percentage cells

The property Accuracy of Percentage Cells applies to values that represent a percentage.  By default, the property Accuracy of Percentage Cells is set to Basis Points (4), which sets the value of the decimals attribute in the XBRL instance to 4.

 

To see the type of a cell, select a cell and click the Cell tab in the Solvency II Report Pane and see the Type property.

 

The accuracy you select from the Solvency II Report Pane controls the accuracy that will be written for this fact in the XBRL instance file. More specifically, the Accuracy properties are bound to the decimals attribute in the XBRL instance file. In the image below, the accuracy value indicated in the brackets corresponds to the value of the decimals attribute in the XBRL instance file.

inc-xa-slv-accuracy3

You can set the accuracy-related properties at report, table, or cell level (see screenshot above). If you set accuracy at multiple levels, keep in mind that the more specific property always overrides the more generic one. For example, the accuracy set at cell level takes priority over the one set at table level. Likewise, the accuracy set at table level takes priority over the one set at report level.

 

For monetary and numeric cells, the accuracy value can be either positive or negative. A positive value N specifies the accuracy of up to N digits to the right of the decimal separator. For example, the value 2 specifies the accuracy of monetary cells to be in cents. A negative value N specifies the accuracy of up to N digits to the left of the decimal separator. For example, the value -3 specifies the accuracy to be up to thousands, while the value -6 specifies the accuracy to be up to millions.

 

© 2015-2021 Altova GmbH