FUNDING PLAN MANAGEMENT DEVICE, FUNDING PLAN MANAGEMENT METHOD, AND FUNDING PLAN MANAGEMENT PROGRAM
The cash flow schedule management device addresses the challenge of managing complex construction industry cash flows by classifying and generating schedules by project, department, and company-wide levels, improving visibility and reducing manual workload.
Patent Information
- Application Number
- JP2021134688
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Priority Date
- 2021-01-29
- Filing Date
- 2021-08-20
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2041-08-20
AI Technical Summary
In the construction industry, managing cash flow schedules is cumbersome due to hierarchical structures with multiple subcontractors, leading to delayed payments and high workload in manually organizing data using Excel, which hinders early understanding of cash flow dynamics.
A cash flow schedule management device and method that utilizes a control unit and storage unit to classify cash flows by stage (planning, scheduled, actual) and type (deposits/withdrawals) within a matrix, generating and outputting schedules by project, department, and company-wide levels, integrating with construction project data.
Enables accurate and timely understanding of deposits and withdrawals at each stage, reducing workload and enhancing cash flow visibility across different organizational levels.
Smart Images

Figure 0007590286000001 
Figure 0007590286000002 
Figure 0007590286000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a cash flow schedule management device, a cash flow schedule management method, and a cash flow schedule management program. [Background technology]
[0002] Patent Document 1 discloses a funds management support device and a funds management support method that support funds management of multiple deposit accounts in different currencies, which is suitable for funds management such as analysis and forecasting of funds in global corporate groups, etc. (see paragraph 0007 of Patent Document 1, etc.). [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2017-68401 A Summary of the Invention [Problem to be solved by the invention]
[0004] In the construction industry, for example, there are often multiple subcontractor hierarchical structures, and it often takes time for payments to be made. Since it is important to have an abundance of cash in order to continue business, it is important to accurately and quickly grasp the cash flow plan (when and how much to deposit, when and how much to withdraw, etc.).
[0005] However, in the conventional technology including Patent Document 1, in order to grasp the amount of deposits and withdrawals for each period (year and month) for each of the three stages of cash flow (the planning stage where a contract has not yet been concluded, the planned stage where a contract has been concluded but deposits and withdrawals have not been completed, and the actual stage where deposits and withdrawals have been completed), it was necessary to organize information using Excel or the like. This resulted in a very heavy workload, and there was a problem that cash flow could not be grasped early.
[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a cash flow schedule management device, a cash flow schedule management method, and a cash flow schedule management program that enable one to grasp the amounts of deposits and withdrawals for each cash flow stage and period. [Means for solving the problem]
[0007] In order to solve the above-mentioned problems and achieve the object, a cash-flow schedule management device according to the present invention is a cash-flow schedule management device comprising a control unit and a memory unit, the memory unit stores case identification data, department identification data, cash-flow management information including a cash-flow classification which is a classification for identifying whether cash-flow is at a planned, scheduled, or actual stage, a deposit / withdrawal classification which is a classification for identifying a deposit or withdrawal, an amount to be deposited or withdrawn, and a period to which the date on which the amount is to be cashed or has been cashed belongs, and work output target details which are a table having a combination of the cash-flow classification and the deposit / withdrawal classification on one axis and a period on the other axis, and the control unit extracts the cash-flow schedule information in the cash-flow management information from the work output target details. The system is characterized by comprising: a schedule information generating means for generating item-department cash flow schedule information, which is cash flow schedule information for the combination of the item identified by the item identification data and the department identified by the department identification data, by identifying a matrix in the table that matches the cash flow classification, the deposit / withdrawal classification and the period, and storing the amount in the identified matrix; and a schedule output means for outputting an item-department cash flow schedule, which is a cash flow schedule for the combination of the item and the department, based on the generated item-department cash flow schedule information, with the combination of the cash flow classification and the deposit / withdrawal classification on one axis and the period on the other axis, and the amount stored in the matrix identified by these two axes.
[0008] In addition, in the cash flow schedule management device of the present invention, the schedule output means is characterized in that it outputs a departmental cash flow schedule, which is a cash flow schedule on a departmental basis, by aggregating the amounts in the generated case / departmental cash flow schedule on a departmental basis.
[0009] In addition, in the cash flow schedule management device of the present invention, the schedule output means is characterized in that it outputs a company-wide cash flow schedule, which is a cash flow schedule for the entire company, by aggregating the amounts in the generated departmental cash flow schedule.
[0010] In addition, in the cash flow schedule management device of the present invention, the memory unit further stores project information including case identification data and department identification data, and scheduled deposit information including the case identification data and the scheduled deposit amount, and the control unit further comprises a cash flow management generation means for generating the cash flow management information when the cash flow classification in the cash flow management information is a classification for identifying that cash flow is in the planning stage and the deposit / withdrawal classification is a classification for identifying deposits, based on the project information and the scheduled deposit information which have the same case identification data, by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the scheduled deposit amount in the scheduled deposit information as the amount in the cash flow management information.
[0011] In addition, in the cash flow schedule management device of the present invention, the memory unit further stores project information including case identification data and department identification data, previous billing information including the case identification data and the previous billing amount, sales information including the case identification data and the planned collection amount, and billing information including the case identification data and the billing amount, and the control unit further comprises a cash flow management generation means for generating the cash flow management information by, when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the planned stage and the deposit / withdrawal classification is a classification for identifying deposits, setting the department identification data in the project information as the department identification data in the cash flow management information based on any one of the project information, the previous billing information, the sales information, and the billing information that have the same case identification data, and setting the previous billing amount in the previous billing information, the planned collection amount in the sales information, or the billing amount in the billing information as the amount in the cash flow management information, if the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the planned stage and the deposit / withdrawal classification is a classification for identifying deposits.
[0012] In addition, in the cash flow schedule management device of the present invention, the memory unit further stores project information including case identification data and department identification data, and deposit information including the case identification data and the deposit amount, and the control unit further comprises a cash flow management generation means which, when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the performance stage and the deposit / withdrawal classification is a classification for identifying deposits, generates the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the deposit amount in the deposit information as the amount in the cash flow management information based on the project information and the deposit information which have the same case identification data.
[0013] In addition, in the cash flow schedule management device of the present invention, the memory unit further stores project information including case identification data and department identification data, and order information including the case identification data and the order amount, and the control unit further comprises a cash flow management generation means for generating the cash flow management information when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the planning stage and the deposit / withdrawal classification is a classification for identifying withdrawals, by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the order amount in the order information as the amount in the cash flow management information based on the project information and the order information which have the same case identification data.
[0014] In addition, in the cash flow schedule management device of the present invention, the memory unit further stores project information including case identification data and department identification data, and purchase information including the case identification data and the purchase amount, and the control unit further includes a cash flow management generation means for generating the cash flow management information when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the planning stage and the deposit / withdrawal classification is a classification for identifying withdrawals, by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the purchase amount in the purchase information as the amount in the cash flow management information based on the project information and the purchase information which have the same case identification data.
[0015] In addition, in the cash flow schedule management device of the present invention, the memory unit further stores project information including case identification data and department identification data, and payment information including the case identification data and the payment amount, and the control unit further comprises a cash flow management generation means for generating the cash flow management information when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the performance stage and the deposit / withdrawal classification is a classification for identifying withdrawals, by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the payment amount in the payment information as the amount in the cash flow management information based on the project information and the payment information which have the same case identification data.
[0016] In addition, in the cash flow schedule management device according to the present invention, the project is a construction project, and the device is used in the construction industry.
[0017] Furthermore, in a cash-flow schedule management method according to the present invention, there is provided a cash-flow schedule management method executed by an information processing device having a control unit and a storage unit, the storage unit stores case identification data, department identification data, cash-flow management information including a cash-flow classification which is a classification for identifying whether the cash-flow is at a planned, scheduled, or actual stage, a deposit / withdrawal classification which is a classification for identifying a deposit or withdrawal, an amount to be deposited or withdrawn, and a period to which the date on which the amount is to be cashed or has been cashed belongs, and work output target details which are a table having a combination of the cash-flow classification and the deposit / withdrawal classification on one axis and a period on the other axis, and the control unit executes a process of extracting the cash-flow classification from the work output target details, the cash-flow classification in the cash-flow management information, the deposit / withdrawal classification being a classification for identifying a deposit or withdrawal, and a period to which the date on which the amount is to be cashed or has been cashed belongs, and the amount stored in the matrix specified by the identified matrix, and a schedule information generating step of generating item-department cash flow schedule information, which is cash flow schedule information for the combination of the item identified by the item identification data and the department identified by the department identification data, based on the generated item-department cash flow schedule information; and a schedule output step of outputting an item-department cash flow schedule, which is a cash flow schedule for the combination of the item and the department, based on the generated item-department cash flow schedule information, in which the combination of the cash flow category and the cash flow category is taken as one axis and the period is taken as the other axis and the amount is stored in the matrix specified by these two axes.
[0018] Furthermore, in a cash flow schedule management program according to the present invention, the program is executed by an information processing device having a control unit and a memory unit, the memory unit stores case identification data, department identification data, cash flow management information including a cash flow classification which is a classification for identifying whether cash flow is at a planned, scheduled, or actual stage, a deposit / withdrawal classification which is a classification for identifying a deposit or withdrawal, an amount to be deposited or withdrawn, and a period to which the date on which the amount is to be cashed or has been cashed belongs, and work output target details which are a table having a combination of the cash flow classification and the deposit / withdrawal classification on one axis and a period on the other axis, and The method includes a schedule information generating step of generating item-department cash flow schedule information, which is cash flow schedule information for the combination of the item identified by the item identification data and the department identified by the department identification data, by identifying a matrix in the table that matches the cash flow category, the deposit / withdrawal category, and the period, and storing the amount in the identified matrix; and a schedule output step of outputting an item-department cash flow schedule, which is a cash flow schedule for the combination of the item and the department, based on the generated item-department cash flow schedule information, with the combination of the cash flow category and the deposit / withdrawal category on one axis and the period on the other axis, and with the amount stored in a matrix identified by these two axes. Effect of the Invention
[0019] According to the present invention, it is possible to grasp the amounts of deposits and withdrawals for each stage of cash flow and for each period. [Brief description of the drawings]
[0020] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a financial flow plan management device. [Diagram 2] FIG. 2 is a diagram showing an example of a system configuration according to the present embodiment. [Diagram 3]FIG. 3 is a diagram illustrating an example of a method for calculating the billing destination master and the scheduled collection date. [Figure 4] FIG. 4 is a diagram illustrating an example of the payment destination master. [Diagram 5] FIG. 5 is a diagram illustrating an example of the transaction method master. [Figure 6] FIG. 6 is a diagram showing an example of the source of acquisition of amounts in the cash flow management information. [Figure 7] FIG. 7 is a diagram showing an example of project information registered in 2021 / 02. [Figure 8] FIG. 8 is a diagram showing an example of expected deposit information and cash flow management information registered in 2021 / 02. [Figure 9] FIG. 9 is a diagram showing an example of work project-specific cash flow schedule information generated in 2021 / 02. [Figure 10] FIG. 10 is a diagram illustrating an example of the generation of a work output target detail. [Figure 11] FIG. 11 is a diagram showing an example of construction-specific cash flow schedule information generated in 2021 / 02. [Figure 12] FIG. 12 is a diagram showing an example of a construction-specific cash flow schedule output in February 2021. [Figure 13] FIG. 13 is a diagram showing an example of project information registered in March 2021. [Figure 14] FIG. 14 is a diagram showing an example of pre-billing information and cash flow management information registered in March 2021. [Figure 15] FIG. 15 is a diagram showing an example of order information and cash flow management information registered in March 2021. [Figure 16] FIG. 16 is a diagram showing an example of cash flow management information registered in 2021 / 03. [Figure 17] FIG. 17 is a diagram showing an example of work project-specific cash flow schedule information and project-specific cash flow schedule information generated in March 2021. [Figure 18] FIG. 18 is a diagram showing an example of a construction-specific cash flow schedule output in March 2021. [Figure 19] FIG. 19 is a diagram showing an example of project information registered in 2021 / 03 that was carried over to 2021 / 04. [Figure 20] FIG. 20 is a diagram showing an example of sales information and cash flow management information registered in April 2021. [Figure 21] FIG. 21 is a diagram showing an example of deposit information and cash flow management information registered in April 2021. [Figure 22] FIG. 22 is a diagram showing an example of cash flow management information registered at the intermediate stage of 2021 / 04. [Figure 23] FIG. 23 is a diagram showing an example of work project-specific cash flow schedule information generated at the midpoint of 2021 / 04. [Figure 24] FIG. 24 is a diagram showing an example of construction-specific cash flow schedule information generated at the midpoint of 2021 / 04. [Diagram 25] FIG. 25 is a diagram showing an example of a construction-specific cash flow schedule output at the midpoint of April 2021. [Figure 26] FIG. 26 is a diagram showing an example of purchase information and cash flow management information registered in April 2021. [Figure 27] FIG. 27 is a diagram showing an example of cash flow management information registered in 2021 / 04. [Figure 28] FIG. 28 is a diagram showing an example of work project-specific cash flow schedule information generated in April 2021. [Figure 29] FIG. 29 is a diagram showing an example of construction-specific cash flow schedule information generated in April 2021. [Diagram 30] FIG. 30 is a diagram showing an example of a construction-specific cash flow schedule output in April 2021. [Diagram 31] FIG. 31 is a diagram showing an example of payment information and cash flow management information registered in May 2021. [Diagram 32] FIG. 32 is a diagram showing an example of cash flow management information registered in 2021 / 05. [Diagram 33]FIG. 33 is a diagram showing an example of work project-specific cash flow schedule information generated in May 2021. [Diagram 34] FIG. 34 is a diagram showing an example of construction-specific cash flow schedule information generated in May 2021. [Diagram 35] FIG. 35 is a diagram showing an example of a construction-specific cash flow schedule output in May 2021. [Diagram 36] FIG. 36 is a diagram showing an example of a departmental cash flow schedule. [Figure 37] FIG. 37 is a diagram showing an example of a company-wide cash flow schedule. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0021] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, preferred embodiments of a cash flow schedule management device, a cash flow schedule management method, and a cash flow schedule management program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to the preferred embodiments.
[0022] [1. Background, Issues and Overview] This section describes the background, problems and overview of the present invention.
[0023] [1-1. Background and Problems of the Invention] The construction industry has a multi-layered subcontracting structure, and in the case of long-term construction projects, payments are made to subcontractors, but the receipt of payments tends to be delayed. Since payment deadlines are stipulated in the Construction Business Act and the Subcontracting Act, etc., in order to continue business, it is necessary to forecast cash flow and hold ample cash.
[0024] In addition, in many cases, the accounting and finance department manages the payment schedule in Excel after issuing invoices, and manages the payment schedule after receiving invoices from subcontractors, but construction projects with long construction periods and large amounts of money have a large impact on a company's cash flow. For this reason, it is desirable to manage the cash flow schedule including construction schedules at the contract stage, and ideally, the inquiry stage.
[0025] And while sales and construction staff are aware of the profits for each project, they often do not pay attention to the planned inflow and outflow. Therefore, in order to fundamentally improve the company's cash flow problems, it is necessary to make not only the entire company and accounting departments, but also department managers and construction managers aware of the planned inflow and outflow.
[0026] Furthermore, in terms of supporting business continuity during the COVID-19 pandemic, it is expected that the usefulness of not only profit management but also cash management will become even more important.
[0027] In short, cash flow forecasts require the collection of a wide range of information, but previously, cash flow forecasts were managed manually using Excel, etc., which created a problem of high workload when they were created (workload problem). Also, previously, cash flow forecasts were recognized at the time of invoicing and payment, but information was not collected from the field to accounting at the time of receiving or placing an order for a project, so there was a problem of not being able to confirm the cash flow forecast early (timing of understanding problem).
[0028] [1-2. Overview of the present invention] Therefore, in this embodiment, for example, by linking business progress and cash flow and managing the status, it is possible to improve planning accuracy as the process progresses, and to manage cash flow plans more accurately and earlier.
[0029] In addition, in this embodiment, for example, planned information and actual performance information regarding cash flow are collected from each business, and the information can be checked at any time as of a specified date by managers in different positions, such as at the construction unit (from the perspective of the site manager), department unit (from the perspective of the department manager), and company-wide unit (from the perspective of management).
[0030] In this embodiment, for example, for information where deposits and withdrawals are not yet confirmed at the inquiry or contract stage, the scheduled deposit date and scheduled payment date can be calculated as follows. The scheduled deposit date can be calculated by referencing the agreement in the billing master from the scheduled sales date in the contract information. The scheduled payment date can be calculated by referencing the agreement in the supplier master from the scheduled end date of the construction period of the planned order in the budget information. Note that when the denomination is a bill, the scheduled deposit date and scheduled payment date can be adjusted taking into account the settlement date.
[0031] Furthermore, in this embodiment, for example, the construction management system mainly manages deposits and withdrawals linked to construction projects, but if additional information such as selling and general administrative expenses, non-operating profit and loss, and extraordinary profit and loss are also registered as receivables and payables, it becomes possible to manage the precise cash flow plan for the entire company. The specific configuration and operation are described below.
[0032] [2. Configuration] An example of the configuration of a cash flow schedule management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the cash flow schedule management device 100.
[0033] The cash flow schedule management device 100 is a commercially available desktop personal computer. The cash flow schedule management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0034] The cash flow schedule management device 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 cash flow schedule management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0035] The communication interface unit 104 communicatively connects the cash flow schedule management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the cash flow schedule management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various master data described later may be stored in the server 200, for example.
[0036] 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 realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0037] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.
[0038] The memory unit 106 includes, for example, project information 106a, expected payment information 106b, advance billing information 106c, sales information 106d, billing information 106e, payment information 106f, order information 106g, purchase information 106h, payment information 106i, billing destination master 106j, payment destination master 106k, transaction method master 106m, cash flow management information 106n, work construction-specific cash flow schedule information 106p, work output target details 106q, and work-specific cash flow schedule information 106r.
[0039] Here, project information 106a through payment information 106i are information registered daily as the work progresses, and will be described in the following section [2-1]. Billing destination master 106j through transaction method master 106m are master information set in advance by the operator, and will be described in the following section [2-2]. Cash flow management information 106n through construction cash flow schedule information 106r are information characteristic of the present invention, which are generated through processing, and will be described in the following section [2-3].
[0040] [2-1. Project Information 106a to Payment Information 106i] Project information 106a includes, for example, a project number, project name, department, billing destination, contract status, inquiry date, order date, etc. The project number is a number that uniquely identifies a project. The department is the department that manages the project. The billing destination is the business partner from which money is collected. The contract status is status information that indicates the progress of the project, and there are three statuses: inquiry, order received, and lost. The order date is the date the initial order was recorded.
[0041] Scheduled deposit information 106b includes, for example, a scheduled deposit number, a project number, a billing destination, a transaction method, a scheduled deposit amount (amount), a scheduled billing date, a scheduled collection date, and a cash-in / out date. The scheduled deposit number is a slip number that uniquely indicates the scheduled deposit information. The transaction method is the method of collection of the amount. The amount is the amount to be collected. The scheduled billing date is the target date used to calculate the scheduled collection date. The scheduled collection date is the scheduled date for collection of the amount. The cash-in / out date is the date on which the amount is to be cashed.
[0042] The previous billing information 106c includes, for example, the previous billing number, project number, billing destination, transaction method, previous billing amount (amount), previous billing date, scheduled collection date, cash in / out date, etc. The previous billing number is a slip number that uniquely identifies the previous billing information. The previous billing date is the date when the previous billing was registered, and is also the target date used to calculate the scheduled collection date.
[0043] Sales information 106d includes, for example, a sales number, a project number, a billing destination, a transaction method, a sales amount, a planned collection amount, a sales date, a planned collection date, and a cash-in / out date. The sales number is a slip number that uniquely identifies the sales information. The sales date is the date when the sales was registered, and is also the target date used to calculate the planned collection date. Regarding the planned collection amount, if a pre-billing was made before the sales was registered, the sales amount ≠ the collection amount. Specifically, when the sales are registered, the amount obtained by offsetting the current sales amount with the previous billing amount is set in sales information 106d.
[0044] The billing information 106e includes, for example, a billing number, a project number, a billing destination, a transaction method, a billing amount (amount), a billing date, a scheduled collection date, and a cash-in / out date. The billing number is a slip number that uniquely identifies the billing information. The billing date is the date when the bill was registered, and is also the target date used to calculate the scheduled collection date.
[0045] The deposit information 106f includes, for example, a deposit number, a project number, a billing destination, a transaction method, a deposit amount (amount), a scheduled collection date, a deposit date, a cash-in / out date, etc. The deposit number is a slip number that uniquely identifies the deposit information. The deposit date is the date when the deposit was registered (a date that reflects the deposit record).
[0046] Order information 106g includes, for example, an order number, a project number, a payee, a transaction method, an order amount (amount), an order date, a scheduled purchase date, a scheduled payment date, and a cash-in / out date. The order number is a slip number that uniquely identifies the order information. The payee is the business partner to which money is paid. The order date is the date on which the order was registered. The scheduled purchase date is the target date used to calculate the scheduled payment date. The scheduled payment date is the scheduled payment date for the amount. The cash-in / out date is the date on which cash is withdrawn.
[0047] The purchase information 106h includes, for example, a purchase number, a project number, a payment destination, a transaction method, a purchase amount (amount), a purchase date, a scheduled payment date, and a cash-in / out date. The purchase number is a slip number that uniquely identifies the purchase information. The purchase date is the date when the purchase was registered, and is also the target date used to calculate the scheduled payment date.
[0048] Payment information 106i includes, for example, a payment number, a project number, a payee, a transaction method, a payment amount (amount), a scheduled payment date, a payment date, and a cash-in / out date. The payment number is a slip number that uniquely indicates payment information. The payee is the business partner to whom money is paid. The payment date is the date the payment was registered (a date that reflects the actual payment).
[0049] Here, the nature of the deposit schedule information 106b through payment information 106i and the relationship between these information and the cash flow management information 106n will be described with reference to FIG. 2 and FIG.
[0050] The deposit schedule information 106b is information that is generated at the deposit planning stage, as shown in Fig. 2. As shown in Fig. 6, in the cash flow management information 106n, when the cash flow category is "0: plan" and the deposit / withdrawal category is "0: deposit", the amount in the deposit schedule information 106b is set as the amount in the cash flow management information 106n.
[0051] The pre-billing information 106c, sales information 106d, and billing information 106e are information that is generated at the stage of scheduled deposits, as shown in Fig. 2. As shown in Fig. 6, in the cash flow management information 106n, when the cash flow classification is "1: scheduled" and the deposit / withdrawal classification is "0: deposit", the amounts in the pre-billing information 106c, sales information 106d, and billing information 106e are set as the amounts in the cash flow management information 106n.
[0052] Deposit information 106f is information that is generated at the deposit performance stage (=after the deposit has been made) as shown in Fig. 2. As shown in Fig. 6, in the cash flow management information 106n, when the cash flow category is "2: performance" and the deposit / withdrawal category is "0: deposit", the amount in deposit information 106f is set as the amount in cash flow management information 106n.
[0053] The order information 106g is information that is generated at the planning stage of withdrawal (payment), as shown in Fig. 2. As shown in Fig. 6, when the cash flow category in the cash flow management information 106n is "0: plan" and the deposit / withdrawal category is "1: withdrawal (payment)", the amount in the order information 106g is set as the amount in the cash flow management information 106n.
[0054] The purchase information 106h is information that is generated at the stage of planning withdrawal (payment), as shown in Fig. 2. As shown in Fig. 6, when the cash flow classification is "1: Plan" and the deposit / withdrawal classification is "1: Withdrawal (Payment)" in the cash flow management information 106n, the amount in the purchase information 106h is set as the amount in the cash flow management information 106n.
[0055] Payment information 106i is information that is generated at the withdrawal (payment) performance stage (=after the withdrawal (payment) has been completed), as shown in Figure 2. As shown in Figure 6, in the cash flow management information 106n, when the cash flow category is "2: performance" and the deposit / withdrawal category is "1: withdrawal (payment)", the amount in payment information 106i is set as the amount in cash flow management information 106n.
[0056] [2-2. Billing destination master 106j ~ Transaction method master 106m] 3, the billing destination master 106j includes, for example, a billing destination code, a billing destination name, a closing date, a collection month, and a collection date. The billing destination code and the billing destination name indicate the business partner from which the money is to be collected. The closing date, the collection month, and the collection date are information used to calculate the scheduled collection date.
[0057] Here, a method for calculating the scheduled collection date will be described with reference to the table shown in FIG. The year and month for the calculation of (2) is the year and month to which the calculation date for (1) belongs. The closing period in (3) is calculated based on the calculation year and month in (2) and the closing date set in the billing destination master 106j. The calculation date for (4) shall be the calculation date for (2) if the condition (I) (3) (start date of the period covered by the calculation in (1)) (end date of the period covered by the calculation in (3)) is met. Conversely, if the condition (II) is not met, the calculation date for (2) + 1 month shall be met. The expected collection month in (5) is calculated by adding the calculation target year and month in (4) to the collection month in the billing destination master 106j. The scheduled collection date of (6) is calculated based on the scheduled collection month of (5) and the collection date in the billing destination master 106j.
[0058] 4, the payee master 106k includes, for example, a payee code, a payee name, a closing date, a payment month, a payment date, etc. The scheduled payment date can be calculated by replacing the words in the method for calculating the scheduled collection date explained in the previous paragraph as follows, so a detailed explanation will be omitted. · Billing destination master 106j → Payment destination master 106k · Collection month in billing master 106j → payment month in payment master 106k Scheduled collection month → Scheduled payment month · Scheduled collection date → Scheduled payment date
[0059] As shown in FIG. 5, the transaction method master 106m includes, for example, a transaction method code, a transaction method name, a transaction category, and a bill site. The transaction method code and transaction method name are the method of collecting money and the payment method. The transaction category is the type of transaction. The bill site is the bill site set when the transaction category is a bill. For example, if the transaction method is "TOR22: Bill (90 days)" and the target date (scheduled collection date) is 2021 / 12 / 01, the CASHIN / OUT date can be calculated as 20201 / 03 / 01 by calculating "target date 2021 / 12 / 01 + bill site 90 days in the transaction method master 106m".
[0060] The collection method and payment method can be set by apportionment by denomination (transaction classification) on the transaction method master 106m, and by further breaking down each planned and actual information by denomination, it can also be expanded into a cash flow schedule by denomination. By breaking down by denomination, it is even possible to predict the cash in / out date of cash and deposits taking into account the bill due date. The cash in / out date can be calculated based on the bill site set on the transaction method master 106m.
[0061] [2-3. Cash Flow Management Information 106n ~ Cash Flow Schedule Information by Construction Project 106r] As shown in FIG. 8, the cash flow management information 106n includes, for example, project identification data (project number), department identification data (department code), customer identification data (customer code), cash flow classification which is a classification for identifying whether the cash flow is at the planned, scheduled, or actual stage, deposit / withdrawal classification which is a classification for identifying deposits or withdrawals, transaction classification, voucher number, the amount (amount) to be deposited or withdrawn, accounting date, accounting year and month, the date when the amount is or has been cashed (CASHIN / OUT date), and the period to which the date belongs (CASHIN / OUT year and month), etc.
[0062] The project number indicates the project number of the cash flow management target (for example, a construction project). The department code is the code of the department that manages the project. The business partner code is the code of the business partner from which money is collected or paid. The cash flow category indicates the status of the cash flow information, and there are three categories: "0: Plan", "1: Schedule", and "2: Actual". There are three categories of cash flow categories: "0: Deposit", which indicates income, "1: Withdrawal (Payment)", which indicates expenditure, and "9: Balance", which indicates income minus expenditure. The transaction category indicates the type of money collection and payment method. The document number is the document number from which the cash flow management information is generated. The amount is the amount collected or paid. The accounting date is the date on which the cash flow of money is recognized or recognized as actual. The accounting year and month is the year and month to which the accounting date belongs. The CASHIN / OUT date is the date on which money is converted or converted into cash. The CASHIN / OUT date is the year and month to which the CASHIN / OUT date belongs.
[0063] Work construction cash flow schedule information 106p is information obtained by aggregating amounts of records with the same combination of project number, customer code, cash flow category, deposit / withdrawal category, and CASHIN / OUT year / month in cash flow management information 106n. Work construction cash flow schedule information 106p includes, for example, project number, customer code, cash flow category, deposit / withdrawal category, CASHIN / OUT year / month (target year / month), aggregated amount (amount), etc., as shown in Fig. 9 etc.
[0064] As shown in FIG. 10 and other figures, the work output target details 106q is a table in which a combination of a cash flow category and a deposit / withdrawal category is shown on one axis, and a period is shown on the other axis.
[0065] The cash flow schedule information by construction 106r is information used to output the cash flow schedule by construction. The cash flow schedule information by construction 106r is generated by storing the total amount (amount) in the cash flow schedule information by construction 106p in the matrix in the work output target details 106q, as will be explained in detail in [3. Specific examples of processing] below. The cash flow schedule information by construction 106r includes, for example, the project number, the customer code, the cash flow classification, the deposit / withdrawal classification, and the amount by target year and month, as shown in FIG. 11, etc.
[0066] The control unit 102 is a CPU or the like that performs overall control of the cash flow schedule management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0067] The control unit 102, in terms of functional concept, includes, for example, (1) a cash flow management generation unit 102a as a cash flow management generation means, (2) a schedule information generation unit 102b as a schedule information generation means that identifies a matrix in the table that matches the cash flow category, the deposit / withdrawal category, and the period in the cash flow management information from the details to be output from the work, and stores the amount in the identified matrix, thereby generating item-department cash flow schedule information, which is cash flow schedule information for a combination of the item identified by the item identification data and the department identified by the department identification data, and (3) a schedule output unit 102c as a schedule output means that outputs an item-department cash flow schedule, which is a cash flow schedule for a combination of the item and the department, based on the generated item-department cash flow schedule information, with the combination of the cash flow category and the deposit / withdrawal category on one axis and the period on the other axis, and the amount stored in the matrix identified by these two axes.
[0068] The cash flow management generation unit 102a generates the cash flow management information 106n by setting amounts in the cash flow management information 106n based on different information according to the cash flow classification (three patterns: "0: plan," "1: schedule," or "2: result") and the deposit / withdrawal classification (two patterns: "0: deposit" or "1: withdrawal") in the cash flow management information 106n. Below, the generation of the cash flow management information 106n will be explained for each of six patterns (three cash flow classification patterns x two deposit / withdrawal classification patterns).
[0069] In the case where the cash flow category is "0: plan" and the deposit / withdrawal category is "0: deposit" in the cash flow management information 106n, the cash flow management generation unit 102a generates the cash flow management information 106n based on the project information 106a and the scheduled deposit information 106b, which have the same project number, by setting the department code in the project information 106a as the department code in the cash flow management information 106n and setting the scheduled deposit amount in the scheduled deposit information 106b as the amount in the cash flow management information 106n (see Figures 7 and 8).
[0070] In the case where the cash flow category is "1: Plan" and the deposit / withdrawal category is "0: Deposit" in the cash flow management information 106n, the cash flow management generation unit 102a generates the cash flow management information 106n by setting the department code in the project information 106a as the department code in the cash flow management information 106n based on the project information 106a and any one of the previous billing information 106c, sales information 106d, and billing information 106e having the same project number, and setting the previous billing amount in the previous billing information 106c, the amount to be collected in the sales information 106d, or the billing amount in the billing information 106e as the amount in the cash flow management information 106n (see Figures 13 and 14).
[0071] In the case where the cash flow category in the cash flow management information 106n is "2: Actual results" and the deposit / withdrawal category is "0: Deposit", the cash flow management generation unit 102a generates cash flow management information 106n based on project information 106a and deposit information 106f which have the same project number, by setting the department code in project information 106a as the department code in the cash flow management information 106n and setting the deposit amount in deposit information 106f as the amount in the cash flow management information 106n (see Figures 19 and 21).
[0072] In the case where the cash flow management information 106n has a cash flow category of "0: plan" and a cash flow category of "1: withdrawal", the cash flow management generation unit 102a generates cash flow management information 106n based on project information 106a and order information 106g which have the same project number, by setting the department code in project information 106a as the department code in cash flow management information 106n and setting the order amount in order information 106g as the amount in cash flow management information 106n (see Figures 13 and 15).
[0073] In the case where the cash flow category in the cash flow management information 106n is "1: Plan" and the deposit / withdrawal category is "1: Withdrawal", the cash flow management generation unit 102a generates the cash flow management information 106n based on the project information 106a and the purchase information 106h which have the same project number, by setting the department code in the project information 106a as the department code in the cash flow management information 106n and setting the purchase amount in the purchase information 106h as the amount in the cash flow management information 106n (see Figures 19 and 26).
[0074] In the case where the cash flow category in the cash flow management information 106n is "2: Actual results" and the deposit / withdrawal category is "1: Withdrawal", the cash flow management generation unit 102a generates cash flow management information 106n based on project information 106a and payment information 106i which have the same project number, by setting the department code in the project information 106a as the department code in the cash flow management information 106n and setting the payment amount in the payment information 106i as the amount in the cash flow management information 106n (see Figures 19 and 31).
[0075] The schedule information generation unit 102b identifies from the work output target details 106q a matrix in the table of the work output target details 106q that matches the cash flow category, deposit / withdrawal category and period in the cash flow management information 106n, and generates project / department-based cash flow schedule information (construction-specific cash flow schedule information 106r), which is cash flow schedule information on a project and department combination basis, by storing the amounts in the cash flow management information 106n in the identified matrix (see Figures 11, 17, 24, 29 and 34).
[0076] Based on the generated project / department-based cash flow schedule information (construction-specific cash flow schedule), the schedule output unit 102c generates a project / department-specific cash flow schedule (construction-specific cash flow schedule), which is a cash flow schedule on a project / department combination basis, in which the combination of cash flow category and deposit / withdrawal category is used as one axis and the period is used as the other axis, and amounts are stored in a matrix specified by these two axes (see Figures 12, 18, 25, 30 and 35).
[0077] The schedule output unit 102c outputs a departmental cash flow schedule, which is a cash flow schedule by department, by aggregating the amounts in the generated project / department-specific cash flow schedule (construction-specific cash flow schedule) by department (see Figure 36).
[0078] The schedule output unit 102c totals the amounts in the generated departmental cash flow schedules, and outputs a company-wide cash flow schedule, which is a company-wide cash flow schedule (see FIG. 37).
[0079] [3. Specific examples of processing] In this section, a specific example of the processing according to this embodiment will be described. Below, the generation of the project-specific cash flow schedule will be explained by processing month (2021 / 02-2021 / 06) in [3-1] to [3-4], the generation of the department-specific cash flow schedule will be explained in [3-5], and the generation of the company-wide cash flow schedule will be explained in [3-6].
[0080] [3-1. Generate a cash flow forecast by construction project for February 2021] First, the generation of a construction-specific cash flow schedule when the year and month processed by the system is set to 2021 / 02 will be explained using Figures 7 to 12.
[0081] (1) Generation of project information 106a First, as shown in Fig. 7, project information 106a is generated for each contract with a business partner in order to use it as a management unit for construction work. The billing destination and contract status are input in the project information 106a. In the example of project information 106a in Fig. 7, "10: Inquiry" is registered as the contract status, and in this case, the inquiry date is input.
[0082] (2) Generation of deposit schedule information 106b Next, as shown in Fig. 8, expected payment information 106b is registered for the project. In expected payment information 106b, the transaction method, amount, and expected billing date are registered. In expected payment information 106b, the expected collection date and cash in / out date are calculated with reference to billing destination master 106j, with the expected billing date as the calculation target date.
[0083] (3) Generation of cash flow management information 106n and work-specific cash flow schedule information 106p Next, the cash flow management generating unit 102a generates cash flow management information 106n from the project information 106a and the scheduled payment information 106b, as shown in Fig. 8. Here, the contract status "10: Inquiry" in the project information 106a in Fig. 7 corresponds to the "planning stage" in cash flow management, so the cash flow classification is registered as "0: Plan" as shown in the cash flow management information 106n in Fig. 8. Also, the fact that the scheduled payment information 106b has been registered means that "payment" in cash flow management will be made in the future, so the deposit / withdrawal classification is registered as "0: Deposit" as shown in the cash flow management information 106n in Fig. 8.
[0084] As shown in the cash flow management information 106n in Fig. 8, when the cash flow category is "0: plan" and the deposit / withdrawal category is "0: deposit", the cash flow management generation unit 102a sets the amount in the deposit schedule information 106b as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the cash flow management generation unit 102a sets the amount in the deposit schedule information 106b, calculated by tallying up the amounts in the deposit schedule information 106b by record unit having the same combination of deposit schedule number, transaction method, scheduled collection date, and CASHIN / OUT date, as the amount in the cash flow management information 106n.
[0085] 8. Furthermore, the cash flow management generating unit 102a sets the department "Department A" in the project information 106a in FIG. 7 as a department in the cash flow management information 106n in FIG.
[0086] Next, as shown in Fig. 9, the amounts in the generated cash flow management information 106n are aggregated by project number, customer code, cash flow category, deposit / withdrawal category, and CASHIN / OUT year / month to generate work-specific cash flow schedule information 106p. The generated work-specific cash flow schedule information 106p is one of the two pieces of information that are used to generate work-specific cash flow schedule information 106r.
[0087] (4) Creating work output target details 106q Here, we will explain the generation of the work output target details 106q, which is the other of the two pieces of information that are the basis for generating the construction-specific cash flow schedule information 106r. The work output target details 106q shown in Fig. 10 are generated based on the output target detail information (vertical axis) and the output target year and month information (horizontal axis) shown in Fig. 10. The target year and month in the output target year and month information (horizontal) is generated from the extraction conditions specified when the construction-specific cash flow schedule is output. For example, if the base month specified as the extraction condition is 2021 / 02, the target months will be the base month - 1 month or earlier (before 2021 / 01), the specified base month (2021 / 02), base month + 1 month (2021 / 03), base month + 2 months (2021 / 04), base month + 3 months (2021 / 05), base month + 4 months (2021 / 06), base month + 5 months (2021 / 07), and base month + 6 months or later (2021 / 08 or later).
[0088] (5) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Next, the generated work project-specific cash flow schedule information 106p in Figure 9 is expanded into work output target details 106q in Figure 10 by project number, client code, cash flow category, deposit / withdrawal category and target year / month, thereby generating work project-specific cash flow schedule information 106r in Figure 11.
[0089] Specifically, the schedule information generation unit 102b identifies the record in the first row in the work output target details 106q in Figure 10 as a record having the same cash flow category ``0: Plan'' and deposit / withdrawal category ``0: Deposit'' in the work project-specific cash flow schedule information 106p in Figure 9. Then, the schedule information generating unit 102b stores the amount of 1,100,000 for 2021 / 04 in the work construction-specific cash flow schedule information 106p of FIG. 9 in the column of 2021 / 04 in the specified first row record, stores the amount of 3,300,000 for 2021 / 05 in the work construction-specific cash flow schedule information 106p of FIG. 9 in the column of 2021 / 05 in the specified first row record, and stores the amount of 2,200,000 for 2021 / 08 and later in the work construction-specific cash flow schedule information 106p of FIG. 9 in the column of 2021 / 08 and later in the specified first row record. In addition, the schedule information generating unit 102b adds the project number and customer code in the work construction-specific cash flow schedule information 106p of FIG. 9 to the leftmost column of the work output target details 106q of FIG. 10. The construction-by-construction fund flow schedule information 106r thus generated is shown in FIG.
[0090] Finally, the schedule output unit 102c outputs the construction-specific cash flow schedule (base date=2021 / 02) shown in Fig. 12 based on the construction-specific cash flow schedule information 106r generated by the schedule information generation unit 102b. The construction-specific cash flow schedule shown in Fig. 12 is a cash flow schedule for the A department for the construction identified by project number PJ200001.
[0091] [3-2. Generate a cash flow forecast by construction project for March 2021] Next, the generation of a construction-by-construction cash flow schedule when the year and month processed by the system is set to 2021 / 03 will be described with reference to FIGS. 13 to 18.
[0092] (1) Generation of project information 106a When a registered project is ordered, the project information 106a is updated as shown in Fig. 13. Specifically, in the generated project information 106a in Fig. 7, the contract status is changed from "10: Inquiry" to "20: Order Received," and "2021 / 03 / 01" is registered as the order date.
[0093] (2) Generation of pre-invoice information 106c Next, as shown in Fig. 14, pre-billing information 106c is registered for the project. In pre-billing information 106c, the transaction method, amount, and pre-billing date are registered. In pre-billing information 106c, the pre-billing date is used as the calculation target date, and the scheduled collection date and cash-in / out date are calculated by referring to billing destination master 106j.
[0094] (3) Generation of cash flow management information 106n based on previous billing information 106c Next, the cash flow management generating unit 102a generates cash flow management information 106n from the project information 106a and the advance billing information 106c, as shown in Fig. 14. Here, the contract status "20: Order received" in the project information 106a in Fig. 13 corresponds to the "planned stage" in cash flow management, so the cash flow classification is registered as "1: Planned" as shown in the cash flow management information 106n in Fig. 14. Also, the fact that the advance billing information 106c has been registered means that "deposit" in cash flow management will be made in the future, so the deposit / withdrawal classification is registered as "0: Deposit" as shown in the cash flow management information 106n in Fig. 14.
[0095] As shown in the cash flow management information 106n in Fig. 14, when the cash flow classification is "1: Plan" and the deposit / withdrawal classification is "0: Deposit", the cash flow management generation unit 102a sets the amount in the previous billing information 106c as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the cash flow management generation unit 102a sets the amount in the previous billing information 106c, calculated by tallying up the amounts in the previous billing information 106c by record unit having the same combination of previous billing number, project number, billing destination (customer), transaction category, scheduled collection date (accounting date), and CASHIN / OUT date, as the amount in the cash flow management information 106n.
[0096] 14. Furthermore, the cash flow management generating unit 102a sets the department "Department A" in the project information 106a in FIG. 13 as a department in the cash flow management information 106n in FIG.
[0097] (4) Generation of purchase order information 106g Next, as shown in Fig. 15, order information 106g is registered for the project. In other words, an order is placed with a subcontractor. In order information 106g, the payee, transaction method, amount, order date, and planned purchase date are registered. In order information 106g, the planned payment date and cash in / out date are calculated with reference to payee master 106k, using the planned purchase date as the calculation target date.
[0098] (5) Generation of cash flow management information 106n based on order information 106g Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and the order information 106g, as shown in Fig. 15. Here, the order information 106g is information at the planning stage as shown in Fig. 2, so the cash flow classification is registered as "0: Plan", as shown in the cash flow management information 106n in Fig. 15. Also, since the order information 106g has been registered, it means that "withdrawal" in the cash flow management will be performed in the future, so the deposit / withdrawal classification is registered as "1: Withdrawal", as shown in the cash flow management information 106n in Fig. 15.
[0099] As shown in the cash flow management information 106n in Fig. 15, when the cash flow category is "0: plan" and the deposit / withdrawal category is "1: withdrawal (payment)", the cash flow management generation unit 102a sets the amount in the order information 106g as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the amount in the order information 106g is calculated by tallying up the amounts in the records with the same combination of order number, project number, payee (business partner), transaction category, scheduled payment date (accounting date) and CASHIN / OUT date, and sets the amount in the cash flow management information 106n.
[0100] 15. Furthermore, the cash flow management generating unit 102a sets the department "Department A" in the project information 106a in FIG. 13 as a department in the cash flow management information 106n in FIG.
[0101] (6) Updating the cash flow management information 106n and the work-specific cash flow schedule information 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n shown in Figure 16 by adding the cash flow management information 106n shown in Figure 14 generated in this item [3-2](3) and the cash flow management information 106n shown in Figure 15 generated in this item [3-2](5) to the cash flow management information 106n shown in Figure 9 generated in [3-1].
[0102] Next, as shown in Fig. 17, the amounts in the generated cash flow management information 106n are aggregated by project number, customer code, cash flow category, deposit / withdrawal category, and CASHIN / OUT year / month to generate work-specific cash flow schedule information 106p. As described above, the generated work-specific cash flow schedule information 106p is one of the two pieces of information that are the basis for generating work-specific cash flow schedule information 106r.
[0103] The method of generating the work output target details 106q, which is the other of the two pieces of information that are the basis for generating the construction-specific cash flow schedule information 106r, is the same as in (4) of [3-1], so a detailed explanation will be omitted. The generated work output target details 106q are as shown in FIG.
[0104] (7) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Next, the schedule information generating unit 102b generates the construction-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the construction-specific cash flow schedule information 106r generated in FIG. 17, the amounts in the two hatched matrices (1,100,000 yen and 550,000 yen) are the newly added amounts.
[0105] Finally, the schedule output unit 102c outputs the construction-specific cash flow schedule (base date=2021 / 03) shown in Fig. 18 based on the construction-specific cash flow schedule information 106r generated by the schedule information generation unit 102b. The construction-specific cash flow schedule shown in Fig. 18 is a cash flow schedule for the A department for the construction identified by project number PJ200001.
[0106] [3-3. Generate a cash flow forecast by construction project for April 2021] Next, the generation of a construction-specific cash flow schedule when the year and month processed by the system is 2021 / 04 will be explained using Figures 19 to 30.
[0107] (1) Generation of project information 106a It is assumed that there are no changes to the project as of April 2021. In this case, the project information 106a will have the same content as the project information 106a for March 2021 shown in FIG. 13, as shown in FIG.
[0108] (2) Generating Sales Information 106g Next, as shown in Fig. 20, sales information 106g is registered for the project. In the sales information 106g, the transaction method, amount, and sales date are registered. In the sales information 106g, the planned collection date and cash in / out date are calculated with reference to the billing destination master 106j, using the sales date as the calculation target date. In the sales information 106g, the planned collection amount is calculated.
[0109] (3) Generation of cash flow management information 106n based on sales information 106g Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and sales information 106g, as shown in Fig. 20. Here, the contract status "20: Order received" in the project information 106a in Fig. 19 corresponds to the "planned stage" in cash flow management, so the cash flow classification is registered as "1: Planned" as shown in the cash flow management information 106n in Fig. 20. Also, since the sales information 106g has been registered, it means that "deposit" in cash flow management will be made in the future, so the deposit / withdrawal classification is registered as "0: Deposit" as shown in the cash flow management information 106n in Fig. 20.
[0110] As shown in the cash flow management information 106n in Fig. 20, when the cash flow classification is "1: Plan" and the deposit / withdrawal classification is "0: Deposit", the cash flow management generation unit 102a sets the planned collection amount in the sales information 106g as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the cash flow management generation unit 102a sets the planned collection amount in the sales information 106g, calculated by tallying up the amount by record unit having the same combination of sales number, project number, billing destination (business partner), transaction classification, planned collection date, and CASHIN / OUT date, as the amount in the cash flow management information 106n.
[0111] (4) Generation of deposit information 106f Next, as shown in Fig. 21, deposit information 106f is registered for the project. In the deposit information 106f, the transaction method, amount, and deposit date are registered. In the deposit information 106f, the deposit date is reflected as the CASHIN / OUT date.
[0112] (5) Generation of cash flow management information 106n based on deposit information 106f Next, the cash flow management generating unit 102a generates cash flow management information 106n from the project information 106a and the deposit information 106f, as shown in Fig. 21. Here, the deposit information 106f is information at the performance stage where a deposit has actually been made, so the cash flow classification is registered as "2: performance", as shown in the cash flow management information 106n in Fig. 21. Also, the fact that the deposit information 106f has been registered means that a "deposit" has been made in cash flow management, so the deposit / withdrawal classification is registered as "0: deposit", as shown in the cash flow management information 106n in Fig. 21.
[0113] As shown in the cash flow management information 106n in Fig. 21, when the cash flow classification is "2: Actual results" and the deposit / withdrawal classification is "0: Deposit," the cash flow management generation unit 102a sets the amount in the deposit information 106f as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the cash flow management generation unit 102a sets the amount in the deposit information 106f, calculated by tallying up the amounts in the records with the same combination of deposit number, project number, billing destination (client), transaction classification, scheduled collection date, and CASHIN / OUT date, as the amount in the cash flow management information 106n.
[0114] (6) Updating the cash flow management information 106n and the work-specific cash flow schedule information 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n shown in Figure 22 by adding the cash flow management information 106n shown in Figure 20 generated in this item [3-3](3) and the cash flow management information 106n shown in Figure 21 generated in this item [3-3](5) to the cash flow management information 106n shown in Figure 16 generated in [3-2].
[0115] Next, as shown in Fig. 23, the amounts in the generated cash flow management information 106n are aggregated by project number, customer code, cash flow category, deposit / withdrawal category, and CASHIN / OUT year / month to generate work-specific cash flow schedule information 106p. As described above, the generated work-specific cash flow schedule information 106p is one of the two pieces of information that are the basis for generating work-specific cash flow schedule information 106r.
[0116] The method of generating the work output target details 106q, which is the other of the two pieces of information that are the basis for generating the construction-specific cash flow schedule information 106r, is the same as in (4) of [3-1], so a detailed explanation will be omitted. The generated work output target details 106q are as shown in FIG.
[0117] (7) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Next, the schedule information generating unit 102b generates the construction-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the construction-specific cash flow schedule information 106r generated in Fig. 24, the amounts in the three hatched matrices (1,100,000 yen, 3,300,000 yen, and 2,200,000 yen) are the newly added amounts.
[0118] Next, the schedule output unit 102c outputs the construction-specific cash flow schedule (base year / month=2021 / 04) shown in Fig. 25 based on the construction-specific cash flow schedule information 106r generated by the schedule information generation unit 102b. The construction-specific cash flow schedule shown in Fig. 25 is a cash flow schedule for the A department for the construction identified by project number PJ200001.
[0119] (8) Registration of purchase information 106h Next, purchase information 106h is registered for the project as shown in Fig. 26. In the purchase information 106h, the transaction method, amount, and purchase date are registered. In the purchase information 106h, the purchase date is used as the calculation date, and the scheduled payment date and cash in / out date are calculated by referring to the payment destination master 106k.
[0120] (9) Generation of cash flow management information 106n based on purchase information 106h Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and purchase information 106h, as shown in Fig. 26. Here, the purchase information 106h is information at the planning stage as shown in Fig. 2, so the cash flow classification is registered as "1: Plan" as shown in the cash flow management information 106n in Fig. 26. Also, since the purchase information 106h has been registered, it means that "withdrawal" in the cash flow management will be performed in the future, so the deposit / withdrawal classification is registered as "1: Withdrawal" as shown in the cash flow management information 106n in Fig. 26.
[0121] As shown in the cash flow management information 106n in Fig. 26, when the cash flow classification is "1: Plan" and the deposit / withdrawal classification is "1: Withdrawal (Payment)", the cash flow management generation unit 102a sets the amount in the purchase information 106h as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the cash flow management generation unit 102a sets the amount in the purchase information 106h, calculated by tallying up the amounts in the purchase information 106h by record unit having the same combination of purchase number, project number, payee (business partner), transaction classification, scheduled payment date (accounting date), and CASHIN / OUT date, as the amount in the cash flow management information 106n.
[0122] (10) Updating the cash flow management information 106n and the work construction cash flow schedule information 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n shown in Figure 27 by adding the cash flow management information 106n shown in Figure 26 generated in (9) of this item [3-3] to the cash flow management information 106n shown in Figure 22 generated in this item [3-3].
[0123] Next, as shown in Fig. 28, the amounts in the generated cash flow management information 106n are aggregated by project number, customer code, cash flow category, deposit / withdrawal category, and CASHIN / OUT year / month to generate work-specific cash flow schedule information 106p. As described above, the generated work-specific cash flow schedule information 106p is one of the two pieces of information that are the basis for generating work-specific cash flow schedule information 106r.
[0124] The method of generating the work output target details 106q, which is the other of the two pieces of information that are the basis for generating the construction-specific cash flow schedule information 106r, is the same as in (4) of [3-1], so a detailed explanation will be omitted. The generated work output target details 106q are as shown in FIG.
[0125] (11) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Next, the schedule information generating unit 102b generates the construction-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the construction-specific cash flow schedule information 106r generated in Fig. 29, the amount (550,000 yen) in one matrix indicated by hatching is the newly added amount.
[0126] Finally, the schedule output unit 102c outputs the construction-specific cash flow schedule (base date=2021 / 04) shown in Fig. 30 based on the construction-specific cash flow schedule information 106r generated by the schedule information generation unit 102b. The construction-specific cash flow schedule shown in Fig. 30 is a cash flow schedule of department A for the construction identified by project number PJ200001.
[0127] [3-4. Generate a cash flow schedule by construction project for May 2021] Next, the generation of a construction-by-construction cash flow schedule when the year and month processed by the system is 2021 / 05 will be described with reference to Figures 31 to 35.
[0128] (1) Generation of payment information 106i First, as shown in Fig. 31, payment information 106i is registered for a project. In the payment information 106i, the payee, transaction method, amount, and payment date are registered. In the payment information 106i, the payment date is reflected as the CASH IN / OUT date.
[0129] (2) Generation of cash flow management information 106n based on payment information 106i Next, the cash flow management generating unit 102a generates cash flow management information 106n from the project information 106a and payment information 106i, as shown in Fig. 31. Here, since the payment information 106i is information at the performance stage where a payment has actually been made, the cash flow classification is registered as "2: performance," as shown in the cash flow management information 106n in Fig. 31. Furthermore, since the registration of the payment information 106i means that a "payment" has been made in cash flow management, the deposit / withdrawal classification is registered as "1: Withdrawal," as shown in the cash flow management information 106n in Fig. 31.
[0130] As shown in the cash flow management information 106n in Fig. 31, when the cash flow category is "2: Actual results" and the deposit / withdrawal category is "1: Withdrawal," the cash flow management generation unit 102a sets the amount in the payment information 106i as the amount in the cash flow management information 106n, as explained using Fig. 6. Specifically, the cash flow management generation unit 102a sets the amount in the payment information 106i, calculated by tallying up the amounts in the payment information 106i by record unit having the same combination of payment number, project number, payee, transaction category, payment date, and CASHIN / OUT date, as the amount in the cash flow management information 106n.
[0131] (3) Updating the cash flow management information 106n and the work-specific cash flow schedule information 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n as shown in Figure 32 by adding the cash flow management information 106n as shown in Figure 31 generated in (2) of this item [3-4] to the cash flow management information 106n as shown in Figure 27 generated in [3-3].
[0132] Next, as shown in Fig. 33, the amounts in the generated cash flow management information 106n are aggregated by project number, customer code, cash flow category, deposit / withdrawal category, and CASHIN / OUT year / month to generate work-specific cash flow schedule information 106p. As described above, the generated work-specific cash flow schedule information 106p is one of the two pieces of information that are the basis for generating work-specific cash flow schedule information 106r.
[0133] The method of generating the work output target details 106q, which is the other of the two pieces of information that are the basis for generating the construction-specific cash flow schedule information 106r, is the same as in (4) of [3-1], so a detailed explanation will be omitted. The generated work output target details 106q are as shown in FIG.
[0134] (4) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Finally, the schedule information generating unit 102b generates the construction-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the construction-specific cash flow schedule information 106r generated as shown in Fig. 34, the amount (550,000 yen) in one matrix indicated by hatching is the newly added amount.
[0135] Finally, the schedule output unit 102c outputs the construction-specific cash flow schedule (base date=2021 / 05) shown in Fig. 35 based on the construction-specific cash flow schedule information 106r generated by the schedule information generation unit 102b. The construction-specific cash flow schedule shown in Fig. 35 is a cash flow schedule for the A department for the construction identified by project number PJ200001.
[0136] [3-5. Creating a departmental cash flow forecast] Next, the generation of a departmental cash flow schedule will be described with reference to FIG.
[0137] The schedule output unit 102c generates a departmental cash flow schedule for the A department by aggregating the project-specific cash flow schedules for multiple projects in the A department generated by the methods [3-1] to [3-4] by department (however, the values in the specific examples of [3-1] to [3-4] are not related to the values in the specific example of this item [3-5]). Specifically, if the project-specific cash flow schedule for the A project in the A department is the content shown in the seven rows (1) to (7) shown in "A project" in FIG. 36, and the project-specific cash flow schedule for the B project in the A department is the content shown in the seven rows (1) to (7) shown in "B project" in FIG. 36, the schedule output unit 102c generates the rows shown in (8) to (21) in FIG. 36 by aggregating the values of these 14 rows, and generates a departmental cash flow schedule for the A department.
[0138] When generating a departmental cash flow forecast, it is possible to specify as extraction conditions which values of inquiries (plans), orders (plans), and sales (results) should be included in the table. It is also possible to display the values included in the table as a "status" displayed next to the table.
[0139] Here, if the time (present) when the departmental cash flow forecast in Figure 36 was generated is the end of June 2021, the value in the "Net" row in the table is calculated using different formulas for the elapsed months (April 2021 to June 2021) and future months (July 2021 to November 2021), as explained below. For the elapsed months (April 2021 to June 2021), the value in the "Net" row is calculated by subtracting the value in the row with cash flow category "2: Actual" and deposit / withdrawal category "1: Payment" from the value in the row with cash flow category "2: Actual" and deposit / withdrawal category "0: Deposit". For future months (2021 / 07~2021 / 11), the value in the balance row is calculated by subtracting the value in the row with cash flow category "1: Plan" and cash flow category "0: Deposit" from the value in the row with cash flow category "1: Plan" and cash flow category "1: Payment."
[0140] In this way, by generating a departmental cash flow forecast and calculating the departmental total amount, for example, the status of each construction project belonging to each department can be displayed, and the monthly and cumulative amounts of the department can be confirmed. Also, for example, the department manager can check whether there are any months in which his / her department is experiencing negative spreads, or whether there is a small amount of prepayments collected and collections are concentrated in the latter half of the month.
[0141] [3-6. Generate a company-wide cash flow forecast] Finally, the generation of the company-wide cash flow schedule will be explained with reference to FIG.
[0142] The schedule output unit 102c generates a company-wide cash flow schedule for the entire company by aggregating multiple departmental cash flow schedules generated by the method of [3-5] (however, the values in the specific example of [3-5] are not related to the values in the specific example of this item [3-6]). Specifically, if the departmental cash flow schedule for the A department is as shown in the seven rows (1) to (7) shown under "A department" in Fig. 37, and the departmental cash flow schedule for the headquarters is as shown in the seven rows (1) to (7) shown under "Headquarters" in Fig. 37, the schedule output unit 102c generates the rows (8) to (21) shown in Fig. 37 by aggregating the values of these 14 rows, thereby generating a company-wide cash flow schedule for the entire company.
[0143] When generating a company-wide cash flow forecast, the method for specifying extraction conditions, displaying "status," and calculating the value of the "Net" row in the table is the same as in the case of the departmental cash flow forecast described in [3-5], so a detailed explanation will be omitted.
[0144] In this way, by generating a company-wide cash flow forecast and calculating the total amount for the entire company, it is possible to display the totals for each department and check the monthly and cumulative amounts for the entire company. It is also possible to get an overview of the entire company and check departments and months that are experiencing negative spreads. And, for example, by adding the headquarters' expenditure plans to the debt, it is possible to check and verify the cash flow forecast for the entire company in more detail.
[0145] [4. Summary of the present embodiment] In this way, the cash flow schedule management device 100 according to this embodiment generates a cash flow schedule for each construction project, department, or company, making it possible to grasp the amount of incoming and outgoing funds for each stage of cash flow and for each period. The cash flow schedule management device 100 according to this embodiment is particularly useful in industries where long-term contracts are involved and individual cost calculation is required (such as the construction industry, IT (Information Technology) industry, and production industry).
[0146] Furthermore, according to the cash flow schedule management apparatus 100 of this embodiment, for example, measures can be devised on a case-by-case basis for improving cash flow for each department and site based on a company-wide forecast.
[0147] According to the cash flow schedule management device 100 of this embodiment, for example, it is possible to simulate the future taking into account unconfirmed information such as inquiries and contracts.
[0148] Furthermore, in [3. Specific examples of processing], cash flow plan management based on scheduled deposit and withdrawal dates was explained, but according to the cash flow plan management device 100 of this embodiment, if it is possible to switch to the basis of recording sales and purchases, for example, it is also possible to predict the outlook on a profit basis and a cash basis.
[0149] Furthermore, according to the cash flow plan management device 100 of this embodiment, it is possible to create and simulate cash flows at future times, for example, by generating journal entry data for planned actual data at a specific time point and setting it on the accounting system side.
[0150] [5. 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 goals 8 and 9 of the SDGs.
[0151] 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.
[0152] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0153] 6. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0154] 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.
[0155] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0156] Moreover, with regard to the cash flow schedule management device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.
[0157] For example, the processing functions of the cash flow schedule management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the cash flow schedule management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form the control unit.
[0158] In addition, this computer program may be stored in an application program server connected to the cash flow schedule management device 100 via any network, and it is also possible to download all or a part of it as needed.
[0159] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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.
[0160] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. 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, may use well-known configurations and procedures.
[0161] The various databases etc. 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 etc. used for various processes and providing websites.
[0162] The cash flow schedule management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The cash flow schedule management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.
[0163] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0164] The present invention is useful, for example, in industries that employ individual cost management, and is particularly useful in the construction and IT industries. [Explanation of symbols]
[0165] 100 Cash flow plan management device 102 Control section 102a Cash Flow Management Generation Department 102b Schedule information generating unit 102c Schedule output section 104 Communication interface section 106 Storage section 106a Project Information 106b Deposit Schedule Information 106c billing information 106d Sales Information 106e Billing Information 106f Deposit Information 106g Ordering Information 106h Purchase Information 106i Payment Information 106j Billing Master 106k Payment destination master 106m Transaction Method Master 106n Cash Flow Management Information 106p Work construction-specific cash flow schedule information 106q Work output target details 106r Construction-specific cash flow schedule information 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. A cash flow plan management device including a control unit and a storage unit, The storage unit includes: cash flow management information including case identification data, department identification data, a cash flow classification which is a classification for identifying whether the cash flow is at a planned, scheduled, or actual stage, a deposit / withdrawal classification which is a classification for identifying deposits or withdrawals, the amount to be deposited or withdrawn, and the period including the date on which the amount was or was cashed; A work output target detail which is a table having a combination of the cash flow category and the deposit / withdrawal category on one axis and a period on the other axis; is stored, The control unit is a schedule information generating means for generating item / department unit cash flow schedule information, which is cash flow schedule information for a combination of an item specified by the item identification data and a department specified by the department identification data, by identifying a matrix in the table that matches the cash flow category, the deposit / withdrawal category, and the period in the cash flow management information from the work output target details and storing the amount in the identified matrix; a schedule output means for outputting a cash flow schedule by case / department, which is a cash flow schedule by case and department, based on the generated cash flow schedule information by case / department, in which the combination of the cash flow category and the deposit / withdrawal category is set as one axis and the period is set as the other axis, and the amount is stored in a matrix specified by these two axes; To have A cash flow planning management device comprising:
2. The schedule output means includes: aggregating the amounts in the generated project / department-specific cash flow forecast by department, thereby outputting a department-specific cash flow forecast, which is a cash flow forecast by department; 2. The cash flow schedule management device according to claim 1,
3. The schedule output means includes: outputting a company-wide cash flow forecast, which is a cash flow forecast on a company-wide basis, by aggregating the amounts in the generated departmental cash flow forecasts; 3. The cash flow schedule management device according to claim 2,
4. The storage unit includes: project information including case identification data and department identification data; Payment schedule information including case identification data and a payment schedule amount; is further stored, The control unit is a cash flow management generating means for generating the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the expected deposit amount in the expected deposit information as the amount in the cash flow management information, based on the project information and the expected deposit information in which the case identification data is the same, when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in a planning stage and the deposit classification is a classification for identifying deposits in the cash flow management information Further comprising:
4. A cash flow schedule management device according to claim 1, wherein:
5. The storage unit includes: project information including case identification data and department identification data; prior claim information including case identification data and prior claim amount; Sales information including case identification data and a planned collection amount; billing information including case identification data and billing amount; is further stored, The control unit is a cash flow management generating means for generating the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information based on the project information and any one of the prior billing information, the sales information, and the billing information in which the case identification data is the same, and setting the prior billing amount in the prior billing information, the planned collection amount in the sales information, or the billing amount in the billing information as the amount in the cash flow management information, when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in a planned stage and the deposit / withdrawal classification is a classification for identifying a deposit Further comprising:
4. A cash flow schedule management device according to claim 1, wherein:
6. The storage unit includes: project information including case identification data and department identification data; Deposit information including case identification data and a deposit amount; is further stored, The control unit is a cash flow management generating means for generating the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the deposit amount in the deposit information as the amount in the cash flow management information, based on the project information and the deposit information in which the case identification data is the same, when the cash flow classification in the cash flow management information is a classification for identifying that the cash flow is in the performance stage and the deposit classification is a classification for identifying deposits in the cash flow management information Further comprising:
4. A cash flow schedule management device according to claim 1, wherein:
7. The storage unit includes: project information including case identification data and department identification data; Order information including item identification data and an order amount; is further stored, The control unit is a cash flow management generating means for generating the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the order amount in the order information as the amount in the cash flow management information, based on the project information and the order information in which the case identification data is the same, when the cash flow classification is a classification for identifying that the cash flow is in a planning stage and the deposit / withdrawal classification is a classification for identifying a withdrawal, Further comprising:
4. A cash flow schedule management device according to claim 1, wherein:
8. The storage unit includes: project information including case identification data and department identification data; Purchase information including item identification data and a purchase amount; is further stored, The control unit is a cash flow management generating means for generating the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the purchase amount in the purchase information as the amount in the cash flow management information, based on the project information and the purchase information having the same case identification data, when the cash flow classification is a classification for identifying that the cash flow is in a planning stage and the deposit / withdrawal classification is a classification for identifying a withdrawal, Further comprising:
4. A cash flow schedule management device according to claim 1, wherein:
9. The storage unit includes: project information including case identification data and department identification data; payment information including case identification data and a payment amount; is further stored, The control unit is a cash flow management generating means for generating the cash flow management information by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the payment amount in the payment information as the amount in the cash flow management information, based on the project information and the payment information in which the case identification data is the same, when the cash flow classification is a classification for identifying that the cash flow is in the performance stage and the deposit / withdrawal classification is a classification for identifying a withdrawal, Further comprising:
4. A cash flow schedule management device according to claim 1, wherein:
10. The said project is a construction project, 10. A cash flow schedule management device according to claim 1, for use in the construction industry.
11. A method for managing a cash flow plan executed by an information processing device having a control unit and a storage unit, The storage unit includes: cash flow management information including case identification data, department identification data, a cash flow classification which is a classification for identifying whether the cash flow is at a planned, scheduled, or actual stage, a deposit / withdrawal classification which is a classification for identifying deposits or withdrawals, the amount to be deposited or withdrawn, and the period including the date on which the amount was or was cashed; A work output target detail which is a table having a combination of the cash flow category and the deposit / withdrawal category on one axis and a period on the other axis; is stored, Executed by the control unit, a schedule information generating step of generating item / department unit cash flow schedule information, which is cash flow schedule information for a combination of an item identified by the item identification data and a department identified by the department identification data, by identifying a matrix in the table that matches the cash flow category, the deposit / withdrawal category, and the period in the cash flow management information from the work output target details and storing the amount in the identified matrix; a schedule output step of outputting a cash flow schedule by project / department, which is a cash flow schedule by project and department, based on the generated cash flow schedule information by project / department, in which the combination of the cash flow category and the deposit / withdrawal category is set as one axis and the period is set as the other axis, and the amount is stored in a matrix specified by these two axes; containing, A cash flow forecast management method comprising the steps of:
12. A cash flow plan management program to be executed by an information processing device having a control unit and a storage unit, The storage unit includes: cash flow management information including case identification data, department identification data, a cash flow classification which is a classification for identifying whether the cash flow is at a planned, scheduled, or actual stage, a deposit / withdrawal classification which is a classification for identifying deposits or withdrawals, the amount to be deposited or withdrawn, and the period including the date on which the amount was or was cashed; A work output target detail which is a table having a combination of the cash flow category and the deposit / withdrawal category on one axis and a period on the other axis; is stored, To cause the control unit to execute a schedule information generating step of generating item / department unit cash flow schedule information, which is cash flow schedule information for a combination of an item identified by the item identification data and a department identified by the department identification data, by identifying a matrix in the table that matches the cash flow category, the deposit / withdrawal category, and the period in the cash flow management information from the work output target details and storing the amount in the identified matrix; a schedule output step of outputting a cash flow schedule by project / department, which is a cash flow schedule by project and department, based on the generated cash flow schedule information by project / department, in which the combination of the cash flow category and the deposit / withdrawal category is set as one axis and the period is set as the other axis, and the amount is stored in a matrix specified by these two axes; containing, A cash flow forecast management program characterized by:
Citation Information
Patent Citations
Financial calculation device, financial calculation method, financial calculation program and computer readable recording medium having the same recorded thereon
JP2003216796A
Cash flow planning support system and program
JP2004252590A
Fund management assisting device and fund management assisting method
JP2017068401A
Credit decision data providing system for construction industry
JP2020129168A
