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.

Procedure to convert Excel to XBRL. First we generate the templates, then we fill them with data, and then we export to XBRL

Technical Architecture of the mapping process based on Excel templates.

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.

Select the option export to Excel from XBRLizer menu

Then select the option generate formulas in Excel with sum of numbers with sign.

Window where we can select the roles from XBRL we would like to export from Excel

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.

Window to set the filenames for the export files

After generating the files, it will display a confirmation message regarding generation and location of the saved files:

Window to confirmate template files have been created

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:

RS Mapper plugin inside Excel

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.

RS Mapper plugin is loaded. Mapping options of the plug-in

 

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:

Final output. The Excel has been exported correctly to XBRL report. We can see this report on XBRLizer. We can proceed with the valdiation process

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.