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 Art

[0002] Today, for example, there are salary payments and bonus payments as the money paid to employees and the like. In these salary payments or bonus payments, for example, payments of money for items such as basic salary, position allowance, overtime pay, commuting allowance (non-taxable), etc. are made. Similarly, as the money deducted from the money paid to employees and the like, there are salary deductions and bonus deductions, etc. In these salary deductions or bonus deductions, deductions of money for items such as health insurance premiums, income tax, employment insurance premiums, and the shortage of year-end adjustment, etc. are made.

[0003] In a salary system, which is an example of a system in which such payments and deductions of money are made, calculations such as salary or bonus are made in consideration of the employee's salary system and work performance, and payments, tax payments, declarations, etc. to the employee are made.

[0004] Here, in business management, simply paying salaries and bonuses does not mean that the business is completed. It is necessary to make journal entries of the results and reflect them in the financial accounting system. Patent Document 1 (Japanese Unexamined Patent Application Publication No. 2021-121919) discloses an accounting processing support system that can automate the creation of tax return documents regardless of the type and reduce the creation burden when adopting different accounting software for each corporation to manage corporate information and accounting information.

[0005] As described above, in business management, it is necessary to make journal entries of salaries or bonuses for which payments or deductions have been made and reflect them in the financial accounting system. In addition to directly registering journal entries for this financial accounting system, it is generally practiced to also register journal data generated in other business systems in a coordinated manner.

Prior Art Documents

Patent Documents

[0006] [Patent Document 1] Japanese Patent Application Laid-Open No. 2021-121919 [Summary of the Invention] [Problems to be Solved by the Invention]

[0007] However, in order to convert various registration contents including salaries generated in other business systems into correct financial journal entries and link them on the financial accounting system side, it is necessary to create in advance a journal definition master that is referred to when making financial journal entries on the financial accounting system side. For this journal definition master, it is necessary to create it by performing complex conversion settings in consideration of the journal entries of the other business systems as the source of linkage and the financial accounting system as the destination of linkage, and there has been a problem that a great deal of labor is required to create the journal definition master.

[0008] The present invention has been made in view of the above problems, and an object thereof is to provide a business support device, a business support method, and a business support program that enable automatic creation of a journal definition master and reduce the labor required for an operator who creates the journal definition master. [Means for Solving the Problems]

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

[0010] Also, in order to solve the above-described problems and achieve the object, the business support method according to 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 an item used in the calculation of money among items of money to be paid and items of money to be deducted, and pattern information of a pattern indicating a debit or credit account item of journal data corresponding to the item indicated by the usage item information, and detects pattern information of an account item for each item; an account item detection step in which an account item detection unit refers to a journal definition template master in which a debit or credit account item set in the journal data is stored for each pattern information, and detects the account item of the journal data corresponding to each pattern information; and a journal definition master automatic creation step in which a journal definition master automatic creation unit automatically creates a journal definition master including an item and an account item for each pattern information based on the account item detected in the account item detection step.

[0011] Also, in order to solve the above-described problems and achieve the object, the business support program according to 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 an item used in the calculation of money among items of money to be paid and items of money to be deducted, and pattern information of a pattern indicating a debit or credit account item of journal data corresponding to the item indicated by the usage item information, and detects pattern information of an account item for each item; an account item detection unit that refers to a journal definition template master in which a debit or credit account item set in the journal data is stored for each pattern information, and detects the account item of the journal data corresponding to each pattern information; and a journal definition master automatic creation unit that automatically creates a journal definition master including an item and an account item for each pattern information based on the account item detected by the account item detection unit.

Advantages of the Invention

[0012] The present invention can automatically create a journal definition master. Therefore, the labor required for an operator to create a journal definition master can be reduced.

Brief Description of the Drawings

[0013]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Figure 20

Figure 21

Embodiments for Carrying Out the Invention

