Labor cost management system, labor cost management method, and labor cost management program

Abstract

To provide a labor cost management system, a labor cost management method, and a labor cost management program configured to manage labor cost in detail for an employee who works multiple times at the same store or works at different stores on the same day.SOLUTION: A labor cost management system includes: time-recording means which registers an employee, workday, clock-in time and clock-out time of a store, in work result data, in accordance with time-recording operation on a terminal in the store; moving time registration means which registers, for each employee, moving time in each store in the work result data; and labor cost processing means which refers to the work result data, and calculates the total work time including the moving time for each store, for each employee, regarding a target month of a year, to calculate an allocation rate of the work time for each store.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a labor cost management system, a labor cost management method, and a labor cost management program. [Background technology]

[0002] For example, in a company that operates a store, it is difficult to cover all business days with only its own employees, so when there is a shortage of staff, it is common to adjust shifts by borrowing employees from other nearby stores and including helpers. For example, Patent Document 1 is known as an attendance management system for stores. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2003-6692 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the above-mentioned Patent Document 1 does not mention anything about managing labor costs in detail when an employee works at the same store multiple times a day or at multiple stores.

[0005] The present invention has been made in consideration of the above, and aims to provide a labor cost management system, labor cost management method, and labor cost management program that can manage labor costs in detail when an employee works at the same store multiple times a day or at multiple stores. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a labor cost management system that has a control unit and manages the labor costs of employees at each store, wherein the control unit is configured to be able to access a memory area that stores work performance data including employees, work days, arrival times, departure times, and travel times for each store, and is characterized by having a time-stamping means that registers the employee, work day, arrival time, and departure time for the store in the work performance data in response to a time-stamping operation at a terminal at the store, a travel time registration means that registers travel time for each store in the work performance data for each employee, and a labor cost processing means that refers to the work performance data, aggregates the work hours including travel time for each store for each employee for a target year and month, and calculates the allocation rate of work hours for each store.

[0007] According to one aspect of the present invention, the memory area stores payroll calculation result data including the target year and month, employee code, affiliation, basic salary, overtime pay, social insurance premiums, and income tax, as well as a journal entry linkage master that registers whether each payroll item is subject to journal entry linkage and whether it is subject to allocation, and the labor cost processing means may create employee-specific allocation result data including employee code, affiliation, payroll item, and amount based on the payroll calculation result data and the allocation rate of working hours for each store in accordance with the journal entry linkage master.

[0008] According to another aspect of the present invention, the personnel expense processing means may create department-specific item-specific journal entry linked data including department, salary item, and amount based on the employee-specific allocation result data.

[0009] In addition, according to one aspect of the present invention, the memory area stores a journal entry definition master that specifies debit or credit items for each salary item, and the labor cost processing means may create department-specific salary journal entry data for each department in accordance with the journal entry definition master based on the department-specific item journal entry linkage data.

[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a labor cost management method executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a memory area that stores work performance data including employees, work days, arrival times, departure times, and travel times for each store, and the method includes a time-stamping process executed by the control unit to register the employees, work days, arrival times, and departure times for each store in the work performance data in response to a time-stamping operation at a terminal at the store, a travel time registration process to register the travel time for each store in the work performance data for each employee, and a labor cost processing process to refer to the work performance data, aggregate the work hours including travel time for each store for each employee for the target year and month, and calculate the allocation rate of work hours for each store.

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is a labor cost management program to be executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a memory area that stores work performance data including employees, work days, arrival times, departure times, and travel times for each store, and the control unit executes the following labor cost management program: a time-stamping process in which the employee, work day, arrival time, and departure time for each store are registered in the work performance data in response to a time-stamping operation at a terminal at the store; a travel time registration process in which the travel time for each store is registered in the work performance data for each employee; and a labor cost processing process in which, by referring to the work performance data, the working hours including travel time for each store for each employee for the target year and month are tallied and the allocation rate of working hours for each store is calculated. [Effects of the Invention]

[0012] According to the present invention, it is possible to effectively manage personnel costs in detail when an employee works at the same store multiple times a day or at multiple stores. [Brief explanation of the drawings]

[0013] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a personnel cost management system according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the belonging master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of the employee master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the journal entry linkage setting master. [Figure 5] FIG. 5 is a diagram illustrating an example of the configuration of the journal definition master. [Figure 6] FIG. 6 is a flowchart illustrating an outline of the overall processing of the control unit of the labor cost management system according to this embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system according to this embodiment. [Figure 8] FIG. 8 is a diagram illustrating a specific example of the processing of the control unit of the labor cost management system according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. [Figure 14] FIG. 14 is a diagram illustrating a specific example of the processing of the control unit of the labor cost management system according to the present embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. [Figure 16]FIG. 16 is a diagram for explaining a specific example of the processing of the control unit of the labor cost management system in this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0014] Hereinafter, embodiments of a labor cost management system, a labor cost management method, and a labor cost management program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.

