CN112001705A - A management system for equipment billing and settlement - Google Patents

Abstract

The invention proposes a management system for equipment billing and settlement, including a business system, a billing system, a write-off system and a settlement system. The business system stores business data, and the billing system includes transaction data. layer, data synchronization layer, data calculation layer and storage layer, the transaction data layer has the business data in the business system called, and the business data in the transaction data layer synchronizes data to the data calculation layer through the data synchronization layer For calculation, the storage layer is connected with the data calculation layer for storing the calculation data in the data calculation layer, and also includes a data warehouse, the storage layer is connected with the data warehouse data, and the write-off system includes a write-off system. Data layer, write-off data synchronization layer, write-off data calculation layer, write-off data storage layer and write-off data warehouse, the invention provides a scientific and convenient online financial billing settlement management service.

Description

A management system for equipment billing and settlement

technical field

The invention relates to a management system for equipment billing and settlement.

Background technique

With the continuous development of each company's business, there are more and more partners, the types of rental equipment provided by the company are gradually diversified, and the number of equipment available for rental is increasing. The traditional manual ledger has the following disadvantages in the calculation of daily expenses and customer reconciliation :

1. The labor cost has increased sharply, and it is difficult to troubleshoot when the online and offline data are inconsistent, and it is difficult to reconcile accounts;

2. The calculation of cost items will cause data lag generation due to the delay of manual processing, and the timeliness is poor;

3. The offline confirmation process of bills is long, the problem feedback is not timely, and the customer satisfaction is not high;

4. It is impossible to effectively identify customers with different credit levels, and it is difficult to maintain customer relationships.

In view of the above-mentioned deficiencies of the prior art, the purpose of the present invention is to provide a scientific and convenient online financial billing and settlement management service, and aims to solve the problems of complicated financial business and cumbersome manual calculation in the prior art.

SUMMARY OF THE INVENTION

Purpose of the invention: The purpose of the present invention is to provide a method of using a rental equipment transportation management system in view of the deficiencies in the current technology, which can improve the safety of the rental equipment during transportation by effectively and actively supervising the transportation vehicles.

Technical solution: In order to achieve the above purpose, the present invention provides a management system for equipment billing and settlement, which is characterized in that it includes a business system, a billing system, a write-off system and a settlement system, and the business system stores Business data, the billing system includes a transaction data layer, a data synchronization layer, a data calculation layer, and a storage layer. The transaction data layer contains the business data retrieved from the business system, and the business data in the transaction data layer The data is synchronized to the data calculation layer through the data synchronization layer for calculation. The storage layer is connected to the data calculation layer for storing the calculation data in the data calculation layer, and also includes a data warehouse. The storage layer is connected to the data warehouse. Data connection, the write-off system includes a write-off data layer, a write-off data synchronization layer, a write-off data calculation layer, a write-off data storage layer and a write-off data warehouse, and the write-off transaction data layer has a billing system After calculating the billing data and the business data in the business system, the write-off data layer synchronizes the billing data and business data to the write-off calculation layer through the write-off data synchronization layer, and the write-off storage layer is connected to the write-off data synchronization layer. The computing layer data connection is used to store the billing data and business data after write-off, and also includes a write-off data warehouse, the write-off storage layer is connected to the write-off data layer, and the write-off storage layer is connected to the write-off data layer. The data layer is connected to the computing system data.

As an improvement of this technical solution: the billing system and the write-off system further include a data gateway and FineBI, the storage layer is signally connected to the data gateway, and the data warehouse is signally connected to FineBI and the data gateway, respectively, The write-off storage layer is signal-connected with the data gateway, and the write-off data warehouse is signal-connected through FineBI and the data gateway, respectively.

As an improvement of the technical solution, the transaction data layer includes transaction orders and clients corresponding to the transaction orders.

As an improvement of this technical solution: the data synchronization layer includes a T+0 mode and a T+1 mode, the T+0 mode is provided with a task scheduling platform and a monitoring and alarm platform, and in the T+0 mode Settings include configuration management, log management, kafka cluster, and Canal Server.

As an improvement of the technical solution, the data computing layer includes billing subject configuration management, billing rule engine, execution policy management, log management, resource management and billing verification task management.

As an improvement of the technical solution, the storage layer stores tenant information and corresponding calculated tenant fee information.

As an improvement of the technical solution, the write-off data layer includes an ICC billing system and a business system, and business data is stored in the business system.

As an improvement of the technical solution, the write-off data synchronization layer includes a task scheduling platform and a monitoring and alarming platform.

