JP2019061526A - Payroll system, payroll method and program - Google Patents

Abstract

To provide a more convenient salary receipt system that allows an employee to easily receive a prescribed payment amount based on a salary of the employee when necessary, while reducing a financial and operational burden on an employer side.SOLUTION: A salary receipt system 1 includes a salary receipt apparatus 10, a company terminal 20, and an employee terminal 30. The salary receipt apparatus 10 includes: a request processing unit 102 that receives an application for salary receipt including an application amount from an employee; an applicable amount calculation unit 103 that calculates, on the basis of accumulated data on employee working hours and salary unit price, an applicable amount of salary receipt of the employee; a payment amount calculation unit 104 that calculates a payment amount on the basis of an assumed advance money amount for a month set for each employer, the applicable amount and the application amount; and a transfer data table creation unit 106 that creates transfer data to transfer a payment amount to an account of the employee.SELECTED DRAWING: Figure 3

Description

  The present invention relates to a payroll system, a payroll method, and a program.

  There is known a prepaid salary system that allows an employee to receive labor compensation for labor already provided at any time (see, for example, Patent Document 1). In the payroll prepayment system described in this patent document 1, daily salary data of the employee is created on a daily basis, accumulated data in a period from a predetermined start date to a prepayment application date is calculated, and prepayment is already made from the accumulated data. The available money is calculated by subtracting the accumulated data of the money data, and the application money is withdrawn from the account of the employer and transferred to the account of the employee.

Patent No. 4395413 gazette

  However, in the prior art, the employer had to prepare a lump sum for prepayment, which was burdensome. In addition, there was also an effort such as calculating daily salary data.

  The present invention has been made in view of the above-described circumstances, and allows an employee to easily receive a prescribed payment amount based on a salary when necessary, and in addition, the employer's financial and working side. It is possible to reduce the burden and provide a more convenient payroll system, payroll method and program.

  In order to achieve the above object, the payroll system pertaining to the present invention has an application processing unit that receives an application for payroll reception including an application amount from an employee, accumulated data of working hours of the employee, a salary unit price, and already paid An available amount calculation unit that calculates the applicable amount of the salary receipt of the employee based on the amount, a payment amount calculated based on the maximum amount set for each employer, the applicable amount, and the application amount A payment amount calculation unit, and a transfer data creation unit for creating transfer data including the payment amount and the account data of the employee, and at least a part of the employee's salary on behalf of the employer It is characterized by being replaced and paying.

  In addition, the payroll processing according to the present invention includes the application processing step of receiving an application for payroll reception including the application amount from the employee, the accumulated data of working hours of the employee, the salary unit price, and the above-mentioned employee based on the already paid amount. The application possible amount calculation process which calculates the application possible amount of the payroll receipt, the payment amount calculation process which calculates the payment amount based on the ceiling set for each employer, the application possible amount and the application amount, A transfer data creation step of creating transfer data including the payment amount and the account data of the employee, and replacing at least a part of the salary of the employee on behalf of the employer. I assume.

  In the program according to the present invention, the computer may be an application processing means for receiving an application for salary receipt including an application amount from the employee, the accumulated data of working hours of the employee, the salary unit price, and the employee based on the already paid amount. Applicable amount calculation means for calculating the application possible amount of payroll receipt, Payment amount calculation means for calculating the payment amount based on the limit amount set for each employer, the application possible amount and the application amount, the payment It is a program for functioning as transfer data creation means which creates transfer data including the amount of money and the account data of the employee.

  According to the present invention, an employee can easily receive a predetermined payment amount based on a salary when necessary, and the burden on the employer's side can be reduced, which is more convenient. Payroll system, payroll method, and program can be provided.

It is a schematic diagram showing an example of composition of a payroll receipt system concerning one embodiment of the present invention. It is a figure which shows the hardware constitutions example of the salary receipt system shown in FIG. 1, (a) shows the hardware constitution example of a salary receipt apparatus, (b) shows the hardware in case a company terminal and an employee terminal are PC. An example of a hardware configuration is shown, and (c) shows an example of a hardware configuration when the business terminal and the employee terminal are smart phones. It is a block diagram which shows the function structural example of the salary receipt system shown in FIG. It is a figure which shows an example of the data structure of a company code table. It is a figure showing an example of a data structure of a salary pattern table. It is a figure which shows an example of the data structure of an employee table. It is a figure which shows an example of the data structure of a total data table. It is a figure which shows an example of the data structure of a request table. It is a figure which shows an example of the data structure of a transfer table. It is a figure which shows an example of the data structure of a decanting data table. FIG. 6 is a sequence diagram showing an example of a flow of salary pattern data update processing in the salary receipt system according to the present embodiment. FIG. 7 is a sequence diagram showing an example of a flow of application processing of salary receipt in the salary receipt system according to the present embodiment. FIG. 7 is a sequence diagram showing an example of a flow of confirmation processing of usage history and cancellation processing of a salary receipt application in the salary receipt system according to the present embodiment. FIG. 6 is a sequence diagram showing an example of the flow of transfer processing in the payroll system according to the present embodiment. FIG. 7 is a sequence diagram showing an example of a flow of deduction data table creation processing in the payroll system according to the present embodiment. It is an example of a screen displayed on the display part of a company terminal, (a) shows a login screen, (b) shows a salary pattern change initial screen, (c) shows a salary pattern detail screen. It is an example of a screen displayed on the display part of an employee terminal, (a) shows a login screen and (b) shows a password change screen. (A) shows the application top screen, (b) shows the transfer destination account list screen, (c) shows the application amount input screen, and (d) shows the transfer. (E) shows a transfer account specification screen, (f) shows an application content confirmation screen, and (g) shows a reception completion screen. (A) shows the application top screen, (b) shows the usage history screen, (c) shows the application cancellation confirmation screen, and (d) shows the cancellation acceptance completion. Show the screen. It is explanatory drawing for demonstrating a prepayment application OK period and NG period.

  Hereinafter, an embodiment of a payroll system according to the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing a configuration example of a payroll receiving system 1 according to the present embodiment. Here, “salary receipt” in the present specification means that the employee receives a predetermined payment amount based on salary at any time before the salary payment date. The payment amount also includes compensation for labor already provided by the employee, and advance payment and temporary payment based on salary. As shown in FIG. 1, the payroll system 1 according to the present embodiment includes a payroll system 10 provided to a provider (hereinafter referred to as a “host”) that provides payroll service by the payroll system 1, and a payroll system. Company terminals 20, 20, ... as information terminals provided to a plurality of companies who are employers who have subscribed to the service, and employees as information terminals owned by employees who are workers (employees) of each company And the terminal 30, 30,...

  The payroll receiving apparatus 10, the company terminal 20, and the employee terminal 30 are connected to one another via the communication network 2. Furthermore, the payroll receiving apparatus 10 is connected via the communication network 3 to transfer systems 50, 50,... Of financial institutions to which pays such as banks are transferred.

  For example, the Internet can be used for the communication network 2, and data transmitted and received between PCs and portable terminals connected to the communication network 2 is transmitted. On the other hand, it is desirable for the communication network 3 to use a dedicated communication line with the transfer system 50 of the financial institution or a closed network for security reasons. Further, although the connection between the corporation terminal 20 and the payroll receiving apparatus 10 may be the Internet, it may be a dedicated communication line or a closed network, which can enhance security.

  The following describes the details of the payroll system 1 on the assumption that the host is a credit company, but the host is not limited to a credit company, and may be a credit sales company other than a credit company. In addition, the host is not limited to a credit sales company, and may be, for example, financial institutions such as various banks, insurance companies, securities companies, and non-banks.

  In the present embodiment, a server personal computer (PC) is used as the salary receiving device 10, but the present invention is not limited to the PC, and a general-purpose large computer (main frame) or the like can also be used. The server PC may use a cloud computing service, or may be its own server PC. Further, in the present embodiment, although the payroll receiving apparatus 10 is configured by one server PC, it is configured by a plurality of server PCs according to the size and purpose of use of the payroll service to be provided. It is also good. In addition, the payroll receiving apparatus 10 also includes a monitor as a display unit and a printer as an output unit, and can display and output various information at the time of operation of the payroll receiving system 1 and at the time of maintenance and inspection.

  The company terminal 20 and the employee terminal 30 can use known desktop type, notebook type, tablet type PCs and the like provided with a monitor, a printer, a communication device and the like. These are not limited to PCs, and devices that can be connected to smartphones, mobile phones, and other communication networks 2 and have a display function such as an image or a data input function can be used.

  Next, a hardware configuration example of the payroll receiving apparatus 10, the corporation terminal 20, and the employee terminal 30 will be described using FIG. As shown in FIG. 2A, the payroll receiving apparatus 10 includes a CPU 11, a ROM 12, a RAM 13, a non-volatile storage 14 including a hard disk drive and a flash memory, and communication for connecting to the communication networks 2 and 3 by wire or wireless. It mainly comprises an I / F 15, an external storage medium 16, a database 17, and the like. These components are electrically connected by a bus 18 so that data can be transmitted and received between the CPU 11 and each part.

  The ROM 12 and the non-volatile storage 14 store various programs and data used in the payroll receiving apparatus 10. The CPU 11 includes a microprocessor or the like, controls the RAM 13 as a work area, and reads and executes an operating system and various programs from the ROM 12 and the non-volatile storage 14 to control the overall operation of the salary reception device 10.

  As the external storage medium 16, for example, storage media such as a CD-ROM, a CD-RW, a DVD-ROM, a DVD-RW, and a flexible disk can be used. For example, a payroll reception program may be stored in the external storage medium 16, and the payroll reception program may be executed by the CPU 11 reading out the payroll reception program and expanding it in the RAM 13.

  The database 17 is a storage unit (storage unit) that stores various tables used by the payroll receiving apparatus 10. As the database 17, a large capacity storage service provided by a cloud provider or the like can be used.

  When the company terminal 20 and the employee terminal 30 are PCs, as shown in FIG. 2B, the CPU 21, RPM 22, RAM 23, non-volatile storage 24, communication I / F 25, external storage medium 26, liquid crystal display, etc. And an input unit 28 formed of a keyboard, a mouse, a touch panel and the like. These components are electrically connected by a bus 29 so that data can be transmitted and received between the CPU 21 and each part.

  The CPU 21 comprises a microprocessor or the like, reads the operating system and other programs stored in the ROM 22, the non-volatile storage 24, and the external storage medium 26 using the RAM 23 as a work area, and executes the enterprise terminal 20 and employees The respective units of the terminal 30 are controlled.

  When the company terminal 20 and the employee terminal 30 are smartphones, as shown in FIG. 2C, the CPU 31, the ROM 32, the RAM 33, the non-volatile storage 34, the EEPROM 35 for reading or writing data, and an image of a subject Various sensors 37 such as camera 36, electronic magnetic compass and gyro compass, acceleration sensor, RTC (Real Time Clock) 38 for outputting current date and time information, microphone 39, speaker 40, antenna 41, communication with the base station and wireless LAN communication , A communication I / F 42 for performing near field communication such as Wi-Fi, a display unit 43 such as a liquid crystal display, and an input unit 44 including a touch panel mounted on the liquid crystal display and operation buttons. These components are electrically connected by a bus 45 so that data can be transmitted and received between the CPU 31 and each unit.

  The CPU 31 is composed of a microprocessor or the like, reads the operating system and other programs stored in the ROM 32 and the non-volatile storage 34 using the RAM 33 as a work area, and executes each part of the company terminal 20 and the employee terminal 30 Control.

  The corporation terminal 20 and the employee terminal 30 execute salary reception processing at the corporation terminal 20 and the employee terminal 30 by accessing the salary reception device 10 via the communication network 2 using a general-purpose browser or the like. Can. Alternatively, a dedicated payroll application program (application) is installed on the company terminal 20 and the employee terminal 30, and the payroll program on the company terminal 20 and the employee terminal 30 is executed by activating the application. It can also be done.

  Next, the function of the payroll system 1 of the present embodiment will be described using the functional block diagram of FIG. Below, the function of payroll receiver 10 is mainly explained.

  As shown in FIG. 3, the payroll receiving apparatus 10 functionally includes a control unit 100 that controls the entire operation of the payroll receiving apparatus 10, and a database 17 as a storage unit. The control unit 100 functions as a salary pattern update unit 101, a request processing unit 102, an available amount calculation unit 103, a payment amount calculation unit 104, a transfer table creation unit 105, a deduction data table creation unit 106, and a notification unit 107. The control unit 100 also functions as a management unit that manages the overall operation of the payroll system 1.

  The database 17 stores a company table T1, a salary pattern table T2, an employee table T3, a cumulative data table T4, a request table T5, a transfer table T6, and a deduction data table T7 as shown in FIGS. 4A to 4G. .

  FIG. 4A is an example of the company table T1, and various data of a company that has subscribed to the payroll service is stored for each company code. The entry of data into the company table T1 is performed on the host side at the time of joining the company's payroll service. In the company table T1, "company code" for identifying a company, "company name (Kanji)", "company name (Kana)", "login ID" for accessing the payroll system 1, "password" , “Type of industry”, “number of employees”, “utilization rate”, “usage unit price”, “expected replacement amount”, “total replacement amount” and the like are stored. The data set in the company table T1 is not limited to these, and other data may be stored. Also, it is not necessary to set all the data listed here. Necessary data can be appropriately set in accordance with the specification of the payroll system 1 and the form and size of the company to be introduced. The same applies to the other tables T2 to T7 described below.

  The “login ID” and “password” can be changed by the company from the company terminal 20. When the change instruction is received, the company table T1 is updated. The “total reimbursement amount” stores the total amount of salaries already received by each employee of each company in the current month.

  “Expected Reimbursement Amount” is the maximum amount of monthly reimbursement amount (total receivable amount) for each employer. The “expected replacement amount” is calculated, for example, by the following formula using “the number of employees”, “usage rate” and “usage unit price”.

Estimated replacement amount (Yen) = Number of employees (person) × Usage rate (%) × Unit price (Yen)

  Using the above equation, for example, in the case of “Inc. A” in FIG. 4A, 1,000 employees × utilization rate 20% × usage unit price 50,000 yen = 10,000,000 yen is the assumed replacement price. The “usage rate” and the “usage unit price” are coefficients, and can be set in advance on the host side in consideration of the type of industry, the size of the company, the management state or performance, the past experience with the host, and the like. The “number of employees”, the “utilization rate”, and the “usage unit price” may be updated, and the “expected replacement amount” may be recalculated and stored.

  The host side makes a credit judgment on the estimated reimbursement amount calculated by the formula, and sets a final estimated reimbursement amount according to the result of the credit judgment, but the present invention is not limited to this. It is also possible to calculate in advance the estimated reimbursement amount using the above-mentioned calculation formula or the like, and store the final estimated reimbursement amount for which credit judgment is made in the company table T1. In this case, it is not necessary to store the number of employees, the usage rate, and the unit price, and the storage capacity can be reduced. The payroll system 1 has a mechanism that can not receive an amount equal to or more than a payroll because it is a system in which an employee receives a predetermined payment amount based on pay at any time. However, in order to suppress excessive use of the payroll service within one company (one employee), an estimated replacement amount (limit amount) is set.

  FIG. 4B is an example of the salary pattern table T2, and various data for each employment category of the company are stored in association with the company code. That is, in the present embodiment, an attendance cycle, a payroll date, a prepayment upper limit rate and the like can be set for each employment category, and based on these, the receipt date and the receipt amount can be set more freely than before. It is possible to provide a more convenient payroll service.

  Although the input of data to the pay pattern table T2 is basically performed on the host side when joining a company's payroll service, the employer side can also update data from the company terminal 20.

  "Employment classification code", "Employment classification name", "Salary classification", "Monthly paid number of times", "Daily calculation days", "Prepayment upper limit rate", "Transfer account 1 change possibility", in salary pattern table T2, “Transfer account 2 changeability”, “transfer account 3 changeability”, “working period”, “depreciated data closing date”, “transfer fee 1”, “transfer fee 2” and the like are stored.

  “Employment classification code” and “employment classification name” are a code representing the employment classification predetermined for each employer and its name. In the example of FIG. 4B, 20: full-time employee, 50: contract employee, 60: non-regular employee, 90: part-time job are set, but there is no limitation to these, and more employment categories can be set. . For example, even for full-time employees, it is possible to set more finely divided employment categories such as general occupations and professional occupations.

  “Payment classification” indicates a form of payment of salary, and for example, monthly salary, weekly salary, daily salary, etc. are set. “Number of monthly payments” indicates the number of salary payments during a month, and is set, for example, once (or twice) in the case of a monthly salary, or four times in the case of a weekly salary. “Daily calculation days” indicates the number of days for the payroll division when the monthly salary is prorated. The "prepayment upper limit rate" is a percentage (%) representing the proportion of the limit that can be received by prepayment out of the total of the total salary.

  Usually, there is a tax or insurance deduction for salaries, and even if the deduction is a salaries, the use is a predetermined part, so it is not desirable to pay the deduction for the employee as cash. Although the deduction amount may be deducted in advance from the gross salary, the salary increases with the passage of days, so an application for receiving a salary at the beginning of the month when the gross salary is small (hereinafter referred to as “prepayment application”). If you do, the total salary may fall below the deduction amount and you may not be able to receive any salary at all. Therefore, the "prepayment upper limit rate" has been established, and at least a part of the salary can be received even at the beginning of the month, while leaving the ability to deduct taxes and insurance premiums.

  “Transfer account 1 changeability”, “transfer account 2 changeability”, and “transfer account 3 changeable” are set as to whether each transfer account data can be changed. In this embodiment, two accounts (transfer accounts 2 and 3) can be specified in addition to a normal pay transfer account (transfer account 1). In order to prevent the employee from changing the transfer account 1 which is the transfer account of the salary without permission, "No" is stored in the "transfer account 1 change possibility". The transfer accounts 2 and 3 may be set as “OK” in “Transfer account 2 changeable”, “Transfer account 3 changeable”, or only one of them as “OK” so that employees can set or change freely. Can be set freely according to the circumstances of the company.

  The closing date of the application for salary receipt is stored in the "deduction data closing date". The company deducts the total amount paid by the host to the employee in the payroll service and deducts it from the salary and transfers it to the transfer account. If the period from the closing date to the payroll date is short, the total payment amount must be known before the closing date to facilitate processing by the employer for deducting the total payment amount. Is desirable. Therefore, in the present embodiment, a date that is several days earlier than the attendance cycle closing date is stored in advance in the pay pattern table T3 as a withdrawal date closing date for each employment category. The payroll receiving apparatus 10 reports to the employer the total amount of payment for each employee paid from the start date of the attendance cycle to the closing date of the deduction data on the closing date of the deduction data.

  The “transfer fee 1” and the “transfer fee 2” store the transfer fee when the payroll system 10 transfers the salary to the transfer account of the employee. Although two storage areas for the transfer fee are provided in the present embodiment, the present invention is not limited to this, and only one may be provided, or three or more may be provided. If two or more storage areas for the transfer fee are provided, for example, the transfer fee can be changed according to the transfer amount.

  FIG. 4C is an example of the employee table T3. For each company, employee data belonging to the company is stored in advance in association with the company code. The employee table T3 includes "company code", "employee code" for identifying the employee, "login ID" and "password" for the employee to access the payroll system 1, and "employee". Name (Kanji) and Name (Kana), Employment classification, Transfer destination 1, Transfer destination 2, Transfer destination 3, Hourly salary for each hourly unit price, Tax division, and Insurance classification, e-mail address, etc. are stored. Although the host side basically performs data entry to the employee table T3, the "login ID" and "password", and the "transfer destination" for the predetermined "transferee" is changed or registered by the employee from the employee terminal 30 It is possible to

  The “employment classification” stores the employment classification name (or the employment classification code) of each employee and is associated with the salary pattern table T2. In the present embodiment, the employee can register up to three payee accounts. In addition, not only so-called banks, such as central banks, regional banks, and net banks, but also Japan Post Bank accounts can be designated as transfer accounts. The "Financial Bank Number", "Branch Number", "Type", "Account Number", "Account" of the three financial institutions of "Remittance Destination 1", "Remittance Destination 2", and "Remittance Destination 3" The data required for the transfer, such as the name, is stored.

  Account data of the payee's payee's payee is stored in advance in "payee's payee 1". With regard to “transfer destination 1”, in order to make it impossible for the employee to change, “transfer account change availability” of each employment category of the pay pattern table T2 is “not”. The “transfer destination 2” and “transfer destination 3” may store predetermined transfer destinations in advance, or may be left blank (NULL) so that they can be registered later. In this case, the employee changes the “transfer destination 2” and the “transfer destination 3” by setting “transfer account change availability / non-transferability” of the pay pattern table T2 as “OK”, or the employee newly registers or deletes. It can be permitted.

  The hourly wage for each employee is stored in "hourly salary". Although it is preferable that there is at least one hourly unit price, in the present embodiment, a plurality of hourly unit prices can be stored. For example, the hourly unit price 1 stores the monthly amount converted into hourly salary, and the hourly unit price 2, 3, 4, ... at hourly overtime, late at night, after work on holiday, etc. It can be memorized. For each company, it is possible to store an appropriate hourly unit price according to the working hours, the type of business, the type of work, etc.

  The "tax classification" and the "insurance classification" store a flag as to whether or not tax and premium are deducted from the payment amount. Generally, taxes and insurance premiums are deducted and salaries are paid, so if the amount of prepayment is large, it is not possible to deduct taxes and insurance premiums. Therefore, when considering the deduction amount such as tax and premium when deciding the payment amount, it is desirable to set “tax division” and “insurance division” in the employee table T3. In this case, for example, by referring to the tax amount table and the insurance fee table stored in advance in the database 17, the employee's tax and insurance fee can be calculated.

  The e-mail address of the employee is stored in the “e-mail address”. A notification e-mail of the contents (application number, scheduled transfer date, etc.) of the reception when the application for receiving the salary is received is sent to this e-mail address. Also, if the application is not accepted or if a transfer error occurs, an error notification email is sent to this e-mail address. In addition to this, it is also possible to send a notification e-mail or notification e-mail when the application cancellation is accepted.

  FIG. 4D is an example of the accumulated data table T4, and for each company code and employee code, the accumulated data of the working time of each month for each employee is associated with the hourly unit price, corresponding to the company code and the employee code. Is stored in The data to be input to the accumulated data table T4 may be, for example, transmitted from the company side as batch data after the end of daily working hours. Further, the attendance data transmitted in real time from the attendance system to the payroll receiving apparatus 10 may be stored in the accumulated data table T4 in real time in cooperation with the attendance system on the company side.

  FIG. 4E is an example of the request table T5, and for each company code and employee code, it is associated with the company code and employee code, and an application (request) for receiving a salary from each employee, an application cancellation Historical data is stored. In the request table T5, each time a new request from an employee is accepted, a new column is created and request data is stored.

  In the request table T5, "application data" (column) is created and stored for each application corresponding to the "company code" and the "employee code". In the request table T5, "application date", "application amount", "transfer amount", "transfer fee", "application number", "transfer destination", "transfer date", "application status flag", etc. for each application Is stored.

  In the "application date", the date when the request (application) was made is stored. The “request amount” stores the desired amount applied by the employee. The payment amount to be actually transferred is stored in the "transfer amount". The "transfer fee" stores the transfer fee. The “application number” is automatically assigned a number identifying the application and stored. The “transfer destination” stores the transfer destination designated by the applicant. The "transfer date" stores the scheduled transfer date. The “application status flag” is a flag for identifying the transfer status. “1” indicates that the application is under way, that is, the application has been accepted, and “2” indicates that the application has been cancelled. "3" indicates that the transfer table T6 having transfer data described therein has been transmitted to the financial institution during transfer. Also, "4" indicates that a transfer error or transfer error has been determined. "5" indicates that the transfer has been completed. In addition, after the transfer is completed, it may be determined that the transfer amount is deducted from the salary, and the transfer amount transferred by the host may be stored as "5" when the host has billed the employer.

  FIG. 4F is an example of the transfer table T6, and data relating to transfer of salary is stored. The transfer table T6 is created when an application for receiving a salary is received and transfer data is sent to the transfer system 50 of the financial institution. In the transfer table T6, the financial institution data of the transfer source, that is, the host's account data is “transfer source financial institution number”, “transfer source branch number”, “transfer source deposit type”, “transfer source account number”, “transfer source The employee account data stored as the former account holder's name and acquired from the employee table T3 by designation from the employee is "transfer destination financial institution number", "transfer destination branch number", "transfer destination deposit type", "transfer destination deposit type" As well as being stored as a destination account number and a "transferee account name", a "transfer amount" and a "transfer specified date" are stored.

  FIG. 4G is an example of the deduction data table T7, and each employee is paid to the employees by the start date of the attendance cycle and the deduction data closing date in association with the “company code” and the “employee code”. The total amount of money ("payment total amount") is stored.

  Next, an overview of the functions of the respective units of the control unit 100 will be described. The salary pattern update unit 101 has a function of receiving the change data of the salary pattern input from the corporation terminal 20 and updating the salary pattern table T2 of the database 17. In addition, the salary pattern update unit 101 transmits the data for displaying an image on the display unit 27 to the company terminal 20, based on the function as an image generation unit, or based on the login ID and password. It also has a function as an authentication unit that authenticates whether or not to permit access from the server.

  The request processing unit 102 has a function of receiving an application (request) regarding salary receipt from the employee terminal 30, and storing the request (request) in the request table T5. Applications for payroll receipts include payroll receipt applications, cancellation applications, and usage history confirmation applications.

  In addition, the request processing unit 102 transmits the data for displaying the image on the display unit 27 to the employee terminal 30, the employee terminal based on the function as the image generation unit, and the login ID and the password. It also has a function as an authentication unit that authenticates whether or not to allow access from 30.

  The request processing unit 102 also has a function of controlling so as not to receive an application for receipt of salary from the closing date of the towing data to the closing date of the working cycle. As described above, in the present embodiment, in order to facilitate processing of the payroll transfer on the employer side, the total payment amount of each employee is calculated on the closing date of the deduction data before the closing date of the attendance cycle, Report to employers. However, if there is an application for receipt of salary between the deduction data closing date and the attendance cycle closing date, the processing becomes complicated, for example, the deduction processing from the salary for this month is not in time, and it is necessary to deduct the next month. It will Therefore, in the present embodiment, the request processing unit 102 controls so that the prepayment application can not be made from the closing date of the towing data to the closing date of the working cycle.

  In addition, the request processing unit 102 stores the business day calendar of each financial institution, and according to this calendar, a period in which prepayment application can be made (hereinafter referred to as “prepayment application OK period”) and a period in which it can not be made (hereinafter , "Prepayment application NG period". FIG. 10 shows an explanatory diagram for explaining the prepayment application OK period and the NG period. In the example of FIG. 10, the attendance cycle for the employee's employment category is 16 days (from: attendance cycle start) to the following month 15 (to: attendance cycle closing day). Further, since the deadline for requiring deduction data by the employer is the 11th of the following month, 10 days before the due date is set for the deduction data closing date of the pay pattern table T2. More specifically, in the present embodiment, the deadline is 11 o'clock on the 10th, and applications for salary receipt up to 11:00 are accepted, but applications after 11:00 are not accepted. 11:00 is the time when the deduction data table T7 is created by batch processing.

  Here, as shown in FIG. 10, when the tenth day of the deduction data closing day is Sunday, the eighth day of the business day immediately before that is the deduction data closing day. Therefore, from this month, from 16th to 11:00 on the 16th of the attendance cycle start period is the prepayment application OK period, and from 11:00 on the 8th to the 15th day of the attendance cycle closing day, it is the prepayment application NG period. Since the next 10th is a weekday, the next month from 16th to 11th will be the prepayment application OK period, and the 10th from 11:00 to 15th will be the prepayment application NG period.

  The possible application amount calculation unit 103 has a function of calculating the possible application amount for which the employee can apply for payroll (prepayment). The applicable money amount calculation unit 103 calculates the compensation for the work up to now based on the hourly pay unit price of the employee table T3 and the working time of the cumulative data table T4. The application possible amount calculation unit 103 multiplies the calculated compensation for the current labor by the “prepayment upper limit rate” acquired from the salary pattern table T2, and sums the paid amount acquired from the request table T5 from the obtained amount. Subtract the amount and calculate the amount that can be applied.

  The payment amount calculation unit 104 is based on the application possible amount calculated by the application possible amount calculation unit 103, the application amount applied by the employee, the total replacement amount of the company table T1 and the estimated replacement amount (upper limit). Calculate the payment amount (transfer amount). That is, when the application amount is equal to or less than the applicable amount and the sum of the application amount and the total replacement amount is equal to or less than the expected replacement amount (limit amount), the application amount is taken as the payment amount. On the other hand, if the application amount exceeds the application amount, the payment amount is the amount obtained by subtracting the excess amount from the application amount. Further, the payment amount calculation unit 104 subtracts the fee corresponding to the payment amount from the payment amount, and sets it as the final payment amount. Also, if the sum of the application amount and the total replacement amount exceeds the expected replacement amount (limit amount), an alert is displayed (alert).

  The transfer table creation unit 105 has a function of creating a transfer table T6 to be transmitted to the transfer system 50 of a financial institution by specifying a transfer destination account and a transfer amount. In the present embodiment, the Japan Post Bank account can also be designated as the transfer destination account. In the case of a bank, since the branch number is 3 digits and the account number is 7 digits (full silver format), when a bank account is designated, “transfer destination 1”, “transfer destination” of employee table T3 as it is 2 "," transfer destination 3 "are stored.

  On the other hand, Japan Post Bank has a 5-point fulcrum number and an 8-digit account number (symbol number format). Therefore, when performing transfer procedure in Zengin type, it is necessary to convert the Japan Post Bank branch number and account number into a Zengin type numbering system. Depending on the company, Japan Post Bank's branch number and account number are kept as symbol number format, and converted into all silver type numbering system, and even if it is in symbol number format, There are cases where some numbers are truncated and held in correspondence with the 3-digit Bank Number and the 8-digit Account Number.

  In the payroll system 1 of the present embodiment, data can be stored in the transfer account of the employee table T3 as it is in a format owned by a company. Then, according to the format of the transfer account data stored in the transfer table creating unit 105, the transfer table T6 is created by converting as appropriate. Therefore, it is not necessary for the employer side to perform conversion work etc., and the convenience of the employer side can be improved.

  Specifically, in the case of the symbol number format of the Japan Post Bank account number and the case where some numbers are cut off, the transfer table creating unit 105 converts it into the all-silver format, and creates the transfer table T6. On the other hand, in the case of the all silver format, the transfer table T6 is created without conversion.

  The deduction data table creation unit 106 calculates the total amount of payroll receipt (deduction amount) for each employee of each employer according to the deduction data closing date of the salary pattern table T2, and the deduction data table for each employer It has a function to create T7. The deduction data table T7 is provided from the host to each employer on the deduction data closing day.

  Note that the deduction data table T7 may be provided as a batch file, or may be attached to an e-mail when the capacity is small. Further, by accessing the payroll receiving apparatus 10 from the corporation terminal 20, the employer may be able to browse, print, download and the like of the deduction data table T7. Also, it may be provided in cooperation with a company's attendance system.

  The notification unit 107 has a function of transmitting an e-mail to the employee terminal 30 in response to an instruction from the request processing unit 102 or the like. The contents of the e-mail include notification of receipt of application for receipt of pay, notification of transfer error, and the like. The notification unit 107 acquires the email address of the employee from the employee table T3 corresponding to the company code and the employee code, and creates and sends an email corresponding to the content of the notification.

  Hereinafter, an example of the flow of payroll processing (payroll method, payroll service) executed by the payroll system 1 according to the present embodiment configured as described above will be described with reference to the drawings. The payroll processing includes processing such as payroll pattern data update processing, payroll receipt application processing, usage history confirmation processing, payroll receipt application cancellation processing, transfer processing, and deduction data table creation processing.

  First, the payroll pattern data update process when the payroll pattern data is updated on the company side will be described with reference to the sequence diagram of FIG. 5A and the screen example of FIG. First, in step S100, the employer launches a browser or application of the company terminal 20 to access the payroll receiving apparatus 10. For example, the payroll receiving apparatus 10 is accessed by designating the URL assigned to the payroll receiving apparatus 10 directly or with an application at the company terminal 20.

  The access from the corporation terminal 20 is notified to the salary pattern update unit 101. The pay pattern update unit 101 that has received this notification transmits data necessary for displaying the login screen to the company terminal 20, and causes the display unit 27 to display the login screen 60 as shown in FIG. (Step S101). The employer can input a login ID and a password on the login screen 60 (step S102). The login ID may be an arbitrary one determined in advance, an e-mail address, a company code or the like.

  The login ID and password input from the login screen 60 are transmitted to the salary pattern update unit 101. The salary pattern update unit 101 determines whether or not the combination of the input login ID and password is present in the company table T1 (step S103). If it is determined that there is not (No in step S103), an error is notified to the corporation terminal 20. When this error notification is received, the corporation terminal 20 can return to step S102 and make the employer re-perform the login process.

  If it is determined in step S103 that there is a login, it is determined that the login is successful, and the process proceeds to the next step S104. In step S104, the pay pattern change unit 101 reads the pay pattern data of the employer from the pay pattern table T2 using the company code as a key. Then, data for displaying the payroll pattern change initial screen 61 is transmitted to the corporation terminal 20, and the payroll pattern change initial screen 61 as shown in FIG. 6B is displayed on the display unit 27.

  On the payroll pattern change initial screen 61, a list of “employment classification code”, “employment classification name”, and “salary classification” is displayed. The employer presses the “details” of the employment category to be changed with a mouse or the like to select the selected employment category, and the selected employment category is transmitted to the pay pattern changing unit 101 (step S105). For example, in the example of FIG. 6 (b), "full-time employee" is selected.

  The salary pattern reception unit 101 acquires detailed data from the salary pattern table T2 using the selected employment classification as a key. By transmitting the acquired data, a salary pattern detail screen 62 as shown in FIG. 6C is displayed on the display unit 27 (step S106). On this payroll pattern detail screen 62, payroll pattern data such as "employment classification code", "employment classification name", and "number of monthly payments" are displayed. The employer inputs (updates) data of an item to be changed on the pay pattern detail screen 62 (step S107).

  The changed salary pattern data is transmitted from the corporation terminal 20 to the salary pattern update changing unit 101. The salary pattern update unit 101 updates the salary pattern table T2 with the received salary pattern data (step S108).

  The pay pattern change initial screen 61 may be provided with an add button and a delete button for the employment classification so that the employer can add or delete the employment classification. Specifically, pressing the add button on the payroll pattern change initial screen 61 moves to the payroll pattern detail screen 62, and the employer inputs a new employment classification code and the corresponding payroll pattern data. It can be so. Receiving this input, the pay pattern update unit 101 adds pay pattern data of the added employment classification to the pay pattern table T2. Further, one of the employment categories is selected on the payroll pattern change initial screen 61, and deletion designation can be made by pressing the delete button. Receiving this designation, the salary pattern update unit 101 deletes the salary pattern data of the employment category from the salary pattern table T2.

  Next, an example of the application process of the salary receipt when the employee requests the salary receipt will be described with reference to the sequence diagram of FIG. 5B and the screen example of FIG. 7. First, in step S200, the employee launches a browser or an application of the employee terminal 30, and accesses the payroll receiving apparatus 10. For example, the payroll receiving apparatus 10 is accessed by designating the URL assigned to the payroll receiving apparatus 10 directly or with an application on the employee terminal 30.

  The access from the employee terminal 30 is notified to the request processing unit 102. The request processing unit 102 having received this notification transmits data necessary for displaying the login screen on the employee terminal 30, and displays the login screen 70 as shown in FIG. 7A on the display unit 27. (S201). In the login screen 60, the employee can input a login ID and a password (step S202). The login ID may be any predetermined one, an e-mail address, or a combination of a company code and an employee code.

  In addition, once login is successful, the processing of steps S201 and S202 is skipped at the next access from the same employee terminal 30, and the process proceeds to step S203 without performing login authentication, and payroll processing is executed. May be

  In addition, it may be possible to select a password change process from the menu bar m1 displayed on the screen. When receiving the selection instruction, the request processing unit 102 causes the display unit 27 to display the password change screen 71 shown in FIG. 7B. The employee can input a new password from this password change screen 71. The request processing unit 102 checks the validity of the new password input from the password change screen 71, and when it is determined to be valid, it is stored in the employee table T3, but when it is determined to be invalid. Is not memorized. The notification unit 107 notifies the e-mail address stored in the employee table T3 of the notification e-mail of the change or invalidity of the password.

  The login ID and password input from the login screen 70 are transmitted to the request processing unit 102. The request processing unit 102 determines whether or not the combination of the input login ID and password is present in the employee table T3 (step S203), and when it is determined that it does not exist (NO in the determination in step S203). , And notify the employee terminal 30 of an error. When this error notification is received, the employee terminal 30 can return to step S202 and can have the employee re-execute the login process.

  If it is determined in step S203 that the log-in is successful, the process proceeds to the next step S204, and it is determined whether the application date is within the application OK period. In the case of the prepayment application NG period (the determination in step S204 is NO), the application for the salary receipt can not be made, so the processing is ended. At this time, a message may be displayed on the employee terminal 30 to the effect that it is a period in which the application for salary receipt can not be made.

  In the case of the prepayment application OK period (the determination in step S204 is YES), the process proceeds to step S205. In step S205, the request processing unit 102 causes the display unit 27 to display an application top screen 72 on which a notice or the like is displayed as shown in FIG. 8A.

  On the application top screen 72, the employee can not only perform the application procedure, but also can confirm, register, and update the transfer destination account. In this case, the employee selects “confirmation, registration, update of the transfer destination account” in the menu bar m1 of the application top screen 72 (step S206). In response to this selection, the request processing unit 102 acquires data of the three transferee accounts from the employee table T3, and causes the display unit 27 to display the transferee account list screen 73 as shown in FIG. 8B. It is displayed (step S207). At this time, the contents of transfer account change propriety of each account of the payroll pattern table T2 are confirmed, and if it is, icons of deletion, change and registration are displayed in the column of the account.

  By visually recognizing the transfer destination account list screen 73, the employee can confirm the transfer destination account. Further, in the example of FIG. 8 (b), the company designated account is displayed on the “transfer destination 1” and can not be changed. In addition, employees can freely input transfer destinations 2 and 3. For transfer destination 2, the contents of the account already registered are displayed, and deletion and change can be performed by pressing the delete button or the change button. It has become. Further, the payee 3 is unregistered, and can be registered by pressing the registration button.

  When deletion is selected on the transfer destination account list screen 73, the request processing unit 102 deletes the data of the transfer destination from the employee table T3. When update or registration is selected on the transfer destination account list screen 73, the request processing unit 102 displays an appropriate update / registration screen. Employees can update and register accounts from this screen. When the update and registration of the account are executed, the request processing unit 102 updates the account of the employee table T3 (step S208).

  On the other hand, when the employee applies for salary receipt, by pressing "Apply" on the application top screen 72, the request processing unit 102 is notified of an application execution instruction (step S209), and this is accepted. According to the instruction of the request processing unit 102, the application possible amount calculation unit 103 calculates the application possible amount that can be received by the employee (step S210). Specifically, the application possible amount calculation unit 103 acquires data of the employee from the employee table T3 and the accumulated data table T4 based on the company code and the employee code. Then, the hourly unit price is multiplied by the accumulated data obtained by accumulating the working hours up to the present to calculate the salary amount so far. When a plurality of hourly wages are set, the salary amount up to the present is calculated by adding up the multiplication results.

  Next, the available money amount calculation unit 103 acquires the “prepayment upper limit rate” from the salary pattern table T2 using the employment classification acquired from the employee table T3 as a key. This "prepayment upper limit rate" is multiplied by the current salary amount calculated above to calculate "applicable amount". At this time, the amount after multiplication may be rounded down or rounded off by a predetermined number of digits (in units of hundred yen or units of thousand yen). In this way, by multiplying the "payroll amount" by the "prepayment upper limit rate", the entire "payout amount" will not become the "applicable amount" and the employee will be paid the deduction amount of tax and insurance premiums. Can be suppressed.

  Further, when there is an application for prepayment in the current month, the available money amount calculation unit 103 subtracts the paid amount (the paid amount) from the possible money amount. Specifically, referring to the request table T5, those having application status flags “1” (under application), “3” (under transfer) or “5” (transfer completed) are extracted, The transfer amount is totaled to calculate the paid amount, which is subtracted from the application possible amount to obtain the final application possible amount. Below, an example of a calculation formula is given.

Available amount for application (Yen) = Cumulative working time data (h) × Hourly salary unit price (Yen) × Prepaid upper limit rate-Amount payable (Yen)

  In addition, the calculation procedure of the said applicable money amount is an example, and is not limited to this. As another example of the calculation procedure, the total amount for which a prepayment application has been made in advance is subtracted from the "salary amount", and the calculated amount is multiplied by a predetermined "prepayment upper limit rate". It can also be done.

  Then, the request processing unit 102 transmits the calculated applicable amount to the employee terminal 30, and causes the display unit 27 to display an application amount input screen 74 as shown in FIG. 8C (step S211). In the application amount input screen 74, an application possible amount, an amount specification icon, an application amount input field and the like are displayed. The employee inputs a desired application amount in the application amount input field (step S211). At this time, the amount can be input in units of 1,000 yen or 5,000 yen by pressing the amount specifying icon, or the amount can be directly input from a ten key or the like. Also, the full amount can be input in one touch by pressing the full amount button. The request application unit 102 is notified of the desired application amount by inputting the desired application amount and pressing the “Next” button by the employee.

  Receiving this application amount, the payment amount calculation unit 104 calculates the payment amount (transfer amount) (step S213). First, the payment amount calculation unit 104 sets the application amount as the payment amount when the application amount is equal to or less than the application possible amount, and sets the application possible amount as the payment amount when the application amount exceeds the application possible amount. In this way, even if the application amount exceeds the application amount, the application can be accepted, and the employee can receive salaries at least for the application amount.

  Next, the payment amount is added to the total replacement amount acquired from the company table T1. If the added amount exceeds the estimated replacement amount (limit amount), an alert (alert) is displayed on the monitor of the payroll receiving apparatus 10 that the amount has been exceeded together with the company name and the like. As a result, it is possible to know on the host side that the predetermined company-wide salary payment amount has reached the expected replacement amount (the limit amount). In addition, the host can notify the company that the limit has been reached and draw attention.

  As a different example of calculation of the payment amount, when the amount obtained by adding the payment amount to the total replacement amount acquired from the company table T1 exceeds the assumed replacement amount (the limit amount), the amount obtained by subtracting this excess amount As the final payment amount. This makes it possible to suppress an excessive increase in the amount of salary paid for the entire enterprise.

  Then, a commission (acquired from the salary pattern table T2) corresponding to the payment amount is subtracted from the final payment amount to calculate a commission deduction transfer amount. The request processing unit 102 transmits the transfer amount after transfer of fees and causes the display unit 27 to display a transfer amount confirmation screen 75 as shown in FIG. 8D (step S214).

  When the employee presses "Next" on the transfer amount confirmation screen 75 to confirm the transfer amount (step S215), the request processing unit 102 transfers the transfer destination account as shown in FIG. 8 (e). The designation screen 76 is displayed on the display unit 27 (step S216). The employee selects the transfer destination account from the pull-down list on the transfer destination account specification screen 76, and presses “Next” to fix the transfer destination account (step S217). In addition, it is also possible to return to the application amount input screen 74 and re-input the application amount by pressing “Return” on the transfer destination account specification screen 76.

  In response to the confirmation of the transfer destination account, the request processing unit 102 causes the display unit 27 to display an application content confirmation screen 77 as shown in FIG. 8F (step S218). If the application is to be confirmed, the employee presses "confirm" (step S219). In addition, when “Return” is pressed on the application content confirmation screen 77, it is possible to return to the transfer destination account specification screen 76.

  When "confirm" is pressed, the request processing unit 102 displays the acceptance completion screen 78 on which the transfer date (scheduled date) and the application number are displayed on the display unit 27, as shown in FIG. 8 (g). (Step S220). The transfer date is determined with reference to the business day calendar of each business period according to the application date, the application time, and the timing of sending the transfer data to the transfer system 50 of the financial institution. For example, the final time when the financial institution 50 can apply for the transfer on the day is determined in advance, and when the application for receiving the salary is made by the final time, the application date is taken as the transfer date. If the final time is exceeded, and if the application date is a holiday of a financial institution, the next day of the application date will be the transfer date. Furthermore, if these transfer dates are holidays of a financial institution, the next business day will be the transfer date. As described above, in the payroll system 1 of the present embodiment, the application for receiving the payroll from the employee is made on a holiday of a financial institution such as weekends and holidays, as long as it is not a prepayment application NG period, and reserves transfer. be able to.

  Next, the request processing unit 102 creates a new column (record) in the request table T5 based on the determined application (step S221). In this case, although the date of the application time is stored in the "application date" of the new column of the request table T5, not only the date but also the time is stored for the convenience of batch processing for creating the deduction data table T7. Is desirable. The “amount of application” stores the amount of application input by the employee, and the “amount of transfer” stores the final payment amount determined by subtracting the fee etc. The “transfer destination” stores the name (“transfer destination account 1 or the like”) or an identifier of the transfer account designated by the employee, and the “transfer date” stores the scheduled date of the transfer date determined in advance. Ru. In the “application status flag”, “1” (under application) is stored. The request processing unit 102 associates these data with the company code and the employee code and stores them in the request table T5.

  Next, the request processing unit 102 instructs the notification unit 107 to transmit an e-mail for notifying the employee that the application has been approved. The notification unit 107 that has received this instruction creates a reception completion e-mail that describes the application date, application number, transfer amount, transfer date, contents of approval, etc., and uses the e-mail address acquired from the employee table T3. It transmits (step S222). By confirming the e-mail, the employee can know that his / her application for receiving the salary has been approved.

  In the present embodiment, the application is automatically approved by the payroll receiving apparatus 10. However, as another different embodiment, the employer may perform the approval process. In this case, an approval flag indicating whether the employer approves or not is stored in the company table T1. When the approval flag is turned on, when the request table T5 is created, the request table T5 also stores that the approval process is to be performed. That is, the approval flag of the request table T5 is turned on. Then, the company terminal 20 can access the request table T5 of the company so that it can be input whether or not to approve. For example, the employer stores “1” in the approval flag when approving the application, and stores “2” when not approving the application. The payroll receiving apparatus 10 may send an e-mail describing the approval result to the employee.

  Next, an example of the confirmation process of the usage history of the payroll service and the cancellation process of the payroll application will be described with reference to the sequence diagram of FIG. 5C and the screen example of FIG.

  In a state where the employee accesses the payroll receiving apparatus 10, the usage history confirmation is selected by the menu bar m1 on the application top screen 72 shown in FIG. 9A (step S250). In response to this selection, the request processing unit 102 acquires request data for the current month of the employee from the request table T5, adds all transfer amounts, and calculates the use amount for this month (step S251). Then, the usage amount of this month and the data of the request table T5 are transmitted to the employee terminal 30, and the usage history confirmation screen 79 as shown in FIG. 9B is displayed on the display unit 27 (step S252). On the usage history confirmation screen 79, the usage amount of this month and the history data of the past application (for example, for the past one year, the past two years, etc.) are displayed. In addition, since the status according to the application status flag is also displayed, the employee can confirm whether the transfer has been completed, a transfer error or the like has occurred.

  From this history data, for example, it is possible to cancel an application for a predetermined salary receipt whose transfer has not been completed, such as the application status “in transfer”. When the employee presses “cancel application” in the usage history confirmation screen 79 in order to cancel this, an instruction to cancel the application is sent to the request processing unit 102 (step S253).

  In response to the cancellation instruction of the application, the request processing unit 102 causes the display unit 27 to display an application cancellation confirmation screen 80 as shown in FIG. 9C (step S254). The employee confirms the contents of the application cancellation confirmation screen 80, and presses “application cancellation” to confirm cancellation if the cancellation is to be confirmed (step S255). In response to this instruction, the request processing unit 102 displays a cancellation acceptance completion screen 81 as shown in FIG. 9D (step S256). The employee can confirm that the application has been canceled by visually recognizing the cancellation reception completion screen 81. Application cancellation can also be confirmed by displaying the usage history confirmation screen 79. Alternatively, the notification unit 107 may be instructed to send an acceptance cancellation email of the application cancellation.

  Further, the request processing unit 102 deletes the deposit data of the application from the deposit table T6 (step S257), and writes “2” (canceled) in the “application status flag” of the request table T5 (step S258). This confirms the cancellation of the application.

  Next, an example of a transfer process when making a transfer to the employee's account in accordance with the approved application for salary receipt will be described with reference to the sequence diagram of FIG. 5D. The operation of the transfer system 50 of a financial institution differs depending on each financial institution, and an operation according to each specification is performed.

  First, the transfer table creation unit 105 creates the transfer table T6 shown in FIG. 4F with reference to the request table T5 (step S300). At this time, in the case of automatic authentication, the transfer table T6 is created for all the applications for which payment has not been completed, but when the employer approves, the approval flag is “1”, that is, approved. The transfer table T6 is created for the application.

  In the present embodiment, the “transfer source financial institution number”, “transfer source branch number”, “transfer source deposit type”, “transfer source account number”, and “transfer source account name” of the transfer table T6 are the host account in this embodiment. Store data about The company code and employee code of the request table T5, and the transfer destination for “transfer destination financial institution number”, “transfer destination branch number”, “transfer destination deposit type”, “transfer destination account number”, and “transfer destination account name” Based on the foregoing, the transferee data of the employee acquired from the employee table T3 is stored. Further, the “transfer amount” and the “transfer specified date” store the transfer amount and the transfer specified date of the request table T5, respectively.

  The created transfer table T6 is transmitted to the transfer system 50 of the financial institution of the transfer destination at a predetermined timing. When this transmission is completed, the transfer table creation unit 105 writes “3” (during transfer) in the application status flag of the request table T5 (step S302). The transfer system 50 that has received the transfer table T6 transfers the specified transfer amount according to the specified transfer date and account by the well-known transfer process (step S303).

  The transfer table creation unit 105 also has a function of monitoring whether the transfer is successful. That is, after transmission of the transfer table T6, the transfer table creation unit 105 accesses the transfer system 50 of the financial institution every predetermined time to check the transfer status (step S304).

  The deposit system 50 transmits the deposit status to the request processing unit 102 (step S305). When the transfer status is received, the request processing unit 102 determines whether there is a record having an error (step S306). Regarding the application corresponding to the record determined to have an error, “4” (transfer error) is written in the application status flag of the request table T5 (step S307).

  Next, the request processing unit 102 instructs the notification unit 107 to transmit an e-mail for notifying an employee that a transfer error has occurred. Having received this instruction, the notification unit 107 creates an e-mail stating that a transfer error has occurred, and sends it to the e-mail address of the employee code (step S308). By confirming the e-mail, the employee can know that the transfer of the salary has failed. When wanting to know more detailed information, the employee may check the usage history confirmation screen 79. In addition, the application date of the application that resulted in an error, the application number, the transfer amount, etc. may be described in the e-mail, and the details can be known without the employee checking the usage history confirmation screen 79. . On the other hand, for the application corresponding to the record having no error, “5” (transfer completed) is written in the application status flag (step S309).

  By the above processing, the employee can receive a prepaid salary. Also, the employer does not have to pay salaries to employees before the payroll day, as the host transfers and transfers salaries to the employee's account. Therefore, it is not necessary to secure the amount of money collected in the employer's account, and it is possible to avoid transfer errors due to lack of balance and the like.

  Next, an example of the flow of creation processing of the pull-down data table T7 will be described with reference to the sequence diagram of FIG. 5E and the explanatory diagram of FIG. In the payroll receiving apparatus 10, the deduction data table creation unit 106 acquires “working period” (time cycle) and “deduction data closing date” from the pay pattern table T2, and based on the business day calendar of each financial institution, Decide data date of the present month is determined (step S400). That is, if the deduction date is the financial institution's holiday, the previous financial institution business day is taken as the deduction date.

  At 11:00 am of the pull-off data closing date, the pull-out data table creation unit 106 starts the creation of the pull-down data table T7 by batch processing. First, request data is acquired from the request table T5 for each company code and employee (step S401). Then, the request data with the application status flag “5” (transfer completed) is detected, the transfer amount and transfer fee are added up for each employee, the total payment amount is calculated, and the deduction data table T7 is created (step S402). At this time, add the transfer amount and transfer fee of the request data for transfer other than the error and cancellation, that is, the transfer status of the application status flag “1” (under application) and “3” (under transfer) to the payment total amount It is also good. The deduction data table T7 is provided to each employer.

  When calculating the salary of each employee, the employer subtracts the total amount of the payment from the salary of each employee based on the deduction data table T7 together with the tax, the premium and the like (step S403). The amount after subtraction is transferred to a predetermined transfer account on a payroll date to pay a payroll (step S404). This allows the employee to receive the remaining salary. In addition, the employer transfers the amount deducted from the salary of each employee, that is, the reimbursed amount transferred by the host and the usage fee of the payroll system 1 to the host's account to pay the host (S405). . Since the employer can pay the host the amount deducted from the salary, the employer does not incur any debt. Payment to the host is not limited to transfer, but may be automatic withdrawal.

  As described above, according to the payroll system 1 of the present embodiment, the host replaces and pays at least a part of the employee's salary on behalf of the employer. There is no need to pay and no debt for the employer. Therefore, it is not necessary to secure the amount of money collected in the employer's account, and the burden on the employer can be reduced.

  In addition, we calculate the amount that the employee can apply based on the accumulated data of the employee's daily working hours and the salary unit price set in advance, and the monthly estimated replacement amount (limit amount) set for each employer The payment amount is calculated based on the calculated application possible amount and the application amount. Therefore, it is possible to save the trouble of the employer calculating the daily salary data. Further, even if the application amount is larger than the application possible amount, the employee can receive the salary within the range not exceeding the application possible amount and can suppress an excessive receipt. In addition, a limit is set for each employer, and alert display (warning) when this limit is exceeded can prevent excessive receipt of salary for the entire employer. .

  In addition, the method of receiving salary according to the payroll system 1 of the present embodiment is based on the process of receiving an application for receiving salary including the application amount from the employee, the accumulated data of working hours of the employee, the salary unit price, and the already paid amount. Calculating the amount of application for the salary receipt of the employee, calculating the amount of payment based on the limit set for each employer, the amount of application and the amount of application, and the amount of payment for the employee Creating transfer data for transferring to an account.

  Further, the program executed by the payroll system 1 of the present embodiment is a computer, means for receiving an application for payroll including an application amount from the employee, accumulated data of working hours of the employee, pay unit price and already paid Means for calculating the applicable amount of the employee's salary receipt based on the amount, means for calculating the payment amount based on the limit amount settable for each employer, the applicable amount and the application amount, and the payment amount Is a program for functioning as a means of creating transfer data for transferring an account to an employee's account.

  Therefore, the employee can easily receive the prescribed payment amount based on his / her salary when necessary, while reducing the financial and working burden on the employer side, and a more convenient salary receipt system 1 , Payroll methods, and programs can be provided.

  In addition, the application possible amount calculation unit 103 sets the salary unit price according to the employment category to the cumulative data of working hours from the start date of the attendance cycle set according to the employment category of the employee to the application receipt date of the salary reception. The available money amount is calculated by multiplying the obtained amount by the prepaid upper limit rate set according to the employment category, and subtracting the already paid amount from the obtained amount. With this configuration, it is possible to suppress the receipt of excessive salary of the employee and secure an amount that can deduct, for example, a deduction amount such as a tax or a premium.

  Further, in the present embodiment, the payment amount calculation unit 104 sets the application amount as the payment amount if the application amount is less than or equal to the application possible amount, and if the application amount exceeds the application possible amount, the application possible amount It is considered as the payment amount. According to this configuration, the employee can receive salary at least for the amount that can be applied. Furthermore, when the additional amount of the payment amount and the total amount already used by all the employees to which the employee belongs exceeds the expected replacement amount (the limit amount), an alert is displayed (warning). Therefore, it can be known that the amount of salary receipt for the entire employer has reached the expected repayment amount (the limit amount).

  Further, the estimated replacement amount (limit amount) is an amount obtained by multiplying the number of employees of the employer by a predetermined usage rate and a predetermined unit price. Therefore, it is possible to freely set the utilization rate and the unit price for each employer according to the type of industry, the size and management of the company, and the past experience of the host, etc. Convenience can be improved.

  Further, among the plurality of account data, the transfer data table creation unit 105 sets account data designated by the employee in the transfer table T6. Therefore, the employee can designate transfer to a desired account according to the purpose of use of the received salary as well as the payroll account. As a result, it is possible to prevent, for example, the trouble of transferring a payroll account to another account, the occurrence of a transfer fee, and the like.

  Further, the request processing unit 102 displays application data including the application amount, the application date, and the transfer date on the display unit 27 of the employee terminal 30 in response to the display application of the usage history from the employee and presents the data to the employee. In addition, it is configured to receive an application for cancellation of salary receipt from the employee. And the transfer table preparation part 105 is comprised so that the transfer table T6 may be created with respect to the application of the salary receipt which application cancellation is not made. Therefore, the employee can freely view the history of salary receipt, decide whether or not to apply for prepayment, or use it as a reference for a future household plan. In addition, by canceling the application, it is possible to prevent overpayment of salary and the like.

  Further, the deduction data table creation unit 106 calculates the total amount of the application amount transferred from the start of the employee's attendance cycle to the deduction data closing date which is a predetermined number of days before the attendance cycle closing date. This total amount is promptly provided to the employer. Therefore, the employer can know the total amount of salary receipt of each employee for deduction from salary before salary calculation, and can perform processing related to salary calculation smoothly and quickly.

  In addition, the request processing unit 102 does not accept an application for receiving an employee's salary from the closing date of the deduction data to the closing date of the time cycle. As a result, after deducting the total amount of the application amount from the salary and completing the payroll calculation, there is no need to deduct the deductible amount, and it takes time and effort to recalculate the transfer salary and carry over to the next month. To reduce the burden on employers.

  Although the embodiments of the present invention have been described in detail with reference to the drawings, the above-described embodiments are merely examples of the present invention, and the present invention is not limited to only the configurations of the above-described embodiments. . Needless to say, even if there are design changes and the like within the scope of the present invention, they are included in the present invention.

  For example, in the above-described embodiment, the host recovers the salary and pays the employee. That is, the pay is transferred from the host's account to the employee's account. However, the present invention is not limited to reversion by a host, and a system for transferring from an employer's account to an employee's account can also be used. In this case, the deduction account of the employer is stored in the company table T1, and when the transfer table T6 is created, data on the account of the employer is stored in the “transfer source”. In this way, the host can save the trouble of requesting the employer to pay the reimbursement amount or debiting the reimbursement amount from the employer's account.

  Also, as another embodiment, an application processing unit for receiving an application for receiving a salary including an application amount from an employee, accumulated data of working hours of the employee, and a salary unit price set according to the employment category of the employee And an applicable amount calculating unit for calculating an applicable amount of an employee's salary receipt based on the already paid amount, a paid amount calculating unit for calculating an amount of payment based on the applicable amount and the application amount, and a payment It is also possible to have a payroll prepayment system provided with a transfer data creation unit that creates transfer data including the amount of money and employee account data.

  In such a payroll system, the employee can easily receive the prescribed payment amount based on the salary when necessary, and the financial and operational burden on the employer side can be reduced, which makes the system more usable. Can provide a good payroll system. Furthermore, since the salary unit price and the like can be set according to the employment category, it is possible to provide a salary receipt system according to the requirements of the employer having various employment forms. In the case of this payroll system, the amount of money received by the employee in advance can be changed by the host to be paid later and charged to the employer later, or it can be made to be debited directly from the account of the employer. , Transfer source does not matter.

  Further, as a payroll system according to another embodiment, an application processing unit for receiving a payroll application including an application amount from the employee, accumulated data of working hours of the employee, and a salary unit price set according to the employment category of the employee And based on the amount already paid, it is possible to calculate the possible application amount of the employee's salary receipt based on the applicable amount calculation part, and the limit amount set for each employer, based on the applicable amount and the required amount, the payment amount It has a payment amount calculation unit to calculate and a transfer data creation unit to create transfer data including payment amount and employee's account data, and replace at least a part of the employee's salary on behalf of the employer and pay It may be one.

  In such a payroll system, the employee can easily receive the prescribed payment amount based on the salary when necessary, and the financial and operational burden on the employer side can be reduced, which makes the system more usable. Can provide a good payroll system. Furthermore, since it is possible to set the salary unit price etc. according to the employment classification, it is possible to meet the requirements of employers with various employment forms, and it is not necessary to secure the amount of money collected in the employer's account. Can reduce the burden on

DESCRIPTION OF SYMBOLS 1 payroll receipt system 10 payroll receipt apparatus 100 control part 102 request processing part (application processing part) 103 application possible amount calculation part 104 payment amount calculation part 105 transfer table preparation part (transfer data preparation part)
106 Deduction data table creation unit (deduction data creation unit)

Claims (12)

An application processing unit that receives an application for salary receipt including an application amount from an employee;
An applicable amount calculation unit for calculating an applicable amount of the salary receipt of the employee based on accumulated data of working hours of the employee, a salary unit price, and an already paid amount;
A payment amount calculation unit that calculates a payment amount based on a ceiling amount set for each employer, the application possible amount, and the application amount;
A transfer data creation unit that creates transfer data including the payment amount and the employee's account data;
The payroll system according to claim 1, wherein at least a part of the employee's salary is replaced and paid on behalf of the employer. An application processing unit that receives an application for salary receipt including an application amount from an employee;
Applicable amount calculation unit that calculates the applicable amount of the salary receipt of the employee based on the accumulated data of working hours of the employee, the salary unit price set according to the employment category of the employee, and the amount already paid When,
A payment amount calculation unit that calculates a payment amount based on the applicable amount and the application amount;
And a transfer data creation unit that creates transfer data including the payment amount and the employee's account data. An application processing unit that receives an application for salary receipt including an application amount from an employee;
Applicable amount calculation unit that calculates the applicable amount of the salary receipt of the employee based on the accumulated data of working hours of the employee, the salary unit price set according to the employment category of the employee, and the amount already paid When,
A payment amount calculation unit that calculates a payment amount based on a ceiling amount set for each employer, the application possible amount, and the application amount;
A transfer data creation unit that creates transfer data including the payment amount and the account data of the employee;
Equipped with
The payroll system according to claim 1, wherein at least a part of the employee's salary is replaced and paid on behalf of the employer.   The possible application amount calculation unit is a salary set according to the employment category in the cumulative data of working hours from the start date of the attendance cycle set according to the employment category of the employee to the application date of the salary reception The unit price is multiplied, the obtained amount is multiplied by the prepaid upper limit rate set in accordance with the employment category, and the available amount is calculated by subtracting the already paid amount from the obtained amount. The payroll system according to any one of claims 1 to 3.   The payment amount calculation unit sets the application amount as a payment amount when the application amount is less than or equal to the application possible amount, and when the application amount exceeds the application possible amount, the payment amount as the application possible amount. In addition, when the additional amount between the payment amount and the total amount already used by the entire employer to which the employee belongs exceeds a limit amount, a warning is given. The payroll system according to any one of ~ 4.   The salary according to any one of claims 1 to 5, wherein the limit amount is an amount obtained by multiplying the number of employees of the employer by a predetermined utilization rate and a predetermined unit price. Receiving system.   The said transfer data creation part sets the said account data designated by the said employee to the said transfer data out of a plurality of account data, The method according to any one of claims 1 to 6, Payroll system. The application processing unit presents application data including the application amount, application date, and transfer date to the employee in response to a display application of the usage history from the employee, and the employee receives the salary from the employee. Configured to accept cancellation applications,
The said transfer data preparation part was comprised so that the said transfer data might be created with respect to the application of the salary receipt which application has not been cancelled, The statement in any one of the Claims 1-7 characterized by the above-mentioned. Payroll system.   A claim including: a deduction data creation unit for calculating a total amount of the application amount transferred from the start of the employee's attendance cycle to a deduction data closing day which is a predetermined number of days before the attendance cycle closing day The salary receipt system according to any one of Items 1 to 8.   10. The salary reception according to claim 9, wherein the application processing unit is configured not to accept the application for the salary reception of the employee between the closing date of the deduction data and the closing date of the work cycle. system. An application processing process for receiving an application for salary receipt including an application amount from an employee;
An applicable amount calculation step of calculating an applicable amount of the salary receipt of the employee based on accumulated data of working hours of the employee, a salary unit price and an already paid amount;
A payment amount calculating step of calculating a payment amount based on the limit amount set for each employer, the application possible amount and the application amount;
A transfer data creation step of creating transfer data including the payment amount and the employee's account data;
A payee receiving method characterized in that at least a part of the employee's salary is replaced and paid on behalf of the employer. Computer,
Application processing means to receive application for salary receipt including application amount from employee,
Application possible amount calculation means for calculating the application possible amount of the salary reception of the employee based on the accumulated data of working hours of the employee, the salary unit price and the already paid amount,
Payment amount calculation means for calculating the payment amount based on the limit amount set for each employer, the application possible amount and the application amount,
A program for functioning as transfer data creation means for creating transfer data including the payment amount and the account data of the employee.