Payroll calculation device, payroll calculation method, and payroll 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 calculation of each employee is performed 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 in the upper part of the display screen, and a summary of the salary details of each employee is displayed in 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 of each employee with only one click by performing the salary calculation of each employee of the 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 performed 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 with 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, with conventional payroll systems, it was difficult to calculate overtime pay separately for the same month using multiple overtime rates, both before and after the rate change. Furthermore, attendance hours could only be recorded as a monthly total, making it difficult to separate attendance hours before and after the rate change within the same month.

[0008] Therefore, if a change in the payroll system occurred within a payroll period, such as within a week or month, it was necessary to manually calculate payroll, including overtime pay, which was a time-consuming task.

[0009] This invention has been made in view of the above-mentioned problems, and aims to provide a payroll calculation device, a payroll calculation method, and a payroll calculation program that can easily perform payroll calculations even if a change in the payroll system occurs during the payroll calculation period. [Means for solving the problem]

[0010] To solve the above-mentioned problems and achieve the objective, the payroll calculation device according to the present invention includes: a change information acquisition unit that acquires information on changes in employment conditions during the payroll calculation period; a basic amount acquisition unit that acquires information on the basic salary and allowances before the change in employment conditions indicated by the change information, and information on the basic salary and allowances after the change in employment conditions; an attendance information acquisition unit that acquires attendance information for the payroll calculation period; a work portion payroll calculation unit that calculates the pre-change pay amount corresponding to the work performed before the change in employment conditions based on the pre-change amount information and attendance information, and calculates the post-change pay amount corresponding to the work performed after the change in employment conditions based on the post-change amount information and attendance information; and pre-change amount information and attendance information The system includes an overtime calculation unit that calculates the pre-change overtime amount, which corresponds to the overtime worked before the change in employment conditions, based on the information, and calculates the post-change overtime amount, which corresponds to the overtime worked after the change in employment conditions, based on the post-change amount information and attendance information, and a total payment calculation unit that calculates the total amount of salary paid for the pay period by adding up the pre-change salary amount, pre-change overtime amount, post-change salary amount and post-change overtime amount. The work-based salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by the division value obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the division value obtained by dividing the number of working days after the change in employment conditions by the number of calendar days.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the payroll calculation method according to the present invention is a payroll calculation method performed by a payroll calculation device equipped with a change information acquisition unit, a basic amount acquisition unit, an attendance information acquisition unit, a work-per-work pay calculation unit, an overtime calculation unit and a total pay calculation unit, wherein the change information acquisition unit performs a change information acquisition step to acquire information on changes in employment conditions within the payroll calculation period; the basic amount acquisition unit performs a basic amount acquisition step to acquire information on the basic salary and allowances before the change in employment conditions indicated by the change information, and information on the basic salary and allowances after the change in employment conditions; the attendance information acquisition unit performs an attendance information acquisition step to acquire attendance information for the payroll calculation period; and the work-per-work pay calculation unit calculates the pre-change pay amount corresponding to the work performed before the change in employment conditions based on the pre-change amount information and attendance information, and calculates the employment conditions based on the post-change amount information and attendance information. The system includes a work-based salary calculation step that calculates the revised salary amount corresponding to the work performed after the change; an overtime calculation step in which an overtime calculation unit calculates the pre-change overtime amount corresponding to the overtime work performed before the change in employment conditions based on the pre-change amount information and attendance information, and calculates the revised overtime amount corresponding to the overtime work performed after the change in employment conditions based on the revised amount information and attendance information; and a total payment calculation step in which a total payment calculation unit calculates the total payment amount for the salary calculation period by adding up the pre-change salary amount, pre-change overtime amount, revised salary amount, and revised overtime amount. In the work-based salary calculation step, the pre-change salary amount is calculated by multiplying the pre-change amount information by the value obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and the revised salary amount is calculated by multiplying the revised amount information by the value obtained by dividing the number of working days after the change in employment conditions by the number of calendar days.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the payroll calculation program according to the present invention comprises a computer, a change information acquisition unit that acquires information on changes in employment conditions during the payroll calculation period, a basic amount acquisition unit that acquires information on the basic salary and allowances before the change in employment conditions indicated by the change information, and information on the basic salary and allowances after the change in employment conditions, an attendance information acquisition unit that acquires attendance information for the payroll calculation period, a work portion payroll calculation unit that calculates the pre-change pay amount corresponding to the work performed before the change in employment conditions based on the pre-change amount information and attendance information, and calculates the post-change pay amount corresponding to the work performed after the change in employment conditions based on the post-change amount information and attendance information, and the pre-change amount The system functions as an overtime calculation unit that calculates the pre-change overtime amount, which corresponds to the overtime worked before the change in employment conditions, based on information and attendance information, and calculates the post-change overtime amount, which corresponds to the overtime worked after the change in employment conditions, based on post-change amount information and attendance information. It also functions as a total payment calculation unit that calculates the total amount of salary paid for the pay period by adding up the pre-change salary amount, pre-change overtime amount, post-change salary amount, and post-change overtime amount. The work-based salary calculation unit calculates the pre-change salary amount by multiplying the pre-change amount information by the division value obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the division value obtained by dividing the number of working days after the change in employment conditions by the number of calendar days. [Effects of the Invention]

