WO2019064920A1

WO2019064920A1 - Salary receiving system, salary receiving method and program

Info

Publication number: WO2019064920A1
Application number: PCT/JP2018/029063
Authority: WO
Inventors: 有悟佐藤; 俊博榎本; かおり嶋田
Original assignee: 株式会社クレディセゾン
Priority date: 2017-09-27
Filing date: 2018-08-02
Publication date: 2019-04-04
Also published as: JP2019061526A; PH12019502223A1; JP6349450B1

Abstract

Provided is a salary receiving device (10) or the like through which a worker can conveniently receive a prescribed payment amount based on a salary, when necessary, and which is more convenient to use by reducing the cost and work burdens on the employer side. The salary receiving system (1) is configured by being provided with a salary receiving device (10), a company terminal (20) and an employee terminal (30). The salary receiving device (10) is configured by being provided with: a request processing unit (102) which receives, from a worker, a request for receiving a salary including a requested amount; a requestable amount calculation unit (103) which calculates a requestable amount of a salary to be received by the worker on the basis of the salary rate of the worker and cumulative data on the working hours of the worker; a payment amount calculation unit (104) which calculates a payment amount on the basis of a monthly assumed advance amount set for each employer, the requestable amount, and a requested amount; and a transfer data table creation unit (105) which creates transfer data for transferring the payment amount to an account of the worker.

Description

Payroll system, payroll method and program

The present disclosure relates to payroll systems, payroll methods, and programs.

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 disclosure has been made in view of the above-described circumstances, and a worker can easily receive a prescribed payment amount based on salary as needed, and the financial and working side of the employer can 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, a payroll system according to the present disclosure comprises an information terminal owned by an employee, and a payroll receiving apparatus connected to the information terminal via a network and installed at a payroll service provider. An application processing unit for receiving an application for receiving a salary including the application amount from the information terminal, and the accumulated data of working hours of the employee, the salary unit price and the already paid amount. Obtained by multiplying the application amount calculation unit for calculating the application possible amount of salary receipt of employees and the number of employees of the employer multiplied by the utilization rate and the unit price of the salary receipt service set for each employer. A payment amount calculation unit for calculating a payment amount based on the limit amount, the application possible amount and the application amount, and transfer data including the payment amount and the account data of the employee Comprising a transfer data creation unit that, the, at least a portion of salary of the employee, wherein the pay advance on behalf of the employer.

In addition, a payroll receiving method according to the present disclosure includes a payroll reception apparatus including an information terminal owned by an employee and a payroll receiving apparatus connected to the information terminal via the network and installed at a payroll service provider. An application processing step of receiving a salary receipt application including an application amount from the information terminal, the payroll receiving method performed in the system, accumulated data of working hours of the employee, and Applicable amount calculating step of calculating the applicable amount of the salary receipt of the employee based on the salary unit price set according to the employment category, the prepaid upper limit rate set according to the employment category and the already paid amount , The limit obtained by multiplying the number of employees of the employer by the utilization rate and the unit price of the payroll service set for each of the employers, the applicable amount of application and the amount of application And at least one of the employee's salaries by performing a payment amount calculation step of calculating a payment amount and a transfer data creation step of generating transfer data including the payment amount and the account data of the employee. The department may be replaced on the behalf of the employer for payment.

In addition, the program according to the present disclosure is set according to application processing means for receiving an application for receiving a salary including the application amount from the employee, the cumulative data of the working hours of the employee, and the employment category of the employee. Application possible amount calculation means for calculating the application possible amount of the salary receipt of the employee based on the paid salary unit price, the prepaid upper limit rate set according to the employment category and the already paid amount, the number of employees of the employer Payment amount calculation means for calculating the payment amount based on the limit amount obtained by multiplying the utilization rate of the payroll service and the unit price used for each of the employers, the applicable amount and the application amount, It is a program for functioning as transfer data creation means which creates transfer data including payment amount and account data of the employee.

According to the present disclosure, 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 salary receipt system concerning one embodiment of this indication. It is a figure which shows the example of a hardware constitutions of the salary receipt system shown in FIG. (A) shows a hardware configuration example of the payroll receiving apparatus. (B) shows an example of the hardware configuration when the corporate terminal and the employee terminal are PCs. (C) shows an example of 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 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 payroll pattern change initial screen, and (c) shows a payroll 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. It is an example of a screen displayed on the display part of an employee terminal. (A) Application top screen, (b) Transfer destination account list screen, (c) Application amount input screen, (d) Transfer amount confirmation screen, (e) Transfer account specification screen (F) shows an application content confirmation screen, and (g) shows an acceptance completion screen. It is an example of a screen displayed on the display part of an employee terminal. (A) shows an application top screen, (b) shows a usage history screen, (c) shows an application cancellation confirmation screen, and (d) shows a cancellation acceptance completion 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 disclosure 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 the communication network 2, for example, the Internet can be used. The communication network 2 transmits data transmitted and received between PCs and portable terminals connected thereto. 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. The host is not limited to a credit company, and may be a credit 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 recording 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 entire operation of the payroll receiving apparatus 10.

As the external recording medium 16, for example, a recording medium such as a CD-ROM, a CD-RW, a DVD-ROM, a DVD-RW, and a flexible disk can be used. The external recording medium 16 stores, for example, a payroll receiving program. The CPU 11 can read out the payroll receiving program and deploy it in the RAM 13 to execute the payroll receiving program.

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, the RPM 22, the RAM 23, the non-volatile storage 24, the communication I / F 25, the external recording medium 26, the 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. The CPU 21 controls the respective units of the company terminal 20 and the employee terminal 30 by reading and executing the operating system and other programs stored in the ROM 22, the non-volatile storage 24, and the external recording medium 26 using the RAM 23 as a work area. Do.

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 wireless communication such as Wi-Fi, a display unit 43 such as a liquid crystal display, and an input unit 44 including a touch panel and operation buttons mounted on the liquid crystal display. 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 comprises a microprocessor or the like. The CPU 31 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 controls each part of the company terminal 20 and the employee terminal 30 by executing the program.

The corporation terminal 20 and the employee terminal 30 access the payroll receiving apparatus 10 via the communication network 2 using a general-purpose browser or the like. As a result, it is possible to execute payroll processing on the company terminal 20 and the employee terminal 30 side. Alternatively, a dedicated pay receipt application program (application) is installed in the company terminal 20 and the employee terminal 30. By activating the application, it is possible to execute a payroll program on the company terminal 20 and the employee terminal 30 side.

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 data creation unit 105, a deduction data 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”, “approval flag” 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 and management state of the company, actual results, 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, it is possible to set an attendance cycle, a pay date, a prepayment upper limit rate, and the like for each employment category. Based on these, the date of receipt and the amount of receipt can be set more freely than in the past. Therefore, it is possible to provide a more convenient salary reception service.

The entry of data to the payroll pattern table T2 is basically performed by the host at the time of joining the payroll service of the company. Also, the employer side can update 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: temporary employee, 90: part-time job are set. However, the present invention is not limited 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. “Monthly paid” indicates the number of pays per month. For example, if monthly salary is set once (or twice), if weekly salary, etc., four times may be set. “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. The deduction amount may be subtracted in advance from the total salary amount. However, because salary increases with the passage of days, if you make a salary receipt application (hereinafter referred to as “prepayment application”) at the beginning of the month when the gross salary is small, the gross salary falls below the deduction amount, and the receipt of salary It may not be possible 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. It is also good. It can be set freely according to the circumstances of the company, etc.

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 T2 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. Only one can be provided, or three or more can 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. For “Transfer destination 1”, “Transfer destination 2” and “Transfer destination 3”, the “Financial institution number”, “Branch number”, “Type”, “Account number”, “Account name” of the financial institution of each transfer destination ", Etc., data necessary for the transfer are 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, and the like.

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 It is stored as a former account holder. The employee account data acquired from the employee table T3 by the designation by the employee is “transfer destination financial institution number”, “transfer destination branch number”, “transfer destination deposit type”, “transfer destination account number”, “transfer destination While being stored as an account holder, "transfer amount" and "transfer designated 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 has a function as an image generation unit that transmits data for displaying an image on the display unit 27 to the employee terminal 30. It also has a function as an authentication unit that authenticates whether or not access from the employee terminal 30 is permitted based on the login ID and the password.

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 from 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 16th to 11:00 on the 16th of the start of the attendance cycle, this month is the prepayment application OK period, and from 11:00 on the 8th to the 15th day of the attendance cycle closing day, 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 data creation unit 105 has a function of creating a transfer table T6 to be transmitted to the transfer system 50 of the financial institution by designating the transfer destination account and the 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, the branch number has three digits and the account number has seven digits (full silver format). Therefore, when a bank account is designated, it is stored as it is in “transfer destination 1”, “transfer destination 2”, and “transfer destination 3” of the employee table T3.

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, the Japan Post Bank branch number and the account number may be kept as they are in a symbol number format, or may be converted to a BANK format number system and may be stored. Moreover, although it is a symbol number format, some numbers may be cut off and held corresponding to the branch number 3 digit bank number and the account number 8 digit of the bank type.

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 data creation 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 data creation 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 creation unit 106 calculates the total amount of salary 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 T7 for each employer. Have the ability to create 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 salary pattern update unit 101 reads the salary pattern data of the employer from the salary 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 “detail” of the employment category to be changed with a mouse or the like to select it, and the selected employment category is transmitted to the pay pattern update unit 101 (step S105). For example, in the example of FIG. 6 (b), "full-time employee" is selected.

The salary pattern update 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 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 70, 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, pressing “Apply” on the application top screen 72 notifies the request processing unit 102 of an instruction for executing the application (step S209). According to an instruction of the request processing unit 102 that has received the request, the application available amount calculation unit 103 calculates an application available amount that the employee can receive (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, with reference to the request table T5, one having an application status flag of “1” (under application), “3” (under transfer) or “5” (transfer completion) is extracted. The extracted “transfer amount” is summed to calculate the already paid amount, and it is subtracted from the above-mentioned application possible amount to obtain the final application possible amount. Below, an example of a calculation formula is given.

Allowable amount for application (Yen) = Cumulative working time data (h) × Hourly wage unit price (Yen) × Prepayment 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 the desired application amount in the application amount input field (step S212). 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 determination 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). When the application is confirmed with the contents of the application content confirmation screen 77, 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 at which the application for transfer on the day can be applied to the transfer system 50 of the financial institution is determined in advance, and if the application for receiving a 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, the date of application is stored in the "application date" of the new column of the request table T5. In addition, it is desirable to store not only the date but also the time, for the convenience of batch processing for creating the deduction data table T7. 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 a transfer account designated by the employee. As the "transfer date", the scheduled date of the transfer date determined earlier is stored. 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 data 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, a transfer table T6 is created for all the applications for which payment has not been completed. When approving by the employer, a transfer table T6 is created for an application whose approval flag is “1”, ie, approved.

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 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 data 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).

Further, the transfer data creation unit 105 also has a function of monitoring whether the transfer has been successful. That is, after transmission of the transfer table T6, the transfer data 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. Note that 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. Even if the employee does not check the usage history confirmation screen 79, details can be known. 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 creation unit 106 acquires “working period” (time attendance cycle) and “deduction data closing date” from the pay pattern table T2. Then, based on the business day calendar of each financial institution, the deduction date of the current 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 day, the pull-out data generation unit 106 starts the generation of the pull-out 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. A deduction data table T7 is provided to each employer (see dashed arrow in FIG. 5E).

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, the transfer data creation unit 105 sets account data designated by the employee from among the plurality of account data 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 it to the employee In addition, it is configured to receive an application for cancellation of salary receipt from the employee. Then, the transfer data creation unit 105 is configured to create the transfer table T6 in response to the application for the salary receipt for which the application has not been cancelled. 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.

In addition, the deduction data 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 disclosure have been described in detail with reference to the drawings, the above embodiments are merely examples of the present disclosure, and the present disclosure is not limited to only the configurations of the above embodiments. . Of course, even if there are design changes and the like within the scope of the present disclosure, they are included in the present disclosure.

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

CROSS-REFERENCE TO RELATED APPLICATIONS

This application claims priority based on Japanese Patent Application No. 2017-186092 filed with the Japanese Patent Office on September 27, 2017, the entire disclosure of which is incorporated herein by reference in its entirety.

Claims

An information terminal owned by an employee; and a payroll receiving apparatus connected to the information terminal via a network and installed at a payroll service provider.
The payroll receiver
An application processing unit that receives an application for salary receipt including an application amount from the information terminal;
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;
The amount of payment is calculated based on the maximum amount obtained by multiplying the number of employees of the employer by the usage rate of the payroll service and the unit price set for each employer, the applicable amount for application and the amount for application. The payment amount calculation unit
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 information terminal owned by an employee; and a payroll receiving apparatus connected to the information terminal via a network and installed at a payroll service provider.
The payroll receiver
An application processing unit that receives an application for salary receipt including an application amount from the information terminal;
Cumulative data of working hours of the employee, salary unit price set according to the employment category of the employee, prepaid upper limit rate set according to the employment category, and salary of the employee based on the already paid amount Application possible amount calculation part which calculates possible application amount of receipt, and
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 information terminal owned by an employee; and a payroll receiving apparatus connected to the information terminal via a network and installed at a payroll service provider.
The payroll receiver
An application processing unit that receives an application for salary receipt including an application amount from the information terminal;
Cumulative data of working hours of the employee, salary unit price set according to the employment category of the employee, prepaid upper limit rate set according to the employment category, and salary of the employee based on the already paid amount Application possible amount calculation part which calculates possible application amount of receipt, and
The amount of payment is calculated based on the maximum amount obtained by multiplying the number of employees of the employer by the usage rate of the payroll service and the unit price set for each employer, the applicable amount for application and the amount for application. The payment amount calculation unit
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.
The possible application amount calculation unit multiplies the salary unit price set according to the employment category by the accumulated data of working hours from the start date of the time cycle set according to the employment category to the application date of the payroll reception And calculating the possible application amount 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. The salary receipt system according to Item 2 or 3.
The payment amount calculation unit sets the application amount as the payment amount when the application amount is equal to or less than the application possible amount, and when the application amount exceeds the application possible amount, the application possible amount is the application amount. If the payment amount and the additional amount between the payment amount and the total amount already used by the entire employer to which the employee belongs exceeds the limit amount, the total replacement amount for the employer is the limit 4. The payroll system according to claim 1, which warns that the amount has been exceeded.
The utilization rate and the usage cost used to calculate the limit amount are determined in advance by the provider of the payroll service based on the type, size, business condition, results, past experience, or others of the employer. The payroll system according to any one of claims 1, 3, 5 characterized in that.
The transfer data creation unit is configured to set the account data designated by the employee from among a plurality of account data in the transfer data, and the application processing unit is configured to process a plurality of information from the information terminal. An instruction to confirm, register, update or delete the account data is received, and based on the instruction, presentation, registration, update or deletion of the account data is performed. Payroll system according to any one of 6.
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.
A payroll method performed by a payroll system comprising: an information terminal owned by an employee; and a payroll apparatus connected to the information terminal via a network and installed at a payroll service provider.
The payroll receiver
An application processing step of receiving an application for salary receipt including an application amount from the information terminal;
Cumulative data of working hours of the employee, salary unit price set according to the employment category of the employee, prepaid upper limit rate set according to the employment category, and salary of the employee based on the already paid amount Application possible amount calculation process which calculates application possible amount of receipt, and
The amount of payment is calculated based on the maximum amount obtained by multiplying the number of employees of the employer by the usage rate of the payroll service and the unit price set for each employer, the applicable amount for application and the amount for application. Payment amount calculation process
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,
Cumulative data of working hours of the employee, salary unit price set according to the employment category of the employee, prepaid upper limit rate set according to the employment category, and salary of the employee based on the already paid amount Application possible amount calculation means to calculate application possible amount of receipt,
The amount of payment is calculated based on the maximum amount obtained by multiplying the number of employees of the employer by the usage rate of the payroll service and the unit price set for each employer, the applicable amount for application and the amount for application. Payment amount calculation means,
A program for functioning as transfer data creation means for creating transfer data including the payment amount and the account data of the employee.