Track 3 interactive data sharing thomas verdin dirk tuymans sascha heinig wednesday 18 may 2011
Sponsored Links
This presentation is the property of its rightful owner.
1 / 26

Track 3 “Interactive Data Sharing” Thomas VERDIN, Dirk TUYMANS, Sascha HEINIG PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

22 nd XBRL International Conference “Sharing Economic Information in a Global World: the XBRL Contribution” 17-19 May 2011 Brussels, Belgium. Track 3 “Interactive Data Sharing” Thomas VERDIN, Dirk TUYMANS, Sascha HEINIG Wednesday, 18 May 2011. The xEBR WG a network of Business Registers.

Download Presentation

Track 3 “Interactive Data Sharing” Thomas VERDIN, Dirk TUYMANS, Sascha HEINIG

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

22nd XBRL International Conference“Sharing Economic Information in a Global World: the XBRL Contribution”17-19 May 2011Brussels, Belgium

Track 3

“Interactive Data Sharing”


Wednesday, 18 May 2011

The xEBR WG a network of Business Registers

Purposeincrease the coordination and interoperability for XBRL efforts and taxonomies for European Business Registrars and company information providers

Scopeall economic and legal data for companies operating or registered in the European Union :company ID, financial statements, other economic & legal data

Deliverablesoverview of existing material, common & best practices, generic taxonomies and all other exchanges between members about XBRL


  • Interconnection of the Business Registers in Europe



Use of XBRL for the Bundesanzeiger

Interoperabilitywith BACH scheme


XBRL EuropeBusiness Registers in Action

Interconnection of Business Registers

European Commission proposal

Core Reference Taxonomy : xEBR

More interconnection & exchanges


Localization thanks to interconnection

European Commission Initiative



Proposal for a


amending Directives 89/666/EEC, 2005/56/EC and 2009/101/EC as regards the

interconnection of central, commercial and companies registers




Facilitate access to economic and legal information regarding companies in Europe

Draft Directive

Core Reference Taxonomy


Overview of the xEBR Taxonomy




Financial statements

Company Profile/ID

Common Taxonomy Elements

xEBR Taxonomy V2


  • Vocabulary (MONNET)

  • Additional infos (THEIA)

  • Consistence with ECCBSO (BACH)


  • XBRL is the best standard for a Common Reference

  • One connecting structure presented as a taxonomy

    • Interconnecting with presentation linkbases of local taxonomies

xEBR Taxonomy V3


xEBR Taxonomy V4


Technical Adjustments

xEBR Taxonomy V5

xEBR for interoperability

  • Mapping:

    • For cross-border rendering

    • For cross-border ratios

    • For cross-border transfers

  • Use Cases:

    • Cross-border rendering, financial statements

    • Cross-border ratio on multiple taxonomies

    • Cross-border storage of EU taxonomies and instances

Monnet Project


  • Interconnection of Business Registers in Europe

  • 3


  • Use of XBRL for the Bundesanzeiger

Links between xEBR and BACH/ESD


Links betweenxEBR and BACH/ESD

  • Initial idea on company key figures

    • +/- 55 variablese.g.: "land and buildings", "operating income"

    • national concepts expressed in codes and labelse.g. for BE: 44 "trade creditors"NL: handelsschuldenFR: dettes commercialesDE: Verbindlichkeiten aus Lieferungen und Leistungen

    • interoperability established by using information in national reference linkbase

    • relationship with national concepts, 7 reference termse.g. "broader than", "sum of", "close to"

Links betweenxEBR and BACH/ESD

  • But "sharing information" also means reusing existing structures, data and methodologies

  • Qualitative work done by ECCBSO:European Committee of Central Balance-Sheet Data Offices

    • BACH: Bank for the Accounts of Companies Harmonized

    • ESD: European Sectoral references Database


