Treasury systems - |

The GNI@ TREASURY MANAGEMENT solution is a system with a web-based user interface that provides full automation and integration of all treasury transactions with external organization systems.

Technologically, the solution was designed on the basis of constructors and setup forms that helps configure and integrate workflows into the system easily and without technical staff.

The solution includes a built-in setup integration interface with such systems as S.W.I.F.T., Bloomberg, Reuters.
All GNI software modules operate in real-time mode.
The system also includes an interface for integration with automated banking systems that display all treasury transactions in accounting records.

Main advantages of our solution
Complex approach
We provide the entire software product line based on а single IT platform to meet the needs of any financial organization, both for individuals and legal entities.
Integration
All products run on the same platform, and a license configurator is provided depending on the requirements of the organization.
Customizability
The solution is based on built-in constructors, allowing clients to manage their workflows independently without programmers involvement.
Multilanguage capability
The system supports an unlimited number of languages certainly resulting in a positive effect on the product overall perception by the end user.
User-friendly interface
The system works through a web-based user interface and does not require installation of any desktop software. In addition, the system allows to configure an individual workplace for each individual user, including featured interfaces and a search system.
Data integrity
Any possibility to violate the data integrity is technologically excluded. A transaction is conducted completely or not conducted at all — "rollback mechanisms". The system excludes any backdate transactions and/or transactions prohibited within the general business chain of an organization. Data integrity is ensured by using the redo log engine that permeates the system and its tables.
Transparency
The solution provides transparency as all system modules run in real time and in real mode, and all transaction and accounting operations are logged.
Continuity
To ensure continuity, stress test and control procedures were embedded in the system for load check by the number of transactions conducted per minute, per hour, per day.

Applied technologies
The front-end client side is based on Oracle Apex technology.
The platform supports two integration technologies with external systems and subsystems: SOAP and REST (basic and recommended technology) and file exchange.

All printing forms are created on the basis of Jasper Reports (iReport).

Oracle Weblogic or Apache Tomcat application server and Oracle 18 database server are also applied.
To increase the system security, the following was created: a user password managment mechanism, a mechanism of integration and synchronization of system users with LDAP, a data warehouse mechanism, a data integrity mechanism, logs and audit mechanisms.

Modules and subsystems of GNI@ TREASURY MANAGEMENT
Centralized treasury product control module
The subsystem provides unprecedented opportunities for creation and management of all types of treasury products through a common interface. In addition to product creation, the system allows to independently configure an accounting model (all accounting) and the financial policy without external programmers assistance based on built-in constructors.
In addition, the functionality of the system provides broad opportunities to manage business conditions of these products:

  • monetary policy;
  • financial policy;
  • organizational policy, etc;
  • option to specify coverage and group clients;
  • option to set limits and regulation rules.
  • These options provide flexibility of the sales strategy and prompt launch of new solutions in the financial market.
  • As part of the module, the front-office is provided for centralized product management by the head office.
Main functional units of the module:

  • registration of new products;
  • setup of accounting model for products, linking of all necessary accounts to the product including balance sheet and off-balance sheet accounts;
  • setup of business conditions and parameters for different product subtypes:
  • loro and nostro accounts;
  • interbank deposits;
  • interbank loans;
  • all types of securities;
  • all types of foreign exchange transactions;
  • other subtypes.
  • determining events resulting in certain accounting transactions for each product. For example, bond issue, bond placement, commission fee charging, interest charging, coupon payment, penalty interest charging, repurchase, etc.
In addition, the functionality of this module includes a product approval chain within the existing corporate structure of the organization.
Financial partner profile control module
The financial partner profile control module is an integral part of the system infrastructure operated in conjunction with other modules and subsystems of treasury systems and the automated banking system.
All financial organizations are registered on the single-window principle. When creating a client data sheet, a financial organization is necessarily assigned with certain client types based on type breakdown matrix in line with the requirements of the management team and/or the regulator — for example, resident/non-resident, bank/non-bank organization. The system does not have any restrictions either on the number of created types or the number of values in these types.
Based on the types of financial organizations, an accounting model is determined based on the transaction type that allows the subsystem to automatically select necessary accounts from the setup matrix through online integration with the automated banking system. Therefore, the human factor is completely excluded at the moment of transactions, and the data in analytical accounting always match the data in synthetic accounting without any manual involvement.
The system also has all the necessary controls in full compliance with the anti-money laundering regulations (AML) and the Foreign Account Tax Compliance Act (FATCA), as well as in accordance with the common reporting standard (CRS).
The module offers a front-office and a back-office interface for centralized management of financial partners.

