Bill data verification method and device

Abstract

The embodiment of the invention discloses a bill data verification method and device. According to the embodiment of the invention, after a template creation page is displayed, a bill template comprising a plurality of cells is created in the template creation page according to a received template creation instruction, and when a rule configuration instruction for each cell is received, a corresponding value standard is configured for each cell; and filling the cells according to the value standards corresponding to the cells to generate a target bill, and checking the to-be-checked bill according to the target bill to obtain a checking result. Wherein the value taking standard is used for representing a determination mode of data needing to be filled in the cells. Therefore, the bill template is created and configured by the verification personnel, and then the target bill is automatically generated by using the bill template to verify the to-be-verified bill, so that the bill data verification efficiency can be improved, and the experience of the verification personnel is improved.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and specifically to a method and apparatus for verifying bill data. Background Technology

[0002] In the current settlement process of e-commerce platforms, whenever an order is completed, the amount paid by the user is allocated to multiple relevant parties according to a pre-agreed ratio, such as suppliers, the platform itself, and channel partners. At the same time, each completed order also incurs some additional fees (such as bad debt liability fees, subsidy liability fees, handling fees, or technical fees). These additional fees are periodically compiled into bills, which are then paid or collected by the platform from the relevant parties in the form of bills.

[0003] Before making or collecting payments to various stakeholders in the form of invoices, platforms typically need to verify the compiled invoices. Existing invoice verification methods rely entirely on manual verification. However, in practice, the invoices requiring verification often involve a large number of orders, each requiring calculation of the payments and charges owed to different stakeholders for different expense items. Furthermore, even for the same expense item, the applicable calculation method varies between different stakeholders or across different time periods. This makes existing invoice verification methods not only inefficient but also provide a poor user experience for verification personnel. Summary of the Invention

[0004] In view of this, embodiments of the present invention provide a bill data verification method and apparatus to improve the efficiency of bill data verification and enhance the experience of verification personnel.

[0005] In a first aspect, embodiments of the present invention provide a billing data verification method, the method comprising:

[0006] Display template creation page;

[0007] In response to receiving a template creation instruction, a bill template is created on the template creation page according to the template creation instruction, the bill template including multiple cells;

[0008] For each of the cells, in response to receiving a rule configuration instruction for the cell, a corresponding value standard is configured for the cell, wherein the value standard is used to characterize the method of determining the data to be filled in the cell;

[0009] Fill in each cell according to the value criteria corresponding to each cell to generate the target bill;

[0010] The target invoice is used to verify the invoice to be verified in order to obtain the verification result.

[0011] Secondly, embodiments of the present invention provide a bill data verification device, the device comprising:

[0012] The display unit is used to showcase the template creation page;

[0013] A template creation unit is configured to, in response to receiving a template creation instruction, create a bill template on the template creation page according to the template creation instruction, wherein the bill template includes multiple cells;

[0014] The template configuration unit is used to configure a corresponding value standard for each cell in response to receiving a rule configuration instruction for the cell. The value standard is used to characterize the method of determining the data to be filled in the cell.

[0015] The filling unit is used to fill in each cell according to the value standard corresponding to each cell to generate the target bill;

[0016] The verification unit is used to verify the invoice to be verified based on the target invoice to obtain the verification result.

[0017] Thirdly, embodiments of the present invention provide a computer-readable storage medium storing computer program instructions thereon, which, when executed by a processor, implement the method described in the first aspect.

[0018] Fourthly, embodiments of the present invention provide an electronic device, the device comprising:

[0019] Memory is used to store one or more computer program instructions;

[0020] A processor, wherein the one or more computer program instructions are executed by the processor to implement the method as described in the first aspect.

[0021] Fifthly, embodiments of the present invention provide a computer program product that, when run on a computer, causes the computer to perform the method described in the first aspect.

[0022] This invention, after displaying the template creation page, creates a bill template with multiple cells based on the received template creation instructions. Upon receiving rule configuration instructions for each cell, it configures corresponding value standards for each cell, and then fills in each cell according to the corresponding value standards to generate a target bill. Finally, it verifies the bill to be verified based on the target bill to obtain the verification result. The value standards characterize the method of determining the data to be filled in the cells. Therefore, by having verification personnel create and configure bill templates, and then automatically generating target bills for verification, this invention improves the efficiency of bill data verification and enhances the verification personnel's experience. Attached Figure Description

[0023] The above and other objects, features and advantages of the present invention will become clearer from the following description of embodiments of the invention with reference to the accompanying drawings, in which:

[0024] Figure 1 This is a flowchart of the bill data verification method according to an embodiment of the present invention;

[0025] Figure 2 A schematic diagram illustrating the template creation page in an embodiment of the present invention;

[0026] Figure 3 A schematic diagram illustrating the template creation page in an embodiment of the present invention;

[0027] Figure 4 This is a schematic diagram of the value standard setting page according to an embodiment of the present invention;

[0028] Figure 5 This is a flowchart of the target bill generation method according to an embodiment of the present invention;

