JP2006285746A - Allowance calculating device and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To improve business efficiency by calculating the gross amount of allowance for ensuring a preset net income of an employee, and by easily coping with a change in various data by the situation of an employee, a legal reform, or the like. <P>SOLUTION: An allowance calculating device 1 for calculating a balancing allowance according to the conditions of the employee on the basis of a group of pieces of information for allowance calculation comprises an input section 12 to which a setting deduction item and the setting instruction of the preset net income are inputted; a temporary allowance calculation means for calculating the sum of the temporary gross amount of allowance by adding the amount of the deduction item of a fixed amount from the setting deduction item; a balancing allowance calculation means for calculating the balancing allowance by referring to the group of pieces of information for allowance calculation for subtracting the amount of deduction corresponding to the setting deduction item from the temporary gross amount of allowance; and a CPU 10 that compares the balancing allowance with the preset net income, and functions as a control means for performing control so that the calculation processing of the balancing allowance is repeated until the balancing allowance coincides with the preset net income. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a supply amount calculation device and a program for calculating an employee's salary.

  Employers of employees, such as companies and organizations that pay salaries, calculate the total amount of payment, including the basic salary and overtime allowance, etc. for employees, and various social insurance premiums, The deduction amount calculated by deducting the amount of income tax, resident tax, company rent, property type, etc. and making various deductions from the total payment amount is paid to the employee.

In such a salary calculation, a complicated calculation process based on a lot of data and a flexible payment calculation process according to a user's request are difficult depending on the calculation time and the form of the payment method. Therefore, as a method for selecting the payment method according to the user's request, program storage means for storing the current month payment method payroll calculation program and the next month payment method calculation program, and data for selecting the required payment method And a payroll calculation processing section for selecting a payroll program from the program storage means according to data set in the payroll data setting means based on a payroll calculation instruction and executing payroll calculation. A salary calculation system is disclosed (see Patent Document 1).
Japanese Patent Laid-Open No. 2003-76817

  However, in the conventional payment amount calculation process, for example, when an employment contract between the user and the employee is determined in advance, a take-out amount desired by the employee (hereinafter referred to as a guarantee amount) is determined in advance. In order to make the amount of deductions paid to employees equal to the amount of guarantee, the calculated amount of deductions is compared with the amount of guarantee, and if they do not match, the user who calculates the amount of deduction is arbitrarily informed. The total amount of payment must be changed and the subsidy amount calculated again, and the total amount must be changed and calculated manually several times until the subsidy amount and the guarantee amount match. This is a time-consuming and complicated task.

  The problem of the present invention is that it is possible to calculate the total amount of payment that can secure the employee's guaranteed amount set in advance, and that it can easily cope with changes in various data due to employee circumstances and legal revisions, etc. Is to improve.

The invention described in claim 1 corresponds to a deduction item setting instruction and the set deduction item in the payment amount calculation device that calculates a deduction payment amount according to the conditions of the employee based on the payment amount calculation information group An input means for inputting a setting instruction for a security amount preset as a payment amount after the amount to be deducted, and a fixed amount of deduction items among the deduction items set and specified for the security amount And a provisional payment calculation means for calculating a provisional total payment amount by subtracting the deduction amount corresponding to the deduction item from the provisional total payment amount with reference to the payment amount calculation information group. The subsidy amount calculation means for calculating the subsidy amount, the subsidy amount and the guarantee amount are compared, and the subtraction amount is calculated so as to repeat the calculation process of the subsidy amount until the subsidy amount and the guarantee amount match. Control means for controlling the calculation means; It is payments calculation device comprising, it is characterized.
Furthermore, a program for causing a computer to function the main means shown in the invention described in claim 1 is provided (the invention described in claim 8).

  According to the inventions of claims 1 and 8, since the total payment amount that can secure the security amount is calculated only by inputting the security amount and the setting deduction item, the operational efficiency can be improved, and The total payment amount can be calculated in a short time by calculating the provisional total payment amount by adding the fixed amount of the deduction item amount to the guaranteed amount from the set deduction items.

  According to the invention described in claim 2, when it is determined that the deduction amount and the guarantee amount do not match, the difference amount between the deduction amount and the guarantee amount is added to the provisional gross payment amount, and the added provisional gross payment Since the deduction amount is calculated again based on the amount, the deduction amount can be converged to the guaranteed amount in a short time.

  According to the third aspect of the present invention, it is possible to easily set the total payment amount that can secure the guaranteed amount.

  According to the invention described in claim 4, since the total payment amount that can secure the security amount can be calculated in a short time according to the employment form of the employee, the work efficiency can be improved.

  According to the invention described in claim 5, when an employment contract is made between the employee and the user before joining the company, the employee is not qualified to participate in the health insurance premium, nursing care insurance premium and welfare pension insurance premium. In this case, since the total amount of payment that can ensure the amount of security desired by the employee can be calculated in a short time, it can be used for the salary calculation at the time of the contract, and the work efficiency can be improved.

  According to the invention described in claim 6, it is possible to calculate the total amount of payment that can secure the guaranteed amount of salary paid to the employee every month, which can be utilized for the user's funding plan.

  According to the seventh aspect of the present invention, it is possible to estimate the total amount of payment that can secure the guaranteed amount of bonus paid to the employee, and to use it for the user's financial plan.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment. The embodiment of the present invention shows the most preferable mode of the present invention, and the terminology of the present invention is not limited to this.

[Embodiment 1]
Hereinafter, Embodiment 1 of the present invention will be described in detail with reference to the drawings.
First, the configuration will be described.
FIG. 1 is a block diagram showing the configuration of the payment amount calculation apparatus 1 according to the first embodiment.
As shown in FIG. 1, the payment amount calculation device 1 includes a CPU (Central Processing Unit) 10, a storage unit 11, an input unit 12, a display unit 13, a print unit 14, a communication unit 15, and the like. Etc. are electrically connected.

  The CPU 10 reads out a system program stored in the storage unit 11, develops it in a work area formed in the storage unit 11, and controls each unit in accordance with the system program. In addition, the CPU 10 reads out various processing programs including the total salary payment calculation program stored in the storage unit 11, develops them in the work area, and executes various processes.

  The CPU 10 is selected by operating the input unit 12 from a plurality of deduction items displayed on the display screen of the display unit 13 in order to realize the first embodiment in cooperation with the storage unit 11. The input deduction item (hereinafter referred to as a set deduction item) and a salary guarantee amount set in advance as a payment amount after deduction of the amount corresponding to the set deduction item are stored in the storage unit 11 and input. Function as a provisional payment calculation means to calculate the provisional total amount of salary by adding the fixed amount of deduction items to the guaranteed amount, and the set deduction from the calculated provisional total amount Compare the function of the subsidy calculation method that calculates the subsidy amount by subtracting the various deductions corresponding to the item, the subsidy amount and the security amount, and subtract until the subsidy amount and the security amount match. Repeat the payment calculation process It realizes a function as a control means for controlling so.

  The storage unit 11 has a program storage area, a data storage area, and a work area. The program storage area stores in advance various processing programs such as a system program corresponding to the payment calculation device 1 and a total salary payment calculation program for realizing the first embodiment, and the data storage area. In order to calculate various deductions, personal insurance information group 111, company insurance information group 112, personal income tax information group 113, personal tax support information group 114, company income tax information group 115, resident tax information group 116, personal deduction information Group 117, employee salary calculation result information group 118, etc. and health insurance premium table and welfare for determining health insurance premium, nursing insurance premium, welfare pension insurance premium when qualification for social insurance office is not acquired A payment calculation information group such as an information group corresponding to the pension insurance premium amount table, various data, and the like are stored in advance. Note that the payment amount calculation information group for calculating various deductions is not special information unique to the present invention, and the calculation of the salary deduction amount that is conventionally performed as the salary deduction amount calculation processing. This is a general information group used for processing.