A financial partner profile control module supports creation of financial partners with all required details:

  • bank details;
  • general data;
  • senior management data;
  • data about founders;
  • other data.
This module also supports setup and automated generation of required printing plates.
Nostro and loro account control module
The module enables to register all accounts on the single-window principle including:

  • registration of loro accounts for financial and credit institutions;
  • registration of nostro accounts for financial and credit institutions.
The complex infrastructure of the system allows to use the same accounts for different types of transactions and different products thereby reducing the additional work on the front of the organization.
The entire accounting model under this module is configured via a specific built-in constructor. All transactions on loro/nostro accounts are conducted automatically through web integration with the automated banking system of the organization and with other modules and subsystems,
This module has a unique structure that enables accounting of balances and turnovers with regard to "virtual types": In total, the system has seven "virtual types" of balances and turnovers on loro/nostro accounts:

  • cash balance means funds credited to the account via cash desk of the branch;
  • non-cash balance means funds credited to the account in cashless form;
  • credit clearing remaining balance means funds credited to the account from a credit tranche;
  • deposit clearing remaining balance means funds credited to the account from a deposit account;
  • interest balance means funds credited to the account as income on deposit;
  • blocked balance.
As a result, the system allows to determine different tariffs and fees depending on the "virtual type" of the balance and/or turnover without any additional actions. Additionally, this mechanism allows to determine different taxation base depending on different virtual balances on the financial organization's account without creating additional transactions and/or complex calculations in the system.
The module offers a front-office and a back-office interface for centralized management of financial organizations accounts.

Main functional units of the module:

  • account management;
  • integration with systems of domestic tax authorities for opening and/or registration of current accounts;
  • contract management;
  • product management by accounts. This unit involves change of parameters, account closing, balance transfer, etc;
  • current account portfolio management.
  • This module enables setup and automated generation of required printing forms:
  • account opening application;
  • account opening agreement and other documents
Control module for transactions and operations in the financial market.
The control module for transactions and operations allows registration of all types of contracts in the financial market and their further management in the system based on the agreement approved under agreement approval chain.
The module involves all possible settlements, payments and transfers at all possible financial marketplaces including domestic interbank market.

The functionality of the system supports calculations both at fixed interest rates, and at floating rates linked to specific events and/or global financial indicators — LIBOR, etc.
The system supports all types of interest calculations for each contract:

  • 30/360;
  • ACT/360;
  • ACT/365;
  • ACT/ACT.

The functionality of the transaction management system includes:

  • creation of contracts in accordance with the decision of the organization;
  • loan repayment/payment schedule generation (principal amount of loan, interest accrued, final payment, other values in accordance with the product terms);
  • a monitoring schedule generation;
  • automated opening of all required balance sheet and off-balance sheet accounts for each transaction by means of web integration with the automated banking system of the organization;
  • automated generation of entries on created accounts based on the accounting model by means of web integration with the automated banking system of the organization;
  • agreement registration.
  • The functionality of the system allows to perform the following operations:
  • registration of interbank deposits — raised;
  • registration of interbank deposits — placed;
  • registration of interbank loans — raised;
  • registration of interbank loans — placed;
  • overnight transactions;
  • foreign exchange (FX) purchase, sale and currency conversion;
  • Forward transactions;
  • SPOT transactions;
  • SWAP transactions;
  • Netting;
  • interbank transfers;
  • interbank payments according to set calculations;
  • interbank teller cash transactions — cash receipt with subsequent calculations on correspondent accounts from Cash and Settlement Center of the National Bank (CSCNB) or its equivalent;
  • interbank teller cash transactions — cash sending with subsequent calculations on correspondent accounts from Cash and Settlement Center of the National Bank (CSCNB) or its equivalent;
  • interbank teller transactions — cash receipt with subsequent settlements on correspondent accounts from another financial organization;
  • interbank teller transactions — cash sending with subsequent settlements on correspondent accounts from another financial organization;
  • other required treasury transactions.
By means of web integration with the "General ledger" module and with other modules and subsystems, all treasury transactions are automatically displayed in online accounting using the specified accounting model with configurable constructors.
The functionality of the system allows to perform various types of restructuring under current agreements, including prolongation, change of interest rates, writing off of debt, etc.

