JP2014067231A - Salary calculation system, salary calculation program and salary calculation server - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce a gap from an event occurrence to a payday.SOLUTION: A salary calculation system includes: previous month salary statement storage means 22-1 that stores a previous month salary statement data; current month salary statement storage means 23-1 that creates and stores a current month salary statement data 23 by copying a salary statement data stored in the previous month salary statement storage means 22-1; and salary payment and deduction base information storage means 25 and 26 that store salary payment and deduction base information when a new salary payment and deduction base information occurs after a closing date of the previous month. The present month salary statement data 23 is updated as a night batch by a current month payroll processing closing date 4 on the basis of the salary payment and deduction base information.

Description

  The present invention relates to a salary calculation system in a large-scale company.

  Conventionally, a salary calculation system in a large-scale company is performed in the following procedure, for example. FIG. 7 is an explanatory diagram showing an outline flow of conventional salary calculation processing. After the payment processing of the salary for the previous month, the completion of the predetermined paper processing is completed 71 for the previous month's salary processing. After that, in order to reflect the payment processing for the current month's salary, the acquisition process of personnel information etc. that captures the salary payment / deduction basis information that occurred after the previous month's salary processing deadline and until the current salary processing deadline 4 72 is performed. The receipt of the salary payment / deduction basis information is temporarily closed by the salary processing deadline 4. After that, the salary calculation processing 73 is performed to calculate the salary for the current month based on the acquired salary payment / deduction basis information, and to calculate the salary for the current month. A confirmation process 74 is performed. After that, the payment date 75 is obtained through a salary payment process 75 including a bank transfer procedure, and the salary process is completed 76 for the current month.

  FIG. 8 is also an explanatory diagram showing details of the conventional salary calculation processing. For example, after completion of the previous month's salary processing 71 on September 15, personnel information etc. capture processing 72 is performed. Actually, salary payment / deduction basis information generated after the deadline for the previous month (August 21) is taken in. The taken salary supply / deduction basis information is accumulated in the salary master 77. This personnel information fetching process 72 is performed until the salary processing deadline 4 on September 20.

  Thereafter, from September 21 to October 6, a salary calculation process 73 for calculating the amount of payment and deduction for each individual from various information accumulated in the salary master 77 is performed. During this time, salary calculation, correction and re-correction are performed. Then, a pay statement 78-1 is created from the pay master 77. After that, in October, the payment confirmation process 74 confirms the person in charge of the personnel details for the salary statement 78-2, and then the bank transfer process is performed based on the data of the salary statement 78-3. The salary payment process 75 is performed on October 10th. Finally, the pay processing for the current month is completed 76 on October 15 again. That is, for the current month, based on the salary payment / deduction basis information for the calculation period from August 21 to September 20, the salary payment is October 10, and for the next month, the calculation period is from September 21 to 10 On the 20th of the month, the salary payment will be on the 10th of November.

  Japanese Patent Laid-Open No. 6-325066 (Patent Document 1) describes an invention relating to a salary calculation method and system. According to Patent Document 1, there is described a technique for calculating daytime attendance data such as working hours and overtime hours using time stamp data collected by a time recorder, and calculating period attendance data based on attendance closing dates. Yes.

