Business support device, business support method, and business support program

Abstract

To provide a business support device that can automatically create a journal entry definition master and reduce labor of an operator who creates a journal entry definition master.SOLUTION: A pattern information detection unit refers to an item definition master including usage item information indicating items used in calculating the amount of money among items of money to be paid and items of money to be deducted, and pattern information of a pattern indicating debit or credit account items of journal entry data corresponding to items indicated by the usage item information, and detects pattern information of account items for each item. An account item detection unit refers to a journal entry definition template master where debit or credit account items set in the journal entry data are stored for each piece of pattern information, and detects the account items of the journal entry data corresponding to each piece of pattern information. Then, a journal entry definition master automatic creation unit automatically creates, on the basis of the detected account items, a journal entry definition master including items and account items for each piece of pattern information.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]

[0002] Nowadays, for example, money paid to employees includes salary and bonus payments, and in salary and bonus payments, for example, basic salary, position allowance, overtime pay, commuting allowance (tax exemption), etc. Similarly, money deducted from money paid to employees includes salary deduction and bonus deduction, and in salary deduction and bonus deduction, for example, health insurance premiums, income tax, employment insurance premiums, and year-end tax adjustment shortfalls are deducted.

[0003] A payroll system, which is an example of a system in which such monetary payments and deductions are made, calculates salaries or bonuses, etc., taking into account an employee's pay system and work performance, and makes payments to employees, pays taxes, or files tax returns, etc.

[0004] In corporate management, the payment of salaries and bonuses does not mean that the work is complete; the results must be accounted for and reflected in the financial accounting system. Patent Document 1 (JP Patent Publication 2021-121919) discloses a financial settlement support system that automates the creation of tax return documents regardless of their type, reducing the burden of creating them when different accounting software is used for each corporation to manage corporate information and accounting information.

[0005] As mentioned above, in business management, it is necessary to make journal entries for salaries and bonuses that have been paid or deducted and to reflect them in the financial accounting system. In addition to directly registering journal entries in the financial accounting system, it is common to also link and register journal data generated in other business systems. [Prior art documents] [Patent documents]

[0006] [Patent Document 1] Patent Publication No. 2021-121919 Summary of the Invention [Problem to be solved by the invention]

[0007] However, in order to convert various registered contents, including payroll generated in other business systems, into correct financial journal entries on the financial accounting system side and link them, it is necessary to create in advance a journal entry definition master that is referenced when making financial journal entries on the financial accounting system side. This journal entry definition master needs to be created by performing complex conversion settings that take into account the journal entries of the other business systems that are linked and the financial accounting systems that are linked, and there was a problem that creating the journal entry definition master required a lot of effort.

[0008] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable the automatic creation of a journal entry definition master and reduce the effort required of an operator who creates the journal entry definition master. [Means for solving the problem]

[0009] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention has a pattern information detection unit that refers to an item definition master including usage item information indicating items used in calculating money among monetary items to be paid and monetary items to be deducted, and pattern information of patterns indicating debit or credit account items of journal data corresponding to the items indicated in the usage item information, and detects pattern information of account items for each item; an account item detection unit that refers to a journal entry definition template master in which debit or credit account items set in the journal entry data for each pattern information, and detects account items of the journal entry data corresponding to each pattern information; and an automatic journal entry definition master creation unit that automatically creates a journal entry definition master including items and account items for each pattern information based on the account items detected by the account item detection unit.

