JP4350721B2 - Deposit management method, deposit management system and deposit management program - Google Patents

Description

  The present invention relates to a receipt management method, a receipt management system, and a receipt management program for assigning a supplier code to be used when a billing record and a receipt record are collated and deleted for each supplier in connection with collection of accounts receivable. It is.

  As one of the tasks related to the collection of accounts receivable, the billing records containing the billing details and the receipt records containing the billing details are collated, and the billing data is erased sequentially. This is a common practice. Recently, this work may be performed using a computer. For example, a technique of performing an application using EDI (Electronic Data Interchange) is also disclosed (see, for example, Patent Document 1). In the technique described in this document, the consumption process is automated by carrying the consumption key information around.

Furthermore, a technique related to a transfer processing system that performs transfer using a plurality of transfer-dedicated accounts associated with a payer is also disclosed (see, for example, Patent Document 2). In the technique described in this document, a table search is performed to determine whether the transferred account number is an account number dedicated for transfer. As a result of the table search, if the account is not dedicated to transfer, normal ledger deposit processing is performed. On the other hand, when it is an account number dedicated for transfer, the transfer account number is changed to a valid account number by adding the transfer account number and related information to a predetermined location. At this time, an account number dedicated to the transfer for each payer and related information are given to a predetermined location and notified. In a company that has set up a transfer-dedicated account, the payer can be identified by the account number used for the transfer.
JP 2001-92913 A (first page) JP 2000-82101 A (first page)

  When performing the application process, it is necessary to collate the billing record and the payment record regarding the same business partner. Here, with respect to the billing record, the biller himself / herself can be assigned a supplier code for identifying the supplier. However, with respect to the deposit record, in the case of ordinary bank transfer, the identification work of the deposit source must be identified only by a warm transfer requester name that can be freely input by the transfer requester. In the case of a name or corporate name, there are similar names and it may be difficult to uniquely identify the name. For this reason, this consumption work is a heavy load.

  In addition, EDI may not be used in business relationships. Further, when the transfer requester does not add EDI information to the transfer, the transfer cannot be performed using the EDI information. On the other hand, in the process using a transfer dedicated account, it is necessary to associate a business partner with a virtual transfer dedicated account, and the management of allocation and usage is a factor in increasing the office burden.

  The present invention has been made to solve the above-mentioned problems, and its purpose is to efficiently and accurately assign a supplier code to be used when checking and deleting a billing record and a deposit record for each supplier. To provide a deposit management method, a deposit management system, and a deposit management program.

In order to solve the above-mentioned problems, the invention according to claim 1 is characterized in that a point data storage means for recording data relating to points to be given to a matching item for each supplier, a supplier name and For each supplier, a transaction number data storage means for recording data related to the number of transactions with this supplier, and a supplier data storage means for recording information related to the matching condition corresponding to the matching item, for each supplier, In order to perform an application process of a receipt record and a billing record by using a receipt management system provided with a matching number data storage means for recording data on the number of matching times matched with the matching item at the supplier and a management computer The payment management method for assigning the supplier code of Obtaining a deposit record including information related to the transfer request content corresponding to the matching item, information relating to the transfer requester name, and information relating to the supplier name recorded in the supplier data storage means The candidate is extracted, and for each of the supplier candidates, the matching conditions recorded in the supplier data storage means are checked against the transfer request contents included in the deposit record, and the matching items are matched with the matching items. From the point acquisition processing stage for calculating the point total value to which the points recorded in the point data storage means are calculated, the supplier candidate having a high point total value in the order, and the supplier candidate when there is confirmation input suppliers is configured to impart a partner number to the payment record, the transaction number data storage hand In this case, “1” is added to the number of transactions for this business partner, and the matching number data storage means matches the matching item that matches the item of this deposit record and the item of the specified business partner record. “1” is added to the number of times, the total number of transactions is calculated for all transactions using the transaction number data storage means, and the total number ratio is calculated by dividing the number of transactions of the business partner who has entered the confirmation by the total number of transactions. Calculate the total number of matching by summing the number of matching using the matching number data storage means for the business partner, and calculate the condition ratio by dividing the number of matching by the total number of matching for each matching item, In the point data storage means, the total number ratio and the condition ratio with respect to the supplier having the confirmed input. The point is to execute a point update processing step of updating and recording a value obtained by multiplying as a point to be given to the matching item of the supplier .

The invention according to claim 2, in the payment management method according to claim 1, said matching condition includes a sending bank information on bank used when partner performs transfer, the point update processing steps, The gist of the present invention is to update and record the identification information for identifying the destination bank included in the deposit record for which the firm has been confirmed for the business partner in the business partner data storage means as the destination bank information.

According to a third aspect of the present invention, in the payment management method according to the first or second aspect , the matching condition includes payment date information relating to a transfer date on which a business partner has made a transfer, and the point is updated and recorded. The gist of the stage is to update and record the transfer date included in the deposit record for which a firm input has been entered as the deposit date information in the supplier data storage means.

