110 likes | 279 Views
Tying XBRL GL to FR: XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de Harald Schmitt, IASCF, hschmitt@iasb.org.uk. Agenda. Introduction Scenario Domain issues Technical issues Mapping and query basics
E N D
Tying XBRL GL to FR:XBRL mappings, transformations and queries across the reporting supply chain Thomas Klement, XBRL Germany, thomas.klement@xbrl.de Harald Schmitt, IASCF, hschmitt@iasb.org.uk
Agenda • Introduction • Scenario • Domain issues • Technical issues • Mapping and query basics • Evaluation results
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
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
XBRL Capabilities ─ Scenario: Corporate Group Reporting internal FR Taxonomy Dimensional Taxonomy external FR Taxonomy XBRL GL
Will XBRL Become an Enabling Technology for Backwards Discovery?
XBRL XBRL FR Dimensional Taxonomies XBRL GL Formulas Generic Linkbases XML SQL/XML XML for Analysis XPath XSLT XQuery What standards are available?
GL Example:Storage,Processing and Transition FR FR XML DB ERP
Main problems • Cross-system transitions • Bi-directional mappings
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
Transition Approach and Evaluation Results For further information checkhttp://www.xbrlopen.org/abra/xbrltransitions.pdf