[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the business support method of the present invention includes a pattern information detection step in which a pattern information detection unit refers to an item definition master including usage item information indicating items used in calculating money among monetary items to be paid and monetary items to be deducted, and pattern information of patterns indicating debit or credit account items of journal data corresponding to the items indicated in the usage item information, and detects pattern information of account items for each item; an account item detection step in which an account item detection unit refers to a journal entry definition template master in which debit or credit account items to be set in the journal entry data for each pattern information are stored, and detects account items of the journal entry data corresponding to each pattern information; and an automatic journal entry definition master creation step in which an automatic journal entry definition master creation unit automatically creates a journal entry definition master including items and account items for each pattern information based on the account items detected in the account item detection step.

[0011] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support program of the present invention causes a computer to function as a pattern information detection unit that refers to an item definition master including usage item information indicating the items used in calculating the amounts of money among the monetary items to be paid and the monetary items to be deducted, and pattern information of patterns indicating the debit or credit account items of the journal data corresponding to the items indicated in the usage item information, and detects the pattern information of the account items for each item; an account item detection unit that refers to a journal entry definition template master in which the debit or credit account items set in the journal entry data for each piece of pattern information are stored, and detects the account items of the journal entry data corresponding to each piece of pattern information; and an automatic journal entry definition master creation unit that automatically creates a journal entry definition master including items and account items for each piece of pattern information based on the account items detected by the account item detection unit. Effect of the Invention

[0012] The present invention can automatically create a journal entry definition master, thereby reducing the labor required of an operator who creates the journal entry definition master. [Brief description of the drawings]

[0013] [Figure 1] FIG. 1 is a block diagram illustrating a hardware configuration of a task support device according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the item definition master. [Diagram 3] FIG. 3 is a diagram illustrating an example of a journal entry definition template master. [Figure 4] FIG. 4 is a diagram illustrating an example of the journal entry definition master. [Diagram 5] FIG. 5 is a flowchart showing the flow of an automatic journal definition master generation operation and a journal data recording operation in the business support device according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of an item definition master maintenance screen for setting each setting item of salary payment. [Figure 7] FIG. 7 is a diagram showing an example of an item definition master maintenance screen for setting each setting item of salary deduction. [Figure 8] FIG. 8 is a diagram showing an example of employee payment data. [Figure 9] FIG. 9 is a diagram illustrating an example of employee deduction data. [Figure 10] FIG. 10 is a diagram showing an example of employee transfer data. [Figure 11] FIG. 11 is a diagram for explaining examples of journal entries for each item. [Figure 12] FIG. 12 is a diagram showing an example of setting the item definition master based on the item definition maintenance screen. [Figure 13] FIG. 13 is a diagram showing an example of a journal entry definition master maintenance screen when creating a journal entry definition master for a basic salary. [Figure 14] FIG. 14 is a diagram showing an example of a journal entry definition master maintenance screen when creating a journal entry definition master for health insurance (individual). [Figure 15] FIG. 15 is a diagram illustrating an example of a journal entry definition master corresponding to the first pattern. [Figure 16]FIG. 16 is a diagram illustrating an example of a journal entry definition master corresponding to the second pattern. [Figure 17] FIG. 17 is a diagram showing an example of a journal entry definition master corresponding to the third pattern. [Figure 18] FIG. 18 is a diagram showing an example of a journal entry definition master corresponding to the fourth pattern. [Figure 19] FIG. 19 is a diagram showing an example of a journal entry definition master corresponding to the fifth pattern. [Figure 20] FIG. 20 is a diagram showing a portion of the employee payment data and a portion of the employee deduction data. [Figure 21] FIG. 21 is a diagram illustrating an example of journal data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] A business support device according to an embodiment of the present invention will be described in detail below with reference to the drawings. As an example, this embodiment is an example in which the business support device automatically creates a "journal entry definition master" and uses this journal entry definition master to generate journal entry data for payments and deductions made to employees and to record the data in the accounting system, thereby supporting the work of accounting staff and the like. Note that the present invention is not limited to the following embodiment, which is described merely as an example.

[0015] (Hardware configuration) 1, the business support device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.

[0016] The communication interface unit 4 is connected to a network 50, for example, a wide area network such as the Internet or a private network such as a LAN (Local Area Network). An accounting server device 51 is connected to the network 50. The accounting server device 51 is provided with an accounting system 52, which is software. Journal data such as salary created by the business support device 1 of the embodiment is transmitted to the accounting server device 51 and recorded in the accounting system 52. Note that, as shown by the dotted line block in FIG. 1, the accounting system 52 may be provided in the memory unit 2 of the business support device 1, and the journal data may be recorded in this accounting system 52.

[0017] The storage unit 2 may be, for example, a read only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD). The storage unit 2 stores an operation support program that automatically creates a "journal entry definition master" and supports the operation of creating journal entry data of the salaries paid to employees and the deducted money based on the journal entry definition master and recording the data in the accounting system 52.

[0018] The storage unit 2 also stores an item definition master 11, a journal entry definition template master 12, and a journal entry definition master 13, which will be described later.

[0019] (Item definition master) Fig. 2 is a diagram showing an example of the item definition master 11. As shown in Fig. 2, the item definition master 11 includes various information such as a setting item name, a total payment flag (total payment FLG), a total taxable amount flag (total taxable amount FLG), a social insurance flag (social insurance FLG), a labor insurance flag (labor insurance FLG), a total deduction flag (total deduction FLG), and a pattern type.

[0020] The setting item names are the names of the monetary items to be paid and the monetary items to be deducted. In the example of Figure 2, for example, they are basic salary, monthly basic salary, basic salary adjustment amount, position allowance, monthly position allowance, position allowance adjustment amount, overtime pay, taxable commuting allowance, non-taxable commuting allowance, dormitory fees, stockholding association, other deductions, individual health insurance, health insurance company, income tax, positive net payment amount, negative net payment amount, year-end adjustment excess or shortfall, etc.

[0021] The total payment flag is information that indicates whether or not the monetary value of the item is used in calculating the total amount of salary paid to all employees (total payment). "TRUE" is set for items used in calculating total payment, and "FALSE" is set for items not used in calculating total payment.

[0022] In other words, the total pay flag is information that indicates whether or not the amount of the item is to be added up to the total pay on the pay slip, and is calculated using the formula "Net pay = Total pay - Total deductions." In the example in Figure 2, "TRUE" is set for the items of basic salary, position allowance, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable).

