Salary calculation device, salary calculation method and salary calculation program

Abstract

To provide a salary calculation device, a salary calculation method and a salary calculation program for performing salary calculation in accordance with a change in a salary system within a salary calculation period.SOLUTION: In a salary calculation device, an employee data acquisition unit acquires change information of an employment condition within a salary calculation period, and acquires a basic salary before the change in the employment condition shown by the change information, amount information before the change in various allowances, a basic salary after the change in the employment condition and amount information after the change in the various allowances, an attendance data acquisition unit acquires attendance information during the salary calculation period, and a calculation processing unit divides the number of attendance days before the change in the employment condition by the number of calendar days to be multiplied by the amount information before the change and calculates a salary amount before the change, divides the number of attendance days after the change in the employment condition by the number of calendar days to be multiplied by the amount information after the change and calculates a salary amount after the change, calculates an overtime work amount corresponding to overtime work before and after the change in the employment condition from the amount information before the change and the attendance information, and adds the salary amount before the change, the overtime work amount before the change, the salary amount after the change and the overtime work amount after the change to calculate the total payment amount.SELECTED DRAWING: Figure 1

Description

Technical Field

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

Background Art

[0002] Today, in companies and the like, it is often the case that the salary of each employee is calculated using salary calculation software.

[0003] Patent Document 1 (Japanese Unexamined Patent Application Publication No. 2016-85750) discloses a salary calculation method that greatly simplifies salary calculation work for small and medium-sized enterprises and the like. In this salary calculation method, the total salary of all employees is displayed at the upper part of the display screen, and a summary of the salary details of each employee is displayed at the lower part. When a button such as "confirm the salary details for September" is clicked by a salary calculation person or the like, the salary of each employee is confirmed, and the flag of the record of the calculation result of each employee stored in the storage unit of the web server becomes a true value.

[0004] The salary calculation person can complete the salary calculation for each employee with only one click by calculating the salary of each employee for the current month using the previously recorded company information and employee information. Therefore, it is possible to reduce the burden of the complicated salary calculation work that was carried out by reflecting unique information for each employee.

[0005] Here, for example, in the dispatch industry, within a month, the dispatch destination of dispatched employees often changes, and the employment conditions also often change due to contract renewal or the like. At that time, not only the salary allowance but also the overtime rate changes within the month, so it is necessary to calculate the overtime allowance at multiple overtime rates within the month.

Prior Art Documents

Patent Documents

[0006]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0007] However, in the conventional salary system, it has been difficult to separately calculate overtime allowances before and after the unit price change at multiple overtime unit prices within the same month. Also, the working hours can only be held on a monthly total basis, and it has been difficult to separately hold the working hours before the unit price change and the working hours after the unit price change within the month.

[0008] Therefore, when a change in the salary system occurs during the salary calculation period such as within a week or within a month, it is necessary to manually calculate the salary including overtime pay, etc., which requires time-consuming work.

[0009] The present invention has been made in view of the above problems, and an object thereof is to provide a salary calculation device, a salary calculation method, and a salary calculation program that can easily perform salary calculation even when a change in the salary system occurs during the salary calculation period.

Means for Solving the Problems

[0010] In order to solve the above-described problems and achieve the object, a salary calculation device according to the present invention includes a change information acquisition unit that acquires change information on employment conditions during a salary calculation period, a basic amount acquisition unit that acquires pre-change basic salary and pre-change amount information on various allowances before the change of employment conditions indicated by the change information, and post-change basic salary and post-change amount information on various allowances after the change of employment conditions, an attendance information acquisition unit that acquires attendance information for the salary calculation period, a work portion salary calculation unit that calculates a pre-change salary amount corresponding to the work portion before the change of employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount corresponding to the work portion after the change of employment conditions based on the post-change amount information and the attendance information, an overtime calculation unit that calculates a pre-change overtime amount corresponding to the overtime portion before the change of employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount corresponding to the overtime portion after the change of employment conditions based on the post-change amount information and the attendance information, and a total payment amount calculation unit that adds up the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount to calculate the total payment amount of the salary for the salary calculation period. The work portion salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by a division value obtained by dividing the number of work days before the change of employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the post-change amount information by a division value obtained by dividing the number of work days after the change of employment conditions by the number of calendar days.

