Automatic electric charge returning and supplementing system and method based on RPA

Abstract

The invention relates to the technical field of automatic electricity charge return and supplement, in particular to an automatic electricity charge return and supplement system and method based on RPA, the output end of an operation analysis module is in communication connection with the input end of an execution module, and the output end of an intelligent operation module is in communication connection with the input end of the operation analysis module and the input end of the execution module; the rehearsal unit can predict electricity consumption of a user in the future according to existing data and provide reasonable suggestions for the user, the problem of long time consumption of electricity fee refunding and supplementing can be solved in the refunding and supplementing process, the working efficiency is improved, meanwhile, multiple times of accounting and approval processing can be carried out when the system operates, and the accuracy of automatic electricity fee refunding and supplementing is improved; and the calculation unit can calculate the electric charge return and supplement of different types of customers, and the influence of various factors of electricity price policy adjustment on different types of customers is fully considered, so that the electric charge return and supplement calculation can be fair and reasonable for the power supply and consumption parties, and the policy adjustment characteristics and tendency can be better and accurately realized.

Description

Technical Field

[0001] The present invention relates to the technical field of automatic electricity bill refund and compensation, and specifically relates to an RPA-based automatic electricity bill refund and compensation system and method. Background Art

[0002] With the continuous advancement of the high-quality service work of power supply companies, the optimization of electricity bill refund and compensation work has become increasingly important. To solve the problem of the long time-consuming of the original manual electricity bill refund and compensation, an electricity bill refund and compensation method based on robotic process automation has been proposed.

[0003] For example, a method, system, device and medium for electricity bill refund and compensation with the application number CN202311621116.2 and the publication date of March 8, 2024. According to the obtained user information, the present invention obtains the user's electricity consumption information, calculates the refund and compensation difference based on the electricity consumption information and the real-time electricity price, and conducts liquidation approval. There is no need for manual calculation and approval, and compared with manual calculation, the accuracy and efficiency of the whole process are higher, which can avoid errors in the manual calculation process, and can quickly feedback the calculated user information and refund and compensation difference information to the user, improving the efficiency of the approval process.

[0004] At present, although the existing automatic electricity bill refund and compensation systems can achieve the purpose of automatic electricity bill refund and compensation, the functions of the automatic electricity bill refund and compensation systems are relatively simple, unable to provide reasonable suggestions to users, and the refund and compensation process takes a long time. Therefore, it is urgent to design an RPA-based automatic electricity bill refund and compensation system and method to solve the above problems. Summary of the Invention

[0005] The purpose of the present invention is to provide an RPA-based automatic electricity bill refund and compensation system and method to solve the above deficiencies in the prior art.

