JP7240100B2 - Proportion calculation device, proportion calculation method, and proportion calculation program - Google Patents

Description

The present invention relates to a journal data creation device, a journal data creation method, and a journal data creation program.

Patent Document 1 discloses a personnel cost simulation system, a personnel cost simulation method, and a personnel cost simulation program for efficiently predicting personnel costs (see paragraph 0006 of Patent Document 1).

Japanese Patent No. 5917785

In this way, in the field of managing personnel expenses, for example, when an employee concurrently performs multiple tasks, when paying salaries to the employee, the number of days worked by the employee for each of the multiple tasks is calculated. It is necessary to create journal data including personnel expenses corresponding to each of the plurality of operations by calculating a proportional division ratio and proportionally dividing the salary amount for the employee using the proportional division ratio.

However, in the past, the number of working days was managed by, for example, a daily report input by the employee on a daily basis.

For this reason, for example, there has been a request to be able to calculate the proportional division ratio based on the employee's work history (for example, information on the date of issue of a certain work), but it has not been realized.

The present invention has been made in view of the above problems. It is an object of the present invention to provide a journal data creation device, a journal data creation method, and a journal data creation program capable of creating journal data including expenses.

In order to solve the above-mentioned problems and achieve the object, the journalizing data creation device according to the present invention is a journalizing data creation device comprising a control unit and a storage unit, wherein the storage unit stores the employee's work history and Business identification data for identifying the business of the employee and account identification data for identifying the account corresponding to the business in the journal data based on the business history are linked and stored, The control unit includes a proportional division ratio calculating means for calculating a proportional division ratio corresponding to the period of engaging in the work based on the work history in the storage unit, a salary amount for the employee, and the salary amount for the proportional division ratio calculating means. The apportioned amount proportionally divided based on the apportionment rate calculated in , the business identification data in the storage unit, and the account specified by the account identification data in the storage unit linked to the business identification data. and journal data creation means for creating journal data including.

Further, in the journal data creation device according to the present invention, the work history is a period for each work, which is a period of engagement for each of the plurality of jobs when the employee is engaged in a plurality of jobs, and the proportional division ratio calculation means is characterized by calculating the proportional division ratio corresponding to each of the plurality of tasks by multiplying a value obtained by dividing the period for each task by the total of the periods for each task by 100.

Further, the journalizing data creation device according to the present invention is characterized in that the work history is the number of days of work for the work calculated based on the date of issue of the work.

Further, a journal data creation method according to the present invention is a journal data creation method executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores the employee's work history and the employee's business. Business identification data for identification and account item identification data for identifying account items corresponding to the business in the journal data based on the business history are linked and stored, and are executed by the control unit. a proportional division ratio calculating step of calculating a proportional division ratio corresponding to the period of engaging in the work based on the work history stored in the storage unit; a journal including an apportioned amount proportionally distributed based on the apportionment ratio, the business identification data in the storage unit, and the account specified by the account identification data in the storage unit linked to the business identification data and a journal data creation step of creating data.

Further, a journal data creation program according to the present invention is a journal data creation program to be executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores an employee's work history and the employee's business and the account item identification data for identifying the account items corresponding to the business in the journal data based on the business history are linked and stored, and the control unit executes a proportional division ratio calculating step of calculating a proportional division ratio corresponding to the period of engaging in the work based on the work history stored in the storage unit; The apportioned amount proportionally divided based on the apportionment rate calculated in , the business identification data in the storage unit, and the account specified by the account identification data in the storage unit linked to the business identification data. and a journal data creation step of creating journal data including.

According to the present invention, it is possible to calculate the personnel expenses corresponding to each job that the employee is engaged in using the proportional division ratio calculated using the employee's work history, and create journal data including the calculated personnel expenses. Play.

FIG. 1 is a block diagram showing an example of the configuration of a journal data creation device. FIG. 2 is a diagram showing an example of the flow of processing according to this embodiment. FIG. 3 is a diagram showing an example of specific contents of main job information and concurrent job information. FIG. 4 is a diagram showing an example of how to calculate a proportional division ratio based on main job information and concurrent job information. FIG. 5 is a diagram showing an example of created journal data.

