Payroll calculation device, payroll calculation method, and payroll calculation program

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

[Technical field]

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

[0002] Nowadays, for example, in the temp staffing industry, there are cases where a variable allowance such as travel expenses that an employee has paid in advance is billed to a client in the current month, and the same amount of the variable allowance is then added to the employee's salary the following month.

[0003] Regarding variable allowances, Patent Document 1 (JP Patent Publication 62-137659) 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 such information via the keyboard each time it occurs regardless of when the payroll is calculated. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Publication No. 137659 / 1983 Summary of the Invention [Problem to be solved by the invention]

[0005] However, in the past, 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, the business operator managed the amount of variable allowance etc. outside the system until the next 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, not billing clients for variable allowances paid to staff members. Such inconveniences can be prevented to some extent by matching billings and salaries for each client, but this is not desirable as it increases the workload of the business operator.

[0006] The present invention has been 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. [Means for solving the problem]

[0007] In order to solve the above problems and achieve the object, the payroll calculation device according to the present invention comprises: Generate variable allowance data indicating variable allowances which are allowances of transaction categories that have been claimed by the payroll closing date and whose claims are approved and whose claimed amounts fluctuate, and store the data in a storage unit A variable allowance data generating unit; The variable allowances claimed by the closing date are read from the memory unit and added to the salary corresponding to the closing date, which is calculated based on the closing date. The system has a salary data generating unit that generates salary data.

[0008] In order to solve the above problems and achieve the object, the payroll calculation method according to the present invention comprises: Generate variable allowance data indicating variable allowances which are allowances of transaction categories that have been claimed by the payroll closing date and whose claims are approved and whose claimed amounts fluctuate, and store the data in a storage unit A variable allowance data generating step and a salary data generating unit, The variable allowances claimed by the closing date are read from the memory unit and added to the salary corresponding to the closing date, which is calculated based on the closing date. The method includes a salary data generating step of generating salary data.

[0009] In order to solve the above problems and achieve the object, a payroll calculation program according to the present invention comprises: Generate variable allowance data indicating variable allowances which are allowances of transaction categories that have been claimed by the payroll closing date and whose claims are approved and whose claimed amounts fluctuate, and store the data in a storage unit A variable allowance data generating unit; The variable allowances claimed by the closing date are read from the memory unit and added to the salary corresponding to the closing date, which is calculated based on the closing date. It functions as a salary data generation unit that generates salary data. Effect of the Invention

[0010] The present invention makes it possible to perform payroll calculations that prevent oversights of claims and oversights of payments of variable allowances. [Brief description of the drawings]

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

[0012] 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.

[0013] (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 staff to companies and the like. This 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 the mouse device to realize a pointing device function can be used.

[0014] The storage unit 2 may be, for example, a read only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD). The storage unit 2 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.

[0015] The transaction category master 11 stores transaction category codes and transaction category names as shown in Fig. 2. The example in Fig. 2 indicates 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".

[0016] The salary item master 12 stores transaction category codes and transaction category names for variable allowances, as shown in Fig. 3. The example in Fig. 3 indicates 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".

[0017] The payroll closing date of the company or the like that uses the payroll calculation device 1 of the embodiment is stored in the payroll closing date master 13. In the example of Fig. 4, the "10th" of each month is registered as the payroll closing date.

[0018] The case basic table 14 stores the case number, contract period (start date: from), contract period (end date: to), customer code, and business content, as shown in FIG. 5. The example of FIG. 5 shows that the business with case number "100" is sales administration for a customer with customer code "T0001" and the contract period is "January 1, 2021 to March 31, 2022." The example of 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."

[0019] The constraint work basic table 15 stores contracted work numbers, case numbers, and staff codes. The example in Fig. 6 shows that the work with case number "100", which is sales administration for the customer with customer code "T0001" explained using Fig. 5, was contracted with contracted work number "1101" by a staff member (temporary employee) with staff code "1001". The example in Fig. 6 also shows that the work with case number "300", which is marketing administration for the customer with customer code "T0002" explained using Fig. 5, was contracted with contracted work number "3301" by a staff member (temporary employee) with staff code "3001".

