Business support device, business support method, and business support program

Abstract

To enable recognition of an incurred cost of a task at desired timing.SOLUTION: An acquisition unit acquires a split order amount of order amounts of multiple tasks respectively associated with respective pieces of provisional settlement timing and managed as a single contract at one or more pieces of provisional settlement timing during a period until completion of all tasks of the contract. A calculation unit multiplies a budget rate being the value obtained by dividing the total of the budget amounts set for the respective split order amounts by a total amount of the split order amounts corresponding to the contract at the first provisional settlement timing by the split order amount acquired at the first provisional settlement timing to calculate the first provisional settlement amount, and multiplies the amount obtained by adding the split order amount acquired at the provisional settlement timing of this time to the total of the split order amounts acquired at the provisional settlement timing before this time at the subsequent provisional settlement timing by the budget rate to calculate the provisional settlement amounts of the next and subsequent times.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]

[0002] In the accounting processing device disclosed in Patent Document 1 (Patent Publication No. 7098126), an acquisition means acquires data including a target profit (M) and a construction period (D) for an ordered construction project. A calculation means calculates a target profit ([M / D]·T) per a predetermined period (T) based on the acquired data, and a display means displays the calculated target profit ([M / D]·T).

[0003] This allows us to accurately grasp whether the planned profits are being secured for each project throughout the progress of the project, from order to completion, regardless of whether the project has been completed in the past, enabling detailed profit management. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Patent No. 7098126 Summary of the Invention [Problem to be solved by the invention]

[0005] As an example, in the construction industry, for example, it is common to manage multiple construction projects related to one contract. This means that budgets and incurred costs are managed for the entire contract, but there is a problem that it is difficult to recognize incurred costs at the desired timing before the construction is completed. This problem is more pronounced in the case of completed construction, where revenue can be recognized by recording sales in a lump sum when the construction is completed and handed over.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable the recognition of costs incurred for work such as construction at a desired timing and support the progress management of work. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention has an acquisition unit that acquires, at one or more provisional settlement timings until all work under a contract is completed, split order amounts, which are order amounts for multiple tasks managed as one contract, each associated with each provisional settlement timing; a calculation unit that, at the first provisional settlement timing, calculates a first provisional settlement amount by multiplying the split order amount acquired at the first provisional settlement timing by a budget rate, which is a value obtained by dividing the total of each budget amount set for each split order amount by the total of each split order amount corresponding to the contract, and calculates subsequent provisional settlement amounts at the next or subsequent provisional settlement timings by multiplying the budget rate by an amount obtained by adding the split order amount acquired at the current provisional settlement timing to the total of the split order amounts acquired at the provisional settlement timings up to this one; a data generation unit that generates provisional settlement data including the provisional settlement amount calculated for each provisional settlement timing; and an output control unit that outputs the provisional settlement data generated for each provisional settlement timing.

[0008] In order to solve the above-mentioned problems and achieve the object, the business support method according to the present invention includes an acquisition step in which an acquisition unit acquires, at the timing of one or more provisional settlements until all the work of the contract is completed, split order amounts, which are order amounts for each of a plurality of work tasks managed as one contract and which are associated with the timing of each provisional settlement, and a calculation unit calculates a budget rate, which is a value obtained by dividing the total amount of each budget amount set for each split order amount by the total amount of each split order amount corresponding to the contract at the timing of the first provisional settlement, as the split order rate acquired at the timing of the first provisional settlement. The method includes a calculation step of calculating an initial provisional settlement amount by multiplying the divided order amount, and at the timing of the next provisional settlement onwards, calculating the provisional settlement amount from the next time onwards by multiplying the total amount of the divided order amounts obtained at the timing of the current or previous provisional settlement by the budget rate; a data generation step in which a data generation unit generates provisional settlement data including the provisional settlement amount calculated for each provisional settlement; and an output control step in which an output control unit outputs the provisional settlement data generated for each provisional settlement.

[0009] In addition, in order to solve the above-mentioned problems and achieve the object, the business support program of the present invention causes a computer to function as: an acquisition unit that acquires, at one or more provisional settlement timings until all work of the contract is completed, a split order amount, which is the order amount for each of a plurality of tasks managed as one contract, each associated with each provisional settlement timing; a calculation unit that, at the first provisional settlement timing, calculates a first provisional settlement amount by multiplying the split order amount acquired at the first provisional settlement timing by a budget rate, which is a value obtained by dividing the total amount of each budget amount set for each split order amount by the total amount of each split order amount corresponding to the contract, and calculates subsequent provisional settlement amounts at the next or subsequent provisional settlement timings by multiplying the budget rate by an amount obtained by adding the split order amount acquired at the current provisional settlement timing to the total amount of the split order amounts acquired at the provisional settlement timings prior to this one; a data generation unit that generates provisional settlement data including the provisional settlement amount calculated for each provisional settlement timing; and an output control unit that outputs the provisional settlement data generated for each provisional settlement timing. Effect of the Invention

