Reconciliation method and device, electronic equipment and storage medium

Abstract

The invention provides an account checking method and device, electronic equipment and a storage medium, and relates to the technical field of financial account checking. The reconciliation method comprises the steps that target reconciliation data corresponding to each reconciliation subject is acquired, the target reconciliation data comprises data of reconciliation subjects and reconciliation auxiliary items, the reconciliation subjects and the reconciliation auxiliary items have a corresponding relation, and the reconciliation auxiliary items are used for carrying out auxiliary accounting on the corresponding reconciliation subjects; and performing account checking according to the target account checking data corresponding to each account checking main body to obtain an account checking result. According to the method, the accuracy of the obtained account checking data is ensured, so that the accuracy of account checking in a complex scene is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of financial reconciliation, and in particular to a reconciliation method, device, electronic equipment and storage medium. Background Art

[0002] Reconciliation is a very important task, which involves the flow and use of funds and is an indispensable part of a company's financial management. First of all, through a reasonable reconciliation cycle, voucher collection, reconciliation process, exception handling and data update, the accuracy and authenticity of financial data can be ensured. Secondly, internal reconciliation is to check the current business of different accounting entities. When there is a discrepancy, the reason is checked in time. It is a key link and important measure to avoid operational risks and prevent cases.

[0003] Existing reconciliation solutions generally compare single data items. Due to the simple rules, the reconciliation accuracy in complex scenarios is low. Summary of the invention

[0004] The present invention provides a reconciliation method, device, electronic device and storage medium, which are used to solve the defect of low reconciliation accuracy of reconciliation solutions in the prior art. The method of reconciliation using combined data of reconciliation subjects and reconciliation auxiliary items ensures the accuracy of the obtained reconciliation data, thereby improving the accuracy of reconciliation in complex scenarios.

[0005] The present invention provides a reconciliation method, comprising the following steps: Obtaining target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects have a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items are used to perform auxiliary accounting on the corresponding reconciliation subjects; Reconciliation is performed according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0006] According to a reconciliation method provided by the present invention, the step of obtaining target reconciliation data corresponding to each reconciliation subject includes: Acquire reconciliation configuration information, wherein the reconciliation configuration information includes information of each configured reconciliation subject, the reconciliation account corresponding to each reconciliation subject, and the corresponding reconciliation auxiliary items under each reconciliation account; The balance and voucher entry details of the corresponding auxiliary reconciliation items under the reconciliation subjects corresponding to the respective reconciliation entities are obtained according to the reconciliation configuration information to obtain the target reconciliation data corresponding to the respective reconciliation entities.

[0007] According to a reconciliation method provided by the present invention, the target reconciliation data corresponding to each reconciliation subject includes a plurality of detailed business data. After acquiring the balance and voucher entry details of the corresponding reconciliation auxiliary items under the reconciliation subjects corresponding to each reconciliation subject according to the reconciliation configuration information and obtaining the target reconciliation data corresponding to each reconciliation subject, the method further includes: The target reconciliation data corresponding to each reconciliation subject is stored in a table according to a first dimension of each detailed business data, and when storing in each table, the target reconciliation data is partitioned and stored according to a second dimension of each detailed business data, wherein the first dimension is used to represent a business date, and the second dimension is used to represent a business object.

[0008] According to a reconciliation method provided by the present invention, reconciliation is performed according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result, including: Obtaining a target reconciliation scheme, the target reconciliation scheme comprising at least one configured reconciliation scheme and execution logic corresponding to the at least one reconciliation scheme, the execution logic corresponding to the at least one reconciliation scheme being used to indicate an execution order and / or a triggering condition of each reconciliation scheme, and each reconciliation scheme in the at least one reconciliation scheme adopting at least one reconciliation method selected from one-to-one data comparison, one-to-many data comparison, many-to-many data comparison, and self-data comparison; Reconciliation is performed according to the target reconciliation scheme and the target reconciliation data corresponding to each reconciliation subject to obtain the reconciliation result.

[0009] According to a reconciliation method provided by the present invention, the at least one reconciliation scheme includes a first reconciliation scheme, a second reconciliation scheme and a third reconciliation scheme, the reconciliation success condition of the first reconciliation scheme is that the amount of a single item is equal, the reconciliation success condition of the second reconciliation scheme is that the sum of the amounts of multiple items is equal to the amount of the single item, and the reconciliation success condition of the third reconciliation scheme is that the sum of the amounts of its own items is equal to zero, and the execution logic corresponding to the at least one reconciliation scheme is a binary tree, the root node of the binary tree is the first reconciliation scheme, the first-level child node of the binary tree is the second reconciliation scheme, and the second-level child node of the binary tree is the third reconciliation scheme.

[0010] According to a reconciliation method provided by the present invention, the reconciliation detail tables corresponding to the reconciliation subjects include a first reconciliation detail table corresponding to the first reconciliation subject and a second reconciliation detail table corresponding to the second reconciliation subject, and reconciliation is performed according to the target reconciliation scheme and the target reconciliation data corresponding to the reconciliation subjects to obtain the reconciliation result, including: Performing reconciliation starting from the root node according to the first reconciliation detail table and the second reconciliation detail table; Trigger the first reconciliation plan, traverse the amount of each item in the first reconciliation details table, and perform a single comparison with the amount of each item in the second reconciliation details table to determine whether the amounts are equal, and determine the first successfully matched item and the first unmatched item in the first reconciliation details table, as well as the first successfully matched item and the first unmatched item in the second reconciliation details table; When the execution of the first reconciliation plan is completed, the second reconciliation plan is triggered, the first unmatched successful entry in the first reconciliation details table is traversed, and the value obtained by adding the amounts of at least two unmatched successful entries is compared with the amount of a single entry of the first unmatched successful entry in the second reconciliation details table to determine whether the amounts are equal, and the second matched successful entry and the second unmatched successful entry in the first reconciliation details table, as well as the second matched successful entry and the second unmatched successful entry in the second reconciliation details table are determined; When the execution of the second reconciliation plan is completed, the third reconciliation plan is triggered, the amounts of the second unmatched items in the first reconciliation details table are summed up, and if the value is 0, it is marked as a successfully matched item, and then the amounts of the second unmatched items in the second reconciliation details table are summed up, and if the value is 0, it is marked as a successfully matched item, and the third successfully matched item and the third unmatched item in the first reconciliation details table, as well as the third successfully matched item and the third unmatched item in the second reconciliation details table are determined; The reconciliation result is obtained according to the first successfully matched entry, the second successfully matched entry, the third matched entry and the third unmatched successfully entry in the first reconciliation details table, and the first successfully matched entry, the second successfully matched entry, the third successfully matched entry and the third unmatched successfully entry in the second reconciliation details table.

