JP2003316935A - Management support device, management support method, and computer-readable recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a management support device capable of immediately providing the state of cash flow in a period ranging from the present to the future by successively storing information on income and payment occurring in a business management in a database. <P>SOLUTION: Order intake data and order placing data inputted from an input means 16 are stored in an income database 24 and a payment database 26 as data including income amount and incoming date and payment amount and payment date based on a payment condition file storing payment conditions for each customer, and a loan amount and loan date as income and a payment amount and payment data as payment from the inputted loan amount, loan date, payment conditions, and interest calculation file 20 are stored in a loan database 28. A target period and calculation unit are appointed, and all income amounts and all payment amounts are totaled from the databases, and a difference therebetween is outputted, as cash flow data, to an output means 18. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a management support device, a management support method, and a computer-readable recording medium for providing information on finance and profit / loss to a business manager by a simple operation, and particularly to a business. A management support device capable of accumulating information on income, payments, and due dates that occur daily in management in a database one after another by simple computer operation, and easily providing cash flow from the present to the future and profit and loss status. The present invention relates to a management support method and a computer-readable recording medium.

[0002]

2. Description of the Related Art Many accounting systems using computers for performing settlement processing and accounting processing of companies have been commercially available. These accounting systems are created in accordance with the accounting principles and the bookkeeping principles of double-entry bookkeeping, with an emphasis on tabulating past income and expenses incurred in the fiscal year (in addition to cash). There are restrictions such as the need for a journal entry voucher because of journal entry, the complexity of processing that requires processing by an accounting expert, and the treatment of finance (cash management) and profit and loss as separate items. It was

Generally, the profits and losses as a result of the settlement are important to the managers of the companies and the financial managers of the companies, but considering the current performance, it will be one half of the next six months.
It is more important to grasp the status of monthly cash flow and profit / loss for a year or several years, and to take measures early.
The reason is that even if sales are good, there is no cash flow, and if a cash shortage occurs, it could lead to bankruptcy.

In order to avoid such a risk, it is necessary for the manager and the financial manager to easily grasp the status of cash flow and profit and loss over a certain period in the future.
An accounting system based on the above accounting principles and bookkeeping principles cannot be dealt with, and a financial and accounting system based on a cash-based accounting book is desired. This need is due to the inability to hire a wealth of financial and accounting staff.
This is especially noticeable in a relatively small company, which does not have a system to keep track of performance, cash flow, and profit / loss status whenever managers and financial managers need it.

As described above, it is essential for the corporate manager to make daily business decisions, and it is necessary to grasp the cash flow (cash flow) after a certain period from the present. As a system for grasping this cash flow, JP 200
There is a system disclosed in Japanese Patent Publication No. 1-14384.

The system is a cash file, an income file in which the sales amount of each customer is recorded, a payment condition file of each customer, an expenditure file in which expected expenditure types and their payment deadlines are entered. Then, from the income file and the payment term file, calculate the total income forecast from all customers at the future standard time, and add the cash amount at the standard time to this to obtain the total fund forecast available at the standard time. In addition to the calculation, the total expected spending amount is obtained from the data of the spending file, and the total estimated amount of funds and the total expected spending amount are written together and output to a display device or the like.

[0007]

However, in the system disclosed in the above-mentioned prior art, a certain point in the future is designated as the reference time, and the total amount of funds forecast and the total amount of expenditure forecast at that reference time are written together. It's just for display,
For example, it is not enough for the purpose of dynamically grasping the monthly cash flow situation for the next six months, one year, or several years, knowing when there is a risk of a cash shortage, and taking early measures. There is a problem that we can not cope, and also,
There was also a problem that there was no function to calculate profit and loss, and it was not possible to meet the demand for grasping profit and loss as well as cash flow.

Therefore, according to the present invention, information on income, payments and their dates that occur on a daily basis in business management is sequentially accumulated in a database by a simple computer operation, and the cash flow from the present to the future and the profit and loss situation are immediately obtained. Management support device, management support method,
Another object is to provide a computer-readable recording medium.

[0009]

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems, and provides an input means, an output means, a control means including a calculation section, and a payment condition for each customer. Order data input from the input means, which includes a stored payment condition file, an interest rate calculation file, an income database for storing income data, a payment database for storing payment data, and a borrowing database for storing borrowing data. Based on the payment condition file and the payment condition file, individual income data including an income amount and an income date are stored in the income database, and based on the order data input from the input means and the payment condition file, the payment amount and Individual payment data including a payment date is stored in the payment database, and a loan amount, a loan date, and a repayment condition input from the input means. Serial on the basis of the interest calculation file,
The borrowing amount and the borrowing date as income, the repayment amount and the repayment date as payment are stored in the borrowing database, and based on the noticed period and the aggregation unit input from the input means, the control means causes the change in the noticed period. For each aggregation unit, the total income amount of the income database and the borrowing database, and the total payment amount of the payment database and the borrowing database are totaled, and the difference between the total income amount and the total payment amount is used as cash management data in the output means. It is characterized by outputting.

