How to Get EBA XBRL from 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. Benefits of using XBRL include increased accuracy and efficiency of supervisory practices and risk identification. The use of XBRL benefits filing organizations as well, because the now-standardized data can be easily validated and then used further for automated report generation and other common requirements.

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 and not familiar with XBRL syntax.

Let’s take a look at how EBA reporting tools can make it easier.

EBA XBRL from Excel

Read more…

Tags: , ,

Learn about XULE for XBRL


XBRL (eXtensible Business Reporting Language) is an open, XML-based standard for the electronic submission of business and financial data. Though XBRL specifies what data must be reported and provides a standardized way of doing so, companies and regulatory agencies need a way to ensure the quality of data that is submitted. One approach is by using business rule validation, and XULE is one method that is growing in popularity.

Read more…
Tags: , , , ,

Certified Tools for xBRL-JSON & xBRL-CSV


XBRL International has finalized the sunrise period for its important new OIM (Object Information Model), which includes the xBRL-JSON and xBRL-CSV standards. In turn, it has completed the software certification process. Any product awarded the XBRL Certified Software designation has been thoroughly tested by XBRL International for conformance with the current XBRL specifications.

OIM represents a years-long effort of the XBRL community to modernize the financial reporting standard, providing a model for easily transforming XBRL data between XML and other popular formats like CSV and JSON. This way, organizations can take advantage of the functionality of XBRL and at the same time have XBRL documents written in the format(s) most convenient for them.

Altova XMLSpy and RaptorXML Server were some of the very first tools on the market to support xBRL-JSON and xBRL-CSV and are now officially named XBRL Certified Software for the OIM standards (in addition to being certified for a variety of other core XBRL technologies).

Learn more:

Colleagues collaborating on computers in an office
Tags: , , , , ,

Working with Avro Big Data in Your Favorite XML Editor


Big Data trends have developers working with XML alongside other data protocols such as JSON and Apache Avro, and XMLSpy supports both of these with dedicated editing views and functionality.

Let’s see how specialized Avro support in XMLSpy makes visualizing and searching Avro files, as well as editing Avro schemas, uniquely easy. We’ll also look at some of the advantages of utilizing RaptorXML Server for high-performance Avro processing.

shutterstock_88166515

Read more…

Tags: , , , , , ,

How to Debug XSLT and XQuery


Nothing’s more frustrating than getting unintended results from an XSLT or XQuery transformation and having to spend hours tracking down the issue – especially if you’ve inherited the project from another developer or haven’t looked at the code in a few months.  Of course, XMLSpy has long included an XSLT debugger and XQuery debugger for setting break points and stepping through transformations to identify problems.

For a more interactive debugging process, XMLSpy also includes XSLT/XQuery back-mapping.

With back-mapping enabled, you can simply click on or hover over the portion of your output document you want to zero in on, and XMLSpy will immediately highlight the source XML and XSLT or XQuery instruction that is responsible. Let’s see how it works.

Debug XSLT with back-mapping

Read more…

Tags: , , , ,

Learn About OIM for XBRL


XBRL – the eXtensible Business Reporting Language – is a global framework for exchanging business information. The standard, maintained by XBRL International, is based on XML and designed to offer a standards-based approach to communicating and exchanging financial information between business systems.

The current version of the standard was finalized in 2003 and since then has received widespread uptake and eventual mandates from numerous countries and regulatory agencies, including the United States SEC. Adoption of the standard is due to advantages that include enabling automation and cost savings, better quality of reported data, improved analysis, and better quality of information used for decision making.

Despite its benefits, the complexity of XBRL presents a sharp learning curve for accountants and other stakeholders not familiar with XML, leading to errors and increased consultancy costs. In addition, coinciding with the adoption of big data technologies, XBRL has been used to represent ever growing datasets, which can be resource intensive.

XBRL International has worked over the years to modernize and simplify the standard in response to those challenges, and the Open Information Model (OIM) is an exciting and innovative solution.

Accountants learning about OIM XBRL
Read more…
Tags: , , , , , ,

NoSQL Database Support and More in Version 2022


Altova Software Version 2022 is now available, with exciting new support for mapping and converting NoSQL databases in MapForce, pure text report output in StyleVision, and Windows 11 across the product line. The release also adds support for the exciting new OIM standard from XBRL International.

Here’s a look at the highlights.

Read more…
Tags: , , , , , ,