[0011] The present invention also provides a reconciliation device, comprising the following modules: A data acquisition module, used to acquire target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects have a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items are used to perform auxiliary accounting on the corresponding reconciliation subjects; The data reconciliation module is used to perform reconciliation according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0012] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, any of the above-described reconciliation methods is implemented.

[0013] The present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the reconciliation method as described in any one of the above is implemented.

[0014] The present invention also provides a computer program product, comprising a computer program, wherein when the computer program is executed by a processor, the computer program implements any of the above-mentioned reconciliation methods.

[0015] The reconciliation method, device, electronic device and storage medium provided by the present invention adopt a method of reconciliation by combining data of reconciliation subjects and reconciliation auxiliary items, thereby ensuring the accuracy of the acquired reconciliation data and improving the accuracy of reconciliation in complex scenarios. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 It is a flowchart of the reconciliation method provided by the present invention.

[0018] Figure 2 It is a flowchart of the method for obtaining target reconciliation data provided by the present invention.

[0019] Figure 3 It is a flowchart of a method for reconciling target reconciliation data provided by the present invention.

[0020] Figure 4 It is a schematic diagram of the reconciliation logic architecture provided by the present invention.

[0021] Figure 5 It is a schematic diagram of the overall flow of the reconciliation method provided by the present invention.

[0022] Figure 6 This is one of the schematic diagrams of the storage structure provided by the present invention.

[0023] Figure 7 This is the second schematic diagram of the storage structure provided by the present invention.

[0024] Figure 8 It is a structural schematic diagram of the account reconciliation device provided by the present invention.

[0025] Fig. 9 It is a schematic diagram of the physical structure of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0026] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the drawings of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0027] Reconciliation is a very important task, which involves the flow and use of funds and is an indispensable part of a company's financial management. First of all, through a reasonable reconciliation cycle, voucher collection, reconciliation process, exception handling and data update, the accuracy and authenticity of financial data can be ensured. Secondly, internal reconciliation is to check the current business of different accounting entities. When there is a discrepancy, the reason is checked in time. It is a key link and important measure to avoid operational risks and prevent cases.

[0028] Existing reconciliation solutions generally compare single data items. Due to the simple rules, the reconciliation accuracy in complex scenarios is low.

[0029] In view of this, an embodiment of the present invention provides a reconciliation method, which obtains target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects have a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items are used to assist in the accounting of the corresponding reconciliation subjects; reconciliation is performed according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result. This method ensures the accuracy of the reconciliation data obtained, thereby improving the accuracy of reconciliation in complex scenarios.

[0030] The technical solutions in the embodiments of the present invention will be described below in conjunction with the accompanying drawings in the embodiments of the present invention.

[0031] Figure 1 : is a flow chart of the reconciliation method provided by the present invention. The reconciliation method can be applied to electronic devices, which can be various types of devices with information processing capabilities during implementation. For example, the electronic device can include a personal computer, a laptop computer, a PDA or a server, etc.; the electronic device can also be a mobile terminal, for example, the mobile terminal can include a mobile phone, a car computer, a tablet computer or a projector, etc. Figure 1 As shown, the method may include the following steps 101 to 102: Step 101: Obtain target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects correspond to the reconciliation auxiliary items, and the reconciliation auxiliary items are used to perform auxiliary accounting on the corresponding reconciliation subjects.

[0032] It should be noted that the reconciliation subject may refer to a subject in finance, which is mainly divided into five categories of accounting subjects: assets, liabilities, owner's equity, profit and loss, and cost. Auxiliary items can be used for auxiliary accounting of subjects, which refers to a supplementary method of financial processing implemented through specific accounting items, and exemplary ones may include quantity accounting, department accounting, etc. Among them, the reconciliation subject of the present invention may be an accounting subject, that is, the accounting subject is used as the reconciliation subject for internal reconciliation, and a single or multiple current accounts between two accounting subjects are reconciled.

[0033] Among them, there are many ways to obtain the target reconciliation data corresponding to each reconciliation subject, for example, data import methods can be used, such as Robotic process automation (RPA) interface access, Representational State Transfer (REST) ​​interface access, Excel, TXT and other format import, etc. The present invention supports multiple ways of data import, which can facilitate enterprises to import reconciliation data and reduce the burden of reconciliation. The present invention does not limit the method of obtaining the target reconciliation data corresponding to each reconciliation subject.

[0034] Step 102: reconcile according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0035] It should be noted that there are many ways to reconcile according to the target reconciliation data corresponding to each reconciliation subject, such as reconciliation according to preset reconciliation rules, or reconciliation by simulating human reconciliation operation behavior through RPA technology, etc. The present invention does not limit the way to reconcile according to the target reconciliation data corresponding to each reconciliation subject and obtain the reconciliation result. Among them, providing an automated reconciliation function can reduce manual intervention, and at the same time can provide functions such as abnormal reminders and automatic archiving, further improving the intelligence level of reconciliation.

[0036] It is understandable that the present invention ensures the accuracy of the extracted reconciliation data by adopting the method of reconciliation of account + voucher auxiliary item combination information, thereby improving the accuracy of reconciliation and avoiding the inconsistency of accounts caused by human error or simple automated reconciliation rules. In addition, online reconciliation can obtain reconciliation data in real time, greatly shortening the reconciliation time and improving the reconciliation efficiency.

[0037] In some embodiments, the target reconciliation data corresponding to each reconciliation subject can be obtained according to the reconciliation configuration information. The reconciliation configuration information can be input by a user, obtained by system import, etc.

