JP2004185588A - Credit negation method, credit negation device, computer program and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a credit negating method which can automatically conduct credit negation by a computer from both detailed data of billing and detailed data of payment which are extracted by the narrowing-down processing regarding a subject with regard to an amount claimed and an amount of payment, which are included in these pieces of data. <P>SOLUTION: A server 1 comprises an operation control 10, a billing detailed master 11a, a payment detailed master 12a, a customer master 13, negation procedure master 14, a transfer charge master 15, a negation program storage part 16, a RAM 17 having the negation program stored therein, a communication part 18 which makes communication with the outside world, and a temporary billing detailed master 11b and a temporary payment detailed master 12b. <P>COPYRIGHT: (C)2004,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a method for processing a debt application, an apparatus for processing a debt application, a computer program, and a recording medium.
[0002]
[Prior art]
The receivables clearing process for receivables and other receivables is performed by matching the billing statement data issued to the billing party with the receipt statement data concerning the deposit obtained from a financial institution when there is a deposit, and these data including the amount etc. Is satisfied, it is determined that there is payment for the request, and the above-described receivables clearing process is performed.
[0003]
The data to be matched for such reconciliation are as follows: billing date ≦ payment date, whether the amounts match, whether the billing party and the payment source (payment source) match, Further, there is a case such as whether or not the same number as the number (billing number) assigned to the billing statement is present in the payment statement data.
[0004]
[Problems to be solved by the invention]
Of the above items, items such as whether billing date ≤ payment date and whether the same number as the number given to the billing statement are present in the payment statement data are automatically matched to some extent using a computer. You can also.
[0005]
However, even if there is no problem in matching these items, it is not always the case that the above-mentioned reconciliation processing may be executed. For example, the billing party and the payment source (payment source) match, or the correspondence relationship between the billing party and the payment source having a specific relationship is registered as a master, and the billing statement data to be applied and the corresponding payment statement Even if the data can be specified within a certain range, if the billing amount and the deposit amount are different, the application processing cannot be performed. In particular, a plurality of claims made to a specific billing party may be collectively settled with one payment (deposit), and if one payment (deposit) is always made for one request. However, it is extremely difficult to automatically perform the matching process between the billing amount and the deposit amount using a computer or the like.
[0006]
As described above, payment is not always made in response to each request, but rather is often not made. In particular, the greater the business relationship, the more common it is to be paid (received).
[0007]
In addition, when performing receivables and other receivables reconciliation work, the target billing party (including multiple billing parties that make up a group and make payments (payments) from a specific person) In some cases, payment has already been made a plurality of times, and it is not possible to know which payment (payment) corresponds to which range of claims.
[0008]
In addition, the sum of the deposit amounts included in the plurality of receipt details data and the sum of the invoice amounts included in the plurality of receipt details data are close to a certain extent, but there is a difference. In some cases, it is difficult to determine whether or not a difference has occurred, so that the erasing process cannot be performed. This may be due to trivial reasons, such as a transfer fee (depending on the financial institution) deducted from the payment (payment). Since it is difficult to specify the reason, it must be performed manually by relying on the intuition of the person, and the above-described automation processing becomes more and more difficult.
[0009]
The present invention has been made in view of the above-described circumstances, and is described as being erased when the billing party and the payment source match or when a person having a specific relationship is determined to be the payment source on behalf of the billing party. At the stage where the billing detail data and the deposit detail data to be included can be specified, the computer calculates the billing amount and the deposit amount included in the data in accordance with a predetermined number of patterns of a reconciliation processing procedure. Accordingly, the present invention provides a method and a configuration of the apparatus for automatically executing the debt clearing process.
[0010]
In addition, if there is a so-called overpayment or underpayment that the receivable clearing process cannot be performed according to the procedure of the above-mentioned reconciliation processing pattern, the computer automatically performs a compulsory clearing process for a part of the amount as much as possible. A method and apparatus for performing the method are also proposed.
[0011]
In addition, a computer program and a recording medium that can execute such a method are also proposed.
[0012]
[Means for Solving the Problems]
The method for processing a claim reconciliation according to the present invention is characterized in that the total amount of the payment details data to be cleared stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data The total amount of the billing statement data to be reconciled, which is also stored in the data storage unit having the above, is subjected to a reconciliation process by the arithmetic unit, and the two total amounts match, or the difference between the amounts is preset. If the difference is within the error range, the calculation means performs a process of reconciling the received receipt detail data with the claim detail data in the range where the total amount matches or the claim detail data in which the amount difference is within the error range. The basic feature is that
[0013]
According to the above configuration, among a plurality of payment detail data to be applied, the total amount of the same billing detail data to be applied which has a billing date of a specific period before the latest payment date, And the total amount of the plurality of upper entry detail data is subjected to the matching process by the arithmetic means. As a result of the reconciliation process, if the calculating means determines that the total amount of the two matches or the difference between the amounts is within a predetermined error range, the calculating means determines the target payment statement data. Then, the reconciliation processing is performed between the billing detail data in the range where the total amount matches and the billing detail data in which the amount difference is within the error range.
[0014]
In the above configuration, both the billing statement data and the deposit statement data are limited to “applying target” because the billing party and the payment source (payment source) are determined from the two data. By matching, only the matching billing statement data and payment statement data are narrowed down, or the correspondence relationship between the billing party and the payment source having a specific relationship is registered in a master file or the like, and the file is referred to. By being able to specify within a certain range the billing detail data to be applied and the corresponding payment detail data, it means that only the corresponding billing detail data and payment detail data can be narrowed down. This is because it is assumed that the pre-processing of the processing performed in the configuration has already been completed.
[0015]
Also, when the two data are compared, there is a difference in the amount between the two total amounts. If the difference is within a preset error range, the difference between the target payment details data and the amount The remittance processing with the billing statement data within the range is performed because the transfer fee is deducted when the billing party makes a transfer, the difference in handling of fractions (rounding, rounding down, rounding up etc.) In many cases, errors may occur for some reason, such as when the total amount differs due to the change by the above, and if a large amount of both data is handled and the sum of the amounts contained therein is added, the total amount of both data will always be Since it may become inconsistent, the error range is determined in advance within a range where there is no problem even if the cause is not pursued, and the billing statement data and the payment statement in which the amount difference is within the error range. data This is to allow processing scrubbing of. However, since the amount of the transfer fee is fixed to some extent, the difference between the fixed amount and the total amount of the combined amount of multiple transfer fees or the amount within an integral multiple of the If they match, it is of course possible to include them as error ranges.
[0016]
Claims 2 to 6 are claims to be applied which have a billing date of a specific period before the latest payment date of the target receipt detail data defined in the above claim 1. Disclosure of data. The configuration of claim 2 stipulates that all the billing statement data whose billing date is before the latest payment date is used as such data. That is, this is a case like a pattern 1 described later.
[0017]
The structure of claim 3 also discloses billing specification data to be applied which has a billing date of a specific period before the latest payment date of the target payment specification data specified in the structure of claim 1. As such data, it is stipulated that the billing date is the billing detail data up to the last day of the month before the latest payment date. That is, this is a case like a pattern 2 described later.
[0018]
The structure of claim 4 also discloses billing specification data to be applied which has a billing date of a specific period before the latest payment date of the target payment specification data specified in the structure of claim 1. As such data, it is stipulated that the billing date is the billing detail data up to the last day of the month before the latest payment date. That is, this is a case like a pattern 3 described later.
[0019]
The structure of claim 5 also discloses billing specification data to be applied which has a billing date of a specific period before the latest payment date of the target payment specification data specified in the structure of claim 1. As such data, it is defined that the billing date is the billing detail data for the month before the latest payment date. That is, this is a case like a pattern 4 described later.
[0020]
The structure of claim 6 also discloses billing specification data to be applied which has a billing date of a specific period before the latest payment date of the target payment specification data specified in the structure of claim 1. As such data, it is stipulated that the billing date is the billing detail data for the date two months before the latest payment date. That is, this is a case like a pattern 5 described later.
[0021]
The configuration up to now specifies the configuration in which the sum of the billing amounts of all the billing statement data in a certain fixed period (including the case of all targets before a certain date) is calculated. In the configuration of No. 7, the billing amounts included in the billing detail data are sequentially added in the order of the billing date with the oldest billing date, and each time the check with the total amount of the receipt detailed data is repeatedly performed. Are matched, or if the difference between the amounts is within a preset error range, the arithmetic means performs the erasing process of both data. As a specific configuration, the data storage having the total amount of the payment details data to be applied and stored in the data storage means and the billing date before the latest payment date of the target payment details data is described. Of the billing detail data to be applied for reconciliation also stored in the means, the billing amount is added in ascending order of the billing date, and the total amount being added is subjected to a reconciliation process by the computing means, and If the sums match or if the difference between the sums is within a preset error range, the calculating means calculates the difference between the billing detail data to be processed and the billing detail data or the sum difference in the range where the total sum matches. It is characterized in that a reconciliation process is performed with the billing specification data within the error range. That is, this is a case like a pattern 6 described later.
[0022]
Further, in the above configuration, when there are a plurality of billing statement data to be applied for the same billing date, a processing procedure is determined so that the arithmetic unit performs the addition process from the data of the small billing amount (claims). Item 8).
[0023]
Furthermore, when the billing dates conflict as described above, it is difficult to perform the abutting process, but it is easier to perform the abutting process in the order of the billing number (in the order of the youngest number or the oldest number). The billing amounts included in the data are sequentially added, and each time the check with the total amount of the receipt details data is repeatedly performed, and at the time of the check, the total amounts match, or the difference between the amounts is set in advance. When the error is within the error range, the arithmetic means performs the erasing process of both data.
[0024]
As a specific configuration, the above-mentioned data having the total amount of the payment details data to be applied and stored in the data storage means and the billing date before the latest payment date of the target payment details data Of the billing detail data to be applied for resale also stored in the storage means, the billing amounts are added in ascending order of the billing number included in the data, and the total amount being added is matched by the calculating means. If the sum is equal during the processing, or if the difference between the sums is within a predetermined error range, the calculating means calculates the billing amount in the range where the sum of the sum is equal to the target payment details data. The present invention is characterized in that a reconciliation process is performed with the billing data in which the difference between the detailed data and the amount of money is within the error range (claim 9). That is, this is a case like a pattern 7 described later.
[0025]
Also, if the counterparty of the transaction decides to pay the bill on a predetermined date every month (for example, payment on the 25th of the month following the closing on the 20th of every month), the reconciliation is performed based on such scheduled recovery date. It is possible to specify billing statement data corresponding to the target payment statement data. Claim 10 stipulates such a claim clearing process based on a reconciliation process based on the scheduled collection date.
[0026]
As a more specific configuration, the data having the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date before the latest payment date of the target payment details data Of the billing statement data to be applied for similarly stored in the storage unit, the total amount of the billing statement data whose scheduled recovery date included in the data is a date before the latest payment date is calculated by the arithmetic unit. If the total amount matches or the difference between the amounts is within a preset error range, the calculating means calculates the billing amount in the range where the total amount matches the target payment details data. The present invention is characterized in that a reconciliation process is performed with the billing data in which the difference between the detailed data and the amount of money is within the error range (claim 10). That is, this is a case like a pattern 8 described later.
[0027]
The above-described claims 1 to 10 calculate the total amount of a plurality of pieces of data of the payment detail data to be applied up to that point, and store the corresponding billing detail data as described above. The reconciliation processing is performed by specifying the reconciliation processing procedure. However, according to the configuration of claims 11 to 20, for each piece of payment detail data to be reconciled, the corresponding billing statement data Is identified by the above-described abutting procedure, and the erasing process is performed. In this case, since there is only one receipt detail data to be applied, the data matched at the time of the matching process is the deposit amount itself, and the corresponding billing detail data is included in the billing detail data. When the total amount and the deposit amount match or the difference between the amounts falls within the error range, the corresponding payment statement data and billing statement data are erased. .
[0028]
Among them, the configuration of the claim clearing processing method according to claim 11 corresponds to the configuration of claim 1, and more specifically, the structure of the payment detail data to be cleared stored in the data storage means is described. The calculation unit calculates the sum of the deposit amount and the billing detail data to be applied which is also stored in the data storage unit having a billing date of a specific period before the payment date of the target receipt detail data. If the matching process is performed and the deposit amount and the total amount thereof match, or if the difference between the amounts is within a predetermined error range, the calculation unit calculates the target deposit detail data and the total amount. Is applied to the billing detail data or the billing detail data in which the difference in the amount of money is within the error range.
[0029]
The structure of the claim clearing processing method according to claim 12 corresponds to the structure of claim 2, and more specifically, in the structure of claim 11, a specific period before the payment date of the target payment specification data. Is characterized in that all the billing statement data having the billing date before the payment date is used as the billing statement data to be applied for having the billing date. That is, this is a case like a pattern 9 described later.
[0030]
The structure of the claim clearing processing method according to claim 13 corresponds to the structure of claim 3, and more specifically, in the structure of claim 11, a specific period before the payment date of the target payment specification data. As billing detail data to be applied for having the billing date of (1), billing detail data up to the last day of the month before the payment date is used. That is, this is a case like a pattern 10 described later.
[0031]
The structure of the claim clearing processing method of claim 14 corresponds to the structure of claim 4, and more specifically, in the structure of claim 11, a specific period before the payment date of the target payment details data. As billing detail data to be applied for having the billing date of (a), billing detail data up to the last day of two months before the payment date is used. That is, this is a case like a pattern 11 described later.
[0032]
The structure of the claim clearing processing method of claim 15 corresponds to the structure of claim 5, and more specifically, in the structure of claim 11, a specific period before the payment date of the target payment specification data. Is characterized in that the billing date is the billing detail data corresponding to the month before the payment date as the billing detail data to be applied having the billing date. That is, this is a case like a pattern 12 described later.
[0033]
The structure of the claim clearing processing method of claim 16 corresponds to the structure of claim 6, and more specifically, in the structure of claim 11, a specific period before the payment date of the target payment specification data. Is characterized in that the billing date is the billing date data for the date two months before the payment date as the reimbursement target billing data having the billing date. That is, this is a case like a pattern 13 described later.
[0034]
The structure of the claim clearing processing method according to claim 17 corresponds to the structure of claim 7, and more specifically, the amount of the payment detail data to be cleared stored in the data storage means, Of the billing detail data to be applied which is also stored in the data storage means having a billing date prior to the payment date of the target billing detail data, the billing amount is added in ascending order of the billing date. While the sum is being added, the sum is subjected to a matching process by the arithmetic means, and if the deposit amount matches the total amount on the way, or if the difference between the amounts is within a preset error range, The calculation means performs a process of erasing the target payment statement data, the billing statement data in the range where the deposit amount and the total amount thereof match, or the billing statement data in which the difference between the amounts is within the error range. This It is characterized in. That is, this is a case like a pattern 14 described later.
[0035]
The structure of the claim clearing processing method of claim 18 corresponds to the structure of claim 8, and more specifically, in the structure of claim 17, the claim date is the same as the clearing date. When there are a plurality of billing detail data, the above-mentioned addition processing is performed from the data of the small billing amount by the calculating means.
[0036]
The configuration of the claim clearing processing method according to claim 19 corresponds to the structure of claim 9, and more specifically, the amount of the payment detail data to be cleared stored in the data storage means, Of the billing detail data to be applied which is also stored in the data storage means having a billing date prior to the payment date of the target billing detail data, the order of the claim number included in the data is ascending. While the billing amount is being added, the total amount being added is subjected to a matching process by the arithmetic means, and the received amount and the total amount match on the way, or the difference between the amounts is set to a predetermined error range. If it is within the range, the calculation means calculates a difference between the target payment statement data, the claim statement data in the range where the deposit amount and the total amount thereof match, or the claim detail data in which the amount difference is within the error range. Erase It is characterized in that the actual processing is carried out. That is, this is a case like a pattern 15 described later.
[0037]
The structure of the claim clearing processing method of claim 20 corresponds to the structure of claim 10, and more specifically, the amount of the payment detail data to be cleared stored in the data storage means, Of the billing detail data to be applied, which is also stored in the data storage means having a billing date before the payment date of the target billing detail data, the scheduled recovery date included in the data is as described above. The total amount of the billing statement data having a date before the payment date is collated by the calculating means, and the received amount matches the total amount, or the difference between the amounts is within a predetermined error range. If so, the calculation means applies the target payment statement data to the billing statement data in the range where the deposit amount and the total amount thereof match or the claim detail data in which the amount difference is within the error range. Is characterized in that management is made. That is, this is a case like a pattern 16 described later.
[0038]
The configuration of claim 21 is a configuration in which, with respect to one payment statement data to be applied, the corresponding billing statement data is also matched for each case, and the application processing is performed. That is, the configuration of the claim clearing processing method according to the claim includes a deposit amount of the payment detail data to be cleared stored in the data storage unit and a billing date before the payment date of the target payment detail data. Of the billing detail data to be applied which is also stored in the data storage means having the above, the billing amount is collated by the computing means in ascending order of the billing date. If the amount matches or if the difference between the amounts is within a preset error range, the calculation means causes the target receipt details data to match the deposit amount and the claim amount data. The present invention is characterized in that a reconciliation process is performed with the billing statement data in which the difference between the amounts is within the error range. That is, this is a case like a pattern 17 described later.
[0039]
Claims 22 to 42 redefine the configuration of the claim clearing processing method according to claims 1 to 21 as a configuration of the apparatus.
[0040]
That is, the configuration of the claim clearing processing device of claim 22 corresponds to the configuration of claim 1 described above, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
The two sums are compared, and if the sums match or if the difference between the sums is within a preset error range, the target payment statement data and the sum of A third calculating means for performing a reconciliation process between the billing statement data and the billing statement data in which the difference between the amounts is within an error range;
It is characterized by having.
[0041]
The structure of claim 23 corresponds to the structure of claim 2, and more specifically, in claim 22, has a billing date of a specific period before the latest payment date of the payment details data. The present invention is characterized in that all billing statement data whose billing date is before the latest payment date is used as billing statement data to be applied.
[0042]
The structure of claim 24 corresponds to the structure of claim 3, and more specifically, in claim 22, has a billing date of a specific period before the latest payment date of the payment details data. The present invention is characterized in that, as the billing statement data to be applied, billing statement data whose billing date is up to the last day of the month before the latest payment date is used.
[0043]
The structure of claim 25 corresponds to the structure of claim 4, and more specifically, in claim 22, has a billing date of a specific period before the latest payment date of the payment details data. The present invention is characterized in that, as the billing detail data to be applied, billing detail data whose billing date is up to the last day of the month before the latest payment date is used.
[0044]
The structure of claim 26 corresponds to the structure of claim 5, and more specifically, in claim 22, has a billing date of a specific period before the latest payment date of the payment details data. The present invention is characterized in that, as the billing detail data to be applied, billing detail data corresponding to the month before the latest payment date is used.
[0045]
The structure of claim 27 corresponds to the structure of claim 6, and more specifically, in claim 22, has a billing date of a specific period before the latest payment date of the payment details data. The present invention is characterized in that, as the billing detail data to be applied, billing detail data corresponding to the date two months before the latest payment date is used as the billing date.
[0046]
The structure of claim 28 corresponds to the structure of claim 7, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
A second method for sequentially outputting the total amount in the middle of the addition while adding the billing amount in the order of the oldest billing date among the billing detail data having the billing date prior to the latest payment date of the payment detail data. Arithmetic means of
Each time the second calculation means outputs the total amount, the two total amounts are compared in the middle, and if the total amounts match or if the difference between the amounts is within a preset error range, A third calculating means for performing a reconciliation process between the received payment statement data and the claim statement data in the range where the total amount matches or the claim statement data in which the amount difference is within the error range;
It is characterized by having.
[0047]
The structure of claim 29 corresponds to the structure of claim 8, and more specifically, in the case of claim 28, wherein there are a plurality of claim specification data in which the claim date is the same date as the reconciliation target. Is characterized in that the above-mentioned addition processing is sequentially performed from the data of the small billed amount by the second calculating means.
[0048]
The structure of claim 30 corresponds to the structure of claim 9, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Of the billing statement data having a billing date before the most recent payment date of the above-mentioned billing statement data, while adding the billing amount in ascending order of the billing number included in the data, the total amount in the middle of the addition is calculated. Second calculating means for sequentially outputting,
Each time the second calculation means outputs the total amount, the two total amounts are compared in the middle, and if the total amounts match or if the difference between the amounts is within a preset error range, A third calculating means for performing a reconciliation process between the received payment statement data and the claim statement data in the range where the total amount matches or the claim statement data in which the amount difference is within the error range;
It is characterized by having.
[0049]
The structure of claim 31 corresponds to the structure of claim 10, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
The sum of the billing statement data having the billing date before the latest payment date of the billing statement data and the scheduled collection date included in the data having the billing date before the latest payment date. Second calculating means for calculating the amount,
The two sums are compared, and if the sums match or if the difference between the sums is within a preset error range, the target payment statement data and the sum of A third calculating means for performing a reconciliation process between the billing statement data and the billing statement data in which the difference between the amounts is within an error range;
It is characterized by having.
[0050]
The structure of claim 32 corresponds to the structure of claim 11, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the payment date of one of the receipt statement data;
The deposit amount of the deposit details data is compared with the total amount, and if the deposit amount matches the total amount, or if the difference between the amounts is within a preset error range, the target is determined. A second calculating means for performing a reconciliation process between the receipt statement data, the claim statement data in the range in which the deposit amount and the total amount thereof match, or the claim statement data in which the amount difference is within the error range
It is characterized by having.
[0051]
The structure of claim 33 corresponds to the structure of claim 12, and more specifically, in claim 32, the reconciliation having a billing date of a specific period before the deposit date of the receipt details data. The present invention is characterized in that all billing statement data whose billing date is before the payment date is used as target billing statement data.
[0052]
The structure of claim 34 corresponds to the structure of claim 13, and more specifically, in claim 32, the application having the claim date of a specific period before the deposit date of the receipt details data. The present invention is characterized in that, as the target billing detail data, billing detail data up to the last day of the month before the payment date is used.
[0053]
The structure of claim 35 corresponds to the structure of claim 14, and more specifically, in claim 32, the application method according to claim 32, which has a billing date of a specific period before the payment date of the payment detail data. The present invention is characterized in that, as the target billing detail data, billing detail data up to the last day of the month before the payment date is used.
[0054]
The structure of claim 36 corresponds to the structure of claim 15, and more specifically, in claim 32, the application having the claim date of a specific period before the deposit date of the receipt details data. The present invention is characterized in that, as the target billing detail data, the billing detail data corresponding to the month preceding the payment date is used.
[0055]
The structure of claim 37 corresponds to the structure of claim 16, and more specifically, in claim 32, the application method according to claim 32, which has a billing date of a specific period before the payment date of the payment details data. The present invention is characterized in that, as the target billing detail data, billing detail data corresponding to the date two months before the payment date is used.
[0056]
The structure of claim 38 corresponds to the structure of claim 17, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
Among the billing statement data having a billing date that is earlier than the payment date of the above-mentioned billing statement data, the billing amount is added in ascending order of the billing date, and the total amount during the addition is sequentially output. Arithmetic means of
Each time the first calculating means outputs the total amount, the deposit amount of the deposit details data is compared with the total amount on the way, and the received amount and the total amount match, or the difference between the amounts is calculated. Is within a preset error range, the target payment statement data and the claim statement data in the range in which the deposit amount and their total amount match or the claim difference data in which the amount difference is within the error range. A second calculating means for performing the elimination processing of
It is characterized by having.
[0057]
The structure of claim 39 corresponds to the structure of claim 18. More specifically, in claim 38, there is a case where there is a plurality of billing specification data in which the billing date is the same as the reconciliation date. Is characterized in that the above-mentioned addition processing is performed from the data of the small amount of money charged by the first calculating means.
[0058]
The structure of claim 40 corresponds to the structure of claim 19, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
Of the billing statement data having a billing date before the payment date of the above-mentioned billing statement data, the billing amount is added in ascending order of the billing number included in the data, and First arithmetic means for sequentially outputting,
Each time the first calculating means outputs the total amount, the deposit amount of the deposit details data is compared with the total amount on the way, and the received amount and the total amount match, or the difference between the amounts is calculated. Is within a preset error range, the target payment statement data and the claim statement data in the range in which the deposit amount and their total amount match or the claim difference data in which the amount difference is within the error range. A second calculating means for performing the elimination processing of
It is characterized by having.
[0059]
The structure of claim 41 corresponds to the structure of claim 20, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
Of the billing statement data having a billing date before the first payment date of the above-mentioned billing statement data, the scheduled collection date included in the data is the total amount of the billing statement data having a date before the payment date. First calculating means for calculating;
The deposit amount of the deposit details data is compared with the total amount, and if the deposit amount matches the total amount, or if the difference between the amounts is within a preset error range, the target is determined. A second calculating means for performing a reconciliation process between the receipt statement data, the claim statement data in the range in which the deposit amount and the total amount thereof match, or the claim statement data in which the amount difference is within the error range
It is characterized by having.
[0060]
The structure of claim 42 corresponds to the structure of claim 21 described above, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
The reconciliation process is performed between the deposit amount of the receipt detailed data and the billing date of the target receipt detail data which has a billing date earlier than the receipt date, in the order of older billing date. If the deposit amount and the charge amount match on the way, or if the difference between the amounts is within a preset error range, the target deposit statement data, the charge amount and the charge amount match. Second calculation means for performing a reconciliation process with the detail data or the claim detail data in which the difference between the amounts is within the error range;
It is characterized by having.
[0061]
The configurations of claims 43 to 63 specify a program that can be executed by the computer in order to cause the computer to execute the method defined in claims 1 to 21.
[0062]
That is, as a configuration for solving the above-mentioned problem, a computer that can execute each of the processes defined in claims 1 to 21 using a configuration of the computer and that can be read and executed by the computer. Disclose about the program. Needless to say, these configurations may be provided not only as a computer program but also as a configuration of a recording medium storing a program having a similar function (claim 64) as described later. In this case, the computer may be a general-purpose computer including the configuration of the central processing unit, or may include a dedicated machine or the like dedicated to a specific process. There is no particular limitation as long as it is accompanied.
[0063]
When such a program for causing a computer to execute each of the above processes is read out by the computer, a process similar to any one of the processes defined in claims 1 to 21 is executed.
[0064]
In addition, by executing the computer program using existing hardware resources, the method of the present invention as a new application can be easily executed on existing hardware. Further, by recording such a computer program on the above-mentioned recording medium, the computer program can be easily distributed and sold as a software product. In addition, the configuration of the recording medium may be the configuration of an internal storage device such as a RAM or a ROM or the configuration of an external storage device such as a hard disk, in addition to the above-described format. If it does, it goes without saying that it is included in the recording medium defined in the present invention.
[0065]
The function of executing a part of the processes described in claims 43 to 63 may be a function incorporated in a computer (a function incorporated in a computer as hardware). (The functions may be realized by an operating system or another application program incorporated in the computer.) The program may include an instruction to call or link a function performed by the computer. good.
[0066]
This is because a part of each processing defined in claims 43 to 63 is substituted by a part of a function achieved by, for example, an operating system, and a program or a module for realizing the function is not included. Although not directly recorded, if some of the functions of the operating system that achieve those functions are called or linked, the configuration is substantially the same.
[0067]
In addition to being used by itself, the program described above can be recorded on a recording medium, distributed or sold, and transmitted by communication or the like, as described later, and can be transferred.
[0068]
Among them, the configuration of claim 43 is a configuration corresponding to the configuration of claim 1, and the specific configuration is stored in the data storage unit by being executed by a computer having a data storage unit and an arithmetic unit. The total amount of the payment statement data to be applied and the claim to be applied which is also stored in the data storage means having a billing date of a specific period before the latest payment date of the target payment statement data. The total amount of the detailed data is subjected to a matching process by the arithmetic unit, and if the total amounts match, or if the difference between the amounts is within a predetermined error range, the calculation unit sets the target value. A computer for executing a reconciliation process between the payment statement data and the claim statement data in the range where the total amount matches or the claim statement data in which the amount difference is within the error range. Is a program.
[0069]
The structure of Claim 44 is a structure corresponding to the structure of Claim 2, and the specific structure is the same as that of Claim 43, except that the billing date of a specific period before the latest payment date of the target receipt details data is set. The present invention is characterized in that as billing detail data to be applied, all billing detail data whose billing date is before the latest payment date is used.
[0070]
The structure of Claim 45 is a structure corresponding to the structure of Claim 3, and the specific structure is the same as that of Claim 43 except that the billing date of a specific period before the latest payment date of the target payment details data is set. The present invention is characterized in that, as the billing statement data to be applied, billing statement data whose billing date is up to the last day of the month before the latest payment date is used.
[0071]
The structure of Claim 46 is a structure corresponding to the structure of Claim 4, and the specific structure is the same as that of Claim 43 except that the billing date of a specific period before the latest payment date of the target payment details data is set. The present invention is characterized in that, as the billing statement data to be applied, billing statement data whose billing date is up to the last day of the month before the latest payment date is used.
[0072]
The structure of Claim 47 is a structure corresponding to the structure of Claim 5, and the specific structure is the same as that of Claim 43 except that the billing date of a specific period before the latest payment date of the target payment specification data is set. The present invention is characterized in that, as the billing statement data to be applied, billing statement data corresponding to the month before the latest payment date is used as the billing date.
[0073]
The structure of Claim 48 is a structure corresponding to the structure of Claim 6, and the specific structure is that in Claim 43, the billing date of a specific period before the latest payment date of the target payment details data is set. The present invention is characterized in that, as the billing detail data to be applied, the billing detail data corresponding to the date two months before the latest payment date is used.
[0074]
The structure of claim 49 is a structure corresponding to the structure of claim 7, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. And the total amount of the payment details data to be applied and the billing details data to be applied which is also stored in the data storage means having a billing date before the latest payment date of the target payment details data. Among the billing amounts, the billing amounts are added in ascending order of the billing date, and the total amount being added is subjected to a matching process by the arithmetic means, and the total amounts on the way match, or the difference between the amounts is set in advance. If the difference is within the error range, the calculation unit deletes the target payment statement data from the claim statement data in the range where the total amount matches or the claim detail data in which the difference in the amount is within the error range. Is a computer program characterized by write processing is executed.
[0075]
The structure of claim 50 is a structure corresponding to the structure of claim 8, and the specific structure is that in claim 49, there is a plurality of billing specification data in which the billing date is the same as the reconciliation date. Is characterized in that the above-mentioned addition processing is performed from the data of the small amount of charge by the above-mentioned calculating means.
[0076]
The structure of claim 51 is a structure corresponding to the structure of claim 9, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. And the total amount of the payment details data to be applied and the billing details data to be applied which is also stored in the data storage means having a billing date before the latest payment date of the target payment details data. Of these, while the billing amounts are added in ascending order of the billing number included in the data, the total amount during the addition is subjected to a matching process by the arithmetic means, and the total amounts on the way match, or If the difference is within a preset error range, the calculating means causes the billing statement data in the range in which the total amount matches the billing statement data or the billing amount data in the amount difference within the error range. Is a computer program characterized by erasing narrowing process with the detailed data is performed.
[0077]
The structure of claim 52 is a structure corresponding to the structure of claim 10, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. And the total amount of the payment details data to be applied and the billing details data to be applied which is also stored in the data storage means having a billing date before the latest payment date of the target payment details data. Of these, the total amount of the billing statement data in which the scheduled collection date included in the data has a date before the latest payment date is subjected to a reconciliation process by the arithmetic means, and the two total amounts match, or If the difference is within a preset error range, the calculation means causes the billing detail data or the amount difference in the range where the total amount matches the target payment detail data to fall within the error range. Is a computer program characterized by erasing narrowing process with the determined detailed data is performed.
[0078]
The structure of claim 53 is a structure corresponding to the structure of claim 11, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. Of the deposit details data to be applied, and the billing details data to be applied, which is also stored in the data storage means having a billing date of a specific period prior to the payment date of the target receipt details data. The total amount is subjected to a matching process by the calculating means, and if the received amount matches the total amount, or if the difference between the amounts is within a predetermined error range, the calculating means The reconciliation process is executed between the received receipt detail data and the claim detail data in the range where the total amount matches or the claim detail data in which the difference in the amount is within the error range. It is over data program.
[0079]
The structure of Claim 54 is a structure corresponding to the structure of Claim 12, and the specific structure thereof is as described in Claim 53, wherein the eraser having a billing date of a specific period before the payment date of the target payment specification data is used. The present invention is characterized in that all billing statement data whose billing date is before the payment date is used as billing statement data to be included.
[0080]
The structure of claim 55 is a structure corresponding to the structure of claim 13, and the specific structure thereof is as described in claim 53, wherein the eraser having the billing date of a specific period before the payment date of the target payment specification data is described in claim 53. As the billing detail data to be included, billing detail data up to the last day of the month before the payment date is used.
[0081]
The structure of Claim 56 is a structure corresponding to the structure of Claim 14, and a specific structure thereof is as described in Claim 53, wherein an eraser having a billing date of a specific period before the payment date of the target payment details data is used. It is characterized in that as the detailed billing data to be included, the detailed billing data whose billing date is up to the last day of the month before the payment date is used.
[0082]
The structure of Claim 57 is a structure corresponding to the structure of Claim 15, and the specific structure thereof is as described in Claim 53, wherein the eraser having a billing date of a specific period before the payment date of the target payment details data is used. As the billing detail data to be included, billing detail data corresponding to the month before the payment date is used.
[0083]
The structure of claim 58 is a structure corresponding to the structure of claim 16, and the specific structure is as described in claim 53, wherein the eraser having the billing date of a specific period before the payment date of the target payment specification data is used. As billing detail data to be included, billing detail data corresponding to the date two months before the payment date is used.
[0084]
The structure of claim 59 is a structure corresponding to the structure of claim 17, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. Of the payment details of the payment details data to be included and the billing details data to be applied which are also stored in the data storage means having a billing date prior to the payment date of the target payment details data. While the billing amounts are added in ascending order of the billing date, the total amount during the addition is subjected to a matching process by the arithmetic means, and the received amount and the total amount match on the way, or If the difference is within a preset error range, the calculation means calculates the target payment statement data, the billing statement data and the amount in the range in which the above-mentioned deposit amount and their total amount match. There is a computer program characterized by processing scrub the billing statement data within the error range is performed.
[0085]
The structure of claim 60 is a structure corresponding to the structure of claim 18, and the concrete structure thereof is the case where, in claim 59, there is a plurality of billing specification data in which the billing date is the same as the reconciliation date. Is characterized in that the above-mentioned addition processing is performed from the data of the small amount of charge by the above-mentioned calculating means.
[0086]
The structure of claim 61 is a structure corresponding to the structure of claim 19, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. Of the payment details of the payment details data to be included and the billing details data to be applied which are also stored in the data storage means having a billing date prior to the payment date of the target payment details data. While the billing amount is added in ascending order of the billing number included in the data, the total amount during the addition is subjected to a matching process by the arithmetic means, and the received amount and the total amount match during the processing. Or, if the difference between the amounts is within a preset error range, the calculating means checks the amount of the received payment details in the range in which the received amount and the total amount thereof match. A computer program, characterized in that the detailed data to amount difference erasing narrowing process with the billing statement data within the error range is performed.
[0087]
The structure of claim 62 is a structure corresponding to the structure of claim 20, and more specifically, is executed by a computer having a data storage means and an arithmetic means, so that the eraser stored in the data storage means is executed. Of the payment details of the payment details data to be included and the billing details data to be applied which are also stored in the data storage means having a billing date prior to the payment date of the target payment details data. The total amount of the billing statement data whose scheduled collection date included in the data is a date before the payment date is subjected to a reconciliation process by the arithmetic means, and the received amount matches the total amount thereof, or If the difference between the amounts is within a preset error range, the calculation means calculates the billing details in the range in which the target payment details data, the above-mentioned payment amount and the total amount thereof match. Over data to the amount difference is a computer program, characterized in that the erasing narrowing process the billing statement data within the error range is performed.
[0088]
The structure of claim 63 is a structure corresponding to the structure of claim 21. More specifically, when the computer having the data storage means and the operation means executes the computer, the eraser stored in the data storage means is executed. Of the payment details of the payment details data to be included and the billing details data to be applied which are also stored in the data storage means having a billing date prior to the payment date of the target payment details data. The billing amount is compared by the calculating means in the order of the oldest billing date, and if the deposit amount and the billing amount match on the way, or if the difference between the amounts is within a preset error range, The calculation means performs a process of reconciling the target payment statement data, the claim statement data in which the deposit amount matches the billed amount, or the billing statement data in which the difference between the amounts is within an error range. Is a computer program characterized in that it is the row.
[0089]
Further, the structure of claim 64 specifies a computer-readable recording medium storing the computer program according to any one of claims 43 to 63, as described above. That is, these computer programs are stored in a recording medium, and can be used as a transaction target or actually executed.
[0090]
Claims 65 to 118 are used when there is a so-called overpayment or underpayment in which the receivables clearing process cannot be performed even in accordance with the procedure of the abutting processing pattern performed by the above-described claims 1 to 64. The present invention proposes a configuration in which a computer can automatically perform a compulsory erasure process for a part of the erasure range.
[0091]
Of these, the configuration of the claim clearing processing method according to claims 65 to 73 is characterized in that the amount of payment of the payment details data to be cleared or the total amount thereof and the specific payment date before the latest payment date of the target payment details data are There is a difference between the billing amount of the billing statement data to be applied having the billing date of the period or the total amount, and the difference is judged to be outside the preset error range. It defines the processing when there is a.
[0092]
First, the structure of the claim clearing processing method of claim 65 is as follows:
In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation and the total amount thereof are compared by the arithmetic means, there is a difference between the two amounts, and the difference is out of a preset error range. If there is payment statement data and billing statement data that have been excluded from the reconciliation process, the amount of the one statement data, which is the larger one, is calculated by the calculation means (the other Of the detailed data of one or a plurality of sums thereof) and the remaining amount, and the same amount of the two detailed data is subjected to the process of applying the two detailed data.
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or is excluded from the target of the reconciliation processing in the data storage means.
It is characterized by:
[0093]
That is, in the above-described procedure of the application processing pattern, when there is a so-called overpayment or underpayment in which the application processing cannot be performed, the above-described calculating means converts the detailed data on the large amount side into (the other detailed data). (The sum of one or a plurality of sums thereof) and the remaining amount. Then, for the same amount of both the detail data, the calculation means automatically performs the process of clearing the two detail data.
[0094]
In addition, the calculation means assigns a specific account to the remaining amount, and the remaining account amount is left in the data storage means as a reconciliation processing of the payment statement data or the billing statement data. Data is stored), forcible erasing processing is performed, or the data is stored in the data storage means and excluded from the object of the erasing processing. [The remaining amount of data is deleted from the data storage means and another processing system (for example, The data to be processed by the customer's system). In this case, as will be described later, depending on what kind of account is assigned [in the embodiment, the method of assigning the account (priority if there are a plurality of accounts) is previously registered in the customer master], Whether the payment details data or the billing details data is to be left in the data storage means as an object of reconciliation processing, whether forced reconciliation processing is performed, or whether the data storage means is excluded from the reconciliation processing objects. Decided.
[0095]
The structure of Claim 66 is a case where the deposit amount of 1 of the payment statement data which is excluded from the reconciliation processing is larger than the billing amount of the billing statement data which is also excluded from the reconciliation processing or the total amount thereof. It defines a more specific configuration of claim 65,
The calculating means divides the deposit amount of the receipt statement data into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a remaining portion. While the reconciliation process of both detail data is performed,
Further, an account of the advance payment is added to the remaining money amount by the calculating means, and the remaining money amount is left in the data storage means as a processing target of the payment detail data.
It is characterized by:
[0096]
That is, the balance is given an account of the advance payment by the calculating means, and is left in the data storage means as a processing object of the payment detail data, so that it is carried over to the next payment processing.
[0097]
The structure of claim 67 is the same as that in the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof. Claim 65 defines another specific configuration,
The calculating means divides the deposit amount of the receipt statement data into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a remaining portion. While the reconciliation process of both detail data is performed,
Further, for the remaining amount, the calculation means assigns an account of the provisional deposit and performs a forcible clearing process.
It is characterized by:
[0098]
As described above, when the provisional receipt account is attached and the forcible reconciliation process is performed, as described above, the data for the remaining amount is reconciled from the data storage means (only the reconciled result is the data). ) As data to be processed by another (e.g., customer) processing system. Subsequent processing is left to the other system.
[0099]
The structure of Claim 68 is the same as that in the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof. It defines another specific configuration of claim 65,
The calculating means divides the deposit amount of the receipt statement data into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a remaining portion. While the reconciliation process of both detail data is performed,
Further, for the remaining amount, an account item other than the accounts receivable is given by the calculating means, and is excluded from the reconciliation processing object in the data storage means.
It is characterized by:
[0100]
In this way, when an account receivable is added to the account and is excluded from the reconciliation processing in the data storage means, the data for the remaining amount is deleted from the data storage means as described above, and another processing system is used. Transferred as data to be processed. Subsequent processing is left to the other system.
[0101]
In contrast to the above, the structure of claim 69 is the same as the above, except that the billing amount of one of the billing statement data excluded from the reconciliation processing is the same as the deposit amount of the payment statement data also excluded from the reconciliation processing or the total amount thereof For a larger case, a more specific configuration of claim 65 is defined,
The calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and for the same amount of both statement data, While the reconciliation process of both detail data is performed,
Further, for the remaining amount, the calculation means adds an account item corresponding to the remaining amount of the bill, and the account is left in the data storage means as an object of the reconciliation processing of the billing statement data.
It is characterized by:
[0102]
In other words, the account of the remaining balance is added to the balance by the calculation unit, and the remaining account is left in the data storage unit as a target of the clearing process of the billing statement data, so that the balance is carried forward to the next clearing process. .
[0103]
The structure of Claim 70 is the same as that in the case where the billing amount of one of the billing statement data excluded from the reconciliation processing is larger than the deposit amount of the payment statement data also excluded from the reconciliation processing or the total amount thereof. It defines another specific configuration of claim 65,
The calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and for the same amount of both statement data, While the reconciliation process of both detail data is performed,
Further, for the remaining amount, the account means of the accounts receivable is attached by the calculating means, and the forcible clearing process is performed.
It is characterized by:
[0104]
As described above, when the account of the accounts receivable is attached and the forcible reconciliation process is performed, the data for the remaining amount of the bill is reconciled from the data storage means (only the reconciled result is stored as data). Transferred as data to be processed by another (eg, customer side) processing system. Subsequent processing is left to the other system.
[0105]
Further, the structure of claim 71 is the structure of claims 65 to 70, wherein the remaining amount of the detailed data subjected to the division processing is the amount of the other remaining detailed data or a plurality of totals. If the amount is larger than the amount, it specifies that the division process and the reconciliation process of both detail data are performed repeatedly,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the reconciliation processing of the two detailed data, and the remaining amount is changed to the amount of the other remaining detailed data or a plurality of the remaining amount data. When the amount becomes smaller than the total amount, a specific account item is added to the remaining amount by the arithmetic means, and is left in the data storage means as a processing target of the payment statement data or the billing statement data. Forced erase processing is performed, or excluded from the erase processing target in the data storage means
It is characterized by:
[0106]
The structure of claim 72 is the same as in claim 69 or claim 70, except that the billing amount of one of the billing statement data which has been excluded from the reconciliation processing is the same as that of the receipt statement data which has also been excluded from the reconciliation processing. A specific structure is stipulated when the amount is larger than the total amount or the total amount,
In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation and the total amount thereof are compared by the arithmetic means, there is a difference between the two amounts, and the difference is out of a preset error range. Is determined, there is the payment statement data and the billing statement data that have been excluded from the reconciliation processing, and the billing amount of 1 of the billing statement data that has been excluded from the reconciliation processing is also the same as the reconciliation processing. In the case where the deposit amount is larger than the deposit amount or the total amount of the deposit detail data which is excluded from the target, the calculation means sets the charge amount of the claim detail data to (the deposit amount of the deposit detail data or the total amount thereof). Forehead) and equivalent, is divided into a remaining amount of money, both detailed data per the same amount min, with processing scrub both detailed data is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process.
It is characterized by:
[0107]
As described above, the payment details data of the discount amount corresponding to the remaining amount of the billing details data is newly created in the section of "discount", and the reconciliation process is performed in accordance with the lending and borrowing.
[0108]
The structure of claim 73 is the structure of claim 72, wherein the remaining amount of the billing statement data subjected to the division processing is larger than the amount of the other remaining receipt statement data or a plurality of total amounts. In this case, it is specified that the above-mentioned division process and the reconciliation process of both detail data are performed repeatedly,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the erasing process of both the detail data, and the remaining amount of the billing detail data is converted to the other remaining payment detail data. When the amount becomes smaller than the total amount or a plurality of total amounts, the above-mentioned calculating means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, and sets Is attached and forced reconciliation is performed
It is characterized by:
[0109]
On the other hand, the configuration of the claim reconciliation processing method according to claims 74 to 82 is characterized in that the receivable amount of the payment details data to be cleared or the total amount thereof and a specific payment date before the latest payment date of the target payment details data are set. In the reconciliation process, once the reconciliation process is performed in accordance with the procedure of the reconciliation processing pattern described above, the remaining amount If there are payment details data and billing details data that have been excluded from the so-called reconciliation processing (that is, the amount included in both the remaining data cannot be processed in the above reconciliation processing pattern, (A case where there is a difference and the difference is an overpayment or an underpayment in which the difference is determined to be out of a preset error range).
[0110]
The structure of the claim clearing processing method of claim 74 is as follows:
In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation or the total amount thereof is subjected to a matching process by the calculating means, the two amounts match, or the difference between the two amounts is a predetermined error. It is determined that it is within the range, and within that range, the reconciliation process of the targeted payment statement data and billing statement data is performed,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. When there is received receipt statement data and billing statement data, the amount of one statement data, which is the larger amount, is calculated by the above-mentioned calculating means into an amount equivalent to (the amount of one statement of the other statement data or a plurality thereof). , And the remaining amount is divided. For the same amount of the two items of data, the reconciliation process of both items of data is performed.
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or is excluded from the target of the reconciliation processing in the data storage means.
It is characterized by:
[0111]
In other words, after the reconciliation processing of both the detailed data is performed once according to the above-described reconciliation processing pattern, there are remaining payment details data and billing details data which are excluded from the so-called reconciliation processing (that is, the remaining two data sets). The amount included in the amount cannot be processed in the above-described reconciliation processing pattern, there is a difference between the two amounts, and the difference is an overpayment or an underpayment that is determined to be outside the preset error range. In the case), the calculation means divides the detail data on the large amount of money into an amount corresponding to (one amount of the other details data or a plurality of total amounts thereof) and the remaining amount. Then, for the same amount of both the detail data, the calculation means automatically performs the process of clearing the two detail data.
[0112]
For the remaining money, a specific account is given by the calculating means, and a forced reconciliation process is performed, which is left in the data storage means as a reconciliation processing of the payment statement data or the billing statement data. Performed, or is excluded from the object of the erasing process in the data storage means. In this case, as will be described later, depending on what kind of account is assigned [in the embodiment, the method of assigning the account (priority if there are a plurality of accounts) is previously registered in the customer master], Whether the payment details data or the billing details data is to be left in the data storage means as an object of reconciliation processing, whether forced reconciliation processing is performed, or whether the data storage means is excluded from the reconciliation processing objects. Decided.
[0113]
The structure of claim 75 is that, when the deposit amount of one of the receipt details data which has been excluded from the reconciliation processing is larger than the billed amount or the total amount of the billing details data which has also been excluded from the reconciliation processing, It defines a more specific configuration of claim 74,
The calculating means divides the deposit amount of the receipt statement data into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a remaining portion. While the reconciliation process of both detail data is performed,
Further, an account of the advance payment is added to the remaining money amount by the calculating means, and the remaining money amount is left in the data storage means as a processing target of the payment detail data.
It is characterized by:
[0114]
The structure of Claim 76 is also similar to the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof. Claim 74 defines another specific configuration,
The calculating means divides the deposit amount of the receipt statement data into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a remaining portion. While the reconciliation process of both detail data is performed,
Further, for the remaining amount, the calculation means assigns an account of the provisional deposit and performs a forcible clearing process.
It is characterized by:
[0115]
The configuration of claim 77 is the same as that in the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof. It defines another specific configuration of claim 74,
The calculating means divides the deposit amount of the receipt statement data into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a remaining portion. While the reconciliation process of both detail data is performed,
Further, for the remaining amount, an account item other than the accounts receivable is given by the calculating means, and is excluded from the reconciliation processing object in the data storage means.
It is characterized by:
[0116]
In contrast to the above, the structure of claim 78 is the same as the above, except that the billing amount of one of the billing statement data excluded from the reconciliation processing is the same as the deposit amount of the payment statement data also excluded from the reconciliation processing or the total amount thereof In the case of being larger, a more specific configuration of claim 74 is defined,
The calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and for the same amount of both statement data, While the reconciliation process of both detail data is performed,
Further, for the remaining amount, the calculation means adds an account item corresponding to the remaining amount of the bill, and the account is left in the data storage means as an object of the reconciliation processing of the billing statement data.
It is characterized by:
[0117]
The structure of claim 79 is the same as that in the case where the charge amount of one of the billing statement data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment statement data which has also been excluded from the reconciliation processing. It defines another specific configuration of claim 74,
The calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and for the same amount of both statement data, While the reconciliation process of both detail data is performed,
Further, for the remaining amount, the account means of the accounts receivable is attached by the calculating means, and the forcible clearing process is performed.
It is characterized by:
[0118]
Further, the structure of Claim 80 is the structure of Claims 74 to 79, wherein the remaining amount of the detailed data subjected to the division processing is the amount of the other remaining detailed data or a plurality of totals. If the amount is larger than the amount, it specifies that the division process and the reconciliation process of both detail data are performed repeatedly,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the reconciliation processing of the two detailed data, and the remaining amount is changed to the amount of the other remaining detailed data or a plurality of the remaining amount data. When the amount becomes smaller than the total amount, a specific account item is added to the remaining amount by the arithmetic means, and is left in the data storage means as a processing target of the payment statement data or the billing statement data. Forced erase processing is performed, or excluded from the erase processing target in the data storage means
It is characterized by:
[0119]
The structure of Claim 81 is the same as that of Claims 78 and 79, except that the billing amount of 1 of the billing statement data which has been excluded from the reconciliation processing is the same as that of Claim 78. A specific structure is stipulated when the amount is larger than the total amount or the total amount,
In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation or the total amount thereof is subjected to a matching process by the calculating means, the two amounts match, or the difference between the two amounts is a predetermined error. It is determined that it is within the range, and within that range, the reconciliation process of the targeted payment statement data and billing statement data is performed,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. Payment data and billing statement data, and the charge amount of one of the billing statement data that was excluded from the reconciliation processing is equal to the sum or the total amount of the payment statement data that was also excluded from the reconciliation processing. If it is larger, the calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and For each amount, the reconciliation process of both detail data is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process.
It is characterized by:
[0120]
In the structure of claim 82, in the structure of claim 81, the remaining amount of the billing statement data subjected to the division processing is larger than the amount of the other remaining receipt statement data or a plurality of total amounts. In this case, it is specified that the above-mentioned division process and the reconciliation process of both detail data are performed repeatedly,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the erasing process of both the detail data, and the remaining amount of the billing detail data is converted to the other remaining payment detail data. When the amount becomes smaller than the total amount or a plurality of total amounts, the above-mentioned calculating means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, and sets Is attached and forced reconciliation is performed
It is characterized by:
[0121]
On the other hand, in claims 83 to 100, the configuration of the claim clearing processing method in claims 65 to 82 is redefined as the configuration of the apparatus.
[0122]
That is, the structure of the claim clearing processing device of claim 83 corresponds to the structure of claim 65, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
At the time of determining whether or not the erasing process is possible by the third arithmetic means, there is a difference between the two amounts of money between the two detailed data, and it is determined that the difference is outside the preset error range. When there are payment statement data and billing statement data that have become outside, the amount of the one statement data of the larger amount is calculated as (an amount of one of the other statement data or a total thereof), A fourth calculating means for dividing the data into the remaining amount and performing the process of applying the two detailed data to the same amount of the two detailed data;
For the remaining amount, add a specific account, leave it in the data storage unit as the target of the reconciliation processing of the payment details data or billing details data, perform a compulsory reconciliation process, or Control means to remove from the reconciliation process
It is characterized by having.
[0123]
The structure of Claim 84 corresponds to the structure of Claim 66. As a more specific structure of Claim 83,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the fourth arithmetic means The deposit amount of the receipt detail data is divided into a portion corresponding to (the billing amount of the billing detail data or the total amount thereof) and a portion corresponding to the remaining amount. Processing is performed,
Further, the control means assigns an account of the advance receipt to the remaining amount, and the remaining account amount is left as an object of the payment processing of the payment details data in the data storage means.
[0124]
The configuration of claim 85 corresponds to the configuration of claim 67, and as a more specific configuration of claim 83,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the fourth arithmetic means The deposit amount of the receipt detail data is divided into a portion corresponding to (the billing amount of the billing detail data or the total amount thereof) and a portion corresponding to the remaining amount. Processing is performed,
Further, for the remaining amount, the account of the provisional deposit is added by the control means, and the forcible clearing process is performed.
It is characterized by:
[0125]
The structure of Claim 86 corresponds to the structure of Claim 68. As a more specific structure of Claim 83,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the fourth arithmetic means The deposit amount of the receipt detail data is divided into a portion corresponding to (the billing amount of the billing detail data or the total amount thereof) and a portion corresponding to the remaining amount. Processing is performed,
Further, for the remaining amount, an account item other than the accounts receivable is given by the control means, and is excluded from the reconciliation processing object in the data storage means.
It is characterized by:
[0126]
The configuration of claim 87 corresponds to the configuration of claim 69, and as a more specific configuration of claim 83,
When the billing amount of one of the billing statement data that has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the billing statement data that has also been excluded from the reconciliation processing, the fourth arithmetic unit performs The billing amount of the billing detail data is divided into a portion corresponding to (the deposit amount or the total amount of the above-mentioned receipt detail data) and the remaining amount. Processing is performed,
Further, the control means assigns an account item corresponding to the remaining amount of the remaining amount, and the remaining account amount is left in the data storage means as an object of the reconciliation processing of the invoice detail data.
It is characterized by:
[0127]
The configuration of claim 88 corresponds to the configuration of claim 70, and as a more specific configuration of claim 83,
When the billing amount of one of the billing statement data that has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the billing statement data that has also been excluded from the reconciliation processing, the fourth arithmetic unit performs The billing amount of the billing detail data is divided into a portion corresponding to (the deposit amount or the total amount of the above-mentioned receipt detail data) and the remaining amount. Processing is performed,
Further, for the remaining amount, an account of accounts receivable is added by the control means, and a forcible clearing process is performed.
It is characterized by:
[0128]
The structure of Claim 89 corresponds to the structure of Claim 71. In the structure of Claims 83 to 88, the remaining amount of the detailed data that has been subjected to the division processing is the other amount. When the amount is larger than the amount of the remaining detailed data or the total amount of the plurality, the above-mentioned division processing and the reconciliation processing of both the detailed data are performed repeatedly,
In such cases,
With respect to the remaining amount, the fourth calculation means repeats the above-described dividing process of the amount and the erasing process of both the detail data, and the remaining amount becomes the amount of the other remaining detail data. Or, when the total amount becomes smaller than the total amount, a specific account item is added to the remaining amount by the control means, and the data storage means is used as a target for reconciliation of the payment statement data or the billing statement data. Remaining, forcible erase processing is performed, or excluded from the erase processing target in the data storage means
It is characterized by:
[0129]
The structure of claim 90 corresponds to the structure of claim 72, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
At the time of determining whether or not the erasing process is possible by the third arithmetic means, there is a difference between the two amounts of money between the two detailed data, and it is determined that the difference is outside the preset error range. If the billing amount of one of the billing detail data that has been excluded is larger than the deposit amount of the receipt detail data that has also been excluded from the reconciliation processing or the total amount thereof, the billing amount of the billing detail data is calculated as ( A fourth calculating unit that divides the amount corresponding to the data amount or the total amount thereof) into a portion corresponding to the remaining amount and a portion corresponding to the same amount of both the detail data, and performs a reconciliation process of both detail data;
Control means for temporarily creating payment details data of a discount amount corresponding to the remaining amount of the billing details data, attaching a discount account thereto, and performing a forcible clearing process;
It is characterized by having.
[0130]
The structure of claim 91 corresponds to the structure of claim 73. In the structure of claim 90, the remaining amount of the billing specification data that has been subjected to the division processing is the other. It stipulates that the above-mentioned division process and the reconciliation process of both detail data are performed repeatedly when it is larger than the amount of the receipt details data or the total amount of a plurality of receipts,
In such cases,
With respect to the remaining amount, the above-mentioned dividing process of the amount and the erasing process of both detail data are further repeated by the fourth calculating means, and the remaining amount of the billing detail data is left as the other portion. When it becomes smaller than the amount of the receipt details data or a plurality of total amounts, the control means temporarily creates the receipt details data of the discount amount corresponding to the remaining amount of the claim details data, and makes a Account is attached and forced reconciliation is performed
It is characterized by:
[0131]
The structure of the claim clearing processing apparatus of claim 92 corresponds to the structure of claim 74, and more specifically,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
A fourth calculating means for performing a clearing process on the received receipt details data and billing detail data within a range where the clearing process is determined to be possible;
The third calculation means determines that there is a difference between the two amounts of data remaining after the reconciliation processing by the fourth calculation means, and that the difference is outside the preset error range. As a result, if there is payment statement data and billing statement data that have been excluded from the reconciliation process, the larger one of the statement data is replaced by the one of the other statement data The total amount) and the remaining amount are divided, and the fourth arithmetic unit issues an instruction to execute the process of applying both the detail data for the same amount of the detail data. 5 calculation means;
For the remaining amount, add a specific account, leave it in the data storage unit as the target of the reconciliation processing of the payment details data or billing details data, perform a compulsory reconciliation process, or Control means to remove from the reconciliation process
It is characterized by having.
[0132]
The configuration of claim 93 corresponds to the configuration of claim 75, and as a more specific configuration of claim 92,
In the case where the deposit amount of 1 of the payment statement data excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof, the fifth arithmetic unit The deposit amount of the receipt statement data is divided into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a portion corresponding to the remaining amount. , The reconciliation process of both detail data is performed,
Further, the control means assigns an account of the advance receipt to the remaining amount, and the remaining account amount is left as an object of the payment processing of the payment details data in the data storage means.
[0133]
The configuration of claim 94 corresponds to the configuration of claim 76, and as a more specific configuration of claim 92,
In the case where the deposit amount of 1 of the payment statement data excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof, the fifth arithmetic unit The deposit amount of the receipt statement data is divided into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a portion corresponding to the remaining amount. , The reconciliation process of both detail data is performed,
Further, for the remaining amount, the account of the provisional deposit is added by the control means, and the forcible clearing process is performed.
It is characterized by:
[0134]
The configuration of claim 95 corresponds to the configuration of claim 77. As a more specific configuration of claim 92,
In the case where the deposit amount of 1 of the payment statement data excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof, the fifth arithmetic unit The deposit amount of the receipt statement data is divided into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a portion corresponding to the remaining amount. , The reconciliation process of both detail data is performed,
Further, for the remaining amount, an account item other than the accounts receivable is given by the control means, and is excluded from the reconciliation processing object in the data storage means.
It is characterized by:
[0135]
The configuration of claim 96 corresponds to the configuration of claim 78. As a more specific configuration of claim 92,
In the case where the billing amount of one of the billing statement data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the receipt statement data which has also been excluded from the reconciliation processing, the fifth calculating means The billing amount of the billing detail data is divided into an amount corresponding to (the deposit amount of the deposit detail data or the total amount thereof) and a remaining amount, and the fifth calculating means calculates the same amount of the same amount of both the detail data. , The reconciliation process of both detail data is performed,
Further, the control means assigns an account item corresponding to the remaining amount of the remaining amount, and the remaining account amount is left in the data storage means as an object of the reconciliation processing of the invoice detail data.
It is characterized by:
[0136]
The configuration of claim 97 corresponds to the configuration of claim 79, and as a more specific configuration of claim 92,
In the case where the billing amount of one of the billing statement data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the receipt statement data which has also been excluded from the reconciliation processing, the fifth calculating means The billing amount of the billing detail data is divided into an amount corresponding to (the deposit amount of the deposit detail data or the total amount thereof) and a remaining amount, and the fifth calculating means calculates the same amount of the same amount of both the detail data. , The reconciliation process of both detail data is performed,
Further, for the remaining amount, an account of accounts receivable is added by the control means, and a forcible clearing process is performed.
It is characterized by:
[0137]
The structure of claim 98 corresponds to the structure of claim 80. In the structure of claims 92 to 97, the remaining amount of the detailed data that has been subjected to the division processing is the other. When the amount is larger than the amount of the remaining detailed data or the total amount of the plurality, the above-mentioned division processing and the reconciliation processing of both the detailed data are performed repeatedly,
In such cases,
With respect to the remaining amount, the fifth calculation means repeats the above-described division processing of the amount and the reconciliation processing of both the detail data, and the remaining amount becomes the amount of the other remaining detail data. Or, when the total amount becomes smaller than the total amount, a specific account item is added to the remaining amount by the control means, and the data storage means is used as a target for reconciliation of the payment statement data or the billing statement data. Remaining, forcible erase processing is performed, or excluded from the erase processing target in the data storage means
It is characterized by:
[0138]
The structure of claim 99 corresponds to the structure of claim 81, and as a more specific structure,
Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
A fourth calculating means for performing a clearing process on the received receipt details data and billing detail data within a range where the clearing process is determined to be possible;
The third calculation means determines that there is a difference between the two amounts of data remaining after the reconciliation processing by the fourth calculation means, and that the difference is outside the preset error range. As a result, there are payment statement data and billing statement data that have been excluded from the reconciliation processing, and the payment amount of 1 of the billing statement data that has been excluded from the reconciliation processing has also been excluded from the reconciliation processing. When it is larger than the deposit amount of the detailed statement data or the total amount thereof, the charge amount of the billing detailed statement data is divided into a portion corresponding to (the deposit amount or the total amount of the above-mentioned deposit detail data) and a remaining amount, Fifth computing means for giving an instruction to perform the clearing process of both detail data by the fourth computing means for the same amount of both detail data,
Control means for temporarily creating payment details data of a discount amount corresponding to the remaining amount of the billing details data, attaching a discount account thereto, and performing a forcible clearing process;
It is characterized by having.
[0139]
The structure of claim 100 corresponds to the structure of claim 82. In the structure of claim 99, the remaining amount of the billing specification data that has been subjected to the division process is the other. It stipulates that the above-mentioned division process and the reconciliation process of both detail data are performed repeatedly when it is larger than the amount of the receipt details data or the total amount of a plurality of receipts,
In such cases,
With respect to the remaining amount, the fifth arithmetic unit repeats the above-described division processing of the amount and the reconciliation processing of both the detail data, and the remaining amount of the billing detail data becomes the remaining amount. When it becomes smaller than the amount of the receipt details data or a plurality of total amounts, the control means temporarily creates the receipt details data of the discount amount corresponding to the remaining amount of the claim details data, and makes a Account is attached and forced reconciliation is performed
It is characterized by:
[0140]
The configurations of claims 101 to 118 specify programs that can be executed by the computer in order to cause the computer to execute the methods defined in claims 65 to 82. That is, as a configuration for solving the above-described problem, a computer that can execute each of the processes defined in claims 65 to 82 using a configuration of the computer and that can be read and executed by the computer. Disclose about the program. When such a program for causing a computer to execute each of the above-described processes is read out by the computer, a process similar to any one of the processes defined in claims 65 to 82 is executed.
[0141]
Among them, the configuration of claim 101 is a configuration corresponding to the configuration of claim 65, and the specific configuration is
When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, If there is a difference in the amount and it is determined that the difference is out of the preset error range, and there are payment statement data and billing statement data that have been excluded from the reconciliation process, the larger amount The calculation means divides the amount of one detailed data into an amount equivalent to (an amount of one of the other detailed data or a plurality thereof) and a remaining amount. Per the same amount worth of over data, with processing scrub both detailed data is performed,
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or a process excluded from the object of the erasing process is executed in the data storage means.
A computer program characterized by the following.
[0142]
The structure of Claim 102 corresponds to the structure of Claim 66. As a more specific structure of Claim 101,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
Further, an account of the advance payment is added to the remaining money amount by the calculating means, and the remaining money amount is left in the data storage means as a processing target of the payment detail data.
A computer program characterized by the following.
[0143]
The configuration of Claim 103 corresponds to the configuration of Claim 67. As a more specific configuration of Claim 101,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
Further, for the remaining amount, the calculation means assigns an account of the provisional deposit and performs a forcible clearing process.
A computer program characterized by the following.
[0144]
The structure of Claim 104 corresponds to the structure of Claim 68. As a more specific structure of Claim 101,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
Further, for the remaining amount, an account item other than the accounts receivable is given by the calculating means, and is excluded from the reconciliation processing object in the data storage means.
A computer program characterized by the following.
[0145]
The structure of claim 105 corresponds to the structure of claim 69, and as a more specific structure of claim 101,
When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
Further, for the remaining amount, the calculation means adds an account item corresponding to the remaining amount of the bill, and the account is left in the data storage means as an object of the reconciliation processing of the billing statement data.
A computer program characterized by the following.
[0146]
The configuration of claim 106 corresponds to the configuration of claim 70, and as a more specific configuration of claim 101,
When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
Further, for the remaining amount, the account means of the accounts receivable is attached by the calculating means, and the forcible clearing process is performed.
It is characterized by:
[0147]
The structure of Claim 107 corresponds to the structure of Claim 71. In the structure of Claims 101 to 106, the remaining amount of the detailed data that has been subjected to the division processing is the other amount. When the amount is larger than the amount of the remaining detailed data or the total amount of the plurality, the above-mentioned division processing and the reconciliation processing of both the detailed data are performed repeatedly,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the reconciliation processing of the two detailed data, and the remaining amount is changed to the amount of the other remaining detailed data or a plurality of the remaining amount data. When the amount becomes smaller than the total amount, a specific account item is added to the remaining amount by the arithmetic means, and is left in the data storage means as a processing target of the payment statement data or the billing statement data. Forced erase processing is performed, or excluded from the erase processing target in the data storage means
It is characterized by:
[0148]
The configuration of claim 108 corresponds to the configuration of claim 72, and as a more specific configuration,
When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, If there is a difference in the amount and it is determined that the difference is outside the preset error range, there are payment statement data and billing statement data that are excluded from the reconciliation processing, and the reconciliation processing is not performed. In the case where the billing amount of the billing detail data 1 becomes larger than the deposit amount or the total amount of the payment detail data also excluded from the reconciliation processing, the calculating means The billing amount of the billing statement data is divided into an amount corresponding to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and for the same amount of both statement data, As the reconciliation process is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process.
A computer program characterized by the following.
[0149]
The structure of claim 109 corresponds to the structure of claim 73. In the structure of claim 108, the remaining amount of the billing specification data that has been subjected to the splitting process is the other. It stipulates that the above-mentioned division process and the reconciliation process of both detail data are performed repeatedly when it is larger than the amount of the receipt details data or the total amount of a plurality of receipts,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the erasing process of both the detail data, and the remaining amount of the billing detail data is converted to the other remaining payment detail data. When the amount becomes smaller than the total amount or a plurality of total amounts, the above-mentioned calculating means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, and sets Is attached and forced reconciliation is performed
It is a computer program characterized by the following.
[0150]
The structure of claim 110 corresponds to the structure of claim 74.
When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, It is determined that the amounts match or the difference between the two amounts is within a preset error range, and within that range, the target payment statement data and billing statement data are processed for reconciliation,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. When there is received receipt statement data and billing statement data, the amount of one statement data, which is the larger amount, is calculated by the above-mentioned calculating means into an amount equivalent to (the amount of one statement of the other statement data or a plurality thereof). , And the remaining amount is divided. For the same amount of the two items of data, the reconciliation process of both items of data is performed.
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or a process excluded from the object of the erasing process is executed in the data storage means.
A computer program characterized by the following.
[0151]
The configuration of claim 111 corresponds to the configuration of claim 75, and as a more specific configuration of claim 110,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
Further, an account of the advance payment is added to the remaining money amount by the calculating means, and the remaining money amount is left in the data storage means as a processing target of the payment detail data.
A computer program characterized by the following.
[0152]
The configuration of claim 112 corresponds to the configuration of claim 76, and as a more specific configuration of claim 110,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
Further, for the remaining amount, the calculation means assigns an account of the provisional deposit and performs a forcible clearing process.
A computer program characterized by the following.
[0153]
The structure of Claim 113 corresponds to the structure of Claim 77. As a more specific structure of Claim 110,
In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
Further, for the remaining amount, an account item other than the accounts receivable is given by the calculating means, and is excluded from the reconciliation processing object in the data storage means.
A computer program characterized by the following.
[0154]
The structure of claim 114 corresponds to the structure of claim 78, and as a more specific structure of claim 110,
When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
Further, for the remaining amount, the calculation means adds an account item corresponding to the remaining amount of the bill, and the account is left in the data storage means as an object of the reconciliation processing of the billing statement data.
A computer program characterized by the following.
[0155]
The structure of claim 115 corresponds to the structure of claim 79, and as a more specific structure of claim 110,
When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
Further, for the remaining amount, the account means of the accounts receivable is attached by the calculating means, and the forcible clearing process is performed.
A computer program characterized by the following.
[0156]
The structure of Claim 116 corresponds to the structure of Claim 80. In the structure of Claims 110 to 115, the remaining amount of the detailed data that has been subjected to the division processing is the other amount. When the amount is larger than the amount of the remaining detailed data or the total amount of the plurality, the above-mentioned division processing and the reconciliation processing of both the detailed data are performed repeatedly,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the reconciliation processing of the two detailed data, and the remaining amount is changed to the amount of the other remaining detailed data or a plurality of the remaining amount data. When the amount becomes smaller than the total amount, a specific account item is added to the remaining amount by the arithmetic means, and is left in the data storage means as a processing target of the payment statement data or the billing statement data. Forced erase processing is performed, or excluded from the erase processing target in the data storage means
It is characterized by:
[0157]
The structure of claim 117 corresponds to the structure of claim 81, and as a more specific structure,
When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, It is determined that the amounts match or the difference between the two amounts is within a preset error range, and within that range, the target payment statement data and billing statement data are processed for reconciliation,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. Payment data and billing statement data, and the charge amount of one of the billing statement data that was excluded from the reconciliation processing is equal to the sum or the total amount of the payment statement data that was also excluded from the reconciliation processing. If it is larger, the calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and For each amount, the reconciliation process of both detail data is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process.
A computer program characterized by the following.
[0158]
The structure of claim 118 corresponds to the structure of claim 82. In the structure of claim 117, the remaining amount of the billing statement data that has been subjected to the division process is the other. It stipulates that the above-mentioned division process and the reconciliation process of both detail data are performed repeatedly when it is larger than the amount of the receipt details data or the total amount of a plurality of receipts,
In such cases,
With respect to the remaining amount, the calculation means repeats the above-described division processing of the amount and the erasing process of both the detail data, and the remaining amount of the billing detail data is converted to the other remaining payment detail data. When the amount becomes smaller than the total amount or a plurality of total amounts, the above-mentioned calculating means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, and sets Is attached and forced reconciliation is performed
A computer program characterized by the following.
[0159]
Further, as described above, the configuration of claim 119 defines a computer-readable recording medium storing the computer program according to any one of claims 101 to 118. That is, these computer programs are stored in a recording medium, and can be used as a transaction target or actually executed.
[0160]
The computer that executes the method or the program (or the program read from the recording medium) or the computer that configures the system may have one configuration (such as a stand-alone computer), but is not limited thereto. Instead, the network is composed of a plurality of computers (such as a plurality of servers) constituting a network, and the processing performed in each of the above steps is distributed (if necessary, through an appropriate communication configuration) to these computers. May be set in the program so that the program is executed.
[0161]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is an explanatory diagram showing an outline of an embodiment of the present invention. In this example, the company provided with the server 1 is the headquarters of the group, and the company in the group provided with the terminals 3x to 3z connected to the server 1 sells or sells goods or services to any of the customers A to G. Are provided and these customers are billed. Then, each customer uses one of their own terminals 4a to 4g to make a transfer request to the depositor bank that has a transaction with these customers, and furthermore the host of the bank that has a transaction with the controlling company from the bank. Transfer processing is performed on (2). Thereafter, based on the billing statement data possessed by the group company regarding the billing and the receipt statement data sent from the host 2 side, the server 1 performs the processing of clearing the receivables (such as accounts receivable). This is illustrated by this figure.
[0162]
Here, the fact that the three group companies are enclosed in squares indicates that the group is the headquarters company, and the customers A to D, which are the billing destinations, are also enclosed in squares, which will be described later. As shown in FIG. 9, when the billing destination is any of the customers A to D, a transfer request for the bill is always made by the customer A (accurately, a transfer request is issued from the customer A to the receiving bank). Transfer processing is performed by the receiving bank in accordance with the transfer to the host 2 of the house bank of the controlling company; payment processing with the customer A as the receiving source by grouping). As shown in FIG. 9, when the billing destination is any of the customers E to G, the transfer request may be made by the customer G, and each of E to G is also surrounded by a square. Customers E to G who are billed In some cases, a transfer request may be made by the customer G to the receiving bank in response to a request to each of the customers E to G, or may be issued by the customers E and F themselves. Based on those transfer requests, the transfer source bank performs a transfer process to the host 2 of the bank of the controlling company; a payment process using the customer G or the customer EF itself as a payment source by grouping and special setting. )It is shown that.
[0163]
2 to 6 show the functional block configuration in the server 1 of the supervising company and the flow of processing in these functional blocks in the case of the framework configuration shown in FIG.
[0164]
As shown in these drawings, the server 1 includes an arithmetic control unit 10 composed of a CPU, a billing statement master 11a composed of a hard disk drive, a payment statement master 12a, a customer master 13, an application procedure master 14, A transfer fee master 15, a clearing processing program storage section 16, a RAM 17 for storing the clearing processing program to be read and executed by the arithmetic and control unit 10, and an external communication. And a communication unit 18 for performing the communication.
[0165]
In addition, the temporary billing statement master 11b and the temporary receipt statement master 12b shown in these drawings are configured using the hard disk drive or the RAM 17. By executing the reconciliation processing program in the arithmetic and control unit 10, the billing statement data of a specific group company to be reconciled in the billing statement master 11 a is extracted and stored in the temporary billing statement master 11 b. Temporary storage of billing statement data stored for the clearing process, and payment statement data addressed to a specific group company to be cleared in the payment statement master 12a are extracted and stored in the temporary payment statement master 12b. It functions as a temporary storage unit for the payment details data stored for the application processing.
[0166]
As shown in FIG. 2, in the server 1, the billing statement data sent to the customers A to G from the billing source terminals 3 x, 3 y and 3 z of the group company is arithmetically controlled via the communication unit 18. These are sent to the unit 10 and are further stored in the billing statement master 11a by the arithmetic and control unit 10. Similarly, on the server 1, based on the transfer request made to the request of the group company by the customer A, E to G, the transfer processing is performed from the depositing source bank to the host 2 in the bank of the supervising company. The payment statement data sent from the host 2 and destined for each of the group companies is transferred to the arithmetic and control unit 10 via the communication unit 18, and further received by the arithmetic and control unit 10. It is stored in the master 12a. It should be noted that the host 2 is registered in a customer registration master (not shown) provided in the host 2 with data of the supervising company and its group companies that have a business relationship with the bank and receive the provision of this service. The payment statement data transferred from the host 2 is extracted and sent to the supervising company (in some cases, to each group company).
[0167]
Next, as shown in FIG. 3, a grouping table that defines who makes a transfer as a payment source for a bill to customers A to G, which are grouped as shown in FIGS. 9 and 28 described below, is registered. The customer master 13 (as will be described later, the customer master 13 includes, in addition to this table, setting items such as a clearing pattern, a commission adjustment setting, and a deemed clearing setting by the controlling company or a group company). Then, the calculation control unit 10 narrows down the billing statement data and the payment statement data to be applied, and stores them in the temporary billing statement master 11b and the temporary payment statement master 12b, respectively. With the above processing, the narrowing-down processing for the billing party and the payment source is performed. The process of narrowing down the subject will be described later.
[0168]
Further, in FIG. 4, as shown in FIG. 28 described later, together with the grouping table, of the 17 clearing patterns described later, clearing patterns selected and set by the supervising company or its group company, commission adjustment settings, and deemed clearing With reference to the customer master 13 in which transfer settings and the like are registered, the calculation control unit 10 refers to a clearing procedure master 14 storing 17 clearing patterns themselves and a transfer fee master 15 storing transfer fees. Then, based on the billing statement data and the payment statement data stored in the temporary billing statement master 11b and the temporary receipt statement master 12b, both data to be applied for further refining are narrowed down. In other words, a narrowing-down process is performed on the corresponding data that further narrows which data is in a corresponding relationship from both the billing detail data and the payment detail data extracted by the narrowing-down process on the subject. The process of narrowing down the correspondence data will also be described later.
[0169]
FIG. 5 shows that the calculation control unit 10 performs the matching and clearing processing of the billing statement data and the payment statement data which are in correspondence with each other in the above-described narrowing down processing, and the processing results are stored in the temporary billing statement master 11b and the temporary billing statement master 11b. The state stored in the receipt details master 12b is shown.
[0170]
FIG. 6 shows that the arithmetic and control unit 10 updates the billing statement data and the deposit statement data accumulated in the billing statement master 11a and the receipt statement master 12a by the reconciliation and reconciliation processing. This shows a state in which the processing has been executed.
[0171]
FIG. 7 is a flowchart showing a procedure for registering a setting item for reconciliation / application in the customer master 13 of the server 1 by the supervising company or the group company.
[0172]
First, for the purpose of narrowing down the billing party and the entity of the payment source, setting and registration (grouping and special setting) of customers A to G of the group company as to where payment is made for billing to those persons are performed. (Step S101).
[0173]
Subsequent processes are settings for narrowing down the corresponding data.
[0174]
First, an operator of the supervising company or a group company selects an arbitrary clearing pattern from among 17 patterns described later (the 17 patterns are stored in the clearing procedure master 14), and registers the clearing pattern to the customer master 13. Is performed (step S102).
[0175]
Then, the operator of the supervising company or the group company selects whether or not to adjust the bank transfer fee at the time of the reconciliation / clearing process, and if the fee is adjusted, also inputs the amount. In response, the server 1 checks whether fee adjustment is performed (step S103).
[0176]
If the commission adjustment is not performed (step S103; N), the process jumps to step S105.
[0177]
Conversely, when the fee adjustment is performed (step S103; Y), the setting of performing the fee adjustment in the customer master 13 and the amount of the fee for the adjustment are set (step S104).
[0178]
Next, the operator of the controlling company or group company, even if there is a discrepancy in the amount during the reconciliation / applying process, executes the reconciliation assuming that the reconciliation was successful. When performing deemed clearing, also enter the amount range. In response, the server 1 checks whether or not to perform the deemed clearing (step S105).
[0179]
Here, if the deemed clearing is not performed (step S105; N), the process ends.
[0180]
Conversely, when the deemed clearing is performed (Step S105; Y), the setting of performing the deemed clearing on the customer master 13 and the range of the difference amount (the deemed difference amount) to which the deemed clearing is performed are set ( Step S106).
[0181]
On the other hand, FIG. 8 is a flowchart showing the processing procedure of the loan clearing process by the narrowing down process of the billing party and the payment source from FIG. 3 to FIG. 6 and the narrowing down process of the corresponding data.
[0182]
Usually, the customer side determines the closing date and pays the payment on the 20th, 25th, 30th, etc. of the month, the next month, or the month after the month. Therefore, in the application processing program on the server 1 side, the end of the month is set as the receivable application processing date, and the arithmetic control unit 10 checks whether or not the processing due date has arrived (step S201). However, the processing date can be set arbitrarily, for example, every day or every few days.
[0183]
Here, when the due date has not arrived (step S201; N), the processing by the clearing processing program ends. On the other hand, when the due date has arrived (step S201; Y), whether the billing statement data and the receipt statement data that have not been processed yet to be compared and applied as shown in FIG. It is checked whether it is (Step S202).
[0184]
If both data are not present in each of the masters 11a and 12a (step S202; N), the processing by the clearing processing program ends. However, since this program is started at least every day (may be every several hours), the process starts again from the step S201.
[0185]
Conversely, when both data are present in the respective masters 11a and 12a (step S202; Y), the arithmetic control unit 10 refers to the customer master 13 (step S203), and narrows down the billing party and the payment source. [Drawing destination = the process of extracting both data of the payment source (to be applied to the drawing)] is performed. (Step S204).
[0186]
After that, in step S205, it is checked whether or not the subsequent processing from step S206 to step S215 (the narrowing down processing for the corresponding data) has been performed on all the data extracted by the narrowing down processing (step S205). ). When all of these processes have been completed (step S205; Y), the process by the reconciliation processing program ends.
[0187]
On the other hand, if the above processing has not been completed (step S205; N), one or a plurality of payment statement data of an arbitrary group company and these data (billee = payment source) or (billee = Based on all the clearing patterns selected and registered in the customer master 13 among the 17 patterns, the processing from step S207 to step S214 is performed based on the billing statement data that is related to the (grouped specific customers). It is checked whether or not the operation has been performed (step S206). As will be described later, if the corresponding billing statement data and payment statement data cannot be cleared by the processing from step S207 to step S213 (step S214; N), the process returns to step S206 and returns to the customer master 13 The processing from step S207 to step S213 is newly performed according to the reconciliation pattern registered next.
[0188]
However, even if all the clearing patterns selected and registered in the customer master 13 cannot clear the corresponding billing statement data and payment statement data (N in step S214 and Y in step S206). Case), the inability to process is displayed on any of the screens of the server 1 or the screens of the billing source terminals 3x to 3z (step S216), and the process returns to the step S205, where the corresponding new billing statement data and payment are received. The narrowing-down process for the corresponding data from step S206 to step S215 is performed on the detailed data.
[0189]
In addition, in the above-mentioned step S206, when the application processing using the application pattern registered next in the customer master 13 is not completed (step S206; N), in the order of the application patterns registered in the master 13, The processing from step S207 to step S214 is performed.
[0190]
In that case, first, it is checked whether the commission adjustment is set in the customer master 13 (step S207).
[0191]
When the commission adjustment is not set in the customer master 13 (step S207; N), it is further checked whether or not the deemed application is set in the customer master 13 (step S208).
[0192]
When the deemed clearing is not set in the customer master 13 (step S208; N), the clearing pattern registered in the customer master 13 is read from the clearing procedure master 14 by the arithmetic control unit 10 and read. Then, the corresponding billing statement data and payment statement data are cleared (step S209). In this case, in the subsequent process of determining whether or not to apply in step S214, the sum of the deposit amounts described in the optional receipt details data and the amount of the invoices described in the claim detail data in a predetermined range based on the application pattern are determined. Whether or not to apply is determined by whether or not the sum matches.
[0193]
In the step S208, when the deemed application is set in the customer master 13 (step S208; Y), the application pattern and the deemed difference registered in the customer master 13 are referred to, and Based on the read-out application pattern, the application processing of the corresponding billing statement data and payment statement data is performed (step S210). Even if there is a difference between the sums of the amounts described in both data, if the difference is within the range of the above-mentioned deemed difference, it is treated as rejectable in the rejection determination process of step S214.
[0194]
In step S207, when the fee adjustment is set in the customer master 13 (step S207; Y), it is further checked whether or not the deemed clearing is set in the customer master 13 (step S211).
[0195]
When the deemed application is not set in the customer master 13 (step S211; N), the application pattern registered in the customer master 13 and the item of the priority transfer fee are referred to, and Based on the read-out payment pattern and the transfer fee amount read from the transfer fee master 15, the corresponding billing detail data and payment detail data are cleared (step S212). Even when there is a difference in the sum of the amounts of money described in both data, if the difference is the amount of money corresponding to the transfer fee, it is treated as clearable in the clearing / non-clearability determination process in step S214.
[0196]
In the above step S211, if the deemed application is set in the customer master 13 (step S211; Y), the items of the application pattern, the assumed difference and the priority transfer fee registered in the customer master 13 are referred to. Based on the clearing pattern read from the clearing procedure master 14 and the transfer fee amount read from the transfer fee master 15, the clearing process of the corresponding billing detail data and payment detail data is performed (step). S213). Even if there is a difference in the sum of the amounts of money described in both data, if the difference is a difference between the range of the deemed difference and the amount corresponding to the transfer fee, it is determined whether or not the application in step S214 is applicable. It is treated as clearable in the judgment process.
[0197]
As a result of performing the clearing process in steps S209, S210, S212 and S213, it is checked whether clearing is possible in the process (step S214), and clearing of both data is impossible. If there is (Step S214; N), the process returns to Step S206, and the clearing process from Step S207 to Step S213 is repeated based on the next clearing pattern registered in the customer master 13. .
[0198]
If both data can be cleared (step S214; Y), the results of the clearing process are stored in the temporary billing statement master 11b and the temporary receipt statement master 12b as shown in FIG. 5 (step S215). ). Thereafter, the process returns to the step S205, and it is checked whether or not a narrowing-down process for the corresponding data from the step S206 to the step S215 has been performed on the extracted all billing detail data and all the payment detail data (step S205). .
[0199]
If the processing from step S206 to step S215 has not been performed on the extracted all billing statement data and all payment statement data (step S205; N), the processing from step S206 to step S215 is repeated. Conversely, if the processing from step S206 to step S215 has been performed on all the billing statement data and all the payment statement data (step S205; Y), the clearing processing by the clearing processing program ends there.
[0200]
Finally, although not shown in this figure, when the reconciliation processing by the reconciliation processing program is completed, the billing statements stored in the temporary billing statement master 11b and the temporary receipt statement master 12b as shown in FIG. Based on the data and payment detail data clearing processing, the billing detail data and payment detail data stored in the billing detail master 11a and the payment detail master 12a are updated as if the receivable clearing process has been completed.
[0201]
FIG. 9 shows an example of a state of setting and registering a grouping table in the customer master 13 which defines who will make a payment as a payment source for the grouped customers A to G (see FIG. 28, the treatment of the customers B to D is different).
[0202]
As shown in the figure, when billing is made to customers A to D as billing destinations, payment for the billing (payment source) is always made on behalf of customer A (the billing party is a customer). A is not a substitute payment).
[0203]
If billing is made to customers E to G as billing destinations, payment for the billing (payment source) is usually made on behalf of customer G, but this grouping table contains an application range flag. If it is set, the customer who is the billing destination (customers E and F in the drawing) can pay as a special case (it will be recognized as a payment source).
[0204]
Further, FIG. 10 shows an example of the payment statement data and the billing statement data extracted by performing the narrowing-down process on the billing party and the payment source entity based on FIG. Here, the billing destination of the billing statement data is the customers A to D. By referring to the grouping table of the customer master 13, all the payments of the customers A to D are performed by the customer A (that is, the customers A to D). The payment source corresponding to D is all customers A). The payment sources actually entered into the server 1 as the payment details data are all customer A data as far as the billing destinations A to D in the examples of FIGS. 9 and 10 are concerned.
[0205]
Next, 17 examples of the clearing patterns stored in the clearing procedure master 14 will be described with reference to FIGS. The examples of the application patterns in FIGS. 11 to 27 have no relation to the example of the payment details data and the billing details data in FIG. 10 for convenience of explanation.
[0206]
In this example, the payment amount and the billing amount are checked with respect to the payment detail data and the billing detail data to be cleared according to the following rules while extracting and rearranging the data.
[0207]
Pattern 1 (see FIG. 11)
For the payment details data and billing details data to be applied, the total amount of N pieces of payment details data (four in the figure) based on the target billing destination (code) or payment source (code) calculate. At this time, based on the date (2002/08/25) with the latest payment date among the N pieces of payment detail data, the billing date of the target billing detail data is changed to the payment date (2002) acquired above. / 08/10) Calculate the total amount of the data to be applied for the previous data. This is the first pattern rule for checking the amount of money based on the calculated total amount of deposit and the total amount of invoices to be applied. In the example of FIG. 11, the data of the black shaded line is erased.
[0208]
Pattern 2 (see FIG. 12)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. Based on the processing date (date of the server 1) in the target billing detail data, the total amount of the billing target billing amount up to the last day of the previous month is calculated. This is a rule to check the amount based on the calculated total amount of the deposit and the total amount of the invoice to be applied. In the example of FIG. 12, when the application processing is performed on 2008/08/31, the data of the black shaded line is applied.
[0209]
Pattern 3 (see FIG. 13)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. Based on the processing date (date of the server 1) of the target billing detail data, the total amount of the billing target billing date up to the last day of the month before the billing date is calculated. This is a rule to check the amount based on the calculated total amount of the deposit and the total amount of the invoice to be applied. In the example of FIG. 13, when the reconciliation processing is performed on 2002/08/31, the data of the black shaded line is reconciled.
[0210]
Pattern 4 (see FIG. 14)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. Based on the processing date (date of the server 1) in the target billing detail data, the total amount of the billing target billing amount for the previous month is calculated. This is a rule to check the amount based on the calculated total amount of the deposit and the total amount of the invoice to be applied. In the example of FIG. 14, when the reconciliation processing is performed on 2002/08/31, the data of the black shaded line is reconciled.
[0211]
Pattern 5 (see FIG. 15)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. Based on the processing date (date of the server 1) in the target billing statement data, the total amount of the billing target billing amount for the date two months before the billing date is calculated. This is a rule to check the amount based on the calculated total amount of the deposit and the total amount of the invoice to be applied. In the example of FIG. 15, when the application process is performed on 2008/08/31, the data of the black shaded line is applied.
[0212]
Pattern 6 (see FIG. 16)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. At this time, based on the latest payment date among the N pieces of payment detail data, the billing date of the target billing detail data is set to a date before the payment date acquired above, and Is a rule to check the amount while adding the invoice amount to be applied in order from the oldest data. (If there are multiple data with the same invoice date, the invoice amount to be applied is added from the smaller amount) . An amount check is performed based on the calculated total amount of the deposit and the total amount of the invoice to be applied. The check of the money amount is performed until the matching is performed or until the money amount exceeds the error range (the deemed difference amount and / or the addition amount of the transfer amount) that allows the application. In the example of FIG. 16, when the application processing is performed on 2008/08/31, the data of the black shaded line is applied.
[0213]
Pattern 7 (see FIG. 17)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. At this time, based on the latest payment date among the N pieces of payment detail data, the billing date is set to the data before the payment date obtained above, and the billing number is set. This is a rule for checking the amount while adding the billing amount to be applied in ascending order. An amount check is performed based on the calculated total amount of the deposit and the total amount of the invoice to be applied. The check of the amount is performed until the matching is completed or the error exceeds the error range allowing the application as described above. In the example of FIG. 17, when the application processing is performed on 2008/08/31, the data of the black shaded line is applied.
[0214]
Pattern 8 (see FIG. 18)
The total amount of the N pieces of payment detail data is calculated based on the billing destination (code) or the payment source (code) to be applied to the payment detail data and the billing detail data to be applied. At this time, out of the N payment details data, based on the date of the latest payment, the scheduled collection date of the target billing details data is a data before the payment date acquired as described above. Calculate the sum of the amounts. This is a rule to check the amount based on the calculated total amount of the deposit and the total amount of the invoice to be applied. In the example of FIG. 18, the data of the black shaded line is erased.
[0215]
Pattern 9 (see FIG. 19)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). At this time, the billing detail data is the total amount of the billing amount to be applied for all data whose billing date is before the payment date. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 19, the data of the black shaded line is erased.
[0216]
Pattern 10 (see FIG. 20)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). Based on the processing date (date of the server 1) in the target billing detail data, the total amount of the billing target billing amount up to the last day of the previous month is calculated. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 20, when the reconciliation processing is performed on 2002/08/31, the data of the black shaded line is reconciled.
[0219]
Pattern 11 (see FIG. 21)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). Based on the processing date (date of the server 1) of the target billing detail data, the total amount of the billing target billing date up to the last day of the month before the billing date is calculated. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 21, when the application processing is performed on 2008/08/31, the data of the black shaded line is applied.
[0218]
Pattern 12 (see FIG. 22)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). Based on the processing date (date of the server 1) in the target billing detail data, the total amount of the billing target billing amount for the previous month is calculated. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 22, when the application processing is performed on 2002/08/31, the data of the black shaded line is applied.
[0219]
Pattern 13 (see FIG. 23)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). Based on the processing date (date of the server 1) in the target billing statement data, the total amount of the billing target billing amount for the date two months before the billing date is calculated. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 23, when the reconciliation processing is performed on 2002/08/31, the data of the black shaded line is reconciled.
[0220]
Pattern 14 (see FIG. 24)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). This is a rule for checking the amount of data to be applied, in order from the data with the oldest billing date, to the data with the billing date before the payment date in the target billing detail data. (If there are a plurality of data with the same billing date, the data to be applied for is charged from the data with the smaller amount). The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 24, when the reconciliation process is performed on 2008/08/31, the data of the black shaded line is reconciled. Here, the payment details data (payment amount 50,000 yen) on the payment date 2002/07/05 is applied together with the payment details data on the billing dates 2002/06/10 and 2002/06/20, and the payment date The payment details data (payment amount of 30,000 yen) on 2002/08/25 is erased together with the payment details data on 2002/07/20 of the billing date.
[0221]
Pattern 15 (see FIG. 25)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). This is a rule that checks the amount of data to be applied while increasing the invoice amount to be applied to data in which the invoice date is before the payment date in the order from the lowest invoice number in the invoice details data to be processed. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 25, when the reconciliation processing is performed on 2002/08/31, the data of the black shaded line is reconciled.
[0222]
Pattern 16 (see FIG. 26)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). At this time, the billing detail data is the total amount of the billing target for application for all data whose scheduled collection date is before the payment date. The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 26, the data of the black shaded line is erased.
[0223]
Pattern 17 (see FIG. 27)
For the payment details data and billing details data to be applied, based on the target billing destination (code) or payment source (code), the data of one payment details data is arranged in order from the oldest payment date. (If there are a plurality of data with the same payment date, start with the data with the lowest item number). Among the billing details data to be processed, the billing date is a rule that checks the data to be cleared for one billing detail data in order from the data with the oldest billing date to the data before the payment date (billing) If there are multiple data with the same date, check from the data with the smaller billing amount for clearing). The check of the amount is performed until the target billing statement data matches or the check of all the payment statement data is completed. In the example of FIG. 27, when the reconciliation processing is performed on 2002/08/31, the data of the black shaded line is reconciled. Here, the payment details data (payment amount of 50,000 yen) on the payment date 2002/07/05 is erased together with the payment details data on the payment date 2002/06/15, and the payment details data on the payment date 2002/08/25 is used. The payment specification data (payment amount of 30,000 yen) has been erased together with the payment specification data for the billing date of 2002/07/20.
[0224]
The above-mentioned clearing pattern is stored as data in the clearing procedure master 14 as described above. Then, in the customer master 13, it is possible to assign priorities to up to five patterns (of course, it is possible to increase the number of patterns or to reduce the number of patterns less than 5). ing. The data is read out by the arithmetic and control unit 10 in accordance with the above order registered in the customer master 13. At the time of the clearing process, the data is read out in steps S209, S210, S212, and S213 in FIG. This is done using patterns.
[0225]
(Example)
Next, an embodiment of the present invention will be described with reference to FIGS.
[0226]
FIG. 28 shows a setting example of each item in the customer master 13 in this embodiment. In this example, the customers B, C, and D are set to group the customer A in the customer master 13. The clearing flags set in the clearing range are set for the customers B to D (different from FIG. 9). They may be paid (deposited) to the billing source or they may be paid (deposited) by themselves.
[0227]
When the billing destination is the customer A, the pattern 17 is used with the highest priority as the application pattern, the pattern 12 is used next, and three more priority patterns are registered in order. Similarly, as the clearing pattern for the customer B, the pattern 14 is used with the highest priority, the pattern 17 is used next, and three more priority patterns are registered in order. As the application pattern for the customer C, the pattern 2 is used with the highest priority, the pattern 17 is used next, and three more priority patterns are registered in order. As for the consumption pattern relating to the customer D, the pattern 1 is used with the highest priority, the pattern 10 is used next, and three more priority patterns are registered in order.
[0228]
On the other hand, in each case, the commission adjustment is set to “use”, and the prioritized commission amounts are “high amount” for customers A to C and “low amount” for customer D. FIG. 29 shows the contents of the transfer fee data stored in the transfer fee master 15, according to which the "high amount" starts from 420 yen, and if the calculation does not fit, 315 yen , 210 yen and 105 yen (customer D will be referred to in reverse).
[0229]
In addition, the deemed application is set to “use”, and the deemed difference is in the range of “−10 to 10 yen”.
[0230]
As described above, when the contents of the customer master 13, the clearing procedure master 14, and the transfer fee master 15 are set, as shown in FIG. FIG. 5 shows an example of corresponding billing statement data and payment statement data when payment is made (that is, customers A to D become billing destinations), and thereafter, payment is made with the customer A as the payment source.
[0231]
Here, since the narrowing-down process for the subject has already been completed, the narrowing-down process for the corresponding data for narrowing down which data has a corresponding relationship is performed. The date when this process was performed is August 4, 2002.
[0232]
First, in the receivable clearing process by the arithmetic and control unit 10, the process is performed in order from the first of the above-mentioned payment detail data.
[0233]
1. The setting of the customer master 13 is referred to from the payment source (code) of the payment details data to be processed. In the example of FIG. 30, since the payment source is customer A, the customer master 13 refers to the setting of customer A.
[0234]
1- (1) By setting the clearing range of the customer master 13 shown in FIG. 28, the billing statement data to be cleared is extracted. In the example of FIG. 30, the clearing range flag (*) is not set in the clearing range of the billing destination A in the customer master 13 (FIG. 28). This indicates that the billing statement data in which A is set in the payment source (code) is the data to be cleared. In the example shown in the figure, all the billing detail data of six cases are to be processed.
[0235]
Supplement: If the clearing range flag (*) is set in the clearing range of the billing destination A in the customer master 13, billing detail data in which A is set in the billing destination (code), that is, from the top Only three billing statement data are targeted.
[0236]
By setting the application pattern, the corresponding billing statement data is further narrowed down. In the example of the above figure, the first clearing pattern of the billing destination A in the customer master 13 is set to 17 (FIG. 28). The clearing pattern 17 narrows the clearing target billing detail data to the first billing detail data with the oldest billing date as shown in the example of FIG. 27 described above. Here, the data to be collated is determined.
[0237]
Next, a flow of checking each amount will be described.
[0238]
2. Check the deposit amount and billed amount. In the processing described above, the data is narrowed down to the data shown in FIG.
[0239]
2- (1) Check whether the total amount of money to be processed is the total amount of money to be processed.
In the example of FIG. 31, the total deposit amount of 14,680 yen and the total charge amount of 20,000 yen are not equal.
[0240]
2- (2) Next, a judgment is made in the transfer fee adjustment (confirm the setting of the transfer fee adjustment in the customer master 13).
In the billing destination A of the customer master 13, the transfer fee adjustment is used (FIG. 28). Therefore, it is checked whether the difference between the billing amount meter and the deposit amount meter is the amount registered in the transfer fee master 15. In the above example, the transfer fee is not adjusted because the difference is 5,320 yen.
[0241]
2- (3) Next, a decision is made in the deemed clearing (confirmation of the clearing setting only in the customer master 13).
In the billing destination A of the customer master 13, the deemed clearing is used. Accordingly, the difference is calculated in order from the highest amount registered in the transfer fee master 15 by applying to the formula of the total amount of the invoice- (the total amount of the deposit + the transfer fee), and the difference is determined as the adjustment range of the deemed application. Check inside. In the above example, no matter how much the transfer fee amount registered in the transfer fee master 15 is adjusted, it does not fall within the deemed clearing adjustment range (between -10 and 10 yen).
Invoice amount total-(deposit amount total + transfer fee) = difference calculated by
2,0000 yen-(14,680 yen + 420 yen) = Difference 4,900 yen
[0242]
Next, the transfer fee adjustment is not performed, and only the deemed application adjustment is confirmed. In the above example, of course, this does not fall within the adjustment range of the deemed clearing.
Invoice amount total-(deposit amount total amount) = Difference calculated by
2,0000 yen-(14,680 yen) = balance 5,320 yen
[0243]
Supplement: If both the transfer fee adjustment and the deemed clearing are not used, the checks in 2- (2) and (3) above are not performed. Therefore, unless the total amount of deposit is equal to the total amount of billing, no application matching is performed.
[0244]
By checking up to this point, data that cannot be cleared is determined to be a clearing unmatch.
[0245]
However, in the clearing pattern 17, if the clearing cannot be matched with the first billing detail data with the oldest billing date, the rule is to check the amount with the next oldest billing detail data. Therefore, the next check is made with the data shown in FIG.
[0246]
That is, based on the data shown in FIG. 32, by sequentially checking from the above 2- (1), it is possible to confirm that it is within the adjustment range by confirming 2- (3).
Invoice amount total-(deposit amount total + transfer fee) = difference calculated by
15,000 yen-(14,680 yen + 315 yen) = Difference 5 yen
[0247]
The adjustment range of the deemed clearing is between -10 and 10 yen, so it is within the range. Therefore, it is determined that the matching is clear. In the application pattern 17, thereafter, the next payment specification data is checked sequentially with the payment specification data with the oldest billing date in the same manner as described above, but all the application unmatches are determined.
[0248]
3. Change the application pattern and check.
In the example of “checking the amount of money to be paid and the amount of money to be charged”, the pattern 12 is set after the application pattern 17 (FIG. 28). Therefore, the clearing pattern 12 will be performed.
[0249]
In the confirmation processing up to the “check of the deposit amount and the bill amount”, the data shown in FIG. 33 has not been applied.
[0250]
Therefore, when the billing statement data corresponding to the clearing pattern 12 is narrowed down, the result is further as shown in FIG.
[0251]
The clearing pattern 12 is a rule for confirming the total amount obtained by adding the billing detail data of the previous month on the basis of the processing date. Therefore, the above-mentioned “2. Check of the amount of money paid and the amount of money charged” is performed with a total amount of money 79,580 yen and a total amount of money 80,000 yen.
[0252]
If the data of FIG. 34 is checked in order from 2- (1), it is determined that the matching is clear by confirming 2- (2).
Invoice amount total = (deposit amount total + transfer fee)
80,000 yen = (79,580 yen + 420 yen)
[0253]
As described above, the application is automatically performed based on various conditions set in the customer master 13.
[0254]
In this embodiment described above, the processing result as shown in FIG. 35 is finally automatically processed.
[0255]
Next, the drawings in FIG. 36 and subsequent figures show how to split the amount of money when there is a so-called overpayment or underpayment that makes it impossible to apply for receivables according to the procedure of the matching process pattern performed in the above embodiment. This shows an example of a configuration in which a specific account is set, and further a part of the specific account is automatically processed by a computer.
[0256]
When the reconciliation processing of the payment statement data and the billing statement data is completed in the above-described pattern, as shown in FIG. Even if the clearing process has not been completed and the clearing process is not performed by the pattern (a flag indicating that the clearing process is not performed) is set by the arithmetic control unit 10 to the temporary billing statement master. 11b and the temporary receipt details master 12b, respectively, are returned to the billing details master 11a and the receipt details master 12a, respectively, and update processing is performed only on the one for which the reconciliation processing has been completed (a flag indicating that the reconciliation processing has been completed). , And a number indicating the other party detailed data to be applied is attached).
[0257]
The reconciliation procedure master 14 further registers reconciliation procedures involving the division of the amount of money and the setting of a specific account shown in FIGS. In the non-pattern application processing registration menu shown in FIG. 40 described later, the group management company or an operator of the group company uses the above-mentioned application data to further apply the above-described detailed data to the application data. When the processing is set and registered in the customer master 13 of the controlling company server 1, the processing is performed by the server 1 in the following procedure.
[0258]
First, as shown in FIG. 36, in addition to the items shown in FIG. 28, the customer master 13 (as will be described later) includes, as shown in FIG. (There is a setting item by the controlling company or the group company for the processing, etc.), and the arithmetic and control unit 10 once again sets the payment statement data and the billing statement data which have been excluded from the reconciliation processing by the pattern as reconciliation targets. It is narrowed down and stored in the temporary receipt details master 12b and the temporary claim details master 11b, respectively. In the above processing, the payment detail data and the billing detail data (once the pattern is applied once) are narrowed down with respect to the entity of the payment source and the billing party, and are subjected to the clearing process by the clearing procedure involving the division of the amount and the setting of the specific account. The narrowing-down process is performed on the payment statement data and the billing statement data which have become out of the scope of the processing.
[0259]
Further, as shown in FIG. 37, the customer shown in FIG. 41 to be described later in which item data for the automatic payment division processing and the automatic payment division processing selected and set by the operator of the supervising company or its group company is registered. Twelve ({(Claims 66 to 70) × 2 (Repeated pattern claim 71)) + (Claim 72) × 2 (Repeated pattern claim 73)} of the above-described clearing procedure centered on the master 13. The stored application procedure master 14 is referred to by the arithmetic and control unit 10. As a result, the payment statement data and the billing statement data which are stored in the temporary receipt statement master 12b and the temporary claim statement master 11b and which are once excluded from the reconciliation processing by the pattern by applying the above 17 patterns are larger than the larger ones. The amount of one detailed data is divided by the arithmetic and control unit 10 into an amount equivalent to (one amount of the other detailed data or a plurality of total amounts thereof) and a remaining amount. For the same amount, the reconciliation processing of both detail data is performed.
[0260]
Further, a specific account item to be described later is given by the arithmetic control unit 10 to the remaining money amount, and the payment detail data or the billing detail data is applied to the temporary receipt detail master 12b or the temporary billing detail master 11b. Or a forced reconciliation process is performed, or is excluded from the reconciliation process target (the data is transferred to another system) in the temporary payment details master 12b or the temporary billing details master 11b. Is performed.
[0261]
FIG. 38 shows that the above-described processing is performed by the arithmetic and control unit 10 to perform the above-described process of clearing the receipt detail data and the claim detail data and the process of the remaining balance. The results of these processes are stored in the temporary receipt detail master 12b and the temporary claim. The state stored in the statement master 11b is shown.
[0262]
FIG. 39 shows that the arithmetic control unit 10 updates the billing statement data and the billing statement data stored in the billing statement master 12a and the billing statement master 11a by the reconciliation processing to update both data. This shows the executed state.
[0263]
FIG. 40 shows a non-pattern clearing process registration menu registered for each billing party in the customer master 13 of the supervising company server 1 by the group supervising company or an operator of the group company as described above. In the menu, the setting button of the automatic payment division processing and the setting button of the automatic payment division processing are selected by default.
[0264]
Of these, the payment statement automatic division processing is performed when the payment amount of the payment detail data is larger than each of the billing details data (or the sum of each billing amount) due to excessive payment or the like, as shown in FIG. In addition, the control operation unit 10 automatically divides the received amount into a portion corresponding to (one charged amount or a total of a plurality of charged amounts) and the remaining amount. As shown in FIG. 58 to be described later, the billing statement automatic division processing is automatically performed by the control calculation unit 10 when the deposit amount of the deposit statement data is smaller than the billing amount of the billing statement data due to underpayment or the like. This is a process of dividing the amount into a portion corresponding to (one deposit amount or a total amount of a plurality of deposit amounts) and the remaining amount. Of course, these items may not be set by the operator.
[0265]
The setting button for automatic execution of advance payment processing is used to treat the remaining amount of money when the automatic payment division automatic splitting process is set, and the control operation unit 10 causes the account of the remaining amount to be processed by advance payment. Is a button for selecting whether or not to be automatically set as. When the remaining amount is automatically set as advance payment, the remaining amount is flagged with respect to the receipt details data (unapplied data) for which no application processing has been performed. The data is carried over to the next time, but the period during which the data is stored as unapplied data can be set using the items provided below the setting button.
[0266]
The button for setting the final application processing method is used to set the temporary receipt as the account item of the data when the automatic payment processing is not automatically executed or when the unapplied payment details data has passed its storage period. This button is used to select whether or not to perform the receivable.
[0267]
The setting button for the automatic execution of the discount processing is treated as the amount of the remaining amount, and the control calculation unit 10 temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data. This button is used to select whether to automatically set the discount account. In addition, it is possible to set in a column provided below the setting button whether the remaining amount is up to what percentage of the invoiced amount to automatically perform the discount processing. When the remaining amount exceeds the range or when the automatic execution of the discount processing is not set, whether the processing of the remaining amount as the account item is automatically processed by the arithmetic control unit 10 as the remaining amount of the bill is determined. Whether or not to do so can be further selected with a setting button below. However, in the case where the remaining amount is the billing amount, a flag is set as billing detail data (unapplied data) that has not been subjected to the applying process, and the data is carried forward until the next time. The period during which the data is stored as unfinished data can be set using the items provided below the setting button. In the case where the automatic processing is not performed for the remaining amount of the bill, the accounts receivable is set as the account for the remaining amount.
[0268]
FIG. 41 shows a case where the group clearing company or the operator of the group company sets the clearing procedure using the non-pattern clearing process registration menu shown in FIG. The registration status of the reconciliation procedure is shown.
[0269]
In the case where the billing destination is the customer D, the default settings are changed for both the payment statement automatic splitting process and the billing statement automatic splitting process, and neither is performed. The calculation control unit 10 refers to the customer master 13 and the clearing procedure master 14 to perform the automatic splitting / clearing process and the remaining amount. Is set for the specific account specified therein, and the processing shown in FIG. 46 and subsequent figures is performed.
[0270]
FIG. 42 is a flowchart showing a procedure of setting items for executing the clearing procedure in the customer master 13 of the server 1 by the operator of the supervising company or the group company.
[0271]
Here, the supervising company server 1 checks whether or not to perform the automatic payment statement splitting process on the display screen for the operator of the supervising company, for example, in the screen display of FIG. 40 (step S301). Here, if the setting button for not performing the payment statement automatic division processing is selected (step S301; N), registration indicating that the automatic division processing is not to be performed is made, and the process proceeds to the next step S303.
[0272]
Conversely, if the setting button for performing the payment statement automatic division process is selected (eg, the setting button below the default setting button is selected) (step S301; Y), the customer master 13 includes A registration to perform the division process is made (step S302).
[0273]
Next, the amount remaining after the amount split and the reconciliation process for the same amount in both detail data are performed by the arithmetic control unit 10, or the amount remaining without the amount split and the reconciliation process not being performed, It is checked whether the account item can be automatically processed as advance payment (step S303).
[0274]
If the account is not automatically processed as an advance payment (step S303; N), registration is made that processing is not to be performed, and the process proceeds to step S307 described below.
[0275]
On the other hand, when the account item is automatically processed as an advance payment (step S303; Y), an input of a storage period of unapplied data is requested (step S304), and it is checked whether or not the storage period has been input. (Step S305). If the storage period has not been input (step S305; N), the process returns to step S304, and the above processing is repeated.
[0276]
Conversely, if there is an input of the storage period (step S305; Y), the fact that the advance receipt processing is automatically executed and the storage period are registered in the customer master 13 (step S306).
[0277]
If the pre-payment processing is not automatically executed on the display screen, or if the storage period has expired despite the fact that the execution of the processing has been registered, the final application processing Is checked (step S307).
[0278]
If the final clearing process is a temporary receipt (step S307; Y), registration is made in the customer master 13 to perform the final clearing process with the account item as a temporary receipt (step S308). Conversely, if the final clearing process is not a provisional payment (step S307; N), registration is made in the customer master 13 so that the clearing process is performed with the account item out of accounts receivable (step S309). Thereafter, the processing shifts to the processing of FIG.
[0279]
As shown in FIG. 43, the controlling company server 1 checks whether or not to perform the automatic billing statement splitting process on the display screen for the operator on the display screen of FIG. 40 (step S401). Here, when the setting button for not performing the billing statement automatic division processing is selected (step S401; N), registration that the billing statement automatic division processing is not performed is made, and the process proceeds to step S403.
[0280]
On the other hand, when the setting button for performing the automatic billing division process is selected (for example, the setting button below the default setting button is selected) (step S401; Y), the billing automatic division is performed in the customer master 13. A registration to perform the processing is made (step S402).
[0281]
Next, the amount remaining after the amount split and the reconciliation process for the same amount in both detail data by the operation control unit 10 or the amount remaining without the amount split and without the reconciliation process is automatically performed. It is checked whether the discount processing may be performed (step S403).
[0282]
If the account is not automatically discounted as a discount (step S403; N), registration that the discount is not performed is made, and the process proceeds to step S407 described below.
[0283]
On the other hand, when the discount processing is performed automatically (step S403; Y), a request to set a discount rate is issued (step S404), and it is checked whether the discount rate has been set (step S405). . If the discount rate has not been set (step S405; N), the process returns to step S404, and the above processing is repeated.
[0284]
Conversely, if the discount rate is set (step S405; Y), the fact that the discount processing is automatically performed and the discount rate are registered in the customer master 13 (step S406).
[0285]
In the case where the discount processing is not automatically executed on the display screen or the case where the execution of the processing is registered but the remaining amount exceeds the setting range of the discount rate, Then, it is checked whether or not to automatically process the remaining balance (step S407).
[0286]
When the setting button not to be processed as the remaining billing amount is selected (step S407; N), a registration is made to the effect that the amount of money remaining in the customer master 13 is automatically cleared as an account receivable. This is performed (step S411).
[0287]
Conversely, when the setting button for processing the remaining balance is selected (step S407; Y), an input of the storage period of the unapplied data is requested (step S408), and it is determined whether or not the storage period has been input. Is checked (step S409). If there is no input of the storage period (step S409; N), the process returns to step S408 and the above processing is repeated.
[0288]
Conversely, if the storage period is input (step S409; Y), the fact that the account item is to be processed as the remaining amount of the bill for the remaining amount and the storage period are registered in the customer master 13 (step S410), The item setting process for executing the application procedure to the master 13 ends.
[0289]
FIGS. 44 and 45 show that the setting of the twelve clearing procedures by the clearing processing registration menu outside the pattern described above does not apply to the clearing processing according to the seventeenth matching processing pattern of the above embodiment (cannot be processed). FIG. 11 is a flowchart showing a flow of processing in a case where a computer automatically performs a reconciliation process for a part of the received receipt statement data and the billing statement data by dividing the amount and setting a specific account. .
[0290]
First, it is checked whether or not there remains payment detail data or billing detail data that has been excluded from the reconciliation processing by the matching processing pattern (step S501).
[0291]
If these payment statement data or billing statement data do not remain (step S501; N), the process ends. On the other hand, if the payment statement data or the claim statement data remains (step S501; Y), it is determined whether or not there is partner data (a claim statement data or a payment statement data) to be matched in the clearing procedure setting. Is checked (step S502). As will be described later, such a check is performed when the larger amount of the detailed data is divided, in accordance with the largest amount of the detailed data of the other party to be subjected to the matching process, and the same amount and the remaining amount. This operation is performed in a case where such work needs to be repeated after the two detailed data are erased by the same amount.
[0292]
If there is no such billing detail data or payment detail data (step S502; N), it is checked whether or not only the payment detail data remains (step S508).
[0293]
If only the payment details data remains (step S508; Y), it is determined that all of the work of dividing the amount of money and the application of both pieces of detail data related to excessive payment have been completed, and the process proceeds to step S509 described below. On the other hand, if only the billing statement data remains (step S508; N), it is determined that all of the below-described money amount division and reconciliation work for the underpayment have been completed, and the process proceeds to step S605 in FIG. 45 described below. .
[0294]
On the other hand, if the billing detail data or the payment detail data to be the partner exists in the above step S502 (step S502; Y), it is determined whether the payment is an excessive payment or an underpayment. It is checked whether or not the amount is larger than the billing amount of the other party or the total amount (step S503).
[0295]
If the deposit amount of the receipt details data is not larger than the billing amount of the other party or the total amount thereof (step S503; N), the process proceeds to step S601 in FIG. 45 described later.
[0296]
Conversely, if the deposit amount of the receipt details data is larger than the billing amount of the other party or the total amount thereof (step S503; Y), the arithmetic control unit 10 registers the customer master 13 registered as shown in FIG. Is checked to determine whether or not to perform the automatic splitting process on the deposit amount included in the receipt details data (step S504). The method of this automatic division will be described later. If the automatic division process is not performed (step S504; N), the process proceeds to step S509.
[0297]
On the other hand, if the automatic division process is performed (step S504; Y), the calculation controller 10 calculates one billing amount (for example, the largest amount among them) or the amount The processing is divided into the same amount as some of the total amounts and the remaining amount (step S505).
[0298]
Then, of the divided payment amounts, the payment amount equivalent to the above-mentioned one billing amount and the corresponding billing amount are subjected to a clearing process by the arithmetic control unit 10 (step S506).
[0299]
After that, the remaining payment details data is left as it is in the temporary payment details master 12b (step S507), and the process returns to the step S501 to repeat the above-described division processing of the specification data and the elimination processing of both the specification data.
[0300]
In step S502, when the billing statement data or the payment statement data to be the partner is gone (step S502; N), the check in step S508 (check whether only the payment statement data remains) is performed again, and the payment statement is performed. If only the data remains (step S508; Y), it is determined that all of the work of dividing the amount of money and the clearing of both detail data concerning the overpayment have been completed, and the process proceeds to step S509 described below.
[0301]
In step S509, the operation control unit 10 refers to the customer master 13 to check whether or not the account item is automatically processed as a down payment with respect to the remaining amount of the deposit amount after the clearing process. Is performed (step S509).
[0302]
In the case of automatically processing as advance payment (step S509; Y), the customer master 13 is further referred to and set from the payment date of the original payment specification data in the non-pattern application processing registration menu of FIG. It is checked whether it is within the period (during the period of saving the unapplied data) (step S510). If the unapplied data is in the storage period (step S510; Y), the remaining amount is processed as a down payment and is stored in the temporary receipt details master 12b for re-applying the next time (step S510). S511).
[0303]
On the other hand, in the above-mentioned step S509, when it is not automatically processed as the advance payment (step S509; N), and when it is not in the period of saving the unapplied data in step S510 (step S510; N), the customer master 13 is further referred to, It is checked whether or not the final application processing method for the remaining amount is set as a provisional deposit (step S512).
[0304]
If the final application process for the remaining amount is set to provisional payment (step S512; Y), the arithmetic control unit 10 forcibly deletes the remaining amount by using the account item as the provisional payment. Is performed (step S513). Conversely, if the final clearing process is not set to provisional payment (step S512; N), the arithmetic control unit 10 sets the account item to "out of accounts receivable" and excludes the remaining amount from the clearing target data. (Step S514). In the case where these accounts are included in the provisional deposit or the accounts other than the accounts receivable, since the remaining amount is separately processed by the operator such as refund, the receipt details data (the amount is the remaining portion) is temporarily stored in the temporary receipt details. After being returned to the master 12b, it is transferred by the arithmetic control unit 10 to another system via the communication unit 18 (step S515).
[0305]
After the processing of step S511 or step S515, the process returns to the first step S501 and shifts to the next data erasing process.
[0306]
In step S503, if the deposit amount of the receipt details data is not larger than the counterparty's billed amount or the total amount thereof (step S503; N), as shown in FIG. It is checked whether or not the automatic split process is performed on the billing amount included in the billing statement data (step S601). The method of this automatic division will be described later. If the automatic division process is not performed (step S601; N), the billing statement data is left as it is in the temporary billing statement master 11b (step S602), and the process proceeds to step S605 described later. On the other hand, if the automatic division process is performed (step S601; Y), the calculation control unit 10 determines whether or not the received amount of one (for example, the largest amount among them) or the amount of those payments is calculated by the arithmetic and control unit 10. Is divided into the same amount as the total amount and the remaining amount (step S603).
[0307]
Then, of the divided billing amounts, the billing amount of the same amount as the deposit amount and the corresponding deposit amount are subjected to a clearing process by the arithmetic control unit 10 (step S604), and the process returns to the step S501.
[0308]
If it is determined in step S508 that only the billing statement data remains (step S508; N), the above-described division of the amount and the reconciliation of both statement data regarding the underpayment have all been completed, and the process proceeds to step S606. The operation control unit 10 refers to the customer master 13 to check whether or not to automatically process the account item as a discount for the remaining amount of the invoiced amount after the application process. (Step S605).
[0309]
In the case of automatically processing as a discount (step S605; Y), the customer master 13 is further referred to and whether or not the remaining amount (difference) is within the set range of the discount rate (original billing amount x discount rate). Is checked (step S606).
[0310]
If the remaining amount is within the setting range of the discount rate (step S606; Y), the arithmetic and control unit 10 temporarily stores the payment details data of the discount amount corresponding to the remaining amount of the billing details data. It is created, a discount account is given to it, and a forcible reconciliation process is performed with the remaining amount of the billing statement data (step S607).
[0311]
On the other hand, if the discount is not automatically processed in step S605 (step S605; N) and if the remaining amount is not within the set range of the discount rate in step S606 (step S606; N), the customer master 13 is referred to. Then, it is checked whether or not the account is automatically processed as the remaining balance (step S608).
[0312]
In the case of automatically processing as the remaining amount of the bill (step S608; Y), within the period set in the non-pattern clearing process registration menu of FIG. (During the data storage period) (step S609). If it is during the reconciliation-uncompleted data storage period (step S609; Y), the remaining amount is processed as the remaining amount for billing, and is stored in the temporary billing statement master 11b for the next reclaiming process. (Step S610).
[0313]
On the other hand, in step S608, when the billing balance is not automatically processed (step S608; N), and when it is not in the unapplied data storage period in step S609 (step S609; N), the customer master 13 is further referred to. Regarding the final clearing process for the remaining amount, the arithmetic control unit 10 sets the account item as receivable and forcibly clears the remaining amount (step S611).
[0314]
If the remaining amount is forcibly applied as receivable in step S611, the remaining amount is separately billed by an operator. ) Is temporarily returned to the temporary billing statement master 11b, and then transferred to another system by the arithmetic and control unit 10 via the communication unit 18 (step S612).
[0315]
After the processes in steps S607, S610, and S612, the process returns to the first step S501, and shifts to the next data erasing process.
[0316]
Next, with respect to the reconciliation procedure stored in the reconciliation procedure master 14, the case of overpayment will be described with reference to FIGS. 46 to 57, and the case of underpayment will be described with reference to FIGS. 58 to 69. As described above, these clearing procedures are set and registered in the customer master 13 as shown in FIG. 41 by the operator from the clearing process registration menu outside the pattern in FIG.
[0317]
First, as shown in FIG. 46, two billing detail data of a billing amount of 40,000 yen on September 10, 2002 and a billing amount of 20,000 yen on September 20, 2002 are erased according to the above-mentioned seventeen matching processing patterns. In the case where the billing statement data that is not subject to the transfer processing is left, and the billing statement data of the transfer amount of 80,000 yen is also left on the payment date of October 25, 2002, this state is a so-called state. This is equivalent to an overpayment.
[0318]
When the payment statement automatic division process is performed in such a state, as shown in FIG. 47, both the payment statement data and the payment control date are kept on October 25, 2002 by the arithmetic and control unit 10. As it is, the deposit amount of 80,000 yen is divided into an amount (40,000 yen in the figure) matching the largest billed amount and the remaining amount (40,000 yen in the figure).
[0319]
Then, for the hatched portion (for the same amount) in FIG.
[0320]
Next, as shown in FIG. 49, a similar division process is performed on the payment detail data of the remaining amount (40,000 yen), and further, as shown in FIG. 50, a shaded portion (for the same amount). Is performed by the arithmetic control unit 10.
[0321]
The above process is repeated until there is no more billing detail data to be cleared (to be a partner) in the clearing procedure.
[0322]
In the case of FIG. 51, the last remaining receipt details data is processed by the arithmetic control unit 10 as an advance receipt (temporarily stored in the temporary receipt details master 12b), and is retained until the next reconciliation process.
[0323]
In the case of FIG. 52, the remaining payment details data is processed by the arithmetic and control unit 10 as a provisional receipt for the account item, and the payment details data in the shaded portion is forcibly erased without being lent. Become. In that case, the data is transferred to another system by the arithmetic and control unit 10, where it is left to the processing of the system (for example, the system outputs an indication to the operator to perform a refund process, and accordingly displays the display. Refund processing is performed by an operator or the like).
[0324]
In the case of FIG. 53, the remaining payment details data is processed by the arithmetic and control unit 10 so that the account item is out of accounts receivable, and the payment details data enclosed by a broken line are excluded from the reconciliation target. In that case, the data is transferred to another system by the arithmetic and control unit 10, where it is left to the processing of the system. When processed as non-accounts receivable, the detailed data is processed by the supervising company server 1 so that screen inquiry and file output can be performed on the server 1 itself and at the billing source terminals 3x to 3z of the group company. It is better to keep the data in a separate file.
[0325]
Another application processing method in the case of excessive deposit will be described with reference to FIGS.
[0326]
First, when there is an excessive deposit as shown in FIG. 46, as shown in FIG. 54, the above-mentioned deposit details data is stored by the arithmetic and control unit 10 on October 25, 2002, while both of the deposit dates are kept. The deposit amount of 80,000 yen is divided into an amount (60,000 yen in the case of the figure) matching the total amount of the billing amount and a remaining amount (20,000 yen in the case of the figure).
[0327]
Then, for the same amount of money (shaded portion) in FIG.
[0328]
Next, as for the payment details data of the remaining amount (for 20,000 yen), in the case of FIG. 55, the calculation control unit 10 processes the account item as advance receipt (temporarily stores it in the temporary payment details master 12b), and To the time of the reconciliation process.
[0329]
In the case of FIG. 56, the remaining payment details data is processed by the arithmetic and control unit 10 as a provisional receipt for the account, and all the payment details data (all shaded portions) are forcibly erased without borrowing and debiting. Will be included. In this case, the receipt details data relating to the provisional receipt is transferred by the arithmetic and control unit 10 to another system, where it is left to the processing of the system.
[0330]
Further, in the case of FIG. 57, the remaining payment detail data is processed by the arithmetic and control unit 10 so that the account item is out of the accounts receivable, and only the shaded portion (the portion where the amount matches) is subjected to the clearing process of both the detail data. Further, the payment details data processed as non-receivable is excluded from the application. In that case, the data is transferred to another system by the arithmetic and control unit 10, where it is left to the processing of the system.
[0331]
Next, an underpayment will be described with reference to FIGS.
First, as shown in FIG. 58, the billing statement data of the billing amount of 60,000 yen on the billing date of September 10, 2002 is left as the billing statement data which has been excluded from the reconciliation processing by the above-mentioned 17 matching processing pattern. On the other hand, if the payment details data of the transfer amount of 30,000 yen on the payment date of October 25, 2002 and the transfer amount of 20,000 yen on the same day are left, this state corresponds to the case of so-called underpayment. Will do.
[0332]
When the billing statement automatic division process is performed in such a state, as shown in FIG. 59, the billing statement data is kept on September 10, 2002 by the arithmetic control unit 10 on both sides. As it is, the billed amount of 60,000 yen is divided into the amount matching the largest deposit amount (30,000 yen in the figure) and the remaining amount (30,000 yen in the figure).
[0333]
Then, for the hatched portion (for the same amount) in FIG.
[0334]
Next, as shown in FIG. 61, the same division processing is performed on the billing detail data for the remaining amount (30,000 yen), and further, as shown in FIG. 62, the shaded portion (for the same amount). Is performed by the arithmetic control unit 10.
[0335]
The above processing is repeated until there is no more payment detail data to be applied (the other party) in this application procedure.
[0336]
In the case of FIG. 63 (when the shortage is within the range of the discount rate of the original billing amount), the arithmetic control unit 10 applies the same discount amount as the billing amount obtained by discounting the account item to the last remaining billing statement data. Is newly created, and both the detail data of the shaded portions are erased.
[0337]
Further, as shown in FIG. 64, the account data corresponding to the remaining balance is added to the last remaining billing statement data by the arithmetic and control unit 10 and stored in the temporary billing statement master 11b. Up to this point, it remains as the target of the billing data reconciliation process.
[0338]
Alternatively, as shown in FIG. 65, the account details of the receivable is added to the billing statement data of the remaining amount by the arithmetic and control unit 10 (shaded portion), and the reconciliation process is performed. In that case, the data is transferred to another system by the arithmetic and control unit 10, where it is left to the processing of the system.
[0339]
Another reconciliation processing method in the case of an underpayment and a setting for automatic billing division processing will be described with reference to FIGS. 66 to 69.
[0340]
First, when there is an underpayment as shown in FIG. 58, as shown in FIG. 66, the billing specification data is processed by the arithmetic control unit 10 on September 10, 2002 while keeping both billing dates. The invoice amount of 60,000 yen is divided into an amount (50,000 yen in the case of the figure) matching the total amount of the deposit and a remaining amount (10,000 yen in the case of the figure).
[0341]
Then, with respect to the same amount of money (shaded portion) in FIG.
[0342]
At the same time, the calculation control unit 10 temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data (10,000 yen in the case of the same figure), and sets the discount account item to it. (If the shortfall is within the discount rate of the original billing amount), the clearing process will be performed simultaneously with the clearing process for the remaining billing statement data, In this case, the entire amount of both the detail data is cleared.
[0343]
In the case of FIG. 68, the calculation control unit 10 performs an application process for the same amount (shaded portion).
[0344]
On the other hand, as for the billing statement data of the amount of money (10,000 yen) remaining in the division process, the calculation control unit 10 processes the account item as the remaining billing amount as shown in FIG. Once stored) and remain until the next clearing process.
[0345]
Further, in FIG. 69, as in the case of FIG. 68 described above, the calculation control unit 10 performs a clearing process for the same amount of money (shaded portion).
[0346]
Next, as shown in the figure, the billing statement data of the amount of money (equivalent to 10,000 yen) remaining in the division processing is processed by the arithmetic and control unit 10 as accounts receivable (the temporary billing statement master 11b stores Once stored), the data is forcibly erased. In that case, the data is transferred to another system by the arithmetic and control unit 10, where it is left to the processing of the system.
[0347]
As described above, according to the configuration of the present embodiment, even when the billing party and the payment source (payment source) do not match, the association is performed between them, and the receivable clearing process is automated by a computer or the like. Will be able to do.
[0348]
Further, from both the billing detail data and the payment detail data extracted by the narrowing-down process relating to such an entity, which data is in correspondence with each other is further narrowed down according to a reconciliation processing procedure using some predetermined application patterns. Since the narrowing down process for the corresponding data is performed, the computer automatically performs the loan clearing process.
[0349]
Further, in the above-described procedure of the matching process pattern, when there is a so-called overpayment or underpayment that cannot be erased and charged, the deposit amount or the total amount of the receipt details data to be applied and the target receipt details The amount of the billing data to be cleared or the total amount of the billing details data having a billing date of a specific period before the latest payment date of the data is too large or too small to be reconciled from the beginning. ), The calculation control unit divides the detailed amount data on the large amount side into an amount corresponding to (one amount of the other item data or a plurality of total amounts thereof) and the remaining amount, and With respect to the same amount of the two detailed data, the calculation control unit automatically performs the erasing process of the two detailed data, so that a part of the data can be strengthened as much as possible. Comprising a specific scrubbing process to the computer can be automatically performed. In this case, the arithmetic control unit assigns a specific account item to the remaining amount, and the remaining account amount is left in each of the temporary detail data storage units as a payment target data or billing detail data reconciliation process (each of them). The data for the balance is stored in the temporary detail data storage unit), forced reconciliation processing is performed, or the respective temporary description data storage units are excluded from the reconciliation processing target. Become. Alternatively, the calculation control unit temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, assigns a discount account to the data, and performs a forcible clearing process. In other words, the payment details data of the discount amount corresponding to the remaining amount of the billing details data is newly created in the section of "discount", and the reconciliation process is performed together with the loan. .
[0350]
It should be noted that the method for retiring a loan according to the present invention is not limited to the above-described embodiment, and it goes without saying that various changes can be made without departing from the spirit of the present invention.
[0351]
【The invention's effect】
As described above, according to the claim clearing processing method, the claim clearing processing apparatus, the computer program, and the recording medium according to claims 1 to 64 of the present invention, the billing destination and the payment source match, When it is determined that a person who has a specific relationship on behalf of the billing party has become the payment source, the billing statement data and the payment statement data to be applied can be specified, and further included in these data. An excellent effect can be achieved in that the receivables clearing process can be automatically performed by the computer in accordance with a predetermined number of matching processes for the billing amount and the deposit amount.
[0352]
According to the claim clearing processing method, the claim clearing processing apparatus, the computer program, and the recording medium according to claims 65 to 119, the so-called matching processing pattern described in claims 1 to 64 is used. In the procedure, even if there is a so-called overpayment or underpayment that cannot be erased, the above-mentioned calculating means converts the detailed data on the large amount side into (one amount of the other detailed data or a total of a plurality thereof). Amount) and the remaining amount are divided, and for the same amount of both detail data, the calculation means automatically performs the process of clearing both detail data. In this case, the computer can automatically perform the compulsory erasure process for a part of the erasure to the extent possible. In this case, a specific account item is added to the remaining amount by the calculation means, and the remaining account amount is left in each data storage means as an object of the reconciliation processing of the payment statement data or the billing statement data. The data corresponding to the remaining amount is stored in the means), forced reconciliation processing is performed, or the respective data storage means are excluded from the reconciliation processing target. Alternatively, the above-mentioned calculating means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, assigns a discount account to the data, and performs the reconciliation processing with the balance. Will be done.
[Brief description of the drawings]
FIG. 1 is an explanatory diagram showing an outline of an embodiment of the present invention.
FIG. 2 is an explanatory diagram showing a functional block configuration in a managing company server 1 and a processing flow in the block configuration.
FIG. 3 is an explanatory diagram showing a functional block configuration in a server 1 of the controlling company and a processing flow in the block configuration.
FIG. 4 is an explanatory diagram showing a functional block configuration in the server 1 of the controlling company and a processing flow in the block configuration.
FIG. 5 is an explanatory diagram showing a functional block configuration in the server 1 of the controlling company and a processing flow in the block configuration.
FIG. 6 is an explanatory diagram showing a functional block configuration in the server 1 of the controlling company and a processing flow in the block configuration.
FIG. 7 is a flowchart showing a registration procedure of a setting item for reconciliation / application in the customer master 13 of the server 1 by a supervising company or a group company.
FIG. 8 is a flowchart showing a processing procedure of a debt clearing process by a narrowing process relating to a billing party and a payment source entity and a narrowing process relating to corresponding data in FIGS. 3 to 6;
FIG. 9 is an explanatory diagram showing an example of a state of setting and registering a grouping table in the customer master 13 which defines who will make a payment as a payment source for grouped customers A to G;
FIG. 10 is an explanatory diagram showing an example of payment statement data and billing statement data that have been extracted based on the narrowing-down process for the billing party and the payment source entity based on FIG. 9;
FIG. 11 is an explanatory diagram showing an example of an application pattern 1;
FIG. 12 is an explanatory diagram showing an example of a consumption pattern 2;
FIG. 13 is an explanatory diagram showing an example of an application pattern 3;
FIG. 14 is an explanatory diagram showing an example of a clearing pattern 4;
FIG. 15 is an explanatory diagram showing an example of an application pattern 5;
FIG. 16 is an explanatory diagram showing an example of an application pattern 6;
FIG. 17 is an explanatory diagram showing an example of an application pattern 7;
FIG. 18 is an explanatory diagram showing an example of a consumption pattern 8.
FIG. 19 is an explanatory diagram showing an example of an application pattern 9;
FIG. 20 is an explanatory diagram showing an example of an application pattern 10;
FIG. 21 is an explanatory diagram showing an example of a consumption pattern 11;
FIG. 22 is an explanatory diagram showing an example of an application pattern 12;
FIG. 23 is an explanatory diagram showing an example of an application pattern 13;
FIG. 24 is an explanatory diagram showing an example of an application pattern 14;
FIG. 25 is an explanatory diagram showing an example of an application pattern 15;
FIG. 26 is an explanatory diagram showing an example of an application pattern 16;
FIG. 27 is an explanatory diagram showing an example of a consumption pattern 17;
FIG. 28 is an explanatory diagram showing a setting example of each item in the customer master 13 in one embodiment of the present invention.
FIG. 29 is an explanatory diagram showing a setting example of a transfer fee master 15 in the configuration of the embodiment.
FIG. 30 shows the corresponding billing statement data and deposit statement data when billing is made to customers A to D from each group company led by the supervising company, and thereafter payment is made with customer A as the payment source. It is explanatory drawing which shows an example of.
FIG. 31 is an explanatory diagram showing a state in which narrowing-down has been performed according to the initially set erase pattern 17;
FIG. 32 is an explanatory diagram showing a state where the next billing statement data is read out when the application cannot be cleared in the first amount check.
FIG. 33 is an explanatory diagram showing an example of unapplied billing statement data and payment statement data remaining after processing by the reconciliation pattern 17 is completed.
FIG. 34 is an explanatory diagram showing a state in which narrowing down has been performed according to the next consumption pattern 12;
FIG. 35 is an explanatory diagram showing a final processing result in the configuration of the present embodiment.
FIG. 36 is a functional block diagram of a server 1 in a case where a forcible reconciliation is performed in a controlling company server 1 in accordance with a reconciliation procedure involving division of a registered amount and setting of a specific account, and processing of the block configuration. It is explanatory drawing which shows a flow.
FIG. 37 is an explanatory diagram showing a functional block configuration in the server 1 when the above-described forced erasing is performed, and a flow of a next process in the block configuration.
FIG. 38 is an explanatory diagram showing a functional block configuration in the server 1 in a case where the above-described forced erasing is performed, and a flow of further processing in the block configuration.
FIG. 39 is an explanatory diagram showing a functional block configuration in the server 1 in the case where the above-described forced erasing is performed, and a processing flow at the time of further termination in the block configuration.
FIG. 40 is a display showing a clearing process registration menu outside a pattern used when forcibly clearing is performed in the controlling company server 1 in accordance with a clearing procedure involving division of a registered amount and setting of a specific account. It is an explanatory view of a screen.
FIG. 41 is an explanatory diagram showing, in a table form, a registration state of the customer master 13 in which a compulsory clearing procedure is registered by the registration menu.
FIG. 42 is a flowchart showing a flow of a registration process of a forcible clearing procedure using the registration menu.
FIG. 43 is a flowchart showing the flow of the continuation of the registration process of the forcible clearing procedure using the registration menu.
FIG. 44 is a flowchart showing a flow of a forcible clearing process of payment details data or billing details data according to the forcible clearing procedure.
FIG. 45 is a flowchart showing the continuation of the flow of the forcible clearing process of the payment details data to the billing details data according to the forcible clearing procedure.
FIG. 46 is an explanatory view showing an example of an application procedure stored in the application procedure master 14 showing a state in which an excessive deposit has been made;
FIG. 47 is an explanatory diagram showing an example of how to perform a money amount splitting process in accordance with the above-described clearing procedure in the case of the above example.
FIG. 48 is an explanatory diagram showing an example of how to perform the same amount forcible clearing process according to the clearing procedure in the case of the above example.
FIG. 49 is an explanatory diagram showing a method of the next money amount division processing according to the above-described application procedure for the money remaining after the forced application processing;
FIG. 50 is an explanatory diagram showing a method of the next same amount forcible clearing process according to the clearing procedure in the case of the above example.
FIG. 51 is an explanatory diagram showing an example of a method of handling payment detail data for the amount of money remaining after the forced clearing process;
FIG. 52 is an explanatory diagram showing another example of how to handle the payment details data for the amount of money remaining after the forced clearing process.
FIG. 53 is an explanatory diagram showing another example of how to handle the payment details data for the amount of money remaining after the forced clearing process.
FIG. 54 is an explanatory diagram showing another example of how to perform the money amount dividing process according to the above-mentioned clearing procedure when there is an excessive deposit in FIG. 46;
FIG. 55 is an explanatory diagram showing an example of a method of forcibly applying the same amount in accordance with the above-described application procedure and a method of handling payment detail data for an amount remaining after the application processing in the above example. is there.
FIG. 56 is an explanatory view showing another example of a method of forcibly applying the same amount according to the above-mentioned application procedure and a method of handling the payment details data for the amount remaining after the application processing.
FIG. 57 is an explanatory view showing another example of a method of forcibly applying the same amount in accordance with the above-mentioned application procedure and a method of handling the payment details data for the amount remaining after the application processing.
58 is an explanatory diagram showing an example of an application procedure stored in the application procedure master 14 showing a state in which an underpayment has occurred; FIG.
FIG. 59 is an explanatory diagram showing an example of a method of performing a money amount division process in accordance with the above-described clearing procedure in the case of the above example.
FIG. 60 is an explanatory diagram showing an example of how to perform the same amount forced clearing process according to the clearing procedure in the case of the above example.
FIG. 61 is an explanatory diagram showing a method of the next money amount division processing according to the above-mentioned application procedure for the money remaining after the forced application processing;
FIG. 62 is an explanatory diagram showing a method of performing the next same amount forced clearing process according to the clearing procedure in the case of the above example.
FIG. 63 is an explanatory diagram showing an example of a method of handling detailed data corresponding to the amount of money remaining after the forced clearing process;
FIG. 64 is an explanatory diagram showing another example of how to handle the billing statement data for the amount of money remaining after the forced clearing process.
FIG. 65 is an explanatory diagram showing another example of how to handle the billing statement data for the amount of money remaining after the forced clearing process.
FIG. 66 is an explanatory diagram showing another example of how to perform the money amount dividing process in accordance with the above-mentioned application procedure when there is an underpayment of FIG. 58;
FIG. 67 is a diagram showing another example of the same amount forced clearing process according to the above clearing procedure in the above example and a method of handling the billing statement data for the remaining amount after the clearing process. FIG.
FIG. 68 is an explanatory view showing another example of a method of forcibly applying the same amount according to the above-described application procedure and a method of handling the billing statement data for the amount of money remaining after the application processing.
FIG. 69 is an explanatory view showing still another example of a method of the same amount forcible clearing process according to the above clearing procedure and a method of handling billing detail data corresponding to the amount of money remaining after the clearing process.
[Explanation of symbols]
1 server
2 Host
3x-3z Billing source terminal
4a-4g customer terminal
10 Operation control unit
11a Billing item master
11b Temporary billing item master
12a Receipt details master
12b Temporary receipt details master
13 Customer Master
14 Application procedure master
15 Transfer fee master
16 Clearing program storage
17 RAM
18 Communication unit

