JP2005004573A - Method for taking in bank payment data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To prevent the occurrence of system errors in a system server for payment management by removing the input abnormality of bank payment data. <P>SOLUTION: A remitter name database 3 for storing correspondence relation between remittance information such as a transferor name, a bank name, a head office/branch office name, an account number which are included in band payment data 5, and a customer code is prepared, the remittance data of the bank payment data 5 inputted to an accounting terminal 1 is compared with the remittance information stored in the remitter name database 3, the bank payment data 5 are sorted into normal data provided with the remittance information which can be processed as it is on the basis of the customer code and error data provided with remittance information which can not be processed as it is and these discriminated data are stored in a storage means 4. Since payment processing based on the customer code is applied to the bank payment data 5 which can be processed as it is on the basis of the normal data of the storage means 4, i.e. the customer code, the occurrence of system errors can be prevented in the the system server 2 for payment management. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to an improvement of a bank deposit data fetching method of an accounting system that processes bank deposit data based on a supplier code.
[0002]
[Prior art]
For example, an accounting system with an automatic journalizing function as disclosed in Patent Document 1 is well known as a system for taking in bank deposit data and automatically journalizing it.
[0003]
This accounting system with an automatic journal function adds up the amounts of invoice slips to generate transfer schedule data for each customer code, and copes with transfers made in time series related to the same customer code. Thus, the billing data is appropriately deleted.
[0004]
When the billing data is deleted, an appropriate cancellation process is performed by determining whether the billing information matches or does not match the transfer amount and confirms the matching.
[0005]
[Patent Document 1]
JP-A-11-161722 (paragraph numbers 0065 to 0067, FIGS. 5 and 6)
[0006]
[Problems to be solved by the invention]
However, all of these types of conventional accounting systems have a relationship between the transfer information such as the name of the transferor, bank name, head office name, account number, etc. and the supplier code used in the system server for deposit management. Was built on the premise that it will be used under properly matched conditions, and if you try to import bank deposit data while the account number is undecided, a data entry error or system error will occur There was a risk of causing problems.
[0007]
OBJECT OF THE INVENTION
SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to improve the inconvenience of the prior art, eliminate an abnormality in the input of bank deposit data, and reliably prevent the occurrence of a system error in a deposit management system server. Is to provide.
[0008]
[Means for Solving the Problems]
The present invention is a bank receipt data capturing method of an accounting system for processing bank receipt data based on a supplier code, and in order to achieve the above object,
Establish a transfer name database that stores the correspondence between the transfer information included in the bank deposit data and the supplier code,
Each time bank deposit data is input to the accounting terminal, the transfer information is extracted from the bank deposit data, and it is determined whether or not the transfer information is stored in the transfer person name database.
When the transfer information is stored in the transfer person name database, the bank deposit data is stored as normal data in the preprocessing storage means together with the supplier code corresponding to the transfer information,
When the transfer information is not stored in the transfer person name database, the bank deposit data is stored as error data in the preprocessing storage means.
[0009]
With such a configuration, first, when bank deposit data is input to the accounting terminal, transfer information is extracted from the bank deposit data, and it is determined whether or not this transfer information is stored in the transfer person name database. To do.
Here, when the transfer information is stored in the transfer person name database, the supplier code corresponding to this transfer information is already stored in the transfer person name database, and this bank deposit data is based on the supplier code. It means that it can be processed as it is. Therefore, when the transfer information is stored in the transfer person name database, the transfer information is stored as normal data in the preprocessing storage means together with the supplier code.
On the other hand, if the transfer information is not stored in the transfer person name database, the transfer information is incorrect or new, and the corresponding supplier code is not stored in the transfer person name database. means. Therefore, in such a case, the bank deposit data cannot be processed based on the supplier code. Therefore, when the transfer information is not stored in the transfer person name database, the bank deposit data is stored as error data in the preprocessing storage means.
In this way, transfer information is extracted from bank receipt data, compared with the transfer information in the transferee name database, and discriminated between those that can be processed as is and those that cannot be processed based on the supplier code. System errors can be prevented from occurring in the system server.
Moreover, since the error data is stored in the preprocessing storage means without being discarded, it is possible to eliminate the bank deposit data input abnormality by performing appropriate post-processing on the error data.
[0010]
Moreover, it is possible to attach a temporary business partner code to the bank deposit data and recognize it as error data.
[0011]
If such a configuration is applied, the file structure of the storage means for preprocessing should be prepared only for handling normal data records, that is, for storing business partner codes and bank deposit data in association with each other. It is easy to simplify the file structure.
[0012]
Furthermore, bank deposit data that is error data is extracted from the storage means for preprocessing, and for error data that can specify the business partner, the transfer information and the business partner code can be stored again in the transfer name database. desirable.
[0013]
Transfer money by reusing the error data stored in the preprocessing storage means and correcting the erroneous transfer information, or by adding and storing a new supplier code The personal name database will gradually be enhanced, and the subsequent process of importing bank deposit data can be carried out smoothly.
In addition, it is possible to check errors such as data entry mistakes and incorrect remittance by reconfirming error data.
[0014]
In addition, for the error data that can identify the supplier, after storing the transfer information and the supplier code in the transfer person name database,
Again, extract the bank deposit data that is the error data from the storage means for preprocessing,
Extract the transfer information from the bank receipt data that is error data, determine whether the transfer information is stored in the transfer person name database,
When the transfer information is stored in the transfer person name database, the bank deposit data is stored as normal data in the preprocessing storage means together with the supplier code corresponding to the transfer information,
If the transfer information is not stored in the transfer person name database, it is desirable to store the bank deposit data as error data in the preprocessing storage means.
[0015]
Reuse the error data to correct the erroneous transfer information, or update the transfer person name database by adding new transfer information and immediately re-create the error data based on this transfer person name database. By performing the processing, it is possible to automatically re-register the error data stored in the preprocessing storage means that can be handled as normal data as normal data.
[0016]
In addition, a system server for deposit management is connected to the storage means for preprocessing, and the bank deposit data stored together with the supplier code as normal data in the storage means for preprocessing is based on the supplier code. Make automatic deposit processing.
[0017]
Since automatic deposit processing is performed on bank deposit data that can be handled appropriately, that is, bank deposit data with a business partner code, system errors can be reliably prevented from occurring in the system server for deposit management. .
[0018]
DETAILED DESCRIPTION OF THE INVENTION
Next, an embodiment of a bank deposit data capturing method to which the present invention is applied will be described with reference to the drawings.
[0019]
FIG. 1 is a functional block diagram showing an embodiment in which the bank deposit data fetching method of the present invention is applied to an accounting system constructed on a computer system.
[0020]
This computer system generally includes an accounting terminal 1 used for input of bank deposit data, a system server 2 for deposit management, and a transfer person name database 3 composed of non-volatile storage means such as a hard disk, And the like.
[0021]
Among these, the accounting terminal 1 is constituted by a normal personal computer or workstation provided with a CPU, ROM, RAM, hard disk, monitor, keyboard and the like, and the hardware configuration is well known.
[0022]
On the hard disk of the accounting terminal 1, application data required for executing the data distribution process for distributing the bank deposit data into normal data and error data and storing it in the preprocessing storage unit 4 as error data Application program required for inconsistent data correction processing that extracts stored bank deposit data and re-stores transfer information and supplier code related to error data that can specify the supplier in the transferor name database 3; In addition, an application program and the like necessary for maintenance processing such as correction, update or confirmation of data in the transfer person name database 3 are stored.
[0023]
The bank deposit data 5 read into the accounting terminal 1 is composed of one record by transfer information such as the name of the transferor, bank name, head office name, account number, and actual data such as the transfer amount. Input processing to 1 is performed via a data communication line, a data storage medium, or the like. An example of a file summarizing several bank deposit data is shown in FIG. A data end code indicating the end of file is inserted at the position of the last record of this file.
[0024]
The transfer person name database 3 and the preprocessing storage unit 4 may be installed independently of the accounting terminal 1 or may be constructed using a part of the hard disk of the accounting terminal 1. However, the preprocessing storage means 4 is configured to allow access from both the accounting terminal 1 and the system server 2, and the transfer person name database 3 is permitted to be accessed from the accounting terminal 1. It is necessary to have a configuration to obtain.
[0025]
The transfer person name database 3 is a database for storing the correspondence between known transfer information such as the transfer person name, bank name, head office name, and account number, and the supplier code assigned to each. Regarding the input processing of the transfer information and the supplier code, for example, manual input using the keyboard of the accounting terminal 1 is possible. An example of the correspondence between the transfer information and the supplier code is shown in FIG.
[0026]
The system server 2 is composed of a normal personal computer or workstation equipped with a CPU, ROM, RAM, hard disk, monitor, keyboard, etc., and the bank deposit data is stored in the hard disk based on the supplier code. An accounting processing application program for processing is stored. The hardware and software configurations of the system server 2 are known.
[0027]
Next, the flowchart of FIG. 2 showing the outline of the data distribution process performed by the accounting terminal 1, the flowchart of FIG. 3 showing the outline of the inconsistent data correction process, and the outline of the maintenance process are shown. With reference to the flowchart of FIG. 4 and the flowchart of FIG. 5 showing the outline of the accounting process performed by the system server 2, the bank deposit data capturing method in the present embodiment will be described in detail.
[0028]
When the data distribution processing application program is started and processing of the accounting terminal 1 is started, the accounting terminal 1 first reads information for one record via a data communication line or a data storage medium (FIG. 1, FIG. 1). Step 201), it is determined whether this information is a data end code (Step 202).
[0029]
If this information is not the data end code, it means that the data of one record read this time is the bank deposit data 5, so that the accounting terminal 1 uses the bank deposit data 5, the name of the payer, the bank name, the book Transfer information such as branch name, account number, etc. is extracted, the transfer name database 3 is searched with the transfer information, and it is determined whether or not the transfer information matching the transfer information is already stored in the transfer name database 3 (Step 203).
[0030]
If the matching transfer information is already stored in the transfer person name database 3, it means that the supplier code corresponding to this transfer information is already stored in the transfer person name database 3. 1 stores the bank receipt data 5 of one record read this time together with this supplier code as normal data in the preprocessing storage means 4 (step 204).
[0031]
On the other hand, if the matching transfer information is not stored in the transfer person name database 3, the transfer information is incorrect or new, and the corresponding supplier code is not stored in the transfer person name database 3. Therefore, the accounting terminal 1 adds a temporary customer code, for example, 99999, to the bank receipt data 5 of one record read this time, and the temporary customer code and the bank of one record read this time. The deposit data 5 is stored as error data in the preprocessing storage means 4 (step 205).
[0032]
The temporary supplier code may actually be any value, but it must not be the same as the existing supplier code.
[0033]
The above processing is repeatedly executed until the data end code is read through the data communication line or the data storage medium. Finally, the data distribution processing is completed when the data end code is read.
[0034]
Therefore, for example, bank deposit data 5 as shown in FIG. 6A is read in order, and the transfer information stored in the transfer person name database 3 is as shown in FIG. 6B. If there is, the first record, the second record, and the fourth record of the bank receipt data 5 as shown in FIG. The bank record data 5 of the third record is stored in the storage unit 4 and stored in the preprocessing storage unit 4 as error data with a temporary customer code 99999. An example of the execution result is shown in FIG.
[0035]
Next, when the application program for inconsistent data correction processing is started and processing of the accounting terminal 1 is started, the accounting terminal 1 searches the storage means 4 for preprocessing and receives the bank deposit data which is error data. 5, that is, all the bank deposit data 5 with a temporary customer code 99999 is extracted, and the transfer information stored in the preprocessing storage means 4 corresponding to these, that is, the name of the transfer person, The bank name, branch name, account number, etc. are displayed on the monitor of the accounting terminal 1 (step 301 in FIG. 3).
[0036]
The operator refers to the name of the transfer person, bank name, head office name, account number, etc. displayed on the monitor, and for error data that can identify the business partner based on these transfer information, the business partner for the new business partner Use the keyboard of the accounting terminal 1 to execute code assignment, correction processing of transfer information related to obvious mistakes caused by mistakes or incorrect input of transfer information, etc. This transfer information and supplier code Is updated and stored in the transfer person name database 3 (step 302).
[0037]
For example, in the above-described example, the bank deposit data 5 of the third record shown in FIG. 6C is extracted as error data and displayed on the monitor of the accounting terminal 1. Therefore, the operator transfers Trihikiaki 3, Bank B, C Cyten, 4506084 only when the name of the transfer person, bank name, head office name, account number, etc. displayed on the monitor can be identified as valid. A person name, a bank name, a branch name, and an account number are stored in the transfer person name database 3 and, for example, an unused value such as A0003 is assigned as the supplier code.
[0038]
In this way, the bank deposit data 5 once stored as error data in the preprocessing storage means 4 is read again, and by using the inconsistent data correction process, possible data correction or addition of a supplier code, etc. By performing the processing, the contents of the transfer person name database 3 are gradually enhanced, and the processing related to the subsequent capture of bank deposit data can be smoothly performed.
[0039]
However, if error data is not extracted from the preprocessing storage unit 4 even after starting the application program for inconsistent data correction processing, nothing is displayed on the monitor and the inconsistent data correction processing is immediately terminated. The operator does not need to do anything.
[0040]
In addition, if it is not possible to identify a business partner based on these data by referring to the transfer name, bank name, head office name, account number, etc. displayed on the monitor in the inconsistent data correction process, Since it is impossible to assign the supplier code to the supplier or to correct the transfer information, the processing related to the assignment of the supplier code and the correction of the transfer information is not executed, and the contents of the transfer name database 3 are changed. Keep it as it is.
[0041]
Here, when correction of transfer information, additional allocation of a supplier code, or the like is performed on the transfer person name database 3, it is stored as error data in the storage means 4 for preprocessing at this time. There is a possibility that a part of the bank deposit data 5 can be handled as normal data.
[0042]
Therefore, the operator newly starts the application program for data distribution processing, and is given the bank deposit data stored as error data in the preprocessing storage means 4, that is, the temporary customer code 99999. For the bank deposit data, the accounting terminal 1 is made to execute the data distribution process of FIG.
[0043]
In the above-described example, the bank deposit data 5 of the third record shown in FIG. 6C is read as error data into the accounting terminal 1 (steps 201 and 202). The transfer person name database 3 is searched based on C-stain, 4506084 (step 203).
[0044]
At this stage, since the transfer information is already stored in the transfer person name database 3 by the inconsistent data correction process described above, the bank receipt data 5 of the third record shown in FIG. And the corresponding supplier code A0003 is assigned from the transferor name database 3, and together with this supplier code, the bank deposit data 5 read this time, that is, the third record shown in FIG. 6C. Is stored in the preprocessing storage means 4 as normal data (step 204).
[0045]
Specifically, rewriting from error data to normal data by rewriting the value of the temporary customer code 99999 of the bank receipt data 5 of the third record shown in FIG. That is, storage processing as normal data is performed. Therefore, even after the saving process is completed, even if the accounting terminal 1 executes the data distribution process for the bank deposit data 5 stored as the error data again, the third data shown in FIG. The bank deposit data 5 of the record is not duplicated as error data.
[0046]
Further, error data for which the corresponding transfer information is not detected from the transfer person name database 3 by the data distribution process performed on the error data in the preprocessing storage unit 4 is again determined as error data. It is held as error data in the processing storage means 4 as it is.
[0047]
If an error occurs even if the data distribution process is repeatedly executed for bank deposit data stored as error data in the preprocessing storage unit 4, there is a possibility that the transfer information itself is incorrect. Because it is expensive, it may be necessary to make inquiries to financial institutions or business partners based on one or more information such as the name of bank transfer, bank name, branch name, and account number displayed on the monitor. However, by performing the reconfirmation of the error data in this way, it is possible to reliably detect troubles such as data input mistakes and erroneous remittance.
[0048]
Finally, automatic payment processing by the system server 2 is executed on the normal data stored in the preprocessing storage unit 4 in this way.
[0049]
When the accounting server application program is started at a predetermined time at night to start processing of the system server 2, the system server 2 stores the bank deposit data 5 stored in the preprocessing storage unit 4 for each record. An accounting process such as an automatic deposit process is executed based on the value of the customer code read and stored in the record and actual data such as the transfer amount (FIG. 4, step 401).
[0050]
There are various types of software for performing accounting processing, but since it is normal for all to perform payment processing based on the supplier code, the aforementioned data distribution processing, inconsistent data correction processing, inconsistency By executing the data correction process and optimizing the supplier code of the bank deposit data 5 stored in the preprocessing storage means 4, it is possible to reliably prevent the occurrence of system errors, etc., and make smooth automatic deposits Processing can be achieved.
[0051]
In addition, when processing such as correction, update or confirmation of data in the transfer person name database 3 is started, the application program for maintenance processing is started to start processing of the accounting terminal 1, and the operation is performed by function keys or the like. Is selected (steps 501 to 504 in FIG. 5), and the functions are executed (steps 505 to 509).
[0052]
In this embodiment, transfer information and supplier code registration processing (step 505), transfer information and supplier code correction processing (step 506), and transfer information and supplier code deletion processing (step 506) with respect to the transfer person name database 3 507), reference processing (step 508) related to monitor display and printout of transfer information and supplier code, etc. can be performed, but these processing are as normal processing related to file operations. Since it is publicly known, detailed description is omitted.
[0053]
【The invention's effect】
The bank receipt data capture method of the present invention provides a transfer person name database for storing the correspondence between the transfer information included in the bank receipt data and the customer code, and the transfer information of the bank receipt data input to the accounting terminal; By comparing the transfer information stored in the transfer person's name database, the bank receipt data is converted into normal data with transfer information that can be processed as it is based on the supplier code, and transfer information that cannot be processed as it is. Since it is discriminated from the prepared error data and stored in the preprocessing storage means, it is possible to prevent the occurrence of a system error in the deposit management system server that performs deposit processing based on the supplier code.
Moreover, since the error data is stored in the preprocessing storage means without being discarded, the input abnormality of the bank deposit data can be solved by performing appropriate post-processing on the error data. .
[0054]
In addition, error data is recognized by attaching a temporary supplier code to bank deposit data, so there is no need for a special file structure for identifying normal data and error data, and the file structure is simplified. Is easy.
[0055]
In addition, bank deposit data that is error data is extracted from the storage means for preprocessing, and for error data that can specify the business partner, the incorrect transfer information is corrected, or a new business partner Since the code is added and memorized, the contents of the transfer name database are gradually enriched each time the process is repeated, so that the subsequent process of importing bank deposit data can be carried out smoothly. Become. In addition, by reconfirming the error data, it is possible to check for errors such as data entry mistakes or incorrect remittance.
[0056]
In addition, after storing the transfer information and supplier code in the transfer person's name database, the bank deposit data, which is error data at that time, is extracted again from the storage means for preprocessing, and based on the supplier code. Since the bank deposit data with the transfer information that can be processed as it is and the bank deposit data with the transfer information that cannot be processed as it is, it is discriminated again, so the error stored in the storage means for preprocessing Data that can be handled as normal data can be automatically re-registered as normal data.
[0057]
Then, the deposit management system server connected to the preprocessing storage means performs automatic deposit processing based on the supplier code for the bank deposit data stored as normal data in the preprocessing storage means. Therefore, it is possible to reliably prevent the occurrence of a system error in the deposit management system server.
[Brief description of the drawings]
FIG. 1 is a functional block diagram showing an embodiment when a bank deposit data capturing method of the present invention is applied to an accounting system constructed on a computer system.
FIG. 2 is a flowchart showing an outline of data distribution processing executed by the accounting terminal according to the embodiment;
FIG. 3 is a flowchart showing an outline of inconsistent data correction processing executed by the accounting terminal according to the embodiment;
FIG. 4 is a flowchart showing an outline of maintenance processing executed by the accounting terminal according to the embodiment;
FIG. 5 is a flowchart showing an outline of an accounting process executed by the system server of the embodiment.
FIG. 6A is a conceptual diagram showing an example of bank deposit data, and FIG. 6B shows an example of a correspondence relationship between transfer information stored in a transfer name database and a supplier code. FIG. 6C is a conceptual diagram showing an example of normal data and error data stored in the preprocessing storage means.
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 1 Accounting terminal 2 System server 3 Transfer person name database 4 Preprocessing storage means 5 Bank deposit data

