WO2022142040A1 - Billing data verification method and apparatus, computer device and storage medium - Google Patents

Billing data verification method and apparatus, computer device and storage medium Download PDF

Info

Publication number
WO2022142040A1
WO2022142040A1 PCT/CN2021/091690 CN2021091690W WO2022142040A1 WO 2022142040 A1 WO2022142040 A1 WO 2022142040A1 CN 2021091690 W CN2021091690 W CN 2021091690W WO 2022142040 A1 WO2022142040 A1 WO 2022142040A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
verified
billing
bill
bill data
Prior art date
Application number
PCT/CN2021/091690
Other languages
French (fr)
Chinese (zh)
Inventor
楚亚兵
黑晓群
Original Assignee
平安普惠企业管理有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 平安普惠企业管理有限公司 filed Critical 平安普惠企业管理有限公司
Publication of WO2022142040A1 publication Critical patent/WO2022142040A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Definitions

  • the present application relates to the technical field of digital assets, and in particular, to a method, device, computer equipment and storage medium for verifying billing data.
  • Account reconciliation refers to checking and checking the bills in the account books in order to ensure the correctness and reliability of the records in the account books.
  • Traditional reconciliation work is usually performed by manual reconciliation.
  • manual reconciliation is prone to omission of bills, and the required labor costs are also very huge.
  • many companies have developed their own automated reconciliation systems.
  • the current reconciliation system has a low degree of automation and fails to realize the automation of reconciliation well.
  • the current reconciliation system usually cannot automatically obtain the bill files that need to be reconciled, and the bill files that need to be reconciled need to be uploaded manually.
  • some billing files are in excel format), the reconciliation data in the billing file is scattered and other reasons, and the automatic analysis of the billing file has not been realized.
  • the technical problem to be solved by this application is that the current account reconciliation system has a low degree of automation and fails to realize the automation of account reconciliation well.
  • a first aspect of the present application discloses a method for verifying billing data, the method comprising:
  • the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
  • a second aspect of the present application discloses an apparatus for verifying billing data, the apparatus comprising:
  • the acquisition module is used to acquire the bill file containing the bill data to be verified
  • a parsing module configured to input the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
  • a determining module configured to determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
  • an extraction module configured to extract the data of the standard data type from the original bill data, as the bill data to be verified contained in the bill file;
  • the obtaining module is further configured to obtain reference bill data to be used for the verification of the bill data to be verified;
  • a verification module configured to verify the bill data to be verified according to the reference bill data, and obtain a verification result corresponding to the bill data to be verified, and the verification result is used to indicate that the verification of the bill data to be verified is passed or verified Fail;
  • the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
  • a third aspect of the present application discloses a computer device, the computer device comprising:
  • the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
  • a fourth aspect of the present application discloses a computer storage medium.
  • the computer storage medium stores computer instructions. When the computer instructions are called, the following method is performed:
  • the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
  • the form of manually uploading reconciliation data can be replaced, and different file parsers can be used to complete the parsing of the reconciliation file according to the different file formats of the billing file, and then different types of reconciliation files can be extracted according to the different uploading channels of the billing file.
  • the data is used as the bill data to be verified, so that the bill data to be verified can be accurately extracted from the bill file, which is conducive to improving the efficiency and accuracy of bill data verification, thereby improving the automation of the reconciliation system and better realizing the reconciliation. automation.
  • FIG. 1 is a schematic flowchart of a method for verifying billing data disclosed in an embodiment of the present application
  • FIG. 2 is a schematic structural diagram of a device for verifying billing data disclosed in an embodiment of the present application
  • FIG. 3 is a schematic structural diagram of a computer device disclosed in an embodiment of the present application.
  • FIG. 4 is a schematic structural diagram of a computer storage medium disclosed in an embodiment of the present application.
  • the present application discloses a verification method, device, computer equipment and storage medium for billing data, which can replace the form of manually uploading reconciliation data, and use different file parsers to complete the parsing of the billing file according to the file format of the billing file. , and then extract different types of data as the bill data to be verified according to the different upload channels of the bill file, so that the bill data to be verified can be accurately extracted from the bill file, which is beneficial to improve the efficiency and accuracy of bill data verification, thereby improving the
  • the degree of automation of the reconciliation system can better realize the automation of reconciliation.
  • FIG. 1 is a schematic flowchart of a method for verifying billing data disclosed in an embodiment of the present application. As shown in Figure 1, the verification method of the billing data may include the following operations:
  • the bill file may be a file in multiple file formats, and the bill file in different file formats corresponds to different file parsers.
  • the file format of the obtained bill file may be word format, excel format, txt format, or the like.
  • file parsers corresponding to different file formats can be preset to perform different parsing operations on bill files of different file formats to obtain the bill data to be verified contained in the bill file (described later).
  • the reconciliation system is the most important part of the payment system. It is at the end of the entire payment process.
  • the bill file can be uploaded by the terminal of the third-party payment channel or the terminal of the bank.
  • the reference bill data can be the transaction flow data of the platform where the reconciliation system is located. Compare the bill data to be verified provided by the third-party payment channel or bank with the transaction flow data of the platform. If the two are consistent, the bill is correct, and the verification of the bill data to be verified is passed. If the two are inconsistent, the bill has errors and needs to be verified. Billing data verification failed.
  • file parsers corresponding to different file formats can be preset to perform different parsing operations on bill files of different file formats to obtain the bill data to be verified contained in the bill file.
  • the corresponding file parser may be the ExcelUtil tool. After the bill file is entered into the ExcelUtil tool, you can first check whether the name of the bill file is correct, and then check whether the header of the bill file is filled in according to the standard file, then parse the bill file into a list set, and convert the content of the bill file into For the preset object type, obtain the attribute value corresponding to the table header according to the attribute name, and finally verify the correctness of the content of the billing file.
  • the parsed original bill data may include an upload channel identifier field to distinguish the upload channel of the original bill data. For example, if the upload channel identifier field is recorded as "Bank A", it means that the channel for uploading the original bill data is "Bank A" .
  • the data included in the parsed original billing data is usually messy and redundant.
  • a transaction record in the original billing data may include the serial number, principal, interest, fee, penalty interest, transaction date and other data of the transaction record.
  • different types of data are stored in different fields (for example, a field for principal, a field for interest, etc.). However, when reconciliation is performed on different channels, the data to be reconciled is usually different.
  • Bank A when Bank A reconciles accounts, it needs to compare the fields of the principal, while when Bank B reconciles accounts, it does not need to compare the fields of the principal, but only the fields of the transaction date.
  • only the data in the fields that need to be compared can be extracted as the bill data to be verified.
  • the bill file is uploaded by Bank A
  • extract the data of the principal field from the original bill data corresponding to the bill file as the bill data to be verified.
  • the billing data the data in the transaction date field is extracted as the billing data to be verified.
  • a table can be preset, in which fields to be compared by different upload channels (ie, standard data types) can be recorded. By querying the table, the standard data types of the billing file can be determined.
  • the implementation of the verification method for billing data described in FIG. 1 can replace the form of manually uploading the reconciliation data, and use different file parsers to complete the parsing of the billing file according to the different file formats of the billing file.
  • Different upload channels can extract different types of data as the bill data to be verified, so that the bill data to be verified can be accurately extracted from the bill file, which is beneficial to improve the efficiency and accuracy of bill data verification, thereby improving the automation of the reconciliation system. , to better automate reconciliation.
  • the method further includes:
  • Difference verification is performed on the differential bill data according to the target bill data to obtain a differential verification result corresponding to the differential bill data, where the differential verification result is used to indicate whether the differential bill data passes or fails the differential verification.
  • the transaction records in the bill data to be verified may not be in a one-to-one correspondence with the transaction records (that is, the transaction flow records of the platform) with reference to the bill data, and there is no transaction for which there is a corresponding transaction flow record.
  • the record will cause the verification of the bill data to be verified to fail.
  • a transaction record without a corresponding transaction flow record is extracted from the to-be-verified bill data as the differential bill data.
  • the transaction flow record corresponding to the difference bill data may be in the reference bill data for the last reconciliation process or the reference bill data for the next reconciliation process, so the last time
  • the reference bill data for reconciliation processing or the reference bill data for next reconciliation processing is used as the target bill data, and is compared with the difference bill data (ie difference verification). If the comparison is passed, the difference verification of the difference bill data is passed. , which means that the data of the differential billing data is correct, but it fails to pass the verification due to data omission.
  • the billing data to be verified in the billing file is still equal, and manual verification does not need to be performed again. If the difference verification of the difference billing data fails, it means that the data of the difference billing data may be wrong and need to be checked and corrected manually.
  • the method further includes:
  • the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the difference that fails the difference verification.
  • the difference bill data that fails the difference verification needs to be sent to a manual inspection terminal (for example, the terminal corresponding to the financial staff), and then the financial staff manually Manually check the difference bill data that has not passed the difference verification. If the financial staff manually checks that the difference bill data is correct and valid data, the corresponding account reconciliation operation will be performed on the difference bill data that has not passed the difference verification.
  • the reconciliation operation may be to automatically generate the reference bill data corresponding to the difference bill data that has not passed the difference verification, and then perform a verification on the difference bill data that has not passed the difference verification, so as to make the difference bill that has not passed the difference verification.
  • Data can pass validation.
  • bill reconciliation is a common requirement. If the bill data is true and valid after manual inspection, the bill data in the reconciliation system can be reconciled by performing an account reconciliation operation.
  • this optional embodiment can manually check the differential bill data that has not passed the differential verification when the verification of the differential bill data fails, so that the verification result can be made more accurate by means of manual verification, and the results can be checked manually.
  • the difference bill data that has not passed the difference verification is real and valid
  • the corresponding account reconciliation operation is performed to realize the automatic execution of the reconciliation operation, which further improves the automation of the reconciliation system.
  • the method further includes:
  • the similar bill data is sent to the manual checking terminal.
  • the bill data to be manually inspected is likely to be incorrect data.
  • the reconciliation system there are many factors that cause incorrect billing data, such as incorrect entry data caused by user's misoperation, data loss during the transmission of billing data, etc. If some insignificant factor caused the incorrect billing data, the error is usually minor, such as a missing or changed number.
  • the similar bill data in the reference bill data and the target bill data that is similar to the bill data to be manually checked is first inquired, and then the similar bill data is sent to the manual check terminal, which can assist the user to correct the wrong bill data (the user is in the comparison After similar billing data and manual checking of billing data, it is easier to find errors in manual checking of billing data, which is more beneficial for users to correct data).
  • this optional embodiment can send similar billing data to the manual checking terminal after manual checking and confirm that the billing data to be checked manually is wrong data, so as to assist the user in correcting the wrongly checking billing data manually, and improve the accuracy of the checking.
  • the intelligence of the accounting system can send similar billing data to the manual checking terminal after manual checking and confirm that the billing data to be checked manually is wrong data, so as to assist the user in correcting the wrongly checking billing data manually, and improve the accuracy of the checking.
  • the bill data to be verified includes at least one transaction record to be verified, and each transaction record to be verified includes at least a record identifier and transaction information corresponding to the bill record to be verified.
  • the billing data includes at least one reference transaction record, and each of the reference transaction records includes at least a record identifier and transaction information corresponding to the reference transaction record;
  • performing the verification on the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified including:
  • the bill data to be verified and the reference bill data are stored in redis according to the syntax of redis cache, and then the redisdiff algorithm is used to compare the bill data to be verified and the reference bill data, so that the redisdiff algorithm can be used. high performance and improve the speed of data validation.
  • the comparison between the bill data to be verified and the reference bill data may include the following methods: comparing whether the number of records of successful transactions in the bill data to be verified and the reference bill data are consistent, comparing all the records in the bill data to be verified and the reference bill data Whether the number of records is consistent, compare whether the record identification and transaction information (which may include information such as principal, interest, fees, penalty interest, etc.) of each record in the bill data to be verified and the reference bill data are consistent. If the comparison result of one of the above comparison methods is inconsistent, it can be determined that the verification result corresponding to the bill data to be verified is that the verification fails.
  • the reissdiff algorithm can be used to compare the bill data to be verified with the reference bill data, so that the high performance of the reissdiff algorithm can be utilized to improve the verification efficiency of the bill data.
  • the acquiring a billing file containing billing data to be verified includes:
  • a third-party payment channel or the bank's system can be pre-agreed to push the bill file to the specified target ftp server regularly, and then the account reconciliation system is
  • the billing file can be obtained from the target ftp server for verification.
  • the efficiency of obtaining the billing file can be improved by utilizing the efficiency of the ftp server for transferring files. Since the ftp server downloads or operates multiple files for a long time, the connection will be disconnected due to timeout. Therefore, when the third-party system pushes the billing file to the target ftp server, it is necessary to set the link timeout time.
  • the file push time exceeds the link timeout time, determine If the target ftp server is stuck, you need to re-link the target ftp server and push the billing file again.
  • the interval between re-linking and pushing can be every 5-10 minutes (that is, the target ftp server is re-linked every 5-10 minutes).
  • the link timeout time can be set to 30 minutes.
  • the bill file upload can be completed within 30 minutes. If the bill file upload time exceeds 30 minutes, the server may freeze.
  • some third-party payment channels or bank systems third-party systems provide a download interface for downloading bill files, and the download interface can be called periodically to obtain bill files.
  • this optional embodiment can provide different ways to obtain billing files, and can improve the efficiency of obtaining billing files by utilizing the efficiency of file transmission by the ftp server, thereby improving the verification efficiency of billing data.
  • the verification information is obtained by running the verification method of the billing data, and is used to record the verification status of the billing data, for example, the file name of the acquired billing file, the parsed original billing data, the The extracted bill data to be verified, the obtained reference bill data, the verification result of the bill data to be verified, and so on.
  • Uploading verification information to the blockchain ensures its security and fairness and transparency to users.
  • the user can download the verification information from the blockchain, so as to check whether the verification information of the verification method of the billing data has been tampered with.
  • the blockchain referred to in this example is a new application mode of computer technology such as distributed data storage, point-to-point transmission, consensus mechanism, and encryption algorithm.
  • Blockchain essentially a decentralized database, is a series of data blocks associated with cryptographic methods. Each data block contains a batch of network transaction information to verify its Validity of information (anti-counterfeiting) and generation of the next block.
  • the blockchain can include the underlying platform of the blockchain, the platform product service layer, and the application service layer.
  • FIG. 2 is a schematic structural diagram of an apparatus for verifying billing data disclosed in an embodiment of the present application.
  • the verification device for billing data may include:
  • an obtaining module 201 configured to obtain a bill file containing bill data to be verified
  • a parsing module 202 configured to input the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
  • a determination module 203 configured to determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
  • an extraction module 204 configured to extract the data of the standard data type from the original bill data, as the bill data to be verified contained in the bill file;
  • the obtaining module 201 is further configured to obtain reference bill data to be used for the verification of the bill data to be verified;
  • the verification module 205 is configured to verify the bill data to be verified according to the reference bill data, and obtain a verification result corresponding to the bill data to be verified, and the verification result is used to indicate that the verification of the bill data to be verified has passed or verification failed;
  • the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
  • the extraction module 204 is further configured to verify the bill data to be verified according to the reference bill data in the verification module 205 to obtain the verification corresponding to the bill data to be verified After the result, when the verification result is used to indicate that the verification of the to-be-verified bill data fails, extract the unverified differential bill data from the to-be-verified bill data;
  • the obtaining module 201 is further configured to obtain target billing data for verifying the differential billing data
  • the device also includes:
  • a difference verification module configured to perform difference verification on the difference bill data according to the target bill data, and obtain a difference verification result corresponding to the difference bill data, where the difference verification result is used to represent the difference verification of the difference bill data Pass or fail.
  • the apparatus further includes:
  • the sending module is configured to, after the difference verification module performs the difference verification on the difference bill data according to the target bill data, and obtains the difference verification result corresponding to the difference bill data, when the difference verification result is used to indicate the difference verification result.
  • the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the differential bill data that has not passed the differential verification;
  • a receiving module configured to receive a manual check result input by a user at the manual check terminal based on the bill data to be checked manually, where the manual check result is used to indicate that the bill data to be checked manually is valid or invalid;
  • the account reconciliation module is configured to, when the manual inspection result received by the receiving module is used to indicate that the bill data to be manually inspected is valid, execute the corresponding process of the bill data to be manually inspected for the bill data to be manually inspected. Balance operation.
  • the apparatus further includes:
  • the judgment module is configured to judge whether the reference bill data and the target bill data exist in the reference bill data and the target bill data when the manual check result received by the receiving module is used to indicate that the bill data to be checked manually is invalid. Manually check similar billing data with similar billing data;
  • the sending module is further configured to send the similar bill data to the manual checking terminal when the judgment module judges that the similar bill data exists in the reference bill data and the target bill data.
  • the bill data to be verified includes at least one transaction record to be verified, and each transaction record to be verified includes at least a record identifier and transaction information corresponding to the bill record to be verified.
  • the billing data includes at least one reference transaction record, and each of the reference transaction records includes at least a record identifier and transaction information corresponding to the reference transaction record;
  • the verification module 205 verifies the bill data to be verified according to the reference bill data, and the specific manner of obtaining the verification result corresponding to the bill data to be verified is as follows:
  • the specific manner in which the acquiring module 201 acquires the bill file containing the bill data to be verified is:
  • FIG. 3 is a schematic structural diagram of a computer device disclosed in an embodiment of the present application.
  • the computer equipment may include:
  • a memory 301 storing executable program code
  • processor 302 connected to the memory 301;
  • the processor 302 invokes the executable program code stored in the memory 301 to execute the steps in the method for verifying billing data disclosed in Embodiment 1 of the present application.
  • the embodiment of the present application discloses a computer storage medium 401, where the computer storage medium 401 stores computer instructions, and when the computer instructions are invoked, is used to execute the steps in the method for verifying billing data disclosed in the first embodiment of the present application.
  • the computer storage medium 401 may be non-volatile or volatile.
  • modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical modules, that is, they may be located in One place, or it can be distributed over multiple network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution in this embodiment. Those of ordinary skill in the art can understand and implement it without creative effort.

