Method, medium and equipment for timed and batch settlement of funds

Through the timed batch liquidation method of funds, the efficiency problem of the existing payment and clearing system in high concurrency scenarios is solved. By processing transaction details and account data in batches, the available balance is calculated, and more efficient fund liquidation is achieved and user experience is improved. and system performance.

CN119006160AInactive Publication Date: 2024-11-22RURAL CREDIT BANKS FUNDS CLEARING CENT CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
CN202411086146.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-08
Publication Date
2024-11-22
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The existing payment and clearing system cannot meet the business processing efficiency needs in the high concurrent capital flow scenarios. Real-time clearing of each transaction has led to an increase in database pressure, reducing the clearing speed and user experience.

Method used

By obtaining transaction flow details, creating a clearing summary table, splitting the network-entering agency account into multiple pieces of data, clearing transaction flow details in batches, calculating available balances, and determining whether the account is sufficient, avoiding real-time transactions one by one. Performance bottlenecks in liquidation.

Benefits of technology

It reduces the time-consuming and time-consuming of massive funds clearing, improves user transfer experience, avoids concurrent locking problems, improves processing efficiency, and solves the performance bottleneck of real-time liquidation transactions.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119006160A_ABST
    Figure CN119006160A_ABST
Patent Text Reader

Abstract

The invention provides a method, a medium and equipment for timed and batch settlement of funds. The method comprises the following steps: obtaining transaction flow details of a network access mechanism, and storing the transaction flow details into a timed settlement flow table; creating a clearing summary sheet, and splitting the network access mechanism account into a plurality of pieces of data for storage; regularly clearing transaction flow details in batches; network access mechanism account data in the liquidation summary sheet is updated; querying the current account table to obtain an account balance, a transfer amount and an overdraft limit; querying a liquidation summary sheet to obtain a total amount of non-posted debit money and a total amount of non-posted loan money; calculating the available balance of the network access mechanism account; and judging whether the corresponding network access mechanism account is successfully cleared or not according to the available balance. The available balance of the clearing account is calculated in real time, so that the risk of overdraft of the clearing account is avoided.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of payment and clearing technology, and more specifically, to a method, medium and equipment for timed batch clearing of funds. Background Art

[0002] With the continuous introduction of financial payment models and the continuous advancement of the construction of a standardized system for the financial industry, the existing payment system of rural small and medium-sized financial institutions is not in line with current development needs in terms of performance architecture. Therefore, the construction of a payment and clearing system is very urgent, and it is necessary to meet high-concurrency capital flow scenarios, fine-tune capital management, meet business processing efficiency, and improve payment service capabilities.

[0003] In the payment and clearing system, it is necessary to calculate the available balance of the clearing account of each network institution in real time to verify whether the account has sufficient funds.

[0004] The current main technical solution is to calculate the available balance by performing real-time settlement for each transaction flow to determine whether the settlement is successful. Real-time settlement requires calculating the available balance of the account once for each transaction.

[0005] Among them, the available balance refers to the standard for the payment and clearing system to determine whether the network institution can conduct debit business. Available balance = book balance - deposit amount + overdraft limit + unrecorded amount, among which the book balance, deposit amount and overdraft limit are stored in the current account table and can be obtained by querying the table according to the clearing account number. The unrecorded amount is the change amount summarized in real time according to the real-time transaction flow on the Tth day. The unrecorded amount = the total unrecorded credit amount - the total unrecorded debit amount.

[0006] As transactions become more frequent and data volumes increase, the transaction-by-transaction real-time settlement model cannot meet the needs of high-concurrency data processing scenarios. In addition, database pressure increases, business efficiency cannot be improved, the settlement speed is reduced, and the user experience is greatly reduced. Summary of the invention

[0007] The purpose of the present invention is to provide a method, medium and equipment for timed batch clearing of funds.

[0008] The present invention aims to solve the problems existing in the prior art.

[0009] Compared with the prior art, the technical solution of the present invention and its beneficial effects are as follows:

[0010] The first aspect disclosed by the present invention provides a method for scheduled batch clearing of funds, including: obtaining transaction flow details of network-connected institutions and storing them in a scheduled clearing flow table; creating a clearing summary table and splitting the accounts of network-connected institutions into multiple data for storage; clearing transaction flow details in batches on a scheduled basis; updating the account data of network-connected institutions in the clearing summary table; querying the current account table to obtain the book balance, the amount of deposit, and the overdraft limit; querying the clearing summary table to obtain the total amount of unrecorded debits and the total amount of unrecorded credits; calculating the available balance of the accounts of network-connected institutions; and judging whether the corresponding accounts of network-connected institutions have been successfully cleared based on the available balance.