As an improvement of the technical solution, the write-off data calculation layer includes a write-off rule engine, log management, and write-off configuration management.

As an improvement of the technical solution, the write-off data storage layer includes ES cluster, Redis cluster and HBase cluster.

Compared with the prior art, the present invention has the following beneficial effects:

(1) The present invention has a variety of charging modes, and the charging system, as the support of the standard charging background, provides powerful business data query and analysis capabilities, supports multi-rule charging for customers, and can meet the real-time access of different customers;

(2) Standardized online reconciliation process, customers can check bills at any time, sign and confirm online, and improve communication efficiency;

(3) Customized write-off system, the write-off system is committed to providing the most rational write-off services for customers of different levels, providing customers with multi-dimensional write-off rules, and connecting multiple categories of write-off subjects;

(4) Systematic financial middle-office services, through the financial data provided by the financial middle-office, to analyze and screen the company's high-quality and stable customers. In the later process of customer relationship maintenance, business personnel can configure the account period and settlement method in a targeted and diversified manner;

(5) The invention can meet the seamless access of multiple customers and different categories of billing items, and reduce the company's labor costs and improve customer satisfaction through the powerful business processing capabilities and big data analysis capabilities provided by the financial middle-office. , improve the company's efficiency.

Description of drawings:

1 is a schematic diagram of the principle structure of a charging system in the present invention;

Fig. 2 is an example diagram of billing processing in the billing system in the present invention;

Fig. 3 is a schematic diagram of the principle structure of the write-off system in the present invention;

4 is an example diagram of online confirmation of bills in the present invention;

Fig. 5 is a schematic diagram of the charging and settlement process flow of the financial center in the present invention;

FIG. 6 is a schematic diagram of the online confirmation process of the bill in the present invention.

Detailed ways

The present invention will be further clarified below with reference to the accompanying drawings and specific embodiments. It should be understood that the following specific embodiments are only used to illustrate the present invention and not to limit the scope of the present invention. It should be noted that the words "front", "rear", "left", "right", "upper" and "lower" used in the following description refer to the directions in the drawings, and the words "inner" and "outer" ” refer to directions towards or away from the geometric center of a particular part, respectively.

In order to solve the technical problems in the background art, the present invention proposes a management system for equipment billing and settlement, as shown in the accompanying drawings 1-6 of the specification.

Among them: task scheduling platform: it is a lightweight distributed task scheduling platform based on the transformation of the existing XXL-JOB, which is used for the configuration, scheduling, monitoring and execution result query of tasks of each platform;

Monitoring and alarm platform: for different business scenarios involving process data verification, transmission data specification verification, abnormal operation results, etc., through the real-time alarm mechanism of the network, SMS, and business platform;

Billing subject configuration management: A multi-type billing customer management platform is developed for different products accessed externally, which is used in the ICC billing system for cost calculation and generation;

Billing rule engine: According to different billing subjects in the configuration management of billing subjects, it provides general and customized dynamic billing rule management, which is used for ICC billing system for cost calculation and generation;

Execution policy management: Manage different execution policies of the charging rule engine;

Resource management and billing verification task management; for system resources, rationally and efficiently standardize the resource and task management platform generated by using the ICC billing system;

ICC billing system: The basic data provided by the business system is generated through billing subject configuration management, billing rule engine, execution strategy management, resource management, and billing verification task management, etc. directly understandable data;

Business system: provide basic data to the equipment billing and settlement management system;

Write-off rule engine: According to the data generated by the ICC billing system, it provides general and customized dynamic write-off rule management, which is used for the write-off system to write off billing accounts according to the rules;

Write-off configuration management: configuration management other than write-off rules, including write-off management of self-operated and non-self-operated billing accounts, resource management of write-off system, etc., for the stable operation of write-off system.

As shown in Figure 1-2, the billing system implements:

Through the billing rule engine, the cost calculation of different dimensions can be satisfied at the same time, which is reflected in different billing subjects, customized cost calculation intervals, and diversified data display carriers.

The billing subjects include common types of fees in the leasing industry, such as equipment rental fees and service fees. The rental fee includes the daily rental of the equipment and possible maintenance fees, and the service fee includes the transportation cost of the equipment.

The customized cost calculation interval is generated according to different market conditions and operating scenarios in different regions. It provides diversified services such as daily rental price, monthly rental price, time-of-use billing, and price adjustment to meet the different needs of customers.

The financial data calculated in real time every day is stored in different financial systems according to the different analysis requirements of the financial department, and can be inquired by financial personnel at any time for multi-dimensional analysis. Such as financial accounts receivable detailed report, receivable summary report, income detailed report, income summary report, receivable aging report, etc.