[0015] [1. Overview] For example, it is difficult for a company that operates a store to cover all business days with its own employees alone, so if there are not enough staff, it is common for them to borrow employees from other nearby stores and adjust shifts to include helpers.

[0016] On the other hand, from the perspective of labor costs, in order to calculate the labor cost budget to be allocated to each store and analyze performance, it would be desirable to allocate labor costs in proportion to the proportion of support staff working at other stores and to manage them more strictly.

[0017] However, when an employee works multiple times a day at the same store or multiple stores, or when considering the travel time between stores, management becomes complicated, and previously it was not possible to allocate pay according to working hours at each work location. Additionally, because the allocation results are currently linked, if you want to manage the "transferred amount" for analytical purposes, you need to check it separately against the payroll results. If it were possible to implement a system that would allow detailed management of these amounts as transfers to other stores, it would be easier to manage at the field level.

[0018] Therefore, in this embodiment, a system is constructed in which the total working hours for each employee and each store, taking into account support and travel time, are tallied and a labor cost allocation rate is calculated based on the ratio, making it possible to manage labor costs in detail when an employee works at the same store multiple times a day or at multiple stores.

[0019] The labor cost management system of this embodiment can be widely used in industries such as retail businesses that operate multiple stores.

[0020] [2. Configuration] The configuration of a personnel expense management system 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the personnel expense management system 100.

[0021] The labor cost management system 100 is, for example, a commercially available desktop personal computer or workstation. As shown in Figure 2, the labor cost management system 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the labor cost management system 100 is connected to each other so that they can communicate with each other via any communication path.

[0022] The communication interface unit 104 communicatively connects the labor cost management system 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function for communicating data with other devices via a communication line. Here, the network 300 has a function for communicatively connecting the labor cost management system 100 with the server 200, store terminals 400..., and employee terminals 500..., and is, for example, the Internet or a LAN (Local Area Network). The store terminals 400... are configured to be able to communicate with the labor cost management system 100 via the network 300. The store terminals 400... are terminals located in stores, for example, at Kokura IC or Yukuhashi IC in the Fukuoka area of ​​western Japan. The Kokura IC in the Fukuoka area of ​​western Japan will be abbreviated as "Kokura IC," and the Yukuhashi IC in the Fukuoka area of ​​western Japan will be abbreviated as "Yukuhashi IC." The employee terminals 500 are terminals carried by employees for their own use, and are configured to be able to communicate with the labor cost management system 100 via the network 300.

[0023] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114 as a display unit, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0024] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0025] The storage unit 106 also stores a department master 106a, an employee master 106b, a journal linkage setting master 106c, a journal definition master 106d, work performance data, salary journal data by department, and the like.

[0026] The affiliation master 106a can be configured as a table or the like in which affiliated stores (affiliation code and / or affiliation name), business hours, and closing times are registered in association with each other, as shown in Fig. 2. In the example shown in Fig. 2, the first line has the affiliation code "Z00-Z00-Z01", the affiliation name "West Japan - Fukuoka area - Kokura IC", business hours "07:00", and closing time "22:00", and the second line has the affiliation code "Z00-Z00-Z02", the affiliation name "West Japan - Fukuoka area - Yukuhashi IC", business hours "07:00", and closing time "22:00".

