Data collection with the Central Server for Statistical* Reporting * and prudential

1. Data collection with theCentral Server for Statistical* Reporting*and prudential André Peters Mark Creemers Project Coordinator Statistics Department, XBRL project leader Tel : +32 (0)2 221 28 21 Tel : +32 (0)2 221 55 58 E-mail : andre.peters@nbb.be E-mail : mark.creemers@nbb.be

2. National Bank of Belgium - Statistics & Supervision NBB is in charge of • Financial statistics • Balance of payments & IIP • Foreign trade statistics (for the National Accounts Institute) • National Accounts (for the National Accounts Institute) • Data collection for the Supervisory authority (CBFA) • Banks, Insurance companies, Pension funds, OFI NBB is in a quite unique position covering data collection needs for financial statistics, for statistics on real economy and for supervision.

3. National Bank of Belgium - Statistics & Supervision • 20,000 reporting agents for foreign trade • 12,000 reporting agents for balance of payments (direct reporting) • 4,000 reporting agents for direct investments • 110 banks, 250 pension funds, 140 insurance companies, ... • public administrations also report • NBB reports to NBB for monetary statistics ==> Clear need for a rational IT solution for data collection • User friendly for small companies filling in statistical forms • Full automation capabilities for big companies using XBRL, XML, file transfer in a complex IT environment with a very high level of security

4. The solution : Central Server for Statistical Reporting • a single IT software tool • implemented on server(s) connected to the Internet • dedicated to all kinds of statistical and prudential reports • used by all kinds of reporting agents (financial, non-financial, public, private, big or small companies) • to report to different authorities (central bank, supervisors, NSI)

5. IT : Life cycle of statistics & CSSR • conception • implementation • data collection & first validation • control & data correction • production & quality control • dissemination of results & broadcasting ==> very thin tool in the production chain but very efficient by its level of functionalities } CSSR

6. Scope of CSSR • Many statistical domains • Many domains for supervision • Many surveys - many forms • Different reporting frequencies • Many sectors of activity • Several languages (FR, NL, DE & EN) => For the declarants • A single IT solution for all reportings • A single IT solution for big, small, financial & non-financial companies • A declarant must use only one IT software for all reportings

7. CSSR : Central Server for Statistical Reporting Banks CSSR - Trade in services - Reporting for control - Banking supervision - Insurance supervision - IFRS - Basel II - Intrastat (foreign trade) - MIR - Direct investments - Securities portfolio - Other investments - etc Financial statistics Insurance companies Balance of payments OFI Foreign trade Pension funds Financial supervision Non-financial companies big, small, <> sectors of activity Economic statistics National accounts Administrations Int. investment position

8. General Principles • Internet standards-based application : HTTP, SMTP, S/MIME • ‘Thin client’ architecture : only browser at client side, no NBB-software • NBB does not intervene in the automation at client side • One central validation-server at the NBB • Support different profiles of users : low-profile, semi-automated and full-automated • Support different levels of security : 'strong' and 'weak' secured • Client is responsible for follow-up and quality of his reporting • Immediate validation of his reporting • Adequate functions to do this follow-up • Same philosophy for many reportings

9. General Principles • Reporting agents receives their own 'space' on the server • input for a survey can be done over several days • to finish the reporting, they have to 'close' the questionnaire • Multilingual application • Business areas are responsible for the business logic • software is managed by the business areas • the application contains functions to define new surveys, forms, validation- and derivation rules without intervention of the IT-department • Short 'time to market' for new questionnaire

10. Input Channels • On-line data entry : 'Web-forms' • Layout and content of Webform is determined by end-users • Import of CSV-files • Synchronous or asynchronous treatment • Format of the csv-file is similar to the corresponding Web-form • Http file upload • XML format, one or many 'tables' • Asynchronous treatment • Client gets a validation report via e-mail • Mail exchange • Strong secured : data is encrypted and digitally signed (S/MIME) • For certain reportings, non-secure mail is authorised under the responsibility of the client. Control on the 'from address'

11. Input Channels • XBRL (IFRS, Bazel II, FINREP) • integrated in the content part of our proprietary XML format

12. Advantages for the reporting agent • Advantages for the reporting agent • A single tool • A single address • A single userID/certificate • A single interface • Multilingual software • No software, no installation, no costs • No interference between CSSR and the internal organisation of the reporting agent • Validation reports (on-line or off-line)

13. Advantages for the central Bank or the Supervisor • A single IT software • No software distribution • No support - officially only one browser supported (I.E. v 5.0) • New release on demand & when needed • Savings on costs of data entry, time to produce the results • Higher quality thanks to integrated checks • Software fully managed by the statisticians • Reducing the "time to market"

14. IT: Functionalities for the reporting agent • Web page interface with forms • Edit, Save, Delete, Validate functions • File upload • On-line validation • On-line totalisation • Standard print of forms • Private memory space to store temporary data • Identification of the contact persons • Delegation of access authorisation • Follow-up tool (control board) • E-mail upload and off-line validation report

15. Functionalities for the statisticians & the supervisors • Domain definition • Survey definition • Code table, classification & list definition (meta-data) • Definition, maintenance & update of validation & calculation rules • Population Management • Which companies have to report what for which period within which prescribed time limit • Follow-up of response • calculation of response rate / non-response rate / average delay for reporting • preparation of reminder