JP-A-6-325066

  However, according to the conventional technique, the salary payment for the salary payment / deduction basis information generated after the salary processing deadline for the current month is generally the next month. That is, in the schedule described in FIG. 8, the salary payment for the salary payment / deduction basis information that occurred on September 21 in the calculation period of September 21 to October 20 for the next month is as the next month. A process of paying in addition to the payment date for November (November 10) is performed. Thus, the deviation from the occurrence of the event to the payment date 5 is about 50 days at the longest and about 20 days after the shortest, and the company is required to reduce this deviation as much as possible.

  On the other hand, in the case of a large-scale company with a large number of employees or a government office with a large number of employees, it takes time to calculate the salary due to the large number of people, and it is difficult to perform the calculation within a predetermined period. There was a problem.

  The problem to be solved by the present invention is the case where the period from the salary processing deadline to the salary payment is performed in the shortest possible time, and in the case of a large-scale company (including public offices; the same shall apply hereinafter). It is also possible to provide a salary calculation system that does not burden the calculation process of salary for a large number of employees.

  In order to solve the above-mentioned problems, the salary calculation system according to the present invention takes in salary payment / deduction basis information generated by the deadline, and calculates the salary for the current month based on the acquired salary payment / deduction basis information. In the payroll calculation system, the previous month salary details storage means for storing the salary details data for the previous month and the salary details data for the current month are created and stored from the salary details data stored in the previous month salary details storage means Salary details storage means for the current month, and when there is occurrence of the salary payment / deduction basis information after the deadline for the previous month, the salary supply / deduction basis information storage means for storing the salary payment / deduction basis information, Based on the salary payment / deduction basis information stored in the salary supply / deduction basis information storage means, the salary detail data for the current month stored in the salary detail storage means for the current month Te, is characterized in that it has a updating means for updating said before the deadline of the current month.

  According to the present invention having the above-described configuration, since it is decided to create the salary detail data for the current month from the salary detail data for the previous month stored in the salary detail storage means for the previous month, the salary supply for the salary detail data for the previous month・ The salary calculation for employees who do not generate deduction ground information is completed on the salary processing deadline for the current month.

  On the other hand, a salary payment / deduction basis information storage means for storing the salary payment / deduction basis information is provided, and the salary details data for the current month stored in the salary details storage means for the current month is received by the salary processing deadline for the current month. Since it was decided to update based on the above-mentioned salary payment / deduction basis information, the salary calculation for employees who had generated salary payment / deduction basis information for the previous month's salary details data was completed on the salary processing deadline for the current month. It will be.

  Furthermore, for the entire employee, the current month's salary detail data is created by copying from the previous month's salary detail data. The salary detail data for the current month is updated by night batch as described later. Therefore, the salary calculation is completed on the salary processing deadline for the current month for both employees who have no salary payment / deduction basis information. This makes it possible to reduce the burden of payroll calculation in a large-scale company with a large number of processing cases.

  Further, according to the present invention, the salary calculation for the current month can be performed on the day of the salary processing deadline for the current month, and the burden of the salary calculation can be reduced. Can be changed to move. Specifically, the difference between the occurrence of an event and the date of payment is paid for about 40 days at the longest and about 10 days for the shortest, and can be shortened by about 10 days compared to the conventional case. This enables the period from the salary processing deadline to the salary payment to be as short as possible, and the salary payment for the salary payment / deduction basis information generated by the salary processing deadline is as much as possible in the current month. Payment can be processed.

It is explanatory drawing which shows the detail of the salary calculation system regarding 1st Embodiment. It is explanatory drawing which shows the outline | summary flow of the salary calculation system regarding 1st Embodiment. It is a block diagram of the salary calculation system regarding 1st Embodiment. It is explanatory drawing which shows operation | movement of the nighttime batch processing program regarding 1st Embodiment. It is a flowchart which shows operation | movement of the nighttime batch process regarding 1st Embodiment. It is explanatory drawing which shows the detailed flow in the nighttime batch process of the personnel information regarding 1st Embodiment. It is explanatory drawing which shows the detailed flow in the nighttime batch process of working hours management regarding 1st Embodiment. It is explanatory drawing which shows the detailed flow in the night batch process of the social insurance information regarding 1st Embodiment. It is explanatory drawing which shows the detailed flow in the night batch process of the company house information regarding 1st Embodiment. It is explanatory drawing which shows the outline | summary flow of the conventional salary calculation process. It is explanatory drawing which similarly shows the detail of the conventional salary calculation process.

