JP2021114188A - Salary processing device, salary processing method, and salary processing program - Google Patents

Abstract

To reduce a workload and improve accuracy of expense recording by automatically creating a journal during retroactive work related to salary.SOLUTION: A salary processing device according to the present embodiment includes: a first master that sets items of normal portion or retroactive portion of salary of salary data including a flag for specifying the normal portion or the retroactive portion, employee identification information, and an amount of each salary item, to be output as a journal; a second master that sets debit and credit accounts for each normal portion or retroactive portion of salary set in the first master; external cooperation data creation means that aggregates the amount of the salary data for each item of the normal portion or the retroactive portion of salary set in the first master; and journal creation means that crates the journal based on the debit and credit accounts set in the second master corresponding to each item of the normal portion or retroactive portion of salary set in the first master.SELECTED DRAWING: Figure 5

Description

The present invention relates to a payroll processing apparatus, a payroll processing method, and a payroll processing program.

When paying salaries at a company, for example, due to negotiations with the labor union or delays in applying for allowances, there is a discrepancy between the amount that should be paid and the amount that was actually paid, and the difference is settled. (Retroactive work) is necessary. As a conventional payroll processing system, for example, there is Patent Document 1. In the system of Patent Document 1, company information including salary rules of the company and employee information related to each employee of the company are recorded, and each employee of the corresponding month is used by using the company information and the employee information. Payroll is calculated, at least a part of the payroll calculation result is displayed on the web browser together with the confirmation button of the calculation result, and when the confirmation button is clicked or tapped, the calculation result of each employee in the corresponding month is displayed. It is confirmed, and the calculation result is confirmed only based on the fact that the confirmation button is clicked or tapped, and the account item is determined and journalized for each salary breakdown for the salary paid by the company.

Japanese Unexamined Patent Publication No. 2016-85750

However, Patent Document 1 does not describe anything about the preparation of transfer journals at the time of retroactive work (settlement) related to salary.

The present invention has been made in view of the above, and it is possible to reduce the work load and improve the accuracy of expense recording by automatically creating journals during retroactive work related to salary. It is an object of the present invention to provide a processing device, a payroll processing method, and a payroll processing program.

In order to solve the above-mentioned problems and achieve the object, the present invention is a payroll processing device provided with a storage unit and a control unit, and the storage unit is provided with a flag for designating a normal portion or a retroactive portion. The salary data including the employee identification information and the amount of each salary item, the first master for setting the salary items for the normal or retroactive portion of the salary data to be output as a journal, and the first master. A second master for setting a debit account and a credit account is stored for each item of salary for normal or retroactive portion set in the master, and the control unit creates the salary data. The salary data creation means, the external linkage data creation means for creating external linkage data that aggregates the amount of the salary data for each item of salary for normal or retroactive portion set in the first master, and the first Based on the debit and credit accounts set in the second master, and the aggregated amount of the external linkage data, corresponding to each item of normal salary or retroactive salary set in one master. It is characterized by having a journal creation means for creating journals.

Further, according to one aspect of the present invention, the ordinary portion includes a normal payment portion and a normal deduction portion, the retroactive portion includes a retroactive payment portion and a retroactive deduction portion, and the salary item includes a payment item and a retroactive deduction portion. Deduction items may be included.