[0023] The total tax amount flag is information that indicates whether or not the monetary amount of the item is used in calculating the total amount (taxable) taxed to all employees. "TRUE" is set for items that are used in calculating the total tax amount, and "FALSE" is set for items that are not used in calculating the total tax amount. In the example in Figure 2, "TRUE" is set for the items of basic salary, position allowance, overtime pay, and commuting allowance (taxable).

[0024] The social insurance flag is information that indicates whether or not the money of the item is used in the calculation of social insurance. "TRUE" is set for items used in the calculation of social insurance, and "FALSE" is set for items not used in the calculation of social insurance. In the example of Figure 2, "TRUE" is set for the items of basic salary, position allowance, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable).

[0025] The labor insurance flag is information that indicates whether or not the monetary amount of the item is used in the calculation of labor insurance. "TRUE" is set for the item used in the calculation of labor insurance, and "FALSE" is set for the item not used in the calculation of labor insurance. In the example of Figure 2, "TRUE" is set for the items of basic salary, position allowance, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable).

[0026] The total deduction flag is information that indicates whether the amount of the item is used in calculating the total amount of deductions for all employees. "TRUE" is set for the item that is used in calculating the total amount of deductions, and "FALSE" is set for the item that is not used in calculating the total amount of deductions.

[0027] In other words, the total deduction flag indicates whether or not the amount of the item is to be added to the total deduction amount in the pay slip information, and is calculated using the formula "Net pay amount = Total pay amount - Total deduction amount." In the example in Figure 2, "TRUE" is set for the items of dormitory fees, stock ownership plan, other deductions, health insurance (individual), income tax, and year-end adjustment excess / deficit.

[0028] The pattern type is information in which the account items when the monetary transaction of the item is made are patterned and assigned a pattern number. In the example of Fig. 2, the pattern number of the first pattern is set as the pattern number of the account items for basic salary, basic salary monthly amount, basic salary adjustment amount, position allowance, position allowance monthly amount, position allowance adjustment amount, overtime pay, taxable commuting allowance, and non-taxable commuting allowance. In the example of Fig. 2, the pattern number of the second pattern is set as the pattern number of the account items for dormitory expenses, stock ownership plan, other deductions, individual health insurance, and income tax.

[0029] In the example of Fig. 2, the pattern number of the third pattern is set as the pattern number of the account item for the net pay amount (positive) and the net pay amount (negative). In the example of Fig. 2, the pattern number of the fourth pattern is set as the pattern number of the account item for health insurance (company). In the example of Fig. 2, the pattern number of the fifth pattern is set as the pattern number of the account item for the year-end adjustment excess / deficiency amount.

[0030] The settings of the various flags and pattern types for the item definition master 11 are preset based on an item definition master maintenance screen, which will be described with reference to Figures 6 and 7. This will be described in detail later.

[0031] (Journal entry definition template master) Fig. 3 is a diagram showing an example of the journal entry definition template master 12. As shown in Fig. 3, the journal entry definition template master 12 includes various information such as a pattern type, a pattern name, a debit general account item, a debit sub-item, a credit general account item, a credit sub-item, and a credit customer.

[0032] The pattern types are the above-mentioned first to fifth pattern numbers. The pattern names are the names of the patterns of each pattern number. In the example of FIG. 3, the pattern name "Payment items" is set for the first pattern, and the pattern name "Deduction items" is set for the second pattern. Also, in the example of FIG. 3, the pattern name "Net payment amount" is set for the third pattern, and the pattern name "Company share" is set for the fourth pattern. Also, in the example of FIG. 3, the pattern name "Year-end adjustment excess / shortfall" is set for the fifth pattern.

[0033] In the example of Figure 3, for the payment items, which are the first pattern, the account number "660" indicating the account "salary" is set as the total debit account, and for the deduction items, which are the second pattern, the account number "710" indicating the account "deposit" is set as the total credit account.

[0034] In the example of Fig. 3, for the net payment amount, which is the third pattern, the account number "810" indicating the account item "deposit" is set as the total account item on the credit side, and for the company's share, which is the fourth pattern, the account number "510" indicating the account item "legal welfare expenses" is set as the total account item on the debit side, and the account number "400" indicating the account item "accrued expenses" is set as the total account item on the credit side. In the example of Fig. 3, for the year-end adjustment excess / deficit, which is the fifth pattern, the account number "710" indicating the account item "deposit" is set as the total account item on the credit side.

[0035] (Journal entry definition master) Fig. 4 is a diagram showing an example of the journal entry definition master 13. As shown in Fig. 4, the journal entry definition master 13 includes various information such as a definition number, a target item, a debit general account item, a debit sub-item, a debit customer, a credit general account item, a credit sub-item, and a credit customer.

[0036] The above-mentioned journal entry definition template master 12 is referenced based on the pattern type (pattern type of the item definition master in FIG. 2) attached to the item of the money that was paid or deducted, and an account item corresponding to the pattern type is detected. Then, the detected account item is set in this journal entry definition master 13 as the account item corresponding to the journal entry of that item. In this way, the journal entry definition master 13 is automatically created. This will be described in detail later.

