JP2018139053A - Amount data generation device, amount data generation method and amount data generation program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an amount data generation device, an amount data generation method and an amount data generation program which allow for simultaneous generation of sales data including a sales amount and billing data including a billed amount in spite of the occurrence of mismatch between a target period of sales amount calculation for each employee and a target period of billed amount calculation for the employee.SOLUTION: According to this embodiment, the amount data generation method comprises: a step (1) of acquiring a rule to be applied to a target employee, from a contract table; a step (2) of calculating a sales amount in a present month for the target employee on the basis of the number of labor hours of the target employee included in a result table, according to a reference amount included in the acquired rule and generating sales data including the calculated sales amount; and a step (3) of calculating a billed amount in the present month for the target employee on the basis of the number of labor hours of the target employee included in the result table, according to the reference amount, a billing closing date and a billing division and generating billing data including the calculated billed amount.SELECTED DRAWING: Figure 7

Description

  The present invention relates to an amount data creation device, an amount data creation method, and an amount data creation program.

  Patent Document 1 provides a comprehensive range of management up to salary calculation and billing operations, linked to the operation schedule of the security guards and the actual results, corresponding to billing processing, deposit processing, salary processing, and security guard management. A security control system is disclosed as a total system that can prepare various various forms to improve the management efficiency of the security industry and greatly reduce the security-specific business processing (see paragraph 0004, etc.).

JP 2002-123656 A

  In such a security industry, IT (Information Technology) dispatch industry, etc., for example, when company A dispatches an employee to company B, the target period of the sales amount calculation within company A for each dispatched employee, There may be a discrepancy between the dispatched employee and the target period for billing amount calculation for Company B.

  For example, the amount of sales in company A for August is calculated based on the number of working hours from August 1 to August 31, but the amount charged to Company B for August is 7 The shift is calculated based on the number of working hours from 1st to 31st of July (that is, billed in the next month).

  When such a deviation occurs, conventionally, for example, a method of manually calculating the amount charged to B company has been taken, but the workload is very large.

  The present invention has been made in view of the above, and even if there is a gap between the target period for calculating the sales amount of each employee and the target period for calculating the charge amount of each employee, the sales amount is A monetary data creating apparatus, monetary data creating method, and monetary data creating program capable of simultaneously creating sales data including billing data and billing data including a billing amount are provided.

  In order to solve the above-described problems and achieve the object, an amount data creation device according to the present invention is an amount data creation device including a control unit and a storage unit. A contract table containing a plurality of rules for calculating the billing amount and a performance table containing the number of working hours of employees are stored, and the rules include a base amount, a billing date, a billing for the current month and Claim classification meaning any one of claims for next month closing, and the control unit acquires the rule applied to the target employee from the contract table, and the acquisition means acquired by the acquisition means Based on the reference amount included in the rules, the sales amount of the target employee for the current month is calculated based on the number of working hours of the target employee included in the result table, and the sales data including the calculated sales amount is calculated. Based on the number of working hours of the target employee included in the result table, according to the sales data creation means for creating data, and the reference amount included in the rules acquired by the acquisition means, the claim closing date, and the claim classification, Charge data creation means for calculating a bill amount of the target employee for the current month and creating bill data including the calculated bill amount.

  The amount data creation method according to the present invention is a amount data creation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit calculates a sales amount and a billed amount for the current month. A contract table including a plurality of rules for the time of execution and an actual result table including the number of working hours of employees are stored. The rules include a reference amount, a billing date, a billing for the current month and a billing for the next month. Including the claim category meaning any one of the rules applied to the target employee and executed by the control unit from the contract table, and the rule acquired in the acquisition step. Based on the included reference amount, the sales amount of the target employee for the current month is calculated based on the number of working hours of the target employee included in the result table, and the sales amount including the calculated sales amount is calculated. Based on the number of working hours of the target employee included in the performance table, according to the sales data creation step of creating data, and the reference amount included in the rule acquired in the acquisition step, the claim closing date, and the charge classification, A billing data creation step of calculating a billing amount of the target employee for the current month and creating billing data including the calculated billing amount.

  An amount data creation program according to the present invention is an amount data creation program for causing an information processing apparatus including a control unit and a storage unit to execute, and the storage unit calculates a sales amount and an invoice amount for the current month. A contract table including a plurality of rules for performing a job and a performance table including the number of working hours of employees are stored. The rules include a base amount, a billing due date, a billing for the current month and a billing for the next month. Including the claim classification meaning any one of the above, the acquisition step for acquiring the rule applied to the target employee to be executed by the control unit from the contract table, and the acquisition acquired in the acquisition step In accordance with the standard amount included in the rules, the sales amount for the target employee for the current month is calculated based on the number of working hours of the target employee included in the actual result table. Sales data creation step for creating sales data including the sales amount issued, and according to the reference amount, billing due date and billing category included in the rule acquired in the acquisition step, A billing data creation step of calculating a billing amount of the target employee for the current month based on the number of working hours and creating billing data including the calculated billing amount.

  According to the present invention, even if there is a gap between the sales period calculation period of each employee and the charge period calculation period of each employee, the sales data including the sales amount and the charge including the charge amount are included. The effect is that data can be created simultaneously.

