The XBRLizer tool can build a set of files containing: the skeleton of a report from any existing taxonomy, a blank model of the data source file (an Excel in this case), and the file which provides the bindings between the data source and the report.
These three files can be used again in XBRLizer+ to convert the data source filed with data (which can be done manually or through an ETL process) into a valid XBRL file and a validation report.
Technical Architecture of the mapping process based on Excel templates.
As follows, an example of the Excel exportation process of templates and their mapping from the menu archive from RS-XBRLIZER.
The Excel worksheet that will be exported are defined below, as the names to be assigned to the different worksheets, then select the option generate formulas in Excel with sum of numbers with sign.
Once defined the wished features, select ok and define the folders where the Excel, XBRLT and XML files will be saved.
Once the files were generated, it displays a confirmation message regarding generation and location of the saved files as it is shown in the pictures below.
The mapper is installed as an Excel application and it will be visualized in the upper side of the tool as it is shown below.
For working in the mapping of any financial statement or note, is necessary select the worksheet of the financial statement or note in Excel as in the XBRL Mapper view. At the Mapper section all the features can be observed in each cell, such as currency unit, period and dimensions.
The necessary files were generated with the Excel together for Mapping, once completed the financial data and the mapping adjustments made, the XBRL report can be generated automatically from the Excel completed.
Once the XBRL report is generated is necessary to make adjustments that assess the compliance of all validation rules before the XBRL report is sent to the regulator. In this regard, the tool has the necessary validators (XBRL 2.1, dimensions and formulas), those will determine errors and inconsistencies which must be reviewed and corrected in order to send successfully a report free of errors.
An example of errors reported for review and correction is shown below.
Common errors such duplicates and wrong totals can be seen very easy, and even highlighted the user can identify the exact cell or figures that produce the errors, which will be disclosed in the bottom of the screen in the validation section, also the tool has the property of exporting an error report to excel, and the report structure will include different types of errors, depending on findings, the description will help to determine certain actions to follow up in order to correct the error. For reports imported from Excel, the tool also displays the exact field providing information regarding the position into the file.
A report free of errors in the validation process is shown as following.