Project income and expenditure management device, project income and expenditure management method, and project income and expenditure management program

Abstract

To provide a project balance management system capable of analyzing by managing the actual and estimated costs of each project every month and storing the estimated cost for each processing month, a project balance management method, and a project balance management program.SOLUTION: The project balance management system is configured to register a piece of information on the planned cost of a project while linking the estimated monthly actual amount, estimated annual actual amount, and estimated actual amount for the next fiscal year and after for each cost item during the order period based on project information, obtain project cost details with actual monthly costs for each cost item, update the project information planned cost based on the project cost breakdown, and based on the information on the project cost, obtain a piece of information on the project analytics for a predetermined time unit.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a project balance management device, a project balance management method, and a project balance management program. [Background technology]

[0002] Patent Document 1 discloses a configuration in which, when an update of the contract amount as a monthly process is detected, the cumulative progress sales amount and the single-period progress sales amount are recalculated based on the contract amount after taking into account any increase or decrease. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2022-182779 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in Patent Document 1 above has a problem in that it is not possible to register actual costs and estimated costs to be incurred in future months for each processing year and month.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a project income and expenditure management device, a project income and expenditure management method, and a project income and expenditure management program that manage the actual costs and estimated costs of each project as a monthly process and store the estimated costs for each processing month so that they can be analyzed. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the project income and expenditure management device of the present invention is a project income and expenditure management device equipped with a memory unit and a control unit, wherein the memory unit comprises a project storage means for storing project information including contract information that sets the order period for the project and budget information that sets the budget amount for each cost item of the project, and the control unit comprises: a project registration means for registering project planned cost information that links the estimated monthly actual amount, estimated annual actual amount, and estimated actual amount for the next year and thereafter for each cost item during the order period based on the project information; a cost detail acquisition means for acquiring project cost details that set the estimated monthly actual amount for each cost item; an update means for updating the project planned cost information based on the project cost details; and an analysis acquisition means for acquiring project analysis information for a specified period based on the project planned cost information.

[0007] In addition, in the project income and expenditure management device of the present invention, the analysis acquisition means acquires the project analysis information based on the project planned cost information, which sets a predetermined period actual amount generated by summing up the monthly actual amount generated for each cost item for each predetermined period.

[0008] In addition, in the project income and expenditure management device according to the present invention, the analysis acquisition means acquires the project analysis information based on the project planned cost information, which includes the actual amount expected to be incurred in the fiscal year, the actual amount expected to be incurred in the following fiscal year and thereafter, and the difference between the actual amount expected to be incurred in the current fiscal year and the actual amount expected to be incurred in the following fiscal year and thereafter.

[0009] In addition, in the project income and expenditure management device of the present invention, the analysis acquisition means is characterized in that when the cost item and the specified period are set on the analysis screen, it acquires the project analysis information of the cost item for the specified period based on the project planned cost information.

[0010] In the project balance management device according to the present invention, the analysis acquisition means further displays the project analysis information.

[0011] In the project balance management device according to the present invention, the predetermined period is one month, one quarter, one trimester, or one half year.

[0012] Furthermore, in the project income and expenditure management device according to the present invention, the updating means replaces the monthly actual amount expected to be incurred for each cost item set in the project planned cost information with the monthly actual amount based on the project cost details, and updates the annual actual amount expected to be incurred and the expected actual amount for the following fiscal year and thereafter set in the project planned cost information based on the difference between the monthly actual amount expected to be incurred and the monthly actual amount.

[0013] Furthermore, a project balance management method according to the present invention is a project balance management method to be executed by a project balance management device having a memory unit and a control unit, wherein the memory unit comprises project storage means for storing project information including contract information that sets the order period for the project and budget information that sets the budget amount for each cost item of the project, and the method includes the following steps executed by the control unit: a project registration step for registering project planned cost information that links together the monthly actual amount expected to be incurred, the annual actual amount expected to be incurred, and the expected actual amount for the following year and thereafter for each cost item during the order period, based on the project information; a cost detail acquisition step for acquiring project cost details that set the monthly actual amount to be incurred for each cost item; an update step for updating the project planned cost information based on the project cost details; and an analysis acquisition step for acquiring project analysis information for a predetermined period of time based on the project planned cost information.

