Project management system, project management method, and project management program

Abstract

To provide a project management system that allows a parent company to quickly grasp an unrealized profit arising from transaction with a subsidiary company when a project is shared and executed among companies within a scope of consolidated accounting objects.SOLUTION: A project management system of an embodiment includes: project registration means that registers contract details including project identification information and a status class indicating whether a project is completed or not for a parent company; cost registration means that registers purchase data including a date, an invoice number, a supplier, a product, a tax-excluded amount, and project identification information for the parent company; and unrealized profit amount calculation means that tallies up, on the basis of the purchase data, for each project identification information of the parent company, subtracts a net asset amount, which is a total amount of cost amounts of cost information for project identification information of a subsidiary company linked to the project identification information of the parent company by the unrealized profit aggregated asset-contract details master, from a tax-excluded amount of the product registered in an asset target product master, and calculates an unrealized profit amount.SELECTED DRAWING: Figure 1

Description

[Technical Field]

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

[0002] For example, in the IT industry, software package development is often shared among consolidated group companies. In such cases, costs incurred in developing a single piece of software involve buying and selling. In the case of group companies, the parent company's software suspense account includes unrealized profits, so when viewed on a consolidated basis, it is necessary to understand the amount excluded. For example, Patent Document 1 is a conventional system for managing unrealized profits in consolidated accounting. [Prior art documents] [Patent documents]

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

[0004] However, the above-mentioned Patent Document 1 does not state anything about a parent company being able to quickly identify unrealized profits arising from transactions with subsidiaries when a project is shared and executed by companies within the scope of consolidated accounting.

[0005] The present invention has been made in consideration of the above, and aims to provide a project management system, a project management method, and a project management program that enable a parent company to quickly grasp unrealized profits arising from transactions with subsidiaries when a project is shared and executed by companies within the scope of consolidated accounting. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a project management system having a control unit, the control unit being configured to be able to access a storage area storing a consolidated supplier master in which subsidiaries that are suppliers to be consolidated accounting are registered, an asset product master in which capitalized products, completed account items, and uncompleted account items are registered in association with each other, cost information including project identification information, cost items, and cost amounts for subsidiaries, and an unrealized profit summary asset-contract detail master in which project identification information of a parent company and project identification information of subsidiaries are registered in association with each other, and a storage area storing a consolidated supplier master in which project identification information, completion or uncompletion of a project is specified for a parent company ... a cost registration means for registering purchase data for a parent company, including a date, a slip number, a supplier, a product, a tax-excluded amount, and project identification information; and an unrealized profit calculation means for calculating an unrealized profit by aggregating the purchase data for each project identification information of the parent company in the contract details based on the purchase data and subtracting the net asset amount, which is the total of the cost amounts of the cost information for the project identification information of the subsidiary linked to the project identification information of the parent company in the unrealized profit aggregation asset-contract detail master, from the tax-excluded amount of the product registered in the asset target product master.

[0007] Furthermore, according to one aspect of the present invention, the unrealized profit calculation means may further create and output an unrealized profit statement including project identification information, supplier, product, amount excluding tax, unrealized profit amount, net asset amount, and account name.

[0008] According to another aspect of the present invention, the unrealized profit calculation means may not tally up products that are not registered in the asset target product master.

[0009] Furthermore, according to one aspect of the present invention, the unrealized profit calculation means may set the "account name" of the unrealized profit statement by obtaining the "account item at completion" from the asset target product master using the product as a key if the status classification in the contract details is "completed," and by obtaining the "account item at incomplete" from the asset target product master using the product as a key if the status classification in the contract details is "uncompleted."

[0010] According to another aspect of the present invention, the control unit may further include an asset information processing means for creating asset information based on the unrealized profit statement and outputting the asset information to a fixed asset system.

[0011] According to another aspect of the present invention, the completed account item may include software, and the non-completed account item may include a software provisional account.