(First embodiment)
Hereinafter, a first embodiment of the present invention will be described. FIG. 2 is an explanatory diagram showing an outline flow of the salary calculation system according to the first embodiment. After the payment processing for the previous month's salary, the previous month's salary completion processing 31 is performed upon completion of predetermined paperwork. Thereafter, in order to reflect the salary payment process for the current month, the personnel information acquisition process 32 for taking in salary payment / deduction basis information generated after the previous month's salary process deadline date and before the current month's salary process deadline date 32 Is done. Here, the salary supply / deduction basis information includes any one of personnel information, work information, and deduction information. At the same time, a salary calculation process 33 is performed for calculating the salary for each individual based on the acquired salary payment / deduction basis information and calculating the salary for the current month. These are performed by nighttime batch processing as will be described later. These are temporarily closed on the salary processing deadline 4. The personnel information is information such as transfer, recruitment, promotion and salary increase. The work information is information such as absence from work and overtime. The deduction information includes company housing fees, social insurance premiums, etc.

  After the salary processing deadline 4, a payment amount confirmation process 34 is performed by the personnel manager. After that, the payment date 35 is obtained through a salary payment process 35 including a bank transfer procedure, and the salary completion process 36 for the current month. As is clear from this, the salary processing deadline 4 relating to the present embodiment is the end of the month, and the salary calculation processing 33 is performed before the salary processing deadline 4 as compared with the conventional technique.

  FIG. 1 is an explanatory diagram showing details of the salary calculation system according to the first embodiment. For example, a salary completion process 31 for the previous month is performed on September 15, and then a personnel information etc. capturing process 32 is performed. What is taken into consideration in this personnel information acquisition process 32 is that there are employees whose salary for the current month is not different from the salary for the previous month, and various payments that have occurred up to the salary processing deadline 4 The salary increases or decreases by the deduction amount, and there are employees who need to calculate monthly. Therefore, for the latter employee, in order to accurately reflect the event that has occurred in the salary, the salary payment / deduction basis information generated after the previous month's salary processing deadline (the end of August) is taken. Specifically, various information such as personnel information, work information, and deduction information is accumulated in the database 20 described later. Various information such as personnel information, work information, and deduction information is stored in a supply basis file 25 and a deduction basis file 26 as salary supply / deduction basis information storage means 25 and 26. Further, the salary detail data for the previous month, which is data relating to the salary for the previous month, is stored in the salary detail storage means 22-1 for the previous month of the database 20, and the salary detail data 23 for the current month, which is data relating to the salary for the current month, is stored in the database. It is stored in the 20 monthly salary details storage means 23-1.

  At the same time, the salary calculation system according to the present embodiment creates salary detail data 23 for the current month by copying from the salary detail data for the previous month for all employees. This creation is performed by nighttime batch processing. For employees whose salary for the current month is the same as the salary for the previous month, that is, for employees whose salary payment / deduction basis information does not occur from the day after the salary processing deadline 4 of the previous month until the salary processing deadline 4 of the current month The salary calculation is completed when the salary detail data 23 is created. However, whether salary payment / deduction basis information has occurred or not is determined on the salary processing deadline 4 of the current month.

  On the other hand, for employees who have generated salary payment / deduction basis information from the day after the salary processing deadline 4 of the previous month to the salary processing deadline 4 of the current month, the salary details for the current month are determined by the payment basis file 25 and the deduction basis file 26. Data 23 is updated. This update is performed by nighttime batch processing every day until the salary processing deadline 4 of the end of September after the previous month salary completion processing 31 on September 15th. In this way, the salary calculation for the employee who has generated the salary payment / deduction basis information is completed and fixed on the salary processing deadline 4 of the current month.

  Personnel in charge of salary statement data 23 for the current month stored in the salary statement storage means 23-1 for the current month in the payment confirmation process 34 after October 4 of the salary processing deadline 4 for the current month Is confirmed. It also calculates the total salary of all employees and creates legal records. Further, retroactive processing for adjusting past errors is also performed here. Then, on October 10, a transfer process to the bank is performed based on the data of the salary detail data 23 for the current month, and a salary payment process 35 is performed. Finally, salary completion processing 36 for the current month is performed again on October 15. After the current month salary completion process 36, a salary detail (not shown) for the next month is created from the current salary detail data 23 stored in the current salary detail storage means 23-1. That is, for the current month, the salary payment is October 10 based on the salary payment / deduction basis information from September 1 to the end of September, and the next month is from October 1 to the end of October. The salary will be paid on November 10th.

  Thus, according to the salary calculation system relating to the present embodiment, the salary calculation processing 33 is performed before the salary processing deadline 4, so the salary processing deadline 4 is changed from the conventional September 20 (FIG. 8). You can change it to be 10 days late until the end of September. Therefore, the deviation from the occurrence of the event to the payment date 5 is paid after about 40 days at the longest and about 10 days at the shortest, and can be shortened by about 10 days compared to the conventional case.

  FIG. 3 is a configuration diagram of the salary calculation system according to the first embodiment. The salary calculation system includes a Web / AP (Application) server 1 and a database server 2. The Web / AP server 1 and the database server 2 are connected via a network and can exchange electronic data. The database server 2 controls the database 20. The Web / AP server 1 is connected to a plurality of personal computers 3 via a network. Accordingly, the personal computer 3 can access the database server 2 via the Web / AP server 1. The network is, for example, a company intranet or the Internet.

  The database 20 functions as a previous month salary detail storage means 22-1 for storing the salary detail data for the previous month, and also functions as a current month salary detail storage means 23-1 for storing the salary detail data 23 for the current month. It also functions as salary supply / deduction basis information storage means 25 and 26 for storing the basis file 25 and the deduction basis file 26. Furthermore, it functions as a subject file described later.

  The Web / AP server 1 includes a personnel information section 11, a salary information section 12, a social insurance information section 13, a working time management section 14, and a company house information section 15. The personnel information unit 11, salary information unit 12, social insurance information unit 13, working time management unit 14, and company housing information unit 15 accept input data from the personal computer 3 and store the input data in the database 20 via the database server 2. To do.

  The personnel information section 11 receives employee movement information, recruitment information and promotion / raising information input from the personal computer 3 and stores them in the database 20 as supply basis information. The social insurance information unit 13 accepts employee social insurance subscriber information input from the personal computer 3 and stores it in the database 20 as deduction basis information.

  The working time management unit 14 accepts employee overtime performance information input from the personal computer 3 and stores it in the database 20 as supply basis information. The company housing information unit 15 accepts employee house usage fee deduction information input from the personal computer 3 and stores it in the database 20 as deduction basis information. The salary information unit 12 updates the salary detail data 23 for the current month based on the supply basis information and the subtraction basis information stored by the personnel information unit 11, social insurance information unit 13, working time management unit 14, and company housing information unit 15. .

  The nighttime batch unit 16 copies the salary detail data for the previous month to create the salary detail data 23 for the current month, and for employees who have generated salary payment / deduction basis information from the payment basis file 25 and the deduction basis file 26 The salary details data 23 for the minute is updated. The storage unit 17 stores various data, and the I / O control unit 18 controls input / output with the database server 2 and the plurality of personal computers 3. And the control part 10 controls operation | movement of these each part.

  FIG. 4 is an explanatory diagram showing the operation of the nighttime batch processing program according to the first embodiment. The database 20 includes a personnel file 21 as a subject file, a social insurance file 24, a working time management file (not shown), and a company housing file, and includes salary detail data for the previous month and salary detail data 23 for the current month.

  (1) When the personnel information section 11 of the Web / AP server 1 accepts the input of the transfer information from the personal computer 3, the date is displayed in the corresponding employee A column of the personnel file 21 of the database 20 as a basis for payment (September 17). And the amount of basic salary etc. is stored. Similarly, when the social insurance information section 13 accepts the input of social insurance subscriber information from the personal computer 3, the date (September 17) and the deduction are displayed in the corresponding employee D column of the social insurance file 24 of the database 20 as a deduction basis. Stores the amount.

  (2) The nighttime batch unit 16 of the Web / AP server 1 reads the date and the basic salary amount stored in the corresponding employee A column of the personnel file 21 of the database 20 at the time of nighttime batch processing. Similarly, the nighttime batch unit 16 reads the date and deduction amount stored in the corresponding employee D column of the social insurance file 24 of the database 20 at the time of nighttime batch processing.

  (3) After that, the nighttime batch unit 16 stores the salary details for the current month in the database 20 using the employee number as a key for the date (September 17) and the basic salary amount stored in the corresponding employee A column of the personnel file 21. Write to means 23-1 and update it. Similarly, the date (September 17) and the deduction amount stored in the corresponding employee D column of the social insurance file 24 of the database 20 are written in the salary details storage means 23-1 for the current month using the employee number as a key and updated. To do. As a result, the salary detail data 23 for the current month is updated.