[0014] Furthermore, the project income and expenditure management program of the present invention is a project income and expenditure management program to be executed by a project income and expenditure management device having a memory unit and a control unit, wherein the memory unit comprises a project storage means for storing project information including contract information that sets the order period for the project and budget information that sets the budget amount for each cost item of the project, and the control unit executes the following steps in the control unit: a project registration step for registering project planned cost information that links together the monthly actual amount expected to be incurred, the annual actual amount expected to be incurred, and the expected actual amount for the following year and thereafter for each cost item during the order period based on the project information; a cost detail acquisition step for acquiring project cost details that set the monthly actual amount expected to be incurred for each cost item; an update step for updating the project planned cost information based on the project cost details; and an analysis acquisition step for acquiring project analysis information for a specified period based on the project planned cost information. [Effects of the Invention]

[0015] The present invention provides the advantage of being able to grasp income and expenditures for each fiscal year and to compare forecasts and costs on a quarterly or monthly basis. The present invention also provides the advantage of being able to forecast income and expenditures for each fiscal year. The present invention also provides the advantage of being able to identify changes in the final forecast by retaining future expected costs for each processing month. The present invention also provides the advantage of being able to grasp when deviations between plans and actual results occur by managing incurred costs and expected costs for each monthly processing period, thereby enabling the analysis of the causes of the deviations and the refinement of future plans. The present invention also provides the advantage of being able to calculate forecasts as of the end of the current fiscal year. The present invention also provides the advantage of being able to quickly confirm information necessary for management decisions by forecasting income and expenditures based on expected costs. The present invention also provides the advantage of being able to grasp changes in expected costs for each processing month, thereby visualizing the causes and taking countermeasures more quickly, contributing to the refinement of income and expenditure forecasts through trend analysis. Furthermore, the present invention has the effect of improving the accuracy of income and expenditure forecasts by making it possible to grasp income and expenditure for each fiscal year.Furthermore, the present invention has the effect of registering not only the final income and expenditure but also the estimated costs for grasping income and expenditure for each fiscal year, switching between actual and estimated results based on the base date, and querying data using an analysis screen. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a project balance management device according to this embodiment. [Figure 2] FIG. 2 is a flowchart showing an example of the processing of the project balance management device in this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of the project balance management process in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of the project balance management process in this embodiment. [Figure 5]FIG. 5 is a diagram showing an example of the project balance management process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the project balance management process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of the project balance management process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the project balance management process in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the project balance management process in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the project balance management process in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the project balance management process in this embodiment. [Figure 12] FIG. 12 is a diagram showing an example of the project balance management process in this embodiment. [Figure 13] FIG. 13 is a diagram showing an example of the project balance management process in this embodiment. [Figure 14] FIG. 14 is a diagram showing an example of the project balance management process in this embodiment. [Figure 15] FIG. 15 is a diagram showing an example of a cost-based budget / actual variance analysis in this embodiment. [Figure 16] FIG. 16 is a diagram showing an example of a cost-based budget / actual variance analysis in this embodiment. [Figure 17] FIG. 17 is a diagram showing an example of a cost-based budget / actual variance analysis in this embodiment. [Figure 18] FIG. 18 is a diagram showing an example of a cost-based budget / actual variance analysis in this embodiment. [Figure 19] FIG. 19 is a diagram showing an example of the annual balance analysis by cost in this embodiment. [Figure 20] FIG. 20 is a diagram showing an example of the annual balance analysis by cost in this embodiment. [Figure 21]FIG. 21 is a diagram showing an example of the annual balance analysis by cost in this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0018] [1. Overview] First, an outline of the present invention will be described.

[0019] Traditionally, systems used in the construction industry and other sectors have been designed to capture final income and expenditures, so forecasts of income and expenditures for each fiscal year have often been made outside the system.

[0020] Therefore, in this embodiment, a system is provided that automatically calculates the estimated cost at the end of the current fiscal year by allowing estimated costs to be registered for each future month in the final forecast.

