Disclosure of Invention
The invention aims to overcome the defects of the prior art, and provides a bill management auditing method capable of realizing digital management of various bills, improving the accuracy of bill information and realizing intuitive checking and auditing of the bill information, and a bill management auditing system for realizing the management auditing method.
The invention is realized by the following technical scheme:
A bill management auditing method comprises the following steps:
S1, logging in a personal invoice pool, uploading a bill file, wherein one bill file at least comprises one bill;
S2, the personal invoice pool module receives the uploaded bill file, automatically identifies or analyzes the bill file to obtain bill information of each bill, wherein the bill information comprises the bill type, coordinate values of four corners of an outer frame where the bill is located, fields on the bill and coordinate information corresponding to each field, the fields comprise bill column names and bill column contents, and the coordinate information corresponding to each field is coordinate values of four corners of a rectangular frame where each field is located;
For a non-digital electronic bill with a JPG, JPEG, PNG, BMP, TIF, PDF format of an uploaded bill file, the bill information acquisition method comprises the following steps: identifying through OCR technology to obtain bill information of each bill;
For digital electronic bills with PDF and OFD formats of uploading bill files, the bill information acquisition method comprises the following steps: directly analyzing the bill to obtain bill surface information, wherein the bill surface information comprises bill types, bill column names and bill column contents, and obtaining coordinate values of four corners of an outer frame of the bill and coordinate values of four corners of a rectangular frame where each bill column name and each bill column contents are located through an OCR technology;
For a digital electronic bill with an uploading bill file in an XML format, the bill information acquisition method comprises the following steps: presetting bill templates of various electronic bills, wherein coordinate values of four corners of an outer frame where the bill templates are positioned are corresponding set values, a plurality of corresponding column names and filling frames corresponding to the column names are arranged on the bill templates, and corresponding coordinate values are calibrated in advance according to the positions of the four corners of a rectangular frame where the column names and the filling frames are positioned on the bill templates; directly analyzing the digital electronic bill in the XML format to obtain bill surface information, wherein the bill surface information comprises bill types, bill column names and bill column contents, selecting corresponding bill templates according to the analyzed bill types, correspondingly filling the corresponding bill column contents into filling frames on the bill templates according to the mapping relation between the bill column names on the bill surface information and the column names on the bill templates to form a simulated bill, and storing the simulated bill in a PDF format as a preview form of the bill, so that subsequent manual examination is more visual, coordinate values of four corners of an outer frame where the bill templates are positioned are coordinate values of four corners of the outer frame where the bill is positioned, the bill column names and the bill column contents are fields on the bill, and coordinate values of four corners of a rectangular frame where the bill column names and the filling frames are positioned on the bill templates are coordinate values of four corners of the rectangular frame where the corresponding bill column names and the bill column contents are positioned on the bill templates;
s3, selecting a preset mapping rule corresponding to the bill type according to the acquired bill type, filling the acquired bill column content into a bill form of the bill of the corresponding type according to the mapping rule, realizing automatic bill filling, wherein one bill form corresponds to one bill, and associating the bill form with a bill file corresponding to the bill; the bill form also comprises an accessory number column and a preview column, wherein the accessory number column is used for automatically filling in the number of the bill file corresponding to the bill when uploading, and the bill file corresponding to the bill can be checked by clicking the number; the preview column is used for automatically displaying a preview thumbnail of the bill file corresponding to the bill, and for the bill file in the XML format, the thumbnail is a preview thumbnail of the simulated bill in the PDF format in the step S2; when clicking on a preview thumbnail, an enlarged view of the preview thumbnail can be viewed;
s4, checking, modifying and confirming the bill form manually, updating and storing bill information corresponding to the bill form; the operation can manually correct and identify the place of missing, and update bill information in time;
S5, when checking the bill, calling a bill checking interface or automatically logging in a bill checking platform, importing key query fields in the latest bill information, performing preliminary checking on the bill, and when the preliminary query results are inconsistent, the bill is not checked or cannot be checked (for some non-value-added tickets, such as train tickets, taxi tickets and the like, data cannot be imported for checking), displaying corresponding query results, such as 'inconsistent', 'no ticket checked' or 'cannot be checked'; when the preliminary query result is specific bill detailed information, identifying the bill detailed information to obtain bill query information, comparing the bill query information with the latest bill information one by one, if the bill query information is completely consistent, displaying 'checking pass', and if the bill query information is inconsistent, displaying information of corresponding inconsistent content;
S6, each bill recorded according to the steps S1 to S5 becomes a bill in the personal invoice pool, when a reimbursement link is required to be entered, the reimbursement bill is created by introducing the corresponding bill in the personal invoice pool through the reimbursement bill creation module, one reimbursement bill at least corresponds to one bill, and the reimbursement amount of the reimbursement bill is automatically generated by the sum of the bill amounts of the bills; after successfully submitting the reimbursement bill, the imported bill automatically enters an enterprise invoice pool, and a bill number of the associated reimbursement bill is imported into the bill form;
S7, the reimbursement sheets are subjected to business audit by related business departments;
S8, reimbursement is conducted, wherein the financial verification comprises financial intelligent verification and financial manual verification, the financial intelligent verification comprises ticket checking and weight checking of the tickets in the reimbursement bill before the financial manual verification, a ticket checking and weight checking module is automatically called, the tickets are firstly compared with the tickets in an enterprise invoice pool, if the tickets are repeated, a reimbursement opinion is automatically generated, the repeated information of the related tickets is displayed in the approval opinion, and the reimbursement bill is returned; if not, the automatic login bill checking platform checks whether the bill is a reimbursed bill, if so, automatically generates a return bill approval opinion, displays the reimbursed information of the related bill in the approval opinion, returns the reimbursed bill, and if not, displays no repeated information;
a bill list area and a bill image display area are arranged on a manual bill examination interface of business examination and financial manual examination, the bill list area displays bill information of each bill, and the bill image display area is used for displaying images of bill files corresponding to each bill;
Clicking the bill to be audited in the bill list area, connecting 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 where the corresponding bill is located, which are obtained in the step S2, so as to form a bill rectangular frame for framing the corresponding bill, and selecting the corresponding bill from the bill file image to facilitate manual audit; especially for the condition that a plurality of notes are arranged on one note file, the corresponding notes can be visually checked
Clicking corresponding bill column contents in the bill information in the bill list area, connecting the four coordinate points on the bill image according to the coordinate values of four corners of the rectangular frame where the corresponding bill column contents are located, forming a rectangular frame of contents for framing the corresponding bill column contents, and selecting the corresponding bill column contents through the frame to facilitate manual checking.
The further improved technical scheme is that the financial audit of the reimbursement bill is performed with financial intelligent audit before the financial artificial audit, and the financial intelligent audit comprises:
evaluating the priority of the reimbursement sheets according to a preset rule, sorting the reimbursement sheets to be audited according to the priority, and arranging the reimbursement sheets with high priority in front to be processed preferentially;
Evaluating the risk value of the reimbursement bill according to a preset rule, and if the risk value is smaller than a set value, marking the reimbursement bill as to-be-checked, wherein the reimbursement bill can be directly distributed to a financial lead for checking; if the risk value is larger than the set value, marking the risk value as to be further audited, displaying corresponding risk prompt information, and further auditing by the financial related personnel, wherein the risk value can be distributed to the corresponding financial personnel.
The further improved technical scheme is that if the bill checking result in the bill imported in the reimbursement bill shows that the bill cannot be checked, the risk value is greater than the set value, the bill is marked as to be checked further, bill checking information of the corresponding bill is displayed, and the financial staff can manually check or verify the related bill and can distribute the bill to the corresponding financial staff.
The further improved technical scheme is that for the bill incapable of being automatically identified or analyzed in the step S2, special bills, such as some unconventional bills, or the bill incapable of being identified due to bill pollution and fold, or the bill incapable of being identified due to unclear bill files, failure of an identification system and the like, are defined, firstly, a rectangular bill frame is added on the outer frame of the special bill on the bill file corresponding to the special bill, and a rectangular content frame is added on the corresponding bill column content, and after the bill file is stored, the bill file is uploaded through a my invoice pool again; in the S3 step, filling in a bill form of the special bill in a manual input mode, and obtaining bill information of the corresponding special bill from the bill form; and S7 and S8, displaying the bill rectangular frame of the special bill and the content rectangular frame on the content of the corresponding bill column in the bill image display area corresponding to the special bill, so that the subsequent checking and checking are facilitated. The framing operation may be performed using corresponding software, such as picture processing software (drawing, photoshop, etc.), PDF processing software (Adobe Acrobat, etc.).
In the further improved technical scheme, in the step S7, if the bill checking result in the bill imported by the reimbursement bill shows that the bill is checked out, the bill is inconsistent or the corresponding inconsistent content information is displayed, the reimbursement bill cannot be submitted.
The further improved technical scheme is that in the step S5, when the inconsistency exists, the information of the corresponding inconsistent content is displayed, and then the method further comprises the following steps: and (3) manually modifying the inconsistent information content in the bill form, updating and storing the bill information corresponding to the bill form, checking the bill again according to the method in the step (S5) until the bill is completely consistent, displaying that the check is passed, otherwise, failing to submit the reimbursement bill associated with the bill in the step (S7), and storing the modification record for subsequent checking and checking.
The user can know the true or false condition of the bill and the place inconsistent with the original billing record, such as inconsistent information caused by identification or input, can be overcome by manual modification, the modification record is reserved, and manual or related programs are needed in the subsequent auditing link to further audit whether the modified bill information is consistent with the real bill information.
The further improved technical scheme is that the bill checking platform is a national value-added tax bill checking platform of the national tax administration.
The further improved technical scheme is that the method for identifying the non-digital electronic bill in the step S2 through the OCR technology comprises the following steps: the method comprises the steps of firstly identifying the outer frames of all the notes on a note file to obtain coordinate values of all the note frames and four corners of all the note frames, and then respectively identifying the content in all the note frames to obtain note information corresponding to all the notes.
The further improved technical scheme is that the method for identifying the content in each bill frame comprises the following steps: firstly, judging whether the content in the bill frame comprises a text layer or not, if the content comprises the text layer, directly extracting the characters of the text layer; if not, performing image recognition by OCR technology, dividing a character area in the image by a recognition model, and recognizing characters in the character area; and obtaining each field according to the relative position relation among the characters, and judging the category of each field according to the matching condition of the position coordinates of the frame where each field is located and the template.
The bill management auditing system is used for realizing the bill management auditing method and comprises a personal invoice pool module, an enterprise invoice pool module, a bill preview display module, a bill checking module, a reimbursement bill creation module, a business auditing module and a financial auditing module;
The personal invoice pool module comprises a bill file uploading unit, a bill identification and analysis unit, a bill form generating unit and a bill form management unit, wherein the bill file uploading unit is used for a user to upload a bill file, and one bill file at least comprises one bill; the bill identification and analysis unit is used for identifying, analyzing or/and processing bills in the imported bill files when the bill files uploaded by the bill file uploading unit are imported into the personal invoice pool, so as to obtain bill information of each bill; the bill form generating unit is used for automatically generating bill forms according to the bill information obtained by the bill identification and analysis unit, and when the bill cannot be identified, a user generates the bill forms in a manual input mode and associates corresponding bill files, and one bill form corresponds to one bill; the bill form management unit is used for manually modifying, sorting and deleting bill forms, and updating and storing bill information in real time;
the enterprise invoice pool module is used for receiving the bills imported from the personal invoice pool module, storing the bills in the enterprise invoice pool and providing retrieval service;
The bill preview display module is used for displaying preview thumbnail of the bill files corresponding to each bill in the bill form and displaying an enlarged view when clicking the preview thumbnail; displaying images of bill files corresponding to all bills on a manual bill checking interface for business checking and financial checking, selecting corresponding bills from the bill file image upper frame when clicking the bill to be checked in the bill list area, and selecting corresponding bill column contents from the corresponding bill image upper frame when clicking the bill column contents corresponding to the bills;
The bill checking module is used for checking the bill, and automatically checking the bill according to the latest bill information of the bill to be checked by calling a bill checking interface or automatically logging in a bill checking platform, and feeding back the information of 'failure to check' when the bill cannot be checked; when the checking result of inconsistent or no ticket is obtained, feeding back information of ' inconsistent ' or no ticket ' to be checked; when specific bill detailed information is obtained, analyzing the bill detailed information and comparing the bill detailed information with the latest bill information of the bill one by one, if the bill detailed information is completely consistent, feeding back information of 'checking passing' and if the bill detailed information is inconsistent, feeding back information of corresponding inconsistent content;
The reimbursement bill creation module is used for a user to create reimbursement bills, wherein the reimbursement bills can be created by leading corresponding bills in a personal invoice pool, and one reimbursement bill at least corresponds to one bill;
the business auditing module is used for auditing (manual auditing) the reimbursement sheets by related business departments;
The financial auditing module is used for auditing the reimbursement bill by a financial department and comprises a financial intelligent auditing module and a financial manual auditing module, the financial intelligent auditing module comprises a bill checking unit, a priority rating unit and a risk value rating unit, the bill checking unit is used for checking whether the bill associated with the reimbursement bill is repeated or not, comparing the bill to be checked with the bill in an enterprise invoice pool, verifying whether the bill is a repeated bill or not, and logging in a bill checking platform to check whether the bill is the reimbursed bill or not; the priority rating unit is used for carrying out priority rating on the reimbursement bill, and the risk value rating unit is used for carrying out risk value rating on the reimbursement bill and making a corresponding prompt according to the risk value rating condition.
The invention generates the bill ticket by uploading the bill document, and forms the personal invoice pool, which is convenient for individuals to manage the bill, and when the bill in the personal invoice pool enters the enterprise invoice pool, the storage and management of the enterprise bill are convenient; the bill file can contain a plurality of bills, so that the operation of reimbursement staff can be simplified, one bill form corresponds to one bill, and one reimbursement bill can contain a plurality of bills, so that the management of the bills and the reimbursement bill is clear and reasonable; the bill identification and analysis unit can analyze all bills under normal conditions, and can acquire single bill information by identifying the outer frame of a single bill in a bill file, can directly analyze data for digital bills in PDF and OFD formats which can be visually checked, and can form a browsable analog bill form which can be checked and browsed by arranging a bill template for digital bills in XML formats which cannot be visually checked, so that the checking and checking of reimbursement staff and auditing staff can be facilitated; through the identification of four-corner coordinate positions of the outer frames of all the bills, the identification of four-corner coordinate positions of the frames of the contents of the bills and the setting of rectangular frame coordinates of the bills and the contents of the bills in an XML format digital bill template, corresponding bills and contents of the bills can be directly selected in a frame during browsing and checking, and the intuitiveness of checking and checking is improved; the notes which cannot be automatically identified can be digitized in a manual input and manual framing mode, and the digital and intelligent unified management of all notes is finally realized through the respective processing of the notes under different conditions, so that different notes are not required to be treated differently in a manual auditing link, and the images and detailed information of the notes can be checked; the automatic identification information can be manually checked and modified, meanwhile, the bill information can be automatically checked in the bill checking link, the automatic checking opportunity and the manual modification opportunity are provided again, and the accuracy of the bill information can be further ensured; the financial intelligent auditing module can automatically evaluate the risk value of the bill and carry out risk prompt, including prompting the problem found in the bill checking link; the personal invoice pool module and the enterprise invoice pool module can be used for managing the bill information of individuals and enterprises respectively, are clear in management, are associated with reimbursement bills, and can realize tracing.
Detailed Description
A bill management auditing method, as shown in figure 1, comprises the following steps:
S1, logging in a personal invoice pool, uploading a bill file through a personal invoice pool module, wherein one bill file at least comprises one bill.
The bill file can be an electronic bill, mainly a OFD, PDF, XML-format digital bill, generally the bill is obtained by downloading through a mailbox and a website, and is directly uploaded in a OFD, PDF, XML file format; the paper bill also comprises the paper printing piece of the digital bill, namely, the digital bill in PDF and OFD formats is printed into the paper bill, such as railway electronic ticket, electronic ticket travel ticket, electronic common invoice, electronic value-added tax special invoice, bank electronic receipt and the like (when the bill is checked in, the electronic accounting document of the bill must be saved at the same time, namely, the bill is archived by an XML format electronic file containing a digital signature), and the file can be JPG, JPEG, TIFF, BMP, PDF formats.
One bill can be photographed or scanned into one bill file, or a plurality of bills can be photographed or scanned into one bill file after being arranged, so that the method is suitable for centralized scanning of a plurality of bills with small denomination and small area, such as scanning rentals, subway tickets and train tickets of the same category into one bill file, and can be used for reimbursement in travel.
S2, the personal invoice pool module receives the uploaded bill file, automatically identifies or analyzes the bill file to obtain bill information of each bill, wherein the bill information comprises the bill type, coordinate values of four corners of an outer frame where the bill is located, fields on the bill and coordinate information corresponding to the fields, the fields comprise bill column names and bill column contents, and the coordinate information corresponding to the fields is coordinate values of four corners of a rectangular frame where the fields are located and comprises coordinate values of four corners of the rectangular frame where the bill column names and the bill column contents are located.
The classification of the bill type can be performed according to the actual situation of enterprises and the main use of the system, for example, the bill type can be classified into a train ticket, an accommodation ticket, a travel ticket, a rating ticket, a catering ticket, a value-added tax ticket and the like, and the bill type can be classified into an electronic invoice (value-added tax special invoice), an electronic invoice (common invoice), a value-added tax special invoice, a value-added tax common invoice, a common invoice and the like according to the bill type. The bill types can be classified by methods such as decision trees, support vector machines, neural networks, deep learning and the like, and also can be classified by key fields identified on the bill surface, and all the methods can adopt the existing mature technology.
The uploaded bill files have different formats, the bill files with different formats have different analysis or identification modes, and the bill files can be classified according to different processing modes:
(1) For a non-digital electronic bill with a JPG, JPEG, PNG, BMP, TIF, PDF format of an uploaded bill file, the bill information acquisition method comprises the following steps: and (5) identifying by an OCR technology to obtain bill information of each bill.
The method for identifying the bill file by the OCR technology comprises the following steps: the method comprises the steps of firstly identifying the outer frames of all the notes on a note file to obtain coordinate values of all the note frames and four corners of all the note frames, only obtaining one note frame for the case of only one note on one note file, obtaining a plurality of note frames and coordinate values of all the four corners of all the note frames for the case of a plurality of notes on one note file, and then respectively identifying the content in all the note frames. The identification of bill frames can be realized by adopting the prior art such as contour detection, interpolation method, color LSD line segment detection algorithm and some training models. Therefore, when a plurality of notes are scanned in one note file, each note can be identified one by one, and the vertex coordinates of each note frame are obtained.
The method for identifying the content in each bill frame comprises the following steps: firstly, judging whether the bill file comprises a text layer, if so, directly extracting characters of the text layer; if not, performing image recognition by OCR technology, dividing a character area in the image by a recognition model, and recognizing characters in the character area; and judging whether the category of each field belongs to the name of the bill column or the content of the bill column according to the matching condition of the position coordinates of the frame where each field is positioned and the template, wherein the relative positions of the column contents such as a train ticket, a starting station, a terminal station, a train number, an amount and the like are fixed. Thus, key information of the bill can be obtained, and the key information comprises coordinate values of four corners of a rectangular frame where the contents of each bill column are located.
The character recognition in the image by utilizing the OCR technology is a mature technology in the prior art, can be realized by adopting the prior art, such as some commercial software, and can also be realized by utilizing some commercial interfaces, such as hundred-degree intelligent cloud OCR interfaces, tengxun cloud OCR interfaces and Alicloud OCR services, and the corresponding API interfaces can be selected according to specific conditions and can be called correspondingly according to the types of bill files.
(2) For digital electronic bills with PDF and OFD formats of uploading bill files, the bill information acquisition method comprises the following steps: directly analyzing the bill to obtain bill surface information, wherein the bill surface information comprises bill types, bill column names and bill column contents, and obtaining coordinate values of four corners of an outer frame of the bill and coordinate values of four corners of a rectangular frame where each bill column name and each bill column contents are located through an OCR technology;
For digital electronic bills in PDF and OFD formats, bill information can be analyzed through corresponding analysis software, such as invoice package software provided by financial and tax departments, and can be presented in an image mode, characters can be identified through OCR technology, and the outer frames and the inner frames can be identified through combination of bill analysis and OCR identification, so that bill information can be obtained.
(2) For the digital electronic bill with an XML format uploaded by a bill file, in this case, generally, one bill file corresponds to one bill, and the bill information obtaining method includes: the method comprises the steps of presetting bill templates of various electronic bills, namely only adding value tax special invoices and common invoices, expanding various templates meeting practical requirements according to technical development and actual demands, presetting coordinate values of four corners of an outer frame where the bill templates are located as corresponding set values according to the size of a layout, if the upper left corner is set as a coordinate origin, converting coordinates of the other three corners according to the set resolution of the bill templates, wherein a plurality of corresponding column names and filling frames corresponding to the column names are arranged on the bill templates, and calibrating corresponding coordinate values in advance according to the positions of the four corners of a rectangular frame where the column names and the filling frames are located on the bill templates, wherein the coordinate values are also obtained based on the coordinate origin.
The method comprises the steps of directly analyzing a digital bill in an XML format to obtain bill surface information, wherein the bill surface information comprises bill types, bill column names and bill column contents, selecting corresponding bill templates according to the analyzed bill types, correspondingly filling the corresponding bill column contents into filling frames on the bill templates according to the mapping relation between the bill column names on the bill surface information and the column names on the bill templates to form a simulated bill, storing the simulated bill in a PDF format, and taking the simulated bill as a preview form of the bill, so that the follow-up manual examination is more visual, coordinate values of four corners of an outer frame where the bill templates are located are coordinate values of four corners of the outer frame where the bill is located, the bill column names and the bill column contents are fields on the bill, and coordinate values marked on the bill templates by the four corners of a rectangular frame where the bill names and the filling frames are located are coordinate values of the four corners of the rectangular frame where the corresponding bill column names and the bill column contents are located.
For an electronic bill in an XML format, a corresponding electronic certificate plug-in can be called for analysis, for example, invoice package software provided by a financial tax department is called for analysis, and bill information obtained through analysis comprises information such as an invoice code, a number, an invoicing date, a purchaser, a seller, commodity details, tax and the like.
The frame coordinates of each bill and the coordinate values of four corners of the rectangular frame where the name of each bill column and the content of each bill column are located are required to be acquired, so that corresponding bills can be visually marked for subsequent preview, check and audit, and the audit is convenient.
S3, selecting a preset mapping rule corresponding to the bill type according to the acquired bill type, filling the acquired bill column content into a bill form of the bill of the corresponding type according to the mapping rule, realizing automatic bill filling, wherein one bill form corresponds to one bill, and associating the bill form with a bill file corresponding to the bill; as shown in fig. 2, the bill form further includes an "attachment number" column and a "preview" column, where the "attachment number" column is used to automatically fill in the number when the bill file corresponding to the bill is uploaded, and clicking the number can check the bill file corresponding to the number; the preview column is used for automatically displaying a preview thumbnail of the bill file corresponding to the bill, and for the bill file in the XML format, the thumbnail is a preview thumbnail of the simulated bill in the PDF format in the step S2; when a preview thumbnail is clicked, an enlarged view of the preview thumbnail can be viewed. When there are multiple notes on a note document, the same attachment number and image preview may be displayed on the note form corresponding to the notes, as in fig. 1. The bill form also sets up columns such as invoice numbers, invoice amounts, reimbursement amounts, bill types, associated reimbursement bills, detailed information of bills and the like according to the situation.
S4, checking, modifying and confirming the bill form manually, updating and storing bill information corresponding to the bill form. As shown in fig. 3, the error of the data obtained by recognition can be corrected, and bill information can be updated in time.
S5, when checking the bill (clicking a 'bill checking' button), calling a bill checking interface or automatically logging in the bill checking platform, checking through the existing commercial interface, such as a Baiwang interface, importing key inquiry fields in the latest bill information, initially checking the bill, and displaying inquiry results corresponding to 'inconsistent', 'no bill checked' and 'no check' when the initial inquiry results are inconsistent, no bill checked or no check.
In order to further verify the authenticity and correctness of the bill information, the bill information checking method and device provided by the invention are used for comparing the checked information with the bill information in the bill pool to find out the inconformity and take corresponding measures. Specifically, when the preliminary query result is specific bill detailed information, identifying the bill detailed information to obtain bill query information, comparing the bill query information with the latest bill information one by one, if the bill query information is completely consistent, displaying 'checking passing', and if the bill query information is inconsistent, displaying information of corresponding inconsistent content. The user can know the true or false condition of the bill and the place inconsistent with the original billing record, such as inconsistent information caused by identification or input, can be overcome by manual modification, the modification record is reserved, and manual or related programs are needed in the subsequent auditing link to further audit whether the modified bill information is consistent with the real bill information. The modified ticket information may be further inspected until it is completely consistent, indicating "inspection pass", otherwise the ticket associated reimbursement sheets cannot be submitted.
At present, the bill checking platform is generally a national value-added tax invoice checking platform of the national tax administration, wherein key fields mainly comprise four elements required for checking: the platform or the corresponding checking interface can be used for obtaining whether each bill is consistent with the billing information, whether the bill exists, the relevant state of the bill (whether to void, reimburse, etc.), the specific information of the bill, etc. Different information is displayed according to different ping results. For some non-value-added tickets, such as train tickets, taxi tickets and the like, data cannot be imported for checking, information of 'failure to check' is displayed, related personnel are reminded to focus on checking in a manual checking link, and manual checking can be performed through other checking ways.
S6, each bill recorded according to the steps S1 to S5 becomes a bill in the personal invoice pool, when a reimbursement link is required to be entered, the reimbursement bill is created by importing the corresponding bill in the personal invoice pool through the reimbursement bill creation module, one reimbursement bill at least corresponds to one bill, and the reimbursement amount of the reimbursement bill is automatically generated by the sum of the bill amounts of the bills. The specific operation can be as shown in fig. 4, namely, the bill form corresponding to the bill is directly checked, and the operation can be performed.
When the imported bill has the condition that the bill checking result is that the bill is not checked, inconsistent or corresponding inconsistent content information is displayed, the reimbursement bill cannot be submitted.
After successfully submitting the reimbursement bill, the imported bill automatically enters an enterprise invoice pool, and a bill number of the associated reimbursement bill is imported into the bill form.
S7, the reimbursement sheets are subjected to business audit by related business departments. The business segment is typically the department with which the reimbursement personnel are associated, such as the department leader of the reimbursement personnel.
S8, conducting financial auditing, wherein the financial auditing comprises financial intelligent auditing and financial manual auditing, the financial intelligent auditing comprises conducting ticket checking and re-checking on tickets in the reimbursement ticket before the financial manual auditing, automatically calling a ticket checking and re-checking module, firstly comparing whether the ticket is repeated with the ticket in an enterprise invoice pool, if yes, automatically generating reimbursement comments, displaying repeated information of related tickets in the approval comments, and returning the reimbursement ticket; if not, the automatic login bill checking platform checks whether the bill is a reimbursed bill, if so, automatically generates a return bill approval opinion, displays the reimbursed information of the related bill in the approval opinion, returns the reimbursed bill, and if not, displays no repeated information.
In order to facilitate the ticket examination operation of personnel related to the business part and the financial part, ticket face conditions of related tickets can be visually checked, as shown in fig. 5, a ticket list area and a ticket image display area are arranged on a manual ticket examination interface of business examination and financial manual examination, the ticket list area displays ticket information of each ticket, such as ticket numbers, ticket types, invoice codes, ticket face amounts, billing dates, buyers, sellers, commodity details, tax and the like, and the ticket image display area is used for displaying images of ticket files corresponding to each ticket. The method can be realized by adopting the following steps:
When clicking the bill to be audited in the bill list area, connecting 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 where the corresponding bill is located, which are obtained in the step S2, so as to form a bill rectangular frame for framing the corresponding bill, and selecting the corresponding bill from the bill file image so as to facilitate manual audit; particularly, under the condition that a plurality of notes are arranged on one note file, the corresponding notes can be quickly locked from the notes, and visual inspection is facilitated.
Clicking corresponding bill column contents in the bill information in the bill list area, connecting the four coordinate points on the bill image according to the coordinate values of four corners of the rectangular frame where the corresponding bill column contents are located, forming a rectangular frame of contents for framing the corresponding bill column contents, and selecting the corresponding bill column contents through the frame to facilitate manual checking.
In this embodiment, the financial intelligence audit includes:
Evaluating the priority of the reimbursement sheets according to a preset rule, sorting the reimbursement sheets to be audited according to the priority, and arranging the reimbursement sheets with high priority in front to be processed preferentially; the priority rating rules can be assigned to comprehensively rate according to indexes such as the submitting time, emergency, bill type and the like.
Evaluating the risk value of the reimbursement bill according to a preset rule, if the risk value is smaller than a set value, marking the reimbursement bill as to-be-checked, and directly distributing the reimbursement bill to a financial lead for checking later; if the risk value is larger than the set value, marking the risk value as to be further audited, displaying corresponding risk prompt information, further auditing by financial related personnel, and distributing the risk value to corresponding financial personnel for processing according to the situation.
If the bill checking result in the reimbursement bill is unable to check, the risk value is larger than the set value, the bill is marked as to be checked further, the bill checking information of the corresponding bill is displayed, and the financial staff performs the manual checking or verification of the related bill.
As one of the implementation modes, the bill which cannot be automatically identified or analyzed in the step S2 is defined as a special bill, such as a plurality of unconventional bills (railway tickets, quota invoices and the like), or a bill which cannot be identified due to bill pollution and fold, or a bill which cannot be identified due to unclear bill files, failure of an identification system and the like, wherein the bill file corresponding to the special bill is firstly provided with a rectangular bill frame on an outer frame of the special bill and a rectangular bill frame with contents on corresponding bill column contents, and the bill file is stored and then uploaded through a my invoice pool; in the S3 step, filling in a bill form of the special bill in a manual input mode, and obtaining bill information of the corresponding special bill from the bill form; and S7 and S8, displaying the bill rectangular frame of the special bill and the content rectangular frame on the content of the corresponding bill column in the bill image display area corresponding to the special bill.
The framing operation may be performed using corresponding software, such as picture processing software (drawing, photoshop, etc.), PDF processing software (Adobe Acrobat, etc.).
A bill management auditing system is used for realizing the bill management auditing method, as shown in fig. 6, and comprises a personal invoice pool module, an enterprise invoice pool module, a bill preview display module, a bill checking module, a reimbursement bill creation module, a business auditing module and a financial auditing module.
The personal invoice pool module comprises a bill file uploading unit, a bill identification and analysis unit, a bill form generating unit and a bill form management unit, wherein the bill file uploading unit is used for a user to upload a bill file, and one bill file at least comprises one bill; the bill identification and analysis unit is used for identifying, analyzing or/and processing bills in the imported bill files when the bill files uploaded by the bill file uploading unit are imported into the personal invoice pool, so as to obtain bill information of each bill; the bill form generating unit is used for automatically generating a bill form and associating corresponding bill files according to the bill information obtained by the bill identification and analysis unit, and when the bill cannot be identified, a user generates the bill form and associates corresponding bill files in a manual input mode, and one bill form corresponds to one bill; the bill form management unit is used for manually modifying, sorting and deleting bill forms and updating and storing bill information in real time.
The enterprise invoice pool module is used for receiving the bills imported by the personal invoice pool module, storing the bills in the enterprise invoice pool and providing retrieval service.
The bill preview display module is used for displaying preview thumbnail of the bill files corresponding to each bill in the bill form and displaying an enlarged view when clicking the preview thumbnail; and displaying images of bill files corresponding to the bills on a manual bill examination interface for business examination and financial examination, when clicking the bill to be examined in the bill list area, selecting the corresponding bill from the upper frame of the bill file image, and when clicking the bill column content corresponding to the bill, selecting the corresponding bill column content from the upper frame of the corresponding bill image.
The bill checking module is used for checking the bill, and automatically checking the bill according to the latest bill information of the bill to be checked by calling a bill checking interface or automatically logging in a bill checking platform, and feeding back the information of 'failure to check' when the bill cannot be checked; when the checking result of inconsistent or no ticket is obtained, feeding back information of ' inconsistent ' or no ticket ' to be checked; when specific bill detailed information is obtained, the bill detailed information is analyzed and compared with the latest bill information of the bill one by one, if the bill detailed information is completely consistent, the information of 'checking passing' is fed back, and when the bill detailed information is inconsistent, the information of corresponding inconsistent content is fed back.
The reimbursement bill creation module is used for creating reimbursement bills for users, and the reimbursement bills can be created by leading corresponding bills in the personal invoice pool, and one reimbursement bill corresponds to at least one bill.
The business auditing module is used for auditing the reimbursement sheets by related business departments, generally auditing manually, and setting auditing at different levels according to the actual enterprise.
The financial auditing module is used for auditing the reimbursement bill by a financial department and comprises a financial intelligent auditing module and a financial manual auditing module, the financial intelligent auditing module comprises a bill checking unit, a priority rating unit and a risk value rating unit, the bill checking unit is used for checking whether the bill associated with the reimbursement bill is repeated or not, comparing the bill to be checked with the bill in an enterprise invoice pool, verifying whether the bill is a repeated bill or not, and logging in a bill checking platform to check whether the bill is the reimbursed bill or not; the priority rating unit is used for carrying out priority rating on reimbursement sheets, the risk value rating unit is used for carrying out risk value rating on reimbursement sheets and making corresponding prompts according to the risk value rating condition, for example, prompting that certain notes which cannot be automatically checked need manual checking, certain notes need important attention after being modified for many times, and certain notes need manual checking when being created by notes which cannot be automatically identified.
The foregoing detailed description is directed to embodiments of the invention which are not intended to limit the scope of the invention, but rather to cover all modifications and variations within the scope of the invention.