A method, system, device and medium for reconciling business data and voucher data in an ERP business system

By establishing reconciliation plan tables and filtering rules in the ERP system and customizing the reconciliation plan, the problems of complex operations and waste of human resources during the reconciliation process of business data and general ledger voucher data in the existing technology are solved, and flexible and efficient The reconciliation function reduces corporate costs.

CN113689276BActive Publication Date: 2024-11-08INSPUR GENERSOFT CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202110988195.5
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-08-26
Publication Date
2024-11-08
Estimated Expiration
2041-08-26

AI Technical Summary

Technical Problem

In the existing ERP system, there are problems such as many operational portals, inconsistent, and a large amount of human resources in the reconciliation process of business data and general ledger voucher data, and the reconciliation function cannot adapt to changes in the data structure, resulting in the inability to effectively verify.

Method used

By establishing a reconciliation plan table, setting filtering rules based on user input, filtering and consistency judgment of the data of the business system, providing customized reconciliation plans, and reducing human resources investment.

Benefits of technology

It realizes customization and flexibility of reconciliation solutions, reduces corporate costs, improves reconciliation efficiency, and facilitates users to discover problems.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113689276B_ABST
    Figure CN113689276B_ABST
Patent Text Reader

Abstract

A method, system, device and medium for reconciling business data and voucher data in an ERP business system, wherein the method comprises: establishing a reconciliation plan table according to the data structure of the business system; establishing multiple filtering rules according to the user's input and the reconciliation plan table; and filtering the voucher data and / or business data of the business system according to the multiple filtering rules, making consistency judgments based on the filtering results of the data filtering and returning the judgment results. The present invention provides a method for compiling different reconciliation plans for business types, checking and verifying general ledger voucher data and business data from different dimensions, understanding the enterprise situation in more detail, and facilitating users to find problems in a timely manner; reducing the enterprise's human resource investment and reducing enterprise costs.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention belongs to the field of computer office automation, and in particular relates to a method, system, equipment and medium for reconciling business data and voucher data in an ERP business system. Background Art

[0002] The reconciliation of enterprise business data and general ledger voucher data is to check and verify the relevant data recorded in the books and accounts before the book records of the accounting period are carried forward to ensure that the book records are true and reliable. After completing daily business processing, business documents can generate vouchers through the accounting center and form data in the general ledger. When users strictly generate vouchers from documents through the accounting center, there will be no difference between the business data and the general ledger voucher data. However, if users manually add vouchers to the general ledger to record business occurrences, differences may occur, resulting in inconsistent data in the business module and the general ledger module. At this time, you need to use the reconciliation function to complete the inspection and verification of the enterprise business data and the general ledger voucher data.

[0003] In the prior art, for each business type of document, the user needs to manually complete the verification of business data and general ledger voucher data one by one.

[0004] The inventors have found that the prior art has at least the following problems: there are many operation entrances, which are not unified and inconvenient for users to operate; business data needs to be entered or screened manually, and if the business volume of the enterprise is large, it will require more human resources or take a long time, increasing the cost of the enterprise; even if there are some automatic reconciliation methods, these reconciliation methods are heavily dependent on the database or data structure of the ERP system. Once the data or the data structure of the database changes, the reconciliation function will immediately collapse and cannot adapt to the ever-changing business data and general ledger or bill voucher data. Summary of the invention

[0005] In view of this, it is necessary to provide a system with strong adaptability to business data and / or bill voucher data and high autonomy for users, which can cope with changes in different data structures and change the reconciliation plan simply and efficiently. Based on this, the present invention proposes a method, system, device and medium for reconciling business data and voucher data in an ERP business system, wherein the method includes:

[0006] Establishing a reconciliation plan table according to the data structure of the business system;

[0007] Establishing multiple filtering rules according to the user's input and the reconciliation plan table; and

[0008] The credential data and / or business data of the business system are filtered according to the multiple filtering rules, and consistency judgment is performed based on the filtering results of the data filtering and the judgment results are returned.

[0009] In some implementations of the present invention, the reconciliation plan table in the method includes a table header, a first table body, and a second table body corresponding to the data structure of the business system.

[0010] In some embodiments of the present invention, the method of establishing multiple filtering rules according to the user input and the reconciliation plan table includes:

[0011] Establishing global filtering rules according to the header of the reconciliation plan table;

[0012] Establishing a first filtering rule according to the user input and the first table body;

