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

Abstract

To make it possible to easily execute salary calculation even when there is a change of a salary system in a salary calculation period.SOLUTION: A change information acquisition unit acquires change information of an employment condition in a salary calculation period. A base salary acquisition unit acquires the base salary before change of the employment condition shown by the change information, before-change amount information of various benefits, and after-change amount information of the base salary and benefits after change of the employment condition. An attendance information acquisition unit acquires attendance information for the salary calculation period. An attendance salary calculation unit calculates the respective salary amounts equivalent to attendances before and after change of the employment condition on the basis of the before-change amount information and the attendance information. An overtime work calculation unit calculates the respective overtime work amounts equivalent to overtime works before and after change of the employment condition on the basis of the before-change amount information and the attendance information. A total supply amount calculation unit adds the before-change salary amount, the before-change overtime work amount, the after-change salary amount, and the after-change overtime work salary amount and calculates the total supply amount of the salary in the salary calculation period.SELECTED DRAWING: Figure 9

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, companies often use payroll software to calculate the payroll of each employee.

[0003] Patent Document 1 (JP Patent Publication No. 2016-85750) discloses a payroll calculation method that greatly simplifies payroll calculation procedures for small and medium-sized enterprises. This payroll calculation method displays the total salary of all employees in the upper section of the display screen, and displays a summary of each employee's pay slip in the lower section. When a payroll calculation clerk clicks a button such as "Confirm September pay slip," the salary of each employee is confirmed, and the flag of the calculation result record for each employee stored in the memory unit of the web server becomes true.

[0004] Payroll staff can use pre-recorded company and employee information to calculate the payroll of each employee for that month, and complete the calculation with just one click. This reduces the burden of complex payroll calculation work that previously required reflecting unique information for each employee.

[0005] For example, in the temp staffing industry, the dispatch destination of a temp staff member often changes during the month, and the employment conditions change due to contract renewal, etc. In such cases, not only the salary allowance but also the overtime rate changes during the month, so it is necessary to calculate the overtime allowance at multiple overtime rates during the month. [Prior art documents] [Patent documents]

[0006] [Patent Document 1] JP 2016-85750 A Summary of the Invention [Problem to be solved by the invention]

[0007] However, in the conventional payroll system, it was difficult to calculate overtime allowances separately for multiple overtime rates within the same month, including before and after the rate change.In addition, working hours could only be recorded as a monthly total, making it difficult to record working hours before and after the rate change separately within the same month.

[0008] Therefore, if a change occurred in the payroll system during a payroll calculation period, such as within a week or month, payroll calculations including overtime pay had to be done manually, which was time-consuming work.

[0009] 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 can easily perform payroll calculations even if changes occur in the payroll system during the payroll calculation period. [Means for solving the problem]

[0010] In order to solve the above-mentioned problems and achieve the object, the payroll calculation device according to the present invention includes a change information acquisition unit that acquires change information on employment conditions during a payroll calculation period, a basic amount acquisition unit that acquires pre-change amount information on basic salary and various allowances before the change in the employment conditions indicated by the change information, and post-change amount information on basic salary and various allowances after the change in the employment conditions, an attendance information acquisition unit that acquires attendance information for the payroll calculation period, a work portion payroll calculation unit that calculates a pre-change salary amount equivalent to the amount of work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount equivalent to the amount of work after the change in the employment conditions based on the post-change amount information and the attendance information, an overtime calculation unit that calculates a pre-change overtime amount equivalent to the amount of overtime work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount equivalent to the amount of overtime work after the change in the employment conditions based on the post-change amount information and the attendance information, and a total pay 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 a total pay amount of salary for the payroll calculation period. When the payroll calculation period is on a monthly basis, the overtime calculation unit calculates the overtime amount for the week in which the employment conditions were changed and the overtime pay for the month in which the employment conditions were changed by using the higher overtime unit price between the overtime unit price before the change in employment conditions and the overtime unit price after the change in employment conditions.