Further, according to one aspect of the present invention, the payment item may include at least one of job title allowance, job salary, overtime pay, and family allowance, and the deduction item may include union dues.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a pay processing method for causing an information processing device including a control unit and a storage unit to execute the data, and the storage unit is usually used. Set the salary data including the flag for specifying the minute or retroactive portion, the employee identification information, the amount of each salary item, and the salary item of the normal portion or the retroactive portion of the salary data to be output as a journal. A first master and a second master for setting a debit account and a credit account for each item of normal or retroactive salary set in the first master are stored. An external linkage that aggregates the amount of the salary data for each of the salary data creation step for creating the salary data, which is executed in the control unit, and the normal or retroactive salary items set in the first master. The debit account and credit account set in the second master corresponding to each item of the external linkage data creation step for creating data and the normal or retroactive salary set in the first master. , And a journal creation step of creating a journal based on the aggregated amount of the external linkage data.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a payroll processing program to be executed by an information processing device provided with a control unit and a storage unit, and a normal portion or a retroactive portion is designated. The salary data including the flag to be used, the employee identification information, the amount of each salary item, and the first master for setting the salary items for the normal or retroactive portion of the salary data to be output as a journal. A second master for setting a debit account and a credit account is stored for each item of salary for normal or retroactive data set in the first master, and the salary is stored in the control unit. A salary data creation step for creating data and an external linkage data creation step for creating external linkage data that aggregates the amount of the salary data for each item of normal or retroactive salary set in the first master. And, the debit account and the credit account set in the second master corresponding to each salary item of the normal amount or the retroactive amount set in the first master, and the external linkage data are aggregated. It is characterized by a journal creation step of creating a journal based on an amount of money and a payroll processing program for executing.

According to the present invention, it is possible to reduce the work load and improve the accuracy of expense recording by automatically creating journals in the case of retroactive work related to salary.

FIG. 1 is a diagram for explaining an example of a conventional retroactive work related to salary. FIG. 2 is a diagram for explaining an example of a conventional retroactive work related to salary. FIG. 3 is a diagram for explaining an example of a conventional retroactive work related to salary. FIG. 4 is a diagram for explaining an outline of journal creation at the time of retroactive work regarding salary of the present embodiment. FIG. 5 is a block diagram showing an example of a payroll processing device according to the present embodiment. FIG. 6 is a diagram showing a data configuration example of the journal linkage output item setting master and the journal definition master. FIG. 7 is a diagram showing a data configuration example of employee supply data, employee deduction data, external cooperation data, and journal detail data. FIG. 8 is a diagram showing a flow for explaining the outline of the overall processing flow of the control unit of the payroll processing device (No. 1). FIG. 9 is a diagram showing a flow for explaining the outline of the overall processing flow of the control unit of the payroll processing device (No. 2). FIG. 10 is a diagram showing an example of a data sample. FIG. 11 is a diagram showing an example of a data sample. FIG. 12 is a diagram showing an example of a data sample. FIG. 13 is a diagram showing an example of a data sample. FIG. 14 is a diagram showing an example of a data sample. FIG. 15 is a diagram showing an example of a data sample.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. overview]
When the company pays salaries, for example, due to negotiations with the labor union or delays in applying for allowances, there is a discrepancy between the amount that should be paid and the amount that was actually paid, and the difference is settled. (Retroactive work) is necessary. When recording the difference caused by retroactive work as an expense, it is necessary for the accounting department to create a transfer journal.

Conventionally, in the personnel department, "the total value of the difference caused by retroactive work" is paid as salary, so it is not necessary to manage the difference on an item-by-item basis, and the total value is linked between the systems to record expenses. rice field. However, in the accounting department, since the account items are different for each item, it is necessary to create a transfer journal for the total value. Since this transfer journal creation work requires a great deal of labor, the work load is heavy and accounting errors are likely to occur.

Therefore, in the present embodiment, when the difference caused by the retroactive work related to salary is recorded as an expense, the result of each item of salary is linked to the accounting journal, and a mechanism for automatically creating the journal is constructed. , It is possible to reduce the work load and improve the accuracy of expense recording by eliminating the need for transfer journal creation work during retroactive work in the accounting department.

An example of the conventional retroactive work related to salary will be described with reference to FIGS. 1 to 3. FIG. 1 is a diagram for explaining Case 1. FIG. 2 is a diagram for explaining Case 2. It is a figure for demonstrating the case which links the retrospective result to accounting.

(1) Implementation of retroactive work Case 1 (retroactive work related to base-up and regular salary increase) will be described with reference to FIG. Due to delays in negotiations with the labor union and assessment of salary increases, base-ups and decisions on regular salary increases will inevitably be delayed in business. Since the number of target persons and target items becomes enormous, the transfer journal work itself becomes complicated.

