JP2965944B2 - Funding processing system, funding processing method, and recording medium recording funding processing execution program - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a funding processing system, a funding processing method, and a recording medium on which a funding processing execution program is recorded. More specifically, a cash-flow processing system and a cash-flow processing that can easily execute the processing of accounting data relating to cash-flow, such as a process of creating a cash-flow performance table, a cash-payment table, and a cash-flow monthly transition table, based on a normal journalizing operation. The present invention relates to a method and a recording medium on which a funding processing execution program is recorded.

[0002]

2. Description of the Related Art In a general accounting system,
Inputs data related to various accounting processes, such as transfer slips, deposit slips, and withdrawal slips, and performs journal processing in accordance with the prescribed accounting rules. Journal journals, general ledgers, trial balances, profit and loss statements Generate various accounting data. For example, the accounting data associated with the payment processing due to sales that occur daily, the withdrawal processing due to expenditures, the transfer processing due to the payment of salary, etc. are sequentially input by predetermined input means, and the data processing means executes the processing of the input data. Generate various accounting data. Monthly or semi-annual,
The closing process for each fiscal year is executed, the monthly accounting data is determined, the fiscal year closing process, and the like are performed. The result is displayed on a display as necessary, or output as paper by a printer or the like.

An important item of such accounting processing is data processing relating to cash flow. This is data processing for the purpose of grasping and managing fluctuations, changes, and the like of cash-related items such as cash, deposits, and securities. This cash flow data processing includes, for example, a process of creating a cash flow performance table, a fund balance table, a cash flow monthly transition table, and the like. This is generated by judging the contents of the counter account of the journal and the increase / decrease of the fund, etc., and summing up, when various kinds of funding items are included in the journal data generated or scheduled to be generated daily.

[0004] For example, when a salary account is debited and a deposit account is credited, it is determined that the funds have decreased due to "personnel expenses expenditure", and this decrease in funds is recorded. If the deposit account is debited and the short-term borrowing is credited, it is determined that an increase in funds has occurred due to the “borrowing of short-term borrowing”, and these are counted. The funding data processing is to calculate such an increase or decrease in the fund based on the journal data and create various kinds of tabulation tables and the like.

[0005] However, the creation of a cash flow performance table, etc.
Not everyone can process data related to cash flow, and it can be created only by specialists who have knowledge of journals and the classification of each journal subject in cash flow aggregation. is there. Therefore, in the conventional accounting process, a specialist is currently processing the cash flow data based on the journal data and the like. Under such circumstances, there is a demand for a system that allows non-specialists without specific knowledge to easily perform funding data processing. In addition, in the conventional accounting process, it is inevitable that the time and effort required to aggregate the funding data due to the increase in the number of journal data is inevitable. There is a demand for a system that can be executed by a house and that reduces the processing of processing the cash flow data itself.

[0006]

SUMMARY OF THE INVENTION A cash-finish processing system, a cash-finish processing method, and a recording medium on which a cash-finish processing execution program is recorded according to the present invention solve the above-mentioned problems in the cash-financing totalization described above, An object of the present invention is to make it possible to easily execute processing relating to funding data, such as creation.

Further, the present invention provides a funding processing system, a funding processing method, and a funding processing execution program capable of automatically creating funding-related data such as a funding record table and a cash balance table based on daily journalizing operations. An object of the present invention is to provide a recording medium on which is recorded.

[0008]

In order to achieve the above object, a cash flow processing system according to the present invention comprises a data input means for inputting accounting data, and a data processing means for processing the accounting data input in the data input means. And a master database accessible by the data processing means, and a storage means for storing processing data processed by the data processing means, wherein the master database includes a cash management code for each of the various cash management names in the cash management processing. And a cash flow master table that has a cash flow code to be set when a cash item is set to the offsetting account of journal data, and a cash flow master table that individually corresponds the cash flow code to each accounting item for which journal processing is performed. The data processing means is provided by the data input means. Whether or not the input accounting data includes a funding subject is determined based on a table in which whether or not the subject is a funding subject for each subject, and if it is determined that the funding subject is included, The present invention is characterized in that it is configured to execute a process of assigning the selected cash flow code to the input accounting data based on the registration data in the subject master table held in the master database.

