Report verification method, device and equipment based on check general table and storage medium

Abstract

The invention provides a report verification method, device and equipment based on a checking general table and a storage medium, and relates to the technical field of data processing. According to the method provided by the invention, automatic and centralized management of report verification is realized by configuring the verification general table. Through the report query instruction, the check formula in the check general table is analyzed, and the target report number and the target data position of the target attached report are quickly positioned, so that the report index value is efficiently acquired. Subsequently, the collected index value is verified by using the verification general table, and the report verification result is generated, so that the complexity of manual operation is reduced, the verification accuracy is improved, and the consistency and accuracy of reports are better ensured through a centralized verification process. And the efficiency and the effect of financial statement data verification are remarkably improved.

Description

Technical Field

[0001] The present application relates to the field of video retrieval technology, and in particular to a report verification method, device, equipment and storage medium based on a checksum table. Background Art

[0002] In the financial field, the financial reporting platform, as a data platform for companies to disclose annual reports, needs to provide annual report data to the financial planning office quickly and accurately.

[0003] Generally, there are many annotation reports on the financial reporting platform, and a large number of verifications need to be configured within and between reports to verify whether the data is accurate and consistent. Currently, the verification of financial data is usually configured in each report, and it is necessary to query each report one by one to check whether all the verifications have passed. It is impossible to have an overview of the verification differences of all reports, which wastes a lot of manpower and time.

[0004] Therefore, how to improve the efficiency of data verification of financial statements has become a technical problem that needs to be solved urgently. Summary of the invention

[0005] The present application provides a report verification method, device, equipment and storage medium based on a verification summary table, aiming to improve the data verification efficiency of financial statements.

[0006] In a first aspect, the present application provides a report verification method based on a verification summary table, the report verification method based on the verification summary table comprising the following steps:

[0007] Configure the checksum table;

[0008] Based on the report query instruction, the verification formula in the verification summary table is parsed to obtain a target report number and a target data location of at least one target annotation report;

[0009] Based on the target report number and the target data location, collecting the report indicator value of the target annotation report;

[0010] Based on the verification summary table, the report indicator values ​​are verified to generate report verification results.

[0011] In a second aspect, the present application further provides a report verification device based on a verification summary table, the report verification device based on the verification summary table comprising:

[0012] The total table configuration module is used to configure the verification total table;

[0013] A verification formula parsing module, used to parse the verification formula in the verification summary table based on the report query instruction, and obtain the target report number and target data position of at least one target annotation report;

[0014] A data collection module, used for collecting the report index value of the target annotation report based on the target report number and the target data position;

[0015] The report verification module is used to verify the report indicator value based on the verification summary table and generate a report verification result.

[0016] In a third aspect, the present application also provides a computer device, comprising a processor, a memory, and a computer program stored in the memory and executable by the processor, wherein when the computer program is executed by the processor, the steps of the report verification method based on the checksum table as described above are implemented.

[0017] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the steps of the report verification method based on the verification summary table as described above are implemented.

[0018] The present application provides a report verification method, device, computer equipment and storage medium based on a verification summary table. The present application method includes configuring a verification summary table; parsing the verification formula in the verification summary table based on a report query instruction to obtain a target report number and a target data position of at least one target annotation report; collecting the report index value of the target annotation report based on the target report number and the target data position; and verifying the report index value based on the verification summary table to generate a report verification result. In the above manner, the present application realizes the automation and centralized management of report verification by configuring a verification summary table. Through the report query instruction, the verification formula in the verification summary table is parsed to quickly locate the target report number and the target data position of the target annotation report, thereby efficiently collecting the report index value. Subsequently, the collected index value is verified using the verification summary table to generate a report verification result, which not only reduces the tediousness of manual operation and improves the accuracy of verification, but also through the centralized verification process, the consistency and accuracy between reports are better guaranteed, significantly improving the efficiency and effect of financial report data verification. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0020] Figure 1 A flowchart of a first embodiment of a report verification method based on a checksum table provided by the present application;

[0021] Figure 2 A schematic diagram of the table structure of a verification summary table provided in an embodiment of the present application;

[0022] Figure 3 It is a structural schematic diagram of a first embodiment of a report verification device based on a checksum table provided by the present application;

