Bill cancel-after-verification method and system

Abstract

The invention relates to the field of data processing, in particular to a bill cancel-after-verification method and system. The method comprises an automatic cancel-after-verification bank statement mode which comprises the following steps: pulling a bank statement of a third-party bank system at regular time, and extracting bank statement information; the method comprises the following steps: regularly pulling advertiser recharging information of a company BPMS system, prepaid claiming bank flow to an advertiser fund pool according to bank flow numbers, advertiser IDs, business types, months and other information in the recharging information, and querying an advertiser fund pool account in response to an acquired advertiser bill to determine whether an available limit exists in the advertiser fund pool; and in response to existence of the available quota in the advertiser fund pool, cancelling the bills of the advertiser after verification, and deducting the available quota of the advertiser fund pool according to the cancelled after verification. By adopting the method provided by the invention, the bill verification efficiency and accuracy can be effectively improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of data processing. More particularly, the present application relates to a bill cancellation method and system. BACKGROUND

[0002] An advertiser bill is a fee settlement voucher issued by an advertising platform or an agent to an advertiser (i.e. an enterprise or an individual who places an advertisement) after the end of an advertisement placement period, which is used to record the advertisement service consumption details and the amount payable of the advertiser within a certain period of time.

[0003] In modern advertising platforms, e-commerce and enterprise financial systems, as the business scale and transaction frequency continue to grow, enterprises need to process a large amount of bank flow and advertiser bill data every day. The traditional bill cancellation method usually relies on financial personnel to manually compare bank flow and bills and complete fund claiming and bill deduction. This method is not only inefficient, but also prone to incorrect, missed or delayed cancellation, which seriously affects the accuracy of the enterprise's finance and account management. SUMMARY

[0004] To solve the technical problem of low efficiency of advertiser bill cancellation in the prior art, the present application provides a solution in the following aspects.

[0005] In a first aspect, the present application provides a bill cancellation method, comprising an automatic bank flow cancellation mode, the automatic bank flow cancellation mode comprising: pulling bank flow of a third-party bank system at a regular time, extracting bank flow information, the bank flow information comprising a bank flow number, a transaction date, a transaction amount, a transaction currency, a payee principal, a payee account number, a payer principal and a payment note; pulling advertiser recharge information of a company BPMS system at a regular time, pre-claiming the bank flow to an advertiser fund pool according to the bank flow number, the advertiser ID, the business type, the month and other information in the recharge information, in response to obtaining the advertiser bill, querying the advertiser fund pool account to determine whether the advertiser fund pool has available quota; in response to the advertiser fund pool having available quota, canceling the advertiser bill and deducting the available quota of the advertiser fund pool according to the cancellation amount.

[0006] Preferably, it further comprises a bill cancellation flow mode, the bill cancellation flow mode comprising: in response to a user initiating a cancellation action in a bank flow list and inputting a claim cancellation instruction, matching the payment information of the bank flow with the invoice information of the advertiser bill of the company reconciliation system, and displaying the advertiser bill that matches successfully; wherein the invoice information comprises a payer principal and an invoice amount, and the payment information comprises a payment principal, a payment note and a transaction amount. In response to the user checking the advertiser bill to be cancelled from the matched advertiser bills, filling in the amount to be cancelled, and inputting a confirmation cancellation instruction, the amount to be cancelled is compared with the remaining cancellable amount of the bank flow, if the amount to be cancelled is less than or equal to the remaining cancellable amount, the actual cancellation amount of the advertiser bill is equal to the amount to be cancelled; otherwise, the actual cancellation amount of the advertiser bill is equal to the remaining cancellable amount; and the cancelled amount of the advertiser bill is updated.

[0007] Preferably, the bill cancellation flow mode further comprises: in response to the completion of the cancellation, associating the advertiser bill with the flow, and storing the association information, the association information comprising bill information, flow information, and claimed amount information; The matching state of the bank flow is recalculated, if the bank flow amount is equal to the matched amount of the bank flow, the matching state is set to matched; if the bank flow amount is greater than the matched amount of the bank flow, the matching state is set to partially matched; if the matched amount of the bank flow is zero, the matching state is set to un-matched; The cancellation state of the advertiser bill is recalculated, if the advertiser bill amount is equal to the cancelled amount of the advertiser bill, the cancellation state is set to cancelled; if the advertiser bill amount is greater than the cancelled amount of the advertiser bill, the cancellation state is set to partially cancelled; if the cancelled amount of the advertiser bill is zero, the cancellation state is set to un-cancelled.