FIG. 5 is a flowchart showing the operation of the nighttime batch processing according to the first embodiment.
S 101: After the previous month salary completion processing 31 on September 15, the control unit 10 of the Web / AP server 1 sends the previous month's salary details data to the night batch unit 16, and the previous month's salary details storage unit 22 of the database 20. -1 is instructed to be stored.

S102: The control unit 10 instructs the nighttime batch unit 16 to copy the salary detail data for the previous month and create the salary detail data 23 for the current month.
S103: The control unit 10 instructs the nighttime batch unit 16 to store the salary detail data 23 for the current month in the current salary detail storage means 23-1 of the database 20.

S104: The control unit 10 instructs the nighttime batch unit 16 to check whether there is a subject file (personnel file 21, social insurance file 24, etc.) in which the salary supply / deduction basis information is generated.
S105: The control unit 10 instructs the nighttime batch unit 16 to store the salary supply / deduction basis information for each subject file in the database 20, and to update the salary detail data 23 for the current month. Details will be described next.

FIG. 6A is an explanatory diagram showing a detailed flow in nighttime batch processing of personnel information related to the first embodiment.
S201: When employee movement information, recruitment information, and promotion / payment information are input from the personal computer 3, the control unit 10 instructs the personnel information unit 11 to accept them.

S202: The control unit 10 instructs the personnel information unit 11 to store it in the database 20 as personnel announcement information.
S203: Thereafter, the control unit 10 provides the night batch unit 16 with the salary information unit 12 in the night batch based on the personnel announcement information stored in the database 20, and the salary in the monthly salary details storage means 23-1 in the database 20. An instruction is given to update the detailed data 23. Updating is updating based on the employee number.

