Data creation device, data creation method, and data creation program

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

Technical Field

[0004] ,

[0006] , , , , , ,

[0005] , , ,

[0003] , , , , ,

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

Background Art

[0002] Patent Document 1 discloses a construction cost management system and the like that appropriately sets the allocation of the consumption tax difference when a consumption tax change occurs during construction over several years.

Prior Art Document

[0007] 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 by project based on the information extracted by the data extraction unit, the order amount, and the sales data by project that is created based on the sales data by project that is created based on the sales data by project that is created based on the information extracted by the data extraction unit, the order amount, and the sales tax rate applicable to the completion month.

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

[0009] Furthermore, in the data creation device according to the present invention, the project may relate to construction work.

[0010] Furthermore, the data creation method according to the present invention is characterized by the following steps: a 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, which are linked to predetermined project identification information; and a sales data creation unit by consumption tax rate, if the data extraction unit extracts a consumption tax rate that is different from the consumption tax rate applied to the completion month, the unit 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.

[0011] Furthermore, the data creation program according to the present invention is designed to cause an information processing device to function as a data extraction means 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, if the data extraction means extracts a consumption tax rate that is different from the consumption tax rate applied to the completion month, a consumption tax rate data creation means that 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. [Effects of the Invention]

[0012] This invention has the effect of enabling the creation of sales data separately for each consumption tax rate when multiple consumption tax rates are used for sales, and consequently contributing to the accurate and efficient creation of invoices that comply with the invoice system. [Brief explanation of the drawing]

[0013] [Figure 1] Figure 1 is a diagram illustrating the overview of the effects of this embodiment. [Figure 2] Figure 2 is a block diagram showing an example of the configuration of a business support device according to this embodiment. [Figure 3] 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] 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] 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] 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] Figure 7 shows an example of an invoice output by the business support device according to this embodiment. [Modes for carrying out the invention]

[0014] Embodiments of the data creation apparatus, data creation method, and data creation program according to the present invention will be described in detail below with reference to the drawings. However, the present invention is not limited to these embodiments.

[0015] [1. Overview] FIG. 1 is a diagram showing an overview of the effects of the present embodiment. When the following conditions shown as an example in A of FIG. 1 are assumed, in the present embodiment, by calculating the sales amount for each consumption tax rate, an invoice corresponding to the invoice system shown in B of FIG. 1 in which the amount billed and the consumption tax amount are displayed for each consumption tax rate can be created, so that correction by the person in charge is not required. · Consumption tax amendment details: Changed from 8% to 10% on October 1, 2019 · Period of application of transitional measures: From April 1, 2019 to September 30, 2019 · Construction information: Construction subject to the construction progress standard · Order amount: ¥10,000 · Contract period: Five months from August 1, 2019 to December 31, 2019

[0016] [2. Configuration] An example of the configuration of the business support device 100 (including the data creation device of the present invention) according to the present embodiment will be described with reference to FIG. 2 and the like. FIG. 2 is a block diagram showing an example of the configuration of the business support device 100.

[0017] 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, and may be constructed based on a portable business support device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0018] The business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part included in the business support device 100 is communicably connected via an arbitrary communication path.

[0019] The communication interface unit 104 connects the business support device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines. The communication interface unit 104 has the function of communicating data with other devices via communication lines. 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). The data stored in the storage unit 106 may be stored in, for example, the server 200.

[0020] 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 may be referred to as the keyboard 112 or mouse 112.

[0021] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory 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.

[0022] 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 project-specific monthly sales data of the present invention), sales details data 106h (corresponding to project-specific sales data of the present invention), sales consumption tax breakdown data 106i (corresponding to consumption tax rate-specific sales data of the present invention), and invoice details data 106j (corresponding to consumption tax rate-specific invoice data and invoice data of the present invention), etc.

[0023] The basic construction information data 106a is used to manage basic information for 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.).

[0024] 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, etc.), and contract date, etc.

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

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

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

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

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

[0030] As shown in Figure 6, sales detail data 106h stores sales identification information assigned to sales (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.

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

[0032] As shown in Figure 6, the billing details data 106j stores billing identification information, 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, etc., which are assigned to the bill.

[0033] 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 that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0034] Functionally, the control unit 102 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 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, and the invoice input unit 102h includes the invoice data creation unit according to the present invention.

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

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

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

[0038] 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 into the cost detail data 106e, linking it to the project and order.

[0039] 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 a construction project 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 the order.

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

[0041] 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 to be sold.

[0042] The sales input unit 102g performs the following steps: 1) Subtract the total percentage-based sales amount included in the extracted records from the order amount linked to the project and order to be sold, which is stored in the order details data 106c, to calculate the percentage-based sales amount for the completion month; 2) Multiply the calculated percentage-based sales amount by the consumption tax rate applicable to the completion month to calculate the percentage-based sales consumption tax amount for the completion month; 3) Add the calculated percentage-based sales amount and the total to calculate the sales amount for the completion month; 4) Add the calculated percentage-based sales consumption tax amount and the total percentage-based sales consumption tax amounts included in the extracted records to calculate the sales consumption tax amount for the completion month; 5) Register the calculated sales amount and sales consumption tax amount for the completion month, as well as the consumption tax rate applicable to the completion month, linked to the project and order, in the sales details data 106h.