In FIG. 1, for example, April is the time for base-up and regular salary increase, but the details of base-up and regular salary increase may not be finalized due to negotiations with the labor union in the personnel department and delays in assessment. For example, the base will be raised and the regular salary increase will be decided in June, and retroactive work (retrospective of the contents from April to June) will be implemented. In the personnel department, carry out retroactive work based on the confirmed results.

Case 2 (when the application for each payment item is delayed (for example, when the application for allowance is delayed)) will be described with reference to FIG. Every time the application is delayed, transfer journal work will occur. For example, when a child is born, there are frequent delays in applying for allowances to the company due to the large number and complexity of procedures with government agencies.

In FIG. 2, for example, an employee's child is born in May and is eligible for family allowance, but the application is delayed. For example, in June, apply for a family allowance one month later, and carry out retroactive work for May in accordance with the allowance payment for June.

(2) A case where the retroactive result is linked to accounting will be described with reference to FIG. In FIG. 3, in the personnel department, since the total value of the retroactive results (position allowance + wages on employment + overtime pay + family allowance, etc.) is paid as salary, it is not necessary to manage the difference in units of payment items. On the other hand, in the accounting department, since the account items are different for each payment item (for example, labor cost for job title allowance, 〇〇 cost for wages on job function, etc.), it is necessary to transfer the breakdown of the total value. In this transfer journal, the departments that perform business are divided, the target persons and items are enormous (for example, in the case of base-up and regular salary increase), and frequent work occurs (for example, in the case of retroactive payment item unit). Since the aggregation unit is different for each payment item, the work burden is very high, and if an error occurs in the breakdown calculation, the cost will be different from the actual cost.

FIG. 4 is a diagram for explaining an outline of journal creation at the time of retroactive work regarding salary of the present embodiment. In FIG. 4, in the present embodiment, by linking the retroactive results for each payment item instead of linking the total of the retroactive results, the work of creating the transfer journal is not required, and mistakes associated with the transfer journal are made. It will be eliminated and it will be possible to record expenses more accurately.

This embodiment is particularly effective for, for example, a large-scale user who has a labor union. Due to the nature of the work, retroactive work is characterized by the fact that it tends to occur in companies where there is a labor union and the power of the union is strong. In addition, this embodiment is also effective when the number of employees is large and the allowance unit is corrected for the past salary.

[2. Constitution]
An example of the configuration of the payroll processing device according to the present embodiment will be described with reference to the drawings.

FIG. 5 is a block diagram showing an example of a payroll processing device according to the present embodiment. The payroll processing device 100 is, for example, a commercially available desktop personal computer. The payroll processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

The payroll processing device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the payroll processing device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the payroll processing device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the payroll processing device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. As a result, the communication interface unit 104 is configured to be capable of data communication with the server 200 via the network 300.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving a command to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

Further, the storage unit 106 includes a journal linkage output item setting master (first master) 106a, a journal definition master (second master) 106b, an employee supply data file 106c, an employee deduction data file 106d, and an external device. It includes a linked data file 106e and a journal detail data file 106f. FIG. 6 is a diagram showing a data configuration example of the journal linkage output item setting master 106a and the journal definition master 106b. FIG. 7 is a diagram showing a data configuration example of employee supply data, employee deduction data, external cooperation data, and journal detail data.

The journal linkage output item setting master 106a outputs the normal portion (normal payment portion, normal deduction portion) or retroactive portion (retroactive payment portion, retroactive deduction portion) of salary data (employee payment data, employee deduction data), which is output as a journal. It is a master for setting items (payment items, deduction items). As shown in FIG. 6, the journal linkage output item setting master 106a has reference source information for designating a reference source such as a table of original data (for example, salary data) to be journalized and a data field, and a reference. It can be composed of a table or the like that is registered in association with the item name of the salary to be paid. For example, the reference source information "employee payment" specifies the "normal payment" of the retroactive flag of the employee payment data, and "employee payment_retroactive" specifies the "retroactive payment" of the retroactive flag of the employee payment data (see FIG. 13). ).

