JP2022008289A - Bill management device, bill management method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce the burden on an accounting person to process an invoice.
An invoice management device 1 is an invoice management device 1 that manages invoices, and acquires invoice data indicating invoice contents and voucher data indicating transaction contents corresponding to the invoices. Acquisition unit 141 to calculate, the calculation unit 143 to calculate the amount difference which is the difference between the billing amount included in the billing data and the amount included in the voucher data, and the case where the amount difference is less than a predetermined threshold and the amount difference. It has an output unit 144 that outputs different result information regarding the admissibility of the billed amount depending on whether or not is equal to or greater than the threshold value.
[Selection diagram] Fig. 3

Description

The present invention relates to an invoice management device, an invoice management method and a program.

Conventionally, a system for checking the validity of the invoice amount is known. Patent Document 1 discloses a technique for notifying when the total amount contained in the invoice data and the total amount contained in the purchase order data corresponding to the invoice data do not match.

Japanese Unexamined Patent Publication No. 2016-066334

However, the person who receives the above notification (for example, the accounting person) must investigate the cause of the inconsistent amount and decide whether or not the invoice can be processed in the inconsistent amount. However, it was a heavy burden for the accounting staff who processed a large number of invoices.

Therefore, the present invention has been made in view of these points, and an object thereof is to reduce the burden on the accounting staff to process the invoice.

The invoice management device according to the first aspect of the present invention is an invoice management device that manages invoices, and shows invoice data indicating the invoice contents and transaction contents corresponding to the invoice data. An acquisition unit that acquires voucher data, a calculation unit that calculates the amount difference that is the difference between the billing amount included in the billing data and the amount included in the voucher data, and the amount difference is less than a predetermined threshold value. It has an output unit that outputs different result information regarding the admissibility of the billed amount depending on whether the amount difference is equal to or greater than the threshold value.

When the amount difference is less than the threshold value, the output unit outputs acceptable information indicating that the amount difference is acceptable as the result information, and when the amount difference is equal to or more than the threshold value, the output unit outputs the allowable information. The unacceptable information indicating that the amount difference is unacceptable may be output as the result information.

When the output unit determines that the amount difference is caused by the difference in the predetermined tax rounding, the output unit outputs the allowable information, and the amount difference is caused by the difference in the rounding. If it is determined that there is no such information, the unacceptable information may be output.

The calculation unit calculates a plurality of tax amounts by a plurality of methods having different fraction processing of the predetermined tax based on the amount other than the predetermined tax included in the billing data, and the output unit is the calculation unit. If the total amount obtained by adding any of the plurality of tax amounts calculated by the above to the amount other than the predetermined tax amount matches the invoiced amount, the allowable information is output and the total amount matches the invoiced amount. If not, the unacceptable information may be output.

The output unit may output information indicating the content of the rounding process used by the calculation unit when the total amount matches the billed amount.

When the amount difference is equal to or greater than the threshold value, the output unit sets the billed amount from among a plurality of other voucher data different from the first voucher data used by the calculation unit to calculate the amount difference. Information on one or more second voucher data including the amount of money for which the amount difference is less than the threshold value may be output.

When the amount difference is equal to or greater than the threshold value, the output unit corresponds to the billing data among a plurality of other voucher data different from the first voucher data used by the calculation unit to calculate the amount difference. Information about one or more second voucher data with a relatively high probability of being used may be output.

The output unit is associated with at least one of the business name, product name, unit price or number of purchases included in the billing data in association with the one or more second voucher data, and the business included in the voucher data. A reliability number indicating the degree of matching with at least one of a person's name, a product name, a unit price, or the number of purchases may be output.

When the amount difference is equal to or greater than the threshold value, the acquisition unit acquires other voucher data different from the first voucher data used by the calculation unit to calculate the amount difference, and the calculation unit obtains the other voucher data. The amount difference, which is the difference between the billing amount included in the billing data and the amount included in the other voucher data, may be calculated.

The acquisition unit acquires a plurality of the voucher data of different types, and the calculation unit acquires the billed amount and the amount difference included in the voucher data for each voucher data. In the output unit, the case where each of the plurality of amount differences calculated by the calculation unit is less than the threshold value and the case where at least one of the plurality of amount difference is equal to or more than the threshold value. , Different result information may be output regarding the admissibility of the billed amount.

The acquisition unit acquires the first voucher data including the order contents or the approval contents regarding the order, and the second voucher data including the delivery contents or the acceptance inspection contents for the delivery as the voucher data, and the output unit obtains the billing data. It is the difference between the billed amount and the first amount when the included billing amount, the first amount included in the first voucher data, and the second amount included in the second voucher data do not match. It may be determined whether or not the first amount difference and the second amount difference, which is the difference between the billed amount and the second amount, are due to the fraction processing of the predetermined tax.

The invoice management method according to the second aspect of the present invention includes billing data indicating the invoice content of the invoice executed by a computer that manages the invoice, and voucher data indicating the transaction content corresponding to the invoice data. The step of calculating the amount difference which is the difference between the billing amount included in the billing data and the amount included in the voucher data, the case where the amount difference is less than a predetermined threshold, and the case where the amount difference is less than a predetermined threshold. It has a step of outputting different result information regarding the admissibility of the billed amount depending on whether the amount difference is equal to or greater than the threshold value.