[0023] Figure 4 It is a schematic block diagram of the structure of a computer device provided in an embodiment of the present application.

[0024] The realization of the purpose, functional features and advantages of this application will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0025] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0026] The flowcharts shown in the accompanying drawings are only examples and do not necessarily include all the contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps may be decomposed, combined or partially merged, so the actual execution order may change according to actual conditions.

[0027] In conjunction with the accompanying drawings, some embodiments of the present application are described in detail below. In the absence of conflict, the following embodiments and features in the embodiments can be combined with each other.

[0028] Please refer to Figure 1 , Figure 1 A flowchart of a first embodiment of a report verification method based on a checksum table provided in the present application.

[0029] like Figure 1 As shown, the report verification method based on the verification summary table includes steps S101 to S104.

[0030] S101, configure the verification summary table;

[0031] In one embodiment, the checksum table can be configured by electronic spreadsheet software EXCEL, and all the annotation reports required by the checksum table are associated and statistically analyzed, including the report name, report number, report storage location and data structure in the report of the annotation report.

[0032] Exemplarily, the data structure within the report may include the data distribution within the note report, such as what types of data are included, what financial data each single element represents, etc. For example, the sales report of product A may include time, quantity, sales amount, quarterly sales volume, sales region, etc. Each product A has a corresponding data in each item. Therefore, the verification summary table can count the data structure of each note report, and then locate the report data of each cell in the note report for verification according to actual verification requirements.

[0033] Furthermore, based on the report verification requirements, a verification summary table is configured; based on at least one of the verification formulas in the verification summary table, the annotation report information of at least one annotation report is determined, wherein the annotation report information includes at least a report number and a report location; based on the annotation report information, each annotation report is associated with the verification summary table so that the verification summary table collects the report indicator value of the annotation report according to the annotation report information.

[0034] In one embodiment, the report verification requirement may be all verification items that the current user needs to perform report verification, such as balance sheet asset total verification, balance sheet liability total verification, and the like.

[0035] In one embodiment, according to the report verification requirements, the framework of the verification summary table is configured, and then according to the data requirements of the verification items, that is, the annotation reports required when executing the verification formulas of each verification item, the annotation report information of each annotation report is determined, which may include but is not limited to the report number, the storage location of the report and the report name.

[0036] Exemplarily, configuring the verification summary table may include steps such as defining verification rules, creating verification formulas, and associating annotation reports.

[0037] In a specific embodiment, the data items and rules to be verified can be identified according to the report verification requirements of the business personnel, and then the verification rules can be defined. Defining the verification rules includes determining the data type, range, and consistency rules to be verified.

[0038] In a specific embodiment, creating a verification formula refers to writing a corresponding formula or query statement for each verification rule in the verification summary table. Optionally, the verification formula can be written using Excel formula, SQL query or programming language.

[0039] In a specific embodiment, a data reference to the annotation report can be set in the verification summary table to realize the association of the annotation report with the verification summary table. Associating the annotation report can ensure that the verification summary table can reference all related annotation reports.

[0040] In one embodiment, each annotation report is associated with a verification summary table based on the annotation report information, and permissions for the verification summary table to access and retrieve data in the annotation report table are configured so that the verification summary table can automatically collect the report data required for the verification formula according to the report verification instructions.

[0041] In one embodiment, the verification summary table includes verification level, verification code, verification name, verification description, verification formula, verification difference and verification result, etc.

[0042] The verification level includes a verification summary layer and a verification detail layer. The verification summary layer is used to summarize the verification report information and the verification results, and the verification detail layer is used to calculate the verification indicator value.

[0043] For example, Figure 2 As shown, Figure 2 A schematic diagram of the table structure of a verification summary table provided in an embodiment of the present application. Specifically, column A is the verification level, 1 is the verification summary level, and 2 is the verification detail level, which can be scaled or expanded by grouping. Column B is the verification code, and the coding rule is report number + verification number. Column C is the verification name. Column D is the verification description. Columns E and F are configured with indicator formulas. At the verification detail level of level 2, they are configured according to the agreed formula GetSetValue(A,B). Parameter A is the report number, and parameter B is the cell of the report where the data to be verified is located. Set an EXCEL formula in the verification summary of level 1, and summarize the details under the verification. Column G is the verification difference column, and the difference formula is set according to the verification rules. Column H is the verification result column. If there is no difference in the verification, it will display OK, and if there is a difference, it will display wrong, and the background color will be highlighted in red.