[0011] In order to solve the above problems and achieve the object, the payroll calculation method according to the present invention comprises: A payroll calculation method executed by a payroll calculation device including a change information acquisition unit, a basic amount acquisition unit, an attendance information acquisition unit, a working wage calculation unit, an overtime calculation unit, and a total pay calculation unit, A change information acquisition step in which a change information acquisition unit acquires change information on employment conditions during a payroll calculation period; a basic amount acquisition step in which a basic amount acquisition unit acquires pre-change amount information of the basic salary and various allowances before the change in the employment conditions indicated by the change information and post-change amount information of the basic salary and various allowances after the change in the employment conditions; an attendance information acquisition step in which an attendance information acquisition unit acquires attendance information for the payroll calculation period; and a work portion salary calculation unit calculates a pre-change salary amount equivalent to the work portion before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates the post-change amount information and the attendance information. a work-per-hour salary calculation step for calculating a post-change salary amount equivalent to the amount of work after the change in the employment conditions based on the information; an overtime calculation step for calculating a pre-change overtime amount equivalent to the amount of overtime work before the change in the employment conditions based on the pre-change amount information and attendance information, and calculating a post-change overtime amount equivalent to the amount of overtime work after the change in the employment conditions based on the post-change amount information and attendance information; and a total payment calculation step for calculating a total payment amount of salary for the salary calculation period by adding the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount. and in the overtime calculation step, when the payroll calculation period is on a monthly basis, the overtime unit price before the change in employment conditions and the overtime unit price after the change in employment conditions, whichever is higher, is used to calculate the overtime amount for the week in which the change in employment conditions occurred and the overtime pay for the month in which the change in employment conditions occurred.

[0012] Further, in order to solve the above-mentioned problems and achieve the object, a payroll calculation program according to the present invention includes a computer including: a change information acquisition unit that acquires change information on employment conditions during a payroll calculation period; a basic amount acquisition unit that acquires pre-change amount information on basic salary and various allowances before the change in the employment conditions indicated by the change information, and post-change amount information on basic salary and various allowances after the change in the employment conditions; an attendance information acquisition unit that acquires attendance information for the payroll calculation period; a work portion payroll calculation unit that calculates a pre-change salary amount equivalent to the amount of work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount equivalent to the amount of work after the change in the employment conditions based on the post-change amount information and the attendance information; an overtime calculation unit that calculates a pre-change overtime amount equivalent to the amount of overtime work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount equivalent to the amount of overtime work after the change in the employment conditions based on the post-change amount information and the attendance information; and a total pay 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 a total pay amount of salary for the payroll calculation period. When the payroll calculation period is on a monthly basis, the overtime calculation unit calculates the overtime amount for the week in which the employment conditions were changed and the overtime pay for the month in which the employment conditions were changed, using the higher of the overtime rate before the change in employment conditions and the overtime rate after the change in employment conditions. Effect of the Invention

[0013] According to the present invention, even if a change occurs in the pay system during the pay calculation period, pay calculation can be easily performed. [Brief description of the drawings]

[0014] [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 schematic diagram showing the flow of a payroll calculation process in the payroll calculation device of the embodiment. [Diagram 3] FIG. 3 is a flowchart showing the flow of the payroll calculation process of the payroll calculation device according to the embodiment. [Figure 4] FIG. 4 is a diagram showing an example of employment contract data. [Diagram 5] FIG. 5 is a diagram showing an example of employment contract data in which the base unit price of overtime pay and the unit price of overtime work are input. [Figure 6] FIG. 6 is a diagram showing an example of date and time attendance data. [Figure 7] FIG. 7 is a diagram showing an example of attendance compilation data formed based on date and time attendance data. [Figure 8] FIG. 8 is a diagram showing an example of monthly attendance data. [Figure 9] FIG. 9 is a flowchart showing the flow of a process for calculating overtime work in excess of a predetermined weekly time by the calculation processing unit of the payroll calculation device. [Figure 10] FIG. 10 is a diagram for explaining the operation of calculating the weekly prescribed hour excess overtime allowance using the higher overtime unit price when the calculation processing unit performs the weekly prescribed hour excess overtime calculation process. [Figure 11] FIG. 11 is a flowchart showing the flow of monthly variable overtime calculation processing by the calculation processing unit of the payroll calculation device. [Figure 12] FIG. 12 is a diagram for explaining the operation of calculating the monthly overtime allowance using the higher overtime unit price when the calculation processing unit performs the monthly variable overtime calculation process. [Figure 13] FIG. 13 is a diagram illustrating an example of the payroll calculation data. [Figure 14] FIG. 14 is a diagram showing an example of the salary calculation result data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0015] A payroll calculation device according to an embodiment of the present invention will be described in detail below with reference to the drawings. The present invention is not limited to the following embodiment.