[0010] The present invention makes it possible to recognize costs incurred for work such as construction at a desired timing, and can support work progress management operations. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 is a block diagram illustrating a hardware configuration of a task support device according to an embodiment. [Diagram 2] FIG. 2 is a diagram showing data generated by inputting basic information and contract information, and budget data, in the business support device according to the embodiment. [Diagram 3] FIG. 3 is a diagram showing quarterly incurred costs generated by inputting purchases and expenses, and quarterly completion transfer costs generated by inputting contract completion, in the business support device according to the embodiment. [Figure 4]FIG. 4 is a diagram showing an example of the contract completion registration screen showing a state in which creation of provisional completion data is specified in June, which corresponds to the first quarter. [Diagram 5] FIG. 5 is a diagram showing an example of order data and order detail data used to create provisional completion data for June, which corresponds to the first quarter. [Figure 6] FIG. 6 is a diagram showing an example of budget data, purchase data, and expense data used to create provisional completion data for June, which corresponds to the first quarter. [Figure 7] FIG. 7 is a diagram showing an example of provisional completion data for June, which corresponds to the first quarter. [Figure 8] FIG. 8 is a diagram showing an example of black journalizing data and red journalizing data generated corresponding to the provisional completion data for June, which corresponds to the first quarter. [Figure 9] FIG. 9 is a diagram showing an example of the contract completion registration screen showing a state in which creation of provisional completion data is specified in September, which corresponds to the second quarter. [Figure 10] FIG. 10 is a diagram showing an example of order data and order detail data used to create provisional completion data for September, which corresponds to the second quarter. [Figure 11] FIG. 11 is a diagram showing an example of budget data, purchase data, and expense data used to create provisional completion data for September, which corresponds to the second quarter. [Figure 12] FIG. 12 is a diagram showing an example of provisional completion data for September, which corresponds to the second quarter. [Figure 13] FIG. 13 is a diagram showing an example of black journalizing data and red journalizing data generated corresponding to the provisional completion data for September, which corresponds to the second quarter. [Figure 14] FIG. 14 is a diagram showing an example of a contract completion registration screen when carrying out the completion process in March, which corresponds to the fourth quarter. [Figure 15] FIG. 15 is a diagram showing an example of order data and order detail data used to generate sales data and sales detail data in the construction completion process for March, which corresponds to the fourth quarter. [Figure 16]FIG. 16 is a diagram showing an example of budget data, purchase data, and expense data used to generate sales data and sales statement data in the completion process for March, which corresponds to the fourth quarter. [Figure 17] FIG. 17 is a diagram showing an example of sales data and sales statement data generated in the completion process for March, which corresponds to the fourth quarter. [Figure 18] FIG. 18 is a diagram showing an example of order data and order detail data used in the construction completion process for March, which corresponds to the fourth quarter. [Figure 19] FIG. 19 is a diagram showing an example of budget data, purchase data, and expense data used in the completion process for March, which corresponds to the fourth quarter. [Figure 20] FIG. 20 is a diagram showing a state in which provisional completion data is not generated in the completion process for March, which corresponds to the fourth quarter. [Figure 21] FIG. 21 is a diagram showing an example of journal entry data generated in the completion process for March, which corresponds to the fourth quarter. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A task support device according to an embodiment of the present invention will now be described in detail with reference to the accompanying drawings.

[0013] The business support device according to the embodiment will be described as an example that supports accounting operations based on the so-called completed contract basis, in which sales are recorded in a lump sum at the timing when the construction is completed and the handover is completed. In addition, the construction period is from April 10, 2022 to March 10, 2023 of the following year, and provisional completion data is created with the timing of provisional settlement being June 30, 2022 (first quarter), September 30, 2022 (second quarter), and December 31, 2022 (third quarter), and completion processing based on the completed contract basis is performed on March 31, 2023.

[0014] The present invention is not limited to such an embodiment, and can be applied to any kind of work support, so long as it involves provisional settlement before completion and the review of sales or progress before completion. Provisional settlement can be performed at any desired timing, such as monthly or semi-annually.

[0015] (Hardware configuration) FIG. 1 is a block diagram showing a hardware configuration of a task support device 1 according to an embodiment. As shown in FIG. 1, the task support device 1 according to the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function. The communication interface unit 4 is connected to a network such as a wide area network such as the Internet or a private network such as a LAN (Local Area Network).

[0016] The storage unit 2 may be, for example, a read only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD). The storage unit 2 stores a business support program that generates provisional completion data for each quarter of a construction project as a provisional settlement. In addition, the business support program is executed to generate order data, order detail data, budget data, purchase data, expense data, provisional completion data, black journal data, red journal data, sales data, and sales detail data. The storage control unit 25 shown in FIG. 1 controls the storage and reading of the various generated data in the storage unit 2.

[0017] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the storage unit 2, thereby functioning as an acquisition unit 21, a calculation unit 22, a data generation unit 23, a display control unit 24, and a storage control unit 25, as shown in Fig. 1. The display control unit 24 is an example of an output control unit.

[0018] The acquisition unit 21 acquires the split order amount, which is the order amount for each of a plurality of works (construction works) managed as one contract, associated with each provisional settlement timing, at one or more provisional settlement timings (at each quarter) until all the works (construction works) of the contract are completed. The split order amount may be acquired from the split order amount stored in the memory unit 2, or may be acquired via a network. Also, data on the split order amount input by a business operator may be acquired, or the split order amount may be acquired from an external memory or the like.

