XBRL Mapping

XBRL mapping in Altova MapForce

MapForce XBRL Features

MapForce supports using XBRL taxonomies as the data source or target structure for any mapping. Mappings to XBRL taxonomies can be used to extract financial data from accounting systems for reporting and disclosure, while mappings from XBRL taxonomies with associated instance files can be used to integrate data for financial analysis. MapForce XBRL support includes:

  • XML data to/from XBRL
  • Database to/from XBRL
  • Flat files to/from XBRL
  • Excel to/from XBRL
  • Web services to/from XBRL

Download Trial

Efficient Financial Reporting

Extensible Business Reporting Language (XBRL) is an XML-based markup language for electronic transmission of business and financial data. With a mandate from the United States Securities and Exchange Commission (SEC), and official support from European Parliament as well as the governments of Japan and China, XBRL aims to reduce costs through the elimination of time consuming and error-prone human interaction. The introduction of XBRL tags allows computers to process information independently, thus increasing the speed of data integration and exchange, while at the same time virtually eliminating data redundancy and quality issues.

MapForce supports the use of XBRL taxonomies as the source or target of any mapping, enabling you to graphically transform backend accounting data into a compliant format without any risk to its semantic or structural integrity and/or integrate reporting data for financial analysis. Support for code generation in Java, C#, or C++ means that you can also automate the conversion of financial data based on the graphical mapping design. This makes public financial data submission a repeatable and highly manageable process, allowing you to produce valid XBRL reports as required based on the variable data stored in accounting system fields.

Developing XBRL Mappings

To develop an XBRL mapping based on an existing taxonomy, simply insert your taxonomy structure in the MapForce design pane. MapForce will display a graphical representation of the file structure, depicting taxonomy concepts, hypercubes, abstract elements, periods, identifiers, etc. with intuitive icons.

The XBRL component takes structural and semantic information from the associated linkbases and is presented in a hierarcy that can be easily interpreted, expanded or contracted as needed.

Once you have set up your source and target mapping components in the MapForce design pane, complete the mapping by simply dragging connecting lines between the components and inserting additional operators for more complex conversions.

Filtering and Processing XBRL Data

MapForce provides flexible support for filtering and processing data via advanced processing functions based on Boolean conditions or manipulating data as it’s converted from source to target format.

For example, because XBRL data is essentially flat, it is often necessary to apply grouping functions that combine source data into groups and then further process those groups to transform the data into a hierarchical structure. This is facilitated by grouping functions in the MapForce function library.

XBRL mapping output in Altova MapForce

Next Steps