[0011] Also, in order to solve the above-described problems and achieve the object, a salary calculation method according to the present invention is a salary calculation method executed by a salary calculation device including a change information acquisition unit, a basic amount acquisition unit, an attendance information acquisition unit, a work portion salary calculation unit, an overtime calculation unit, and a total payment amount calculation unit. The change information acquisition unit performs a change information acquisition step of acquiring change information on employment conditions during a salary calculation period. The basic amount acquisition unit performs a basic amount acquisition step of acquiring pre-change basic salary and pre-change amount information on various allowances before the change in employment conditions indicated by the change information, and post-change basic salary and post-change amount information on various allowances after the change in employment conditions. The attendance information acquisition unit performs an attendance information acquisition step of acquiring attendance information for the salary calculation period. The work portion salary calculation unit performs a work portion salary calculation step of calculating a pre-change salary amount corresponding to the work portion before the change in employment conditions based on the pre-change amount information and the attendance information, and calculating a post-change salary amount corresponding to the work portion after the change in employment conditions based on the post-change amount information and the attendance information. The overtime calculation unit performs an overtime calculation step of calculating a pre-change overtime amount corresponding to the overtime portion before the change in employment conditions based on the pre-change amount information and the attendance information, and calculating a post-change overtime amount corresponding to the overtime portion after the change in employment conditions based on the post-change amount information and the attendance information. The total payment amount calculation unit performs a total payment amount calculation step of adding the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount to calculate the total payment amount of the salary for the salary calculation period. In the work portion salary calculation step, the pre-change salary amount is calculated by multiplying the pre-change amount information by a division value obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and the post-change salary amount is calculated by multiplying the post-change amount information by a division value obtained by dividing the number of working days after the change in employment conditions by the number of calendar days.

[0012] Also, in order to solve the above-described problems and achieve the object, the salary calculation program according to the present invention causes a computer to function as a change information acquisition unit for acquiring change information on employment conditions during a salary calculation period, a basic salary acquisition unit for acquiring pre-change salary information and various allowance pre-change amount information before the change of employment conditions indicated by the change information, and post-change salary information and various allowance post-change amount information after the change of employment conditions, an attendance information acquisition unit for acquiring attendance information for the salary calculation period, a work portion salary calculation unit for calculating a pre-change salary amount corresponding to the work portion before the change of employment conditions based on the pre-change amount information and the attendance information, and calculating a post-change salary amount corresponding to the work portion after the change of employment conditions based on the post-change amount information and the attendance information, an overtime calculation unit for calculating a pre-change overtime amount corresponding to the overtime portion before the change of employment conditions based on the pre-change amount information and the attendance information, and calculating a post-change overtime amount corresponding to the overtime portion after the change of employment conditions based on the post-change amount information and the attendance information, and a total payment amount calculation unit for adding the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount to calculate the total payment amount for the salary calculation period. The work portion salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by a division value obtained by dividing the number of work days before the change of employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the post-change amount information by a division value obtained by dividing the number of work days after the change of employment conditions by the number of calendar days.

Effect of the Invention

[0013] According to the present invention, even when a change occurs in the salary system during the salary calculation period, the salary can be easily calculated.

Brief Description of the Drawings

[0014]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Embodiments for Carrying Out the Invention

[0015] Hereinafter, a salary calculation device according to an embodiment to which the present invention is applied will be described in detail with reference to the drawings. The present invention is not limited by the following description of the embodiments.

[0016] [Hardware Configuration] First, FIG. 1 is a block diagram showing the hardware configuration of the salary calculation device 1 according to the embodiment. Although it is an example, this salary calculation device 1 is a salary calculation device that calculates the salary of each dispatched employee of a dispatching company. As the salary calculation device 1 of this embodiment, in addition to a desktop personal computer device, a notebook personal computer device or a tablet personal computer device can be used. Further, as the salary calculation device 1, a portable information processing device such as a PDA (Personal Digital Assistants) device or a smartphone can be used. Such a salary calculation device 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5.

[0017] An input device 6 and an output device 7 are connected to the input / output interface unit 5. As the output device 7, 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.

[0018] As the storage unit 2, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used. The storage unit 2 stores a personnel data system 11, a work data system 12, a salary calculation system 13, and a salary data system 14.

[0019] Each of the systems 11 to 14 is an application program that operates in relation to each other. In this example, the explanation will proceed on the assumption that each of the systems 11 to 14 is stored in the same storage unit 2. However, the personnel data system 11, the work data system 12, and the salary data system 14 may be physically stored in different server devices. In this case, the salary calculation device 1 and the server devices storing the systems 11, 12, and 14 are communicably connected to each other via the communication interface unit 4 and a predetermined network such as the Internet. Even with such a configuration, the same operational effects as those described below can be obtained. For details, refer to the following explanation.

[0020] The personnel data system 11 stores employee data including the employee numbers, dispatch start periods, dispatch end periods, dispatch destinations, and salary systems of each dispatched employee. The work data system 12 stores daily and monthly attendance data of each dispatched employee. The salary data system 14 stores the salary calculation result data of each dispatched employee calculated by the salary calculation system 13.

