JP2022117401A - Funding schedule management device, funding schedule management method and funding schedule management program - Google Patents

Abstract

To provide a funding schedule management device, a funding schedule management method and a funding schedule management program capable of grasping, for each funding stage and for each period of time, the amount of money to be deposited and the amount of money to be paid out.SOLUTION: The funding schedule management method includes: a step (1) of identifying, from a table detailing the work output objects, a matrix which matches a funding section, a money deposition/withdrawal section and a year/month in funding management information, in the table, and storing, in the identified matrix, the amount of money in the funding management information in the identified matrix, thereby, generating funding timetable information in units of a combination of a matter and a department; and a step (2) of outputting, based on the generated funding timetable information, a funding timetable, in units of the combination of the matter and the department, in which funding table, the amount of money is stored in the matrix identified by two axes consisting of one axis being a combination of the funding section and the money deposition/withdrawal section, and the other axis being year/month.SELECTED DRAWING: Figure 12

Description

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

Patent Document 1 discloses a fund management support device and a fund management support method for supporting fund management of multiple deposit accounts with different currencies, which is suitable for fund management such as analysis and forecasting of funds in a globally expanding corporate group. is disclosed (see paragraph 0007 of Patent Document 1, etc.).

Japanese Patent Application Laid-Open No. 2017-68401

Here, in the construction industry, etc., there are many hierarchical structures of multiple subcontractors, and it often takes time to receive payment. Since it is important to have ample cash in order to continue business, it is necessary to accurately and quickly grasp the cash flow schedule (when and how much to deposit, when and how much to withdraw, etc.) is important.

