1 / 17

Regulatory banking reporting at Banco de España

Regulatory banking reporting at Banco de España. Some functions require the collection of data from credit institutions: Promotion of the stability of the financial system Preparation and publication of statistics Gathering data for the European Central Bank Process

portia-gill
Download Presentation

Regulatory banking reporting at Banco de España

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Regulatory banking reporting at Banco de España • Some functions require the collection of data from credit institutions: • Promotion of the stability of the financial system • Preparation and publication of statistics • Gathering data for the European Central Bank • Process • Regulation laws are published : definition of concepts required and its schedule • Data is received and debugged through a validation process • Clean data is available for analysts • Some numbers • More than 150 financial statements in use (more than 300 in total) • About 40.000 different financial concepts defined • More than 28.000 quality checks defined • More than 100.000 statements processed per year

  2. C C Regulation law System requirements System requirements Code Code IT developer IT developer IT analyst IT analyst Business user Business user Implementation of a new regulation law (classic approach) Regulator Commercial bank

  3. Errors detected Notification Validation OK Data extraction Data extraction Analysis and corrections Data filing and validation process (classic approach) Regulator Analysis Commercial bank

  4. Sender Sender Sender Sender Sender Sender Sender Sender Sender Sender Sender Sender Regulator Complexity of the whole process 400 credit institutions

  5. XBRL Taxonomy Regulation Law IT analyst Business user Business user Implementation of a new regulation law (XBRL approach) Regulator Commercial banks

  6. Validation OK Data extraction & local validation Analysis And corrections Data filing and validation process (XBRL approach) Regulator Analysis Commercial banks

  7. 2005 2011 2010 2007 2009 2008 2004 2006 XBRL Projects FINREP 2012 COREP 2012 Taxonomy development Nº Participants: > 300 Nº Filings / year: > 1000 ECB BSI and MRI statistics Nº Participants: > 300 Nº Concepts (EU): ~ 1.700 Nº Dimensions (EU): 12 Mutual guarantee Exchange offices Nº Participants: > 300 Nº Filings/year: ~1000 Nº Concepts (EU): ~ 950 Nº Dimensions (EU): 22 Add. Concepts (ES): ~ 553 Add. Dimensions (ES): 8 Sectorial Statements (FINREP) Nº Participants: > 300 Nº Filings/year: > 7000 Nº Concepts: > 650 Solvency Information (COREP) Nº Participants: > 50 Nº Filings/year: > 200 Nº Concepts: > 950 Public Statements (IFRS) Appraisal Companies

  8. 2010 2005 2011 2007 2009 2008 2006 2004 XBRL Projects FINREP 2012 COREP 2012 Taxonomy development Nº Participants: > 300 Nº Filings / year: > 1000 Application / infrastructure Analysis DB evolution ECB BSI and MRI statistics Nº Participants: > 300 Nº Concepts (EU): ~ 1.700 Nº Dimensions (EU): 12 Database migration Mutual guarantee Exchange offices Nº Participants: > 300 Nº Filings/year: ~1000 Nº Concepts (EU): ~ 950 Nº Dimensions (EU): 22 Add. Concepts (ES): ~ 553 Add. Dimensions (ES): 8 Multi-instance validation Sectorial Statements (FINREP) Nº Participants: > 300 Nº Filings/year: > 7000 Nº Concepts: > 650 Taxonomy viewer Solvency Information (COREP) XBRL Formula integration SIIF Dimensions Evolution Nº Participants: > 50 Nº Filings/year: > 200 Nº Concepts: > 950 Public Statements (IFRS) SIIF System Basic XBRL Infrastructure Appraisal Companies XBRL Prototype

  9. Banco de España Implementation Financial Institutions XBRL Formula Validation Process Other applications XBRL filings SIIF Submissions Management Validation results XBRL Taxonomy Main Data repository

  10. Banco de España Financial Institutions Implementation • Helper services • Fulfilment state querying • Pre-validation • XBRL viewer • XBRL on-line forms • Taxonomy browsing XBRL Metadata Main Data repository

  11. 2008 2005 2011 2010 2007 2009 2006 2004 XBRL Projects FINREP 2012 COREP 2013 Nº Participants: > 300 Nº Filings / year: > 1000 ECB BSI and MRI statistics Nº Participants: > 300 Nº Concepts (EU): ~ 1.700 Nº Dimensions (EU): 12 Mutual guarantee Exchange offices Nº Participants: > 300 Nº Filings/year: ~1000 Nº Concepts (EU): ~ 950 Nº Dimensions (EU): 22 Add. Concepts (ES): ~ 553 Add. Dimensions (ES): 8 Sectorial Statements (FINREP) Nº Participants: > 300 Nº Filings/year: > 7000 Nº Concepts: > 650 25.000 new validations rules (multiple instance validation) Solvency Information (COREP) Nº Participants: > 50 Nº Filings/year: > 200 Nº Concepts: > 950 Public Statements (IFRS) 22.000 instance documents received 10.000 validation rules defined 1.200 XBRL assertions needed 60.000 errors detected Appraisal Companies

  12. Former approach

  13. Conclusions • Better maintainability: • Striking reduction in the number of rules to maintain (reduced to a 10%) • Validation rules expressed in business terms • Reusability between different actors • Regulators and credit institutions • Different countries: • European rules • Domestic ones • Data available sooner and improved quality • Standard and formal language to express formulae • Can be validated at the source of information • Poor understanding of XBRL by credit institutions

More Related