Social insurance premium processing device, social insurance premium processing method, and social insurance premium processing program

Abstract

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 personnel involved in calculating the amount of social insurance premium collection in an industry where many employees enter and leave the company.SOLUTION: A social insurance premium processing device according to the present embodiment comprises employee information registration means that registers and updates employee information such as employee number, date of hire, date of retirement, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and a grade, for the subject salary payment period, and social insurance premium processing means that, at the time of salary calculation for the subject payment period, for each employee number, update the social insurance premium collection category or the previous month's premium based on the social insurance qualification acquisition date and the social insurance qualification loss date with respect to the employee information, and calculates and updates the amount of social insurance premium collection based on the social insurance premium collection category.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a social insurance premium processing device, a social insurance premium processing method, and a social insurance premium processing program. [Background technology]

[0002] For example, in the past, the calculation of the amount of social insurance premiums to be collected required a person in charge to determine whether or not a person was eligible for social insurance when they acquired or lost their eligibility for social insurance, and to maintain the classification and calculate the amount of social insurance premiums. For example, Patent Document 1 is an example of a conventional system for calculating social insurance premiums. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent No. 5917785 Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not mention anything about reducing the burden on the person in charge of calculating the amount of social insurance premiums to be collected in an industry where there is a high rate of joining and leaving the company.

[0005] The present invention has been 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 personnel when calculating social insurance premium collection amounts in industries with a high rate of employee joining and leaving the company. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a social insurance premium processing device equipped with a control unit, wherein 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 social insurance qualification loss, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount, and is characterized by comprising: employee information registration means that registers and updates the target year and month of salary payment, employee number, date of joining the company, 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 accordance with the operation of a person in charge; and social insurance premium processing means that, when calculating the salary 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.

[0007] 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, and the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, and the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss date, and the social insurance qualification acquisition date ≠ the month of the social insurance qualification loss, and the social insurance premium collection category is set to "exempt" as part of update pattern (2), and process update pattern (3) by setting the amount as the previous month's insurance premium, and if the social insurance qualification acquisition date = the social insurance qualification loss date, and the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the social insurance qualification loss date is not equal to the social insurance qualification loss date, and the social insurance qualification acquisition date ≠ the social insurance qualification loss date, and the social insurance premium processing means may process update pattern (4) by not updating the category.

[0008] Furthermore, according to one aspect of the present invention, in the case of joining social insurance at the time of employment or joining at any time other than the time of employment, the processing of the update pattern (1) is performed, in the case of loss of social insurance 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, the processing of the update pattern (2) is performed, in the case of gaining or losing social insurance in the same month, the processing of the update pattern (3) is performed, and in the case of gaining or losing on the same day due to re-employment at retirement age, the processing of the update pattern (4) may be performed.

[0009] 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 is registered by associating grades with social insurance premiums, and the social insurance premium processing means sets the previous month's premium as the premium collection amount 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 ``previous month at time of joining,'' and if the social insurance category is ``non-eligible,'' sets the premium collection amount to 0 yen, and if it is ``eligible,'' obtains 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 premium collection amount.

[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a social insurance premium processing method executed by an information processing device equipped with a control unit, wherein 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 social insurance qualification loss, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount, and the method includes an employee information registration process executed by the control unit, which registers and updates the target year and month of salary payment, employee number, date of joining the company, date of retirement, social insurance qualification acquisition date, date of social insurance qualification loss, social insurance collection category, and grade of the employee information in accordance with the operation of a person in charge, and a social insurance premium processing process which, 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 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 for each employee number.

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a social insurance premium processing program to be executed by an information processing device equipped with a control unit, wherein 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 social insurance qualification loss, social insurance collection category, grade, previous month's insurance premium, current month's insurance premium, and insurance premium collection amount, and the control unit executes an employee information registration process in accordance with the operation of a person in charge, which registers and updates the target year and month of salary payment, employee number, date of joining the company, 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, and a social insurance premium processing process in which, when calculating the payroll for the target year and month, for each employee number, the social insurance collection category or the previous month's insurance premium is updated based on the social insurance qualification acquisition date and date of social insurance qualification loss, and the insurance premium collection amount is calculated and updated based on the social insurance collection category. [Effects of the Invention]

[0012] According to the present invention, in an industry where there is a high rate of employees joining and leaving the company, it is possible to reduce the burden on the person in charge of calculating the amount of social insurance premiums to be collected. [Brief explanation of the drawings]

[0013] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a social insurance premium processing device according to this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the configuration of the social insurance premium table master. [Figure 3] 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. [Figure 4] 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. [Figure 5] 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. [Figure 6] 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. [Figure 7] 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. [Figure 8] 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. [Figure 9] 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. [Figure 10] 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. [Figure 11] 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. [Figure 12] 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. [Figure 13] 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. [Figure 14] 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. [Figure 15] 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. [Figure 16] 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. [Figure 17] 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. [Figure 18] 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. DETAILED DESCRIPTION OF THE INVENTION

[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0015] [1. Overview] Previously, to calculate the amount of social insurance (hereinafter sometimes abbreviated as "social insurance") premiums to be collected, a person in charge would determine whether or not an employee was eligible for social insurance when they gained or lost eligibility, 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), employees frequently gain or lose eligibility, and special cases such as gaining or losing eligibility 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 required specialized knowledge, placing a heavy burden on the person in charge.