The billing module covers a wide range, serving but not limited to aerial equipment and excavator leasing industries. Through flexible configuration, it can meet the access of different leasing categories.

Introduction to the billing model - billing subject: rent (rent):

Financial terminology:

a. Expected lease days --expectedDays

b. Weighted monthly rent --weightedMonthRent

c. Actual lease days --actualDays

d. Callback rent --callbackRent

(1) Billing logic:

1. expectedDays ≤ 30 days

(1) actualDays ≤ 30 days

When multiple price ranges are involved, examples are as follows:

Days 1 & Price 1 (No. 1-10: 150 per day, 3000 per month)

Days 2 & Price 2 (No. 11-20: 130 per day, 2700 per month)

Days 3 & Price 3 (No. 21-30: 120 per day, 2400 per month)

Phase 1 (Numbers 1-10):

① Daily rent (rent) on the statistical day: 150 (current daily rent price), accumulative 150*10=1500

②Rent callback (callbackRent): weighted monthly rental price of 3000-cumulative daily income from the starting date to the statistical date=X;

When X≤0: callbackRent = 0

When X>0: callbackRent = X

The second stage (No. 11-20):

①Daily rent (rent) on the statistical day: 130, accumulative 130*10=1300

②Rent callback (callbackRent): weighted monthly rental price of 2800-cumulative daily income from the starting date to the statistical date=X;

When X≤0: callbackRent = 0

When X>0: callbackRent = X

The second stage (No. 21-30):

①Daily rent (rent) on the statistical day: 120, accumulative 120*10=1200

②Rent callback (callbackRent): weighted monthly rental price of 2700-cumulative daily income from the starting date to the statistical date=X;

When X≤0: callbackRent = 0

When X>0: callbackRent = X

③No. 21 rental callback (callbackRent): weighted monthly rental price 2700-cumulative income 2920=-220;

④No. 22 rental callback (callbackRent): weighted monthly rental price 2700-cumulative income 2920=-120

⑤No. 23 rental callback (callbackRent): weighted monthly rental price 2700-cumulative income 2920=-120

Note:

Weighted monthly rental price calculation rules:

weightedMonthRent = price1 * day1 + price2 * day2 + price3*day3

price1: Within the scope of the weighted monthly rental price statistics, the current monthly rental price of the equipment on the statistical day/30;

day1: within the scope of weighted monthly rental price statistics, the effective time of price1;

price2, price3 are the same as price1;

day2 and day3 are the same as day1.

In the example, when calculating the weighted monthly rental price for each day from the 1st to the 10th, price1=3000/30, day1=30, weighted monthly rental price = (3000/30) *30 = 3000

When calculating the weighted monthly rental price for each day from the 11th to the 20th, price1=3000/30, day1=10, price2=2700/30, day2=20, the weighted monthly rental price = (3000/30) *10 + (2700/ 30)*20 = 2800

When calculating the weighted monthly rental price for each day from the 21st to the 21st, price1=3000/30, day1=10, price2=2700/30, day2=10, price2=2400/30, day2=10, weighted monthly rental price = ( 3000/30) *10 + (2700/30)*10+(2400/30)*10 = 2700

(2) actualDays > 30 days

Daily rent on the statistical day (rent) = monthly rental price of the current month/30

2. ExpectedDays > 30 days

Same as expectedDays ≤ 30, when calculating the rent for the first 30 days, the daily rent defaults to the current monthly rent price/30

Summary: To ensure that customers enjoy the greatest discounts, the total rental cost for the first 30 days is valued:

Min ((day rental price 1*days1+day rental price2*days2+day rental price3*days3), weighted monthly rental price).

Application prospect of financial billing system:

The financial billing system, as the back-end support for Zhongneng's standard billing, provides powerful business data query and analysis capabilities, supports multi-rule billing for customers, and can meet the real-time access of different customers.

As shown in Figure 3, the write-off system:

(1) After the billing system data is generated, through customized write-off rules, which are embodied in the write-off sequence of each billing subject, and the multi-dimensional write-off logic of documents and customers, the system can timely and accurately write off expense items. , and generate various accounting documents.

(2) Common write-off rules - unified billing items, write-off according to the age of expenses from large to small, and calculate the number of days overdue for equipment in real time