[0016] [Hardware configuration] First, FIG. 1 is a block diagram showing the hardware configuration of a salary calculation device 1 according to an embodiment. As an example, this salary calculation device 1 is a salary calculation device that calculates the salary of each temporary employee of a temp agency. As the salary calculation device 1 according to this embodiment, in addition to a desktop personal computer, a notebook personal computer or a tablet personal computer can be used. As the salary calculation device 1, a PDA (Personal Digital Assistants) device or a portable information processing device such as a smartphone can be used. Such a 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.

[0017] An input device 6 and an output device 7 are connected to the input / output interface unit 5. A monitor device (including a home television) can be used as the output device 7. As the input device 6, a keyboard device, a mouse device, a microphone device, and / or a monitor device that cooperates with a mouse device to realize a pointing device function can be used.

[0018] A storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), a HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used as the storage unit 2. A personnel data system 11, an employment data system 12, a payroll calculation system 13, and a payroll data system 14 are stored in the storage unit 2.

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

[0020] The personnel data system 11 stores employee data including the employee number, dispatch start period, dispatch end period, dispatch destination, pay system, etc. of each dispatched employee. The employment data system 12 stores daily attendance data and monthly attendance data of each dispatched employee. The payroll data system 14 stores payroll calculation result data for each dispatched employee calculated by the payroll calculation system 13.

[0021] The control unit 3 realizes each of the functions of an employee data acquisition unit 21, an attendance data acquisition unit 22, an input processing unit 23, an arithmetic processing unit 24 and a memory control unit 25 by executing a payroll calculation system 13, which is an application program stored in the memory 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 date and time attendance data and monthly attendance data from the work data system 12. The input processing unit 23 generates employment contract data by inputting the base unit price and overtime unit price of overtime pay before and after a change in the salary system within a month into the employee data in response to an input operation by a business operator who operates the payroll 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 calculation processing unit 24 calculates the salary of each temporary employee based on the employment contract data and attendance data, including the base unit price of overtime pay and the overtime unit price before and after the change in the salary system within the month. The calculation processing unit 24 is an example of a work salary calculation unit, an overtime calculation unit, and a total payment calculation unit. The memory control unit 25 transmits the salary calculation result data indicating the calculated salary of each temporary employee to the salary data system and controls the storage.

[0024] (Overview of payroll processing) Figure 2 is a schematic diagram showing the flow of such payroll calculation processing. As shown in this figure, the base unit price and overtime unit price of overtime pay before and after the change in the pay system during the month are input into the employee data of each temporary worker collected from the personnel data system 11. This generates employment contract data. In addition, daily attendance data and monthly attendance data of each temporary worker are obtained from the employment information system 12 as attendance compilation data.

[0025] The payroll calculation system 13 generates payroll calculation result data that takes into account the pay systems before and after the change within a month for each temporary employee based on the employment contract data and attendance data, and transmits this data to the payroll data system 14 for storage.

[0026] (Payroll Processing Details) Fig. 3 is a flowchart showing the flow of such a payroll calculation process. The control unit 3 executes the payroll calculation system stored in the storage unit 2, thereby executing each process shown in the flowchart of Fig. 3 in order, starting from step S1.

[0027] First, in step S1, the employee data acquisition unit 21 acquires employee data of the temporary employee who will be performing the payroll calculation from the personnel data system 11. In step S2, the input processing unit 23 generates employment contract data by inputting the base unit price and overtime unit price of overtime pay before and after the change in the pay system within the month into the employee data in response to the input operation of the business operator.

[0028] An example of employment contract data is shown in Figure 4. Of these, Figure 4(a) is an example of employment contract data for a monthly salaried contract employee. Figure 4(b) is an example of employment contract data for an hourly wage contract employee. As shown in Figures 4(a) and 4(b), the employment contract data includes various data such as company number, employee number, start date and end date of the dispatch contract, dispatch destination, salary category, monthly designated hours, designated number of days, daily designated hours, basic salary, daily wage, hourly wage, job salary, qualification allowance, base unit price for overtime pay, and overtime unit price for overtime pay.

