JP4479945B2 - Cash flow management device and program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a cash flow management device and a program for managing cash flow.
[0002]
[Prior art]
In general, in a company, a store, etc., cash management as a management measure is periodically performed in order to accurately grasp the money in and out of management and take good measures such as fund procurement. In this case, conventionally, the payment schedule / payment schedule and the payment history / payment history are managed separately, and the payment schedule / payment schedule is managed as a predicted value in consideration of the past years. Yes. The same applies to the case where the cash flow management is performed by the information processing apparatus in addition to the case where the cash flow management is performed by the bookkeeping.
[0003]
[Problems to be solved by the invention]
However, managing the payment plan / payment schedule as a forecast value that takes into account the past years' results often does not match the actual cash flow (balance), and it is difficult to properly grasp the current cash flow status. there were.
It is an object of the present invention to input accurate sales / payment information for each transaction when the actual transaction occurs, so that an accurate cash flow statement based on the actual transaction can be confirmed before actual billing / payment is made. Is to do.
[0004]
[Means for Solving the Problems]
According to the first aspect of the present invention, for each of a plurality of business partners, at least information relating to the billing / payment deadline and a collection / payment method are stored as business partner information storage means, at least a scheduled date item, Cash flow statement storage means for storing balance item, partner code field indicating business partner, and planned amount field as scheduled records, and depending on user operation, business partner for credit sales or credit purchase, and credit sales Alternatively, the transaction input means for inputting the amount data of the purchase purchase and the supplier information storage means are accessed based on the supplier input by the transaction input means, and are associated with the input supplier. The information on the billing / payment due date of the record for each business partner and the collection / payment method are read from the business partner information storage means, and the current date being timed, Based on the billing / payment deadline information read from the supplier information storage means and the collection / payment method, For sales or purchases Calculate the expected date of payment or payment, calculated For sales or purchases Includes scheduled payment date data of payment or payment and amount data of credit sales or credits input by the transaction input means Cash flow statement A creation means for creating a scheduled record, and a creation means created by this creation means For sales or purchases Includes planned date data for receipts or payments and amount data for multiple sales or purchases Cash flow statement Storage control means for storing the schedule record in the scheduled date item and the scheduled amount item of the cash flow statement storage means, a period input means for inputting a display target period for displaying the cash flow statement according to a user operation, and this period input Including the scheduled date item corresponding to the display target period input by the means Cash flow statement An acquisition unit that reads and acquires a schedule record from the cash flow statement storage unit, and the acquisition unit that acquires the scheduled record. Cash flow statement Based on the scheduled record, the scheduled date data of the receipt or payment of the sales or purchase in the display target period, For sales or purchases Display means for displaying a cash flow statement screen showing a cash flow statement including money amount data for deposit or payment.
Furthermore, a program for causing a computer to function as the main means shown in the above-described invention according to claim 1 is provided (the invention according to claim 2).
[0012]
DETAILED DESCRIPTION OF THE INVENTION
An embodiment of the present invention will be described below with reference to FIGS.
FIG. 1 is a block diagram showing the overall configuration of an information processing apparatus with a cash flow management function in this embodiment.
This information processing apparatus is an office computer or the like having an application function for managing cash flow according to money in and out of a company organization. This cash flow management function is a sales / payment for each transaction input when an actual transaction occurs. Based on the information, an accurate cash flow statement corresponding to the actual transaction is displayed and output.
Prior to detailed description of the features of this embodiment, the hardware configuration of this embodiment will be described below.
[0013]
The CPU 1 is a central processing unit that controls the overall operation of the information processing apparatus in accordance with the operating system and various application software in the storage device 2. The storage device 2 stores an operating system, various application software, a database, character fonts, and the like, and is configured by a magnetic, optical, semiconductor memory, and the drive system thereof. The recording device 2 may have a configuration in which a removable storage medium such as a CD-ROM or DVD can be mounted in addition to a fixed memory such as a hard disk. The programs and data in the storage device 2 are loaded into a RAM (for example, static RAM) 3 as needed, or the data in the RAM 3 is saved in the storage device 2. Further, the CPU 1 can directly access and use programs / data of other electronic devices via the communication device 4, and can receive and receive downloads from other electronic devices via the communication device 4.
[0014]
On the other hand, the communication device 4, the input device 5, the display device 6, and the printing device 7, which are input / output peripheral devices, are connected to the CPU 1 through the bus line, and the CPU 1 performs these operations according to the input / output program. Control.
The communication device 4 is connected to a local communication network or a wide area communication network and controls data transmission / reception with other information processing devices. For example, a wired / wireless communication device including a communication modem, an infrared module, an antenna, and the like. It is a communication interface. The input device 5 is an operation unit that constitutes a pointing device such as a keyboard, a touch panel, a mouse, or a touch input pen, and inputs character string data and various commands. The display device 6 is a liquid crystal, CRT, or plasma display device that performs full-color display, and the printing device 7 is a non-impact printer or a dot impact printer such as thermal transfer or ink jet.
[0015]
FIG. 2 is a diagram showing various tables and files provided in the storage device 2.
In this storage device 2, in addition to the operating system and various application software, a supplier table 11, a cash flow statement file 12, an expense payment schedule creation table 13, and an inquiry character string file 14 which are features of this embodiment are provided. In addition, an automobile tax table 15 and a light automobile tax table 16 are provided as index tables.
[0016]
FIG. 3 is a diagram showing the contents of the supplier table 11.
This supplier table 11 stores and manages records by supplier including information on billing / payment deadlines and collection / payment methods for each supplier, and the contents can be arbitrarily changed as necessary. ing. The records for each business partner include “party code”, “partner name”, “billing / payment due date”, “collection / payment month”, “collection / payment date”, “collection / payment method”, Each item has a “Bill Site”.
[0017]
The “partner code” and “partner name” that make up this customer-specific record are supplier identification information, and “billing / payment due date”, “collection / payment month”, and “collection / payment date” are In the information on the billing / payment closing date, for example, in the case of “B Shokai”, the “billing / payment closing date” is “the last day of the month”, “collection / payment month” is “the month following the billing / payment” The case where the “collection / payment date” is “end of month” is illustrated.
The “collection / payment method” is information indicating the collection / payment method such as cash income / payment, bill collection / settlement, transfer, and the like. “Bill site” is information indicating a bill period.
[0018]
FIG. 4 is a diagram showing the contents of the cash flow statement file 12.
The cash flow statement file 12 centrally manages the receipt / payment schedule record and the receipt / payment actual record, and the receipt / payment schedule record is stored in the sales / payment for each transaction entered when the actual transaction occurs. The record is automatically created according to the payment / payment record when the payment / payment record (actual transaction) occurs for the payment / payment schedule record. Information.
Each record in the cash flow statement file 12 includes “schedule / actual category”, “schedule / actual date”, “cash balance category”, “cash balance summary category”, “party code”, “amount”, “actual amount”. , “Amount carried forward”, “Scheduled date for carrying forward”, and “Scheduled date for application”.
[0019]
In addition, every time a schedule record or a performance record is created, this record is additionally registered in the cash flow statement file 12. At that time, the planned record group and the actual record group are separately registered and registered, but of course, the planned record group and the actual record group may be mixed and registered separately, The registration form is arbitrary.
Further, in this case, each record in the cash flow statement file 12 includes, for example, “sales input”, “purchase input”, “annual expense schedule input”, “collection of receivables” as shown on the right side of FIG. ”,“ Trade bill collection ”,“ Payment of accounts payable ”,“ Bill settlement ”, etc.
[0020]
“Schedule / Actual classification” is information indicating whether the record is a planned record or an actual record, and among “Schedule / Actual date”, the scheduled date is the receipt / calculation calculated by referring to the supplier table 11. This is the scheduled date of payment, and the actual date is the date when the deposit / payment result occurs. A method for calculating the scheduled date will be described later. “Balance summary category” is information indicating deposit, bill deposit, bill payment, bill payment, salary, cash sales, tax and other charges. “Destination code” is information indicating a business partner. The other “amount”, “actual amount”, “amount carried forward”, “scheduled date for carrying forward”, and “scheduled date for application” will be described in detail with reference to FIGS. “Amount” is the planned / actual receipt / payment amount, “Actual amount” is the actual amount when an actual occurrence has occurred for the scheduled record, and “Amount carried forward” is carried over to the scheduled record. When it occurs, that is, when the receipt / payment result occurs for the expected receipt / payment record, the actual occurrence “date” is after the “schedule date” included in the expected record. In addition, when the actual “money amount” is less than the “money amount” included in the scheduled record, this is information indicating the balance carried over.
[0021]
In the present embodiment, when the carry-over is scheduled, a new schedule record including the balance of the carry-over and the next date of payment / payment due to the carry-over is created in this embodiment. In this case, the information indicates the scheduled date of the next deposit / payment set in the record in order to reflect that the carry-over has occurred with respect to the original schedule record.
“Scheduled date for application” is information that is set in the actual record when an actual result occurs for the planned record. In this embodiment, the actual result for the schedule is The actual record is displayed and output as a cash flow statement in place of the planned record, and the scheduled date on which the planned record is not output is shown.
[0022]
5 to 7 are diagrams for explaining the cash flow statement file 12 in detail based on specific examples.
FIG. 5 shows information for each supplier set in the supplier table 11 in advance as “closing date: 20 days”, “collection month: month following billing month”, “collection date: 20 days”, “collection method”. ： Cash ”and an example of sales of“ 1 million yen on July 5 ”and“ 500,000 yen on July 10 ”. In this case, “August 20” is calculated based on the collection month and date corresponding to the business partner, and the amount is “1,500,000 yen”.
The schedule record created in this way is registered in the cash flow statement file 12. This schedule record includes “schedule / actual class = 1 (plan)”, “schedule / actual date = 2010820”, and “cash balance class = 1”. (Revenue), “Balance Summary Category = 02 (Deposit)”, “Amount = 1,500,000”.
[0023]
FIG. 6 shows a case where a deposit record has occurred on “August 15”, which is before the scheduled deposit date, for the scheduled record registered in the cash flow statement file 12 as described above. An actual record created based on the actual result is additionally registered in the cash flow statement file 12. In this case, the actual record includes “schedule / actual category = 2 (actual)”, “plan / actual date = 20010815”, “account balance = 1 (income)”, “account summary category = 02 (payment)”, “Amount of money = 800,000” and “Scheduled date for application = 20010820”.
Further, in the original schedule record corresponding thereto, the “actual amount” is “800,000”, and it is recorded that there is a deposit record of “amount = 800,000” with respect to the schedule. In this case, “Amount-Actual amount = Remaining amount (700,000)” of the scheduled record is set, but in the actual amount of payment before the scheduled date of payment, no carry-over is performed even if there is a remaining amount.
[0024]
FIG. 7 shows a case where a part of the balance is deposited on the scheduled deposit date, and “500,000” is part of the “balance (700,000)” on “August 20” on the scheduled deposit date. "Is deposited, the remaining" 200,000 "is carried over to the next time. At this time, a new record is created based on the current deposit record and is additionally registered in the cash flow statement file 12, and the “billing / payment due date” set in the supplier table 11 corresponding to the supplier. ”,“ Recovery / Payment Month ”,“ Recovery / Payment Date ”,“ Collection / Payment Method ”, and“ Bill Site ”to calculate the next payment date. A new schedule record for the next time including “September 20” and the balance “200,000” is created and additionally registered in the cash flow statement file 12.
[0025]
In this case, the “actual amount” in the original scheduled record is updated from “800,000” to “1,300,000”, and “200,000” is set as the “carry-over amount”. Furthermore, in order to perform carry-forward management, the next scheduled deposit date “September 20” is set in “scheduled carry-forward scheduled date” in the original scheduled record.
In this embodiment, when there is a deposit after the next scheduled deposit date and a balance is generated, automatic carry-over similar to the above is performed. In other words, in the above example, even if there is a deposit of less than “200,000” on “September 20”, the carry-over is performed, and the same applies to the deposit before the next scheduled deposit date. As in the case of FIG. 6 described above, even if the balance is generated, automatic carry-over is not performed.
[0026]
FIG. 8 is a diagram showing the contents of the expense payment schedule creation table 13.
This expense payment schedule creation table 13 is a table used when creating an expense payment schedule record, and stores information for inquiring the generation unit and the payment amount for each expense. This expense payment schedule creation table 13 has items of “expense type”, “expense”, “occurrence unit”, “fixed month”, “amount input method”, and “selection list table”, and “expense type”. “Wage salary”, “Tax”, “Lease fee”, “Land rent”, “Expense” indicates the detailed classification of expenses, for example, “Salary”, “Bonus”, “Automobile tax” "Light vehicle tax", "Lease fee", etc. “Occurrence unit” indicates the occurrence of expenses “1: every month”, “2: designated month”, “3: fixed month”.
[0027]
“Fixed month” indicates a specific fixed month, “May” is set as the fixed month corresponding to “Automobile tax”, and “April” is set as the fixed month corresponding to “Light vehicle tax”. Is set.
“Amount Input Method” indicates “1: Direct Input”, “2: Select Input from List Table”, and “Amount Input Method” is “2: Select Input from List Table”. This indicates that the vehicle tax table 15 or the light vehicle tax table 16 defined in the “table” item is searched, and the corresponding amount should be selected and input from among them.
In the inquiry screen generated based on the contents of the expense payment schedule creation table 13, an expense payment schedule record including payment time and payment amount for each expense is created according to the inquiry result entered in the screen, This expense payment schedule record is additionally registered in the cash flow statement file 12.
[0028]
FIG. 9 is a diagram showing a part of an inquiry screen generated based on the contents of the expense payment schedule creation table 13.
In this inquiry screen, “Expense type for creating expense plan: January to December” is displayed in a list corresponding to “Expense type” indicating the expense schedule to be created and “Inquiry content”. In this case, “inquiry content” is an inquiry sentence generated by combining information acquired from the expense payment schedule creation table 13 and information acquired from the inquiry character string file 14. For example, “salary” is acquired from the expense payment schedule creation table 13, “is there any payment? How much is the payment” from the query string file 14, and they are combined to obtain “salary payment” Is there a query?
[0029]
Next, the operation algorithm of the information processing apparatus in this embodiment will be described with reference to the flowcharts shown in FIGS. Here, each function described in these flowcharts is stored in the form of a readable program code, and operations according to the program code are sequentially executed. It is also possible to sequentially execute operations according to the program code transmitted via the transmission medium. That is, in addition to the recording medium, an operation specific to this embodiment can be executed using a program / data supplied externally via a transmission medium.
[0030]
FIG. 10 is a flowchart showing the overall operation of the main part of the information processing apparatus.
First, the CPU 1 determines the selection instruction content arbitrarily selected and designated from the processing menu screen (step A1). Here, when the input of sales / purchase is selected (step A2), the payment / payment schedule creation process of FIG. 11 is executed (step A3), and when the input of expense payment is selected (step A3) Step A4), the expense payment schedule creation process of FIG. 12 is executed (step A5).
If the input of payment / payment record is selected (step A6), the deposit / payment record update process of FIG. 13 and FIG. 14 is executed (step A7), and the cash flow statement display is selected. (Step A8), cash flow statement display processing is executed (Step A9).
[0031]
FIG. 11 is a flowchart detailing the deposit / payment schedule creation process.
First, the CPU 1 selects processing of cash sales / payment sales or cash purchase / payment purchase (step B1), and acquires the input business partner, sales amount / purchase amount, etc. (step B2). When the processing selection is cash sales / cash purchase (step B3), cash income / payment has already occurred due to sales / purchase, so a scheduled record is not created and the cash sales receipt / payment amount is set. A corresponding performance record is created and additionally registered in the cash flow statement file 12 (step B4).
In this case, the lowest record in FIG. 4 shows the actual record corresponding to the cash sales receipt, “01: Cash sales” is set in “Balance summary category”, and “Scheduled date for application” The current date is set.
[0032]
On the other hand, when the process selection is “schedule sales / purchase purchase” (step B3), the customer table 11 is accessed to acquire various item data necessary for creating a scheduled record (step B5). In other words, the "billing / payment due date", "collection / payment month", "collection / payment date", "collection / payment method", and "bills site" items associated with this business partner are acquired. To do.
Then, it is determined whether the “collection / payment method” is cash or transfer (step B6). If it is cash or transfer, the current date is acquired, and the current date and the “billing / payment due date”, “collection” / Payment month "and" collection / payment date ", the payment / payment scheduled date is calculated (step B7). In this case, for example, as shown in FIG. 3, in “B store or D store”, “the last day of the month following the billing / payment month” is calculated as the scheduled date. Then, a schedule record including the scheduled date and amount is created and additionally registered in the cash flow statement file 12 (step B8).
[0033]
When the “collection / payment method” is a bill (step B9; Yes), the process proceeds to step B10, and in addition to the current date, “billing / payment due date”, “collection / payment month”, “collection / payment date” ”,“ Collection / payment method ”, and“ bills site ”to calculate the expected payment / payment date (step B10). In this case, for example, in the case of credit sales for “E store” shown in FIG. 3, a promissory note with a two-month term is received at “the last day of the month following the billing / payment month”, and payment is made two months after receiving the bill Scheduled date. Then, a schedule record including the scheduled date and amount is created and additionally registered in the cash flow statement file 12 (step B8). Thereafter, the above-described operation is repeated (steps B1 to B11) until an end instruction is issued (step B11).
[0034]
FIG. 12 is a flowchart detailing the expense payment schedule creation process.
First, the CPU 1 searches the expense payment schedule creation table 13 and the inquiry character string file 14 (step C1) and creates an inquiry screen. At this time, one record is designated from the head of the expense payment schedule creation table 13. The “expense” in the designated record is read out, and “is there any payment” read out from the inquiry character string file 14 to create an inquiry sentence and display it in the inquiry screen (step 2). The inquiry result input in the inquiry screen is acquired (step C3). If payment is made (step C4), the “occurrence unit” is read from the specified record to determine whether it is “specified month” (step C5). If it is the designated month, a query sentence “What month do you want to pay?” Is read from the query string file 14 and displayed (step C6), and the input query result is acquired and stored (step C7).
[0035]
Next, “amount input method” is read from the designated record to determine the input method (step C8). If “1: Direct”, an inquiry sentence “How much is the payment” from the query string file 14 Is read and displayed (step C9), and the input query result is acquired and stored (step C10).
If the “amount input method” is “selection from list” (step C8), the “selection list table” is acquired from the record, and the designated vehicle tax table 15 or light vehicle tax is obtained. After the table 16 is read and displayed (step C11), the input selection result is acquired and stored (step C12).
[0036]
Further, based on the “occurrence unit” of the designated record, processing is performed to update the contents of the cash flow statement file 12 according to “every month”, “designated month”, and “fixed month” (steps C13 to C16). That is, if the “occurrence unit” is “monthly” (step C13), a payment schedule record having the input answer amount as the expense payment amount for each month is created and additionally registered in the cash flow statement file 12 (step S13). C14). If the “occurrence unit” is “specified month” (step 13), a payment schedule record is created with the input answer amount as the expense payment amount for the specified month, and additionally registered in the cash flow statement file 12 ( Step C15), if it is “fixed month” (step C13), a payment schedule record having the input answer amount as the expense payment amount for the fixed month is created and additionally registered in the cash flow statement file 12 (step C16). .
Then, it is checked whether all records in the expense payment schedule creation table 13 have been designated (step C17). If not, the next record is designated (step C18), and the above operation is repeated thereafter (step C17). C1-C18).
[0037]
13 and 14 are flowcharts detailing the deposit / payment record update process.
First, when deposit / payment record information is input (step D1), the CPU 1 accesses the cash flow statement file 12 and selects and designates a corresponding scheduled record (step D2). Then, based on the actual information input this time, a new actual record is created and additionally registered in the cash flow statement file 12 (step D3), and the schedule corresponding to the “scheduled target date” in this actual record The “scheduled date” of the record is set (step D4).
Next, “Amount” in the actual record is set to “Actual amount” in the corresponding scheduled record (step D5). Then, “schedule date” is acquired from the schedule record (step D6), and “amount” and “actual amount” are acquired (step D7).
[0038]
Then, the process proceeds to step D8 in FIG. 14, where “amount-actual amount” is calculated based on “amount” and “actual amount” acquired from the scheduled record, and whether the value is greater than “0”. In other words, it is checked whether there is a balance or a part of the deposit / payment. If there is no balance, the process proceeds to step D14. If there is a balance, the actual occurrence date (current date) is compared with the “scheduled date” obtained from the scheduled record, and the “actual occurrence date” It is checked whether or not “≧ scheduled date”, that is, whether the deposit / payment results before the scheduled deposit / payment date (step D9).
[0039]
Here, when a record is generated before the scheduled date (step D9), even if there is a balance, the process proceeds to step D14 without carrying over, but when the record is generated after the scheduled date (step D9). On the condition that the result is not expense payment, the customer table 11 is searched based on the “party code” of the customer, and the corresponding “billing / payment due date”, “collection / payment month”, The “collection / payment date” is acquired, and the next scheduled date for the balance is calculated (step D10). That is, the next payment / payment scheduled date is calculated with reference to the supplier table 11 with the “scheduled date” in the scheduled record as a reference.
[0040]
The next scheduled record including the next “scheduled date” and “remaining balance” calculated in this way is newly created and additionally registered in the cash flow statement file 12 (step D11). Then, the calculated next scheduled payment / payment date is set in the “scheduled carry-forward date” in the original scheduled record, and the “amount-actual amount = remaining balance” is set in the “carry-over amount” in the original scheduled record. "Is set (step D13).
Thereafter, the above-described operation is repeated (steps D1 to D14) until an end instruction is issued (step D14).
[0041]
FIG. 15 and FIG. 16 are flowcharts showing processing for displaying the cash flow schedule / actual details based on the cash flow statement file 12 created as described above.
First, when “year / month” arbitrarily specified as a display target is input (step E1), the CPU 1 stores all scheduled records and actual records corresponding to the specified “year / month” in a cash flow statement file. 12 (step E2). Then, one of the corresponding records is selected and designated (step E3), and the “schedule / actual category” is determined as “1 = plan” (step E4), and “2 = actual”. If there is, the result record is extracted as a display target (step E5).
[0042]
On the other hand, if the “schedule / actual result category” is “1 = plan” (step E4), the “carry forward amount” is read from the schedule record to check whether “carry forward amount = 0” (step E6). If “carry forward amount = 0”, “amount” and “actual amount” in the scheduled record are read to check whether “amount> actual amount” (step E7). If “Amount> Actual amount”, this is a condition (Steps E6, E7), and this scheduled record is extracted as a display target (Step E8). That is, a scheduled record that has no carryover and has a remaining amount (amount> actual amount) is set as a display target. Then, in order to identify the actual record and the scheduled record, the planned record is shaded (step E9).
Hereinafter, by repeating the above-described operation for all records corresponding to the designated year and month (steps E1 to E10), all the actual records are to be displayed, and the scheduled records have no carryover and the remaining (amount) > Only scheduled records with> (actual amount) are to be displayed.
[0043]
After the display object is extracted in this way, the process proceeds to step E11 in FIG. 16, where the cash balance statement form is read, and the monthly initial balance is read (step E12). Then, one of the record records to be displayed is selected and designated (step E13), and the “schedule / actual result category” of the designated record is referred to determine whether it is an actual record (step E14). Here, if it is an actual record, “Summary”, “Destination”, “Amount” are extracted from the record to create display data (Step E15), and “Balance / Division” is determined (Step E16). The balance is calculated based on the determination result (step E17). In this case, for the first record, the “amount” is adjusted according to the “balance category” with respect to the initial balance of the month, but for the second and subsequent records, the “ Calculated by adding or subtracting the “amount” according to the “cash balance”. Further, based on the determination result of the “balance category”, “summary”, “destination”, “amount”, and “balance” as display target items are arranged in the corresponding income list / expenditure list in the cash flow statement form. (Step E18).
[0044]
On the other hand, if the designated record is a scheduled record (step E14), “summary” and “destination” are extracted from the record to create display data (step E20), and “amount”, “actual amount” Is extracted, “amount-actual amount” is calculated, and the remaining amount which is the calculation result is created as a display target item (step E21). Then, the “balance category” is discriminated (step E16), the balance is calculated based on the discrimination result (step E17), and the “summary”, “partner”, “remaining amount”, and “balance” are calculated. It arrange | positions to the corresponding income list / expenditure list in a detailed form (step E18).
When the display process for one record is finished, it is determined whether there are still unselected records (step E19), and the above-described operation is repeated until all the display target records are selected (steps E14 to E21). When the cash flow statement list is created in this way, it is displayed and output (step E22).
[0045]
FIG. 17 is a diagram showing a display example of a cash flow statement list.
This cash flow statement list is created based on the contents of the cash flow statement file 12 shown in FIG. Further, this cash flow statement list (monthly) is a case where the year / month “June 2001” is designated, and in the header part, in addition to the designated year / month, the initial balance “1,500,000”, Today's date "June 21, 2001" is displayed. The detail section is divided into “date”, “income list”, “expenditure list”, and “balance”, and the income list and expenditure list are “explanation”, “destination”, “amount”. It is divided into items. Here, the hatched part (shaded part) given in the detail part indicates a scheduled record, and the others indicate all record records.
[0046]
Here, in the cash flow statement file 12 shown in FIG. 18, “partner code: 0011 = G firm”, “partner code: 0012 = H firm”, “partner code: 0013 = J store”, “partner code” : 0014 = K store ”.
In addition, in the cash flow statement list (monthly) shown in FIG. 17, each “balance” in the detail portion is a value obtained by adding the “amount” to the “balance” for the previous time in the case of income, In this case, the “amount” is subtracted from the “balance” for the previous time.
[0047]
In this cash flow statement file 12, the first record of the schedule, that is, the record of “scheduled date = 20010605” and “destination code: 0011 = G Shokai” is that “amount = 500,000”. Since “Actual amount = 450,000” and “Amount carried forward = 50,000” are generated, this scheduled record is not displayed. Further, the next scheduled record created by this carry-over becomes “scheduled date = 200010705” and is carried forward to “next month = 20010705”, so the designated year / month “June” is not displayed. ing. That is, the schedule record is displayed after July.
[0048]
Further, the record of “scheduled date = 20010630” and “destination code: 0014 = K Shokai” is “actual amount = 190,000” in contrast to its “amount = 210,000”. However, as in the case of FIG. 6 described above, “actual occurrence date ≧ scheduled date”, “carry forward amount = 0” of the record is kept, and “amount> actual amount”. The record becomes a display target and is shaded in the cash flow statement list as shown in FIG. In this case, “amount-actual amount = 20,000” is displayed in the item “amount” of the scheduled record.
[0049]
Further, a scheduled record of “personnel expenses” which is a monthly expense is also displayed, and “summary = personnel expenses” and “amount = 800,000” are displayed in the expenditure list of the detail section.
In such a cash flow statement list, as for the cash flow in June, it is only necessary to confirm the “balance” in the last line. The balance at the beginning of June was “1,500,000 yen” At the end of the balance, the balance becomes “410,000 yen”, and it is understood that it is necessary to raise the amount of “410,000 yen”.
Note that the year / month level is not limited to the current month, and even when the month after July of the next month is designated, a cash flow statement list for the designated month can be obtained by the same operation as described above.
[0050]
As described above, in this embodiment, the CPU 1 performs "partner code", "partner name", "billing / payment due date", "collection / payment month", "collection / payment date", " Referring to the supplier table 11 storing the “collection / payment method” and “bill site”, the “billing / payment lock” corresponding to the supplier according to the sales / payment information for each transaction input when the actual transaction occurs. Date, “collection / payment month”, “collection / payment date”, “collection / payment method”, etc. are acquired to calculate the expected deposit / payment date, and includes this scheduled date and the expected deposit / payment amount Since the schedule record is created, stored and managed in the cash flow statement file 12, and displayed and output, the actual billing / payment is made simply by inputting the sales / payment information for each transaction when the actual transaction occurs. Before, based on actual transactions It was possible to confirm the exact funding specification, because it is not as in the prior art predicted values, it is possible to accurately grasp the funding situation at the present time.
[0051]
In this case, when the payment / payment record is generated for the schedule together with the schedule record of payment / payment, a record of the record related to the record is created and stored in the cash flow statement file 12, and the schedule record and record are recorded. Since the cash flow details including records are displayed and output, it is possible to centrally manage the schedule and actual results, and the cash flow details including the schedule and actual results make it easier to compare and control the current cash flow status. It becomes possible to grasp accurately.
[0052]
In addition, when the year / month indicating the display target period is designated, each record corresponding to the designated year / month is acquired from the cash flow statement file 12, and is displayed and output as a cash flow statement corresponding to the designated period. Each record in the cash flow statement file 12 can be output by an arbitrarily designated year and month, and it becomes possible to easily manage cash flow by period such as the current month, the next month, and the like.
In addition to outputting the schedule record in which the actual record has not occurred among the scheduled records in the cash flow statement file 12, the actual record for the schedule is displayed and output in place of the planned record. Therefore, in addition to outputting all the record records, it is also possible to output a scheduled record in which no record has been generated, thereby enabling more realistic cash management.
[0053]
The cash flow statement form is divided into an income list / expenditure list, and deposit / payment is determined based on the scheduled record and actual record, and each record is determined based on the determination result to the corresponding income list / Since the balance is calculated and output based on the deposit / payment amount and the cash flow details including this balance are displayed and output, the misunderstanding of deposit / payment can be prevented. It is possible to easily check the cash amount by the balance.
[0054]
When the receipt / payment result occurs for the scheduled record, the date of occurrence of the actual result is after the scheduled date included in the scheduled record, and the amount of the actual result is included in the scheduled record. If the amount is less than a certain amount, the next deposit / payment scheduled date for the balance carried forward is calculated, and the next scheduled record including this scheduled carry-forward date is created and stored in the cash flow statement file 12 Even if it is the next scheduled carry-over, it can be confirmed early. For example, when the records in the cash flow statement file 12 are output by the year and month specified arbitrarily, the next carry-over schedule carried forward one month ahead, two months ahead, etc. not included in the current month It is possible to confirm early by simply specifying the year and month.
[0055]
In the inquiry screen generated based on the contents of the expense payment schedule creation table 13 and the query character string file 14 and based on the contents of the expense payment schedule creation table 13 and the inquiry character string file 14, the query result entered in the screen The payment schedule record of expenses including payment time and payment amount for each expense is created according to the above, so that payment schedule information for expenses can be easily created in an inquiry format, and expenses are generated in companies, stores, etc. Even if they differ from each other, it is possible to make a general inquiry about information relating to a common expense that is generally generated, and the payment schedule record of this expense can be stored and managed in the cash flow statement file 12.
[0056]
In the above-described embodiment, the year / month is specified as the display target period, but the period is arbitrary, such as the second half of the year, and the cash flow details are displayed in addition to displaying the list, It may be displayed in a graph or printed out.
In addition, the above-described embodiment is not limited to the stand-alone type, and each component is physically separated into two or more cases, such as a wired transmission path such as a communication line or a cable, radio waves, microwaves, infrared rays, etc. A distributed computer system that transmits and receives data via a wireless transmission path may be configured.
[0057]
On the other hand, a recording medium (for example, a CD-ROM, a floppy disk, a RAM card, etc.) on which a program code for executing each of the above-described units is recorded may be provided to the computer.
That is, a recording medium having a computer readable program code, and at least a supplier information storage unit that stores at least information on a billing / payment due date and a collection / payment method as supplier information for each supplier. , According to the sales / payment information for each transaction input when the actual transaction occurs, obtain information on the billing / payment due date and collection / payment method corresponding to the business partner, and calculate the expected payment / payment date , A function for creating schedule information including the scheduled date and the expected deposit / payment amount, a function for storing and managing the created deposit / payment schedule information as a cash flow statement, and obtaining each schedule information and cash flow statement And a computer-readable recording medium storing a program for realizing the function of outputting Good.
[0058]
【The invention's effect】
According to this invention (invention described in claim 1), by referring to the supplier information storage means for storing the information on the billing / payment due date and the collection / payment method for each supplier, it is input when an actual transaction occurs. The Multiply sales or purchases Information on the billing / payment due date and collection / payment method corresponding to the customer according to the customer's account and the amount data of the sales or purchase For sales or purchases Calculate the expected deposit / payment date and Payment / payment of premium sales or premium purchases Scheduled date and For sales or purchases Includes deposit / payment amount Scheduled record for cash flow statement Is created, stored and managed as a cash flow statement, and it is output, so just enter the sales / payment information for each transaction when the actual transaction occurs. Therefore, it is possible to confirm an accurate cash flow statement based on the above, and since it is not a predicted value as in the past, it is possible to accurately grasp the current cash flow situation.
[Brief description of the drawings]
FIG. 1 is a block diagram showing the overall configuration of an information processing apparatus with a cash flow management function.
FIG. 2 is a view showing various tables and files provided in the storage device 2;
FIG. 3 is a view showing the contents of a supplier table 11;
FIG. 4 is a view showing the contents of a cash flow statement file 12;
FIG. 5 is a diagram for explaining the cash flow statement file 12 in detail based on a specific example;
FIG. 6 is a diagram for explaining the cash flow statement file 12 in detail based on a specific example; .
FIG. 7 is a diagram for explaining the cash flow statement file 12 in detail based on a specific example;
FIG. 8 is a view showing the contents of an expense payment schedule creation table 13;
FIG. 9 is a diagram showing a part of an inquiry screen generated based on the contents of the expense payment schedule creation table 13;
FIG. 10 is a flowchart showing the overall operation of the main part of the information processing apparatus.
FIG. 11 is a flowchart detailing the deposit / payment schedule creation processing of FIG. 10;
12 is a flowchart detailing the expense payment schedule creation processing of FIG. 10;
FIG. 13 is a flowchart detailing the deposit / payment record update process of FIG. 10;
FIG. 14 is a flowchart showing a deposit / payment record update process continued from FIG. 13;
FIG. 15 is a flowchart showing processing for displaying a cash flow schedule / actual details based on a cash flow statement file 12;
FIG. 16 is a flowchart illustrating the cash flow schedule / actual result processing following FIG. 15;
FIG. 17 is a view showing a display example of a cash flow statement list.
FIG. 18 is a diagram exemplifying the contents of a cash flow statement file 12 that is a creation source of the cash flow statement list of FIG. 17;
[Explanation of symbols]
1 CPU
2 storage devices
4 communication devices
5 input devices
6 Display device
7 Printing device
11 Supplier table
12 Cash flow statement file
13 Expense payment schedule creation table
14 Query string file
15 Car tax table
16 Light vehicle tax table