[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides a project management method executed by an information processing device having a control unit, wherein the control unit is configured to be able to access a storage area that stores a consolidated supplier master in which subsidiaries that are suppliers to be consolidated accounting are registered, an asset target product master in which capitalized products, completed account items, and uncompleted account items are registered in association with each other, cost information including project identification information, cost items, and cost amounts for subsidiaries, and an unrealized profit summary asset-contract detail master in which project identification information of a parent company and project identification information of subsidiaries are registered in association with each other, and the control unit is configured to be able to access a storage area that stores a consolidated supplier master in which subsidiaries that are suppliers to be consolidated accounting are registered in association with each other, and a project management method executed by the control unit that stores a consolidated supplier master in which capitalized products, completed account items, and uncompleted account items are registered in association with each other, and an asset-contract detail master in which project identification information of a parent company and project identification information of subsidiaries are registered in association with each other, and a cost registration step of registering purchase data for a parent company, including a date, a slip number, a supplier, a product, a tax-exempt amount, and project identification information; and an unrealized profit calculation step of calculating an unrealized profit by aggregating the purchase data for each project identification information of the parent company in the contract details based on the purchase data and subtracting the net asset amount, which is the total of the cost amounts of the cost information for the project identification information of subsidiaries linked to the project identification information of the parent company in the unrealized profit aggregation asset-contract detail master, from the tax-exempt amount of the product registered in the asset target product master.

[0013] In order to solve the above-mentioned problems and achieve the object, the present invention provides a project management program to be executed by an information processing device having a control unit, the control unit being configured to be able to access a storage area that stores a consolidated supplier master in which subsidiaries that are suppliers to be consolidated accounting are registered, an asset target product master in which capitalized products, completed account items, and uncompleted account items are registered in association with each other, cost information including project identification information, cost items, and cost amounts for subsidiaries, and an unrealized profit summary asset-contract detail master in which project identification information of a parent company and project identification information of subsidiaries are registered in association with each other, and the control unit is configured to be able to access a storage area that stores a consolidated supplier master in which project identification information, completed or uncompleted account items, and an asset target product master in which capitalized products, completed or uncompleted account items are registered in association with each other, for the parent company, a cost registration step of registering purchase data for a parent company, including a date, a slip number, a supplier, a product, a tax-exempt amount, and project identification information; and an unrealized profit calculation step of calculating the unrealized profit amount by aggregating the purchase data for each project identification information of the parent company in the contract details based on the purchase data and subtracting the net asset amount, which is the total of the cost amounts of the cost information for the project identification information of subsidiaries linked to the project identification information of the parent company in the unrealized profit aggregation asset-contract detail master, from the tax-exempt amount of the product registered in the asset target product master. [Effects of the Invention]

[0014] According to the present invention, when a project is shared and executed by companies within the scope of consolidated accounting, it is possible for a parent company to quickly grasp unrealized profits arising from transactions with its subsidiaries. [Brief explanation of the drawings]

[0015] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a project management system according to the present embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the configuration of the linked supplier master data. [Figure 3]FIG. 3 is a diagram illustrating an example of the configuration of the asset target product master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the unrealized profit total asset-contract details master. [Figure 5] FIG. 5 is a flow diagram showing an example of the overall processing of the project management system according to this embodiment. [Figure 6] FIG. 6 is a flow diagram showing an example of the overall processing of the subsidiary system according to this embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the project management system and the subsidiary system according to this embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the project management system and the subsidiary system according to this embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the project management system and the subsidiary system according to this embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the project management system and the subsidiary system according to this embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the project management system and the subsidiary system according to this embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the project management system and the subsidiary system according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A project management system, a project management method, and a project management program according to an embodiment of the present invention will be described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the present embodiment.

[0017] [1: Overview] For example, in the IT industry, it is common for a company to outsource some or all of its software development to a consolidated subsidiary. In such cases, it is assumed that the outsourcing costs paid to the consolidated subsidiary include profits. In other words, if you only look at individual accounting figures, the software in progress account will include unrealized profits for consolidated accounting purposes until the software is completed, and the assets that are capitalized upon completion of the software will also include unrealized profits for consolidated accounting purposes. Because the software in progress account, excluding unrealized profits, represents the actual amount, understanding it without waiting for legal consolidation will lead to improved management efficiency.

[0018] However, in the past, accurate suspense accounts could not be determined without waiting for a quarter due to complex consolidated financial statements.

[0019] Therefore, in this embodiment, a system has been constructed that makes it possible to grasp early on the unrealized profits that accompany transactions when a project is shared and executed by companies within the scope of consolidated accounting.

[0020] Specifically, the project management system of this embodiment has been designed with consolidated accounting in mind, something not found in conventional project management system + fixed asset systems. By aggregating the cost amounts of each company, it is possible to manage unrealized profits and consolidated asset amounts (net asset amounts). Furthermore, by linking accurate project management costs, it becomes possible to grasp precise figures. Furthermore, by utilizing the project management system + fixed asset system, it becomes possible to centrally manage unrealized software suspense accounts + software on a detail-by-detail basis, and grasp the latest amounts that take depreciation expenses into account on a monthly basis.

[0021] Furthermore, by managing unrealized profits, the project management system of this embodiment allows for the immediate confirmation of consolidated asset amounts before linking to the fixed asset system or consolidated accounting system, which allows for faster processing than the consolidation procedures of a regular consolidated accounting system, thereby accelerating consolidated financial settlement. By managing depreciation calculations for consolidated asset amounts in parallel with the fixed asset management of individual companies, figures can be grasped at an earlier stage than when depreciation is calculated after linking to the consolidated accounting system, thereby accelerating consolidated financial settlement. Furthermore, even if the consolidated accounting system does not use monthly consolidated financial settlement units, by utilizing the project management system + fixed asset system, figures can be grasped on a monthly basis for each individual company, allowing for an early grasp of management figures that take consolidation into consideration.

[0022] The project management system of the present invention is widely applicable to industries where projects are shared and executed by companies within the scope of consolidated accounting, such as IT companies, the service industry, and the construction industry.

[0023] [2. Configuration] An example of the configuration of a project management system according to this embodiment will be described with reference to FIG. 1 and other figures. FIG. 1 is a block diagram showing an example of the configuration of a project management system 100 according to this embodiment. The project management system 100 according to this embodiment is communicatively connected to a server 200, a fixed asset management system 400, a consolidated accounting system 500, a subsidiary system 600, etc. via a network 300. The project management system 100 is used, for example, by a parent company (e.g., parent company X) when a project is to be shared and executed by companies within the consolidated accounting system. The subsidiary systems 600, etc. are used by subsidiaries (e.g., subsidiary Y) when a project is to be shared and executed by companies within the consolidated accounting system.

[0024] The project management system 100 is, for example, a commercially available desktop personal computer or workstation.

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

[0026] The communication interface unit 104 communicatively connects the project management system 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 exchanging data with other devices via the communication line. Here, the network 300 has a function of communicatively connecting the project management system 100 with the server 200, the fixed asset management system 400, and the consolidated accounting system 500, and is, for example, the Internet or a LAN (Local Area Network). The project management system 100 is configured to be able to access the memory unit 606 of the subsidiary system 600, and can acquire data in real time from the contract details table 606a, purchase table 606b, cost information table 606c, etc., stored in the memory unit 606.

[0027] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. Note that, hereinafter, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as a "user operation via a UI."

[0028] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0029] The memory unit (memory area) 106 stores, for example, a consolidated supplier master 106a, an asset target product master 106b, an unrealized profit total asset-contract detail master 106c, a contract detail table 106d, a purchase table 106e, an unrealized profit statement, an asset information table 106f, etc. Fig. 2 is a diagram showing an example of the configuration of the consolidated supplier master 106a. Fig. 3 is a diagram showing an example of the configuration of the asset target product master 106b. Fig. 4 is a diagram showing an example of the configuration of the unrealized profit total asset-contract detail master 106c.

