JP2003331204A - Deposits/withdrawals data processing system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reduce a load required for account processing of a customer by classifying deposits/withdrawals detailed data corresponding to account sorting classification of the customer. <P>SOLUTION: A cashbook system 50 generates fixed summary data D30 based on the content of a deposits/withdrawals detailed summary T20 included in the deposits/withdrawals detailed data D10 in a customer's account. Then, the cashbook system 50 specifies a transaction content code T50 based on the generated fixed summary data D30, and stores the transaction content code T50 in a deposit receipts/disbursements detailed data table TB20 together with the deposits/withdrawals detailed data D10. The accumulated deposits/ withdrawals detailed data D10 can be easily classified based on the transaction content code T50 by accumulating the deposits/withdrawals detailed data D10 in the deposit receipts/disbursements detailed data table TB20 in this way. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a deposit / withdrawal data processing system, and more particularly to a deposit / withdrawal data processing system for processing deposit / withdrawal detailed data of deposit / withdrawal processing performed on a customer's account.

[0002]

2. Description of the Related Art Among customers of financial institutions such as banks, there are customers such as companies who have to manage transactions in accounting. However, management of deposits and withdrawals of funds made to customer accounts opened at financial institutions,
Since it is independent of accounting transaction management, such a customer has to be managed separately by an accounting person or the like.

That is, information about deposits and withdrawals made in an account of a financial institution is provided to the customer in a form such as entry in a bankbook or output of a deposit and withdrawal statement form, and the customer who receives it receives these information. The contents of the deposit / withdrawal must be specified based on the deposit / withdrawal amount and its date in the bankbook or the deposit / withdrawal statement form, and further from the deposit / withdrawal summary which is supplementary information accompanying this. Then, based on the contents of the specified deposit / withdrawal, the deposit / withdrawal made in the account of this financial institution is classified into the account items etc. necessary for accounting management, and accounting transaction management is performed. is doing.

[0004]

However, the information about deposit and withdrawal obtained from the bankbook or deposit and withdrawal statement form includes the deposit and withdrawal amount and the date, and the deposit and withdrawal statement summary as supplementary information. Only, and
The description is not always easy to understand, and is often just a supplementary description. For this reason, the accountant, etc. can instantly understand what kind of commercial transaction the deposit / withdrawal described in the bankbook or deposit / withdrawal statement form actually is, and how it is classified in accounting. Can be difficult to identify.

In addition, such a judgment depends in large part on the personal experience and skills of the person in charge of accounting and the like, and when the person in charge of accounting is newly replaced, transaction management in accounting is performed. May not function properly. In addition, since it depends on the judgment of the person in charge of accounting, human error is likely to occur.

Moreover, the deposit and withdrawal statement data of the account of the financial institution and the data of the accounting transaction management system of the customer are not necessarily compatible with each other. Therefore, it may be necessary to manually input the deposit / withdrawal statement data provided by the financial institution into the accounting transaction management system of the customer, or to convert and read the data. If such work occurs, there is a possibility that an input error or a data conversion error will occur.

Therefore, the present invention has been made in view of the above problems, and is necessary for a customer to manage accounting transactions by effectively utilizing the customer's deposit and withdrawal statement data accumulated by a financial institution. It is an object of the present invention to provide a deposit / withdrawal data processing system capable of significantly reducing the labor.

[0008]

In order to solve the above problems, a deposit / withdrawal data processing system according to the present invention obtains deposit / withdrawal detailed data of deposit / withdrawal processing performed on a customer's account. It is money detail data acquisition means, and the deposit / withdrawal detail data includes at least the amount of money that has been deposited or withdrawn, and deposit / withdrawal summary information that is supplementary information relating to the deposit or dispensing process. Based on the contents of the deposit / withdrawal statement data acquisition unit and the deposit / withdrawal statement summary information included in the deposit / withdrawal statement data, the deposit / withdrawal statement data is classified according to the content of the transaction. , Determine transaction content specific information based on this classification,
It is characterized by comprising transaction detail determining means and deposit detail data holding means for storing and holding the deposit / withdrawal detailed data together with the transaction specific information.

The control method of the deposit / withdrawal data processing system according to the present invention holds deposit / withdrawal detailed data of deposit / withdrawal processing performed on a customer's account, and this deposit / withdrawal detailed data is at least A control method for a deposit / withdrawal data processing system, comprising a deposit / withdrawal amount and a deposit / withdrawal description information which is supplementary information about the deposit / withdrawal processing. Based on the contents of the deposit / withdrawal statement data acquisition step of acquiring money statement data and the deposit / withdrawal statement summary information included in the deposit / withdrawal statement data, the deposit / withdrawal statement data is set as a transaction content. According to the transaction content determining step of determining the transaction content specifying information based on this classification, and storing the deposit and withdrawal statement data together with the transaction content specifying information in the deposit statement data holding means. That, characterized by comprising a storage step.

The program for controlling the deposit / withdrawal data processing system according to the present invention holds deposit / withdrawal detailed data of deposit / withdrawal processing performed on a customer's account. , A program for controlling the deposit / withdrawal data processing system, which includes at least the amount of deposit / withdrawal processing and deposit / withdrawal summary information which is supplementary information about the deposit / withdrawal processing. Then, the deposit / withdrawal statement data is acquired, and the deposit / withdrawal statement data is acquired based on the contents of the deposit / withdrawal statement summary information included in the deposit / withdrawal statement data. The transaction content determining step of classifying the data according to the content of the transaction and determining the transaction content identifying information based on this classification; and the deposit / withdrawal statement data including the transaction content identifying information. Together, stored in the deposit item data holding means, characterized by comprising a storage step.