The journal definition master 106b is the normal portion (normal payment portion, normal deduction portion) or retroactive portion (retroactive payment portion, retroactive deduction) of salary data (employee payment data, employee deduction data) set in the journal linkage output item setting master 106a. It is a master for setting journal accounts for each item (payment item, deduction item) of (minute). As shown in FIG. 6, the journal definition master 106b is, for example, a table for registering the reference source information, the debit total account (code and / or name), and the credit total account (code and or name) in association with each other. Can be configured with. The journal linkage output item setting master 106a and the journal definition master 106b are linked by the reference source information.

The employee-supplied data file 106c is a file for storing the employee-supplied data. Employee-paid data is data for managing fixed / variable salary amounts and the like. As shown in FIG. 7, the employee payment data includes, for example, a retroactive flag that specifies normal payment or retroactive payment, an employee code that is employee identification information, and a total payment of payment items such as job title allowance and wages that are payment item names. It may include forehead data.

The employee deduction data file 106d is a file for storing the employee deduction data. Employee deduction data is data for managing the amount of fixed / variable deduction. As shown in FIG. 7, the employee deduction data may include total deduction data such as a retroactive flag that specifies normal deduction or retroactive deduction, an employee code that is employee identification information, and union fee that is a deduction item. good.

Salary data consists of employee payment data and employee deduction data.

The external linkage data file 106e is a file for storing external linkage data. The external linkage data is for managing the aggregated result of salary data before being converted into journal data. As shown in FIG. 7, the external cooperation data file 106e may include, for example, reference source information, item names of payment or deduction, and data such as an amount of money. The external linkage data is linked (linked) to the journal linkage output item setting master 106a and the journal definition master 106b with reference source information.

The journal detail data file 106f is a file for storing journal detail data (simply also referred to as "journal"). The journal detail data is for managing the data in the state of being finally created in the form of a journal. As shown in FIG. 7, the journal detail data includes, for example, a journal definition number, a debit total account (code and / or subject name), a debit amount, a credit total account (code and / or subject name), a credit amount, and the like. It may contain data.

Returning to FIG. 5, the control unit 102 is a CPU or the like that collectively controls the payroll processing device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

Here, the control unit 102 is functionally conceptually composed of an employee supply data creation unit 102a, an employee deduction data creation unit 102b, an external cooperation data creation unit 102c, a journal creation unit 102d, a master maintenance unit 102e, and a screen. It includes a display control unit 102f. The employee payment data creation unit 102a and the employee deduction data creation unit 102b constitute a salary data creation means.

The employee payment data creation unit 102a creates (calculates) employee payment data in response to an operator's operation on the employee payment input screen (not shown) displayed on the monitor 114, and creates the employee payment data file 106c. sign up.

The employee deduction data creation unit 102b creates (calculates) employee deduction data in response to an operator's operation on the employee deduction input screen (not shown) displayed on the monitor 114, and creates the employee deduction data file 106d. Store.

The external linkage data creation unit 102c creates external linkage data that aggregates the amount of salary data for each salary item of normal or retroactive portion of salary data set in the journal linkage output item setting master 106a, and externally. Stored in the linked data file 106e.

The journal creation unit 102d is a debit account and a credit account set in the journal definition master 106b corresponding to each item of salary for normal or retroactive salary data set in the journal linkage output item setting master 106a. In addition, journal detail data (journal) is created based on the total amount of the external linkage data and stored in the journal detail data file 106f.

The master maintenance unit 102e adds / deletes data of the journal linkage output item setting master 106a and the journal definition master 106ac according to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114. It is for editing such as changes.

The screen display control unit 102f controls the display and input of various screens (for example, employee supply input screen, employee deduction input screen, master maintenance screen, etc.) displayed on the monitor 114.

[3. Concrete example]
A specific example of the processing of the control unit 102 of the payroll processing device 100 according to the present embodiment will be described with reference to FIGS. 5 to 15. 8 and 9 are flows for explaining the outline of the overall processing flow of the control unit 102 of the payroll processing device 100. In the following description, the description of the unit of the amount of yen will be omitted.

With reference to FIGS. 8 and 9, the outline of the overall processing flow of the control unit 102 of the payroll processing device 100 will be described. In FIG. 8, the employee payment data creation unit 102a and / or the employee deduction data creation unit 102b executes the payroll calculation work, and the retroactive flag of the employee payment data and / or the employee deduction data (salary data) is normally divided. Calculate the amount of the salary item (payment item and / or deduction item) of (step S1).

