JP7590286B2 - FUNDING PLAN MANAGEMENT DEVICE, FUNDING PLAN MANAGEMENT METHOD, AND FUNDING PLAN MANAGEMENT PROGRAM - Google Patents

Description

The present invention relates to a cash flow schedule management device, a cash flow schedule management method, and a cash flow schedule management program.

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 are suitable for funds management such as analysis and forecasting of funds in corporate groups that operate globally (see paragraph 0007 of Patent Document 1, etc.).

JP 2017-68401 A

In the construction industry, for example, there is often a multi-layered structure of subcontractors, and it often takes a long 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 understand the cash flow plan (how much to deposit and when, how much to withdraw, etc.).

However, in conventional technologies 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 the information using Excel or similar. This resulted in a very heavy workload and the problem of being unable to grasp the cash flow at an early stage.

The present invention has been made in consideration of the above 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 make it possible to grasp the amount of deposits and withdrawals for each cash flow stage and period.

In order to solve the above-mentioned problems and achieve the object, the cash flow schedule management device of the present invention is a cash flow schedule management device equipped with a control unit and a memory unit, the memory unit stores case identification data, department identification data, cash flow classifications which are classifications for identifying whether cash flow is at a planned, scheduled, or actual stage, deposit and withdrawal classifications which are classifications for identifying deposits or withdrawals, cash flow management information including amounts to be deposited or withdrawn, and periods including dates on which the amounts are to be cashed or have been cashed, and work output target details which are tables with combinations of the cash flow classifications and the deposit and withdrawal classifications on one axis and periods on the other axis, and the control unit extracts the cash flow information in the cash flow schedule management device from the work output target details. The system is characterized by comprising: a schedule information generating means for generating item/department-based 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 means for outputting an item/department-based cash flow schedule, which is a cash flow schedule for the combination of the item and the department, based on the generated item/department-based cash flow schedule information, in which the combination of the cash flow category and the deposit/withdrawal category is on one axis and the period is on the other axis, and the amount is stored in a matrix identified by these two axes.

In addition, in the cash flow schedule management device according to the present invention, the schedule output means is characterized in that it outputs a departmental cash flow schedule, which is a cash flow schedule by department, by aggregating the amounts in the generated case/departmental cash flow schedule by department.

In addition, in the cash flow schedule management device according to 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.

In the cash flow schedule management device according to the present invention, the storage unit further stores project information including case identification data and department identification data, and deposit schedule information including the case identification data and the planned deposit 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 deposits, based on the project information and the deposit schedule information for which the case identification data is the same, by setting the department identification data in the project information as the department identification data in the cash flow management information and setting the planned deposit amount in the deposit schedule information as the amount in the cash flow management information.

In addition, in the cash flow schedule management device according to the present invention, the storage 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 includes a cash flow management generation 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 any one of the project information, the previous billing information, the sales information, and the billing information in which the case identification data is the same, 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, 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 deposits.

In addition, in the cash flow schedule management device according to the present invention, the storage 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 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 performance stage and the deposit/withdrawal classification is a classification for identifying deposits, based on the project information and the deposit information for which the case identification data is the same, 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.

In the cash flow schedule management device according to the present invention, the storage 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 includes a cash flow management generation 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 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.

In addition, in the cash flow schedule management device according to the present invention, the storage 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 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 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 planning stage and the deposit/withdrawal classification is a classification for identifying withdrawals.

In the cash flow schedule management device according to the present invention, the storage 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 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 performance stage and the deposit/withdrawal classification is a classification for identifying withdrawals, based on the project information and the payment information in which the case identification data is the same, 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.

The cash flow schedule management device according to the present invention is characterized in that the project is a construction project and is used in the construction industry.

In addition, in the cash flow schedule management method according to the present invention, a cash flow schedule management method is executed by an information processing device having a control unit and a storage unit, and the storage unit stores case identification data, department identification data, cash flow classifications for identifying whether the cash flow is at a planned, scheduled, or actual stage, deposit/withdrawal classifications for identifying deposits or withdrawals, amounts to be deposited or withdrawn, and periods to which the dates on which the amounts are to be cashed or have been cashed belong, and work output target details which are tables with combinations of the cash flow classifications and the deposit/withdrawal classifications on one axis and periods on the other axis, and the control unit executes the cash flow management method by extracting the cash flow classifications in the cash flow management information from the work output target details. The method includes a schedule information generating step of generating project/department-based cash flow schedule information, which is cash flow schedule information for the combination of the project identified by the project identification data and the department identified by the department identification data, by identifying a matrix in the table that matches the deposit/withdrawal category and the period, and storing the amount in the identified matrix; and a schedule output step of outputting a project/department-based cash flow schedule, which is a cash flow schedule for the combination of the project and the department, based on the generated project/department-based cash flow schedule information, in which the combination of the deposit/withdrawal category and the period is set as one axis and the amount is stored in a matrix specified by these two axes.

