The present invention relates to a credit and debit log analysis device, a credit and debit log analysis method, and a credit and debit log analysis program, by which a premonition useful for grasping a situation of a customer can be obtained through a credit and debit log analysis.
PTL 1 discloses a technique, by which bankruptcy probability of a company is calculated using past records, such as account receivable balance, annual trading volume, and mortgage appraisal value, and credit management information including corporate financial data. Further, the technique described in PTL 1 conducts a go/no-go judgment for a transaction according to a predetermined criterion by taking the calculated bankruptcy probability and a profit into consideration.
PTL 2 discloses a technique, by which a final rating value is calculated by administering quantitative information calculated based on financial data and past bankruptcy cases, and corrective information inputted manually by a person in charge of loan, and weighting the two at a predetermined ratio, so as to carry out credit rating on a company accurately.
PTL 1: Japanese Unexamined Patent Application Publication No. 2005-258802
PTL 2: Japanese Unexamined Patent Application Publication No. 2005-134938
Since the financial data, based on which bankruptcy probability or a rating value used in PTL 1 or PTL 2 is calculated, are macroscopic data, a minute premonition, which may occur in an individual transaction, cannot be grasped. Further, since according to PTL 1 or PTL 2 a qualitative evaluation depending on a subjective opinion of a person in charge is utilized, the evaluation is dependent on the person in charge. Furthermore, there is also a drawback that an evaluation cannot be performed according to PTL 1 or PTL 2, if a person in charge is absent.
Under such circumstances, an object of the present invention is to provide a credit and debit log analysis device, a credit and debit log analysis method, and a credit and debit log analysis program, by which an analysis in minute units not attainable with macroscopic indices can be carried out objectively.
A credit and debit log analysis device according to the present invention includes a credit and debit log storage unit, which stores a history of credit to an account of a customer to be an analysis object and debit to the account as a credit and debit log, a calendar that stores information on a date, a trend discovering unit that discovers a trend of credit and debit based on the credit and debit log and the calendar, a trend storage unit that stores the trend, a matching rule generating unit that generates a matching rule based on the trend so as to detect credit and debit data contravening the trend, a matching rule storage unit that stores the matching rule, a matching unit that detects a premonition by comparing the credit and debit data and the matching rule, a premonition storage unit that stores the premonition, and a presentation unit that presents the premonition to a user.
A credit and debit log analysis method according to the present invention includes storing a history of credit to an account of a customer to be an analysis object and debit to the account as a credit and debit log, storing information on a date in a calendar, discovering a trend of credit and debit based on the credit and debit log and the calendar, string the trend, generating a matching rule based on the trend so as to detect credit and debit data contravening the trend, storing the matching rule, detecting a premonition by comparing the credit and debit data and the matching rule, storing the premonition, and presenting the premonition to a user.
A credit and debit log analysis program according to the present invention causes a computer to execute a credit and debit log storage processing for storing a history of credit to an account of a customer to be an analysis object and debit to the account as a credit and debit log, a processing for storing information on a date in a calendar, a trend discovery processing for discovering a trend of credit and debit based on the credit and debit log and the calendar, a trend storage processing for storing the trend, a matching rule generation processing for generating a matching rule based on the trend so as to detect credit and debit data contravening the trend, a matching rule storage processing for storing the matching rule, a matching processing for detecting a premonition by comparing the credit and debit data and the matching rule, a premonition storage processing for storing the premonition, and a presentation processing for presenting the premonition to a user.
According to the present invention, an analysis in minute units not attainable with macroscopic indices can be carried out objectively.
Exemplary embodiments of the present invention will be described in detail below referring to drawings.
The credit and debit log storage unit 11 stores a history of credit to an account of a customer to be an analysis object (e.g. a company or an individual) and a payment from the account. The trend discovering unit 12 discovers a trend in the credit and debit, such as regularly occurring credit and debit, referring to the credit and debit log stored in the credit and debit log storage unit 11 and the information concerning a date stored in the calendar 15. The trend storage unit 13 stores the trend of the credit and debit discovered by the trend discovering unit 12. The matching rule generating unit 14 generates a matching rule based on the trend of the credit and debit so as to detect credit and debit data contravening the trend.
The calendar 15 stores information concerning date (e.g. in the order of year, month, and day). The matching rule storage unit 16 stores a matching rule generated by the matching rule generating unit 14. The matching unit 17 compares each of the credit and debit data stored in the credit and debit log storage unit 11 with the matching rule stored in the matching rule storage unit 16. In the event there is a credit and debit datum contravening the matching rule, the matching unit 17 stores the same as a premonition showing company deterioration, etc. in the premonition storage unit 18.
The premonition storage unit 18 stores a premonition detected by the matching unit 17. The presentation unit 19 presents to a user the credit and debit log stored in the credit and debit log storage unit 11, the trend stored in the trend storage unit 13, the matching rule stored in the matching rule storage unit 16, and the premonition stored in the premonition storage unit 18. The presentation unit 19 does not necessarily present all of the above, but may present, for example, only the premonition.
Next, actions of a credit and debit log analysis device of the present exemplary embodiment will be described.
The trend discovering unit 12 extracts a credit and debit log to be used for discovering a trend from the credit and debit log storage unit 11 (step S1). Then, the trend discovering unit 12 discovers a trend on the basis of the extracted credit and debit log and the date information in the calendar 15 (step S2). Then, the trend discovering unit 12 stores the discovered trend in the trend storage unit 13 (step S3).
Next, the matching rule generating unit 14 generates a matching rule on the basis of the discovered trend and a date in the calendar 15 (step S4). Then, the matching rule generating unit 14 stores (saves) the matching rule in the matching rule storage unit 16 (step S5).
Operations of an example of a credit and debit log analysis device of the present exemplary embodiment will be described below.
In order to discover a trend from the credit and debit log, the trend discovering unit 12 counts for example the number of combinations of the respective data in the credit and debit log, and a trend is discovered if there is the same combination occurring not less than a predefined number of times. For example, in the case of the example shown in
In discovering a trend, the trend discovering unit 12 may take the likelihood of the trend into consideration. For example, comparing a case in which a credit is earned on the 10th day of each month over 12 months, and a case in which a credit is earned on the 10th day in 9 months out of 12 months, the former case exhibits higher likelihood. Further, even in the latter case, the likelihood is different, if the remaining 3 credits are absent at all, or made on different days. For the trend discovering unit 12, a frequency of credit and debit data per certain period that correspond to a trend, or a frequency of exceptions may be decided in advance, and a trend which satisfies the condition may be only extracted.
The data shown in the third row in
The data shown in the fourth row in
The data shown in the fifth row in
In this regard, the trend discovering unit 12 may adopt an on-line processing, by which upon entry of a new piece of data in the credit and debit log, the same is compared, or adopt a batch-wise processing, by which all the data entered during a certain period are compared collectively. In the case of a batch-wise processing, the trend discovering unit 12 conducts a comparison at one time, for example, when the credit and debit logs for a whole day have been collected. Further, the trend discovering unit 12 may conduct an on-demand processing, by which it initiates a comparison upon receipt of a demand from a user or an external system. The matching unit 17 may adopt similarly as the trend discovering unit 12 any of an on-line processing, a batch-wise processing, and an on-demand processing.
Since, as described above, the credit and debit log analysis device according to the present exemplary embodiment analyzes directly primary data of the credit and debit log, an analysis in minute units, which cannot be grasped from macroscopic indices, becomes possible. Furthermore, since the credit and debit log analysis device according to the present exemplary embodiment conducts an analysis by a computer based on objective criteria, there is no room for a subjective opinion of a person in charge, and an analysis of a customer is possible in the absence of a person in charge.
Since the credit and debit log analysis device according to the present exemplary embodiment conducts an analysis not manually but by a computer, the cost can be reduced. Furthermore, since the credit and debit log analysis device according to the present exemplary embodiment uses objective criteria generated from past credit and debit logs, the criteria are not biased by personal preconceptions and an overlook of a premonition can be prevented. Further, since the credit and debit log analysis device according to the present exemplary embodiment can store an analysis result electronically, the analysis result can be easily reused.
Further, with the credit and debit log analysis device according to the present exemplary embodiment, the time and labor required for detecting an irregular transaction deviating from regular and ordinary transactions among credit and debit transactions of a customer, especially at a financial institution, can be curtailed. Further, with the credit and debit log analysis device according to the present exemplary embodiment, the detected irregular transactions can be collected, shared, and reused among interested persons. Meanwhile, since the credit and debit log analysis device according to the present exemplary embodiment can contribute to grasp a premonition of company deterioration, for example, by a financial institution, an early stage protective measure can be employed by grasping at an early stage a premonition of company deterioration.
According to the present exemplary embodiment, it is possible to determine whether premonitions of the same Class have been detected a predetermined number of times successively. For example, in a case where the matching unit 17 stores a premonition lacking for a credit as the data shown in the second row of
The credit and debit log analysis device according to the present exemplary embodiment can detect if the intervals between credits increase gradually. For example, if the matching unit 17 stores a premonition that the result is later than a scheduled date for a credit as the data shown in the third row of
Further, the credit and debit log analysis device according to the present exemplary embodiment can detect also, for example, if the credit amount decreases gradually, or conversely increases gradually. In the event the matching unit 17 detects a premonition that a credit amount is less than a scheduled amount as shown in the fifth row of
Further, the credit and debit log analysis device according to the present exemplary embodiment can also detect a monthly credit of a substantially same amount or an amount in a round number from a customer, with whom dealing has started newly since a certain month. Since such a transaction may possibly be a bogus transaction, it may be deemed as a premonition to be detected.
Further, the credit and debit log analysis device according to the present exemplary embodiment can detect that payments performed to a certain customer by a certain means until a certain month have been changed to another means since the certain month. For example, a fact that the payment performed initially by a transfer was changed to a payment by a bill payable from a certain time point suggests a tighter cash-flow, which may be a premonition to be detected. In order to make such detection possible, it is necessary for the credit and debit log storage unit 11, the trend storage unit 13, the matching rule storage unit 16, and the premonition storage unit 18 to store information on a payment means, and specifically they should be provided with a column with respect to a payment means.
Further, the credit and debit log analysis device according to the present exemplary embodiment can collect monthly changes in transaction amounts with a certain customer or the total transaction amounts with the entire customers for several years, and detect if the change exceeds a certain value. For example, a case, where transaction amounts with a customer have been about 1 hundred million yen/month in January, February, and March respectively in the recent years, and transaction amounts have been about 1 billion yen/month in April, May, and June respectively in the recent years, is assumed. In such a case, the credit and debit log analysis device according to the present exemplary embodiment may take it for normal that the transaction amount increases suddenly in April, but for abnormal that the same increases suddenly in February. According to the present exemplary embodiment, the totalizing period may be not only a month but may be a day, a week, or the like.
Further, in the credit and debit log analysis device according to the present exemplary embodiment the matching unit 17 can evaluate the condition of a customer to be an analysis object based on a plurality of premonitions stored in the premonition storage unit 18. For example, when the monthly number of premonitions increases gradually, the credit and debit log analysis device according to the present exemplary embodiment can decide that the condition of a customer to be an analysis object has been deteriorating. Further, when the number of premonitions increases suddenly in a certain month, the credit and debit log analysis device according to the present exemplary embodiment will evaluate that the business performance has been rapidly deteriorated. The matching unit 17 stores also the evaluation result in the premonition storage unit 18. The matching unit 17 can achieve such an evaluation, for example, by labelling premonitions on which the evaluation is based. Further, the credit and debit log analysis device according to the present exemplary embodiment can detect a change in the number of specific credits and debits per month. For example, in the case of a corporation and if the corporate tax is paid twice in a month, it is possible that an overdue tax or a surcharge was demanded.
In the credit and debit log analysis device according to the present exemplary embodiment the matching unit 17 detects a premonition by obtaining data of an external database through the external DB interface 151 and combining the same with the data in the premonition storage unit 18. The data in the external database (external data) are data other than a credit and a debit of a company of an analysis object. For example, the matching unit 17 can detect a payment in an amount equal to or more than 30% of the annual sales volume by obtaining external data showing the company size, such as the capital size and the annual sales volume, from an external database. If such a detection is made, it is possible that a bogus transaction has been undertaken.
Further, the credit and debit log analysis device according to the present exemplary embodiment can detect an abnormal payment of a tax, for example, by obtaining account settlement data from an external database. For example, in the event that a company in deficit pays a corporate tax, or that a company does not pay a corporate tax even 5 years after return into profit from deficit, the event is abnormal and detected as a premonition.
With the credit and debit log analysis device according to the present exemplary embodiment, a preventive effect against overlook and negligence in notification of a premonition can be improved by utilizing data of an external database.
The credit and debit log analysis device according to the present exemplary embodiment can perform discovery of a trend, generation of a matching rule, and comparison, considering a non-business day. For example, in a case where it is assumed that the business day administration unit 111 maintains a rule, by which, if a scheduled date for crediting is a holiday, crediting will possibly occur on the next business day. In such a case, if June 10 is a Sunday or a holiday and a credit and a debit are not entered, the credit and debit log analysis device according to the present exemplary embodiment interprets a credit entered on June 11 as a credit on June 10. Meanwhile, for example, in a case where it is assumed that the business day administration unit 111 maintains a rule, by which, if a scheduled date for crediting is a holiday, crediting will possibly occur on the previous business day. In such a case, if June 10 is a Saturday and a credit and a debit are not entered, the credit and debit log analysis device according to the present exemplary embodiment interprets a credit entered on June 9 as a credit on June 10.
The credit and debit log analysis device shown in
The credit and debit log analysis device shown in
Further, when a user specifies a premonition, the presentation unit 19 may display a past premonition, which was detected based on the same matching rule by which the specified premonition was detected.
When a user specifies a matching rule, the presentation unit 19 may display a past premonition, which was detected by the same matching rule. Alternatively, as soon as the matching unit 17 detects a premonition, the presentation unit 19 may display the premonition. The presentation unit 19 does not ordinarily display a premonition, and may display a premonition only when an instructed is made by a user. Further, the presentation unit 19 may have a user search a past premonition, and display the result. The presentation unit 19 may display the change in the number of detected premonitions as a table or a graph.
The presentation unit 19 may allow a user to input a judgment whether a premonition is useful or not, and display selectively a premonition, for which a positive judgment has been inputted. Further, it is conceivable that the presentation unit 19 is so configured as to cumulate or classify only useful premonitions. In this regard, a useful premonition means, for example, in the case of a company, a premonition related to company deterioration.
The presentation unit 19 may transmit a premonition only to the terminal 131 of interested persons defined for each condition of a premonition, such as a transaction partner and an amount. Further, the presentation unit 19 may inform publicly by a warning light that there is a noteworthy presenting content, when a predetermined condition, such as an amount and a transaction partner, is met.
The presentation unit 19 may be configured such that a premonition, a matching rule, a trend, and a credit and debit log once displayed can be searched and displayed later. An example of the presentation unit 19 shown in
Since the credit and debit log analysis device shown in
In the aforedescribed exemplary embodiments, the credit and debit log analysis devices referred to in the following (1) to (8) and (Supplementary Note 1) to (Supplementary Note 15) are also disclosed.
(1) A credit and debit log analysis device is provided with the following:
a credit and debit log storage unit, which stores a history of credit to an account of a customer to be an analysis object and debit to the account as a credit and debit log (e.g. credit and debit log storage unit 11),
a calendar, which stores information on a date (e.g. calendar 15),
a trend discovering unit, which discovers a trend of credit and debit based on the credit and debit log and the calendar (e.g. trend discovering unit 12),
a trend storage unit, which stores the trend (e.g. trend storage unit 13),
a matching rule generating unit, which generates a matching rule based on the trend so as to detect credit and debit data contravening the trend (e.g. matching rule generating unit 14),
a matching rule storage unit, which stores the matching rule (e.g. matching rule storage unit 16),
a matching unit, which detects a premonition by comparing the credit and debit data and the matching rule (e.g. matching unit 17),
a premonition storage unit, which stores the premonition (e.g. premonition storage unit 18), and
a presentation unit, which presents the premonition to a user (e.g. presentation unit 19).
(2) The credit and debit log analysis device may be configured such that the trend discovering unit discovers a trend that a credit or a debit occurs on a specific day, and the matching unit detects that a credit or a debit has not occurred on the specific day as a premonition.
(3) The credit and debit log analysis device may be configured such that the trend discovering unit discovers a trend that credit and debit occur in an amount within a specific range, and the matching unit detects that a credit or a debit has occurred in an amount beyond the specific range as a premonition.
(4) The credit and debit log analysis device may be configured such that the matching unit detects a new premonition using a premonition detected in the past.
(5) The credit and debit log analysis device is provided with an external data interface (e.g. external DB interface 151), which is connected with an external database. Meanwhile, the device may be also configured such that the matching unit inputs data concerning the customer of the analysis object other than the credit and debit data through the external database interface, and detects a new premonition by comparing a detected premonition with the data.
(6) The credit and debit log analysis device is provided with a business day administration unit (e.g. business day administration unit 111), which administers information concerning dates, on which a credit or a debit of the customer of the analysis object can be performed. Meanwhile, the device may be configured such that the calendar acquires the information from the business day administration unit, and the trend discovering unit, the matching rule generating unit, and the matching unit perform processing taking the information into consideration.
(7) The credit and debit log analysis device may be configured as follows:
Namely, the presentation unit displays premonitions extracted from the premonition storage unit, and in the event that a user designates a specific premonition, a matching rule, based on which the premonition was detected. The presentation unit may display: in the event that a user designates the matching rule, a trend, based on which the matching rule was generated; and in the event that a user designates the trend, a part of the credit and debit data, based on which the trend was discovered.
(8) The credit and debit log analysis device may be configured such that the presentation unit transmits a relevant premonition only to terminals of interested persons (e.g. terminal 131) defined in advance for each condition of a premonition.
The credit and debit log analysis device may be configured such that the trend discovering unit discovers a trend that a credit or a debit occurs on a specific day, and the matching unit detects that a credit or a debit scheduled on the specific day has occurred on another day as a premonition.
The credit and debit log analysis device may be configured such that the trend discovering unit discovers as a trend all customers, with whom a credit or a debit has been earned ever, and the matching unit detects as a premonition that a credit or a debit has occurred with a customer, with whom a credit and a debit have not been earned yet.
The credit and debit log analysis device may be configured such that the trend discovering unit discovers as a trend occurrence of a credit or a debit in a specific amount, when a specific condition is met, and that the matching unit detects as a premonition occurrence of a credit or a debit in an amount different from the specific amount, when a specific condition is met.
The credit and debit log analysis device may be configured such that the matching unit detects as a new premonition successive premonitions of the same Class appearing a predetermined number of times or more in premonitions having been detected in the past.
The credit and debit log analysis device may be configured such that the matching unit can detect as a new premonition gradual increase in intervals between credit dates with respect to premonitions having been detected in the past.
The credit and debit log analysis device may be configured such that the matching unit can detect as a new premonition gradual decrease in credit amounts, or gradual increase in credit amounts with respect to premonitions having been detected in the past.
The credit and debit log analysis device may be configured such that the credit and debit log storage unit stores a class of a payment means as a part of the credit and debit log, and that the matching unit detects change in the payment means with respect to the same customer from a certain time point as a premonition.
The credit and debit log analysis device may be configured as follows. Namely, the trend discovering unit discovers a trend of a monthly amount with respect to a transaction amount with a customer, or a total transaction amount of all customers. The matching unit may detect as a premonition a month in which there appears a difference equal to or more than a certain value between the monthly amount and the trend.
The credit and debit log analysis device may be configured such that the matching unit detects a fluctuation of the number of premonitions during a specific period taking a pace of the fluctuation into consideration as a new premonition.
The credit and debit log analysis device may be configured such that the trend unit discovers a credit or a debit earned not on a specific day but during every predetermined period as a trend taking the information administered by the business day administration unit into consideration.
The credit and debit log analysis device is provided with a log restriction unit (e.g. log restriction unit 121) for restricting a credit and debit log extracted from the credit and debit log storage unit, and may be configured such that the trend discovering unit discovers a trend of a credit and a debit based on the restricted credit and debit log and the calendar.
The credit and debit log analysis device may be configured such that, when a user designates a specific premonition, the presentation unit displays a past premonition, which was detected by the same matching rule based on which the designated premonition was detected.
The credit and debit log analysis device may be configured such that, when a user designates a specific matching rule, the presentation unit displays a past premonition, which was detected by the matching rule.
The credit and debit log analysis device may be configured such that the presentation unit receives a judgment of a user indicating whether a premonition is useful or not, and displays only the information judged as useful.
The credit and debit log analysis device may be configured such that the presentation unit transmits a presenting content to terminals owned by interested persons to display the presenting content on the terminals.
This application claims the benefit of priority base on Japanese Patent Application No. 2012-157703 filed on 13 Jul. 2012, the entire disclosures of which are hereby incorporated by reference.
Although the present invention has been described referring to exemplary embodiments and Examples, it is to be understood that the present invention is not limited by such exemplary embodiments and Examples. To the constitution or details of the present invention many alternations conceivable by those skilled in the art can be added within the spirit and scope of the present invention.
The present invention can be utilized by a bank for grasping deterioration of the business situation of a customer, or grasping the asset situation of an individual customer.
Number | Date | Country | Kind |
---|---|---|---|
2012-157703 | Jul 2012 | JP | national |
Filing Document | Filing Date | Country | Kind |
---|---|---|---|
PCT/JP2013/002590 | 4/17/2013 | WO | 00 |