JP2019168979A - Journalizing data creation device, journalizing data creation method and journalizing data creation program - Google Patents

Abstract

To provide a journalizing data creation device, a journalizing data creation method and a journalizing data creation program capable of creating journalizing data containing a calculated employment cost, by calculating the employment cost corresponding to each task in which an employee is engaged, by using proportional rate calculated by using work history of the employee.SOLUTION: According to an embodiment, a storage part stores work history of an employee and a section name of the employee, and a matter CD and a journalization pattern CD while associated, and (1) proportional rate corresponding to a period where the employee is engaged in a task is calculated based on the work history in the storage part, and (2) journalizing data, containing salary amount relating to the employee, proportional division amount provided by proportionally dividing the salary amount based on the proportional rate calculated in the (1), the section name and the matter CD in the storage part, and account title specified by the journalization pattern CD in the storage part associated to the matter CD and the section name, is created.SELECTED DRAWING: Figure 5

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 labor cost simulation system, a labor cost simulation method, and a labor cost simulation program for efficiently predicting labor costs (see paragraph 0006 of Patent Literature 1).

Japanese Patent No. 5917785

  Thus, in the field of managing personnel expenses, for example, when an employee has multiple duties, when paying salary to the employee, the number of working days of the employee for each of the plural duties is determined. It is necessary to create journal data including labor costs corresponding to each of the plurality of operations by calculating a proration rate and apportioning the salary amount for the employee using the apportionment rate.

  However, conventionally, since the number of working days is managed by, for example, a daily report that employees enter daily, there is a problem in that it takes time to input and it is difficult to master the operation.

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

  The present invention has been made in view of the above problems, and calculates a personnel cost corresponding to each of the operations that the employee engages using a proration rate calculated using the employee's work history, and calculates the calculated personnel 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 that can create journal data including expenses.

  In order to solve the above-described problems and achieve the object, a journal data creation device according to the present invention is a journal data creation device including a control unit and a storage unit, and the storage unit stores employee work history and The business identification data for identifying the business of the employee and the account identification data for identifying the account corresponding to the business in journal data based on the business history are stored in association with each other, and A control unit that calculates a proration rate corresponding to a period of engagement in the business based on a business history in the storage unit; a salary amount relating to the employee; and a salary amount for the apportionment rate calculating unit The apportioned amount determined based on the apportionment rate calculated in step 4, the business identification data in the storage unit, and the account identified by the account identification data in the storage unit associated with the business identification data Eyes, that and a journal data creation means for creating a journal data including, characterized.

  Further, in the journal data creating apparatus according to the present invention, the work history is a work period for each of the plurality of works when the employee is engaged in a plurality of works, and the apportioning rate calculating means Is characterized by calculating the proration rate corresponding to each of the plurality of business operations by multiplying the value obtained by dividing the business operation period by the total of the business operation periods by 100.

  The journal data creating apparatus according to the present invention is characterized in that the business history is the number of working days for the business, which is calculated based on an announcement date for the business.

  The journal data creation method according to the present invention is a journal data creation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit stores an employee's business history and the employee's business. Business identification data for identification is stored in association with account identification data for identifying the account corresponding to the business in the journal data based on the business history, and is executed by the control unit. A distribution ratio calculating step for calculating a distribution ratio corresponding to a period of engagement in the business based on a business history in the storage unit; a salary amount for the employee; and a salary amount for the employee calculated in the distribution ratio calculation step The apportioned amount determined based on the apportionment rate, the business identification data in the storage unit, and the account identification data in the storage unit associated with the business identification data It includes a journal data creation step of creating a journal data including a constant course, and the features a.

  The journal data creation program according to the present invention is a journal data creation program for causing an information processing apparatus including a control unit and a storage unit to execute the journal data creation program, and the storage unit stores an employee's business history and the employee's business Is stored in association with account identification data for identifying the account corresponding to the business in the journal data based on the business history, and is executed in the control unit. An apportioning rate calculating step for calculating an apportioning rate corresponding to a period of engaging in the job based on the work history in the storage unit, an amount of salary for the employee, and an apportioning rate calculating step The apportioning amount apportioned based on the apportionment ratio calculated in step 1, the business identification data in the storage unit, and the account in the storage unit associated with the business identification data It includes a journal data creation step of creating a journal data including the account specified by the identification data, characterized by.

  According to the present invention, it is possible to calculate the labor cost corresponding to each of the work that the employee is engaged using the apportionment rate calculated using the work history of the employee, and to create journal data including the calculated labor cost. Play.