[0044] Furthermore, after configuring the verification summary table, when it is detected that the note report associated with the verification summary table has a report modification, report modification information is generated; based on the report modification information, a verification formula update instruction is generated; based on the verification formula update instruction, the verification formula of the verification summary table is updated to adapt to the modified data position of the note report.

[0045] In one embodiment, a monitoring module such as a database trigger, a file monitoring tool, or a built-in function of a report management system can be used to monitor changes in the report. Whenever a modification of an annotation report is detected, the monitoring module can automatically record the detailed information of the modification and generate report modification information.

[0046] Exemplarily, the report modification information may include the report number and name of the modified annotation report, information about the person who modified it, the modification time, the modification item, the modification location, and the modification content, etc.

[0047] Among them, the report number is used as a unique identifier for the annotation report, which is convenient for accurately identifying and tracking the modified report. The report name can clearly describe the content and purpose of the report. The modification personnel information can include the name or ID of the person who performed the modification operation to ensure that the responsibility is assigned to the person. The modification time can include the specific date and time when the modification operation occurred, which is convenient for determining the most recent status of the report data. The modification item refers to the specific data item that is modified, such as financial data, sales data, etc. The modification location refers to the specific location of the modified data in the annotation report, such as the row number, column number or cell reference. The modification content can include a comparison of the data before and after the modification, including the old value and the new value.

[0048] In one embodiment, report modification may involve submitting modification instructions to the regulatory agency. For example, when the tax bureau modifies financial statements, it is necessary to provide a description of the data modification, including the reason, process and result of the modification, as well as relevant supporting documents. Therefore, report modification information may also include other modification record information, such as the reason for the modification, which is used to help other business personnel understand why the modification is needed, which may include data error correction, policy changes, market conditions changes, etc.; it may also include audit status, which is used to check whether the modification has been reviewed, and the name or ID of the reviewer, etc.; it may also include relevant attachment information, such as audit reports, policy documents, etc.

[0049] In one embodiment, report modification information can be recorded in a report modification log and may be tracked and managed through automated tools. For example, using Excel or professional report management software, tracking codes can be embedded in the report to automatically record modification information each time it is saved or submitted.

[0050] In one embodiment, the report modification information can be separately filed as a document recording the report data changes, so as to track each data update of the annotation report and the verification summary table, and ensure the transparency and auditability of the report data.

[0051] Optionally, all necessary report modification information is obtained from the monitoring module, and the report modification information data can be formatted into an easy-to-process format, such as JSON or XML, to achieve data normalization and facilitate accurate updating of the verification master table.

[0052] Optionally, the data in the verification master table and the annotation report can be compared periodically, such as traversing all the verification formulas in the verification master table to ensure that all the data required by each verification formula in the verification master table can be queried and called in the annotation report, thereby ensuring the validity of the verification formula and avoiding data omissions or errors.

[0053] This embodiment realizes the automation and centralized management of report verification by configuring the verification summary table. When a modification of the annotation report is detected, the report modification information can be generated in time, and the verification formula update instruction is generated based on this information, which will automatically update the verification formula in the verification summary table to adapt to the change of the report data location. This automated update mechanism not only improves the efficiency of report verification, but also reduces the errors that may be caused by manual updates, ensuring the accuracy and consistency of report data. In this way, enterprises can respond to changes in reports more quickly, save a lot of human resources, and improve the overall quality of financial reports.

[0054] S102, based on the report query instruction, parsing the verification formula in the verification master table to obtain a target report number and a target data position of at least one target annotation report;

[0055] In one embodiment, a Java program is developed and bound to a verification summary table. When a report query is clicked, the Java program parses the verification formula, obtains the report number and location in the formula, finds the corresponding indicator ID, and then searches the report indicator result table for the report indicator value, and displays the result in the report query interface.

[0056] For example, open the financial report platform, select the note verification table, select the query date and account set entity, and click query to view the overall situation of all verifications under the bank account set.