[0006] To achieve the above purpose, the present invention provides the following technical solutions: An RPA-based automatic electricity bill refund and compensation system includes an operation analysis module, an execution module, and an intelligent operation module. There is a communication connection between the output end of the operation analysis module and the input end of the execution module, and there are communication connections between the output end of the intelligent operation module and the input ends of the operation analysis module and the execution module respectively; Further, the operation analysis module includes an access unit, a calculation unit, an accounting unit, a preview unit, and an approval unit. There is a communication connection between the output end of the access unit and the input end of the calculation unit, there are communication connections between the output end of the calculation unit and the input ends of the accounting unit and the preview unit respectively, and there are accounting unit and preview unit between the output ends of the accounting unit and the preview unit and the input end of the approval unit; Further, the access unit is used to receive the electricity charge refund request information sent by the user and the power consumption monitored by the user's electricity meter. The access unit includes a request module and a meter data access module. The request module receives the electricity charge refund request information sent by the user through three methods: SMS, telephone communication, and official website customer service communication. The meter data access module is connected to the user's electricity meter through network communication, and the meter data access module can receive the power consumption monitored by the user's electricity meter; Further, the calculation unit calculates the electricity charge of the user by calculating the power consumption. The electricity charge formula selected in the calculation process of the calculation unit is as follows: Among them, is the electricity charge, is the amount of electricity used by the user, n is the category of electricity price (including catalog electricity price, funds and surcharges, etc.), and is the amount of different electricity price types; Further, the accounting unit gives information on whether to refund or supplement based on the accounting between the electricity charge calculated by the calculation unit and the fee paid by the user. The formula selected in the accounting process of the accounting unit is as follows: Among them, is the fee paid by the user, is the electricity charge. If D>0, the accounting unit obtains the information that a refund can be made. If D=0, the accounting unit obtains the information that no refund or supplement can be made. If D<0, the accounting unit obtains the information that additional fees are required; Further, the preview unit previews the user's future power consumption by analyzing the data accessed by the access unit and the data calculated by the calculation unit. The preview steps of the preview unit are as follows: S1-1. Receive the power consumption data accessed by the access unit and the data calculated by the calculation unit, analyze the data, and construct a positive correlation line chart based on it; S1-2. Input the data into the preview formula for calculation, and judge the user's future power consumption data based on the calculation result. The preview formula is as follows: Among them, is the power consumption of the user in the first month or the first quarter, is the power consumption of the user in the previous month or the previous quarter, is the power consumption of the user in the next month or the next quarter, is the power consumption of the user in the next two months or the next two quarters. If R≥1, it indicates that the user's future power consumption is gradually increasing, and the preview unit gives suggestions of not recommending a refund and recommending a fee supplement. If R<1, it indicates that the user's future power consumption is gradually decreasing, and the preview unit gives a suggestion of recommending a refund; Further, the approval unit is used to approve the result calculated by the accounting unit. The approval unit approves whether to refund or supplement the electricity charge based on the result calculated by the accounting unit and the result previewed by the preview unit, and it is specifically divided into the following situations: (1) Accounting unit: D=0, preview unit: regardless of whether R≥1 or R<1, the refund approval fails, and a suggestion of requiring payment of fees is given; (2)Accounting unit: D > 0, preview unit: If R ≥ 1, the refund approval is passed, and a suggestion of not recommending a refund is given; if R < 1, the refund approval is passed, and no suggestion is given. Accounting unit: D < 0, preview unit: Regardless of whether R ≥ 1 or R < 1, the refund approval is not passed, and information about the need to pay fees occurs. Furthermore, the execution module executes the refund and compensation of electricity charges according to the result approved by the approval unit. The execution module includes a push unit and a refund and compensation unit. The push unit sends the information approved by the approval unit to the user by means of text messages, WeChat, and voice calls. The refund and compensation unit is connected to the online banking system of the power grid enterprise through API technology. The refund and compensation unit transfers the money in the online banking system of the power grid enterprise to the user according to the information approved by the approval unit.

[0007] Furthermore, the intelligent operation module is built based on RPA, and the intelligent operation module is used to automatically control the operation and analysis module and the execution module to run.

[0008] An RPA-based automatic electricity charge refund and compensation method includes the following steps: Step S1. Collect data and build an automatic system: Collect relevant operation information during the previous manual refund and compensation of electricity charges, analyze the operation information, and build an automatic refund and compensation system through RPA according to the analysis results. Step S2. Collect and optimize the refund and compensation plan system: Log in to the official website of the power grid enterprise to obtain the electricity charge refund and compensation plan, and optimize the automatic refund and compensation system according to the refund and compensation plan. Step S3. Activate the system and receive requests: Activate the information transmission function of the automatic refund and compensation system, and receive the request information and electricity consumption information sent by the user. Step S4. System operation and refund and compensation: The automatic refund and compensation system processes the request information and electricity consumption information sent by the user, and transfers the money in the online banking system of the power grid enterprise to the user or sends a fee supplement information to the user according to the processing results.

[0009] In the above technical solution, the beneficial effects of an RPA-based automatic electricity charge refund and compensation system and method provided by the present invention are as follows: (10) When the present invention conducts the automatic refund and compensation of electricity charges, the preview unit can predict the user's future electricity consumption based on the existing data, provide reasonable suggestions to the user, and during the refund and compensation process, it can solve the problem of long duration of electricity charge refund and compensation, improve work efficiency. At the same time, when the system operates, it can perform multiple accounting and approval processes, improving the accuracy of automatic electricity charge refund and compensation.