[0037] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the storage unit 2, thereby functioning as a display control unit 21, an item definition master maintenance processing unit 22, a payroll calculation processing unit 23, a transfer data creation processing unit 24, and a pattern information detection unit 25, as shown in Fig. 1. In addition, the control unit 3 executes the business support program, thereby functioning as an account subject detection unit 26, an automatic journal entry definition master creation unit 27, a journal entry data generation unit 28, and a communication control unit 29.

[0038] The display control unit 21 displays an item definition master maintenance screen for setting the item definition master 11, a journal entry definition master maintenance screen for setting the journal entry definition master 13, and the like, via the output device 7. The item definition master maintenance processing unit 22 refers to the journal entry definition template master 12, and performs processing such as automatically inputting account items of pattern types corresponding to items input to the item definition master maintenance screen, and the like.

[0039] The payroll calculation processing unit 23 calculates the pay to be paid to employees, deductions, bank transfer amounts, etc. The transfer data creation processing unit 24 creates bank transfer data (employee transfer data) for each employee based on the bank transfer amount calculated by the payroll calculation processing unit 23.

[0040] The pattern information detection unit 25 refers to the item definition master 11, which contains usage item information indicating the items used in calculating the amounts among the monetary items to be paid and the monetary items to be deducted (equivalent, for example, to the setting item names of the item definition master 11 in Figure 2), and pattern information of patterns indicating the debit or credit account items of the journal entry data corresponding to the items indicated in the usage item information (equivalent, for example, to the pattern type setting item names of the item definition master 11 in Figure 2), and detects pattern information of the account items for each item.

[0041] The account item detection unit 26 refers to the journal entry definition template master 12, which stores the debit or credit account items to be set in the journal entry data for each detected pattern information, and detects the account items of the journal entry data corresponding to each pattern information.

[0042] The journal entry definition master automatic creation unit 27 automatically creates the journal entry definition master 13 including items and account items for each piece of pattern information based on the account items detected by the account item detection unit 26 .

[0043] The journal data generation unit 28 refers to the journal definition master 13 based on the monetary item to be paid or the monetary item to be deducted, and generates journal data with the account item corresponding to the monetary item to be paid or the account item corresponding to the monetary item to be deducted.

[0044] The communication control unit 29 records the generated accounting data in the accounting system 52 of the accounting server device 51 (or the accounting system 52 of the storage unit 2) via the network 50.

[0045] (Automatic creation of journal definition master and recording of journal data) Next, the flow of the operation of automatically creating the journal entry definition master 13 and the operation of recording journal entry data in the business support device 1 of the embodiment is shown in the flowchart of Fig. 5. The control unit 3 of the business support device 1 executes the business support program stored in the storage unit 2 to perform each process of steps S1 to S6 in the flowchart of Fig. 5.

[0046] In step S1, the item definition master maintenance processing unit 22 performs an item definition master maintenance process for creating the item definition master 11. Specifically, when the operator designates an item definition master maintenance process via the input device 6, the display control unit 21 displays an item definition maintenance screen shown in FIG.

[0047] As shown in Figures 6 and 7, the item definition maintenance screen has an attribute selection field, a category selection field, and a field for selecting items to be used in calculations. As "attributes", various attributes such as company basic, employee, salary attendance, salary payment, salary deduction, bonus attendance, bonus payment, and bonus deduction can be selected. As "categories", each category of all items, fixed, variable, or calculation can be selected.

[0048] The selection columns for items to be used in calculations are formed by orthogonally connecting the columns of each setting item and the rows of the calculation types. The operator selects the setting items to be used in the desired calculation by inputting a check mark in the desired selection column.

[0049] Fig. 6 shows an example in which the attribute "salary payment" is selected and the classification "all items" is selected. When this selection is made, the display control unit 21 displays all the setting items, which are "all items" of the attribute "salary payment", in each column, such as basic salary, monthly basic salary, basic salary adjustment, position allowance, monthly position allowance, position allowance adjustment, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable), as shown in Fig. 6. At the same time, the display control unit 21 displays rows for each calculation type, such as fixed, variable, calculation, total payment, total taxable amount, social insurance, labor insurance, and total deductions.

[0050] The operator selects the setting items to be used for the desired calculation by inputting a check mark in the area (=selection column) where the column of each item and the row of each calculation type overlap. The example in Figure 6 shows that the amounts of each of the items of basic salary, position allowance, overtime pay, commuting allowance (taxable) and commuting allowance (non-taxable) are selected to be used in the calculation of "total pay."

[0051] In contrast, Fig. 7 shows an example in which the attribute "salary deduction" is selected and the classification "all items" is selected. When this selection is made, the display control unit 21 displays all setting items in each column, which are "all items" of the attribute "salary deduction", such as dormitory fees, stockholding association, other deductions, health insurance (individual), health insurance (company), employment insurance (individual), employment insurance (company), income tax, and year-end adjustment excess / shortfall, as shown in Fig. 7. At the same time, the display control unit 21 displays rows for each calculation type, such as fixed, variable, calculation, total payment, total taxable amount, social insurance, labor insurance, and total deductions.

