Form verification method, device, computer equipment and storage medium

Abstract

The present application relates to a form verification method, device, computer equipment and storage medium. The method includes: sequentially obtaining a piece of data to be matched in the first list, first matching the data to be matched with each piece of data in the second list one by one according to the matching rules; then, matching the data to be matched in the first list with the summary data in the second list for a second time; then, matching each record in the first list with the bill group data in the second list for a third time; each time the match is successful, the successfully matched data is marked. Through the three-check process, the data to be matched in the first list is matched with the single data, summary data, and bill group data in the second list layer by layer to obtain the verification results of the first list and the second list. This method can handle various types of bills, shorten the verification time, improve the verification efficiency, and improve the accuracy of the verification results.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a form checking method, device, computer equipment and storage medium. Background Art

[0002] In the process of reinsurance risk trading, insurance companies and reinsurance companies have a very heavy bill verification work. The current bill verification work relies on manual comparison, so the verification efficiency is low and the accuracy is not high. Summary of the invention

[0003] Based on this, it is necessary to provide a form checking method, device, computer equipment and storage medium that can improve the efficiency and accuracy of form checking in response to the above technical problems.

[0004] In a first aspect, a form checking method is provided, the method comprising:

[0005] Obtain one piece of data to be matched in the first list in turn, match the data to be matched with each piece of data in the second list one by one according to the matching rule, and if the match is successful, mark the data to be matched and the matching data in the second list for the first time;

[0006] Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; match the to-be-matched data in the first list with the aggregated data in the second list in sequence according to the matching rule, and if the match is successful, mark each piece of data of the to-be-matched data and the aggregated data in the second list for a second time;

[0007] At least one summary data with the same bill group number in the second list is summarized to obtain bill group data; each record in the first list is matched with the bill group data in the second list according to the matching rules. If the match is successful, the data to be matched and each data of the bill group data in the second list are marked for a third time to obtain the verification result of the first list and the second list.

[0008] In one embodiment, the method further comprises:

[0009] Obtain the first list and the second list, and display them on the verification interface;

[0010] In response to a triggering operation on a check control on the check interface, a parameter option box is displayed;

[0011] Get the input tolerance parameter value and reverse parameter value through the parameter option box;

[0012] The matching rule is obtained according to the tolerance parameter value and the reverse parameter value.

[0013] In one embodiment, matching the data to be matched with each piece of data in the second list one by one according to the matching rule includes:

[0014] Calculate according to the to-be-matched data in the first list and the reverse parameter value to obtain correct to-be-matched data;

[0015] If the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the match is successful.

[0016] In one embodiment, the first list and the second list are obtained and displayed on the verification interface including:

[0017] Obtaining an original settlement list provided by the first user;

[0018] Preprocessing the original settlement list to obtain a first list;

[0019] Displaying the first list on the checking interface;

[0020] A query condition is obtained, a second list is obtained from a database according to the query condition, and the second list is displayed on a verification interface, wherein the second list refers to an unsettled list provided by a second user.

[0021] In one embodiment, obtaining the query condition includes:

[0022] Acquire a trigger operation for a query control on the verification interface, and display a query condition field according to the query trigger operation, wherein the query condition field includes at least one of a bill status, a write-off status, a date range, a currency, or a first user identifier, wherein the currency is determined according to the currency in the first list;

[0023] Get the value assigned to the query condition field, and get the query condition based on the value of the query condition field.

[0024] In one embodiment, the method further comprises:

[0025] Calculate the matching degree based on the checking result, the data volume of the first list and the data volume of the second list;

[0026] If the matching degree is less than the preset matching degree, the query condition field is redisplayed, the value assigned to the query condition field is obtained, and a new query condition is obtained based on the value of the query condition field for verification, or the parameter option box is redisplayed, and the input tolerance parameter value and reverse parameter value are obtained through the parameter option box to redefine the matching rules.

[0027] In one embodiment, the method further comprises:

[0028] Acquire a trigger operation for a first export control on the verification interface, add a verification result ID to the first list, and generate a first verification file;

[0029] A trigger operation for a second export control on the verification interface is obtained, a verification result ID is added to the second list, and a second verification file is generated.

[0030] In a second aspect, a form checking device is provided, the device comprising:

[0031] A first matching module is used to sequentially obtain a piece of to-be-matched data in the first list, and match the to-be-matched data with each piece of data in the second list one by one according to the matching rule. If the match is successful, the to-be-matched data and the matching data in the second list are marked for the first time;

[0032] The second matching module is used to aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially match the data to be matched in the first list with the aggregated data in the second list according to the matching rule, and if the match is successful, mark each piece of data of the data to be matched and the aggregated data in the second list for a second time;

