Journal entry method, program, and information processing apparatus

Abstract

To provide a journal entry method for automatically carry out journal entries from data related to transactions, a program for creating compound journal entry, and an information processing apparatus.SOLUTION: A journal entry method to be performed by an information processing apparatus 1 includes: a data acquisition step (ST100) for acquiring transaction data related to transactions; and a journal entry step for generating journal entry data based on the acquired transaction data. The transaction data includes one or more pieces of first amount data each indicating the amount of one item related to a transaction. The journal entry data includes multiple pieces of second amount data each indicating the amount of debit or credit of an accounting title. The journal entry step includes: a determination step (ST105) of determining each of the multiple pieces of second amount data included in the journal entry data on the basis of the one or more pieces of first amount data included in the transaction data; and a data generation step (ST115) of generating journal entry data including the determined second amount data of the accounting titles.SELECTED DRAWING: Figure 2

Description

[Technical field]

[0001] The present invention relates to a journalizing method, a program therefor, and an information processing device for performing the journalizing method. [Background technology]

[0002] Generally, accounting software is used for corporate accounting work. Various accounting data is input into the accounting software, which is used to manage accounting books and prepare financial statements. Inputting accounting data into accounting software is one of the main tasks in accounting work. Summary of the Invention [Problem to be solved by the invention]

[0003] Accounting data is input to accounting software by, for example, preparing accounting data in a specified format (e.g., a CSV file) and importing it into the accounting software. The data that is the source of accounting data (original data) may be, for example, data obtained by reading transaction slips using OCR (optical character recognition) or data output from business software such as payroll management software. When preparing accounting data to be imported into accounting software, it is necessary to pick up the records of individual transactions (dates, contents, amounts, etc. related to the transactions) contained in the original data, make journal entries for each transaction record according to specified rules, and determine the amounts of debit and credit account items. This type of journal entry work is very cumbersome and places a heavy burden on accounting department staff.

[0004] The present invention has been made in view of the above circumstances, and an object of the present invention is to provide a journal entry method, a program, and an information processing device that can automatically perform journal entry from transaction data. [Means for solving the problem]

[0005] A first aspect of the present invention is a journal entry method performed by an information processing device, the journal entry method having a data acquisition step of acquiring transaction data related to a transaction and a journal entry step of generating journal entry data based on the acquired transaction data, wherein the transaction data includes one or more first amount data each indicating an amount of one item related to the transaction, and the journal entry data includes a plurality of second amount data each indicating an amount of a debit or credit account item, and each of the plurality of second amount data in the journal entry data is associated with one of the first amount data in the transaction data, the journal entry step includes a determination step of determining each of the plurality of second amount data included in the journal entry data based on the one or more first amount data included in the transaction data, and a data generation step of generating journal entry data including the second amount data for each of the determined account items, and the determination step of determining one of the second amount data includes determining the one of the second amount data based on the one of the first amount data associated with the one of the second amount data.

[0006] A second aspect of the present invention is a program including instructions for causing an information processing device to perform journal entries, the processing performed by the information processing device in accordance with the instructions comprising a data acquisition step of acquiring transaction data relating to a transaction, and a journal entry step of generating journal entry data based on the acquired transaction data, the transaction data including one or more first amount data each indicating an amount of one item related to the transaction, the journal entry data including a plurality of second amount data each indicating an amount of a debit or credit account item, each of the plurality of second amount data in the journal entry data corresponding to one of the first amount data in the transaction data, the journal entry step including a determination step of determining each of the plurality of second amount data included in the journal entry data based on the one or more first amount data included in the transaction data, and a data generation step of generating journal entry data including the second amount data for each of the determined account items, the determination step of determining one of the second amount data including determining the one of the second amount data based on the one of the first amount data corresponding to the one of the second amount data.

[0007] A third aspect of the present invention is an information processing device that performs journal entries, the information processing device having a processing unit and a memory unit that stores instructions to be executed by the processing unit, and the processing performed by the processing unit in accordance with the instructions includes a data acquisition step of acquiring transaction data related to a transaction and a journal entry step of generating journal entry data based on the acquired transaction data, the transaction data including one or more first amount data indicating an amount of one item related to the transaction, the journal entry data including a plurality of second amount data indicating an amount of a debit or credit account item, and each of the plurality of second amount data in the journal entry data corresponds to one first amount data in the transaction data, the journal entry step includes a determination step of determining each of the plurality of second amount data included in the journal entry data based on the one or more first amount data included in the transaction data, and a data generation step of generating journal entry data including the second amount data for each determined account item, and the determination step of determining one second amount data includes determining the one second amount data based on the one first amount data associated with the one second amount data.

