Altova® EBA add-in for Excel, version 2021 Basic Edition

Creating a New Report

Home Prev Top Next

The instructions below show you how to prepare a new XBRL report based on the default EBA (European Banking Authority) taxonomy available in Altova® European Banking Authority (EBA) 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, see Installing XBRL Taxonomies.

To create a new report:

1.In the Excel ribbon, click the EBA tab.

2.Click Insert New Report.


3.Select the taxonomy entry point corresponding to the report that you wish to create. Use the filter at the top of the dialog box to filter entry points by keywords such as "IFRS", "Funding", and so on. Note that, 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 Show entry points available for download check box. To show all versions, clear the Show only most current entry points check box.


Entry points that are shown in brick red color are not installed. To install the respective XBRL taxonomies, select the entry point, and then click OK. This opens the XBRL Taxonomy Manager, where you can complete the installation, see Managing XBRL Taxonomies.

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 EBA Filing 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:


Entering Data

Controlling Accuracy of Cells

Validating Data

Exporting Data to XBRL


EBA Filing Pane

EBA Filing 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 EBA Filing Pane command in the ribbon. As illustrated above, the EBA Filing Pane consists of two main sections: Properties and Tables.



The properties displayed in the EBA Filing 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 EBA Filing 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 EBA Filing 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 EBA Filing 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.

© 2020 Altova GmbH