[0033] The third matching module is used to summarize at least one summary data with the same bill group number in the second list to obtain bill group data; match each record in the first list with the bill group data in the second list according to the matching rules. If the match is successful, the data to be matched and each data of the bill group data in the second list are marked for a third time to obtain the verification result of the first list and the second list.

[0034] In a third aspect, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0035] Obtain one piece of data to be matched in the first list in turn, match the data to be matched with each piece of data in the second list one by one according to the matching rule, and if the match is successful, mark the data to be matched and the matching data in the second list for the first time;

[0036] Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; match the to-be-matched data in the first list with the aggregated data in the second list in sequence according to the matching rule, and if the match is successful, mark each piece of data of the to-be-matched data and the aggregated data in the second list for a second time;

[0037] At least one summary data with the same bill group number in the second list is summarized to obtain bill group data; each record in the first list is matched with the bill group data in the second list according to the matching rules. If the match is successful, the data to be matched and each data of the bill group data in the second list are marked for a third time to obtain the verification result of the first list and the second list.

[0038] In a fourth aspect, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

[0039] Obtain one piece of data to be matched in the first list in turn, match the data to be matched with each piece of data in the second list one by one according to the matching rule, and if the match is successful, mark the data to be matched and the matching data in the second list for the first time;

[0040] Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; match the to-be-matched data in the first list with the aggregated data in the second list in sequence according to the matching rule, and if the match is successful, mark each piece of data of the to-be-matched data and the aggregated data in the second list for a second time;

[0041] At least one summary data with the same bill group number in the second list is summarized to obtain bill group data; each record in the first list is matched with the bill group data in the second list according to the matching rules. If the match is successful, the data to be matched and each data of the bill group data in the second list are marked for a third time to obtain the verification result of the first list and the second list.

[0042] The above-mentioned form verification method, device, computer equipment and storage medium obtain one piece of data to be matched in the first list in turn, and first match the data to be matched with each piece of data in the second list one by one according to the matching rules; then, match the data to be matched in the first list with the summary data in the second list for a second time; then, match each record in the first list with the bill group data in the second list for a third time; each time the match is successful, the successfully matched data is marked. Through the three-check process, the data to be matched in the first list is matched with the single data, summary data, and bill group data in the second list layer by layer to obtain the verification results of the first list and the second list. This method can handle various types of bills, shorten the verification time, improve the verification efficiency, and improve the accuracy of the verification results. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 An application environment diagram of a form checking method in an embodiment;

[0044] Figure 2 A schematic diagram of a flow chart of a form checking method in one embodiment;

[0045] Figure 3 A schematic diagram of an interface of a form checking method in one embodiment;

[0046] Figure 4 It is a structural diagram of a form checking method in another embodiment;

[0047] Figure 5 A schematic diagram of the overall flow of a form checking method in another embodiment;

[0048] Figure 6 is a structural block diagram of a form checking device in one embodiment;

[0049] Figure 7 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0050] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0051] The form verification method provided in this application can be applied to Figure 1 In the application environment shown. Among them, the terminal 102 communicates with the server 104 through the network. The terminal 102 receives the original settlement list provided by the first user, and sends the query conditions to the server 104 through the network through the query conditions entered by the checker on the check interface on the terminal 102. The server 104 queries in the database according to the query conditions, obtains the unsettled list provided by the second user, and sends it to the terminal 102 through the network. Among them, the terminal 102 can be but not limited to various personal computers, laptops, smart phones, tablet computers and portable wearable devices, and the server 104 can be implemented with an independent server or a server cluster composed of multiple servers. This embodiment is described by applying the form checking method to reinsurance risk transactions. The form checking method provided in this application can also be applied to form checking in other transaction processes, such as bank transaction bill checking, school bill checking, etc.

[0052] In one embodiment, Figure 2 As shown, a form checking method is provided, which is applied to Figure 1 The terminal in is used as an example to illustrate, including the following steps:

[0053] Step 202, sequentially obtain a piece of to-be-matched data in the first list, and match the to-be-matched data with each piece of data in the second list one by one according to the matching rule. If the match is successful, the to-be-matched data and the matching data in the second list are marked for the first time.

[0054] Among them, the first list is a settlement list provided by the first user. The first user can be a company or an individual. For example, the first user can be different types of insurance companies: a reinsurance brokerage company or a reinsurance ceding company. A reinsurance ceding company refers to an insurance company that transfers part of the insurance business it undertakes to other insurance companies; a reinsurance brokerage company mainly refers to those "companies where insurance brokers help insurance companies arrange reinsurance business and conduct reinsurance business according to the needs of certain large insurance businesses themselves." The first list can be a table or other text format, and this embodiment is not limited here, as long as the list information can be clearly represented. Each column in the first list represents an attribute, and each row represents a piece of data. The attributes of the first list include key list information such as currency and amount.