Embodiments of a journal data creation device, a journal data creation method, and a journal data creation program will be described in detail below with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. overview]
In the construction industry, etc., when an employee concurrently works on multiple projects, when paying salary to said employee, a proportional division rate is calculated according to the number of days engaged in said multiple projects, and this proportional division rate is used. It is necessary to create journal data including personnel expenses corresponding to each of the plurality of cases (personnel expenses for each case) by proportionally dividing the salary amounts for the employees.

However, conventionally, in order to calculate personnel expenses corresponding to each of the plurality of projects, it is necessary to manage daily reports and review the proportional division ratio. Therefore, there is a problem that it is necessary to determine whether a construction project corresponds to completed construction or unfinished construction each time.

Conventionally, there have been methods of proportionally dividing personnel expenses using fixed ratios and daily report results, but these methods have the following problems. In other words, when a fixed ratio is used, there is a problem that it deviates from the actual situation (actual labor cost) when the occurrence of labor cost fluctuates as in the construction industry. In addition, when using the actual daily report, it is necessary to make the site worker bear the burden of inputting the daily report and proportional division calculation based on the input of the daily report, and there is a problem that it is difficult to master the operation.

Therefore, in the present embodiment, for example, it is made possible to automatically calculate the proportional division ratio for each case from the personnel history of the employee. Further, in the present embodiment, for example, the personnel expenses for each case are calculated by proportionally dividing the salary amount for employees using the proportional division rate, and on the other hand, by automatically determining the account item from the journal pattern code, It is now possible to create journal information according to the item code.

In this way, by automatically calculating the proportional division ratio using personnel history data for income and expenditure management for each project, in the present embodiment, for example, daily report management and complicated review of the proportional division ratio are not performed. , it became possible to calculate personnel expenses by project. In addition, in the present embodiment, for example, by holding item codes and journalizing pattern codes in association with personnel careers of employees, it is possible to centrally manage information related to income and expenditure for each item through history management. Specific configurations and operations will be described below.

[2. composition]
An example of the configuration of the journalizing data creation device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the journal data creation device 100. As shown in FIG.

The journal data creation device 100 is a commercially available desktop personal computer. In addition, the journalizing data creation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but can be a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, a tablet personal computer, etc. type information processing device.

The journalizing data creation device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in the journalizing data creation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the journalizing data creation device 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 of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the journalizing data creation device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 includes, for example, main job information 106a, concurrent job information 106b, proportional division ratio information 106c, and journal data 106d.

In the following, an employee of employee CD "1111" (hereinafter referred to as "employee 1") whose main work is project CD "AAAAA" at "Osaka Construction Department Construction Section A Workplace" and "Osaka Construction Department Construction Employee CD " 2222” employee (hereinafter referred to as “Employee 2”), and an employee CD “3333” whose main job is “Osaka Construction Department Administrative G” and concurrently works at “Osaka Accounting Department” (hereinafter referred to as “Employee 2”). (referred to as "employee 3"), and , as an example, to proceed with the explanation.

The regular business information 106a is information related to the regular business of the employee, and is a history that always occurs for each employee. Employees 1 to 3 all have regular business information 106a, as shown in FIG. As shown in FIG. 3, the main job information 106a includes, for example, employee identification data (employee CD) for identifying an employee, employee's work history (issued date), career classification, work for identifying the work of the employee. It includes identification data (main job affiliation name and project CD), account item identification data (journal pattern CD) for identifying the account item corresponding to the business in the journal data 106d based on the work history, remarks, and the like.

The concurrent job information 106b is information about an employee's concurrent job, and is a history that occurs when an employee has multiple projects (including concurrent jobs in an administrative department). Therefore, the concurrent job information 106b is not generated for an employee who has multiple projects. Since employee 1 has only a main job and no concurrent jobs, only employees 2 and 3 have concurrent job information 106b, as shown in FIG. As shown in FIG. 3, the concurrent job information 106b includes, for example, the employee identification data (employee CD), the work history (issued date), the career classification, the work identification data (department name and project CD), the account Includes item identification data (journal pattern CD) and remarks.

