Transcript Slide 1
The CBSO project - Experience and issues
Madrid, 05 October 2006
Camille Dümm Pascal Rodrique
Central Balance Sheet Office
Agenda
CBSO Project Process Planning Communication Project - Modules Technical features Experiences Issues 2
CBSO Project - Process
Taxonomy Software package
Instance document
Upload XBRL Sofista
Validator
3 PDF
XBRL files Database
CBSO Project - Planning
CBSO Project - Planning
Taxonomy - Draft 1 Feedback WG Taxonomy Architecture analyse Taxonomy - Final structure Taxonomy - Final version Taxonomy - Production version Internal Functional job analysis Internal developments Internal tests Contact with software vendors Tests for software vendors Applications in test environment Production nov-2004 mars-2005 juil-2005 nov-2005 mars-2006 juil-2006 nov-2006 mars-2007 4
CBSO Project - Communication
Extensive information about the taxonomy is available on the website of XBRL Belgium.
Taxonomy files Instance documents based on real cases a user guide a "viewer" allowing to run over the taxonomy in an efficient and pleasant way Technical documents Protocol New template Road shows to professionals Accountants associations Software vendors 5
CBSO Project – Interaction with Software vendors Why they were involved
Private companies produce 60% of the annual accounts filed electronically The success of the project depends also from their ability to produce valid instance documents as from April 2007 Software vendors were associated to the project from the beginning
How they were involved
Feedback on the taxonomy through the WG Personal contact to propose a "test service" Application available in a test environment as from January 2007 6
CBSO project - Sofware vendors
Taxonomy Draft version
03/2005
NBB
WG Taxonomy
Software vendors Application developments Taxonomy Final Structure
01/2006
Application Tests Taxonomy Final version
10/2006 01/2007 Tests
01/04/2007 P r o d u c t i o n
7
CBSO Project - Modules
Publication according to the legal mission
Template published by the NBB based on elements clearly defined in the law Rendering Module
Data processed in order to draw up statistics
Data must be validated through arithmetical and logical checks Validation Module 8
CBSO Project - Modules
Belgian Gaap
Individual annual accounts are drawn up according to the Belgian Gaap Taxonomy
Assistance
Free software used to input the data of annual accounts as alternative to private software The output is a file compliant with the legal requirements Data Entry Module 9
Taxonomy - Description
be-fr-pfs-ci-2006-10-01 According to Belgian GAAP Financial Reporting Primary Financial Statements Commercial and Industry Technical assumptions Compliant spec 2.1 and FRTA Multilingual Modular structure 10
Taxonomy - Architecture
11
Taxonomy - Experiences
Tools
Taxonomy development - Fujitsu Taxonomy validation Fujitsu - DecisionSoft - UBmatrix Instance document creation - Fujitsu (sample)
Conclusions
Generic tools essential considering the complexity of the syntax The tools are not complete and give different results 12
Data Entry - Features
"On line" application Allowing a company to fill in the data of its annual account Allowing upload of an XBRL file build with another application Validating the data according to technical and legal requirements Displaying the annual account as it will be published according to the legal template Creating a valid output file ready to be filed 13
Data Entry - Layout (1)
14
Data Entry - Layout (2)
15
Data Entry - Experiences
Complete "In house" development
Tools too generic => need for specific functions Tuple handling
Solution
Most of the sections are automatically generated from the taxonomy Some specific sections (identifying data or social balance) use "metadata" to be generated Methodology reused for Rendering module 16
Validation - Features
Three levels of validation
XML validation XBRL validation against taxonomy be-fr-pfs-ci-xxxx NBB validation containing specific rules but also arithmetical and logical checks
Technical specifications published
Software vendors must produce instance documents answering to all specifications Frequent contacts with software vendors (Feedback about taxonomy, tests sessions, …) 17
Validation - Experiences
Module used at two levels
To validate an instance document in the data entry application To validate an instance document in the filing application
"In house" development
Too many specific checks "Formula" not yet available To be integrated in an existing process 18
Rendering - Objectives
Legal mission
Annual accounts have to be published according to a formal template Availability as PDF file
Objectives
to insert most of the rendering parameters in the taxonomy instead of managing them outside, to allow multilingualism to reduce processing time when there is a new taxonomy version.
19
Rendering – Technical structure
Taxonomy linkbases
be-fr-pfs-ci-2006-01-01-presentation.xml
be-fr-pfs-ci-2006-01-01-reference.xml
be-fr-pfs-ci-2006-01-01-label.xml
1 XSL 1 XSL 1 XSL
Transformation .../out/presentation.xml
.../out/reference.xml
.../out/label.xml
Instance Document
Company.xml
3 XSL
Transformation TransformedCompany.xml
2* XSL
Transformation PresentationInstructions.xml
To execute at each taxonomy version To produce a PDF file
20
4 XSL-FO
Company.pdf
Versioning - Requirements
Versioning
First changes with be-fr-pfs-ci-2008-04-01 New taxonomy = New name Corrections Legal changes Use of a Definition linkbase as intermediate table from a version to the next one 21
Versioning - Scenario
Definition linkbase Version n+1 essence-alias id 1 similar-item id 2 - def 2 id 3 id 4 id 4.1
Version n id 1 id 2 - def 1 id 3 id 3.1
id 4 -
22
CBSO Project - Issues
Urgent needs
Versioning Formula Rendering specifications
Dangers
In the absence of specifications coming from XBRL International, developers will imagine specific solutions which will go against harmonization 23
Contacts
National Bank of Belgium Central Balance Sheet Office
24