JPH07191961A - Processing method for prediction of cash flow - Google Patents

Abstract

PURPOSE:To provide a new processing method for prediction of cash flow which achieves the short-period fund management purpose. CONSTITUTION:Future item data is inputted to a classification file b1, and classification pattern data accompanying the cash flow is inputted to an ordinary classification master (d), and data to predict the main profit and loss items of each month occurring after the prediction day based on data in the same month of the preceding year is inputted to a future main profit and loss item prediction data file 5, and data of principal recovery or payment pattern data is inputted to a recovery and payment pattern master 2, and the Shifty short- term cash flow is predicted based on these input data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a cash flow forecasting processing method for providing a program program for propagating cash flow forecasting processing in a financial accounting system.

[0002]

2. Description of the Related Art A conventional financial accounting method is, as shown in FIG. 2, input data such as a transfer slip, a receipt slip, and a withdrawal slip, and repetitive continuation in a hard disk such as a regular journal master and a summary master. Based on usage information, draw out information about account item amount (total balance trial balance, monthly income statement, etc.), auxiliary item amount (auxiliary item balance list, etc.), department item amount (department income statement, etc.) And
The main purpose was to retrieve data such as journals, ledger, and transaction details by consumption tax. In other words, in the conventional financial accounting method, the purpose was to grasp the financial accounting processing from the past to the present based on the input data.

[0003]

[Problems to be Solved by the Invention] One of the important things in company management is "future financing", that is,
It is important to grasp the monthly payment amount and whether or not payment is possible based on the amount of future payments in advance.

The present invention predicts the daily cash flow for a predetermined period (for example, 6 months) after the specified prediction date, and
We made it possible to forecast short-term fund management, such as procuring and repayment of insufficient funds, and non-recurring funds coming and going, that is, to achieve the short-term fund management objectives.
It is intended to provide a cash flow forecasting processing method for proliferation to a financial accounting processing system.

[0005]

The present invention provides a journal file in which specific journal data such as a receivable or payable journal is input, and a regular journal master in which repetitive journal pattern data is input. In the provided financial accounting processing system, the journal file is collected. Payment due date,
Enter future items data such as cash settlement ratio and bills site, enter journal pattern data that accompanies the movement of funds to the regular journal entry master, and enter the main profit and loss items for each month that occur after the forecast date. Input the data to be predicted based on the data of the same month of the previous year into the future main profit and loss item forecast data file and collect the data of major collection or payment pattern.
A cash flow prediction processing method that predicts the daily movement of funds by inputting into the payment pattern master and searching for transactions that cause the inflow and outflow of funds for a predetermined period after the predicted reading date based on the above input data. It is related. The present invention is based on the above, and is intended to achieve the purpose of short-term fund management.

[0006]

[Operation] Collected in journal file. Enter future data such as expected payment date, cash settlement rate, bills site, and enter journal pattern data that accompanies the movement of funds in the regular journal master. Data that predicts profit and loss items based on the same month last year,
Input into the future main profit and loss item forecast data file and collect the data of major collection or payment patterns. Enter in the payment pattern master.

Based on this, based on the reading and retrieval of the above-mentioned input data, for example, cash flow forecast conditions, daily cash schedule, monthly cash schedule, forecast item list, for example, 6
It predicts the daily movement of funds by searching for transactions that cause the inflow and outflow of funds for a predetermined period after the forecast date such as months.

[0008]

FIG. 2 shows an example of a conventional financial accounting basic processing method which is the basis for carrying out the cash flow forecasting processing method according to the present invention. Since the basic processing method of financial accounting shown in the figure belongs to a known technique, a detailed description thereof will be omitted, but the outline thereof is as follows.

In FIG. 2, A is a data input processing unit, which is data to be inserted each time such as a transfer slip, a deposit slip, and a withdrawal slip, that is, specific journal data such as a receivable or payable journal. , Consists of a regular journal entry master that has entered journal pattern data that is used repeatedly, and a summary master that has entered data other than the above,
Both masters are provided in the repeated continuous use information storage space set in the hard disk.

B is a journal file, which is an input file in the hard disk. It is a space for storing the processing result, and is for processing the information derived from the data input processing unit A described above.

C is a display item group, and the journal entry file B
Information is retrieved, or necessary information is shown via other data files such as an account amount file. The display is output by a display or a printer.

Reference numeral D is a display display item group displayed in a state where graphic data processing is performed.

FIG. 1 shows a flowchart of a cash flow prediction processing method according to the present invention. Further, the cash flow forecasting processing method according to the present invention expands and incorporates the conventional financial accounting basic processing method illustrated in FIG. That is, in FIG. 2, the journal file B1 to which new data is input corresponds to the journal file B1 shown in FIG. Then, the series of flowcharts shown in FIG. 1 are set to coexist with the series of flowcharts shown in FIG.

In other words, in the drawing, the cash flow forecasting processing method portion according to the present invention (FIG. 1) and the conventional financial accounting basic processing method (FIG. 2) are shown separately, but in reality, both are This is a flow chart in a form in which they are merged and a branch is made from the "journalization file B1" in which new data is input to the "journalization file B".

