JPH06332930A - Salary data input method - Google Patents

Abstract

PURPOSE:To provide a salary data input method for reducing burden to an operator even in inputting the data of salary items to be calculated by using any special calculating formula. CONSTITUTION:Concerning the salary data input method for inputting salary data to work conditions items or salary items while displaying worker items such as the member's numbers or names of workers, work condition items such as attendance time or overtime work and salary items such as basic salary or overtime work pay, the calculated salary item is previously decided by registering the prescribed calculating formula using a previously decided unit cost item and an item for the number of times of data inputs from the salary items and when inputting the salary data to the calculated salary item, the salary data are inputted to the calculated salary item by inputting number of times data to the number of times item and calculating the salary based on the prescribed calculating formula.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a salary data input method for inputting salary data while displaying worker items, attendance items and salary items.

[0002]

2. Description of the Related Art In recent years, a payroll calculation program for payroll processing has become widespread, and the digitization of payroll data such as pay deduction items and attendance items has become popular, and is used for payroll and accounting work. It is progressing. Salary items are roughly classified into fixed items that do not change for one year, such as basic salary, and variable items that change monthly such as overtime pay. When inputting salary data, the operator only needs to input data for variable items.

Among the variable items, overtime hours, which is an attendance time item, is calculated by multiplying the unit price, such as overtime allowance calculated by a company using the same formula, and full-time allowance is also calculated. Some companies use a special formula to calculate. For the salary item calculated using the same formula, the item data of the attendance items necessary for the calculation were used to automatically enter the data. However,
For a salary item calculated using a special formula for each company, an operator calculates actual salary data with a calculator or the like and directly inputs the amount data into the salary item.

[0004]

As described above, when inputting data of salary items calculated by using a special formula for each company, it is necessary to actually calculate with a calculator or the like, which imposes a burden on the operator. At the same time, there is a problem that a data input error tends to occur. In addition, master data such as basic salary for each worker and social insurance premiums, which is the basis for calculating salary data, creates an employee master independent of salary data,
Stored in it. Therefore, in order to correct the numerical value of the master data, it is necessary to start the program for correcting the master data and open the employee master file.

Therefore, when the master data is changed while the salary data is being input, the program for inputting the salary data is temporarily terminated, the master data correcting program is started, and the master data of the employee master is changed. After fixing
There was a problem that the operator had to bear a heavy burden because he had to restart the salary data input program and continue to input salary data.

An object of the present invention is to provide a salary data input method that can reduce the burden on the operator even when inputting data of salary items calculated using a special calculation formula. Another object of the present invention is to provide a salary data input method capable of easily correcting master data such as basic salary and social insurance premiums, which is the basis for calculation of salary data, while inputting salary data. .

[0007]

[Means for Solving the Problems] The above purpose displays worker items such as employee numbers and names of workers, attendance items such as attendance time and overtime hours, and salary items such as basic salary and overtime allowance. However, in the salary data input method of inputting salary data for attendance items or salary items, from the salary item,
When the salary data is entered for the calculated salary item, the calculated salary item in which a predetermined calculation formula using the unit price item and the data input frequency item is registered is predetermined.
This is achieved by a salary data input method characterized in that salary data is input to a calculated salary item by inputting the number data to the number item and performing calculation based on a predetermined calculation formula.

In the above salary data input method,
When inputting salary data, it is desirable to directly correct master data, which is the basis of calculation of salary data, while displaying worker item, attendance item and salary item. Furthermore, in the above salary data input method, when the salary data is input, like the pay statement to be paid to the worker, the worker item is displayed at the top and the attendance item is displayed below the worker item. It is desirable to display the item below the attendance item and display the frequency data together with the salary data in the calculated salary item.

Furthermore, in the above-mentioned salary data input method, an input scheduled salary item for which the salary data is to be input is determined in advance from the salary item, and at the time of inputting the salary data, at least salary items other than the planned salary item are input. It is desirable not to display salary data.

[0010]

According to the present invention, the attendance items such as employee numbers and names of the employed workers, attendance items such as attendance time and overtime hours, and salary items such as basic salary and overtime allowance are displayed while displaying attendance items. Or, in the salary data input method of inputting salary data for a salary item, a calculated salary item is registered in advance by registering a predetermined calculation formula using a predetermined unit price item and a data input frequency item from the salary item. By the way, when inputting the salary data for the calculated salary item, the number of times data is input to the number of times item, and the payroll data is input to the calculated salary item by calculating based on a predetermined calculation formula. It is possible to reduce the burden on the operator when inputting the data of the salary item calculated using the calculation formula.