[0021] In this embodiment, basic information about the project is registered as the project basic information input, the order amount for each construction project is registered as the contract information input, the budget for each project cost category such as material costs, subcontract costs, labor costs, and expenses is registered as the budget input, actual results linked to the project number, order number, and order line number registered in the project basic information input and contract information input are registered as the registration of each cost (purchase input, project cost accounting input, etc.), and the estimated final amount is registered as the final forecast input. Note that in the final forecast input program in this embodiment, costs for past months (including the current month) are automatically set from the actual costs using the current monthly as the base (they are only displayed on the screen and cannot be modified), and the values ​​registered in the monthly processing for the previous month are set as the initial values ​​for future months' costs.

[0022] [2. Configuration] An example of the configuration of a project balance management apparatus 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a project balance management apparatus 100 according to this embodiment.

[0023] 1, the project balance management apparatus 100 is a commercially available desktop personal computer. Note that the project balance management apparatus 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0024] The project balance management apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the project balance management apparatus 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0025] The communication interface unit 104 communicably connects the project balance management apparatus 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the project balance management apparatus 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).

[0026] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0027] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes a basic information management master 106a, a monthly period master 106b, and a project database 106c.

[0028] The basic information management master 106a is a master in which the fiscal year, the beginning year and month, and the fiscal year and month are set.

[0029] The monthly period master 106b is a master that associates the start and end of each month.

[0030] The project database 106c stores project information for each project. The project database 106c may store project information including contract information that sets the order period for the project and budget information that sets the budget amount for each cost item for the project. The project information may also include project planned cost information and project analysis information.

[0031] The control unit 102 is a CPU or the like that performs overall control of the project income and expenditure management apparatus 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. Functionally, the control unit 102 conceptually includes a project registration unit 102a, a cost detail acquisition unit 102b, an update unit 102c, and an analysis acquisition unit 102d.

[0032] The project registration unit 102a registers project information. Here, the project registration unit 102a may register project planned cost information. Furthermore, the project registration unit 102a may register project planned cost information that is set by linking the estimated monthly actual amount, estimated annual actual amount, and estimated actual amount for the next fiscal year and thereafter for each cost item during the order acceptance period, based on the project information.

[0033] The cost detail acquiring unit 102b acquires project cost details in which the monthly actual amount has been set. Here, the cost detail acquiring unit 102b may acquire project cost details in which the monthly actual amount has been set for each cost item.

[0034] The updating unit 102c updates the planned project cost information. Here, the updating unit 102c may update the planned project cost information based on the project cost details. Furthermore, the updating unit 102c may replace the estimated monthly actual amount for each cost item set in the planned project cost information with the actual monthly amount based on the project cost details, and update the estimated actual annual amount and the estimated actual amounts for the following fiscal year and thereafter set in the planned project cost information based on the difference between the estimated monthly actual amount and the actual monthly amount.

[0035] The analysis acquisition unit 102d acquires project analysis information. Here, the analysis acquisition unit 102d may acquire project analysis information for a predetermined period based on the project planned cost information. Furthermore, the analysis acquisition unit 102d may acquire project analysis information that sets a predetermined period actual amount obtained by summing the monthly actual amounts for each cost item for each predetermined period based on the project planned cost information. Furthermore, the analysis acquisition unit 102d may acquire project analysis information that sets an annual estimated actual amount for each predetermined period, an estimated actual amount for the following fiscal year, and the difference between the estimated actual amount for the current fiscal year and the estimated actual amount for the following fiscal year, based on the project planned cost information. Furthermore, when a cost item and a predetermined period are set on the analysis screen, the analysis acquisition unit 102d may acquire project analysis information for the cost item for the predetermined period based on the project planned cost information. Furthermore, the analysis acquisition unit 102d may display the project analysis information. Here, the predetermined period may be a month, a quarter, a trimester, or a half year.

[0036] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0037] [Project Income and Expenditure Management Processing] An example of the project balance management process in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a flowchart showing an example of the process of the project balance management apparatus 100 in this embodiment.