[0020] (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.

[0021] The input processing unit 21 performs input processing corresponding to input operations 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.

[0022] (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 the payroll calculation device 1 in this embodiment 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.

[0023] First, when inputting 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 exemplified in Fig. 8. This roster input screen has a selection field for the attendance type, "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.

[0024] In the example of Figure 8, "claimed attendance" is selected as the attendance type 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 a staff code of "1001" and a case number of "100". The example of Figure 8 also shows that the claim month for the variable allowance is "May 2021" and the cutoff date for this month's payroll calculation is "the 31st".

[0025] In step S2 of the flowchart in FIG. 7, the display control unit 24 determines whether or not "billed attendance" is selected as the attendance type. If "paid 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 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.

[0026] When the operation of the "variable allowance" button 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 the staff as transportation expenses for a business trip as the next month's salary amount. In this case, the business operator selects "10: business trip expenses" as the transaction category (see FIG. 2) and "1: travel expenses" as the next month's salary item (see FIG. 3). Then, the business operator inputs the "50,000 yen" claimed by the staff as the next month's salary amount.

[0027] The input processing unit 21 acquires various data thus inputted 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 acquired various data (step S5). As shown in FIG. 10(a), the variable allowance data (billed amount) includes a closing date, a data category, a contract number, and a staff code. The variable allowance data (billed amount) also includes an allowance amount, a transaction category, a next month's salary item, and a next month's salary amount. The example of FIG. 10(a) is an example in which variable allowance data (billed amount) is generated based on various data inputted on the variable allowance / deduction input screen, with the data category being "1: billing", the allowance amount being "50,000 yen", the 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".

[0028] 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) which will be the next month's salary. The variable allowance data (salary amount) includes a closing date, a data category, a contract number, and a staff code, as illustrated in FIG. 10(b). The variable allowance data (salary amount) also includes an allowance amount, a transaction category, a next month's salary item, and a next month's salary amount. The example of FIG. 10(b) is an example in which variable allowance data (salary amount) is generated with a data category of "2: salary" and an allowance amount of "50,000 yen" 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.

[0029] As shown in Fig. 10(a) and Fig. 10(b), the variable allowance data (billed amount) and the variable allowance data (salary amount) have next month salary items "1 to 30", and although this is only an example, variable allowances can be input for up to 30 items. As a result, variable allowance data including one or more billed variable allowances is generated by the data generation unit 23.

[0030] 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, "No" is determined in step S2 of the flowchart in Fig. 7, and the process proceeds to step S11 in Fig. 11.

[0031] 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 and 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 (for example, the 10th) registered in the salary closing date master 13 shown in Fig. 4 as the salary closing date. Then, in this state, the business operator operates the "Variable Allowance" button.

[0032] 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 / 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.

[0033] The example of 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 determines the input items of the variable allowance data in the order of the transaction classification codes of the salary item master 12, as shown in Fig. 15.

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

[0035] As described above, the variable allowance data (billed amount) and the variable allowance data (salary amount) have next month salary items "1 to 30" as shown in Fig. 10(a) and Fig. 10(b). Therefore, the salary data generated by the data generating unit 23 based on such variable allowance data also becomes salary data including one or more claimed variable allowances as shown in Fig. 16.

[0036] (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.

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

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

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

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

[0041] [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.

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

[0043] 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.

[0044] Furthermore, with regard to the payroll calculation device 1, the components shown in the figures are merely functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0045] 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 containing 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 for giving instructions to the CPU in cooperation with the OS and performing various processing is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into the RAM, and cooperates with the CPU to form the control unit 3.

[0046] In addition, 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 it is also possible to download all or part of it as needed.

[0047] 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.

[0048] Furthermore, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works in cooperation with a separate program, such as an OS, to achieve its function. Note that well-known configurations and procedures can be used for the specific configuration 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.

[0049] 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.

[0050] 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 be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

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

[0052] The present invention is useful for payroll calculation work in companies, temporary staffing agencies, and the like. [Explanation of symbols]

[0053] 1 Payroll calculation device 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Transaction classification master 12 Payroll item master 13 Payroll Closing Date Master 14 Case Basic Table 15 Basic table for sales work 21 Input processing section 22 Memory control unit 23 Data Generation Division 24 Display control section

Claims

1. A variable allowance data generating unit that generates variable allowance data indicating a variable allowance that is claimed by the payroll closing date and is a transaction category allowance for which the claim is approved and whose claim amount fluctuates, and stores the data in a storage unit; a payroll data generating unit that generates payroll data by reading out from the storage unit the variable allowance claimed by the payroll closing date and adding it to the payroll corresponding to the payroll closing date, the variable allowance being calculated based on the payroll closing date; A payroll calculation device having the above structure.

2. 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 .

3. 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

4. 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:

5. 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