Really Easy Converter from Excel to iXBRL
Release dated 2018/12/15
The iXBRL instance document for City of Alexandria, VA, prepared by Allyson R. Ugarte – Sole Practitioner Member – using RECEiX has been selected for the webinar of XBRL US about CAFR. 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.
Download RECEiX Open Source program and HANDBOOK. Also RECEiXtest with additional dimensions & footnotes sheets.
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.
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 Taxonomy. Each 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.