[0027] As shown in FIG. 3, the employee master 106b can be configured as a table that associates and registers the employee (employee code and / or employee name), affiliated store (affiliation code and / or affiliation name), work system (full-time employee or part-time employee), employee classification (full-time employee or part-time employee), etc.

[0028] In the example shown in the figure, the employee code is "A005", the department code is "Z00-Z00-Z02", the department name is "West Japan - Fukuoka Area - Yukuhashi IC", and the employee classification is "Full-time employee".

[0029] The journal entry linkage setting master 106c can be configured as a table or the like that associates and registers salary items (basic salary, overtime pay, social insurance premiums, income tax, net pay), whether or not they are subject to journal entry linkage, and whether or not they are subject to distribution, as shown in Fig. 4. In the example shown in the same figure, basic salary, overtime pay, social insurance premiums, income tax, and net pay are all subject to journal entry linkage and distribution.

[0030] The journal entry definition master 106d can be configured as a table that associates and registers salary items (basic salary, overtime pay, social insurance premiums, income tax, net pay), debit items, and credit items, as shown in Fig. 5. In the example shown in the figure, basic salary and overtime pay are set as salary allowances in the debit item, social insurance premiums are set as deposits (social insurance) in the credit item, income tax is set as deposits (income tax) in the credit item, and net pay is set as bank transfer amount in the credit item.

[0031] Work performance data can register arrival, departure, and travel times for multiple work locations, and may include employee code, work date, work location 1 (time), arrival time 1 (time), departure time 1 (time), working hours at work location 1 (time), travel time at work location 1 (time), work location 2 (time), arrival time 2 (time), departure time 2 (time), working hours at work location 2 (time), travel time at work location 2 (time), work location 3 (time), arrival time 3 (time), departure time 3 (time), working hours at work location 3 (time), travel time at work location 3 (time), etc. Work locations are checked for their work performance registration status on a daily basis, in the order of 1st to 3rd time. If the 1st time is not registered, it is registered in the order of 1st time, if the 1st time is registered, it is registered in the order of 2nd time, and if the 2nd time is registered, it is registered in the order of 3rd time.

[0032] The control unit 102 is a CPU or the like that performs overall control of the labor cost management system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0033] The control unit 102 is configured to be able to access the department master 106a, employee master 106b, journal entry collaboration setting master 106c, journal entry definition master 106d, work performance data, payroll calculation result data, and department-specific payroll journal data, etc., stored in the memory unit 106. Note that the department master 106a, employee master 106b, journal entry collaboration setting master 106c, journal entry definition master 106d, work performance data, and department-specific payroll journal data, etc., may be stored in another location (for example, server 200) as long as the control unit 102 is able to access them.

[0034] The control unit 102 conceptually includes a time stamp unit 102a, a travel time registration unit 102b, a labor cost processing unit 102c, a screen display control unit 102d, and a master maintenance unit 102e.

[0035] The screen display control unit 102d provides a time-stamping screen in response to access from the store terminals 400, etc., and controls its display and the acceptance of input. The screen display control unit 102d provides an individual work schedule screen in response to access from the employee terminals 500, etc., and controls its display and the acceptance of input. The screen display control unit 102d also controls the display and input of various screens (e.g., master maintenance screen, journal entry collaboration employee allocation registration screen, etc.) displayed on the monitor 114.

[0036] The time-stamping unit 102a registers and updates the employee, work date, and arrival and departure times for the store in the work performance data stored in the memory unit 106 in response to the time-stamping operation (clock-in button, clock-out button) of the employee on the time-stamping screen of the store terminal 400 of the store.

[0037] The travel time registration unit 102b registers and updates travel time in the work performance data stored in the storage unit 106 in response to an employee's input operation on the individual work schedule screen on the employee terminal 500. Note that it may also be possible to register travel time in the work performance data on the individual work schedule screen from the store terminal 400.

[0038] The labor cost processing unit 102c refers to the work performance data, totals the working hours, including travel time between stores, for each employee for the target year and month, and calculates the allocation rate of working hours for each store.

[0039] The labor cost processing unit 102c may create employee-specific allocation result data including employee code, department, salary item, and allocated amount based on the payroll calculation result data and the allocation rate of working hours for each store in accordance with the accounting linkage setting master 106c.