[0038] As shown in FIG. 2, the project registration unit 102a registers project planned cost information in the project database 106c, which is set by linking the expected monthly actual amount for each cost item during the order period, the expected annual actual amount, and the expected actual amount for the following fiscal year and beyond, based on the project information stored in the project database 106c (step SA-1).

[0039] Then, the cost detail obtaining unit 102b obtains, as a monthly process, project cost details in which the monthly actual amount incurred for each cost item is set (step SA-2).

[0040] Then, based on the project cost details, the updating unit 102c replaces the monthly actual amount expected to be incurred for each cost item set in the project planned cost information stored in the project database 106c with the monthly actual amount, and updates the annual actual amount expected to be incurred and the estimated actual amounts for the following fiscal year and thereafter set in the project planned cost information stored in the project database 106c based on the difference between the monthly actual amount expected to be incurred and the monthly actual amount (step SA-3).

[0041] Then, the analysis acquisition unit 102d determines whether or not an analysis instruction specifying a cost item and a predetermined period has been set by the user via the input device 112 on the analysis screen displayed on the output device 114 (step SA-4).

[0042] If the analysis acquisition unit 102d determines that an analysis instruction has not been set on the analysis screen (step SA-4: No), the analysis acquisition unit 102d moves the process to step SA-2.

[0043] On the other hand, if the analysis acquisition unit 102d determines that an analysis instruction has been set on the analysis screen (step SA-4: Yes), it moves the process to step SA-5.

[0044] Then, based on the project planned cost information, the analysis acquisition unit 102d acquires project analysis information that sets the actual amount expected to be incurred in the fiscal year for each specified period, the actual amount expected to be incurred in the following fiscal year and thereafter, and the difference between the actual amount expected to be incurred in the current fiscal year and the actual amount expected to be incurred in the following fiscal year and thereafter (step SA-5).

[0045] Then, the analysis acquisition unit 102d determines whether the current time is the final month of the order period based on the monthly period master 106b and the project information (step SA-6).

[0046] If the analysis and acquisition unit 102d determines that the current time is not the final month of the order period (step SA-6: No), it moves the process to step SA-2.

[0047] If the analysis and acquisition unit 102d determines that the current time is the final month of the order period (step SA-6: Yes), it ends the process.

[0048] An example of the project balance management process in this embodiment will now be described with reference to Fig. 3 to Fig. 14. Fig. 3 to Fig. 14 are diagrams showing an example of the project balance management process in this embodiment.

[0049] As shown in FIG. 3, in this embodiment, when an order is received for a project that is scheduled to be concluded on April 1, 2022, and sales are scheduled for March 31, 2024, the basic information management master 106a and the monthly period master 106b are referenced. Here, the fiscal year set in the basic information management master 106a in this embodiment may store the current fiscal year and be updated at the completion of monthly processing at the end of the current fiscal year (monthly processing in March 2023), the start month may store the start month of the current fiscal year and be updated at the completion of monthly processing at the end of the current fiscal year (monthly processing in March 2023), and the fiscal year and month may store the current processing year and month and be updated at the time of monthly processing for the current month (monthly processing in April 2022). Furthermore, the month numbers set in the monthly period master 106b in this embodiment are numbered 1 to 12 for each month of each year (the start of the period is numbered 1 and the end of the period is numbered 12).

[0050] 4, in this embodiment, when the contract is concluded in April 2022, project basic information is set, contract information for the project order is set, and budget information for the project budget is set, thereby setting project planned cost information. Here, in the project planned cost information in this embodiment, for yyyyMM01 to yyyyMM12, the current year (2022) is obtained from the fiscal year set in the basic information management master 106a, the monthly period master 106b is referenced from the fiscal year set in the basic information management master 106a, item names are set in month number order (yyyyMM01⇒202204, yyyyMM02⇒202205), and the expected occurrence from April 2022 onwards is registered as 100,000 yen as the final forecast input. In addition, in the project planned cost information of this embodiment, for amounts incurred in the previous fiscal year and earlier, the current fiscal year (2022) is obtained from the fiscal year in the basic information management master 106a, the fiscal year and month of the last fiscal year (202203) is obtained from the monthly period master 106b, the project number, order number, and order line number are obtained from the budget information, and the fiscal year and month (prior to the fiscal year and month of the last fiscal year) are obtained, and the amounts are aggregated by cost item category. In addition, in the project planned cost information of this embodiment, for costs of past months (including the current month), the processing year and month (202204) is obtained from the fiscal year and month set in the basic information management master 106a, the project number, order number, order line number, and fiscal year and month are set from the cost details, costs for each cost item category are aggregated and set, costs prior to the current month are locked and cannot be changed, future month costs are set from the input results of the previous month, and the final forecast is referenced to the project budget.