FIG. 2 shows an example of a payment amount calculation information group for calculating various deduction amounts.
An example of the personal insurance information group 111 is shown in FIG.
As shown in FIG. 2A, the personal insurance information group 111 stores information on various social insurances corresponding to each employee in advance, and identifies the company / organization, etc. in which the employee is employed. Company code, insurance code for identifying various insurances, employee number for identifying employees, information revision date indicating the date the record was revised, insurance name indicating the name of various insurances indicated by the insurance code, insurance name Target category indicating whether or not the employee is a target, insurance type indicating the type of the insurance name, calculation type indicating the insurance name calculation method (fixed, insurance rate, not covered), calculation category A plurality of records in which items such as fixed amount insurance premiums indicating the insurance premiums are fixed are registered. The personal insurance information group 111 stores information on the case where the salary payment amount is calculated and the case where the bonus payment amount is calculated.

  The fixed premium is the insurance premium rate set for each social insurance (health insurance, long-term care insurance, welfare annuity insurance) in the standard remuneration monthly fixed for each employee separately stored in the storage unit 11 (For example, 8.2% for health insurance, 1.25% for long-term care insurance, and 13.934% for welfare annuity insurance). Fixed amount unless changed.

FIG. 2B shows an example of the company insurance information group 112.
As shown in FIG. 2 (b), a company code for identifying the company / organization where the employee is employed, an insurance code for identifying various insurances, an information revision date indicating the date on which the record was revised, A plurality of records in which items such as an insurance name indicating the name of various insurances indicated by the insurance code, a company burden rate for the insurance name, an individual burden rate, and an overall burden rate indicating an overall insurance premium rate are registered. The company insurance information group 112 stores information on calculating the salary payment amount and calculating the bonus payment amount.

An example of the personal income tax information group 113 is shown in FIG.
As shown in FIG. 2C, the personal income tax information group 113 includes a company code for identifying a company / organization where the employee is employed, an employee number for identifying the employee, and a date when the record is revised. A plurality of records in which items such as an information revision date to be shown, a tax amount table category indicating a category applied to the employee number, and a tax table column category are defined are registered.

FIG. 2D shows an example of the personal tax support information group 114.
As shown in FIG. 2D, the personal tax support information group 114 includes a company code for identifying a company / organization where the employee is employed, an employee number for identifying the employee, and a date when the record is revised. Information revision date, automatic serial number that distinguishes each record, a relationship indicating the relationship between the employee and the dependent indicated by the employee number, tax dependent conversion number indicating the number of people for the relationship, etc. Records are stored.

FIG. 2E shows an example of the company income tax information group 115.
As shown in FIG. 2 (e), the company income tax information group 115 includes a company code for identifying a company / organization in which the employee is employed, an information revision date indicating the date when the record is revised, and an income tax on salary. A plurality of records in which items such as a salary tax calculation category indicating a calculation method for calculating the income tax and a bonus tax calculation category indicating a calculation method for calculating the income tax for the bonus are registered.

FIG. 2F shows an example of the resident tax information group 116.
As shown in FIG. 2 (f), the resident tax information group 116 includes a company code for identifying a company / organization where the employee is employed, an employee number for identifying the employee, and an employee indicated by the employee number. A plurality of records in which items such as the target year of the applicable resident tax and the monthly resident tax amount notified from the municipality are defined.

FIG. 2G shows an example of the individual deduction information group 117.
As shown in FIG. 2G, the personal deduction information group 117 includes a company code for identifying a company / organization where the employee is employed, an employee number for identifying the employee, and a deduction item number for identifying the deduction item. , The name of the deduction item indicated by the deduction item number (funding reserves, purchase money for holdings, company housing wages, etc.) When the date is not set, for example, a sequential number of 9 is indicated.), A plurality of records in which items such as a deduction amount for the deduction item are defined are registered.