[0029] Figure 6 This is a flowchart of another target bill generation method according to an embodiment of the present invention;

[0030] Figure 7 This is a flowchart of the mutual exclusion identification method according to an embodiment of the present invention;

[0031] Figure 8 This is a schematic diagram of a bill data verification device according to an embodiment of the present invention;

[0032] Figure 9 This is a schematic diagram of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0033] The present application is described below based on embodiments, but it is not limited to these embodiments. In the detailed description of the present application below, certain specific details are described in detail. Those skilled in the art can fully understand the present application without these details. To avoid obscuring the substance of the present application, well-known methods, processes, flows, elements, and circuits are not described in detail.

[0034] Furthermore, those skilled in the art should understand that the accompanying drawings provided herein are for illustrative purposes only and are not necessarily drawn to scale.

[0035] Unless the context explicitly requires it, words such as "including" or "contains" throughout the application should be interpreted as including rather than exclusive or exhaustive; that is, meaning "including but not limited to".

[0036] In the description of this application, it should be understood that the terms "first," "second," etc., are used for descriptive purposes only and should not be construed as indicating or implying relative importance. Furthermore, in the description of this application, unless otherwise stated, "a plurality of" means two or more.

[0037] The solutions described in this specification and embodiments, if involving the processing of personal information, will be processed only under the premise of having a legal basis (such as obtaining the consent of the personal information subject, or being necessary for the performance of a contract), and will only be processed within the scope stipulated or agreed upon. A user's refusal to process personal information beyond what is necessary for basic functions will not affect the user's use of basic functions.

[0038] In the following description, an e-commerce platform will be used as an example. However, it should be understood that the solutions of this embodiment can also be applied to suppliers or channel partners, etc. Furthermore, the e-commerce platform can refer to a ride-hailing platform, an online food delivery platform, a fresh food delivery platform, an express delivery platform, or any other platform that has a requirement for billing data verification. This application does not limit this.

[0039] Figure 1 This is a flowchart of a billing data verification method according to an embodiment of the present invention. Figure 1 As shown, the bill data verification method may specifically include the following steps:

[0040] It should be understood that the entity executing the bill data verification method can be any general-purpose data processing device with a display interface. Such general-purpose data processing devices may include tablet computers, laptop computers, or desktop computers, etc., and this application does not impose any limitations on this.

[0041] Step S100: Display the template creation page.

[0042] Specifically, the data processing equipment can display a template creation page under the control of verification personnel. This template creation page allows verification personnel to create and configure invoice templates. It should be understood that the configured invoice templates can be used by the data processing equipment to generate target invoices for verification of the invoices to be verified.

[0043] Step S200: In response to receiving a template creation instruction, create an invoice template on the template creation page according to the template creation instruction.

[0044] Specifically, after the data processing device displays the template creation page, the verification personnel can trigger a template creation command. Upon receiving the command, the data processing device can create an invoice template on the template creation page. The created invoice template can include multiple cells. Each cell can correspond to a specific expense item and related expense object. Different cells will not correspond to the same expense item and related expense object simultaneously.

[0045] It should be understood that in this embodiment, the "fee-related objects" can refer to the payers or receivers of additional fees, which may include channel partners or suppliers, etc. The "fee items" can refer to the specific types of additional fees, which may include bad debt liability fees, subsidy liability fees, handling fees, or technology fees, etc. Specifically, the platform will advance payments for bad debts incurred during operation. Bad debt liability fees can refer to the fees paid to the platform by other related parties to share the bad debt losses after the platform has advanced payments for bad debts. The platform will advance payments for subsidies issued to users or related business entities (such as drivers or riders, the specific amount depending on the applicable scenario of this solution) during operation. Subsidy liability fees can refer to the fees paid to the platform by other related parties to share the subsidies after the platform has advanced payments for subsidies. When the platform transfers funds to various related parties through a third-party payment platform, the third-party payment platform will charge a certain fee, which will also be advanced by the platform. Handling fees can refer to the fees charged by the platform to various related parties to compensate for this advance payment. In each order, the relevant party will provide corresponding technical or service support. The technical fee can refer to the fee paid by the platform to the relevant party for the technical or service support provided.

[0046] Optionally, in this embodiment, to facilitate the creation and management of bill templates by verification personnel, each row cell in the bill template can correspond to the same expense item, and each column cell in the bill template can correspond to the same expense-related object. Further, the template creation instruction can include an item creation instruction and an object creation instruction. The item creation instruction and the object creation instruction can be used to create rows and columns, respectively. In step S200, the data processing device can create rows and columns according to the item creation instruction and the object creation instruction, thereby creating the bill template. Alternatively, in some embodiments, each column cell in the bill template can also correspond to the same expense item, and each row cell in the bill template can also correspond to the same expense-related object. It should be understood that, for adaptation, the item creation instruction and the object creation instruction can be used to create columns and rows, respectively.

[0047] Optionally, the project creation instruction and the object creation instruction can be triggered by the verification personnel through the corresponding controls in the touch template creation page.