The invention according to claim 4 is a point data storage means for recording data relating to points given to matching items for each business partner, and a matching condition corresponding to the business partner name and the matching item for each business partner. For the supplier data storage means for recording information on the transaction, the transaction number data storage means for recording the data on the number of transactions with this business partner for each business partner, and the matching items at this business partner for each business partner. A deposit management system comprising a matching count data storage means for recording data relating to the number of matching matches, and a management computer, and a supplier code for assigning a supplier code for performing a process of applying a deposit record and a billing record. Information about the transfer request contents corresponding to the transfer requester name and the matching item by the computer Means for obtaining a receipt record including, means for collating the information on the name of the transfer requester, and information on the name of the business partner recorded in the business partner data storage means, and extracting the business partner candidate; Each time, the matching condition recorded in the supplier data storage means and the transfer request content included in the deposit record are collated, and the points recorded in the point data storage means are given to the matching items that match. If there is a point input processing means for calculating the total point value, a means for outputting the candidate candidates having a high point total value in that order, and a confirmation input of the supplier from the supplier candidates , together with imparting partner number to the payment record in the transaction number data storage means, the "1" to the number of transactions for the suppliers pressurized In the matching number data storage means, "1" is added to the matching number of matching items in the item of the deposit record and the specified customer record item, and the transaction number data storage means The total number of transactions is calculated for all transactions, the total number ratio is calculated by dividing the number of transactions of the customer with the confirmed input by the total number of transactions, and the matching number data storage means for the customer is calculated. The total number of matching is calculated by using the total number of matching, and the ratio of the number of matching is divided by the total number of matching for each matching item. For the matching item of this supplier, a value obtained by multiplying the total ratio by the condition ratio is And a point update processing means for updating and recording as points to be given .

According to a fifth aspect of the present invention, in the payment management system according to the fourth aspect , the matching condition includes destination bank information relating to a bank used when a business partner makes a transfer, and the point update processing means includes: The gist of the present invention is to update and record the identification information for identifying the destination bank included in the deposit record for which the firm has been confirmed for the business partner in the business partner data storage means as the destination bank information.

According to a sixth aspect of the present invention, in the payment management system according to the fourth or fifth aspect , the matching condition includes payment date information relating to a transfer date on which a business partner has transferred, and the point update processing means includes: The gist of the present invention is to update and record the transfer date included in the deposit record for which the firm has been confirmed as the deposit date information as the deposit date information.

The invention according to claim 7 is a point data storage means for recording data relating to points given to matching items for each business partner, and a matching condition corresponding to the business partner name and the matching item for each business partner. For the supplier data storage means for recording information on the transaction, the transaction number data storage means for recording the data on the number of transactions with this business partner for each business partner, and the matching items at this business partner for each business partner. Payment management that assigns a supplier code for performing a process of applying a payment record and a billing record using a payment management system equipped with a matching frequency data storage means that records data on the number of matching matches and a management computer A program that corresponds to the transfer requester name and the matching item for the management computer A candidate for transaction is extracted by collating means for obtaining a deposit record including information relating to the contents of the transfer request, information relating to the name of the transfer requester, and information relating to the supplier name recorded in the supplier data storage means. And the matching condition recorded in the supplier data storage means and the transfer request content included in the deposit record for each supplier candidate, and the point data storage means for matching items matching Point acquisition processing means for calculating the point total value assigned with the points recorded in the above, means for outputting the candidate suppliers with the highest point total value in that order, and confirmation of the supplier from the supplier candidates If an input is configured to impart a partner number to the payment record in the transaction number data storing means, the suppliers It adds "1" to the number of transactions with, in the matching count data storing means, and items of the payment record, certain
"1" is added to the matching number of matching items in the field of the customer record that has been matched, and the total number of transactions is calculated for all transactions using the transaction number data storage means. The total number of transactions is calculated by dividing the number of transactions of the business partner by the total number of transactions, and for the business partner, the total number of matching is calculated using the matching number data storage means, and for each matching item Then, a condition ratio obtained by dividing the number of matching times by the total number of matching is calculated, and the value obtained by multiplying the total ratio by the condition ratio is calculated for the business partner who has received the confirmation input in the point data storage means. It is made to function as point update processing unit that updates recorded as point given to previous matching item The gist.

(Function)
According to the invention described in claim 1, 4 or 7 , the management computer acquires a deposit record including information on the transfer request content corresponding to the transfer requester name and the matching item, and information on the transfer requester name and the business partner Partner candidates are extracted by collating with information on supplier names recorded in the data storage means. Then, for each supplier candidate, the matching condition recorded in the supplier data storage means and the transfer request content included in the deposit record are collated, and the points recorded in the point data storage means for the matching items that match. The point total value to which is assigned is calculated. Then, business partner candidates with a high point total value are output in that order, and when there is a confirmation input of a business partner from among business partner candidates, a business partner code is given to this deposit record and point data In the storage means, the points of matching items that coincide with each other for the confirmed input are updated and recorded. Since the point total value is used to specify and output a probable supplier candidate, the supplier can be specified efficiently. Furthermore, since this point is calculated based on the results determined as a business partner, the accuracy can be improved.