[0013] According to the present invention, even if a change in the salary system occurs during the payroll period, payroll calculation can be easily performed. [Brief explanation of the drawing]

[0014] [Figure 1] Figure 1 is a block diagram showing the hardware configuration of the payroll calculation device according to the embodiment. [Figure 2] Figure 2 is a schematic diagram showing the flow of payroll processing in the payroll calculation device of the embodiment. [Figure 3] Figure 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. [Figure 5] FIG. 5 is a diagram showing an example of employment contract data in which the standard unit price and overtime unit price of overtime pay 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 summary 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 overtime calculation processing for overtime exceeding a predetermined time during the week by the arithmetic processing unit of the salary calculation device. [Figure 10] FIG. 10 is a diagram for explaining the operation of calculating the overtime pay for overtime exceeding a predetermined time during the week using the higher overtime unit price when the arithmetic processing unit performs the overtime calculation processing for overtime exceeding a predetermined time during the week. [Figure 11] FIG. 11 is a flowchart showing the flow of monthly modified overtime calculation processing by the arithmetic processing unit of the salary calculation device. [Figure 12] FIG. 12 is a diagram for explaining the operation of calculating the monthly overtime pay using the higher overtime unit price when the arithmetic processing unit performs the monthly modified overtime calculation processing. [Figure 13] FIG. 13 is a diagram showing an example of salary calculation data. [Figure 14] FIG. 14 is a diagram showing an example of salary calculation result data.

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 based on the drawings. The present invention is not limited by the following description of the embodiments.

[0016] [Hardware Configuration] First, Figure 1 is a block diagram showing the hardware configuration of the payroll calculation device 1 according to this embodiment. Although this is just one example, this payroll calculation device 1 is a payroll calculation device that calculates the salaries of each dispatched employee of a dispatching company. In this embodiment, the payroll calculation device 1 can be a desktop personal computer, a notebook personal computer, or a tablet personal computer. In addition, the payroll calculation device 1 can be a PDA (Personal Digital Assistant) or a portable information processing device such as a smartphone. Such a payroll 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 / output interface unit 5 is connected to an input device 6 and an output device 7. The output device 7 can be a monitor device (including a home television). The input device 6 can be a keyboard device, a mouse device, a microphone device, or a monitor device that works in conjunction with the mouse device to provide a pointing device function.

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