An example of the employee salary calculation result information group 118 is shown in FIG.
As shown in FIG. 2 (h), the employee salary calculation result information group 118 includes a company code for identifying a company / organization where the employee is employed, an employee number for identifying the employee, and an employee indicated by the employee number. Payment date, salary or bonus payment to the person, various payment items (vocational ability salary, age salary, etc.), total payment amount indicating the total amount of various payment items, deduction after various deductions to the total payment amount A plurality of records in which items such as various calculation results such as amounts are stored are registered.

  The storage unit 11 includes a storage medium such as a magnetic or optical recording medium, a non-volatile memory that can be read and erased electrically by the CPU 10 such as a semiconductor memory, or a volatile memory. This storage medium includes a portable medium such as a CD-ROM (Compact Disc Read Only Memory) and a memory card, and a fixed medium such as a hard disk.

  The input unit 12 includes a keyboard having cursor keys, numeric input keys, various function keys, and the like, a mouse that is a pointing device, and the like. Is output to the CPU 10, and a setting instruction for a security amount set in advance by a contract between an employee and a user and a selection instruction for a security deduction item to be covered by a security amount from a plurality of deduction items are input. Input means.

  The display unit 13 is configured by a display screen such as an LCD (Liquid Crystal Display), for example, and displays various information such as a captured image and various operation screens on the display screen according to instructions of a display signal input from the CPU 10. Display means.

  The printing unit 14 is a printing unit of an ink jet type, a laser type, a thermal type, or the like, and, according to an instruction from the CPU 10, data on the total supply amount calculation result of the present invention, image data, etc. An image including characters and symbols is recorded.

  The communication unit 15 is configured by a modem (MODEM: Modulator / DEModulater) or a terminal adapter (TA: Terminal Adapter), a network card, and the like, and externally via a communication network such as a WAN (Wide Area Network) or a LAN (Local Area Network). Control to communicate with the device.

  FIG. 3 shows an example of the total salary payment calculation start screen G0 displayed on the display screen when the total salary payment calculation processing in the first embodiment is executed.

  As shown in FIG. 3, the salary total payment calculation start screen G0 is a calculation date input field G1 for inputting a date for calculating the total salary payment, an employee for setting a target person for calculating the total salary Number input field G2a, employee name display field G2b in which an employee name corresponding to the employee number input in the employee number input field G2a is displayed, a security amount setting area G3 for setting a salary security amount, and various social insurance premiums Social insurance premium setting area G4 to be set, income tax setting area G5 to set income tax, other deduction setting area G6 to set other deductions such as resident tax, property, and reserve, salary based on the contents of the above various setting areas A calculation start button G7 for instructing the start of the total payment amount calculation process.

  The security amount setting area G3 includes a taxable payment input field G3a for inputting a taxable payment amount, a non-taxable payment amount field G3b for inputting a non-taxable payment amount, a taxable payment input field G3a, and a non-taxable payment amount input field. Guarantee amount display field G3c in which the amount of salary guaranteed obtained by adding the numerical value input to G3b is displayed, and what deduction items the amount displayed in the amount display field G3c is from the total salary payment There is a setting deduction item column G3d indicating whether the amount is the amount obtained by subtracting the amount.

  The setting deduction item column G3d can be arbitrarily set from a plurality of deduction items. For example, in the case of income tax only, social insurance premiums (health insurance, long-term care insurance, welfare pension insurance, employment insurance, welfare pension fund) and income tax, social insurance premiums, income tax and resident tax, Thus, it is possible to select and set from patterns in which a plurality of deduction items are combined.

  The taxable payment input field 3a and the non-taxable payment input field 3b include an employee salary calculation result information group when the employee salary calculation result information group 118 includes data indicating the calculation result of the salary corresponding to the employee number. It may be read from 118 and displayed.

  In the social insurance premium setting area G4, employees corresponding to the employee number entered in the employee number input field G2a for each social insurance (health insurance, long-term care insurance, employee pension insurance, employment insurance, employee pension fund) If the subject category column G4a and whether the subject category column G4a is the subject, the fixed amount display column in which the fixed amount is displayed when the corresponding social insurance premium is a fixed amount. When G4b and various qualifications for social insurance offices have not been acquired due to circumstances before joining the company, etc. (Health insurance premiums, nursing care insurance premiums and employee pension insurance premiums for employees to be calculated are included in the personal insurance information group 111. A check box G4c is provided to indicate that it is not registered.

  In the target classification column G4a and the fixed amount display column G4b, information corresponding to the employee number input to the employee number input column G2a from the personal insurance information group 111 of the storage unit 11 is read and displayed.

  The target classification column G4a and the fixed amount display column G4b can be changed to other information on the total salary payment calculation start screen G0, and the changed information is reflected and changed in the personal insurance information group 111. .

  In the income tax setting area G5, various information related to the income tax of the employee corresponding to the employee number entered in the employee number input field G2a is displayed in the tax table classification display field G5a, tax table field classification display field G5b, tax dependent number display field G5c. And an income tax calculation method display field G5d.

  The tax amount table classification display column G5a and the tax table column classification display column G5b read the tax amount table classification and the tax table column classification corresponding to the employee number input to the employee number input field G2a from the personal income tax information group 113 of the storage unit 11. Each is displayed.

  In the tax support person number display column G5c, the total of tax support conversion number corresponding to the employee number input to the employee number input column G2a from the personal tax support information group 114 of the storage unit 11 is displayed.

  In the income tax calculation method display column G5d, the salary tax calculation classification indicated by the company code corresponding to the employee number input in the employee number input column G2a from the company income tax information group 115 of the storage unit 11 is read and displayed.

  The tax table classification display field G5a, the tax table field classification display field G5b, and the income tax calculation method display field G5d can be changed to other information on the total salary calculation calculation start screen G0. It is reflected and changed in the income tax information group 113 and the income tax calculation method display column G5d.

  The other deduction amount setting area G6 includes a resident tax display column G6a and another deduction amount display column G6b.

  In the resident tax display field G6a, the date entered in the calculation date entry field from the resident tax information group 116 of the storage unit 11 and the amount of the resident tax corresponding to the employee number entered in the employee number entry field G2a are read out. The other deduction amount display column G6b is displayed with the total amount of deduction corresponding to the employee number input to the employee number input column G2a from the personal deduction information group 117 of the storage unit 11.

  The resident tax display field G6a and the other deduction amount display field G6b can be changed to other information on the salary total payment calculation start screen G0.

Next, the operation of the first embodiment will be described.
FIG. 4 shows the flow of the total salary payment calculation process in the first embodiment.

  First, the total salary calculation calculation start screen G0 is displayed on the display screen of the display unit 13, and the date and employee number are displayed in the calculation date input field G1 and the employee number input field G2a when the input unit 12 is operated by the user. When entered, the employee name display field G2a displays the name of the employee to be calculated, a security amount setting area G3, a social insurance premium setting area G4, an income tax setting area G5, and other deduction amount setting area G6. Each information is displayed on (Step S1).

  When the input unit 12 is operated by the user, when a numerical value is input to the taxable payment input field G3a and the non-taxable payment input field G3b, the salary security amount S is calculated, and the security amount display field G3c is calculated. The paid salary guarantee amount S is displayed and set (step S2).

  Further, a setting deduction item is selected by operating the setting deduction item column G3b by operating the input unit 12 by the user (step S3).

  After the setting deduction item is selected, various pieces of information corresponding to the selected setting deduction item are set in order to calculate the subsidy amount B (step S4). For example, when the set deduction item is selected as income tax, social insurance premium, etc., the information in the other deduction setting area G6 is set not to be used for calculating the total payment amount and is displayed in a shaded manner.

  The user operates the calculation start button G7 by operating the input unit 12 after confirming the total salary payment calculation start screen G0 in which various information is set. When the calculation start button G7 is operated, the fixed amount of deduction items from the set deduction items is added to the guaranteed amount S, and the provisional total payment amount A is calculated (step S5).

  When the provisional total payment amount A is calculated, the calculation processing of the salary deduction payment amount B, which is conventionally performed as the salary deduction payment amount calculation processing, is executed (steps S6 to S10). However, the deduction processing is not executed for the deduction items that are not included in the selected set deduction items.

  A calculation process (steps S <b> 6 to S <b> 10) of the salary deduction payment amount B that is conventionally performed as the salary deduction payment calculation process will be described.

  When the provisional total amount A is calculated, the personal insurance information group 111 and the company insurance information group 112 are read from the storage unit 11 to calculate various social insurance premiums, and various societies calculated from the provisional total amount A are calculated. The insurance premium is deducted (step S6).

  Then, the personal income tax information group 113, the personal dependent information group 114, and the company income tax information group 115 are read from the storage unit 11, the income tax is calculated, and the calculated income tax is deducted (step S7).

  Further, the resident tax information group 116 is read from the storage unit 11 to calculate the resident tax, and the calculated resident tax is deducted (step S8).

  The personal deduction information group 117 is read from the storage unit 11 to calculate the other deduction amount, and the calculated other deduction amount is deducted (step S9).

  By performing the deduction processing of steps S6 to S10, a subsidy payment amount B is calculated (step S10).

  When the deduction payment amount B is calculated, it is determined whether or not the calculated deduction payment amount B matches the guarantee amount S (step S11).

  When it is determined that the difference payment amount B and the security amount S do not match (step S11; No), the difference amount between the security amount S and the difference payment amount B by subtracting the difference payment amount B from the security amount S. C is calculated (step S12).

  The calculated difference amount C is added to the provisional total payment amount A, the provisional total payment amount A to which the difference amount C is added is set as a new provisional total payment amount A (step S13), and the process returns to step S6.

  When it is determined that the deduction payment amount B and the guarantee amount S coincide with each other (step S11; Yes), the provisional total payment amount A is set as the total payment amount (step S14), and the total salary payment calculation processing is completed. The

  That is, by setting the provisional total payment amount that the deduction payment amount B and the security amount S match to the total payment amount that the user pays to the employee, the employee is set at the time of contract with the user, etc. A security amount (procurement amount) will be paid.

  FIG. 5 shows an example of the calculation result of the total payment amount when income tax is selected as the setting deduction item. The example shown in FIG. 5 is an example of the calculation result of the total payment amount when the employment form of the employee is part, part-time job, commissioned, etc. and the user does not have social insurance.

  As shown in FIG. 5, when the security amount S is 100,000 yen and the set deduction item is set to income tax, only the information on the income tax is set as the set deduction item information. Since the income tax is a fluctuating amount that varies depending on the amount of salary to be taxed, the provisional total amount A1 is calculated as the same amount as the security amount S.

  An income tax deduction amount is calculated for the provisional total payment amount A1, and a subtraction payment amount B1 obtained by subtracting the income tax deduction amount from the provisional total payment amount A1 is calculated. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, the provisional total payment amount A2 is set as a new provisional total payment amount, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount C3), it is determined that the guaranteed amount S and the deduction payment amount B3 match, and the provisional total payment amount A3 is set as the total payment amount.

  In this way, even if the employee's form of employment is part-time, part-time job, commissioned, etc. and he / she is not subscribed to the user's social insurance, the employee's pre-set employee's insurance amount (procurement amount) can be secured. Since the total amount to be paid can be calculated in a short time, the work efficiency can be improved.

  FIG. 6 shows an example of the calculation result of the total payment amount when income tax, social insurance, etc. are selected as the setting deduction items. In the example shown in Figure 6, the employee is working overseas, and the amount of subsidy paid when working overseas is less than when working overseas due to the income tax calculation method, so that the employee is not penalized. It is an example of the calculation result in the case of setting total payment amount.