Further, in the cash flow processing system of the present invention, the cash flow master table is set so that a cash flow code corresponds to each of the cash flow names.
Furthermore, a feature is that a revenue and expenditure category indicating the contents of income and expenditure and an income and expenditure indicating distinction between incoming and outgoing are set for each of the cash flow names.

Further, in the cash flow processing system of the present invention, the item master table contains a cash flow code to be set when a cash item is set in the partner account of the journal data, for each accounting item for which the journal processing is performed. It is characterized in that it is a table in which a cash flow code is set individually for each of a case of payment and a case of payment of funds.

Further, in the cash flow processing system according to the present invention, when the accounting data input by the data inputting means includes the funding item, the data processing means may provide a credit or debit item for the journalizing item of the accounting data. The present invention is characterized in that it has a configuration for executing a process of assigning the funding amount to the journal data.

Further, in the cash flow processing system of the present invention, the data processing means determines a cash flow amount to be given in the process of giving the cash flow amount to the journal data, based on the cash amount and the counter account amount. In the determination, the cash flow amount to be granted is determined within a range not exceeding the account amount of the counter account, and within a range that does not exceed the total cash amount set. .

Further, the cash flow processing method of the present invention is a cash flow processing method for processing accounting data, wherein the presence or absence of a funding item in the accounting data input by the data input means is determined in advance for each item. It is determined based on the registered table, and if it is determined in the determination that there is a funding item, the cash flow code to be set when the funding item is set in the accounting data is individually set for each accounting item. It is characterized in that the cash flow code registered in the corresponding item master table is added to the input accounting data.

Further, the funding processing method according to the present invention, when the accounting data entered by the data input means includes the accounting item, calculates the accounting amount for the credit or debit item of the journal entry item of the accounting data. It is characterized in that a process of giving inside is executed.

Further, in the cash-flow processing method of the present invention, the cash-flow amount to be provided in the process of adding the cash-flow amount to the accounting data is determined based on the cash-item amount and the counter-account item amount. The funding amount to be granted is determined within a range that does not exceed the account amount of the counter account, and within a range that the total of the set cashing amounts does not exceed the item amount of the funding item.

Further, the recording medium on which the funding processing execution program of the present invention is recorded is a recording medium on which a funding processing execution program for processing accounting data is recorded,
The presence or absence of a funding subject in the accounting data input by the data input means is determined based on a table in which whether or not the subject is a funding subject for each subject in advance, and in the determination, when it is determined that there is a funding subject, When a cash item is set in the accounting data, a cashing code registered in an item master table in which a cashing code to be set is individually associated with each accounting item is added to the input accounting data.

Further, the recording medium on which the funding processing execution program of the present invention is recorded, when the accounting data inputted by the data input means includes the funding item, the credit or debit item of the journal entry item of the accounting data. A process of giving the funding amount to the journal data.

Further, the recording medium in which the cash-flow execution program of the present invention is recorded determines the cash-flow amount to be given in the process of assigning the cash-flow amount to the accounting data based on the cash-item amount and the counter-account item amount. In the determination, the cash flow amount to be granted is determined within a range not exceeding the account amount of the counter account, and within a range not exceeding the total cash amount set. I do.

[0019]

FIG. 1 shows an example of a system configuration of an accounting system according to the present invention. In the configuration example shown in FIG. 1, the data input / output device 10 is used as a basic component in the system.
1, data processing unit 102, master database 103,
It has a data storage unit 104 and a data output unit 105. Among these basic components, the data processing unit 102
Journal data processing unit 1021 and cash flow data processing unit 1
022. In addition, the master database 103
The data output unit 105 includes a subject master 1031, a cash management master 1032, and various masters 1033. The data output unit 105 includes a printer 1051 and a display device 1052.

The data input / output unit 101 is a device for inputting various types of accounting data. The data input / output unit 101 converts payment data, payment data, transfer data, and the like into a predetermined journal format or a slip format, such as an input format set in the system in advance. Enter according to. The input format and the like will be described later in detail. In this embodiment, the data input / output unit 101 has a configuration also serving as an output unit, and can display various data as needed.

The data processing unit 102 has a journal data processing unit 1021 and a funding data processing unit 1022, is connected to the master database 103 and the data storage unit 104, and has a configuration capable of accessing each data. I have. The data processing unit 102 performs processing on data input from the data input / output unit 101 and the like. For example, the accounting data input in the form of a deposit slip or withdrawal slip is subjected to a journalizing process in accordance with a predetermined accounting rule, and a totaling ledger, a file for each subject, etc., are registered in a predetermined file, and recorded. The processed data is stored in the data storage unit 104.

