Loan systems
The GNI @ LOAN MANAGEMET SYSTEM solution is a comprehensive integrated modular business solution that handles the strategic and day-to-day lending processes of a wide range of financial institutions, from small financial institutions requiring consumer lending or leasing companies providing assets to an operational or financial leasing, to international banks or funds working with syndicated loans, which require the functionality of financing complex projects, consisting of several tranches with a tie to a specific financing resource.
GNI credit management systems allow you to create all possible types of credit products, including credit lines, loans, overdrafts with all possible options for credit processes. In addition, the solution includes a number of other modules and subsystems, including for making an automatic decision on the issuance of a loan (scoring modeles), credit monitoring, collateral, appraisal of collateral, surety, structuring and restructuring, decision-making customization procedures, creation of committees, customization business chains and electronic document management procedures, other modules and subsystems.
Our solution gives your organization unprecedented flexibility, scalability and reliability. We have adapted our subsystems and modules, which contain functionalities designed to successfully serve all clients of the organization, including individuals, legal entities and financial institutions. Technologically, the solution is based on constructors and customization forms, so it helps the Bank to easily and without the help of technical specialists (programmers) customize and integrate its business processes into the system.
All modules in GNI software work in real time and online, while, thanks to the unique infrastructure of the accounting system, accounting transactions are carried out automatically from operational accounting based on a custom accounting model.
Advantages of the solution «GNI@ LOAN MANAGEMET SYSTEM»
Complex approach
The proposed solution enables to carry out all financial transactions online, similar to such operations in a branch of the organization, both for individuals and for legal entities, if permitted by local laws.
Customizability
The solution is based on built-in constructors, allowing clients to manage their workflows independently without programmers involvement.
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 individual users to customize their own interface and selected transactions, and helps to create transaction templates for better client servicing.
Transparency
The solution provides transparency of all client activities using units and subunits of client reports (statements), as well as various types of notifications on conducted transactions.
Integration
The front-end side of the solution works on the same principle as microservices with back-end side. Such solution provides a prompt response to the execution of all assigned commands resulting in high quality of service. There are no limits for the amount of data processed.
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.
Data integrity
Any possibility to violate the data integrity is technologically excluded by the procedure of microservice and logging of all transactions, as well as accounting operations running through the user interface. A transaction is conducted completely or not conducted at all — "rollback mechanisms". A transaction is conducted completely or not conducted at all — "rollback mechanisms". The system excludes conducting of 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.
Continuity
The system ensures 24/7 uninterrupted operation using intermediate data storage procedures and built-in cyclical checks for data exchange with the main bank systems. In addition, stress test and control procedures were embedded into the system for load check by the number of transactions conducted per minute, per hour and day.
Applied technologies
The front-end part is based on Oracle Apex technology.
The platform for credit systems supports 2 technologies for integration with external systems and subsystems: SOAP and REST (the main and recommended technology).
All printable forms are based on Jasper Reports (iReport).
It also uses Oracle Weblogic or Apache Tomcat application server and Oracle 18 database server.
To improve the security of the system, a mechanism for managing user passwords, a mechanism for integrating and synchronizing system users with LDAP, mechanisms for data storage, mechanisms for data integrity, logs and audit mechanisms have been created.
gni@GNI@ LOAN MANAGEMET SYSTEM modules and subsystems
Centralized loan product control module
The centralized loan product control module provides broad opportunities to create and manage all types of loan products on the "single window" concept, including:
- documentary transactions;
- loans;
- installment (repayment in equal parts);
- credit lines;
- overdrafts;
- syndicated loan.
The module provides a front-office for the centralized product management and a back-office interface for integration with the automated banking system of the organization and for integration with other external software packages.
In addition to creating products, our solution enables an organization to configure an accounting model (all accounting) and loan policy based on built-in constructors independently, without programmers assistance:
- setup of accounting model for products (linking all necessary accounts to a product, including balance sheet and off-balance sheet accounts);
- setup of compliance of loan products and loan terms based on a loan constructor for all loan subtypes (loan, overdraft, credit line, syndicated loan, etc.);
- determination of events according to which accounting transactions for each product will be conducted. For example, interest accrual, penalty interest accrual, principal overdue, overdue accrued interest, write-off on off-balance, recovery from off-balance, restructuring (write-off, prolongation, transfer from one currency into another at a special rate) and many other events.
In addition, the functionality of the system provides broad opportunities to manage business models of these products, namely:
- determination of client profile (client segmentation, employment, minimum work experience, social status, age, etc.);
- requirements for document package (mandatory, optional);
- type of loan;
- loan currency;
- financing term (daily, monthly, annually and others);
- financing limits (minimum-maximum amount, total limit, limit with additional approval of the committee, tranche limit, etc.);
- determination of interest rate values;
- interest accrual regulations (interest accrual base, interest accrual method, other parameters);
- interest accrual schedules (opening annuity, closing annuity, accrual on the balance, payment of principal amount at the end of the term, seasonal schedules, special schedules);
- commission fee charging regulations (payment immediately, payment during the loan schedule period in equal parts, other parameters);
- setting commission fee values;
- setup of security requirements (uncollateralized, collateralized, guarantee, cover ratio, determination of collateral structure — real estate, guarantee, current assets, etc.);
- setup of required financial indicators for the borrower (ratio of monthly income to the payment amount, other indicators according to the profit and loss statement or to the balance sheet for legal entities and individual entrepreneurs);
- setup of loan monitoring procedures and policies (frequency, procedure of loan monitoring manager assignment, etc.);
- setup of possible restructuring rules (conversion from one currency to another, prolongation, etc.);
- linking loans to the source of financing (availability of targeted financing, the need to calculate passive liabilities and corresponding incomes/expenses on such loans);
- overdue rules (grace days, without grace days, taking into account the public holidays, etc.);
- requirements for additional banking services (different types of insurance (life, property, job loss, etc.), SMS notifications, e-mail notifications);
- promotions and promotional activities (payment of interest by trade organizations instead of the client, cash back and others);
- set up of chain of loan application approval/confirmation procedures within the existing organizational structure of the organization by creating various committees, decision-making boards;
- determination and segmentation of clients for the assignment of various loan products.
In such a way, a multidimensional matrix – constructor is formed for each loan product, which provides maximum flexibility for all necessary calculations and charges followed by their automatic display on the accounts in the General Ledger of the organization.
These features provide flexibility in the organization's sales strategy and prompt launch of new solutions onto the financial market.
Applications and loan memoranda control module for legal entities and individual entrepreneurs
Applications and loan memoranda control module for legal entities and individual entrepreneurs
The applications and loan memoranda control module for legal entities and individual entrepreneurs allows to fully automate the entire process of loan memorandum submitting, processing, initial approval, transfer of the memorandum to the committee for final decision and subsequent transfer of fully approved memoranda into the management system for loan agreements (credit conveyor) for granting of all types of loans to corporate clients:
- business loans;
- micro and SME loans;
- overdrafts;
- credit lines;
- syndicated loans;
- other loans.
The module supports loan granting for all possible business projects of potential corporate clients:
- construction and complex infrastructure projects;
- launch of startup projects;
- development of current business of clients, including financing of working capital, non-current assets;
- agricultural loans (farmers – equipment, animals, fertilizers, etc.).
Powered by a built-in constructor, the system allows an organization to independently manage the loan 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 depending on different values;
- to create and independently edit data drop-down lists.
The module provides a front office for branches and outlets as well as a back-office interface for integration with the automated banking system of an organization and for integration with external systems/services:
- state services for data provision about clients, guarantors, owners of legal entities and individual entrepreneurs;
- state services for data provision about incomes of shareholders/founders (tax office, social insurance fund, etc.);
- services for credit bureau data provision both about legal entities or individual entrepreneurs, and about shareholders, guarantors;
- services of state extracts on movable and immovable property;
- other services.
The loan financing memorandum is closely integrated with the Customer relationship management module (CRM), as a result of which all required corporate client data are filled in to the memorandum from the client data sheet in the automatic mode.
In addition, the system provides a number of control procedures at the time of memorandum fill-in for granting of loan to corporate clients:
- control over the general limit of the financial organization (no more than the agreed amount under other loan memoranda/no more than a certain amount from the capital of the financial organization, etc.);
- control of a valid director's ID available in the system;
- control in terms of persons associated with the financial organization;
- availability of all required attached documents and graphic data.
The system checks all possible relationships of the potential borrower in terms of participation in other loans as a borrower, guarantor, related party and other checks.
The following sections are included in the loan memorandum for corporate clients:
- financing terms (term, currency, amount, rate, grace days and other parameters that are defined in the loan product constructor);
- client profile (general information about the client, contact information, management, founders, related companies);
- market analysis (market share of a potential borrower, major competitors, major suppliers, strengths and weaknesses of a business, advantages of manufactured goods and services, business seasonality, environmental and social impact and other data as requested by the organization);
- project analysis (type of financing, project stages, total amount of the project, interest of financing on the part of founders and organization, experience in this project and other information);
- the purpose of the financing (working capital, equipment acquisition, and other purposes);
- Financial analysis is one of the key units in the loan memorandum on the basis of which the organization makes a decision. This unit includes subsystems:
- client's balance sheet. The functionality of the system involves the built-in constructor with which an organization’s specialist can independently create borrower balance sheets for an unlimited number of dates based on data provided by the client. The functionality of the system also provides a unique opportunity for a specialist of the organization to independently create balance sheets items without any restriction for legal entities and/or individual entrepreneurs within the specified sections (current assets, non-current assets, current liabilities, long-term liabilities, capital). In such a way, it is possible to analyze the balance sheets of legal entities and/or individual entrepreneurs as per different dates according to their internal detailing, taking into account general accounting principles. The system also provides the ability to automatically upload the balance sheet from Excel according to a set template;
- profit and loss statement — PLS. The functionality of the system involves the built-in constructor, on the basis of which an organization’s specialist can independently create borrower's profit and loss statements for an unlimited number of periods based on data provided by the client. The functionality of the system also provides a unique opportunity for a specialist of the organization to independently create PLS items without any restriction for legal entities and/or individual entrepreneurs within the specified sections (Incomes, Expenses). In such a way, it is possible to analyze PLS of legal entities and/or individual entrepreneurs as per different periods according to their internal detailing, taking into account general accounting principles. The system also provides the ability to automatically upload PLS according to a set Excel template;
- cash flow statement — CFS. The functionality of the system supports a built-in constructor, on the basis of which an organization’s specialist can independently create client's cash flow statements for an unlimited number of periods based on data provided by the client. The functionality of the system provides a unique opportunity for a specialist of the organization to independently create CFS items without any restriction for legal entities and/or individual entrepreneurs within the specified sections (Cash Flow from Operations, Cash Flow from Investments, Cash Flow from Financial Activities, Cash at Beginning of Period, Cash at End of Period). In such a way, it is possible to analyze CFS of legal entities and/or individual entrepreneurs as per different periods according to their internal detailing, taking into account general accounting principles. The system also provides the ability to automatically upload CFS according to a set Excel template;
- profit and loss statement (PLS), projection. The functionality of the system supports a built-in constructor with which an organization’s specialist can independently create projections of borrower's profit and loss statements for an unlimited number of periods. The functionality of the system also provides a unique opportunity for a specialist of the organization to create items of the projected PLS independently or automatically based on the actual data in PLS by using a certain ratio for further manual data adjustment within the specified sections (incomes, expenses). In addition, it is possible to automatically upload the projected PLS according to the set Excel template;
- cash flow statement (CFS), projection. The functionality of the system supports a built-in constructor with which an organization’s specialist can independently create projections of client's cash flow statements for an unlimited number of periods. The functionality of the system also provides a unique opportunity for a specialist of the organization to create items of the projected CFS independently or automatically based on actual data in CFS by using a certain ratio for further manual data adjustment within the specified sections (Cash Flow from Operations, Cash Flow from Investments, Cash Flow from Financial Activities, Cash at Beginning of Period, Cash at End of Period). In addition, it is possible to automatically upload the projected CFS according to the set Excel template;
- cross-check. The functionality of the system includes a cross-checking mechanism and an analysis mechanism by minimum financial indicators set in loan constructors regarding particular products. For example, the system automatically checks the comparison of net profit in PLS for the period and the differences in retained earnings in the borrower's balance sheet. Based on the borrower's financial statements, the system also performs calculations of various ratios (pre-configured in loan constructors) and provides a comparative analysis with the minimum indicators in products;
- client's credit history. The system's functionality supports downloading of credit history from Credit Information Bureaus not only for the client, but also for founders, guarantors, and other related parties. This allows to perform a comprehensive financial analysis of legal entities and individual entrepreneurs in terms of possible risks for the organization;
- current account turnovers. The functionality of the system allows the analysis of bank statements and turnovers on current accounts of legal entities and individual entrepreneurs for different periods. This functionality provides an analysis of cashless transactions not only of the organization itself, but also of statements from other financial and credit institutions. This unit allows to analyze the possible other income of the organization: commission fee for cash and settlement services, income from payroll products, fee for servicing payment terminals, etc. This information also serves as an additional verification mechanism for all financial statements of the client;
- security – collaterals. The functionality of the system allows to register various types of security within the framework of the loan memorandum in accordance with the minimum values in the loan constructors of the loan product. 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;
- other collateral;
- 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 controls the minimum package of documents for each product and ensures the storage of electronic document flow of legal entities and individual entrepreneurs in the framework of the loan memorandum. This unit includes not only borrower documents confirming the fact of his/her registration with the respective state agencies, and other statutory documents, but also scanned copies of documents confirming the identity of company shareholders, or registration documents of company shareholders, documents confirming the identity of guarantors, or registration documents of guarantors. The system does not have any restrictions on the number of documents included in the framework of the memorandum;
- monitoring regulations. The functionality of the system provides the ability to change the minimum conditions of loan monitoring set in the loan constructor within the framework of the loan memorandum. According to the decision of the respective persons and/or authorities, the financial monitoring arrangement, monitoring frequency, list of requested information, etc. can be changed. In such a way, the system provides flexibility in this regard in order to minimize the risks of the organization in making certain decisions;
- loan memorandum approval procedure. System’s functionality is deeply integrated into the control module for loan committees and workflows on loan application approval, so that the system directs all employees of the organization along the preconfigured decision-making chain.
The module includes the following functional units:
- creation and registration of loan memoranda;
- procedure before filling in the loan memorandum. The system allows to postpone the preparation of a memorandum for a certain period;
- procedure of sending of loan memoranda for approval/confirmation;
- procedure for an automated borrower financial analysis;
- procedure for borrower data compliance with the terms of selected product.
This module also supports setup and automated generation of required printing forms:
- loan application;
- loan memorandum form/client profile;
- consent to the processing of personal data;
- consent to the queries to various data sources, including a query to credit bureaus;
- other documents.
This module is used not only for the initial granting of all types of loans to legal entities and individual entrepreneurs, but also for repeat granting. Also, the module is used for filling-in and creating consultation sheets, on the basis of which loan memoranda can be created. Additionally, the functionality of this module allows to restructure the already granted loans with follow-up approval of such memorandum under the pre-configured decision-making chain.
As a result, the functionality of the system fully meets all the needs of a financial organization in legal entities and individual entrepreneurs financing regarding the creation of a loan memorandum and sending it to the approval process.
Application and loan memorandum control module for individuals
The application and loan memorandum control module for individuals allows to fully automate the entire process of loan memorandum submitting, processing, initial approval, transfer of the memorandum to the committee for final decision and subsequent transfer of fully approved memoranda into the management system for loan agreements (credit conveyor) for granting of all types of loans for individuals:
- cash loans;
- overdrafts;
- automobile loan;
- mortgage loans;
- loans for the service purchase (travel services and others)
- loans for the purchase of goods;
- credit cards (with or without grace period, installment);
Powered by a built-in constructor, the system allows an organization to independently manage the loan memorandum (application) form for individuals based on a built-in constructor:
- to determine required and optional entry fields;
- to determine interconnection of entry fields depending on different values;
- to create and independently edit data drop-down lists.
The module provides a front office for branches and outlets as well as a back-office interface for integration with the automated banking system of an organization and for integration with external systems/services:
- state services for personal data provision about clients, guarantors;
- state services for data provision about clients' incomes (tax office, social insurance fund, etc.);
- services for data provision from credit bureaus;
- services of state extracts on movable and immovable property;
- systems for borrower scoring point calculation;
- other services.
The loan financing memorandum for individuals is closely integrated with the Customer relationship management module (CRM) and other required systems, as a result of which all the necessary personal data of the client are filled in to the memorandum from the client data sheet in the automatic mode.
In addition, the system provides a number of control procedures at the time of memorandum fill-in on granting of a loan to individuals:
- control of a valid ID available in the system;
- availability of all required attached documents and graphic data;
- availability of client's biometric data, etc.
The system checks all possible relationships of the potential borrower in terms of participation in other loans as a borrower, guarantor, related party and other checks.
The following sections are included in the loan memorandum for individuals:
- product and financing terms (term, currency, amount, rate and other parameters that are defined in the loan product constructor);
- client profile, divided into main sections:
- personal information about the client (full name, date of birth, number of the client's ID document, date of issue of the document, etc.);
- contact information (work phone, home phone, mobile phone, contact persons);
- source and size of income of the client and his family (job, private business and other sources of income, amount earned from different sources of income);
- expenses of the client and his/her family (monthly expenses with the possibility of breaking down by different types: food, accommodation, etc.);
- social analysis (configurable questionnaires to calculate scoring points and to make automatic decisions);
- financing purpose (goods, mortgage, cash loan and other purposes);
- financial analysis (automatic calculation of various ratios, comparison of calculated values with the basic values set in constructors);
- security (real estate, transport, cash funds/deposits, guarantor/co-borrower, other collateral);
- documents and graphic data (scanned copies of identity documents, client photos, other documents required in accordance with loan constructor);
- client biometrics (fingerprint – Touch ID, Face ID);
- client's credit history;
- monitoring regulations;
- memorandum approval procedure (the functionality of the system is deeply integrated into the control module for loan committees and workflows on loan application approval, so that the system directs all employees of the organization along the preconfigured decision-making chain).
The module includes the following functional units:
- creation and registration of loan memoranda;
- procedure before filling in the loan memorandum. The system allows to postpone the preparation of a memorandum for a certain period;
- procedure of sending of loan memoranda for approval/confirmation;
- procedure for an automated borrower financial analysis;
- procedure for borrower data compliance with the terms of selected product.
This module also supports setup and automated generation of required printing forms:
- loan application;
- loan memorandum form/client profile;
- consent to the processing of personal data;
- consent to the queries to various data sources, including a query to credit bureaus;
- other documents.
This module is used not only for the initial granting of loan to individuals, but also for repeat granting, as well as for filling-in and creating consultation sheets, on the basis of which loan memoranda can be created.
Additionally, the functionality of this module allows to restructure the already issued loans with follow-up approval of such memorandum under the pre-configured decision-making chain.
As a result, the functionality of the system fully meets all the needs of a financial organization in individuals financing regarding the creation of a loan memorandum and sending it to the approval process.
Loan agreement control modul
The loan agreement control module allows registration of loan agreements in the system based on the loan memorandum approved under the approval chain, and performs automated accounting in accordance with the configured accounting model for a specific product by means of integration with the "General ledger" module.
The system supports registration of not only single, but also group loan agreements with automatic generation of required invoices and journal entries.
The functionality of the system for loan agreement control includes:
- creation of a loan agreement (or several agreements in case of group financing) in accordance with the decision made in the organization;
- loan repayment schedule generation (principal amount of loan, interest accrued, final payment, other values in accordance with the product terms);
- generation of a repayment schedule for all insurance agreements related to the granting of loan;
- generation of a loan monitoring schedule;
- automatic opening of all required balance sheet and off-balance sheet accounts for each loan transaction by means of integration with the "General ledger" module (accounts are opened under a specific client/agreement or under separate general balance sheet accounts, depending on the selected accounting model):
- loan granting;
- beginning of overdue;
- early and standard repayments;
- restructuring;
- change of risk/reserves group;
- write-off of interest and/or principal amount;
- suspension and resumption of interest and/or penalty interest accrual;
- 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);
- registration of an agreement and/or security agreements within the framework of an approved memorandum (collateral agreement, guarantee agreement with automated opening of all required off-balance sheet accounts and entries);
This module also supports setup and automated generation of required printing forms:
- loan agreement;
- repayment schedule;
- collateral agreement;
- loan monitoring schedule;
- other printing forms.
The module also supports setup of automatic billing for loan repayment from current accounts of individuals, legal entities, and individual entrepreneurs and/or their guarantors in accordance with repayment schedules and billing conditions.
Credit card control module
The credit card control module provides full automation for all processes related to credit cards from the moment of ordering of the credit card production and their PIN codes to the moment of concluding of the agreements with clients based on the loan memorandum approved under approval chain, and performs automated accounting in accordance with the configured accounting model for a specific product by means of integration with the "General ledger" module.
The functionality of the system supports all possible products within the framework of credit cards, namely:
- standard credit cards;
- credit cards with a grace period;
- credit cards for installments (division of payments into equal parts).
The credit card functionality for installment is controlled by user-friendly forms of the constructor and depends on the following main parameters:
- client segment;
- seller or group of sellers that conducted a credit card transaction;
- type of credit card and/or related credit product;
- type of transaction (retail, cash, etc.);
- interest repayment method (seller of goods, client, mixed).
The functionality of the system for credit card control includes:
- order of credit cards from branches and divisions;
- transfer of credit cards and their PIN codes to branches and divisions;
- creation of a loan agreement in accordance with the decision made in the organization;
- repayment schedule generation (principal amount of loan, interest accrued, final payment, other values in accordance with the product terms);
- generation of a loan monitoring schedule;
- automated opening of required balance sheet and off-balance sheet accounts;
- generating of the total credit limit of the card on off-balance sheet;
- automated generation of journal entries for created accounts based on the accounting model;
- registration of security agreements within the framework of the approved memorandum (collateral agreements, guarantee agreements).
The credit card control system also includes a subsystem for calculating bonuses ("cash back") of various loyalty programs with different partners (for example, replenishment of the client’s mobile phone balance and others).
This module also supports setup and automated generation of required printing forms:
- loan agreement;
- repayment schedule;
- collateral agreement;
- loan monitoring schedule;
- other printing forms.
The module also supports automatic repayment of debt from current accounts of individuals, legal entities and individual entrepreneurs and/or their guarantors.
Documentary transactions control module
The documentary transactions control module allows registration of agreements for all types of documentary transactions with legal entities and individual entrepreneurs based on the loan memorandum approved under approval chain, and performs automated accounting in accordance with the configured accounting model for a specific product.
The system's functionality supports all possible documentary transactions, namely:
- all types of bank guarantees (issued/accepted, secured/unsecured, revocable/irrevocable, etc.);
- all types of letters of credit (import/export, revocable/irrevocable, confirmed/unconfirmed, etc.);
- documentary remittance.
The functionality of the documentary transaction control system includes:
- creation of an agreement for performing documentary transactions in accordance with the decision made by the organization;
- repayment schedule generation (accrued interest, commission fees in accordance with the product terms);
- generation of an agreement monitoring schedule;
- automated opening of required balance sheet accounts:
- off-balance sheet account for the amount of liability under documentary transactions;
- account of commission fee or interest on documentary transactions;
- accrued penalty interest account;
- provision account for the value of liabilities of documentary transactions;
- other accounts required by the organization's accounting model or the regulator.
- automatic opening of the required debit and credit accounts:
- commission income account;
- accrued interest income account;
- expense accounts for accrued provisions;
- other income and expense accounts required by the organization's accounting model or by the regulator;
- generation of a limit on off-balance sheet documentary transactions;
- automated generation of journal entries for created accounts based on the accounting model;
- registration of security agreements within the framework of the approved memorandum (collateral agreements, guarantee agreements).
This module also supports setup and automated generation of required printing forms:
- agreement for documentary transactions;
- repayment schedule;
- collateral agreement;
- monitoring schedule;
- other printing forms.
Loan repayment control module
The loan repayment control module allows to fully automate the entire process of repayment of all loan types for legal entities, individuals and individual entrepreneurs, and to perform automated accounting in accordance with the configured accounting model for a specific product.
The functionality of the system supports both manual repayment and automatic repayment of client debt under loan agreements.
Within the framework of the system, a constructor is built in by means of which the organization can independently determine the priority of automatic repayment of client debt, for example:
- first priority — overdue fines and penalties;
- second priority — overdue accrued interest;
- third priority — overdue principal amount;
- fourth priority — current accrued interest;
- fifth priority — current principal amount.
The module also supports the manual repayment of loan with various operation arrangements:
- individual credit rate;
- redistribution of the payment amount within another repayment logic (first the principal amount, then the interest, etc.);
- individual write-off on the basis of a judicial decision, etc.
This module is closely integrated with other modules and subsystems of GNI Software, in particular with the modules of cash settlement, account-to-account transfers, the module for accounting of transactions via payment terminals and other modules and subsystems. The system also takes into account various sales channels for the preparation of analytical reports:
- branches and outlets of the organization;
- Internet banking;
- mobile banking;
- payment terminal and other terminals.
The functionality of the system for loan repayment (billing) control includes various units and subsystems:
- type of transaction (payment of initial payment, repayment, debt closure)
- currency;
- client with all details (integration with customer relationship management module);
- loan agreement with all details (amount of debt as per penalty interest, accrued interest, principal amount and other data);
- cash transaction code and/or payment code;
- automatic generation of entries as per created accounts on the basis of the accounting model by means of integration with the "General ledger" module.
This module also supports setup and automated generation of required printing forms:
- letter confirming the loan closure;
- other printing forms.
Loan agreement restructuring control module
The loan agreement restructuring control module allows to change the terms of loan agreements within the system based on the loan memorandum approved under approval chain, and to perform automated accounting in accordance with the configured accounting model for a specific product.
The functionality of the system supports the following types of restructuring:
- restructuring with interest/penalty interest freezing (payment at the end of the term upon the occurrence of certain events);
- restructuring with write-off of accrued interest and/or penalty interest;
- conversion of loan/line from one currency into another at a special rate;
- prolongation of all types of loans;
- generation of special schedules for loan (payment of interest only, seasonal payment of principal amount and interest, repayment of principal amount during certain periods of seasonality, many other possibilities);
- capitalization of interest accrued;
- other types of restructuring.
The restructuring functionality includes:
- generation of a new schedule for loan repayment in accordance with the terms of the restructuring;
- generation of an updated loan monitoring schedule;
- automatic generation of journal entries as per created accounts on the basis of the accounting model by means of integration with the "General ledger" module;
- registration of security agreements within the framework of the approved memorandum (collateral agreements, guarantee agreements);
- registration of insurance agreements within the framework of the approved memorandum (property insurance, other types of insurance).
This module also supports setup and automated generation of required printing forms:
- loan agreement (supplementary agreement);
- new repayment schedule;
- new collateral agreement;
- loan monitoring schedule;
- other printing forms.
As a result, the system provides all necessary tools for changing the current conditions of loan agreements for legal entities, individuals and individual entrepreneurs, both in automatic mode according to the set scenario, and in manual mode by an employee of the organization.
Control module for loan committees and workflows on loan application approval
Based on the built-in constructors, the control module for loan committees and workflows on loan application approval provides unprecedented opportunities to independently create and manage all types of loan committees, from one loan committee member to an unlimited number of committees with different structures and powers of committee members without programmers assistance on the common interface principle in accordance with the requirements of the organization.
The system's constructor provides broad options to setup different loan committees with the following basic parameters:
- setting the loan committee level (level 1, level 2, etc.);
- assignment of a committee for a structural division (for an entire organization, for 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 committees and their structure are formed, another constructor is built in the module, which provides configuration of the workflows for the approval of loan memoranda for both individuals, legal entities, and individual entrepreneurs. The following basic parameters are included in this constructor to setup the approval workflow:
- product group segmentation (consumer financing, business loans, etc.);
- product (a particular product by which individual approval rules are configured);
- assignment of approval chain for structural division loan application (for the 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 financing amount confirmed by a particular committee);
- granting terms (standard, non-standard);
- sequence principle (confirmation is final or another level of approval is required);
- committee approving this product;
- sequence (in what sequence the product is approved);
- purpose of decision (granting of financing 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 loan application approval without technical staff assistance, which supports online voting for all required committee members according to the approved memoranda.
In addition to the above, the module includes functionality for tracking the flow of loan committees to ensure maximum decision-making speed within the structural divisions of the organization and improve the quality of client service.
This module also supports setup and automated generation of required printing forms:
- voting protocol;
- other documents.
As a result, the functionality of the system fully meets all the needs of a financial organization in setting up a workflow for approval of loan applications/memoranda for all types of clients.
Loan provision control module
The loan provision control module allows to fully automate the processes related to the formation and recovery of provisions with their subsequent display in accounting entries, both for individuals, and for legal entities and individual entrepreneurs, by means of integration with "General ledger" module.
This module involves setup of the workflow for potential loss provision accrual using a parametric constructor. With system structure the organization can independently manage the processes of provision accrual without programmers or technical staff assistance and thereby quickly respond to the organization's state of affairs and/or to requirements of the regulator.
All types of provision accrual transactions are fully integrated into various modules of the system, including “Loan agreement control module”, "Loan cards control module", "Documentary transactions control module", “General ledger”. As a result, the system provides all automatic calculations and accounting without any manual intervention on the part of the organization's employees.
The module provides a front-office for branches and outlets, as well as a back-office interface to process the provision accrual/recovery.
This module involves setup of any classifications of provision types in two units:
- general provision for potential loss — principal amount (principal amount without overdue);
- special provision for potential loan loss — principal amount (overdue principal amount);
- general provision for potential loan loss — interest-bearing debt;
- special provision for potential loss — interest-bearing debt (including penalty interest and penalties);
The functionality of the provision control system includes various units and subsystems:
- Classification of loan agreements for provision accrual with a breakdown of each of two units (special, general provision) into different segments:
- group of clients;
- product group;
- loan products;
- currency;
- number of days overdue (principal debt and/or interest);
- risk scoring (regulated by a separate risk control module);
- other parameters of loan portfolio segmentation.
- assignment of interest for provision accrual for each type of provision classification (normal, satisfactory, under supervision, doubtful, loss/write-off, etc.);
- automatic calculation of provision for the following three types:
- only for the principal amount;
- only for interest;
- for the principal amount and interest.
- creation of accounting entries in automatic mode for calculated provision by means of integration with the “General ledger” module;
- procedure for changing the classification of loan agreement and documentary transactions with subsequent display in accounting records by means of integration with the “General ledger” module;
- procedure for changing of provision calculation values with subsequent display in accounting records by means of integration with the “General ledger” module.
In addition, when calculating provisions, the system's functionality allows to take into account the cost of security for loans and documentary transactions.
This module generates a report on monitoring of accrued provision in the context of various analytics, in particular, on:
- risk groups
- Departments;
- Branches;
- Products;
- Client group;
- Terms;
- Other data segments.
Loan monitoring module
The loan monitoring module allows to fully automate the entire process of monitoring of all types of loans to individuals, legal entities, and individual entrepreneurs.
The functionality of the system supports:
- scheduled monitoring (as per schedule);
- unscheduled monitoring.
The system also allows to create and store two or more monitoring schedules for each loan agreement.
The system has a built-in constructor, through which the organization can independently manage all processes related to monitoring of loan agreements and agreements for documentary transactions without the technical staff assistance, including forming various templates for monitoring schedules and assigning them to different client groups, product groups, and products.
The functionality of the loan monitoring system includes various units and subsystems:
- registration of planned schedules and unscheduled inspections of borrowers and/or guarantors;
- determination of monitoring frequency;
- determination of monitoring types (enterprise visits, data request, financial statements request, cross-checks from publicly available resources). All types of monitoring can be determined within the schedule and performed by the employees of the organization in parallel;
- registration of monitoring results in a structured format including the results of financial analysis:
- balance sheet for legal entities and individual entrepreneurs;
- profit and loss statement — PLS;
- cash flow statement — CFS;
- assignment of a method for selection of a monitoring specialist (randomly, to monitor regions, to monitor groups of clients, etc.);
- transfer of a client from one risk group to another based on monitoring results in order to accrue/adjust provisions using the loan provisions control module.
This module generates a report on monitoring of financing in the context of various analytics, in particular, on:
- employees;
- departments;
- branches;
- products;
- client groups;
- terms;
- other data segments.
This module also supports setup and automated generation of required printing forms:
- monitoring protocol;
- other printing forms.
In such a way, the module allows to address all the tasks of the organization related to loan monitoring and processing of the results of such monitoring, both for individuals, legal entities, and for individual entrepreneurs.
Bad loan control module
The bad loan control module enables an organization to create unique opportunities to fully automate workflows without the technical staff or programmers assistance, for each loan product or product group, both for individuals and legal entities, and for individual entrepreneurs, using the parametric constructors.
The module provides a front office for branches and outlets and a back-office interface for the organization's head office to confirm transactions.
The functionality of the bad loan management system includes various units and subsystems:
- procedure for full and/or partial write-off of bad debt (principal amount, interest accrued);
- automatic generation of journal entries as per created accounts on the basis of the accounting model by means of integration with the "General ledger" module;
- procedure for full and/or partial recovery of bad debt (principal amount, interest accrued);
- approval procedure for bad debt write-off (setup of write-off approval chain) with a breakdown into:
- limits;
- currencies;
- products;
- product groups;
- group of clients.
This module generates a report on written-off bad loans in the context of various analytics, including:
- departments;
- branches;
- products;
- client group;
- debt periods;
- other data segments.
In such a way, the module allows to address all the tasks of the organization related to bad loan management within the system, both for individuals, and for legal entities and individual entrepreneurs.
Other property control module
The other property control module enables an organization to control other property from the moment of registration of such property, valuation, revaluation, sale at auction to conducting all accounting entries within the automated banking system.
This module is designed to set up all types and subtypes of other property by using a parametric constructor. With this system structure the organization can independently set up any types and subtypes of other property without programmers or technical staff assistance and implement them in the shortest possible time.
The main types of other property on the balance sheet of an organization can be:
- buildings and constructions;
- means of transport;
- agricultural equipment;
- special equipment;
- other types of equipment.
The system's functionality makes it possible to perform all types of transactions related to other property on a single-window concept, including:
- creating types and subtypes of other property;
- setting up an accounting model for automatic accounting of each property type;
- setting up the procedure for evaluation and revaluation of other property;
- writing off the value of other property based on valuation reports;
- holding auctions for the sale of other property (above or below the collateral value);
- direct sale of other property;
- sale of other property on credit;
- recording the other property in the balance sheet as a fixed asset (through direct integration with the fixed assets control module).
This module generates a report on organization's other property in the context of various analytical data slices, in particular, on:
- client group;
- products;
- departments and branches;
- types and subtypes of other property;
- risk group of loan portfolio;
- other data segments.
This module also supports setup and automated generation of required printing forms:
- a report on the evaluation of other property;
- act on revaluation of other property on the balance sheet of the organization;
- act on the sale of other property;
- other printing forms.
Thus, the module allows to address all the tasks of the organization related to the accounting and sale of other property, for both individual, legal entities, and individual entrepreneurs.
Security and collateral control module
The security and collateral control module helps an organization to setup and manage security policy, both for individuals and legal entities, and for individual entrepreneurs, on the single-window concept.
The security and collateral management system supports all security types, specifying a detailed structured description for each collateral:
- real estate;
- intangible assets, including property rights;
- transport (ships, special or military vehicles, cars, etc.);
- equipment;
- gold and precious metals;
- inventory, current assets, including goods in circulation;
- securities;
- guarantee;
- deposits and current accounts;
- letters of guarantee;
- animals (cattle, small ruminants, etc.);
- other types of security.
The entire accounting model under this module is configured via a specific built-in constructor, therefore all transactions in the accounting are conducted automatically through the system transactional accounting.
The module provides a front office and a back-office interface to process transactions related to securities and collateral.
The module includes the following functional units:
- setup of the collateral policy of the organization for each product includes a list of the following key parameters:
- collateral structure (minimum/maximum value);
- client segment;
- product segment;
- product;
- discount factor for collateral value;
- market value;
- salvage value;
- documents confirming the ownership of collateral;
- other parameters for each individual type of security.
- setup of accounting model for each type of security (off-balance sheet accounts);
- 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.
This module generates a report on monitoring of security and collateral in the context of various analytics, in particular, on:
- client group;
- products;
- departments and branches;
- types of security and collateral;
- risk group of loan portfolio;
- other data segments.
This module also supports setup and automated generation of required printing forms:
- Collateral agreement;
- Guarantee agreement;
- Collateral monitoring schedule and other printing forms.
Thus, the module allows to address all the tasks related to security and collateral management for all groups of organization's clients.
Subsystem for report preparation on loans and documentary transactions
The subsystem for report preparation on loans and documentary transactions allows an organization to generate various types of statements, for both individuals and legal entities, and for individual entrepreneurs, in both transactional and analytical Oracle Business Intelligence system.
The subsystem supports the following reporting areas for all types of loan systems:
- general loan portfolio;
- loan portfolio on different analytical data slices;
- collateral portfolio;
- portfolio of other property recorded on the balance sheet of the organization;
- loan reports and accounting as per IFRS 9 standards.
- The reporting system includes a number of reports with many parameters and details, in the context of:
- clients;
- client groups;
- product groups;
- products;
- currencies;
- terms;
- the number of overdue days on principal amount;
- the number of overdue days on interest;
- risk groups;
- security share;
- other parameters.
All these reports provide a complete and accurate online picture of the organization's situation for effective and full asset management and achievement of key performance indicators (KPIs).
Overdue loan control module
The troubled loan control module enables an organization to create unique opportunities to create workflows without the technical staff or programmers assistance, for each loan product or product group, both for individuals and legal entities, and for individual entrepreneurs, using the parametric constructors.
The module provides a front office for branches and outlets, as well as a back-office interface for configuring steps for controlling overdue debts and integrating with external systems ("call center" and others).
The functionality of the overdue loan management system includes various units and subsystems:
- determination of client groups;
- determination of products;
- generating of overdue loan portfolio;
- creation of different scenarios for dealing with overdue loans;
- determination of the steps of the overdue loan department in different scenarios;
- grouping of steps according to various logical attributes;
- determination of rules for transition between scenarios;
- determination of rules for transition between steps;
- determination of managers/employees of the organization and assignment them responsible for performing a particular step;
- creation of a planned schedule for completing steps for the overdue loan portfolio;
- analysis of actual implementation of steps with planned values and reasons indicated;
- creation of a list of reasons and results of actions taken by managers of the department for overdue loan management.
This module generates a report on monitoring of overdue loans in the context of various analytics, in particular, on:
- risk groups;
- departments;
- branches;
- products;
- client group;
- completed steps;
- non-completed steps;
- reasons for non-completing the steps, etc.;
- other data segments.
In such a way, the module allows to address all the tasks of the organization related to overdue loan management and processing of the results of such management, both for individuals, and for legal entities and individual entrepreneurs.