Automatic reconciliation system and method based on big data

Abstract

The invention provides an automatic reconciliation system and method based on big data, and the system comprises: a real-time synchronization unit which is used for receiving a database change message, employing different processing modes according to a table name, filtering useless fields, and storing the useless fields in an es search engine; the reconciliation processing unit that is used for pulling the relevant data of each service from the es search engine, performing reconciliation and storing a reconciliation result to the es search engine; the order supplementing processing unit thatis used for pulling the serial number and the failure information of the account checking failure order from the es search engine, finding a corresponding business system according to the failure information and initiating order supplementing operation; and the reconciliation bill processing unit that is used for pulling reconciliation information from the es search engine and generating a merchant reconciliation bill according to business and merchant classification.

Description

technical field [0001] The present invention relates to the field of transaction and financial data processing, in particular to an automatic account reconciliation system and method based on big data. Background technique [0002] After the order payment of the current online transaction system is successful, the service system notifications such as cost billing and merchant billing have the following problems: [0003] First, missing notifications or notification failures occur frequently. Second, the missing notification situation cannot be known in advance. Generally, settlement personnel will prompt for processing after completing channel reconciliation. On the one hand, this problem increases the workflow and increases the cost of manual processing; on the other hand, it directly affects the timeliness and accuracy of channel reconciliation, and reduces work efficiency. Third, when the number of reconciliation slips is large enough, the reconciliation information is...

AI Technical Summary

Problems solved by technology

On the one hand, this problem increases the workflow and increases the cost of manual processing; on the other hand, it directly affects the timeliness and accuracy of channel reconciliation, and reduces work efficiency

Third, when the number of reconciliation slips is large enough, the reconciliation information is often slow due to massive data, and the efficiency is extremely low

Images