JP2024085099A - Data creation apparatus, data creation method, and data creation program - Google Patents

Abstract

To provide a data creation apparatus and so on which can create sales data as to each consumption tax rate if multiple consumption tax rates for sales are used and which can correctly and efficiently create an invoice corresponding to an invoice system.SOLUTION: According to an embodiment of the present invention, a method has steps of 1) with reference to current reference sales data regarding a construction project currently carried out over a plurality of months, extracting a sales amount and a consumption tax rate associated with both of a predetermined project and a predetermined order, and 2) if a consumption tax rate different from the consumption tax rate applied upon the sales is extracted, generating sales consumption tax breakdown data by calculating a sales amount and a consumption tax rate allocated to the month of completion applied with respect to each consumption tax rate based on the amount of a placed order associated with the extracted information and the predetermined project and the predetermined order.SELECTED DRAWING: Figure 6

Description

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

Patent Document 1 discloses a construction cost management system that appropriately allocates the difference in consumption tax when a change in consumption tax occurs during construction that spans multiple years.

JP 2018-194894 A

In the construction industry, if the consumption tax rate is revised and a contract is signed for construction work that is accounted for using the percentage of completion method during the transitional period and is completed after the date of the consumption tax revision, there may be multiple consumption tax rates used for sales. Also, the invoice system requires taxable businesses to display the amount of consumption tax for each consumption tax rate on their invoices, but until now, invoices that were normally created for one consumption tax rate had to be manually revised by a person to create an invoice that complies with the invoice system, which raised the risk of human error.

The present invention has been made in consideration of the above problems, and aims to provide a data creation device, a data creation method, and a data creation program that can create sales data for each consumption tax rate when multiple consumption tax rates are used for sales, and that can ultimately contribute to the accurate and efficient creation of invoices that comply with the invoice system.

In order to solve the above-mentioned problems and achieve the object, the data creation device according to the present invention is characterized by comprising: a data extraction unit that extracts the sales amount and the consumption tax rate associated with the specific project identification information according to the progress rate by referring to monthly sales data by project for a project proceeding over multiple months, which manages sales according to the progress rate for each month up to the month before the completion month and includes a consumption tax rate; and a consumption tax rate sales data creation unit that, when the data extraction unit extracts a consumption tax rate different from the consumption tax rate applied to the completion month, calculates the sales amount and the consumption tax amount to be recorded for the completion month by consumption tax rate based on the amount obtained by subtracting the total of the sales amounts extracted by the data extraction unit from the order amount of the specific project identification information, the consumption tax rate applied to the completion month, and the sales amount and the consumption tax rate extracted by the data extraction unit, to create the consumption tax rate sales data.

The data creation device according to the present invention may further include a billing data creation unit that creates billing data by consumption tax rate based on the sales data by consumption tax rate when the sales data by consumption tax rate is available, and creates billing data based on the sales data by project created based on the information extracted by the data extraction unit, the order amount, and the consumption tax rate applied to the completion month when the sales data by consumption tax rate is not available.

The data creation device according to the present invention may further include a project sales data creation unit that creates the project sales data based on the information extracted by the data extraction unit, the order amount, and the consumption tax rate applied to the completion month.

In the data creation device of the present invention, the project may be related to construction work.

The data creation method according to the present invention is characterized by including a step in which the data extraction unit refers to monthly sales data by project for a project that is carried out over multiple months, which manages sales according to the progress rate for each month up to the month before the completion month and includes a consumption tax rate, and extracts the sales amount and the consumption tax rate according to the progress rate linked to specified project identification information; and a step in which the sales data creation unit by consumption tax rate creates sales data by consumption tax rate by subtracting the total of the sales amounts extracted by the data extraction unit from the order amount of the specified project identification information, based on the consumption tax rate applied to the completion month, and the sales amount and the consumption tax rate extracted by the data extraction unit, when the data extraction unit extracts a consumption tax rate different from the consumption tax rate applied to the completion month.

