JP2023132177A - Salary calculation device, salary calculation method, and salary calculation program - Google Patents

Abstract

To enable a salary calculation that prevents omission of a claim and omission of payment of a variable allowance.SOLUTION: A variable allowance data generation unit generates variable allowance data corresponding to a claimed variable allowance and to be paid with a salary the next time, and stores the variable allowance data in a storage unit. A salary data generation unit reads the variable allowance data from the storage unit and generates added salary data in generating salary data corresponding to the next time. This can automatically slide an allowance claimed for the current month to a salary of an object employee for the next month to pay the salary, and can prevent omission of a claim and omission of payment of the variable allowance.SELECTED DRAWING: Figure 10

Description

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

Nowadays, for example, in the temporary staffing industry, there are cases in which staff request variable allowances such as travel expenses that have been paid in advance to clients in the current month, and then pay the same amount of variable allowances to the staff member's salary the following month.

Regarding variable allowances, Patent Document 1 (Japanese Unexamined Patent Publication No. 62-137659) states that, for example, information on amounts that change monthly, such as variable allowances such as insurance allowances and business trip allowances, is managed, and each time it occurs, regardless of the time of salary calculation, A payroll variable pay management system is disclosed in which inputs or corrections are made via a keyboard.

Japanese Unexamined Patent Publication No. 137659/1983

However, in the past, the processing month for invoicing customers for travel expenses etc. paid by staff and the salary paid to staff was delayed, so business operators had to pay variable allowances until the next month's salary processing. Amounts, etc. were managed outside the system. As a result, although we billed our customers for travel expenses, etc., we failed to pay variable allowances to our staff, and conversely, although we paid variable allowances to our staff, we failed to bill our customers. This caused an inconvenience. Although such inconveniences can be prevented to some extent by comparing invoices and salaries for each customer, this is not desirable because it increases the work burden on the business operator.

The present invention has been made in view 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 omissions in claims and payments of variable allowances. shall be.

In order to solve the above-mentioned problems and achieve the purpose, the payroll calculation device according to the present invention generates variable allowance data to be paid next time with the salary corresponding to the requested variable allowance, and stores it in the storage unit. It has a variable allowance data generation section, and a salary data generation section that reads the variable allowance data from the storage section and generates added salary data when generating salary data corresponding to the next time.

In addition, in order to solve the above-mentioned problems and achieve the purpose, the salary calculation method according to the present invention is such that the variable allowance data generation unit generates variable allowance data to be paid with the next salary, corresponding to the requested variable allowance. a variable allowance data generation step in which the variable allowance data is generated and stored in the storage unit, and the salary data generation unit reads the variable allowance data from the storage unit and generates the added salary data when generating corresponding salary data next time. a generation step.

In addition, in order to solve the above-mentioned problems and achieve the purpose, the payroll calculation program according to the present invention causes the computer to generate variable allowance data to be paid next time with the salary, corresponding to the requested variable allowance, It functions as a variable allowance data generation unit that is stored in a storage unit and a salary data generation unit that reads variable allowance data from the storage unit and generates added salary data when generating salary data corresponding to the next time.

INDUSTRIAL APPLICABILITY The present invention can perform salary calculations that prevent omissions in billing and omissions in payment of variable allowances.

FIG. 1 is a block diagram showing the hardware configuration of a payroll calculation device according to an embodiment. FIG. 2 is a diagram showing an example of a transaction classification master. FIG. 3 is a diagram showing an example of a salary item master. FIG. 4 is a diagram showing an example of a 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 contracted work basic data. FIG. 7 is a flowchart showing the flow of payroll calculation operations in the payroll calculation device of the embodiment. FIG. 8 is a diagram showing an example of a work schedule input screen. FIG. 9 is a diagram showing an example of a variable allowance/deduction input screen. FIG. 10 is a diagram showing an example of variable allowance data (bill portion) and variable allowance data (salary portion). 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 work list input screen. FIG. 13 is a diagram showing 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 showing an example of salary data.

