XBRL y el entorno internacionalIgnacio Boixo
Relaciones internacionales, XBRL España
OPORTUNIDADES DE NEGOCIO EN EL AMBITO DE LA TRANSMISIÓN DE LA INFORMACIÓN FINANCIERA PARA EMPRESAS DESARROLLADORAS DE SOFTWARE
Red.es10 Noviembre 2011
Cell code vs. Dimensions
Location of activity: SpainAmount type: Outstanding
PrimaryItem: AssetsCategory of assets: Debt securitiesCounterparty sector: Monetary Financial InstitutionsOriginal maturity: ≥ 1 year < 2 yearCounterparty residence: SpainInstrument original currency: EUR
2
Data centric approach
3
?Data requirements
+ concepts definitions
Data exchange format:XBRL taxonomyData Model
analysis and audit
supervisor data
reporting entity
Data Modeler: ExcelXbrlGen
4
Excel add-in Open Source available at www.openfiling.info tools
Dimensional Reconciliation
5
FINREPECB Statistics
COREP
Collateral
Sector
Risk type
Impairment
Currency
Time intervals
Geographical areas
Percentage Intervals
Amount type
Approach
Entity code
Exposure type Securitization type
Main categories
Loan type
Amount interval
Minimum reserve
Transfer
…
Comprehensive income
Controlling/Non-controllingFair value level
Portfolio …
FINREPrev 2
Market
Ochocki, B. et al. (2011)
Dimensional Reconciliation extensibility
6
ECB Statistics
Percentage Intervals
Amount interval
Minimum reserve
COREP
Exposure type
Securitization type
…
FINREP
Collateral
Sector
Risk type
Impairment
Currency
Time intervals
Geographical areas
Amount type
Entity code
Main categories
Loan type
Transfer
Comprehensive income
Controling/Non-controllingFair value level
Portfolio
…
FINREPrev 2
Market
Portfolio
Approach/Model used
Approach/Model used
SOLVENCY II
Line of business
Type of business
Diversification
Type of contract
Change in basic own funds Type of claim …
Ochocki, B. et al. (2011)
Queries
7
by p
ortfo
lioby c
atego
ry
by counterparty residence
by original currency
by amount
by …
by counterparty sector
assets
SELECT SUM(factValue) FROM allFactsWHEREitem=″assets″ AND portfolio=″held-for-trading″ AND category=″derivatives″ ANDamount=″notional″ ANDctResidence=″uk″ ANDctSector=″credit institutions″ ANDoriginalCurrency=″eur″ ANDriskType=″commodity″ ANDmarket=″OTC″ AND…
24.320.223,54
888
NSAs Jurisdictions
Decisions Advice
….. …..Membership
Int’l
EuroFiling Collaborative Framework
Coop
erati
on
9
EU + XBRLEU + ?
XBRL/IFRS en ámbito internacional
10
Factores de la brecha digital
2011-09-08 Implementing an Harmonized Banking Supervision in Europe: the Way Forward 2004-2013 11
E-comercio
-
Ampliación EU
PNB total y per capita
+
+
Inversión extranjera
% I+D+
+
-
Modelo de implementación
12
Bank
IT BankingOperationsCounterpartiesCollateral… Instance
------------------------------------
Supervisor
IT Supervision
ReportsOther data……
Presentation, Analysis…
Bank operations, controls….
Basel IIIFRS
to XBRL from XBRL
Basel IIIFRS
File Transfer (National)
XBRL (Europe)
XBRL (National)
ErrorsErrors
Internet
National implementation
Europe
InstitutionConsultantsVendors
InstitutionConsultants
Vendors
Didactic model for explanatory purposes only
REGULADORES
Instance------------------------------------
INDUSTRIA
Retos tecnológicos
13
Degree of dimensionality (EU-issue) Degree of extension (US-IFRS issue)• Role (schedule) identification• Concept identification (or misuse)
Formula support (IFRS next year) Versioning support (IFRS and SBR) Table LB support (EU next year)• No more presentation linkbase
Model-centric taxonomy design (EU now)• versus Form-centric taxonomy design
Buy now, suffer later
14
Need to maintain for a very long timeNeed products up to date for long future• XML changes (or fixes bugs) steadily• XBRL changes (or fixes bugs) steadily• Annual regulatory, taxonomy & validation changes
Life beyond corporate transitions and changes• Maintenance independent of owner changes
Life beyond key personnel changes• Complexity impact on future maintainability• Is Academia involved
Life beyond platform changes (server, desktop)
Descargas Código Abierto
15
Product Category Date Count
Rivet Dragon View Viewer (txmy & inst) 2008-07 66
UBMatrix XPE 2.5 XBRL Processor (old, pre-XDT) 2007-01 50
Java XBRL API XBRL Processor 2011-06 45
CodeXBRL (.Net & Java) GL Processor 2009-06 27
Rivet Dragon Tag SEC filing creator 2008-07 25
API Lenloc/Penloc Instances in Lenloc 2010 2011-06 24
Data Modeler Taxonomy creator 2011-07 18
Taxonomy Generator Taxonomy creator 2005-06 12
Batavia XBRL Library XBRL Processor 2007-10 11
IFRS Modules Mgr Browse and combine mduls 2009-04 11
Inline XBRL extractor Inline to XBRL instance 2010-05 10
XBRL Core Java to edit XBRL 2007-01 6
XBRL Composer DTS compilation 2005-04 2
API Taxonomia Library 2011-07 1
16
2011: Common dimensions for Solvency, Financial, Statistics2012: New Solvency and Financial XBRL taxonomies2013: European harmonized framework go live!
Top Related