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
  • Optional EBA data quality checks
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.

EBA data quality checks

The EBA recommends optional data quality checks in addition to the mandatory validations under the EBA XBRL taxonomy. These checks help reporting institutions improve data accuracy and meet regulatory requirements before submission. While they are optional, using these extra checks can reduce the risk of errors and improve compliance.

Support for performing additional quality checks on EBA XBRL documents gives Altova customers an additional advantage for improving efficiency and accuracy.

EBA data quality checks

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.5 of the EBA Reporting Framework, the add-in includes built-in support for the European Central Bank Supervisory Financial Reporting Data Points (ECB SFRDP) and the Single Resolution Board (SRB) filing rules.

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 (Banque de France)

  • LCB-FT - Combating Money Laundering and the Financing of Terrorism Taxonomy
  • RUBA - Unified Reporting Banks and Assimilates Taxonomy
  • COREP - Common Reporting Taxonomy with the modules LCR_CON, LCR_DA, NSFR_CON and ALM_CON
  • CREDITIMMO - Reporting Taxonomy for home loans and the profitability of production and outstanding home loans in France

BBK - Deutsche Bundesbank

  • EBA-ITS-Reporting extended by the German base taxonomy
  • RTF - Risk bearing capacity taxonomy

BDP - Banco de Portugal

  • Financial and Common Reporting framework

BOE - Bank of England

  • BANKING - Regulatory reporting for the banking sector (including PRA - Prudential Regulation Authority)
  • STATISTICS - Statistical reporting obligations

CBI - Central Bank of Ireland

  • FSP - Taxonomy for Fund Service Providers, Investment Firms and other Payment Institutions

DNB - De Nederlandsche Bank

  • BISCBS - BIS Consolidated Banking Statistics Taxonomy
  • BSI - Balance Sheet Items Taxonomy
  • DGS - Deposit Guarantee Scheme Reporting Framework
  • FBO - Taxonomy for financial reporting for investment funds and fund managers
  • FEH - Foreign Equity Holdings
  • MESREP - Macroeconomic Statistics Reporting Taxonomy
  • MIR - MFI Interest Rates Reporting Taxonomy
  • MSR - Taxonomy for the Monthly Securities Reporting
  • OTC - Derivatives Reporting Taxonomy
  • PAY - Payment Statistics Reporting Framework
  • PLA - Profit and Loss Account Taxonomy
  • PPSP - Taxonomy for Payment Processing Service Providers
  • SPV - Securitization Vehicles Taxonomy for Special Purpose Vehicles reporting

NBB - National Bank of Belgium

  • BANKING - Domain MBS-XBRL reporting: FINREP, TREP

Altova is often able to add new country-specific taxonomies for use in this add-in via the XBRL Taxonomy Manager, provided they have an XBRL table linkbase and are Eurofiling-based. Contact Altova Support with requests of this type.

Learn More