Logic control system based on security liquidation product

Abstract

The invention discloses a logic control system based on a security liquidation product, and relates to the technical field of security liquidation. Comprising the steps of automatic clearing process and voucher generation, multi-level clearing management, data reconciliation and consistency check, multi-currency support and exchange processing, voucher template and data dictionary mapping, clearing role and authority management, real-time data backup and log management, and automatic clearing process and voucher generation. The system is composed of a batch data acquisition unit and a voucher template configuration unit, and data is acquired from a front-end business system to a clearing system regularly in a data warehouse writing storage process. According to the logic control system based on the security liquidation product, liquidation management helps an enterprise to process financial accounting of all broker businesses; the settlement management generates accounting documents of all institutions through one-key trial calculation according to a preset business accounting rule and background system data acquisition work; therefore, manual order making is reduced, the maintenance and operation cost is reduced, the financial accounting efficiency is improved, and a statistical basis is provided for various analyses.

Description

Technical Field

[0001] The present invention relates to the technical field of securities clearing, and in particular to a logic control system based on securities clearing products. Background Art

[0002] The invention background of the clearing management system mainly stems from the increasing demand for efficient and accurate clearing in the financial and securities industries.

[0003] The following are the background factors that drove the development of this system:

[0004] 1. With the expansion of financial markets, the transaction volume of securities companies and financial institutions has surged. The manual processing of clearing data and the generation of accounting vouchers has become inefficient, prone to errors and difficult to meet the needs of high frequency and large data volumes. Therefore, financial institutions need a system that can automate and batch clearing processing to improve efficiency.

[0005] 2. The clearing process of securities companies involves multiple levels (headquarters, branches, business departments, etc.) and multiple business scenarios (such as primary clearing and secondary clearing). Manually managing these complex processes is time-consuming and prone to data inconsistency. Therefore, it is crucial to design an automated system to support clearing in multiple levels and complex scenarios.

[0006] 3. With the increase in regulatory requirements, securities companies and financial institutions need to ensure the accuracy and compliance of financial data; the clearing management system ensures the standardization of accounting documents and reduces compliance risks through preset voucher templates and automated accounting rules;

[0007] 4. In financial institutions, clearing business data is usually scattered in multiple systems, such as over-the-counter transaction systems, legal person clearing systems, etc.; due to the different standards of these systems, it is easy to cause data reconciliation difficulties; this system supports automated data reconciliation and unified account management, solves the problem of inconsistent data sources, and provides a reliable data foundation for financial accounting;

[0008] To sum up, the design and development background of the clearing management system is to solve a series of problems in the financial industry, such as complex clearing processes, large amounts of data, high difficulty in reconciliation, and strict compliance requirements, and to optimize clearing efficiency and accuracy through automation and batching. Summary of the invention

[0009] In view of the deficiencies of the prior art, the present invention provides a logic control system based on securities clearing products, which solves the problems raised in the above-mentioned background technology.

[0010] To achieve the above objectives, the present invention is implemented through the following technical solutions: a logical control system based on securities clearing products, including automated clearing process and voucher generation, multi-level clearing management, data reconciliation and consistency check, multi-currency support and exchange processing, voucher template and data dictionary mapping, clearing role and authority management, real-time data backup and log management;

[0011] Automated clearing process and voucher generation, consisting of a batch data collection unit and a voucher template configuration unit. The data warehouse writes stored procedures to collect data from the front-end business system to the clearing system on a regular basis. The clearing system automatically calculates and generates vouchers through the system's background task configuration.

[0012] Multi-level clearing management, consisting of hierarchical clearing architecture units, multi-select trial calculation and generation units, is used to generate all-selected financial accounting books and voucher templates;

[0013] Data reconciliation and consistency check, which consists of system reconciliation unit, data monitoring and exception handling unit, provides reconciliation view for comparing differences between module and business data;

[0014] Multi-currency support and exchange processing, consisting of a multi-currency exchange rule unit and a clearing day and transaction calendar setting unit, automatically uses the system exchange rate to calculate the debit and credit amounts in the local currency when generating vouchers;