[0019] The calculation unit 22 calculates the first provisional settlement amount (provisional completion data for the first quarter) by multiplying the split order amount obtained at the time of the first provisional settlement (first quarter) by the budget rate, which is the value obtained by dividing the sum of the budget amounts set for each split order amount by the sum of the split order amounts corresponding to the contract.

[0020] In addition, the calculation unit 22 calculates the provisional settlement amount for the next or subsequent provisional settlements (in the second or third quarter) by multiplying the total amount of the installment order amounts obtained at the provisional settlements up to this one by the installment order amount obtained at the provisional settlements up to this one by the budget rate.

[0021] That is, at the timing of provisional settlement for the second quarter, the calculation unit 22 adds the installment order amount for the first quarter to the installment order amount for the second quarter, and multiplies this sum by the above-mentioned budget rate to generate provisional completion data for the second quarter. Similarly, at the timing of provisional settlement for the third quarter, the calculation unit 22 adds the installment order amount for the first quarter, the installment order amount for the second quarter, and the installment order amount for the third quarter, and multiplies this sum by the above-mentioned budget rate to generate provisional completion data for the third quarter.

[0022] The data generation unit 23 generates provisional settlement data including the provisional settlement amount calculated for each quarter, which is the timing of the provisional settlement described above. The display control unit 24, which is an example of an output control unit, displays the provisional settlement data generated for each provisional settlement timing (each quarter) via the output device 7, which is an example of a display unit. The provisional settlement data may be output as sound via a speaker device, or may be printed via a printer.

[0023] In addition, the data generation unit 23 generates black journal entry data on the first date of provisional settlement (e.g., June 30, 2022) as provisional settlement data including the initial (first quarter) provisional settlement amount, with the completed work accounts receivable, which is the installment order amount obtained at the time of provisional settlement, as a debit, the completed work sales revenue, which is the installment order amount obtained at the time of provisional settlement, as a credit, the completed work cost, which is the budgeted amount corresponding to the installment order amount obtained at the time of provisional settlement, as a debit, and the uncompleted work expenditure, which is the budgeted amount corresponding to the installment order amount obtained at the time of provisional settlement, as a credit.

[0024] In addition, the data generation unit 23 generates red journal entry data for performing reverse journal entry processing of black journal entry data, with completed work sales as the debit, completed work accounts receivable as the credit, uncompleted work expenses as the debit, and completed work costs as the credit, for a date after the first date of provisional settlement (for example, July 1, 2022).

[0025] In addition, the data generation unit 23 generates black journal entry data on the date of the next or subsequent provisional settlement (for example, September 30, 2022 or December 31, 2022) as provisional settlement data including the provisional settlement amount for the next or subsequent quarters (second quarter and third quarter), in which the sum of the accounts receivable for completed work and the payments received for uncompleted work, which are the installment order amounts obtained at the time of the next or subsequent provisional settlement, is debited, the completed work sales amount, which is the sum of the installment order amounts obtained at the time of the next or subsequent provisional settlement and the installment order amounts obtained at the time of the provisional settlement for the next or subsequent quarters (first quarter in the case of the second quarter, and first and second quarters in the case of the third quarter), is credited, and the completed work cost, which is the amount obtained by multiplying the completed work sales amount, which is the total of the installment order amounts, by the budget rate, is debited, and the amount of the completed work cost, which is the total of the installment order amounts, by multiplying the completed work sales amount, which is the total of the installment order amounts, by the budget rate, is credited as uncompleted work expenses.

[0026] In addition, the data generation unit 23 generates red journal data for performing the reversal journalization process of the above-mentioned black journal data on a date after the date of the next provisional settlement (for example, October 1, 2022 or January 1, 2023), in which the completed work sales revenue, which is the total amount of the divided order amount obtained at the time of provisional settlement before the next quarter (first quarter in the case of the second quarter, and first and second quarters in the case of the third quarter), is debited, the total amount of the completed work accounts receivable and the uncompleted work receipts, which are the divided order amount obtained at the time of provisional settlement after the next quarter (second or third quarter), is credited, the uncompleted work expenses equivalent to the completed work cost, which is the amount obtained by multiplying the completed work sales revenue, which is the total amount of the divided order amount, by the budget rate, is debited, and the completed work cost, which is the amount corresponding to the uncompleted work expenses equivalent to the completed work cost, which is the amount obtained by multiplying the completed work sales revenue, which is the total amount of the divided order amount, by the budget rate, is credited.

[0027] In other words, the data generation unit 23 generates black journal entry data as provisional settlement each quarter, and, for example, on the start date of the next quarter, generates red journal entry data corresponding to this black journal entry data, and cancels the black journal entry data (provisionally generated black invoices) for accounting purposes.

[0028] In addition, the data generation unit 23 generates budget data including the order amount, which is the total of each divided order amount corresponding to a contract, the total of each budget amount set for each divided order amount, the budget rate obtained by dividing the total budget amount by the total of each divided order amount corresponding to a contract, the budget amount by expense item, which is the breakdown of the total budget amount, and the item-by-expense ratio obtained by dividing the budget amount by the total of each divided order amount corresponding to a contract.

