Associated transaction automatic settlement method and system based on data and electricity invoices

Abstract

The invention belongs to the field of computers, and particularly discloses an associated transaction automatic settlement method and system based on a digital-to-electronic invoice, and the method comprises the steps: obtaining a digital-to-electronic invoice issued by a seller and a purchase receiving transaction provided by a purchaser; in combination with the tax-free unit price, the quantity and the preset tax-free unit price allowance, matching the invoice detail line with the purchase receiving transaction; when the invoice detail lines are all matched with the receiving transaction lines; summarizing the non-tax-containing amount and the tax amount in the matching information to obtain a summarized non-tax-containing amount, a summarized tax amount and a summarized tax-containing amount; when the difference value between the summarized tax-contained amount and the total tax-contained amount of the digital electronic invoice is not greater than the preset allowance of the total tax-contained amount, adjusting the non-tax-contained amount and / or tax amount of at least one receiving transaction line in the matching information until the non-tax-contained amount, the tax amount and the total tax-contained amount are respectively equal through comparison; and creating the payable invoice according to the adjusted information. According to the invention, efficient and accurate automatic invoice bookkeeping and payment are realized.

Description

Technical Field

[0001] The present application belongs to the field of computers, and more specifically, to a method and system for automated settlement of related transactions based on digital electronic invoices. Background Art

[0002] In the traditional settlement process, financial and business personnel are usually required to manually process and input a large number of tax invoices and settlement documents, which is not only time-consuming and labor-intensive, but also prone to errors. With the expansion of corporate transaction scale and the increase in business volume, this manual processing method can no longer meet the growing business needs of enterprises. Therefore, enterprises urgently need a method that can automatically process invoices and settlement documents to improve settlement efficiency and accuracy.

[0003] With the continuous development of new technologies such as optical character recognition (OCR), natural language processing, and machine learning algorithms, the technical conditions for achieving settlement automation have been met. These technologies can support enterprises to automatically process, analyze, and archive invoices and settlement documents, thereby automating the settlement process. At the same time, the State Taxation Department is also vigorously promoting the promotion and application of digital invoices, and providing corresponding technical support and services, providing a strong guarantee for enterprises to achieve settlement automation.

[0004] The current invoice automation processing and settlement can only perform some simple invoice automation processing, and cannot cope with some complex situations. It has limited functions and cannot cope with the difference in unit price when the unit price precision of the two parties to the transaction is different, and cannot handle the slight difference between the amount on the invoice and the actual transaction amount due to rounding or calculation accuracy. These situations still require manual intervention, resulting in poor flexibility of the automated settlement platform. Therefore, there is an urgent need to provide an invoice automation processing and settlement platform with more comprehensive functions and higher practicality. Summary of the invention

[0005] In view of the defects of the prior art, the purpose of this application is to provide a method and system for automated settlement of related transactions based on digital electronic invoices, aiming to solve the problem that the existing automated invoice processing and settlement platform is unable to cope with complex situations and has poor flexibility.

[0006] To achieve the above objectives, in a first aspect, the present application provides a method for automated settlement of related transactions based on digital invoices, comprising:

[0007] Obtaining a digital electricity invoice issued by a seller and a purchase receiving transaction provided by a purchaser; the digital electricity invoice includes at least one invoice detail line, a total amount excluding tax, a total tax amount, and a total amount including tax; the purchase receiving transaction includes at least one receiving transaction line, and each invoice detail line and each receiving transaction line include: quantity, unit price excluding tax, amount excluding tax, and tax amount;

[0008] In combination with the tax-exclusive unit price, quantity, and preset tax-exclusive unit price tolerance, each invoice detail line is matched with a purchase receiving transaction; when each invoice detail line is matched to one or more corresponding receiving transaction lines, corresponding matching information is obtained; and the tax-exclusive amounts and tax amounts of all receiving transaction lines in the matching information are respectively summarized to obtain a summarized tax-exclusive amount, a summarized tax amount, and a summarized tax-inclusive amount;

[0009] When at least one of the summarized tax-exclusive amount, the summarized tax amount and the summarized tax-inclusive amount is not equal to the total tax-exclusive amount, the total tax amount and the total tax-inclusive amount of the digital invoice, and the difference between the summarized tax-inclusive amount and the total tax-inclusive amount of the digital invoice is not greater than the preset total tax-inclusive amount tail difference tolerance, adjust the tax-exclusive amount and / or tax amount of at least one receiving transaction line in the matching information until the three are respectively equal;

[0010] An A / P invoice document is created based on the adjusted matching information to settle the digital invoice.

[0011] It can be understood that this application maximizes the matching degree between the invoice detail line and the receiving transaction line within the unit price tolerance range by pre-setting the unit price tolerance and the total amount difference, and automatically eliminates the tax-exclusive amount and the tax amount difference summarized in the payable invoice settlement document, thereby ensuring the consistency of business data and financial data and improving the flexibility and practicality of the digital invoice automation settlement platform.

[0012] In a possible implementation, the preset tax-exclusive unit price tolerance includes: the tax-exclusive unit price tolerance of each invoice detail line; wherein the tax-exclusive unit price tolerance of each invoice detail line is the same, the tax-exclusive unit price tolerance of some invoice detail lines is the same, or the tax-exclusive unit price tolerance of each invoice detail line is different;

[0013] and / or in combination with preset tax-exclusive unit price tolerances, matching each invoice detail line to the purchase receipt transaction, including:

[0014] The matching includes exact matching and fuzzy matching; the exact matching has a higher priority than the fuzzy matching;

[0015] The exact matching is as follows: firstly, matching is performed based on the tax-exclusive unit price of the receiving transaction line being the same as the tax-exclusive unit price of each invoice detail line, filtering out the receiving transaction lines whose tax-exclusive unit price is exactly matched, and then matching is performed based on quantity;

[0016] The fuzzy matching is: firstly matching based on the difference between the tax-exclusive unit price of the receiving transaction line and the tax-exclusive unit price of each invoice detail line is not greater than the corresponding tax-exclusive unit price tolerance, screening out the receiving transaction lines with fuzzy matching of the tax-exclusive unit price, and then matching based on quantity; and / or

[0017] The criteria for matching by quantity include at least one of the following criteria: the quantity of an invoice detail line is consistent with the quantity of a received transaction line, the quantity of an invoice detail line is consistent with the sum of the quantities of multiple received transaction lines, the quantity of an invoice detail line is consistent with the partial quantity of a received transaction line, and the quantity of an invoice detail line is consistent with the sum of the partial quantities of multiple received transaction lines.

[0018] In a possible implementation, each received transaction line further includes: a remaining invoicable quantity; the remaining invoicable quantity refers to a quantity in the received transaction line that has not been invoiced;

[0019] If the quantity of an invoice detail line is consistent with the quantity of a receiving transaction line, or the quantity of an invoice detail line is consistent with the sum of the quantities of multiple receiving transaction lines, the corresponding one or more receiving transaction lines will be used as the receiving transaction lines that match the invoice detail line, and the information of the matching receiving transaction lines will be copied to the matching information, and the remaining invoicable quantity of the corresponding one or more receiving transaction lines will be updated to 0;

[0020] If the quantity of an invoice detail line is consistent with the partial quantity of a receiving transaction line or the sum of the partial quantities of multiple receiving transaction lines, the corresponding one or more receiving transaction lines will be used as the receiving transaction lines that match the invoice detail line, and the information of the matched receiving transaction lines will be copied to the matching information, and in the matching information, the quantity or the sum of the quantities of the one or more receiving transaction lines will be set to be consistent with the quantity of the invoice detail line, and the quantity of the invoice detail line will be subtracted from the remaining invoicable quantity of the corresponding one or more receiving transaction lines.