[0055] The second list is an unsettled list provided by the second user. The second user can be a company or an individual, for example, the second user can be a reinsurance company. Reinsurance, also known as ceding insurance or "insurance of insurance", refers to the business in which the insurer partially transfers its own insurance liability to other insurers. In the reinsurance business, the party that cedes the insurance is the original insurer, and the party that accepts the reinsurance is the reinsurer. The reinsurer has no direct relationship with the original insured and is only responsible to the original insurer. The second list can be a table or other text format, and this embodiment is not limited here, as long as the list information can be clearly represented. Each column in the second list represents an attribute, and each row represents a piece of data. The attributes of the second list include currency, amount, first user ID, bill status, write-off status, date range and other key information.

[0056] Specifically, a piece of data is obtained from the first list as the data to be matched, and the currency and amount of the data to be matched are matched one by one with each piece of data in the second list, and the two are checked according to the matching rules. The matching rules refer to the pre-set matching conditions of the currency and amount. If the currency and amount of the data to be matched and a piece of data in the second list meet the matching rules, the match is successful, and then the data to be matched and the matching data in the second list are marked for the first time. If there are multiple pieces of data in the second list that match the data to be matched, the multiple matching data are sorted in the order of increasing dates in the date interval in the second list, and the matching data and the data to be matched with the smallest date are selected for the first marking. The first marking method can be "first list line number ## second list line number", for example, if the amount and currency of the first line of data in the first list are the same as the amount and currency of the third line of data in the second list, the first marking is "1##3", and the mark is used as the ID of the verification result of the two pieces of data. A new column can be inserted in the first list and the second list, and the ID of the verification result is written into the corresponding row where the data to be matched and the matching data are located.

[0057] Step 204, summarize at least one piece of data with the same bill number in the second list to obtain summarized data; match the data to be matched in the first list with the summarized data in the second list in turn according to the matching rules. If the match is successful, mark each piece of data of the data to be matched and the summarized data in the second list for a second time.

[0058] Among them, one bill number may correspond to multiple amounts. These multiple amounts have the same bill number and belong to the same bill. The summary data of the bill is the sum of these multiple amounts. For example, Xiao A buys a product C in six installments. When the bill is finally summarized, the bill numbers of these six installments are the same and they all correspond to product C. When the bill is finally checked, the summary amount needs to be checked with the seller's bill.

[0059] Specifically, the amounts of multiple data with the same bill number in the second list are accumulated to obtain the aggregate amount of the aggregated data. One unmatched data is obtained from the first list in turn as the data to be matched, and the data to be matched is matched with the aggregate amount of the aggregated data in the second list in turn. If the unmatched data and the aggregate amount in the aggregated data meet the matching rules, the match is successful, and then the data to be matched and each piece of aggregated data in the second list are marked for the second time. The second marking method is the same as the first marking method mentioned above. For example, if the amount of the 5th line of data in the first list is 100, the currency is CNY, and the bill numbers of the amounts of lines 10, 20, and 30 in the second list are the same, and the accumulated amount of these three lines of data is 100CNY, then the second mark is written as "5##10_20_30".

[0060] Step 206, summarize at least one summary data with the same bill group number in the second list to obtain bill group data; match each record in the first list with the bill group data in the second list according to the matching rules. If the match is successful, mark the data to be matched and each data of the bill group data in the second list for a third time to obtain the verification result of the first list and the second list.

[0061] Specifically, a group of bills may contain multiple summary data, so the amounts of multiple bill summary data with the same bill group number need to be accumulated to get the bill group amount. For example, Xiao A has 15 purchases in October, all of which are paid with Huabei. Each purchase has a unique bill number. The bill group number corresponding to these multiple bill numbers, i.e., "October Consumption Bills", is the same, and they all belong to Xiao A's October consumption bills. When repaying Huabei in November, the 15 purchase amounts in October are summarized to get the bill group amount and then the repayment is made.

[0062] Obtain one unmatched data piece from the first list as the data to be matched, and match the data to be matched with the amount of the bill group data in the second list in turn. If the amount of the unmatched data and the bill group data meets the matching rules, the match is successful. Then mark the data to be matched and each piece of the bill group data in the second list for the third time, and use the third mark as the ID of the verification result of the two pieces of data. The third marking method is the same as the first marking method mentioned above, and no examples will be given here. Finally, the complete first list data and the verification result ID of each piece of data are used as the verification result of the first list, and the complete second list data and the verification result ID of each piece of data constitute the verification result of the second list.

