Skip to main content

Stages of New Regulatory Reporting Implementation

In the last blog, we discussed what is Financial Regulatory Reporting and its importance in the banking industry. Regulatory Reporting comprises the submission of business numbers as required by regulators to evaluate and track the financial and operational status of financial institutions and their compliance with required regulatory provisions.

Whenever a Regulator brings in new requirements, banks have to go through various stages to finally deliver what Regulators are asking for.

Let's go through various stages of implementing new regulatory requirements.

Interpretation of new rules:

Reviewing and establishing what the regulation means for the firm, translating the regulatory requirements into IT requirements, any associated staff training, and validation processes. Scoping needs to be done at this stage. We need to understand the regulatory rules and guidelines as well as identify interdependencies with other major regulations. We have to assess the impact of the rules on our strategic priorities and operations.

Data Preparation:

Sourcing and integrating data from different systems and reviewing for completeness and accuracy. Identifying stewardship of data and Frequency of data required is also important. The top challenges for banks are:

                 1.Data availability

                 2.Data quality

                 3.Infrastructure and IT capability

Fig 1: Stages of New Regulatory Reporting Implementation

Report Production:

Transforming data by applying the appropriate calculations and business rules, checking for and resolving errors, and aggregating data to input data to each reporting cell in templates before signing off the report for submission. Banks can use third-party tools like AxiomSL, OneSumX, or any in house tool for Report production purposes.

Communication:

Transforming reports into the format required for submission and sending the output to regulators. Sometimes the Regulators ask to send granular data in XML, XBRL, or in Excel Sheets. Gabriel is the FCA's online system for collecting and storing regulatory data from firms while OSCA (The online statistical collection application) is used by reporting institutions to submit statistical data to the Bank of England.

Queries:

Handling both internal queries prior to submission as well as queries received from regulators after submission. Banks need to reply to any ad-hoc queries by regulators as well as internal assessment bodies. So Regulatory team always need to be prepared to furnish data point in a stipulated time period.

Regulatory reporting is an ongoing process where banks need to interact with their counterparts and submit qualitative, accurate data with timeliness.

 

About Amlgo Labs : Amlgo Labs is an advanced data analytics and decision sciences company based out in Gurgaon and Bangalore, India. We help our clients in different areas of data solutions includes design/development of end to end solutions (Cloud, Big Data, UI/UX, Data Engineering, Advanced Analytics and Data Sciences) with a focus on improving businesses and providing insights to make intelligent data-driven decisions across verticals. We have another vertical of business that we call - Financial Regulatory Reporting for (MAS, APRA, HKMA, EBA, FED, RBI etc) all major regulators in the world and our team is specialized in commonly used regulatory tools across the globe (AxiomSL Controller View, OneSumX Development, Moody’s Risk, IBM Open Pages etc).We build innovative concepts and then solutions to give an extra edge to the business outcomes and help to visualize and execute effective decision strategies. We are among top 10 Data Analytics Start-ups in India, 2019 and 2020.

Please feel free to comment or share your views and thoughts. You can always reach out to us by sending an email at info@amlgolabs.com or filling a contact form at the end of the page.

 

Labels:

Comments

  1. tradeimexinfoDecember 31, 2020 at 3:50 PM

    I really want to thank the author for such a nice blog that helped me to understand why it is important. Philippines Customs Data

    ReplyDelete
  2. Mary JamesFebruary 16, 2021 at 3:39 PM

    I am glad to say that this is a very useful post. superb and intresting.one of the best post.this inspired a new blog. Thanks for sharing wonderful information .Iso 27001 Implementation Chennai

    ReplyDelete
  3. Laura BushMarch 12, 2021 at 1:10 AM

    This information is so useful and informative which you have shared here. It is beneficial for beginners to develop their knowledge. It is very gainful information. Thanks for share it. Mexico Import Data

    ReplyDelete
  4. tradeimexinfoOctober 2, 2021 at 3:21 AM

    I read this article, it is really informative one. Your way of writing and making things clear is very impressive. Thanking you for such an informative article.Philippines Import Data

    ReplyDelete
  5. industryforumDecember 7, 2021 at 5:10 AM

    Nice info, I am very thankful to you that you have shared this special information with us. I got some different kind of knowledge from your web page, and it is really helpful for everyone. Thanks for share it. Read more info about Online CPIM course

    ReplyDelete