[0030] The consolidated supplier master 106a is a master for setting suppliers that are subsidiaries of the consolidated accounting target, and can be configured as a table in which the suppliers that are subsidiaries of the consolidated accounting target (supplier CD and / or supplier name) are registered, as shown in Figure 2. The supplier CD is the primary key.

[0031] The asset target product master 106b is a master for setting information on the products to be capitalized, and can be configured with a table or the like that associates and registers the product (product CD and / or product name), the account CD at completion, the account item name at completion, the account CD at non-completion, and the account item name at non-completion, as shown in Figure 3. The supplier CD is the primary key.

[0032] The unrealized profit aggregate asset-contract detail master 106c is a master for linking the parent company's project identification information with the subsidiary's project identification information, and can be configured as a table or the like that associates and registers the asset number, asset name, project identification information (contract detail number and / or contract detail name), and supplier (supplier CD and / or supplier name) of parent company X with the project identification information (contract detail number and / or contract detail name) of subsidiary company Y, as shown in Fig. 4. The asset number is the primary key.

[0033] The contract details table 106d is a table for storing the parent company's contract details. The contract details may include project identification information (contract detail number and / or contract detail name), a direct / indirect cost classification that specifies the classification of direct or indirect costs, a category name that specifies direct or indirect costs, a department CD, a division name, and a status classification that specifies whether the project is completed or incomplete. The contract detail number is the primary key.

[0034] The purchase table 106e is a table for storing the parent company's purchase data. The purchase data may include the date, slip number, supplier (supplier CD and / or supplier name), product (product CD and / or product name), price excluding tax, and project identification information (contract specification number and / or contract specification name). The contract specification number, supplier CD, and product CD are primary keys.

[0035] The asset information table 106f is a table for storing asset information. The asset information may include an asset number, an asset name, an asset type CD, an asset type name, and tax / accounting information (depreciation method, useful life method, memorandum value, acquisition amount, useful life method, memorandum value, and net depreciation method, net useful life method, net memorandum value, net acquisition amount, net useful life method, net memorandum value).

[0036] Returning to Figure 1, the control unit 102 is a CPU or the like that performs overall control of the project management system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0037] The control unit 102 is configured to process the consolidated supplier master 106a, the asset product master 106b, the unrealized profit total asset-contract detail master 106c, the contract detail table 106d, the purchase table 106e, the unrealized profit statement, and the asset information table 106f stored in the storage unit 106. The above may be provided in another location (for example, server 200) as long as the control unit 102 can access them.

[0038] The control unit 102 conceptually includes a master maintenance unit 102a, a project registration unit 102b, a cost registration unit 102c, an unrealized profit calculation unit 102d, an asset information processing unit 102e, and a screen display control unit 102f.

[0039] The master maintenance unit 102a performs settings such as data input, addition, change, and update for the consolidated supplier master 106a, asset target product master 106b, and unrealized profit aggregated asset-contract detail master 106c, in response to, for example, operator operations on a master maintenance screen (not shown) displayed on the monitor 114.

[0040] The project registration unit 102b inputs contract details for direct costs and indirect costs in response to, for example, an operator's operation on a project registration screen (not shown) displayed on the monitor 114, and registers the details in the contract details table 106d.

[0041] The cost registration unit 102c is used to register cost information such as purchase data, and for example, inputs purchase data and registers it in the purchase table 106e in accordance with the operator's operations on a purchase input screen (not shown) displayed on the monitor 114.

[0042] The unrealized profit calculation unit 102d performs aggregation for each project identification information of the contract details based on the purchase data, and calculates the amount of unrealized profit by subtracting the net asset amount, which is the total cost amount of the cost information in the cost information table 606c for the project identification information of the subsidiary linked to the project identification information of the parent company in the unrealized profit aggregation asset-contract details master 106c, from the tax-excluded amount of the product registered in the asset target product master 106b.

[0043] The unrealized profit calculation unit 102d further creates an unrealized profit statement including project identification information, supplier, product, amount excluding tax, unrealized profit amount, net asset amount, and account name, and displays and outputs it on the unrealized profit statement screen while also registering it in the memory unit 106.

[0044] Furthermore, the unrealized profit calculation unit 102d may not tally up products that are not registered in the asset target product master 106b.

[0045] Furthermore, the unrealized profit calculation unit 102d may set the "account name" of the unrealized profit statement by retrieving the "account item at completion" from the asset target product master 106b using the product as a key if the status classification in the contract details is "completed," and by retrieving the "account item at uncompleted" from the asset target product master 106b using the product as a key if the status classification in the contract details is "uncompleted."

