JP7832099B2 - Data creation device, data creation method, and data creation program - Google Patents

Description

This 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, etc., that appropriately allocates the difference in consumption tax when a change in consumption tax occurs during a construction project spanning multiple years.

Japanese Patent Publication No. 2018-194894

In the construction industry, when there is a revision to the consumption tax, and a contract for a construction project subject to the percentage-of-completion method is signed within the transitional period, and the completion date falls after the consumption tax revision, multiple consumption tax rates may be applied to sales. Furthermore, under the invoice system, taxable businesses are now required to display the consumption tax amount for each tax rate on their invoices. Previously, however, invoices corresponding to a single consumption tax rate had to be manually modified to comply with the invoice system, which carried the risk of human error.

This invention has been made in view of the above-mentioned problems, and aims to provide a data creation device, a data creation method, and a data creation program that can create sales data separately for each consumption tax rate when multiple consumption tax rates are used for sales, and thereby contribute to the accurate and efficient creation of invoices compliant with the invoice system.

To solve the aforementioned problems and achieve the objectives, the data creation device according to the present invention is characterized by comprising: a data extraction unit that extracts sales amounts and the consumption tax rates corresponding to the progress rate, linked to predetermined project identification information, by referring to project-specific monthly sales data for projects carried out over multiple months, which manages sales according to the progress rate for each month up to the month preceding the completion month and includes the consumption tax rate; and a consumption tax rate sales data creation unit that, if the data extraction unit extracts a consumption tax rate that differs 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 for each consumption tax rate, based on the amount obtained by subtracting the total sales amounts extracted by the data extraction unit from the order amount of the predetermined project identification information, the consumption tax rate applied to the completion month, and the sales amounts and consumption tax rates extracted by the data extraction unit, thereby creating sales data by consumption tax rate.

Furthermore, the data creation device according to the present invention may further include a billing data creation unit that, if sales data by sales tax rate is available, creates billing data by sales tax rate based on the sales data by sales tax rate, and, if sales data by sales tax rate is not available, creates billing data based on project-specific sales data created using the information extracted by the data extraction unit, the order amount, and the sales tax rate applicable to the completion month.

Furthermore, the data creation apparatus according to the present invention may further include a project-specific sales data creation unit that creates 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.

Furthermore, in the data creation apparatus according to the present invention, the project may relate to construction work.

Furthermore, the data creation method according to the present invention is characterized by the following steps: The data extraction unit refers to project-specific monthly sales data for a project carried out over multiple months, which manages sales according to the progress rate for each month up to the month preceding the completion month, and includes the consumption tax rate, and extracts the sales amount and the consumption tax rate according to the progress rate, linked to predetermined project identification information; and the consumption tax rate-specific sales data creation unit, if the data extraction unit extracts a consumption tax rate that differs 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 for each consumption tax rate, based on the amount obtained by subtracting the total sales amount extracted by the data extraction unit from the order amount of the predetermined project identification information, the consumption tax rate applied to the completion month, and the sales amount and consumption tax rate extracted by the data extraction unit, and creates sales data by consumption tax rate.

Furthermore, the data creation program according to the present invention is designed to function as a data extraction means for an information processing device that references project-specific monthly sales data for projects carried out over multiple months, which manages sales according to the progress rate for each month up to the month preceding the completion month and includes the consumption tax rate, to extract sales amounts and the consumption tax rate according to the progress rate, linked to predetermined project identification information. If the data extraction means extracts a consumption tax rate that differs from the consumption tax rate applied to the completion month, the data extraction means calculates the sales amount and consumption tax amount to be recorded in the completion month for each consumption tax rate, based on the amount obtained by subtracting the total sales amounts extracted by the data extraction means from the order amount of the predetermined project identification information, the consumption tax rate applied to the completion month, and the sales amounts and consumption tax rates extracted by the data extraction means, thereby creating sales data by consumption tax rate.

This invention has the effect of enabling the creation of separate sales data for each consumption tax rate used when multiple consumption tax rates are applied to sales, and consequently contributing to the accurate and efficient creation of invoices compliant with the invoice system.