[0057] Further, based on the report query instruction, the verification number and verification name of the report verification operation are determined; based on the verification number and the verification name, the verification formula is determined; based on the verification formula, the target report number and target data location of the target annotation report are determined.

[0058] In one embodiment, the report query instruction may be a request initiated by a user terminal and containing feature query conditions. According to the report query instruction, a verification formula for the verification operation request is matched in the verification summary table, and the number and data location information of the target annotation report are extracted from the verification formula.

[0059] The verification formula can be in the form of cell reference, named range or direct value.

[0060] In one embodiment, according to the parameters in the report query instruction, the check total table or database is queried to determine the corresponding check number and check name, so as to quickly locate the specific check item. The check number and check name are used to screen out the specific check item in the check total table. The check formula under the check item is the check formula required by the current check request. The check formula is parsed grammatically and logically to determine the data type required to constitute the check formula, and then the target annotation report where the data required by the check formula is located is located, and then the target report number and target data position of the target annotation report are determined.

[0061] The target data location refers to the cell location of the data required to form the verification formula in the target note report.

[0062] For example, a user submits a query request through the system interface to generate a report query instruction, and the request contains the check number "CHK12345". Based on the received check number, the system searches for the corresponding check operation in the check total table and finds the check name "quarterly sales data check". The check formula corresponding to the check name "quarterly sales data check" is retrieved as =SUM(Sheet2!D4:D15)-'AP-2024-Q3'!C3. By analyzing the check formula, the target report number "AP-2024-Q3" can be extracted, and the target data location is the "C3" cell.

[0063] S103, based on the target report number and the target data position, collecting the report indicator value of the target annotation report;

[0064] Furthermore, based on the target report number, the storage location of the target note report is determined, and according to the storage location, the target note report is retrieved; based on the target data location, the cell position of the report indicator value in the target note report is determined; and the report data corresponding to the cell position is collected to obtain the report indicator value.

[0065] In one embodiment, according to the report number, the database, file system or report management platform storing the report is accessed to locate the specific location storing the target report, and the report number is used to find and locate the specific target annotation report in the storage system to find the accurate report document containing the target data. The target annotation report is opened, and according to the provided data location, such as cell reference (e.g., "C3" in Excel), row number and column number, etc., the target data location in the target annotation report is navigated to collect the report indicator value from the target data location. This may include reading the value, text or other data types of the cell.

[0066] Specifically, use the target report number to query the report management system or file index database to obtain the storage path or URL of the report and find the exact location where the target annotation report is stored. Based on the obtained storage location, access the file system, database or network location to retrieve the target annotation report, use an appropriate application (such as Excel, PDF reader or professional report viewer) to open the retrieved target annotation report, and find the corresponding cell in the open report based on the provided target data location (such as cell reference "C3"). Read the data in the target cell, which can include numeric values, text, dates or other data types.

[0067] S104: Based on the verification summary table, verify the report indicator value and generate a report verification result.

[0068] In one embodiment, verification rules and formulas are extracted from the verification summary table, and these rules define how to verify the report data. The verification formula is applied to calculate and verify the collected data, and a report verification result report can be generated based on the verification result and fed back to the verification request end.

[0069] For example, suppose there is a financial statement verification task that needs to verify the accuracy of the quarterly sales total. First, obtain the verification rules from the verification summary table, which may involve the consistency of the sales total and the tax report. Then, determine that the verification target is the quarterly sales total, access the report storage system, and retrieve the quarterly sales report numbered "QS-2024-Q3". Locate the data location "F10" cell in the report and collect the sales total data at this location. Use the verification formula to calculate and verify the data, record the verification results, and generate a detailed report including whether the verification is passed.

[0070] Furthermore, based on the verification formula in the verification summary table, the report indicator value is verified and calculated, and the report verification result is output; when the report verification result is normal, the target annotation report is marked as a first verification label; when the report verification result is abnormal, the target annotation report is marked as a second verification label.

[0071] In one embodiment, a verification formula for verifying the report indicator value is extracted from the verification summary table, and the report indicator value required for the current verification operation is collected from the annotation report according to the data composition of the verification formula, and the collected report indicator value is calculated using the extracted verification formula, and the verification calculation result is output to form the report verification result. The verification calculation result can be a specific difference value, or a comparison result of two data, such as the indicator difference value of the same indicator in the same report at different times, or whether the report indicator values ​​of the same indicator in two different reports at the same time are the same.

