JP7623313B2 - Payroll calculation device, payroll calculation method, and payroll calculation program - Google Patents

Description

The present invention relates to a payroll calculation device, a payroll calculation method, and a payroll calculation program.

Today, for example, in the temp agency industry, variable allowances such as travel expenses that have been paid in advance by staff are billed to clients in the current month, and the same amount of variable allowance is added to the staff's salary the following month.

Regarding variable allowances, Patent Document 1 (JP Patent Publication 62-137659A) discloses a payroll calculation variable pay management system that manages monthly changing monetary information for variable allowances such as insurance allowances and travel allowances, and inputs or modifies the information via keyboard each time it occurs, regardless of when the payroll is calculated.

Japanese Unexamined Patent Publication No. 137659/1983

However, previously, because the processing month for billing clients for travel expenses etc. paid by staff members differed from the processing month for the salary paid to staff members, business operators managed the amounts of variable allowances etc. outside the system until the following month's salary processing. This resulted in inconveniences such as billing clients for travel expenses etc. but not paying the variable allowance to staff members, and conversely, paying variable allowances to staff members but not billing clients. Such inconveniences can be prevented to some extent by matching billings with salaries for each client, but this is not desirable as it increases the workload of business operators.

The present invention was made in consideration of the above-mentioned problems, and aims to provide a payroll calculation device, a payroll calculation method, and a payroll calculation program that enable payroll calculations that prevent missed claims and missed payments of variable allowances.

In order to solve the above-mentioned problems and achieve the objectives, the payroll calculation device of the present invention has a variable allowance data generation unit that generates variable allowance data indicating a variable allowance which is an allowance for a transaction category that has been claimed by the payroll closing date and for which the claim is approved and the claimed amount fluctuates and stores it in a memory unit, and a payroll data generation unit that generates payroll data by reading from the memory unit the variable allowance claimed by the payroll closing date and adding it to the payroll corresponding to the payroll closing date, calculated based on the payroll closing date .

In addition, in order to solve the above-mentioned problems and achieve the objectives, the payroll calculation method of the present invention includes a variable allowance data generation step in which a variable allowance data generation unit generates variable allowance data indicating a variable allowance that is an allowance for a transaction category that has been claimed by the payroll closing date and for which the claim is approved and whose claimed amount varies, and stores the variable allowance data in a memory unit, and a payroll data generation step in which the payroll data generation unit reads out from the memory unit the variable allowance claimed by the payroll closing date and adds it to the salary corresponding to the payroll closing date, calculated based on the payroll closing date .

In addition, in order to solve the above-mentioned problems and achieve the objective, the payroll calculation program of the present invention causes a computer to function as a variable allowance data generation unit that generates variable allowance data indicating a variable allowance that is an allowance for a transaction category that has been claimed by the payroll closing date and for which the claim has been approved , and whose claimed amount fluctuates, and stores the data in a memory unit, and a payroll data generation unit that reads the variable allowance claimed by the payroll closing date from the memory unit and adds it to the payroll corresponding to the payroll closing date, calculated based on the payroll closing date.

The present invention makes it possible to perform payroll calculations that prevent missed claims and missed payments of variable allowances.

FIG. 1 is a block diagram showing the hardware configuration of a payroll calculation device according to an embodiment of the present invention. FIG. 2 is a diagram showing an example of the transaction classification master. FIG. 3 is a diagram illustrating an example of the salary item master. FIG. 4 is a diagram showing an example of the payroll closing date master. FIG. 5 is a diagram showing an example of case basic data. FIG. 6 is a diagram showing an example of basic data of a contract work. FIG. 7 is a flowchart showing the flow of the payroll calculation operation in the payroll calculation device of the embodiment. FIG. 8 is a diagram showing an example of a roster input screen. FIG. 9 is a diagram showing an example of the variable allowance/deduction input screen. FIG. 10 is a diagram showing an example of variable allowance data (billed amount) and variable allowance data (salary amount). FIG. 11 is another flowchart showing the flow of the payroll calculation operation in the payroll calculation device of the embodiment. FIG. 12 is a diagram showing another example of the roster input screen. FIG. 13 is a diagram illustrating an example of variable allowance data. FIG. 14 is a diagram showing another example of the variable allowance/deduction input screen. FIG. 15 is a diagram for explaining the order in which variable allowances are determined. FIG. 16 is a diagram illustrating an example of salary data.