[0051] 5, in this embodiment, when costs are recorded in April 2022, project cost details that set the actual costs incurred for each cost item for April 2022 are obtained through each cost registration (purchase input, project cost recording input, etc.), and the costs incurred for each cost item for the current month and the estimated costs for each cost item for future months are initially displayed based on the project cost details, and the project planned cost information is updated. Here, in the project planned cost information in this embodiment, the estimated actual costs incurred for the fiscal year are set as the cumulative total (cumulative total from yyyyMM01 to yyyyMM12) of the actual costs incurred up to the current month and the estimated amounts (input values) from the following month onwards, and the estimated actual costs for the following fiscal year and beyond are set as the estimated amount obtained by subtracting the amount incurred in the previous fiscal year and earlier and the estimated actual costs incurred for the fiscal year from the final forecast. In the project planned cost information in this embodiment, the accounting year and month set in the basic information management master 106a is set as the accounting year and month, and the base months 1 to 12 are set as the initial display yyyyMM01 to yyyyMM12.

[0052] As shown in Figure 6, in this embodiment, when costs are recorded for May 2022, the basic information management master 106a is referenced, and project cost details are obtained by registering each cost, which include the actual costs incurred for each cost item for May 2022.

[0053] As shown in Figure 7, in this embodiment, the costs incurred for each cost item for the current month and the estimated costs for each cost item for future months are initially displayed based on the project cost details, and the project planned cost information is updated. Here, in the project planned cost information in this embodiment, the estimated costs from June 2022 onwards are registered as 100,000 yen as the final forecast input. Furthermore, because the project planned cost information in this embodiment includes the accounting year and month as a key, updated information for the following month and beyond can be added and updated without deleting information from the current month onwards.

[0054] As shown in Figure 8, in this embodiment, when recording costs from April 2022 to March 2023, the basic information management master 106a is referenced, and by registering the costs of each incurred cost, project cost details are obtained that set the actual costs incurred for each cost item from April 2022 to March 2023.

[0055] As shown in FIGS. 9 to 12, in this embodiment, the project planned cost information is updated and set based on the project cost details for each month.

[0056] As shown in Figure 13, in this embodiment, the basic information management master 106a is referenced, and when costs are recorded in April 2023, the new fiscal year, project cost details are obtained by registering each cost, setting out the actual costs incurred for each cost item for April 2023.

[0057] As shown in Figure 14, in this embodiment, the amounts incurred in the previous year and earlier, the costs incurred for each cost item in the current month, and the estimated costs for each cost item in future months are initially displayed based on the project cost details, and the project planned cost information is updated. In this embodiment, the amounts incurred in the previous year and earlier are aggregated from the project cost details. Furthermore, in the project planned cost information in this embodiment, the estimated costs from May 2023 onwards are registered as ¥100,000 as the final forecast input.

[0058] An example of a cost-specific budget / actual variance analysis in this embodiment will be described with reference to Figures 15 to 18. Figures 15 to 18 are diagrams showing an example of a cost-specific budget / actual variance analysis in this embodiment.