[0038] Figure 2 is a flow chart of the method for obtaining target reconciliation data provided by the present invention. Figure 2 As shown, the acquisition of target reconciliation data corresponding to each reconciliation subject may include: Step 201: Acquire reconciliation configuration information, wherein the reconciliation configuration information includes information of configured reconciliation entities, reconciliation accounts corresponding to each reconciliation entity, and corresponding reconciliation auxiliary items under each reconciliation account.

[0039] It should be noted that the reconciliation configuration information may be information set by a user through a configuration interface, or may be imported information, and the present invention does not limit the method for obtaining the reconciliation configuration information.

[0040] Among them, the reconciliation configuration information can determine the accounting subject of the reconciliation and configure the mapping relationship between the accounting subject accounts and auxiliary items. It can be maintained within the system, accessed from the accounting system through an interface, or accessed from different systems through RPA robots.

[0041] For example, the reconciliation subject may include an accounting subject H1 and an accounting subject H2, and the reconciliation items corresponding to each reconciliation subject may include S1 (asset account) and corresponding auxiliary items P1 (project), C1 (customer) and N1 (internal account). Among them, the reconciliation items and the contents of the reconciliation auxiliary items of the accounting subject H1 and the accounting subject H2 are corresponding.

[0042] Step 202: According to the reconciliation configuration information, the balance and voucher entry details of the corresponding reconciliation auxiliary items under the reconciliation subjects corresponding to the reconciliation entities are obtained to obtain the target reconciliation data corresponding to the reconciliation entities.

[0043] It should be noted that after obtaining the reconciliation configuration information, data can be extracted from the database according to the reconciliation configuration information, and the extracted data may include enterprise account details, balances, etc. The data source may be the actual voucher accounting data of each organization.

[0044] For example, when extracting the initial balance, you can connect to the accounting system or import it offline. The offline import supports Excel and TXT formats. The balance M1 of the auxiliary item P1+C1+N1 corresponding to account S1 is queried and deposited into the system as the balance of S1. The balance M2 of the auxiliary item P2+C2+N2 corresponding to account S2 is queried and deposited into the system as the balance of S2. At this time, M1 should be equal to M2. After the beginning of the next year, the initial balances of M1 and M2 will be updated.

[0045] In addition, you can also extract enterprise account details based on the reconciliation configuration information and store them in the reconciliation detail tables T1 and T2. The extraction of enterprise account details can be connected to the accounting system, RPA robot, and offline import. Offline import supports Excel and TXT formats. Extract the voucher entry details of the auxiliary items P1+C1+N1 corresponding to subject S1 to obtain the enterprise account details. Among them, extract the balances and voucher details of different auxiliary items of the reconciliation subject, and automatically reconcile according to the debit and credit amounts, supporting reconciliation of the same debit and credit directions and reconciliation of opposite directions.

[0046] It can be understood that by configuring each reconciliation subject, the reconciliation account corresponding to each reconciliation subject, and the information of the corresponding reconciliation auxiliary items under each reconciliation account through the reconciliation configuration information, and then obtaining the target reconciliation data according to the reconciliation configuration information, the data source can be made more accurate.

[0047] Furthermore, the target reconciliation data corresponding to each reconciliation entity may include multiple detailed business data. After obtaining the balance and voucher entry details of the corresponding reconciliation auxiliary items under the reconciliation account corresponding to each reconciliation entity according to the reconciliation configuration information to obtain the target reconciliation data corresponding to each reconciliation entity, the method may further include: storing the target reconciliation data corresponding to each reconciliation entity in a separate table according to the first dimension of each detailed business data, and partitioning and storing the target reconciliation data in each table according to the second dimension of each detailed business data, wherein the first dimension is used to represent the business date, and the second dimension is used to represent the business object.

[0048] It should be noted that the amount of data in the account voucher details in a large group will be very large. You can use the open source distributed relational database middleware Mycat to store it in separate tables by year and month according to the detailed business date dimension. When storing a single month, continue to split it according to the organizational structure as the database partition dimension. The sub-table partition dimension is not a fixed dimension. Different sub-table and partition schemes can be configured for different business scenarios. Among them, Mycat supports distributed SQL queries to facilitate data queries.

[0049] It is understandable that reconciliation data supports data sharding storage, that is, based on database partitioning + Mycat table partitioning, supports distributed and cluster deployment, and supports storage and reconciliation of 100 million and 1 billion data. Based on the above table partitioning and partitioning scheme, it breaks the data volume limit of a single table in a traditional relational database and can adapt to reconciliation scenarios with large data volumes.

[0050] In some embodiments, at least one reconciliation scheme may be configured to reconcile the target reconciliation data corresponding to each reconciliation subject, thereby improving the flexibility of reconciliation.

[0051] Figure 3 Schematic diagram of the process of reconciling target reconciliation data provided by the present invention. Figure 3As shown, performing reconciliation according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result may include: Step 301: Obtain a target reconciliation scheme, wherein the target reconciliation scheme includes at least one configured reconciliation scheme and execution logic corresponding to the at least one reconciliation scheme, wherein the execution logic corresponding to the at least one reconciliation scheme is used to indicate an execution order and / or a trigger condition of each reconciliation scheme, and each reconciliation scheme in the at least one reconciliation scheme adopts at least one reconciliation method selected from one-to-one data comparison, one-to-many data comparison, many-to-many data comparison, and self-data comparison.

[0052] It should be noted that the target reconciliation scheme includes at least one reconciliation scheme, and each reconciliation scheme can adopt a different reconciliation method, and at least one reconciliation scheme is also provided with execution logic to manage the execution order and / or triggering conditions of each reconciliation scheme.

[0053] Exemplarily, different reconciliation schemes can be flexibly set for different business scenarios, supporting the setting of reconciliation dimensions, reconciliation methods, reconciliation symbols, advanced configuration, etc. The reconciliation program has built-in commonly used reconciliation symbols and supports extensions, such as: one-to-one comparison, summing up a single piece of data on the left and comparing it with multiple pieces of data on the right, summing up both sides separately and comparing, and the sum of one side is 0 (red rush scenario), etc. The execution logic corresponding to at least one reconciliation scheme can be executed in serial mode, binary tree mode, parallel mode, etc. The present invention does not limit the execution logic corresponding to the at least one reconciliation scheme.