The work history will be explained. The work history is, for example, the number of days engaged in the work calculated based on the date of issue of the work. Further, when the employee has engaged in a plurality of tasks, the work history is, for example, the period of each task (the number of days of work), which is the period of engagement (number of days of engagement) for each of the plurality of tasks. Taking employees 1 to 3 as an example, how to calculate the number of working days will be explained.

A method of calculating the number of working days for employee 1 will be explained. As shown in the main work information 106a in FIG. 3, the date of issue for the work of project CD "AAAA" in "Osaka Construction Department Construction Section A Workplace" is "2017/4/1". In this case, the number of working days in April when employee 1 is engaged in the work is "31 days" from April 1st to April 31st, as shown in "period calculation image 1" in FIG. .

Explain how to calculate the number of working days for employee 2. As shown in the main work information 106a of FIG. 3, the date of issue of the business of project CD "BBBBB" in "Osaka Building Department Construction Section B Workplace" is "2017/4/1". In this case, the number of working days in April when employee 2 is engaged in the work is "31 days" from April 1st to April 31st, as shown in "period calculation image 2" in FIG. . Also, as shown in the concurrent job information 106b in FIG. is "2017/4/16". In this case, the number of days in April that the employee 2 is engaged in the work is "15 days" from April 1st to April 15th, as shown in the "Period calculation image 2" in FIG. Then, as shown in the concurrent job information 106b in FIG. 3, the issue date for the work of the project CD "DDDDD" in "workplace D, construction department, construction section, Osaka" is "2017/4/16". In this case, the number of days in April during which the employee 2 is engaged in the work is "16 days" from April 16th to April 31st, as shown in the "Period calculation image 2" in FIG.

The method of calculating the number of working days for employee 3 will be explained. As shown in the main work information 106a of FIG. 3, the date of issue of the work in "Osaka Architectural Department Clerical G" is "2017/4/1". In this case, the number of days in April during which the employee 3 is engaged in the work is "31 days" from April 1st to April 31st, as shown in the "Period calculation image 3" in FIG. Further, as shown in the concurrent job information 106b in FIG. 3, the date of issue of the work in the "Osaka Accounting Department" is "2017/4/1". In this case, the number of days in April during which the employee 3 is engaged in the work is "31 days" from April 1st to April 31st, as shown in the "Period calculation image 3" in FIG.

The business identification data will be explained. The work identification data may be any data as long as it can identify the work that the employee is engaged in. ) and case identification data (case CD) for identifying the case in which the employee is engaged.

The journalizing pattern CD will be described. As the journal pattern CD, for example, data for identifying the account item "indirect labor cost" (journal pattern CD: 1 in FIG. 3), data for identifying the account item "incomplete construction expenditure" (FIG. 3 journal entry pattern CD: 2) and data for identifying the account item "completion work cost" (journal entry pattern CD: 3 in FIG. 3). When a certain project (construction work) is completed, the journal pattern CD will be from 2 to 3. For example, in the concurrent job information 106b in FIG. 3, the construction specified by the project CD "CCCCC" has already been completed because the cancellation date is "2017/4/16". I understand. Therefore, the journalizing pattern CD for the matter CD "CCCCC" is changed from 2 to 3, as shown in the concurrent job information 106b in FIG. In other words, when the affiliation incidental information is changed from unfinished construction expenditure to completed construction cost for the same project, the affiliation information is revised.

The proportional division ratio information 106c is information including the proportional division ratio corresponding to the period in which the employee engaged in the work. As shown in FIG. 4, the apportionment rate information 106c includes, for example, the employee identification data (employee CD), the total work history (denominator days), the work history (numerator days), the apportionment rate, and the work identification data (Occurring department and matter CD) and the account item identification data (journal pattern CD). The proportional division rate can be calculated based on the work history (details of the calculation method will be described in [3. Specific example of processing] below).