Figure 1 is a diagram illustrating the overview of the effects of this embodiment. Figure 2 is a block diagram showing an example of the configuration of a business support device according to this embodiment. Figure 3 shows an example of the workflow for the contract month and the various data created by the business support device according to this embodiment. Figure 4 shows an example of the workflow for the month following the contract and the various data created by the business support device according to this embodiment. Figure 5 shows an example of the workflow from the month following the contract signing to the month before the completion month, and the various data created by the business support device according to this embodiment. Figure 6 shows an example of the workflow for the month of completion and the various types of data created by the business support device according to this embodiment. Figure 7 shows an example of an invoice output by the business support device according to this embodiment.

The following describes in detail, with reference to the drawings, embodiments of the data creation apparatus, data creation method, and data creation program according to the present invention. However, the present invention is not limited to these embodiments.

[1. Overview]
Figure 1 is a diagram illustrating the overview of the effects of this embodiment. Assuming the following conditions, which are also shown as an example in Figure 1A, this embodiment makes it possible to create an invoice corresponding to the invoice system shown in Figure 1B, which displays the billing amount and consumption tax amount for each consumption tax rate, by calculating the sales amount for each consumption tax rate, thus eliminating the need for corrections by the person in charge.
- Consumption tax revision details: Changed from 8 percent to 10 percent on October 1, 2019 - Transition period: From April 1, 2019 to September 30, 2019
• Construction information: Construction work subject to the percentage-of-completion method • Contract amount: ¥10,000
Contract period: 5 months, from August 1, 2019 to December 31, 2019

[2. Structure]
An example of the configuration of the business support device 100 (including the data creation device of the present invention) according to this embodiment will be described with reference to Figure 2, etc. Figure 2 is a block diagram showing an example of the configuration of the business support device 100.

The business support system 100 is built on a commercially available desktop personal computer. However, the business support system 100 is not limited to being built on a stationary business support system such as a desktop personal computer; it may also be built on a portable business support system such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The business support device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108. Each component of the business support device 100 is connected via an arbitrary communication path for communication.

The communication interface unit 104 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 the function of communicating data with other devices via the communication line. Here, the network 300 has the 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). Note that the data stored in the storage unit 106 may be stored in, for example, the server 200.

The input/output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 as the keyboard 112 or mouse 112.

The storage unit 106 stores various databases, tables, and files. The storage unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) for various processing tasks. As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 stores basic construction information data 106a, order header data 106b, order details data 106c, budget details data 106d, cost details data 106e, progress data 106f, percentage-based sales data 106g (corresponding to the project-specific monthly sales data of the present invention), sales details data 106h (corresponding to the project-specific sales data of the present invention), sales consumption tax breakdown data 106i (corresponding to the consumption tax rate-specific sales data of the present invention), and invoice details data 106j (corresponding to the consumption tax rate-specific invoice data and invoice data of the present invention), etc.

The basic construction information data 106a is for managing basic information of projects that are carried out over multiple months (e.g., construction work). As shown in Figure 3, it stores project identification information assigned to the project (e.g., PJ number, etc.) and sales criteria classification (e.g., percentage-of-completion criteria, etc.).

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

As shown in Figure 3, the order details data 106c stores project identification information, order identification information, order line number, planned sales date, and order amount.

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, the cost detail data 106e stores project identification information, order identification information, order line number, accounting year and month, and cost amount, etc.

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

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

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

The sales consumption tax breakdown data 106i is used to manage sales amounts and other data for each consumption tax rate when there are multiple consumption tax rates applied to sales. As shown in Figure 6, it stores sales identification information, sales line number, consumption tax rate, sales amount corresponding to the consumption tax rate, and sales consumption tax amount corresponding to the consumption tax rate.

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

Returning to Figure 2, the control unit 102 is a CPU or similar component that comprehensively controls the business support device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs defining various processing procedures, and required data. It executes various information processing operations based on these stored programs.

The control unit 102 functionally comprises 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 percentage-based sales calculation processing unit 102f, a sales input unit 102g, and an invoice input unit 102h. The sales input unit 102g includes the data extraction unit, the sales data creation unit by consumption tax rate, and the sales data by project according to the present invention, while the invoice input unit 102h includes the invoice data creation unit according to the present invention.

The construction information input unit 102a registers the sales-based information entered by the operator during the contract month for the construction project into the construction basic information data 106a.

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

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

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

