A bill management and auditing method and system
Through the combination of the personal invoice pool module and the financial intelligent audit module, the digital management and intuitive audit of multiple bills are realized, the security problems existing in the process of bills are solved, and the accuracy of information and audit efficiency are improved.
Patent Information
- Application Number
- CN202411306113.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-19
- Publication Date
- 2024-11-19
- Estimated Expiration
- 2044-09-19
AI Technical Summary
It is difficult for the existing technology to realize the digital management and intuitive audit of multiple bills, and there are security issues such as difficulty in distinguishing authenticity, repeated printing reimbursement, and face-to-face information modification in the digitalization process.
Upload bill files through the personal invoice pool module, use OCR technology and bill template analysis to obtain bill information, generate bill forms, and combine the financial intelligent audit module to automatically fill in, check and risk assessment to ensure the accuracy and security of bill information. .
It realizes digital management and intuitive audit of multiple bills, improves the accuracy and security of bill information, simplifies the reimbursement process, and reduces the complexity of manual review.
Smart Images

Figure CN118822473B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of intelligent management technology, and in particular to a bill management and review method and system. Background Art
[0002] Artificial intelligence technology is being increasingly applied to the traditional financial accounting field. At present, in the daily management of many enterprises and institutions, people have applied artificial intelligence technologies such as character recognition, natural language processing, and machine learning to financial accounting, management accounting, internal control and other financial work, promoting financial work to gradually move towards intelligence. The financial systems of some companies have been able to realize the intelligent identification, management and review of bills, and achieve intelligent and process-based management. However, due to the wide variety of bills, different ways of obtaining them, and different billing platforms, it is difficult to digitize and manage bills intelligently. It is often necessary to treat and manage certain bills separately, which makes it difficult to achieve complete digitization. It is also often difficult to achieve intuitiveness in the bill review process, and it is also accompanied by security issues brought about by the digitization of bills, such as difficulty in distinguishing authenticity, repeated printing and reimbursement, and modification of bill information. Summary of the invention
[0003] The purpose of the present invention is to overcome the shortcomings of the above-mentioned prior art and provide a bill management and audit method that can realize digital management of various types of bills, improve the accuracy of bill information, and realize intuitive viewing and auditing of bill information, as well as a bill management and audit system that implements the management and audit method.
[0004] The present invention is achieved through the following technical solutions:
[0005] A bill management and review method comprises the following steps:
[0006] S1. Log in to the personal invoice pool and upload the invoice file. One invoice file contains at least one invoice.
[0007] S2. The personal invoice pool module receives the uploaded bill file, automatically identifies or parses the bill file, and obtains bill information of each bill, wherein the bill information includes the bill type, the coordinate values of the four corners of the outer frame where the bill is located, the fields on the bill and the coordinate information corresponding to each field, wherein the fields include the bill column name and the bill column content, and the coordinate information corresponding to each field is the coordinate values of the four corners of the rectangular frame where each field is located;
[0008] For non-digital electronic invoices uploaded in the format of JPG, JPEG, PNG, BMP, TIF, or PDF, the method for obtaining the invoice information is as follows: identify the invoices through OCR technology to obtain the invoice information of each invoice;
[0009] For digital electronic bills uploaded in PDF or OFD format, the bill information is obtained as follows: the bill is directly parsed to obtain the face information, which includes the bill type, bill column name, and bill column content; then the coordinate values of the four corners of the bill outer frame and the coordinate values of the four corners of the rectangular box containing the bill column name and bill column content are obtained through OCR technology;
[0010] For digital electronic invoices whose uploaded invoice files are in XML format, the method for obtaining the invoice information is as follows: presetting invoice templates for various types of electronic invoices, the coordinate values of the four corners of the outer frame where the invoice template is located are corresponding set values, and the invoice template is provided with a number of corresponding column names and fill-in boxes corresponding to the column names, and the corresponding coordinate values are pre-calibrated according to the positions of the four corners of the rectangular frame where the column names and fill-in boxes are located on the invoice template; directly parsing the digital electronic invoice in XML format to obtain the face information, the face information includes the invoice type, the invoice column name and the invoice column content, and selecting the corresponding invoice template according to the parsed invoice type Then, according to the mapping relationship between the bill column name on the bill information and the column name on the bill template, the corresponding bill column content is filled into the fill-in box on the bill template to form a simulated bill, and saved in PDF format as a preview of the bill, so that subsequent manual review is more intuitive, the coordinate values of the four corners of the outer frame where the bill template is located are the coordinate values of the four corners of the outer frame where the bill is located, the bill column name and the bill column content are the fields on the bill, and the coordinate values of the four corners of the rectangular frame where the column name and the fill-in box on the bill template are marked on the bill template are the coordinate values of the four corners of the rectangular frame where the corresponding bill column name and the bill column content are located;
[0011] S3. Select a preset mapping rule corresponding to the bill type according to the acquired bill type, and fill the acquired bill column content into the bill form of the corresponding type of bill according to the mapping rule to realize automatic form filling. One bill form corresponds to one bill, and the bill form is associated with the bill file corresponding to the bill; the bill form also includes an "Attachment Number" column and a "Preview" column. The "Attachment Number" column is used to automatically fill in the number of the bill file corresponding to the bill when it is uploaded. Click the number to view the corresponding bill file; the "Preview" column is used to automatically display a preview thumbnail of the bill file corresponding to the bill. For the bill file in XML format, its thumbnail is the preview thumbnail of the simulated bill in PDF format in step S2; when a preview thumbnail is clicked, an enlarged image of the preview thumbnail can be viewed;
[0012] S4. Manually check, modify and confirm the bill form, update and save the bill information corresponding to the bill form; this operation can manually correct the identification errors and omissions, and update the bill information in a timely manner;
[0013] S5. When checking the ticket, call the ticket checking interface or automatically log in to the ticket checking platform, import the key query fields in the latest ticket information, and conduct a preliminary check on the ticket. When the preliminary query result is inconsistent, no such ticket is found, or it cannot be checked (for some non-value-added tickets, such as train tickets, taxi tickets, etc., data cannot be imported for checking), display the corresponding query result, such as "inconsistent", "no such ticket" or "cannot be checked"; when the preliminary query result is specific ticket details, identify the ticket details to obtain ticket query information, compare the ticket query information with the latest ticket information one by one, if they are completely consistent, display "check passed", and when there is inconsistency, display the corresponding inconsistent content information;
[0014] S6. The bills entered in steps S1 to S5 become bills in the personal invoice pool. When the reimbursement phase is required, the corresponding bills in the personal invoice pool are imported through the reimbursement form creation module to create a reimbursement form. One reimbursement form corresponds to at least one bill, and the sum of the bill amounts of each bill automatically generates the reimbursement amount of the reimbursement form. After the reimbursement form is successfully submitted, the imported bills automatically enter the corporate invoice pool, and the bill number of the associated reimbursement form is imported into the bill form.
[0015] S7. The reimbursement form shall be subject to business review by the relevant business department;
[0016] S8. Financial audit is conducted for reimbursement. Financial audit includes financial intelligent audit and financial manual audit. Financial intelligent audit is conducted before financial manual audit. Financial intelligent audit includes checking the bills in the reimbursement form for duplicates. The bill duplication checking module is automatically called to compare the bills with the bills in the enterprise invoice pool to see if there are any duplicates. If so, a return order approval opinion is automatically generated, and the approval opinion shows the duplicate information of the relevant bills, and the reimbursement form is returned. If not, the bill verification platform is automatically logged in to check whether the bill is a reimbursed bill. If so, a return order approval opinion is automatically generated, and the approval opinion shows the reimbursement information of the relevant bills, and the reimbursement form is returned. If not, it shows that there is no duplicate information.
[0017] A bill list area and a bill image display area are provided on the manual bill review interface for business review and financial manual review. The bill list area displays bill information of each bill, and the bill image display area is used to display images of bill files corresponding to each bill.
[0018] Click on the bill to be reviewed in the bill list area, and connect the four coordinate points on the image of the corresponding bill file according to the coordinate values of the four corners of the outer frame of the corresponding bill obtained in step S2 to form a bill rectangular frame that frames the corresponding bill. The corresponding bill can be selected in the bill file image to facilitate manual review; especially when there are multiple bills on a bill file, the corresponding bill can be viewed intuitively.
[0019] Click on the corresponding bill column content in the bill information in the bill list area, and according to the coordinate values of the four corners of the rectangular box where the corresponding bill column content is located obtained in step S2, connect these four coordinate points on the bill image to form a content rectangular box that frames the corresponding bill column content. By selecting the corresponding bill column content, manual review is facilitated.
[0020] A further improved technical solution is that the financial review of the reimbursement form is preceded by a financial intelligent review before the financial manual review, and the financial intelligent review includes:
[0021] The priority of the expense report is assessed according to the preset rules. The expense reports to be reviewed are sorted according to the priority. The expense reports with higher priority are placed at the front and will be processed first.
[0022] The risk value of the reimbursement form is assessed according to the preset rules. If the risk value is less than the set value, the reimbursement form will be marked as pending review and can be directly assigned to the financial leader for review; if the risk value is greater than the set value, it will be marked as pending further review and the corresponding risk warning information will be displayed. It will be further reviewed by relevant financial personnel and can be assigned to the corresponding financial personnel.
[0023] A further improved technical solution is that if the bill inspection result of the bill imported into the reimbursement form is displayed as "unable to be inspected", the risk value is assessed to be greater than the set value, and it is marked for further review, and the bill inspection information of the corresponding bill is displayed. The financial personnel will conduct manual inspection or verification of the relevant bills, which can be assigned to the corresponding financial personnel.
[0024] A further improved technical solution is that for bills that cannot be automatically identified or parsed in step S2, they are defined as special bills, such as some unconventional bills, bills that cannot be identified due to bill stains or wrinkles, or bills that cannot be identified due to unclear bill files, malfunctions in the recognition system, etc., first add a bill rectangular frame to the outer frame of the special bill and a content rectangular frame to the corresponding bill column content on the bill file corresponding to the special bill, and then save the bill file and upload the bill file again through my invoice pool; in step S3, fill in the bill form of the special bill by manual entry, and obtain the bill information of the corresponding special bill from the bill form; in steps S7 and S8, display the bill rectangular frame of the special bill and the content rectangular frame on the corresponding bill column content in the bill image display area of the corresponding special bill, so as to facilitate subsequent review and viewing. The frame adding operation can be performed using corresponding software, such as image processing software (Paint, Photoshop, etc.) and PDF processing software (such as Adobe Acrobat, etc.).
[0025] A further improved technical solution is that in step S7, if the bills imported into the reimbursement form have a bill verification result that displays "no such bill", "inconsistent" or displays corresponding inconsistent content information, the reimbursement form cannot be submitted.
[0026] A further improved technical solution is that when there is an inconsistency in step S5, information about the corresponding inconsistent content is displayed, and then it also includes: manually modifying the inconsistent information in the bill form, updating and saving the bill information corresponding to the bill form, and re-checking the bill according to the method in S5 until they are completely consistent, and displaying "check passed", otherwise the reimbursement form associated with the bill cannot be submitted in step S7, and the modification record is saved for subsequent review.
[0027] Users can learn the authenticity of the bill and any inconsistencies with the original billing records from the feedback results. If the information inconsistency is caused by identification or input, it can be overcome through manual modification and the modification record will be retained. In the subsequent review stage, manual or related procedures will be required to further review whether the modified bill information is consistent with the actual face value information.
[0028] A further improved technical solution is that the bill verification platform is the National Value-Added Tax Invoice Verification Platform of the State Administration of Taxation.
[0029] A further improved technical solution is that the method for identifying non-digital electronic invoices through OCR technology in step S2 includes: first identifying the outer borders of each bill on the bill file to obtain the coordinate values of each bill border and the four corners of each bill border, and then identifying the contents within each bill border to obtain the bill information corresponding to each bill.
[0030] A further improved technical solution is that the method for identifying the content within each bill frame includes: first, determining whether the content within the bill frame includes a text layer. If so, directly extracting the text layer text; if not, performing image recognition through OCR technology, segmenting the text area in the image through the recognition model and identifying the text in the text area; obtaining each field based on the relative position relationship between the text, and determining the category of each field based on the matching of the position coordinates of the frame where each field is located with the template.
[0031] A bill management and review system, used to implement the above-mentioned bill management and review method, including a personal invoice pool module, an enterprise invoice pool module, a bill preview and display module, a bill inspection module, a reimbursement form creation module, a business review module and a financial review module;
[0032] The personal invoice pool module includes a bill file uploading unit, a bill identification and parsing unit, a bill form generating unit and a bill form management unit. The bill file uploading unit is used for users to upload bill files, and one bill file includes at least one bill; the bill identification and parsing unit is used to identify, parse and / or process the bills in the imported bill file when the bill file uploaded by the bill file uploading unit is imported into the personal invoice pool, so as to obtain the bill information of each bill; the bill form generating unit is used to automatically generate a bill form according to the bill information obtained by the bill identification and parsing unit, and when the bill cannot be identified, the user generates a bill form by manual entry and associates the corresponding bill file, and one bill form corresponds to one bill; the bill form management unit is used for manual modification, sorting and deletion of the bill form, and real-time update and storage of the bill information;
[0033] The enterprise invoice pool module is used to receive the bills imported from the personal invoice pool module, store the bills in the enterprise invoice pool, and provide retrieval services;
[0034] The bill preview display module is used to display the preview thumbnail of the bill file corresponding to each bill in the bill form, and display its enlarged image when clicking the preview thumbnail; and display the image of the bill file corresponding to each bill on the manual bill review interface of business review and financial review. When clicking the bill to be reviewed in the bill list area, the corresponding bill is framed on the bill file image, and when clicking the bill column content corresponding to the bill, the corresponding bill column content is framed on the corresponding bill image;
[0035] The bill inspection module is used for bill inspection. By calling the bill inspection interface or automatically logging into the bill inspection platform, the bill is automatically inspected according to the latest bill information of the bill to be inspected. When the inspection cannot be performed, the message "cannot be inspected" is fed back; when the inspection result is inconsistent or the bill does not exist, the message "inconsistent" or "no such bill" is fed back; when the specific bill details are obtained, the bill details are parsed and compared with the latest bill information of the bill one by one. If they are completely consistent, the message "inspection passed" is fed back; when there is inconsistency, the information of the corresponding inconsistent content is fed back;
[0036] The reimbursement form creation module is used for users to create reimbursement forms. Reimbursement forms can be created by importing corresponding bills in the personal invoice pool. One reimbursement form corresponds to at least one bill;
[0037] The business review module is used by relevant business departments to review the reimbursement form (manual review);
[0038] The financial audit module is used by the financial department to audit the reimbursement form, and includes a financial intelligent audit module and a financial manual audit module. The financial intelligent audit module includes a bill duplication checking unit, a priority assessment unit and a risk value assessment unit. The bill duplication checking unit is used to check whether the bills associated with the reimbursement form are duplicated. It compares the bill to be checked for duplicates with the bills in the enterprise invoice pool to verify whether they are duplicate bills, and logs in to the bill verification platform to check whether the bill is a reimbursed bill; the priority assessment unit is used to perform priority assessment on the reimbursement form, and the risk value assessment unit is used to perform risk value assessment on the reimbursement form, and make corresponding prompts based on the risk value assessment results.
[0039] The present invention generates a bill list by uploading a bill file and forms a personal invoice pool, which is convenient for individuals to manage their bills. When the bills in the personal invoice pool enter the corporate invoice pool, it is convenient to store and manage corporate bills. One bill file can contain multiple bills, which can simplify the operation of reimbursement personnel. One bill form only corresponds to one bill, and one reimbursement form can contain multiple bills, making the management of bills and reimbursement forms clear and reasonable. The bill identification and parsing unit can parse all bills under normal circumstances, and obtain the single bill information by identifying the outer frame of a single bill in the bill file. For digital electrical bills in PDF and OFD formats that can be viewed intuitively, data parsing can be performed directly. For digital electrical bills in XML format that cannot be viewed intuitively, a viewable and browsable simulated bill form is formed by setting a bill template, which is convenient for reimbursement personnel and auditors to review and check. By identifying the coordinate positions of the four corners of the outer frame of each bill in the bill file, the coordinate positions of the four corners of the frame where the bill column content is located, and in the XML format digital electrical bill template The coordinates of the bill border and the rectangular frame of the bill column content in the board are set. When browsing, the corresponding bill and bill column content can be directly selected, which improves the intuitiveness of viewing and auditing; for bills that cannot be automatically identified, these bills can be digitized by manual entry and manual framing. By processing bills in different situations separately, the unified management of digitalization and intelligentization of all bills can be finally achieved. In the manual review stage, there is no need to treat different bills differently, and the image and detailed information of the bill can be viewed; the automatically identified information can be manually checked and modified, and the bill information can be automatically checked in the bill inspection stage, which once again provides the opportunity for automatic verification and manual modification, and can further ensure the accuracy of the bill information; the financial intelligent audit module can automatically assess the risk value of the document and provide risk warnings, including warnings of problems found in the bill inspection stage; the personal invoice pool module and the corporate invoice pool module can be used for individuals and enterprises to manage their own bill information respectively, with clear management, and associated with the reimbursement form, which can achieve traceability. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 The figure is a flow chart of a bill management and review method according to an embodiment of the present invention.
[0041] Figure 2 Schematic diagram of a bill form page in an embodiment of the present invention.
[0042] Figure 3 This is a schematic diagram of a bill form editing page in an embodiment of the present invention.
[0043] Figure 4 This is a schematic diagram of importing a bill page when a reimbursement form is generated in an embodiment of the present invention.
[0044] Figure 5 It is a schematic diagram of the manual review page of the reimbursement form in an embodiment of the present invention.
[0045] Figure 6 The figure is a structural block diagram of the bill management and review system according to an embodiment of the present invention. DETAILED DESCRIPTION
[0046] A bill management and auditing method, such as Figure 1 As shown, the following steps are included:
[0047] S1. Log in to the personal invoice pool and upload the bill file through the personal invoice pool module. One bill file includes at least one bill.
[0048] The bill file can be an electronic bill, mainly digital bills in OFD, PDF, and XML formats. Generally, these bills are obtained through email or website downloads, and can be directly uploaded in the format of OFD, PDF, and XML files; it can also be a file obtained by taking a photo or scanning a paper bill, such as various machine-printed invoices, paper train tickets, taxi tickets, fixed-rate subway tickets, etc. Paper bills also include paper printouts of the above-mentioned digital bills, that is, digital bills in PDF and OFD formats are printed into paper tickets, such as railway electronic tickets, electronic ticket itineraries, electronic ordinary invoices, electronic value-added tax special invoices, bank electronic receipts, etc. (When this type of bill is recorded, its electronic accounting voucher must also be saved, that is, it must be archived in the form of an electronic file in XML format with a digital signature). The file can be in JPG, JPEG, TIFF, BMP, PDF and other formats.
[0049] One bill can be photographed or scanned into a bill file, or multiple bills can be arranged and photographed or scanned into a bill file. This is suitable for centralized scanning of multiple tickets of small denomination and small area, such as scanning taxi tickets, subway tickets, and train tickets of the same category into one bill file, which can also be used for travel reimbursement.
[0050] S2. The personal invoice pool module receives the uploaded bill files, automatically identifies or parses the bill files, and obtains the bill information of each bill, wherein the bill information includes the bill type, the coordinate values of the four corners of the outer frame where the bill is located, the fields on the bill and the coordinate information corresponding to each field, wherein the fields include the bill column name and the bill column content, and the coordinate information corresponding to each field is the coordinate values of the four corners of the rectangular frame where each field is located, including the coordinate values of the four corners of the rectangular frame where the bill column name and the bill column content are located.
[0051] The classification of bill types can be carried out according to the actual situation of the enterprise and the main purpose of the system, such as train tickets, accommodation tickets, itineraries, fixed-amount invoices, catering tickets, value-added tax invoices, etc., and can also be divided into electronic invoices (special value-added tax invoices), electronic invoices (ordinary invoices), special value-added tax invoices, ordinary value-added tax invoices, ordinary invoices, etc. Bill types can be classified by methods such as decision trees, support vector machines, neural networks and deep learning, or by key fields identified on the bills, all of which can use existing mature technologies.
[0052] The uploaded bill files have different formats. Bill files of different formats have different parsing or identification methods. They can be classified as follows according to different processing methods:
[0053] (1) For non-digital electronic invoices uploaded in the formats of JPG, JPEG, PNG, BMP, TIF, and PDF, the method for obtaining the invoice information is to identify them through OCR technology to obtain the invoice information of each invoice.
[0054] The method of identifying bill documents by OCR technology includes: first identifying the outer frame of each bill on the bill document, obtaining the coordinate values of each bill frame and the four corners of each bill frame. In the case where there is only one bill on a bill document, only one bill frame is obtained. In the case where there are multiple bills on a bill document, multiple bill frames and the coordinate values of the four corners of each bill frame can be obtained, and then the content in each bill frame is identified respectively. The identification of the bill frame can be achieved by using existing technologies such as contour detection, interpolation, color LSD line segment detection algorithm and some training models. In this way, when multiple bills are scanned in a bill file, each bill can be identified one by one, and the vertex coordinates of each bill frame can be obtained.
[0055] The method for identifying the content within each bill frame includes: firstly, determining whether the bill file includes a text layer, if it does, directly extracting the text layer text; if not, performing image recognition through OCR technology, segmenting the text area in the image through the recognition model and identifying the text in the text area; obtaining each field according to the relative position relationship between the texts, and determining the category of each field according to the matching of the position coordinates of the frame where each field is located with the template, whether it belongs to the bill column name or the bill column content, such as a train ticket, the relative position of the departure station, terminal station, train number, amount and other column contents is fixed. In this way, the key information of the bill can be obtained, including the coordinate values of the four corners of the rectangular frame where the contents of each bill column are located.
[0056] Using OCR technology to recognize text in images is a relatively mature technology. Existing technologies, such as some commercial software, can be used, or some commercial interfaces can be used to implement it, such as Baidu Smart Cloud OCR Interface, Tencent Cloud OCR Interface, and Alibaba Cloud OCR Service. The corresponding API interface can be selected according to the specific situation, and the corresponding call can be made according to the type of bill file.
[0057] (2) For digital electronic invoices uploaded in PDF or OFD format, the method for obtaining the invoice information is as follows: the invoice is directly parsed to obtain the face information, which includes the invoice type, invoice column name and invoice column content; then the coordinate values of the four corners of the outer frame of the invoice and the coordinate values of the four corners of the rectangular frame containing the invoice column name and invoice column content are obtained through OCR technology;
[0058] For digital electronic invoices in PDF and OFD formats, the invoice information can be parsed by corresponding parsing software, such as the invoice package software provided by the finance and taxation department. At the same time, it can be presented in the form of images, and OCR technology can be used to recognize text, outer borders and inner borders. Therefore, the invoice information can be obtained by combining invoice parsing with OCR recognition.
[0059] (2) For digital electronic invoices uploaded in XML format, in this case, generally one invoice file corresponds to one invoice. The method for obtaining the invoice information is as follows: preset invoice templates for various types of electronic invoices. Currently, there are only two types: special value-added tax invoices and ordinary invoices. According to technological development and actual needs, multiple templates that meet practical requirements can be expanded. The coordinate values of the four corners of the outer frame where the invoice template is located are corresponding set values, which can be preset according to the size of the layout. For example, the upper left corner is set as the coordinate origin, and the coordinates of the other three corners are converted according to the resolution of the set invoice template. The invoice template is provided with a number of corresponding column names and fill boxes corresponding to each of the column names. The corresponding coordinate values are pre-calibrated according to the positions of the four corners of the rectangular frame where each of the column names and fill boxes are located on the invoice template. These coordinate values are also obtained based on the coordinate origin.
[0060] The digital electronic bill in XML format is directly parsed to obtain the face information, which includes the bill type, bill column name and bill column content. After selecting the corresponding bill template according to the parsed bill type, the corresponding bill column content is filled in the fill-in box on the bill template according to the mapping relationship between the bill column name on the face information and the column name on the bill template to form a simulated bill, and saved in PDF format as a preview of the bill, which is convenient for viewing and makes subsequent manual review more intuitive. In this way, the coordinate values of the four corners of the outer frame where the bill template is located are the coordinate values of the four corners of the outer frame where the bill is located, the bill column name and the bill column content are the fields on the bill, and the coordinate values of the four corners of the rectangular frame where the column name and the fill-in box on the bill template are marked on the bill template are the coordinate values of the four corners of the rectangular frame where the corresponding bill column name and the bill column content are located.
[0061] For electronic invoices in XML format, the corresponding electronic voucher plug-in can be called for parsing, such as calling the invoice package software provided by the finance and taxation department for parsing. The parsed invoice information includes invoice code, number, invoice date, purchaser, seller, product details, tax amount and other information.
[0062] The reason why it is necessary to obtain the border coordinates of each bill, as well as the coordinate values of the four corners of the rectangular frame where each bill column name and bill column content are located, is to enable intuitive marking of the corresponding bills during subsequent preview, viewing, and review, for easy review.
[0063] S3. Select a preset mapping rule corresponding to the bill type according to the acquired bill type, and fill the acquired bill column content into the bill form of the corresponding type of bill according to the mapping rule to realize automatic form filling. One bill form corresponds to one bill, and the bill form is associated with the bill file corresponding to the bill; Figure 2The bill form also includes an "Attachment Number" column and a "Preview" column. The "Attachment Number" column is used to automatically fill in the number of the bill file corresponding to the bill when it is uploaded. Click the number to view the corresponding bill file; the "Preview" column is used to automatically display a preview thumbnail of the bill file corresponding to the bill. For bill files in XML format, the thumbnail is the preview thumbnail of the simulated bill in PDF format in step S2; when a preview thumbnail is clicked, an enlarged image of the preview thumbnail can be viewed. Figure 1 When there are multiple bills on a bill file, the same attachment number and image preview may be displayed on the bill form corresponding to these bills. The bill form also sets columns such as invoice number, invoice amount, reimbursement amount, bill type, related reimbursement form, and bill details according to the situation.
[0064] S4. Manually check, modify and confirm the bill form, and update and save the bill information corresponding to the bill form. Figure 3 As shown, errors and omissions in the identified data can be corrected and the bill information can be updated in a timely manner.
[0065] S5. When checking the bill (click the "Bill Check" button), call the bill check interface or automatically log in to the bill check platform. You can check through the existing commercial interface, such as the Baiwang interface, import the key query fields in the latest bill information, and perform a preliminary check on the bill. When the preliminary query result is inconsistent, no such bill or unable to check, the corresponding query results of "inconsistent", "no such bill" and "unable to check" are displayed.
[0066] In order to further verify the authenticity and correctness of the bill information, the present invention compares the information obtained by verification with the bill information in the invoice pool to find out the inconsistencies and take corresponding measures. Specifically, when the preliminary query result is a specific bill detailed information, the bill detailed information is identified to obtain the bill query information, and the bill query information is compared with the latest bill information one by one. If they are completely consistent, "verification passed" is displayed, and when there is an inconsistency, the corresponding inconsistent content information is displayed. The user can know the authenticity of the bill and the inconsistency with the original invoicing record from the feedback result. If the information is inconsistent due to identification or entry, it can be overcome by manual modification, and the modification record is retained. In the subsequent review link, manual or related procedures are required to further review whether the modified bill information is consistent with the actual face value information. The modified bill information can be further checked until it is completely consistent and "verification passed" is displayed, otherwise the reimbursement form associated with the bill cannot be submitted.
[0067] At present, the bill verification platform is generally the National VAT Invoice Verification Platform of the State Administration of Taxation, in which the key fields are mainly the four elements required for verification: invoice number, invoice code, invoice amount, and invoice date. Through this platform or the corresponding verification interface, it can be obtained whether each bill is consistent with the invoice information, whether the invoice exists, the relevant status of the invoice (whether it is invalid, reimbursed, etc.), the specific information of the invoice, etc. Different information is displayed according to different verification results. For some non-value-added tickets, such as train tickets, taxi tickets, etc., it is impossible to import data for verification, and the message "Unable to Verify" is displayed, and the relevant personnel are reminded to focus on the review during the manual review process. Manual inspection can be carried out through other verification channels.
[0068] S6. The bills entered in steps S1 to S5 become bills in the personal invoice pool. When you need to enter the reimbursement stage, you can import the corresponding bills in the personal invoice pool through the reimbursement form creation module to create a reimbursement form. One reimbursement form corresponds to at least one bill, and the sum of the bill amounts of each bill automatically generates the reimbursement amount of the reimbursement form. The specific operation can be as follows: Figure 4 As shown, just check the bill form of the corresponding bill to operate.
[0069] When the imported bills have a bill verification result of no such bill, inconsistency, or displaying corresponding inconsistent content information, the reimbursement form cannot be submitted.
[0070] After successfully submitting the reimbursement form, the imported bill will automatically enter the company's invoice pool, and the bill number of the associated reimbursement form will be imported into the bill form.
[0071] S7. The reimbursement form is reviewed by the relevant business department. The business department is generally the department associated with the reimbursement personnel, such as the department leader of the reimbursement personnel.
[0072] S8. Financial audit is conducted on the reimbursement form. Financial audit includes intelligent financial audit and manual financial audit. Intelligent financial audit is conducted before manual financial audit. Intelligent financial audit includes checking the duplicate bills in the reimbursement form. The duplicate bill checking module is automatically called to compare the bills with the bills in the enterprise invoice pool to see if there are any duplications. If so, it indicates that duplicate reimbursements have been made. A return order approval opinion is automatically generated, and the duplicate information of the relevant bills is displayed in the approval opinion. The reimbursement form is returned. If not, the bill verification platform is automatically logged in to check whether the bill is a reimbursed bill. If so, a return order approval opinion is automatically generated, and the reimbursement form is returned. If not, the information that there is no duplication is displayed.
[0073] To facilitate the review of documents by the business and financial personnel, the face value of the relevant documents can be viewed directly, such as Figure 5As shown, the present invention provides a bill list area and a bill image display area on the manual bill review interface for business review and financial manual review. The bill list area displays bill information of each bill, such as bill number, bill type, invoice code, face value, billing date, buyer, seller, commodity details, tax amount, etc. The bill image display area is used to display the image of the bill file corresponding to each bill. The following method can be used to achieve this:
[0074] When clicking on a bill to be reviewed in the bill list area, according to the coordinate values of the four corners of the outer frame of the corresponding bill obtained in step S2, these four coordinate points are connected on the image of the corresponding bill file to form a bill rectangular frame that frames the corresponding bill. The corresponding bill can be selected in the bill file image to facilitate manual review; especially in the case where there are multiple bills on a bill file, the corresponding bill can be quickly locked from the multiple bills for intuitive viewing.
[0075] Click on the corresponding bill column content in the bill information in the bill list area, and according to the coordinate values of the four corners of the rectangular box where the corresponding bill column content is located obtained in step S2, connect these four coordinate points on the bill image to form a content rectangular box that frames the corresponding bill column content. By selecting the corresponding bill column content, manual review is facilitated.
[0076] In this embodiment, the financial intelligent audit includes:
[0077] The priority of the reimbursement form is assessed according to the preset rules. The reimbursement forms to be reviewed are sorted according to the priority. The reimbursement forms with higher priorities are placed at the front and will be processed first. The priority assessment rules can be scored and comprehensively assessed based on indicators such as submission time, urgency, and document type.
[0078] The risk value of the reimbursement form is assessed according to the preset rules. If the risk value is less than the set value, the reimbursement form will be marked as pending review and can be directly assigned to the financial leader for review later; if the risk value is greater than the set value, it will be marked for further review and the corresponding risk warning information will be displayed. It will be further reviewed by the relevant financial personnel and can be assigned to the corresponding financial personnel for processing according to the situation.
[0079] If the bills imported into the reimbursement form have a bill verification result that cannot be verified, the risk value is assessed to be greater than the set value, and the bill is marked for further review. The bill verification information of the corresponding bill is displayed, and the financial staff will manually check or verify the relevant bills.
[0080] As one of the implementation methods, for the bills that cannot be automatically identified or parsed in step S2, they are defined as special bills, such as some unconventional bills (train tickets, fixed-amount invoices, etc.), or bills that cannot be identified due to damage or wrinkles, or bills that cannot be identified due to unclear bill documents, failure of the recognition system, etc., first, a bill rectangular frame is added to the outer frame of the special bill and a content rectangular frame is added to the corresponding bill column content on the bill file corresponding to the special bill, and the bill file is saved and then uploaded again through my invoice pool; in step S3, the bill form of the special bill is filled in by manual entry, and the bill information of the corresponding special bill is obtained from the bill form; in steps S7 and S8, the bill rectangular frame of the special bill and the content rectangular frame on the corresponding bill column content are displayed in the bill image display area of the corresponding special bill.
[0081] The framing operation can be performed using corresponding software, such as image processing software (Paint, Photoshop, etc.) and PDF processing software (such as Adobe Acrobat, etc.).
[0082] A bill management and audit system is used to implement the above-mentioned bill management and audit method, such as Figure 6 As shown, it includes a personal invoice pool module, an enterprise invoice pool module, a bill preview and display module, a bill verification module, a reimbursement form creation module, a business review module and a financial review module.
[0083] The personal invoice pool module includes a bill file uploading unit, a bill identification and parsing unit, a bill form generating unit and a bill form management unit. The bill file uploading unit is used for users to upload bill files, and one bill file includes at least one bill; the bill identification and parsing unit is used to identify, parse and / or process the bills in the imported bill file when the bill file uploaded by the bill file uploading unit is imported into the personal invoice pool, so as to obtain the bill information of each bill; the bill form generating unit is used to automatically generate a bill form according to the bill information obtained by the bill identification and parsing unit and associate it with the corresponding bill file, and when the bill cannot be identified, the user generates a bill form by manual entry and associates it with the corresponding bill file, and one bill form corresponds to one bill; the bill form management unit is used for manual modification, sorting and deletion of the bill form, and real-time update and storage of the bill information.
[0084] The enterprise invoice pool module is used to receive the bills imported from the personal invoice pool module, store the bills in the enterprise invoice pool, and provide retrieval services.
[0085] The bill preview display module is used to display preview thumbnails of bill files corresponding to each bill in the bill form, and to display an enlarged image when clicking on the preview thumbnail; and to display images of bill files corresponding to each bill on the manual review interface for business review and financial review. When clicking on a bill to be reviewed in the bill list area, a corresponding bill is framed on the bill file image; when clicking on the bill column content corresponding to the bill, a corresponding bill column content is framed on the corresponding bill image.
[0086] The bill inspection module is used for bill inspection. By calling the bill inspection interface or automatically logging into the bill inspection platform, the bill is automatically inspected according to the latest bill information of the bill to be inspected. When the inspection cannot be performed, the message "cannot be inspected" is fed back; when an inconsistent inspection result or the bill does not exist is obtained, the message "inconsistent" or "no such bill" is fed back; when specific bill detailed information is obtained, the bill detailed information is parsed and compared with the latest bill information of the bill one by one. If they are completely consistent, the message "inspection passed" is fed back; when there is an inconsistency, the information of the corresponding inconsistent content is fed back.
[0087] The reimbursement form creation module is used for users to create reimbursement forms. Reimbursement forms can be created by importing corresponding bills in the personal invoice pool. One reimbursement form corresponds to at least one bill.
[0088] The business review module is used by relevant business departments to review reimbursement forms, which is generally a manual review, and different levels of review are set according to the actual situation of the enterprise.
[0089] The financial audit module is used by the financial department to audit the reimbursement form, and includes a financial intelligent audit module and a financial manual audit module. The financial intelligent audit module includes a bill duplicate checking unit, a priority assessment unit and a risk value assessment unit. The bill duplicate checking unit is used to check whether the bills associated with the reimbursement form are duplicated. It verifies whether the bills to be checked are duplicated by comparing the bills in the enterprise invoice pool, and logs in to the bill verification platform to check whether the bill is a reimbursed bill; the priority assessment unit is used to perform priority assessment on the reimbursement form, and the risk value assessment unit is used to perform risk value assessment on the reimbursement form, and make corresponding prompts based on the risk value assessment results, such as prompting that some bills that cannot be automatically checked need to be manually checked, some bill forms have been modified many times and need to be paid special attention, and some bill forms are created by bills that cannot be automatically identified and need to be manually verified.
[0090] The above detailed description is a specific description of a feasible embodiment of the present invention. The embodiment is not intended to limit the patent scope of the present invention. Any equivalent implementation or modification that does not deviate from the present invention should be included in the patent scope of this case.
Claims
1. A bill management and auditing method, characterized in that: The steps include: S1. Log in to the personal invoice pool and upload the invoice file. One invoice file contains at least one invoice. S2. The personal invoice pool module receives the uploaded bill file, automatically identifies or parses the bill file, and obtains the bill information of each bill, wherein the bill information includes the bill type, the coordinate values of the four corners of the outer frame where the bill is located, the fields on the bill and the coordinate information corresponding to each field, wherein the fields include the bill column name and the bill column content, and the coordinate information corresponding to each field is the coordinate values of the four corners of the rectangular frame where each field is located; For non-digital electronic invoices uploaded in the format of JPG, JPEG, PNG, BMP, TIF, or PDF, the method for obtaining the invoice information is as follows: identify the invoices through OCR technology to obtain the invoice information of each invoice; For digital electronic bills uploaded in PDF or OFD format, the bill information is obtained as follows: the bill is directly parsed to obtain the face information, which includes the bill type, bill column name, and bill column content; the coordinate values of the four corners of the bill outer frame and the coordinate values of the four corners of the rectangular box containing the bill column name and bill column content are obtained by OCR technology; For digital electricity bills whose bill files are uploaded in XML format, the method for obtaining the bill information is as follows: presetting bill templates for various types of digital electricity bills, the coordinate values of the four corners of the outer frame where the bill template is located are corresponding set values, and the bill template is provided with a number of corresponding column names and fill-in boxes corresponding to each of the column names, and the corresponding coordinate values are pre-calibrated according to the positions of the four corners of the rectangular frame where each of the column names and the fill-in boxes are located on the bill template; directly parsing the digital electricity bill in XML format to obtain the bill face information, the bill face information includes the bill type, bill column name and bill column content, and selecting the corresponding bill template according to the parsed bill type Then, according to the mapping relationship between the bill column name on the bill information and the column name on the bill template, the corresponding bill column content is filled into the fill-in box on the bill template to form a simulated bill, and saved in PDF format as a preview of the bill, so that subsequent manual review is more intuitive, the coordinate values of the four corners of the outer frame where the bill template is located are the coordinate values of the four corners of the outer frame where the bill is located, the bill column name and the bill column content are the fields on the bill, and the coordinate values of the four corners of the rectangular frame where the column name and the fill-in box on the bill template are marked on the bill template are the coordinate values of the four corners of the rectangular frame where the corresponding bill column name and the bill column content are located; S3. Select a preset mapping rule corresponding to the bill type according to the acquired bill type, and fill the acquired bill column content into the bill form of the corresponding type of bill according to the mapping rule to realize automatic form filling. One bill form corresponds to one bill, and the bill form is associated with the bill file corresponding to the bill; the bill form also includes an "Attachment Number" column and a "Preview" column. The "Attachment Number" column is used to automatically fill in the number of the bill file corresponding to the bill when it is uploaded. Click the number to view the corresponding bill file; the "Preview" column is used to automatically display a preview thumbnail of the bill file corresponding to the bill. For the bill file in XML format, its thumbnail is the preview thumbnail of the simulated bill in PDF format in step S2; when a preview thumbnail is clicked, an enlarged image of the preview thumbnail can be viewed; S4. Manually check, modify and confirm the bill form, and update and save the bill information corresponding to the bill form; S5. When checking the bill, call the bill checking interface or automatically log in to the bill checking platform, import the key query fields in the latest bill information, and perform a preliminary check on the bill. When the preliminary query result is inconsistent, no such bill is found, or it cannot be checked, the corresponding query result "inconsistent", "no such bill" or "cannot be checked" is displayed; when the preliminary query result is specific bill details, identify the bill details to obtain bill query information, and compare the bill query information with the latest bill information one by one. If they are completely consistent, "check passed" is displayed, and when there is inconsistency, the corresponding inconsistent content information is displayed; S6. The bills entered in steps S1 to S5 become bills in the personal invoice pool. When the reimbursement phase is required, the corresponding bills in the personal invoice pool are imported through the reimbursement form creation module to create a reimbursement form. One reimbursement form corresponds to at least one bill, and the sum of the bill amounts of each bill automatically generates the reimbursement amount of the reimbursement form. After the reimbursement form is successfully submitted, the imported bills automatically enter the corporate invoice pool, and the bill number of the associated reimbursement form is imported into the bill form. S7. The reimbursement form shall be subject to business review by the relevant business department; S8. Financial audit is conducted on reimbursement. Financial audit includes financial intelligent audit and financial manual audit. Financial intelligent audit is conducted before financial manual audit. Financial intelligent audit includes checking the duplicate bills in the reimbursement form. The bill duplication checking module is automatically called to compare the bills with the bills in the enterprise invoice pool to see if there are any duplications. If so, a return order approval opinion is automatically generated and the reimbursement form is returned. If not, the bill verification platform is automatically logged in to check whether the bill is a reimbursed bill. If so, a return order approval opinion is automatically generated and the reimbursement form is returned. If not, the information that there is no duplication is displayed. A bill list area and a bill image display area are provided on the manual bill review interface for business review and financial manual review. The bill list area displays bill information of each bill, and the bill image display area is used to display images of bill files corresponding to each bill. Click on the bill to be reviewed in the bill list area, and connect the four coordinate points on the image of the corresponding bill file to form a bill rectangular frame that frames the corresponding bill according to the coordinate values of the four corners of the outer frame of the corresponding bill obtained in step S2, so as to facilitate manual review by selecting the corresponding bill in the bill file image; Click on the corresponding bill column content in the bill information in the bill list area, and according to the coordinate values of the four corners of the rectangular box where the corresponding bill column content is located obtained in step S2, connect these four coordinate points on the bill image to form a content rectangular box that frames the corresponding bill column content. By selecting the corresponding bill column content, manual review is facilitated.
2. A bill management and auditing method according to claim 1, characterized in that: The financial review of the reimbursement form is preceded by a financial intelligent review before the financial manual review. The financial intelligent review includes: The priority of the expense report is assessed according to the preset rules. The expense reports to be reviewed are sorted according to the priority. The expense reports with higher priority are placed at the front and will be processed first. The risk value of the reimbursement form is assessed according to the preset rules. If the risk value is less than the set value, the reimbursement form will be marked for review; if the risk value is greater than the set value, it will be marked for further review and the corresponding risk warning information will be displayed for further review by relevant financial personnel.
3. A bill management and auditing method according to claim 2, characterized in that: If the bill inspection result of the bill imported into the reimbursement form is displayed as "Unable to Verify", its risk value is assessed to be greater than the set value, and it is marked for further review. The bill inspection information of the corresponding bill is displayed, and the financial staff will manually inspect or verify the relevant bill.
4. A bill management and auditing method according to claim 1, characterized in that: For bills that cannot be automatically identified or parsed in step S2, they are defined as special bills. First, a bill rectangular frame is added to the outer frame of the special bill and a content rectangular frame is added to the corresponding bill column content on the bill file corresponding to the special bill. After saving the bill file, the bill file is uploaded again through my invoice pool; in step S3, the bill form of the special bill is filled in manually, and the bill information of the corresponding special bill is obtained from the bill form; in steps S7 and S8, the bill rectangular frame of the special bill and the content rectangular frame on the corresponding bill column content are displayed in the bill image display area corresponding to the special bill.
5. A bill management and auditing method according to claim 1, characterized in that: In step S7, if the bills imported into the reimbursement form have a bill verification result showing "no such bill found", "inconsistent" or showing corresponding inconsistent content information, the reimbursement form cannot be submitted.
6. A bill management and auditing method according to claim 1, characterized in that: If there is any inconsistency in step S5, the corresponding inconsistent content information will be displayed. Then it also includes: manually modifying the inconsistent content in the bill form, updating and saving the bill information corresponding to the bill form, and re-checking the bill according to the method in S5 until they are completely consistent and "check passed" is displayed. Otherwise, the reimbursement form associated with the bill cannot be submitted in step S7, and the modification record is saved for subsequent review.
7. A bill management and auditing method according to claim 1, characterized in that: The bill verification platform mentioned is the National Value-Added Tax Invoice Verification Platform of the State Administration of Taxation.
8. A bill management and auditing method according to claim 1, characterized in that: The method for identifying non-digital electronic invoices by OCR technology in step S2 includes: first identifying the outer frame of each bill on the bill file to obtain the coordinate values of each bill frame and the four corners of each bill frame, and then identifying the content within each bill frame to obtain the bill information corresponding to each bill.
9. A bill management and auditing method according to claim 8, characterized in that: The method for identifying the content within each bill frame includes: first, determining whether the content within the bill frame includes a text layer. If so, directly extracting the text layer text; if not, performing image recognition through OCR technology, segmenting the text area in the image through the recognition model and identifying the text in the text area; obtaining each field according to the relative position relationship between the text, and determining the category of each field according to the matching of the position coordinates of the frame where each field is located with the template.
10. A bill management and review system, used to implement the bill management and review method according to any one of claims 1 to 9, characterized in that: It includes personal invoice pool module, enterprise invoice pool module, bill preview and display module, bill verification module, expense report creation module, business review module and financial review module; The personal invoice pool module includes a bill file uploading unit, a bill identification and parsing unit, a bill form generating unit and a bill form management unit. The bill file uploading unit is used for users to upload bill files, and one bill file includes at least one bill; the bill identification and parsing unit is used to identify and / or parse the bills in the imported bill file when the bill file uploaded by the bill file uploading unit is imported into the personal invoice pool, so as to obtain the bill information of each bill; the bill form generating unit is used to automatically generate a bill form according to the bill information obtained by the bill identification and parsing unit, and when the bill cannot be identified, the user generates a bill form by manual entry and associates the corresponding bill file, and one bill form corresponds to one bill; the bill form management unit is used for manual modification, sorting and deletion of the bill form, and real-time update and storage of the bill information; The enterprise invoice pool module is used to receive the bills imported from the personal invoice pool module, store the bills in the enterprise invoice pool, and provide retrieval services; The bill preview display module is used to display a preview thumbnail of the bill file corresponding to each bill in the bill form, and display its enlarged image when clicking the preview thumbnail; In addition, the image of the bill file corresponding to each bill is displayed on the manual bill review interface of business review and financial review. When a bill to be reviewed in the bill list area is clicked, the corresponding bill is framed on the bill file image. When the bill column content corresponding to the bill is clicked, the corresponding bill column content is framed on the corresponding bill image. The bill inspection module is used for bill inspection. It automatically inspects the bill according to the latest bill information of the bill to be inspected. If the inspection cannot be performed, the message "cannot be inspected" is fed back. If the inspection result is inconsistent or the bill does not exist, the message "inconsistent" or "no such bill" is fed back. When the specific bill details are obtained, the bill details are parsed and compared with the latest bill information of the bill one by one. If they are completely consistent, the message "inspection passed" is fed back. If there is inconsistency, the information of the corresponding inconsistent content is fed back. The reimbursement form creation module is used for users to create reimbursement forms by importing corresponding bills from the personal invoice pool. One reimbursement form corresponds to at least one bill. The business review module is used by relevant business departments to review the reimbursement form; The financial audit module is used by the financial department to audit the reimbursement form, and includes a financial intelligent audit module and a financial manual audit module. The financial intelligent audit module includes a bill duplication checking unit, a priority assessment unit and a risk value assessment unit. The bill duplication checking unit is used to check whether there are duplicate bills associated with the reimbursement form. It compares the bill to be checked for duplicates with the bills in the enterprise invoice pool to verify whether they are duplicate bills, and logs in to the bill verification platform to check whether the bill is a reimbursed bill; the priority assessment unit is used to perform priority assessment on the reimbursement form, and the risk value assessment unit is used to perform risk value assessment on the reimbursement form, and make corresponding prompts based on the risk value assessment results.
Citation Information
Patent Citations
Bill auditing system and method thereof
CN114862540A