The recording medium according to the present invention holds deposit and withdrawal detailed data of deposit processing or withdrawal processing performed for a customer's account, and this deposit and withdrawal detailed data is at least the deposit processing or withdrawal processing. A recording medium in which a program for controlling the deposit / withdrawal data processing system is recorded, which includes the deposited amount and deposit / withdrawal description summary information that is supplementary information regarding the deposit / withdrawal process.
Transaction of the deposit / withdrawal detailed data based on the content of the deposit / withdrawal detailed data included in the deposit / withdrawal detailed data acquisition step of acquiring the deposit / withdrawal detailed data. According to the content of, and determines the transaction content identification information based on this classification, the transaction content determination step, and the deposit and withdrawal detailed data together with the transaction content specific information, stored in the deposit detailed data holding means, And a program for causing the deposit / withdrawal data processing system to execute the storing step.

[0012]

BEST MODE FOR CARRYING OUT THE INVENTION One embodiment of the present invention utilizes deposit / withdrawal statement data stored in an accounting system,
This is to reduce the labor required for the customer to perform accounting processing by generating deposit and withdrawal statement data that is suitable for accounting transaction management for each customer. More details will be described below.

First, the structure of a deposit / withdrawal accounting management system 10 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing a schematic configuration of a deposit / withdrawal accounting management system 10 according to the present embodiment.

As shown in FIG. 1, a deposit / withdrawal accounting management system 10 comprises a deposit / withdrawal data processing system 20 provided on the financial institution side and a customer side computer system 30 provided on the customer side. ing. The deposit / withdrawal data processing system 20 and the customer computer system 30 are connected via a communication network 40 such as the Internet or a dedicated line. In FIG. 1, only one customer side computer system 30 is connected to the transfer processing system 20, but a plurality of customer side computer systems 30 are connected to the deposit / withdrawal data processing system 20 corresponding to a plurality of customers. It may have been done.

The deposit / withdrawal data processing system 20 provided on the financial institution side comprises a cash accounting system 50 and an accounting system 52. The cash register system 50 and the accounting system 52 are in-house LAN (Local).
Area Network) etc. are connected to each other.

The cash accounting system 50 is connected to the communication network 40, and has a customer / payee master database 60, a transaction content master database 62, a deposit and withdrawal statement database 64, and a transaction setting master database 66. , And a summary code master database 68.

The accounting system 52 connected to the cash book system 50 includes an account deposit / withdrawal statement database 70. In addition, this accounting system 52 processes various deposits and withdrawals performed for a customer's account, and the processing details of each account are stored in the account deposit / withdrawal database 7.
Store in 0 and accumulate. Among the accounts stored in the account deposit / withdrawal statement database 70, information regarding deposit processing and withdrawal processing regarding a predetermined account set to provide the accounting management service in the deposit / withdrawal data processing system 20 is, for example, It is transmitted to the cash accounting system 50 as deposit / withdrawal statement data once a day.

FIG. 2 is a diagram showing an example of a data format of the deposit / withdrawal detailed data D10 according to the present embodiment.

As shown in FIG. 2, the deposit / withdrawal detailed data D10 according to the present embodiment has, as data items, a slip date T10, a slip number T12, a deposit / withdrawal classification T14, and
Amount T16, account transaction category T18, deposit and withdrawal statement summary T
20 and transfer requester information T22. That is, in this embodiment, the data items shown in FIG. 2 are extracted from the deposit / withdrawal information of the customer's account stored in the account deposit / withdrawal statement database 70,
It is transmitted to the cash register system 50. The deposit / withdrawal detailed data D10 is generated for each deposit / withdrawal process for one account.

The slip date T10 stores the date of the slip for which the deposit / withdrawal process is requested. Slip number T
In 12, the slip number of the slip for which this deposit / withdrawal processing request has been made is stored. The pay-in / pay-out section T14 stores data for distinguishing whether the pay-in / pay-out detailed data D10 is based on the "payment" processing or the "payment" processing.

The amount T16 stores the amount of money deposited / disbursed by the depositing process or the dispensing process. That is, in the case of deposit processing, the deposit amount is stored,
In case of withdrawal processing, the amount of withdrawal is stored. The account transaction category T18 stores data relating to transaction categories related to the deposit / withdrawal statement data D10. In the present embodiment, the account transaction classification T18 includes eight types of “cash”, “transfer”, “payment of other store ticket”, “exchange”, “transfer”, “other”, and “correction”. One of the categories is stored.

In the deposit / withdrawal statement summary T20, summary data stored in the account deposit / withdrawal statement database 70 and stored for the deposit / withdrawal process is stored. This summary is supplemental information regarding deposit / withdrawal processing.
In the transfer requester information T22, this deposit / withdrawal detailed data D1
When 0 is a transfer process from another account to this account, data necessary for specifying the transfer requester is stored.

Therefore, in the example of the deposit / withdrawal detail data D10 of FIG. 2, the slip date is March 28, 2002.
Based on the slip with the day slip number "deposit 003110", 21,000 yen for "Yokohama Shigesuido"
You can see that it shows that you have withdrawn from this account.

FIG. 3 is a diagram showing a more detailed data format of the deposit / withdrawal statement summary T20 in this embodiment. As shown in FIG. 3, in the present embodiment, the deposit / withdrawal statement summary T20 has a data length of 20 bytes. Any 1 from the 1st byte to the 17th byte
The byte character is stored. Since it is a 1-byte character, there are basically only alphanumeric characters, katakana, and simple symbols. These 17 bytes form the abstract character string.

A three-digit summary code is stored in the 18th to 20th bytes. This summary code is a code system uniquely adopted by the financial institution in which the deposit / withdrawal data processing system 20 is provided, and one summary code is assigned according to the content of the deposit / withdrawal processing.