[0019] Each of the systems 11-14 is an application program that operates in relation to each other. In this example, we will proceed with the explanation assuming that each of the systems 11-14 is stored in the same memory unit 2, but the personnel data system 11, the work data system 12, and the payroll data system 14 may each be stored on physically different server devices. In this case, the payroll calculation device 1 and the server devices on which each of the systems 11, 12, and 14 are 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 and advantages described below can be obtained. For details, please refer to the explanation below.

[0020] The personnel data system 11 stores employee data for each dispatched worker, including their employee number, dispatch start period, dispatch end period, dispatch destination, and salary structure. The work data system 12 stores daily and monthly attendance data for each dispatched worker. The payroll data system 14 stores the payroll calculation results for each dispatched worker, calculated by the payroll calculation system 13.

[0021] The control unit 3 executes the payroll calculation system 13, which is an application program stored in the memory unit 2, thereby realizing the functions of the employee data acquisition unit 21, attendance data acquisition unit 22, input processing unit 23, calculation processing unit 24, and memory control unit 25.

[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 attendance data and monthly attendance data from the work data system 12. The input processing unit 23 generates employment contract data by inputting the standard unit price and overtime unit price for overtime pay before and after changes in the salary system within the month into the employee data, in response to the input operations of the business operator operating the payroll calculation device 1. The employee data acquisition unit 21 and the input processing unit 23 are examples of basic amount acquisition units.

[0023] The calculation processing unit 24 calculates the salary of each dispatched worker based on employment contract data and attendance data, including the standard unit price and overtime rate for overtime pay before and after changes to the salary system within the month. The calculation processing unit 24 is an example of a unit that calculates the salary for the work performed, an overtime calculation unit, and a total payment calculation unit. The storage control unit 25 transmits the calculated salary calculation result data showing the salary of each dispatched worker to the salary data system and controls its storage.

[0024] (A general overview of the payroll processing flow) Figure 2 is a schematic diagram illustrating the flow of this payroll calculation process. As shown in Figure 2, the employee data for each dispatched worker collected from the personnel data system 11 includes the standard overtime rate and overtime rate before and after any changes to the payroll system within the month. This generates employment contract data. In addition, the work information system 12 retrieves the daily and monthly attendance data for each dispatched worker as attendance summary data.

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

[0026] (Details of payroll processing) Figure 3 is a flowchart showing the flow of this payroll calculation process. The control unit 3 executes the payroll calculation system stored in the memory unit 2, and in order from step S1, each process shown in the flowchart of Figure 3 is executed.

[0027] First, in step S1, the employee data acquisition unit 21 acquires employee data of dispatched employees for whom payroll calculations are 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 for overtime pay before and after changes in the payroll system within the month into the employee data, in response to the input operations of the business operator.

[0028] Figure 4 shows an example of employment contract data. Of these, Figure 4(a) is an example of employment contract data for a monthly-paid contract employee. Figure 4(b) is an example of employment contract data for an hourly-paid contract employee. 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, end date of the dispatch contract, dispatch destination, salary category, monthly scheduled hours, scheduled days, daily scheduled hours, basic salary, daily wage, hourly wage, job-based pay, qualification allowance, standard unit price for overtime pay, and overtime unit price for overtime pay.

[0029] Of these, the employee number, the start date and end date of the dispatch contract, and the dispatch destination data are automatically entered into the employee data obtained from the HR data system 11. The example of a monthly-paid employee in Figure 4(a) shows 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] Furthermore, the example of a salaried employee in Figure 4(a) shows that a contract employee with employee number "100" had their assignment period to client company "100231" end on March 10th, 2021, and their assignment changed to company "2000011" from March 11th, 2021.

[0031] Furthermore, the example of hourly wage earners in Figure 4(b) shows that a contract employee with employee number "200" had their assignment period to client company "100231" end on March 10th, 2021, and their assignment changed to company "2000011" from March 11th, 2021.