The employee payment data creation unit 102a and / or the employee deduction data creation unit 102b executes the retroactive calculation work, and among the employee payment data and / or the employee deduction data (salary data), the retroactive flag is the item of the retroactive salary. Calculate the amount of (payment item and / or deduction item) (step S2).

The master maintenance unit 102e executes the output item master setting process, sets the reference source information and the salary item of the journal linkage output item setting master 106a, and registers the salary item to be generated in the journal (step S3). With the reference source information, it is possible to specify the actual salary (normal portion) and the retroactive difference (retroactive portion) of the items to be generated in the journal of salary data.

The master maintenance unit 102e executes the journal definition master setting process, registers the reference source information and the debit and credit accounts of the journal definition master 106b, and registers the conversion method of the salary item to be generated in the journal to the account. (Step S4).

The external linkage data creation unit 102c generates external linkage data which is the original data for conversion into journals (step S5). Specifically, the external linkage data creation unit 102c acquires (1) salary item information (reference source information, item name) to be generated in the journal set by the journal linkage output item setting master 106a, and (2) journal entry. Acquire the amount data from the salary data (employee payment data, employee deduction data) for the salary items to be raised in. Since the salary data (employee payment data, employee deduction data) manages the amount of the normal amount and the retroactive amount as separate records for each salary item, it is possible to generate the normal amount and the retroactive amount in the journal for each salary item. It is possible. Then, (3) create and register external linkage data that aggregates the acquired amount for each salary item to be generated in the journal.

The journal creation unit 102d converts (creates) the journal detail data which is the journal data (step S6). Specifically, (1) and (2) for each salary item (reference source information and item name) generated in the journal of the journal definition master 106b, the corresponding debit account and credit account, and the corresponding external linkage data. Acquire the amount and (3) create journal detail data based on the acquired information.

Next, specific data examples of the processes of FIGS. 8 and 9 will be described with reference to FIGS. 10 to 15. 10 to 15 are diagrams showing specific data samples of the processes of FIGS. 8 and 9 described above. In the following example, the case of creating a journal for employee-paid data among salary data will be described.

(S1: Payroll business)
FIG. 10 is a diagram for explaining a payroll operation. In FIG. 10, the amount of the payment item for the normal payment whose retroactive flag of the employee payment data is “normal payment” is determined. In the example shown in FIG. 10, the first line is the retroactive flag "normal payment", the employee code "Mr. A", the job title allowance "150,000", the wages on the job "60,000", and the third line is the retroactive flag " It will be "normal payment", employee code "Mr. B", job title allowance "20,000", and wages on the job "30,000".

(S2: Retroactive calculation work)
FIG. 11 is a diagram for explaining the retroactive calculation work. In FIG. 11, the amount of the payment item for the retroactive payment whose retroactive flag of the employee payment data is “retroactive payment” is determined. In the example shown in FIG. 11, the second line is the retroactive flag "retroactive payment", the employee code "Mr. A", the job title allowance "20,000", the wages on the job "10,000", and the fourth line is the retroactive flag "retroactive payment". "Retroactive payment", employee code "Mr. B", job title allowance "10,000", wages on the job "10,000".

(S3: Journal linkage output item master setting)
FIG. 12 is a diagram for explaining the setting of the journal linkage output item setting master 106a. In FIG. 12, the reference source information of the journal linkage output item setting master 106a and the salary item (payment item) to be generated in the journal are registered. In the reference source information, it is possible to specify the reference destination data and its retroactive flag "normal payment" and "retroactive payment". For example, the reference source information "employee payment" is retroactive of the employee payment data. The flag "normal payment" and "employee payment_retroactive" specify the "retroactive payment" of the retroactive flag of the employee payment data.

In the example of the journal linkage output item setting master 106a shown in FIG. 12, the first line is the reference source information "employee payment", the payment item name "position allowance", and the second line is the reference source information "employee payment_retroactive". , Payment item name "Job title allowance_retroactive", 3rd line is reference source information "Employee payment", Payment item name "Wages on job", 4th line is Reference source information "Employee payment_retroactive", Payment item name "Wages on the job_retroactive" is set.