DESCRIPTION OF THE PREFERRED EMBODIMENTS A payroll calculation device according to an embodiment of the present invention will be described in detail below 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 payroll calculation device 1 according to an embodiment. Although this is just one example, the payroll calculation device 1 of the embodiment is used for payroll calculation of a temporary staffing company that dispatches temporary employees to companies and the like. This payroll calculation device 1 includes a storage section 2, a control section 3, a communication interface section 4, and an input/output interface section 5. An input device 6 and an output device 7 are connected to the input/output interface section 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, 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.

As the storage unit 2, 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. The storage unit 2 is provided with a transaction classification master 11, a salary item master 12, a salary closing date master 13, a case basic table 14, and a contract work basic table 15, which are storage areas, respectively.

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

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

The payroll closing date master 13 stores the closing dates for payroll calculations of companies, etc. that use the payroll calculation device 1 of the embodiment. The example in FIG. 4 is an example in which the "10th" of every month is registered as the salary cutoff 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. In the example in Figure 5, the business with the project number "100" is sales work for the customer with the customer code "T0001", and the contract period is "January 1, 2021 to March 31, 2022". It shows that. In addition, in the example in Figure 5, the business with the project number "300" is marketing business for the customer with the customer code "T0002", and the contract period is "April 1, 2022 to June 30, 2022". It shows that it is "day".

The constraint work basic table 15 stores contract work numbers, case numbers, and staff codes. In the example of FIG. 6, the work with the case number "100", which is a sales office work for the customer with the customer code "T0001" explained using FIG. 5, has the contract work number "1101", and '' indicates that the contract was concluded by a staff member (temporary employee) with the staff code. In addition, in the example of FIG. 6, the business with the project number "300", which is the marketing business for the customer with the customer code "T0002" explained using FIG. 5, has the contract work number "3301", and " This indicates that the contract was concluded by a staff member (temporary employee) with a staff code of 3001.

(Functional configuration of payroll calculation device)
Next, the storage unit 2 stores a payroll calculation program. The control unit 3 of the payroll calculation device 1 functions as an input processing unit 21, a storage control unit 22, a data generation unit 23, and a display control unit 24 by executing the payroll calculation program stored in the storage unit 2. do. The data generation unit 23 is an example of a variable allowance data generation unit and a salary data generation unit.

The input processing unit 21 performs input processing corresponding to an input operation performed by a business operator via the input device 6. The storage control unit 22 temporarily stores variable allowance data corresponding to the variable allowance requested by the staff in the storage unit 2, reads it out in the next month, and reflects 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 next month's salary. 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)
The salary calculation device 1 of this embodiment temporarily stores variable allowances such as travel expenses requested by staff in the storage unit 2, reads them out in the next month, and automatically reflects them on the salary data. . The flow of the payroll calculation operation in the payroll calculation device 1 of this embodiment is shown in the flowcharts of FIGS. 7 and 11. Each process in the flowcharts of FIGS. 7 and 11 is executed by the control unit 3 based on the payroll calculation program.

First, when inputting variable allowances such as travel expenses requested by staff, the business operator performs a display designation operation on the work schedule input screen. When this operation for specifying the display of the work schedule input screen is performed, in step S1 of the flowchart of FIG. 7, the display control unit 24 displays the work schedule input screen illustrated in FIG. 8. This worksheet input screen has an attendance type selection field of "Billed Attendance" or "Salary Attendance", an input field for staff code, an input field for case number, an input field for year and month, and an input field for closing date. .

In the example shown in FIG. 8, "billed attendance" is selected as the attendance type in order to input variable allowances such as business trip expenses. Further, the example in FIG. 8 shows input of a variable allowance from a staff member whose case number is "100" and whose staff code is "1001." Further, the example in FIG. 8 shows that the request date and month of the variable allowance is "May 2021" and the closing date of this month for payroll calculation is "31st".