[0072] In one embodiment, if the verification result is normal, the target annotation report is marked with a first verification mark, such as "passed", "qualified" or "normal verification". If the verification result is abnormal, the target annotation report is marked with a "second verification label", such as "failed", "unqualified" or "abnormal verification". Alternatively, the report verification result can also be marked by cell color in the verification summary table, such as normal verification result is marked in green, and abnormal verification result is marked in red. This provides a clear mark for the verified annotation report data, which is convenient for management and review.

[0073] This embodiment provides a report verification method based on a verification summary table. The present application method realizes the automation and centralized management of report verification by configuring the verification summary table. Through the report query instruction, the verification formula in the verification summary table is parsed, and the target report number and target data position of the target annotation report are quickly located, so as to efficiently collect the report index value. Subsequently, the collected index value is verified using the verification summary table to generate the report verification result, which not only reduces the tediousness of manual operation and improves the accuracy of verification, but also through the centralized verification process, the consistency and accuracy between reports are better guaranteed, which significantly improves the efficiency and effect of financial report data verification.

[0074] See also Figure 3 , Figure 3 It is a structural schematic diagram of a first embodiment of a report verification device based on a checksum table provided in the present application. The report verification device based on a checksum table is used to execute the aforementioned report verification method based on a checksum table.

[0075] like Figure 3 As shown, the report verification device 200 based on the verification master table includes: a master table configuration module 201, a verification formula analysis module 202, a data collection module 203 and a report verification module 204.

[0076] The total table configuration module 201 is used to configure the verification total table;

[0077] The verification formula parsing module 202 is used to parse the verification formula in the verification summary table based on the report query instruction to obtain the target report number and target data position of at least one target annotation report;

[0078] The data collection module 203 is used to collect the report index value of the target annotation report based on the target report number and the target data position;

[0079] The report verification module 204 is used to verify the report indicator value based on the verification summary table and generate a report verification result.

[0080] In one embodiment, the verification formula parsing module 202 includes:

[0081] A verification operation determining unit, used to determine a verification number and a verification name of a report verification operation based on the report query instruction;

[0082] A verification formula determination unit, configured to determine the verification formula based on the verification number and the verification name;

[0083] The target annotation report determination unit is used to determine the target report number and target data position of the target annotation report based on the verification formula.

[0084] In one embodiment, the report verification module 204 includes:

[0085] A verification result output unit, used to perform verification calculation on the report indicator value based on the verification formula in the verification summary table, and output the report verification result;

[0086] A first marking unit, configured to mark the target annotation report as a first verification label when the report verification result is normal;

[0087] The second marking unit is used to mark the target annotated report as a second verification label when the report verification result is abnormal.

[0088] In one embodiment, the master table configuration module 201 includes:

[0089] The total table configuration unit is used to configure the verification total table based on the report verification requirements;

[0090] An annotation report information determination unit, configured to determine annotation report information of at least one annotation report based on at least one of the verification formulas in the verification master table, wherein the annotation report information at least includes a report number and a report position;

[0091] A report associating unit is used to associate each of the annotation reports with the verification summary table based on the annotation report information, so that the verification summary table collects the report indicator value of the annotation report according to the annotation report information.

[0092] In one embodiment, the report verification device 200 based on the verification summary table further includes a report updating module, including:

[0093] A report modification information generating unit, configured to generate report modification information when detecting that the note report associated with the verification master table has been modified;

[0094] An update instruction generating unit, used for generating a verification formula update instruction based on the report modification information;

[0095] A report updating unit is used to update the verification formula of the verification summary table based on the verification formula update instruction to adapt to the modified data position of the annotation report.

[0096] In one embodiment, the data acquisition module 203 includes:

[0097] An annotation report retrieval unit, used to determine the storage location of the target annotation report based on the target report number, and retrieve the target annotation report according to the storage location;

[0098] A data position determination unit, used to determine the cell position of the report indicator value in the target annotation report based on the target data position;

[0099] The data collection unit is used to collect the report data corresponding to the cell position and obtain the report indicator value.