[0046] The asset information processing unit 102e creates asset information based on the unrealized profit statement in response to, for example, an operator's operation on the asset information creation screen displayed on the monitor 114, registers the information in the asset information table 106f, and outputs it to the fixed asset management system 400.

[0047] The screen display control unit 102f controls the display and input of various screens displayed on the monitor 114 (for example, a project registration screen, a purchase input screen, an unrealized profit statement screen, an asset information creation screen, a master maintenance screen, etc.).

[0048] The subsidiary system 600 can be configured with hardware similar to that of the project management system 100, and is equipped with a control unit 602, a communication interface unit (not shown), a memory unit 606, and an input / output interface unit (not shown), and a description of the similar hardware configuration will be omitted.

[0049] The storage unit (storage area) 606 stores, for example, a contract details table 606a, a purchase table 606b, a cost information table 606c, and the like.

[0050] The contract details table 606a is a table for storing the contract details of subsidiary company Y. The contract details may include project identification information (contract detail number and / or contract detail name), a direct / indirect cost classification that specifies the classification of direct or indirect costs, a category name that specifies direct or indirect costs, a department CD, a division name, and a status classification that specifies whether the project is completed or incomplete. The contract detail number serves as the primary key.

[0051] The purchase table 606b is a table for storing purchase data for subsidiary company Y. The purchase data may include the date, invoice number, supplier (supplier CD and / or supplier name), product (product CD and / or product name), amount excluding tax, and project identification information (contract specification number and / or contract specification name). The contract specification number, supplier CD, and product CD are primary keys.

[0052] The cost information table 606c is a table for storing cost information for subsidiary company Y. The cost information may include project identification information (contract detail number and / or contract detail name), cost CD, cost item name, and cost amount. The contract detail number, supplier CD, and product CD are primary keys.

[0053] The control unit 602 conceptually includes a project registration unit 602a and a cost registration unit 602b.

[0054] The project registration unit 602a inputs contract details in response to, for example, an operator's operation on a project registration screen (not shown) displayed on the monitor 114, and registers them in a contract details table 606a.

[0055] The cost registration unit 602b is used to register cost information such as purchase data, and for example, inputs purchase data and registers it in the purchase table 606b in accordance with the operator's operations on a purchase input screen (not shown) displayed on the monitor.

[0056] In addition, the cost registration unit 602b creates cost information by aggregating cost amounts (purchase costs of products in the purchase data, labor costs, outsourcing costs, transportation costs, indirect costs, sales costs, administrative costs, etc.) based on the purchase data in the purchase table 606b, and registers this information in the cost information table 606c.

[0057] [3. Specific Examples] 1 to 12, a specific example of the overall processing of the control unit 102 of the project management system 100 and the subsidiary system 600 in this embodiment will be described.

[0058] (3-1. Overall processing of the project management system 100) FIG. 5 is a flowchart for explaining an outline of the overall processing of the control unit 102 of the project management system 100 according to this embodiment.

[0059] An overview of the overall processing of the control unit 102 of the project management system 100 in this embodiment will be described with reference to Figure 5. In Figure 5, the project registration unit 102b executes a contract details registration process (step S1). Specifically, in the contract details registration process, the project registration unit 102b registers contract details for direct costs in the contract details table 106d, for example, in response to an operator's operation on a project registration screen (not shown) displayed on the monitor 114. The project registration unit 102b also executes an indirect project registration process (step S2). Specifically, in the indirect project registration process, the project registration unit 102b registers contract details for indirect costs in the contract details table 106d, for example, in response to an operator's operation on a project registration screen (not shown) displayed on the monitor 114.

[0060] The cost registration unit 102c executes a purchase input process (step S3). Specifically, in the purchase input process, the cost registration unit 102c inputs purchase data in response to, for example, an operator's operation on a purchase input screen (not shown) displayed on the monitor 114, and registers the data in the purchase table 106e.

[0061] The master maintenance unit 102a executes unrealized profit total asset-contract detail master maintenance processing (step S4). In the unrealized profit total asset-contract detail master maintenance processing, the master maintenance unit 102a sets data in the unrealized profit total asset-contract detail master 106c in accordance with, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0062] The unrealized profit calculation unit 102d executes an unrealized profit statement output process (step S5). Specifically, in the unrealized profit statement output process, the unrealized profit calculation unit 102d performs aggregation for each project identification information based on the purchase data, calculates the unrealized profit amount by subtracting the net asset amount, which is the total amount of cost amounts of the cost information in the cost information table 606c for the project identification information of the subsidiary linked to the project identification information of the parent company in the unrealized profit aggregation asset-contract detail master 106c, from the tax-excluded amount of the product registered in the asset target product master 106b, and creates an unrealized profit statement including the project identification information, supplier, product, tax-excluded amount, unrealized profit amount, net asset amount, and account name acquired from the asset target product master 106b, and displays and outputs it on the unrealized profit statement screen displayed on the monitor 114, and also stores it in the storage unit 106.

[0063] In this case, unrealized profits may not be calculated for suppliers that are not subject to consolidated accounting in the consolidated supplier master 106a. Products that are not registered as asset target products in the asset target product master 106b may not be tallied. Regarding the "account item," if the status classification in the contract details is "completed," the "account item at completion" is obtained and set from the asset target product master 106b using the product as a key, and if the status classification in the contract details is "uncompleted," the "account item at uncompleted" is obtained and set from the asset target product master 106b using the product as a key.