In the above salary data input method,
When entering salary data, while displaying the worker item, attendance item, and salary item, if you directly correct the master data that is the basis of the salary data calculation, you do not have to start the master data correction program. , You can easily modify the master data. Furthermore, in the above salary data input method, when the salary data is input, like the pay statement to be paid to the worker, the worker item is displayed at the top and the attendance item is displayed below the worker item. By displaying the items below the attendance items and displaying the number of times data together with the salary data in the calculated salary item, it is possible for the operator to input the salary data without feeling discomfort as if he / she entered the salary statement.

Furthermore, in the above-mentioned salary data input method, an input scheduled salary item for which the salary data is to be input is determined in advance from the salary item, and at least the salary items other than the input scheduled salary item are input when the salary data is input. If you do not display salary data, you can correct salary data
Even during input, salary data can be efficiently input without revealing important salary data of the worker.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A salary data input method according to an embodiment of the present invention will be described with reference to FIGS. First, the salary data input by the salary data input method of this embodiment will be described with reference to the display screen of FIG. FIG. 1 shows a display screen in a state where the input of salary data and the calculation of salary data have been completed according to this embodiment described later.

In the present embodiment, the salary data is displayed in the same form as the actual image of the pay statement to be paid to the worker. That is, as shown in FIG. 1, worker items such as affiliation and name of the worker are displayed at the top of the display screen. At the bottom of the worker item, attendance items such as number of days worked, number of days off from work, working hours, and early / late hours are displayed. At the bottom of the attendance item, the basic salary, performance salary, etc. are displayed over two lines, and at the bottom of the payment item, deductible items such as health insurance premiums, welfare pension insurance, etc. are displayed over two lines. Has been done. Below the deduction items, calculation items such as the total payment amount and the total deduction amount are displayed.

Among these salary items, there are fixed items that do not change monthly such as basic salary and variable items that change monthly such as overtime allowance. Conventionally, data input of fixed items and data of variable items are available. Inputting was done on separate display screens. In this embodiment, both fixed items and variable items are displayed on the same display screen as the image of the actual pay statement shown in FIG. 1 to input data. Therefore, there is an advantage that all salary items can be listed and the accuracy of data input is improved. Further, since it is not necessary to switch the display screen between the data input of the fixed item and the data input of the variable item, there is an advantage that the waste of time in the data input is reduced.

Details of salary items will be described with reference to FIG. As the employee item at the top of the pay slip, the employee's affiliation name is “Accounting Department Finance Section” and the affiliation code is “11-
00 ”, employee number“ 0100 ”, name“ Ichiro Yamada ”
Is displayed. In addition, as salary data for the attendance items below the worker item, the number of working days is “20 days”, the number of holiday work days, the number of special vacation days, and the number of paid vacation days are all “0”.
Days, and the number of absentee days is "1 day". Total work time is "155 hours 00 minutes", total delay time is "00 hours 00 minutes", all normal overtime hours is "8 hours 00 minutes", late night overtime hours, holiday work overtime hours, and overtime spare time are all " It is displayed as "00 hour 00 minute".

Further, as salary data of the pay item below the attendance item, the basic salary is "264000 yen", the functional salary is "9000 yen", the position allowance is "4000 yen", the family allowance is "1000 yen", and the housing allowance. Is "7000 yen", skill allowance is "9000 yen", job allowance is "7000 yen", adjustment allowance is "8650 yen", meeting allowance is "3420 yen", full-time allowance is "2000 yen", price allowance is " 0 yen, sales allowance is 0 yen, meal allowance is 1700 yen, overtime allowance is 12640 yen, commuting allowance is 3500 yen, and deduction is 11000 yen. .

Also, as a deduction item under the payment item,
The health insurance premium is "8400 yen" and the welfare pension insurance amount is "72".
40 yen, employment insurance premium is 1398 yen, income tax is 6
280 yen, resident tax is 20000 yen, fellowship fee is 2500 yen, cancer insurance amount is 3500 yen, property savings is 2000 yen, association membership fee is 1500 yen, mutual aid membership fee is 0 yen, accident insurance is 0 yen, company housing costs are 0
"Yen", deposits are "0 yen", mutual aid loans are "0 yen", and advance / in-kind are "0 yen".

