JP7736731B2 - Social insurance premium processing device, social insurance premium processing method, and social insurance premium processing program - Google Patents

Description

The present invention relates to a social insurance premium processing device, a social insurance premium processing method, and a social insurance premium processing program.

For example, in the past, the amount of social insurance premiums to be collected was calculated by a person in charge, who would determine whether or not an individual was eligible for social insurance when they acquired or lost eligibility, maintain the classification, and then calculate the social insurance premiums. A conventional system for calculating social insurance premiums is disclosed, for example, in Patent Document 1.

Patent No. 5917785

However, Patent Document 1 does not mention anything about reducing the burden on employees who calculate social insurance premiums in industries with high employee turnover rates.

The present invention was made in consideration of the above, and aims to provide a social insurance premium processing device, a social insurance premium processing method, and a social insurance premium processing program that can reduce the burden on employees when calculating social insurance premium collection amounts in industries with high employee turnover.

To solve the above-mentioned problems and achieve the objectives, the present invention provides a social insurance premium processing device equipped with a control unit. The control unit is configured to be able to access a memory area that stores employee information including the target year and month of salary payment, employee number, date of employment, date of retirement, social insurance category, date of social insurance qualification acquisition, date of social insurance qualification loss, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount. The device is characterized by having: employee information registration means that registers and updates the target year and month of salary payment, employee number, date of employment, date of retirement, date of social insurance qualification acquisition, date of social insurance qualification loss, social insurance collection category, and grade of the employee information in response to operation by a staff member; and social insurance premium processing means that, when calculating the payroll for the target year and month, updates the social insurance collection category or previous month's insurance premium for the employee information for each employee number based on the social insurance qualification acquisition date and date of social insurance qualification loss, and calculates and updates the insurance premium collection amount based on the social insurance collection category.

Furthermore, according to one aspect of the present invention, the social insurance premium processing means may process update pattern (1) by setting the social insurance collection category to "the month before joining the company" if the target year/month - January = the month of the social insurance qualification acquisition date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date; process update pattern (2) by setting the social insurance collection category to "exemption" if the target year/month > the month of the social insurance qualification loss date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss; process update pattern (3) by setting the amount as the previous month's insurance premium; and process update pattern (4) by not updating if the social insurance qualification acquisition date = the month of the social insurance qualification loss date and the social insurance qualification acquisition date ≠ the social insurance qualification loss date.

Furthermore, according to one aspect of the present invention, in the case of joining social insurance at the time of employment or joining at a time other than the time of employment, the processing of the update pattern (1) is performed; in the case of social insurance loss at retirement, including mid-month and end-of-month retirement, loss other than retirement, including contract changes, and same-day acquisition or loss due to transfer, the processing of the update pattern (2) is performed; in the case of social insurance loss or acquisition in the same month, the processing of the update pattern (3) is performed; and in the case of social insurance loss or acquisition on the same day due to re-employment after retirement, the processing of the update pattern (4) may be performed.

In addition, according to one aspect of the present invention, the control unit is further configured to be able to access a social insurance premium table master that associates grades with social insurance premiums, and the social insurance premium processing means sets the premium collection amount to the previous month's premium if the social insurance collection category is "normal," sets the premium collection amount to 0 yen if the social insurance collection category is "exempt," sets the premium collection amount to 0 yen if the social insurance collection category is "month before joining" and the social insurance category is "non-eligible," and if it is "eligible," retrieves the social insurance premiums from the social insurance premium table master using the grade of the employee information as a key and sets the amount as the premium collection amount.

Furthermore, to solve the above-mentioned problems and achieve the objectives, the present invention provides a social insurance premium processing method executed by an information processing device equipped with a control unit. The control unit is configured to be able to access a memory area that stores employee information including the target year and month of salary payment, employee number, date of employment, date of retirement, social insurance category, date of social insurance qualification acquisition, date of social insurance qualification loss, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount. The method includes an employee information registration process executed by the control unit that registers and updates the target year and month of salary payment, employee number, date of employment, date of retirement, date of social insurance qualification acquisition, date of social insurance qualification loss, social insurance collection category, and grade of the employee information in response to operations by a person in charge, and a social insurance premium processing process that, when calculating the payroll for the target year and month, updates the social insurance collection category or previous month's insurance premium for the employee information for each employee number based on the social insurance qualification acquisition date and date of social insurance qualification loss, and calculates and updates the insurance premium collection amount based on the social insurance collection category.