The progress rate calculation processing unit 102e calculates the project's progress rate for each month from the contract month to the month before the completion month of the construction work by dividing the total cost amount up to that month by the budget amount. The calculated progress rate and fiscal year are then registered in the progress data 106f, linked to the project and order.

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

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

The sales input unit 102g performs the following steps: 1) Calculates the percentage-based sales amount for the completion month by subtracting the total percentage-based sales amount included in the extracted records from the order amount linked to the project and order for which sales are being targeted, stored in the order details data 106c; 2) Calculates the percentage-based sales consumption tax amount for the completion month by multiplying the calculated percentage-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 percentage-based sales amount and the total; 4) Calculates the sales consumption tax amount for the completion month by adding the calculated percentage-based sales consumption tax amount and the total percentage-based sales consumption tax amounts included in the extracted records; and 5) Registers the calculated sales amount, sales consumption tax amount, and applicable consumption tax rate for the completion month in the sales details data 106h, linked to the project and order.

If the extracted records contain a consumption tax rate different from the consumption tax rate applied to the completion month, the sales input unit 102g will: 1) calculate the sales amount and sales consumption tax for the completion month by summing the percentage-based sales amount and percentage-based sales consumption tax for each consumption tax rate, based on the extracted records, the calculated percentage-based sales amount and percentage-based sales consumption tax for the completion month, and the consumption tax rate applied to the completion month; and 2) register the calculated sales amount and sales consumption tax, along with the corresponding consumption tax rate, in the sales consumption tax breakdown data 106i, linked to the sales.

The billing input unit 102h, if it has sales consumption tax breakdown data 106i linked to the sales identification information and sales line number of the billed item, registers the billing amount, the billed consumption tax amount, and the corresponding consumption tax rate for each consumption tax rate, linked to the sales, in the billing detail data 106j, based on the sales consumption tax breakdown data 106i. If it does not have sales consumption tax breakdown data 106i linked to the sales identification information and sales line number of the billed item, it registers the billing amount, the billed consumption tax amount, and the corresponding consumption tax rate, linked to the sales, in the billing detail data 106j, based on the sales detail data 106h.

The control unit 102 (for example, an invoice output unit (not shown)) may create and output invoice data (particularly invoices corresponding to the invoice system, where the invoice amount and invoiced consumption tax amount are shown by consumption tax rate) based on the information stored in the invoice details data 106j.

[3. Processing]
An example of the processing performed by the business support device 100 configured as described above will be explained with reference to Figure 3, etc. Figure 3, etc., shows an example of the processing performed by the business support device 100.

[Step 1: Registration for the contract month (August 2019) (Figure 3)]
First, when the operator inputs "progress basis" as sales basis information, the construction information input unit 102a assigns a PJ number (in this case, "PJ001" is assigned), and stores the assigned PJ number "PJ001" and the entered sales basis "progress basis" in the construction basic information data 106a.

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

Next, when the operator enters the project budget information, the budget input unit 102c stores the project number "PJ001," the order number "JU001," and the entered budget amount "7,500 yen," etc., in the budget details data 106d.

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

Next, the progress rate calculation processing unit 102e calculates a progress rate of "30 percent" by dividing the total cost amount of "2,250 yen" stored in the cost detail data 106e by the budget amount of "7,500 yen" stored in the budget detail data 106d, and multiplying by 100. The calculated progress rate of "30 percent," the project number "PJ001," the order number "JU001," and the accounting year and month "2019/08," etc., 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 details 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 (which is "0 yen" because it is the contract month) to calculate the progress-based sales amount "3,000 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 month "2019/08", it calculates the progress-based sales consumption tax amount "240 yen" for the contract month. Finally, it 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", and the accounting month "2019/08", etc., in the progress-based sales data 106g.

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