[0054] Step 302: reconcile according to the target reconciliation scheme and the target reconciliation data corresponding to each reconciliation subject to obtain the reconciliation result.

[0055] It should be noted that there are many ways to obtain the reconciliation result by reconciling the target reconciliation scheme with the target reconciliation data corresponding to each reconciliation entity. The reconciliation may be performed according to program settings or by using a third-party tool. The present invention does not limit the way to obtain the reconciliation result by reconciling the target reconciliation scheme with the target reconciliation data corresponding to each reconciliation entity.

[0056] In addition, the present invention also supports reconciliation task sharding, that is, based on the cluster deployment method, the reconciliation task is split according to the organization + year + period dimensions, and the task is distributed to each node through the message queue mq, so as to realize the aggregation of results after the execution of large batches of tasks separately.

[0057] It can be understood that by obtaining the target reconciliation plan according to the configured reconciliation plan information, different reconciliation plans can be flexibly set for different business scenarios, thereby improving the flexibility and convenience of reconciliation.

[0058] In some embodiments, the at least one reconciliation plan includes a first reconciliation plan, a second reconciliation plan and a third reconciliation plan. The reconciliation success condition of the first reconciliation plan is that the amount of a single item is equal, the reconciliation success condition of the second reconciliation plan is that the sum of the amounts of multiple items is equal to the amount of the single item, and the reconciliation success condition of the third reconciliation plan is that the sum of the amounts of its own items is equal to zero. The execution logic corresponding to the at least one reconciliation plan is a binary tree, the root node of the binary tree is the first reconciliation plan, the first-level child node of the binary tree is the second reconciliation plan, and the second-level child node of the binary tree is the third reconciliation plan.

[0059] It should be noted that the reconciliation plan can support the setting of multiple reconciliation plans in series in the form of a binary tree. After the reconciliation of each plan succeeds or fails, it can be forked and executed according to the configuration. This method can be adapted to more reconciliation scenarios. For example, you can set: single value = single value, sum = sum, single value = sum, single value = single value negation, etc., and execute one reconciliation plan after success and another reconciliation plan after failure, thereby improving the flexibility of the reconciliation plan.

[0060] Further, the reconciliation details table corresponding to each reconciliation subject includes a first reconciliation details table corresponding to the first reconciliation subject and a second reconciliation details table corresponding to the second reconciliation subject. The reconciliation according to the target reconciliation scheme and the target reconciliation data corresponding to each reconciliation subject to obtain the reconciliation result may include: performing reconciliation from the root node according to the first reconciliation details table and the second reconciliation details table; triggering the first reconciliation scheme, traversing the amount of each item in the first reconciliation details table, and performing a single comparison with the amount of each item in the second reconciliation details table to determine whether the amount is equal, determining the first successfully matched item and the first unmatched successfully item in the first reconciliation details table, and the first successfully matched item and the first unmatched successfully item in the second reconciliation details table; when the first reconciliation scheme is executed, triggering the second reconciliation scheme, traversing the first unmatched successfully item in the first reconciliation details table, and comparing the value obtained by adding the amounts of at least two unmatched successfully items with the amount of the single item of the first unmatched successfully item in the second reconciliation details table. The second reconciliation table is compared with the first reconciliation table to determine whether the amounts are equal, and the second successfully matched item and the second unmatched item in the first reconciliation table are determined, as well as the second successfully matched item and the second unmatched item in the second reconciliation table; when the second reconciliation plan is executed, the third reconciliation plan is triggered, the amounts of the second unmatched items in the first reconciliation table are summed up, and a value of 0 is marked as a successfully matched item, and then the amounts of the second unmatched items in the second reconciliation table are summed up, and a value of 0 is marked as a successfully matched item, and the third successfully matched item and the third unmatched item in the first reconciliation table are determined, as well as the third successfully matched item and the third unmatched item in the second reconciliation table; the reconciliation result is obtained according to the first successfully matched item, the second successfully matched item, the third matched item and the third unmatched item in the first reconciliation table, and the first successfully matched item, the second successfully matched item, the third successfully matched item and the third unmatched item in the second reconciliation table.

[0061] Figure 4 Schematic diagram of the reconciliation logic architecture provided by the present invention. Figure 4 As shown, the reconciliation scheme includes F1, F2 and F3. The three schemes are connected in series. F1 is configured to set the task to be executed after success and the task to be executed after failure to F2, and F2 is configured to set the task to be executed after success and the task to be executed after failure to F3, forming a binary tree.

[0062] Exemplarily, the reconciliation scheme includes F1, F2 and F3, and another binary tree structure may be adopted, where F1 is configured to execute task F2 upon success and to execute task F3 upon failure.

[0063] In some embodiments, during the reconciliation process, we may need to concatenate the reconciliation conditions (such as date, transaction type, etc.), then calculate the hash value based on the concatenated string, and determine the storage location of the string in the array (bucket). Exemplarily, a bucket algorithm, which is one of the implementation methods of a hash table, can be used for reconciliation. The following will explain this reconciliation calculation process in detail.

[0064] The steps of reconciliation calculation may include: 1. Concatenate the reconciliation conditions, for example, concatenate the reconciliation conditions into a string, such as 1002022-03-01. 2. Calculate the hash value: You can use Java's hashCode() method to calculate the hash value of the concatenated string. 3. Bit operation: For example, shift the hash value right by 16 bits and perform an XOR operation with the original hash value to further reduce hash conflicts. 3. Modulus operation: Subtract 1 from the result of the bit operation (because the array index starts at 0), and then perform a modulus operation on the array length x to obtain the final storage location.

[0065] The reconciliation method provided by the present invention adopts the account + voucher auxiliary item combination information reconciliation, and can expand N reconciliation schemes and compare multi-dimensional data, thereby ensuring the accuracy of the data and improving the accuracy of the reconciliation, avoiding account discrepancies caused by human errors or single reconciliation rules.

[0066] The following describes an exemplary application of an embodiment of the present invention in a practical application scenario.

[0067] This embodiment uses the "accounting entity" as the reconciliation entity to reconcile single or multiple current accounts between two accounting entities, and supports generating a reconciliation statement (balance adjustment sheet) after daily reconciliation.