[0008] Preferably, the bill cancellation flow mode further comprises: periodically scanning the cancellation result to identify abnormal situations, the types of abnormal situations including amount deviation and invoice invalidation; the amount deviation refers to the difference between the cancellation amount and the bill amount exceeding a preset threshold; If there is an abnormal situation of invoice invalidation, the original flow attached to the invalidated invoice is automatically released, a bill virtual invoice is created, and the released flow is re-attached to the bill virtual invoice.

[0009] Preferably, the bill cancellation flow mode further comprises: if there is an abnormal situation of amount deviation, the original matching record is deleted, and the process of the bill cancellation flow is re-executed; In response to the completion of the process of the bill cancellation flow, the deviation between the cancellation amount and the bill amount is re-checked, if the deviation amount is 0, the user is notified of the successful repair, otherwise, the user is notified of manual intervention.

[0010] Preferably, it further comprises a bill cancellation return point bill mode, the bill cancellation return point bill mode comprising: In response to the user selecting the advertiser bill to be cancelled from the advertiser bill list, filling in the amount to be cancelled, and inputting a claimed cancellation instruction, the return point bills with the same advertiser ID and business type as the advertiser bill to be cancelled are filtered out from the return point bills of the company's reconciliation system and displayed. In response to the user selecting a to-be-redeemed points account bill, filling in the to-be-redeemed amount, and inputting a confirmation redemption instruction, it is determined whether the to-be-redeemed amount of the selected points account bill is equal to the to-be-redeemed amount of the to-be-redeemed advertiser account bill. If they are equal, the to-be-redeemed advertiser account bill is redeemed, and the redemption amount is the to-be-redeemed amount filled in. The to-be-redeemed amount of the to-be-redeemed points account bill and the to-be-redeemed amount of the to-be-redeemed advertiser account bill are updated.

[0011] Preferably, the bill redemption points account bill mode further comprises: After the redemption is completed, the redemption status of the to-be-redeemed advertiser account bill is reset, including: if the amount of the to-be-redeemed advertiser account bill is equal to the redeemed amount of the to-be-redeemed advertiser account bill, the redemption status is set to redeemed; if the amount of the to-be-redeemed advertiser account bill is greater than the redeemed amount of the to-be-redeemed advertiser account bill, the redemption status is set to partially redeemed; and if the redeemed amount of the to-be-redeemed advertiser account bill is zero, the redemption status is set to unredeemed. After the redemption is completed, the redemption status of the to-be-redeemed advertiser account bill is reset, including: if the amount of the to-be-redeemed advertiser account bill is equal to the redeemed amount of the to-be-redeemed advertiser account bill, the redemption status is set to redeemed; if the amount of the to-be-redeemed advertiser account bill is greater than the redeemed amount of the to-be-redeemed advertiser account bill, the redemption status is set to partially redeemed; and if the redeemed amount of the to-be-redeemed advertiser account bill is zero, the redemption status is set to unredeemed.

[0012] Preferably, it further comprises a bill special redemption mode, and the bill special redemption mode comprises: In response to the user selecting a to-be-redeemed advertiser account bill from the advertiser account bill list and inputting a special redemption instruction, a redemption type list is displayed, and the redemption types in the redemption type list include clearing balance deduction, bad debt deduction, other deductions, quota transfer deduction, commission special bearing deduction, other tax deduction, and exchange loss and gain deduction. In response to the user selecting a redemption type from the redemption type list and filling in the corresponding deduction amount, the redemption process corresponding to the selected various redemption types is executed. In response to the completion of the execution of the redemption process corresponding to the selected various redemption types, the redeemed amount of the to-be-redeemed advertiser account bill is updated according to the sum of the deduction amounts corresponding to the selected various redemption types. The redemption status of the to-be-redeemed advertiser account bill is reset, including: if the amount of the to-be-redeemed advertiser account bill is equal to the redeemed amount, the redemption status is set to redeemed; if the amount of the to-be-redeemed advertiser account bill is greater than the redeemed amount, the redemption status is set to partially redeemed; and if the redeemed amount of the to-be-redeemed advertiser account bill is zero, the redemption status is set to unredeemed.

