A method and system for analyzing overdue customer bills for an enterprise

By collecting and storing multi-dimensional information of enterprise customers and updating overdue information using Scheduler scheduled program, the problems of high cost of manual overdue accounts and single information are solved, and multi-dimensional information statistics and strategic adjustments are achieved for large-data customers.

CN113902433BActive Publication Date: 2024-11-22BAIRONG ZHIXIN (BEIJING) TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202111166122.4
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-09-30
Publication Date
2024-11-22
Estimated Expiration
2041-09-30

AI Technical Summary

Technical Problem

In the prior art, manual statistics on overdue accounts of corporate customers consume a lot of labor and time costs when the number of customers is large, and the statistical content is limited to overdue debt information, which is difficult to adapt to the situation of large amount of customers and the single statistical information.

Method used

By collecting multi-dimensional label information and billing information of corporate customers, it is stored in the corporate customer model and billing model, and combining Scheduler timing program to update overdue corporate information in real time, providing automated processing to adapt to large data customers and count multi-dimensional corporate information.

Benefits of technology

It reduces manual operation costs, improves work efficiency, can adapt to large data customers and provides more comprehensive strategic direction adjustment information.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN113902433B_ABST
    Figure CN113902433B_ABST
Patent Text Reader

Abstract

The present invention provides a method and system for analyzing overdue customer bills for enterprises, the method comprising: collecting a basic information set of enterprise customer clusters, including a multi-dimensional tag information set and a bill information set of the enterprise customer clusters, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model; obtaining a basic bill information set of the enterprise customer cluster; obtaining a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster, offsetting the remaining prepayment amount information set with the arrears bill information set of each enterprise user, obtaining a first account age information set of each enterprise user, screening the first account age information set, and obtaining a first overdue customer information set; based on a Scheduler timing program, dynamically updating the first overdue customer information set. The technical problem that it is difficult to adapt to the situation of a large number of customers and the single statistical information in the prior art is solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field related to novel information technology services, and in particular to a method and system for analyzing overdue customer bills for an enterprise. Background Art

[0002] In the industrial ecological chain, there are often problems of overdue debts from downstream companies. The statistical calculation of overdue companies is important information for adjusting the company's strategic direction. The enterprise-level overdue customer calculation is applied to companies that have business dealings on the market. By counting customers with arrears, it provides a new direction for the company's strategic stage planning. The more dimensions used in statistics and the larger the amount of data, the more comprehensive the company's understanding of customers, so that it can better improve its business chain.

[0003] The existing overdue calculation is mainly done by relevant financial personnel who calculate the arrears from the business flow with customers and generate an Excel file for recording the arrears as the final output result. This method is limited to the record of overdue debts, and due to manpower limitations, the number of customers that can be managed is relatively small.

[0004] However, the inventors of this application found that the above technology has at least the following technical problems in the process of implementing the technical solution of the invention in the embodiment of this application:

[0005] In the prior art, manual statistics of overdue accounts of corporate customers consume a lot of manpower and time costs when the number of customers is large, and the statistical content is limited to overdue debt information, resulting in technical problems such as difficulty in adapting to situations with a large number of customers and single statistical information. Summary of the invention

[0006] The embodiment of the present application provides a method and system for analyzing overdue customer bills for enterprises, thereby solving the problem that the prior art manually counts overdue accounts of enterprise customers, which consumes a lot of labor and time costs when the number of customers is large, and the statistical content is limited to overdue debt information, resulting in technical problems that are difficult to adapt to situations with a large number of customers and single statistical information. By collecting the basic information of all enterprise customers, the basic information includes tag information describing enterprise information and enterprise billing information, and the tag information of the enterprise information is stored in the enterprise customer model; the billing information is stored in the billing model. The overdue information of the enterprise is calculated in the billing information, and the overdue bill enterprises are screened out in combination with the tag information of the enterprise information. The information of the overdue enterprises is updated in real time through the Scheduler timing program, thereby providing important information for the company's strategic direction adjustment. Based on automated processing, the technical effect of being applicable to customers with large amounts of data and being able to count multi-dimensional enterprise information is achieved.

[0007] In view of the above problems, the embodiments of the present application provide a method and system for analyzing overdue customer bills for an enterprise.

[0008] In a first aspect, an embodiment of the present application provides a method for analyzing overdue customer bills for an enterprise, wherein the method is applied to an enterprise customer model and a bill model, and the method includes: based on big data, collecting a basic information set of an enterprise customer cluster, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model; according to the basic information set, obtaining a basic bill information set of the enterprise customer cluster; according to the basic bill information set, obtaining a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster, and offsetting the remaining prepayment amount information set against the arrears bill information set of each enterprise user to generate a first offset bill information set for each enterprise user; calculating the time age of the first offset bill information set in sequence to generate a first account age information set for each enterprise user; filtering the first account age information set according to the multi-dimensional tag information set to obtain a first overdue customer information set; and dynamically updating the first overdue customer information set based on a Scheduler timing program.

[0009] On the other hand, an embodiment of the present application provides a customer bill overdue analysis system for an enterprise, wherein the system includes: a first acquisition unit, the first acquisition unit is used to collect a basic information set of an enterprise customer cluster based on big data, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model; a first acquisition unit, the first acquisition unit is used to obtain a basic bill information set of the enterprise customer cluster based on the basic information set; a second acquisition unit, the second acquisition unit is used to obtain a basic bill information set of the enterprise customer cluster based on the basic bill information set. A remaining prepayment amount information set of each corporate user in the group, and the remaining prepayment amount information set is offset against the arrears bill information set of each corporate user to generate a first offset bill information set for each corporate user; a first generating unit, the first generating unit is used to sequentially calculate the time age of the first offset bill information set to generate a first account age information set for each corporate user; a third obtaining unit, the third obtaining unit is used to filter the first account age information set according to the multi-dimensional tag information set to obtain a first overdue customer information set; a first updating unit, the first updating unit is used to dynamically update the first overdue customer information set based on a Scheduler timing program.