In step S2 of the flowchart of FIG. 7, the display control unit 24 determines whether "billed attendance" is selected as the attendance type. If "salary attendance" is selected as the attendance type, the process proceeds to step S11 in FIG. 11, which will be described later. If "billed attendance" is selected as the attendance type (step S2: Yes), the process advances 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 button operation for "variable allowance" is detected (step S3: Yes), the display control unit 24 displays the variable allowance/deduction input screen shown in FIG. 9 in step S4. On 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 next month's salary item. The example shown in FIG. 9 is an example in which a staff member requests 50,000 yen for transportation expenses for a business trip as the salary amount for the next month. In this case, the business operator selects "10: Travel expenses" as the transaction category (see FIG. 2) and selects "1: Travel expenses" as the next month's salary item (see FIG. 3). Then, input the "50,000 yen" requested by the staff as the next month's salary amount.

The input processing unit 21 acquires various data input via the variable allowance/deduction input screen in this manner. The data generation unit 23 performs a variable allowance input process to generate variable allowance data (billed amount) to be reflected in the next month's salary as illustrated in FIG. 10(a), based on the various acquired data (step S5). As shown in FIG. 10(a), the variable allowance data (billed portion) includes a closing date, data classification, contract number, and staff code. Further, the variable allowance data (claimed portion) includes the allowance amount, transaction category, next month's salary item, and next month's salary amount. In the example shown in Fig. 10(a), the data category is "1: Claim", the allowance amount is "50,000 yen", and the transaction category 1 is "10 In this example, variable allowance data (invoice amount) is generated in which the next month's salary item is "1: Travel expenses" and the next month's salary amount is "50,000 yen."

Next, in step S6, when the data generation unit 23 generates such variable allowance data (billing portion), it also generates variable allowance data (salary portion) that will be the next month's salary portion. The variable allowance data (salary portion) includes the closing date, data classification, contract number, and staff code, as illustrated in FIG. 10(b). Further, the variable allowance data (salary portion) includes the allowance amount, transaction category, next month's salary item, and next month's salary amount. In the example shown in Figure 10(b), the data category is "2: Salary", and the variable allowance data (salary ) is generated. The storage control unit 22 stores such variable allowance data (invoice portion) and variable allowance data (salary portion) in the storage unit 2.

Furthermore, as shown in Figures 10(a) and 10(b), the variable allowance data (claimed portion) and variable allowance data (salary portion) are provided with next month salary items from 1 to 30. Although this is just an example, it is possible to input variable allowances for up to 30 items. As a result, variable allowance data including one or more requested variable allowances is generated by the data generation unit 23.

Next, when inputting salary allowances, the business operator selects "salary and attendance" as the attendance type on the above-mentioned work schedule input screen, as shown in FIG. 12. If this "salary and attendance" is selected, "No" is determined in step S2 of the flowchart of FIG. 7, and the process proceeds to step S11 of 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", specifies the year and month for creating salary data, for example, "June 2021", and also sets the salary cutoff date as shown in Figure 4. Specify the salary closing date (for example, the 10th) registered in the closing date master 13. Then, the business operator operates the "variable allowance" button in this state.

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 storage control unit 22 displays the button “variable allowance” stored in the storage unit 2, FIG. Read out the above variable allowance data (salary portion) illustrated in . In step S12, the display control unit 24 displays a variable allowance/deduction input screen in which the variable allowance indicated by the read variable allowance data (salary portion) is automatically input, as shown in FIG.

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, the display control unit 24 determines the input items of the variable allowance data in the order of the transaction classification codes of the salary item master 12 in step S13, as shown in FIG.

Next, in step S14, the data generation unit 23 performs salary processing to generate salary data in which the basic salary and variable allowance are associated for each staff member, as shown in FIG. In the example in Figure 16, in the case of a staff member whose staff code is "1001", the basic salary is "100,000 yen", and the travel expenses of "50,000 yen" billed in May 2021 are for June 2021. This shows an example where the allowance is reflected in the salary. In addition, in the example in Figure 16, if the staff code is "3001", the basic salary is "300,000 yen", and the "30,000 yen" meal fee billed in May 2021 is for June 2021. This example shows an example where the payment is reflected in the salary of the employee.