The data creation program of the present invention causes an information processing device to function as a data extraction means for extracting the sales amount and the consumption tax rate associated with a specific project identification information according to the progress rate by referring to monthly sales data by project for a project proceeding over multiple months, which manages sales according to the progress rate for each month up to the month before the completion month and includes a consumption tax rate, and a consumption tax rate sales data creation means for creating consumption tax rate sales data by consumption tax rate by subtracting the total of the sales amounts extracted by the data extraction means from the order amount of the specific project identification information when the data extraction means extracts a consumption tax rate different from the consumption tax rate applied to the completion month, and calculating the sales amount and consumption tax amount to be recorded for the completion month by consumption tax rate based on the consumption tax rate applied to the completion month and the sales amount and the consumption tax rate extracted by the data extraction means.

The present invention has the effect of making it possible to create sales data for each consumption tax rate when multiple consumption tax rates are used for sales, thereby contributing to the accurate and efficient creation of invoices that comply with the invoice system.

FIG. 1 is a diagram showing an outline of the effect of this embodiment. FIG. 2 is a block diagram showing an example of the configuration of a task support device according to this embodiment. FIG. 3 is a diagram showing an example of a workflow for a contract month and various data created by the workflow support device according to this embodiment. FIG. 4 is a diagram showing an example of the flow of business operations for the next month after the contract and various data created by the business support device according to this embodiment. FIG. 5 is a diagram showing an example of the flow of work from the month following the contract to the month before the completion month, and various data created by the work support device according to this embodiment. FIG. 6 is a diagram showing an example of the workflow in the completion month and various data created by the workflow support device according to this embodiment. FIG. 7 shows an example of an invoice output by the business support device according to this embodiment.

Below, an embodiment of a data creation device, a data creation method, and a data creation program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[1. Overview]
Fig. 1 is a diagram showing an outline of the effects of this embodiment. Assuming the following conditions, which are also shown as an example in Fig. 1A, in this embodiment, by calculating the sales amount for each consumption tax rate, it is possible to create an invoice that corresponds to the invoice system shown in Fig. 1B, in which the billing amount and the consumption tax amount are displayed for each consumption tax rate, eliminating the need for corrections by the person in charge.
・ Consumption tax revision: Change from 8% to 10% on October 1, 2019 ・ Transitional measures period: From April 1, 2019 to September 30, 2019
・Construction information: Construction contract based on percentage of completion method ・Order amount: ¥10,000
・Contract period: 5 months from August 1, 2019 to December 31, 2019

2. Configuration
An example of the configuration of the task assistance device 100 according to this embodiment (including the data creation device of the present invention) will be described with reference to Fig. 2 etc. Fig. 2 is a block diagram showing an example of the configuration of the task assistance device 100.

The business support device 100 is constructed based on a commercially available desktop personal computer. Note that the business support device 100 is not limited to being constructed based on a stationary business support device such as a desktop personal computer, but may be constructed based on a portable business support device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The business support device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the business support device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the business support 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 the communication line. Here, the network 300 has a function of connecting the business support 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). The data stored in the memory unit 106 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. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, 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 records computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like.

The memory unit 106 stores basic construction information data 106a, order header data 106b, order detail data 106c, budget detail data 106d, cost detail data 106e, progress data 106f, progress-based sales data 106g (corresponding to monthly sales data by project in the present invention), sales detail data 106h (corresponding to sales data by project in the present invention), sales consumption tax breakdown data 106i (corresponding to sales data by consumption tax rate in the present invention), and billing detail data 106j (corresponding to billing data by consumption tax rate and billing data in the present invention).

The basic construction information data 106a is used to manage basic information on projects (e.g., construction projects) that are carried out over multiple months, and stores project identification information (e.g., PJ number, etc.) and sales criteria classification (e.g., progress criteria, etc.) assigned to the project, as shown in FIG. 3.

As shown in FIG. 3, the order header data 106b stores project identification information, order identification information assigned to the order (e.g., order number, etc.), contract date, etc.

As shown in FIG. 3, the order detail data 106c stores project identification information, order identification information, order line number, expected sales date, order amount, etc.

As shown in Figure 3, budget detail data 106d stores project identification information, order identification information, order line number, budget amount, etc.

As shown in Figures 3, 4, and 5, cost detail data 106e stores project identification information, order identification information, order line number, accounting year and month, cost amount, etc.

As shown in Figures 3, 4, and 5, progress data 106f stores project identification information, order identification information, order line number, fiscal year and month, and project progress rate, etc.