[0010] In a third aspect, an embodiment of the present application provides a customer bill overdue analysis system for an enterprise, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any one of the methods described in the first aspect when executing the program.

[0011] One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:

[0012] Due to the adoption of a method based on big data to collect a basic information set of an enterprise customer cluster, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model; according to the basic information set, a basic bill information set of the enterprise customer cluster is obtained; according to the basic bill information set, a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster is obtained, and the remaining prepayment amount information set is offset against the outstanding bill information set of each enterprise user to generate a first offset bill information set of each enterprise user; the time age of the first offset bill information set is calculated in sequence to generate a first account age information set of each enterprise user; according to the multi-dimensional tag information set, the first account age information set is screened to obtain a first overdue customer information set; based on the Scheduler timing program, a technical solution for dynamically updating the first overdue customer information set is provided, by collecting the basic information of all enterprise customers, the basic information includes tag information describing enterprise information and enterprise bill information, the tag information of the enterprise information is stored in the enterprise customer model; the bill information is stored in the bill model. The overdue information of enterprises is calculated from the billing information, and the overdue enterprises are screened out based on the tag information of the enterprise information. The information of overdue enterprises is updated in real time through the Scheduler timing program, thereby providing important information for the company's strategic direction adjustment. Based on automated processing, it achieves the technical effect of being suitable for customers with large amounts of data and being able to count multi-dimensional enterprise information.

[0013] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] Figure 1 A schematic diagram of a method for analyzing overdue customer bills for an enterprise is provided for an embodiment of the present application;

[0015] Figure 2 A schematic flow chart of a method for analyzing overdue customer bill information combined with multi-dimensional customer information for an enterprise is provided for an embodiment of the present application;

[0016] Figure 3 A schematic diagram of the structure of a customer bill overdue analysis system for an enterprise is provided for the embodiment of the present application;

[0017] Figure 4 It is a schematic diagram of the structure of an exemplary electronic device according to an embodiment of the present application.

[0018] Explanation of the reference numerals: first acquisition unit 11 , first obtaining unit 12 , second obtaining unit 13 , first generation unit 14 , third obtaining unit 15 , first update unit 16 , electronic device 300 , memory 301 , processor 302 , communication interface 303 , bus architecture 304 . DETAILED DESCRIPTION

[0019] The embodiment of the present application provides a method and system for analyzing overdue customer bills for enterprises, thereby solving the problem that the prior art manually counts overdue accounts of enterprise customers, which consumes a lot of labor and time costs when the number of customers is large, and the statistical content is limited to overdue debt information, resulting in technical problems that are difficult to adapt to situations with a large number of customers and single statistical information. By collecting the basic information of all enterprise customers, the basic information includes tag information describing enterprise information and enterprise billing information, and the tag information of the enterprise information is stored in the enterprise customer model; the billing information is stored in the billing model. The overdue information of the enterprise is calculated in the billing information, and the overdue bill enterprises are screened out in combination with the tag information of the enterprise information. The information of the overdue enterprises is updated in real time through the Scheduler timing program, thereby providing important information for the company's strategic direction adjustment. Based on automated processing, the technical effect of being applicable to customers with large amounts of data and being able to count multi-dimensional enterprise information is achieved.

[0020] Application Overview

[0021] In the industrial ecological chain, there are often problems of overdue debts faced by downstream enterprises. The statistical calculation of information on overdue enterprises is important information for adjusting the company's strategic direction. The enterprise-level overdue customer calculation is applied to enterprises with business dealings on the market. By counting customers with arrears, a new direction is provided for the strategic stage planning of the enterprise. The more dimensions used in statistics and the larger the amount of data, the more comprehensive the understanding of the enterprise will be, so that it can better improve its business chain. The existing overdue calculation is mainly calculated by relevant financial personnel from the flow of business dealings with customers, and an Excel file used to record the arrears is generated as the final output result. This method is limited to the record of overdue arrears, and due to the limitation of manpower, the number of customers that can be managed is relatively small. However, in the prior art, due to the manual statistics of overdue accounts of enterprise customers, a lot of labor and time costs will be consumed when the number of customers is large, and the statistical content is limited to overdue arrears information, resulting in the technical problems of being difficult to adapt to the situation of a large number of customers and single statistical information.

[0022] In response to the above technical problems, the overall idea of ​​the technical solution provided by this application is as follows:

[0023] The embodiment of the present application provides a method for analyzing overdue customer bills for an enterprise, wherein the method is applied to an enterprise customer model and a bill model, and the method includes: based on big data, collecting a basic information set of an enterprise customer cluster, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model; according to the basic information set, obtaining a basic bill information set of the enterprise customer cluster; according to the basic bill information set, obtaining a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster, and offsetting the remaining prepayment amount information set against the arrears bill information set of each enterprise user to generate a first offset bill information set of each enterprise user; calculating the time age of the first offset bill information set in sequence to generate a first account age information set of each enterprise user; filtering the first account age information set according to the multi-dimensional tag information set to obtain a first overdue customer information set; and dynamically updating the first overdue customer information set based on a Scheduler timing program.

[0024] After introducing the basic principles of the present application, various non-limiting implementation methods of the present application will be specifically described below in conjunction with the drawings in the specification.

[0025] Embodiment 1

[0026] like Figure 1As shown, an embodiment of the present application provides a method for analyzing overdue customer bills for an enterprise, wherein the method is applied to an enterprise customer model and a bill model, and the method includes:

[0027] S100: Based on big data, a basic information set of an enterprise customer cluster is collected, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model;