(S4: Journal definition master setting)
FIG. 13 is a diagram for explaining the setting of the journal definition master 106b. In FIG. 13, the account item of the journal is set for the salary item (payment item) set in the journal linkage output item setting master 106a. The same data as the journal linkage output item setting master 106a is set for the reference source information and the item name of the journal definition master 106b.

In the example of the journal definition master 106b shown in FIG. 13, the first line is the reference source information “employee payment”, the item name “position allowance”, the debit total account “1000: labor cost”, and the credit total account “3000:”. "Checking deposit", the second line is the reference source information "Employee payment_retroactive", item name "Position allowance_retroactive", debit total account "1000: personnel expenses", credit total account "3000: checking" Set. The third line is the reference source information "employee payment", the item name "professional salary", the debit total account "2000: 〇〇 expense", the credit total account "3000: checking account", and the fourth line is the reference source. Information "Employee payment_retroactive", item name "professional salary_retroactive", debit total account "2000: 〇〇 expense", credit total account "3000: checking deposit" are set.

(S5: External cooperation data generation)
FIG. 14 is a diagram for explaining the generation of external cooperation data. In FIG. 14, the payment items (reference source information and salary item name) to be generated in the journal set by the journal linkage output item setting master 106a are acquired, and the amount is calculated by referring to the employee payment data for each acquired payment item. Generate aggregated external linkage data.

In the example of the external linkage data shown in FIG. 14, the reference source information and the salary item name of the external linkage data are the same as those of the journal linkage output item setting master 106a. Since the first line is the reference source information "employee payment" and the item name "position allowance", the position allowance "150,000" in the first line and the position allowance "20,000" in the third line of the employee payment data. Is acquired and totaled, and the amount of money "170,000" is calculated. Since the second line is the reference source information "employee payment_retroactive" and the item name "position allowance_retroactive", the second line of the employee payment data is the position allowance "20,000" and the fourth line is the position allowance " "10,000" is acquired and totaled, and the amount "30,000" is calculated.

Since the third line is the reference source information "employee payment" and the item name "work performance salary", the work performance salary "60,000" in the first line and the work performance salary "30,000" in the third line of the employee payment data. Is acquired and totaled, and the amount of money "90,000" is calculated. Since the fourth line is the reference source information "employee payment_retroactive" and the item name "professional wages_retroactive", the second line wages "10,000" and the fourth line wages "10,000" of the employee payment data "10,000" is acquired and totaled, and the amount "20,000" is calculated.

(S6: Convert to journal data)
FIG. 15 is a diagram for explaining conversion to journal data, that is, generation of journal detail data. In FIG. 15, journal detail data is created based on the journal definition master 106b and the external linkage data. Specifically, using the reference source information and the item name as keys, the debit total account and the credit total account are acquired from the journal definition master 106b, and the amount of the external linkage data is acquired as the debit amount and the credit amount. Create journal detail data.

In the example of the journal detail data shown in FIG. 15, the first line is the debit total account "1000: labor cost", the debit amount "170,000", the credit total account "3000: checking account", and the credit amount "170". The second line is the debit total account "1000: labor cost", the debit amount "30,000", the credit total account "3000: checking account", and the credit amount "30,000".

The third line is the debit total account "2000: 〇〇 expense", the debit amount "90,000", the credit total account "3000: checking account", the credit amount "90,000", and the fourth line is the debit amount. The total account item is "2000: 〇〇 expense", the debit amount is "20,000", the credit total account item is "3000: checking account", and the credit amount is "20,000".