[0021] In a possible implementation, the matching according to quantity includes:

[0022] Select a receiving transaction line whose quantity is consistent with the quantity of the invoice detail line from all the filtered receiving transaction lines as the receiving transaction line that matches the invoice detail line, copy the information of the matching receiving transaction line to the matching information, and set the remaining invoicable quantity of the matching receiving transaction line to 0;

[0023] If the quantity of each of the filtered receiving transaction lines is inconsistent with the quantity of the invoice detail line, multiple receiving transaction lines whose total quantity is equal to the quantity of the invoice detail line are selected from them, and the selected multiple receiving transaction lines are used as the receiving transaction lines that match the invoice detail line, and the information of the matched receiving transaction lines is copied to the matching information, and the remaining invoicable quantities of the matched multiple receiving transaction lines are all set to 0;

[0024] If the quantity of each of the filtered receiving transaction lines is inconsistent with the quantity of the invoice detail line, a receiving transaction line with a quantity greater than the quantity of the invoice detail line is selected as the receiving transaction line that matches the invoice detail line, and the information of the matched receiving transaction line is copied to the matching information, and the quantity of the receiving transaction line is set to be consistent with the quantity of the invoice detail line in the matching information, and the quantity of the invoice detail line is subtracted from the remaining invoicable quantity of the receiving transaction line; or

[0025] If the quantity of all the received transaction lines in all the screened received transaction lines is inconsistent with the quantity of the invoice detail line, then multiple received transaction lines whose total quantity is greater than the quantity of the invoice detail line are selected according to the preset rule, and the selected multiple received transaction lines are used as the received transaction lines that match the invoice detail line, and the information of the matched multiple received transaction lines is copied to the matching information; the quantities of the multiple received transaction lines are set respectively in the matching information according to the preset rule, so that the sum of the set quantities is consistent with the quantity of the invoice detail line, and the quantities set in the corresponding matching information are subtracted from the remaining invoiceable quantities of the multiple received transaction lines; wherein the preset rule is to select multiple received transaction lines whose corresponding total quantity matches in the order of the number of received transaction lines from large to small, the number from small to large, the difference in quantity relative to the number of invoice detail lines to be matched from small to large, the difference in quantity relative to the number of invoice detail lines to be matched from large to small, or the number is random, and the quantities are set respectively in the matching information.

[0026] In a possible implementation, adjusting the tax-exclusive amount and / or tax amount of the receiving transaction line includes:

[0027] Arbitrarily select one or more receiving transaction lines from the matching information to adjust their tax-exclusive amount and / or tax amount; or select at least one receiving transaction line at at least one preset position from the matching information to adjust its tax-exclusive amount and / or tax amount.

[0028] In a possible implementation, adjusting the tax-exclusive amount and / or tax amount of the receiving transaction line includes:

[0029] When the difference between the aggregated amount including tax and the total amount including tax of the digital electronic invoice is not equal to 0, and the difference is not greater than the preset tolerance for the tail difference of the total amount including tax, or when the difference between the aggregated amount including tax and the total amount including tax of the digital electronic invoice is equal to 0, but the difference between the aggregated tax amount and the total tax amount of the digital electronic invoice is not equal to 0, adjust the amount excluding tax and / or the tax amount of at least one receiving transaction line selected from the matching information so that the adjusted aggregated amount excluding tax, aggregated tax amount, aggregated amount including tax are respectively the same as the total amount excluding tax, total tax amount, and total amount including tax of the digital electronic invoice.

[0030] In a possible implementation, obtaining the digital electricity invoice issued by the seller of the related transaction and the purchase receipt transaction provided by the purchaser includes:

[0031] Determine the purchase order of the associated transaction based on the sales order number and / or supplier name information carried by the digital invoice; the purchase order is provided by the purchaser;

[0032] The purchase receiving transaction is determined from the purchase order; the purchase receiving transaction is the details of the goods shipped by the seller and the purchaser has confirmed receipt of the goods.

[0033] In the second aspect, the present application provides an automated settlement system for related transactions based on digital invoices, including:

[0034] A digital electricity invoice acquisition unit is used to acquire a digital electricity invoice issued by a seller and a purchase receiving transaction provided by a purchaser; the digital electricity invoice includes at least one invoice detail line, a total amount excluding tax, a total tax amount, and a total amount including tax; the purchase receiving transaction includes at least one receiving transaction line, and each invoice detail line and each receiving transaction line include: quantity, unit price excluding tax, amount excluding tax, and tax amount;

[0035] an invoice detail matching unit, for matching each invoice detail line with a purchase receiving transaction in combination with the tax-exclusive unit price, quantity, and a preset tax-exclusive unit price tolerance; when each invoice detail line is matched to one or more corresponding receiving transaction lines, obtaining corresponding matching information; and summarizing the tax-exclusive amounts and tax amounts of all receiving transaction lines in the matching information to obtain a summed tax-exclusive amount, a summed tax amount, and a summed tax-inclusive amount;

[0036] A matching amount tail difference elimination unit is used to adjust the tax-exclusive amount and / or tax amount of at least one receiving transaction line in the matching information until the three are respectively equal when the summarized tax-exclusive amount, the summarized tax amount and the summarized tax-inclusive amount are not equal to the total tax-exclusive amount, the total tax amount and the total tax-inclusive amount of the digital invoice, and the difference between the summarized tax-inclusive amount and the total tax-inclusive amount of the digital invoice is not greater than a preset total tax-inclusive amount tail difference tolerance;

[0037] The payable invoice document creation unit is used to create a payable invoice document according to the adjusted matching information so as to settle the digital invoice.

[0038] In a possible implementation, the preset tax-exclusive unit price tolerance includes: the tax-exclusive unit price tolerance of each invoice detail line; wherein the tax-exclusive unit price tolerance of each invoice detail line is the same, the tax-exclusive unit price tolerance of some invoice detail lines is the same, or the tax-exclusive unit price tolerance of each invoice detail line is different;

[0039] And / or the invoice detail matching unit, the matching methods used to match each invoice detail line with the purchase receiving transaction include: exact matching and fuzzy matching; the exact matching has a higher priority than fuzzy matching; the exact matching is: first matching according to the tax-exclusive unit price of the receiving transaction line is the same as the tax-exclusive unit price of each invoice detail line, screening out the receiving transaction lines with exact matching tax-exclusive unit price, and then matching according to quantity; the fuzzy matching is: first matching according to the tax-exclusive unit price of the receiving transaction line and the tax-exclusive unit price of each invoice detail line The difference is not greater than the corresponding tax-exclusive unit price tolerance, screening out the receiving transaction lines with fuzzy matching tax-exclusive unit price, and then matching according to quantity; and / or the standard for matching according to quantity includes at least one of the following standards: the quantity of an invoice detail line is consistent with the quantity of a receiving transaction line, the quantity of an invoice detail line is consistent with the sum of the quantities of multiple receiving transaction lines, the quantity of an invoice detail line is consistent with the partial quantity of a receiving transaction line, and the quantity of an invoice detail line is consistent with the sum of the partial quantities of multiple receiving transaction lines.