[0013] Preferably, it further comprises a combined redemption mode, and the combined redemption mode comprises: The bill redemption flow mode is executed on the advertiser account bill, thereby obtaining a first redemption amount; The process of performing the bill cancellation rebate bill mode on the advertiser bill, so as to obtain a second cancellation amount; The first cancellation amount and the second cancellation amount are added, so as to obtain a total cancellation amount; The size of the bill amount of the advertiser bill and the total cancellation amount is compared, if the bill amount is equal to the cancelled amount of the bill, the cancellation state is set to cancelled; if the bill amount is greater than the cancelled amount of the bill, the cancellation state is set to partially cancelled.

[0014] In a second aspect, the present application provides a bill cancellation system comprising a memory and a processor, the memory storing computer program instructions which, when executed by the processor, implement the bill cancellation method of the present application.

[0015] The present application has the beneficial effect that: the bill cancellation method of the present application, when canceling the bill, first automatically pulls the bank flow and extracts the key information; then associates the bank flow with the advertiser recharge record, and claims the funds to the fund pool in real time; when the advertiser bill is generated, it is automatically judged whether there is available fund; in the case of meeting the conditions, the bill cancellation is automatically completed, and the fund pool balance is synchronously deducted. Thus, an efficient automatic closed loop between bank flow to account, recharge claim, and bill cancellation is realized, the accuracy and real-time performance of financial cancellation are improved, manual intervention is reduced, and the efficiency and accuracy of bill cancellation are effectively improved.

[0016] Further, by setting an exception handling mechanism, the bill cancellation data with exceptions is automatically identified and repaired, solving the problem of bill cancellation data exceptions caused by changes in bill amount or invalid invoices.

[0017] Further, by setting a combined cancellation mode (i.e. bank flow + rebate double-channel superposition), the success rate of single bill cancellation can be greatly improved, and the backlog of "to be cancelled" bills can be reduced; bank flow priority cancellation ensures that platform funds are timely withdrawn; rebate cancellation supplement improves the use efficiency of rebate funds, avoiding idle or expired rebate. BRIEF DESCRIPTION OF DRAWINGS

[0018] Figure 1 is a flowchart schematically showing a bill cancellation method according to an embodiment of the present application; Figure 2 is a structural schematic diagram of a bill cancellation system according to an embodiment of the present application. DETAILED DESCRIPTION

[0019] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0020] The specific embodiments of the present invention will now be described in detail with reference to the accompanying drawings.

[0021] Example of bill reconciliation method: like Figure 1 As shown, the bill reconciliation method of the present invention includes an automatic bank statement reconciliation mode, wherein the automatic bank statement reconciliation mode includes: S101. Periodically retrieve bank statements, specifically: periodically retrieve bank statements from third-party banking systems, extract bank statement information, including bank statement number, transaction date, transaction amount, transaction currency, payee, payee account, payer, and payee remarks; S102. The bank statement prepayment is claimed to the advertiser's fund pool. Specifically, the advertiser's recharge information is retrieved from the company's BPMS system at regular intervals. Based on the bank statement number, advertiser ID, business type, month and other information in the recharge information, the bank statement prepayment is claimed to the advertiser's fund pool. S103. In response to obtaining the advertiser's bill, query the advertiser's cash pool account to determine whether there is available credit in the advertiser's cash pool; S104. In response to the availability of funds in the advertiser's cash pool, the advertiser's bill is cancelled, and the available funds in the advertiser's cash pool are deducted based on the cancelled amount.