[0048] Figure 2 This is a schematic diagram illustrating the template creation page according to an embodiment of the present invention. For example... Figure 2 As shown, the template creation page 21 may include an object creation control 211 and a project creation control 212. Verification personnel can trigger object creation commands and project creation commands respectively by touching the object creation control 211 and the project creation control 212. After receiving the object creation command and the project creation command, the data processing device can create an invoice template 213 in the template creation page 21 according to the project creation command and object creation command triggered by the verification personnel. The first, second, third, and fourth rows of cells in the invoice template 213 can correspond to expense items a, b, c, and d respectively. The first, second, and third columns of cells in the invoice template 213 can correspond to expense-related objects A, B, and C respectively.

[0049] Optionally, in order to enable the verification personnel to clearly view the expense items and expense-related objects involved in the currently created bill template, the data processing device can also display the expense items corresponding to each row cell and the expense-related objects corresponding to each column cell in the currently created bill template in the corresponding areas of the template creation page 21 (such as the expense-related object display area 214 and the expense item display area 215).

[0050] Furthermore, to facilitate adjustments made by verification personnel to the expense items and related objects in the bill template, the data processing device can also display deletion controls (as shown in deletion control 216) corresponding to each expense item and related object on the template creation page 21. Verification personnel can trigger a deletion command for the corresponding expense item or related object by touching the deletion control. Upon receiving the deletion command, the data processing device can delete the expense item or related object corresponding to the deletion command. It should be understood that after deleting an expense item or related object, the bill template 213 will be adjusted accordingly. Figure 2 Taking the bill template 213 as an example, if the verifier deletes expense item 'a', then the first row of cells corresponding to expense item 'a' in bill template 213 will be deleted accordingly. Alternatively, if the verifier deletes expense-related object 'B', then the second column of cells corresponding to expense-related object 'B' in bill template 213 will be deleted accordingly.

[0051] It should be understood that, in addition to supporting the creation and deletion of expense items and expense-related objects involved in the bill template by the verifiers, the data processing equipment can also support other operations by the verifiers in practical applications to meet their needs. For example, the data processing equipment can also support the verifiers in adjusting the order of expense items corresponding to cells in each row or expense-related objects corresponding to cells in each column of the bill template. Furthermore, the data processing equipment can also support the verifiers in performing row and column transformations on the bill template (that is, converting the original situation where each row of cells corresponds to the same expense item and each column of cells corresponds to the same expense-related object to a situation where each row of cells corresponds to the same expense-related object and each column of cells corresponds to the same expense item). Additionally, the data processing equipment can also support the verifiers in setting corresponding subsets for expense-related objects, etc., which will not be elaborated further here.

[0052] Optionally, in this embodiment, the expense items and expense-related objects created by the verification personnel can be pre-set, and the creation instruction triggered by the verification personnel can be a selection instruction for preset expense items and preset expense-related objects. In step S200, the data processing device can select the corresponding preset expense items and preset expense-related objects according to the creation instruction to create a bill template.

[0053] It should be understood that, in this embodiment, the pages, containers, pop-ups, or functional components displayed by the data processing device can all be implemented using HTML (Hyper Text Markup Language), XML (Extensible Markup Language), CSS (Cascading Style Sheets), and JavaScript.

[0054] Step S300: For each cell, in response to receiving a rule configuration instruction for the cell, configure the corresponding value standard for the cell.

[0055] Specifically, after generating the bill template, the verifier can trigger rule configuration instructions for each cell. Upon receiving these instructions, the data processing device can configure corresponding value standards for each cell. These value standards characterize the method for determining the data to be entered within the cell.

[0056] Optionally, in this embodiment, the method for determining the payment or collection of fees for different fee items by different fee-related objects can be pre-set. When configuring the corresponding value standard for a cell, the data processing device can display the preset value standard adapted to the current cell to the verification personnel, and configure the corresponding value standard for the current cell based on the verification personnel's selection operation. Specifically, the data processing device can display at least one preset value standard applicable to the current cell to the verification personnel according to the fee item and fee-related object corresponding to the current cell. Furthermore, the verification personnel can select any preset value standard from multiple preset value standards, thereby triggering a selection instruction for that preset value standard (the selection instruction can be triggered by the verification personnel by touching the area where the preset value standard is located). After receiving the selection instruction, the data processing device can configure the preset value standard corresponding to the selection instruction as the value standard corresponding to the cell.

[0057] Figure 3 This is a schematic diagram illustrating the template creation page according to an embodiment of the present invention. For example... Figure 3As shown, bill template 311 includes cell 312. Taking the example of a verifier configuring a value standard for cell 312, the verifier can trigger a rule configuration command for cell 312 by touching the area where cell 312 is located in bill template 311. After receiving the rule configuration command, the data processing device can display the preset value standards w, x, y, and z applicable to cell 312 (the preset value standards w, x, y, and z are applicable to calculating the fees payable or collected by fee-related object C for fee item a) in the corresponding display area of ​​the template creation page (as shown in value standard display area 313) according to the fee item a and fee-related object C corresponding to cell 312. Further, if the verifier wants to configure the preset value standard w as the value standard corresponding to cell 312, they can touch the area where the preset value standard w is located to trigger a selection command for the preset value standard w. After receiving the selection command, the data processing device can configure the preset value standard w corresponding to the selection command as the value standard corresponding to cell 312.

