XBRLizer allows the mapping of Excel to XBRL (and vice versa)
The XBRLizer, the XBRL editing tool of Reporting Standard, allows the mapping of any data source file to XBRL. In particular, it allows to export Excel to XBRL.
In order to do so, XBRLizer build the following set of files:
- The skeleton of a report from any existing taxonomy
- A blank model of the data source file.
- The file which provides the bindings between the data source and the report.
These three files allows to convert a data source filled with data into a valid XBRL file. Aditionally we can validate this data and provide a validation report of the generated XBRL file.
How to export from Excel to XBRL
1 – Generate mapping files
As follows, an example of the Excel exportation process of templates and their mapping from the menu archive from RS-XBRLIZER.
Then select the option generate formulas in Excel with sum of numbers with sign.
Once defined the wished features, select ok. In the next window define the filenames and folders where the Excel, and mapping files will be saved.
After generating the files, it will display a confirmation message regarding generation and location of the saved files:
2 – Fill the data of the finantial report in Excel
The mapper is installed as an Excel application and it will be visualized in the upper side of the tool:
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 and modified in each cell, such as currency unit, period and dimensions.
Once the financial data has been filled and the mapping adjustments have been completed, the XBRL report can be generated from the filled Excel. In order to carry out this task, we will use the mapping files of previous step.
3 – Validate the finantial report
Now we can make the necessary adjustments that assess the compliance of all validation rules before sending the XBRL report to the regulator. In this regard, the XBRLizer has the necessary validators (XBRL 2.1, dimensions, formulas…) to ensure its compilance. These validators will determine errors and inconsistencies which must be reviewed and corrected in order to send successfully a report free of errors.
Here is an example of a report of errors for review and correction:
In the bottom of the screen, we can see a validation section where report errors are disclosed. This validation report has a structure which include the found errors, and the description which will help to determine the actions to carry out in order to correct them. For reports imported from Excel, the tool will also display the cells of the Excel file which generated the validation error. We can also export this validation report to excel.