[0028] Specifically, the enterprise customer cluster is a downstream enterprise customer group of the enterprise that uses the customer bill overdue analysis system of the enterprise; the basic information is basic information describing the enterprise customer cluster:

[0029] The first aspect includes the multi-dimensional label information set, which is used to describe the basic information of corporate customers from multiple aspects: exemplary: customer type, for example, banks, non-banks, insurance companies, downstream manufacturers, etc.; customer cluster classification, for example, bank T1, bank T2, bank T3, bank T4, leading Internet finance institutions, trusts, insurance, licensed consumer finance, licensed auto finance and other types of enterprises; business areas, for example, insurance, North China Bank, North China Non-Bank, South China Bank, South China South Bank, East China Bank, East China Non-Bank, West China Bank, West China Non-Bank, Central China Bank, Central China Non-Bank, Inclusive Finance Department, Internet North China, Internet South China, Internet East China, Internet West China, Internet Central China and other regions; other information such as full name, abbreviation, province, city, address, regional id, customer source, customer priority, main business type, institution type, customer product type, customer business status and other types. Furthermore, it also includes verification result label information of whether the above information is valid information, identification information of the creation time of the above information, and identification information of the preset update time. Furthermore, the above multi-dimensional label information is stored in the enterprise customer model to facilitate quick retrieval and distinction from other information. By comprehensively describing and recording the enterprise customer cluster and updating it in real time, it is possible to have a general understanding of the operating status, general strategic direction, etc. of the enterprise customer cluster, and provide more accurate support information for the strategic operation of the enterprise.

[0030] On the other hand, it includes the bill information set, which is used to describe the account transaction information between corporate customers and enterprises: exemplary: including but not limited to basic bills, change bills, invoicing bills, prepaid bills and other labels, and each bill has the date or month identification information of the bill. Furthermore, it also includes verification result label information of whether the above information is valid information, identification information of the creation time of the above information, and identification information of the preset update time. Furthermore, the above multi-dimensional label information is stored in the bill model for quick call and distinction from other information. The bill information set is used to represent the information such as overdue payments and overdue repayments of the corporate customer cluster in real time, and corporate customers with overdue accounts can be quickly screened, and then the bill record statistics are completed. Combined with the operating status of the corporate customer cluster, the general strategic direction and other information, more accurate information is provided for the strategic operation of the enterprise.

[0031] S200: Obtaining a basic billing information set of the enterprise customer cluster according to the basic information set;

[0032] S300: Obtaining a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster according to the basic bill information set, and offsetting the outstanding bill information set of each enterprise user with the remaining prepayment amount information set to generate a first offset bill information set of each enterprise user;

[0033] Specifically, the basic bill information set is to extract the basic bill information in the bill information set, including but not limited to all outstanding bills of corporate customers before the statistical time node, such as: bill information of unpaid or partially paid bills, remaining prepaid amount information of corresponding corporate customers with outstanding bills, etc., wherein the prepaid amount is the prepaid amount paid in advance by the customer; further, all outstanding bills of corporate customers before the statistical time node are identified as the outstanding bill information set of each corporate user; the remaining prepaid amount information of the corresponding corporate customers with outstanding bills is identified as the remaining prepaid amount information set; further, using:

[0034] The first offset bill information = the outstanding bill information of the enterprise user - the remaining prepayment amount information of the corresponding enterprise customer.

[0035] The first offsetting bill information set obtained by calculation represents the actual overdue amount data of all corporate customers with overdue accounts, and the first offsetting bill information is used as the label information of the corresponding overdue corporate customers for identification and storage, so as to facilitate the rapid retrieval of overdue corporate customer information. Further, the bill date or month identification information corresponding to the arrears bill information set of the corporate users in the bill information set is extracted to obtain the bill date of each arrears bill, and the information set of the arrears date is obtained by using the statistical date bill-preset repayment date, and the arrears dates are arranged in order from long to short, and the remaining prepayment amount information of the corporate customers is used to offset the arrears bill information of the corporate users in order from long to short based on the sorting result of the arrears dates, and the remaining unoffset bill information is used as the actual overdue information of the corporate customers for identification, so as to facilitate the subsequent information feedback processing.

[0036] S400: Calculating the time age of the first offset bill information set in sequence to generate a first account age information set of each enterprise user;

[0037] Specifically, the bill date or month identification information corresponding to the arrears bill information set of the enterprise user in the bill information set is extracted to obtain the bill date of each arrears bill, and the bill date includes information such as the bill creation date and the preset repayment date; the first account age information set is the account age information of the bill corresponding to the first offset bill information of the enterprise user who still has an overdue account after offset, and the determination method is given by an example without limitation: the bill creation time information is calculated by counting the date bill-the bill creation date, and the overdue time information of the bill is calculated by counting the date bill-the preset repayment date, and the bill creation time information and the bill overdue time information are used as the label information corresponding to the overdue enterprise customer of the account to identify the first account age information of the enterprise user, and all overdue enterprise customers are identified using the same method to obtain the first account age information set of each enterprise user. By determining the overdue bill age information of the enterprise customer, it can assist the enterprise in analyzing the collection status and arrears status of the enterprise customer over time, and then adjust the information such as customer priority, and plan the development strategy of the enterprise.

[0038] S500: Filtering the first account age information set according to the multi-dimensional tag information set to obtain a first overdue customer information set;

[0039] Specifically, the first overdue customer information set is to analyze the first aging information set corresponding to the corporate customer information set in combination with the basic information in the multi-dimensional tag information set to determine the actual overdue customer combination, and the determination method is given as an example without limitation: extracting the account, payment cycle and other basic information in the multi-dimensional tag information set, example case 1: the first aging information shows that the corresponding corporate customer bill is overdue, but the account information of the corporate customer shows that the payment has been recovered, then it is placed in the pending overdue customer range, and the subsequent manual query system statistics are carried out, and the two consult the bank account transfer situation before determining; example case 2: the first aging information shows that the corresponding corporate customer bill is overdue, but in fact the payment cycle of the corporate customer has a certain lag, then it is placed in the pending overdue customer range, and it is necessary to wait until the payment cycle ends before determining whether it is an overdue customer. By screening the corporate customers corresponding to the first aging information set in combination with the multi-dimensional tag information set, the actual overdue customers are flexibly determined, and more accurate overdue account information is provided.