[0016] In this invention, the amount of social insurance premiums to be collected is automatically calculated based on the employee's date of social insurance qualification acquisition (hereinafter sometimes abbreviated as "social insurance qualification date") and the date of social insurance qualification loss (hereinafter sometimes abbreviated as "social insurance loss date"), thereby reducing the burden on the person in charge of calculating the amount of social insurance premiums to be collected.

[0017] Specifically, in this invention, when calculating payroll, both the date of social insurance acquisition and the date of social insurance loss are referenced, the social insurance collection category and the previous month's insurance premium are calculated, and the amount of social insurance premium to be collected is automatically calculated based on the social insurance collection category.

[0018] According to the present invention, for example, when there is a large number of employees joining and leaving the company, the burden on the person in charge of setting social insurance collection categories for each employee is heavy. However, the person in charge can now complete the process by only processing the joining and leaving of employees, which significantly reduces the effort required to calculate the amount of social insurance premiums to be collected when calculating payroll.

[0019] 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.).

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

[0021] 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 a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0022] 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 as to be able to communicate with each other via any communication path.

[0023] The communication interface unit 104 communicably 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 a function of communicating data with other devices via a communication line. Here, the network 300 has a 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).

[0024] 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 cooperation with a mouse. In the following, 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.

[0025] Various databases, tables, files, etc. are stored in the storage unit (storage area) 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage 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, an optical disk, etc.

[0026] The storage unit 106 also stores a social insurance premium table master 106a, employee qualifications, etc. Fig. 2 is a diagram showing an example of the configuration of the social insurance premium table master 106a.

[0027] The social insurance premium table master 106a can be configured as a table or the like in which grades and social insurance premium amounts are registered in association with each other, as shown in FIG.

[0028] 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 applicable, 1: applicable), 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).

[0029] The control unit 102 is a CPU or the like that comprehensively controls the social insurance premium processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs.

[0030] 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. The social insurance premium table master 106a, employee information, etc. may be stored in another location (for example, the server 200), as long as the control unit 102 is able to access them.

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

[0032] The employee information registration unit 102a is used to register and update employee information, and for example, in response to operations by a person in charge on an employee information input screen displayed on the monitor 114, it registers and updates the salary payment date, employee number, joining date, retirement date, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, grade, etc. of the employee information stored in the memory unit 106.

[0033] When calculating the payroll for the target month, the social insurance premium processing unit 102b updates the social insurance collection category or the 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.

[0034] In addition, the social insurance premium processing unit 102b 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 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; process update pattern (2) by setting the social insurance collection category to "exemption" 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; 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 acquisition date = the month of the social insurance loss date, and the social insurance acquisition date ≠ the social insurance loss date.

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

[0036] 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 "previous month at time of 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 obtain 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.

[0037] 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 an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0038] The screen display control unit 102d controls the display of various screens (for example, a master maintenance screen, an employee information input screen, etc.) displayed on the monitor 114 and the input therefor.

[0039] [3. Specific Examples] A specific example 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 a specific example of the processing of the social insurance premium processing device 100 in this embodiment.

[0040] [3-1. Processing flow] FIG. 3 is a diagram for explaining the setting logic of 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: exemption", 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 social insurance category in FIG. (Calculation is performed even if the previous month's insurance premium is not set as a value.)

[0041] FIG. 4 is a diagram for 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 obtained from the social insurance premium table master 106a using the employee information grade as a key, and the amount is set as the insurance premium for the current month.

[0042] FIG. 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 figure, the horizontal axis indicates events that occur, including social insurance enrollment at time of joining, enrollment other than joining, 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 indicates employee information, including the date of joining, date of retirement, social insurance category, social insurance acquisition date, social insurance loss date, 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 "○."

[0043] The employee information registration unit 102a updates the items of employee information when an event occurs as follows: In the case of joining at the time of employment, the date of joining, social insurance category, and social insurance acquisition date are updated. In the case of joining other than joining, the social insurance category and social insurance acquisition date are updated. In the case of loss at time of retirement (retirement during the month), the date of retirement, social insurance category, and social insurance loss date are updated. In the case of loss at time of retirement (retirement at the end of the month), the date of retirement, social insurance category, and social insurance loss date are updated. In the case of loss other than retirement (contract change, etc.), the social insurance category and social insurance loss date are updated. In the case of gain or loss in the same month, the social insurance category, social insurance acquisition date, and social insurance loss date are updated. In the case of gain or loss on the same day (reemployment after retirement), the date of joining, date of retirement, social insurance category, social insurance acquisition date, and social insurance loss date are updated. In the case of gain or loss on the same day (transfer), the date of joining, date of retirement, social insurance category, social insurance acquisition date, and social insurance loss date are updated.