[0052] The operator selects the setting items to be used for the desired calculation by checking the area (=selection column) where the column of each item and the row of each calculation type overlap. In the example of Figure 7, the amounts of each item, such as dormitory fees, stock ownership plan, other deductions, health insurance (individual), employment insurance (individual), income tax, and year-end tax adjustment excess / deficiency, are selected to be used in the calculation of "total deductions."

[0053] When the items (basic salary, income tax, etc.) used to calculate the desired attribute (salary payment or salary deduction, etc.) and type (total payment, total deductions, etc.) are selected in this way, the item definition master maintenance processing unit 22 sets the information of "TRUE" in the calculation type column of the selected item in the item definition master 11 shown in Fig. 2. Note that the item definition master maintenance processing unit 22 sets the information of "FALSE" in the column of the item definition master 11 that is not set on the item definition master maintenance screen, as the item is not used in the calculation.

[0054] In the item definition master maintenance screen shown in Fig. 6, it is set that the setting items of basic salary, position allowance, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable) are used in the calculation of "total pay". Therefore, the item definition master maintenance processing unit 22 sets information of "TRUE" in each column of the setting items of basic salary, position allowance, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable) in the row of "total pay flag" in the item definition master 11, as shown in Fig. 2.

[0055] 7, the item definition master maintenance screen is set to use the setting items of dormitory fee, stock ownership plan, other deduction, health insurance (individual), employment insurance (individual), income tax, and year-end adjustment excess / deficiency in the calculation of "total deduction." Therefore, the item definition master maintenance processing unit 22 sets information of "TRUE" in each of the setting items of basic salary, position allowance, overtime pay, commuting allowance (taxable), and commuting allowance (non-taxable) in the row of "total deduction salary flag" in the item definition master 11, as shown in FIG.

[0056] When the item definition master 11 is created in this way, the process proceeds to step S2 in the flowchart of Fig. 5. In step S2, the payroll calculation processing unit 23 generates employee payment data shown in Fig. 8 and employee deduction data exemplified in Fig. 9 based on each employee's basic salary, position allowance, commuting allowance, dormitory fee, stock ownership plan, other deductions, health insurance (individual), health insurance (company), year-end adjustment excess / deficit amount, etc.

[0057] Then, in step S3, the transfer data creation processing unit 24 generates employee transfer data for each employee, as shown in FIG. 10, based on the employee payment data and the employee deduction data.

[0058] Next, in step S4 of the flowchart in FIG. 5, the journal entry definition master automatic creation unit 27 performs a journal entry definition master maintenance process for automatically creating the journal entry definition master 13 shown in FIG.

[0059] As a basic concept, payroll entries can be patterned as shown in Figures 11(a) and 11(b). Payment item → Debit (salary) Deduction item → Credit (deposit) Net payment amount → Credit (deposit) Company's share → Debit / Credit (Legal welfare expenses / Unpaid expenses) Year-end adjustment excess / deficiency → Credit (deposit)

[0060] For this reason, the journal entry definition master automatic creation unit 27 detects the pattern type of each item based on each setting content (TRUE or FALSE) of the item definition master 11, and based on the detected pattern type, refers to the journal entry definition template master 12 in Fig. 3. Then, as illustrated in Fig. 12, it detects the debit / credit and subject corresponding to the pattern type from the journal entry definition template master 12, and automatically creates the journal entry definition master for each item.

[0061] Total Pay FLG is TRUE -> Pay Item Deduction total FLG is TRUE -> Deduction item System fixed items Net payment amount positive and Net payment amount negative → Net payment amount System fixed items - Company share Year-end adjustment excess / shortfall amount for system fixed items → Year-end adjustment excess / shortfall amount

[0062] The excess or shortfall amount of the year-end adjustment is a refund or additional collection amount due to the year-end adjustment.

[0063] Specifically, when the operator specifies maintenance of the journal entry definition master via the input device 6, the display control unit 21 displays a journal entry definition master maintenance screen, as exemplified in Figs. 13 and 14, via the output device 7. As shown in Figs. 13 and 14, this journal entry definition master maintenance screen has an input field for the target item, an input field for the debit account item, and an input field for the credit account item. The example of Fig. 13 is an example in which the operator has input the target item of "basic salary" into such a journal entry definition master maintenance screen. Also, the example of Fig. 14 is an example in which the operator has input the target item of "health insurance (individual)" into the journal entry definition master maintenance screen.

[0064] The definition numbers are automatically assigned by the journal definition master automatic creation unit 27 and displayed by the display control unit 21. As an example, payment items are automatically numbered in 10th increments starting from 1000, deduction items are automatically numbered in 10th increments starting from 2000, and net payment amounts are automatically numbered in 10th increments starting from 3000 and displayed.

