Big data-based judicial library system transaction offset processing method and system, and medium
By obtaining transaction data and market and industry information in the treasurer system, calculating offset impact factors and evaluating indexes, and generating transaction offset reports, the problem of inefficiency of traditional manual operations is solved, and automated transaction offsets are realized, which reduces financial management costs and risk.
Patent Information
- Application Number
- CN202411496386.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-25
- Publication Date
- 2024-11-22
AI Technical Summary
The transaction offset processing of traditional treasurer systems relies on manual operations, is inefficient and insufficiently intelligent, making it difficult to automatically offset transactions according to market changes, increasing the cost and risk of corporate financial management.
The transaction data and data source information are obtained through the treasurer system, related market and industry data are extracted, transaction offset accuracy impact factors and rationality evaluation index are calculated, transaction offset processing reports are generated, and transaction offset processing is realized to achieve automation and accuracy of transaction offset.
It improves the efficiency and intelligence of transaction offsets, reduces financial management costs, reduces risks, and achieves the accuracy and rationality assessment of transaction offsets.
Smart Images

Figure CN119006197A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of financial management technology, and in particular, to a transaction offset processing method, system and medium for a treasury system based on big data. Background Art
[0002] In corporate financial management, the treasury system plays an important role. With the continuous expansion of corporate scale and the increasing complexity of business, the number and types of transactions in the treasury system are also increasing. Traditional transaction offset processing methods mainly rely on manual operations, which are inefficient and prone to errors. At the same time, due to the lack of effective data analysis and processing methods and insufficient intelligence, it is difficult to achieve automatic offset of transactions according to market changes, which increases the cost and risk of corporate financial management.
[0003] In view of the above problems, effective technical solutions are urgently needed. Summary of the invention
[0004] The purpose of the present application is to provide a transaction offset processing method, system and medium for a treasury system based on big data. The transaction data and corresponding data source information can be obtained through the treasury system, and related market information and industry information can be obtained according to the corresponding data source information of the transaction data. The related market data and industry data are extracted for processing to obtain transaction offset accuracy influencing factors, and the transaction data are matched and analyzed to obtain transaction pairs with offset relationships. The transaction feature data is extracted, and the corresponding exchange rate is obtained according to the transaction feature data. The transaction feature data is analyzed and processed based on the exchange rate and the offset accuracy influencing factors to obtain an offset accuracy evaluation index, the offset data is obtained, and the offset rationality evaluation index is obtained in combination with the preset industry historical offset data. The offset accuracy evaluation index and the offset rationality evaluation index are processed to obtain a transaction offset measurement index, and the transaction offset measurement index is compared with the preset standard transaction offset measurement index. A transaction offset processing report is generated according to the comparison result.
[0005] The present application also provides a transaction offset processing method for a treasury system based on big data, comprising the following steps: Obtain transaction data and corresponding data source information through the treasury system; Obtain related market information and industry information according to the data source information corresponding to the transaction data, extract related market data according to the related market information, extract industry data according to the industry information, process the related market data and industry data, and obtain the transaction offset accuracy influencing factor; Performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data; Acquire a corresponding exchange rate according to the transaction feature data, analyze and process the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, and obtain an offset accuracy evaluation index; Obtain the offset data, process it in combination with the preset industry historical offset data, and obtain the offset rationality assessment index; Processing is performed according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain a transaction offset measurement index; The transaction offset measurement index is compared with a preset standard transaction offset measurement index, and a transaction offset processing report is generated according to the comparison result.
[0006] Optionally, in the transaction offset processing method for a treasury system based on big data described in the present application, the steps of acquiring related market information and industry information according to data source information corresponding to the transaction data, extracting related market data according to the related market information, extracting industry data according to the industry information, and processing the related market data and industry data to obtain a transaction offset accuracy influencing factor include: Acquire relevant market information and industry information according to the data source information corresponding to the transaction data; Extracting related market data according to the related market information, including price fluctuation data and supply and demand change data; Extracting industry data based on the industry information, including industry scale grade data and growth rate; The price fluctuation data, supply and demand change data, industry scale grade data and growth rate are input into a preset transaction offset accuracy evaluation model for processing to obtain transaction offset accuracy influencing factors.
[0007] Optionally, in the transaction offset processing method for a treasury system based on big data described in the present application, performing matching analysis on the transaction data, obtaining transaction pairs with an offsetting relationship, and extracting transaction feature data include: The transaction data includes transaction time data, transaction relationship feature data and transaction amount data; Matching analysis is performed based on the transaction time data, transaction relationship feature data and transaction amount data to obtain transaction pairs with an offsetting relationship and extract transaction feature data.
[0008] Optionally, in the transaction offset processing method for a treasury system based on big data described in the present application, the step of acquiring a corresponding exchange rate according to the transaction feature data, analyzing and processing the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor to obtain an offset accuracy evaluation index includes: The transaction characteristic data includes transaction currency category characteristic data, accounts receivable data and accounts payable data; Obtaining a corresponding real-time exchange rate according to the transaction currency category characteristic data combined with preset transaction offset time data; The real-time exchange rate, offset accuracy influencing factor, accounts receivable data and accounts payable data are input into a preset offset accuracy evaluation model for processing to obtain an offset accuracy evaluation index.
[0009] Optionally, in the transaction offset processing method for the treasury system based on big data described in the present application, the obtaining of the offset data and processing in combination with preset industry historical offset data to obtain the offset rationality evaluation index include: The offset data includes offset amount data and corresponding offset ratio; The offset amount data and the corresponding offset ratio are processed in combination with the preset industry historical offset transaction amount average and historical offset ratio to obtain an offset rationality assessment index.
[0010] Optionally, in the transaction offset processing method for a treasury system based on big data described in the present application, the processing according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain the transaction offset measurement index includes: Inputting the offset accuracy evaluation index and the offset rationality evaluation index into a preset transaction offset measurement evaluation model for processing to obtain a transaction offset measurement index; The calculation formula of the transaction offset measurement index in the transaction offset measurement evaluation model is: ; in, To measure the transaction offset index, , They are the offset accuracy evaluation index and the offset rationality evaluation index, is the preset characteristic coefficient.
[0011] Optionally, in the transaction offset processing method for a treasury system based on big data described in the present application, comparing the transaction offset measurement index with a preset standard transaction offset measurement index and generating a transaction offset processing report according to the comparison result includes: Comparing the transaction offset measurement index with a preset standard transaction offset measurement index to obtain a transaction offset measurement relative value; Performing a threshold comparison of the transaction offset measure relative value with a preset transaction offset measure relative threshold; If it is greater than the preset transaction offset measurement relative threshold, a transaction offset processing report is generated; If it is less than or equal to the preset transaction offset metric relative threshold, the offset transaction is marked and sent to the operation and maintenance personnel for backend display.
[0012] In a second aspect, the present application provides a treasury system transaction offset processing system based on big data, the system comprising: a memory and a processor, the memory comprising a program of a treasury system transaction offset processing method based on big data, the program of the treasury system transaction offset processing method based on big data being executed by the processor to implement the following steps: Obtain transaction data and corresponding data source information through the treasury system; Obtain related market information and industry information according to the data source information corresponding to the transaction data, extract related market data according to the related market information, extract industry data according to the industry information, process the related market data and industry data, and obtain the transaction offset accuracy influencing factor; Performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data; Acquire a corresponding exchange rate according to the transaction feature data, analyze and process the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, and obtain an offset accuracy evaluation index; Obtain the offset data, process it in combination with the preset industry historical offset data, and obtain the offset rationality assessment index; Processing is performed according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain a transaction offset measurement index; The transaction offset measurement index is compared with a preset standard transaction offset measurement index, and a transaction offset processing report is generated according to the comparison result.
[0013] Optionally, in a treasury system transaction offset processing system based on big data described in the present application, the steps of acquiring related market information and industry information according to data source information corresponding to transaction data, extracting related market data according to the related market information, extracting industry data according to the industry information, and processing according to the related market data and industry data to obtain a transaction offset accuracy influencing factor include: Acquire relevant market information and industry information according to the data source information corresponding to the transaction data; Extracting related market data according to the related market information, including price fluctuation data and supply and demand change data; Extracting industry data based on the industry information, including industry scale grade data and growth rate; The price fluctuation data, supply and demand change data, industry scale grade data and growth rate are input into a preset transaction offset accuracy evaluation model for processing to obtain transaction offset accuracy influencing factors.
[0014] In the third aspect, the present application also provides a computer-readable storage medium, which stores a treasury system transaction offset processing method program based on big data. When the treasury system transaction offset processing method program based on big data is executed by a processor, the steps of the treasury system transaction offset processing method based on big data as described in any one of the above items are implemented.
[0015] As can be seen from the above, the transaction offset processing method, system and medium of the treasury system based on big data provided by the present application obtain transaction data and corresponding data source information through the treasury system, obtain related market information and industry information according to the corresponding data source information of the transaction data, extract the related market data and industry data for processing, obtain the transaction offset accuracy influencing factor, match and analyze the transaction data, obtain transaction pairs with offset relationships, extract transaction feature data, obtain the corresponding exchange rate according to the transaction feature data, analyze and process the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, obtain the offset accuracy evaluation index, obtain the offset data, and process it in combination with the preset industry historical offset data to obtain the offset rationality evaluation index, process it according to the offset accuracy evaluation index and the offset rationality evaluation index, obtain the transaction offset measurement index, compare the transaction offset measurement index with the preset standard transaction offset measurement index, and generate a transaction offset processing report according to the comparison result.
[0016] Other features and advantages of the present application will be described in the following description, and partly become apparent from the description, or understood by practicing the embodiments of the present application. The purpose and other advantages of the present application can be realized and obtained by the structures specifically pointed out in the written description and the drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0017] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.
[0018] Figure 1 A flowchart of a transaction offset processing method for a treasury system based on big data provided in an embodiment of the present application; Figure 2 A flowchart of obtaining transaction offset accuracy influencing factors of a transaction offset processing method for a treasury system based on big data provided in an embodiment of the present application; Figure 3 A flowchart of generating a transaction offset processing report for a transaction offset processing method for a treasury system based on big data provided in an embodiment of the present application. DETAILED DESCRIPTION
[0019] The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. The components of the embodiments of the present application described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application claimed for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without making creative work belong to the scope of protection of the present application.
[0020] It should be noted that similar reference numerals and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further defined and explained in subsequent drawings. At the same time, in the description of this application, the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance.
[0021] Please refer to Figure 1 , Figure 1 The flowchart of the treasury system transaction offset processing method based on big data in some embodiments of the present application. The treasury system transaction offset processing method based on big data is used in a terminal device, such as a computer, a mobile phone terminal, etc. The treasury system transaction offset processing method based on big data includes the following steps: S11. Obtain transaction data and corresponding data source information through the treasury system; S12. Obtaining related market information and industry information according to the data source information corresponding to the transaction data, extracting related market data according to the related market information, extracting industry data according to the industry information, and processing the related market data and industry data to obtain a transaction offset accuracy influencing factor; S13, performing matching analysis on the transaction data, obtaining transaction pairs with offsetting relationships, and extracting transaction feature data; S14, acquiring a corresponding exchange rate according to the transaction feature data, analyzing and processing the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, and obtaining an offset accuracy evaluation index; S15. Obtain the offset data, and process it in combination with the preset industry historical offset data to obtain an offset rationality assessment index; S16. Processing is performed according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain a transaction offset measurement index; S17: Compare the transaction offset measurement index with a preset standard transaction offset measurement index, and generate a transaction offset processing report according to the comparison result.
[0022] It should be noted that in order to realize transaction offset processing and improve offset efficiency and intelligence, transaction data and corresponding data source information are obtained from the treasury system, and related market information and industry information are obtained based on the corresponding data source information of the transaction data. The related market data and industry data are extracted and processed respectively to obtain transaction offset accuracy influencing factors, which are used to correct the transaction offset between the two parties to the transaction. Based on the obtained transaction data, matching analysis is performed according to preset requirements to obtain offset transaction pairs with offset relationships, and transaction feature data including transaction currency category feature data, receivables data and payables data are extracted. Since the two parties to the transaction may use different currencies for transactions, the transaction characteristics are calculated based on the transaction characteristics. The real-time exchange rate is queried based on the transaction category feature data in the tax data, and the transaction feature data is analyzed and processed in combination with the offset accuracy influencing factors to obtain the offset accuracy evaluation index. While analyzing the transaction accuracy, whether the transaction offset is in line with the industry and the rationality of the historical offset transactions should also be considered. Therefore, the offset data is continued to be obtained, and processed in combination with the preset industry historical offset data to obtain the offset rationality evaluation index. The offset accuracy evaluation index for evaluating the offset accuracy and the offset rationality evaluation index for evaluating the offset rationality are comprehensively analyzed and processed to obtain the transaction offset measurement index, which is then compared with the preset standard transaction offset measurement index, and a transaction offset processing report is generated based on the comparison results.
[0023] Please refer to Figure 2 , Figure 2 The present invention is a flowchart of obtaining a transaction offset accuracy influencing factor of a transaction offset processing method of a treasury system based on big data in some embodiments of the present application. According to an embodiment of the present invention, the steps of obtaining associated market information and industry information according to data source information corresponding to transaction data, extracting associated market data according to associated market information, extracting industry data according to industry information, and processing the associated market data and industry data to obtain a transaction offset accuracy influencing factor include: S21, acquiring related market information and industry information according to the data source information corresponding to the transaction data; S22, extracting related market data according to the related market information, including price fluctuation data and supply and demand change data; S23, extracting industry data according to the industry information, including industry scale grade data and growth rate; S24. Input the price fluctuation data, supply and demand change data, industry scale grade data and growth rate into a preset transaction offset accuracy assessment model for processing to obtain transaction offset accuracy influencing factors.
[0024] It should be noted that the transaction between the two parties is affected by market and industry fluctuations during the transaction process. Directly offsetting the transaction amount will lead to insufficient offset accuracy. Therefore, first obtain the related market information and industry information according to the corresponding data source information of the transaction data, extract the related market data including price fluctuation data and supply and demand change data from the related market information, and extract the industry data including industry scale grade data and growth rate from the industry information. Input the price fluctuation data, supply and demand change data, industry scale grade data and growth rate into the preset transaction offset accuracy assessment model for processing, and obtain the transaction offset accuracy influencing factors; The calculation formula of the transaction offset accuracy influencing factor in the transaction offset accuracy evaluation model is: ; in, To offset the accuracy impact factor for transactions, , , , They are price fluctuation data, supply and demand change data, industry scale data and growth rate. , , It is the preset characteristic coefficient (the characteristic coefficient is obtained by querying the preset treasury system transaction offset platform).
[0025] According to an embodiment of the present invention, performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data includes: The transaction data includes transaction time data, transaction relationship feature data and transaction amount data; Matching analysis is performed based on the transaction time data, transaction relationship feature data and transaction amount data to obtain transaction pairs with an offsetting relationship and extract transaction feature data.
[0026] It should be noted that transaction data including transaction time data, characteristic data of the relationship between the two transaction parties and transaction amount data are obtained from the treasury system for matching analysis to determine transaction pairs with offsetting relationships and extract transaction characteristic data; for example, a group company has two subsidiaries, A and B. Company A sells goods to Company B with a transaction amount of 1 million yuan, and Company B provides services to Company A with a transaction amount of 800,000 yuan. Based on the relationship between the two transaction parties and the matching relationship of the transaction amounts, it is identified that the two transactions have an offsetting relationship.
[0027] According to an embodiment of the present invention, the step of acquiring a corresponding exchange rate according to the transaction feature data, analyzing and processing the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor to obtain an offset accuracy evaluation index includes: The transaction characteristic data includes transaction currency category characteristic data, accounts receivable data and accounts payable data; Obtaining a corresponding real-time exchange rate according to the transaction currency category characteristic data combined with preset transaction offset time data; The real-time exchange rate, offset accuracy influencing factor, accounts receivable data and accounts payable data are input into a preset offset accuracy evaluation model for processing to obtain an offset accuracy evaluation index.
[0028] It should be noted that after determining the transaction pair with an offsetting relationship, the transaction characteristic data including the transaction currency category characteristic data, the receivables data and the payables data are extracted. If the two parties to the transaction use different currencies for the transaction, direct offsetting will lead to offset errors. Therefore, the real-time exchange rate at the offset time is first obtained through online exchange rate query based on the transaction currency category characteristic data, and then the real-time exchange rate, offset accuracy influencing factor, receivables data and payables data are input into the preset offset accuracy evaluation model for processing to obtain the offset accuracy evaluation index; The calculation formula of the offset accuracy evaluation index in the offset accuracy evaluation model is: ; in, To offset the accuracy evaluation index, , , , They are real-time exchange rate, offset accuracy influencing factors, accounts receivable data and accounts payable data. It is the preset characteristic coefficient (the characteristic coefficient is obtained by querying the preset treasury system transaction offset platform).
[0029] According to an embodiment of the present invention, the offset data is obtained and processed in combination with preset industry historical offset data to obtain an offset rationality evaluation index, including: The offset data includes offset amount data and corresponding offset ratio; The offset amount data and the corresponding offset ratio are processed in combination with the preset industry historical offset transaction amount average and historical offset ratio to obtain an offset rationality assessment index.
[0030] It should be noted that there are differences in the time when the account changes occur between the two parties of the transaction. After the offsetting process is completed, the rationality of the offsetting should be evaluated based on the historical data of the industry to confirm that it meets the industry requirements while ensuring accuracy. Therefore, the offsetted data including the offset amount data and the corresponding offset ratio are obtained, and the offset data is processed in combination with the preset industry historical offset transaction amount average and historical offset ratio to obtain the offset rationality evaluation index; The calculation formula of the offset rationality evaluation index is: ; in, To offset the rationality assessment index, , , , They are offset amount data, offset ratio, historical offset transaction amount average and historical offset ratio. , , It is the preset characteristic coefficient (the characteristic coefficient is obtained by querying the preset treasury system transaction offset platform).
[0031] According to an embodiment of the present invention, the processing according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain the transaction offset measurement index includes: Inputting the offset accuracy evaluation index and the offset rationality evaluation index into a preset transaction offset measurement evaluation model for processing to obtain a transaction offset measurement index; The calculation formula of the transaction offset measurement index in the transaction offset measurement evaluation model is: ; in, To measure the transaction offset index, , They are the offset accuracy evaluation index and the offset rationality evaluation index, is the preset characteristic coefficient.
[0032] It should be noted that in order to ensure that the offset processing complies with financial and industry comprehensive standards, the offset accuracy assessment index and offset rationality assessment index obtained will be input into the preset transaction offset measurement assessment model for processing, and the transaction offset measurement index will be obtained to comprehensively evaluate the effect of the transaction data offset processing, which will be used to evaluate the final offset completion status.
[0033] Please refer to Figure 3 , Figure 3 The present invention is a flowchart of generating a transaction offset processing report of a transaction offset processing method of a treasury system based on big data in some embodiments of the present application. According to an embodiment of the present invention, the transaction offset measurement index is compared with a preset standard transaction offset measurement index, and a transaction offset processing report is generated according to the comparison result, including: S31, comparing the transaction offset measurement index with a preset standard transaction offset measurement index to obtain a transaction offset measurement relative value; S32, performing a threshold comparison between the transaction offset measure relative value and a preset transaction offset measure relative threshold; S33. If the amount is greater than the preset transaction offset measurement relative threshold, a transaction offset processing report is generated; S34. If it is less than or equal to the preset transaction offset measurement relative threshold, the offset transaction is marked and sent to the operation and maintenance personnel for backend display.
[0034] It should be noted that the transaction offset measurement index is compared with the preset standard transaction offset measurement index to obtain the transaction offset measurement relative value. For example, if the obtained transaction offset measurement index is 0.3 and the preset standard transaction offset measurement index is 1, then 0.3 / 1=0.3 is the transaction offset measurement relative value. Then, the threshold is compared with the preset transaction offset measurement relative threshold. In this embodiment, the transaction offset measurement relative threshold is set to (0, 0.65], (0.65, 1]. For example, if the obtained transaction offset measurement relative value is 0.3, which is less than the preset transaction offset measurement relative threshold, it means that there is a problem with this offset transaction. The offset transaction is marked and sent to the operation and maintenance personnel for back-end display for further verification. If the obtained transaction offset measurement relative value is 0.8, it means that this offset transaction is accurate and reasonable, and a transaction offset processing report is generated, including but not limited to the offset transaction details, offset amount, and saved capital cost.
[0035] It is worth mentioning that according to an embodiment of the present invention, it also includes: Obtain and process the transaction amounts of the same transaction type within multiple preset time periods to obtain the standard deviation of the corresponding transaction amounts; Compare the transaction amount standard deviation with the preset standard transaction amount standard deviation to obtain the transaction amount standard deviation deviation rate; Compare the transaction amount standard deviation rate with the preset transaction amount standard deviation level threshold, and determine the deviation level according to the comparison result; The corresponding warning level is generated according to the deviation level and sent to the background for display.
[0036] It should be noted that there will be different transaction types and corresponding transaction data in the treasury system. If the transaction amount of the same transaction type fluctuates too much, it may be caused by erroneous transactions or major changes in the market. Therefore, it is necessary to supervise and evaluate potential transaction risks. By obtaining and processing the transaction amounts of the same transaction type in multiple preset time periods, the standard deviation of the corresponding transaction amount can be obtained; for example, a group of transaction amounts are 100, 120, 110, 90, and 130, then (100+120+110+90+130) / 5=110 is the average transaction amount, and the standard deviation of the transaction amount is: ; The obtained transaction amount standard deviation is divided by the preset standard transaction amount standard deviation to obtain the transaction amount standard deviation deviation rate, and then the transaction amount standard deviation deviation rate is compared with the preset transaction amount standard deviation deviation level threshold. In this embodiment, the transaction amount standard deviation deviation level threshold is set to (0, 0.3), [0.3, 0.5], (0.5, 1], corresponding to the first level deviation, the second level deviation, and the third level deviation, respectively. Among them, the third level deviation level is the highest, that is, the transaction amount fluctuates the most. The deviation level is determined according to the comparison result to generate the corresponding warning level, and it is sent to the background for display. For example, if the obtained transaction amount standard deviation deviation rate is 0.14, it corresponds to the first level deviation, and the first level warning is output. If the obtained transaction amount standard deviation deviation rate is 0.4, it corresponds to the second level deviation, and the second level warning is output; the operation and maintenance personnel initiate the corresponding plan according to the warning level, such as stopping transaction offset, manual review, etc.
[0037] It is worth mentioning that according to an embodiment of the present invention, it also includes: Obtaining the number of times that the relative value of the transaction offset measure is less than a preset transaction offset measure relative threshold within a preset time period; Compare the number of times with a preset number of times threshold, wherein the number of times threshold includes a first preset number of times threshold and a second preset number of times threshold, and the first preset number of times threshold is less than the second preset number of times threshold; If it is less than or equal to the first preset number threshold, no processing is performed; If it is greater than the first preset number threshold and less than or equal to the second preset number threshold, then activate the early warning reminder response; If it is greater than a second preset number threshold, the transaction offset processing suspension response is activated.
[0038] It should be noted that the transaction offset measurement relative value obtained by dividing the transaction offset measurement index by the preset standard transaction offset measurement index reflects the accuracy and rationality of the transaction offset processing. If the situation that the transaction offset measurement relative value is less than the preset transaction offset measurement relative threshold occurs multiple times, it means that there is a problem in the transaction offset process, and the matching method, offset processing method or other processes need to be checked and updated; therefore, the number of times the transaction offset measurement relative value is less than the preset transaction offset measurement relative threshold within the preset time period is obtained, and the preset time period is set to 1 week or set according to the specific situation, and the thresholds are compared with the first preset number threshold and the second preset number threshold respectively. In this embodiment, the first preset number threshold is set to 5 times, and the second preset number threshold is set to 8 times; for example, if the number of times less than the preset transaction offset measurement relative threshold is 3 times, no processing is performed; if the number of times less than the preset transaction offset measurement relative threshold is 6 times, an early warning reminder response is activated to prevent further errors; if the number of times less than the preset transaction offset measurement relative threshold is 9 times, the transaction offset processing is suspended and further processed by the financial operation and maintenance personnel.
[0039] The present invention also discloses a treasury system transaction offset processing system based on big data, comprising a memory and a processor, wherein the memory comprises a treasury system transaction offset processing method program based on big data, and when the treasury system transaction offset processing method program based on big data is executed by the processor, the following steps are implemented: Obtain transaction data and corresponding data source information through the treasury system; Obtain related market information and industry information according to the data source information corresponding to the transaction data, extract related market data according to the related market information, extract industry data according to the industry information, process the related market data and industry data, and obtain the transaction offset accuracy influencing factor; Performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data; Acquire a corresponding exchange rate according to the transaction feature data, analyze and process the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, and obtain an offset accuracy evaluation index; Obtain the offset data, process it in combination with the preset industry historical offset data, and obtain the offset rationality assessment index; Processing is performed according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain a transaction offset measurement index; The transaction offset measurement index is compared with a preset standard transaction offset measurement index, and a transaction offset processing report is generated according to the comparison result.
[0040] It should be noted that in order to realize transaction offset processing and improve offset efficiency and intelligence, transaction data and corresponding data source information are obtained from the treasury system, and related market information and industry information are obtained based on the corresponding data source information of the transaction data. The related market data and industry data are extracted and processed respectively to obtain transaction offset accuracy influencing factors, which are used to correct the transaction offset between the two parties to the transaction. Based on the obtained transaction data, matching analysis is performed according to preset requirements to obtain offset transaction pairs with offset relationships, and transaction feature data including transaction currency category feature data, receivables data and payables data are extracted. Since the two parties to the transaction may use different currencies for transactions, the transaction characteristics are calculated based on the transaction characteristics. The real-time exchange rate is queried based on the transaction category feature data in the tax data, and the transaction feature data is analyzed and processed in combination with the offset accuracy influencing factors to obtain the offset accuracy evaluation index. While analyzing the transaction accuracy, whether the transaction offset is in line with the industry and the rationality of the historical offset transactions should also be considered. Therefore, the offset data is continued to be obtained, and processed in combination with the preset industry historical offset data to obtain the offset rationality evaluation index. The offset accuracy evaluation index for evaluating the offset accuracy and the offset rationality evaluation index for evaluating the offset rationality are comprehensively analyzed and processed to obtain the transaction offset measurement index, which is then compared with the preset standard transaction offset measurement index, and a transaction offset processing report is generated based on the comparison results.
[0041] According to an embodiment of the present invention, the method of acquiring related market information and industry information according to data source information corresponding to transaction data, extracting related market data according to the related market information, extracting industry data according to the industry information, and processing the related market data and industry data to obtain a transaction offset accuracy influencing factor includes: Acquire relevant market information and industry information according to the data source information corresponding to the transaction data; Extracting related market data according to the related market information, including price fluctuation data and supply and demand change data; Extracting industry data based on the industry information, including industry scale grade data and growth rate; The price fluctuation data, supply and demand change data, industry scale grade data and growth rate are input into a preset transaction offset accuracy evaluation model for processing to obtain transaction offset accuracy influencing factors.
[0042] It should be noted that the transaction between the two parties is affected by market and industry fluctuations during the transaction process. Directly offsetting the transaction amount will lead to insufficient offset accuracy. Therefore, first obtain the related market information and industry information according to the corresponding data source information of the transaction data, extract the related market data including price fluctuation data and supply and demand change data from the related market information, and extract the industry data including industry scale grade data and growth rate from the industry information. Input the price fluctuation data, supply and demand change data, industry scale grade data and growth rate into the preset transaction offset accuracy assessment model for processing, and obtain the transaction offset accuracy influencing factors; The calculation formula of the transaction offset accuracy influencing factor in the transaction offset accuracy evaluation model is: ; in, To offset the accuracy impact factor for transactions, , , , They are price fluctuation data, supply and demand change data, industry scale data and growth rate. , , It is the preset characteristic coefficient (the characteristic coefficient is obtained by querying the preset treasury system transaction offset platform).
[0043] According to an embodiment of the present invention, performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data includes: The transaction data includes transaction time data, transaction relationship feature data and transaction amount data; Matching analysis is performed based on the transaction time data, transaction relationship feature data and transaction amount data to obtain transaction pairs with an offsetting relationship and extract transaction feature data.
[0044] It should be noted that transaction data including transaction time data, characteristic data of the relationship between the two transaction parties and transaction amount data are obtained from the treasury system for matching analysis to determine transaction pairs with offsetting relationships and extract transaction characteristic data; for example, a group company has two subsidiaries, A and B. Company A sells goods to Company B with a transaction amount of 1 million yuan, and Company B provides services to Company A with a transaction amount of 800,000 yuan. Based on the relationship between the two transaction parties and the matching relationship of the transaction amounts, it is identified that the two transactions have an offsetting relationship.
[0045] According to an embodiment of the present invention, the step of acquiring a corresponding exchange rate according to the transaction feature data, analyzing and processing the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor to obtain an offset accuracy evaluation index includes: The transaction characteristic data includes transaction currency category characteristic data, accounts receivable data and accounts payable data; Obtaining a corresponding real-time exchange rate according to the transaction currency category characteristic data combined with preset transaction offset time data; The real-time exchange rate, offset accuracy influencing factor, accounts receivable data and accounts payable data are input into a preset offset accuracy evaluation model for processing to obtain an offset accuracy evaluation index.
[0046] It should be noted that after determining the transaction pair with an offsetting relationship, the transaction characteristic data including the transaction currency category characteristic data, the receivables data and the payables data are extracted. If the two parties to the transaction use different currencies for the transaction, direct offsetting will lead to offset errors. Therefore, the real-time exchange rate at the offset time is first obtained through online exchange rate query based on the transaction currency category characteristic data, and then the real-time exchange rate, offset accuracy influencing factor, receivables data and payables data are input into the preset offset accuracy evaluation model for processing to obtain the offset accuracy evaluation index; The calculation formula of the offset accuracy evaluation index in the offset accuracy evaluation model is: ; in, To offset the accuracy evaluation index, , , , They are real-time exchange rate, offset accuracy influencing factors, accounts receivable data and accounts payable data. It is the preset characteristic coefficient (the characteristic coefficient is obtained by querying the preset treasury system transaction offset platform).
[0047] According to an embodiment of the present invention, the offset data is obtained and processed in combination with preset industry historical offset data to obtain an offset rationality evaluation index, including: The offset data includes offset amount data and corresponding offset ratio; The offset amount data and the corresponding offset ratio are processed in combination with the preset industry historical offset transaction amount average and historical offset ratio to obtain an offset rationality assessment index.
[0048] It should be noted that there are differences in the time when the account changes occur between the two parties of the transaction. After the offsetting process is completed, the rationality of the offsetting should be evaluated based on the historical data of the industry to confirm that it meets the industry requirements while ensuring accuracy. Therefore, the offsetted data including the offset amount data and the corresponding offset ratio are obtained, and the offset data is processed in combination with the preset industry historical offset transaction amount average and historical offset ratio to obtain the offset rationality evaluation index; The calculation formula of the offset rationality evaluation index is: ; in, To offset the rationality assessment index, , , , They are offset amount data, offset ratio, historical offset transaction amount average and historical offset ratio. , , It is the preset characteristic coefficient (the characteristic coefficient is obtained by querying the preset treasury system transaction offset platform).
[0049] According to an embodiment of the present invention, the processing according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain the transaction offset measurement index includes: Inputting the offset accuracy evaluation index and the offset rationality evaluation index into a preset transaction offset measurement evaluation model for processing to obtain a transaction offset measurement index; The calculation formula of the transaction offset measurement index in the transaction offset measurement evaluation model is: ; in, To measure the transaction offset index, , They are the offset accuracy evaluation index and the offset rationality evaluation index, is the preset characteristic coefficient.
[0050] It should be noted that in order to ensure that the offset processing complies with financial and industry comprehensive standards, the offset accuracy assessment index and offset rationality assessment index obtained will be input into the preset transaction offset measurement assessment model for processing, and the transaction offset measurement index will be obtained to comprehensively evaluate the effect of the transaction data offset processing, which will be used to evaluate the final offset completion status.
[0051] According to an embodiment of the present invention, comparing the transaction offset measurement index with a preset standard transaction offset measurement index and generating a transaction offset processing report according to the comparison result includes: Comparing the transaction offset measurement index with a preset standard transaction offset measurement index to obtain a transaction offset measurement relative value; Performing a threshold comparison of the transaction offset measure relative value with a preset transaction offset measure relative threshold; If it is greater than the preset transaction offset measurement relative threshold, a transaction offset processing report is generated; If it is less than or equal to the preset transaction offset metric relative threshold, the offset transaction is marked and sent to the operation and maintenance personnel for backend display.
[0052] It should be noted that the transaction offset measurement index is compared with the preset standard transaction offset measurement index to obtain the transaction offset measurement relative value. For example, if the obtained transaction offset measurement index is 0.3 and the preset standard transaction offset measurement index is 1, then 0.3 / 1=0.3 is the transaction offset measurement relative value. Then, the threshold is compared with the preset transaction offset measurement relative threshold. In this embodiment, the transaction offset measurement relative threshold is set to (0, 0.65], (0.65, 1]. For example, if the obtained transaction offset measurement relative value is 0.3, which is less than the preset transaction offset measurement relative threshold, it means that there is a problem with this offset transaction. The offset transaction is marked and sent to the operation and maintenance personnel for back-end display for further verification. If the obtained transaction offset measurement relative value is 0.8, it means that this offset transaction is accurate and reasonable, and a transaction offset processing report is generated, including but not limited to the offset transaction details, offset amount, and saved capital cost.
[0053] It is worth mentioning that according to an embodiment of the present invention, it also includes: Obtain and process the transaction amounts of the same transaction type within multiple preset time periods to obtain the standard deviation of the corresponding transaction amounts; Compare the transaction amount standard deviation with the preset standard transaction amount standard deviation to obtain the transaction amount standard deviation deviation rate; Compare the transaction amount standard deviation rate with the preset transaction amount standard deviation level threshold, and determine the deviation level according to the comparison result; The corresponding warning level is generated according to the deviation level and sent to the background for display.
[0054] It should be noted that there will be different transaction types and corresponding transaction data in the treasury system. If the transaction amount of the same transaction type fluctuates too much, it may be caused by erroneous transactions or major changes in the market. Therefore, it is necessary to supervise and evaluate potential transaction risks. By obtaining and processing the transaction amounts of the same transaction type in multiple preset time periods, the standard deviation of the corresponding transaction amount can be obtained; for example, a group of transaction amounts are 100, 120, 110, 90, and 130, then (100+120+110+90+130) / 5=110 is the average transaction amount, and the standard deviation of the transaction amount is: ; The obtained transaction amount standard deviation is divided by the preset standard transaction amount standard deviation to obtain the transaction amount standard deviation deviation rate, and then the transaction amount standard deviation deviation rate is compared with the preset transaction amount standard deviation deviation level threshold. In this embodiment, the transaction amount standard deviation deviation level threshold is set to (0, 0.3), [0.3, 0.5], (0.5, 1], corresponding to the first level deviation, the second level deviation, and the third level deviation, respectively. Among them, the third level deviation level is the highest, that is, the transaction amount fluctuates the most. The deviation level is determined according to the comparison result to generate the corresponding warning level, and it is sent to the background for display. For example, if the obtained transaction amount standard deviation deviation rate is 0.14, it corresponds to the first level deviation, and the first level warning is output. If the obtained transaction amount standard deviation deviation rate is 0.4, it corresponds to the second level deviation, and the second level warning is output; the operation and maintenance personnel initiate the corresponding plan according to the warning level, such as stopping transaction offset, manual review, etc.
[0055] It is worth mentioning that according to an embodiment of the present invention, it also includes: Obtaining the number of times that the relative value of the transaction offset measure is less than a preset transaction offset measure relative threshold within a preset time period; Compare the number of times with a preset number of times threshold, wherein the number of times threshold includes a first preset number of times threshold and a second preset number of times threshold, and the first preset number of times threshold is less than the second preset number of times threshold; If it is less than or equal to the first preset number threshold, no processing is performed; If it is greater than the first preset number threshold and less than or equal to the second preset number threshold, then activate the early warning reminder response; If it is greater than a second preset number threshold, the transaction offset processing suspension response is activated.
[0056] It should be noted that the transaction offset measurement relative value obtained by dividing the transaction offset measurement index by the preset standard transaction offset measurement index reflects the accuracy and rationality of the transaction offset processing. If the situation that the transaction offset measurement relative value is less than the preset transaction offset measurement relative threshold occurs multiple times, it means that there is a problem in the transaction offset process, and the matching method, offset processing method or other processes need to be checked and updated; therefore, the number of times the transaction offset measurement relative value is less than the preset transaction offset measurement relative threshold within the preset time period is obtained, and the preset time period is set to 1 week or set according to the specific situation, and the thresholds are compared with the first preset number threshold and the second preset number threshold respectively. In this embodiment, the first preset number threshold is set to 5 times, and the second preset number threshold is set to 8 times; for example, if the number of times less than the preset transaction offset measurement relative threshold is 3 times, no processing is performed; if the number of times less than the preset transaction offset measurement relative threshold is 6 times, an early warning reminder response is activated to prevent further errors; if the number of times less than the preset transaction offset measurement relative threshold is 9 times, the transaction offset processing is suspended and further processed by the financial operation and maintenance personnel.
[0057] A third aspect of the present invention provides a readable storage medium, which stores a treasury system transaction offset processing method program based on big data. When the treasury system transaction offset processing method program based on big data is executed by a processor, the steps of the treasury system transaction offset processing method based on big data as described in any one of the above items are implemented.
[0058] The present invention discloses a transaction offset processing method, system and medium for a treasury system based on big data, which obtains transaction data and corresponding data source information through a treasury system, obtains related market information and industry information according to the corresponding data source information of the transaction data, extracts the related market data and industry data for processing, obtains transaction offset accuracy influencing factors, performs matching analysis on the transaction data, obtains transaction pairs with offset relationships, extracts transaction feature data, obtains corresponding exchange rates according to the transaction feature data, analyzes and processes the transaction feature data based on the exchange rate combined with the offset accuracy influencing factors, obtains an offset accuracy evaluation index, obtains offset data, processes the data in combination with preset industry historical offset data, obtains an offset rationality evaluation index, processes the data according to the offset accuracy evaluation index and the offset rationality evaluation index, obtains a transaction offset measurement index, compares the transaction offset measurement index with a preset standard transaction offset measurement index, and generates a transaction offset processing report according to the comparison result.
[0059] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. The device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as: multiple units or components can be combined, or can be integrated into another system, or some features can be ignored or not executed. In addition, the coupling, direct coupling, or communication connection between the components shown or discussed can be through some interfaces, and the indirect coupling or communication connection of the devices or units can be electrical, mechanical or other forms.
[0060] The units described above as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units; they may be located in one place or distributed on multiple network units; some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.
[0061] In addition, all functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may be separately used as a unit, or two or more units may be integrated into one unit; the above-mentioned integrated units may be implemented in the form of hardware or in the form of hardware plus software functional units.
[0062] Those skilled in the art can understand that: all or part of the steps of implementing the above method embodiments can be completed by hardware related to program instructions, the aforementioned program can be stored in a readable storage medium, and when the program is executed, it executes the steps of the above method embodiments; and the aforementioned storage medium includes: mobile storage devices, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), disks or optical disks, and other media that can store program codes.
[0063] Alternatively, if the above-mentioned integrated unit of the present invention is implemented in the form of a software function module and sold or used as an independent product, it can also be stored in a readable storage medium. Based on this understanding, the technical solution of the embodiment of the present invention can be essentially or partly reflected in the form of a software product that contributes to the prior art. The software product is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the methods described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as mobile storage devices, ROM, RAM, magnetic disks or optical disks.
Claims
1. A transaction offset processing method for a treasury system based on big data, characterized in that: The following steps are involved: Obtain transaction data and corresponding data source information through the treasury system; Obtain related market information and industry information according to the data source information corresponding to the transaction data, extract related market data according to the related market information, extract industry data according to the industry information, process the related market data and industry data, and obtain the transaction offset accuracy influencing factor; Performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data; Acquire a corresponding exchange rate according to the transaction feature data, analyze and process the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, and obtain an offset accuracy evaluation index; Obtain the offset data, process it in combination with the preset industry historical offset data, and obtain the offset rationality assessment index; Processing is performed according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain a transaction offset measurement index; The transaction offset measurement index is compared with a preset standard transaction offset measurement index, and a transaction offset processing report is generated according to the comparison result.
2. The transaction offset processing method of the treasury system based on big data according to claim 1 is characterized in that: The method of obtaining the associated market information and industry information according to the data source information corresponding to the transaction data, extracting the associated market data according to the associated market information, extracting the industry data according to the industry information, and processing the associated market data and the industry data to obtain the transaction offset accuracy influencing factor includes: Acquire relevant market information and industry information according to the data source information corresponding to the transaction data; Extracting related market data according to the related market information, including price fluctuation data and supply and demand change data; Extracting industry data based on the industry information, including industry scale grade data and growth rate; The price fluctuation data, supply and demand change data, industry scale grade data and growth rate are input into a preset transaction offset accuracy evaluation model for processing to obtain transaction offset accuracy influencing factors.
3. The transaction offset processing method of the treasury system based on big data according to claim 2 is characterized in that: The matching analysis of the transaction data to obtain a transaction pair with an offsetting relationship and extracting transaction feature data includes: The transaction data includes transaction time data, transaction relationship feature data and transaction amount data; Matching analysis is performed based on the transaction time data, transaction relationship feature data and transaction amount data to obtain transaction pairs with an offsetting relationship and extract transaction feature data.
4. The transaction offset processing method of the treasury system based on big data according to claim 3 is characterized in that: The step of acquiring a corresponding exchange rate according to the transaction feature data, analyzing and processing the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor to obtain an offset accuracy evaluation index includes: The transaction characteristic data includes transaction currency category characteristic data, accounts receivable data and accounts payable data; Obtaining a corresponding real-time exchange rate according to the transaction currency category characteristic data combined with preset transaction offset time data; The real-time exchange rate, offset accuracy influencing factor, accounts receivable data and accounts payable data are input into a preset offset accuracy evaluation model for processing to obtain an offset accuracy evaluation index.
5. The transaction offset processing method of the treasury system based on big data according to claim 4 is characterized in that: The offset data is obtained and processed in combination with the preset industry historical offset data to obtain the offset rationality assessment index, including: The offset data includes offset amount data and corresponding offset ratio; The offset amount data and the corresponding offset ratio are processed in combination with the preset industry historical offset transaction amount average and historical offset ratio to obtain an offset rationality assessment index.
6. The transaction offset processing method of the treasury system based on big data according to claim 5 is characterized in that: The processing according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain the transaction offset measurement index includes: Inputting the offset accuracy evaluation index and the offset rationality evaluation index into a preset transaction offset measurement evaluation model for processing to obtain a transaction offset measurement index; The calculation formula of the transaction offset measurement index in the transaction offset measurement evaluation model is: ; in, To measure the transaction offset index, , They are the offset accuracy evaluation index and the offset rationality evaluation index, is the preset characteristic coefficient.
7. The transaction offset processing method of the treasury system based on big data according to claim 6 is characterized in that: The step of comparing the transaction offset measurement index with a preset standard transaction offset measurement index and generating a transaction offset processing report according to the comparison result includes: Comparing the transaction offset measurement index with a preset standard transaction offset measurement index to obtain a transaction offset measurement relative value; Performing a threshold comparison of the transaction offset measure relative value with a preset transaction offset measure relative threshold; If it is greater than the preset transaction offset measurement relative threshold, a transaction offset processing report is generated; If it is less than or equal to the preset transaction offset metric relative threshold, the offset transaction is marked and sent to the operation and maintenance personnel for backend display.
8. A treasury system transaction offset processing system based on big data, characterized in that: The invention comprises a memory and a processor, wherein the memory comprises a program of a transaction offset processing method of a treasury system based on big data, and the program of the transaction offset processing method of a treasury system based on big data is executed by the processor to implement the following steps: Obtain transaction data and corresponding data source information through the treasury system; Obtain related market information and industry information according to the data source information corresponding to the transaction data, extract related market data according to the related market information, extract industry data according to the industry information, process the related market data and industry data, and obtain the transaction offset accuracy influencing factor; Performing matching analysis on the transaction data to obtain transaction pairs with offsetting relationships and extracting transaction feature data; Acquire a corresponding exchange rate according to the transaction feature data, analyze and process the transaction feature data based on the exchange rate combined with the offset accuracy influencing factor, and obtain an offset accuracy evaluation index; Obtain the offset data, process it in combination with the preset industry historical offset data, and obtain the offset rationality assessment index; Processing is performed according to the offset accuracy evaluation index and the offset rationality evaluation index to obtain a transaction offset measurement index; The transaction offset measurement index is compared with a preset standard transaction offset measurement index, and a transaction offset processing report is generated according to the comparison result.
9. The treasury system transaction offset processing system based on big data according to claim 8, characterized in that: The method of obtaining the associated market information and industry information according to the data source information corresponding to the transaction data, extracting the associated market data according to the associated market information, extracting the industry data according to the industry information, and processing the associated market data and the industry data to obtain the transaction offset accuracy influencing factor includes: Acquire relevant market information and industry information according to the data source information corresponding to the transaction data; Extracting related market data according to the related market information, including price fluctuation data and supply and demand change data; Extracting industry data based on the industry information, including industry scale grade data and growth rate; The price fluctuation data, supply and demand change data, industry scale grade data and growth rate are input into a preset transaction offset accuracy evaluation model for processing to obtain transaction offset accuracy influencing factors.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a treasury system transaction offset processing method program based on big data. When the treasury system transaction offset processing method program based on big data is executed by the processor, the steps of a treasury system transaction offset processing method based on big data as described in any one of claims 1 to 7 are implemented.