[0040] In a third aspect, the present application provides an electronic device comprising: at least one memory for storing programs; and at least one processor for executing the programs stored in the memory. When the program stored in the memory is executed, the processor is used to execute the method described in the first aspect or any possible implementation of the first aspect.

[0041] In a fourth aspect, the present application provides a computer-readable storage medium, which stores a computer program. When the computer program runs on a processor, the processor executes the method described in the first aspect or any possible implementation of the first aspect.

[0042] In a fifth aspect, the present application provides a computer program product. When the computer program product runs on a processor, the processor executes the method described in the first aspect or any possible implementation of the first aspect.

[0043] It can be understood that the beneficial effects of the second to fifth aspects mentioned above can be found in the relevant description of the first aspect mentioned above, and will not be repeated here.

[0044] In general, the above technical solutions conceived by this application have the following beneficial effects compared with the prior art:

[0045] The present application provides a method and system for automated settlement of related transactions based on digital electronic invoices. By setting the unit price tolerance excluding tax and the tail difference of the total amount including tax, the application fully considers the slight differences in the unit price accuracy of the seller and the buyer, as well as the slight difference between the amount on the invoice and the actual transaction amount due to rounding or calculation accuracy during the invoice issuance process. By considering the unit price tolerance, automatically judging and processing the tail difference, the matching degree between the invoice detail line and the receiving transaction line is maximized within the unit price tolerance range, and the tax-excluding amount and the tax amount tail difference summarized in the invoice payable settlement document are automatically eliminated to ensure that the amount of the invoice payable document is consistent with the tax invoice amount, thereby improving the accuracy of the data. The application further improves the efficiency and practicality of the automated settlement of digital electronic invoices, significantly reduces the workload of business personnel in manually uploading tax invoices, conducting invoice reviews, and adjusting tolerances and tail differences, thereby greatly improving work efficiency.

[0046] The present application provides an automated settlement method and system for related transactions based on digital electricity invoices, which can automatically obtain invoice structured information and invoice image files by docking with the digital electricity invoice system, and automatically create related transaction settlement documents by automatically matching digital electricity invoices and purchase orders and receiving transactions. The automated process reduces the workload of manual operations and human intervention, improves work efficiency, and reduces the error rate caused by manual operations, ensuring the consistency of business data and financial data. The present application can summarize and archive digital electricity invoices and their associated settlement documents throughout the entire process, generate statistical reports, and facilitate enterprises to view and audit at any time, thereby improving the compliance and transparency of enterprises. The present application provides an efficient, accurate and flexible settlement automation processing method to meet the growing business needs of enterprises, improve settlement efficiency and accuracy, and reduce operating costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 This is one of the flow charts of the method for automated settlement of related transactions based on digital electricity invoices provided in the embodiment of the present application;

[0048] Figure 2 This is the second flow chart of the method for automated settlement of related transactions based on digital electronic invoices provided in the embodiment of the present application;

[0049] Figure 3 It is an architectural diagram of an automated settlement system for related transactions based on digital electronic invoices provided in an embodiment of the present application;

[0050] Figure 4 It is an architectural diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0052] The term "and / or" in this article is a description of the association relationship of associated objects, indicating that there can be three relationships. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. The symbol " / " in this article indicates that the associated objects are in an or relationship, for example, A / B means A or B.

[0053] In the embodiments of the present application, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in the embodiments of the present application should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0054] The embodiments of the present application are described below in conjunction with the drawings in the embodiments of the present application.

[0055] Figure 1 This is one of the flow charts of the method for automated settlement of related transactions based on digital invoices provided in the embodiment of the present application; Figure 1 As shown, the following steps are included:

[0056] Step S101, obtain the digital electricity invoice issued by the seller and the purchase receipt transaction provided by the purchaser; the digital electricity invoice includes at least one invoice detail line, the total amount excluding tax, the total tax amount and the total amount including tax, and the purchase receipt transaction includes at least one receiving transaction line, and each invoice detail line and each receiving transaction line include: quantity, unit price excluding tax, amount excluding tax and tax amount.

[0057] In one example, the purchase order of the associated transaction can be determined based on the sales order number and / or supplier name information carried in the digital invoice; the above-mentioned purchase order is provided by the purchaser; further, the above-mentioned purchase receipt transaction is determined from the purchase order; wherein, the purchase receipt transaction is the details of the goods shipped by the seller and the purchaser has confirmed receipt of the goods.

[0058] Step S102, matching each invoice detail line with the purchase receiving transaction in combination with the unit price excluding tax, quantity and the preset unit price tolerance excluding tax; when each invoice detail line matches one or more corresponding receiving transaction lines, obtaining corresponding matching information; summarizing the tax-excluding amount and tax amount of all receiving transaction lines in the matching information respectively, to obtain the summed tax-excluding amount, the summed tax amount and the summed tax-inclusive amount.

[0059] Specifically, the preset tax-exclusive unit price tolerance includes: the tax-exclusive unit price tolerance of each invoice detail line; wherein the tax-exclusive unit price tolerance of each invoice detail line is the same, the tax-exclusive unit price tolerance of some invoice detail lines is the same, or the tax-exclusive unit price tolerance of each invoice detail line is different. Further preferably, the tax-exclusive unit price of all invoice detail lines can be the same, or different tax-exclusive unit price tolerances can be set for different order ranges of tax-exclusive unit prices.

[0060] Exemplarily, after the seller and the buyer mutually determine the unit price, the unit price may be displayed to 2 to 15 decimal places due to the different ways of expressing the unit price due to the system's precision. Taking into account the difference in the decimal places of the unit prices displayed by the seller and the buyer, and / or the unit price tolerance within a certain range agreed in advance by the seller and the buyer, a reasonable tax-exclusive unit price tolerance can be preset to maximize the matching degree between the invoice detail line and the receiving transaction line within the unit price tolerance range. The above-mentioned tax-exclusive unit price tolerance is generally less than 0.01; for example, it can be 0.02, 0.01 or 0.0001, etc. (the value can be taken according to financial experience), and the unit is RMB. For transactions with larger amounts, the tolerance range can be appropriately relaxed; for transactions with smaller amounts, stricter tolerance standards can be set.

[0061] In an example, each invoice detail line is matched with a purchase receiving transaction, including: exact matching and fuzzy matching; exact matching has a higher priority than fuzzy matching, that is, exact matching is performed first and fuzzy matching is performed later; exact matching is: first matching is performed based on the fact that the tax-exclusive unit price of the receiving transaction line is the same as the tax-exclusive unit price of each invoice detail line, filtering out the receiving transaction lines with exact matching tax-exclusive unit prices, and then matching based on quantity; fuzzy matching is: first matching is performed based on the fact that the difference between the tax-exclusive unit price of the receiving transaction line and the tax-exclusive unit price of each invoice detail line is not greater than the corresponding tax-exclusive unit price tolerance, filtering out the receiving transaction lines with fuzzy matching tax-exclusive unit prices, and then matching based on quantity.

[0062] Furthermore, the above-mentioned precise matching is to first match the tax-exclusive unit price of each invoice detail line, screen out all receiving transaction lines whose tax-exclusive unit price in the receiving transaction line is consistent with it, then perform quantity matching among all the screened receiving transaction lines, and select at least one receiving transaction line whose quantity matches it as the receiving transaction line that matches the invoice detail line; the above-mentioned fuzzy matching is to match the tax-exclusive unit price of each invoice detail line in combination with the preset tax-exclusive unit price tolerance, screen out all receiving transaction lines whose tax-exclusive unit price in the receiving transaction line and the tax-exclusive unit price of the invoice detail line have a difference that is not greater than the tax-exclusive unit price tolerance, then perform quantity matching among all the screened receiving transaction lines, and select at least one receiving transaction line whose quantity matches it as the receiving transaction line that matches the invoice detail line.

