Journal entry generation device, method, and program

Abstract

To provide a journal entry generation device that can easily generate journal entry on the basis of previously received Peppol e-invoice and contents entered at that time.SOLUTION: According to an embodiment, a journal entry generation device includes: an item setting unit that sets a digital invoice item for determining a transaction type and a digital invoice item for determining a section; a journal entry setting unit that sets an initial journal entry value using a current digital invoice value, a pre-defined digital invoice item, a past digital invoice value, and a transaction type specified in the digital e-invoice; a correction reflection unit that reflects, when the transaction type has been changed, in a line following the line that has been changed this time, changed contents, for a line where a value of a pre-defined digital invoice item matches the line that has been changed this time; and a journal entry generation unit that generates the journal entry by summing up data of e-invoices that have the same transaction type and the section.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a journal entry generating device, method, and program suitable for journal entry input from, for example, a Pepol invoice. [Background technology]

[0002] Normally, in order for a company to grasp its business performance in detail using an accounting system, it is necessary to input journal entries into the accounting system at a granular level. In order to input journal entries at a granular level, such as purchased goods or departments, it is necessary to refer to the details of the invoices, etc., which are the original input documents, rather than the identification section, and this input work becomes a burden for the company. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent No. 6950107 [Non-patent literature]

[0004] [Non-Patent Document 1] https: / / www.digital.go.jp / policies / electronic_invoice (searched on January 17, 2020) Summary of the Invention [Problem to be solved by the invention]

[0005] However, the content of invoices and other documents varies depending on the issuer. In other words, the format (where to write) and the content of invoices and other documents vary depending on the issuer.

[0006] Although the standard specifications (JP-PINT) for digital invoices such as Pepol Invoice have been made public, the items that recipients use to input journal entries into their accounting systems vary depending on the issuer. Therefore, recipients must switch the Pepol Invoice items they refer to when inputting journal entries depending on the issuer.

[0007] This is undesirable because it is time-consuming and increases the burden on the recipient.

[0008] When a recipient enters journal entries from a Pepol Invoice, the account heading is determined based on information such as the sender of the Pepol Invoice, the product name, and its summary. If a Pepol Invoice is received with the same sender and product name, it is normal to enter the same account heading as previously determined in the journal entry.

[0009] The present invention has been made in consideration of the above circumstances, and aims to provide a journal entry generation device, method, and program that can easily generate journal entries based on the previously received Pepol invoice and the content entered at that time. [Means for solving the problem]

[0010] In order to achieve the above object, a first aspect of the present invention is a journal entry generation device that generates journal entries using past digital invoices and content entered for the past digital invoices, and is equipped with: an item setting unit that sets digital invoice items that determine the transaction type and digital invoice items that determine the department; a journal entry setting unit that sets initial values ​​for journal entries using the value of the current digital invoice, pre-set digital invoice items, past digital invoice values, and the transaction type specified in the past digital invoice; a correction reflection unit that, when the transaction type is changed, reflects the changed content in rows following the row changed this time and where the value of the pre-set digital invoice item matches the row changed this time; and a journal entry generation unit that generates journal entries by adding up data on digital invoices that have the same transaction type and department specified.

[0011] A second aspect of the present invention is the journal entry generation device of the first aspect, further comprising a display control unit that creates original data for journal entries based on the values ​​of items on a digital invoice and displays the data on a display.

[0012] A third aspect of the present invention is a journal entry generation device of the first or second aspect, in which the journal entry setting unit sets a specified transaction type in the corresponding line of the past digital invoice when the values ​​of a pre-set digital invoice item match between the current digital invoice and a past digital invoice.

[0013] A fourth aspect of the present invention is a journal entry generation device of the first or second aspect, in which the journal entry setting unit sets a specified department in the corresponding line of the past digital invoice if the values ​​of a pre-set digital invoice item match between the current digital invoice and the previous digital invoice.

[0014] A fifth aspect of the present invention is a journal entry generation method implemented by a journal entry generation device that generates journal entries using past digital invoices and content entered for the past digital invoices, the journal entry generation method including the steps of: the journal entry generation device setting digital invoice items that determine the transaction type and digital invoice items that determine the department; setting initial values ​​for the journal entries using the value of the current digital invoice, pre-set digital invoice items, past digital invoice values, and the transaction type specified in the past digital invoice; if the transaction type is changed, reflecting the changed content in rows following the row changed this time and onwards where the value of the pre-set digital invoice item matches the row changed this time; and generating journal entries by adding up data on digital invoices that have the same transaction type and department specified.