FIG. 1 is a block diagram illustrating an example of a configuration of a journal data creation apparatus. FIG. 2 is a diagram illustrating an example of a processing flow according to the present embodiment. FIG. 3 is a diagram illustrating an example of specific contents in the main business information and the concurrent information. FIG. 4 is a diagram illustrating an example of a method of calculating a proration rate based on main business information and concurrent information. FIG. 5 is a diagram illustrating an example of journal data to be created.

  Hereinafter, embodiments of a journal data creation device, a journal data creation method, and a journal data creation program will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
In the construction industry, etc., when an employee is concurrently engaged in multiple projects, when paying salary to the employee, calculate a proration rate according to the number of days engaged in the multiple projects, and use the apportionment rate. By apportioning the salary amount for the employee, it is necessary to create journal data including personnel costs corresponding to each of the plurality of cases (labor costs for each case).

  However, conventionally, in order to calculate the labor cost corresponding to each of the plurality of cases, it is necessary to review daily report management and the apportionment rate, and specify an account item when creating journal data. In order to achieve this, there is a problem that it is necessary to judge each time whether a construction project corresponds to completed construction or incomplete construction.

  Conventionally, there has been a method of apportioning labor costs using fixed ratios and daily reports, but each has the following problems. In other words, when the fixed ratio is used, there is a problem that when the generation of labor costs fluctuates as in the construction industry, it deviates from the actual situation (actual labor costs). In addition, when using daily report results, it is necessary for the field worker to bear daily report input and apportionment calculation based on the daily report input, and there is a problem that operation mastery is difficult.

  Therefore, in the present embodiment, for example, a proration rate for each case can be automatically calculated from the personnel history of employees. Further, in the present embodiment, for example, by calculating the salary amount for each case by apportioning the salary amount for the employee using the apportionment ratio, on the other hand, by automatically determining the account item from the journal pattern code, The journal information according to the Item code can be created.

  Thus, by automatically calculating the apportion rate using personnel history data for project-specific balance management, in this embodiment, for example, without performing daily report management or complicated review of the apportion rate. Now, it is possible to calculate personnel costs by project. Further, in the present embodiment, for example, by storing the case code and the journal pattern code in association with the personnel history of the employee, information related to the balance of each case can be centrally managed by history management. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