As described above, according to the present embodiment, the storage unit contains salary data including a flag for designating a normal portion or a retroactive portion, employee identification information, and an amount for each salary item. Journal linkage output item that sets the normal or retroactive salary item of salary data including the flag that specifies the normal or retroactive amount to be output as a journal, the employee identification information, and the amount of each salary item. The setting master (first master) 106a, the journal definition master 106b that sets the debit account and the credit account for each salary item of the normal amount or the retroactive amount set in the journal linkage output item setting master 106a, and the journal definition master 106b. The amount of salary data is totaled for each of the regular or retroactive salary items set in the employee payment data creation unit 102a and the employee deduction data creation unit 102b that create salary data, and the journal linkage output item setting master 106a. The debit account set in the journal definition master 106b corresponding to each item of the normal salary or the retroactive salary set in the external linkage data creation unit 102c that creates the external linkage data and the journal linkage output item setting master 106a. Since it is equipped with a credit account and a journal creation unit 102d that creates journals based on the aggregated amount of external linkage data, it is possible to automatically create journals during retroactive work related to salary. It is possible to reduce the work load and improve the accuracy of expense accounting.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the payroll processing apparatus 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the payroll processing device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the payroll processing apparatus is required. Read mechanically to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit 106 such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the payroll processing apparatus 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. be.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes 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), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Optical Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

The "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, the installation procedure after reading, and the like.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the payroll processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the payroll processing device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the information processing device.

Further, the specific form of the distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or the like. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Payroll processing device 102 Control unit 102a Employee supply data creation unit 102b Employee deduction data creation unit 102c External linkage data creation unit 102d Journal creation unit 102e Master maintenance unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 106a Journal linkage output item Setting master 106b Journal definition master 106c Employee supply data file 106d Employee deduction data file 106e External linkage data file 106f Journal detail data file 108 Input / output interface unit 112 Input device 114 Output device 300 Network

Claims (5)

A payroll processing device equipped with a storage unit and a control unit.
In the storage unit
Salary data including a flag that specifies normal or retroactive portion, employee identification information, and the amount of each salary item.
A first master that sets salary items for normal or retroactive salary data to be output as a journal, and
A second master that sets a debit account and a credit account for each item of regular or retroactive salary set in the first master, and
Is stored,
The control unit
The salary data creation means for creating the salary data and
An external linkage data creation means for creating external linkage data that aggregates the amount of the salary data for each item of salary for normal or retroactive portion set in the first master.
To the debit account and credit account set in the second master corresponding to each item of salary for normal or retroactive amount set in the first master, and the aggregated amount of the external linkage data. Journal creation means to create journals based on
A payroll processing device characterized by being equipped with. The ordinary portion includes the ordinary payment portion and the ordinary deduction portion.
The retroactive portion includes the retroactive payment portion and the retroactive deduction portion.
The salary processing device according to claim 1, wherein the salary item includes a payment item and a deduction item. The salary processing device according to claim 2, wherein the payment item includes at least one of job title allowance, job salary, overtime pay, and family allowance, and the deduction item includes union dues. It is a payroll processing method to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
Salary data including a flag that specifies normal or retroactive portion, employee identification information, and the amount of each salary item.
A first master that sets salary items for normal or retroactive salary data to be output as a journal, and
A second master that sets a debit account and a credit account for each item of regular or retroactive salary set in the first master, and
Is stored,
Executed in the control unit,
The salary data creation step for creating the salary data and
An external linkage data creation step for creating external linkage data that aggregates the amount of the salary data for each item of normal salary or retroactive salary set in the first master.
To the debit account and credit account set in the second master corresponding to each item of salary for normal or retroactive amount set in the first master, and the aggregated amount of the external linkage data. Journal creation steps to create journals based on
A payroll method characterized by including. It is a payroll processing program to be executed by an information processing device equipped with a control unit and a storage unit.
Salary data including a flag that specifies normal or retroactive portion, employee identification information, and the amount of each salary item.
A first master that sets salary items for normal or retroactive salary data to be output as a journal, and
A second master that sets a debit account and a credit account for each item of regular or retroactive salary set in the first master, and
Is stored,
In the control unit
The salary data creation step for creating the salary data and
An external linkage data creation step for creating external linkage data that aggregates the amount of the salary data for each item of normal salary or retroactive salary set in the first master.
To the debit account and credit account set in the second master, and the aggregated amount of the external linkage data corresponding to each salary item of the normal amount or the retroactive amount set in the first master. Journal creation steps to create journals based on
Payroll program to run.

Images