United Kingdom

Choose another country to see content specific to your location.

Finance, Treasury and Risk Integration: Automated Reconciliation



  • Automated Reconciliation between Treasury vs Finance for numerous products (i.e. Investment Banking, Home Loans, Money Markets etc.)


Banking area 


  • Finance Product Control

  • Regulatory capital and reporting areas incl. Treasury & Capital Management and Credit Risk Reporting


Skill sets


  • SQL

  • Data Analysis

  • SunGard RCC & Moody's RFO

  • SAP Subledger & Business Warehouse




  • Regulatory Capital

  • Data and Technology

  • Process Automation

  • Finance Subledger

  • Risk and Finance Alignment

  • User / System Testing




  • Consider all finance initiatives and timelines before initiating your regulatory solution

  • Be sure of the data integration requirements across source

  • Have a clear understanding of the data provided by different areas and the ownership thereof




A significant challenge all banks face is the reconciliation of data across their various system and business environments. Two major areas integral to reconciliation is the alignment between the Risk and Finance data. A large corporate, institutional and investment bank embarked on an integration project between their Risk and Finance areas to firstly comply to regulatory requirements, secondly to ensure the accuracy of all reported numbers and lastly, to implement a robust and timeous process for the required reconciliations.


Monocle was tasked with optimising the reconciliation process within Treasury by identifying and unpacking the sources shared between Treasury and Finance. This entailed identifying synergies between the two areas where Treasury leveraged the banks finance data. Monocle assisted in implemented an automated end-to-end solution based off these Finance initiatives. This also encompassed ensuring that all regulatory requirements were adhered to. Monocle’s involvement in the project was from start to finish, working with the bank on the overall solution, building the required business & technical specifications for implementation as well as performing both System integration testing and user acceptance testing. Lastly Monocle provided post-production support to ensure effective handover and project embedment.





  • Automated reconciliation process between Treasury and Finance

  • More accurate results with minimal adjustments required by Treasury

  • Quicker turnaround with less involved parties


Key skills required 


  • An understanding of the Finance and Treasury regulatory capital processes, the subject matter and concepts involved and the data required to enable these processes

  • Technical knowledge on data integration patterns and ETL design

  • Experienced regression testing capabilities for regulatory capital processes and calculations

"Monocle’s overall business knowledge of finance and risk combined with their technical capabilities ensured quicker turn around from specifications through to build and sign-off of testing."Head: Group Regulatory Reporting

How can we help you?

Contact us

What’s the latest with Monocle