Below, a payroll calculation device according to an embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

(Hardware configuration)
FIG. 1 is a block diagram showing the hardware configuration of a salary calculation device 1 according to an embodiment. As an example, the salary calculation device 1 according to an embodiment is used for salary calculation by a temporary staffing agency that dispatches temporary workers to companies and the like. The salary calculation device 1 includes a memory 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 television) can be used. As the input device 6, a keyboard device, a mouse device, a microphone device, and a monitor device that cooperates with a mouse device to realize a pointing device function can be used.

The memory unit 2 may be, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), a HDD (Hard Disk Drive), or an SSD (Solid State Drive). The memory unit 2 is provided with a transaction category master 11, a payroll item master 12, a payroll closing date master 13, a case basic table 14, and a contract work basic table 15, each of which is a storage area.

As shown in Figure 2, the transaction category master 11 stores transaction category codes and transaction category names. The example in Figure 2 shows that the transaction category code for business trip expenses is "10", the transaction category code for commuting expenses is "30", the transaction category code for meal expenses is "50", and the transaction category code for communication expenses is "60".

As shown in Figure 3, the salary item master 12 stores the transaction category code and transaction category name of variable allowances. The example in Figure 3 shows that the transaction category code for travel expenses is "1", the transaction category code for meal expenses is "2", and the transaction category code for health checkups is "3".

The payroll closing date master 13 stores the closing date for payroll calculations for companies and other entities that use the payroll calculation device 1 of the embodiment. In the example of Figure 4, the "10th" of each month is registered as the payroll closing date.

As shown in FIG. 5, the case basic table 14 stores the case number, contract period (start date: from), contract period (end date: To), customer code, and business content. The example in FIG. 5 shows that the business with case number "100" is sales work for a customer with customer code "T0001" and the contract period is "January 1, 2021 to March 31, 2022." The example in FIG. 5 also shows that the business with case number "300" is marketing work for a customer with customer code "T0002" and the contract period is "April 1, 2022 to June 30, 2022."

The constraint work basic table 15 stores the contract work number, case number, and staff code. The example in Figure 6 shows that the business with case number "100", which is sales work for the customer with customer code "T0001" described in Figure 5, was contracted with a contract work number of "1101" by a staff member (temporary employee) with a staff code of "1001". The example in Figure 6 also shows that the business with case number "300", which is marketing work for the customer with customer code "T0002" described in Figure 5, was contracted with a contract work number of "3301" by a staff member (temporary employee) with a staff code of "3001".

(Functional configuration of payroll calculation device)
Next, a payroll calculation program is stored in the memory unit 2. The control unit 3 of the payroll calculation device 1 executes the payroll calculation program stored in the memory unit 2, thereby functioning as an input processing unit 21, a memory control unit 22, a data generation unit 23, and a display control unit 24. The data generation unit 23 is an example of a variable allowance data generation unit and a payroll data generation unit.

The input processing unit 21 performs input processing corresponding to the input operation performed by the business operator via the input device 6. The memory control unit 22 temporarily stores variable allowance data corresponding to the variable allowance requested by the staff in the memory unit 2, and reads it out the following month to reflect it in the salary data. The data generation unit 23 generates variable allowance data corresponding to the variable allowance to be paid together with the salary for the following month. The display control unit 24 displays a work schedule input screen, a variable allowance/deduction input screen, etc. on the output device 7.

(Payroll calculation operation)
In this embodiment, the payroll calculation device 1 temporarily stores variable allowances such as travel expenses claimed by staff in the memory unit 2, and reads them out the following month to automatically reflect them in the payroll data. The flow of payroll calculation operations in this embodiment of the payroll calculation device 1 is shown in the flowcharts of Figures 7 and 11. Each process in the flowcharts of Figures 7 and 11 is executed by the control unit 3 based on the payroll calculation program.

First, when entering variable allowances such as travel expenses claimed by staff, the business operator performs a display specification operation of the roster input screen. When this display specification operation of the roster input screen is performed, in step S1 of the flowchart in FIG. 7, the display control unit 24 displays the roster input screen illustrated in FIG. 8. This roster input screen has an attendance type selection field for "claimed attendance" or "paid attendance," an input field for the staff code, an input field for the case number, an input field for the year and month, and an input field for the closing date.