[0068] Figure 5 It is a schematic diagram of the overall process of the reconciliation method provided by the present invention. Figure 5 As shown, the method comprises the following steps: Step 1: Initial reconciliation: The implementation staff or customer staff configures and extracts the detailed accounts and auxiliary item information of the enterprise accounts of different accounting entities, and saves them after extracting the initial balance. If there are any unreconciled accounts, they need to be entered.

[0069] This can include determining the accounting subject for reconciliation and configuring the mapping relationship between the accounting subject accounts and auxiliary items. This can be maintained within the system, accessed from the accounting system through an interface, or accessed from different systems through RPA robots.

[0070] Taking the reconciliation of accounting entities H1 and H2 as an example, the detailed extraction schemes are obtained as shown in Table 1. The configuration is as follows: H1 initial account S1 (asset account) and corresponding auxiliary items, supporting the setting of multiple auxiliary items, including project P1, customer C1, and internal account N1; H2 initial account S2 (asset account) and corresponding auxiliary items, supporting the setting of multiple auxiliary items, including project P2, customer C2, and internal account N2. Here, P1, C1, and N1 are business-related with P2, C2, and N2, and this relationship needs to be determined by the financial staff; Table 1: Account configuration information

[0071] Among them, when extracting the initial balance, you can connect to the accounting system or import offline. The offline import supports Excel and TXT formats. The balance M1 of the auxiliary item P1+C1+N1 corresponding to the account S1 is queried and deposited into the system as the balance of S1. The balance M2 of the auxiliary item P2+C2+N2 corresponding to the account S2 is queried and deposited into the system as the balance of S2. At this time, M1 should be equal to M2. After the beginning of the next year, the initial balances of M1 and M2 will be updated, as shown in Table 2.

[0072] Table 2 Balance withdrawal information

[0073] Step 2: Detail extraction: According to the initial enterprise account extraction plan in step 1, extract the enterprise account details and store them in the reconciliation detail tables T1 and T2. The specific steps are as follows: Step 2.1: It can be connected to the accounting system, RPA robot, and offline import. Offline import supports Excel and TXT formats. Extract the voucher entry details of the auxiliary items P1+C1+N1 corresponding to subject S1, and obtain the details S1D1, S1D2, S1D3, S1D4, and S1D5. Extract the voucher entry details of the auxiliary items P2+C2+N2 corresponding to subject S2, and obtain S2D1, S2D2, S2D3, S2D4, S2D5, and S2D6, as shown in Table 3.

[0074] Table 3 Reconciliation Details

[0075] Step 2.2: The amount of data in the account voucher details will be very large in a large group. You can use Mycat to store it in separate tables by year and month according to the detailed business date dimension. When storing it in a single month, continue to split it according to the organizational structure as the database partition dimension. The sub-table partition dimension is not a fixed dimension. Different sub-table and partition schemes can be configured for different business scenarios.

[0076] Step 3: Reconciliation plan: Set up the reconciliation table, reconciliation conditions, reconciliation dimensions, reconciliation symbols, etc. The specific steps are as follows: Step 3.1: The reconciliation table is configured as detailed tables T1 and T2 corresponding to account S1 and account S2; Step 3.2: Configure reconciliation schemes F1, F2, and F3. The condition for F1 is that the amounts are equal, the condition for F2 is that the sum of the amounts on the left is equal to the sum on the right, and the condition for F3 is that the sum of the amounts on one side is equal to 0; Step 3.3: Connect the three schemes in series, configure F1 to execute tasks after success and after failure to set them to F2, and configure F2 to execute tasks after success and after failure to set them to F3, to form a binary tree; the advantage of this scheme is that through the bifurcated data structure, different reconciliation schemes can be executed according to the success and failure results of a single scheme, which can adapt to businesses in a variety of different scenarios.

[0077] Step 4: Reconciliation: Query the corresponding detailed data by project and reconciliation period (date range) and then reconcile. You can reconcile manually (manually check the detailed reconciliation) or automatically (reconcile all unreconciled data according to the reconciliation plan). The specific steps are as follows: Step 4.1: According to the binary tree formed in step 3, reconcile from the root node; Step 4.2: When a single solution is executed, the enterprise account details of S1 and S2 are queried according to T1 and T2 configured in step 3, and then reconciliation is performed to obtain the data listed in step 2.1; Step 4.3: Determine the query table based on the reconciliation dimension set in step 3 and the sub-table and partition scheme set in step 2.2, and distribute multiple tasks to each cluster node according to organization + year + period. The cluster node stores the reconciliation results of a single reconciliation scheme and a single sub-task into the database; the reconciliation scheme can be reconciled based on the database table as the dimension, without the need for secondary processing, and the data can be reconciled directly. It can be divided into table A on the left and table B on the right, supporting bilateral reconciliation and unilateral reconciliation (unilateral reconciliation is required for red cancellation).

[0078] Step 4.4: When S1 and S2 are reconciled and plan F1 is executed, the symbol is judged to be equal to the amount. After traversing all the data sets of S1, it can be concluded that S1D3 is equal to S2D1; after F1 completes the reconciliation, F2 is triggered. At this time, all the unreconciled items of S1 are traversed and added once every two. The sum of the unreconciled items of S1 is used to perform a single comparison with the unreconciled result set of S2, and it can be concluded that S1D1+S1D2 is equal to S2D2; after F2 is completed, F3 is triggered and the symbol is judged to be equal to 0 after unilateral addition. At this time, the unreconciled details of S1 are added in pairs, and the value is 0, which marks the reconciliation successful. Then, the unreconciled details of S2 are added in pairs, and the value is 0, which marks the reconciliation successful. After F3 is executed, the reconciliation ends.

[0079] In addition, if the internal reconciliation uses the voucher summary for reconciliation, you can set the following conditions: F1 condition is the same amount, F2 is the same summary, and F3 is the sum of the two sides equals 0. At this time, after F1 succeeds, you can execute F2 to further find which accounts have the same summary. After F1 fails, go to F3 to see if it is a one-sided reconciliation. In actual projects, you can also configure F1 to be the same summary + amount, and reconcile with the amount after failure. The configuration method is very flexible and can be reconciled according to the configuration of the specific implementation personnel.

