How To Create A Taxonomy In Excel

143/148

Tagging Cells in the Taxonomy Template

You must select a cell or multiple cells before tagging. For applying tag, you need to scan each cell in the template and need to know the following information:

What type of the tag that you should apply
What are the parameters to apply tags

The recommended order of tagging is as follows:

First, you need to tag Data element cells
Later, you need to tag Header element cells such as: Concepts, Dimensions, Context and Units
Lastly, you need to tag Table element cells such as: Table Begin and Table End

Note:

If you follow the order, then you can avoid tagging issues at the time of validation.

After applying the tags, you can validate the tags, either using Arelle or Regulator.

Applying Tag to Cells in the Taxonomy Template

To apply tag for a cell or range of cells in the Taxonomy template, perform these steps:

Download the Taxonomy template from Taxonomy Landing Page.

Note:

From Taxonomy landing page, you need to select a required taxonomy template.

Taxonomy templates or Microsoft excel templates are defined based on industry code. For example: Bank of Colpatria has a code: 001 BANCOS, Promigas has a code: 261 SERVICIOS PÚBLICOS DOMICILIARIOS.

Using Microsoft Excel, open a Taxonomy template, and then select a cell or range of cells to apply tag.
In High Volume XBRL ribbon, select .

The Auto Tag Cell dialog box is displayed.

Select the required tags such as: Data, Header, or Table tags for each cells in the Taxonomy template.

Note:

While tagging range of cells, out of the all contexts, the default context is displayed on the top of the drop-down list. Similarly, out of all the units, the default unit is displayed on the top of the drop-down list.

After applying tag to each cell in the worksheet, and then click OK.

You need to follow these rules and apply the respective tag to each cell:

SL No	Tag Name	Tag Description
1	Data	This defines that the cell is a data cell. Tag Type: #DATA comment in the cell. The Negate sign allows to flip the sign of the numeric cell, thus the different sign is generated in the XBRL instance. By default, Negate sign attribute is set to false. This tag is used to flip the sign of a value. If set to true, the value will be flipped. For example: If the value is 500, then the value is reported as -500.
2	Concept	This labels a cell as a concept header. Tag Type: #CON comment in the Excel cell.
3	Context	This defines the context of the cell. Tag Type: #CTX comment in the cell.
4	Unit	This defines that the cell is represented as a unit, such as: 'shares' , 'pure' , or "USD". Tag Type: #UNT comment in the cell. Optional : The unit parameter such as: "decimals" and "scaling" can be defined in the #UNT tag. For example: #UNT($cop,decimals="3",scaling="-3") Note: If decimals or scaling attributes are not defined, then the default values are taken from the DEI worksheet.
5	Dimension	This defines that the cell is an explicit dimension label. Tag Type: #DIM comment in the cell.
6	Table Begin	This marks the beginning of a table. This tag is used to delineate a clear section in the sheet, either tag can be beginning of a table or text blocks. Tag Type: #TABLEBEGIN comment in the Excel cell.
7	Table End	This marks the ending of a table. This tag is used to delineate a clear section in the sheet, either tag can be table ending cell or text blocks. Tag Type: #TABLEEND comment in the Excel cell. Either #TABLEBEGIN or #TABLEEND tag can be applied, but not both for same cell.