[0063] In the above form verification method, by sequentially obtaining a piece of data to be matched in the first list, firstly, the data to be matched is matched one by one with each piece of data in the second list according to the matching rules; then, the data to be matched in the first list is matched with the summary data in the second list for a second time; then, each record in the first list is matched with the bill group data in the second list for a third time; each time the match is successful, the successfully matched data is marked. Through the three-check process, the data to be matched in the first list is matched with the single data, summary data, and bill group data in the second list layer by layer to obtain the verification results of the first list and the second list. This method can handle various types of bills, shorten the verification time, improve the verification efficiency, and improve the accuracy of the verification results.

[0064] In one embodiment, the method further comprises:

[0065] Obtain the first list and the second list, and display them on the verification interface;

[0066] In response to a triggering operation on a check control on the check interface, a parameter option box is displayed;

[0067] Get the input tolerance parameter value and reverse parameter value through the parameter option box;

[0068] The matching rule is obtained according to the tolerance parameter value and the reverse parameter value.

[0069] Specifically, the first list, the second list and some trigger controls are displayed on the verification interface. When the trigger operation of the verification control on the verification interface is received by the verification personnel, a parameter option box pops up and is displayed on the verification interface. The parameter option box includes two fields, namely, tolerance parameter and reverse parameter. The tolerance parameter is a two-decimal number format, which refers to the error that is acceptable to the verification process. For example, a tolerance parameter value of 0.00 means that no error is allowed, and a tolerance parameter value of 0.01 means that the allowable error range is [-0.01, 0.01]. The reverse parameter refers to the debit and credit direction of the data in the first list. If the first list is filled in from the perspective of the first user, the debit and credit direction of the amount in the second list is different, so the amount of the data in the first list needs to be multiplied by -1. For example, Xiao A borrowed 100 yuan from Xiao B. For Xiao A, the account amount is +100 yuan, and for Xiao B, the account amount is -100 yuan. The checker can input or select the tolerance parameter and reverse parameter fields in the parameter option box. The terminal obtains the input tolerance parameter value and reverse parameter value through the parameter option box, and calculates the matching rules based on the tolerance parameter value, reverse parameter value and the first list data and the second list data.

[0070] In this embodiment, the tolerance parameter value and the reverse parameter value are obtained through the parameter option box, and the tolerance parameter value can be adjusted according to the verification requirements. The data in the first list and the data in the second list are adjusted to be consistent according to the lending direction, thereby improving the flexibility and accuracy of the verification process.

[0071] In one embodiment, the data to be matched is matched one by one with each piece of data in the second list according to the matching rule, including:

[0072] Calculate according to the to-be-matched data in the first list and the reverse parameter value to obtain correct to-be-matched data;

[0073] If the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the match is successful.

[0074] Specifically, the correct data to be matched refers to the data to be matched whose lending direction is consistent with the lending direction in the second list. First, the lending direction of the data to be matched in the first list is detected. If it is consistent with the lending direction of the data in the second list, the data to be matched in the first list is the correct data to be matched; if it is inconsistent with the lending direction of the data in the second list, the amount in the data to be matched in the first list is multiplied by (-1) to obtain the correct data to be matched. The matching rule is that the currency of the correct data to be matched in the first list is the same as the currency of a data in the second list, and |the amount of the correct data to be matched in the first list-the amount of a data in the second list|<the tolerance parameter value. If the currency of the correct data to be matched in the first list is the same as the currency of a data in the second list, and the absolute value of the difference between the amounts of the two is less than the tolerance parameter value, the match is successful. Since the hash distribution of the amount is relatively good, the matching condition can be uniquely determined only based on the currency and the amount. If you want a higher matching degree, you can also add other conditions to improve the matching accuracy.

[0075] The second matching process is consistent with the above matching process. If the currency of the correct data to be matched in the first list is the same as the currency of the summary data amount in the second list, and the absolute value of the difference between the two amounts is less than the tolerance parameter value, the matching is successful.

[0076] The third matching process is consistent with the above matching process. If the currency of the correct data to be matched in the first list is the same as the currency of the bill group data amount in the second list, and the absolute value of the difference between the two amounts is less than the tolerance parameter value, the match is successful.

[0077] In this embodiment, the matching rules can be flexibly adjusted through the reverse parameter value and the tolerance parameter value, thereby improving the flexibility of the verification process. At the same time, through three verification processes, it can solve the situation where the second list contains single data, summary data and bill group data at the same time, and the bills for combined payments can also be summarized and matched successfully. It has a wide range of applications and ensures the accuracy of the verification results.

[0078] In one embodiment, the first list and the second list are obtained and displayed on the verification interface including:

[0079] Obtaining an original settlement list provided by the first user;

[0080] Preprocessing the original settlement list to obtain a first list;

[0081] Displaying the first list on the checking interface;

[0082] A query condition is obtained, a second list is obtained from a database according to the query condition, and the second list is displayed on a verification interface, wherein the second list refers to an unsettled list provided by a second user.

