CN113158857A - Electronic accounting voucher processing method and device, electronic equipment and medium - Google Patents
Electronic accounting voucher processing method and device, electronic equipment and medium Download PDFInfo
- Publication number
- CN113158857A CN113158857A CN202110381935.9A CN202110381935A CN113158857A CN 113158857 A CN113158857 A CN 113158857A CN 202110381935 A CN202110381935 A CN 202110381935A CN 113158857 A CN113158857 A CN 113158857A
- Authority
- CN
- China
- Prior art keywords
- bill
- target
- voucher
- information
- image
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 claims abstract description 40
- 238000012545 processing Methods 0.000 claims abstract description 25
- 238000012015 optical character recognition Methods 0.000 claims abstract description 12
- 238000003860 storage Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 8
- 238000004801 process automation Methods 0.000 claims description 3
- 230000000875 corresponding effect Effects 0.000 description 38
- 230000006870 function Effects 0.000 description 17
- 238000011161 development Methods 0.000 description 7
- 230000018109 developmental process Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 238000013461 design Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000007726 management method Methods 0.000 description 4
- 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
- 238000013500 data storage Methods 0.000 description 2
- 238000007667 floating Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 230000003044 adaptive effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000002452 interceptive effect 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
- 230000003287 optical effect Effects 0.000 description 1
- 238000007639 printing Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 230000029305 taxis Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
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
Abstract
The application discloses an electronic accounting voucher processing method, an electronic accounting voucher processing device, electronic equipment and a medium. The method comprises the following steps: acquiring a bill image to be processed and a bill abstract of the bill image to be processed; 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; acquiring a generated target accounting voucher, matching the target accounting voucher with each bill information in the database, and determining target bill information matched with the target accounting voucher; and acquiring a target bill image corresponding to the target bill information, and binding and storing the target accounting voucher and the target bill image.
Description
Technical Field
The invention relates to the technical field of computer information, in particular to a method, a device, electronic equipment and a medium for processing an electronic accounting voucher.
Background
The accounting voucher is an accounting voucher filled by the financial accounting department according to the original voucher, records the brief content of the economic service, determines an accounting entry and serves as an accounting basis. Accounting is carried out according to the financial needs of each company, and an account book is made and stored for checking.
The financial regulation is relatively complex and trivial, core information such as debit and credit accounting subjects, auxiliary accounting subjects and the like in the accounting document needs bill certification such as a corresponding invoice, the manufacturing is complex, the document amount is large, and perfect storage and query are not easy to realize.
Disclosure of Invention
In view of the above, it is necessary to provide an electronic accounting voucher processing method, apparatus, electronic device and medium for solving the above problems.
In a first aspect, a method for processing an electronic accounting voucher is provided, which includes:
acquiring a bill image to be processed and a bill abstract of the bill image to be processed;
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;
acquiring a generated target accounting voucher, matching the target accounting voucher with each bill information in the database, and determining target bill information matched with the target accounting voucher;
and acquiring a target bill image corresponding to the target bill information, and binding and storing the target accounting voucher and the target bill image.
In a second aspect, there is provided an electronic accounting voucher processing apparatus comprising:
the acquisition module is used for acquiring a bill image to be processed and a bill abstract of the bill image to be processed;
the recognition processing module is used for carrying out optical character recognition 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 the generated target accounting voucher;
the identification processing module is further used for matching the target accounting voucher with each bill information in the database and determining target bill information matched with the target accounting voucher;
the storage module is further used for acquiring a target bill image corresponding to the target bill information and binding and storing the target accounting voucher and the target bill image.
In a third aspect, an electronic device is provided, 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 possible implementation thereof.
The method comprises the steps of obtaining a bill image to be processed and a bill abstract of the bill image to be processed; 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; acquiring a generated target accounting voucher, matching the target accounting voucher with each bill information in the database, and determining target bill information matched with the target accounting voucher; the method comprises the steps of obtaining a target bill image corresponding to target bill information, binding and storing the target accounting voucher with the target bill image, achieving long-term storage of perfect bills and accounting voucher data, automatically matching and storing the electronic accounting voucher with the bill image, managing the accounting voucher and the corresponding bill image of each company in a standard mode, facilitating inquiry, further and quickly generating an electronic account book and reducing financial workload.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Wherein:
fig. 1 is a schematic flow chart of a method for processing an electronic accounting voucher according to an embodiment of the present application;
FIG. 2 is a schematic diagram of an electronic billing voucher provided by an embodiment of the present application;
fig. 3 is a schematic diagram of a query page provided in the embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic accounting voucher processing apparatus 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 technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, in one embodiment, an electronic billing voucher processing method is provided, which can be applied to an electronic billing voucher processing means. The method comprises the following steps:
101. and acquiring a bill image to be processed and a bill abstract of the bill image to be processed.
The electronic accounting voucher processing apparatus in the embodiment of the present application may be an electronic device, and in a specific implementation, the electronic device may be a terminal, which may also be referred to as 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 is a desktop computer.
The bills involved in the embodiments of the present application may be various kinds of business vouchers, such as invoices, issued and collected in purchasing goods, providing or receiving services, and performing other business activities. The invoice is a text issued by a seller to a buyer in economic activities, and the content includes the name, quality and agreement price of a product or service provided to the buyer. In addition to pre-payment, the invoice must have the elements of being paid by the purchaser to the seller according to agreed conditions, must contain the date and quantity, and is an important certificate for accounting. Invoices for effectively purchasing products or services are specified by the Chinese accounting system to be called tax invoices. For internal auditing and counting, each invoice must have a unique journal number to prevent the invoice from repeating or skipping.
The to-be-processed bill image can be in any form of a photo, a screenshot or a PDF including the bill, which is not limited in the embodiment of the present application. The source of the bill image to be processed is generated by the user, and can also be generated by a Robot Process Automation (RPA) process. For example, the user may directly take a picture of a bill generated at ordinary times at the front end and upload the bill, for example, take a picture of a mobile phone and upload the bill to the system, and the back end may store the bill as a picture or PDF, where the specific format may be set as required, and the specific format is not limited here.
The bill abstract can be provided together when the bill image to be processed is uploaded, and can be determined after characters, such as a title, in the bill image to be processed is input by a user or automatically identified by a system.
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 (OCR) in the embodiments of the present application refers to a process in which an electronic device examines characters in a document or image, determines the shape of the characters by detecting dark and light patterns, and then translates the shape into computer text by a Character Recognition method.
Specifically, the key characters of the bill image to be processed can be automatically identified through OCR to obtain the bill information, and the bill information may include the bill amount, unit, invoice number, tax amount, and the like, which is not limited herein. And the bill image to be processed, the corresponding bill abstract and the bill information can be stored in the database together, so that the storage is convenient, and the inquiry and the printing can be carried out when needed.
103. And acquiring the generated target accounting voucher, matching the target accounting voucher with each bill information in the database, and determining the target bill information matched with the target accounting voucher.
The accounting voucher is an accounting voucher filled by the financial accounting department according to the original voucher, records the brief content of the economic service, determines an accounting entry and serves as an accounting basis. The bookkeeping voucher is also called an entry voucher, and is also called a bookkeeping voucher, and a record for determining the account name, the bookkeeping direction and the amount of money according to the requirements of a registered book is the basis for registering a detailed ledger and a general ledger. The bookkeeping voucher in the embodiment of the application is an electronic bookkeeping voucher, and can refer to an electronic bookkeeping voucher schematic diagram shown in fig. 2, as shown in fig. 2, the electronic bookkeeping voucher can include information such as a number, an abstract, an accounting subject, an amount, time, a billing person, and the like, and the information in the electronic bookkeeping voucher can be modified and stored as required, and different electronic bookkeeping voucher formats and colors can be reset. The bill corresponding to the electronic accounting voucher can be automatically matched in the embodiment of the application.
Optionally, the obtaining the generated target accounting voucher includes:
acquiring the target accounting voucher generated by the robot process automation module; alternatively, the first and second electrodes may be,
acquiring the target bookkeeping voucher which is manually recorded and stored; alternatively, the first and second electrodes may be,
and acquiring the electronic target accounting voucher generated by scanning the paper voucher.
The finance can record some produced running water and invoices into a bookkeeping voucher, and finally the bookkeeping voucher is used for generating a financial statement. The accounting voucher in the application can be recorded and stored in a preset voucher template through finance, can be generated through processing of an RPA robot and uploaded to a system, or is generated through scanning of a paper voucher to form an electronic file, and the method is not limited.
The target bookkeeping voucher can be any electronic bookkeeping voucher to be subjected to bill matching, when the target bookkeeping voucher exists, the target bookkeeping voucher can be identified and matched with each bill information in the database, and a bill corresponding to the target bookkeeping voucher is searched.
In an optional embodiment, the ticket information includes a ticket amount; the step 103 may include:
31. obtaining the voucher amount of the target accounting voucher;
32. and comparing the bill sum of each bill information with the voucher sum to determine the target bill information, wherein the bill sum of the target bill information is the same as the voucher sum of the target accounting voucher.
Specifically, the voucher amount in the target bookkeeping 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 consistent amount is searched to serve 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 accounting voucher may be matched with multiple items of information such as company name and date of each bill one by one, so as to obtain a result with the highest comprehensive matching degree. The most accurate matching of the bookkeeping voucher and the bill image can be realized through the comparison and identification of multi-aspect information.
The ticket information that is generally intended for electronic billing voucher matching belongs to recently uploaded unmatched ticket images, and therefore, a part of the ticket images can be screened for matching with the target billing voucher by selecting the uploading date of the ticket images, reducing the data processing amount.
Further optionally, the step 32 includes:
comparing the bill sum of each bill information with the voucher sum to obtain first bill information of which the bill sum is the same as the voucher sum;
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 accounting voucher, and determining that the bill information matched with the bill abstract and the voucher abstract is the target bill information.
In some cases, more than one bill amount may be matched, that is, the first bill information obtained when the amount is matched includes at least two bill information, and at this time, the bill abstract of the first bill information may be compared with the bill abstract of the target accounting bill to determine which is the actually matched bill information. Specifically, the similarity between each bill abstract in the first bill information and the content of the voucher abstract can be compared, and the bill information corresponding to the bill abstract with the highest similarity to the voucher abstract is determined to be the target bill information.
In an alternative embodiment, optionally, the matching may be adjusted manually in the system for at least some electronic accounting voucher or ticket images that are not automatically identified as matching. For example, the ticket image under an electronic accounting voucher can be manually added, deleted or modified, and the corresponding login account authority can be also required in relation to the editing operation.
104. And acquiring a target bill image corresponding to the target bill information, and binding and storing the target accounting voucher and the target bill image.
And determining target bill information corresponding to the target accounting voucher through matching the bill information with the content of the electronic accounting voucher, thereby determining a corresponding bill image, namely acquiring the target bill image corresponding to the target bill information, and completing the matching of the target accounting voucher and the corresponding bill.
The electronic accounting voucher and the corresponding bill image can be associated and stored in the database, and each electronic accounting voucher and the corresponding bill image can be stored in order, so that the electronic accounting voucher and the corresponding bill image can be inquired and stored conveniently.
In an alternative embodiment, said target billing voucher includes a plurality of types of accounting, wherein each type of accounting corresponds to an amount of said voucher;
the step 32 may include:
comparing the bill amount of each bill information with the voucher amount corresponding to each type of accounting subject to determine target bill information corresponding to each type of accounting subject;
the binding and storing the target accounting voucher and the target bill image may include:
determining a bill sequence according to the arrangement sequence of the accounting subjects of the multiple types in the target accounting voucher, wherein the bill sequence is the arrangement sequence of the target bill image corresponding to the target accounting voucher;
and binding and storing the target accounting voucher and the target bill image, and storing the arrangement sequence of the target bill image corresponding to the target accounting voucher.
The target billing voucher may include multiple types of accounting such as management charge, or a product charge, and each type of accounting corresponds to a voucher 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 may refer to the foregoing description, which is not described herein again.
It should be noted that the multiple types of accounting subjects in the target accounting document have a certain arrangement order, so that the corresponding order of the bills can be determined, that is, the matched images of the bills can be integrated, and the order of the images of the bills corresponding to the target accounting document corresponds to the order of the accounting subjects.
Optionally, the step 102 includes:
storing the bill image to be processed, the bill abstract, the company name, the customer number and the time information corresponding to the bill information and the bill image to be processed in the database in a correlated manner;
the method further comprises the following steps:
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 number of the inquiring client and/or the inquiring time information, generating a bill image inquiring result and returning the bill image inquiring result to the front end.
The method in the embodiment of the application can be applied to a resource management interactive system (web side), and the user group used can be accounting. The accounting management client is convenient, the user and the client can check invoice information, industrial and commercial information conveniently, the client can be helped to make accounts and report taxes, the function of collecting certificates from various data sources is included, and meanwhile, the method is also an important way for interaction between the RPA robot and the bill information.
Specifically, the company name, the customer number and the time information can be set or stored simultaneously when the to-be-processed bill image is uploaded, and in the embodiment of the application, the accounting data of a plurality of companies can be stored in a classified mode, and processing and feedback processing results are carried out. The time information can be the uploading time of the bill image to be processed.
In 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 the company name, the query client number and/or the query time information, and the bill image query result is generated and returned to the front end.
The software architecture in the embodiments of the present application is mainly divided into two blocks, a front end (UI) and a back end (system).
The front end is used primarily as a UI interface display and user interaction for the data collection module. In one embodiment, the front end is composed in hypertext markup language, and then an HTML file which can be analyzed by a browser is used as a main body. By way of example, as shown in FIG. 3, the overall page is laid out in three large blocks:
the menu bar (top-bar) at the top of the page is divided into eight menus;
the function bar (sidebar) on the left side presents different function modules according to different menu selections;
the content in the middle of the content presentation part (content) is changed according to the selected function module.
In the content section, it is subdivided into two blocks:
a company query view (row-project-list-view) and a section (table-wrap) that displays the query results.
Among them, a Cascading Style Sheets (Cascading Style Sheets) can be used to express the skin Style of pages in documents such as HTML. Parameters such as background color, size, font color, and weight may be set as required, and are not limited herein. For example, as shown in fig. 3, in the top-bar section, the model is: selecting the background as light blue (#2DC3E8), the height of the background is 50px, the width is adaptive to 100%, the height of the background is 50px, the font color is white (# FFF), the minimum width of a page is 1024px, the page weight coefficient is 999, and the page layout mode is fixed positioning; pattern on sidebar section: the background color is gray black (#273240), the floating mode is left floating, width 205px, font color light gray (# D3D6D 9); row-project-list-view section: the page layout is moved relative to the current window, the height is 50px, the minimum width is 1075px, the upper and lower inner edge distance is 10px, and the left and right inner edge distance is 20 px; table-wrap section: the background color was white (# FFF), all borders were 1px solid lines light gray (# D5D5D5), and the rounded border was 3 px. Which is only schematically shown here.
In the embodiment of the application, the front-end and back-end query functions can be realized by adopting JavaScript language programming. The JavaScript is a lightweight and interpretation programming language with function priority, supports styles of object-oriented style, command style and the like, and is used for realizing the functions of connecting a form with a background system when a request is made and transmitting data to a background. The row-project-list-view section contains three search boxes, namely a company name query, a customer number query, a year and month query, and may further include a submit button and a reset button. For example, when a company name search box has a value and a query button is clicked, a post request is initiated through JavaScript to submit, front-end parameters are sent to a background system to trigger a query function, a background query result set is returned to the front end according to regular arrangement to be received, and finally the front end receives query results and displays the query results in a page. The customer number query works the same way. The final effect is as shown in fig. 3, fig. 3 is a schematic view of an inquiry page provided by the present application, which can inquire the ticket image, wherein the screenshot returns various types of ticket images respectively showing different companies, and operations such as editing, exporting and the like can be performed.
In an alternative embodiment, the electronic accounting book can be generated rapidly according to the plurality of electronic accounting vouchers and the plurality of bill images which are stored in a binding mode. Wherein the electronic billing book may include one or more billing voucher pages ordered in billing time order, each billing voucher page followed by a ticket image page ordered in the ticket order.
Specifically, the electronic bookkeeping book may be automatically generated by one key according to each electronic bookkeeping voucher, and the ticket image and the determined ticket sequence matched with the electronic bookkeeping voucher, wherein each bookkeeping voucher page is generated according to the original bookkeeping voucher and is sorted according to the bookkeeping time sequence, and each bookkeeping voucher page is followed by the corresponding ticket image and is sorted according to the determined ticket sequence.
Correspondingly, the back end mainly comprises the functions of data storage and automatic generation of electronic accounting vouchers and accounting books by one key. The back end in the embodiment of the application can be realized by adopting a PHP programming language to design a background function.
The application also discloses a background system development environment building method which is suitable for system building of the electronic bookkeeping voucher processing method. The method specifically comprises the following steps:
first step in the local deployment of development frameworks (Thinkphp); the second step is the local configuration of the database (Mysql).
In the development phase, the development pattern may employ an MVC structure. The directory structure is layered: service implementation layer (Application), project Framework layer (Framework), and Public support layer (Public). And then carrying out database table structure design, customer table design and electronic account book table design, and creating a corresponding table (template) in the database after the design is finished.
Firstly, storing a configuration file of a development framework Thinkphp under a Core framework (Core) project file of a framework layer. Following the tool class (Lib) project file, methods such as date format conversion function, GET call interface GET return function, POST call interface GET return, json data return format function, etc. are developed and packaged.
Secondly, in a business implementation layer, under a Controller project folder, where a specific function implementation method is mainly developed, the specific method related to the application may include: the method comprises the steps of electronic account book list query, electronic account book setting, electronic account book and bill association operation, certificate or bill sequencing modification, electronic certificate generation through scanning of paper certificates, encryption during downloading of certificate PDFs, checking of the PDFs of the electronic account books and the like, and can be set according to required functions, and the method is not limited in the embodiment of the application.
And thirdly, developing a highly reusable database connection method on a common support layer. Due to the fact that the demand of the front-end query and upload requests is large, codes of database connection objects can be packaged, the purpose of simplifying operation of the database is achieved, and the phenomenon that high concurrency is caused due to the fact that a database resource pool is occupied when the front-end user requests excessively is avoided, and the system is broken down.
After the method between the development stages is developed, any step of the electronic accounting voucher processing method in the embodiment of the application can be executed, electronic bills and accounting 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, and then the JSON data is returned to the front end to be processed and finally displayed in a page.
The above development manner is only an illustration, and in an alternative implementation manner, a system framework structure, a development language, a database connection manner, and the like may be selected as needed, which is not limited in this application.
The electronic accounting 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; 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; acquiring a generated target accounting voucher, matching the target accounting voucher with each bill information in the database, and determining target bill information matched with the target accounting voucher; acquiring a target bill image corresponding to the target bill information, and binding and storing the target accounting voucher and the target bill image, so that the complete long-term storage of bills and accounting voucher data can be realized, the electronic accounting voucher and the bill image can be automatically matched and stored, and the accounting voucher and the corresponding bill image of each company can be managed in a standard manner; the electronic bookkeeping account book meeting the standard can be conveniently and accurately generated, the evidence and the management are convenient to store, and the paper and the actual storage space are saved. When needed, the paper can be conveniently printed into a physical voucher or an account book for various required occasions.
Based on the description of the foregoing electronic accounting voucher processing method embodiment, an embodiment of the present application further discloses an electronic accounting voucher processing apparatus, as shown in fig. 4, the electronic accounting voucher processing apparatus 400 includes:
an obtaining module 410, configured to obtain a to-be-processed bill image and a bill abstract of the to-be-processed bill image;
the recognition processing module 420 is used for carrying out optical character recognition on the bill image to be processed to obtain bill information;
the storage module 430 is configured to store the to-be-processed bill image, the bill abstract, and the bill information in a database;
the obtaining module 410 is further configured to obtain the generated target accounting voucher;
the identification processing module 420 is further configured to match the target accounting voucher with each piece of ticket information in the database, and determine target ticket information matched with the target accounting voucher;
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 accounting voucher and the target ticket image.
The electronic accounting voucher processing apparatus 400 can perform part or all of the steps of the method in the embodiment shown in fig. 1, which is not described herein again.
Based on the description of the method embodiment and the device embodiment, the embodiment of the application further provides an electronic device. 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. The processor 501, the input device 502, the output device 503, and the computer storage medium 504 within the electronic device may be connected by a bus or other means.
A computer storage medium 504 may be stored in the memory of the electronic device, the computer storage medium 504 being used for storing a computer program comprising program instructions, and the processor 501 being used for executing the program instructions stored by the computer storage medium 504. The processor 501 (or CPU) is a computing core and a control core of the electronic device, and is adapted to implement one or more instructions, and in particular, is adapted to load and execute the one or more instructions so as to implement a corresponding method flow or a corresponding function; in one embodiment, the processor 501 described above in the embodiments of the present application may be configured to perform a series of processes, including any steps of the method in the embodiment shown in fig. 1, and the like.
An embodiment of the present application further provides a computer storage medium (Memory), which is a Memory device in an electronic device and is used to store programs and data. It is understood that the computer storage medium herein may include both a built-in storage medium in the electronic device and, of course, an extended storage medium supported by the electronic device. Computer storage media provide storage space that stores an operating system for an electronic device. Also stored in this memory space are one or more instructions, which may be one or more computer programs (including program code), suitable for loading and execution by processor 501. The computer storage medium may be a high-speed RAM memory, or may be a non-volatile memory (non-volatile memory), such as at least one disk memory; and optionally at least one computer storage medium located remotely from the processor.
In one embodiment, one or more instructions stored in a computer storage medium may be loaded and executed by processor 501 to perform the corresponding steps in the above embodiments; in particular implementations, one or more instructions in the computer storage medium may be loaded by processor 501 and executed to perform any step of the method in fig. 1, which is not described herein again.
It should be noted that the electronic accounting voucher processing method, apparatus, electronic device and medium described above belong to a general inventive concept, and the contents in the embodiments of the electronic accounting voucher processing method, apparatus, electronic device and medium may be mutually applicable.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and modules may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. For example, the division of the module is only one logical division, and other divisions may be possible in actual implementation, for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted, or not performed. The shown or discussed mutual coupling, direct coupling or communication connection may be an indirect coupling or communication connection of devices or modules through some interfaces, and may be in an electrical, mechanical or other form.
Modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical modules, may be located in one place, or may be distributed on 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 the present embodiment.
In the above embodiments, the implementation may be wholly or partially realized 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. The procedures or functions according to the embodiments of the present application are wholly or partially generated when the computer program instructions are loaded and executed on a computer. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored on or transmitted over 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 wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)), or wirelessly (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that includes one or more of the available media. The usable medium may be a read-only memory (ROM), or a 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 (DVD), or a semiconductor medium, such as a Solid State Disk (SSD).
Claims (10)
1. An electronic accounting voucher processing method is characterized by comprising the following steps:
acquiring a bill image to be processed and a bill abstract of the bill image to be processed;
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;
acquiring a generated target accounting voucher, matching the target accounting voucher with each bill information in the database, and determining target bill information matched with the target accounting voucher;
and acquiring a target bill image corresponding to the target bill information, and binding and storing the target accounting voucher and the target bill image.
2. The electronic accounting voucher processing method of claim 1, wherein the ticket information comprises a ticket amount; the matching the target accounting voucher with each bill information in the database and determining the target bill information matched with the target accounting voucher comprise:
obtaining the voucher amount of the target accounting voucher;
and comparing the bill sum of each bill information with the voucher sum to determine the target bill information, wherein the bill sum of the target bill information is the same as the voucher sum of the target accounting voucher.
3. The method for processing the electronic accounting voucher according to claim 2, wherein the step of comparing the voucher amount of each voucher information with the voucher amount to determine the target voucher information comprises the steps of:
comparing the bill sum of each bill information with the voucher sum to obtain first bill information with the bill sum identical to the voucher sum;
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 accounting voucher, and determining that the bill information matched with the bill abstract and the voucher abstract is the target bill information.
4. The electronic billing voucher processing method of claim 2, wherein the target billing voucher comprises a plurality of types of accounting, wherein each type of accounting corresponds to one of the voucher amounts;
comparing the bill amount of each bill information with the voucher amount to determine the target bill information, including:
comparing the bill amount of each bill information with the voucher amount corresponding to each type of accounting subject, and determining target bill information corresponding to each type of accounting subject;
the binding and storing the target accounting voucher and the target bill image comprises:
determining a bill sequence according to the arrangement sequence of the accounting departments of the multiple types in the target accounting voucher, wherein the bill sequence is the arrangement sequence of the target bill image corresponding to the target accounting voucher;
and binding and storing the target accounting voucher and the target bill image, and storing the arrangement sequence of the target bill image corresponding to the target accounting voucher.
5. The method of processing an electronic billing voucher according to claim 4, wherein after the binding storing the target billing voucher with the target ticket image and storing the arrangement order of the target ticket image corresponding to the target billing voucher, the method further comprises:
generating a bookkeeping book according to a plurality of bookkeeping vouchers and a plurality of bill images which are stored in a binding mode, wherein the bookkeeping book comprises one or a plurality of bookkeeping voucher pages which are sorted according to a bookkeeping time sequence, and each bookkeeping voucher page is followed by a bill image page which is sorted according to the bill sequence.
6. The electronic accounting voucher processing method of any one of claims 1-5, wherein storing the ticket image to be processed, the ticket digest and the ticket information in a database comprises:
storing the bill image to be processed, the bill abstract, the company name corresponding to the bill information and the bill image to be processed, the customer number and the time information in the database in an associated manner;
the method further comprises the following steps:
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 number of the inquiring client and/or the inquiring time information, generating a bill image inquiring result and returning the bill image inquiring result to the front end.
7. The method of electronic billing credential processing according to claim 1 wherein the obtaining the generated target billing credential comprises:
acquiring the target accounting voucher generated by a robot process automation module; alternatively, the first and second electrodes may be,
acquiring the target accounting voucher which is manually input and stored; alternatively, the first and second electrodes may be,
and acquiring the electronic target accounting voucher generated by scanning the paper voucher.
8. An electronic accounting voucher processing apparatus comprising:
the acquisition module is used for acquiring a bill image to be processed and a bill abstract of the bill image to be processed;
the recognition processing module is used for carrying out optical character recognition 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 the generated target accounting voucher;
the identification processing module is further used for matching the target accounting voucher with each bill information in the database and determining target bill information matched with the target accounting voucher;
the storage module is further used for acquiring a target bill image corresponding to the target bill information and binding and storing the target accounting voucher and the target bill image.
9. 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 accounting voucher processing method according to any one of claims 1 to 7.
10. A computer-readable storage medium, in which a computer program is stored which, when executed by a processor, causes the processor to carry out the steps of the electronic accounting voucher processing method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110381935.9A CN113158857A (en) | 2021-04-09 | 2021-04-09 | Electronic accounting voucher processing method and device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110381935.9A CN113158857A (en) | 2021-04-09 | 2021-04-09 | Electronic accounting voucher processing method and device, electronic equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113158857A true CN113158857A (en) | 2021-07-23 |
Family
ID=76888935
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110381935.9A Pending CN113158857A (en) | 2021-04-09 | 2021-04-09 | Electronic accounting voucher processing method and device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113158857A (en) |
Cited By (7)
| 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 |
| CN114248572A (en) * | 2022-03-02 | 2022-03-29 | 远光软件股份有限公司 | Printing method and device of accounting document and storage medium |
| CN114495136A (en) * | 2022-04-14 | 2022-05-13 | 滨州市社会保险事业中心 | Financial data storage method, system, computer equipment and storage medium |
| CN114677188A (en) * | 2022-05-25 | 2022-06-28 | 国网浙江省电力有限公司 | 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 |
| CN115311651A (en) * | 2022-10-12 | 2022-11-08 | 泰安协同软件有限公司 | Real estate voucher 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 (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1628247A1 (en) * | 2004-08-21 | 2006-02-22 | Sap Ag | Database for accountancy purposes |
| US20170092062A1 (en) * | 2014-09-24 | 2017-03-30 | Jcm American Corporation | Electronic Voucher Ticket System |
| CN106815924A (en) * | 2016-12-22 | 2017-06-09 | 河南职业技术学院 | A kind of accounting voucher processing system |
| CN108961021A (en) * | 2018-05-18 | 2018-12-07 | 北京大账房网络科技股份有限公司 | It is taken pictures using Intelligent mobile equipment and generates the method and system of voucher |
| CN109636557A (en) * | 2018-12-11 | 2019-04-16 | 厦门商集网络科技有限责任公司 | A kind of intelligent classification bookkeeping methods and equipment based on bank slip recognition |
| US20190213832A1 (en) * | 2014-09-24 | 2019-07-11 | Jcm American Corporation | Electronic Voucher Ticket System |
| CN110363097A (en) * | 2019-06-21 | 2019-10-22 | 深圳壹账通智能科技有限公司 | Enterprise's portrait generation method and device based on financial statement |
| CN110675234A (en) * | 2019-08-23 | 2020-01-10 | 国信电子票据平台信息服务有限公司 | Electronic newspaper bill generation method and electronic equipment |
| CN110969408A (en) * | 2019-11-08 | 2020-04-07 | 国网辽宁省电力有限公司 | Material settlement full-process integrated management platform generation system and method |
| CN111091349A (en) * | 2019-12-10 | 2020-05-01 | 远光软件股份有限公司 | Voucher binding system, method and equipment |
| CN111931777A (en) * | 2020-06-30 | 2020-11-13 | 北京来也网络科技有限公司 | Invoice information processing method and device based on RPA and storage medium |
| WO2021017694A1 (en) * | 2019-07-31 | 2021-02-04 | 苏宁云计算有限公司 | Method and device for generating accounting document based on sap system |
-
2021
- 2021-04-09 CN CN202110381935.9A patent/CN113158857A/en active Pending
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1628247A1 (en) * | 2004-08-21 | 2006-02-22 | Sap Ag | Database for accountancy purposes |
| US20170092062A1 (en) * | 2014-09-24 | 2017-03-30 | Jcm American Corporation | Electronic Voucher Ticket System |
| US20190213832A1 (en) * | 2014-09-24 | 2019-07-11 | Jcm American Corporation | Electronic Voucher Ticket System |
| CN106815924A (en) * | 2016-12-22 | 2017-06-09 | 河南职业技术学院 | A kind of accounting voucher processing system |
| CN108961021A (en) * | 2018-05-18 | 2018-12-07 | 北京大账房网络科技股份有限公司 | It is taken pictures using Intelligent mobile equipment and generates the method and system of voucher |
| CN109636557A (en) * | 2018-12-11 | 2019-04-16 | 厦门商集网络科技有限责任公司 | A kind of intelligent classification bookkeeping methods and equipment based on bank slip recognition |
| CN110363097A (en) * | 2019-06-21 | 2019-10-22 | 深圳壹账通智能科技有限公司 | Enterprise's portrait generation method and device based on financial statement |
| WO2021017694A1 (en) * | 2019-07-31 | 2021-02-04 | 苏宁云计算有限公司 | 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 |
| CN110969408A (en) * | 2019-11-08 | 2020-04-07 | 国网辽宁省电力有限公司 | Material settlement full-process integrated management platform generation system and method |
| CN111091349A (en) * | 2019-12-10 | 2020-05-01 | 远光软件股份有限公司 | Voucher binding system, method and equipment |
| CN111931777A (en) * | 2020-06-30 | 2020-11-13 | 北京来也网络科技有限公司 | Invoice information processing method and device based on RPA and storage medium |
| CN112580640A (en) * | 2020-06-30 | 2021-03-30 | 北京来也网络科技有限公司 | Invoice information processing method and device combining RPA and AI |
Cited By (9)
| 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 |
| CN114248572A (en) * | 2022-03-02 | 2022-03-29 | 远光软件股份有限公司 | Printing method and device of accounting document and storage medium |
| CN114248572B (en) * | 2022-03-02 | 2022-07-01 | 远光软件股份有限公司 | Printing method and device of accounting document and storage medium |
| CN114495136A (en) * | 2022-04-14 | 2022-05-13 | 滨州市社会保险事业中心 | Financial data storage method, system, computer equipment and storage medium |
| CN114677188A (en) * | 2022-05-25 | 2022-06-28 | 国网浙江省电力有限公司 | 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 |
| CN115311651A (en) * | 2022-10-12 | 2022-11-08 | 泰安协同软件有限公司 | Real estate voucher data acquisition and arrangement method |
| 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 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113158857A (en) | Electronic accounting voucher processing method and device, electronic equipment and medium | |
| JP6179853B2 (en) | Accounting system, accounting program, and book | |
| US20150227785A1 (en) | Information processing apparatus, information processing method, and program | |
| JPH06501584A (en) | information processing equipment | |
| JP2011170490A (en) | SaaS GENERAL ACCOUNTING SYSTEM | |
| CN1541362B (en) | WebJINS information journal automatic editing system | |
| US20130006673A1 (en) | Consolidating Billing Statements in an Agency Business Model | |
| US20090049375A1 (en) | Selective processing of information from a digital copy of a document for data entry | |
| JP6001743B1 (en) | Data management system, method and program | |
| US20110052075A1 (en) | Remote receipt analysis | |
| CN110781875A (en) | Value-added tax invoice scanning and identifying platform and method | |
| CN111768281A (en) | General ledger voucher generation method, device and system | |
| JP6464440B1 (en) | Accounting processing apparatus, accounting processing system, accounting processing method and program | |
| JP6895632B1 (en) | Accounting equipment, accounting systems, accounting methods and programs | |
| CN113240503A (en) | Reimbursement invoice management method, device and medium based on intelligent equipment | |
| JP2010244227A (en) | Accounting input storage device | |
| JP6993200B2 (en) | Data display device, data display method and data display program | |
| JP2014109855A (en) | Print order reception/placement system and control method thereof | |
| KR20200026486A (en) | Method, apparatus and computer-readable medium of matching logo design based on enterprise analysis | |
| CN112801842A (en) | Tax information sharing platform | |
| JP7266083B2 (en) | Data display device, data display method and data display program | |
| JP6967174B1 (en) | Data processing equipment, data processing methods and programs | |
| JP2001005886A (en) | Data processor and storage medium | |
| KR20200057173A (en) | System and method for generating software specification document | |
| KR20190139453A (en) | Tax accounting processing apparatus and method for proving tax report result information therein |
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 |