FIG. 4 shows this deposit / withdrawal data processing system 2.
It is a figure which shows the summary code table TB10 of the applicable code system which 0 has adopted. This summary code table TB
10 is stored in the summary code master database 68. The summary code table TB10 includes, as data items, a summary code T30, a summary name T32, and a learning section T34.

The summary code T30 stores a 3-digit summary code. The name corresponding to the summary code is stored in the summary name T32. This name represents the content of the deposit process or the withdrawal process. Learning category T
In 34, when deposit / withdrawal detailed data D10 including the summary code in the deposit / withdrawal detailed description T20 is input, identification information indicating whether or not the learning function described below is applied to the deposit / withdrawal detailed data D10. It is stored.

For example, in the example of FIG. 4, the summary code "01
The summary name of "0" is "transfer", and the learning function is not applied and stored in advance as a database. The summary name of the application code "011" is "transfer / money transfer". The application is preset and held as a database. The system of this application code is generally fixedly set by the financial institution and affects the entire system of the financial institution, and therefore cannot be easily changed.

Next, the fixed summary generating process executed by the cash accounting system 50 according to this embodiment will be described with reference to FIG. FIG. 5 is a flowchart illustrating this fixed summary generation processing. This fixed description generation process is
This is a process executed every time the cash accounting system 50 acquires one deposit / withdrawal detailed data D10 from the accounting system 52.

As shown in FIG. 5, the cash register system 5
0 separates the summary character string and the summary code from the deposit / withdrawal statement summary T20 of the obtained deposit / withdrawal statement data D10,
It is acquired (step S10). Subsequently, the cash register system 50 determines whether or not the acquired summary code is "999" (step S12). The description code is "9
99 "(step S12: Ye
In s), the character string "other" is stored at the beginning of the fixed summary data (step S14).

FIG. 6 (a) is a diagram showing an example of the deposit / withdrawal statement summary T20 in which "999" is stored in the summary code, and FIG. 6 (b) is the fixed summary data D30 generated in step S14. It is a figure which shows an example. As shown in FIG. 6B, in the present embodiment, fixed summary data D3
0 has a data length of 40 bytes. Then, as shown in FIG. 6A, when “999” is stored in the last 3 bytes of the deposit / withdrawal statement summary T20, FIG.
As shown in (b), "other" is stored from the first byte to the sixth byte of the fixed summary data D30. Here, since kanji and hiragana are 2-byte codes, 6 bytes are required even for 3-character information.

As shown in FIG. 5, in step S12, when the cash accounting system 50 determines that the summary code is not "999" (step S12: No), the summary code is "011", and Deposit / withdrawal detail data D
It is determined whether the deposit / withdrawal category T14 of 10 is “deposit” (step S16). The description code is "011" and the deposit / withdrawal category T1 of the deposit / withdrawal detailed data D10.
When it is determined that "4" is "payment" (step S16:
Yes), the fixed summary data D30 includes a character string "transfer / money transfer", a 1-byte space, the summary character string acquired in step S10, a 1-byte space, and a deposit / withdrawal statement data D10. The fixed summary data D3 is combined with the information stored in the client information T22.
It is set to 0 (step S18).

FIG. 7A is a diagram showing an example of a deposit / withdrawal statement summary T20 in which "011" is stored in the summary code, and FIG. 7B is a fixed summary data D30 generated in step S18. It is a figure which shows an example. As shown in FIG. 7A, “011” is stored in the 3 bytes after the deposit / withdrawal description summary T20, and “payment” is stored in the deposit / withdrawal category T14 of the deposit / withdrawal detailed data D10. If there is a fixed summary data D, as shown in FIG.
The character string of "transfer / money transfer" is stored in the 1st to 10th bytes of 30. Then, in the example of FIG. 7, since the summary character string is "Furikomi", "Furikomi" is stored after the 1-byte space following the "Transfer / Remittance" character string. Furthermore, after the 1-byte space has been inserted, in this example, since “K) Hiyaku Kogyo” is stored in the transfer requester information T22, “K) Hiyaku Kogyo” is stored. This is because, in the case of a transfer deposit, it is necessary for the customer who receives this transfer deposit to be able to specify the transfer requester.

As shown in FIG. 5, when it is not determined in step S16 that the summary code is "011" and the deposit / withdrawal category T14 of the deposit / withdrawal detailed data D10 is "payment" (step). In S16: No, it is determined whether the summary code acquired in step S10 exists in the summary code table TB10 (step S).
20).

The summary code is the summary code table TB10.
If it exists (step S20: Yes), the cash register system 50 searches the summary code table TB10 and acquires the summary name T32 corresponding to the summary code T30 (step S22). Then, the cash register system 5
For 0, the contents of the acquired summary name T32, the space of 1 byte, and the summary character string obtained in step S10 are combined to form fixed summary data D30 (step S2).
4).

In FIG. 8A, the description code is, for example, "05".
FIG. 8B is a diagram showing an example of the deposit / withdrawal statement summary T20 in which “4” is stored, and FIG. 8B is a diagram showing an example of the fixed summary data D30 generated in step S24. Figure 8
As shown in (a), 3 after the deposit and withdrawal statement summary T20
If "054" is stored in the byte, the cash register system 50 determines the summary code table T in step S22.
“Water” is acquired from B10 as the corresponding summary name T32. Therefore, in step S24, as shown in FIG.
The character string "water supply" is stored in the byte. Then, in the example of FIG. 8, since the summary character string is "Yokohama Shigeidou", the character string "Yokohama Shigeidou" is stored after the 1-byte space following the character string of "water supply".