FIG. 1 is a block diagram illustrating an example of a configuration of a monetary amount data creation apparatus. FIG. 2 is a diagram illustrating an example of each data and each master. FIG. 3 is a diagram showing a plurality of rules for calculating the sales amount and the billing amount for the current month. FIG. 4 is a diagram showing the number of working hours of each employee from June 21 to July 20. FIG. 5 is a diagram showing the number of working hours of each employee from July 21 to August 31. FIG. 6 is a diagram showing the number of working hours of each employee from September 1st to September 30th. FIG. 7 is a diagram illustrating an example of a calculation formula for the sales amount of each employee and a calculation formula for the charge amount of each employee.

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

[1. Overview]
In industries where there is a transaction that makes a bill based on working hours by person (for example, the IT dispatch industry), the period of calculation may differ between “owner's sales recording” and “billing amount to customers”. Here, in the general sales management system, sales data and billing data are linked, so the bill of the billing amount is corrected manually or without using the system form. Billing data was created manually. However, if billing data is created manually, business mistakes and defects in the internal control flow occur, so there are many companies that use manual controls such as double checks.

  Here, the case where the calculation target periods are different will be described in detail. For example, in a closing payment with a business partner, the calculation target period of the billing amount is not set to 1 day to 31 days, but when the correct accounting process is performed, the calculation target period of the sales amount is 1 day to 31 days. It is necessary to. In particular, in the dispatching industry, there are cases where the billing is made in the current month or the next month, in item units (basic work time, overtime, etc.) in addition to the closing payment with the business partner.

In such a case, processing has conventionally been performed by any of the following methods (1) to (3). However, the actual processing is not correct.
(1) Divide everything in the human system.
(2) Invoices are created manually according to the target period of sales amount calculation (does not always match the collection schedule).
(3) From the viewpoint of subject importance, endure the calculation of the sales amount until the billing amount calculation target period, that is, wait.

  Therefore, in this embodiment, even if there is a gap between the sales period calculation period of each employee and the charge period calculation period of each employee, the sales data including the sales amount and the charge amount are included. It was possible to create billing data including it at the same time. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