FIG. 6A shows an example of the calculation result of the subsidy amount during domestic work, and FIG. 6B shows an example of the calculation result of the subsidy amount when working overseas.
As shown in Figures 6 (a) and (b), if the total amount of payment is 800,000 yen and the deduction items are set for social insurance, etc. (health insurance, welfare annuity insurance, employment insurance) and income tax, Health insurance premiums, welfare pension insurance premiums, and employment insurance premiums overseas are the same, while income tax is a rate that is set in advance for the salary subject to taxation under the Income Tax Law when working overseas (For example, 20%), the amount of deduction is greatly different between domestic work and overseas work, which is disadvantageous for employees working overseas.

  In FIG. 6 (c), the total salary payment for overseas work is applied to the salary total payment calculation process of the present invention so that the same amount of subsidy as for domestic work can be obtained even when working overseas. An example of the amount calculation result is shown.

  As shown in Fig. 6 (c), the security amount S is the same as the subsidy amount for domestic work (659,310 yen), the deduction items are social insurance, etc. (health insurance, welfare annuity insurance, employment insurance) and income tax When set, the information on the set deduction items is information on social insurance and income tax.

  When the social insurance, etc. that is the subject of calculation is health insurance, welfare annuity insurance, employment insurance, the health insurance premium and welfare annuity insurance premium when calculating the subsidy of this salary are standard Since it is calculated based on the monthly remuneration and the premium rate set in advance, it is a fixed amount (fixed amount) regardless of changes in the total amount paid. Employment insurance premiums and income taxes are variable amounts that vary depending on the amount of salary subject to taxation. Accordingly, the provisional total amount A1 is calculated as an amount obtained by adding the health insurance premium s1 and the welfare annuity insurance premium s2 as fixed amounts to the security amount S.

  Social insurance deductions (total of health insurance and welfare pension insurance deductions and employment insurance deductions) and income tax deductions are calculated for the provisional total payment A1, and the social insurance deduction calculated from the provisional total payment A1 The subsidy amount B1 is calculated by subtracting the income tax deduction amount. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, the provisional total payment amount A2 is set as a new provisional total payment amount, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  In this way, if the employee's work location, etc., has changed, the difference in the subsidy payment due to the influence of the situation can be eliminated, and a pre-set guarantee amount (procurement amount) can be secured as before the change in circumstances. Since the total amount of payment can be calculated in a short time, there will be no disadvantage to the employee.

  FIG. 7 shows an example of the calculation result of the total amount paid when income tax, social insurance, and resident tax are selected as the setting deduction items. The example shown in FIG. 7 shows a case in which the total amount of payment to guarantee the take-up amount (guarantee amount) desired by the employee is set when a new employment contract is made between the employee and the user. It is an example of the calculation result in.

  As shown in FIG. 7, when the security amount S is 300,000 yen and the set deduction item is set for social insurance, etc. (health insurance, welfare annuity insurance, employment insurance), income tax and resident tax, information on the set deduction item Information on social insurance, income tax and resident tax is set.

  If the social insurance, etc. that is subject to calculation is health insurance, welfare annuity insurance, employment insurance, the health insurance premium and welfare annuity insurance premium are calculated based on the standard monthly remuneration and a preset rate. Therefore, it is a fixed amount (fixed amount) regardless of changes in the total amount paid. Employment insurance premiums and income taxes are variable amounts that vary depending on the amount of payment subject to taxation. Since the resident tax is the amount notified from the municipality, it is a fixed amount (fixed amount) regardless of changes in the total amount paid. Accordingly, the provisional total amount A1 is calculated as an amount obtained by adding the health insurance premium s1, the welfare pension insurance premium s2, and the resident tax s3 to the security amount S.

  Social insurance deductions (total of health insurance and welfare pension insurance deductions and employment insurance deductions), income tax deductions, and resident tax deductions are calculated for temporary total payments A1 and calculated from temporary total payments A1 The subsidy amount B1 is calculated by subtracting the social insurance deduction amount, income tax deduction amount, and resident tax deduction amount. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, the provisional total payment amount A2 is set as a new provisional total payment amount, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  In this way, when a new employment contract is made between the employee and the employer, the total amount of payment that can secure the amount of take (guarantee) desired by the employee can be calculated in a short time. Business efficiency can be improved.

  Fig. 8 shows that the check box G4c is marked with a check mark when the employee who is the subject of the calculation of the subsidy is a non-participating member of the health insurance premium, nursing care insurance premium and welfare pension insurance premium. An example of the calculation result of the total payment when income tax and social insurance are selected as deduction items is shown.

  For example, the employee who is the subject of the calculation has not submitted a qualification notification to the social insurance office to which the user has joined due to circumstances before joining the company. When the insurance premium has not been decided, the total amount to be paid for guaranteeing the take-up amount (guarantee amount) desired by the employee is set when the employment contract is concluded between the employee and the employer. It is an example of the calculation result in a case.

  As shown in FIG. 8, with the check mark in the check box G4c, the security amount S is set to 250,000 yen, the set deduction items are set to social insurance, etc. (health insurance, welfare pension insurance, employment insurance) and income tax In this case, information on the set deduction items is information on social insurance and income tax.

  If the social insurance, etc. that is subject to calculation is health insurance, welfare pension insurance, employment insurance, check the health insurance premium and welfare pension insurance premium when calculating the subsidy for this salary. By checking the box G4c, it is determined that there is no data indicating the insurance premium of the employee to be calculated in the personal insurance information group 111, and the health insurance premium amount table stored in advance in the storage unit 11 The amount varies depending on the Employees' Pension Insurance Premium Table and the amount paid. Employment insurance premiums and income taxes are variable amounts that vary depending on the amount of salary subject to taxation. Therefore, the provisional total amount A1 is calculated as the same amount as the guaranteed amount S.

  Health insurance premium amount table and welfare annuity premium amount table are referred to provisional gross payment amount A1, and health insurance premium and welfare pension insurance premium data corresponding to provisional gross payment amount A1 are acquired and acquired. The amount indicated by the data is calculated as the health insurance deduction and welfare pension insurance deduction, and further, the employment insurance deduction and income tax deduction are calculated, and the health insurance deduction and welfare annuity insurance calculated from the provisional total payment A1 A deduction amount B1 obtained by subtracting the deduction amount, the employment insurance deduction amount, and the income tax deduction amount is calculated. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, the provisional total payment amount A2 is set as a new provisional total payment amount, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  In this way, it is possible to calculate the total payment amount that can secure the amount of take (guarantee amount) desired by the employee in a short time, such as when an employment contract is made between the employee and the user before joining the company. It can be used for salary estimation at the time, and work efficiency can be improved.

  The example shown in FIG. 8 shows the case where the set deduction item is set to income tax and social insurance premiums, but the same applies to the case where the set deduction item is resident tax and other deductions in addition to income tax and social insurance premiums. The total amount paid can be calculated.

  In addition, the provisional total payment amount when the set deduction item is set to resident tax and other deductions in addition to income tax and social insurance premiums, etc. is the amount obtained by adding a fixed resident tax and other deductions to the security amount S Is calculated.

  Therefore, according to the first embodiment, until now, in order to calculate the guaranteed salary, the user changes the total salary of the salary to calculate the deduction amount, and the calculated deduction amount Compared to the amount of guarantee and the amount of guarantee, this work was repeated many times until they matched, but only by entering the setting items (guarantee amount, setting deduction items, etc.) Since the amount is calculated, work efficiency can be improved.

  Furthermore, by calculating the provisional total payment amount by adding the fixed amount of deduction items to the guaranteed amount from the set deduction items, the total payment amount can be calculated in a short time. If it is determined that the difference between the deduction payment amount and the guarantee amount does not match, the difference amount between the deduction payment amount and the guarantee amount is added to the provisional gross payment amount, and the deduction payment amount is again determined based on the added provisional gross payment amount. Since it is calculated, the subsidy payment amount can be converged to the guaranteed amount in a short time.

  In addition, the salary using the general payment amount calculation information group used for the calculation processing of the salary deduction amount and the calculation processing of the salary deduction amount conventionally used as the salary deduction amount calculation processing The total payment amount calculation process of the employee can be realized, so there have been changes in the employee's circumstances (for example, the number of dependents, personnel changes, etc.) and the payment calculation information group and deduction amount calculation process when the law was revised Even in this case, it is not necessary to change the payment amount calculation information group and the deduction amount calculation processing for the total salary payment calculation processing, and the development man-hours can be reduced.

  And since it is possible to estimate the total amount of payment that can secure the amount of salary that is paid to the employee every month, it can also be utilized for the financial plan for the user side.