As shown in FIG. 5, in step S20, when it is determined that the summary code does not exist in the summary code table TB10 (step S20: No), the contents of the account transaction section T18 of the deposit / withdrawal statement data D10 are described. ,
The 1-byte space is combined with the summary character string acquired in step S10 to form fixed summary data D30 (step S26).

FIG. 9A is a diagram showing an example of the deposit / withdrawal statement summary T20 in which "090" which is not in the summary code table TB10 is stored in the summary code.
(B) is the fixed summary data D generated in step S26
It is a figure which shows an example of 30. As shown in FIG. 9 (a),
When "090" is stored in the 3 bytes after the deposit / withdrawal statement description T20, the cash accounting system 50 determines the description code in the description code table TB in step S20.
It is determined that it does not exist in 10. In this case, the cash register system 50 uses the account transaction classification T1 of the deposit / withdrawal statement data D10.
Get the contents of 8. Here, it is assumed that the information "other" is stored in the account transaction category T18. Therefore, in step S26, as shown in FIG. 9B, the character string of "other" is stored in the first byte to the sixth byte of the fixed summary data D30. Then, in the example of FIG. 8, since the summary character string is "Fukutotei comment",
After the 1-byte space following the "other" string,
The character string "Fukutotei comment" is stored.

Next, as shown in FIG. 5, step S1
After generating the fixed summary data D30 in step 4, step S18, step S24, or step S26, the cash book system 50 uses the generated fixed summary data D30 and the data of the deposit / withdrawal statement data D10 as a deposit / withdrawal statement database. It stores in 64 (step S28).

FIG. 10 and FIG. 11 are views showing an example of the structure of the deposit and withdrawal statement data table TB20 stored in the deposit and withdrawal statement database 64. The deposit / withdrawal statement data table TB20 is a table formed for each account opened by the customer. That is, the data of deposit processing and withdrawal processing performed for the customer's account are sequentially accumulated in the deposit and withdrawal statement data table TB20.

As shown in FIGS. 10 and 11, the deposit and withdrawal statement data table TB20 has data items such as a company code 40, a slip date T42, and a slip number T.
44, supplier record T46, customer / payee name T48, transaction content code T50, and deposit / withdrawal category T52.
, Amount T54, fixed summary T56, cashbook summary T6
0, account transaction classification T62, deposit and withdrawal statement summary T64
And transfer requester information T66.

The slip date / time T42, slip number T44, deposit / withdrawal category T52, amount T54, account transaction category T62, deposit / withdrawal statement summary T6 of the deposit / withdrawal statement data table TB20.
4 and the transfer requester information T66, the slip date T10 and the slip number T1 of the deposit and withdrawal detail data D10, respectively.
2, deposit and withdrawal category T14, amount T16, account transaction category T1
8, deposit and withdrawal statement summary T20, and transfer requester information T2
The data of 2 is directly transcribed and stored. Also,
Fixed summary T56 of deposit and withdrawal statement data table TB20
Includes step S14, step S18, step S2
4, or the fixed summary data D30 generated in step S26 is stored. In the example of FIGS. 10 and 11,
The contents of the deposit and withdrawal detail data table TB20 when the fixed summary generating process shown in FIG. 5 is performed on the deposit and withdrawal detail data D10 shown in FIG. 2 are shown.

Next, with reference to FIGS. 12 and 13, the deposit and withdrawal statement data generation process executed by the cash accounting system 50 will be described. The deposit / receipt statement data generation process is a process executed subsequent to the fixed summary generation process of FIG. 5 described above.

As shown in FIG. 12, a cash register system 50.
Acquires the summary code from the deposit / withdrawal statement summary T64 of the deposit / withdrawal statement data table TB20 (step S4).
0). Subsequently, the cash register system 50 uses the acquired description code as a search key to create a description code table TB1.
0 is searched, and the learning category T3 of the corresponding summary code T30 is searched.
It is acquired whether or not 4 is set to use the learning function (step S42).

Next, the cash accounting system 50 judges whether or not the acquired summary code is a summary code for using the learning function (step S44). When it is determined that the summary code does not use the learning function (step S44:
In No), as shown in FIG. 13, the contents of the fixed summary T56 of the deposit and withdrawal statement data table TB20 are set in the cashbook summary T60 (step S46). Then, this deposit / receipt statement data generation process is ended.

On the other hand, in step S44 of FIG.
When it is determined that the summary code uses the learning function (step S44: Yes), the contents of the fixed summary T56 are acquired from the deposit and withdrawal statement data table TB20 (step S48). Then, the cash register system 50
Uses the fixed description T56 as a search key to search the supplier setting master table and obtain the corresponding company code and supplier code (step S50).

FIG. 14 is a diagram showing an example of the configuration of the supplier setting master table TB30 according to this embodiment.
This supplier setting master table TB30 is formed in the supplier setting master database 66, one table for each account.

As shown in FIG. 14, the supplier setting master table TB30 is provided with a company code T70, a fixed summary T72, and a supplier code T74 as data items. The company code T70 stores a code for identifying the company of the customer. The fixed summary T72 stores a summary for identifying the business partner. In the present embodiment, the contents of the fixed summary T72 are the company code T70 and the supplier code T.
It is a search key for searching 74. The supplier code T74 stores a code for identifying the supplier. In the present embodiment, by combining both the company code T70 and the supplier code T74, the supplier in each account can be uniquely specified.

As shown in FIG. 12, after the customer setting master table TB30 is searched, the cash register system 5
0 determines whether the company code T70 and the supplier code T74 exist in the supplier setting master table TB30 (step S52). When the company code T70 and the supplier code T74 do not exist (step S
52: No), as shown in FIG. 13, the contents of the fixed summary T56 of the deposit and withdrawal statement data table TB20 are set in the cashbook summary T60 (step S46). Then, this deposit / receipt statement data generation process is ended.