[0058] Optionally, in order to enable users to clearly see the value standard corresponding to each cell, for each cell that has completed the value standard configuration, the data processing device can display the relevant information of the value standard corresponding to the cell (such as name or number) in the cell (as shown in cells 314 and 315).

[0059] Optionally, in this embodiment, the generated and configured bill template may have a corresponding applicable period, meaning that a bill template is only used to generate bills for the platform within a certain time period. Specifically, the applicable period of the bill template can be set by the verification personnel.

[0060] It should be understood that, in this embodiment, each value standard also has a corresponding applicable period. Therefore, for the same bill template, the applicable period of the value standard corresponding to each cell in the bill template should be ensured to match the applicable period of the bill template.

[0061] Furthermore, to ensure that the applicable period of the value standard corresponding to each cell in the same bill template is the same, the data processing device can prompt the verification personnel to set the applicable period of the bill template before configuring the corresponding value standard for each cell in the bill template. Then, when showing the verification personnel at least one preset value standard applicable to the current cell, the data processing device can only show the verification personnel preset value standards whose applicable period matches the applicable period of the bill template. For example, if the applicable period of the bill template is May 2024, the preset value standards applicable to a certain cell in the bill template include preset value standard e with an applicable period of April 2024 to June 2024, preset value standard f with an applicable period of April 2024 to May 2024, and preset value standard g with an applicable period of June 2024 to July 2024. When the verification personnel configure the corresponding value standard for this cell, the data processing device can only show the verification personnel preset value standards e and f for the verification personnel to choose from.

[0062] Optionally, in this embodiment, each value criterion may include at least one variable. After configuring the corresponding value criterion for a cell, the data processing device can also establish the association between the variable in each value criterion and the corresponding field or cell in the source data table. Specifically, for each value criterion, when receiving a variable association instruction for the current value criterion, the data processing device can establish the association between the variable in the current value criterion and the corresponding field or cell in the source data table according to the variable association instruction.

[0063] Optionally, to facilitate the verification personnel in performing association operations on the variables in each value standard, for each cell that has completed the configuration of the value standard, the data processing device can also display the relevant information of the variables included in the value standard (such as names or identifiers) in the cell (as shown in cells 314 and 315).

[0064] Optionally, the source data table can be generated by a data processing device based on historical order details. Each field in the source data table can be defined by the data processing device based on instructions triggered by verification personnel. Specifically, the data processing device can acquire historical order details. After acquiring the historical order details, the data processing device can organize the historical order details to generate the source data table. Further, upon receiving a field definition instruction, the data processing device can define the fields in the source data table according to the field definition instruction (that is, define each column of data in the source data table as a corresponding field). The acquired historical order details can come from different systems under the platform, such as a payment management system, an order management system, or a refund management system, etc., and this application does not impose any restrictions on this. Each row in the generated source data table can correspond to different related objects, such as suppliers, the platform itself, and various channel partners. Some columns in the generated source data table can correspond to different fee types, such as the user's actual payment amount, the amount allocated to each related object, the refund amount, and the amount collected by the third-party payment platform, etc., while other columns can correspond to different order statuses, such as whether a refund has been issued or whether a price has been changed. It should be understood that historical order details data can originate from different historical orders. Therefore, the data within the cells of the source data table obtained by organizing historical order details data can also originate from different historical orders. In this embodiment, data from different historical orders can be independent within the cells, or they can be organized into a total. The specific settings can be configured by the verification personnel according to actual verification needs, and this application does not impose any specific limitations on this.

[0065] Further, in this embodiment, the value standard types include a first type and a second type. The first type of value standard can be used to instruct the direct filling of the associated data of the variables in the value standard into the corresponding cell. The second type of value standard has multiple corresponding preset value conditions, each with a corresponding value formula. The second type of value standard can be used to instruct the calculation of the associated data of the variables in the value standard using the corresponding value formula based on the currently satisfied value conditions, and then fill the calculation result into the corresponding cell. Before displaying at least one preset value standard applicable to the current cell, the data processing device can also allow the verifier to select the value standard type. Then, the data processing device can display at least one preset value standard applicable to the current cell to the verifier based on the verifier's selection of the value standard type. For example, suppose the preset value standards applicable to a certain cell include preset value standards e, f, and g. Preset value standard e is of type first, and preset value standards f and g are of type second. If the verifier selects the second type of value standard for the cell, the data processing device can display the preset value standards f and g for the verifier to choose from.