[0065] The pattern information detection unit 25 refers to the item definition master 11 shown in Fig. 2 based on the target item inputted in the journal entry definition master maintenance screen. Since the example in Fig. 13 is an example in which "basic salary" is inputted as the target item, the pattern information detection unit 25 refers to the item definition master 11 to determine whether or not "basic salary" exists among the setting item names whose total salary flag is set to "TRUE". In other words, the pattern information detection unit 25 refers to the item definition master 11 to determine whether or not the total salary flag for "basic salary" is set to "TRUE".

[0066] In the example of Fig. 2, since the total pay flag of "basic salary" is "TRUE", the pattern information detection unit 25 detects the pattern type associated with the setting item of "basic salary". In the example of Fig. 2, the "first pattern" is detected as the pattern associated with the setting item of "basic salary".

[0067] Next, the account item detection unit 26 refers to the journal entry definition template master 12 based on the pattern type detected by the pattern information detection unit 25. Then, it detects the account item associated with the "first pattern". In the example of FIG. 3, the account item number "660" indicating the account item "salary" is set as the total account item on the debit side for the "first pattern". Therefore, the account item detection unit 26 detects the account item "salary" with the account item number "660" as the account item on the debit side of the setting item of "basic salary".

[0068] When an account item is detected in this manner, the display control unit 21 inputs and displays the account item number "660" indicating the account item "salary", which is the debit account item of "basic salary", in the debit input field of the journal entry definition master maintenance screen, as exemplified in Fig. 13. The display control unit 21 also displays the account item name "salary" adjacent to the account item number along with the account item number.

[0069] Similarly, the example in Fig. 14 is an example in which "health insurance (individual)" is input as the target item. In this case, the pattern information detection unit 25 refers to the item definition master 11 and determines whether or not "health insurance (individual)" is present among the setting item names for which the deduction total flag is "TRUE". In other words, the pattern information detection unit 25 refers to the item definition master 11 and determines whether or not the deduction total flag for "health insurance (individual)" is "TRUE".

[0070] In the example of Fig. 2, since the deduction total flag for "health insurance (individual)" is "TRUE", the pattern information detection unit 25 detects the pattern type associated with the setting item of "health insurance (individual)". In the example of Fig. 2, the "second pattern" is detected as the pattern associated with the setting item of "health insurance (individual)".

[0071] Next, the account item detection unit 26 refers to the journal entry definition template master 12 based on the pattern type detected by the pattern information detection unit 25. Then, it detects the account items associated with the "second pattern". In the example of Fig. 3, for the "second pattern", in addition to the account item number "710" indicating the account item "Deposit" as the total account item on the credit side, the sub-account of "Social Insurance Premiums" which is the credit sub-account of "10" on the credit side, and "XX Pension Office", which is the client of "20098", are detected as clients.

[0072] When an account item is detected in this manner, the display control unit 21 inputs and displays the account item number "710" indicating the account item "deposit" which is the credit account item of "health insurance (individual)" in the credit input field of the journal entry definition master maintenance screen, as exemplified in FIG. 14. The display control unit 21 also displays the account item name "deposit" adjacent to the account item number along with the account item number. The display control unit 21 also displays the auxiliary account number "10" and the auxiliary account name "social insurance premium" acquired from the journal entry definition template master 12 together with such an account item in the credit input field of the journal entry definition master maintenance screen. Furthermore, the display control unit 21 also displays the customer number "20098" and the customer name "XX Pension Office" acquired from the journal entry definition template master 12 together with the above-mentioned account items in the credit input field of the journal entry definition master maintenance screen.

[0073] Next, the journal entry definition master automatic creation unit 27 creates a journal entry definition master 13 corresponding to the target items and account items, etc., inputted on the journal entry definition master maintenance screen. The example in Fig. 15 is an example in which a journal entry definition master 13 indicating the account item of the item "basic salary (salary)" and the account item of "commuting allowance (tax-exempt)" shown in Fig. 13 is created as the journal entry definition master 13 described using Fig. 2.

[0074] 15, the journal entry definition master 13 in which the target item "basic salary" is input together with the definition number "1110" and the account number "660" indicating the account item "salary" is input to the debit general account item is automatically created by the journal entry definition master automatic creation unit 27. The journal entry definition master 13 in which the target item "commuting allowance (tax-exempt)" is input together with the definition number "1990" and the account number "660" indicating the account item "salary" is input to the debit general account item is automatically created by the journal entry definition master automatic creation unit 27.

[0075] Similarly, the example in Fig. 16 is an example in which a journal entry definition master 13 showing the account item of the item "Dormitory fee (deposit)" is created as the journal entry definition master 13 described using Fig. 2. In this case, as shown in Fig. 16, the target item "Dormitory fee" is entered along with the definition number "2110", and the journal entry definition master 13 in which the account item number "710" showing the account item of "deposit", the credit auxiliary item "10", and the customer "20098" are entered in the credit total account item is automatically created by the journal entry definition master automatic creation unit 27.