According to the present invention, the total number of transactions is calculated for all transactions using the transaction number data storage means, and the total number ratio is calculated by dividing the number of transactions of the business partner who has made a definite input by the total number of transactions. Further, for the business partner, the total number of matching is calculated by using the matching number data storage means, and the condition ratio obtained by dividing the number of matching by the total number of matching is calculated for each matching item. Then, the value obtained by substituting the total ratio and the condition ratio into a predetermined function is updated and recorded in the point data storage means as a point to be given to the matching item of the supplier. When the points are determined using the total number of transactions, it is possible to consider a business partner with many transactions, while the points are biased to such business partners. In addition, when matching items are taken into account, it is possible to consider suppliers with fewer transactions, but the variation increases. Therefore, the point which considered the total number and the matching item can be calculated from the total number ratio and the condition ratio. Thereby, a customer can be specified accurately about a transfer requester.

According to the invention described in claim 2 or 5 , the matching condition includes destination bank information related to a bank used when a business partner makes a transfer. Then, identification information for identifying the destination bank included in the deposit record for which the firm has been confirmed for the business partner is updated and recorded in the business partner data storage means as the destination bank information. Since the transfer requester often transfers money from the same bank, the priorities of the business partner candidates can be calculated based on the information on the destination bank where the transfer was made.

According to the invention described in claim 3 or 6 , the matching condition includes payment date information related to the transfer date on which the business partner has made the transfer. Then, the transfer date included in the payment record for which the firm input has been entered for the customer is updated and recorded in the customer data storage means as the payment date information. Since the transfer requester often transfers money at the same timing, the priority order of the supplier candidates can be calculated based on the information related to the transfer date.

  According to the present invention, there is provided a deposit management method, a deposit management system, and a deposit management program for efficiently and accurately assigning a supplier code used when checking and deleting a billing record and a receipt record for each supplier. Can be provided.

  Hereinafter, an embodiment embodying the present invention will be described with reference to FIGS. In the present embodiment, a description will be given of a deposit management method, a deposit management system, and a deposit management program that are used when a bill related to accounts receivable and a deposit are applied. As shown in FIG. 1, in this embodiment, an application process is performed using a financial institution system 10 and an application processing system 20.

The consumption processing system 20 is a computer system that executes a consumption process. As shown in FIG. 1, the consumption processing system 20 includes a control unit 21, a data storage unit, an input unit 25, an output unit 26, a communication unit, and the like configured by a control unit such as a CPU, a RAM, and a ROM. A keyboard or pointing device is used for the input unit 25. As the output unit 26, a display or a printer is used.

  Further, the consumption processing system 20 is connected to the financial institution system 10 via a network and performs communication. Further, the application processing system 20 includes a master data storage unit 22, a point data storage unit 23, a billing data storage unit 33, and a deposit data storage unit 34.

  The control unit 21 of the consumption processing system 20 performs various data management processing for performing the consumption processing. This control unit performs the processes described later (each process in the deposit record acquisition stage, the supplier candidate extraction stage, the point acquisition process stage, the supplier candidate output stage, the point update process stage, etc.). By executing the deposit management program for that purpose, the control unit 21 receives deposit data registration means 211, name compression processing means 212, matching processing means 213, point acquisition processing means 214, point update processing means as shown in FIG. 215, which functions as a consumption processing unit 216.

  Here, the deposit data registration unit 211 records the transfer data received by firm banking in the deposit data storage unit 34. The name compression processing means 212 executes a compression process of the transfer requester name included in the deposit record. The matching processing means 213 assigns a supplier code for identifying the supplier by matching the supplier registered in the master data storage unit 22 with the transfer requester. The point acquisition processing unit 214 performs point acquisition processing for specifying a supplier candidate using the point data storage unit 23 when the supplier code cannot be given by the matching processing unit 213. The point update processing means 215 performs point update processing for learning by reflecting the result in the point data storage unit 23 when a business partner is specified. The application processing means 216 performs an application process for billing and payment using the assigned supplier code.

  The master data storage unit 22 functions as a supplier data storage means, and master data such as a name compression table and a supplier table is recorded. Each table in the master data storage unit 22 is initially registered when a transaction is performed, and is updated and recorded for each deposit.

  In the name compression table, data relating to a character string used for generating a compressed name from which a corporate abbreviation is deleted is recorded. Specifically, this name compression table includes data on corporate abbreviations that are normally used by transfer clients, such as “Kabushiki Kaisha”, “(K)”, “K)”, etc. It is recorded.

  The supplier table consists of field items such as supplier code, supplier name, supplier name, supplier address, destination bank information, keyword, alias, corporate abbreviation, payment date, and payment time for each customer. Account records are recorded.