[0080] The following is an example of the reconciliation algorithm. The present invention can use a reconciliation algorithm (bucket algorithm). First, when reconciling, the reconciliation conditions are taken and concatenated. For example, the first row of S1 in Table 3, S1D1, is concatenated to 1002022-03-01. The bucket algorithm is used to initialize an array of length x as a bucket, and the hash code hashcode of 1002022-03-01 is taken. The hashcode is bitwise shifted right by 16 bits and then XORed with the hashcode, and then the modulus of 16-1 is taken to obtain 7.

[0081] The formula is: storage location = (((k = key.hashCode()) ^ (k>>>16)) - 1) % x.

[0082] Figure 6 This is one of the schematic diagrams of the storage structure provided by the present invention. Assuming x=16, the storage structure is as follows Figure 6 The same is true for S2 details. After the formula operation, an array similar to the result of S1 will be obtained. When searching for the corresponding matching account of S1D1, the 1002022-03-01 concatenated by S1D1 will be used to check whether there is the same data in the corresponding array position of S2. If there is, the reconciliation is successful, otherwise the reconciliation fails; Through the formula, we find that the length of 16 buckets is very small and the data stored is limited. Therefore, when the number of full buckets reaches a certain amount, we need to add buckets. The formula for adding buckets (assuming that the current number of full buckets is y) is to expand the capacity: x=y>x*0.75?x*2:x.

[0083] Figure 7 This is the second schematic diagram of the storage structure provided by the present invention. Figure 7 As shown, when calculating the bucket position, there may be a situation where there is already content in the bucket. At this time, it is necessary to maintain a string of buckets at the position of the current bucket to handle the situation of the same position. The structure is as follows Figure 7 As shown, assuming that position 15 is repeated, it is necessary to maintain another string of buckets at position 15.

[0084] Step 5: Reconciliation statement: Generate a reconciliation statement, including the reconciliation period, beginning balance, ending balance, unreconciled accounts, and reconciliation results. The ending balances of the two accounts must be verified to see if they are balanced.

[0085] Step 5.1: Generate the balances of S1 and S2 of the reconciliation statement according to the initial balances in step 1.3. After reconciliation according to step 4.3, it can be concluded that the voucher details S1D4 and S1D5 of account S1 have not been successfully reconciled, and the voucher details S2D5 and S2D6 of account S2 have not been successfully reconciled. Since both S1 and S2 are asset accounts, the debit amount is income and the credit amount is expenditure. Then it can be concluded that: the details of S1 received but not received by S2 are 120, the details of S1 paid but not paid by S2 are 800, the details of S2 received but not received by S1 are 700, and the details of S2 paid but not paid by S1 are 230. Perform a balance check when saving the reconciliation statement. The check formula is: S1 balance + S1 received but not received by S2 - S1 paid but not paid by S2 = S2 balance + S2 received but not received by S1 + S2 paid but not paid, as shown in Table 4.

[0086] Table 4 Statement of Account

[0087] Step 6: Result notification: The reconciliation results are pushed to the user’s mobile terminal, such as SMS, corporate WeChat, email, etc.

[0088] The advantages of the above-mentioned embodiment scheme are as follows: internal reconciliation is performed with the "accounting subject" as the reconciliation subject, and single or multiple current accounts between two accounting subjects are reconciled. The balances and voucher details of different auxiliary items of the accounting subject can be extracted, and automatic reconciliation can be performed according to the debit and credit amounts, supporting reconciliation in the same debit and credit directions and reconciliation in the opposite directions. Different reconciliation schemes can be flexibly set for different business scenarios, supporting the setting of reconciliation dimensions, reconciliation methods, reconciliation symbols, advanced configuration, etc.; the program has built-in commonly used reconciliation symbols and supports extensions, such as: one-to-one comparison, comparison after summing up a single item on the left and multiple items on the right, comparison after summing up both sides, and 0 after summing up on one side (red rush scenario), etc. A single reconciliation scheme can also support the extension of pre- and post-reconciliation tasks, for example: 1. The execution results of each scheme can be notified to the person in charge of reconciliation by extending the pre- and post-tasks. 2. Data can also be micro-processed. In addition, reconciliation can also use RPA technology to simulate human operation behavior, reduce human errors and delays, and can run 24 / 7 uninterruptedly to ensure the stability and continuity of business processes. The reconciliation solution uses the database table as the dimension for reconciliation, without secondary processing, and directly reconciles the data. It is divided into table A on the left and table B on the right, supporting bilateral reconciliation and unilateral reconciliation (unilateral reconciliation is required for red flush). Based on the implemented sub-table and partitioning scheme, the data volume limit of a single table in a traditional relational database is broken. The reconciliation scheme supports the setting of multiple reconciliation schemes in series in the form of a binary tree. After each scheme succeeds or fails in reconciliation, it can be executed according to the configuration fork. This method can adapt to more reconciliation scenarios, for example, it can be set separately: single value = single value, sum = sum, single value = sum, single value = single value negation, etc., and execute one reconciliation scheme after success, and execute another reconciliation scheme after failure. The scheme of the above embodiment ensures the accuracy of the acquired reconciliation data, thereby improving the accuracy of reconciliation in complex scenarios.

[0089] Based on the foregoing embodiments, an embodiment of the present invention provides a reconciliation device, and each module included in the device and each unit included in each module can be implemented by a processor; of course, it can also be implemented by a specific logic circuit; in the implementation process, the processor can be a central processing unit (CPU), a microprocessor (MPU), a digital signal processor (DSP) or a field programmable gate array (FPGA), etc.

[0090] The following is a description of the account reconciliation device provided by the present invention. The account reconciliation device described below and the account reconciliation method described above can be referenced to each other.