[0029] Of these, the employee number, start date and end date of the dispatch contract, and dispatch destination are data that are automatically input to the employee data obtained from the personnel data system 11. The example of a salaried employee in Figure 4(a) indicates that the company number is "100", the employee number is "100", the dispatch contract start date is "January 16, 2021", the end date is "March 10, 2021", and the dispatch destination is company "100231".

[0030] In addition, the example of a salaried employee in Figure 4(a) shows that a contract employee with employee number "100" had his / her dispatch period to dispatch company "100231" end on March 10th in March 2021, and then changed his / her dispatch period to company "2000011" on March 11th in the same March 2021.

[0031] In addition, the example of an hourly wage worker in Figure 4(b) shows that a contract employee with employee number "200" had his / her dispatch period to dispatch company "100231" end on March 10th in March 2021, and then changed his / her dispatch company to company "2000011" on March 11th in the same month of 2021.

[0032] In contrast, various data such as salary category, specified hours per month, specified number of days, specified hours per day, basic salary, daily wage, hourly wage, job-related pay, qualification allowance, base unit price for overtime pay, and overtime unit price for overtime pay are data that are manually entered by the business operator.

[0033] The example of a salaried worker in Figure 4(a) shows that before the change in dispatch destination, the monthly scheduled hours were "160 hours," the scheduled number of days was "20 days," the daily scheduled hours were "0 hours," the basic salary was "200,000 yen," the daily wage was "0 yen," the hourly wage was "0 yen," the job salary was "40,000 yen," and the qualification allowance was "0 yen."

[0034] In addition, after the dispatch destination is changed, the example shows that the monthly scheduled hours are "168 hours," the scheduled number of days is "20 days," the daily scheduled hours are "0 hours," the basic salary is "300,000 yen," the daily wage is "0 yen," the hourly wage is "0 yen," the job salary is "10,000 yen," and the qualification allowance is "20,000 yen."

[0035] In addition, the example of an hourly wage worker shown in Figure 4(b) shows that before the dispatch destination was changed, the hourly wage was "1,000 yen," and after the dispatch destination was changed, the hourly wage became "1,500 yen."

[0036] Next, in step S3 of the flowchart in Fig. 3, the task operator calculates and inputs the base unit price and overtime unit rate of overtime work into the employment contract data. At this time, if both the base unit price and overtime unit rate of overtime work before the change of the dispatch destination and the base unit price and overtime unit rate of overtime work after the change of the dispatch destination have not been input, the task operator inputs the base unit price and overtime unit rate of overtime work both before and after the change of the dispatch destination into the employment contract data. On the other hand, if the base unit price and overtime unit rate of overtime work before the change of the dispatch destination have already been input and the base unit price and overtime unit rate of overtime work after the change of the dispatch destination have not been input, the task operator inputs the base unit price and overtime unit rate of overtime work after the change of the dispatch destination into the employment contract data.

[0037] Fig. 5 shows employment contract data in which the base unit price and overtime unit price for overtime work before and after a change in dispatch destination have been input. Of these, Fig. 5(a) shows employment contract data in which the base unit price and overtime unit price for overtime work have been input for the employment contract data of a monthly salaried contract employee. Also, Fig. 5(b) shows employment contract data in which the base unit price and overtime unit price for overtime work have been input for the employment contract data of an hourly wage contract employee.

[0038] For example, in the case of a monthly salary employee, the base unit price for overtime is calculated by calculating "(basic salary + job salary + qualification allowance) / monthly designated hours." The overtime unit price is also calculated by multiplying the base unit price by the statutory premium rate (1.25).

[0039] For this reason, in the example of a salaried worker in Figure 5(a), before the change of dispatch destination, a base unit price of "1,500 yen" is calculated by the calculation of "(200,000 yen + 40,000 yen) / 160 hours" and entered into the employment contract data. Also, an overtime unit price of "1,875 yen" is calculated by the calculation of "1,500 yen x 1.25" and entered into the employment contract data.

[0040] In the example of a salaried worker in Figure 5(a), after the dispatch destination is changed, the base unit price is calculated as "1,965 yen" by calculating "(300,000 yen + 10,000 yen + 20,000 yen) / 168 hours." In addition, the overtime unit price is calculated as "2,457 yen" by calculating "1,965 yen x 1.25."