[0066] Figure 4 This is a schematic diagram of the value standard setting page according to an embodiment of the present invention. It should be understood that the value standard setting page can be used by verification personnel to set preset value standards. Figure 4As shown, the value standard setting page 41 displays relevant information about preset value standards, such as the value standard number, applicable scenarios, applicable period, type, name, applicable fee items, and applicable fee-related objects. It should be understood that all of the above-mentioned relevant information can be set by the verification personnel. Further, when the verification personnel set the type of the preset value standard to the second type, the value standard setting page 41 may also include a condition addition control 411. The verification personnel can trigger a condition addition instruction by touching the condition addition control 411. After receiving the condition addition instruction, the data processing device can add corresponding preset value conditions for the value standard. Further, in this embodiment, each preset value condition may have a corresponding rule setting control (as shown in rule setting control 412) and formula setting control (as shown in formula setting control 413). The verification personnel can trigger rule setting instructions and formula setting instructions respectively by touching the rule setting control and formula setting control. After receiving the rule setting instructions and formula setting instructions, the data processing device can set the specific judgment rules and corresponding value formulas for the preset value conditions according to the rule setting instructions and formula setting instructions respectively. It should be understood that the specific judgment rules and corresponding value formulas for the preset value conditions can be determined by the platform and the parties involved in the fee, and set by the verification personnel.

[0067] Optionally, the value standard setting page 41 may also include a standard save control 414. After completing the setting of the preset value standard, the verifier can trigger a standard save command by touching the standard save control 414. After receiving the standard save command, the data processing device can save the preset value standard. It should be understood that the saved preset value standard can be displayed to the verifier as an option when configuring the value standard for the corresponding cell, for the verifier to select.

[0068] Optionally, in this embodiment, the verification personnel can also save the created and configured bill template. Specifically, the template creation page can also include a template saving control (such as...). Figure 2 (Template save control 217). Verifiers can trigger a template save command by touching the template save control. After receiving the template save command, the data processing device can save the current bill template.

[0069] Step S400: Fill in each cell according to the value standard corresponding to each cell to generate the target bill.

[0070] Specifically, after the bill template is generated and configured, the data processing device can fill in each cell according to the value standard corresponding to each cell to generate the target bill.

[0071] Figure 5 This is a flowchart of the target invoice generation method according to an embodiment of the present invention. Figure 5 As shown, the target invoice generation method may specifically include the following steps:

[0072] It should be understood that by implementing such Figure 5 The target bill generation method shown above can be implemented by a data processing device in step S400.

[0073] Step S410: For each of the value criteria, obtain the associated data of each variable in the value criteria from the source data table or the corresponding cell according to the association relationship.

[0074] Specifically, for the value standard corresponding to each cell, the data processing device can obtain the associated data of each variable in the value standard from the source data table or the corresponding cell according to the association relationship.

[0075] Optionally, in this embodiment, the bill template has a corresponding applicable period. In step S410, the data processing device can obtain the associated data of each variable in the value standard from the source data table or the corresponding cell according to the association relationship and the applicable period of the bill template.

[0076] Step S420: Fill in each cell according to the value standard corresponding to each cell and the associated data.

[0077] Specifically, the data processing device can fill in each cell according to the value standard corresponding to each cell and the related data obtained.

[0078] Optionally, in this embodiment, the value criteria include a first type and a second type. Different types of value criteria are used to indicate different methods for determining the data to be filled in the cell. Specifically, for a cell whose corresponding value criteria is of type first, the data processing device can directly fill in the associated data of the variables in the value criteria into the cell. For a cell whose corresponding value criteria is of type second, the data processing device can determine the currently satisfied value condition from multiple preset value conditions, and select the corresponding value formula to calculate the associated data of the variables in the value criteria based on the currently satisfied value condition, and then fill in the calculation result into the corresponding cell. It should be understood that the value conditions may include whether to refund or whether to change the price, etc. Whether the value conditions are satisfied can be determined by the data processing device by reading the corresponding fields in the source data table.

[0079] It should be understood that for each historical order, the data processing device calculates the payment and collection data for different fee items for different fee-related objects. Therefore, for the same cell, the data processing device will calculate the fee data corresponding to different historical orders separately. In this embodiment, the data processing device can either fill in the fee data corresponding to each historical order independently in the cell, or it can organize the fee data corresponding to each historical order into a total and fill it in the cell. The specific settings can be configured by the verification personnel according to the actual verification needs, and this application does not impose any specific limitations on this.

[0080] Optionally, to improve bill generation efficiency, the data processing device can also determine multiple partition bills in parallel, and then organize the multiple partition bills to generate the target bill.

[0081] Figure 6 This is a flowchart illustrating another method for generating a target invoice according to an embodiment of the present invention. Figure 6 As shown, the target invoice generation method may specifically include the following steps:

[0082] It should be understood that by implementing such Figure 6 The target bill generation method shown can also be implemented by the data processing device using the same steps S400.

[0083] Step S410': Determine multiple partition time periods based on the applicable period.

[0084] Specifically, the data processing device can divide the applicable period of the current bill template into multiple partition time periods. Each partition time period can be the same or different; this application does not impose any restrictions on this.

[0085] Step S420': For each partition time period, fill in each cell according to the value standard corresponding to each cell to obtain the partition bill corresponding to the partition time period.

[0086] Specifically, for each partition time period, the data processing device can fill in each cell according to the value standard corresponding to each cell to obtain the partition bill corresponding to the partition time period.

[0087] It should be understood that multiple partitioned bills can be generated by the data processing device using a parallel execution of multiple threads. Furthermore, when determining the partitioned bill corresponding to a single partitioned time period, the data processing device also obtains the associated data for each value standard and fills in each cell according to the value standard corresponding to each cell and the obtained associated data. However, compared to the above embodiment where the associated data of each variable in the value standard is obtained from the source data table or corresponding cell based on the associated information and the applicable period of the bill template, in step S420', the data processing device obtains the associated data of each variable in the value standard from the source data table or corresponding cell based on the associated information and the partitioned time period.

[0088] Optionally, to ensure data security, the data processing equipment can also generate corresponding watermarks for the obtained target orders according to the needs of the verification personnel. Further, the watermark can be a digital watermark or a transparent watermark; this application does not impose any limitation on this.

[0089] Step S500: Verify the bill to be verified according to the target bill to obtain the verification result.

[0090] Specifically, after generating the target invoice, the data processing device can verify the invoice to be verified based on the target invoice to obtain the verification result. The invoice to be verified can be periodically compiled by the platform or relevant parties, and can be entered into the data processing device by verification personnel. It should be understood that the invoice to be verified may include payment or collection data for different expense items from at least one expense-related party. The verification of the invoice to be verified by the data processing device specifically refers to the verification of the expense data included in the invoice.

[0091] It should be understood that the cost data for different orders in the invoice to be verified can be independent of each other or can be aggregated into a total; this application does not impose any restrictions. Furthermore, it should be noted that the invoice template and the cell entry method of the invoice to be verified should be consistent.

[0092] Furthermore, the verification result can indicate whether the expense data in the bill to be verified is correct. After obtaining the verification result, the data processing device can also provide prompts to the verification personnel based on the verification result. Specifically, if the verification result indicates that all expense data in the bill to be verified is correct, the data processing device can confirm the verification is successful and provide a verification pass prompt. If the verification result indicates that there are errors in the expense data in the bill to be verified, the data processing device can confirm the verification fails and provide a verification failure prompt, and then display the relevant expense objects and expense items with errors to the verification personnel.

[0093] Optionally, since the applicable period of the bill template can be set by the verifier, in this embodiment, the verifier can also create and configure different bill templates to implement corresponding bill verification methods. In one implementation, to reduce the computational burden on the data processing equipment, the verifier can also create and configure different bill templates in batches based on the statistical period of the bill to be verified. Each bill template can be used to generate target bills for different time periods within the statistical period. Then, after the statistical period ends, the data processing equipment, under the control of the verifier, will organize all the target bills generated within the statistical period and verify them against the orders to be verified within the statistical period to obtain the verification results. For example, if the statistical period is one month, the verifier can create and configure the corresponding bill template each day to generate the target bill for that day. Then, after the month ends, the verifier can control the data processing equipment to organize all the target bills generated in the previous month and verify them against the orders to be verified in the previous month to obtain the verification results.

[0094] Alternatively, in another implementation, when verification personnel create and configure multiple bill templates for the same expense-related object, if the expense items and applicable periods involved in the multiple bill templates overlap simultaneously, it will lead to inaccurate subsequent verification. To address this, the data processing device can also identify mutually exclusive bill templates (i.e., bill templates whose expense items and applicable periods overlap with the current bill template) to alert the verification personnel.

[0095] Figure 7 This is a flowchart of a mutual exclusion identification method according to an embodiment of the present invention. Figure 7 As shown, the mutual exclusion identification method may specifically include the following steps:

[0096] Step S610: Determine the field association information of the bill template to the source data table based on the association relationship.

[0097] Specifically, the data processing device can determine the field association information of the current bill template to the source data table based on the association relationship. This field association information can be a binary segment. Each binary character in the field association information can correspond to a field in the source data table, and the binary character can be used to indicate whether the corresponding field is associated with a cell in the bill template.

[0098] Optionally, in this embodiment, the binary character "1" can be used to indicate that the corresponding field has been associated with a cell in the bill template. The binary character "0" can be used to indicate that the corresponding field has not been associated with a cell in the bill template. For example, assuming that the source data table includes a total of 8 fields, and the 3rd, 4th, and 8th fields are associated with cells in the current bill template, then the data processing device can determine that the field association information of the current bill template with the source data table is "00110001".

[0099] Step S620: Perform an AND operation on the field association information of the bill template to the source data table and the field association information of each historical bill template to the source data table.

[0100] Specifically, after determining the field association information of the current bill template with the source data table, the data processing device can perform a bitwise AND operation between the field association information of the bill template with the source data table and the field association information of each historical bill template with the source data table. It should be understood that the historical bill templates involved in this bitwise AND operation can be those that only involve the same expense-related object and whose applicable period overlaps with the current bill template.

[0101] Step S630: Apply a mutual exclusion flag to the bill template based on the AND operation result.