16. Where does XBRL enter CSSR-picture? • Central Server for • Statistical Reporting • - Trade in services • - Direct Investments • - Securities Portfolio • - Other investments • - Intrastat • - BSI (2003) • - MIR (2003) • - Supervision : Banks, Insurances Companies, Pension Funds • XBRL • IFRS (2006) • FinRep (2007) • Basel II,CoRep (2007) • Basel II, pillar II (2008) Banks Financial Statistics Insurance Companies Balance of Payments OFI's Foreign trade Pension Funds Economical stat. Non-financial companies big, small, <> sectors of activity National accounts Administrations Prudential Supervisor

17. XBRL and the CSSR • Possibilities to report: • File upload / e-mail • Create XBRL file • Add XML envelope • File upload / e-mail with signed and encrypted file in attachment • Manual Data entry XML (identification) XBRL (data, > 99%)

18. CSSR - file upload or e-mail delivery • CSSR Delivery Report • Your reference number is 7332 • CSSR Acknowledgement • Your delivery (7332) has been accepted by the CSSR at the NBB and is sent to the validation server. • A validation report will follow. • CSSR Validation Report

19. CSSR - file upload or e-mail delivery

20. XBRL and the CSSR • There are no limitations in the reporting protocol with regard to: • the number of referenced taxonomies (templates); • the number of facts, contexts or periods. • So, within one document it is possible to report: • facts for all taxonomies for one period. • facts for one / more taxonomies for several periods. • (very) limited sets of concepts, possibly even concept per concept, for corrections or revisions.

21. CSSR - online access FINREP / COREP reporting in XBRL Other reportings in XML

22. CSSR - online access

23. CSSR - data entry

24. CSSR - data entry

25. CSSR - data entry

26. CSSR - data entry

27. CSSR - data entry

28. CSSR - consultation of facts • Consultation of the history of the facts • Consultation based on presentation linkbase • Consultation based on (part of) the name of the element, as defined in the taxonomy.

29. CSSR - data entry • How to create a table visualisation? • Choose Y-axis • Choose one (or more) X-axis • Create 0,1,... drop-down boxes

30. CSSR - business rules • Calculation linkbase: • only straightforward, simple calculations • No inequalities. • No multiplications. • No exceptions. • No cross-context. • Formula linkbase no recommendation yet • IT: additional rules outside taxonomy

31. CSSR - business rules • Business rules outside of taxonomy : for (CPT=="ifrs_gp:AvailableForSaleFinancialAssetsAccumulatedImpairmentLosses") group [DIMPROPS], CPT {VAL>=0;} for all group [DIMPROPS] {if (((VAL(CPT=="be_ifrs_fi:SpecificAllowancesForIndividuallyAssessedFinancialAssets") + VAL(CPT=="be_ifrs_fi:SpecificAllowancesForCollectivelyAssessedFinancialAssets")) !=0) then (VAL(CPT=="be_ifrs_fi:CarryingAmountOfTheImpairedAsset") ==0));} for CPT == "p_cm_ca:MarketRiskCapitalRequirements" and MR=="d_mr:MRiskSACOMTotal" group [DIMPROPS]- ["COM"],CPT {VAL(COM==null) ~== sum(VAL(exist(COM)));} Everything is possible! Rules are very intuitive! Reporter-dependent!

32. XBRL and the CSSR, very well integrated and a strong combination! • XBRL is highly flexible. CSSR allows to take full advantage of this flexibility by working at concept level. • XBRL calculations are too limited. Until formula linkbase is available, all possible business rules can be programmed and validated by CSSR. Afterwards, CSSR can be used to add additional features (exceptions, tolerances,...). • Manual entry form is available in CSSR and is based on taxo. • In the medium term, everything can be put in the taxonomy (instructions, business rules,...). Simply load the taxonomy in the CSSR and make it available to the reporting agents! • Transparancy, maintenance, new reporting projects,... • Validation before submission: "zero error" reports should be submitted "Management by Exception"

33. CSSR : Conclusions • single software • multi-reporting agents & multi-users • multi-domains, multi-surveys, multi-forms • multilevel functionalities (small or big companies) • multilevel security • multilingual • multi-authorities (National Bank, Supervisor, National Accounts) • only used by Belgian authorities • ==> Why not widen the use of CSSR to other authorities in charge of statistical & prudential data collection?

34. CSSR : Central Server for Statistical Reporting BELGIUM BELGIUM Banks CSSR - Trade in services - Reporting for control - Banking supervision - Insurance supervision - IFRS - Basel II - Intrastat (foreign trade) - MIR - Direct investments - Securities portfolio - Other investments - etc Financial statistics Insurance companies Balance of payments OFI Foreign trade Pension funds Financial supervision Non-financial companies big, small, <> sectors of activity Economic statistics National accounts Administrations Int. investment position

35. CSSR : Internationalisation Belgium Belgium CSSR Country 2 Country 2 CSSR country 2 Country n CSSR country n Country n

36. CSSR : Internationalisation Advantages for cooperators • Availability of a high level solution in the short term • Teething problems have already been overcome • Confidentiality of the data totally guaranteed • NBB - IT infrastructure is up to date, including disaster recovery procedure • CSSR development conforms to the state of the art in IT business • Costs saving - greatest part of the investments already made • Costs sharing of the IT platform between the countries using CSSR depending on the volume needed by each country • Possibility to add new domains of data collection when needed => good learning curve & very low costs to start the project