In addition, the cash flow schedule management program according to the present invention is a cash flow schedule management program to be 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 classifications which are classifications for identifying whether cash flow is at a planned, scheduled, or actual stage, deposit/withdrawal classifications which are classifications for identifying deposits or withdrawals, amounts to be deposited or withdrawn, and periods to which the dates on which the amounts are to be cashed or have been cashed belong, and work output target details which are tables with combinations of the cash flow classifications and the deposit/withdrawal classifications on one axis and periods on the other axis, and the memory unit stores, from the work output target details, cash flow management information including: The method includes a schedule information generating step of generating project/department-based cash flow schedule information, which is cash flow schedule information for the combination of the project identified by the project 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 a project/department-based cash flow schedule, which is a cash flow schedule for the combination of the project and the department, based on the generated project/department-based cash flow schedule information, 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 identified by these two axes.

The present invention has the effect of making it possible to grasp the amount of deposits and withdrawals for each stage of cash flow and for each period.

FIG. 1 is a block diagram showing an example of the configuration of a financial flow schedule management device. FIG. 2 is a diagram showing an example of a system configuration according to the present embodiment. FIG. 3 is a diagram showing an example of a method for calculating the billing destination master and the scheduled collection date. FIG. 4 is a diagram showing an example of the payee master. FIG. 5 is a diagram illustrating an example of the transaction method master. FIG. 6 is a diagram showing an example of the source of acquisition of amounts in the cash flow management information. FIG. 7 is a diagram showing an example of project information registered in 2021/02. FIG. 8 is a diagram showing an example of expected deposit information and cash flow management information registered in 2021/02. FIG. 9 is a diagram showing an example of work project-specific cash flow schedule information generated in 2021/02. FIG. 10 is a diagram showing an example of the generation of a work output target detail. FIG. 11 is a diagram showing an example of construction-specific cash flow schedule information generated in 2021/02. FIG. 12 is a diagram showing an example of a construction-specific cash flow schedule output in February 2021. FIG. 13 is a diagram showing an example of project information registered in 2021/03. FIG. 14 is a diagram showing an example of pre-billing information and cash flow management information registered in March 2021. FIG. 15 is a diagram showing an example of order information and cash flow management information registered in 2021/03. FIG. 16 is a diagram showing an example of cash flow management information registered in 2021/03. 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. FIG. 18 is a diagram showing an example of a construction-specific cash flow schedule output in March 2021. FIG. 19 is a diagram showing an example of project information registered in 2021/03 carried over to 2021/04. FIG. 20 is a diagram showing an example of sales information and cash flow management information registered in April 2021. FIG. 21 is a diagram showing an example of deposit information and cash flow management information registered in April 2021. FIG. 22 is a diagram showing an example of cash flow management information registered at the intermediate stage of 2021/04. FIG. 23 is a diagram showing an example of work project-specific cash flow schedule information generated at the midpoint of 2021/04. FIG. 24 is a diagram showing an example of project-specific cash flow schedule information generated at the midpoint of 2021/04. Figure 25 is a diagram showing an example of a construction-specific cash flow schedule output at the midpoint of April 2021. FIG. 26 is a diagram showing an example of purchasing information and cash flow management information to be registered in April 2021. FIG. 27 is a diagram showing an example of cash flow management information registered in 2021/04. FIG. 28 is a diagram showing an example of work project-specific cash flow schedule information generated in April 2021. FIG. 29 is a diagram showing an example of construction-specific cash flow schedule information generated in April 2021. FIG. 30 is a diagram showing an example of a construction-specific cash flow schedule output in April 2021. FIG. 31 is a diagram showing an example of payment information and cash flow management information to be registered in May 2021. FIG. 32 is a diagram showing an example of cash flow management information registered in 2021/05. FIG. 33 is a diagram showing an example of work project-specific cash flow schedule information generated in May 2021. FIG. 34 is a diagram showing an example of construction-specific cash flow schedule information generated in May 2021. FIG. 35 is a diagram showing an example of a construction-specific cash flow schedule output in May 2021. FIG. 36 is a diagram showing an example of a departmental cash flow schedule. FIG. 37 is a diagram showing an example of a company-wide cash flow schedule.