An example of the configuration of the journal data creation apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram illustrating an example of the configuration of the journal data creation apparatus 100.

  The journal data creation device 100 is a commercially available desktop personal computer. The journal data creation apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but is a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. It may be a type information processing apparatus.

  The journal data creation apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the journal data creation apparatus 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the journal 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 other devices via a communication line. Here, the network 300 has a function of connecting the journal 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). Note that 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 unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described 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 giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

  The storage unit 106 includes, for example, main business information 106a, concurrent information 106b, apportion rate information 106c, and journal data 106d.

  In the following, the employee of the employee CD “1111” (hereinafter referred to as “Employee 1”) who is in charge of the work of the project “AAAAA” in the “Osaka Building Department Construction Section A Workplace” and “Osaka Building Department Construction” Employee CD “CCCCC” and “DDDDD”, which are the project CDs of “CCCCC” and “DDDDD” of “Osaka Architecture Dept. 2222 ”(hereinafter referred to as“ Employee 2 ”) and the employee of“ CD3333 ”who is responsible for the duties of“ Osaka Architecture Dept. Office G ”and who is also assigned to the“ Osaka Accounting Dept. ” “Employee 3”)), and the explanation will be taken as an example.

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

  The concurrent job information 106b is information related to the concurrent job of the employee, and is a history that occurs when the employee spans multiple projects (including the concurrent job of the administrative department). For this reason, the concurrent information 106b does not occur for employees who straddle multiple projects. Since the employee 1 has only the main duties and does not have the concurrent duties, only the employees 2 and 3 have the concurrent information 106b as shown in FIG. As shown in FIG. 3, the concurrent information 106b includes, for example, the employee identification data (employee CD), the business history (date of issue), the career classification, the business identification data (concurrent job affiliation name and project CD), the account Includes subject identification data (journal pattern CD) and remarks.

  The business history will be described. The business history is, for example, the number of working days for the business calculated based on the date of announcement for the business. Further, when the employee is engaged in a plurality of operations, the operation history is, for example, an operation period (the number of operations) for each of the operations. Taking employees 1 to 3 as an example, how to calculate the number of working days will be described.

  Explain how to calculate the number of working days for Employee 1. As shown in the main business information 106a of FIG. 3, the date of announcement regarding the work of the project CD “AAAAA” in “Osaka Architecture 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 1 to April 31 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 business information 106a of FIG. 3, the date of announcement regarding the work of the 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 1 to April 31, as shown in “period calculation image 2” in FIG. . In addition, as shown in the concurrent information 106b in FIG. 3, the date of announcement regarding the work of the project CD “CCCCC” in the “Osaka Building Department Construction Section C Workplace” is “2017/4/1”, and the date of release issuance Is "2017/4/16". In this case, the number of days during which the employee 2 is engaged in the work is “15 days” from April 1 to April 15 as shown in “period calculation image 2” in FIG. As shown in the concurrent information 106b of FIG. 3, the date of announcement regarding the work of the project CD “DDDDD” in the “Osaka Building Department Construction Section D Workplace” is “2017/4/16”. In this case, the number of days in April that the employee 2 is engaged in the work is “16 days” from April 16 to April 31, as shown in “period calculation image 2” in FIG.

  Explain how to calculate the number of working days for Employee 3. As shown in the main business information 106a of FIG. 3, the date of announcement regarding the work in “Osaka Architecture Department Office G” is “2017/4/1”. In this case, the number of days in April that the employee 3 is engaged in the work is “31 days” from April 1 to April 31, as shown in “period calculation image 3” in FIG. Further, as shown in the concurrent information 106b in FIG. 3, the announcement date for the business in the “Osaka Accounting Department” is “2017/4/1”. In this case, the number of days in April that the employee 3 is engaged in the work is “31 days” from April 1 to April 31, as shown in “period calculation image 3” in FIG.

  The business identification data will be described. The business identification data may be any data as long as it can identify the business that the employee is engaged in. For example, affiliation identification data for identifying the affiliation of the employee (main business affiliation name and concurrent affiliation name) ) And item identification data (item CD) for identifying the item in which the employee is engaged.

  The journal pattern CD will be described. As the journal pattern CD, for example, data for identifying the account item “indirect labor costs” (journal pattern CD: 1 in FIG. 3) and data for identifying the account item “incomplete construction expenditure” (FIG. 3). Journal pattern CD: 2) and data for identifying the account item “completed construction cost” (journal pattern CD: 3 in FIG. 3) and the like. When a certain project (construction) is completed, the journal pattern CD becomes 2 to 3. For example, in the concurrent information 106b in FIG. 3, for the construction specified in the project CD “CCCCC”, the release date is “2017/4/16”, so that the construction has already been completed. I understand. For this reason, the journal pattern CD for the case CD “CCCCC” is changed from 2 to 3 as shown in the concurrent information 106b of FIG. In other words, when the affiliation-related information is changed from an incomplete construction expenditure to a completed construction cost for the same project, the affiliation information is revised.

  The apportioning rate information 106c is information including an apportioning rate corresponding to a period in which employees have been engaged in the work. As shown in FIG. 4, the proration rate information 106c includes, for example, the employee identification data (employee CD), the total of the business history (number of denominator days), the business history (number of molecular days), the proration rate, and the business identification data. (Accounting department and project CD) and the account item identification data (journal pattern CD) and the like are included. The apportioning rate can be calculated based on the business history (details of the calculation method will be described in [3. Specific examples of processing] below).

  The journal data 106d is journal data including personnel expenses corresponding to each of the operations that the employee is engaged in. As shown in FIG. 5, the journal data 106d includes, for example, a credit item, a credit amount, a debit item, a debit department, a debit item CD, a debit amount, and the like. Details of the journal data 106d in FIG. 5 are described in [3. Specific Example of Processing] will be described as follows. That is, the journal data 106d in the upper part of FIG. 5 includes “200,000 yen” as the labor cost corresponding to the work specified by “Department: Osaka Architecture Department” and “Project CD: AAAA”. In addition, the journal data 106d in the middle of FIG. 5 includes “100,000 yen” as the labor cost corresponding to the work specified by “Department: Osaka Architecture Department” and “Project CD: BBBBB”. : "48,000 yen" is included as the labor cost corresponding to the work specified in "Osaka Architecture Department" and "Project CD: CCCCC", and is specified in "Department: Osaka Architecture Department" and "Project CD: DDDDD" "52,000 yen" is included as a labor cost corresponding to the business. The journal data 106d in the lower part of FIG. 5 includes “100,000 yen” as the labor cost corresponding to the work specified in “Department: Osaka Architectural Department”, and is specified in “Department: Osaka Accounting Department”. "100,000 yen" is included as the labor cost corresponding to the work to be done.

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

  The control unit 102 is functionally conceptually, for example, (1) an apportioning rate calculating unit 102a as an apportioning rate calculating unit that calculates an apportioning rate corresponding to a period of engaging in the operation based on the business history in the storage unit. And (2) the salary amount related to the employee, the apportioning amount obtained by apportioning the salary amount based on the apportioning rate calculated by the apportioning rate calculating means, the job identification data in the storage unit, and the job identification data A journal data creating unit 102b as journal data creating means for creating journal data including the account item identified by the account item identification data in the storage unit. The details of the processing executed by each unit are described in [3. Specific Example of Processing] will be described.

