DIAMOS Reconciliation

Fully automate reconciliation and validation processes with DIAMOS Reconciliation

The consistent matching of data between systems or market partners is a key challenge in the investment industry. Multiple data formats as well as different views of the data and their structures often make matching time-consuming and complex. DIAMOS-Reconciliation enables the automated processing of a wide variety of data formats. The flexibility of the set of rules with simultaneous mapping of complex technical circumstances makes it possible with our module to achieve the best possible automation with transparency at all times and offers the possibility of customising the process individually – regardless of whether it involves cash accounts, holdings of any kind, transactions, transaction costs, NAV data, master data, or other data to be matched.

Benefit from these advantages:

  • Minimisation of manual activities
  • Automated reconciliation processes
  • Flexible set of rules and rule editor
  • Dual control principle and audit-capable

 

The number of different data sources, transaction volumes, holdings, and bank accounts makes it all the more difficult to maintain consistent reconciliation on a daily basis. All of this leads to major bottlenecks and cascading effects. For example, if releases are made too late.

DIAMOS Reconciliation helps to comprehensively master these challenges. Different data formats can be flexibly set up directly in the module and can be used immediately without any programming effort. Depending on the circumstances, the data can then flow into the different matching categories; here, for example, any number of matchings can be configured in parallel. The set of rules understands all the required professionalism without narrowing down to individual asset categories or issues.

Whether for a few dozen funds or 1000 and more funds in a short time window, the extremely high-performance automated matching ensures efficient support for the required specialist processes.

The results of the matching are displayed clearly and concisely. The user can concentrate on the exceptions and can process them using a variety of filter options. It is possible to create a rule directly from a technical constellation that is processed manually. This is then automatically taken into account during the next run. In addition, exceptions that occur in several funds can be processed together. This and many other features provide maximum support so that manual processes can be reduced to the absolute minimum.

This is also supported by the feature of combining the matching categories. For example, the results of the turnover matching can also be taken into account in the stock matching in order to optimally support business constellations such as different posting cuts.

Core functionalities – matching categories

Automated matching of holdings for all asset classes

Matching of cash accounts. The matching can take place either purely on the balance, including the display of the turnover or additionally on the turnover. In addition, an open item list can be kept.

Matching of turnover of any kind. Use for the matching of trade transactions in the context of fund management as well as for the matching of fee calculation results

Validation of fund valuations determined by the system, taking into account holdings (shares, bonds, derivatives), benchmarks, shares in circulation, turnover as a matching against the data of another system or as a matching against the “previous day”

Checking of data consistency and other technical issues. Generic tool for the matching of any category of data.

Further application examples of the different matching categories

Matching of holdings at different depositories

Matching of open transactions of the business partners involved to support the

Securities lending and securities reconciliation

Matching of securities lending and securities stocks

Matching of master data between two systems with the aim of data refinement and the creation of “golden copy” master data

Checking of data consistency and other technical issues. Generic tool for the matching of any category of data.

Further specifications and functionalities

Flexible rules and customisable configurability

  • Management of the reconciliation routines via a flexible set of rules
  • Freely configurable data interfaces
  • Individual definition of the result display
  • Provision of quickly operational standard configurations
     

High STP rates between all business partners and systems involved

  • Automated exchange between all systems involved – e.g. fund accounting systems, portfolio management systems, systems of the depositary bank (custodian bank), banking systems, payment systems
  • Processing of all common interface formats such as SWIFT (MT535, MT940), XML, CSV, TXT, Fixed Length, databases, Word documents, Excel files (e.g. BVI Excel), PDF
  • The implementation of new interfaces is possible without software adaptation: Interfaces can be configured directly by the user; DIAMOS provides the appropriate configuration definitions on request
     

Automated data import/cross-component data repository

  • Automated data import from all relevant sources such as (accounting) systems, master data providers or course providers
  • The data required for different reconciliation processes are loaded centrally into the system and are available for all licensed components

Maximum reconciliation rates

  • Discrepancies are reported directly by the system in order to allow for quick checking and further processing
  • System-supported merging for positions that clearly correspond to each other Automated generation of matching/validation proposals for doubtful positions

Optimal user-friendliness, efficient support for controlling, management, and auditing

  • Intuitive input masks/user guidance
  • Template-based commenting options with free text option and configurable text modules
  • Comfort functions such as synchronous scrolling or extensive filter functionalities
  • Audit-proof historicisation
  • Paperless review concept: All reconciliation information can be accessed directly via the application at any time and, if desired, across departments
  • Consolidated overview of the results taking into account the different forms of reconciliation
  • Clear visualisation of the reconciliation results via dashboard, traffic light status displays, and statistics charts
  • Optimised resource planning is enabled
  • Individual provision of supplementary reports and task lists
Request a product demo now without obligation