[0022] In one embodiment, a bill reconciliation flow mode is also included, which includes: S201, in response to the user initiating a reconciliation action in the bank statement list and entering a claim reconciliation instruction, matching the payment information of the bank statement with the invoice information of the advertiser's bill in the company's reconciliation system, and displaying the successfully matched advertiser's bill; wherein, the invoice information includes the payment entity and the invoice amount, and the payment information includes the payment entity, payment remarks and transaction amount; Methods for obtaining bank transaction records include: periodically retrieving bank transaction records from third-party banking systems, extracting bank transaction information, and storing it in the bank transaction record list of the bill reconciliation system; bank transaction information includes bank transaction number, transaction date, transaction amount, transaction currency, payee, payee account, payer, and payment remarks; S201, in response to the user checking the need to be cancelled from the matched advertiser bill, filling in the amount to be cancelled, and inputting the confirmation cancellation instruction, comparing the amount to be cancelled with the remaining amount of the bank flow, if the amount to be cancelled is less than or equal to the remaining amount, the actual cancellation amount of the advertiser bill is equal to the amount to be cancelled; otherwise, the actual cancellation amount of the advertiser bill is equal to the remaining amount; update the cancelled amount of the advertiser bill.

[0023] In one embodiment, the bill cancellation flow mode further comprises: S301, in response to the completion of the cancellation, associating the advertiser bill and the flow, and storing the association information, the association information comprising bill information, flow information and claim amount information; S302, recalculate the matching state of the bank flow, if the bank flow amount is equal to the matched amount of the bank flow, the matching state is set to matched; if the bank flow amount is greater than the matched amount of the bank flow, the matching state is set to partially matched; if the matched amount of the bank flow is zero, the matching state is set to unmatched; S303, recalculate the cancellation state of the advertiser bill, if the advertiser bill amount is equal to the cancelled amount of the advertiser bill, the cancellation state is set to cancelled; if the advertiser bill amount is greater than the cancelled amount of the advertiser bill, the cancellation state is set to partially cancelled; if the cancelled amount of the advertiser bill is zero, the cancellation state is set to uncancelled.

[0024] In one embodiment, the bill cancellation flow mode further comprises an exception handling mechanism, which comprises: S401, scan the cancellation result regularly to identify abnormal situations, the types of abnormal situations including amount deviation and invoice cancellation; the amount deviation refers to the difference between the cancellation amount and the bill amount exceeding a preset threshold; S402, if there is an abnormal situation of invoice cancellation, automatically release the original flow attached to the cancelled invoice, and create a bill virtual invoice, and reattach the released flow to the bill virtual invoice.

[0025] In one embodiment, the exception handling mechanism further comprises: S501, if there is an amount deviation, delete the original matching record and re-execute the bill cancellation flow process; S502, in response to the completion of the bill cancellation flow process, recheck whether there is a deviation between the cancellation amount and the bill amount, if the deviation amount is 0, notify the user of the successful repair, otherwise, notify the user of manual intervention.

[0026] In one embodiment, it further comprises a bill cancellation return point bill mode, the bill cancellation return point bill mode comprising: S601, in response to the user selecting a to-be-reconciled advertiser bill in the advertiser bill list, filling in the to-be-reconciled amount, and inputting a claim reconciliation instruction, filtering a rebate bill with the same advertiser ID and business type as the to-be-reconciled advertiser bill from the rebate bills of the company's account system and displaying the same; S602, in response to the user selecting a to-be-reconciled rebate bill from the filtered rebate bills, filling in the to-be-reconciled amount, and inputting a confirmation reconciliation instruction, determining whether the to-be-reconciled amount of the selected rebate bill is equal to the to-be-reconciled amount of the to-be-reconciled advertiser bill, and if so, reconciling the to-be-reconciled advertiser bill, the reconciliation amount being the filled-in to-be-reconciled amount; updating the reconciled amount of the to-be-reconciled rebate bill and the to-be-reconciled advertiser bill.

[0027] In one embodiment, the bill reconciliation rebate bill mode further comprises: After reconciliation is completed, the reconciliation status of the to-be-reconciled advertiser bill is reset, including: if the amount of the to-be-reconciled advertiser bill is equal to the reconciled amount of the to-be-reconciled advertiser bill, the reconciliation status is set to reconciled; if the amount of the to-be-reconciled advertiser bill is greater than the reconciled amount of the to-be-reconciled advertiser bill, the reconciliation status is set to partially reconciled; if the reconciled amount of the to-be-reconciled advertiser bill is zero, the reconciliation status is set to unreconciled; After reconciliation is completed, the reconciliation status of the rebate bill is reset, including: if the amount of the rebate bill is equal to the reconciled amount of the rebate bill, the reconciliation status is set to reconciled; if the amount of the rebate bill is greater than the reconciled amount of the rebate bill, the reconciliation status is set to partially reconciled; if the reconciled amount of the rebate bill is zero, the reconciliation status is set to unreconciled.