[0013] A second filtering rule is established according to the user input and the second table body.

[0014] In some embodiments of the present invention, the method of filtering the credential data and / or business data of the business system according to the multiple filtering rules includes:

[0015] Filtering the credential data based on the global filtering rule to obtain primary credential data;

[0016] The service data is filtered based on the global filtering rule to obtain primary service data.

[0017] In some embodiments of the present invention, the method of filtering the credential data and / or business data of the business system according to the multiple filtering rules includes:

[0018] Filtering the first-level credential data based on the first filtering rule to obtain second-level credential data;

[0019] The primary business data is filtered based on the second filtering rule to obtain secondary business data.

[0020] In some embodiments of the present invention, the method of performing consistency judgment based on the filtering result of the data filtering and returning the judgment result includes:

[0021] Determining whether the values ​​of the same field of the secondary business data and the secondary credential data belonging to the same business event are consistent; and

[0022] The secondary business data and secondary voucher data with inconsistent judgment results are combined and exported as the result.

[0023] In some implementations of the present invention, the intersection of the fields in the first filtering rule in the method and the second filtering rule is not empty.

[0024] Another aspect of the present invention provides a system for reconciling business data and voucher data in an ERP business system, comprising:

[0025] An initialization module configured to establish a reconciliation plan table according to the data structure of the business system;

[0026] A policy module configured to establish a plurality of filtering rules according to the user's input and the reconciliation plan table;

[0027] The execution module is configured to perform data filtering on the credential data and / or business data of the business system according to the multiple filtering rules, perform consistency judgment based on the filtering results of the data filtering and return the judgment result.

[0028] Another aspect of the present invention provides a computer device, characterized in that it includes:

[0029] at least one processor; and

[0030] A memory, wherein the memory stores a computer program that can be run on the processor, and when the processor executes the program, the method described in any one of the above embodiments is performed.

[0031] Another aspect of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, wherein when the computer program is executed by a processor, the method described in any one of the above embodiments is executed.

[0032] The present invention has at least the following beneficial effects: customizable reconciliation plans, which is convenient for each enterprise to prepare different plans for different business types; convenient for user operation, the user only needs to set filtering rules according to the fields in the reconciliation plan table, and it will take effect without modifying any code; provides a method for preparing different reconciliation plans for business types, checks and verifies general ledger voucher data and business data from different dimensions, understands the enterprise situation in more detail, and facilitates users to discover problems in a timely manner; reduces the enterprise's human resource investment and reduces enterprise costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] In order to more clearly illustrate the embodiments of the present invention 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, the drawings in the following description are only some embodiments of the present invention. For ordinary technicians in this field, other embodiments can be obtained based on these drawings without paying creative work.

[0034] Figure 1 A method flow chart of an embodiment of the present invention;

[0035] Figure 2 A schematic diagram of the structure of an ERP business system provided by an embodiment of the present invention;

[0036] Figure 3 A schematic diagram of a computer device structure provided by an embodiment of the present invention;

[0037] Figure 4 A schematic diagram of a computer-readable storage medium provided for an embodiment of the present invention. DETAILED DESCRIPTION

[0038] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the embodiments of the present invention are further described in detail below in combination with specific embodiments and with reference to the accompanying drawings.

[0039] It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are for distinguishing two non-identical entities with the same name or non-identical parameters. It can be seen that "first" and "second" are only for the convenience of expression and should not be understood as limitations on the embodiments of the present invention. The subsequent embodiments will not explain this one by one.

[0040] like Figure 1 As shown, the present invention proposes a method for reconciling business data and voucher data in an ERP business system, comprising:

[0041] Step S100: establishing a reconciliation plan table according to the data structure of the business system;

[0042] Step S200: establishing a plurality of filtering rules according to the user's input and the reconciliation plan table; and

[0043] Step S300: filtering the credential data and / or business data of the business system according to the multiple filtering rules, performing consistency judgment based on the filtering results of the data filtering and returning the judgment result.

[0044] In this embodiment, in step S100, detailed data of all databases related to bills or general ledger voucher data in the ERP system or field names corresponding to different data tables are added to the reconciliation plan table to establish a reconciliation plan table related to the reconciliation plan. For example, in a reconciliation plan involving a department, the database location, database name, corresponding data table, and various field names of the table structure in the data table of the business data table where the department is located are stored in the reconciliation plan table; and the database location, database name, corresponding data table, and various field information of the table structure in the data table of the bill table (hereinafter referred to as bill voucher) involving the department are also stored in the reconciliation plan table.