[Embodiment 2]
Hereinafter, the second embodiment of the present invention will be described in detail with reference to the drawings.
First, the configuration will be described.
Since the configuration of the bonus amount calculation apparatus 1 in the second embodiment is the same as that in the first embodiment, the illustration is omitted.

  In the second embodiment, instead of the total salary payment calculation process described in the first embodiment, the total bonus payment calculation process will be described. Accordingly, the storage unit 11 stores a total bonus payment calculation program and various necessary data in place of the total salary payment calculation processing program.

  Note that the various data and information group used to calculate the various deduction amounts are the same as in the first embodiment, and the calculation of the bonus deduction payment amount of salary that is conventionally performed as the bonus deduction payment calculation processing. Since it is a general information group used for processing, description is omitted.

  FIG. 9 shows an example of the bonus total payment calculation start screen G10 displayed on the display screen when the bonus total payment calculation processing in the second embodiment is executed.

  As shown in FIG. 9, the bonus total payment calculation start screen G10 is a calculation date input field G1 for inputting a date for calculating the total bonus payment, and an employee for setting a calculation target person for the total payment Number input field G2a, employee name display field G2b in which the name of the employee corresponding to the employee number input in the employee number input field G2a is displayed, bonus calculation basic period indicating the number of months of the basic period for calculating the bonus G2c, a security amount setting area G13 for setting a bonus security amount, a social insurance premium setting area G14 for setting various social insurance premiums, an income tax setting area G15 for setting an income tax, and other deductions such as a property form and a reserve In addition, a deduction amount setting area G16, a calculation start button G17 for instructing to start a bonus total payment calculation process based on the contents of the various setting areas, and the like are provided.

  The security amount setting area G13 includes a taxable payment input field G13a for inputting a taxable payment amount, a non-taxable payment amount field G13b for inputting a non-taxable payment amount, a taxable payment input field G13a, and a non-taxable payment amount input field. Guarantee amount display column G13c in which the bonus amount calculated by adding the numerical value input to G13b is displayed, and what deduction items the amount displayed in the guarantee amount display column G13c is from the total bonus payment amount There is a setting deduction item column G13d indicating whether the amount is the amount obtained by subtracting the amount.

  The setting deduction item column G13d can be arbitrarily set from a plurality of deduction items. For example, as a deduction item, in the case of income tax only, social insurance premiums (health insurance, welfare annuity insurance, employment insurance) and a pattern in which multiple deduction items are combined can be selected and set as in the case of income tax. .

  The taxable payment input field 13a and the non-taxable payment input field 13b are read from the employee salary calculation result information group 118 when the employee salary calculation result information group 118 includes bonus data corresponding to the employee number. May be displayed.

  In the social insurance premium setting area G14, for each social insurance (health insurance, long-term care insurance, employee pension insurance, employment insurance), the employee corresponding to the employee number entered in the employee number input field G2a It has the object classification column G14a in which it is displayed whether it is object.

  In the target classification column G14a, information corresponding to the employee number input to the employee number input column G2a from the personal insurance information group 111 of the storage unit 11 is read and displayed.

  The target classification column G14a can be changed to other information on the bonus total payment calculation start screen G10, and the changed information is reflected and changed in the personal insurance information group 111.

  In the income tax setting area G15, various information related to the income tax of the employee corresponding to the employee number input in the employee number input field G2a is displayed in a tax table classification display field G15b, a tax dependent number display field G15c, an income tax calculation method display field G15d, It has a previous month salary display column G15e indicating the salary amount after deduction of social insurance premiums for the previous month.

  In the tax table category display column G15b, the tax table column category corresponding to the employee number input to the employee number input column G2a from the personal income tax information group 113 of the storage unit 11 is read and displayed.

  In the tax dependent number display column G15c, the total number of tax dependent converted numbers corresponding to the employee number input in the employee number input column G2a from the personal tax dependent information group 114 of the storage unit 11 is displayed.

  In the income tax calculation method display column G15d, the bonus tax calculation classification corresponding to the employee number input to the employee number input column G2a from the company income tax information group 115 of the storage unit 11 is read and displayed.

  In the previous month salary display column G15e, the amount after deduction of social insurance or the like is read from the total payment amount corresponding to the employee number input in the employee number input column G2a from the employee salary calculation result information group 118 of the storage unit 11. Is displayed.

  The tax table classification display field G15b and the income tax calculation method display field G15d can be changed to other information on the bonus total payment calculation start screen G10, and the changed information includes the personal income tax information group 113, the income tax calculation method. It is reflected and changed in the display column G5d.

  In the other deduction amount setting area G16, the date entered in the calculation date entry field from the individual deduction information group 117 of the storage unit 11 and the total amount of deduction corresponding to the employee number entered in the employee number entry field G2a are displayed. Other deduction amount display column G16b.

  The other deduction amount display column G6b can be changed to other information on the bonus total payment calculation start screen G10.

