tying xbrl gl to fr: xbrl mappings, transformations and queries across the reporting supply chain...
TRANSCRIPT
![Page 1: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/1.jpg)
Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain
Thomas Klement, XBRL Germany, [email protected] Schmitt, IASCF, [email protected]
![Page 2: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/2.jpg)
Agenda• Introduction• Scenario• Domain issues• Technical issues• Mapping and query basics• Evaluation results
![Page 3: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/3.jpg)
Current situation“Gap between financial reporting information and originating data sources”
The reasons are– High degree of aggregation versus bulk data– Complex processing rules – Heterogeneous data models– Various data exchange formats– Few experience with use of standards
![Page 4: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/4.jpg)
Objective• How can standards help bridging the gap?
– Existing XML standards– Upcoming XBRL standards
• What standards are needed?– XBRL import/export– Validity checking– Inter-XBRL mapping– XBRL Transformation– XBRL querying
![Page 5: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/5.jpg)
XBRL Capabilities ─ Scenario: Corporate Group Reporting
XBRL GL
DimensionalTaxonomy
internalFR Taxonomy
externalFR Taxonomy
![Page 6: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/6.jpg)
Will XBRL Become an Enabling Technology for Backwards Discovery?
![Page 7: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/7.jpg)
What standards are available?
• XBRL– XBRL FR– Dimensional
Taxonomies– XBRL GL– Formulas– Generic Linkbases
• XML– SQL/XML– XML for Analysis– XPath– XSLT– XQuery
![Page 8: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/8.jpg)
Example:
Storage, Processing and Transition
GL FR FR
ERP XML DB
![Page 9: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/9.jpg)
Main problems
• Cross-system transitions
• Bi-directional mappings
![Page 10: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/10.jpg)
Makes Consolidation Bi-directional Mappings Impossible?
• Individual company closing– Period initialisation– Carry-over– Compilation– Validation– Reconciliation– Allocation– Reclassification– Currency conversion– Validation
• Concolidated financial statement– Changes of consolidation
scope– Elimination of inter-company
profit and loss– Group summation– Reclassification– Consolidation of investments– Validation
![Page 11: Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de](https://reader036.vdocuments.us/reader036/viewer/2022062407/56649e4f5503460f94b470c2/html5/thumbnails/11.jpg)
Transition Approach and Evaluation Results
For further information check
http://www.xbrlopen.org/abra/xbrltransitions.pdf