Electronic Invoice Data Processing Method Based on Data Sharing

Abstract

The present invention discloses an electronic invoice data processing method based on data sharing, which relates to the technical field of electronic invoice processing. By establishing a collection file for the obtained electronic invoice information, each node path of the jump path of each electronic invoice is given a unique identifier with the aid of an identification mapping table; then each node path is identified by the unique identifier, and the unique identifiers of several node paths are grouped in threes, and then the unique identifiers of each group are respectively converted into RGB values to generate a picture, and then the pictures are placed in the collection file in the order of the corresponding unique identifiers in sequence to form a jump dark path; it can well process the jump path, avoid information leakage and prevent the invoice position from being known, and at the same time, the access to electronic invoices of non-jump paths will be refused, further ensuring its security.

Description

Technical Field

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

[0002] A patent with the publication number CN114936861B discloses a financial data sharing method and system based on big data, which includes the following steps: receiving the financial sharer account number, payment software name, set of financial voucher categories, and financial voucher time period input by the user; opening the corresponding payment software, and retrieving the corresponding payment bills according to the financial voucher time period; classifying the retrieved payment bills according to the set of financial voucher categories to obtain the first type of payment bills and the second type of payment bills, where the first type of payment bills conform to the set of financial voucher categories; receiving a payment bill category swapping instruction, and updating the first type of payment bills and the second type of payment bills; applying for electronic vouchers for all payment bills in the first type of payment bills; receiving the electronic vouchers, and sharing the electronic vouchers to the financial sharer account number. Without the user having to prepare various paper bills, it is possible to automatically batch share various bills that need to be reimbursed during a business trip, which is fast, convenient, and reliable.

[0003] However, for electronic invoices, although a method for data sharing has been solved, for this type of financial data of electronic invoices, how to ensure its security, and 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;

[0005] For this reason, the present invention proposes an electronic invoice data processing method based on data sharing, which specifically includes the following steps:

[0006] Establish an aggregation file for the obtained electronic invoice information. The aggregation file includes key information representing the content of the electronic invoice and a jump path representing the storage location. The jump path contains several node paths;

[0007] Assign a unique identifier to each node path by means of an identification mapping table. The unique identifier is a three-digit number; then each node path is identified by the unique identifier. The unique identifiers of several node paths are grouped in threes, and then the unique identifiers of each group are respectively converted into RGB values to generate a picture, and then the pictures are arranged in sequence in the aggregation file according to the order of the corresponding unique identifiers to form a jump dark path.

[0008] Further, the key information includes the purchaser, seller, project name, transaction value, invoice number, and invoice date.

[0009] Further, when generating the picture of the jump dark path, if three unique identifiers cannot be divided into a group, 000 is used as a numerical value for supplementation until a group of RGB numerical values is filled up.

[0010] Further, the archived files are aggregated into an EXCEL table, and the key information of all invoices and the jump dark path are integrated in the table.

[0011] Further, the value range of the unique identifier is from 001 to 255.

[0012] Further, when it is necessary to access the electronic invoice in the aggregated file, it is necessary to decrypt the access dark path of the electronic invoice in the aggregated file through a password peripheral device. First, convert the picture into RGB numerical values and arrange them in order, and then find the node path with the help of the identification mapping table in order. After the node paths are combined, the jump path is obtained, and the corresponding position of the electronic invoice can be directly jumped to through the jump path.

[0013] Further, the password peripheral device is a USB flash drive, and a decryption program and an identification mapping table are stored in the password peripheral device;

[0014] When directly accessing the electronic invoice at the corresponding position by any means other than the jump path, an invalid invoice will be automatically selected from the preset storage area of the discarded invoice for display.

[0015] Further, when receiving the electronic invoice proposed to be aggregated into the file, the electronic invoices for reimbursement will be selected and marked as reimbursement invoices.

[0016] Further, when obtaining several reimbursement invoices, the seller in the reimbursement invoices will be automatically extracted and marked as the consumption object;

[0017] According to the difference between the several transaction values of the consumption object and the average value of all transaction values, the number of transaction values exceeding the average value ±X1 is screened out. Divide this number by the number of transaction values to obtain the complex external ratio. When the complex external ratio is lower than B1, the corresponding consumption object is marked as the framed object at this time, and the range from the minimum value to the maximum value of Yi at this time is marked as the framed amount range; otherwise, no processing is performed;

[0018] According to the invoice date of the consumption object, several interval frequencies of the consumption object are determined. According to the stability value representing the data dispersion situation of the interval frequency, those with a stability value not exceeding the set value X3 are marked as the framed objects, and the range from the minimum value to the maximum value of this interval frequency is marked as the framed interval range; those with a stability value exceeding X3 are not processed;

