CN105303437A - Processing method and device for account checking - Google Patents

Abstract

The present invention provides a processing method and device for account reconciliation, comprising: receiving an account reconciliation request, the account reconciliation request including the identification of the transaction system; according to the account reconciliation request, obtaining the account reconciliation file in the transaction system corresponding to the identification of the transaction system, and the transaction information stored in the local database; obtain the first transaction record group corresponding to the reconciliation file, and the second transaction record group corresponding to the transaction information; according to the first primary key, according to the first preset order, the first The first transaction records in the transaction record group are sorted, and the second transaction records in the second transaction group are sorted according to the first preset order according to the second primary key; the sorted first transaction records In the group and the second transaction record group, compare whether the first transaction record is consistent with the second transaction record with the same corresponding order, and perform corresponding processing according to the obtained reconciliation result. The method and device for processing reconciliation provided by the present invention, Improve the efficiency of reconciliation.

Description

Account reconciliation processing method and device

technical field

The present invention relates to the technical field of communications, in particular to a method and device for processing account reconciliation.

Background technique

Reconciliation is the most common scenario in the financial system. For example, each bank needs to reconcile with UnionPay, Alipay needs to reconcile with each bank, and each merchant of Alipay may also need to reconcile Alipay. Usually, the transaction system is in When processing funds for transactions, it is necessary to call the payment system for payment, and the payment system is responsible for the liquidation of funds.

In the prior art, in order to ensure the accuracy of funds, the payment system generally provides reconciliation files for the transaction system, and before liquidating the funds, query the local database of the transaction system one by one according to the primary key of each record in the reconciliation file. For each record, if the corresponding record in the reconciliation file is not found in the local database of the transaction system, the corresponding record in the reconciliation file will be marked as abnormal data. For the corresponding record in the reconciliation file, compare each field in the record, and mark the record in the local database of the transaction system as checked. If any difference is found, mark the record as abnormal data .

However, with the prior art, since each record in the reconciliation file needs to visit the local database of the transaction system to query and compare records, the efficiency of reconciliation is reduced.

Contents of the invention

The invention provides a processing method and device for account reconciliation, which are used to solve the problem of low account reconciliation efficiency in the prior art.

The first aspect of the present invention provides a processing method for reconciliation, including:

Receive a reconciliation request, the reconciliation request includes the identification of the transaction system;

According to the reconciliation request, obtain the reconciliation file in the transaction system corresponding to the identifier of the transaction system, and the transaction information stored in the local database;

Obtain a first transaction record group corresponding to the reconciliation file, and a second transaction record group corresponding to the transaction information, wherein the first transaction record group includes a plurality of first transaction records, each Each transaction record includes a first primary key and a corresponding reconciliation field; the second transaction record group includes a plurality of second transaction records, and each second transaction record includes a second primary key and a corresponding reconciliation field;

According to the first primary key, the first transaction records in the first transaction record group are sorted according to the first preset sequence, and according to the second primary key, according to the first preset sequence, the second The second transaction records in the transaction group are sorted;

In the sorted first transaction record group and the second transaction record group, compare whether the first transaction record is consistent with the corresponding second transaction record with the same sort, and perform corresponding processing according to the obtained reconciliation result.

The second aspect of the present invention provides a processing device for reconciliation, including:

A receiving module, configured to receive an account reconciliation request, wherein the account reconciliation request includes the identification of the transaction system;

An acquisition module, configured to acquire, according to the account reconciliation request, the account reconciliation file in the transaction system corresponding to the identifier of the transaction system, and the transaction information stored in the local database;

The obtaining module is also used to obtain a first transaction record group corresponding to the reconciliation file, and a second transaction record group corresponding to the transaction information, wherein the first transaction record group includes a plurality of A transaction record, each first transaction record includes a first primary key and a corresponding reconciliation field; the second transaction record group includes a plurality of second transaction records, and each second transaction record includes a second primary key and Corresponding reconciliation fields;

A sorting module, configured to sort the first transaction records in the first transaction record group according to the first preset order according to the first primary key, and sort according to the first preset sequence according to the second primary key order, sorting the second transaction records in the second transaction group;

The comparison processing module is used to compare whether the first transaction record is consistent with the second transaction record corresponding to the same sort in the sorted first transaction record group and the second transaction record group, and perform corresponding corresponding reconciliation results according to the obtained reconciliation results. deal with.

The present invention provides a processing method and device for account reconciliation, comprising: receiving an account reconciliation request, the account reconciliation request including the identification of the transaction system; according to the account reconciliation request, obtaining the account reconciliation file in the transaction system corresponding to the identification of the transaction system, and the transaction information stored in the local database; obtain the first transaction record group corresponding to the account reconciliation file, and the second transaction record group corresponding to the transaction information, and according to each first transaction record in the first transaction record group The first primary key, according to the first preset order, sorts the first transaction records in the first transaction record group, and then according to the second primary key in the second transaction records in the second transaction record group, according to the first Preset sort order, sort the second transaction records in the second transaction group; in the sorted first transaction record group and second transaction record group, compare the first transaction record with the corresponding second transaction with the same sort Whether the records are consistent, and perform corresponding processing according to the obtained reconciliation results. Since the first transaction record group corresponding to the reconciliation file can be firstly processed according to the first primary key and the first preset order, the first transaction record group According to the second transaction record group corresponding to the transaction information saved in the local database, according to the second primary key and the first preset order, the second transaction record in the second transaction record group Sorting, and then comparing the first transaction record group and the second transaction record group after sorting to see if the first transaction record is consistent with the second transaction record with the same sorting. For each transaction record in the database, the stored transaction information in the local database should be queried separately to obtain matching transaction records for comparison. This embodiment effectively improves the processing efficiency of account reconciliation.

Description of drawings

Fig. 1 is a schematic flow chart of Embodiment 1 of the processing method for reconciliation provided by the present invention;

FIG. 2 is a schematic flow diagram of Embodiment 2 of the processing method for reconciliation provided by the present invention;

Fig. 3 is a schematic flow chart of Embodiment 3 of the processing method for reconciliation provided by the present invention;

FIG. 4 is a schematic flow diagram of Embodiment 4 of the processing method for reconciliation provided by the present invention;

FIG. 5 is a schematic structural diagram of Embodiment 1 of the processing device for reconciliation provided by the present invention;

FIG. 6 is a schematic structural diagram of Embodiment 2 of the processing device for reconciliation provided by the present invention;

FIG. 7 is a schematic structural diagram of Embodiment 3 of the processing device for reconciliation provided by the present invention;

FIG. 8 is a schematic structural diagram of Embodiment 4 of the processing device for reconciliation provided by the present invention.

detailed description

In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

Fig. 1 is a schematic flow chart of Embodiment 1 of the processing method for reconciliation provided by the present invention. As shown in Fig. 1, the method includes:

Step 101. Receive an account reconciliation request, where the account reconciliation request includes the identification of the transaction system.

In this embodiment, the subject of execution of the method is the account reconciliation processing device. In addition, each transaction system has a unique identifier.

Step 102, according to the reconciliation request, obtain the reconciliation file in the transaction system corresponding to the identifier of the transaction system, and the transaction information stored in the local database.

Step 103, acquiring the first transaction record group corresponding to the reconciliation file, and the second transaction record group corresponding to the transaction information.

Wherein, the first transaction record group includes a plurality of first transaction records, each first transaction record includes a first primary key and a corresponding reconciliation field; the second transaction record group includes a plurality of second transaction records, each The second transaction record includes a second primary key and a corresponding reconciliation field.

In this embodiment, for example, the first primary key in the first transaction record may be a serial number, and its corresponding reconciliation fields include but not limited to amount, order number, handling fee, date, receiving account number and payment account number etc.; the second primary key in the second transaction record may be a serial number, and its corresponding reconciliation fields include but not limited to amount, order number, handling fee, date, receiving account number and payment account number, etc.

Step 104: sort the first transaction records in the first transaction record group according to the first preset order according to the first primary key, and sort the second transaction records according to the first preset order according to the second primary key The second transactions in the group are sorted.

In this embodiment, if the first primary key and the second primary key are serial numbers or order numbers, the first preset arrangement sequence may be from large to small, or may be from small to large.

Step 105. In the sorted first transaction record group and the second transaction record group, compare whether the first transaction record is consistent with the corresponding second transaction record with the same sort, and perform corresponding processing according to the obtained reconciliation result.

In this embodiment, for example, the number of first transaction records in the sorted first transaction record group is N, and the number of second transaction records in the sorted second transaction record group is N, Then the first transaction record sorted by i can be compared with the second transaction record sorted by i, and if they are all the same, a correct reconciliation result will be generated; if at least one of them is different, the two different transaction records can be compared. The same first transaction record and second transaction record are extracted to form a reconciliation report, so as to generate a reconciliation result carrying the reconciliation report.

In this embodiment, the reconciliation request is received, and the reconciliation request includes the identification of the transaction system; according to the reconciliation request, the reconciliation file in the transaction system corresponding to the identification of the transaction system and the transaction information stored in the local database are obtained; Obtain the first transaction record group corresponding to the reconciliation file, and the second transaction record group corresponding to the transaction information, and according to the first primary key in each first transaction record in the first transaction record group, according to the first preset Sorting order: sort the first transaction records in the first transaction record group, and then sort the second transaction records according to the second primary key in the second transaction records in the second transaction record group according to the first preset The second transaction records in the group are sorted; in the sorted first transaction record group and the second transaction record group, compare whether the first transaction record is consistent with the corresponding second transaction record in the same order, and according to the obtained pair According to the first transaction record group corresponding to the reconciliation file, the first transaction records in the first transaction record group can be sorted according to the first primary key and the first preset order, According to the second transaction record group corresponding to the transaction information stored in the local database, sort the second transaction records in the second transaction record group according to the second primary key and the first preset order, and then sort the sorted first In the first transaction record group and the second transaction record group, compare whether the first transaction record is consistent with the second transaction record with the same corresponding order. Compared with the prior art, each transaction record in the reconciliation file needs to be In terms of querying the stored transaction information in the local database and obtaining matching transaction records for comparison, this embodiment effectively improves the processing efficiency of account reconciliation.

Fig. 2 is a schematic flow chart of Embodiment 2 of the processing method for reconciliation provided by the present invention. As shown in Fig. 2, the method includes:

Step 201. Receive an account reconciliation request, which includes the identification of the transaction system.

Step 202, according to the reconciliation request, obtain the reconciliation file in the transaction system corresponding to the identifier of the transaction system, and the transaction information stored in the local database.

Step 203, using the sed tool to remove the file header and the file footer in the reconciliation file, so as to obtain the processed reconciliation file.

In this embodiment, the file header and the file footer in the reconciliation file do not include reconciliation field information.

Step 204, using the awk tool to obtain a first transaction record group from the processed reconciliation file, wherein the first transaction record group includes a plurality of first transaction records, and each first transaction record includes a first primary key and the corresponding reconciliation fields.

In this embodiment, the awk tool can be used to obtain the information of each reconciliation field in the processed reconciliation file.

Step 205: Obtain a second transaction record group corresponding to the transaction information, wherein the second transaction record group includes a plurality of second transaction records, and each second transaction record includes a second primary key and a corresponding reconciliation field.

Step 206: sort the first transaction records in the first transaction record group according to the first preset order according to the first primary key, and sort the second transaction records according to the first preset order according to the second primary key The second transactions in the group are sorted.

Step 207: In the sorted first transaction record group and the second transaction record group, compare whether the first transaction record is consistent with the corresponding second transaction record with the same sort, and perform corresponding processing according to the obtained reconciliation result.

In this embodiment, the sed tool is used to remove the file header and the file tail in the reconciliation file to obtain the processed reconciliation file, and the awk tool is used to obtain the first transaction record group from the processed reconciliation file , so that the information of each reconciliation field can be obtained from the reconciliation file, so as to facilitate subsequent processing of each reconciliation field in the reconciliation file.

Fig. 3 is a schematic flow chart of the third embodiment of the processing method for reconciliation provided by the present invention. On the basis of the embodiment described in Fig. 2 above, as shown in Fig. 3, the third embodiment of the processing method for reconciliation provided by the present invention In step 204, the awk tool is used to obtain the first transaction record group from the processed reconciliation file, including:

Step 301, using the awk tool to obtain initial first transaction records from the processed reconciliation file according to preset field information, wherein the field information in each initial first transaction record matches the preset field information.

In this embodiment, the preset field information can be selected from all reconciliation fields of the reconciliation file according to the specific needs of reconciliation.

Step 302: Determine the first primary key from the field information in each initial first transaction record, and sort the field information other than the first primary key according to the second sorting order as the reconciliation corresponding to the first primary key field to get the first transaction record.

In this embodiment, the awk tool is used to obtain the initial first transaction record from the processed reconciliation file according to the preset field information, wherein the field information in each initial first transaction record is the same as the preset field information Information matching, respectively determine the first primary key from the field information in each initial first transaction record, and sort the field information other than the first primary key according to the second sorting order as the reconciliation corresponding to the first primary key words to obtain the first transaction record, so that the preset field information can be adaptively selected according to the reconciliation requirements, so as to obtain the corresponding first transaction record, thereby reducing the data volume of the first transaction record.

Fig. 4 is a schematic flow chart of Embodiment 4 of the processing method for reconciliation provided by the present invention. On the basis of the embodiment described in Fig. 2 above, as shown in Fig. 4 , in Embodiment 4 of the processing method for reconciliation provided by the present invention , in step 206, the second transaction record group corresponding to the transaction information is obtained, including:

Step 401. Obtain an initial second transaction record from the transaction information according to preset field information; wherein, the field information in each initial second transaction record matches the preset field information.

Step 402, respectively determine the second primary key from the field information in each initial second transaction record, and sort the field information except the second primary key according to the second arrangement order as the reconciliation corresponding to the second primary key field to get the second transaction record.

In this embodiment, the initial second transaction record is obtained from the transaction information according to the preset field information; wherein, the field information in each initial second transaction record matches the preset field information, and each initial Determine the second primary key in the field information in the second transaction record, and sort the field information except the second primary key according to the second arrangement order as the reconciliation field corresponding to the second primary key to obtain the second transaction record , so that the order of each field of the first transaction record and the second transaction record is the same, thereby improving the efficiency of reconciliation.

Further, on the basis of any of the above embodiments, in Embodiment 5 of the method for processing accounts reconciliation provided by the present invention, the first primary key and the second primary key include a serial number, or a serial number and an order number.

FIG. 5 is a schematic structural diagram of Embodiment 1 of an account reconciliation processing device provided by the present invention. As shown in FIG.

The receiving module 10 is configured to receive an account reconciliation request, and the account reconciliation request includes the identification of the transaction system.

The acquiring module 11 is configured to acquire the account reconciliation file in the transaction system corresponding to the identifier of the transaction system and the transaction information stored in the local database according to the account reconciliation request.

The obtaining module 11 is also used to obtain the first transaction record group corresponding to the reconciliation file, and the second transaction record group corresponding to the transaction information, wherein the first transaction record group includes a plurality of first transaction records, each Each transaction record includes a first primary key and a corresponding reconciliation field; the second transaction record group includes a plurality of second transaction records, and each second transaction record includes a second primary key and a corresponding reconciliation field.

The sorting module 12 is configured to sort the first transaction records in the first transaction record group according to the first preset order according to the first primary key, and sort the first transaction records in the first transaction record group according to the first preset sequence according to the second primary key. The second transaction records in the second transaction group are sorted.

The comparison processing module 13 is used to compare whether the first transaction record is consistent with the second transaction record corresponding to the same sort in the sorted first transaction record group and the second transaction record group, and perform corresponding transaction according to the obtained reconciliation result. processing.

The processing device for reconciliation in this embodiment can execute the technical solution of the method embodiment shown in FIG. 1 , and its implementation principle and beneficial effects are similar, and will not be repeated here.

FIG. 6 is a schematic structural diagram of Embodiment 2 of an account reconciliation processing device provided by the present invention. As shown in FIG. 6 , on the basis of Embodiment 1 above, the acquisition module 11 includes: a first acquisition unit 110 and a second acquisition unit 111 .

The first obtaining unit 110 is configured to use the sed tool to remove the file header and file trailer in the reconciliation file, so as to obtain the processed reconciliation file.

The second obtaining unit 111 is configured to use the awk tool to obtain the first transaction record group from the processed reconciliation file.

The processing device for account reconciliation in this embodiment can implement the technical solution of the method embodiment shown in FIG. 2 , and its implementation principles and beneficial effects are similar, and will not be repeated here.

FIG. 7 is a schematic structural diagram of Embodiment 3 of the processing device for reconciliation provided by the present invention. As shown in FIG. 7 , on the basis of the above embodiments, the second acquisition unit 111 includes:

The matching subunit 1110 is used to use the awk tool to obtain the initial first transaction record from the processed reconciliation file according to the preset field information; wherein, the field information in each initial first transaction record is consistent with the preset The field information matches.

The transaction record acquisition subunit 1111 is configured to determine the first primary key from the field information in each initial first transaction record, and sort the field information except the first primary key according to the second arrangement order as the first primary key. A reconciliation word corresponding to a primary key to obtain the first transaction record.

The processing device for account reconciliation in this embodiment can execute the technical solution of the method embodiment shown in FIG. 3 , and its implementation principles and beneficial effects are similar, and will not be repeated here.

FIG. 8 is a schematic structural diagram of Embodiment 4 of the reconciliation processing device provided by the present invention. As shown in FIG. 8 , on the basis of the above-mentioned Embodiment 3, the acquisition module 11 further includes:

The third obtaining unit 112 is used to obtain the initial second transaction record from the transaction information according to the preset field information; and determine the second primary key from the field information in each initial second transaction record, and then divide the first The field information other than the second primary key is sorted according to the second sorting order and used as the reconciliation field corresponding to the second primary key to obtain the second transaction record.

Wherein, the field information in each initial second transaction record matches the preset field information.

The device for processing account reconciliation in this embodiment can implement the technical solution of the method embodiment shown in FIG. 4 , and its implementation principles and beneficial effects are similar, and will not be repeated here.

Furthermore, on the basis of any of the above embodiments, in Embodiment 5 of the processing device for reconciliation provided by the present invention, the first primary key and the second primary key include a serial number, or a serial number and an order number.

Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present invention, rather than limiting them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: It is still possible to modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some or all of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the technical solutions of the various embodiments of the present invention. scope.

Claims (10)

1. a disposal route for reconciliation, is characterized in that, comprising:

Receive reconciliation request, described reconciliation request comprises the mark of transaction system;

According to described reconciliation request, obtain the reconciliation file in the transaction system of the mark correspondence of described transaction system, and the Transaction Information preserved in local data base;

Obtain the first transaction record group corresponding with described reconciliation file, and the second transaction record group corresponding with described Transaction Information, wherein, described first transaction record group comprises multiple first transaction record, and each first transaction record includes the first major key and corresponding reconciliation field; Described second transaction record group comprises multiple second transaction record, and each second transaction record comprises the second major key and corresponding reconciliation field;

According to the first major key, preset according to first and put in order, sequence process is carried out to the first transaction record in described first transaction record group, and according to the second major key, preset according to described first and put in order, sequence process is carried out to the second transaction record in the second transaction group;

In the first transaction record group after sequence and the second transaction record group, compare the first transaction record whether consistent with corresponding the second identical transaction record that sorts, and process accordingly according to the reconciliation result obtained.

2. method according to claim 1, is characterized in that, the first transaction record group that described acquisition is corresponding with described reconciliation file, comprising:

Adopt sed instrument, remove the file header in described reconciliation file and end-of-file, to obtain the reconciliation file after process;

Adopt awk instrument, from the reconciliation file after described process, obtain described first transaction record group.

3. method according to claim 2, is characterized in that, described employing awk instrument, from the reconciliation file after described process, obtains described first transaction record group, comprising:

Adopt described awk instrument, from the reconciliation file after described process, according to preset field information, obtain initial first transaction record; Wherein, the field information in each initial first transaction record all with described preset field information matches;

The first major key is determined respectively from the field information each described initial first transaction record, and using after other field informations except described first major key sort according to second order order as the reconciliation field that described first major key is corresponding, to obtain described first transaction record.

4. according to the method in claim 2 or 3, it is characterized in that, obtain the second transaction record group corresponding with described Transaction Information, comprising:

From Transaction Information, according to preset field information, obtain initial second transaction record; Wherein, the field information in each initial second transaction record all with described preset field information matches;

The second major key is determined respectively from the field information each described initial second transaction record, and using after other field informations except described second major key sort according to second order order as the reconciliation field that described second major key is corresponding, to obtain described second transaction record.

5. according to the arbitrary described method of claims 1 to 3, it is characterized in that, described first major key and the second major key comprise serial number or described serial number and order number.

6. a treating apparatus for reconciliation, is characterized in that, comprising:

Receiver module, for receiving reconciliation request, described reconciliation request comprises the mark of transaction system;

Acquisition module, for according to described reconciliation request, obtains the reconciliation file in the transaction system of the mark correspondence of described transaction system, and the Transaction Information preserved in local data base;

Described acquisition module is also for obtaining the first transaction record group corresponding with described reconciliation file, and the second transaction record group corresponding with described Transaction Information, wherein, described first transaction record group comprises multiple first transaction record, and each first transaction record includes the first major key and corresponding reconciliation field; Described second transaction record group comprises multiple second transaction record, and each second transaction record comprises the second major key and corresponding reconciliation field;

Order module, for according to the first major key, presets according to first and puts in order, sequence process is carried out to the first transaction record in described first transaction record group, and according to the second major key, preset according to described first and put in order, sequence process is carried out to the second transaction record in the second transaction group;

Relatively processing module, in the first transaction record group after sequence and the second transaction record group, compares the first transaction record whether consistent with corresponding the second identical transaction record that sorts, and processes accordingly according to the reconciliation result obtained.

7. device according to claim 6, is characterized in that, described acquisition module comprises:

First acquiring unit, for adopting sed instrument, removes the file header in described reconciliation file and end-of-file, to obtain the reconciliation file after process;

Second acquisition unit, for adopting awk instrument, from the reconciliation file after described process, obtains described first transaction record group.

8. device according to claim 7, is characterized in that, described second acquisition unit comprises:

Coupling subelement, for adopting described awk instrument, from the reconciliation file after described process, according to preset field information, obtains initial first transaction record; Wherein, the field information in each initial first transaction record all with described preset field information matches;

Transaction record obtains subelement, for determining the first major key respectively from the field information each described initial first transaction record, and using after other field informations except described first major key sort according to second order order as the reconciliation field that described first major key is corresponding, to obtain described first transaction record.

9. the device according to claim 7 or 8, is characterized in that, described acquisition module also comprises:

3rd acquiring unit, for from described Transaction Information, according to preset field information, obtains initial second transaction record; And from the field information each described initial second transaction record, determine the second major key respectively, again using after other field informations except described second major key sort according to second order order as the reconciliation field that described second major key is corresponding, to obtain described second transaction record;

Wherein, the field information in each initial second transaction record all with described preset field information matches.

10. according to the arbitrary described device of claim 6 to 8, it is characterized in that, described first major key and the second major key comprise serial number or described serial number and order number.