As shown in Figures 3, 4, 5 and 6, progress-based sales data 106g stores project identification information, order identification information, order line number, accounting year and month, progress-based sales amount, consumption tax rate, and progress-based sales consumption tax amount, etc.

As shown in FIG. 6, sales detail data 106h stores sales identification information (e.g., sales number, etc.) assigned to the sale, sales line number, project identification information, order identification information, order line number, consumption tax rate at the time of the sale, sales amount, and sales consumption tax amount.

The sales consumption tax breakdown data 106i is used to manage the sales amount etc. for each consumption tax rate when there are multiple consumption tax rates applicable to sales, and as shown in FIG. 6, stores sales identification information, sales line number, consumption tax rate, sales amount according to the consumption tax rate, and sales consumption tax amount according to the consumption tax rate.

As shown in FIG. 6, the billing detail data 106j stores billing identification information assigned to the billing, billing line number, sales identification information, consumption tax rate, billing amount according to the consumption tax rate, and billing consumption tax amount according to the consumption tax rate.

Returning to FIG. 2, the control unit 102 is a CPU or the like that provides overall control of the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

The control unit 102, in terms of its functional concept, includes a construction information input unit 102a, a contract information input unit 102b, a budget input unit 102c, a cost input unit 102d, a progress rate calculation processing unit 102e, a progress-based sales calculation processing unit 102f, a sales input unit 102g, and a billing input unit 102h. The sales input unit 102g includes the data extraction unit of the present invention, the consumption tax rate sales data creation unit of the present invention, and the project sales data of the present invention, and the billing input unit 102h includes the billing data creation unit of the present invention.

The construction information input unit 102a registers the sales criteria information entered by the operator in the contract month of the construction project in the construction basic information data 106a.

The contract information input unit 102b links the contract information entered by the operator in the contract month of a construction project to the project and registers it in the order header data 106b and order detail data 106c.

The budget input unit 102c links the budget information entered by the operator in the contract month of the construction project to the project and the order, and registers it in the budget detail data 106d.

The cost input unit 102d links the cost information entered by the operator for each month from the contract month of the construction project to the month before the completion month with the project and the order, and registers it in the cost detail data 106e.

The progress rate calculation processing unit 102e calculates the progress rate of a construction project by dividing the total cost amount up to that month by the budget amount for each month from the contract month to the month before the completion month, and links the calculated progress rate and fiscal year to the project and order, and registers them in the progress data 106f.

The progress-based sales calculation processing unit 102f calculates the progress-based sales amount for each month from the contract month to the month before the completion month of a construction project by subtracting the cumulative progress-based sales amount from the previous month and before from the amount obtained by multiplying the order amount by the progress rate, calculates the progress-based sales consumption tax amount based on the calculated progress-based sales amount and the consumption tax rate at that time, and registers the calculated progress-based sales amount, progress-based sales consumption tax amount, consumption tax rate, and fiscal year in the progress-based sales data 106g by linking them to the project and order.

The sales input unit 102g refers to the progress-based sales data 106g to extract records linked to the project and order that is the subject of the sales (records for each month from the contract month to the month before the completion month).

The sales input unit 102g 1) calculates the progress-based sales amount for the completion month by subtracting the total progress-based sales amount included in the extracted records from the order amount linked to the project and order that is the subject of the sales stored in the order detail data 106c, 2) calculates the progress-based sales tax amount for the completion month by multiplying the calculated progress-based sales amount by the consumption tax rate applicable to the completion month, 3) calculates the sales amount for the completion month by adding the calculated progress-based sales amount to this total, 4) calculates the sales tax amount for the completion month by adding the calculated progress-based sales tax amount to the total progress-based sales tax amount included in the extracted records, and 5) registers the calculated sales amount and sales tax amount for the completion month and the consumption tax rate applicable to the completion month in the sales detail data 106h, linking them to the project and order.

If the extracted record contains a consumption tax rate that is different from the consumption tax rate applied to the completion month, the sales input unit 102g 1) calculates the sales amount and sales consumption tax amount for the completion month by consumption tax rate by adding up the progress-based sales amount and progress-based sales consumption tax amount for each consumption tax rate based on the extracted record, the calculated progress-based sales amount and progress-based sales consumption tax amount for the completion month, and the consumption tax rate applied to the completion month, and 2) links the calculated sales amount and sales consumption tax amount and the corresponding consumption tax rate to the sales and registers them in the sales consumption tax breakdown data 106i.