This module enables setup and automated generation of required printing forms:

  • agreement,
  • other printing forms.

The module supports setup of automated billing on loan repayment from accounts of financial institutions.
Securities application and memorandum control module
The securities application and memorandum control module allows to fully automate the entire process of memorandum submitting, processing, initial approval, transfer of the memorandum to the committee for consideration for final decision and subsequent transfer of fully approved memoranda into the securities contract management system:

  • all types of bonds;
  • REPO and reverse REPO;
  • all types of certificates;
  • Path through;
  • other securities.

Powered by a built-in constructor, the system allows the organization to independently manage the memorandum form (application) for corporate clients based on a built-in constructor:

  • to determine required and optional entry fields;
  • to determine interconnection of entry fields with different values;
  • to create and independently edit data drop-down lists.
  • The module provides a front office and a back office interface for integration with the automated banking system and with external systems/services:
  • services for data provision about clients, guarantors, owners of legal entities and individual entrepreneurs (KYC procedures);
  • services with local financial marketplaces (interbank, local financial markets);
  • services with international financial marketplaces and stock exchanges (bloomberg and others).

Since the memorandum is closely integrated with the сustomer relationship management module of the organization (CRM), all the required data of securities buyers are automatically entered into the memorandum from the client's card.
In addition, when filling in the memorandum, the system supports some control procedures:

  • control of compliance with planned targets actually specified in memoranda;
  • availability of all required attached documents and graphic data.
  • The following sections are included in the securities memorandum:
  • type and financial conditions of securities (term, currency, amount, rate, grace days and other parameters);
  • market analysis;
  • project analysis;
  • purpose of financing;
  • financial analysis of the issuer's organization itself in order to form various printing forms (including prospectuses, memoranda, PIM and other documents);
  • security — collaterals: the system's functionality allows registration of various types of security within the framework of the memorandum. The system supports accounting and registration by variety of parameters (location, area, arrangement, condition, cost/evaluation and others) of various types of security and their cover ratio:
  • real estate;
  • transport;
  • cash/deposits;
  • guarantor/co-borrower;
  • securities and shares;
  • other deposits.
  • security assessment: the functionality of the system supports the introduction of various methods of security appraisal, including reports from specially licensed and accredited organizations;
  • documents and graphic data: the system's functionality monitors the minimum package of documents for each product and ensures storage of the electronic document flow within the framework of the memorandum. The system does not have any restrictions on the number of documents included in the framework of the memorandum;
  • memorandum approval procedure: the system's functionality is deeply integrated into the control module for committees and workflows related to application approval. The system directs all employees of the organization along the preconfigured decision-making chain.

Main functional units of the module:

  • creation and registration of memoranda;
  • procedure before filling in the memorandum. The system allows to postpone the preparation of a memorandum for a certain period;
  • procedure of sending of memoranda for approval/confirmation.
  • This module enables setup and automated generation of required printing forms:
  • memorandum on securities;
  • prospectus/memorandum for securities issue (PIM);
  • applications for subscription on securities to be issued;
  • other documents.
Additionally, the functionality of this module allows to restructure already conducted transactions with a subsequent approval chain of such memorandum suing a pre-configured decision-making chain.

In such a way, the functionality of the system fully meets all needs of a financial organization in creating of a memorandum and sending it for the approval process.
Control module for committees and workflows on securities memorandum approval
Based on built-in constructors, the control module for committees and workflows on securities memorandum approval provides unprecedented opportunities to independently create and manage all types of committees (from one committee member to an unlimited number of committees with different composition and powers of committee members) without programmers assistance on the common interface principle in accordance with requirements of the organization.

The system constructor provides broad options to setup all committees with the following basic parameters:

  • setting the committee level (level 1, level 2, etc.);
  • appointment/election of a committee in the structural division (throughout the organization, in a particular branch or division, etc.);
  • setting the types of voting for each specific committee (decision-making by a majority of votes, unanimous decision, majority of votes with percentage ratio);
  • setting the values of majority of votes in the form of a percentage ratio for decision-making;
  • setting the status of committee members (with or without a chairman);
  • number of committee members;
  • minimum number of committee members to make a decision;
  • other parameters.
The functionality allows to appoint and/or reappoint committee members and their chairmen within the system by means of integration with the organization's human resources control module.