[0040] S600: Based on the Scheduler timing program, dynamically update the first overdue customer information set.

[0041] Specifically, the Scheduler timing program is a plug-in tool for scheduling scheduled tasks. By inserting the Scheduler timing program, the account change information of the corporate customer, including repayment, recharge, and consumption, is stored, and the first overdue customer information set is updated in real time. When the overdue balance corresponding to the first offset bill information of the first overdue customer is recovered and offset by recharge, the overdue mark of the corresponding first overdue customer is cancelled; when the consumption information of the first overdue customer is overdue again, the overdue consumption amount is added to the first offset bill information, and the total overdue amount of the first overdue customer is updated. The Scheduler timing program can dynamically update the account change information of the first overdue customer information, the consumption information corresponding to the invoicing, etc., which reduces a large number of manual modification operations, reduces costs, and improves work efficiency. It should be stated that although the Scheduler timing program is used as a plug-in for real-time task update here, it does not limit other conventional tools that can achieve the same function. For example, there are several unrestricted methods such as message queues or asynchronous calls.

[0042] Further, based on obtaining the remaining prepayment amount information set of each enterprise user in the enterprise customer cluster, step S300 further includes:

[0043] S310: Obtaining a total prepayment information set of each enterprise user according to the basic bill information set;

[0044] S320: Obtaining total consumption amount information and total refund amount information of each enterprise user according to the total prepayment information set;

[0045] S330: Obtain detailed account flow information of each enterprise user within a predetermined time according to the basic bill information set, wherein the detailed account flow information includes the total amount of manual adjustment and the total amount of processed bad debts;

[0046] S340: Obtaining the initial customer balance set of each enterprise user at the predetermined time and the old deadline repayment amount set;

[0047] S350: Perform arithmetic operations on the total prepayment information set, the total consumption amount information, the initial customer balance set, the old deadline repayment amount set, the total manual adjustment amount, the total processed bad debt amount and the total refund amount information of each corporate user to obtain the remaining prepayment amount information set.

[0048] Specifically, the total prepaid payment information of the enterprise user is the total amount of prepaid repayments extracted from the prepaid bills in the enterprise user's billing information before the statistical time node and after the last statistical time node; the total consumption amount information of the enterprise user is the total amount of consumption in the enterprise user account before the statistical time node and after the last statistical time node, which is read from the invoicing bill in the basic billing information set; the total refund amount information is the total amount returned to the enterprise user from the enterprise user account before the statistical time node and after the last statistical time node, which is extracted from the change bill information; the account flow details information of the enterprise user within the predetermined time is the account correction and change status of the enterprise user before the statistical time node and after the last statistical time node, including the total amount of manual adjustment and the total amount of bad debt processing:

[0049] The total amount of manual adjustments is the amount of money lost by the enterprise users due to manual adjustments to their account amounts before the statistical time node and after the last statistical time node. Here are two unrestricted examples: the refund amount entered into a certain enterprise user's account is incorrect and needs to be adjusted; after the enterprise's account is audited by the audit department, the auditors require adjustments based on the audit results, etc., and the total amount of adjustments before the statistical time node is recorded as the total amount of manual adjustments. The total amount of bad debts processed is the total amount of uncollected accounts receivable and the total amount of approved losses in the accounts of enterprise users before the statistical time node and after the last statistical time node. Among them, the predetermined time is the time interval between the last account statistical time node and this statistical time node.

[0050] The initial customer balance information of the enterprise user at the predetermined time is the total remaining amount corresponding to the bill information of the repayment before the statistical time node. The initial customer balance information and the bill creation date are stored together. For example, if the last statistical time is December 31, 20, and the statistical time node this time is March 31, 20, the initial customer balance information is the balance of the first quarter of 21, which records the repayment balance information from January to March 21; the old term deadline repayment amount is the total amount remaining of the old term repayment that exceeds the bill repayment before the statistical time node. For example, if the last statistical time is December 31, 20, and the statistical time node this time is March 31, 20, then the old term deadline repayment amount is the repayment amount of the receivables in 20.

[0051] Furthermore, the remaining prepayment amount information is calculated by the following formula:

[0052] The remaining prepayment amount information = the total prepayment information of the enterprise user - the total consumption amount of the enterprise user - the total refund amount information + the total amount of manual adjustment + the total amount of processed bad debts + the initial customer balance + the amount of repayment at the end of the old term;

[0053] The above formula is used to calculate each user in the enterprise user set to obtain the remaining prepayment amount information set, and the remaining prepayment amount information is marked as tag information on the corresponding enterprise user to facilitate real-time viewing of the remaining prepayment amount of the enterprise user.

[0054] Further, based on the sequential calculation of the time age of the first offset bill information set, step S400 further includes:

[0055] S410: Obtaining a billing deadline time set for each enterprise user according to the first offset bill information set, wherein the billing deadline time set includes a billing deadline month set;

[0056] S420: obtaining current date information of information statistics according to the first overdue customer information set, wherein the current date information includes current month information;

[0057] S430: According to the current month information, the time age of the set of closing bill months is calculated in sequence to obtain a set of information on the number of months of difference;

[0058] S440: Obtain a first account age information set of each enterprise user according to the difference in months information set.

