Electronic invoice data processing method based on data sharing

Abstract

The invention discloses an electronic invoice data processing method based on data sharing, and relates to the technical field of electronic invoice processing, a collection file is established for obtained electronic invoice information, and then each node path of a jump path of each electronic invoice is endowed with a unique identifier by means of an identifier mapping table; each node path is identified by means of a unique identifier, the unique identifiers of the plurality of node paths form a group, the unique identifiers of each group are converted into RGB numerical values, pictures are generated, the pictures are sequentially placed in a collection file according to the sequence of the corresponding unique identifiers, and a skipping dark path is formed; according to the invention, the method can achieve the processing of the skipping path, prevents the information leakage from causing the position of the invoice to be known by a person, and further guarantees the safety of the electronic invoice through refusal of the access of the electronic invoice in a non-skipping path.

Description

Technical Field

[0001] The present invention belongs to the technical field of electronic invoice processing, and in particular to an electronic invoice data processing method based on data sharing. Background Art

[0002] The patent with announcement number CN114936861B announces a financial data sharing method and system based on big data, including the following steps: receiving the financial sharing person account, payment software name, financial voucher category set and financial voucher time period input by the user; opening the corresponding payment software, and retrieving the corresponding payment bill according to the financial voucher time period; classifying the retrieved payment bill according to the financial voucher category set to obtain the first category payment bill and the second category payment bill, and the first category payment bill conforms to the financial voucher category set; receiving the payment bill category exchange instruction, and updating the first category payment bill and the second category payment bill; applying for the electronic voucher of all payment bills in the first category payment bill; receiving the electronic voucher, and sharing the electronic voucher to the financial sharing person account. Without the user preparing various paper bills, various bills that need to be reimbursed during business trips can be automatically shared in batches, which is fast, convenient and reliable.

[0003] However, with regard to electronic invoices, although the method of data sharing has been solved, how to ensure the security of such financial data as electronic invoices; how to ensure that the data is not illegally read when the storage computer is illegally accessed; based on this, a solution is provided. Summary of the invention

[0004] The present invention aims to solve at least one of the technical problems existing in the prior art; To this end, the present invention proposes an electronic invoice data processing method based on data sharing, which specifically includes the following steps: A collection file is created for the acquired electronic invoice information. The collection file includes key information indicating the content of the electronic invoice and a jump path indicating the storage location. The jump path includes several node paths. Each node path is assigned a unique identifier with the help of an identification mapping table. The unique identifier is a three-digit number. Each node path is then identified with the help of a unique identifier. The unique identifiers of several node paths are grouped in three. The unique identifiers of each group are then converted into RGB values ​​to generate images. The images are then placed in the collection archive in the order of the corresponding unique identifiers to form a jump dark path.

[0005] Further, key information includes buyer, seller, item name, transaction value, invoice number and invoice date.

[0006] Furthermore, when generating an image for jumping to a dark path, if three unique identifiers cannot be divided into one group, 000 is used as a value to supplement until a group of RGB values ​​can be filled.

[0007] Furthermore, the archive is collected into an EXCEL table, which integrates the key information of all invoices and the hidden jump path.

[0008] Furthermore, the unique identifier has a value range of 001 to 255.

[0009] Furthermore, when it is necessary to access the electronic invoices in the collection archive, it is necessary to decrypt the dark access path of the electronic invoices in the collection archive through the password peripheral, first convert the image into RGB values ​​and arrange them in sequence, and then find the node path in sequence with the help of the identification mapping table. After the node paths are combined, the jump path is obtained, and the jump path is used to directly jump to the location of the corresponding electronic invoice.

[0010] Furthermore, the password peripheral is a U disk, and the password peripheral stores a decryption program and an identification mapping table; When the electronic invoice at the corresponding location is directly accessed through any non-jump path, an invalid invoice will be automatically selected from the preset storage area of ​​discarded invoices for display.

[0011] Furthermore, when electronic invoices are received and recommended for collection into archives, the electronic invoices for reimbursement will be selected and marked as reimbursement invoices.