Here, in the supplier code field, data relating to an identifier individually assigned to each supplier for uniquely specifying the supplier is recorded.
In each of the business partner name, business partner name, and business partner address fields, the real name of the business partner (business partner name, business partner name) and data related to the business partner address are recorded.

  In the destination bank information field, as identification information for identifying the destination bank to be used when this business partner makes a transfer, the destination bank name / code, bank branch name / code, account item name / code, account number, Each data of the account holder name is recorded.

  In the keyword field, data relating to a keyword registered in advance for specifying the name of the transfer requester is recorded. For example, when the original business partner name is “Kabushiki Kaisha Mizuhojosouken”, a character string for specifying the transfer client is used, such as “Mizuhojoshosoken”. This keyword is used to perform a matching process using a search by partial matching with the client name input by the transfer client.

  In the alias field, data relating to the transfer requester name is recorded when the customer code is confirmed and entered in the payment record in which the transfer requester name is not matched with the real name. In the alias field, a name after the name compression process is recorded, and a plurality of names can be registered as necessary.

In the corporation abbreviation field, data relating to abbreviations that are conventionally used for this business partner is recorded.
In the deposit date and deposit time fields, data relating to the previous deposit date and deposit time is recorded as deposit date information.

  The point data storage unit 23 functions as a point data storage unit, a matching number data storage unit, and a transaction number data storage unit, and records transaction number data and a point table used when judging a business partner. The transaction number data and the point table are updated every time the supplier determines. This point table is registered for each business partner, and records the number of transactions with respect to the business partner code, and the number of matching times and the number of points for each matching item.

In the supplier code field, data relating to an identifier for specifying the supplier is recorded.
In the number of transactions field, data relating to the number of times of deposits for a predetermined period at this customer is recorded.

  In the present embodiment, the destination bank code, the billing amount, the payment date, and the payment time are used as matching items. For each matching item, fields for the number of matching times and the number of points are provided. In the matching number field, data relating to the number of times matching is performed in a predetermined period in each matching item when a firm input is made is recorded. In the point number field, data relating to points to be given for determining the priority order of the business partners is recorded for this matching item.

  The billing data storage unit 33 records billing records for accounts receivable from business partners. The billing record includes the business partner name, business partner code, sales date, billing closing date, billing date, scheduled payment date, slip number and transaction details (product code, product name, quantity received, quantity, unit price, amount, total amount and Data field for recording data items such as total amount). In the present embodiment, the total amount is used as a billing amount and is applied. In addition, each billing record includes a consumption flag field. In the application flag field, an application flag is recorded when the application is completed. This application flag includes a unique application code that can identify the receipt record that has been applied. The billing record registered in the billing data storage unit 33 is sent to the business partner as electronic data or forms.

In the deposit data storage unit 34, a deposit record in which a transfer is made from a business in response to the charge is recorded. This deposit record is recorded when transfer data is acquired from the financial institution system 10. This deposit record includes a date, deposit amount, transfer requester name, destination bank information, and the like. Further, each deposit record includes a supplier code field and an application flag field. In the supplier code field, a supplier code assigned by a process described later is recorded. In the application flag field, an application flag is recorded when the application is completed. This application flag is configured to include a common application code in order to identify the request record that has been applied.