Abstract

A billing data verification method, comprising: obtaining a billing file containing billing data to be verified (101); inputting the billing file into a file parser corresponding to a file format of the billing file for parsing to obtain original billing data corresponding to the billing file (102); determining, according to an uploading channel identifier corresponding to the billing file, a standard data type corresponding to the billing file (103); extracting data of the standard data type from the original billing data to serve as the billing data to be verified contained in the billing file (104); obtaining reference billing data to be used for verifying the billing data to be verified (105); and verifying, according to the reference billing data, the billing data to be verified to obtain a verification result corresponding to the billing data to be verified, the verification result being used for indicating that the billing data to be verified passes the verification or fails to pass the verification (106). The automation degree of a reconciliation system can be improved, and thus, the automation of the reconciliation can be better implemented.

Description

账单数据的验证方法、装置、计算机设备以及存储介质Verification method, device, computer equipment and storage medium for billing data
 本申请要求于2020年12月29日提交中国专利局、申请号为202011590424.X,发明名称为“账单数据的验证方法、装置、计算机设备以及存储介质”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。This application claims the priority of the Chinese patent application filed on December 29, 2020 with the application number 202011590424.X and the invention titled "Method, Device, Computer Equipment and Storage Medium for Verification of Billing Data", all of which The contents are incorporated herein by reference.