[0083] Specifically, when the original settlement list provided by the first user is received, the original settlement list is preprocessed to obtain a first list in a standardized format. For example, the original settlement list provided by the first user is received via email, and the two columns of currency and amount in the original settlement list are extracted, and the original settlement list in RMB is changed to CNY, and redundant information is removed. For example, the summary information in the original settlement list is removed, the identification of the first user (logo, first user name, etc.) is removed, and the first list attribute information is added: currency, amount, contract name, contract reinsurance / temporary reinsurance, account type, business year, etc., among which currency and amount are required attributes, and other attributes can be left unprocessed to improve the verification efficiency.

[0084] Import the first list into the verification interface. For example, you can drag the pre-processed first list directly into the verification interface and confirm the first list data, such as Figure 3 As shown, if the import is normal, the first list can be displayed on the left half of the boundary surface of the verification interface. By checking whether the number of lines of the first list displayed on the left side of the verification interface is accurate, whether there are extra blank lines, whether the amount and precision are imported accurately, whether the currency is ambiguous (such as CNY, RMB), whether there is unnecessary information misleading into the verification interface, etc., after the information is confirmed to be correct, the query conditions can be obtained to obtain the second list.

[0085] The query conditions input by the checker on the check interface are obtained and uploaded to the server. The server database stores all the bill information of the second user. The server obtains the unsettled list corresponding to the first list data from the database according to the query conditions and the query service provided by the server, i.e., the second list, and sends the second list to the terminal. After receiving the second list, the terminal displays the second list on the right half of the boundary surface of the check interface.

[0086] like Figure 4 As shown, the form checking method provided by this application and a series of services provided by SICS are designed through the development platform. Figure 4 It also shows a series of core system services (such as SICS Query, Live Desktop, SICS API), document cloud and development platform used by the form verification method provided by this application. The SICS (i.e. core system) series of services provide a guarantee for querying the second list. The second list can be quickly queried through different terminal devices, and the files generated by the verification process can be automatically stored in the document cloud for subsequent viewing.

[0087] In this embodiment, by preprocessing the original settlement list provided by the first user, settlement lists in different formats provided by different users can be processed, thereby enhancing the compatibility of the form verification method provided by this application; the server narrows the query scope through the query conditions, and uses the query service (i.e., SICS Query) provided by the SICS API to obtain the unsettled list provided by the second user, thereby achieving high query efficiency and being able to flexibly obtain the unsettled list that needs to be verified, thereby improving the flexibility of the verification method.

[0088] In one embodiment, obtaining query conditions includes:

[0089] Acquire a trigger operation for a query control on the verification interface, and display a query condition field according to the query trigger operation, wherein the query condition field includes at least one of a bill status, a write-off status, a date range, a currency, or a first user identifier, wherein the currency is determined according to the currency in the first list;

[0090] Get the value assigned to the query condition field, and get the query condition based on the value of the query condition field.

[0091] Specifically, when the trigger operation of the checker on the query control on the check interface is obtained, the query condition field is displayed, and the query condition field includes at least one of the bill status, write-off status, date range, currency, or first user identification. Among them, the first user identification can be obtained and entered according to the ID or name of the user in the first list, and the first user is represented as a necessary query condition. The currency does not need to be entered, and the currency field value can be automatically obtained and displayed on the currency field directly according to the currency information in the first list. Other field information can be entered by the checker, and then the terminal obtains the value assigned to the query condition field to obtain the query condition. For example, in order to obtain the unsettled list, the bill status must be close, the write-off status is unsettle, the date range is October 2020-November 2020, the first user identification is 1, and the query condition obtained is the unsettled list of the first user identified as 1 from October 2020 to November 2020.

[0092] In this embodiment, by obtaining the input query conditions, the query range can be adjusted according to the verification requirements, thereby improving the flexibility of the verification, and the unsettled list can be obtained according to multiple query conditions, thereby improving the accuracy of the verification.

[0093] In one embodiment, the method further comprises:

[0094] Calculate the matching degree based on the checking result, the data volume of the first list and the data volume of the second list;

[0095] If the matching degree is less than the preset matching degree, the query condition field is redisplayed, the value assigned to the query condition field is obtained, and a new query condition is obtained based on the value of the query condition field for verification, or the parameter option box is redisplayed, and the input tolerance parameter value and reverse parameter value are obtained through the parameter option box to redefine the matching rules.

[0096] Specifically, the matching degree includes the matching degree of the first list and the matching degree of the second list, and the matching degree is calculated as the number of successful matches / total number. The matching degree of the first list is the number of successful matches in the first list divided by the total data volume of the first list, and the matching degree of the second list is the number of successful matches in the second list divided by the total data volume of the second list. For example, the first list imports 1,000 rows of data, and 987 rows are successfully matched, which means that verification result IDs are generated after 987 rows, and the matching degree on the left is 98.7%. At this time, if the second list data is 2,000 items and 987 items are matched, then the matching degree of the second list is 49.35%. The matching degree of the first list and the second list can allow users to better understand the status of the list data and the matching status.

