Overview

The EBA XBRL Add-in for Excel leverages Altova's expertise in XML and XBRL technologies to provide a user-friendly solution for EBA reporting. By integrating directly with Excel, the add-in allows users to enter, validate, and export EBA report data in XBRL format. This approach simplifies the reporting process and ensures that financial data is accurately represented according to the EBA taxonomy. The add-in is designed to be intuitive and easy to use, making it accessible to financial professionals who may not have a background in XBRL. It provides an Excel template that guides users through the data entry process, ensuring that all required fields are completed accurately. The template includes descriptions and valid entries for each field, helping users understand what data needs to be entered and how to enter it correctly. Once the data is entered, users can generate a valid EBA XBRL instance document by clicking the Export XBRL button in the EBA ribbon. This feature automates the conversion of Excel data into XBRL format, ready for submission. The add-in also includes an Import XBRL button, which allows users to import existing EBA XBRL reports into Excel for easy analysis and review. This feature is particularly useful for organizations that need to review and reuse XBRL data.

Features

• No technical XBRL expertise required: The add-in eliminates the need for users to understand XBRL syntax, making it accessible to financial professionals who are already comfortable working with Excel.
• Excel template for data entry: The add-in provides an Excel template that guides users through the data entry process, ensuring that all required fields are completed accurately.
• Export XBRL button: Once the data is entered, users can generate a valid EBA XBRL instance document by clicking the Export XBRL button in the EBA ribbon. This feature automates the conversion of Excel data into XBRL format, ready for submission.
• Import XBRL button: Users can import existing EBA XBRL reports into Excel for easy analysis and review. This feature allows users to view, understand, and reuse XBRL data within Excel.
• EBA Filing Properties entry helper: The entry helper assists users with data entry by providing descriptions and valid entries for each field. This ensures that the data entered is accurate and compliant with the EBA taxonomy.
• Tables selector window: The tables selector window allows users to navigate to or hide tables within the Excel template. This feature helps users manage large datasets and focus on specific sections of the report.
• Cell Documentation window: The cell documentation window displays useful information about the contents of each cell, helping users understand what data to enter. This feature provides context and guidance for accurate data entry.
• Data validation: The add-in includes comprehensive data validation and messaging about errors and inconsistencies. This ensures that the data entered is accurate and meets regulatory requirements.
• Optional EBA data quality checks: The add-in supports optional data quality checks recommended by the EBA. These checks help improve data accuracy and compliance before submission.
• Batch conversion: Users can perform batch conversion of multiple EBA reports to Excel. This feature streamlines the reporting process for organizations with large volumes of data.
• COM API: The add-in includes a COM API for automating data entry and report creation. This feature allows organizations to integrate the add-in with other systems and automate repetitive tasks.
• OIM XBRL support: The add-in supports OIM (Open Information Model) 1.0 CSV output. This feature provides additional flexibility for data interchange and reporting.
• XBRL Taxonomy Manager: The XBRL Taxonomy Manager allows users to easily select and install required taxonomies and versions. This feature ensures that the add-in is always up-to-date with the latest regulatory requirements.