FIG. 6B is an explanatory diagram illustrating a detailed flow in nighttime batch processing of work hours management according to the first embodiment.
S301: The control unit 10 instructs the salary information unit 12 to update the salary detail data 23 of the salary detail storage unit 23-1 for the current month in the database 20 based on the personnel announcement information.

S302: The control unit 10 instructs the salary information unit 12 to store in the database 20 as salary change information.
S303: By referring to the salary change information by the operation from the personal computer 3, the monthly work result information indicating the overtime of the employee is created.

S304: The control unit 10 instructs the work time management unit 14 to store the work performance monthly information in the database 20 as work time report information.
S305: After that, the control unit 10 sends the salary information unit 12 to the nighttime batch unit 16 based on the working time report information stored in the database 20 and stores the salary details storage unit 23-1 for the current month in the database 20 in the nighttime batch. An instruction is given to update the salary detail data 23.

FIG. 6C is an explanatory diagram illustrating a detailed flow in nighttime batch processing of social insurance information according to the first embodiment.
S401, S402: The control unit 10 instructs the social insurance information unit 13 to accept social insurance subscriber information through an operation from the personal computer 3, and instructs the database 20 to store the information as social insurance information.

  S403, S404: Similarly, the control unit 10 instructs the social insurance information unit 13 to accept employment insurance subscriber information by operating from the personal computer 3, and instructs the database 20 to store it as employment insurance information.

  S405: Thereafter, the control unit 10 sends the salary information unit 12 to the night batch unit 16 based on the social insurance information and employment insurance information stored in the database 20, and the salary details storage means 23 for the current month in the database 20 in the night batch. -1 is instructed to update the salary detail data 23 of -1.

S406: The control unit 10 instructs the social insurance information unit 13 to import insurance / savings / property saving application information through an operation from the personal computer 3.
S407: The control unit 10 instructs the night batch unit 16 that the social insurance information unit 13 totals insurance, savings, and property savings deductions in the night batch.

S408: The control unit 10 insures and saves the insurance / savings / property saving application information and the insurance / savings / property savings deduction amount to the social insurance information unit 13 in the database 20. Instruct to store as property information.
S409: After that, the control unit 10 makes the salary information unit 12 to the night batch unit 16 based on the insurance / savings / property information stored in the database 20 and the salary information storage means 23- 1 is instructed to update the salary detail data 23 of 1

FIG. 6D is an explanatory diagram illustrating a detailed flow in nighttime batch processing of company housing information according to the first embodiment.
S501: The control unit 10 instructs the company house information unit 15 to accept maintenance of company house usage fee deduction information by an operation from the personal computer 3.