[0021] The control unit 3 realizes the functions of the employee data acquisition unit 21, the attendance data acquisition unit 22, the input processing unit 23, the arithmetic processing unit 24, and the memory control unit 25 by executing the salary calculation system 13, which is an application program stored in the storage unit 2.

[0022] The employee data acquisition unit 21 is an example of a change information acquisition unit and acquires employee data from the personnel data system 11. The attendance data acquisition unit 22 is an example of an attendance information acquisition unit and acquires daily and monthly attendance data from the work data system 12. The input processing unit 23 generates employment contract data by inputting and processing the standard unit price and overtime unit price, etc. of overtime pay before and after the change of the salary system within the month into the employee data in response to the input operation of the business operator who operates the salary calculation device 1. The employee data acquisition unit 21 and the input processing unit 23 are examples of a basic amount acquisition unit.

[0023] The arithmetic processing unit 24 calculates the salary of each dispatched employee based on employment contract data and work attendance data including the standard unit price and overtime unit price of overtime pay before and after the change of the salary system within a month. The arithmetic processing unit 24 is an example of a work-attendance salary calculation unit, an overtime calculation unit, and a total payment amount calculation unit. The memory control unit 25 transmits the salary calculation result data indicating the salary of each calculated dispatched employee to the salary data system for storage and control.

[0024] (Schematic flow of salary calculation process) Figure 2 is a schematic diagram showing such a flow of salary calculation processing. As shown in this Figure 2, the employee data of each dispatched employee collected from the personnel data system 11 includes the standard unit price and overtime unit price of overtime pay before and after the change of the salary system within a month. Thereby, employment contract data is generated. Also, from the work attendance information system 12, the daily work attendance data and monthly work attendance data of each dispatched employee are acquired as work attendance summary data.

[0025] The salary calculation system 13 generates salary calculation result data considering the salary systems before and after the change within a month for each dispatched employee based on the employment contract data and the work attendance summary data, and transmits this to the salary data system 14 for storage.

[0026] (Details of salary calculation process) Figure 3 is a flowchart showing such a flow of salary calculation processing. The control unit 3 executes each process shown in the flowchart of Figure 3 in order from step S1 by executing the salary calculation system stored in the storage unit 2.

[0027] First, in step S1, the employee data acquisition unit 21 acquires the employee data of the dispatched employee for whom salary calculation is to be performed from the personnel data system 11. In step S2, the input processing unit 23 generates employment contract data by inputting the standard unit price and overtime unit price of overtime pay before and after the change of the salary system within a month into the employee data in response to the input operation of the business operator.

[0028] Figure 4 shows an example of employment contract data. Among these, Figure 4(a) is an example of the employment contract data of contract employees on a monthly salary basis. Figure 4(b) is an example of the employment contract data of contract employees on an hourly wage basis. As shown in Figures 4(a) and 4(b), the employment contract data includes various data such as company number (Company No.), employee number, start date of the dispatch contract period, end date of the period, dispatch destination, salary classification, monthly scheduled hours, scheduled days, daily scheduled hours, basic salary, daily wage, hourly wage, job allowance, qualification allowance, standard unit price of overtime pay, and overtime unit price of overtime pay.

[0029] Among these, each data of employee number, start date of the dispatch contract period, end date of the period, and dispatch destination is data that is automatically input with respect to the employee data obtained from the personnel data system 11. The example of the monthly salary employee in Figure 4(a) shows that the company No. is "100", the employee number is "100", the start date of the dispatch contract period is "January 16, 2021", the end date of the period is "March 10, 2021", and the dispatch destination is the company "100231".

[0030] Also, the example of the monthly salary employee in Figure 4(a) shows an example where the contract employee with the employee number "100" had the dispatch period for the dispatch destination "100231" end on March 10, 2021 within March 2021, and the dispatch destination was changed to the company "2000011" starting from March 11, 2021 within the same March 2021.

[0031] Also, the example of the hourly wage employee in Figure 4(b) shows an example where the contract employee with the employee number "200" had the dispatch period for the dispatch destination "100231" end on March 10, 2021 within March 2021, and the dispatch destination was changed to the company "2000011" starting from March 11, 2021 within the same March 2021.

[0032] On the other hand, various data such as salary classification, monthly scheduled hours, scheduled days, daily scheduled hours, basic salary, daily wage, hourly wage, job allowance, qualification allowance, standard unit price of overtime pay, and overtime unit price of overtime pay are data that are manually input by the business operator.

[0033] The example of the monthly-paid employee in Fig. 4(a) shows that before the change of the dispatched destination, the monthly scheduled working hours are "160 hours", the scheduled number of days is "20 days", the daily scheduled working hours are "0 hours", the basic salary is "200,000 yen", the daily salary is "0 yen", the hourly wage is "0 yen", the job allowance is "40,000 yen", and the qualification allowance is "0 yen".