On the other hand, the company code T70 and the supplier code T
74 exists (step S52: Yes), the content of the company code T70 acquired in step S50 is stored in the company code T40 of the deposit and withdrawal statement data table TB20, and the supplier code T74 acquired in step S50. Contents of the deposit and withdrawal statement data table TB2
Stored in the supplier code T46 of 0 (step S5
4). For example, in the example of the deposit and withdrawal statement data table TB20 of FIGS. 10 and 11, since the fixed description T56 is “water supply Yokohama Shigeido”, “12345” is set as the company code T70 from the supplier setting master table TB30 of FIG. It is acquired and stored in the company code T40 of the deposit and withdrawal statement data table TB20. Also,
“00001” is acquired as the supplier code T74 from the supplier setting master table TB30 of FIG. 14, and the supplier code T4 of the deposit and withdrawal statement data table TB20.
6 is stored.

Next, as shown in FIG. 12, the cash register system 50 searches the customer / payee master table using the company code and the supplier code obtained in step S50 as search keys, and searches the customer / payee master table. The corresponding transaction content code and customer / payee name are acquired (step S56).

FIG. 15 is a diagram showing an example of the configuration of the customer / payee master table TB40 according to this embodiment. This customer / payee master table TB40 is
One table is formed in the customer / payee master database 60 for each account.

As shown in FIG. 15, the customer / payee master table TB40 has, as data items, a company code T80, a customer code T82, a customer / payee name T84, and a transaction content code T86. It is configured with. Company code T80 and supplier code T82
Correspond to the company code T70 and the supplier code T74 of the supplier setting master table TB30, respectively. Therefore, in the present embodiment, these company code T80 and supplier code T82 correspond to the corresponding supplier /
It serves as a search key for searching the payee name T84 and the transaction content code T86.

In the customer / payee name T84, the name of the customer or payee is stored. The transaction content code T86 stores a code for identifying the content of the transaction assigned by each customer to the customer or the payee. This transaction content code is a code for classifying journals in accounting processing of each customer. For example, in FIG.
In the example, the customer is "Yokohama City Waterworks Bureau" and "○○○ Electric Power"
And "XXX gas" are entered in one category in accounting, so the same transaction content code "330
1 ”is assigned. The method of classifying such journals differs for each customer.

Next, as shown in FIG. 13, after searching the customer / payee master table TB40, the cash register system 50 determines whether the transaction content code exists in the customer / payee master table TB40. Is determined (step S60). When the transaction content code does not exist in the customer / payee master table TB40 (step S60: No), the content of the fixed description T56 of the deposit and withdrawal statement data table TB20 is changed to the balance sheet description T60.
Is set (step S46). Then, this deposit / receipt statement data generation process is ended.

On the other hand, when the transaction content code exists in the customer / payee master table TB40 (step S6)
0: Yes), the transaction content code T86 acquired in step S56 is stored in the deposit and withdrawal statement data table TB20.
The customer / payee name T84 acquired in step S56 is stored in the customer / payee name T48 of the deposit and withdrawal statement data table TB20 (step S62). For example, in the example of the deposit and withdrawal statement data table TB20 in FIGS. 10 and 11, the company code T40 is set to “12345” and the supplier code T46 is set to “00001”.
From the customer / payee master table TB40 in FIG. 15, as the customer / payee name T84, "Yokohama City Waterworks Bureau"
Is acquired and the transaction content code T86 is "3301".
Is obtained. Then, the customer / payee name T48 in the customer / payee master table TB40 of FIG.
"Yokohama City Waterworks Bureau" is stored in the transaction content code T50
“3301” is stored in.

Next, as shown in FIG. 13, the cash register system 50 searches the transaction content master table using the transaction content code acquired in step S56 as a search key,
The summary initial value information corresponding to the transaction content code is acquired (step S64).

FIG. 16 is a diagram showing an example of the configuration of the transaction content master table TB50 according to this embodiment. The transaction content master table TB50 is formed in the transaction content master database 62, one table for each account.

As shown in FIG. 16, the transaction content master table TB50 is provided with a transaction content code T90 and summary initial value information T92 as data items. The transaction content code T90 corresponds to the transaction content code T86 of the customer / payee master table TB40. Therefore, in the present embodiment, the transaction content code T90 serves as a search key for searching the corresponding summary initial value information T92.

The summary initial value information T92 stores information relating to the initial value of the cash register summary registered by the customer so far for the transaction content code. For example, in the example of FIG. 16, “water charge, electricity bill, gas bill” is registered as the summary initial value information for the transaction content code “3301”.

Next, as shown in FIG. 13, after retrieving the transaction content master table TB50, the cash accounting system 50 judges whether or not the summary initial value information exists in the transaction content master table TB50 (step S6
6). Description Initial value information is transaction content master table TB
If it does not exist in step 50 (step S66: No), the fixed summary T of the deposit and withdrawal statement data table TB20 is displayed.
The contents of 56 are set in the cash register summary T60 (step S46). Then, this deposit / receipt statement data generation process is ended.

On the other hand, when the summary initial value information is present in the transaction content master table TB50 (step S66: Y).
es), the “*” mark is added to the beginning of the summary initial value information T92 acquired in step S64, and the summary cash value data table TB20 is stored in the deposit and withdrawal statement data table T20 (step S68). Here, the “★” mark is automatically generated identification information indicating that the cash register system 50 automatically generated the cash register summary T60. By looking at this automatically generated identification information, the customer can see the cash register system summary T60.
It can be known that it is automatically generated by 0. This completes the deposit and receipt detail data generation process.