[0076] Similarly, the example in Fig. 17 is an example in which a journal entry definition master 13 indicating the account items of "Net Payment Amount (Positive)" and "Net Payment Amount (Negative)" is created as the journal entry definition master 13 described using Fig. 2. In this case, as shown in Fig. 17, the target items of "Net Payment Amount (Positive)" and "Net Payment Amount (Negative)" are input together with the definition number of "3110", and the journal entry definition master 13 in which the account item number of "810" indicating the account item of "Deposit" is input to the credit total account item is automatically created by the journal entry definition master automatic creation unit 27.

[0077] Similarly, the example of Fig. 18 is an example in which a journal entry definition master 13 indicating the account item of the item "health insurance (company)" is created as the journal entry definition master 13 described using Fig. 2. In this case, as shown in Fig. 18, the journal entry definition master 13 is automatically created by the journal entry definition master automatic creation unit 27, in which the target item "health insurance (company)" is entered along with the definition number "4110", and the account number "510" indicating the account item of "legal welfare expenses" is entered as the debit general account item and the account number "400" indicating the account item of "accrued expenses" is entered as the credit general account item.

[0078] Similarly, the example in Fig. 19 is an example in which a journal entry definition master 13 indicating the account item of the item "year-end adjustment excess / shortage" is created as the journal entry definition master 13 described using Fig. 2. In this case, as shown in Fig. 19, the target item "year-end adjustment excess / shortage" is entered along with the definition number "5110", and the journal entry definition master 13 in which the account item number "710" indicating the account item of "deposit" is entered in the credit total account item, the credit subsidiary item "20", and the customer "30122" are entered is automatically created by the journal entry definition master automatic creation unit 27.

[0079] The journal entry definition master automatic creation unit 27 stores the journal entry definition master 13 thus automatically created in the storage unit 2.

[0080] Next, when the operator designates the journal data transmission process shown in step S5 of the flowchart in Fig. 5 via the input device 6, the journal data generation unit 28 calculates the total amount of basic salary to be paid to each employee based on the employee payment data shown in Fig. 20(a), and calculates the total amount of health insurance (individual) to be deducted from each employee's salary based on the employee deduction data shown in Fig. 20(b). In this example, the total amount of basic salary is "300,000 yen + 60,000 yen + 310,000 yen = 670,000 yen," and the total amount of health insurance (individual) is "50,000 yen + 40,000 yen + 60,000 yen = 150,000 yen."

[0081] Next, when the external data acceptance process shown in step S6 of the flowchart in Fig. 5 is specified by the operator via the input device 6, the journal data generation unit 28 detects the account item of the total amount of basic salary (=total amount of salary) as exemplified in Fig. 21(a) by referring to the journal entry definition master 13 for "salary" shown in Fig. 15. In addition, the journal data generation unit 28 detects the account item of the total amount of health insurance (individual) (=total amount of deposits) by referring to the journal entry definition master 13.

[0082] Then, as shown in Fig. 21(b), the journal data generation unit 28 generates journal data for "salary" by inputting an automatically assigned voucher number, a debit amount of "670,000 yen" in this example, and a debit account item of "660." The journal data generation unit 28 also generates journal data for "deposit" by inputting an automatically assigned voucher number, a debit amount of "150,000 yen" in this example, a credit account item of "710," and a credit sub-account item of "10."

[0083] The accounting data generated in this manner is recorded in the accounting system 52 of the accounting server device 51 by the communication control unit 29 via the communication interface unit 4 and the network 50 at a predetermined timing, for example, at the end or beginning of the month.

[0084] (Effects of the embodiment) In addition to directly registering journal entries in the financial accounting system, it is common to link journal data to the system in order to reflect data generated in other business systems in financial journal entries. However, in order for the financial accounting system to automatically and appropriately determine and convert various registered contents, including payroll generated in other business systems, into correct financial journal entries and link them, it is necessary to set up complex conversion settings in advance that take into account the journal entries of the business system from which the link originates and the business system to which the link is made.

[0085] In the journal entry definition master that enables the conversion settings from such a payroll system to financial journal entry data, corresponding subjects are set for each payment item and deduction item, and journal entry data is created according to the settings. In addition, it is common to create journal entries for the amount of transfer payment or collection, the company's share of social insurance or labor insurance, and refunds or additional collections for year-end adjustments.

[0086] In addition, the human resources department is responsible for the payment of salaries and bonuses, but the accounting department is responsible for journal entries. If the person in charge of setting up the journal entry definition master is the human resources department, it takes time to set it up because they do not have accounting knowledge. Also, when actually linked, the balance does not match and errors often occur. Also, since year-end adjustment journal entries are only made once a year, settings may be overlooked when the system is operational.

[0087] On the other hand, when the accounting department is in charge, they may not be aware of changes to the personnel system or salary regulations, and errors may occur when coordinating accounting entries when salary items increase or decrease.