[0032] In contrast, various data such as salary categories, monthly scheduled hours, scheduled days, daily scheduled hours, basic salary, daily wage, hourly wage, job-based pay, qualification allowance, standard rate for overtime pay, and overtime rate for overtime pay are manually entered by the operations operator.

[0033] The example of a monthly salary employee in Figure 4(a) shows an example where, before the change in the dispatch destination, the monthly scheduled hours were "160 hours", the number of scheduled 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 allowance was "40,000 yen", and the qualification allowance was "0 yen".

[0034] Furthermore, the example shows that after the assignment destination changes, the monthly scheduled hours are "168 hours", the number of scheduled 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 allowance is "10,000 yen", and the qualification allowance is "20,000 yen".

[0035] Furthermore, the example of an hourly wage worker shown in Figure 4(b) indicates that before the change in the client company, the hourly wage was "1000 yen," and after the change in the client company, the hourly wage became "1500 yen."

[0036] Next, in step S3 of the flowchart in Figure 3, the operations operator calculates and inputs the standard overtime rate and overtime rate into the employment contract data. In this case, if the operations operator has not entered both the standard overtime rate and overtime rate before the change in the dispatch destination and the standard overtime rate and overtime rate after the change in the dispatch destination, the operations operator inputs both the standard overtime rate and overtime rate before and after the change in the dispatch destination into the employment contract data. On the other hand, if the standard overtime rate and overtime rate before the change in the dispatch destination have already been entered, but the standard overtime rate and overtime rate after the change in the dispatch destination have not been entered, the operations operator inputs the standard overtime rate and overtime rate after the change in the dispatch destination into the employment contract data.

[0037] Figure 5 shows employment contract data with the standard overtime rate and overtime rate entered before and after the change in the dispatch destination. Of these, Figure 5(a) shows employment contract data with the standard overtime rate and overtime rate entered for a monthly-paid contract employee. Figure 5(b) shows employment contract data with the standard overtime rate and overtime rate entered for an hourly-paid contract employee.

[0038] For example, for salaried employees, the base rate for overtime is calculated by performing the following calculation: "(basic salary + job allowance + qualification allowance) / monthly scheduled hours". The actual overtime rate is then calculated by multiplying the base rate by the statutory overtime premium rate (1.25).

[0039] Therefore, in the example of a monthly-paid employee in Figure 5(a), before the dispatch destination changes, the base unit price of "1,500 yen" is calculated by "(200,000 yen + 40,000 yen) / 160 hours" and entered into the employment contract data. In addition, the overtime unit price of "1,875 yen" is calculated by "1,500 yen × 1.25" and entered into the employment contract data.

[0040] Furthermore, in the example of a monthly-paid employee in Figure 5(a), after the dispatch destination changes, the base hourly rate of "1,965 yen" is calculated by "(300,000 yen + 10,000 yen + 20,000 yen) / 168 hours". In addition, the overtime hourly rate of "2,457 yen" is calculated by "1,965 yen × 1.25".

[0041] In contrast, for hourly wage earners, the standard overtime rate is calculated by multiplying the hourly wage by the statutory overtime premium rate (1.25). Furthermore, the nighttime rate (premium pay) is calculated by multiplying the hourly wage by 0.25.

[0042] Therefore, in the example of an hourly wage worker in Figure 5(b), before the dispatch destination changes, the overtime rate of "1,250 yen" is calculated by "1,000 yen x 1.25" and entered into the employment contract data. Also, the night-time rate of "250 yen" is calculated by "1,000 yen x 0.25" and entered into the employment contract data.

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

[0044] Next, in step S4 of the flowchart in Figure 3, the attendance data acquisition unit 22 acquires daily attendance data and monthly attendance data from the work data system 12. Figure 6 shows an example of daily attendance data. As shown in Figure 6, the daily attendance data consists of company no., employee number, date, number of days worked, number of days worked on holidays, working hours, and overtime hours. In this example in Figure 6, the data from March 1st to March 10th is the daily attendance data before the change in the payroll system. The data from March 11th to March 31st is the daily attendance data after the change in the payroll system.

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