[0014] Hereinafter, a business support apparatus according to an embodiment to which the present invention is applied will be described in detail with reference to the drawings. Although this is an example, in this embodiment, a "journal definition master" is automatically created in the business support apparatus, and using this journal definition master, journal data of money paid and deducted from employees is generated and entered into an accounting system to support the work of accounting staff and the like. Note that the present invention is not limited to the following embodiments described as an example.

[0015] (Hardware Configuration) As shown in FIG. 1, the business support apparatus 1 according to 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. As the output device 7, a display unit such as a monitor device (including a home TV), a printing device, or a speaker device corresponds. As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, a monitor device that realizes a pointing device function in cooperation with the mouse device can be used.

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

[0017] As the storage unit 2, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used. In the storage unit 2, a "journal definition master" is automatically created, and based on this journal definition master, a business support program is stored to support the task of creating journal data for the salary paid to employees and the money deducted and recording it in the accounting system 52.

[0018] Also, in the storage unit 2, an item definition master 11, a journal definition template master 12, and a journal definition master 13, which will be described later, are stored.

[0019] (Item Definition Master) FIG. 2 is a diagram showing an example of the item definition master 11. As shown in this FIG. 2, the item definition master 11 is composed of 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 name is the name of the item for the money to be paid and the item for the money to be deducted. In the example of Figure 2, for example, basic salary, monthly basic salary, adjusted basic salary, position allowance, monthly position allowance, adjusted position allowance, overtime pay, taxable commuting allowance, non-taxable commuting allowance, dormitory expenses, stockholders' meeting, other deductions, individual health insurance, company health insurance, income tax, positive net payable amount, negative net payable amount, year-end adjustment excess / deficiency amount, etc.

[0021] The total payment amount flag is information indicating whether to use the money of that item in the calculation of the total amount of salary paid to each employee (total payment amount). "TRUE" is set for the items used in the calculation of the total payment amount, and "FALSE" is set for the items not used in the calculation of the total payment amount.

[0022] In other words, the total payment amount flag is information indicating whether to aggregate the money of that item into the total payment amount on the salary statement, and is calculated by the formula "net payable amount = total payment amount - total deduction amount". In the example of Figure 2, "TRUE" is set for the items of basic salary, position allowance, overtime pay, taxable commuting allowance, and non-taxable commuting allowance.

[0023] The total taxable amount flag is information indicating whether to use the money of that item in the calculation of the total amount of tax levied on each employee (total tax). "TRUE" is set for the items used in the calculation of the total taxable amount, and "FALSE" is set for the items not used in the calculation of the total taxable amount. In the example of Figure 2, "TRUE" is set for the items of basic salary, position allowance, overtime pay, and taxable commuting allowance.

[0024] The social insurance flag is information indicating whether to use the money of that item in the calculation of social insurance. "TRUE" is set for the items used in the calculation of social insurance, and "FALSE" is set for the 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, taxable commuting allowance, and non-taxable commuting allowance.

[0025] The labor insurance flag is information indicating whether to use the money of that item in the calculation of labor insurance. For items used in the calculation of labor insurance, "TRUE" is set, and for items not used in the calculation of labor insurance, "FALSE" is set. 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 indicating whether to use the money of that item in the calculation of the total deduction amount for all employees. For items used in the calculation of the total deduction amount, "TRUE" is set, and for items not used in the calculation of the total deduction amount, "FALSE" is set.

[0027] In other words, the total deduction flag is information indicating whether to aggregate the money of that item in the total deduction amount of salary detail information, and is calculated by the formula "net payable amount = total payable amount - total deduction amount". In the example of Figure 2, "TRUE" is set for the items of accommodation expenses, shareholders' meeting, other deductions, health insurance (individual), income tax, and year-end adjustment excess / deficiency amount.