[0040] The personnel expense processing unit 102c may create department-specific item-specific journalization linked data including department, salary item, and allocated amount based on the employee-specific allocation result data.

[0041] The personnel expense processing unit 102c may create salary journal data by department for each department based on the journal linkage data by department and item in accordance with the journal definition master, and register the data in the storage unit 206.

[0042] The master maintenance unit 102e performs settings such as inputting, adding, deleting, and editing data for the department master 106a and the employee master 106b in response to an operator's operation on a master maintenance screen displayed on the monitor 114, for example.

[0043] [3. Specific Examples] Specific examples of processing by the control unit of labor cost management system 100 in this embodiment will be described with reference to Figures 1 to 16. An outline of the overall processing by the control unit of labor cost management system 100 in this embodiment will be described with reference to Figure 4. Figure 6 is a diagram showing a flow for explaining an outline of the overall processing by the control unit of labor cost management system 100 in this embodiment.

[0044] (3-1. Overall processing) 6, the time-stamping unit 102a executes the time-stamping process (step S1). Specifically, in the time-stamping process, the time-stamping unit 102a registers and updates the employee, work date, and the store's arrival time and departure time in the work performance data stored in the memory unit 106 in response to the time-stamping operation (clock-in button, clock-out button) of the employee on the time-stamping screen of the store terminal 400.

[0045] The travel time registration unit 102b executes a travel time registration process (step S2). Specifically, in the travel time registration process, the travel time registration unit 102b registers and updates the travel time of the work performance data stored in the memory unit 106 in response to an input operation by the employee on the individual work schedule screen of the employee terminal 500.

[0046] The labor cost processing unit 102c executes labor cost processing (step S3). Specifically, in labor cost processing, the labor cost processing unit 102c refers to the work performance data, aggregates the working hours, including travel time between stores, for each employee for the target year and month, and calculates the allocation rate of the working hours for each store.

[0047] In addition, the labor cost processing unit 102c may create employee-specific allocation result data including employee code, affiliation, salary item, and allocated amount based on the payroll calculation result data and the allocation rate of working hours for each store in accordance with the accounting linkage setting master 106c.

[0048] Furthermore, the personnel expense processing unit 102c may create department-specific item-specific journalization linked data including department, salary item, and allocated amount based on the employee-specific allocation result data.

[0049] Furthermore, the personnel expense processing unit 102c may create department-specific salary journal data for each department based on the department-specific item-specific journal linkage data in accordance with the journal definition master.

[0050] (3-2. Sample data) 7 to 16 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the labor cost management system 100 in this embodiment. A specific example of the processing by the control unit 102 of the labor cost management system 100 in this embodiment will be explained with reference to FIGS. 7 to 16.

[0051] 1. The process of calculating working hours for each individual and each store will be explained with reference to Figures 7 to 12. Here, we will explain the case where employee A05 works at Yukuhashi IC and then goes to Kokura IC to support other employees.

[0052] (S1: Stamping process) Employee A05 clocks in at Yukuhashi IC and clocks in on store terminal 400. Figure 7 is a diagram showing an example of a clock-in screen 600. The clock-in screen 600 includes an area 601 that displays the clock-in time, an area 602 for entering employee information, an area 603 that displays contact information including arrival and departure times, and an area 604 that displays a clock-in button and a clock-out button.

[0053] Figure 7(A) shows an example where employee code "A005" and employee name "Employee A05" pressed the clock-in button at 6:57:46 on Thursday, January 12th. Figure 7(B) shows an example where employee code "A005" and employee name "Employee A05" pressed the clock-out button at 11:02:23 on Thursday, January 12th. Pressing the clock-in button or clock-out button updates the work performance data.

[0054] Figure 8(A) is a diagram showing an example of the work location setting screen. On each terminal located in the store, the store corresponding to the work location is registered in advance on the work location setting screen and saved in the browser's cookie. Thereafter, when clocking in, the work location in the work performance data is updated based on the location information saved in the cookie. In the example shown in Figure 8(A), Z00: West Japan - Z00: Fukuoka Area - Z02: Yukuhashi IC are registered. If the cookie has been deleted, when the clocking in screen is opened, the screen will automatically transition to that screen and the work location will be set again.