[0046] Figure 7(a) shows an example of attendance data before the change in the pay system, where the dispatch period started on "March 1, 2021," ended on "March 10, 2021," had "8" working days, "0" days of holiday work, "2" days of paid leave, "64" working hours, and "9" hours of overtime.

[0047] Furthermore, the example of attendance data after the change in the salary system shown in Figure 7(b) shows that the dispatch period started on "March 11, 2021," ended on "March 31, 2021," with "15 days" worked, "1 day" worked on holidays, "0 days" of paid leave, "114 hours" of work, and "2 hours" of overtime.

[0048] In contrast, Figure 8 shows an example of monthly attendance data. As shown in Figure 8, the monthly attendance data includes the 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. Furthermore, the monthly attendance data 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. Furthermore, the monthly attendance data includes overtime hours exceeding 40 hours in the fifth week of the month, and total monthly overtime hours.

[0049] The example of monthly attendance data shown in Figure 8 illustrates a scenario where, prior to the change in the salary system, the overtime hours exceeding 40 hours in the second week of the month were "4 hours," the overtime hours exceeding 40 hours in the third week of the month were "2 hours," and the total monthly overtime was "5 hours."

[0050] Furthermore, the example of monthly attendance data shown in Figure 8 demonstrates that, after the change in the salary system, the amount of overtime exceeding 40 hours in the first to fifth weeks of the month is "0 hours," and the total monthly overtime is also "0 hours."

[0051] Next, in step S5 of the flowchart in Figure 3, the calculation processing unit 24, when there is a change in the salary system within the week, uses the higher of the overtime rates before the change in the salary system and the overtime rates after the change in the salary system to calculate overtime corresponding to the hours exceeding the prescribed hours for that week (calculation of overtime exceeding prescribed hours within the week).

[0052] Figure 9 is a flowchart showing the detailed flow of the calculation operation for overtime exceeding the prescribed weekly hours shown in step S5. In the flowchart of Figure 9, as the process progresses from step S4 to step S11, the calculation processing unit 24 determines on a weekly basis whether or not overtime exceeding 40 hours (overtime exceeding the prescribed weekly hours) has occurred, based on the monthly attendance data shown in Figure 8. If no overtime exceeding the prescribed weekly hours has occurred (step S11: No), the process proceeds directly to step S6 in the flowchart of Figure 3.

[0053] On the other hand, if overtime exceeding the prescribed hours occurs within the week (Step S11: Yes), the process proceeds to Step S12. In Step S12, the calculation processing unit 24 determines whether there has been a change in the overtime rate due to a change in the salary system for the week in which the overtime exceeding the prescribed hours 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 does not affect the calculation of overtime. Therefore, in Step S13, the calculation processing unit 24 calculates the overtime pay for overtime exceeding the prescribed hours within the week using the previous overtime rate. This allows the process to proceed to Step S6.

[0055] In contrast, if there is a change in the overtime rate within the week (step S12: Yes), the calculation processing unit 24 calculates the overtime pay for hours exceeding the scheduled hours for that week using the higher of the overtime rates before and after the change in the pay system in step S14.

[0056] Specifically, as shown in Figure 10, suppose that during the week from March 8th (Sun) to March 14th (Sat), the salary system changes on March 11th (Wed), causing the overtime rate to change from "1,875 yen" to "2,475 yen" from March 11th (Wed). In this case, the calculation processing unit 24 uses the higher overtime rate of "2,475 yen" to calculate the overtime pay for hours exceeding the standard hours within the week. This prevents the disadvantageous situation where dispatched workers are paid overtime using the lower overtime rate.

[0057] Furthermore, the arithmetic processing unit 24 calculates overtime pay for hours exceeding the prescribed time within a week using the higher overtime rate, but only for the calculation of overtime pay for salaried employees.