[0063] Further preferably, the above-mentioned matching criteria by quantity include at least one of the following criteria: the quantity of an invoice detail line is consistent with the quantity of a received transaction line, the quantity of an invoice detail line is consistent with the sum of the quantities of multiple received transaction lines, the quantity of an invoice detail line is consistent with the partial quantity of a received transaction line, and the quantity of an invoice detail line is consistent with the sum of the partial quantities of multiple received transaction lines.

[0064] For example, each received transaction line further includes: a remaining invoicable quantity; the remaining invoicable quantity refers to a quantity in the received transaction line that has not yet been invoiced;

[0065] Further preferably, the above matching by quantity specifically includes: if the quantity of an invoice detail line is consistent with the quantity of a receiving transaction line, or the quantity of an invoice detail line is consistent with the sum of the quantities of multiple receiving transaction lines, then the corresponding one or more receiving transaction lines are used as receiving transaction lines that match the invoice detail line, and the information of the matched receiving transaction lines is copied to the matching information, and the remaining invoicable quantity of the corresponding one or more receiving transaction lines is updated to 0.

[0066] When actually matching, first select a receiving transaction line whose quantity is consistent with the quantity of the invoice detail line from all the filtered receiving transaction lines as the receiving transaction line that matches the invoice detail line, copy the information of the matched receiving transaction line to the matching information, and set the remaining invoicable quantity of the matched receiving transaction line to 0; then, if the quantity of each receiving transaction line in all the filtered receiving transaction lines is inconsistent with the quantity of the invoice detail line, select multiple receiving transaction lines whose total quantity is equal to the quantity of the invoice detail line, use the selected multiple receiving transaction lines as the receiving transaction lines that match the invoice detail line, copy the information of the matched receiving transaction line to the matching information, and set the remaining invoicable quantities of the matched multiple receiving transaction lines to 0.

[0067] Further preferably, the above-mentioned matching by quantity specifically also includes: if the quantity of an invoice detail line is consistent with the partial quantity of a receiving transaction line or is consistent with the sum of the partial quantities of multiple receiving transaction lines, then the corresponding one or more receiving transaction lines are used as receiving transaction lines that match the invoice detail line, and the information of the matched receiving transaction lines is copied to the matching information, and in the matching information, the quantity or the sum of the quantities of the one or more receiving transaction lines is set to be consistent with the quantity of the invoice detail line, and the quantity of the invoice detail line is subtracted from the remaining invoicable quantity of the corresponding one or more receiving transaction lines.

[0068] During the actual matching, if the quantity of each of the received transaction lines in all the screened received transaction lines is inconsistent with the quantity of the invoice detail line, a received transaction line with a quantity greater than the quantity of the invoice detail line is selected as the received transaction line that matches the invoice detail line, and the information of the matched received transaction line is copied to the matching information, and the quantity of the received transaction line is set to be consistent with the quantity of the invoice detail line in the matching information, and the quantity of the invoice detail line is subtracted from the remaining invoiceable quantity of the received transaction line; if the quantity of all the received transaction lines in all the screened received transaction lines is inconsistent with the quantity of the invoice detail line, multiple received transaction lines whose total quantity is greater than the quantity of the invoice detail line are selected according to the preset rules, and the selected multiple received transaction lines are used as the received transaction lines that match the invoice detail line, and the information of the matched multiple received transaction lines is copied to the matching information; the quantities of the multiple received transaction lines are respectively set according to the preset rules in the matching information, so that the sum of the set quantities is consistent with the quantity of the invoice detail line, and the quantities set in the corresponding matching information are respectively subtracted from the remaining invoiceable quantities of the multiple received transaction lines.

[0069] Among them, the preset rule is to select multiple receiving transaction lines with corresponding quantity matching sums in the order of quantity from large to small, quantity from small to large, quantity difference relative to the quantity of invoice detail lines to be matched from small to large, quantity difference relative to the quantity of invoice detail lines to be matched from large to small, or quantity random, and set the quantity in the matching information respectively.

[0070] Step S103, when at least one of the summarized amount excluding tax, the summarized tax amount and the summarized amount including tax is not equal to the total amount excluding tax, the total tax amount and the total amount including tax of the digital electronic invoice, and the difference between the summarized amount including tax and the total amount including tax of the digital electronic invoice is not greater than the preset tolerance of the total amount including tax, adjust the amount excluding tax and / or tax amount of at least one receiving transaction line in the matching information until the three are respectively equal.

[0071] For example, the above-mentioned total tax-inclusive amount tail difference tolerance is usually relatively small. The tail difference generally refers to the slight difference between the amount on the invoice and the actual transaction amount due to rounding or calculation accuracy during the invoice issuance process; for example, the above-mentioned tail difference tolerance can be 0.1, 0.2, etc. (the value can be determined according to financial experience); the unit is Yuan.

[0072] Specifically, one or more receiving transaction lines can be arbitrarily selected from the matching information to adjust their tax-exclusive amount and / or tax amount; or at least one receiving transaction line at at least one preset position can be selected from the matching information to adjust its tax-exclusive amount and / or tax amount.

[0073] In one example, when the difference between the aggregated amount including tax and the total amount including tax of the digital electrical invoice is not equal to 0, and the difference is not greater than the preset tolerance for the tail difference of the total amount including tax, or when the difference between the aggregated amount including tax and the total amount including tax of the digital electrical invoice is equal to 0, but the difference between the aggregated tax amount and the total tax amount of the digital electrical invoice is not equal to 0, the amount excluding tax and / or the tax amount of at least one receiving transaction line selected from the matching information is adjusted so that the adjusted aggregated amount excluding tax, aggregated tax amount, aggregated amount including tax are respectively the same as the total amount excluding tax, total tax amount, and total amount including tax of the digital electrical invoice.

[0074] Step S104, creating an invoice payable document according to the adjusted matching information, so as to settle the digital electricity invoice.

[0075] Figure 2 This is the second flow chart of the method for automated settlement of related transactions based on digital invoices provided in the embodiment of the present application; Figure 2 As shown, including:

[0076] (1) Invoice data acquisition: Regularly pull digital invoice structured data and invoice image files from the digital invoice system. Configure the user and password authorized by the digital invoice service, set the Restful interface call task, use the invoice code as the unique primary key, and synchronize the invoice data regularly. Invoice structured data includes invoice number, invoice date, invoice issuing company name (related transaction seller), invoice issuing company unified social credit code, remarks, total amount including tax, amount excluding tax, tax amount; product code, product description, specification model, unit, quantity, unit price, amount excluding tax, tax rate, tax amount. The digital invoice image file can refer to the display information of the existing digital invoice.

[0077] (2) Purchase order matching: Based on the sales order number and supplier name in the digital invoice of the seller of the related transaction, the purchase order and purchase receipt transaction of the buyer of the related transaction in the procurement system are automatically matched. If the total amount is consistent, a reconciliation statement is automatically created.

[0078] (3) Invoice details matching: Based on the principle of precise matching first and fuzzy matching later, precise matching refers to the line where the unit price excluding tax on the digital invoice detail line is exactly the same as the unit price excluding tax on the purchase order receiving transaction line. Fuzzy matching is based on the rule that if the difference between the unit price excluding tax on the invoice and the unit price excluding tax on the purchase receiving transaction is within the tolerance range, the two are considered to be the same. The specific steps are as follows:

[0079] (3-1) Get the preset unit price tolerance Δp. Define the number of invoice detail lines as j, j = 1, 2, 3, ..., n; define the number of purchase order receiving transaction lines as k, k = 1, 2, 3, ..., m. Q k The invoiced quantity for the kth line of the purchase order receipt transaction.

[0080] (3-2) Set the traversal round to S, the initial value of S is 1, and S≤5. Match the invoice quantity of the purchase receipt transaction line one by one according to the invoice line number from small to large.

[0081] (3-3) S = 1, the invoice line and the receiving transaction line with the same unit price and quantity are marked as matched, and are removed from the matching range. If all invoice lines j are marked as matched, proceed to step (4) to determine and eliminate the tail difference, otherwise proceed to the next step.

[0082] (3-4) Set S = S + 1 and S ≤ 5. For invoice lines with the same unit price as the receiving transaction line, but with a smaller invoice line quantity than the receiving transaction line quantity, match the invoice lines from the smallest to the largest available invoice quantity of the receiving transaction line. The matched invoice lines are marked as matched and removed from the matching range. The available invoice quantity of the receiving transaction line minus the matched quantity, if greater than 0, is used for subsequent invoice line matching. If all invoice lines j are marked as matched, proceed to step (4) to determine and eliminate the tail difference, otherwise proceed to the next step.

[0083] (3-5) Set S = S + 1 and S ≤ 5: For invoice lines with the same unit price as the receiving transaction line, but with a larger invoice line quantity than the receiving transaction line quantity, perform cumulative matching according to the invoice line quantity available for invoicing from small to large. The matching invoice lines and receiving transaction lines are marked as matched and the matching range is eliminated. The invoice line quantity available for invoicing minus the matched quantity is greater than 0 and is used for subsequent invoice line matching. If all invoice lines j are marked as matched, proceed to step (4) to determine and eliminate the tail difference, otherwise proceed to the next step.

[0084] (3-6) Set S = S + 1 and S ≤ 5: Add the unit price tolerance Δp, and add the remaining receiving transaction line unit prices ± Δp to obtain the unit price range within the tolerance range. Match the invoice line unit price with it. If it falls within the receiving transaction line unit price range, it meets the unit price matching condition. Continue to match the invoice lines that meet the conditions and have a quantity less than the receiving transaction line's invoiceable quantity from small to large according to the receiving transaction line's invoiceable quantity. Mark the matched ones as matched and eliminate the matching range. The receiving transaction line's invoiceable quantity minus the matched quantity, if it is greater than 0, will continue to be used for subsequent invoice line matching. If all invoice lines j are marked as matched, go to step (4) to judge and eliminate the tail difference, otherwise go to the next step.

[0085] (3-7) Set S = S + 1, and S ≤ 5: Invoice lines that meet the unit price matching conditions of the previous round and whose quantity is greater than the invoice quantity of the receiving transaction line are cumulatively matched according to the invoice quantity of the receiving transaction line from small to large, and the matched invoice lines are marked as matched, and the matching range is eliminated. The invoice quantity of the receiving transaction line minus the matched quantity is greater than 0 and is continued to be used for subsequent invoice line matching. Continue to be used for subsequent invoice line matching. If all invoice lines j are marked as matched, go to step (4) to judge and eliminate the tail difference. Otherwise, notify the buyer by email and verify with the seller to re-invoice.

[0086] When all invoice lines j are marked as matched, the corresponding relationship between the invoice detail lines, the purchase receipt transaction lines and the current invoicing quantity is output, as shown in Table 1:

[0087] Table 1

[0088]

[0089] As shown in the example in Table 1, the receiving transaction lines matched by the first invoice detail line are the i-th receiving transaction line, the j-th receiving transaction line..., the h-th receiving transaction line, and the invoice quantities of each matching receiving transaction line are: Accordingly, the remaining invoicable quantity of the i-th receiving transaction line, the j-th receiving transaction line, ..., and the h-th receiving transaction line in the original purchase receiving transaction is deducted from the original remaining invoicable quantity.

[0090] Accordingly, the aggregated matching information can be listed as follows:

[0091]

[0092] in, The quantity of invoice issued for each receiving transaction line (1, 2, ..., m) after this matching.

[0093] (4) Determination and elimination of tail difference: Determine whether there is a difference between the total amount including tax and tax amount of the matched digital invoice and the total amount including tax and tax amount of the matched purchase receipt transaction line summary. If there is no difference, directly create an invoice payable document for the purchaser of the related transaction and associate it with the digital invoice image file. If there is a tail difference in any of the total amount including tax and the tax amount, adjust the amount of the invoice payable document according to the set tail difference tolerance range. After it is no different from the tax invoice amount, automatically create an invoice payable document for the purchaser of the related transaction and associate it with the tax invoice image file. If it exceeds the tail difference tolerance range set by the system, the seller will be notified by email to re-invoice. The steps for adjusting the tail difference are as follows:

[0094] (4-1) Parameter definition

[0095] a. Obtain the allowable difference Δt (Δt>0) between the total amount including tax of the invoice and the total amount including tax of the invoice payable.

[0096] b. Define the total amount including tax, total amount excluding tax, and total tax amount of the A / P invoice as X, Y, and Z respectively, and X = Y + Z. The total amount including tax, total amount excluding tax, and total tax amount of the digital invoice are X', Y', and Z' respectively; X' = Y' + Z'.

[0097] c. Define the product detail line number of the invoice payable as i, i = 1, 2, 3, ..., n; X i , Y i , Z i Respectively represent the tax-inclusive amount, tax-exclusive amount, and tax amount of the i-th line of the invoice payable. i , Y′ i , Z′ i They represent the adjusted amount including tax, amount excluding tax and tax amount of the i-th line of the invoice payable document respectively.

[0098] Total amount of invoice payable including tax:

[0099] Total amount of invoice payable excluding tax:

[0100] Total tax amount of invoice payable:

[0101] d. Define the difference between the total amount including tax of the invoice payable and the digital invoice as ΔX, ΔX = |XX′|, and the difference between the total tax amount of the invoice payable and the digital invoice as ΔZ, ΔZ = |ZZ′|.

[0102] (4-2) Determination of tail difference range

[0103] When the difference of the total amount including tax is ΔX≠0, and ΔX≤Δt or ΔX=0, and ΔZ≠0, the tail difference range allowed by the system is met, and the tail difference between the amount excluding tax and the tax amount of the item in the detail line of the A / P invoice document needs to be automatically adjusted to eliminate the tail difference. When the difference of the total amount including tax is ΔX>Δt, the seller is notified by email to re-invoice.

[0104] (4-3) Tail Difference Adjustment

[0105] Scenario 1: When ΔX≠0 and ΔX≤Δt, that is, there is a difference between the total amount including tax of the A / P invoice and the digital invoice, the amount including tax, amount excluding tax and tax amount of the A / P invoice detail line shall be adjusted.

[0106] Set i=1. In an example, select the first detail line of the A / P invoice for adjustment.

[0107] The tax-inclusive amount after adjustment: X′1=X1+(X′-X);

[0108] Adjusted tax amount: Z′1=Z1+(Z′-Z);

[0109] The amount excluding tax after adjustment is: Y′1=X′1-Z′1.

