JPH08255203A - Cash flow schedule simulation system - Google Patents

Abstract

PURPOSE: To provide a cash flow schedule simulation system with with a general-purpose interface is provided to collect cash flow information from respective key jobs and further a cash flow schedule integrated over a whole company can be effectively simulated. CONSTITUTION: This system is provided with a cash flow information reception part 4 for receiving the cash flow information from key job systems with a general-purpose formet and storing it in an interface file 6, first-order simulation execution part 18 for executing a real cash flow schedule simulation based on a first-order simulation DB 16 containing a cash flow master file, cash flow information and correction information, condition setting part 20 for setting the various kind fo conditions of fixed information, and second-order simulation execution part 26 for executing a virtual cash flow schedule simulation based on a second-order simulation DB 24 containing the set conditions, cash flow information and correction information so as to make possible retrial and this system is effectively used for deciding the cash flow schedule over the whole company.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a fund-transfer plan simulation system, and more particularly to a fund-transfer plan simulation system that enables simulation of a fund-transfer plan controlled by a company as a whole, not by core business or department within a general enterprise. .

[0002]

2. Description of the Related Art Needless to say, cash flow is a very important factor in corporate management in accounting processing in general companies. Therefore, it is necessary to sufficiently carry out a simulation of cash flow based on not only actual transactions of debts / debts but also transactions that will occur in the future, so that it can be effectively used for financing in the future. In recent years, a financing system that can perform such various financing simulations has been constructed.

[0003]

However, although the system of cash management has been systematized in the past, the system of cash management is not so advanced. This is because the content and form of information on cash flow are not uniform throughout the company because they are different for each core business such as bill management, deposit and savings management, etc., so that necessary information cannot be collectively collected as integrated data. Therefore, information about cash flow in each core business is usually apt to be buried in the heads of managers or senior managers of accounting, and even if a cash flow simulation can be performed for each department, the funds managed by the entire company can be managed. It was very difficult to perform the repeating simulation.

Further, it is desired to be able to more effectively simulate a wide variety of funding schedules.

The present invention has been made to solve the above problems, and an object thereof is to provide a general-purpose interface capable of collecting fund transfer information from each core business, and further to provide a company-wide interface. The purpose of the present invention is to provide a cash flow simulation system that enables effective simulation of cash flow schedules integrated in.

[0006]

In order to achieve the above-mentioned object, the invention of the present invention performs a simulation of a cash flow plan on the basis of cash flow information relating to a transaction of a credit / debt or a transaction schedule in a general enterprise. In a fund transfer schedule simulation system, a fund transfer information receiving means for receiving fund transfer information in a unified data format from each core business system, a fund transfer information storage means for storing the received fund transfer information, and a fund transfer schedule simulation It is characterized by having a cash flow master file for storing information other than the cash flow information necessary for performing the above, and a simulation executing means for performing a cash flow schedule simulation integrated based on the cash flow information.

Further, the cash flow information received from each core business system is characterized by including key information for identifying the cash flow information, transaction information for specifying transaction contents, and settlement schedule information for settlement of transactions.

Further, the key information includes a connection system classification, a data identification span and a batch processing number.

Further, the transaction information is characterized in that it includes a type, a counterparty, an occurrence date, an amount of money, various expenses, a burden category and an interest rate.

Further, the settlement schedule information includes at least one set of a fund item, a settlement date, a settlement period and a settlement amount.

Further, the present invention is characterized by further comprising a cash flow information correction storage means for storing correction update information when the cash flow information received from each core business system is corrected and correction information including whether or not the correction is possible.

In addition, the simulation condition setting means for setting various conditions for carrying out the cash carrying schedule simulation is provided, and in addition to the primary simulation which is a realistic cash carrying planning simulation, the setting conditions by the simulation condition setting means are provided. It is characterized by performing a secondary simulation, which is a simulation of a virtual fund raising plan based on.

[0013]

In the present invention having the above structure,
By providing a unified data format, it is possible to collect the financing information from each core business system at once, so that it is possible to carry out a simulation of the financing schedule that is integrated over the entire company.

Further, by providing correction information including whether or not to correct the cash flow information from each core business system in correspondence with the cash flow information, it is possible to prevent unnecessary correction of the cash flow information.