However, in the conventional technology including Patent Document 1, there are three stages of cash flow (planning stage when a contract has not yet been signed, planning stage when a contract is signed but deposits and withdrawals have not been completed, and deposits and withdrawals have been completed. In order to grasp the amount of deposits and withdrawals for each period (year and month), it was necessary to organize the information using Excel or the like. For this reason, there is a problem that the workload is very high and the cash flow cannot be grasped at an early stage.

SUMMARY OF THE INVENTION The present invention has been made in view of the above problems. An object of the present invention is to provide a method and a funding schedule management program.

In order to solve the above-described problems and achieve the object, a funding schedule management device according to the present invention is provided with a control unit and a storage unit, wherein the storage unit stores a case identification data, department identification data, a cash flow classification that identifies whether the cash flow is in the plan, schedule, or actual stage, and a classification that identifies receipts or withdrawals. Funds management information including a classification, an amount deposited or withdrawn, and a period to which the date on which the amount was cashed or cashed; Work output target details, which is a table with one axis on the other axis and the period on the other axis, are stored. The matter identified by the matter identification data and the department identification data are identified by specifying a matrix in the table that matches the entry/payment category and the period, and storing the amount in the identified matrix. schedule information generating means for generating project/department-based funding schedule information, which is funding schedule information for a combination of departments; A combination of the above-mentioned matter and the above-mentioned department, in which the above-mentioned amount is stored in a matrix specified by the above two axes, with the combination of the advance category and the above-mentioned deposit/withdrawal category as one axis and the above-mentioned period as the other axis. schedule output means for outputting a project/department-by-department cash flow schedule, which is a cash flow schedule of the above.

Further, in the financing schedule management apparatus according to the present invention, the schedule output means aggregates the amounts in the generated project/department-specific financing schedule for each department, and outputting a departmental cash flow schedule, which is a cash flow schedule for the company.

Further, in the cash flow schedule management device according to the present invention, the schedule output means aggregates the amounts in the generated cash flow schedule for each department, thereby producing a company-wide cash flow schedule. It is characterized by outputting a company-wide cash flow schedule.

Further, in the financing schedule management device according to the present invention, the storage unit stores project information including project identification data and department identification data, project identification data, and a deposit schedule including a scheduled deposit amount. and is further stored therein, and the control unit determines that, in the cash flow management information, the cash flow classification is a classification for identifying that the cash flow is in a planning stage, and the deposit/withdrawal When the classification is a classification for identifying deposits, the division identification data in the project information is changed to the cash flow management information based on the project information and the deposit schedule information having the same project identification data. A cash flow management generating means for generating the cash flow management information by setting it as the department identification data and setting the scheduled deposit amount in the cash deposit schedule information as the amount in the cash flow management information. characterized by

Further, in the financing schedule management device according to the present invention, the storage unit stores project information including project identification data and department identification data, project identification data and pre-billing amount including project identification data and pre-billing amount. information, sales information including item identification data and expected collection amount, and billing information including item identification data and billing amount, and the control unit controls the cash flow management. In the information, if the funding classification is a classification for identifying that the financing is in the planning stage and the deposit/withdrawal classification is a classification for identifying deposits, the project identification data is the same The department identification data in the project information is set as the department identification data in the cash flow management information based on the project information and any one of the previous billing information, the sales information, and the billing information. and setting the previous billed amount in the previous billing information, the expected collection amount in the sales information, or the billed amount in the billing information as the amount in the cash flow management information. It is characterized by further comprising cash flow management generation means for generating management information.

In the financing schedule management device according to the present invention, the storage unit stores project information including project identification data and department identification data, deposit information including project identification data, and a deposit amount. , is further stored, and the control unit, in the cash flow management information, the cash flow classification is a classification for identifying that the cash flow is in the actual stage, and the deposit/withdrawal classification is If the classification is for identifying a payment, the division identification data in the project information is changed to the division identification in the cash flow management information based on the project information and the payment information having the same project identification data. The method further comprises cash flow management generation means for generating the cash flow management information by setting the cash flow management information as data and setting the cash deposit amount in the cash deposit information as the cash amount in the cash cash management information. do.

Further, in the financing schedule management device according to the present invention, the storage unit stores project information including item identification data and department identification data, order information including item identification data and an order amount. , is further stored, and the control unit, in the cash flow management information, the cash flow classification is a classification for identifying that the cash flow is in the planning stage, and the deposit/withdrawal classification is If the classification is for identifying payment, the division identification data in the project information is changed to the division in the cash flow management information based on the project information and the order information having the same matter identification data. further comprising cash flow management generation means for generating the cash flow management information by setting the order amount in the order information as identification data and setting the order amount in the order information as the amount in the cash flow management information. and

Further, in the financing schedule management device according to the present invention, the storage unit stores project information including project identification data and department identification data, purchase information including project identification data, and purchase amount. is further stored, and the control unit is configured such that, in the cash flow management information, the cash flow classification is a classification for identifying that the cash flow is in a planned stage, and the deposit/withdrawal If the classification is for identifying payment, the division identification data in the project information is added to the cash flow management information based on the project information and the purchase information having the same item identification data. and setting the purchase amount in the purchase information as the amount in the cash flow management information to generate the cash flow management information. characterized by:

In the financing schedule management device according to the present invention, the storage unit stores project information including project identification data and department identification data, payment information including project identification data, and a payment amount. , is further stored, and the control unit, in the cash flow management information, the cash flow classification is a classification for identifying that the cash flow is in the actual stage, and the deposit/withdrawal classification is If the classification is for identifying withdrawals, the division identification data in the project information is changed to the division in the cash flow management information based on the project information and the payment information having the same matter identification data. characterized by further comprising cash flow management generation means for generating the cash flow management information by setting the payment amount in the payment information as identification data and setting the payment amount in the payment information as the amount in the cash flow management information. and

Further, in the financing schedule management device according to the present invention, the project is a construction project and is used in the construction industry.

Further, in the cash flow schedule management method according to the present invention, the cash flow schedule management method is executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores item identification data and department identification data. Data, cash flow classification for identifying whether the cash flow is in the planned, planned, or actual stage, deposit/withdrawal classification for identifying deposits or withdrawals, and deposit/withdrawal Funds management information including the amount of cash received or made and the period to which the date of cashing of the amount belongs, and the combination of the cash flow classification and the deposit/withdrawal classification as one axis, and the period as an axis Work output target details, which is a table serving as the other axis, are stored, and the cash flow classification in the cash flow management information, the cash flow management information, and the cash flow management information are stored from the work output target details, which are executed by the control unit. By specifying a matrix in the table that matches the money category and the period and storing the amount in the specified matrix, the project identified by the project identification data and the department identified by the department identification data a schedule information generating step of generating project/department-based funding schedule information, which is funding schedule information in combination units; and the combination of the deposit/withdrawal categories on one axis and the period on the other axis, and the amount of money stored in a matrix specified by these two axes, in units of combinations of the projects and departments. and a schedule output step of outputting the project/department cash flow schedule, which is a schedule.

Further, a funding schedule management program according to the present invention is a funding schedule management program to be executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores item identification data, department Identification data, cash flow categories for identifying whether the cash flow is in the planned, planned, or actual stages, deposit/withdrawal categories for identifying deposits or withdrawals, deposit/withdrawal Funds management information including the amount paid or paid and the period to which the date on which the amount was cashed or cashed, and the combination of the cash flow classification and the deposit/withdrawal classification as one axis, and the period are stored, and the work output target details, which is a table with the other axis as the other axis, are stored. The matter identified by the matter identification data and the department identification data are identified by specifying a matrix in the table that matches the entry/payment category and the period, and storing the amount in the identified matrix. a schedule information generation step of generating project/department-based funding schedule information, which is funding schedule information for a combination of departments; A combination of the above-mentioned matter and the above-mentioned department, in which the above-mentioned amount is stored in a matrix specified by the above two axes, with the combination of the advance category and the above-mentioned deposit/withdrawal category as one axis and the above-mentioned period as the other axis. and a schedule output step of outputting the project/department-by-department cash flow schedule, which is the cash flow schedule.

ADVANTAGE OF THE INVENTION According to this invention, it is effective in making it possible to grasp|ascertain the amount of deposit and the amount of withdrawal for every stage of cash flow and for every period.

FIG. 1 is a block diagram showing an example of the configuration of a funding schedule management device. FIG. 2 is a diagram showing an example of a system configuration according to this embodiment. FIG. 3 is a diagram showing an example of a method of calculating a billing destination master and a scheduled collection date. FIG. 4 is a diagram showing an example of a payee master. FIG. 5 is a diagram showing an example of a transaction method master. FIG. 6 is a diagram showing an example of an acquisition source of the amount in the cash flow management information. FIG. 7 is a diagram showing an example of project information registered on 2021/02. FIG. 8 is a diagram showing an example of deposit schedule information and cash flow management information registered on February 2021. FIG. 9 is a diagram showing an example of work construction-specific cash flow schedule information generated on 2021/02. FIG. 10 is a diagram showing an example of generation of work output target details. FIG. 11 is a diagram showing an example of construction-specific cash flow schedule information generated on February 2021. As shown in FIG. FIG. 12 is a diagram showing an example of a construction-by-construction cash flow schedule that is output on February 2021. As shown in FIG. FIG. 13 is a diagram showing an example of project information registered on 2021/03. FIG. 14 is a diagram showing an example of pre-billing information and cash flow management information registered on March 2021. FIG. FIG. 15 is a diagram showing an example of order information and cash flow management information registered on March 2021. FIG. 16 is a diagram showing an example of cash flow management information registered on March 2021. FIG. 17 is a diagram showing an example of work construction-specific funding schedule information and construction-specific funding schedule information generated on March 2021. FIG. FIG. 18 is a diagram showing an example of a construction-by-construction cash flow schedule that is output on March 2021. As shown in FIG. FIG. 19 is a diagram showing an example of project information registered on March 2021 that was handed over to April 2021. FIG. 20 is a diagram showing an example of sales information and cash flow management information registered on 2021/04. FIG. 21 is a diagram showing an example of deposit information and cash flow management information registered on April 2021. FIG. 22 is a diagram showing an example of cash flow management information registered in the middle of 2021/04. FIG. 23 is a diagram showing an example of work construction cash flow schedule information generated in the middle of 2021/04. FIG. 24 is a diagram showing an example of work-specific cash flow schedule information generated in the middle of 2021/04. FIG. 25 is a diagram showing an example of a construction-by-construction cash flow schedule that is output midway through April 2021. As shown in FIG. FIG. 26 is a diagram showing an example of purchase information and cash flow management information registered on 2021/04. FIG. 27 is a diagram showing an example of cash flow management information registered on 2021/04. FIG. 28 is a diagram showing an example of work construction-specific funding schedule information generated on 2021/04. FIG. 29 is a diagram showing an example of work-specific cash flow schedule information generated on 2021/04. FIG. 30 is a diagram showing an example of a construction-specific cash flow schedule that is output on April 2021. FIG. 31 is a diagram showing an example of payment information and cash flow management information registered on May 2021. FIG. 32 is a diagram showing an example of cash flow management information registered on 2021/05. FIG. 33 is a diagram showing an example of work construction-specific funding schedule information generated on 2021/05. FIG. 34 is a diagram showing an example of construction-specific cash flow schedule information generated on May 2021. As shown in FIG. FIG. 35 is a diagram showing an example of a construction-specific cash flow schedule that is output on May 2021. FIG. FIG. 36 is a diagram showing an example of a cash flow schedule by department. FIG. 37 is a diagram showing an example of a company-wide funding schedule.

EMBODIMENT OF THE INVENTION Below, embodiment of the cash flow schedule management apparatus, the cash flow schedule management method, and the cash flow schedule management program which concern on this invention is described in detail based on drawing. It should be noted that the present invention is not limited by this embodiment.

[1. Background/issues and overview]
In this section, the background, problems, and outline of the present invention will be explained.

[1-1. Background and problems of the present invention]
The construction industry has a layered structure of multiple subcontractors, and when construction takes a long time, payments are made to the subcontractor, but the payment tends to be delayed. Payment deadlines are stipulated by the Construction Business Act and the Subcontract Act, etc., so in order to continue business, it is necessary to forecast cash flow and hold ample cash.

In addition, in many cases, the cash flow schedule is managed in Excel after the accounting and finance department issues the invoice, and the payment schedule is managed after receiving the invoice from the subcontractor, but the construction period is long. Construction projects with a large amount of money have a large impact on a company's cash flow. Therefore, it is desirable to manage the funding schedule including the construction schedule at the contract stage, ideally at the inquiry stage.

In addition, sales staff and construction staff are aware of the profit for each project, but are often not aware of the deposit/withdrawal schedule. Therefore, in order to fundamentally improve the problem of cash flow as a company, it is necessary to make not only the entire company and accounting, but also department managers and construction managers aware of the schedule of deposits and withdrawals.

Furthermore, in terms of supporting business continuity during the COVID-19 pandemic, it is expected that the usefulness of not only profit management but also cash management will increase further.

In short, it is necessary to collect a wide range of information for the cash flow schedule, but in the past, the cash flow schedule was managed manually using Excel, etc., so there was a problem that the creation load was high (problem of work load). . In addition, in the past, the cash flow schedule was recognized at the timing of billing and payment, but there was a problem that information could not be gathered from the front line to the accounting at the time of receiving or placing an order for a project, making it impossible to confirm the cash flow schedule at an early stage. There was (problem of understanding timing).

[1-2. Outline of the present invention]
Therefore, in the present embodiment, for example, by linking business progress and cash flow and managing the status, planning accuracy is improved as the process progresses, and the cash flow schedule can be managed more accurately and earlier. made it possible.

In addition, in this embodiment, for example, the schedule information and performance information in cash management are collected from each business, and the results are collected for each construction unit (from the viewpoint of the site manager), each department (from the viewpoint of the department manager), and each company (from the manager's viewpoint). In this way, persons in charge with different positions can check information at any time as of the specified date.

Further, in the present embodiment, for example, the scheduled deposit date and the scheduled payment date can be calculated as follows for information in which deposits and withdrawals are undetermined at the inquiry stage or the contract stage. The scheduled payment date can be calculated by referring to the agreement in the billing destination master from the scheduled sales date in the contract information. The scheduled payment date can be calculated by referring to the agreement of the supplier master from the scheduled completion date of the order schedule in the budget information. If the denomination is a bill, the scheduled payment date and the scheduled payment date can be adjusted in consideration of the settlement date.

Furthermore, in this embodiment, for example, on the construction management system, although the management of deposits and withdrawals linked to construction projects is the main subject, additional information such as SG&A expenses, non-operating profit and loss, and extraordinary profit and loss are also registered as credits and debts. If so, it becomes possible to manage the cash flow schedule precisely for the company as a whole. Specific configurations and operations will be described below.

[2. Constitution]
An example of the configuration of the cash flow schedule management device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the cash flow schedule management device 100. As shown in FIG.

The cash flow schedule management device 100 is a commercially available desktop personal computer. Note that 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 commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, a tablet personal computer, or the like. It may be a portable information processing device.

The cash flow schedule management device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in the cash flow schedule management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the cash flow schedule management apparatus 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the cash flow schedule management apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later 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 section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 stores, for example, project information 106a, payment schedule information 106b, previous 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, payee master 106k, transaction method master 106m, funding management information 106n, funding schedule information by work construction 106p, work output target details 106q, by construction and cash flow schedule information 106r.

Here, the project information 106a to payment information 106i are information that is registered daily as the work progresses, and will be described in item [2-1] below. The billing destination master 106j to the transaction method master 106m are master information set by the operator in advance, and will be described in item [2-2] below. The cash flow management information 106n to the work cash flow schedule information 106r are characteristic information of the present invention and are generated through processing, and will be described in [2-3] below.

[2-1. project information 106a to payment information 106i]
The project information 106a includes, for example, a project number, a project name, a department, a billing party, a contract status, an inquiry date, an order receipt date, and the like. A project number is a number that uniquely indicates a project. A department is a department that manages a project. A billing party is a business partner from whom money is collected. The contract status is status information representing the progress of the project, and there are three statuses of inquiry, acceptance, and lost order. The order date is the date when the first order is recorded.

The payment schedule information 106b includes, for example, a payment schedule number, a project number, a billing destination, a transaction method, a scheduled payment amount (amount), a scheduled billing date, a scheduled collection date, a CASHIN/OUT date, and the like. including. The deposit schedule number is a slip number that uniquely indicates the deposit schedule information. The transaction method is the method of collecting the amount. The amount is the collected amount. The scheduled billing date is the target date used for calculating the scheduled collection date. The scheduled collection date is the scheduled collection date of the amount. The CASHIN/OUT date is the date of cashing.

The pre-billing information 106c includes, for example, a pre-billing number, a project number, a billing destination, a transaction method, a pre-billing amount (amount), a pre-billing date, a scheduled collection date, a CASHIN/OUT date, and the like. including. The pre-billing number is a slip number that uniquely indicates pre-billing information. The previous billing date is the date on which the previous billing registration was performed, and is also the target date used to calculate the scheduled collection date.

The sales information 106d includes, for example, a sales number, a project number, a billing destination, a transaction method, a sales amount, a scheduled collection amount, a sales date, a scheduled collection date, a CASHIN/OUT date, and the like. . The sales number is a slip number that uniquely indicates sales information. The sales date is the date on which the sales registration is performed, and is also the target date used to calculate the scheduled collection date. Regarding the expected collection amount, if the pre-billing is made 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 billed amount is set in the sales information 106d.

The billing information 106e includes, for example, a billing number, a project number, a billing destination, a transaction method, a billing amount (amount), a billing date, a scheduled collection date, a CASHIN/OUT date, and the like. The billing number is a slip number that uniquely indicates billing information. The billing date is the date when the billing registration is performed, and is also the target date used for calculating the scheduled collection date.

The deposit information 106f includes, for example, a deposit number, a project number, a billing party, a transaction method, a deposit amount (amount), a scheduled collection date, a deposit date, a CASHIN/OUT date, and the like. The receipt number is a slip number that uniquely indicates the receipt information. The payment date is the date when the payment is registered (the date on which the payment record is reflected).

The order information 106g includes, for example, an order number, a project number, a payee, a transaction method, an order amount (amount), an order date, a scheduled purchase date, a scheduled payment date, and a CASHIN/OUT date. , etc. The order number is a slip number that uniquely indicates order information. A payee is a business partner to whom money is paid. The order date is the date on which order registration is performed. The scheduled purchase date is a target date used for calculating the scheduled payment date. The scheduled payment date is the scheduled payment date of the amount. The CASHIN/OUT date is the date for withdrawing cash.

The purchase information 106h includes, for example, a purchase number, a project number, a payee, a transaction method, a purchase amount (amount), a purchase date, a scheduled payment date, a CASHIN/OUT date, and the like. including. The purchase number is a slip number that uniquely indicates purchase information. The purchase date is the date on which purchase registration is performed, and is also the target date used to calculate the scheduled payment date.

The payment information 106i includes, for example, payment number, project number, payee, transaction method, payment amount (amount), scheduled payment date, payment date, CASHIN/OUT date, and the like. The payment number is a slip number that uniquely indicates payment information. A payee is a business partner to whom money is paid. The payment date is the date on which the payment registration was performed (the date on which the payment results are reflected).

Here, properties of the deposit schedule information 106b to payment information 106i and the relationship between these information and the cash management information 106n will be described with reference to FIGS. 2 and 6. FIG.

The deposit schedule information 106b is information generated at the deposit planning stage, as shown in FIG. As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "0: plan" and the deposit/withdrawal classification is "0: deposit", the amount in the deposit schedule information 106b is It is set as the amount in the cash flow management information 106n.

The pre-billing information 106c, the sales information 106d, and the billing information 106e are information generated at the payment planning stage, as shown in FIG. As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "1: scheduled" and the deposit/withdrawal classification is "0: deposit", the previous billing information 106c, sales information 106d and The amount in the billing information 106e is set as the amount in the cash management information 106n.

The deposit information 106f, as shown in FIG. 2, is information generated at the actual stage of deposit (=after completion of deposit). As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "2: actual" and the deposit/withdrawal classification is "0: deposit", the amount in the deposit information 106f is It is set as the amount of money in the forwarding management information 106n.

The order information 106g, as shown in FIG. 2, is information generated in the withdrawal (payment) planning stage. As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "0: plan" and the deposit/withdrawal classification is "1: withdrawal (payment)", the order information 106g The amount is set as the amount in the cash flow management information 106n.

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

The payment information 106i, as shown in FIG. 2, is information generated at the actual stage of withdrawal (payment) (=after payment (payment) is completed). As shown in FIG. 6, in the cash flow management information 106n, when the cash flow classification is "2: Actual" and the deposit/withdrawal classification is "1: Withdrawal (payment)", the payment information 106i The amount is set as the amount in the cash flow management information 106n.

[2-2. Billing destination master 106j to transaction method master 106m]
The billing destination master 106j includes, for example, a billing destination code, a billing destination name, a closing date, a collection month, a collection date, and the like, as shown in FIG. The billing party code and billing party name indicate the business partner from whom the money is to be collected. The closing date, collection month, and collection date are information used to calculate the scheduled collection date.

Here, a method for calculating the scheduled collection date will be described using the table shown in FIG.
・The year and month subject to calculation in (2) are the years and months to which the date subject to calculation in (1) belongs.
The closing period of (3) is calculated by setting the calculation target year and month of (2) and the closing date in the billing destination master 106j.
・The year and month subject to calculation in (4) are subject to the following conditions: (I) Start date of the closing period in (3) ≤ Date of calculation in (1) ≤ End date of the closing period in (3) , (2), and if (II) the condition is not satisfied, the calculation target year and month of (2) + 1 month.
- The scheduled collection month in (5) is calculated by the calculation target year and month in (4) + 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.

The payee master 106k includes, for example, payee code, payee name, closing date, payment month, payment date, etc., as shown in FIG. Since the scheduled payment date can be calculated by replacing the terms in the method of calculating the scheduled collection date described in the previous paragraph with the following, detailed description is omitted.
・Billing destination master 106j→Payment destination master 106k
・Collection month in the billing destination master 106j→Payment month in the payment destination master 106k・Scheduled collection month→Scheduled payment month・Scheduled collection date→Scheduled payment date

The transaction method master 106m includes, for example, a transaction method code, a transaction method name, a transaction category, a bill site, and the like, as shown in FIG. The transaction method code and transaction method name are the method of collecting money and the method of payment. The transaction category is the type of transaction. The bill site is a bill site set when the transaction classification is 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 will be "target date 2021/12/01 + transaction method 90 days at the bill site in the master 106m can be calculated as 20201/03/01.

Collection methods and payment methods can be set proportionally by denomination (transaction classification) on the transaction method master 106m, and by further breaking down each schedule and performance information by denomination, it can also be developed into a cash flow schedule by denomination. It is possible. By decomposing by denomination, it is possible to predict the CASHIN/OUT date of cash and deposits considering the due date of bills. The CASHIN/OUT date can be calculated based on the bill site set on the transaction method master 106m.

[2-3. Cash flow management information 106n to construction-specific cash flow schedule information 106r]
The cash flow management information 106n includes, for example, item identification data (project number), department identification data (department code), supplier identification data (customer code), and cash flow planning data, as shown in FIG. , cash flow classification, which is a classification for identifying whether it is in the stage of schedule or actual, deposit / withdrawal classification, which is a classification for identifying deposit or withdrawal, transaction classification, slip number, deposit / withdrawal The amount (amount) paid or paid, the date of posting, the month and year of posting, the date on which the said amount was cashed or cashed (CASHIN/OUT date), and the period to which the date belongs (CASHIN/OUT date) and, etc.

The project number indicates the project number of a financial management target (for example, a construction project). The department code is the code of the department that manages the project. The business partner code is the code of the business partner to whom money is to be collected or paid. The funding classification is a classification indicating the status of the financing information, and there are three classifications of "0: plan", "1: plan" and "2: actual". As the deposit/withdrawal category, "0: Deposit" is a category that means income, "1: Withdrawal (payment)" is a category that means expenditure, and "(Payment)" is a category that means income minus expenditure 9: There are three categories of income and expenditure. A transaction category is a category that indicates the type of money collection and payment method. The slip number is the slip number that is the origin of the cash flow management information. The amount is the collected amount or the paid amount. The recording date is the date on which cash receipts and withdrawals are recognized or made as actual. The recording date is the year and month to which the recording date belongs. The CASHIN/OUT date is the date the money is cashed or made. The CASHIN/OUT year/month is the year/month to which the CASHIN/OUT date belongs.

The cash flow schedule information by work construction 106p is information obtained by aggregating amounts between records in the cash flow management information 106n that have the same combination of project number, customer code, cash flow classification, deposit/withdrawal classification, and CASHIN/OUT year/month. is. The cash flow schedule information 106p for each work construction includes, as shown in FIG. , the amount after aggregation (amount), and the like.

As shown in FIG. 10 and the like, the work output target specification 106q is a table having a combination of cash flow category and deposit/withdrawal category as one axis and a period as the other axis.

The construction-by-construction financing schedule information 106r is information used to output the construction-by-construction financing schedule. Details of the construction-by-construction funding schedule information 106r are described in [3. specific example of processing], it is generated by storing the amounts (amounts) after aggregation in the work construction-by-work financing schedule information 106p in a matrix in the work output target details 106q. The construction-by-work financing schedule information 106r includes, as shown in FIG. 11 and the like, for example, a project number, a client code, a financing classification, a deposit/withdrawal classification, an amount for each target year and month, and the like.

The control unit 102 is a CPU or the like that comprehensively controls the cash flow schedule management device 100 . The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally and conceptually includes, for example, (1) a cash flow management generation unit 102a as a cash flow management generating means; , identifying a matrix in the table that matches the deposit/withdrawal category and the period, and storing the amount in the identified matrix, thereby identifying the matter identified by the matter identification data and the department identification data (3) a schedule information generating unit 102b as schedule information generating means for generating project/department-based funding schedule information, which is funding schedule information for a combination of departments; Based on the cash flow schedule information by department, the combination of the cash flow classification and the deposit/withdrawal classification is used as one axis, and the period is used as the other axis, and the amount is specified in a matrix specified by these two axes. and a schedule output unit 102c as a schedule output means for outputting a stored cash flow schedule by project/department, which is a stored cash flow schedule for a combination of the projects and the departments.

The cash flow management generation unit 102a generates the cash flow classification (three patterns of "0: plan", "1: plan", or "2: actual") and the deposit/withdrawal classification ("0: deposit") in the cash flow management information 106n. or 2 patterns of "1: Withdrawal"). The generation of the cash flow management information 106n will be described below for each of 6 patterns (3 patterns of cash flow divisions×2 patterns of deposit/withdrawal divisions).

In the cash flow management information 106n, when the cash flow classification is "0: plan" and the deposit/withdrawal classification is "0: deposit", the cash flow management generation unit 102a generates project information with the same project number. 106a and payment schedule information 106b, the department code in the project information 106a is set as the department code in the cash flow management information 106n, and the scheduled payment amount in the payment schedule information 106b is set as the amount in the cash flow management information 106n. By setting, the cash flow management information 106n is generated (see FIGS. 7 and 8).

In the cash flow management information 106n, when the cash flow classification is "1: scheduled" and the deposit/withdrawal classification is "0: deposit", the cash flow management generation unit 102a generates project information with the same project number. 106a and one of the previous billing information 106c, the sales information 106d and the billing information 106e, the department code in the project information 106a is set as the department code in the cash flow management information 106n, and the department code in the previous billing information 106c is set. The cash flow management information 106n is generated by setting the previous billed amount, the scheduled collection amount in the sales information 106d, or the billed amount in the billing information 106e as the amount in the cash flow management information 106n (see FIGS. 13 and 14). ).