[0012] Furthermore, when a number of reimbursement tickets are obtained, the seller in the reimbursement ticket is automatically extracted and marked as the consumer; According to the difference between several transaction values ​​of consumer objects and the mean of all transaction values, the number of transaction values ​​exceeding the mean ±X1 is screened out, and the number is divided by the number of transaction values ​​to obtain the complex external ratio. When the complex external ratio is lower than B1, the corresponding consumer object is marked as a box selection object, and the range from the minimum value to the maximum value of Yi at this time is marked as the box selection amount range; otherwise, no processing is performed; According to the invoice date of the consumer object, several interval frequencies of the consumer object are determined. According to the stable value representing the discrete situation of the data of the interval frequency, the stable value not exceeding the set value X3 is marked as the frame selection object, and the range from the minimum value to the maximum value of the interval frequency at this time is marked as the frame selection interval range; the stable value exceeding X3 is not processed; When selecting objects from consumer objects, the number of consumer objects that appear should exceed the preset value X2 times; Objects that are not filtered as selected objects are still marked as consumption objects.

[0013] Furthermore, when any newly reimbursed electronic invoice of an employee is detected, it is marked as a real-time reimbursement invoice; Get the seller, transaction value, and invoice date in the real-time invoice to be reported, and determine the real-time interval based on the invoice date and the previous invoice date; If there is a selection object that matches it, the selection interval range and selection amount range in the selection object will be obtained and compared with the corresponding real-time interval and transaction value. If the real-time interval and transaction value are not within the corresponding selection interval range and selection amount range, a doubt signal is generated and the corresponding invoice to be reported is marked as a doubtful invoice to be reported; If there is no matching selected object, the real-time invoice to be reported will be automatically compared with all other existing invoices. If one or more electronic invoices are detected that are different from the real-time invoice to be reported in only one item, the electronic invoice will be marked as a questionable invoice to be reported; Obtain all doubtful invoices awaiting reporting, and submit them for manual verification.

[0014] Compared with the prior art, the present invention has the following beneficial effects: The present application establishes a collection file for the acquired electronic invoice information, and then assigns a unique identifier to each node path of the jump path of each electronic invoice with the help of an identification mapping table; then each node path is identified with the help of a unique identifier, and the unique identifiers of several node paths are grouped in three, and then each group of unique identifiers is converted into RGB values ​​to generate an image, and then the images are placed in the collection file in the order of the corresponding unique identifiers to form a jump dark path; the jump path can be processed well to avoid information leakage, which would cause the location of the invoice to be known to others, and at the same time, access to electronic invoices on non-jump paths would be denied, further ensuring its security. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 is a flowchart of a method according to a first embodiment of the present invention; Figure 2 This is a flowchart of the method of Embodiment 2 of the present invention. DETAILED DESCRIPTION

[0016] The technical solution of the present invention will be clearly and completely described below in conjunction with the embodiments. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0017] Please refer to the figure, this application provides an electronic invoice data processing method based on data sharing; As an embodiment 1 of the present application, the method specifically includes the following steps: Step 1: Get the electronic invoice that has been submitted and confirmed or reimbursed by any person, and extract key information from the electronic invoice, including the buyer, seller, project name, transaction value, invoice number, invoice date and other key information in the invoice. The transaction value here refers to the total amount of price and tax. This can be done by extracting keywords through OCR technology. This is an existing technology, so it will not be described in detail. A collection file is created based on the information of the identified electronic invoice, which contains all the key information of the invoice. The corresponding electronic invoice is stored in a random location of a specified partition of a specified smart device, and the storage path of the corresponding invoice is automatically extracted and constructed into a jump path. When this process is implemented, an EXCEL table can be created, which integrates the key information of all invoices. An invoice file is suggested in the form of a table. After marking the serial number, the first line of the header is named in sequence as the buyer, seller, project name, transaction value, invoice number and invoice date, and then the corresponding numbers are automatically filled in below; then a jump path is added after the invoice date column; Semi-hidden encryption is performed on the jump path. The specific process of semi-hidden encryption is as follows: First, the paths of all electronic invoices in the collection archive are obtained, and each node in the path is obtained. After removing duplicates, several node paths are obtained; Then, a unique identifier is given to each node path. The unique identifier is a three-digit value, which is randomly assigned and can be assigned from 001 to 255. Unique identifiers are not equal. An identification mapping table of node paths and unique identifiers is obtained. Then get the number of node paths and divide it by 3. If the number can be integer, assign the unique identifiers corresponding to the node paths to the corresponding RGB values ​​in groups of three in order. Then generate pictures according to the RGB values ​​to obtain several pictures in succession. The number of pictures depends on the quotient obtained by dividing by 3. If it cannot be divided evenly, the number of groups of the unique identifiers of the remaining node paths is grouped into 000, and after filling three groups, a new RGB value is obtained to generate a new image; Obtain the images after all unique identifiers are converted, and place the images in the order of the node paths represented by the unique identifiers to form a jump dark path; Then get the jump dark path and identification mapping table; The specific examples are as follows: For example, when the storage path of any electronic invoice is: C:\Users\Documents\chat_files\id_8388759445322_d49f\ms\file; then corresponding to the 7 existing node paths, the mapping table corresponding to the unique identifier can be constructed as follows:

[0018] When it needs to be converted into RGB values, three pictures can be generated. These three pictures are the jump dark path; the RGB values ​​corresponding to the three pictures are: First picture: 025, 034, 244; Second picture: 133, 147, 003; The third picture: 006, 000, 000; The above is just one example; Step 2: Detect access to electronic invoices; When any employee who has obtained the right to access the invoice wants to access the invoice, a special password peripheral is required, which can be a USB flash drive. The password peripheral stores the decryption program, collection archive and identification mapping table. The decryption program, collection archive and identification mapping table only exist in the password peripheral, or they can also be protected on the blockchain; that is, the corresponding jump dark path can be converted into digital plaintext, the digital plaintext is arranged in order, the digital plaintext of 000 is removed to obtain the remaining digital plaintext, and the node path is restored according to the identification mapping table. Several node paths constitute the jump path; Access the electronic invoice stored in the corresponding location through the jump path; When any electronic invoice at the corresponding location is directly accessed through a non-jump path, an invalid invoice will be automatically selected from the preset storage area of ​​discarded invoices for display; Abandoned invoices are invalid invoices or expired invoices that have been cancelled. The storage location and specific invoices are pre-set by the administrator; As the second embodiment of the present application, this embodiment is implemented on the basis of the first embodiment. The difference from the first embodiment is that when the electronic invoice is received and the collection file is established, the electronic invoice is also classified and collected according to reimbursement and other two methods, that is, the electronic invoices taken by employees for reimbursement are marked as reimbursement tickets, so as to distinguish them from other electronic invoices, and then the reimbursement tickets are error identified. The specific method of error identification is: First, the seller in the electronic invoice is obtained and marked as the consumer. Then, the transaction value and invoice date of each transaction on the invoice of the consumer are obtained. Select any consumption object and obtain the number of times the consumption object appears. When the number exceeds X2, X2 is a preset value, which can generally be 100. Of course, more values ​​can be selected according to actual conditions. If the conditions are met, the following processing is performed: Get the transaction value of each transaction and mark it as Yi, i=1, ..., n; then automatically get the time from the first invoice date to the last invoice date according to the invoice date, mark it as the interval frequency, and mark it as Gj, j=1, ..., m, where m=n-1; Then get the mean value P of Yi, set the checkbox, checkbox = P ± X1, X1 is the preset value, so as to get the range of the checkbox, and then get the number of Yi that is not in the checkbox, divide the number by n, and the obtained value is marked as the complex external ratio; When the external-complex ratio is lower than B1, the corresponding consumer object is marked as a box-selected object, and the rest are still marked as consumer objects; the range from the minimum value to the maximum value of Yi at this time is marked as the box-selected amount range; Then, the interval frequency Gj is obtained, and the mean value at maturity is also obtained, which is marked as R. The stable value W of Gj is calculated using the formula. The specific calculation formula is: ; Then compare W with the preset number X3. If W does not exceed X3, it is also marked as a box selection object, and the range from the minimum value to the maximum value of Gj at this time is marked as the box selection interval range. Otherwise, it is still marked as a consumption object. Get the selection interval range and selection amount range of all selected objects; When any newly reimbursed electronic invoices from employees are detected, they will be marked as real-time reimbursement invoices; Get the seller, transaction value, and invoice date in the real-time invoice to be reported, and determine the real-time interval based on the invoice date and the previous invoice date; If there is a selection object that matches it, the selection interval range and selection amount range in the selection object will be obtained and compared with the corresponding real-time interval and transaction value. If the real-time interval and transaction value are not within the corresponding selection interval range and selection amount range, a doubt signal is generated and the corresponding invoice to be reported is marked as a doubtful invoice to be reported; If there is no matching selected object, the real-time invoice to be reported will be automatically compared with all other existing invoices. If one or more electronic invoices are detected that are different from the real-time invoice to be reported in only one item, the electronic invoice will be marked as a questionable invoice to be reported; Obtain all invoices that are in doubt and waiting to be reported; The invoices in doubt will be submitted for manual verification.