A configuration of the money amount data creation device 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 money amount data creation device 100.

  The money amount data creation device 100 is a commercially available desktop personal computer. The amount data creation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a mobile device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smart phone, or tablet personal computer. It may be a type information processing apparatus.

  As shown in FIG. 1, the monetary amount 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 monetary amount data creation apparatus 100 is communicably connected via an arbitrary communication path.

  The communication interface unit 104 connects the monetary amount data creation device 100 to the network 300 through 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 amount 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 stored in the storage unit 106 to be described later may be stored in the server 200.

  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 a monitor 114 as a display unit, and the input device 112 may be described as a keyboard 112 or a 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 an employee master 106a, a contract table 106b, a daily report table 106c, a performance table 106d, a sales table 106e as sales data, and a billing table 106f as billing data. Among these, the employee master 106a and the daily report table 106c are arbitrary components, and may or may not be included in the storage unit 106.

  In the following explanation, when a certain company dispatches each employee to a dispatch destination company, the sales amount for each said employee within the certain company (in-house) is calculated. A situation is assumed in which the amount billed to the dispatched company for an employee is calculated. However, scenes to which the present invention can be applied are not limited to the scenes described above.

  As an outline of the processing according to the present embodiment, as shown in FIG. 2, first, an actual result table 106d is created based on a daily report table 106c associated with the employee master 106a. A sales table 106e and a billing table 106f are created based on the created actual result table 106d and the contract table 106b linked to the employee master 106a. Hereinafter, items included in each master and each data will be described.

  The employee master 106a includes items such as an employee code and an employee name.

  The contract table 106b includes a plurality of rules for calculating the sales amount and billing amount for the current month. A different rule is set for each employee code. The rule includes a reference amount, a billing deadline, and a billing category that represents one of a billing for the current month and a billing for the next month.

  The reference amount is an amount for a certain number of working hours. For example, if the salary payment form is payment based on a system engineering service contract, the unit price for the basic work time, the excess unit price per hour when the basic work time is exceeded, and the hourly rate when it falls below this The reduced unit price may be set separately. The reference amount for Mr. A in FIG. 3 is three: 500,000 yen (unit price for 150 to 170 hours of basic work time), 3,000 yen (excess unit price), and 3,000 yen (reduced unit price). . Alternatively, when the salary payment mode is payment based on the hourly wage system, the standard amount is 1,000 yen (hourly wage within a predetermined working time per day), 1,250 yen (as per Mr. C in FIG. 3) Two overtime hourly wages). The salary payment form is not limited to the payment based on the above-mentioned system engineering service contract or the payment based on the hourly rate system, and may be, for example, the payment based on the monthly salary system.

  The billing deadline is a deadline for calculating the amount. The closing date is not particularly limited, and examples thereof include closing on the last day, closing on the 10th, closing on the 15th, and closing on the 20th.

  The billing category is a category indicating whether the target period for calculating the amount is the current month or the next month. For example, when the billing amount for August is calculated with the closing date, if the billing category is “current month”, the working hours in the period from August 1 to August 31 are This is the target period for the billing amount calculation. On the other hand, when the billing category is “next month”, the number of working hours in the period from July 1 to July 31 becomes the target period for billing amount calculation for August (so-called Billed next month).

  Here, the sales amount of each employee for the current month is calculated based on only the reference amount among the three parameters of the reference amount, the billing due date, and the billing category. This is because the billing deadline is the last day for all employees and the billing category is the same month for all employees. For example, when calculating the sales amount for August of Mr. A to Mr. D, as shown in FIG. 5, for Mr. A to Mr. D, the billing due date of the sales amount is 31 days. It is August of the current month. On the other hand, the standard amount for each of Mr. A to Mr. D is different as shown in FIG.

  On the other hand, the billing amount of each employee for the current month is calculated based on a combination of three parameters: a reference amount, a billing due date, and a billing category. For example, when calculating the amount charged for Mr. C in August, if the base amount is 1,000 yen per hour, the billing deadline is 20 days, and the billing category is the current month, then Mr. C's August The amount charged for a minute can be calculated by multiplying 1,000 yen by the number of working hours between July 21 and August 20. As another example, if the base amount is 1,000 yen per hour, the last day of the billing is the last day, and the billing category is the current month, the billing amount for Mr. C in August is 1,000 yen, It can be calculated by multiplying the number of working hours between 1st month and 31st August. As yet another example, if the base amount is 1,000 yen per hour, the billing deadline is 20 days, and the billing category is the following month, It can be calculated by multiplying 000 yen by the number of working hours between June 21 and July 20.

  The daily report table 106c includes the number of working hours per day for each employee, and the actual result table 106d is created based on the daily report table 106c.

  The result table 106d includes the number of working hours of employees. The actual result table 106d may further include, for example, an employee CD, so that the actual result table 106d can include the number of working hours linked to each employee CD.

  The sales table 106e includes the sales amount of each employee for the current month. The billing table 106f includes the billing amount of each employee for the current month. For details on how to calculate the sales amount for each employee for this month and the amount charged for each employee for this month, see “3. Specific Example of Processing] will be described.

  The control unit 102 is a CPU or the like that controls the monetary amount data creation apparatus 100 in an integrated manner. 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. Run.

  The control unit 102 is functionally conceptually (1) an acquisition unit 102a as an acquisition unit that acquires the rule applied to the target employee from the contract table, and (2) the rule acquired by the acquisition unit. Sales data for calculating the sales amount of the target employee for the current month based on the number of working hours of the target employee included in the result table in accordance with the included reference amount, and creating sales data including the calculated sales amount Sales data creation unit 102b as creation means, and (3) the number of working hours of the target employee included in the performance table according to the reference amount, billing due date and billing classification included in the rule acquired by the acquisition means The billing data creation means as a billing data creation means for calculating the billing amount of the target employee for the current month based on the billing data and creating billing data including the calculated billing amount It includes a part 102c, a. 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, a specific example of the processing according to the present embodiment will be described mainly with reference to FIGS. In the present embodiment, a case will be described in which the sales amount and billing amount for August are calculated for each of four target employees, Mr. A to Mr. D.