In the cash flow management information 106n, when the cash flow classification is "2: actual" and the deposit/withdrawal classification is "0: deposit", the cash flow management generation unit 102a generates project information with the same project number. 106a and deposit information 106f, the department code in the project information 106a is set as the department code in the cash flow management information 106n, and the deposit amount in the deposit information 106f is set as the amount in the cash flow management information 106n. to generate cash flow management information 106n (see FIGS. 19 and 21).

In the cash flow management information 106n, when the cash flow classification is "0: plan" and the deposit/withdrawal classification is "1: withdrawal", the cash flow management generation unit 102a Based on the information 106a and the order information 106g, the department code in the project information 106a is set as the department code in the cash flow management information 106n, and the order amount in the order information 106g is set as the amount in the cash flow management information 106n. As a result, cash flow management information 106n is generated (see FIGS. 13 and 15).

In the cash flow management information 106n, when the cash flow classification is "1: scheduled" and the deposit/withdrawal classification is "1: withdrawal", the cash flow management generation unit 102a Based on the information 106a and the purchase information 106h, the department code in the project information 106a is set as the department code in the cash flow management information 106n, and the purchase amount in the purchase information 106h is set as the amount in the cash flow management information 106n. , the cash flow management information 106n is generated (see FIGS. 19 and 26).