For specific rental items, for example, equipment is rented from January 1, the daily cost is 100 yuan, and the settlement frequency is a natural month, that is, February 1 is the billing date, and if the customer receives a payment of 500 yuan on February 1, priority will be given to January 1. The rent of the No. 1 began to be written off, and the accumulated rent of 500 yuan from January 1st to January 5th was written off, and the remaining days totaled 2,600 yuan, resulting in overdue, and the number of overdue days is 1 day.

Verification system application:

The financial write-off system is committed to providing the most rational write-off services for customers of different levels, providing customers with multi-dimensional write-off rules, and connecting multiple categories of write-off subjects.

Customized and standardized online bill confirmation process for equipment rental bills:

(1) In order to facilitate the company's business personnel to settle settlements with customers in a timely manner, the financial center provides online billing services. Business personnel can inquire about the combination of rental equipment, time period, billing subjects and other conditions provided by the bill, and initiate bills in time. At the same time, it also supports automatic billing and SMS reminder functions, without the need for business personnel to operate, the system automatically generates bills.

(2) Customers can check bills at any time, sign and confirm online, and improve communication efficiency.

(3) The standardized online bill confirmation service can assist the company's business personnel to complete the payment collection task in a timely manner and improve the company's business productivity.

Financial and legal personnel can analyze and screen the company's high-quality and stable customers through the financial data provided by the financial center. In the later process of customer relationship maintenance, business personnel can configure the account period and settlement method in a targeted and diversified manner. Through the billing and settlement service provided by the financial middle-office service, equipment leasing, cost calculation, bill confirmation, and real-time verification can be realized. A win-win model of sales and cooperation.

Claims (10)

1. A billing management system for equipment characterized by: the system comprises a service system, a charging system, a verification and cancellation system and a settlement system, wherein the service system stores service data, the charging system comprises a transaction data layer, a data synchronization layer, a data calculation layer and a storage layer, the transaction data layer is provided with the service data in the called service system, the service data in the transaction data layer is calculated in the data calculation layer through the data synchronization layer, the storage layer is connected with the data calculation layer and used for storing the calculation data in the data calculation layer, the system also comprises a data warehouse, the storage layer is in data connection with the data warehouse, the verification and cancellation system comprises a verification and cancellation data layer, a verification and cancellation data synchronization layer, a verification and cancellation data calculation layer, a verification and cancellation data storage layer and a verification and cancellation data warehouse, the verification and cancellation transaction data layer is provided with the charging data calculated by the charging system and the service data in the service system, the verification and cancellation data layer synchronizes the charging data and the service data to the verification and cancellation computing layer through the verification and cancellation data synchronization layer, the verification and cancellation storage layer is connected with the verification and cancellation computing layer and used for storing the charging data and the service data after verification and cancellation, the verification and cancellation data storage system further comprises a verification and cancellation data warehouse, the verification and cancellation storage layer is connected with the verification and cancellation data layer in a data mode, and the verification and cancellation storage layer is connected with the verification and cancellation data layer in a data mode.

2. The device charge settlement management system according to claim 1, wherein: the charging system and the verification and cancellation system further comprise a data gateway and a FineBI, the storage layer is in signal connection with the data gateway, the data warehouse is in signal connection with the FineBI and the data gateway respectively, the verification and cancellation storage layer is in signal connection with the data gateway, and the verification and cancellation data warehouse is in signal connection with the data gateway through the FineBI and the data gateway respectively.

3. The device charge settlement management system according to claim 1, wherein: the transaction data layer comprises a transaction order and a client corresponding to the transaction order.

4. The device charge settlement management system according to claim 1, wherein: the data synchronization layer comprises a T +0 mode and a T +1 mode, a task scheduling platform and a monitoring alarm platform are arranged in the T +0 mode, and configuration management, log management, a kafka cluster and a Canal Server are arranged in the T +0 mode.

5. The device charge settlement management system according to claim 1, wherein: the data calculation layer comprises charging subject configuration management, a charging rule engine, execution policy management, log management, resource management and charging check task management.

6. The device charge settlement management system according to claim 1, wherein: the storage layer stores tenant information and corresponding calculated tenant expense information.

7. The device charge settlement management system according to claim 1, wherein: the core-cancellation data layer comprises an ICC charging system and a service system, wherein service data are stored in the service system.

8. The device charge settlement management system according to claim 1, wherein: the core-cancellation data synchronization layer comprises a task scheduling platform and a monitoring alarm platform.

9. The device charge settlement management system according to claim 1, wherein: the core-canceling data calculation layer comprises a core-canceling rule engine, log management and core-canceling configuration management.

10. The device charge settlement management system according to claim 1, wherein: the core-cancellation data storage layer comprises an ES cluster, a Redis cluster and an HBase cluster.

Images