[0041] In contrast, for hourly wage workers, the standard unit price for overtime is calculated by multiplying the hourly wage by the statutory premium rate (1.25). Also, the night-time unit price (premium pay) is calculated by multiplying the hourly wage by 0.25.

[0042] For this reason, in the example of the hourly wage worker in Figure 5(b), before the change of dispatch destination, the overtime rate of "1250 yen" is calculated by the calculation of "1000 yen x 1.25" and entered into the employment contract data. Also, the night-time rate of "250 yen" is calculated by the calculation of "1000 yen x 0.25" and entered into the employment contract data.

[0043] In the example of the hourly wage worker in Figure 5(b), after the dispatch destination is changed, the overtime rate of "1,875 yen" is calculated by the calculation of "1,500 yen x 1.25" and entered into the employment contract data. Also, the night-time rate of "375 yen" is calculated by the calculation of "1,500 yen x 0.25" and entered into the employment contract data.

[0044] Next, in step S4 of the flowchart in FIG. 3, the attendance data acquisition unit 22 acquires daily attendance data and monthly attendance data from the work data system 12. FIG. 6 is a diagram showing an example of daily attendance data. As shown in FIG. 6, the daily attendance data includes company number, employee number, date, number of working days, number of holidays, working hours, and overtime hours. In the example of FIG. 6, which is just one example, the daily attendance data from March 1st to March 10th is the data before the salary system change. Also, the daily attendance data from March 11th to March 31st is the data after the salary system change.

[0045] The attendance data acquisition unit 22 generates attendance summary data before the salary system change, as shown in Fig. 7(a), based on the daily attendance data before the salary system change. Also, the attendance data acquisition unit 22 generates attendance summary data after the salary system change, as shown in Fig. 7(b), based on the daily attendance data after the salary system change. As shown in Fig. 7(a) and Fig. 7(b), the attendance summary data includes the company number, employee number, start date and end date of the dispatch period, number of working days, number of holidays, number of paid holidays, working hours, and overtime hours.

[0046] In an example of attendance compilation data before the change in the salary system shown in Figure 7(a), the dispatch start date for the dispatch period is "March 1, 2021," the dispatch end date is "March 10, 2021," the number of working days during this period is "8 days," the number of holidays is "0 days," the number of paid holidays is "2 days," the working hours are "64 hours," and the overtime hours are "9 hours."

[0047] In addition, an example of attendance compilation data after the change in the salary system shown in Figure 7 (b) shows that the start date of the dispatch period is "March 11, 2021", the end date of the dispatch period is "March 31, 2021", the number of working days during this period is "15 days", the number of holidays is "1 day", the number of paid holidays 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 Fig. 8, the monthly attendance data includes company number, 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. The monthly attendance data also includes 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. The monthly attendance data also includes overtime hours exceeding 40 hours in the fifth week of the month, and monthly overtime hours.

[0049] The example of monthly attendance data shown in Figure 8 indicates that before the change in the salary system, overtime hours exceeding 40 hours in the second week of the month were "4 hours," overtime hours exceeding 40 hours in the third week of the month were "2 hours," and monthly overtime hours were "5 hours."

[0050] In addition, the example of monthly attendance data shown in Figure 8 shows that after the salary system change, overtime hours exceeding 40 hours in the first through fifth weeks of the month are recorded as "0 hours," and monthly overtime hours are also recorded as "0 hours."

[0051] Next, in step S5 of the flowchart in FIG. 3, when the salary system is changed within a week, the calculation processing unit 24 uses the higher of the overtime unit price before the salary system change and the overtime unit price after the salary system change to calculate the overtime corresponding to the hours that exceed the specified hours for that week (calculation of overtime in excess of the specified hours within a week).

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

[0053] On the other hand, if overtime work exceeding the predetermined weekly hours has occurred (step S11: Yes), the process proceeds to step S12. In step S12, the calculation processing unit 24 determines whether or not the overtime rate has changed due to a change in the pay system during the week in which the overtime work exceeding the predetermined weekly hours has occurred.