A processing procedure for performing the consumption process using the consumption processing system 20 configured as described above will be described with reference to FIGS.
(Grant customer code)
First, when a bill is received from a trading partner, a payment process is performed from the destination bank to the destination bank. Then, the control unit 21 of the application processing system 20 acquires transfer data from the financial institution system 10 of the destination bank. In the present embodiment, the deposit data registration unit 211 of the control unit 21 receives the transfer data by firm banking. Then, the deposit data registration means 211 of the control unit 21 records the transfer data in the deposit data storage unit 34.

  And the control part 21 of the consumption processing system 20 performs the matching process of a compression name and a real name (step S1-1). Specifically, first, the name compression processing means 212 of the control unit 21 acquires the transfer requester name of the deposit record recorded in the deposit data storage unit 34. If the name compression processing unit 212 detects a space in the character string of the transfer requester name, the name compression processing unit 212 deletes the space. Next, the name compression processing unit 212 generates a compressed name from which the corporate abbreviation is deleted. Specifically, when a character string included in the name compression table recorded in the master data storage unit 22 is detected in the character string of the transfer requester name in the deposit record, this character string is deleted. Then, the matching processing unit 213 searches for a business partner whose real name matches the compressed name generated by the name compression processing unit 212 in the business partner table recorded in the master data storage unit 22.

  Here, when the number (matching number) of supplier records specified in the supplier table is 1 (in the case of “1” in step S1-2), the matching processing means 213 of the control unit 21 A supplier code assigning / recording process is executed (step S1-3). Specifically, the matching processing unit 213 assigns and records a supplier code to the deposit record recorded in the deposit data storage unit 34.

  Further, the control unit 21 updates the supplier table recorded in the master data storage unit 22 for this supplier. Specifically, the matching processing means 213 of the control unit 21 adds “1” to the number of transactions for this business partner. Further, the matching processing means 213 updates the payment date and payment time of the supplier record using the payment record.

  On the other hand, if the supplier whose compressed name and real name match in the supplier table cannot be specified (in the case of “None” in step S1-2), the control unit 21 executes the matching process using the keyword and the alias. (Step S1-4). Specifically, the matching processing unit 213 searches for a business partner whose keyword or alias matches the compressed name generated by the name compression processing unit 212 in the business partner table recorded in the master data storage unit 22. .

  Here, when the number of matching is 1 (in the case of “1” in step S1-5), the matching processing means 213 of the control unit 21 executes a supplier code assignment / recording process (step S1). -3).

  Further, when a supplier whose compressed name matches a keyword or an alias cannot be specified in the supplier table (in the case of “none” in step S1-5), a supplier code cannot be assigned. Therefore, the matching processing unit 213 of the control unit 21 records the unspecified flag in the supplier code field of the deposit record in the deposit data storage unit 34 (step S1-6).

  On the other hand, when a plurality of business partner candidates are identified (in the case of “two or more” in steps S1-2 and S1-5), the control unit 21 of the application processing system 20 performs the determination process using the corporate abbreviation. Execute (Step S1-7). Specifically, the matching processing unit 213 of the control unit 21 acquires the corporate abbreviation registered in association with each supplier candidate in the supplier table recorded in the master data storage unit 22. Then, each corporate abbreviation is compared with the compressed name generated by the name compression processing means 212.

  Here, when the business partner with the same corporate abbreviation can be identified uniquely (in the case of “YES” in step S1-8), the control unit 21 of the application processing system 20 assigns and records the business partner code. Processing is executed (step S1-3). Then, using the supplier code assigned in this way, an application process (step S2-9) is performed as described later.

  On the other hand, when the corporate abbreviations match at two or more business partners and cannot be uniquely identified (in the case of “NO” in step S1-8), the control unit 21 of the application processing system 20 transacts using the number of points. A ranking process for determining the priorities of the prior candidates is executed. This process will be described with reference to FIG.

  Here, first, the control unit 21 of the application processing system 20 executes the point number extraction processing for each supplier candidate (step S2-1). Specifically, the point acquisition processing unit 214 compares the destination bank information of the deposit record with the destination bank information recorded in the supplier record of the supplier candidate. And when both correspond, using the point table recorded in the point data memory | storage part 23, the number of points regarding the matching item "destination bank" about this supplier candidate is acquired.

  Next, a billing record for the candidate supplier is extracted from the billing data storage unit, and the billing amount is specified. Then, the deposit amount recorded in the deposit record is compared with the bill amount recorded in the billing record. And when both correspond within the predetermined range, the number of points regarding the matching item “billing amount” for this supplier candidate is acquired using the point table recorded in the point data storage unit 23.

  Next, the payment date and the payment time are specified in the payment record for the candidate supplier. Then, the payment date and the payment time recorded in the payment record are compared with the payment date and the payment time recorded in the supplier record of the supplier candidate. Here, when the value of the deposit record matches the value of the supplier record within a predetermined range, the matching item “payment date” for this supplier candidate is used using the point table recorded in the point data storage unit 23. ”Or“ Deposit time ”.

  And the control part 21 of the consumption processing system 20 totals the number of points for every supplier candidate (step S2-2). Specifically, the point acquisition processing unit 214 calculates a point total value obtained by totaling the number of points acquired for each matching item from the point table in step S2-1 for each supplier candidate.

Next, the control part 21 of the consumption processing system 20 performs a rearrangement process using a point total value (step S2-3). Specifically, the point acquisition processing unit 214 generates a ranking list in which the business partner candidates are arranged in the descending order of the calculated point total value. And the control part 21 performs the display process of the supplier candidate of a high ranking (step S2-4). Specifically, a confirmation screen including the generated ranking list is displayed on the output unit 26. On this confirmation screen, various data included in the supplier record regarding the supplier candidates are displayed in the ranking order together with various data included in the deposit record. Furthermore, a selection button for selecting each supplier candidate and a free entry field for inputting a supplier not included in the ranking list are provided.

  In this case, the user confirms the ranking list and performs a confirmation input using the input unit 25. In this case, the control unit 21 of the application processing system 20 records the supplier code relating to the supplier in the deposit record (step S2-5). If the business partner cannot be specified in the ranking list, the user directly records the business partner code in the deposit record.

  Next, it is confirmed whether or not the business partner who has made the confirmation input is registered in the point data storage unit 23 (step S2-6). When selection input of a business partner not yet registered in the point data storage unit 23 is made (in the case of “NO” in step S2-6), the control unit 21 stores the transaction in the point data storage unit 23. A new registration process is performed for the destination (step S2-7). Specifically, a point table relating to this supplier is newly registered in the point data storage unit 23.

  Further, the control unit 21 updates the supplier table recorded in the master data storage unit 22 for this supplier. Specifically, the matching processing means 213 of the control unit 21 adds “1” to the number of transactions for this business partner. Further, the matching processing means 213 updates the payment date and payment time of the supplier record using the payment record. Also, the matching processing means 213 confirms whether or not the compressed name of the transfer requester name is recorded in the alias field of this supplier record. If the compressed name is not recorded, the matching processing unit 213 additionally records the compressed name in the alias field.

  On the other hand, when a user selects a business partner related to this deposit record from among business partners already registered in the point data storage unit 23 ("YES" in step S2-6). In the case), the control unit 21 of the consumption processing system 20 executes a process for updating the number of granted points (step S2-8). In this case, first, similarly to the above, the supplier table recorded in the master data storage unit 22 is updated for this supplier. Hereinafter, the update process of the number of granted points will be described with reference to FIG.

  The control unit 21 of the application processing system 20 performs a total number ratio calculation process for candidates identified as business partners (step S3-1). Specifically, the point update processing unit 215 first calculates the number of transactions of the customer and the total number of transactions. Then, the point update processing means 215 calculates the total number ratio by dividing the number of transactions by the total number of transactions.