Next, the operation of the second embodiment will be described.
FIG. 10 shows a flow of the bonus total payment calculation processing in the second embodiment.

  First, the bonus total payment calculation start screen G10 is displayed on the display screen of the display unit 13. When the input unit 12 is operated by the user, the date and employee number are displayed in the calculation date input field G1 and the employee number input field G2a. When entered, the employee name display field G2a displays the name of the employee to be calculated, a security amount setting area G13, a social insurance premium setting area G14, an income tax setting area G15, and other deduction amount setting area G16. Each information is displayed (step S21).

  When a numerical value is input to the taxable amount input field G13a and the non-taxable amount input field G13b by operating the input unit 12 by the user, the bonus guaranteed amount S is calculated and calculated in the guaranteed amount display field G13c. The guaranteed amount is displayed and set (step S22).

  Further, the setting deduction item is selected by operating the setting deduction item column G13b by operating the input unit 12 by the user (step S23).

  After the set deduction item is selected, various pieces of information corresponding to the selected deduction item are set in order to calculate the deduction amount B (step S24). For example, when the set deduction item is selected as income tax, social insurance premium, etc., the information in the other deduction setting area G16 is set not to be used for calculating the total payment amount and is displayed in a shaded manner.

  The user operates the calculation start button G17 by operating the input unit 12 after confirming the bonus total payment calculation activation screen G10 in which various information is set. When the calculation start button G17 is operated, the amount of the fixed amount of deduction items is added to the guaranteed amount S and the provisional total amount A is calculated (step S25).

  When the provisional total payment amount A is calculated, the bonus subtraction payment amount B calculation processing conventionally performed as the bonus subtraction payment calculation processing is executed (steps S26 to S29). However, the deduction processing is not executed for the deduction items that are not included in the selected set deduction items.

  A bonus subsidy payment amount B calculation process (steps S26 to S29) conventionally performed as the bonus subsidy payment calculation process will be described.

  When the provisional total payment amount A is calculated, a standard bonus amount obtained by rounding down the provisional total payment amount A to less than 1,000 yen is calculated, and the personal insurance information group 111 and the company insurance information are calculated from the storage unit 11 to the calculated standard bonus amount. In the case of the salary of the first embodiment, the group 112 is referred to and the insurance premium rate read from the individual insurance information group 111 and the company insurance information group 112 is multiplied to calculate the health insurance premium and the welfare pension insurance premium. Employment insurance premiums are calculated in the same manner as above, and various insurance premiums calculated from the provisional total payment amount A are deducted (step S26).

  Then, the personal income tax information group 113, the personal dependent information group 114, and the company income tax information group 115 are read from the storage unit 11, the income tax is calculated, and the calculated income tax is deducted (step S27).

  Further, the individual deduction information group 117 is read from the storage unit 11, the other deduction amount is calculated, and the calculated other deduction amount is deducted (step S28).

  By performing the deduction processing in steps S26 to S28, the subsidy payment amount B is calculated (step S29).

  When the deduction payment amount B is calculated, it is determined whether or not the calculated deduction payment amount B matches the guarantee amount S (step S30).

  If it is determined that the difference payment amount B and the security amount S do not match (step S30; No), the difference amount between the security amount S and the difference payment amount B by subtracting the difference payment amount B from the security amount S. C is calculated (step S31).

  The calculated difference amount C is added to the provisional total payment amount A, the provisional total payment amount A to which the difference amount C is added is set as a new provisional total payment amount A (step S32), and the process returns to step S26.

  If it is determined that the deduction payment amount B and the guarantee amount S match (step S30; Yes), the provisional total payment amount A is set as the total payment amount (step S33), and the bonus total payment calculation processing is terminated. The

  That is, by setting the provisional total payment amount that the deduction payment amount B and the security amount S match to the total payment amount that the user pays to the employee, the employee sets the security amount set at the time of contract with the user, etc. (Procurement amount) will be paid.

  FIG. 11 shows an example of the calculation result of the total payment amount when income tax is selected as the setting deduction item. The example shown in FIG. 11 shows that the employee is working overseas and the total amount is paid so that the employee is not disadvantaged because the amount of subsidy for overseas work is less than domestic work due to the income tax calculation method. It is an example of the calculation result in the case of setting an amount.

Fig. 11 (a) shows an example of the calculation result of the subsidy amount for domestic work with domestic social insurance (health insurance premiums, employee pension insurance premiums, employment insurance premiums). Fig. 11 (b) An example of the calculation result of the subsidy amount when working overseas is under the same insurance policy as domestic social insurance.
As shown in FIGS. 11A and 11B, the income tax is calculated based on a rate (for example, 20%) set in advance for the salary to be taxed under the Income Tax Law when working overseas. For this reason, the amount of the subsidy paid differs greatly between domestic work and overseas work, which was disadvantageous for employees working overseas.

  In FIG. 11 (c), the total payment of bonuses during overseas work is applied to the bonus payment calculation process of the present invention so that the same amount of deductions as during domestic work can be obtained even when working overseas. An example of the amount calculation result is shown.

  As shown in FIG. 11 (c), when the security amount S is the same as the subsidy amount for domestic work (276,000 yen) and the set deduction item is set to income tax, the information on the set deduction item is information on income tax. Is set.

  The income tax is a variable amount that varies depending on the amount of bonus to be taxed. Therefore, the provisional total amount A1 is calculated as the same amount as the guaranteed amount S.

  Income tax deduction and other deductions (foreign insurance premiums) are calculated for the provisional gross payment A1, and the subsidy payment B1 is calculated by subtracting the income tax deduction and other deductions calculated from the provisional gross payment A1. Is calculated. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, the provisional total payment amount A2 is set as a new provisional total payment amount, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  FIG. 12 shows an example of the calculation result of the total amount paid when income tax, social insurance, etc. are selected as the setting deduction items. In the example shown in FIG. 12, as in the case of FIG. 11, the total payment is made so that the employee is working overseas, and the amount of deduction is less than the domestic work due to the income tax calculation method, so that the employee is not disadvantaged. It is an example of the calculation result in the case of setting an amount.