Further, since various conditions for performing the fund transfer schedule simulation can be set from the simulation condition setting means, for example, when the fund shortage occurs as a result of the realistic fund transfer schedule simulation, various setting conditions are set. While changing the various secondary (virtual)
Since it is possible to perform a simulation of a fund-raising schedule, it can be useful for formulating a fund-raising plan.

[0016]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT A preferred embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a fund transfer schedule simulation system according to the present invention. The financing system simulating system 2 is connected to each core business system that performs each core business performed in each department, that is, sales management, production management, bill management, and the like. The system 2 includes means for acquiring fund transfer information, means for performing realistic simulation of fund transfer schedule (primary simulation) based on various actual information, and various setting conditions, which will be described later in detail. A means for performing a simulation (secondary simulation) of a virtual funding schedule,
Can be roughly divided into

The means for acquiring the cash flow information is a cash flow information receiving part 4 as a cash flow information receiving means for receiving the cash flow information from the core business system, and a cash flow information storage received by the cash flow information receiving part 4. It has a simulation interface file (hereinafter, referred to as “interface file”) 6 as a means for financing. In order for the cash flow information receiving unit 4 to receive the data of the cash flow information in the unified format, it is necessary to prepare an application capable of transmitting the cash flow information in the unified data format in each core business system as a connection option. There is.

The means for carrying out the primary simulation is a fund transfer master file (connection option management master file 8, opening fund balance master file 10 and fund transfer) which stores information other than the fund transfer information necessary for performing the fund transfer simulation. Scheduled fixed information database (hereinafter,
(Referred to as “fixed information DB”) 12), and an environment setting unit 14 for setting environment in the cash flow master file,
When making corrections to the data content of the cash flow information included in the interface file 6, the cash flow information primary storage simulation database as a cash flow information correction storage means for storing the cash flow information including the correction data by adding the correction information. (Hereafter, referred to as "primary simulation DB")
16 and a primary simulation executing unit 18 as a simulation executing unit that performs a realistic simulation of a fund transfer schedule based on the fund transfer information.

The means for performing the secondary simulation includes a condition setting section 20 as a simulation condition setting means for setting various conditions for carrying out the fund transfer simulation, and a secondary simulation condition file 22 for storing the set conditions. And the primary simulation DB16
When making a correction to the data content of the cash flow information included in the cash flow information, the secondary simulation database (hereinafter, "Secondary simulation DB") 24, and a secondary simulation execution unit 26 as a simulation executing means for performing a virtual simulation of fund transfer schedule integrated based on the fund transfer information.

Further, the present system 2 has a financing schedule information output unit 28 for displaying / printing the simulation result in each simulation executing unit 18, 26. This outputs the fund transfer schedule information created in the form of a graph or a table to a display device (not shown) or a printable printer (not shown).

As is apparent from the system configuration described above, in this embodiment, the simulation of the cash flow plan is performed based on various conditions that are arbitrarily set, in addition to the realistic primary simulation performed based on the actual information. The feature is that a virtual secondary simulation can be performed.

FIG. 2 is a diagram showing the data format of the cash flow information sent from each core business system to this system 2 in this embodiment. This data format has an extremely general-purpose interface designed to pay attention to the generation of debts and debts and their settlement (reflection to cash flow). The cash flow information includes key information (data creation key information) that identifies the cash flow information, transaction information (credit / debt information) that specifies the transaction content, and settlement schedule information regarding settlement of the transaction. The data creation key information, the bond / debt information, and the settlement schedule information are composed of respective data as shown in FIG.

The "connected system classification" is ID information for identifying the connected core business system. The "data extraction span" represents the unit of aggregation of the source of cash flow information. For example, in the case of monthly summarizing the fund-raising schedule information for the following months and thereafter, data representing "year and month" is set. “Batch processing No.” is a batch processing number in the combination of “connected system classification” and “data extraction span”.
That is, the cash flow information is identified by the combination of the data creation key information. It is effective for duplicate check and replacement check during retry. “Type” is the type of receivables / payments such as accounts receivable and payable. The “counterparty code” is a code for identifying the transaction partner of the credit / debt such as the customer code and the company code. The “occurrence date” is the date on which the credit / debt has occurred (is scheduled to occur). “Amount” is the amount of the debt / debt. “Other expenses” are amounts of various expenses such as transfer fees. The “burden classification” indicates the person who bears various expenses such as the company or the other party. “Interest rate” represents the interest rate (%) when the “type” is payment / interest income. The “fund item code” indicates a fund item for settlement of funds such as bill due date payment. "Settlement date"
Is the date on which the funds will be settled. "Payment institution" is
It is an institution to settle cash such as cash accounts or various bank accounts. The “payment amount” is the amount to be settled. Set a positive number for increasing funds and a negative number for decreasing funds. Note that the settlement schedule information is a positive multiple (×) because it is customary to specify multiple settlement methods for one claim / debt.
n). Therefore, if this relationship is defined by the branch number or the like in the data creation key information, it may be a separate record.