[0059] Specifically, according to the bill information corresponding to the first offset bill information set, the bill date or month identification information is extracted from the bill information set to obtain the date data of each bill corresponding to each enterprise user, including the bill creation date identification information, the bill expiration date and other bill date and time, preferably using the bill expiration month as the expiration date; further, the current date information is the date to which the statistical time node belongs, preferably the current month information, the overdue customer information of the first offset bill information set corresponding to the bill expiration date is extracted to obtain the bill expiration month of the corresponding overdue bill, the overdue duration of the enterprise customer is calculated based on the bill expiration month of the overdue bill and the current month information, preferably using the difference in months information to represent; the overdue duration of all overdue enterprise customers is obtained using the same method to obtain the difference in months information set, and further, the difference in months information set is used as the representation data of the first aging information set of each enterprise user. The overdue duration of all overdue enterprise customers can be represented by the first aging information set of each enterprise user, so as to facilitate the priority division of collection of overdue customers according to different durations.

[0060] Further, based on the offsetting of the remaining prepaid amount information set against the outstanding bill information set of each enterprise user, step S300 further includes S360:

[0061] S361: Obtaining a billing time sequence table of each remaining prepayment amount information according to the remaining prepayment amount information set of each enterprise user;

[0062] S362: Obtain a first billing time and a second billing time according to the billing time sequence table, wherein the first billing time is the earliest time in the billing time sequence table, and the second billing time is the latest time in the billing time sequence table;

[0063] S363: Based on the sequence from the first billing time to the second billing time in the billing time sequence table, the remaining prepaid amount information set is offset against the outstanding billing information set of each corporate user.

[0064] Specifically, the billing time series table extracts the bill date or month identification information corresponding to the outstanding billing information set of the enterprise user in the billing information set, obtains the billing date of each outstanding bill, and arranges the billing dates in chronological order to obtain the information; the first billing time is the header billing date of the billing time series table, and the second billing time is the footer billing date of the billing time series table, wherein the footer billing date is later than the header billing date; further, the remaining prepayment amount information is used to offset according to the billing time series table starting from the first billing time until the remaining prepayment amount is cleared or the second billing time is reached, and the offset process is: the total amount offset = the remaining prepayment amount information - the amount owed by the enterprise user corresponding to the first billing time until the remaining prepayment amount is cleared or the second billing time is reached; then the amount owed corresponding to the enterprise user - the total amount offset is used to obtain the actual overdue amount. When a bill of the enterprise user is overdue, the remaining prepaid amount in the account is first used to offset the overdue bills of the enterprise user according to the time sequence. If all overdue bills are offset, the overdue mark of the corresponding enterprise user will be deleted; if not all of them are offset, the remaining unoffset bills will be treated as overdue bills, and the overdue information of the corresponding enterprise user will be updated according to the Scheduler timing program, so as to obtain a more accurate overdue information mark.

[0065] Further, based on screening the first aging information set to obtain a first overdue customer information set, step S500 further includes:

[0066] S510: Presetting overdue account aging requirements based on the enterprise customer cluster, wherein the overdue account aging requirements include custom aging cycles and additional months change information;

[0067] S520: Filter the first account age information set according to the overdue account age requirement to generate an overdue information queue list;

[0068] S530: Obtain the first overdue customer information set according to the overdue information queue list.

[0069] Specifically, the preset overdue account age requirement is the preset allowable overdue account age after evaluating the overdue customers corresponding to the overdue bills of the multi-dimensional tag information set of the enterprise customer cluster. It mainly consists of two parts. The first part is the customized account age cycle, which is the preset overdue account age set by the enterprise itself, and there is no restriction on it; the second part is the additional months change information, which refers to the additional months added on the basis of the original overdue account age. If the repayment is made within this number of months, it will not affect the credit of the overdue enterprise user. If the payment is still not received after exceeding the additional months change information, the credit score of the corresponding enterprise user will be reduced. Furthermore, the overdue enterprise users who can be paid within the preset overdue account age requirement are screened out, and the account age information exceeding the preset overdue account age requirement is stored to obtain the overdue information queue list. The overdue information queue list represents the overdue enterprise customers who have been screened again, and a more accurate list of low-information enterprise customers with actual overdue is obtained, which provides important information assistance for subsequent strategic planning.

[0070] Further, such as Figure 2 As shown, based on obtaining the first overdue customer information set, step 500 further includes S540:

[0071] S541: performing multi-dimensional aggregation on the overdue information queue list according to the multi-dimensional tag information set to generate a multi-dimensional overdue information queue list;

[0072] S542: Obtaining target customer bill label information of the first enterprise;

[0073] S543: Based on the target customer bill tag information, the multi-dimensional overdue information queue list is screened to obtain the first overdue customer information set.

[0074] S544: Feedback the first overdue customer information set to the first enterprise for display.

[0075] Specifically, the multi-dimensional overdue information queue list is based on the corresponding multi-dimensional label information extracted from the multi-dimensional label information set by the enterprise users in the overdue information queue list, including but not limited to: business line, type, region, payment cycle and other label information; further, the extracted multi-dimensional label information is marked on the overdue enterprise customer corresponding to the multi-dimensional overdue information queue list to obtain the target customer bill label information of the first enterprise; further, based on the obtained multi-dimensional target customer bill label information of the first enterprise, the operating conditions of the overdue enterprise users are evaluated, and the collection ability is analyzed, and the overdue customers who are determined to be unable to be collected within the preset overdue account age requirements are screened out as the first overdue customers; further, the first overdue customers finally screened out and their corresponding customer bill label information are presented in pairs to the first enterprise, wherein the first enterprise is the enterprise using the system. By expanding customer labels, the dimensions of statistics and display are increased, and the value of statistical results is improved.

[0076] In summary, the method and system for analyzing overdue customer bills for an enterprise provided by the embodiments of the present application have the following technical effects:

[0077] 1. The embodiment of the present application provides a method and system for analyzing overdue customer bills for enterprises, thereby solving the problem in the prior art that manual statistics of overdue accounts of enterprise customers consume a lot of labor and time costs when the number of customers is large, and the statistical content is limited to overdue debt information, resulting in technical problems that are difficult to adapt to situations with a large number of customers and single statistical information. By collecting the basic information of all enterprise customers, the basic information includes tag information describing enterprise information and enterprise billing information, and the tag information of the enterprise information is stored in the enterprise customer model; the billing information is stored in the billing model. The overdue information of the enterprise is calculated in the billing information, and the overdue enterprises are screened out in combination with the tag information of the enterprise information. The information of the overdue enterprises is updated in real time through the Scheduler timing program, thereby providing important information for the company's strategic direction adjustment. Based on automated processing, the technical effect of being applicable to customers with large amounts of data and being able to count multi-dimensional enterprise information is achieved.

[0078] 2. Update the information of overdue enterprises in real time through the Scheduler timing program. When faced with a large number of changes to the original bills, the overdue information can be generated again by triggering the re-execution of the overdue generation task on the system page. This reduces a large number of manual modification operations, reduces costs, and improves work efficiency.

[0079] 3. Based on the multi-dimensional tag information, the customer tags for overdue corporate users can be dynamically expanded to increase the dimensions of statistics and display, thereby improving the value of statistical results.

[0080] Embodiment 2

[0081] Based on the same inventive concept as the method for analyzing overdue customer bills for an enterprise in the aforementioned embodiment, Figure 3 As shown, the embodiment of the present application provides a customer bill overdue analysis system for an enterprise, wherein the system includes:

[0082] A first collection unit 11, the first collection unit 11 is used to collect a basic information set of an enterprise customer cluster based on big data, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in an enterprise customer model, and the bill information set is stored in a bill model;

[0083] A first obtaining unit 12, the first obtaining unit 12 is used to obtain a basic billing information set of the enterprise customer cluster according to the basic information set;

[0084] A second obtaining unit 13, the second obtaining unit 13 is used to obtain a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster according to the basic bill information set, and offset the outstanding bill information set of each enterprise user with the remaining prepayment amount information set to generate a first offset bill information set of each enterprise user;

[0085] A first generating unit 14, the first generating unit 14 is used to calculate the time age of the first offset bill information set in sequence to generate a first account age information set of each enterprise user;

[0086] A third obtaining unit 15, the third obtaining unit 15 is used to filter the first account age information set according to the multi-dimensional tag information set to obtain a first overdue customer information set;

[0087] The first updating unit 16 is used to dynamically update the first overdue customer information set based on a Scheduler timing program.

[0088] Furthermore, the system also includes:

[0089] A fourth obtaining unit, the fourth obtaining unit is used to obtain a total prepayment information set of each enterprise user according to the basic bill information set;

[0090] A fifth obtaining unit, the fifth obtaining unit is used to obtain the total consumption amount information and the total refund amount information of each enterprise user according to the total prepayment information set;

[0091] A sixth obtaining unit, the sixth obtaining unit is used to obtain detailed account flow information of each enterprise user within a predetermined time according to the basic bill information set, wherein the detailed account flow information includes a total amount of manual adjustment and a total amount of processed bad debts;

[0092] A seventh obtaining unit, the seventh obtaining unit is used to obtain the initial customer balance set and the old deadline repayment amount set of each enterprise user at the predetermined time;

[0093] The first calculation unit is used to perform arithmetic operations on the total prepayment information set of each corporate user, the total consumption amount information, the initial customer balance set, the old deadline repayment amount set, the total manual adjustment amount, the total processed bad debt amount and the total refund amount information to obtain the remaining prepayment amount information set.

[0094] Furthermore, the system also includes:

[0095] an eighth obtaining unit, the eighth obtaining unit being used to obtain a set of billing deadlines for each enterprise user according to the first offset billing information set, the set of billing deadlines including a set of billing deadline months;

[0096] a ninth obtaining unit, the ninth obtaining unit being used to obtain current date information of information statistics according to the first overdue customer information set, wherein the current date information includes current month information;

[0097] A second calculation unit, the second calculation unit is used to calculate the time age of the set of closing bill months in sequence according to the current month information, and obtain a set of information on the number of months of difference;

[0098] A tenth obtaining unit, the tenth obtaining unit is used to obtain the first account age information set of each enterprise user according to the difference month number information set.

[0099] Furthermore, the system also includes:

[0100] an eleventh obtaining unit, the eleventh obtaining unit being used to obtain a billing time series table of each remaining prepayment amount information according to the remaining prepayment amount information set of each enterprise user;

[0101] a twelfth obtaining unit, the twelfth obtaining unit being used to obtain a first billing time and a second billing time according to the billing time sequence table, wherein the first billing time is the earliest time in the billing time sequence table, and the second billing time is the latest time in the billing time sequence table;

[0102] The first processing unit is used to offset the outstanding billing information set of each enterprise user with the remaining prepaid amount information set based on the sequence from the first billing time to the second billing time in the billing time series table.

[0103] Furthermore, the system also includes:

[0104] A first setting unit, the first setting unit is used to preset overdue account aging requirements based on the enterprise customer cluster, wherein the overdue account aging requirements include a custom aging cycle and additional months change information;

[0105] a first generating unit, the first generating unit being configured to filter the first account aging information set according to the overdue account aging requirement to generate an overdue information queue list;

[0106] A thirteenth obtaining unit, the thirteenth obtaining unit is used to obtain the first overdue customer information set according to the overdue information queue list.

[0107] Furthermore, the system also includes:

[0108] a second generating unit, the second generating unit being configured to perform multi-dimensional aggregation on the overdue information queue list according to the multi-dimensional tag information set to generate a multi-dimensional overdue information queue list;

[0109] a fourteenth obtaining unit, the fourteenth obtaining unit being used to obtain bill tag information of target customers of the first enterprise;