Master data required for the journalizing process is registered in various masters 1033 of the master database 103, and the data processing unit 102 determines a predetermined master in accordance with data input in the data input / output unit 101. The journal data is processed by extracting or referencing necessary data from the table, and the processing result is stored in the data storage unit 104. The various masters include, for example, a table relating to company codes, a table relating to date data, a table relating to security matters, and the like as shown in the figure.

The data processing section 102 has a funding data processing section 1022. Funding data processing unit 10
Reference numeral 22 executes processing of the funding-related data when the journalizing data input in the data input / output unit 101 includes data on the funding.

When processing data related to funding, the subject master 103 in the master database 103 is used.
1 and each master table of the cash flow master 1032 are referred to. Each of the master tables used for the funding data processing will be described in detail later.

The data that has been subjected to the data processing accompanying the accounting processing is stored in the data storage unit 104. The data storage unit 104 stores and holds the processing data in the form of a general ledger, a journal diary, and a cash flow record table in which a format has been set in advance, or stores the processing data as a data string from which these necessary aggregation tables can be created. Remember. Data storage unit 1
04 stores, for example, input data, journal data, funding performance data, and the like as shown in the figure.

The data output unit 105 includes a printer 105
1. Equipped with a device capable of displaying or outputting data, such as a display device 1052, and outputting various statements such as a profit and loss statement, a trial balance, a cash flow record and a schedule as needed.

In the configuration example of the accounting system shown in FIG. 1, each component is shown in a divided form in order to explain its function, but various components such as a data input / output unit and a data input / output unit are used. The present invention can be applied to a configuration in which various components are integrated, such as a configuration in which a processing unit or a data processing unit and a data storage unit are integrated, and a plurality of data input devices or output devices. May be connected by a wired or wireless data network, perform data communication between the devices, and perform data processing.

The cash flow processing executed in the cash flow processing system of the present invention is performed by using a magnetic disk, a floppy disk, an optical recording medium, a magneto-optical recording medium, a RAM, or the like on which the cash flow processing execution program of the present invention is recorded. The operation of each system component can be controlled and executed by executing the program by reading the program from the program recording medium.

The cash flow data processing executed in the cash flow processing system of the present invention will be described below.
First, with reference to FIG. 2 to FIG. 5, the cash-finish master table and the subject master table required in the cash-finish data processing of the cash-finish processing system of the present invention will be described in detail.

FIG. 2 is a diagram showing the recorded contents of the cash flow master table. Figure 2 shows the cash flow master table.
As shown in the table, each item of cash flow code, cash flow name, income and expenditure category, and income expenditure is set. In the cash flow name, names related to cash flow occurring in the accounting process are listed. The cash flow codes are set so as to correspond one-to-one to each of the listed cash flow names. In this example, the cashing code is set by a four-digit numerical value. However, these codes need only be identifiable for each of the cashing name items that need to be registered. Or the like.

In the cash flow master table, a revenue and expenditure category is set for each of the set cash flow names, and another type of income and expenditure is set. The income and expenditure category is a category that represents the contents of income and expenditure, and can be set to “current account”, “financial equipment balance”, “financial account”, “transfer between funds”, and “other”. The meaning of each category is as follows.

[0032]

[Table 1] Current account: “Funds” resulting from business activities of companies
Division indicating increase or decrease of. Closing equipment balance: Acquisition of facilities such as land, buildings, machinery, etc.
A category that indicates an increase or decrease in “funds” due to sales, or an increase or decrease in “funds” due to settlement of accounts such as taxes, dividends, and bonuses for directors. Financial balance: A category that indicates an increase or decrease in “funds” generated by financing activities. Transfer between funds: A category that indicates that the amount of “funds” itself does not increase or decrease even if a journal entry of “fund item” occurs, such as a change from a savings account to a checking account. Other income and expenditure: Classification when none of the above applies.

The above-described setting of the income and expenditure division is an example, and any division can be set according to the necessity of the accounting process to be executed. The income expenditure is a category indicating “payment” or “withdrawal”. In the example shown in FIG. 2, for example, when the cash flow name is “sales receipt”, the cash flow code is “101”.
0, the income and expenditure category is set as "accounted income and expenditure," and the other of income and expenditure is set as "income."