If there is sales consumption tax breakdown data 106i linked to the sales identification information and sales line number of the invoice target, the invoice input unit 102h links the invoice amount and invoice consumption tax amount by consumption tax rate and the corresponding consumption tax rate to the sales based on the sales consumption tax breakdown data 106i, and registers them in the invoice detail data 106j by linking them to the sales, and if there is no sales consumption tax breakdown data 106i linked to the sales identification information and sales line number of the invoice target, the invoice input unit 102h links the invoice amount and invoice consumption tax amount and the corresponding consumption tax rate to the sales based on the sales detail data 106h, and registers them in the invoice detail data 106j by linking them to the sales.

The control unit 102 (e.g., an invoice output unit (not shown)) may create and output invoice data (especially invoices that comply with an invoice system in which the invoice amount and the invoiced consumption tax amount are shown by consumption tax rate) based on the information stored in the invoice detail data 106j.

3. Processing
An example of processing performed by the task assistance device 100 configured as described above will be described with reference to Fig. 3 etc. Fig. 3 etc. are diagrams showing an example of processing performed by the task assistance device 100.

[Step 1: Registering the contract month (August 2019) (Figure 3)]
First, when the operator inputs the "progress standard" as sales standard information, the construction information input unit 102a assigns a project number (in this case, it is assumed that "PJ001" is assigned), and stores the assigned project number "PJ001" and the input sales standard "progress standard" in the construction basic information data 106a.

Next, when the operator inputs the construction contract information, the contract information input unit 102b assigns an order number (in this case, it is assumed that "JU001" is assigned), and stores the PJ number "PJ001", the assigned order number "JU001", the input contract date "2019/08/01", etc. in the order header data 106b, and also stores the PJ number "PJ001", the order number "JU001", the input planned sales date "2019/12/31", the input order amount "10,000 yen", etc. in the order detail data 106c.

Next, when the operator inputs the budget information for the construction project, the budget input unit 102c stores the project number "PJ001," the order number "JU001," and the input budget amount "7,500 yen" in the budget detail data 106d.

Next, when the operator inputs the cost information for the construction work, the cost input unit 102d stores the project number "PJ001", the order number "JU001", the input accounting year and month "2019/08", the input cost amount "2,250 yen", etc. in the cost detail data 106e.

Next, the progress rate calculation processing unit 102e divides the total cost amount "2,250 yen" stored in the cost detail data 106e by the budget amount "7,500 yen" stored in the budget detail data 106d, and multiplies it by 100 to calculate a progress rate of "30 percent", and stores the calculated progress rate "30 percent", the project number "PJ001", the order number "JU001", the accounting year and month "2019/08", etc. in the progress data 106f.

Next, the progress-based sales calculation processing unit 102f multiplies the order amount "10,000 yen" stored in the order detail data 106c by the progress rate "30 percent" stored in the progress data 106f, and subtracts the cumulative progress-based sales amount from the previous month and before ("0 yen" because it is the contract month) from that amount to calculate the progress-based sales amount "3,000 yen" for the contract month. It calculates the progress-based sales consumption tax amount "240 yen" for the contract month based on the calculated progress-based sales amount "3,000 yen" and the consumption tax rate "8 percent" as of the accounting year and month "2019/08", and stores the calculated progress-based sales amount "3,000 yen", the calculated progress-based sales consumption tax amount "240 yen", the consumption tax rate "8 percent", the PJ number "PJ001", the order number "JU001", the accounting year and month "2019/08", etc. in the progress-based sales data 106g.

[Step 2: Registration for the month following the contract month (September 2019) (Figure 4)]
First, when the operator inputs cost information for the construction project, the cost input unit 102d stores the project number "PJ001", the order number "JU001", the input accounting year and month "2019/09", and the cost amount "2,250 yen", etc., in the cost detail data 106e.

