Evaluation table processing method and RPA robot

Abstract

The invention provides a valuation table processing method and an RPA robot, which can be used in the financial field or other fields, and the method comprises the following steps: receiving a valuation table processing request; if the processing mode in the valuation table processing request is valuation table reconciliation, reconciliation data are obtained according to the valuation table processing request, and the reconciliation data comprise a to-be-processed party valuation table, a to-be-processed local party valuation table, a local party subject name and to-be-compared elements; according to the reconciliation data, reconciliation is carried out on the to-be-processed party valuation table and the to-be-processed local valuation table, and valuation table processing corresponding to the valuation table processing request is completed. According to the invention, the automation degree and accuracy of valuation table processing can be improved.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a valuation table processing method and an RPA robot. Background Technology

[0002] In the financial sector, valuation reconciliation is a crucial step in ensuring the accuracy of asset valuations and the consistency of financial data. Valuation sheets are typically generated by asset managers, custodians, or third-party valuation agencies to record valuation information for various financial assets, such as security prices, net asset value, and yields. The reconciliation process usually involves comparing valuation sheets from different sources, identifying and addressing any discrepancies, to ensure data consistency across all parties.

[0003] Currently, asset custody department staff typically spend a significant amount of time and effort manually processing asset valuation tables in their daily work. This can lead to a large volume of repetitive tasks, potentially resulting in calculation and operational errors and ultimately, incorrect processing results.

[0004] This section is intended to provide background or context for the embodiments of the invention set forth in the claims. The description herein is not an admission that it is prior art simply because it is included in this section. Summary of the Invention

[0005] To address at least one problem in the prior art, this application proposes a valuation table processing method and an RPA robot, which can improve the automation and accuracy of valuation table processing.

[0006] To address the aforementioned technical problems, this application provides the following technical solution:

[0007] Firstly, this application provides a method for processing valuation tables, including:

[0008] Receive valuation table processing request;

[0009] If the processing method in the valuation table processing request is valuation table reconciliation, then reconciliation data is obtained according to the valuation table processing request. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements.

[0010] Based on the reconciliation data, the valuation table of the counterparty to be processed and the valuation table of the self to be processed are reconciled to complete the valuation table processing corresponding to the valuation table processing request.

[0011] In one embodiment, obtaining reconciliation data based on the valuation table processing request includes:

[0012] Obtain the configuration file corresponding to the valuation table processing request. The configuration file includes: manager information, product unique identifier, subject name, and comparison elements.

[0013] Based on the manager information and the product's unique identifier, keyword matching is performed on emails in the email account to search and determine the target email, and the valuation table of the target party to be processed is downloaded from the attachment of the target email.

[0014] The latest self-valuation table is obtained from the specified address and used as the self-valuation table to be processed.

[0015] In one embodiment, reconciling the pending counterparty valuation table and the pending self-valuation table based on the reconciliation data includes:

[0016] From the self-evaluation table to be processed, obtain the self-evaluation account name and the first data of the comparison element;

[0017] From the preset subject correspondence, obtain the target record containing the subject name of the party. The preset subject correspondence includes: multiple records, each record including: multiple synonyms;

[0018] Determine whether there is a subject name in the pending counterparty valuation table that has a similarity to a synonym in the target record that meets a preset similarity condition. If so, determine that subject name as the counterparty subject name corresponding to the subject name in the target record.

[0019] From the counterparty valuation table to be processed, obtain the second data corresponding to the counterparty's account name and the comparison element;

[0020] Based on the first and second data, the accounts are reconciled to obtain the difference between the two, and an account reconciliation feedback table is generated.

[0021] In one embodiment, the step of reconciling the accounts based on the first data and the second data to obtain the difference between the two and generating a reconciliation feedback table includes:

[0022] Convert the data types of the first and second data to the same data type;

[0023] Based on the same data type, the first and second data are reconciled to obtain the difference between them, and a reconciliation feedback table is generated.

[0024] In one embodiment, the valuation table processing method further includes:

[0025] If the difference between the first data and the second data is greater than the difference threshold between the corresponding subject and the element to be compared, then the feature data of the subject corresponding to the difference is obtained.

[0026] Input the difference, the feature data corresponding to the subject and the element to be compared into a preset root cause localization model, determine the output of the preset root cause localization model as the reason for the difference between the first data and the second data, and write the reason for the difference into the reconciliation feedback table.

[0027] The preset root cause localization model is obtained by training the classification algorithm based on a batch of training samples and their corresponding actual differences. Each training sample includes: feature data of the subject corresponding to the historical difference and the elements to be compared.

[0028] In one embodiment, after receiving the valuation table processing request, the method further includes:

[0029] If the processing method in the valuation table processing request is valuation table element extraction, then obtain the local valuation table;

[0030] Based on the preset list of elements to be extracted, determine the subjects and elements to be screened corresponding to the valuation table of this party;

[0031] Write the element columns corresponding to the subjects and elements to be screened into a preset result ledger table to complete the valuation table processing corresponding to the valuation table processing request.

[0032] In one embodiment, determining the subject to be screened and the elements to be screened corresponding to the valuation table based on a preset list of elements to be extracted includes:

[0033] Extract the product name and valuation date from the name of the valuation table provided by this party;

[0034] Based on the product name and valuation date, the subject to be screened and the element to be screened corresponding to the valuation table are extracted from the preset element to be extracted table.

[0035] Secondly, this application provides an RPA (robotic process automation) robot, comprising:

[0036] The receiving module is used to receive valuation table processing requests;

[0037] The acquisition module is used to acquire reconciliation data according to the valuation table processing request if the processing method in the valuation table processing request is valuation table reconciliation. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements.

[0038] The processing module is used to reconcile the valuation table of the counterparty to be processed and the valuation table of the self to be processed based on the reconciliation data, and complete the valuation table processing corresponding to the valuation table processing request.

[0039] Thirdly, this application provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the method described thereon.

[0040] Fourthly, this application provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the method described above.

[0041] As can be seen from the above technical solution, this application provides a valuation table processing method and apparatus. The method includes: receiving a valuation table processing request; if the processing method in the valuation table processing request is valuation table reconciliation, then obtaining reconciliation data according to the valuation table processing request, the reconciliation data including: a counterparty valuation table to be processed, a self-valuation table to be processed, self-account name, and comparison elements; reconciling the counterparty valuation table to be processed and the self-valuation table to be processed according to the reconciliation data, completing the valuation table processing corresponding to the valuation table processing request, which can improve the automation and accuracy of valuation table processing; specifically, it can solve the pain point that business personnel in the asset custody department of the banking industry need to spend a lot of time and energy processing asset valuation tables in their daily work, and empower front-line business personnel by relying on RPA robot process automation technology. On the one hand, it uses automated operations to reduce the burden and increase efficiency of business personnel, and entrusts a large amount of repetitive daily work to robots to automatically complete it; on the other hand, it makes the workflow more standardized and normalized, overcomes the calculation and operation errors that may occur manually, and makes the processing results more accurate. Attached Figure Description

[0042] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. In the drawings:

[0043] Figure 1 This is a first flowchart illustrating the valuation table processing method in the embodiments of this application;

[0044] Figure 2 This is a schematic diagram of the second process of the valuation table processing method in the embodiments of this application;

[0045] Figure 3 This is a schematic diagram of the second process of the valuation table processing method in the embodiments of this application;

[0046] Figure 4 This is a schematic diagram of the structure of the PRA robot in the embodiments of this application;

[0047] Figure 5 This is a schematic block diagram of the system configuration of an electronic device according to an embodiment of this application. Detailed Implementation

[0048] To enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of this application.

[0049] To address at least one of the problems existing in the prior art, this application provides a valuation table processing method and an RPA robot. By employing RPA robot process automation technology, the existing manual processing of asset valuation tables in the banking asset custody business line can be transformed into fully automated processing using a workflow robot. Compared to previous methods, this invention effectively reduces the workload and increases efficiency for frontline staff by automating a large amount of repetitive daily work. Furthermore, it overcomes potential calculation and operational errors that may occur with humans, making the workflow more standardized and ensuring the accuracy of the processing results. In addition, given the low-code, rapid, and convenient development characteristics of RPA robot process automation technology, this invention also possesses easy replication and expansion capabilities, allowing for rapid iterative upgrades in response to changes or additions to business modules during practical application.