[0008] A fourth aspect of the present invention is an information processing device for performing journal entries, the information processing device having a data acquisition means for acquiring transaction data related to a transaction, and a journal entry means for generating journal entry data based on the acquired transaction data, wherein the transaction data includes one or more first amount data each indicating an amount of an item related to a transaction, and the journal entry data includes a plurality of second amount data each indicating an amount of a debit or credit account item, and each of the plurality of second amount data in the journal entry data corresponds to one first amount data in the transaction data, the journal entry means includes a determination means for determining each of the plurality of second amount data included in the journal entry data based on the one or more first amount data included in the transaction data, and a data generation means for generating journal entry data including the second amount data for each determined account item, and when determining one second amount data, the determination means determines the one second amount data based on the one first amount data associated with the one second amount data. Effect of the Invention

[0009] According to the present invention, it is possible to provide a journal entry method, a program, and an information processing device that can automatically perform journal entry from data related to transactions. [Brief description of the drawings]

[0010] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a system according to the present embodiment. [Diagram 2] FIG. 2 is a diagram for explaining an example of processing by the information processing device according to the present embodiment. [Diagram 3] FIG. 3 is a diagram for explaining an example of a correspondence relationship between first item data of transaction data and second item data of journal data. [Figure 4] FIG. 4 is a diagram for explaining an example of generating journal data based on data read by OCR from an image of a document related to a transaction record. [Diagram 5] FIG. 5 is a diagram for explaining an example of a process for determining data of each item included in the document read data in the example of FIG. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0011] Fig. 1 is a diagram showing an example of a system according to the present embodiment. The system shown in Fig. 1 performs processing to generate journal entry data including amounts relating to debit and credit account items based on transaction data including records relating to transactions (date, transaction content, amount, etc.). The system shown in Fig. 1 includes an information processing device 1, a terminal device 3, and an accounting server 5, which are capable of communicating with each other via a communication network 9 such as the Internet. The information processing device 1 is an example of an information processing device of the present invention.

[0012] [Accounting Server 5] The accounting server 5 is a computer on which accounting software runs, and inputs accounting data, manages accounting books, prepares financial statements, etc. in response to requests from the terminal devices 3 accessed via the communications network 9.

[0013] [Terminal device 3] The terminal device 3 is a device equipped with information and communication functions such as a personal computer, tablet, or smartphone, and is operated by a user who performs accounting work in a company or the like. The terminal device 3 is equipped with a processing unit, a storage unit, and a communication unit similar to the communication unit 11, the storage unit 12, and the processing unit 13 of the information processing device 1 described later, as well as an input unit (input devices such as a touch panel, a mouse, and a keyboard) for inputting user instructions to the processing unit, and a display device (liquid crystal display, organic EL display, projector, etc.) for displaying information. The terminal device 3 accesses the information processing device 1 and performs a process of uploading data including transaction records (dates, contents, amounts, etc. related to transactions) to the information processing device 1, and a process of acquiring information on transactions that have been subjected to journalization processing from the information processing device 1. The terminal device 3 also accesses the accounting server 5 and performs a process of importing information on transactions that have been subjected to journalization processing by the information processing device 1 into accounting software.

[0014] 1, the terminal device 3 is connected to a scanner 4 (image capture device) and can capture an image of a document using the scanner 4. For example, the terminal device 3 can capture an image of a document (transaction slip, transaction statement, etc.) on which a transaction record is recorded using the scanner 4, convert the captured image into a file of a predetermined format (PDF file, image file, etc.), and upload it to the information processing device 1.

[0015] [Information processing device 1] The information processing device 1 acquires transaction data related to transactions from data uploaded from the terminal device 3 (tabular data including transaction records, image data of documents containing transaction records, etc.), and generates journal data (described later) based on the acquired transaction data. For example, the information processing device 1 includes one or more computers. The information processing device 1 shown in the example of FIG. 1 has a communication unit 11, a storage unit 12, and a processing unit 13.

[0016] The communication unit 11 communicates with other devices (such as the terminal device 3) via the communication network 9. The communication unit 11 includes a device (such as a network interface card) that communicates in compliance with a predetermined communication standard such as Ethernet (registered trademark) or wireless LAN.