Next, the progress rate calculation processing unit 102e calculates a progress rate of "60 percent" by dividing the total cost amount of "4,500 yen" in the cost detail data 106e by the budget amount of "7,500 yen" stored in the budget detail data 106d, and multiplying by 100. The calculated progress rate of "60 percent," the project number "PJ001," the order number "JU001," and the accounting year and month "2019/09," etc., 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 details data 106c by the progress rate "60 percent" stored in the progress data 106f, and subtracts the cumulative progress-based sales amount from the previous month, which is the contract month amount "3,000 yen," to calculate the progress-based sales amount "3,000 yen" for the next month. Based on the calculated progress-based sales amount "3,000 yen" and the consumption tax rate "8 percent" as of the accounting month "2019/09," it calculates the progress-based sales consumption tax amount "240 yen" for the next month. Finally, 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," and the accounting month "2019/09," etc., 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 percentage-based sales calculation processing unit 102f perform the same processing as described in step 2, so that the cost detail data 106e, progress data 106f, and percentage-based sales data 106g also store records for 2019/10 and 2019/11.

[Step 4: Registration of the completion month (2019/12) (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") that are linked to the PJ number "PJ001" and order number "JU001" that are the subject of sales.

Next, the sales input unit 102g performs the following steps: 1) Subtract the total percentage-based sales of the four extracted records, "9,000 yen," from the order amount "10,000 yen" associated with the PJ number "PJ001" and order number "JU001" stored in the order details data 106c to calculate the percentage-based sales amount "1,000 yen" for the completion month "2019/12"; 2) Multiply the calculated percentage-based sales amount "1,000 yen" by the consumption tax rate "10 percent" applicable to the completion month to calculate the percentage-based sales consumption tax amount "100 yen" for the completion month; 3) The calculated percentage-based sales amount "1,000 yen" and The total of "9,000 yen" is added to calculate the sales amount for the completion month, "10,000 yen." Then, 4) the calculated percentage-based sales consumption tax amount of "100 yen" is added to the total percentage-based sales consumption tax amounts included in the four extracted records, "780 yen," to calculate the sales consumption tax amount for the completion month, "880 yen." Finally, 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 PJ number "PJ001," and the order number "JU001," etc., are stored in sales detail data 106h.

Next, if the four extracted records contain a consumption tax rate different from the "10 percent" consumption tax rate applied to the completion month, the sales input unit 102g 1) sums the percentage-based sales amount and percentage-based sales consumption tax amount for each consumption tax rate based on the four extracted records, the calculated percentage-based sales amount of "1,000 yen" and percentage-based sales consumption tax amount of "100 yen" for the completion month, and the "10 percent" consumption tax rate applied to the completion month, and calculates the completion month sales amount of "6,000 yen" and sales consumption tax amount for a consumption tax rate of "8 percent". 1) The sales amount for the completion month is calculated as "4,000 yen" and the sales consumption tax amount is calculated as "400 yen" based on a consumption tax rate of "10 percent" for "480 yen". 2) The records containing the calculated sales amount "6,000 yen", the calculated sales consumption tax amount "480 yen", the corresponding consumption tax rate "8 percent", and the sales number "UR001", etc., and the records containing the calculated sales amount "4,000 yen", the calculated sales consumption tax amount "400 yen", the corresponding consumption tax rate "10 percent", and the sales number "UR001", etc., are stored in the sales consumption tax breakdown data 106i.

Next, the billing input unit 102h stores records linked to the sales number "UR001" and sales line number "001" in the sales consumption tax breakdown data 106i. Based on this data, it stores records containing the assigned billing number "SE001", billing amount "6,000 yen", billing consumption tax amount "480 yen", corresponding consumption tax rate "8 percent", and sales number "UR001" in the billing details data 106j. It also stores records containing the billing number "SE001", billing amount "4,000 yen", billing consumption tax amount "400 yen", corresponding consumption tax rate "10 percent", and sales number "UR001".

The invoice output unit (not shown) then creates and outputs invoice data, as shown in Figure 7, which corresponds to the invoice system and shows the invoice amount and invoiced consumption tax amount for each consumption tax rate, based on the information stored in the invoice details data 106j.

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

Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[5. Other Embodiments]
In addition to the embodiments described above, 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 those described as being performed automatically can be performed manually, or all or part of those described as being performed manually can be performed automatically using known methods.

Furthermore, the processing procedures, control procedures, specific names, information including registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be modified at will unless otherwise specified.

Furthermore, regarding the business support device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

For example, the processing functions of the business support device 100, particularly those performed by the control unit, may be implemented entirely or partially by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary, computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the business support device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores computer programs that cooperate with the OS to give instructions to the CPU and perform various processing tasks. These computer programs are executed by being loaded into RAM and, in cooperation with the CPU, constitute the control unit.