[0034] Also, after the change of the dispatched destination, it shows an example where the monthly scheduled working hours are "168 hours", the scheduled number of days is "20 days", the daily scheduled working hours are "0 hours", the basic salary is "300,000 yen", the daily salary is "0 yen", the hourly wage is "0 yen", the job allowance is "10,000 yen", and the qualification allowance is "20,000 yen".

[0035] Moreover, the example of the hourly-paid employee shown in Fig. 4(b) indicates that before the change of the dispatched destination, the hourly wage is "1,000 yen", and after the change of the dispatched destination, the hourly wage becomes "1,500 yen".

[0036] Next, in step S3 of the flowchart in Fig. 3, the business operator calculates and inputs the overtime standard unit price and the overtime unit price for the employment contract data. At this time, if both the overtime standard unit price and the overtime unit price before the change of the dispatched destination and those after the change of the dispatched destination are not input, the business operator inputs the overtime standard unit price and the overtime unit price for both before and after the change of the dispatched destination into the employment contract data. On the contrary, if the overtime standard unit price and the overtime unit price before the change of the dispatched destination have already been input and the overtime standard unit price and the overtime unit price after the change of the dispatched destination are not input, the business operator inputs the overtime standard unit price and the overtime unit price after the change of the dispatched destination into the employment contract data.

[0037] Fig. 5 is a diagram showing the employment contract data with the overtime standard unit price and the overtime unit price input before and after the change of the dispatched destination. Among them, Fig. 5(a) shows the employment contract data with the overtime standard unit price and the overtime unit price input for the employment contract data of the contract employee of the monthly-paid employee. Also, Fig. 5(b) shows the employment contract data with the overtime standard unit price and the overtime unit price input for the employment contract data of the contract employee of the hourly-paid employee.

[0038] As an example, in the case of a monthly salary employee, the base rate for overtime is calculated by performing the calculation of "(basic salary + job allowance + qualification allowance) / monthly scheduled working hours". Also, the overtime rate is calculated by multiplying the base rate by the legal overtime rate (1.25).

[0039] Therefore, in the example of the monthly salary employee in Fig. 5(a), before the change of the dispatching destination, by performing the calculation of "(200,000 yen + 40,000 yen) / 160 hours", a base rate of "1,500 yen" is calculated and input into the employment contract data. Also, by performing the calculation of "1,500 yen × 1.25", an overtime rate of "1,875 yen" is calculated and input into the employment contract data.

[0040] Also, in the example of the monthly salary employee in Fig. 5(a), after the change of the dispatching destination, by performing the calculation of "(300,000 yen + 10,000 yen + 20,000 yen) / 168 hours", a base rate of "1,965 yen" is calculated. Also, by performing the calculation of "1,965 yen × 1.25", an overtime rate of "2,457 yen" is calculated.

[0041] On the other hand, in the case of an hourly wage employee, the base rate for overtime is calculated by performing the calculation of "hourly wage × legal overtime rate (1.25)". Also, the late-night rate (overtime pay) is calculated by performing the calculation of "hourly wage × 0.25".

[0042] Therefore, in the example of the hourly wage employee in Fig. 5(b), before the change of the dispatching destination, by performing the calculation of "1,000 yen × 1.25", an overtime rate of "1,250 yen" is calculated and input into the employment contract data. Also, by performing the calculation of "1,000 yen × 0.25", a late-night rate of "250 yen" is calculated and input into the employment contract data.

[0043] Also, in the example of the hourly wage employee in Fig. 5(b), after the change of the dispatching destination, by performing the calculation of "1,500 yen × 1.25", an overtime rate of "1,875 yen" is calculated and input into the employment contract data. Also, by performing the calculation of "1,500 yen × 0.25", a late-night rate of "375 yen" is calculated and input into the employment contract data.

[0044] Next, in step S4 of the flowchart in FIG. 3, the attendance and leave data acquisition unit 22 acquires daily attendance and leave data and monthly attendance and leave data from the employment data system 12. FIG. 6 is a diagram showing an example of the daily attendance and leave data. As shown in this FIG. 6, the daily attendance and leave data is composed of company No., employee number, date, number of working days, number of rest and leave days, working hours, and overtime hours, etc. Although it is an example, in the case of the example in FIG. 6, from March 1st to March 10th are the daily attendance and leave data before the salary system change. Also, from March 11th to March 31st are the daily attendance and leave data after the salary system change.