[0015] A sixth aspect of the present invention is a program for generating journal entries using past digital invoices and the content entered for the past digital invoices, and is a program that causes a processor to realize the following functions: a function for setting digital invoice items that determine the transaction type and digital invoice items that determine the department; a function for setting initial values ​​for journal entries using the value of the current digital invoice, pre-set digital invoice items, past digital invoice values, and the transaction type specified in the past digital invoice; a function for, when the transaction type is changed, reflecting the changed content in rows following the row changed this time and where the value of the pre-set digital invoice item matches the row changed this time; and a function for generating journal entries by adding up data on digital invoices that have the same transaction type and department specified. [Effects of the Invention]

[0016] According to the present invention, it is possible to provide a journal entry generation device, method, and program that can easily generate journal entries based on the digital invoice received last time and the content entered at that time. [Brief explanation of the drawings]

[0017] [Figure 1] FIG. 1 is a block diagram showing an example of the electronic circuit configuration of a journal entry generating device to which a journal entry generating method according to an embodiment of the present invention is applied. [Figure 2] Figure 2 is a conceptual diagram showing the entire Pepol Invoice. [Figure 3] Figure 3 is a conceptual diagram showing the entire Pepol Invoice. [Figure 4] FIG. 4 is a conceptual diagram for explaining data items in the journal entry generation basic information column. [Figure 5] FIG. 5 is a diagram illustrating a master including sales tax information, account titles, accounts, and departments. [Figure 6] FIG. 6 is a diagram illustrating a master including approval paths, document types, transaction type groups, and transaction types. [Figure 7] FIG. 7 is a diagram showing an example of a display of an input screen for receiving setting input. [Figure 8] FIG. 8 is a diagram showing an example of original data of journal entries displayed on a display based on the values ​​of the items in the Pepol Invoice according to the sender's business (issuer). [Figure 9] FIG. 9 is a table showing past Pepol invoices and the transaction types specified in the past Pepol invoices. [Figure 10] Figure 10 is a table showing the current Pepol invoice and the transaction type to be automatically set. [Figure 11] FIG. 11 is a diagram showing an example of data in which the same transaction type and department are specified in a Pepol Invoice. [Figure 12] FIG. 12 is a diagram showing an example of journalization in which the data shown in FIG. 11 is added up. [Figure 13] FIG. 13 is a diagram showing an example of the setting contents of FIG. DETAILED DESCRIPTION OF THE INVENTION

[0018] Hereinafter, embodiments of the present invention will be described with reference to the drawings. The drawings are schematic or conceptual, and the relationship between the thickness and width of each part, the size ratio between parts, etc., are not necessarily the same as those in reality. Furthermore, even when the same part is shown, the dimensions and ratios may be different depending on the drawing. In this specification and each drawing, elements similar to those previously described with reference to the previous drawings are designated by the same reference numerals, and detailed and redundant explanations will be omitted as appropriate.

[0019] FIG. 1 is a block diagram showing an example of the electronic circuit configuration of a journal entry generating device to which a journal entry generating method according to an embodiment of the present invention is applied.

[0020] The journal entry generation device 20 is a device that generates journal entries using past Pepol invoices and the content entered for the past Pepol invoices, and has an electronic circuit configuration as shown in Figure 1. The journal entry generation device 20 can be realized by a computer such as a PC.

[0021] As illustrated in FIG. 1, the journal entry generation device 20 includes a CPU 22, a recording medium reading unit 23, an input unit 25 such as a keyboard or mouse, a display 24, a storage device 26, and a memory 30, all connected to one another by a bus 21.

[0022] The memory 30 stores an item setting program 310 , an initial display program 320 , an automatic setting program 330 , a correction reflecting program 340 , and a journal generation program 350 .

[0023] The CPU 22 is a processor that controls the operation of each unit in the journal entry generating device 20 in accordance with each program 310 to 350 stored in the memory 30.

[0024] The storage device 26 is made up of, for example, an SSD (Solid State Drive) or an HDD (Hard Disk Drive), and is capable of storing data on past Pepol Invoices.