[0010] (11)The calculation unit of the present invention can calculate the electricity charge refund and compensation for different types of customers. Since various factors of electricity price policy adjustment are fully considered, the calculation of electricity charge refund and compensation can be made more fair and reasonable for both power supply and consumption parties, and the characteristics and tendencies of policy adjustment can be accurately implemented better. Description of the Drawings

[0011] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings required in the embodiments. Obviously, the drawings described below are only some embodiments recorded in the present invention. For those of ordinary skill in the art, other drawings can also be obtained according to these drawings.

[0012] Figure 1 It is a schematic diagram of the system flow provided for an embodiment of the automatic electricity charge refund and compensation system and method based on RPA of the present invention.

[0013] Figure 2 It is a schematic diagram of the structure of the access unit provided for an embodiment of the automatic electricity charge refund and compensation system and method based on RPA of the present invention.

[0014] Figure 3 It is a schematic diagram of the structure of the execution module provided for an embodiment of the automatic electricity charge refund and compensation system and method based on RPA of the present invention.

[0015] Figure 4 It is a flowchart of the method provided for an embodiment of the automatic electricity charge refund and compensation system and method based on RPA of the present invention. Detailed Embodiments

[0016] In order to enable those skilled in the art to better understand the technical solutions of the present invention, the following will further introduce the present invention in detail in conjunction with the drawings.

[0017] As Figures 1-3 shown, an automatic electricity charge refund and compensation system based on RPA provided by an embodiment of the present invention includes an operation analysis module, an execution module, and an intelligent operation module. A communication connection is established between the output end of the operation analysis module and the input end of the execution module. A communication connection is established between the output end of the intelligent operation module and the input ends of the operation analysis module and the execution module respectively; The operation analysis module includes an access unit, a calculation unit, an accounting unit, a preview unit, and an approval unit. A communication connection is established between the output end of the access unit and the input end of the calculation unit. A communication connection is established between the output end of the calculation unit and the input ends of the accounting unit and the preview unit respectively. The output ends of the accounting unit and the preview unit are in an accounting unit and a preview unit with the input end of the approval unit; The access unit is used to receive the electricity bill refund request information sent by the user and the power consumption monitored by the user's electricity meter. The access unit includes a request module and an electricity meter data access module. The request module receives the electricity bill refund request information sent by the user through three methods: SMS, telephone communication, and official website customer service communication. The electricity meter data access module is connected to the user's electricity meter through network communication, and the electricity meter data access module can receive the power consumption monitored by the user's electricity meter; The calculation unit calculates the electricity cost of the user by calculating the power consumption. The electricity cost formula selected in the calculation process of the calculation unit is as follows:

[0018] Among them, is the electricity cost, is the amount of electricity used by the user, n is the type of electricity price (including catalog electricity price, funds and surcharges, etc.), is the amount of different electricity price types; The accounting unit gives information on whether to refund or supplement based on the accounting between the electricity cost calculated by the calculation unit and the fee paid by the user. The formula selected in the accounting process of the accounting unit is as follows:

[0019] Among them, is the fee paid by the user, is the electricity cost. If D>0, the accounting unit obtains the information that a refund can be made. If D=0, the accounting unit obtains the information that no refund or supplement can be made. If D<0, the accounting unit obtains the information that additional fees are required; The preview unit previews the user's future power consumption through the analysis of the data accessed by the access unit and the data calculated by the calculation unit. The preview steps of the preview unit are as follows: S1-1. Receive the power consumption data accessed by the access unit and the data calculated by the calculation unit, analyze the data, and construct a positive correlation line chart based on it; S1-2. Input the data into the preview formula for calculation, and judge the user's future power consumption data based on the calculation results. The preview formula is as follows:

[0020] Among them, is the power consumption of the user in the first month or the first quarter, is is the power consumption of the user in the previous month or the previous quarter, is is the power consumption of the user in the next month or the next quarter, is The electricity consumption of users in the next two months or the next two quarters. If R ≥ 1, it indicates that the future electricity consumption of users is gradually increasing, and the preview unit gives suggestions of not recommending refund and recommending additional payment. If R < 1, it indicates that the future electricity consumption of users is gradually decreasing, and the preview unit gives suggestions of recommending refund; The approval unit is used to approve the results calculated by the calculation unit. The approval unit approves whether to refund or supplement the electricity bill according to the results calculated by the calculation unit and the results previewed by the preview unit, and specifically includes the following situations: (12) Calculation unit: D = 0, preview unit: regardless of whether R ≥ 1 or R < 1, the refund approval fails, and a suggestion of needing to pay the fee is given; (13) Calculation unit: D > 0, preview unit: if R ≥ 1, the refund approval passes, and a suggestion of not recommending refund is given. If R < 1, the refund approval passes, and no suggestion is given; Calculation unit: D < 0, preview unit: regardless of whether R ≥ 1 or R < 1, the refund approval fails, and information of needing to pay the fee occurs; The execution module executes the refund and supplement of the electricity bill according to the results approved by the approval unit. The execution module includes a push unit and a refund and supplement unit. The push unit sends the information approved by the approval unit to the user by means of text messages, WeChat, and voice calls. The refund and supplement unit is connected to the online banking system of the power grid enterprise through API technology. The refund and supplement unit transfers the money in the online banking system of the power grid enterprise to the user according to the information approved by the approval unit.

[0021] The intelligent operation module is built based on RPA. The intelligent operation module is used to automatically control the operation and analysis module and the execution module to run.

[0022] An automatic electricity bill refund and supplement method based on RPA, as Figure 4 shown, includes the following steps: Step S1. Collect data and build an automatic system: Collect relevant operation information during the previous manual refund and supplement of electricity bills, analyze the operation information, and build an automatic refund and supplement system through RPA according to the analysis results; Step S2. Collect and optimize the refund and supplement plan system: Log in to the official website of the power grid enterprise to obtain the electricity bill refund and supplement plan, and optimize the automatic refund and supplement system according to the refund and supplement plan; Step S3. Open the system and receive requests: Open the information transmission function of the automatic refund and supplement system, and receive the request information and electricity consumption information sent by the user; Step S4. System operation and refund and supplement: The automatic refund and supplement system processes the request information and electricity consumption information sent by the user, and transfers the money in the online banking system of the power grid enterprise to the user or sends supplementary fee information to the user according to the processing results.

[0023] Only some exemplary embodiments of the present invention have been described by way of illustration. Undoubtedly, for those of ordinary skill in the art, the described embodiments can be modified in various different ways without departing from the spirit and scope of the present invention. Therefore, the above drawings and description are illustrative in nature and should not be construed as limiting the scope of protection of the claims of the present invention.

Claims

1. An automatic electricity fee refund system based on RPA, including a calculation and analysis module, an execution module and an intelligent operation module, characterized in that: The output end of the computing and analyzing module is communicatively connected to the input end of the executing module, and the output end of the intelligent operation module is communicatively connected to the input ends of the computing and analyzing module and the executing module respectively; The computing and analysis module includes an access unit, a computing unit, an accounting unit, a preview unit and an approval unit. The output end of the access unit is in communication connection with the input end of the computing unit. The output end of the computing unit is in communication connection with the input ends of the accounting unit and the preview unit respectively. The output ends of the accounting unit and the preview unit are in communication connection with the input end of the approval unit. The access unit is used to receive the electricity fee refund request information sent by the user and the electricity consumption sent by the user's electricity meter; The calculation unit calculates the user's electricity cost by calculating the electricity consumption; The accounting unit provides information on whether to refund or not based on the accounting between the electricity cost calculated by the calculation unit and the fee paid by the user; The preview unit previews the user's future power consumption by analyzing the access data of the access unit and the calculation data of the calculation unit; The approval unit is used to approve the results of the accounting unit; The execution module executes the refund of electricity fee according to the approval result of the approval unit.