A1 is a data input processing unit, which is similar to the data input processing unit A shown in FIG.
The transfer slip a, the deposit slip b, and the withdrawal slip c are transmitted to the journal file B1 described below. Then, the regular journal entry master d in the data input processing unit A1 is, in addition to the items entered in the regular journal entry master shown in FIG. 2, journal data accompanied by the movement of funds, such as a journal entry / exit at the same time every month. Has been input, and the data is transmitted to the automatic processing system 1 described below.

The journal entry file B1 shown in FIG. 1 is specific journal entry data (for example, transfer slip a, deposit slip b, and withdrawal slip) that has already been input to the sorting file B shown in FIG. In addition to the accounts receivable and accounts payable journals based on c etc.), future item data such as “scheduled collection payment date”, “cash settlement ratio”, and “bill settlement site” are newly read.

Reference numeral E denotes a cash flow forecasting processing unit, which is constructed by a system and a master as described below.

Reference numeral 1 denotes an automatic processing system, which controls automatic calculation processing for predicting the daily movement of funds for a predetermined period (6 months in the illustrated embodiment) after the predicted date. Then, the data of the journal file B1 described above is sent to the automatic processing system 1.

Reference numeral 2 is a collection in which data of major collection or payment patterns and their composition ratios are input. This is a payment pattern master, and this data is entangled in a future main profit / loss item forecast data file 5 and sent to the automatic processing system 1 to generate main profit / loss items for each month (for example, accounts receivable) occurring after the forecast date. , Accounts payable, etc.) for predicting future daily fund movements.

3 is a trade receivable. Individual collection of accounts payable. It is a payment term master, and the collection. When the additional data input 4 is input to the journal file B1 together with the payment pattern master 2, it plays a role of supporting the creation of the input data. In other words, for each sub-account set for accounts receivable and accounts payable,
Recovery of each. Payment terms are collection. It is made possible to register which of the payment pattern masters 2 it corresponds to, and if an auxiliary subject is entered in the receivable / payable accrual journal, based on the registered pattern, "collection. , "Cash payment ratio", "Bill payment site" are automatically displayed on the system. This automatically displayed content can be modified and entered.

Reference numeral 5 is a future main profit / loss item forecast data file for forecasting items such as sales and purchases based on the data of the same month of the previous year. Then, the input to the data file is input via the future data input unit 6. Then, as support data for that purpose, the past balance data file 7 such as the previous term account amount file, the two-previous term account item amount file, and the two-previous term account item amount file is used.

Reference numeral 8 is a cash flow forecast condition list, 9 is a daily cash flow forecast table, 10 is a monthly cash flow forecast table, and 11 is a forecast item list, which are searched by the automatic processing system 1. The data information of a pattern is shown. The output is displayed by a display or a printer.

As described above, the collection. Future item data such as expected payment date, cash settlement ratio, bill site, etc. are newly entered, journal data accompanied by movement of funds is entered in the regular journal entry master d, and each month that occurs after the forecast date Input the data for forecasting the main profit / loss items based on the data of the same month of the previous year into the future main profit / loss item forecast data file 5 and collect the data of major recovery or payment pattern. It is input in the payment pattern master 2.

By reading and retrieving each of the above-mentioned data by the automatic processing system 1, for example, a fund transfer forecast condition list 8, a daily fund transfer schedule 9, a monthly fund transfer schedule 10,
For example, a transaction that causes the inflow and outflow of funds for a predetermined period after the predicted date, such as 6 months, such as the forecast item list 11, is searched to predict the daily movement of funds.

[0025]

According to the present invention, the daily cash flow for a predetermined period (for example, 6 months) after the specified forecast date is predicted,
In addition, forecasting of short-term fund procurement and repayment, non-recurring fund inflows and outflows, that is, future forecasts is enabled, and the short-term fund management objective is achieved. Therefore, regarding "future cash flow", which is one of the important matters in the management of the company, it is necessary to grasp the amount of monthly payments and whether or not payment is possible based on the expected amount of future payments as soon as possible. Is facilitated.

[Brief description of drawings]

FIG. 1 is a flowchart of a cash flow prediction processing method according to the present invention.

FIG. 2 is a flowchart showing an example of a conventional financial accounting basic processing method which is a basis for carrying out the cash flow forecasting processing method according to the present invention.

[Explanation of symbols]

 A1 Data input processing part a Transfer slip b Deposit slip c Withdrawal slip d Regular journal master B1 Journal file E Cash forecasting processor 1 Automatic processing system 2 Collection. Payment pattern master 3 Accounts receivable. Individual collection of accounts payable. Payment term master 4 Additional data input 4 5 Future main profit / loss item forecast data file 6 Future data input section 7 Past balance data file 8 Cash flow forecast condition list 9 Daily cash flow forecast table 10 Monthly cash flow forecast table 11 Forecast items List

Claims (1)

[Claims] 1. A financial accounting system comprising a journal file in which specific journal data such as accounts receivable and accounts payable are entered, and a regular journal master in which journal pattern data to be repeatedly used is entered. Collected in the journal file. Future data such as expected payment date, cash settlement rate, bills site, etc. is newly input, and journal pattern data accompanied by movement of funds is input to the regular journal master, and each month after the forecast date is generated. Input the data for forecasting the main loss items based on the data of the same month of the previous year into the future forecast data file of the main loss items and collect the data of major collection or payment pattern. A cash flow forecasting processing method for predicting the daily movement of funds by inputting into the payment pattern master and searching for transactions that cause the inflow and outflow of funds for a predetermined period after the predicted reading date based on the above-mentioned input data.