[0055] Figure 8(B) shows an example of work performance data. The work performance data includes fields such as employee code, work date, work location 1 (time), arrival time 1 (time), departure time 1 (time), working hours at work location 1 (time), travel time to work location 1 (time), work location 2 (time), arrival time 2 (time), departure time 2 (time), working hours at work location 2 (time), travel time to work location 2 (time), work location 3 (time), arrival time 3 (time), departure time 3 (time), working hours at work location 3 (time), and travel time to work location 3 (time). The work location is checked for the first to third work records on a daily basis. If the first work record is not registered, it is registered as the first work record. If the first work record is registered, it is registered as the second work record. If the second work record is registered, it is registered as the third work record. By clocking in at the store where the employee worked, the working hours for each work location are automatically calculated. The work location is determined from the terminal settings of the store where the employee clocked in.

[0056] In this example, when the time stamps shown in Figure 7(A) and (B) are made, as shown in the fourth line, the first time has not been entered, so it is registered as the first time, and the work performance data is updated to employee code "A005," work date "2023 / 01 / 12," work location "Z00-Z00-Z02," time at work 1 "07:00," time at work 1 "11:00," and work time at work location 1 "4 hours." The work hours "4 hours" are calculated automatically.

[0057] After leaving work at Yukuhashi IC, employee A05 moves to Kokura IC and clocks in at the store terminal 400 at Kokura IC. Figure 9 shows an example of the display of the clock-in screen 600. Figure 9(A) shows an example where employee code "A005" and employee name "Employee A05" presses the clock-in button at 17:58:01 on Thursday, January 12th. Figure 9(B) shows an example where employee code "A005" and employee name "Employee A05" presses the clock-out button at 22:01:15 on Thursday, January 12th.

[0058] Figure 10 shows the work performance data that is updated when the time stamps shown in Figures 9(A) and (B) are made. In this case, since the first shift has already been registered, the second shift is reflected, and as shown in the fourth line, the data is updated to work location 2 "Z00-Z00-Z01," arrival time 2 "18:00," departure time 2 "22:00," and work time for work location 2 "4 hours." The work time "4 hours" is calculated automatically.

[0059] (S2: Travel time registration process) Employee A05 accesses the individual work schedule screen from his / her employee terminal 500 and registers travel time. The travel time to which store and how many hours to allocate is manually entered from the individual work schedule. In this example, a travel time of 1 hour is entered for work location 2 to cover the cost of the support destination, Kokura IC.

[0060] FIG. 11 shows an example of an individual work schedule. The individual work schedule has a header area for entering the employee code and base date, and an area that displays the work schedule that reflects the actual work data for the specified employee code. Enter the travel time for the base date specified in the work schedule. When the travel time is entered, the actual work data is updated. In the example shown in the figure, travel time 2 "1 hr" is registered on 01 / 28.

[0061] Figure 12 shows the work performance data that is updated when travel time is entered in Figure 11. As shown in the fourth line, travel time 2 on 1 / 28 has been updated to "1 hour."

[0062] 2. The process of aggregating working hours, including travel time, for each employee and each store will be explained with reference to Figures 13 to 16. Employee A05 will be explained below. Here, the explanation will be given using data examples from the journal entry linkage setting master 106c in Figure 4 and the journal entry definition master 106d in Figure 5.

[0063] (S3: Labor cost registration processing) (1) Divide and aggregate the work performance data by work location 1 to 3. First, as shown in Figure 13(A), work hours (including travel time) for work location 1 are calculated, including travel time for work location 1. Then, as shown in Figure 13(B), work hours (including travel time) for work location 2 are calculated, including travel time for work location 2. There is no work at work location 3, so there is no need to tally it up. Next, as shown in Figures 13(C) and (D), work hours (including travel time) are tallied for each of work locations 1 to 3.