[0025] These programs 310 to 350 may be stored in advance in memory 30, or may be read and stored in memory 30 from an external recording medium 27 such as a memory card via recording medium reading unit 23. These programs 310 to 350 are designed not to be rewritable. Details of each of these programs will be described later.

[0026] In addition to the user-unrewritable areas in which these programs 310 to 350 are stored, the memory 30 also has a writable data area 360 as an area for storing rewritable data.

[0027] Figures 2 and 3 are conceptual diagrams showing the entire Pepol Invoice.

[0028] As shown in FIGS. 2 and 3, the Pepol Invoice 10 includes a supplier information section 11, a total information section 12, a detail section 13, and a basic information section 14 for journal entry generation.

[0029] The basic information column 14 for journal entry generation is provided corresponding to each journal entry in the detail section 13, and as it could not be shown in FIG. 2, it is shown in FIG.

[0030] Screens such as those shown in FIGS. 2 and 3 are displayed on the display 24.

[0031] FIG. 4 is a conceptual diagram for explaining data items in the journal entry generation basic information column.

[0032] As shown in FIG. 4, the journal entry generation basic information field 14 includes an edit button field 14a, a transaction type field 14b, and a department field 14c.

[0033] In the edit button column 14a, an edit button 14aa is displayed for each item. The user can change the values ​​in the transaction type column 14b and the department column 14c on the screen by operating the input unit 25 and specifying the edit button 14aa for the desired item.

[0034] The transaction type field 14b is set to the transaction type that is linked to the account code and consumption tax classification code to be set in the journal entry. Figure 4 shows an example in which the code (B52) "Consumables Expense" is set in the transaction type field 14b.

[0035] The code of the department to be set in the journal entry is set in the department column 14c. Fig. 4 shows an example in which the code (000) "common department" is set in the department column 14c.

[0036] The journal entry generating device 20 has a master such as the one shown in Figures 5 and 6 to easily generate journal entries based on the content entered in the Pepol Invoice. The journal entry generating device 20 can have such a master by storing it in the storage device 26.

[0037] FIG. 5 is a diagram illustrating a master including sales tax information, account titles, accounts, and departments.

[0038] The consumption tax information 31 includes tax accounting classification (tax-excluded accounting method or tax-inclusive accounting method), whether taxable sales for the base period are 100 million yen or less, and the like.

[0039] Account title 32 includes a code number (for example, (5211)) for the amount of merchandise purchased, etc.

[0040] The account 33 includes a code number (for example, (5211A)) of the product or the like.

[0041] The department 34 includes a code number (for example, (100)) of a department, branch, or the like.

[0042] FIG. 6 is a diagram illustrating a master including approval paths, document types, transaction type groups, and transaction types.

[0043] The approval route 41, document type 42, and transaction type group and transaction type 43 are correlated, and the upper part of Figure 6 shows an example in which the approval route 41 is (A) for purchase, the first stage is (b) person in charge B, the document type 42 is (A) invoice (for purchase), and the transaction type group and transaction type 43 is (A) for purchase and includes (A01) product purchase A, (A02) product purchase B, and (A03) product purchase C.

[0044] The lower part of Figure 6 shows an example in which the approval route 41 is (B) for expenses, the first stage is (a) person in charge A and (b) person in charge B, the document type 42 is (B) invoice (for expenses), the transaction type group and transaction type 43 are (B) for expenses, and include (A01) stationery expenses, (A02) daily necessities, etc., and (A03) newspaper subscription fees.

[0045] The item setting program 310 is a program for setting items on the Pepol Invoice that determine the transaction type 43 in advance, items on the Pepol Invoice that determine the department 34, etc. The item setting program 310 displays an input screen 241 such as that shown in Figure 7 on the display 24 to receive setting input from the user.

[0046] That is, FIG. 7 is a diagram showing an example of a display of an input screen for accepting setting inputs.

[0047] The input screen 241 displays a register button 241a, a modify button 241b, a delete button 241c, a transaction type group display section 241d, a purchase display section 241e, a Pepol Invoice item column 241f for determining the transaction type (initial value), and a Pepol Invoice item column 241g for determining the cost-bearing department (initial value).