[0110] A fifteenth obtaining unit is used to filter the multi-dimensional overdue information queue list based on the target customer bill tag information to obtain the first overdue customer information set.

[0111] The second processing unit is used to feed back the first overdue customer information set to the first enterprise for display.

[0112] Exemplary Electronic Devices

[0113] Reference below Figure 4 To describe the electronic device of the embodiment of the present application,

[0114] Based on the same inventive concept as the customer bill overdue analysis method for an enterprise in the aforementioned embodiment, the embodiment of the present application also provides a customer bill overdue analysis system for an enterprise, including: a processor, the processor is coupled to a memory, the memory is used to store a program, when the program is executed by the processor, the system executes any one of the methods described in the first aspect.

[0115] The electronic device 300 includes: a processor 302, a communication interface 303, and a memory 301. Optionally, the electronic device 300 may also include a bus architecture 304. The communication interface 303, the processor 302, and the memory 301 may be interconnected via the bus architecture 304; the bus architecture 304 may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus. The bus architecture 304 may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 4 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0116] The processor 302 may be a CPU, a microprocessor, an ASIC, or one or more integrated circuits for controlling the execution of the program of the present application.

[0117] The communication interface 303 uses any transceiver-like system for communicating with other devices or communication networks, such as Ethernet, radio access network (RAN), wireless local area networks (WLAN), wired access networks, etc.

[0118] The memory 301 may be a ROM or other type of static storage device that can store static information and instructions, a RAM or other type of dynamic storage device that can store information and instructions, or an electrically erasable programmable read-only memory (EEPROM), a compact disc (CD-ROM) or other optical disc storage, an optical disc storage (including a compressed optical disc, a laser disc, an optical disc, a digital versatile disc, a Blu-ray disc, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of an instruction or data structure and can be accessed by a computer, but is not limited thereto. The memory may exist independently and be connected to the processor via a bus architecture 304. The memory may also be integrated with the processor.

[0119] The memory 301 is used to store computer-executable instructions for executing the solution of the present application, and the execution is controlled by the processor 302. The processor 302 is used to execute the computer-executable instructions stored in the memory 301, thereby realizing a method for analyzing overdue customer bills for an enterprise provided in the above embodiment of the present application.

[0120] Optionally, the computer-executable instructions in the embodiments of the present application may also be referred to as application code, which is not specifically limited in the embodiments of the present application.

[0121] The embodiment of the present application provides a method and system for analyzing overdue customer bills for enterprises, thereby solving the problem that the prior art manually counts overdue accounts of enterprise customers, which consumes a lot of labor and time costs when the number of customers is large, and the statistical content is limited to overdue debt information, resulting in technical problems that are difficult to adapt to situations with a large number of customers and single statistical information. By collecting the basic information of all enterprise customers, the basic information includes tag information describing enterprise information and enterprise billing information, and the tag information of the enterprise information is stored in the enterprise customer model; the billing information is stored in the billing model. The overdue information of the enterprise is calculated in the billing information, and the overdue bill enterprises are screened out in combination with the tag information of the enterprise information. The information of the overdue enterprises is updated in real time through the Scheduler timing program, thereby providing important information for the company's strategic direction adjustment. Based on automated processing, the technical effect of being applicable to customers with large amounts of data and being able to count multi-dimensional enterprise information is achieved.

[0122] Those of ordinary skill in the art will appreciate that the various digital numbers such as the first and second involved in the present application are only for the convenience of description, and are not used to limit the scope of the embodiments of the present application, nor do they represent the order of precedence. "And / or" describes the association relationship of the associated objects, indicating that three relationships may exist. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. The character " / " generally indicates that the associated objects before and after are in an "or" relationship. "At least one" refers to one or more. At least two refers to two or more. "At least one", "any one" or similar expressions refer to any combination of these items, including any combination of single items (individuals) or plural items (individuals). For example, at least one item (individual, kind) of a, b, or c can represent: a, b, c, ab, ac, bc, or abc, where a, b, c can be single or multiple.

[0123] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable systems. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from a website site, computer, server or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website site, computer, server or data center. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server, data center, etc. that includes one or more available media integrated. The available medium may be a magnetic medium, (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive (SSD)), etc.

[0124] The various illustrative logic units and circuits described in the embodiments of the present application can be implemented or operated by a general-purpose processor, a digital signal processor, an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic system, a discrete gate or transistor logic, a discrete hardware component, or the design of any combination of the above functions. The general-purpose processor can be a microprocessor, and optionally, the general-purpose processor can also be any traditional processor, controller, microcontroller or state machine. The processor can also be implemented by a combination of a computing system, such as a digital signal processor and a microprocessor, a plurality of microprocessors, one or more microprocessors in conjunction with a digital signal processor core, or any other similar configuration to implement.

[0125] The steps of the method or algorithm described in the embodiments of the present application can be directly embedded in hardware, a software unit executed by a processor, or a combination of the two. The software unit can be stored in a RAM memory, a flash memory, a ROM memory, an EPROM memory, an EEPROM memory, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium in the art. Exemplarily, the storage medium can be connected to the processor so that the processor can read information from the storage medium and can write information to the storage medium. Optionally, the storage medium can also be integrated into the processor. The processor and the storage medium can be arranged in an ASIC, and the ASIC can be arranged in a terminal. Optionally, the processor and the storage medium can also be arranged in different components in the terminal. These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are performed on the computer or other programmable device to produce a computer-implemented process, so that the instructions executed on the computer or other programmable device provide for implementing the process in the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0126] Although the present application has been described in conjunction with specific features and embodiments thereof, it is obvious that various modifications and combinations may be made thereto without departing from the spirit and scope of the present application. Accordingly, this specification and the drawings are merely exemplary illustrations of the present application as defined by the appended claims, and are deemed to have covered any and all modifications, variations, combinations or equivalents within the scope of the present application. Obviously, a person skilled in the art may make various modifications and variations to the present application without departing from the scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include these modifications and variations.

