Transcript Slajd 1 - Eurofiling

XBRL COFINREP Implementation
VII COFINREP Workshop
Bartosz Ochocki
[email protected]
2
VII COFINREP Workshop
XBRL in Polish banking sector
• National Bank of Poland
▫ extension of COREP and FINREP taxonomies
▫ COREP CA template required starting from March 2007
▫ COREP and FINREP obligatory since July/September 2007




legislative process
development of the reporting platform
designing of the data base
enabling analysis
• Reporting banks
▫ preparation of their internal systems
▫ solutions of Polish software vendors
2007-05-09
3
Reporting chain
Model approach
VII COFINREP Workshop
Data mining
Regulator
Legal
regulations
Report receiving and validating
Content and
format
Report
Report generating
Reporting entity
Data sources
Software vendors
and consultants
2007-05-09
4
VII COFINREP Workshop
2007-05-09
XBRL reporting implementation phases
Requirements analysis
I
II
Resources analysis and planning
III
Preparation of infrastructure
Tests
IV
V
Production use
VI
Rules and processes regarding maintenance
Heavily depend on
scope, conditions
and means of
implementation
5
VII COFINREP Workshop
Scope of
implementation
Data mining
Regulator
scope of
reporting
chain
Report receiving
range of data
collected
Report for
statistics
Report for
supervisors
Report generating
Reporting entity
Data sources
Report for
financial/
accounting
2007-05-09
6
VII COFINREP Workshop
Means of implementation
development using own
resources only
 independency
 customization possibility
development using
available tools as
components
purchase of the solution
covering whole reporting chain
 time and effort minimizing
 less knowledge required
2007-05-09
7
VII COFINREP Workshop
XBRL reporting implementation phases
I
Requirements analysis
II
Resources analysis and planning
III
Preparation of infrastructure
IV
Tests
V
Production use
VI
Rules and processes regarding maintenance
2007-05-09
8
VII COFINREP Workshop
III
Preparation of infrastructure
Preparation of data model
2
Taxonomy development and documentation
Instance document requirements documentation
4
3
Development of reports generating solutions (optional)
Communication aspects (transferring and receiving files)
6
1
5
Taxonomies distribution
5a
Transfer of reports (receiving and validation)
5b
Data conversion and gathering
Data analysis
7
2007-05-09
9
VII COFINREP Workshop
III
Preparation of infrastructure
1
Preparation of data model
clarity
fundamental
requirements
• Problems
▫
▫
▫
▫
unequivocal
consistency
level of details
decision on use of dimensions
logical split in parts
understanding of the nature and limitations of XBRL
technology
2007-05-09
10
VII COFINREP Workshop
III
Preparation of infrastructure
Preparation of data model
Taxonomy development and documentation
1
2
Taxonomy
requirements
Requirements
Predevelopment
Information
model
Design
Taxonomy
Working Drafts
Building
Development
Testing
Publication &
Recognition
Taxonomy
Exposure Draft
Taxonomy Final
Version
Post-development
Maintenance
and Usage
2007-05-09
11
VII COFINREP Workshop
III
2007-05-09
Preparation of infrastructure
Taxonomy development and documentation
2
• framework and modularization - building a taxonomy from logical
pieces
• aim:
▫
▫
▫
▫
avoiding redundancy (elements and relationships)
minimizing of efforts
minimizing of size
maximizing of functionality and flexibility
• technical approaches:
▫
▫
▫
▫
modularization on linkbase (extended links) level [IFRS-GP]
modularization with one sack for elements definitions [FINREP]
modularization with common elements' sacks [COREP]
mix
12
VII COFINREP Workshop
L
S
(b)
L
S1
(d)
R
S
(ts)
L
S
(w)
S2
(d)
R
D
S
(tr)
D
R
S1
(p)
P
R
L
C
S2
(p)
D
P
C
S3
(p)
D
P
C
D
S1
(t)
modularization with one sack
for elements definitions
[FINREP]
S2
(t)
L
S3
(t)
D
L
D
2007-05-09
L
S3
(d)
R
D
13
VII COFINREP Workshop
S1
(cp)
P
S2
(cp)
C
L
D
P
R
C
L
S1
(p)
S
(ts)
modularization with common
elements' sacks
[COREP]
D
R
S2
(p)
S3
(p)
L
S1
(d)
P
C
L
D
R
P
C
L
S1
(t)
L
D
R
P
C
L
S2
(t)
D
L
D
D
L
R
D
R
L
S2
(d)
S3
(t)
2007-05-09
R
D
L
D
S3
(d)
R
D
14
NBP –Taxonomy framework
VII COFINREP Workshop
monthly
individual
quarterly
COREP
consolidated
quarterly
monthly
PAS
quarterly
yearly
individual
monthly
IFRS
FINREP
quarterly
yearly
quarterly
consolidated
COMMON
IFRS
yearly
2007-05-09
15
VII COFINREP Workshop
III
Preparation of infrastructure
Instance document requirements documentation
3
(1)
• requirements regarding indication of version and sort of
taxonomy on which report is based:
▫ automatic: schemaRef attribute of the entry schema
(extending prohibited)
▫ additional:




file name
context id
reported element
…
• requirements for data accuracy
▫ precision/decimals attributes
▫ depending on concept or data type
2007-05-09
16
VII COFINREP Workshop
III
Preparation of infrastructure
Instance document requirements documentation
• specific file names and context ids, e.g.:
N_a_b_c_d_RRRRMMDD.xbrl
▫
▫
▫
▫
▫
▫
N: shortened bank name
a: [c;f]
b: [j;s]
c: [p;m]
d: [m;k;r]
RRRRMMDD: reporting date
• reporting entity identification:
▫ entity identifier: code of reporting bank
▫ identifier scheme: http://sis.nbp.pl/ticker
3
(2)
2007-05-09
17
VII COFINREP Workshop
III
Preparation of infrastructure
Instance document requirements documentation
<xbrli:context id="BANK_f_j_p_k_20070630P_FDPA003_FDPP023_FDWA002">
<xbrli:entity>
<xbrli:identifier scheme="http://sis.nbp.pl/bank">111</xbrli:identifier>
<xbrli:segment>
<xbrldi:explicitMember dimension="d-FINREP-pl-pa:PortfelABWymiar">
d-FINREP-pl-pa:PortfelB
</xbrldi:explicitMember>
<xbrldi:explicitMember dimension="d-FINREP-pl-pp:PodzialPodmiotowyWymiar">
d-FINREP-pl-pp:DuzePrzedsiebiorstwa
</xbrldi:explicitMember>
<xbrldi:explicitMember dimension="d-FINREP-pl-wa:WalutyWymiar">
d-FINREP-pl-wa:Pln
</xbrldi:explicitMember>
</xbrli:segment>
</xbrli:entity>
<xbrli:period>
<xbrli:startDate>2007-03-31</xbrli:startDate>
<xbrli:endDate>2007-06-30</xbrli:endDate>
</xbrli:period>
</xbrli:context>
<xbrli:unit id="PLN">
<xbrli:measure>iso4217:PLN</xbrli:measure>
</xbrli:unit>
<p-FINREP-pl:PrzychodyZTytuluOdsetekKredytyNaNieruchomosciMieszkaniowe decimals="0"
unitRef="PLN"
contextRef="BGK_f_j_p_k_20070630_FDPA003_FDPP023_FDWA002">1000
</p-FINREP-pl:PrzychodyZTytuluOdsetekKredytyNaNieruchomosciMieszkaniowe>
3
(3)
2007-05-09
18
VII COFINREP Workshop
III
Preparation of infrastructure
Development of reports generating solutions (optional)
• MS Excel macro for CA template
• Field left to the market
4
2007-05-09
19
VII COFINREP Workshop
III
Preparation of infrastructure
Communication aspects (transferring and receiving files)
• communication platform: Internet
• basic features:
▫ login
▫ taxonomy distribution
▫ transfer and receive of report
 report classification
 period
 taxonomy package
 information on submitting person
 information on person responsible for data
5
2007-05-09
20
VII COFINREP Workshop
III
Preparation of infrastructure
Communication aspects (transferring and receiving files)
institution
• exposing taxonomy
• communicating
changes
• report receiving
reporting entity
• download taxonomy
(mappings and
remappings)
• report submitting
5
software vendor
• taxonomy download
and caching
(embedding in tools)
2007-05-09
21
VII COFINREP Workshop
III
Preparation of infrastructure
Transfer of reports (receiving and validation)
5b
• XBRL and other validations
▫ XBRL - embedded in portal validator
▫ need for customization of error messages
 language
 human readability
▫ advanced business rules
 business rules need to be communicated to reporting entities (preferred
electronic format, e.g. CSV, XML, …)
 available software specific solutions
▫ other checks
 formal requirements regarding instance documents
 completeness
▫ historical checks on the database level
2007-05-09
22
VII COFINREP Workshop
III
Preparation of infrastructure
Data conversion and gathering
6
• Data conversion
▫ mapping of:
 taxonomies in order to design database
 reports (instance documents) into databases
▫ mechanism to flatten XBRL
 contextually
 dimensionally
▫ may support problem of versioning
 indication of changes in taxonomies with regard to databases
 consequences of taxonomy changes for XBRL instance
documents content
2007-05-09
23
VII COFINREP Workshop
XBRL Reporting Chain Model
2007-05-09
24
VII COFINREP Workshop
VI
2007-05-09
Rules and processes regarding maintenance
Taxonomy
bugs and
issues
Data gathering
New
(changed/corrected)
taxonomy
Regulator
Receiving and validating report
Format and
content
Report
Changes in
legislation
Changes in
taxonomy
Generating reports
Reporting entity
Changes in base
taxonomy (in case of
extensions)
Data sources
Former taxonomy
25
VII COFINREP Workshop
VI
2007-05-09
Rules and processes regarding maintenance
• technical (ID) labels
▫ construction: link:label elements with specific xlink:role
attribute value
▫ unique identification of a concept
▫ benefits:
 easier and faster communications (short codes instead of long
labels)
 easier indication of concepts (in taxonomy, instance document or
validation reports)
 direct link between data model and the taxonomy
 supports designing of, mappings to and maintenance of
databases
 supports versioning (codes don't change while names or
namespaces do)
26
VII COFINREP Workshop
Responsibilities of the reporting banks
• gathering and calculation of reporting data
• generation of the instance documents
▫ correct definition of context information
▫ ability to localise reporting concepts in the taxonomy
structure
▫ proper mapping from internal systems and databases
• validation of the instance document
▫ XBRL (XML and others)
▫ business rules
▫ formal requirements
• sending of the instance document to the reporting system
• understanding of error reports and correction of errors
2007-05-09
Thank you
Bartosz Ochocki
[email protected]