CN113158857B - Electronic billing certificate processing method, electronic billing certificate processing device, electronic equipment and medium - Google Patents
Electronic billing certificate processing method, electronic billing certificate processing device, electronic equipment and medium Download PDFInfo
- Publication number
- CN113158857B CN113158857B CN202110381935.9A CN202110381935A CN113158857B CN 113158857 B CN113158857 B CN 113158857B CN 202110381935 A CN202110381935 A CN 202110381935A CN 113158857 B CN113158857 B CN 113158857B
- Authority
- CN
- China
- Prior art keywords
- bill
- target
- information
- voucher
- billing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000012545 processing Methods 0.000 title claims abstract description 27
- 238000003672 processing method Methods 0.000 title claims description 16
- 238000000034 method Methods 0.000 claims abstract description 34
- 238000012015 optical character recognition Methods 0.000 claims abstract description 11
- 230000000875 corresponding effect Effects 0.000 claims description 46
- 238000003860 storage Methods 0.000 claims description 29
- 238000004590 computer program Methods 0.000 claims description 8
- 230000003287 optical effect Effects 0.000 claims description 3
- 230000002596 correlated effect Effects 0.000 claims description 2
- 230000006870 function Effects 0.000 description 16
- 238000011161 development Methods 0.000 description 7
- 230000018109 developmental process Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 238000007726 management method Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000013461 design Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000007667 floating Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000001105 regulatory effect Effects 0.000 description 2
- 239000007787 solid Substances 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000009191 jumping Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000004801 process automation Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/583—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content
- G06F16/5846—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content using extracted text
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/10—Character recognition
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computer Vision & Pattern Recognition (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Multimedia (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a method, a device, electronic equipment and a medium for processing an electronic accounting voucher. The method comprises the following steps: acquiring a to-be-processed bill image and a bill abstract of the to-be-processed bill image; performing optical character recognition on the bill image to be processed to obtain bill information, and storing the bill image to be processed, the bill abstract and the bill information in a database; acquiring a generated target billing voucher, matching the target billing voucher with each bill information in the database, and determining target bill information matched with the target billing voucher; and acquiring a target bill image corresponding to the target bill information, and binding and storing the target billing certificate and the target bill image.
Description
Technical Field
The present invention relates to the field of computer information technologies, and in particular, to a method, an apparatus, an electronic device, and a medium for processing an electronic billing certificate.
Background
The accounting vouchers are accounting vouchers which are filled by financial departments according to the original vouchers, record the brief content of economic service, determine accounting entry and serve as accounting basis. Accounting is carried out according to requirements on financial needs of each company, and an account book is manufactured and stored for verification.
The financial regulation is relatively complex and trivial, the core information of borrowers, lenders, auxiliary accounting subjects and the like in the accounting document is required to be proved by corresponding bills and the like, the production is complex, the document quantity is large, and the perfect storage and inquiry are not easy to realize.
Disclosure of Invention
Based on this, there is a need to address the above-mentioned problems, and to propose an electronic billing voucher processing method, apparatus, electronic device and medium.
In a first aspect, there is provided a method for processing electronic billing certificates, including:
Acquiring a to-be-processed bill image and a bill abstract of the to-be-processed bill image;
Performing optical character recognition on the bill image to be processed to obtain bill information, and storing the bill image to be processed, the bill abstract and the bill information in a database;
acquiring a generated target billing voucher, matching the target billing voucher with each bill information in the database, and determining target bill information matched with the target billing voucher;
And acquiring a target bill image corresponding to the target bill information, and binding and storing the target billing certificate and the target bill image.
In a second aspect, an electronic billing voucher processing apparatus is provided, comprising:
The acquisition module is used for acquiring the bill image to be processed and the bill abstract of the bill image to be processed;
the identification processing module is used for carrying out optical character identification on the bill image to be processed to obtain bill information;
the storage module is used for storing the bill image to be processed, the bill abstract and the bill information in a database;
the acquisition module is also used for acquiring the generated target billing certificate;
The identification processing module is further used for matching the target billing certificate with each bill information in the database and determining target bill information matched with the target billing certificate;
The storage module is also used for acquiring a target bill image corresponding to the target bill information and binding and storing the target billing certificate and the target bill image.
In a third aspect, there is provided an electronic device comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps as in the first aspect and any one of its possible implementations.
In a fourth aspect, there is provided a computer storage medium storing one or more instructions adapted to be loaded by a processor and to perform the steps of the first aspect and any one of its possible implementations described above.
The method comprises the steps of obtaining a bill image to be processed and a bill abstract of the bill image to be processed; performing optical character recognition on the bill image to be processed to obtain bill information, and storing the bill image to be processed, the bill abstract and the bill information in a database; acquiring a generated target billing voucher, matching the target billing voucher with each bill information in the database, and determining target bill information matched with the target billing voucher; the target bill image corresponding to the target bill information is acquired, the target accounting vouchers and the target bill image are bound and stored, so that perfect bill and accounting vouchers data can be stored for a long time, the electronic accounting vouchers and the bill image can be automatically matched and stored, the accounting vouchers of all companies and the corresponding bill images are regulated and managed, the inquiry is convenient, the electronic account book can be further and rapidly generated, and the financial workload is reduced.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Wherein:
FIG. 1 is a flowchart of a method for processing electronic billing certificates according to an embodiment of the present application;
FIG. 2 is a schematic diagram of an electronic billing voucher according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a query page according to an embodiment of the present application;
FIG. 4 is a schematic diagram of an electronic billing certificate processing device according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
As shown in fig. 1, in one embodiment, an electronic billing voucher processing method is provided that can be applied to an electronic billing voucher processing device. The method comprises the following steps:
101. and acquiring the bill image to be processed and the bill abstract of the bill image to be processed.
The electronic accounting voucher processing device in the embodiment of the application can be an electronic device, and in a specific implementation, the electronic device can be a terminal, and also can be called a terminal device, including but not limited to other portable devices such as a laptop computer or a tablet computer. In some embodiments, the device is not a portable communication device, but a desktop computer.
The bill related in the embodiment of the application can be various business certificates such as invoices which are issued and collected in the process of purchasing and selling goods, providing or receiving service and engaging in other business activities. Invoice refers to text issued by a seller to a purchaser in an economic activity, and content includes a name, quality, and agreement price for providing a product or service to the purchaser. In addition to pre-payment, the invoice must have the element of being paid by the purchasing party to the seller according to agreed conditions, must contain date and quantity, and is an important voucher for accounting accounts. The chinese accounting system specifies that an invoice for a product or service is effectively called a tax invoice. For internal audit and accounting, each invoice must have a unique running account number to prevent the invoice from repeating or jumping.
The image of the bill to be processed may be any photo, screenshot or PDF form containing the bill, which is not limited in the embodiment of the present application. The source of the ticket image to be processed is generated by the user, and can also be generated by robotic flow automation (Robotic process automation, RPA) processing. For example, the user can directly take a photograph of the bill generated at ordinary times at the front end and upload the bill, for example, through a mobile phone photographing and uploading system, the rear end can be stored as a picture or PDF, the specific format of the bill can be set according to the needs, and the bill is not limited here.
The bill abstract can be provided together when uploading the bill image to be processed, and can be recorded by a user or automatically identified by a system after words such as titles in the bill image to be processed are confirmed.
102. And carrying out optical character recognition on the bill image to be processed to obtain bill information, and storing the bill image to be processed, the bill abstract and the bill information in a database.
Optical character recognition (Optical Character Recognition, OCR) as referred to in the embodiments of the present application refers to the process in which an electronic device examines characters in a document or image, etc., determines their shape by detecting dark and light patterns, and then translates the shape into computer text using a character recognition method.
Specifically, the key characters can be automatically recognized by OCR on the bill image to be processed to obtain bill information, where the bill information may include bill amount, unit, bill number, tax, etc., and is not limited herein. And the bill image to be processed, the corresponding bill abstract and the bill information can be stored in a database together, so that the bill image to be processed is convenient to store, and can be inquired and printed when required.
103. And acquiring the generated target billing certificate, matching the target billing certificate with each bill information in the database, and determining target bill information matched with the target billing certificate.
The accounting vouchers are accounting vouchers which are filled by the financial department according to the original vouchers, record the brief content of the economic service, determine accounting entry and serve as accounting basis. The accounting voucher is also called an entry voucher, is also called an accounting voucher, and is a record of the account name, the accounting direction and the amount according to the requirement of the accounting book, and is the basis of the accounting statement and the general ledger. The accounting vouchers in the embodiment of the application are electronic accounting vouchers, and can refer to an electronic accounting vouchers schematic diagram shown in fig. 2, and as shown in fig. 2, the electronic accounting vouchers can comprise information such as numbers, abstracts, accounting subjects, amounts, time, manufacturers and the like, the information in the electronic accounting vouchers can be modified and stored according to the needs, and different electronic accounting vouchers formats and colors can be reset. According to the embodiment of the application, the bill corresponding to the electronic billing certificate can be automatically matched.
Optionally, the acquiring the generated target billing credential includes:
acquiring the target billing evidence generated by the robot flow automation module; or alternatively
Acquiring the target accounting vouchers which are manually input and stored; or alternatively
An electronic target billing voucher generated by scanning the paper voucher is obtained.
Finance can record some produced running water and invoices into accounting vouchers, and finally the accounting vouchers are used for generating financial reports. The accounting certificates in the application can be recorded and saved in a preset certificate template by finance, can be generated by RPA robot processing and uploaded to a system, or can be generated into an electronic file by scanning paper certificates, and are not limited herein.
The target billing voucher can be any electronic billing voucher to be subjected to bill matching, and when the target billing voucher exists, the target billing voucher can be identified and matched with each bill information in the database, and the bill corresponding to the target billing voucher is searched.
In an alternative embodiment, the bill information includes bill amount; the step 103 may include:
31. Acquiring the voucher amount of the target accounting voucher;
32. And comparing the bill amount of each bill information with the certificate amount to determine the target bill information, wherein the bill amount of the target bill information is the same as the certificate amount of the target accounting certificate.
Specifically, the voucher amount in the target accounting voucher can be identified, the voucher amount is compared with the bill amount in the bill information stored in the database, and the bill image with the same amount is searched and used as the target bill image corresponding to the target bill information. Further optionally, the bill information may further include information such as company name and date, and the target billing certificate may be matched with a plurality of information such as company name and date of each bill one by one, so as to obtain a result with highest comprehensive matching degree. The most accurate matching of the accounting vouchers and the bill images can be realized through the comparison and identification of the information in multiple aspects.
Bill information that is normally intended for matching of electronic billing certificates belongs to recently uploaded unmatched bill images, and therefore, part of the bill images can be screened for matching with target billing certificates by selecting the upload date of the bill images, reducing the data processing amount.
Further optionally, the step 32 includes:
comparing the bill amount of each bill information with the certificate amount to obtain first bill information with the bill amount being the same as the certificate amount;
And comparing the bill abstract of the first bill information with the certificate abstract of the target billing certificate under the condition that the first bill information comprises at least two bill information, and determining that the bill information matched with the bill abstract is the target bill information.
In some cases, more than one bill amount identical to the bill amount may be matched, that is, the first bill information obtained when the bill amount is matched includes at least two bill information, at this time, the bill digest of the first bill information may be compared with the bill digest of the target billing certificate to determine which is the bill information actually matched. Specifically, the similarity between each bill abstract and the content of the voucher abstract in the first bill information can be compared, and the bill information corresponding to the bill abstract with the highest similarity of the voucher abstract is determined to be the target bill information.
In an alternative embodiment, optionally, matching may be manually adjusted for a small portion of the electronic billing voucher or ticket images in the system that cannot be automatically identified as matching. For example, ticket images under a certain electronic billing certificate can be manually added, deleted or modified, and the editing operation can also be related to the authority of the corresponding login account.
104. And acquiring a target bill image corresponding to the target bill information, and binding and storing the target billing certificate and the target bill image.
And determining target bill information corresponding to the target billing voucher through matching the bill information with the content of the electronic billing voucher, so that a corresponding bill image can be determined, namely, a target bill image corresponding to the target bill information can be acquired, and matching of the target billing voucher and the corresponding bill is completed.
The electronic billing certificates can be associated with the corresponding bill images and stored in the database, and each electronic billing certificate and the corresponding bill image can be stored in order, so that inquiry and certificate storage are facilitated.
In an alternative embodiment, the target accounting document includes a plurality of types of accounting subjects, wherein each type of accounting subject corresponds to one of the document amounts;
The step 32 may include:
Comparing the bill amount of each bill information with the certificate amount corresponding to each type of accounting subject to determine the target bill information corresponding to each type of accounting subject;
The storing the target billing certificate in association with the target ticket image may include:
Determining a bill sequence according to the arrangement sequence of the accounting orders of the multiple types in the target accounting document, wherein the bill sequence is the arrangement sequence of the target bill images corresponding to the target accounting document;
binding and storing the target billing certificate and the target bill image, and storing the arrangement sequence of the target bill image corresponding to the target billing certificate.
The target accounting document may include multiple types of accounting subjects, such as management fees, or certain product fees, and each type of accounting subject corresponds to a document amount, which may be the same or different. At this time, the corresponding bill image needs to be matched for each type of accounting subject, and the matching process can refer to the foregoing description, which is not repeated here.
It should be noted that the accounting documents of the plurality of types in the target accounting document have a certain arrangement order, so that the corresponding order of the notes can be determined, that is, the matched note images can be integrated, and the order of the note images corresponding to the target accounting document corresponds to the order of the accounting documents.
Optionally, the step 102 includes:
The bill image to be processed, the bill abstract and the bill information are stored in the database in a correlated manner with the company name, the client number and the time information corresponding to the bill image to be processed;
The method further comprises the following steps:
acquiring a bill image query request from the front end, wherein the bill image query request comprises a query company name, a query client number and/or query time information;
And inquiring the corresponding bill image in the database according to the name of the inquiring company, the inquiring client number and/or the inquiring time information, generating a bill image inquiring result and returning to the front end.
The method in the embodiment of the application can be applied to a resource management interactive system (web end), and the user group used can be accounting. The accounting management client is convenient, the user and the client can check invoice information and business information, the client is helped to make accounts and returns tax, the accounting management client also comprises a function of collecting certificates from various data sources, and the accounting management client is an important way for the interaction of the RPA robot and bill information.
Specifically, company names, client numbers and time information can be set or stored at the same time when uploading the bill images to be processed. The time information may be uploading time of the ticket image to be processed.
According to the embodiment of the application, the bill image query request can be initiated at the front end, the corresponding bill image is queried in the back-end database through company name, query client number and/or query time information, and the bill image query result is generated and returned to the front end.
The software architecture in the embodiment of the application is mainly divided into two large blocks, namely a front end (UI) and a back end (system).
The front end is mainly used for UI interface display and user interaction of the data collection module. In one embodiment, the front end is composed of HTML files that can be parsed by the browser after being written and constructed in hypertext markup language. For example, as shown in FIG. 3, the overall page layout is three large blocks:
the menu bar (top-bar) at the top of the page is divided into eight menus;
the left functional column (sidebar) presents different functional modules according to different menu selections;
The middle content presentation section (content) is also changed correspondingly according to the selected function module.
In the content section, two main blocks are subdivided:
company query view (row-project-list-view) and part (table-wrap) showing query results.
Wherein, a cascading style sheet (CASCADING STYLE SHEETS) may be employed to represent skin styles of pages in a file such as HTML. Parameters such as background color, size, font color, weight, etc. can be set as required, and are not limited herein. For example, as shown in FIG. 3, the style at the top-bar section is: selecting the background as light blue (# 2DC3E8), the height of the background is 50px, the width of the background is 100% in a self-adaptive manner, the height of the background is 50px, the font color is white (# FFF), the minimum width of the page is 1024px, the page weight coefficient is 999, and the page layout mode is fixed positioning; pattern at part sidebar: the background color is gray black (# 273240), the floating mode is left floating, the width is 205px, and the font color is light gray (# D3D6D9); row-project-list-view section: the page layout is moved relative to the current window, 50px high, 1075px minimum width, 10px upper and lower inner margins, and 20px left and right inner margins; table-wrap section: the background color is white (#fff), all borders are 1px solid light gray (#d5d5d5), and rounded borders are 3px. This is only illustrative.
In the embodiment of the application, the front-end and back-end query function can be realized by adopting JavaScript programming. The JavaScript is a lightweight and interpreted programming language with function priority, supports styles such as object oriented and command oriented, and is used for realizing the functions of connecting with a background system and transmitting data to the background when the form is requested. Three search boxes are included in the row-project-list-view section, namely, company name query, customer number query, year and month query, and may also include a submit button and a reset button. For example, when the company name search box has a value and clicks the query button, a post request submission is initiated through JavaScript, the front-end parameters are sent to the background system to trigger the query function, then the background query result set is arranged according to rules and returned to the front-end for receiving, and finally the front-end receives the query result and displays the query result in the page. Customer numbering inquiry is the same. The final effect is shown in fig. 3, and fig. 3 is a schematic diagram of a query page provided by the application, so that the query can be performed on bill images, screenshot in the query page returns show various types of bill images of different companies respectively, and editing, exporting and other operations can be performed.
In an alternative embodiment, the electronic billing account book may be quickly generated from binding the stored plurality of electronic billing vouchers with the plurality of ticket images. Wherein the electronic billing account book may include one or more billing voucher pages ordered in billing time sequence, each billing voucher page being followed by a ticket image page ordered in ticket sequence as described above.
Specifically, the electronic accounting book can be automatically generated by one key according to each electronic accounting voucher, the bill images matched with the electronic accounting voucher and the determined bill sequence, wherein each accounting voucher page is generated according to the original accounting voucher, ordered according to the accounting time sequence, and each accounting voucher page is followed by the corresponding bill image and ordered according to the determined bill sequence.
Correspondingly, the back end mainly comprises the functions of storing data and automatically generating an electronic accounting voucher and an accounting book by one key. In the embodiment of the application, the back end can be realized by adopting PHP programming language to design a background function.
The application also discloses a background system development environment construction method which is suitable for the system construction of the electronic billing voucher processing method. The method specifically comprises the following steps:
A first step of developing a local deployment of the framework (Thinkphp); the second step is the local configuration of the database (Mysql).
In the development phase, the development mode may employ an MVC structure. Directory structure layering: a business implementation layer (Application), a project Framework layer (Framework), a Public support layer (Public). And then carrying out database table structure design, client table design and electronic account book table design, and creating a corresponding table (template) in the database after the design is finished.
① Under the Core framework (Core) project file of the framework layer, the configuration file of the development framework Thinkphp is stored. Following the tool class (Lib) project file, methods are developed and packaged, such as date format conversion functions, GET call interface GET return value functions, POST call interface GET return values, json data return value formatting functions, and the like.
② At the business implementation layer, under the control project folder, mainly where a specific function implementation method is developed, the specific method related to the present application may include: the electronic account book list inquiry, the electronic account book setting, the electronic account book voucher and ticket association operation, the modification of the voucher or ticket ordering, the scanning of the paper voucher to generate the electronic voucher, the encryption when the voucher PDF is downloaded, the checking of the PDF of the electronic account book and the like can be set according to the required functions, and the embodiment of the application is not limited to this.
③ At the common support layer, highly reusable database connection methods are developed. Because the front-end inquiry and uploading request have large demand, the embodiment of the application can encapsulate the codes for connecting the database objects, thereby achieving the purpose of simplifying the operation of the database and preventing the phenomenon of high concurrency caused by occupying a database resource pool when the front-end user requests excessively and causing the system to crash.
After the development of the method in the development stage is finished, any step of the electronic billing voucher processing method in the embodiment of the application can be executed, electronic bill and billing voucher data stored in a database with the front end data and the back end data communicated with each other are processed, the data can be analyzed into JSON according to a request, then the JSON data is returned to the front end to be processed, and finally the JSON data is displayed in a page.
The development modes are merely illustrative, and in alternative embodiments, the system framework structure, the development language, the database connection mode, etc. may be selected according to needs, which is not limited in this embodiment of the present application.
The electronic billing voucher processing method in the embodiment of the application can acquire the bill image to be processed and the bill abstract of the bill image to be processed; performing optical character recognition on the bill image to be processed to obtain bill information, and storing the bill image to be processed, the bill abstract and the bill information in a database; acquiring a generated target billing voucher, matching the target billing voucher with each bill information in the database, and determining target bill information matched with the target billing voucher; the target bill image corresponding to the target bill information is acquired, the target billing voucher and the target bill image are bound and stored, so that perfect bill and billing voucher data can be stored for a long time, the electronic billing voucher and the bill image can be automatically matched and stored, and billing vouchers of various companies and corresponding bill images are regulated and managed; the electronic accounting account book meeting the standard can be conveniently and accurately generated, the evidence storage and management are convenient, and the paper and the actual storage space are saved. The entity certificate or the account book can be conveniently printed when needed, and the method is used for various needed occasions.
Based on the above description of the embodiment of the electronic billing voucher processing method, the embodiment of the present application also discloses an electronic billing voucher processing device, as shown in fig. 4, the electronic billing voucher processing device 400 includes:
An acquiring module 410, configured to acquire a to-be-processed bill image and a bill abstract of the to-be-processed bill image;
the recognition processing module 420 performs optical character recognition on the bill image to be processed to obtain bill information;
a storage module 430, configured to store the to-be-processed ticket image, the ticket abstract, and the ticket information in a database;
The obtaining module 410 is further configured to obtain the generated target billing credential;
the identification processing module 420 is further configured to match the target billing certificate with each ticket information in the database, and determine target ticket information matched with the target billing certificate;
The storage module 430 is further configured to obtain a target ticket image corresponding to the target ticket information, and bind and store the target billing certificate and the target ticket image.
The electronic billing certificate processing apparatus 400 may perform some or all of the steps of the method in the embodiment shown in fig. 1, and will not be described herein.
Based on the description of the method embodiment and the device embodiment, the embodiment of the application also provides electronic equipment. Referring to fig. 5, the electronic device 500 includes at least a processor 501, an input device 502, an output device 503, and a computer storage medium 504. Wherein the processor 501, input device 502, output device 503, and computer storage medium 504 within the electronic device may be connected by a bus or other means.
The computer storage medium 504 may be stored in a memory of an electronic device, the computer storage medium 504 is configured to store a computer program, the computer program includes program instructions, and the processor 501 is configured to execute the program instructions stored in the computer storage medium 504. The processor 501 (or CPU (Central Processing Unit, central processing unit)) is a computing core and a control core of the electronic device, which are adapted to implement one or more instructions, in particular to load and execute one or more instructions to implement a corresponding method flow or a corresponding function; in one embodiment, the processor 501 described above in connection with the embodiments of the present application may be used to perform a series of processes, including any steps of the method of the embodiment shown in fig. 1, etc.
The embodiment of the application also provides a computer storage medium (Memory), which is a Memory device in the electronic device and is used for storing programs and data. It is understood that the computer storage media herein may include both built-in storage media in the electronic device and extended storage media supported by the electronic device. The computer storage medium provides a storage space that stores an operating system of the electronic device. Also stored in this memory space are one or more instructions, which may be one or more computer programs (including program code), adapted to be loaded and executed by the processor 501. The computer storage medium herein may be a high-speed RAM memory or a non-volatile memory (non-volatile memory), such as at least one magnetic disk memory; optionally, at least one computer storage medium remote from the processor may be present.
In one embodiment, one or more instructions stored in a computer storage medium may be loaded and executed by processor 501 to implement the corresponding steps in the above embodiments; in particular, one or more instructions in the computer storage medium may be loaded by the processor 501 and perform any steps of the method of fig. 1, which are not described herein.
It should be noted that the above electronic billing voucher processing method, apparatus, electronic device and medium belong to a general inventive concept, and the content in the electronic billing voucher processing method, apparatus, electronic device and medium embodiments may be mutually applicable.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the apparatus and modules described above may refer to the corresponding process in the foregoing method embodiment, which is not repeated herein.
In the several embodiments provided by the present application, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. For example, the division of the module is merely a logical function division, and there may be another division manner when actually implemented, for example, a plurality of modules or components may be combined or may be integrated into another system, or some features may be omitted or not performed. The coupling or direct coupling or communication connection shown or discussed with each other may be through some interface, device or module indirect coupling or communication connection, which may be in electrical, mechanical, or other form.
The modules illustrated as separate components may or may not be physically separate, and components shown as modules may or may not be physical modules, i.e., may be located in one place, or may be distributed over a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in or transmitted across a computer-readable storage medium. The computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by a wired (e.g., coaxial cable, fiber optic, digital subscriber line (digital subscriber line, DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a read-only memory (ROM), or a random-access memory (random access memory, RAM), or a magnetic medium such as a floppy disk, a hard disk, a magnetic tape, a magnetic disk, or an optical medium such as a digital versatile disk (DIGITAL VERSATILE DISC, DVD), or a semiconductor medium such as a Solid State Disk (SSD), or the like.
Claims (9)
1. A method of electronic billing evidence processing, comprising:
Acquiring a to-be-processed bill image and a bill abstract of the to-be-processed bill image;
Performing optical character recognition on the bill image to be processed to obtain bill information, and storing the bill image to be processed, the bill abstract and the bill information in a database;
Acquiring a target billing voucher generated by a robot flow automation module, wherein the target billing voucher is an electronic billing voucher to be subjected to bill matching; matching the target billing certificate with each bill information in the database, and determining target bill information matched with the target billing certificate;
And acquiring a target bill image corresponding to the target bill information, and binding and storing the target billing certificate and the target bill image.
2. The electronic billing voucher processing method of claim 1, wherein the ticket information includes a ticket amount; the matching the target billing voucher with each bill information in the database, and determining target bill information matched with the target billing voucher comprises the following steps:
Acquiring the voucher amount of the target accounting voucher;
and comparing the bill amount of each bill information with the certificate amount to determine the target bill information, wherein the bill amount of the target bill information is the same as the certificate amount of the target accounting certificate.
3. The electronic billing voucher processing method of claim 2, wherein the comparing the ticket amount of each ticket information with the voucher amount, determining the target ticket information, includes:
Comparing the bill amount of each bill information with the certificate amount to obtain first bill information with the bill amount being the same as the certificate amount;
and under the condition that the first bill information comprises at least two bill information, comparing the bill abstract of the first bill information with the voucher abstract of the target billing voucher, and determining that the bill information matched with the bill abstract is the target bill information.
4. The electronic billing voucher processing method of claim 2, wherein the target billing voucher includes a plurality of types of accounting, wherein each type of accounting corresponds to one of the voucher amounts;
The step of comparing the bill amount of each bill information with the certificate amount to determine the target bill information comprises the following steps:
Comparing the bill amount of each bill information with the certificate amount corresponding to each type of accounting subject to determine the target bill information corresponding to each type of accounting subject;
The binding and storing the target billing voucher and the target bill image comprises the following steps:
determining a bill sequence according to the arrangement sequence of the accounting orders of the multiple types in the target accounting document, wherein the bill sequence is the arrangement sequence of the target bill images corresponding to the target accounting document;
and binding and storing the target billing certificate and the target bill image, and storing the arrangement sequence of the target bill image corresponding to the target billing certificate.
5. The method for processing electronic billing voucher according to claim 4, wherein after said storing the target billing voucher in association with the target ticket image and storing the order of the target ticket images corresponding to the target billing voucher, the method further comprises:
And generating an accounting book according to the stored accounting vouchers and the ticket images, wherein the accounting book comprises one or more accounting vouchers which are ordered according to the accounting time sequence, and each accounting vouchers is followed by the ticket image pages ordered according to the ticket sequence.
6. The electronic billing voucher processing method of any of claims 1-5, wherein storing the pending ticket image, the ticket digest and the ticket information in a database includes:
the bill image to be processed, the bill abstract, the bill information, company names, client numbers and time information corresponding to the bill image to be processed are stored in the database in a correlated mode;
The method further comprises the steps of:
Acquiring a bill image query request from a front end, wherein the bill image query request comprises a query company name, a query client number and/or query time information;
and inquiring the corresponding bill image in the database according to the name of the inquiring company, the inquiring client number and/or the inquiring time information, generating a bill image inquiring result and returning to the front end.
7. An electronic billing voucher processing apparatus comprising:
The acquisition module is used for acquiring the bill image to be processed and the bill abstract of the bill image to be processed;
the identification processing module is used for carrying out optical character identification on the bill image to be processed to obtain bill information;
the storage module is used for storing the bill image to be processed, the bill abstract and the bill information in a database;
the acquisition module is further used for acquiring a target billing voucher generated by the robot flow automation module, wherein the target billing voucher is an electronic billing voucher to be subjected to bill matching;
The identification processing module is further used for matching the target billing certificate with each bill information in the database and determining target bill information matched with the target billing certificate;
The storage module is also used for acquiring a target bill image corresponding to the target bill information and binding and storing the target billing certificate and the target bill image.
8. An electronic device comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps of the electronic billing credential processing method of any of claims 1 to 6.
9. A computer readable storage medium, characterized in that a computer program is stored, which, when being executed by a processor, causes the processor to perform the steps of the electronic billing voucher processing method as claimed in any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110381935.9A CN113158857B (en) | 2021-04-09 | 2021-04-09 | Electronic billing certificate processing method, electronic billing certificate processing device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110381935.9A CN113158857B (en) | 2021-04-09 | 2021-04-09 | Electronic billing certificate processing method, electronic billing certificate processing device, electronic equipment and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113158857A CN113158857A (en) | 2021-07-23 |
| CN113158857B true CN113158857B (en) | 2024-08-27 |
Family
ID=76888935
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110381935.9A Active CN113158857B (en) | 2021-04-09 | 2021-04-09 | Electronic billing certificate processing method, electronic billing certificate processing device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113158857B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113793456A (en) * | 2021-09-07 | 2021-12-14 | 上海浦东发展银行股份有限公司 | Bill drawing method and device, electronic equipment and storage medium |
| CN114248572B (en) * | 2022-03-02 | 2022-07-01 | 远光软件股份有限公司 | Printing method and device of accounting document and storage medium |
| CN114782971B (en) * | 2022-03-24 | 2024-09-03 | 合肥工业大学 | Financial document image recognition method and system |
| CN114495136A (en) * | 2022-04-14 | 2022-05-13 | 滨州市社会保险事业中心 | Financial data storage method, system, computer equipment and storage medium |
| CN114677188B (en) * | 2022-05-25 | 2022-08-26 | 国网浙江省电力有限公司 | Full-amount acquisition method and device suitable for paperless certificate data |
| CN115271893A (en) * | 2022-06-08 | 2022-11-01 | 广西产研院人工智能与大数据应用研究所有限公司 | Method and device for managing fee bill and storage medium |
| CN115311651B (en) * | 2022-10-12 | 2023-08-08 | 泰安协同软件有限公司 | Real estate certificate data acquisition and arrangement method |
| CN116434265A (en) * | 2023-06-12 | 2023-07-14 | 中国航空结算有限责任公司 | Civil aviation passenger transport ticket management method, device, equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108961021A (en) * | 2018-05-18 | 2018-12-07 | 北京大账房网络科技股份有限公司 | It is taken pictures using Intelligent mobile equipment and generates the method and system of voucher |
| CN111931777A (en) * | 2020-06-30 | 2020-11-13 | 北京来也网络科技有限公司 | Invoice information processing method and device based on RPA and storage medium |
Family Cites Families (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1628247A1 (en) * | 2004-08-21 | 2006-02-22 | Sap Ag | Database for accountancy purposes |
| US10235838B2 (en) * | 2014-09-24 | 2019-03-19 | Jcm American Corporation | Electronic voucher ticket system |
| US10970967B2 (en) * | 2014-09-24 | 2021-04-06 | Jcm American Corporation | Electronic voucher ticket system |
| CN106296378B (en) * | 2016-07-26 | 2021-06-01 | 四川长虹电器股份有限公司 | XBRL-based intelligent financial cloud platform system, construction method and service implementation method |
| CN106815924B (en) * | 2016-12-22 | 2019-06-18 | 河南职业技术学院 | A kind of accounting voucher processing system |
| CN109859021A (en) * | 2018-11-28 | 2019-06-07 | 北京轻赢数据科技有限公司 | Generate the method, apparatus and computer storage medium of bookkeeping voucher |
| CN109636557A (en) * | 2018-12-11 | 2019-04-16 | 厦门商集网络科技有限责任公司 | A kind of intelligent classification bookkeeping methods and equipment based on bank slip recognition |
| CN110163734A (en) * | 2019-03-20 | 2019-08-23 | 金明 | Bill scans the System and method for for directly generating voucher |
| CN110363097A (en) * | 2019-06-21 | 2019-10-22 | 深圳壹账通智能科技有限公司 | Enterprise's portrait generation method and device based on financial statement |
| CN110570291A (en) * | 2019-07-31 | 2019-12-13 | 苏宁云计算有限公司 | Method and device for generating accounting document based on SAP system |
| CN110675234A (en) * | 2019-08-23 | 2020-01-10 | 国信电子票据平台信息服务有限公司 | Electronic newspaper bill generation method and electronic equipment |
| CN110969408B (en) * | 2019-11-08 | 2024-04-05 | 国网辽宁省电力有限公司 | Material settlement whole-flow integrated management platform generation system and method |
| CN111091349B (en) * | 2019-12-10 | 2024-04-12 | 远光软件股份有限公司 | Certificate binding system, method and equipment |
-
2021
- 2021-04-09 CN CN202110381935.9A patent/CN113158857B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108961021A (en) * | 2018-05-18 | 2018-12-07 | 北京大账房网络科技股份有限公司 | It is taken pictures using Intelligent mobile equipment and generates the method and system of voucher |
| CN111931777A (en) * | 2020-06-30 | 2020-11-13 | 北京来也网络科技有限公司 | Invoice information processing method and device based on RPA and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113158857A (en) | 2021-07-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113158857B (en) | Electronic billing certificate processing method, electronic billing certificate processing device, electronic equipment and medium | |
| US8442881B2 (en) | Systems and methods of processing and classifying a financial transaction | |
| US9213893B2 (en) | Extracting data from semi-structured electronic documents | |
| CN108734528A (en) | A kind of electronic invoice keeps accounts method automatically | |
| CN110458562B (en) | Bill reimbursement method, device and equipment and computer storage medium | |
| US20150227785A1 (en) | Information processing apparatus, information processing method, and program | |
| US20050222944A1 (en) | System and method for managing the reimbursement of expenses using expense reports | |
| JPH06501584A (en) | information processing equipment | |
| JP2011170490A (en) | SaaS GENERAL ACCOUNTING SYSTEM | |
| CN105512890A (en) | Method and system for generating accounting voucher | |
| US20130006673A1 (en) | Consolidating Billing Statements in an Agency Business Model | |
| JP6001743B1 (en) | Data management system, method and program | |
| US20110052075A1 (en) | Remote receipt analysis | |
| CN105243583A (en) | Data processing method and data processing system | |
| US20110166934A1 (en) | Targeted advertising based on remote receipt analysis | |
| JP2012146158A (en) | Accounting processing system | |
| CN111178836A (en) | Batch archiving method, device and equipment for electronic documents and storage medium | |
| CN113240503A (en) | Reimbursement invoice management method, device and medium based on intelligent equipment | |
| US8650221B2 (en) | Systems and methods to associate invoice data with a corresponding original invoice copy in a stack of invoices | |
| JP6976763B2 (en) | Journal information processing device, journal information processing method, and program | |
| JP2010244227A (en) | Accounting input storage device | |
| CN117541180A (en) | Invoice processing method, invoice processing device and invoice processing medium | |
| JP6993200B2 (en) | Data display device, data display method and data display program | |
| JP2022022377A (en) | Data display device, data display method, and data display program | |
| CN112801765A (en) | Generating method, device and system of reimbursement file, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |