Checking processing method for consigned fee and electronic equipment
By automating the process of verifying consignment expenses through the expense verification system, the problems of low efficiency and large errors in manual operation have been solved, achieving efficient and accurate verification of consignment expenses.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-12-17
- Publication Date
- 2026-04-03
AI Technical Summary
In existing technologies, the calculation of consignment fees relies on manual operation, which leads to low efficiency and is prone to calculation errors.
The expense verification system obtains the target processing instructions input by the user, automatically extracts data from the database, performs anomaly detection and comparison to ensure data accuracy, and uses the data warehouse system to verify the results, achieving fully automated verification throughout the entire process.
It improved the accuracy and efficiency of reconciliation and processing of consignment expenses, shortened the reconciliation cycle, reduced labor costs, and avoided errors caused by system self-checks.
Smart Images
Figure CN121786078A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of data processing technology, and more specifically, to a method and electronic device for verifying and processing consignment fees. Background Technology
[0002] In the current fund distribution business or asset management product distribution system, distribution fees are a significant incentive expenditure paid to distribution agencies to compensate them for their investments in customer acquisition, ongoing services, and product promotion. The calculation of distribution fees is a core step in the distribution fee processing procedure.
[0003] In existing technologies, the calculation of consignment fees mainly relies on manual operation. Specifically, at the beginning of each settlement cycle, relevant business personnel collect and organize multiple key data points, manually calculate the actual consignment fees, and manually verify the calculated consignment fees.
[0004] However, the existing consignment fee calculation process relies on manual operation, resulting in low efficiency. Furthermore, calculation errors may occur. Summary of the Invention
[0005] The purpose of this application is to address the shortcomings of the prior art by providing a method and electronic device for verifying and processing consignment expenses, thereby improving the accuracy and efficiency of the verification and processing of consignment expenses.
[0006] To achieve the above objectives, the technical solutions adopted in the embodiments of this application are as follows: In a first aspect, embodiments of this application provide a method for verifying consignment expenses, applied to an expense verification system, wherein the expense verification system includes a target database, and the method includes: The system obtains the target processing instruction input by the user through the user interface of the fee verification system. The target processing instruction includes: target product identifier, target distributor identifier, verification time range, and at least one element type. According to the target processing instruction, the data source to be processed is obtained from the target database, wherein the target database stores first sales data elements of multiple distributors for multiple products at multiple times and of multiple element types. Determine whether there are any anomalies in the first sales data elements of each element type in the data source to be processed, and obtain the first element verification result corresponding to each element type; If the verification results of the first element corresponding to each element type are all normal, then the first sales result is determined according to the data source to be processed. According to the target processing instruction, obtain the second sales data elements and the second sales results of various element types corresponding to the target processing instruction from the data warehouse system; Based on multiple types of first-level sales data elements, the first-level sales result, multiple types of second-level sales data elements, and the second-level sales result, determine whether to use the first-level sales result as the target sales result. If so, output the target sales result through the user interface.
[0007] Optionally, obtaining the data source to be processed from the target database according to the target processing instruction includes: The target processing instruction is parsed to obtain the target product identifier, the target distributor identifier, the verification time range, and the type of each element. Based on the target product identifier, the target distributor identifier, the verification time range, and the types of each element, construct a database query statement for the target database; Execute the database query statement to retrieve the data source to be processed from the target database.
[0008] Optionally, determining whether there are any anomalies in the first consignment data elements of each element type in the data source to be processed, and obtaining the first element verification result corresponding to each element type, includes: According to the time sequence, the data elements of the first sales data elements of each element type at each time and the data elements of the first sales data elements of the associated type corresponding to the element type at each time are obtained from the data source to be processed. Based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point, determine whether there are any abnormalities in the first sales data elements of each element type at each time point. Based on whether there are any anomalies in the first sales data elements of each element type at each time point, the verification results of the first element corresponding to each element type are obtained.
[0009] Optionally, determining whether there are anomalies in the first sales data elements of each element type at each time point based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point includes: If the element type is a customer maintenance fee rate type, and the associated type of the customer maintenance fee rate type is a product management fee rate type and a product sales service fee rate type, then based on the data elements of the first sales data element of the customer maintenance fee rate type at the first moment, the data elements of the first sales data element of the product sales service fee rate type at the first moment, and the data elements of the first sales data element of the product management fee rate type at the first moment, it is determined whether there is an anomaly in the first moment, wherein the first moment is any moment within the verification time range.
[0010] Optionally, determining whether the first sales data element of the customer maintenance fee rate type is abnormal at the first time point based on the data elements of the first sales data element of the customer maintenance fee rate type, the data elements of the first sales data element of the product sales service fee rate type, and the data elements of the first sales data element of the product management fee rate type at the first time point includes: Obtain the first sum of the sales service fee rate of the first agency data element of the product sales service fee rate type at the first time point and the management fee rate of the first agency data element of the product management fee rate type at the first time point; If the customer maintenance fee rate of the first sales data element of the customer maintenance fee rate type is less than or equal to the first sum at the first time, it is determined that the first sales data element of the customer maintenance fee rate type does not have any abnormality at the first time.
[0011] Optionally, determining whether the first sales data element of the customer maintenance fee rate type is abnormal at the first time point based on the data elements of the first sales data element of the customer maintenance fee rate type, the data elements of the first sales data element of the sales service fee rate type, and the data elements of the first sales data element of the product management fee rate type at the first time point includes: Acquire the first change in the sales service fee rate of the first agency data element of the sales service fee rate type at the first time point, the second change in the management fee rate of the first agency data element of the product management fee rate type at the first time point, and the third change in the customer maintenance fee rate of the first agency data element of the customer maintenance fee rate type at the first time point. If the first change and the second change have the same trend, and the trends of the first change and the second change are different from the trend of the third change, then it is determined that the first sales data element of the customer maintenance fee rate type is abnormal at the first moment.
[0012] Optionally, determining whether there are anomalies in the first sales data elements of each element type at each time point based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point includes: If the element type is a product share quantity type, then determine whether the product share quantity of the first sales data element of the product share quantity type is missing at the first moment; If there are no missing data elements, it is determined that the first sales data element of the product share quantity type does not have any abnormalities at the first time point.
[0013] Optionally, determining the first sales result based on the data source to be processed includes: Obtain the data elements of the first sales data elements of each element type at each time point from the data source to be processed; The first sales result at each time point is determined based on the data elements and the preset formula.
[0014] Optionally, determining whether to use the first sales result as the target sales result based on the first sales data element of multiple element types, the first sales result, the second sales data element of multiple element types, and the second sales result includes: The first sales results at each specified time point are compared with the second sales results at each specified time point to determine the result error; If the result error meets the preset condition, then the first sales result at each time point is taken as the target sales result at each time point. If the result error does not meet the preset conditions, then the difference information is determined based on the first sales data element of the multiple element types and the second sales data element of the multiple element types, and the difference information is displayed.
[0015] Secondly, embodiments of this application also provide a device for verifying and processing consignment fees, the device comprising: The acquisition module is used to acquire the target processing instruction input by the user through the user interface of the fee verification system. The target processing instruction includes: target product identifier, target distributor identifier, verification time range, and at least one element type. The acquisition module is specifically used to acquire the data source to be processed from the target database according to the target processing instruction. The target database stores first sales data elements of multiple distributors for multiple products at multiple times and of multiple element types. The first determining module is used to determine whether there are any abnormalities in the first sales data elements of each element type in the data source to be processed, and to obtain the first element verification result corresponding to each element type. The first determining module is specifically used to determine the first sales result based on the data source to be processed if the first element verification results corresponding to each element type are all normal. The acquisition module is specifically used to acquire, according to the target processing instruction, the second sales data elements of multiple element types corresponding to the target processing instruction and the second sales results from the data warehouse system; The second determining module is used to determine whether to take the first sales result as the target sales result based on multiple types of first sales data elements, the first sales result, multiple types of second sales data elements, and the second sales result. If so, the target sales result is output through the user interface.
[0016] Optionally, the acquisition module is specifically used for: The target processing instruction is parsed to obtain the target product identifier, the target distributor identifier, the verification time range, and the type of each element. Based on the target product identifier, the target distributor identifier, the verification time range, and the types of each element, construct a database query statement for the target database; Execute the database query statement to retrieve the data source to be processed from the target database.
[0017] Optionally, the first determining module is specifically used for: According to the time sequence, the data elements of the first sales data elements of each element type at each time and the data elements of the first sales data elements of the associated type corresponding to the element type at each time are obtained from the data source to be processed. Based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point, determine whether there are any abnormalities in the first sales data elements of each element type at each time point. Based on whether there are any anomalies in the first sales data elements of each element type at each time point, the verification results of the first element corresponding to each element type are obtained.
[0018] Optionally, the first determining module is specifically used for: If the element type is a customer maintenance fee rate type, and the associated type of the customer maintenance fee rate type is a product management fee rate type and a product sales service fee rate type, then based on the data elements of the first sales data element of the customer maintenance fee rate type at the first moment, the data elements of the first sales data element of the product sales service fee rate type at the first moment, and the data elements of the first sales data element of the product management fee rate type at the first moment, it is determined whether there is an anomaly in the first moment, wherein the first moment is any moment within the verification time range.
[0019] Optionally, the first determining module is specifically used for: Obtain the first sum of the sales service fee rate of the first agency data element of the product sales service fee rate type at the first time point and the management fee rate of the first agency data element of the product management fee rate type at the first time point; If the customer maintenance fee rate of the first sales data element of the customer maintenance fee rate type is less than or equal to the first sum at the first time, it is determined that the first sales data element of the customer maintenance fee rate type does not have any abnormality at the first time.
[0020] Optionally, the first determining module is specifically used for: Acquire the first change in the sales service fee rate of the first agency data element of the sales service fee rate type at the first time point, the second change in the management fee rate of the first agency data element of the product management fee rate type at the first time point, and the third change in the customer maintenance fee rate of the first agency data element of the customer maintenance fee rate type at the first time point. If the first change and the second change have the same trend, and the trends of the first change and the second change are different from the trend of the third change, then it is determined that the first sales data element of the customer maintenance fee rate type is abnormal at the first moment.
[0021] Optionally, the first determining module is specifically used for: If the element type is a product share quantity type, then determine whether the product share quantity of the first sales data element of the product share quantity type is missing at the first moment; If there are no missing data elements, it is determined that the first sales data element of the product share quantity type does not have any abnormalities at the first time point.
[0022] Optionally, the first determining module is specifically used for: Obtain the data elements of the first sales data elements of each element type at each time point from the data source to be processed; The first sales result at each time point is determined based on the data elements and the preset formula.
[0023] Optionally, the second determining module is specifically used for: The first sales results at each specified time point are compared with the second sales results at each specified time point to determine the result error; If the result error meets the preset condition, then the first sales result at each time point is taken as the target sales result at each time point. If the result error does not meet the preset conditions, then the difference information is determined based on the first sales data element of the multiple element types and the second sales data element of the multiple element types, and the difference information is displayed.
[0024] Thirdly, embodiments of this application also provide an electronic device, including: a processor, a memory, and a bus. The memory stores program instructions executable by the processor. When the application runs, the processor communicates with the memory via the bus, and the processor executes the program instructions to perform the steps of the consignment fee verification processing method described in the first aspect.
[0025] Fourthly, embodiments of this application also provide a computer-readable storage medium storing a computer program, which is read and executes the steps of the consignment fee verification method described in the first aspect.
[0026] The beneficial effects of this application are: This application provides a method and electronic device for verifying and processing consignment expenses. By acquiring the target processing instructions input by the user through the user interface of the expense verification system, and retrieving the data source to be processed from the target database according to the target processing instructions, the verification task is started in a structured and configurable manner. Users can accurately define the scope of verification processing through the user interface, avoiding omissions or misselections in traditional manual operations. The system determines whether there are any anomalies in the first-tier sales data elements of each element type in the data source to be processed, and obtains the first-tier verification results for each element type. If the first-tier verification results for each element type are normal, the first-tier sales result is determined based on the data source to be processed. This system checks the sales data elements before determining the first-tier sales result to ensure the accuracy of the data elements involved in the calculation, forming a control logic of prior verification before calculation. This ensures the reliability of the calculation basis and avoids obtaining incorrect sales results based on missing or erroneous data elements. Based on the target processing instruction, the system retrieves the second-tier sales data elements and second-tier sales results for multiple element types corresponding to the target processing instruction from the data warehouse system. Based on the multiple types of first-tier sales data elements, first-tier sales results, multiple types of second-tier sales data elements, and second-tier sales results, the system determines whether to use the first-tier sales result as the target sales result. If so, the target sales result is output through the user interface. By determining whether the first-tier sales result is the target sales result based on the results from two sources and two paths, the system ensures that the output target sales result is more accurate, avoids "same-source deviation" caused by system self-checking, and improves the credibility of the target sales result. By constructing a complete closed-loop process of "user command-driven, local data extraction, anomaly detection, local calculation, external result comparison, and automatic decision-making", the entire process is automated, which significantly shortens the verification cycle, reduces labor costs, and improves the accuracy of sales results. Attached Figure Description
[0027] To more clearly illustrate the technical solutions of the embodiments of this application, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of this application and should not be regarded as a limitation of the scope. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.
[0028] Figure 1 A flowchart illustrating a method for verifying consignment fees provided in this application embodiment; Figure 2 A flowchart illustrating another method for verifying consignment fees provided in this application embodiment; Figure 3 A flowchart illustrating another method for verifying and processing consignment fees provided in this application embodiment; Figure 4A flowchart illustrating another method for verifying consignment fees provided in this application embodiment; Figure 5 A schematic diagram of an apparatus for verifying and processing consignment fees provided in an embodiment of this application; Figure 6 This is a structural block diagram of an electronic device provided in an embodiment of this application. Detailed Implementation
[0029] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. It should be understood that the accompanying drawings in this application are for illustrative and descriptive purposes only and are not intended to limit the scope of protection of this application. Furthermore, it should be understood that the schematic drawings are not drawn to scale. The flowcharts used in this application illustrate operations implemented according to some embodiments of this application. It should be understood that the operations in the flowcharts may not be implemented in sequence, and steps without logical contextual relationships may be reversed or implemented simultaneously. In addition, those skilled in the art, guided by the content of this application, may add one or more other operations to the flowcharts, or remove one or more operations from the flowcharts.
[0030] Furthermore, the described embodiments are merely some, not all, of the embodiments of this application. The components of the embodiments of this application described and illustrated herein can typically be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of this application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely to illustrate selected embodiments of the application. All other embodiments obtained by those skilled in the art based on the embodiments of this application without inventive effort are within the scope of protection of this application.
[0031] It should be noted that the term "comprising" will be used in the embodiments of this application to indicate the presence of the features declared thereafter, but does not exclude the addition of other features.
[0032] Optionally, the consignment fee verification method provided in this application embodiment is applied to an electronic device equipped with a fee verification system. This electronic device can be, for example, a mobile phone, tablet computer, laptop computer, PDA, desktop computer, or other terminal device with computing power and display capabilities, or it can be a server. Specifically, it can be applied to applications in the terminal device, such as mobile phone applications (APPs) or computer application systems.
[0033] The following is a detailed explanation of the specific implementation process of the consignment fee verification process provided in the embodiments of this application.
[0034] Figure 1 This is a flowchart illustrating a method for verifying consignment fees provided in an embodiment of this application. The executing entity of this method is, as described above, the fee verification system in an electronic device. Figure 1 As shown, the method includes: S101. Obtain the target processing instruction input by the user through the user interface of the fee verification system.
[0035] The target processing instruction may include: target product identifier, target distributor identifier, verification time range, and at least one element type. Element types may include, but are not limited to: product accrual fee type, product sales service fee rate type, product management fee rate type, distributor customer maintenance fee rate type, and distributor product share quantity type. The target product refers to the product under the target distributor. This target processing instruction is the trigger signal for the entire verification process, instructing the system to perform automated verification operations on data elements for a specific product, a specific distributor, and a specific time range. The at least one element type refers to the type of data element to be verified across different dimensions.
[0036] Among them, the target product identifier is the unique identifier of the product that needs to be verified, such as fund code, wealth management product number, etc.; the target distributor identifier is the identifier of the institution that needs to be verified, such as the unique identifier of a bank, securities company, or third-party sales platform; the verification time range is the time interval that needs to be verified, such as "January 1, 2024 to December 31, 2024", which can be set by daily, monthly, quarterly or annual granularity.
[0037] Optionally, the user interface can be a graphical interface, such as a web-based management backend, a desktop application, or a mobile app. Users can complete instruction settings through various input components such as text input boxes, drop-down menus, and calendar controls. The input method for this target processing instruction is not limited to manual entry; it can also support receiving verification task requests pushed by external systems via API interfaces, enabling integration and linkage with other business systems. For example, the financial settlement system can automatically generate verification tasks at the beginning of each month and send the target processing instructions to the expense verification system, thereby achieving an unattended periodic verification process.
[0038] S102. Obtain the data source to be processed from the target database according to the target processing instructions.
[0039] The target database stores first-level resale data elements of multiple resellers for multiple products at multiple times, covering multiple element types.
[0040] Optionally, the target database is a pre-built and continuously maintained data storage system used to centrally store first-hand sales data elements of multiple distributors for various products, such as funds and wealth management products, at different points in time. This target database can be implemented using a relational database or a distributed data warehouse architecture, and data is collected and updated from business systems, such as transaction systems, fee management systems, and share registration systems, through a scheduled synchronization mechanism to ensure data timeliness and consistency.
[0041] S103. Determine whether there are any anomalies in the first sales data elements of each element type in the data source to be processed, and obtain the first element verification results corresponding to each element type.
[0042] The first element verification result indicates whether there are any anomalies in the first sales data element of a certain element type at a certain time. The first element verification result can be "normal" or "abnormal", or it can be determined by a score. Then, based on the first element verification result corresponding to each element type, it is determined whether the first sales data element of each element type should be used as input for subsequent calculation of sales results.
[0043] S104. Determine whether the verification result of the first element corresponding to each element is normal.
[0044] Specifically, if the verification results of the first element corresponding to each element type are all normal, then the following step S105 is executed; if the verification results of the first element corresponding to each element type are abnormal, then the following step S1010 is executed.
[0045] S105. Determine the first sales result based on the data source to be processed.
[0046] Specifically, the first sales result can be determined based on the first sales data elements of various element types in the data source to be processed.
[0047] S106. Based on the target processing instruction, retrieve the second sales data elements and second sales results of various element types corresponding to the target processing instruction from the data warehouse system.
[0048] Here, the second sales data elements of multiple element types corresponding to the target processing instruction and the second sales results refer to the second sales elements of multiple element types corresponding to the target processing instruction stored in other systems outside the expense verification system, as well as the second sales results determined by other systems based on the second sales data elements of multiple element types stored therein. These other systems could be, for example, enterprise-level data warehouse systems.
[0049] Optionally, the second-level sales data elements stored in the data warehouse system for multiple element types, including target products, target distributors, and verification time ranges, can be the same as or different from the first-level sales data elements stored in the expense verification system for the same target products, target distributors, and verification time ranges.
[0050] For example, the data warehouse system can obtain second-generation sales data elements for target product A0, target distributor A1, verification time range T1~T2 and multiple element types, as well as the second-generation sales results determined by the data warehouse system based on the second-generation sales data elements of multiple element types.
[0051] S107. Based on the various types of first-tier sales data elements, first-tier sales results, various types of second-tier sales data elements, and second-tier sales results, determine whether to use the first-tier sales results as the target sales results.
[0052] Specifically, if it is determined that the first sales result will be used as the target sales result, then step S108 is executed; if it is determined that the first sales result will not be used as the target sales result, then step S109 is executed.
[0053] S108. Output the target sales results through the user interface.
[0054] S109. Output the difference information between the first and second sales results.
[0055] Specifically, the difference information between the first and second sales results refers to the difference data elements between the first and second sales data elements.
[0056] For example, the first and second data elements of the product sales service fee rate type are different, including target product A0, target distributor A1, and verification time range T1~T2.
[0057] S1010, Output an error message.
[0058] Optionally, the output error message is used to indicate that the first sales data element corresponding to a certain element type is abnormal. Then, the user can correct the first sales data element corresponding to the element type based on the error message to obtain a new first sales data element corresponding to the element type, that is, to obtain a new data source to be processed, and then determine the first sales result based on the new data source to be processed.
[0059] In this embodiment, the system acquires the target processing instructions input by the user through the user interface of the expense verification system, and retrieves the data source to be processed from the target database according to the target processing instructions, thus realizing the structured and configurable startup of the verification task. Users can accurately define the scope of verification processing through the user interface, avoiding omissions or misselections in traditional manual operations. The system determines whether there are any anomalies in the first-tier sales data elements of each element type in the data source to be processed, and obtains the first-tier verification results for each element type. If the first-tier verification results for each element type are normal, the first-tier sales result is determined based on the data source to be processed. This system checks the sales data elements before determining the first-tier sales result to ensure the accuracy of the data elements involved in the calculation, forming a control logic of prior verification before calculation. This ensures the reliability of the calculation basis and avoids obtaining incorrect sales results based on missing or erroneous data elements. Based on the target processing instruction, the system retrieves the second-tier sales data elements and second-tier sales results for multiple element types corresponding to the target processing instruction from the data warehouse system. Based on the multiple types of first-tier sales data elements, first-tier sales results, multiple types of second-tier sales data elements, and second-tier sales results, the system determines whether to use the first-tier sales result as the target sales result. If so, the target sales result is output through the user interface. By determining whether the first-tier sales result is the target sales result based on the results from two sources and two paths, the system ensures that the output target sales result is more accurate, avoids "same-source deviation" caused by system self-checking, and improves the credibility of the target sales result. By constructing a complete closed-loop process of "user command-driven, local data extraction, anomaly detection, local calculation, external result comparison, and automatic decision-making", the entire process is automated, which significantly shortens the verification cycle, reduces labor costs, and improves the accuracy of sales results.
[0060] Figure 2 A flowchart illustrating another method for verifying consignment fees provided in this application embodiment is shown below. Figure 2 As shown, the step S102 above, which involves retrieving the data source to be processed from the target database according to the target processing instruction, may include: S201. Parse the target processing instructions to obtain the target product identifier, target distributor identifier, verification time range, and the type of each element.
[0061] Specifically, semantic parsing and parameter extraction can be performed on the target processing instructions. This process can be completed by the instruction parsing module, whose function is to decompose the structured or semi-structured instructions input by the user into multiple parameters that can be recognized and processed by the system. Specifically, the target product identifier, target distributor identifier, verification time range, and the types of each element can be obtained.
[0062] S202. Based on the target product identifier, target distributor identifier, verification time range, and the type of each element, construct a database query statement for the target database.
[0063] Optionally, after parsing and obtaining the parameters from the target processing instruction, the process proceeds to the query statement generation stage. Specifically, high-level business parameters can be converted into a query language executable by the underlying database. For example, the generated database query statement can be Structured Query Language (SQL), thereby achieving semantic mapping from the application layer to the data layer. One or more database query statements can be constructed based on preset template rules or dynamic concatenation algorithms.
[0064] S203. Execute a database query statement to retrieve the data source to be processed from the target database.
[0065] Optionally, after the query statement is generated, the system sends the generated database query statement to the target database for execution via the database connection component. The target database can be a locally deployed database or a cloud database service. After executing the database query statement, the database returns the data source to be processed. This data source to be processed may, for example, include the data elements of the first sales data elements of each element type at each time point within the time range t1 to tn. For example, it can include the product sales service fee rate 1, product management fee rate 1, and customer maintenance fee rate 1 of the first-tier sales data element of the product sales service fee rate type at time t1; the product sales service fee rate 2, product management fee rate 2, and customer maintenance fee rate 2 of the first-tier sales data element of the product sales service fee rate type at time t2; and the product sales service fee rate n, product management fee rate n, and customer maintenance fee rate n of the first-tier sales data element of the product sales service fee rate type at time tn.
[0066] Figure 3 A flowchart illustrating another method for verifying consignment fees provided in this application embodiment is shown below. Figure 3 As shown, in S103 above, it is determined whether there are any anomalies in the first sales data elements of each element type in the data source to be processed, and the first element verification results corresponding to each element type are obtained, which may include: S301. According to the time sequence, obtain the data elements of the first sales data elements of each element type at each time point from the data source to be processed, as well as the data elements of the first sales data elements of the associated type corresponding to the element type at each time point.
[0067] For example, if the associated types corresponding to the customer maintenance fee rate type can include the product sales service fee rate type and the product management fee rate type, then for the customer maintenance fee rate type, the customer maintenance fee rate 1 of the first sales data element of the customer maintenance fee rate type at time t1 can be obtained from the data source to be processed, as well as the data elements of the first sales data element of the associated type of the customer maintenance fee rate type at time t1. That is, the product sales service fee rate 1 of the first sales data element of the product sales service fee rate type and the product management fee rate 1 of the first sales data element of the product management fee rate type can be obtained at time t1. In other words, for the customer maintenance fee rate type, the customer maintenance fee rate 1 and the product sales service fee rate 1 and product management fee rate 1 corresponding to the customer maintenance fee rate type can be obtained.
[0068] Then, for each element type, we can obtain the data elements of the first sales data element of that element type at each time point, as well as the data elements of the first sales data element of the associated type of that element type at each time point.
[0069] S302. Based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point, determine whether there are any anomalies in the first sales data elements of each element type at each time point.
[0070] For example, for the customer maintenance fee rate type, it can be determined whether there is an anomaly in the customer maintenance fee rate 1 at time t1 based on the customer maintenance fee rate 1 and the product sales service fee rate 1 and product management fee rate 1 corresponding to the customer maintenance fee rate type.
[0071] S303. Based on whether there are any anomalies in the first sales data elements of each element type at each time point, obtain the first element verification results corresponding to each element type.
[0072] The first element verification result refers to whether the first sales data element of each element type is normal at each time point.
[0073] In this embodiment, by time-aligned extraction, multi-factor joint judgment, and time-by-time anomaly identification, the first sales data elements of each element type at each time point are detected to determine whether the first sales data elements of each element type at each time point are normal. This realizes the automation, refinement, and interpretability of data quality assessment in the sales fee verification process, forming a closed-loop, controllable, and highly reliable front-end verification system, laying a solid foundation for the subsequent generation of reliable first sales results.
[0074] Optionally, in step S302 above, determining whether there are any anomalies in the first sales data elements of each element type at each time point based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated types corresponding to the element types at each time point may include: If the data type is Customer Maintenance Fee Rate, and the associated data types of Customer Maintenance Fee Rate are Product Management Fee Rate and Product Sales Service Fee Rate, then based on the data elements of the first sales data element of Customer Maintenance Fee Rate at the first moment, the data elements of the first sales data element of Product Sales Service Fee Rate at the first moment, and the data elements of the first sales data element of Product Management Fee Rate at the first moment, determine whether there is an anomaly in the first sales data element of Customer Maintenance Fee Rate at the first moment. Here, the first moment is any moment within the verification time range.
[0075] Optionally, determining whether the first-tier data element of the customer maintenance fee rate type is abnormal at the first moment, based on the data elements of the first-tier data element of the customer maintenance fee rate type, the first-tier data element of the product sales service fee rate type, and the first-tier data element of the product management fee rate type at the first moment, may include: Obtain the first sum of the first agency sales data element (product sales service fee rate type) and the first agency management fee rate (product management fee rate type) at the first moment. For example, obtain the first sum A of product sales service fee rate 1 and product management fee rate 1.
[0076] If the customer maintenance fee rate of the first sales data element of the customer maintenance fee rate type is less than or equal to the first sum at the first moment, it is determined that there is no anomaly in the first sales data element of the customer maintenance fee rate type at the first moment.
[0077] For example, if the customer maintenance fee rate 1 is less than or equal to the first sum A, then it is determined that the customer maintenance fee rate 1 is not abnormal. If the customer maintenance fee rate 1 is greater than the first sum A, then it is determined that the customer maintenance fee rate 1 is abnormal, and a prompt message indicating that the first sales data element of the customer maintenance fee rate type at time t1 is abnormal is output, along with a normal range value, so that the user can correct the first sales data element of the customer maintenance fee rate type at time t1. After the first sales data element of the customer maintenance fee rate type at time t1 is corrected, the corrected customer maintenance fee rate at time t1 is updated to the data source to be processed, so that the subsequent calculation of the first sales result can be performed based on the corrected first sales data element of the customer maintenance fee rate type at time t1.
[0078] Optionally, determining whether the first-tier data element of the customer maintenance fee rate type is abnormal at the first moment, based on the data elements of the first-tier data element of the customer maintenance fee rate type, the first-tier data element of the product sales service fee rate type, and the first-tier data element of the product management fee rate type at the first moment, may include: The data includes the first change in the sales service fee rate (of the first sales agent data element, sales service fee rate type), the second change in the management fee rate (of the first sales agent data element, product management fee rate type), and the third change in the customer maintenance fee rate (of the first sales agent data element, customer maintenance fee rate type) at the first moment. Specifically, the first change refers to the trend of the sales service fee rate at the first moment compared to the previous moment; the second change refers to the trend of the product management fee rate at the first moment compared to the previous moment; and the third change refers to the trend of the customer maintenance fee rate at the first moment compared to the previous moment.
[0079] If the first change and the second change have the same trend, and the trends of the first change and the second change are different from the trend of the third change, then the first sales data element of the customer maintenance fee rate type is abnormal at the first moment.
[0080] For example, if the product management fee rate at the first moment shows an increasing trend compared to the product management fee rate at the previous moment, and the product management fee rate at the first moment shows an increasing trend compared to the product management fee rate at the previous moment, but the customer maintenance fee rate at the first moment shows no change or a decrease compared to the customer maintenance fee rate at the previous moment, then the customer maintenance fee rate at the first moment is determined to be abnormal. In this case, a prompt message is output to indicate that the customer maintenance fee rate at the first moment is abnormal, so that the customer maintenance fee rate at the first moment can be adjusted, and the adjusted customer maintenance fee rate at the first moment is updated in the pending data source. If the trends of the product management fee rate at the first moment compared to the product management fee rate at the previous moment, the product management fee rate at the first moment compared to the product management fee rate at the previous moment, and the customer maintenance fee rate at the first moment compared to the customer maintenance fee rate at the previous moment are all the same, then the customer maintenance fee rate at the first moment is determined to be normal.
[0081] Optionally, determining whether the first-tier data element of the customer maintenance fee rate type is abnormal at the first moment, based on the data elements of the first-tier data element of the customer maintenance fee rate type, the first-tier data element of the product sales service fee rate type, and the first-tier data element of the product management fee rate type at the first moment, may include: Specifically, if the element type is "Product Share Quantity," then it is determined whether the product share quantity of the first distribution data element of the "Product Share Quantity" type is missing at the first moment. If there is no missing quantity, it is determined that the first distribution data element of the "Product Share Quantity" type is not abnormal at the first moment; if there is a missing quantity, it is determined that the first distribution data element of the "Product Share Quantity" type is abnormal at the first moment, and a prompt message indicating that the product share quantity at the first moment is missing is output so that the user can complete the product share quantity at the first moment, and the completed product share quantity at the first moment is updated in the data source to be processed.
[0082] Figure 4 A flowchart illustrating another method for verifying consignment fees provided in this application embodiment is shown below. Figure 4 As shown, determining the first sales result based on the data source to be processed in S105 above may include: S401. Obtain the data elements of the first sales data elements of each element type at each time point from the data source to be processed.
[0083] Optionally, the data elements obtained in step S401 refer to the data elements that have been tested to ensure that the first-generation sales data elements of each element type are normal at each time.
[0084] For example, at time t1, the data obtained include: Customer maintenance fee rate 1 (customer maintenance fee rate type), Product sales service fee rate 1 (product sales service fee rate type), Product management fee rate 1 (product management fee rate type), Product accrual fee 1 (product accrual fee type), and Product share quantity 1 (product share quantity type).
[0085] S402. Determine the first sales result at each time point based on each data element and the preset formula.
[0086] The default formula is: Distributor fee = (Distributor's share / Total number of product shares) × (Product sales expenses + Product fixed management fees) × (Customer maintenance fee rate / (Product fixed management fee rate + Product sales service fee rate)).
[0087] Specifically, the data elements of the first-tier sales data elements of each element type obtained in step S401 at each time point can be substituted into the preset formula to obtain the first-tier sales results at each time point. Among these, product accrued sales expenses and product accrued fixed management fees are both included in the product accrued expenses of the first-tier sales data elements of the product accrued expense type at each time point. Total product share quantity refers to the data elements of the first-tier sales data elements of the product share quantity type at each time point. Product fixed management fee rate refers to the data elements of the first-tier sales data elements of the product management fee rate type at each time point.
[0088] Optionally, determining whether to use the first sales result as the target sales result based on multiple types of first sales data elements, first sales results, multiple types of second sales data elements, and second sales results in S107 above may include: Specifically, the first sales results at each time point are compared with the second sales results at each time point to determine the result error. For example, the first sales results at time t1 are compared with the second sales results at time t1 to obtain the result error at time t1.
[0089] If the result error meets the preset conditions, the first sales result at each time point is taken as the target sales result at that time point. If the result error does not meet the preset conditions, the difference information is determined based on multiple types of first sales data elements and multiple types of second sales data elements, and the difference information is displayed. If the result error does not meet the preset conditions, it indicates that there is a difference in the calculation between the first sales result and the second sales result. At this time, the data elements of the first sales data elements of multiple element types used to calculate the first sales result at the first time point are compared with the data elements of the second sales data elements of multiple element types used to calculate the second sales result at the first time point. The data elements of the first sales data elements of each element type that have differences at the first time point can be identified. The data elements of each element type that have differences and the data elements of the first sales data elements of each element type at the first time point can be marked for users to view.
[0090] Figure 5 A schematic diagram of an apparatus for verifying and processing consignment fees provided in this application embodiment is shown below. Figure 5 As shown, the device includes: The acquisition module 501 is used to acquire the target processing instruction input by the user through the user interface of the cost verification system. The target processing instruction includes: target product identifier, target distributor identifier, verification time range and at least one element type. The acquisition module 501 is specifically used to acquire the data source to be processed from the target database according to the target processing instruction, wherein the target database stores first sales data elements of multiple distributors for multiple products at multiple times and of multiple element types. The first determination module 502 is used to determine whether there are any abnormalities in the first sales data elements of each element type in the data source to be processed, and to obtain the first element verification result corresponding to each element type. The first determining module 502 is specifically used to determine the first sales result based on the data source to be processed if the first element verification results corresponding to each element type are all normal. The acquisition module is specifically used to acquire, according to the target processing instruction, the second sales data elements of multiple element types corresponding to the target processing instruction and the second sales results from the data warehouse system; The second determining module 503 is used to determine whether to take the first sales result as the target sales result based on the first sales data elements of multiple types, the first sales result, the second sales data elements of multiple types, and the second sales result. If so, the target sales result is output through the user interface.
[0091] Optionally, the acquisition module 501 is specifically used for: The target processing instruction is parsed to obtain the target product identifier, the target distributor identifier, the verification time range, and the type of each element. Based on the target product identifier, the target distributor identifier, the verification time range, and the types of each element, construct a database query statement for the target database; Execute the database query statement to retrieve the data source to be processed from the target database.
[0092] Optionally, the first determining module 502 is specifically used for: According to the time sequence, the data elements of the first sales data elements of each element type at each time and the data elements of the first sales data elements of the associated type corresponding to the element type at each time are obtained from the data source to be processed. Based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point, determine whether there are any abnormalities in the first sales data elements of each element type at each time point. Based on whether there are any anomalies in the first sales data elements of each element type at each time point, the verification results of the first element corresponding to each element type are obtained.
[0093] Optionally, the first determining module 502 is specifically used for: If the element type is a customer maintenance fee rate type, and the associated type of the customer maintenance fee rate type is a product management fee rate type and a product sales service fee rate type, then based on the data elements of the first sales data element of the customer maintenance fee rate type at the first moment, the data elements of the first sales data element of the product sales service fee rate type at the first moment, and the data elements of the first sales data element of the product management fee rate type at the first moment, it is determined whether there is an anomaly in the first moment, wherein the first moment is any moment within the verification time range.
[0094] Optionally, the first determining module 502 is specifically used for: Obtain the first sum of the sales service fee rate of the first agency data element of the product sales service fee rate type at the first time point and the management fee rate of the first agency data element of the product management fee rate type at the first time point; If the customer maintenance fee rate of the first sales data element of the customer maintenance fee rate type is less than or equal to the first sum at the first time, it is determined that the first sales data element of the customer maintenance fee rate type does not have any abnormality at the first time.
[0095] Optionally, the first determining module 502 is specifically used for: Acquire the first change in the sales service fee rate of the first agency data element of the sales service fee rate type at the first time point, the second change in the management fee rate of the first agency data element of the product management fee rate type at the first time point, and the third change in the customer maintenance fee rate of the first agency data element of the customer maintenance fee rate type at the first time point. If the first change and the second change have the same trend, and the trends of the first change and the second change are different from the trend of the third change, then it is determined that the first sales data element of the customer maintenance fee rate type is abnormal at the first moment.
[0096] Optionally, the first determining module 502 is specifically used for: If the element type is a product share quantity type, then determine whether the product share quantity of the first sales data element of the product share quantity type is missing at the first moment; If there are no missing data elements, it is determined that the first sales data element of the product share quantity type does not have any abnormalities at the first time point.
[0097] Optionally, the first determining module 502 is specifically used for: Obtain the data elements of the first sales data elements of each element type at each time point from the data source to be processed; The first sales result at each time point is determined based on the data elements and the preset formula.
[0098] Optionally, the second determining module 503 is specifically used for: The first sales results at each specified time point are compared with the second sales results at each specified time point to determine the result error; If the result error meets the preset condition, then the first sales result at each time point is taken as the target sales result at each time point. If the result error does not meet the preset conditions, then the difference information is determined based on the first sales data element of the multiple element types and the second sales data element of the multiple element types, and the difference information is displayed. Figure 6 This is a structural block diagram of an electronic device 400 provided in an embodiment of this application. (See diagram below.) Figure 6 As shown, the electronic device may include: a processor 401 and a memory 402.
[0099] Optionally, a bus 403 may also be included, wherein the memory 402 is used to store machine-readable instructions executable by the processor 401. When the electronic device 400 is running, the processor 401 and the memory 402 communicate with each other via the bus 403, and the processor 401 executes the machine-readable instructions to perform the method steps in the above method embodiments.
[0100] This application also provides a computer-readable storage medium storing a computer program, which, when run by a processor, executes the method steps described in the above-described method for verifying consignment fees.
[0101] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems and devices described above can be compared with the corresponding processes in the method embodiments, and will not be repeated here. In the several embodiments provided in this application, it should be understood that the disclosed systems, devices, and methods can be implemented in other ways. The device embodiments described above are merely illustrative. For example, the division of modules is only a logical functional division; in actual implementation, there may be other division methods. Furthermore, multiple modules or components may be combined or integrated into another system, or some features may be ignored or not executed. Another point is that the displayed or discussed mutual coupling or direct coupling or communication connection may be through some communication interfaces; the indirect coupling or communication connection of devices or modules may be electrical, mechanical, or other forms.
[0102] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. If the functions are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes: USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, optical disks, and other media capable of storing program code.
[0103] The above are merely specific embodiments of this application, but the scope of protection of this application is not limited thereto. Any changes or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the scope of protection of this application.
Claims
1. A method for verifying and processing consignment expenses, characterized in that, The method is applied to a cost reconciliation system, which includes a target database, and includes: The system obtains the target processing instruction input by the user through the user interface of the fee verification system. The target processing instruction includes: target product identifier, target distributor identifier, verification time range, and at least one element type. According to the target processing instruction, the data source to be processed is obtained from the target database, wherein the target database stores first sales data elements of multiple distributors for multiple products at multiple times and of multiple element types. Determine whether there are any anomalies in the first sales data elements of each element type in the data source to be processed, and obtain the first element verification result corresponding to each element type; If the verification results of the first element corresponding to each element type are all normal, then the first sales result is determined according to the data source to be processed. According to the target processing instruction, obtain the second sales data elements and the second sales results of various element types corresponding to the target processing instruction from the data warehouse system; Based on multiple types of first-level sales data elements, the first-level sales result, multiple types of second-level sales data elements, and the second-level sales result, determine whether to use the first-level sales result as the target sales result. If so, output the target sales result through the user interface.
2. The method for verifying and processing consignment expenses according to claim 1, characterized in that, The step of obtaining the data source to be processed from the target database according to the target processing instruction includes: The target processing instruction is parsed to obtain the target product identifier, the target distributor identifier, the verification time range, and the type of each element. Based on the target product identifier, the target distributor identifier, the verification time range, and the types of each element, construct a database query statement for the target database; Execute the database query statement to retrieve the data source to be processed from the target database.
3. The method for verifying and processing consignment expenses according to claim 1, characterized in that, The step of determining whether there are any anomalies in the first sales data elements of each element type in the data source to be processed, and obtaining the first element verification result corresponding to each element type, includes: According to the time sequence, the data elements of the first sales data elements of each element type at each time and the data elements of the first sales data elements of the associated type corresponding to the element type at each time are obtained from the data source to be processed. Based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated type corresponding to the element type at each time point, determine whether there are any abnormalities in the first sales data elements of each element type at each time point. Based on whether there are any anomalies in the first sales data elements of each element type at each time point, the verification results of the first element corresponding to each element type are obtained.
4. The method for verifying and processing consignment expenses according to claim 3, characterized in that, The step of determining whether there are any anomalies in the first sales data elements of each element type at each time point, based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated types corresponding to each element type at each time point, includes: If the element type is a customer maintenance fee rate type, and the associated type of the customer maintenance fee rate type is a product management fee rate type and a product sales service fee rate type, then based on the data elements of the first sales data element of the customer maintenance fee rate type at the first moment, the data elements of the first sales data element of the product sales service fee rate type at the first moment, and the data elements of the first sales data element of the product management fee rate type at the first moment, it is determined whether there is an anomaly in the first moment, wherein the first moment is any moment within the verification time range.
5. The method for verifying and processing consignment expenses according to claim 4, characterized in that, The step of determining whether the first sales data element of the customer maintenance fee rate type is abnormal at the first moment, based on the data elements of the first sales data element of the customer maintenance fee rate type, the data elements of the first sales data element of the product sales service fee rate type, and the data elements of the first sales data element of the product management fee rate type at the first moment, includes: Obtain the first sum of the sales service fee rate of the first agency data element of the product sales service fee rate type at the first time point and the management fee rate of the first agency data element of the product management fee rate type at the first time point; If the customer maintenance fee rate of the first sales data element of the customer maintenance fee rate type is less than or equal to the first sum at the first time, it is determined that the first sales data element of the customer maintenance fee rate type does not have any abnormality at the first time.
6. The method for verifying and processing consignment expenses according to claim 4, characterized in that, The step of determining whether the first sales data element of the customer maintenance fee rate type is abnormal at the first moment, based on the data elements of the first sales data element of the customer maintenance fee rate type, the data elements of the first sales data element of the sales service fee rate type, and the data elements of the first sales data element of the product management fee rate type at the first moment, includes: Acquire the first change in the sales service fee rate of the first agency data element of the sales service fee rate type at the first time point, the second change in the management fee rate of the first agency data element of the product management fee rate type at the first time point, and the third change in the customer maintenance fee rate of the first agency data element of the customer maintenance fee rate type at the first time point. If the first change and the second change have the same trend, and the trends of the first change and the second change are different from the trend of the third change, then it is determined that the first sales data element of the customer maintenance fee rate type is abnormal at the first moment.
7. The method for verifying and processing consignment expenses according to claim 3, characterized in that, The step of determining whether there are any anomalies in the first sales data elements of each element type at each time point, based on the data elements of the first sales data elements of each element type at each time point and the data elements of the first sales data elements of the associated types corresponding to each element type at each time point, includes: If the element type is a product share quantity type, then determine whether the product share quantity of the first sales data element of the product share quantity type is missing at the first moment; If there are no missing data elements, it is determined that the first sales data element of the product share quantity type does not have any abnormalities at the first time point.
8. The method for verifying and processing consignment expenses according to claim 1, characterized in that, The step of determining the first sales result based on the data source to be processed includes: Obtain the data elements of the first sales data elements of each element type at each time point from the data source to be processed; The first sales result at each time point is determined based on the data elements and the preset formula.
9. The method for verifying and processing consignment expenses according to claim 1, characterized in that, The step of determining whether to use the first sales result as the target sales result based on the first sales data element of multiple element types, the first sales result, the second sales data element of multiple element types, and the second sales result includes: The first sales results at each time point are compared with the second sales results at each time point to determine the result error; If the result error meets the preset condition, then the first sales result at each time point is taken as the target sales result at each time point. If the result error does not meet the preset conditions, then the difference information is determined based on the first sales data element of the multiple element types and the second sales data element of the multiple element types, and the difference information is displayed.
10. An electronic device, characterized in that, The system includes a cost verification system, a memory, and a processor. The memory stores a computer program executable by the processor. When the processor executes the computer program, it implements the steps of the consignment cost verification processing method according to any one of claims 1-9.