[0028] The pattern type is information obtained by patterning the accounting items when posting the money of that item and attaching a pattern number. In the example of Figure 2, the pattern number of the first pattern is set as the pattern number of the accounting items for basic salary, monthly basic salary, basic salary adjustment amount, position allowance, monthly position allowance, position allowance adjustment amount, overtime pay, taxable commuting allowance, and non-taxable commuting allowance. Also, in the example of Figure 2, the pattern number of the second pattern is set as the pattern number of the accounting items for accommodation expenses, shareholders' meeting, other deductions, individual health insurance, and income tax.

[0029] In addition, in the example of FIG. 2, the pattern number of the third pattern is set as the pattern number of the accounting item for the deduction payment amount (positive) and the deduction payment amount (negative). Further, in the example of FIG. 2, the pattern number of the fourth pattern is set as the pattern number of the accounting item for health insurance (company). Further, in the example of FIG. 2, the pattern number of the fifth pattern is set as the pattern number of the accounting item for the year-end adjustment excess / deficiency amount.

[0030] The settings of various flags for the item definition master 11 and the pattern type are preset based on the item definition master maintenance screen described with reference to FIGS. 6 and 7. Specifically, it will be described later.

[0031] (Journal definition template master) FIG. 3 is a diagram showing an example of the journal definition template master 12. As shown in FIG. 3, the journal definition template master 12 is composed of various information such as pattern type, pattern name, debit general ledger account, debit subsidiary account, credit general ledger account, credit subsidiary account, and credit customer.

[0032] The pattern type is the above-mentioned first to fifth pattern numbers. The pattern name is the name of the pattern for each pattern number. In the example of FIG. 3, for the first pattern, the pattern name of "payment item" is set, and for the second pattern, the pattern name of "deduction item" is set. Also, in the example of FIG. 3, for the third pattern, the pattern name of "deduction payment amount" is set, and for the fourth pattern, the pattern name of "company share" is set. Also, in the example of FIG. 3, for the fifth pattern, the pattern name of "year-end adjustment excess / deficiency" is set.

[0033] In addition, in the example of FIG. 3, for the payment item which is the first pattern, the account number "660" indicating the account of "salary" is set as the debit general ledger account, and for the deduction item which is the second pattern, the account number "710" indicating the account of "deposit" is set as the credit general ledger account.

[0034] In addition, in the example of FIG. 3, for the deduction payment amount which is the third pattern, the account number "810" indicating the "deposit" account is set as the general ledger account on the credit side. For the company share which is the fourth pattern, the account number "510" indicating the "statutory welfare expenses" account as the general ledger account on the debit side and the account number "400" indicating the "accrued expenses" account as the general ledger account on the credit side are set. Also, in the example of FIG. 3, for the year-end adjustment excess / deficiency amount which is the fifth pattern, the account number "710" indicating the "trust money" account is set as the general ledger account on the credit side.

[0035] (Journal Definition Master) FIG. 4 is a diagram showing an example of the journal definition master 13. As shown in this FIG. 4, the journal definition master 13 is composed of various information such as definition number, target item, debit general ledger account, debit subsidiary account, debit transaction partner, credit general ledger account, credit subsidiary account, and credit transaction partner.

[0036] The above-mentioned journal definition template master 12 is referred to based on the pattern type (the pattern type of the item definition master in FIG. 2) attached to the item of the money for which payment or deduction has been made, and the general ledger account corresponding to the pattern type is detected. Then, the detected general ledger account is set in this journal definition master 13 as the general ledger account corresponding to the journal of that item. Thereby, the journal definition master 13 is automatically created. Details will be described later.

[0037] (Functional Configuration of Business Support Device) Next, by executing the business support program stored in the storage unit 2, the control unit 3 functions as a display control unit 21, an item definition master maintenance processing unit 22, a salary calculation processing unit 23, a transfer data creation processing unit 24, and a pattern information detection unit 25 as shown in FIG. 1. Also, by executing the business support program, the control unit 3 functions as a general ledger account detection unit 26, a journal definition master automatic creation unit 27, a journal data generation unit 28, and a communication control unit 29.

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