[0064] (2) The work performance summary data (locations 1 to 3) is summed (UNION-ALL) and then further summarized by location. As shown in Figure 13(E), all work locations 1 to 3 are aggregated, and as shown in Figure 13(F), location-specific work performance summary data is generated by aggregating work hours (including travel time) for each work location. The location-specific work performance summary data includes the following fields: employee code, work location, and work hours (including travel time) by work location. In this example, for employee A005, the work location work hours (including travel time) for work location "Z00-Z00-Z02" are "26 hours," and the work location work hours (including travel time) for work location "Z00-Z00-Z01" are "5 hours."

[0065] The accounting staff performs operations on the journal entry collaboration employee allocation registration screen 700. FIG. 14 shows an example of the journal entry collaboration employee allocation registration screen 700. The journal entry collaboration employee allocation registration screen includes a field for specifying the employee code, a button for selecting type (salary or bonus), and a display area displaying the allocation affiliation (work location) and allocation rate (work location work hours (including travel time) converted to minutes). When the employee code is specified, the calculated location-specific work performance summary data is imported (CSV import) into the allocation rate registration screen and displayed. The "allocation rate" can be registered in any unit (in this case, the summary time converted to "minutes"), and can be registered without the need to make the total 100%. The total is calculated from the registered number of hours, and the percentage is automatically calculated. When the execute button (not shown) is pressed, journal entry collaboration data including the employee code, type (salary or bonus), allocation affiliation (work location), and allocation rate (work location work hours (including travel time) converted to minutes) is generated, and the following processing is performed.

[0066] When the journal linkage data is generated, employee-specific allocation result data is created based on the payroll calculation result data, the allocation rate of the journal linkage data, and the journal linkage setting master 106c.

[0067] Figure 15(A) shows an example of payroll calculation result data. The payroll calculation result data is calculated based on basic salary and actual work data, and is registered in the memory unit 206. The payroll calculation result data includes the following items: target year and month, employee code, department, basic salary, overtime pay, social insurance premiums, and income tax. In this example, for the target year and month "2023 / 02" and employee code "A005," the results are basic salary "100,000," overtime pay "0," social insurance premiums "27,000," and income tax "720."

[0068] By referring to the journal entry linkage setting master 106c, employee-specific allocation result data such as that shown in Figure 15(B) is generated based on the allocation rate between the payroll calculation result data and the journal entry linkage data. Specifically, based on the basic salary calculation data, data on items that are subject to journal entry linkage in the journal entry linkage setting master 106c is created, and allocation processing is performed for items that are subject to allocation. In the example of the journal entry linkage setting master 106c shown in Figure 4, basic salary, overtime pay, social insurance premiums, income tax, and net payment amount are subject to journal entry linkage and allocation.

[0069] The employee-specific allocation result data includes the following fields: employee code, department, item name (basic salary, overtime pay, social insurance premiums, income tax, net payment amount), and amount. In the allocation process, allocation is made to each department according to the allocation rate setting, with fractions of less than one yen being allocated to the department with the larger allocation rate. For example, for a basic salary of 100,000, 100,000 x (1560 / (1560+300)) = 83,871 will be allocated to department Z00-Z00-Z02, and 100,000 x (300 / (1560+300)) = 16,129 will be allocated to department Z00-Z00-Z01.

[0070] Based on the employee-specific allocation result data, department-specific item-specific journal entry linked data is generated as shown in Figure 16(A). The department-specific item-specific journal entry linked data has fields for department, item name, and amount. Based on the department-specific item-specific journal entry linked data, department-specific salary journal entry data is created by referencing the journal entry definition master 106d. Specifically, in accordance with the journal entry definition master 106d in Figure 5, basic salary and overtime pay are treated as salary allowances on the debit side, social insurance premiums are treated as deposits (social insurance) on the credit side, income tax is treated as deposits (income tax) on the credit side, and the net payment amount is treated as the bank transfer amount on the credit side. FIG. 16(B) is a diagram showing an example of salary journal data by department for department "Z00-Z00-Z02", and FIG. 16(C) is a diagram showing an example of salary journal data by department for department "Z00-Z00-Z01".

[0071] As explained above, the system is equipped with a time-stamping unit 102a that registers the employee, work date, and arrival and departure times at the store in the work performance data in response to the time-stamping operation on the store terminal, a travel time registration unit 102b that registers the travel time at each store in the work performance data for each employee, and a labor cost processing unit 102c that refers to the work performance data, tallies the work hours including travel time at each store for each employee for the target year and month, and calculates the allocation rate of work hours at each store, making it possible to manage labor costs in detail when an employee works at the same store multiple times in a day or when an employee works at multiple stores.