[0110] Scenario 2: When ΔX=0 and ΔZ≠0, that is, the total amount including tax of the A / P invoice and the digital invoice is the same, but there is a difference in the total amount excluding tax or the tax amount, then the amount excluding tax and the tax amount of the A / P invoice detail line shall be adjusted.

[0111] Set i=1. In an example, select the first detail line of the A / P invoice for adjustment.

[0112] The tax-inclusive amount after adjustment: X′1=X1;

[0113] Adjusted tax amount: Z′1=Z1+(Z′-Z);

[0114] The adjusted amount excluding tax is: Y′1=Y1+(Y′-Y).

[0115] (4-4) Reassign the amount of detail line: reassign the tax-inclusive amount, tax-exclusive amount and tax amount of the first detail line of the invoice payable document to X′1, Y′1 and Z′1.

[0116] (5) Creation and push of payable invoice documents: Create, submit and push payable invoice documents to the payable invoice settlement module.

[0117] (6) Review of invoice payable documents and invoice accounting: The finance staff reviews the invoice payable documents and pushes them to the Enterprise Resource Planning (ERP) system for automatic invoice accounting after approval, generating an ERP invoice voucher number.

[0118] (7) Payment slip creation: Automatically generate a payment slip based on the payable invoice document, including payment amount, payment date, payment method and other information.

[0119] (8) Payment order review and payment accounting: After the cashier reviews and approves the payment order, he / she will make the payment according to the payment date and push the invoice payment information to ERP for invoice payment accounting and generate the ERP payment voucher number.

[0120] (9) Full-process data aggregation and archiving: The purchase orders, purchase receipt transactions, payable invoice documents and status, payment documents and status, invoice vouchers, and payment vouchers associated with digital invoices are aggregated and archived throughout the entire process to generate statistical reports.

[0121] In a further embodiment, an automated settlement system for related transactions based on digital invoices may be built based on the automated settlement method described above. The system may include:

[0122] (1) Digital invoice data acquisition module

[0123] This module is responsible for periodically obtaining the structured data and invoice image files of invoices from the digital invoice system.

[0124] Specific features include:

[0125] 1. Data interface connection: Configure the user and password authorized by the digital invoice service, verify the interface connectivity, and ensure that the interface can accurately obtain the digital invoice data.

[0126] 2. Scheduled task setting: Set interface scheduled tasks according to user needs.

[0127] 3. Scheduled retrieval: Set the time according to the scheduled task, and retrieve invoice data from the digital invoice system on a regular basis every day.

[0128] 4. Data analysis and storage: The acquired invoice structured data, such as invoice number, invoice date, invoice issuer information, etc., are stored in the database. At the same time, the invoice image file is saved to the file server.

[0129] (2) A / P Invoice Creation Module

[0130] This module is responsible for matching the purchase orders associated with digital invoices, automatically reconciling accounts, and creating payable invoices. Specific functions include:

[0131] 1. Purchase order matching: Automatically match the purchase order of the buyer of the related transaction in the procurement system according to the sales order number and supplier name in the digital invoice remarks.

[0132] 2. Invoice details matching: Match the unit price excluding tax and quantity of the digital invoice detail line with the unit price excluding tax and invoicable quantity of the purchase order receiving transaction line until all invoice details are matched.

[0133] 3. Determination and processing of tail difference: Determine whether there is tail difference in the total amount including tax, total amount excluding tax, tax amount, etc. between the digital invoice line and the invoice payable document corresponding to the receiving transaction. If the tail difference is within the allowable range, the amount of the invoice payable document will be automatically adjusted to make it consistent with the tax invoice amount; if it exceeds the allowable range, the buyer will be notified by email and the invoice will be re-issued after verification with the seller.

[0134] 4. Creation of A / P invoice documents: Based on the invoice line matching and tail difference processing results, the A / P invoice documents are automatically created and associated with the corresponding digital invoice image files.

[0135] (3) A / P Invoice Settlement Module

[0136] This module is responsible for reviewing the invoices payable and automatically generating payment slips for review and payment after they are approved. Specific functions include:

[0137] 1. Review of invoices payable: Finance personnel review invoices payable in the supplier settlement system to ensure the accuracy and compliance of document information.

[0138] 2. Payment slip generation: After the payable invoice document is reviewed and approved, the system automatically generates a payment slip, including payment amount, payment date, payment method and other information.

[0139] 3. Review and payment of payment slip: The cashier reviews the payment slip and makes payment after confirming that it is correct. After successful payment, the payment information is pushed to the ERP system for payment accounting.

[0140] (4) Financial automatic accounting module

[0141] This module is responsible for automatically recording invoices based on the associated digital invoices of the invoices payable, and for recording the payment of invoices based on the payment status of the invoices payable. Specific functions include:

[0142] 1. Automatic invoice accounting: For the approved payable invoice documents, they are automatically pushed to the ERP system for invoice accounting and generate ERP invoice voucher numbers.

[0143] 2. Automatic payment accounting: According to the payment status of the invoice payable, the payment accounting is automatically pushed to the ERP system to generate the ERP payment voucher number. At the same time, the payment information is associated with the invoice information to ensure the integrity and accuracy of the data.

[0144] (5) Report Management Module

[0145] This module is responsible for summarizing and archiving the entire process of purchase orders, purchase receipt transactions, payable invoices and status, payment documents and status, invoice vouchers, and payment vouchers associated with digital invoices, and generating statistical reports.

[0146] In a further embodiment, Figure 3 is an architectural diagram of an automated settlement system for associated transactions based on digital electronic invoices provided in an embodiment of the present application; Figure 3 As shown, including:

[0147] The digital electricity invoice acquisition unit 310 is used to acquire the digital electricity invoice issued by the seller and the purchase receiving transaction provided by the purchaser; the digital electricity invoice includes at least one invoice detail line, the total amount excluding tax, the total tax amount and the total amount including tax, and the purchase receiving transaction includes at least one receiving transaction line, and each invoice detail line and each receiving transaction line include: quantity, unit price excluding tax, amount excluding tax and tax amount;

[0148] The invoice detail matching unit 320 is used to match each invoice detail line with the purchase receiving transaction in combination with the tax-exclusive unit price, quantity and preset tax-exclusive unit price tolerance; when each invoice detail line is matched to one or more corresponding receiving transaction lines, obtain corresponding matching information; and summarize the tax-exclusive amount and tax amount of all receiving transaction lines in the matching information to obtain a summarized tax-exclusive amount, a summarized tax amount and a summarized tax-inclusive amount;

[0149] The matching amount tail difference elimination unit 330 is used to adjust the tax-exclusive amount and / or tax amount of at least one received transaction line in the matching information until the three are respectively equal when the summarized tax-exclusive amount, the summarized tax amount and the summarized tax-inclusive amount are not equal to the total tax-exclusive amount, the total tax amount and the total tax-inclusive amount of the digital invoice, and the difference between the summarized tax-inclusive amount and the total tax-inclusive amount of the digital invoice is not greater than a preset total tax-inclusive amount tail difference tolerance;

[0150] The payable invoice document creation unit 340 is used to create a payable invoice document according to the adjusted matching information so as to settle the digital electricity invoice.

[0151] In a possible implementation, the preset tax-exclusive unit price tolerance includes: the tax-exclusive unit price tolerance of each invoice detail line; wherein the tax-exclusive unit price tolerance of each invoice detail line is the same, the tax-exclusive unit price tolerance of some invoice detail lines is the same, or the tax-exclusive unit price tolerance of each invoice detail line is different;