[0039] The salary calculation processing unit 23 calculates the salary, deduction amount, bank transfer amount, etc. to be paid to employees. 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 salary calculation processing unit 23.

[0040] The pattern information detection unit 25 refers to the item definition master 11 including usage item information indicating items used in the calculation of money (corresponding to the set item names in the item definition master 11 in FIG. 2 as an example) among the items of money to be paid and the 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 (corresponding to the pattern type set item names in the item definition master 11 in FIG. 2 as an example), and detects pattern information of account items for each item.

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

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

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

[0044] The communication control unit 29 posts the generated journal entry data to 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 operation of journal entry definition master and posting operation of journal entry data) Next, the flowchart of FIG. 5 shows the flow of the automatic creation operation of the journal entry definition master 13 and the posting operation of the journal entry data in the business support device 1 of the embodiment. The control unit 3 of the business support device 1 executes each process of steps S1 to S6 in the flowchart of FIG. 5 by executing the business support program stored in the storage unit 2.

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

[0047] As shown in FIGS. 6 and 7, the item definition maintenance screen is provided with a selection column for attributes, a selection column for classifications, and a selection column for items used in calculations. As the "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 the "classifications", each classification of all items, fixed, variable, or calculation can be selected.

[0048] The selection column for items used in calculations is a selection column formed by the orthogonal intersection of the columns of each setting item and the rows of calculation types. The operator selects the setting items to be used in the desired calculation by entering a check (mark) in the desired selection column.

[0049] Figure 6 shows an example where the attribute of "salary payment" is selected and the classification of "all items" is selected. When this selection is made, as shown in Figure 6, the display control unit 21 displays all the setting items of "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)", which are "all items" of the attribute of "salary payment", in each column. At the same time, the display control unit 21 displays the rows of each calculation type of fixed, variable, calculation, total salary, total taxable amount, social insurance, labor insurance, and total deductions.

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

[0051] In contrast, Figure 7 shows an example where the attribute of "salary deduction" is selected and the classification of "all items" is selected. When this selection is made, as shown in Figure 7, the display control unit 21 displays all the setting items of "accommodation expenses", "shareholding association", "other deductions", "health insurance (individual)", "health insurance (company)", "employment insurance (individual)", "employment insurance (company)", "income tax", and "excess or deficiency of year-end adjustment", which are "all items" of the attribute of "salary deduction", in each column. At the same time, the display control unit 21 displays the rows of each calculation type of fixed, variable, calculation, total salary, 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 entering a check (mark) in the area where the columns of each item and the rows of each calculation type overlap (= selection column). The example in Fig. 7 shows that for the calculation of "total deductions", it is selected to use the amounts of each item such as dormitory expenses, shareholding associations, other deductions, health insurance (individual), employment insurance (individual), income tax, and the over / under amount of year-end adjustment.