Further, as a calculation item under the deduction item, "0 yen" is excluded from the employment insurance, and the total payment amount is "321".
910 yen ", deduction total amount is" 51706 yen ", deduction amount is" 270204 yen ", bank transfer amount is" 200000 "
“Yen” and cash payment amount are displayed as “70204 yen”. In the present embodiment, among these salary items, for salary items calculated using a special formula for each company,
As the calculated salary item, a predetermined calculation formula using a predetermined unit price item and a data input frequency item is registered.

A method of registering a predetermined calculation formula for a calculated salary item will be described with reference to FIGS. Figure 2
Is a registration screen for registering the calculated salary item from the salary item. From the salary items displayed on the right side of the registration screen in FIG. 2, select the salary item to be registered as the calculated salary item.
It is possible to select the calculated salary item from the payment items such as basic salary and deduction items such as health insurance premiums. Of the payout items, basic wages, commuting allowance, overtime pay, reduction allowance, etc., fixed items or variable items whose formula is uniformly determined, and deduction items, health insurance premiums , Welfare pension insurance amount, employment insurance premium, income tax, resident tax,
Items that have a fixed formula even if they are fixed items or variable items are displayed in red so that they cannot be selected.

In the specific example of FIG. 2, as the calculated salary item,
Meeting allowance (calculation formula 1), full-time allowance (calculation formula 2), sales allowance (calculation formula 3), meal allowance (calculation formula 4)
Is selected, and company housing expenses (calculation formula 5) and deposits (calculation formula 6) are selected from the deduction items. The formula for each calculated salary item is described as follows on the left side of each registration screen in FIGS. 3 to 5.

Calculation formula 1 [meeting allowance]: T1 * C1 Calculation formula 2 [working allowance]: T2- (N5 * 5000) Calculation formula 3 [sales allowance]: T3 * C3 * 0.95 Calculation formula 4 [meal allowance] ]: T4 * C4 Formula 5 [Company Housing Expenses]: T5 * C5 Formula 6 [Deposits]: T6 * C6 Among these formulas, T1 to T6 are called calculation unit price items and are the basis for calculating salary data. Is a numerical value. FIG. 3 shows the registration screen of the calculation unit price item. In the lower right part of FIG. 3, there is a "unit cost item" column, in which the item name and unit price of the calculated salary item are displayed. The calculated unit price item T1 of the conference allowance is "2000" yen, the calculated unit price item T2 of the full-time allowance is "10000" yen, the calculated unit price item T3 of the sales allowance is "1000" yen, and the calculated unit price of the meal allowance. It can be seen that the item T4 is “300” yen, the calculated unit price item T5 of company housing expense is “0” yen, and the calculated unit price item T6 of deposit is “0” yen.

Of these calculation formulas, C1 to C6 are called calculation frequency items, and are items that are input by the operator when data is input. Number of items for meeting allowance C
1 is set, the count item C3 is set for the sales allowance, the count item C4 is set for the meal allowance, the count item C5 is set for the company housing expense, and the count item C6 is set for the deposit. It is set. These calculation count items C1
As shown in FIG. 1, C6 is displayed in the upper part of the salary data of the salary item.

Among these calculation formulas, +,-, *,
/, (,) Are called operator items, and are operators for the calculation formula of salary data. The operator item registration screen is shown in FIG.
In the lower right part of FIG. 4, there is an "operator item" column in which operators +,-, *, /, (,) are displayed together with their meanings. It is possible to include data on attendance items in these formulas. FIG. 5 shows a screen for registering attendance items in the calculation formula. In the specific example of FIG. 5, a state in which the number of absent days N5 of the attendance item is registered in the calculation formula 2 of the full-time allowance is shown.

Numerical values can be included in these calculation formulas. Numerical value "500" in formula 2
0 ”is used, and the numerical value“ 0.9 ”is used in the calculation formula 3 of the sales allowance.
5 ”is used. Shortened input items will be described with reference to FIG. As described above, salary items include fixed items that do not change monthly such as basic salary, and variable items that change monthly such as overtime allowance. In this embodiment, fixed items are also displayed without distinguishing variable items. For this reason, the planned salary item for which the salary data is to be input is set in advance as a short input item, and when the data is input, the cursor can be moved only to the planned salary item, so that the salary data can be input. It can be shortened.
FIG. 6 is a registration screen for abbreviated input items. In FIG. 6, adjustment allowance, conference allowance, full-time allowance, price allowance, sales allowance, meal allowance, reduction allowance, deposit, mutual aid loan, advance / actual item are registered as planned salary items (abbreviated input items). There is.

Next, a method of inputting salary data by an operator will be described with reference to FIGS. 1, 7 and 8. By the above-described method, the calculated salary item is registered together with the calculation formula, and when the shortened input item is registered, the operator enters the actual salary data input operation. FIG. 7 shows a display screen in a state where the input of salary data and the calculation of salary data according to the present embodiment are not completed. In FIG. 7, data of attendance items is not transferred, and only salary data of fixed items such as basic salary are displayed. Is a payroll item,
Meeting allowance (calculation formula 1), sales allowance (calculation formula 3), meal allowance (calculation formula 4), company housing expenses (calculation formula 5), deposit (calculation formula 6) The data is displayed.

When the salary data is input / corrected, the cursor is first positioned at the employee number, so if the employee number is input there, the data input screen is displayed. When the operator presses the return key, the cursor sequentially moves in the salary item order. In a normal salary item, the cursor moves to the position of the amount data in the lower row, but in the case of a calculated salary item that requires data input for the number of times item, the cursor moves directly to the upper stage where the number of times item is displayed.

For example, in the case of the conference allowance, the cursor is moved to the upper frequency item. When the operator inputs the number C1 of meetings, according to the calculation formula 1 (T1 * C1), the number of times C1 is added to “2000” yen, which is the calculated unit price item T1 of the meeting allowance.
The salary data for the meeting allowance multiplied by is automatically calculated,
It is displayed at the bottom of the meeting allowance. Regarding the calculated salary item, the sales allowance, the meal allowance, the company housing expense, and the deposit, which use the number of times item in the calculation formula, the cursor moves to the number of times item in the upper row to prompt the operator to input data.

Note that the full-time allowance of the calculated salary item does not use the frequency item, and if the number of absentee days is input, calculation is performed according to the calculation formula 2 and the calculation result is displayed as salary data. When entering data, the cursor moves to the salary data in the lower row, and the operator is prompted to correct the data for full-time allowance. When the salary data is input by the operator and the salary data is calculated, a display screen as shown in FIG. 1 is displayed and the input of the salary data is completed.

As described above, according to this embodiment, even when the data of the salary item calculated by using the special calculation formula is input,
The burden on the operator can be reduced. Next, the shortening input in this embodiment will be described with reference to FIG. When the abbreviated input is selected, the cursor moves only to the abbreviated input items shown by the thick frame in FIG. 1, and the input work of salary data can be shortened. In the specific example of FIG. 1, cursors are only registered as adjustment input items, adjustment allowance, meeting allowance, full-time allowance, price allowance, sales allowance, meal allowance, reduced amount, deposit, mutual aid loan, advance / actual item. Moves. In addition, the cursor moves to the upper row, which is the number of items for the calculated allowance such as meeting allowance, sales allowance, meal allowance, and deposit.

Next, the mask input in this embodiment will be described with reference to FIG. If you do not want the salary data of your workers to be revealed, you can select the masked entry. When the operator wants to input the mask data so that the salary data is not displayed on the screen, he presses a predetermined key, for example, the "ESC key". By doing so, as shown in FIG. 8, the salary data of salary items other than the planned input salary item (abbreviated input item) among the payment item, the deduction item, and the calculation item is not displayed. Salary data that would be troublesome for others to see is masked, and the salary data of workers is kept secret. In the specific example of FIG. 8, all worker items and attendance items are displayed.

The operator inputs salary data on the mask input screen shown in FIG. 8. However, since the salary data is displayed for the planned salary item (abbreviated input item) for actually inputting salary data. , There is no problem in data input work. To cancel the mask input screen shown in FIG. 8, the operator presses a predetermined key such as “E”.
Just press the "SC key" again. As shown in Figure 1,
The data input screen is displayed with the salary data of all salary items.

In this way, the salary data of the worker can be corrected and input without any trouble without revealing the important salary data of the worker. Moreover, since the salary data can be corrected and input without revealing the important salary data of the worker, it is possible to allow a worker such as a part-time worker who does not have the right to access the salary data to input the data.

Next, a method of correcting master data in this embodiment will be described with reference to FIGS. 9 and 10. In this embodiment, it is possible to directly correct the master data, which is the basis of the calculation of salary data, while displaying pay statements such as worker items, attendance items, and salary items. Items for which master data can be corrected are displayed at the bottom of the display screens in FIGS. 9 and 10. Of the master data, basic items (basic), social insurance items (company insurance), attendance unit price items (unit price),
The formula unit price item (calculation), bank transfer / resident tax item (bank), and income tax item (income tax) can be modified.

For example, in FIG. 9, the unit price item of the calculation formula is corrected. When the function key corresponding to “calculation” is pressed, the correction window of the calculation unit price item shown in FIG. 9 opens, and data can be directly input and corrected for the calculation formula unit price item which is the master data. Moreover, in FIG. 10, the income tax items are corrected. When the function key corresponding to “income tax” is pressed, the correction window for the income tax item shown in FIG. 10 opens, and the income tax which is the master data can be input and directly corrected.

As described above, according to this embodiment, the master data such as the basic salary and the social insurance premium, which is the basis of the calculation of the salary data, can be easily corrected during the input of the salary data. The present invention is not limited to the above embodiment, and various modifications can be made. For example, the specific examples of each salary item in the above embodiment are merely examples, and may differ depending on the salary system of the company.

[0037]

As described above, according to the present invention, employee items such as employee number and name of a worker, attendance items such as attendance time and overtime hours, and salary items such as basic salary and overtime allowance are provided. In the salary data input method of inputting salary data for attendance items or salary items while displaying, a predetermined calculation formula using a predetermined unit price item and the number of times data is entered is registered from the salary item. The calculated salary item is set in advance, and when the salary data for the calculated salary item is input, the number of times data is input to the number of times item and the calculation is performed based on a predetermined calculation formula, so that the salary data is input to the calculated salary item. Therefore, when inputting the data of the salary item calculated by using the special calculation formula, the burden on the operator can be reduced.

[Brief description of drawings]

FIG. 1 is a diagram showing a salary data input screen according to a salary data input method according to an embodiment of the present invention.

FIG. 2 is a diagram showing a registration screen for registering a calculated salary item in the salary data input method according to the embodiment of the present invention.

FIG. 3 is a diagram showing a registration screen for registering a calculation unit price item in a calculation formula in the salary data input method according to the embodiment of the present invention.

FIG. 4 is a diagram showing a registration screen for registering operator items in a calculation formula in the salary data input method according to the embodiment of the present invention.

FIG. 5 is a diagram showing a registration screen for registering attendance items in a calculation formula in the salary data input method according to the embodiment of the present invention.

FIG. 6 is a diagram showing a registration screen of a planned salary item (abbreviated input item) in the salary data input method according to the embodiment of the present invention.

FIG. 7 is a diagram showing a salary data input screen in a salary data input method according to an embodiment of the present invention.

FIG. 8 is a diagram showing a mask input screen in the salary data input method according to the embodiment of the present invention.

FIG. 9 is a diagram showing a screen for correcting master data (calculation unit price item) in the salary data input method according to the embodiment of the present invention.

FIG. 10 is a diagram showing a master data (income tax item) correction screen in the salary data input method according to the embodiment of the present invention.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Seiichi Kurodan 1-1-1, Nishishinjuku, Shinjuku-ku, Tokyo Within the Obic Business Consultants Co., Ltd. (72) Inventor Shizuo Iwasaki Nishishinjuku, Shinjuku-ku, Tokyo 2-1-1, Obic Business Consultant Co., Ltd. (72) Inventor Atsushi Okamoto 2-1-1, Nishishinjuku, Shinjuku-ku, Tokyo Within Obic Business Consultant Co., Ltd.

Claims (4)

[Claims] [Claim 1] The attendance item or salary item is displayed while displaying the employee item such as employee number or name of the employee, attendance items such as attendance time and overtime hours, and salary items such as basic salary and overtime allowance. In the salary data input method for inputting salary data, a calculated salary item in which a predetermined calculation formula using a predetermined unit price item and the number of times data is input is registered from the salary item is predetermined. When the salary data for the calculated salary item is input, the salary data is input to the calculated salary item by inputting the frequency data to the frequency item and calculating based on the predetermined calculation formula. How to enter salary data. 2. The salary data input method according to claim 1, wherein when the salary data is input, the master that is a basis for calculating the salary data is displayed while displaying the worker item, the attendance item, and the salary item. A salary data input method characterized by directly correcting data. 3. The salary data input method according to claim 1 or 2, when the salary data is input, the employee item is displayed at the top like a pay statement to be paid to the employee, and the attendance item is displayed. Is displayed below the worker item, the salary item is displayed below the attendance item, and in the calculated salary item, the number-of-times data is displayed together with the salary data. 4. The salary data input method according to any one of claims 1 to 3, wherein an expected salary item to be input with the salary data or the number of times items is predetermined from the salary item, A salary data input method, wherein at least salary data of salary items other than the planned salary item is not displayed when data is input.