In the program according to the third aspect of the present invention, the computer that manages the invoice acquires the billing data indicating the billing content of the invoice and the voucher data indicating the transaction content corresponding to the billing data. , A calculation unit that calculates the amount difference between the billing amount included in the billing data and the amount included in the voucher data, and when the amount difference is less than a predetermined threshold, the amount difference is said. It functions as an output unit that outputs different result information regarding the admissibility of the billed amount depending on whether the billing amount is equal to or higher than the threshold value.

According to the present invention, there is an effect that the burden on the accounting staff to process the invoice can be reduced.

It is a figure for demonstrating the outline of an invoice management apparatus. It is a figure which shows an example of the invoice received by the demandee. It is a figure which shows the functional structure of an invoice management apparatus. It is a figure which shows an example of the invoice information database which a storage part stores. It is a flowchart which shows the operation flow of an invoice management apparatus.

[Overview of invoice management device 1]
FIG. 1 is a diagram for explaining an outline of the invoice management device 1. The invoice management device 1 is a device for acquiring invoice data indicating the invoice content of the invoice and managing the invoice using the result of analyzing the character string included in the invoice data, for example, a computer. The invoice management device 1 may be configured by one computer or may be configured by a plurality of computers.

An invoice is a document issued to charge the price of goods or the price of services (hereinafter referred to as "price"). The billing data is, for example, image data generated by the reading device 2 (for example, a scanner or a digital camera) reading the bill.

The invoice management device 1 manages voucher data of a voucher different from the invoice in addition to the invoice. The voucher data is data indicating the transaction details of a product or service (hereinafter, simply referred to as "commodity"), for example, order data indicating the order details, approval data indicating the approval details regarding the order, delivered products, and the like. Delivery data indicating the delivery contents or acceptance data indicating the acceptance contents for the delivery. In the present embodiment, the voucher data will be described as ordering data. Specifically, the invoice management device 1 acquires order data indicating the order contents of the purchase order, and manages the purchase order using the result of analyzing the character string included in the order data. A purchase order is a document issued to request a product to purchase. The order data is, for example, image data generated by the reading device 2 reading the purchase order. The order data may be input data in which each data item included in the order data is input. The invoice management device 1 may manage the purchase order instead of the purchase order.

The invoice management device 1 is used by a business operator that manages issued invoices, that is, a demandee who is charged for the transaction. The claimant is, for example, a person involved in the accounting business of the company that received the invoice (for example, an accounting person), a person involved in the purchasing business of the company (for example, a purchasing person), or a representative of the company. Is a person.

FIG. 2 is a diagram showing an example of documents managed by the invoice management device 1. In the purchase order shown in FIG. 2 (a), the name of the business operator of the ordering party is described. In addition, the purchase order describes the total amount (that is, the order amount) of the amount of each product including the number of products to be ordered, the unit price of the product, and the consumption tax. The order amount may be an amount calculated by the ordering business operator, or may be an amount calculated based on the unit price of each product published by the ordering business operator. The invoice management device 1 registers and manages the information described in such a purchase order in the order information database.

The invoice shown in FIG. 2B describes the name, address, and contact information of the business operator (claimer) who issued the invoice. In addition, the invoice describes the total amount (that is, the invoiced amount) of the amount of each product including the number of purchased products, the unit price of the purchased products, and the consumption tax. The invoice management device 1 registers and manages the information described in such an invoice in the billing information database.

The accountant processes the invoice based on the invoice issued. Specifically, first, the purchaser uploads the order data of the purchase order showing the contents of the ordered order and the billing data of the received invoice to the invoice management device 1, and the order data and the billing data are obtained. Is registered in the invoice management device 1. Then, the accounting staff uses the order amount included in the order data (the amount included in the voucher data) to confirm whether or not the invoice amount included in the invoice data is appropriate, and the invoice amount is appropriate. Perform the procedure to pay the billed price (billed amount) in case.

By the way, there are cases where the ordered amount and the billed amount do not completely match even though the ordered amount and the billed amount are correct. For example, if the order amount is not rounded and the billing amount is rounded, the order amount and the billing amount do not match. In such a case, the accountant needs to determine whether the difference between the ordered amount and the invoiced amount is within an acceptable range. However, the work of determining whether or not the difference between the order amount and the invoice amount is within an acceptable range has been a heavy burden for the accounting staff who processes a large number of invoices.

Therefore, in the invoice management device 1, when there is an amount difference between the order amount and the invoice amount, the amount difference is less than a predetermined threshold value and the amount difference is equal to or more than a predetermined threshold value. , Output different result information about the invoice allowance. "There is a difference in amount" means that the order amount and the invoice amount do not match. The threshold value is the maximum value allowed as the difference between the order amount and the invoice amount in the company that uses the invoice management device 1 for accounting processing. The threshold is, for example, the maximum value of the amount difference that can occur due to the rounding of the consumption tax when the billing amount is calculated. With the invoice management device 1 configured in this way, the accounting staff can easily grasp whether or not the invoice amount having an amount difference from the order amount is within an acceptable range. As a result, the invoice management device 1 can reduce the burden on the accounting staff to process the invoice.