[0072] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0073] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0074] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0075] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0076] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0077] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0078] Furthermore, with regard to the labor cost management system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0079] For example, all or any part of the processing functions of the labor cost management system 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the labor cost management system 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM and works with the CPU to form the control unit.

[0080] In addition, this computer program may be stored in an application program server connected to the labor cost management system 100 via any network, and all or part of it may be downloaded as needed.

[0081] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0082] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0083] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0084] The labor cost management system 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The labor cost management system 100 may also be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.

[0085] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0086] 100 Labor Cost Management System 102 Control section 102a Stamping section 102b Travel time registration unit 102c Labor Cost Processing Department 102d Screen display control unit 102e Master Maintenance Department 104 Communication interface unit 106 Storage section 106a Affiliated Master 106b Employee Master 106c Journal Entry Linkage Setting Master 106d Journal entry definition master 108 Input / Output Interface Section 112 Input Device 114 Output Device 300 Network 400 store terminals 500 employee terminals

Claims

1. A labor cost management system that includes a control unit and manages labor costs for employees at each store, The control unit The system is configured to be able to access a storage area that stores work performance data including employees, work days, arrival times at each store, departure times, and travel times, a time-stamping means for registering the employee, work date, and arrival and departure times at the store in the work performance data in response to a time-stamping operation on a terminal at the store; a travel time registration means for registering travel time at each store in the work performance data for each employee; A labor cost processing means for referencing the work performance data, aggregating the working hours, including travel time between stores, for each employee for the target year and month, and calculating the allocation rate of working hours for each store in any unit of time by dividing the total working hours at that store by the total working hours at all stores; A labor cost management system comprising:

2. The storage area includes: Payroll calculation results data including target year and month, employee, department, basic salary, overtime pay, social insurance premiums, and income tax, A journal entry linkage master that registers whether each pay item is subject to journal entry linkage and whether it is subject to allocation; is stored, The labor cost management system described in claim 1, characterized in that the labor cost processing means creates employee-specific allocation result data including employee, affiliation, salary item, and amount based on the payroll calculation result data and the allocation rate of working hours for each store in accordance with the accounting linkage master.

3. The personnel expense management system according to claim 2, characterized in that the personnel expense processing means creates department-specific item-specific journal entry linked data including department, salary item, and amount based on the employee-specific allocation result data.

4. The storage area includes: For each payroll item, a journal entry definition master that specifies the debit or credit item is stored. The personnel expense management system according to claim 3, characterized in that the personnel expense processing means creates department-specific salary journal data for each department in accordance with the journal definition master based on the department-specific item journal linkage data.

5. A labor cost management method executed by an information processing device having a control unit, The control unit The system is configured to be able to access a storage area that stores work performance data including employees, work days, arrival times at each store, departure times, and travel times, Executed in the control unit: a time-stamping step of registering the employee, work date, and arrival and departure times at the store in the work performance data in response to a time-stamping operation on a terminal at the store; a travel time registration step of registering travel time at each store in the work performance data for each employee; a labor cost processing step of referencing the work performance data, aggregating the working hours, including travel time between stores, for each employee for the target year and month, and calculating the allocation rate of working hours for each store in any unit of time by dividing the total working hours at that store by the total working hours at all stores; A labor cost management method comprising:

6. A labor cost management program to be executed by an information processing device having a control unit, The control unit The system is configured to be able to access a storage area that stores work performance data including employees, work days, arrival times at each store, departure times, and travel times, The control unit a time-stamping step of registering the employee, work date, and arrival and departure times at the store in the work performance data in response to a time-stamping operation on a terminal at the store; a travel time registration step of registering travel time at each store in the work performance data for each employee; a labor cost processing step of referencing the work performance data, aggregating the working hours, including travel time between stores, for each employee for the target year and month, and calculating the allocation rate of working hours for each store in any unit of time by dividing the total working hours at that store by the total working hours at all stores; A labor cost management program to implement the following.

Images