[0054] No change in the weekly overtime unit price (step S12: No) means that there is no change in the salary system, or the change in the salary system does not affect the overtime calculation. Therefore, in step S13, the calculation processing unit 24 calculates the overtime allowance for overtime work exceeding the specified hours in a week at the previous overtime unit price. Then, the process proceeds to step S6.

[0055] On the other hand, if there is a change in the overtime rate within the week (step S12: Yes), in step S14, the calculation processing unit 24 calculates the overtime pay for work that exceeds the specified hours for that week using the higher overtime rate before and after the change in the salary system.

[0056] Specifically, for example, as shown in FIG. 10, during the week of March 8 (Sun) to March 14 (Sat), the salary system is changed on March 11 (Wed), and the overtime unit price changes from "1,875 yen" to "2,475 yen" on March 11 (Wed). In this case, the calculation processing unit 24 calculates the overtime allowance for the specified hours within the week using the higher overtime unit price of "2,475 yen". This prevents the inconvenience of the overtime allowance being calculated using the lower overtime unit price, which is the overtime unit price that is disadvantageous to the dispatched employee.

[0057] The calculation processing unit 24 performs the operation of calculating the overtime allowance for work exceeding a predetermined number of hours within a week using the higher overtime unit price only for calculation of overtime allowance for salaried employees.

[0058] Next, in the flowchart of Fig. 3, when such a calculation process for overtime work exceeding a predetermined time within a week is performed, the process proceeds to step S6. In step S6, the calculation processing unit 24 performs a monthly variable overtime calculation process to calculate the overtime pay for monthly overtime work using the higher overtime unit price if the overtime unit price has changed due to a change in the salary system within the month.

[0059] Fig. 11 is a flowchart showing the detailed flow of the monthly variable overtime calculation process shown in step S6. In the flowchart of Fig. 11, when the process proceeds from step S5 to step S21, the calculation processing unit 24 determines whether or not 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 proceeds directly to step S7 in the flowchart of Fig. 3.

[0060] On the other hand, if monthly overtime work has occurred (step S21: Yes), the process proceeds to step S22. In step S22, the calculation processing unit 24 determines whether or not a change in the overtime unit price has occurred during the month due to a change in the salary system.

[0061] If the overtime unit price for that month has not changed (step S22: No), this means that there is no change in the salary system, or that the change in the salary system has no effect on the overtime calculation. Therefore, in step S23, the calculation processing unit 24 calculates the overtime allowance for the monthly overtime work using the previous overtime unit price. This causes the process to proceed to step S7.

[0062] On the other hand, if there has been a change in the overtime unit price within that month (step S22: Yes), in step S24, the calculation processing unit 24 calculates the overtime pay for the monthly overtime work using the higher overtime unit price before and after the change in the salary system.

[0063] Specifically, for example, as shown in FIG. 12, during the month from March 1 (Sun) to March 31 (Tue), the salary system is changed on March 11 (Wed), and the overtime unit price changes from "1,875 yen" to "2,475 yen" on March 11 (Wed). In this case, the calculation processing unit 24 calculates the overtime allowance for monthly overtime work within the month using the higher overtime unit price of "2,475 yen". This makes it possible to prevent the inconvenience of monthly overtime allowance being calculated using the lower overtime unit price, which is the overtime unit price that is disadvantageous to the dispatched employee.

[0064] The calculation processing unit 24 performs the operation of calculating the overtime allowance for monthly overtime work within a month using the higher overtime unit price only for calculation of overtime allowance for salaried employees.

[0065] Next, once such monthly variable overtime calculation processing has been performed, processing proceeds to step S7 in the flowchart of Fig. 3. In step S7, the calculation processing unit 24 generates payroll calculation data that reflects the calculation results of the above-mentioned weekly overtime calculation processing and monthly variable overtime calculation processing in the employment contract data. The calculation processing unit 24 then generates payroll calculation result data by adding the basic salary and overtime allowance before and after the emergency system change, which are shown in this payroll calculation data. The memory control unit 25 controls the storage of this payroll calculation result data in the payroll data system 14.

[0066] Fig. 13 is a diagram showing an example of salary calculation data, in which Fig. 13(a) is an example of salary calculation data for a monthly salaried employee, and Fig. 13(b) is an example of salary calculation data for an hourly wage employee.