In the example of Figure 8, "claimed attendance" has been selected as the attendance type in order to enter variable allowances such as travel expenses. The example of Figure 8 also shows the input of a variable allowance from a staff member with case number "100" and staff code "1001". The example of Figure 8 also shows that the claim month for the variable allowance is "May 2021" and the closing date for this month's payroll calculation is "the 31st".

In step S2 of the flowchart in FIG. 7, the display control unit 24 determines whether or not "billed attendance" has been selected as the attendance type. If "paid attendance" has been selected as the attendance type, processing proceeds to step S11 in FIG. 11, which will be described later. If "billed attendance" has been selected as the attendance type (step S2: Yes), processing proceeds to step S3. In step S3, the display control unit 24 determines whether or not the "variable allowance" button shown in FIG. 8 has been operated.

When the "Variable Allowance" button operation is detected (step S3: Yes), the display control unit 24 displays the variable allowance/deduction input screen shown in FIG. 9 in step S4. In the variable allowance/deduction input screen shown in FIG. 9, the business operator inputs the next month's salary amount to be reflected in the next month's salary, and selects the transaction category and the next month's salary item. The example in FIG. 9 is an example in which "50,000 yen" has been claimed by a staff member as travel expenses for a business trip as the next month's salary amount. In this case, the business operator selects "10: Travel expenses" as the transaction category (see FIG. 2) and "1: Travel expenses" as the next month's salary item (see FIG. 3). The business operator then inputs the "50,000 yen" claimed by the staff member as the next month's salary amount.

The input processing unit 21 acquires the various data thus input via the variable allowance/deduction input screen. The data generating unit 23 performs variable allowance input processing to generate variable allowance data (billed amount) to be reflected in the next month's salary, as shown in FIG. 10(a) based on the various acquired data (step S5). As shown in FIG. 10(a), the variable allowance data (billed amount) includes a closing date, data category, contract number, and staff code. The variable allowance data (billed amount) also includes an allowance amount, transaction category, next month's salary item, and next month's salary amount. The example in FIG. 10(a) is an example in which variable allowance data (billed amount) is generated based on the various data input on the variable allowance/deduction input screen, with the data category being "1: billing", the allowance amount being "50,000 yen", transaction category 1 being "10: travel expenses", the next month's salary item being "1: travel expenses", and the next month's salary amount being "50,000 yen".

Next, in step S6, when the data generating unit 23 generates such variable allowance data (billing amount), it also generates variable allowance data (salary amount) that will be the next month's salary. The variable allowance data (salary amount) includes a closing date, data category, contract number, and staff code, as shown in FIG. 10(b). The variable allowance data (salary amount) also includes the allowance amount, transaction category, next month's salary item, and next month's salary amount. The example in FIG. 10(b) is an example in which variable allowance data (salary amount) with the data category set to "2: Salary" and the allowance amount set to "50,000 yen" was generated based on various data entered in the variable allowance/deduction input screen. The memory control unit 22 stores such variable allowance data (billing amount) and variable allowance data (salary amount) in the memory unit 2.

As shown in Fig. 10(a) and Fig. 10(b), the variable allowance data (billed amount) and variable allowance data (salary amount) have next month salary items numbered "1 to 30," and, as an example, it is possible to input variable allowances for up to 30 items. As a result, variable allowance data including one or more claimed variable allowances is generated by the data generation unit 23.

Next, when entering salary and allowances, the business operator selects "Salary Attendance" as the attendance type on the above-mentioned roster input screen, as shown in FIG. 12. If "Salary Attendance" is selected, the answer is determined to be "No" in step S2 of the flowchart in FIG. 7, and the process proceeds to step S11 in FIG. 11.

In step S11, the display control unit 24 determines whether or not the "Variable Allowance" button shown in FIG. 12 has been operated. In this case, the business operator selects "Salary Attendance" and specifies the year and month for which the salary data will be created, for example, "June 2021," and specifies the salary closing date registered in the salary closing date master 13 shown in FIG. 4 (for example, the 10th) as the salary closing date. Then, in this state, the business operator operates the "Variable Allowance" button.

When the display control unit 24 detects a button operation for "variable allowance" while "salary and attendance" is selected on the work schedule input screen, the memory control unit 22 reads out the above-mentioned variable allowance data (salary portion) shown in FIG. 13, which is stored in the memory unit 2. In step S12, the display control unit 24 displays a variable allowance and deduction input screen in which the variable allowance indicated by the read variable allowance data (salary portion) is automatically input, as shown in FIG. 14.