Below, an embodiment 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 drawings. Note that the present invention is not limited to the present embodiment.

[1. Background, Issues and Overview]
This section describes the background, problems and overview of the present invention.

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

In addition, cash flow forecasts are often managed in Excel by the accounting and finance department after issuing invoices, and payment schedules are managed 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 cash flow forecasts including construction schedules at the contract stage, and ideally also at the quotation stage.

And while sales and construction staff are aware of the profits for each project, they often do not pay attention to planned income and expenditures. For this reason, in order to fundamentally improve the company's cash flow problems, it is necessary to make department managers and construction managers, as well as the entire company and accounting staff, aware of planned income and expenditures.

Furthermore, in terms of supporting business continuity during the COVID-19 pandemic, it is expected that the usefulness of managing funds as well as profits will become even more important.

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 meant that creating them was a heavy burden (workload issue). Also, previously, cash flow forecasts were known at the time of invoicing and payment, but information was not collected from the field at the time of receiving or placing an order for a project, so there was an issue that cash flow forecasts could not be confirmed early on (problem of timing).

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

In addition, in this embodiment, for example, planned and actual cash flow information is collected from each business, and managers in different positions, such as at the construction level (from the perspective of the site manager), at the department level (from the perspective of the department manager), and at the company level (from the perspective of management), can check the information at any time as of a specified date.

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.

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 precisely manage the cash flow plan for the entire company. The specific configuration and operation are explained below.

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.

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.

The cash flow schedule management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the cash flow schedule management device 100 is connected to each other so as to be able to communicate with each other via any communication path.

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 masters described below may be stored in the server 200, for example.

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 works with a mouse to provide 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.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like.

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 project-specific cash flow schedule information 106p, work output target details 106q, and work project-specific cash flow schedule information 106r.

Here, project information 106a to payment information 106i are information registered daily as work progresses, and are described in the following section [2-1]. Billing destination master 106j to transaction method master 106m are master information set in advance by the operator, and are described in the following section [2-2]. Cash flow management information 106n to construction-specific cash flow schedule information 106r are information characteristic of the present invention, which are generated through processing, and are described in the following section [2-3].

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

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

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 voucher number that uniquely identifies the previous billing information. The previous billing date is the date the previous billing was registered, and is also the target date used to calculate the scheduled collection date.

Sales information 106d includes, for example, sales number, project number, billing destination, transaction method, sales amount, planned collection amount, sales date, planned collection date, cash in/out date, etc. The sales number is a slip number that uniquely identifies the sales information. The sales date is the date the sales registration was performed, and is also the target date used to calculate the planned collection date. Regarding the planned collection amount, if a pre-billing was performed before the sales registration, the sales amount ≠ the collection amount. Specifically, when the sales are registered, the amount obtained by offsetting the current sales amount and the previous billing amount is set in sales information 106d.

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 planned collection date, and a cash-in/out date. The billing number is a document number that uniquely identifies the billing information. The billing date is the date on which the billing was registered, and is also the target date used to calculate the planned collection date.

The deposit information 106f includes, for example, the deposit number, project number, billing destination, transaction method, deposit amount (amount), scheduled collection date, deposit date, cash in/out date, etc. The deposit number is a slip number that uniquely identifies the deposit information. The deposit date is the date the deposit was registered (the date that reflects the actual deposit).

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 planned purchase date, a planned payment date, and a cash-in/out date. The order number is a document 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 planned purchase date is the target date used to calculate the planned payment date. The planned payment date is the planned payment date of the amount. The cash-in/out date is the date on which cash is withdrawn.

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 voucher number that uniquely identifies the purchase information. The purchase date is the date on which the purchase was registered, and is also the target date used to calculate the scheduled payment date.

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 the 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).

Here, the nature of the deposit schedule information 106b through payment information 106i, and the relationship between this information and the cash flow management information 106n will be explained using Figures 2 and 6.

