Please enable JavaScript to view this site.

Altova® EBA add-in for Excel, version 2020

» No topics above this level «

Creating a New Report

Scroll Home Prev Top Next More

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 at the same time when you install the add-in. Additional taxonomies can be installed separately, see Installing Additional Taxonomies.

 

 

To create a new report:

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

2.Click Insert New Report.

inc-xa-insert-eba

3.When prompted, 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 versions, clear the Show only most current entry points check box.

inc-xa-entry-point-eba

The entry points available by default on the dialog box above are those applicable to the EBA Taxonomy. For more information, refer to the supporting documents of the EBA taxonomy (specifically, see the "EBA Architecture for XBRL representation of DPM"). Additional entry points are available for selection if you downloaded and installed additional XBRL taxonomies from the Altova Download Center (https://www.altova.com/eba-xbrl/download).

4.Be patient while the report tables are loaded into Excel. During this operation, a dialog box informs you of the progress, for example:

inc-xa-insert-progress-eba

Once the report tables have finished loading, notice the Tables section in the EBA Filing Pane.

inc-xa-filing-pane-eba

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.

 

Properties

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.

 

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.

 

Tables

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.

© 2019 Altova GmbH