By using this unified general-purpose data format, it is possible to collectively collect the cash flow information necessary for totaling the cash flow schedule regarding the credit / debt transaction or the transaction schedule from all the core business systems.

Next, the three types of funding master files used in this embodiment will be described. In the connection option management master file 8, the core business system that is the target of the simulation of the fund-transfer plan is set. For example, information such as "connect to sales management" and "not connect to bill management" is set. In the beginning-of-year funds balance master file 10, units for totaling the beginning funds balance are set. "By account", "By company", etc. The fixed information DB 12 stores the information necessary for performing the financing simulation other than the financing information received from the backbone information system. Information common to each backbone, information not related to direct transactions, and usually frequently Fixed information such as information that is not changed is set. For example, the ratio of payment of cash and bills, bill discount rate, name of financial institution, interest rate of each financial institution, labor cost, etc. are included.

FIG. 3 is a diagram showing the data structure of various databases used for storing cash flow information used in this embodiment. The various databases will be described with reference to this figure.

FIG. 3A is a storage format of the interface file 6 for storing the cash flow information received from all the core business systems in this embodiment.
In this embodiment, as is apparent from the figure, the data format of the cash flow information sent from each core business system is recorded as it is. Of course, a data structure that is easy to use may be used.

FIG. 3B shows a primary simulation DB.
16 is a diagram showing a data structure of 16, which has a data structure in which correction information is added to the same data structure of cash flow information as the interface file 6. As the correction information, the contents when any data included in the interface file 6 is corrected when the primary simulation is performed are written. The correction information includes update date and time, which are update information, “update date” and “update time”, an “update ID” indicating the identification number of the person who made the update, and a “confirmation flag” indicating whether the correction is possible. Contains. The cash flow information can be re-corrected until the confirmation flag is set. A comment field may be provided to arbitrarily write a comment by the updater.

FIG. 3C shows the secondary simulation DB.
It is the figure which showed the data structure of 24, and is the same as the data structure of primary simulation DB16. However, in the secondary simulation DB 24, modification information is written when the funding information stored in the primary simulation DB 16 is modified.

FIG. 4 is a flow chart showing the flow of the processing of the fund transfer simulation in this embodiment. The processing in this embodiment will be described below with reference to this figure.

First, various initial information is set from the environment setting unit 14 before the simulation of the fund transfer plan (step 101). For the connection option management master 8, it is set which fund transfer information from which core business is to be processed. This may be the connection / disconnection of the target core business system, or the cash flow information may be received from all the core business systems and the information to be used later may be selected. With this setting, the cash flow information can be received from each core business system regularly or sequentially. The opening fund balance master file 10 is set such that the opening fund balance is “by account”. In this case, the opening fund balance of the entire company will be obtained by automatically collecting the data for each account. The above-mentioned fixed information and the like are set in advance in the fixed information DB 12.

According to the above environment setting, the target financing information among the financing information included in the interface file 6 collected from the predetermined core business system is developed in the primary simulation DB 16 (step 102).
The primary simulation is this primary simulation D
It is performed based on B16. Next, the operator, if necessary, from the terminal device, the contents of correction of the fund-raising information and the display contents of the fund-raising schedule information desired to be obtained (for example, the fund-raising schedule transition graph by account), format (graph, table), target time, etc. Is designated (step 103). When the funding information is modified, the updater, date, etc. are recorded in the primary simulation DB 16 as modification information. Further, the operator sets whether or not the correction content can be re-corrected in the confirmation flag. When the corrections and inquiries are completed, the fund transfer schedule simulation is actually executed (step 104), and the fund transfer schedule information output unit 28 outputs the fund transfer schedule information output to a specified output device in a specified format. (Step 105).

