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

Abstract

To early grasp unrealized gain due to a transaction when executing a project by allotment within enterprizes which are connection objects.SOLUTION: A project management system includes: a connection object supplier master registering a connection object supplier and profit margin; an asset object commodity master registering asset generating commodity, account title in completion, and account title when incomplete; project registration means for registering contract details including project identification information and state classification specifying completion or incompletion of the project; initial cost registration means for registering purchase data including purchase source, commodity, tax excluded cost, and project identification information; and unrealized gain calculation means for performing counting for each project identification information based on the purchase data, and calculating unrealized gain amount obtained by multiplying the tax excluded amount by profit margin acquired from the connection object supplier master using the supplier as a key, regarding the commodity registered in the supplier registered in the connection object supplier master and in the asset object commodity master.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 mention anything about early detection of unrealized profits associated with a transaction when a project is shared and executed by consolidated companies.

[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 make it possible to grasp unrealized profits associated with a transaction at an early stage when a project is shared and executed by consolidated companies. [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 equipped with a control unit, the control unit being configured to be able to access a memory area storing a consolidated supplier master that associates and registers suppliers to be consolidated with profit margins, and an asset target product master that associates and registers products to be capitalized, account items at completion, and account items at incomplete, the system being characterized by comprising: a project registration means that registers contract details including project identification information and a status class specifying whether the project is completed or not in the memory area; a cost registration means that registers purchase data including date, invoice number, supplier, product, amount excluding tax, and project identification information in the memory area; and an unrealized profit calculation means that aggregates the purchase data for each project identification information, and for suppliers registered in the consolidated supplier master and products registered in the asset target product master, calculates the amount of unrealized profit by multiplying the amount excluding tax by the profit margin obtained from the consolidated supplier master using the supplier as a key.

[0007] Furthermore, according to one aspect of the present invention, the unrealized profit calculation means may create and output an unrealized profit statement including project identification information, supplier, product, amount excluding tax, unrealized profit amount calculated by multiplying the amount excluding tax by profit margin, net asset amount calculated by subtracting the amount excluding tax from the amount excluding unrealized profit, 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 incompletion" 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 uncompleted account item may include a software suspense account.

[0012] In addition, 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 memory area that stores a consolidated supplier master that associates suppliers to be consolidated with profit margins and registers them, and an asset target product master that associates products to be capitalized, account items at completion, and account items at incomplete, and the method includes: a project registration step executed by the control unit that registers contract details including project identification information and a status class that specifies whether the project is completed or not in the memory area; a cost registration step that registers purchase data including date, voucher number, supplier, product, amount excluding tax, and project identification information in the memory area; and an unrealized profit calculation step that aggregates the purchase data for each project identification information, and, for suppliers registered in the consolidated supplier master and products registered in the asset target product master, calculates an unrealized profit amount by multiplying the amount excluding tax by the profit margin obtained from the consolidated supplier master using the supplier as a key.

[0013] In addition, 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, wherein the control unit is configured to be able to access a memory area that stores a consolidated supplier master that associates suppliers to be consolidated with profit margins and registers them, and an asset product master that associates products to be capitalized, account items at completion, and account items at incomplete, and the control unit executes a project registration step in which the control unit registers contract details including project identification information and a status class that specifies whether the project is completed or not in the memory area; a cost registration step in which purchase data including the date, invoice number, supplier, product, amount excluding tax, and project identification information in the memory area; and an unrealized profit calculation step in which the control unit tallys up the purchase data for each project identification information, and, for suppliers registered in the consolidated supplier master and products registered in the asset product master, calculates the amount of unrealized profit by multiplying the amount excluding tax by the profit margin obtained from the consolidated supplier master using the supplier as a key. [Effects of the Invention]

[0014] According to the present invention, when a project is shared and executed by consolidated companies, it is possible to grasp the unrealized profits accompanying the transaction at an early stage. [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 flow diagram showing an example of the overall processing of the project management system according to this embodiment. [Figure 5]FIG. 5 is a diagram for explaining a specific example of processing by the control unit of the project management system according to this embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of processing by the control unit of the project management 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 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 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 linked accounting procedures.

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

[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 setting the profit margin for each company, it is possible to manage unrealized profits and consolidated asset amounts (net asset amounts). By utilizing the project management system + fixed asset system, it is possible to centrally manage unrealized software suspense accounts + software on a detail basis, and grasp the latest amounts, taking depreciation expenses into account, on a monthly basis.

[0021] In the project management system of this embodiment, by managing unrealized profits, it is possible to immediately check 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, it is possible to grasp figures 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 financial settlement unit in the consolidated accounting system is not monthly, by utilizing the project management system + fixed asset system, it is possible to grasp figures on a monthly basis for each individual company, making it possible to grasp management figures that take consolidation into consideration at an earlier stage.

[0022] The project management system of the present invention is widely applicable to industries where projects are shared and executed by consolidated companies, 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 etc. The project management system according to this embodiment can be suitably used, for example, by a parent company when a project is executed in a shared manner with a company subject to consolidated accounting. Fig. 1 is a block diagram showing an example of the configuration of a project management system 100 according to this embodiment.

[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, for example, the Internet or a LAN (Local Area Network).

[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 storage unit 106 stores, for example, a consolidated supplier master table 106a, an asset target product master table 106b, a contract details table 106c, a purchase table 106d, an unrealized profit statement, an asset information table 106e, etc. Fig. 2 is a diagram showing an example of the configuration of the consolidated supplier master table 106a. Fig. 3 is a diagram showing an example of the configuration of the asset target product master table 106b.

[0030] The consolidated supplier master 106a is a master for setting the profit margin for each supplier that is the subject of consolidated accounting, and can be configured with a table that associates and registers suppliers (supplier CD and / or supplier name) and profit margins, 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 contract details table 106c is a table for storing 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 serves as the primary key.

[0033] The purchase table 106d is a table for storing purchase data. The purchase data may include the date, invoice 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.

[0034] The asset information table 106e 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, a depreciation method, a useful life, a memorandum value, a net depreciation method, a net useful life, and a net memorandum value for tax purposes, and an acquisition price, a depreciation method, a useful life, a memorandum value, a net acquisition price, a net depreciation method, a net useful life, and a net memorandum value for accounting purposes.

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

[0036] The control unit 102 is configured to be able to access the consolidated supplier master 106a, the asset target product master 106b, the contract detail table 106c, the purchase table 106d, the unrealized profit statement, the material information table 106e, etc., stored in the storage unit 106. Note that the consolidated supplier master 106a, the asset target product master 106b, the contract detail table 106c, the purchase table 106d, the unrealized profit statement, the material information table 106e, etc. may be provided in another location (for example, the server 200) as long as the control unit 102 is able to access them.

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

[0038] The master maintenance unit 102a performs settings such as inputting, adding, changing, and updating data in the linked supplier master 106a and the asset product master 106b, for example, in response to operator operations on a master maintenance screen (not shown) displayed on the monitor 114.

[0039] 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 106c.

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

[0041] The unrealized profit calculation unit 102d tally up the purchase data for each project identification information, and for a supplier registered in the consolidated supplier master 106a and a product registered in the asset target product master 106b, calculates the amount of unrealized profit by multiplying the tax-excluded amount by the profit rate obtained from the consolidated supplier master 106a using the supplier as a key.

[0042] The unrealized profit calculation unit 102d further creates an unrealized profit statement including project identification information, supplier, product, tax-exclusive amount, unrealized profit amount calculated by multiplying the tax-exclusive amount by profit margin, net asset amount calculated by subtracting the tax-exclusive amount from the unrealized profit amount, and account name, and displays and outputs the statement on the unrealized profit statement screen while also registering it in the memory unit 106.

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

[0044] 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 incompletion" from the asset target product master 106b using the product as a key if the status classification in the contract details is "uncompleted."

[0045] 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 106e, and outputs it to the fixed asset system 500.

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

[0047] [3. Specific Examples] A specific example of the processing performed by the control unit 102 of the project management system 100 according to this embodiment will be described with reference to FIGS.

[0048] (3-1. Overall processing) FIG. 4 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.

[0049] 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 4. In Figure 4, 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 106c, 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 106c, for example, in response to an operator's operation on a project registration screen (not shown) displayed on the monitor 114.

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

[0051] The unrealized profit calculation unit 102d executes an unrealized profit statement output process (step S3). Specifically, in the unrealized profit statement output process, the unrealized profit calculation unit 102d performs aggregation for each contract detail number based on the purchase data, and first, for a supplier registered in the consolidated supplier master 106a and a commodity registered in the asset target commodity master 106b, calculates an unrealized profit amount by multiplying the tax-excluded amount by the profit rate obtained from the consolidated supplier master 106a using the supplier as a key, and creates an unrealized profit statement including the project identification information, the supplier, the commodity, the tax-excluded amount, the unrealized profit amount calculated by multiplying the tax-excluded amount by the profit rate, the net asset amount calculated by subtracting the tax-excluded amount from the unrealized profit amount, and the account name, and displays and outputs the statement on an unrealized profit statement screen displayed on the monitor 114 and stores it in the storage unit 106.

[0052] 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 CD as a key, and if the status classification in the contract details is "uncompleted," the "account item at incompletion" is obtained and set from the asset target product master 106b using the product CD as a key.

[0053] The asset information processing unit 102e executes asset information additional input processing (step S5). Specifically, in the asset information input processing, the asset information processing unit 102e extracts and displays reference data from the unrealized profit statement and contract details using the specified project identification information as a key in response to an operator's operation on the asset information creation screen displayed on the monitor 114, and further creates asset information to which information related to the assets has been added and registers the created asset information in the asset information table 106e.

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

[0055] (3-2. Sample data) 5 to 8 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the project management system 100 in this embodiment. A specific example of the processing by the control unit 102 of the project management system 100 in this embodiment will be explained with reference to FIGS. 5 to 8.

[0056] (Master maintenance processing) A specific example of master maintenance processing will be described with reference to Fig. 5. 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.

[0057] Figure 5(A) is a diagram showing an example of the settings for the consolidated supplier master 106a. As shown in Figure 2, the consolidated supplier master 106a has the fields for supplier CD, supplier name, and profit margin. In the example shown in the figure, the first line has supplier CD "S001," supplier name "Company A," and profit margin "10%." The second line has supplier CD "S002," supplier name "Company B," and profit margin "9%." The third line has supplier CD "S003," supplier name "Company C," and profit margin "11%."

[0058] 5(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".

[0059] (S1: Contract details registration processing and S2: Indirect project registration processing) A specific example of the contract details registration process and the indirect project registration process will be described with reference to Fig. 6. 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 106c.

[0060] FIG. 6A is a diagram showing an example of contract details registered in the contract details table 106c. 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.

[0061] In the example shown in the figure, the first line shows the contract details for direct costs, with the contract detail number "0001," contract detail name "PJ-01," direct / indirect category "1," category name "direct," department CD "B1," department name "System 1," and status category "completed." The fourth line shows the contract details for indirect costs, with the contract detail number "1001," contract detail name "System 1 Project," direct / indirect category "2," category name "indirect," department CD "B1," department name "System 1," and status category "uncompleted."

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

[0063] 6(B) is a diagram showing an example of purchase data registered in purchase table 106d. 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."

[0064] The supplier "S004: D Company" on lines 7 and 8 is not registered as a supplier subject to consolidation in the consolidated supplier master 106a, and is therefore a supplier not subject to consolidation, so unrealized profits are not calculated in the unrealized profit statement. The product "H002: Advances" on lines 9 to 11 is not registered as an asset-targeted product in the asset-targeted product master 106b, and is therefore a product not subject to asset targets, so it is not included in the calculations in the unrealized profit statement.

[0065] (S4: Unrealized profit statement output processing) A specific example of the unrealized profit statement output process will be described with reference to Fig. 7. The unrealized profit calculation unit 102d performs aggregation for each contract detail number based on the purchase data, and first, for a supplier registered in the consolidated supplier master database 106a and a commodity registered in the asset target commodity master database 106b, calculates the unrealized profit amount by multiplying the tax-excluded amount by the profit rate obtained from the consolidated supplier master database 106a using the supplier as a key, and creates an unrealized profit statement including the contract detail number, contract detail name, supplier CD, supplier name, commodity CD, commodity name, tax-excluded amount, unrealized profit amount calculated by multiplying the tax-excluded amount by the profit rate, the net asset amount calculated by subtracting the tax-excluded amount from the unrealized profit amount, and the account CD and account name obtained from the asset target commodity master database 106b. The unrealized profit statement is then displayed on an unrealized profit statement screen displayed on the monitor 114 and stored in the storage unit 106.

[0066] 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 incompletion" is obtained and set from the asset target product master 106b using the product CD as a key.

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

[0068] In the example shown in the figure, the first line contains the contract detail number "0001," contract detail name "PJ-01," supplier CD "S001," supplier name "Company A," product CD "H001," product name "Subcontracting costs (assets)," amount excluding tax "1,000,000," unrealized profit amount "100,000," net asset amount "900,000," account CD "K001," and account "Software." Specifically, since the profit margin for "Company A" is 10% in the consolidated supplier master 106a, the unrealized profit amount is calculated as follows: Amount excluding tax (actual paid amount) "1,000,000" x Profit margin "10%" = 100,000, and the net asset amount is calculated as Amount excluding tax "1,000,000" - Unrealized profit amount "100,000" = 900,000. As the status classification is "Completed" in the contract details, the account name is set by obtaining and setting the completion account item "Software" from the asset target product master 106b using the product CD "H001: Subcontract cost (asset)" as the key.

[0069] In the example shown in the figure, unrealized profits are not calculated for "Company D," which is not registered as a consolidated accounting target in the consolidated supplier master 106a. No aggregation is done for the product "Advance Payments," which is not registered as an asset target product in the asset target product master 106b. For lines 1 to 3, the status category is "Completed" in the contract details, 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 onwards, the status category is "Uncompleted" in the contract details, 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."

[0070] (S5: Asset information additional input process) A specific example of the asset information additional input process will be described with reference to Fig. 8. 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 extracts and displays reference data from the unrealized profit statement and contract details using a designated contract number as a key, and further creates asset information to which asset-related information has been added and registers the created asset information in the asset information table 106e.

[0071] 8(A) is a diagram showing an example of reference data extracted from the unrealized profit statement and contract details using the contract number as a key. The person in charge refers to the reference data and adds information related to the assets to create asset information.

[0072] On the asset information creation screen, the following items are displayed as reference data: contract detail number, contract detail name, account CD, account name, acquisition amount, net asset amount, department CD, and department name, as shown in Figure 8(A). The example shown in the same figure shows an example when contract detail number "0001" is specified.

[0073] 8(B) is a diagram showing an example of asset information to be created. The asset information creation screen displays the asset number, asset name, asset type CD, asset type name, tax depreciation method, useful life, 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 FIG. 8(B) is registered in asset information table 106e.

[0074] (S6: Asset information output process) A specific example of the asset information output process will be described with reference to Fig. 8. The asset information processing unit 102e outputs the asset information registered in the asset information table 106e to the fixed asset management system 400 in cooperation with the asset information processing unit 102e, and also outputs the asset information to other systems such as the consolidated accounting system 500.

[0075] As described above, according to this embodiment, there are provided a consolidated supplier master 106a, which is a master for setting the profit margin for each supplier of the consolidated accounting target, and in which the supplier and the profit margin are registered in association with each other; an asset target product master 106b, which is a master for setting information on the products to be capitalized, and in which the products, the account items at the time of completion, and the account items at the time of incompleteness are registered in association with each other; a project registration unit 102b, which registers in the storage unit 106 contract details including project identification information and a status classification specifying whether the project is completed or not; and a data entry unit 106c, which stores information on the date, slip number, supplier, product, amount excluding tax, project The system is equipped with a cost registration unit 102c that registers purchase data including identification information in the storage unit 106, and an unrealized profit calculation unit 102d that performs aggregation for each project identification information based on the purchase data, and calculates the amount of unrealized profit by multiplying the tax-excluded amount by the profit rate obtained from the consolidated supplier master 106a using the supplier as a key, for a supplier registered in the consolidated supplier master 106a and a commodity registered in the asset target commodity master 106b. Therefore, when a project is shared and executed by companies within the consolidated group, it becomes possible to grasp the unrealized profit associated with the transaction at an early stage.

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

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

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

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

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

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

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

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

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

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

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

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

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

[0089] 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]

[0090] 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 Contract Details Table 106d Purchasing Table 106e 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

Claims

1. A project management system having a control unit, The control unit Consolidated accounting target supplier master data that associates suppliers and profit margins with consolidated accounting target suppliers, Asset target product master that associates and registers the product to be capitalized, the account item at completion, and the account item at incomplete, and The storage area storing the a project registration means for registering contract details including project identification information and a status class specifying whether the project is completed or not in the storage area; cost registration means for registering purchase data including date, slip number, supplier, product, tax-excluded amount, and project identification information in the storage area; an unrealized profit calculation means for performing aggregation for each project identification information based on the purchase data, and for a supplier registered in the consolidated supplier master and a commodity registered in the asset target commodity master, calculating an unrealized profit amount by multiplying the tax-excluded amount by a profit rate acquired from the consolidated supplier master using the supplier as a key; A project management system comprising:

2. The project management system of claim 1, wherein the unrealized profit calculation means creates and outputs an unrealized profit statement including project identification information, supplier, product, amount excluding tax, unrealized profit calculated by multiplying the amount excluding tax by the profit margin, net asset value calculated by subtracting the amount excluding tax from the amount excluding unrealized profit, and account name.

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. 3. A project management system as described in claim 2, wherein the unrealized profit calculation means, for the "account name" of the unrealized profit statement, if the status classification in the contract details is "completed", uses the product as a key to obtain and set the "account item at completion" from the asset target product master, and if the status classification in the contract details is "uncompleted", uses the product as a key to obtain and set the "account item at incompletion" from the asset target product master.

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

6. 6. A project management system according to claim 1, wherein the account items at completion include software, and the account items at incomplete include a software suspense account.

7. A project management method executed by an information processing device having a control unit, The control unit Consolidated accounting target supplier master data that associates suppliers and profit margins with consolidated accounting target suppliers, 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 The storage area storing the Executed in the control unit: a project registration step of registering contract details including project identification information and a status class specifying whether the project is completed or not in the storage area; a cost registration step of registering purchase data including date, invoice number, supplier, product, amount excluding tax, and project identification information in the storage area; an unrealized profit calculation step of aggregating the data for each project identification information based on the supplier data, and calculating the unrealized profit amount by multiplying the tax-excluded amount by the profit rate obtained from the consolidated supplier master using the supplier as a key for the supplier, for the supplier registered in the consolidated supplier master and the commodity registered in the asset target commodity master; A project management method comprising:

8. A project management program to be executed by an information processing device having a control unit, The control unit Consolidated accounting target supplier master data that associates suppliers and profit margins with consolidated accounting target suppliers, 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 The storage area storing the In the control unit, a project registration step of registering contract details including project identification information and a status class specifying whether the project is completed or not in the storage area; a cost registration step of registering purchase data including date, invoice number, supplier, product, amount excluding tax, and project identification information in the storage area; an unrealized profit calculation step of aggregating the data for each project identification information based on the supplier data, and calculating the unrealized profit amount by multiplying the tax-excluded amount by the profit rate obtained from the consolidated supplier master using the supplier as a key for the supplier, for the supplier registered in the consolidated supplier master and the commodity registered in the asset target commodity master; Project management program for implementing.

Images