Post a Comment

More Popular Posts

Amlgo Blog - Experience The Experiments

Amlgo Labs Blog  is a step towards our vision to share knowledge and experiences, Amlgoites accept every challenge very enthusiastically. We do experiments, we fail but we learn and build complex solutions to help our clients solve their problems in Data, Analytics, Prediction, Forecasting, Reporting, Designing and Development area. During this process we enjoy immense learning everyday and we have decided to share our thoughts, learnings, experiments and experiences so that we don't work in silos and contribute the best of our knowledge towards community and learn more by views and reviews. This website is maintained and brough to you by  Amlgo Labs Professionals .   Our Strong Basics -  1)   KISS (Keep It Simple and Straightforward) :  We believe most of the problems can be solved by keeping things simple and straight. This is the learning we had in past, sometimes we try to solve technical problems using high end algorithms and complex codes but this results into complications.
1 comment
Read more

Power BI Blog - What is Power BI and Why we use Power BI.

This Power BI blog is an introduction to the Power BI. In this Power BI tutorial, you will learn Power BI basics - what is Power BI, Power BI Desktop and Power BI Service. Power BI tool is a combination of Business Intelligence and Visualization. Before we dig deep let’s understand what is Business Intelligence. Business Intelligence is a broad spectrum which consists of using different business strategies and techniques to gather data, refine it and process it for the purpose of data analysis which gives us some meaningful information which helps in data driven decision making. When we present this information in the form of some charts, graphs it takes the form of Visualization.
4 comments
Read more

Power BI Card Visual With Conditional Formatting

In this blog we will take you through the Power BI Card Visual and a workaround to present card with conditional formatting. To know more about what is Power BI please do check Power BI Blog . The conditional formatting, we do will not be on the Card Visual, but the output will certainly look like Card, which is a requirement in some cases. Many Power BI users have used Card Visual to represent some value on the Power BI Reports separately or on above of any other visual, but sometimes clients ask which is deemed difficult to achieve, but not impossible. So, let’s dive into the practical to know more about it.
2 comments
Read more

A simplified view of a QlikView tool:

In our last blog related to Qlikview, we discussed the use of Qlikview for Financial Data Analytics . Qlikview is a Business Intelligence tool that consists of a front end to visualize the processed data and a back end to provide the security and publication of the mechanism for QlikView user documents.
3 comments
Read more

Polybase Installation for Scale-Out process

This part is the continuation of the previous blog about the introduction of  Polybase Scale-Out Group . As we have discussed in our earlier blog PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, PolyBase can be used to access external data in SQL Server, Oracle, Teradata, and MongoDB.
3 comments
Read more

JavaScript: The Important Basics

In this weird world of technology people often get confused how does a website work? What all things should I be aware of? So we are here to help you. Most of the content on web is developed with the help of JavaScript. JavaScript is really becoming popular these days with the coming of ECMAScript2015 and ECMAScript 2016, for this reason, some beginners learning React and Angular and are also trying to tackle more modern JavaScript syntax at the same time. If you're new to both, it can be confusing as to "what is JavaScript and what are its important features". This document should serve as a primer to help you get up-to-speed on JavaScript syntax that we feel matters the most for learning React as well as Angular.
4 comments
Read more

How to Connect Windows with Ansible?

Hello Techies, this blog is the continuation of the last blog Install Ansible on Windows which is the second part of the series Ansible with Windows . Before you proceed, I recommend you to please take a look at the introductory blog of this series so to have an understanding of this series.
Post a Comment
Read more