FIG. 3 shows an example of a cash-finish master maintenance screen displayed in the case of data entry or correction of the cash-finish master table of FIG. In the example shown in FIG. 3, the screen displayed on the display includes a cash flow code, a cash flow name (kanji, abbreviation, kana), an income and expenditure category,
And each of the items of the income and expenditure division can be inputted. Add items of cash flow master table,
Alternatively, change, correction, deletion, etc. of the already set data are executed by calling up this cash flow master maintenance screen.

FIG. 4 is a diagram showing an example of data setting regarding the cash flow code in the subject master table. As shown in FIG. 4, the cash flow codes in the subject master table are configured to individually set “fund deposit” and “fund disbursement” corresponding to the subject.

In the item master table, basically, for all the detailed items, the cash flow codes are set in the items of “fund deposit” and “fund disbursement” in the master table. “Fund deposit” is an item for setting a cash flow code indicating the reason for depositing “fund” when “fund subject” is set as a debit as a counter subject of the subject.
The “fund disbursement” is an item for setting a cash flow code indicating the reason for dispensing the “fund” when the “fund subject” is set as a credit as the partner subject of the subject. In the item master table of FIG. 4, the cash flow code set in “fund transfer” and “fund disbursement” needs to correspond to the cash flow code of the cash flow master table in FIG.

For example, in FIG. 4, if the subject is “current account”, and if the fund subject is set as the counter subject of “current account” in the journal, the transfer of funds is made whether the counter subject is debit or credit. The cash flow name in the cash flow master table corresponds to the item of “cash transfer”, and “900” set at the bottom of FIG.
"0" is set.

When the item is "account receivable" in FIG. 4, the cash flow name in the cash flow master table of FIG. 2 corresponds to the item of "account receivable", and "1020" set in FIG. Is set. In FIG. 4, when the subject is “securities”, the code differs depending on whether the partner subject at the time of journal entry is “debit” or “credit”. In this case, the cash flow name in the cash flow master table of FIG. 2 corresponds to the item of “sales of securities” or “purchase of securities”, and “5040” and “5040” set in each item of FIG. “6040” is set in each column of “fund deposit” and “fund disbursement” in the subject master table of FIG.

FIG. 5 shows an example of a subject master / maintenance screen used for data input or correction of the subject master table of FIG. In the example shown in FIG. 5, the screen displayed on the display is a screen for executing detailed settings for each subject, and is configured so that a subject code, a subject name, and a funding code can be set. The cash flow code is configured to individually set a cash flow code for payment and a cash flow code for withdrawal corresponding to the subject master table of FIG. Further, at the bottom of the screen, there is an item for setting details of the subject after item A, and the item H
Has an item indicated as “financing subject” for setting whether or not this subject is a fund subject. Here, when a journal entry is executed for an item for which the setting of “1: fund” is made, the funding data processing section executes the funding data processing.

Next, the funding data processing executed in the funding processing system of the present invention based on the above-described funding master table and subject master table will be described using various data processing examples.

First, the setting of the cash flow code at the time of actual data input will be described with reference to FIGS.
FIG. 6 shows input data in a slip input format. In the example of FIG. 6, the accounts payable “10,000” and the accounts payable “5,000” are debited, and the checking account “15,000” is debited.
00 ”is journalized. In the accounting processing system of the present invention, when such data is input, the journal item is identified, and when the fund item is debited, a code indicating the receipt of funds is set, and the fund item is credited. If journalized, a code indicating the withdrawal of funds is set on the partner subject side.
It should be noted that these codes can be input by an input person, and are automatically set when not input. The operation on the system will be described in detail later.

In the example shown in FIG. 6, since the checking account has been credited, a cash flow code indicating the reason for dispensing funds is set for each of the accounts payable and the accounts payable on the partner account side. In the column of accounts payable, “2020 Accounts payable” is set, and in the column of accounts payable, “2020 Accounts payable” is set. These set cash flow codes and names need to be registered in the cash flow master table shown in FIG. If the data entry person is familiar with the registered code, etc., it is possible to directly enter and register on the display as described above, but if there is no entry, the journal "Accounts payable", The cash flow code registered in “fund disbursement” in the item master table shown in FIG. 4 is automatically set for each journal item of “payables”. As is clear from the subject master table of FIG. 4, the cash flow code of the “finance withdrawal” of the accounts payable is “2020”,
The cash flow code of the “payment” is “2030”
Therefore, these codes are automatically set.