The progress rate calculation processing unit 102e then divides the total cost amount in the cost detail data 106e, "4,500 yen," by the budget amount "7,500 yen" stored in the budget detail data 106d, and multiplies it by 100 to calculate a progress rate of "60 percent." The progress rate thus calculated, along with the project number "PJ001," the order number "JU001," and the accounting year and month "2019/09," are then stored in the progress data 106f.

Next, the progress-based sales calculation processing unit 102f multiplies the order amount "10,000 yen" stored in the order detail data 106c by the progress rate "60 percent" stored in the progress data 106f, and subtracts the amount for the contract month, which is the cumulative total of the progress-based sales amounts from the previous month and before, "3,000 yen" to calculate the progress-based sales amount for the next month, "3,000 yen." Based on the calculated progress-based sales amount "3,000 yen" and the consumption tax rate "8 percent" as of the accounting year and month "2019/09," the progress-based sales consumption tax amount for the next month, "240 yen," is calculated, and the calculated progress-based sales amount "3,000 yen," the calculated progress-based sales consumption tax amount "240 yen," the consumption tax rate "8 percent," the PJ number "PJ001," the order number "JU001," the accounting year and month "2019/09," and the like are stored in the progress-based sales data 106g.

[Step 3: Registration from the month after the contract month (October 2019) to the month before the completion month (November 2019) (Figure 5)]
The cost input unit 102d, the progress rate calculation processing unit 102e, and the progress-based sales calculation processing unit 102f execute processing similar to that described in step 2, and thereby the cost detail data 106e, the progress data 106f, and the progress-based sales data 106g further store records for 2019/10 and 2019/11.

[Step 4: Register the completion month (December 2019) (Figure 6)]
First, the sales input unit 102g refers to the progress-based sales data 106g and extracts four records (records for each month from the contract month "2019/8" to the month before the completion month "2019/11") linked to the project number "PJ001" and order number "JU001" that are the subject of sales.

Next, the sales input unit 102g 1) subtracts the total progress-based sales amount "9,000 yen" contained in the four extracted records from the order amount "10,000 yen" linked to the PJ number "PJ001" and order number "JU001" stored in the order detail data 106c to calculate the progress-based sales amount "1,000 yen" for the completion month "2019/12", 2) multiplies the calculated progress-based sales amount "1,000 yen" by the consumption tax rate "10 percent" applicable to the completion month to calculate the progress-based sales consumption tax amount "100 yen" for the completion month, and 3) multiplies the calculated progress-based sales amount "1,000 yen" and The total "9,000 yen" is added to calculate the sales amount for the completion month "10,000 yen", 4) the calculated progress-based sales consumption tax amount "100 yen" is added to the total progress-based sales consumption tax amount contained in the four extracted records "780 yen" to calculate the sales consumption tax amount for the completion month "880 yen", and 5) the calculated sales amount for the completion month "10,000 yen", the calculated sales consumption tax amount "880 yen", the consumption tax rate applicable to the completion month "10 percent", the assigned sales number "UR001", the project number "PJ001", and the order number "JU001", etc. are stored in the sales detail data 106h.

Next, if the four extracted records contain a consumption tax rate that is different from the consumption tax rate "10 percent" applied to the completion month, the sales input unit 102g: 1) adds up the progress-based sales amount and progress-based sales consumption tax amount by consumption tax rate based on the four extracted records, the calculated progress-based sales amount "1,000 yen" and progress-based sales consumption tax amount "100 yen" for the completion month, and the consumption tax rate "10 percent" applied to the completion month, and calculates the sales amount "6,000 yen" and sales consumption tax amount " 1) calculate the sales amount "4,000 yen" and sales tax amount "400 yen" for the month of completion for the consumption tax rate of "10 percent" and 2) store a record including the calculated sales amount "6,000 yen", the calculated sales tax amount "480 yen", the corresponding consumption tax rate "8 percent" and sales number "UR001", and a record including the calculated sales amount "4,000 yen", the calculated sales tax amount "400 yen", the corresponding consumption tax rate "10 percent" and sales number "UR001", in the sales tax breakdown data 106i.