技术领域technical field
本申请涉及数字资产技术领域,尤其涉及一种账单数据的验证方法、装置、计算机设备以及存储介质。The present application relates to the technical field of digital assets, and in particular, to a method, device, computer equipment and storage medium for verifying billing data.
背景技术Background technique
对账是指在会计核算中,为保证账簿记录正确可靠,对账簿中的账单进行检查和核对工作。传统的对账工作通常使用人工对账的方式进行,然而人工对账很容易发生账单遗漏的情况,且需要的人力成本也是非常巨大的。为了提高对账效率,节约人力成本,许多公司都研发了各自的自动化对账系统。但是,发明人发现,目前的对账系统的自动化程度较低,未能很好地实现对账的自动化。例如,目前的对账系统通常不能自动获取需要对账的账单文件,需要由人工上传需要对账的账单文件,且由于账单文件的文件格式多种多种(例如,有的账单文件是word格式,有的账单文件是excel格式),账单文件中的对账数据散乱等原因,也未能实现账单文件的自动化解析。Account reconciliation refers to checking and checking the bills in the account books in order to ensure the correctness and reliability of the records in the account books. Traditional reconciliation work is usually performed by manual reconciliation. However, manual reconciliation is prone to omission of bills, and the required labor costs are also very huge. In order to improve reconciliation efficiency and save labor costs, many companies have developed their own automated reconciliation systems. However, the inventor found that the current reconciliation system has a low degree of automation and fails to realize the automation of reconciliation well. For example, the current reconciliation system usually cannot automatically obtain the bill files that need to be reconciled, and the bill files that need to be reconciled need to be uploaded manually. , some billing files are in excel format), the reconciliation data in the billing file is scattered and other reasons, and the automatic analysis of the billing file has not been realized.
技术问题technical problem
本申请所要解决的技术问题在于,目前的对账系统的自动化程度较低,未能很好地实现对账的自动化。The technical problem to be solved by this application is that the current account reconciliation system has a low degree of automation and fails to realize the automation of account reconciliation well.
技术解决方案technical solutions
为了解决上述技术问题,本申请第一方面公开了一种账单数据的验证方法,所述方法包括:In order to solve the above technical problems, a first aspect of the present application discloses a method for verifying billing data, the method comprising:
获取包含有待验证账单数据的账单文件;Obtain a billing file containing billing data to be verified;
将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;inputting the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;Extracting the data of the standard data type from the original billing data as the billing data to be verified contained in the billing file;
获取将要用于进行所述待验证账单数据的验证的参照账单数据;obtaining reference billing data to be used for the verification of the billing data to be verified;
根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;Verifying the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified has passed or the verification has failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
本申请第二方面公开了一种账单数据的验证装置,所述装置包括:A second aspect of the present application discloses an apparatus for verifying billing data, the apparatus comprising:
获取模块,用于获取包含有待验证账单数据的账单文件;The acquisition module is used to acquire the bill file containing the bill data to be verified;
解析模块,用于将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;a parsing module, configured to input the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
确定模块,用于根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;a determining module, configured to determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
提取模块,用于从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;an extraction module, configured to extract the data of the standard data type from the original bill data, as the bill data to be verified contained in the bill file;
所述获取模块,还用于获取将要用于进行所述待验证账单数据的验证的参照账单数据;The obtaining module is further configured to obtain reference bill data to be used for the verification of the bill data to be verified;
验证模块,用于根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;A verification module, configured to verify the bill data to be verified according to the reference bill data, and obtain a verification result corresponding to the bill data to be verified, and the verification result is used to indicate that the verification of the bill data to be verified is passed or verified Fail;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
本申请第三方面公开了一种计算机设备,所述计算机设备包括:A third aspect of the present application discloses a computer device, the computer device comprising:
存储有可执行程序代码的存储器;a memory in which executable program code is stored;
与所述存储器连接的处理器;a processor connected to the memory;
所述处理器调用所述存储器中存储的所述可执行程序代码时,执行如下方法:When the processor calls the executable program code stored in the memory, the following method is performed:
获取包含有待验证账单数据的账单文件;Obtain a billing file containing billing data to be verified;
将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;inputting the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;Extracting the data of the standard data type from the original billing data as the billing data to be verified contained in the billing file;
获取将要用于进行所述待验证账单数据的验证的参照账单数据;obtaining reference billing data to be used for the verification of the billing data to be verified;
根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;Verifying the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified has passed or the verification has failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
本申请第四方面公开了一种计算机存储介质,所述计算机存储介质存储有计算机指令,所述计算机指令被调用时,执行如下方法:A fourth aspect of the present application discloses a computer storage medium. The computer storage medium stores computer instructions. When the computer instructions are called, the following method is performed:
获取包含有待验证账单数据的账单文件;Obtain a billing file containing billing data to be verified;
将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;inputting the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;Extracting the data of the standard data type from the original billing data as the billing data to be verified contained in the billing file;
获取将要用于进行所述待验证账单数据的验证的参照账单数据;obtaining reference billing data to be used for the verification of the billing data to be verified;
根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;Verifying the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified has passed or the verification has failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
有益效果beneficial effect
本申请实施例中,能够替代人工上传对账数据的形式,并根据账单文件的文件格式不同使用不同的文件解析器完成对账单文件的解析,然后根据账单文件的上传渠道的不同提取不同类型的数据作为待验证账单数据,从而能够准确地从账单文件中提取出待验证账单数据,有利于提高账单数据验证的效率和准确性,进而提高对账系统的自动化程度,更好地实现对账的自动化。In the embodiment of the present application, the form of manually uploading reconciliation data can be replaced, and different file parsers can be used to complete the parsing of the reconciliation file according to the different file formats of the billing file, and then different types of reconciliation files can be extracted according to the different uploading channels of the billing file. The data is used as the bill data to be verified, so that the bill data to be verified can be accurately extracted from the bill file, which is conducive to improving the efficiency and accuracy of bill data verification, thereby improving the automation of the reconciliation system and better realizing the reconciliation. automation.
附图说明Description of drawings
为了更清楚地说明本申请实施例中的技术方案,下面将对实施例描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本申请的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to illustrate the technical solutions in the embodiments of the present application more clearly, the following briefly introduces the drawings that are used in the description of the embodiments. Obviously, the drawings in the following description are only some embodiments of the present application. For those of ordinary skill in the art, other drawings can also be obtained from these drawings without creative effort.
图1是本申请实施例公开的一种账单数据的验证方法的流程示意图;1 is a schematic flowchart of a method for verifying billing data disclosed in an embodiment of the present application;
图2是本申请实施例公开的一种账单数据的验证装置的结构示意图;2 is a schematic structural diagram of a device for verifying billing data disclosed in an embodiment of the present application;
图3是本申请实施例公开的一种计算机设备的结构示意图;3 is a schematic structural diagram of a computer device disclosed in an embodiment of the present application;
图4是本申请实施例公开的一种计算机存储介质的结构示意图。FIG. 4 is a schematic structural diagram of a computer storage medium disclosed in an embodiment of the present application.
本发明的实施方式Embodiments of the present invention
本申请公开了一种账单数据的验证方法、装置、计算机设备以及存储介质,能够替代人工上传对账数据的形式,并根据账单文件的文件格式不同使用不同的文件解析器完成对账单文件的解析,然后根据账单文件的上传渠道的不同提取不同类型的数据作为待验证账单数据,从而能够准确地从账单文件中提取出待验证账单数据,有利于提高账单数据验证的效率和准确性,进而提高对账系统的自动化程度,更好地实现对账的自动化。以下分别进行详细说明。The present application discloses a verification method, device, computer equipment and storage medium for billing data, which can replace the form of manually uploading reconciliation data, and use different file parsers to complete the parsing of the billing file according to the file format of the billing file. , and then extract different types of data as the bill data to be verified according to the different upload channels of the bill file, so that the bill data to be verified can be accurately extracted from the bill file, which is beneficial to improve the efficiency and accuracy of bill data verification, thereby improving the The degree of automation of the reconciliation system can better realize the automation of reconciliation. Each of them will be described in detail below.
实施例一Example 1
请参阅图1,图1是本申请实施例公开的一种账单数据的验证方法的流程示意图。如图1所示,该账单数据的验证方法可以包括以下操作:Please refer to FIG. 1. FIG. 1 is a schematic flowchart of a method for verifying billing data disclosed in an embodiment of the present application. As shown in Figure 1, the verification method of the billing data may include the following operations:
101、获取包含有待验证账单数据的账单文件。101. Obtain a bill file containing bill data to be verified.
102、将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据。102. Input the billing file into a file parser corresponding to the file format of the billing file for analysis, and obtain original billing data corresponding to the billing file.
103、根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型。103. Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file.
104、从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据。104. Extract the data of the standard data type from the original bill data, as the bill data to be verified contained in the bill file.
105、获取将要用于进行所述待验证账单数据的验证的参照账单数据。105. Acquire reference bill data to be used for verifying the bill data to be verified.
106、根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过。106. Verify the bill data to be verified according to the reference bill data, and obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified passes or fails.
本申请实施例中,账单文件可以是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。通过自动获取包含有待验证账单数据的账单文件进行后续的账单数据验证,不需要由人工上传账单文件,从而能够提高对账流程的自动化程度。其中,获取到的账单文件的文件格式可以是word格式、excel格式、txt格式等。在对账系统中,可以预设不同文件格式对应的文件解析器,用于对不同文件格式的账单文件进行不同的解析操作以得到账单文件中所包含的待验证账单数据(稍后描述)。另外,对账系统是支付系统中最重要的一环,处于整个支付环节的最尾端,主要用于保证平台的交易流水数据和第三方支付渠道或银行账单数据的一致性,是保证支付系统资金安全的最后一道防线。假设对账系统应用在支付系统中,则账单文件可以是由第三方支付渠道的终端或者银行的终端上传的,此时,参照账单数据则可以是对账系统所在平台的交易流水数据。将由第三方支付渠道或者银行提供的待验证账单数据与平台的交易流水数据进行对比,若两者一致,则账单正确,待验证账单数据验证通过,若两者不一致,则账单存在错误,待验证账单数据验证不通过。In this embodiment of the present application, the bill file may be a file in multiple file formats, and the bill file in different file formats corresponds to different file parsers. By automatically obtaining the billing file containing the billing data to be verified for subsequent billing data verification, there is no need to manually upload the billing file, thereby improving the automation of the reconciliation process. The file format of the obtained bill file may be word format, excel format, txt format, or the like. In the account reconciliation system, file parsers corresponding to different file formats can be preset to perform different parsing operations on bill files of different file formats to obtain the bill data to be verified contained in the bill file (described later). In addition, the reconciliation system is the most important part of the payment system. It is at the end of the entire payment process. It is mainly used to ensure the consistency of the transaction flow data of the platform and the data of third-party payment channels or bank bills. It is the guarantee of the payment system. The last line of defense for financial security. Assuming that the reconciliation system is applied in the payment system, the bill file can be uploaded by the terminal of the third-party payment channel or the terminal of the bank. In this case, the reference bill data can be the transaction flow data of the platform where the reconciliation system is located. Compare the bill data to be verified provided by the third-party payment channel or bank with the transaction flow data of the platform. If the two are consistent, the bill is correct, and the verification of the bill data to be verified is passed. If the two are inconsistent, the bill has errors and needs to be verified. Billing data verification failed.
在对账系统中,可以预设不同文件格式对应的文件解析器,用于对不同文件格式的账单文件进行不同的解析操作以得到账单文件中所包含的待验证账单数据。例如,账单文件的文件格式为excel,则对应的文件解析器可以是ExcelUtil工具。在账单文件输入至ExcelUtil工具之后,可以先校验账单文件的名称是否正确,再校验账单文件的表头是否按照标准文件填写,然后将账单文件解析成list集合,将账单文件的内容转换成预先设置的对象类型,根据属性名获取与表格表头对应的属性值,最后校验账单文件内容的正确性,若校验通过,则得到账单文件对应的原始账单数据。解析出的原始账单数据可以包括上传渠道标识字段,用于区分原始账单数据的上传渠道,如,上传渠道标识字段记录为“A银行”,则表示上传该原始账单数据的渠道为“A银行”。另外,解析出的原始账单数据所包括的数据通常比较杂乱且冗余,例如,原始账单数据中一条交易记录可以包括交易记录的流水号、本金、利息、费用、罚息、交易日期等数据,不同类型的数据存储在不同的字段中(如,本金对应一个字段、利息对应一个字段等等)。但是,不同渠道进行对账时,所需要比对的数据通常不一样。例如,A银行对账时需要比对本金的字段,而B银行对账时不需要比对本金的字段,只需要比对交易日期的字段。为简化比对操作,可以仅提取需要进行比对的字段中的数据,以作为待验证账单数据。假设账单文件是由A银行上传的,则从账单文件对应的原始账单数据中,提取本金字段的数据作为待验证账单数据,假设账单文件是由B银行上传的,则从账单文件对应的原始账单数据中,提取交易日期字段的数据作为待验证账单数据。具体地,可以预设一个表格,表格中可以记录有不同的上传渠道需要比对的字段(即标准数据类型),通过查询该表格即能够确定账单文件的标准数据类型。In the account reconciliation system, file parsers corresponding to different file formats can be preset to perform different parsing operations on bill files of different file formats to obtain the bill data to be verified contained in the bill file. For example, if the file format of the bill file is excel, the corresponding file parser may be the ExcelUtil tool. After the bill file is entered into the ExcelUtil tool, you can first check whether the name of the bill file is correct, and then check whether the header of the bill file is filled in according to the standard file, then parse the bill file into a list set, and convert the content of the bill file into For the preset object type, obtain the attribute value corresponding to the table header according to the attribute name, and finally verify the correctness of the content of the billing file. If the verification is passed, the original billing data corresponding to the billing file is obtained. The parsed original bill data may include an upload channel identifier field to distinguish the upload channel of the original bill data. For example, if the upload channel identifier field is recorded as "Bank A", it means that the channel for uploading the original bill data is "Bank A" . In addition, the data included in the parsed original billing data is usually messy and redundant. For example, a transaction record in the original billing data may include the serial number, principal, interest, fee, penalty interest, transaction date and other data of the transaction record. , different types of data are stored in different fields (for example, a field for principal, a field for interest, etc.). However, when reconciliation is performed on different channels, the data to be reconciled is usually different. For example, when Bank A reconciles accounts, it needs to compare the fields of the principal, while when Bank B reconciles accounts, it does not need to compare the fields of the principal, but only the fields of the transaction date. To simplify the comparison operation, only the data in the fields that need to be compared can be extracted as the bill data to be verified. Assuming that the bill file is uploaded by Bank A, extract the data of the principal field from the original bill data corresponding to the bill file as the bill data to be verified. In the billing data, the data in the transaction date field is extracted as the billing data to be verified. Specifically, a table can be preset, in which fields to be compared by different upload channels (ie, standard data types) can be recorded. By querying the table, the standard data types of the billing file can be determined.
可见,实施图1所描述的账单数据的验证方法,能够替代人工上传对账数据的形式,并根据账单文件的文件格式不同使用不同的文件解析器完成对账单文件的解析,然后根据账单文件的上传渠道的不同提取不同类型的数据作为待验证账单数据,从而能够准确地从账单文件中提取出待验证账单数据,有利于提高账单数据验证的效率和准确性,进而提高对账系统的自动化程度,更好地实现对账的自动化。It can be seen that the implementation of the verification method for billing data described in FIG. 1 can replace the form of manually uploading the reconciliation data, and use different file parsers to complete the parsing of the billing file according to the different file formats of the billing file. Different upload channels can extract different types of data as the bill data to be verified, so that the bill data to be verified can be accurately extracted from the bill file, which is beneficial to improve the efficiency and accuracy of bill data verification, thereby improving the automation of the reconciliation system. , to better automate reconciliation.
在一个可选的实施例中,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果之后,所述方法还包括:In an optional embodiment, after verifying the bill data to be verified according to the reference bill data, and obtaining a verification result corresponding to the bill data to be verified, the method further includes:
当所述验证结果用于表示所述待验证账单数据验证不通过时,从所述待验证账单数据中提取出未通过验证的差异账单数据;When the verification result is used to indicate that the verification of the to-be-verified bill data fails, extracting the unverified differential bill data from the to-be-verified bill data;
获取用于进行所述差异账单数据的验证的目标账单数据;obtaining target billing data for verification of the differential billing data;
根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果,所述差异验证结果用于表示所述差异账单数据的差异验证通过或者不通过。Difference verification is performed on the differential bill data according to the target bill data to obtain a differential verification result corresponding to the differential bill data, where the differential verification result is used to indicate whether the differential bill data passes or fails the differential verification.
在该可选的实施例中,在使用对账系统进行对账时,有时会出现数据错误或者数据漏传的现象。当出现数据错误或者数据漏传的现象时,待验证账单数据中的交易记录可能不能与参照账单数据的交易记录(即平台的交易流水记录)一一对应,不存在对应的交易流水记录的交易记录会导致待验证账单数据验证不通过。在待验证账单数据验证不通过时,从待验证账单数据中提取出不存在对应的交易流水记录的交易记录作为差异账单数据。若出现的是数据漏传的现象,则差异账单数据对应的交易流水记录可能是在上一次进行对账处理的参照账单数据或者下一次进行对账处理的参照账单数据中,所以可以将上一次进行对账处理的参照账单数据或者下一次进行对账处理的参照账单数据作为目标账单数据,与差异账单数据进行比对(即差异验证),若比对通过,则差异账单数据的差异验证通过,即表示差异账单数据的数据是正确的,只是由于数据遗漏导致未能通过验证,账单文件中的待验证账单数据仍然是平账的,不需要再次进行人工核对,若比对不通过,则差异账单数据的差异验证不通过,则表示差异账单数据的数据有可能是错误的,需要人工核对修正。In this optional embodiment, when reconciliation is performed using the reconciliation system, sometimes data errors or data omissions may occur. When there is a data error or missing data transmission, the transaction records in the bill data to be verified may not be in a one-to-one correspondence with the transaction records (that is, the transaction flow records of the platform) with reference to the bill data, and there is no transaction for which there is a corresponding transaction flow record. The record will cause the verification of the bill data to be verified to fail. When the verification of the to-be-verified bill data fails, a transaction record without a corresponding transaction flow record is extracted from the to-be-verified bill data as the differential bill data. If there is a phenomenon of missing data transmission, the transaction flow record corresponding to the difference bill data may be in the reference bill data for the last reconciliation process or the reference bill data for the next reconciliation process, so the last time The reference bill data for reconciliation processing or the reference bill data for next reconciliation processing is used as the target bill data, and is compared with the difference bill data (ie difference verification). If the comparison is passed, the difference verification of the difference bill data is passed. , which means that the data of the differential billing data is correct, but it fails to pass the verification due to data omission. The billing data to be verified in the billing file is still equal, and manual verification does not need to be performed again. If the difference verification of the difference billing data fails, it means that the data of the difference billing data may be wrong and need to be checked and corrected manually.
可见,实施该可选的实施例,能够在待验证账单数据的验证不通过时,对未通过验证的待验证账单数据进行更进一步的验证,从而使得验证结果更加准确。It can be seen that by implementing this optional embodiment, when the verification of the to-be-verified bill data fails, further verification can be performed on the to-be-verified bill data that has not passed the verification, thereby making the verification result more accurate.
在一个可选的实施例中,所述根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果之后,所述方法还包括:In an optional embodiment, after the difference verification is performed on the differential bill data according to the target bill data, and a differential verification result corresponding to the differential bill data is obtained, the method further includes:
当所述差异验证结果用于表示所述差异账单数据验证不通过时,将待人工查验账单数据发送至预先确定出的人工查验终端,所述待人工查验账单数据是指未通过差异验证的差异账单数据;When the difference verification result is used to indicate that the verification of the difference bill data fails, the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the difference that fails the difference verification. billing data;
接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果,所述人工查验结果用于表示所述待人工查验账单数据有效或者无效;Receive a manual check result input by the user at the manual check terminal based on the bill data to be manually checked, where the manual check result is used to indicate that the bill data to be checked manually is valid or invalid;
当接收到的所述人工查验结果用于表示所述待人工查验账单数据有效时,针对所述待人工查验账单数据执行所述待人工查验账单数据对应的平账操作。When the received manual inspection result is used to indicate that the bill data to be manually inspected is valid, a reconciliation operation corresponding to the bill data to be manually inspected is performed for the bill data to be manually inspected.
在该可选的实施例中,若差异账单数据未能通过差异验证,则需要将未通过差异验证的差异账单数据发送至人工查验终端(如,财务人员对应的终端),再由财务人员人工对未通过差异验证的差异账单数据进行人工核对,若财务人员人工核对差异账单数据是正确有效的数据,则对未通过差异验证的差异账单数据执行对应的平账操作。这里,平账操作可以是自动生成与未通过差异验证的差异账单数据对应的参照账单数据,然后再针对该未通过差异验证的差异账单数据进行一次验证,从而使该未通过差异验证的差异账单数据能够通过验证。在对账系统中,账单平账是常见的需求,若经过人工查验后,账单数据是真实有效的,则可以通过执行平账操作,来使对账系统中的账单数据平账。In this optional embodiment, if the difference bill data fails to pass the difference verification, the difference bill data that fails the difference verification needs to be sent to a manual inspection terminal (for example, the terminal corresponding to the financial staff), and then the financial staff manually Manually check the difference bill data that has not passed the difference verification. If the financial staff manually checks that the difference bill data is correct and valid data, the corresponding account reconciliation operation will be performed on the difference bill data that has not passed the difference verification. Here, the reconciliation operation may be to automatically generate the reference bill data corresponding to the difference bill data that has not passed the difference verification, and then perform a verification on the difference bill data that has not passed the difference verification, so as to make the difference bill that has not passed the difference verification. Data can pass validation. In the account reconciliation system, bill reconciliation is a common requirement. If the bill data is true and valid after manual inspection, the bill data in the reconciliation system can be reconciled by performing an account reconciliation operation.
可见,实施该可选的实施例能够在差异账单数据验证不通过时,对未通过差异验证的差异账单数据进行人工查验,从而能够利用人工查验的方式使得验证结果更加准确,并在人工查验出未通过差异验证的差异账单数据是真实有效时,执行对应的平账操作,实现自动执行平账操作,使得对账系统的自动化程度进一步提升。It can be seen that the implementation of this optional embodiment can manually check the differential bill data that has not passed the differential verification when the verification of the differential bill data fails, so that the verification result can be made more accurate by means of manual verification, and the results can be checked manually. When the difference bill data that has not passed the difference verification is real and valid, the corresponding account reconciliation operation is performed to realize the automatic execution of the reconciliation operation, which further improves the automation of the reconciliation system.
在一个可选的实施例中,所述接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果之后,所述方法还包括:In an optional embodiment, after receiving the manual check result input by the user at the manual check terminal based on the bill data to be checked manually, the method further includes:
当接收到的所述人工查验结果用于表示所述待人工查验账单数据无效时,判断所述参照账单数据和所述目标账单数据中是否存在与所述待人工查验账单数据相似的相似账单数据;When the received manual check result is used to indicate that the bill data to be checked manually is invalid, determine whether there is similar bill data similar to the bill data to be checked manually in the reference bill data and the target bill data ;
当判断出所述参照账单数据和所述目标账单数据中存在所述相似账单数据,将所述相似账单数据发送至所述人工查验终端。When it is determined that the similar bill data exists in the reference bill data and the target bill data, the similar bill data is sent to the manual checking terminal.
在该可选的实施例中,若经过人工查验确认待人工查验账单数据不是真实有效的数据,则待人工查验账单数据有较大的可能是错误的数据。在对账系统中,造成错误的账单数据的因素有很多,如,用户的误操造成了错误的入账数据,账单数据的传输过程中数据丢失等。若是一些影响不大的因素造成了错误的账单数据,则错误通常较为微小,如其中一个数字缺失或者变更。此时,先查询参照账单数据和目标账单数据中与待人工查验账单数据相似的相似账单数据,然后将相似账单数据发送至人工查验终端,能够辅助用户进行错误的账单数据的修正(用户在比对相似账单数据和人工查验账单数据后更容易发现人工查验账单数据的错误所在,更有利于用户修正数据)。In this optional embodiment, if it is confirmed by manual inspection that the bill data to be manually inspected is not real and valid data, the bill data to be manually inspected is likely to be incorrect data. In the reconciliation system, there are many factors that cause incorrect billing data, such as incorrect entry data caused by user's misoperation, data loss during the transmission of billing data, etc. If some insignificant factor caused the incorrect billing data, the error is usually minor, such as a missing or changed number. At this time, the similar bill data in the reference bill data and the target bill data that is similar to the bill data to be manually checked is first inquired, and then the similar bill data is sent to the manual check terminal, which can assist the user to correct the wrong bill data (the user is in the comparison After similar billing data and manual checking of billing data, it is easier to find errors in manual checking of billing data, which is more beneficial for users to correct data).
可见,实施该可选的实施例能够在人工查验待确认出人工查验账单数据为错误的数据之后,将相似账单数据发送至人工查验终端,辅助用户进行错误的人工查验账单数据的修正,提高对账系统的智能化程度。It can be seen that the implementation of this optional embodiment can send similar billing data to the manual checking terminal after manual checking and confirm that the billing data to be checked manually is wrong data, so as to assist the user in correcting the wrongly checking billing data manually, and improve the accuracy of the checking. The intelligence of the accounting system.
在一个可选的实施例中,所述待验证账单数据包括至少一条待验证交易记录,每条所述待验证交易记录至少包括该条待验证账单记录对应的记录标识和交易信息,所述参照账单数据包括至少一条参照交易记录,每条所述参照交易记录至少包括该条参照交易记录对应的记录标识和交易信息;In an optional embodiment, the bill data to be verified includes at least one transaction record to be verified, and each transaction record to be verified includes at least a record identifier and transaction information corresponding to the bill record to be verified. The billing data includes at least one reference transaction record, and each of the reference transaction records includes at least a record identifier and transaction information corresponding to the reference transaction record;
以及,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,包括:And, performing the verification on the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, including:
将所有的所述待验证交易记录和所有的所述参照交易记录存储至redis的Map对象;Store all the transaction records to be verified and all the reference transaction records in the Map object of redis;
将所有的所述待验证交易记录对应的记录标识和所有的所述参照交易记录对应的记录标识存储至redis的set对象;Store the record identifiers corresponding to all the transaction records to be verified and the record identifiers corresponding to all the reference transaction records to the set object of redis;
基于redissdiff算法判断所有的所述待验证交易记录和所有的所述参照交易记录是否存在差异;Based on the redisdiff algorithm, determine whether there is a difference between all the transaction records to be verified and all the reference transaction records;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录存在差异,确定所述待验证账单数据对应的验证结果为验证不通过;When it is judged that there is a difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is a verification failure;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录不存在差异,确定所述待验证账单数据对应的验证结果为验证通过。When it is determined that there is no difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is verified as passed.
在该可选的实施例中,将待验证账单数据和参照账单数据按照redis缓存的语法存储在redis中,然后利用redissdiff算法进行待验证账单数据和参照账单数据的比对,从而能够利用redissdiff算法的高性能,提高数据验证的速度。其中,对待验证账单数据和参照账单数据的比对可以包括如下几种方式:比对待验证账单数据和参照账单数据中交易成功的记录的数量是否一致、比对待验证账单数据和参照账单数据中所有记录的数量是否一致、比对待验证账单数据和参照账单数据中每条记录的记录标识和交易信息(可以包括本金、利息、费用、罚息等信息)是否一致。若上述比对方式中的其中一种方式的比对结果是不一致,则可以确定待验证账单数据对应的验证结果为验证不通过。In this optional embodiment, the bill data to be verified and the reference bill data are stored in redis according to the syntax of redis cache, and then the redisdiff algorithm is used to compare the bill data to be verified and the reference bill data, so that the redisdiff algorithm can be used. high performance and improve the speed of data validation. The comparison between the bill data to be verified and the reference bill data may include the following methods: comparing whether the number of records of successful transactions in the bill data to be verified and the reference bill data are consistent, comparing all the records in the bill data to be verified and the reference bill data Whether the number of records is consistent, compare whether the record identification and transaction information (which may include information such as principal, interest, fees, penalty interest, etc.) of each record in the bill data to be verified and the reference bill data are consistent. If the comparison result of one of the above comparison methods is inconsistent, it can be determined that the verification result corresponding to the bill data to be verified is that the verification fails.
可见,实施该可选的实施例能够利用redissdiff算法进行待验证账单数据和参照账单数据的比对,从而能够利用redissdiff算法的高性能,提高账单数据的验证效率。It can be seen that by implementing this optional embodiment, the reissdiff algorithm can be used to compare the bill data to be verified with the reference bill data, so that the high performance of the reissdiff algorithm can be utilized to improve the verification efficiency of the bill data.
在一个可选的实施例中,所述获取包含有待验证账单数据的账单文件,包括:In an optional embodiment, the acquiring a billing file containing billing data to be verified includes:
从预先设置的目标ftp服务器上获取包含有待验证账单数据的账单文件,其中,所述目标ftp服务器用于存储由第三方系统定时上传的账单文件,或者,Acquire the bill file containing the bill data to be verified from the preset target ftp server, where the target ftp server is used to store the bill file regularly uploaded by the third-party system, or,
调用由第三方系统提供的账单数据下载接口,得到包含有待验证账单数据的账单文件。Call the billing data download interface provided by the third-party system to obtain the billing file containing the billing data to be verified.
在该可选的实施例中,在支付系统中,可以预先约定由第三方支付渠道或者银行的系统(第三方系统)将账单文件定时地推送到指定的目标ftp服务器上,然后对账系统即能够从目标ftp服务器上获取到账单文件进行验证。这样能够利用ftp服务器传输文件的高效性提高获取账单文件的效率。由于ftp服务器长时间下载或者操作多个文件,会导致超时断开链接,所以在第三方系统推送账单文件至目标ftp服务器时,需要设置链接超时时间,若文件推送时间超过链接超时时间,则确定目标ftp服务器卡死,需要重新链接目标ftp服务器,重新推送账单文件,其中,重新链接和推送的时间间隔可以是5-10分钟一次(即每隔5-10分钟重新链接一次目标ftp服务器)。链接超时时间可以设置为30分钟,理论上30分钟内即能够完成账单文件的上传,若账单文件的上传之间超过30分钟,则有可能存在服务器卡死的情况。另外,一些第三方支付渠道或者银行的系统(第三方系统)会提供用于下载账单文件的下载接口,可以定时地调用该下载接口以获得账单文件。In this optional embodiment, in the payment system, a third-party payment channel or the bank's system (third-party system) can be pre-agreed to push the bill file to the specified target ftp server regularly, and then the account reconciliation system is The billing file can be obtained from the target ftp server for verification. In this way, the efficiency of obtaining the billing file can be improved by utilizing the efficiency of the ftp server for transferring files. Since the ftp server downloads or operates multiple files for a long time, the connection will be disconnected due to timeout. Therefore, when the third-party system pushes the billing file to the target ftp server, it is necessary to set the link timeout time. If the file push time exceeds the link timeout time, determine If the target ftp server is stuck, you need to re-link the target ftp server and push the billing file again. The interval between re-linking and pushing can be every 5-10 minutes (that is, the target ftp server is re-linked every 5-10 minutes). The link timeout time can be set to 30 minutes. In theory, the bill file upload can be completed within 30 minutes. If the bill file upload time exceeds 30 minutes, the server may freeze. In addition, some third-party payment channels or bank systems (third-party systems) provide a download interface for downloading bill files, and the download interface can be called periodically to obtain bill files.
可见,实施该可选的实施例能够提供不同的方式来获取账单文件,并且能够利用ftp服务器传输文件的高效性提高获取账单文件的效率,进而提高账单数据的验证效率。It can be seen that implementing this optional embodiment can provide different ways to obtain billing files, and can improve the efficiency of obtaining billing files by utilizing the efficiency of file transmission by the ftp server, thereby improving the verification efficiency of billing data.
可选地,还可以:将所述账单数据的验证方法的验证信息上传至区块链中。Optionally, it is also possible to upload the verification information of the verification method of the billing data to the blockchain.
具体来说,验证信息是通过运行所述账单数据的验证方法后得到的,用于记录账单数据的验证情况,例如,已获取到的账单文件的文件名称、已解析出的原始账单数据、已提取的待验证账单数据、已获取的参照账单数据、待验证账单数据的验证结果等等。将验证信息上传至区块链可保证其安全性和对用户的公正透明性。用户可以从区块链中下载得到该验证信息,以便查证所述账单数据的验证方法的验证信息是否被篡改。本示例所指区块链是分布式数据存储、点对点传输、共识机制、加密算法等计算机技术的新型应用模式。区块链(Blockchain),本质上是一个去中心化的数据库,是一串使用密码学方法相关联产生的数据块,每一个数据块中包含了一批次网络交易的信息,用于验证其信息的有效性(防伪)和生成下一个区块。区块链可以包括区块链底层平台、平台产品服务层以及应用服务层等。Specifically, the verification information is obtained by running the verification method of the billing data, and is used to record the verification status of the billing data, for example, the file name of the acquired billing file, the parsed original billing data, the The extracted bill data to be verified, the obtained reference bill data, the verification result of the bill data to be verified, and so on. Uploading verification information to the blockchain ensures its security and fairness and transparency to users. The user can download the verification information from the blockchain, so as to check whether the verification information of the verification method of the billing data has been tampered with. The blockchain referred to in this example is a new application mode of computer technology such as distributed data storage, point-to-point transmission, consensus mechanism, and encryption algorithm. Blockchain, essentially a decentralized database, is a series of data blocks associated with cryptographic methods. Each data block contains a batch of network transaction information to verify its Validity of information (anti-counterfeiting) and generation of the next block. The blockchain can include the underlying platform of the blockchain, the platform product service layer, and the application service layer.
实施例二Embodiment 2
请参阅图2,图2是本申请实施例公开的一种账单数据的验证装置的结构示意图。如图2所示,该账单数据的验证装置可以包括:Please refer to FIG. 2 , which is a schematic structural diagram of an apparatus for verifying billing data disclosed in an embodiment of the present application. As shown in Figure 2, the verification device for billing data may include:
获取模块201,用于获取包含有待验证账单数据的账单文件;an obtaining module 201, configured to obtain a bill file containing bill data to be verified;
解析模块202,用于将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;A parsing module 202, configured to input the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
确定模块203,用于根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;A determination module 203, configured to determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
提取模块204,用于从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;an extraction module 204, configured to extract the data of the standard data type from the original bill data, as the bill data to be verified contained in the bill file;
所述获取模块201,还用于获取将要用于进行所述待验证账单数据的验证的参照账单数据;The obtaining module 201 is further configured to obtain reference bill data to be used for the verification of the bill data to be verified;
验证模块205,用于根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;The verification module 205 is configured to verify the bill data to be verified according to the reference bill data, and obtain a verification result corresponding to the bill data to be verified, and the verification result is used to indicate that the verification of the bill data to be verified has passed or verification failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
在一个可选的实施例中,所述提取模块204,还用于在所述验证模块205根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果之后,当所述验证结果用于表示所述待验证账单数据验证不通过时,从所述待验证账单数据中提取出未通过验证的差异账单数据;In an optional embodiment, the extraction module 204 is further configured to verify the bill data to be verified according to the reference bill data in the verification module 205 to obtain the verification corresponding to the bill data to be verified After the result, when the verification result is used to indicate that the verification of the to-be-verified bill data fails, extract the unverified differential bill data from the to-be-verified bill data;
所述获取模块201,还用于获取用于进行所述差异账单数据的验证的目标账单数据;The obtaining module 201 is further configured to obtain target billing data for verifying the differential billing data;
以及,所述装置还包括:And, the device also includes:
差异验证模块,用于根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果,所述差异验证结果用于表示所述差异账单数据的差异验证通过或者不通过。A difference verification module, configured to perform difference verification on the difference bill data according to the target bill data, and obtain a difference verification result corresponding to the difference bill data, where the difference verification result is used to represent the difference verification of the difference bill data Pass or fail.
在一个可选的实施例中,所述装置还包括:In an optional embodiment, the apparatus further includes:
发送模块,用于在所述差异验证模块根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果之后,当所述差异验证结果用于表示所述差异账单数据验证不通过时,将待人工查验账单数据发送至预先确定出的人工查验终端,所述待人工查验账单数据是指未通过差异验证的差异账单数据;The sending module is configured to, after the difference verification module performs the difference verification on the difference bill data according to the target bill data, and obtains the difference verification result corresponding to the difference bill data, when the difference verification result is used to indicate the difference verification result. When the verification of the differential bill data fails, the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the differential bill data that has not passed the differential verification;
接收模块,用于接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果,所述人工查验结果用于表示所述待人工查验账单数据有效或者无效;a receiving module, configured to receive a manual check result input by a user at the manual check terminal based on the bill data to be checked manually, where the manual check result is used to indicate that the bill data to be checked manually is valid or invalid;
平账模块,用于当所述接收模块接收到的所述人工查验结果用于表示所述待人工查验账单数据有效时,针对所述待人工查验账单数据执行所述待人工查验账单数据对应的平账操作。The account reconciliation module is configured to, when the manual inspection result received by the receiving module is used to indicate that the bill data to be manually inspected is valid, execute the corresponding process of the bill data to be manually inspected for the bill data to be manually inspected. Balance operation.
在一个可选的实施例中,所述装置还包括:In an optional embodiment, the apparatus further includes:
判断模块,用于当所述接收模块接收到的所述人工查验结果用于表示所述待人工查验账单数据无效时,判断所述参照账单数据和所述目标账单数据中是否存在与所述待人工查验账单数据相似的相似账单数据;The judgment module is configured to judge whether the reference bill data and the target bill data exist in the reference bill data and the target bill data when the manual check result received by the receiving module is used to indicate that the bill data to be checked manually is invalid. Manually check similar billing data with similar billing data;
所述发送模块,还用于当所述判断模块判断出所述参照账单数据和所述目标账单数据中存在所述相似账单数据,将所述相似账单数据发送至所述人工查验终端。The sending module is further configured to send the similar bill data to the manual checking terminal when the judgment module judges that the similar bill data exists in the reference bill data and the target bill data.
在一个可选的实施例中,所述待验证账单数据包括至少一条待验证交易记录,每条所述待验证交易记录至少包括该条待验证账单记录对应的记录标识和交易信息,所述参照账单数据包括至少一条参照交易记录,每条所述参照交易记录至少包括该条参照交易记录对应的记录标识和交易信息;In an optional embodiment, the bill data to be verified includes at least one transaction record to be verified, and each transaction record to be verified includes at least a record identifier and transaction information corresponding to the bill record to be verified. The billing data includes at least one reference transaction record, and each of the reference transaction records includes at least a record identifier and transaction information corresponding to the reference transaction record;
以及,所述验证模块205根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果的具体方式为:And, the verification module 205 verifies the bill data to be verified according to the reference bill data, and the specific manner of obtaining the verification result corresponding to the bill data to be verified is as follows:
将所有的所述待验证交易记录和所有的所述参照交易记录存储至redis的Map对象;Store all the transaction records to be verified and all the reference transaction records in the Map object of redis;
将所有的所述待验证交易记录对应的记录标识和所有的所述参照交易记录对应的记录标识存储至redis的set对象;Store the record identifiers corresponding to all the transaction records to be verified and the record identifiers corresponding to all the reference transaction records to the set object of redis;
基于redissdiff算法判断所有的所述待验证交易记录和所有的所述参照交易记录是否存在差异;Based on the redisdiff algorithm, determine whether there is a difference between all the transaction records to be verified and all the reference transaction records;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录存在差异,确定所述待验证账单数据对应的验证结果为验证不通过;When it is judged that there is a difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is a verification failure;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录不存在差异,确定所述待验证账单数据对应的验证结果为验证通过。When it is determined that there is no difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is verified as passed.
在一个可选的实施例中,所述获取模块201获取包含有待验证账单数据的账单文件的具体方式为:In an optional embodiment, the specific manner in which the acquiring module 201 acquires the bill file containing the bill data to be verified is:
从预先设置的目标ftp服务器上获取包含有待验证账单数据的账单文件,其中,所述目标ftp服务器用于存储由第三方系统定时上传的账单文件,或者,Acquire the bill file containing the bill data to be verified from the preset target ftp server, where the target ftp server is used to store the bill file regularly uploaded by the third-party system, or,
调用由第三方系统提供的账单数据下载接口,得到包含有待验证账单数据的账单文件。Call the billing data download interface provided by the third-party system to obtain the billing file containing the billing data to be verified.
对于上述账单数据的验证装置的具体描述可以参照上述账单数据的验证方法的具体描述,在此不再一一赘述。For the specific description of the apparatus for verifying the billing data, reference may be made to the specific description of the method for verifying the billing data, which will not be repeated here.
实施例三Embodiment 3
请参阅图3,图3是本申请实施例公开的一种计算机设备的结构示意图。如图3所示,该计算机设备可以包括:Please refer to FIG. 3 , which is a schematic structural diagram of a computer device disclosed in an embodiment of the present application. As shown in Figure 3, the computer equipment may include:
存储有可执行程序代码的存储器301;a memory 301 storing executable program code;
与存储器301连接的处理器302;a processor 302 connected to the memory 301;
处理器302调用存储器301中存储的可执行程序代码,执行本申请实施例一公开的账单数据的验证方法中的步骤。The processor 302 invokes the executable program code stored in the memory 301 to execute the steps in the method for verifying billing data disclosed in Embodiment 1 of the present application.
实施例四Embodiment 4
本申请实施例公开了一种计算机存储介质401,计算机存储介质401存储有计算机指令,该计算机指令被调用时,用于执行本申请实施例一公开的账单数据的验证方法中的步骤。其中,计算机存储介质401可以是非易失性,也可以是易失性。The embodiment of the present application discloses a computer storage medium 401, where the computer storage medium 401 stores computer instructions, and when the computer instructions are invoked, is used to execute the steps in the method for verifying billing data disclosed in the first embodiment of the present application. The computer storage medium 401 may be non-volatile or volatile.
以上所描述的装置实施例仅是示意性的,其中所述作为分离部件说明的模块可以是或者也可以不是物理上分开的,作为模块显示的部件可以是或者也可以不是物理模块,即可以位于一个地方,或者也可以分布到多个网络模块上。可以根据实际的需要选择其中的部分或者全部模块来实现本实施例方案的目的。本领域普通技术人员在不付出创造性的劳动的情况下,即可以理解并实施。 The device embodiments described above are only illustrative, wherein the modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical modules, that is, they may be located in One place, or it can be distributed over multiple network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution in this embodiment. Those of ordinary skill in the art can understand and implement it without creative effort. 