[0043] If the extracted records include 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 progress-based sales amount and progress-based sales consumption tax for each consumption tax rate based on the extracted records, the calculated progress-based sales amount and progress-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.

[0044] If there is sales consumption tax breakdown data 106i associated with the sales identification information and sales line number of the billed item, the billing input unit 102h registers the billing amount and billed consumption tax amount by consumption tax rate, as well as the corresponding consumption tax rate, in the billing details data 106j, linked to the sales, based on the sales consumption tax breakdown data 106i. If there is no sales consumption tax breakdown data 106i associated with the sales identification information and sales line number of the billed item, the billing input unit 102h registers the billing amount and billed consumption tax amount, as well as the corresponding consumption tax rate, in the billing details data 106j, linked to the sales, based on the sales details data 106h.

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

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

[0047] [Step 1: Registration for the contract month (2019 / 08) (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.

[0048] 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 details data 106c.

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

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

[0051] 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 details data 106e by the budget amount of "7,500 yen" stored in the budget details data 106d, and multiplying the result by 100. The calculated progress rate of "30 percent", project number "PJ001", order number "JU001", and accounting year and month "2019 / 08", etc., are then stored in the progress data 106f.

[0052] Next, the percentage-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 percentage-based sales amount from the previous month (which is "0 yen" because it is the contract month) from that amount to calculate the percentage-based sales amount "3,000 yen" for the contract month. Based on the calculated percentage-based sales amount "3,000 yen" and the consumption tax rate "8 percent" as of the accounting month "2019 / 08", it calculates the percentage-based sales consumption tax amount "240 yen" for the contract month, and stores the calculated percentage-based sales amount "3,000 yen", the calculated percentage-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 percentage-based sales data 106g.

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

[0054] 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 details data 106e by the budget amount of "7,500 yen" stored in the budget details data 106d, and multiplying the result by 100. The calculated progress rate of "60 percent", project number "PJ001", order number "JU001", and accounting year and month "2019 / 09", etc., are then stored in the progress data 106f.

[0055] 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 amount for the contract month, "3,000 yen," which is the cumulative progress-based sales amount from the previous months, 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, 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 / 09," etc., in the progress-based sales data 106g.

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

[0057] [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 project number "PJ001" and order number "JU001" that are the subject of the sales.

[0058] Next, the sales input unit 102g 1) subtracts 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) multiplies 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) and The total of "9,000 yen" is added to calculate the sales amount for the completion month, "10,000 yen". 4) The calculated percentage-based sales consumption tax amount, "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". 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.

[0059] Next, the sales input unit 102g, if the four extracted records include a consumption tax rate different from the consumption tax rate "10 percent" applied to the completion month, 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 "1,000 yen" and percentage-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 completion month sales amount "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 the consumption tax rate of "10 percent" for "480 yen". 2) A record 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 a record 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.

[0060] Next, the billing input unit 102h stores in the billing details data 106j a record 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", based on the sales consumption tax breakdown data 106i. This record contains the assigned billing number "SE001", billing amount "6,000 yen", billing consumption tax amount "480 yen", corresponding consumption tax rate "10 percent", and sales number "UR001", etc.

[0061] Then, the invoice output unit (not shown) 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 by consumption tax rate, based on the information stored in the invoice details data 106j.

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

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

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

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

[0066] 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 by known methods.

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

[0068] Furthermore, with respect to the business support device 100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[0069] For example, the processing functions of the business support device 100, particularly those performed by the control unit, may be implemented in whole or in part 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) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

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

[0071] 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" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0072] 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, monolithic 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.

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

[0074] 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 on the device.

[0075] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0076] This invention is useful in various industries, including the construction industry. [Explanation of Symbols]

[0077] 100 Business support equipment 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 Section 104 Communication Interface Section 106 Storage section 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 Sales data based on progress 106h Sales Details Data 106i Sales Consumption Tax Breakdown Data 106j Billing Details Data 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

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

2. If the aforementioned sales data by consumption tax rate exists, the billing data creation unit creates billing data by consumption tax rate based on the aforementioned sales data by consumption tax rate. If the aforementioned sales data by consumption tax rate does not exist, the billing data creation unit creates billing data based on the information extracted by the data extraction unit, the order amount, and the project-specific sales data created based on the aforementioned consumption tax rate applicable to the completion month. To further prepare, A data creation device according to claim 1, characterized by the following:

3. Project Sales Data Creation Unit 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. To further prepare, A data creation device according to claim 2, characterized by the following:

4. The aforementioned project relates to construction work. A data creation device according to any one of claims 1 to 3, characterized by the above.

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

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

Images