Claims (2)

A supplier information storage means for storing at least information on a billing / payment due date and a collection / payment method as a supplier-specific record for a plurality of suppliers;
Cash flow statement storage means for storing at least a scheduled date item, a balance category item, a partner code item indicating a business partner, and a scheduled amount item as a scheduled record;
A transaction input means for inputting a sales partner or a purchase supplier and a charge sales or purchase amount data in accordance with a user operation;
Based on the business partner input by the business transaction input means, the business partner information storage means is accessed, and information on the billing / payment due date of the business partner record associated with the input business partner and collection / payment reading out method from the client information storage means, based on the timed current and date are information and recovery / Payment billing / payment closing date read from the client information storage means, multiplying the sales or Kaketsukamatsu Calculate the payment / payment scheduled date data, and calculate the calculated sales / payment receipt / payment date data, and the sales / payment amount data entered by the transaction input means, Creating means for creating a schedule record of cash flow statement including
The schedule record of the cash flow statement including the scheduled date data of the receipt or payment of the premium sales or purchase and the amount data of the premium sales or purchase created by the creation means is the scheduled date of the cash detail storage means. Storage control means for storing items and scheduled amount items;
A period input means for inputting a display target period for displaying a cash flow statement according to a user operation;
An acquisition unit that reads and acquires the schedule record of the cash flow statement including the schedule date item corresponding to the display target period input by the period input unit;
Based on the schedule record of the cash flow statement acquired by the acquisition means, the scheduled date data of the receipt or payment of the sales or purchase in the display target period, and the amount of the receipt or payment of the sale or purchase Display means for displaying a cash flow statement screen showing a cash flow statement including data,
A cash management apparatus characterized by comprising: Computer
Means for storing at least information relating to the billing / payment deadline and collection / payment method in a supplier information storage means as a supplier-specific record for a plurality of suppliers;
Means for storing at least a scheduled date item, a balance category item, a partner code item indicating a business partner, and a scheduled amount item as a scheduled record in a cash flow statement storage unit;
In response to user operation, a means to input a transaction input means with a customer of charge sales or charge purchase and amount data of charge sales or charge purchase,
Based on the business partner input by the business transaction input means, the business partner information storage means is accessed, and information on the billing / payment due date of the business partner record associated with the input business partner and collection / payment reading out method from the client information storage means, based on the timed current and date are information and recovery / Payment billing / payment closing date read from the client information storage means, multiplying the sales or Kaketsukamatsu to calculate the expected date data of payment or payment of the entrance, and the scheduled date data of payment or payment of hanging sales or KaketsukamatsuIri that has been calculated, and the amount of money multiplied by sales or KaketsukamatsuIri data entered by the transaction input means Creation means to create a planned record of cash flow statement including
The schedule record of the cash flow statement including the scheduled date data of the receipt or payment of the credit sales or purchase and the amount data of the premium sales or purchase created by the creation means is the scheduled date of the cash detail storage means. Storage control means for storing items and scheduled amount items;
Means for causing a period input means to input a display target period for displaying a cash flow statement according to a user operation;
An acquisition means for reading out and obtaining a schedule record of the cash flow statement including the schedule date item corresponding to the display target period input by the period input means from the cash flow statement storage unit;
Based on the schedule record of the cash flow statement acquired by the acquisition means, the scheduled date data of the receipt or payment of the sales or purchase in the display target period, and the amount of the receipt or payment of the sale or purchase Display means for displaying a cash flow statement screen showing a cash flow statement including data,
Program to function as.

Images