Claims (20)

1、一种账单数据的验证方法,其中,所述方法包括:1. A method for verifying billing data, wherein the method comprises:
获取包含有待验证账单数据的账单文件;Obtain a billing file containing billing data to be verified;
将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;inputting the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;Extracting the data of the standard data type from the original billing data as the billing data to be verified contained in the billing file;
获取将要用于进行所述待验证账单数据的验证的参照账单数据;obtaining reference billing data to be used for the verification of the billing data to be verified;
根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;Verifying the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified has passed or the verification has failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
2、根据权利要求1所述的账单数据的验证方法,其中,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果之后,所述方法还包括:2. The method for verifying billing data according to claim 1, wherein after verifying the billing data to be verified according to the reference billing data, and obtaining a verification result corresponding to the billing data to be verified, the Methods also include:
当所述验证结果用于表示所述待验证账单数据验证不通过时,从所述待验证账单数据中提取出未通过验证的差异账单数据;When the verification result is used to indicate that the verification of the to-be-verified bill data fails, extracting the unverified differential bill data from the to-be-verified bill data;
获取用于进行所述差异账单数据的验证的目标账单数据;obtaining target billing data for verification of the differential billing data;
根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果,所述差异验证结果用于表示所述差异账单数据的差异验证通过或者不通过。Difference verification is performed on the differential bill data according to the target bill data to obtain a differential verification result corresponding to the differential bill data, where the differential verification result is used to indicate whether the differential bill data passes or fails the differential verification.
3、根据权利要求2所述的账单数据的验证方法,其中,所述根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果之后,所述方法还包括:3. The method for verifying billing data according to claim 2, wherein after performing differential verification on the differential billing data according to the target billing data, and obtaining a differential verification result corresponding to the differential billing data, the Methods also include:
当所述差异验证结果用于表示所述差异账单数据验证不通过时,将待人工查验账单数据发送至预先确定出的人工查验终端,所述待人工查验账单数据是指未通过差异验证的差异账单数据;When the difference verification result is used to indicate that the verification of the difference bill data fails, the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the difference that fails the difference verification. billing data;
接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果,所述人工查验结果用于表示所述待人工查验账单数据有效或者无效;Receive a manual check result input by the user at the manual check terminal based on the bill data to be manually checked, where the manual check result is used to indicate that the bill data to be checked manually is valid or invalid;
当接收到的所述人工查验结果用于表示所述待人工查验账单数据有效时,针对所述待人工查验账单数据执行所述待人工查验账单数据对应的平账操作。When the received manual inspection result is used to indicate that the bill data to be manually inspected is valid, a reconciliation operation corresponding to the bill data to be manually inspected is performed for the bill data to be manually inspected.
4、根据权利要求3所述的账单数据的验证方法,其中,所述接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果之后,所述方法还包括:4. The method for verifying billing data according to claim 3, wherein after receiving the manual checking result input by the user at the manual checking terminal based on the billing data to be checked manually, the method further comprises:
当接收到的所述人工查验结果用于表示所述待人工查验账单数据无效时,判断所述参照账单数据和所述目标账单数据中是否存在与所述待人工查验账单数据相似的相似账单数据;When the received manual check result is used to indicate that the bill data to be checked manually is invalid, determine whether there is similar bill data similar to the bill data to be checked manually in the reference bill data and the target bill data ;
当判断出所述参照账单数据和所述目标账单数据中存在所述相似账单数据,将所述相似账单数据发送至所述人工查验终端。When it is determined that the similar bill data exists in the reference bill data and the target bill data, the similar bill data is sent to the manual checking terminal.
5、根据权利要求1-4任一项所述的账单数据的验证方法,其中,所述待验证账单数据包括至少一条待验证交易记录,每条所述待验证交易记录至少包括该条待验证账单记录对应的记录标识和交易信息,所述参照账单数据包括至少一条参照交易记录,每条所述参照交易记录至少包括该条参照交易记录对应的记录标识和交易信息;5. The method for verifying billing data according to any one of claims 1-4, wherein the billing data to be verified includes at least one transaction record to be verified, and each transaction record to be verified includes at least the transaction record to be verified. The record identifier and transaction information corresponding to the billing record, the reference billing data includes at least one reference transaction record, and each of the reference transaction records includes at least the record identifier and transaction information corresponding to the reference transaction record;
以及,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,包括:And, performing the verification on the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, including:
将所有的所述待验证交易记录和所有的所述参照交易记录存储至redis的Map对象;Store all the transaction records to be verified and all the reference transaction records in the Map object of redis;
将所有的所述待验证交易记录对应的记录标识和所有的所述参照交易记录对应的记录标识存储至redis的set对象;Store the record identifiers corresponding to all the transaction records to be verified and the record identifiers corresponding to all the reference transaction records to the set object of redis;
基于redissdiff算法判断所有的所述待验证交易记录和所有的所述参照交易记录是否存在差异;Based on the redisdiff algorithm, determine whether there is a difference between all the transaction records to be verified and all the reference transaction records;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录存在差异,确定所述待验证账单数据对应的验证结果为验证不通过;When it is judged that there is a difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is a verification failure;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录不存在差异,确定所述待验证账单数据对应的验证结果为验证通过。When it is determined that there is no difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is verified as passed.
6、根据权利要求1-4任一项所述的账单数据的验证方法,其中,所述获取包含有待验证账单数据的账单文件,包括:6. The method for verifying billing data according to any one of claims 1-4, wherein the acquiring the billing file containing the billing data to be verified comprises:
从预先设置的目标ftp服务器上获取包含有待验证账单数据的账单文件,其中,所述目标ftp服务器用于存储由第三方系统定时上传的账单文件,或者,Acquire the bill file containing the bill data to be verified from the preset target ftp server, where the target ftp server is used to store the bill file regularly uploaded by the third-party system, or,
调用由第三方系统提供的账单数据下载接口,得到包含有待验证账单数据的账单文件。Call the billing data download interface provided by the third-party system to obtain the billing file containing the billing data to be verified.
7、一种账单数据的验证装置,其中,所述装置包括:7. A device for verifying billing data, wherein the device comprises:
获取模块,用于获取包含有待验证账单数据的账单文件;The acquisition module is used to acquire the bill file containing the bill data to be verified;
解析模块,用于将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;a parsing module, configured to input the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
确定模块,用于根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;a determining module, configured to determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
提取模块,用于从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;an extraction module, configured to extract the data of the standard data type from the original bill data, as the bill data to be verified contained in the bill file;
所述获取模块,还用于获取将要用于进行所述待验证账单数据的验证的参照账单数据;The obtaining module is further configured to obtain reference bill data to be used for the verification of the bill data to be verified;
验证模块,用于根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;A verification module, configured to verify the bill data to be verified according to the reference bill data, and obtain a verification result corresponding to the bill data to be verified, and the verification result is used to indicate that the verification of the bill data to be verified is passed or verified Fail;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
8、根据权利要求7所述的账单数据的验证装置,其中,所述提取模块,还用于在所述验证模块根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果之后,当所述验证结果用于表示所述待验证账单数据验证不通过时,从所述待验证账单数据中提取出未通过验证的差异账单数据;8. The device for verifying billing data according to claim 7, wherein the extracting module is further configured to verify the billing data to be verified according to the reference billing data in the verification module to obtain the billing data to be verified. After verifying the verification result corresponding to the bill data, when the verification result is used to indicate that the verification of the to-be-verified bill data fails, extract the differential bill data that fails the verification from the to-be-verified bill data;
所述获取模块,还用于获取用于进行所述差异账单数据的验证的目标账单数据;The obtaining module is further configured to obtain target billing data for verifying the differential billing data;
以及,所述装置还包括:And, the device also includes:
差异验证模块,用于根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果,所述差异验证结果用于表示所述差异账单数据的差异验证通过或者不通过。A difference verification module, configured to perform difference verification on the difference bill data according to the target bill data, and obtain a difference verification result corresponding to the difference bill data, where the difference verification result is used to represent the difference verification of the difference bill data Pass or fail.
9、一种计算机设备,其中,所述计算机设备包括:9. A computer device, wherein the computer device comprises:
存储有可执行程序代码的存储器;a memory in which executable program code is stored;
与所述存储器连接的处理器;a processor connected to the memory;
所述处理器调用所述存储器中存储的所述可执行程序代码时,执行如下方法:When the processor calls the executable program code stored in the memory, the following method is performed:
获取包含有待验证账单数据的账单文件;Obtain a billing file containing billing data to be verified;
将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;inputting the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;Extracting the data of the standard data type from the original billing data as the billing data to be verified contained in the billing file;
获取将要用于进行所述待验证账单数据的验证的参照账单数据;obtaining reference billing data to be used for the verification of the billing data to be verified;
根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;Verifying the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified has passed or the verification has failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
10、根据权利要求9所述的计算机设备,其中,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果之后,所述方法还包括:10. The computer device according to claim 9, wherein after the verification of the to-be-verified bill data according to the reference bill data to obtain a verification result corresponding to the to-be-verified bill data, the method further comprises: :
当所述验证结果用于表示所述待验证账单数据验证不通过时,从所述待验证账单数据中提取出未通过验证的差异账单数据;When the verification result is used to indicate that the verification of the to-be-verified bill data fails, extracting the unverified differential bill data from the to-be-verified bill data;
获取用于进行所述差异账单数据的验证的目标账单数据;obtaining target billing data for verification of the differential billing data;
根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果,所述差异验证结果用于表示所述差异账单数据的差异验证通过或者不通过。Difference verification is performed on the differential bill data according to the target bill data to obtain a differential verification result corresponding to the differential bill data, where the differential verification result is used to indicate whether the differential bill data passes or fails the differential verification.
11、根据权利要求10所述的计算机设备,其中,所述根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果之后,所述方法还包括:11. The computer device according to claim 10, wherein after performing the difference verification on the difference bill data according to the target bill data, and obtaining a difference verification result corresponding to the difference bill data, the method further comprises: :
当所述差异验证结果用于表示所述差异账单数据验证不通过时,将待人工查验账单数据发送至预先确定出的人工查验终端,所述待人工查验账单数据是指未通过差异验证的差异账单数据;When the difference verification result is used to indicate that the verification of the difference bill data fails, the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the difference that fails the difference verification. billing data;
接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果,所述人工查验结果用于表示所述待人工查验账单数据有效或者无效;Receive a manual check result input by the user at the manual check terminal based on the bill data to be manually checked, where the manual check result is used to indicate that the bill data to be checked manually is valid or invalid;
当接收到的所述人工查验结果用于表示所述待人工查验账单数据有效时,针对所述待人工查验账单数据执行所述待人工查验账单数据对应的平账操作。When the received manual inspection result is used to indicate that the bill data to be manually inspected is valid, a reconciliation operation corresponding to the bill data to be manually inspected is performed for the bill data to be manually inspected.
12、根据权利要求11所述的计算机设备,其中,所述接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果之后,所述方法还包括:12. The computer device according to claim 11, wherein after receiving the manual check result input by the user at the manual check terminal based on the bill data to be checked manually, the method further comprises:
当接收到的所述人工查验结果用于表示所述待人工查验账单数据无效时,判断所述参照账单数据和所述目标账单数据中是否存在与所述待人工查验账单数据相似的相似账单数据;When the received manual check result is used to indicate that the bill data to be checked manually is invalid, determine whether there is similar bill data similar to the bill data to be checked manually in the reference bill data and the target bill data ;
当判断出所述参照账单数据和所述目标账单数据中存在所述相似账单数据,将所述相似账单数据发送至所述人工查验终端。When it is determined that the similar bill data exists in the reference bill data and the target bill data, the similar bill data is sent to the manual checking terminal.
13、根据权利要求9-12任一项所述的计算机设备,其中,所述待验证账单数据包括至少一条待验证交易记录,每条所述待验证交易记录至少包括该条待验证账单记录对应的记录标识和交易信息,所述参照账单数据包括至少一条参照交易记录,每条所述参照交易记录至少包括该条参照交易记录对应的记录标识和交易信息;13. The computer device according to any one of claims 9-12, wherein the bill data to be verified includes at least one transaction record to be verified, and each transaction record to be verified at least includes the corresponding bill record to be verified. The record identifier and transaction information of the reference bill data include at least one reference transaction record, and each of the reference transaction records includes at least the record identifier and transaction information corresponding to the reference transaction record;
以及,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,包括:And, performing the verification on the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, including:
将所有的所述待验证交易记录和所有的所述参照交易记录存储至redis的Map对象;Store all the transaction records to be verified and all the reference transaction records in the Map object of redis;
将所有的所述待验证交易记录对应的记录标识和所有的所述参照交易记录对应的记录标识存储至redis的set对象;Store the record identifiers corresponding to all the transaction records to be verified and the record identifiers corresponding to all the reference transaction records to the set object of redis;
基于redissdiff算法判断所有的所述待验证交易记录和所有的所述参照交易记录是否存在差异;Based on the redisdiff algorithm, determine whether there is a difference between all the transaction records to be verified and all the reference transaction records;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录存在差异,确定所述待验证账单数据对应的验证结果为验证不通过;When it is judged that there is a difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is a verification failure;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录不存在差异,确定所述待验证账单数据对应的验证结果为验证通过。When it is determined that there is no difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is verified as passed.
14、根据权利要求9-12任一项所述的计算机设备,其中,所述获取包含有待验证账单数据的账单文件,包括:14. The computer device according to any one of claims 9-12, wherein said obtaining a billing file containing billing data to be verified comprises:
从预先设置的目标ftp服务器上获取包含有待验证账单数据的账单文件,其中,所述目标ftp服务器用于存储由第三方系统定时上传的账单文件,或者,Acquire the bill file containing the bill data to be verified from the preset target ftp server, where the target ftp server is used to store the bill file regularly uploaded by the third-party system, or,
调用由第三方系统提供的账单数据下载接口,得到包含有待验证账单数据的账单文件。Call the billing data download interface provided by the third-party system to obtain the billing file containing the billing data to be verified.
15、一种计算机存储介质,所述计算机存储介质存储有计算机程序,其中,所述计算机程序被处理器执行时,实现如下方法:15. A computer storage medium storing a computer program, wherein, when the computer program is executed by a processor, the following method is implemented:
获取包含有待验证账单数据的账单文件;Obtain a billing file containing billing data to be verified;
将所述账单文件输入至所述账单文件的文件格式对应的文件解析器进行解析,得到所述账单文件对应的原始账单数据;inputting the billing file into a file parser corresponding to the file format of the billing file for parsing to obtain original billing data corresponding to the billing file;
根据所述账单文件对应的上传渠道标识确定所述账单文件对应的标准数据类型;Determine the standard data type corresponding to the billing file according to the upload channel identifier corresponding to the billing file;
从所述原始账单数据中提取所述标准数据类型的数据,以作为所述账单文件所包含的待验证账单数据;Extracting the data of the standard data type from the original billing data as the billing data to be verified contained in the billing file;
获取将要用于进行所述待验证账单数据的验证的参照账单数据;obtaining reference billing data to be used for the verification of the billing data to be verified;
根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,所述验证结果用于表示所述待验证账单数据验证通过或者验证不通过;Verifying the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, where the verification result is used to indicate that the verification of the bill data to be verified has passed or the verification has failed;
其中,所述账单文件是多种文件格式的文件,且不同文件格式的账单文件对应不同的文件解析器。Wherein, the bill file is a file in multiple file formats, and bill files in different file formats correspond to different file parsers.
16、根据权利要求15所述的计算机存储介质,其中,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果之后,所述方法还包括:16. The computer storage medium according to claim 15, wherein after the verification of the bill data to be verified according to the reference bill data and obtaining the verification result corresponding to the bill data to be verified, the method further include:
当所述验证结果用于表示所述待验证账单数据验证不通过时,从所述待验证账单数据中提取出未通过验证的差异账单数据;When the verification result is used to indicate that the verification of the to-be-verified bill data fails, extracting the unverified differential bill data from the to-be-verified bill data;
获取用于进行所述差异账单数据的验证的目标账单数据;obtaining target billing data for verification of the differential billing data;
根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果,所述差异验证结果用于表示所述差异账单数据的差异验证通过或者不通过。Difference verification is performed on the differential bill data according to the target bill data to obtain a differential verification result corresponding to the differential bill data, where the differential verification result is used to indicate whether the differential bill data passes or fails the differential verification.
17、根据权利要求16所述的计算机存储介质,其中,所述根据所述目标账单数据对所述差异账单数据进行差异验证,得到所述差异账单数据对应的差异验证结果之后,所述方法还包括:17. The computer storage medium according to claim 16, wherein after the difference verification is performed on the differential billing data according to the target billing data, and a differential verification result corresponding to the differential billing data is obtained, the method further comprises: include:
当所述差异验证结果用于表示所述差异账单数据验证不通过时,将待人工查验账单数据发送至预先确定出的人工查验终端,所述待人工查验账单数据是指未通过差异验证的差异账单数据;When the difference verification result is used to indicate that the verification of the difference bill data fails, the bill data to be manually checked is sent to a predetermined manual check terminal, and the bill data to be checked manually refers to the difference that fails the difference verification. billing data;
接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果,所述人工查验结果用于表示所述待人工查验账单数据有效或者无效;Receive a manual check result input by the user at the manual check terminal based on the bill data to be manually checked, where the manual check result is used to indicate that the bill data to be checked manually is valid or invalid;
当接收到的所述人工查验结果用于表示所述待人工查验账单数据有效时,针对所述待人工查验账单数据执行所述待人工查验账单数据对应的平账操作。When the received manual inspection result is used to indicate that the bill data to be manually inspected is valid, a reconciliation operation corresponding to the bill data to be manually inspected is performed for the bill data to be manually inspected.
18、根据权利要求17所述的计算机存储介质,其中,所述接收用户基于所述待人工查验账单数据在所述人工查验终端输入的人工查验结果之后,所述方法还包括:18. The computer storage medium according to claim 17, wherein after receiving the manual checking result input by the user at the manual checking terminal based on the bill data to be checked manually, the method further comprises:
当接收到的所述人工查验结果用于表示所述待人工查验账单数据无效时,判断所述参照账单数据和所述目标账单数据中是否存在与所述待人工查验账单数据相似的相似账单数据;When the received manual check result is used to indicate that the bill data to be checked manually is invalid, determine whether there is similar bill data similar to the bill data to be checked manually in the reference bill data and the target bill data ;
当判断出所述参照账单数据和所述目标账单数据中存在所述相似账单数据,将所述相似账单数据发送至所述人工查验终端。When it is determined that the similar bill data exists in the reference bill data and the target bill data, the similar bill data is sent to the manual checking terminal.
19、根据权利要求15-18任一项所述的计算机存储介质,其中,所述待验证账单数据包括至少一条待验证交易记录,每条所述待验证交易记录至少包括该条待验证账单记录对应的记录标识和交易信息,所述参照账单数据包括至少一条参照交易记录,每条所述参照交易记录至少包括该条参照交易记录对应的记录标识和交易信息;19. The computer storage medium according to any one of claims 15-18, wherein the bill data to be verified comprises at least one transaction record to be verified, and each transaction record to be verified includes at least the bill record to be verified Corresponding record identifiers and transaction information, the reference bill data includes at least one reference transaction record, and each of the reference transaction records includes at least the record identifier and transaction information corresponding to the reference transaction record;
以及,所述根据所述参照账单数据对所述待验证账单数据进行验证,得到所述待验证账单数据对应的验证结果,包括:And, performing the verification on the bill data to be verified according to the reference bill data to obtain a verification result corresponding to the bill data to be verified, including:
将所有的所述待验证交易记录和所有的所述参照交易记录存储至redis的Map对象;Store all the transaction records to be verified and all the reference transaction records in the Map object of redis;
将所有的所述待验证交易记录对应的记录标识和所有的所述参照交易记录对应的记录标识存储至redis的set对象;Store the record identifiers corresponding to all the transaction records to be verified and the record identifiers corresponding to all the reference transaction records to the set object of redis;
基于redissdiff算法判断所有的所述待验证交易记录和所有的所述参照交易记录是否存在差异;Based on the redisdiff algorithm, determine whether there is a difference between all the transaction records to be verified and all the reference transaction records;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录存在差异,确定所述待验证账单数据对应的验证结果为验证不通过;When it is judged that there is a difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is a verification failure;
当判断出所有的所述待验证交易记录和所有的所述参照交易记录不存在差异,确定所述待验证账单数据对应的验证结果为验证通过。When it is determined that there is no difference between all the transaction records to be verified and all the reference transaction records, it is determined that the verification result corresponding to the bill data to be verified is verified as passed.
20、根据权利要求15-18任一项所述的计算机存储介质,其中,所述获取包含有待验证账单数据的账单文件,包括:20. The computer storage medium according to any one of claims 15-18, wherein the obtaining a billing file containing billing data to be verified comprises:
从预先设置的目标ftp服务器上获取包含有待验证账单数据的账单文件,其中,所述目标ftp服务器用于存储由第三方系统定时上传的账单文件,或者,Acquire the bill file containing the bill data to be verified from the preset target ftp server, where the target ftp server is used to store the bill file regularly uploaded by the third-party system, or,
调用由第三方系统提供的账单数据下载接口,得到包含有待验证账单数据的账单文件。Call the billing data download interface provided by the third-party system to obtain the billing file containing the billing data to be verified.
PCT/CN2021/091690 2020-12-29 2021-04-30 Billing data verification method and apparatus, computer device and storage medium WO2022142040A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202011590424.XA CN112669008A (en) 2020-12-29 2020-12-29 Bill data verification method and device, computer equipment and storage medium
CN202011590424.X 2020-12-29