[0100] In one embodiment, the verification summary table includes verification level, verification code, verification name, verification description, verification formula, verification difference and verification result;

[0101] The verification level includes a verification summary layer and a verification detail layer. The verification summary layer is used to summarize the verification report information and the verification results, and the verification detail layer is used to calculate the verification indicator value.

[0102] It should be noted that technical personnel in the relevant field can clearly understand that for the convenience and conciseness of description, the specific working process of the above-described device and each module can refer to the corresponding process in the aforementioned report verification method embodiment based on the verification summary table, and will not be repeated here.

[0103] The apparatus provided in the above embodiment may be implemented in the form of a computer program. The computer program may be Figure 4 Runs on the computer device shown.

[0104] See also Figure 4 , Figure 4 1 is a schematic block diagram of a computer device provided in an embodiment of the present application. The computer device may be a server.

[0105] See also Figure 4 The computer device includes a processor, a memory and a network interface connected through a system bus, wherein the memory may include a non-volatile storage medium and an internal memory.

[0106] The non-volatile storage medium can store an operating system and a computer program. The computer program includes program instructions, and when the program instructions are executed, the processor can execute any report verification method based on the checksum table.

[0107] The processor is used to provide computing and control capabilities and support the operation of the entire computer equipment.

[0108] The internal memory provides an environment for the operation of the computer program in the non-volatile storage medium. When the computer program is executed by the processor, the processor can execute any report verification method based on the checksum table.

[0109] The network interface is used for network communication, such as sending assigned tasks, etc. Those skilled in the art will understand that Figure 4 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0110] It should be understood that the processor may be a central processing unit (CPU), and the processor may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0111] In one embodiment, the processor is used to run a computer program stored in the memory to implement the following steps:

[0112] Configure the checksum table;

[0113] Based on the report query instruction, the verification formula in the verification summary table is parsed to obtain a target report number and a target data location of at least one target annotation report;

[0114] Based on the target report number and the target data location, collecting the report indicator value of the target annotation report;

[0115] Based on the verification summary table, the report indicator values ​​are verified to generate report verification results.

[0116] In one embodiment, when the processor implements the report query instruction, parses the verification formula in the verification summary table, and obtains the target report number and target data location of at least one target annotation report, it is used to implement:

[0117] Based on the report query instruction, determine the verification number and verification name of the report verification operation;

[0118] Determining the calibration formula based on the calibration number and the calibration name;

[0119] Based on the verification formula, a target report number and a target data position of the target annotation report are determined.

[0120] In one embodiment, when the processor verifies the report indicator value based on the verification summary table and generates a report verification result, it is used to implement:

[0121] Based on the verification formula in the verification summary table, the report indicator value is verified and calculated, and the report verification result is output;

[0122] When the report verification result is normal, marking the target annotation report as a first verification tag;

[0123] When the report verification result is abnormal, the target annotation report is marked as a second verification tag.

[0124] In one embodiment, when implementing the configuration verification summary table, the processor is used to implement:

[0125] Configure the verification summary table based on report verification requirements;

[0126] Determine, based on at least one of the verification formulas in the verification master table, annotation report information of at least one annotation report, wherein the annotation report information at least includes a report number and a report location;

[0127] Based on the annotation report information, each annotation report is associated with the verification summary table, so that the verification summary table collects the report indicator value of the annotation report according to the annotation report information.

[0128] In one embodiment, after implementing the configuration verification summary table, the processor is further configured to implement:

[0129] When it is detected that the note report associated with the verification summary table has a report modification, report modification information is generated;

[0130] Based on the report modification information, generate a verification formula update instruction;

[0131] Based on the verification formula update instruction, the verification formula of the verification summary table is updated to adapt to the modified data position of the annotation report.

[0132] In one embodiment, when the processor collects the report indicator value of the target annotation report based on the target report number and the target data position, it is used to implement:

[0133] Based on the target report number, determining the storage location of the target annotation report, and retrieving the target annotation report according to the storage location;

[0134] Based on the target data location, determining the cell location of the report indicator value in the target annotation report;

[0135] The report data corresponding to the cell position is collected to obtain the report indicator value.

[0136] In one embodiment, the verification summary table includes verification level, verification code, verification name, verification description, verification formula, verification difference and verification result;