[0050] It should be noted that the valuation table processing method and apparatus disclosed in this application can be used in the field of financial technology, as well as in any other field. The application areas of the valuation table processing method and apparatus disclosed in this application are not limited. The acquisition, storage, use, and processing of data in the technical solutions of each embodiment of this application all comply with relevant laws and regulations.

[0051] The following examples illustrate this in detail.

[0052] To improve the automation and accuracy of valuation table processing, this embodiment provides a valuation table processing method where the execution subject is an RPA robot, such as... Figure 1 As shown, this method specifically includes the following:

[0053] Step 100: Receive valuation table processing request.

[0054] Specifically, it can receive valuation table processing requests sent from the front end. These requests include processing methods selected by the user based on a pop-up window guided by the robot, such as "valuation table reconciliation" or "valuation table element extraction".

[0055] Step 200: If the processing method in the valuation table processing request is valuation table reconciliation, then according to the valuation table processing request, obtain the reconciliation data, which includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the elements to be compared.

[0056] Step 300: Based on the reconciliation data, reconcile the valuation table of the counterparty to be processed and the valuation table of the self to be processed, and complete the valuation table processing corresponding to the valuation table processing request.

[0057] To improve the reliability of obtaining reconciliation data, in one embodiment, step 200, which involves obtaining reconciliation data based on the valuation table processing request, includes:

[0058] Step 201: Obtain the configuration file corresponding to the valuation table processing request. The configuration file includes: manager information, product unique identifier, subject name, and comparison elements.

[0059] Specifically, the manager information may include: the name of the external manager and the manager's email address; a unique product identifier to distinguish different products, which may be the product name or product number, etc. The account name can represent the account name to be compared in the account reconciliation table. For example, the account name may include: stock investment, bond investment, and fund investment, etc.; the comparison elements may include: quantity, market price, and market value, etc. The configuration file may include: a. Product details table: containing information such as the product name to be processed, the external manager, and the manager's email address. b. Account correspondence: containing the account codes, account names, and which elements need to be compared for both the counterparty and the account holder.

[0060] Step 202: Based on the manager information and product unique identifier, perform keyword matching on emails in the email account, search and determine the target email, and download the valuation table of the target email from the attachment of the target email.

[0061] Specifically, it can be determined whether a pending valuation table for the other party already exists locally. If not, the email system is opened, and the user logs in using a public email account. A search is performed based on the specified product name and manager in the product details table. After matching keywords, the valuation table attachment sent by the external manager is downloaded, i.e., the other party's valuation table. The email account can be searched for emails containing the manager's information and the product's unique identifier as the target email. The valuation table processing request can also include the product's unique identifier; if found, the pending valuation table for the other party can be obtained based on the product's unique identifier.

[0062] Step 203: Obtain the latest self-valuation table from the specified address as the self-valuation table to be processed.

[0063] Specifically, the designated address is used to store the company's valuation table, and can be preset according to actual conditions. For example, it can be an internal asset management system. The company can open the internal asset management system, log in with a user account with query privileges, enter the designated module, and export the latest company valuation table compressed package. The exported company valuation table compressed package can then be decompressed.

[0064] In one embodiment, step 300, reconciling the pending counterparty valuation table and the pending self-valuation table based on the reconciliation data, includes:

[0065] From the pending self-assessment table, obtain the first data of the self-assessment account name and the comparison element. From the preset account correspondence, obtain the counterparty account name containing the corresponding counterparty account name. The preset account correspondence may include the correspondence between the self-assessment account name and the counterparty account name. From the pending counterparty assessment table, obtain the second data of the counterparty account name and the comparison element. Based on the first data and the second data, perform reconciliation, obtain the difference between the two, and generate a reconciliation feedback table.