[0064] The asset information processing unit 102e executes asset information additional input processing (step S6). Specifically, in the asset information input processing, the asset information processing unit 102e extracts and displays information from the unrealized profit statement and the contract details for the contract detail number linked in the unrealized profit total asset-contract detail master 106c, using the asset number designated by the operator's operation on the asset information creation screen displayed on the monitor 114 as a key, for example, and further creates asset information by adding information related to the assets to the extracted information and registers it in the asset information table 106f.

[0065] The asset information processing unit 102e executes asset information output processing (step S7). Specifically, the asset information processing unit 102e outputs the asset information registered in the asset information table 106f to other systems such as the fixed asset management system 400 and the consolidated accounting system 500.

[0066] (3-2. Overall processing of subsidiary system 600) FIG. 6 is a flowchart for explaining an outline of the overall processing of the control unit 602 of the subsidiary system 600 in this embodiment.

[0067] An overview of the overall processing of the control unit 602 of the subsidiary system 600 in this embodiment will be described with reference to Fig. 6. In Fig. 6, the project registration unit 602a executes a contract details registration process (step T1). Specifically, in the contract details registration process, the project registration unit 602a registers the contract details in a contract details table 606a in response to, for example, an operator's operation on a project registration screen (not shown) displayed on a monitor.

[0068] The cost registration unit 602b executes a purchase input process (step T2). Specifically, in the purchase input process, the cost registration unit 602b inputs purchase data in response to, for example, an operator's operation on a purchase input screen (not shown) displayed on a monitor, and registers the data in the purchase table 606b.

[0069] The cost registration unit 602b executes a cost calculation process (step T3). Specifically, in the cost calculation process, the cost registration unit 602b creates cost information by aggregating cost amounts (purchase costs of products in the purchase data, labor costs, outsourcing costs, transportation costs, indirect costs, sales costs, administrative costs, etc.) based on the purchase data in the purchase table 606b, and registers the cost information in the cost information table 606c.

[0070] (3-3. Sample data) 7 to 12 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the project management system 100 and the control unit 602 of the subsidiary system 600 in this embodiment. A specific example of the processing by the control unit 102 of the project management system 100 and the control unit 602 of the subsidiary system 600 will be explained with reference to FIGS. 7 to 12.

[0071] (Master maintenance processing of project management system 100) 7, a specific example of master maintenance processing of the project management system 100 will be described. The master maintenance unit 102a sets data in advance in the linked supplier master 106a and the asset target product master 106b in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0072] 7(A) is a diagram showing an example of the settings for the linked supplier master 106a. The linked supplier master 106a has fields for supplier CD and supplier name. In the example shown in the figure, the supplier CD is "S001" and the supplier name is "Company Y."

[0073] 7(B) is a diagram showing an example of the settings of the asset target product master 106b. The asset target product master 106b has fields for product CD, product name, account CD at completion, account item name at completion, account CD at completion, and account item name at completion. In the example shown in the figure, the first line has product CD "H001", product name "subcontract cost (asset)", account CD at completion "K001", account item name at completion "software", account CD at completion "K002", and account item name at completion "software in progress", and the second line has product CD "L001", product name "subcontract cost (building)", account CD at completion "K101", account item name at completion "building", account CD at completion "K102", and account item name at completion "construction in progress".

[0074] (S1: Contract Detail Registration Processing and S2: Indirect Project Registration Processing of Project Management System 100) 8, a specific example of the contract details registration process and the indirect project registration process of the project management system 100 will be described. The project registration unit 102b inputs contract details for direct costs and indirect costs in response to, for example, an operator's operation on a project registration screen (not shown) displayed on the monitor 114, and registers them in the contract details table 106d.

[0075] FIG. 8A is a diagram showing an example of contract details registered in the contract details table 106d. The contract details include the following items: contract detail number, contract detail name, direct / indirect category specifying the category of direct cost (1) or indirect cost (2), category name specifying direct cost or indirect cost, department CD, division name, and status category specifying the completed or incomplete status of the project.

[0076] In the example shown in the figure, the first line shows the contract details for direct costs, with the contract detail number "X0001," contract detail name "XPJ-01," direct / indirect category "1," category name "direct," department CD "XB1," department name "System 1," and status category "completed." The fourth line shows the contract details for indirect costs, with the contract detail number "X1001," contract detail name "X System 1 Project," direct / indirect category "2," category name "indirect," department CD "XB1," department name "System 1," and status category "uncompleted."

[0077] (T1 of subsidiary system 600: contract details registration process) 8, a specific example of contract details registration processing in the subsidiary system 600 will be described. The project registration unit 602a inputs contract details in response to, for example, an operator's operation on a project registration screen (not shown) displayed on a monitor, and registers them in a contract details table 606a.

[0078] FIG. 8B is a diagram showing an example of contract details registered in the contract details table 606a. The contract details include the following items: contract detail number, contract detail name, direct / indirect category specifying the category of direct cost (1) or indirect cost (2), category name specifying direct cost or indirect cost, department CD, division name, and status category specifying the completed or incomplete status of the project.

[0079] In the example shown in the figure, the first line shows the contract detail number "Y0001," contract detail name "YPJ-01," direct / indirect classification "1," classification name "direct," department CD "YB1," department name "System 1," and status classification "completed." The second line shows the contract details for indirect costs, and shows the contract detail number "Y0012," contract detail name "System 1 PJ," direct / indirect classification "2," classification name "direct," department CD "YB1," department name "System 1," and status classification "uncompleted."

[0080] (S3 of the project management system 100: Purchase input processing) A specific example of the purchase input process will be described with reference to Fig. 9. The cost registration unit 102c registers purchase data in the purchase table 106e in response to, for example, an operator's operation on a purchase input screen (not shown) displayed on the monitor 114.