[0152] The invoice detail matching unit 320 matches each invoice detail line with the purchase receiving transaction in the following matching methods: exact matching and fuzzy matching; the exact matching has a higher priority than fuzzy matching; the exact matching is: first matching based on the tax-exclusive unit price of the receiving transaction line being the same as the tax-exclusive unit price of each invoice detail line, filtering out the receiving transaction lines with exact matching tax-exclusive unit prices, and then matching based on quantity; the fuzzy matching is: first matching based on the tax-exclusive unit price of the receiving transaction line being the same as the tax-exclusive unit price of each invoice detail line, filtering out the receiving transaction lines with fuzzy matching tax-exclusive unit prices, and then matching based on quantity; and / or the matching criteria based on quantity include at least one of the following criteria: the quantity of an invoice detail line is consistent with the quantity of a receiving transaction line, the quantity of an invoice detail line is consistent with the sum of the quantities of multiple receiving transaction lines, the quantity of an invoice detail line is consistent with a partial quantity of a receiving transaction line, and the quantity of an invoice detail line is consistent with the sum of the partial quantities of multiple receiving transaction lines.

[0153] It should be understood that the above-mentioned system is used to execute the methods in the above-mentioned embodiments. The implementation principles and technical effects of the corresponding program units in the system are similar to those described in the above-mentioned methods. The working process of the system can refer to the corresponding process in the above-mentioned method and will not be repeated here.

[0154] Based on the method in the above embodiment, the embodiment of the present application provides an electronic device, such as Figure 4 As shown, the electronic device may include: a processor 410, a communication interface 420, a memory 430 and a communication bus 440, wherein the processor 410, the communication interface 420 and the memory 430 communicate with each other via the communication bus 440. The processor 410 may call the logic instructions in the memory 430 to execute the method in the above embodiment.

[0155] In addition, the logic instructions in the above-mentioned memory 430 can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application.

[0156] Based on the method in the above embodiment, an embodiment of the present application provides a computer-readable storage medium, which stores a computer program. When the computer program runs on a processor, the processor executes the method in the above embodiment.

[0157] Based on the method in the above embodiment, an embodiment of the present application provides a computer program product. When the computer program product runs on a processor, the processor executes the method in the above embodiment.

[0158] It is understandable that the processor in the embodiment of the present application may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field programmable gate arrays (FPGA) or other programmable logic devices, transistor logic devices, hardware components or any combination thereof. The general-purpose processor may be a microprocessor or any conventional processor.

[0159] The method steps in the embodiments of the present application can be implemented by hardware or by a processor executing software instructions. The software instructions can be composed of corresponding software modules, and the software modules can be stored in random access memory (RAM), flash memory, read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), registers, hard disks, mobile hard disks, CD-ROMs, or any other form of storage medium known in the art. An exemplary storage medium is coupled to a processor so that the processor can read information from the storage medium and write information to the storage medium. Of course, the storage medium can also be a component of the processor. The processor and the storage medium can be located in an ASIC.

[0160] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium or transmitted through the computer-readable storage medium. The computer instructions may be transmitted from a website site, a computer, a server or a data center to another website site, a computer, a server or a data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or a data center that includes one or more available media integrated. The available medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive (SSD)), etc.

[0161] It should be understood that the various numerical numbers involved in the embodiments of the present application are only used for the convenience of description and are not used to limit the scope of the embodiments of the present application.

[0162] It will be easily understood by those skilled in the art that the above description is only a preferred embodiment of the present application and is not intended to limit the present application. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present application shall be included in the scope of protection of the present application.

Claims

1. A method for automated settlement of related transactions based on digital invoices, characterized in that: include: Obtain the digital invoice issued by the seller and the purchase receipt transaction provided by the buyer; The digital invoice includes at least one invoice detail line, a total amount excluding tax, a total tax amount, and a total amount including tax, and the purchase receiving transaction includes at least one receiving transaction line, and each invoice detail line and each receiving transaction line includes: quantity, unit price excluding tax, amount excluding tax, and tax amount; In combination with the tax-exclusive unit price, quantity, and preset tax-exclusive unit price tolerance, each invoice detail line is matched with a purchase receiving transaction; when each invoice detail line is matched to one or more corresponding receiving transaction lines, corresponding matching information is obtained; and the tax-exclusive amounts and tax amounts of all receiving transaction lines in the matching information are respectively summarized to obtain a summarized tax-exclusive amount, a summarized tax amount, and a summarized tax-inclusive amount; When at least one of the summarized tax-exclusive amount, the summarized tax amount and the summarized tax-inclusive amount is not equal to the total tax-exclusive amount, the total tax amount and the total tax-inclusive amount of the digital invoice, and the difference between the summarized tax-inclusive amount and the total tax-inclusive amount of the digital invoice is not greater than the preset total tax-inclusive amount tail difference tolerance, adjust the tax-exclusive amount and / or tax amount of at least one receiving transaction line in the matching information until the three are respectively equal; An A / P invoice document is created based on the adjusted matching information to settle the digital invoice.

2. The method according to claim 1, characterized in that The preset tax-exclusive unit price tolerance includes: the tax-exclusive unit price tolerance of each invoice detail line; wherein the tax-exclusive unit price tolerance of each invoice detail line is the same, the tax-exclusive unit price tolerance of some invoice detail lines is the same, or the tax-exclusive unit price tolerance of each invoice detail line is different; and / or in combination with a preset tax-exclusive unit price tolerance, matching each invoice detail line with the purchase receipt transaction, including: exact matching and fuzzy matching; the exact matching has a higher priority than the fuzzy matching; The exact matching is as follows: firstly, matching is performed based on the tax-exclusive unit price of the receiving transaction line being the same as the tax-exclusive unit price of each invoice detail line, filtering out the receiving transaction lines whose tax-exclusive unit price is exactly matched, and then matching is performed based on quantity; The fuzzy matching is: firstly matching based on the difference between the tax-exclusive unit price of the receiving transaction line and the tax-exclusive unit price of each invoice detail line is not greater than the corresponding tax-exclusive unit price tolerance, screening out the receiving transaction lines with fuzzy matching of the tax-exclusive unit price, and then matching based on quantity; and / or The criteria for matching by quantity include at least one of the following criteria: the quantity of an invoice detail line is consistent with the quantity of a received transaction line, the quantity of an invoice detail line is consistent with the sum of the quantities of multiple received transaction lines, the quantity of an invoice detail line is consistent with the partial quantity of a received transaction line, and the quantity of an invoice detail line is consistent with the sum of the partial quantities of multiple received transaction lines.

3. The method according to claim 2, characterized in that Each receiving transaction line also includes: the remaining invoicable quantity; the remaining invoicable quantity refers to the quantity in the receiving transaction line that has not yet been invoiced; If the quantity of an invoice detail line is consistent with the quantity of a receiving transaction line, or the quantity of an invoice detail line is consistent with the sum of the quantities of multiple receiving transaction lines, the corresponding one or more receiving transaction lines will be used as the receiving transaction lines that match the invoice detail line, and the information of the matching receiving transaction lines will be copied to the matching information, and the remaining invoicable quantity of the corresponding one or more receiving transaction lines will be updated to 0; If the quantity of an invoice detail line is consistent with the partial quantity of a receiving transaction line or the sum of the partial quantities of multiple receiving transaction lines, the corresponding one or more receiving transaction lines will be used as the receiving transaction lines that match the invoice detail line, and the information of the matched receiving transaction lines will be copied to the matching information, and in the matching information, the quantity or the sum of the quantities of the one or more receiving transaction lines will be set to be consistent with the quantity of the invoice detail line, and the quantity of the invoice detail line will be subtracted from the remaining invoicable quantity of the corresponding one or more receiving transaction lines.