[0029] (Overview of provisional completion data generation operation) Next, an overview of the operation of generating quarterly provisional completion data in the business support device 1 of the embodiment will be described with reference to Fig. 2 and Fig. 3. First, the business operator inputs project (PJ) basic information and contract information via the input device 6. As a result, as shown in Fig. 2(a), order data (and order detail data) are generated in which the project number (contract number), order number (construction number), order line number, order amount of minor works included in the contract (construction amount: equivalent to the divided order amount), and scheduled completion date of each minor work are associated.

[0030] The example in Figure 2(a) shows that there is a contract with a project number of "PJ22001" and an order number of "JU22001", and that the contract includes minor works with order amounts of "8 million yen", "3 million yen", "6 million yen", and "5 million yen", respectively. In addition, the scheduled completion dates for each minor work are set as "June 10, 2022", "September 10, 2022", "December 10, 2022", and "March 10, 2023", respectively.

[0031] The example in Figure 2(a) shows that there is a contract with a project number of "PJ23001" and an order number of "JU23001", and that the contract includes minor works with order amounts of "7 million yen" and "2 million yen", respectively. In addition, the scheduled completion dates for each minor work are set as "April 10, 2023" and "April 30, 2023", respectively.

[0032] The business operator also inputs the budget amount for each minor work as shown in Fig. 2(b). The example in Fig. 2(b) shows that the budget amounts of "6 million yen", "2.5 million yen", "4.5 million yen" and "3.5 million yen" have been set for each minor work with the project number "PJ23001", respectively, and indicates that the total budget amount of "16.5 million yen" has been set. When the budget amounts are set in this manner, the calculation unit 22 calculates the budget rate by dividing the budget amount of "16.5 million yen" by the total amount of the order amount (8 million yen + 3 million yen + 6 million yen + 5 million yen = 22 million yen) (16.5 million yen / 22 million yen = 75.0%).

[0033] The business operator also inputs the budget amounts by expense item, which are the breakdown of the budget amount of "16.5 million yen," as shown in Fig. 6(a). In the example of Fig. 6, out of the budget amount of "16.5 million yen," "6 million yen" is input as "material costs," "2.5 million yen" as "outsourcing costs," "4.5 million yen" as "labor costs," and "3.5 million yen" as "expenses." When the budget amounts by expense item are input in this manner, the calculation unit 22 calculates the item-specific ratio corresponding to the budget amount by each expense item by dividing the budget amount of each expense item by the order amount of "22 million yen."

[0034] In other words, in this example, the expense item ratio corresponding to the budgeted amount for material costs is calculated as "6 million yen / 22 million yen = 27.2%," the expense item ratio corresponding to the budgeted amount for outsourcing costs is calculated as "2.5 million yen / 22 million yen = 11.4%," the expense item ratio corresponding to the budgeted amount for labor costs is calculated as "4.5 million yen / 22 million yen = 20.5%," and the expense item ratio corresponding to the budgeted amount for expenses is calculated as "3.5 million yen / 22 million yen = 15.9%."

[0035] The data generating unit 23 generates budget data including such order amount, budget rate, budget amount, budget amount by expense item, and ratio by expense item (see FIG. 2(b) and FIG. 6(a)).

[0036] In addition, the business operator inputs purchases and expenses every quarter as shown in Figure 3(a). The example in Figure 3(a) is an example in which the incurred costs of "7 million yen" incurred as of the end of June 2022 are input, the incurred costs of "7 million yen + 3.5 million yen = 10.5 million yen" incurred as of the end of September 2022 are input, and the incurred costs of "7 million yen + 3.5 million yen + 4.5 million yen = 15 million yen" incurred as of the end of December 2022 are input.

[0037] The business operator also inputs the deposits quarterly, as shown in FIG. 3(b). The example in FIG. 3(b) shows that a deposit of "8 million yen" was made at the end of June 2022 for the completion of construction in June, and this deposit was processed in July of the following month. The example in FIG. 3(b) shows that a deposit of "3 million yen" was made at the end of September 2022 for the completion of construction in September, and this deposit was processed in October of the following month. The example in FIG. 3(b) shows that a deposit of "6 million yen" was made at the end of December 2022 for the completion of construction in December, and this deposit was processed in January of the following year.

[0038] Then, the calculation unit 22 calculates the completion transfer cost for each quarter as shown in FIG. 3(c) by multiplying the budget rate by the order amount of each small construction work as the billing amount for each quarter. The data generation unit 23 generates provisional completion data including the completion transfer cost calculated for each quarter. The example of FIG. 3 is an example in which, as of the end of June 2022, a completion transfer cost of "6 million yen" is generated for the incurred cost of "7 million yen" shown in FIG. 3(a), as of the end of September 2022, a completion transfer cost of "8.25 ​​million yen" is generated for the incurred cost of "10.5 million yen" shown in FIG. 3(a), and as of the end of December 2022, a completion transfer cost of "12.75 million yen" is generated for the incurred cost of "15 million yen" shown in FIG. 3(a).

[0039] The display control unit 24 displays the generated provisional completion data via the output device 7. This makes it possible to display the provisional completion data for each quarter, and to check and manage the progress of the construction work, etc.