FIG. 5 is a diagram showing an output example of the funding schedule information obtained by the funding schedule simulation. Here, a method of using the output funding schedule information will be described.

FIG. 5 (a) is a company-level fund transfer schedule graph. It can be seen from this graph that the company lacks funds at T1, so some measures should be taken before that. You will find that you need to take FIG. 5 (b) is a graph of planned cash flow transition at the account level. According to this graph, there is a shortage of funds company-wide at the time T1, but at the time T2, the cash flow is successful in that account. It is possible to determine that there is no shortage of funds for the entire company just by not having it. Therefore, it can be understood that the shortage of funds in the account can be solved by applying a allowance such as a direct debit from another account with a margin.

FIG. 5 (c) is a company-wide and account-level funding schedule list. With this list, it is possible to understand at a glance what kind of deposit schedule and withdrawal schedule are available. it can. By account, it is possible to grasp the details of the withdrawal and withdrawal schedules, so it is possible to easily know the reason for the lack of funds.

As described above, the primary simulation is carried out regularly or at any time. In the primary simulation, a realistic fund transfer schedule simulation is carried out using the actual fund transfer information and the actual fixed information. , You can get real-life funding schedule information. After the above process is completed, if it is desired to continue outputting in a different format in step 106, or if the cash flow information is re-corrected, the process returns to step 103.

Next, the secondary simulation will be described.

This secondary simulation is characterized in that the primary simulation is a realistic fund-raising schedule simulation, while the virtual fund-bearing schedule simulation is performed by changing the conditions up to fixed information.

When setting conditions (step 107),
Although various conditions are set from the condition setting unit 20 (step 108), examples of the various conditions to be set include, for example, cash payment ratio, payment (purchase) of a bill site, etc.
Change of conditions, change of payment (sales) conditions such as cash deposit ratio, bill discount rate, etc., change of deposit conditions such as early cancellation, deposit shift, etc., refinancing, repayment delay, interest rate fluctuation, etc. , Changes in closing dates, changes in personnel expenses / labor expenses such as raises. In other words, in the secondary simulation, it is possible to execute a virtual fund transfer simulation such as what happens if the settlement date is delayed although the funds are actually insufficient. The various conditions set are recorded in the secondary simulation condition file 22. As a result, it can be recorded as a log or can be reused. In addition, it is not necessary to rewrite the actual fixed information and perform the fund transfer simulation.

According to the above-mentioned condition setting, the target financing information among the financing information included in the primary simulation DB 16 is developed in the secondary simulation DB 24 (step 109). The secondary simulation is performed based on the secondary simulation DB 24. Then, the fund transfer schedule simulation is actually executed (step 110), and the fund transfer schedule information output unit 28 outputs the fund transfer schedule information output to a specified output device in a specified format (step 111). . Note that these outputs can use the same format as that shown in FIG. 5 described above even in the secondary simulation, so there is no need to prepare an output format for the secondary simulation.

In this secondary simulation, when there is a shortage of funds company-wide as at time T1 shown in FIG. 5 (b), which condition can be changed to eliminate the shortage of funds at time T1. It is possible to virtually examine the measures to be taken. For example, it can be resolved by extending the payment due date to the supplier, or can be resolved by changing the bill discount rate. If the bill discount rate is to be changed, whether or not the company-wide fund shortage can be resolved by changing the relevant bill discount rate from the condition setting unit 20 and retrying the secondary simulation in step 107. Is immediately known. In this way, by performing the secondary simulation, various countermeasures can be virtualized by changing the contents of fixed information that could not be changed in the primary simulation, not only for each account but also when the company lacks funds. And can be useful in formulating a financing plan.

As described above, according to the present embodiment, if a unified data format is provided to receive the cash flow information from each core business system, and if the cash flow information is sent based on this format, each cash flow information is sent. A company-wide fund transfer schedule simulation that controls the business system can be performed to obtain fund transfer schedule information. Further, since the cash flow information from each core business system can be collected in a unified data format, the cash flow schedule simulation system can be packaged.

In the secondary simulation,
Since the condition setting unit 20 is provided and various conditions can be set without changing the actual fixed information, it is possible to study various countermeasures for cash flow so as to support the creation of company-wide cash flow.