[0067] In the example of a salaried employee in FIG. 13(a), the records in the top row are the payroll calculation data before the change in the pay system, and the records in the bottom row are the payroll calculation data after the change in the pay system.

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

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

[0070] Similarly, in the example of an hourly wage employee in FIG. 13(b), the records in the top column are the payroll calculation data before the pay system change, and the records in the bottom column are the payroll calculation data after the pay system change.

[0071] The period before the salary system change is the period from March 1, 2021 to March 10, 2021. The calculation processing unit 24 calculates the basic salary for the period before the salary system change as "1,000 yen x 64 hours = 64,000 yen" and calculates the excessive overtime allowance as "1,250 yen x 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 calculation processing unit 24 calculates the basic salary for the period after the salary system change as "1,500 yen x 114 hours = 171,000 yen" and the excessive overtime allowance as "1,875 yen x 2 hours = 3,750 yen."

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

[0074] The calculation processing unit 24 adds up the basic salary and overtime allowance before and after the change in the salary system, and calculates the salary for March 2021 as shown in FIG. 14(a) for a monthly salary employee, as follows: basic salary: 264,517 yen, job salary: 20,646 yen, qualification allowance: 12,904 yen, etc. For an hourly wage employee, the calculation processing unit 24 calculates the overtime allowance as 21,789 yen, overtime allowance for over 40 hours per week as 9,828 yen, and monthly variable overtime allowance as 12,285 yen.

[0075] The calculation processing unit 24 adds up the basic salary and overtime allowance, etc. before and after the change in the salary system, and calculates the salary for March 2021 for an hourly wage employee as shown in Figure 14(b) for the basic salary of "252,000 yen" and the job salary of "15,000 yen," etc.

[0076] The storage control unit 25 controls the storage of such payroll calculation result data in the payroll data system 14. This completes all the processing in the flowchart of FIG.

[0077] [Effects of the embodiment] As is clear from the above explanation, the payroll calculation device 1 of the embodiment holds multiple pay rates per month as employment contract data, and also holds attendance data on a daily basis. This makes it possible to automatically calculate various allowances, including overtime pay, before and after the payroll system change, even if the payroll system is changed within the same month. Therefore, even if the payroll system is changed, payroll calculations can be performed easily without cumbersome work, and the time required for payroll calculations can be significantly reduced.

[0078] In addition, for overtime that occurs in a week, such as overtime over 40 hours per week, the higher overtime unit price for that week is used to calculate the overtime allowance for that week. Furthermore, for overtime that occurs in a month, such as monthly variable work, the higher overtime unit price for that month is used to calculate the monthly overtime allowance. This prevents the inconvenience of overtime over 40 hours per week or monthly overtime being calculated at the lower overtime unit price, resulting in the wages of temporary workers and other employees being unfairly low.

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

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

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

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

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

[0084] In addition, 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 drawings may be changed as desired unless otherwise specified.

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

[0086] 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 in 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 tenant analysis 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 a RAM, and cooperates with the CPU to configure the control unit 3.

[0087] In addition, this tenant analysis program, which is a computer program, may be stored in another server device connected to the tenant analysis device 1 via any network, and it is also possible to download all or part of it as needed.

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

[0089] Moreover, 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 configuration that is distributed as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

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

[0091] 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 connected to any peripheral device. The payroll 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 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]

[0093] The present invention is useful for payroll calculations when a change in pay format occurs during a payroll calculation period. [Explanation of symbols]

[0094] 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 Personnel Data System 12 Employment Data System 13 Payroll system 14 Payroll Data System 21 Employee Data Acquisition Department 22 Attendance Data Acquisition Department 23 Input Processing Section 24 Processing unit 25 Memory control unit

Claims