[0028] In one embodiment, the bill reconciliation rebate bill mode further comprises: S701, in response to the user selecting a to-be-reconciled advertiser bill from the advertiser bill list and inputting a special reconciliation instruction, displaying a reconciliation type list, the reconciliation types in the reconciliation type list including clearing balance deduction, bad debt deduction, other deductions, quota transfer deduction, fee special column bearing deduction, other tax deduction, and exchange loss and gain deduction; S702, in response to the user selecting a reconciliation type from the reconciliation type list and filling in the corresponding deduction amount, executing the reconciliation process corresponding to the selected various reconciliation types; S703, in response to the completion of the reconciliation process corresponding to the selected various reconciliation types, updating the reconciled amount of the to-be-reconciled advertiser bill according to the sum of the deduction amounts corresponding to the selected various reconciliation types; S704, resetting the cancellation state of the to-be-cancelled advertiser bill, if the amount of the to-be-cancelled advertiser bill is equal to the cancelled amount, the cancellation state is set as cancelled; if the amount of the to-be-cancelled advertiser bill is greater than the cancelled amount, the cancellation state is set as partially cancelled; if the cancelled amount of the to-be-cancelled advertiser bill is zero, the cancellation state is set as not cancelled.

[0029] In the embodiment, the cancellation process corresponding to the clearing balance deduction includes: In response to the user filling in the first deduction information and inputting the confirmation cancellation instruction, a positive and negative virtual bank flow is generated, wherein the positive virtual bank flow is used for cancelling the advertiser bill, and the negative virtual bank flow is used for deducting the fund pool of the advertiser and deducting the available amount; the first deduction information includes the deduction amount and the deduction description.

[0030] The cancellation process corresponding to the quota transfer deduction includes: in response to the user filling in the second deduction information and inputting the confirmation cancellation instruction, a positive and negative virtual bank flow is generated, wherein the positive virtual bank flow is used for cancelling the advertiser bill, and the negative flow is used for deducting the fund pool of the advertiser of the quota transfer out party and deducting the available amount; the second deduction information includes the deduction amount, the deduction description and the ID of the advertiser of the quota transfer out party.

[0031] The cancellation process corresponding to the bad debt deduction, the other deduction, the handling fee special column bearing deduction, the other tax deduction and the exchange loss and gain deduction includes: in response to the user filling in the third deduction information and inputting the confirmation cancellation instruction, a positive virtual bank flow is generated for cancelling the advertiser bill; the third deduction information includes the deduction amount, the deduction description and other information.

[0032] In one embodiment, a combined cancellation mode is further included, and the combined cancellation mode includes: S801, performing a bill cancellation flow of a bill cancellation flow mode on the advertiser bill, so as to obtain a first cancellation amount; S802, performing a bill cancellation flow of a bill cancellation return point bill mode on the advertiser bill, so as to obtain a second cancellation amount; S803, adding the first cancellation amount and the second cancellation amount, so as to obtain a total cancellation amount; S804, comparing the bill amount of the advertiser bill with the total cancellation amount, if the bill amount is equal to the cancelled amount of the bill, the cancellation state is set as cancelled; if the bill amount is greater than the cancelled amount of the bill, the cancellation state is set as partially cancelled.

[0033] An embodiment of a bill cancellation system: The application further provides a bill cancellation system. Figure 2As shown, the bill canceling system comprises a processor and a memory, the memory stores computer program instructions, when the computer program instructions are executed by the processor, a bill canceling method described in the above embodiments is realized.

[0034] The bill canceling system further comprises a communication bus and a communication interface and other components well known to those skilled in the art, the settings and functions of which are known in the art, and thus will not be described here.

[0035] In the present application, the aforementioned memory can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus, or device. For example, the computer readable storage medium can be any appropriate magnetic storage medium or magneto-optical storage medium, such as Resistive Random Access Memory (RRAM), Dynamic Random Access Memory (DRAM), Static Random-Access Memory (SRAM), Enhanced Dynamic Random Access Memory (EDRAM), High-Bandwidth Memory (HBM), Hybrid Memory Cube (HMC), etc., or any other medium that can be used to store the desired information and that can be accessed by an application, module, or both. Any such computer storage media can be part of the device or accessible or connectable thereto. Any applications or modules described in the present application can be implemented using computer readable / executable instructions that can be stored or otherwise held by such computer readable media.

