xbrl europe week june 1, 2012 - madrid, spain practicing xbrl formulae in the bank of spain...
TRANSCRIPT
XBRL Europe weekJune 1, 2012 - Madrid, SpainPracticing XBRL Formulae in the Bank of Spain
Speakers: Víctor Morilla Moira Lorenzo Manuel Rodríguez
• WHAT DID WE DO?
• WHAT DO WE DO?
• HOW DO WE DO?
• Methodology
• Time & Team
• CONCLUSIONS
XBRL Formulae in Bank of Spain
WHAT DID WE DO?
Before (from 2005 to Summer 2008)
Sender
XBRL instance
Before (from Summer 2008 to March 2012)
XBRL FRONT-END
XBRL Instance
(only valid instances)
Facts in XBRL instance
Validations against information in a database Ex: previous periods
XBRL Basic validations & calculation linkbaseEx: A=B+C A=B+2C
1
LegacyDatabase
5%
Business rules – No XBRL validations
2Ex: A = B * C Si A=0 => B = 5*C/D
80%
315%
Sender
XBRL instance
XBRL FRONT-END
XBRL Basic validations 15%
Business rules – XBRL Formulae validations
XBRL Instance
(only valid instances)
Facts in XBRL instance
Validations against information in a database Ex: previous periods
LegacyDatabase
Business rules – No XBRL validations
2Ex: A = B * C Si A=0 => B = 5*C/D
80%
315%
Errors report
Errors report
Sender
XBRL FRONT-END
Errors report
100%
WHAT DO WE DO?
Now
XBRL instance
XBRL Basic validations 1
Business rules – XBRL Formulae validations
Facts in the same XBRL instance
Validations against information in a database:• Other XBRL instances• Atributes• External information
2
3
XBRL Instance
(only valid instances)
HOW DO WE DO? - Methodology
Business rules Analysis
(1) Described in terms of reports cells
(2) Rules classification and encoding
Consistence asertions, value asertions and existence asertions
To unify: One formula resolves many rules
(3) There is information contained in several instances
(4) Threshold and rounding (concepts monetary in thousands of euros)
Developing linkbase & testing(including developing errors message)
Documentation & services
Documents Reference numbers
& classification
Formulae linkbase
Formulae Linkbase + corrected
Bussines rulesAnalysis
Developing linkbase
Instance generation
& testing
+Services
Training DebuggingAnalys DevelopmentTest
HOW DO WE DO? – Time & Team
About 400 XBRL Formulae for 3.400 business rules
About 120 working days = 5,5 months/person
(analysis, development and testing)
3,5 XBRL Formulae/day/person
40 %30 %
30 %
Training DebuggingEffective work
About 75,000 XBRL Formulae (most of them automatically migrated from the legacy sistem)
About 100 XBRL formulae in 8 days/person
(analysis, manual development and testing)
12,5 XBRL Formulae/day/person
2 % 5 %
33 %
40 %
20 %
First steps (COREP project in 2008) Now
40 %
30 %
30 %
CONCLUSIONS
All Bank of Spain Business rules expressed as XBRL Formulae
<To complete …..>
Practicing XBRL formulae in the Bank of Spain
Thank you for your attention
Víctor Morilla ([email protected])Moira Lorenzo ([email protected])
Manuel Rodriguez ([email protected])