FIG. 17 is a diagram showing an example of a deposit and withdrawal book display screen W10 displayed on the customer's customer side computer system 30 for the account after the fixed summary generation process and the deposit and withdrawal statement data generation process described above are performed. Is. This deposit / withdrawal book display screen W10 is displayed on the customer side computer system 30 via the communication network 40 by the customer operating the customer side computer system 30, for example.
Is displayed when connected to the cash register system 50.

As shown in FIG. 17, the deposit / withdrawal book display screen W10 displays the deposit / withdrawal book generated based on the deposit / withdrawal process performed for the customer's account. This deposit / accounting book has date T100 as data items,
Voucher number T102, transaction details T104, customer /
Payee T106, deposit T108, withdrawal T110,
And a description T112.

The date T100 is displayed based on the contents of the slip date T42 of the deposit and withdrawal detail data table TB20, and the slip number T102 is displayed based on the slip number T44 of the deposit and withdrawal detail data table TB20. As the transaction content T104, summary initial value information T92 corresponding to the code stored in the transaction content code T46 is displayed based on the transaction content master table. The customer / payee T106 is a deposit / withdrawal statement data table TB20.
It is displayed based on the customer / payee name T48.

The deposit T108 and the dispense T110 are displayed based on the deposit / withdrawal category T52 and the amount T54 of the deposit / withdrawal statement data table TB20. That is, when the deposit / withdrawal category T52 is “payment”, the amount stored in the amount T54 is displayed in the deposit / withdrawal T108, and the deposit / withdrawal category T52 is displayed.
When 52 is “withdrawal”, the amount stored in the amount T54 is displayed in withdrawal T110. In the description T112, the contents of the cashbook description T60 of the deposit and withdrawal detail data table TB20 are displayed.

Next, based on FIG. 18 and FIG. 19, the customer is a customer / payee T48 and summary initial value information T9.
The operation for setting the registration of No. 2 will be described. Figure 1
FIG. 8 is a diagram showing an example of a deposit and withdrawal book display screen W10 which is displayed when a withdrawal process is performed for the first customer in this customer account. FIG. 19 is a diagram showing a screen display after the customer has made necessary inputs to the deposit and withdrawal book display screen W10 of FIG.

In the example of FIG. 18, the withdrawal process from this account has never been performed as payment by the Yokohama City Waterworks Bureau. Therefore, the fixed summary T56 "Waterworks Yokohama Shigeido" is set as the supplier. Master table TB30
It has not been registered in. Therefore, the cashbook description T60 of the deposit and withdrawal statement data table TB20 is
The contents of the fixed summary T56 are stored (step S52: No in FIG. 12, step S46 in FIG. 13). Therefore, in the summary T112 of FIG. 18, "water supply Yokohama Shigesuido" is displayed. Further, the transaction content T104 and the customer / payee T106 are blank.

It is assumed that the customer who sees the deposit and withdrawal book display screen W10 operates the customer-side computer system 30 and inputs "Yokohama City Waterworks Bureau" to the customer / payee T106, for example. As a result, "Yokohama City Waterworks Bureau" is newly registered in the customer / payee name T84 of the customer / payee master table TB40, and a new company code T80 corresponding to this "Yokohama City Waterworks Bureau" is added. A supplier code T82 and a transaction content code T86 are assigned.

Further, the customer side computer system 30
It is assumed that, for example, the operator inputs "water charge, electricity bill, gas bill" in the summary T112 by operating. As a result, in the transaction content master table TB50, "water charge / electricity / gas fee" is registered in the summary initial value information T92 corresponding to the newly registered transaction content code T90. Further, as a result, the transaction content T10 corresponding to the transaction content code
The display of 4 is rewritten.

The data of the deposit and withdrawal detailed data table TB20 of the deposit processing and the withdrawal processing relating to this account thus accumulated are provided to the customer as a deposit and withdrawal book by classifying the journals according to the accounting processing of the customer. can do. FIG. 20 shows a deposit and withdrawal book output P with such a journal entry.
It is a figure which shows an example of 10. FIG. 20 shows an example in which the customer outputs the deposit and withdrawal book output P10 by a printer.

As shown in FIG. 20, the cash register system 50
Is the transaction content code T50 from the deposit / withdrawal statement data D10 stored in the deposit / withdrawal statement data table TB20.
It is possible to journal each code stored in and output it. In the example of FIG. 20, in the accounting process of this customer, the water charge, the electricity charge, and the gas charge, which are classified into the transaction content code “3301”, are collectively output as one.

As described above, according to the deposit / withdrawal accounting management system 10 according to the present embodiment, the customer is dealt with based on the deposit / withdrawal processing regarding the customer's account performed by the accounting system 20. By classifying the transaction details, the deposit processing and the withdrawal processing are automatically translated, so that the customer's accounting processing burden can be greatly reduced.

That is, the cash accounting system 50 specifies the transaction content by using the summary character string and summary code of the deposit / withdrawal summary T20 included in the deposit / withdrawal detail data D10 generated by the accounting system 52. The fixed summary data D30, which is a key for, is generated. Then, the cash accounting system 50 decides to classify the deposit / withdrawal statement data D10 based on the fixed summary data D30. Therefore, the customer identifies the supplier as a supplier setting master table TB3.
0, customer / payee master table TB40, and
If you register in the transaction content master table TB50,
Learning function automatically
It is possible to obtain the deposit and withdrawal book display screen W10 as shown in FIG.

Further, by using such a learning function of automatic registration, the summary initial value information T92 of the transaction content master table TB50 is stored based on the fixed summary data D30 generated from the summary character string and the summary code. Whether or not the existing data is used as the cash register summary T60 is set in advance according to the nature of the summary code by the learning classification T34 of the summary code table TB10. Therefore, it is possible to prevent automatic registration from the summary initial value information T92 for summary codes having low repeat continuity. By doing so, the validity of the data of the deposit and withdrawal book display screen W10 when the data is automatically acquired from the summary initial value information T92 can be made higher.