[0137] The verification level includes a verification summary layer and a verification detail layer. The verification summary layer is used to summarize the verification report information and the verification results, and the verification detail layer is used to calculate the verification indicator value.

[0138] A computer-readable storage medium is also provided in an embodiment of the present application, wherein the computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and the processor executes the program instructions to implement any report verification method based on a checksum table provided in an embodiment of the present application.

[0139] The computer-readable storage medium may be an internal storage unit of the computer device described in the foregoing embodiment, such as a hard disk or memory of the computer device. The computer-readable storage medium may also be an external storage device of the computer device, such as a plug-in hard disk, a smart memory card (SmartMedia Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), etc., equipped on the computer device.

[0140] The above are only specific implementations of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present application, and these modifications or replacements should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.

Claims

1. A report verification method based on a checksum table, characterized in that: The method comprises: Configure the checksum table; Based on the report query instruction, the verification formula in the verification summary table is parsed to obtain a target report number and a target data location of at least one target annotation report; Based on the target report number and the target data location, collecting the report indicator value of the target annotation report; Based on the verification summary table, the report indicator values ​​are verified to generate report verification results.

2. The report verification method based on the verification summary table according to claim 1 is characterized in that: The method of parsing the verification formula in the verification summary table based on the report query instruction to obtain the target report number and target data location of at least one target annotation report includes: Based on the report query instruction, determine the verification number and verification name of the report verification operation; Determining the calibration formula based on the calibration number and the calibration name; Based on the verification formula, a target report number and a target data position of the target annotation report are determined.

3. The report verification method based on the checksum table according to claim 1 is characterized in that: The verifying the report indicator value based on the verification summary table to generate a report verification result includes: Based on the verification formula in the verification summary table, the report indicator value is verified and calculated, and the report verification result is output; When the report verification result is normal, marking the target annotation report as a first verification tag; When the report verification result is abnormal, the target annotation report is marked as a second verification tag.

4. The report verification method based on the checksum table according to claim 1 is characterized in that: The configuration verification summary table includes: Configure the verification summary table based on report verification requirements; Determine, based on at least one of the verification formulas in the verification master table, annotation report information of at least one annotation report, wherein the annotation report information at least includes a report number and a report location; Based on the annotation report information, each annotation report is associated with the verification summary table, so that the verification summary table collects the report indicator value of the annotation report according to the annotation report information.

5. The report verification method based on the checksum table according to claim 1 is characterized in that: After configuring the verification summary table, it also includes: When it is detected that the note report associated with the verification summary table has a report modification, report modification information is generated; Based on the report modification information, generate a verification formula update instruction; Based on the verification formula update instruction, the verification formula of the verification summary table is updated to adapt to the modified data position of the annotation report.

6. The report verification method based on the checksum table according to claim 1 is characterized in that: The step of collecting the report indicator value of the target annotation report based on the target report number and the target data position includes: Based on the target report number, determining the storage location of the target annotation report, and retrieving the target annotation report according to the storage location; Based on the target data location, determining the cell location of the report indicator value in the target annotation report; The report data corresponding to the cell position is collected to obtain the report indicator value.

7. The report verification method based on the checksum table according to claim 1 is characterized in that: The verification summary table includes verification level, verification code, verification name, verification description, verification formula, verification difference and verification result; The verification level includes a verification summary layer and a verification detail layer. The verification summary layer is used to summarize the verification report information and the verification results, and the verification detail layer is used to calculate the verification indicator value.

8. A report verification device based on a checksum table, characterized in that: The report verification device based on the verification summary table includes: The total table configuration module is used to configure the verification total table; A verification formula parsing module, used to parse the verification formula in the verification summary table based on the report query instruction, and obtain the target report number and target data position of at least one target annotation report; A data collection module, used for collecting the report index value of the target annotation report based on the target report number and the target data position; The report verification module is used to verify the report indicator value based on the verification summary table and generate a report verification result.

9. A computer device, characterized in that: The computer device includes a processor, a memory, and a computer program stored in the memory and executable by the processor, wherein when the computer program is executed by the processor, the steps of the report verification method based on the checksum table as described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, wherein when the computer program is executed by a processor, the steps of the report verification method based on the checksum table as described in any one of claims 1 to 7 are implemented.

Images