[0040] (For processing in June 2022) Next, the operation of generating provisional completion data will be specifically described. First, among the small works of the project number (contract number) of "PJ22001" shown in FIG. 2(a), the work with the order amount of "8 million yen" corresponding to the order number (work number) of "1" was started on April 10, 2022 and completed on June 10, 2022, so the progress will be confirmed on June 30, 2022, which corresponds to the first quarter. In this case, the business operator specifies the display of the contract completion screen. When this specification operation is performed, the control unit 3 functions as the display control unit 24 based on the business support project stored in the storage unit 2, and displays the contract completion registration screen exemplified in FIG. 4 via the output device 7.

[0041] The business operator inputs "June 30, 2022" as the base date and the scheduled completion date on this contract completion registration screen, and selects the completion category of "provisional completion" from the completion category selection field. As a result, the display control unit 24 refers to the order data shown in FIG. 5(a) and the order detail data shown in FIG. 5(b), and displays a list of the project number, contract completion date, order number, contract construction name, construction period, contract amount, person in charge, department in charge, and billing amount of the construction completed by June 30, 2022 on the contract completion registration screen, as shown in FIG.

[0042] The example in Figure 4 shows a list of various data for two construction projects, "PJ22001" and "PJ23001," which are projects that were completed by June 30, 2022. The business operator checks the checkboxes of the construction projects for which provisional completion data is to be generated, and operates the execute button (not shown).

[0043] The "contract completion date" included in the order data in Figure 5(a) is entered as the contract completion date, which is the date when all construction work for the project number "PJ22001" is completed. In this example, as described below, the contract completion date is entered as "March 31, 2023". Since the explanation here is for the processing for June 2022, the "contract completion date" will be left blank (NULL data).

[0044] The business operator may also input a desired project number or order number into the contract completion registration screen. When the desired project number or order number is input, the display control unit 24 displays on the contract completion registration screen the contract completion date, order number, contract work name, construction period, contract amount, person in charge, responsible department, billing amount, etc., corresponding to the specified base date and planned completion date of the minor work of the input project number or order number. In this case as well, when the business operator generates provisional completion data, he / she inputs a check into a check box and operates an execute button (not shown).

[0045] When the execute button is operated, the data generation unit 23 refers to the order data shown in Fig. 5(a), the order detail data shown in Fig. 5(b), the budget data shown in Fig. 6(a), the purchase data shown in Fig. 6(b), and the expense data shown in Fig. 6(c), and generates provisional completion data corresponding to the first quarter of June 2022, as shown in Fig. 7. This provisional completion data includes the project number, order number, office code, department code, order date, invoice code, invoice sales amount, sales date, provisional completion date, sold amount, invoiced amount, total work in progress cost, completion transfer cost, and budget rate.

[0046] The example in FIG. 7 is provisional completion data for a minor construction project for which the construction project is a contract with the order number "JU22001" and the project completion date is tentative for June 2022 (see FIG. 2(a)). The budget rate is calculated by dividing the total of the budget amounts set for the order amounts of each construction project, which is "16.5 million yen", by the total of the order amounts of each construction project corresponding to the contract, which is "22 million yen", with the control unit 3 functioning as the calculation unit 22 based on the business support program. In this case, the budget rate is "75%". The data generation unit 23 generates provisional completion data including the budget rate of "75%".

[0047] The calculation unit 22 also calculates a completion transfer cost of "6 million yen" by multiplying the order amount of "8 million yen" for the minor work, whose scheduled completion date was June 2022, by this budget rate of "75%". The data generation unit 23 generates provisional completion data including the invoiced amount, which is the order amount of "8 million yen", and the completion transfer cost of "6 million yen".

[0048] The data generation unit 23 also generates provisional completion data by inputting "June 30, 2022", which is input by the business operator via the contract completion registration screen, as the "provisional completion date". Note that the "sales date" included in this provisional completion data is left blank (NULL data) by the data generation unit 23, since no sales have actually occurred. In this example, the "sales date" is input as "March 31, 2023", the date when all construction work is completed and sales are recorded.

[0049] Next, the data generation unit 23 generates black journal entry data for the date "June 30, 2022" as shown in Figure 8, with the debit side set to accounts receivable from completed construction of "8 million yen", the credit side set to sales revenue from completed construction of "8 million yen", the debit side set to expenditure for uncompleted construction of "6 million yen", and the credit side set to the cost of completed construction of "6 million yen".

[0050] In addition, the data generation unit 23 generates red journal entry data on the date of "July 1, 2022" as shown in Fig. 8, in which the debit side is the completed construction sales amount of "8 million yen", the credit side is the completed construction receivables amount of "8 million yen", the debit side is the uncompleted construction expenditure amount of "6 million yen", and the credit side is the completed construction cost amount of "6 million yen". This makes it possible to cancel the black journal entry data generated as provisional completion on "June 30, 2022" with the red journal entry data dated "July 1, 2022".