The journal data 106d is journal data including personnel expenses and the like corresponding to each work performed by an employee. The journal data 106d, as shown in FIG. 5, includes, for example, a credit item, a credit amount, a debit item, a debit department, a debit case CD, and a debit amount. Details of the journal data 106d in FIG. 5 are described in [3. Specific example of processing], but the outline is as follows. That is, the journal data 106d in the upper part of FIG. 5 includes "200,000 yen" as personnel expenses corresponding to the work identified by "Department: Osaka Construction Department" and "Project CD: AAAAA". In addition, the journal data 106d in the middle of FIG. 5 includes “100,000 yen” as personnel expenses corresponding to the work specified by “Department: Osaka Construction Department” and “Project CD: BBBBB”, and “Department : Osaka Construction Department" and "Project CD: CCCCC" include "48,000 yen" as personnel expenses corresponding to the work specified in "Department: Osaka Construction Department" and "Project CD: DDDDD". “52,000 yen” is included as personnel expenses corresponding to the work done by the company. In the journal data 106d in the lower part of FIG. 5, "100,000 yen" is included as the labor cost corresponding to the work specified by "Department: Osaka Construction Department", and is specified by "Department: Osaka Accounting Department". "100,000 yen" is included as personnel expenses corresponding to the work done.

The control unit 102 is a CPU or the like that controls the journal data creation device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally and conceptually includes, for example: (1) a proportional division ratio calculation unit 102a as a proportional division ratio calculation unit that calculates the proportional division ratio corresponding to the period of time engaged in the work based on the work history in the storage unit; and (2) a salary amount for said employee, a proportional division amount obtained by dividing said salary amount proportionally based on said proportional division ratio calculated by said proportional division ratio calculating means, task identification data in said storage unit, and said task identification data. and a journal data creation unit 102b as a journal data creation means for creating journal data including the account item specified by the account item identification data in the storage unit linked with. Details of the processing executed by each unit are described in [3. Specific example of processing].

[3. Specific example of processing]
A specific example of the processing according to the present embodiment will be described in detail below with reference to FIGS. 2 to 5. FIG. As an overview of the processing according to this embodiment, as shown in FIG. 2, first, [2. configuration], then create allocation data by calculating the proportional distribution ratio as described in detail in [3-1] below, and finally, in [3- 2], journal data is created based on the created allocation data. As an overview of how to calculate the apportionment ratio, the project CD of the project in which each employee is involved is obtained from the main job information 106a and secondary job information 106b, which are managed by linking the project CD and the journal pattern CD (cost category) to each employee. Acquire the history (issued date) associated with and calculate the number of days. Then, using the number of days in the numerator, the apportionment rate is calculated for each case within the working period of one month. As an overview of the creation of journal data, journal data is created from the proportional division rate (allocation rate) and journal pattern CD (cost division) associated with each case.

As a prerequisite, the specific contents of the main job information 106a and the concurrent job information 106b are as shown in FIG. Also, [2. Configuration], the account item specified by the journal pattern CD1 is "indirect personnel expenses", the account item specified by the journal pattern CD2 is "uncompleted construction expenditure", and the account item specified by the journal pattern CD3. is the “completed construction cost”.

[3-1. Proportion calculation]
The proportional division ratio calculation unit 102a calculates the proportional division ratio corresponding to the period of time engaged in work based on the work history (number of days worked) in the storage unit 106. FIG. In this item, the method of calculating the proportional division ratio for employees 1 to 3 will be described as an example.

As an overview of the processing in this item, the number of working days in the salary calculation period (one month) is calculated from the main work information 106a and the concurrent work information 106b, A proportional division ratio is calculated using the number of days as the numerator, and the matter CD and journal pattern CD associated with the calculated proportional division ratio are specified.

(1) Calculation of proportional division ratio for employee 1 [2. structure], the number of days engaged in work for project CD "AAAAA" in "Workplace A, Construction Department, Construction Section, Osaka" in which employee 1 was engaged is "31 days". Therefore, the apportionment rate calculation unit 102a calculates the apportionment rate for the work of project CD "AAAA" in "workplace A, construction department, construction section, Osaka" as follows: 31 days/31 days x 100 = 100%. Then, the proportional division ratio information 106c (shown in the upper part of FIG. 4) including the information in the calculated proportional division ratio and the main job information 106a is created. Note that the proportional division ratio information 106c is synonymous with allocation data.