[0011] As a further improvement, the transaction flow details of the network-connected institutions are obtained and stored in the scheduled settlement flow table, wherein each transaction in the transaction flow details stores information including but not limited to business category, message identification number, initiating bank number, sending date, sending time, debit bank number, credit bank number, transaction amount, currency, debit and credit marks, business date, serial number, netting session, system status and scheduled settlement session information.

[0012] As a further improvement, the clearing summary table is created to split the account of the networked institution into multiple data for storage, wherein the clearing summary table includes but is not limited to recording the split ID, clearing account number, business type, business date, netting session, debit and credit flag, total amount and accounting status information.

[0013] As a further improvement, the batch-by-batch scheduled clearing transaction flow details include: grouping the scheduled clearing transaction flow details, performing scheduled aggregation calculations, converting transaction-by-transaction clearing into batch clearing, and setting a scheduled processing time of 5 minutes.

[0014] As a further improvement, the batch scheduled clearing transaction flow details include: selecting the clearing sessions completed on the current date, grouping the scheduled clearing flow sheets according to the major business category, debit bank number, credit bank number, debit and credit signs and currency, and clearing in batches.

[0015] As a further improvement, the current account table is queried to obtain the book balance, the amount of deposit, and the overdraft limit, wherein, according to the current account table corresponding to the clearing account number currently queried, the query obtains the affiliated institution, currency, yesterday's balance, balance, amount of deposit, overdraft limit, account status, book balance, clearing limit and account type information.

[0016] A second aspect of the present invention provides a storage medium storing a computer program, which, when executed by a processor, implements the steps of the method for timed batch clearing of funds.

[0017] The third aspect of the present invention provides an electronic device, which includes at least a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the method for timed batch settlement of funds when executing the computer program on the memory.

[0018] The beneficial effects of the present invention are:

[0019] This method calculates the real-time changing available balance of the network account by a method of regularly clearing a large amount of real-time fund data in batches and splitting the hot account data and updating and summarizing it, and judges whether the account funds of the network institution are sufficient based on this data. This method can solve the performance bottleneck problem of real-time clearing of each transaction, reduce the pressure of the business system, change the clearing of funds from transaction to batch clearing of funds, reduce the time consumption of massive fund clearing, improve the user transfer experience, and avoid concurrent locks caused by single record updates through data splitting, effectively improving processing efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] Figure 1 The present invention provides a flow chart of a method for periodic batch clearing of funds.

[0021] Figure 2 It is a schematic diagram of the database structure provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0022] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Therefore, the following detailed description of the embodiments of the present invention provided in the drawings is not intended to limit the scope of the claimed invention, but merely represents the selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0023] In the description of the present invention, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features. In the description of the present invention, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.

[0024] Reference Figure 1 and Figure 2As shown, a method for scheduled batch clearing of funds includes: obtaining transaction flow details of network-connected institutions and storing them in a scheduled clearing flow table; creating a clearing summary table and splitting the accounts of network-connected institutions into multiple data for storage; clearing transaction flow details in batches on a scheduled basis; updating the account data of network-connected institutions in the clearing summary table; querying the current account table to obtain the book balance, the amount of deposit, and the overdraft limit; querying the clearing summary table to obtain the total amount of unrecorded debits and the total amount of unrecorded credits; calculating the available balance of the accounts of network-connected institutions; and judging whether the corresponding accounts of network-connected institutions are successfully cleared according to the available balance.

[0025] The transaction flow details of the networked institution are obtained and stored in the scheduled settlement flow table, wherein each transaction in the transaction flow details includes but is not limited to the business category, message identification number, initiating bank number, sending date, sending time, debit bank number, credit bank number, transaction amount, currency, debit and credit marks, business date, serial number, netting session, system status and scheduled settlement session information.

[0026] The clearing summary table is created to split the account of the networked institution into multiple data for storage, wherein the clearing summary table includes but is not limited to recording the split ID, clearing account number, business type, business date, netting session, debit and credit mark, total amount and accounting status information.

