Data checking method and device, electronic equipment and readable storage medium

Abstract

The invention relates to a data checking method and device, electronic equipment and a readable storage medium. Type recognition can be performed on an acquired bill image. And according to the identified classification of the bill image, calling a corresponding data extraction template to extract preset key data from the bill image. And checking the extracted preset key data according to a checking algorithm corresponding to the preset key data. After accounting is completed, according to the archiving process of the business to which the bill image belongs, the bill image after accounting is archived, and accounting and archiving of the bill data are achieved. The whole accounting process of feature extraction, comparison, checking and filing can be automatically carried out in the whole process, compared with a manual processing mode, the data accounting efficiency is improved, and the accuracy and reliability of data accounting can be ensured.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a data checking method, device, electronic device and readable storage medium. Background Art

[0002] As the scale of modern enterprises continues to expand, the businesses involved will be scattered in various regions. Especially for energy-based enterprises, relevant business personnel are distributed in various regions across the country. In the process of related transactions, due to differences in the contents of bank receipts and business receipts in various places, most of the bills and business content verification requires business personnel to manually sort out the data offline, such as verifying the collected data, amount verification, date verification, calculating and summarizing the verified data and comparing it with the SAP system (financial management system) and bank flow data, completing voucher production, data archiving and other operations. The whole process is not only inefficient, but also requires specialized personnel to handle, and has high labor costs. Summary of the invention

[0003] The present invention provides a data checking method, device, electronic device and readable storage medium, which can improve the efficiency of data checking and reduce labor costs.

[0004] To achieve the above object, the present invention provides the following technical solutions:

[0005] A data verification method provided according to a specific embodiment of the present invention includes:

[0006] Perform type recognition on the acquired bill image;

[0007] Based on the category to which the bill image belongs, calling a corresponding data extraction template to extract preset key data from the bill image;

[0008] Calculating the preset key data based on a checking algorithm corresponding to the preset key data;

[0009] Based on the filing process of the business to which the bill image belongs, the calculated bill image is filed.

[0010] Furthermore, before the type of the acquired bill image is identified, the method further includes:

[0011] The table and text content in the bill image are identified, and the content is divided and extracted according to the identification result.

[0012] Furthermore, the data verification method further includes:

[0013] If the type of the bill image is not identified, the preset key data is extracted from the bill image based on a preset general template.

[0014] Furthermore, the data verification method further includes:

[0015] Process, summarize and distribute daily archived data based on the daily analysis template.

[0016] Furthermore, the archiving process of the business to which the bill image belongs, archiving the calculated bill image, includes:

[0017] The accounting information, daily verification information and circulation process information associated with the bill image are stored in the filing system.

[0018] Furthermore, based on the category to which the bill image belongs, calling a corresponding data extraction template to extract preset key data from the bill image includes:

[0019] Determining the category to which the bill image belongs according to the type of the bank to which the bill image belongs and the associated bill type;

[0020] The preset key data is extracted from the bill image according to the data extraction template determined according to the associated bill type.

[0021] Furthermore, the data verification method further includes:

[0022] When calculating the preset key data, the preset key data is associated and calculated based on the data interaction relationship recorded in the preset communication template.

[0023] A data checking device provided according to a specific embodiment of the present invention includes:

[0024] A bill recognition module is used to identify the type of the acquired bill image;

[0025] A data extraction module, used to extract preset key data from the bill image by calling a corresponding data extraction template based on the category to which the bill image belongs;

[0026] A data accounting module is used to calculate the preset key data based on the verification algorithm corresponding to the preset key data; and a data archiving module is used to archive the calculated bill image based on the archiving process of the business to which the bill image belongs.

[0027] An electronic device provided according to a specific embodiment of the present invention includes: a memory and a processor;

[0028] The memory is used to store programs;

[0029] The processor is used to execute the program to implement the various steps of the data verification method described above.

[0030] According to a specific embodiment of the present invention, a readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, each step of the data verification method described above is implemented.