[0053] When the desired attributes (such as salary payment or salary deduction, etc.) and the items (such as basic salary, income tax, etc.) to be used for the calculation of various types (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 column of the calculation type of the selected item for the item definition master 11 shown in Fig. 2. Note that the item definition master maintenance processing unit 22 sets the information of "FALSE" as an item not to be used in the calculation for the columns of the items not set on the item definition master maintenance screen in the item definition master 11.

[0054] On the item definition master maintenance screen shown in Fig. 6, it is set to use the setting items of basic salary, position allowance, overtime pay, commuting allowance (taxable) and commuting allowance (non-taxable) in the calculation of "total payment". Therefore, as shown in Fig. 2, the item definition master maintenance processing unit 22 sets the 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 payment flag" in the item definition master 11.

[0055] Also, on the item definition master maintenance screen shown in Fig. 7, it is set to use the setting items of dormitory expenses, shareholding associations, other deductions, health insurance (individual), employment insurance (individual), income tax, and the over / under amount of year-end adjustment in the calculation of "total deductions". Therefore, as shown in Fig. 2, the item definition master maintenance processing unit 22 sets the 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 deductions flag" in the item definition master 11.

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

[0057] Then, in step S3, the transfer data creation processing unit 24 generates employee transfer data for each employee as exemplified 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 definition master automatic creation unit 27 performs a journal definition master maintenance process for automatically creating the journal definition master 13 shown in FIG. 4.

[0059] Basically, the salary journal can be patterned as shown in FIGS. 11(a) and 11(b). Payment item → Debit (salary) Deduction item → Credit (deposit) Net payment amount → Credit (deposit) Company share → Debit / Credit (statutory welfare expenses / accrued expenses) Year-end adjustment excess / deficiency → Credit (deposit)

[0060] Therefore, based on each setting content (TRUE or FALSE) of the item definition master 11, the journal definition master automatic creation unit 27 detects the pattern type of each item, and based on the detected pattern type, refers to the journal definition template master 12 in FIG. 3. Then, as exemplified in FIG. 12, from the journal definition template master 12, the debit / credit and accounts corresponding to the pattern type are detected, and the journal definition master for each item is automatically created.

[0061] Total payment FLG is TRUE → Payment item Total deduction FLG is TRUE → Deduction item Difference between positive and negative net payment amounts of system-fixed items → Net payment amount Company - borne items in system fixed items → Company - borne portion Over - or - under amount of year - end adjustment in system fixed items → Over - or - under amount of year - end adjustment

[0062] Note that the over - or - under amount of year - end adjustment is a refund amount or an additional collection amount due to year - end adjustment.

[0063] Specifically, when the operator designates the maintenance of the journal definition master via the input device 6, the display control unit 21 displays the journal definition master maintenance screen illustrated in FIGS. 13 and 14 via the output device 7. As shown in FIGS. 13 and 14, this journal definition master maintenance screen is provided with an input field for the target item, an input field for the debit account, and an input field for the credit account. The example in FIG. 13 is an example where the target item of "basic salary" is input by the operator for such a journal definition master maintenance screen. Also, the example in FIG. 14 is an example where the target item of "health insurance (individual)" is input by the operator for the journal definition master maintenance screen.

[0064] Note that the definition number is automatically numbered by the journal definition master automatic creation unit 27 and displayed by the display control unit 21. As an example, the payment items are automatically numbered from 1000 at intervals of 10, the deduction items are automatically numbered from 2000 at intervals of 10, and the net payment amount is automatically numbered from 3000 at intervals of 10 and displayed.

[0065] Based on the target item input on the journal definition master maintenance screen, the pattern information detection unit 25 refers to the item definition master 11 shown in FIG. 2. In the example of FIG. 13, since the target item "basic salary" is input, the pattern information detection unit 25 refers to the item definition master 11 to determine whether "basic salary" exists among the setting item names for which the total payment flag is "TRUE". In other words, the pattern information detection unit 25 refers to the item definition master 11 to determine whether the total payment flag of "basic salary" is "TRUE".

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

[0067] Next, the accounting 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 accounting item associated with "the first pattern". In the case of the example in FIG. 3, for "the first pattern", the accounting item number "660", which indicates the accounting item of "salary" as the debit total accounting item, is set. Therefore, the accounting item detection unit 26 detects the accounting item of "salary" with the accounting item number "660" as the debit accounting item of the setting item of "basic salary".

[0068] When the accounting item is detected in this way, as illustrated in FIG. 13, the display control unit 21 inputs and displays the accounting item number "660", which indicates the accounting item of "salary" as the debit accounting item of "basic salary", in the debit input field of the journal entry definition master maintenance screen. Note that the display control unit 21 also displays the accounting item name of "salary" adjacent to the accounting item number.

[0069] Similarly, the example in FIG. 14 is an example in which "health insurance (individual)" is input as the target item. Also in this case, the pattern information detection unit 25 refers to the item definition master 11 and determines whether "health insurance (individual)" exists 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 the deduction total flag of "health insurance (individual)" is "TRUE".

[0070] In the case of the example in FIG. 2, since the total deduction flag for "Health Insurance (Individual)" is "TRUE", the pattern information detection unit 25 detects the pattern type associated with the setting item for "Health Insurance (Individual)". In the case of the example in FIG. 2, as the pattern associated with the setting item for "Health Insurance (Individual)", the "Second Pattern" is detected.

[0071] Next, the accounting 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 accounting items associated with the "Second Pattern". In the case of the example in FIG. 3, for the "Second Pattern", as the credit general ledger accounting item, in addition to the accounting item number "710" indicating the "Deposit" accounting item, the auxiliary accounting item of "Social Insurance Premium", which is the credit auxiliary accounting item of "10", and the trading partner "〇〇 Pension Office", which is the trading partner of "20098", are detected.

[0072] When the accounting items are detected in this way, as illustrated in FIG. 14, the display control unit 21 inputs and displays the accounting item number "710", which indicates the "Deposit" accounting item, which is the credit accounting item for "Health Insurance (Individual)", in the credit input field on the journal entry definition master maintenance screen. Note that the display control unit 21 also displays the accounting item name of "Deposit" adjacent to the accounting item number. In addition, the display control unit 21 also displays the auxiliary accounting item number "10" and the auxiliary accounting item name of "Social Insurance Premium" obtained from the journal entry definition template master 12 together with such accounting items in the credit input field on the journal entry definition master maintenance screen. Furthermore, the display control unit 21 also displays the trading partner number "20098" and the trading partner name of "〇〇 Pension Office" obtained from the journal entry definition template master 12 together with the above-mentioned accounting items in the credit input field on the journal entry definition master maintenance screen.

[0073] Next, the journal definition master automatic creation unit 27 creates a journal definition master 13 corresponding to the target items and accounting items etc. input on the journal definition master maintenance screen. The example in Fig. 15 is an example in which a journal definition master 13 showing the accounting items of the item "basic salary (salary)" and the accounting items of the item "commuting allowance (non-taxable)" shown in Fig. 13 is created as the journal definition master 13 described with reference to Fig. 2.

[0074] In this case, as shown in Fig. 15, a journal definition master 13 is automatically created by the journal definition master automatic creation unit 27, in which the target item with "basic salary" and the accounting item number "660" indicating the accounting item of "salary" are input to the debit general ledger account together with the definition number "1110". Also, a journal definition master 13 is automatically created by the journal definition master automatic creation unit 27, in which the target item with "commuting allowance (non-taxable)" and the accounting item number "660" indicating the accounting item of "salary" are input to the debit general ledger account together with the definition number "1990".

[0075] Similarly, the example in Fig. 16 is an example in which a journal definition master 13 showing the accounting items of the item "lodging expenses (deposit)" is created as the journal definition master 13 described with reference to Fig. 2. In this case, as shown in Fig. 16, a journal definition master 13 is automatically created by the journal definition master automatic creation unit 27, in which the target item with "lodging expenses" and the accounting item number "710" indicating the accounting item of "deposit", the credit auxiliary account "10", and the business partner "20098" are input to the credit general ledger account together with the definition number "2110".

[0076] Similarly, the example in Fig. 17 is an example in which a journal definition master 13 showing the accounting items of the items "deducted payment amount (positive)" and "deducted payment amount (negative)" is created as the journal definition master 13 described with reference to Fig. 2. In this case, as shown in Fig. 17, a journal definition master 13 is automatically created by the journal definition master automatic creation unit 27, in which the target items with "deducted payment amount (positive)" and "deducted payment amount (negative)" and the accounting item number "810" indicating the accounting item of "deposit" are input to the credit general ledger account together with the definition number "3110".

[0077] Similarly, the example of FIG. 18 is an example in which a journal definition master 13 showing the account items of the item "Health Insurance (Company)" is created as the journal definition master 13 described with reference to FIG. 2. In this case, as shown in FIG. 18, together with the definition number "4110", the target item "Health Insurance (Company)" is input, and the account number "510" indicating the account item of "Statutory Welfare Expenses" is input to the debit general ledger account, and the account number "400" indicating the account item of "Accounts Payable" is input to the credit general ledger account. The journal definition master 13 thus input is automatically created by the journal definition master automatic creation unit 27.

[0078] Similarly, the example of FIG. 19 is an example in which a journal definition master 13 showing the account items of the item "Year-End Adjustment Excess / Deficiency Amount" is created as the journal definition master 13 described with reference to FIG. 2. In this case, as shown in FIG. 19, together with the definition number "5110", the target item "Year-End Adjustment Excess / Deficiency" is input, and the journal definition master 13 in which the account number "710" indicating the account item of "Deposits", the credit subsidiary account "20", and the business partner "30122" are input to the credit general ledger account is automatically created by the journal definition master automatic creation unit 27.

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

[0080] Next, when the journal data transmission process shown in step S5 of the flowchart in FIG. 5 is specified by the operator via the input device 6, the journal data generation unit 28 calculates the total amount of basic salary paid to each employee based on the employee payment data shown in FIG. 20(a), and calculates the total amount of health insurance (individual) deducted from the salary of each employee based on the employee deduction data shown in FIG. 20(b). In the case of 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 reception 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 refers to the journal definition master 13 of "salary" shown in FIG. 15, and as illustrated in FIG. 21(a), detects the account item of the total amount of basic salary (= total amount of salary). Further, the journal data generation unit 28 refers to the journal definition master 13 to detect the account item of the total amount of health insurance (individual) (= total amount of deposit).

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

[0083] The journal data generated in this way is posted to the accounting system 52 of the accounting server device 51 via the communication interface unit 4 and the network 50 by the communication control unit 29 at a predetermined timing such as the end or beginning of the month.

[0084] (Effect of the Embodiment) In addition to directly performing journal registration in the financial accounting system, it is generally performed to perform journal data linkage in the system in order to reflect the data generated in other business systems in the financial journal. However, in order to automatically and appropriately judge various registration contents including salary generated in other business systems on the financial accounting system side and convert them into correct financial journals for linkage, it is necessary to perform a complicated conversion setting in advance considering the business system of the source of linkage and the journal of the destination of linkage.

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

[0086] Also, the payment of salary or bonus is the responsibility of the personnel department, while the journal entry is the responsibility of the accounting department. When the person in charge of setting the journal definition master is the personnel department, it takes time for the setting because they lack accounting knowledge. Also, when actually coordinating, there are often errors due to the mismatch of debits and credits. In addition, since the year-end adjustment journal entry is only made once a year, there may be a setting omission during system operation.

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

[0088] For these reasons, the business support device 1 of the embodiment systematizes the accounting accounts of the data generated by salary and the like according to the type of data and divides them into several patterns. Then, based on the flag (total payment, total deduction, transfer payment amount, etc.), the journal definition master 13 is automatically created, and based on the created journal definition master 13, the accounting accounts of each item are detected and reflected in the journal data. This can reduce the labor of the operator creating the journal definition master 13. Also, even an accounting department staff member with little accounting knowledge can easily and quickly perform correct journal definition settings.

[0089] Also, the business support device 1 of the embodiment automatically creates the journal definition master 13 based on the basic concept of converting payment to expense (debit), deduction to deposit (credit), and transfer payment amount / collection amount to deposit (credit).

[0090] In the item definition master 11 for defining item information used in calculating and defining salaries and bonuses and storing the results in a salary system, when the total payment flag, which is a flag corresponding to the above pattern, is on, it can be determined as "payment", and when the total deduction flag is on, it can be determined as "deduction". Since these are flag settings that must be set for salary calculation, they can be automatically categorized without special attention from an accounting perspective, enabling a leak-free setting. Also, even if the salary items increase or decrease due to personnel system or salary revisions, a leak-free setting can be enabled. In addition, it is possible to prevent setting leaks in the year-end adjustment refund or additional collection.

[0091] [Contribution to the Sustainable Development Goals (SDGs) led by the United Nations] According to this embodiment, since it can contribute to improving business efficiency and making appropriate business judgments of the enterprise, it becomes possible to contribute to Goals 8 and 9 of the SDGs.

[0092] Also, according to this embodiment, since it can contribute to reducing waste loss and promoting paperless and digitalization, it becomes possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0093] Also, according to this embodiment, since it can contribute to strengthening control and governance, it becomes possible to contribute to Goal 16 of the SDGs.