[0048] Furthermore, the Pepol Invoice item field 241f that determines the transaction type (initial value) includes the seller's Pepol ID 241f1, seller's name 241f2, buyer's accounting information 241f3, item name in the transaction details 241f4, item summary in the transaction details 241f5, summary in the transaction details 241f6, and buyer's accounting information in the transaction details 241f7. A check box that accepts selection is displayed in front of each item, and the user can set the Pepol Invoice item that determines the transaction type (initial value) by operating the input unit 25 and checking the desired check box.

[0049] Furthermore, the item field 241g of the Pepol Invoice that determines the cost-bearing department (default value) includes the login user ID 241g1, the seller's Pepol ID 241g2, the buyer's accounting information 241g3, the delivery destination name 241g4, the item summary in the transaction details 241g5, the summary in the transaction details 241g6, and the buyer's accounting information in the transaction details 241g7. A check box is displayed in front of each item to accept selection, and the user can set the Pepol Invoice item that determines the cost-bearing department (default value) by operating the input unit 25 and checking the desired check box.

[0050] Multiple types of this setting can be registered, and in the storage device 26 where Pepol Invoice is saved, it is possible to associate each master of document type 42. This allows the initial display program 320 to create original journal entry data based on the values ​​of Pepol Invoice items corresponding to the sending business (issuer), and to initially display it on the display 24.

[0051] FIG. 8 is a diagram showing an example of original data of journalization displayed on the display 24 based on the values ​​of the items of the Pepol Invoice according to the sender business (issuer).

[0052] Please note that the areas surrounded by cloud marks in the figure are explanatory text for explaining the items, and are not displayed on the screen of the display 24.

[0053] The original data 251 of the transaction displayed on the screen includes the name of the delivery destination 251a, the item name in the transaction details 252b, the application in the transaction details 252c, the item application in the transaction details 252d, the buyer accounting information in the transaction details 252e, and the buyer accounting information 252f, but the items displayed are not limited to these.

[0054] The automatic setting program 330 automatically sets the initial values ​​of the journal entry for transaction type 14b, for example, as illustrated in Figure 4, using the value of the current Pepol invoice, pre-set Pepol invoice items, past Pepol invoice values, and transaction types specified in past Pepol invoices.

[0055] The automatic setting program 330 also automatically sets the specified transaction type 14b in the corresponding line of the past Pepol invoice if the values ​​of the pre-set Pepol invoice items match between the current Pepol invoice and the previous Pepol invoice.

[0056] These automatic sets are illustrated using FIGS. 9 and 10. FIG.

[0057] FIG. 9 is a table showing past Pepol invoices and the transaction types specified in the past Pepol invoices.

[0058] Figure 10 is a table showing the current Pepol invoice and the transaction type to be automatically set.

[0059] In both Figures 9 and 10, the settings for "Pepol Invoice items that determine the transaction type (initial value)" are the seller's Pepol ID, seller's name, and transaction details item description.

[0060] Similarly, for department 14c shown in Figure 4, if the values ​​for pre-set Pepol Invoice items, etc., match between the current Pepol Invoice and the previous Pepol Invoice, the automatic setting program 330 automatically sets the department specified in the corresponding row of the previous Pepol Invoice as the initial value.

[0061] For example, in Figure 4, when the edit button 14aa for a certain row is selected and the corresponding transaction type 14b is changed, the correction reflection program 340 will reflect the changed content in rows that meet the following condition, i.e., rows following the row that was changed this time and whose values ​​for pre-set Pepol Invoice items, etc., match those of the row that was changed this time.

[0062] When generating journal entries from Pepol Invoice detail data, the journal entry generation program 350 sums up data from Pepol Invoices that have the same transaction type 14b and department 14c specified, as shown in Figure 11, to generate journal entries such as those shown in Figure 12. The settings in Figure 11 are as shown in Figure 13.

[0063] As described above, the journal entry generation device to which the journal entry generation method of this embodiment is applied makes it possible to easily generate journal entries based on the previously received Pepol invoice and the information entered at that time.

[0064] It also absorbs the differences in Pepol Invoice formats depending on the issuer, and can initially display the original journal data according to the values ​​of pre-set Pepol Invoice items, making it possible to generate journal data from Pepol Invoices from various issuers. This reduces the burden on recipients.

[0065] Although the best mode for carrying out the present invention has been described above with reference to the accompanying drawings, the present invention is not limited to such a configuration. Those skilled in the art may conceive of various modifications and alterations within the scope of the technical ideas of the invention as defined in the claims, and it is understood that such modifications and alterations also fall within the technical scope of the present invention. [Explanation of symbols]