As shown in FIG. 2, the scheduled deposit information 106b is information that is generated at the deposit planning stage. 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 scheduled deposit information 106b is set as the amount in the cash flow management information 106n.

As shown in FIG. 2, pre-billing information 106c, sales information 106d, and billing information 106e are information that is generated at the stage of planning deposits. As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "1: Plan" and the deposit/withdrawal classification is "0: Deposit," the amounts in pre-billing information 106c, sales information 106d, and billing information 106e are set as the amounts in the cash flow management information 106n.

As shown in FIG. 2, deposit information 106f is information that is generated at the deposit performance stage (= after the deposit has been made). As shown in FIG. 6, in the cash flow management information 106n, if 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.

As shown in FIG. 2, the order information 106g is information that is generated at the planning stage of withdrawal (payment). As shown in FIG. 6, in the cash flow management information 106n, when the cash flow category is "0: planning" 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.

As shown in FIG. 2, purchase information 106h is information that is generated at the stage of planning withdrawal (payment). As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "1: Plan" and the deposit/withdrawal classification is "1: Withdrawal (Payment)", the amount in purchase information 106h is set as the amount in the cash flow management information 106n.

As shown in FIG. 2, payment information 106i is information that is generated at the withdrawal (payment) performance stage (= after the withdrawal (payment) has been completed). As shown in FIG. 6, in the cash flow management information 106n, if 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 the cash flow management information 106n.

[2-2. Billing destination master 106j to 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.

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 calculation of (2) is the year and month to which the calculation date of (1) belongs.
The closing period in (3) is calculated based on the calculation target year and month in (2) and the closing date set in the billing destination master 106j.
The calculation date for (4) will be the calculation date for (2) if the condition (I) is met: the start date of the closing period in (3) ≦ the calculation date for (1) ≦ the end date of the closing period in (3); whereas, if the condition (II) is not met, the calculation date for (2) + 1 month.
The planned 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.

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 the billing destination master 106j → payment month and scheduled collection month in the payment destination master 106k → scheduled payment month and scheduled collection date → scheduled payment date

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 "target date 2021/12/01 + bill site 90 days in the transaction method master 106m".

Collection methods and payment methods can be set by denomination (transaction category) on the transaction method master 106m, and by further breaking down each planned and actual information by denomination, it is also possible to develop a cash flow schedule by denomination. By breaking down by denomination, it is even possible to predict the cash in/out dates of cash and deposits taking into account the bill due date. The cash in/out dates can be calculated based on the bill site set on the transaction method master 106m.

[2-3. Cash Flow Management Information 106n to Cash Flow Schedule Information by Construction Project 106r]
As shown in FIG. 8, the cash flow management information 106n includes, for example, case 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/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/month), etc.

The project number indicates the project number of the cash flow management subject (for example, a construction project). The department code is the code of the department that manages the project. The client code is the code of the client from whom 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 deposit and withdrawal of money is recognized as actual results. 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 into cash or converted into cash. The CASHIN/OUT year and month is the year and month to which the CASHIN/OUT date belongs.

Cash flow schedule information by work project 106p is information obtained by aggregating amounts for records in cash flow management information 106n that have the same combination of project number, customer code, cash flow category, deposit/withdrawal category, and CASHIN/OUT year/month. As shown in FIG. 9, cash flow schedule information by work project 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. 10 etc., the work output target details 106q is a table in which the combination of cash flow category and deposit/withdrawal category is on one axis and the period is on the other axis.

The cash flow schedule information by project 106r is information used to output the cash flow schedule by project. The cash flow schedule information by project 106r is generated by storing the total amount (amount) in the cash flow schedule information by project 106p in a matrix in the work output target details 106q, as will be explained in detail in [3. Specific examples of processing] below. As shown in FIG. 11, the cash flow schedule information by project 106r includes, for example, the project number, the client code, the cash flow category, the deposit/withdrawal category, and the amount by target year and month.

The control unit 102 is a CPU or the like that provides 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, required data, etc., and executes various information processing operations based on these stored programs.