FIG. 12A shows the calculation result of the subsidy amount when working in Japan, and FIG. 12B shows the calculation result of the subsidy amount when working overseas.
As shown in Figs. 12 (a) and 12 (b), if employees are enrolled in domestic social insurance even when working overseas, domestic and overseas health insurance premiums, employee pension insurance premiums, employment While insurance premiums are the same amount, income tax is calculated based on a pre-set rate (for example, 20%) for the salary subject to taxation under the Income Tax Law when working overseas. The amount of the subsidy paid differs greatly between domestic work and overseas work, resulting in a disadvantage for employees working overseas.

  In FIG. 12 (c), the total payment of salary when working abroad is applied to the total salary calculation processing of the present invention so that the same amount of deduction as when working overseas is obtained even when working overseas. An example of the amount calculation result is shown.

  As shown in Fig. 12 (c), the security amount S is the same as the subsidy amount for domestic work (603,027 yen), the deduction items are social insurance, etc. (health insurance, welfare annuity insurance, employment insurance) and income tax When set, the information on the set deduction items is information on social insurance and income tax.

  If the social insurance, etc. that is subject to calculation is health insurance, welfare annuity insurance, or employment insurance, the health insurance premium or welfare annuity insurance premium for calculating the bonus subsidy shall be Since it is calculated based on the total amount paid and the insurance premium rate set in advance, the amount varies depending on the variation in the total amount paid. Employment insurance premiums and income taxes are variable amounts that vary depending on the amount of bonus to be taxed. Therefore, the provisional total amount A1 is calculated as the same amount as the guaranteed amount S.

  Social insurance deduction (health insurance, welfare annuity insurance, employment insurance deduction) and income tax deduction are calculated for provisional total payment A1, and social insurance deduction and income tax deduction calculated from provisional total payment A1 A subtraction payment amount B1 from which the amount has been subtracted is calculated. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, the provisional total payment amount A2 is set as a new provisional total payment amount, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  In this way, if the employee's work location, etc., has changed, the difference in the subsidy payment due to the influence of the situation can be eliminated, and a pre-set guarantee amount (procurement amount) can be secured as before the change in circumstances. Since the total amount of payment can be calculated, there will be no disadvantage to the employee.

  FIG. 13 shows an example of the calculation result of the total bonus payment amount when there is no salary in the previous month (including the case where the amount of salary in the previous month is equal to or less than the amount of social insurance).

  As shown in FIG. 13, when the security amount S is set to 600,000 yen and the set deduction item is set to social insurance etc. (health insurance, welfare annuity insurance, employment insurance) and income tax, the information of the set deduction item is social insurance Etc. and income tax information is set.

  If the social insurance, etc. that is subject to calculation is health insurance, welfare annuity insurance, or employment insurance, the health insurance premium or welfare annuity insurance premium for calculating the bonus subsidy shall be Since it is calculated based on the total amount paid and the insurance premium rate set in advance, the amount varies depending on the variation in the total amount paid. The employment insurance premium is a variable amount that varies depending on the amount of bonus to be taxed.

  As shown in FIG. 13, when the amount after deduction of social insurance premiums in the previous month is 0 yen as shown in FIG. 13, the number of months indicated in the bonus calculation reference period for the amount of bonuses after deduction of social insurance premiums (for example, (June) is gradually calculated, and the calculated amount is applied to the monthly table to obtain a tax amount, and the calculated tax amount is multiplied by the number of months in the bonus calculation reference period. That is, the income tax when there is no salary or the like of the previous month is a variable amount that varies depending on the amount of bonus payment.

  Therefore, the provisional total amount A1 is calculated as the same amount as the guaranteed amount S.

  Social insurance deduction (health insurance, welfare annuity insurance, employment insurance deduction) and income tax deduction are calculated for provisional total payment A1, and social insurance deduction and income tax deduction calculated from provisional total payment A1 A subtraction payment amount B1 from which the amount has been subtracted is calculated. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, a new provisional total payment amount A2 is set, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  In this way, even if there is no salary for the previous month, etc., the bonus payment calculation processing that is routinely performed as bonus payment calculation processing is applied, and there is no special setting or operation. It is possible to calculate the total amount of payment that can secure a preset guarantee amount (takeover amount).

  Fig. 14 shows an example of the result of calculating the total amount of bonuses paid when paying bonuses (amounts after deducting social insurance premiums) that exceed 10 times the previous month's salary amount (amounts deducting social insurance premiums, etc.) Show.

  As shown in FIG. 14, when the security amount S is set to 600,000 yen and the set deduction item is set to social insurance, etc. (health insurance, welfare annuity insurance, employment insurance) and income tax, the information of the set deduction item is social insurance Etc. and income tax information is set.

  If the social insurance, etc. that is subject to calculation is health insurance, welfare annuity insurance, or employment insurance, the health insurance premium or welfare annuity insurance premium for calculating the bonus subsidy shall be Since it is calculated based on the total amount paid and the insurance premium rate set in advance, the amount varies depending on the variation in the total amount paid. The employment insurance premium is a variable amount that varies depending on the amount of bonus to be taxed.

  If the security amount S set as shown in FIG. 14 (for example, 600,000 yen) exceeds 10 times the amount (for example, 40,000 yen) after deducting social insurance premiums from the previous month, The number of months (for example, June) indicated in the bonus calculation reference period is subtracted from the bonus amount after deduction, and the total amount calculated after deducting social insurance premiums from the previous month is calculated. A tax amount is calculated by applying it to the monthly table, and the amount calculated by subtracting the income tax amount of the previous month from the calculated tax amount is multiplied by the number of months in the bonus calculation reference period. That is, the income tax when there is no salary or the like of the previous month is a variable amount that varies depending on the amount of bonus payment.

  Therefore, the provisional total amount A1 is calculated as the same amount as the guaranteed amount S.

  Social insurance deduction (health insurance, welfare annuity insurance, employment insurance deduction) and income tax deduction are calculated for provisional total payment A1, and social insurance deduction and income tax deduction calculated from provisional total payment A1 A subtraction payment amount B1 from which the amount has been subtracted is calculated. The difference amount C1 is calculated by subtracting the deduction amount B1 calculated from the security amount S. However, since the difference amount C1 is not 0 yen, it is determined that the security amount S and the calculated deduction amount B1 do not match. . Then, the calculated difference amount C1 is added to the provisional total payment amount A1, a new provisional total payment amount A2 is set, and the process is repeated until the difference amount C becomes 0 yen.

  When the difference amount C becomes 0 yen (in the case of the difference amount Cn), it is determined that the guaranteed amount S and the deduction payment amount Bn match, and the provisional total payment amount An is set as the total payment amount.

  In this way, even when paying bonuses (amounts after deducting social insurance premiums) that exceed 10 times the amount of salary in the previous month (amounts deducting social insurance premiums, etc.) As a bonus, a bonus subsidy calculation process that is conventionally performed is applied, and a total payment amount that can secure a predetermined guarantee amount (takeover amount) without special setting and operation can be calculated.

  Therefore, according to the second embodiment, until now, in order to calculate the guaranteed bonus amount, the user changes the total bonus payment amount by calculating the bonus payment amount, and calculates the calculated bonus payment amount. Compared to the amount of guarantee and the amount of guarantee, this work was repeated many times until they matched, but by simply entering the setting items (guarantee amount, deduction items, etc.), the total amount of payment that can secure the amount of guarantee was calculated Therefore, it is to improve business efficiency.

  Furthermore, when it is determined that the calculated amount of subsidy payment does not match the amount of guarantee, the difference between the amount of subsidy payment and the amount of security is added to the provisional total amount of payment, and again based on the added provisional total amount of payment Since the deduction amount is calculated, the deduction amount can be converged to the bonus guarantee amount in a short time.

  In addition, bonuses using the general payment amount calculation information group used for bonus payment calculation processing and bonus bonus payment calculation processing conventionally used as bonus payment calculation processing The total payment amount calculation process of the employee can be realized, so there have been changes in the employee's circumstances (for example, the number of dependents, personnel changes, etc.) and the payment calculation information group and deduction amount calculation process at the time of law revision Even in this case, it is not necessary to change the payment amount calculation information group and the deduction amount calculation processing for the bonus total payment calculation processing, and the development man-hours can be reduced.

  Since the total amount of payment that can secure the guaranteed amount of bonuses to be paid to employees can be calculated, the user can also use it for fund planning.

It is a block diagram which shows the structure of the payment calculation apparatus 1 in this Embodiment 1. FIG. As an example of a payment amount calculation information group for calculating various deduction amounts, FIG. 2 (a) shows the personal insurance information group 111, FIG. 2 (b) shows the company insurance information group 112, and FIG. 2 (c) shows. , Personal income tax information group 113, FIG. 2 (d) shows personal tax support information group 114, FIG. 2 (e) shows company income tax information group 115, FIG. 2 (f) shows resident tax information group 116, FIG. g) shows an example of the personal deduction information group 117, and FIG. 2 (h) shows an example of the employee salary calculation result information group 118. It is an example of the total salary payment calculation start screen G0 displayed on the display screen when the total salary payment calculation processing in the first embodiment is executed. It is a flow of the total supply amount calculation process of salary in this Embodiment 1. FIG. It is an example of the calculation result of the total amount of payment when an income tax is selected as a setting deduction item. It is an example of the calculation result of total payment when income tax, social insurance, etc. are selected as a setting deduction item. It is an example of the calculation result of the total amount of payment when income tax, social insurance, and resident tax are selected as setting deduction items. When the employee who is subject to calculation of the subsidy is a non-participating member of health insurance premium, nursing care insurance premium and welfare pension insurance premium, a check mark is added to the check box G4c, and income tax is set as a deduction item. It is an example of the calculation result of the total payment when social insurance is selected. It is an example of the bonus total payment calculation start screen G10 displayed on the display screen when the bonus total payment calculation processing in the second embodiment is executed. It is a flow of a bonus total payment calculation process in the second embodiment. It is an example of the calculation result of the total amount of payment when an income tax is selected as a setting deduction item. It is an example of the calculation result of total payment when income tax, social insurance, etc. are selected as a setting deduction item. It is an example of the calculation result of the total amount of bonus payment when there is no salary for the previous month (including the case where the amount of salary for the previous month is less than the amount of social insurance). It is an example of a calculation result of the total amount of bonus payment when paying a bonus (amount minus social insurance premiums) more than 10 times the amount of salary in the previous month (amount minus social insurance premiums).