In the cash flow management information 106n, when the cash flow classification is "2: Actual" and the deposit/withdrawal classification is "1: Withdrawal", the cash flow management generation unit 102a generates projects with the same project number. Based on the information 106a and the payment information 106i, the department code in the project information 106a is set as the department code in the cash flow management information 106n, and the payment amount in the payment information 106i is set as the amount in the cash flow management information 106n. As a result, cash flow management information 106n is generated (see FIGS. 19 and 31).

The schedule information generation unit 102b identifies, from the work output target details 106q, a matrix in the table of the work output target details 106q that matches the cash flow classification, deposit/withdrawal classification, and period in the cash flow management information 106n, By storing the amounts in the cash flow management information 106n in the matrix, project/department unit cash flow schedule information (construction-specific cash flow schedule information 106r ) (see FIGS. 11, 17, 24, 29 and 34).

The schedule output unit 102c uses the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis based on the generated project/department-based cash flow schedule information (construction-specific cash flow schedule). A project/department-specific funding schedule (construction-specific funding schedule), which is a funding schedule for a combination of projects and departments, in which amounts are stored in the matrix specified by these two axes. (See FIGS. 12, 18, 25, 30 and 35).

The schedule output unit 102c aggregates the amounts in the generated project/department-specific funding schedule (construction-specific funding schedule) for each department, thereby producing a division-by-department funding schedule for each department. Output the cash flow schedule (see FIG. 36).