Publications (1)

Publication Number Publication Date
WO2022142040A1 true WO2022142040A1 (en) 2022-07-07

Family

ID=75411770

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2021/091690 WO2022142040A1 (en) 2020-12-29 2021-04-30 Billing data verification method and apparatus, computer device and storage medium

Country Status (2)

Country Link
CN (1) CN112669008A (en)
WO (1) WO2022142040A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115936886A (en) * 2023-03-15 2023-04-07 深圳华锐分布式技术股份有限公司 Failure detection method, device, equipment and medium for heterogeneous security trading system

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112669008A (en) * 2020-12-29 2021-04-16 平安普惠企业管理有限公司 Bill data verification method and device, computer equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5822716A (en) * 1996-07-22 1998-10-13 Atlantic Richfield Company System and method for generating bills of lading for liquid commodity shipments
CN110188136A (en) * 2019-06-10 2019-08-30 四川长虹电器股份有限公司 A kind of modularization reconciliation system and its account checking method based on bank-corporate express
CN110659965A (en) * 2019-09-24 2020-01-07 北京腾赋网络科技有限公司 Control method for automatically reflecting bill difference of takeout order
CN112669008A (en) * 2020-12-29 2021-04-16 平安普惠企业管理有限公司 Bill data verification method and device, computer equipment and storage medium

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107888672A (en) * 2017-11-02 2018-04-06 深圳市牛鼎丰科技有限公司 Billing data processing method, device, storage medium and computer equipment
CN109325028A (en) * 2018-08-22 2019-02-12 平安普惠企业管理有限公司 A kind of reconciliation file verification method and terminal device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5822716A (en) * 1996-07-22 1998-10-13 Atlantic Richfield Company System and method for generating bills of lading for liquid commodity shipments
CN110188136A (en) * 2019-06-10 2019-08-30 四川长虹电器股份有限公司 A kind of modularization reconciliation system and its account checking method based on bank-corporate express
CN110659965A (en) * 2019-09-24 2020-01-07 北京腾赋网络科技有限公司 Control method for automatically reflecting bill difference of takeout order
CN112669008A (en) * 2020-12-29 2021-04-16 平安普惠企业管理有限公司 Bill data verification method and device, computer equipment and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115936886A (en) * 2023-03-15 2023-04-07 深圳华锐分布式技术股份有限公司 Failure detection method, device, equipment and medium for heterogeneous security trading system
CN115936886B (en) * 2023-03-15 2023-06-27 深圳华锐分布式技术股份有限公司 Failure detection method, device, equipment and medium for heterogeneous securities trading system