The control unit 102 has, in terms of its functional concept, 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 classification, the deposit/withdrawal classification, and the period in the cash flow management information from the work output target details, and stores the amount in the identified matrix, thereby generating case/department-based cash flow schedule information that is cash flow schedule information for a combination of the case identified by the case 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 a case/department-based cash flow schedule that is a cash flow schedule for a combination of the case and the department, in which the combination of the cash flow classification and the deposit/withdrawal classification is set as one axis and the period is set as the other axis, and the amount is stored in the matrix specified by these two axes, based on the generated case/department-based cash flow schedule information.

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: Actual") 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 the six patterns (three cash flow classification patterns x two deposit/withdrawal classification patterns).

When the cash flow management information 106n has a cash flow category of "0: Plan" and a cash flow category of "0: Deposit", the cash flow management generation unit 102a generates cash flow management information 106n by setting the department code in project information 106a as the department code in cash flow management information 106n and setting the planned deposit amount in deposit schedule information 106b as the amount in cash flow management information 106n based on project information 106a and scheduled deposit information 106b that have the same project number (see Figures 7 and 8).

When the cash flow management information 106n has a cash flow category of "1: Plan" and a cash flow category of "0: Deposit", the cash flow management generation unit 102a generates 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 one of the previous billing information 106c, sales information 106d, and billing information 106e that have the same project number, and setting the previous billing amount in the previous billing information 106c, the planned collection amount 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).

When the cash flow management information 106n has a cash flow category of "2: Actual results" and a cash flow category of "0: Deposit", the cash flow management generation unit 102a generates cash flow management information 106n by setting the department code in project information 106a as the department code in cash flow management information 106n and setting the deposit amount in deposit information 106f as the amount in cash flow management information 106n based on project information 106a and deposit information 106f that have the same project number (see Figures 19 and 21).

When 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 that 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).

When the cash flow management information 106n has a cash flow category of "1: 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 purchase information 106h that 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 purchase amount in purchase information 106h as the amount in cash flow management information 106n (see Figures 19 and 26).

When the cash flow management information 106n has a cash flow category of "2: Actual results" and a cash flow category of "1: Withdrawal," the cash flow management generation unit 102a generates cash flow management information 106n by setting the department code in project information 106a as the department code in cash flow management information 106n and setting the payment amount in payment information 106i as the amount in cash flow management information 106n based on project information 106a and payment information 106i that have the same project number (see Figures 19 and 31).

The schedule information generating unit 102b identifies the 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 from the work output target details 106q, and generates project/department unit 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).

Based on the generated project/department-based cash flow schedule information (construction-based cash flow schedule), the schedule output unit 102c generates a project/department-based cash flow schedule (construction-based cash flow schedule), which is a cash flow schedule for a combination of project and department, with the combination of cash flow category and deposit/withdrawal category on one axis and time period on the other axis, and amounts stored in a matrix specified by these two axes (see Figures 12, 18, 25, 30, and 35).

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/departmental cash flow schedule (construction-specific cash flow schedule) by department (see Figure 36).

The schedule output unit 102c aggregates the amounts in the generated departmental cash flow schedules to output a company-wide cash flow schedule, which is a company-wide cash flow schedule (see Figure 37).

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 (February 2021 to June 2021) 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].