1. a change information acquisition unit for acquiring change information on employment conditions during a payroll calculation period; a basic amount acquisition unit that acquires pre-change amount information of the basic salary and various allowances before the change in the employment conditions indicated in the change information, and post-change amount information of the basic salary and various allowances after the change in the employment conditions; An attendance information acquisition unit for acquiring attendance information for the payroll calculation period; a work-related salary calculation unit that calculates a pre-change salary amount corresponding to the amount of work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount corresponding to the amount of work after the change in the employment conditions based on the post-change amount information and the attendance information; an overtime calculation unit that calculates a pre-change overtime amount equivalent to the amount of overtime work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount equivalent to the amount of overtime work after the change in the employment conditions based on the post-change amount information and the attendance information; a total payment calculation unit that calculates a total payment amount of salary for the salary calculation period by adding the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount, said overtime calculation unit, when the payroll calculation period is on a monthly basis, calculates the overtime amount for the week in which the change in employment conditions occurred and the overtime pay for the month in which the change in employment conditions occurred by using the higher overtime unit price of the overtime unit price before the change in employment conditions and the overtime unit price after the change in employment conditions; A payroll calculation device comprising:

2. The overtime calculation unit calculates the overtime amount before the change using an overtime unit price calculated by dividing the pre-change amount information by the prescribed working hours corresponding to the payroll calculation period and multiplying the calculated overtime amount by a prescribed coefficient related to overtime, and calculates the overtime amount after the change using an overtime unit price calculated by dividing the post-change amount information by the prescribed working hours corresponding to the payroll calculation period and multiplying the calculated overtime amount by a prescribed coefficient related to overtime.

2. The payroll calculation device according to claim 1 .

3. The work salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by a divided value obtained by dividing the number of working days before the change in 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 divided value obtained by dividing the number of working days after the change in the employment conditions by the number of calendar days.

3. The payroll calculation device according to claim 1 or 2, characterized in that

4. The change information acquisition unit acquires the change information of the employment conditions of the dispatched employee during a payroll calculation period; The payroll calculation device according to any one of claims 1 to 3, characterized in that

5. A payroll calculation method executed by a payroll calculation device having a change information acquisition unit, a basic amount acquisition unit, an attendance information acquisition unit, a working wage calculation unit, an overtime calculation unit, and a total pay calculation unit, a change information acquisition step in which the change information acquisition unit acquires change information on employment conditions during a payroll calculation period; a basic amount acquisition step in which the basic amount acquisition unit acquires pre-change amount information of the basic salary and various allowances before the change in the employment conditions indicated by the change information, and post-change amount information of the basic salary and various allowances after the change in the employment conditions; An attendance information acquisition step in which the attendance information acquisition unit acquires attendance information for the payroll calculation period; a work portion calculation step in which the work portion calculation unit calculates a pre-change salary amount corresponding to the work portion before the change in the 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 in the 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 equivalent to the amount of overtime work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount equivalent to the amount of overtime work after the change in the employment conditions based on the post-change amount information and the attendance information; a total payment calculation step in which the total payment 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 a total payment amount of salary for the salary calculation period; In the overtime calculation step, when the payroll calculation period is a month, the higher of the overtime unit price before the change in the employment conditions and the overtime unit price after the change in the employment conditions is used to calculate the overtime amount for the week in which the change in the employment conditions occurred and the overtime amount for the month in which the change in the employment conditions occurred; A payroll calculation method characterized by the above.

6. Computer, a change information acquisition unit for acquiring change information on employment conditions during a payroll calculation period; a basic amount acquisition unit that acquires pre-change amount information of the basic salary and various allowances before the change in the employment conditions indicated in the change information, and post-change amount information of the basic salary and various allowances after the change in the employment conditions; An attendance information acquisition unit for acquiring attendance information for the payroll calculation period; a work-related salary calculation unit that calculates a pre-change salary amount corresponding to the amount of work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change salary amount corresponding to the amount of work after the change in the employment conditions based on the post-change amount information and the attendance information; an overtime calculation unit that calculates a pre-change overtime amount equivalent to the amount of overtime work before the change in the employment conditions based on the pre-change amount information and the attendance information, and calculates a post-change overtime amount equivalent to the amount of overtime work after the change in the employment conditions based on the post-change amount information and the attendance information; a total payment calculation unit that calculates a total payment amount of salary for the salary calculation period by adding the pre-change salary amount, the pre-change overtime amount, the post-change salary amount, and the post-change overtime amount; said overtime calculation unit, when the payroll calculation period is on a monthly basis, calculates the overtime amount for the week in which the change in employment conditions occurred and the overtime pay for the month in which the change in employment conditions occurred by using the higher overtime unit price of the overtime unit price before the change in employment conditions and the overtime unit price after the change in employment conditions; A payroll program that features:

Images