The processing of the above input data will be described with reference to the system configuration diagram of FIG. The slip input in FIG. 6 is executed in the data input / output unit in FIG. The journal data processing unit 1021 in the data processing unit 102 that has received the input data from the data input / output unit 101 refers to the subject master 1031 in the master database 103 or the master table of various masters 1033, and determines the input subject and the like. Perform a check to see if it is correct, and if it is determined that the input data is appropriate according to the predetermined input format,
The data is registered and stored in the data storage unit according to a preset format.

Further, whether or not a funded subject is included in the journalized subject is determined by searching the setting of the subject master table based on the input subject. This data search and judgment is performed for each subject of the input subject in FIG.
Is determined with reference to whether the setting item H of the subject master / maintenance screen shown in FIG.

When it is determined based on the setting of the item master table that the input item includes a funding item, a process related to the funding data is executed in the funding data processing section 1022 of the data processing section 102. The funding data processing unit 1022 sets a funding code representing the receipt of funds to the counterpart if the funding item is debited, and the funding data representing the withdrawal of funds if the funding item is credited. Set the code on the partner subject side. The data processing unit 102 converts the subject master table shown in FIG. 4 into the subject master 1031 in the master database 103 shown in FIG.
To search for an input subject from the subject master table, and select and register the cash flow code registered in the "funded" or "funded" of the searched input subject. When the cash flow code is set in the journal data, the processing data is stored in the data storage unit 104 of the system configuration diagram in FIG. 1 together with other journal data and the like.

FIG. 7 shows an example of a journal entry screen. The data input person can input necessary transaction data in accordance with a preset input form as shown in FIG. The input items are, according to the display shown in FIG.
The debit item, the amount, the credit item, the amount, and the like may be input so as to be embedded in predetermined fields. Input columns relating to cash flow are provided for each of debit and credit, and the data input person can input data registered in the cash flow master. Even if there is no entry in these fields, if a funding item is entered as a debit or a credit, the data processing unit 102 automatically sets a predetermined cashing code in this funding field according to the above-described procedure. In FIG. 7, the accounts payable with the cash flow code “2020” is set in the debit cash flow column.

As described above, the funding code is automatically set. If it is desired to change these automatically set data, the input person can change and register the automatically set funding information. However, the cash flow code input by the user needs to be registered in the cash flow master table in advance.

In the cash flow data processing in the cash flow processing system of the present invention, it is possible to set not only the above-mentioned cash flow code but also the cash flow amount. Hereinafter, the setting of the funding amount will be described with reference to a setting example of the funding amount in FIG. 8 and the processing flow in FIG. 9.

FIG. 8 shows an example of the automatic setting of the funding amount and the input person changing the automatically set cashing amount. When a journal entry is made as shown in FIG. 8 (a), that is, when the accounts payable and the accounts payable are input to the debit, and the current account and the accounts receivable are input to the credit, the current account 12, 12
A cash-out amount of 000 yen is automatically and sequentially allocated to the accounts payable and the accounts payable of the counterparty. Since the amount of accounts payable on the input slip is 10,000 yen, the automatic allocation of cash flow amount is up to 10,000 yen.
It is determined to be 000 yen, and as shown in FIG. 8 (b), the cash amount data of 10,000 yen is recorded as accounts payable payment. Further, the remaining balance of 2,000 yen is recorded as repayment of 2,000 yen as a cash flow for the unpaid amount. The funding data processing unit 1022 in FIG. 1 compares the input amount of the fund-related item with the input amount of the partner item to determine each set amount. This amount setting process will be described in detail with reference to the flow of FIG.

When the input person changes the cash flow data automatically set in this way, on the setting screen, as shown in FIG. 8C, accounts payable: 8,000 yen, accounts payable: 4,000. Just enter the circle.

FIG. 9 is a flow chart illustrating the data processing of the cash flow information in the cash flow processing system of the present invention. First, when a journal entry is made, step 901 is executed.
In, it is determined whether the entered journal has a fund account. If a fund account such as a deposit, cash, or securities is included in the journal subject, the answer is Yes, and the process proceeds to step 902. This determination is executed by searching the subject master table based on the input subject and referring to the setting of the corresponding item. If the determination in step 901 is No, the cash account is not included in the journal entry, and the cash flow data processing is not executed, so that only the general journal processing is executed and the cash flow data processing ends.