[0017] The storage unit 12 stores one or more programs 121 including instructions executable by the processing unit 13, data temporarily stored during processing by the processing unit 13, data used in processing by the processing unit 13, data obtained as a result of processing by the processing unit 13, and the like. The storage unit 12 may include, for example, a main storage device (RAM, ROM, etc.) and an auxiliary storage device (flash memory, SSD, hard disk, memory card, optical disk, etc.). The storage unit 12 may be composed of one storage device or multiple storage devices. When the storage unit 12 is composed of multiple storage devices, each storage device is connected to the processing unit 13 via a computer bus or any other communication means.

[0018] The processing unit 13 generally controls the overall operation of the information processing device 1 and executes a predetermined information processing. The processing unit 13 includes, for example, one or more processors (such as a central processing unit (CPU), a micro-processing unit (MPU), or a digital signal processor (DSP)) that executes processing in accordance with instructions of one or more programs 121 stored in the storage unit 12. The processing unit 13 operates as a computer by the one or more processors executing instructions of one or more programs 121 stored in the storage unit 12. The information processing device 1 may include a plurality of such computers, and these computers may execute processing in cooperation with each other by communicating with each other via an arbitrary communication network.

[0019] The processing unit 13 may include one or more dedicated hardware (such as an application specific integrated circuit (ASIC) or a field-programmable gate array (FPGA)) configured to realize a specific function. In this case, the processing unit 13 may execute all of the processes described in this embodiment in a computer, or may execute at least a part of the processes in dedicated hardware.

[0020] The program 121 may be recorded, for example, in a computer-readable recording medium (optical disk, memory card, USB memory, or other non-transitory tangible medium). The processing unit 13 may read at least a part of the one or more programs 121 recorded in such a recording medium by a recording medium reading device (optical disk device, etc.) or an interface device (USB interface, etc.) not shown, and write the program 12 in the storage unit 12. Alternatively, the processing unit 13 may download at least a part of the one or more programs 121 from another device connected to the communication network 9 by the communication unit 11, and write the program 12 in the storage unit 12. The program 121 may include an instruction to cause the processing unit 13 to perform at least a part of the processing according to this embodiment described later.

[0021] Here, the journalization process performed by the information processing device 1 having the above-mentioned configuration will be described. FIG. 2 is a diagram for explaining an example of a journalizing process by the information processing device 1, and shows an example of a process for generating journalizing data based on data relating to a transaction record uploaded from the terminal device 3. As shown in FIG. Step ST105 is an example of a determination step of the present invention. Step ST115 is an example of a data generating step of the present invention.

[0022] ST100: When data related to a transaction record is uploaded from the terminal device 3, the information processing device 1 acquires the uploaded data as transaction data related to the transaction. One piece of transaction data is data related to one or a group of transactions, and includes multiple first item data corresponding to multiple predetermined items related to the transaction. The data uploaded from the terminal device 3 includes one or more transaction data.

[0023] One transaction data includes, for example, at least a part of the first item data listed below. Transaction details data (item 1 data on the contents of the transaction) - First amount data (first item data showing the amount of one transaction item) Date data (first item of data regarding the date of the transaction)

[0024] ST105: The information processing device 1 determines data for each item of the journal data (second item data) based on the transaction data acquired in step ST100. One journal data includes multiple second item data. The information processing device 1 determines each second item data of one journal data based on one transaction data.

[0025] One piece of journal data includes, for example, at least a part of the second item data listed below. Account data (second item data related to the debit or credit account) Sub-item data (second item data on sub-items that classify the contents of debit or credit account items) Second amount data (second item data showing the amount of the debit or credit account item) Department data (second item data on the debit or credit department) Tax category data (second item of data on the tax category of the debit or credit) Summary data (second item data regarding the summary of the debit or credit) Date data (second item data regarding the date of the transaction related to the journal entry)

[0026] In this embodiment, each of the multiple second item data in the journal data is associated with one or more first item data. The information processing device 1 determines one second item data based on one or more first item data associated with the one second item data.

[0027] For example, each of the plurality of second amount data in the journalization data is associated with one first amount data. The information processing device 1 determines one second amount data based on one first amount data associated with the one second amount data.

[0028] In addition, some of the second item data in the journal data (for example, account item data, etc.) may be predetermined data. In this case, the information processing device 1 may determine other second item data in the journal data based on the first item data of the transaction data.