[0097] The first list matching degree, the second list matching degree and the preset matching degree can be compared. If the matching degree is less than the preset matching degree, the parameter option box or the query condition field is redisplayed, and the input tolerance parameter value and reverse parameter value are obtained through the parameter option box again, the matching rule is re-determined, and then the check is re-performed; or the value assigned to the query condition field is obtained again, and a new query condition is obtained according to the value of the query condition field, and the check is re-performed. When re-checking, the previous check result will be cleared.

[0098] In one embodiment, the method further comprises:

[0099] Acquire a trigger operation for a first export control on the verification interface, add a verification result ID to the first list, and generate a first verification file;

[0100] A trigger operation for a second export control on the verification interface is obtained, a verification result ID is added to the second list, and a second verification file is generated.

[0101] Specifically, when the checker triggers the first export control on the check interface, the check result ID is added to the first list, a first check file is generated, and the first check file is automatically stored in the document cloud, which is not easy to lose. The first check file can be sent to the first user so that the first user can view the check result.

[0102] When the verification personnel triggers the second export control on the verification interface, the verification result ID is added to the second list, a second verification file is generated, and the first verification file is automatically stored in the document cloud to prevent loss. The second verification file is used for the second user to retain and internal reconciliation, so as to summarize the results of multiple verifications in the future for subsequent verification work.

[0103] You can also create a verification object based on the creation control of the verification interface. When creating a verification object, you can create multiple verification objects based on the currency. You can also convert verification objects of different currencies in a verification process into a compromise currency to create a verification object. Due to the separation of business systems, the second user also includes different sub-users. When creating a verification object, each subsidiary creates a separate verification object. For example, China Re Group includes 6 subsidiaries such as China Property Reinsurance Co., Ltd. and China Life Reinsurance Co., Ltd. The businesses of different subsidiaries are separated, and a verification object needs to be created for each subsidiary. The verification object includes the first checklist, the second checklist, the verification result ID, the verification time and matching degree, and the verification process number, which can be used as the connection key between the verification system and the core system for subsequent verification work and to make the verification process traceable.

[0104] In this embodiment, by creating a first verification file, a first verification document and a verification object, and automatically storing the verification file and the verification object in the document cloud, the verification process can be traced, which facilitates subsequent work.

[0105] In order to facilitate the understanding of the technical solutions provided in the embodiments of the present application, Figure 5 , the form checking method provided in the embodiment of the present application is briefly described with a complete form checking process:

[0106] (1) Obtain the original settlement list provided by the first user (i.e. Figure 5 in the Settlement List).

[0107] (2) Preprocessing the original settlement list (i.e. Figure 5 clear the settlement list in the check list) to obtain a first list; display the first list (i.e. Figure 5 to the system).

[0108] (3) Obtaining a trigger operation for a query control on the verification interface, and displaying a query condition field according to the query trigger operation, wherein the query condition field includes at least one of a bill status, a write-off status, a date range, a currency, or a first user identifier, wherein the currency is determined according to the currency in the first list. Obtaining a value assigned to the query condition field, and obtaining a query condition (i.e., Figure 5Query the unsettled list in the database). Query the database to obtain a second list according to the query condition, and display the second list on the verification interface, wherein the second list refers to the unsettled list provided by the second user.

[0109] (4) in response to a triggering operation on a check control on the check interface, a parameter option box is displayed; a tolerance parameter value and a reverse parameter value inputted are obtained through the parameter option box; and the matching rule (i.e., Figure 5 in the trigger smart check).

[0110] (5) Obtain one piece of data to be matched in the first list in turn, and match the data to be matched with each piece of data in the second list one by one according to the matching rule (i.e. Figure 5 In the bill-by-bill matching process), if the match is successful, the to-be-matched data and the matching data in the second list are marked for the first time.

[0111] (6) Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; match the to-be-matched data in the first list with the aggregated data in the second list in sequence according to the matching rule (i.e. Figure 5 In the Balance matching process), if the match is successful, each piece of data to be matched and the summarized data in the second list is marked for the second time.

[0112] (7) Aggregate at least one summary data with the same bill group number in the second list to obtain bill group data; match each record in the first list with the bill group data in the second list according to the matching rule (i.e. Figure 5 Claim group matching process in the claim group), if the match is successful, each piece of data of the to-be-matched data and the bill group data in the second list is marked for the third time to obtain the verification result of the first list and the second list.