[3-1. Acquisition process]
First, the acquisition process performed by the acquisition unit 102a will be described. The acquisition unit 102a acquires the rules applied to the target employee from the contract table 106b. Hereinafter, the rules applied to each of Mr. A to Mr. D will be described for each employee.

(1) Mr. A As shown in FIG. 3, as the rule applied to Mr. A, the acquisition unit 102a has (basic amount, billing deadline, billing category) = (unit price of basic work time 500,000 yen, last day) , Current month), (excess unit price and reduced unit price 3,000 yen, last day, current month).

(2) Mr. B As shown in FIG. 3, Mr. B obtains the rules applied to Mr. B as follows: (basic amount, billing deadline, billing category) = (unit price of basic work time 500,000 yen, last day) , Current month), (excess unit price and reduced unit price 3,000 yen, last day, next month).

(3) Mr. C The acquisition unit 102a has, as a rule applied to Mr. C, as shown in FIG. 3, (base amount, billing deadline, billing category) = (hourly wage 1,000 yen for a predetermined working time, 20 (Day, current month), (overtime hourly wage 1,250 yen, 20th, current month).

(4) Mr. D As shown in FIG. 3, as a rule applied to Mr. D, the acquisition unit 102 a has (basic amount, billing deadline, billing category) = (unit price of basic work time 500,000 yen, 20 (Day, current month), (excess unit price and reduced unit price 3,000 yen, 20th, next month).

[3-2. Sales data creation process]
Next, sales data creation processing performed by the sales data creation unit 102b will be described. The sales data creation unit 102b calculates the sales amount of the target employee for the current month based on the number of working hours of the target employee included in the result table 106d according to the reference amount included in the rule acquired by the acquisition unit 102a. Sales data (sales table 106e) including the sales amount is generated. Hereinafter, the sales amount for August of each of Mr. A to Mr. D will be explained for each employee.

(1) Mr. A The reference amount included in the rules acquired by the acquiring unit 102a for Mr. A is [3-1. ], The basic unit time 500,000 yen and the excess unit price and the reduced unit price 3,000 yen. The above [2. As described in the description of the contract table 106b in [Configuration], the billing deadline for calculating the sales amount for August is 31st for every employee (the last day is closed), and the billing category is for any employee. Since August is the current month, the sales time for August of Mr. A is 184 hours of sales time from August 1 to August 31, as shown in FIG. Accordingly, as shown in FIG. 7, Mr. A's sales amount for August is 500,000 yen (up to 170 hours of basic work time) +3,000 yen (excess unit price for excess 14 hours) × 14 hours = It can be calculated as 542,000 yen.

(2) Mr. B The reference amount included in the rule acquired by Mr. B for Mr. B is [3-1. ], The basic unit time 500,000 yen and the excess unit price and the reduced unit price 3,000 yen. As in (1) above, the billing deadline for calculating the sales amount for August is 31st (the last day), and the billing category is August (current month). As shown in FIG. 5, the sales time is 196 hours of sales time from August 1st to August 31st. Therefore, as shown in FIG. 7, Mr. B's sales amount for August is 500,000 yen (up to 170 hours of basic work time) +3,000 yen (excess unit price for excess 26 hours) × 26 hours = It can be calculated as 578,000 yen.

(3) Mr. C. The reference amount included in the rule acquired by Mr. C for Mr. C is [3-1. ], The hourly wage is 1,000 yen for the predetermined working hours and the hourly wage is 1,250 yen for the predetermined working hours. Similarly to (1) above, the billing deadline for calculating the sales amount for August is 31st (the last day), and the billing category is August (current month). For this reason, as shown in FIG. 5, the sales time within the predetermined working hours for August of Mr. C is 168 hours (8 hours × 21) of the sales time (normal) from August 1 to August 31. In addition, as shown in FIG. 5, the sales hours for Mr. C's overtime are 9 hours (1 hour × 9 days) of sales hours (overtime) from August 1st to August 31st. is there. Therefore, as shown in FIG. 7, the sales amount for August of Mr. C can be calculated as 1,000 yen × 168 hours + 1,250 yen × 9 hours = 179,250 yen.

(4) Mr. D. The reference amount included in the rule acquired by Mr. D for Mr. D is [3-1. ], The basic unit time 500,000 yen and the excess unit price and the reduced unit price 3,000 yen. Also, as in (1) above, when the sales amount for August is calculated, the billing deadline is 31st (the last day) and the billing category is August (current month). As shown in FIG. 5, the sales time is 175 hours of sales time from August 1st to August 31st. Therefore, as shown in FIG. 7, Mr. D's sales amount for August is 500,000 yen (up to 170 hours of basic work time) +3,000 yen (excess unit price for excess 5 hours) × 5 hours = It can be calculated as 515,000 yen.

[3-3. Billing data creation process]
Finally, billing data creation processing performed by the billing data creation unit 102c will be described. The billing data creation unit 102c bills the target employee for the current month based on the number of working hours of the target employee included in the result table 106d in accordance with the reference amount, billing due date, and billing category included in the rules acquired by the acquiring unit 102a. The amount is calculated, and billing data (billing table 106f) including the calculated amount is created. In the following, the amount charged for Mr. A to Mr. D in August will be explained for each employee.

(1) Mr. A The acquisition unit 102a acquires the reference amount, the billing deadline, and the billing classification included in the rules acquired for Mr. A by [3-1. ] (Basic unit cost 500,000 yen, last day, current month), (Excess unit price and reduced unit price 3,000 yen, last day, current month). Therefore, Mr. A's billing time for August is 184 hours of billing time from August 1 to August 31, as shown in FIG. Therefore, as shown in FIG. 7, Mr. A's billed amount is 500,000 yen (up to 170 hours of basic work time) + 3,000 yen (excess unit price for excess 14 hours) x 14 hours = 542,000 yen And can be calculated.

(2) Mr. B The acquisition amount 102a includes the reference amount, the billing deadline, and the billing category included in the rules acquired for Mr. B. [3-1. ] (Basic unit time 500,000 yen, last day, current month), (Excess unit price and reduced unit price 3,000 yen, last day, next month). Therefore, as shown in FIG. 5, the billing time for Mr. B's basic work time for August is 170 hours of billing time (basic) from August 1st to August 31st, As shown in FIGS. 4 and 5, Mr. B's billing time for the excess time for August is 5.0 hours of the billing time (excess) from July 1st to July 31st. Therefore, as shown in FIG. 7, Mr. B's billed amount for August is 500,000 yen (up to 170 hours of basic work time) + 3,000 yen (excess unit price for excess 5 hours) x 5 hours = It can be calculated as 515,000 yen.

(3) Mr. C The acquiring unit 102a acquires the reference amount, the billing due date, and the billing category included in the rules acquired for Mr. C. [3-1. ], As described in the item, (hourly wage of 1,000 hours for the predetermined working hours, 20th, current month), (hourly wage for overtime 1,250 yen, 20th, current month). Therefore, as shown in FIG. 5, the billing time for the predetermined working hours for August of Mr. C is 160 hours (normally) billing time from July 21 to August 20 (8 hours × 20 In addition, as shown in FIG. 5, the billing time for Mr. C's overtime is 7 hours (1.0 hour × 7) of the billing time (overtime) from July 21 to August 20. Day). Therefore, as shown in FIG. 7, Mr. C's bill amount for August can be calculated as 1,000 yen × 160 hours + 1,250 yen × 7 hours = 168,750 yen.

(4) Mr. D The acquisition amount 102a includes the reference amount, the billing closing date, and the billing category included in the rules acquired for Mr. D. [3-1. ] (Basic unit price 500,000 yen, 20th, current month), (Excess unit price and reduced unit price 3,000 yen, 20th, next month). Therefore, as shown in FIG. 5, the billing time for the basic work time for August of Mr. D is 170 hours of billing time (basic) from July 21 to August 20, Mr. D's billing time for the excess time for August is 12 hours of the billing time (excess) from June 21 to July 20, as shown in FIG. Therefore, as shown in FIG. 7, Mr. D's charged amount for August is 500,000 yen (up to 170 hours of basic work time) +3,000 yen (excess unit price for excess 12 hours) × 12 hours = It can be calculated as 536,000 yen.

  Thus, according to the amount data creation device 100 according to the present embodiment, even when there is a gap between the sales amount calculation target period of each employee and the charge amount calculation target period of each employee, Sales data including sales amount and billing data including charge amount can be created at the same time. For this reason, for example, as in the past, sales data is created only by the system, and billing data is not created manually. Can be improved.

[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.

  In addition, regarding the money amount data creation device 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 money amount data creation device 100, particularly the processing functions performed by the control unit 102, 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 a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and monetary 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.

  Further, this computer program may be stored in an application program server connected to the monetary amount 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. Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

  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 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  Moreover, the money amount 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 money amount data creation device 100 may be realized by installing software (including a program or data) that realizes the processing described in the present embodiment in the device.

  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 the IT industry, the staffing industry, the security industry, and the like.

100 Amount data creation device
102 Control unit
102a acquisition unit
102b Sales data creation department
102c Billing data creation unit
104 Communication interface
106 Storage unit
106a Employee Master
106b Contract table
106c Daily report table
106d results table
106e Sales table
106f billing table
108 Input / output interface
112 Input device
114 Output device 200 Server 300 Network

Claims (3)

A money amount data creation device including a control unit and a storage unit,
In the storage unit,
A contract table containing multiple rules for calculating sales and billing amounts for the month;
A performance table that includes the number of hours worked by employees,
Is stored,
The rules include a base amount, a billing closing date, and a billing category that means one of a billing for the current month and a billing for the next month,
The controller is
Acquisition means for acquiring the rules applied to the target employee from the contract table;
In accordance with the reference amount included in the rules acquired by the acquisition means, the sales amount of the target employee for the current month is calculated based on the number of working hours of the target employee included in the result table, and the calculated sales amount Sales data creation means for creating sales data including
Based on the reference amount included in the rule acquired by the acquisition means, the billing due date, and the billing category, the billing amount for the target employee for the current month is calculated based on the number of working hours of the target employee included in the result table Billing data creating means for creating billing data including the calculated billing amount;
Providing
A monetary data creation device characterized by A money amount data creation method executed by an information processing apparatus including a control unit and a storage unit,
In the storage unit,
A contract table containing multiple rules for calculating sales and billing amounts for the month;
A performance table that includes the number of hours worked by employees,
Is stored,
The rules include a base amount, a billing closing date, and a billing category that means one of a billing for the current month and a billing for the next month,
Executed by the control unit,
Obtaining the rules that apply to the target employee from the contract table;
According to the reference amount included in the rules acquired in the acquisition step, the sales amount of the target employee for the current month is calculated based on the number of working hours of the target employee included in the result table, and the calculated sales amount Sales data creation step to create sales data including
Based on the amount of working hours of the target employee included in the result table, the amount charged for the current month of the target employee is calculated according to the reference amount, the billing deadline, and the billing category included in the rule acquired in the acquisition step A billing data creation step for creating billing data including the calculated billing amount;
Including
A monetary data creation method characterized by A money amount data creation program for causing an information processing apparatus including a control unit and a storage unit to execute,
In the storage unit,
A contract table containing multiple rules for calculating sales and billing amounts for the month;
A performance table that includes the number of hours worked by employees,
Is stored,
The rules include a base amount, a billing closing date, and a billing category that means one of a billing for the current month and a billing for the next month,
For causing the control unit to execute,
Obtaining the rules that apply to the target employee from the contract table;
According to the reference amount included in the rules acquired in the acquisition step, the sales amount of the target employee for the current month is calculated based on the number of working hours of the target employee included in the result table, and the calculated sales amount Sales data creation step to create sales data including
Based on the amount of working hours of the target employee included in the result table, the amount charged for the current month of the target employee is calculated according to the reference amount, the billing deadline, and the billing category included in the rule acquired in the acquisition step A billing data creation step for creating billing data including the calculated billing amount;
Including
A monetary data creation program characterized by

Images