[0015] Voucher template and data dictionary mapping, which consists of voucher template custom unit and digital dictionary and comparison table configuration unit, supports custom data dictionary and internal and external system organization comparison;

[0016] Clearing role and authority management, which consists of a role authority allocation unit and a template usage authority control unit, is used to configure the availability of accounting books and templates;

[0017] Real-time data backup and log management, consisting of a data backup and recovery unit and an operation log and audit unit, is used to automatically record detailed trial calculation logs and the generation date of vouchers.

[0018] Optionally, for batch data collection, the system collects data from different business systems in batches through the stored procedures written by the data warehouse, specifically the data collected by the Xinyi or counter system, including but not limited to the secondary transaction and settlement summary table of economic business, the open-end fund transaction table, and the fixed-point delivery details table, and provides timed and manual import functions;

[0019] Voucher template configuration: the system has a built-in standardized economic business clearing voucher template library, and voucher templates can be customized according to different business scenarios to support the primary and secondary clearing needs of the headquarters and various business departments; the voucher template automatically associates the data retrieval rule configuration formulas of the data source tables of different businesses, and generates corresponding accounting vouchers based on the data retrieval rule configuration, reducing the workload of manual voucher generation.

[0020] Optionally, in the hierarchical clearing architecture, the system supports a hierarchical design of primary clearing and secondary clearing; primary clearing is used for headquarters accounting, and secondary clearing is used for branches and business departments;

[0021] Multi-select Trial Calculation and Generate allows users to perform batch trial calculation and generate vouchers for the account books and business types within the scope of authority. Specifically, in the Voucher Generation node, select the financial accounting account books and clearing voucher template business types to be generated; and generate general ledger vouchers through the Trial Calculation and Generate Voucher buttons.

[0022] Optionally, the system reconciliation function implements the data reconciliation function between the general ledger account of the UFIDA system and the over-the-counter transaction system and the legal person clearing system; through free reports and data comparison tools, the system automatically identifies differences and generates reconciliation reports;

[0023] Data monitoring and exception handling. The system is equipped with a real-time data monitoring module. The background task module of the collection system monitors the execution of collection tasks to ensure the accuracy of daily voucher generation and data import. If the collection fails or there is no data, it is judged as abnormal data, and the background task warning is used to push warning messages to financial personnel for timely manual inspection and repair.

[0024] Optionally, the system provides a multi-currency conversion function for the multi-currency exchange rules, supports the conversion of foreign currencies into local currencies, automatically calculates the debit and credit amounts of local currencies according to the preset exchange rate rules, and automatically balances the tail difference according to the definition of the netting line set in the voucher template;

[0025] Settlement day and trading calendar. The system provides a work calendar function based on the needs of different markets. Specifically, different clearing and delivery rules are set, and the clearing calendar is used to define trading days for different trading markets.

[0026] Optionally, the voucher template is customized, and the user can customize the data extraction formula and data source of the voucher template. The system automatically configures the data extraction conditions according to business needs and flexibly adapts to various clearing scenarios;

[0027] Data dictionary and comparison table configuration, through the clearing data dictionary and basic data comparison table, the clearing data dictionary is the functional node in the clearing system, and the basic data comparison is the functional node of the integration platform. The system can configure the data mapping relationship between multiple systems, so that the financial subjects and organization codes of different systems are unified, and support the seamless connection between external data and internal systems.

[0028] Optionally, for the role authority allocation, the system supports the division of clearing authority according to roles, such as headquarters clearing role and business department clearing role, and different roles control different accounting books;

[0029] Template usage permission control: for different clearing categories, the system controls the access rights of each clearing role to the voucher template.

[0030] Optionally, for the data backup and recovery, the system generates log records for all liquidation operations and backs up liquidation data. The backed-up liquidation data is classified according to account books, business categories, and dates, and supports abnormal recovery and data rollback functions.

[0031] The present invention provides a logic control system based on securities clearing products, which has the following beneficial effects:

[0032] The logic control system based on securities clearing products automates data collection, optimizes data collection algorithms, and significantly reduces the time consumption of batch import and voucher generation processes, greatly improving efficiency; the layered clearing management architecture supports parallel clearing of different business types, allowing large-scale, cross-departmental clearing tasks to be completed quickly;

[0033] The system uses the automatic reconciliation function to ensure the consistency of accounts between the UFIDA system and the external clearing system and counter system, effectively reducing errors in manual reconciliation and ensuring the accuracy of clearing data; real-time data monitoring and abnormal alarm mechanisms further enhance data consistency, allowing potential data errors in the clearing process to be quickly discovered and corrected;

[0034] Standardized voucher templates and accounting subject settings ensure the consistency of format, content and subject of all generated accounting vouchers, meeting the regulatory agency's requirements for financial compliance; system logging and role authority management improve the security and transparency of the system, effectively supporting internal audits and compliance checks;

[0035] The system's multi-currency conversion and automatic exchange balance functions solve the settlement problems faced by financial institutions in a multi-currency environment, making the settlement process of cross-border business more efficient and accurate; the flexible configuration of the work calendar and settlement calendar adapts to the settlement rules of different markets, reduces the cost of manual maintenance, and ensures the reconciliation and settlement needs of multiple markets;

[0036] The custom configuration function of voucher templates enables the system to quickly adapt to the personalized needs of different customers and support the expansion and change of future business scenarios; the flexible setting of data dictionary and comparison table ensures that the system can integrate data from different external systems and achieve seamless connection with other business systems;

[0037] The system reduces manual operations in liquidation, reduces operational risks and labor costs, and also reduces maintenance and operating costs during the liquidation process, thus improving the overall financial processing efficiency of the enterprise. The system's automated processes and flexible configurations make user operations simpler and faster, reduce manual intervention and misoperation, and improve user experience. Through authority management, users can perform corresponding liquidation operations according to their roles, effectively allocating work authority and enhancing the convenience and security of the system.

[0038] The clearing management system has achieved remarkable technical results in improving clearing efficiency, enhancing data accuracy and compliance, supporting multi-currency clearing, reducing costs, and improving user experience, providing an efficient, stable, and flexible technical solution for clearing management of financial and securities institutions. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 It is a schematic diagram of the invention process. DETAILED DESCRIPTION

[0040] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments.

[0041] See also Figure 1 , the present invention provides a technical solution: a logical control system based on securities clearing products, including automated clearing process and voucher generation, multi-level clearing management, data reconciliation and consistency check, multi-currency support and exchange processing, voucher template and data dictionary mapping, clearing role and authority management, real-time data backup and log management;

[0042] Automated clearing process and voucher generation, consisting of a batch data collection unit and a voucher template configuration unit. The data warehouse writes stored procedures to collect data from the front-end business system to the clearing system on a regular basis. The clearing system automatically calculates and generates vouchers through the system's background task configuration.

[0043] Batch data collection: the system collects data from different business systems in batches through the stored procedures written by the data warehouse. Specifically, the data collected by the Xinyi or counter system includes but is not limited to the secondary transaction and settlement summary table of economic business, the open-end fund transaction table, and the fixed-point delivery details table, and provides timed and manual import functions;

[0044] Voucher template configuration: the system has a built-in standardized economic business clearing voucher template library, and voucher templates can be customized according to different business scenarios to support the primary and secondary clearing needs of the headquarters and various business departments; the voucher template automatically associates the data retrieval rule configuration formulas of the data source tables of different businesses, and generates corresponding accounting vouchers according to the data retrieval rule configuration, reducing the workload of manual voucher generation;

[0045] Multi-level clearing management, consisting of hierarchical clearing architecture units, multi-select trial calculation and generation units, is used to generate all-selected financial accounting books and voucher templates;

[0046] Hierarchical clearing architecture: the system supports hierarchical design of primary clearing and secondary clearing; primary clearing is used for headquarters accounting, and secondary clearing is used for branches and business departments;

[0047] Multi-select trial calculation and generation allows users to perform batch trial calculation and generate vouchers for the account books and business types within the scope of authority. Specifically, in the voucher generation node, select the financial accounting account books and clearing voucher template business types to be generated; and generate general ledger vouchers through the trial calculation and generate voucher buttons;