The example in FIG. 14 is an example of a variable allowance/deduction input screen in which "travel expenses" of "50,000 yen" to be added to the salary for June 2021 is automatically input. Since the salary items are fixed, in step S13, the display control unit 24 confirms the input items of the variable allowance data in the order of the transaction classification codes in the salary item master 12, as shown in FIG. 15.

Next, in step S14, the data generation unit 23 performs payroll processing to generate payroll data that associates the basic salary and variable allowance for each staff member, as shown in FIG. 16. The example in FIG. 16 shows an example in which the basic salary is "100,000 yen" for a staff member with staff code "1001", and travel expenses of "50,000 yen" claimed in May 2021 are reflected in the salary for June 2021 and paid. The example in FIG. 16 also shows an example in which the basic salary is "300,000 yen" for a staff member with staff code "3001", and meal expenses of "30,000 yen" claimed in May 2021 are reflected in the salary for June 2021 and paid.

As described above, the variable allowance data (billed amount) and variable allowance data (salary amount) have next month salary items "1 to 30" as shown in Figures 10(a) and 10(b). Therefore, the salary data generated by the data generation unit 23 based on such variable allowance data will also be salary data that includes one or more claimed variable allowances, as shown in Figure 16.

(Effects of the embodiment)
As is clear from the above explanation, the payroll calculation device 1 of the embodiment can automatically slide the variable allowance claimed in the current month into the target employee's salary for the next month and pay it. This prevents inconveniences such as, for example, billing a client for travel expenses, but failing to pay the variable allowance to the staff, or conversely, paying the variable allowance to the staff, but failing to bill the client.

In addition, the variable allowance claimed in the current month can be automatically adjusted into the employee's salary for the following month, making it possible to perform payroll calculations that prevent inconveniences such as overlooking the payment of variable allowances to the above-mentioned staff members, without increasing the workload of the business operators.

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

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs Goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using a known method.

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

In addition, with regard to the payroll calculation device 1, 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, the processing functions of the payroll calculation device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the payroll calculation device 1 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to constitute the control unit 3.

The payroll calculation program of this payroll calculation device 1 may also be stored in another server device connected to the payroll calculation device 1 via any network, and all or part of it may be downloaded as needed.

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

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

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

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

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful for payroll calculations in companies, temporary staffing agencies, etc.

REFERENCE SIGNS LIST 1 Payroll calculation device 2 Memory unit 3 Control unit 4 Communication interface unit 5 Input/output interface unit 6 Input device 7 Output device 11 Transaction classification master 12 Payroll item master 13 Payroll closing date master 14 Case basic table 15 Contract work basic table 21 Input processing unit 22 Memory control unit 23 Data generation unit 24 Display control unit

Claims (5)

a variable allowance data generating unit that generates variable allowance data indicating a variable allowance that is an allowance of a transaction category that has been claimed by the payroll closing date and whose claim amount fluctuates, and stores the variable allowance data in a storage unit ;
a salary data generating unit that generates salary data by reading from the storage unit and adding the variable allowance claimed by the payroll closing date to the salary corresponding to the payroll closing date, the salary data being calculated based on the payroll closing date ;
A payroll calculation device having the above structure. The variable allowance data generating unit generates the variable allowance data including one or more requested variable allowances;
2. The payroll calculation device according to claim 1 . The salary data generating unit generates the salary data including one or more requested variable allowances;
3. The payroll calculation device according to claim 1 or 2, characterized in that a variable allowance data generating step in which a variable allowance data generating unit generates variable allowance data indicating a variable allowance that is an allowance of a transaction category that has been claimed by the payroll closing date and whose claim is permitted and whose claimed amount fluctuates, and stores the variable allowance data in a storage unit ;
a salary data generating step in which a salary data generating unit generates salary data by reading out from the storage unit the variable allowance claimed by the payroll closing date and adding it to the salary corresponding to the payroll closing date, the salary data being calculated based on the payroll closing date;
A payroll calculation method having the following: Computer,
a variable allowance data generating unit that generates variable allowance data indicating a variable allowance that is an allowance of a transaction category that has been claimed by the payroll closing date and whose claim amount fluctuates, and stores the variable allowance data in a storage unit ;
functioning as a salary data generating unit that generates salary data by reading from the storage unit and adding the variable allowance claimed by the payroll closing date to the salary corresponding to the payroll closing date, the salary calculated based on the payroll closing date ;
A payroll program that features:

Images