[0081] 9(A) is a diagram showing an example of purchase data registered in purchase table 106e. The purchase data has fields for date, slip number, supplier CD, supplier name, product CD, product name, amount excluding tax, contract specification number, and contract specification name. In the example shown in the figure, the first line contains the date "2022 / 4 / 1", slip number "123456789", supplier CD "S001", supplier name "Company A", product CD "H001", product name "Subcontract cost (asset)", amount excluding tax "1,000,000", contract specification number "0001", and contract specification name "PJ-01".

[0082] The suppliers "Company B, Company C, and Company D" on lines 3 to 8 are not registered as suppliers subject to consolidated accounting in the consolidated supplier master 106a, and are therefore not subject to consolidated accounting, so unrealized profits are not calculated in the unrealized profit statement. The product "Advance Payments" on lines 9 to 11 is not registered as an asset-targeted product in the asset-targeted product master 106b, and is therefore not subject to asset calculations, so it is not included in the calculations in the unrealized profit statement.

[0083] (Subsidiary System 600 T2: Purchase Input Processing) 9, a specific example of purchase input processing in the subsidiary system 600 will be described. The cost registration unit 602b inputs purchase data and registers it in the purchase table 606b in response to, for example, an operator's operation on a purchase input screen (not shown) displayed on a monitor.

[0084] 9(B) is a diagram showing an example of purchase data registered in purchase table 106e. The purchase data has fields for date, slip number, supplier CD, supplier name, product CD, product name, amount excluding tax, contract specification number, and contract specification name. In the example shown in the figure, the first line contains the date "2022 / 4 / 1," slip number "234567890," supplier CD "S005," supplier name "Company A," product CD "H003," product name "Consumables," amount excluding tax "900,000," contract specification number "Y0001," and contract specification name "YPJ-01."

[0085] (Project Management System 100 S4: Unrealized Profit Aggregation Asset-Contract Detail Master Maintenance Processing) 10, a specific example of the unrealized profit total asset-contract detail master maintenance process of the project management system 100 will be described. The master maintenance unit 102a sets data in the unrealized profit total asset-contract detail master 106c in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0086] 10 is a diagram showing an example of the settings of the unrealized profit total asset-contract detail master 106c. The unrealized profit total asset-contract detail master 106c includes the following fields: asset number, asset name, contract detail number, contract detail name, supplier CD, supplier name of parent company X, and contract detail number and contract detail of subsidiary company Y.

[0087] In the example shown in the figure, the first line contains parent company X's asset number "XSW0001," asset name "XPJ-01SW," contract detail number "X0001," contract detail name "XPJ-01," supplier CD "S001," and supplier name "Y Company," as well as subsidiary company Y's contract detail number "Y0001" and contract detail "YPJ-01." The second line contains parent company X's asset number "XSW0002," asset name "XPJ-21SW," contract detail number "X1001," contract detail name "X Inter-System Project," supplier CD "S001," and supplier name "Y Company," as well as subsidiary company Y's contract detail number "Y0002" and contract detail "YPJ-02."

[0088] (T3: Cost accounting processing in subsidiary system 600) A specific example of cost calculation processing in the subsidiary system 600 will be described with reference to Figure 11. The cost registration unit 602b creates cost information by aggregating cost amounts (purchase costs of products in the purchase data, labor costs, subcontract costs, transportation costs, indirect costs, sales costs, administrative costs, etc.) for each contract detail number based on cost data such as purchase data in the purchase table 606b, and registers this information in the cost information table 606c. Note that it is assumed that cost data other than purchase data, such as labor costs, subcontract costs, transportation costs, indirect costs, sales costs, administrative costs, etc., is registered in the storage unit 606, and the cost information is created by referring to this data.

[0089] 11 is a diagram showing an example of cost information for subsidiary Y registered in the cost information table 606c. The cost information has fields for the contract detail number, contract detail name, cost CD, cost item name, and cost amount. In the example shown in the figure, the first line contains subsidiary Y's contract detail number "Y0001," contract detail "YPJ-01," cost CD "K003," cost item name "consumables cost," and cost amount "900,000." The second line contains subsidiary Y's contract detail number "Y0001," contract detail "YPJ-01," cost CD "K004," cost item name "labor cost," and cost amount "10,000."

[0090] (S5 of the project management system 100: Unrealized profit statement output process) 7, a specific example of the unrealized profit statement output process of the project management system 100 will be described. The unrealized profit calculation unit 102d performs aggregation for each contract detail number based on the purchase data, and calculates the unrealized profit amount by subtracting the net asset amount, which is the total cost amount of the cost information in the cost information table 606c for the contract detail number of the subsidiary linked to the parent company's contract detail number in the unrealized profit aggregation asset-contract detail master 106c, from the tax-excluded price of the product registered in the asset target product master, and creates an unrealized profit statement including the contract detail number, contract detail name, supplier CD, supplier name, product CD, product name, tax-excluded price, unrealized profit amount, net asset amount, account CD and account name acquired from the asset target product master 106b, and displays and outputs it on the unrealized profit statement screen displayed on the monitor 114, and also stores it in the memory unit 106.

[0091] In this case, unrealized profits are not calculated for suppliers that are not subject to consolidated accounting in the consolidated supplier master 106a. Products that are not registered as asset target products in the asset target product master 106b are not tallied. Regarding the "account item," if the status classification in the contract details is "completed," the "account item at completion" is obtained and set from the asset target product master 106b using the product CD as a key, and if the status classification in the contract details is "uncompleted," the "account item at uncompleted" is obtained and set from the asset target product master 106b using the product CD as a key.

