WO2022029834A1 - Data processing device, data processing method, and program - Google Patents
Data processing device, data processing method, and program Download PDFInfo
- Publication number
- WO2022029834A1 WO2022029834A1 PCT/JP2020/029657 JP2020029657W WO2022029834A1 WO 2022029834 A1 WO2022029834 A1 WO 2022029834A1 JP 2020029657 W JP2020029657 W JP 2020029657W WO 2022029834 A1 WO2022029834 A1 WO 2022029834A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- amount
- total
- invoice
- data
- data processing
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/14—Payment architectures specially adapted for billing systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
Definitions
- the present invention relates to a data processing device, a data processing method and a program for processing an invoice.
- Patent Document 1 discloses a technique for correcting a misrecognized character string based on a misrecognition pattern such as a difference between an old character and a new character of a Chinese character and a difference in an okurigana of a Chinese character (for example, Patent Document 1). See 1).
- the present invention has been made in view of these points, and an object thereof is to improve the accuracy of the amount of money registered in the computer that manages the invoice.
- the data processing device of the first aspect of the present invention corresponds to a data acquisition unit for acquiring invoice data, a total invoice amount included in the invoice data, and a plurality of products included in the invoice data. Warning when the comparison result by the comparison unit does not match the comparison unit that compares the total billing amount and the total amount of the plurality of product amounts with the amount specification unit that specifies the plurality of product amounts. It has an output unit that outputs information.
- the invoice data includes a first invoice data in which the total invoice amount is described and a second invoice data in which the details of the plurality of products are described, and the comparison unit includes the first invoice.
- the plurality of products included in the second invoice data including the total invoice amount included in the invoice data and the invoice number associated with the invoice number described in the first invoice data. It may be compared with the total amount of the amount.
- the comparison unit may calculate the total amount by adding up the plurality of product amounts described in the direction in which the character strings indicating the names of the plurality of products are arranged in the invoice data.
- the invoice data includes a tax-excluded amount and a tax amount associated with each of the plurality of products, and the comparison unit adds up the tax-excluded amount and the tax amount corresponding to each of the plurality of products. Therefore, the total amount may be calculated.
- the invoice data includes a tax-excluded amount and a tax amount associated with each of the plurality of products
- the comparison unit is a total of the plurality of tax-excluded amounts corresponding to the plurality of products.
- the output is obtained by comparing each of the first total amount and the second total amount, which is the total amount of the plurality of tax-excluded amounts corresponding to the plurality of products and the plurality of the tax amounts, with the total billed amount.
- the unit may output the warning information when both the comparison result between the first total amount and the total billing amount and the comparison result between the second total amount and the total billing amount do not match.
- the output unit may use the first total amount or the second total amount. Information indicating which of the amounts matches the total billed amount may be output.
- the output unit may output information indicating which of the plurality of product prices and the total billed amount may be erroneous. ..
- the comparison unit determines the amount of the plurality of products based on the result of comparing the amount based on the result of multiplying the unit price and the quantity of each of the plurality of products included in the invoice data with the amount of the product. It is determined whether or not there is an error in any of the products, and when the comparison unit determines that there is an error in any of the plurality of product prices, the output unit has an error in any of the plurality of product prices. When the comparison unit determines that there is no error in any of the plurality of product prices, the information indicating that there is a high probability that the total billing amount is incorrect is output. You may.
- the output unit may output the total amount as a candidate for a correction amount of the total billing amount.
- the output unit may have an error in one or more of the plurality of product prices.
- the correction amount candidate may be output.
- the data processing method includes a step in which a computer acquires invoice data, a total invoice amount included in the invoice data, and a plurality of products included in the invoice data.
- the program of the third aspect of the present invention corresponds to a step of acquiring invoice data to a computer, a total invoice amount included in the invoice data, and a plurality of products included in the invoice data.
- FIG. 1 is a diagram for explaining the configuration of the data processing system S.
- the data processing system S is a system for processing the invoice data obtained by reading the invoice.
- the invoice data is data created by reading the invoice, and is data including an image showing the contents of the invoice or a plurality of text data corresponding to a plurality of character strings included in the invoice.
- the data processing system S includes a data processing device 1, an accounting terminal 2, and an employee terminal 3.
- the data processing device 1, the accounting terminal 2, and the employee terminal 3 transmit and receive data via the network N.
- the network N includes, for example, the Internet or an intranet.
- the data processing device 1 is a computer that manages various invoice data.
- the data processing device 1 may acquire a file containing the image data of the invoice from the accounting terminal 2 or the employee terminal 3 and create the invoice data based on the character string specified in the acquired image data.
- the file containing the invoice data may be acquired from the accounting terminal 2 or the employee terminal 3.
- the data processing device 1 manages invoice data indicating the contents of the invoice received by the billing company.
- the data processing device 1 stores an invoice database including the contents of invoices received by the invoiced company in the past and a plurality of past invoice data indicating the departments related to each invoice, and the accounting terminal 2
- the contents of the stored invoice data are provided to the accounting terminal 2 in response to the request from.
- the data processing device 1 may recognize the character string included in the invoice data and output the data registered in the database of the system that manages the invoice data (for example, the core system for accounting).
- the data processing device 1 uses artificial intelligence, for example, to recognize the character string contained in the image data of the invoice and create the invoice data, but the character string may not be recognized correctly. There may also be typographical errors in the invoice. If a misrecognized or miswritten character string is registered in the database, the accounting process will be hindered.
- the data processing device 1 compares the total invoice amount included in the invoice data with the plurality of product amounts corresponding to the plurality of products included in the invoice data so as not to interfere with the accounting processing. By doing so, it is determined whether or not there is an erroneously recognized or erroneously written character string.
- the data processing device 1 calls attention to the accounting staff by outputting warning information when it detects that there is an erroneously recognized character string or an erroneously written character string.
- the data processing device 1 may output a character string candidate presumed to be correct.
- the accounting terminal 2 is a computer used by an employee (for example, an accounting person) who uses the data processing device 1 in the billing company that received the invoice.
- the accounting terminal 2 transmits and receives various data to and from the data processing device 1 via, for example, an intranet.
- the accounting terminal 2 transmits, for example, the image data of the invoice read by the accounting person with a scanner to the data processing device 1. Further, the accounting terminal 2 accesses the invoice database stored in the data processing device 1 according to the instruction of the accounting person, and displays the invoice data specified by the accounting person.
- FIG. 1 shows one accounting terminal 2, a plurality of accounting terminals 2 may access the data processing device 1.
- the employee terminal 3 is a computer used by an employee of the billing company that ordered the product or the like from the billing company.
- the employee terminal 3 transmits the image data of the invoice to the data processing device 1 according to the operation of the employee.
- FIG. 2 and 3 are diagrams showing an example of an invoice.
- FIG. 2 shows an example of the invoice portion of the invoice
- FIG. 3 shows an example of the detail portion of the invoice.
- the main points of the description are described in the book, for example, the total billing amount of the amounts of the plurality of products described in the description is described.
- the "purchase amount” which is the total amount of tax-excluded amounts of the plurality of products shown in the specification shown in FIG. 3
- the “consumption tax amount” which is the total amount of the consumption tax amounts of the plurality of products.
- the total billed amount which is the sum of the "purchased amount” and the "consumption tax amount" is described as the "billed amount”.
- the delivery date, product name, quantity, unit price, product amount, and tax amount of each of the plurality of products are described.
- a subtotal of the product amount and a subtotal of the tax amount of a plurality of products are also described, and the total amount, which is the total amount of these items, is described as the "billed amount”.
- FIG. 4 is a diagram showing an example of invoice data created by reading the invoice invoice shown in FIG.
- the data processing device 1 causes, for example, the accounting terminal 2 to display the invoice data shown in FIG.
- the total invoice amount is read as 89,000 yen, and a warning "There is a possibility of 88,000 yen" is displayed.
- the data processing device 1 compares, for example, the total invoice amount shown in FIG. 4 with the total value of a plurality of product amounts in the invoice data obtained by reading the invoice shown in FIG. 3, and warns when these do not match. Is displayed on the accounting terminal 2. At this time, as a candidate for the correct total billing amount, the total value of the plurality of product amounts described in the statement is displayed on the accounting terminal 2 as a correction amount candidate.
- the data processing device 1 displays a warning based on the result of comparing the total amount of the tax-excluded amount and the tax amount with the total billed amount, or a correction amount candidate. May be displayed. By displaying the warning on the accounting terminal 2 in this way, the data processing device 1 can recognize that there is a problem with the invoice data. Further, the data processing device 1 displays the correction amount candidate, so that the accounting staff can easily correct the correction amount.
- FIG. 5 is a diagram showing an example of invoice data created by reading the details of the invoice shown in FIG.
- the "billed amount” is erroneously read as 98,000 yen, and a warning is displayed.
- the amount described as the "billed amount” is 88,000 yen, which is the total amount of the total amount of 80,000 yen for a plurality of product amounts and the total amount of 8,000 yen for the tax amount. Since we have not done so, we judge that there is a possibility that the amount stated as "billed amount” is incorrect and output a warning.
- the data processing device 1 may output a warning based on the fact that it does not match the total billing amount stated in the book.
- the data processing device 1 when the total invoice amount included in the invoice data and the total amount of the plurality of product amounts corresponding to the plurality of products included in the invoice data do not match. Since it outputs a warning, the accountant recognizes that the amount in the invoice has been read incorrectly. As a result, it is possible to prevent incorrect amounts from being registered in the database.
- the configuration and operation of the data processing device 1 will be described in detail.
- FIG. 6 is a diagram showing the configuration of the data processing device 1.
- the data processing device 1 has a communication unit 11, a storage unit 12, and a control unit 13.
- the control unit 13 includes a data acquisition unit 131, a character string specifying unit 132, an amount specifying unit 133, a comparison unit 134, and an output unit 135.
- the communication unit 11 has a communication controller for transmitting and receiving various data to and from the accounting terminal 2 and the employee terminal 3 via the network N.
- the communication unit 11 inputs data received from, for example, the accounting terminal 2 to the data acquisition unit 131. Further, the communication unit 11 transmits the data input from the output unit 135 to, for example, the accounting terminal 2.
- the storage unit 12 has a storage medium such as a ROM (ReadOnlyMemory), a RAM (RandomAccessMemory), and a hard disk.
- the storage unit 12 stores a program executed by the control unit 13.
- the storage unit 12 also functions as a work memory for temporarily storing the image data of the invoice received via the communication unit 11.
- the storage unit 12 may store the invoice data of the past invoice.
- the control unit 13 has, for example, a CPU (Central Processing Unit).
- the control unit 13 functions as a data acquisition unit 131, a character string specifying unit 132, an amount specifying unit 133, a comparison unit 134, and an output unit 135 by executing a program stored in the storage unit 12.
- a CPU Central Processing Unit
- the data acquisition unit 131 acquires various data via the communication unit 11.
- the data acquisition unit 131 acquires invoice data transmitted from, for example, the accounting terminal 2 or 3.
- the data acquisition unit 131 inputs the image data to the character string specifying unit 132.
- the data acquisition unit 131 may store the image data of the invoice in the storage unit 12.
- the data acquisition unit 131 inputs the invoice data to the amount specifying unit 133.
- the data acquisition unit 131 may acquire data indicating the operation content in the accounting terminal 2.
- the instruction data is, for example, selection data indicating a candidate character string selected by the accounting staff of the accounting terminal 2 from a plurality of candidate character strings.
- the data acquisition unit 131 notifies the amount identification unit 133 of the acquired selection data.
- the character string specifying unit 132 specifies a plurality of character strings included in the image data of the invoice.
- the character string specifying unit 132 specifies a plurality of character strings by recognizing characters using, for example, OCR (Optical Character Recognition).
- OCR Optical Character Recognition
- the character string specifying unit 132 learns a combination of an image data in which a character is read and a character string as teacher data, and outputs a plurality of character strings corresponding to the input image data (that is, a machine learning model (that is,).
- a machine learning model that is,
- the character string specifying unit 132 notifies the amount specifying unit 133 of the specified character string.
- the character string identification unit When the invoice is composed of an invoice and a statement, and the image data of the invoice includes the invoice data (first invoice data) and the statement data (second invoice data), the character string identification unit.
- the 132 may further determine whether the read image data of the invoice is the data of the book or the data of the details, and may notify the amount specifying unit 133 of the determination result. For example, when the character string specifying unit 132 cannot specify the character strings of a plurality of product names, it determines that the image data of the read invoice is the data of the book, and specifies the character strings of the plurality of product names. If it can be done, it is determined that the image data of the read invoice is the data of the details.
- the character string specifying unit 132 inputs the invoice data read into the model machine-learned using the format of the book and the format of the details as teacher data in advance, and the read invoice is based on the result output from the model. It may be determined whether it is a reference or a detail.
- the character string specifying unit 132 includes the first billing data and the second billing data corresponding to one bill among the plurality of first billing data and the plurality of second billing data. May be specified.
- the character string specifying unit 132 may refer to, for example, the first invoice data and the first invoice data. 1
- the second invoice data including the invoice number corresponding to the invoice number described in the invoice data may be determined to be the data of the reference and the data of the details included in one invoice data. ..
- the second invoice data includes the same invoice number as the invoice number S1000226 included in the first invoice data, and the first invoice data shown in FIG. 2 is , It is determined that the second invoice data is a reference shown in FIG.
- the character string specifying unit 132 notifies the amount specifying unit 133 of the type information indicating which invoice data corresponds to the invoice and which invoice data corresponds to the details.
- the amount specifying unit 133 specifies the total invoice amount included in the invoice data and the plurality of product amounts corresponding to the plurality of products included in the invoice data.
- the amount specifying unit 133 specifies, for example, that the amount included in the book is the total billed amount based on the type information notified from the character string specifying unit 132, and in the same column or the same column as a plurality of product names in the statement. Identify that the amounts listed on the same line are multiple product amounts.
- the amount identification unit 133 will use the location in the invoice where the amount is stated, or the text next to the amount. It may be determined whether it is the total invoice amount or the product amount based on at least one of the contents. The amount specifying unit 133 determines, for example, that the amount written at the bottom of the invoice is the total invoice amount, and that the amount written in the same column or row as the product name is the product amount. do.
- the comparison unit 134 compares the total billed amount specified by the amount specifying unit 133 with the total amount of the plurality of product amounts.
- the comparison unit 134 is included in, for example, the total invoice amount included in the first invoice data corresponding to the invoice shown in FIG. 2 and the second invoice data corresponding to the details shown in FIG. Compare with the total amount of multiple product prices.
- the comparison unit 134 adds up the total amount of the plurality of products described in the direction (vertical direction in the example shown in FIG. 3) in which the character strings indicating the names of the plurality of products are arranged in the invoice data. Is calculated.
- the comparison unit 134 notifies the output unit 135 of the comparison result.
- the comparison unit 134 compares the total invoice amount described in one item with the total amount of the plurality of product amounts. You may.
- the output unit 135 outputs warning information when the comparison results of the comparison unit 134 do not match.
- the output unit 135 may output the difference between the total billed amount and the total amount of the plurality of product amounts when the comparison results do not match. If the output unit 135 determines that the total billing amount may be incorrect, the output unit 135 may output the total amount as a candidate for the correction amount of the total billing amount.
- the output unit 135 causes the accounting terminal 2 to display the warning information, the difference amount, or the correction amount candidate by, for example, transmitting the warning information or the correction amount candidate to the accounting terminal 2, but the output unit 135 is connected to the data processing device 1.
- the warning information, the difference or the correction amount candidate may be displayed on the displayed display, or the warning information, the difference amount or the correction amount candidate may be printed on paper.
- the comparison unit 134 shall add up the tax-excluded amount and the tax amount corresponding to each of the plurality of products. Calculate the total amount by.
- the comparison unit 134 is a first total amount which is a total amount of a plurality of tax-excluded amounts corresponding to a plurality of products, and a second total amount which is a total amount of a plurality of tax-excluded amounts and a plurality of tax amounts corresponding to a plurality of products. You may compare each of the total amounts with the total invoiced amount.
- the output unit 135 outputs warning information when both the comparison result between the first total amount and the total billing amount and the comparison result between the second total amount and the total billing amount do not match, and either one of them. If the comparison results of are the same, no warning information is output.
- the comparison unit 134 and the output unit 135 in this way, for example, when the total billing amount including tax is described in the book and the tax-excluded amount for each product is described in the statement, someday. It is possible to prevent the comparison unit 134 from erroneously determining that the value is incorrect and the output unit 135 from outputting the warning information.
- the output unit 135 when the comparison result between the first total amount and the total billing amount or the comparison result between the second total amount and the total billing amount match, either the first total amount or the second total amount is the total.
- Information indicating whether the amount matches the billed amount may be output. For example, when the output unit 135 determines that the first total amount and the total billing amount match, the accounting terminal 2 displays "the total billing amount described in the book is the tax-excluded amount", and the second When it is determined that the total billing amount and the total billing amount match, "the total billing amount stated in the book is the tax-included amount" is displayed on the accounting terminal 2.
- the output unit 135 By outputting such information by the output unit 135, when the tax-excluded amount is described in the book, the accounting staff recognizes that the total billed amount described in the book is the tax-excluded amount. Can be processed.
- the output unit 135 may have an error in one of the plurality of product amounts or the total billing amount. Information indicating the above may be output.
- the comparison unit 134 is based on the result of comparing the amount based on the result of multiplying the unit price and the quantity of each of the plurality of products contained in the invoice data and the product amount. It is determined whether or not there is an error in any of the product prices of. When the comparison unit 134 determines that one of the plurality of product prices is incorrect, the output unit 135 outputs information indicating that there is a high probability that one of the plurality of product prices is incorrect. Further, when the comparison unit 134 determines that there is no error in any of the plurality of product prices, the output unit 135 outputs information indicating that there is a high probability that the total billed amount has an error.
- FIG. 7 is a diagram showing an example of invoice data in which information indicating that there is a high probability that the product price is incorrect is output.
- the comparison unit 134 compares the amount obtained by multiplying the quantity and the unit price, the product amount, and the tax amount for each product. In the case of the example shown in FIG. 7, in the comparison unit 134, the amount of 20,000 yen, which is the product of the quantity of the “probe for measuring instrument A” and the unit price, does not match the product price, and the tax amount is 2,000 yen. Since it is consistent with the above, it is judged that there is a high possibility that the product price "30,000 yen" is incorrect.
- the comparison unit 134 determines that it is highly probable that the product amount is "20,000 yen" based on either the amount obtained by multiplying the quantity and the unit price or the tax amount.
- the output unit 135 determines that there is a possibility that one of the plurality of product prices is incorrect, the output unit 135 is a candidate for the correction amount of one or more product prices that may be incorrect among the plurality of product prices. Is output. In the example shown in FIG. 7, the output unit 135 outputs the information "there is a possibility of 20,000 yen".
- the comparison unit 134 has the quantity, unit price, and product amount associated with each of the plurality of products, provided that the total billed amount described in the book and the total amount of the plurality of product prices described in the statement do not match. , And whether the tax amount is consistent with other amounts listed in the same column or row. By operating the comparison unit 134 in this way, only when there is a possibility that one of the amounts described in the item is incorrect, the consistency of the amount described in the item is checked. It is possible to shorten the processing time when the total billed amount described and the total amount of the plurality of product amounts described in the statement match.
- the data of the invoice and the data of the details included in the invoice data are the data corresponding to the invoice and the details included in the same invoice.
- the invoice data and the detail data contained in the invoice data may be different invoices and details. Therefore, in order to be able to detect such an error, the output unit 135 has an error in character recognition due to the difference between the total billing amount described in the book and the total amount of the plurality of product amounts described in the statement. If it is determined that the above is not the case, warning information may be output indicating that the description and the details may not match.
- the comparison unit 134 compares the total billed amount with the total amount of a plurality of product amounts, and as a result, a plurality of numerical values are used. If they do not match, it may be determined that the book and the details may not match.
- the comparison unit 134 and the output unit 135 By operating the comparison unit 134 and the output unit 135 in this way, the accounting staff can understand that an error has occurred in the process of reading the invoice containing the invoice and the details, so that incorrect data can be stored in the computer. You can prevent it from being registered.
- FIG. 8 is a flowchart showing the flow of the amount check process in the data processing device 1.
- the flowchart shown in FIG. 8 starts from the time when, for example, the accounting staff performs a process of registering the image data of the invoice in the data processing device 1.
- the data acquisition unit 131 acquires the image data of the invoice transmitted by the accounting terminal 2, and inputs the acquired image data to the character string specifying unit 132 (S11).
- the data acquisition unit 131 may acquire the invoice data after the character string is specified, and may notify the acquired invoice data to the amount identification unit 133.
- the character string specifying unit 132 specifies a character string included in the input image data, and notifies the specified character string to the amount specifying unit 133 (S12).
- the amount specifying unit 133 specifies the total billed amount based on the character string described in the book (S13). Further, the amount specifying unit 133 specifies a plurality of product prices based on the plurality of character strings notified as the character strings described in the details (S14). The comparison unit 134 compares the total billed amount with the plurality of product amounts (S15).
- the comparison unit 134 determines that the comparison results match (YES in S16)
- the comparison unit 134 ends the amount check process.
- the comparison unit 134 determines that the comparison results do not match, the comparison unit 134 notifies the output unit 135 of the determination result, and the output unit 135 outputs warning information (S17).
- the comparison unit 134 can calculate the correction amount candidate (YES in S18)
- the output unit 135 further outputs the correction amount candidate (S19).
- the comparison unit 134 cannot calculate the correction amount candidate (NO in S18)
- the output unit 135 ends the process.
- the data processing device 1 outputs warning information when, for example, the total invoice amount described in the invoice and the total amount of a plurality of product amounts described in the invoice details do not match. Therefore, in the output unit 135, in addition to the case where the character string specifying unit 132 misrecognizes the character string, the total invoice amount and the total amount do not match due to the mixture of different invoices and details. Also, warning information can be output. As a result, it becomes possible for the accounting staff to know that an error has occurred in the process of reading the invoice containing the invoice and the details.
- the character string specified by the character string specifying unit 132 is displayed on the accounting terminal 2 with the appearance of the invoice as shown in FIG. 4 or FIG. 5 is illustrated.
- the mode in which the character string is displayed is arbitrary.
- the accounting terminal 2 may display a character string to be registered in the computer in a table format.
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Human Resources & Organizations (AREA)
- Technology Law (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Character Input (AREA)
- Character Discrimination (AREA)
Abstract
A data processing device 1 includes a data acquisition unit 131 that acquires invoice data, a monetary amount specification unit 133 that specifies a total billed amount included in the invoice data and a plurality of product prices corresponding to a plurality of products included in the invoice data, a comparison unit 134 that compares the total billed amount to the sum of the plurality of product prices, and an output unit that outputs warning information in cases where the comparison result from the comparison unit 134 is a non-matching result.
Description
本発明は、請求書を処理するためのデータ処理装置、データ処理方法及びプログラムに関する。
The present invention relates to a data processing device, a data processing method and a program for processing an invoice.
従来、文書を文字認識した結果に誤りがある場合に、誤認識された文字列を修正する機能を有する画像処理装置が知られている。特許文献1には、漢字の旧字と新字の違いや漢字の送り仮名の違い等の誤認識パターンに基づいて、誤認識した文字列を修正する技術が開示されている(例えば、特許文献1を参照)。
Conventionally, an image processing device having a function of correcting an erroneously recognized character string when there is an error in the result of character recognition of a document is known. Patent Document 1 discloses a technique for correcting a misrecognized character string based on a misrecognition pattern such as a difference between an old character and a new character of a Chinese character and a difference in an okurigana of a Chinese character (for example, Patent Document 1). See 1).
近年、請求書に記載された金額を認識し、認識した金額をコンピュータで管理するシステムが使用されている。請求書に記載された金額が正しく認識されないと、請求書を管理するコンピュータに正しい金額が登録されないので、経理処理に支障が生じてしまう。従来の技術により、誤認識パターンに当てはまる誤認識であれば、金額が正しく修正される場合があるが、誤認識パターンに当てはまらない誤認識が生じた場合、誤認識が発生していることに気づかないまま、誤った金額が登録されてしまう場合があるという問題があった。
In recent years, a system that recognizes the amount stated on the invoice and manages the recognized amount with a computer has been used. If the amount stated on the invoice is not correctly recognized, the correct amount will not be registered in the computer that manages the invoice, which will hinder the accounting process. With conventional technology, if the misrecognition applies to the misrecognition pattern, the amount may be corrected correctly, but if the misrecognition does not apply to the misrecognition pattern, you notice that the misrecognition has occurred. There was a problem that the wrong amount of money might be registered without it.
そこで、本発明はこれらの点に鑑みてなされたものであり、請求書を管理するコンピュータに登録される金額の精度を高めることを目的とする。
Therefore, the present invention has been made in view of these points, and an object thereof is to improve the accuracy of the amount of money registered in the computer that manages the invoice.
本発明の第1の態様のデータ処理装置は、請求書データを取得するデータ取得部と、前記請求書データに含まれる合計請求額と、前記請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定する金額特定部と、前記合計請求額と前記複数の商品金額の合算額とを比較する比較部と、前記比較部による比較結果が一致していない場合に警告情報を出力する出力部と、を有する。
The data processing device of the first aspect of the present invention corresponds to a data acquisition unit for acquiring invoice data, a total invoice amount included in the invoice data, and a plurality of products included in the invoice data. Warning when the comparison result by the comparison unit does not match the comparison unit that compares the total billing amount and the total amount of the plurality of product amounts with the amount specification unit that specifies the plurality of product amounts. It has an output unit that outputs information.
前記請求書データは、前記合計請求額が記載された第1請求書データと、前記複数の商品の明細が記載された第2請求書データと、を含み、前記比較部は、前記第1請求書データに含まれている前記合計請求額と、前記第1請求書データに記載された請求書番号に関連付けられた請求書番号を含む前記第2請求書データに含まれている前記複数の商品金額の合算額とを比較してもよい。
The invoice data includes a first invoice data in which the total invoice amount is described and a second invoice data in which the details of the plurality of products are described, and the comparison unit includes the first invoice. The plurality of products included in the second invoice data including the total invoice amount included in the invoice data and the invoice number associated with the invoice number described in the first invoice data. It may be compared with the total amount of the amount.
前記比較部は、前記請求書データにおいて前記複数の商品の名称を示す文字列が配置されている方向に記載された前記複数の商品金額を合算することにより前記合算額を算出してもよい。
The comparison unit may calculate the total amount by adding up the plurality of product amounts described in the direction in which the character strings indicating the names of the plurality of products are arranged in the invoice data.
前記請求書データには、前記複数の商品それぞれに関連付けて、税抜金額と税額とが含まれており、前記比較部は、前記複数の商品それぞれに対応する税抜金額と税額とを合算することにより前記合算額を算出してもよい。
The invoice data includes a tax-excluded amount and a tax amount associated with each of the plurality of products, and the comparison unit adds up the tax-excluded amount and the tax amount corresponding to each of the plurality of products. Therefore, the total amount may be calculated.
前記請求書データには、前記複数の商品それぞれに関連付けて、税抜金額と税額とが含まれており、前記比較部は、前記複数の商品に対応する複数の前記税抜金額の合算額である第1合算額、及び前記複数の商品に対応する複数の前記税抜金額と複数の前記税額との合算額である第2合算額のそれぞれと、前記合計請求額とを比較し、前記出力部は、前記第1合算額と前記合計請求額との比較結果、及び前記第2合算額と前記合計請求額との比較結果の両方が一致しない場合に前記警告情報を出力してもよい。
The invoice data includes a tax-excluded amount and a tax amount associated with each of the plurality of products, and the comparison unit is a total of the plurality of tax-excluded amounts corresponding to the plurality of products. The output is obtained by comparing each of the first total amount and the second total amount, which is the total amount of the plurality of tax-excluded amounts corresponding to the plurality of products and the plurality of the tax amounts, with the total billed amount. The unit may output the warning information when both the comparison result between the first total amount and the total billing amount and the comparison result between the second total amount and the total billing amount do not match.
前記出力部は、前記第1合算額と前記合計請求額との比較結果、又は前記第2合算額と前記合計請求額との比較結果が一致した場合、前記第1合算額又は前記第2合算額のどちらが前記合計請求額と一致したかを示す情報を出力してもよい。
When the comparison result between the first total amount and the total billing amount or the comparison result between the second total amount and the total billing amount match, the output unit may use the first total amount or the second total amount. Information indicating which of the amounts matches the total billed amount may be output.
前記出力部は、前記比較結果が一致していない場合、前記複数の商品金額のいずれかと前記合計請求額とのうち、どちらに誤りがある可能性があるかを示す情報を出力してもよい。
If the comparison results do not match, the output unit may output information indicating which of the plurality of product prices and the total billed amount may be erroneous. ..
前記比較部は、前記請求書データに含まれている前記複数の商品それぞれの単価と数量とを乗算した結果に基づく額と前記商品金額とを比較した結果に基づいて、前記複数の商品金額のいずれかに誤りがあるか否かを判定し、前記出力部は、前記複数の商品金額のいずれかに誤りがあると前記比較部が判定した場合、前記複数の商品金額のいずれかに誤りがある蓋然性が高いことを示す情報を出力し、前記複数の商品金額のいずれにも誤りがないと前記比較部が判定した場合、前記合計請求額に誤りがある蓋然性が高いことを示す情報を出力してもよい。
The comparison unit determines the amount of the plurality of products based on the result of comparing the amount based on the result of multiplying the unit price and the quantity of each of the plurality of products included in the invoice data with the amount of the product. It is determined whether or not there is an error in any of the products, and when the comparison unit determines that there is an error in any of the plurality of product prices, the output unit has an error in any of the plurality of product prices. When the comparison unit determines that there is no error in any of the plurality of product prices, the information indicating that there is a high probability that the total billing amount is incorrect is output. You may.
前記出力部は、前記合計請求額に誤りがある可能性があると前記比較部が判定した場合、前記合計請求額の修正額候補として前記合算額を出力してもよい。
When the comparison unit determines that the total billing amount may be incorrect, the output unit may output the total amount as a candidate for a correction amount of the total billing amount.
前記出力部は、前記複数の商品金額のいずれかに誤りがある可能性があると前記比較部が判定した場合、前記複数の商品金額のうち誤りがある可能性がある一以上の商品金額の修正額候補を出力してもよい。
When the comparison unit determines that one of the plurality of product prices may be incorrect, the output unit may have an error in one or more of the plurality of product prices. The correction amount candidate may be output.
本発明の第2の態様のデータ処理方法は、コンピュータが、請求書データを取得するステップと、前記請求書データに含まれる合計請求額と、前記請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定するステップと、前記合計請求額と前記複数の商品金額の合算額とを比較するステップと、比較した結果が一致していない場合に警告情報を出力するステップと、を実行する。
The data processing method according to the second aspect of the present invention includes a step in which a computer acquires invoice data, a total invoice amount included in the invoice data, and a plurality of products included in the invoice data. A step of specifying a plurality of corresponding product amounts, a step of comparing the total billed amount and the total amount of the plurality of product amounts, and a step of outputting warning information when the comparison results do not match. And execute.
本発明の第3の態様のプログラムは、コンピュータに、請求書データを取得するステップと、前記請求書データに含まれる合計請求額と、前記請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定するステップと、前記合計請求額と前記複数の商品金額の合算額とを比較するステップと、比較した結果が一致していない場合に警告情報を出力するステップと、を実行させる。
The program of the third aspect of the present invention corresponds to a step of acquiring invoice data to a computer, a total invoice amount included in the invoice data, and a plurality of products included in the invoice data. A step of specifying a plurality of product amounts, a step of comparing the total billed amount and the total amount of the plurality of product amounts, a step of outputting warning information when the comparison results do not match, and a step of outputting warning information. To execute.
本発明によれば、請求書を管理するコンピュータに登録される金額の精度を高めることができるという効果を奏する。
According to the present invention, there is an effect that the accuracy of the amount of money registered in the computer that manages the invoice can be improved.
[データ処理システムSの概要]
図1は、データ処理システムSの構成を説明するための図である。データ処理システムSは、請求書を読み取って得られた請求書データを処理するためのシステムである。請求書データは、請求書を読み取ることにより作成されたデータであり、請求書の内容を示す画像、又は請求書に含まれる複数の文字列に対応する複数のテキストデータを含むデータである。 [Overview of data processing system S]
FIG. 1 is a diagram for explaining the configuration of the data processing system S. The data processing system S is a system for processing the invoice data obtained by reading the invoice. The invoice data is data created by reading the invoice, and is data including an image showing the contents of the invoice or a plurality of text data corresponding to a plurality of character strings included in the invoice.
図1は、データ処理システムSの構成を説明するための図である。データ処理システムSは、請求書を読み取って得られた請求書データを処理するためのシステムである。請求書データは、請求書を読み取ることにより作成されたデータであり、請求書の内容を示す画像、又は請求書に含まれる複数の文字列に対応する複数のテキストデータを含むデータである。 [Overview of data processing system S]
FIG. 1 is a diagram for explaining the configuration of the data processing system S. The data processing system S is a system for processing the invoice data obtained by reading the invoice. The invoice data is data created by reading the invoice, and is data including an image showing the contents of the invoice or a plurality of text data corresponding to a plurality of character strings included in the invoice.
データ処理システムSは、データ処理装置1と、経理端末2と、従業員端末3と、を備える。データ処理装置1、経理端末2及び従業員端末3は、ネットワークNを介してデータを送受信する。ネットワークNは、例えばインターネット又はイントラネットを含む。
The data processing system S includes a data processing device 1, an accounting terminal 2, and an employee terminal 3. The data processing device 1, the accounting terminal 2, and the employee terminal 3 transmit and receive data via the network N. The network N includes, for example, the Internet or an intranet.
データ処理装置1は、各種の請求書データを管理するコンピュータである。データ処理装置1は、経理端末2又は従業員端末3から請求書の画像データを含むファイルを取得し、取得した画像データにおいて特定された文字列に基づいて、請求書データを作成してもよく、経理端末2又は従業員端末3から請求書データを含むファイルを取得してもよい。
The data processing device 1 is a computer that manages various invoice data. The data processing device 1 may acquire a file containing the image data of the invoice from the accounting terminal 2 or the employee terminal 3 and create the invoice data based on the character string specified in the acquired image data. , The file containing the invoice data may be acquired from the accounting terminal 2 or the employee terminal 3.
本実施形態に係るデータ処理装置1は、請求先企業が受け取った請求書の内容を示す請求書データを管理する。データ処理装置1は、過去に請求先企業が受け取った請求書の内容、及びそれぞれの請求書に関連する部門を示す複数の過去請求書データを含む請求書データベースを記憶しており、経理端末2からの要求に応じて、記憶している請求書データの内容を経理端末2に提供する。データ処理装置1は、請求書データに含まれている文字列を認識し、請求書データを管理するシステム(例えば経理用の基幹システム)のデータベースに登録されるデータを出力してもよい。
The data processing device 1 according to the present embodiment manages invoice data indicating the contents of the invoice received by the billing company. The data processing device 1 stores an invoice database including the contents of invoices received by the invoiced company in the past and a plurality of past invoice data indicating the departments related to each invoice, and the accounting terminal 2 The contents of the stored invoice data are provided to the accounting terminal 2 in response to the request from. The data processing device 1 may recognize the character string included in the invoice data and output the data registered in the database of the system that manages the invoice data (for example, the core system for accounting).
データ処理装置1は、例えば人工知能を用いて請求書の画像データに含まれている文字列を認識して請求書データを作成するが、文字列を正しく認識できないという場合がある。また、請求書に誤記が存在する場合もある。誤認識又は誤記された文字列がデータベースに登録されてしまうと経理処理に支障が生じる。データ処理装置1は、経理処理に支障が生じないように、請求書データに含まれる合計請求額と、当該請求書データに含まれている複数の商品に対応する複数の商品金額と、を比較することにより、誤認識又は誤記された文字列の有無を判定する。データ処理装置1は、誤認識された文字列や誤記された文字列があることを検出した場合に警告情報を出力することで、経理担当者に注意を促す。データ処理装置1は、誤認識又は誤記された文字列があることを検出した場合に、正しいと推定される文字列の候補を出力してもよい。
The data processing device 1 uses artificial intelligence, for example, to recognize the character string contained in the image data of the invoice and create the invoice data, but the character string may not be recognized correctly. There may also be typographical errors in the invoice. If a misrecognized or miswritten character string is registered in the database, the accounting process will be hindered. The data processing device 1 compares the total invoice amount included in the invoice data with the plurality of product amounts corresponding to the plurality of products included in the invoice data so as not to interfere with the accounting processing. By doing so, it is determined whether or not there is an erroneously recognized or erroneously written character string. The data processing device 1 calls attention to the accounting staff by outputting warning information when it detects that there is an erroneously recognized character string or an erroneously written character string. When the data processing device 1 detects that there is a erroneously recognized or erroneously written character string, the data processing device 1 may output a character string candidate presumed to be correct.
経理端末2は、請求書を受領した請求先企業においてデータ処理装置1を利用する従業員(例えば経理担当者)が使用するコンピュータである。経理端末2は、例えばイントラネットを介してデータ処理装置1との間で各種のデータを送受信する。
The accounting terminal 2 is a computer used by an employee (for example, an accounting person) who uses the data processing device 1 in the billing company that received the invoice. The accounting terminal 2 transmits and receives various data to and from the data processing device 1 via, for example, an intranet.
経理端末2は、例えば経理担当者がスキャナで読み取った請求書の画像データをデータ処理装置1に送信する。また、経理端末2は、経理担当者の指示に応じてデータ処理装置1が記憶している請求書データベースにアクセスして、経理担当者が指定した請求書データを表示する。図1は1台の経理端末2を示しているが、複数の経理端末2がデータ処理装置1にアクセスしてもよい。
The accounting terminal 2 transmits, for example, the image data of the invoice read by the accounting person with a scanner to the data processing device 1. Further, the accounting terminal 2 accesses the invoice database stored in the data processing device 1 according to the instruction of the accounting person, and displays the invoice data specified by the accounting person. Although FIG. 1 shows one accounting terminal 2, a plurality of accounting terminals 2 may access the data processing device 1.
従業員端末3は、商品等を請求元企業に発注した請求先企業の従業員が使用するコンピュータである。従業員端末3は、従業員が請求書を受け取った場合に、従業員の操作に応じて請求書の画像データをデータ処理装置1に送信する。
The employee terminal 3 is a computer used by an employee of the billing company that ordered the product or the like from the billing company. When the employee receives the invoice, the employee terminal 3 transmits the image data of the invoice to the data processing device 1 according to the operation of the employee.
図2及び図3は、請求書の例を示す図である。図2は、請求書における鑑の部分の例を示しており、図3は、請求書における明細の部分の例を示している。鑑には明細の要点が記載されており、例えば、明細に記載されている複数の商品の金額の合計請求額が記載されている。図2に示す例においては、図3に示す明細に記載されている複数の商品の税抜金額の合計額である「御買上額」、複数の商品の消費税額の合計額である「消費税額」、及び「御買上額」と「消費税額」が合算された合計請求額が「御請求額」として記載されている。
2 and 3 are diagrams showing an example of an invoice. FIG. 2 shows an example of the invoice portion of the invoice, and FIG. 3 shows an example of the detail portion of the invoice. The main points of the description are described in the book, for example, the total billing amount of the amounts of the plurality of products described in the description is described. In the example shown in FIG. 2, the "purchase amount" which is the total amount of tax-excluded amounts of the plurality of products shown in the specification shown in FIG. 3 and the "consumption tax amount" which is the total amount of the consumption tax amounts of the plurality of products. , And the total billed amount, which is the sum of the "purchased amount" and the "consumption tax amount", is described as the "billed amount".
図3に示す明細においては、複数の商品それぞれの納品日、品名、数量、単価、商品金額、税額が記載されている。また、複数の商品の商品金額の小計、税額の小計も記載されており、それらを合算した金額である合算額が「御請求額」として記載されている。
In the details shown in FIG. 3, the delivery date, product name, quantity, unit price, product amount, and tax amount of each of the plurality of products are described. In addition, a subtotal of the product amount and a subtotal of the tax amount of a plurality of products are also described, and the total amount, which is the total amount of these items, is described as the "billed amount".
図4は、図2に示した請求書の鑑を読み取って作成された請求書データの例を示す図である。データ処理装置1は、図4に示す請求書データを、例えば経理端末2に表示させる。
FIG. 4 is a diagram showing an example of invoice data created by reading the invoice invoice shown in FIG. The data processing device 1 causes, for example, the accounting terminal 2 to display the invoice data shown in FIG.
図4に示す請求書データにおいては、合計請求額が89,000円と読み取られており、「88,000円の可能性あり」という警告が表示されている。データ処理装置1は、例えば、図4に示す合計請求額と、図3に示した請求書を読み取った請求書データにおける複数の商品金額の合算値とを比較し、これらが一致しない場合に警告を経理端末2に表示させる。この際、正しい合計請求額の候補として、明細に記載されている複数の商品金額の合算値を修正額候補として経理端末2に表示させる。
In the invoice data shown in FIG. 4, the total invoice amount is read as 89,000 yen, and a warning "There is a possibility of 88,000 yen" is displayed. The data processing device 1 compares, for example, the total invoice amount shown in FIG. 4 with the total value of a plurality of product amounts in the invoice data obtained by reading the invoice shown in FIG. 3, and warns when these do not match. Is displayed on the accounting terminal 2. At this time, as a candidate for the correct total billing amount, the total value of the plurality of product amounts described in the statement is displayed on the accounting terminal 2 as a correction amount candidate.
データ処理装置1は、鑑に税別金額と税額とが記載されている場合、税別金額と税額とを合算した額と合計請求額とを比較した結果に基づいて警告を表示させたり、修正額候補を表示させたりしてもよい。データ処理装置1がこのように警告を経理端末2に表示させることで、経理担当者が、請求書データに問題があることを認識することができる。また、データ処理装置1が修正額候補を表示させることにより、経理担当者が正しい額に訂正をしやすくなる。
When the tax-excluded amount and the tax amount are described in the data processing device 1, the data processing device 1 displays a warning based on the result of comparing the total amount of the tax-excluded amount and the tax amount with the total billed amount, or a correction amount candidate. May be displayed. By displaying the warning on the accounting terminal 2 in this way, the data processing device 1 can recognize that there is a problem with the invoice data. Further, the data processing device 1 displays the correction amount candidate, so that the accounting staff can easily correct the correction amount.
図5は、図3に示した請求書の明細を読み取って作成された請求書データの例を示す図である。図5に示す請求書データにおいては、「御請求額」が誤って98,000円と読み取られており、警告が表示されている。データ処理装置1は、「御請求額」として記載された額が、複数の商品金額の合算額80,000円と税額の合算額8,000円を合計した額である88,000円と一致していないことから、「御請求額」として記載された額に誤りがある可能性があると判定して警告を出力する。データ処理装置1は、鑑に記載されている合計請求額とも一致していないことに基づいて警告を出力してもよい。
FIG. 5 is a diagram showing an example of invoice data created by reading the details of the invoice shown in FIG. In the invoice data shown in FIG. 5, the "billed amount" is erroneously read as 98,000 yen, and a warning is displayed. In the data processing device 1, the amount described as the "billed amount" is 88,000 yen, which is the total amount of the total amount of 80,000 yen for a plurality of product amounts and the total amount of 8,000 yen for the tax amount. Since we have not done so, we judge that there is a possibility that the amount stated as "billed amount" is incorrect and output a warning. The data processing device 1 may output a warning based on the fact that it does not match the total billing amount stated in the book.
このように、データ処理装置1は、請求書データに含まれる合計請求額と、請求書データに含まれている複数の商品に対応する複数の商品金額の合算額とが一致していない場合に警告を出力するので、請求書内の金額が誤って読み取られていることを経理担当者が認識する。その結果、誤った金額がデータベースに登録されることを防げる。以下、データ処理装置1の構成及び動作を詳細に説明する。
As described above, in the data processing device 1, when the total invoice amount included in the invoice data and the total amount of the plurality of product amounts corresponding to the plurality of products included in the invoice data do not match. Since it outputs a warning, the accountant recognizes that the amount in the invoice has been read incorrectly. As a result, it is possible to prevent incorrect amounts from being registered in the database. Hereinafter, the configuration and operation of the data processing device 1 will be described in detail.
[データ処理装置1の構成及び動作]
図6は、データ処理装置1の構成を示す図である。データ処理装置1は、通信部11と、記憶部12と、制御部13とを有する。制御部13は、データ取得部131と、文字列特定部132と、金額特定部133と、比較部134と、出力部135とを有する。 [Configuration and operation of data processing device 1]
FIG. 6 is a diagram showing the configuration of thedata processing device 1. The data processing device 1 has a communication unit 11, a storage unit 12, and a control unit 13. The control unit 13 includes a data acquisition unit 131, a character string specifying unit 132, an amount specifying unit 133, a comparison unit 134, and an output unit 135.
図6は、データ処理装置1の構成を示す図である。データ処理装置1は、通信部11と、記憶部12と、制御部13とを有する。制御部13は、データ取得部131と、文字列特定部132と、金額特定部133と、比較部134と、出力部135とを有する。 [Configuration and operation of data processing device 1]
FIG. 6 is a diagram showing the configuration of the
通信部11は、ネットワークNを介して経理端末2及び従業員端末3と各種のデータを送受信するための通信コントローラを有する。通信部11は、例えば経理端末2から受信したデータをデータ取得部131に入力する。また、通信部11は、出力部135から入力されたデータを、例えば経理端末2に送信する。
The communication unit 11 has a communication controller for transmitting and receiving various data to and from the accounting terminal 2 and the employee terminal 3 via the network N. The communication unit 11 inputs data received from, for example, the accounting terminal 2 to the data acquisition unit 131. Further, the communication unit 11 transmits the data input from the output unit 135 to, for example, the accounting terminal 2.
記憶部12は、ROM(Read Only Memory)、RAM(Random Access Memory)及びハードディスク等の記憶媒体を有する。記憶部12は、制御部13が実行するプログラムを記憶している。記憶部12は、通信部11を介して受信した請求書の画像データを一時的に記憶するワークメモリとしても機能する。記憶部12は、過去の請求書の請求書データを記憶してもよい。
The storage unit 12 has a storage medium such as a ROM (ReadOnlyMemory), a RAM (RandomAccessMemory), and a hard disk. The storage unit 12 stores a program executed by the control unit 13. The storage unit 12 also functions as a work memory for temporarily storing the image data of the invoice received via the communication unit 11. The storage unit 12 may store the invoice data of the past invoice.
制御部13は、例えばCPU(Central Processing Unit)を有する。制御部13は、記憶部12に記憶されたプログラムを実行することにより、データ取得部131、文字列特定部132、金額特定部133、比較部134及び出力部135として機能する。
The control unit 13 has, for example, a CPU (Central Processing Unit). The control unit 13 functions as a data acquisition unit 131, a character string specifying unit 132, an amount specifying unit 133, a comparison unit 134, and an output unit 135 by executing a program stored in the storage unit 12.
データ取得部131は、通信部11を介して各種のデータを取得する。データ取得部131は、例えば経理端末2又は3から送信された請求書データを取得する。データ取得部131は、取得した請求書データが画像データである場合、当該画像データを文字列特定部132に入力する。データ取得部131は、請求書の画像データを記憶部12に記憶させてもよい。データ取得部131は、取得した請求書データがテキストデータを含む場合、請求書データを金額特定部133に入力する。
The data acquisition unit 131 acquires various data via the communication unit 11. The data acquisition unit 131 acquires invoice data transmitted from, for example, the accounting terminal 2 or 3. When the acquired invoice data is image data, the data acquisition unit 131 inputs the image data to the character string specifying unit 132. The data acquisition unit 131 may store the image data of the invoice in the storage unit 12. When the acquired invoice data includes text data, the data acquisition unit 131 inputs the invoice data to the amount specifying unit 133.
また、データ取得部131は、経理端末2における操作内容を示すデータを取得してもよい。指示データは、例えば複数の候補文字列から経理端末2の経理担当者が選択した候補文字列を示す選択データである。データ取得部131は、取得した選択データを金額特定部133に通知する。
Further, the data acquisition unit 131 may acquire data indicating the operation content in the accounting terminal 2. The instruction data is, for example, selection data indicating a candidate character string selected by the accounting staff of the accounting terminal 2 from a plurality of candidate character strings. The data acquisition unit 131 notifies the amount identification unit 133 of the acquired selection data.
文字列特定部132は、請求書の画像データに含まれる複数の文字列を特定する。文字列特定部132は、例えばOCR(Optical Character Recognition)を用いて文字認識することにより複数の文字列を特定する。一例として、文字列特定部132は、文字が読み取られた画像データと文字列との組み合わせを教師データとして学習し、入力された画像データに対応する複数の文字列を出力する機械学習モデル(すなわち人工知能エンジン)に請求書の画像データを入力することにより、複数の文字列を特定する。文字列特定部132は、特定した文字列を金額特定部133に通知する。
The character string specifying unit 132 specifies a plurality of character strings included in the image data of the invoice. The character string specifying unit 132 specifies a plurality of character strings by recognizing characters using, for example, OCR (Optical Character Recognition). As an example, the character string specifying unit 132 learns a combination of an image data in which a character is read and a character string as teacher data, and outputs a plurality of character strings corresponding to the input image data (that is, a machine learning model (that is,). By inputting the image data of the invoice into the artificial intelligence engine), multiple character strings are specified. The character string specifying unit 132 notifies the amount specifying unit 133 of the specified character string.
請求書が鑑と明細から構成されており、請求書の画像データが鑑のデータ(第1請求書データ)と明細のデータ(第2請求書データ)とを含んでいる場合、文字列特定部132は、読み取った請求書の画像データが鑑のデータであるか明細のデータであるかをさらに判別し、判別した結果を金額特定部133に通知してもよい。文字列特定部132は、例えば、複数の商品名の文字列を特定できなかった場合には読み取った請求書の画像データが鑑のデータであると判定し、複数の商品名の文字列を特定できた場合には読み取った請求書の画像データが明細のデータであると判定する。文字列特定部132は、予め鑑の書式と明細の書式とを教師データとして機械学習したモデルに読み取った請求書データを入力し、当該モデルから出力された結果に基づいて、読み取った請求書が鑑であるか明細であるかを判別してもよい。
When the invoice is composed of an invoice and a statement, and the image data of the invoice includes the invoice data (first invoice data) and the statement data (second invoice data), the character string identification unit. The 132 may further determine whether the read image data of the invoice is the data of the book or the data of the details, and may notify the amount specifying unit 133 of the determination result. For example, when the character string specifying unit 132 cannot specify the character strings of a plurality of product names, it determines that the image data of the read invoice is the data of the book, and specifies the character strings of the plurality of product names. If it can be done, it is determined that the image data of the read invoice is the data of the details. The character string specifying unit 132 inputs the invoice data read into the model machine-learned using the format of the book and the format of the details as teacher data in advance, and the read invoice is based on the result output from the model. It may be determined whether it is a reference or a detail.
文字列特定部132は、特定した文字列に基づいて、複数の第1請求書データ及び複数の第2請求書データのうち、一つの請求書に対応する第1請求データと第2請求データとを特定してもよい。第2請求書データが、第1請求書データに記載された請求書番号に関連付けられた請求書番号を含んでいる場合、文字列特定部132は、例えば、第1請求書データと、当該第1請求書データに記載された請求書番号に対応する請求書番号を含む第2請求書データとを、一つの請求書データに含まれる鑑のデータ及び明細のデータであると判定してもよい。
Based on the specified character string, the character string specifying unit 132 includes the first billing data and the second billing data corresponding to one bill among the plurality of first billing data and the plurality of second billing data. May be specified. When the second invoice data includes the invoice number associated with the invoice number described in the first invoice data, the character string specifying unit 132 may refer to, for example, the first invoice data and the first invoice data. 1 The second invoice data including the invoice number corresponding to the invoice number described in the invoice data may be determined to be the data of the reference and the data of the details included in one invoice data. ..
図2及び図3に示す例の場合、第2請求書データは、第1請求書データが含む請求書番号S1000226と同一の請求書番号を含んでおり、図2に示す第1請求書データが、図3に示す第2請求書データの鑑であると判定する。文字列特定部132は、どの請求書データが鑑に対応し、どの請求書データが明細に対応するかを示す種別情報を金額特定部133に通知する。
In the case of the example shown in FIGS. 2 and 3, the second invoice data includes the same invoice number as the invoice number S1000226 included in the first invoice data, and the first invoice data shown in FIG. 2 is , It is determined that the second invoice data is a reference shown in FIG. The character string specifying unit 132 notifies the amount specifying unit 133 of the type information indicating which invoice data corresponds to the invoice and which invoice data corresponds to the details.
金額特定部133は、請求書データに含まれる合計請求額と、請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定する。金額特定部133は、例えば、文字列特定部132から通知された種別情報に基づいて、鑑に含まれている金額が合計請求額であると特定し、明細において複数の商品名と同じ列又は同じ行に記載されている金額が複数の商品金額であると特定する。
The amount specifying unit 133 specifies the total invoice amount included in the invoice data and the plurality of product amounts corresponding to the plurality of products included in the invoice data. The amount specifying unit 133 specifies, for example, that the amount included in the book is the total billed amount based on the type information notified from the character string specifying unit 132, and in the same column or the same column as a plurality of product names in the statement. Identify that the amounts listed on the same line are multiple product amounts.
請求書の明細に合計請求額と複数の商品金額とが記載されている場合、金額特定部133は、金額が記載されている請求書内の位置、又は金額の横に記載されている文字の内容の少なくともいずれかに基づいて、合計請求額であるか商品金額であるかを判別してもよい。金額特定部133は、例えば請求書の最も下の位置に書かれている金額が合計請求額であると判別し、商品名と同じ列又は行に書かれている金額が商品金額であると判別する。
If the invoice details include the total invoice amount and multiple merchandise amounts, the amount identification unit 133 will use the location in the invoice where the amount is stated, or the text next to the amount. It may be determined whether it is the total invoice amount or the product amount based on at least one of the contents. The amount specifying unit 133 determines, for example, that the amount written at the bottom of the invoice is the total invoice amount, and that the amount written in the same column or row as the product name is the product amount. do.
比較部134は、金額特定部133が特定した合計請求額と複数の商品金額の合算額とを比較する。比較部134は、例えば、図2に示した鑑に対応する第1請求書データに含まれている合計請求額と、図3に示した明細に対応する第2請求書データに含まれている複数の商品金額の合算額とを比較する。比較部134は、請求書データにおいて複数の商品の名称を示す文字列が配置されている方向(図3に示す例においては縦方向)に記載された複数の商品金額を合算することにより合算額を算出する。比較部134は、比較した結果を出力部135に通知する。なお、請求書の明細に合計請求額と複数の商品金額とが記載されている場合、比較部134は、一つの明細に記載された合計請求額と複数の商品金額の合算額とを比較してもよい。
The comparison unit 134 compares the total billed amount specified by the amount specifying unit 133 with the total amount of the plurality of product amounts. The comparison unit 134 is included in, for example, the total invoice amount included in the first invoice data corresponding to the invoice shown in FIG. 2 and the second invoice data corresponding to the details shown in FIG. Compare with the total amount of multiple product prices. The comparison unit 134 adds up the total amount of the plurality of products described in the direction (vertical direction in the example shown in FIG. 3) in which the character strings indicating the names of the plurality of products are arranged in the invoice data. Is calculated. The comparison unit 134 notifies the output unit 135 of the comparison result. When the total invoice amount and the plurality of product amounts are described in the invoice statement, the comparison unit 134 compares the total invoice amount described in one item with the total amount of the plurality of product amounts. You may.
出力部135は、比較部134が比較した結果が一致していない場合に警告情報を出力する。出力部135は、比較した結果が一致していない場合に、合計請求額と複数の商品金額の合算額との差額を出力してもよい。出力部135は、合計請求額に誤りがある可能性があると判定した場合、合計請求額の修正額候補として合算額を出力してもよい。出力部135は、例えば経理端末2に警告情報又は修正額候補を送信することにより、警告情報、差額又は修正額候補を経理端末2に表示させるが、出力部135は、データ処理装置1に接続されたディスプレイに警告情報、差額又は修正額候補を表示させたり、紙に警告情報、差額又は修正額候補を印刷したりしてもよい。
The output unit 135 outputs warning information when the comparison results of the comparison unit 134 do not match. The output unit 135 may output the difference between the total billed amount and the total amount of the plurality of product amounts when the comparison results do not match. If the output unit 135 determines that the total billing amount may be incorrect, the output unit 135 may output the total amount as a candidate for the correction amount of the total billing amount. The output unit 135 causes the accounting terminal 2 to display the warning information, the difference amount, or the correction amount candidate by, for example, transmitting the warning information or the correction amount candidate to the accounting terminal 2, but the output unit 135 is connected to the data processing device 1. The warning information, the difference or the correction amount candidate may be displayed on the displayed display, or the warning information, the difference amount or the correction amount candidate may be printed on paper.
以下、比較部134及び出力部135の動作を詳細に説明する。
図3に示す例のように、明細に商品の税抜金額と税額とが別々に記載されている場合、比較部134は、複数の商品それぞれに対応する税抜金額と税額とを合算することにより合算額を算出する。比較部134は、複数の商品に対応する複数の税抜金額の合算額である第1合算額、及び複数の商品に対応する複数の税抜金額と複数の税額との合算額である第2合算額のそれぞれと、合計請求額とを比較してもよい。この場合、出力部135は、第1合算額と合計請求額との比較結果、及び第2合算額と合計請求額との比較結果の両方が一致しない場合に警告情報を出力し、いずれか一方の比較結果が一致している場合には警告情報を出力しない。このように比較部134及び出力部135が動作することで、例えば、鑑に税込の合計請求額が記載されており、明細に商品別の税抜金額が記載されているような場合に、いずれかが誤っていると比較部134が誤判定して出力部135が警告情報を出力してしまうことを防止できる。 Hereinafter, the operations of thecomparison unit 134 and the output unit 135 will be described in detail.
As in the example shown in FIG. 3, when the tax-excluded amount and the tax amount of the product are described separately in the statement, thecomparison unit 134 shall add up the tax-excluded amount and the tax amount corresponding to each of the plurality of products. Calculate the total amount by. The comparison unit 134 is a first total amount which is a total amount of a plurality of tax-excluded amounts corresponding to a plurality of products, and a second total amount which is a total amount of a plurality of tax-excluded amounts and a plurality of tax amounts corresponding to a plurality of products. You may compare each of the total amounts with the total invoiced amount. In this case, the output unit 135 outputs warning information when both the comparison result between the first total amount and the total billing amount and the comparison result between the second total amount and the total billing amount do not match, and either one of them. If the comparison results of are the same, no warning information is output. By operating the comparison unit 134 and the output unit 135 in this way, for example, when the total billing amount including tax is described in the book and the tax-excluded amount for each product is described in the statement, someday. It is possible to prevent the comparison unit 134 from erroneously determining that the value is incorrect and the output unit 135 from outputting the warning information.
図3に示す例のように、明細に商品の税抜金額と税額とが別々に記載されている場合、比較部134は、複数の商品それぞれに対応する税抜金額と税額とを合算することにより合算額を算出する。比較部134は、複数の商品に対応する複数の税抜金額の合算額である第1合算額、及び複数の商品に対応する複数の税抜金額と複数の税額との合算額である第2合算額のそれぞれと、合計請求額とを比較してもよい。この場合、出力部135は、第1合算額と合計請求額との比較結果、及び第2合算額と合計請求額との比較結果の両方が一致しない場合に警告情報を出力し、いずれか一方の比較結果が一致している場合には警告情報を出力しない。このように比較部134及び出力部135が動作することで、例えば、鑑に税込の合計請求額が記載されており、明細に商品別の税抜金額が記載されているような場合に、いずれかが誤っていると比較部134が誤判定して出力部135が警告情報を出力してしまうことを防止できる。 Hereinafter, the operations of the
As in the example shown in FIG. 3, when the tax-excluded amount and the tax amount of the product are described separately in the statement, the
また、出力部135は、第1合算額と合計請求額との比較結果、又は第2合算額と合計請求額との比較結果が一致した場合、第1合算額又は第2合算額のどちらが合計請求額と一致したかを示す情報を出力してもよい。出力部135は、例えば、第1合算額と合計請求額とが一致していると判定した場合、「鑑に記載された合計請求額は税抜金額です」と経理端末2に表示させ、第2合算額と合計請求額とが一致していると判定した場合、「鑑に記載された合計請求額は税込金額です」と経理端末2に表示させる。出力部135がこのような情報を出力することで、鑑に税抜金額が記載されている場合に、鑑に記載された合計請求額が税抜金額であることを経理担当者が認識して処理をすることができる。
Further, in the output unit 135, when the comparison result between the first total amount and the total billing amount or the comparison result between the second total amount and the total billing amount match, either the first total amount or the second total amount is the total. Information indicating whether the amount matches the billed amount may be output. For example, when the output unit 135 determines that the first total amount and the total billing amount match, the accounting terminal 2 displays "the total billing amount described in the book is the tax-excluded amount", and the second When it is determined that the total billing amount and the total billing amount match, "the total billing amount stated in the book is the tax-included amount" is displayed on the accounting terminal 2. By outputting such information by the output unit 135, when the tax-excluded amount is described in the book, the accounting staff recognizes that the total billed amount described in the book is the tax-excluded amount. Can be processed.
出力部135は、複数の商品金額の合算額と合計請求額との比較結果が一致していない場合、複数の商品金額のいずれかと合計請求額とのうち、どちらに誤りがある可能性があるかを示す情報を出力してもよい。これを可能にするために、比較部134は、請求書データに含まれている複数の商品それぞれの単価と数量とを乗算した結果に基づく額と商品金額とを比較した結果に基づいて、複数の商品金額のいずれかに誤りがあるか否かを判定する。出力部135は、複数の商品金額のいずれかに誤りがあると比較部134が判定した場合、複数の商品金額のいずれかに誤りがある蓋然性が高いことを示す情報を出力する。また、出力部135は、複数の商品金額のいずれにも誤りがないと比較部134が判定した場合、合計請求額に誤りがある蓋然性が高いことを示す情報を出力する。
If the comparison result between the total amount of the plurality of product amounts and the total billing amount does not match, the output unit 135 may have an error in one of the plurality of product amounts or the total billing amount. Information indicating the above may be output. In order to make this possible, the comparison unit 134 is based on the result of comparing the amount based on the result of multiplying the unit price and the quantity of each of the plurality of products contained in the invoice data and the product amount. It is determined whether or not there is an error in any of the product prices of. When the comparison unit 134 determines that one of the plurality of product prices is incorrect, the output unit 135 outputs information indicating that there is a high probability that one of the plurality of product prices is incorrect. Further, when the comparison unit 134 determines that there is no error in any of the plurality of product prices, the output unit 135 outputs information indicating that there is a high probability that the total billed amount has an error.
図7は、商品金額に誤りがある蓋然性が高いことを示す情報が出力された請求書データの例を示す図である。比較部134は、商品ごとに、数量と単価を乗算した額と、商品金額と、税額とを比較する。図7に示す例の場合、比較部134は、「測定器A用プローブ」の数量と単価とを乗算した額である20,000円が商品金額に一致しておらず、税額2,000円とは整合していることから、商品金額「30,000円」に誤りがある蓋然性が高いと判定する。そして、比較部134は、数量と単価を乗算した額、又は税額のいずれかに基づいて、商品金額が「20,000円」である蓋然性が高いと判定する。出力部135は、複数の商品金額のいずれかに誤りがある可能性があると比較部134判定した場合、複数の商品金額のうち誤りがある可能性がある一以上の商品金額の修正額候補を出力する。図7に示す例において、出力部135は、「20,000円の可能性あり」という情報を出力している。
FIG. 7 is a diagram showing an example of invoice data in which information indicating that there is a high probability that the product price is incorrect is output. The comparison unit 134 compares the amount obtained by multiplying the quantity and the unit price, the product amount, and the tax amount for each product. In the case of the example shown in FIG. 7, in the comparison unit 134, the amount of 20,000 yen, which is the product of the quantity of the “probe for measuring instrument A” and the unit price, does not match the product price, and the tax amount is 2,000 yen. Since it is consistent with the above, it is judged that there is a high possibility that the product price "30,000 yen" is incorrect. Then, the comparison unit 134 determines that it is highly probable that the product amount is "20,000 yen" based on either the amount obtained by multiplying the quantity and the unit price or the tax amount. When the output unit 135 determines that there is a possibility that one of the plurality of product prices is incorrect, the output unit 135 is a candidate for the correction amount of one or more product prices that may be incorrect among the plurality of product prices. Is output. In the example shown in FIG. 7, the output unit 135 outputs the information "there is a possibility of 20,000 yen".
比較部134は、鑑に記載された合計請求額と、明細に記載された複数の商品金額の合算額とが一致しないことを条件として、複数の商品それぞれに関連付けられた数量、単価、商品金額、及び税額が、同じ列又は同じ行に記載された他の額と整合するかどうかを判定してもよい。比較部134がこのように動作することで、明細に記載された金額のいずれかに誤りがある可能性がある場合に限って、明細に記載された金額の整合性をチェックするため、鑑に記載された合計請求額と明細に記載された複数の商品金額の合算額とが一致している場合の処理時間を短縮することができる。
The comparison unit 134 has the quantity, unit price, and product amount associated with each of the plurality of products, provided that the total billed amount described in the book and the total amount of the plurality of product prices described in the statement do not match. , And whether the tax amount is consistent with other amounts listed in the same column or row. By operating the comparison unit 134 in this way, only when there is a possibility that one of the amounts described in the item is incorrect, the consistency of the amount described in the item is checked. It is possible to shorten the processing time when the total billed amount described and the total amount of the plurality of product amounts described in the statement match.
ところで、以上の説明においては、請求書データに含まれている鑑のデータと明細のデータとが、同一の請求書に含まれている鑑と明細に対応するデータであることを前提に説明したが、請求書を読み取る作業をした人のミスにより、請求書データに含まれている鑑のデータと明細のデータとが、それぞれ異なる請求書の鑑と明細であるということもある。そこで、このようなミスを検出することができるように、出力部135は、鑑に記載された合計請求額と明細に記載された複数の商品金額の合算額との差異が、文字認識の誤りでないと判定した場合に、鑑と明細が整合していない可能性があることを示す警告情報を出力してもよい。
By the way, in the above description, it is assumed that the data of the invoice and the data of the details included in the invoice data are the data corresponding to the invoice and the details included in the same invoice. However, due to a mistake made by the person who read the invoice, the invoice data and the detail data contained in the invoice data may be different invoices and details. Therefore, in order to be able to detect such an error, the output unit 135 has an error in character recognition due to the difference between the total billing amount described in the book and the total amount of the plurality of product amounts described in the statement. If it is determined that the above is not the case, warning information may be output indicating that the description and the details may not match.
近年の文字認識率は99%以上であり、複数の文字が誤認識される確率は低いので、比較部134は、合計請求額と複数の商品金額の合算額とを比較した結果、複数の数値が一致していないという場合に、鑑と明細が整合していない可能性があると判定してもよい。比較部134及び出力部135がこのように動作することで、鑑と明細が含まれている請求書を読み取る処理にミスが生じたことを経理担当者が把握できるので、誤ったデータがコンピュータに登録されることを防げる。
Since the character recognition rate in recent years is 99% or more and the probability that multiple characters are erroneously recognized is low, the comparison unit 134 compares the total billed amount with the total amount of a plurality of product amounts, and as a result, a plurality of numerical values are used. If they do not match, it may be determined that the book and the details may not match. By operating the comparison unit 134 and the output unit 135 in this way, the accounting staff can understand that an error has occurred in the process of reading the invoice containing the invoice and the details, so that incorrect data can be stored in the computer. You can prevent it from being registered.
[データ処理装置1の処理の流れ]
図8は、データ処理装置1における金額チェック処理の流れを示すフローチャートである。図8に示すフローチャートは、例えば経理担当者がデータ処理装置1に請求書の画像データを登録する処理を行った時点から開始している。 [Processing flow of data processing device 1]
FIG. 8 is a flowchart showing the flow of the amount check process in thedata processing device 1. The flowchart shown in FIG. 8 starts from the time when, for example, the accounting staff performs a process of registering the image data of the invoice in the data processing device 1.
図8は、データ処理装置1における金額チェック処理の流れを示すフローチャートである。図8に示すフローチャートは、例えば経理担当者がデータ処理装置1に請求書の画像データを登録する処理を行った時点から開始している。 [Processing flow of data processing device 1]
FIG. 8 is a flowchart showing the flow of the amount check process in the
データ取得部131は、経理端末2が送信した請求書の画像データを取得し、取得した画像データを文字列特定部132に入力する(S11)。データ取得部131は、文字列が特定された後の請求書データを取得し、取得した請求書データを金額特定部133に通知してもよい。文字列特定部132は、入力された画像データに含まれている文字列を特定し、特定した文字列を金額特定部133に通知する(S12)。
The data acquisition unit 131 acquires the image data of the invoice transmitted by the accounting terminal 2, and inputs the acquired image data to the character string specifying unit 132 (S11). The data acquisition unit 131 may acquire the invoice data after the character string is specified, and may notify the acquired invoice data to the amount identification unit 133. The character string specifying unit 132 specifies a character string included in the input image data, and notifies the specified character string to the amount specifying unit 133 (S12).
金額特定部133は、鑑に記載されている文字列に基づいて、合計請求額を特定する(S13)。また、金額特定部133は、明細に記載されている文字列として通知された複数の文字列に基づいて、複数の商品金額を特定する(S14)。比較部134は、合計請求額と複数の商品金額とを比較する(S15)。
The amount specifying unit 133 specifies the total billed amount based on the character string described in the book (S13). Further, the amount specifying unit 133 specifies a plurality of product prices based on the plurality of character strings notified as the character strings described in the details (S14). The comparison unit 134 compares the total billed amount with the plurality of product amounts (S15).
比較部134は、比較した結果が一致していると判定した場合(S16においてYES)、金額チェック処理を終了する。比較部134は、比較した結果が一致していないと判定した場合、判定した結果を出力部135に通知して、出力部135が警告情報を出力する(S17)。出力部135は、比較部134が修正額候補を算出できた場合(S18においてYES)、修正額候補をさらに出力する(S19)。出力部135は、比較部134が修正額候補を算出できなかった場合(S18においてNO)、処理を終了する。
When the comparison unit 134 determines that the comparison results match (YES in S16), the comparison unit 134 ends the amount check process. When the comparison unit 134 determines that the comparison results do not match, the comparison unit 134 notifies the output unit 135 of the determination result, and the output unit 135 outputs warning information (S17). When the comparison unit 134 can calculate the correction amount candidate (YES in S18), the output unit 135 further outputs the correction amount candidate (S19). When the comparison unit 134 cannot calculate the correction amount candidate (NO in S18), the output unit 135 ends the process.
[データ処理装置1による効果]
以上説明したように、データ処理装置1は、請求書データに含まれる合計請求額と、請求書データに含まれている複数の商品に対応する複数の商品金額の合算額とが一致していない場合に警告情報を出力するので、請求書内の金額が誤って読み取られていることを経理担当者が認識する。その結果、誤った金額がデータベースに登録されることを防げる。 [Effect of data processing device 1]
As described above, in thedata processing device 1, the total invoice amount included in the invoice data and the total amount of the plurality of product amounts corresponding to the plurality of products included in the invoice data do not match. Since the warning information is output in the case, the accounting staff recognizes that the amount in the invoice is read incorrectly. As a result, it is possible to prevent incorrect amounts from being registered in the database.
以上説明したように、データ処理装置1は、請求書データに含まれる合計請求額と、請求書データに含まれている複数の商品に対応する複数の商品金額の合算額とが一致していない場合に警告情報を出力するので、請求書内の金額が誤って読み取られていることを経理担当者が認識する。その結果、誤った金額がデータベースに登録されることを防げる。 [Effect of data processing device 1]
As described above, in the
データ処理装置1は、例えば、請求書の鑑に記載された合計請求額と請求書の明細に記載された複数の商品金額の合算額とが一致していない場合に警告情報を出力する。したがって、出力部135は、文字列特定部132が文字列を誤認識した場合に加えて、それぞれ異なる請求書の鑑と明細とが混在したことにより、合計請求額と合算額とが一致しない場合にも、警告情報を出力することができる。その結果、鑑と明細が含まれている請求書を読み取る処理にミスが生じたことを経理担当者が把握することも可能になる。
The data processing device 1 outputs warning information when, for example, the total invoice amount described in the invoice and the total amount of a plurality of product amounts described in the invoice details do not match. Therefore, in the output unit 135, in addition to the case where the character string specifying unit 132 misrecognizes the character string, the total invoice amount and the total amount do not match due to the mixture of different invoices and details. Also, warning information can be output. As a result, it becomes possible for the accounting staff to know that an error has occurred in the process of reading the invoice containing the invoice and the details.
以上、本発明を実施の形態を用いて説明したが、本発明の技術的範囲は上記実施の形態に記載の範囲には限定されず、その要旨の範囲内で種々の変形及び変更が可能である。例えば、装置の全部又は一部は、任意の単位で機能的又は物理的に分散・統合して構成することができる。また、複数の実施の形態の任意の組み合わせによって生じる新たな実施の形態も、本発明の実施の形態に含まれる。組み合わせによって生じる新たな実施の形態の効果は、もとの実施の形態の効果を併せ持つ。
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.
例えば、以上の説明においては、文字列特定部132が特定した文字列が、図4又は図5のような請求書の外観で経理端末2に表示される場合を例示したが、経理端末2に文字列が表示される態様は任意である。経理端末2は、コンピュータに登録する対象となる文字列を表形式で表示してもよい。
For example, in the above description, the case where the character string specified by the character string specifying unit 132 is displayed on the accounting terminal 2 with the appearance of the invoice as shown in FIG. 4 or FIG. 5 is illustrated. The mode in which the character string is displayed is arbitrary. The accounting terminal 2 may display a character string to be registered in the computer in a table format.
1 データ処理装置
2 経理端末
3 従業員端末
11 通信部
12 記憶部
13 制御部
131 データ取得部
132 文字列特定部
133 金額特定部
134 比較部
135 出力部 1Data processing device 2 Accounting terminal 3 Employee terminal 11 Communication unit 12 Storage unit 13 Control unit 131 Data acquisition unit 132 Character string specification unit 133 Amount specification unit 134 Comparison unit 135 Output unit
2 経理端末
3 従業員端末
11 通信部
12 記憶部
13 制御部
131 データ取得部
132 文字列特定部
133 金額特定部
134 比較部
135 出力部 1
Claims (12)
- 請求書データを取得するデータ取得部と、
前記請求書データに含まれる合計請求額と、前記請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定する金額特定部と、
前記合計請求額と前記複数の商品金額の合算額とを比較する比較部と、
前記比較部による比較結果が一致していない場合に警告情報を出力する出力部と、
を有するデータ処理装置。 The data acquisition department that acquires invoice data, and
An amount specifying unit that specifies the total invoice amount included in the invoice data and the plurality of product amounts corresponding to the plurality of products included in the invoice data.
A comparison unit that compares the total billed amount with the total amount of the plurality of product amounts,
An output unit that outputs warning information when the comparison results by the comparison unit do not match, and an output unit.
Data processing device with. - 前記請求書データは、前記合計請求額が記載された第1請求書データと、前記複数の商品の明細が記載された第2請求書データと、を含み、
前記比較部は、前記第1請求書データに含まれている前記合計請求額と、前記第1請求書データに記載された請求書番号に関連付けられた請求書番号を含む前記第2請求書データに含まれている前記複数の商品金額の合算額とを比較する、
請求項1に記載のデータ処理装置。 The invoice data includes a first invoice data in which the total invoice amount is described and a second invoice data in which the details of the plurality of products are described.
The comparison unit includes the total invoice amount included in the first invoice data and the second invoice data including the invoice number associated with the invoice number described in the first invoice data. Compare with the total amount of the above-mentioned multiple product prices included in
The data processing apparatus according to claim 1. - 前記比較部は、前記請求書データにおいて前記複数の商品の名称を示す文字列が配置されている方向に記載された前記複数の商品金額を合算することにより前記合算額を算出する、
請求項1又は2に記載のデータ処理装置。 The comparison unit calculates the total amount by summing up the plurality of product prices described in the direction in which the character strings indicating the names of the plurality of products are arranged in the invoice data.
The data processing apparatus according to claim 1 or 2. - 前記請求書データには、前記複数の商品それぞれに関連付けて、税抜金額と税額とが含まれており、
前記比較部は、前記複数の商品それぞれに対応する税抜金額と税額とを合算することにより前記合算額を算出する、
請求項1から3のいずれか一項に記載のデータ処理装置。 The invoice data includes a tax-excluded amount and a tax amount in association with each of the plurality of products.
The comparison unit calculates the total amount by adding the tax-excluded amount and the tax amount corresponding to each of the plurality of products.
The data processing apparatus according to any one of claims 1 to 3. - 前記請求書データには、前記複数の商品それぞれに関連付けて、税抜金額と税額とが含まれており、
前記比較部は、前記複数の商品に対応する複数の前記税抜金額の合算額である第1合算額、及び前記複数の商品に対応する複数の前記税抜金額と複数の前記税額との合算額である第2合算額のそれぞれと、前記合計請求額とを比較し、
前記出力部は、前記第1合算額と前記合計請求額との比較結果、及び前記第2合算額と前記合計請求額との比較結果の両方が一致しない場合に前記警告情報を出力する、
請求項1から4のいずれか一項に記載のデータ処理装置。 The invoice data includes a tax-excluded amount and a tax amount in association with each of the plurality of products.
In the comparison unit, the first total amount, which is the total amount of the plurality of the tax-excluded amounts corresponding to the plurality of products, and the total of the plurality of the tax-excluded amounts corresponding to the plurality of products and the plurality of the tax amounts. Comparing each of the second total amount, which is the amount, with the total billed amount,
The output unit outputs the warning information when both the comparison result between the first total amount and the total billing amount and the comparison result between the second total amount and the total billing amount do not match.
The data processing apparatus according to any one of claims 1 to 4. - 前記出力部は、前記第1合算額と前記合計請求額との比較結果、又は前記第2合算額と前記合計請求額との比較結果が一致した場合、前記第1合算額又は前記第2合算額のどちらが前記合計請求額と一致したかを示す情報を出力する、
請求項5に記載のデータ処理装置。 When the comparison result between the first total amount and the total billing amount or the comparison result between the second total amount and the total billing amount match, the output unit may use the first total amount or the second total amount. Outputs information indicating which of the amounts matches the total billed amount,
The data processing apparatus according to claim 5. - 前記出力部は、前記比較結果が一致していない場合、前記複数の商品金額のいずれかと前記合計請求額とのうち、どちらに誤りがある可能性があるかを示す情報を出力する、
請求項1から6のいずれか一項に記載のデータ処理装置。 If the comparison results do not match, the output unit outputs information indicating which of the plurality of product prices and the total billed amount may be erroneous.
The data processing apparatus according to any one of claims 1 to 6. - 前記比較部は、前記請求書データに含まれている前記複数の商品それぞれの単価と数量とを乗算した結果に基づく額と前記商品金額とを比較した結果に基づいて、前記複数の商品金額のいずれかに誤りがあるか否かを判定し、
前記出力部は、前記複数の商品金額のいずれかに誤りがあると前記比較部が判定した場合、前記複数の商品金額のいずれかに誤りがある蓋然性が高いことを示す情報を出力し、前記複数の商品金額のいずれにも誤りがないと前記比較部が判定した場合、前記合計請求額に誤りがある蓋然性が高いことを示す情報を出力する、
請求項7に記載のデータ処理装置。 The comparison unit determines the amount of the plurality of products based on the result of comparing the amount based on the result of multiplying the unit price and the quantity of each of the plurality of products included in the invoice data with the amount of the product. Determine if there is an error in one of them and
When the comparison unit determines that one of the plurality of product prices is incorrect, the output unit outputs information indicating that there is a high probability that one of the plurality of product prices is incorrect. When the comparison unit determines that there is no error in any of the plurality of product prices, it outputs information indicating that there is a high probability that the total billed amount is incorrect.
The data processing apparatus according to claim 7. - 前記出力部は、前記合計請求額に誤りがある可能性があると前記比較部が判定した場合、前記合計請求額の修正額候補として前記合算額を出力する、
請求項7又は8に記載のデータ処理装置。 When the comparison unit determines that the total billing amount may be incorrect, the output unit outputs the total amount as a correction amount candidate for the total billing amount.
The data processing apparatus according to claim 7. - 前記出力部は、前記複数の商品金額のいずれかに誤りがある可能性があると前記比較部が判定した場合、前記複数の商品金額のうち誤りがある可能性がある一以上の商品金額の修正額候補を出力する、
請求項7から9のいずれか一項に記載のデータ処理装置。 When the comparison unit determines that one of the plurality of product prices may be incorrect, the output unit may have an error in one or more of the plurality of product prices. Output correction amount candidates,
The data processing apparatus according to any one of claims 7 to 9. - コンピュータが、
請求書データを取得するステップと、
前記請求書データに含まれる合計請求額と、前記請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定するステップと、
前記合計請求額と前記複数の商品金額の合算額とを比較するステップと、
比較した結果が一致していない場合に警告情報を出力するステップと、
を実行するデータ処理方法。 The computer
Steps to get invoice data and
A step of specifying the total invoice amount included in the invoice data and the plurality of product amounts corresponding to the plurality of products included in the invoice data.
A step of comparing the total billed amount with the total amount of the plurality of product amounts,
A step to output warning information when the comparison results do not match, and
Data processing method to execute. - コンピュータに、
請求書データを取得するステップと、
前記請求書データに含まれる合計請求額と、前記請求書データに含まれている複数の商品に対応する複数の商品金額と、を特定するステップと、
前記合計請求額と前記複数の商品金額の合算額とを比較するステップと、
比較した結果が一致していない場合に警告情報を出力するステップと、
を実行させるためのプログラム。 On the computer
Steps to get invoice data and
A step of specifying the total invoice amount included in the invoice data and the plurality of product amounts corresponding to the plurality of products included in the invoice data.
A step of comparing the total billed amount with the total amount of the plurality of product amounts,
A step to output warning information when the comparison results do not match, and
A program to execute.
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/JP2020/029657 WO2022029834A1 (en) | 2020-08-03 | 2020-08-03 | Data processing device, data processing method, and program |
JP2020542172A JP6980927B1 (en) | 2020-08-03 | 2020-08-03 | Data processing equipment, data processing methods and programs |
JP2021079170A JP2022028599A (en) | 2020-08-03 | 2021-05-07 | Data processor, method for processing data, and program |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/JP2020/029657 WO2022029834A1 (en) | 2020-08-03 | 2020-08-03 | Data processing device, data processing method, and program |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2022029834A1 true WO2022029834A1 (en) | 2022-02-10 |
Family
ID=78870906
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/JP2020/029657 WO2022029834A1 (en) | 2020-08-03 | 2020-08-03 | Data processing device, data processing method, and program |
Country Status (2)
Country | Link |
---|---|
JP (2) | JP6980927B1 (en) |
WO (1) | WO2022029834A1 (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP7445345B1 (en) | 2023-07-18 | 2024-03-07 | A1A株式会社 | Program, method, information processing device, system |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2000331097A (en) * | 1999-05-20 | 2000-11-30 | Nec Corp | Method and device for additional price tax taking-in and recording medium recording program for this device |
JP2001325562A (en) * | 2000-05-17 | 2001-11-22 | Minolta Co Ltd | Image recognizing device, image forming device, image recognizing method, and computer-readable recording medium with image reocgnizing program stored therein |
JP2014116025A (en) * | 2009-02-10 | 2014-06-26 | Kofax Inc | System, method, and computer program product for determining document validity |
JP2016177349A (en) * | 2015-03-18 | 2016-10-06 | グローリー株式会社 | Business form processing system, business form processing method and program |
JP2019040467A (en) * | 2017-08-25 | 2019-03-14 | キヤノン株式会社 | Information processing apparatus and control method therefor |
JP2019049823A (en) * | 2017-09-08 | 2019-03-28 | キヤノン株式会社 | Image processing apparatus, image processing method and program |
-
2020
- 2020-08-03 JP JP2020542172A patent/JP6980927B1/en active Active
- 2020-08-03 WO PCT/JP2020/029657 patent/WO2022029834A1/en active Application Filing
-
2021
- 2021-05-07 JP JP2021079170A patent/JP2022028599A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2000331097A (en) * | 1999-05-20 | 2000-11-30 | Nec Corp | Method and device for additional price tax taking-in and recording medium recording program for this device |
JP2001325562A (en) * | 2000-05-17 | 2001-11-22 | Minolta Co Ltd | Image recognizing device, image forming device, image recognizing method, and computer-readable recording medium with image reocgnizing program stored therein |
JP2014116025A (en) * | 2009-02-10 | 2014-06-26 | Kofax Inc | System, method, and computer program product for determining document validity |
JP2016177349A (en) * | 2015-03-18 | 2016-10-06 | グローリー株式会社 | Business form processing system, business form processing method and program |
JP2019040467A (en) * | 2017-08-25 | 2019-03-14 | キヤノン株式会社 | Information processing apparatus and control method therefor |
JP2019049823A (en) * | 2017-09-08 | 2019-03-28 | キヤノン株式会社 | Image processing apparatus, image processing method and program |
Also Published As
Publication number | Publication date |
---|---|
JPWO2022029834A1 (en) | 2022-02-10 |
JP6980927B1 (en) | 2021-12-15 |
JP2022028599A (en) | 2022-02-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2019194028A1 (en) | Image processing device, image processing method, and storage medium for storing program | |
CN110472939A (en) | A kind of supply chain business paper automatic check device, system and method | |
JPWO2019008766A1 (en) | Voucher processing system and voucher processing program | |
CN115358751B (en) | Automatic auditing method and device for transaction receipt and electronic equipment | |
WO2022029834A1 (en) | Data processing device, data processing method, and program | |
JP6576728B2 (en) | Accounting system, accounting method, program and guidance report | |
JP2019185139A (en) | Image processing device, image processing method, and program | |
CN109343844B (en) | Method for comparing and correcting data based on Flex bill | |
WO2019193923A1 (en) | Image processing device, image processing method and recording medium | |
JP6810303B1 (en) | Data processing equipment, data processing method and data processing program | |
WO2021260891A1 (en) | Invoice management device, invoice management method, and program | |
JP6507459B2 (en) | Accounting system | |
JP6810302B1 (en) | Data processing equipment, data processing methods and programs | |
JP6848134B1 (en) | Data processing equipment, data processing methods and programs | |
JP7111143B2 (en) | Image processing device, image processing method and program | |
JP2021093222A (en) | Accounting processor, accounting processing system, method for accounting processing, and program | |
JP2001005886A (en) | Data processor and storage medium | |
JP4230620B2 (en) | Order data confirmation device | |
WO2022049689A1 (en) | Data processing device, data processing method, and program | |
WO2022074793A1 (en) | Data processing device, data processing method, and program | |
JP6858420B1 (en) | Accounting equipment, accounting systems, accounting methods and programs | |
CN110673888B (en) | Verification method and device for configuration file | |
JP6639628B2 (en) | Commodity sales data processing device and program | |
AU2009344884B2 (en) | System and method for creating coupon offers and barcodes | |
CN115862047A (en) | OCR-based (optical character recognition-based) manifest identification and calibration method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
ENP | Entry into the national phase |
Ref document number: 2020542172 Country of ref document: JP Kind code of ref document: A |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 20948267 Country of ref document: EP Kind code of ref document: A1 |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 20948267 Country of ref document: EP Kind code of ref document: A1 |