CN112801616B - Abnormal account book processing method and device - Google Patents
Abnormal account book processing method and device Download PDFInfo
- Publication number
- CN112801616B CN112801616B CN202110119531.2A CN202110119531A CN112801616B CN 112801616 B CN112801616 B CN 112801616B CN 202110119531 A CN202110119531 A CN 202110119531A CN 112801616 B CN112801616 B CN 112801616B
- Authority
- CN
- China
- Prior art keywords
- bank
- data
- account book
- book data
- checking
- 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.)
- Active
Links
- 230000002159 abnormal effect Effects 0.000 title claims abstract description 48
- 238000003672 processing method Methods 0.000 title claims description 8
- 238000012937 correction Methods 0.000 claims abstract description 32
- 238000012545 processing Methods 0.000 claims abstract description 32
- 238000000034 method Methods 0.000 claims abstract description 26
- 238000004590 computer program Methods 0.000 claims description 16
- 238000003860 storage Methods 0.000 claims description 11
- 238000012546 transfer Methods 0.000 claims description 6
- 238000013500 data storage Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 6
- 238000004364 calculation method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000001502 supplementing effect Effects 0.000 description 2
- 230000002457 bidirectional effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000003825 pressing Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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/02—Banking, e.g. interest calculation or account maintenance
-
- 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
Abstract
The invention discloses a method and a device for processing an abnormal account book, wherein the method comprises the following steps: acquiring a preconfigured account book data table, wherein the account book data table comprises a daily final balance account book data table and a transaction detail account book data table; acquiring account book data of a first bank and a second bank according to a preconfigured account book data table, and storing the account book data of the first bank and the second bank in a data lake on a distributed system, wherein data in the data lake are stored in the form of text files; according to account book data of a first bank and a second bank stored in a data lake on a distributed system, checking the first bank and the second bank to obtain difference data; generating abnormal transaction correction data of the first bank and the second bank according to the difference data; the local books of the first bank and the second bank are updated according to the abnormal transaction correction data. The invention has the advantages of less manpower resource consumption, high working efficiency and low cost.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for processing an abnormal account book.
Background
This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
Under the development trend that the bank financing is automatically sold and cleared by the traditional financing product issuing bank and the financing products issued by other banks can be sold by the current bank, the financing account book check in the original bank is also expanded from the account book of a single bank to the account books among a plurality of banks.
When the account book checking and adjusting are performed, the prior art generally relies on the mechanism that the account book checking is completed by the account checking program of the seller's bank on the same day to perform account checking, but sometimes errors occur in the prior accounts or transactions which are found after a plurality of days, such as transaction missing or inconsistent transaction occurrence, due to the logic problem of the account checking program, and the prior batch program cannot be re-run at the moment, so that the historical transaction details need to be checked in a two-way manner, so that the manpower resource consumption is high, the working efficiency is low, and the cost is high.
Disclosure of Invention
The embodiment of the invention provides an abnormal account book processing method, which has the advantages of less manpower resource consumption, high working efficiency and low cost, and comprises the following steps:
acquiring a preconfigured account book data table, wherein the account book data table comprises a daily final balance account book data table and a transaction detail account book data table;
acquiring account book data of a first bank and a second bank according to a preconfigured account book data table, and storing the account book data of the first bank and the second bank in a data lake on a distributed system, wherein the data in the data lake is stored in the form of a text file;
according to account book data of a first bank and a second bank stored in a data lake on a distributed system, checking the first bank and the second bank to obtain difference data;
generating abnormal transaction correction data of the first bank and the second bank according to the difference data;
and updating the local account books of the first bank and the second bank according to the abnormal transaction correction data.
Optionally, the reconciling the first bank and the second bank according to the account book data of the first bank and the second bank stored in the data lake on the distributed system, to obtain difference data includes:
checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail balance data and transaction detail miss data.
Optionally, before updating the local accounts book of the first bank and the second bank according to the abnormal transaction correction data, the method includes:
and judging whether the first bank and the second bank have wrong transaction detail amount and/or missing transaction detail.
Optionally, the account book data of the first bank and the second bank are transferred into the data lake on the distributed system through file transfer software or a file transfer protocol FTP tool.
The embodiment of the invention also provides an abnormal account book processing device, which has the advantages of less manpower resource consumption, high working efficiency and low cost, and comprises:
an account book data table obtaining module, configured to obtain a preconfigured account book data table, where the account book data table includes a daily final balance account book data table and a transaction detail account book data table;
the data storage module is used for acquiring the account book data of the first bank and the second bank according to a preconfigured account book data table, and storing the account book data of the first bank and the second bank in a data lake on the distributed system, wherein the data in the data lake is stored in the form of a text file;
the account checking processing module is used for checking the first bank and the second bank according to the account book data of the first bank and the second bank stored in the data lake on the distributed system to obtain difference data;
the data correction module is used for generating abnormal transaction correction data of the first bank and the second bank according to the difference data;
and the account book processing module is used for updating the local account books of the first bank and the second bank according to the abnormal transaction correction data.
Optionally, the reconciliation processing module is further configured to:
checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail balance data and transaction detail miss data.
Optionally, the apparatus includes:
and the judging module is used for judging whether the first bank and the second bank have wrong transaction details and/or missing transaction details.
Optionally, the account book data of the first bank and the second bank are transferred into the data lake on the distributed system through file transfer software or a file transfer protocol FTP tool.
The embodiment of the invention also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the method when executing the computer program.
Embodiments of the present invention also provide a computer-readable storage medium storing a computer program for executing the above method.
According to the embodiment of the invention, the account book data of the first bank and the second bank are acquired by acquiring the pre-configured account book data table, the account book data of the first bank and the second bank are stored in the data lake on the distributed system, the account book data of the first bank and the second bank are checked according to the account book data of the first bank and the second bank stored in the data lake on the distributed system, the balance data is acquired, abnormal transaction correction data of the first bank and the second bank are generated according to the balance data, and the correction processing of the abnormal account book can be automatically completed according to the local account book of the first bank and the second bank, so that the labor resource consumption is small, the working efficiency is high, and the cost is low.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
FIG. 1 is a flow chart of an abnormal account book processing method in an embodiment of the invention;
FIG. 2 is a schematic diagram of an abnormal account book processing device according to an embodiment of the present invention;
FIG. 3 is a flow chart of an abnormal account book processing method according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an abnormal account processing apparatus according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a computer device according to an embodiment of the invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention will be described in further detail with reference to the accompanying drawings. The exemplary embodiments of the present invention and their descriptions herein are for the purpose of explaining the present invention, but are not to be construed as limiting the invention.
Fig. 1 is a flowchart of a method for processing an abnormal account book according to an embodiment of the present invention, as shown in fig. 1, where the method includes:
step 101, obtaining a preconfigured account book data table, wherein the account book data table comprises a daily final balance account book data table and a transaction detail account book data table.
In the embodiment, the account book data table is configured by user definition in advance, and when the method is implemented, the bank end business system can be embedded through a SIDECAR side car mode, and the daily final balance account book data and the transaction detail account book data are derived according to the daily final balance account book data table and the transaction detail account book data table which are configured by user definition. Wherein the daily final balance account book data and the transaction detail account book data are historical data in a historical banking system.
When the data is exported, the data can be exported according to the user-defined configured business system database information, the date range information and the like.
And 102, acquiring the account book data of the first bank and the second bank according to a preconfigured account book data table, and storing the account book data of the first bank and the second bank in a data lake on a distributed system, wherein the data in the data lake is stored in the form of a text file.
The first bank and the second bank are two-party reconciliation banks. The account book data of the first bank and the second bank are the daily final balance account book data and the transaction detail account book data. The distributed system may be a HADOOP big data platform. In particular implementations, the daily final balance account data and the transaction detail account data may be stored directly in text form in a data lake of the HADOOP big data platform.
In a specific implementation, the account book data of the first bank and the second bank can be transferred into the data lake on the distributed system through file transfer software or a file transfer protocol FTP tool.
Step 103, checking account of the first bank and the second bank according to account book data of the first bank and the second bank stored in a data lake on the distributed system, and obtaining difference data.
In an embodiment, step 103 comprises:
checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail balance data and transaction detail miss data.
For example, based on the HADOOP data lake platform, the B bank transaction detail account book data is checked based on the a bank transaction detail account book data, and the business elements (account number, amount, currency) are checked based on the business unique key (such as the transaction unique serial number). After the one-way check is finished, the check is carried out on the bank data A by taking the bank data B as the reference, and finally, the balance data and the transaction detail missing data of the transaction detail account book are obtained. The transaction detail difference data and the transaction detail missing data can be parameters taking the bank account of a certain party as a standard or supplementing missing data by both parties or discarding transaction details by both parties, and according to the parameters, current day-end balance account book data and current day-end transaction detail account book data of a plurality of banks A and banks B can be generated so as to improve the accuracy of subsequently updating the local account books of the banks A and B.
Step 104, generating abnormal transaction correction data of the first bank and the second bank according to the balance data.
In specific implementation, the day-end balance account book data of the current day can be extracted, the difference data after the two-way check of the first bank and the second bank is read, and a new piece of current day-end account book data, namely abnormal transaction correction data, is generated according to a business primary key (such as an account number and transaction flow). After the newly generated current day final book data is acquired, it may also be exported in the form of a file.
Step 105, updating the local account book of the first bank and the second bank according to the abnormal transaction correction data.
According to the method, the account book data of the first bank and the second bank are acquired according to the pre-configured account book data table, the account book data of the first bank and the second bank are stored in the data lake on the distributed system, the account book data of the first bank and the second bank are checked according to the account book data of the first bank and the second bank stored in the data lake on the distributed system, difference data are acquired, abnormal transaction correction data of the first bank and the second bank are generated according to the difference data, and correction processing of the abnormal account book can be automatically completed according to the local account book of the first bank and the local account book of the second bank, so that human resource consumption is small, working efficiency is high, and cost is low.
In order to first learn about abnormal transactions existing in the first bank and the second bank, so as to facilitate subsequent operations, as shown in fig. 3, before updating local accounts books of the first bank and the second bank according to the abnormal transaction correction data, the method includes:
step 301, determining whether the first bank and the second bank have wrong transaction details and/or missing transaction details.
In the implementation, whether the transaction detail amount is wrong or not or whether the transaction detail is missing or not or whether the transaction detail amount is wrong or whether the transaction detail is missing or not can be judged respectively by the first bank and the second bank.
The following provides a specific example to illustrate the invention:
s1, acquiring daily terminal balance account book data and transaction detail account book data (historical data) from a banking system according to a daily terminal balance account book data table and a transaction detail account book data table which are configured by a user in a customized mode in advance;
s2, storing the daily final balance account book data and the transaction detail account book data in a data lake of the HADOOP big data platform in a text form.
S3, checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail difference data and transaction detail miss data;
s4, reading difference data which are checked in a two-way mode by the first bank and the second bank, and pressing a business main key (such as an account number and a transaction stream) to newly generate current daily final account book data, namely abnormal transaction correction data. After the newly generated current day final account book data is acquired, the current day final account book data can be exported in a file form;
s5, judging whether the first bank and the second bank have wrong transaction details and/or missing transaction details;
and S6, updating local account books of the first bank and the second bank according to the abnormal transaction correction data.
Based on the same inventive concept, the embodiment of the invention also provides an abnormal account book processing device, as described in the following embodiment. Since the principle of solving the problem by the abnormal account book processing device is similar to that of the abnormal account book processing method, the implementation of the abnormal account book processing device can be referred to the implementation of the abnormal account book processing method, and the repeated parts are not repeated. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.
Fig. 2 is a schematic structural diagram of an abnormal account book processing device according to an embodiment of the present invention, where, as shown in fig. 2, the device includes:
an account book data table obtaining module 201, configured to obtain a preconfigured account book data table, where the account book data table includes a daily final balance account book data table and a transaction detail account book data table;
in the embodiment, the account book data table is configured by user definition in advance, and when the method is implemented, the bank end business system can be embedded through a SIDECAR side car mode, and the daily final balance account book data and the transaction detail account book data are derived according to the daily final balance account book data table and the transaction detail account book data table which are configured by user definition. Wherein the daily final balance account book data and the transaction detail account book data are historical data in a historical banking system.
When the data is exported, the data can be exported according to the user-defined configured business system database information, the date range information and the like.
A data storage module 202, configured to collect account book data of the first bank and the second bank according to a preconfigured account book data table, and store the account book data of the first bank and the second bank in a data lake on the distributed system, where data in the data lake is stored in the form of a text file;
the first bank and the second bank are two-party reconciliation banks. The account book data of the first bank and the second bank are the daily final balance account book data and the transaction detail account book data. The distributed system may be a HADOOP big data platform. In particular implementations, the daily final balance account data and the transaction detail account data may be stored directly in text form in a data lake of the HADOOP big data platform.
The reconciliation processing module 203 is configured to perform reconciliation processing on the first bank and the second bank according to account book data of the first bank and the second bank stored in the data lake on the distributed system, so as to obtain difference data;
for example, based on the HADOOP data lake platform, the B bank transaction detail account data is checked based on the a bank transaction detail account data, and the business elements (account number, amount, currency) are checked based on the business unique key (such as the transaction unique serial number). After the one-way check is finished, the check is carried out on the bank data A by taking the bank data B as the reference, and finally, the balance data and the transaction detail missing data of the transaction detail account book are obtained. The transaction detail difference data and the transaction detail missing data can be parameters taking the bank account of a certain party as a standard or supplementing missing data by both parties or discarding transaction details by both parties, and according to the parameters, current day-end balance account book data and current day-end transaction detail account book data of a plurality of banks A and banks B can be generated so as to improve the accuracy of subsequently updating the local account books of the banks A and B.
A data correction module 204 for generating abnormal transaction correction data of the first bank and the second bank according to the difference data;
in specific implementation, the data correction module 204 may extract the day-to-day balance account book data of the current day, read the difference data after the two-way check of the first bank and the second bank, and newly generate a piece of current day-to-day balance account book data, i.e. abnormal transaction correction data, according to the business primary key (such as account number and transaction flow). After the newly generated current day final book data is acquired, it may also be exported in the form of a file.
The account book processing module 205 is configured to update local accounts books of the first bank and the second bank according to the abnormal transaction correction data.
In an embodiment of the present invention, the reconciliation processing module is further configured to:
checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail balance data and transaction detail miss data.
In an embodiment of the present invention, as shown in fig. 4, the apparatus includes:
the judging module 401 is configured to judge whether the first bank and the second bank have wrong transaction details and/or missing transaction details.
In the embodiment of the invention, the account book data of the first bank and the second bank are transmitted into the data lake on the distributed system through file transfer software or a File Transfer Protocol (FTP) tool.
To achieve the above object, according to another aspect of the present application, there is also provided a computer apparatus. As shown in fig. 5, the computer device includes a memory, a processor, a communication interface, and a communication bus, where a computer program executable on the processor is stored on the memory, and when the processor executes the computer program, the steps in the method of the above embodiment are implemented.
The processor may be a central processing unit (Central Processing Unit, CPU). The processor may also be any other general purpose processor, digital signal processor (Digital Signal Processor, DSP), application specific integrated circuit (Application Specific Integrated Circuit, ASIC), field programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination thereof.
The memory is used as a non-transitory computer readable storage medium for storing non-transitory software programs, non-transitory computer executable programs, and units, such as corresponding program units in the above-described method embodiments of the invention. The processor executes the various functional applications of the processor and the processing of the composition data by running non-transitory software programs, instructions and modules stored in the memory, i.e., implementing the methods of the method embodiments described above.
The memory may include a memory program area and a memory data area, wherein the memory program area may store an operating system, at least one application program required for a function; the storage data area may store data created by the processor, etc. In addition, the memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory may optionally include memory located remotely from the processor, the remote memory being connectable to the processor through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The one or more units are stored in the memory, which when executed by the processor, performs the method in the above embodiments.
Embodiments of the present invention also provide a computer-readable storage medium storing a computer program for executing the above method.
In summary, the invention acquires the pre-configured account book data table, acquires the account book data of the first bank and the second bank according to the pre-configured account book data table, stores the account book data of the first bank and the second bank in the data lake on the distributed system, performs account checking processing on the first bank and the second bank according to the account book data of the first bank and the second bank in the data lake on the distributed system, acquires the difference data, generates abnormal transaction correction data of the first bank and the second bank according to the difference data, and updates the local account books of the first bank and the second bank according to the abnormal transaction correction data, thereby automatically completing correction processing on the abnormal account book.
In addition, the historical transaction detail data are subjected to bidirectional checking, the checked difference result and the current daily final balance account book data are subjected to overall calculation according to the user preset parameters, corrected account book data are obtained, the correctness of the business system account book is ensured, the transaction checking and calculation are performed based on the HADOOP big data platform, massive account book data are supported, the performance capacity standard is high, and the business system is flexibly adjusted by the business system, wherein the business system is used for generating multiple corrected account book data by supporting various preset account book adjustment parameters.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (8)
1. An abnormal account book processing method, comprising:
acquiring a preconfigured account book data table, wherein the account book data table comprises a daily final balance account book data table and a transaction detail account book data table;
acquiring account book data of a first bank and a second bank according to a preconfigured account book data table, and storing the account book data of the first bank and the second bank in a data lake on a distributed system, wherein the data in the data lake is stored in the form of a text file;
according to account book data of a first bank and a second bank stored in a data lake on a distributed system, checking the first bank and the second bank to obtain difference data;
generating abnormal transaction correction data of the first bank and the second bank according to the difference data;
updating local account books of the first bank and the second bank according to the abnormal transaction correction data;
the step of checking the first bank and the second bank according to the account book data of the first bank and the second bank stored in the data lake on the distributed system to obtain difference data comprises the following steps:
checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail balance data and transaction detail miss data.
2. The method of claim 1, wherein prior to updating the local books of the first bank and the second bank based on the abnormal transaction correction data, the method comprises:
and judging whether the first bank and the second bank have wrong transaction detail amount and/or missing transaction detail.
3. The method of claim 1, wherein the accounting data of the first bank and the second bank is transferred into the data lake on the distributed system by file transfer software or file transfer protocol FTP tool.
4. An abnormal account book processing apparatus, comprising:
an account book data table obtaining module, configured to obtain a preconfigured account book data table, where the account book data table includes a daily final balance account book data table and a transaction detail account book data table;
the data storage module is used for acquiring the account book data of the first bank and the second bank according to a preconfigured account book data table, and storing the account book data of the first bank and the second bank in a data lake on the distributed system, wherein the data in the data lake is stored in the form of a text file;
the account checking processing module is used for checking the first bank and the second bank according to the account book data of the first bank and the second bank stored in the data lake on the distributed system to obtain difference data;
the data correction module is used for generating abnormal transaction correction data of the first bank and the second bank according to the difference data;
the account book processing module is used for updating local account books of the first bank and the second bank according to the abnormal transaction correction data;
wherein, the reconciliation processing module is further for:
checking the account book data of the second bank by taking the account book data of the first bank as a standard to obtain a first checking result;
checking the account book data of the first bank by taking the account book data of the second bank as a standard to obtain a second checking result;
obtaining difference data according to the first checking result and the second checking result, wherein the difference data comprises: transaction detail balance data and transaction detail miss data.
5. The apparatus of claim 4, wherein the apparatus comprises:
and the judging module is used for judging whether the first bank and the second bank have wrong transaction details and/or missing transaction details.
6. The apparatus of claim 4 wherein the accounting data of the first bank and the second bank is transferred to the data lake on the distributed system by file transfer software or file transfer protocol FTP tool.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 3 when executing the computer program.
8. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program which, when executed by a processor, implements the method of any of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110119531.2A CN112801616B (en) | 2021-01-28 | 2021-01-28 | Abnormal account book processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110119531.2A CN112801616B (en) | 2021-01-28 | 2021-01-28 | Abnormal account book processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112801616A CN112801616A (en) | 2021-05-14 |
| CN112801616B true CN112801616B (en) | 2024-03-05 |
Family
ID=75812541
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110119531.2A Active CN112801616B (en) | 2021-01-28 | 2021-01-28 | Abnormal account book processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112801616B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113626510B (en) * | 2021-08-11 | 2024-02-13 | 中国银行股份有限公司 | Transaction verification method, device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107833131A (en) * | 2017-10-31 | 2018-03-23 | 中国银行股份有限公司 | Inter-bank pays reconciliation method for early warning, device, computer equipment and storage medium |
| CN109360086A (en) * | 2018-09-28 | 2019-02-19 | 厦门商集网络科技有限责任公司 | Method and apparatus based on bank statement data auto-complete accounting data |
| CN109493202A (en) * | 2018-09-27 | 2019-03-19 | 深圳壹账通智能科技有限公司 | Block chain account checking method, device, system, equipment and readable storage medium storing program for executing |
| CN110619562A (en) * | 2019-08-02 | 2019-12-27 | 上海联众网络信息有限公司 | Full-channel bidirectional account checking method |
-
2021
- 2021-01-28 CN CN202110119531.2A patent/CN112801616B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107833131A (en) * | 2017-10-31 | 2018-03-23 | 中国银行股份有限公司 | Inter-bank pays reconciliation method for early warning, device, computer equipment and storage medium |
| CN109493202A (en) * | 2018-09-27 | 2019-03-19 | 深圳壹账通智能科技有限公司 | Block chain account checking method, device, system, equipment and readable storage medium storing program for executing |
| CN109360086A (en) * | 2018-09-28 | 2019-02-19 | 厦门商集网络科技有限责任公司 | Method and apparatus based on bank statement data auto-complete accounting data |
| CN110619562A (en) * | 2019-08-02 | 2019-12-27 | 上海联众网络信息有限公司 | Full-channel bidirectional account checking method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112801616A (en) | 2021-05-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103927314B (en) | A kind of method and apparatus of batch data processing | |
| CN110399533A (en) | Funds flow querying method and device | |
| CN106327196A (en) | Payment threshold acquisition method and device | |
| CN109598604B (en) | Day-to-day cutting judgment method and device | |
| CN104598551A (en) | Data statistics method and device | |
| CN112784112B (en) | Message verification method and device | |
| CN109582550B (en) | Method, device and server for acquiring full-service scene fault set | |
| CN112801616B (en) | Abnormal account book processing method and device | |
| CN113010443B (en) | Database test data generation method and device based on financial core transaction scene | |
| CN112150262B (en) | Account checking data processing method and device | |
| US20190196935A1 (en) | Computer-implemented methods, computer-readable media and electronic devices for processing test electronic transactions | |
| CN109615506A (en) | Collection information processing method and system | |
| CN113128998B (en) | Service processing method, device and system of block chain system | |
| US20110055055A1 (en) | General ledger chart of accounts combination editing request response | |
| CN116797345A (en) | Task processing method, device, computer equipment and storage medium | |
| CN111651522A (en) | Data synchronization method and device | |
| CN116302889A (en) | Performance test method and device for functional module and server | |
| CN113657817B (en) | Transaction processing method and device, electronic equipment and readable storage medium | |
| CN111797099B (en) | Data processing method and device based on subjects and auxiliary attributes | |
| CN111680023B (en) | Migration data checking method and device | |
| CN114418738A (en) | Cross-border remittance data processing method and device | |
| CN113159913A (en) | Accounting information processing method and device | |
| CN111291019B (en) | Similarity discrimination method and device for data model | |
| CN113177843A (en) | Cross-bank loan service processing method and device based on block chain | |
| CN112950384A (en) | Processing system, method, computer equipment and storage medium based on cache technology |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |