CN112634006A - Account checking processing method and device, electronic equipment and storage medium - Google Patents
Account checking processing method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112634006A CN112634006A CN202011626518.8A CN202011626518A CN112634006A CN 112634006 A CN112634006 A CN 112634006A CN 202011626518 A CN202011626518 A CN 202011626518A CN 112634006 A CN112634006 A CN 112634006A
- Authority
- CN
- China
- Prior art keywords
- bill
- files
- transaction
- reconciliation
- file
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 22
- 238000012545 processing Methods 0.000 claims description 32
- 238000000034 method Methods 0.000 claims description 27
- 238000002156 mixing Methods 0.000 claims description 21
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000002457 bidirectional effect Effects 0.000 abstract description 4
- 230000007246 mechanism Effects 0.000 description 19
- 230000008569 process Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000002688 persistence Effects 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000011022 operating instruction Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000005477 standard model Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/389—Keeping log of transactions for guaranteeing non-repudiation of a transaction
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a reconciliation processing method, a device, an electronic device and a storage medium, wherein for two objects for transaction, one of the two objects is taken as a reference object, the other object is taken as a comparison object, for example, the first object is taken as the reference object for the first time, and the second object is taken as the reference object for the second time, so that the bill files of the two objects are subjected to one-by-one reconciliation in a bidirectional reconciliation mode, and the transaction data in the bill file is matched to determine the reconciliation results of the two objects. The invention provides a high-availability and high-performance universal account checking mode, and the accuracy of account checking is improved.
Description
Technical Field
The invention relates to the technical field of internet, in particular to a reconciliation processing method and device for financial industry business reconciliation, electronic equipment and a storage medium.
Background
With the rapid development of the internet financial industry, more and more business services are provided, and business data is multiplied. In the payment system, the account checking provides monitoring service for key business indexes of the payment service, provides a strong shield for settlement and reduces the labor cost.
Therefore, how to improve the reconciliation accuracy becomes an urgent problem to be solved at the present stage.
Disclosure of Invention
In view of the above, to solve the above problems, the present invention provides a reconciliation processing method, apparatus, electronic device and storage medium, and the technical solution is as follows:
a reconciliation processing method, the method comprising:
respectively acquiring bill files of a first object and a second object for transaction, wherein the bill files record transaction data of related objects;
sequentially taking the first object and the second object as reference objects, and taking the other object except the reference object in the first object and the second object as a comparison object;
according to the bill files of the reference object, performing batch-by-batch blending on the bill files of the comparison objects to determine a plurality of groups of associated bill files;
and matching transaction data of each group of bill files to obtain account checking results of the first object and the second object.
Preferably, after the obtaining of the billing files of the first object and the second object for performing the transaction respectively, the method further comprises:
and respectively carrying out data conversion on the bill files of the first object and the second object so as to obtain respective standard transaction data.
Preferably, the method further comprises:
and processing the reconciliation result.
Preferably, the obtaining of the billing files of the first object and the second object for performing the transaction respectively includes:
determining a plurality of batches according to the transaction time of the first object and the second object;
and sequentially processing the batches, and loading the transaction files of the first object and the second object in the transaction time corresponding to each batch.
Preferably, the performing of the transaction-by-transaction reconciliation on the billing file of the comparison object according to the billing file of the reference object includes:
creating a plurality of processing threads, wherein one processing thread corresponds to one loaded batch;
and calling each processing thread to execute the bill file of the reference object on the loaded transaction files of the corresponding batch through the processing thread, and performing batch-by-batch blending on the bill files of the comparison objects.
Preferably, the tie-back type of the first object and the second object is internal tie-back;
the obtaining of the billing files of the first object and the second object for the transaction respectively comprises:
and responding to the transaction events of the first object and the second object, and acquiring the bill files of the first object and the second object in real time.
Preferably, the tie-out type of the first object and the second object is external tie-out;
the obtaining of the billing files of the first object and the second object for the transaction respectively comprises:
acquiring the bill files of the first object and the second object on the previous day;
in a case where the first object is a payment consumer and the second object is a payment provider, the reconciling the reconciliation files of the comparison objects one by one according to the reconciliation file of the reference object to determine associated sets of reconciliation files, comprising:
if the reference object is the first object and the comparison object is the second object, performing first-time batch-by-batch reconciliation on the bill file of the second object according to the bill file of the first object to determine the associated multiple groups of bill files;
storing a first bill file of which the associated bill file does not exist in the bill files of the first object and the second object into an error temporary storage pool;
if the reference object is the second object and the comparison object is the first object, performing second-time batch-by-batch reconciliation on the bill file of the first object according to the bill file of the second object to determine that the second bill file of the associated bill file does not exist in the bill file of the second object and the bill file of the first object;
and calling the first bill file stored in the error temporary storage pool on the previous two days, and matching the second bill file with the called first bill file to update the plurality of groups of bill files.
A reconciliation processing apparatus, the apparatus comprising:
the file acquisition module is used for respectively acquiring bill files of a first object and a second object for transaction, and the bill files are recorded with transaction data of related objects;
a blending module, configured to sequentially use the first object and the second object as reference objects, and use another object of the first object and the second object except the reference object as a comparison object; according to the bill files of the reference object, performing batch-by-batch blending on the bill files of the comparison objects to determine a plurality of groups of associated bill files;
and the matching module is used for matching the transaction data of each group of bill files to obtain the reconciliation results of the first object and the second object.
An electronic device, comprising: at least one memory and at least one processor; the memory stores a program, and the processor calls the program stored in the memory, wherein the program is used for realizing any one of the reconciliation processing methods.
A storage medium having stored therein computer-executable instructions for performing any one of the reconciliation processing methods.
The invention provides a reconciliation processing method, a device, an electronic device and a storage medium, wherein for two objects for transaction, one of the two objects is taken as a reference object, the other object is taken as a comparison object, for example, the first object is taken as the reference object for the first time, and the second object is taken as the reference object for the second time, so that the bill files of the two objects are subjected to one-by-one reconciliation in a bidirectional reconciliation mode, and the transaction data in the bill file is matched to determine the reconciliation results of the two objects. The invention provides a high-availability and high-performance universal account checking mode, and the accuracy of account checking is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a system architecture diagram of a transaction system provided by an embodiment of the present invention;
fig. 2 is a flowchart of a method of a reconciliation processing method according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an account checking processing apparatus according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below.
For the convenience of understanding of the present invention, the technical background of the present invention will be first explained as follows:
checking accounts: with the development of the financial and internet industries, the definition of the technology also changes in several stages, as follows:
stage 1: the reconciliation is originally from accounting, and is the work of checking and checking the relevant data in the account book in order to ensure the record of the account book to be correct and reliable.
stage 2: with the development of the internet finance or e-commerce industry, the application range of the account checking is expanded, and in this period, the account checking means that a payment user and a payment provider mutually confirm the correctness of transactions and funds in a fixed period, so that the consistency and correctness of the transactions and the funds of the two parties are ensured.
Referring to the system structure diagram of the transaction system shown in fig. 1, the transaction system may include a payment service agent and a third party payment authority such as a bank, a payment treasure, and a WeChat payment, and the payment service agent may include service services such as credit, change, red envelope, and a payment gateway such as a charge/withdrawal, a payment/deduction, a consumption/refund, and the like. The reconciliation type between the business service and the payment gateway is called internal reconciliation, which is real-time, and the reconciliation type between the payment gateway and the third-party payment mechanism is external reconciliation (or mechanism reconciliation), which is T +1 day (next day).
Of course, in the transaction between the service and the payment gateway, the service is a payment user and the payment gateway is a payment provider; in the transaction between the payment gateway and the third party payment mechanism, the payment gateway is the payment user, and the third party payment mechanism is the payment provider.
In the invention, the transaction between the first object and the second object can refer to the transaction between the business service and the payment gateway, and can also refer to the transaction between the payment gateway and a third-party payment mechanism. The invention is illustrated below:
referring to a method flowchart of the reconciliation processing method shown in fig. 1, the reconciliation processing method provided by the embodiment of the invention includes the following steps:
and S10, acquiring bill files of the first object and the second object for transaction respectively, wherein the bill files record the transaction data of the related objects.
In the embodiment of the invention, the reconciliation downloading mode of the third-party payment channel mainly comprises the following steps: the download methods include FTP, SFTP, HTTP, etc., and the download methods include DB, RPC, etc., mainly for the internal service system.
That is, if the two objects of the reconciliation are the service gateway and the payment gateway, the bill files of the two objects can be obtained by adopting download methods such as DB and RPC, and if the two objects of the reconciliation are the payment gateway and the third party payment mechanism, the bill files of the two objects can be obtained by adopting download methods such as FTP, SFTP and HTTP.
The bill file contains transaction data of related objects, taking the transaction between the payment gateway and the third-party payment mechanism as an example:
the bill file of the payment gateway contains data related to the transaction initiated by the payment gateway, including the transaction serial number, the user name, the payment account, the transaction initiation time, the amount, the receiving account, the transaction status, and the like, for example, "transaction list 0001: zhang Sanjian bank 888888 initiated a top-up of 100 blocks of operation to the video App Zhang Sanyu account at 2020-10-0919: 53:43, and the transaction was successful ".
The bill file of the third-party payment mechanism contains relevant data of the third-party payment mechanism responding to the transaction, including a transaction serial number, a user name, a payment account, transaction response time, an amount, a receiving account, a transaction state and the like, for example, a transaction list 0001: zhang Sanjian bank 888888 receives a 100-block recharging operation instruction for the video App three virtual account at 2020-10-0919:57:52, and the transaction is successful.
It should be noted that, for internal reconciliation, once the transaction of the first object and the second object is completed, the billing files of the first object and the second object can be obtained without waiting for the next day. For external reconciliation, the next day of acquisition is required to be waited.
In some other embodiments, to ensure that the reconciliation data specification is valid, the embodiment of the present invention further includes the following steps:
and respectively carrying out data conversion on the bill files of the first object and the second object so as to obtain respective standard transaction data.
In the embodiment of the invention, the data conversion is a process of standardizing transaction data. The obtained transaction data in the bill files of the first object and the second object can be converted into a reconciliation standard model through modeling. For example, there may be a portion of the bill file in "rmb" unit and a portion of the bill file in "U.S. dollar" unit corresponding to the "amount" of the transaction data, which requires that the "amount" be converted to the same unit by amount conversion.
S20, the first object and the second object are sequentially used as reference objects, and the other object of the first object and the second object except the reference object is used as a comparison object.
In the embodiment of the invention, the transaction between the payment gateway and the third-party payment mechanism is taken as an example. And when the payment gateway is checked for the first time, the payment gateway is taken as a reference object, and the third-party payment mechanism is correspondingly taken as a comparison object. And in the second time of reconciliation, the third-party payment mechanism is taken as a reference object, and the payment gateway is correspondingly taken as a comparison object. The following describes a scheme of reconciliation of the reference object and the comparison object each time.
And S30, performing per-stroke reconciliation on the bill files of the comparison objects according to the bill files of the reference objects to determine the associated multiple groups of bill files.
In the embodiment of the invention, for each bill file of the reference object, each bill file of the comparison object can be sequentially subjected to stroke-by-stroke blending through the serial number, that is, whether the related bill files of the comparison object have the same serial number is judged. One billing file of the reference object and one billing file of the comparison object having the same serial number are taken as a set of associated billing files.
Of course, for a certain bill file of the reference object, if there is no bill file of the same serial number for the comparison object, it may be determined that the comparison object misses the bill, that is, the comparison object does not store the bill file.
And S40, matching the transaction data of each group of bill files to obtain the reconciliation result of the first object and the second object.
In the embodiment of the invention, for a group of bill files, the specified transaction data can be compared, so as to generate the reconciliation result, and if the transaction data are completely consistent, the reconciliation is judged to be successful. Of course, the specific transaction data and comparison rules compared may be self-configurable.
Several error types of the reconciliation result are explained below:
for example, if the status of a certain billing file of the reference object is "transaction successful" and the status of the billing file of the associated comparison object is "transaction failed", it can be determined that the reference object is long, the comparison object is short, and the statuses are not consistent; for another example, if the status of a certain billing file of the reference object is "transaction failed" and the status of the billing file of the associated comparison object is "transaction successful", it can be determined that the reference object is short, the comparison object is long, and the statuses are not consistent; for another example, the amount of a certain billing file of the reference object is a, and the amount of a billing file of the related comparison object is B, if a > B, it can be determined that the reference object is long, the comparison object is short, and the amount of money does not match, and if a < B, it can be determined that the reference object is short, the comparison object is long, and the amount of money does not match; for another example, if the transaction data includes a commission fee, and the commission fee of a certain bill file of the reference object and the commission fee of a bill file of the comparison object associated therewith are different, it is determined that the commission fees do not match.
Thus, the reconciliation result includes the determination result for each bill file of the reference object and the determination result for each bill file of the comparison object.
In other embodiments, the reconciliation result may be further processed, and the embodiment of the present invention further includes the following steps:
and processing the account checking result.
In the embodiment of the invention, the account result can be processed, such as persistence and early warning generation. Specifically, the reconciliation result can be uploaded to a cloud server for storage so as to realize persistence, and the early warning level can be determined according to the error type of the reconciliation result, so that the user can maintain in time.
In other embodiments, in order to solve the problem that a huge amount of single reconciliation data, especially millions or even tens of millions of reconciliation processing capacity may be caused when external reconciliation is performed, in the embodiment of the present invention, a concept of "distributed task splitting" is provided for massive data, and specifically, when step S10 "is executed to respectively obtain the bill files of the first object and the second object for performing a transaction", the following steps may be adopted:
determining a plurality of batches according to the transaction time of the first object and the second object; and sequentially processing a plurality of batches, and loading the transaction files of the first object and the second object in the transaction time corresponding to each batch.
In the embodiment of the present invention, the billing files of the first object and the second object may be processed in batches according to the transaction time, for example, one batch per hour. Of course, if there are more than one reconciliation server, then each batch may be assigned a corresponding server that processes the batch billing file. Therefore, synchronous acquisition of transaction files of multiple batches can be realized.
On this basis, in order to further split the reconciliation task, in the embodiment of the present invention, when performing step S30, "perform a batch-by-batch reconciliation on the billing file of the comparison object according to the billing file of the reference object", the following steps may be adopted:
creating a plurality of processing threads, wherein one processing thread corresponds to one loaded batch; and calling each processing thread to execute the bill files according to the reference object on the loaded transaction files of the corresponding batch through the processing thread, and performing batch-by-batch blending on the bill files of the comparison object.
In the embodiment of the invention, for one account checking server, if the bill file batches distributed to the account checking server are multiple, multiple processing threads can be built internally, and transaction files of different batches are processed through different processing threads, so that the account checking efficiency is improved.
In other embodiments, for external reconciliation, currently the bill files of the first object and the second object on the previous day are obtained, and the payment gateway and the third-party payment mechanism continue to be taken as an example, since the transactions between the two are delayed, there may be a "daily" order in which the payment gateway exists but the third-party payment mechanism does not exist, such as the bill file "transaction list 0002: li quan business bank 999999 initiates a top-up 100 block operation to the video App li quan virtual account at 2020-10-0923: 59:58 with a successful transaction ", while the bill file of its associated third party payment institution is" transaction bill 0002: the Liquan Industrial and commercial Bank 999999 receives 100 operating instructions for recharging the video App Liquan virtual account at 2020-10-1000: 00:08, and the transaction is successful. Obviously, when the account checking date is '2020-10-10', the bill file of the third party payment institution cannot be acquired, and the third party payment institution belongs to the 'daily cutting' order.
To solve this problem, in the embodiment of the present invention, in executing step S30, "perform a batch-by-batch reconciliation on the billing files of the comparison objects according to the billing file of the reference object to determine the associated multiple sets of billing files", the following steps may be adopted:
if the reference object is a first object and the comparison object is a second object, performing first-time batch-by-batch blending on the bill file of the second object according to the bill file of the first object to determine a plurality of groups of associated bill files;
storing the first bill file of which the associated bill file does not exist in the bill files of the first object and the second object to an error temporary storage pool;
if the reference object is the second object and the comparison object is the first object, performing second-time batch-by-batch blending on the bill file of the first object according to the bill file of the second object to determine that the second bill file of the associated bill file does not exist in the bill file of the second object and the bill file of the first object;
and calling the first bill file stored in the error temporary storage pool on the previous two days, and matching the second bill file with the called first bill file to update the plurality of groups of bill files.
In the embodiment of the invention, the continuous payment gateway and the third-party payment mechanism are taken as examples, the bill files of the third-party payment mechanism are subjected to first one-by-one reconciliation by taking the bill files of the payment gateway as a reference, and after the associated multiple groups of bill files are determined, the associated bill files (namely the first bill file of the previous day) which do not exist in the bill files of the third-party payment mechanism in the bill files of the payment gateway are further stored in the error temporary storage pool to prepare for the identification of the 'daily cutting' order in the next day.
When the bill file of the payment gateway is subjected to second-time batch-by-batch blending by taking the bill file of the third-party payment mechanism as a reference, the determined multiple groups of bill files are the same as the first-time batch-by-batch blending, but the difference is that the first bill file stored in the previous two days of the error temporary storage is called after the second-time batch-by-batch blending is carried out to determine that the associated bill file (namely the second bill file) does not exist in the bill file of the payment gateway in the bill file of the third-party payment mechanism, and a new group or groups of associated bill files can be determined through matching, so that the previous multiple groups of bill files are updated.
According to the reconciliation processing method provided by the embodiment of the invention, for two objects which are transacted, one of the two objects is taken as a reference object, the other object is taken as a comparison object, for example, the first object is taken as the reference object for the first time, and the second object is taken as the reference object for the second time, so that the bill files of the two objects are subjected to reconciliation one by one in a bidirectional reconciliation mode, and the transaction data in the reconciliation file is matched to determine the reconciliation results of the two objects. The invention provides a high-availability and high-performance universal account checking mode, and the accuracy of account checking is improved.
Based on the reconciliation processing method provided by the above embodiment, an embodiment of the present invention correspondingly provides an apparatus for executing the reconciliation processing method, where a schematic structural diagram of the apparatus is shown in fig. 3, and the apparatus includes:
the file acquiring module 10 is configured to acquire bill files of a first object and a second object for performing a transaction, where the bill files record transaction data of the related objects;
a blending module 20 for sequentially taking the first object and the second object as reference objects and taking the other one of the first object and the second object except the reference object as a comparison object; according to the bill files of the reference object, performing batch-by-batch blending on the bill files of the comparison objects to determine a plurality of groups of associated bill files;
and the matching module 30 is used for matching the transaction data of each group of bill files to obtain a reconciliation result of the first object and the second object.
Optionally, the file obtaining module 10 is further configured to:
and respectively carrying out data conversion on the bill files of the first object and the second object so as to obtain respective standard transaction data.
Optionally, the matching module 30 is further configured to:
and processing the account checking result.
Optionally, the file obtaining module 10 is specifically configured to:
determining a plurality of batches according to the transaction time of the first object and the second object; and sequentially processing a plurality of batches, and loading the transaction files of the first object and the second object in the transaction time corresponding to each batch.
Optionally, the blending module 20 is specifically configured to:
creating a plurality of processing threads, wherein one processing thread corresponds to one loaded batch; and calling each processing thread to execute the bill files according to the reference object on the loaded transaction files of the corresponding batch through the processing thread, and performing batch-by-batch blending on the bill files of the comparison object.
Optionally, the reconciliation type of the first object and the second object is internal reconciliation; the file obtaining module 10 is specifically configured to:
and acquiring the bill files of the first object and the second object in real time in response to the transaction events of the first object and the second object.
Optionally, the reconciliation type of the first object and the second object is external reconciliation; the file obtaining module 10 is specifically configured to:
acquiring the bill files of the first object and the second object on the previous day;
the blending module 20 is specifically configured to:
under the condition that the first object is a payment user and the second object is a payment provider, if the reference object is the first object and the comparison object is the second object, performing first-time batch-by-batch reconciliation on the bill files of the second object according to the bill files of the first object to determine a plurality of groups of associated bill files; storing the first bill file of which the associated bill file does not exist in the bill files of the first object and the second object to an error temporary storage pool; if the reference object is the second object and the comparison object is the first object, performing second-time batch-by-batch blending on the bill file of the first object according to the bill file of the second object to determine that the second bill file of the associated bill file does not exist in the bill file of the second object and the bill file of the first object; and calling the first bill file stored in the error temporary storage pool on the previous two days, and matching the second bill file with the called first bill file to update the plurality of groups of bill files.
It should be noted that, for the detailed execution function of each module, reference may be made to the disclosure of the corresponding part of the reconciliation processing method, and details are not described herein again.
The reconciliation processing device provided by the embodiment of the invention takes one of two objects as a reference object and the other as a comparison object in sequence for the two objects which are transacted, for example, the first object is taken as the reference object for the first time and the second object is taken as the reference object for the second time, so that the bill files of the two objects are submitted one by one in a bidirectional reconciliation mode, and the transaction data in the billing files are matched to determine the reconciliation results of the two objects. The invention provides a high-availability and high-performance universal account checking mode, and the accuracy of account checking is improved.
An embodiment of the present invention further provides an electronic device, including: at least one memory and at least one processor; the memory stores a program, and the processor calls the program stored in the memory, wherein the program is used for realizing the reconciliation processing method of the embodiment.
The embodiment of the invention also provides a storage medium, wherein the storage medium stores computer-executable instructions, and the computer-executable instructions are used for executing the reconciliation processing method of the embodiment.
The reconciliation processing method, the reconciliation processing device, the electronic device and the storage medium provided by the invention are described in detail, a specific example is applied in the text to explain the principle and the implementation mode of the invention, and the description of the embodiment is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
It should be noted that, in the present specification, the embodiments are all described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include or include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A reconciliation processing method is characterized by comprising the following steps:
respectively acquiring bill files of a first object and a second object for transaction, wherein the bill files record transaction data of related objects;
sequentially taking the first object and the second object as reference objects, and taking the other object except the reference object in the first object and the second object as a comparison object;
according to the bill files of the reference object, performing batch-by-batch blending on the bill files of the comparison objects to determine a plurality of groups of associated bill files;
and matching transaction data of each group of bill files to obtain account checking results of the first object and the second object.
2. The method of claim 1, wherein after obtaining billing files for the first object and the second object, respectively, for conducting the transaction, the method further comprises:
and respectively carrying out data conversion on the bill files of the first object and the second object so as to obtain respective standard transaction data.
3. The method of claim 1, further comprising:
and processing the reconciliation result.
4. The method of claim 1, wherein obtaining billing files for the first object and the second object, respectively, for conducting the transaction comprises:
determining a plurality of batches according to the transaction time of the first object and the second object;
and sequentially processing the batches, and loading the transaction files of the first object and the second object in the transaction time corresponding to each batch.
5. The method of claim 4, wherein said reconciling the billing files of the comparison object from the billing file of the reference object on a case-by-case basis comprises:
creating a plurality of processing threads, wherein one processing thread corresponds to one loaded batch;
and calling each processing thread to execute the bill file of the reference object on the loaded transaction files of the corresponding batch through the processing thread, and performing batch-by-batch blending on the bill files of the comparison objects.
6. The method of claim 1, wherein the tie-out type of the first object and the second object is internal tie-out;
the obtaining of the billing files of the first object and the second object for the transaction respectively comprises:
and responding to the transaction events of the first object and the second object, and acquiring the bill files of the first object and the second object in real time.
7. The method of claim 1, wherein the tie-out type of the first object and the second object is external tie-out;
the obtaining of the billing files of the first object and the second object for the transaction respectively comprises:
acquiring the bill files of the first object and the second object on the previous day;
in a case where the first object is a payment consumer and the second object is a payment provider, the reconciling the reconciliation files of the comparison objects one by one according to the reconciliation file of the reference object to determine associated sets of reconciliation files, comprising:
if the reference object is the first object and the comparison object is the second object, performing first-time batch-by-batch reconciliation on the bill file of the second object according to the bill file of the first object to determine the associated multiple groups of bill files;
storing a first bill file of which the associated bill file does not exist in the bill files of the first object and the second object into an error temporary storage pool;
if the reference object is the second object and the comparison object is the first object, performing second-time batch-by-batch reconciliation on the bill file of the first object according to the bill file of the second object to determine that the second bill file of the associated bill file does not exist in the bill file of the second object and the bill file of the first object;
and calling the first bill file stored in the error temporary storage pool on the previous two days, and matching the second bill file with the called first bill file to update the plurality of groups of bill files.
8. A reconciliation processing apparatus, comprising:
the file acquisition module is used for respectively acquiring bill files of a first object and a second object for transaction, and the bill files are recorded with transaction data of related objects;
a blending module, configured to sequentially use the first object and the second object as reference objects, and use another object of the first object and the second object except the reference object as a comparison object; according to the bill files of the reference object, performing batch-by-batch blending on the bill files of the comparison objects to determine a plurality of groups of associated bill files;
and the matching module is used for matching the transaction data of each group of bill files to obtain the reconciliation results of the first object and the second object.
9. An electronic device, comprising: at least one memory and at least one processor; the memory stores a program, and the processor calls the program stored in the memory, and the program is used for realizing the reconciliation processing method according to any one of claims 1 to 7.
10. A storage medium having stored thereon computer-executable instructions for performing the reconciliation processing method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011626518.8A CN112634006A (en) | 2020-12-31 | 2020-12-31 | Account checking processing method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011626518.8A CN112634006A (en) | 2020-12-31 | 2020-12-31 | Account checking processing method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112634006A true CN112634006A (en) | 2021-04-09 |
Family
ID=75290021
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011626518.8A Pending CN112634006A (en) | 2020-12-31 | 2020-12-31 | Account checking processing method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112634006A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114547113A (en) * | 2022-04-26 | 2022-05-27 | 云账户技术(天津)有限公司 | Mass data account checking system, method, network equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100174644A1 (en) * | 2006-08-17 | 2010-07-08 | Mastercard International Incorporated | Integrated File Structure Useful in Connection with Apparatus and Method for Facilitating Account Restructuring in an Electronic Bill Payment System |
| CN109859025A (en) * | 2019-01-24 | 2019-06-07 | 上海蔚来汽车有限公司 | A kind of automatic account checking method and electronic equipment |
-
2020
- 2020-12-31 CN CN202011626518.8A patent/CN112634006A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100174644A1 (en) * | 2006-08-17 | 2010-07-08 | Mastercard International Incorporated | Integrated File Structure Useful in Connection with Apparatus and Method for Facilitating Account Restructuring in an Electronic Bill Payment System |
| CN109859025A (en) * | 2019-01-24 | 2019-06-07 | 上海蔚来汽车有限公司 | A kind of automatic account checking method and electronic equipment |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114547113A (en) * | 2022-04-26 | 2022-05-27 | 云账户技术(天津)有限公司 | Mass data account checking system, method, network equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109285069B (en) | Resource transfer method, device and server | |
| CN111553656A (en) | Capital settlement method and device based on big data, electronic equipment and medium | |
| CN110428240B (en) | Automatic suspicious transaction identification and processing method, terminal and server | |
| CN111125106B (en) | Batch running task execution method, device, server and storage medium | |
| CN109615384B (en) | Method, device and server for generating timeliness check rule | |
| CN110689417A (en) | Accounting system-based settlement method and system, storage medium and terminal | |
| CN109325728A (en) | A kind of debt data processing method and terminal device based on user data resource | |
| CN112184240A (en) | Refund request processing method and device | |
| CN110610414A (en) | Data processing method and system | |
| CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
| CN112907344A (en) | Accounting data processing method and device, electronic equipment and storage medium | |
| CN115187378A (en) | Loan automatic repayment method, system, computer equipment and storage medium | |
| CN113554509B (en) | Processing method, device, medium and electronic equipment for online payment service | |
| CN110033362B (en) | Money drawing method, device and equipment | |
| CN113312259B (en) | Interface testing method and device | |
| CN112634006A (en) | Account checking processing method and device, electronic equipment and storage medium | |
| CN112258306B (en) | Account information checking method, device, electronic equipment and storage medium | |
| CN116383052A (en) | Automatic testing method, device and equipment for batch processing task and storage medium | |
| WO2022188528A1 (en) | Transaction fee payment method based on parallel execution, and device and storage medium | |
| CN112634010A (en) | Fund preallocation processing method, device, electronic equipment and medium | |
| CN114444120A (en) | Financing method and device based on block chain, electronic equipment and storage medium | |
| CN112419052A (en) | Transaction testing method and device, electronic equipment and readable storage medium | |
| CN114997977B (en) | Data processing method, device, electronic equipment and computer readable medium | |
| CN114358898A (en) | Accounting data processing method and device, electronic equipment and storage medium | |
| CN115409578A (en) | Order data processing method, system, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210409 |