[0031] It can be seen from the above technical solutions that the present invention discloses a data verification method, which can be performed by identifying the type of the acquired bill image. Then, according to the category to which the identified bill image belongs, the corresponding data extraction template is called to extract the preset key data from the bill image. According to the verification algorithm corresponding to the preset key data, the extracted preset key data is calculated. After the calculation is completed, the calculated bill image can be archived according to the archiving process of the business to which the bill image belongs, so as to realize the accounting and archiving of the bill data. The entire process can automatically perform the entire accounting process of feature extraction, comparison, verification, and archiving, which improves the efficiency of data accounting compared to manual processing and can ensure the accuracy and reliability of data accounting. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] 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 described below are only 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.

[0033] Figure 1 A flow chart of a data verification method provided by an embodiment of the present invention;

[0034] Figure 2 A system architecture diagram for the data verification method provided in the embodiment of the present invention;

[0035] Figure 3 A processing diagram of the middle platform system provided in an embodiment of the present invention;

[0036] Figure 4 A structural diagram of a data checking device provided by an embodiment of the present invention;

[0037] Figure 5 A structural diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0038] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only 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.

[0039] Reference Figure 1 As shown, an embodiment of the present invention provides a data verification method, which may include the following steps:

[0040] 101. Perform type recognition on the acquired bill image.

[0041] Specifically, the staff can upload various data containing bill images according to the calculation date according to the cycle or time required for data calculation. The bill images that can be uploaded may include images of bank receipts, receipts, EXCEL tables, etc. The staff can obtain and upload bill images through office software, video recording equipment, etc. After obtaining the bill images provided by the staff, the bill images can be pre-processed and identified, and targeted extraction can be performed for different types of bill images, such as using OCR recognition technology to identify the format of the bill images, and classifying and identifying the bill images according to the consensus features of the identified bill images. In this way, the type of bill image can be identified in advance on the basis of the bill image, such as the type of bills such as bank receipts and payment receipts.

[0042] 102. Based on the category to which the bill image belongs, a corresponding data extraction template is called to extract preset key data from the bill image.

[0043] Specifically, after determining the category to which the bill image that needs to be calculated belongs, key data of the bill can be extracted according to the data extraction template pre-set for each category, such as the total amount on the bill, the remaining amount and other key accounting data can be extracted and recorded.

[0044] 103. Calculate the preset key data based on the verification algorithm corresponding to the preset key data.

[0045] Specifically, according to the accounting rules or verification process determined by the business corresponding to the extracted key data, the extracted key data is calculated and verified according to the rules. For example, to calculate the daily turnover of a gas station, an amount can be calculated by extracting the key data from the daily bill image, and then the daily turnover of the gas station is queried according to the bank or other financial institution to which the bill belongs to obtain a query amount. The calculation of the key data of turnover is realized by comparing the two amounts obtained above.

[0046] 104. Based on the archiving process of the business to which the bill image belongs, archive the calculated bill image.

[0047] Specifically, after the key data is calculated, the bill can be archived according to the business system to which the bill belongs, and the business data related to the bill can be written back to the corresponding business system, thereby realizing the business accounting process without the perception of the business personnel. This data verification method can realize the complete process of automatic recognition, verification and archiving of bill images. Compared with the manual classification, verification, accounting and archiving operation mode, it improves the standardization of the daily report processing process and has higher accounting speed and reliability.

[0048] In another specific embodiment of the present invention, before the type recognition is performed on the acquired bill image, the following steps may be further included:

[0049] Recognize the table and text content in the bill image, and divide and extract the content based on the recognition results.

[0050] Specifically, the bills involved in the accounting may include bank receipts of different types from different banks in different regions, receipts from different banks or different POS machines, customized excel account adjustments, pre-collection slips, internal customized bills, etc. Based on the commonality between bills, these bills are generally composed of tables and texts. By identifying the common features, the bill types can be distinguished based on the type and content of the table, further improving the efficiency of bill identification and accounting.

[0051] When extracting key data, the category to which the bill image belongs can be determined based on the type of bank to which the bill image belongs and the associated bill type, and then preset key data can be extracted from the bill image based on the data extraction template determined by the associated bill type.

[0052] In addition, in some special cases, if the type of bill image is not identified, the preset key data of the bill image can be extracted based on the preset general template. For example, for some user-defined bills, whose content and format are different from normal bills, the data can be extracted using a general template based on the extracted key data to realize online processing of the bill.

