Taxonomy Builder
Product page
Description
The DTS Builder from Excel file is a tool that converts Excel files into XBRL Taxonomies. Reporting Standard believes that Excel + the Taxonomy Definition language developed by Reporting Standard is the perfect combination for taxonomy building in all possible scenarios as has been demonstrated all around the globe in several projects in different countries.
The following sections in the wiki are an introduction via examples to the capabilities of the DTS Definition Language and the implementation in Excel.
Benefits of using Excel rather than a general purpose Taxonomy Editor
Among several benefits, here are just a few of them:
- Excel is a flexible data container. The user is free to add documentation, colors, formulas and whatever the user considers for the purpose of better documenting and keep track of the issues during the taxonomy development phase.
- Excel files are understandable by XBRL experts and non XBRL experts. This means that non XBRL Experts but business experts can provide useful feedback during a Taxonomy development project.
- The implementation defined by Reporting Standard is based on two things: common table structures and a DTS definition language that allows technical experts to do even more things that they can do with other taxonomy editors in the markets
- The Excel Based Taxonomy Builder is the most simple and flexible way to develop high quality XBRL taxonomies as it allows you to be consistent in your taxonomy creation and concentrate in the important things rather than in the geeck technical details that provides no value
Examples
During this on line training we are going to create a taxonomy for Google financial statemens as they are published in Google web site.
Download the [Google.xls] Excel spreadsheet that contains the taxonomy definition.
- The Excel document contains 4 sheets, but only 3 contains relevant data for the taxonomy building process. Excel allows the user to add additional sheets for documentation purposes. The user can also use coloring on cells and formulas in order to build the taxonomy in a consistent manner. We will see examples on this later.
- The Documentation sheet contains just documentation
- The Main sheet contains the presentation, calculation and definition linkbases definition
- The Concepts sheet contains a table with concepts definitions that are referenced in other places
- The DTS sheet contains the DTS definition language
- The DTS definition language is where the tool starts building the Taxonomy.
The DTS definition language is a instructions based language where an instructions identifies something to do. Some instructions encapsulate other instructions as it is the case of the BOT (Beginning Of Taxonomy) - EOF (End of Taxonomy) instructions. The instructions has parameters and the instructions and the parameters gives the user the possibility of structuring the Excel content in the way the user wants (there is no need to have a Concepts sheet or a Main sheet)