Explanation of symbols

1 Payment amount calculation device 10 CPU
11 Storage Unit 111 Personal Insurance Information Group 112 Company Insurance Information Group 113 Personal Income Tax Information Group 114 Personal Tax Dependent Information Group 115 Company Income Tax Information Group 116 Resident Tax Information Group 117 Personal Deduction Information Group 118 Employee Salary Calculation Result Information Group G0 Total Salary Payment Amount calculation start screen G1 Calculation date input field G2a Employee number input field G2b Employee name display field G2c Bonus calculation basic period G3, G13 Security amount setting area G3a, G13a Taxable payment input field G3b, G13b Tax-free payment input field G3c, G13c Guarantee amount display column G3d, G13d Setting deduction item column G4, G14 Social insurance premium setting area G4a, G14a Target division column G4b Fixed amount display column G4c Check box G5, G15 Income tax setting area G5a Tax amount table division display column G5b, G15b Tax division Display column G5c, G15c Tax dependent number display column 5d, G15d income tax calculation method display field G15e the previous month salary display field G6, G16 and other deductions set area G6a residents tax display field G6b, G16b other deductions display field G7, G17 calculation start button

Claims (8)

In the payment amount calculation device for calculating the subtraction payment amount according to the conditions of the employee based on the payment amount calculation information group,
An input means for inputting a setting instruction for a deduction item and a setting instruction for a guarantee amount set in advance as a payment amount after the amount corresponding to the set deduction item is deducted;
Temporary payment amount calculating means for calculating a provisional total payment amount by adding an amount of a fixed amount of deduction items from among the deduction items instructed to set to the guaranteed amount;
A subsidy amount calculation means for subtracting a deduction amount corresponding to the deduction item from the provisional total amount of payment with reference to the payment amount calculation information group, and calculating a subsidy amount;
Control means for comparing the subsidized amount and the guaranteed amount, and controlling the subtracted amount calculating unit so as to repeat the calculation of the subtracted amount until the subtracted amount and the guaranteed amount match;
A payment amount calculating device comprising: The control means includes
If it is determined that the deduction amount and the guarantee amount do not match, the difference between the deduction amount and the guarantee amount is added to the provisional total amount;
The supply amount calculation device according to claim 1. The control means includes
If it is determined that the deduction payment amount and the guarantee amount match, the provisional total payment amount is set as a total payment amount that the user pays to the employee;
The supply amount calculating device according to claim 1 or 2. The deduction item instructed to be set is any one of income tax, social insurance premium, etc. and income tax, social insurance premium, etc., income tax and resident tax,
The supply amount calculation device according to any one of claims 1 to 3. The input means includes
A setting instruction is entered to indicate that the employee who is subject to the calculation of the subsidy is a non-participating member of the health insurance premium, long-term care insurance premium and welfare pension insurance premium,
The deduction payment calculation means is:
Calculating the deduction amount when setting instructions indicating that you are not eligible for health insurance premiums, nursing care insurance premiums and employee pension insurance premiums are entered;
The supply amount calculation device according to any one of claims 1 to 4, wherein: The security amount is the salary security amount paid to employees every month,
The supply amount calculating device according to any one of claims 1 to 5, wherein: The amount of security is the amount of bonus paid to employees,
The payment calculation device according to any one of claims 1 to 6, wherein: In a computer provided in the payment calculation device that calculates the subtraction payment according to the conditions of the employee based on the payment calculation information group,
An input means for inputting a setting instruction for a deduction item and a setting instruction for a guarantee amount set in advance as a payment amount after the amount corresponding to the set deduction item is deducted;
Temporary payment amount calculating means for calculating a provisional total payment amount by adding an amount of a fixed amount of deduction items from among the deduction items instructed to set to the guaranteed amount;
A subsidy amount calculation means for subtracting a deduction amount corresponding to the deduction item from the provisional total amount of payment with reference to the payment amount calculation information group, and calculating a subsidy amount;
Control means for comparing the subsidized amount and the guaranteed amount, and controlling the subtracted amount calculating unit so as to repeat the calculation of the subtracted amount until the subtracted amount and the guaranteed amount match;
Program to function as.

Images