[0019] When screening the framed objects from the consumption objects, the number of occurrences of the consumption object should exceed the preset value X2 times;

[0020] Those not screened as framed objects are still marked as consumption objects.

[0021] Further, when any newly added electronic invoice of an employee is detected, it is marked as a real-time invoice to be reported.

[0022] Obtain 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.

[0023] If there is a checked object that is consistent with it, the checked interval range and checked amount range in the checked 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 checked interval range and checked amount range, a suspicious signal will be generated, and the corresponding real-time invoice to be reported will be marked as a suspicious invoice to be reported.

[0024] If there is no checked object that is consistent with it, the real-time invoice to be reported will be automatically compared with each item of all the existing invoices. If it is detected that there is more than one electronic invoice that is only different from the real-time invoice to be reported by one item, the electronic invoice will be marked as a suspicious invoice to be reported.

[0025] Obtain all the suspicious invoices to be reported, and report the suspicious invoices to be reported to the manual for verification.

[0026] Compared with the prior art, the beneficial effects of the present invention are:

[0027] In this application, an aggregation file is established for the obtained electronic invoice information, and then each node path of the jump path of each electronic invoice is assigned a unique identifier by means of an identification mapping table; then each node path is identified by the unique identifier, and the unique identifiers of several node paths are grouped in threes, and then the unique identifier of each group is respectively converted into an RGB value to generate a picture, and then the pictures are placed in the aggregation file in the order of the corresponding unique identifiers to form a jump dark path; it can handle the jump path well, avoid information leakage, so that the invoice position is known to others, and at the same time, the access to the electronic invoice of the non-jump path will be refused, further ensuring its security. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] Figure 1 It is a flowchart of the method of Embodiment 1 of the present invention;

[0029] Figure 2 It is a flowchart of the method of Embodiment 2 of the present invention. DETAILED DESCRIPTION OF THE INVENTION

[0030] 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 a part of the embodiments of the present invention, rather than all the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0031] Please refer to the figure. The present application provides an electronic invoice data processing method based on data sharing;

[0032] As the first embodiment of the present application, the method specifically includes the following steps:

[0033] Step 1: Obtain the electronic invoices that have been submitted and confirmed or reimbursed by any person, and extract the key information from the electronic invoices. The key information includes the key information in the invoice such as the purchaser, seller, project name, transaction value, invoice number, and invoice date. Here, the transaction value refers to the total amount of tax and price; specifically, the keywords can be extracted through OCR technology. This is the prior art, so no specific description will be given;

[0034] Establish an aggregation file according to the information of the identified electronic invoices. The aggregation file contains all the key information of the invoices. At the same time, the corresponding electronic invoices will be stored in a random position in the specified partition of the specified intelligent device, and the storage path of the corresponding invoice will be automatically extracted, and this path will be extracted and constructed into a jump path;

[0035] When this process is specifically implemented, an EXCEL table can be established. All the key information of the invoices is integrated in this table. An invoice file is established in the form of a table. After numbering, the first row header is named purchaser, seller, project name, transaction value, invoice number, and invoice date in sequence, and then the corresponding numbers are automatically filled in below; then a jump path is appended after the invoice date column;

[0036] Perform semi-hidden encryption on the jump path. The specific process of semi-hidden encryption is as follows:

[0037] First, obtain the paths of all the electronic invoices in the aggregation file, obtain each node in the path, and after removing duplicates, obtain several node paths;

[0038] Then, assign a unique identifier to each node path. The unique identifier is a three-digit numerical value, which is randomly assigned and can be assigned from 001 to 255. The unique identifiers are not equal to each other; an identification mapping table of the node path and the unique identifier is obtained;

[0039] Then obtain the number of node paths, divide it by 3. If it can be divided evenly, then sequentially group the unique identifiers corresponding to the node paths in groups of three and assign them to the corresponding RGB values. Then generate images according to the RGB values, and continuously obtain several images. The number of images depends on the quotient obtained by dividing by 3;

[0040] If it cannot be divided evenly, then group the remaining unique identifiers of the node paths in groups of 000. After filling three groups, a new RGB value is obtained, and a new image is generated;

[0041] Obtain the images after all unique identifiers are converted, and arrange the images in sequence according to the order of the node paths represented by the unique identifiers to form a jump dark path;

[0042] Then obtain the jump dark path and the identification mapping table;

[0043] Specific examples are as follows: For example, when the storage path of any electronic invoice is:

[0044] C:\Users\Documents\chat_files\id_8388759445322_d49f\ms\file; then for the corresponding 7 node paths, the construction of the mapping table assigned to the unique identifiers can be as follows:

[0045]

[0046] When it needs to be converted into RGB values, three images can be generated, and these three images are the jump dark path; the RGB values corresponding to the three images are as follows:

[0047] The first image: 025, 034, 244;

[0048] The second image: 133, 147, 003;

[0049] The third image: 006, 000, 000;

[0050] The above is only one example;

[0051] Step 2: Detect the access to the electronic invoice;

[0052] When an employee who has randomly obtained the access permission to the invoice accesses the invoice, a dedicated password peripheral is required, which can be a USB flash drive. The password peripheral stores a decryption program, a collection file, and an identification mapping table. The decryption program, the collection file, and the identification mapping table only exist in the password peripheral, or they can also be protected by uploading to the blockchain; that is, it can convert the corresponding jump dark path into digital plaintext, arrange the digital plaintext in order, remove the digital plaintext with 000, and then restore the node path according to the identification mapping table. Several node paths form a jump path;

[0053] Access the electronic invoice stored at the corresponding location through the jump path;

[0054] When any electronic invoice at the corresponding location is directly accessed by a non-jump path method, an invalid invoice will be automatically selected from the pre-set storage area of the discarded invoices for display;

[0055] The discarded invoice is an invalid invoice or an expired and already red-inked invoice. The storage location and the specific invoice are preset by the administrator;

[0056] As another embodiment of the present application, this embodiment is implemented on the basis of Embodiment 1. The difference from Embodiment 1 is that when receiving the electronic invoice and establishing the collection file, the electronic invoice will also be classified and collected in two ways: reimbursement and others. That is, the electronic invoice brought by the employee for reimbursement is marked as a reimbursement invoice for easy distinction from other electronic invoices, and then error identification is performed on the reimbursement invoice. The specific method of error identification is as follows:

[0057] First, the seller in the electronic invoice is obtained and marked as the consumption object, and then the transaction value and invoice date on the invoice of the consumption object are obtained;

[0058] Select any consumption object, and obtain the number of times the consumption object appears. When the number of times exceeds X2, X2 is a preset value, and the general value can be one hundred. Of course, more values can be selected according to the actual situation. When the conditions are met, the following processing is performed:

[0059] Obtain its transaction value each time and mark it as Yi, i = 1,..., n; then, according to the invoice date, automatically obtain the duration from the first time to the duration between each invoice date and the previous invoice date, and mark it as the interval frequency and mark it as Gj, j = 1,..., m, where m = n - 1;

[0060] Then obtain the mean value P of Yi, set a checkbox, checkbox = P ± X1, X1 is a preset value, so as to obtain the range of the checkbox, and then obtain the number of Yi that are not within the checkbox, divide the number by n, and mark the obtained value as the ratio outside the checkbox;

[0061] When the compound external ratio is lower than B1, mark the corresponding consumption object as the selected object, and the rest are still marked as consumption objects; mark the range from the minimum value to the maximum value of Yi at this time as the selected amount range;

[0062] Then obtain the interval frequency Gj, and also obtain the period average value, mark it as R, and calculate the stable value W of Gj using the formula. The specific calculation formula is:

[0063] ;

[0064] Then compare W with the preset number X3. If W does not exceed X3, also mark it as the selected object, and mark the range from the minimum value to the maximum value of Gj at this time as the selected interval range, otherwise it is still marked as a consumption object;

[0065] Obtain the selected interval range and selected amount range of all selected objects;

[0066] When any newly added electronic invoice for employee reimbursement is detected, mark it as a real-time pending reimbursement invoice;

[0067] Obtain the seller, transaction value, and invoice date in the real-time pending reimbursement invoice, and determine the real-time interval based on the invoice date and the previous invoice date;

[0068] If there is a consistent selected object, obtain the selected interval range and selected amount range in the selected object, and compare them with the corresponding real-time interval and transaction value. If the real-time interval and transaction value are not within the corresponding selected interval range and selected amount range, generate a suspicious signal, and mark the corresponding real-time pending reimbursement invoice as a suspicious pending reimbursement invoice;

[0069] If there is no consistent selected object, automatically compare this real-time pending reimbursement invoice with each of the remaining existing invoices one by one. If any one or more electronic invoices that are only different from this real-time pending reimbursement invoice by one item are detected, mark this electronic invoice as a suspicious pending reimbursement invoice;

[0070] Obtain all suspicious pending reimbursement invoices;

[0071] Report the suspicious pending reimbursement invoices to the manual for verification.

[0072] 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 of ordinary skill in the art should understand that the technical method of the present invention can be modified or equivalently replaced 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 ​​Yi of consumer objects and the mean of all transaction values, the number of transaction values ​​whose absolute value of the difference exceeds the preset value 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 9 is characterized in that: When any new electronic invoice for reimbursement by an employee is detected, it will be marked as a real-time invoice to be reported; 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 real-time 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