[0113] (8) Calculate based on the verification result, the first list data volume and the second list data volume to obtain the matching degree (i.e., the matching result generation process); if the matching degree is less than the preset matching degree, redisplay the query condition field, obtain the value assigned to the query condition field, obtain the new query condition according to the value of the query condition field, and perform the verification, or redisplay the parameter option box, obtain the input tolerance parameter value and reverse parameter value through the parameter option box, and redefine the matching rule.

[0114] (9) Obtain a trigger operation for the first export control on the verification interface, add the verification result ID to the first list, and generate a first verification file (i.e., export the other party's result file); obtain a trigger operation for the second export control on the verification interface, add the verification result ID to the second list, and generate a second verification file (i.e., export our result file); and may also generate a verification object (i.e., generate an SBG object, a Settlement Balance Group object).

[0115] It should be understood that although Figure 2 , Figure 5 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 2 , Figure 5 At least part of the steps may include multiple steps or multiple stages. These steps or stages are not necessarily performed at the same time, but can be performed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed in turn or alternately with other steps or at least part of the steps or stages in other steps.

[0116] In one embodiment, Figure 6 As shown, a form checking device is provided, including: a first matching module 602, a second matching module 604 and a third matching module 606, wherein:

[0117] The first matching module 602 is used to sequentially obtain a piece of data to be matched in the first list, and match the data to be matched with each piece of data in the second list one by one according to the matching rule. If the match is successful, the data to be matched and the matching data in the second list are marked for the first time.

[0118] The second matching module 604 is used to summarize at least one piece of data with the same bill number in the second list to obtain summarized data; according to the matching rules, the data to be matched in the first list is matched with the summarized data in the second list in turn. If the match is successful, each piece of data of the data to be matched and the summarized data in the second list is marked for the second time.

[0119] The third matching module 606 is used to summarize at least one summary data with the same bill group number in the second list to obtain bill group data; match each record in the first list with the bill group data in the second list according to the matching rules. If the match is successful, mark the data to be matched and each data of the bill group data in the second list for a third time to obtain the verification result of the first list and the second list.

[0120] In one embodiment, the above-mentioned form checking device further includes: an acquisition module and a display module.

[0121] The acquisition module is used to acquire the first list and the second list and display them on the verification interface;

[0122] The display module is used to display a parameter option box in response to a trigger operation on the check control on the check interface; and obtain the input tolerance parameter value and reverse parameter value through the parameter option box; and obtain the matching rule according to the tolerance parameter value and reverse parameter value.

[0123] In one embodiment, the first matching module 602 is further used to calculate based on the data to be matched in the first list and the reverse parameter value to obtain correct data to be matched; if the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the match is successful.

[0124] In one embodiment, the acquisition module includes a first acquisition unit and a second acquisition unit, wherein the first acquisition unit is used to acquire an original settlement list provided by the first user; and is also used to pre-process the original settlement list to obtain a first list;

[0125] The display module is also used to display the first list on the checking interface;

[0126] The second acquisition unit is used to acquire a query condition, query the database to obtain a second list according to the query condition, and display the second list on the verification interface, wherein the second list refers to an unsettled list provided by the second user.

[0127] In one embodiment, the second acquisition unit is used to acquire a trigger operation of a query control on the verification interface, and display a query condition field according to the query trigger operation, wherein the query condition field includes at least one of a bill status, a write-off status, a date range, a currency, or a first user identifier, wherein the currency is determined according to the currency in the first list;

[0128] And obtain the value assigned to the query condition field, and obtain the query condition according to the value of the query condition field.

[0129] In one embodiment, the third matching module 606 is further used to calculate according to the checking result, the first list data volume and the second list data volume to obtain a matching degree;

[0130] If the matching degree is less than the preset matching degree, the display module is also used to redisplay the query condition field, and the second acquisition unit is also used to obtain the value assigned to the query condition field, obtain a new query condition according to the value of the query condition field, and perform a check, or the display module is also used to redisplay the parameter option box, obtain the input tolerance parameter value and reverse parameter value through the parameter option box, and redefine the matching rule.

[0131] In one embodiment, the first acquisition unit is further used to acquire a trigger operation on a first export control on the verification interface, add a verification result ID to the first list, and generate a first verification file;

[0132] The second acquisition unit is also used to acquire a trigger operation on a second export control on the verification interface, add a verification result ID to the second list, and generate a second verification file.

[0133] For the specific definition of the form checking device, please refer to the definition of the form checking method above, which will not be repeated here. Each module in the above-mentioned form checking device can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0134] In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as follows: Figure 7 As shown. The computer device includes a processor, a memory, a communication interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be achieved through WIFI, an operator network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a form verification method is implemented. The display screen of the computer device can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covered on the display screen, or a button, trackball or touchpad set on the computer device housing, or an external keyboard, touchpad or mouse, etc.