[0045] Based on the daily attendance and leave data before the salary system change, the attendance and leave data acquisition unit 22 generates the attendance and leave aggregation data before the salary system change as shown in FIG. 7(a). Also, based on the daily attendance and leave data after the salary system change, the attendance and leave data acquisition unit 22 generates the attendance and leave aggregation data after the salary system change as shown in FIG. 7(b). As shown in FIG. 7(a) and FIG. 7(b), the attendance and leave aggregation data is composed of company No., employee number, start date of the assignment period, end date of the period, number of working days, number of rest and leave days, number of paid leave days, working hours, and overtime hours.

[0046] An example of the attendance and leave aggregation data before the salary system change shown in FIG. 7(a) is that the start date of the assignment period is "March 1, 2021", the end date of the assignment is "March 10, 2021", the number of working days during this period is "8 days", the number of rest and leave days is "0 days", the number of paid leave days is "2 days", the working hours are "64 hours", and the overtime hours are "9 hours".

[0047] Also, an example of the attendance and leave aggregation data after the salary system change shown in FIG. 7(b) is that the start date of the assignment period is "March 11, 2021", the end date of the assignment is "March 31, 2021", the number of working days during this period is "15 days", the number of rest and leave days is "1 day", the number of paid leave days is "0 days", the working hours are "114 hours", and the overtime hours are "2 hours".

[0048] In contrast, FIG. 8 is a diagram showing an example of monthly attendance data. As shown in this FIG. 8, the monthly attendance data is composed of company No., employee number, overtime hours exceeding 40 hours in the first week of the month, and overtime hours exceeding 40 hours in the second week of the month. Further, the monthly attendance data is composed of overtime hours exceeding 40 hours in the third week of the month, and overtime hours exceeding 40 hours in the fourth week of the month. Further, the monthly attendance data is composed of overtime hours exceeding 40 hours in the fifth week of the month, and monthly overtime hours.

[0049] The example of the monthly attendance data shown in this FIG. 8 shows an example where, before the change in the salary system, the overtime hours exceeding 40 hours in the second week of the month are "4 hours", the overtime hours exceeding 40 hours in the third week of the month are "2 hours", and the monthly overtime hours are "5 hours".

[0050] Further, the example of the monthly attendance data shown in FIG. 8 shows an example where, after the change in the salary system, the overtime hours exceeding 40 hours from the first week to the fifth week of the month are "0 hours", and the monthly overtime hours are also "0 hours".

[0051] Next, in step S5 of the flowchart in FIG. 3, when there is a change in the salary system during the week, the arithmetic processing unit 24 uses the higher overtime unit price between the overtime unit price before the change in the salary system and the overtime unit price after the change in the salary system to perform overtime calculation corresponding to the time exceeding the predetermined time of that week (overtime calculation exceeding the predetermined time within the week).

[0052] FIG. 9 is a flowchart showing the detailed flow of the overtime calculation operation exceeding the predetermined time within the week shown in this step S5. In the flowchart of this FIG. 9, when the processing proceeds from step S4 to step S11, the arithmetic processing unit 24 determines for each week whether overtime (overtime exceeding the predetermined time within the week) exceeding 40 hours has occurred based on the monthly attendance data shown in FIG. 8. If no overtime exceeding the predetermined time within the week has occurred (step S11: No), the processing directly proceeds to step S6 of the flowchart in FIG. 3.

[0053] On the other hand, when overtime work exceeding the specified time within a week occurs (step S11: Yes), the process proceeds to step S12. In step S12, the arithmetic processing unit 24 determines whether there is a change in the overtime rate due to a change in the salary system within the week in which the overtime work exceeding the specified time within the week has occurred.

[0054] The fact that there is no change in the overtime rate within the week (step S12: No) means that there is no change in the salary system or that the change in the salary system has no impact on the overtime calculation. Therefore, in step S13, the arithmetic processing unit 24 calculates the overtime allowance for overtime work exceeding the specified time within the week at the previous overtime rate. As a result, the process proceeds to step S6.

[0055] On the contrary, when there is a change in the overtime rate within the week (step S12: Yes), the arithmetic processing unit 24 calculates the overtime allowance for the overtime work exceeding the specified time of that week using the higher overtime rate among the overtime rates before and after the change in the salary system in step S14.

[0056] Specifically, for example, as shown in FIG. 10, within the week from March 8 (Sunday) to March 14 (Saturday), assume that the salary system changes on March 11 (Wednesday), and the overtime rate changes from "1875 yen" to "2475 yen" with March 11 (Wednesday) as the boundary. In this case, the arithmetic processing unit 24 calculates the overtime allowance for the overtime work exceeding the specified time within the week using the higher overtime rate of "2475 yen". This can prevent the inconvenience of calculating the overtime allowance at the lower overtime rate, which is disadvantageous to the dispatched employees.