[0066] Specifically, the exported valuation table package can be unzipped, and each asset valuation table within the folder can be processed in a loop. The product name and valuation date can be parsed from the first row header. The corresponding counterparty valuation table for that product can be located, and according to the pre-configured account mapping, data such as "quantity," "market price," and "market value" for both the counterparty and the client can be obtained item by item. If the account or corresponding column data is missing, the missing data is recorded; otherwise, the element information is extracted and compared. Meanwhile, pre-defined ignoreable columns in the account mapping table are not processed. The detailed comparison information is written to the reconciliation feedback table.

[0067] In order to improve the efficiency of the reconciliation process while ensuring the reliability of the reconciliation, such as Figure 2As shown, in one embodiment, step 300, which involves reconciling the counterparty valuation table and the self-valuation table based on the reconciliation data, includes:

[0068] Step 301: Obtain the name of the subject and the first data of the comparison element from the subject valuation table to be processed.

[0069] For example, the correspondence between the subject name, the element to be compared, and the first data can be shown in Table 1.

[0070] Table 1

[0071]

[0072] Step 302: Obtain the target record containing the subject name from the preset subject correspondence. The preset subject correspondence includes multiple records, and each record includes multiple synonyms.

[0073] Specifically, the synonyms in the same record can represent subject names that have the same meaning but may have different names. For example, in the preset subject correspondence, a record includes: Stock A, Stock a, Equities A, etc.

[0074] Step 303: Determine whether there is a subject name in the pending counterparty valuation table that has a similarity to a synonym in the target record that meets a preset similarity condition. If so, determine the subject name as the counterparty subject name corresponding to the subject name in the target record.

[0075] Specifically, if there is a subject name in the valuation table of the counterparty to be processed that has a similarity greater than the similarity threshold with a synonym in the target record, then the subject name can be determined as the counterparty subject name corresponding to the subject name of the counterparty in the target record.

[0076] Step 304: Obtain the second data corresponding to the counterparty's account name and the comparison element from the counterparty valuation table to be processed.

[0077] For example, the correspondence between the counterparty's subject name, the element to be compared, and the second data can be shown in Table 2.

[0078] Table 2

[0079]

[0080] Step 305: Reconcile the first data and the second data to obtain the difference between them and generate a reconciliation feedback table.

[0081] Specifically, the account name, the first data, the second data, and the difference between the two can be written into the reconciliation feedback table. The reconciliation feedback table can include the account codes, account names, values ​​of each element, differences between the two, comparison results, and other information for both parties. For example, the reconciliation feedback table is shown in Table 3.

[0082] Table 3

[0083]

[0084] To further improve the reliability of reconciliation, in one embodiment, step 305 includes: converting the data types of the first data and the second data to the same data type; reconciling the first data and the second data based on the same data type to obtain the difference between the two, and generating a reconciliation feedback table.

[0085] Specifically, the data types of the first and second data can be uniformly converted to integers or floating-point numbers, etc.

[0086] To pinpoint the root cause of reconciliation discrepancies, such as Figure 3 As shown, in one embodiment, the valuation table processing method further includes:

[0087] Step 306: If the difference between the first data and the second data is greater than the difference threshold between the corresponding subject and the element to be compared, then obtain the feature data of the subject corresponding to the difference.

[0088] Specifically, the correspondence between the proprietary account, the comparison element, and the difference threshold can be pre-set according to the actual situation, and this application does not impose any restrictions on this. Based on the correspondence between the proprietary account, the comparison element, and the difference threshold, and the proprietary account and comparison element corresponding to the first data, the corresponding difference threshold is determined; the proprietary account corresponding to the difference between the first data and the second data can represent the proprietary account corresponding to the first data. The feature data may include: whether it is a newly included position, the market volatility on that day, and the valuation date, etc.

[0089] Step 307: Input the difference, the feature data corresponding to the subject, and the comparison element into a preset root cause localization model, determine the output result of the preset root cause localization model as the reason for the difference between the first data and the second data, and write the reason for the difference into the reconciliation feedback table; the preset root cause localization model is obtained by training the classification algorithm based on batch training samples and their corresponding actual reasons for the difference, each training sample includes: feature data of the subject corresponding to the historical difference and the comparison element.