(2) Calculation of proportional division ratio for employee 2 [2. structure], the number of days worked for the project CD "BBBBB" in "Osaka Construction Department Construction Section B Workplace" where employee 2 was engaged was "31 days", and employee 2 was engaged in " The number of working days for the project CD "CCCCC" at Osaka Construction Department Construction Section C Workplace is "15 days", and the project CD "DDDDD" at "Osaka Construction Department Construction Section D Workplace" where employee 2 was engaged. is "16 days". In this way, when an employee is engaged in a plurality of tasks, the proportional division ratio calculation unit 102a divides the period for each task (the number of days of work for each task) by the total of the periods for each task, and multiplies the value by 100. , the proportional division ratio corresponding to each of the plurality of tasks is calculated.

Specifically, the apportionment rate calculation unit 102a calculates the apportionment rate for the work of project CD "BBBBB" in "workshop B, construction department, construction department, Osaka" by 31 days/(31 days + 15 days + 16 days) x 100 = 50. 15 days ÷ (31 days + 15 days + 16 days) × 100 ≒ 24% The apportionment rate for project CD "DDDDD" in Construction Department Construction Section D Workplace" is calculated as follows: 16 days ÷ (31 days + 15 days + 16 days) x 100 ≈ 26%. Then, the proportional division ratio information 106c (shown in the middle of FIG. 4) including the calculated proportional division ratio and the information in the main job information 106a and the concurrent job information 106b is created.

(3) Calculation of proportional division ratio for employee 3 [2. Structure], the number of days worked for the work in "Osaka Construction Department Office G" in which employee 3 was engaged was "31 days", and the number of days worked for the work in "Osaka Accounting Department" was "31 days". ”. In this way, when an employee is engaged in a plurality of tasks, the proportional division ratio calculation unit 102a divides the period for each task (the number of days of work for each task) by the total of the periods for each task, and multiplies the value by 100. , the proportional division ratio corresponding to each of the plurality of tasks is calculated.

Specifically, the proportional division ratio calculation unit 102a calculates the proportional division ratio for the work in “Osaka Construction Department Office G” as 31 days ÷ (31 days + 31 days) × 100 = 50%, The apportionment rate for work is calculated as 31 days/(31 days + 31 days) x 100 = 50%. Then, the proportional division ratio information 106c (shown in the lower part of FIG. 4) including the calculated proportional division ratio and the information in the main job information 106a and the concurrent job information 106b is created.

[3-2. Create Journal Data]
The journal data creation unit 102b prepares the salary amount for the employee, the apportionment amount obtained by proportionally dividing the salary amount based on the apportionment ratio calculated by the apportionment ratio calculation unit 102a, the work identification data in the storage unit 106, and the work identification data. and the account item specified by the account item identification data (journal pattern CD) in the storage unit 106 associated with the journal data 106d. In this item, the method of creating journal data for employees 1 to 3 will be explained as an example. The three proportional division ratio information 106c shown on the left side of FIG. 5 are obtained by cutting out the denominator days and the numerator days in the proportional division ratio information 106c created in [3-1].

As an overview of the processing in this item, journal entries are generated from the apportionment rate, generating department, matter CD and journal entry pattern CD.

(1) Journal data for employee 1 Assume that the salary for employee 1 in April is 200,000 yen. In this case, if 200,000 yen is apportioned at the apportionment rate of 100% calculated in (1) of [3-1], the apportionment amount for the project CD "AAAA" in "Osaka Construction Department Construction Section A Workplace" will be: 200,000 yen. Further, the job identification data for the employee 1 is, referring to the main job information 106a in FIG. Then, the journal pattern CD in the storage unit 106 that is associated with the main job affiliation name "Osaka Construction Department" and the project CD "AAAAA" is "2" when referring to the main job information 106a of FIG. The account item for the work specified in "Osaka Construction Department" and project CD "AAAAA" is "expenditure on uncompleted construction".

