JP2022046199A - Wage-advance-payment-time overpayment prevention device, wage-advance-payment-time overpayment prevention method and wage-advance-payment-time overpayment prevention program - Google Patents

Abstract

To provide a wage-advance-payment-time overpayment prevention device and the like capable of preventing overpayment at the wage advance payment by calculating, when the wage advance payment is made to dispatch staffs, the allowable advance payment amount on the basis of days for which dispatch staffs have already worked.SOLUTION: A wage-advance-payment-time overpayment prevention method in this embodiment, comprises the steps of: (1) acquiring a predetermined time and a basic unit wage associated with an input staff code and associated with an input contract period which input month/year belongs to, from contract work data including a staff code, a contract period, a predetermined time and a basic unit wage; (2) acquiring work days associated with the input staff code and work days belonging to the input month/year, from attendance performance data including the staff code and work days; (3) calculating an amount of salary up to a current time point in the input month/year on the basis of the predetermined time and the basic unit wage acquired and the number of work days acquired; and (4) calculating an amount obtained by subtracting the predetermined amount from the amount of wage calculated up to the current time point, as an allowable advance payment amount.SELECTED DRAWING: Figure 2

Description

The present invention relates to a payroll prepayment overpayment prevention device, a payroll prepayment overpayment prevention method, and a payroll prepayment overpayment prevention program.

Patent Document 1 states, "In recent years, working styles such as dispatched workers, part-time workers, contract employees, and part-time employees have diversified, and lifestyles and values have also diversified. There has been an increase in the demand for prepaid salaries to receive salaries immediately after employment (see paragraph 0003 of Patent Document 1). The reception unit 23 calculates the maximum amount that can be prepaid to the worker by referring to the amount deposited in the prepaid account as salary for the worker's labor, and compares the prepaid amount in the prepaid request with the maximum amount. (See paragraph 0036 of Patent Document 1).

Japanese Unexamined Patent Publication No. 2020-4143

In the dispatching industry and the like, the demand for prepayment of salary is increasing, and as described in Patent Document 1, a technique that can automatically calculate the prepayment amount has also appeared. However, there is a problem that overpayment occurs when an employee who has paid the salary in advance retires immediately after that. Therefore, there is a demand for a method that can calculate the amount of prepayment so that overpayment does not occur as much as possible, but it has not been realized yet.

The present invention has been made in view of the above problems, and when paying a salary to a dispatched staff member in advance, the amount that can be paid in advance is calculated based on the number of days that the dispatched staff member has already been in operation. , The purpose of which is to provide a payroll prepayment overpayment prevention device, a payroll prepayment overpayment prevention method and a payroll prepayment overpayment prevention program which can prevent overpayment at the time of payroll prepayment.

In order to solve the above-mentioned problems and achieve the object, the payroll prepaid overpayment prevention device according to the present invention is provided with a control unit to prevent overpayment when payroll is prepaid to dispatched staff. It is a salary prepayment overpayment prevention device that can be used by the control unit from contract data including dispatch staff identification data for identifying the dispatch staff, contract period, predetermined working hours, and unit price information. Prescribed working hours and unit price information linked to the input dispatch staff identification data for the dispatch staff who wishes to pay in advance and to the contract period to which the entered year and month to which the dispatch staff wishes to pay in advance belongs. From the attendance record data including the means for acquiring the unit price information, etc., the dispatched staff identification data, and the working day which is the day when the dispatched staff worked, the dispatched staff identification data is linked to the input dispatched staff identification data. , The working day acquisition means for acquiring the working days belonging to the entered year and month, the predetermined working hours and unit price information acquired by the unit price information acquisition means, and the number of working days acquired by the working day acquisition means. Based on, when the last day of the days when the dispatched staff has already worked is considered to be the current time, the current salary amount which is the current salary amount up to the present time in the entered year and month is calculated. Prepaid amount calculated by subtracting a predetermined amount from the current salary calculated by the calculation means and the current salary calculation means as the prepaid amount that can be prepaid to the dispatched staff. It is characterized by having a possible amount calculation means.

Further, in the salary prepayment overpayment prevention device according to the present invention, the control unit uses the deduction data including the dispatch staff identification data, the year and month, and the deduction amount which is the amount deducted in the year and month. , The previous month deduction amount acquisition means for acquiring the deduction amount associated with the input dispatch staff identification data and the month before the input year and month is further provided, and the prepayable amount calculation means It is characterized in that the amount obtained by subtracting the previous month's deduction amount acquired by the previous month's deduction amount acquisition means from the current salary amount calculated by the current current salary amount calculation means is calculated as the prepayable amount.

Further, in the device for preventing overpayment at the time of prepaid salary according to the present invention, the control unit includes the dispatch staff identification data, the prepaid date which is the date when the prepaid is made, and the prepaid amount which is the amount of the prepaid. Further provided with a prepaid amount acquisition means for acquiring the prepaid amount linked to the input dispatch staff identification data and the prepaid date belonging to the entered year and month from the prepaid data including the above-mentioned prepaid amount. The calculation means is characterized in that the amount obtained by subtracting at least the prepaid amount acquired by the prepaid amount acquisition means from the current salary calculated by the current salary calculation means is calculated as the prepaid possible amount.

Further, the method for preventing overpayment at the time of payroll prepayment according to the present invention can prevent overpayment at the time of prepayment of salary to dispatched staff, which is executed by an information processing apparatus provided with a control unit. The prepayment method is a payment prevention method, which is executed by the control unit and is based on the contract data including the dispatch staff identification data for identifying the dispatch staff, the contract period, the predetermined working hours, and the unit price information. Acquires the prescribed working hours and unit price information linked to the input dispatch staff identification data for the dispatch staff who wishes to pay, and to the contract period to which the entered year and month to which the dispatch staff wishes to pay in advance belongs. From the attendance record data including the unit price information acquisition step, the dispatched staff identification data, and the working day which is the day when the dispatched staff worked, the dispatched staff identification data is linked to the input dispatched staff identification data and described above. In the working day acquisition step to acquire the working days belonging to the input year and month, the predetermined working hours and unit price information acquired in the unit price information acquisition step, and the number of working days acquired in the working day acquisition step. Based on this, if the last day of the days already worked by the dispatched staff is considered to be the current time, the current salary calculation step for calculating the current salary, which is the salary up to the present time in the entered year and month. And, the amount obtained by subtracting a predetermined amount from the current salary calculated in the current salary calculation step is calculated as the prepayable amount which is the prepayable amount to the dispatched staff. It is characterized by including, and.

Further, the salary prepayment overpayment prevention program according to the present invention can prevent overpayment when paying prepayment to dispatched staff for execution by an information processing apparatus provided with a control unit. From the contract data including the dispatch staff identification data for identifying the dispatch staff, the contract period, the predetermined working hours, and the unit price information, which is an overpayment prevention program and is to be executed by the control unit. Prescribed working hours and unit price information linked to the input dispatch staff identification data for the dispatch staff who wishes to pay in advance and to the contract period to which the entered year and month to which the dispatch staff wishes to pay in advance belongs. From the attendance record data including the unit price information acquisition step to acquire, the dispatched staff identification data, and the working day which is the day when the dispatched staff worked, the dispatched staff identification data is linked to the input dispatched staff identification data. , The working day acquisition step to acquire the working days belonging to the input year and month, the predetermined working hours and unit price information acquired in the unit price information acquisition step, and the number of working days acquired in the working day acquisition step. Based on, when the last day of the days when the dispatched staff has already worked is considered to be the current time, the current salary amount which is the current salary amount up to the present time in the entered year and month is calculated. The calculation step and the amount obtained by subtracting a predetermined amount from the current salary calculated in the current salary calculation step can be calculated as a prepaid amount that can be prepaid to the dispatched staff. It is characterized by including a forehead calculation step.

According to the present invention, when paying a salary in advance to a dispatched staff member, it is possible to prevent overpayment at the time of paying the salary in advance by calculating the amount that can be paid in advance based on the number of days that the dispatched staff member has already operated. It has the effect of being able to do it.

FIG. 1 is a block diagram showing an example of a configuration of an overpayment prevention device at the time of payroll prepayment. FIG. 2 is a diagram showing an example of contract work data, attendance record data, salary deduction data, and prepaid data. FIG. 3 is a diagram showing a screen example in this embodiment.

Hereinafter, embodiments of the salary prepaid overpayment prevention device, the salary prepaid overpayment prevention method, and the salary prepaid overpayment prevention program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
In the dispatch industry, there are many staff whose salaries are unstable, and since the prepaid salary system is effective for hiring staff, there are many companies that prepaid salaries. However, when the staff retires, there is a problem that if the prepaid salary is excessively paid, the prepaid salary cannot be collected.

For this reason, in the past, in order to prevent excessive prepayment, the salary amount already incurred at the time of prepayment and the deduction amount (social insurance cost and company housing cost) that will occur in that month are grasped. However, although the amount of advance payment was calculated by manual calculation, there was a problem that the work efficiency was very poor and it took time.

Therefore, in the present embodiment, for example, by combining a dispatch system, a salary system, a prepaid system, etc., the estimated salary at the present time is calculated from the number of days that the staff has already operated, and the social insurance cost and the social insurance cost are calculated from the estimated salary. By deducting dormitory fees, etc., it is now possible to automatically calculate how much advance payment will not result in overpayment.

As a result, for example, it has become possible to reduce the risk that a staff member who has made a prepaid salary will suddenly quit and cannot collect the prepaid salary. In addition, it is no longer necessary to check the attendance record, social insurance deduction, company housing deduction, etc. for each staff member in order to understand how much advance payment can be made. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
An example of the configuration of the overpayment prevention device 100 at the time of payroll prepayment according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the overpayment prevention device 100 at the time of payroll prepayment.

The payroll prepaid overpayment prevention device 100 is a commercially available desktop personal computer. The payroll prepaid overpayment prevention device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer. It may be a portable information processing device such as.

The payroll prepaid overpayment prevention device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the payroll prepaid overpayment prevention device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the payroll prepaid overpayment prevention device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the payroll prepaid overpayment prevention device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data of various masters and the like described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). In addition to the keyboard, mouse, and microphone, the input device 112 can use a monitor that realizes a pointing device function in cooperation with the mouse. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes, for example, contract work data 106a as contract data, attendance record data 106b, salary deduction data 106c as deduction data, and prepaid data 106d.

Here, according to the salary prepaid overpayment prevention device 100 according to the present embodiment, overpayment can be prevented when the salary is prepaid to the dispatched staff. The user of the overpayment prevention device 100 at the time of payroll prepayment according to the present embodiment is, for example, a dispatching company. The prepayment is, for example, paying a salary to the dispatched staff before a predetermined payday. The overpayment means that, for example, because the dispatched staff has retired immediately after the prepayment, a portion of the prepayment amount that cannot be collected occurs. Hereinafter, the specific contents of each data will be described.

The contract work data 106a is data that retains contract information with the dispatched staff. As shown in FIG. 2, the contracted work data 106a includes, for example, dispatched staff identification data (staff code) for identifying the dispatched staff, a contract period, predetermined working hours (predetermined hours), and unit price information (basic). Unit price) and, etc. are included.

The attendance record data 106b is data for holding the attendance record of the dispatched staff. As shown in FIG. 2, the attendance record data 106b includes, for example, the dispatched staff identification data (staff code), a working day which is the day when the dispatched staff worked, and the like.

The salary deduction data 106c is data that holds the deduction amount and the like deducted from the salary amount of the dispatched staff. As shown in FIG. 2, the salary deduction data 106c includes, for example, the dispatched staff identification data (staff code), a year and month, and a deduction amount which is the amount deducted in the year and month. Examples of the deduction amount include social insurance premiums and dormitory expenses.

The prepaid data 106d is data that holds the prepaid amount and the like that have already been paid to the dispatched staff. As shown in FIG. 2, the prepayment data 106d includes, for example, the dispatched staff identification data (staff code), the prepayment date which is the date when the prepayment was made, the prepayment amount which is the amount of the prepayment, and the like. include.

The control unit 102 is a CPU or the like that collectively controls the overpayment prevention device 100 at the time of payroll prepayment. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally conceptually, for example, (1) the prepaid from the contract data including the dispatch staff identification data for identifying the dispatch staff, the contract period, the predetermined working hours, and the unit price information. Acquires the prescribed working hours and unit price information linked to the entered dispatched staff identification data for the dispatched staff who wishes to, and to the contract period to which the entered year and month to which the dispatched staff wishes to pay in advance belongs. The input was made from the attendance record data including the unit price information acquisition unit 102a as a unit price information acquisition means, (2) the dispatched staff identification data, and the working day which is the day when the dispatched staff worked. The working day acquisition unit 102b as a working day acquisition means for acquiring the working day belonging to the entered year and month, which is linked to the dispatched staff identification data, and (3) the predetermined work acquired by the unit price information acquisition means. Based on the time and unit price information and the number of working days acquired by the working day acquisition means, the entered year when the last day of the days already worked by the dispatched staff is considered to be the current time. The current salary calculation unit 102c as a means of calculating the current salary, which is the current salary in the month, and (4) the dispatched staff identification data, the year and month, and the deduction in the year and month. The previous month's deduction amount to obtain the deduction amount linked to the entered dispatched staff identification data and the month before the entered year and month from the deduction amount including the deduction amount. From the prepaid data including the previous month deduction amount acquisition unit 102d as an acquisition means, (5) the dispatched staff identification data, the prepaid date which is the date of the prepaid, and the prepaid amount which is the prepaid amount. , The prepayment amount acquisition unit 102e as a prepayment amount acquisition means for acquiring the prepayment amount associated with the input dispatch staff identification data and the prepayment date belonging to the input year and month, and (6) the above. As a prepayable amount calculation means that calculates the amount obtained by subtracting a predetermined amount from the current salary amount calculated by the current salary amount calculation means as the prepayable amount that is the amount that can be prepaid to the dispatched staff. The prepaid amount calculation unit 102f and the like are provided.

The unit price information acquisition unit 102a is input from the contract work data 106a including the dispatch staff identification data, the contract period, the predetermined working hours, and the unit price information, for the dispatch staff who wishes to pay in advance. Acquires predetermined working hours and unit price information linked to the identification data and linked to the contract period to which the entered year and month to which the dispatched staff wishes to pay in advance belongs.

The working day acquisition unit 102b links the input dispatch staff identification data from the attendance record data 106b including the dispatched staff identification data and the working day, and sets the working day belonging to the input year and month. get.

In the current salary amount calculation unit 102c, the dispatched staff has already worked based on the predetermined working hours and unit price information acquired by the unit price information acquisition unit 102a and the number of working days acquired by the working day acquisition unit 102b. If the last day of the day is considered to be the current time, the current salary amount, which is the salary amount up to the present time in the entered year and month, is calculated.

The previous month deduction amount acquisition unit 102d is associated with the input dispatch staff identification data from the salary deduction data 106c including the dispatch staff identification data, the year and month, and the deduction amount, and the input date and month. Get the deduction amount associated with the month before.

The prepaid amount acquisition unit 102e is associated with the input dispatched staff identification data from the prepaid data 106d including the dispatched staff identification data, the prepaid date, and the prepaid amount, and belongs to the input date. Obtain the prepaid amount associated with the prepaid date.

The prepaid amount calculation unit 102f is an amount that can be prepaid to the dispatched staff by subtracting a predetermined amount from the current salary calculated by the current salary calculation unit 102c. Calculated as.

The prepaid amount calculation unit 102f may calculate the amount obtained by subtracting the previous month deduction amount acquired by the previous month deduction amount acquisition unit 102d from the current salary amount calculated by the current salary amount calculation unit 102c as the prepaid possible amount. .. That is, the prepaid amount calculation unit 102f may calculate the prepaid amount by the formula "the current salary amount-the previous month deduction amount".

The prepayable amount calculation unit 102f may calculate the amount obtained by subtracting at least the prepayment amount acquired by the prepayment amount acquisition unit 102e from the current salary amount calculated by the current salary amount calculation unit 102c as the prepayable amount. That is, the prepaid amount calculation unit 102f calculates the prepaid amount by the formula "the current salary amount-the prepaid amount" or "the current salary amount-the previous month deduction amount-the prepaid amount". You may.

[3. Specific example of processing]
In this item, a specific example of the process according to this embodiment will be described. In this item, we will explain the salary paid in August 2020, which is calculated based on the attendance record for July 2020, assuming that the dispatched staff with staff code "1000" wants to pay in advance. Further, in this item, the explanation will be made on the assumption that the person in charge of payroll at the dispatching company uses the overpayment prevention device 100 at the time of payroll prepayment.

As a premise of the explanation in this item, it is assumed that the contract work data 106a holding the contract information of the dispatched staff is registered in advance with the contents shown in FIG. Also. It is assumed that the attendance record data 106b holding the attendance record for July 2020 of the dispatched staff is registered in advance by the dispatched staff or the like with the contents shown in FIG. Then, it is assumed that the salary deduction data 106c holding the deduction amount for June 2020 of the dispatched staff is registered in advance with the contents shown in FIG. Further, it is assumed that the prepaid data 106d holding the prepaid amount already paid to the dispatched staff in July 2020 is registered in advance with the contents shown in FIG.

[3-1. Unit price information acquisition process]
First, the unit price information acquisition unit 102a acquires the contract in which the staff is operating at that time from the contracted work data 106a, using the staff and the year and month as keys. The image of the acquired contract is the table of "target work" shown in FIG.

Specifically, as shown in FIG. 3, it is assumed that "1000" is input as the staff code and "2020/07" is input as the year and month by the salary payer. In this case, the unit price information acquisition unit 102a is associated with the input staff code "1000" from the contracted work data 106a in FIG. 2, and the contract period "2020" to which the input "2020/07" belongs. As information linked to "/7/1 to 2020/9/30", we will acquire the specified time of 8:00 and the basic unit price of 2500 yen.

[3-2. Working day acquisition process]
Next, the working day acquisition unit 102b acquires the days that are already in operation at the present time from the attendance record data 106b. Specifically, the working day acquisition unit 102b is associated with the input staff code "1000" from the attendance record data 106b in FIG. 2, and is set as a working day belonging to the input "2020/07". , 2020/07 / 01,02,03,04,05,08,09,10,11,12 Get 10 working days.

[3-3. Current salary calculation process]
Next, the current salary calculation unit 102c calculates the estimated salary currently generated. Specifically, the current salary calculation unit 102c has a predetermined time of 8:00 and a basic unit price of 2500 yen acquired by the unit price information acquisition unit 102a, and 10 working days acquired by the work day acquisition unit 102b. Based on, 10 days x basic unit price 2500 yen x predetermined time 8:00 = 200,000 yen. The 200,000 yen is the salary of the dispatched staff up to the present time (= 2020/07/12) as of July 2020.

[3-4. Previous month deduction acquisition process]
Next, the previous month deduction amount acquisition unit 102d acquires the social insurance premium deducted in the previous month and the amount deducted in the previous month other than social insurance from the salary system (salary deduction data 106c). Specifically, the previous month deduction amount acquisition unit 102d is associated with the input staff code "1000" from the salary deduction data 106c in FIG. 2, and the month before the input "2020/07". As a deduction amount linked to "2020/06", the social insurance premium of 20,000 yen and the total deduction (= deduction amount other than social insurance) of 65,000 yen will be acquired.

[3-5. Prepaid amount acquisition process]
Next, the prepaid amount acquisition unit 102e acquires the amount already prepaid this month from the prepaid data 106d. The image of the acquired prepaid amount is the table of "prepaid history" shown in FIG. Specifically, the prepaid amount acquisition unit 102e is associated with the entered staff code "1000" and with the prepaid date "2020/07/01" belonging to the entered "2020/07". Acquire 20,000 yen as a prepaid amount.

[3-6. Prepaid amount calculation process]
Finally, the prepaid amount calculation unit 102f calculates and displays the prepaid balance. Specifically, the prepaid amount calculation unit 102f has a social insurance premium of 20,000 yen and a total deduction of 65,000 yen acquired by the previous month's deduction amount acquisition unit 102d from 200,000 yen calculated by the current salary amount calculation unit 102c, and the prepaid amount acquisition unit. By deducting the prepaid amount of 20,000 yen acquired in 102e, that is, by calculating 200,000 yen-20,000 yen-65,000 yen-20,000 yen, the amount of 95,000 yen can be used as the prepaid balance. calculate.

Then, the person in charge of payroll inputs the amount to be paid in advance this time within the range of the calculated balance of 95,000 yen in the place of "prepaid amount" in the table of "prepayment this time" shown in FIG. In the example of Fig. 3, 40,000 yen is entered in the "prepaid amount" section, but since the entered prepaid amount of 40,000 yen is an amount of 95,000 yen or less that can be prepaid, the prepaid amount can be made without any problem. Will be. Then, in the "balance" section of the "prepaid this time" table in FIG. 3, 55,000 yen is displayed as the balance obtained by subtracting the input prepaid amount of 40,000 yen from the prepaidable balance of 95,000 yen.

[3-7. summary]
As described above in [3-1] to [3-6], according to the salary prepaid overpayment prevention device 100 according to the present embodiment, the dispatched staff has the attendance record for July 2020. If you wish to prepay the salary paid in August 2020, the estimated salary will be calculated based on the number of days the dispatched staff has worked up to the present time (= 2020/07/12). By deducting the deduction amount for June 2020 and the salary amount already paid in July 2020 from the estimated salary amount, it is possible to make the prepayment within the range where overpayment will not occur.

[4. Summary of this embodiment]
As described above, according to the salary prepaid overpayment prevention device 100 according to the present embodiment, when the salary is prepaid to the dispatched staff, the prepaid can be made based on the number of days that the dispatched staff has already operated. By calculating a large amount, it is possible to prevent overpayment at the time of prepaid salary.

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

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the salary prepaid overpayment prevention device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the payroll prepaid overpayment prevention device 100, particularly each processing function performed by the control unit, all or any part thereof may be interpreted and executed by the CPU and the CPU. It may be realized, or it may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and at the time of prepayment of salary as necessary. It is read mechanically by the overpayment prevention device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in an application program server connected to the payroll prepaid overpayment prevention device 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is also possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Probe Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the payroll prepayment overpayment prevention device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. good. Further, the payroll prepaid overpayment prevention device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful in an industry such as a dispatching industry that has a salary prepayment system.

100 Overpayment prevention device at the time of payroll prepayment 102 Control unit
102a Unit price information acquisition department
102b Working day acquisition department
102c Current salary calculation department
102d Previous month deduction acquisition department
102e Prepaid amount acquisition department
102f Prepaid amount calculation unit 104 Communication interface unit 106 Storage unit
106a Contracted work data
106b Attendance record data
106c salary deduction data
106d Prepaid data 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

It is a salary prepayment overpayment prevention device that has a control unit and can prevent overpayment when paying prepayment to dispatched staff.
The control unit
From the contract data including the dispatched staff identification data for identifying the dispatched staff, the contract period, the predetermined working hours, and the unit price information, the dispatched staff identification data input for the dispatched staff who wishes to pay in advance. And the unit price information acquisition means to acquire the prescribed working hours and unit price information linked to the contract period to which the entered year and month to which the dispatched staff wishes to pay in advance belongs.
From the attendance record data including the dispatched staff identification data and the working day which is the day when the dispatched staff worked, the work is linked to the input dispatched staff identification data and belongs to the input year and month. How to get the working day to get the day, and
Based on the predetermined working hours and unit price information acquired by the unit price information acquisition means and the number of working days acquired by the work day acquisition means, the last day of the days already worked by the dispatched staff is currently set. When the current salary amount, which is the current salary amount up to the present time in the entered year and month, is calculated, and the current salary amount calculation means.
Prepaid amount calculation means for calculating the amount obtained by subtracting a predetermined amount from the current salary calculated by the current salary calculation means as the prepaid possible amount, which is the amount that can be prepaid to the dispatched staff. When,
To prepare for
An overpayment prevention device for payroll prepayment. The control unit
From the deduction data including the dispatched staff identification data, the year and month, and the deduction amount that is the amount deducted in the year and month, the year and month linked to the entered dispatched staff identification data and the entered year. Further equipped with the previous month deduction amount acquisition means to acquire the deduction amount associated with the month before the month,
The prepayable amount calculation means calculates the amount obtained by subtracting the previous month deduction amount acquired by the previous month deduction amount acquisition means from the current salary amount calculated by the current salary amount calculation means as the prepayable amount.
The overpayment prevention device for payroll prepayment according to claim 1. The control unit
From the prepayment data including the dispatched staff identification data, the prepayment date which is the date when the prepayment was made, and the prepayment amount which is the amount of the prepayment, the dispatched staff identification data linked to the input dispatch staff identification data and Further provided with a prepaid amount acquisition means for acquiring the prepaid amount associated with the prepaid date belonging to the entered year and month.
The prepayable amount calculation means calculates the amount obtained by subtracting at least the prepayment amount acquired by the prepayment amount acquisition means from the current salary amount calculated by the current salary amount calculation means as the prepayable amount.
The device for preventing overpayment at the time of payroll prepayment according to claim 1 or 2. It is a salary prepayment prevention method that can prevent overpayment when paying prepayment to dispatched staff, which is executed by an information processing device equipped with a control unit.
Executed by the control unit,
From the contract data including the dispatched staff identification data for identifying the dispatched staff, the contract period, the predetermined working hours, and the unit price information, the dispatched staff identification data input for the dispatched staff who wishes to pay in advance. And the unit price information acquisition step to acquire the prescribed working hours and unit price information linked to the contract period to which the entered year and month to which the dispatched staff wishes to pay in advance belongs.
From the attendance record data including the dispatched staff identification data and the working day which is the day when the dispatched staff worked, the work is linked to the input dispatched staff identification data and belongs to the input year and month. The working day acquisition step to acquire the day and
Based on the predetermined working hours and unit price information acquired in the unit price information acquisition step and the number of working days acquired in the working day acquisition step, the last day of the days already worked by the dispatched staff is currently set. If you think that, the current salary calculation step for calculating the current salary, which is the current salary in the entered year and month, and
The prepaid amount calculation step The prepaid amount calculation step is calculated by subtracting a predetermined amount from the calculated current salary amount as the prepaid possible amount, which is the amount that can be prepaid to the dispatched staff. ,
To include,
A method for preventing overpayment at the time of payroll prepayment, which is characterized by. It is a salary prepayment overpayment prevention program that can prevent overpayment when paying prepayment to dispatched staff to be executed by an information processing device equipped with a control unit.
To make the control unit execute
From the contract data including the dispatched staff identification data for identifying the dispatched staff, the contract period, the predetermined working hours, and the unit price information, the dispatched staff identification data input for the dispatched staff who wishes to pay in advance. And the unit price information acquisition step to acquire the prescribed working hours and unit price information linked to the contract period to which the entered year and month to which the dispatched staff wishes to pay in advance belongs.
From the attendance record data including the dispatched staff identification data and the working day which is the day when the dispatched staff worked, the work is linked to the input dispatched staff identification data and belongs to the input year and month. The working day acquisition step to acquire the day and
Based on the predetermined working hours and unit price information acquired in the unit price information acquisition step and the number of working days acquired in the working day acquisition step, the last day of the days already worked by the dispatched staff is currently set. If you think that, the current salary calculation step for calculating the current salary, which is the current salary in the entered year and month, and
The prepaid amount calculation step The prepaid amount calculation step is calculated by subtracting a predetermined amount from the calculated current salary amount as the prepaid possible amount, which is the amount that can be prepaid to the dispatched staff. ,
To include,
A program to prevent overpayment at the time of payroll prepayment.

Images