If the determination in step 901 is Yes,
Proceeding to step 902, the master is searched by the counter account. For example, when the journal processing data as shown in FIG. 6 is input, the fund account is “current account” and the counter accounts are “accounts payable” and “payable”. A search for "Accounts payable" or "Payables" will be executed. In this flow, the funding data processing is sequentially executed for each item, so that the item master table for “accounts payable” is first searched.

In the next step 903, the cash flow code corresponding to the searched item is obtained from the item master table, and is set in the journal data. In the journal data in the input example of FIG. 6, "2020 Accounts payable" is recorded in this step 903.

In the next step 904, the sum of the fund item amount and the counter account amount is compared. Describing in correspondence with the input example of FIG. 8, in FIG.
It is a "current account" and the amount is 12,000 yen. On the other hand, the accounts payable, which is the counter account, is 10,000 yen, and the accounts payable is 5,000 yen. In this case, first, the cash flow amount is set for the accounts payable,
The fund item amount “current account”: 12,000 is compared with the counter account amount total: “accounts payable” 10,000. Since the amount of the fund item “current account”: 12,000> the total amount of the counter account: “accounts payable” is 10,000, step 90
The determination at 4 is Yes, and the process proceeds to step 905.

In step 905, the same amount as the counter account amount is set as the funding amount in the counter account. In the input example of FIG. 8, as shown in FIG.
Zero yen is set.

When step 905 is completed, step 90
Proceeding to 6, a search for the next counter account is executed. In the example of FIG. 8, the accounts payable is the next partner account. Step 9
At 02, a search is made for the counterpart item master, and the same processing as described above is performed.

In the case of the input example of FIG. 8, in the cash flow data processing of the accounts payable, the cumulative comparison between the fund item amount and the counter account amount in step 904 is performed.
It is 2,000 yen, and the offsetting account is payable: 10,000
0 yen + unpaid money: 5,000 yen, so the amount of the cash account “current account”: 12,000 <accumulated counter account amount:
"Accounts payable" is 10,000 + unpaid 5,000.
Therefore, the determination in step 904 is No, and step 9
Proceed to 07.

In step 907, "fund account amount-cumulative set partner account amount" is set in the cashing information of the partner account. In the example of FIG. 8, the fund account amount−the set counter account total is 12000−10000 = 2000.
In this case, 2,000 yen of the unpaid payment is set as the funding amount information of the unpaid money.

In the cash flow processing system of the present invention, the cash flow management can be easily executed by using the cash flow data processing as described above. The cash flow management is to collectively manage the increase and decrease of the “fund subject” which is a subject in which the fund subject category in the subject master table is set as “fund”.

FIG. 10 shows a sample funding schedule input screen that is set when performing cashing management. In the example of FIG. 10, “sales receipt” is used as the funding item, and the cash flow code 1 is used.
An input example of 010 is shown. For each month, a schedule can be entered for 1000 yen as a monetary unit. For example, 3,000 yen in funds in April and 0 out of funds in April
Yen, total 3000 Yen, May fund entry 4,000
It costs 0 yen and the amount of funding is 0 yen, for a total of 4,000 yen.

By inputting these funding schedules and recording them in a storage device, it is easy to compare them with the actual journal entry. For example, a “financing table”, a “financing monthly transition table”, etc. Can be easily executed. The cash flow table is a book that displays the cash flow results from the beginning of the period to the specified month and the cash flow schedule after the specified month.
The cash flow monthly transition table is a book that displays the total cash flow results from the beginning of the period to the designated month.

FIG. 11 shows an example of a funding table created at the time when the accounting data for April and May is closed by executing predetermined data input on the funding schedule input screen of FIG. As shown in FIG. 11, items of each funding item, for example, “Receivables collection: (Cash-back code: 1020)”,
"Payment to notes receivable: (Cash-back code: 1030)"
In correspondence with the above, the increase / decrease of each subject is shown as a list along with actual data and scheduled data for each month. In the data shown in FIG. 11, the data for October and November marked with “*” indicate scheduled data, and the amount entered on the cashing schedule input screen in FIG. 10 is displayed. 4
The data of the month and May are data totaled based on the actual journal entry. Regarding the data entered as a journal entry as described above, the funding code and the funding amount are set and stored in the data storage unit. Therefore, for each item shown in FIG. If the data having the cash flow code is totaled, the totalization of each data on the cash flow for each month can be easily executed.