[0091] Figure 8 Schematic diagram of the structure of the reconciliation device provided by the present invention. Figure 8 As shown, the device 500 includes a data acquisition module 501 and a data reconciliation module 502, wherein: The data acquisition module 501 is used to acquire target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects have a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items are used to perform auxiliary accounting on the corresponding reconciliation subjects; The data reconciliation module 502 is used to perform reconciliation according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0092] In some embodiments, the data acquisition module 501 includes a configuration acquisition unit and a data acquisition unit, wherein: The configuration acquisition unit is used to acquire reconciliation configuration information, wherein the reconciliation configuration information includes information of each configured reconciliation subject, the reconciliation account corresponding to each reconciliation subject, and the corresponding reconciliation auxiliary items under each reconciliation account; The data acquisition unit is used to acquire the balance and voucher entry details of the corresponding reconciliation auxiliary items under the reconciliation subjects corresponding to the reconciliation entities according to the reconciliation configuration information, and obtain the target reconciliation data corresponding to the reconciliation entities.

[0093] In some embodiments, the device also includes a data storage module, which is used to store the target reconciliation data corresponding to each reconciliation entity in a table according to the first dimension of each detailed business data, and to partition and store the target reconciliation data according to the second dimension of each detailed business data when storing in each table. The first dimension is used to represent the business date, and the second dimension is used to represent the business object.

[0094] In some embodiments, the data reconciliation module 502 includes a solution acquisition unit and a data reconciliation unit, wherein: The scheme acquisition unit is used to acquire a target reconciliation scheme, wherein the target reconciliation scheme includes at least one configured reconciliation scheme and execution logic corresponding to the at least one reconciliation scheme, wherein the execution logic corresponding to the at least one reconciliation scheme is used to indicate the execution order and / or triggering condition of each reconciliation scheme, and each reconciliation scheme in the at least one reconciliation scheme adopts at least one reconciliation method selected from one-to-one data comparison, one-to-many data comparison, many-to-many data comparison and self-data comparison; The data reconciliation unit is used to perform reconciliation according to the target reconciliation scheme and the target reconciliation data corresponding to each reconciliation subject to obtain the reconciliation result.

[0095] In some embodiments, the at least one reconciliation plan includes a first reconciliation plan, a second reconciliation plan and a third reconciliation plan. The reconciliation success condition of the first reconciliation plan is that the amount of a single item is equal, the reconciliation success condition of the second reconciliation plan is that the sum of the amounts of multiple items is equal to the amount of the single item, and the reconciliation success condition of the third reconciliation plan is that the sum of the amounts of its own items is equal to zero. The execution logic corresponding to the at least one reconciliation plan is a binary tree, the root node of the binary tree is the first reconciliation plan, the first-level child node of the binary tree is the second reconciliation plan, and the second-level child node of the binary tree is the third reconciliation plan.

[0096] In some embodiments, the data reconciliation unit is specifically used to: perform reconciliation starting from the root node according to the first reconciliation detail table and the second reconciliation detail table; Trigger the first reconciliation plan, traverse the amount of each item in the first reconciliation details table, and perform a single comparison with the amount of each item in the second reconciliation details table to determine whether the amounts are equal, and determine the first successfully matched item and the first unmatched item in the first reconciliation details table, as well as the first successfully matched item and the first unmatched item in the second reconciliation details table; When the execution of the first reconciliation plan is completed, the second reconciliation plan is triggered, the first unmatched successful entry in the first reconciliation details table is traversed, and the value obtained by adding the amounts of at least two unmatched successful entries is compared with the amount of a single entry of the first unmatched successful entry in the second reconciliation details table to determine whether the amounts are equal, and the second matched successful entry and the second unmatched successful entry in the first reconciliation details table, as well as the second matched successful entry and the second unmatched successful entry in the second reconciliation details table are determined; When the execution of the second reconciliation plan is completed, the third reconciliation plan is triggered, the amounts of the second unmatched items in the first reconciliation details table are summed up, and if the value is 0, it is marked as a successfully matched item, and then the amounts of the second unmatched items in the second reconciliation details table are summed up, and if the value is 0, it is marked as a successfully matched item, and the third successfully matched item and the third unmatched item in the first reconciliation details table, as well as the third successfully matched item and the third unmatched item in the second reconciliation details table are determined; The reconciliation result is obtained according to the first successfully matched entry, the second successfully matched entry, the third matched entry and the third unmatched successfully entry in the first reconciliation details table, and the first successfully matched entry, the second successfully matched entry, the third successfully matched entry and the third unmatched successfully entry in the second reconciliation details table.

[0097] In the embodiment of the present invention, by adopting a method of performing reconciliation using a combination of reconciliation subjects and reconciliation auxiliary items, the accuracy of the acquired reconciliation data is ensured, thereby improving the accuracy of reconciliation in complex scenarios.

[0098] Fig. 9 Schematic diagram of the physical structure of the electronic device provided by the present invention. Fig. 9 As shown, the electronic device may include: a processor 610, a communication interface 620, a memory 630 and a communication bus 640, wherein the processor 610, the communication interface 620 and the memory 630 communicate with each other through the communication bus 640. The processor 610 may call the logic instructions in the memory 630 to execute the reconciliation method, which includes: obtaining target reconciliation data corresponding to each reconciliation subject, the target reconciliation data including data of reconciliation subjects and reconciliation auxiliary items, the reconciliation subjects having a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items being used to perform auxiliary accounting on the corresponding reconciliation subjects; performing reconciliation according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0099] In addition, the logic instructions in the above-mentioned memory 630 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0100] On the other hand, the present invention also provides a computer program product, which includes a computer program. The computer program can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the reconciliation method provided by the above-mentioned methods, which method includes: obtaining target reconciliation data corresponding to each reconciliation subject, the target reconciliation data including data of reconciliation accounts and reconciliation auxiliary items, the reconciliation accounts and the reconciliation auxiliary items having a corresponding relationship, and the reconciliation auxiliary items being used to perform auxiliary accounting for the corresponding reconciliation accounts; reconciliation is performed according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0101] The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present invention is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer-readable storage medium may be any available medium that a computer can store or a data storage device such as a server or data center that includes one or more available media integrated therein. The available medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive Solid State Disk (SSD)), etc.

[0102] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the reconciliation method provided by the above-mentioned methods, the method comprising: obtaining target reconciliation data corresponding to each reconciliation subject, the target reconciliation data comprising data of reconciliation accounts and reconciliation auxiliary items, the reconciliation accounts having a corresponding relationship with the reconciliation auxiliary items, the reconciliation auxiliary items being used to perform auxiliary accounting for the corresponding reconciliation accounts; performing reconciliation according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