Links betweenxEBR and BACH/ESD

  • BACH provides annual accounts statistics

    • for non-financial enterprises for 9 EU countries

    • for at least 10 financial years (from 2000 onwards)

    • for 95 major harmonized items of

      • assets and liabilities

      • profit and loss account

      • notes

    • the business sectors correspond to the NACE rev. 2 breakdown into divisions (2 digits)

    • 3 different size classes

    • either a variable sample or a sliding sample over 2 years

Links betweenxEBR and BACH/ESD

  • Advantages of reusing BACH variables

    • harmonization of definitions xEBR - BACH

    • transition table between (European) harmonized items and national codes already done for 9 EU countries

    • micro-economic information from XBRL instance documents can be compared with sectoral information from BACH database

Links betweenxEBR and BACH/ESD

  • State of affairs on company key figures

    • 102 variables including all 95 BACH items

    • relationship between concepts uses SKOS (Simple Knowledge Organization System) reference terms

      • exact match: national concept is exactly equivalent

      • narrow match: national concept is more specific

      • broad match: national concept is more generic

    • mapping has been prepared for several business register taxonomies (BE, DE, FR, IT, ...)

Links betweenxEBR and BACH/ESD

  • ESD contains financial ratios

    • for non-financial companies for 8 EU countries

    • for 28 ratios

      • operating cost, earning and profitability

      • working capital

      • financial income and charges

      • assets and liabilities structure

    • shown in quartiles

    • differentiated by NACE rev.2 codes (2 digits)

    • 4 different size classes

Links betweenxEBR and BACH/ESD

  • Advantages of using ESD information

    • ratios are based on concepts from BACH database

    • sectoral benchmarks by comparing the financial performances of single firms derived from XBRL instance documents with its respective sectoral and size aggregate from ESD database

    • consistent and comprehensive figures to credit institutions for their credit risk analysis


  • Interconnection of the Business Registers in Europe



Use of XBRL for the Bundesanzeiger

Interoperabilitywith BACH sheme


Use of XBRL for the Bundesanzeigere-federalgazette in Germany

Main Tasks:

  • checking of completeness and filing in due time (§ 329 HGB) (4 Month - 1 Year)

  • transformation of heterogeneous data into a standardized internet format

  • transmission to Business Register

    • peak season December – February

  • reporting about none and late filing to Ministry of Justice (fines from € 2.500 up to € 25.000)

Use of XBRL for the BundesanzeigerXBRL - data sources

  • 1.1 m. annual accounts per year

  • 55% unstructured

  • currently accepted filing formats

    • legal gazette

      • XML / XBRL

      • MS-Office

      • PDF

      • paper (till 2009)

    • Business Register

      • XML

      • PDF (as a service)

        Filing mainly in XML / XBRL

    • price

    • usability

Filing to the federal gazette in 2010

Use of XBRL for the BundesanzeigerXBRL – data harmonization

  • Harmonization process

  • transformation from different data sources to XBRL

  • mutli-level quality testings

  • branch- and sectoral specific information (WZ08)

  • result: harmonized data sets for further processing

Use of XBRL for the Bundesanzeiger- case studies for the use of XBRL data -

  • Own products

    • business portal „Firm Extra“

      • ratios

      • benchmarks

        • region

        • branch

        • companies sizes

      • company profiles

      • company monitoring

    • solution provider - data selling

Use of XBRL for the Bundesanzeiger- case studies for the use of XBRL data -

  • Known partner products

    • rating agencies

      • ratings

      • scorings

      • benchmarks

  • information-provider and –refiner

    • ratings

    • benchmarks

  • credit assurances

    • credit risk management

    • solvency statements

    • risk monitoring

  • Use of XBRL for the Bundesanzeiger- future opportunities -

    • Activities planned to raise our XBRL quota

      • introduction of XBRL forms for filing annual accounts

      • promotion of XBRL to software providers for tax accountants

      • solution provider for “E-Bilanz” XBRL

    • Future objective

      • Achieving a real Business register interoperability

        through the usage of XEBR-structure with EU-wide branch specific benchmarks

    Questions & Contacts

    Dirk TUYMANS

    [email protected]

    Sascha HEINIG

    [email protected]

    Thomas VERDIN

    [email protected]

  • Login