Next, the control unit 21 calculates the number of points for each matching item for each business partner.
Specifically, the control unit 21 executes a condition ratio calculation process for items matched in the matching items (step S3-2). Specifically, the point update processing means 215 adds “1” to the matching count of matching items in the item of the deposit record and the item of the specified supplier record. Then, the point update processing means 215 calculates the total number of matchings by summing the number of matchings in this supplier's point table. Then, the condition ratio is calculated by dividing the number of matching for each matching item by the total number of matching.

  Next, the control part 21 of the consumption processing system 20 performs the update process of the number of points recorded in the point data storage part 23 (step S3-3). Specifically, the point update processing means 215 updates the value obtained by assigning the total number ratio and the condition ratio to a predetermined function (here, multiplication) for each matching item as the number of points in the point table. This number of points is used in the subsequent ranking process of the supplier candidates.

(Consumption processing)
Next, the application processing system 20 executes an application process for billing and payment (step S2-9). Specifically, the application processing unit 216 of the control unit 21 uses the billing record and the deposit record to which the same customer code is assigned to search for a record having the same billing amount. Then, when a record with the same amount is detected, the application processing unit 216 of the control unit 21 is common to the deposit record recorded in the deposit data storage unit 34 and the bill record recorded in the billing data storage unit 33. An application code is assigned and an application flag including the application code is recorded.

  In addition, when it is not possible to perform individual application, it is also possible to perform application processing using a total value obtained by adding a part or all of a billing record and a deposit record. Also in this case, the application processing unit 216 of the control unit 21 assigns a common application code to the records with the same amount of money and the records constituting the total value, and uses the application code including the application code. Record the flag.

  Furthermore, it is also possible to perform the application process using the amount range including the adjustment amount in the amount of the billing record and the deposit record. Specifically, the application processing unit 216 of the control unit 21 adds or subtracts the adjustment amount considering the transfer fee to the charge amount with respect to the charge amount. Here, the adjustment amount is an amount range (for example, “1000 yen”) that the customer can accept even when the deposit amount and the invoice amount are different, and the adjustment amount data is stored in advance in the application processing means 216. Keep it.

As described above, according to the present embodiment, the following effects can be obtained.
In the above embodiment, the supplier table is recorded in the master data storage unit 22. In this supplier table, supplier records including supplier names, supplier names, keywords, and alias fields are recorded in association with supplier codes for each supplier. And the control part 21 of the consumption processing system 20 performs the matching process of a compression name and a real name (step S1-1). Further, the control unit 21 executes matching processing using keywords and aliases (step S1-4). When the business partner can be uniquely identified, the matching processing unit 213 of the control unit 21 executes the business partner code assigning / recording process (step S1-3). Thereby, the supplier code used in the application process can be efficiently given.

  In the above embodiment, the supplier table is recorded in the master data storage unit 22. In this supplier table, a supplier record including a corporate abbreviation field is recorded in association with a supplier code for each supplier. And when a some supplier candidate is specified, the control part 21 of the consumption processing system 20 performs a determination process using a corporation abbreviation (step S1-7). Here, when the business partner with the same corporate abbreviation can be uniquely identified, the control unit 21 of the application processing system 20 executes the business partner code assigning / recording process (step S1-3). Thereby, the supplier code used in the application process can be efficiently given.