Therefore, according to the present invention, information on income, payments, and dates that are routinely generated in business management are sequentially accumulated in a database by a simple computer operation, and cash flow from present to future and profit and loss status. It will be possible to immediately provide, and based on the current financial situation, the management can dynamically grasp the monthly cash flow situation for the next six months, or for several years, and At times when there is a risk, you can immediately understand the sales forecast and profit and loss forecast for this term, and you can implement countermeasures early. Further, it is possible to easily grasp the deviation from the sales target and the actual profit, the profit and loss status of each product, etc. Further, it becomes easy to update the financial management data when there is a rapid sales change or a change in cost.

[0011]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described in detail below with reference to the accompanying drawings. FIG. 1 is a block diagram showing a schematic configuration of a management support apparatus according to the present invention. A management support apparatus 10 of the present invention includes a recording medium 12 storing a program that is a processing procedure for management support, a control unit 13 including a calculation unit 14, an input unit 16, an output unit 1.
8. Interest rate calculation file 20 which is a tool for calculating repayment amount for borrowed money, payment condition file 22 storing payment conditions for each customer, income database 24 storing income data, and payment database 26 storing payment data
And a borrowing database 28 for storing borrowing data.

The payment database 28 has individual order data 2 including the payment amount and the payment due date generated by the purchasing activity.
1. Stored is individual research and development data 23 including a payment amount and a payment due date generated by research and development activities, and necessary expense data 25 such as personnel expenses including a payment amount and a payment due date.