[0135] Those skilled in the art will understand that Figure 7 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0136] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0137] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0138] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0139] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0140] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A form checking method, characterized in that: The method comprises: Obtain one piece of to-be-matched data in the first list in turn, match the to-be-matched data with each piece of data in the second list one by one according to the matching rule, and if the match succeeds, mark the to-be-matched data and the matching data in the second list for the first time; Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; match the to-be-matched data in the first list with the aggregated data in the second list in sequence according to the matching rule, and if the match is successful, mark each piece of data of the to-be-matched data and the aggregated data in the second list for a second time; Aggregate at least one summary data with the same bill group number in the second list to obtain bill group data; match each record in the first list with the bill group data in the second list according to the matching rule, and if the match is successful, mark each data of the to-be-matched data and the bill group data in the second list for a third time to obtain a verification result of the first list and the second list, wherein the verification result at least includes one of the first marking result of marking the to-be-matched data and the matching data in the second list for the first time, the second marking result of marking the to-be-matched data and the summary data in the second list for the second time, and the third marking result of marking the to-be-matched data and the account group data in the second list for the third time, and the method further includes: Obtain the first list and the second list, and display them on the verification interface; In response to a triggering operation on a check control on the check interface, displaying a parameter option box; Obtaining the input tolerance parameter value and reverse parameter value through the parameter option box; The matching rule is obtained according to the tolerance parameter value and the reverse parameter value.

2. The method according to claim 1, characterized in that The step of matching the data to be matched with each piece of data in the second list one by one according to the matching rule includes: Calculate according to the to-be-matched data in the first list and the reverse parameter value to obtain correct to-be-matched data; If the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the match is successful.

3. The method according to claim 1, characterized in that The obtaining of the first list and the second list and displaying them on the verification interface include: Obtaining an original settlement list provided by the first user; Preprocessing the original settlement list to obtain a first list; Displaying the first list on the verification interface; A query condition is obtained, a second list is obtained from a database according to the query condition, and the second list is displayed on a verification interface, wherein the second list refers to an unsettled list provided by a second user.

4. The method according to claim 3, characterized in that The obtaining query conditions includes: Acquire a trigger operation for a query control on the verification interface, and display a query condition field according to the query trigger operation, wherein the query condition field includes at least one of a bill status, a write-off status, a date range, a currency, or a first user identifier, wherein the currency is determined according to the currency in the first list; The value assigned to the query condition field is obtained, and the query condition is obtained according to the value of the query condition field.

5. The method according to claim 4, characterized in that The method further comprises: Calculating according to the checking result, the data volume of the first list and the data volume of the second list to obtain a matching degree; If the matching degree is less than the preset matching degree, the query condition field is redisplayed, the value assigned to the query condition field is obtained, a new query condition is obtained according to the value of the query condition field, and a check is performed, or the parameter option box is redisplayed, and the input tolerance parameter value and reverse parameter value are obtained through the parameter option box to redefine the matching rules.

6. The method according to claim 1, characterized in that The method further comprises: Acquire a trigger operation for a first export control on the verification interface, add a verification result ID to the first list, and generate a first verification file; A trigger operation for a second export control on the verification interface is obtained, a verification result ID is added to the second list, and a second verification file is generated.

7. A form checking device, characterized in that: The device comprises: A first matching module is used to sequentially obtain a piece of to-be-matched data in the first list, and match the to-be-matched data with each piece of data in the second list one by one according to the matching rule, and if the match is successful, mark the to-be-matched data and the matching data in the second list for the first time; A second matching module is used to aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially match the data to be matched in the first list with the aggregated data in the second list according to the matching rule, and if the match is successful, mark each piece of data of the data to be matched and the aggregated data in the second list for a second time; The third matching module is used to summarize at least one summary data with the same bill group number in the second list to obtain bill group data; match each record in the first list with the bill group data in the second list according to the matching rule, and if the match is successful, mark the data to be matched and each data of the bill group data in the second list for a third time to obtain the verification result of the first list and the second list, wherein the verification result at least includes one of the first marking result of marking the data to be matched and the matching data in the second list for the first time, the second marking result of marking the data to be matched and the summary data in the second list for the second time, and the third marking result of marking the data to be matched and the account group data in the second list for the third time. The form verification device also includes an acquisition module and a display module, the acquisition module is used to acquire the first list and the second list and display them on the verification interface; the display module is used to display a parameter option box in response to a trigger operation on the verification control on the verification interface, and obtain the input tolerance parameter value and reverse parameter value through the parameter option box, and obtain the matching rule according to the tolerance parameter value and reverse parameter value.

8. The device according to claim 7, characterized in that The first matching module is also used for: Calculation is performed based on the data to be matched in the first list and the reverse parameter value to obtain correct data to be matched; if the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the match is successful.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images