[0051] (For processing in September 2022) Next, among the small construction works with the project number (contract number) of "PJ22001" shown in FIG. 2(a), the construction work with the order amount of "3 million yen" corresponding to the order number (construction number) of "2" was started on June 10, 2022 and completed on September 10, 2022, so the progress will be confirmed on September 30, 2022, which corresponds to the second quarter. In this case, the business operator specifies the display of the contract completion screen. When this specification operation is performed, the control unit 3 functions as the display control unit 24 based on the business support project stored in the memory unit 2, and displays the contract completion registration screen exemplified in FIG. 9 via the output device 7.

[0052] The business operator inputs "September 30, 2022" as the base date and the scheduled completion date on this contract completion registration screen, and selects the completion category of "provisional completion" from the completion category selection field. As a result, the display control unit 24 refers to the order data shown in FIG. 10(a) and the order detail data shown in FIG. 10(b), and displays a list of the project number, contract completion date, order number, contract construction name, construction period, contract amount, person in charge, department in charge, and billing amount of the construction completed by September 30, 2022 on the contract completion registration screen, as shown in FIG. 9.

[0053] The example in FIG. 9 shows a list of various data for two construction projects, "PJ22001" and "PJ23001", which are construction projects that will be completed by September 30, 2022. The business operator checks the checkbox of the construction project for which provisional completion data is to be generated, and operates the execute button (not shown).

[0054] When the execution button is operated, the data generation unit 23 refers to the order data shown in FIG. 10(a), the order detail data shown in FIG. 10(b), the budget data shown in FIG. 11(a), the purchase data shown in FIG. 11(b), the expense data shown in FIG. 11(c), the deposit data shown in FIG. 11(d), and the deposit reconciliation data shown in FIG. 11(e), and generates provisional completion data corresponding to the second quarter of September 2022, as shown in FIG. 12. The "supplementary information" shown in the deposit data in FIG. 11(d) and the deposit reconciliation data in FIG. 11(e) is account information (in the example of FIG. 11(d), main account information is entered in the main bank) or a bill number, etc. In addition, in the deposit data in FIG. 11(d), the "cash and deposit / passing account" is "8 million yen". In addition, in the deposit reconciliation data in FIG. 11(e), the "passing account / uncompleted construction receipt" is "8 million yen".

[0055] When generating this provisional completion data, the calculation unit 22 calculates a completion transfer cost of "8.25 ​​million yen" by multiplying the "11 million yen" obtained by adding the "8 million yen" order amount for the small work in the first quarter and the "3 million yen" order amount for the small work in the second quarter by the above-mentioned "75%" budget rate. The data generation unit 23 generates provisional completion data including the invoiced amount, which is the order amount of "11 million yen", and the completion transfer cost of "8.25 ​​million yen".

[0056] The data generation unit 23 also generates provisional completion data by inputting "September 30, 2022" entered by the business operator via the contract completion registration screen as the "provisional completion date." As an image, the data generation unit 23 generates provisional completion data for each quarter by setting the provisional completion data generated in the first quarter as the first column of records and the provisional completion data generated in the second quarter as the second column of records, as shown in FIG. 12. This makes it possible to display the provisional completion data for each quarter in a list, making it easier to recognize the progress of the construction work, etc.

[0057] Next, the data generation unit 23 generates black journal entry data on the date of "September 30, 2022" as shown in FIG. 13, in which the total amount of "3 million yen" of uncompleted construction receivables and "8 million yen" of uncompleted construction receivables is debited, the sales amount of "11 million yen" of completed construction is credited, the cost of completed construction of "8.25 ​​million yen" is debited, and the expenditure for uncompleted construction of "8.25 ​​million yen" is credited. Since the data generation unit 23 has a payment for the June invoice, it offsets the uncompleted construction receivables, as in "July accrual journal entry: cash and deposits 8 million yen / uncompleted construction receivables 8 million yen".

[0058] In addition, the data generation unit 23 generates red journal data on the date of "October 1, 2022" as shown in Fig. 13, in which the completed construction sales of "11 million yen" is debited, the total amount of the completed construction receivables of "3 million yen" and the uncompleted construction receipts of "8 million yen" is debited, the uncompleted construction expenditures of "8.25 ​​million yen" is debited, and the completed construction cost of "8.25 ​​million yen" is credited. This makes it possible to cancel the black journal data generated as provisional completion on "September 30, 2022" with the red journal data dated "October 1, 2022".

[0059] (For processing in March 2023) Next, as shown in Figure 5(b), all minor construction works for project number (contract number) "PJ22001" that started on "April 10, 2022" were completed on "March 10, 2023", so sales will be recorded on "March 31, 2023". In this case, the business operator specifies the display of the contract completion screen, and on the contract completion registration screen that is displayed, enters "March 31, 2023" as the base date and planned completion date, as shown in Figure 14, and selects the completion category of "Uncompleted (=Completion processing)" from the completion category selection field.

[0060] As a result, the display control unit 24 refers to the order data shown in Fig. 15(a) and the order detail data shown in Fig. 15(b), and displays on the contract completion registration screen a list of the project number, contract completion date, order number, contract work name, construction period, contract amount, person in charge, department in charge, and billing amount of the construction work completed by March 31, 2023, as shown in Fig. 14. The processing performed on March 31, 2023 is a completion processing that actually records sales data, unlike the provisional completion processing described above.