[0090] Specifically, the classification algorithm can be a decision tree algorithm or a random forest, etc. The actual cause of the difference can be the true reason for the difference determined based on expert experience.

[0091] To extract valuation table elements after reconciling the valuation table, in one embodiment, after step 100, the following is also included:

[0092] Step 400: If the processing method in the valuation table processing request is valuation table element extraction, then obtain the local valuation table.

[0093] Specifically, it can determine whether there are already any pending asset valuation tables on the local machine. If not, it unzips the exported asset valuation table compressed package, processes each asset valuation table in the folder in a loop, and parses out the product name and valuation date based on the title of its first line.

[0094] Step 500: Based on the preset list of elements to be extracted, determine the subjects and elements to be screened corresponding to the valuation table.

[0095] Specifically, the preset table of elements to be extracted may include: the required account number (i.e. the number of the account to be screened), the column name of the required valuation element (i.e. the name of the element to be screened), and the column name corresponding to the account number written in the ledger, etc.

[0096] Step 600: Write the element columns corresponding to the subjects and elements to be screened into the preset result ledger table to complete the valuation table processing corresponding to the valuation table processing request.

[0097] Specifically, the preset result ledger table can be empty initially. After the subject to be filtered and the element corresponding to the element to be filtered are listed, for example, the preset result ledger table can be as shown in Table 4.

[0098] Table 4

[0099]

[0100] To improve the reliability of obtaining the subjects and elements to be screened, in one embodiment, step 500 includes:

[0101] Step 511: Extract the product name and valuation date from the name of the valuation table.

[0102] Step 512: Based on the product name and valuation date, extract the subject to be screened and the element to be screened corresponding to the valuation table from the preset element to be extracted table.

[0103] Specifically, the preset table of elements to be extracted can pre-store the correspondence between product name, valuation date, subject to be screened, and element to be screened.

[0104] To further illustrate this solution, this application provides an application example of a valuation table processing method. In this application example, the method includes:

[0105] Step 1: Start the process robot and make a selection according to the robot's instructions in the pop-up window. If you select "Valuation Table Reconciliation", proceed to Step 2. If you select "Valuation Table Element Extraction", proceed to Step 8.

[0106] Step 2: Enter the "Valuation Reconciliation" module and read the following pre-set configuration file:

[0107] a. Product Details: Includes the product name to be processed, the external manager, and the manager's email address.

[0108] b. Subject correspondence: This includes the subject codes and names of both parties, as well as information on which elements need to be compared.

[0109] c. Reconciliation Feedback Form: This form includes the account codes and names for both the counterparty and the client, the values ​​of each element, the differences between the two accounts, and the comparison results. The initial state of the reconciliation feedback form can be empty.

[0110] Step 3: Determine if there is already a pending counterparty valuation table on the local machine. If not, proceed to step 3.1; otherwise, proceed directly to step 4.

[0111] Step 3.1: The robot opens the email system, logs in using a public email account, searches for the specified product name and manager in the product details table (Table a), downloads the valuation table attachment sent by the external manager after matching the keywords, i.e., the other party's valuation table.

[0112] Step 4: Determine if there is already a local valuation table to be processed. If not, proceed to step 4.1; otherwise, proceed directly to step 5.

[0113] Step 4.1: The robot opens the internal asset management system, logs in using the account with query permissions, enters the designated module, and exports the latest self-valuation table compressed package.

[0114] Step 5: Unzip the exported asset valuation table compressed package, process each asset valuation table in the folder in a loop, and parse out the product name and valuation date based on the title of its first line.

[0115] Step 6: Locate the counterparty's valuation table for the product. Following the pre-configured account mapping, retrieve data such as "quantity," "market price," and "market capitalization" for each account for both the counterparty and the company. If no data exists for a particular account or corresponding column, record the missing data; otherwise, extract the relevant information for comparison. Meanwhile, pre-defined ignoreable columns in the account mapping table are left unprocessed.