[0053] It also supports users to process, summarize and distribute the daily archived data based on the daily analysis template. The corresponding daily analysis template can be set according to different accounting businesses to summarize and distribute the daily verified data according to different businesses.

[0054] When the bill archiving process is performed after accounting, the accounting information, daily verification information and circulation process information associated with the bill image can be stored in the archiving system. That is, the data of the normal circulation process such as data collection, daily verification, voucher production, and accounting that have been completed will be uniformly archived into the corresponding business archiving system, including image bills, accounting information, daily information, etc.

[0055] In some specific embodiments of the present invention, considering the data accounting of multiple parties that may be involved, when calculating the preset key data, the preset key data can be associated and calculated based on the data interaction relationship recorded in the preset communication template. For example, the daily turnover of a gas station needs to be associated with the gas filling volume, so as to more accurately calculate the daily turnover.

[0056] As a specific application of the above embodiment, the data verification method can be applied in Figure 2 In the middle platform system shown, the middle platform system maintenance interface, daily analysis module, daily data module, RPA communication module and basic module are composed. The daily data module uploads the daily data provided by CCS (load control system), gas station and image library in the external system to the daily analysis module. The data of the SAP system is uploaded to the daily analysis module by the RPA communication module. The daily analysis module introduces the image and text recognition technology provided by the big data platform through the basic module, performs the processing flow of the above data verification method, and realizes the data recognition, extraction, classification, processing and other processes.

[0057] Among them, reference Figure 3 The data interaction structure diagram between the middle office system and various external systems shown in the figure uses two RPA servers to link the SAP system, UnionPay system, and middle office system. The middle office system actively calls the data in the RPA server to perform data verification operations such as bill verification, bill identification, and bill reconciliation. Then the corresponding business data is written back to the corresponding system through the RPA server, thereby realizing the business personnel's non-perceptual business process. By pre-collecting and aggregating the data of all business systems, different business operations, data extraction, and data verification are completed through non-perceptual operations in the background. Compared with the methods of manual classification, verification, accounting, and archiving, the standardization of the daily report process is improved, and the speed of identification, verification, accounting, archiving, etc. is accelerated, with a higher accuracy rate.

[0058] It is understandable that those skilled in the art may also apply the data verification method to other energy accounting systems, without limitation herein.

[0059] Reference Figure 4As shown, an embodiment of the present invention further provides a data checking device, which, when running, can implement each step of the above data checking method, and the device may include:

[0060] The bill recognition module 401 is used to perform type recognition on the acquired bill image.

[0061] The data extraction module 402 is used to extract preset key data from the bill image by calling a corresponding data extraction template based on the category to which the bill image belongs.

[0062] The data calculation module 403 is used to calculate the preset key data based on the verification algorithm corresponding to the preset key data.

[0063] The data archiving module 404 is used to archive the calculated bill images based on the archiving process of the business to which the bill images belong.

[0064] Furthermore, the bill identification module 401 is also used for:

[0065] The table and text content in the bill image are identified, and the content is divided and extracted according to the identification result.

[0066] Furthermore, the data extraction module 402 is also used for:

[0067] If the type of the bill image is not identified, the preset key data is extracted from the bill image based on a preset general template.

[0068] Furthermore, the data accounting module 403 is also used for:

[0069] Process, summarize and distribute daily archived data based on the daily analysis template.

[0070] Furthermore, the data archiving module 404 is specifically used for:

[0071] The accounting information, daily verification information and circulation process information associated with the bill image are stored in the filing system.

[0072] Furthermore, the data extraction module 402 is specifically used for:

[0073] The category to which the bill image belongs is determined according to the type of the bank to which the bill image belongs and the associated bill type.

[0074] The preset key data is extracted from the bill image according to the data extraction template determined according to the associated bill type.

[0075] Furthermore, the data accounting module 403 is also used for:

[0076] When calculating the preset key data, the preset key data is associated and calculated based on the data interaction relationship recorded in the preset communication template.

[0077] Reference Figure 5 As shown, an embodiment of the present invention further provides an electronic device, which may include: a memory 501 and a processor 502 .

[0078] The memory 501 is used to store programs.

[0079] The processor 502 is used to execute the program to implement the various steps of the data verification method described in the above embodiment.