Furthermore, this computer program may be stored on an application program server connected to the business support device 100 via any network, and it is possible to download all or part of it as needed.

Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" refers to memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile). This includes any "portable physical media" such as Blu-ray Discs and Blu-ray® Discs.

Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, standalone structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

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

Furthermore, the business support device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the business support device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.

Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration. All or part of the devices can be functionally or physically distributed and integrated in any unit, depending on various additions or functional loads. In other words, the above-described embodiments may be implemented in any combination, or selectively implemented.

This invention is useful in various 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 Percentage-based sales calculation processing unit
102g Sales Input Section
102h Invoice Input Unit 104 Communication Interface Unit 106 Storage Unit
106a Basic Construction Information Data
106b Order Header Data
106c Order Details Data
106d Budget Details Data
106e Cost Details Data
106f Progress Data
106g Percentage-based sales data
106h Sales Details Data
106i Sales Consumption Tax Breakdown Data
106j Billing details data 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (6)

A data extraction unit extracts the sales amount and the aforementioned consumption tax rate, corresponding to the progress rate, for projects carried out over multiple months, by referring to project-specific monthly sales data, which manages sales according to the progress rate for each month up to the month preceding the completion month, and which includes the consumption tax rate, and which is linked to predetermined project identification information.
If the data extraction unit extracts a consumption tax rate that is different from the consumption tax rate applied to the completion month, the sales data creation unit for consumption tax rates calculates the sales amount and consumption tax amount to be recorded in the completion month for each consumption tax rate, based on the amount obtained by subtracting the total sales amount extracted by the data extraction unit from the order amount of the predetermined project identification information, the consumption tax rate applied to the completion month, and the sales amount and consumption tax rate extracted by the data extraction unit, and creates sales data for each consumption tax rate.
To be equipped,
A data creation device characterized by the following. The system further includes a billing data creation unit which, if the aforementioned sales data by sales tax rate exists, creates billing data by sales tax rate based on the aforementioned sales data by sales tax rate, and if the aforementioned sales data by sales tax rate does not exist, creates billing data based on project-specific sales data created using the information extracted by the data extraction unit, the order amount, and the aforementioned sales tax rate applicable to the completion month.
A data creation device according to claim 1, characterized by the following: The project-specific sales data creation unit further creates project-specific sales data based on the information extracted by the data extraction unit, the order amount, and the consumption tax rate applicable to the completion month.
A data creation device according to claim 2, characterized by the following: The aforementioned project relates to construction work.
A data creation device according to any one of claims 1 to 3, characterized by the above. Information processing device,
A step of extracting the sales amount and the aforementioned consumption tax rate, corresponding to the progress rate, linked to predetermined project identification information, by referring to project-specific monthly sales data for projects carried out over multiple months, which manages sales according to the progress rate for each month up to the month preceding the completion month and includes the consumption tax rate.
If, in the above step, a consumption tax rate different from the consumption tax rate applied to the completion month is extracted, the step of creating sales data by consumption tax rate by calculating the sales amount and consumption tax amount to be recorded in the completion month for each consumption tax rate, based on the amount obtained by subtracting the total sales amount extracted in the above step from the order amount of the predetermined project identification information, the consumption tax rate applied to the completion month, and the sales amount and consumption tax rate extracted in the above step.
To execute,
A data creation method characterized by the following. Information processing equipment,
A data extraction means that extracts sales amounts and the aforementioned consumption tax rates, corresponding to the progress rate, for projects carried out over multiple months, by referring to project-specific monthly sales data for each month up to the month preceding the completion month, which manages sales according to the progress rate and includes the consumption tax rate, and links them to predetermined project identification information.
If the data extraction means extracts a consumption tax rate that is different from the consumption tax rate applied to the completion month, the data extraction means calculates the amount obtained by subtracting the total sales amount extracted by the data extraction means from the order amount of the predetermined project identification information, the consumption tax rate applied to the completion month, and the sales amount and consumption tax rate extracted by the data extraction means, and creates sales data by consumption tax rate, thereby creating sales data by consumption tax rate.
A data creation program designed to function as such.