Claims (5)

A bank receipt data capture method for an accounting system that processes bank receipt data based on a business partner code,
Establish a transfer name database that stores the correspondence between the transfer information included in the bank deposit data and the supplier code,
Each time bank deposit data is input to the accounting terminal, the transfer information is extracted from the bank deposit data to determine whether the transfer information is stored in the transfer person name database,
When the transfer information is stored in the transfer person name database, the bank deposit data is stored as normal data in the preprocessing storage means together with the supplier code corresponding to the transfer information,
When the transfer information is not stored in the transfer person name database, the bank receipt data capturing method is characterized in that the bank receipt data is stored as error data in a preprocessing storage means. 2. The bank receipt data fetching method according to claim 1, wherein a temporary supplier code is attached to the bank receipt data so as to be recognized as error data. The bank deposit data that is error data is extracted from the preprocessing storage means, and the error information that can identify the business partner is stored again in the transfer person name database for the transfer information and the business partner code. The bank deposit data fetching method according to claim 1 or 2. After storing the transfer information and supplier code in the transfer person name database for the error data that can identify the supplier,
Extracting the bank deposit data that is error data from the preprocessing storage means anew,
It is determined whether or not the transfer information is stored in the transfer person name database by extracting the transfer information from the bank deposit data which is error data,
When the transfer information is stored in the transfer person name database, the bank deposit data is stored as normal data in the preprocessing storage unit together with the supplier code corresponding to the transfer information,
4. The bank deposit according to claim 3, wherein, when the transfer information is not stored in the transfer person name database, the bank deposit data is retained in the preprocessing storage means as error data. Data capture method. A system server for deposit management is connected to the storage means for preprocessing, and the bank deposit data stored together with the supplier code as normal data in the storage means for preprocessing is based on the supplier code. 5. The bank deposit data fetching method according to any one of claims 1, 2, 3, and 4, wherein automatic deposit processing is performed.

Images