As described above, in the cash-finish processing system of the present invention, the cash-processing-related accounting process items are enumerated as cash-finish names, and a correspondence table in which a cash-finish code is assigned in correspondence with the enumerated cash-finish names is generated as a cash-finish master table. Further, for each account item, an item master table in which a funding code is set for "fund deposit" and "fund dispensing" is generated, and these tables are stored and held in the master database. With this configuration, when a journal entry of data including an item requiring funding processing is performed from the data input unit, various operations such as granting a funding code and a funding amount based on each master table stored in the master database are performed. Is executed.

When creating various kinds of data related to cash flow, for example, when making a cash flow table, a cash flow monthly transition table, and the like,
It is possible to easily search and tabulate the extraction and aggregation of cash flow related data based on the cash flow code automatically added to daily journal data, so even non-experts who do not have knowledge of cash flow Of the cash flow data of the client can be created.

The processing of adding or changing the contents of each master table can be executed as necessary as master table maintenance processing. In addition, when a person who inputs the accounting data wants to refer to the data in each registration master table, for example, the cash flow name and the corresponding cash flow code, the data input / output unit 101 in the system configuration diagram of FIG. It is also possible to extract predetermined necessary data from the master database, display the data on the display device of the data input / output unit 101, and refer to the data.

[0066]

As described above, according to the cash-flow processing system, the cash-flow processing method, and the recording medium on which the cash-flow processing execution program is recorded, the following various effects can be obtained.

[Automatic Recognition and Code Setting of Cashing-Related Data in Journal Items] Even if the data entry person has no knowledge of the cashing process, if the journal data contains an item that requires cashing data processing, Then, the data processing means identifies the subject, automatically sets the required cashing code, and stores the journal data together with the assigned code. Therefore, when a data entry person has performed journalizing processing of data including an item related to funding, it is sufficient to input data as normal journalizing processing without being conscious of cashing data processing.

[The funding data processing is facilitated. ]
If the journal entry data entered by the data entry person includes data used for the cash-in process, a cash-in code is all assigned and stored in the storage device. Therefore, when creating a cash flow related book such as a cash flow table, a cash flow monthly transition table, etc., it is possible to execute data aggregation based on the provided cash flow code, and it is possible to generate necessary cash flow data. It will be easier.

[Automatic setting of cash flow amount in journal processing] If the journal data includes an item that requires funding data processing, the data processing means identifies the item, automatically executes the setting of the necessary funding code, and stores the journal data together with the assigned code. Further, a cash flow amount for the counter account is set based on the money amount of the money item. Since the setting of the funding amount is executed based on the item amount of the funding item and the counterpart item amount of the funding item, occurrence of an error in the setting of the amount is prevented. Further, since each set amount of money is stored and held in the storage device together with the journal data, the accurate amount of money can be easily totaled at the time of creating the funding data.

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a system configuration of a cash flow processing system according to the present invention.

FIG. 2 is a diagram showing an example of a cash flow master table used in the cash flow processing system according to the present invention.

FIG. 3 is a diagram showing a cash flow master table maintenance screen for inputting data of a cash flow master table in FIG. 2;

FIG. 4 is a diagram showing an example of a subject master table used in the cash flow processing system according to the present invention.

FIG. 5 is a diagram showing a subject master table maintenance screen for inputting data of the subject master table in FIG. 4;

FIG. 6 is a diagram showing an input example when a slip is input in the cash flow processing system of the present invention.

FIG. 7 is a diagram showing an example of a journal entry screen in the cash flow processing system of the present invention.

FIG. 8 is a diagram illustrating an automatic setting and changing process of a funding amount in the funding system of the present invention.

FIG. 9 is a diagram illustrating a flow of cash-financing data processing in the cash-financing processing system of the present invention.

FIG. 10 In the cash flow processing system of the present invention,
It is a figure showing the example of the funding schedule input screen used when performing funding management.

FIG. 11 In the cash flow processing system of the present invention,
It is a figure which shows the example of the cash flow table created when cash flow management is performed.