[0094] [Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

[0095] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

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

[0097] Regarding the business support device 1, each illustrated component is a functional concept and does not necessarily need to be physically configured as shown in the drawings.

[0098] For example, with respect to the processing functions provided by the business support device 1, particularly the various processing functions performed by the control unit 3 and the control unit 3, all or any part of them may be realized by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in this embodiment, and is mechanically read by the business support device 1 as necessary. That is, in the storage unit 2 such as a ROM or HDD, a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded. This computer program is executed by being loaded into the 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 an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0101] Also, a "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in the business support device 1 shown in the embodiment, well-known configurations and procedures can be used.

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

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

[0104] Furthermore, the specific form of the 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 arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0105] As an example, the present invention can be applied to a salary system or the like to support salary payment operations and the like.

Explanation of Signs

[0106] 1 Business support device 2 Storage unit 3 Control unit 4 Communication interface unit 5 Input / output interface unit 6 Input device 7 Output device 11 Item definition master 12 Journal definition template master 13 Journal definition master 21 Display control unit 22 Item definition master maintenance processing unit 23 Salary calculation processing unit 24 Transfer data creation processing unit 25 Pattern information detection unit 26 Account item detection unit 27 Journal definition master automatic creation unit 28 Journal data generation unit 29 Communication control unit 50 Network 51 Accounting server device 52 Accounting system