The schedule output unit 102c outputs a company-wide funding schedule, which is a company-wide funding schedule, by aggregating the amounts in the generated departmental funding schedule (see FIG. 37).

[3. Specific example of processing]
In this section, a specific example of processing according to this embodiment will be described. Below, the generation of the cash flow schedule by construction is explained in [3-1] to [3-4] by processing date (2021/02-2021/06), and the generation of the cash flow schedule by department is described in [3 -5], and generation of the company-wide funding schedule will be described in [3-6].

[3-1. Creation of cash flow schedule by construction work for February 2021]
First, the generation of the construction-specific cash flow schedule when the year and month being processed by the system = 2021/02 will be described using FIGS. 7 to 12. FIG.

(1) Generation of Project Information 106a First, as shown in FIG. 7, project information 106a is generated for each contract with a business partner for the purpose of using it as a construction management unit. In the project information 106a, billing destination and contract status are entered. In the example of the project information 106a in FIG. 7, "10: Inquiry" is registered as the contract status, and in this case, the date of inquiry is entered.

(2) Generation of Payment Schedule Information 106b Next, as shown in FIG. 8, payment schedule information 106b is registered for the project. In the payment schedule information 106b, the transaction method, amount, and scheduled billing date are registered. In the payment schedule information 106b, the scheduled collection date and the CASHIN/OUT date are calculated with reference to the billing destination master 106j, using the scheduled billing date as the date to be calculated.

(3) Generation of cash flow management information 106n and work construction work cash flow schedule information 106p Next, as shown in FIG. Generate management information 106n. Here, since the contract status "10: Inquiry" in the project information 106a in FIG. 7 corresponds to the "planning stage" in the cash flow management, as shown in the cash flow management information 106n in FIG. : plan”. The fact that the deposit schedule information 106b has been registered means that the "deposit" in the cash flow management will be performed in the future, so the deposit/withdrawal classification is "0: deposit" as shown in the cash flow management information 106n in FIG. be registered.

As shown in the cash flow management information 106n in FIG. 8, when the cash flow classification is "0: plan" and the deposit/withdrawal classification is "0: deposit", the cash flow management generation unit 102a 6, the amount in the deposit schedule information 106b is set as the amount in the cash flow management information 106n. Specifically, the cash flow management generating unit 102a aggregates the amounts in the deposit schedule information 106b in units of records with the same combination of deposit schedule number, transaction method, scheduled collection date, and CASHIN/OUT date. It is set as the amount of money in the forwarding management information 106n.

Further, the cash flow management generation unit 102a sets the department "A department" in the project information 106a of FIG. 7 as the department in the cash flow management information 106n of FIG.

Next, as shown in FIG. 9, the amounts in the generated cash flow management information 106n are aggregated by project number, business partner code, cash flow classification, deposit/withdrawal classification, and CASHIN/OUT year/month. Work construction cash flow schedule information 106p is generated. The generated work construction-specific financing schedule information 106p is one of the two pieces of information from which the construction-specific financing schedule information 106r is generated.

(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 from which the construction-by-construction cash flow schedule information 106r is generated, will be described. The work output target specification 106q shown in FIG. 10 is generated based on the output target specification information (vertical axis) shown in FIG. 10 and the output target year/month information (horizontal axis) shown in FIG. Note that the target year and month in the output target year and month information (horizontal) is generated from the extraction conditions specified at the time of outputting the project-specific cash flow schedule. For example, if the base year and month specified as an extraction condition is 2021/02, the base year and month minus January (before 2021/01), the specified base year and month (2021/02), the base year and month + 1 month ( 2021/03), base date + February (2021/04), base date + March (2021/05), base date + April (2021/06), base date + May (2021/07) and base The year and month + after June (after 2021/08) will be the target year and month.

(5) Generation of work-specific funding schedule information 106r and output of work-specific funding schedule Next, the generated work work-based funding schedule information 106p in FIG. 11. By developing the work output target details 106q in FIG. 10 in units of work classification, deposit/withdrawal classification, and target year/month, the construction-by-construction cash flow schedule information 106r of FIG. 11 is generated.

Specifically, the schedule information generation unit 102b creates a record having the same classification as the cash flow classification "0: Plan" and the deposit/withdrawal classification "0: Deposit" in the work work cash flow schedule information 106p of FIG. , the record on the first line in the work output target specification 106q in FIG. 10 is specified. Then, the schedule information generation unit 102b stores the amount 1,100,000 for April 2021 in the cash flow schedule information by work construction 106p of FIG. , the amount 3,300,000 for May 2021 in the cash flow schedule information by work construction 106p of FIG. 9 is stored in the column of May 2021 in the identified first row record, In the column after August 2021, the amount 2,200,000 after August 2021 in the cash flow schedule information 106p for each work construction in FIG. 9 is stored. At the same time, the schedule information generation unit 102b adds the project number and supplier code in the work construction-by-work financing schedule information 106p in FIG. 9 to the leftmost column of the work output target details 106q in FIG. FIG. 11 shows the construction-specific cash flow schedule information 106r generated in this way.

Finally, the schedule output unit 102c generates the construction-specific funding schedule (reference date=2021/02) shown in FIG. to output The construction-by-construction financing schedule shown in FIG. 12 is a financing schedule for the A department for the construction identified by the project number PJ200001.

[3-2. Generation of cash flow schedule by construction work for 2021/03]
Next, the generation of the construction-specific cash flow schedule when the year and month being processed by the system = 2021/03 will be described using FIGS. 13 to 18. FIG.

(1) Generation of Project Information 106a When a registered project receives an order, the project information 106a is updated as shown in FIG. Specifically, in the generated project information 106a of FIG. 7, the contract status is changed from "10: Inquiry" to "20: Received", and "2021/03/01" is registered as the order date. .

(2) Generation of Pre-billing Information 106c Next, as shown in FIG. 14, pre-billing information 106c is registered for the project. In the pre-billing information 106c, the transaction method, amount, and pre-billing date are registered. In the previous billing information 106c, the scheduled collection date and the CASHIN/OUT date are calculated with reference to the billing destination master 106j, using the previous billing date as the calculation target date.

(3) Generation of cash flow management information 106n based on previous billing information 106c Next, as shown in FIG. Generate. Here, since the contract status "20: order received" in the project information 106a of FIG. 13 corresponds to the "scheduled stage" in the cash flow management, as shown in the cash flow management information 106n in FIG. : scheduled”. Further, the fact that the previous billing information 106c has been registered means that the "deposit" in the cash flow management will be performed in the future. be registered.

As shown in the cash flow management information 106n in FIG. 14, when the cash flow classification is "1: scheduled" and the deposit/withdrawal classification is "0: deposit", the cash flow management generation unit 102a 6, the amount in the previous billing information 106c is set as the amount in the cash flow management information 106n. Specifically, the cash flow management generation unit 102a converts the amount in the previous billing information 106c into a previous billing number, a project number, a billing party (business partner), a transaction classification, a scheduled collection date (accounting date), and a CASHIN/OUT The sum totaled for each record with the same combination of dates is set as the sum in the cash flow management information 106n.

Further, the cash flow management generation unit 102a sets the department "A department" in the project information 106a of FIG. 13 as the department in the cash flow management information 106n of FIG.

(4) Generation of Order Information 106g Next, as shown in FIG. 15, order information 106g is registered for the project. That is, an order is placed with a subcontractor. In the order information 106g, the payee, transaction method, amount, order date, and scheduled purchase date are registered. In the order information 106g, the scheduled payment date and the CASHIN/OUT date are calculated by referring to the payee master 106k with the scheduled purchase date as the date to be calculated.

(5) Generation of Cash Flow Management Information 106n Based on Order Information 106g Next, as shown in FIG. 15, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and the order information 106g. . Here, since the order information 106g is information in the planning stage as shown in FIG. 2, as shown in the cash flow management information 106n in FIG. 15, the cash flow classification is registered as "0: plan". Further, the fact that the order information 106g has been registered means that "withdrawal" in the cash flow management will be performed in the future, so as shown in the cash flow management information 106n in FIG. registered with.

As shown in the cash flow management information 106n in FIG. 15, when the cash flow classification is "0: plan" and the deposit/withdrawal classification 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 described with reference to FIG. Specifically, the amounts in the order information 106g were aggregated in record units with the same combination of order number, project number, payee (business partner), transaction classification, scheduled payment date (accounting date), and CASHIN/OUT date. The amount is set as the amount in the cash flow management information 106n.

Further, the cash flow management generation unit 102a sets the department "A department" in the project information 106a of FIG. 13 as the department in the cash flow management information 106n of FIG.

(6) Updating the cash flow management information 106n and the work work-specific cash flow schedule information 106p , 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] is added, the cash flow management information 106n is updated as shown in FIG.