[0059] In this embodiment, as shown in FIG. 15, when a user specifies a project number, order number, order line number, and cost account category on the analysis screen and selects an analysis method, the project planned costs from April 2022 to March 2023 are acquired as the analysis source data from the project number, order number, order line number, and cost account category specified on the analysis screen, as shown in FIG. 16. The acquired results are re-extracted for each analysis method, and as shown in FIG. 17, the acquired results are output on a monthly basis without being re-extracted. As shown in FIG. 18, the end-of-quarter results are re-acquired from the acquired results (results in the monthly period master 106b where the month number is a multiple of 3) and output. In this way, in this embodiment, results are output using the analysis method (monthly or quarterly) specified for base months 1 to 12 set in the project planned cost information. Therefore, by managing the estimated costs for each processing year and month, it is possible to determine when deviations from the plan occurred, and discrepancies between forecasts and actual results can be identified, allowing for review of when the plan should have been revised.

[0060] An example of the annual balance analysis by cost in this embodiment will be described with reference to Figures 19 to 21. Figures 19 to 21 are diagrams showing an example of the annual balance analysis by cost in this embodiment.

[0061] In this embodiment, as shown in Figure 19, when the user specifies the project number, order number, order line number, and cost account category on the analysis screen and selects an analysis method, as shown in Figure 20, the project planned costs from April 2022 to March 2023 are obtained as the source data for analysis from the project number, order number, order line number, and cost account category specified on the analysis screen, and the obtained results are re-extracted according to the analysis method.As shown in Figure 21, the order date and scheduled completion date are referenced from the contract information of the project order, and the "difference from the following year onwards = expected actual results for the fiscal year - expected actual results for the following fiscal year onwards" is calculated, and the obtained results are output on a monthly basis without being re-extracted, and on a quarterly basis, the end-of-quarter results are re-obtained from the obtained results (monthly period master 106b. results where the month number is a "multiple of 3" are obtained) and output. In this way, in this embodiment, the results of the expected actual costs for the current year and the expected actual costs for the following year and beyond set in the project planned cost information are output using the specified analysis method (monthly or quarterly), making it possible to analyze the balance between the current year and the following year, and to check at what point the balance has fluctuated significantly, and in analyzing labor costs, it becomes possible to consider assignments based on the balance results.

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

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

[0064] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0065] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth 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 using known methods.

[0067] Furthermore, 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 can be changed as desired unless otherwise specified.

[0068] Furthermore, with regard to the project balance management apparatus 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0069] For example, all or any part of the processing functions of the project balance management apparatus 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the project balance management apparatus 100 as needed. That is, a computer program for issuing 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 (Hard Disk Drive). The computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0070] This computer program may also be stored in an application program server connected to the project income and expenditure management apparatus 100 via any network, and all or part of it may be downloaded as needed.

[0071] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or 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.

[0072] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0073] The various databases stored in the memory unit 106 are storage means such as 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 providing websites.

[0074] The project balance management apparatus 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The project balance management apparatus 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0075] 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0076] The present invention is useful in industries such as the IT industry, the equipment industry with a large number of projects, and the construction industry, which makes profit and loss forecasts based on projected results. [Explanation of symbols]