[0058] Next, in the flowchart of Figure 3, once the calculation process for overtime exceeding the prescribed weekly hours is performed, the process proceeds to step S6. In step S6, the calculation processing unit 24 performs a monthly variable overtime calculation process that calculates the overtime allowance for the month using the higher overtime rate if the overtime rate changes due to a change in the salary system within that month.

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

[0060] On the other hand, if monthly overtime hours have been incurred (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 rate has occurred due to a change in the salary system during that month.

[0061] If there is no change in the overtime rate for that month (Step S22: No), it means that there is no change in the salary system, or that the change in the salary system does not affect the overtime calculation. Therefore, in Step S23, the calculation processing unit 24 calculates the monthly overtime allowance using the previous overtime rate. This allows the process to proceed to Step S7.

[0062] In contrast, if there is a change in the overtime rate within that month (step S22: Yes), the calculation processing unit 24 calculates the overtime pay for that month's overtime using the higher of the overtime rates before and after the change in the salary system in step S24.

[0063] Specifically, as shown in Figure 12, suppose that within the month of March 1st (Sun) to March 31st (Tue), the salary system changes on March 11th (Wed), and the overtime rate changes from "1,875 yen" to "2,475 yen" from March 11th (Wed). In this case, the calculation processing unit 24 uses the higher overtime rate of "2,475 yen" to calculate the overtime pay for the month's overtime work. This prevents the disadvantageous situation where the monthly overtime pay for dispatched workers is calculated using the lower overtime rate.

[0064] Furthermore, the arithmetic processing unit 24 calculates the overtime pay for monthly overtime work within the month using the higher overtime rate, but only for the calculation of overtime pay for salaried employees.

[0065] Next, once this monthly variable overtime calculation process is completed, the process proceeds to step S7 in the flowchart of Figure 3. In step S7, the arithmetic processing unit 24 generates payroll calculation data by reflecting the calculation results of the weekly overtime calculation process and the monthly variable overtime calculation process into the employment contract data. The arithmetic processing unit 24 then generates payroll calculation result data by adding the basic salary and overtime pay, etc., before and after the change in the emergency system, as shown in this payroll calculation data. The storage control unit 25 stores this payroll calculation result data in the payroll data system 14.

[0066] Figure 13 shows an example of payroll calculation data. Figure 13(a) is an example of payroll calculation data for a monthly salary employee, and Figure 13(b) is an example of payroll calculation data for an hourly salary employee.

[0067] In the example of a monthly salary employee shown in Figure 13(a), the records in the upper column represent the payroll calculation data before the change in the payroll system, and the records in the lower column represent the payroll calculation data after the change in the payroll system.

[0068] The period before the change in the salary system is from March 1, 2021 to March 10, 2021. The calculation processing unit 24 calculates the basic salary for the period before the change in the salary system 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". The calculation processing unit 24 also calculates the overtime allowance before the change in the salary system as "1,875 yen × 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 × (20 days / 31 days) = 193,549 yen" and the job allowance as "10,000 yen × (20 days / 31 days) = 6,452 yen". The calculation processing unit 24 also 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 calculation processing unit 24 calculates the overtime allowance for hours 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". Furthermore, the calculation processing unit 24 calculates the monthly variable overtime allowance using the higher overtime rate before and after the change in the salary system, resulting in "2,457 yen x 5 hours = 12,285 yen".

[0070] Similarly, in the example of hourly wage earners in Figure 13(b), the records in the upper column are the payroll calculation data before the payroll system change, and the records in the lower column are the payroll calculation data after the payroll system change.

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

[0073] Next, the calculation processing unit 24 adds up the basic salary and overtime pay calculated before and after the salary system change to generate salary calculation result data. Figure 14 shows an example of salary calculation result data. Of these, Figure 14(a) shows an example of salary calculation result data for a monthly salary employee, and Figure 14(b) shows an example of salary calculation result data for an hourly salary employee.

[0074] The calculation processing unit 24 adds up the basic salary and overtime pay before and after the change in the salary system, so that for salaried employees, as shown in Figure 14(a), the salary for March 2021 is calculated as follows: basic salary of "264,517 yen", job pay of "20,646 yen", qualification allowance of "12,904 yen", etc. Also, for hourly wage employees, the calculation processing unit 24 calculates overtime pay of "21,789 yen", overtime pay for over 40 hours per week of "9,828 yen", monthly variable overtime pay of "12,285 yen", etc.

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

[0076] The memory control unit 25 stores this payroll calculation result data in the payroll data system 14. This completes all the processes shown in the flowchart in Figure 3.

[0077] [Effects of the embodiment] As is clear from the above description, the payroll calculation device 1 of this embodiment stores multiple pay rates as employment contract data for the month, and also stores attendance data on a daily basis. This allows the system to automatically calculate various allowances, including overtime pay, before and after the payroll system change, even if the payroll system changes within the same month. Therefore, even if the payroll system changes, payroll calculations can be performed easily without any troublesome procedures, and payroll calculation time can be significantly reduced.

[0078] Furthermore, for overtime that occurs on a weekly basis, such as overtime exceeding 40 hours per week, the higher of the two overtime rates for that week will be used to calculate the overtime pay for that week. In addition, for overtime that occurs on a monthly basis, such as in a variable monthly work schedule, the higher of the two overtime rates for that month will be used to calculate the monthly overtime pay. This prevents the problem of overtime exceeding 40 hours per week or monthly overtime being calculated using the lower overtime rate, which could result in unfairly low wages for employees such as dispatched workers.

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

[0080] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0081] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

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