As mentioned above, the variable allowance data (claimed portion) and variable allowance data (salary portion) are set up for the next month's salary items from 1 to 30, as shown in Figures 10(a) and 10(b). It is being Therefore, the salary data generated by the data generation unit 23 based on such variable allowance data also includes one or more requested variable allowances, as shown in FIG.

(Effects of embodiment)
As is clear from the above description, the salary calculation device 1 according to the embodiment can automatically slide and pay the variable allowance requested for the current month to the target employee's salary for the next month. As a result, for example, although a customer was billed for travel expenses, etc., variable allowances were not paid to the staff, and conversely, although variable allowances were paid to staff, claims were made to the customer. Inconveniences such as leakage can be prevented.

In addition, the variable allowance requested for the current month can be automatically slid and paid to the target employee's salary for the next month, so there is no need to increase the work burden on the business operator, and there are no inconveniences such as omissions in the payment of variable allowances to the above-mentioned staff. It is possible to perform payroll calculations that prevent such problems.

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

Furthermore, this embodiment can contribute to reducing waste loss and promoting paperless and electronic systems, making it possible to contribute to Goal 12, Goal 13, and Goal 15 of the SDGs.

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

[Other embodiments]
In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described 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 of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

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

Further, regarding the salary calculation device 1, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided in the payroll calculation device 1, especially the control unit 3 and each processing function performed by the control unit 3, are interpreted in whole or in part by a CPU (Central Processing Unit) and the CPU. It may be realized by a program to be executed, or may be realized by hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment. 1 mechanically read. That is, a storage unit such as a ROM or an HDD stores a computer program that cooperates with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes the control unit 3 in cooperation with the CPU.

Further, the payroll calculation program of this payroll calculation device 1 may be stored in another server device connected to the payroll calculation device 1 via any network, and all or part of it may be stored as necessary. It is also possible to download.

Further, the payroll calculation program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical Disk), DVD (Digital Versatile Disk), Blu-ray (registered trademark) Disc, etc. shall include any “portable physical medium”.

Furthermore, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in the payroll calculation device 1 shown in the embodiment, and the installation procedure after reading.

The storage 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 the like used for various processing and website provision. , stores files for web pages, etc.

Further, the payroll calculation device 1 may be configured with an information processing device such as a known personal computer device or a workstation, or may be configured with an information processing device to which arbitrary peripheral devices are connected. Further, the information processing device may be implemented by implementing software (including programs, data, etc.) that implements the processing described in this embodiment.

Furthermore, the specific form of dispersion/integration of devices is not limited to what is shown in the diagram, and all or part of the devices can be functionally or physically divided into arbitrary units according to various additions or additions of functions. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in payroll calculation operations for companies, temporary staffing companies, and the like.

1 Payroll calculation device 2 Storage 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 Project basic table 15 Contract work basic table 21 Input processing Section 22 Storage control section 23 Data generation section 24 Display control section

Claims (5)

a variable allowance data generation unit that generates variable allowance data to be paid with salary next time corresponding to the requested variable allowance and stores it in a storage unit;
a salary data generation unit that reads the variable allowance data from the storage unit and generates added salary data when generating salary data corresponding to the next time;
A payroll calculation device with The variable allowance data generation unit generates the variable allowance data including one or more requested variable allowances;
The payroll calculation device according to claim 1, characterized by: The salary data generation unit generates the salary data including one or more requested variable allowances;
The payroll calculation device according to claim 1 or 2, characterized in that: a variable allowance data generation step in which the variable allowance data generation unit generates variable allowance data to be paid with the salary next time corresponding to the requested variable allowance and stores it in the storage unit;
a salary data generation step in which the salary data generation unit reads the variable allowance data from the storage unit and generates added salary data when generating salary data corresponding to the next time;
Payroll calculation method with. computer,
a variable allowance data generation unit that generates variable allowance data to be paid with salary next time corresponding to the requested variable allowance and stores it in a storage unit;
functioning as a salary data generation unit that reads the variable allowance data from the storage unit and generates added salary data when generating salary data corresponding to the next time;
A payroll calculation program featuring:

Images