[3-1. Creating 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 the system is processing is set to 2021/02 will be explained using Figures 7 to 12.

(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 a construction project. In the project information 106a, the billing destination and the contract status are input. In the example of the project information 106a in Fig. 7, "10: Inquiry" is registered as the contract status, and in this case, the inquiry date is input.

(2) Generation of expected payment 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.

(3) Generation of Cash Flow Management Information 106n and Work-Specific Cash Flow Schedule Information 106p Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and the expected 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 expected 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.

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 scheduled deposit 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 scheduled deposit information 106b, calculated by tallying the amounts in the scheduled deposit information 106b by record unit with the same combination of scheduled deposit number, transaction method, scheduled collection date, and CASHIN/OUT date, as the amount in the cash flow management information 106n.

The cash flow management generation unit 102a also sets the department "Department A" in the project information 106a in FIG. 7 as the department in the cash flow management information 106n in FIG. 8.

Next, as shown in FIG. 9, the amounts in the generated cash flow management information 106n are aggregated by project number, client 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.

(4) Generation of work output target details 106q Here, 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, will be described. 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 and after (2021/08 and after).

(5) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Next, the generated work construction-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 construction-specific cash flow schedule information 106r in Figure 11.

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 classification as the cash flow classification "0: Plan" and the deposit/withdrawal classification "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-specific cash flow schedule information 106r generated in this way is shown in Figure 11.

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 Department A for the construction identified by project number PJ200001.

[3-2. Creating a cash flow forecast by construction project for March 2021]
Next, the generation of a construction-specific cash flow schedule when the year and month being processed by the system is set to 2021/03 will be explained using Figures 13 to 18.

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

(2) Generation of Advance Billing Information 106c Next, advance billing information 106c is registered for the project, as shown in Fig. 14. In advance billing information 106c, the transaction method, amount, and advance billing date are registered. In advance billing information 106c, the scheduled collection date and the cash in/out date are calculated with reference to billing destination master 106j, using the advance billing date as the calculation target date.

(3) Generation of cash flow management information 106n based on advance billing information 106c Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and 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 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.

As shown in the cash flow management information 106n in FIG. 14, when the cash flow category is "1: Plan" and the deposit/withdrawal category 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 amount in the previous billing information 106c by record unit with the same combination of previous billing number, project number, billing destination (client), transaction category, planned collection date (accounting date), and CASHIN/OUT date, as the amount in the cash flow management information 106n.

The cash flow management generation unit 102a also sets the department "Department A" in the project information 106a in FIG. 13 as the department in the cash flow management information 106n in FIG. 14.

(4) Generation of 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 the order information 106g, the payee, transaction method, amount, order date, and planned purchase date are registered. In the order information 106g, the planned payment date and cash in/out date are calculated with reference to the payee master 106k, using the planned purchase date as the calculation target date.

(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 order information 106g, as shown in Fig. 15. Here, since the order information 106g is information at the planning stage as shown in Fig. 2, the cash flow classification is registered as "0: Plan", as shown in the cash flow management information 106n in Fig. 15. Furthermore, since the order information 106g has been registered, it means that "withdrawal" in 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.

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 set as the amount in the cash flow management information 106n by tallying up the amounts in the order information 106g for records with the same combination of order number, project number, payee (business partner), transaction category, scheduled payment date (accounting date), and CASHIN/OUT date.

The cash flow management generation unit 102a also sets the department "Department A" in the project information 106a in FIG. 13 as the department in the cash flow management information 106n in FIG. 15.

(6) Updating of cash flow management information 106n and cash flow schedule information by work project 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n as shown in FIG. 16 by adding the cash flow management information 106n shown in FIG. 14 generated in (3) of this item [3-2] and the cash flow management information 106n shown in FIG. 15 generated in (5) of this item [3-2] to the cash flow management information 106n shown in FIG. 9 generated in [3-1],

Next, as shown in FIG. 17, the amounts in the generated cash flow management information 106n are aggregated by project number, client 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 used to generate work-specific cash flow schedule information 106r.

The method for 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 Figure 10.

(7) Generation of project-specific cash flow schedule information 106r and output of project-specific cash flow schedule Next, the schedule information generation unit 102b generates project-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the generated project-specific cash flow schedule information 106r shown in Figure 17, the amounts in the two hatched matrices (1,100,000 yen and 550,000 yen) are newly added amounts.

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 the A department's cash flow schedule for the construction identified by project number PJ200001.

[3-3. Creating 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 the system is processing is set to 2021/04 will be explained using Figures 19 to 30.

(1) Generation of project information 106a
It is assumed that there are no changes to the project as of 2021/04. In this case, the project information 106a will have the same content as the project information 106a for 2021/03 shown in FIG. 13, as shown in FIG. 19.

(2) Generation of 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.

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

As shown in the cash flow management information 106n in FIG. 20, when the cash flow category is "1: Plan" and the deposit/withdrawal category 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 with the same combination of sales number, project number, billing destination (client), transaction category, planned collection date, and CASHIN/OUT date, as the amount in the cash flow management information 106n.

(4) Creation 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 CASH IN/OUT date.

(5) Generation of cash flow management information 106n based on deposit information 106f Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and deposit information 106f, as shown in Fig. 21. Here, 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 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.

As shown in the cash flow management information 106n in FIG. 21, when the cash flow category is "2: Actual results" and the deposit/withdrawal category 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 amount in the deposit information 106f by record unit with the same combination of deposit number, project number, billing destination (client), transaction category, scheduled collection date, and CASHIN/OUT date, as the amount in the cash flow management information 106n.

(6) Updating of cash flow management information 106n and cash flow schedule information by work project 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n as shown in FIG. 22 by adding the cash flow management information 106n shown in FIG. 20 generated in (3) of this item [3-3] and the cash flow management information 106n shown in FIG. 21 generated in (5) of this item [3-3] to the cash flow management information 106n shown in FIG. 16 generated in [3-2], as shown in FIG. 22.

Next, as shown in FIG. 23, the amounts in the generated cash flow management information 106n are aggregated by project number, client 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 used to generate work-specific cash flow schedule information 106r.

The method for 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 Figure 10.

(7) Generation of project-specific cash flow schedule information 106r and output of project-specific cash flow schedule Next, the schedule information generation unit 102b generates project-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the generated project-specific cash flow schedule information 106r shown in Fig. 24, the amounts in the three hatched matrices (1,100,000 yen, 3,300,000 yen, and 2,200,000 yen) are newly added amounts.

Next, the schedule output unit 102c outputs the construction-specific cash flow schedule (base date = 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 Department A for the construction identified by project number PJ200001.

(8) Registration of Purchase Information 106h Next, as shown in Fig. 26, purchase information 106h is registered for the project. 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.

(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, since the purchase information 106h is information at the planning stage as shown in Fig. 2, the cash flow classification is registered as "1: Plan" as shown in the cash flow management information 106n in Fig. 26. Furthermore, 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.

As shown in the cash flow management information 106n in FIG. 26, when the cash flow category is "1: Plan" and the deposit/withdrawal category 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 the amounts in the purchase information 106h by record unit with the same combination of purchase number, project number, payee (business partner), transaction category, scheduled payment date (accounting date), and CASHIN/OUT date, as the amount in the cash flow management information 106n.

(10) Updating the cash flow management information 106n and the work project-specific cash flow schedule information 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n as shown in FIG. 27 by adding the cash flow management information 106n shown in FIG. 26 generated in (9) of this item [3-3] to the cash flow management information 106n shown in FIG. 22 generated in this item [3-3].

Next, as shown in FIG. 28, the amounts in the generated cash flow management information 106n are aggregated by project number, client 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 used to generate work-specific cash flow schedule information 106r.

The method for 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 Figure 10.

(11) Generation of project-specific cash flow schedule information 106r and output of project-specific cash flow schedule Next, the schedule information generation unit 102b generates project-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the generated project-specific cash flow schedule information 106r shown in Figure 29, the amount (550,000 yen) in one matrix shown by hatching is the newly added amount.

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 the department A's cash flow schedule for the construction identified by project number PJ200001.

[3-4. Creating a cash flow forecast by construction project for May 2021]
Next, the generation of a construction-specific cash flow schedule when the year and month the system is processing is set to 2021/05 will be explained using Figures 31 to 35.

(1) Creation 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.

(2) Generation of Cash Flow Management Information 106n Based on Payment Information 106i Next, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and the 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.

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 the amounts in the payment information 106i by record unit with 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.

(3) Updating the cash flow management information 106n and the work project-specific cash flow schedule information 106p Next, the cash flow management generation unit 102a updates the cash flow management information 106n as shown in FIG. 32 by adding the cash flow management information 106n shown in FIG. 31, which was generated in (2) of this item [3-4], to the cash flow management information 106n shown in FIG. 27, which was generated in [3-3].

Next, as shown in FIG. 33, the amounts in the generated cash flow management information 106n are aggregated by project number, client 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 used to generate work-specific cash flow schedule information 106r.

The method for 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 Figure 10.

(4) Generation of project-specific cash flow schedule information 106r and output of project-specific cash flow schedules Finally, the schedule information generation unit 102b generates project-specific cash flow schedule information 106r in the same manner as in (5) of [3-1]. In the generated project-specific cash flow schedule information 106r shown in Figure 34, the amount (550,000 yen) in one matrix indicated by hatching is the newly added amount.

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 the A department's cash flow schedule for the construction identified by project number PJ200001.

[3-5. Creating a departmental cash flow forecast]
Next, the generation of a departmental cash flow schedule will be described with reference to FIG.

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 under "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 under "B project" in FIG. 36, the schedule output unit 102c generates the rows (8) to (21) shown in FIG. 36 by aggregating the values of these 14 rows, and generates a departmental cash flow schedule for the A department.

When generating a departmental cash flow forecast, it is possible to specify as extraction conditions which values of inquiries (plans), orders (plans), and sales (actual 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.

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 elapsed months (April 2021 to June 2021) and future months (July 2021 to November 2021), as explained below. For 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."

In this way, by generating a cash flow forecast by department and calculating the total amount for the department, it is possible to display the status of each construction project belonging to each department, and check the monthly and cumulative amounts for the department. In addition, for example, a department manager can check whether there are any months in which their department is experiencing a negative spread, or whether there is a small amount of prepayments collected and collections are concentrated in the latter half of the month.

[3-6. Creating a company-wide cash flow forecast]
Finally, the generation of a company-wide cash flow schedule will be described with reference to FIG.

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 Department A is the content shown in the seven rows (1) to (7) shown under "Department A" in FIG. 37, and the departmental cash flow schedule for the headquarters is the content shown in the seven rows (1) to (7) shown under "Headquarters" in FIG. 37, the schedule output unit 102c generates the rows shown in (8) to (21) in FIG. 37 by aggregating the values of these 14 rows, and generates a company-wide cash flow schedule for the entire company.

When generating a company-wide cash flow forecast, the process for specifying extraction conditions, displaying "status," and calculating the value of the "Net" row in the table is the same as for the departmental cash flow forecast described in [3-5], so a detailed explanation will be omitted.

In this way, by generating a company-wide cash flow forecast and calculating the total amount for the entire company, it is possible, for example, to display the totals for each department and check the monthly and cumulative amounts for the entire company. It is also possible, for example, to get an overview of the entire company and check which departments or months are experiencing negative spreads. And, for example, by adding the headquarters' expenditure plans to the liabilities, it is possible to check and verify the cash flow forecast for the entire company in more detail.

[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 calculations are required (such as the construction industry, the IT (Information Technology) industry, and the production industry).

In addition, the cash flow planning management device 100 according to this embodiment can devise measures for improving cash flow on a case-by-case basis for departments and sites, for example, based on a company-wide forecast.

The cash flow schedule management device 100 according to this embodiment can simulate the future, taking into account unconfirmed information such as inquiries and contracts.

Furthermore, in [3. Specific examples of processing], cash flow schedule management based on scheduled deposit and withdrawal dates was explained, but with the cash flow schedule management device 100 according to this embodiment, for example, if it is possible to switch based on sales and purchases, it is also possible to forecast the outlook on a profit and cash basis.

Furthermore, according to the cash flow planning 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 and setting it on the accounting system side.

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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.

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 a known method.

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

Furthermore, with regard to the cash flow planning management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

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 the 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 is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the cash flow schedule management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, and may also be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, 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 consisting of multiple modules or libraries, and a program that works in conjunction 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, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

The cash flow schedule management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The cash flow schedule management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on 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.

The present invention is useful, for example, in industries that use individual cost management, and is particularly useful in the construction and IT industries.

100: Funds flow plan management device 102: Control unit
102a Cash Flow Management Generation Unit
102b Schedule information generating unit
102c Schedule output unit 104 Communication interface unit 106 Storage unit
106a Project Information
106b Payment 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 destination 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 unit 112 Input device 114 Output device 200 Server 300 Network

Claims (12)

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: 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, 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, 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, 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/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 the project information and the scheduled deposit information in which the case identification data is the same, and setting the scheduled deposit amount in the scheduled deposit information as the amount in the cash flow management information,
4. A cash flow schedule management device according to claim 1, wherein: 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 a billing amount;
is further stored,
The control unit is
a cash flow management generating 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 a planning stage and the deposit/withdrawal classification is a classification for identifying a deposit, 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 pre-billing information, the sales information and the billing information in which the case identification data is the same, and setting the pre-billing amount in the pre-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,
4. A cash flow schedule management device according to claim 1, wherein: 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, 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, 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 the deposit information in which the case identification data is the same, and setting the deposit amount in the deposit information as the amount in the cash flow management information,
4. A cash flow schedule management device according to claim 1, wherein: 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 in the cash flow management information 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,
4. A cash flow schedule management device according to claim 1, wherein: 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 in the cash flow management information 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,
4. A cash flow schedule management device according to claim 1, wherein: 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, 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 a withdrawal, 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;
4. A cash flow schedule management device according to claim 1, wherein: The said project is a construction project,
10. A cash flow schedule management device according to claim 1, for use in the construction industry. 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: 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:

Images