[0045] In step S200, the user selects appropriate fields or information to generate filtering rules based on the information in the reconciliation plan table established in step S100. The filtering rules are specifically independent information in the reconciliation plan table. The user can appropriately add and delete fields in the filtering rules based on the fields in the reconciliation plan table as needed, that is, add fields in the reconciliation plan table to the filtering rules or delete fields in the filtering rules. For example, a filtering rule of a reconciliation plan includes the ID of a business data table, business type, business generation time or bill generation time, and bill ID (a unique ID automatically generated by the database when the bill record is generated in the database).

[0046] In step S300, the business system according to the embodiment of the method of the present invention will filter the data records that meet the filtering rules in the corresponding table in the corresponding database according to the filtering rules set by the user in step S200, analyze the data filtered by multiple filtering rules, and match the data information of the fields with the same field type or field name in the relevant data records, and then the reconciliation result is considered normal. If the corresponding information is not the same, it is considered that the reconciliation result is abnormal. For example: if according to the filtering rules, a data record is found from the business data table, and the data record is associated with a voucher data in the bill data table (that is, the business data and the voucher data are records of an event), and the business data table also records that the amount consumed when the business is completed is 1000, and the data on the amount field of the corresponding voucher data in the bill data table is also 1000, then it is judged that the business data and the voucher data are the same, that is, the reconciliation result is consistent.

[0047] In some implementations of the present invention, the reconciliation plan table in the method includes a table header, a first table body, and a second table body corresponding to the data structure of the business system.

[0048] In this embodiment, it should be noted that in some implementations, the reconciliation plan table is at the user-visible layer or for the user who formulates the reconciliation plan, only part of the information needs to be provided. Other information has been acquired by the system or has been established in the reconciliation plan table by other users in the background, such as the location information of the database (the IP address of a server), the account and password for accessing the database, etc. This information is not visible to the user who formulates the reconciliation plan, but is actually used only to simplify the use of the reconciliation plan table.

[0049] In some embodiments of the present invention, in a reconciliation plan based on a certain department, the structure of the reconciliation plan table is simplified and upgraded, and a table header is established. The table header information includes:

[0050] The reconciliation plan number, name, business type, accounting organization, business record, account book, notes and other information. The reconciliation plan number refers to the unique identification of the reconciliation plan, and the name is specified by the user according to the actual reconciliation task; the business type is also customized by the user according to the business; the accounting organization is related to the business data table (mostly departments in actual implementation), that is, when performing reconciliation analysis on a department, it is necessary to find all business data related to the department from the business data table, so it is necessary to provide the identification information of the organization in the data table; the account book refers to the bill voucher data record generated by the department; the notes are the notes provided by the user on the reconciliation plan.

[0051] Furthermore, it also includes a first table body. The first table body corresponds to the information in the bill data table, that is, it is associated with the account book in the table header. For example, the table structure of the bill data table defined in a certain ERP system includes: document unique ID, reconciliation account, accounting dimension, data corresponding to the accounting dimension, general ledger voucher digit field-increase item, currency, bill voucher digit field-decrease item and other fields. The fields of the first table body in the ERP system are the above information.

[0052] In addition, it also includes the second table body, which corresponds to the information in the business data table, that is, it is related to the accounting organization in the table header. For example, the business data table structure defined in a certain ERP system includes: corresponding documents, accounting dimensions corresponding to document fields, field corresponding data, document filtering rules, document number field location, whether to enable formulas, formulas, document number field names, business data nature, reconciliation date dimensions, currencies, settlement organization fields, notes and other information. Among them, "accounting dimensions corresponding to document fields" is equivalent to the accounting dimensions in the billing data table. The corresponding document field records the information of the "Document Unique ID" field in the billing data table corresponding to the business data record; the document number field location corresponds to the difference between the "General Ledger Voucher Number Field-Increase Item" and "Billing Voucher Number Field-Decrease Item and Other Fields" in the billing data table.

[0053] It should be noted that although the information in the second table body and the first table body is taken from two data tables, it does not completely include the information of each field in the two data tables. It is only selectively added to the contents of the first table body and the second table body by the user based on the field information of the two data tables.

[0054] In some embodiments of the present invention, the method of establishing multiple filtering rules according to the user input and the reconciliation plan table includes:

[0055] Establishing global filtering rules according to the header of the reconciliation plan table;

[0056] Establishing a first filtering rule according to the user input and the first table body;

[0057] A second filtering rule is established according to the user input and the second table body.

[0058] In this embodiment, when the method of the present invention is specifically implemented, it is necessary to determine the reconciliation plan for the reconciliation, that is, to determine the operating entity of the reconciliation, which may be each individual department or the entire company.

[0059] Specifically, first establish a global filtering rule, and based on the format provided in the header of the reconciliation plan table, create a new reconciliation plan. The user needs to select the department (accounting organization) to be reconciled by the reconciliation plan, and then determine the business data table corresponding to the business data of the department (accounting organization) and the account book (bill data table) corresponding to the bill data. For example: create a global filtering rule, the rule data is as follows: G2021001, process department reconciliation 1, task-bill, P003 (process department ID), table_Task, Bill_data. Among them, G2021001 represents the number of the reconciliation plan represented by the global filtering rule; "Process Department Reconciliation 1" represents the name of the reconciliation plan; "Task-Bill" represents the business type of the reconciliation plan; "P003" represents the ID of the accounting organization of the reconciliation plan in the database; "table_Task" represents the business record table for recording business data of the operating entity (process department) reconciled by the reconciliation plan; "Bill_data" represents the account book of the operating entity (process department) reconciled by the reconciliation plan, that is, the bill data table.

[0060] In addition, a first filtering rule needs to be established based on the first table body. The user selects some fields in the first table body to create the first filtering rule according to the reconciliation requirements.

[0061] Specifically, the user selects one or more of the following fields: document unique ID, reconciliation subject, accounting dimension, data corresponding to the accounting dimension, account voucher number field - increase item, currency, bill voucher number field - decrease item, etc. to create the first filtering rule.

[0062] In addition, users are required to select corresponding fields from the second table body to create a second filtering rule according to their own reconciliation needs. Specifically, select one or more of the following information: "Corresponding document, accounting dimension corresponding document field, field corresponding data, document filtering rule, document digit field position, whether to enable formula, formula, document digit field name, business data nature, reconciliation date dimension, currency, settlement organization field, remarks" to create a second filtering rule.

[0063] In addition, it should be noted that the first filtering rule and the second filtering rule can be created based on the fields shown in the first table body and the second table body when they are created, or fields that do not exist in the first table body and the second table body can be entered as the first filtering rule or the second filtering rule based on the user's understanding of the business data table and the account book (bill data table) structure.

[0064] In some embodiments of the present invention, the method of filtering the credential data and / or business data of the business system according to the multiple filtering rules includes:

[0065] Filtering the credential data based on the global filtering rule to obtain primary credential data;

[0066] The service data is filtered based on the global filtering rule to obtain primary service data.

[0067] In this embodiment, after the global filtering rules are established, the ERP system in which the method provided by the present invention is located will perform filtering operations according to the global filtering rules to filter out data that meets the global filtering rules.

[0068] Specifically, according to the accounting organization information in the global filtering rules (department ID in some embodiments), in the business data table corresponding to the business record field, the data records in the business data table are filtered for the accounting organization according to the business record time specified when the global filtering rules are initially established, and all business data that meet the specified business record time are found and used as primary business data.

[0069] Furthermore, according to the accounting organization information in the global filtering rules (department ID in some embodiments), in the billing data table corresponding to the account book field, the data records in the billing data table for the accounting organization are screened according to the business record time specified when the global filtering rules are initially established, and all voucher data that meet the specified business record time are found and used as the first-level voucher data.

[0070] In some embodiments of the present invention, the method of filtering the credential data and / or business data of the business system according to the multiple filtering rules includes:

[0071] Filtering the first-level credential data based on the first filtering rule to obtain second-level credential data;

[0072] The primary business data is filtered based on the second filtering rule to obtain secondary business data.

[0073] In this embodiment, the primary credential data filtered by the global filtering rule is filtered again by the first filtering rule.

[0074] Specifically, the data structure of the voucher data in the primary voucher data is exactly the same as the bill in the bill data table, but because the data in many fields is of no value for reconciliation, it is necessary to filter the data of no value for reconciliation. When filtering, the fields in the first filtering rule are used as a comparison. If a field in the primary voucher data is included in the first filtering rule, the field data is retained. Otherwise, it is deleted. All voucher data in the primary voucher data are traversed and filtered according to the first filtering rule to obtain the secondary voucher data.