[0080] An embodiment of the present invention further provides a readable storage medium on which a computer program is stored. When the computer program is executed by a processor, each step of the data verification method described in the above embodiment is implemented.

[0081] For the above-mentioned method embodiments, for the sake of simplicity, they are all described as a series of action combinations, but those skilled in the art should know that the present invention is not limited by the order of the actions described, because according to the present invention, some steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present invention.

[0082] It should be noted that each embodiment in this specification is described in a progressive manner, and each embodiment focuses on the differences from other embodiments, and the same or similar parts between the embodiments can be referred to each other. For the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0083] The steps in the methods of the embodiments of the present invention may be adjusted in order, combined, or deleted according to actual needs, and the technical features recorded in the embodiments may be replaced or combined.

[0084] The modules and sub-modules in the devices and terminals of the various embodiments of the present invention may be combined, divided, or deleted according to actual needs.

[0085] In the several embodiments provided by the present invention, it should be understood that the disclosed terminals, devices and methods can be implemented in other ways. For example, the terminal embodiments described above are only schematic, for example, the division of modules or submodules is only a logical function division, and there may be other division methods in actual implementation, such as multiple submodules or modules can be combined or integrated into another module, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or modules, which can be electrical, mechanical or other forms.

[0086] The modules or submodules described as separate components may or may not be physically separated, and the components of the modules or submodules may or may not be physical modules or submodules, that is, they may be located in one place, or they may be distributed on multiple network modules or submodules. Some or all of the modules or submodules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0087] In addition, each functional module or submodule in each embodiment of the present invention may be integrated into one processing module, or each module or submodule may exist physically separately, or two or more modules or submodules may be integrated into one module. The above-mentioned integrated modules or submodules may be implemented in the form of hardware or in the form of software functional modules or submodules.

[0088] Professionals may further appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in the above description according to function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians may use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0089] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented directly by hardware, software units executed by a processor, or a combination of the two. The software units may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0090] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0091] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A data verification method, characterized in that: include: Perform type recognition on the acquired bill image; Based on the category to which the bill image belongs, calling a corresponding data extraction template to extract preset key data from the bill image; Calculating the preset key data based on a checking algorithm corresponding to the preset key data; Based on the filing process of the business to which the bill image belongs, the calculated bill image is filed.

2. The data checking method according to claim 1, characterized in that: Before the type recognition is performed on the acquired bill image, the following steps are also included: The table and text content in the bill image are identified, and the content is divided and extracted according to the identification result.

3. The data checking method according to claim 1, characterized in that: Also includes: If the type of the bill image is not identified, the preset key data is extracted from the bill image based on a preset general template.

4. The data checking method according to claim 1, characterized in that: Also includes: Process, summarize and distribute daily archived data based on the daily analysis template.

5. The data checking method according to claim 1, characterized in that: The archiving process based on the business to which the bill image belongs, archiving the calculated bill image, includes: The accounting information, daily verification information and circulation process information associated with the bill image are stored in the filing system.

6. The data checking method according to claim 1, characterized in that: The extracting preset key data from the bill image by calling a corresponding data extraction template based on the category to which the bill image belongs includes: Determining the category to which the bill image belongs according to the type of the bank to which the bill image belongs and the associated bill type; The preset key data is extracted from the bill image according to the data extraction template determined according to the associated bill type.

7. The data checking method according to claim 1, characterized in that: Also includes: When calculating the preset key data, the preset key data is associated and calculated based on the data interaction relationship recorded in the preset communication template.

8. A data checking device, characterized in that: include: A bill recognition module is used to identify the type of the acquired bill image; A data extraction module, used to extract preset key data from the bill image by calling a corresponding data extraction template based on the category to which the bill image belongs; A data calculation module, used for calculating the preset key data based on a verification algorithm corresponding to the preset key data; as well as The data archiving module is used to archive the calculated bill images based on the archiving process of the business to which the bill images belong.

9. An electronic device, characterized in that: include: Memory and processor; The memory is used to store programs; The processor is used to execute the program to implement each step of the data verification method according to any one of claims 1 to 7.

10. A readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, each step of the data checking method according to any one of claims 1 to 7 is implemented.

Images