[0027] The batch-by-batch scheduled clearing transaction flow details include: grouping the scheduled clearing transaction flow details, performing scheduled aggregation calculations, converting transaction-by-transaction clearing into batch clearing, and setting a scheduled processing time of 5 minutes.

[0028] The batch scheduled clearing transaction flow details include: selecting the clearing sessions completed on the current date, grouping the scheduled clearing flow sheets according to the business category, debit bank number, credit bank number, debit and credit marks, and currency, and clearing in batches.

[0029] The updating of the account data of the networked institution in the liquidation summary table, wherein the account of the networked institution is split into multiple entries, can realize concurrent updating of multiple entries under the same account, solve the problem of concurrent database lock, and improve the processing efficiency. According to the concurrent volume of the networked institution's business, each networked institution is split into different numbers of entries.

[0030] The current account table is queried to obtain the book balance, the amount of deposit, and the overdraft limit, wherein, according to the current account table corresponding to the clearing account number currently queried, the affiliated institution, currency, yesterday's balance, balance, amount of deposit, overdraft limit, account status, book balance, clearing limit and account type information are queried.

[0031] A storage medium stores a computer program, which, when executed by a processor, implements the steps of a method for timed batch clearing of funds.

[0032] An electronic device comprises at least a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of a method for timed batch clearing of funds when executing the computer program on the memory.

[0033] The above embodiments are only used to explain the technical solutions of the present invention rather than to limit them. Those skilled in the art should understand that any modification and equivalent substitution that does not depart from the spirit and scope of the present invention should fall within the protection scope of the claims of the present invention.

Claims

1. A method for timed batch clearing of funds, characterized in that: include: Obtain transaction details of networked institutions and store them in the scheduled clearing statement; Create a liquidation summary table and split the accounts of the participating institutions into multiple data for storage; Transaction details of batch clearing; Update the account data of the networked institutions in the clearing summary table; Query the current account table to obtain the book balance, deposit amount, and overdraft limit; Query the clearing summary table to obtain the total unrecorded debit amount and the total unrecorded credit amount; Calculate the available balance of the account of the participating institution; Determine whether the corresponding account of the network institution has been successfully cleared based on the available balance.

2. A method for scheduled batch clearing of funds according to claim 1, characterized in that: The transaction flow details of the networked institution are obtained and stored in the scheduled settlement flow table, wherein each transaction in the transaction flow details includes but is not limited to the business category, message identification number, initiating bank number, sending date, sending time, debit bank number, credit bank number, transaction amount, currency, debit and credit marks, business date, serial number, netting session, system status and scheduled settlement session information.

3. A method for scheduled batch clearing of funds according to claim 1, characterized in that: The clearing summary table is created to split the account of the networked institution into multiple data for storage, wherein the clearing summary table includes but is not limited to recording the split ID, clearing account number, business type, business date, netting session, debit and credit mark, total amount and accounting status information.

4. A method for scheduled batch clearing of funds according to claim 1, characterized in that: The batch-by-batch scheduled clearing transaction flow details include: grouping the scheduled clearing transaction flow details, performing scheduled aggregation calculations, converting transaction-by-transaction clearing into batch clearing, and setting a scheduled processing time of 5 minutes.

5. A method for scheduled batch clearing of funds according to claim 1, characterized in that: The batch scheduled clearing transaction flow details include: selecting the clearing sessions completed on the current date, grouping the scheduled clearing flow sheets according to the business category, debit bank number, credit bank number, debit and credit marks, and currency, and clearing in batches.

6. A method for scheduled batch clearing of funds according to claim 1, characterized in that: The current account table is queried to obtain the book balance, the amount of deposit, and the overdraft limit, wherein, according to the current account table corresponding to the clearing account number currently queried, the affiliated institution, currency, yesterday's balance, balance, amount of deposit, overdraft limit, account status, book balance, clearing limit and account type information are queried.

7. A storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by the processor, the steps of the method for timed batch settlement of funds as described in any one of claims 1 to 6 are implemented.

8. An electronic device, characterized in that: The method comprises at least a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of a method for timed batch clearing of funds as described in any one of claims 1 to 6 when executing the computer program on the memory.

Citation Information

Patent Citations

  • Online payment service processing method and device, medium and electronic equipment

    CN113554509A

  • Streamline fund reconciliation method, apparatus and device, and storage medium

    CN116630072A

  • Real-time capital transfer system and method

    CN1635504A