[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 by known methods.

[0084] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0085] Furthermore, with respect to the payroll calculation device 1, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[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 implemented in whole or in any part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary 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 needed. That is, a storage unit such as ROM or HDD records a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit 3.

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

[0088] Furthermore, the payroll calculation program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical Disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0089] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

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

[0091] Furthermore, the payroll calculation device 1 may be composed of a known personal computer device or an information processing device such as a workstation, or it may be composed of an information processing device to which any peripheral devices are connected. In addition, the payroll calculation device 1 may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

[0092] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional additions. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0093] This invention is useful for calculating salaries when a change in salary structure occurs during the payroll period. [Explanation of Symbols]

[0094] 1. Payroll processing system 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input devices 7 Output device 11. Human Resources Data System 12. Employment Data System 13. Payroll System 14. Payroll Data System 21 Employee Data Acquisition Department 22 Attendance Data Acquisition Unit 23 Input Processing Unit 24. Arithmetic Processing Unit 25 Memory Control Unit

Claims

1. A change information acquisition unit that acquires information on changes in employment conditions during the payroll calculation period, A basic amount acquisition unit that acquires information on the basic salary and allowances before the change in employment conditions indicated in the aforementioned change information, and information on the basic salary and allowances after the change in employment conditions, A time and attendance information acquisition unit that acquires attendance information for the aforementioned payroll calculation period, A work-per-work pay calculation unit calculates the pre-change salary amount corresponding to the work performed before the change in employment conditions based on the pre-change salary information and attendance information, and calculates the post-change salary amount corresponding to the work performed after the change in employment conditions based on the post-change salary information and attendance information. An overtime calculation unit calculates the pre-change overtime amount corresponding to the overtime work before the change in employment conditions based on the pre-change amount information and the attendance information, and calculates the post-change overtime amount corresponding to the overtime work after the change in employment conditions based on the post-change amount information and the attendance information, The system includes a total payment calculation unit that calculates the total amount of salary paid for the salary calculation period by adding up the salary amount before the change, the overtime amount before the change, the salary amount after the change, and the overtime amount after the change. The aforementioned work-based salary calculation unit calculates the pre-change salary amount by multiplying the pre-change salary information by the division result obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the division result obtained by dividing the number of working days after the change in employment conditions by the number of calendar days by the post-change salary information. A payroll calculation device characterized by the following.

