WO2022003977A1 - Data processing device, data processing method, and program - Google Patents

Data processing device, data processing method, and program Download PDF

Info

Publication number
WO2022003977A1
WO2022003977A1 PCT/JP2020/026268 JP2020026268W WO2022003977A1 WO 2022003977 A1 WO2022003977 A1 WO 2022003977A1 JP 2020026268 W JP2020026268 W JP 2020026268W WO 2022003977 A1 WO2022003977 A1 WO 2022003977A1
Authority
WO
WIPO (PCT)
Prior art keywords
invoice
department
past
data
issued
Prior art date
Application number
PCT/JP2020/026268
Other languages
French (fr)
Japanese (ja)
Inventor
顕 松田
鴻鵬 葛
智 小俣
啓太郎 森
Original Assignee
ファーストアカウンティング株式会社
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by ファーストアカウンティング株式会社 filed Critical ファーストアカウンティング株式会社
Priority to PCT/JP2020/026268 priority Critical patent/WO2022003977A1/en
Priority to JP2020537258A priority patent/JP6805394B1/en
Priority to JP2020200792A priority patent/JP2022013578A/en
Publication of WO2022003977A1 publication Critical patent/WO2022003977A1/en

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
    • 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 data based on an invoice.
  • the accountant cannot determine from the information on the invoice which department is the invoice for the goods or services involved. rice field. Also, if the company that received the invoice had multiple departments, the accountant could not identify which department had to bear the costs. Therefore, there is a problem that it takes time and effort for the accounting staff to identify the department related to the invoice.
  • an object of the present invention is to provide a data processing device, a data processing method, and a program for an accounting person to easily identify a department related to an invoice. do.
  • the data acquisition unit for acquiring invoice data and the contents of one or more items included in the invoice data are described in the department or invoice that issued the invoice.
  • the issuing department that issued the invoice corresponding to the invoice data, or the invoice by comparing the contents of one or more items contained in the specified past invoice to the department paying the invoice amount. It has a specific unit that specifies at least one of the payment departments that pay the invoice amount, and an output unit that outputs department information indicating the issuing department or the payment department specified by the specific unit.
  • the data processing device is an invoice in which the contents of one or more items included in the plurality of past invoice data corresponding to the plurality of past invoices and the department that issued the plurality of past invoices are associated with each other. Further having a storage unit for storing a database, the specific unit identifies and specifies the past invoice data having contents similar to the contents of one or more items included in the invoice data in the invoice database. The department that issued the past invoice corresponding to the past invoice data may be specified as the issuing department.
  • the data processing device is associated with the content of one or more items contained in the plurality of past invoice data corresponding to the plurality of past invoices and the department that paid the cost for the plurality of past invoices. Further having a storage unit for storing an invoice database, the specific unit identifies the past invoice data having a content similar to the content of one or more items included in the invoice data in the invoice database. , The department that paid the cost for the past invoice corresponding to the specified past invoice data may be specified as the payment department.
  • the specific unit has contents similar to the contents of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit. Based on the allocation rate associated with the past invoice data, the payment amount by the plurality of departments or the plurality of projects associated with the past invoice data may be specified.
  • the department further has a storage unit for storing the invoice database associated with the department, and the specific unit is included in the invoice data among the plurality of past invoice data stored in the storage unit.
  • the specific unit corresponds to the issuance interval of the past invoice immediately before corresponding to the same product as the product indicated by the invoice data acquired by the data acquisition unit, and the same product as the product indicated by the invoice data.
  • the department indicated by the payment department information associated with the two or more past invoices is designated as the payment department. It may be specified.
  • the specific unit may refer to at least one of the issuing department or the payment department by referring to the contents of one or more items included in the past invoice issued by the company that issued the invoice corresponding to the invoice data. May be specified.
  • the output unit may output reliability information indicating the probability that the specific unit has correctly specified the issuing department or the payment department in association with the invoice data.
  • the step of acquiring the invoice data executed by the computer and the contents of one or more items included in the invoice data are described in the department that issued the invoice, or the department that issued the invoice.
  • the invoice corresponding to the invoice data is displayed. It has a step of specifying at least one of the issuing issuance department or the payment department that pays the invoice amount stated in the invoice, and a step of outputting department information indicating the specified issuance department or the payment department. ..
  • the program of the third aspect of the present invention applies a computer to a data acquisition unit that acquires invoice data, the contents of one or more items included in the invoice data, to the department that issued the invoice, or the invoice.
  • the issuing department that issued the invoice corresponding to the invoice data, or the invoice by comparing the contents of one or more items contained in the specified past invoice to the department paying the stated invoice amount. It functions as a specific unit that specifies at least one of the payment departments that pay the stated invoice, and an output unit that outputs department information indicating the issuing department or the payment department specified by the specific unit.
  • FIG. 1 is a diagram for explaining the configuration of the data processing system S.
  • the data processing system S is described in the invoice based on the contents described in the invoice sent to the billing company that is the business operator who purchased the goods or services (hereinafter referred to as "goods, etc.”). It is a system for identifying the department in the billing company that was involved in the provision of the product, etc., or the department in the billing company that was involved in the ordering of the product, etc.
  • the data processing system S is, for example, a system for supporting the accounting department of the billing company, and can be used by the accounting staff.
  • the data processing system S includes a data processing device 1, an accounting terminal 2, an employee terminal 3, and a billing source terminal 4.
  • the data processing device 1, the accounting terminal 2, the employee terminal 3, and the billing source terminal 4 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 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 acquires a file containing image data from the accounting terminal 2, the employee terminal 3, or the billing source terminal 4, and creates invoice data based on the character string specified in the acquired image data. Also, a file containing invoice data may be acquired from the accounting terminal 2, the employee terminal 3, or the billing source terminal 4.
  • the data processing device 1 executes a process for identifying the department in the billing company involved in the provision of the product or the like described in the invoice, or the department in the billing company involved in the ordering of the product or the like. ..
  • the data processing device 1 newly receives the invoice data by the billing company by referring to the past invoice data similar to the invoice data newly received by the billing company among the plurality of stored invoice data in the past. Identify the department related to the invoice (that is, the department within the billing company involved in the provision of the goods, etc. stated in the invoice, or the department within the billing company involved in the ordering of the goods, etc.).
  • the data processing device 1 stores the divisional allocation rate of the invoice amount stated in the invoice in association with the invoice received by the invoice in the past.
  • the data processing device 1 distributes the bills by department corresponding to the past bills stored in the data processing device 1.
  • the departmental allocation rate of the invoice amount newly received by the billing company is specified.
  • the data processing device 1 associates the invoice data with the specified department name or information indicating the allocation rate for each department, and transmits or prints the invoice data to the accounting terminal 2.
  • 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.
  • 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 the 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 designated by the accounting person. The accounting terminal 2 displays, for example, a department name or a department-specific allocation rate specified by the data processing device 1. Although 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.
  • the billing terminal 4 is a computer used by an employee of the billing company that has received an order for a product or the like.
  • the billing source terminal 4 transmits the image data of the invoice to the predetermined address of the billing company.
  • the predetermined address is, for example, the address of the data processing device 1, the accounting terminal 2, or the employee terminal 3.
  • FIG. 2 is a conceptual diagram showing the relationship between the billing source company and the billing destination company. It is assumed that each of the billing company and the billing company has multiple departments. The billing company orders products, etc. from one of the multiple departments of the billing company. Then, the billing company issues an invoice after the department that has received the order for the product or the like delivers the product or the like among the plurality of departments.
  • FIGS. 3 to 5 are diagrams showing an example of an invoice received by the billing company.
  • the invoice is issued by Ace Machinery Co., Ltd., it does not indicate which of the multiple departments within Ace Machinery Co., Ltd. was in charge of arranging products.
  • the accounting staff of the billing company can determine which department of the billing company or which person in charge has decided the billing content, and which department of the billing company has ordered the product, etc. just by looking at the invoice. Or, it is not possible to know which department of the billing company should bear the cost. In such a case, the data processing device 1 enables the accounting staff to grasp these points based on the contents of the invoice.
  • the data processing device 1 is sold based on the product names described in the invoice shown in FIG. 3 being "Measuring instrument A maintenance" and “Measuring instrument A probe". It is specified that the person in charge belongs to the Tokyo Sales Department of Ace Machinery Co., Ltd., and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd. Based on the product names described in the invoice shown in FIG. 4 being "Measuring instrument B maintenance" and “Measuring instrument B probe", the data processing apparatus 1 is sold by Ace Machinery Co., Ltd. It is specified that they belong to the Yokohama Sales Department of Tanaka Research Co., Ltd. and that the person in charge of ordering these belongs to the Circuit Development Department of Tanaka Research Co., Ltd.
  • 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 has a data acquisition unit 131, a specific unit 132, and an output unit 133.
  • the communication unit 11 has a communication controller for transmitting and receiving various data to and from the accounting terminal 2 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 133 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 stores the invoice database. Specifically, the storage unit 12 includes the contents of one or more items included in the plurality of past invoice data corresponding to the plurality of past invoices issued in the past, the department that issued the plurality of past invoices, and the unit. Stores the invoice database associated with the department that paid for multiple past invoices.
  • the storage unit 12 stores the issuing department information for identifying the department that issued the plurality of past invoices in association with each of the plurality of past invoice data.
  • the storage unit 12 may store payment department information for identifying the department that paid the cost for the invoice in association with each of the plurality of past invoice data.
  • the issuing department information and the payment department information may be the department name or the code information given to the department.
  • the storage unit 12 stores the names of the plurality of departments or the plurality of projects for which the costs for the invoices have been paid and the allocation rates of the plurality of departments or the plurality of projects in association with each of the plurality of past invoice data. do.
  • the allocation rate is the ratio paid by each department to the invoice amount stated on the invoice.
  • FIG. 7 is a diagram showing an example of records in the invoice database stored in the storage unit 12.
  • the invoice number, billing company name, billing department name, sales person name, telephone number and fax number of the billing company, ordering date, delivery date, billing date, product name, unit price, The quantity, payment department, orderer, and cost allocation rate are associated.
  • the telephone number and the FAX number may be the numbers described in the invoice, or may be the telephone number and the FAX number registered in advance in association with the name of the sales person.
  • FIG. 7A is a record in which the same product as the product described in the invoice shown in FIG. 3 is described and corresponds to the past invoice issued about one year ago.
  • FIG. 7B is a record in which the same product as the product described in the invoice shown in FIG. 4 is described and corresponds to a past invoice issued about one year ago.
  • the control unit 13 has, for example, a CPU (Central Processing Unit).
  • the control unit 13 functions as a data acquisition unit 131, a specific unit 132, and an output unit 133 by executing a program stored in the storage unit 12.
  • the data acquisition unit 131 acquires various data received by the communication unit 11.
  • the data acquisition unit 131 acquires the image data or the invoice data of the invoice transmitted from the accounting terminal 2 or the employee terminal 3.
  • the data acquisition unit 131 extracts a character string included in the invoice by performing OCR processing, and describes the invoice based on the extracted character string. Identify the content.
  • the data acquisition unit 131 specifies, for example, the name of the billing company, the contact information of the billing company, the name of the product to be billed, the unit price, the quantity, the amount, and the transfer destination account included in the invoice.
  • the data acquisition unit 131 registers the contents of the specified invoice in the invoice database.
  • the specific unit 132 corresponds to the invoice data acquired by the data acquisition unit 131 (hereinafter, may be referred to as “specific target invoice data”) by referring to the past invoice data stored in the invoice database. Identify at least one of the issuing departments that issued the invoice or the payment department that pays the invoice amount stated on the invoice.
  • the issuing department is the department in charge of providing the products, etc. described in the invoice at the company that issued the invoice, or the employee in charge of providing the products, etc.
  • the payment department is the department in charge of ordering the products, etc. described in the invoice at the company that received the invoice, or the employee in charge of ordering the products, etc.
  • the specific unit 132 puts the contents of one or more items included in the specific target invoice data into a past invoice in which the department that issued the invoice or the department that pays the invoice amount stated in the invoice is specified. Identify at least one of the issuing departments that issued the invoice corresponding to the specified invoice data or the payment department that pays the invoice amount stated on the invoice by comparing it to the content of one or more items included. ..
  • the contents of one or more items included in the invoice data are the contact information of the billing company, the name (product name) of the product to be billed, the ordering date, the delivery date, the billing date, the unit price, the quantity, the amount or the transfer destination account. At least one of.
  • the specifying unit 132 specifies past invoice data having contents similar to the contents of one or more items included in the invoice data in the invoice database.
  • the specific unit 132 refers to the department that issued the past invoice corresponding to the specified past invoice data or the department that paid the cost for the past invoice, the department that issued the invoice corresponding to the specified target invoice data, or the relevant department. Identify as the department that pays for the invoice.
  • the specific unit 132 is an issuing unit associated with the past invoice data having a content similar to the content of one or more items included in the specific target invoice data among the plurality of past invoice data stored in the storage unit 12. Identify the department indicated by the information as the department that issued the invoice. Further, the specific unit 132 is associated with the past invoice data having a content similar to the content of one or more items included in the specific target invoice data among the plurality of past invoice data stored in the storage unit 12. The department indicated by the payment department information is specified as the department that pays the invoice amount stated on the invoice.
  • the specific unit 132 determines the allocation rate associated with the past invoice data having a content similar to the content of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit 12. Based on this, the payment amount by multiple departments or multiple projects associated with the past invoice data may be specified. By automatically specifying the allocation rate of the invoice data by the specific unit 132, the efficiency of the work of the accounting staff to calculate the burden amount for each department of the payment amount is improved.
  • the specific unit 132 among the plurality of past invoice data registered in the invoice database, the contents of a predetermined number or more of the plurality of items included in the past invoice data correspond to the specific target invoice data. Select one or more past invoice data that matches the content of the item as past invoice data with similar content. When a plurality of past invoices are selected, the specific unit 132 selects the past invoice data having more matching items (that is, the most similar past invoice data).
  • the specific unit 132 has, for example, the past invoice data whose product name and quantity match the product name and quantity included in the specified target invoice data among a plurality of past invoice data registered in the invoice database. Select.
  • the identification unit 132 identifies at least one of the issuing department name, the payment department name, or the allocation rate registered in the invoice database in association with the selected past invoice data.
  • the specific unit 132 includes the date when the storage unit 12 issues a plurality of past invoices or the date when the product related to the plurality of past invoices is ordered, the department which issued the plurality of past invoices, and the plurality of past invoices. Utilizing the fact that the department that paid the cost for the invoice and remembers the associated invoice database, based on the date related to the purchase of the item, such as the order date or delivery date of the item, etc. , The past invoice data corresponding to the specified target invoice data may be specified.
  • the specific unit 132 has issued two or more past invoices having contents similar to the contents of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit 12.
  • the predetermined condition is, for example, a condition set by an accounting person or stored in the storage unit 12 in advance, and an invoice is issued under the same name over a predetermined period in the past (for example, one year). That is, the same amount of invoice has been issued more than once in the past, and the same name or amount of invoice has been issued at regular intervals.
  • the specific unit 132 has an issue interval between the product, etc. indicated by the specific target invoice data and the past invoice immediately before corresponding to the same product, etc., and the same product, etc. as the product, etc. indicated by the specific target invoice data. If the difference from the issuance interval of two or more past invoices corresponding to is within a predetermined range that can be regarded as the same, the department indicated by the payment department information associated with the two or more past invoice data is billed. It may be specified as the department that pays the invoice stated in the invoice.
  • the predetermined range is a range of a period sufficiently smaller than the issuance interval. For example, when the issuance interval is one year, the predetermined range is within one month. If the issuance interval is one year, the predetermined range may be within one week.
  • a plurality of past invoices for the same product ordered in the past by the same payment department are issued every year, and the specified target invoice is issued about one year after the latest past invoice.
  • the payment department associated with the past invoice is identified as the department that ordered the goods for the specified invoice data.
  • the specific unit 132 is a past invoice issued by a company that has issued an invoice corresponding to the specified target invoice data among a plurality of past invoice data registered in the invoice database.
  • the past invoice data corresponding to the invoice may be specified.
  • the specifying unit 132 identifies at least one of the invoice issuing department or the payment department corresponding to the specified target invoice data by referring to the contents of one or more items included in the specified past invoice data. do.
  • the specific unit 132 may preferentially select the past invoice data that matches the contact information or the transfer destination account number in addition to the company name that issued the specific target invoice. If the contact or transfer account numbers match, it is highly probable that the issuing department and the payment department match. Therefore, by operating the specific unit 132 in this way, the specific accuracy of the issuing department and the payment department can be improved. improves.
  • the specific unit 132 refers to the record shown in FIG. 7 (a), and the person in charge of selling the product described in the invoice shown in FIG. 3 is Ace Machinery Co., Ltd. It is specified that they belong to the Tokyo Sales Department and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd. Further, in the case of the invoice shown in FIG. 4, the specific unit 132 refers to the record shown in FIG. 7 (b), so that the person in charge of selling the product described in the invoice shown in FIG. 4 can use the ace machine stock. It is specified that they belong to the Yokohama sales department of the company and that the person in charge of ordering these belongs to the circuit development department of Tanaka Research Co., Ltd.
  • the specific unit 132 when there is no past invoice in which all of the plurality of products shown in the invoice match, as in the invoice shown in FIG. 5, some of the plurality of products match. You may identify the person in charge of selling and ordering some goods based on one or more past invoices.
  • the specific unit 132 refers to the record shown in FIG. 7 (a), and the sales person in charge of "measurement instrument A maintenance" and “measurement instrument A probe” is an ace machine. It is specified that they belong to the Tokyo Sales Department of Tanaka Research Co., Ltd. and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd.
  • FIG. 7 (a) the sales person in charge of "measurement instrument A maintenance" and "measurement instrument A probe” is an ace machine. It is specified that they belong to the Tokyo Sales Department of Tanaka Research Co., Ltd. and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd.
  • FIG. 7 (a) the sales person in
  • the specifying unit 132 may calculate the reliability indicating the certainty. For example, the more the number of items included in the specified target invoice data that match the contents contained in the past invoice data, the more the issuing department or the payment department has the specific unit 132. It is judged that there is a high probability that the invoice is correctly specified, and the reliability is increased.
  • the specific unit 132 may determine the reliability by weighting each item. Further, in the specific unit 132, the issue interval between the product or the like indicated by the specific target invoice data and the past invoice immediately before corresponding to the same product or the like is the same as the product or the like indicated by the specific target invoice data. Even if the issuance interval of a plurality of corresponding past invoices is almost the same, the reliability may be higher than that of the other cases.
  • the output unit 133 outputs the department information indicating the invoice issuing department or the payment department specified by the specific unit 132.
  • the output unit 133 may output reliability information indicating the probability that the specific unit 132 correctly identifies the issuing department or the payment department in association with the billing data.
  • the reliability information is information indicating the reliability calculated by the specific unit 132, and the probability that the issuing department specified by the specific unit 132 is the department actually in charge of selling the product or the like, or the specific unit 132 specified. This is information indicating the degree of correspondence with the probability that the payment department is the department that was actually in charge of ordering products and the like.
  • FIG. 8 is a diagram showing an example of information output by the output unit 133.
  • the invoice number, the billing source company name, the sales department, the sales person, the payment department, the ordering person, the invoice amount, the allocation rate, and the reliability are displayed in association with each other.
  • the output unit 133 may further display the contact information of the invoice issuing department or sales person or the payment department or ordering person.
  • the output unit 133 may output the reason why the reliability is low, as in the invoice of the invoice number S100002251 in FIG.
  • the accountant can easily contact the person in charge of selling the product (that is, the person involved in issuing the invoice) or the person in charge of ordering the product described in the invoice. Can be taken.
  • the accounting staff can easily make journal entries for each department of the billed amount.
  • the accounting staff can flexibly respond by changing the method of contacting the sales staff or the ordering staff depending on the magnitude of the reliability.
  • FIG. 9 is a flowchart showing the operation flow of the data processing device 1. The flowchart shown in FIG. 9 starts from the time when the invoice arrives at the billing company that uses the data processing device 1.
  • the data acquisition unit 131 acquires invoice data from the accounting terminal 2 or another terminal (S11). Subsequently, the specifying unit 132 refers to the past invoice data registered in the invoice database (S12), and is there any past invoice data similar to the content included in the specified target invoice data acquired in S11? It is determined whether or not (S13). The specifying unit 132 may execute the determination process of S13 on condition that the accounting terminal 2 receives an instruction to specify a sales person or an ordering person corresponding to the specified target invoice data.
  • the process is terminated.
  • the sales department sales person in charge of the product or the like related to the specific target invoice data may be used by the various methods described above.
  • the payment department which may be the person in charge of ordering
  • the output unit 133 outputs information about the specified department (S15).
  • the output unit 133 associates each of the plurality of payment departments with each other.
  • the allocation rate is output (S17).
  • the specific unit 132 specifies that there is only one payment department to bear the cost of the product or the like related to the specific target invoice data (NO in S16)
  • the specific unit 132 ends the process. In this case, the output unit 133 may output information indicating that the allocation rate of one payment department is 100%.
  • the specific unit 132 has specified the department that issued the invoice or the department that pays the invoice amount stated in the invoice for the contents of one or more items included in the specific target invoice data. At least the issuing department that issued the invoice corresponding to the specified invoice data, or the paying department that pays the invoice amount stated in the invoice, by comparing it with the content of one or more items contained in the past invoice. Identify one. Then, the output unit 133 outputs information indicating the issuing department or the payment department specified by the specific unit 132. By operating the data processing device 1 in this way, if the company that issued the invoice has multiple departments, or if the company that received the invoice has multiple departments, the accountant will be invoiced. Work efficiency is improved because related departments can be easily identified.

Abstract

This data processing device 1 has: a data acquiring unit 131 that acquires invoice data; a specifying unit 132 that compares the contents of one or more items included in the invoice data with the contents of one or more items included in a past invoice in which a department that has issued an invoice and a department that is to pay an invoice amount written on the invoice are specified, thereby specifying at least any of an issuing department that issued the invoice corresponding to the invoice data acquired by the data acquiring unit 131 or a payment department that pays the invoiced amount written on the invoice; and an output unit 133 that outputs department information which indicates the issuing department or the payment department specified by the specifying unit 132.

Description

データ処理装置、データ処理方法及びプログラムData processing equipment, data processing methods and programs
　本発明は、請求書に基づくデータを処理するためのデータ処理装置、データ処理方法及びプログラムに関する。 The present invention relates to a data processing device, a data processing method and a program for processing data based on an invoice.
　従来、請求書の発行者と配賦先コードとを予め紐づけておき、請求書の発行者に基づいて配賦額を決定する技術が知られている（例えば、特許文献１を参照）。 Conventionally, a technique has been known in which an invoice issuer and an allocation destination code are linked in advance and the allocation amount is determined based on the invoice issuer (see, for example, Patent Document 1).
特開２０２０－０１３３５８号公報Japanese Unexamined Patent Publication No. 2020-0133358
　請求書を発行する企業に複数の部門がある場合、経理担当者は、請求書に記載された情報からは、どの部門が関わった商品又はサービスに対する請求書であるかを特定することができなかった。また、請求書を受け取った企業に複数の部門がある場合、経理担当者は、どの部門が費用を負担する必要があるかを特定することができなかった。したがって、経理担当者が請求書に関連する部門を特定するために手間がかかるという問題が生じていた。 If the company issuing the invoice has multiple departments, the accountant cannot determine from the information on the invoice which department is the invoice for the goods or services involved. rice field. Also, if the company that received the invoice had multiple departments, the accountant could not identify which department had to bear the costs. Therefore, there is a problem that it takes time and effort for the accounting staff to identify the department related to the invoice.
　そこで、本発明はこれらの点に鑑みてなされたものであり、経理担当者が請求書に関連する部門を特定しやすくするためのデータ処理装置、データ処理方法及びプログラムを提供することを目的とする。 Therefore, the present invention has been made in view of these points, and an object of the present invention is to provide a data processing device, a data processing method, and a program for an accounting person to easily identify a department related to an invoice. do.
　本発明の第１の態様のデータ処理装置は、請求書データを取得するデータ取得部と、前記請求書データに含まれる一以上の項目の内容を、請求書を発行した部門又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較することにより、前記請求書データに対応する請求書を発行した発行部門、又は前記請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する特定部と、前記特定部が特定した前記発行部門又は前記支払部門を示す部門情報を出力する出力部と、を有する。 In the data processing device of the first aspect of the present invention, the data acquisition unit for acquiring invoice data and the contents of one or more items included in the invoice data are described in the department or invoice that issued the invoice. The issuing department that issued the invoice corresponding to the invoice data, or the invoice, by comparing the contents of one or more items contained in the specified past invoice to the department paying the invoice amount. It has a specific unit that specifies at least one of the payment departments that pay the invoice amount, and an output unit that outputs department information indicating the issuing department or the payment department specified by the specific unit.
　前記データ処理装置は、複数の前記過去請求書に対応する複数の過去請求書データに含まれる一以上の項目の内容と、前記複数の過去請求書を発行した部門と、が関連付けられた請求書データベースを記憶する記憶部をさらに有し、前記特定部は、前記請求書データベースにおいて、前記請求書データに含まれる一以上の項目の内容に類似する内容の前記過去請求書データを特定し、特定した前記過去請求書データに対応する前記過去請求書を発行した部門を前記発行部門として特定してもよい。 The data processing device is an invoice in which the contents of one or more items included in the plurality of past invoice data corresponding to the plurality of past invoices and the department that issued the plurality of past invoices are associated with each other. Further having a storage unit for storing a database, the specific unit identifies and specifies the past invoice data having contents similar to the contents of one or more items included in the invoice data in the invoice database. The department that issued the past invoice corresponding to the past invoice data may be specified as the issuing department.
　前記データ処理装置は、複数の前記過去請求書に対応する複数の過去請求書データに含まれる一以上の項目の内容と、前記複数の過去請求書に対する費用を支払った部門と、が関連付けられた請求書データベースを記憶する記憶部をさらに有し、前記特定部は、前記請求書データベースにおいて、前記請求書データに含まれる一以上の項目の内容に類似する内容の前記過去請求書データを特定し、特定した前記過去請求書データに対応する前記過去請求書に対する費用を支払った部門を前記支払部門として特定してもよい。 The data processing device is associated with the content of one or more items contained in the plurality of past invoice data corresponding to the plurality of past invoices and the department that paid the cost for the plurality of past invoices. Further having a storage unit for storing an invoice database, the specific unit identifies the past invoice data having a content similar to the content of one or more items included in the invoice data in the invoice database. , The department that paid the cost for the past invoice corresponding to the specified past invoice data may be specified as the payment department.
　複数の前記過去請求書に対応する複数の過去請求書データそれぞれに関連付けて、前記過去請求書に対する費用を支払った複数の部門又は複数のプロジェクトと、前記複数の部門又は前記複数のプロジェクトの配賦率を記憶する記憶部をさらに有し、前記特定部は、前記記憶部に記憶された前記複数の過去請求書データのうち、前記請求書データに含まれる一以上の項目の内容に類似する内容の前記過去請求書データに関連付けられた前記配賦率に基づいて、当該過去請求書データに関連付けられた前記複数の部門又は前記複数のプロジェクトによる支払額を特定してもよい。 Allocation of the plurality of departments or projects for which the costs for the past invoices and the plurality of departments or the plurality of projects are associated with each of the plurality of past invoice data corresponding to the plurality of the past invoices. Further having a storage unit for storing the rate, the specific unit has contents similar to the contents of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit. Based on the allocation rate associated with the past invoice data, the payment amount by the plurality of departments or the plurality of projects associated with the past invoice data may be specified.
　複数の前記過去請求書が発行された日又は前記複数の過去請求書に係る商品が発注された日と、前記複数の過去請求書を発行した部門及び前記複数の過去請求書に対する費用を支払った部門と、が関連付けられた請求書データベースを記憶する記憶部をさらに有し、前記特定部は、前記記憶部に記憶された前記複数の過去請求書データのうち、前記請求書データに含まれる一以上の項目の内容に類似する内容の２以上の前記過去請求書が発行された日又は前記２以上の複数の過去請求書に係る商品が発注された日の関係が所定の条件を満たす場合に、前記２以上の過去請求書に関連付けられた支払部門情報が示す部門を前記支払部門として特定してもよい。 The date on which the plurality of past invoices were issued or the date on which the goods related to the plurality of past invoices were ordered, the department that issued the plurality of past invoices, and the expenses for the plurality of past invoices were paid. The department further has a storage unit for storing the invoice database associated with the department, and the specific unit is included in the invoice data among the plurality of past invoice data stored in the storage unit. When the relationship between the date when two or more of the past invoices with contents similar to the contents of the above items are issued or the date when the goods related to the two or more past invoices are ordered meets the predetermined conditions. , The department indicated by the payment department information associated with the two or more past invoices may be specified as the payment department.
　前記特定部は、前記データ取得部が取得した前記請求書データが示す商品と同一の商品に対応する直前の過去請求書との発行間隔と、前記請求書データが示す商品と同一の商品に対応する前記２以上の過去請求書の発行間隔との差が同じであるとみなせる所定範囲内である場合に、前記２以上の過去請求書に関連付けられた支払部門情報が示す部門を前記支払部門として特定してもよい。 The specific unit corresponds to the issuance interval of the past invoice immediately before corresponding to the same product as the product indicated by the invoice data acquired by the data acquisition unit, and the same product as the product indicated by the invoice data. When the difference from the issuance interval of the two or more past invoices is within a predetermined range, the department indicated by the payment department information associated with the two or more past invoices is designated as the payment department. It may be specified.
　前記特定部は、前記請求書データに対応する請求書を発行した企業が発行した前記過去請求書に含まれる一以上の項目の内容を参照することにより、前記発行部門又は前記支払部門の少なくともいずれかを特定してもよい。 The specific unit may refer to at least one of the issuing department or the payment department by referring to the contents of one or more items included in the past invoice issued by the company that issued the invoice corresponding to the invoice data. May be specified.
　前記出力部は、前記請求書データに関連付けて、前記特定部が前記発行部門又は前記支払部門を正しく特定した蓋然性を示す信頼度情報を出力してもよい。 The output unit may output reliability information indicating the probability that the specific unit has correctly specified the issuing department or the payment department in association with the invoice data.
　本発明の第２の態様のデータ処理方法は、コンピュータが実行する、請求書データを取得するステップと、前記請求書データに含まれる一以上の項目の内容を、請求書を発行した部門、又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較するステップと、比較した結果に基づいて、前記請求書データに対応する請求書を発行した発行部門、又は前記請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定するステップと、特定した前記発行部門又は前記支払部門を示す部門情報を出力するステップと、を有する。 In the data processing method of the second aspect of the present invention, the step of acquiring the invoice data executed by the computer and the contents of one or more items included in the invoice data are described in the department that issued the invoice, or the department that issued the invoice. Based on the step of comparing the contents of one or more items contained in the specified past invoice by the department paying the invoice amount stated in the invoice, and the result of the comparison, the invoice corresponding to the invoice data is displayed. It has a step of specifying at least one of the issuing issuance department or the payment department that pays the invoice amount stated in the invoice, and a step of outputting department information indicating the specified issuance department or the payment department. ..
　本発明の第３の態様のプログラムは、コンピュータを、請求書データを取得するデータ取得部、前記請求書データに含まれる一以上の項目の内容を、請求書を発行した部門、又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較することにより、前記請求書データに対応する請求書を発行した発行部門、又は前記請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する特定部、及び前記特定部が特定した前記発行部門又は前記支払部門を示す部門情報を出力する出力部、として機能させる。 The program of the third aspect of the present invention applies a computer to a data acquisition unit that acquires invoice data, the contents of one or more items included in the invoice data, to the department that issued the invoice, or the invoice. The issuing department that issued the invoice corresponding to the invoice data, or the invoice, by comparing the contents of one or more items contained in the specified past invoice to the department paying the stated invoice amount. It functions as a specific unit that specifies at least one of the payment departments that pay the stated invoice, and an output unit that outputs department information indicating the issuing department or the payment department specified by the specific unit.
　本発明によれば、経理担当者が請求書に関連する部門を特定しやすくなるという効果を奏する。 According to the present invention, there is an effect that the accounting staff can easily identify the department related to the invoice.
データ処理システムＳの構成を説明するための図である。It is a figure for demonstrating the structure of the data processing system S. 請求元企業と請求先企業との関係を示す概念図である。It is a conceptual diagram which shows the relationship between the billing source company and the billing destination company. 請求先企業が受け取った請求書の例を示す図である。It is a figure which shows the example of the invoice received by the billing company. 請求先企業が受け取った請求書の例を示す図である。It is a figure which shows the example of the invoice received by the billing company. 請求先企業が受け取った請求書の例を示す図である。It is a figure which shows the example of the invoice received by the billing company. データ処理装置１の構成を示す図である。It is a figure which shows the structure of the data processing apparatus 1. 記憶部が記憶している請求書データベース内のレコードの一例を示す図である。It is a figure which shows an example of the record in the invoice database which a storage part stores. 出力部が出力する情報の一例を示す図である。It is a figure which shows an example of the information which an output part outputs. データ処理装置の動作の流れを示すフローチャートである。It is a flowchart which shows the operation flow of a data processing apparatus.
［データ処理システムＳの概要］
　図１は、データ処理システムＳの構成を説明するための図である。データ処理システムＳは、商品又はサービス（以下、「商品等」という）を購入した事業者である請求先企業に送られてきた請求書に記載された内容に基づいて、請求書に記載された商品等の提供に関わった請求元企業内の部門、又は当該商品等の発注に関わった請求先企業内の部門を特定するためのシステムである。データ処理システムＳは、例えば請求先企業の経理部門を支援するためのシステムであり、経理担当者が利用することができる。 [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 described in the invoice based on the contents described in the invoice sent to the billing company that is the business operator who purchased the goods or services (hereinafter referred to as "goods, etc."). It is a system for identifying the department in the billing company that was involved in the provision of the product, etc., or the department in the billing company that was involved in the ordering of the product, etc. The data processing system S is, for example, a system for supporting the accounting department of the billing company, and can be used by the accounting staff.
　データ処理システムＳは、データ処理装置１と、経理端末２と、従業員端末３と、請求元端末４と、を備える。データ処理装置１、経理端末２、従業員端末３及び請求元端末４は、ネットワークＮを介してデータを送受信する。ネットワークＮは、例えばインターネット又はイントラネットを含む。 The data processing system S includes a data processing device 1, an accounting terminal 2, an employee terminal 3, and a billing source terminal 4. The data processing device 1, the accounting terminal 2, the employee terminal 3, and the billing source terminal 4 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 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 acquires a file containing image data from the accounting terminal 2, the employee terminal 3, or the billing source terminal 4, and creates invoice data based on the character string specified in the acquired image data. Also, a file containing invoice data may be acquired from the accounting terminal 2, the employee terminal 3, or the billing source terminal 4.
　データ処理装置１は、請求書に記載された商品等の提供に関わった請求元企業内の部門、又は当該商品等の発注に関わった請求先企業内の部門を特定するための処理を実行する。データ処理装置１は、記憶した過去の複数の請求書データのうち、新たに請求先企業が受け取った請求書データに類似する過去請求書データを参照することにより、新たに請求先企業が受け取った請求書に関連する部門（すなわち、請求書に記載された商品等の提供に関わった請求元企業内の部門、又は当該商品等の発注に関わった請求先企業内の部門）を特定する。 The data processing device 1 executes a process for identifying the department in the billing company involved in the provision of the product or the like described in the invoice, or the department in the billing company involved in the ordering of the product or the like. .. The data processing device 1 newly receives the invoice data by the billing company by referring to the past invoice data similar to the invoice data newly received by the billing company among the plurality of stored invoice data in the past. Identify the department related to the invoice (that is, the department within the billing company involved in the provision of the goods, etc. stated in the invoice, or the department within the billing company involved in the ordering of the goods, etc.).
　また、データ処理装置１は、過去に請求先企業が受け取った請求書に関連付けて、請求書に記載された請求額の部門別配賦率を記憶している。データ処理装置１は、新たに請求先企業が受け取った請求書に記載された請求額が請求先企業内の複数の部門に関連する場合、記憶している過去の請求書に対応する部門別配賦率を参照することにより、新たに請求先企業が受け取った請求書の請求額の部門別配賦率を特定する。データ処理装置１は、請求書データと、特定した部門名又は部門別配賦率を示す情報とを関連付けて、経理端末２に送信したり印刷したりする。 Further, the data processing device 1 stores the divisional allocation rate of the invoice amount stated in the invoice in association with the invoice received by the invoice in the past. When the billing amount stated in the invoice newly received by the billing company is related to a plurality of departments in the billing company, the data processing device 1 distributes the bills by department corresponding to the past bills stored in the data processing device 1. By referring to the rate, the departmental allocation rate of the invoice amount newly received by the billing company is specified. The data processing device 1 associates the invoice data with the specified department name or information indicating the allocation rate for each department, and transmits or prints the invoice data to the accounting terminal 2.
　経理端末２は、請求先企業においてデータ処理装置１を利用する従業員（例えば経理担当者）が使用するコンピュータである。経理端末２は、例えばイントラネットを介してデータ処理装置１との間で各種のデータを送受信する。 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. 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 the 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 designated by the accounting person. The accounting terminal 2 displays, for example, a department name or a department-specific allocation rate specified by the data processing device 1. Although 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. 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. The billing terminal 4 is a computer used by an employee of the billing company that has received an order for a product or the like. The billing source terminal 4 transmits the image data of the invoice to the predetermined address of the billing company. The predetermined address is, for example, the address of the data processing device 1, the accounting terminal 2, or the employee terminal 3.
　図２は、請求元企業と請求先企業との関係を示す概念図である。請求元企業及び請求先企業のそれぞれには複数の部門があることが想定されている。請求先企業は、請求元企業の複数の部門のうち一つの部門に商品等を発注する。そして、請求元企業は、複数の部門のうち、商品等の発注を受けた部門が商品等を納入してから請求書を発行する。 FIG. 2 is a conceptual diagram showing the relationship between the billing source company and the billing destination company. It is assumed that each of the billing company and the billing company has multiple departments. The billing company orders products, etc. from one of the multiple departments of the billing company. Then, the billing company issues an invoice after the department that has received the order for the product or the like delivers the product or the like among the plurality of departments.
　図３から図５は、請求先企業が受け取った請求書の例を示す図である。当該請求書には、エース機械株式会社から発行されているが、エース機械株式会社内の複数の部門のうち、どの部門が商品等の手配を担当したかは示されていない。また、請求先企業である田中リサーチ株式会社内の複数の部門のうち、どの部門が請求書に記載された商品等の提供を受けたかは示されていない。 FIGS. 3 to 5 are diagrams showing an example of an invoice received by the billing company. Although the invoice is issued by Ace Machinery Co., Ltd., it does not indicate which of the multiple departments within Ace Machinery Co., Ltd. was in charge of arranging products. In addition, it is not shown which of the multiple departments within Tanaka Research Co., Ltd., which is the billing company, received the products, etc. stated in the invoice.
　例えば図２に示すように、請求先企業の光学研究部が請求元企業の東京営業所の担当者に商品を発注した場合であっても、請求書は請求元企業であるエース機械株式会社から請求先企業である田中リサーチ株式会社に宛てて発行される。したがって、請求先企業の経理担当者は、請求書を見ただけでは、請求元企業のどの部門又はどの担当者が請求内容を決定したか、請求先企業のどの部門が商品等を発注したか、又は請求先企業のどの部門が費用を負担すべきか等を把握できない。データ処理装置１は、このような場合に、請求書の内容に基づいて、これらの点を経理担当者が把握できるようにする。 For example, as shown in FIG. 2, even if the optical research department of the billing company orders the product from the person in charge of the Tokyo sales office of the billing company, the invoice is sent from the billing company, Ace Machinery Co., Ltd. Issued to the billing company, Tanaka Research Co., Ltd. Therefore, the accounting staff of the billing company can determine which department of the billing company or which person in charge has decided the billing content, and which department of the billing company has ordered the product, etc. just by looking at the invoice. Or, it is not possible to know which department of the billing company should bear the cost. In such a case, the data processing device 1 enables the accounting staff to grasp these points based on the contents of the invoice.
　詳細については後述するが、データ処理装置１は、図３に示す請求書に記載されている品名が「測定器Ａメンテナンス」及び「測定器Ａ用プローブ」であることに基づいて、これらの販売担当者がエース機械株式会社の東京営業部に所属すること、及びこれらの発注担当者が田中リサーチ株式会社の光学研究部に所属することを特定する。データ処理装置１は、図４に示す請求書に記載されている品名が「測定器Ｂメンテナンス」及び「測定器Ｂ用プローブ」であることに基づいて、これらの販売担当者がエース機械株式会社の横浜営業部に所属すること、及びこれらの発注担当者が田中リサーチ株式会社の回路開発部に所属することを特定する。 Although the details will be described later, the data processing device 1 is sold based on the product names described in the invoice shown in FIG. 3 being "Measuring instrument A maintenance" and "Measuring instrument A probe". It is specified that the person in charge belongs to the Tokyo Sales Department of Ace Machinery Co., Ltd., and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd. Based on the product names described in the invoice shown in FIG. 4 being "Measuring instrument B maintenance" and "Measuring instrument B probe", the data processing apparatus 1 is sold by Ace Machinery Co., Ltd. It is specified that they belong to the Yokohama Sales Department of Tanaka Research Co., Ltd. and that the person in charge of ordering these belongs to the Circuit Development Department of Tanaka Research Co., Ltd.
　データ処理装置１は、図５に示す請求書に示されている複数の商品のうち、一部の商品を請求元企業の第１の部門が担当し、他の一部の商品を請求元企業の第２の部門が担当したことを特定してもよい。同様に、データ処理装置１は、図５に示す請求書に示されている複数の商品のうち、一部の商品を請求先企業の第１の部門が担当し、他の一部の商品を請求先企業の第２の部門が担当したことを特定してもよい。データ処理装置１がこのように動作することで、経理担当者が請求書に関連する部門を容易に特定することが可能になる。
　以下、データ処理装置１の構成及び動作を詳細に説明する。 In the data processing device 1, among the plurality of products shown in the invoice shown in FIG. 5, some products are handled by the first department of the billing company, and some other products are handled by the billing company. It may be specified that the second department of the above was in charge. Similarly, in the data processing device 1, among the plurality of products shown in the invoice shown in FIG. 5, some products are handled by the first department of the billing company, and some other products are handled. It may be specified that the second department of the billing company was in charge. By operating the data processing device 1 in this way, the accounting staff can easily identify the department related to the invoice.
Hereinafter, the configuration and operation of the data processing device 1 will be described in detail.
［データ処理装置１の構成及び動作］
　図６は、データ処理装置１の構成を示す図である。データ処理装置１は、通信部１１と、記憶部１２と、制御部１３とを有する。制御部１３は、データ取得部１３１と、特定部１３２と、出力部１３３とを有する。 [Configuration and operation of data processing device 1]
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 has a data acquisition unit 131, a specific unit 132, and an output unit 133.
　通信部１１は、ネットワークＮを介して経理端末２と各種のデータを送受信するための通信コントローラを有する。通信部１１は、例えば経理端末２から受信したデータをデータ取得部１３１に入力する。また、通信部１１は、出力部１３３から入力されたデータを、例えば経理端末２に送信する。 The communication unit 11 has a communication controller for transmitting and receiving various data to and from the accounting terminal 2 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 133 to, for example, the accounting terminal 2.
　記憶部１２は、ＲＯＭ（Read Only Memory）、ＲＡＭ（Random Access Memory）及びハードディスク等の記憶媒体を有する。記憶部１２は、制御部１３が実行するプログラムを記憶している。記憶部１２は、通信部１１を介して受信した請求書の画像データを一時的に記憶するワークメモリとしても機能する。 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.
　また、記憶部１２は請求書データベースを記憶している。具体的には、記憶部１２は、過去に発行された複数の過去請求書に対応する複数の過去請求書データに含まれる一以上の項目の内容と、複数の過去請求書を発行した部門及び複数の過去請求書に対する費用を支払った部門と、が関連付けられた請求書データベースを記憶する。記憶部１２は、複数の過去請求書データそれぞれに関連付けて、複数の過去請求書を発行した部門を識別するための発行部門情報を記憶する。記憶部１２は、複数の過去請求書データそれぞれに関連付けて、請求書に対する費用を支払った部門を識別するための支払部門情報を記憶してもよい。発行部門情報及び支払部門情報は、部門名であってもよく、部門に付与されたコード情報であってもよい。 In addition, the storage unit 12 stores the invoice database. Specifically, the storage unit 12 includes the contents of one or more items included in the plurality of past invoice data corresponding to the plurality of past invoices issued in the past, the department that issued the plurality of past invoices, and the unit. Stores the invoice database associated with the department that paid for multiple past invoices. The storage unit 12 stores the issuing department information for identifying the department that issued the plurality of past invoices in association with each of the plurality of past invoice data. The storage unit 12 may store payment department information for identifying the department that paid the cost for the invoice in association with each of the plurality of past invoice data. The issuing department information and the payment department information may be the department name or the code information given to the department.
　さらに、記憶部１２は、複数の過去請求書データそれぞれに関連付けて、請求書に対する費用を支払った複数の部門名又は複数のプロジェクト名と、複数の部門又は複数のプロジェクトそれぞれの配賦率を記憶する。配賦率は、請求書に記載された請求額のうち、各部門が支払う割合である。 Further, the storage unit 12 stores the names of the plurality of departments or the plurality of projects for which the costs for the invoices have been paid and the allocation rates of the plurality of departments or the plurality of projects in association with each of the plurality of past invoice data. do. The allocation rate is the ratio paid by each department to the invoice amount stated on the invoice.
　図７は、記憶部１２が記憶している請求書データベース内のレコードの一例を示す図である。図７に示すレコードにおいては、請求書番号、請求元企業名、請求部門名、販売担当者名、請求元企業の電話番号及びＦＡＸ番号、発注日、納品日、請求日、商品名、単価、数量、支払部門、発注担当者、費用配賦率が関連付けられている。電話番号及びＦＡＸ番号は、請求書に記載されている番号であってもよく、販売担当者名に関連付けて予め登録された電話番号及びＦＡＸ番号であってもよい。 FIG. 7 is a diagram showing an example of records in the invoice database stored in the storage unit 12. In the record shown in FIG. 7, the invoice number, billing company name, billing department name, sales person name, telephone number and fax number of the billing company, ordering date, delivery date, billing date, product name, unit price, The quantity, payment department, orderer, and cost allocation rate are associated. The telephone number and the FAX number may be the numbers described in the invoice, or may be the telephone number and the FAX number registered in advance in association with the name of the sales person.
　図７（ａ）は、図３に示した請求書に記載された商品と同一の商品が記載され、約１年前に発行された過去請求書に対応するレコードである。図７（ｂ）は、図４に示した請求書に記載された商品と同一の商品が記載され、約１年前に発行された過去請求書に対応するレコードである。 FIG. 7A is a record in which the same product as the product described in the invoice shown in FIG. 3 is described and corresponds to the past invoice issued about one year ago. FIG. 7B is a record in which the same product as the product described in the invoice shown in FIG. 4 is described and corresponds to a past invoice issued about one year ago.
　制御部１３は、例えばＣＰＵ（Central Processing Unit）を有する。制御部１３は、記憶部１２に記憶されたプログラムを実行することにより、データ取得部１３１、特定部１３２及び出力部１３３として機能する。 The control unit 13 has, for example, a CPU (Central Processing Unit). The control unit 13 functions as a data acquisition unit 131, a specific unit 132, and an output unit 133 by executing a program stored in the storage unit 12.
　データ取得部１３１は、通信部１１が受信した各種のデータを取得する。データ取得部１３１は、経理端末２又は従業員端末３から送信された請求書の画像データ又は請求書データを取得する。データ取得部１３１は、請求書データが画像データである場合、ＯＣＲ処理を施すことにより、請求書に含まれている文字列を抽出し、抽出した文字列に基づいて、請求書に記載された内容を特定する。データ取得部１３１は、例えば請求書に含まれている請求元企業名、請求元企業の連絡先、請求対象の商品等の名称、単価、個数、金額、振込先口座を特定する。データ取得部１３１は、特定した請求書の内容を請求書データベースに登録する。 The data acquisition unit 131 acquires various data received by the communication unit 11. The data acquisition unit 131 acquires the image data or the invoice data of the invoice transmitted from the accounting terminal 2 or the employee terminal 3. When the invoice data is image data, the data acquisition unit 131 extracts a character string included in the invoice by performing OCR processing, and describes the invoice based on the extracted character string. Identify the content. The data acquisition unit 131 specifies, for example, the name of the billing company, the contact information of the billing company, the name of the product to be billed, the unit price, the quantity, the amount, and the transfer destination account included in the invoice. The data acquisition unit 131 registers the contents of the specified invoice in the invoice database.
　特定部１３２は、請求書データベースに記憶された過去請求書データを参照することにより、データ取得部１３１が取得した請求書データ（以下、「特定対象請求書データ」という場合がある）に対応する請求書を発行した発行部門、又は当該請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する。発行部門は、請求書を発行した企業において請求書に記載された商品等の提供を担当した部門、又は当該商品等の提供を担当した従業員である。支払部門は、請求書を受け取った企業において請求書に記載された商品等の発注を担当した部門、又は当該商品等の発注を担当した従業員である。 The specific unit 132 corresponds to the invoice data acquired by the data acquisition unit 131 (hereinafter, may be referred to as “specific target invoice data”) by referring to the past invoice data stored in the invoice database. Identify at least one of the issuing departments that issued the invoice or the payment department that pays the invoice amount stated on the invoice. The issuing department is the department in charge of providing the products, etc. described in the invoice at the company that issued the invoice, or the employee in charge of providing the products, etc. The payment department is the department in charge of ordering the products, etc. described in the invoice at the company that received the invoice, or the employee in charge of ordering the products, etc.
　特定部１３２は、例えば、特定対象請求書データに含まれる一以上の項目の内容を、請求書を発行した部門、又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較することにより、特定対象請求書データに対応する請求書を発行した発行部門、又は請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する。請求書データに含まれる一以上の項目の内容は、請求元企業の連絡先、請求対象の商品等の名称（品名）、発注日、納品日、請求日、単価、数量、金額又は振込先口座の少なくともいずれかである。 The specific unit 132, for example, puts the contents of one or more items included in the specific target invoice data into a past invoice in which the department that issued the invoice or the department that pays the invoice amount stated in the invoice is specified. Identify at least one of the issuing departments that issued the invoice corresponding to the specified invoice data or the payment department that pays the invoice amount stated on the invoice by comparing it to the content of one or more items included. .. The contents of one or more items included in the invoice data are the contact information of the billing company, the name (product name) of the product to be billed, the ordering date, the delivery date, the billing date, the unit price, the quantity, the amount or the transfer destination account. At least one of.
　特定部１３２は、請求書データベースにおいて、請求書データに含まれる一以上の項目の内容に類似する内容の過去請求書データを特定する。特定部１３２は、特定した過去請求書データに対応する過去請求書を発行した部門又は当該過去請求書に対する費用を支払った部門を、特定対象請求書データに対応する請求書を発行した部門又は当該請求書に対する費用を支払う部門として特定する。 The specifying unit 132 specifies past invoice data having contents similar to the contents of one or more items included in the invoice data in the invoice database. The specific unit 132 refers to the department that issued the past invoice corresponding to the specified past invoice data or the department that paid the cost for the past invoice, the department that issued the invoice corresponding to the specified target invoice data, or the relevant department. Identify as the department that pays for the invoice.
　特定部１３２は、記憶部１２に記憶された複数の過去請求書データのうち、特定対象請求書データに含まれる一以上の項目の内容に類似する内容の過去請求書データに関連付けられた発行部門情報が示す部門を、請求書を発行した部門として特定する。また、特定部１３２は、記憶部１２に記憶された複数の過去請求書データのうち、特定対象請求書データに含まれる一以上の項目の内容に類似する内容の過去請求書データに関連付けられた支払部門情報が示す部門を、請求書に記載された請求額を支払う部門として特定する。 The specific unit 132 is an issuing unit associated with the past invoice data having a content similar to the content of one or more items included in the specific target invoice data among the plurality of past invoice data stored in the storage unit 12. Identify the department indicated by the information as the department that issued the invoice. Further, the specific unit 132 is associated with the past invoice data having a content similar to the content of one or more items included in the specific target invoice data among the plurality of past invoice data stored in the storage unit 12. The department indicated by the payment department information is specified as the department that pays the invoice amount stated on the invoice.
　特定部１３２は、記憶部１２に記憶された複数の過去請求書データのうち、請求書データに含まれる一以上の項目の内容に類似する内容の過去請求書データに関連付けられた配賦率に基づいて、当該過去請求書データに関連付けられた複数の部門又は複数のプロジェクトによる支払額を特定してもよい。特定部１３２が請求書データの配賦率を自動的に特定することで、経理担当者が支払額の部門別の負担額を算出する作業の効率が向上する。 The specific unit 132 determines the allocation rate associated with the past invoice data having a content similar to the content of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit 12. Based on this, the payment amount by multiple departments or multiple projects associated with the past invoice data may be specified. By automatically specifying the allocation rate of the invoice data by the specific unit 132, the efficiency of the work of the accounting staff to calculate the burden amount for each department of the payment amount is improved.
　特定部１３２は、請求書データベースに登録された複数の過去請求書データのうち、過去請求書データに含まれる複数の項目のうち所定数以上の項目の内容が、特定対象請求書データにおいて対応する項目の内容と一致している一以上の過去請求書データを、類似する内容の過去請求書データとして選択する。特定部１３２は、複数の過去請求書を選択した場合、一致している項目がより多い過去請求書データ（すなわち最も類似する過去請求書データ）を選択する。 In the specific unit 132, among the plurality of past invoice data registered in the invoice database, the contents of a predetermined number or more of the plurality of items included in the past invoice data correspond to the specific target invoice data. Select one or more past invoice data that matches the content of the item as past invoice data with similar content. When a plurality of past invoices are selected, the specific unit 132 selects the past invoice data having more matching items (that is, the most similar past invoice data).
　特定部１３２は、例えば、請求書データベースに登録された複数の過去請求書データのうち、品名及び数量が、特定対象請求書データに含まれている品名及び数量と一致している過去請求書データを選択する。特定部１３２は、選択した過去請求書データに関連付けて請求書データベースに登録されている発行部門名、支払部門名又は配賦率の少なくともいずれかを特定する。 The specific unit 132 has, for example, the past invoice data whose product name and quantity match the product name and quantity included in the specified target invoice data among a plurality of past invoice data registered in the invoice database. Select. The identification unit 132 identifies at least one of the issuing department name, the payment department name, or the allocation rate registered in the invoice database in association with the selected past invoice data.
　特定部１３２は、記憶部１２が、複数の過去請求書が発行された日又は複数の過去請求書に係る商品が発注された日と、複数の過去請求書を発行した部門及び複数の過去請求書に対する費用を支払った部門と、が関連付けられた請求書データベースを記憶していることを利用して、商品の発注日又は納品日等のように、商品等の購入に関連する日に基づいて、特定対象請求書データに対応する過去請求書データを特定してもよい。 The specific unit 132 includes the date when the storage unit 12 issues a plurality of past invoices or the date when the product related to the plurality of past invoices is ordered, the department which issued the plurality of past invoices, and the plurality of past invoices. Utilizing the fact that the department that paid the cost for the invoice and remembers the associated invoice database, based on the date related to the purchase of the item, such as the order date or delivery date of the item, etc. , The past invoice data corresponding to the specified target invoice data may be specified.
　特定部１３２は、例えば、記憶部１２に記憶された複数の過去請求書データのうち、請求書データに含まれる一以上の項目の内容に類似する内容の２以上の過去請求書が発行された日又は２以上の複数の過去請求書に係る商品が発注された日の関係が所定の条件を満たす場合に、２以上の過去請求書に関連付けられた支払部門情報が示す部門を支払部門として特定する。所定の条件は、例えば経理担当者により設定されたり予め記憶部１２に記憶されたりしている条件であり、過去の所定の期間（例えば１年間）にわたって同一の名目で請求書が発行されていること、過去に２回以上にわたって同一の金額の請求書が発行されていること、一定の間隔で同一の名目又は金額の請求書が発行されていること等である。 For example, the specific unit 132 has issued two or more past invoices having contents similar to the contents of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit 12. Specify the department indicated by the payment department information associated with two or more past invoices as the payment department if the relationship between the day or the date on which the goods for two or more past invoices were ordered meets certain conditions. do. The predetermined condition is, for example, a condition set by an accounting person or stored in the storage unit 12 in advance, and an invoice is issued under the same name over a predetermined period in the past (for example, one year). That is, the same amount of invoice has been issued more than once in the past, and the same name or amount of invoice has been issued at regular intervals.
　一例として、特定部１３２は、特定対象請求書データが示す商品等と同一の商品等に対応する直前の過去請求書との発行間隔と、特定対象請求書データが示す商品等と同一の商品等に対応する２以上の過去請求書の発行間隔との差が同じであるとみなせる所定範囲内である場合に、当該２以上の過去請求書データに関連付けられた支払部門情報が示す部門を、請求書に記載された請求額を支払う部門として特定してもよい。所定範囲は、発行間隔に対して十分に小さい期間の範囲であり、例えば発行間隔が１年である場合、所定範囲は１ヵ月以内である。発行間隔が１年である場合、所定範囲が１週間以内であってもよい。 As an example, the specific unit 132 has an issue interval between the product, etc. indicated by the specific target invoice data and the past invoice immediately before corresponding to the same product, etc., and the same product, etc. as the product, etc. indicated by the specific target invoice data. If the difference from the issuance interval of two or more past invoices corresponding to is within a predetermined range that can be regarded as the same, the department indicated by the payment department information associated with the two or more past invoice data is billed. It may be specified as the department that pays the invoice stated in the invoice. The predetermined range is a range of a period sufficiently smaller than the issuance interval. For example, when the issuance interval is one year, the predetermined range is within one month. If the issuance interval is one year, the predetermined range may be within one week.
　具体的には、特定部１３２は、同じ支払部門が過去に発注した同じ商品に関する複数の過去請求書が１年ごとに発行されており、直近の過去請求書から約１年後に特定対象請求書が発行されている場合、当該過去請求書に関連付けられた支払部門を特定対象請求書データの商品を発注した部門であると特定する。特定部１３２がこのように商品等が発注される間隔を利用することで、定期的に購入される商品等の担当部門を特定する精度が向上する。 Specifically, in the specific unit 132, a plurality of past invoices for the same product ordered in the past by the same payment department are issued every year, and the specified target invoice is issued about one year after the latest past invoice. Is issued, the payment department associated with the past invoice is identified as the department that ordered the goods for the specified invoice data. By using the interval in which the product or the like is ordered by the specific unit 132 in this way, the accuracy of identifying the department in charge of the product or the like that is regularly purchased is improved.
　特定部１３２は、複数の項目を比較する前に、請求書データベースに登録されている複数の過去請求書データのうち、特定対象請求書データに対応する請求書を発行した企業が発行した過去請求書に対応する過去請求書データを特定してもよい。そして、特定部１３２は、特定した過去請求書データに含まれる一以上の項目の内容を参照することにより、特定対象請求書データに対応する請求書の発行部門又は支払部門の少なくともいずれかを特定する。特定部１３２がこのように動作することで、多数の請求書データから、発行部門又は支払部門の特定に有効性が高い過去請求書データを絞り込むことができるので、特定精度が向上するとともに特定処理の時間を短縮することができる。 Before comparing a plurality of items, the specific unit 132 is a past invoice issued by a company that has issued an invoice corresponding to the specified target invoice data among a plurality of past invoice data registered in the invoice database. The past invoice data corresponding to the invoice may be specified. Then, the specifying unit 132 identifies at least one of the invoice issuing department or the payment department corresponding to the specified target invoice data by referring to the contents of one or more items included in the specified past invoice data. do. By operating the specific unit 132 in this way, it is possible to narrow down the past invoice data that is highly effective for specifying the issuing department or the payment department from a large number of invoice data, so that the specific accuracy is improved and the specific processing is performed. Time can be shortened.
　特定部１３２は、特定対象請求書を発行した企業名に加えて、連絡先又は振込先口座番号が一致している過去請求書データを優先的に選択してもよい。連絡先又は振込先口座番号が一致している場合、発行部門及び支払部門が一致している蓋然性が高いので、特定部１３２がこのように動作することで、発行部門及び支払部門の特定精度が向上する。 The specific unit 132 may preferentially select the past invoice data that matches the contact information or the transfer destination account number in addition to the company name that issued the specific target invoice. If the contact or transfer account numbers match, it is highly probable that the issuing department and the payment department match. Therefore, by operating the specific unit 132 in this way, the specific accuracy of the issuing department and the payment department can be improved. improves.
　図３に示した請求書の場合、特定部１３２は図７（ａ）に示したレコードを参照することにより、図３に示す請求書に記載された商品の販売担当者がエース機械株式会社の東京営業部に所属すること、及びこれらの発注担当者が田中リサーチ株式会社の光学研究部に所属することを特定する。また、図４に示した請求書の場合、特定部１３２は図７（ｂ）に示したレコードを参照することにより、図４に示す請求書に記載された商品の販売担当者がエース機械株式会社の横浜営業部に所属すること、及びこれらの発注担当者が田中リサーチ株式会社の回路開発部に所属することを特定する。 In the case of the invoice shown in FIG. 3, the specific unit 132 refers to the record shown in FIG. 7 (a), and the person in charge of selling the product described in the invoice shown in FIG. 3 is Ace Machinery Co., Ltd. It is specified that they belong to the Tokyo Sales Department and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd. Further, in the case of the invoice shown in FIG. 4, the specific unit 132 refers to the record shown in FIG. 7 (b), so that the person in charge of selling the product described in the invoice shown in FIG. 4 can use the ace machine stock. It is specified that they belong to the Yokohama sales department of the company and that the person in charge of ordering these belongs to the circuit development department of Tanaka Research Co., Ltd.
　特定部１３２は、例えば図５に示す請求書のように、請求書に示されている複数の商品の全てが一致する過去請求書がない場合に、複数の商品のうち一部の商品が一致する一以上の過去請求書に基づいて、一部の商品の販売担当者及び発注担当者を特定してもよい。図５に示す請求書の場合、特定部１３２は、図７（ａ）に示したレコードを参照することにより、「測定器Ａメンテナンス」及び「測定器Ａ用プローブ」の販売担当者がエース機械株式会社の東京営業部に所属すること、及びこれらの発注担当者が田中リサーチ株式会社の光学研究部に所属することを特定する。また、特定部１３２は、図７（ｂ）に示したレコードを参照することにより、「測定器Ｂメンテナンス」及び「測定器Ｂ用プローブ」の販売担当者がエース機械株式会社の横浜営業部に所属すること、及びこれらの発注担当者が田中リサーチ株式会社の回路開発部に所属することを特定する。 In the specific unit 132, when there is no past invoice in which all of the plurality of products shown in the invoice match, as in the invoice shown in FIG. 5, some of the plurality of products match. You may identify the person in charge of selling and ordering some goods based on one or more past invoices. In the case of the invoice shown in FIG. 5, the specific unit 132 refers to the record shown in FIG. 7 (a), and the sales person in charge of "measurement instrument A maintenance" and "measurement instrument A probe" is an ace machine. It is specified that they belong to the Tokyo Sales Department of Tanaka Research Co., Ltd. and that the person in charge of ordering these belongs to the Optical Research Department of Tanaka Research Co., Ltd. In addition, by referring to the record shown in FIG. 7B, the sales person in charge of "Measuring instrument B maintenance" and "Measuring instrument B probe" is assigned to the Yokohama sales department of Ace Machinery Co., Ltd. It is specified that they belong to and that the person in charge of ordering these belongs to the circuit development department of Tanaka Research Co., Ltd.
　特定部１３２は、請求書の発行部門、支払部門又は配賦率を特定した場合に、その確からしさを示す信頼度を算出してもよい。特定部１３２は、例えば、特定対象請求書データに含まれている項目のうち、過去請求書データに含まれている内容と一致している項目の数が多ければ多いほど、発行部門又は支払部門を正しく特定した蓋然性が高いと判定して信頼度を大きくする。特定部１３２は、項目ごとに重みづけをして信頼度を決定してもよい。また、特定部１３２は、特定対象請求書データが示す商品等と同一の商品等に対応する直前の過去請求書との発行間隔が、特定対象請求書データが示す商品等と同一の商品等に対応する複数の過去請求書の発行間隔とほぼ同じである場合にも、そうでない場合よりも信頼度を大きくしてもよい。 When the specifying department 132 specifies the issuing department, the payment department, or the allocation rate of the invoice, the specifying unit 132 may calculate the reliability indicating the certainty. For example, the more the number of items included in the specified target invoice data that match the contents contained in the past invoice data, the more the issuing department or the payment department has the specific unit 132. It is judged that there is a high probability that the invoice is correctly specified, and the reliability is increased. The specific unit 132 may determine the reliability by weighting each item. Further, in the specific unit 132, the issue interval between the product or the like indicated by the specific target invoice data and the past invoice immediately before corresponding to the same product or the like is the same as the product or the like indicated by the specific target invoice data. Even if the issuance interval of a plurality of corresponding past invoices is almost the same, the reliability may be higher than that of the other cases.
　出力部１３３は、特定部１３２が特定した請求書の発行部門又は支払部門を示す部門情報を出力する。出力部１３３は、請求データに関連付けて、特定部１３２が発行部門又は支払部門を正しく特定した蓋然性を示す信頼度情報を出力してもよい。信頼度情報は、特定部１３２が算出した信頼度を示す情報であり、特定部１３２が特定した発行部門が、実際に商品等の販売を担当した部門である確率、又は特定部１３２が特定した支払部門が、実際に商品等の発注を担当した部門である確率に対応する度合いを示す情報である。 The output unit 133 outputs the department information indicating the invoice issuing department or the payment department specified by the specific unit 132. The output unit 133 may output reliability information indicating the probability that the specific unit 132 correctly identifies the issuing department or the payment department in association with the billing data. The reliability information is information indicating the reliability calculated by the specific unit 132, and the probability that the issuing department specified by the specific unit 132 is the department actually in charge of selling the product or the like, or the specific unit 132 specified. This is information indicating the degree of correspondence with the probability that the payment department is the department that was actually in charge of ordering products and the like.
　図８は、出力部１３３が出力する情報の一例を示す図である。図８に示す例においては、請求書番号、請求元企業名、販売部門、販売担当者、支払部門、発注担当者、請求額、配賦率、信頼度が関連付けて表示されている。出力部１３３は、これらの情報に加えて、請求書の発行部門若しくは販売担当者又は支払部門若しくは発注担当者の連絡先をさらに表示してもよい。出力部１３３は、信頼度が低い場合に、図８の請求書番号Ｓ１０００２２５１の請求書のように、信頼度が低い理由を出力してもよい。 FIG. 8 is a diagram showing an example of information output by the output unit 133. In the example shown in FIG. 8, the invoice number, the billing source company name, the sales department, the sales person, the payment department, the ordering person, the invoice amount, the allocation rate, and the reliability are displayed in association with each other. In addition to this information, the output unit 133 may further display the contact information of the invoice issuing department or sales person or the payment department or ordering person. When the reliability is low, the output unit 133 may output the reason why the reliability is low, as in the invoice of the invoice number S100002251 in FIG.
　経理担当者は、図８に示す情報を閲覧することにより、請求書に記載された商品の販売担当者（すなわち、請求書の発行に関わった担当者）又は商品の発注担当者に容易に連絡を取ることができる。また、経理担当者は、請求額の部門別の仕訳を容易に行うことができる。さらに、信頼度情報が示されているため、経理担当者は、信頼度の大きさによって販売担当者又は発注担当者への連絡の取り方を変えるといった柔軟な対応が可能になる。 By viewing the information shown in FIG. 8, the accountant can easily contact the person in charge of selling the product (that is, the person involved in issuing the invoice) or the person in charge of ordering the product described in the invoice. Can be taken. In addition, the accounting staff can easily make journal entries for each department of the billed amount. Furthermore, since the reliability information is shown, the accounting staff can flexibly respond by changing the method of contacting the sales staff or the ordering staff depending on the magnitude of the reliability.
［データ処理装置１の処理の流れ］
　図９は、データ処理装置１の動作の流れを示すフローチャートである。図９に示すフローチャートは、データ処理装置１を利用する請求先企業に請求書が届いた時点から開始している。 [Processing flow of data processing device 1]
FIG. 9 is a flowchart showing the operation flow of the data processing device 1. The flowchart shown in FIG. 9 starts from the time when the invoice arrives at the billing company that uses the data processing device 1.
　データ取得部１３１は、経理端末２又は他の端末から請求書データを取得する（Ｓ１１）。続いて、特定部１３２は、請求書データベースに登録されている過去請求書データを参照し（Ｓ１２）、Ｓ１１において取得した特定対象請求書データに含まれる内容と類似する過去請求書データがあるか否かを判定する（Ｓ１３）。特定部１３２は、経理端末２から、特定対象請求書データに対応する販売担当者又は発注担当者を特定する処理を行う指示を受けたことを条件としてＳ１３の判定処理を実行してもよい。 The data acquisition unit 131 acquires invoice data from the accounting terminal 2 or another terminal (S11). Subsequently, the specifying unit 132 refers to the past invoice data registered in the invoice database (S12), and is there any past invoice data similar to the content included in the specified target invoice data acquired in S11? It is determined whether or not (S13). The specifying unit 132 may execute the determination process of S13 on condition that the accounting terminal 2 receives an instruction to specify a sales person or an ordering person corresponding to the specified target invoice data.
　特定部１３２、類似する過去請求書データがないと判定した場合（Ｓ１３においてＮＯ）、処理を終了する。特定部１３２、類似する過去請求書データがあると判定した場合（Ｓ１３においてＹＥＳ）、上述した各種の方法により、特定対象請求書データに係る商品等の販売部門（販売担当者であってもよい）、又は支払部門（発注担当者であってもよい）を特定し（Ｓ１４）、出力部１３３が特定した部門に関する情報を出力する（Ｓ１５）。 If it is determined that there is no similar past invoice data in the specific unit 132 (NO in S13), the process is terminated. When it is determined that the specific unit 132 has similar past invoice data (YES in S13), the sales department (sales person in charge) of the product or the like related to the specific target invoice data may be used by the various methods described above. ), Or the payment department (which may be the person in charge of ordering) is specified (S14), and the output unit 133 outputs information about the specified department (S15).
　特定部１３２が、特定対象請求書データに係る商品等の費用を負担するべき複数の支払部門があることを特定した場合（Ｓ１６においてＹＥＳ）、出力部１３３は、複数の支払部門それぞれに関連付けて配賦率を出力する（Ｓ１７）。特定部１３２が、特定対象請求書データに係る商品等の費用を負担するべき支払部門が一つであることを特定した場合（Ｓ１６においてＮＯ）、特定部１３２は処理を終了する。なお、この場合に、出力部１３３が、一つの支払部門の配賦率が１００％であること示す情報を出力してもよい。 When the specific unit 132 specifies that there are a plurality of payment departments that should bear the costs of goods and the like related to the specific target invoice data (YES in S16), the output unit 133 associates each of the plurality of payment departments with each other. The allocation rate is output (S17). When the specific unit 132 specifies that there is only one payment department to bear the cost of the product or the like related to the specific target invoice data (NO in S16), the specific unit 132 ends the process. In this case, the output unit 133 may output information indicating that the allocation rate of one payment department is 100%.
［データ処理装置１による効果］
　以上説明したように、特定部１３２は、特定対象請求書データに含まれる一以上の項目の内容を、請求書を発行した部門、又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較することにより、特定対象請求書データに対応する請求書を発行した発行部門、又は当該請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する。そして、出力部１３３は、特定部１３２が特定した発行部門又は支払部門を示す情報を出力する。データ処理装置１がこのように動作することで、請求書を発行した企業に複数の部門がある場合、又は請求書を受け取った企業に複数の部門がある場合に、経理担当者が請求書に関連する部門を容易に特定することができるので、作業効率が向上する。 [Effect of data processing device 1]
As described above, the specific unit 132 has specified the department that issued the invoice or the department that pays the invoice amount stated in the invoice for the contents of one or more items included in the specific target invoice data. At least the issuing department that issued the invoice corresponding to the specified invoice data, or the paying department that pays the invoice amount stated in the invoice, by comparing it with the content of one or more items contained in the past invoice. Identify one. Then, the output unit 133 outputs information indicating the issuing department or the payment department specified by the specific unit 132. By operating the data processing device 1 in this way, if the company that issued the invoice has multiple departments, or if the company that received the invoice has multiple departments, the accountant will be invoiced. Work efficiency is improved because related departments can be easily identified.
　以上、実施の形態を用いて本発明を説明したが、本発明の技術的範囲は上記実施の形態に記載の範囲には限定されず、その要旨の範囲内で種々の変形及び変更が可能である。例えば、装置の全部又は一部は、任意の単位で機能的又は物理的に分散・統合して構成することができる。また、複数の実施の形態の任意の組み合わせによって生じる新たな実施の形態も、本発明の実施の形態に含まれる。組み合わせによって生じる新たな実施の形態の効果は、もとの実施の形態の効果を併せ持つ。 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 thereof. be. For example, all or part of the device can be functionally or physically distributed / integrated in any unit. Also included in the embodiments of the present invention are new embodiments resulting from any combination of the plurality of embodiments. The effect of the new embodiment produced by the combination has the effect of the original embodiment together.
１　データ処理装置
２　経理端末
３　従業員端末
４　請求元端末
１１　通信部
１２　記憶部
１３　制御部
１３１　データ取得部
１３２　特定部
１３３　出力部 1 Data processing device 2 Accounting terminal 3 Employee terminal 4 Billing terminal 11 Communication unit 12 Storage unit 13 Control unit 131 Data acquisition unit 132 Specific unit 133 Output unit

Claims (10)

  1. 　請求書データを取得するデータ取得部と、
    　前記請求書データに含まれる一以上の項目の内容を、請求書を発行した部門又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較することにより、前記請求書データに対応する請求書を発行した発行部門、又は前記請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する特定部と、
    　前記特定部が特定した前記発行部門又は前記支払部門を示す部門情報を出力する出力部と、
    　を有するデータ処理装置。     The data acquisition department that acquires invoice data, and
    The content of one or more items contained in the invoice data is the content of one or more items included in the past invoice in which the department that issued the invoice or the department that pays the invoice amount stated in the invoice is specified. By comparison, a specific unit that identifies at least one of the issuing department that issued the invoice corresponding to the invoice data or the payment department that pays the invoice amount stated in the invoice.
    An output unit that outputs department information indicating the issuing department or the payment department specified by the specific unit, and an output unit.
    Data processing device with.
  2. 　複数の前記過去請求書に対応する複数の過去請求書データに含まれる一以上の項目の内容と、前記複数の過去請求書を発行した部門と、が関連付けられた請求書データベースを記憶する記憶部をさらに有し、
    　前記特定部は、前記請求書データベースにおいて、前記請求書データに含まれる一以上の項目の内容に類似する内容の前記過去請求書データを特定し、特定した前記過去請求書データに対応する前記過去請求書を発行した部門を前記発行部門として特定する、
    　請求項１に記載のデータ処理装置。     A storage unit that stores an invoice database in which the contents of one or more items included in the plurality of past invoice data corresponding to the plurality of past invoices and the department that issued the plurality of past invoices are associated with each other. Has more,
    The specific unit identifies the past invoice data having a content similar to the content of one or more items included in the invoice data in the invoice database, and the past corresponding to the specified past invoice data. Identify the department that issued the invoice as the issuing department,
    The data processing apparatus according to claim 1.
  3. 　複数の前記過去請求書に対応する複数の過去請求書データに含まれる一以上の項目の内容と、前記複数の過去請求書に対する費用を支払った部門と、が関連付けられた請求書データベースを記憶する記憶部をさらに有し、
    　前記特定部は、前記請求書データベースにおいて、前記請求書データに含まれる一以上の項目の内容に類似する内容の前記過去請求書データを特定し、特定した前記過去請求書データに対応する前記過去請求書に対する費用を支払った部門を前記支払部門として特定する、
    　請求項１に記載のデータ処理装置。     Stores an invoice database associated with the content of one or more items contained in the plurality of past invoice data corresponding to the plurality of past invoices and the department that paid the cost for the plurality of past invoices. Has more storage,
    The specific unit identifies the past invoice data having a content similar to the content of one or more items included in the invoice data in the invoice database, and the past corresponding to the specified past invoice data. Identify the department that paid the cost for the invoice as the payment department,
    The data processing apparatus according to claim 1.
  4. 　複数の前記過去請求書に対応する複数の過去請求書データそれぞれに関連付けて、前記過去請求書に対する費用を支払った複数の部門又は複数のプロジェクトと、前記複数の部門又は前記複数のプロジェクトの配賦率を記憶する記憶部をさらに有し、
    　前記特定部は、前記記憶部に記憶された前記複数の過去請求書データのうち、前記請求書データに含まれる一以上の項目の内容に類似する内容の前記過去請求書データに関連付けられた前記配賦率に基づいて、当該過去請求書データに関連付けられた前記複数の部門又は前記複数のプロジェクトによる支払額を特定する、
    　請求項１に記載のデータ処理装置。     Allocation of the plurality of departments or projects for which the costs for the past invoices and the plurality of departments or the plurality of projects are associated with each of the plurality of past invoice data corresponding to the plurality of the past invoices. It also has a storage unit to store the rate,
    The specific unit is associated with the past invoice data having a content similar to the content of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit. Identify payments by the plurality of departments or the plurality of projects associated with the historical invoice data based on the allocation rate.
    The data processing apparatus according to claim 1.
  5. 　複数の前記過去請求書が発行された日又は前記複数の過去請求書に係る商品が発注された日と、前記複数の過去請求書を発行した部門及び前記複数の過去請求書に対する費用を支払った部門と、が関連付けられた請求書データベースを記憶する記憶部をさらに有し、
    　前記特定部は、前記記憶部に記憶された前記複数の過去請求書データのうち、前記請求書データに含まれる一以上の項目の内容に類似する内容の２以上の前記過去請求書が発行された日又は前記２以上の複数の過去請求書に係る商品が発注された日の関係が所定の条件を満たす場合に、前記２以上の過去請求書に関連付けられた支払部門情報が示す部門を前記支払部門として特定する、
    　請求項１に記載のデータ処理装置。     The date on which the plurality of past invoices were issued or the date on which the goods related to the plurality of past invoices were ordered, the department that issued the plurality of past invoices, and the expenses for the plurality of past invoices were paid. The department also has a storage unit to store the associated invoice database,
    The specific unit is issued with two or more of the past invoices having contents similar to the contents of one or more items included in the invoice data among the plurality of past invoice data stored in the storage unit. The department indicated by the payment department information associated with the two or more past invoices when the relationship between the date or the date when the goods related to the two or more past invoices are ordered satisfies a predetermined condition. Identify as payment department,
    The data processing apparatus according to claim 1.
  6. 　前記特定部は、前記データ取得部が取得した前記請求書データが示す商品と同一の商品に対応する直前の過去請求書との発行間隔と、前記請求書データが示す商品と同一の商品に対応する前記２以上の過去請求書の発行間隔との差が同じであるとみなせる所定範囲内である場合に、前記２以上の過去請求書に関連付けられた支払部門情報が示す部門を前記支払部門として特定する、
    　請求項５に記載のデータ処理装置。     The specific unit corresponds to the issuance interval of the past invoice immediately before corresponding to the same product as the product indicated by the invoice data acquired by the data acquisition unit, and the same product as the product indicated by the invoice data. When the difference from the issuance interval of the two or more past invoices is within a predetermined range, the department indicated by the payment department information associated with the two or more past invoices is designated as the payment department. Identify,
    The data processing apparatus according to claim 5.
  7. 　前記特定部は、前記請求書データに対応する請求書を発行した企業が発行した前記過去請求書に含まれる一以上の項目の内容を参照することにより、前記発行部門又は前記支払部門の少なくともいずれかを特定する、
    　請求項１から６のいずれか一項に記載のデータ処理装置。     The specific unit may refer to at least one of the issuing department or the payment department by referring to the contents of one or more items included in the past invoice issued by the company that issued the invoice corresponding to the invoice data. To identify
    The data processing apparatus according to any one of claims 1 to 6.
  8. 　前記出力部は、前記請求書データに関連付けて、前記特定部が前記発行部門又は前記支払部門を正しく特定した蓋然性を示す信頼度情報を出力する、
    　請求項１から７のいずれか一項に記載のデータ処理装置。     The output unit outputs reliability information indicating the probability that the specific unit correctly identifies the issuing department or the payment department in association with the invoice data.
    The data processing apparatus according to any one of claims 1 to 7.
  9. 　コンピュータが実行する、
    　請求書データを取得するステップと、
    　前記請求書データに含まれる一以上の項目の内容を、請求書を発行した部門、又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較するステップと、
    　比較した結果に基づいて、前記請求書データに対応する請求書を発行した発行部門、又は前記請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定するステップと、
    　特定した前記発行部門又は前記支払部門を示す部門情報を出力するステップと、
    　を有するデータ処理方法。     Computer runs,
    Steps to get invoice data and
    The content of one or more items contained in the invoice data, the content of one or more items included in the past invoice in which the department that issued the invoice or the department that pays the invoice amount stated in the invoice is specified. And the steps to compare with
    Based on the results of the comparison, a step of identifying at least one of the issuing department that issued the invoice corresponding to the invoice data or the payment department that pays the invoice amount stated in the invoice.
    A step of outputting department information indicating the specified issuing department or the payment department, and
    Data processing method.
  10. 　コンピュータを、
    　請求書データを取得するデータ取得部、
    　前記請求書データに含まれる一以上の項目の内容を、請求書を発行した部門、又は請求書に記載された請求額を支払う部門が特定された過去請求書に含まれる一以上の項目の内容と比較することにより、前記請求書データに対応する請求書を発行した発行部門、又は前記請求書に記載された請求額を支払う支払部門の少なくともいずれかを特定する特定部、及び
    　前記特定部が特定した前記発行部門又は前記支払部門を示す部門情報を出力する出力部、
    　として機能させるためのプログラム。
     
     
          Computer,
    Data acquisition department to acquire invoice data,
    The content of one or more items contained in the invoice data, the content of one or more items included in the past invoice in which the department that issued the invoice or the department that pays the invoice amount stated in the invoice is specified. By comparing with, a specific part that specifies at least one of the issuing department that issued the invoice corresponding to the invoice data, or the payment department that pays the invoice amount stated in the invoice, and the specific part. An output unit that outputs department information indicating the specified issuing department or payment department,
    A program to function as.
PCT/JP2020/026268 2020-07-03 2020-07-03 Data processing device, data processing method, and program WO2022003977A1 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
PCT/JP2020/026268 WO2022003977A1 (en) 2020-07-03 2020-07-03 Data processing device, data processing method, and program
JP2020537258A JP6805394B1 (en) 2020-07-03 2020-07-03 Data processing equipment, data processing methods and programs
JP2020200792A JP2022013578A (en) 2020-07-03 2020-12-03 Data processing device, data processing method and program

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/JP2020/026268 WO2022003977A1 (en) 2020-07-03 2020-07-03 Data processing device, data processing method, and program

Publications (1)

Publication Number Publication Date
WO2022003977A1 true WO2022003977A1 (en) 2022-01-06

Family

ID=73836020

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/JP2020/026268 WO2022003977A1 (en) 2020-07-03 2020-07-03 Data processing device, data processing method, and program

Country Status (2)

Country Link
JP (2) JP6805394B1 (en)
WO (1) WO2022003977A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7233794B1 (en) * 2022-10-21 2023-03-07 ファーストアカウンティング株式会社 Information processing device, information processing method and program

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2007524887A (en) * 2003-03-13 2007-08-30 コンソリデイテッド ビルディング ソリューションズ インコーポレーテッド Electronic bill presentation and payment system and method of using the same
US20120116932A1 (en) * 2010-11-08 2012-05-10 Bank Of America Corporation Evaluating requests using historical benchmarking
JP6646308B1 (en) * 2019-03-07 2020-02-14 ファーストアカウンティング株式会社 Voucher analysis device, accounting processing system, voucher analysis method, voucher analysis program

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2007524887A (en) * 2003-03-13 2007-08-30 コンソリデイテッド ビルディング ソリューションズ インコーポレーテッド Electronic bill presentation and payment system and method of using the same
US20120116932A1 (en) * 2010-11-08 2012-05-10 Bank Of America Corporation Evaluating requests using historical benchmarking
JP6646308B1 (en) * 2019-03-07 2020-02-14 ファーストアカウンティング株式会社 Voucher analysis device, accounting processing system, voucher analysis method, voucher analysis program

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7233794B1 (en) * 2022-10-21 2023-03-07 ファーストアカウンティング株式会社 Information processing device, information processing method and program

Also Published As

Publication number Publication date
JP2022013578A (en) 2022-01-18
JP6805394B1 (en) 2020-12-23
JPWO2022003977A1 (en) 2022-01-06

Similar Documents

Publication Publication Date Title
US11847627B2 (en) Product catalog services
US4992940A (en) System and method for automated selection of equipment for purchase through input of user desired specifications
RU2183854C2 (en) System of applications and application accompanying system
JP4638450B2 (en) Transaction apparatus, slip generation method, and computer program
JP2017084258A (en) Merchandise sales management server, merchandise sales management system and merchandise sales management method
WO2021245755A1 (en) Bill management device, bill management method, and program
JP4422071B2 (en) Accounts receivable verification system and method for receivables verification
JP2004051374A (en) Seamless commodity physical distribution information system
WO2022003977A1 (en) Data processing device, data processing method, and program
JP6775100B1 (en) Billing information management device, billing information management method and program
KR20090132260A (en) Method for easy returning of goods and reducing of the cost of transport
WO2021260891A1 (en) Invoice management device, invoice management method, and program
JP2007115215A (en) Operation management system of internet auction substitute business
JP5614439B2 (en) Customer management device and program
JP6730019B2 (en) Electronic payment system and electronic payment method
JPH11208794A (en) Oil delivery instruction system and recording medium with oil delivery instruction system program recorded
WO2001082159A1 (en) Cotton yarn trading method utilizing network
CN110807678A (en) Method and system for generating value-added tax red invoice invoicing data
JP7276951B1 (en) Information processing device, information processing method and program
JP7074803B2 (en) Customs business support equipment, customs business support method, and customs business support program
JP6848134B1 (en) Data processing equipment, data processing methods and programs
JP6790310B1 (en) Voucher management device, voucher management method and program
JP7215779B1 (en) Data processing device, data processing method and program
JP4091714B2 (en) Charge collection method
WO2022176100A1 (en) Data processing device, data processing method, and program

Legal Events

Date Code Title Description
ENP Entry into the national phase

Ref document number: 2020537258

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: 20943601

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: 20943601

Country of ref document: EP

Kind code of ref document: A1