Electronic bookkeeping method and electronic bookkeeping system
By analyzing and writing EXCEL tables, the data in electronic vouchers are automatically extracted and processed, solving the problem of low manual accounting efficiency and achieving an efficient and accurate electronic accounting process.
Patent Information
- Application Number
- CN202411125097.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-16
- Publication Date
- 2024-11-22
AI Technical Summary
Currently, accountants still use manual accounting, which is inefficient and error-prone, and cannot efficiently process electronic invoices and other electronic vouchers.
By obtaining the original vouchers, analyzing and writing their data into a preset EXCEL table, the electronic data is extracted using the OCR recognition tool, and automatic accounting is completed in the accounting software interface, replacing the manual accounting process.
It improves accounting efficiency, reduces the error rate, realizes automatic accounting of electronic vouchers, and improves the accuracy and efficiency of accounting work.
Smart Images

Figure CN119006194A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of electronic accounting, and in particular to an electronic accounting method and an electronic accounting system. Background Art
[0002] At present, enterprises use electronic invoices (digital invoices) to issue or receive invoices, banks also use electronic receipts, and employees also use electronic expense reports for reimbursement. These electronic expense reports can be obtained through the corresponding system, usually in PDF or image format.
[0003] Currently, accountants still use manual bookkeeping methods to keep accounts, which is inefficient and prone to errors. Summary of the invention
[0004] In view of this, the present application discloses an electronic accounting method. The method may include: obtaining an original voucher; parsing the original voucher to obtain electronic data corresponding to a preset EXCEL table header field; writing the electronic data into the preset EXCEL and displaying it on an interface of an accounting software; in response to completing a selection operation for a target original voucher on the interface, completing accounting according to the target electronic data corresponding to the target original voucher.
[0005] In some embodiments, the parsing of the original voucher to obtain the electronic data corresponding to the preset EXCEL table header field includes: obtaining the voucher type of the original voucher and a parsing template corresponding to the voucher type; the parsing template includes at least one box; the position corresponding to the box in the original voucher contains the electronic data corresponding to the preset EXCEL table header field; enlarging the original voucher to the same size as the parsing template; using a screenshot tool to cut out the frame diagrams corresponding to each frame in the original voucher; performing text recognition on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
[0006] In some embodiments, the text recognition is performed on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field, including: using an OCR recognition tool to perform text recognition on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
[0007] In some embodiments, writing the electronic data into the preset EXCEL includes: obtaining the header field of the parsed electronic data; writing the electronic data into a blank position in the EXCEL corresponding to the header field, wherein the electronic data parsed from the same original voucher is located in the same row of the EXCEL.
[0008] In some embodiments, in response to completing the selection operation for the target original voucher on the interface, completing the accounting according to the target electronic data corresponding to the target original voucher, includes: in response to completing the selection operation for the target original voucher on the interface, obtaining the preset electronic data under the preset field in the EXCEL; filling the preset electronic data of each preset field into the corresponding field in the preset accounting voucher template to generate an accounting voucher.
[0009] In some embodiments, the method further includes: in response to completing a selection operation for a target original voucher on the interface, obtaining field data of the other party company corresponding to the target original voucher; in response to the existence of a target accounting voucher corresponding to the field data of the other party company, writing each electronic data corresponding to the target original voucher into the target accounting voucher.
[0010] In some embodiments, the method further includes: in response to operations on the EXCEL, using the built-in functions of the EXCEL to complete corresponding processing and obtain processing results; the operations of the EXCEL include at least one of the following: formula calculation, graphing, screening, and sorting; the formula calculation includes summary and summation; and the processing results are displayed through the interface of the accounting software.
[0011] In some embodiments, the method further includes: in response to completing accounting according to the target electronic data corresponding to the target original voucher, binding the target original voucher with the accounting voucher generated by the accounting; in response to a printing operation for the accounting voucher, providing the user with options for each original voucher bound to the accounting voucher; in response to the original voucher selected by the user, printing the accounting voucher and the selected original voucher.
[0012] In some embodiments, the method further includes: in response to a review operation on the accounting voucher, providing the user with options for various original vouchers bound to the accounting voucher; in response to the original voucher selected by the user, displaying the accounting voucher and the selected original voucher.
[0013] The present application also proposes an electronic accounting system, comprising: an acquisition unit, which acquires original vouchers; a parsing unit, which parses the original vouchers to obtain various electronic data corresponding to the header fields of a preset EXCEL table; a display unit, which writes the electronic data into the preset EXCEL and displays it on the interface of the accounting software; and an accounting unit, which completes accounting according to the target electronic data corresponding to the target original voucher in response to completing a selection operation for the target original voucher on the interface.
[0014] In the scheme recorded in any of the aforementioned embodiments, the obtained original voucher can be parsed to obtain the electronic data corresponding to the preset EXCEL table header fields and written into EXCEL for display. Automatic accounting can also be performed according to the selected target original voucher, thereby replacing manual accounting, improving accounting efficiency and reducing error rate.
[0015] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS
[0016] In order to more clearly illustrate the technical solutions in one or more embodiments of the present application or related technologies, the drawings required for use in the embodiments or related technology descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in one or more embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.
[0017] The following is a brief introduction to the drawings required for use in the embodiments or related technical descriptions.
[0018] Figure 1 A schematic diagram of a method flow of an electronic accounting method shown in this application.
[0019] Figure 2 A flowchart of a method for parsing original vouchers is shown in this application.
[0020] Figure 3 A schematic flow chart of a method for printing a voucher shown in the present application.
[0021] Figure 4 A flowchart of a method for checking vouchers shown in this application.
[0022] Figure 5 This is a schematic diagram of the structure of an electronic accounting system shown in this application. DETAILED DESCRIPTION
[0023] The exemplary embodiments will be described in detail below, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are only examples of devices and methods consistent with some aspects of the present application as detailed in the attached claims.
[0024] The terms used in this application are only for the purpose of describing specific embodiments, and are not intended to limit this application. The singular forms of "a", "said" and "the" used in this application and the appended claims are also intended to include plural forms, unless the context clearly indicates other meanings. It should also be understood that the term "and / or" used in this article refers to and includes any or all possible combinations of one or more associated listed items. It should also be understood that the word "if" used in this article, depending on the context, can be interpreted as "at the time of" or "when" or "in response to determining".
[0025] In view of this, the present application proposes an electronic accounting method. The method can parse the acquired original voucher, obtain the electronic data corresponding to the preset EXCEL table header field, write it into EXCEL for display, and can also automatically record the account according to the selected target original voucher, thereby replacing manual accounting, improving accounting efficiency and reducing error rate.
[0026] The following is a description of the embodiments with reference to the accompanying drawings.
[0027] See also Figure 1 , Figure 1 The following is a flow chart of an electronic bookkeeping method shown in this application. Figure 1 As shown, the method may include S102-S108.
[0028] S102, obtaining the original voucher.
[0029] S104, parsing the original voucher to obtain the electronic data corresponding to the preset EXCEL table header fields.
[0030] S106, writing the electronic data into the preset EXCEL and displaying it on the interface of the accounting software.
[0031] S108, in response to completing the selection operation for the target original voucher on the interface, completing the accounting according to the target electronic data corresponding to the target original voucher.
[0032] The original vouchers include electronic invoices, bank receipts, expense reimbursement forms, etc. Take electronic invoices as an example.
[0033] For example:
[0034] The first step is to obtain the original voucher: Assume that a small business purchased office supplies and received the following electronic invoice as the original voucher: Invoice number: INV-20240727; Date: July 27, 2024; Amount: RMB 1,000; Project name: Office expenses. The above fields are only examples, and more fields will be included in actual situations.
[0035] The second step is to parse the original voucher: the accounting software automatically parses the electronic invoice and extracts the following data: Invoice number: INV-20240727; Date: July 27, 2024; Amount: RMB 1,000; Project name: Office expenses. These data are parsed according to the preset Excel table format.
[0036] The third step is to write the preset Excel table and display it in the accounting software interface:
[0037] Fill the electronic data obtained by analysis into the preset Excel table, as shown in Table 1.
[0038] Table 1:
[0039]
[0040] These data are also displayed on the accounting software interface for accountants to view and operate.
[0041] Step 4. In response to completing the selection operation for the target original voucher on the interface: the accountant selects the electronic invoice (INV-20240727) to be recorded on the accounting software interface.
[0042] Step 5: Complete accounting: The system automatically generates accounting voucher entries based on the selected electronic invoice data, as shown in Table 2.
[0043] Table 2:
[0044]
[0045] The system automatically completed the accounting of this office expense based on accounting rules and settings.
[0046] Through the scheme recorded in S102-S108, the obtained original voucher can be parsed to obtain the electronic data corresponding to the preset EXCEL table header fields and write them into EXCEL for display. It can also automatically record accounts according to the selected target original voucher, thereby replacing manual accounting, improving accounting efficiency and reducing error rate.
[0047] In some embodiments, image processing methods may be used to complete the parsing of the original voucher.
[0048] See also Figure 2 , Figure 2 A flowchart of a method for parsing original vouchers is shown in this application. Figure 2 This is an explanation of S104. Figure 2 As shown, the method may include S202-S212.
[0049] S202, obtaining the voucher type of the original voucher and a parsing template corresponding to the voucher type; the parsing template includes at least one box; the position corresponding to the box in the original voucher contains electronic data corresponding to a preset EXCEL table header field.
[0050] S204, enlarging the original voucher to the same size as the parsed template.
[0051] S206, using a screenshot tool, screenshots are taken from the original voucher to obtain the block diagrams corresponding to each box.
[0052] S208, performing text recognition on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain each electronic data corresponding to the preset EXCEL table header field.
[0053] S210, obtaining the header fields of the parsed electronic data.
[0054] S212, writing the electronic data into a blank position corresponding to the header field in the EXCEL, wherein the electronic data parsed from the same original voucher is located in the same row of the EXCEL.
[0055] For example: parsing office supplies purchase invoices and importing them into Excel spreadsheets.
[0056] The first step is to obtain the voucher type and corresponding parsing template of the original voucher. Original vouchers include electronic invoices, electronic receipts, expense reports, etc. There are also many types of electronic invoices. Different original voucher patterns are different, and the storage locations of electronic data are different, so the parsing templates need to be differentiated.
[0057] Suppose we have an office supplies purchase invoice as the original voucher, which contains the following information: Voucher type: Office supplies purchase invoice; Parsing template: Contains multiple boxes for identifying information such as product name, quantity, unit price and total price.
[0058] The boxes in the parsing template correspond to the preset Excel table fields:
[0059] Invoice Number: in the first box; Item Type: in the second box; Amount: in the third box; Date: in the fourth box.
[0060] The preset Excel table contains the following header fields: Invoice Number, Item Name, Amount, Date.
[0061] Step 2. Enlarge the original document to the size of the parsed template:
[0062] Use image processing software to enlarge or reduce the office supplies purchase invoice to the same as the parsing template in order to accurately identify the product information, quantity, unit price and total price.
[0063] The third step is to capture the box image:
[0064] Use a screenshot tool or a programmable image processing tool to respectively capture the block diagrams corresponding to the first box, the second box, the third box, and the fourth box from the illustration of the purchase invoice.
[0065] The fourth step is text recognition processing: using the OCR recognition tool, each frame is subjected to text recognition to obtain the electronic data contained in each frame, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
[0066] Apply optical character recognition (OCR) technology to each captured block diagram to convert the text in the image into readable electronic data:
[0067] First box: Identify the invoice number as INV-20240727;
[0068] Box 2: Identify the item name as Office Expenses;
[0069] The third-party box: identifies the unit price as 1,000 yuan;
[0070] Box 4: Identify the date as July 27, 2024.
[0071] The identified electronic data can then be imported into a preset Excel table, as shown in Table 1.
[0072] The solution recorded in S202-S208 can utilize image processing technology to extract necessary data from the original voucher and import it into a preset Excel table for further recording and management.
[0073] In some embodiments, in response to completing the selection operation for the target original voucher on the interface, the preset electronic data under the preset field in the EXCEL can be obtained; the preset electronic data of each preset field is filled into the corresponding field in the preset accounting voucher template to generate an accounting voucher. In this way, automatic accounting from original vouchers to accounting vouchers can be achieved.
[0074] For example, you can maintain the mapping relationship between each header field in EXCEL and each field in the accounting voucher in advance, and then fill in the electronic data corresponding to the selected target original voucher in EXCEL into the corresponding field of the accounting voucher template to generate the accounting voucher and realize automatic accounting.
[0075] In some embodiments, in response to completing the selection operation for the target original voucher on the interface, the field data of the counterpart company corresponding to the target original voucher is obtained; in response to the existence of a target accounting voucher corresponding to the field data of the counterpart company, each electronic data corresponding to the target original voucher is written into the target accounting voucher.
[0076] For example, if there is already an accounting voucher corresponding to Company A and an original voucher related to Company A is received, the electronic data can be written into the accounting voucher corresponding to Company A to achieve data aggregation and more standardized accounting.
[0077] In some embodiments, in response to the operation on the EXCEL, the built-in function of the EXCEL is used to complete the corresponding processing and obtain the processing result; the operation of the EXCEL includes at least one of the following: formula operation, drawing, screening, sorting; the formula operation includes summing up;
[0078] The processing results are displayed through the interface of the accounting software.
[0079] For example, users can perform formula calculations, drawing, filtering, sorting and other operations in the EXCEL displayed by the accounting software. The accounting software integrates the functions of EXCEL and can process and display them accordingly. For example, if the user selects several original vouchers and summarizes the amount, the accounting software can use the SUM function to obtain the summary amount and display it.
[0080] In some embodiments, the binding and storage of original vouchers and accounting vouchers can be completed to facilitate printing.
[0081] See also Figure 3 , Figure 3 This is a flow chart of a method for printing a voucher as shown in this application. Figure 3 As shown, the method may include S302-S306.
[0082] S302, in response to completing bookkeeping according to the target electronic data corresponding to the target original voucher, binding the target original voucher with the accounting voucher generated by the bookkeeping.
[0083] S304: In response to a printing operation on the accounting voucher, providing the user with options for various original vouchers bound to the accounting voucher.
[0084] S306, in response to the original voucher selected by the user, printing the accounting voucher and the selected original voucher.
[0085] For example, in accounting software, after an accounting voucher is generated, the original voucher number can be bound to the accounting voucher to ensure that the original data can be traced back when needed.
[0086] Users can perform the following operations through the accounting software: Print option: When the user chooses to print the accounting voucher, the system provides an option that allows the user to choose whether to print the original voucher bound to the accounting voucher. Select the original voucher: If the user chooses to print the original voucher, the system will display all the original vouchers bound to the accounting voucher (such as invoice INV123456). Print accounting vouchers and original vouchers: When the user confirms the selection of invoice INV123456, the system will print a copy of the accounting voucher and invoice INV123456 at the same time, ensuring the integrity of the accounting records and facilitating auditing.
[0087] In some embodiments, the binding and storage of original vouchers and accounting vouchers are completed for easy reference.
[0088] See also Figure 4 , Figure 4 This is a flow chart of a method for checking vouchers shown in this application. Figure 4 As shown, the method may include S402-S404.
[0089] S402: In response to a review operation on the accounting voucher, providing the user with options for various original vouchers bound to the accounting voucher.
[0090] S404, in response to the original voucher selected by the user, display the accounting voucher and the selected original voucher.
[0091] For example, in accounting software, after an accounting voucher is generated, the original voucher number can be bound to the accounting voucher to ensure that the original data can be traced back when needed.
[0092] Users can perform the following operations through the accounting software: View options: When the user chooses to view an accounting voucher, the system provides an option that allows the user to choose whether to query the original voucher bound to the accounting voucher. Select original voucher: If the user selects the original voucher to be queried, the system will display all the original vouchers bound to the accounting voucher (such as invoice INV123456). Display accounting vouchers and original vouchers: When the user confirms the selection of invoice INV123456, the system will display a copy of the accounting voucher and invoice INV123456 at the same time, ensuring the integrity of the accounting records and facilitating auditing.
[0093] Corresponding to any method embodiment, the present application also proposes an electronic accounting system. Figure 5 , Figure 5 This is a schematic diagram of the structure of an electronic accounting system shown in this application. Figure 5 As shown, the electronic accounting system 500 includes:
[0094] The acquisition unit 510 acquires the original certificate:
[0095] The parsing unit 520 parses the original voucher to obtain electronic data corresponding to the header fields of the preset EXCEL table;
[0096] The display unit 530 writes the electronic data into the preset EXCEL and displays it on the interface of the accounting software;
[0097] The accounting unit 540, in response to completing the selection operation for the target original voucher on the interface, completes the accounting according to the target electronic data corresponding to the target original voucher.
[0098] In some embodiments, the parsing unit 520 further:
[0099] Obtaining the voucher type of the original voucher and a parsing template corresponding to the voucher type; the parsing template includes at least one box; the position corresponding to the box in the original voucher contains electronic data corresponding to a preset EXCEL table header field;
[0100] Enlarging the original voucher to the same size as the parsed template;
[0101] Using a screenshot tool, cut out the block diagrams corresponding to each box from the original voucher;
[0102] Perform text recognition on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
[0103] In some embodiments, the parsing unit 520 further:
[0104] Using the OCR recognition tool, each frame diagram is subjected to text recognition to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
[0105] In some embodiments, the display unit 530 further:
[0106] Obtain the header fields of the parsed electronic data;
[0107] The electronic data is written into a blank position in the EXCEL corresponding to the header field, wherein the electronic data parsed from the same original voucher is located in the same row of the EXCEL.
[0108] In some embodiments, the accounting unit 540 further:
[0109] In response to completing the selection operation for the target original voucher on the interface, obtaining the preset electronic data under the preset field in the EXCEL;
[0110] Fill in the preset electronic data of each preset field into the corresponding field in the preset accounting voucher template to generate an accounting voucher.
[0111] In some embodiments, the accounting unit 540 further:
[0112] In response to completing the selection operation for the target original voucher on the interface, acquiring the counterparty company field data corresponding to the target original voucher;
[0113] In response to the existence of a target accounting voucher corresponding to the field data of the counterpart company, each electronic data corresponding to the target original voucher is written into the target accounting voucher.
[0114] In some embodiments, the system 500 further includes a processing unit configured to:
[0115] In response to the operation on the EXCEL, the built-in function of the EXCEL is used to complete the corresponding processing and obtain the processing result; the operation of the EXCEL includes at least one of the following: formula operation, drawing, screening, sorting; the formula operation includes summing up;
[0116] The processing results are displayed through the interface of the accounting software.
[0117] In some embodiments, the system 500 further includes a printing module for:
[0118] In response to completing bookkeeping according to the target electronic data corresponding to the target original voucher, binding the target original voucher with the accounting voucher generated by the bookkeeping;
[0119] In response to a printing operation on the accounting voucher, providing the user with options of various original vouchers bound to the accounting voucher;
[0120] In response to the original document selected by the user, the accounting document and the selected original document are printed.
[0121] In some embodiments, the system 500 further includes a review module for:
[0122] In response to a review operation on the accounting voucher, providing the user with options for each original voucher bound to the accounting voucher;
[0123] In response to the original document selected by the user, the accounting document and the selected original document are displayed.
[0124] In this system, the acquired original vouchers can be parsed to obtain the electronic data corresponding to the preset EXCEL table header fields and written into EXCEL for display. Automatic accounting can also be performed based on the selected target original vouchers, thereby replacing manual accounting, improving accounting efficiency and reducing error rates.
[0125] Those skilled in the art should understand that one or more embodiments of the present application may be provided as a method, system or computer program product. Therefore, one or more embodiments of the present application may take the form of a complete hardware embodiment, a complete software embodiment or an embodiment combining software and hardware. Moreover, one or more embodiments of the present application may take the form of a computer program product implemented on one or more computer-usable storage media (which may include but are not limited to disk storage, CDROM, optical storage, etc.) containing computer-usable program code.
[0126] The term "and / or" in the present application means at least one of the two. For example, "A and / or B" may include three options: A, B, and "A and B".
[0127] Each embodiment in the present application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the data processing device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0128] The above describes a specific embodiment of the present application. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the accompanying drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0129] The subject matter described in this application and the embodiments of the functional loading can be implemented in the following: digital electronic circuits, tangibly embodied computer software or firmware, computer hardware that can include the structure disclosed in this application and its structural equivalents, or a combination of one or more of them. The embodiments of the subject matter described in this application can be implemented as one or more computer programs, that is, one or more modules in the computer program instructions encoded on a tangible non-temporary program carrier to be executed by a data processing device or control the loading of a data processing device. Alternatively or additionally, the program instructions can be encoded on an artificially generated propagation signal, such as a machine-generated electrical, optical or electromagnetic signal, which is generated to encode information and transmit it to a suitable receiver device for execution by a data processing device. The computer storage medium can be a machine-readable storage device, a machine-readable storage substrate, a random or serial access memory device, or a combination of one or more of them.
[0130] The processes and logic flows described in this application can be performed by one or more programmable computers executing one or more computer programs to perform corresponding functions by loading according to input data and generating output. The processes and logic flows can also be performed by special-purpose logic circuits, such as FPGAs (field programmable gate arrays) or ASICs (application-specific integrated circuits), and the apparatus can also be implemented as special-purpose logic circuits.
[0131] A computer suitable for executing a computer program may include, for example, a general and / or special purpose microprocessor, or any other type of central processing unit. Typically, the central processing unit will receive instructions and data from a read-only memory and / or a random access memory. The basic components of a computer may include a central processing unit for implementing or executing instructions and one or more memory devices for storing instructions and data. Typically, a computer will also include one or more large-capacity storage devices for storing data, such as a disk, a magneto-optical disk, or an optical disk, or the computer will be loadably coupled to this large-capacity storage device to receive data from it or to transmit data to it, or both. However, a computer does not necessarily have such a device. In addition, a computer may be embedded in another device, such as a mobile phone, a personal digital assistant (PDA), a mobile audio or video player, a game console, a global positioning system (GPS) receiver, or a portable storage device such as a universal serial bus (USB) flash drive, to name a few.
[0132] Computer readable media suitable for storing computer program instructions and data may include all forms of non-volatile memory, media and memory devices, such as semiconductor memory devices (e.g., EPROM, EEPROM and flash memory devices), magnetic disks (e.g., internal hard disks or removable disks), magneto-optical disks, and CD ROM and DVD ROM disks. The processor and memory may be supplemented by, or incorporated in, special purpose logic circuits.
[0133] Although the application includes many specific implementation details, these should not be interpreted as limiting any disclosed scope or the scope of protection claimed, but are mainly used to describe the features of specific disclosed specific embodiments. Certain features described in multiple embodiments in the application can also be implemented in combination in a single embodiment. On the other hand, the various features described in a single embodiment can also be implemented separately in multiple embodiments or implemented with any suitable sub-combination. In addition, although the feature can work in some combinations as described and even initially claim protection, one or more features from the claimed combination can be removed from the combination in some cases, and the claimed combination can point to a variation of a sub-combination or a sub-combination.
[0134] Similarly, although loads are depicted in a particular order in the accompanying drawings, this should not be understood as requiring that these loads be executed in the particular order shown or executed sequentially, or requiring that all illustrated loads be executed to achieve the desired results. In some cases, multitasking and parallel processing may be advantageous. In addition, the separation of various system modules and components in the described embodiments should not be understood as requiring such separation in all embodiments, and it should be understood that the described program components and systems can generally be integrated together in a single software product, or packaged into multiple software products.
[0135] Thus, specific embodiments of the subject matter have been described. Other embodiments are within the scope of the appended claims. In some cases, the actions recited in the claims can be performed in a different order and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the particular order or sequential order shown to achieve the desired results. In some implementations, multitasking and parallel processing may be advantageous.
[0136] The above are only preferred embodiments of one or more embodiments of the present application and are not intended to limit one or more embodiments of the present application. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of one or more embodiments of the present application should be included in the scope of protection of one or more embodiments of the present application.
Claims
1. An electronic accounting method, characterized in that: The method comprises: Obtain original vouchers; Parse the original voucher to obtain electronic data corresponding to the header fields of the preset EXCEL table; Writing the electronic data into the preset EXCEL and displaying it on the interface of the accounting software; In response to completing the selection operation for the target original voucher on the interface, accounting is completed according to the target electronic data corresponding to the target original voucher.
2. The electronic accounting method according to claim 1, characterized in that: The original voucher is parsed to obtain electronic data corresponding to the preset EXCEL table header fields, including: Obtaining the voucher type of the original voucher and a parsing template corresponding to the voucher type; the parsing template includes at least one box; the position corresponding to the box in the original voucher includes electronic data corresponding to a preset EXCEL table header field; Enlarging the original voucher to the same size as the parsed template; Using a screenshot tool, cut out the block diagrams corresponding to each box from the original voucher; Perform text recognition on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
3. The electronic accounting method according to claim 2, characterized in that: The text recognition is performed on each frame diagram to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field, including: Using the OCR recognition tool, each frame diagram is subjected to text recognition to obtain the electronic data contained in each frame diagram, so as to obtain the electronic data corresponding to the preset EXCEL table header field.
4. The electronic accounting method according to claim 1, characterized in that: The step of writing the electronic data into the preset EXCEL comprises: Obtain the header fields of the parsed electronic data; The electronic data is written into a blank position in the EXCEL corresponding to the header field, wherein the electronic data parsed from the same original voucher is located in the same row of the EXCEL.
5. The electronic accounting method according to claim 1, characterized in that: In response to completing the selection operation for the target original voucher on the interface, completing the accounting according to the target electronic data corresponding to the target original voucher, including: In response to completing the selection operation for the target original voucher on the interface, obtaining the preset electronic data under the preset field in the EXCEL; Fill in the preset electronic data of each preset field into the corresponding field in the preset accounting voucher template to generate an accounting voucher.
6. The electronic accounting method according to claim 5, characterized in that: The method further comprises: In response to completing the selection operation for the target original voucher on the interface, acquiring the counterparty company field data corresponding to the target original voucher; In response to the existence of a target accounting voucher corresponding to the field data of the counterpart company, each electronic data corresponding to the target original voucher is written into the target accounting voucher.
7. The electronic accounting method according to claim 1, characterized in that: The method further comprises: In response to the operation on the EXCEL, the built-in function of the EXCEL is used to complete the corresponding processing and obtain the processing result; the operation of the EXCEL includes at least one of the following: formula operation, drawing, screening, sorting; the formula operation includes summing up; The processing results are displayed through the interface of the accounting software.
8. The electronic accounting method according to claim 1, characterized in that: The method further comprises: In response to completing bookkeeping according to the target electronic data corresponding to the target original voucher, binding the target original voucher with the accounting voucher generated by the bookkeeping; In response to a printing operation on the accounting voucher, providing the user with options of various original vouchers bound to the accounting voucher; In response to the original document selected by the user, the accounting document and the selected original document are printed.
9. The electronic accounting method according to claim 8, characterized in that: The method further comprises: In response to a review operation on the accounting voucher, providing the user with options for each original voucher bound to the accounting voucher; In response to the original document selected by the user, the accounting document and the selected original document are displayed.
10. An electronic accounting system, characterized in that: include: Get the unit and get the original certificate: A parsing unit, parsing the original voucher to obtain electronic data corresponding to a preset EXCEL table header field; A display unit writes the electronic data into the preset EXCEL and displays it on the interface of the accounting software; The accounting unit completes accounting according to the target electronic data corresponding to the target original voucher in response to completing the selection operation for the target original voucher on the interface.