S502: The control unit 10 instructs the company house information unit 15 to store company house usage fee deduction information in the database 20 as company house usage fee information.
S503: After that, the control unit 10 sends the salary information unit 12 to the nighttime batch unit 16 based on the company house usage fee information stored in the database 20, and stores the salary details storage unit 23-1 for the current month in the database 20 in the nighttime batch. An instruction is given to update the salary detail data 23.

  As described above, according to the first embodiment of the present invention, the salary calculation for the current month can be performed on the salary processing deadline for the current month, and the burden of the salary calculation can be reduced. By doing so, the salary processing deadline can be delayed as much as possible, so that salary supply / deduction basis information such as personnel information can be incorporated into salary for the current month as much as possible. In addition, it is possible to ensure a sufficient amount of manual work for confirmation.

DESCRIPTION OF SYMBOLS 1 Web / AP server 2 Database server 3 Personal computer 4 Salary processing deadline 5 Supply date 10 Control part 11 Personnel information part 12 Salary information part 13 Social insurance information part 14 Work time management part 15 Company housing information part 16 Night batch part 20 Database 22 -1 Previous Month Salary Details Storage Unit 23 Current Month Salary Details Data 23-1 Current Month Salary Details Storage Unit 25 Payment Basis File 26 Deduction Basis File 31 Previous Month Salary Completion Processing 32 Personnel Information Capture Processing 33 Salary Calculation Processing 34 Payment confirmation processing 35 Salary payment processing 36 Current month salary completion processing

Claims (10)

In the salary calculation system that takes in salary payment / deduction basis information generated by the deadline, and calculates the salary for the current month based on the acquired salary payment / deduction basis information,
Previous month salary statement storage means for storing salary statement data for the previous month;
A monthly salary statement storage unit that creates and stores salary statement data for the current month from the salary statement data stored in the previous month salary statement storage unit;
A salary supply / deduction basis information storage means for storing the salary supply / deduction basis information when there is an occurrence of the salary supply / deduction basis information after the deadline for the previous month;
Based on the salary payment / deduction basis information stored in the salary payment / deduction basis information storage means, the monthly salary detail data stored in the current month's salary detail storage means by the deadline date for the current month A salary calculation system comprising an updating means for updating.   The salary calculation system according to claim 1, wherein the monthly salary detail data is updated in a nightly batch.   The salary calculation system according to claim 1, wherein the salary supply / deduction basis information includes any one of personnel information, work information, and deduction information.   The occurrence of the salary payment / deduction basis information includes any one of personnel information, social insurance information, working time management information, and company housing information generated after the deadline of the previous month. The payroll system described.   2. The salary calculation system according to claim 1, wherein the salary details for the current month are created by copying from the salary details data for the previous month. In the payroll calculation program that takes in the salary payment / deduction basis information generated by the deadline, and calculates the salary for the current month based on the acquired salary payment / deduction basis information,
A previous month salary statement storage procedure for storing the previous month salary statement data in the previous month salary statement storage means;
A monthly salary statement storage procedure for creating salary statement data for the current month from the salary statement data stored in the previous month salary statement storage unit and storing it in the current month salary statement storage unit;
When there is occurrence of the salary payment / deduction basis information after the deadline for the previous month, the salary supply / deduction basis information storage procedure for storing the salary payment / deduction basis information in the salary payment / deduction basis information storage means;
Based on the salary payment / deduction basis information stored in the salary supply / deduction basis information storage means, the deadline date for the current month is stored in the salary detail data stored in the salary detail storage means for the current month. A payroll program that causes a computer to execute an update procedure that is updated by   7. The salary calculation program according to claim 6, wherein the update procedure is performed by night batch processing.   A salary calculation server, comprising the salary calculation program according to claim 6 or 7. In the payroll server that takes in the salary payment / deduction basis information generated by the deadline, and calculates the salary for the current month based on the acquired salary payment / deduction basis information,
Connected to the database,
Instructing the previous month's salary statement data to be stored in the previous month's salary statement storage means of the database,
Instructing to create salary statement data for the current month from the salary statement data stored in the previous month salary statement storage means and storing it in the current month salary statement storage means of the database,
Instructing storing the salary payment / deduction basis information in the salary payment / deduction basis information storage means of the database when there is an occurrence of the salary payment / deduction basis information after the deadline for the previous month,
Based on the salary payment / deduction basis information stored in the salary payment / deduction basis information storage means, the monthly salary detail data stored in the current month's salary detail storage means by the deadline date for the current month A salary calculation server, characterized by having a control unit that instructs updating. The salary calculation server according to claim 9, wherein the monthly salary detail data is updated in a nightly batch.

Images