[Explanation of symbols]

 Reference Signs List 101 data input / output unit 102 data processing unit 1021 journal data processing unit 1022 cash flow data processing unit 103 master database 1031 subject master 1032 cash flow master 1033 various masters 104 data storage unit 105 data output unit 1051 printer 1052 display device

Claims (11)

(57) [Claims] A data input unit for inputting accounting data; a data processing unit for processing the accounting data input in the data input unit; a master database accessible by the data processing unit; In the cash-finish processing system having storage means for storing processed data, the master database includes: a cash-finish master table in which various cash-finish names are associated with cash-finish codes in the cash-finish processing; When a subject is set, the funding code to be set is held for each accounting subject for which journal processing is performed, and the subject master table is held, and the data processing unit is configured to execute the accounting input by the data input unit. Data includes funding items As to whether or not,
It is determined based on a table in which whether or not the subject is a funding subject for each subject in advance, and when it is determined that a funding subject is included, the registration data in the subject master table held in the master database is used. A cash-finish processing system having a configuration for executing a process of giving a cash-financing code selected based on the input accounting data. 2. The cash flow master table is set so that a cash flow code corresponds to each cash flow name, and furthermore, a revenue and expenditure category indicating the contents of income and expenditure, and an income indicating a distinction between incoming and outgoing. 2. The cash flow processing system according to claim 1, wherein expenditure is set in correspondence with each of the cash flow names. 3. The item master table includes a cash flow code to be set when a cash item is set as a counter account of journal data, and a cash flow code for each accounting item for which journal processing is performed. 2. The cash-finish processing system according to claim 1, wherein the cash-finish code is a table in which cash-finish codes are individually set to distinguish the case of money. 4. When the accounting data entered by the data inputting means includes a funding item, the data processing means calculates a cashing amount for a credit or debit item of the accounting data in the accounting data. 4. The cash flow processing system according to claim 1, further comprising a configuration for executing a process to be provided in the inside. 5. The data processing means has a configuration for determining a cash amount to be given in the process of giving the cash amount to the journal data, based on a cash amount and a counter account amount. In the above, the cash flow amount to be assigned to the journal data is determined within a range not exceeding the account amount of the counter account, and within a range where the total of the set cash flow amount does not exceed the account amount of the cash item. The cash flow processing system according to claim 4, characterized in that: 6. A funding processing method for processing accounting data, wherein the presence or absence of a funding subject in the accounting data input by the data input means is based on a table in which whether or not the subject is a funding subject for each subject is registered in advance. In the above determination, when it is determined that the funding item exists in the input accounting data, the funding code to be set when the funding item is set in the accounting data is individually associated with each accounting item. A cash flow code registered in the subject master table to the input accounting data. 7. When the accounting data input by the data input means includes a funding item, a process of assigning a cash flow amount for a credit or debit item of a journal item of the accounting data to the journal data. 7. The cash flow processing method according to claim 6, wherein the method is executed. 8. A cash flow amount to be granted in the process of granting the cash flow amount to accounting data is determined based on a cash account item amount and a counter account item amount, and in the determination, the cash amount of the counter account item is determined. 8. The fund-raising processing method according to claim 7, wherein the fund-raising amount to be granted is determined within a range not exceeding the total amount of the fund-raising amounts that do not exceed the amount of the item of the fund subject. 9. A recording medium on which a funding processing execution program for processing accounting data is recorded, wherein the presence or absence of a funding subject in the accounting data input by the data input means is determined for each subject in advance whether or not the subject is a funding subject. Is determined based on the registered table, and in the above-described determination, when it is determined that there is a funding item, the cash flow code to be set when the funding item is set in the accounting data is individually handled for each accounting item. A recording medium recording a funding processing execution program, wherein the cashing code registered in the subject master table is added to the input accounting data. 10. A process for assigning a funding amount for a credit or debit item of a journal item of the accounting data to the journal data, when the accounting data input by the data input means includes a funding item. A recording medium on which the funding processing execution program according to claim 9 is executed. 11. A cash flow amount to be granted in the process of granting the cash flow amount to accounting data is determined based on a cash account item amount and a counter account item amount, and in the determination, the cash account amount of the counter account item is determined. 11. The funding processing execution program according to claim 10, wherein the funding amount to be provided is determined within a range not exceeding the total amount of the funding amounts to be set and not exceeding the item amount of the funding item. 12. Recording medium on which is recorded.