[0088] For this reason, the business support device 1 of the embodiment systematizes the account items of data generated by payroll, etc., according to the type of data, and divides them into several patterns. Then, a journal entry definition master 13 is automatically created based on the flags (total payment, total deductions, amount of transfer payment, etc.), and based on the created journal entry definition master 13, the account items of each item are detected and reflected in the journal entry data. This reduces the labor of the worker who creates the journal entry definition master 13. Also, even an accounting department staff member with little accounting knowledge can easily and quickly set the correct journal entry definition.

[0089] In addition, the business support device 1 of the embodiment automatically creates a journal entry definition master 13 based on the basic concept of converting payments into expenses (debit), deductions into deposits (credit), and transferred payments and collections into deposits (credit).

[0090] In the item definition master 11, which defines the item information used in the calculation definition of salary and bonus and the storage of the results in the payroll system, if the total payment flag, which is the flag corresponding to the above pattern, is on, it can be judged as "payment", and if the deduction total flag is on, it can be judged as "deduction". Since these are flag settings that must be set for payroll calculation, patterns can be automatically separated without special attention from an accounting point of view, making it possible to set without omissions. Furthermore, even if the salary items increase or decrease due to personnel system or salary revisions, it is possible to set without omissions. In addition, it is also possible to prevent omissions in setting refunds or additional collections in year-end adjustments.

[0091] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, and can therefore contribute to Goals 8 and 9 of the SDGs.

[0092] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.

[0093] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0094] [Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0095] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0096] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0097] Moreover, with regard to the task support device 1, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0098] For example, the processing functions of the business support device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the business support device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in the storage unit 2 such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.

[0099] In addition, the business support program of this business support device 1 may be stored in another server device connected to the business support device 1 via any network, and it is also possible to download all or part of it as needed.

[0100] The business support program for executing the process described in the present embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0101] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that achieves its function by working with a separate program, such as an OS. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the business support device 1 shown in the embodiment, as well as the installation procedure after reading.

[0102] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

[0103] The business support device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device to which any peripheral device is connected. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

[0104] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0105] As an example, the present invention can be applied to a payroll system to support payroll payment operations. [Explanation of symbols]

[0106] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Item definition master 12 Journal entry definition template master 13 Journal entry definition master 21 Display control unit 22 Item definition master maintenance processing section 23 Payroll Processing Unit 24 Transfer data creation processing section 25 Pattern information detection section 26 Account Item Detection Section 27 Automatic creation of journal entry definition master 28 Journal entry data generation unit 29 Communication control section 50 Network 51 Accounting server device 52 Accounting System

Claims

1. a pattern information detection unit that references an item definition master including usage item information indicating items used in calculating the amount of money among items of money to be paid and items of money to be deducted, and pattern information indicating a pattern of account items of debit or credit of journal data corresponding to the items indicated by the usage item information, and detects the pattern information of account items for each of the items; an account item detection unit that refers to a journal entry definition template master in which debit or credit account items set in journal entry data are stored for each of the pattern information, and detects account items of the journal entry data corresponding to each of the pattern information; a journal entry definition master automatic creation unit that automatically creates a journal entry definition master including the items and the account items for each of the pattern information based on the account items detected by the account item detection unit; A business support device having the above configuration.

2. a display control unit that displays an item definition master maintenance screen for selecting items to be used in calculating the amount of money from among items of money to be paid and items of money to be deducted; an item definition master maintenance processing unit that generates the item definition master with the item selected on the item definition master maintenance screen as the used item information; 2. The business support device according to claim 1,

3. Further comprising a journal data generation unit which refers to the journal definition master based on the item of the money to be paid or the item of the money to be deducted, and generates journal data with an account item corresponding to the money to be paid or an account item corresponding to the money to be deducted; 3. The business support device according to claim 1 or 2,

4. a pattern information detection step in which the pattern information detection unit refers to an item definition master including usage item information indicating items used in calculating the amount of money among items of money to be paid and items of money to be deducted, and pattern information of patterns indicating debit or credit account items of journal data corresponding to the items indicated by the usage item information, and detects the pattern information of the account items for each of the items; an account item detection step in which an account item detection unit refers to a journal entry definition template master in which debit or credit account items set in journal entry data are stored for each of the pattern information, and detects account items of the journal entry data corresponding to each of the pattern information; a journal entry definition master automatic creation step in which a journal entry definition master automatic creation unit automatically creates a journal entry definition master including the items and the account items for each of the pattern information based on the account items detected in the account item detection step; A business support method having the above-mentioned features.

5. Computer, a pattern information detection unit that references an item definition master including usage item information indicating items used in calculating the amount of money among items of money to be paid and items of money to be deducted, and pattern information indicating a pattern of account items of debit or credit of journal data corresponding to the items indicated by the usage item information, and detects the pattern information of account items for each of the items; an account item detection unit that refers to a journal entry definition template master in which debit or credit account items set in journal entry data are stored for each of the pattern information, and detects account items of the journal entry data corresponding to each of the pattern information; functioning as an automatic journal entry definition master creation unit that automatically creates a journal entry definition master including the items and the account items for each of the pattern information based on the account items detected by the account item detection unit; A business support program that features:

Images