Next, as shown in FIG. 17, the amounts in the generated cash flow management information 106n are aggregated by project number, business partner code, cash flow category, deposit/withdrawal category, and CASHIN/OUT year/month. Work construction cash flow schedule information 106p is generated. As described above, the generated work construction-specific cash flow schedule information 106p is one of the two pieces of information from which the construction work-class cash flow schedule information 106r is generated.

The method of generating the work output target details 106q, which is the other of the two pieces of information from which the construction-by-construction cash flow schedule information 106r is generated, is the same as (4) of [3-1]. Description is omitted. The generated work output target specification 106q is as shown in FIG.

(7) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Generate cash flow schedule information 106r. In the generated construction-by-work financing schedule information 106r shown in FIG. 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 generates the construction-specific funding schedule (reference date=2021/03) shown in FIG. to output The construction-by-work financing schedule shown in FIG. 18 is the A department's financing schedule for the construction identified by the project number PJ200001.

[3-3. Generation of cash flow schedule by construction work for 2021/04]
Next, the generation of the cash flow schedule for each construction work when the year and month being processed by the system = 2021/04 will be described using FIGS. 19 to 30. FIG.

(1) Generation of project information 106a
It is assumed that there is no change in the project as of 2021/04, and in this case, the project information 106a has the same contents as the project information 106a of 2021/03 shown in FIG. 13, as shown in FIG.

(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 date of sale are registered. In the sales information 106g, the scheduled collection date and the CASHIN/OUT date are calculated with reference to the billing destination master 106j with the sales date as the calculation target date. The expected collection amount is calculated in the sales information 106g.

(3) Generation of Cash Flow Management Information 106n Based on Sales Information 106g Next, as shown in FIG. 20, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and the sales information 106g. . Here, since the contract status "20: order received" in the project information 106a of FIG. 19 corresponds to the "scheduled stage" in the cash flow management, as shown in the cash flow management information 106n in FIG. : scheduled”. Further, the fact that the sales information 106g has been registered means that "deposit" in the cash flow management will be performed in the future, so as shown in the cash flow management information 106n in FIG. be done.

As shown in the cash flow management information 106n in FIG. 20, when the cash flow classification is "1: scheduled" and the deposit/withdrawal classification is "0: deposit", the cash flow management generation unit 102a 6, the expected collection amount in the sales information 106g is set as the amount in the cash flow management information 106n. Specifically, the cash flow management generation unit 102a converts the expected collection amount in the sales information 106g into The sum totaled in the same record unit is set as the sum in the cash flow management information 106n.

(4) Generation of Payment Information 106f Next, as shown in FIG. 21, payment information 106f is registered for the project. In the deposit information 106f, transaction method, amount and date of deposit are registered. In the deposit information 106f, the deposit date is reflected as the CASHIN/OUT date.

(5) Generating Funds Management Information 106n Based on Deposit Information 106f Next, the funds management generation unit 102a generates funds management information 106n from the project information 106a and the deposit information 106f, as shown in FIG. . Here, since the deposit information 106f is information at the actual stage that the deposit has actually been made, as shown in the cash flow management information 106n in FIG. 21, the cash flow classification is registered as "2: performance". Further, the fact that the deposit information 106f is registered means that the "deposit" in the cash flow management has been performed. Therefore, as shown in the cash flow management information 106n in FIG. registered as a deposit.

As shown in the cash flow management information 106n in FIG. 21, when the cash flow classification is "2: Actual" and the deposit/withdrawal classification is "0: Deposit", the cash flow management generation unit 102a 6, the amount in the deposit information 106f is set as the amount in the cash flow management information 106n. Specifically, the cash management generation unit 102a converts the amount in the deposit information 106f into a record with the same combination of deposit number, project number, billing party (business partner), transaction classification, scheduled collection date, and CASHIN/OUT date. The sum totaled in units is set as the amount in the cash flow management information 106n.

(6) Updating the cash flow management information 106n and the work work-specific cash flow schedule information 106p , 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] is added, the cash flow management information 106n is updated as shown in FIG.

Next, as shown in FIG. 23, the amounts in the generated cash flow management information 106n are aggregated by project number, business partner code, cash flow category, deposit/withdrawal category, and CASHIN/OUT year/month. Work construction cash flow schedule information 106p is generated. As described above, the generated work construction-specific cash flow schedule information 106p is one of the two pieces of information from which the construction work-class cash flow schedule information 106r is generated.

The method of generating the work output target details 106q, which is the other of the two pieces of information from which the construction-by-construction cash flow schedule information 106r is generated, is the same as (4) of [3-1]. Description is omitted. The generated work output target specification 106q is as shown in FIG.

(7) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Generate cash flow schedule information 106r. In the generated construction-by-work financing 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 generates the construction-specific cash flow schedule shown in FIG. to output The construction-by-work financing schedule shown in FIG. 25 is a financing schedule for the A department for the construction specified by the project number PJ200001.

(8) Registration of Purchase Information 106h Next, as shown in FIG. 26, purchase information 106h is registered for the project. Transaction method, amount and date of purchase are registered in the purchase information 106h. In the purchase information 106h, the scheduled payment date and the CASHIN/OUT date are calculated by referring to the payee master 106k with the purchase date as the calculation target date.

(9) Generation of cash flow management information 106n based on purchase information 106h Next, as shown in FIG. Generate. Here, since the purchase information 106h is information at the scheduled stage as shown in FIG. 2, as shown in the cash flow management information 106n in FIG. 26, the cash flow classification is registered as "1: scheduled". In addition, the fact that the purchase information 106h has been registered means that "withdrawal" in cash flow management will be performed in the future. ” is registered.

As shown in the cash flow management information 106n in FIG. 26, when the cash flow classification is "1: scheduled" and the deposit/withdrawal classification is "1: withdrawal (payment)", the cash flow management generation unit 102a sets the amount in the purchase information 106h as the amount in the cash flow management information 106n, as described with reference to FIG. Specifically, the cash flow management generator 102a converts the amount in the purchase information 106h into a purchase number, a project number, a payee (business partner), a transaction classification, a scheduled payment date (accounting date), and a CASHIN/OUT The sum totaled for each record with the same combination of dates is set as the sum in the cash flow management information 106n.

(10) Updating the cash flow management information 106n and the work construction cash flow schedule information 106p Next, the cash flow management generation unit 102a generates the cash flow management information shown in FIG. 22 generated in this item [3-3]. 26 generated in (9) of this item [3-3] is added to 106n, the cash management information 106n is updated as shown in FIG.

Next, as shown in FIG. 28, the amounts in the generated cash flow management information 106n are aggregated by project number, business partner code, cash flow category, deposit/withdrawal category, and CASHIN/OUT year/month. Work construction cash flow schedule information 106p is generated. As described above, the generated work construction-specific cash flow schedule information 106p is one of the two pieces of information from which the construction work-class cash flow schedule information 106r is generated.

The method of generating the work output target details 106q, which is the other of the two pieces of information from which the construction-by-construction cash flow schedule information 106r is generated, is the same as (4) of [3-1]. Description is omitted. The generated work output target specification 106q is as shown in FIG.