2. According to the RPA-based automatic electricity fee refund system of claim 1, it is characterized in that: The access unit includes a request module and an electric meter data access module. The request module receives electricity fee refund request information sent by the user through three methods: text message, telephone communication and official website customer service communication. The electric meter data access module is connected to the user's electric meter through network communication, and the electric meter data access module can receive the electricity consumption monitored by the user's electric meter.

3. According to the RPA-based automatic electricity fee refund system of claim 1, it is characterized in that: The electricity fee formula used in the calculation process of the calculation unit is as follows:

4. Among them, For electricity charges, is the amount of electricity used by the user, n is the type of electricity price (including catalogue price, fund and surcharge, etc.), The amount for different types of electricity prices.

5. According to claim 3, the RPA-based automatic electricity fee refund system is characterized in that: The formula used in the calculation process of the accounting unit is as follows:

6. Among them, Pay fees for users, For the electricity fee, if D>0, the accounting unit obtains the information that the fee can be refunded, if D=0, the accounting unit obtains the information that the fee cannot be refunded, and if D<0, the accounting unit obtains the information that the fee needs to be supplemented.

7. The RPA-based automatic electricity fee refund system according to claim 4 is characterized in that: The preview steps of the preview unit are as follows: S1-1. Receive the power consumption data accessed by the access unit, the data calculated by the calculation unit, and analyze the data, based on which a positive correlation line graph is constructed; S1-2. Input the data into the preview formula for calculation, and judge the user's future electricity consumption data based on the calculation results. The preview formula is as follows:

8. Among them, The electricity consumption of users in the first month or first quarter, for The electricity consumption of users in the previous month or the previous quarter, for The electricity consumption of users in the next month or the next quarter, for For the user's electricity consumption in the last two months or the last two quarters, if R≥1, it indicates that the user's future electricity consumption is gradually increasing, and the preview unit gives a suggestion of not recommending refund and suggesting paying additional fees. If R<1, it indicates that the user's future electricity consumption is gradually decreasing, and the preview unit gives a suggestion of recommending refund.

9. The RPA-based automatic electricity fee refund system according to claim 5, characterized in that: The approval unit approves whether to refund the electricity fee based on the calculation results of the accounting unit and the preview results of the preview unit, and the specific cases are as follows: (4) Accounting unit: D = 0, rehearsal unit: regardless of R ≥ 1 or R < 1, the refund approval is not passed, and a suggestion for payment is given; (5) Accounting unit: D>0, rehearsal unit: if R≥1, the refund is approved and a recommendation not to refund is given; if R<1, the refund is approved and no recommendation is given; (6) Accounting unit: D<0, rehearsal unit: regardless of R≥1 or R<1, the refund approval is not passed and the information that the fee needs to be paid is generated.

10. The RPA-based automatic electricity fee refund system according to claim 1, characterized in that: The execution module includes a push unit and a refund unit. The push unit sends the approval information of the approval unit to the user through SMS, WeChat, or voice call.

11. The RPA-based automatic electricity fee refund system according to claim 7, characterized in that: The refund unit is connected with the online banking system of the power grid enterprise through API technology, and the refund unit transfers the money in the online banking system of the power grid enterprise to the user according to the information approved by the approval unit.

12. The RPA-based automatic electricity fee refund system according to claim 1, characterized in that: The intelligent operation module is built based on RPA, and is used to automatically control the operation and analysis module and the execution module.

13. An automatic electricity fee refund method based on RPA, characterized in that: The following steps are involved: Step S1. Collect data and build an automatic system: collect relevant operation information of previous manual electricity fee refunds, analyze the operation information, and build an automatic refund system through RPA based on the analysis results; Step S2. Recording the refund and subsidy optimization system: Log in to the official website of the power grid company to obtain the electricity fee refund and subsidy plan, and optimize the automatic refund and subsidy system according to the refund and subsidy plan; Step S3. Activate the system and receive requests: activate the information transmission function of the automatic refund system, and receive the request information and electricity usage information from the user; Step S4. System operation and refund: The automatic refund system processes the request information and electricity usage information sent by the user, and transfers the money in the power grid enterprise's online banking system to the user or sends the user the compensation information based on the processing results.

Images