In this embodiment, the payment term file 2 is used.
2 is payment terms agreed in advance between customers such as customers and suppliers and the company itself, for example, payment closing date, payment month, payment date (20 days closing, next month, 25 days payment, etc.) ,
The payment conditions such as conditions for bill payment (how much of the total amount is bill payment, etc.) and bill calculation date (settlement date) are stored. This payment condition is for customers (customers,
It has been agreed with the supplier, and either the payment terms of the other party or the payment terms of the company are followed. Further, a procedure (program) for calculating the repayment amount based on the repayment condition for borrowing is prepared as an interest rate calculation file 20. This interest rate calculation file 20
Is a commonly used interest rate calculation package software. You can also simulate the repayment amount by selecting the interest rate calculation file 20 from the option menu and inputting various borrowing amounts and repayment conditions. Is.

Order data, order data, research and development data, and necessary expense data generated in daily work are input to the management support apparatus 10 at any time by a person in charge of work.
At that time, the payment condition file 22 and the interest rate calculation file 20 are referred to as necessary, and the total order amount, the total order amount, the loan amount, etc. in the individual data are the payment amount, the payment date, the income amount, the income date, the repayment date, the repayment date. And is accumulated in each database together with the total amount. For example, when inputting order data, the payment condition file 22 is referred to, and the order amount (including bills) is decomposed into the income amount and the income date according to the payment condition of the corresponding customer, and as individual order data in the income database 24. Accumulated. Similarly, when inputting the order data, the payment condition file 22 is referred to,
According to the payment conditions of the corresponding customer (partitioner), the order amount (including the bill) is decomposed into the payment amount and the due date, and stored in the payment database 26 as individual order data.

When inputting the borrowing data, the interest rate calculation file 20 is referred to, the repayment amount on each repayment date is calculated according to the repayment conditions entered together with the borrowing amount and the borrowing date, and the individual borrowing is made in the borrowing database 28. Data is accumulated as payment data, and the borrowing amount is stored in the borrowing database 28 as income of the individual borrowing data based on the borrowing date. FIG. 2 is a system configuration diagram of a management support system 11 configured as a server and a client type system in which the management support device 10 of this embodiment is connected, and the management support device 10 of FIG. 1 functions as a server. , Each of the clients 15 and 15 ′ is connected to the server 10 via the network. A client program centering on input and output functions is installed in each of the client devices 15 and 15 'to input / output data to / from the database of the server 10.

FIG. 3 is an example of a main menu screen for explaining the processing in the management support apparatus 10 according to the embodiment of the present invention. The main menu consists of six processing categories: business management, registration management, fund management, login history, options, and termination. On the main menu screen, the operator clicks each menu item button that he wants to process, Transit to Detail Menu screen of processing category.

FIG. 4 is a menu configuration diagram showing a tree-like relationship between the processing menu screens of the respective layers transitioning from the main menu of FIG. The business management process consists of four processes: business (income), outsourcing (payment), and research and development. The registration management process consists of two processes, business-related and fund-related, and business-related processes. In addition, customer input,
It is composed of each process of supplier input, and similarly, the fund-related process is further composed of each process of borrower input, balance input, user input, and display name change.

The cash management process is composed of four processes of borrowing, required expenses, cash flow list and profit and loss list. The cash flow list process is further composed of three processes of graph, 10-day unit total and monthly unit total. Has been done. The processing for totaling every 10 days is further composed of each processing of the whole list and the bill list, and the processing for totaling every January is further composed of each processing of the whole list, the serial number list, the customer list and the bill list. . The optional process is composed of three processes: password management, interest rate tool, and version information. Further, on each processing menu screen, by clicking the "return" processing button, it is possible to return to the menu screen of the layer one step higher.

First, the main menu registration management processing will be described. FIG. 5 is a diagram showing an example of a customer input processing screen, (A) shows a customer list display screen, and (B) shows a customer information screen. On the main menu screen of Figure 3,
Select the registration management process, select the business-related item on the next selection screen (not shown), and select the customer input on the next selection screen (not shown) to display the customer list in FIG. 5 (A). To be done. This list includes payment terms for each customer, that is, payment deadline, payment month, and payment date (closed on 20th, next month, 25
Daily payments), conditions for bill payments (such as the ratio of bill payments when the transaction amount exceeds a certain amount), and bill calculation date (settlement date).

When a payment condition for a new customer is added, clicking the new button displays the customer information screen of FIG. 5 (B). The customer information screen is composed of the customer name and the input fields for the closing date, payment month, payment date, and bill reckoning date. By inputting data in each input field and clicking the register button, the payment condition file 2
In 2, the payment conditions of the new customer are stored.

To modify the payment conditions of a customer who has already accumulated, click the target customer on the customer list screen to select it and click the Modify button to display the customer on the customer information screen. The payment terms of are displayed. If you click the register button after correcting the data displayed on this screen, for example, if you want to correct the closing date, edit the data displayed in the input field of the closing date, and click the register button Will be fixed. To delete the accumulated payment terms of the customer, click the target customer on the customer list screen to select it, and then click the delete button. As a result, the payment condition data of the customer is deleted from the payment condition file 22.

The screen configuration of the supplier input in the business-related processing is the same as the processing screen of the customer input described above, and the payment conditions for the supplier input here are also stored in the payment condition file 22. To be done. The processing for correcting and deleting payment conditions is the same as the processing for customer input.

In the registration management process, when a fund-related item is selected on the selection screen (not shown) displayed next, and the borrower input is also clicked on the selection screen (not shown),
The borrower list screen of FIG. 6A is displayed, and a list of borrowers is displayed. To enter a new borrower, click the new button on this screen
When the borrower information screen of (B) is displayed and the borrower name is input and the registration button is clicked, the new borrower input is completed. The processing of correcting and deleting the borrower is the same as the processing of the customer input.

Although illustration of an input screen example is omitted below, in the income and expenditure input in the processing related to funds, the management support apparatus 1
0 users can enter the items related to the balance that they use independently as the balance items, and in the user input, this management support device such as user name, password, user authority (whether to allow menu processing) An input process for registering 10 users can be performed. Further, in the process of changing the display name, it is possible to input to change the screen name displayed on the menu screen, which can be customized by the user of the apparatus.

Next, the work management process of the main menu will be described. FIG. 7 is a diagram showing an example of a business (income) processing screen, where (A) shows an order list display screen and (B) shows a business information screen. When a business management process is selected on the main menu screen of FIG. 3 and a business (income) process is selected on a selection screen (not shown) displayed next,
The order list screen of (A) is displayed. In this list, an outline of each order item, such as the serial number, customer name, subject, delivery date, total order amount, user name (person in charge of business) for each order item, is displayed.

When inputting data of a new order item,
When the new button is clicked, the business information screen shown in FIG. 7B is displayed. The business information screen shows the serial number, customer name, subject, work content, quotation number, estimated amount, man-hour, unit price, user name, delivery date, total order amount, number of divisions, billing date, division amount, receipt date. It is composed of input fields such as date, bill, unfinished sales date and amount, etc. By inputting the required order data in each input field and clicking the register button, the data for each order item is stored in the income database 24. Remembered.

At the time of this input, the payment condition file 22
Is referred to, the payment conditions of the customer of the order case are read out, and the total amount of the order is decomposed into the income amount and the income date, and the data is automatically input. In addition to cash income, if the bill has a check (the bill column on the business information screen), the amount (income amount) and the date when the bill can be cashed (settlement date) are also referred to the payment terms of the payment term file 22. Automatically entered.

For example, in addition to inputting the customer name and other necessary items, the total amount of other orders is also input, and in the case of a lump sum payment (income) by cash, 1 is input for the number of divisions and the billing date for which billing is scheduled. When you enter the date and the amount of payment, the receipt date (payment date) is automatically calculated based on the payment conditions of the customer, that is, the closing date, payment month, and payment date information.
Is entered. In this case, the check is not entered in the bill input field.

If the bill is to be collectively paid, a check is entered in the bill input field. When a check is entered in this field, the settlement date (cashable date) of the bill of receipt is automatically entered based on the information of the billing date of the payment condition.

If there are installment payments, enter the number of installments, enter each installment amount and the billing date, and automatically calculate the receipt date for each installment as in the case of cash lump sum payment. Is input. This is also the case when there is a combination with bills, and the cash due date (year / month / day) is automatically entered for each bill. When the registration button is clicked after the above input is completed, new individual order data is stored in the income database 24.

If the transaction of the ordered item extends over the settlement period, the total amount of orders is divided and entered in the fields of the date and amount of unfinished sales, so that the revenue before the settlement period for the relevant settlement period. And, it can be divided into income after the fiscal year. For example, income can be distributed by inputting a total order amount of 30 million yen in the field of unsold sales as April 30, 20 million yen, May 30, 10 million yen.

To correct the contents of the individual order data that has already been accumulated, click the target item on the order list screen to select it, and click the correction button.
The order data of the relevant order item is displayed on the business information screen. If you change the payment method of the order amount from cash lump sum payment to installment payment, you can enter the correct number of installments, installment amount, billing date, and the date of receipt of each installment payment amount. The day is calculated and input in the corresponding input field. Then, when the registration button is clicked, the corresponding individual order data in the income database 24 is corrected. To delete the data of the accumulated order matter, click the target order matter on the order list screen to select it, and then click the delete button. As a result, the individual order data of the corresponding order case is deleted from the income database 24.

FIG. 8 shows outsourcing (payment) in business management processing.
9A and 9B are views showing an example of the processing screen of FIG. 8, FIG. 8A shows an order list display screen, and FIG. 8B shows an outsourcing information screen. In the main menu screen of Fig. 3, select the task management process,
When an outsourcing (payment) process is selected on the selection screen (not shown) displayed next, the order list screen of FIG. 8A is displayed. On this screen, an outline of each ordering item such as product number, supplier name, order contents, delivery date, order total amount, user (person in charge) name, etc. is displayed.

When inputting new order data, when the new button is clicked, a product number selection screen (not shown) is displayed. On the product number selection screen, the same contents as the order list screen are displayed, but in the case of new order data, only the product number is entered, the other data fields are blank, and the relevant product number is selected. Then, the subcontract information screen of FIG. 8B is displayed. In the present embodiment, the ordering business and the research and development business register the serial number, and the subsequent management is performed based on the serial number. The processing for registering the serial number is required prior to inputting individual order data. However, when the management by the product number is not performed, the product number selection screen (not shown) is omitted, and FIG.
It is also possible to take a mode of making a direct transition to the subcontract information screen.

The subcontracting information screen displays the serial number, supplier name, order contents, work contents, user name, delivery date, total order amount, number of divisions, billing date, division amount, receipt date, bills, unfinished work. It consists of input fields such as date of entry and amount,
Enter the required order data in each entry field and click the register button to complete the payment database 26
The data for each order item is stored in.

At the time of this input, the payment condition file 22
Is referred to, the payment terms agreed with the supplier (customer) of the order item (generally the payment terms of the company in general) are read, and the total order amount is the payment amount. It is disassembled on the payment date and data is automatically input. In addition to payment by cash, if there is a check on the bill (the bill column of the outsourcing information screen), the amount and the date (settlement date) when the bill is cashed are also automatically input from the payment conditions of the payment condition file 22. This process is similar to the above-mentioned order (income) process.

For example, in addition to inputting required items such as the supplier name, the total amount of other orders is input, and in the case of a single payment (income) by cash, 1 is input for the number of divisions and the billing year to be billed. When you enter the date and the amount of payment, the payment date (withdrawal date) is automatically calculated and input based on the payment conditions of the customer, that is, the closing date, payment month, and payment date information. . In this case, the check is not entered in the bill input field.

If the bill is to be collectively paid, a check is entered in the bill input field. If a check is entered in this field, the settlement date (deduction date) of the relevant bill will be calculated based on the billing date information in the payment terms.
Is automatically entered.

If there are installment payments, enter the number of installments, enter each installment amount and billing date, and automatically calculate the installment date of each installment as in the case of cash lump sum payment. Is input. The same applies when there is a combination with bills, and the due date (year, month, and day) as cash is automatically entered for each of cash and bills. When the registration button is clicked after the above input is completed, new individual order data is accumulated in the payment database 26.

If the transaction of the ordered item extends over the settlement period, the total amount of the order is divided and entered in the fields of the date and amount of unfinished purchase, so that It can be divided into payment and payment after the accounting period. For example, an order total of 5 million yen is placed in the field of unfinished purchase on April 30, 2.5 million yen, May 30, 250
You can sort payments by entering 10,000 yen.

By processing the uncompleted purchase and the unsold sales of the above-mentioned order (income), income and payment due to transactions over the settlement period are distributed and processed before and after the settlement period in the daily business input. This makes it possible to understand profit and loss more closely. Also, the processing of the order data described above,
Further, in order data processing, in order to facilitate management of bills of exchange and bills of payment, the date of receipt of bills of order data and the date of issue of bills of order data may be input.

To modify the contents of the individual order data that has already been accumulated, click the target item on the order list screen to select it, and click the modify button.
The data of the relevant order item is displayed on the outsourcing information screen. If you change the payment method for the order amount from the one-time payment in cash to the installment payment,
When the number of times of division, the amount of payment, and the billing date are corrected and input, the payment date of each amount of installment payment is calculated and input into the corresponding input field. Then, when the registration button is clicked, the corresponding individual order data in the payment database 26 is corrected. To delete the accumulated order item data, click the target order item on the order list screen to select it, and then click the delete button. As a result, the individual order data of the relevant order case is deleted from the payment database 26.

Another process in the process of business management is the process of inputting the cost (payment) related to research and development of products etc. The menu structure and screen structure of this process are business (income), outsourcing (payment). Although it is essentially the same as the processing screen of 1. and the detailed description thereof is omitted, the research and development data such as the payment amount and the payment date of the research and development cost input according to the processing screen is accumulated in the payment database 26. Generally, the costs incurred in research and development are reflected in the ordering data and are not directly related to cash flow or profit or loss, but this data can be used for management purposes such as profit and loss management for each research and development.

Next, the fund management process of the main menu will be described. FIG. 9 is a diagram showing an example of a borrowing processing screen, (A) shows a borrowing list display screen, and (B) shows a borrowing information screen. In the main menu screen shown in FIG. 3, when a fund management process is selected and a borrowing process is selected on a selection screen (not shown) displayed next, a borrowing list shown in FIG. 9A is displayed. On this screen, an outline of each borrowing project, such as the name of the borrower, the date of borrowing, the total amount of borrowing, and remarks, is displayed.

When inputting new borrowing data, clicking the new button displays the borrowing information screen of FIG. 9 (B). The borrowing information screen is composed of input fields such as borrower name, remarks, subject, repayment method, interest rate, total amount of loan, borrowing date, repayment start date, number of repayments, and the required borrowing data in each input field. input.

On the other hand, at the time of this input, the interest rate calculation file 20 is referred to, and from the repayment conditions of the borrowing project, that is, the repayment method of repayment of principal and interest or repayment of principal and principal, interest rate, number of repayments, and repayment start date, Each repayment date and repayment amount are calculated and displayed as a repayment list in the field 9a. Then, by clicking the register button, the repayment amount and the repayment date data are accumulated in the borrowing database 28 as individual repayment data (payment), and
The above-mentioned borrowing amount and borrowing date data are stored in the borrowing database 28 as individual borrowing data (income). It should be noted that the field 9a may be configured to display the remaining bonds or the repayment amount as a graph together with the repayment list.

To modify the repayment conditions of already accumulated loan data, click the target loan item on the loan list screen to select it, and click the Modify button to display the corresponding loan item on the loan information screen. The data is displayed. In the case of modifying the location of data to be modified on this screen, for example, the number of repayments, the data displayed in the corresponding input field is modified. When inputting this correction, the interest rate calculation file 20 is referred to, the repayment date and the repayment amount are recalculated, and the individual repayment data in the loan database 28 is corrected by clicking the register button, as in the case of entering a new project. To be done. To delete the accumulated loan item data, click the target loan item on the loan list screen to select it, and then click the Delete button. Accordingly, the borrowing data of the corresponding borrowing case, that is, the repayment date, and the repayment amount, the borrowing amount, the borrowing date, and the like are deleted from the borrowing database 28.

As another process in the fund management process,
There are processing of necessary expenses (payments) related to personnel expenses, consumption tax, corporate tax, bonuses, general expenses, etc. The menu structure and screen structure of this process are essentially the same as the business (income), outsourcing (payment), and research and development process screens, and detailed explanations are omitted, but expenses related to the necessary costs input according to the process screens. The required expense data such as the payment amount and the payment date are stored in the payment database 26. When inputting these expenses, in order to simplify the input, it is possible to use a moving average value for each item. Further, when the management support apparatus 10 is initially introduced, it is necessary to input a carry-forward money. In this case, the subject is entered as the carry-over amount.

As described above, the income (ordering, borrowing) and payment (ordering, R & D, necessary expenses, loan repayment) generated in daily work are the management support apparatus 10 for each case.
, The payment condition file 22 and the interest rate calculation file 20 are referred to as necessary, the income amount and the income date, the payment amount and the payment date are calculated, and stored in the income database 24, the payment database 26, and the borrowing database 28. It

Next, the processing procedure of the cash flow list and the profit and loss list in the cash management process will be described. When you select Cash Management on the main menu of Fig. 3 and select Cash Management List on the next menu screen (not shown), a screen (not shown) for inputting the aggregation unit (aggregation period), output format selection, and focus period Is displayed. The eye-gaze period is to enter the period from the start to the end, and the date to start counting from the date to start ending is input. In the present embodiment, it is possible to perform aggregation for several years from the date when the aggregation is started.
The total unit can be selected in units of 10 days or one month within the focus period, and the output format can be selected from tabular display and graph display. If the output format is not specified, the table format will be displayed. These display results can be printed out by using the print function.

FIG. 10 is a flow chart showing the procedure for totaling cash flow. For example, when the totalization style is entered in the unit of one month from the current point of view in step S11, the income database is calculated in step S12. From the data of 24, the monthly income amount within the period is totaled, and the order data 21 and the research and development data 2 of the payment database 26 are calculated in steps S13 to S15.
3. From the required expense data 25, the monthly payment amount within the period is totaled. Next, in step S16, the amount of income and the amount of payment for each month within the period are totalized from the borrowing data and the repayment data of the borrowing database 28.

When these tabulations are completed, step S1
In step 7, the total cash flow before the focus period is calculated, and the totalized results are displayed as the total fund list in FIG. 11. That is, in FIG. 11, 101 is order data (income), 102 is outsourced data (payment), 103 is R & D data (payment), 104 is borrowing data (income), 1
Reference numeral 05 is repayment data (payment), 106 is individual data of required expense data (payment), and the aggregate value for each month is 1
It is displayed in the total income and total payment of 07. Then, in step S19, the cash flow transition for each month within the period is displayed in the cash flow column of 107 in FIG. 11 based on the total cash flow before the focus period (step S17).

The procedure for processing the profit and loss list is also the same. If you select cash management in the main menu of FIG. 3 and select the profit and loss list in the next menu screen (not shown), the aggregation format and output format are selected and the focus period is A screen (not shown) for inputting is displayed.

FIG. 12 is a flow chart showing the procedure for totalizing profits and losses. For example, in step S21,
When the aggregation unit of the unit of one month is entered from the current point of view for one year, in step S22, the income database 2
Monthly income within the period is aggregated from the data in 4. At this time, if there is uncompleted sales, the amount of income is totaled. Then, in step S23, the payment database 26
From, the monthly payments within the period are aggregated. At this time, if there are uncompleted purchases, the amount of payment will be totaled. In step S24, the required expense data 2 of the payment database 26
The monthly payments from 5 onward are summed up. Then, in step S25, the respective aggregation results are shown in FIG.
It is displayed as a profit and loss list of 3. That is, in FIG. 13, 301 is order data (income), 302 is outsourced data (payment), and 304 is individual data of necessary expense data (payment). In this list, research and development data 303
However, as mentioned above, this R & D data can be omitted regardless of profit or loss.

Input of the eye-gaze period in steps S11 and S21,
By specifying the graph display when selecting the total unit, it is possible to display the total result of the cash flow and the profit and loss in the graph. FIG. 14: is a figure which shows an example which carried out the graph display of the total result of cash flow. In the graph of FIG. 14, the horizontal axis represents the eye-focused period of one year in a unit of counting every month,
The vertical axis represents funds (unit is money). The graph in FIG. 14 is
If the situation remains unchanged, it indicates that there is a risk of a cash shortage in August and September 2002.
Therefore, the manager and the financial manager can easily understand the risk of a cash shortage and can take measures in advance.

In the above description, the case where the whole list is selected when the unit of counting is specified is explained. However, in addition to the whole list in the 10-day counting, the bill list can be specified, and in the 1-month counting, In addition to the whole list, you can count the product number list, customer list, and bill list.

Further, in the log-in history of the main menu (FIG. 3), it is possible to store, as history information, the process performed by each user logging on to the management support apparatus 10 and the process date, and the option process of the main menu can be accumulated. (Figure 3)
If you select the password management of, you can manage the password registration and change of each user, and if you select the interest rate tool, you can use the interest rate calculation file 20 to perform the repayment simulation at the time of borrowing described above and select the version information. The software version information of the management support apparatus can be referred to.

In the processing of the user input of the option of the main menu, the processing authority for each menu of the management support apparatus can be set and managed for each user. For example, a user with level 1 authority has processing authority for all functions, and a user with level 2 can use the task related in the task management in general and registration management.
Having the authority to edit the contents of the work management entered by other users, level 3 users can use the work related in the general work management and registration management.
He has the authority to edit the contents of the business management entered by himself, and can only refer to the contents of the business management entered by other users.

Therefore, level 1 users are executives,
Level 2 users can be assigned to managers such as department managers and section managers, and level 3 users can be assigned to project leaders.

[0060]

As described above, the management support apparatus of the present invention has a payment condition file storing payment conditions for each customer and an interest rate calculation file, and the order data input from the input means and the payment. Individual income data including an income amount and an income date is stored in an income database based on the condition file, and the payment amount and the due date are included based on the order data input from the input means and the payment condition file. Store individual payment data in the payment database,
A borrowing amount, a borrowing date, input from the input means, and
Based on the repayment condition and the interest rate calculation file, the borrowing amount and the borrowing date are stored as income, and the repayment amount and the repayment date are stored in the borrowing database.

Then, based on the eye-gaze period and the total unit input from the input means, the control means causes the total income amount of the income database and the borrowing database for each total unit in the eye-gaze period, and the payment. The total amount of payment of the database and the borrowing database is totaled, and the difference between the total amount of income and the total amount of payment is output as cash management data to the output means.

Therefore, information on income, payments, and dates that are routinely generated in business management are sequentially accumulated in a database by a simple computer operation, and the cash flow and profit / loss status for each certain period from the present to the future are calculated. It is possible to provide it immediately.

[Brief description of drawings]

FIG. 1 is a schematic configuration diagram of a management support apparatus according to an embodiment of the present invention.

FIG. 2 is a system configuration diagram of a management support system according to the present invention.

FIG. 3 is a screen configuration diagram showing a main menu of the management support apparatus.

FIG. 4 is a menu configuration diagram showing a tree of a processing menu of the management support apparatus.

FIG. 5 is a screen configuration diagram showing a customer input process,
(A) shows a customer list screen, (B) shows a customer information screen.

FIG. 6 is a screen configuration diagram showing a process of inputting a borrower,
(A) shows a borrower list screen, (B) shows a borrower information screen.

7A and 7B are screen configuration diagrams showing work (income) processing, in which (A) shows an order list screen and (B) shows a work information screen.

8A and 8B are screen configuration diagrams showing an outsourcing (payment) process, in which (A) shows an order list screen and (B) shows an outsourcing information screen.

FIG. 9 is a screen configuration diagram showing a borrowing process, (A)
Shows a borrowing list screen, and (B) shows a borrowing information screen.

FIG. 10 is a flowchart showing a processing procedure for calculating a cash flow.

FIG. 11 is a screen configuration diagram showing a configuration of an entire fund list screen in a cash management process.

FIG. 12 is a flowchart showing a processing procedure for calculating profit and loss.

FIG. 13 is a screen configuration diagram showing a configuration of a profit and loss list screen in processing of profit and loss.

FIG. 14 is a graph showing a cash flow calculation result in cash flow processing.

[Explanation of symbols]

10 ... Management support device 12 ... Recording medium 13 ... Control means 14 ... Operation unit 16 ... Input means 18 ... Output means 20 ... Interest rate calculation file 22 ... Payment terms file 24 ... Income database 26 ... Payment database 28 ... Borrowing database 21 ... Order data 23 ... R & D data 25 ... Required expense data 11 ... Management support system 15 ... Client device

Claims (8)

[Claims] 1. An input unit, an output unit, a control unit including a calculation unit, a payment condition file storing payment conditions for each customer, an interest rate calculation file, an income database storing income data, and payment. A payment database that stores data, and a borrowing database that stores borrowing data. Based on the order data input from the input means and the payment condition file, the individual income data including the income amount and the income date is described above. Individual payment data, which is stored in an income database and includes a payment amount and a due date, is stored in the payment database based on the order data and the payment condition file input from the input means, and is input from the input means. Borrowing amount, borrowing date, and
Based on the repayment conditions and the interest rate calculation file, borrowed amount and borrowed date as income, repayment amount and repayment date as payment, stored in the borrowed database, and the focus period and the aggregation unit input from the input means. Based on the above, the control means, for each aggregation unit in the eye-gaze period, aggregates all the income amounts of the income database and the borrowing database, and the total payment amounts of the payment database and the borrowing database to obtain the total income amount and the total income amount. A management support device which outputs the difference from the payment amount to the output means as cash flow data. 2. The management support apparatus according to claim 1, wherein the individual payment data includes ordering data, research and development data, and necessary expense data. 3. The total amount of income of the income database is calculated for each of the designated eye-gaze period and the unit of aggregation in the eye-gaze period, the total amount of payment of the payment database is calculated, and the total amount of income and the total amount of payment are calculated. The management support apparatus according to claim 1, wherein the difference is calculated and output as profit and loss data. 4. The income amount, the income date, the payment amount, and the payment date in the order data and the order data are the income amount and the income date before and after the closing period according to the company's closing period. 2. The management support apparatus according to claim 1, wherein the payment amount and the payment date are decomposed and can be input. 5. A step of storing at least a payment condition for each customer in a payment condition file, and based on the payment condition for each customer stored in the payment condition file, the income amount in the order data, Storing the payment amount in the order data together with the due date in the payment database based on the payment condition for each customer stored in the payment condition file, together with the due date, the input means Borrowing amount, borrowing date, and
Based on the repayment conditions and the interest rate calculation file, a step of storing the borrowed amount and the borrowed date as income, and the repayment amount and the repayment date as payment, in the borrowing database, a designated eye-gaze period, and the eye-growth period. A step of calculating the total income amount from the income database and the borrowing database for each aggregation unit, a designated eye-gaze period, and the payment database and the borrowing database with respect to each aggregated unit in the eye-gaze period. From the above, a management support method comprising a step of calculating the total amount of payment and a step of calculating the difference between the total amount of income and the total amount of payment as cash-flow data for each aggregation unit and outputting the cash-flow data. 6. The step of calculating the total amount of income of the income database for each of the designated eye-gaze period and each aggregation unit in the eye-gaze period, the designated eye-gaze period, and each aggregation unit in the eye-gaze period, 6. The method according to claim 5, further comprising: a step of calculating a total payment amount of the payment database; and a step of calculating a difference between the total income amount and the total payment amount as profit and loss data for each aggregation unit, and outputting the profit and loss data. Management support method. 7. The amount of income in the order data for each customer based on at least the process of storing the payment terms for each customer in the payment term file and the payment term for each customer stored in the payment term file. Is stored in the income database together with the income date, and based on the payment condition for each customer stored in the payment condition file, the payment amount in the order data for each customer is stored in the payment database together with the payment date. A process of storing, a borrowing amount input from the input means, a borrowing date, and
Based on the repayment conditions and the interest rate calculation file, the borrowing amount and borrowing date as income, the repayment amount and repayment date as payment, the process of storing in the borrowing database, and the payment amount and payment date in the necessary expense data A process of storing in the payment database, a designated eye-gaze period, a process of calculating the total income amount from the income database and the borrowing database for each aggregation unit in the eye-gaze period, and a designated eye-gaze period. , Processing for calculating the total payment amount from the payment database and the borrowing database for each aggregation unit in the focus period, and the difference between the total income amount and the total payment amount for each aggregation unit as cash flow data. A computer-readable recording of a program for causing a computer to execute the process of calculating and outputting. Recording medium. 8. The recording medium further includes a designated eye-gaze period, a process of calculating the total income of the income database for each aggregation unit in the eye-gaze period, a designated eye-gaze period, and the eye-gaze period. To cause a computer to perform a process of calculating the total payment amount of the payment database for each aggregation unit, and a process of calculating the difference between the total income amount and the total payment amount as profit and loss data for each aggregation unit and outputting the profit and loss data The computer-readable recording medium according to claim 7, wherein the program is recorded.