Also Published As

Publication number Publication date
CN112669008A (en) 2021-04-16

Similar Documents

Publication Publication Date Title
WO2022142040A1 (en) Billing data verification method and apparatus, computer device and storage medium
CN108536521B (en) Simulation platform-based offline environment checking method and device
US20020138570A1 (en) System for and method of automatically migrating data among multiple legacy applications and accessible storage formats
CN114500690B (en) Interface data processing method and device, electronic equipment and storage medium
CN110222028A (en) A kind of data managing method, device, equipment and storage medium
CN110598007B (en) Bill file processing method, device, medium and electronic equipment
EP3436949A1 (en) Data recovery with authenticity
CN117036115A (en) Contract data verification method, device and server
CN113297357A (en) Asynchronous processing method and device for business process data
CN113868219A (en) Method and device for migrating account set data, electronic equipment and computer storage medium
CN109582334B (en) Upgrading method and device for programmable logic device
CN115223292B (en) Processing method and device of dispensing machine, storage medium and electronic equipment
WO2023116031A1 (en) Message checking method and apparatus, and terminal device and computer-readable storage medium
CN112308523A (en) Management method, device, equipment and storage medium of certificate information
US20190355053A1 (en) Method, a device and a system of a distributed financial flows auditing
CN113836145B (en) Method, device, electronic equipment and computer readable storage medium for requesting data
CN108572948B (en) Doorplate information processing method and device
CN112241328B (en) Data processing method, device and system
CN112070470B (en) Annual report reporting method and device, electronic equipment and storage medium
CN113158988A (en) Financial statement processing method and device and computer readable storage medium
CN117036073B (en) Invoice auditing and automatic reimbursement system based on Internet
CN111275550A (en) Information processing method and device, readable storage medium and electronic equipment
TWI831114B (en) Integrity verifying method, system and computer device of separated cross-platform trade and accounting, computer-readable medium
CN113220594B (en) Automatic test method, device, equipment and storage medium
US20200314112A1 (en) Method, apparatus and computer program for verifying the integrity of electronic messages

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 21912802

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 30/10/2023)