[0103] The above-mentioned computer-readable storage medium can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, - but not limited to - an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM) or flash memory, an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.

[0104] Computer-readable signal media may include a data signal propagated in baseband or as part of a carrier wave, which carries a computer-readable program code. Such propagated data signals may take a variety of forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0105] The program code embodied on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wire, optical cable, radio frequency (RF), etc., or any suitable combination of the foregoing.

[0106] Computer program code for performing the operations of the present specification 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., through the Internet using an Internet service provider).

[0107] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0108] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0109] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A reconciliation method, characterized in that: include: Obtaining target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects have a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items are used to perform auxiliary accounting on the corresponding reconciliation subjects; Reconciliation is performed according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

2. The reconciliation method according to claim 1, characterized in that: The obtaining of target reconciliation data corresponding to each reconciliation subject includes: Acquire reconciliation configuration information, wherein the reconciliation configuration information includes information of each configured reconciliation subject, the reconciliation account corresponding to each reconciliation subject, and the corresponding reconciliation auxiliary items under each reconciliation account; The balance and voucher entry details of the corresponding auxiliary reconciliation items under the reconciliation subjects corresponding to the respective reconciliation entities are obtained according to the reconciliation configuration information to obtain the target reconciliation data corresponding to the respective reconciliation entities.

3. The reconciliation method according to claim 2, characterized in that: The target reconciliation data corresponding to each reconciliation subject includes a plurality of detailed business data. After acquiring the balance and voucher entry details of the corresponding reconciliation auxiliary items under the reconciliation subjects corresponding to each reconciliation subject according to the reconciliation configuration information and obtaining the target reconciliation data corresponding to each reconciliation subject, the method further includes: The target reconciliation data corresponding to each reconciliation subject is stored in a table according to a first dimension of each detailed business data, and when storing in each table, the target reconciliation data is partitioned and stored according to a second dimension of each detailed business data, wherein the first dimension is used to represent a business date, and the second dimension is used to represent a business object.

4. The reconciliation method according to claim 1, characterized in that: The reconciliation is performed according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result, including: Obtaining a target reconciliation scheme, the target reconciliation scheme comprising at least one configured reconciliation scheme and execution logic corresponding to the at least one reconciliation scheme, the execution logic corresponding to the at least one reconciliation scheme being used to indicate an execution order and / or a triggering condition of each reconciliation scheme, and each reconciliation scheme in the at least one reconciliation scheme adopting at least one reconciliation method selected from one-to-one data comparison, one-to-many data comparison, many-to-many data comparison, and self-data comparison; Reconciliation is performed according to the target reconciliation scheme and the target reconciliation data corresponding to each reconciliation subject to obtain the reconciliation result.

5. The reconciliation method according to claim 4, characterized in that: The at least one reconciliation plan includes a first reconciliation plan, a second reconciliation plan and a third reconciliation plan. The reconciliation success condition of the first reconciliation plan is that the amount of a single item is equal, the reconciliation success condition of the second reconciliation plan is that the sum of the amounts of multiple items is equal to the amount of the single item, and the reconciliation success condition of the third reconciliation plan is that the sum of the amounts of its own items is equal to zero. The execution logic corresponding to the at least one reconciliation plan is a binary tree, the root node of the binary tree is the first reconciliation plan, the first-level child node of the binary tree is the second reconciliation plan, and the second-level child node of the binary tree is the third reconciliation plan.

6. The reconciliation method according to claim 5, characterized in that: The reconciliation details table corresponding to each reconciliation subject includes a first reconciliation details table corresponding to the first reconciliation subject and a second reconciliation details table corresponding to the second reconciliation subject, and the reconciliation is performed according to the target reconciliation scheme and the target reconciliation data corresponding to each reconciliation subject to obtain the reconciliation result, including: Performing reconciliation starting from the root node according to the first reconciliation detail table and the second reconciliation detail table; Trigger the first reconciliation plan, traverse the amount of each item in the first reconciliation details table, and perform a single comparison with the amount of each item in the second reconciliation details table to determine whether the amounts are equal, and determine the first successfully matched item and the first unmatched item in the first reconciliation details table, as well as the first successfully matched item and the first unmatched item in the second reconciliation details table; When the execution of the first reconciliation plan is completed, the second reconciliation plan is triggered, the first unmatched successful entry in the first reconciliation details table is traversed, and the value obtained by adding the amounts of at least two unmatched successful entries is compared with the amount of a single entry of the first unmatched successful entry in the second reconciliation details table to determine whether the amounts are equal, and the second matched successful entry and the second unmatched successful entry in the first reconciliation details table, as well as the second matched successful entry and the second unmatched successful entry in the second reconciliation details table are determined; When the execution of the second reconciliation plan is completed, the third reconciliation plan is triggered, the amounts of the second unmatched items in the first reconciliation details table are summed up, and if the value is 0, it is marked as a successfully matched item, and then the amounts of the second unmatched items in the second reconciliation details table are summed up, and if the value is 0, it is marked as a successfully matched item, and the third successfully matched item and the third unmatched item in the first reconciliation details table, as well as the third successfully matched item and the third unmatched item in the second reconciliation details table are determined; The reconciliation result is obtained according to the first successfully matched entry, the second successfully matched entry, the third matched entry and the third unmatched successfully entry in the first reconciliation details table, and the first successfully matched entry, the second successfully matched entry, the third successfully matched entry and the third unmatched successfully entry in the second reconciliation details table.

7. A reconciliation device, characterized in that: include: A data acquisition module, used to acquire target reconciliation data corresponding to each reconciliation subject, wherein the target reconciliation data includes data of reconciliation subjects and reconciliation auxiliary items, wherein the reconciliation subjects have a corresponding relationship with the reconciliation auxiliary items, and the reconciliation auxiliary items are used to perform auxiliary accounting on the corresponding reconciliation subjects; The data reconciliation module is used to perform reconciliation according to the target reconciliation data corresponding to each reconciliation subject to obtain a reconciliation result.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the reconciliation method according to any one of claims 1 to 6 is implemented.

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

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the reconciliation method according to any one of claims 1 to 6 is implemented.

Images