Open community of practice for filing and XBRL with Open Source
Header image

iXBRL

 

RECEiX: Really Easy Converter from Excel to iXBRL

FULLY OPEN SOURCE: Download RECEiX.xlsm Open Source program and HANDBOOK. Last update 2025-07-07. (If troubles, try to download as RECEiX.xlsb or RECEiX.zip)

Open Webinar Monday, 30th October 2018 – 15:00-16:00 CET. See the video record and the presentation slides.

Javier Mora, XBRL senior expert. Javier.Mora@xbrl.org.es
Ignacio Boixo, Openfiling Association, Founder. boixo@easyesef.eu

Download Libre RECEiX running with LibreOffice (the open source alternative to Excel) for the example of City of Alexandria. Demo in the Eurofiling Conference 2019


MiCA
Markets in
Crypto-Assets

(Example of use of RECEiX by ESMA in MiCA 2023) https://www.esma.europa.eu/document/mica-white-papers-poc MiCA white papers PoC

In order to allow market participants to familiarise themselves with Inline XBRL, ESMA makes available a Proof of Concept (PoC) illustrating a concrete application of the proposed format requirements included in the draft Implementing Technical Standard (ITS)

An Excel converter into Inline XBRL, which displays how it would be possible to create an Inline XBRL file without the use of complicated software tools (in this case, using a simple Macro in an editable Excel)

Stakeholders are invited to download the Excel converter (content may need to be enabled) and test how it can be easily customised by including new content in column “C” and transformed into an Inline XBRL document by clicking on the “Generate iXBRL output” icon. This will generate a new xHTML document reflecting the edited content.


MiCA Taxonomy Illustrated

Author: Ignacio Boixo boixo@easyesef.eu Version 2025-09-17
Original MiCA taxonomy (target date 2025-03-31) published at: esma.europa.eu/document/mica-taxonomy-2025
Inspired in the description of what is a Taxonomy Illustrated: www.ifrs.org/issued-standards/ifrs-taxonomy/ifrs-taxonomy-illustrated/
Inspired (some elements reused) from ESEF Taxonomy Illustrated: www.openfiling.info
Developed reusing the Open Source easyREADER, by easyESEF Ltd: easyesef.eu/resources
Published by the Eurofiling Foundation at: www.openfiling.info/ixbrl/
Free download (Excel without macros) from: www.openfiling.info/wp-content/upLoads/data/MiCA_Illustrated.xlsx

Disclaimer: This Taxonomy Illustrated is NOT an official publication of ESMA or any other Entity. It is a voluntary, uncompensated, open contribution by author & publisher:
IF YOU DOWNLOAD IT, YOU DO SO AT YOUR OWN RISK ONLY.


XBRL US webinar about CAFR The iXBRL instance document for City of Alexandria, VA, prepared by Allyson R. Ugarte – Sole Practitioner Member – using RECEiX has been selected and explained in this video ww.youtube.com/embed/MNEIAu07qz4?start=703. This is a Demonstration Release Taxonomy representing selected portions of the Comprehensive Annual Financial Report (CAFR) used by state and local governments to report financial data. According to XBRL International, CAFR demo shows the potential for State-Level Structured Data.


ABSTRACT: The Really Easy Converter from Excel to iXBRL (RECEiX) is an Excel proof-of-concept open source tool with an input of Excel spreadsheets and an output of (a) the corresponding extended XBRL taxonomy and (b) the corresponding iXBRL and XBRL documents. RECEiX fully follows the XBRL specifications, as inline XBRL, Dimensions and Taxonomy package, as well as Anchoring draft.
The iXBRL document can be displayed using whatever Internet browser (Microsoft Explorer, Mozilla Firefox, Google Chrome…) with the same layout that the Excel spreadsheets. The iXBRL document can be also processed by whatever XBRL processor, as Arelle open source suite, Openfiling iXBRL extractor, or any other XBRL tool. .

OBJECTIVES: The first objective is didactic, for software developers when creating iXBRL documents and extended XBRL taxonomies from scratch. The second objective is providing empirical evidence, for reporting entities and regulators, about iXBRL generation and consumption. The third objective is contributing to the European Securities and Markets Authority (ESMA) efforts on the European Single Electronic Format (ESEF), according to the European Parliament decisions about transparency in financial markets.

REQUISITES: Any Microsoft Excel version with VBA enabled. Stand alone: Internet is not required.

NEW FEATURES: This release is ESEF compliant, covering the most relevant requirements of the ESEF reporting manual, such as embedded images, multilanguage, LEI and footnotes, among others. Next releases will complete the remaining ESEF requirements as well as the new ones when published. See a 30′ webinar demonstration at  www.eurofiling.academy.

iXBRLextractor: Generic extractor from iXBRL to XBRL and Excel

Download this iXBRLextractor to XBRL and Excel as a simple Excel flat spreadsheet, with a VBA program of 1200+ lines. Click the button and select your input  iXBRL file: the VBA will extract for output file the corresponding XBRL instance document, while showing the content (the facts) in the spreadsheet. The errors detected are show in the screen and listed in a spreadsheet. iXBRLextractor  is GENERIC and not dependant of any XBRL taxonomy.

FUTURE FEATURES:  iXBRLextractor will include ESEF reporting manual elements and validations.

This iXBRLextractor released 2018-01-22 follows the iXBRL recommendations  Inline XBRL 1.1 and Transformation Registry 3 (versions 1 & 2 also included). NOT YET IMPLEMENTED: Some ESEF elements [ix:footnote | ix:relationship | xml:lang], some less used elements, and some formats [ixt:boolean  /  ixt:dates not having year &  month & day or using Asiatic features]. Tested with the Conformance Suite 2017-10-11  BUT not all tests are yet passed.

AnchoringExtractor: extract the Wider-Narrower ESEF roles from a Definition Linkbase

About the European Single Electronic Format (ESEF)

In the Field Test for the European Single Electronic Format (ESEF) of the European Securities and Markets Authority (ESMA) the output format is iXBRL based in the ESEF TaxonomyEach example is provided as an iXBRL file (in both versions, with and without iXBRL viewer) and the corresponding XBRL instance document.

The iXBRLextractor has been tested with these ESMA examples. The rationale is show how a simple iXBRL extractor can extend the current reporting frameworks based in XBRL for input files also in iXBRL, without other modifications.

Both RECEiX and iXBRLextractor are open source and operational, delivered by the Openfiling Team of volunteers for ESEF testing.

Arelle is warmly recommended as a much more complete generic solution, but its use requires a bit of knowledge.

The only other iXBRL open source  is an XSLT-based generic tool, inlineXBRL Extractor (https://sourceforge.net/projects/inlinexbrl/), developed in 2009 by Evan Lenz and Diane Mueller for XBRL International, with Apache License V2.0. Please note that this project is no longer being actively maintained, and this extractor does not support Inline XBRL v1.1, or more recent versions of the Transformation Registry. 

Copyright (mandatory citation).

The design of the RECEiX concept, the development of the proof of concept, and the publication of the results are an intellectual property of the authors, version dated 2018-10-07, and working in most cases out of business hours and in weekends.
The authors hereby grant a license Creative Commons BY (Creative Commons Attribution 4.0 International License), hence expressly requesting their attribution, as moral authorship right.

no