[0116] Step 7: Write the detailed comparison information into the reconciliation feedback form. Record the "quantity," "market price," and "market value" for both parties, the difference between the two, and whether they match. Highlight any discrepancies in the subject matter in yellow, and highlight any subject matter for which data was not found in the subject matter in orange. After completion, proceed to step 12.

[0117] Step 8: Enter the "Establish Valuation Table Element Extraction" module and read the following pre-set configuration file:

[0118] d. Table of elements to be extracted: required account number, column name of the required valuation element, and column name of the account number to be written in the ledger.

[0119] Step 9: Determine if there is already a local valuation table to be processed. If not, proceed to step S4.1 and then to step 10. If there is, proceed directly to step 10.

[0120] Step 10: Unzip the exported asset valuation table compressed package, process each asset valuation table in the folder in a loop, and parse out the product name and valuation date based on the title of its first line.

[0121] Step 11: Fully connect the read valuation table with the element table to be extracted, and filter out the required accounts and corresponding element columns; if there is no matching account, record that the account does not exist; if there is, extract the valuation elements and write them one by one into the result ledger table. After completion, proceed to step 12.

[0122] Step 12: After all valuation tables have been processed, the generated result ledger will be sent to the relevant personnel via email.

[0123] Step 13: After the workflow robot completes its work, it will clear temporary files, etc. The workflow ends.

[0124] From a software perspective, to improve the automation and accuracy of valuation table processing, this application provides an embodiment of an RPA robot for implementing all or part of the valuation table processing method. See [link to RPA implementation details]. Figure 4 The RPA robot specifically includes the following:

[0125] Receiver module 01 is used to receive valuation table processing requests;

[0126] The acquisition module 02 is used to acquire reconciliation data according to the valuation table processing request if the processing method in the valuation table processing request is valuation table reconciliation. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements.

[0127] Processing module 03 is used to reconcile the valuation table of the counterparty to be processed and the valuation table of the self to be processed according to the reconciliation data, and complete the valuation table processing corresponding to the valuation table processing request.

[0128] The RPA robot embodiments provided in this specification can be used to execute the processing flow of the above-described valuation table processing method embodiments. Its functions will not be repeated here, but can be found in the detailed description of the above-described valuation table processing method embodiments.

[0129] Figure 5 This is a schematic diagram of the physical structure of an electronic device provided in an embodiment of the present invention, such as... Figure 5 As shown, the electronic device includes: a memory 501, a processor 502, and a computer program stored in the memory 501 and executable on the processor 502. When the processor 502 executes the computer program, it implements the following method:

[0130] Receive valuation table processing request;

[0131] If the processing method in the valuation table processing request is valuation table reconciliation, then reconciliation data is obtained according to the valuation table processing request. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements.

[0132] Based on the reconciliation data, the valuation table of the counterparty to be processed and the valuation table of the self to be processed are reconciled to complete the valuation table processing corresponding to the valuation table processing request.

[0133] This embodiment discloses a computer program product, which includes a computer program that, when executed by a processor, implements the following method:

[0134] Receive valuation table processing request;

[0135] If the processing method in the valuation table processing request is valuation table reconciliation, then reconciliation data is obtained according to the valuation table processing request. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements.

[0136] Based on the reconciliation data, the valuation table of the counterparty to be processed and the valuation table of the self to be processed are reconciled to complete the valuation table processing corresponding to the valuation table processing request.

[0137] This embodiment provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the following method:

[0138] Receive valuation table processing request;

[0139] If the processing method in the valuation table processing request is valuation table reconciliation, then reconciliation data is obtained according to the valuation table processing request. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements.

[0140] Based on the reconciliation data, the valuation table of the counterparty to be processed and the valuation table of the self to be processed are reconciled to complete the valuation table processing corresponding to the valuation table processing request.