[0061] The example in FIG. 14 shows a list of various data for two construction projects, "PJ22001" and "PJ23001", which are to be completed by March 31, 2023. The business operator checks the checkbox of the project to be subject to completion processing, and operates the execute button (not shown).

[0062] When the execute button is operated, the data generation unit 23 refers to the order data shown in FIG. 15(a), the order detail data shown in FIG. 15(b), the budget data shown in FIG. 16(a), the purchase data shown in FIG. 16(b), the expense data shown in FIG. 16(c), the deposit data shown in FIG. 17(a), and the deposit reconciliation data shown in FIG. 17(b), and generates sales data and sales detail data for the fourth quarter of March 2023 as shown in FIG. 17(c) and FIG. 17(d). In the deposit data in FIG. 17(a), the "Cash and deposit / passing account" is "8 million yen". In the deposit reconciliation data in FIG. 17(b), the "passing account / uncompleted construction receipts" is "8 million yen".

[0063] The sales data shown in Fig. 17(c) includes a sales number, an office code, a department code, a sales date, a project number, an order number, a billing code, and a net amount of invoice sales. The data generation unit 23 inputs "March 31, 2023" as the "sales date", "PJ22001" as the project number, and "22 million yen", which is the total of the order amounts for each small work, as the net amount of invoice sales, to generate sales data.

[0064] The sales statement data shown in Fig. 17(d) is composed of sales number, sales line number, project number, order number, order line number, product name, and net sales amount. The data generation unit 23 consistently uses the project number "PJ22001" as the project number and the order number "JU22001" as the order number for each sub-work. The data generation unit 23 also inputs, as the net sales amount, the amounts of "8 million yen," "3 million yen," "6 million yen," and "5 million yen," which are the order amounts (corresponding to the divided order amount) for each sub-work, which are the breakdown of the order amount of "22 million yen."

[0065] In addition, in the completion processing on March 31, 2023, the above-mentioned provisional completion data based on the order data shown in Figure 18(a), the order detail data shown in Figure 18(b), the budget data shown in Figure 19(a), the purchasing data shown in Figure 19(b), and the expense data shown in Figure 19(c) is not generated as shown in Figure 20.

[0066] Next, the data generation unit 23 generates black journal entry data on the date "March 31, 2023" as shown in Figure 21, with the debit side set as accounts receivable from completed construction of "5 million yen", the credit side set as sales revenue from completed construction of "22 million yen", the debit side set as cost of completed construction of "16.5 million yen", and the credit side set as expenditure for uncompleted construction of "16.5 million yen".

[0067] In addition, since there are payments for the invoices for June, September, and December, the data generating unit 23 generates the following data as shown in FIG. July accounting entry: Cash and deposits 8 million yen / Uncompleted construction receipts 8 million yen October accounting entry: Cash and deposits 3 million yen / Uncompleted construction receipts 3 million yen Accounting for the following January: Cash and deposits 6 million yen / Uncompleted construction receipts 6 million yen The amount received for uncompleted construction is offset as follows:

[0068] In addition, in this completion process, red journalizing data that cancels black journalizing data is not generated.

[0069] (Effects of the embodiment) For example, in the construction industry, it is common to manage multiple works associated with one contract. This means that the budget and incurred costs are managed for the entire contract, but since multiple sub-tasks are carried out in parallel, it is difficult to recognize the incurred costs of the sub-tasks and the progress of the works. In completed construction, sales and costs are generated at the time of contract completion, making it more difficult to recognize sales and costs every quarter.

[0070] The business support device 1 of the embodiment processes the incurred costs and sales as provisional completion to generate provisional completion data and accounting data. This makes it possible to recognize quarterly sales, completion costs, construction progress, etc. In other words, it is possible to recognize the incurred costs for work such as construction at a desired timing such as quarterly, and it is possible to support the work progress management work.

[0071] In addition, while still taking advantage of the practice of consolidating multiple small projects into one contract, it will be possible to record reliable results based on billing processing and budget information.

[0072] [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, and can therefore contribute to Goals 8 and 9 of the SDGs.

[0073] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.

[0074] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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

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

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

[0078] Moreover, with regard to the task support device 1, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0079] For example, the processing functions of the business support device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including 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 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.

[0080] In addition, the business support program of this business support device 1 may be stored in another server device connected to the business support device 1 via any network, and it is also possible to download all or part of it as needed.

[0081] The business support program for executing the process described in the present embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0082] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, 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 as multiple modules or libraries, and a program that achieves its function by working with a separate program, such as an OS. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the business support device 1 shown in the embodiment, as well as the installation procedure after reading.

[0083] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

[0084] The business support device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device to which any peripheral device is connected. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.

[0085] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to 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. [Industrial Applicability]

[0086] The present invention is suitable for use, for example, when calculating a provisional settlement amount midway through construction work or IT (Information Technology) media work, etc., to recognize the progress status. [Explanation of symbols]

[0087] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 21 Acquisition Department 22 Calculation section 23 Data Generation Division 24 Display control section 25 Memory control unit

Claims

