XBRL Taxonomy Builder

/XBRL Taxonomy Builder
XBRL Taxonomy Builder2018-07-23T18:43:34+00:00

Traditionally there are two approaches for taxonomy building

– Use taxonomy editors (Other’s solution)

A ”taxonomy editor” is a computer program that allows you to open a DTS (Discoverable Taxonomy Set) and change the file contents in a user interface

– Use taxonomy “builders” (RS solution)

A “taxonomy builder” is a tool that takes an input and transforms it into a DTS (Discoverable Taxonomy Set) means, the files are generated from the input

Taxonomy Editors

  • They target Business users or IT users but not both

  • Users need to know all the details about the XBRL Syntax in order to use them properly

  • Cannot perform bulk changes such as change the date of all files in the DTS due to a new taxonomy version

  • Cannot be used programmatically to perform validations on element names

  • Cannot add metadata to the DTS files and use that metadata later. All documentation must be in separate documents

  • The user interface and capabilities are rigid and changes requires to contact the software vendor or implement them separately

  • There are areas of the XBRL that cannot be achieved with current Taxonomy Editors such as embedding linkbases inside taxonomy schemas

Taxonomy Builder

  • They can be used by IT and Business users because they are based on Excel files that are common to both types of users

  • Users with IT knowledge focus on specific parts of the Excel and users with Financial background focus on the financial aspects of the taxonomy in a user interface that is familiar to them

  • As Excel allows to use formulas to define the value of a cell, performing bulk changes is easy. For example, if the taxonomy date is in one single cell. A change in that cell might change all file names and directories

  • As Excel allows for complex formulas and can even use modules in other programming languages, it is possible to use that power to perform complex quality checks on the Excel content and evaluate the results to improve the taxonomy quality

  • In Excel, it is possible to add notes to cells, and tag the cells with colors so it is easy for users to see what is OK, what is pending what was rejected etc… It is possible to document the reasons of why for every single piece of information

  • Excel is flexible by nature

  • Our Taxonomy Language covers all aspects of the XBRL specifications and it is Extensible for new instructions in Java modules

The XBRL Taxonomy Builder tool is a fully functional tool and powerful tool to develop XBRL taxonomies from Excel files.

The XBRL Taxonomy Builder is divided in two parts:

The first part is the taxonomy content. This is composed by the data dictionary, the relationships between the elements in the data dictionary and the resources like references and labels. All that information is stored in Excel sheets in a comprehensive format that allows non IT users to introduce, change and review it without deep knowledge about XBRL. For example, the definition of XBRL dimensions using excel templates is according to the business model designed by the Bank of Italy for the COREP taxonomies (Matrix Schema). That model is also used inside BdI for the definition of multidimensional databases.


The second part is a language for creating the DTS (Discoverable Taxonomy Set). The language is used to specify the modular structure of the files that will constitute the DTS. The language contains references to the content (data dictionary, labels, references, presentation links, calculation links and dimensions…). The language can be used to specify different modular approaches for the same content in the Excel sheet.

The Excel Taxonomy Builder accelerates the process of creating an XBRL taxonomy because it eliminates the barriers for new comers. You’ll learn XBRL just by using Excel. Taxonomy development has never been something so simple.

At the same time. Taxonomy Builder allows the creation of high quality taxonomies because the revision of the taxonomy content can be executed by non XBRL experts that normally don’t know XBRL at all.

The XBRL Taxonomy Builder is an external tool to Excel that interprets the DTS creation language and access the Excel content in order to create the taxonomy set

This taxonomy builder has been used by the Superintendencia de Valores y Seguros de Chile in order to create an extension of the IFRS 2006 taxonomy in order to make it corresponds to the IAS published in the 2007 Bound Volume.

Benefits of using Excel for XBRL Taxonomy Building

It is a true fact that none of the high quality and high visibility XBRL taxonomy development projects are based on just one single XBRL Taxonomy editor. It is also true that none of those projects could be created without the right balance between what business people can do for the project and what IT people can do for the project. In fact, every XBRL project is a combination of a team work.

There are several aspects to consider when running an XBRL Taxonomy development project

The XBRL expertise is too technical (and not needed) for business users. Business users are keen to work with Excel.

  • Excel allows for all kind of documentation (coloring, comments, additional sheets).
  • All business experts are able to understand an Excel spreadsheet and provide useful comments without any notion of what XBRL is about.
  • Inside the project team, Communication between IT experts and Business experts in key for the project quality.
  • A tool that maximizes communication must be a tool that business experts and IT experts can understand.
  • Excel allows for better Taxonomy modularization approach or even test multiple serialization strategies.
  • Excel allows for using formulas (Excel formulas) to achieve higher levels of consistency in the taxonomy content Search capabilities on Excel are (by far) more powerful than search capabilities on any other taxonomy development tool Excel is a true team work tool.
  • Multiple people can work on the same Excel workbook simultaneously.

By contrary, Taxonomy development tools using a GUI are fine for doing simple prototypes very fast. Reporting Estándar S.L. clients uses both, XBRLizer for taxonomy viewing and Excel to XBRL Taxonomy builder for the taxonomy development.

On this link you can see how the Chilean SVS (Stock Exchange Supervisor) is using Excel to XBRL Taxonomy Builder for helping Chilean companies to prepare taxonomy extensions of their own SVS Taxonomy (The page content is in Spanish language)

The process is as follows:

  1. Business users download an Excel Workbook (The workbook contains a visible part and a hidden sheet)
  2. Business users fill-in the data on the visible part of the sheets.
  3. This will automatically modify the instructions for generating the taxonomy extension so Reporting Estándar Taxonomy Builder can read the excel and generate the taxonomy.
  4. Business users don’t need to know anything about XBRL The process is fully automatic and simple for business users
  5. It is live, in production, generating taxonomy extensions of IFRS 2010 extended by the Chilean SVS.