[0075] Similarly, the primary business data filtered by the global filtering rule is filtered again by the second filtering rule.

[0076] Specifically, the fields in the second filtering rule are used as the standard. If a field in the primary business data is included in the second filtering rule, the field data is retained, otherwise the content of the field is deleted. All business data in the primary business data are traversed and filtered according to the second filtering rule to obtain the secondary business data.

[0077] In addition, in some embodiments, when using the first filtering rule and the second filtering rule, a virtual data table is established to directly delete data whose field names are not in the first filtering rule or the second filtering rule. This requires a certain amount of data storage space, but can reduce the loss of processor performance.

[0078] In some embodiments of the present invention, the method of performing consistency judgment based on the filtering result of the data filtering and returning the judgment result includes:

[0079] Determining whether the values ​​of the same field of the secondary business data and the secondary credential data belonging to the same business event are consistent; and

[0080] The secondary business data and secondary voucher data with inconsistent judgment results are combined and exported as the result.

[0081] In this embodiment, after obtaining the secondary business data and the secondary voucher data after screening through the first filtering rule and the second filtering rule, all the voucher data of the secondary voucher data are traversed according to the information of the corresponding document field of the secondary business data, and each business record in the secondary business data is associated with the relevant data in the secondary voucher data. And the business data records and voucher data records with an associated relationship are analyzed. Specifically, the difference of the current period increase of the bill, the difference of the current period increase = the increase of the general ledger voucher data in the current period - the increase of the business data in the current period; the difference of the current period decrease = the decrease of the general ledger voucher data in the current period - the decrease of the business data in the current period, and the corresponding reconciliation result is obtained. If the difference of the current period increase and the difference of the current period decrease are both zero, then the reconciliation result is balanced, otherwise the reconciliation result is unbalanced. And the secondary business data and secondary voucher data with unbalanced reconciliation results are merged into a result and output to the corresponding display interface.

[0082] Here, it should be noted that, in the embodiment of the present invention, the content fields in the first table body and the second table body may be different in name, but the two fields in the two table bodies as correlations have the same field type in the corresponding content in their respective databases. For example, in the previous embodiment, the names of the two fields "general ledger voucher data reduction in this period" and "business data reduction in this period" seem to be different, because in the data tables of different databases, due to the habit of developers, there may be some identical data but with different field names in different data tables. Therefore, after establishing the first filtering rule and the second filtering rule, when comparing the secondary business data and the secondary voucher data, the user needs to establish a third mapping rule, and by specifying the two fields in the first table body and the second table body in the third mapping rule, the obtained secondary business data and the secondary voucher data are compared and processed before the reconciliation result can be output. When the system is executed, it can filter the business data and billing voucher data according to the first filtering rule and the second filtering rule set by the user to obtain the secondary business data and the secondary voucher data, and compare the relevant secondary business data and the secondary voucher data after the above filtering according to the paired associated fields in the mapping rule through the third mapping rule, and further output the result record of the comparison exception.

[0083] In some implementations of the present invention, the intersection of the fields in the first filtering rule in the method and the second filtering rule is not empty.

[0084] In this embodiment, the reconciliation plan does not strictly compare only the differences in accounts receivable, but can also compare records in other data tables or databases. However, when comparing, there must be the same fields in the first filter rule and the second filter rule or the data recorded in the database or data structure pointed to must be the same.

[0085] Therefore, the three filtering rules proposed in the present invention can be used for comparison and analysis of other businesses according to business needs. When used, it is only necessary to include the fields whose corresponding data may be the same into the first filtering rule or the second filtering rule. This can achieve the needs of different comparison tasks without modifying the business logic of the code.

[0086] like Figure 2 As shown, another aspect of the present invention provides a business data and voucher data reconciliation system 100 in an ERP business system, comprising:

[0087] Initialization module 1, configured to establish a reconciliation plan table according to the data structure of the business system;

[0088] Strategy module 2, configured to establish multiple filtering rules according to the user's input and the reconciliation plan table;

[0089] The execution module 3 is configured to perform data filtering on the credential data and / or business data of the business system according to the multiple filtering rules, perform consistency judgment based on the filtering results of the data filtering and return the judgment result.

[0090] like Figure 3 As shown, another aspect of the present invention provides a computer device, characterized in that it includes:

[0091] at least one processor 301; and

[0092] The memory 302 stores a computer program that can be run on the processor, and the processor executes the method described in any one of the above embodiments when executing the program.

[0093] like Figure 4 As shown, another aspect of the present invention provides a computer-readable storage medium 400, wherein the computer-readable storage medium 400 stores a computer program 402, wherein when the computer program is executed by a processor 401, the method described in any one of the above embodiments is executed.

[0094] The present invention has at least the following beneficial effects: a customizable reconciliation plan is provided, so that each enterprise can prepare different plans for different business types; it is convenient for users to operate, and users only need to set filtering rules according to the fields in the reconciliation plan table, and the plan will take effect without modifying any code; a reconciliation plan that can be customized for each business type is provided, which checks and verifies the general ledger voucher data and business data from different dimensions, so as to understand the enterprise situation in more detail and facilitate users to find problems in time; it reduces the enterprise's human resource investment and reduces the enterprise's costs.

Claims

1. A method for reconciling business data and voucher data in an ERP business system, characterized in that: include: Establishing a reconciliation plan table according to the data structure of the business system; Establishing multiple filtering rules according to the user's input and the reconciliation plan table; as well as Performing data filtering on the credential data and / or business data of the business system according to the multiple filtering rules, performing consistency judgment based on the filtering results of the data filtering and returning the judgment result; The establishing of the reconciliation plan table according to the data structure of the business system includes: Add the detailed data of all databases related to bills or general ledger voucher data in the ERP system or the field names corresponding to different data tables to the reconciliation plan table to establish a reconciliation plan table related to the reconciliation plan; The reconciliation plan table includes a table header, a first table body, and a second table body corresponding to the data structure of the business system; The establishing of multiple filtering rules according to the user input and the reconciliation plan table includes: Establishing global filtering rules according to the header of the reconciliation plan table; Establishing a first filtering rule according to the user input and the first table body; Establishing a second filtering rule according to the user input and the second table body; The filtering of the credential data and / or business data of the business system according to the multiple filtering rules comprises: Filtering the credential data based on the global filtering rule to obtain primary credential data; The service data is filtered based on the global filtering rule to obtain primary service data.

2. The method according to claim 1, characterized in that: The filtering of the credential data and / or business data of the business system according to the multiple filtering rules comprises: Filtering the first-level credential data based on the first filtering rule to obtain second-level credential data; The primary business data is filtered based on the second filtering rule to obtain secondary business data.

3. The method according to claim 2, characterized in that The performing consistency judgment based on the filtering result of the data filtering and returning the judgment result includes: Determining whether the values ​​of the same field of the secondary business data and the secondary credential data belonging to the same business event are consistent; and The secondary business data and secondary voucher data with inconsistent judgment results are combined and exported as the result.

4. The method according to claim 1, characterized in that: The intersection of the fields in the first filtering rule and the second filtering rule is not empty.

5. A business data and voucher data reconciliation system in an ERP business system, comprising: An initialization module configured to establish a reconciliation plan table according to the data structure of the business system; The step of establishing a reconciliation plan table according to the data structure of the business system includes: adding detailed data indications of all databases related to bills or general ledger voucher data in the ERP system or field names corresponding to different data tables to the reconciliation plan table to establish a reconciliation plan table related to the reconciliation plan; The reconciliation plan table includes a table header, a first table body, and a second table body corresponding to the data structure of the business system; a policy module configured to establish multiple filtering rules according to user input and the reconciliation plan table; the establishing multiple filtering rules according to user input and the reconciliation plan table includes: establishing a global filtering rule according to a table header of the reconciliation plan table; establishing a first filtering rule according to user input and the first table body; establishing a second filtering rule according to user input and the second table body; The filtering of the credential data and / or business data of the business system according to the multiple filtering rules includes: filtering the credential data based on the global filtering rules to obtain primary credential data; filtering the business data based on the global filtering rules to obtain primary business data; The execution module is configured to perform data filtering on the credential data and / or business data of the business system according to the multiple filtering rules, perform consistency judgment based on the filtering results of the data filtering and return the judgment result.

6. A computer device, characterized in that: include: at least one processor; as well as A memory storing a computer program executable on the processor, wherein the processor executes the method according to any one of claims 1 to 4 when executing the program.

7. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method according to any one of claims 1 to 4 is performed.