1. an acquisition unit that acquires, at one or more provisional settlement timings until all the work under the contract is completed, split order amounts, which are order amounts for multiple works managed as one contract and are associated with each of the provisional settlement timings; a calculation unit which, at the timing of the first provisional settlement, calculates an initial provisional settlement amount by multiplying the split order amount acquired at the timing of the first provisional settlement by a budget rate, which is a value obtained by dividing the total amount of each budget amount set for each of the split order amounts by the total amount of each of the split order amounts corresponding to the contract, and calculates subsequent provisional settlement amounts at the timing of the next or subsequent provisional settlement by multiplying the budget rate by an amount obtained by adding the split order amount acquired at the timing of the current or previous provisional settlement to the total amount of the split order amounts acquired at the timing of the current or previous provisional settlement; a data generating unit that generates provisional settlement data including the provisional settlement amount calculated at each timing of the provisional settlement; an output control unit that outputs the provisional settlement data generated at each timing of the provisional settlement; A business support device having the above configuration.

2. The data generation unit As the provisional settlement data including the first provisional settlement amount, Generate black journal entry data on the first date of the provisional settlement, with the completed work accounts receivable, which is the divided order amount obtained at the time of the provisional settlement, as a debit, the completed work sales revenue, which is the divided order amount obtained at the time of the provisional settlement, as a credit, the completed work cost, which is the budget amount corresponding to the divided order amount obtained at the time of the provisional settlement, as a debit, and the uncompleted work expenditure, which is the budget amount corresponding to the divided order amount obtained at the time of the provisional settlement, as a credit, Red journal entry data for performing a reverse journal entry process on the black journal entry data, in which the completed work sales amount is debited, the completed work accounts receivable is credited, the uncompleted work expenses are debited, and the completed work cost is credited, is generated on a date after the first date of the provisional settlement, As the provisional settlement data including the provisional settlement amount for the next time and thereafter, generate black journal entry data for the date of the next or subsequent provisional settlement in which the sum of the accounts receivable for completed work and the receipts of uncompleted work, which are the split order amounts obtained at the timing of the next or subsequent provisional settlement, is debited, the completed work sales amount, which is the sum of the split order amounts obtained at the timing of the next or subsequent provisional settlement and the split order amounts obtained at the timing of the next or subsequent provisional settlement or earlier, is credited, the completed work cost, which is the amount obtained by multiplying the completed work sales amount, which is the sum of the split order amounts, by the budget rate, is debited, and the completed work cost, which is the amount obtained by multiplying the completed work sales amount, which is the sum of the split order amounts, by the budget rate, is credited as uncompleted work expenses, generating red journal data for performing a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, the red journal data being used to perform a reverse journal entry process on the black journal data, the red journal data being used to perform a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, the red journal data being used to perform a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, the red journal data being used to perform a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, the red journal data being used to perform a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, the red journal data being used to perform a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, the red journal data being used to perform a reverse journal entry process on the black journal data for a date after the date of the next or later provisional settlement, 2. The business support device according to claim 1,

3. The data generation unit The order amount, which is the sum of the divided order amounts corresponding to the contract; The total of each of the budget amounts set for each of the divided order amounts, The budget rate obtained by dividing the total amount of the budget by the total amount of each of the divided order amounts corresponding to the contract; The budget amount by item that is the breakdown of the total amount of the budget, The item-specific ratio obtained by dividing each of the budget amounts by the total of the divided order amounts corresponding to the contract, generating budget data including:

3. The business support device according to claim 1 or 2,

4. an acquisition step in which an acquisition unit acquires, at one or more provisional settlement timings until all the work of the contract is completed, split order amounts, which are order amounts for multiple works managed as one contract, each associated with each of the provisional settlement timings; a calculation step in which a calculation unit calculates an initial provisional settlement amount by multiplying the split order amount acquired at the first provisional settlement by a budget rate, which is a value obtained by dividing the total amount of each budget amount set for each of the split order amounts by the total amount of each of the split order amounts corresponding to the contract, and calculates subsequent provisional settlement amounts by multiplying the budget rate by an amount obtained by adding the split order amount acquired at the current provisional settlement to the total amount of the split order amounts acquired at the provisional settlement before this one; a data generating step of generating provisional settlement data including the provisional settlement amount calculated for each provisional settlement timing; an output control step in which an output control unit outputs the provisional settlement data generated at each timing of the provisional settlement; A business support method having the above-mentioned features.

5. Computer, an acquisition unit that acquires, at one or more provisional settlement timings until all the work under the contract is completed, split order amounts, which are order amounts for multiple works managed as one contract and are associated with each of the provisional settlement timings; a calculation unit which, at the timing of the first provisional settlement, calculates an initial provisional settlement amount by multiplying the split order amount acquired at the timing of the first provisional settlement by a budget rate, which is a value obtained by dividing the total amount of each budget amount set for each of the split order amounts by the total amount of each of the split order amounts corresponding to the contract, and calculates subsequent provisional settlement amounts at the timing of the next or subsequent provisional settlement by multiplying the budget rate by an amount obtained by adding the split order amount acquired at the timing of the current or previous provisional settlement to the total amount of the split order amounts acquired at the timing of the current or previous provisional settlement; a data generating unit that generates provisional settlement data including the provisional settlement amount calculated at each timing of the provisional settlement; functioning as an output control unit that outputs the provisional settlement data generated at each timing of the provisional settlement; A business support program that features:

Images