Claims

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

2. A display control unit that displays an item definition master maintenance screen for selecting items used in the calculation of money among the items of money for which payment is made and the items of money to be deducted; The item definition master maintenance processing unit further includes generating the item definition master using the item selected on the item definition master maintenance screen as the usage item information; The business support device according to claim 1, characterized in that.

3. A journal data generation unit that refers to the journal definition master based on the item of money for which payment is made or the item of money to be deducted, and generates journal data with the ledger account corresponding to the money for which payment is made or journal data with the ledger account corresponding to the money to be deducted; The business support device according to claim 1 or claim 2, characterized in that.

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 the calculation of money among the items of money for which payment is made and the items of money to be deducted, and pattern information of a pattern indicating a debit or credit ledger account of journal data corresponding to the items indicated by the usage item information, and detects the pattern information of the ledger account for each item; A ledger account detection step in which the ledger account detection unit refers to a journal definition template master in which the debit or credit ledger account set in the journal data is stored for each pattern information, and detects the ledger account of the journal data corresponding to each pattern information; A journal entry definition master automatic creation step in which the journal entry definition master automatic creation unit automatically creates a journal entry definition master including the item and the accounting item for each pattern information based on the accounting item detected in the accounting item detection step; A business support method having the above.

5. A computer, Referring to an item definition master including usage item information indicating an item used in the calculation of money among items of money to be paid and items of money to be deducted, and pattern information of a pattern indicating a debit or credit accounting item of journal entry data corresponding to the item indicated by the usage item information, and detecting the pattern information of the accounting item for each item; Referring to a journal entry definition template master in which the debit or credit accounting item set in the journal entry data is stored for each pattern information, and detecting the accounting item of the journal entry data corresponding to each pattern information; Functioning as a journal entry definition master automatic creation unit that automatically creates a journal entry definition master including the item and the accounting item for each pattern information based on the accounting item detected by the accounting item detection unit; A business support program characterized by the above.

Images