JP2004272304A - Borrowing data creation device and borrowing data creation program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a borrowing data creation device and borrowing data creation program enabling even a person having no accounting special knowledge to rapidly and easily calculate a cash flow and create three table of borrowing in a consistent manner. <P>SOLUTION: This borrowing data creation device automatically creates a sales list and a credit list from sales estimate data, a buying list and a payment list from buying estimate data, a schedule of other credits for a credit other than sales and borrowing, a payment table of expense and others for a payment other than buying or repayment, and a repayment schedule for borrowing. This device automatically creates an account book by bank from the credit list, the payment list, the schedule of other credits, the payment table of expense and others, and the repayment schedule. This device automatically creates a total account table from the account book by bank. This device automatically creates a cash flow table from the total account table. This device further automatically creates a bank transaction state table displaying, by bank, the bill discount balance, short-term borrowing balance, long-term borrowing balance, and the deposit balance. <P>COPYRIGHT: (C)2004,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a borrowed material creation device and a borrowed material creation program, and more particularly, to a borrowed material creation device and a borrowed material creation program that can be easily created by a person without accounting expertise.
[0002]
[Prior art]
In general, funding is a very important issue for business owners.
Therefore, data processing related to cash flow is performed as an important task of corporate accounting.
[0003]
However, data processing relating to cash flow is not inherently performed by anyone due to its nature, and conventionally, only persons in charge of accounting expertise of a certain degree or more were able to perform data processing. Therefore, it has been desired to realize a system that enables even those who do not have such specialized knowledge to easily perform data processing related to cash flow.
[0004]
Therefore, a fund-raising processing system has been developed that can automatically create fund-raising-related data such as a funding record table and a fund balance table based on daily journalizing operations (see Patent Document 1).
[0005]
In addition, there is also a system in which the slip information for financial statements and the slip information for cash flow are distinguished by a fund code so that input processing can be performed on both at once (see Patent Documents 2 and 3). .
[0006]
[Patent Document 1]
JP-A-11-120227
[Patent Document 2]
JP 2000-36001 A
[Patent Document 3]
JP 2001-76064 A
[0007]
[Problems to be solved by the invention]
However, the above-mentioned conventional cash-flow system is not for cash-flow, but is only an appendix of accounting.
[0008]
In other words, the funding schedule should be a means to solve various business issues by using the information obtained from the forecast in the long term. However, even with the above-mentioned conventional cash flow system, in fact, much effort is required to create the cash flow schedule, and the creation itself is likely to be the purpose.
[0009]
In addition, according to the above-mentioned conventional cash flow system, materials submitted in connection with bank borrowing, that is, three borrowing tables (fund table, bank transaction status, sales list (order details) (order details)) are individually stored. Therefore, it is difficult to ensure consistency among the three parties.
[0010]
The present invention has been made in view of the above-mentioned problems, and allows a person without accounting expertise to quickly and easily calculate a cash flow and to prepare a borrowing material that can consistently prepare three borrowing tables. It is intended to provide a device and a borrowed material preparation program.
[0011]
[Means for Solving the Problems]
In order to achieve the above object, according to the first aspect of the present invention, the borrowing material creation device includes: a sales forecast data, a purchase expectancy data, a payment expectation data other than sales / borrowings, and a purchase / borrowing schedule. When the expected withdrawal data other than repayment and the expected repayment of borrowed money are input, the income and expenditure are classified into predetermined items, the amounts are totaled, and a cash flow table is automatically created in a single table. It has a function.
[0012]
According to the second aspect of the present invention, the borrowed material creating apparatus further has a function of automatically creating a sales list showing order details when sales expected data is input. It is characterized by having.
[0013]
According to the third aspect of the present invention, the borrowing material creating apparatus has a function of automatically creating a deposit list showing the actual and / or expected deposit amounts for each sales destination for each sales month based on the sales list. The borrowed material creating apparatus according to claim 2 further comprises:
[0014]
According to the invention described in claim 4, the borrowing material creating apparatus further has a function of automatically creating a purchase list showing order details when expected purchase data is input. Borrowed material creation device.
[0015]
According to the fifth aspect of the present invention, the borrowing material creating device automatically creates a payment list showing payment results and / or scheduled payment amounts for each supplier for each payment month based on the purchase list. The borrowed material creating apparatus according to any one of claims 1 to 4, further having a function of performing a borrowed material.
[0016]
According to the sixth aspect of the present invention, the borrowed material creating apparatus further has a function of automatically creating a note book showing a list of bills to be received when receiving the sales price in the form of bills. Characterized in that it is the borrowed material creation device described in the section.
[0017]
According to the invention described in claim 7, the borrowed material creating apparatus further has a function of automatically creating a bill of exchange showing a list of bills to be paid when paying the purchase price by bill. It is the borrowed material creation device described in Item 1.
[0018]
According to the eighth aspect of the invention, the borrowing material creating apparatus further has a function of automatically creating other deposit schedules showing at least the deposit date and the deposit amount for each deposit source for deposits other than sales and borrowings. A borrowed material creating apparatus according to any one of claims 1 to 7.
[0019]
According to the ninth aspect of the present invention, the borrowing material creating apparatus automatically creates an expense or other payment table showing at least a withdrawal date and a withdrawal amount for each item for withdrawals other than purchase / borrowing repayments. The borrowed material creating device according to any one of claims 1 to 8, further having a function.
[0020]
According to the tenth aspect of the present invention, the borrowing material creating device further has a function of automatically creating a borrowing list showing at least the borrowing balance for each borrowing date and / or for each borrower. 9. The borrowed material creating apparatus according to any one of items 1 to 9, characterized in that:
[0021]
According to the eleventh aspect of the present invention, the borrowing material creating apparatus automatically creates a borrowing repayment schedule indicating at least a borrowing balance and a repayment date for each borrowing date and / or each borrower. The borrowed material creating apparatus according to any one of claims 1 to 10, further comprising:
[0022]
According to the twelfth aspect of the present invention, the borrowing material creating device includes: a deposit list, a payment list, a note book, a bill payable, other payment schedules, expenses and other payment tables, and repayment of borrowings. 12. The borrowing material creating device according to claim 11, further comprising a function of automatically creating a bank account book showing at least a deposit amount and a withdrawal amount in chronological order for each bank based on the schedule. Is what you do.
[0023]
According to the invention described in claim 13, the borrowing material creating apparatus further has a function of automatically creating a total balance table showing at least the amount of money received from the bank and the amount of money to be paid to the bank in chronological order based on the bank account book. A borrowed material creating apparatus according to claim 12 having the above features.
[0024]
According to the fourteenth aspect of the present invention, the borrowing material creating device is a borrowing material creating device according to the thirteenth aspect, which has a function of automatically creating a fund schedule based on a total accounting table. .
[0025]
According to the invention described in claim 15, the borrowing material creating apparatus further has a function of automatically creating at least a bank transaction status table showing a discounted bill balance, a short-term borrowing balance, a long-term borrowing balance, and a deposit balance for each bank. Item 15 is a borrowed material creating apparatus according to any one of Items 1 to 14.
[0026]
According to the invention as set forth in claim 16, the borrowing material creation program comprises: sales prospect data, purchase prospect data, deposit prospect data other than sales / borrowing, withdrawal prospect data other than purchase / borrow repayment, When borrowed debt repayment expected data is entered, the computer realizes the function of classifying the income and expenditure into predetermined items, summing up the amounts, and automatically creating a consolidated financial statement in a single table It is assumed that.
[0027]
According to the seventeenth aspect of the present invention, the borrowing material creation program causes a computer to realize a function of automatically creating a sales list showing an order receipt when the sales forecast data is input. It is a creation program.
[0028]
According to the eighteenth aspect of the invention, the borrowing material creation program has a function of automatically creating a deposit list showing the actual and / or expected payments for each sales destination for each sales month based on the sales list. A borrowed material creating program according to claim 16 or 17, which is realized by a computer.
[0029]
According to the nineteenth aspect of the present invention, the borrowing material creation program causes a computer to implement a function of automatically creating a purchase list showing order details when expected purchase data is input. 18. The borrowed material creating program described in 18.
[0030]
According to the twentieth aspect, the borrowing material creating program automatically creates a payment list showing payment results and / or scheduled payment amounts for each supplier for each payment month based on the purchase list. A borrowed material creating program according to any one of claims 16 to 19, wherein the borrowed material creating program causes a computer to realize the function.
[0031]
According to the twenty-first aspect of the present invention, the borrowed material creation program causes a computer to realize a function of automatically creating a note book showing a list of bills to be received when receiving a sales bill in the form of a bill. Or the borrowing material creation program according to item 1.
[0032]
According to the invention described in claim 22, the borrowing material creating program causes the computer to realize a function of automatically creating a bill of exchange showing a list of bills to be paid when paying the purchase price by bill. A borrowed material creation program according to any one of the preceding claims.
[0033]
According to the twenty-third aspect of the invention, the borrowing material creating program provides the computer with a function of automatically creating at least a deposit schedule showing at least a deposit date and a deposit amount for each deposit source for deposits other than sales and borrowings. A borrowed material creating program according to any one of claims 16 to 22 to be realized.
[0034]
According to the invention described in claim 24, the borrowing material creation program automatically creates an expense or other payment table showing at least a withdrawal date and a withdrawal amount for each subject for withdrawals other than purchase and repayment. A borrowed material creating program according to any one of claims 16 to 23, wherein the borrowed material creating program causes a computer to realize the function.
[0035]
According to the invention described in claim 25, the borrowing material creation program causes the computer to realize a function of automatically creating a borrowing list showing at least the borrowing balance for each borrowing date and / or each borrower. A borrowed material creating program according to any one of Items 16 to 24.
[0036]
According to the invention described in claim 26, the borrowing material creating program automatically creates a borrowing repayment schedule indicating at least the borrowing balance and the expected repayment date for each borrowing date and / or each borrower. 26. A borrowed material creating program according to claim 16, wherein the borrowed material creating program is realized by a computer.
[0037]
According to the invention described in claim 27, the borrowing material preparation program comprises: a payment list, a payment list, a note book, a payment note book, other payment schedules, expenses and other payment tables, and repayment of borrowings. 27. The borrowing material creation program according to claim 26, wherein the computer realizes a function of automatically creating a bank account book showing at least a deposit amount and a withdrawal amount in chronological order for each house bank based on the schedule. It is a feature.
[0038]
According to the invention described in claim 28, the borrowing material creation program has a computer function of automatically creating a total accounting table showing at least the amount of payment from the bank and the amount of payment to the bank in chronological order based on the bank account book. A borrowed material creating program according to claim 27, wherein the borrowed material creating program is realized.
[0039]
According to the invention described in claim 29, the borrowing material creating program is a borrowing material creating program according to claim 28, which causes a computer to realize a function of automatically creating a fund schedule based on a total balance sheet. Things.
[0040]
According to the invention described in claim 30, the borrowing material creation program realizes, on a computer, a function of automatically creating a bank transaction status table showing at least a discounted bill balance, a short-term borrowing balance, a long-term borrowing balance, and a deposit balance for each bank. A borrowed material creating program according to any one of claims 16 to 29.
[0041]
BEST MODE FOR CARRYING OUT THE INVENTION
Next, an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention will be described in detail with reference to the accompanying drawings.
[0042]
FIG. 1 shows a hardware configuration diagram of an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention.
[0043]
In the figure, the borrowed material creating apparatus 100 includes a CPU 1, a ROM 2, a RAM 3, a hard disk 4, a keyboard 5, a mouse 6, a display 7, a CD-ROM drive 8, a printer 9, a bus 10, , CD-ROM 200.
[0044]
The CPU 1 controls the entire borrowed material creating apparatus 100 based on the borrowed material creating program according to the present invention.
The ROM 2 stores information such as an operation system, application programs, and tables of a database.
The RAM 3 is used as a work area of the CPU 1.
The hard disk 4, like the ROM 2, stores information such as application programs and tables of a database.
[0045]
The keyboard 5 has keys for giving operation instructions and inputting characters (including numbers and symbols).
The mouse 6 is for giving an operation instruction or pointing to a location on the display 7, and may be another pointing device.
[0046]
The display 7 displays an input information screen and a display screen of each form.
The CD-ROM drive 8 reads from and writes to the CD-ROM 200.
The printer 9 prints each form.
[0047]
The bus 10 connects the CPU 1, the ROM 2, the RAM 3, the hard disk 4, the keyboard 5, the mouse 6, the display 7, the CD-ROM drive 8, and the printer 9 as shown in the figure.
[0048]
The CD-ROM 200 is an external recording medium for recording information such as application programs and tables of a database.
Here, the CD-ROM 200 will be described as an example of the external recording medium, but the present invention is not limited to this, and may be, for example, an FD or MO. In that case, a hardware configuration in which an FD drive or an MO drive is connected to the bus 10 is further provided.
[0049]
The borrowed material creating apparatus according to the present invention has the above hardware (computer). The borrowing material creation program according to the present invention includes a funding table creation function, a sales list creation function, a payment list creation function, a purchase list creation function, a payment list creation function, a bill of exchange receipt creation function, which will be described later. , Payment note book creation function, other payment schedule creation function, expenses and other payment schedule creation function, borrowed money list creation function, borrowed money repayment schedule creation function, bank account book creation function, total account book creation function, bank transaction status The computer of the borrowing material creation device realizes a table creation function, a bank daily balance creation function, a cash accounting book creation function, and / or a journal entry book creation function.
Note that the above hardware configuration is only a typical example, and the present invention is not limited to the above configuration.
[0050]
FIG. 2 is a functional block diagram showing an embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0051]
In FIG. 1, the borrowed material creating apparatus 100 includes a data input unit 20, a data processing unit 30, a master database 31, a data storage unit 32, and a data output unit 40.
[0052]
The data input unit 20 is a means for inputting various types of accounting data. Here, estimated sales data, estimated purchase data, estimated payment data, estimated other payment data, estimated expenses and other payment data, estimated repayment of borrowed data, and the like are input in accordance with a preset input format.
[0053]
The data processing unit 30 processes data input from the data input unit 20 while accessing the master database 31 and the data storage unit 32. That is, when the various data is input from the data input unit 20, the data processing unit 30 refers to the master database 31 for necessary master data according to the input data, extracts the master data, The data processing is executed, and the processing result is stored in the data storage unit 32.
[0054]
The database 31 has master data necessary for the above-described various types of data processing, a sales list (order receipt) described later, a payment list, a bill of receivables, a purchase list, a payment list, a payment note, and other payments. A table relating to various codes and items required for various forms such as a schedule, expenses and other payments, a borrowed money list, a borrowed money repayment schedule, a bank transaction status table, and a fund schedule are stored and registered.
[0055]
The data storage unit 32 stores the result of the data processing executed by the data processing unit 30. At this time, the processing data is stored and held in the form of the various forms in which a form is set in advance, or the processing data is stored and held as a data string in which the forms can be created.
[0056]
The data output unit 40 includes a printer and a device capable of displaying or outputting data, such as a display, and based on the processing data in the data storage unit 32, according to a user's instruction, a sales list (order receipt). , Receipt list, bill of receivables, purchase list, payment list, bill of payment, other payment schedule, expenses and other payment table, borrowed money list, repayment of borrowed money, bank transaction status table, fund schedule, etc. Output and display of various forms.
[0057]
Note that the present diagram is merely a conceptual configuration, and thus the present invention is not limited to the above block diagram.
[0058]
FIG. 3 is a flowchart showing the operation (data flow) of the embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0059]
When expected sales data is input in step S1, a sales list (order receipt) is automatically created in step S2. Next, in step S3, a payment list is automatically created from the sales list (order receipt). If the sales price is to be received in the form of a note, a note (entry) book is automatically created in step S4.
[0060]
When expected purchase data is input in step S11, a purchase list is automatically created in step S12. Next, in step S13, a payment list is automatically created from the purchase list. When paying the purchase price by a bill, a bill of payment (entry) book is automatically created in step S14.
[0061]
With respect to the payment schedule other than sales and borrowing such as interest income, etc., it is input as expected other payment data (expected payment data other than sales and borrowing) in step S21, and in step S22, the other payment (planned) table is automatically created. You.
[0062]
Withdrawal schedules other than purchase / borrowing repayment, such as personnel expenses / expenses, etc., are entered as other expected payment data (expected withdrawal data other than purchase / borrowing repayment) in step S31, and in step S32. , Expense and other payment (plan) tables are automatically created.
[0063]
When the borrowing repayment plan (borrowing repayment expected data) is input in step S41, a borrowing list and a borrowing repayment schedule are automatically created in step S42. Further, in step S43, a bank transaction status table is automatically created.
[0064]
In step S51, a bank-by-bank acquisition list (from a payment list, a payment list, a note receivable book, a payment note book, other payment schedules, expenses and other payment tables, and a debt repayment schedule). A bank account book is automatically created.
[0065]
In step S52, a deposit / withdrawal total table (total accounting book) is automatically created from a bank-acquired money list (bank accounting book). Further, in step S53, a funding table is automatically created from a bank-by-bank acquisition money list (bank-specific accounting book).
[0066]
With the configuration and operation described above, the borrowed material creating apparatus according to the present embodiment has a function of automatically creating a sales list (order receipt) when sales forecast data is input, and a function of the sales list (order receipt). ), A function to automatically create a payment list from expected purchase data, a function to automatically create a payment list from the purchase list, A function to automatically create a bill of exchange when paying by bill, a function to automatically create a bill of exchange to pay the purchase price by bill, and other payments to be paid for interest income (other than sales and borrowing) A function to automatically create a table, a function to automatically create an expense and other payment table for withdrawal of personnel expenses and other payments (other than purchase and repayment of debt), and a list of borrowed money and a repayment schedule of borrowed money for borrowing Function to automatically create A function to automatically create a bank account (payment list for each bank) from a list, payment list, notes receivable, notes payable, other payment schedules, expenses and other payments, and debt repayment schedules. A function to automatically create a total accounting table (combined deposit and withdrawal table) from the bank account book (acquisition table by bank) and a function to automatically create the fund schedule from the total accounting table (combined withdrawal table). And a function for automatically creating a bank transaction status table displaying a discounted bill balance, a short-term borrowing balance, a long-term borrowing balance, and a deposit balance for each bank.
[0067]
Hereinafter, a data input method in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention will be described.
[0068]
FIG. 4 shows a menu screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0069]
Here, Windows (registered trademark) will be described as an operation system (hereinafter referred to as an OS).
[0070]
When the OS is started in a personal computer (hereinafter, referred to as a PC), a program manager screen appears on the display 7. Here, open the group called "financing system" and double-click the icon "financing system bank". Then, a menu screen (hereinafter, referred to as a menu screen) of “financing system bank” as shown in FIG. 4 appears on the display 7.
[0071]
As shown in the figure, the menu screen has a menu bar in which items of “change year”, “input”, “print”, printer setting, data backup, “end”, and “help” are arranged. Each item will be described later.
[0072]
As shown in the figure, the menu screen shows illustrations of "Change year", "Input", "Print", Printer settings, Data backup, "End", "Help", animals (cow), "Sales list", " Payment List, Payment Confirmation, Purchase List, Payment List, Payment Confirmation, Other Payments, Expenses / Other Payments, Borrowing List, Notes Receivable , "Payment note book".
[0073]
When each button is clicked with the mouse 6, each input screen appears on the display 7 as described later.
[0074]
As described above, an operation can be input by graphical information such as selection of an icon menu by using a Graphical User Interface (hereinafter referred to as a GUI), so that anyone can easily operate and even those who do not have accounting expertise can easily perform the operation. You can calculate the cash flow and create three borrowing tables. Note that the GUI refers to an interface that uses visual information such as graphics for operating the computer.
[0075]
When the “year change” on the menu bar of the menu screen described with reference to FIG. 4 is clicked with the mouse 6, a target year change screen as shown in FIG. The user uses the keyboard 5 to write the year in which the processing is performed at a predetermined location on the screen. If the written year is correct, click “OK” on the right side of the screen with the mouse 6. Thus, a new entry or change of the target year is performed.
[0076]
When "input" on the menu bar of the menu screen is clicked with the mouse 6, as shown in FIG. 6, "sales list", "payment list", "payment confirmation", "purchase list", "payment" A list of menus such as “List”, “Payment confirmation”, “Other payments”, “Expenses and other payments”, “List of borrowings”, “Notes receivable”, “Payment notes”, and “Initial balance setting” appears. The “sales table” to “payment note book” basically have the same functions as the buttons on the right side of the menu screen. That is, when each menu is selected and executed, the respective input screens appear on the display 7 as described later.
[0077]
“Initial balance setting” is a menu for registering bank balances to be set when introducing this program. When selected and executed, a bank balance registration screen as shown in FIG. 7 appears on the display 7. .
[0078]
To register a bank, click “Add Bank” at the bottom right of the screen. Then, a bank addition screen as shown in FIG. 8 appears. Therefore, the user uses the keyboard 5 or the like to enter a bank name in a predetermined column. If the entered bank name is correct, click "OK". Then, the screen returns to the bank balance registration screen as shown in FIG.
[0079]
To register the deposit balance, click on the line for registering (changing) the deposit balance, and then click “Change Balance” at the bottom right of the screen. Then, an initial setting balance change screen as shown in FIG. 10 appears. Therefore, the user uses the keyboard 5 or the like to enter the set date, ordinary deposit, and checking account balance in predetermined fields. If the entered set date, ordinary deposit, and checking account balance are correct, click "OK". Then, the screen returns to the bank balance registration screen as shown in FIG.
[0080]
As for the registration of balances other than deposits (notes receivable, accounts receivable, notes payable, accounts payable, discount bills, and borrowings), as described later, the flow data (data related to balances) before the fiscal year in which the fund Registration (input) is performed.
[0081]
Hereinafter, a printing procedure of various forms in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention will be described.
[0082]
FIG. 12 shows a menu screen in a state where “print” on the menu bar is clicked.
[0083]
When "print" is clicked, a list of 14 items is displayed as shown in the figure. The forms include “sales list (horizontal)”, “payment list (horizontal)”, “purchase list (horizontal)”, “payment list (horizontal)”, ) "," Payment notes (entry) book (vertical) "," Other payment tables (vertical) "," Expenses and other payment tables (vertical) "," Loans list (vertical) "," Debt repayment schedule (vertical) ""," List of deposits and withdrawals by bank (vertical) "," Total deposits and withdrawals (vertical) "," Bank transaction status (table) (vertical) ", and" financing table (vertical) ". The (vertical) and (horizontal) characters beside the form indicate the printing direction in the printer settings.
[0084]
When printing other payment tables and expenses / other payment tables, specify the month to be printed.
[0085]
To print a bank-by-bank deposit / withdrawal list, click on the output from your savings account, checking account, or grand total. Next, a month to be printed is specified.
[0086]
To print the deposit / withdrawal totals table, click on the output from your savings account, checking account, or grand total. Next, a month to be printed is specified.
[0087]
When printing the bank transaction status (table), specify the month to print. Then, the designated month-end balance is printed.
[0088]
When the cash flow sheet is printed, six months are displayed, so the first month to be printed is specified.
[0089]
The printing is performed using the printer 9. Other settings for the printer 9 include resolution, paper size, paper feeding method, and the like. Here, the printing direction is mainly selected.
[0090]
Hereinafter, backup of various data in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention will be described.
[0091]
FIG. 13 shows a menu screen in a state where “data backup” on the menu bar is clicked.
[0092]
When "Data Backup" is clicked, a screen for selecting a backup to a hard disk or a floppy disk appears (there are also restorations). The user selects which one to execute.
[0093]
For example, when “Backup to floppy disk” is selected and executed, a screen as shown in FIG. 14 appears on the display 7. Here, when the user selects a drive for storing the backup data and clicks “OK”, various types of data described below are backed up.
[0094]
When "Restore from floppy disk" is selected and executed, a screen as shown in FIG. Here, the user selects the drive into which the backup floppy is to be inserted, and clicks "OK" to restore the data.
[0095]
To end the program according to the present embodiment, click “End” on the menu bar. When the user clicks "Help" on the menu bar, the user can refer to a help function such as an input method corresponding to the menu screen.
[0096]
Hereinafter, each function of the borrowed material creating apparatus and the borrowed material creating program according to the present invention will be individually described.
[0097]
First, a function of automatically creating a sales list (order details) in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention will be described.
[0098]
When sales forecast data is input, a sales list (order receipt) as shown in FIG. 16 is automatically created. As shown in the figure, the sales list (order receipt) is a table in which sales results or planned sales amounts in each fiscal year for each customer (for each sales destination) are arranged for each month (month of sales). Further, information on items such as sales product name, payment condition, total for one year (annual total), transfer destination and the like can be shown.
[0099]
When the user inputs predetermined data using the keyboard 5 and the mouse 6 as described later, data in a similar format (sales list data) is displayed on the display 7 and printed out by the printer 9.
[0100]
The data from April to July in FIG. 16 is so-called “actual” data (actual sales) in which the delivery of the product has been completed successfully. The data from August to March are so-called “planned” data (planned sales) in which the delivery of the product has not been completed successfully. As described above, by displaying the data in which the delivery of the product has been successfully completed and the data in which the product has not been completed so as to be distinguished, the user can easily grasp the sales situation.
[0101]
Here, a procedure for inputting (including deleting and changing) the sales list (order specification) will be described.
[0102]
The registration (deletion) of the customer / commodity and the input (change) of the sales amount are performed using the sales list screen displayed on the display 7 as described below.
[0103]
When the “sales list” (“input” or button on the menu bar) is clicked on the menu screen, a customer name selection screen as shown in FIG. 17 appears on the display 7. The user presses a button of the reading kana of the customer to be selected on the customer name selection screen, and inputs the customer.
[0104]
There are the following three types of customer designation methods.
{Circle around (1)} The first reading of the name is selected from the classification of the line.
{Circle around (2)} The first reading of the name is selected from AZ classification.
(3) All items are displayed instead of being displayed separately as in (1) or (2).
When the customer is specified in this way, a sales list screen as shown in FIG. 18 appears.
[0105]
First, registration of a customer / product will be described.
[0106]
Clicking “Edit” at the upper left of the sales list screen in FIG. 18 displays “Customer / product registration” and “Customer / product deletion” as shown in the figure. Click “Product Registration”.
[0107]
Then, a customer / product registration screen as shown in FIG. 19 appears. Therefore, the user inputs the customer name, customer reading, product name, product name reading, payment month, payment date, receiving bank, and receiving account. Note that the customer reading and the product name reading are input in hiragana.
[0108]
To register the payment month, click the ↓ bar, and the payment site from the current month to 11 months later will be displayed, so click the relevant part.
[0109]
To register the payment date, click the ↓ bar to display 1, 5, 10, 15, 20, 25, and the last day of the payment. Payment dates that do not correspond to these are entered from the keyboard 5 (numeric keys).
[0110]
To register the receiving bank, register the bank name. Once registered, the bank will appear when you click the ↓ bar. To register a deposit account, click the ↓ bar and select Normal (Deposit) or Check (Deposit).
[0111]
If there is no error in the above input, click the "OK" button at the bottom right of the customer / product registration screen, and the customer name, customer reading, product name, product name reading, payment month, payment date, payment The bank and the deposit account are registered, and the screen returns to the sales list screen after the registration.
[0112]
On the other hand, when deleting a customer / commodity, on the sales list screen in FIG. 18, the customer / commodity is clicked and specified, and “edit” is clicked on the upper left. Next, "customer / product deletion" is clicked to display a customer / product deletion screen as shown in FIG.
[0113]
If there is no mistake in deleting the customer / product indicated on the customer / product deletion screen, click the “OK” button at the lower right of the customer / product deletion screen. The screen is deleted and the screen returns to the sales list screen after the deletion.
[0114]
When inputting the sales amount, the cursor is moved to the place to be input on the sales list screen as shown in FIG. 21 and clicked. Thus, the input location is specified. Next, as shown in FIG. 22, an input is made in units of one yen into an amount column at the lower left of the sales list screen (amount excluding consumption tax). If there is no error in the input, click the "OK" button on the right side of the amount column. Then, as shown in FIG. 23, the display returns to the sales list screen after the input of the amount.
To cancel in the middle of the input, click the "Cancel" button on the right of the "OK" button in FIG.
[0115]
To change the sales amount, click the data to be changed on the sales list screen as shown in FIG. Then, the screen is switched to a screen as shown in FIG. Next, as shown in FIG. 26, the user inputs change data in the amount column at the lower left of the sales list screen. If there is no error, the user clicks the “OK” button on the right side of the amount column, and the processing procedure in the case of sales cancellation (change to sales amount “0”) will be described later.
[0116]
A payment breakdown screen as shown in FIG. 27 appears. The data displayed in the upper row (sales amount) is the changed amount (the amount including the consumption tax). The data in the lower frame is the amount before the change. Change this amount.
[0117]
As shown in FIG. 28, a row to be changed is clicked to select it, and then "change" at the lower right is clicked. Then, a payment details change screen as shown in FIG. 29 appears. Then, move the cursor to the place to change and click. Enter the change amount. If there is no error, click “OK.” Then, the screen returns to the payment breakdown screen as shown in Fig. 30. The corrected amount is displayed there. Click "". Then, as shown in FIG. 31, the sales list screen after the amount adjustment is displayed, and the change is completed.
[0118]
Next, a function of automatically creating a deposit list in the borrowed material creating apparatus and the borrowed material creating program according to an embodiment of the present invention will be described.
[0119]
FIG. 32 shows an example of a deposit list in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. The payment list is a sales list displayed on a payment basis, and is automatically created from the sales list (order details).
[0120]
That is, as shown in the figure, the payment list is a table showing, for each month (sales month), the payment result or the expected payment amount in each year for each customer (for each sales person). Further, information on items such as sales product name, payment condition, total for one year (annual total), transfer destination and the like can be shown.
[0121]
When the user inputs predetermined data using the keyboard 5 and the mouse 6 as described later, data in the same format (payment list data) is displayed on the display 7, and is printed out by the printer 9.
[0122]
The data of the payment list created in this way (payment list data) is transcribed to a bank account book described later, and further compiled in a fund schedule described later.
[0123]
Note that the data from April to July in FIG. 32 is so-called “actual” data (actual deposit amount) in which the deposit processing (collection) has been completed. The data from August to March is so-called “scheduled” data (scheduled deposit amount) in which the deposit processing (collection) has not been completed. As described above, by displaying the data for which the payment processing has been completed and the data for which the payment processing has not been completed so as to be distinguishable, the user can easily grasp the payment status.
[0124]
Here, a procedure for changing the sales deposit and the deposit amount will be described.
[0125]
The process of changing the sales deposit, the deposit amount, and the like is performed using a deposit list screen displayed on the display 7 as described later. That is, when a change is made to the payment (in the case of division, postponement, bills, etc.), input (change processing) is performed using the payment list screen as shown in FIG. The change of the sales amount is performed from the sales list screen as described above. In principle, the payment list will display the initial planned payment amount even if the contents of the payment change as described above, but if the sales amount is changed from the sales list screen, it will automatically Changes to
[0126]
When the user clicks on “payment list” (“input” or button on the menu bar) on the menu screen, a customer name selection screen as shown in FIG. 17 appears on the display 7. As described above, the user presses the button of the reading name of the customer to be selected on the customer name selection screen, and inputs the customer.
[0127]
The method for specifying the customer is the same as described above. When the customer is specified in such a manner, a payment list screen as shown in FIG. 33 appears.
[0128]
First, a description will be given of a case of changing to the divisional payment.
[0129]
When the data to be changed on the payment list screen is clicked, a screen as shown in FIG. 34 is displayed. Here, the amount before the change is displayed in the amount column at the lower left. Then, click the "Change" button on the right side of the amount column. Then, a payment breakdown screen as shown in FIG. 35 appears. Then, click the line of the data to be changed, and click the "Change" button at the lower right of the screen. Then, a payment breakdown change screen as shown in FIG. 36 appears. Then, as shown in FIG. 37, the change amount is input, and if there is no error, "OK" is clicked.
[0130]
Then, the screen returns to the payment breakdown screen as shown in FIG. 38, and at the same time, the corrected amount is displayed. Since this is a divisional payment and data is to be added, click "Add" on this payment breakdown screen. Then, a payment breakdown addition screen as shown in FIG. 39 appears. Then, input each input item and click "OK" if there is no error, then return to the payment breakdown screen as shown in Fig. 4. If there is no error, click "Go to payment list" at the bottom right of the screen Then, the screen returns to the payment list screen.
[0131]
Next, the change of the payment date will be described.
[0132]
When the data to be changed is clicked on the payment list screen shown in FIG. 33, the payment list screen shown in FIG. 34 is displayed. Then, click "Change" on the right of the lower left price column. Then, the payment breakdown screen of FIG. 35 appears. Then, click the row of the data to be changed, and click “Change” in the lower right. Then, the payment details change screen of FIG. 36 appears. Therefore, the changed payment date is input to the payment date field using the keyboard 5 (numeric keys). If there is no error, the user clicks “OK.” Then, the screen returns to the payment breakdown screen of Fig. 38. However, the date after correction is displayed in the expected payment date column. Click "Go to Deposit List" to complete the change.
[0133]
The same applies to the change of the payment date until the payment details change screen of FIG. 36 appears. Then, as shown in FIG. 41, the item in the field of the item on the deposit breakdown change screen is changed to "bills", as shown in FIG. If there are no other problems, click "OK". Then, a bill input screen as shown in FIG. 42 appears. Here, the bill date, bill number, account, drawer (endorser), and payer (underwriter) are entered. If there is no error, click "OK". The screen returns to the payment breakdown screen as shown in FIG. There, the note number and the due date are entered in the remarks column. If there is no problem, click "Payment List" to complete the change.
[0134]
In the case where the same customer has a plurality of sales data in the same month and the payment is one bill, the bill amount is divided. In this case, the bill number is changed to protect data dub.
[0135]
In the case of partial bill deposit, the bill deposit processing described with reference to FIGS. 42 and 43 is performed, and at the same time, the payment addition processing described with reference to FIGS. 38 and 39 is performed.
[0136]
In the case of changing the receiving bank, the receiving bank is changed in the same manner as the above-described processing for changing the receiving date.
[0137]
Next, deletion of sales / payment will be described.
[0138]
In the case of sales cancellation, the sales amount “0” is input on the sales list screen as shown in FIG.
[0139]
As shown in FIG. 45, "delete" is clicked on the payment breakdown screen. Then, a payment details deletion screen as shown in FIG. 46 is displayed. If there is no particular problem, "OK" is clicked. Then, the screen returns to the payment details screen after deletion as shown in FIG. Further, when "to sales list" is clicked, the display returns to the deleted sales list screen as shown in FIG.
[0140]
If the payment is changed from split payment to single payment, select the relevant data on the payment list screen, and delete unnecessary data on the payment breakdown screen. When the payment details deletion screen appears, click "OK". When a change is required, the change process is continued.
[0141]
Here, payment confirmation will be described. FIG. 49 shows a payment confirmation list screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. This is a screen for managing the receivable collection.
[0142]
On the menu screen described above, click "Payment confirmation"("input" or button on the menu bar). Then, a date input screen shown in FIG. 50 appears. Therefore, the user inputs the month to be checked and clicks “OK”. Then, a payment confirmation list screen as shown in FIG. 49 appears. Here, the payment schedule data of the current month is displayed. When payment is confirmed, put a check mark in the confirmation column at the right end (click the line where payment is confirmed). When done, click "Go to Menu".
[0143]
Next, a function of automatically creating a purchase list in the borrowed material creating apparatus and the borrowed material creating program according to an embodiment of the present invention will be described.
[0144]
FIG. 51 shows an example of a purchase list in the embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0145]
When the expected purchase data is input, a purchase list as shown in FIG. 51 is automatically created. As shown in the figure, the purchase list is a table showing, for each month, purchase results or planned purchase amounts in each year for each supplier. In addition, information on items such as a purchased product name, a payment condition, a total for one year (annual total), a transfer destination, and the like can be shown.
[0146]
When the user inputs predetermined data using the keyboard 5 and the mouse 6 as described later, data in a similar format (purchase list data) is displayed on the display 7 and printed out by the printer 9. .
[0147]
The data from April to July in FIG. 51 is so-called “actual” data (actual purchase amount) in which the delivery of the product has been completed successfully. The data from August to March is so-called “planned” data (planned purchase amount) in which the delivery of the product has not been completed successfully. In this way, if the data indicating that the delivery of the product has been successfully completed and the data that has not been completed are displayed so as to be distinguishable, the user can easily grasp the purchase situation.
[0148]
Here, the input (including deletion / change) procedure of the purchase list (order specification) will be described.
[0149]
The registration (deletion) of the supplier / product and the input (change) of the purchase price are performed using a purchase list screen displayed on the display 7 as described below.
[0150]
When the “supply list” (“input” or button on the menu bar) is clicked on the above-mentioned menu screen, a supplier name selection screen as shown in FIG. 51 appears on the display 7. The user presses the button of the reading kana of the supplier selected on the supplier name selection screen and inputs the supplier. There are three types of supplier specification methods similar to the above-described customer specification method.
[0151]
When the supplier is specified in this way, a purchase list screen as shown in FIG. 53 appears.
[0152]
First, registration of a supplier / commodity will be described.
[0153]
The preparation of the purchase list is first performed from the supplier / product registration.
Clicking "Edit" at the upper left of the Supplier List screen displays "Supplier / Product Registration" and "Supplier / Product Deletion". Here, click "Supplier / Product Registration". Then, a supplier / merchandise registration screen as shown in FIG. 54 appears, and the supplier input, merchandise name, merchandise name reading, payment month, payment date, main transfer destination, and account are input. Note that the reading of the supplier and the reading of the product name are entered in “Hiragana”. If there is no error in the input, click “OK.” Then, the screen returns to the purchase list screen.
[0154]
On the other hand, when deleting a supplier / product, the supplier / product is clicked and specified on the purchase list screen shown in FIG. 53, and "edit" is clicked on the upper left. Next, when "delete supplier / product" is clicked, a supplier / product delete screen as shown in FIG. 55 appears.
[0155]
If there is no error in deleting the supplier / product shown on the supplier / product deletion screen, click the “OK” button at the lower right of the supplier / product deletion screen. The destination / product is deleted, and the display returns to the purchase list screen after the deletion.
[0156]
When inputting the purchase price, the cursor is moved to the place to be input on the purchase list screen as shown in FIG. 56 and clicked. Thus, the input location is specified. Next, using the keyboard 5 (numeric keypad), an input is made in units of one yen into the amount column at the lower left of the purchase list screen (amount excluding consumption tax). If there is no error in the input, click the "OK" button on the right side of the amount column.
To cancel during the input, click the "Cancel" button on the right of the "OK" button in FIG.
[0157]
To change the purchase price, the purchase price is changed from a purchase list screen as shown in FIG. When the data to be changed is clicked, the screen is switched to a screen as shown in FIG. Next, as shown in FIG. 59, the user inputs change data in the amount column at the lower left of the purchase list screen. Then, if there is no error, the user clicks the “OK” button on the right side of the amount column, and a payment breakdown screen as shown in FIG.60 appears.The data displayed in the upper row (purchase amount) is changed. The data in the lower frame is the amount before the change.This amount is changed.
[0158]
In the screen of FIG. 60, a row to be changed is clicked to select it, and then “change” in the lower right is clicked. Then, a payment details change screen as shown in FIG. 61 appears. Then, the cursor is moved to the place to be changed and clicked, and the change amount is input. If there is no error, click “OK.” Then, the screen returns to the payment breakdown screen as shown in Fig. 62. The corrected amount is displayed there. Click "To purchase list". Then, as shown in FIG. 63, the purchase list screen after the amount adjustment is displayed, and the change is completed.
[0159]
Next, a description will be given of a function of automatically creating a payment list in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0160]
FIG. 64 shows an example of a payment list in one embodiment of the borrowed material creation device and the borrowed material creation program according to the present invention. The payment list is a purchase list displayed on a withdrawal basis.
[0161]
That is, as shown in the figure, the payment list is a table showing payment results or scheduled payment amounts in each year for each supplier for each month (payment month). In addition, information on items such as a purchased product name, a payment condition, a total for one year (annual total), a transfer destination, and the like can be shown. Such a payment list is automatically created from the aforementioned purchase list.
[0162]
When the user inputs predetermined data using the keyboard 5 and the mouse 6 as described later, data in a similar format (payment list data) is displayed on the display 7 and printed out by the printer 9.
[0163]
The data of the payment list (payment list data) created in this way is transferred to a bank account book described later, and further compiled into a fund schedule described later.
[0164]
The data from April to July in FIG. 64 is so-called “actual” data (actual payment amount) for which the payment processing has been completed. The data from August to March is so-called “scheduled” data (scheduled payment amount) for which the payment processing has not been completed. As described above, by displaying the data for which payment processing has been completed and the data for which payment processing has not been completed so as to be distinguishable, the user can easily grasp the payment status.
[0165]
Here, a procedure for changing the purchase payment and the payment amount will be described.
[0166]
The processing for changing the purchase payment, the payment amount, and the like is performed using a payment list screen displayed on the display 7 as described later. That is, when a change is made to the payment (for example, when the payment is made by division, postponement, or bill), an input (change process) is made using a payment list screen as shown in FIG.
[0167]
Note that the purchase price is changed from the purchase list screen as described above. In the payment list, even if the payment contents change as described above, in principle, the initial expected payment amount is displayed, but if the purchase amount is changed from the purchase list screen, it will be Change automatically.
[0168]
When the “payment list” (“input” or button on the menu bar) is clicked on the above-mentioned menu screen, a supplier (payee) name selection screen (see FIG. 51) appears on the display 7. The user presses the button of the reading name of the customer selected on the supplier (payee) name selection screen, and inputs the payee. The designation method is the same as described above. When the payee is specified in such a manner, a payment list screen appears.
[0169]
First, the case of the installment payment will be described.
[0170]
When the data to be changed on the payment list screen in FIG. 65 is clicked, the screen switches to a screen as shown in FIG. Here, the amount before the change is displayed in the amount column at the lower left. Then, click the "Change" button on the right side of the amount column. Then, a payment breakdown screen as shown in FIG. 67 appears. Then, click the line of the data to be changed, and click the "Change" button at the lower right of the screen. Then, a payment details change screen as shown in FIG. 68 appears. Therefore, as shown in FIG. 68, the change amount is input, and if there is no error, "OK" is clicked. Then, the screen returns to the payment breakdown screen as shown in FIG. 69, and at the same time, the corrected amount is displayed. Since this is a payment in installments, and data is to be added, click “Add” on this payment breakdown screen. Then, a payment details adding screen as shown in FIG. 70 appears. Then, input each input item and click "OK" if there is no error, and then return to the payment breakdown screen as shown in Fig. 71. If there is no error, click "to payment list" at the bottom right of the screen And return to the payment list screen.
[0171]
Next, the change of the payment date will be described.
[0172]
When the data to be changed is clicked on the payment list screen shown in FIG. 65, the payment list screen shown in FIG. 66 is displayed. Then, click "Change" on the right of the lower left price column. Then, the payment breakdown screen of FIG. 67 appears. Then, click the row of the data to be changed, and click “Change” in the lower right. Then, the payment details change screen of FIG. 68 appears. Therefore, the payment date after the change is entered in the payment date column using the keyboard 5 (numeric keys). If there is no error, click “OK.” Then, the screen returns to the payment breakdown screen of Fig. 67. However, the date after correction is displayed in the expected payment date column. Click "To payment list" to complete the change.
[0173]
In the case of the bill payment, the change is the same as the change of the payment date until the payment details change screen of FIG. 68 appears. Then, the item of “deposit” in the deposit category on the payment breakdown change screen is changed to “bill draft” as shown in FIG. If there are no other problems, click "OK". Then, a payment note input screen as shown in FIG. 73 appears. Here, the bill date, bill number, and account are entered. If there is no error, click "OK". Then, the screen returns to the payment breakdown screen as shown in FIG. There, the note number and the due date are entered in the remarks column. If there is no problem, click "To payment list" to complete the change.
[0174]
If there is a plurality of purchase data at the same payee in the same month and the payment is one bill, the bill amount is divided. In this case, the bill number is changed to protect data dub.
[0175]
In the case of a bill endorsement, if the payment details change screen appears, the processing is advanced in the same procedure as the change of the payment date. Then, the subject of the deposit category on the payment breakdown change screen is changed to "normal" as shown in FIG. 75, and the user clicks "OK" as shown in FIG. When you select (click) the bill, click "OK". Then, the screen returns to the payment breakdown screen. As shown in FIG. 77, the endorsement bill, bill number, and due date are entered in the remarks column. If there are no mistakes, click "To Payment List" to complete the change.
[0176]
In the case of partial bill payment, the processing of bill payment described with reference to FIGS. 73 and 74 is performed, and the additional processing of payment described with reference to FIGS. 69 and 70 is performed.
[0177]
In the case of changing the paying bank, the paying bank is changed in the same manner as in the payment date change process described above.
[0178]
Next, deletion of purchase / payment will be described.
[0179]
In the case of purchase cancellation, as shown in FIG. 78, a purchase amount "0" is input on the purchase list screen.
[0180]
Click “Delete” on the payment breakdown screen as shown in FIG. 79. Then, the payment details deletion screen as shown in FIG. 80 is displayed. If there is no particular problem, click “OK”. Then, the screen returns to the payment breakdown screen after deletion as shown in FIG. Further, when "to purchase list" is clicked, the screen returns to the purchase list screen after deletion as shown in FIG.
[0181]
If the payment is changed from installment payment to single payment, select the relevant data on the payment list screen and delete unnecessary data on the payment breakdown screen. When the payment details deletion screen appears, click "OK". When a change is required, the change process is continued.
[0182]
Here, payment confirmation will be described. FIG. 83 shows a payment confirmation list screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. This is a screen for managing payment of accounts payable.
[0183]
Click “Payment confirmation” (“Enter” or button on the menu bar) on the menu screen described above. Then, the date input screen shown in FIG. 50 appears. Therefore, the user inputs the month to be checked and clicks “OK”. Then, the payment confirmation list screen shown in FIG. 83 appears. Here, the payment schedule data for the current month is displayed. If payment is confirmed, put a check mark in the confirmation column at the right end (click the line where payment is confirmed). When done, click "Go to Menu".
[0184]
Next, a description will be given of a function of automatically creating a payment schedule in the borrowed material creating apparatus and the borrowed material creating program according to an embodiment of the present invention.
[0185]
FIG. 84 shows an example of the other payment schedule in the embodiment of the borrowed material creating apparatus and the borrowed material making program according to the present invention.
[0186]
Deposit data such as interest income (other than sales and borrowing) are as shown in the figure, “Deposit / Deposit Source”, “Date (Deposit Date)”, “Description”, “(Deposit) Amount”, “(Deposit) Bank” , "Remarks" and "Total other payments" are arranged in a table. When the user inputs predetermined data using the keyboard 5 and the mouse 6 as described later, data of the same format (other data to be paid) is displayed on the display 7, and is printed out by the printer 9. . In this way, the other payment schedule is automatically created for the payment of interest income (other than sales and borrowing).
[0187]
The data of the other payment schedule (other payment schedule data) created in this way is transferred to a bank account book described later, and further compiled into a fund schedule described later.
[0188]
Here, a processing procedure of addition, change, and deletion of other payment schedule data will be described.
[0189]
To add new data, first click "Additional payment"("Input" or button on the menu bar) on the menu screen. Then, the date input screen shown in FIG. 50 appears. Therefore, the user inputs the month to be input and clicks "OK". Then, the other payment table screen shown in FIG. 85 appears. Then, when inputting new data, click “Add”. Then, the other payment registration screen as shown in FIG. 86 appears. Therefore, the user inputs the payment date, payment source, deposit classification, amount, deposit bank, and summary. If there is no error, click "OK". Then, the screen returns to the other payment table screen as shown in FIG. If there is no problem, click “Go to Menu”.
[0190]
When changing the data, the other payment table screen is called, and as shown in FIG. 88, the row of the data to be changed is clicked and selected, and "change" at the lower right of the screen is clicked. Then, the other payment change screen as shown in FIG. 89 appears. Here, the portion to be changed is changed using the keyboard 5 (numeric keys), and "OK" is clicked. Then, the screen returns to the other payment table screen shown in FIG. 90. If there is no particular problem, click “to menu”.
[0191]
When deleting data, the other payment table screen is called, and as shown in FIG. 91, a row of data to be deleted is clicked and selected, and "delete" at the lower right of the screen is clicked. Then, the other payment deletion screen as shown in FIG. 92 appears. Click "OK" to delete the data. Then, as shown in FIG. 93, the other payment table screen after deletion appears. If there is no particular problem, click “go to menu”.
[0192]
Next, a description will be given of a function for automatically creating an expense or other payment table in an embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0193]
FIG. 94 shows an example of an expense and other payment table (payment list, etc.) in one embodiment of the borrowed material creating apparatus and the borrowed material making program according to the present invention.
[0194]
Withdrawal data other than purchase / borrowing repayment, such as personnel expenses / expenses, are as shown in the figure, "Deposit / Subject", "Date (withdrawal date)", "Description", "(Withdrawal) amount", " It is arranged in a table that is divided into "Payment Bank", "Remarks" and "Total Payment".
[0195]
When the user uses the keyboard 5 and the mouse 6 to input predetermined data as described later, data in a similar format (expenses and other payment data) is displayed on the display 7 and printed out by the printer 9. . In this way, an expense and other payment table is automatically created for withdrawal of personnel expenses, expenses and other payments (other than purchase and repayment of loans).
[0196]
The data of the expense and other payment table (expense and other payment data) created in this manner is transferred to a bank account book described later, and further compiled into a fund schedule described later.
[0197]
Here, a procedure of inputting (adding, changing, and deleting) the expense and other payment data will be described.
[0198]
Expenditures other than purchases, notes payable, and repayment of borrowings are all entered using the expense / other payment table screen described later. The operation method is basically the same as the other payment table screens, except that there is a “subject” column. The “subject” indicates a breakdown of expenses and other payments, and includes expenditure items (personnel expenses, expenses, capital funds, taxes and dividends, interest expenses, and others) in the cash flow table. However, transfers other than the expenditure items in the funding schedule are also displayed in the subjects. It should be noted that the transfer includes other-line transfer (4 patterns) and same-line transfer (2 patterns).
[0199]
On the menu screen, click "Expenses / other payments"("input" or button on the menu bar) and enter the month to be entered on the date input screen shown in FIG. Then, an expense / other payment table screen as shown in FIG. 96 appears. Then, when inputting new or additional data, click "Add", when changing, click "Change", and when deleting, click "Delete".
[0200]
FIG. 97 shows a new (additional) data registration screen.
For subjects, click the ↓ bar and select the subject (or transaction). When the other bank transfer or the same bank transfer is selected, it is not necessary to input the summary.
In the case of another bank transfer, when "OK" is pressed, a transfer destination selection screen appears, and the corresponding bank is clicked.
Once registered, the summary will appear when you click the ↓ bar.
When all are entered, click "OK".
[0201]
FIG. 98 shows a screen for changing data (expense / other payment change screen). FIG. 99 shows a screen for deleting data (expense / other payment deletion screen). Use each screen to change or delete expenses and other payment data.
[0202]
Next, a description will be given of a function of automatically creating a borrowed money list and a borrowed money repayment schedule in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0203]
FIG. 100 shows an example of a borrowed money list in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. This is a table showing “long / short / account”, “borrowing balance”, “paying bank”, and “interest / interest” for each “borrowing date” and “borrower”. In addition, there is a “Remarks” column, and “Total borrowing” is also shown.
[0204]
FIG. 101 shows an example of the borrowed money repayment schedule in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. This is a table showing the balance and the repayment (planned) date for each “borrowing date” and “borrower”. In addition, there are also columns for “long / short / account”, “amount”, “receiving bank”, “interest / interest”, and “remarks”.
[0205]
When the user inputs predetermined data using the keyboard 5 and the mouse 6 as described later, data in a similar format (borrowed money list data / borrowed money repayment data) is displayed on the display 7 and these are displayed on the printer 9. Is printed out. In this way, the borrowed money list and the borrowed money repayment schedule are automatically created for the borrowed money.
[0206]
The data of the borrowed money list and the borrowed money repayment schedule data (borrowed money list data / borrowed money repayment scheduled data) created in this way are posted to the bank account book described later, and further aggregated in the cash flow table described later. .
[0207]
Here, the procedure of inputting (registering, changing, and deleting) the borrowed money list data and the borrowed money repayment schedule data will be described.
[0208]
Data on borrowing / repayment is input from the borrowed money list screen shown in FIG.
[0209]
In the case of borrowing registration, first, on the above-mentioned menu screen, click on “List of borrowings” (in “input” or button on the menu bar). Then, the borrowed money list screen shown in FIG. 101 appears. Then, a borrowed money registration screen as shown in FIG. 103 appears. Then, using the keyboard 5, the borrowing date, the borrower, the amount, the borrowing interest rate, the depositing bank, the classification of the account (normal or current), long / short. And click "OK" if there is no error. Then, the screen returns to the borrowed money list screen as shown in FIG. 104, and clicks “go to menu”.
[0210]
When changing the borrowing, as shown in FIG. 105, a row to be changed is clicked and selected on the borrowed money list screen, and the change data is specified. Then, click “Change Borrowing”. Then, a borrowed money change screen as shown in FIG. 106 appears. Move the cursor to the position to be changed, change the data using the mouse 6, the keyboard 5, or the like, and click "OK". Then, the screen returns to the borrowed money list screen as shown in FIG.
[0211]
When borrowing is to be deleted, as shown in FIG. 108, a row to be deleted is clicked and selected on the borrowed money list screen, and deletion data is specified. Then, click “Delete Borrow”. Then, a borrowed money deletion screen as shown in FIG. 109 appears. If the data can be deleted, click “OK”. Then, it returns to the borrowed money list screen after borrowing deletion.
[0212]
In the case of repayment of borrowing, as shown in FIG. 110, the repayment data is specified by clicking and selecting a row for inputting repayment data on the borrowed money list screen. Then, click "repayment plan". Then, a debt repayment plan screen as shown in FIG. 111 appears.
[0213]
Then, enter the repayment date, the repayment amount, and the borrowing interest, and click “OK”. Then, the screen returns to the borrowed money list screen as shown in FIG. 112, and clicks “go to menu”.
Note that the borrowing interest can also be input as the interest expense of "expenses / other payments" without inputting on this screen.
[0214]
Next, a description will be given of a function of automatically creating a bill of exchange to be received when the sales price is received as a bill.
[0215]
FIG. 113 shows an example of the note receivable book (note receivable list) in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. This is a table showing a list of bills receivable. In the present embodiment, the “receipt date”, “number”, “drawer / endorser”, “payment / underwriter”, “amount”, “depositing bank”, “date”, “tensetsu”, etc. are indicated for each bill receivable. Have been.
[0216]
As described above, when the sales price or the like is received in the form of a bill, the data of the bill to be received is input from the bill input screen shown in FIG. When such an input is performed, data (bill receipt note data (receipt note list data)) in the same format as the bill of exchange receipt (receipt note list) as shown in FIG. 113 is automatically created. Is displayed on the display 7. A printout of this by the printer 9 is a bill of exchange receipt (list of bills of exchange receipt).
Note that the endorsement of the bill is entered using the payment breakdown change screen shown in FIG. 75 and the bill selection screen shown in FIG.
[0219]
The data of the notes receivable book (bill receivables list) created as described above (notes receivable book data (bills receivable list data) are converted to It is posted to the accounting book, and further tabulated in the fund schedule described below.
[0218]
It is preferable to present the data so that it can be determined whether or not the deposit processing has been completed. For example, as for data relating to the bills for which the deposit processing has been completed, the user can easily determine whether or not the bills for which the deposit processing has been completed by displaying "done" in the "end of the balance" column as shown in FIG. Can be determined.
[0219]
Further, it is preferable to present the bill of exchange data so that the bill that has been subjected to the bill endorsement process can be identified. For example, as shown in FIG. 112, "Endorsement" is written in the "Ten end" field of such a bill, and if "Endorsement date" is displayed, the user can determine whether or not the bill has been endorsed. It becomes.
[0220]
In addition, it is preferable to present the bill of exchange data so that the bill that has been subjected to the bill discount processing can be identified. For example, as shown in FIG. 113, if "discount" is added to the "end of the bill" field of the data of the discounted bill, the user can determine whether or not the bill is a discounted bill.
[0221]
As described above, the data related to bill endorsement processing and bill discount processing is displayed in the `` end of bill '' column, and the discount processing of bills described below and the detail processing of the balance, and the detail processing of the bill end of the bill are linked. Is preferred.
[0222]
Here, the bill discount processing will be described.
[0223]
When the user clicks on the “Notes on bill” (in the menu bar or under “Input”) on the menu screen, a bills on receipt screen as shown in FIG. 114 appears. Then, click the data to be discounted and select it, and click "Bills discount" at the bottom right of the screen.
[0224]
Then, a bill discount input screen as shown in FIG. 115 appears. Enter a discount processing date, a discounted amount, a discount bank, and an account, and click "OK". Then, the screen returns to the note receivable book screen as shown in FIG. 116, and if there is no problem, click "to menu".
[0225]
When the bill discount processing is performed in this manner, as shown in FIG. 116, the word “%” is written in the balance box on the bill of exchange receipt screen.
The discount fee is automatically included in the interest expense.
[0226]
To change the data on which bills were discounted, such as cancellation of discount, select the row of data on which the bills were discounted on the bills receivable book screen as shown in FIG. Click “Cancel Discount”. Then, a bill discount cancellation screen as shown in FIG. 118 appears. Then, for example, if the user wants to invalidate the discount on the bill, the user clicks “OK”. Then, the screen returns to the bill of exchange receipt screen as shown in FIG. There, the word “wari” in the end column has disappeared.
[0227]
If you want to know the balance of the discount bill, as shown in FIG. 120, on the bill of exchange receipt screen, click the line of the bill, specify it, then click "Display" in the menu bar, and click "Bill balance". Select "Information display". Then, a bill receivable bill end (discount) screen as shown in FIG. 121 appears. There, the discount processing date, discount bank, discounted amount, account, etc. are displayed. After confirming these, click “To bill of exchange” at the lower right of the screen.
[0228]
If you want to know the details of the end of the endorsement bill, as shown in FIG. 122, on the bill of exchange receipt screen, click the line of the relevant bill and specify it. Then, click “Display” on the menu bar and click “ Select "Information display". Then, a bill receivables end (endorsement) screen as shown in FIG. 123 appears. There, the endorsement payment date, payment amount, etc. are displayed. After confirming this, click “To bill of exchange” at the lower right of the screen.
[0229]
Next, a description will be given of a function of automatically creating a bill of exchange in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0230]
FIG. 124 shows an example of a bill of exchange (payment note list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention. This is a table showing a list of notes payable. In the present embodiment, “drawing date”, “number”, “subject / supplier”, “summary”, “amount”, “payment bank”, “due date”, “end of balance”, etc. are shown for each bill payable. I have.
[0231]
As described above, when paying the purchase price or the like by bill, the data of the bill to be paid is input from the bill of payment input screen shown in FIG. When such an input is performed, data (payment note book data (payment note list data)) in the same format as the bill of exchange (payment note list) shown in FIG. 124 is automatically created. It is displayed on the display 7. What is printed out by the printer 9 is a payment note book (payment note list). In this way, when paying the purchase price by a bill, a bill of payment to be paid is automatically created.
[0232]
The data of the bill of exchange (payment note list) prepared as described above (bill of exchange note data (bill payment note list data)) is transcribed to a later-described bank account book according to the due date, and further described later. Aggregated in the cash schedule.
[0233]
It is preferable to present the data so that it can be determined whether or not the payment of the bill has been completed. For example, as for the data relating to the bills for which payment has been completed, if "done" is displayed in the "end of the bill" column as shown in FIG. 124, the user can easily determine whether or not the bill has been paid for. Can be determined.
[0234]
When "Payment note book" (in the menu bar or "Input" or button) is selected on the above-described menu screen, the screen shown in FIG. 125 appears on the display 7, so that the user does not need to print out. "Payment note book" data can be viewed. If there is no problem, click “Go to Menu”.
[0235]
Next, a description will be given of a function of automatically creating a bank account (a bank-acquired money list) in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0236]
FIG. 126 shows an example of a bank account (a bank-acquired money list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention. This is a table showing, for half a month, details such as “payment (amount)”, “payment (amount)”, and “balance” for each bank with respect to each day. In other words, it can be said that the deposit amount and the withdrawal amount per day are shown for each correspondent bank.
[0237]
From the above-mentioned payment schedule, payment schedule, note receivable book, payment note book, other payment schedule, expenses and other payment schedule, borrowing list or repayment schedule, such bank-specific A cashbook is created automatically.
[0238]
That is, payment list data, payment list data, notes receivable book data, payment note book data, other payment schedule data, expenses and other payment table data, borrowing list data or borrowing repayment schedule data From this, data indicating a list of deposits and withdrawals for each financial institution of the user (bank-specific deposit and withdrawal list data) is automatically created and displayed on the display 7. What is printed out by the printer 9 is a bank account book (bank-acquired money list).
[0239]
The list of deposits and withdrawals by bank includes sales data, other deposit data, purchase data, and other payment data, for which the payment method or payment method is "bank transfer" or "bill of exchange", and deposit / withdrawal data. And borrowing / borrowing data are arranged in order of date.
[0240]
For the sales data and other payment data, the “payment amount” is displayed in the “payment” column. Further, other items such as the “Description” field may be displayed. For example, if the deposit of “bill” from “Oyama Sangyo” is “2060000” yen, it is displayed as a “payment” column of “20th” in the example of the bank deposit / withdrawal table shown in FIG. 126.
[0241]
For the purchase data and other payment data, the “payment amount” is displayed in the “payout column”. Also, other items such as the “Description” field may be displayed. For example, when the "rent" is transferred by "1,000,000" yen, it is displayed as a "withdrawal" column of "20th day" in the example of the bank deposit / withdrawal table shown in FIG. 126.
[0242]
If there is a borrowing from a financial institution, the borrowing amount is displayed in the “payment column” based on the borrowing / borrowing data. When the borrowed money has been repaid (repayed), the repayment amount is displayed in the “payment column”.
[0243]
When there are a plurality of projects for the same customer, it is preferable that the payment schedule of each project is summed up and displayed in the bank deposit / withdrawal table. For example, if a bill of "1,000,000" yen and a bill of "1060000" yen are received from "Oyama Sangyo" on "20th", both are displayed together as shown in FIG.
[0244]
When the user deposits cash in a financial institution, the deposit / withdrawal information includes information on the account of the financial institution, the date of deposit, and the deposit amount. When cash is withdrawn, information on the account of the financial institution, withdrawal date, and withdrawal amount is included.
[0245]
Note that even if the deposit / withdrawal list data for each bank is created separately for each account type (normal or current) as shown in FIGS. 126 and 127, it can be created for each bank (normal and current) as shown in FIG. Together).
[0246]
Further, it is preferable to calculate the balance. The balance can be calculated by adding the deposit amount if there is a deposit and subtracting the deposit amount if there is a deposit from the pre-registered initial deposit amount.
In addition, it is preferable to display a total amount of deposits, a total amount of withdrawals, and / or a balance for each predetermined period (preferably every month).
[0247]
Next, a description will be given of a function of automatically creating a total accounting table (total deposit / withdrawal table) in an embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0248]
FIG. 129 shows an example of a total balance table (combined deposit / withdrawal list) in an embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention. This is a table showing, in chronological order, “payment (amount)”, “payment (amount)”, “balance”, etc. in half-month units with all the banks. In other words, it can be said that the details of the amount of money received from the bank and the amount of money withdrawn to the bank are shown on a daily basis.
[0249]
As described above, the payment list, payment list, notes receivable, payment notes, other payment schedules, expenses and other payment tables, borrowing lists or repayment schedules for each bank A cashbook is created automatically. That is, payment list data, payment list data, bill of exchange receipt data, payment note book data, other payment schedule data, expenses and other payment schedule data, borrowing list data or borrowing repayment schedule data From this, data indicating a list of deposits and withdrawals for each user's financial institution (bank-specific deposit and withdrawal list data) is automatically created.
[0250]
In addition, from the data showing the list of deposits and withdrawals for each financial institution (bank deposit and withdrawal data), "Deposit (amount)", "Withdrawal (amount)", "Balance" And the like (date-and-time deposit list data) indicating the order and the like in chronological order are automatically created. In other words, the bank-by-bank deposit / withdrawal list data of all the banks is combined into one table to form the comprehensive bank-with-payment list data. Then, the comprehensive deposit / withdrawal list data is displayed on the display 7. This is printed out by the printer 9 to form a total accounting table (combined payment list). In this way, a total accounting table (combined accounting list) is automatically created from the bank accounting book (bank-acquired money list).
[0251]
Comprehensive deposit and withdrawal table data includes sales data, other deposit data, purchase data, and other payment data, for which the payment method or payment method is "bank transfer" or "bill of exchange", and deposit / withdrawal data. And borrowing / borrowing data are arranged in order of date. In other words, except that each data is not divided for each financial institution, it can be said that it is the same as the bank deposit / withdrawal list data.
[0252]
In addition, it is preferable that the comprehensive deposit / withdrawal list data indicates a balance. It should be noted that it may be possible to create for each deposit type (normal, current, etc.).
[0253]
Next, a description will be given of a function of automatically creating a funding table in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
[0254]
FIG. 130 shows an example of a funding table in an embodiment of a borrowed material creating device and a borrowed material making program according to the present invention. Such a cash flow table is automatically created from the above-mentioned total accounting table (total deposit and withdrawal list).
[0255]
The fund schedule is a table in which income and expenditures are classified and tabulated for each month in order to grasp the flow of corporate funds. In the present embodiment, as shown in FIG. 130, “sales”, “purchases”, “income”, “rollover from previous month”, “income”, “expenditure”, “excessive shortage”, “financial balance”, “next month” And the balance of the main subject at the end of the month are shown for each month.
[0256]
The "Revenue" column is divided into "Cash collection", "Deposit receipt date", "Bill discount", "Down payment", "Other", "(Bill collection)", and "Total". ing.
The “Expenditure” fields are “Payment cash payment”, “Payer settlement”, “Advance payment”, “Personnel expenses”, “Expenses”, “Equipment funds”, “Tax and dividends”, “Interest expense”, It is divided into "Other", "(Drawing bill)", and "Total".
The "financial balance" column is divided into "borrowed money" and "repayment of borrowed money".
The column of “Main subject month-end balance” is divided into “Notes receivable”, “Accounts receivable”, “Payables notes”, “Accounts payable”, “Discounted notes”, and “Loans”.
As described above, the income and expenditure of the company are classified into predetermined items, the amounts are totaled, and a financial statement table that is consolidated into one table is automatically created.
However, the present invention is not limited to such a format.
[0257]
As described above, the sales list data and the payment list data from the expected sales data, the purchase list data and the payment list data from the expected purchase data, For payments other than purchase / borrowing repayment, payment schedule data is automatically created, and for borrowing, borrowing repayment schedule data is automatically created. Then, bank accounting data is automatically created from the payment list data, payment list data, other payment schedule data, other payment table data, and borrowing repayment schedule data. In addition, total accounting table data is automatically created from bank accounting data. Further, fund schedule data is automatically created from the total accounting table data. The fund schedule data is displayed on the display 7. This is printed out by the printer 9 to form a fund schedule. In this way, a funding table is automatically created from the input of the expected sales data, the expected purchase data, the estimated other payment data, the estimated expected payment data, and the estimated repayment borrowing data.
[0258]
Note that the above-mentioned note receivable book data and payment note book data are also reflected in this cash flow table (data).
[0259]
Next, a function of automatically creating a bank transaction status table in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention will be described.
[0260]
FIG. 131 shows an example of a bank transaction status table in an embodiment of a borrowed material creating device and a borrowed material making program according to the present invention. This is a table showing a discounted bill balance (trader), a short-term borrowing balance, a long-term borrowing balance, and a deposit balance for each bank.
[0261]
From the above-mentioned borrowed money list data, borrowed money repayment schedule data, bank book data by bank, total cash book data, funding sheet data, etc. And the balance of the deposit (bank transaction status table data) are automatically created. This bank transaction status table data is displayed on the display 7. This is printed out by the printer 9 to form a bank transaction status table.
[0262]
The deposit balance is the sum of the balance of the ordinary account of each financial institution, the balance of the checking account, and the balance of fixed deposits (such as time deposits) entered by the user.
[0263]
The borrowing amount is obtained by dividing borrowing / borrowing data (borrowing list data / borrowing repayment schedule data) for each financial institution and summing up the respective amounts. The repaid amount may be subtracted from the borrowed amount. Further, it is preferable to display the long-term borrowing and the short-term borrowing separately. The long-term and short-term boundaries can be set arbitrarily.
[0264]
Next, functions other than those described above in the embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention will be described.
[0265]
The borrowed material creating apparatus and the borrowed material creating program according to the present invention further have a bank (deposit) balance total data creating function.
Bank (deposit) balance daily total data is a data that displays the deposit balance for each financial institution (or for each account) in chronological order, calculates the total amount of the deposit balance of all banks for each date, and displays this. is there.
Note that the balances of the deposits of all the financial institutions may be calculated for each date for each type of deposit and displayed.
[0266]
The borrowed material creation device and the borrowed material creation program according to the present invention further have a cash accounting data (cash accounting book) creation function.
The cash accounting data is data indicating the flow of cash possessed by the user. Specifically, of the sales data, other payment data, purchase data and other payment data, the data for which the payment method or payment method is “cash” is arranged by date, and the balance is calculated. Is displayed.
[0267]
The borrowed material creating apparatus and the borrowed material creating program according to the present invention further have a journal diary creating function.
[0268]
The journal diary creation function is a function of creating a journal diary from sales data, other payment data, purchase data, and other payment data. In order to realize this function, the user selects and / or inputs a "subject" to which each data belongs at the time of or after inputting these data. The information of the input "subject" is included in each data. Then, these data are sorted for each "subject", arranged in order of date for each subject, and list data in a predetermined format (journal diary format) is created.
[0269]
In the above-mentioned journal diary format, at least the subject, the subject code, the date, the summary, the amount, and the information of the depositing / dispensing bank are displayed for each data. Further, it is preferable to calculate the total amount of each item and / or the total amount of all data for each debit / credit, and to display the total amount.
[0270]
The sales data, other payment data, and borrowing data (in the case of borrowing) indicate the type of “deposit” as debit and the item of each data as credit. There are two types of deposits, usually immediate and ordinary, which are included in each data. The subjects include, for example, subjects such as cash collection of sales, receipt due date, bill discount, borrowing, and the like.
For purchase data, other payment data, and borrowed data (in the case of repayment of borrowed money), the item of each data is displayed as a debit, and the type of deposit is displayed as a credit. The subjects include, for example, purchase cash payment, supplier settlement, labor costs, expenses, capital funds, taxes, dividends, interest expense, repayment of borrowings, other bank transfer, same bank transfer, and the like.
[0271]
The subject code may be registered in advance in each data and displayed, or may be left blank.
The date is a sales date, a purchase date, or the like.
The summary may display information included in the summary column of each data. For example, the customer name is displayed in the case of cash collection, the payee bank is displayed in the case of transfer, and the supplier name is displayed in the case of payment.
The amount indicates the amount of money received, the amount of money withdrawn, the amount of borrowed money, and the amount of repayment of borrowed money.
If there is a remarks column, this may be displayed. For example, only in the case of transfer, the type of the transfer destination account (normal, current) may be described.
[0272]
In addition, it is preferable to calculate the total amount of the data of the same subject and at the same date and time (and in the case of sales cash collection, further, the data of the same business partner) and display this amount.
Further, it is not necessary to display the transferred data in the journal journal.
[0273]
Further, if a journal diary relating to payment of receivables, a journal diary relating to payment of expenses and the like, and a journal diary relating to transfer journals are created, settlement processing becomes extremely easy.
The journal diary relating to deposits such as accounts receivable may be created in the same manner as described above using sales data, other deposit data, and borrowed data (information related to borrowed money).
The journal diary for payment of expenses and the like may be created in the same manner as described above using purchase data, other payment data and borrowed data (information on repayment of borrowed money).
[0274]
The journal entry for transfer journals picks up data that has been transferred among sales data, other payment data, purchase data, and other payment data, and creates a journal entry for each subject.
[0275]
Regarding the receivable / sales transfer, the date is the last day, and the amount is the total amount of sales. It is preferable that the summary column include information that makes it possible to determine the details of the transfer, for example, “sales for March”.
[0276]
Regarding the transfer of purchases / accounts payable, the date is the last day and the amount is the total amount of purchases. It is preferable that the summary column include information that makes it possible to determine the details of the transfer, for example, “purchase amount in March”.
[0277]
Regarding the transfer of notes and accounts receivable, the date shall be the last day and the amount shall be the amount of bills collected. It is preferable that the summary column include information that makes it possible to determine the details of the transfer, for example, “purchase amount in March”.
[0278]
For the transfer of discounted bills / bills receivable, the date shall be the last day, and the amount shall be the total amount of discounted bills due on the current month. It is preferable that the summary column include information that makes it possible to determine the details of the transfer, for example, “March's discount bill due date”.
[0279]
For accounts payable / transfer of notes and accounts receivable, the date shall be the last day, and the amount excluding non-operating notes receivable shall be the total amount of the endorsement date for the current month. It is preferable that the summary field be information that can determine the contents of the transfer, such as “March endorsed bill”.
[0280]
Regarding the transfer of accounts payable / payable bills, the date shall be the last day, and the amount shall be the amount of bills issued this month excluding non-operating bills. In the summary column, information that can determine the details of the transfer, such as “March bill payable”, is described.
[0281]
The following information is input by the user separately from the data.
Transfer of accounts payable / receivable
In the summary field, information that can determine the transfer content such as “cancel” is described.
(2) Transfer of salary / deposit
In the summary column, the details of the transfer of employee pension, health insurance, withholding income tax, residence tax, property, etc.
Is described.
▲ 3 ▼ Transportation of travel expenses / transportation / salary
In the summary column, information that can determine the details of the transfer, such as commuting transfer for a commuter pass, is described.
(4) Transfer of salary / legal welfare expenses
The summary field contains information that can be used to determine the details of the transfer, such as employment insurance.
▲ 5 ▼ miscellaneous expenses / transfer of deposit
The summary field contains information that can be used to determine the details of the transfer, such as withholding income tax.
[0282]
Finally, a borrowed material creating program according to the present invention will be described.
[0283]
The borrowed material creating program according to the present invention is a program for causing a computer to realize the function as the above-mentioned cash flow data processing device. In other words, the borrowed material creating device according to the present invention realizes at least the above-mentioned cash flow data creating function, and furthermore, has a sales list data creating function, a purchase list data creating function, a deposit data creating function excluding sales, and a payment data excluding purchasing. Creation function, borrowing / borrowing repayment schedule data creation function, cash accounting data (cash accounting book) creation function, bank-specific cash-in / pay-out list data creation function, bank-specific balance total data creation function, bank-in / out total data creation function, bank transaction This is a program for realizing a situation data creation function and / or a journal entry data (journal journal) creation function. The borrowed material creating program according to the present invention is a program for causing a computer to realize the function as the above-mentioned cash flow data processing device.
[0284]
In other words, the borrowing material creation program according to the present invention includes the financing material (data) creating function and the sales list as described above in the borrowing material creating apparatus having the hardware (computer) as shown in FIG. Table (data) creation function, payment list (data) creation function, purchase list (data) creation function, payment list (data) creation function, bill of exchange receipt (data) creation function, bill of exchange payment (data) Creation function, other payment schedule (data) creation function, expense and other payment table (data) creation function, borrowing list (data) creation function, borrowing repayment schedule (data) creation function, bank account book (data) creation Function, total accounting book (data) creation function, bank transaction status table (data) creation function, bank-specific daily balance (data) creation function, cash accounting book (data) creation function, and / or The other is a program for realizing the journal diary (data) creation function.
[0285]
The preferred embodiment of the present invention has been described above. However, the above-described embodiment is merely an example for describing the present invention, and is not intended to limit the scope of the present invention only to this embodiment. Those skilled in the art can implement the present invention in various other forms in which various modifications, improvements, modifications, simplifications, and the like are added to the above-described embodiment without departing from the gist of the present invention.
For example, in the above description, the cash flow is calculated every month, but may be calculated every predetermined period (for example, every week, every day, every half year, etc.). What period should be calculated may be determined for each user's financial environment.
[0286]
【The invention's effect】
ADVANTAGE OF THE INVENTION According to this invention, the time concerning preparation of a fund schedule can be reduced, and since a manager can concentrate on management more, realization of management which looks ahead is attained.
[0287]
Further, according to the present invention, since all the materials required for bank borrowing are linked and output by automatic calculation, the creation of borrowing materials (bank-submitted materials centering on three tables of borrowing) is simplified, and as a result, , The credit to the bank will increase dramatically.
[0288]
Further, according to the present invention, the output form can be used as it is as accounting data, so that the output form can be fully utilized for accounting, and the time and effort for recording slips and books is greatly reduced, and the efficiency of office work is reduced. Can be dramatically improved.
[0289]
Further, according to the present invention, an operation can be input by graphic information such as selection of an icon menu using a GUI (Graphical User Interface), so that anyone can easily operate and even a novice can use it. Therefore, even those who do not have accounting expertise can easily and quickly calculate the cash flow and can prepare three borrowing tables.
Note that a GUI (Graphical User Interface) refers to an interface that uses visual information such as graphics for operating a computer.
[Brief description of the drawings]
FIG. 1 is a hardware configuration diagram of an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 2 is a conceptual configuration diagram of an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 3 is a diagram schematically illustrating a flow of input data and an outline of a relationship between respective functions in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 4 is an image diagram of a menu screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 5 is an image diagram of a target year change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 6 is an image diagram of a menu screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 7 is an image diagram of a bank balance registration screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 8 is an image diagram of a bank addition screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 9 is an image diagram of a bank balance registration screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 10 is an image diagram of a default balance change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 11 is an image diagram of a bank balance registration screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 12 is an image diagram of a menu screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 13 is an image diagram of a menu screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 14 is an image diagram of a data backup screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 15 is an image diagram of a screen when “Restore from floppy disk” is clicked on the data backup screen in the embodiment of the borrowed material creating device and the borrowed material creating program according to the present invention.
FIG. 16 is an example of a sales list (order details) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 17 is an image diagram of a customer name selection screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 18 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 19 is an image diagram of a customer / product registration screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 20 is an image diagram of a customer / commodity deletion screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 21 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 22 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 23 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 24 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 25 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 26 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 27 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 28 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 29 is an image diagram of a deposit breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 30 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 31 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 32 is an example of a deposit list in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 33 is an image diagram of a payment list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 34 is an image diagram of a payment list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 35 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 36 is an image diagram of a deposit breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 37 is an image diagram of a deposit breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 38 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 39 is an image diagram of a deposit breakdown addition screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 40 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 41 is an image diagram of a deposit breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 42 is an image diagram of a bill input screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 43 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 44 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 45 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 46 is an image diagram of a payment details deletion screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 47 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 48 is an image diagram of a sales list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 49 is an image diagram of a payment confirmation list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 50 is an image diagram of a date input screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 51 is a purchase list in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention.
FIG. 52 is an image diagram of a supplier name selection screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 53 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 54 is an image diagram of a supplier / product registration screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 55 is an image diagram of a supplier / article deletion screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 56 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 57 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 58 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 59 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 60 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 61 is an image diagram of a payment breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 62 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 63 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 64 is an example of a payment list in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 65 is an image diagram of a payment list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 66 is an image diagram of a payment list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 67 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 68 is an image diagram of a payment breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 69 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 70 is an image diagram of a payment breakdown addition screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 71 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 72 is an image diagram of a payment breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 73 is an image diagram of a bill input screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 74 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 75 is an image diagram of a payment breakdown change screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 76 is an image diagram of a receivables selection screen in one embodiment of the borrowed material creating device and the borrowed material creating program according to the present invention.
FIG. 77 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 78 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 79 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 80 is an image diagram of a payment item deletion screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 81 is an image diagram of a payment breakdown screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 82 is an image diagram of a purchase list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 83 is an image diagram of a payment confirmation list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 84 is an example of another payment schedule in the embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 85 is an image diagram of another payment table screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 86 is an image diagram of another deposit registration screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 87 is an image diagram of another payment table screen in one embodiment of the borrowed material creating device and the borrowed material creating program according to the present invention.
FIG. 88 is an image diagram of another payment table screen in one embodiment of the borrowed material creating device and the borrowed material creating program according to the present invention.
FIG. 89 is an image diagram of another deposit change screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 90 is an image diagram of another payment table screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 91 is an image diagram of another payment table screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 92 is an image diagram of another deposit deletion screen in one embodiment of the borrowed material creating device and the borrowed material creating program according to the present invention.
FIG. 93 is an image diagram of another payment table screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 94 shows an example of an expense and other payment table (payment list of expenses etc.) in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention.
FIG. 95 is an image diagram of a date input screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 96 is an image diagram of an expense and other payment table screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 97 is an image diagram of an expense and other payment registration screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 98 is an image diagram of an expense or other payment change screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 99 is an image diagram of an expense and other payment deletion screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 100 is an example of a borrowed money list in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention.
FIG. 101 is an example of a borrowed money repayment schedule in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 102 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 103 is an image diagram of a borrowed money registration screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 104 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 105 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 106 is an image diagram of a borrowed money change screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 107 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 108 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 109 is an image diagram of a borrowed money deletion screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 110 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 111 is an image diagram of a borrowed money repayment plan screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 112 is an image diagram of a borrowed money list screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 113 is an example of a bill receivable book (bill receipt list) in an embodiment of a borrowed material creating apparatus and a borrowed material creating program according to the present invention.
FIG. 114 is an image diagram of a bill-of-receipt book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 115 is an image diagram of a bill discount input screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 116 is an image diagram of a bill-of-receipt book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 117 is an image diagram of a bill-of-receipt book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 118 is an image diagram of a screen when “cancel discount” is clicked on the bill-of-receipt book screen in one embodiment of the borrowed material creating apparatus and the borrowed material creating program according to the present invention.
FIG. 119 is an image diagram of a bill-of-receipt book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 120 is an image diagram of a bill-of-receipt book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 121 is an image diagram of a bill receivables balance (discount) screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 122 is an image diagram of a bill-of-receipt book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 123 is an image diagram of a bill receivables (endorsement) screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 124 is an example of a bill of exchange (payment note list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 125 is an image diagram of a bill of exchange book screen in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 126 is an example of a bank-specific account book (bank-acquired money list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 127 is an example of a bank-based account book (bank-acquired money list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 128 is an example of a bank-specific account book (bank-acquired money list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 129 is an example of a total accounting table (total deposit / withdrawal list) in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 130 is an example of a cash flow chart in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
FIG. 131 is an example of a bank transaction status table in an embodiment of a borrowed material creating device and a borrowed material creating program according to the present invention.
[Description of sign]
1 CPU
2 ROM
3 RAM
4 Hard disk
5 Keyboard
6 mice
7 Display
8 CD-ROM drive
9 Printer
10 Bus
20 Data input section
30 Data processing unit
31 Database
32 Data storage unit
40 Data output unit
100 Borrowed document creation device
200 CD-ROM

Claims (30)

Estimated sales data, estimated purchase data, estimated receipt data other than sales and borrowings, estimated withdrawal data other than purchase and repayment,
Once you have entered the expected repayment data,
A function to classify the income and expenditure into predetermined items, aggregate the amounts, and automatically create a fund schedule that is consolidated into one table,
A borrowed material creating device characterized by having: When the sales forecast data is input, a function of automatically creating a sales list showing order details,
The borrowed material creating device according to claim 1, further comprising: Based on the sales table, a function of automatically creating a payment list showing the payment result and / or the expected payment amount for each sales destination for each sales month;
The borrowed material creating device according to claim 2, further comprising: When the expected purchase data is input, a function for automatically creating a purchase list showing order details,
4. The borrowed material creating device according to claim 1, further comprising: A function of automatically creating a payment list showing payment results and / or scheduled payment amounts for each supplier based on the purchase list for each payment month;
The borrowed material creating apparatus according to any one of claims 1 to 4, further comprising: A function to automatically create a note book showing a list of bills to be received when receiving sales proceeds in bills,
The borrowed material creation device according to any one of claims 1 to 5, further comprising: When paying the purchase price by bill, a function to automatically create a bill of exchange showing a list of bills to be paid,
The borrowed material creating apparatus according to any one of claims 1 to 6, further comprising: A function to automatically create other payment schedules that show at least the payment date and the amount of payment for each payment source for payments other than sales and borrowing,
The borrowed material creating apparatus according to any one of claims 1 to 7, further comprising: A function to automatically create expenses and other payment tables showing at least the withdrawal date and withdrawal amount for each subject for withdrawals other than purchase / repayment of loans,
The borrowed material creating device according to any one of claims 1 to 8, further comprising: A function for automatically creating a borrowing list showing at least the borrowing balance for each borrowing date and / or each borrower,
The borrowed material creating apparatus according to any one of claims 1 to 9, further comprising: A function for automatically creating a repayment schedule for a borrowing, which shows at least a borrowing balance and a repayment date for each borrowing date and / or for each borrower,
The borrowed material creating apparatus according to any one of claims 1 to 10, further comprising: At least in chronological order based on the payment list, the payment list, the bill of receivables, the bill of payment, the other payment schedule, the expense and other payment schedule, and the borrowing repayment schedule. A function to automatically create a bank ledger that shows the deposit amount and withdrawal amount of each bank,
The borrowed material creating device according to claim 11, further comprising: A function of automatically creating a total balance table showing, in chronological order, at least the amount of money received from the bank and the amount of money withdrawn to the bank based on the bank account book,
13. The borrowed material creating apparatus according to claim 12, further comprising: A function for automatically creating the fund schedule based on the total balance table;
The borrowed material creating device according to claim 13, comprising: A function to automatically create a bank transaction status table showing at least the discount bill balance, short-term borrowing balance, long-term borrowing balance and deposit balance for each bank,
The borrowed material creating apparatus according to any one of claims 1 to 14, further comprising: When you enter the expected sales data, estimated purchase data, estimated incoming data other than sales and borrowings, estimated outgoing data other than purchased and borrowed repayments, and estimated borrowed repayment data, A borrowed material creation program, wherein a computer is provided with a function of automatically creating a fund schedule prepared by categorizing items into predetermined items, summing up amounts of money, and summarizing them in one table. 17. The borrowed material creating program according to claim 16, wherein when the expected sales data is input, a function of automatically creating a sales list showing order details is realized by a computer. 18. The computer according to claim 16, wherein a function of automatically creating a payment list showing payment results and / or scheduled payment amounts for each sales destination for each sales month based on the sales list is realized by a computer. Borrowed material creation program. 19. The borrowed material creation program according to claim 16, wherein a function of automatically creating a purchase list showing order details when the expected purchase data is input is realized by a computer. 17. The computer according to claim 16, wherein a function of automatically creating a payment list showing payment results and / or scheduled payment amounts for each supplier for each payment month based on said purchase list is realized. 20. The borrowed material creation program according to any one of the items 19 to 19. 21. The borrowed material creating program according to claim 16, wherein a function of automatically creating a note book showing a list of bills to be received when the sales amount is received as a bill is realized by a computer. 22. The borrowing material creating program according to claim 16, wherein a function of automatically creating a bill of exchange showing a list of bills to be paid when the purchase price is paid by a bill is realized by a computer. . 23. The computer according to any one of claims 16 to 22, wherein a function of automatically creating a payment schedule other than at least a date of payment and a payment amount for each payment source for a payment other than sales and borrowing is realized by a computer. Borrowing material preparation program described in section. 24. A computer having a function of automatically creating an expense or other payment table showing at least a withdrawal date and a withdrawal amount for each subject for withdrawals other than purchase / borrowing repayments. The borrowing material preparation program according to any one of the above. 25. The computer according to claim 16, wherein a function of automatically creating a borrowing list showing at least a borrowing balance for each borrowing date and / or each borrower is provided for the borrowing. Borrowed material creation program. 26. The computer according to claim 16, wherein a function of automatically creating a borrowing repayment schedule indicating at least a borrowing balance and a repayment date for each borrowing date and / or each borrower is realized by a computer. The borrowed material preparation program according to any one of the above. Based on the payment list, the payment list, the note receivable book, the payment note book, the other payment schedule, the expense and other payment table, and the borrowing repayment schedule, at least in chronological order. 28. The borrowing material creating program according to claim 26, wherein the computer is provided with a function of automatically creating a bank-specific accounting book showing the deposit amount and the withdrawal amount of each bank. 28. The borrowing material according to claim 27, wherein a function of automatically creating a total balance table showing at least the amount of money received from the bank and the amount of money to be paid to the bank in order of date based on the bank account book is realized by a computer. Creation program. 29. The borrowing material creating program according to claim 28, wherein a computer is provided with a function of automatically creating the fund schedule based on the total balance sheet. 30. The computer according to any one of claims 16 to 29, wherein a function of automatically creating a bank transaction status table showing at least a discount bill balance, a short-term borrowing balance, a long-term borrowing balance, and a deposit balance for each bank is realized. The borrowed material creation program described.

Images