[0092] 11(B) is a diagram showing an example of data for an unrealized profit statement. The unrealized profit statement includes the contract detail number, contract detail name, supplier CD, supplier name, product CD, product name, amount excluding tax, unrealized profit amount, net asset amount, account CD, and account name.

[0093] In the example shown in the figure, the first line contains the contract detail number "X0001," the contract detail name "XPJ-01," the supplier CD "S001," the supplier name "Company Y," the product CD "H001," the product name "Subcontracting costs (assets)," the amount excluding tax "1,000,000," the unrealized profit amount "87,655," the net asset amount "912,345," the account CD "K001," and the account "Software."

[0094] Specifically, the first line shows the supplier "Company Y," which is registered as a consolidated accounting target in the consolidated supplier master data 106a, so the unrealized profit is calculated. The contract detail number for subsidiary Company Y, linked to parent Company X's contract detail number "X0001" in the unrealized profit total asset-contract detail master data 106c, is "Y0001." Using the contract detail number "Y0001" as a key, the cost information table 606c in the subsidiary system 600 is referenced to calculate the total cost, resulting in "912,345," as shown in Figure 11(A). This is the net asset amount. The tax-exempt amount for the product "Subcontract Costs (Assets)" registered in the asset target product master data 106b is "1,000,000," so the unrealized profit is calculated as the tax-exempt amount "1,000,000" - "912,345" = 87,655. As the status category is "Completed" in the contract details, the account name is set by obtaining the completed account item "Software" from the asset target product master 106b using the product CD "H001: Subcontract Cost (Asset)" as the key.

[0095] In the example shown in the figure, unrealized profits are not calculated for "Company B, C, D," which are not registered as consolidated accounting targets in the consolidated supplier master 106a. The product "Advance Payments," which is not registered as an asset target product in the asset target product master 106b, is not tallied. For lines 1 to 3, the status category in the contract details is "Completed," so the completed account item "Software," obtained from the asset target product master 106b using the product CD "H001: Subcontract Costs (Asset)" as the key, is set as the "Account Name." For lines 4 and onward, the status category in the contract details is "Uncompleted," so the uncompleted account item "Software Suspense Account," obtained from the asset target product master 106b using the product CD "H001: Subcontract Costs (Asset)" as the key, is set as the "Account Name."

[0096] (S6 of the project management system 100: Asset information additional input process) A specific example of the asset information additional input process will be described with reference to Figure 12. For example, in response to an operator's operation on the asset information creation screen displayed on the monitor 114, the asset information processing unit 102e uses a specified asset number as a key to extract and display information from the unrealized profit statement and contract details for the contract detail number linked in the unrealized profit total asset-contract detail master 106c, and further creates asset information by adding information related to the asset to the extracted information and registers it in the asset information table 106f. For fixed asset linkage, the amortization information of the net amount after the elimination of unrealized profit is stored in duplicate.

[0097] Figure 12(A) is a diagram showing an example of information extracted from the unrealized profit statement and contract details for the contract detail number linked in the unrealized profit summary asset-contract detail master 106c, using the specified asset number as a key.

[0098] The asset information creation screen displays the following items: asset number, asset name, contract detail number, contract detail name, account CD, account name, acquisition amount, net asset amount, department CD, and department name, as shown in Figure 12(A). The example shown in the figure shows an example when the asset number "XSW0001" is specified.

[0099] FIG. 12(B) is a diagram showing an example of information related to an added asset. The asset information creation screen displays the asset number, asset name, asset type CD, asset type name, tax depreciation method, useful life method, memorandum value, net depreciation method, net useful life, and net memorandum value, and accounting acquisition amount, depreciation method, useful life, memorandum value, net acquisition amount, net depreciation method, net useful life, and net memorandum value. The acquisition amount and net acquisition amount are automatically displayed. When the operator enters the items other than the amount and presses a register button (not shown), asset information such as that shown in FIGS. 12(A) and 12(B) is registered in the asset information table 106f.

[0100] (S7 of the project management system 100: Asset information output process) 12, a specific example of asset information output processing of the project management system 100 will be described. The asset information processing unit 102e outputs the asset information registered in the asset information table 106f to the fixed asset management system 400 in cooperation with the fixed asset management system 400, and also outputs the asset information to other systems such as the consolidated accounting system 500.

[0101] As described above, according to this embodiment, there are a consolidated supplier master 106a in which subsidiaries that are suppliers to consolidated accounting are registered, an asset product master 106b in which capitalized products, completed account items, and uncompleted account items are registered in association with each other, an unrealized profit total asset-contract detail master 106c in which project identification information of the parent company and project identification information of the subsidiary are registered in association with each other, a project registration unit 102b that registers in the storage unit 106 contract details including project identification information and status classifications specifying whether a project is completed or not for the parent company, and purchase data including date, slip number, supplier, product, amount excluding tax, and project identification information for the parent company. in the memory 106, and an unrealized profit calculation unit 102d that performs aggregation for each project identification information of the parent company in the contract details based on the purchase data and calculates the unrealized profit amount by subtracting the net asset amount, which is the total amount of cost amounts of the cost information in the cost information table 606c for the project identification information of the subsidiary linked to the project identification information of the parent company by the unrealized profit aggregation asset-contract details master, from the tax-excluded amount of the product registered in the asset target product master 106b. Therefore, when a project is carried out by companies within the scope of consolidated accounting, it becomes possible for the parent company to grasp the unrealized profit resulting from transactions with the subsidiary at an early stage.

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

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

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

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

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

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

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