[0036] In the description of the present application, the meaning of "a plurality of", "several" is at least two, for example, two, three or more, etc., unless otherwise explicitly specified.

[0037] Although the present application has shown and described the preferred embodiments of the present application, it will be apparent to those skilled in the art that many modifications, changes and substitutions can be made thereto without departing from the spirit and scope of the present application. It should be understood that various alternatives to the embodiments of the application described herein can be employed in practicing the application.

Claims

1. A bill reconciliation method, characterized in that, This includes an automatic bank statement reconciliation mode, which includes: Periodically retrieve bank statements from third-party banking systems and extract bank statement information, including bank statement number, transaction date, transaction amount, transaction currency, payee, payee account, payer, and payment remarks. Periodically retrieve advertiser recharge information from the company's BPMS system, and prepay the bank transaction amount to the advertiser's fund pool based on information such as bank transaction number, advertiser ID, business type, and month in the recharge information; In response to obtaining the advertiser's bill, query the advertiser's cash pool account to determine if there is available credit in the advertiser's cash pool; In response to the availability of funds in the advertiser's cash pool, the advertiser's bill is cleared, and the available funds in the advertiser's cash pool are deducted based on the cleared amount.

2. The bill reconciliation method as described in claim 1, characterized in that, It also includes a bill reconciliation transaction mode, which includes: responding to a user's initiation of a reconciliation action in the bank statement list and inputting a claim reconciliation instruction, matching the payment information in the bank statement with the invoice information in the advertiser's bill in the company's reconciliation system, and displaying the advertiser's bill that has been successfully matched; wherein, the invoice information includes the payment entity and the invoice amount, and the payment information includes the payment entity, payment remarks and transaction amount; In response to the user selecting advertiser bills to be reimbursed from the successfully matched advertiser bills, entering the amount to be reimbursed, and inputting a confirmation reimbursement instruction, the system compares the amount to be reimbursed with the remaining reimbursable amount in the bank statement. If the amount to be reimbursed is less than or equal to the remaining reimbursable amount, the system sets the actual reimbursement amount of the advertiser bill to be equal to the amount to be reimbursed; otherwise, the system sets the actual reimbursement amount of the advertiser bill to be equal to the remaining reimbursable amount; and updates the reimbursed amount of the advertiser bill.

3. The bill reconciliation method as described in claim 2, characterized in that, The bill reconciliation transaction model also includes: in response to the completion of reconciliation, associating the advertiser's bill and transaction history, and storing the associated information, including bill information, transaction history information, and claimed amount information; Recalculate the matching status of the bank statement. If the bank statement amount equals the already matched amount, the matching status is set to matched; if the bank statement amount is greater than the already matched amount, the matching status is set to partially matched; if the already matched amount is zero, the matching status is set to unmatched. Recalculate the reconciliation status of the advertiser's bill. If the advertiser's bill amount equals the reconciled amount, the reconciliation status is set to reconciled; if the advertiser's bill amount is greater than the reconciled amount, the reconciliation status is set to partially reconciled; if the reconciled amount is zero, the reconciliation status is set to unreconciled.

4. The bill reconciliation method as described in claim 2, characterized in that, The bill reconciliation process also includes an anomaly handling mechanism, which includes: periodically scanning the reconciliation results to identify anomalies. The types of anomalies include amount discrepancies and voided invoices. Amount discrepancies refer to the difference between the reconciliation amount and the bill amount exceeding a preset threshold. If there is an abnormal situation where an invoice is voided, the transaction records originally attached to the voided invoice will be automatically released, and a virtual invoice will be created, and the released transaction records will be reattached to the virtual invoice.

5. The bill reconciliation method as described in claim 4, characterized in that, The anomaly handling mechanism also includes: if there is an anomaly of amount deviation, the original matching record is deleted and the bill reconciliation process is re-executed; Once the bill reconciliation process is complete, recheck whether there is a discrepancy between the reconciliation amount and the bill amount. If the discrepancy is 0, notify the user that the correction was successful; otherwise, notify the user for manual intervention.