[0044] 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 FIG. 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 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.), 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 time of retirement, and update pattern (1) processing is performed at the transfer destination to process enrollment at time of 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.

[0045] 6 is a diagram illustrating the processing flow of the employee information registration unit 102a and the social insurance premium processing unit 102b. In FIG. 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 year and month, employee number, joining date, retirement date, social insurance acquisition date, social insurance loss date, social insurance collection category, and grade.

[0046] The social insurance premium processing unit 102b executes the social insurance premium calculation process when calculating the 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 collection. The update flow for the social insurance premium collection category is as follows.

[0047] First, it is determined whether the social security acquisition date is equal to the social security loss date (even if both are NULL) (Step T1). If the social security acquisition date is equal to the social security 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 the update process is not performed as update pattern (4) (Step T11).

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

[0049] 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 (change in contract, etc.), or gained or lost on the same day (transfer), and the social insurance collection category is set to "5" as processing for update pattern (2) (step T13).

[0050] If the month of loss of social insurance 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 - January (step T4). If the month of social insurance acquisition = the target year and month - January ("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 processing of update pattern (1) (step S14).

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

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

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

[0054] 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, and 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.

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

[0056] (CASE(1): In the case of obtaining social insurance qualification) With reference to Figures 7 and 8, we will explain the case of CASE (1) (when obtaining social insurance eligibility). CASE (1) is an example in which the above update pattern (1) is applied. The target year and month is 2022 / 10. In Figure 7, the employee information is registered as follows: 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".

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

[0058] (CASE (2): Loss of social insurance eligibility) 9 and 10, we will explain the case of 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 Figure 9 has been 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 classification "1: Target", social insurance acquisition date "2022 / 9 / 1", social insurance loss date " ", social insurance collection classification "0: Normal", grade "10", previous month's insurance premium "1000", current month's insurance premium "1000", and insurance premium collection amount "0".

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

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

[0061] (CASE 3: Acquisition or loss of social insurance status in the same month) With reference to Figures 11 and 12, we will explain the case of CASE 3 (when social insurance eligibility is acquired or 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 Figure 11 has been 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".

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

[0063] 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, "1000 yen" is retrieved from the social insurance premium table master 106a, and "1000 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 "1000 yen" is set as the insurance premium collection amount.

[0064] (CASE (4): Acquisition and loss of social insurance qualifications on the same day) With reference to Figures 13 and 14, we will explain the case of CASE (4) (when social insurance eligibility is acquired or 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 Figure 13 has been 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".

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

[0066] In payroll calculation, the social insurance acquisition date is the same as the social insurance loss date, so the update process is not performed according to update pattern (4). 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.

[0067] [3-3. Previous month's insurance premium calculation process] With reference to Figures 15 to 18, an example of the previous month's insurance premium calculation process will be explained. In Figure 15, the target year and month for payroll calculation is 2022 / 10. Assume that employee information such as that shown in Figure 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 classification "1: Target", social insurance acquisition date "2022 / 9 / 1", social insurance loss date " ", social insurance collection classification "0: Normal", grade "10", previous month's insurance premium "0", current month's insurance premium "0", and insurance premium collection amount "0".

[0068] 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 of "1000 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 "1000 yen".

[0069] When registering the payroll date, employee information data for the target year / month + 1 month is generated (updated). When registering the 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.

[0070] Figure 17 is a diagram to explain the contents of the salary payment date registration. The employee number, date of joining, date of leaving, social insurance category, date of social insurance acquisition, date of loss of social insurance, social insurance collection category, and grade are set as is from the target year / month - 1 month. The previous month's insurance premium is set to the amount of the current month's insurance premium from the target year / month - 1 month. The current month's insurance premium and insurance premium collection amount are set to 0 yen.

[0071] 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 one month after the target year and month, which is "1,000 yen." The current month's insurance premium and the amount of insurance premium collected are set to 0 yen.

[0072] As explained above, according to this embodiment, there is provided an employee information registration unit 102a which registers and updates the employee information such as the target year and month of salary payment, employee number, joining date, leaving date, social insurance qualification acquisition date, social insurance qualification loss date, social insurance collection category, and grade in response to operations by the person in charge, and a social insurance premium processing unit 102b which, when calculating the salary for the target year and month, updates the social insurance collection category or the 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. Therefore, in industries with a high rate of joining and leaving the company, it is possible to reduce the burden on the person in charge when calculating the social insurance premium collection amount.

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

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

[0075] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

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

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

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

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

[0080] 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 realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the social insurance premium processing device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0081] In addition, this computer program may be stored in an application program server connected to the social insurance premium processing device 100 via any network, and it is also possible to download all or part of it as needed.

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

[0083] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0084] The various databases stored in the memory unit are storage means 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 providing websites.

[0085] The social insurance premium processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the 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) that causes the device to perform the processing described in this embodiment.

[0086] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0087] 100 Social insurance premium processing equipment 102 Control section 102a Employee Information Registration Department 102b Social Insurance Premium Processing Department 102c Master Maintenance Department 102d Screen display control unit 104 Communication interface unit 106 Storage section 106a Social Insurance Premium Table Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

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

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

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

Images