Furthermore, to solve the above-mentioned problems and achieve the objectives, the present invention provides a social insurance premium processing program for execution by an information processing device equipped with a control unit. The control unit is configured to access a memory area that stores employee information including the target year and month of salary payment, employee number, date of employment, date of retirement, social insurance category, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount. The control unit executes an employee information registration process in response to operations by a staff member to register and update the target year and month of salary payment, employee number, date of employment, date of retirement, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and grade for the employee information, and a social insurance premium processing process that, when calculating the payroll for the target month, updates the social insurance collection category or previous month's insurance premium for the employee information based on the social insurance qualification acquisition date and social insurance qualification loss date, and calculates and updates the insurance premium collection amount based on the social insurance collection category for each employee number.

This invention has the effect of reducing the burden on employees in industries with high employee turnover when calculating social insurance premiums.

FIG. 1 is a block diagram showing an example of the configuration of a social insurance premium processing device according to this embodiment. FIG. 2 is a diagram showing an example of the configuration of the social insurance premium table master. FIG. 3 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 4 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 5 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 16 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 17 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment. FIG. 18 is a diagram for explaining a specific example of the processing of the control unit of the social insurance premium processing device according to this embodiment.

An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to this embodiment.

[1. Overview]
In the past, the calculation of social insurance (hereinafter sometimes abbreviated as "social insurance") premiums required a person in charge to determine whether or not an employee was eligible for social insurance when they gained or lost their qualifications, maintain the social insurance collection classification, and calculate the premiums. In industries with a lot of employees joining and leaving the company (for example, the temporary staffing industry, large companies with many employees, and group companies with many intra-group transfers), qualifications are frequently gained and lost, and special cases such as gaining or losing qualifications in the same month or on the same day also occur. This not only required the time and effort of maintaining the social insurance collection classification, but also specialized knowledge, which placed a heavy burden on the person in charge.

This invention reduces the burden on the person in charge of calculating the amount of social insurance premiums to be collected by automatically calculating the amount of social insurance premiums to be collected based on the employee's date of social insurance eligibility acquisition (hereinafter sometimes abbreviated as "social insurance acquisition date") and the date of social insurance eligibility loss (hereinafter sometimes abbreviated as "social insurance loss date").

Specifically, when calculating payroll, this invention references both the date of social insurance acquisition and the date of social insurance loss, calculates the social insurance collection category and the previous month's insurance premium, and automatically calculates the amount of social insurance premium to be collected based on the social insurance collection category.

For example, in cases where there was a high rate of hiring and retirement, the burden on the person in charge of setting social insurance premium collection categories for each employee was heavy. However, with this invention, the person in charge can now complete the process by simply processing hiring and retirement, significantly reducing the effort required to calculate social insurance premium collection amounts when calculating payroll.

The social insurance premium processing device of the present invention can be suitably applied to industries with a high rate of employee joining and leaving (for example, the temporary staffing industry, large companies with many employees, group companies with a high rate of intra-group transfers, etc.).

2. Configuration
An example of the configuration of a social insurance premium processing device according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a social insurance premium processing device according to this embodiment.

The social insurance premium processing device 100 is a commercially available desktop personal computer. Note that the social insurance premium processing device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers.

The social insurance premium processing device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the social insurance premium processing device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the social insurance premium processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the social insurance premium processing device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in conjunction with a mouse. Note that, below, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The memory unit (storage area) 106 stores various databases, tables, files, and the like. The memory unit 106 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk.

The memory unit 106 also stores social insurance premium table master data 106a, employee qualifications, etc. Figure 2 shows an example of the configuration of the social insurance premium table master data 106a.

The social insurance premium table master 106a can be configured as a table that associates and registers grades and social insurance premium amounts, as shown in Figure 2.