After generation of loan committees and their composition within the module, another constructor enables to set up a workflow for securities memorandum approval. Main parameters of the setup constructor for workflow approval:

  • segmentation of a product group (types of securities, etc.);
  • product (a particular product by which individual approval rules are configured);
  • confirmation of approval chain for structural division application (for an entire organization, for a particular branch or division, etc.);
  • initial amount and currency of consideration (the minimum threshold amount for consideration by a committee);
  • final limit (maximum amount of funding confirmed by a particular committee);
  • sequence principle (confirmation is final or another level of approval is required);
  • sequence (in what sequence the product is approved);
  • decision making (issue of securities or restructuring);
  • other parameters.
In such a way, a multidimensional model is created in the system based on the built-in constructor in order to setup any workflow for application approval without technical staff assistance, which supports online voting for all the required committee members according to the approved memoranda.

Additionally, the module includes functionality for tracking the flow of committees to ensure maximum decision-making speed within the structural divisions of the organization.
This module enables setup and automated generation of required printing forms:
voting protocol and other documents.

As a result, the system's functionality fully meets the needs of a financial organization for setting up the workflow of application/ memorandum approval for all types of securities.
Module for securities registration, issue and placement
The module for securities registration, issue and placement supports registration of securities transactions in the system on the basis of a memorandum confirmed under the memorandum approval chain. By means of web integration with the "General ledger" module and with other modules and subsystems, all securities transactions are automatically displayed in online accounting using a specified accounting model with configurable constructors.
The system supports registration of securities with automatic generation of required accounts and entries.

The functionality of the system includes:

  • creation of transaction in the system in accordance with the decision made by the organization, taking into account various parameters:
  • type of securities;
  • amount of securities;
  • nominal cost;
  • interest rates;
  • repayment and/or repurchase conditions;
  • other conditions;
  • repayment schedule generation (principal amount of loan, interest accrued, final payment, other values in accordance with the product terms);
  • by means of integration with the "General ledger" module, the automatic opening of all required balance sheet and off-balance sheet accounts for each loan transaction is available:
  • registration of securities;
  • issue of securities;
  • placement of securities;
  • early and standard repayments/repurchases of securities;
  • restructuring;
  • other transactions;
  • by means of integration with the "General ledger" module — the automated generation of journal entries for created accounts based on the accounting model (including credit and debit);
  • calculation of agent and/or sales department fees with the automated display in accounting records by using integration with the "General ledger" module;
  • registration of agreement and/or security agreements under an agreed memorandum with the automated display in accounting by using integration with the "General ledger" module.
The system also supports any required integration with external systems using GNI@ DATA EXCHANGE OPEN API web services including various international platforms and stock exchanges.

The functionality of the system allows to perform various types of restructuring under current agreements including prolongation, change of interest rates, writing-off of a part of debt, etc.

The module also supports setup of automated billing for interest payment and/or final payments including coupon payments and securities certificates from current accounts of the organization in compliance with repayment schedules.
This module enables setup and automated generation of required printing forms:

  • prospectus and/or memorandum;
  • subscription agreement;
  • other printing forms.
Control module for processes and transactions on placed securities
The control module for transactions on placed securities provides registration of securities transactions in the system. By means of web integration with the "General ledger" module and with other modules and subsystems, all placed securities transactions are automatically displayed in online accounting records using the specified accounting model with configurable constructors.
The system supports registration of securities with automatic generation of required accounts and entries.

The functionality of the system includes:
  • creation of transaction in the system in accordance with the decision made by the organization, taking into account various parameters:
  • type of securities;
  • amount of securities;
  • nominal cost;
  • repayment and/or repurchase conditions;
  • interest rates and/or rates of return;
  • other conditions;
  • by means of integration with the "General ledger" module, the automatic opening of all required balance sheet and off-balance sheet accounts for each loan transaction is available:
  • purchase of securities;
  • sale of securities;
  • payment of funds to the seller;
  • receipt of interest income;
  • early and standard repayments/repurchases of securities;
  • restructuring;
  • valuation and revaluation of securities;
  • other securities transactions;
  • by means of integration with the "General ledger" module — the automated generation of journal entries for created accounts based on the accounting model (including credit and debit);
  • calculation of agent and/or sales department fees with the automated display in accounting records by using integration with the "General ledger" module;
  • registration of agreement under agreed terms of the transaction.