[0048] Data reconciliation and consistency check, which consists of system reconciliation unit, data monitoring and exception handling unit, provides reconciliation view for comparing differences between module and business data;

[0049] System reconciliation function: the system realizes the data reconciliation function between the general ledger account of the UFIDA system and the over-the-counter transaction system and the legal person clearing system; through free reports and data comparison tools, the system automatically identifies differences and generates reconciliation reports;

[0050] Data monitoring and exception handling. The system is equipped with a real-time data monitoring module. The background task module of the collection system monitors the execution of collection tasks to ensure the accuracy of daily voucher generation and data import. If the collection fails or there is no data, it is determined to be abnormal data, and the warning message is pushed to the financial personnel through the background task warning, so that manual inspection and repair can be carried out in time.

[0051] Multi-currency support and exchange processing, consisting of a multi-currency exchange rule unit and a clearing day and transaction calendar setting unit, automatically uses the system exchange rate to calculate the debit and credit amounts in the local currency when generating vouchers;

[0052] Multi-currency exchange rules: The system provides multi-currency conversion functions, supports foreign currency to local currency conversion, automatically calculates local currency debit and credit amounts according to preset exchange rate rules, and automatically balances the tail difference according to the netting line definition set in the voucher template;

[0053] Set up clearing day and trading calendar. The system provides a working calendar function based on the needs of different markets. Specifically, it sets different clearing and delivery rules and uses the clearing calendar to define trading days for different trading markets.

[0054] Voucher template and data dictionary mapping, which consists of voucher template custom unit and digital dictionary and comparison table configuration unit, supports custom data dictionary and internal and external system organization comparison;

[0055] Customized voucher templates: users can customize the data extraction formula and data source of voucher templates. The system automatically configures the data extraction conditions according to business needs, and flexibly adapts to various clearing scenarios.

[0056] Data dictionary and comparison table configuration: through the clearing data dictionary and basic data comparison table, the clearing data dictionary is a functional node in the clearing system, and the basic data comparison is a functional node of the integration platform. The system can configure the data mapping relationship between multiple systems, so that the financial subjects and institution codes of different systems are unified, and support the seamless connection between external data and internal systems;

[0057] Clearing role and authority management, which consists of a role authority allocation unit and a template usage authority control unit, is used to configure the availability of accounting books and templates;

[0058] Role authority allocation: the system supports the division of clearing authority by role, such as headquarters clearing role and business department clearing role. Different roles control different accounting books.

[0059] Template usage permission control: for different clearing categories, the system controls the access rights of each clearing role to the voucher template;

[0060] Real-time data backup and log management, consisting of a data backup and recovery unit and an operation log and audit unit, which automatically records detailed trial calculation logs and the date of voucher generation;

[0061] Data backup and recovery: the system generates log records for all liquidation operations and backs up liquidation data. The backed-up liquidation data is classified by account book, business category, and date, and supports abnormal recovery and data rollback functions.

[0062] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. A logical control system based on securities clearing products, characterized in that: Including automated clearing process and voucher generation, multi-level clearing management, data reconciliation and consistency check, multi-currency support and exchange processing, voucher template and data dictionary mapping, clearing role and authority management, real-time data backup and log management; Automated clearing process and voucher generation, consisting of a batch data collection unit and a voucher template configuration unit. The data warehouse writes stored procedures to collect data from the front-end business system to the clearing system on a regular basis. The clearing system automatically calculates and generates vouchers through the system's background task configuration. Multi-level clearing management, consisting of hierarchical clearing architecture units, multi-select trial calculation and generation units, is used to generate all-selected financial accounting books and voucher templates; Data reconciliation and consistency check, which consists of system reconciliation unit, data monitoring and exception handling unit, provides reconciliation view for comparing differences between module and business data; Multi-currency support and exchange processing, consisting of a multi-currency exchange rule unit and a clearing day and transaction calendar setting unit, automatically uses the system exchange rate to calculate the debit and credit amounts in the local currency when generating vouchers; Voucher template and data dictionary mapping, which consists of voucher template custom unit and digital dictionary and comparison table configuration unit, supports custom data dictionary and internal and external system organization comparison; Clearing role and authority management, which consists of a role authority allocation unit and a template usage authority control unit, is used to configure the availability of accounting books and templates; Real-time data backup and log management, consisting of a data backup and recovery unit and an operation log and audit unit, is used to automatically record detailed trial calculation logs and the generation date of vouchers.