2. The overtime calculation unit calculates the pre-change overtime amount using the overtime rate calculated by dividing the pre-change amount information by the prescribed working hours corresponding to the payroll calculation period and multiplying it by a prescribed coefficient for overtime, and then calculates the post-change overtime amount using the overtime rate calculated by dividing the post-change amount information by the prescribed working hours corresponding to the payroll calculation period and multiplying it by a prescribed coefficient for overtime. A payroll calculation device according to claim 1, characterized by the following:

3. The aforementioned change information acquisition unit acquires the aforementioned change information regarding the employment conditions of dispatched workers during the payroll calculation period. A payroll calculation device according to claim 1 or claim 2, characterized by the above.

4. A payroll calculation method performed by a payroll calculation device comprising a change information acquisition unit, a base amount acquisition unit, an attendance information acquisition unit, a work-per-hour pay calculation unit, an overtime calculation unit, and a total pay amount calculation unit, The aforementioned change information acquisition unit includes a change information acquisition step that acquires information on changes in employment conditions within the payroll calculation period, The basic amount acquisition unit performs a basic amount acquisition step in which it acquires information on the basic salary and allowances before the change in employment conditions indicated in the change information, and information on the basic salary and allowances after the change in employment conditions. The attendance information acquisition unit performs an attendance information acquisition step of acquiring attendance information for the payroll calculation period, The aforementioned work-based pay calculation unit calculates the pre-change pay amount corresponding to the work performed before the change in employment conditions based on the pre-change amount information and the attendance information, and calculates the post-change pay amount corresponding to the work performed after the change in employment conditions based on the post-change amount information and the attendance information, in a work-based pay calculation step. The overtime calculation step includes: the overtime calculation unit calculating the 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 calculating the 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; The total payment calculation unit includes a total payment calculation step which calculates the total amount of salary for the pay period by adding the salary amount before the change, the overtime amount before the change, the salary amount after the change, and the overtime amount after the change, In the aforementioned work-based salary calculation step, the pre-change salary amount is calculated by multiplying the pre-change salary information by the division result 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 division result obtained by dividing the number of working days after the change in employment conditions by the number of calendar days by the post-change salary information. A payroll calculation method characterized by the following.

5. Computers, A change information acquisition unit that acquires information on changes in employment conditions during the payroll calculation period, A basic amount acquisition unit that acquires information on the basic salary and allowances before the change in employment conditions indicated in the aforementioned change information, and information on the basic salary and allowances after the change in employment conditions, A time and attendance information acquisition unit that acquires attendance information for the aforementioned payroll calculation period, A work-per-work pay calculation unit calculates the pre-change salary amount corresponding to the work performed before the change in employment conditions based on the pre-change salary information and attendance information, and calculates the post-change salary amount corresponding to the work performed after the change in employment conditions based on the post-change salary information and attendance information. An overtime calculation unit calculates the pre-change overtime amount corresponding to the overtime work before the change in employment conditions based on the pre-change amount information and the attendance information, and calculates the post-change overtime amount corresponding to the overtime work after the change in employment conditions based on the post-change amount information and the attendance information, The unit functions as a total payment calculation unit that calculates the total amount of salary paid for the salary calculation period by adding up the aforementioned salary amount before the change, the aforementioned overtime amount before the change, the aforementioned salary amount after the change, and the aforementioned overtime amount after the change. The aforementioned work-based salary calculation unit calculates the pre-change salary amount by multiplying the pre-change salary information by the division result obtained by dividing the number of working days before the change in employment conditions by the number of calendar days, and calculates the post-change salary amount by multiplying the division result obtained by dividing the number of working days after the change in employment conditions by the number of calendar days by the post-change salary information. A payroll program characterized by the following features.

Images