EBA XBRL add-in for Excel

The Altova European Banking Authority (EBA) XBRL Add-in for Excel shields reporting companies from the complexity of XBRL syntax.

This unique tool makes it easy for financial professionals to generate EBA reports compliant with EBA XBRL Filing Rules, directly in an application where they’re already comfortable working: Excel.

European Banking Authority (EBA) Add-in for Excel

The Altova European Banking Authority (EBA) XBRL Add-in for Excel shields reporting companies from the complexity of XBRL syntax.

This unique tool makes it easy for financial professionals to generate EBA reports compliant with EBA XBRL Filing Rules, directly in an application where they’re already comfortable working: Excel.

Build EBA reports directly in Excel

Like other regulatory agencies around the world, the European Banking Authority (EBA) has standardized on XBRL for the transmission of data submitted by filing entities, to capitalize on the benefits of standardized data.

For filing companies, however, the challenge lies in getting backend data into a valid XBRL format according to the EBA Taxonomy, especially since the employees recording the data are generally financial professionals.

What if you could get EBA reports in XBRL format directly from a ubiquitous productivity tool that end users are already using for working with financial data, namely, Excel?

The EBA XBRL Add-in for Excel does exactly that.

Get EBA reports in XBRL without ever leaving Excel

Building EBA XBRL in Excel has numerous benefits:

  • No technical XBRL expertise is required
  • Excel template guides user when entering EBA report data
  • Export XBRL button generates EBA XBRL data
  • Import XBRL button imports EBA XBRL data into Excel for viewing/reviewing XBRL filings
  • EBA Filing Properties entry helper assists with data entry
  • Tables selector window lets you navigate to or hide tables
  • Cell Documentation window provides useful information about cell contents to help guide the data input
  • Data validation with comprehensive messaging about errors and inconsistencies are provided
EBA XBRL reporting is made easy with this friendly Excel template

To make EBA XBRL reporting even easier, the EBA Filing Pane lets users view and update information pertaining to document properties and tables. The Cell Documentation window displays the description of the currently selected cell or property as it’s annotated in the underling taxonomy, so users can understand exactly what to enter.

Import or Export EBA XBRL

Once your EBA report is complete in Excel, simply click the Export XBRL button in the EBA ribbon, and the add-in will generate a valid XBRL instance document for submission.

It's just as easy to import existing EBA XBRL reports into Excel for easy analysis using the Import XBRL button in the EBA ribbon. Once the XBRL data is in Excel, it's easy to view, review, understand, and/or re-use.

Please note: The add-in requires Excel 2010, 2013 or 2016. It is not compatible with prior versions.

Batch conversion of EBA XBRL to Excel

The add-in includes a batch conversion button in the Excel ribbon for converting multiple EBA XBRL reports to Excel. This functionality is helpful for customers working with large numbers of files and provides an easy way to automate batch conversions between EBA XBRL and Excel, saving time while reducing data entry errors.

Automate batch conversion of EBA XBRL to Excel

Support for OIM 1.0 for exporting EBA XBRL to CSV

OIM (Open Information Model) provides a syntax-independent model for XBRL data to be transformed into other formats such as CSV and JSON. Though XBRL provides an efficient, standards-based representation of business report data, such data is often stored and/or consumed in other formats. OIM is an abstraction layer that decouples XBRL from the underlying XML syntax. . This way, organizations can take advantage of the functionality of XBRL and at the same time have XBRL documents written in JSON and/or CSV.

Altova EBA XBRL Add-in for Excel supports OIM (Open Information Model), allowing for CSV output of XBRL reports. This gives users the option to export EBA XBRL reports created in the helpful Excel template directly to CSV in addition to XBRL.

OIM for exporting EBA XBRL to CSV

COM API

The COM API can be used to programmatically automate data entry and facilitate proper editing of the Excel/XBRL document, as well as automate the creation of EBA XBRL reports.

Try Free for 30-Days

It's easy to get started with the Altova EBA XBRL add-in for Excel. Simply download the software and install it to begin your free, 30-day trial.

Support for Additional Local Taxonomies

In addition to Version 3.3 phase 3 of the EBA taxonomy for EBA XBRL reporting, the add-in includes built-in support for the European Central Bank Supervisory Financial Reporting Data Points (ECB SFRDP).

Support is also available for prior versions of the EBA taxonomy, as well as local taxonomies for several European countries via the XBRL Taxonomy Manager. This convenient tool is available directly in the software, offering an easy way to select required taxonomies and versions to use with the add-in.

You can select required taxonomies both during installation and by selecting Manage Taxonomies from the EBA tab in the Excel ribbon.

Selecting XBRL taxonomies for EBA reporting

The XBRL Taxonomy Manager makes it easy to view the taxonomies installed on your system and check whether new versions are available for download, independent of the Altova product release cycle. Please refer to the XBRL Taxonomy manager for the most up-to-date list of supported taxonomies. It can be accessed within the EBA XBRL Excel ribbon or online here.

Supported local taxonomies include:

  • ACPR - Autorité de Contrôle Prudentiel et de Résolution filing rules from Banque de France
  • BBK - Deutsche Bundesbank Taxonomy
  • BOE - Bank of England (BOE) filing rules, including PRA100
  • BDP - Banco de Portugal (BDP) filing rules
  • NBB - National Bank of Belgium (NBB) filing rules
  • SRB - Single Resolution Board (SRB) filing rules

Learn More