2. The logic control system based on securities clearing products according to claim 1, characterized in that: The batch data collection system uses the stored procedures written by the data warehouse to batch collect data from different business systems, specifically the data collected by the Xinyi or counter system, including but not limited to the secondary transaction and settlement summary table of economic business, the open-end fund transaction table, and the fixed-point delivery details table, and provides timed and manual import functions; Voucher template configuration: the system has a built-in standardized economic business clearing voucher template library, and voucher templates can be customized according to different business scenarios to support the primary and secondary clearing needs of the headquarters and various business departments; the voucher template automatically associates the data retrieval rule configuration formulas of the data source tables of different businesses, and generates corresponding accounting vouchers based on the data retrieval rule configuration, reducing the workload of manual voucher generation.

3. The logic control system based on securities clearing products according to claim 1, characterized in that: The hierarchical clearing architecture supports the hierarchical design of primary clearing and secondary clearing. Primary clearing is used for headquarters accounting, and secondary clearing is used for branches and business departments. Multi-select Trial Calculation and Generate allows users to perform batch trial calculation and generate vouchers for the account books and business types within the scope of authority. Specifically, in the Voucher Generation node, select the financial accounting account books and clearing voucher template business types to be generated; and generate general ledger vouchers through the Trial Calculation and Generate Voucher buttons.

4. The logic control system based on securities clearing products according to claim 1, characterized in that: The system reconciliation function implements the data reconciliation function between the general ledger account of the UFIDA system and the over-the-counter transaction system and the legal person clearing system; through free reports and data comparison tools, the system automatically identifies differences and generates reconciliation reports; Data monitoring and exception handling. The system is equipped with a real-time data monitoring module. The background task module of the collection system monitors the execution of collection tasks to ensure the accuracy of daily voucher generation and data import. If the collection fails or there is no data, it is judged as abnormal data, and the background task warning is used to push warning messages to financial personnel for timely manual inspection and repair.

5. The logic control system based on securities clearing products according to claim 1, characterized in that: The system provides a multi-currency conversion function for the multi-currency exchange rules, supports the conversion of foreign currencies into local currencies, automatically calculates the debit and credit amounts of local currencies according to the preset exchange rate rules, and automatically balances the tail difference according to the definition of the netting line set in the voucher template; Settlement day and trading calendar. The system provides a work calendar function based on the needs of different markets. Specifically, different clearing and delivery rules are set, and the clearing calendar is used to define trading days for different trading markets.

6. The logic control system based on securities clearing products according to claim 1, characterized in that: The voucher template is customized. Users can customize the data extraction formula and data source of the voucher template. The system automatically configures the data extraction conditions according to business needs and flexibly adapts to various clearing scenarios. Data dictionary and comparison table configuration, through the clearing data dictionary and basic data comparison table, the clearing data dictionary is the functional node in the clearing system, and the basic data comparison is the functional node of the integration platform. The system can configure the data mapping relationship between multiple systems, so that the financial subjects and organization codes of different systems are unified, and support the seamless connection between external data and internal systems.

7. The logic control system based on securities clearing products according to claim 1, characterized in that: The system supports the division of clearing authority by role, such as headquarters clearing role and business department clearing role. Different roles control different accounting books. Template usage permission control: for different clearing categories, the system controls the access rights of each clearing role to the voucher template.

8. The logic control system based on securities clearing products according to claim 1, characterized in that: For data backup and recovery, the system generates log records for all liquidation operations and backs up liquidation data. The backed-up liquidation data is classified according to account books, business categories, and dates, and supports abnormal recovery and data rollback functions.

Images