4. The method according to claim 2 or 3, characterized in that: The matching according to quantity includes: Select a receiving transaction line whose quantity is consistent with the quantity of the invoice detail line from all the filtered receiving transaction lines as the receiving transaction line that matches the invoice detail line, copy the information of the matching receiving transaction line to the matching information, and set the remaining invoicable quantity of the matching receiving transaction line to 0; If the quantity of each of the filtered receiving transaction lines is inconsistent with the quantity of the invoice detail line, multiple receiving transaction lines whose total quantity is equal to the quantity of the invoice detail line are selected from them, and the selected multiple receiving transaction lines are used as the receiving transaction lines that match the invoice detail line, and the information of the matched receiving transaction lines is copied to the matching information, and the remaining invoicable quantities of the matched multiple receiving transaction lines are all set to 0; If the quantity of each of the filtered receiving transaction lines is inconsistent with the quantity of the invoice detail line, a receiving transaction line with a quantity greater than the quantity of the invoice detail line is selected as the receiving transaction line that matches the invoice detail line, and the information of the matched receiving transaction line is copied to the matching information, and the quantity of the receiving transaction line is set to be consistent with the quantity of the invoice detail line in the matching information, and the quantity of the invoice detail line is subtracted from the remaining invoicable quantity of the receiving transaction line; or If the quantity of all the received transaction lines in all the screened received transaction lines is inconsistent with the quantity of the invoice detail line, then multiple received transaction lines whose total quantity is greater than the quantity of the invoice detail line are selected according to the preset rule, and the selected multiple received transaction lines are used as the received transaction lines that match the invoice detail line, and the information of the matched multiple received transaction lines is copied to the matching information; the quantities of the multiple received transaction lines are set respectively in the matching information according to the preset rule, so that the sum of the set quantities is consistent with the quantity of the invoice detail line, and the quantities set in the corresponding matching information are subtracted from the remaining invoiceable quantities of the multiple received transaction lines; wherein the preset rule is to select multiple received transaction lines whose corresponding total quantity matches in the order of the number of received transaction lines from large to small, the number from small to large, the difference in quantity relative to the number of invoice detail lines to be matched from small to large, the difference in quantity relative to the number of invoice detail lines to be matched from large to small, or the number is random, and the quantities are set respectively in the matching information.

5. The method according to claim 1, characterized in that Adjust the tax-exclusive amount and / or tax amount of the receiving transaction line, including: Arbitrarily select one or more receiving transaction lines from the matching information to adjust their tax-exclusive amount and / or tax amount; or select at least one receiving transaction line at at least one preset position from the matching information to adjust its tax-exclusive amount and / or tax amount.

6. The method according to claim 1 or 5, characterized in that: Adjust the tax-exclusive amount and / or tax amount of the receiving transaction line, including: When the difference between the aggregated amount including tax and the total amount including tax of the digital electronic invoice is not equal to 0, and the difference is not greater than the preset tolerance for the tail difference of the total amount including tax, or when the difference between the aggregated amount including tax and the total amount including tax of the digital electronic invoice is equal to 0, but the difference between the aggregated tax amount and the total tax amount of the digital electronic invoice is not equal to 0, adjust the amount excluding tax and / or the tax amount of at least one receiving transaction line selected from the matching information so that the adjusted aggregated amount excluding tax, aggregated tax amount, aggregated amount including tax are respectively the same as the total amount excluding tax, total tax amount, and total amount including tax of the digital electronic invoice.

7. The method according to any one of claims 1 to 3, characterized in that: Obtain the digital invoice issued by the seller of the related transaction and the purchase receipt transaction provided by the purchaser, including: Determine the purchase order of the associated transaction based on the sales order number and / or supplier name information carried by the digital invoice; the purchase order is provided by the purchaser; The purchase receiving transaction is determined from the purchase order; the purchase receiving transaction is the details of the goods shipped by the seller and the purchaser has confirmed receipt of the goods.

8. An automated settlement system for related transactions based on digital invoices, characterized in that: include: A digital invoice acquisition unit is used to acquire the digital invoice issued by the seller and the purchase receipt transaction provided by the purchaser; The digital invoice includes at least one invoice detail line, a total amount excluding tax, a total tax amount, and a total amount including tax, and the purchase receiving transaction includes at least one receiving transaction line, and each invoice detail line and each receiving transaction line includes: quantity, unit price excluding tax, amount excluding tax, and tax amount; an invoice detail matching unit, for matching each invoice detail line with a purchase receiving transaction in combination with the tax-exclusive unit price, quantity, and a preset tax-exclusive unit price tolerance; when each invoice detail line is matched to one or more corresponding receiving transaction lines, obtaining corresponding matching information; and summarizing the tax-exclusive amounts and tax amounts of all receiving transaction lines in the matching information to obtain a summed tax-exclusive amount, a summed tax amount, and a summed tax-inclusive amount; A matching amount tail difference elimination unit is used to adjust the tax-exclusive amount and / or tax amount of at least one receiving transaction line in the matching information until the three are respectively equal when the summarized tax-exclusive amount, the summarized tax amount and the summarized tax-inclusive amount are not equal to the total tax-exclusive amount, the total tax amount and the total tax-inclusive amount of the digital invoice, and the difference between the summarized tax-inclusive amount and the total tax-inclusive amount of the digital invoice is not greater than a preset total tax-inclusive amount tail difference tolerance; The payable invoice document creation unit is used to create a payable invoice document according to the adjusted matching information so as to settle the digital invoice.

9. The method according to claim 8, characterized in that The preset tax-exclusive unit price tolerance includes: the tax-exclusive unit price tolerance of each invoice detail line; wherein the tax-exclusive unit price tolerance of each invoice detail line is the same, the tax-exclusive unit price tolerance of some invoice detail lines is the same, or the tax-exclusive unit price tolerance of each invoice detail line is different; And / or the invoice detail matching unit, the matching methods used to match each invoice detail line with the purchase receiving transaction include: exact matching and fuzzy matching; the exact matching has a higher priority than fuzzy matching; the exact matching is: first matching according to the tax-exclusive unit price of the receiving transaction line is the same as the tax-exclusive unit price of each invoice detail line, screening out the receiving transaction lines with exact matching tax-exclusive unit price, and then matching according to quantity; the fuzzy matching is: first matching according to the tax-exclusive unit price of the receiving transaction line and the tax-exclusive unit price of each invoice detail line The difference is not greater than the corresponding tax-exclusive unit price tolerance, screening out the receiving transaction lines with fuzzy matching tax-exclusive unit price, and then matching according to quantity; and / or the standard for matching according to quantity includes at least one of the following standards: the quantity of an invoice detail line is consistent with the quantity of a receiving transaction line, the quantity of an invoice detail line is consistent with the sum of the quantities of multiple receiving transaction lines, the quantity of an invoice detail line is consistent with the partial quantity of a receiving transaction line, and the quantity of an invoice detail line is consistent with the sum of the partial quantities of multiple receiving transaction lines.

10. An electronic device, characterized in that: include: at least one memory for storing a computer program; At least one processor is used to execute the program stored in the memory. When the program stored in the memory is executed, the processor is used to execute the method according to any one of claims 1 to 7.

Images