[0019] The above embodiments are only used to illustrate the technical method of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical method of the present invention may be modified or replaced by equivalents without departing from the spirit and scope of the technical method of the present invention.

Claims

1. The electronic invoice data processing method based on data sharing is characterized by: The method specifically comprises the following steps: A collection file is created for the acquired electronic invoice information. The collection file includes key information indicating the content of the electronic invoice and a jump path indicating the storage location. The jump path includes a number of node paths. Each node path is assigned a unique identifier with the help of an identification mapping table. The unique identifier is a three-digit number. Each node path is then identified with the help of a unique identifier. The unique identifiers of several node paths are grouped in three. The unique identifiers of each group are then converted into RGB values ​​to generate images. The images are then placed in the collection archive in the order of the corresponding unique identifiers to form a jump dark path.

2. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: Key information includes buyer, seller, item name, transaction value, invoice number and invoice date.

3. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: When generating an image for jumping to the dark path, if three unique identifiers cannot be divided into a group, 000 is used as a value to supplement until a group of RGB values ​​can be filled.

4. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: The collection file is an EXCEL table, which integrates the key information of all invoices and the hidden jump path.

5. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: The unique identifier value ranges from 001 to 255.

6. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: When it is necessary to access the electronic invoices in the collection archive, it is necessary to decrypt the dark access path of the electronic invoices in the collection archive through the password peripheral, first convert the image into RGB values ​​and arrange them in sequence, and then find the node path in sequence with the help of the identification mapping table. After combining the node paths, the jump path is obtained, and the jump path is used to directly jump to the location of the corresponding electronic invoice.

7. The electronic invoice data processing method based on data sharing according to claim 6 is characterized in that: The password peripheral is a U disk, and the password peripheral stores a decryption program and an identification mapping table; When the electronic invoice at the corresponding location is directly accessed through any non-jump path, an invalid invoice will be automatically selected from the preset storage area of ​​discarded invoices for display.

8. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: When we receive electronic invoices that are recommended for collection, we will select the electronic invoices for reimbursement and mark them as reimbursement invoices.

9. The electronic invoice data processing method based on data sharing according to claim 8 is characterized in that: When a number of reimbursement invoices are obtained, the seller in the reimbursement invoice will be automatically extracted and marked as the consumer; According to the difference between several transaction values ​​of consumer objects and the mean of all transaction values, the number of transaction values ​​exceeding the mean ±X1 is screened out, and the number is divided by the number of transaction values ​​to obtain the complex external ratio. When the complex external ratio is lower than B1, the corresponding consumer object is marked as a box selection object, and the range from the minimum value to the maximum value of Yi at this time is marked as the box selection amount range; otherwise, no processing is performed; According to the invoice date of the consumer object, several interval frequencies of the consumer object are determined. According to the stable value representing the discrete situation of the data of the interval frequency, the stable value not exceeding the set value X3 is marked as the frame selection object, and the range from the minimum value to the maximum value of the interval frequency at this time is marked as the frame selection interval range; the stable value exceeding X3 is not processed; When selecting objects from consumer objects, the number of consumer objects that appear should exceed the preset value X2 times; Objects that are not filtered as selected objects are still marked as consumption objects.

10. The electronic invoice data processing method based on data sharing according to claim 1 is characterized in that: When any newly reimbursed electronic invoices from employees are detected, they will be marked as real-time reimbursement invoices; Get the seller, transaction value, and invoice date in the real-time invoice to be reported, and determine the real-time interval based on the invoice date and the previous invoice date; If there is a selection object that matches it, the selection interval range and selection amount range in the selection object will be obtained and compared with the corresponding real-time interval and transaction value. If the real-time interval and transaction value are not within the corresponding selection interval range and selection amount range, a doubt signal is generated and the corresponding invoice to be reported is marked as a doubtful invoice to be reported; If there is no matching selected object, the real-time invoice to be reported will be automatically compared with all other existing invoices. If one or more electronic invoices are detected that are different from the real-time invoice to be reported in only one item, the electronic invoice will be marked as a questionable invoice to be reported; Obtain all doubtful invoices awaiting reporting, and submit them for manual verification.

Images