As described above, the journal data creating unit 102b creates the journal data 106d shown in the upper part of FIG. The journal entry data includes the salary amount of 200,000 yen as a credit. The journal data also includes, as debits, the apportioned amount of 200,000 yen, the name of the main job affiliation "Osaka Architectural Department", the project CD "AAAA", and the account item "expenditure on uncompleted construction".

(2) Journal data for employee 2 Assume that the salary for employee 2 in April is 200,000 yen. In this case, if 200,000 yen is apportioned by the apportionment ratios of 50%, 24%, and 26% calculated in (2) of [3-1], the work of project CD "BBBBB" in "Osaka Construction Department Construction Section B Workplace" will be 100,000 yen, and the apportioned amount for the project CD "CCCCC" in "Osaka Construction Department Construction Section C Workplace" will be 48,000 yen, and the project CD " DDDDD”, the apportioned amount will be 52,000 yen. Further, the work identification data for employee 2 is, referring to the main work information 106a in FIG. The name is “Osaka Architectural Department” and the project CD is “CCCCC”, and the name of concurrent affiliation is “Osaka Architectural Department” and the project CD is “DDDDD”. Then, the journal pattern CD in the storage unit 106 associated with the main job affiliation name "Osaka Construction Department" and the project CD "BBBBB" is "2" when referring to the main job information 106a of FIG. The account item for the work specified in "Osaka Construction Department" and the project CD "BBBBB" is "Unfinished construction expenditure". Furthermore, the journal pattern CD in the storage unit 106 associated with the concurrent affiliation name “Osaka Construction Department” and the project CD “CCCCC” is “3” when referring to the concurrent affiliation information 106b in FIG. The account item for the work specified in "Osaka Construction Department" and project CD "CCCCC" is "Completed construction cost". Furthermore, the journal pattern CD in the storage unit 106 associated with the concurrent affiliation name “Osaka Construction Department” and the project CD “DDDDD” is “2” when referring to the concurrent affiliation information 106b in FIG. The account item for the work specified in "Osaka Construction Department" and the project CD "DDDDD" is "Expenditure on uncompleted construction work."

As described above, the journal data creating unit 102b creates the journal data 106d shown in the middle of FIG. The journal entry data includes the salary amount of 200,000 yen as a credit. In addition, the first line of the debit side of the journal entry data includes the apportioned amount of 100,000 yen, the main job affiliation name "Osaka Construction Department", the project CD "BBBBB", and the account item "Unfinished construction expenditure". there is The second line of the debit side of the journal entry data includes the apportioned amount of 48,000 yen, the name of concurrent affiliation "Osaka Architectural Department", the project CD "CCCCC", and the account item "Completed construction cost". . Furthermore, the third line of the debit side of the journal entry data includes the apportioned amount of 52,000 yen, the name of concurrent affiliation "Osaka Architectural Department", the project CD "DDDDD", and the account item "Unfinished construction expenditure". .

(3) Journal data for employee 3 Assume that the salary for employee 3 in April is 200,000 yen. In this case, if 200,000 yen is apportioned at the apportionment ratios of 50% and 50% calculated in (3) of [3-1], the apportionment amount for the work in "Osaka Construction Department Administration G" will be 100,000 yen, and "Osaka Accounting The apportioned amount for the work in the "Department" is also 100,000 yen. Further, the work identification data for employee 3 is the main work affiliation name “Osaka Construction Department Office G” when referring to the main work information 106a in FIG. Department. Then, the journalizing pattern CD in the storage unit 106 associated with the main job affiliation name "Osaka Construction Department Office G" is "1" when referring to the main job information 106a in FIG. The account item for the work specified by G” is “indirect personnel expenses”. Then, the journal pattern CD in the storage unit 106 that is associated with the concurrent affiliation name "Osaka Accounting Department" is also "1" when referring to the concurrent affiliation information 106b in FIG. The account item for the work performed will also be “indirect personnel costs”.

As described above, the journal data creating unit 102b creates the journal data 106d shown in the lower part of FIG. The journal entry data includes the salary amount of 200,000 yen as a credit. In addition, the first debit line of the journal entry data includes the apportioned amount of 100,000 yen, the name of the main job affiliation "Osaka Construction Department", and the account item "indirect personnel expenses". The second line of the debit side of the journal entry data includes the apportioned amount of 100,000 yen, the concurrent affiliation name "Osaka Accounting Department", and the account item "indirect personnel expenses".