Although the interface file 6, the primary simulation DB 16 and the secondary simulation DB 24 are provided for each purpose in the above embodiment, sharable cash flow information and the like may be shared. It is also possible to independently execute the primary simulation and the secondary simulation.

[0046]

According to the invention described in claims 1 to 5, by providing a unified and general-purpose data format for receiving the cash flow information necessary for counting the cash flow schedule, it is possible to use from any core business system. It becomes possible to collect the cash flow information collectively. As a result, it becomes possible to carry out company-wide simulations by carrying out the simulation of fund-carrying schedules, which had been carried out independently by each department and each core business.

According to the sixth aspect of the invention, the fund-raising information can be corrected even during the fund-raising schedule simulation, and the correction information can be recorded. Further, since the correction information has a region for setting whether or not the correction is possible, it is possible to prevent unnecessary correction.

According to the invention of claim 7, the virtual secondary simulation can be carried out on the basis of various conditions arbitrarily set in addition to the primary simulation for carrying out the realistic fund transfer simulation. It is possible to virtually examine various measures for managing cash on the system, such as when a cash shortage occurs, and it can be useful for formulating a cash management plan.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing an embodiment of a fund transfer schedule simulation system according to the present invention.

FIG. 2 is a diagram showing a data format of cash management information sent from each core business system to this system in the present embodiment.

FIG. 3 is a diagram showing a data structure of various databases in which cash flow information used in this embodiment is stored. (A) is an interface file, (b) is a primary simulation DB, (c). FIG. 6 is a diagram showing a data structure of a secondary simulation DB.

FIG. 4 is a flowchart showing a flow of processing of a fund transfer schedule simulation in the present embodiment.

FIG. 5 is a diagram showing an output example of funding schedule information obtained by a funding planning simulation in the present embodiment.

[Explanation of symbols]

2 Financing plan simulation system, 4 Financing information receiving unit, 6 Financing plan simulation interface file (interface file), 8 Connection option management master file, 10 Beginning fund balance master file, 12 Financing plan fixed information database ( Fixed information DB), 14 environment setting section, 16 funding simulation primary simulation database (primary simulation DB), 18 primary simulation executing section, 2
0 condition setting unit, 22 secondary simulation condition file, 24 funding simulation secondary simulation database (secondary simulation DB), 26 secondary simulation execution unit, 28 funding planning information output unit.

Claims (7)

[Claims] 1. A cash flow simulation system for simulating a cash flow schedule based on cash flow information relating to a bond / debt transaction or a transaction schedule in a general enterprise, wherein cash flow information in a unified data format from each core business system. A cash flow information receiving means for receiving the cash flow information, a cash flow information storage means for storing the received cash flow information, a cash flow master file for storing information other than the cash flow information necessary for performing the cash flow schedule simulation, A simulation system for performing a financing plan, comprising: simulation executing means for performing a simulation of a financing plan integrated based on the financing information. 2. The simulation system for cash flow planning according to claim 1, wherein the cash flow information received from each core business system relates to key information for identifying the cash flow information, transaction information for specifying transaction details, and transaction settlement. A cash transfer schedule simulation system characterized by including settlement schedule information. 3. The financing schedule simulation system according to claim 2, wherein the key information includes a connection system classification, a data identification span, and a batch processing number. 4. The fund-raising schedule simulation system according to claim 2, wherein the transaction information includes type, counterparty, date of occurrence, amount of money, various expenses, burden category and interest rate. system. 5. The cash-scheduling simulation system according to claim 2, wherein the settlement-scheduling information includes at least one set of a cash item, a settlement date, a settlement period, and a settlement amount. 6. The cash flow simulation system according to claim 1, wherein the cash flow information storing correction data including correction update information and correction propriety when correction is made to the cash flow information received from each core business system. A fund-raising-scheduled simulation system having information correction storage means. 7. The simulation system for fund transfer plan according to claim 1, which has a simulation condition setting means for setting various conditions for carrying out the fund transfer simulation, and is a realistic simulation for fund transfer. In addition to the simulation, a fund transfer schedule simulation system characterized by performing a secondary simulation which is a simulation of a virtual fund transfer schedule based on a setting condition by the simulation condition setting means.