Altova European Banking Authority (EBA) XBRL add-in for Excel Features
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. 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
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.
Advanced Features in Enterprise Edition
The EBA XBRL Add-in for Excel is available in Basic and Enterprise Editions. The advanced Enterprise Edition includes all the features of the Basic Edition, plus:
- Batch conversion button in the Excel ribbon for converting multiple EBA XBRL reports to Excel
- COM API that 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
Support for Additional Local Taxonomies
In addition to 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). The add-in also supports report creation for the local taxonomies listed below. Simply download and install the required taxonomies from the EBA XBRL Add-in download page, and they will be available during report creation.
- ACPR - Autorite de Controle Prudentiel et de Resolution 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
- FTK - De Nederlandsche Bank Financieel Toetsingskader (DNB FTK) filing rules
- NBB - National Bank of Belgium (NBB) filing rules
- SRB - Single Resolution Board (SRB) filing rules
