Reconciliation method and device, electronic equipment and storage medium
A standardized reconciliation method using a step-by-step verification process addresses inconsistencies in business information reconciliation, ensuring accuracy and reducing costs by adjusting and re-verifying data until balance is achieved.
Patent Information
- Application Number
- CN202411145167.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-20
- Publication Date
- 2024-12-03
AI Technical Summary
The current reconciliation process for business information is fragmented and inconsistent across different types, leading to high maintenance costs due to customization, necessitating a universal and standardized reconciliation method.
A step-by-step verification method with varying granularities is employed to compare and adjust business volumes and details, ensuring balance and accuracy by reconciling first and second reconciliation data from different databases.
This approach ensures accurate and efficient reconciliation by identifying and correcting discrepancies, thereby reducing financial risks and maintenance costs associated with inconsistent reconciliation processes.
Smart Images

Figure CN119067793A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of data verification, and in particular to a reconciliation method, device, electronic device and storage medium. Background Art
[0002] With the increasing business volume and amount of bills and other products, business information verification, including verification of message sending and receiving quantity and fund settlement amount, is becoming more and more important. However, the current reconciliation process for business information such as business quantity and business amount is customized according to the actual business type. There is a problem of fragmentation and inconsistency in the reconciliation process of different business information, which results in excessively high maintenance costs for the business information reconciliation system.
[0003] Therefore, how to implement a highly universal and standardized reconciliation method for different business information is a problem that urgently needs to be solved. Summary of the invention
[0004] The main purpose of this application is to provide a reconciliation method, device, electronic device and storage medium, aiming to solve the technical problem of how to implement a highly universal standardized reconciliation method for different business information.
[0005] To achieve the above purpose, the present application proposes a reconciliation method, which includes:
[0006] Acquire first reconciliation data and second reconciliation data, and verify a first business volume of the first reconciliation data and a second business volume of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases;
[0007] When the first business total amount is not balanced with the second business total amount, obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and verifying the first reconciliation detail data and the second reconciliation detail data;
[0008] In the case that the first reconciliation detail data and the second reconciliation detail data are not balanced after verification, determining a business detail difference portion, adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference portion, and returning to execute the step of verifying the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data;
[0009] When the first reconciliation detailed data and the second reconciliation detailed data are checked and balanced, it is determined that the first reconciliation data and the second reconciliation data are balanced.
[0010] In one embodiment, the step of verifying the first business volume of the first reconciliation data and the second business volume of the second reconciliation data includes:
[0011] Aggregating the first reconciliation data to obtain the first business volume, and aggregating the second reconciliation data to obtain the second business volume;
[0012] Comparing the first business total volume with the second business total volume, and determining that the first reconciliation data and the second reconciliation data are balanced when the first business total volume is consistent with the second business total volume;
[0013] When the first business total amount is inconsistent with the second business total amount, it is determined that the first business total amount is not equal to the second business total amount.
[0014] In one embodiment, the first business total includes a total single clearing amount, a total batch clearing amount, and a total clearing debit amount, and the second business total includes a total single clearing amount of large-value payments, a total batch clearing amount of large-value payments, and a total clearing credit amount;
[0015] The step of comparing the first total business volume with the second total business volume comprises:
[0016] Compare the total amount of the single clearing amount with the total amount of the single clearing amount of the large-amount payment, the total amount of the batch clearing amount with the total amount of the batch clearing amount of the large-amount payment, and the total amount of the clearing debit amount with the total amount of the clearing credit amount one by one;
[0017] In the case where the total amount of the single clearing transaction is consistent with the total amount of the single clearing transaction of the large-value payment, the total amount of the batch clearing transaction is consistent with the total amount of the batch clearing transaction of the large-value payment, and the total amount of the clearing debit amount is consistent with the total amount of the clearing credit amount, it is determined that the first business total amount is consistent with the second business total amount;
[0018] When the total amount of the single settlement amount is inconsistent with the total amount of the single settlement amount of the large-value payment, the total amount of the batch settlement amount is inconsistent with the total amount of the batch settlement amount of the large-value payment, and the total amount of the settlement debit amount is inconsistent with the total amount of the settlement credit amount, it is determined that the first business total amount is inconsistent with the second business total amount.
[0019] In one embodiment, the first business total includes a total single clearing amount, a total batch clearing amount, and a total clearing debit amount, and the second business total includes a total single clearing amount of large-value payments, a total batch clearing amount of large-value payments, and a total clearing credit amount;
[0020] The step of obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data includes:
[0021] The group whose total amount is inconsistent among the total amount of the single clearing amount and the total amount of the large-amount payment single clearing amount, the total amount of the batch clearing amount and the total amount of the large-amount payment batch clearing amount, and the total amount of the clearing debit amount and the total amount of the clearing credit amount is taken as the target group;
[0022] The first reconciliation detail data and the second reconciliation detail data are obtained based on the target group, wherein the first reconciliation detail data is the reconciliation detail data belonging to the first reconciliation data part in the target group, and the second reconciliation detail data is the reconciliation detail data belonging to the second reconciliation data part in the target group.
[0023] In one embodiment, the step of verifying the first account reconciliation detail data and the second account reconciliation detail data includes:
[0024] Compare each first business item in the first account reconciliation detailed data with each second business item in the second account reconciliation detailed data one by one;
[0025] When the first business items are consistent with the second business items, determining that the first reconciliation data and the second reconciliation data are balanced;
[0026] When any of the first business items is inconsistent with the second business items, it is determined that the first account reconciliation detailed data is not balanced with the second account reconciliation detailed data.
[0027] In one embodiment, the first business item includes at least one of a single settlement amount, a batch settlement amount, and a settlement debit amount, and the second business item includes at least one of a large-amount payment single settlement amount, a large-amount payment batch settlement amount, and a settlement credit amount;
[0028] The step of comparing each first business item in the first account reconciliation detailed data with each second business item in the second account reconciliation detailed data one by one comprises:
[0029] The first business items are compared with the second business items one by one based on the clearing and delivery order numbers, wherein the clearing and delivery order number is an identifier shared by the account corresponding to the single clearing amount and the account corresponding to the single clearing amount of the large-amount payment, or the account corresponding to the batch clearing amount and the account corresponding to the batch clearing amount of the large-amount payment, or the account corresponding to the clearing debit amount and the account corresponding to the clearing credit amount;
[0030] When the first business item and the second business item corresponding to any clearing and delivery order number are consistent, determining that the first business items are consistent with the second business items;
[0031] In the case where the first business item and the second business item corresponding to any clearing and delivery order number are inconsistent, it is determined that the first business items are inconsistent with any of the second business items.
[0032] In one embodiment, the first reconciliation detail data includes at least one of a single clearing account, a batch clearing account, and a clearing debit account, and the second reconciliation detail data includes at least one of a large-value payment clearing single account, a large-value payment clearing batch account, and a clearing credit account;
[0033] The step of adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part includes:
[0034] In the case where the first reconciliation detail data is the reconciliation party of the second reconciliation detail data, and the difference in the business details is any first business amount in the single settlement account and / or the batch settlement account, which is inconsistent with the corresponding second business amount in the single large-value payment settlement account and / or the batch large-value payment settlement account, the single large-value payment settlement account and / or the batch large-value payment settlement account corresponding to the second business amount shall be refunded and cleared;
[0035] When the first reconciliation detail data and the second reconciliation detail data are reconciliation parties to each other, and the difference in the business details is any third business amount in the clearing debit account, which is inconsistent with the corresponding fourth business amount in the clearing credit account, a reconciliation exception signal is output based on the clearing debit account corresponding to the third business amount and the clearing credit account corresponding to the fourth business amount, and the adjustment data requested by the reconciliation exception signal is received.
[0036] In addition, to achieve the above purpose, the present application also proposes a reconciliation device, the reconciliation device comprising:
[0037] A summary and verification module, used for obtaining the first reconciliation data and the second reconciliation data, and verifying the first business volume of the first reconciliation data and the second business volume of the second reconciliation data;
[0038] a detail checking module, configured to obtain first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and check the first reconciliation detail data and the second reconciliation detail data when the first business total amount is not balanced with the second business total amount;
[0039] a detailed reconciliation module, configured to determine a business detail difference portion when the first reconciliation detailed data and the second reconciliation detailed data are not balanced after reconciliation, reconcile the first reconciliation detailed data and / or the second reconciliation detailed data according to the business detail difference portion, and return to execute the step of reconciling the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data;
[0040] The reconciliation completion module is used to determine that the first reconciliation data and the second reconciliation data are reconciled when the first reconciliation detailed data and the second reconciliation detailed data are reconciled.
[0041] In addition, to achieve the above-mentioned purpose, the present application also proposes an electronic device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the reconciliation method described above.
[0042] In addition, to achieve the above-mentioned purpose, the present application also proposes a storage medium, which is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by the processor, the steps of the reconciliation method described above are implemented.
[0043] In addition, to achieve the above-mentioned purpose, the present application also provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the steps of the reconciliation method described above are implemented.
[0044] One or more technical solutions proposed in this application have at least the following technical effects:
[0045] The present application first obtains first reconciliation data and second reconciliation data, and compares a first business total of the first reconciliation data with a second business total of the second reconciliation data, so as to quickly discover possible accounting errors in business information by comparing the balance of the business totals; in the case where the first business total and the second business total are not balanced when compared, first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data are obtained, and the first reconciliation detail data and the second reconciliation detail data are compared, so as to further compare specific detail data when the business totals are not balanced, so as to accurately compare the accounts of business information; in the case where the first reconciliation detail data and the second reconciliation detail data are compared, If the business details are not balanced, the difference part of the business details is determined, and the first reconciliation detail data and / or the second reconciliation detail data are adjusted according to the difference part of the business details, and the step of checking the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data is returned to execute, so that when the detail data is not balanced, the account adjustment processing is performed to correct the account of the business information and recheck it, thereby ensuring the accuracy of the account of the business information; when the first reconciliation detail data and the second reconciliation detail data are balanced after checking, it is determined that the account of the first reconciliation data and the second reconciliation data are balanced, so that when the detail data are balanced, the account of the business information is confirmed to be balanced, thereby ensuring the balance of the account of the business information after the reconciliation process is executed.
[0046] In summary, the present application adopts a step-by-step verification method with a granularity from coarse to fine to verify the total business volume and the business detail data of the first reconciliation data and the second reconciliation data in turn, and adjusts the accounts and re-verifies when the detail data is not balanced. Since different business information that need to be reconciled has both the total business volume and the business detail data, and by verifying these two types of information, it is possible to determine whether the accounts of the business information are balanced, thus meeting the requirements of general and strong standardized reconciliation of different business information. BRIEF DESCRIPTION OF THE DRAWINGS
[0047] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.
[0048] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.
[0049] Figure 1A flowchart of the first embodiment of the reconciliation method of this application is provided;
[0050] Figure 2 A flow chart of the second embodiment of the reconciliation method of this application;
[0051] Figure 3 A schematic diagram of a simplified flow chart of the reconciliation method provided in Example 2 of the present application;
[0052] Figure 4 A detailed flowchart of the reconciliation method provided in Example 2 of the present application;
[0053] Figure 5 This is a schematic diagram of the module structure of the account reconciliation device according to an embodiment of the present application;
[0054] Figure 6 A schematic diagram of the device structure of the hardware operating environment involved in the reconciliation method in the embodiment of the present application.
[0055] The purpose, features and advantages of this application will be further described in conjunction with the embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0056] It should be understood that the specific embodiments described herein are only used to explain the technical solutions of the present application and are not used to limit the present application.
[0057] In order to better understand the technical solution of the present application, a detailed description will be given below in conjunction with the accompanying drawings and specific implementation methods.
[0058] The main solution of the embodiment of the present application is: obtaining first reconciliation data and second reconciliation data, and checking the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases; in the case that the first business total amount is not balanced with the second business total amount, obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and checking the first reconciliation detail data and the second reconciliation detail data; in the case that the first reconciliation detail data and the second reconciliation detail data are not balanced, determining the business detail difference part, adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part, and returning to execute the step of checking the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data; in the case that the first reconciliation detail data and the second reconciliation detail data are balanced after checking, determining the account balance of the first reconciliation data and the second reconciliation data.
[0059] Since the existing technology reconciliation process for business information such as business quantity and business amount is customized according to the actual business type, there is a problem of fragmentation and inconsistency in the reconciliation process of different business information, which makes the maintenance cost of the business information reconciliation system too high. Therefore, how to implement a highly universal and standardized reconciliation method for different business information is a problem that needs to be solved urgently.
[0060] The present application provides a solution, which uses a step-by-step verification method with a granularity ranging from coarse to fine to verify the total business volume and business detail data of the first reconciliation data and the second reconciliation data in turn, and adjusts and re-verifies the accounts when the detail data is not balanced, thereby meeting the requirements of common and strong standardized reconciliation of different business information.
[0061] It should be noted that the execution subject of this embodiment may be a computing service device with data processing, network communication and program running functions, such as a tablet computer, a personal computer, a mobile phone, etc., or an electronic device capable of realizing the above functions, etc. The following takes an electronic device as an example to illustrate this embodiment and the following embodiments.
[0062] Based on this, the present application embodiment provides a reconciliation method, referring to Figure 1 , Figure 1 This is a flowchart of the first embodiment of the reconciliation method of the present application.
[0063] In this embodiment, the reconciliation method includes steps S10 to S40:
[0064] Step S10, obtaining first reconciliation data and second reconciliation data, and verifying a first business volume of the first reconciliation data and a second business volume of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases;
[0065] It should be noted that the first reconciliation data refers to the reconciliation records provided by the accounting database of a certain system or institution; the second reconciliation data refers to the reconciliation records provided by the accounting database of another system or institution; the first business total amount refers to the total amount of a specific business type recorded in the first reconciliation data, which can be the total number of business quantities or the total amount of business amounts. In this embodiment, the type of the first business total amount is not specifically limited; the second business total amount refers to the total number of a specific business type recorded in the second reconciliation data, which can be the total number of business quantities or the total amount of business amounts. In this embodiment, the type of the second business total amount is not specifically limited.
[0066] In addition, it should be noted that the first reconciliation data may be the reconciliation party of the second reconciliation data, and the first reconciliation data and the second reconciliation data may also be the reconciliation parties of each other. In this embodiment, no specific limitation is made to the reconciliation parties.
[0067] It is understandable that, since there may be an imbalance between the reconciliation data from two different sources during the accounting recording process, performing step S10 can quickly check the total amount of the reconciliation data from two different sources, timely discover the imbalance in the accounting record, and thus improve the efficiency of the reconciliation process.
[0068] In a feasible implementation manner, the step of verifying the first business volume of the first reconciliation data and the second business volume of the second reconciliation data in step S10 may include steps S11 to S13:
[0069] Step S11, summarizing the first reconciliation data to obtain the first business volume, and summarizing the second reconciliation data to obtain the second business volume;
[0070] It is understandable that, since there may be an imbalance between the reconciliation data from two different sources during the accounting recording process, performing step S11 can provide an accurate and effective data basis for quickly checking the total amount of the reconciliation data from two different sources.
[0071] Exemplarily, when the first reconciliation data is the business summary data sent by the National Securities Clearing Corporation through the 071 summary information message, and the second reconciliation data is the message summary data on the bank side, the total number of messages of the business summary data is taken as the first business total amount, and the total number of messages of the message summary data is taken as the second business total amount.
[0072] Exemplarily, when the first reconciliation data is the clearing debit account within the bank and the clearing data issued by the Clearing House through the clearing notification message, and the second reconciliation data is the clearing credit account within the bank and the account data of the People's Bank of China's large-value payment message, the total amount of the clearing debit account, the total amount of a single clearing transaction in the clearing data, and the total amount of a batch clearing transaction in the clearing data are respectively taken as the first business total amount, and the total amount of the calculated credit account, the total amount of a single clearing transaction of large-value payments in the account data, and the total amount of a batch clearing transaction of large-value payments in the account data are respectively taken as the second business total amount.
[0073] Step S12, comparing the first business total volume with the second business total volume, and determining that the first reconciliation data and the second reconciliation data are balanced when the first business total volume is consistent with the second business total volume;
[0074] It is understandable that since inconsistencies in the total business volume in the accounting records may lead to greater financial risks, step S12 is performed to avoid capital losses or other financial risks caused by inconsistencies in the total business volume in the accounting records by determining the consistency of the reconciliation data from the two sources in terms of the total business volume, thereby ensuring the accuracy and consistency of the accounting records.
[0075] In a feasible implementation manner, the first business total amount includes a total amount of single clearing amount, a total amount of batch clearing amount and a total amount of clearing debit amount, and the second business total amount includes a total amount of single clearing amount of large-value payment, a total amount of batch clearing amount of large-value payment and a total amount of clearing credit amount;
[0076] It should be noted that the total amount of single clearing refers to the cumulative amount of financial transactions processed by the National Bill Exchange through single clearing within a certain period of time; the total amount of batch clearing refers to the cumulative amount of financial transactions processed by the National Bill Exchange through batch clearing within a certain period of time; the total amount of clearing debits refers to the cumulative amount deducted from bank accounts through clearing within a certain period of time; the total amount of single clearing of large-value payments refers to the cumulative amount of financial transactions processed by the People's Bank of China through single large-value payment clearing within a certain period of time; the total amount of large-value payment batch clearing refers to the cumulative amount of financial transactions processed by the People's Bank of China through batch large-value payment clearing within a certain period of time; the total amount of clearing credits refers to the cumulative amount added to bank accounts through clearing within a certain period of time.
[0077] The step of comparing the first total business volume with the second total business volume in step S12 may include steps A121 to A123:
[0078] Step A121, comparing the total amount of the single clearing amount with the total amount of the single clearing amount of the large-amount payment, the total amount of the batch clearing amount with the total amount of the batch clearing amount of the large-amount payment, and the total amount of the clearing debit amount with the total amount of the clearing credit amount one by one;
[0079] It is understandable that since the total amount under different settlement methods may be inconsistent during the bank reconciliation process, step A121 is performed to ensure the consistency of the total amount under different settlement methods by comparing the total amount of reconciliation data from different sources under the same settlement method.
[0080] Step A122, when the total amount of the single clearing transaction is consistent with the total amount of the single clearing transaction of the large-value payment, and the total amount of the batch clearing transaction is consistent with the total amount of the batch clearing transaction of the large-value payment, and the total amount of the clearing debit amount is consistent with the total amount of the clearing credit amount, determining that the first business total amount is consistent with the second business total amount;
[0081] It is understandable that since the clearing accounts from the National Commercial Bank of China need to be reconciled with the large-value payment clearing accounts from the People's Bank of China, as well as the clearing debit accounts and the clearing credit accounts within the bank during the bank reconciliation process, step A122 is performed to provide a method for effectively reconciling the clearing accounts from the National Commercial Bank of China with the large-value payment clearing accounts from the People's Bank of China, as well as the clearing debit accounts and the clearing credit accounts within the bank.
[0082] Step A123, when the total amount of the single settlement amount is inconsistent with the total amount of the single settlement amount of the large-value payment, the total amount of the batch settlement amount is inconsistent with the total amount of the batch settlement amount of the large-value payment, the total amount of the settlement debit amount is inconsistent with the total amount of the settlement credit amount, it is determined that the first business total amount is inconsistent with the second business total amount.
[0083] It is understandable that since there may be problems with the reconciliation of clearing accounts from the National Commercial Bank of China and large-value payment clearing accounts from the People's Bank of China, as well as clearing debit accounts within the bank and clearing credit accounts within the bank during the bank reconciliation process, step A123 is performed to provide a method for determining whether there is a reconciliation inconsistency between the clearing accounts from the National Commercial Bank of China and large-value payment clearing accounts from the People's Bank of China, or between the clearing debit accounts within the bank and the clearing credit accounts within the bank.
[0084] In this embodiment, during the bank's business amount verification process, the total amounts under different settlement methods are compared respectively, and inconsistencies in the total amounts under different settlement methods are discovered in a timely manner, thereby ensuring the accuracy and consistency of the bank's business amount verification.
[0085] In another feasible implementation manner, the first total business volume includes the total number of business messages, and the second total business volume includes the number of message summaries, wherein the total number of business messages is the total number of messages sent by the summary information message, and the message summary data is the total number of messages on the bank side;
[0086] It should be noted that the summary information message refers to the 071 message sent by the National Commercial Bank of China to the bank.
[0087] The step of comparing the first total business volume with the second total business volume in step S12 may further include steps B121 to B123:
[0088] Step B121, comparing the total number of service messages with the total number of messages;
[0089] It is understandable that since there may be inconsistencies between the summary information message received from the Securities Exchange and the message data on the bank side during the bank reconciliation process, step B121 is performed to ensure the consistency of the total amount of messages from different sources by comparing the total amount of messages from different sources.
[0090] Step B122, when the total number of service messages is consistent with the message summary number, determining that the first service total amount is consistent with the second service total amount;
[0091] It is understandable that since the total number of messages from the Securities Exchange needs to be balanced with the total number of messages on the bank side during the bank reconciliation process, step B122 is performed to provide a method for effectively balancing the total number of messages from the Securities Exchange with the total number of messages on the bank side.
[0092] Step B123: When the total number of service messages is inconsistent with the aggregated message quantity, it is determined that the first total service quantity is inconsistent with the second total service quantity.
[0093] It is understandable that since there may be a problem of the total number of messages from the Securities Exchange and the total number of messages on the bank side not being equal during the bank reconciliation process, step B123 is performed to provide a method for determining whether the total number of messages from the Securities Exchange and the total number of messages on the bank side are not equal.
[0094] In this embodiment, during the bank's business quantity verification process, the total number of messages from the bill exchange is compared with the total number of messages on the bank side, and the inconsistency between the total number of messages from the bill exchange and the total number of messages on the bank side is discovered in a timely manner, thereby ensuring the accuracy and consistency of the bank's business quantity verification.
[0095] Step S13: when the first business total amount is inconsistent with the second business total amount, determining that the first business total amount is inconsistent with the second business total amount.
[0096] In this embodiment, by comparing the total business volume of reconciliation data from different sources, the accuracy of accounts can be quickly verified, the efficiency and accuracy of the reconciliation process are improved, and the smooth progress of financial transactions is ensured.
[0097] Step S20, when the first business total amount is not balanced with the second business total amount, obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and verifying the first reconciliation detail data and the second reconciliation detail data;
[0098] In a feasible implementation manner, the first business total amount includes a total amount of single clearing amount, a total amount of batch clearing amount and a total amount of clearing debit amount, and the second business total amount includes a total amount of single clearing amount of large-value payment, a total amount of batch clearing amount of large-value payment and a total amount of clearing credit amount;
[0099] The step of obtaining the first reconciliation detail data corresponding to the first reconciliation data and the second reconciliation detail data corresponding to the second reconciliation data in step S20 may include steps A201 to A202:
[0100] Step A201, taking the group whose total amount is inconsistent among the total amount of the single clearing amount and the total amount of the large-amount payment single clearing amount, the total amount of the batch clearing amount and the total amount of the large-amount payment batch clearing amount, and the total amount of the clearing debit amount and the total amount of the clearing credit amount as the target group;
[0101] It should be noted that the target group refers to the group whose total amounts are inconsistent among the three groups: the total amount of single settlement and the total amount of single settlement of large-value payments, the total amount of batch settlement and the total amount of batch settlement of large-value payments, and the total amount of settlement debit and the total amount of settlement credit.
[0102] Step A202, obtaining the first reconciliation detail data and the second reconciliation detail data based on the target group, wherein the first reconciliation detail data is the reconciliation detail data belonging to the first reconciliation data part in the target group, and the second reconciliation detail data is the reconciliation detail data belonging to the second reconciliation data part in the target group.
[0103] It should be noted that the first reconciliation detail data refers to the detailed reconciliation records belonging to the first reconciliation data part in the group where the total amount is inconsistent; the second reconciliation detail data refers to the detailed reconciliation records belonging to the second reconciliation data part in the group where the total amount is inconsistent.
[0104] In the present embodiment, by obtaining the reconciliation details of the unbalanced part when the total amount of some amounts is not reconciled during the bank's business amount reconciliation process, an accurate and effective data basis is provided for further reconciliation of the specific amount transaction records of the distribution, thereby avoiding unnecessary reconciliation process of all reconciliation details when the total amount of some amounts is not reconciled, and improving the bank's reconciliation efficiency and accuracy in the business amount reconciliation process.
[0105] In another feasible implementation manner, the first reconciliation data includes a summary information message, and the second reconciliation data includes bank message summary data. The step of obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data in step S20 may further include step B200:
[0106] Step B200, obtaining a summary detailed reply message corresponding to the summary information message and bank message detailed data corresponding to the bank message summary data.
[0107] It should be noted that the summary detailed reply message refers to the 073 message sent by the National Commercial Bank of China to the bank.
[0108] In this implementation, during the bank's business quantity verification process, when the total amount of messages is not balanced, the summary detailed reply message issued by the Securities Exchange and the detailed message data on the bank side are obtained, which provides an accurate and effective data basis for further verification of the specific message quantity, thereby improving the bank's reconciliation accuracy during the business quantity verification process.
[0109] In a feasible implementation manner, the step of verifying the first account reconciliation detail data and the second account reconciliation detail data in step S20 may include steps S21 to S23:
[0110] Step S21, comparing each first business item in the first account reconciliation detailed data with each second business item in the second account reconciliation detailed data one by one;
[0111] It should be noted that the first business item refers to the specific item recorded in the first reconciliation detail data, which may include the reply message in the summary detailed reply message, or include at least one of a single clearing amount, a batch clearing amount and a clearing debit amount. The present implementation does not specifically limit the type of the first business item; the second business item refers to the specific item recorded in the second reconciliation detail data, which may include the detailed business message in the bank business message, or include at least one of a single clearing amount for large-value payments, a batch clearing amount for large-value payments and a clearing credit amount. The present implementation does not specifically limit the type of the second business item.
[0112] It is understandable that, since there are often omissions in the account details during the actual reconciliation process, step S21 is performed to locate the specific differences in the account records by reconciling the specific accounts one by one, thereby avoiding account errors caused by inconsistent account records.
[0113] Step S22, when the first business items are consistent with the second business items, determining that the first reconciliation data and the second reconciliation data are balanced;
[0114] It is understandable that, since the reconciliation detail data from different sources need to be reconciled during the reconciliation process, step S22 is performed to provide an effective reconciliation method for reconciliation data from different sources.
[0115] Step S23: when any of the first business items is inconsistent with the second business items, it is determined that the first account reconciliation detail data is inconsistent with the second account reconciliation detail data.
[0116] It is understandable that, since the reconciliation details data from different sources may be unbalanced during the reconciliation process, step S23 is performed to provide an accurate and effective basis for determining whether the reconciliation details data from different sources are unbalanced.
[0117] In this implementation, by comparing each specific business item to determine whether the accounts are checked and balanced, the effect of accurate account checking is achieved.
[0118] Step S30, when the first reconciliation detail data and the second reconciliation detail data are not balanced after verification, determining the business detail difference part, adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part, and returning to execute the step of verifying the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data;
[0119] It should be noted that the difference in business details refers to the inconsistent data content between the first reconciliation details and the second reconciliation details; account adjustment refers to a means of adjusting the accounting records to resolve the inconsistencies found during the reconciliation process.
[0120] It is understandable that since there may be system processing errors, account record errors, etc. that may cause inconsistent reconciliation during the account recording process, step S30 is performed to ensure the accuracy and consistency of the account records by adjusting the account records based on the difference in business details, thereby preventing financial losses or other financial risks caused by account errors. At the same time, the business information of the accounts is rechecked after the adjustment, which further improves the accuracy and consistency of the account reconciliation. In addition, by determining the difference in business details, an effective correction basis is provided for correcting the unbalanced accounts, thereby improving the accuracy of correcting the business information accounts.
[0121] In a feasible implementation manner, the first reconciliation detail data includes at least one of a single clearing account, a batch clearing account, and a clearing debit account, and the second reconciliation detail data includes at least one of a large-amount payment clearing single account, a large-amount payment clearing batch account, and a clearing credit account;
[0122] It should be noted that a single clearing account refers to the account record generated by the bill exchange during a single clearing process, a batch clearing account refers to the account record generated by the bill exchange during a batch clearing process, a clearing debit account refers to the debit account record generated by the bank during the clearing process, a large-value payment clearing single account refers to a single account record generated by the People's Bank of China during the large-value payment clearing process, a large-value payment clearing batch account refers to the batch account record generated by the People's Bank of China during the large-value payment clearing process, and a clearing credit account refers to the credit account record generated by the bank during the clearing process.
[0123] The step of adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part in step S30 may include steps A31 to A32:
[0124] Step A31, when the first reconciliation detail data is the reconciliation party of the second reconciliation detail data, and the difference in the business details is any first business amount in the single settlement account and / or the batch settlement account, which is inconsistent with the corresponding second business amount in the large-value payment settlement single account and / or the large-value payment settlement batch account, the large-value payment settlement single account and / or the large-value payment settlement batch account corresponding to the second business amount shall be refunded and cleared.
[0125] It should be noted that the refund and clearing process refers to the refund and clearing of single large-value payment and clearing accounts and / or batch large-value payment and clearing accounts that are inconsistent in amount verification and are not bill businesses.
[0126] It can be understood that, since the first reconciliation detail data is the reconciliation party of the second reconciliation detail data, the second reconciliation detail data needs to be corrected to balance the accounts, so step A31 is performed. By returning and clearing the abnormal data in the second reconciliation detail data, the problem of unbalanced reconciliation caused by the abnormality of the second reconciliation detail data is avoided, and the effect of balancing reconciliation data from different sources is achieved.
[0127] Step A32, when the first reconciliation detail data and the second reconciliation detail data are reconciliation parties to each other, and the difference in the business details is any third business amount in the clearing debit account, which is inconsistent with the corresponding fourth business amount in the clearing credit account, a reconciliation exception signal is output based on the clearing debit account corresponding to the third business amount and the clearing credit account corresponding to the fourth business amount, and the adjustment data requested by the reconciliation exception signal is received.
[0128] It should be noted that the abnormal reconciliation signal refers to the signal used to prompt bank operators to contact the Securities Exchange and / or the People's Bank of China for abnormal processing, and the adjustment data refers to the information used to correct the reconciliation detail data that is inconsistent with the business amount verification.
[0129] It can be understood that, since in the case where the first reconciliation details and the second reconciliation details are used to refer to the reconciliation party, it is necessary to prompt the bank operator with the data of inconsistent business amount verification, so step A32 is performed, by outputting a reconciliation exception signal based on the account with inconsistent business amount verification, and receiving the adjustment data requested by the National Commercial Bank of China and / or the People's Bank of China through the reconciliation exception signal, thereby avoiding the problem of unbalanced reconciliation caused by the abnormality of the first reconciliation details and / or the second reconciliation details, and achieving the effect of balancing the reconciliation data from different sources.
[0130] In this embodiment, by using the refund and clearing method or outputting the abnormal reconciliation signal for the accounts with unbalanced amounts, the accuracy and consistency of the account amount records are further ensured, thereby preventing capital losses or other financial risks caused by incorrect account amounts.
[0131] In another feasible implementation manner, the step of adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part in step S30 may include steps B31 to B32:
[0132] Step B31, when the difference in the business details is that the target bank business message is missing in the second reconciliation details data, sending a reissue application signal to the clearing house to request the clearing house to reissue the target bank business message;
[0133] It should be noted that the target bank business message refers to the message that is found to exist in the first reconciliation detail data from the bill exchange during the verification process, but does not exist in the second reconciliation detail data from the bank side; the reissue application signal refers to the instruction used to request the bill exchange to reissue the bank business message.
[0134] It is understandable that due to the lack of business messages on the bank side, the business quantity verification may be unbalanced during the bank's business quantity verification process. Therefore, step B31 is performed to request the Clearing House to reissue the business message when the business quantity verification is unbalanced, thereby achieving the effect of balancing the bank's business quantity.
[0135] Step B32, when the difference in the business details is that the number of second messages in the second reconciliation detail data is greater than the number of first messages in the first reconciliation detail data, offsetting the messages in the second reconciliation detail data that are inconsistent with the first reconciliation detail data.
[0136] It should be noted that the offsetting process refers to a method of offsetting the messages in the second reconciliation detail data that are inconsistent with the first reconciliation detail data in the opposite direction.
[0137] It is understandable that, due to the extra business messages on the bank side, the business quantity verification may be unbalanced during the bank business quantity verification process. Therefore, step B32 is performed to offset the extra business messages when the business data verification is unbalanced, thereby achieving the effect of balancing the bank's business quantity.
[0138] In this implementation, by requesting reissue or offset for accounts with unbalanced quantities, the accuracy and consistency of account quantity records are further ensured, thereby preventing capital losses or other financial risks caused by incorrect account quantities.
[0139] Step S40: when the first reconciliation detailed data and the second reconciliation detailed data are checked and balanced, determining that the first reconciliation data and the second reconciliation data are balanced.
[0140] It is understandable that, since balanced reconciliation data is required after the reconciliation process is completed, step S40 is performed to confirm the balance of the business information when the detailed data is checked and balanced, thereby ensuring the balance of the business information after the reconciliation process is executed.
[0141] This embodiment provides a reconciliation method, which uses a step-by-step verification method with granularity ranging from coarse to fine to verify the total business volume and business detail data of the first reconciliation data and the second reconciliation data in turn, and adjusts and rechecks the details when the details are not balanced, thereby meeting the requirements of common and strong standardized reconciliation of different business information.
[0142] In a feasible implementation manner, the first business item includes at least one of a single settlement amount, a batch settlement amount, and a settlement debit amount, and the second business item includes at least one of a large-amount payment single settlement amount, a large-amount payment batch settlement amount, and a settlement credit amount;
[0143] It should be noted that the single clearing amount refers to the transaction amount of each individual clearing in the process of a single clearing by the bill exchange; the batch clearing amount refers to the total amount of multiple transactions cleared in the process of batch clearing by the bill exchange; the clearing debit amount refers to the amount deducted from the bank account by the bank during the clearing process; the large-value payment single clearing amount refers to the single transaction amount involved in the large-value payment clearing process by the People's Bank of China; the large-value payment batch clearing amount refers to the total amount of multiple transactions cleared in the process of large-value payment by the People's Bank of China; the clearing credit amount refers to the amount added to the bank account by the bank during the clearing process.
[0144] Step S21 may include steps A211 to A213:
[0145] Step A211, comparing each of the first business items with each of the second business items one by one based on each clearing and delivery order number, wherein the clearing and delivery order number is an identifier shared by the account corresponding to the single clearing amount and the account corresponding to the single clearing amount of the large-amount payment, or the account corresponding to the batch clearing amount and the account corresponding to the batch clearing amount of the large-amount payment, or the account corresponding to the clearing debit amount and the account corresponding to the clearing credit amount;
[0146] It should be noted that the clearing delivery note number refers to a unique identifier generated during the clearing process, which is used to track and verify the clearing results.
[0147] It is understandable that since errors often occur in the details of the account amounts during the bank's business amount verification process, step A211 is performed to locate specific differences in the account amount records by verifying the specific account amounts one by one, thereby avoiding account errors caused by inconsistent account amount records.
[0148] Step A212: when the first business item and the second business item corresponding to any clearing and delivery order number are consistent, determining that the first business items are consistent with the second business items;
[0149] It is understandable that since the business items from different sources corresponding to the same clearing and delivery order number need to be balanced during the bank's business amount verification process, step A212 is performed to provide an effective judgment method for determining whether the business items from different sources corresponding to the same clearing and delivery order number are balanced.
[0150] Step A213: when the first business item and the second business item corresponding to any clearing and delivery order number are inconsistent, determine that the first business items are inconsistent with any of the second business items.
[0151] It is understandable that since there may be a problem of uneven reconciliation of business items from different sources corresponding to the same clearing and delivery order number during the bank's business amount reconciliation process, step A213 is performed to provide an effective judgment method for determining whether business items from different sources corresponding to the same clearing and delivery order number are unevenly reconciled.
[0152] In this implementation, business items from different sources are compared one by one through the clearing and delivery order number, thereby avoiding accounting errors caused by inconsistencies in specific amount transaction items in the account amount records, and ensuring the accuracy and consistency of the account amount records.
[0153] In another feasible implementation manner, each of the first business items includes each reply message in the summary detailed reply message, and each of the second business items includes each detailed business message in the banking business message;
[0154] It should be noted that each reply message refers to each specific message in the summary detailed reply message, and each detailed business message refers to each specific message in the banking business message.
[0155] Step S21 may include steps B211 to B212:
[0156] Step B211, comparing each reply message with each detailed business message one by one, and when each reply message is consistent with each detailed business message, determining that each first business item is consistent with each second business item;
[0157] It is understandable that since the number of messages of reconciliation data from different sources needs to be balanced during the bank's business quantity verification process, step B211 is performed to provide an effective judgment method for determining whether the number of messages of reconciliation data from different sources is balanced.
[0158] Step B212: When any reply message in the reply messages is inconsistent with the detailed business message corresponding to the reply message, it is determined that the first business items are inconsistent with any item in the second business items.
[0159] It is understandable that, since there may be a problem of uneven verification of the number of messages of reconciliation data from different sources during the bank's business quantity verification process, step B212 is performed to provide an effective judgment method for determining whether the number of messages of reconciliation data from different sources is uneven.
[0160] In this implementation, by comparing the message quantities of reconciliation data from different sources one by one, accounting errors caused by inconsistency in specific message quantities in the account quantity records are avoided, thereby ensuring the accuracy and consistency of the account quantity records.
[0161] Based on the first embodiment of the present application, in the second embodiment of the present application, the same or similar contents as those in the above-mentioned embodiment 1 can be referred to the above introduction, and will not be repeated in the following. Figure 2 , Figure 2 This is a flow chart of the second embodiment of the reconciliation method of the present application.
[0162] After step S40, the reconciliation method further includes step S41:
[0163] Step S41: Posting the first reconciliation data and the second reconciliation data.
[0164] It should be noted that process processing refers to the process of formally recording the verified accounts into the account books. This process ensures the formality and completeness of the accounting records and provides an effective data basis for subsequent financial reports and audits.
[0165] Exemplarily, the first reconciliation data and the second reconciliation data verified by each bank branch are posted to the head office account, and the branch account balance is zero. Since the settlement amount has been reconciled, after the branch account balances are added to the head office account, the head office account balance is also zero.
[0166] In this embodiment, the checked and balanced reconciliation data is processed for posting, which ensures the complete execution of the reconciliation process and the smooth progress of the financial transaction.
[0167] For example, to help understand the implementation process of the reconciliation method obtained by combining this embodiment with the above-mentioned embodiment 1, please refer to Figure 3 , Figure 3 A brief flow chart of a reconciliation method is provided, specifically:
[0168] First, upon receiving TGR (trigger) data, such as the first reconciliation data and the second reconciliation data, perform PRE (prepare) reconciliation preparation. After preparing the first reconciliation data and the second reconciliation data to be reconciled, perform SCK (Summary Check), that is, check the first business volume of the first reconciliation data and the second business volume of the second reconciliation data. When the check is completed, the first reconciliation data and the second reconciliation data are balanced, and perform ACC (Account), that is, post the first reconciliation data and the second reconciliation data. When the check is not completed, that is, the check is not balanced, perform DCK (Detailed Check). Check (detailed check) detailed check, that is, checking the first reconciliation detailed data and the second reconciliation detailed data. When the check is completed, that is, the first reconciliation data and the second reconciliation data are determined to be balanced, and ACC posting is performed; when the check is not completed, that is, the check is not balanced, ADJ (Adjustment) detailed adjustment is performed, and after the detailed adjustment is completed, the check is triggered again, that is, the step of checking the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data is returned to execute; when the detailed adjustment does not need to be adjusted, after manual forced balance is performed, ACC posting is performed. After ACC posts, the verification is completed. The dotted arrow in the figure indicates that when the reconciliation data to be verified is the message quantity, the clearing amount verification is performed, that is, when the first reconciliation data to be verified is the business summary data issued by the 071 summary information message, and the second reconciliation data is the message summary data on the bank side, and the accounts of the first reconciliation data and the second reconciliation data are balanced, the first reconciliation data is the clearing debit account within the bank and the clearing data issued by the Clearing House through the clearing notification message, and the second reconciliation data is the clearing credit account within the bank and the account data of the large-amount payment message of the People's Bank of China. Through the verification process of first verifying the business quantity and then verifying the business amount, it is avoided to perform complicated business amount verification when the business quantity is inconsistent, and the verification accuracy and efficiency of the reconciliation process are improved.
[0169] For further information, please refer to Figure 4 , Figure 4 A detailed flowchart of a reconciliation method is provided, specifically:
[0170] Upon receiving TGR (trigger) data, i.e., the summary information message sent by the ticket exchange, the reconciliation process is triggered. In the reconciliation process, PRE reconciliation preparation is first performed. In the first round of reconciliation, the message quantity is checked first, i.e., the preparation of the ticket exchange message summary data and the bank-side message summary data represented by PRE 1 in the figure, and then the SCK summary check is performed, i.e., the verification of the message summary data of the ticket exchange and the bank-side represented by SCK 1 in the figure. If the verification is successful, ACC posting is performed, i.e., there is no processing logic for message reconciliation in this stage represented by ACC 1 in the figure; if the verification is unsuccessful, DCK detailed check is performed, i.e., the preparation of the ticket exchange message detailed data represented by DCK 1 in the figure, the verification of the message detailed data of the ticket exchange and the bank-side, and if the verification is successful, ACC posting is performed; if the verification is unsuccessful, ADJ detailed adjustment is performed, i.e., ADJ in the figure 1 indicates the reason for the imbalance in the analysis and reconciliation. If it is necessary to apply to the Clearing House for reissue of the missing messages on the bank side, the extra messages on the bank side will be offset. After the adjustment is completed, the data will be re-prepared for reconciliation. If it is not necessary to apply for reissue, the ACC will be posted after manual forced reconciliation. After ACC posting, the verification is completed, that is, the message quantity verification is completed at this time, triggering the clearing amount verification. In the process of clearing amount verification, PRE reconciliation preparation is first performed, that is, PRE 2 in the figure indicates the preparation of the account data of the clearing notice of the ticket exchange and the large-value payment message of the People's Bank, and then SCK summary verification is performed, that is, SCK 2 in the figure indicates the parallel amount data summary of six types of tasks such as single clearing of the ticket exchange and single clearing of large-value payment of the People's Bank, and then the verification is caught. In the case of successful verification, enter ACC posting, that is, ACC 2 in the figure indicates that the accounts of each branch are posted to the head office account, and the branch account balance is zero. Since the previous steps have balanced the clearing amount, after the branch accounts are piled up to the head office account, the head office account balance is also zero, and the clearing amount verification process is completed; in the case of unsuccessful verification, enter DCK detailed verification, that is, DCK in the figure 2 indicates that the clearing and delivery order number is used to check the clearing account of the ticket exchange and the large-amount payment account of the People's Bank of China one by one. The internal clearing of the bank checks the internal accounts one by one according to the delivery order number. If the check is successful, enter ACC for posting; if the check is unsuccessful, enter ADJ detailed account adjustment, that is, ADJ 2 in the figure indicates the analysis of the reasons for the unbalanced check. If there are many large-amount payment accounts of the People's Bank of China and they are not bill business, payment return and clearing will be processed; in other cases, the ticket exchange and the People's Bank of China need to be contacted for abnormal processing. After the adjustment is completed, the data is re-prepared for reconciliation. After ACC is posted, the check is completed, thus completing the entire reconciliation process.
[0171] It should be noted that the above examples are only used to understand the present application and do not constitute a limitation on the reconciliation method of the present application. More simple transformations based on this technical concept are all within the scope of protection of the present application.
[0172] This application also provides a reconciliation device, please refer to Figure 5 , the reconciliation device comprises:
[0173] A summary and verification module 10 is used to obtain first reconciliation data and second reconciliation data, and to verify a first business volume of the first reconciliation data and a second business volume of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases;
[0174] A detail checking module 20, configured to obtain first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and check the first reconciliation detail data and the second reconciliation detail data when the first business total amount is not balanced with the second business total amount;
[0175] A detailed reconciliation module 30 is used to determine a business detail difference when the first reconciliation detailed data and the second reconciliation detailed data are not balanced after reconciliation, adjust the first reconciliation detailed data and / or the second reconciliation detailed data according to the business detail difference, and return to execute the step of reconciling the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data;
[0176] The reconciliation completion module 40 is used to determine that the first reconciliation data and the second reconciliation data are reconciled when the first reconciliation detailed data and the second reconciliation detailed data are reconciled.
[0177] Optionally, the summary and verification module 10 is further used for:
[0178] Aggregating the first reconciliation data to obtain the first business volume, and aggregating the second reconciliation data to obtain the second business volume;
[0179] Comparing the first business total volume with the second business total volume, and determining that the first reconciliation data and the second reconciliation data are balanced when the first business total volume is consistent with the second business total volume;
[0180] When the first business total amount is inconsistent with the second business total amount, it is determined that the first business total amount is not equal to the second business total amount.
[0181] Optionally, the first business total includes a total single clearing amount, a total batch clearing amount and a total clearing debit amount, and the second business total includes a total single clearing amount of large-value payments, a total batch clearing amount of large-value payments and a total clearing credit amount;
[0182] The summary checking module 10 is also used for:
[0183] Compare the total amount of the single clearing amount with the total amount of the single clearing amount of the large-amount payment, the total amount of the batch clearing amount with the total amount of the batch clearing amount of the large-amount payment, and the total amount of the clearing debit amount with the total amount of the clearing credit amount one by one;
[0184] In the case where the total amount of the single clearing transaction is consistent with the total amount of the single clearing transaction of the large-value payment, the total amount of the batch clearing transaction is consistent with the total amount of the batch clearing transaction of the large-value payment, and the total amount of the clearing debit amount is consistent with the total amount of the clearing credit amount, it is determined that the first business total amount is consistent with the second business total amount;
[0185] When the total amount of the single settlement amount is inconsistent with the total amount of the single settlement amount of the large-value payment, the total amount of the batch settlement amount is inconsistent with the total amount of the batch settlement amount of the large-value payment, and the total amount of the settlement debit amount is inconsistent with the total amount of the settlement credit amount, it is determined that the first business total amount is inconsistent with the second business total amount.
[0186] Optionally, the first business total includes a total single clearing amount, a total batch clearing amount and a total clearing debit amount, and the second business total includes a total single clearing amount of large-value payments, a total batch clearing amount of large-value payments and a total clearing credit amount;
[0187] The detailed checking module 20 is also used for:
[0188] The group whose total amount is inconsistent among the total amount of the single clearing amount and the total amount of the large-amount payment single clearing amount, the total amount of the batch clearing amount and the total amount of the large-amount payment batch clearing amount, and the total amount of the clearing debit amount and the total amount of the clearing credit amount is taken as the target group;
[0189] The first reconciliation detail data and the second reconciliation detail data are obtained based on the target group, wherein the first reconciliation detail data is the reconciliation detail data belonging to the first reconciliation data part in the target group, and the second reconciliation detail data is the reconciliation detail data belonging to the second reconciliation data part in the target group.
[0190] Optionally, the detail checking module 20 is further used for:
[0191] Compare each first business item in the first account reconciliation detailed data with each second business item in the second account reconciliation detailed data one by one;
[0192] When the first business items are consistent with the second business items, determining that the first reconciliation data and the second reconciliation data are balanced;
[0193] When any of the first business items is inconsistent with the second business items, it is determined that the first account reconciliation detailed data is not balanced with the second account reconciliation detailed data.
[0194] Optionally, the first business item includes at least one of a single settlement amount, a batch settlement amount and a settlement debit amount, and the second business item includes at least one of a large-value payment single settlement amount, a large-value payment batch settlement amount and a settlement credit amount;
[0195] The detailed checking module 20 is also used for:
[0196] The first business items are compared with the second business items one by one based on the clearing and delivery order numbers, wherein the clearing and delivery order number is an identifier shared by the account corresponding to the single clearing amount and the account corresponding to the single clearing amount of the large-amount payment, or the account corresponding to the batch clearing amount and the account corresponding to the batch clearing amount of the large-amount payment, or the account corresponding to the clearing debit amount and the account corresponding to the clearing credit amount;
[0197] When the first business item and the second business item corresponding to any clearing and delivery order number are consistent, determining that the first business items are consistent with the second business items;
[0198] In the case where the first business item and the second business item corresponding to any clearing and delivery order number are inconsistent, it is determined that the first business items are inconsistent with any of the second business items.
[0199] Optionally, the first reconciliation detail data includes at least one of a single clearing account, a batch clearing account, and a clearing debit account, and the second reconciliation detail data includes at least one of a large-value payment clearing single account, a large-value payment clearing batch account, and a clearing credit account;
[0200] The detailed account adjustment module 30 is also used for:
[0201] In the case where the first reconciliation detail data is the reconciliation party of the second reconciliation detail data, and the difference in the business details is any first business amount in the single settlement account and / or the batch settlement account, which is inconsistent with the corresponding second business amount in the single large-value payment settlement account and / or the batch large-value payment settlement account, the single large-value payment settlement account and / or the batch large-value payment settlement account corresponding to the second business amount shall be refunded and cleared;
[0202] When the first reconciliation detail data and the second reconciliation detail data are reconciliation parties to each other, and the difference in the business details is any third business amount in the clearing debit account, which is inconsistent with the corresponding fourth business amount in the clearing credit account, a reconciliation exception signal is output based on the clearing debit account corresponding to the third business amount and the clearing credit account corresponding to the fourth business amount, and the adjustment data requested by the reconciliation exception signal is received.
[0203] Optionally, the reconciliation completion module 40 is further used for:
[0204] Posting the first reconciliation data and the second reconciliation data.
[0205] The reconciliation device provided by the present application adopts the reconciliation method in the above embodiment, which can solve the technical problem of how to implement a highly universal standardized reconciliation method for different business information. Compared with the prior art, the beneficial effects of the reconciliation device provided by the present application are the same as the beneficial effects of the reconciliation method provided by the above embodiment, and the other technical features in the reconciliation device are the same as the features disclosed in the above embodiment method, which will not be repeated here.
[0206] The present application provides an electronic device, which includes: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the reconciliation method in the above-mentioned embodiment 1.
[0207] Reference below Figure 6 , which shows a schematic diagram of the structure of an electronic device suitable for implementing the embodiments of the present application. The electronic devices in the embodiments of the present application may include but are not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Portable Application Descriptions), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 6 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.
[0208] like Figure 6As shown, the electronic device may include a processing device 1001 (e.g., a central processing unit, a graphics processor, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM: Read Only Memory) 1002 or a program loaded from a storage device 1003 to a random access memory (RAM: Random Access Memory) 1004. In RAM1004, various programs and data required for the operation of the electronic device are also stored. The processing device 1001, ROM1002, and RAM1004 are connected to each other through a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Generally, the following systems can be connected to the I / O interface 1006: an input device 1007 including, for example, a touch screen, a touch pad, a keyboard, a mouse, an image sensor, a microphone, an accelerometer, a gyroscope, etc.; an output device 1008 including, for example, a liquid crystal display (LCD: Liquid Crystal Display), a speaker, a vibrator, etc.; a storage device 1003 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 1009. The communication device 1009 can allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows an electronic device with various systems, it should be understood that it is not required to implement or have all the systems shown. More or fewer systems can be implemented or have alternatively.
[0209] In particular, according to the embodiments disclosed in the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device, or installed from a storage device 1003, or installed from a ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the method of the embodiment disclosed in the present application are executed.
[0210] The electronic device provided by the present application adopts the reconciliation method in the above embodiment, which can solve the technical problem of how to implement a highly universal standardized reconciliation method for different business information. Compared with the prior art, the beneficial effects of the electronic device provided by the present application are the same as the beneficial effects of the reconciliation method provided by the above embodiment, and the other technical features in the electronic device are the same as the features disclosed in the method of the previous embodiment, which will not be repeated here.
[0211] It should be understood that the various parts disclosed in this application can be implemented by hardware, software, firmware or a combination thereof. In the description of the above embodiments, specific features, structures, materials or characteristics can be combined in any one or more embodiments or examples in a suitable manner.
[0212] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.
[0213] The present application provides a computer-readable storage medium having computer-readable program instructions (ie, computer programs) stored thereon, and the computer-readable program instructions are used to execute the reconciliation method in the above-mentioned embodiment.
[0214] The computer-readable storage medium provided in the present application may be, for example, a USB flash drive, but is not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems or devices, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM: Random Access Memory), a read-only memory (ROM: Read Only Memory), an erasable programmable read-only memory (EPROM: Erasable Programmable Read Only Memory or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM: CD-Read Only Memory), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (Radio Frequency: Radio Frequency), etc., or any suitable combination of the above.
[0215] The computer-readable storage medium may be included in the electronic device, or may exist independently without being installed in the electronic device.
[0216] The computer-readable storage medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: obtains the first reconciliation data and the second reconciliation data, and checks the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases; when the first business total amount is not balanced with the second business total amount, obtains the first reconciliation detail data corresponding to the first reconciliation data and the second reconciliation detail data corresponding to the second reconciliation data, and checks the first reconciliation detail data and the second reconciliation detail data; when the first reconciliation detail data and the second reconciliation detail data are not balanced, determines the business detail difference part, adjusts the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part, and returns to execute the step of checking the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data; when the first reconciliation detail data and the second reconciliation detail data are balanced after checking, determines the account balance of the first reconciliation data and the second reconciliation data.
[0217] Computer program code for performing the operations of the present application may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0218] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0219] The modules involved in the embodiments described in this application may be implemented by software or hardware, wherein the name of the module does not constitute a limitation on the unit itself in some cases.
[0220] The readable storage medium provided in the present application is a computer-readable storage medium, which stores computer-readable program instructions (i.e., computer programs) for executing the above-mentioned reconciliation method, and can solve the technical problem of how to implement a highly versatile standardized reconciliation method for different business information. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in the present application are the same as the beneficial effects of the reconciliation method provided in the above-mentioned embodiment, and will not be elaborated here.
[0221] The present application also provides a computer program product, including a computer program, which implements the steps of the above-mentioned reconciliation method when executed by a processor.
[0222] The computer program product provided by the present application can solve the technical problem of how to implement a highly universal standardized reconciliation method for different business information. Compared with the prior art, the beneficial effects of the computer program product provided by the present application are the same as the beneficial effects of the reconciliation method provided by the above embodiment, which will not be repeated here.
[0223] The above descriptions are only some embodiments of the present application, and are not intended to limit the patent scope of the present application. All equivalent structural changes made using the contents of the present application specification and drawings under the technical concept of the present application, or direct / indirect applications in other related technical fields are included in the patent protection scope of the present application.
Claims
1. A reconciliation method, characterized in that: The reconciliation method includes: Acquire first reconciliation data and second reconciliation data, and verify a first business volume of the first reconciliation data and a second business volume of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases; When the first business total amount is not balanced with the second business total amount, obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and verifying the first reconciliation detail data and the second reconciliation detail data; In the case that the first reconciliation detail data and the second reconciliation detail data are not balanced after verification, determining a business detail difference portion, adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference portion, and returning to execute the step of verifying the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data; When the first reconciliation detailed data and the second reconciliation detailed data are checked and balanced, it is determined that the first reconciliation data and the second reconciliation data are balanced.
2. The reconciliation method according to claim 1, characterized in that: The step of checking the first business volume of the first reconciliation data and the second business volume of the second reconciliation data comprises: Aggregating the first reconciliation data to obtain the first business volume, and aggregating the second reconciliation data to obtain the second business volume; Comparing the first business total volume with the second business total volume, and determining that the first reconciliation data and the second reconciliation data are balanced when the first business total volume is consistent with the second business total volume; When the first business total amount is inconsistent with the second business total amount, it is determined that the first business total amount is not equal to the second business total amount.
3. The reconciliation method according to claim 2, characterized in that: The first business total includes the total amount of single clearing, the total amount of batch clearing and the total amount of clearing debits; the second business total includes the total amount of single clearing for large-value payments, the total amount of batch clearing for large-value payments and the total amount of clearing credits; The step of comparing the first total business volume with the second total business volume comprises: Compare the total amount of the single clearing amount with the total amount of the single clearing amount of the large-amount payment, the total amount of the batch clearing amount with the total amount of the batch clearing amount of the large-amount payment, and the total amount of the clearing debit amount with the total amount of the clearing credit amount one by one; In the case where the total amount of the single clearing transaction is consistent with the total amount of the single clearing transaction of the large-value payment, the total amount of the batch clearing transaction is consistent with the total amount of the batch clearing transaction of the large-value payment, and the total amount of the clearing debit amount is consistent with the total amount of the clearing credit amount, it is determined that the first business total amount is consistent with the second business total amount; When the total amount of the single settlement amount is inconsistent with the total amount of the single settlement amount of the large-value payment, the total amount of the batch settlement amount is inconsistent with the total amount of the batch settlement amount of the large-value payment, and the total amount of the settlement debit amount is inconsistent with the total amount of the settlement credit amount, it is determined that the first business total amount is inconsistent with the second business total amount.
4. The reconciliation method according to claim 1, characterized in that: The first business total includes the total amount of single clearing, the total amount of batch clearing and the total amount of clearing debits; the second business total includes the total amount of single clearing for large-value payments, the total amount of batch clearing for large-value payments and the total amount of clearing credits; The step of obtaining first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data includes: The group whose total amount is inconsistent among the total amount of the single clearing amount and the total amount of the large-amount payment single clearing amount, the total amount of the batch clearing amount and the total amount of the large-amount payment batch clearing amount, and the total amount of the clearing debit amount and the total amount of the clearing credit amount is taken as the target group; The first reconciliation detail data and the second reconciliation detail data are obtained based on the target group, wherein the first reconciliation detail data is the reconciliation detail data belonging to the first reconciliation data part in the target group, and the second reconciliation detail data is the reconciliation detail data belonging to the second reconciliation data part in the target group.
5. The reconciliation method according to claim 1, characterized in that: The step of checking the first account reconciliation detail data and the second account reconciliation detail data comprises: Comparing each first business item in the first account reconciliation detailed data with each second business item in the second account reconciliation detailed data one by one; When the first business items are consistent with the second business items, determining that the first reconciliation data and the second reconciliation data are balanced; When any of the first business items is inconsistent with the second business items, it is determined that the first account reconciliation detailed data is not balanced with the second account reconciliation detailed data.
6. The reconciliation method according to claim 5, characterized in that: The first business item includes at least one of a single settlement amount, a batch settlement amount, and a settlement debit amount, and the second business item includes at least one of a large-value payment single settlement amount, a large-value payment batch settlement amount, and a settlement credit amount; The step of comparing each first business item in the first account reconciliation detailed data with each second business item in the second account reconciliation detailed data one by one comprises: The first business items are compared with the second business items one by one based on the clearing and delivery order numbers, wherein the clearing and delivery order number is an identifier shared by the account corresponding to the single clearing amount and the account corresponding to the single clearing amount of the large-amount payment, or the account corresponding to the batch clearing amount and the account corresponding to the batch clearing amount of the large-amount payment, or the account corresponding to the clearing debit amount and the account corresponding to the clearing credit amount; When the first business item and the second business item corresponding to any clearing and delivery order number are consistent, determining that the first business items are consistent with the second business items; In the case where the first business item and the second business item corresponding to any clearing and delivery order number are inconsistent, it is determined that the first business items are inconsistent with any of the second business items.
7. The reconciliation method according to claim 1, characterized in that: The first reconciliation detail data includes at least one of a single clearing account, a batch clearing account, and a clearing debit account, and the second reconciliation detail data includes at least one of a large-value payment clearing single account, a large-value payment clearing batch account, and a clearing credit account; The step of adjusting the first reconciliation detail data and / or the second reconciliation detail data according to the business detail difference part includes: In the case where the first reconciliation detail data is the reconciliation party of the second reconciliation detail data, and the difference in the business details is any first business amount in the single settlement account and / or the batch settlement account, which is inconsistent with the corresponding second business amount in the single large-value payment settlement account and / or the batch large-value payment settlement account, the single large-value payment settlement account and / or the batch large-value payment settlement account corresponding to the second business amount shall be refunded and cleared; When the first reconciliation detail data and the second reconciliation detail data are reconciliation parties to each other, and the difference in the business details is any third business amount in the clearing debit account, which is inconsistent with the corresponding fourth business amount in the clearing credit account, a reconciliation exception signal is output based on the clearing debit account corresponding to the third business amount and the clearing credit account corresponding to the fourth business amount, and the adjustment data requested by the reconciliation exception signal is received.
8. A reconciliation device, characterized in that: The reconciliation device comprises: a summary and verification module, configured to obtain first reconciliation data and second reconciliation data, and verify a first business volume of the first reconciliation data and a second business volume of the second reconciliation data, wherein the first reconciliation data and the second reconciliation data are in different account databases; a detail checking module, configured to obtain first reconciliation detail data corresponding to the first reconciliation data and second reconciliation detail data corresponding to the second reconciliation data, and check the first reconciliation detail data and the second reconciliation detail data when the first business total amount is not balanced with the second business total amount; a detailed reconciliation module, configured to determine a business detail difference portion when the first reconciliation detailed data and the second reconciliation detailed data are not balanced after reconciliation, reconcile the first reconciliation detailed data and / or the second reconciliation detailed data according to the business detail difference portion, and return to execute the step of reconciling the first business total amount of the first reconciliation data and the second business total amount of the second reconciliation data; The reconciliation completion module is used to determine that the first reconciliation data and the second reconciliation data are reconciled when the first reconciliation detailed data and the second reconciliation detailed data are reconciled.
9. An electronic device, characterized in that: The device comprises: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the reconciliation method according to any one of claims 1 to 7.
10. A storage medium, characterized in that: The storage medium is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the reconciliation method according to any one of claims 1 to 7 are implemented.