[0102] Specifically, after performing a bitwise AND operation between the field association information of the bill template and the field association information of each historical bill template in the source data table, if the result of the AND operation is 0 for all of them, the data processing device can confirm that there are no mutually exclusive bill templates for the current bill template. In this case, the data processing device does not mark the current bill template as mutually exclusive. If any AND operation result is not 0, the data processing device can confirm that there are mutually exclusive bill templates for the current bill template. In this case, the data processing device can mark the current bill template as mutually exclusive and provide corresponding prompts to the verification personnel.

[0103] This invention, after displaying the template creation page, creates a bill template with multiple cells based on the received template creation instructions. Upon receiving rule configuration instructions for each cell, it configures corresponding value standards for each cell, and then fills in each cell according to the corresponding value standards to generate a target bill. Finally, it verifies the bill to be verified based on the target bill to obtain the verification result. The value standards characterize the method of determining the data to be filled in the cells. Therefore, by having verification personnel create and configure bill templates, and then automatically generating target bills for verification, this invention improves the efficiency of bill data verification and enhances the verification personnel's experience.

[0104] Figure 8This is a schematic diagram of a bill data verification device according to an embodiment of the present invention. Figure 8 As shown, the bill data verification device of this embodiment includes a display unit 81, a template creation unit 82, a template configuration unit 83, a filling unit 84, and a verification unit 85.

[0105] Specifically, the display unit 81 is used to display the template creation page;

[0106] The template creation unit 82 is configured to respond to receiving a template creation instruction and create a bill template in the template creation page according to the template creation instruction, wherein the bill template includes multiple cells;

[0107] The template configuration unit 83 is used to configure a corresponding value standard for each cell in response to receiving a rule configuration instruction for the cell. The value standard is used to characterize the method of determining the data to be filled in the cell.

[0108] The filling unit 84 is used to fill in each cell according to the value standard corresponding to each cell to generate the target bill;

[0109] The verification unit 85 is used to verify the bill to be verified based on the target bill in order to obtain the verification result.

[0110] This invention, after displaying the template creation page, creates a bill template with multiple cells based on the received template creation instructions. Upon receiving rule configuration instructions for each cell, it configures corresponding value standards for each cell, and then fills in each cell according to the corresponding value standards to generate a target bill. Finally, it verifies the bill to be verified based on the target bill to obtain the verification result. The value standards characterize the method of determining the data to be filled in the cells. Therefore, by having verification personnel create and configure bill templates, and then automatically generating target bills for verification, this invention improves the efficiency of bill data verification and enhances the verification personnel's experience.

[0111] Figure 9 This is a schematic diagram of an electronic device according to an embodiment of the present invention. (For example...) Figure 9 As shown, Figure 9The electronic device shown is a data processing device as described in the above embodiments, comprising a general computer hardware architecture, including at least a processor 91 and a memory 92. The processor 91 and memory 92 are connected via a bus 93. The memory 92 is adapted to store instructions or programs executable by the processor 91. The processor 91 can be a standalone microprocessor or a collection of one or more microprocessors. Thus, the processor 91 executes the instructions stored in the memory 92 to perform the method flow of the embodiments of the present invention as described above, thereby realizing data processing and control of other devices. The bus 93 connects the aforementioned components together, and also connects these components to a display controller 94, a display device, and an input / output (I / O) device 95. The input / output (I / O) device 95 can be a mouse, keyboard, modem, network interface, touch input device, motion-sensing input device, printer, and other devices known in the art. Typically, the input / output device 95 is connected to the system via an input / output (I / O) controller 96.

[0112] Those skilled in the art will understand that embodiments of this application can be provided as methods, apparatus (devices), or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-readable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0113] This application is described with reference to flowchart illustrations of methods, apparatus (devices), and computer program products according to embodiments of this application. It should be understood that each step in the flowchart can be implemented by computer program instructions.

[0114] These computer program instructions may be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including an instruction means, the implementation process of which is described in the instruction means. Figure 1 The function specified in one or more processes.

[0115] These computer program instructions may also be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing device, produce instructions for implementing processes. Figure 1 A device for a function specified in one or more processes.

[0116] Another embodiment of the present invention relates to a non-volatile storage medium for storing a computer-readable program for use by a computer to execute some or all of the above-described method embodiments.

[0117] That is, those skilled in the art will understand that all or part of the steps in the methods of the above embodiments can be implemented by a program specifying the relevant hardware. This program is stored in a storage medium and includes several instructions to cause a device (which may be a microcontroller, chip, etc.) or processor to execute all or part of the steps of the methods described in the embodiments of this application. The aforementioned storage medium includes various media capable of storing program code, such as a USB flash drive, a portable hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0118] The above description is merely a preferred embodiment of this application and is not intended to limit this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the protection scope of this application.

Claims