The system also supports any required integration with external systems using GNI@ DATA EXCHANGE OPEN API web services including various international platforms and stock exchanges.
The module also supports setup of automated billing for interest payment and/or final payments including coupon payments and securities certificates from current accounts of the organization in compliance with repayment schedules.
This module also supports setup and automated generation of required printing forms.
REPO process and transaction control module
The REPO process and transaction control module supports registration of transactions in the system on the basis of the memorandum confirmed in the memorandum approval chain. By means of web integration with the "General ledger" module and with other modules and subsystems, all securities transactions are automatically displayed in online accounting using a specified accounting model with configurable constructors.
The system supports the registration of REPOs and reverse REPOs with the automatic generation of the required accounts and journal entries.

The functionality of the system includes:

creation of transaction in the system in accordance with the decision made by the organization, taking into account various parameters:

  • REPO transaction type;
  • contract amount;
  • interest rates;
  • repayment and/or repurchase conditions;
  • other conditions;
  • repayment schedule generation (principal amount of loan, interest accrued, final payment, other values in accordance with the product terms);
  • by means of integration with the "General ledger" module, the automatic opening of all required balance sheet and off-balance sheet accounts for each loan transaction is available:
  • transaction registration;
  • repurchase;
  • early and standard repayments/repurchases;
  • restructuring;
  • other transactions;
  • by means of integration with the "General ledger" module — the automated generation of journal entries for created accounts based on the accounting model (including credit and debit);
  • calculation of agent and/or sales department fees with the automated display in accounting records by using integration with the "General ledger" module;
  • registration of agreement and/or security agreements under an agreed memorandum with the automated display in accounting by using integration with the "General ledger" module.
The system also supports any required integration with external systems using GNI@ DATA EXCHANGE OPEN API web services including various international platforms and stock exchanges.
The functionality of the system allows to perform various types of restructuring under current agreements including prolongation, change of interest rates, writing-off of a part of debt, etc.
The module also supports setup of automated billing for interest payment and/or final payment in compliance with repayment schedules.

This module enables setup and automated generation of required printing forms:

  • prospectus and/or memorandum;
  • agreement;
  • other printing forms.
Security deposit control module
The securities collateral control module allows the organization to configure the collateral policy for all types of securities and to manage the collateral policy on the single-window concept.
The security and collateral management system supports all security types, specifying a detailed structured description for each collateral:

  • loan portfolios;
  • real estate;
  • intangible assets, including property rights;
  • transport;
  • gold and precious metals;
  • securities;
  • other types of security.

By means of web integration with the "General ledger" module and with other modules and subsystems, all transactions with securities collateral are automatically displayed in online accounting using a specified accounting model with configurable constructors.
The module provides a front office and a back office interface to process transactions related to securities and collateral.

Main functional units of the module:

  • setup of the collateral policy of the organization for each product includes a list of the following key parameters:
  • collateral structure (minimum/maximum value);
  • discount factor for collateral value;
  • market value;
  • salvage value;
  • documents confirming the ownership of collateral;
  • other parameters for each individual type of security;
  • restructuring of collateral in off-balance sheet;
  • transfer of collateral from one asset to another;
  • evaluation and revaluation of collateral;
  • security and collateral monitoring;
  • collateral portfolio management.
  • Within this module, a securities and collateral report is generated with different slices of analytical data including:
  • by groups of securities;
  • types of security and collateral;
  • regarding other data segments.
  • This module enables setup and automated generation of required printing forms:
  • security agreement;
  • collateral monitoring schedule and other printing forms.
Thus, the module allows to complete all tasks, involved in collateral management and security for all groups of organization clients
Subsystem for report preparation on securities
The subsystem for report preparation on securities transactions allows to generate various types of reports in both transactional and analytical Oracle Business Intelligence system.
The subsystem supports the following reporting areas for all types of securities:

  • a general securities portfolio with various analytical profiles;
  • accrued interests repayment schedules;
  • payment schedules on coupons and final payments;
  • collateral portfolio;
  • IFRS reports and accounting;
  • other reports.

The reporting system includes reports with many parameters and details, including:

  • types of securities;
  • currencies;
  • terms;
  • risk groups;
  • security share;
  • other parameters.
All these reports provide a complete and accurate online picture of the organization's situation for effective asset management and achievement of key performance indicators (KPIs).

Implementation and customization of our GNI@ TREASURY MANAGEMENT solution with all integrations with external services take on average from 3 to 6 months, provided that the organization shares all the necessary migration data within the specified timeframe.