[0057] Note that the arithmetic processing unit 24 performs the operation of calculating the overtime allowance for the overtime work exceeding the specified time within the week using the higher overtime rate only for the calculation of the overtime allowance of monthly paid employees.

[0058] Next, in the flowchart of FIG. 3, when such overtime calculation processing exceeding the predetermined time within a week is performed, the process proceeds to step S6. In step S6, when the overtime rate has changed due to a change in the salary system within that month, the arithmetic processing unit 24 performs monthly modified overtime calculation processing to calculate the overtime allowance for monthly overtime using the higher overtime rate.

[0059] FIG. 11 is a flowchart showing the detailed flow of the monthly modified overtime calculation processing shown in this step S6. In the flowchart of FIG. 11, when the process proceeds from step S5 to step S21, the arithmetic processing unit 24 determines whether monthly overtime hours have occurred based on the monthly attendance data shown in FIG. 8. If monthly overtime hours have not occurred (step S21: No), the process directly proceeds to step S7 in the flowchart of FIG. 3.

[0060] On the other hand, if monthly overtime hours have occurred (step S21: Yes), the process proceeds to step S22. In step S22, the arithmetic processing unit 24 determines whether the overtime rate has changed due to a change in the salary system within that month.

[0061] The fact that there is no change in the overtime rate within that month (step S22: No) means that there is no change in the salary system or that the change in the salary system has no impact on overtime calculation. Therefore, in step S23, the arithmetic processing unit 24 calculates the overtime allowance for monthly overtime using the previous overtime rate. As a result, the process proceeds to step S7.

[0062] In contrast, if there has been a change in the overtime rate within that month (step S22: Yes), in step S24, the arithmetic processing unit 24 calculates the overtime allowance for the monthly overtime of that month using the higher overtime rate among the overtime rates before and after the change in the salary system.

[0063] Specifically, for example, as shown in FIG. 12, within the month from March 1st (Sunday) to March 31st (Tuesday), assuming that the salary system changes on March 11th (Wednesday), the overtime rate changes from "1,875 yen" to "2,475 yen" with March 11th (Wednesday) as the boundary. In this case, the arithmetic processing unit 24 calculates the overtime allowance for monthly overtime within the month using the higher overtime rate of "2,475 yen". This can prevent the inconvenience that the overtime allowance for monthly overtime is calculated at the lower overtime rate, which is disadvantageous to dispatched employees.

[0064] Note that the arithmetic processing unit 24 performs the operation of calculating the overtime allowance for monthly overtime within the month using the higher overtime rate only for the calculation of the overtime allowance of monthly-paid employees.

[0065] Next, when such monthly modified overtime calculation processing is performed, the process proceeds to step S7 in the flowchart of FIG. 3. In step S7, the arithmetic processing unit 24 generates salary calculation data in which the calculation results of the above-mentioned overtime calculation processing exceeding the predetermined time within a week and the monthly modified overtime calculation processing are reflected in the above-mentioned employment contract data. Then, the arithmetic processing unit 24 generates salary calculation result data by adding the basic salary and overtime allowance before and after the emergency system change indicated by this salary calculation data. The memory control unit 25 performs memory control of this salary calculation result data in the salary data system 14.

[0066] FIG. 13 is a diagram showing an example of salary calculation data. Among them, FIG. 13(a) is an example of salary calculation data in the case of a monthly-paid employee, and FIG. 13(b) is an example of salary calculation data in the case of an hourly-paid employee.

[0067] In the case of the example of the monthly-paid employee in FIG. 13(a), the records in the upper column are the salary calculation data before the salary system change, and the records in the lower column are the salary calculation data after the salary system change.

[0068] The period before the salary system change is the period from March 1, 2021 to March 10, 2021. The arithmetic processing unit 24 calculates the basic salary for the period before the salary system change as "200,000 yen × (11 days / 31 days) = 70,968 yen" and the job allowance as "40,000 yen × (11 days / 31 days) = 14,194 yen". Also, the arithmetic processing unit 24 calculates the overtime allowance before the salary system change as "1,875 yen × 9 hours = 16,875 yen".

[0069] In contrast, the period after the salary system change is the period from March 11, 2021 to March 31, 2021. The arithmetic processing unit 24 calculates the basic salary for the period after the salary system change as "300,000 yen × (20 days / 31 days) = 193,549 yen" and the job allowance as "10,000 yen × (20 days / 31 days) = 6,452 yen". Also, the arithmetic processing unit 24 calculates the qualification allowance after the salary system change as "20,000 yen × (20 days / 31 days) = 12,904 yen" and the overtime allowance as "2,457 yen × 2 hours = 4,914 yen". Furthermore, the arithmetic processing unit 24 calculates the overtime allowance for overtime exceeding 40 hours per week using the higher overtime rate before and after the salary system change as "2,457 yen × 4 hours = 9,828 yen". Also, the arithmetic processing unit 24 calculates the monthly variable overtime allowance using the higher overtime rate before and after the salary system change as "2,457 yen × 5 hours = 12,285 yen".