[3. Specific example of processing]
Hereinafter, specific examples of processing according to the present embodiment will be described in detail with reference to FIGS. As an overview of the processing according to the present embodiment, as shown in FIG. 2, first, as employee history data (main business information 106a and concurrent information 106b) [2. The contents described in [Configuration] are registered, and then allocation data is created by calculating a proration rate as will be described in detail in [3-1] below. Finally, the following [3- As described in detail in 2), journal data is created based on the created allocation data. As an overview of the method of calculating the proration rate, the project CD of the project that each employee is engaged in is determined from the main business information 106a and the concurrent information 106b that are managed by linking the project CD and journal pattern CD (cost category) to each employee. Get the history (announcement date) associated with, and calculate the number of molecular days. Then, using the number of molecular days, a proration rate is calculated for each case within the work period of one month. As an outline of creation of journal data, journal data is created from a distribution ratio (allocation rate) and a journal pattern CD (cost category) associated with each case.

  As a precondition, the specific contents of the main business information 106a and the concurrent information 106b are as shown in FIG. In addition, [2. As described in “Structure], the account item specified by the journal pattern CD1 is“ indirect labor costs ”, the account item specified by the journal pattern CD2 is“ incomplete construction expenditure ”, and the account item specified by the journal pattern CD3. Is the “completed construction cost”.

[3-1. Calculation of proration rate]
The apportionment rate calculation unit 102a calculates an apportionment rate corresponding to a period of engaging in business based on the business history (number of days of engagement) in the storage unit 106. In this item, the method of calculating the proration rate for employees 1 to 3 will be described as an example.

  As an outline of the processing in this item, the number of working days in the payroll calculation period (one month) is calculated from the main business information 106a and the concurrent information 106b, and the total number of the respective working days is used as the denominator. The distribution rate is calculated by using the number of days as a numerator, and further, the project CD and the journal pattern CD associated with the calculated distribution rate are specified.

(1) Calculation of proration rate for employee 1 [2. As described in [Configuration], the number of working days for the work of the project CD “AAAAA” in the “Osaka Architecture Department Construction Section A Workplace” where the employee 1 is engaged is “31 days”. Therefore, the proration rate calculating unit 102a calculates the proration rate for the work of the project CD “AAAAAA” in “Osaka Architecture Department Construction Section A Workplace” as 31 days ÷ 31 days × 100 = 100%. Then, apportioning rate information 106c (shown in the upper part of FIG. 4) including the calculated apportioning rate and information in the main business information 106a is created. The distribution rate information 106c is synonymous with the allocation data.

(2) Calculation of proration rate for employee 2 [2. As explained in “Composition”, the number of working days for the project CD “BBBBB” in the “Osaka Building Department Construction Section B Workplace” where employee 2 was engaged was “31 days”. The number of working days for the project CD “CCCCC” in the Osaka Architectural Department Construction Section C Workplace is “15 days”, and the project CD “DDDDD” in the “Osaka Architectural Department Construction Department D Workplace” where employee 2 was engaged. The number of working days for this business is “16 days”. As described above, when the employee is engaged in a plurality of tasks, the proration rate calculating unit 102a multiplies the value obtained by dividing the period for each task (the number of days for each task) by the total of the periods for each task. Thus, a proration rate corresponding to each of the plurality of operations is calculated.

  Specifically, the proration rate calculation unit 102a calculates the proration rate for the work of the project CD “BBBBB” in “Osaka Architecture Department Construction Section B Workplace” by 31 days ÷ (31 days + 15 days + 16 days) × 100 = 50 %, And the proration rate for the work of the project CD “CCCCC” in “Osaka Building Department Construction Section C Workplace” is calculated as 15 days ÷ (31 days + 15 days + 16 days) × 100≈24%. The proration rate for the project CD “DDDDD” in the “Building Department, Construction Section D Workplace” is calculated as 16 days ÷ (31 days + 15 days + 16 days) × 100≈26%. Then, apportioning rate information 106c (shown in the middle of FIG. 4) including the calculated apportioning rate and information in the main business information 106a and the concurrent information 106b is created.

(3) Calculation of proration rate for employee 3 [2. As explained in “Composition”, the number of working days for “Osaka Architecture Department Office G” engaged by employee 3 is “31 days”, and the number of working days for “Osaka Accounting Department” is “31 days”. Is. As described above, when the employee is engaged in a plurality of tasks, the proration rate calculating unit 102a multiplies the value obtained by dividing the period for each task (the number of days for each task) by the total of the periods for each task. Thus, a proration rate corresponding to each of the plurality of operations is calculated.

  Specifically, the proration rate calculation unit 102a calculates the proration rate for the work in “Osaka Architecture Department Office G” as 31 days ÷ (31 days + 31 days) × 100 = 50%, and in the “Osaka Accounting Department” The proration rate for the business is calculated as 31 days ÷ (31 days + 31 days) × 100 = 50%. Then, apportioning rate information 106c (shown in the lower part of FIG. 4) including the calculated apportioning rate and information in the main business information 106a and the concurrent information 106b is created.

[3-2. Create journal data]
The journal data creation unit 102b includes a salary amount relating to the employee, an apportioning amount obtained by apportioning the salary amount based on the apportioning rate calculated by the apportioning rate calculating unit 102a, job identification data in the storage unit 106, and the job identification data. Journal data 106d including the account item specified by the account item identification data (journal pattern CD) in the storage unit 106 associated with the item is created. In this item, a description will be given by taking an example of how to create journal data for employees 1 to 3. Note that the three distribution ratio information 106c shown on the left side of FIG. 5 is obtained by cutting out the denominator days and the numerator days in the distribution ratio information 106c created in [3-1].

  As an overview of the processing in this item, journal entries are generated from the apportionment ratio, the department in which it occurs, the project CD, and the journal pattern CD.

(1) Journal data for employee 1 The salary in April for employee 1 is 200,000 yen. In this case, if 200,000 yen is apportioned at the apportion rate of 100% calculated in (3-1) of (3-1), the apportionment amount for the project CD “AAAAA” in the “Osaka Architecture Department Construction Section A Workplace” 200,000 yen. Further, the business identification data for the employee 1 is the business affiliation name “Osaka Architecture Department” and the project CD “AAAAA” with reference to the business information 106a of FIG. The journal pattern CD in the storage unit 106 associated with the main business affiliation name “Osaka Architecture Department” and the project CD “AAAAA” is “2” when referring to the main business information 106a in FIG. The account item for the work specified in “Osaka Architecture Department” and Project CD “AAAAA” is “Unfinished Construction Expenditure”.

  As described above, the journal data creation unit 102b creates the journal data 106d in the upper part of FIG. The journal data includes the salary amount of 200,000 yen as a credit. Further, the journal data includes, as a debit, an appropriation amount of 200,000 yen, a head office affiliation name “Osaka Architecture Department” and a project CD “AAAAA”, and an account item “incomplete construction expenditure”.

(2) Journal data for employee 2 The salary in April for employee 2 is 200,000 yen. In this case, if 200,000 yen is apportioned at 50%, 24%, and 26% of the apportion rate calculated in (2) of [3-1], the project CD “BBBBB” in the “Osaka Architecture Department Construction Section B Workplace” The apportioned amount for the project is 100,000 yen, and the prorated amount for the work of the project CD “CCCCC” in the “Osaka Architecture Department Construction Section C Workplace” is 48,000 yen, and the project CD “ The prorated amount for “DDDDD” work is 52,000 yen. Further, the business identification data for the employee 2 is the business affiliation name “Osaka Architecture Department” and the project CD “BBBBB” when referring to the main business information 106a in FIG. 3, and referring to the concurrent information 106b in FIG. The name is “Osaka Architectural Department” and project CD “CCCCC”, and the concurrent name is “Osaka Architectural Department” and project CD “DDDDD”. The journal pattern CD in the storage unit 106 associated with the main business affiliation name “Osaka Architecture Department” and the project CD “BBBBB” is “2” when referring to the main business information 106a in FIG. The account item for the work specified in the “Osaka Architectural Department” and the project CD “BBBBB” will be “Unfinished Construction Expenditure”. Furthermore, since the journal pattern CD in the storage unit 106 associated with the concurrent office name “Osaka Architecture Department” and the project CD “CCCCC” is “3” with reference to the concurrent information 106b in FIG. The account item for the work specified in the “Osaka Architectural Department” and the project CD “CCCCC” is “Finished Construction Cost”. Further, since the journal pattern CD in the storage unit 106 associated with the concurrent affiliation name “Osaka Architecture Department” and the project CD “DDDDD” is “2” when referring to the concurrent information 106 b in FIG. 3, the concurrent affiliation name “ The account item for the work specified in the “Osaka Architectural Department” and the project CD “DDDDD” will be “Unfinished Construction Expenditure”.

  As described above, the journal data creation unit 102b creates the journal data 106d in the middle part of FIG. The journal data includes the salary amount of 200,000 yen as a credit. In addition, the first line of the debit of the journal data includes an appropriation amount of 100,000 yen, the name of the main office “Osaka Building Department” and the project CD “BBBBB”, and the account item “Unfinished Construction Expenditure”. Yes. The second line of the journal data debit contains an apportioned amount of 48,000 yen, the concurrent name “Osaka Building Department” and the project CD “CCCCC”, and the account item “Completed construction cost”. . In addition, the third line of the journal data debit includes an appropriation amount of 52,000 yen, a concurrent affiliation name “Osaka Architecture Department” and project CD “DDDDD”, and an account item “Unfinished Construction Expenditure”. .

(3) Journal data for employee 3 The salary in April for employee 3 is 200,000 yen. In this case, if 200,000 yen is apportioned at the apportionment rate 50% and 50% calculated in (3) of [3-1], the apportionment amount for the business in “Osaka Architecture Department Office G” will be 100,000 yen. The apportionment amount for the business in the department will also be 100,000 yen. Further, the business identification data for employee 3 is the affiliation name “Osaka Architectural Department Office G” when referring to the main business information 106a in FIG. 3, and the concurrent affairs name “Osaka Accounting” is referred to the concurrent information 106b in FIG. Part ". The journal pattern CD in the storage unit 106 associated with the main office affiliation name “Osaka Architecture Department Office G” is “1” when referring to the main office information 106a of FIG. The account item for the business specified by “G” is “indirect labor cost”. The journal pattern CD in the storage unit 106 associated with the concurrent job name “Osaka Accounting Department” is also “1” when referring to the concurrent job information 106b in FIG. The account item for the business to be performed is also “indirect labor costs”.

  As described above, the journal data creation unit 102b creates the journal data 106d in the lower part of FIG. The journal data includes the salary amount of 200,000 yen as a credit. In addition, the first line of the debit of the journal data includes an apportioned amount of 100,000 yen, the name of the head office affiliation “Osaka Building Department”, and the account item “indirect labor costs”. The second line of the debit of the journal data includes an appropriation amount of 100,000 yen, a concurrent affiliation name “Osaka Accounting Department”, and an account item “indirect labor costs”.

[3-3. Summary]
As described above in [3-1] and [3-2], according to the journal data creation device 100 according to the present embodiment, employees are engaged using the proration rate calculated using the employee's work history. Labor costs corresponding to each business to be performed can be calculated, and journal data including the calculated labor costs can be created.

[4. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments 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 performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

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

  Further, regarding the journal data creating apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the journal data creation apparatus 100, particularly the processing functions performed by the control unit, are realized by a CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and journal data is created as necessary. It is mechanically read by the device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the journal data creation apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. It is.

  In addition, a 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 “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit are storage means such as a memory device such as RAM and ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Stores programs, tables, databases, web page files, etc.

  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 an arbitrary peripheral device is connected. Further, the journal data creating apparatus 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the apparatus.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  The present invention is useful, for example, in an industry that performs balance management according to 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 rate calculation unit
102b Journal data creation unit 104 Communication interface unit 106 Storage unit
106a Main business information
106b Concurrent information
106c Proportion rate information
106d Journal data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A journal data creation device comprising a control unit and a storage unit,
In the storage unit,
Stores the business history of the employee, the business identification data for identifying the business of the employee, and the account identification data for identifying the account corresponding to the business in the journal data based on the business history. Has been
The controller is
An apportioning rate calculating means for calculating an apportioning rate corresponding to a period engaged in the operation based on a business history in the storage unit;
The salary amount related to the employee, the apportioning amount obtained by apportioning the salary amount based on the apportioning rate calculated by the apportioning rate calculating means, the business identification data in the storage unit, and the storage associated with the business identification data Journal data creating means for creating journal data including account items identified by account identification data in the department,
Providing
Journal data creation device characterized by The work history is a work period, which is an engagement period for each of the plurality of works when the employee is engaged in a plurality of works,
The apportioning rate calculating means includes
Calculating the proration rate corresponding to each of the plurality of tasks by multiplying the value obtained by dividing the period of each task by the total of the periods for each task by 100;
The journal data creating apparatus according to claim 1. The work history is the number of working days for the work calculated based on the date of announcement for the work;
The journal data creation device according to claim 1 or 2, characterized in that: A journal data creation method executed by an information processing apparatus including a control unit and a storage unit,
In the storage unit,
Stores the business history of the employee, the business identification data for identifying the business of the employee, and the account identification data for identifying the account corresponding to the business in the journal data based on the business history. Has been
Executed by the control unit,
An apportioning rate calculating step for calculating an apportioning rate corresponding to the period engaged in the operation based on the business history in the storage unit;
The salary amount related to the employee, the apportioning amount obtained by apportioning the salary amount based on the apportioning rate calculated in the apportioning rate calculating step, the business identification data in the storage unit, and the storage associated with the business identification data A journal data creation step for creating journal data including the account identified by the account identification data in the department,
Including,
Journal data creation method characterized by A journal data creation program for causing an information processing apparatus including a control unit and a storage unit to execute,
In the storage unit,
Stores the business history of the employee, the business identification data for identifying the business of the employee, and the account identification data for identifying the account corresponding to the business in the journal data based on the business history. Has been
For causing the control unit to execute,
An apportioning rate calculating step for calculating an apportioning rate corresponding to the period engaged in the operation based on the business history in the storage unit;
The salary amount related to the employee, the apportioning amount obtained by apportioning the salary amount based on the apportioning rate calculated in the apportioning rate calculating step, the business identification data in the storage unit, and the storage associated with the business identification data A journal data creation step for creating journal data including the account identified by the account identification data in the department,
Including,
Journal data creation program characterized by

Images