CN113077234A - Account checking method, device and storage medium - Google Patents
Account checking method, device and storage medium Download PDFInfo
- Publication number
- CN113077234A CN113077234A CN202110383112.XA CN202110383112A CN113077234A CN 113077234 A CN113077234 A CN 113077234A CN 202110383112 A CN202110383112 A CN 202110383112A CN 113077234 A CN113077234 A CN 113077234A
- Authority
- CN
- China
- Prior art keywords
- bank
- primary key
- relation
- relationship
- record
- 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
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application discloses an account checking method, equipment and a storage medium, wherein the account checking method comprises the following steps: acquiring a bank deposit journal and bank transaction details which need to be checked; constructing a relation primary key for at least one of the bank deposit journal and the bank transaction detail; and checking the data between the bank deposit journal and the bank transaction detail by using the relation primary key to obtain an account checking result. By the scheme, the bank deposit journal and the bank transaction detail can be checked, and the checking efficiency is improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to an account checking method, and a related apparatus, device, and storage medium.
Background
At present, in daily fund management work of enterprises, bank deposit daily keeping accounts and bank transaction details of the enterprise need to be checked regularly, and the bank deposit account conditions are checked at least once every month generally. But generally, the mode of checking the bank deposit journal and the transaction detail of the bank side adopts manual checking. If the data in the particulars of the bank transaction and the data in the bank deposit journal are too numerous, manual checking is time consuming, labor intensive and prone to error. Therefore, there is an urgent need for a method for checking the deposit journal and the transaction details of the bank, so as to save the manpower and improve the checking efficiency.
Disclosure of Invention
The application at least provides an account checking method, a related device, equipment and a storage medium.
The present application provides in a first aspect a method for checking accounts, including: acquiring a bank deposit journal and bank transaction details which need to be checked; constructing a relation primary key for at least one of the bank deposit journal and the bank transaction detail; and checking data between the bank deposit journal and the bank transaction detail by using the relation primary key to obtain an account checking result.
The bank deposit journal comprises at least one first record, the first record comprises a plurality of data attribute information, the bank transaction detail comprises at least one second record, and the second record comprises a plurality of data attribute information; constructing a primary key of relationship for at least one of a bank deposit journal and a bank transaction detail, comprising: respectively taking at least one of a first record in a bank deposit journal and a second record of bank transaction details as a target object; selecting partial data attribute information in the target object as source attribute information; adding at least one piece of new data attribute information as extended attribute information, wherein the new data attribute information is not included in the target object; and combining the source attribute information and the extended attribute information to obtain a corresponding relation primary key of the target object.
The source attribute information comprises the account number, the generation amount and the direction of the account number, the extension attribute information comprises the unit of the opposite party, and the unit of the opposite party is a paying party or a receiving party which is different from the generation amount of the account number of the local party.
The account checking result comprises a bank balance adjusting table, and the bank balance adjusting table comprises available balance and a first outstanding money; constructing a primary key of relationship for at least one of a bank deposit journal and a bank transaction detail, comprising: constructing a first relation primary key for a first record in a bank deposit journal and a second relation primary key for a second record in a bank transaction detail, wherein the first relation primary key and the second relation primary key comprise the same data attribute; the data between the bank deposit journal and the bank transaction detail is checked by using the relation primary key, and the data comprises the following steps: matching the first relation primary key with the second relation primary key to obtain a bank balance adjustment table; or, matching the first relation key with a second record in the bank transaction detail to obtain a first check result, and matching the second relation key with the first record in the bank deposit journal to obtain a second check result; and combining the first check result and the second check result to obtain a bank balance adjustment table.
The method for matching the first relation key with the second relation key or matching the first relation key with a second record in the bank transaction detail to obtain a first check result and matching the second relation key with the first record in the bank deposit journal to obtain a second check result comprises the following steps: taking one of the contents to be matched as a matching object and the other content as an object to be matched, wherein one of the contents to be matched is a first relation primary key or a second relation primary key; respectively matching each data attribute information in the matched object with the data attribute information corresponding to the object to be matched; under the condition that all data attribute information in the matching object is successfully matched, the matching object and the object to be matched are considered to be successfully matched, and the record corresponding to the matching object and the record corresponding to the object to be matched are used as the arrived money; otherwise, the matching object and the record corresponding to the object to be matched are used as the first outstanding money.
The third relation main key comprises all data attribute information in the fourth relation main key, and the data attribute information contained in the third relation main key is more than the data attribute information contained in the fourth relation main key; the data between the bank deposit journal and the bank transaction detail is checked by using the relation primary key, and the data comprises the following steps: using a third relation primary key to check data between the bank deposit journal and the bank transaction detail to obtain a third checking result; and under the condition that the third checking result meets the preset condition, checking the data between the bank deposit journal and the bank transaction detail by using a fourth relation primary key to obtain a fourth checking result, wherein the combination of the third checking result and the fourth checking result is used as an account checking result.
The third relation primary key has at least one data attribute information of date and abstract more than the fourth relation primary key; and/or the preset condition is that a second outstanding money exists, and the second outstanding money comprises data only existing in the bank deposit journal or the bank transaction detail; and the fourth relation primary key is used for checking the data between the bank deposit journal and the bank transaction detail to obtain a fourth checking result, and the fourth checking result comprises the following steps: and checking the second missed money by using the fourth relation main key to obtain a fourth checking result.
Wherein, before obtaining the bank deposit journal that needs to be checked, include: acquiring a bank deposit certificate; extracting an opposite party unit in the bank deposit certificate, wherein the opposite party unit is used for constructing a relation primary key; after acquiring the bank transaction detail needing to be checked, the method comprises the following steps: and eliminating transaction running data which does not need to be checked in the specification of the bank transaction, wherein the transaction running data which does not need to be checked comprises business in the fund pool.
The second aspect of the present application provides an account checking apparatus, including: the data acquisition module is used for acquiring bank deposit journal and bank transaction details which need to be checked; the relation primary key construction module is used for constructing a relation primary key for at least one of the bank deposit journal and the bank transaction detail; and the account checking module is used for checking data between the bank deposit journal and the bank transaction detail by using the relation primary key to obtain an account checking result.
A third aspect of the present application provides an electronic device comprising a memory and a processor, wherein the processor is configured to execute program instructions stored in the memory to implement the above-mentioned account checking method.
A fourth aspect of the present application provides a computer-readable storage medium having stored thereon program instructions that, when executed by a processor, implement the above-described account checking method.
According to the scheme, the relation main key is constructed for at least one of the bank deposit journal and the bank transaction detail, so that the data in the bank deposit journal and the bank transaction detail which need to be checked are checked by using the relation main key, the corresponding data information can be quickly positioned and associated, an account checking result is obtained, and the account checking efficiency is improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the application.
FIG. 1 is a first flowchart of an embodiment of an account checking method of the present application;
FIG. 2 is a second flowchart of an embodiment of the account checking method of the present application;
FIG. 3 is a schematic structural diagram of an embodiment of the account checking apparatus of the present application;
FIG. 4 is a schematic structural diagram of an embodiment of an electronic device of the present application;
FIG. 5 is a schematic structural diagram of an embodiment of a computer-readable storage medium of the present application.
Detailed Description
The following describes in detail the embodiments of the present application with reference to the drawings attached hereto.
In the following description, for purposes of explanation and not limitation, specific details are set forth such as particular system structures, interfaces, techniques, etc. in order to provide a thorough understanding of the present application.
The term "and/or" herein is merely an association describing an associated object, meaning that three relationships may exist, e.g., a and/or B, may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, the character "/" herein generally indicates that the former and latter related objects are in an "or" relationship. Further, the term "plurality" herein means two or more than two. In addition, the term "at least one" herein means any one of a plurality or any combination of at least two of a plurality, for example, including at least one of A, B, C, and may mean including any one or more elements selected from the group consisting of A, B and C.
Referring to fig. 1, fig. 1 is a first flow chart illustrating an embodiment of an account checking method according to the present application. Specifically, the method may include the steps of:
step S11: and acquiring the bank deposit journal and the bank transaction detail which need to be checked.
The manner of acquiring the bank deposit journal needing to be checked may be acquired through an integrated interface of a device executing the account checking method provided by the embodiment of the disclosure or acquired in an importing manner. The mode of acquiring the bank transaction detail can be an orthogonal mode or an importing mode. Typically, bank deposit journal is a record of the business side, while bank transaction detail is a record of the bank side.
Step S12: a relationship primary key is constructed for at least one of a bank deposit journal and a bank transaction detail.
The relationship key can be constructed for one of the bank deposit journal and the bank transaction detail, or for both. Wherein the primary key of the relationship may be in the form of a set of several keywords. Wherein the key words constituting a relationship key should belong to one record. For example, if a bank deposit journal includes several records of transfer, deposit, etc., a relationship key needs to be constructed for each record. The keyword attributes selected for each record may be the same or different.
Step S13: and checking data between the bank deposit journal and the bank transaction detail by using the relation primary key to obtain an account checking result.
In the case where only one of the constructed relationship primary keys is to be checked against the table of the non-constructed relationship primary keys. For example, if a relationship primary key is constructed only for bank deposit journal, the data in the particulars of the bank transaction is checked by using the relationship primary key. Of course, if the relationship key is constructed for both of these two keys, the data check between the bank deposit journal and the bank transaction details is performed using the two relationship keys.
According to the scheme, the relation main key is constructed for at least one of the bank deposit journal and the bank transaction detail, so that the data between the bank deposit journal and the bank transaction detail to be checked is checked by using the relation main key, the corresponding data information can be quickly positioned and associated, an account checking result is obtained, and the account checking efficiency is improved.
In some disclosed embodiments, the bank deposit journal includes at least one first record therein. The first record includes a number of data attribute information. The bank transaction detail comprises at least one second record, and the second record comprises a plurality of data attribute information. The first record and the second record here may be transfer records, deposit records, and the like, any records having a change in funds. The data attribute information includes the account number of the party, the amount of the occurrence, the direction, the abstract, the date and the like.
The method for constructing the main relationship key for at least one of the bank deposit journal and the bank transaction detail can be as follows:
at least one of the first record in the bank deposit journal and the second record of the bank transaction detail is respectively taken as a target object. The embodiment of the disclosure is exemplified by respectively constructing the relation primary key for the bank deposit journal and the bank transaction detail. That is, when the relation primary key is constructed for the bank deposit journal, the first record in the bank deposit journal is the target object, and when the relation primary key is constructed for the bank transaction detail, the second record in the bank transaction detail is the target object.
Then, partial data attribute information in the target object is selected as source attribute information. The source attribute information includes the account number, the generation amount and the direction of the user. In other embodiments, the source attribute information may further include one or more of a date and a summary. Then, at least one piece of new data attribute information is added as extended attribute information. Wherein the new data attribute information is not included in the target object. In the embodiment of the present disclosure, the addition partner unit is selected as the extended attribute information. The counter party unit refers to a paying party or a receiving party which is different from the generation amount of the account number of the party. That is, the partner unit is a unit other than the own account and the bank. Alternatively, the counterpart unit may be a specific unit name or a unit account number. In the embodiment of the present disclosure, the unit name is specific to the partner unit. Because the general bank deposit journal does not include the other party unit, the bank deposit voucher is obtained before the bank deposit journal needing to be checked is obtained, and the other party unit in the bank deposit voucher is extracted. Wherein, the opposite party can be used for constructing the relation primary key. In the process, certainly, the opposite party does not randomly construct the relation primary key with the other source attribute information, and the bank deposit voucher and the bank deposit journal need to be matched firstly to find the corresponding record in the bank deposit journal. The process of matching the bank deposit certificate with the bank deposit journal can be to extract keywords in the bank deposit certificate and match the keywords in the bank deposit journal, certainly, a plurality of keywords can be selected, and under the condition that all the keywords are successfully matched, the bank deposit certificate is considered to be successfully matched with records in the bank deposit journal, so that the opposite side unit in the bank deposit certificate is extracted to construct a relation main key. Optionally, after the bank transaction detail needing to be checked is obtained, transaction running data which does not need to be checked in the bank transaction detail is removed. Wherein the transaction pipelining data without reconciliation comprises transactions in the fund pool. Of course, this part of transaction flow data without account checking is only an example, and other similar fund collection or preset data without account checking can be eliminated. No particular provision is made here regarding transaction flow data that does not require reconciliation.
And finally, combining the source attribute information and the extended attribute information to obtain a corresponding relation primary key of the target object. The expression form of the relationship primary key corresponding to the specific target object may be as follows: the account number of the present party-the unit of the opposite party-the generation amount-the direction. The data checking precision of the relation primary key is improved by constructing the relation primary key by combining the source data attribute information and the extended data attribute information.
As described above, in the embodiment of the present disclosure, corresponding primary keys are established for the bank deposit journal and the bank transaction details. Specifically, a first relation primary key is constructed for a first record in the bank deposit volume, and a second relation primary key is constructed for a second record in the bank transaction detail. The first relationship primary key and the second relationship primary key include the same data attribute, but in another embodiment, the first relationship primary key and the second relationship primary key may include different data attributes. The account checking result comprises a bank balance adjusting table, wherein the bank balance adjusting table comprises available balance and a first outstanding money. The bank balance adjusting table is a comparison table, covers the total balance of the enterprise and the bank, and correspondingly adjusts according to the non-collection of the bank receiving enterprise and the non-collection of the cash of the enterprise, the non-payment of the bank paying enterprise and the non-payment of the bank paying bank in the form to obtain the available balance. The available balance is the actual available deposit amount of the enterprise after account checking and balance adjustment. The first outstanding money mainly comprises related records of the non-payment of the bank and the cash of the enterprise, and the non-payment of the bank and the payment of the enterprise.
In the case of constructing two kinds of relationship main keys, there are at least two ways of checking the data between the bank deposit journal and the bank transaction details by using the relationship main key: and the other one is to match the first relation key with the second relation key to obtain a bank balance adjustment table. In this case, the data attribute information included in the first relation primary key and the second relation primary key is the same. The successful matching determination method may be that the two relationship primary keys are determined to be successfully matched under the condition that all the data attribute information in the two relationship primary keys are successfully matched. The successful matching identification modes among the data attribute information can all be considered to be successful under the condition of one hundred percent of the same rate, and of course, different successful matching identification modes can be determined for different data attribute information, for example, the one hundred percent of the same rate among the contents such as the generation amount, the direction, the account number of the local side and the like, and the unit of the opposite side can identify successful matching under the condition that the same rate is greater than or equal to the preset same rate, and the preset same rate can also be specifically set according to requirements. Of course, if the relation key includes the abstract, the same rate may be preset for the abstract, wherein the manner of obtaining the abstract from the bank deposit journal and the bank transaction details may be a user-defined extraction, for example, the user-defined extraction starts from the number one word, and how many words in total are extracted as the abstract in the relation key. The other method is that the first relation primary key is matched with a second record in the bank transaction detail to obtain a first check result, and the second relation primary key is matched with the first record in the bank deposit journal to obtain a second check result. And then combining the first check result and the second check result to obtain a bank balance adjustment table. The method and the device have the advantages that the relation main keys are respectively constructed for the bank deposit journal and the bank transaction detail, and then account checking is carried out by utilizing the two relation main keys, so that the accuracy of account checking is improved.
In the two verification methods, one of the contents to be matched is used as a matching object, and the other content is used as an object to be matched. The content of the party as the matching object is a first relation primary key or a second relation primary key. And respectively matching each data attribute information in the matched object with the data attribute information corresponding to the object to be matched. For example, the first relationship primary key is used as a matching object, the second relationship primary key is used as an object to be matched, each data attribute information in the first relationship primary key is respectively matched with each data attribute information in the second relationship primary key, that is, the own account number in the first relationship primary key is matched with the own account number in the second relationship primary key, the generation amount in the first relationship primary key is matched with the generation amount in the second relationship primary key, and the like. And under the condition that all the data attribute information in the matching object is successfully matched, the matching object and the object to be matched are considered to be successfully matched. And taking the record corresponding to the matched object and the record corresponding to the object to be matched as the reached money. For example, if one of the first relationship primary keys is considered to be successfully matched with the other second relationship primary key, the first record corresponding to the first relationship primary key and the second record corresponding to the second relationship primary key are considered to be the money reached. The payment is the payment which is paid by the bank and the payment enterprises. Otherwise, the matching object and the record corresponding to the object to be matched are used as the first outstanding money. In the above example, the first record corresponding to the remaining first relationship primary key which is not successfully matched and the second record corresponding to the remaining second relationship primary key which is not successfully matched are used as the first outstanding money. The relation primary key is determined to be successfully matched only under the condition that all data attribute information in the relation primary key is successfully matched, so that error matching is reduced, and the accuracy of account checking is improved.
In some disclosed embodiments, the relationship primary keys include a third relationship primary key and a fourth relationship primary key of the same target object. The target object is a first record of a bank deposit journal or a second record of bank transaction details. For the related content of the first record and the second record, please refer to the above description, which is not repeated herein. The third relation primary key comprises all data attribute information in the fourth relation primary key, and the data attribute information included in the third relation primary key is more than the data attribute information included in the fourth relation primary key. Optionally, the third relation primary key has at least one data attribute information of date and summary more than the fourth relation primary key. For example, the third relationship primary key is the date-abstract-the current account-the opposite account-the generation amount-direction, and the fourth relationship primary key is the current account-the opposite account-the generation amount-direction. As can be seen, the content included in the third-relationship key is greater than the content included in the fourth-relationship key, that is, the accuracy of account checking using the third-relationship key is higher than the accuracy of account checking using the fourth-relationship key, and the matching success rate using the third-relationship key is lower than the matching success rate using the fourth-relationship key. Alternatively, for bank deposit journal or bank transaction detail, the number of third relationship primary keys constructed is generally greater than the number of fourth relationship primary keys. That is, the fourth relational primary key is not constructed for each of the first record or the second record. In order to save the time and other costs for constructing the fourth relationship primary key, the fourth relationship primary key may be constructed for the remaining third relationship primary keys only when the third relationship primary key performs account checking to obtain a third checking result and the third checking result satisfies a preset condition. For a specific manner of checking the account by using the third relationship key and the fourth relationship key, please refer to the following example.
The specific manner of checking the account using the third relationship primary key and the fourth relationship primary key may be: and checking the data between the bank deposit journal and the bank transaction detail by using the third relation primary key to obtain a third checking result. And under the condition that the third check result meets the preset condition, checking the data between the bank deposit journal and the bank transaction detail by using a fourth relation primary key to obtain a fourth check result. And the combination of the third checking result and the fourth checking result is used as an account checking result. Optionally, the preset condition is the presence of a second outstanding money. The second outstanding money includes data that is present only in the bank deposit journal or the bank transaction details. Specifically, the presence of the second outstanding item means a case where the third relation primary key for matching is left and data in the object to be matched is also left. For example, the third relationship primary key for matching is constructed for the bank deposit journal, at this time, the object to be matched is the bank transaction detail, and the data in the object to be matched is the second record, that is, in this case, the third relationship primary key remains and the second record remains, and the second outstanding money is considered to exist. The fourth checking result may be obtained by checking the data between the bank deposit journal and the bank transaction statement using the fourth relationship primary key, and the fourth checking result may be obtained by checking the second outstanding money using the fourth relationship primary key. Specifically, the remaining data in the object to be matched is matched by using the fourth relationship primary keys corresponding to the remaining third relationship primary keys. In the above example, if the third relationship primary key constructed for the bank deposit journal is left and the second record in the bank transaction detail is also left, the remaining second record is checked by using the fourth relationship primary key corresponding to the remaining third relationship primary key.
As described above, the relationship primary key may be constructed for at least one of the bank deposit journal and the bank transaction particulars, or may be constructed for both of them. And under the condition that only one of the construction relation primary keys is used, matching the data in the other object by using the third relation primary key, and under the condition that the third relation primary key is remained and the data in the other object is remained, matching the remaining data in the other object by using the fourth relation primary key corresponding to the remaining third relation primary key so as to obtain a final account checking result. Of course, in the case of constructing the relationship key for both, there are two ways of checking the data between the bank deposit journal and the bank transaction details by using the relationship key, in the first checking way, matching between two third relationship keys is performed first, and if there is a remainder for both the third relationship keys, matching between the fourth relationship keys corresponding to the remaining third relationship keys is performed to obtain the final account checking result. In the second checking method, the second record in the bank transaction specification is matched by using the third relationship primary key corresponding to the bank deposit journal, the remaining second record is matched by using the fourth relationship primary key corresponding to the remaining third relationship primary key when both the third relationship primary key and the second record are remaining, similarly, the first record in the bank deposit journal is matched by using the third relationship primary key corresponding to the bank transaction specification, the remaining first record is matched again by using the fourth relationship primary key corresponding to the remaining third relationship primary key when both the third relationship primary key and the first record are remaining, and then the final account checking result is obtained by integrating the results obtained by the respective matching.
In order to better understand the scheme provided by the embodiment of the present disclosure, the following example is provided, and the implementation process of the scheme is specifically described. Referring to fig. 2, fig. 2 is a second flowchart of an embodiment of the account checking method of the present application. As shown in fig. 2, the account checking method provided by the embodiment of the present disclosure may include the following steps:
s21: and acquiring a bank deposit certificate.
The specific method for acquiring the bank deposit certificate comprises acquiring through an integrated interface and also can be acquired through an importing method. Please refer to the related description in the above embodiments, which is not repeated herein.
S23: and acquiring the bank deposit journal needing to be checked.
For the way of obtaining the bank deposit journal, please refer to the way of obtaining the bank deposit voucher, which is not described herein again.
And S22, acquiring the bank transaction detail needing to be checked.
The manner of obtaining the bank transaction detail data to be checked includes a bank-enterprise direct connection or import manner, which is described above and is not described herein again.
S24: and eliminating transaction running data without account checking.
The transaction running data that does not need reconciliation includes exchange running data generated by collection of funds and the like, and in addition to these, predefined other types of transaction running data and the like.
Step S21 and step S22 may be performed synchronously, or may be performed sequentially.
Step S25: and constructing a first relation primary key for the bank deposit journal and a second relation primary key for the bank transaction detail.
The specific way of constructing the first relationship key and the second relationship key is as described above, and is not described herein again. After the play first relationship primary key and the second relationship primary key are constructed, step S26 or step S27 is performed.
Step S26: and matching the first relation primary key with the second relation primary key to obtain a bank balance adjustment table.
The process of matching the first relationship key and the second relationship key is as described above, and is not described herein again.
Step S27: matching the first relation primary key with a second record in the bank transaction detail to obtain a first check result, and matching the second relation primary key with the first record in the bank deposit journal to obtain a second check result; and combining the first check result and the second check result to obtain a bank balance adjustment table.
Specifically, the first relation primary key is matched with the second record in the bank transaction detail to obtain the first check result, and the second relation primary key is matched with the first record in the bank deposit journal to obtain the second check result in the manner described above, which is not described herein again.
According to the scheme, the relation main key is constructed for at least one of the bank deposit journal and the bank transaction detail, so that the data in the bank deposit journal and the bank transaction detail which need to be checked are checked by using the relation main key, the corresponding data information can be quickly positioned and associated, an account checking result is obtained, and the account checking efficiency is improved.
The main body of the account checking method may be an account checking apparatus, for example, the account checking method may be executed by a terminal device or a server or other processing device, where the terminal device may be a laptop computer, a desktop computer, a User Equipment (UE), a mobile device, a User terminal, a cellular phone, a cordless phone, a Personal Digital Assistant (PDA), a handheld device, a computing device, a vehicle-mounted device, a wearable device, or the like. In some possible implementations, the account checking method may be implemented by a processor calling computer readable instructions stored in a memory.
Referring to fig. 3, fig. 3 is a schematic structural diagram of an embodiment of the account checking apparatus of the present application. The account checking apparatus 30 includes a data acquisition module 31, a relationship primary key construction module 32, and an account checking module 33. The data acquisition module 31 is used for acquiring bank deposit journal and bank transaction details which need to be checked; the relation primary key construction module 32 is used for constructing a relation primary key for at least one of the bank deposit journal and the bank transaction detail; and the account checking module 33 is used for checking data between the bank deposit daily record and the bank transaction details by using the relation primary key to obtain an account checking result.
The function of each module is specifically implemented by the parameter of the above embodiment of the account checking method, which is not described herein again.
According to the scheme, the relation main key is constructed for at least one of the bank deposit journal and the bank transaction detail, so that the data in the bank deposit journal and the bank transaction detail which need to be checked are checked by using the relation main key, the corresponding data information can be quickly positioned and associated, an account checking result is obtained, and the account checking efficiency is improved.
Referring to fig. 4, fig. 4 is a schematic structural diagram of an embodiment of an electronic device according to the present application. Electronic device 40 includes a memory 41 and a processor 42, processor 42 being configured to execute program instructions stored in memory 41 to implement the steps in any of the above-described account reconciliation method embodiments. In one particular implementation scenario, electronic device 40 may include, but is not limited to: a microcomputer, a server, and the electronic device 40 may also include a mobile device such as a notebook computer, a tablet computer, and the like, which is not limited herein.
Specifically, the processor 42 is configured to control itself and the memory 41 to implement the steps in any of the above-described embodiments of the account checking method. Processor 42 may also be referred to as a CPU (Central Processing Unit). The processor 42 may be an integrated circuit chip having signal processing capabilities. The Processor 42 may also be a general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. In addition, the processor 42 may be commonly implemented by an integrated circuit chip.
According to the scheme, the relation main key is constructed for at least one of the bank deposit journal and the bank transaction detail, so that the data in the bank deposit journal and the bank transaction detail which need to be checked are checked by using the relation main key, the corresponding data information can be quickly positioned and associated, an account checking result is obtained, and the account checking efficiency is improved.
Referring to fig. 5, fig. 5 is a schematic structural diagram of an embodiment of a computer-readable storage medium according to the present application. The computer readable storage medium 50 stores program instructions 51 executable by the processor, the program instructions 51 for implementing the steps in any of the above described embodiments of the account reconciliation method.
According to the scheme, the relation main key is constructed for at least one of the bank deposit journal and the bank transaction detail, so that the data in the bank deposit journal and the bank transaction detail which need to be checked are checked by using the relation main key, the corresponding data information can be quickly positioned and associated, an account checking result is obtained, and the account checking efficiency is improved.
In some embodiments, functions of or modules included in the apparatus provided in the embodiments of the present disclosure may be used to execute the method described in the above method embodiments, and specific implementation thereof may refer to the description of the above method embodiments, and for brevity, will not be described again here.
The foregoing description of the various embodiments is intended to highlight various differences between the embodiments, and the same or similar parts may be referred to each other, and for brevity, will not be described again herein.
In the several embodiments provided in the present application, it should be understood that the disclosed method and apparatus may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a module or a unit is merely one type of logical division, and an actual implementation may have another division, for example, a unit or a component may be combined or integrated with another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some interfaces, and may be in an electrical, mechanical or other form.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit. The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) or a processor (processor) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Claims (10)
1. An account checking method, comprising:
acquiring a bank deposit journal and bank transaction details which need to be checked;
constructing a relation primary key for at least one of the bank deposit journal and the bank transaction detail;
and checking the data between the bank deposit journal and the bank transaction detail by using the relation primary key to obtain an account checking result.
2. The method as claimed in claim 1, wherein the bank deposit journal includes at least one first record, the first record including a plurality of data attribute information, the bank transaction detail includes at least one second record, the second record including a plurality of data attribute information;
the constructing of a relationship primary key for at least one of the bank deposit journal and the bank transaction detail includes:
respectively taking at least one of a first record in a bank deposit journal and a second record of bank transaction details as a target object;
selecting partial data attribute information in the target object as source attribute information;
adding at least one piece of new data attribute information as extended attribute information, wherein the new data attribute information is not included in the target object;
and combining the source attribute information and the extended attribute information to obtain a corresponding relation primary key of the target object.
3. The method according to claim 2, wherein the source attribute information includes a local account, an amount of the occurrence, and a direction, and the extended attribute information includes an opponent unit, which is a different payer or receiver of the amount of the occurrence from the local account.
4. The method of claim 2, wherein the account checking result comprises a bank balance adjustment table, the bank balance adjustment table comprising an available balance and a first outstanding money; the constructing of a relationship primary key for at least one of the bank deposit journal and the bank transaction detail includes:
constructing a first relation primary key for a first record in the bank deposit journal and a second relation primary key for a second record in the bank transaction detail, wherein the first relation primary key and the second relation primary key comprise the same data attribute;
the checking the data between the bank deposit journal and the bank transaction detail by using the relation primary key comprises the following steps:
matching the first relation primary key with the second relation primary key to obtain the bank balance adjustment table;
or, matching the first relation key with a second record in the bank transaction detail to obtain a first check result, and matching the second relation key with the first record in the bank deposit journal to obtain a second check result; and combining the first check result and the second check result to obtain the bank balance adjustment table.
5. The method of claim 4, wherein said matching the first primary relationship key with the second primary relationship key, or said matching the first primary relationship key with the second record in the details of the banking transaction, results in a first check, and said matching the second primary relationship key with the first record in the bank deposit journal, results in a second check, comprising:
taking one of the matched contents as a matching object and the other content as an object to be matched, wherein one of the matched contents is the first relation primary key or the second relation primary key;
respectively matching each data attribute information in the matched object with the data attribute information corresponding to the object to be matched;
under the condition that all data attribute information in the matching object is successfully matched, considering that the matching object and the object to be matched are successfully matched, and taking a record corresponding to the matching object and a record corresponding to the object to be matched as a reached money; otherwise, taking the matching object and the record corresponding to the object to be matched as a first outstanding money.
6. The method according to any one of claims 1 to 5, wherein the relationship primary keys comprise a third relationship primary key and a fourth relationship primary key of the same target object, the target object is a first record of the bank deposit journal or a second record of the bank transaction detail, wherein the third relationship primary key contains all data attribute information in the fourth relationship primary key, and the third relationship primary key contains more data attribute information than the fourth relationship primary key;
the checking the data between the bank deposit journal and the bank transaction detail by using the relation primary key comprises the following steps:
using the third relation primary key to check the data between the bank deposit journal and the bank transaction detail to obtain a third checking result;
and under the condition that the third checking result meets a preset condition, checking data between the bank deposit journal and the bank transaction detail by using the fourth relation primary key to obtain a fourth checking result, wherein the combination of the third checking result and the fourth checking result is used as the account checking result.
7. The method of claim 6, wherein the third primary relationship key has at least one of date, summary data attribute information more than the fourth primary relationship key;
and/or, the preset condition is that a second outstanding money exists, and the second outstanding money comprises data only existing in the bank deposit journal or the bank transaction specification;
the checking the data between the bank deposit journal and the bank transaction detail by using the fourth relation primary key to obtain a fourth checking result, comprising the following steps:
and checking the second missed money by using the fourth relation primary key to obtain a fourth checking result.
8. The method of claim 1, wherein prior to obtaining the bank deposit journal to be verified, comprising:
acquiring a bank deposit certificate;
extracting an opposite party unit in the bank deposit voucher, wherein the opposite party unit is used for constructing the relation primary key;
after the bank transaction detail needing to be checked is obtained, the method comprises the following steps:
and eliminating transaction running data which does not need to be checked in the specification of the bank transaction, wherein the transaction running data which does not need to be checked comprises business in a fund pool.
9. An electronic device comprising a memory and a processor for executing program instructions stored in the memory to implement the method of any of claims 1 to 8.
10. A computer readable storage medium having stored thereon program instructions, characterized in that the program instructions, when executed by a processor, implement the method of any of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110383112.XA CN113077234A (en) | 2021-04-09 | 2021-04-09 | Account checking method, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110383112.XA CN113077234A (en) | 2021-04-09 | 2021-04-09 | Account checking method, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113077234A true CN113077234A (en) | 2021-07-06 |
Family
ID=76615809
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110383112.XA Pending CN113077234A (en) | 2021-04-09 | 2021-04-09 | Account checking method, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113077234A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113626510A (en) * | 2021-08-11 | 2021-11-09 | 中国银行股份有限公司 | Transaction checking method, device, electronic equipment and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006331181A (en) * | 2005-05-27 | 2006-12-07 | Nec Personal Products Co Ltd | Accounts receivable matching system and accounts receivable matching method |
| US20110295725A1 (en) * | 2010-05-28 | 2011-12-01 | Jasmine Gee | Methods and apparatus for automated deposit reconciliation |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| JP2015097013A (en) * | 2013-11-15 | 2015-05-21 | 株式会社三井住友銀行 | Bank system, and method executed by the same |
| CN107944996A (en) * | 2017-10-17 | 2018-04-20 | 九派天下支付有限公司 | A kind of fund account checking method and system |
| FR3066299A1 (en) * | 2017-05-11 | 2018-11-16 | Amadeus S.A.S | A SYSTEM AND METHOD FOR PROCESSING AND ACCOUNTING RECONCILIATION OF AN INVOICE DATA FILE |
| CN109711801A (en) * | 2018-12-13 | 2019-05-03 | 平安普惠企业管理有限公司 | A kind of Internetbank account checking method and device |
| CN111798296A (en) * | 2020-06-15 | 2020-10-20 | 远光软件股份有限公司 | Automatic account checking method, automatic account checking device and computer readable storage medium |
| CN111932354A (en) * | 2020-06-30 | 2020-11-13 | 浙江物产信息技术有限公司 | Method for calculating balance adjustment table |
-
2021
- 2021-04-09 CN CN202110383112.XA patent/CN113077234A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006331181A (en) * | 2005-05-27 | 2006-12-07 | Nec Personal Products Co Ltd | Accounts receivable matching system and accounts receivable matching method |
| US20110295725A1 (en) * | 2010-05-28 | 2011-12-01 | Jasmine Gee | Methods and apparatus for automated deposit reconciliation |
| CN102968716A (en) * | 2012-11-26 | 2013-03-13 | 深圳中兴网信科技有限公司 | Account checking system and account checking method |
| JP2015097013A (en) * | 2013-11-15 | 2015-05-21 | 株式会社三井住友銀行 | Bank system, and method executed by the same |
| FR3066299A1 (en) * | 2017-05-11 | 2018-11-16 | Amadeus S.A.S | A SYSTEM AND METHOD FOR PROCESSING AND ACCOUNTING RECONCILIATION OF AN INVOICE DATA FILE |
| CN107944996A (en) * | 2017-10-17 | 2018-04-20 | 九派天下支付有限公司 | A kind of fund account checking method and system |
| CN109711801A (en) * | 2018-12-13 | 2019-05-03 | 平安普惠企业管理有限公司 | A kind of Internetbank account checking method and device |
| CN111798296A (en) * | 2020-06-15 | 2020-10-20 | 远光软件股份有限公司 | Automatic account checking method, automatic account checking device and computer readable storage medium |
| CN111932354A (en) * | 2020-06-30 | 2020-11-13 | 浙江物产信息技术有限公司 | Method for calculating balance adjustment table |
Non-Patent Citations (1)
| Title |
|---|
| 薛志红: "财务软件中如何进行"银行对账"", 《经济论坛》, pages 49 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113626510A (en) * | 2021-08-11 | 2021-11-09 | 中国银行股份有限公司 | Transaction checking method, device, electronic equipment and storage medium |
| CN113626510B (en) * | 2021-08-11 | 2024-02-13 | 中国银行股份有限公司 | Transaction verification method, device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108376364B (en) | Payment system account checking method and device and terminal device | |
| CN105389488B (en) | Identity identifying method and device | |
| CN112163946A (en) | Accounting processing method and device based on distributed transaction system | |
| WO2011068867A2 (en) | System and method of matching financial transaction records to merchant records of a merchant profile database | |
| CN110874742B (en) | Payment method and device based on block chain and intelligent contract | |
| CN110163634B (en) | Refund method and device based on blockchain and electronic equipment | |
| KR101863612B1 (en) | Apparatus, method and computer program for verifying real name transaction through comparing deposit and withdrawal history | |
| CN108595579A (en) | Contact person's cohesion evaluation method, device, computer equipment and storage medium | |
| CN112053232B (en) | Self-service equipment business accounting consistency processing method and device | |
| CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
| WO2020103573A1 (en) | Block chain-based network transaction signature method and device, and terminal equipment | |
| CN111292178B (en) | Demand matching method and device, storage medium and electronic equipment | |
| CN107392600B (en) | Digital currency transaction payment registration method and system | |
| CN109598575B (en) | Bill generation method and device, electronic equipment and medium | |
| CN113077234A (en) | Account checking method, device and storage medium | |
| WO2020170187A1 (en) | Large-scale processing of data records with efficient retrieval | |
| CN111754320A (en) | Internal transaction voucher cancellation method, device and medium based on business management dimension | |
| CN116128668A (en) | Method, system and computer storage medium for matching bank certificate subjects | |
| CN105989064A (en) | Record information checking method and device | |
| CN115293755A (en) | Bill reconciliation processing method, device, equipment and storage medium | |
| CN115082173A (en) | Account checking processing method and device, computer equipment and storage medium | |
| CN112712353B (en) | Digital currency zero-payment method, system and terminal | |
| CN109993648B (en) | Data processing method and related device | |
| CN113450197A (en) | Hanging account self-balancing result checking method and device | |
| CN113055401A (en) | Enterprise business authorization processing method and device |
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 |