[0066] 10 Pepol Invoice 11. Customer information section 12 Total information column 13 Details section 14 Basic information for journal entry generation 14a Edit button field 14aa Edit button 14b Transaction type column 14c Department field 20 Journal entry generator 21 Bus 22 CPU 23 Recording medium reading unit 24 displays 25 Input section 26 Storage device 27 External storage media 30 memory 31 Consumption tax information 32 Accounts 33 accounts 34 departments 41 Approval Route 42 Document Types 43 Transaction Types 241 Input Screen 241a Registration button 241b Edit button 241c Delete button 241d Transaction type group display section 241e Purchase display section 241f Pepol invoice item column 241f1 Seller's Pepol ID 241f2 Name of seller 241f3 Buyer's accounting information 241f4 Item name in transaction details 241f5 Item description in transaction details 241f6 Transaction details 241f7 and buyer accounting information in the transaction statement 241g Pepol invoice item column 241g1 Login User ID 241g2 Seller Pepol ID 241g3 Buyer's accounting information 241g4 Name of delivery destination 241g5 Item description in transaction statement 241g6 Transaction statement description 241g7 and buyer accounting information in the transaction statement 251 Original data for journal entries 251a Name of delivery destination 252b Item name in transaction details 252c Application within transaction details 252d Applicable to items in transaction details 252e Buyer Accounting Information in Transaction Statement 252f and buyer accounting information 310 Item Setting Program 320 Initial display program 330 Auto Set Program 340 Correction Reflection Program 350 Journal Entry Generator 360 writable data area

Claims

1. A journal entry generation device that generates a journal entry by using a past digital invoice and content input to the past digital invoice, an item setting unit that sets digital invoice items that determine the transaction type and digital invoice items that determine the department; a journal entry setting unit that sets an initial value of the journal entry using the value of the current digital invoice, pre-set digital invoice items, the value of the past digital invoice, and the transaction type specified in the past digital invoice; a correction reflecting unit that, when the transaction type is changed, reflects the changed content in rows following the row in which the value of a preset digital invoice item matches the row in which the transaction type is changed; a journal entry generation unit that generates journal entries by summing up data of the digital invoices that are designated with the same transaction type and department; A journal entry generating device comprising:

2. The journal entry generation device according to claim 1 , further comprising a display control unit that creates original data for the journal entry based on the values ​​of the items on the digital invoice and displays the original data on a display.

3. The journal entry generation device according to claim 1 or 2, wherein if the values ​​of a pre-set digital invoice item match between the current digital invoice and a past digital invoice, the journal entry setting unit sets the specified transaction type in the corresponding line of the past digital invoice.

4. The journal entry generation device according to claim 1 or 2, wherein the journal entry setting unit sets a specified department in the corresponding line of the past digital invoice when the values ​​of a pre-set digital invoice item match between the current digital invoice and the previous digital invoice.

5. A journal entry generation method implemented by a journal entry generation device that generates a journal entry using a past digital invoice and content entered for the past digital invoice, comprising: The journal entry generation device A step of setting a digital invoice item for determining a transaction type and a digital invoice item for determining a department; A step of setting an initial value of the journal entry using the value of the current digital invoice, the items of the digital invoice that have been set in advance, the value of the past digital invoice, and the transaction type specified in the past digital invoice; When the transaction type is changed, reflecting the changed content in the lines following the changed line and subsequent lines in which the values ​​of pre-set digital invoice items match the changed line; generating a journal entry by summing up data of the digital invoices that are designated with the same transaction type and category; Journal entry generation methods, including:

6. A program for generating journal entries using past digital invoices and content entered for the past digital invoices, A function to set digital invoice items that determine the transaction type and digital invoice items that determine the department, A function to set the initial value of the journal entry using the value of the current digital invoice, the items of the pre-set digital invoice, the value of the past digital invoice, and the transaction type specified in the past digital invoice; When the transaction type is changed, a function to reflect the change in the lines following the changed line and onwards where the value of the pre-set digital invoice item matches the changed line; A function to generate journal entries by summing up data of the digital invoice that has the same transaction type and category specified. A program that causes a processor to execute the operation.

Images