[0070] Similarly, in the case of the hourly worker example in Fig. 13(b), the records in the upper column are the salary calculation data before the salary system change, and the records in the lower column are the salary calculation data after the salary system change.

[0071] The period before the salary system change is the period from March 1, 2021 to March 10, 2021. The arithmetic processing unit 24 calculates the basic salary for the period before the salary system change as "1,000 yen × 64 hours = 64,000 yen" and the outrageous overtime allowance as "1,250 yen × 9 hours = 11,250 yen".

[0072] In contrast, the period after the salary system change is from March 11, 2021 to March 31, 2021. The arithmetic processing unit 24 calculates the basic salary for the period after the salary system change as "1500 yen × 114 hours = 171000 yen" and calculates the excessive overtime allowance as "1875 yen × 2 hours = 3750 yen".

[0073] Next, the arithmetic processing unit 24 adds the basic salary and overtime allowance before and after the salary system change calculated in this way to generate salary calculation result data. FIG. 14 is a diagram showing an example of the salary calculation result data. Among them, FIG. 14(a) is a diagram showing an example of the salary calculation result data of a monthly salary employee, and FIG. 14(b) is a diagram showing an example of the salary calculation result data of an hourly wage employee.

[0074] By adding the basic salary and overtime allowance before and after the salary system change, in the case of a monthly salary employee, as shown in FIG. 14(a), the arithmetic processing unit 24 calculates the salary for March 2021 as the basic salary of "264517 yen", the job allowance of "20646 yen", the qualification allowance of "12904 yen", etc. Also, in the case of an hourly wage employee, the arithmetic processing unit 24 calculates the overtime allowance as "21789 yen", the overtime allowance for more than 40 hours per week as "9828 yen", the monthly variable overtime allowance as "12285 yen", etc.

[0075] By adding the basic salary and overtime allowance before and after the salary system change, in the case of an hourly wage employee, as shown in FIG. 14(b), the arithmetic processing unit 24 calculates the salary for March 2021 as the basic salary of "252000 yen", the job allowance of "15000 yen", etc.

[0076] The memory control unit 25 stores and controls such salary calculation result data in the salary data system 14. Thereby, all the processes in the flowchart of FIG. 3 are completed.

[0077] [Effects of the Embodiment] As is clear from the above description, the salary calculation device 1 of the embodiment holds a plurality of salary rates during the month as employment contract data, and also holds attendance data on a daily basis. As a result, even when the salary system changes within the same month, it is possible to automatically calculate various allowances including overtime pay separately before and after the change of the salary system. For this reason, even when the salary system changes, it is possible to easily perform salary calculations without requiring troublesome procedures, and the salary calculation time can be significantly shortened.

[0078] Also, for overtime that occurs weekly, such as overtime exceeding 40 hours per week, the overtime pay for that week is calculated using the higher overtime rate among the overtime rates within that week. Furthermore, for overtime that occurs monthly, such as monthly variable work, the monthly overtime pay is calculated using the higher overtime rate among the overtime rates within that month. This can prevent the situation where overtime exceeding 40 hours per week or monthly overtime is calculated at the lower overtime rate, resulting in an unreasonably low salary for employees such as dispatched workers.

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

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

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

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

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

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

[0085] Also, regarding the salary calculation device 1, each of the illustrated components is a functional concept and does not necessarily need to be physically configured as shown in the drawings.

[0086] For example, regarding the processing functions provided by the salary calculation device 1, particularly each processing function performed by the control unit 3 and the control unit 3, all or any part of them may be realized by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. The program includes non-temporary computer-readable instructions for causing an information processing device to execute the processes described in this embodiment and is recorded on a computer-readable recording medium. As needed, it is mechanically read by the tenant analysis device 1. That is, a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into the RAM and constitutes the control unit 3 in cooperation with the CPU.

[0087] Also, this tenant analysis program, which is a computer program, may be stored in another server device connected to the tenant analysis device 1 via an arbitrary network, and all or part of it can be downloaded as needed.

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

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

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

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

[0092] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or function additions. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0093] The present invention is useful for salary calculation when a change in the salary form occurs during the salary calculation period.

Explanation of Signs

[0094] 1 Salary calculation device 2 Storage unit 3 Control unit 4 Communication interface unit 5 Input / output interface unit 6 Input device 7 Output device 11 Personnel data system 12 Work data system 13 Salary calculation system 14 Salary data system 21 Employee data acquisition unit 22 Attendance data acquisition unit 23 Input processing unit 24 Arithmetic processing unit 25 Storage control unit