The present invention is not limited to the above embodiment and can be variously modified. For example, the data format of each data described above may include data items other than those described above, and the configuration of each data table described above may include data items other than those described above.

The financial institution in the above-mentioned embodiment is a broad concept including banks, life insurance companies, non-life insurance companies, trust companies, etc., where customers may open various accounts.

Further, regarding each processing described in the above-mentioned embodiment, a program for executing each processing is a flexible disk or a CD-ROM (Compact Disc).
-Read Only Memory), ROM, it can be recorded in a recording medium such as a memory card, and distributed in the form of the recording medium. In this case, the recording medium on which this program is recorded is used as each system 30, 5 of the deposit / withdrawal accounting management system 10.
The above-described embodiment can be realized by reading the data in 0, 52 and executing it.

Each system 30, 50, 52 of the deposit / withdrawal accounting management system 10 may include other programs such as an operating system and other application programs. In this case, the other program provided in each system is used, and an instruction for calling a program that realizes the same processing as the above-described embodiment from the program provided in the system is recorded on the recording medium. Good.

Further, such a program can be distributed as a carrier wave through a network instead of being distributed in the form of a recording medium. The program transmitted in the form of carrier wave on the network is the deposit / withdrawal accounting management system 1
The above-described embodiment can be realized by being loaded into each of the systems 30, 50 and 52 of No. 0 and executing this program.

Further, the program may be encrypted or compressed when it is recorded on a recording medium or when it is transmitted as a carrier wave on the network.
In this case, each system 30, 50, 52 of the deposit / withdrawal accounting management system 10 that has read the program from the recording medium or carrier wave needs to execute the program after decrypting or expanding the program. .

[0082]

As described above, according to the deposit / withdrawal data processing system according to the present invention, the deposit / withdrawal detailed data is classified based on the content of the deposit / withdrawal detailed description information contained in the deposit / withdrawal detailed data. However, since the transaction content identification information based on this classification is determined and this deposit / withdrawal statement data is stored and held together with the transaction content identification information, the accumulated deposit / withdrawal statement data is based on the transaction content identification information. Can be easily classified.

[Brief description of drawings]

FIG. 1 is a block diagram illustrating a configuration of a deposit / withdrawal accounting management system according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating a format of deposit / withdrawal detail data acquired by the cash accounting system according to the present embodiment.

FIG. 3 is a diagram illustrating a data format of a deposit / withdrawal statement summary included in the deposit / withdrawal statement data according to the present embodiment.

FIG. 4 is a diagram showing a configuration of a summary code table stored in a summary code master database according to the present embodiment.

FIG. 5 is a flowchart illustrating the contents of a fixed summary generation process executed by the cash accounting system according to the present embodiment.

6A is a diagram showing an example of a deposit / withdrawal statement summary in which "999" is stored in the summary code, and FIG.
(B) is a figure showing an example of fixed summary data generated based on this receipt-and-disbursement statement summary.

FIG. 7 (a) is a diagram showing an example of a deposit / withdrawal statement summary in which “011” is stored in the summary code.
(B) is a figure showing an example of fixed summary data generated based on this receipt-and-disbursement statement summary.

FIG. 8A is a diagram showing an example of a deposit / withdrawal statement summary in which “054” is stored in the summary code.
(B) is a figure showing an example of fixed summary data generated based on this receipt-and-disbursement statement summary.

FIG. 9A is a diagram showing an example of a deposit / withdrawal statement summary in which “090” is stored in the summary code.
(B) is a figure showing an example of fixed summary data generated based on this receipt-and-disbursement statement summary.

FIG. 10 is a diagram showing a configuration of a deposit and withdrawal statement data table stored in the deposit and withdrawal statement database according to the present embodiment (No. 1).

FIG. 11 is a diagram showing a configuration of a deposit and withdrawal statement data table stored in the deposit and withdrawal statement database according to the present embodiment (No. 2).

FIG. 12 is a flowchart for explaining deposit / withdrawal statement data generation processing executed by the cash accounting system according to the present embodiment (No. 1).

FIG. 13 is a flowchart illustrating a deposit and withdrawal statement data generation process executed by the cash accounting system according to the present embodiment (No. 2).

FIG. 14 is a diagram showing a configuration of a supplier setting master table stored in a supplier setting master database according to the present embodiment.

FIG. 15 is a diagram showing a configuration of a customer / payee master table stored in a customer / payee master database according to the present embodiment.

FIG. 16 is a diagram showing a configuration of a transaction content master table stored in a transaction content master database according to the present embodiment.

FIG. 17 is a diagram showing an example of a deposit and withdrawal book display screen displayed on the customer-side computer system of the customer when the learning function is applied.

FIG. 18 is a diagram showing an example of a deposit and withdrawal book display screen displayed on the customer-side computer system of the customer when the learning function is applied but the registration of the customer does not exist.

FIG. 19 is a diagram showing a state in which a customer inputs data on the deposit and withdrawal book display screen of FIG. 18;

FIG. 20 is a diagram showing an example of a deposit and withdrawal book output in which deposit and withdrawal statement data accumulated in a deposit and withdrawal statement data table is classified and printed based on a transaction content code.

[Explanation of symbols]

10 deposit and withdrawal accounting management system 20 Deposit / Withdrawal Data Processing System 30 Customer computer system 40 communication network 50 cash register system 52 Accounting system 60 Customer / Payee Master Database 62 Transaction Content Master Database 64 Deposit and receipt details database 66 Supplier Setting Master Database 68 Summary Code Master Database