Claims

1. A method for analyzing overdue customer bills for an enterprise, wherein: The method is applied to an enterprise customer model and a billing model, and the method comprises: Based on big data, a basic information set of an enterprise customer cluster is collected, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in the enterprise customer model, and the bill information set is stored in the bill model; According to the basic information set, obtaining a basic billing information set of the enterprise customer cluster; According to the basic bill information set, a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster is obtained, and the remaining prepayment amount information set is offset against the outstanding bill information set of each enterprise user to generate a first offset bill information set of each enterprise user; Obtaining a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster, including: obtaining a total prepayment information set, a total consumption amount information, an initial customer balance set, an old deadline repayment amount set, a manual adjustment amount sum, a bad debt processing amount sum and a total refund amount information, and performing arithmetic operations to obtain the remaining prepayment amount information set; The time age of the first offset bill information set is calculated sequentially to generate the first account age information set of each enterprise user, including: identifying the bill creation time information and the bill overdue time information as tag information of the corresponding account overdue enterprise customer to obtain the first account age information of the enterprise user; According to the multi-dimensional tag information set, the first account aging information set is screened to obtain a first overdue customer information set; Based on the Scheduler timing program, the first overdue customer information set is dynamically updated.

2. The method of claim 1, wherein: The step of obtaining a set of information about the remaining prepayment amount of each enterprise user in the enterprise customer cluster further includes: Obtaining a total prepayment information set of each enterprise user according to the basic bill information set; According to the total prepayment information set, the total consumption amount information and the total refund amount information of each enterprise user are obtained; According to the basic bill information set, detailed account flow information of each enterprise user within a predetermined time is obtained, wherein the detailed account flow information includes the total amount of manual adjustment and the total amount of processed bad debts; The initial customer balance set of each enterprise user at the predetermined time and the old deadline repayment amount set are obtained.

3. The method of claim 1, wherein: The sequentially calculating the time age of the first offset bill information set also includes: According to the first offset bill information set, obtaining a billing deadline time set for each enterprise user, wherein the billing deadline time set includes a billing deadline month set; According to the first overdue customer information set, obtaining current date information of information statistics, wherein the current date information includes current month information; According to the current month information, the time age of the set of closing bill months is calculated in sequence to obtain a set of information on the number of months of difference; A first account age information set of each enterprise user is obtained according to the difference in months information set.

4. The method of claim 1, wherein: The offsetting of the remaining prepayment amount information set against the outstanding bill information set of each enterprise user also includes: According to the remaining prepayment amount information set of each enterprise user, a billing time series table of each remaining prepayment amount information is obtained; According to the billing time sequence table, a first billing time and a second billing time are obtained, wherein the first billing time is the earliest time in the billing time sequence table, and the second billing time is the latest time in the billing time sequence table; Based on the sequence from the first billing time to the second billing time in the billing time sequence table, the remaining prepaid amount information set is offset against the outstanding billing information set of each enterprise user.

5. The method of claim 1, wherein: The screening of the first aging information set to obtain a first overdue customer information set also includes: Based on the enterprise customer cluster, overdue account aging requirements are preset, wherein the overdue account aging requirements include custom aging cycles and additional months change information; According to the overdue account age requirement, the first account age information set is screened and filtered to generate an overdue information queue list; The first overdue customer information set is obtained according to the overdue information queue list.

6. The method of claim 5, wherein: The obtaining of the first overdue customer information set further includes: According to the multi-dimensional tag information set, the overdue information queue list is summarized in multiple dimensions to generate a multi-dimensional overdue information queue list; Obtain the target customer bill label information of the first enterprise; Based on the target customer bill tag information, the multi-dimensional overdue information queue list is screened to obtain the first overdue customer information set; The first overdue customer information set is fed back to the first enterprise for display.

7. A customer bill overdue analysis system for an enterprise, wherein: The system comprises: A first collection unit, the first collection unit is used to collect a basic information set of an enterprise customer cluster based on big data, wherein the basic information set includes a multi-dimensional tag information set and a bill information set of the enterprise customer cluster, the multi-dimensional tag information set is stored in an enterprise customer model, and the bill information set is stored in a bill model; A first obtaining unit, the first obtaining unit being configured to obtain a basic billing information set of the enterprise customer cluster according to the basic information set; A second obtaining unit, the second obtaining unit is used to obtain a remaining prepayment amount information set of each enterprise user in the enterprise customer cluster according to the basic bill information set, and offset the arrears bill information set of each enterprise user with the remaining prepayment amount information set to generate a first offset bill information set of each enterprise user; obtaining the remaining prepayment amount information set of each enterprise user in the enterprise customer cluster, including: obtaining a total prepayment information set, a total consumption amount information, an initial customer balance set, an old deadline collection amount set, a manual adjustment amount sum, a bad debt processing amount sum and a total refund amount information, and performing arithmetic operations to obtain the remaining prepayment amount information set; A first generating unit, the first generating unit is used to sequentially calculate the time age of the first offset bill information set to generate a first account age information set of each corporate user, including: identifying the bill creation time information and the bill overdue time information as tag information of the corresponding account overdue corporate customer to obtain the first account age information of the corporate user; a third obtaining unit, the third obtaining unit being configured to filter the first account aging information set according to the multi-dimensional tag information set to obtain a first overdue customer information set; The first updating unit is used to dynamically update the first overdue customer information set based on a Scheduler timing program.

8. A customer bill overdue analysis system for an enterprise, comprising: A processor, the processor is coupled to a memory, the memory is used to store a program, when the program is executed by the processor, the system is enabled to perform the method according to any one of claims 1 to 6.