Employee information may include basic employee information (eligible year and month, employee number, date of joining, date of leaving), social insurance information (eligible year and month, employee number, social insurance category (0: not eligible, 1: eligible), date of social insurance acquisition, date of loss of social insurance, social insurance collection category (0: normal collection, 5: exempt, 6: month before joining), grade), and employee continuation deduction previous month information (eligible year and month, employee number, previous month's insurance premium).

The control unit 102 is a CPU or the like that provides overall control of the social insurance premium processing device 100. The control unit 102 has internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and performs various information processing operations based on these stored programs.

The control unit 102 is configured to be able to access the social insurance premium table master 106a, employee information, etc. stored in the memory unit 106. Note that the social insurance premium table master 106a and employee information, etc. may be stored in another location (e.g., server 200), as long as the control unit 102 is able to access them.

The control unit 102 conceptually includes an employee information registration unit 102a, a social insurance premium processing unit 102b, a master maintenance unit 102c, and a screen display control unit 102d.

The employee information registration unit 102a is used to register and update employee information. For example, in response to operations performed by the person in charge on the employee information input screen displayed on the monitor 114, it registers and updates the employee information stored in the memory unit 106, such as the salary payment date, employee number, joining date, retirement date, social insurance eligibility acquisition date, social insurance eligibility loss date, social insurance collection category, and grade.

When calculating the payroll for the target month, the social insurance premium processing unit 102b updates the social insurance collection category or previous month's insurance premium for each employee information for each employee number based on the social insurance acquisition date and social insurance loss date, and calculates and updates the insurance premium collection amount based on the social insurance collection category.

In addition, if the target year/month - January = the month of the social insurance acquisition date, and the social insurance acquisition date ≠ the social insurance loss date, and the month of the social insurance acquisition date ≠ the month of the social insurance loss date, the social insurance premium processing unit 102b will process update pattern (1) and set the social insurance collection category to "the month before joining the company." If the target year/month > the month of the social insurance loss date, and the social insurance acquisition date ≠ the social insurance loss date, and the month of the social insurance acquisition date ≠ the month of the social insurance loss, the social insurance premium processing unit 102b will process update pattern (2) and set the social insurance collection category to "exempt." If the month of the social insurance acquisition date = the month of the social insurance loss date, and the social insurance acquisition date ≠ the social insurance loss date, the social insurance premium processing unit 102b will process update pattern (3) and set the amount as the previous month's insurance premium. If the social insurance acquisition date = the social insurance loss date, the social insurance premium processing unit 102b will not perform the update, and will process update pattern (4).

In the case of joining social insurance at the time of employment or joining at a time other than the time of employment, renewal pattern (1) is processed; in the case of social insurance loss at retirement, including mid-month and end-of-month retirement, loss other than retirement, including contract changes, and gaining or losing on the same day due to transfer, renewal pattern (2) is processed; in the case of social insurance gain or loss in the same month, renewal pattern (3) is processed; and in the case of social insurance gain or loss on the same day due to re-employment after retirement, renewal pattern (4) may be processed.

If the social insurance collection category is "normal," the social insurance premium processing unit 102b sets the insurance premium collection amount to the previous month's insurance premium; if the social insurance collection category is "exempt," it sets the insurance premium collection amount to 0 yen; if the social insurance collection category is "month before joining" and the social insurance category is "non-eligible," it sets the insurance premium collection amount to 0 yen; if the social insurance collection category is "eligible," it may retrieve the insurance premium from the social insurance premium table master 106a using the employee information grade as a key and set the amount as the insurance premium collection amount.

The master maintenance unit 102c performs editing such as inputting, adding, and changing data in the social insurance premium table master 106a in response to operator operations on the master maintenance screen (not shown) displayed on the monitor 114.

The screen display control unit 102d controls the display and input of various screens (e.g., master maintenance screen, employee information input screen, etc.) displayed on the monitor 114.

3. Specific Examples
Specific examples of the processing of the social insurance premium processing device 100 in this embodiment will be described with reference to Figures 1 to 18. Figures 3 to 18 are diagrams for explaining specific examples of the processing of the social insurance premium processing device 100 in this embodiment.

[3-1. Processing flow]
Figure 3 is a diagram for explaining the setting logic for the social insurance collection category when calculating payroll. The social insurance premium processing unit 102b sets the social insurance collection category when calculating payroll according to this setting logic. If the social insurance collection category is "0: normal collection," the previous month's insurance premium is set as the insurance premium collection amount, and the previous month's amount is collected. If the social insurance collection category is "5: exempt," the insurance premium collection amount is set to 0 yen, and collection is exempted. If the social insurance collection category is "6: month before joining the company," the social insurance category logic in Figure 4 is followed (calculation is performed even if the previous month's insurance premium is not set as a value).

Figure 4 is a diagram explaining the logic for setting the amount of insurance premiums to be collected according to the social insurance category when the social insurance collection category is "6: Month before joining the company." According to this setting logic, when calculating payroll, the social insurance premium processing unit 102b sets the amount of insurance premiums to be collected according to the social insurance category when the social insurance collection category is "6: Month before joining the company." If the social insurance category is "0: Not applicable," the amount of insurance premiums to be collected is set to 0 yen. If the social insurance category is "1: Applicable," the employee information grade and social insurance premium table master 106a are referenced, and the insurance premium is retrieved from the social insurance premium table master 106a using the employee information grade as a key, and the amount is set as the current month's insurance premium.

Figure 5 is a diagram illustrating events, employee information update items, and update patterns (1) to (5). The amount of social insurance premium deductions is controlled by updating the social insurance premium collection category and the previous month's insurance premium. In the diagram, the horizontal axis represents the events that occur, including social insurance enrollment at time of employment, enrollment other than at time of employment, loss at time of retirement (retirement during the month), loss at time of retirement (retirement at the end of the month), loss other than retirement (contract change, etc.), gain or loss in the same month, gain or loss on the same day (reemployment after retirement), gain or loss on the same day (transfer), etc. The vertical axis represents employee information, including date of employment, date of retirement, social insurance category, date of social insurance acquisition, date of loss of social insurance, social insurance premium collection category, and previous month's insurance premium. Items that the employee information registration unit 102a updates when an event occurs are marked with a "○."

The employee information registration unit 102a updates employee information items when an event occurs as follows: If the employee joined at the time of employment, the employee's joining date, social insurance category, and social insurance acquisition date are updated. If the employee joined at a time other than employment, the social insurance category and social insurance acquisition date are updated. If the employee was terminated at the time of retirement (retired during the month), the employee's retirement date, social insurance category, and social insurance loss date are updated. If the employee was terminated at the time of retirement (retired at the end of the month), the employee's retirement date, social insurance category, and social insurance loss date are updated. If the employee was terminated at a time other than retirement (contract change, etc.), the employee's social insurance category and social insurance loss date are updated. If the employee was terminated in the same month, the employee's social insurance category, social insurance acquisition date, and social insurance loss date are updated. If the employee was terminated on the same day (reemployed after retirement), the employee's joining date, retirement date, social insurance category, social insurance acquisition date, and social insurance loss date are updated. If the employee was terminated on the same day (transfer), the employee's joining date, retirement date, social insurance category, social insurance acquisition date, and social insurance loss date are updated.

The social insurance premium processing unit 102b processes update patterns (1) to (4) in the following cases. The processing details of update patterns (1) to (4) are explained in Figure 6. In the case of social insurance enrollment at the time of joining the company or enrollment at a time other than joining the company, update pattern (1) processing is performed. In the case of social insurance loss at retirement (retirement during the month), loss at retirement (retirement at the end of the month), loss other than retirement (contract change, etc.), and same-day acquisition or loss (transfer), update pattern (2) processing is performed. Note that in the case of loss other than retirement (contract change, etc.), the retirement date is not updated, but the information is updated based on the social insurance loss date, so it is included in the processing of update pattern (2). In the case of same-day acquisition or loss (transfer), update pattern (2) processing is performed at the transfer origin to process loss at retirement, and update pattern (1) processing is performed at the transfer destination to process enrollment at joining the company. In the case of same-month acquisition or loss, update pattern (3) processing is performed. In the case of same-day acquisition or loss (reemployment after retirement), update pattern (4) processing is performed.

Figure 6 is a diagram illustrating the processing flow of the employee information registration unit 102a and the social insurance premium processing unit 102b. In Figure 6, the employee information registration unit 102a executes the employee information registration and update process (step S1). Specifically, in the employee information registration and update process, the employee information registration unit 102a registers and updates the employee information such as the salary payment date, employee number, joining date, retirement date, social insurance acquisition date, social insurance loss date, social insurance collection category, and grade.

The social insurance premium processing unit 102b executes the social insurance premium calculation process when calculating payroll (step S2). Specifically, in the social insurance premium calculation process, the social insurance premium processing unit 102b updates the social insurance premium collection category and the amount of premium collected. The social insurance premium collection category update flow is as follows:

First, it is determined whether the social insurance acquisition date = social insurance loss date (even if both are NULL) (Step T1). If the social insurance acquisition date = social insurance loss date (even if both are NULL) ("Yes" in Step T1), it is determined that the acquisition and loss occurred on the same day (reemployment after retirement), and update processing is not performed as update pattern (4) processing (Step T11).

If the social insurance acquisition date is not the same as the social insurance loss date (even if both are NULL) ("No" in step T1), it is determined whether the social insurance acquisition month is the same as the social insurance loss month (step T2). If the social insurance acquisition month is the same as the social insurance loss month ("Yes" in step T2), it is determined that the social insurance acquisition month was the same as the social insurance loss month, and the amount is set to the previous month's insurance premium as part of update pattern (3) processing (step T11).

If the month of social insurance acquisition is not equal to the month of social insurance loss ("No" in step T2), it is determined whether the month of social insurance loss is less than the target month (step T3). If the month of social insurance loss is less than the target month ("Yes" in step T3), it is determined that the social insurance was lost upon retirement (retired during the month), lost upon retirement (retired at the end of the month), lost other than retirement (contract change, etc.), or gained or lost on the same day (transfer), and the social insurance collection category is set to "5" as part of the update pattern (2) processing (step T13).

If the month of social insurance loss is not less than the target year and month ("No" in step T3), it is determined whether the month of social insurance acquisition = the target year and month - 1 month (step T4). If the month of social insurance acquisition = the target year and month - 1 month ("Yes" in step T4), it is determined that the employee joined social insurance at the time of joining the company or at a time other than joining the company, and the social insurance collection category is set to "6" as part of the update pattern (1) processing (step S14).

If the social insurance acquisition month is not equal to the target year and month minus January ("No" in step T4), the update process will not be performed.

The flow for updating the insurance premium collection amount is as follows: If the social insurance collection category is "0: Normal collection", the insurance premium collection amount is set to the previous month's insurance premium.

If the social insurance collection category is "5: Exempt", set the insurance premium collection amount to 0 yen.

If the social insurance collection category is "6: Month before joining the company," the social insurance category is determined (step T5), and if it is "0: Not applicable," the insurance premium collection amount is set to 0 yen; if it is "1: Applicable," the social insurance premium amount is obtained from the social insurance premium table master 106a using the employee information grade as a key, the amount is set as the current month's insurance premium, and the current month's insurance premium is set as the insurance premium collection amount.

[3-2. Update process]
The above update process will be explained using specific examples of cases (1) to (4).

(CASE (1): In the case of obtaining social insurance qualification)
7 and 8, CASE (1) (when social insurance eligibility is obtained) will be explained. CASE (1) is an example in which the above update pattern (1) is applied. The target year and month is 2022/10. In FIG. 7, the employee information is assumed to include the target year and month "202210", employee number "100", joining date "2022/9/1", retirement date "", social insurance category "1: Eligible", social insurance acquisition date "2022/9/1", social insurance loss date "", social insurance collection category "0: Normal", grade "10", previous month's insurance premium "0", current month's insurance premium "0", and insurance premium collection amount "0".

In payroll calculations, as shown in Figure 8, the target year and month - January = social insurance acquisition date (month of social insurance acquisition date), the social insurance acquisition date ≠ social insurance loss date, and the social insurance acquisition date (month) ≠ social insurance loss date (month), so update pattern (1) is processed and the social insurance collection category in the employee information is set to "6: Month before joining". Since the social insurance collection category is "6: Month before joining" and the social insurance category is "1: Target", "1,000 yen" is retrieved from the social insurance premium table master 106a using grade "10" as the key, and the retrieved "1,000 yen" is set as the current month's insurance premium, and the current month's insurance premium of "1,000 yen" is set as the insurance premium collection amount.

(CASE (2): Loss of social insurance eligibility)
9 and 10, we will explain CASE (2) (when social insurance eligibility is lost). CASE 2 is an example in which the above update pattern (2) is applied. The target year and month for payroll calculation is 2022/10. Assume that employee information such as that shown in FIG. 9 is registered. The employee information is assumed to be the target year and month "202210", employee number "200", joining date "2022/9/1", retirement date "", social insurance category "1: target", social insurance acquisition date "2022/9/1", social insurance loss date "", social insurance collection category "0: normal", grade "10", previous month's insurance premium "1000", current month's insurance premium "1000", and insurance premium collection amount "0".

As the employee's retirement has been decided, the employee information is updated to include the retirement date "2022/12/31," social insurance classification "0: Not applicable," and social insurance termination date "2023/10/1," as shown in Figure 10.

For payroll calculations, the target year and month > the month of social insurance loss (the month of the social insurance loss date), the social insurance acquisition date ≠ the social insurance loss date, and the social insurance acquisition date (month) ≠ the social insurance loss date (month), so the update pattern (3) above is processed and the social insurance collection category in the employee information is set to "5: Exempt". As the social insurance collection category is "Exempt," the insurance premium collection amount is set to "0 yen".

(Case 3: Acquisition and loss of social insurance eligibility in the same month)
11 and 12, we will explain the case of CASE 3 (when social insurance eligibility is acquired and lost in the same month). CASE 3 is an example in which the above update pattern (3) is applied. The target year and month for payroll calculation is 2022/10. Assume that employee information such as that shown in FIG. 11 is registered. The employee information is assumed to be the target year and month "202210", employee number "300", joining date "2022/9/1", retirement date "", social insurance category "1: target", social insurance acquisition date "2022/9/1", social insurance loss date "", social insurance collection category "0: normal", grade "10", previous month's insurance premium "0", current month's insurance premium "0", and insurance premium collection amount "0".

As the employee has decided to resign, the retirement date is updated to "2022/9/20," the social insurance classification to "0: Not applicable," and the social insurance termination date to "2022/9/21," as shown in Figure 12.

In payroll calculations, the target year and month = social insurance acquisition month (month of social insurance acquisition date) + 1 month, the target year and month = social insurance loss month (month of social insurance loss date) + 1 month, and the social insurance acquisition date < social insurance loss date, the social insurance acquisition date ≠ social insurance loss date, and the social insurance acquisition month = social insurance loss month, so the above update pattern (3) is processed, and using the current month's grade "10" as the key, "1,000 yen" is retrieved from the social insurance premium table master 106a, and "1,000 yen" is set as the previous month's insurance premium. Since the social insurance collection category is "0: Normal", the previous month's insurance premium "1,000 yen" is set as the insurance premium collection amount.

(CASE (4): Acquisition and loss of social insurance qualifications on the same day)
13 and 14, we will explain CASE (4) (when social insurance eligibility is acquired and lost on the same day). CASE (4) is an example in which the above update pattern (4) is applied. The target year and month for payroll calculation is 2022/10. Assume that employee information such as that shown in FIG. 13 is registered. The employee information is as follows: target year and month "202210", employee number "400", joining date "2023/9/1", retirement date "", social insurance category "1: target", social insurance acquisition date "2023/9/1", social insurance loss date "", social insurance collection category "0: normal", grade "10", previous month's insurance premium "1000", current month's insurance premium "1000", and insurance premium collection amount "0".

As the employee's retirement and joining have been decided, the employee information is updated to include the joining date "2023/1/1", retirement date "2022/12/31", social insurance acquisition date "2023/1/1", and social insurance termination date "2023/1/1", as shown in Figure 14.

In payroll calculations, the social insurance acquisition date is the same as the social insurance loss date, so the update process will not be performed using update pattern (4). Since the social insurance collection category is "0: Normal," the previous month's insurance premium of "1,000 yen" is set as the insurance premium collection amount.

[3-3. Previous month's insurance premium calculation process]
15 to 18, an example of the previous month's insurance premium calculation process will be explained. In FIG. 15, the target year and month for payroll calculation is 2022/10. Assume that employee information such as that shown in FIG. 15 has been registered. The employee information is assumed to be the target year and month "202210", employee number "100", joining date "2022/9/1", retirement date "", social insurance category "1: target", social insurance acquisition date "2022/9/1", social insurance loss date "", social insurance collection category "0: normal", grade "10", previous month's insurance premium "0", current month's insurance premium "0", and insurance premium collection amount "0".

In Figure 16, when calculating payroll, if social insurance premium category = 1: applicable, the current month's insurance premium is updated, and the social insurance premium is obtained from the social insurance premium table master 106a using the employee information grade as a key, and the amount is set as the current month's insurance premium. In this example, the social insurance premium amount of "1,000 yen" is obtained from the social insurance premium table master 106a using the employee information grade "10" as a key, and the current month's insurance premium is updated to "1,000 yen".

When registering a payroll date, employee information data for the target year/month + 1 month is generated (updated). When registering a payroll date, employee information data for the target year/month + 1 month is generated (updated) after the payroll calculation process for the target year/month is completed. In this example, employee information data for 2022/11 is generated.

Figure 17 is a diagram explaining the contents of the salary payment date registration. The employee number, date of employment, date of retirement, social insurance category, social insurance acquisition date, social insurance loss date, social insurance collection category, and grade are set as is to the data for the target year and month minus one month. The previous month's insurance premium is set to the amount of the current month's insurance premium for the target year and month minus one month. The current month's insurance premium and insurance premium collection amount are set to 0 yen.

Figure 18 shows an example of employee information after the payday has been registered. As shown in Figure 18, the previous month's insurance premium is set to the amount of the current month's insurance premium for October 2022, which is the target year and month minus one month, which is 1,000 yen. The current month's insurance premium and insurance premium collection amount are set to 0 yen.

As described above, this embodiment includes an employee information registration unit 102a that registers and updates the employee information's salary payment date, employee number, joining date, retirement date, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and grade in response to the operations of the employee, and a social insurance premium processing unit 102b that, when calculating the salary for the target month, updates the social insurance collection category or previous month's insurance premium for the employee information for each employee number based on the social insurance qualification acquisition date and social insurance qualification loss date, and calculates and updates the insurance premium collection amount based on the social insurance collection category. This makes it possible to reduce the burden on employees when calculating social insurance premium collection amounts in industries with high employee turnover.

[4. 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 the achievement of SDGs Goals 8 and 9.

Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to SDGs goals 12, 13, and 15.

Furthermore, this embodiment can contribute to strengthening control and governance, thereby contributing to Goal 16 of the SDGs.

5. Other Embodiments
The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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

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

Furthermore, with regard to the social insurance premium processing device 100, the components shown in the figure are functional concepts and do not necessarily have to be physically configured as shown in the figure.

For example, all or any part of the processing functions of the social insurance premium processing device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory 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 social insurance premium processing device 100 as needed. In other words, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) that works with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

In addition, this computer program may be stored on an application program server connected to the social insurance premium processing device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes memory cards, USB (Universal Serial Bus) memories, 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 more. This includes any "portable physical media" such as a Blu-ray Disc (registered trademark) and a Blu-ray Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. It should be noted that a "program" is not necessarily limited to a single structure, but also includes a distributed structure consisting of multiple modules or libraries, or a structure that achieves its function by working in conjunction with a separate program, such as an OS. The specific structure and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known structures and procedures.

The various databases stored in the memory unit are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

The social insurance premium processing device 100 may also be configured as an information processing device such as a known personal computer or workstation, or as such an information processing device to which any peripheral device is connected. The social insurance premium processing device 100 may also be realized by installing software (including programs or data, etc.) that causes the device to perform the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments may be implemented in any combination, or embodiments may be implemented selectively.

100 Social insurance premium processing device 102 Control unit 102a Employee information registration unit 102b Social insurance premium processing unit 102c Master maintenance unit 102d Screen display control unit 104 Communication interface unit 106 Storage unit 106a Social insurance premium table master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (3)

A social insurance premium processing device equipped with a control unit,
The control unit
The system is configured to be able to access a memory area that stores employee information including the target year and month of salary payment, employee number, date of joining the company, date of retirement, social insurance category, date of social insurance qualification acquisition, date of loss of social insurance qualification, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount,
an employee information registration means for registering and updating the employee information, such as the salary payment date, employee number, employment date, retirement date, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and grade, in response to an operation by a person in charge;
and a social insurance premium processing means for updating the social insurance collection category or the previous month's insurance premium for each employee information based on the date of social insurance qualification acquisition and the date of social insurance qualification loss when calculating the payroll for the target month, and for calculating and updating the amount of insurance premium to be collected based on the social insurance collection category,
The social insurance premium processing means
If the target year and month - January = the month of the social insurance qualification acquisition date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, the social insurance collection category is set to "the month before joining the company" as the processing of update pattern (1),
If the target year and month > the month of the social insurance qualification loss date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, set the social insurance collection category to "Exemption" as the processing of update pattern (2),
If the month of the social insurance qualification acquisition date is equal to the month of the social insurance qualification loss date, and the social insurance qualification acquisition date is not equal to the social insurance qualification loss date, update pattern (3) is processed and the amount is set to the previous month's insurance premium.
If the date of social insurance qualification acquisition is equal to the date of social insurance qualification loss, the renewal will not be carried out as renewal pattern (4).
In the case of joining social insurance at the time of employment or joining at a time other than the time of employment, the processing of the renewal pattern (1) is carried out; in the case of social insurance loss at retirement, including mid-month retirement and end-of-month retirement, loss other than retirement, including contract change, and same-day acquisition or loss due to transfer, the processing of the renewal pattern (2) is carried out; in the case of social insurance acquisition or loss in the same month, the processing of the renewal pattern (3) is carried out; and in the case of social insurance acquisition or loss on the same day due to re-employment at retirement age, the processing of the renewal pattern (4) is carried out.
The control unit further
The system is configured to be able to access a social insurance premium table master that associates grades with social insurance premiums and registers them.
The social insurance premium processing means is characterized in that if the social insurance collection category is "normal", it sets the previous month's insurance premium as the insurance premium collection amount, if the social insurance collection category is "exempt", it sets 0 yen as the insurance premium collection amount, if the social insurance collection category is "previous month at time of joining", it sets 0 yen as the insurance premium collection amount if the social insurance category is "non-eligible", and if it is "eligible", it retrieves the social insurance premium from the social insurance premium table master using the grade of the employee information as a key and sets the amount as the insurance premium collection amount . A social insurance premium processing method executed by an information processing device having a control unit,
The control unit is configured to be able to access a memory area that stores employee information including the target year and month of salary payment, employee number, date of joining the company, date of retirement, social insurance category, date of social insurance qualification acquisition, date of loss of social insurance qualification, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount;
Executed in the control unit:
an employee information registration process for registering and updating the employee information, such as the salary payment date, employee number, joining date, retirement date, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and grade, in response to an operation by a person in charge;
a social insurance premium processing step for updating the social insurance collection category or the previous month's insurance premium for each employee information based on the date of social insurance qualification acquisition and the date of social insurance qualification loss when calculating the payroll for the target month, and calculating and updating the amount of insurance premium to be collected based on the social insurance collection category;
Including,
In the social insurance premium processing step,
If the target year and month - January = the month of the social insurance qualification acquisition date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, the social insurance collection category is set to "the month before joining the company" as the processing of update pattern (1),
If the target year and month > the month of the social insurance qualification loss date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, set the social insurance collection category to "Exemption" as the processing of update pattern (2),
If the month of the social insurance qualification acquisition date is equal to the month of the social insurance qualification loss date, and the social insurance qualification acquisition date is not equal to the social insurance qualification loss date, update pattern (3) is processed and the amount is set to the previous month's insurance premium.
If the date of social insurance qualification acquisition is equal to the date of social insurance qualification loss, the renewal will not be carried out as renewal pattern (4).
In the case of joining social insurance at the time of employment or joining at a time other than the time of employment, the processing of the renewal pattern (1) is carried out; in the case of social insurance loss at retirement, including mid-month retirement and end-of-month retirement, loss other than retirement, including contract change, and same-day acquisition or loss due to transfer, the processing of the renewal pattern (2) is carried out; in the case of social insurance acquisition or loss in the same month, the processing of the renewal pattern (3) is carried out; and in the case of social insurance acquisition or loss on the same day due to re-employment at retirement age, the processing of the renewal pattern (4) is carried out.
The control unit further
The system is configured to be able to access a social insurance premium table master that associates grades with social insurance premiums and registers them.
In the social insurance premium processing step, if the social insurance collection category is "normal", the insurance premium collection amount is set to the previous month's insurance premium, if the social insurance collection category is "exempt", the insurance premium collection amount is set to 0 yen, if the social insurance collection category is "previous month at time of joining", if the social insurance category is "non-eligible", the insurance premium collection amount is set to 0 yen, if the social insurance category is "eligible", the social insurance premium is obtained from the social insurance premium table master using the grade of the employee information as a key, and the amount is set to the insurance premium collection amount . A social insurance premium processing program to be executed by an information processing device having a control unit,
The control unit
The system is configured to be able to access a memory area that stores employee information including the target year and month of salary payment, employee number, date of joining the company, date of retirement, social insurance category, date of social insurance qualification acquisition, date of loss of social insurance qualification, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount,
The control unit
an employee information registration process for registering and updating the employee information, such as the salary payment date, employee number, joining date, retirement date, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and grade, in response to an operation by a person in charge;
a social insurance premium processing step for updating the social insurance collection category or the previous month's insurance premium for each employee information based on the date of social insurance qualification acquisition and the date of social insurance qualification loss when calculating the payroll for the target month, and calculating and updating the amount of insurance premium to be collected based on the social insurance collection category;
This is a social insurance premium processing program to execute the following:
In the social insurance premium processing step,
If the target year and month - January = the month of the social insurance qualification acquisition date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, the social insurance collection category is set to "the month before joining the company" as the processing of update pattern (1),
If the target year and month > the month of the social insurance qualification loss date, the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the month of the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, set the social insurance collection category to "Exemption" as the processing of update pattern (2),
If the month of the social insurance qualification acquisition date is equal to the month of the social insurance qualification loss date, and the social insurance qualification acquisition date is not equal to the social insurance qualification loss date, update pattern (3) is processed and the amount is set to the previous month's insurance premium.
If the date of social insurance qualification acquisition is equal to the date of social insurance qualification loss, the renewal will not be carried out as renewal pattern (4).
In the case of joining social insurance at the time of employment or joining at a time other than the time of employment, the processing of the renewal pattern (1) is carried out; in the case of social insurance loss at retirement, including mid-month retirement and end-of-month retirement, loss other than retirement, including contract change, and same-day acquisition or loss due to transfer, the processing of the renewal pattern (2) is carried out; in the case of social insurance acquisition or loss in the same month, the processing of the renewal pattern (3) is carried out; and in the case of social insurance acquisition or loss on the same day due to re-employment at retirement age, the processing of the renewal pattern (4) is carried out.
The control unit further
The system is configured to be able to access a social insurance premium table master that associates grades with social insurance premiums and registers them.
A social insurance premium processing program characterized in that, in the social insurance premium processing step, if the social insurance collection category is "normal", the previous month's insurance premium is set as the insurance premium collection amount, if the social insurance collection category is "exempt", 0 yen is set as the insurance premium collection amount, if the social insurance collection category is "previous month at time of joining", if the social insurance category is "non-eligible", 0 yen is set as the insurance premium collection amount, and if it is "eligible", the social insurance premium is obtained from the social insurance premium table master using the grade of the employee information as a key, and the amount is set as the insurance premium collection amount.