(11) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Generate cash flow schedule information 106r. In the generated construction-by-work financing schedule information 106r shown in FIG. 29, the amount (550,000 yen) in one matrix indicated by hatching is the newly added amount.

Finally, the schedule output unit 102c generates the construction-specific funding schedule (reference date=2021/04) shown in FIG. to output The construction-by-construction financing schedule shown in FIG. 30 is the division A's financing schedule for the construction identified by the project number PJ200001.

[3-4. Creation of cash flow schedule by construction work for 2021/05]
Next, the generation of the cash flow schedule for each construction work when the year and month being processed by the system = 2021/05 will be described with reference to Figs.

(1) Generation of Payment Information 106i First, as shown in FIG. 31, payment information 106i is registered for a project. In the payment information 106i, the payee, transaction method, amount and date of payment are registered. The payment date is reflected as the CASHIN/OUT date in the payment information 106i.

(2) Generation of Cash Flow Management Information 106n Based on Payment Information 106i Next, as shown in FIG. 31, the cash flow management generation unit 102a generates cash flow management information 106n from the project information 106a and the payment information 106i. . Here, since the payment information 106i is information at the actual stage that payment has actually been made, as shown in the cash flow management information 106n in FIG. 31, the cash flow classification is registered as "2: Actual". Further, the fact that the payment information 106i is registered means that "payment" has been made in the cash flow management, so as shown in the cash flow management information 106n in FIG. Withdrawal" is registered.

As shown in the cash flow management information 106n in FIG. 31, when the cash flow classification is "2: performance" and the deposit/withdrawal classification is "1: withdrawal", the cash flow management generation unit 102a As explained using FIG. 6, the amount in the payment information 106i is set as the amount in the cash management information 106n. Specifically, the cash flow management generation unit 102a aggregates the amounts in the payment information 106i for each record with the same combination of payment number, project number, payee, transaction classification, payment date, and CASHIN/OUT date. is set as the amount in the cash flow management information 106n.

(3) Updating the cash flow management information 106n and the work work-specific cash flow schedule information 106p , the cash flow management information 106n shown in FIG. 31 generated in (2) of this item [3-4] is added to update the cash flow management information 106n as shown in FIG.

Next, as shown in FIG. 33, the amounts in the generated cash flow management information 106n are aggregated by project number, customer code, cash flow classification, deposit/withdrawal classification, and CASHIN/OUT year/month. Work construction cash flow schedule information 106p is generated. As described above, the generated work construction-specific cash flow schedule information 106p is one of the two pieces of information from which the construction work-class cash flow schedule information 106r is generated.

The method of generating the work output target details 106q, which is the other of the two pieces of information from which the construction-by-construction cash flow schedule information 106r is generated, is the same as (4) of [3-1]. Description is omitted. The generated work output target specification 106q is as shown in FIG.

(4) Generation of construction-specific cash flow schedule information 106r and output of construction-specific cash flow schedule Generate cash flow schedule information 106r. In the generated work-specific financing schedule information 106r shown in FIG. 34, the amount (550,000 yen) in one matrix indicated by hatching is the newly added amount.

Finally, the schedule output unit 102c generates the construction-specific funding schedule (reference date=2021/05) shown in FIG. to output The construction-by-work financing schedule shown in FIG. 35 is a financing schedule for the A department for the construction identified by the project number PJ200001.

[3-5. Generation of cash flow schedule by department]
Next, generation of the departmental cash flow schedule will be described with reference to FIG.

The schedule output unit 102c aggregates the cash flow schedules for each construction work of the multiple construction works in the A department generated by the methods [3-1] to [3-4] on a department-by-department basis. Generate a cash flow schedule by department (however, the values in the concrete examples of [3-1] to [3-4] and the values in the concrete example of this item [3-5] are not related). Specifically, the cash flow schedule by construction for A construction in A department is the contents shown in the 7 lines (1) to (7) indicated by "A construction" in Fig. 36, and B construction in A division has the contents shown in 7 lines (1) to (7) indicated by "B construction" in FIG. By aggregating, rows indicated by (8) to (21) in FIG. 36 are generated to generate a divisional cash flow schedule for the A division.

When generating a departmental cash flow schedule, it is possible to specify, as an extraction condition, which stage of inquiries (planned), orders received (planned), and sales (actual) should be included in the table. be. In addition, it is possible to display up to which stage the value is included in the table as a "status" displayed on the side of the table.

Here, assuming that the creation time (present) of the cash flow schedule by department in Fig. 36 is the end of June 2021, the value of the "subtraction" row in the table is the elapsed month (2021 /04 to 2021/06) and the future month (2021/07 to 2021/11) are calculated using different formulas. For the elapsed months (2021/04 to 2021/06), the value in the row of the subtraction is calculated from the value in the row of the cash flow classification "2: Actual" and the deposit/withdrawal classification "0: Deposit" to the cash flow classification "2: It is calculated by subtracting the value of the row of "result" and the deposit/withdrawal category "1: payment". For the future month (2021/07 to 2021/11), the value in the row of the deduction will be changed from the value in the row of the cash flow classification "1: Scheduled" and the deposit/withdrawal classification "0: Deposit" to the cash flow classification "1: It is calculated by subtracting the value of the row of "scheduled" and the deposit/withdrawal category "1: payment".

In this way, by generating the departmental cash flow schedule and calculating the department total amount, for example, it is possible to display the status of each construction work belonging to each department and check the monthly total and cumulative amount of the department. . In addition, for example, the department manager can check whether the month in which the own department has a negative spread or whether the amount of advance receipts and collections is small and collections are concentrated in the second half.

[3-6. Generation of company-wide funding schedule]
Finally, generation of the 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 the plurality of departmental cash flow schedules generated by the method [3-5]. ] are not related to the values in the concrete examples of this item [3-6]). Specifically, the department-by-department funding schedule for department A is the contents shown in the seven lines (1) to (7) indicated by "A department" in FIG. Assuming that the table has the contents shown in the seven rows (1) to (7) indicated by "headquarters" in FIG. The rows indicated by (8) to (21) are generated to generate a company-wide funding schedule for the entire company.

Also, when generating the company-wide cash flow schedule, how to specify the extraction conditions, display the "status", and calculate the value of the "subtraction" row in the table was explained in [3-5]. Since it is the same as the cash flow schedule by department, detailed explanation is omitted.

By generating the company-wide cash flow schedule and calculating the company-wide total amount in this way, for example, the total for each department can be displayed, and the company-wide monthly total and accumulated amount can be confirmed. Also, for example, it is possible to take a bird's eye view of the entire company and check the departments and months in which the spread is negative. Then, for example, if the expenditure schedule of the headquarters is also added to the debt, it is possible to more precisely confirm and verify the cash flow schedule of the entire company.

[4. Summary of this embodiment]
As described above, according to the cash flow schedule management device 100 according to the present embodiment, by generating a cash flow schedule for each construction unit, department, or company, And it is possible to grasp the withdrawal amount. The financing schedule management device 100 according to the present embodiment is particularly useful, for example, in industries where long-term contracts occur and individual cost calculation is required (construction industry, IT (Information Technology) industry, production industry, etc.). .

Further, according to the cash flow schedule management device 100 according to the present embodiment, for example, based on the company-wide outlook, it is possible to work out countermeasures on a case-by-case basis for improving cash flow with departments and sites.

Further, according to the cash flow schedule management device 100 according to the present embodiment, for example, it is possible to simulate the future in consideration of undetermined information such as inquiries and contracts.