1. A method for verifying billing data, characterized in that, The method includes: Display template creation page; In response to receiving a template creation instruction, a bill template is created on the template creation page according to the template creation instruction, the bill template including multiple cells; For each of the cells, in response to receiving a rule configuration instruction for the cell, a corresponding value standard is configured for the cell, wherein the value standard is used to characterize the method of determining the data to be filled in the cell; Fill in each cell according to the value criteria corresponding to each cell to generate the target bill; The target invoice is used to verify the invoice to be verified in order to obtain the verification result.

2. The method according to claim 1, characterized in that, Each row of cells in the bill template corresponds to the same expense item, and each column of cells in the bill template corresponds to the same expense-related object; or, each column of cells in the bill template corresponds to the same expense item, and each row of cells in the bill template corresponds to the same expense-related object.

3. The method according to claim 2, characterized in that, The template creation instructions include project creation instructions and object creation instructions; The step of creating an invoice template on the template creation page according to the template creation instruction includes: The bill template is created according to the project creation instructions and object creation instructions.

4. The method according to claim 1, characterized in that, The configuration of the corresponding value criteria for the cell includes: Based on the expense item and expense-related object corresponding to the cell, display at least one preset value standard applicable to the cell; In response to receiving a selection instruction, the preset value standard corresponding to the selection instruction is configured as the value standard corresponding to the cell.

5. The method according to claim 1, characterized in that, The value selection criteria include at least one variable; Before filling in each cell according to the value standard corresponding to each cell to generate the target bill, the method further includes: For each of the aforementioned value criteria, in response to receiving a variable association instruction, an association relationship is established between the variable in the value criteria and the corresponding field or cell in the source data table according to the variable association instruction.

6. The method according to claim 5, characterized in that, The step of filling in each cell according to the value standard corresponding to each cell includes: For each of the aforementioned value criteria, the associated data of each of the variables in the value criteria is obtained from the source data table or the corresponding cell according to the association relationship; Fill in each cell according to the value standard corresponding to each cell and the associated data.

7. The method according to claim 6, characterized in that, The bill template has a corresponding applicable period; The step of retrieving the associated data of each variable in the value criterion from the source data table or corresponding cell according to the association relationship includes: Based on the relationship and the applicable period, obtain the associated data of each variable in the value criterion from the source data table or the corresponding cell.

8. The method according to claim 6, characterized in that, The types of the value criteria include a first type and a second type. The second type of value criteria has multiple preset value conditions, and each value condition has a corresponding value formula. The step of filling in each cell according to the value standard corresponding to each cell and the associated data includes: For cells whose corresponding value criteria are of the first type, fill in the associated data of the variable in the value criteria into the cell; For cells whose corresponding value standard is of the second type, determine the currently satisfied value condition from among multiple preset value conditions; Based on the currently satisfied value conditions, the corresponding value formula is selected to calculate the associated data of the variables described in the value criteria; Fill the calculation results into the corresponding cells.

9. The method according to claim 1, characterized in that, The bill template has a corresponding applicable period; The step of filling in each cell according to the value standard corresponding to each cell to generate the target bill includes: Multiple time periods are determined based on the applicable period; For each of the aforementioned partition time periods, each cell is filled in according to the value standard corresponding to each cell to obtain the partition bill corresponding to the partition time period; The multiple partitioned bills are organized to generate the target bill.

10. The method according to claim 5, characterized in that, Before establishing the association between the variables in the value criteria and the corresponding fields or cells in the source data table, the method further includes: Retrieve historical order details; The source data table is generated based on the historical order details data; In response to receiving a field definition instruction, the data in the source data table is defined according to the field definition instruction.

11. The method according to claim 10, characterized in that, Before filling in each cell according to the value standard corresponding to each cell to generate the target bill, the method further includes: Based on the association relationship, the field association information of the bill template to the source data table is determined. The field association information is a binary segment. Each binary character in the field association information corresponds to a field in the source data table. The binary character is used to indicate whether the corresponding field is associated with a cell in the bill template. Perform an AND operation between the field association information of the bill template to the source data table and the field association information of each historical bill template to the source data table; The bill template is marked with mutual exclusion based on the result of the AND operation.

12. A billing data verification device, characterized in that, The device includes: The display unit is used to showcase the template creation page; A template creation unit is configured to, in response to receiving a template creation instruction, create a bill template on the template creation page according to the template creation instruction, wherein the bill template includes multiple cells; The template configuration unit is used to configure a corresponding value standard for each cell in response to receiving a rule configuration instruction for the cell. The value standard is used to characterize the method of determining the data to be filled in the cell. The filling unit is used to fill in each cell according to the value standard corresponding to each cell to generate the target bill; The verification unit is used to verify the invoice to be verified based on the target invoice to obtain the verification result.

13. A computer-readable storage medium storing computer program instructions thereon, characterized in that, The computer program instructions, when executed by a processor, implement the method as described in any one of claims 1-11.

14. An electronic device, characterized in that, The device includes: Memory is used to store one or more computer program instructions; A processor, wherein the one or more computer program instructions are executed by the processor to implement the method as described in any one of claims 1-11.

15. A computer program product, characterized in that, When the computer program product is run on a computer, it causes the computer to perform the method as described in any one of claims 1-11.

Images