[0077] 100 Project Income and Expenditure Management Device 102 Control section 102a Project Registration Department 102b Cost Detail Acquisition Department 102c update section 102d Analysis and acquisition department 104 Communication interface unit 106 Storage section 106a Basic Information Management Master 106b Monthly Period Master 106c Project Database 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A project balance management device comprising a storage unit and a control unit, The storage unit a project storage means for storing project information including contract information that sets the order period of a project, budget information that sets the budget amount for each cost item of the project, and the monthly actual amount of each cost item that has already occurred for the project; A basic information management master that sets the fiscal year, the start year and month, and the fiscal year and month that hold the current fiscal year, Equipped with The control unit a project registration means for registering the estimated project cost information set by linking the estimated actual monthly amount, the estimated actual amount for the current year, and the estimated actual amount for the next year and after for each cost item in the current year, by specifying the estimated actual monthly amount for each cost item that has already occurred in the current year before the current year and month from the project information, by taking in the estimated actual monthly amount for each cost item that has already occurred in the current year before the current month from the project information, by registering the estimated actual monthly amount for each cost item that has not yet occurred in the current year and after the current year input by the user, by calculating the estimated actual monthly amount for the previous year and before by summing up the estimated actual monthly amount for the current year, by calculating the estimated actual annual amount by summing up the estimated actual monthly amount for the current year and the estimated actual monthly amount for the current year, and by calculating the estimated actual annual amount for the current year and after by subtracting the estimated actual monthly amount for the current year and before and the estimated actual annual amount from the budget amount; a cost detail acquisition means for registering project cost details in which the actual monthly cost incurred for each cost item registered by the user for that month is set when the cost is recorded for that month; an updating means for updating the project planned cost information by, at the time of recording the costs for the month, replacing the monthly actual amount to be incurred for the month set in the project planned cost information with the monthly actual amount for each cost item set in the project cost details for the month, updating the annual actual amount to be incurred set in the project planned cost information with the total amount of the monthly actual amount to be incurred and the monthly actual amount to be incurred for the current fiscal year after the replacement, and updating the estimated actual amount for the next fiscal year and thereafter set in the project planned cost information with the difference obtained by subtracting the amounts incurred for the previous fiscal year or earlier and the total amount from the budget amount; an analysis and acquisition means for acquiring project analysis information that sets the actual amount expected to be incurred in the current year, the actual amount expected to be incurred in the next year and thereafter, and the difference from the next year and thereafter by subtracting the actual amount expected to be incurred in the current year from the actual amount expected to be incurred in the current year and the actual amount expected to be incurred in the next year and thereafter, and the difference from the next year and thereafter, using the project planned cost information of the project as analysis source data when the user specifies the project, the cost item, and a predetermined period in the analysis screen; A project balance management device comprising:

2. The analysis and acquisition means The project income and expenditure management device according to claim 1, further comprising: a project analysis information setting an actual amount incurred for a predetermined period, the actual amount being the sum of the monthly actual amount incurred for each cost item for each predetermined period, using the project planned cost information as the analysis source data;

3. The analysis and acquisition means 3. A project balance management device according to claim 1, further comprising: a display unit for displaying the project analysis information.

4. The predetermined period is 3. The project income and expenditure management device according to claim 1, wherein the time period is one month, one quarter, one trimester, or one half year.

5. A project balance management method to be executed by a project balance management device having a storage unit and a control unit, The storage unit a project storage means for storing project information including contract information that sets the order period of a project, budget information that sets the budget amount for each cost item of the project, and the monthly actual amount of each cost item that has already occurred for the project; A basic information management master that sets the fiscal year, the start year and month, and the fiscal year and month that hold the current fiscal year, Equipped with Executed in the control unit: a project registration step of specifying the current fiscal year and current year and month from the fiscal year and fiscal month set in the basic information management master, fetching from the project information the monthly actual amount for each cost item that has already occurred in the current fiscal year before the current month, registering the estimated monthly actual amount for each cost item that has not yet occurred in the current fiscal year or later that was input by the user, calculating the amount incurred in the previous fiscal year or earlier by summing up the actual amounts incurred in the month for the previous fiscal year or earlier, calculating the estimated actual amount for the current fiscal year by summing up the actual amount incurred in the month for the current fiscal year and the estimated actual amount for the current fiscal year, and calculating the estimated actual amount for the fiscal year or later that is the next fiscal year or later of the current fiscal year by subtracting the amount incurred in the previous fiscal year or earlier and the estimated actual amount for the current fiscal year from the budget amount, thereby registering project planned cost information that is set by linking the estimated actual amount for the current fiscal year, the estimated actual amount for the current fiscal year, and the estimated actual amount for the next fiscal year or later for each cost item in the current fiscal year; a cost detail acquisition step of registering project cost details in which the actual monthly amount of each cost item registered by the user for the month is set when the monthly cost is recorded; an updating step of updating the project planned cost information by replacing the monthly actual amount for the month set in the project planned cost information with the monthly actual amount for each cost item set in the project cost details for the month at the time of recording the costs for the month, updating the annual actual amount set in the project planned cost information with the total amount of the monthly actual amount and the monthly actual amount set in the project planned cost information after the replacement, and updating the estimated actual amount for the next fiscal year and thereafter set in the project planned cost information with the difference obtained by subtracting the amounts incurred in the previous fiscal year or earlier and the total amount from the budget amount; an analysis and acquisition step of, when the user specifies the project, the cost item, and a predetermined period on an analysis screen, using the project planned cost information of the project as analysis source data, extracting the actual amount expected to be incurred in the current fiscal year for the final month of each predetermined period in the current fiscal year and the actual amount expected to be incurred in the following fiscal year and thereafter for the final month, and calculating the difference between the actual amount expected to be incurred in the current fiscal year and thereafter and the amount expected to be incurred in the following fiscal year and thereafter by subtracting the actual amount expected to be incurred in the current fiscal year from the actual amount expected to be incurred in the current fiscal year and the actual amount expected to be incurred in the following fiscal year and thereafter, thereby acquiring project analysis information that sets the actual amount expected to be incurred in the current fiscal year, the actual amount expected to be incurred in the following fiscal year and thereafter, and the difference between the actual amount expected to be incurred in the following fiscal year and thereafter; A project income and expenditure management method comprising:

6. A project balance management program to be executed by a project balance management device having a storage unit and a control unit, The storage unit a project storage means for storing project information including contract information that sets the order period of a project, budget information that sets the budget amount for each cost item of the project, and the monthly actual amount of each cost item that has already occurred for the project; A basic information management master that sets the fiscal year, the start year and month, and the fiscal year and month that hold the current fiscal year, Equipped with In the control unit, a project registration step of specifying the current fiscal year and current year and month from the fiscal year and fiscal month set in the basic information management master, fetching from the project information the monthly actual amount for each cost item that has already occurred in the current fiscal year before the current month, registering the estimated monthly actual amount for each cost item that has not yet occurred in the current fiscal year or later that was input by the user, calculating the amount incurred in the previous fiscal year or earlier by summing up the actual amounts incurred in the month for the previous fiscal year or earlier, calculating the estimated actual amount for the current fiscal year by summing up the actual amount incurred in the month for the current fiscal year and the estimated actual amount for the current fiscal year, and calculating the estimated actual amount for the fiscal year or later that is the next fiscal year or later of the current fiscal year by subtracting the amount incurred in the previous fiscal year or earlier and the estimated actual amount for the current fiscal year from the budget amount, thereby registering project planned cost information that is set by linking the estimated actual amount for the current fiscal year, the estimated actual amount for the current fiscal year, and the estimated actual amount for the next fiscal year or later for each cost item in the current fiscal year; a cost detail acquisition step of registering project cost details in which the actual monthly occurrence amount for each cost item registered by the user for the month is set when the monthly costs are recorded; an updating step of updating the project planned cost information by replacing the estimated monthly actual amount for the month set in the project planned cost information with the monthly actual amount for each cost item set in the project cost details for the month at the time of recording the costs for the month, updating the estimated annual actual amount set in the project planned cost information with the total of the monthly actual amount and estimated monthly actual amount for the current fiscal year after the replacement, and updating the estimated actual amount for the next fiscal year and thereafter set in the project planned cost information with the difference obtained by subtracting the amount incurred in the previous fiscal year or earlier and the total amount from the budget amount; an analysis and acquisition step of, when the user specifies the project, the cost item, and a predetermined period on an analysis screen, using the project planned cost information of the project as analysis source data, extracting the actual amount expected to be incurred in the current fiscal year for the final month of each predetermined period in the current fiscal year and the actual amount expected to be incurred in the following fiscal year and thereafter for the final month, and calculating the difference between the actual amount expected to be incurred in the current fiscal year and thereafter and the amount expected to be incurred in the following fiscal year and thereafter by subtracting the actual amount expected to be incurred in the current fiscal year from the actual amount expected to be incurred in the current fiscal year and the actual amount expected to be incurred in the following fiscal year and thereafter, thereby acquiring project analysis information that sets the actual amount expected to be incurred in the current fiscal year, the actual amount expected to be incurred in the following fiscal year and thereafter, and the difference between the actual amount expected to be incurred in the following fiscal year and thereafter; A project income and expenditure management program for carrying out the project.

Images