In the above embodiment, the point data storage unit 23 records a point table used when determining a business partner. And when a business partner cannot be specified uniquely, the control part 21 of the consumption processing system 20 performs the ranking process which determines the priority of a business partner candidate using the number of points. Specifically, the control unit 21 of the application processing system 20 executes point number extraction processing for each supplier candidate (step S2-1), and totals the number of points for each supplier candidate (step S2). -2). And the control part 21 performs a rearrangement process using a point total value (step S2-3), and performs the display process of the supplier candidate of a high ranking (step S2-4). Thereby, it is possible to preferentially display probable supplier candidates for each matching item by making use of matching results. Therefore, the user can specify a business partner efficiently.

  In the above embodiment, the point data storage unit 23 records a point table used when determining a business partner. This point table is updated by the point update processing means 215. Specifically, the control unit 21 of the application processing system 20 calculates a total ratio for a candidate identified as a business partner (step S3-1), and calculates a condition ratio for a matched item (step S3). -2) is executed. And the control part 21 of the consumption processing system 20 performs a point process using a total number ratio and a condition ratio (step S3-3). Specifically, the point update processing means 215 updates the value obtained by multiplying the total ratio and the condition ratio as the number of points in the point table for each matching item. If the number of points is set according to the total number of transactions, the number of points of a business partner with a large number of transactions will be high. On the other hand, if the number of points is set according to the condition ratio, the number of transactions is not taken into account and the credibility is lowered. In the present embodiment, since the number of points is calculated by a function using the total number ratio and the condition ratio, the number of points can be calculated in consideration of the number of transactions and the matching condition ratio.

  In the above embodiment, the control unit 21 updates the supplier table recorded in the master data storage unit 22 for this supplier. Specifically, the matching processing unit 213 of the control unit 21 updates the payment date and the payment time of the supplier record using the payment record. Thereby, a candidate candidate's ranking process can be performed in consideration of transaction results.

In addition, you may change the said embodiment into the following aspects.
In the above embodiment, the point data storage unit 23 records a point table used when determining a business partner. This point table is registered for each business partner, and records the number of transactions with respect to the business partner code, and the number of matching times and the number of points for each matching item. In this embodiment, the destination bank code, the billing amount, the payment date, and the payment time are used as matching items. The matching items are not limited to these, and some or other items can be used.

  (Circle) in the said embodiment, the control part 21 of the consumption processing system 20 performs a point process (step S3-3). Specifically, the point update processing means 215 updates the value obtained by multiplying the total ratio and the condition ratio as the number of points in the point table for each matching item. The method for calculating the number of points is not limited to this, and the number of points considering both can be calculated by using a function using the total number ratio and the condition ratio.

  In the above embodiment, the application processing system 20 records the supplier code related to the supplier in the receipt record (step S2-5), and then executes the billing and receipt application process (step S2-9). . Instead, if the supplier candidate ranking process is performed, the billing amount is also used as a matching item, so if the billing amount matches, the application flag is recorded directly. You may do it.

  In the above embodiment, the control unit 21 of the application processing system 20 executes point number extraction processing (step S2-1) for each supplier candidate, and totals the number of points (step S2-2). In this case, each extracted point may be weighted for each matching item. Specifically, a weighting table in which a weighting function is set for each item is held in the consumption processing system 20. And the control part 21 of the consumption processing system 20 extracts the weighting function of the matching item of this point from the weighting table with respect to the point extracted in step S2-1. Next, the control unit 21 calculates the weighted points by substituting the extracted points into the weighting function. Thereby, the weight can be attached to the points in consideration of the contents of the matching items.

1 is a schematic diagram of a system according to an embodiment of the present invention. Explanatory drawing of the process sequence of one Embodiment of this invention. Explanatory drawing of the process sequence of one Embodiment of this invention. Explanatory drawing of the process sequence of one Embodiment of this invention.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 20 ... Consumption processing system, 21 ... Control part, 211 ... Deposit data registration part, 212 ... Name compression processing means, 213 ... Matching processing means, 214 ... Point acquisition processing means, 215 ... Point update processing means, 216 ... Consumption Include processing means, 22 ... master data storage section, 23 ... point data storage section, 33 ... billing data storage section, 34 ... deposit data storage section.

Claims (7)