6. The bill reconciliation method as described in claim 1, characterized in that, This also includes a bill reimbursement rebate bill model, which includes: In response to a user selecting an advertiser bill to be reimbursed in the advertiser bill list, filling in the amount to be reimbursed, and entering a claim reimbursement instruction, the system filters out reimbursement bills from the company's reimbursement system that have the same advertiser ID and business type as the advertiser bill to be reimbursed and displays them. In response to the user selecting a rebate bill to be reconciled from the filtered rebate bills, entering the amount to be reconciled, and inputting a confirmation reconciliation instruction, the system determines whether the amount to be reconciled for the selected rebate bill is equal to the amount to be reconciled for the advertiser bill. If they are equal, the system reconciles the advertiser bill to be reconciled, and the reconciliation amount is the amount to be reconciled entered. The system then updates the reconciled amounts of both the rebate bill to be reconciled and the advertiser bill to be reconciled.

7. The bill reconciliation method as described in claim 6, characterized in that, The bill reimbursement and rebate bill model also includes: After the reconciliation is completed, reset the reconciliation status of the advertiser's bill to be reconciled, including: if the amount of the advertiser's bill to be reconciled is equal to the amount of the advertiser's bill that has already been reconciled, then the reconciliation status is set to reconciled; if the amount of the advertiser's bill to be reconciled is greater than the amount of the advertiser's bill that has already been reconciled, then the reconciliation status is set to partially reconciled; if the amount of the advertiser's bill that has already been reconciled is zero, then the reconciliation status is set to not reconciled. After the reimbursement is completed, reset the reimbursement status of the reimbursement bill. If the amount of the reimbursement bill is equal to the reimbursed amount of the reimbursement bill, the reimbursement status is set to reimbursed; if the amount of the reimbursement bill is greater than the reimbursed amount of the reimbursement bill, the reimbursement status is set to partially reimbursed; if the reimbursement amount of the reimbursement bill is zero, the reimbursement status is set to unreimbursed.

8. The bill reconciliation method as described in claim 1, characterized in that, This also includes special invoice reimbursement modes, which include: In response to a user selecting an advertiser bill to be reimbursed from the advertiser bill list and entering a special reimbursement instruction, a list of reimbursement types is displayed. The reimbursement types in the list include settlement balance deduction, bad debt deduction, other deductions, credit line transfer deduction, special handling fee deduction, other tax deductions, and exchange gain / loss deduction. In response to the user selecting a reimbursement type from the reimbursement type list and filling in the corresponding deduction amount, the reimbursement process corresponding to the selected reimbursement type is executed. In response to the completion of the reimbursement process corresponding to the selected reimbursement types, the system updates the data based on the deduction amount corresponding to the selected reimbursement types and the already reimbursed amount of the advertiser's bill to be reimbursed. Reset the reconciliation status of advertiser bills pending reconciliation. If the amount of the advertiser bill pending reconciliation is equal to the amount already reconciled, the reconciliation status is set to reconciled; if the amount of the advertiser bill pending reconciliation is greater than the amount already reconciled, the reconciliation status is set to partially reconciled; if the amount already reconciled on the advertiser bill pending reconciliation is zero, the reconciliation status is set to not reconciled.

9. The bill reconciliation method as described in any one of claims 1 to 8 further includes a combined reconciliation mode, wherein the combined reconciliation mode includes: The process of executing the bill reconciliation flow model on the advertiser's bill is used to obtain the first reconciliation amount; The process of performing bill reimbursement and rebate billing on advertisers' bills is used to obtain a second reimbursement amount; The first and second write-off amounts are added together to obtain the total write-off amount; Compare the advertiser's bill amount with the total reimbursement amount. If the bill amount equals the reimbursed amount, the reimbursement status is set to reimbursed; if the bill amount is greater than the reimbursed amount, the reimbursement status is set to partially reimbursed.

10. A bill reconciliation system, comprising a memory and a processor, wherein the memory stores computer program instructions, characterized in that, When the computer program instructions are executed by the processor, the bill reconciliation method according to any one of claims 1 to 9 is implemented.

Images