[0029] FIG. 3 is a diagram for explaining an example of the correspondence between the first item data of the transaction data and the second item data of the journal data. Table 50 in the lower part of FIG. 3 represents a group of transaction data uploaded from terminal device 3 to information processing device 1, for example, data output from payroll management software (such as a CVS format file). Records in the second to sixth rows of table 50 each represent one transaction data related to a salary paid to an employee at a specific store. One transaction data includes 13 first item data. The first row of table 50 represents 13 item names (predetermined words related to the items) in the transaction data. Table 51 in the upper part of FIG. 3 represents journal data generated based on the transaction data (second row) in table 50 in the lower part.

[0030] The journal entry data shown in table 51 in Fig. 3 has two debit account items and seven credit account items. A journal entry in which there are multiple account items on at least one of the debit and credit sides is generally called a composite journal entry. In the example of Fig. 3, the information processing device 1 performs a composite journal entry.

[0031] In the example of FIG. 3, the second amount data of the debit account items "salary" and "transportation expenses" are associated with the first amount data of the item names "amount paid under tax law" and "total non-taxable amount", respectively. The second amount data of the credit account item "current savings" is associated with the first amount data of the item name "net amount paid". In addition, the second amount data of the credit account item "deposit", which is the second amount data of the credit subsidiary items "income tax", "resident tax", "health insurance", "nursing care insurance", "employee pension insurance", and "employment insurance", is associated with the first amount data of the item names "income tax", "resident tax", "health insurance", "nursing care insurance", "employee pension insurance", and "employment insurance", respectively. The information processing device 1 determines each second item data of the journal data based on the corresponding first item data of the transaction data in accordance with the correspondence relationship between such first item data (first amount data, etc.) and second item data (second amount data, etc.).

[0032] ST110: When each second item data in the journal entry data is determined, the information processing device 1 judges whether the total amount of the second amount data of the debit account items matches the total amount of the second amount data of the credit account items. If the two total amounts do not match, the journal entry has not been performed properly, so the information processing device 1 performs a predetermined error process. For example, the information processing device 1 may send an error notification to the terminal device 3 indicating that the total amount of the debit account items does not match the total amount of the credit account items, and display the error notification on the display of the terminal device 3. This makes it possible to prompt the user of the terminal device 3 to check whether there are any errors in the uploaded data.

[0033] ST115: If it is determined in step ST110 that the total amounts of the account items match, the information processing device 1 generates journal entry data including the second item data (second amount data for each account item, etc.) determined in step ST105. For example, the information processing device 1 generates a file of journal entry data having a predetermined format (e.g., a file in CSV format) that can be imported into the accounting software of the accounting server 5.

[0034] The information processing device 1 provides the journal data file generated in step ST115 to the terminal device 3. The terminal device 3 uploads the journal data file acquired from the information processing device 1 to the accounting server 5, and causes the accounting software running on the accounting server 5 to import the journal data file.

[0035] As described above, in this embodiment, each of the multiple second amount data (second item data) indicating the amounts of multiple account items in the journal data is associated with the first amount data (first item data) indicating the amount of a specific item related to the transaction in the transaction data. When transaction data is acquired from the terminal device 3, each of the multiple second amount data included in the journal data is determined based on one or more first amount data included in the acquired transaction data. At this time, one piece of second amount data is determined based on one piece of first amount data associated with the one piece of second amount data. Then, the journal data is generated so as to include the second amount data of each determined account item. Therefore, journalization can be performed automatically from data related to a transaction.

[0036] Next, the accounting process when an image of a document (transaction slip, transaction statement, etc.) captured by the scanner 4 is uploaded from the terminal device 3 to the information processing device 1 will be described.

[0037] In this case, in step ST100 (FIG. 2), the information processing device 1 performs optical character recognition (OCR) on the image of the document uploaded from the terminal device 3 to read a character string from the image of the document, and acquires the read character string as document read data. The document read data acquired by OCR from the image of the document related to the transaction record includes the above-mentioned transaction data.

[0038] The OCR process of the document image may be performed in the terminal device 3. In this case, the information processing device 1 may obtain the document scan data uploaded from the terminal device 3 in step ST100. Alternatively, the information processing device 1 may cause an OCR server (not shown) to execute the OCR process on the document image. In this case, the information processing device 1 may transmit the document image uploaded from the terminal device 3 in step ST100 to the OCR server, and receive document read data as a result of the OCR process from the server.

[0039] When the document read data is acquired in step ST100, the information processing device 1 identifies each first item data (such as first amount data) included in the document read data in step ST105. Next, the information processing device 1 determines each second item data (such as second amount data) of the journalization data based on each identified first item data. After determining each second item data of the journalization data, the information processing device 1 performs the above-mentioned steps ST110 and ST115 to generate the journalization data.

[0040] Fig. 4 is a diagram for explaining an example of generating journal data based on data (document scan data) read by OCR from an image of a document related to a transaction record. The lower diagram in Fig. 4 shows a document read by the scanner 4, which is a slip 60 related to a deposit (transfer) from a payment agent involved in credit card payment.

[0041] Below the slip 60, there is a table 52 including details for each applicable credit card. The top row of the table 52 (hereinafter sometimes referred to as the "title row") includes cells (hereinafter sometimes referred to as the "item cells") in which the item names (predetermined words related to the items) of items related to credit card payments are written. The item name "Payment method" is written in the item cell 30, the item name "Number of sales" is written in the item cell 31, the item name "Sales amount" is written in the item cell 32, the item name "Commission rate" is written in the item cell 33, the item name "Commission" is written in the item cell 34, the item name "Settlement amount" is written in the item cell 35, and the item name "Sales period" is written in the item cell 36. The item cell 30 is located at the beginning of the title row, and after the item cell 30, the item cells 31, 32, ..., 36 are lined up in this order.

[0042] The records in the second to sixth rows of Table 52 each show the details of a payment for one credit card. Each record includes values ​​corresponding to the items in the title row.

[0043] The bottom row of table 51 (hereinafter sometimes referred to as the "total row") includes cells (hereinafter sometimes referred to as the "numeric cell") containing a numeric value obtained by summing up the values ​​of all the details (records in rows 2 to 6) related to a specific item. At the beginning of the total row is cell 37 (hereinafter sometimes referred to as the "total cell 37") containing the word "total". The total number of sales is contained in numeric cell 20 belonging to the same column as item cell 31. The total sales amount is contained in numeric cell 21 in the total row belonging to the same column as item cell 32. The total commission is contained in numeric cell 22 in the total row belonging to the same column as item cell 34. The total settlement amount is contained in numeric cell 23 in the total row belonging to the same column as item cell 35. These numeric cells are located in the total row in the order of numeric cells 20, 21, 22, and 23 from the beginning.

[0044] The top of table 52 in slip 60 has columns 40 and 41 in which other information related to the credit card payment transaction is entered. Column 40 contains an identification number (payee number) that indicates the recipient of the credit card payment, and information on the transfer account (name of financial institution, branch name, account). Column 41 contains the transfer date and amount.

[0045] Table 53 at the top of Fig. 4 shows journal entry data generated based on the total of the sales amount, fee, and settlement amount entered in the total row of table 52 of slip 60. The journal entry data represented by table 53 has two debit account items and one credit account item, and in this example as well, the information processing device 1 performs composite journal entry.

[0046] In the example of Fig. 4, the second amount data of the debit account items "Current deposit" and "Payment fee" are respectively associated with the first amount data of the item names "Settlement amount" and "Fees" written in the total row of Table 52. In addition, the second amount data of the credit account item "Sales deposit" is associated with the first amount data of the item name "Sales amount" written in the total row of Table 52.

[0047] FIG. 5 is a diagram for explaining an example of the process (ST105: FIG. 2) for determining the first item data of each item included in the document read data in the example of FIG.

[0048] ST200: The information processing device 1 identifies the first item data (date data) of the item name "Transfer Date" included in the document read data. For example, the information processing device 1 searches for the character string "Transfer Date" in the field 41 in the document read data, and identifies the date data of "Transfer Date" from the character strings adjacent to this character string ("May 1, 2023" in the example of FIG. 4).

[0049] ST205: The information processing device 1 identifies the first item data (transaction details data) of the item name "Payment number" included in the document scan data. For example, the information processing device 1 searches the document scan data for the character string "Payment number" in field 40, and identifies the transaction details data for "Payment number" from the character strings adjacent to this character string ("XYZ1234" in the example of FIG. 4).

[0050] ST210: The information processing device 1 identifies the first item data (first amount data) for each of the item names "Sales Amount," "Handling Fee," and "Payment Amount" included in the document scan data.

[0051] The document read data includes data corresponding to table 52 (hereinafter, sometimes referred to as "table data"). This table data has a predetermined data format (JSON format, CSV format, etc.) that represents the data of each cell of the table. When identifying the first amount data for one item, the information processing device 1 identifies a numerical cell (hereinafter, sometimes referred to as "amount cell") in which an amount is described based on the position of the item cell in which the item name of the one item is described and the position of the total cell 37 in table 52 shown in the table data of the document read data, and identifies the first amount data of the one item based on the numerical value of the identified amount cell. Specifically, the information processing device 1 identifies a cell (a cell belonging to these columns and rows) determined according to the column of the item cell in which the item name of the one item is described and the row of the total cell (total row) as an amount cell, and identifies the numerical value of the identified amount cell as the first amount data of the one item. For example, in table 52 indicated by the table data, the information processing device 1 identifies the cell belonging to the column of item cell 32 in which the item name "Sales Amount" is written and the row (total row) of total cell 37 in which the word "Total" is written as an amount cell (numeric cell) 21 in which the total sales amount is written, and identifies the numerical value "10277360" of the identified amount cell 21 as the first amount data (total sales amount).

[0052] In addition, table 52 shown in the table data of the document scan data may contain blank cells that do not actually exist due to erroneous recognition by OCR. If such blank cells are included in the total row, there is a possibility that the amount cell determined according to the column of the item cell and the row of the total cell is blank. In this case, when identifying first amount data for one item, if the amount cell identified based on the column of the item cell in which the item name of the one item is written and the row of the total cell (total row) is blank, the information processing device 1 may identify the first amount data for the one item based on the numerical value written in the adjacent cell in the same row (total row) as the identified amount cell. This makes it possible to identify the correct first amount data even if the table data contains blank cells that do not actually exist due to erroneous recognition by OCR.

[0053] ST215: The information processing device 1 determines the date data of the journalization data based on the date data of the "transfer date" identified in step ST200.

[0054] ST220: The information processing device 1 determines the sub-account data, department data, and summary data of the journal data based on the transaction content data of the "payee number" identified in step ST205. For example, the information processing device 1 associates the identification information of the recipient of the sales indicated by the "payee number" with the related data of each account item (sub-account data, department data, summary data, etc.) and stores them in the storage unit 12. When the information processing device 1 identifies the "payee number" in step ST205, it reads out the related data of each account item associated with this "payee number" (sub-account data, department data, summary data, etc.) from the storage unit 12.

[0055] In the example of Figure 4, based on the transaction content data "XYZ1234" for the "payment number," the information processing device 1 identifies the sub-account data "Head office" and summary data "Head office / credit amount / ○○ Co., Ltd." related to the debit account item "Current deposit," identifies the department data "Head office" and summary data "Head office / credit fee / ○○ Co., Ltd." related to the debit account item "Payment fee," and identifies the sub-account data "○○ Co., Ltd. / Head office" and summary data "Head office / credit amount / ○○ Co., Ltd." related to the credit account item "Sales deposit."

[0056] ST225: The information processing device 1 determines second amount data for the account items "Current deposit," "Payment fee," and "Sales deposit" based on the first amount data of the total amount of the item names "Sales amount," "Fees," and "Settlement amount" identified in step ST210.

[0057] In the example of Figure 4, the information processing device 1 determines the total of "Sales Amount" "9,763,492," the total of "Fees" "513,868," and the total of "Settlement Amount" "10,277,360" identified in step ST210 as the second amount data for the account items "Current Deposit," "Payment Fee," and "Sales Deposit," respectively.

[0058] As described above, even when document scan data is obtained by OCR from an image of a document related to a transaction, the first amount data (first item data) of each item included in the document scan data is specified, the second amount data (second item data) of each account item is determined based on the first amount data (first item data) of each specified item, and journal data is generated so as to include the determined second amount data of each account item. Therefore, journalization can be performed automatically from data related to a transaction.

[0059] Next, a modification of the above-mentioned step ST210 (FIG. 5) will be described.

[0060] (Modification 1 of step ST210) In the example of step ST210 described above, the amount cell is identified based on the position of the item cell and the position of the total cell in the table, but if the range of the amount cell in the table is fixed (for example, if the row in which the amount cell is located is fixed), the amount cell may be identified based on the position of the item cell in the table. That is, when identifying first amount data for one item, the information processing device 1 may identify the amount cell based on the position of the item cell (for example, the column of the item cell) in which the item name of the one item is written in the table indicated by the table data of the document read data, and identify the first amount data for the one item based on the numerical value of the identified amount cell.

[0061] Furthermore, when identifying the first amount data for one item, if the amount cell identified based on the column of the item cell in which the item name of the one item is written is blank, the information processing device 1 may identify the first amount data for the one item based on the numerical value written in the adjacent cell in the same row as the identified amount cell. This makes it possible to identify the correct first amount data even if the table data contains a blank cell that does not actually exist due to erroneous recognition by OCR.

[0062] (Modification 2 of step ST210) In the above-mentioned example of step ST210, the amount cell is specified based on the position of the item cell in the table (for example, the column of the item cell). However, when the amount cells in which the first amount data of each item is written are located in the same row (hereinafter may be referred to as the "target row"), and when the amount cells of each item are located in a predetermined order from the first numeric cell in a plurality of numeric cells included in the target row, it is possible to specify the amount cell of each item from among the plurality of numeric cells based on the order of each numeric cell appearing in the target row. That is, when specifying the first amount data of one item, the information processing device 1 may count the order of appearance of the numeric cells from the first cell to the last cell of the target row in the table indicated by the table data, and specify the first amount data of the one item based on the numeric value written in the numeric cell (amount cell) that appears in the predetermined order corresponding to the amount cell of the one item.

[0063] In addition, when a predetermined word (e.g., "Total") is written in a cell of a predetermined column (e.g., the first column) in the target row, the information processing device 1 may identify the row in which the predetermined word is written in the predetermined column as the target row.

[0064] If the first cell of the target row is a total cell, the information processing device 1 may count the order in which the numeric cells appear in the table represented by the table data, from the total cell of the target row (total row) to the last cell, and identify the first amount data of an item based on the numeric value written in the numeric cell (amount cell) that appears in a specified order corresponding to the amount cell of the item.

[0065] 4, counting the order in which numeric cells appear from total cell 37 of the target row (total row) toward the last cell, the first is numeric cell 20, the second is amount cell (numeric cell) 21 of the total sales amount, the third is amount cell (numeric cell) 22 of the total fees, and the fourth is amount cell (numeric cell) 23 of the total settlement amount. In this example, the information processing device 1 identifies the second, third, and fourth numeric cells appearing when counting from total cell 37 of the target row (total row) toward the last cell as amount cell 21 (total sales amount), amount cell 22 (total fees), and amount cell 23 (total settlement amount), respectively.

[0066] According to this variant, even if a blank cell is inserted in the target row due to an OCR misrecognition, the order in which the numeric cells appear when counted from the first cell to the last cell in the target row does not change, so the first amount data for each item can be correctly identified.

[0067] It should be noted that the present invention is not limited to the above-described embodiment, but includes various variations.

[0068] For example, in the above-described embodiment, the terminal device 3 accesses the information processing device 1 via the communication network 9, but in other embodiments of the present invention, the user may directly operate the information processing device 1 using a display device (display) and an input device (keyboard, etc.) provided on the information processing device 1.

[0069] Furthermore, part of the processing performed by the information processing device 1 in the above-described embodiment may be executed by the terminal device 3. In this case, a computer system including the information processing device 1 and the terminal device 3 performs the journalization processing as an information processing device according to one embodiment of the present invention.

[0070] Furthermore, if the information processing device 1 can access the accounting server 5, the information processing device 1 may transmit the accounting data file directly to the accounting server 5. [Explanation of symbols]

[0071] 1...information processing device, 11...communication unit, 12...storage unit, 121...program, 13...processing unit, 3...terminal device, 4...scanner, 5...accounting server, 9...communication network, 20...numeric cell, 21-23...amount cell (numeric cell), 30-36...item cell, 37...total cell, 40-41...column, 50-53...table, 60...voucher

Claims

1. A journal entry method performed by an information processing device, comprising: a data acquisition step of acquiring transaction data relating to the transaction; A journalizing step of generating journal data based on the acquired transaction data; having The transaction data includes: one or more first amount data each indicating an amount of an item related to the transaction; The journal data is a plurality of second amount data each indicating an amount of a debit or credit account item; Each of the plurality of second amount data in the journal data is associated with one of the first amount data in the transaction data, The said journalizing step is A determination step of determining each of the plurality of second amount data included in the journal data based on one or more of the first amount data included in the transaction data; and a data generating step of generating the journal data including the second amount data of each of the determined account items, The step of determining the one of the second amount data includes determining the one of the second amount data based on the one of the first amount data associated with the one of the second amount data. Journal entry method.

2. the data acquisition step includes acquiring document scan data that is read from an image of a document related to the transaction by optical character recognition, the document scan data including the transaction data; The determining step includes: a first amount data specifying step of specifying the first amount data for each of the items included in the document read data; and a second amount data determination step of determining the second amount data of each of the account items based on the first amount data of each of the identified items. The journal entry method according to claim 1.

3. the document includes a table; The table includes an item cell in which a predetermined word related to the item is written, and an amount cell in which an amount related to the item is written, the position of the amount cell in which the amount related to one of the items is described is determined according to the position of the item cell in which the predetermined word related to the one of the items is described; the document scan data includes table data corresponding to the table in the document; Identifying the first amount data of one of the items in the first amount data identifying step includes identifying the amount cell based on a position of the item cell in which the predetermined word related to the one item is written in the table indicated by the table data, and identifying the first amount data of the one item based on a numerical value of the identified amount cell. The journal entry method according to claim 2.

4. the position of the amount cell in which the amount related to one of the items is written is determined according to the column of the item cell in which the predetermined word related to the one of the items is written, Identifying the first amount data of one of the items in the first amount data identifying step includes, when the amount cell identified based on the column of the item cell in which the predetermined word related to the one item is written is blank, identifying the first amount data of the one item based on a numerical value written in an adjacent cell in the same row as the identified amount cell. The journal entry method according to claim 3.

5. the document includes a table; The table includes an item cell in which a predetermined word related to the item is written, an amount cell in which an amount related to the item is written, and a total cell in which a word related to a total is written, the position of the amount cell in which the amount related to one of the items is described is determined according to the position of the item cell in which the predetermined word related to the one of the items is described and the position of the total cell; the document scan data includes table data corresponding to the table in the document; Identifying the first amount data of one of the items in the first amount data identifying step includes identifying the amount cell based on the position of the item cell in which the predetermined word related to the one item is written and the position of the total cell in the table indicated by the table data, and identifying the first amount data of the one item based on the numerical value of the identified amount cell. The journal entry method according to claim 2.

6. the position of the amount cell in which the amount related to one of the items is written is determined according to the column of the item cell in which the predetermined word related to the one of the items is written and the row of the total cell; Identifying the first amount data of one of the items in the first amount data identifying step includes, when the amount cell identified based on the column of the item cell in which the predetermined word related to the one item is written and the row of the total cell is blank, identifying the first amount data of the one item based on a numerical value written in an adjacent cell in the same row as the identified amount cell. The journal entry method according to claim 5.

7. the document includes a table; The table includes an amount cell in which an amount related to the item is entered, the amount cells for each of the items are located in the same row; The row in which the amount cell is located is called the target row, The cells in the target row that contain numbers are called numeric cells. The amount cell of each of the items is a numeric value cell located in a predetermined order from the first numeric value cell among the plurality of numeric value cells in the target row, the document scan data includes table data corresponding to the table in the document; Identifying the first monetary data of one of the items in the first monetary data identification step includes counting the order in which the numeric cells appear in the table indicated by the table data from the first cell to the last cell of the target row, and identifying the first monetary data of the one item based on the numeric values ​​written in the numeric cells that appear in the predetermined order corresponding to the monetary cells of the one item. The journal entry method according to claim 2.

8. The table includes a total cell having a total term therein, the first cell of the target row is the total cell, Identifying the first amount data of one of the items in the first amount data identification step includes counting the order of appearance of the numeric cells from the total cell of the target row toward the last cell in the table indicated by the table data, and identifying the first amount data of the one item based on the numeric values ​​written in the numeric cells that appear in the predetermined order corresponding to the amount cells of the one item. The journal entry method according to claim 7.

9. A program including an instruction for causing an information processing device to perform accounting, The process performed by the information processing device in accordance with the command includes each step of the method according to any one of claims 1 to 8. program.

10. An information processing device for performing journal entry, A processing section; A storage unit that stores instructions to be executed by the processing unit, The processing performed by the processing unit in accordance with the instructions includes each step of the method according to any one of claims 1 to 8. Information processing device.

11. An information processing device for performing journal entry, The method includes a means for performing each step of the method for journalizing according to any one of claims 1 to 8. Information processing device.

Images