Point data storage means for recording data on points to be given to matching items for each business partner;
For each supplier, supplier data storage means for recording information related to the supplier name and the matching condition associated with the matching item;
Transaction number data storage means for recording data relating to the number of transactions with this supplier for each supplier,
For each business partner, a matching frequency data storage means for recording data relating to the matching frequency matched with the matching item at this business partner,
A deposit management method for assigning a supplier code for performing an application process between a receipt record and a billing record using a receipt management system including a management computer,
The management computer is
Obtaining a deposit record including information on the transfer requester name and the transfer request content corresponding to the matching item;
Collating information on the transfer requester name with information on the supplier name recorded in the supplier data storage means to extract a supplier candidate;
For each supplier candidate, the matching condition recorded in the supplier data storage means and the transfer request contents included in the deposit record are collated, and the matching items are recorded in the point data storage means. A point acquisition processing stage for calculating a point total value to which the given points are given,
The supplier candidate with a high point total value is output in that order;
When there is a confirmed input of a supplier from among the supplier candidates, a supplier code is given to this deposit record,
In the transaction number data storage means, “1” is added to the number of transactions for this customer,
In the matching number data storage means, “1” is added to the matching number of matching items in the item of the deposit record and the item of the specified customer record,
Calculate the total number of transactions for all transactions using the transaction number data storage means,
Divide the number of transactions of the customer with the confirmed input by the total number of transactions to calculate the total number ratio,
For the supplier, the total number of matching is calculated using the matching number data storage means, and the total number of matching is calculated.
For each matching item, calculate the condition ratio by dividing the number of matching times by the total number of matchings,
In the point data storage means, a point update process for updating and recording a value obtained by multiplying the total number ratio and the condition ratio as a point to be given to the matching item of the supplier with respect to the supplier having the confirmed input A deposit management method characterized by executing the steps.   The matching conditions include destination bank information relating to the bank used when the business partner makes the transfer,
  The point update processing step is characterized in that identification information for identifying a destination bank included in a deposit record for which a firm input has been entered for a business partner is updated and recorded in the business partner data storage means as destination bank information. The deposit management method according to 1.   The matching condition includes payment date information related to the transfer date on which the supplier has made the transfer,
  3. The step of updating and recording the points includes updating and recording a transfer date included in a deposit record for which a firm input has been entered as a deposit date information in the supplier data storage means. The deposit management method described in.   Point data storage means for recording data on points to be given to matching items for each business partner;
  For each supplier, supplier data storage means for recording information related to the supplier name and the matching condition associated with the matching item;
  Transaction number data storage means for recording data relating to the number of transactions with this supplier for each supplier,
  For each business partner, a matching frequency data storage means for recording data relating to the matching frequency matched with the matching item at this business partner,
  A deposit management system that includes a management computer and assigns a business partner code for performing an application process of a deposit record and a billing record,
  The management computer is
  Means for obtaining a deposit record including information on the transfer request content corresponding to the transfer requester name and the matching item;
  Means for collating information related to the transfer requester name and information relating to the supplier name recorded in the supplier data storage means, and extracting a supplier candidate;
  For each supplier candidate, the matching condition recorded in the supplier data storage means and the transfer request contents included in the deposit record are collated, and the matching items are recorded in the point data storage means. Point acquisition processing means for calculating a point total value to which the given points are given,
  Means for outputting the candidate candidates with a high point total value in that order;
  When there is a confirmed input of a supplier from among the supplier candidates, a supplier code is given to this deposit record,
  In the transaction number data storage means, “1” is added to the number of transactions for this customer,
  In the matching number data storage means, “1” is added to the matching number of matching items in the item of the deposit record and the item of the specified customer record,
  Calculate the total number of transactions for all transactions using the transaction number data storage means,
  Divide the number of transactions of the customer with the confirmed input by the total number of transactions to calculate the total number ratio,
  For the supplier, the total number of matching is calculated using the matching number data storage means, and the total number of matching is calculated.
  For each matching item, calculate the condition ratio by dividing the number of matching times by the total number of matchings,
  In the point data storage means, a point update process for updating and recording a value obtained by multiplying the total number ratio and the condition ratio as a point to be given to the matching item of the supplier with respect to the supplier having the confirmed input Means and
A deposit management system characterized by comprising:   The matching conditions include destination bank information relating to the bank used when the business partner makes the transfer,
  The point update processing means updates and records identification information for identifying a destination bank included in a deposit record for which a firm input has been entered for the supplier as destination bank information in the supplier data storage means. 4. Deposit management system according to 4.   The matching condition includes payment date information related to the transfer date on which the supplier has made the transfer,
  The said point update process means updates and records the transfer date contained in the receipt record with which the confirmation input was carried out about the supplier in the said supplier data storage means as payment date information. Payment management system.   Point data storage means for recording data on points to be given to matching items for each business partner;
  For each supplier, supplier data storage means for recording information related to the supplier name and the matching condition associated with the matching item;
  Transaction number data storage means for recording data relating to the number of transactions with this supplier for each supplier,
  For each business partner, a matching frequency data storage means for recording data relating to the matching frequency matched with the matching item at this business partner,
  A deposit management program for assigning a supplier code for performing a process of applying a deposit record and a billing record using a deposit management system including a management computer,
  The management computer,
  Means for obtaining a deposit record including information on the transfer request content corresponding to the transfer requester name and the matching item;
  Means for collating information related to the transfer requester name and information relating to the supplier name recorded in the supplier data storage means, and extracting a supplier candidate;
  For each supplier candidate, the matching condition recorded in the supplier data storage means and the transfer request contents included in the deposit record are collated, and the matching items are recorded in the point data storage means. Point acquisition processing means for calculating a point total value to which the given points are given,
  Means for outputting the candidate candidates with a high point total value in that order;
  When there is a confirmed input of a supplier from among the supplier candidates, a supplier code is given to this deposit record,
  In the transaction number data storage means, “1” is added to the number of transactions for this customer,
  In the matching number data storage means, “1” is added to the matching number of matching items in the item of the deposit record and the item of the specified customer record,
  Calculate the total number of transactions for all transactions using the transaction number data storage means,
  Divide the number of transactions of the customer with the confirmed input by the total number of transactions to calculate the total number ratio,
  For the supplier, the total number of matching is calculated using the matching number data storage means, and the total number of matching is calculated.
  For each matching item, calculate the condition ratio by dividing the number of matching times by the total number of matchings,
  In the point data storage means, a point update processing means as a point to be given to the matching item of the supplier with a value obtained by multiplying the total number ratio and the condition ratio for the supplier having the confirmed input
A deposit management program characterized by functioning as

Images