[0109] For example, all or any part of the processing functions of the project management system 100, particularly the processing functions performed by the control unit, 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 management system 100 as needed. That is, a computer program for providing 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.

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

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

[0112] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as 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 the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0113] The various databases stored in the memory unit 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.

[0114] The project management system 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 management system 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0115] 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. [Explanation of symbols]

[0116] 100 Project Management Systems 102 Control section 102a Master Maintenance Department 102b Project Registration Department 102c Cost Registration Department 102d Unrealized Profit Calculation Section 102e Asset Information Processing Department 102f Screen display control unit 104 Communication interface unit 106 Storage section 106a Consolidated Supplier Master 106b Asset target product master 106c Unrealized Profit Aggregation Assets - Contract Detail Master 106d Contract Details Table 106e Purchasing Table 106f Asset Information Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network 400 Fixed Asset Management System 500 Consolidated Accounting System 600 Subsidiary Systems 602 Control section 602a Project Registration Department 602b Cost Registration Department 606 Storage section 606a Contract Details Table 606b Purchasing Table 606c Cost Information Table

Claims

1. A project management system having a control unit, The control unit Consolidated vendor master data in which subsidiaries that are vendors for consolidation purposes are registered, Asset target product master that associates and registers the products to be capitalized, the account items at completion, and the account items at the time of completion, and For subsidiaries, cost information including project identification information, cost items, and cost amounts; The unrealized profit summary asset-contract detail master registered by associating the parent company's project identification information with the subsidiary's project identification information; The storage area storing the a project registration means for registering, in the storage area, contract details including project identification information and a status class specifying whether the project is completed or not, for the parent company; a cost registration means for registering purchase data including date, slip number, supplier, product, tax-excluded amount, and project identification information for the parent company in the storage area; an unrealized profit calculation means for calculating an unrealized profit amount by performing an aggregation for each project identification information of the parent company of the contract details based on the purchase data and subtracting a net asset amount, which is the total amount of cost amounts of the cost information for the project identification information of the subsidiary linked to the project identification information of the parent company by the unrealized profit aggregation asset-contract detail master, from the tax-excluded amount of the product registered in the asset target product master; A project management system comprising:

2. The project management system of claim 1, wherein the unrealized profit calculation means further creates and outputs an unrealized profit statement including project identification information, supplier, product, amount excluding tax, unrealized profit amount, net asset amount, and account name, and in this case, for the "account name" of the unrealized profit statement, if the status classification in the contract details is "completed", the product is used as a key and the "account item at completion" is obtained from the asset target product master and set, and if the status classification in the contract details is "uncompleted", the product is used as a key and the "account item at uncompleted" is obtained from the asset target product master and set.

3. 2. A project management system according to claim 1, wherein said unrealized profit calculation means does not tally up products that are not registered in said asset target product master.

4. The control unit further 3. A project management system according to claim 2, further comprising an asset information processing means for creating asset information based on said unrealized profit statement and outputting the information to a fixed asset system.

5. 5. A project management system according to claim 1, wherein the completed account item includes software, and the non-completed account item includes a software provisional account.

6. A project management method executed by an information processing device having a control unit, The control unit Consolidated vendor master data in which subsidiaries that are vendors for consolidation purposes are registered, Asset target product master that associates and registers the products to be capitalized, the account items at completion, and the account items at the time of completion, and For subsidiaries, cost information including project identification information, cost items, and cost amounts; The unrealized profit summary asset-contract detail master registered by associating the parent company's project identification information with the subsidiary's project identification information; The storage area storing the Executed in the control unit: a project registration step of registering, in the storage area, contract details including project identification information and a status class specifying whether the project is completed or not, for the parent company; a cost registration process for registering purchase data including date, invoice number, supplier, product, amount excluding tax, and project identification information for the parent company; an unrealized profit amount calculation step of calculating the unrealized profit amount by performing aggregation for each project identification information of the parent company of the contract details based on the purchase data, and subtracting the net asset amount, which is the total amount of the cost amount of the cost information for the project identification information of the subsidiary linked to the project identification information of the parent company by the unrealized profit aggregation asset-contract detail master, from the tax-excluded amount of the product registered in the asset target product master, A project management method comprising:

7. A project management program to be executed by an information processing device having a control unit, The control unit Consolidated vendor master data in which subsidiaries that are vendors for consolidation purposes are registered, Asset target product master that associates and registers the products to be capitalized, the account items at completion, and the account items at the time of completion, and For subsidiaries, cost information including project identification information, cost items, and cost amounts; The unrealized profit summary asset-contract detail master registered by associating the parent company's project identification information with the subsidiary's project identification information; The storage area storing the In the control unit, a project registration step of registering, in the storage area, contract details including project identification information and a status class specifying whether the project is completed or not, for the parent company; a cost registration step of registering purchase data including date, invoice number, supplier, product, amount excluding tax, and project identification information for the parent company in the storage area; an unrealized profit amount calculation step of calculating the unrealized profit amount by performing aggregation for each project identification information of the parent company of the contract details based on the purchase data, and subtracting the net asset amount, which is the total amount of the cost amount of the cost information for the project identification information of the subsidiary linked to the project identification information of the parent company by the unrealized profit aggregation asset-contract detail master, from the tax-excluded amount of the product registered in the asset target product master, Project management program for implementing.

Images