[0141] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0142] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0143] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0144] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0145] In the description of this specification, the references to terms such as "an embodiment," "a specific embodiment," "some embodiments," "for example," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the invention. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0146] The specific embodiments described above further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above descriptions are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for processing valuation tables, characterized in that, include: Receive valuation table processing request; If the processing method in the valuation table processing request is valuation table reconciliation, then reconciliation data is obtained according to the valuation table processing request. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements. Based on the reconciliation data, the valuation table of the counterparty to be processed and the valuation table of the self to be processed are reconciled to complete the valuation table processing corresponding to the valuation table processing request.

2. The valuation table processing method according to claim 1, characterized in that, The step of processing the request based on the valuation table and obtaining the reconciliation data includes: Obtain the configuration file corresponding to the valuation table processing request. The configuration file includes: manager information, product unique identifier, subject name, and comparison elements. Based on the manager information and the product's unique identifier, keyword matching is performed on emails in the email account to search and determine the target email, and the valuation table of the target email to be processed is downloaded from the attachment of the target email. The latest self-valuation table is obtained from the specified address and used as the self-valuation table to be processed.

3. The valuation table processing method according to claim 1, characterized in that, The reconciliation of the counterparty valuation table and the self-valuation table based on the reconciliation data includes: From the self-evaluation table to be processed, obtain the self-evaluation account name and the first data of the comparison element; From the preset subject correspondence, obtain the target record containing the subject name of the party. The preset subject correspondence includes: multiple records, each record including: multiple synonyms; Determine whether there is a subject name in the pending counterparty valuation table that has a similarity to a synonym in the target record that meets a preset similarity condition. If so, determine that subject name as the counterparty subject name corresponding to the subject name in the target record. From the counterparty valuation table to be processed, obtain the second data corresponding to the counterparty's account name and the comparison element; Based on the first and second data, the accounts are reconciled to obtain the difference between the two, and an account reconciliation feedback table is generated.

4. The valuation table processing method according to claim 3, characterized in that, The reconciliation based on the first and second data, obtaining the difference between the two, and generating a reconciliation feedback table includes: Convert the data types of the first and second data to the same data type; Based on the same data type, the first and second data are reconciled to obtain the difference between them, and a reconciliation feedback table is generated.

5. The valuation table processing method according to claim 3, characterized in that, Also includes: If the difference between the first data and the second data is greater than the difference threshold between the corresponding subject and the element to be compared, then the feature data of the subject corresponding to the difference is obtained. The difference, the feature data corresponding to the subject, and the element to be compared are input into a preset root cause localization model. The output of the preset root cause localization model is determined as the reason for the difference between the first data and the second data, and the reason for the difference is written into the reconciliation feedback table. The preset root cause localization model is obtained by training the classification algorithm based on a batch of training samples and their corresponding actual differences. Each training sample includes: feature data of the subject corresponding to the historical difference and the elements to be compared.

6. The valuation table processing method according to claim 1, characterized in that, Following the receipt of the valuation table processing request, the following is also included: If the processing method in the valuation table processing request is valuation table element extraction, then obtain the local valuation table; Based on the preset list of elements to be extracted, determine the subjects and elements to be screened corresponding to the valuation table of this party; Write the element columns corresponding to the subjects and elements to be screened into a preset result ledger table to complete the valuation table processing corresponding to the valuation table processing request.

7. The valuation table processing method according to claim 6, characterized in that, The step of determining the subjects and elements to be screened corresponding to the valuation table based on the preset list of elements to be extracted includes: Extract the product name and valuation date from the name of the valuation table provided by this party; Based on the product name and valuation date, the subject to be screened and the element to be screened corresponding to the valuation table are extracted from the preset element to be extracted table.

8. An RPA robot, characterized in that, include: The receiving module is used to receive valuation table processing requests; The acquisition module is used to acquire reconciliation data according to the valuation table processing request if the processing method in the valuation table processing request is valuation table reconciliation. The reconciliation data includes: the counterparty valuation table to be processed, the local valuation table to be processed, the local account name, and the comparison elements. The processing module is used to reconcile the valuation table of the counterparty to be processed and the valuation table of the self to be processed based on the reconciliation data, and complete the valuation table processing corresponding to the valuation table processing request.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the method according to any one of claims 1 to 7.

Images