Furthermore, [3. [Specific example of processing] described cash flow schedule management based on scheduled deposit/withdrawal dates, but according to the cash flow schedule management device 100 according to the present embodiment, for example, switching can also be performed on a sales and purchase accounting basis. By doing so, it is possible to predict the prospective landing on a profit basis and a cash basis.

Furthermore, according to the cash flow schedule management device 100 according to the present embodiment, for example, by generating journal data for the scheduled performance data at a specific time and setting it on the accounting system side, the cash flow at the future time can be calculated. It is also possible to create and perform simulations.

[5. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

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

[6. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to the cash flow schedule management device 100, each component shown in the figure is functionally conceptual, and does not necessarily need to be physically configured as shown in the figure.

For example, all or any part of the processing functions of the cash flow schedule management device 100, particularly the processing functions performed by the control unit, are realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is recorded on a non-temporary computer-readable recording medium. It is mechanically read by the management device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the funding schedule management device 100 via any network, and all or part of it may be downloaded as necessary. It is possible.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" means memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (Registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single structure, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

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. Moreover, the cash flow schedule management apparatus 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment in the apparatus.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. That is, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

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

100 funding schedule management device 102 control unit
102a cash flow management generation unit
102b Calendar information generator
102c schedule output unit 104 communication interface unit 106 storage unit
106a Project information
106b Deposit schedule information
106c Billing information
106d Sales information
106e Billing Information
106f deposit information
106g Ordering Information
106h purchase information
106i payment information
106j Billing master
106k payee master
106m Transaction method master
106n Cash flow management information
106p Cash flow schedule information by work construction
106q Work output target details
106r Construction-specific funding schedule information 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (12)

A cash flow schedule management device comprising a control unit and a storage unit,
The storage unit contains
Project identification data, department identification data, a classification for identifying whether the financing is in the plan, schedule, or actual stage, and a classification for identifying deposit or withdrawal. Cash flow management information including a deposit/withdrawal category, an amount deposited/withdrawn, and a period to which the date on which the amount was cashed or cashed;
Work output target details, which is a table with the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis;
is stored and
The control unit
Identifying 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 storing the amount in the identified matrix schedule information generating means for generating project/department-based funding schedule information, which is funding schedule information for a combination of the project identified by the project identification data and the department identified by the department identification data, by When,
A matrix specified by these two axes, with the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis, based on the generated project/department cash flow schedule information schedule output means for outputting a project/department-specific funding schedule, which is a funding schedule for a combination of the project and the department, in which the amount is stored;
to provide
A funding schedule management device characterized by: The schedule output means is
aggregating the amounts in the generated project/department-specific funding schedule for each department, thereby outputting a department-specific funding schedule that is a funding schedule for each department;
The cash flow schedule management device according to claim 1, characterized by: The schedule output means is
outputting a company-wide cash flow schedule, which is a company-wide cash flow schedule, by aggregating the amounts in the generated departmental cash flow schedule;
The cash flow schedule management device according to claim 2, characterized by: The storage unit contains
project information including project identification data and department identification data;
payment schedule information including project identification data and payment schedule amount;
is also stored,
The control unit
In the cash flow management information, when the cash flow classification 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, the case Based on the project information and the payment schedule information having the same identification data, the department identification data in the project information is set as the department identification data in the cash flow management information, and the payment schedule information is set as the department identification data. further comprising cash flow management generation means for generating the cash flow management information by setting the scheduled deposit amount as the amount in the cash flow management information;
The cash flow schedule management device according to any one of claims 1 to 3, characterized by: The storage unit contains
project information including project identification data and department identification data;
pre-billing information including case identification data and pre-billing amount;
Sales information including project identification data and expected collection amount;
billing information including matter identification data and billing amount;
is also stored,
The control unit
In the cash flow management information, if the cash flow classification is a classification for identifying that the cash flow is in a planned stage and the deposit/withdrawal classification is a classification for identifying a deposit, the case Based on the project information having the same identification data and any one of the previous billing information, the sales information and the billing information, the division identification data in the project information is changed to the division in the cash flow management information. By setting as identification data and setting the previous billed amount in the previous billing information, the expected collection amount in the sales information, or the billed amount in the billing information as the amount in the cash flow management information , further comprising cash flow management generation means for generating the cash flow management information;
The cash flow schedule management device according to any one of claims 1 to 3, characterized by: The storage unit contains
project information including project identification data and department identification data;
payment information including project identification data and payment amount;
is also stored,
The control unit
In the cash flow management information, if the cash flow classification is a classification for identifying that the cash flow is in the actual stage, and the deposit/withdrawal classification is a classification for identifying deposits, the case Based on the project information and the deposit information having the same identification data, the department identification data in the project information is set as the department identification data in the cash flow management information, and the deposit amount in the deposit information. as the amount in the cash flow management information, further comprising cash flow management generating means for generating the cash flow management information;
The cash flow schedule management device according to any one of claims 1 to 3, characterized by: The storage unit contains
project information including project identification data and department identification data;
order information including project identification data and order amount;
is also stored,
The control unit
In the cash flow management information, when the cash flow classification is a classification for identifying that the cash flow is in the planning stage and the deposit/withdrawal classification is a classification for identifying payment, Based on the project information and the order information having the same item identification data, the department identification data in the project information is set as the department identification data in the cash flow management information, and the order is placed in the order information. further comprising cash flow management generation means for generating the cash flow management information by setting an amount as the amount in the cash flow management information;
The cash flow schedule management device according to any one of claims 1 to 3, characterized by: The storage unit contains
project information including project identification data and department identification data;
purchase information including project identification data and purchase amount;
is also stored,
The control unit
In the cash flow management information, when the cash flow classification is a classification for identifying that the cash flow is in the scheduled stage and the deposit/withdrawal classification is a classification for identifying payment, Based on the project information and the purchase information having the same project identification data, the division identification data in the project information is set as the division identification data in the cash flow management information, and the division identification data in the purchase information is set as further comprising cash flow management generation means for generating the cash flow management information by setting the purchase amount as the amount in the cash flow management information;
The cash flow schedule management device according to any one of claims 1 to 3, characterized by: The storage unit contains
project information including project identification data and department identification data;
payment information including project identification data and payment amount;
is also stored,
The control unit
In the cash flow management information, when the cash flow classification is a classification for identifying that the cash flow is in the actual stage and the deposit/withdrawal classification is a classification for identifying payment, Based on the project information and the payment information having the same project identification data, the department identification data in the project information is set as the department identification data in the cash management information, and the payment in the payment information is set. further comprising cash flow management generation means for generating the cash flow management information by setting an amount as the amount in the cash flow management information;
The cash flow schedule management device according to any one of claims 1 to 3, characterized by: The project is a construction project,
10. The cash flow schedule management device according to any one of claims 1 to 9, characterized by being used in the construction industry. A cash flow schedule management method executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Project identification data, department identification data, a classification for identifying whether the financing is in the plan, schedule, or actual stage, and a classification for identifying deposit or withdrawal. Cash flow management information including a deposit/withdrawal category, an amount deposited/withdrawn, and a period to which the date on which the amount was cashed or cashed;
Work output target details, which is a table with the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis;
is stored and
executed by the control unit;
Identifying 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 storing the amount in the identified matrix a schedule information generating step for generating project/department-based funding schedule information, which is funding schedule information for a combination of the project identified by the project identification data and the department identified by the department identification data, by When,
A matrix specified by these two axes, with the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis, based on the generated project/department cash flow schedule information a schedule output step of outputting a funding schedule by project/department, which is a funding schedule for a combination of the project and the department, in which the amount is stored;
including
A funding schedule management method characterized by: A funding schedule management program to be executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Project identification data, department identification data, a classification for identifying whether the financing is in the plan, schedule, or actual stage, and a classification for identifying deposit or withdrawal. Cash flow management information including a deposit/withdrawal category, an amount deposited/withdrawn, and a period to which the date on which the amount was cashed or cashed;
Work output target details, which is a table with the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis;
is stored and
for causing the control unit to execute
Identifying 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 storing the amount in the identified matrix a schedule information generating step for generating project/department-based funding schedule information, which is funding schedule information for a combination of the project identified by the project identification data and the department identified by the department identification data, by When,
A matrix specified by these two axes, with the combination of the cash flow classification and the deposit/withdrawal classification as one axis and the period as the other axis, based on the generated project/department cash flow schedule information a schedule output step of outputting a funding schedule by project/department, which is a funding schedule for a combination of the project and the department, in which the amount is stored;
including
A funding schedule management program characterized by:

Images