Claims (8)

[Claims] Claim: What is claimed is: 1. Deposit / withdrawal detail data acquisition means for obtaining deposit / withdrawal detailed data of deposit processing or withdrawal processing performed on a customer's account, wherein the deposit / withdrawal detailed data is at least the deposit / withdrawal processing. A deposit / withdrawal detailed data acquisition unit that includes the amount of money processed and deposit / withdrawal detailed description information that is supplementary information about the depositing / withdrawing processing, and is included in the deposit / withdrawing detailed data. Transaction content determining means for categorizing the deposit / withdrawal statement data according to the transaction content based on the content of the deposit / withdrawal statement summary information, and determining transaction content specifying information based on the classification; A deposit / withdrawal data processing system, comprising: deposit detail data holding means for storing and holding payout detail data together with the transaction content specifying information. 2. The deposit / withdrawal statement summary information includes a summary character string and a summary code, and the transaction content determining means includes the deposit / withdrawal statement data acquired by the deposit / withdrawal statement data acquiring means. Fixed description data generating means for generating fixed description data based on the description code and the description character string included in the deposit / withdrawal statement description information, and the fixed description generated by the fixed description data generating means. The deposit / withdrawal data processing system according to claim 1, further comprising: a transaction content identification information determining unit that determines the transaction content identification information based on data. 3. The transaction content identification information determining means, which corresponds to the fixed summary data, stores the transaction identification information for identifying the transaction partner, and the transaction identification information storage means, and the transaction identification information. Corresponding to, the transaction content identification information holding means for holding the transaction content identification information, and the transaction identification information storage means is searched by using the fixed description data generated by the fixed description data generation means as a search key. , The business partner identification information corresponding to the fixed summary data is acquired, the business partner specific information search acquisition unit, and the business partner specific information acquired by the business partner specific information search acquisition unit as a search key, the transaction content And a supplier specific information search / acquisition unit that searches the specific information holding unit and acquires the transaction content specific information corresponding to the supplier specific information. Withdrawal data processing system according to 2. 4. The fixed summary data generation means, corresponding to the summary code, a summary code holding means for holding a summary name indicating the contents of deposit processing or withdrawal processing, and the deposit / withdrawal statement data acquisition means. Using the summary code included in the deposit / withdrawal statement summary information of the obtained receipt / withdrawal statement data as a search key, the summary code holding means is searched, and the summary name corresponding to the summary code is acquired. Search acquisition means, to the summary name acquired by the summary name search acquisition means,
A summary character string combination generation means for generating the fixed summary data by combining the summary character strings included in the deposit / withdrawal statement summary information of the deposit / withdrawal statement data acquired by the deposit / withdrawal statement data acquisition means. The deposit / withdrawal data processing system according to claim 2 or 3, further comprising: 5. The summary code holding means holds automatic setting information for each of the summary codes, which sets whether or not to automatically determine the transaction content specifying information by the transaction content determining means. The transaction content determination means, only when the automatic setting information corresponding to the summary code of the obtained deposit and withdrawal statement summary information is a setting for automatically determining the transaction content specifying information, the deposit and withdrawal statement 5. The transaction content identification information is determined based on the content of the summary information.
Deposit / withdrawal data processing system described in. 6. Holding deposit / withdrawal detailed data of deposit processing or withdrawal processing performed on a customer's account, and this deposit / withdrawal detailed data includes at least the amount of deposit / withdrawal processing, A method of controlling a deposit / withdrawal data processing system, comprising deposit / withdrawal statement summary information, which is supplementary information relating to the deposit / withdrawal processing, wherein the deposit / withdrawal statement data is obtained. Based on the contents of the process and the deposit / withdrawal statement summary information included in the deposit / withdrawal statement data, the deposit / withdrawal statement data is classified according to the content of the transaction, and the transaction content based on this classification A transaction content determining step of determining specific information, and a storing step of storing the deposit / withdrawal statement data together with the transaction content identifying information in a deposit statement data holding means. Data processing system control method. 7. Holding deposit / withdrawal detailed data of deposit processing or withdrawal processing performed for a customer's account, and this deposit / withdrawal detailed data includes at least the amount of deposit / withdrawal processing, A program for controlling a deposit / withdrawal data processing system, which includes deposit / withdrawal statement description information that is supplementary information regarding the deposit / withdrawal processing, wherein the deposit / withdrawal detailed data is obtained. Based on the detailed data acquisition step and the contents of the deposit / withdrawal statement summary information included in the deposit / withdrawal statement data, the deposit / withdrawal statement data is classified according to the contents of the transaction, and based on this classification Transaction content determining step of determining the transaction content specifying information, and a storing step of storing the deposit and withdrawal statement data in the deposit statement data holding means together with the transaction content specifying information. A program to be executed by the deposit / withdrawal data processing system. 8. Holding deposit / withdrawal detailed data of deposit processing or withdrawal processing performed for a customer's account, and this deposit / withdrawal detailed data includes at least the amount of deposit processing or withdrawal processing, A recording medium in which a program for controlling a deposit / withdrawal data processing system, which includes deposit / withdrawal statement summary information that is supplementary information regarding the deposit / withdrawal processing, is recorded. Acquiring the deposit / withdrawal detailed data, and classifying the deposit / withdrawal detailed data according to the contents of the transaction based on the contents of the deposit / withdrawal detailed description information included in the deposit / withdrawal detailed data. Then, a transaction content determination step of determining transaction content identification information based on this classification, and storing the deposit / withdrawal statement data together with the transaction content identification information in the deposit statement data holding means. Recording medium having a program recorded thereon for executing the storing step, to the receipt and payment data processing system.