Claims

1. A change information acquisition unit that acquires change information on employment conditions during a salary calculation period; A basic salary amount acquisition unit that acquires information on the pre-change basic salary and various allowances before the change in employment conditions indicated by the change information, and information on the post-change basic salary and various allowances after the change in employment conditions; An attendance information acquisition unit that acquires attendance information for the salary calculation period; Based on the pre-change amount information and the attendance information, calculates a pre-change salary amount corresponding to the pre-change working hours of the employment conditions, and based on the post-change amount information and the attendance information, calculates a post-change salary amount corresponding to the post-change working hours of the employment conditions. A working hours salary calculation unit; Based on the pre-change amount information and the attendance information, calculates a pre-change overtime amount corresponding to the pre-change overtime hours of the employment conditions, and based on the post-change amount information and the attendance information, calculates a post-change overtime amount corresponding to the post-change overtime hours of the employment conditions. An overtime calculation unit; A total payment amount calculation unit that adds the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount to calculate the total salary payment amount for the salary calculation period, and is provided with: The working hours salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by a division value obtained by dividing the number of working days before the change in employment conditions by the calendar days, and calculates the post-change salary amount by multiplying the post-change amount information by a division value obtained by dividing the number of working days after the change in employment conditions by the calendar days. A salary calculation device characterized by the above.

2. The overtime calculation unit calculates the pre-change overtime amount using an overtime unit price calculated by dividing the pre-change amount information by a predetermined working time corresponding to the salary calculation period and multiplying by a coefficient defined for overtime, and calculates the post-change overtime amount using an overtime unit price calculated by dividing the post-change amount information by a predetermined working time corresponding to the salary calculation period and multiplying by a coefficient defined for overtime. The salary calculation device according to claim 1, characterized by the above.

3. The change information acquisition unit acquires the change information on the employment conditions of dispatched employees during the salary calculation period. The salary calculation device according to claim 1 or claim 2, characterized by the above.

4. A salary calculation method executed by a salary calculation device including a change information acquisition unit, a basic salary amount acquisition unit, an attendance information acquisition unit, a working hours salary calculation unit, an overtime calculation unit, and a total payment amount calculation unit. a change information acquisition step in which the change information acquisition unit acquires change information on employment conditions during a salary calculation period; a basic salary amount acquisition step in which the basic salary amount acquisition unit acquires pre-change basic salary and pre-change amount information on various allowances before the change in employment conditions indicated by the change information, and post-change basic salary and post-change amount information on various allowances after the change in employment conditions; an attendance information acquisition step in which the attendance information acquisition unit acquires attendance information for the salary calculation period; a workload salary calculation step in which the workload salary calculation unit calculates a pre-change salary amount corresponding to the workload before the change in employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount corresponding to the workload after the change in employment conditions based on the post-change amount information and the attendance information; an overtime calculation step in which the overtime calculation unit calculates a pre-change overtime amount corresponding to the overtime before the change in employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount corresponding to the overtime after the change in employment conditions based on the post-change amount information and the attendance information; a total payment amount calculation step in which the total payment amount calculation unit adds the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount to calculate the total payment amount of the salary for the salary calculation period, and in the workload salary calculation step, calculating the pre-change salary amount by multiplying the pre-change amount information by a division value obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and calculating the post-change salary amount by multiplying the post-change amount information by a division value obtained by dividing the number of working days after the change in employment conditions by the number of calendar days; A salary calculation method characterized by the above.

5. A computer, a change information acquisition unit that acquires change information on employment conditions during a salary calculation period; a basic salary amount acquisition unit that acquires pre-change basic salary and pre-change amount information on various allowances before the change in employment conditions indicated by the change information, and post-change basic salary and post-change amount information on various allowances after the change in employment conditions; an attendance information acquisition unit that acquires attendance information for the salary calculation period; a workload salary calculation unit that calculates a pre-change salary amount corresponding to the workload before the change in employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount corresponding to the workload after the change in employment conditions based on the post-change amount information and the attendance information; Based on the pre-change amount information and the attendance information, calculate a pre-change overtime amount corresponding to the overtime before the change of the employment conditions, and based on the post-change amount information and the attendance information, calculate a post-change overtime amount corresponding to the overtime after the change of the employment conditions, an overtime calculation unit; Function as a total payment amount calculation unit that adds the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount to calculate the total payment amount of the salary for the salary calculation period; The working hours salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by a division value obtained by dividing the number of working days before the change of the employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the post-change amount information by a division value obtained by dividing the number of working days after the change of the employment conditions by the number of calendar days; A salary calculation program characterized by the above.

Images