[3-3. summary]
As described above in [3-1] and [3-2], according to the journalizing data creation device 100 according to the present embodiment, the employee is engaged using the proportional division ratio calculated using the employee's work history It is possible to calculate personnel expenses corresponding to each task to be performed, and create journal data including the calculated personnel expenses.

[4. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

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

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

Also, with respect to the journalizing data creation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided by the journal data creation device 100, especially the processing functions performed by the control unit, are implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. In addition, the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and journalizing data creation as necessary It is read mechanically by the device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the journal data creation apparatus 100 via any network, and it is possible to download all or part of it as necessary. is.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

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

The various databases stored in the storage 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. It stores programs, tables, databases, files for web pages, and so on.

Further, the journal data creation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the journal data creation device 100 may be implemented by installing software (including programs or data) that allows the device to implement the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in industries that manage income and expenditure by business, and is particularly useful in the construction industry, the IT media industry, and the like.

100 journal data creation device 102 control unit
102a proportional division ratio calculation unit
102b journal data creation unit 104 communication interface unit 106 storage unit
106a Business Information
106b Concurrent job information
106c Proportion ratio information
106d journal data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (3)

A proportional division ratio calculation device comprising a control unit and a storage unit,
The storage unit contains
Employee identification data for identifying an employee, affiliation identification data for identifying the affiliation of the employee, project identification data for identifying the project that the employee is engaged in, and the employee at the affiliation Personnel history data including an engagement start date, which is the date when the employee starts working on the project, and an engagement end date, which is the date when the employee finishes working on the project at the department, is stored,
The control unit
For each combination of the employee identification data, the department identification data and the project identification data in the personnel history data, from the engagement start date in the personnel history data to the last day of the month to which the engagement start date belongs or working days calculation means for calculating the number of days until the working end date in the history data as working days;
a proportional division ratio calculation means for calculating a proportional division ratio for each combination by multiplying a value obtained by dividing the number of days worked for each combination calculated by the number of days worked calculated by the number of days aggregated in units of the employee identification data by 100; ,
to provide
A proportional division ratio calculation device characterized by: A proportional division ratio calculation method executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Employee identification data for identifying an employee, affiliation identification data for identifying the affiliation of the employee, project identification data for identifying the project that the employee is engaged in, and the employee at the affiliation Personnel history data including an engagement start date, which is the date when the employee starts working on the project, and an engagement end date, which is the date when the employee finishes working on the project at the department, is stored,
executed by the control unit;
For each combination of the employee identification data, the department identification data and the project identification data in the personnel history data, from the engagement start date in the personnel history data to the last day of the month to which the engagement start date belongs or a work day calculation step for calculating the number of days until the work end date in the history data as work days;
a proportional division rate calculating step of calculating a proportional division rate for each combination by multiplying a value obtained by dividing the number of days worked for each combination calculated in the number of days worked calculated by the number of days aggregated in units of the employee identification data by 100; ,
including
A proportional division ratio calculation method characterized by A proportional division ratio calculation program to be executed by an information processing device having a control unit and a storage unit,
The storage unit contains
Employee identification data for identifying an employee, affiliation identification data for identifying the affiliation of the employee, project identification data for identifying the project that the employee is engaged in, and the employee at the affiliation Personnel history data including an engagement start date, which is the date when the employee starts working on the project, and an engagement end date, which is the date when the employee finishes working on the project at the department, is stored,
for causing the control unit to execute
For each combination of the employee identification data, the department identification data and the project identification data in the personnel history data, from the engagement start date in the personnel history data to the last day of the month to which the engagement start date belongs or a work day calculation step for calculating the number of days until the work end date in the history data as work days;
a proportional division rate calculating step of calculating a proportional division rate for each combination by multiplying a value obtained by dividing the number of days worked for each combination calculated in the number of days worked calculated by the number of days aggregated in units of the employee identification data by 100; ,
including
A proportional division ratio calculation program characterized by

Images