Next, since the sales consumption tax breakdown data 106i contains records linked to the sales number "UR001" and sales line number "001" of the invoice target, the invoice input unit 102h stores in the invoice detail data 106j a record including the invoice number "SE001", invoice amount "6,000 yen", invoice consumption tax amount "480 yen", corresponding consumption tax rate "8 percent", and sales number "UR001", etc., and a record including the invoice number "SE001", invoice amount "4,000 yen", invoice consumption tax amount "400 yen", corresponding consumption tax rate "10 percent", and sales number "UR001", etc., based on the sales consumption tax breakdown data 106i.

Then, the invoice output unit (not shown) creates and outputs invoice data shown in Figure 7, which corresponds to the invoice system in which the invoice amount and the invoiced consumption tax amount are shown by consumption tax rate, based on the information stored in the invoice detail data 106j.

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

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using a known method.

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

Furthermore, with regard to the business support device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the business support device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the business support device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the business support device 100 via any network, and all or part of it may be downloaded as needed.

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

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

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

The business support 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. The business support device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful in a variety of industries, including the construction industry.

100 Business support device 102 Control unit
102a Construction information input section
102b Contract information input section
102c Budget input section
102d Cost input section
102e Progress rate calculation processing unit
102f Progress-based sales calculation processing unit
102g Sales input section
102h billing input unit 104 communication interface unit 106 storage unit
106a Basic construction information data
106b Order header data
106c Order detail data
106d Budget detail data
106e Cost Detail Data
106f Progress Data
106g Progress-based sales data
106h Sales details data
106i Sales and consumption tax breakdown data
106j billing statement data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (6)

a data extraction unit that refers to monthly sales data by project for a project proceeding over multiple months, which manages sales according to a progress rate for each month up to the month before the completion month and includes a consumption tax rate, and extracts a sales amount and the consumption tax rate according to a progress rate associated with a specific project identification information;
a consumption tax rate sales data creation unit which, when the data extraction unit extracts a consumption tax rate different from the consumption tax rate applied to the completion month, calculates the sales amount and consumption tax amount to be recorded in the completion month by consumption tax rate based on the amount obtained by subtracting the total of the sales amounts extracted by the data extraction unit from the order amount of the specified project identification information, the consumption tax rate applied to the completion month, and the sales amount and the consumption tax rate extracted by the data extraction unit, to create sales data by consumption tax rate;
To have
A data creation device comprising: a billing data creation unit which, if the sales data by consumption tax rate is available, creates billing data by consumption tax rate based on the sales data by consumption tax rate, and, if the sales data by consumption tax rate is not available, creates billing data based on the information extracted by the data extraction unit, the order amount, and the consumption tax rate applied to the completion month;
2. The data creation device according to claim 1, a project-specific sales data creation unit that creates the project-specific sales data based on the information extracted by the data extraction unit, the order amount, and the consumption tax rate applied to the completion month;
3. The data creation device according to claim 2, wherein: The project is a construction project;
4. The data creation device according to claim 1, wherein: a data extraction unit referring to monthly sales data by project relating to a project proceeding over multiple months, which manages sales according to the progress rate for each month up to the month before the completion month and includes a consumption tax rate, extracting a sales amount according to the progress rate and the consumption tax rate associated with a predetermined project identification information;
a sales data creation unit for calculating the sales amount and the consumption tax amount to be recorded in the completion month by each consumption tax rate based on the amount obtained by subtracting the total of the sales amounts extracted by the data extraction unit from the order amount of the specified project identification information, the consumption tax rate to be applied in the completion month, and the sales amount and the consumption tax rate extracted by the data extraction unit, when the data extraction unit extracts a consumption tax rate different from the consumption tax rate applied in the completion month, thereby creating sales data by consumption tax rate;
containing,
A data creation method comprising: An information processing device,
a data extraction means for extracting the sales amount and the consumption tax rate according to the progress rate linked to a predetermined project identification information by referring to monthly sales data by project for a project proceeding over a period of multiple months, which manages sales according to the progress rate for each month up to the month before the completion month and includes a consumption tax rate;
a consumption tax rate sales data creation means for calculating the sales amount and consumption tax amount to be recorded in the completion month by consumption tax rate based on an amount obtained by subtracting the total of the sales amounts extracted by the data extraction means from the order amount of the specified project identification information, the consumption tax rate applied to the completion month, and the sales amount and the consumption tax rate extracted by the data extraction means, and creating sales data by consumption tax rate;
A data creation program to function as a.

Images