[Functional configuration and operation of invoice management device 1]
FIG. 3 is a diagram showing a functional configuration of the invoice management device 1. The invoice management device 1 includes a display unit 11, a communication unit 12, a storage unit 13, and a control unit 14. The control unit 14 includes an acquisition unit 141, a character string specifying unit 142, a calculation unit 143, and an output unit 144.

The display unit 11 is a display for displaying information. The display unit 11 displays information based on the instruction of the output unit 144.

The communication unit 12 is a communication interface for connecting to a network (for example, an intranet or the Internet), and provides a communication controller for receiving data from the reading device 2 and transmitting / receiving data to / from another computer. Have. Other computers include, for example, a non-illustrated claimant terminal used by the claimant and a non-illustrated claimant terminal used by the claimant. The claimant is the company or person who received the invoice, and the claimant terminal is, for example, a computer used by the accountant or purchaser of the company that received the invoice (that is, the company that issued the purchase order). Is. The communication unit 12 receives the data in response to the data transmitted by the reading device 2 or another computer, or transmits information based on the instruction of the output unit 144.

The storage unit 13 has a storage medium such as a ROM (Read Only Memory), a RAM (Random Access Memory), and a hard disk. The storage unit 13 stores a program executed by the control unit 14. Further, the storage unit 13 stores order data and billing data. The storage unit 13 further stores an ordering information database that manages information extracted from ordering data and a billing information database that manages information extracted from billing data.

FIG. 4 is a diagram showing an example of a database stored by the storage unit 13. In the ordering information database shown in FIG. 4A, the name of the supplier of the supplier as an example of the supplier identification information of the supplier, the order amount, and the product information (product name, amount, and quantity) of each product are associated with each other. ing. The purchase order information database may further include purchase order identification information (eg, purchase order number) for identifying the purchase order and the issue date on which the purchase order was issued.

In the billing information database shown in FIG. 4B, the name of the billing business operator as an example of the billing business operator identification information, the billing amount, and the product information (product name, amount, and quantity) of each product are associated with each other. ing. The invoice information database may further include invoice identification information (eg, invoice number) for identifying the invoice, as well as the issue date on which the invoice was issued.

In addition, the billing information database may further include purchase order identification information for identifying the purchase order corresponding to the invoice. For example, the purchaser associates the billing data with the purchase order data corresponding to the billing data and uploads it to the invoice management device 1, so that the invoice identification information of the billing data and the purchase order identification information of the order data can be obtained. It is stored in association with the billing information database. As will be described later, the invoice management device 1 may automatically specify the purchase order data corresponding to the billing data, associate the purchase order identification information of the specified order data with the billing data, and register it in the billing information database. ..

Returning to FIG. 3, the control unit 14 is, for example, a CPU (Central Processing Unit). The control unit 14 functions as an acquisition unit 141, a character string specifying unit 142, a calculation unit 143, and an output unit 144 by executing the program stored in the storage unit 13.

The acquisition unit 141 acquires billing data indicating the billing content of the invoice and ordering data that may indicate the ordering content corresponding to the billing data. The acquisition unit 141 may acquire the ordering data and the billing data from the reading device 2, or may acquire the ordering data and the billing data to be compared with each other from the demandee terminal.

The acquisition unit 141 uses information for identifying the invoice and the purchase order (for example, invoice identification information and the invoice identification information) from the demandee terminal of the accounting person who wants to confirm the suitability of the invoice containing the invoice amount different from the order amount. Purchase order identification information) may be acquired, and billing data and order data corresponding to the acquired information may be acquired. The acquisition unit 141 acquires, for example, the ordering data and the billing data stored in the storage unit 13. Further, the acquisition unit 141 may acquire order data registered in the other system from another system managed by the demandee, such as an ERP (Enterprise Resource Planning) system. The acquisition unit 141 inputs the billing data and the order data corresponding to the billing data to the calculation unit 143.

The acquisition unit 141 may specify the content of the billing data based on the character string specified by the character string specifying unit 142 described later, and may acquire the ordering data selected from a plurality of ordering data based on the specified content. Specifically, the acquisition unit 141 has the business operator name, the order amount, and the like, which are included in the billing data generated by the reading device 2 reading the invoice among the plurality of ordering data registered in the ordering information database. Alternatively, the order data including at least a part of the product information (product name, amount and quantity) of each product is acquired.

The character string specifying unit 142 specifies a plurality of character strings included in the ordering data and the billing data input from the acquisition unit 141 when the ordering data and the billing data acquired by the acquisition unit 141 are image data. .. The character string specifying unit 142 notifies the acquisition unit 141 of the specified character string. The character string specifying unit 142 identifies the character string included in the purchase order and the invoice based on the order data and the billing data, for example, by executing OCR (Optical Character Recognition) processing.

The character string specified by the character string specifying unit 142 is, for example, the business name (the business name of the supplier in the purchase order, the business name of the billing source in the invoice), the issue date, the product name of each product, and the product name of each product. It is a unit price, the number of purchases of each product, the total amount (order amount, billing amount), etc., and is a character string corresponding to the information registered in each of the ordering information database and the billing information database. The character string specifying unit 142 is equipped with, for example, an artificial intelligence engine, and uses a machine learning model constructed by deep learning the relationship between image data and a character string as teacher data to obtain a character string with high accuracy. To identify.

The character string specifying unit 142 further functions as a storage control unit for storing the ordering data and the billing data acquired by the acquisition unit 141 in the storage unit 13. Specifically, the character string specifying unit 142 issues the purchase order, the order amount described in the purchase order, the supplier business identification information for identifying the supplier business, and the purchase order based on the order data. The date is stored in the purchase order information database, and based on the billing data, the billing amount stated on the invoice, the billing source business identification information for identifying the billing business operator, and the invoice issuance date. And store it in the billing information database.

That is, when the character string specifying unit 142 specifies the character string included in the purchase order and the invoice, the character string to be registered in the ordering information database and the billing information database among the specified character strings is stored in the storage unit 13. Store in the area corresponding to the character string. The character string specifying unit 142 may store the ordering data and the billing data acquired by the acquisition unit 141 in association with each other. Specifically, the character string specifying unit 142 stores the invoice identification information of the billing data and the purchase order identification information of the purchase order data in association with the billing information database.

The calculation unit 143 calculates the amount difference, which is the difference between the billing amount included in the billing data and the ordering amount included in the ordering data. Specifically, the calculation unit 143 compares the billing amount included in the billing data for determining whether or not the billing amount is appropriate with the ordering amount included in the ordering data corresponding to the billing data. By doing so, the amount difference is calculated. The calculation unit 143 calculates the amount difference according to, for example, the acquisition unit 141 acquiring the billing data. The calculation unit 143 inputs the calculated amount difference to the output unit 144.

"Ordering data corresponding to billing data" is, for example, ordering data including the name of the billing business operator included in the billing data, the business name of the supplier matching the product name of each product, and the product name of each product. Is. The "ordering data corresponding to the billing data" may be ordering data including the quantity and the unit price that match the quantity and the unit price of the product included in the billing data. The "order data corresponding to the billing data" may be the order data corresponding to the order number described in the invoice. "Order data corresponding to billing data" is from the issue date of the purchase order to the issue date of the invoice included in the billing data among one or more order data matching the business name etc. included in the billing data. The order data may have an order period within a predetermined period threshold value. The predetermined period threshold value is a set value preset in the invoice management device 1 such as 1 month or 2 months, and may be a set value common to each business operator, or for each business operator. It may be a different setting value.

The output unit 144 outputs various information regarding billing data and ordering data. The output unit 144, for example, transmits the data registered in the database shown in FIG. 4 to the computer used by the accounting staff and displays it on the display screen so that the accounting staff can check the data. do. The output unit 144 outputs different result information regarding the admissibility of the billed amount depending on whether the amount difference between the billed amount and the ordered amount is less than the predetermined threshold value and the amount difference is equal to or more than the predetermined threshold value. do. The predetermined threshold value is an amount preset in the invoice management device 1, and is an amount in a range that can be changed by rounding, such as 1 yen, 10 yen, 100 yen, or 1,000 yen. .. The predetermined threshold value is not limited to the amount of money, but may be a ratio to the amount billed (for example, 1% or 0.1%).

Specifically, when the amount difference exists, the output unit 144 determines whether or not the amount difference is less than a predetermined threshold value, and outputs different result information according to the determination result. The output unit 144 displays, for example, the billing data to be processed by the invoice in a mode corresponding to the result information on the display screen for the accounting staff to process the invoice.

The output unit 144 may automatically execute the remittance process based on the billing data without outputting the result information when the amount difference does not exist or the amount difference is less than the threshold value. The output unit 144 executes the remittance process by, for example, transmitting billing data to the ERP system that performs the remittance process.

In the example shown in FIG. 4B, the billing amount of the billing number "777777777" has a amount difference within a predetermined threshold value, and the billing amount of the billing number "99999999" has a amount difference of not more than a predetermined threshold value. do. In this case, the output unit 144 displays a list of billing data as shown in FIG. 4B on the display screen, and the billing amount column of the billing number "777777777" and the billing amount column of the billing number "99999999". Is displayed in a different manner. In the case of the example shown in FIG. 4 (b), the invoice amount of the invoice number "777777777" in which the invoice amount and the order amount have an amount difference but the amount difference is within the allowable range is thick as acceptable information. A border is shown. The billing amount of the billing number "99999999" whose amount difference is not within the permissible range is shown as unacceptable information in white on a black background.

The output unit 144 is not limited to the example of displaying the result information on the display screen, and the result information may be printed on a printing machine (not shown), a terminal (not shown) used by the accounting staff, or a remittance process (not shown). The result information may be sent to the server.

When the output unit 144 determines that the amount difference between the ordered amount and the billed amount is less than a predetermined threshold value, the output unit 144 outputs acceptable information indicating that the amount difference is acceptable as the result information. The output unit 144 may execute the remittance processing of the billed amount instead of outputting the allowable information. Further, instead of outputting the acceptable information, the output unit 144 indicates that it is permissible that the acquisition unit 141 does not output the unacceptable information in association with the billing data after acquiring the billing data. It may be the output of.

On the other hand, when the output unit 144 determines that the amount difference between the ordered amount and the billed amount is not less than the predetermined threshold value (the amount difference is equal to or more than the predetermined threshold value), the output unit 144 indicates that the amount difference is unacceptable. Impossible information is output as result information. In this way, the invoice management device 1 outputs acceptable information or unacceptable information, so that the accounting staff determines whether or not the difference between the ordered amount and the invoiced amount is within an acceptable range. You can save the trouble of doing it.

The output unit 144 may output acceptable information when it is determined that the difference in the amount of money is caused by the difference in the fraction processing of the predetermined tax. The prescribed tax is a tax levied on the purchase of goods or services, such as consumption tax or value-added tax. The rounding of a predetermined tax (hereinafter referred to as "consumption tax") is, for example, rounding up, rounding down, or rounding off. In the output unit 144, for example, the amount difference is less than a predetermined threshold value, and the order of the range in which the consumption tax can be rounded (for example, the three digits of one, ten, and one hundred) is "0". If, the acceptable information is output. The range in which the consumption tax can be rounded is preset, for example, by an accountant.

On the other hand, the output unit 144 may output unacceptable information when it is determined that the difference in the amount of money is not caused by the difference in the rounding of the consumption tax. The output unit 144 is, for example, when the amount difference is less than a predetermined threshold value and at least one digit is a numerical value other than "0" in the range in which the consumption tax can be rounded in the billed amount. , Output unacceptable information. Invoice management device 1 By operating in this way, if it is considered that the difference in the amount of money is caused by the difference in the rounding of the consumption tax, it is considered that the difference in the amount of money is within an acceptable range. The person in charge can judge. The output unit 144 does not output the result information when it is considered that the difference in the amount of money is caused by the difference in the rounding of the consumption tax, and it is considered that the difference in the amount of money is caused by the difference in the rounding of the consumption tax. If not, unacceptable information may be output.

In order to determine whether or not the amount difference is caused by the difference in the rounding, the output unit 144 calculates a plurality of billing amounts in which the amount difference from the order amount is different from the consumption tax. It may be determined whether or not it matches any of the calculation results calculated by the method. Specifically, first, the calculation unit 143 calculates a plurality of tax amounts (for example, consumption tax amount) by a plurality of calculation methods having different rounding of the consumption tax based on the amount other than the consumption tax included in the billing data. .. The amount other than the consumption tax included in the billing data is, for example, the amount of each product excluding the consumption tax.

The calculation unit 143 calculates, for example, the consumption tax amount when the total amount of each product is multiplied by the consumption tax rate, the consumption tax amount when the fraction is rounded up, the consumption tax amount when the fraction is rounded down, or the consumption tax amount when the fraction is rounded off. calculate. The calculation unit 143 may calculate the total amount of the amount obtained by multiplying the amount of each product by the consumption tax rate, rounded up, rounded down, or rounded off, as the consumption tax amount.

Then, when the total amount obtained by adding any of the plurality of consumption tax amounts calculated by the calculation unit 143 to the amount other than the consumption tax matches the billed amount, the output unit 144 causes the difference in the amount to be due to the difference in rounding. It is determined that it has occurred and the allowable information is output. On the other hand, in the output unit 144, if the total amount obtained by adding each of the plurality of consumption tax amounts to the amount other than the consumption tax does not match the billed amount, the amount difference is not caused by the difference in rounding. Is determined and unacceptable information is output. By operating the invoice management device 1 in this way, the accounting staff determines that the billing data is incorrect when the difference in the amount is caused not by the error of the billing amount but by the difference in the rounding process. Can be prevented.

The output unit 144 further outputs the processing content information indicating the content of the fraction processing used by the calculation unit 143 when the total amount obtained by adding the consumption tax amount calculated by the calculation unit 143 to the amount other than the consumption tax matches the billed amount. You may. The processing content information is, for example, information indicating a calculation formula or a calculation method (for example, rounding up, rounding down, or rounding). The output unit 144 may output the processing content information in association with each of the plurality of consumption tax amounts calculated by the calculation unit 143 or the plurality of total amounts obtained by adding the plurality of consumption tax amounts to the amounts other than the consumption tax.

By doing so, the invoice management device 1 can make the accounting staff understand what kind of rounding is used in calculating the invoice amount. In addition, when outputting the allowable information, the output unit 144 may output the processing content information indicating the content of the rounding of the consumption tax used for calculating the total amount matching the billed amount.

[Operation flow of invoice management device 1]
FIG. 5 is a flowchart showing the operation flow of the invoice management device 1. The flowchart shown in FIG. 5 starts when the acquisition unit 141 acquires the billing data (S11). The character string specifying unit 142 identifies a plurality of character strings included in the invoice based on the billing data acquired by the acquisition unit 141 (S12).

Subsequently, the acquisition unit 141 acquires the order data corresponding to the billing data (S13). The acquisition unit 141 acquires, for example, order data including a character string that matches a plurality of character strings included in an invoice among a plurality of order data registered in the order information database.

The calculation unit 143 calculates the amount difference between the billing amount included in the billing data and the ordering amount included in the ordering data corresponding to the billing data (S14). The output unit 144 determines whether or not there is a difference in the amount of money (S15). When it is determined that there is no difference in the amount of money (NO in S15), the output unit 144 ends the process. On the other hand, when it is determined that the amount difference exists (YES in S15), the output unit 144 determines whether or not the amount difference is less than a predetermined threshold value (S16).

When the output unit 144 determines that the amount difference is less than a predetermined threshold value (YES in S16), the output unit 144 outputs acceptable information (S17). On the other hand, when it is determined that the amount difference is not less than the predetermined threshold value (the amount difference is equal to or more than the predetermined threshold value) (NO in S16), the output unit 144 outputs unacceptable information (S18).

[First modification]
In the above description, the calculation unit 143 calculated a plurality of consumption tax amounts by a plurality of calculation methods having different rounding of the consumption tax based on the amounts other than the consumption tax included in the billing data. , The consumption tax amount may be calculated by a highly probable calculation method used by the business operator that issued the invoice. In order to do so, when the output unit 144 is the case where the total amount obtained by adding any one of the plurality of consumption tax amounts calculated by the calculation unit 143 using the plurality of calculation methods to the amount other than the consumption tax matches the billed amount. , The calculation method in which the total amount matches the invoice amount is stored in the storage unit 13 in association with the business operator that issued the invoice.

After that, when the acquisition unit 141 acquires new billing data and the difference between the billing amount calculated by the calculation unit 143 and the order amount is equal to or greater than the threshold value, the calculation unit 143 issues an invoice corresponding to the billing data. The calculation method stored in the storage unit 13 in association with the invoice is read out. The calculation unit 143 calculates the consumption tax amount by performing rounding processing corresponding to the read calculation method. By operating the calculation unit 143 in this way, the probability that the consumption tax amount will be calculated by performing the highly probable rounding used when the invoice was created increases, so the cause of the amount difference is the fraction. The accuracy of determining whether or not it is due to processing is improved.

[Second modification]
In the above description, the case where the ordering data corresponding to the billing data is specified as one is illustrated, but there may be a plurality of ordering data that may correspond to the billing data. In such a situation, when the output unit 144 determines that the amount difference between the billed amount and the order amount is equal to or greater than the threshold value, the output unit 144 is different from the first order data used by the calculation unit 143 to calculate the amount difference. From among the plurality of other order data, information regarding one or more second order data including the order amount whose amount difference from the invoice amount is less than the threshold value may be further output. By operating the output unit 144 in this way, when there is a plurality of ordering data that may correspond to the billing data, the accounting staff can grasp the ordering data corresponding to the billing data.

When the amount difference between the billing amount and the ordering amount is equal to or greater than the threshold value, the output unit 144 outputs one or more second ordering data having a relatively high probability of corresponding to the billing data among the plurality of other ordering data. You may. The output unit 144 is, for example, a business name and a product name included in the billing data from among a plurality of other order data different from the first order data used by the calculation unit 143 to calculate the amount difference. , Outputs information about one or more second order data having a relatively large degree of matching at least one of the unit price and the number of purchases.

The output unit 144 associates with one or more second order data, and includes at least one of the business name, product name, unit price or number of purchases included in the billing data, and the business name included in the order data. A reliability number indicating the degree of matching with at least one of the product name, the unit price, and the number of purchases may be output. The reliability is, for example, the higher the number of matches between a plurality of data items included in the billing data (for example, business name, product name, quantity, unit price, etc.) and a plurality of data items included in the ordering data. The information indicates that the smaller the number of matches, the smaller the value.

In addition, different weighting may be set for each data item. For example, a high weight may be set for the business name and the product name, and a low weight may be set for the number of products and the unit price. Further, as for the reliability, for example, the closer the order amount is to the invoiced amount, the higher the value, and the farther the order amount is from the invoiced amount, the smaller the value. By outputting the reliability frequency by the output unit 144, the accounting staff can easily grasp whether or not the output second order data corresponds to the billing data.

Further, when the output unit 144 determines that the amount difference between the billed amount and the order amount is equal to or greater than the threshold value, the acquisition unit 141 is different from the first order data used by the calculation unit 143 to calculate the amount difference. The ordering data of the above may be acquired, and the calculation unit 143 may calculate the amount difference which is the difference between the billing amount included in the billing data and the ordering amount included in the other ordering data. By repeating such processing by the acquisition unit 141 and the calculation unit 143, the probability that the acquisition unit 141 can correctly identify the order data corresponding to the billing data is improved.

[Third modification example]
In the above description, the output unit 144 outputs different result information regarding whether or not the billing amount is acceptable depending on whether the amount difference is less than the predetermined threshold value or the amount difference is greater than or equal to the threshold value. 144 may output different result information depending on whether the amount difference exists or does not exist when the amount difference is less than a predetermined threshold value. The output unit 144, for example, displays the billing data on the display screen when the amount difference is less than a predetermined threshold value and the amount difference exists, and when the amount difference is less than the predetermined threshold value and the amount difference exists. It is displayed in different modes (for example, different colors) depending on whether or not the amount difference is equal to or greater than a predetermined threshold value. The output unit 144 has a case where the amount difference is less than a predetermined threshold value and the amount difference exists, a case where the amount difference is less than the predetermined threshold value and the amount difference does not exist, and a case where the amount difference is equal to or more than the predetermined threshold value. A message having different contents may be sent as result information to the terminal used by the accounting staff. By configuring the output unit 144 in this way, the accounting staff can easily grasp whether or not there is a difference between the ordered amount and the billed amount, and the amount difference from the ordered amount is large. It is possible to easily grasp whether or not a certain billing amount is within an acceptable range.

[Fourth variant]
In the above description, the case where there is one voucher data (ordering data) corresponding to the billing data is illustrated, but there may be a plurality of voucher data which may correspond to the billing data. In such a situation, the output unit 144 differs in the result information regarding the admissibility of the billed amount depending on the determination result of whether or not the difference between the amount of money included in each voucher data and the billed amount is less than the threshold value. May be output.

Specifically, first, the acquisition unit 141 acquires a plurality of voucher data of different types. The plurality of voucher data are, for example, order data, approval data indicating the content of approval regarding the order, delivery data indicating the content of delivery of the delivered product, and acceptance data indicating the content of inspection for the delivery. The calculation unit 143 calculates the amount difference, which is the difference between the billed amount and the amount included in the voucher data, for each voucher data acquired by the acquisition unit 141.

Then, the output unit 144 requests a case where each of the plurality of amount differences calculated by the calculation unit 143 is less than a predetermined threshold value and a case where at least one of the plurality of amount difference is equal to or more than a predetermined threshold value. Output different result information about the allowance of the amount. The output unit 144 displays, for example, the billing data and a plurality of voucher data in association with each other on the display screen, and displays each voucher data in the case where the amount difference is less than a predetermined threshold value and the amount difference exists. Is less than a predetermined threshold value and the amount difference does not exist, and the case where the amount difference is greater than or equal to the predetermined threshold value is displayed in different modes. By operating the output unit 144 in this way, the accounting staff can easily confirm whether or not each amount difference is within an acceptable range, and also responds to an amount difference that is not within an acceptable range. It is possible to easily grasp which voucher data is used.

The output unit 144 determines whether or not the difference between the billed amount and the billed amount is due to the predetermined rounding of the tax, depending on whether or not the billed amount and the amount included in each of the plurality of voucher data match. It may be determined. Specifically, first, the acquisition unit 141 acquires the first voucher data and the second voucher data, which is different from the first voucher data, as voucher data. The first voucher data includes data including order contents or approval contents related to the order, and is, for example, either order data or approval data. The second voucher data is data including delivery contents or acceptance contents for delivery, and is, for example, either delivery data or acceptance inspection data.

Then, when the billing amount included in the billing data, the first amount included in the first voucher data, and the second amount included in the second voucher data do not match, the output unit 144 sets the billing amount and the first. It is determined whether or not the first amount difference, which is the difference from the amount, and the second amount difference, which is the difference between the billed amount and the second amount, are due to the fraction processing of the predetermined tax. The output unit 144, for example, when the billed amount, the first amount, and the second amount do not match, the first amount difference and the first amount difference when each of the first amount difference and the second amount difference is less than a predetermined threshold value. And, when at least one of the second amount difference is equal to or more than a predetermined threshold value, different result information is output regarding the admissibility of the billed amount. By operating the output unit 144 in this way, the accounting staff can easily check whether or not the respective amounts (billed amount, first amount, and second amount) match, and each of them. It can be easily confirmed whether or not the amount difference (first amount difference and second amount difference) is within an acceptable range.

The output unit 144 includes a plurality of data items included in the billing data (for example, the name of the business operator who issued the invoice, the product name, the number of products, the billing amount, etc.) and a plurality of data included in the acceptance inspection data. Whether or not the invoice is appropriate depending on whether or not (for example, the name of the business that presents the invoice, the product name, quantity, and amount of the invoiced product) match each other. Different result information may be output. The output unit 144 may, for example, display the billing data on the display screen when the plurality of data items included in the billing data and the plurality of data included in the acceptance data match, respectively, and when the billing data is included in the billing data. In the case where at least a part of the data items do not match in the data item of the above and the plurality of data included in the acceptance data, the data items are displayed in different modes.

[Effect of invoice management device 1]
As described above, in the invoice management device 1, when there is an amount difference between the order amount and the invoice amount, the amount difference is less than the predetermined threshold value and the amount difference is equal to or more than the predetermined threshold value. Depending on the case, different result information is output regarding the admissibility of the billing amount. By doing so, the accounting staff can grasp whether or not the invoiced amount having a difference from the ordered amount is within an acceptable range. As a result, the accounting staff can save the trouble of determining whether or not the difference between the ordered amount and the billed amount is within an acceptable range. As a result, the invoice management device 1 can reduce the burden on the accounting staff to process the invoice.

Although the present invention has been described above using the embodiments, the technical scope of the present invention is not limited to the scope described in the above embodiments, and various modifications and changes can be made within the scope of the gist. be. For example, all or part of the device can be functionally or physically distributed / integrated in any unit. Also included in the embodiments of the present invention are new embodiments resulting from any combination of the plurality of embodiments. The effect of the new embodiment produced by the combination has the effect of the original embodiment together.

1 Invoice management device 11 Display unit 12 Communication unit 13 Storage unit 14 Control unit 141 Acquisition unit 142 Character string identification unit 143 Calculation unit 144 Output unit 2 Reading device

Claims (13)

An invoice management device that manages invoices
An acquisition unit that acquires billing data indicating the billing content of the invoice and voucher data indicating the transaction content corresponding to the billing data.
A calculation unit that calculates the amount difference, which is the difference between the billing amount included in the billing data and the amount included in the voucher data.
An output unit that outputs different result information regarding the admissibility of the billed amount depending on whether the amount difference is less than a predetermined threshold value or the amount difference is greater than or equal to the threshold value.
Invoice management device with. When the amount difference is less than the threshold value, the output unit outputs acceptable information indicating that the amount difference is acceptable as the result information, and when the amount difference is equal to or more than the threshold value, the output unit outputs the allowable information. The unacceptable information indicating that the amount difference is unacceptable is output as the result information.
The invoice management device according to claim 1. When the output unit determines that the amount difference is caused by the difference in the predetermined tax rounding, the output unit outputs the allowable information, and the amount difference is caused by the difference in the rounding. If it is determined that there is no such information, the unacceptable information is output.
The invoice management device according to claim 2. The calculation unit calculates a plurality of tax amounts by a plurality of methods in which the fraction processing of the predetermined tax is different, based on the amount other than the predetermined tax included in the billing data.
The output unit outputs the permissible information when the total amount obtained by adding any one of the plurality of tax amounts calculated by the calculation unit to the amount other than the predetermined tax amount matches the invoiced amount. If the total amount does not match the billed amount, the unacceptable information is output.
The invoice management device according to claim 2 or 3. The output unit outputs information indicating the content of the rounding process used by the calculation unit when the total amount matches the billed amount.
The invoice management device according to claim 4. When the amount difference is equal to or greater than the threshold value, the output unit sets the billed amount from among a plurality of other voucher data different from the first voucher data used by the calculation unit to calculate the amount difference. Outputs information about one or more second voucher data including the amount of money for which the amount difference is less than the threshold value.
The invoice management device according to any one of claims 1 to 5. When the amount difference is equal to or greater than the threshold value, the output unit corresponds to the billing data among a plurality of other voucher data different from the first voucher data used by the calculation unit to calculate the amount difference. Output information about one or more second voucher data with a relatively high probability of
The invoice management device according to any one of claims 1 to 5. The output unit is associated with at least one of the business name, product name, unit price or number of purchases included in the billing data in association with the one or more second voucher data, and the business included in the voucher data. Outputs a reliability number that indicates the degree to which at least one of a person's name, a product name, a unit price, or the number of purchases matches.
The invoice management device according to claim 6 or 7. When the amount difference is equal to or greater than the threshold value, the acquisition unit acquires other voucher data different from the first voucher data used by the calculation unit to calculate the amount difference.
The calculation unit calculates the amount difference, which is the difference between the billing amount included in the billing data and the amount included in the other voucher data.
The invoice management device according to any one of claims 1 to 8. The acquisition unit acquires a plurality of the voucher data of different types, and obtains the voucher data.
The calculation unit calculates the amount difference, which is the difference between the billed amount and the amount included in the voucher data, for each voucher data.
The output unit determines the billed amount depending on whether each of the plurality of amount differences calculated by the calculation unit is less than the threshold value or when at least one of the plurality of amount difference is equal to or more than the threshold value. Output different result information about the acceptability of
The invoice management device according to any one of claims 1 to 9. The acquisition unit acquires the first voucher data including the order contents or the approval contents regarding the order, and the second voucher data including the delivery contents or the acceptance inspection contents for the delivery as the voucher data.
When the billing amount included in the billing data, the first amount included in the first voucher data, and the second amount included in the second voucher data do not match, the output unit may match the billing amount. It is determined whether or not the first amount difference, which is the difference from the first amount, and the second amount difference, which is the difference between the billed amount and the second amount, are due to the fraction processing of the predetermined tax.
The invoice management device according to any one of claims 1 to 10. Performed by the computer that manages the invoice,
A step of acquiring billing data indicating the billing content of the invoice and voucher data indicating the transaction content corresponding to the billing data, and
A step of calculating the amount difference, which is the difference between the billing amount included in the billing data and the amount included in the voucher data, and
A step of outputting different result information regarding the admissibility of the billed amount depending on whether the amount difference is less than a predetermined threshold value or the amount difference is greater than or equal to the threshold value.
Invoice management method with. The computer that manages the invoice,
An acquisition unit that acquires billing data indicating the billing content of the invoice and voucher data indicating the transaction content corresponding to the billing data.
A calculation unit that calculates the amount difference, which is the difference between the billing amount included in the billing data and the amount included in the voucher data, and when the amount difference is less than a predetermined threshold value, the amount difference is the threshold value. An output unit that outputs different result information regarding the admissibility of the billed amount depending on the above cases.
A program to function as.

Images