Claims (119)

The same amount is stored in the data storage unit having the total amount of the payment details data to be applied and stored in the data storage unit and the billing date of a specific period before the latest payment date of the target payment details data. The total amount of the billing statement data to be reconciled is collated by the calculating means, and if the total amounts match or if the difference between the amounts is within a preset error range, the calculating means Wherein the receivable clearing process is performed for the receivable detail data and the bill detail data in the range where the total amount matches or the bill detail data in which the difference in the amount is within the error range. . As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target payment statement data, all billing statement data whose billing date is before the latest payment date is used. The method of claim 1, wherein the claim is settled. As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target receipt statement data, the billing statement data whose billing date is up to the last day of the previous payment date is used. 2. The method according to claim 1, wherein said method is performed. As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target payment statement data, billing statement data whose billing date is up to the last two months before the latest payment date is used. 2. The method of claim 1 according to claim 1, wherein As the billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target receipt statement data, the billing statement data corresponding to the month before the latest payment date is used as the billing statement data. 2. The method of claim 1 according to claim 1, wherein As the billing detail data to be applied having a billing date of a specific period before the latest payment date of the target payment detail data, the billing detail data corresponding to the date two months before the latest payment date is used. 2. The method of claim 1 according to claim 1, wherein The total amount of the payment details data to be cleared stored in the data storage means and the charges stored in the data storage means having the billing date before the latest payment date of the target payment details data. Of the billing detail data to be included, the billing amount is added in ascending order of the billing date, and the total amount being added is subjected to a reconciliation process by the calculating means, and the total amount on the way is the same, or If the difference between the amounts is within a preset error range, the calculation means calculates the billing detail data in the range where the total amount matches the target receipt details data or the claim details in which the amount difference is within the error range. A method for processing receivables, wherein reconciliation processing with data is performed. 8. The claim clearing process according to claim 7, wherein when there is a plurality of billing statement data to be cleared with the same billing date, said adding process is performed from the data of the small billing amount by the calculating means. Method. The total amount of the payment details data to be cleared stored in the data storage means and the charges stored in the data storage means having the billing date before the latest payment date of the target payment details data. In the billing detail data to be included, the billing amount is added in ascending order of the billing number included in the data, and the total amount during the addition is compared by the arithmetic means, and the total amount on the way is calculated. If they match or if the difference between the amounts is within a preset error range, the calculating means calculates the difference between the billing detail data and the billing detail data or the amount difference in the range where the total amount matches the error range. A claim reconciliation processing method in which reconciliation processing is performed with the billing statement data in the receivables. The total amount of the payment details data to be cleared stored in the data storage means and the charges stored in the data storage means having the billing date before the latest payment date of the target payment details data. Of the billing statement data to be collected, the total amount of billing statement data whose scheduled collection date included in the data is a date before the latest payment date is subjected to a reconciliation process by the calculating means, and the total sum is calculated. If they match or if the difference between the amounts is within a preset error range, the calculating means calculates the difference between the billing detail data and the billing detail data or the amount difference in the range where the total amount matches the error range. A claim reconciliation processing method in which reconciliation processing is performed with the billing statement data in the receivables. The same amount stored in the data storage means having the deposit amount of the payment details data to be applied stored in the data storage means and the billing date of a specific period before the payment date of the target payment details data. The total amount of the billing statement data to be included is collated by the arithmetic means, and the deposit amount and the total amount match, or if the difference between the amounts is within a preset error range, Claims characterized in that the calculation means performs a reconciliation process between the target receipt statement data and the claim statement data in the range where the total amount matches or the claim statement data in which the amount difference is within the error range. Reconciliation processing method. Claims characterized in that all billing statement data whose billing date is before the payment date is used as billing statement data to be applied which has a billing date of a specific period before the deposit date of the target receipt statement data. Item 14. The method for retiring a claim according to Item 11. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target receipt statement data, the billing statement data whose billing date is up to the last day of the previous month of the deposit date is used. The method for retiring a claim according to claim 11, wherein As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target receipt statement data, the billing statement data whose billing date is up to the last day of the month before the deposit date is used. 12. The method for retiring a claim according to claim 11. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target receipt statement data, the billing statement data for the month before the billing date is used as the billing statement data. 12. The method for retiring a claim according to claim 11. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target deposit statement data, the billing statement data corresponding to the date two months before the deposit date is used. 12. The method for retiring a claim according to claim 11. The deposit amount of the payment details data to be applied stored in the data storage means and the application data stored in the data storage means having the billing date before the payment date of the target payment details data. In the target billing statement data, while the billing amounts are added in ascending order of the billing date, the total amount during the addition is subjected to a reconciliation process by the calculating means, and the received amount and the total amount thereof are calculated on the way. If they match, or if the difference between the amounts is within a preset error range, the calculation means causes the target receipt details data, and the claim detail data in the range in which the deposit amount and the total amount thereof match. A method for reconciling claim data, wherein the reconciliation process is performed with billing statement data in which the difference between the amounts is within an error range. 18. The claim clearing process according to claim 17, wherein when there are a plurality of billing statement data to be cleared with the same billing date, the adding process is performed from the data of the small billing amount by the calculating means. Method. The deposit amount of the payment details data to be applied stored in the data storage means and the application data stored in the data storage means having the billing date before the payment date of the target payment details data. Of the target billing statement data, while the billing amounts are added in ascending order of the billing number included in the data, the total amount being added is subjected to a reconciliation process by the calculating means, and the deposit amount and the If the total amount is equal to or the difference between the amounts is within a preset error range, the calculation means makes the target payment details data match the above-mentioned received amount and the total amount thereof. A reconciliation processing method in which reconciliation processing is performed with the billing statement data or the billing statement data in which the amount difference is within the error range. The deposit amount of the payment details data to be applied stored in the data storage means and the application data stored in the data storage means having the billing date before the payment date of the target payment details data. Of the target billing statement data, the total amount of the billing statement data whose scheduled collection date included in the data is earlier than the payment date is subjected to a reconciliation process by the arithmetic means, and the deposit amount and the total thereof are calculated. If the amount matches, or if the difference between the amounts is within a preset error range, the calculating means uses the range in which the target payment details data, the above-described payment amount, and the total amount thereof match. Wherein the reconciliation process is performed with the billing statement data or the billing statement data in which the difference between the amounts is within an error range. The deposit amount of the payment details data to be applied stored in the data storage means and the application data stored in the data storage means having the billing date before the payment date of the target payment details data. In the target billing statement data, the billing amount is subjected to a matching process by the arithmetic means in the order of the oldest billing date, and the deposit amount matches the billing amount on the way, or the difference between the amounts is set in advance. If the error amount is within the error range, the calculation unit applies the target payment statement data, the billing statement data in which the deposit amount matches the billing amount or the billing statement data in which the difference in the amount is within the error range. A method for clearing a claim, wherein the method is performed. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
The two sums are compared, and if the sums match or if the difference between the sums is within a preset error range, the target payment statement data and the sum of A third calculating means for performing a clearing process on the billing statement data and the billing statement data in which the difference between the amounts is within an error range. As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the payment statement data, all billing statement data whose billing date is before the latest payment date is used. 23. The claim clearing apparatus according to claim 22, wherein: As the billing statement data to be applied which has a billing date of a specific period before the most recent deposit date of the billing statement data, the billing statement data whose billing date is up to the last day of the month before the latest payment date is used. 23. The claim clearing processing device according to claim 22, wherein: As the billing statement data to be applied which has a billing date of a specific period before the most recent payment date of the receipt statement data, the billing statement data whose billing date is up to the last two months before the latest payment day is used. The claim clearing apparatus according to claim 22, characterized in that: As the billing statement data to be applied which has a billing date of a specific period before the most recent payment date of the receipt statement data, the billing statement data corresponding to the month before the most recent payment date is used. The claim clearing apparatus according to claim 22, characterized in that: As the billing statement data to be applied which has a billing date of a specific period before the latest deposit date of the receipt statement data, the billing statement data corresponding to the date two months prior to the latest payment day is used as the billing statement data to be applied. The claim clearing apparatus according to claim 22, characterized in that: Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
A second method for sequentially outputting the total amount in the middle of the addition while adding the billing amount in the order of the oldest billing date among the billing detail data having the billing date prior to the latest payment date of the payment detail data. Arithmetic means of
Each time the second calculation means outputs the total amount, the two total amounts are compared in the middle, and if the total amounts match or if the difference between the amounts is within a preset error range, A third calculating means for performing a reconciliation process between the received receipt statement data and the claim statement data in the range where the total amount matches or the claim statement data in which the amount difference is within the error range. Receivable clearing equipment. 29. The method according to claim 28, wherein, when there are a plurality of billing statement data to be applied for the same billing date, the addition processing is sequentially performed from the data of the small billing amount by the second calculating means. Receivable clearing processor. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Of the billing statement data having a billing date before the most recent payment date of the above-mentioned billing statement data, while adding the billing amount in ascending order of the billing number included in the data, the total amount in the middle of the addition is calculated. Second calculating means for sequentially outputting,
Each time the second calculation means outputs the total amount, the two total amounts are compared in the middle, and if the total amounts match or if the difference between the amounts is within a preset error range, A third calculating means for performing a reconciliation process between the received receipt statement data and the claim statement data in the range where the total amount matches or the claim statement data in which the amount difference is within the error range. Receivable clearing equipment. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
The sum of the billing statement data having the billing date before the latest payment date of the billing statement data and the scheduled collection date included in the data having the billing date before the latest payment date. Second calculating means for calculating the amount,
The two sums are compared, and if the sums match or if the difference between the sums is within a preset error range, the target payment statement data and the sum of A third calculating means for performing a clearing process on the billing statement data and the billing statement data in which the difference between the amounts is within an error range. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the payment date of one of the receipt statement data;
The deposit amount of the deposit details data is compared with the total amount, and if the deposit amount matches the total amount, or if the difference between the amounts is within a preset error range, the target is determined. A second calculating means for performing a reconciliation process between the receipt statement data, the claim statement data in the range where the deposit amount and the total amount thereof match, or the claim statement data in which the difference in the amount falls within the error range. Characteristic credit clearing processor. Claims wherein all billing statement data whose billing date is before the payment date is used as the billing statement data to be applied which has a billing date of a specific period before the deposit date of the receipt statement data. 32. The claim clearing apparatus according to claim 32. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the receipt statement data, the billing statement data whose billing date is up to the last day of the month before the deposit date is used. 33. The claim clearing apparatus according to claim 32. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the billing statement data, billing statement data whose billing date is up to the last day of the month before the payment date is used. The claim clearing processing device according to claim 32. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the receipt statement data, the billing statement data for the month preceding the billing date is used. The claim clearing processing device according to claim 32. As the billing statement data to be applied which has a billing date of a specific period before the deposit date of the receipt statement data, billing statement data corresponding to the date two months before the receipt date is used. The claim clearing processing device according to claim 32. Data storage means for storing payment details data and billing details data to be applied;
Among the billing statement data having a billing date that is earlier than the payment date of the above-mentioned billing statement data, the billing amount is added in ascending order of the billing date, and the total amount during the addition is sequentially output. Arithmetic means of
Each time the first calculating means outputs the total amount, the deposit amount of the deposit details data is compared with the total amount on the way, and the received amount and the total amount match, or the difference between the amounts is calculated. Is within a preset error range, the target payment statement data and the claim statement data in the range in which the deposit amount and their total amount match or the claim difference data in which the amount difference is within the error range. And a second calculating means for performing a clearing process. 39. The receivable according to claim 38, wherein when there are a plurality of billing statement data to be applied for the same billing date, the addition processing is performed from the data of the small billing amount by the first calculating means. Reconciliation processing device. Data storage means for storing payment details data and billing details data to be applied;
Of the billing statement data having a billing date before the payment date of the above-mentioned billing statement data, the billing amount is added in ascending order of the billing number included in the data, and First arithmetic means for sequentially outputting,
Each time the first calculating means outputs the total amount, the deposit amount of the deposit details data is compared with the total amount on the way, and the received amount and the total amount match, or the difference between the amounts is calculated. Is within a preset error range, the target payment statement data and the claim statement data in the range in which the deposit amount and their total amount match or the claim difference data in which the amount difference is within the error range. And a second calculating means for performing a clearing process. Data storage means for storing payment details data and billing details data to be applied;
Of the billing statement data having a billing date before the first payment date of the above-mentioned billing statement data, the scheduled collection date included in the data is the total amount of the billing statement data having a date before the payment date. First calculating means for calculating;
The deposit amount of the deposit details data is compared with the total amount, and if the deposit amount matches the total amount, or if the difference between the amounts is within a preset error range, the target is determined. A second calculating means for performing a reconciliation process between the receipt statement data, the claim statement data in the range where the deposit amount and the total amount thereof match, or the claim statement data in which the difference in the amount falls within the error range. Characteristic credit clearing processor. Data storage means for storing payment details data and billing details data to be applied;
The reconciliation process is performed between the deposit amount of the receipt detailed data and the billing date of the target receipt detail data which has a billing date earlier than the receipt date, in the order of older billing date. If the deposit amount and the charge amount match on the way, or if the difference between the amounts is within a preset error range, the target deposit statement data, the charge amount and the charge amount match. A second calculating means for performing a clearing process with the billing data in which the difference between the detailed data and the amount of money is within an error range. When executed by the computer having the data storage means and the calculation means, the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data of the target payment details data The total amount of the billing specification data to be applied for reconciliation, which is also stored in the data storage unit having the billing date of a specific period, is subjected to a reconciliation process by the arithmetic unit, and both total amounts match or the amount If the difference is within a preset error range, the calculation means calculates the billing detail data in the range where the total amount matches the target payment detail data or the billing detail data in which the amount difference is within the error range. A computer program for executing the erasing process. As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target payment statement data, all billing statement data whose billing date is before the latest payment date is used. 44. The computer program according to claim 43, wherein: As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target receipt statement data, the billing statement data whose billing date is up to the last day of the previous payment date is used. 44. The computer program according to claim 43, wherein As billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target payment statement data, billing statement data whose billing date is up to the last two months before the latest payment date is used. 44. The computer program according to claim 43, wherein: As the billing statement data to be applied which has a billing date of a specific period before the latest payment date of the target receipt statement data, the billing statement data corresponding to the month before the latest payment date is used as the billing statement data. 44. The computer program according to claim 43, wherein: As the billing detail data to be applied having a billing date of a specific period before the latest payment date of the target payment detail data, the billing detail data corresponding to the date two months before the latest payment date is used. 44. The computer program according to claim 43, wherein: When executed by the computer having the data storage means and the calculation means, the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data of the target payment details data Of the billing statement data to be applied which is also stored in the data storage means having a billing date, while the billing amount is added in chronological order of the billing date, the total amount during the addition is: The matching processing is performed by the calculating means, and if the total sums on the way match or if the difference between the sums is within a preset error range, the calculating means sets the target payment statement data and the total amount to A computer program for executing a reconciliation process with billing detail data in a matched range and billing detail data in which a difference in amount is within an error range. 50. The computer program according to claim 49, wherein when there is a plurality of billing statement data to be applied for the same billing date, the calculating means performs the adding process from the data of a small billing amount. . When executed by the computer having the data storage means and the calculation means, the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data of the target payment details data Of the billing detail data to be applied for resale also stored in the data storage means having the billing date, the billing amount is added in ascending order of the billing number included in the data, and The total amount is subjected to a matching process by the calculating means, and if the total amount on the way coincides, or if the difference between the amounts is within a predetermined error range, the calculating means causes the target payment statement data to be processed. And a reconciliation process between the billing detail data in the range where the total amount matches and the billing detail data in which the difference in the amount is within the error range. Grams. When executed by the computer having the data storage means and the calculation means, the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data of the target payment details data Of the billing statement data to be applied which is also stored in the data storage means having the billing date, the billing statement data whose scheduled recovery date included in the data is a date before the latest payment date Is calculated by the calculating means, and if the two sums match or if the difference between the amounts is within a predetermined error range, the calculating means causes And a reconciliation process between the billing detail data in the range where the total amount matches and the billing detail data in which the difference in the amount is within the error range. Grams. When the program is executed by a computer having a data storage unit and a calculation unit, the deposit amount of the payment detail data to be applied to be stored stored in the data storage unit and the identification of the target payment detail data before the payment date are specified. The total amount of the billing statement data to be applied, which is also stored in the data storage unit having the billing date of the period, is reconciled by the arithmetic unit, and the deposit amount matches the total amount. Or, if the difference between the amounts is within a predetermined error range, the calculation means causes the target payment details data and the billing details data or the amount difference in the range where the total amount matches to fall within the error range. A computer program for executing a reconciliation process with certain billing statement data. Claims characterized in that all billing statement data whose billing date is before the payment date is used as billing statement data to be applied which has a billing date of a specific period before the deposit date of the target receipt statement data. Item 54. The computer program according to Item 53. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target receipt statement data, the billing statement data whose billing date is up to the last day of the previous month of the deposit date is used. The computer program according to claim 53, wherein: As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target receipt statement data, the billing statement data whose billing date is up to the last day of the month before the deposit date is used. 54. A computer program according to claim 53. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target receipt statement data, the billing statement data for the month before the billing date is used as the billing statement data. 54. A computer program according to claim 53. As the billing statement data to be applied having a billing date of a specific period before the deposit date of the target deposit statement data, the billing statement data corresponding to the date two months before the deposit date is used. 54. A computer program according to claim 53. When executed by the computer having the data storage means and the arithmetic means, the deposit amount of the payment details data to be applied to be stored stored in the data storage means and the billing of the target payment details data before the payment date Of the billing detail data to be applied for resale also stored in the data storage means having a date, while the billing amount is added in ascending order of the billing date, the total amount during the addition is The matching process is performed by the calculating means, and if the received money amount and the total amount thereof match on the way, or if the difference between the money amounts is within a preset error range, the calculating means generates Wherein the reconciliation process is performed with the billing statement data in the range where the deposit amount and the total amount thereof match or the billing statement data in which the difference between the amounts falls within the error range. A computer program that. 60. The computer program according to claim 59, wherein when there is a plurality of billing statement data to be applied for the same billing date, the adding means performs the adding process from the data of the small billing amount by the calculating means. . When executed by the computer having the data storage means and the arithmetic means, the deposit amount of the payment details data to be applied to be stored stored in the data storage means and the billing of the target payment details data before the payment date Of the billing detail data to be applied which is also stored in the data storage means having a date, the billing amount is added in ascending order of the billing number included in the data, and The amount is subjected to a matching process by the arithmetic unit, and if the received amount and the total amount thereof match on the way or if the difference between the amounts is within a predetermined error range, the arithmetic unit The reconciliation processing of the received receipt detail data and the claim detail data in the range where the deposit amount and the total amount thereof match or the claim detail data in which the difference in the amount is within the error range is executed. Computer program characterized in that it is. When executed by the computer having the data storage means and the arithmetic means, the deposit amount of the payment details data to be applied to be stored stored in the data storage means and the billing of the target payment details data before the payment date Of the billing statement data to be applied which is also stored in the data storage means having a date, the total amount of billing statement data whose scheduled collection date contained in the data is a date before the payment date Are subjected to a matching process by the calculation means, and if the deposit amount and the total amount thereof match, or if the difference between the amounts is within a preset error range, the calculation means sets a target. The reconciliation process is executed between the receipt statement data, the claim statement data in the range in which the deposit amount and the total amount thereof match, or the claim statement data in which the difference in the amount falls within the error range. Computer program, characterized in that. When executed by the computer having the data storage means and the arithmetic means, the deposit amount of the payment details data to be applied to be stored stored in the data storage means and the billing of the target payment details data before the payment date Of the billing specification data to be applied for resale, which is also stored in the data storage means having a date, the billing amount is compared with the billing date in chronological order by the computing means, and the deposit amount is calculated on the way. If the billing amount matches the billing amount or if the difference between the amounts is within a predetermined error range, the calculating means causes the billing statement data to match the billing amount and the billing amount. A computer program for executing a reconciliation process with billing detail data in which a difference between the detail data and the amount of money is within an error range. A computer-readable recording medium storing the computer program according to any one of claims 43 to 63. In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation and the total amount thereof are compared by the arithmetic means, there is a difference between the two amounts, and the difference is out of a preset error range. If there is payment statement data and billing statement data that have been excluded from the reconciliation process, the amount of the one statement data, which is the larger one, is calculated by the calculation means (the other Of the detailed data of one or a plurality of sums thereof) and the remaining amount, and the same amount of the two detailed data is subjected to the process of applying the two detailed data.
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or the data storage means is excluded from the target of the reconciliation processing. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
66. The claim clearing method according to claim 65, wherein an account of the advance receipt is added to the remaining amount by the calculating means, and the account is left in the data storage means as a processing target for clearing the receipt details data. Processing method. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
66. The receivable clearing method according to claim 65, wherein an account of the provisional deposit is added to the remaining amount by the calculating means, and a forced clearing process is performed. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
66. The receivable clearing process according to claim 65, wherein the calculation means adds an account item other than the accounts receivable for the remaining amount and excludes the account from the clearing process in the data storage means. Method. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
66. The receivable according to claim 65, wherein an account of the remaining amount of the bill is added to the remaining amount by the calculating means, and the account is left in the data storage means as an object of the reconciliation processing of the billing statement data. Reconciliation processing method. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
66. The receivable clearing method according to claim 65, further comprising, for the remaining amount, an account of receivables assigned by the calculating means and a forced clearing process performed. If the remaining amount of the detailed data subjected to the division processing is larger than the amount of the other remaining detailed data or a plurality of total amounts, the operating unit further increases the amount of the remaining amount by the calculating means. When the above-mentioned division process and the reconciliation process of both detailed data are repeated, and the remaining amount becomes smaller than the amount of the other remaining detailed data or a plurality of total amounts, the remaining amount is reduced. The calculation means assigns a specific account and is left in the data storage means as a processing object of payment statement data or billing statement data. Forcible reconciliation processing is performed. 71. The method according to any one of claims 65 to 70, wherein the method is excluded from the object of the reconciliation processing by means. In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation and the total amount thereof are compared by the arithmetic means, there is a difference between the two amounts, and the difference is out of a preset error range. Is determined, there is the payment statement data and the billing statement data that have been excluded from the reconciliation processing, and the billing amount of 1 of the billing statement data that has been excluded from the reconciliation processing is also the same as the reconciliation processing. In the case where the deposit amount is larger than the deposit amount or the total amount of the deposit detail data which is excluded from the target, the calculation means sets the charge amount of the claim detail data to (the deposit amount of the deposit detail data or the total amount thereof). Forehead) and equivalent, is divided into a remaining amount of money, both detailed data per the same amount min, with processing scrub both detailed data is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process. Claims processing method for receivables. If the remaining amount of the billing statement data that has been subjected to the splitting process is larger than the amount of the other remaining receipt statement data or a plurality of total amounts, the remaining amount is calculated by the calculating means. Further, the above-described splitting process of the amount and the reconciliation process of both the detail data are repeated, and when the remaining amount of the billing detail data becomes smaller than the amount of the other remaining receipt details data or the total amount of the plurality of the remaining receipt details data, By the above-mentioned arithmetic means, the payment details data of the discount amount corresponding to the remaining amount of the billing details data is temporarily created, a discount account is attached thereto, and the forcible clearing process is performed. 73. The method for retiring a claim according to claim 72, wherein: In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation or the total amount thereof is subjected to a matching process by the calculating means, the two amounts match, or the difference between the two amounts is a predetermined error. It is determined that it is within the range, and within that range, the reconciliation process of the targeted payment statement data and billing statement data is performed,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. When there is received receipt statement data and billing statement data, the amount of one statement data, which is the larger amount, is calculated by the above-mentioned calculating means into an amount equivalent to (the amount of one statement of the other statement data or a plurality thereof). , And the remaining amount is divided. For the same amount of the two items of data, the reconciliation process of both items of data is performed.
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or the data storage means is excluded from the target of the reconciliation processing. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
75. The receivable clearing according to claim 74, wherein an account of the advance receipt is added to the remaining amount by the calculating means, and the account is left in the data storage means as a processing object of the payment detail data. Processing method. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
75. The receivable clearing method according to claim 74, wherein, for the remaining amount, the calculation means assigns an account of the provisional deposit and forcibly clears the account. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
75. The receivable clearing process according to claim 74, wherein an account item other than the accounts receivable is added to the remaining amount by the calculating means, and is excluded from the reconciliation processing object in the data storage means. Method. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
75. The receivable according to claim 74, wherein an account of the remaining amount of the bill is attached to the remaining amount by the calculating means, and the account is left in the data storage means as an object of reconciliation of the billing statement data. Reconciliation processing method. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
75. The receivable clearing method according to claim 74, wherein, for the remaining amount, an account of receivables is added by the calculating means and compulsory clearing processing is performed. If the remaining amount of the detailed data subjected to the division processing is larger than the amount of the other remaining detailed data or a plurality of total amounts, the operating unit further increases the amount of the remaining amount by the calculating means. When the above-mentioned division process and the reconciliation process of both detailed data are repeated, and the remaining amount becomes smaller than the amount of the other remaining detailed data or a plurality of total amounts, the remaining amount is reduced. The calculation means assigns a specific account and is left in the data storage means as a processing object of payment statement data or billing statement data. Forcible reconciliation processing is performed. 80. The method according to any one of claims 74 to 79, wherein the method is excluded from the object of the reconciliation processing by means. In the data storage means having the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the billing date of a specific period before the latest payment date of the target payment details data. Similarly, when the billing amount of the billing statement data to be applied for reconciliation or the total amount thereof is subjected to a matching process by the calculating means, the two amounts match, or the difference between the two amounts is a predetermined error. It is determined that it is within the range, and within that range, the reconciliation process of the targeted payment statement data and billing statement data is performed,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. Payment data and billing statement data, and the charge amount of one of the billing statement data that was excluded from the reconciliation processing is equal to the sum or the total amount of the payment statement data that was also excluded from the reconciliation processing. If it is larger, the calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and For each amount, the reconciliation process of both detail data is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process. Claims processing method for receivables. If the remaining amount of the billing statement data that has been subjected to the splitting process is larger than the amount of the other remaining receipt statement data or a plurality of total amounts, the remaining amount is calculated by the calculating means. Further, the above-described splitting process of the amount and the reconciliation process of both the detail data are repeated, and when the remaining amount of the billing detail data becomes smaller than the amount of the other remaining receipt details data or the total amount of the plurality of the remaining receipt details data, By the above-mentioned arithmetic means, the payment details data of the discount amount corresponding to the remaining amount of the billing details data is temporarily created, a discount account is attached thereto, and the forcible clearing process is performed. The method of claim 81, further comprising the step of: Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
At the time of determining whether or not the erasing process is possible by the third arithmetic means, there is a difference between the two amounts of money between the two detailed data, and it is determined that the difference is outside the preset error range. When there are payment statement data and billing statement data that have become outside, the amount of the one statement data of the larger amount is calculated as (an amount of one of the other statement data or a total thereof), A fourth calculating means for dividing the data into the remaining amount and performing the process of applying the two detailed data to the same amount of the two detailed data;
For the remaining amount, add a specific account, leave it in the data storage unit as the target of the reconciliation processing of the payment details data or billing details data, perform a compulsory reconciliation process, or And a control unit for excluding the reconciliation processing target. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the fourth arithmetic means The deposit amount of the receipt detail data is divided into a portion corresponding to (the billing amount of the billing detail data or the total amount thereof) and a portion corresponding to the remaining amount. Processing is performed,
84. The receivable clearing according to claim 83, wherein an account of the advance payment is added to the remaining amount by the control means, and the receivable is left in the data storage means as a processing target of the payment detail data. Processing equipment. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the fourth arithmetic means The deposit amount of the receipt detail data is divided into a portion corresponding to (the billing amount of the billing detail data or the total amount thereof) and a portion corresponding to the remaining amount. Processing is performed,
84. The receivable clearing apparatus according to claim 83, wherein the control means assigns an account of the provisional deposit and forcibly clears the remaining amount. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the fourth arithmetic means The deposit amount of the receipt detail data is divided into a portion corresponding to (the billing amount of the billing detail data or the total amount thereof) and a portion corresponding to the remaining amount. Processing is performed,
84. The receivable clearing process according to claim 83, wherein the control means adds an account item other than the accounts receivable for the remaining amount, and removes the account from the clearing process in the data storage means. apparatus. When the billing amount of one of the billing statement data that has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the billing statement data that has also been excluded from the reconciliation processing, the fourth arithmetic unit performs The billing amount of the billing detail data is divided into a portion corresponding to (the deposit amount or the total amount of the above-mentioned receipt detail data) and the remaining amount. Processing is performed,
84. The receivable according to claim 83, wherein the control means assigns an account item corresponding to the remaining amount of the remaining amount, and the remaining account amount is left in the data storage means as an object of the reconciliation processing of the invoice detail data. Reconciliation processing device. When the billing amount of one of the billing statement data that has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the billing statement data that has also been excluded from the reconciliation processing, the fourth arithmetic unit performs The billing amount of the billing detail data is divided into a portion corresponding to (the deposit amount or the total amount of the above-mentioned receipt detail data) and the remaining amount. Processing is performed,
84. The receivable clearing apparatus according to claim 83, wherein said control means assigns an account of receivables and forcibly clears the remaining amount. When the remaining amount of the detailed data subjected to the splitting process is larger than the amount of the other remaining detailed data or a plurality of total amounts, the fourth calculating means calculates the remaining amount by the fourth calculating means. Further, the above-described splitting process of the amount and the reconciliation process of the two detailed data are repeated, and when the amount of the remaining amount is smaller than the amount of the other remaining detailed data or the total amount of the plurality, the remaining amount is reduced. For the amount of money, a specific account is added by the control means, and the data is stored in the data storage means as a payment object of payment details data or billing details data. 89. The claim clearing apparatus according to claim 83, wherein the data storing means is excluded from the clearing processing target. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
At the time of determining whether or not the erasing process is possible by the third arithmetic means, there is a difference between the two amounts of money between the two detailed data, and it is determined that the difference is outside the preset error range. If the billing amount of one of the billing detail data that has been excluded is larger than the deposit amount of the receipt detail data that has also been excluded from the reconciliation processing or the total amount thereof, the billing amount of the billing detail data is calculated as ( A fourth calculating unit that divides the amount corresponding to the data amount or the total amount thereof) into a portion corresponding to the remaining amount and a portion corresponding to the same amount of both the detail data, and performs a reconciliation process of both detail data;
Control means for temporarily creating payment details data of a discount amount corresponding to the remaining amount of the billing details data, attaching a discount account to it, and forcibly applying a clearing process. Characteristic credit clearing processor. If the remaining amount of the billing statement data that has been subjected to the division process is larger than the amount of the other remaining receipt statement data or a plurality of total amounts, the fourth calculation is performed on the remaining amount of money. By the means, the above-described split processing of the amount and the reconciliation processing of both the detail data are repeated, and the remaining amount of the billing detail data is smaller than the amount of the other remaining receipt details data or the total amount of a plurality of the remaining details. When this happens, the above-mentioned control means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, assigns a discount account to it, and forcibly applies it. 90. The claim clearing apparatus according to claim 90, wherein processing is performed. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
A fourth calculating means for performing a clearing process on the received receipt details data and billing detail data within a range where the clearing process is determined to be possible;
The third calculation means determines that there is a difference between the two amounts of data remaining after the reconciliation processing by the fourth calculation means, and that the difference is outside the preset error range. As a result, if there is payment statement data and billing statement data that have been excluded from the reconciliation process, the larger one of the statement data is replaced by the one of the other statement data The total amount) and the remaining amount are divided, and the fourth arithmetic unit issues an instruction to execute the process of applying both the detail data for the same amount of the detail data. 5 calculation means;
For the remaining amount, add a specific account, leave it in the data storage unit as the target of the reconciliation processing of the payment details data or billing details data, perform a compulsory reconciliation process, or And a control unit for excluding the reconciliation processing target. In the case where the deposit amount of 1 of the payment statement data excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof, the fifth arithmetic unit The deposit amount of the receipt statement data is divided into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a portion corresponding to the remaining amount. , The reconciliation process of both detail data is performed,
93. The receivable clearing as claimed in claim 92, wherein the control means adds an account of the advance payment to the remaining amount, and the receivable is left in the data storage means as a processing object of the payment detail data. Processing equipment. In the case where the deposit amount of 1 of the payment statement data excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof, the fifth arithmetic unit The deposit amount of the receipt statement data is divided into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a portion corresponding to the remaining amount. , The reconciliation process of both detail data is performed,
93. The receivable clearing apparatus according to claim 92, wherein the control means assigns an account of the provisional deposit and forcibly clears the remaining amount. In the case where the deposit amount of 1 of the payment statement data excluded from the reconciliation processing is larger than the billing amount of the billing statement data also excluded from the reconciliation processing or the total amount thereof, the fifth arithmetic unit The deposit amount of the receipt statement data is divided into a portion corresponding to (the billing amount of the billing statement data or the total amount thereof) and a portion corresponding to the remaining amount. , The reconciliation process of both detail data is performed,
93. The receivable clearing process according to claim 92, wherein the control means adds an account item other than the accounts receivable for the remaining amount, and removes the account from the clearing process in the data storage means. apparatus. In the case where the billing amount of one of the billing statement data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the receipt statement data which has also been excluded from the reconciliation processing, the fifth calculating means The billing amount of the billing detail data is divided into an amount corresponding to (the deposit amount of the deposit detail data or the total amount thereof) and a remaining amount, and the fifth calculating means calculates the same amount of the same amount of both the detail data. , The reconciliation process of both detail data is performed,
93. The receivable according to claim 92, wherein the control means assigns an account item corresponding to the remaining amount of the remaining amount, and the remaining account amount is left in the data storage means as an object of the reconciliation processing of the invoice detail data. Reconciliation processing device. In the case where the billing amount of one of the billing statement data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the receipt statement data which has also been excluded from the reconciliation processing, the fifth calculating means The billing amount of the billing detail data is divided into an amount corresponding to (the deposit amount of the deposit detail data or the total amount thereof) and a remaining amount, and the fifth calculating means calculates the same amount of the same amount of both the detail data. , The reconciliation process of both detail data is performed,
93. The receivable clearing apparatus according to claim 92, wherein said control means assigns an account of accounts receivable and forcibly clears the remaining amount. When the remaining amount of the detailed data subjected to the division processing is larger than the amount of the other remaining detailed data or a plurality of total amounts, the fifth calculating unit performs the remaining amount of money on the remaining amount. Further, the above-described splitting process of the amount and the reconciliation process of the two detailed data are repeated, and when the amount of the remaining amount is smaller than the amount of the other remaining detailed data or the total amount of the plurality, the remaining amount is reduced. For the amount of money, a specific account is added by the control means, and the data is stored in the data storage means as a payment object of payment details data or billing details data. 97. The claim clearing apparatus according to claim 92, wherein the data storing means is excluded from the target of the clearing processing. Data storage means for storing payment details data and billing details data to be applied;
First calculating means for calculating a total amount of the payment details data;
Second calculating means for calculating a total amount of billing statement data having a billing date of a specific period before the latest payment date of the payment statement data,
By performing the reconciliation process of the two amounts, it is determined whether or not the two amounts are the same or the difference between the two amounts is within a predetermined error range. Third calculating means for determining whether or not the data can be erased;
A fourth calculating means for performing a clearing process on the received receipt details data and billing detail data within a range where the clearing process is determined to be possible;
The third calculation means determines that there is a difference between the two amounts of data remaining after the reconciliation processing by the fourth calculation means, and that the difference is outside the preset error range. As a result, there are payment statement data and billing statement data that have been excluded from the reconciliation processing, and the payment amount of 1 of the billing statement data that has been excluded from the reconciliation processing has also been excluded from the reconciliation processing. When it is larger than the deposit amount of the detailed statement data or the total amount thereof, the charge amount of the billing detailed statement data is divided into a portion corresponding to (the deposit amount or the total amount of the above-mentioned deposit detail data) and a remaining amount, Fifth computing means for giving an instruction to perform the clearing process of both detail data by the fourth computing means for the same amount of both detail data,
Control means for temporarily creating payment details data of a discount amount corresponding to the remaining amount of the billing details data, attaching a discount account to it, and forcibly applying a clearing process. Characteristic credit clearing processor. If the remaining amount of the billing statement data that has been subjected to the division process is larger than the amount of the other remaining receipt details data or a plurality of total amounts, the fifth calculation is performed on the remaining amount of money. By the means, the above-described split processing of the amount and the reconciliation processing of both the detail data are repeated, and the remaining amount of the billing detail data is smaller than the amount of the other remaining receipt details data or the total amount of a plurality of the remaining details. When this happens, the above-mentioned control means temporarily creates the payment details data of the discount amount corresponding to the remaining amount of the billing details data, assigns a discount account to it, and forcibly applies it. 100. The claim clearing apparatus according to claim 99, wherein processing is performed. When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, If there is a difference in the amount and it is determined that the difference is out of the preset error range, and there are payment statement data and billing statement data that have been excluded from the reconciliation process, the larger amount The calculation means divides the amount of one detailed data into an amount equivalent to (an amount of one of the other detailed data or a plurality thereof) and a remaining amount. Per the same amount worth of over data, with processing scrub both detailed data is performed,
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. Or a process executed by the data storage means to be excluded from the object of the erasing process. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
101. The computer program according to claim 101, wherein the calculation means adds an account of the advance payment to the remaining money amount, and the remaining money amount is left in the data storage means as a processing target of the payment detail data. . In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
102. The computer program according to claim 101, wherein the calculation means assigns an account for provisional payment and forcibly applies the remaining amount to the remaining amount. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
102. The computer program according to claim 101, wherein an account other than the accounts receivable is added to the remaining amount by the calculating means, and is excluded from the reconciliation processing in the data storage means. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
101. The computer according to claim 101, wherein the calculation means adds an account item corresponding to the remaining amount of the remaining amount, and the remaining account amount is left in the data storage unit as an object of the reconciliation processing of the invoice detail data. ·program. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
102. The computer program according to claim 101, wherein the calculation means assigns an account of accounts receivable to the remaining amount and performs a forced reconciliation process. If the remaining amount of the detailed data subjected to the division processing is larger than the amount of the other remaining detailed data or a plurality of total amounts, the operating unit further increases the amount of the remaining amount by the calculating means. When the above-mentioned division process and the reconciliation process of both detailed data are repeated, and the remaining amount becomes smaller than the amount of the other remaining detailed data or a plurality of total amounts, the remaining amount is reduced. The calculation means assigns a specific account and is left in the data storage means as a processing object of payment statement data or billing statement data. Forcible reconciliation processing is performed. 107. The computer program according to any one of claims 101 to 106, wherein the computer program is excluded from the object of the erasing process. When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, If there is a difference in the amount and it is determined that the difference is outside the preset error range, there are payment statement data and billing statement data that are excluded from the reconciliation processing, and the reconciliation processing is not performed. In the case where the billing amount of the billing detail data 1 becomes larger than the deposit amount or the total amount of the payment detail data also excluded from the reconciliation processing, the calculating means The billing amount of the billing statement data is divided into an amount corresponding to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and for the same amount of both statement data, As the reconciliation process is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process. Features and computer programs. If the remaining amount of the billing statement data that has been subjected to the splitting process is larger than the amount of the other remaining receipt statement data or a plurality of total amounts, the remaining amount is calculated by the calculating means. Further, the above-described splitting process of the amount and the reconciliation process of both the detail data are repeated, and when the remaining amount of the billing detail data becomes smaller than the amount of the other remaining receipt details data or the total amount of the plurality of the remaining receipt details data, By the above-mentioned arithmetic means, the payment details data of the discount amount corresponding to the remaining amount of the billing details data is temporarily created, a discount account is attached thereto, and the forcible clearing process is performed. 110. The computer program according to claim 108, wherein: When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, It is determined that the amounts match or the difference between the two amounts is within a preset error range, and within that range, the target payment statement data and billing statement data are processed for reconciliation,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. When there is received receipt statement data and billing statement data, the amount of one statement data, which is the larger amount, is calculated by the above-mentioned calculating means into an amount equivalent to (the amount of one statement of the other statement data or a plurality thereof). , And the remaining amount is divided. For the same amount of the two items of data, the reconciliation process of both items of data is performed.
Further, for the remaining amount, a specific account is given by the calculating means, and a forced reconciliation process is performed in the data storage means, which is left as a reconciliation target of the payment details data or the billing details data. A computer program for executing a process which is performed by the data storage means or excluded from the object of the erasure process. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
112. The computer program according to claim 110, wherein the calculation means adds an account of the advance payment to the remaining money amount, and the remaining money amount is left in the data storage means as a processing target of the payment detail data. . In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
112. The computer program according to claim 110, wherein said calculation means assigns an account for provisional deposit and forcibly applies the remaining amount to the remaining amount. In the case where the deposit amount of 1 of the payment statement data which has been excluded from the reconciliation processing is also larger than the billing amount of the billing statement data which has also been excluded from the reconciliation processing or the total amount thereof, the calculation means Is divided into an amount equivalent to (the billing amount of the billing statement data or the total amount thereof) and a remaining billing amount, and the reconciliation processing of both statement data is performed for the same amount of both billing data. As well as
112. The computer program according to claim 110, wherein an account item other than accounts receivable is added to the remaining amount by the calculating means, and is excluded from the reconciliation processing object in the data storage means. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
112. The computer according to claim 110, wherein the calculation means adds an account item corresponding to the remaining amount of the remaining amount, and the remaining account amount is left in the data storage unit as an object of the reconciliation processing of the invoice detail data. ·program. When the billing amount of one of the billing detail data which has been excluded from the reconciliation processing is larger than the deposit amount or the total amount of the payment detail data which has also been excluded from the reconciliation processing, the calculating means performs Is divided into an amount equivalent to (the deposit amount of the above-mentioned payment detail data or the total amount thereof) and a remaining amount, and the reconciliation processing of both the detail data is performed for the same amount of both the detail data. As well as
112. The computer program according to claim 110, wherein said calculation means assigns an account of accounts receivable for the remaining amount and performs a forced reconciliation process. If the remaining amount of the detailed data subjected to the division processing is larger than the amount of the other remaining detailed data or a plurality of total amounts, the operating unit further increases the amount of the remaining amount by the calculating means. When the above-mentioned division process and the reconciliation process of both detailed data are repeated, and the remaining amount becomes smaller than the amount of the other remaining detailed data or a plurality of total amounts, the remaining amount is reduced. The calculation means assigns a specific account and is left in the data storage means as a processing object of payment statement data or billing statement data. Forcible reconciliation processing is performed. A computer program according to any one of claims 110 to 115, wherein the computer program is excluded from the object of the erasure processing by means. When executed by the computer having the data storage means and the arithmetic means, the deposit amount or the total amount of the payment details data to be applied to be stored stored in the data storage means and the latest payment date of the target payment details data When the billing amount or the total amount of the billing specification data to be applied for reconciliation also stored in the data storage unit having a billing date of a specific earlier period is compared with the billing amount by the computing unit, It is determined that the amounts match or the difference between the two amounts is within a preset error range, and within that range, the target payment statement data and billing statement data are processed for reconciliation,
There is a difference between the two detailed data remaining after the reconciliation processing, and the difference is out of the preset error range. Payment data and billing statement data, and the charge amount of one of the billing statement data that was excluded from the reconciliation processing is equal to the sum or the total amount of the payment statement data that was also excluded from the reconciliation processing. If it is larger, the calculating means divides the billing amount of the billing statement data into an amount equivalent to (the deposit amount of the deposit statement data or the total amount thereof) and a remaining amount, and For each amount, the reconciliation process of both detail data is performed,
Further, the calculation means temporarily creates payment details data of a discount amount corresponding to the remaining amount of the billing details data, applies a discount account to the data, and performs a forcible clearing process. A computer program characterized by the above-mentioned. If the remaining amount of the billing statement data that has been subjected to the splitting process is larger than the amount of the other remaining receipt statement data or a plurality of total amounts, the remaining amount is calculated by the calculating means. Further, the above-described splitting process of the amount and the reconciliation process of both the detail data are repeated, and when the remaining amount of the billing detail data becomes smaller than the amount of the other remaining receipt details data or the total amount of the plurality of the remaining receipt details data, By the above-mentioned arithmetic means, the payment details data of the discount amount corresponding to the remaining amount of the billing details data is temporarily created, a discount account is attached thereto, and the forcible clearing process is performed. 118. The computer program according to claim 117, wherein: A computer-readable recording medium storing the computer program according to any one of claims 101 to 118.

Images