Account checking method and device, storage medium and electronic device
By automatically reconciling accounting information between the transaction system and the general ledger system in the banking system, the problem of data inconsistency between different systems is solved, the efficiency and accuracy of verification are improved, and the need for manual verification is reduced.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- 吉林亿联银行股份有限公司
- Filing Date
- 2022-06-24
- Publication Date
- 2026-07-28
AI Technical Summary
Abnormal data transmission between different business systems within the banking system can lead to inconsistencies in accounts. Manual verification is inefficient and inaccurate, potentially resulting in economic losses.
The system retrieves the target sub-account information and general ledger information from the transaction system, calculates the total balance, and verifies it to ensure consistency between the general ledger information and the period-end account information, generating anomaly alarm information.
It enables rapid and accurate verification of data consistency between systems, ensuring the consistency and accuracy of accounts between the transaction system and the general ledger system, and reducing the workload and error rate of manual verification.
Smart Images

Figure CN117350839B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of financial technology, and more specifically, to a method, apparatus, storage medium, and electronic device for reconciling accounts. Background Technology
[0002] In a banking system, each business can have a corresponding business system. Each business system stores all transaction information for that business system. When conducting overall banking business statistics and organization, it is also necessary to store the transaction information of each business in the general ledger system to generate the entire bank's accounting information.
[0003] However, when transaction information interacts between multiple systems, anomalies may occur during data transmission, leading to inconsistencies in the shared data stored in different systems. This can cause errors in the bank's fund statistics and accounting. To ensure the accuracy of bank transaction records and thus the correctness of bank asset accounts, it is necessary to reconcile the accounting information in each business system with the corresponding accounting information in the general ledger system. This ensures consistency between the accounts in the business systems and the general ledger system. Account reconciliation typically requires regular manual checks of key data by staff. However, manual checks reduce staff efficiency and have a lower accuracy rate, potentially leading to unnecessary financial losses for the bank if errors occur.
[0004] There is currently no effective solution to the problem of low efficiency and accuracy in manually verifying data consistency between systems in related technologies. Summary of the Invention
[0005] This application provides a method, apparatus, storage medium, and electronic device for verifying accounts, in order to solve the problem of low efficiency and accuracy in verifying the consistency of data between systems through manual checks in related technologies.
[0006] According to one aspect of this application, an account reconciliation method is provided. The method includes: a reconciliation system acquiring target sub-account information from a transaction system and acquiring general ledger information from the transaction system, wherein the target sub-account information includes the account balances of each debit note, and the general ledger information is the general ledger information of all debit notes, containing at least a general ledger balance; the reconciliation system calculating the total amount of the account balances of all debit notes in the target sub-account information to obtain the total balance of all debit notes; the reconciliation system reconciling the general ledger balance with the total balance of all debit notes; if the general ledger balance and the total balance of all debit notes are the same, the reconciliation system acquiring period-end account information from the general ledger system and reconciling the period-end balance in the period-end account information with the general ledger balance to obtain a first reconciliation result.
[0007] Optionally, the general ledger information also includes: the first transaction amount and the number of first transactions for all promissory notes within a preset period. Before obtaining the general ledger information from the transaction system, the method further includes: verifying the journal entry information within a preset period determined by the system, wherein the journal entry information includes multiple transaction account information, which is used to record account changes that occur in the transaction system; counting the number of transaction account information in the journal entry information to obtain the number of first transactions; calculating the total transaction volume of all transaction account information in the journal entry information to obtain the first transaction amount; adding the first transaction amount to the initial account balance to obtain the total ledger balance; and determining the number of first transactions, the first transaction amount, and the total ledger balance as the general ledger information.
[0008] Optionally, before obtaining the target sub-account information in the transaction system, the method further includes: verifying the journal entry information within a preset period determined by the system, wherein the journal entry information includes multiple transaction account information, which is used to record account changes that occur in the transaction system; classifying the multiple transaction account information in the journal entry information according to the account type to obtain multiple sets of transaction account information; and adding each set of transaction account information to the initial sub-account information of the corresponding account type to obtain the target sub-account information.
[0009] Optionally, calculating the total balance of all debit notes in the target sub-account information to obtain the total balance of the target sub-account information includes: calculating the total balance in each group of transaction account information, and adding the total balances in all groups of transaction account information to obtain the total balance of the target sub-account information.
[0010] Optionally, after the verification system verifies the total account balance in the general ledger information with the total balance of the target sub-account information to obtain the first verification result, the method further includes: if the general ledger balance and the total balance are different, determining that an anomaly has occurred in the transaction system and generating an alarm message for the transaction system.
[0011] Optionally, after verifying the ending balance in the period-end account information with the general ledger balance to obtain the first verification result, the method further includes: the transaction system determining whether the second verification result is abnormal, wherein the abnormality of the second verification result indicates that the general ledger information and the general ledger information are different; if the second verification result is abnormal, it is determined that an anomaly has occurred in the general ledger system, and an alarm message for the general ledger system is generated.
[0012] Optionally, the period-end account information also includes: the second transaction amount and the second transaction number of all debit notes within the preset period. After reconciling the period-end balance in the period-end account information with the total account balance to obtain the first reconciliation result, the method further includes: reconciling the first transaction amount and the second transaction amount to obtain the second reconciliation result; reconciling the first transaction number and the second transaction number to obtain the third reconciliation result; and combining the first reconciliation result, the second reconciliation result, and the third reconciliation result to obtain the reconciliation result of the period-end balance and the total account balance.
[0013] According to another aspect of this application, an account reconciliation apparatus is provided. The apparatus includes: an acquisition unit, configured to acquire target sub-account information from a transaction system and acquire general ledger information from the transaction system via a reconciliation system, wherein the target sub-account information includes the account balances of each debit note, and the general ledger information is the general ledger information of all debit notes, and the general ledger information includes at least the general ledger balance; a first calculation unit, configured to calculate the total account balances of all debit notes in the target sub-account information via the reconciliation system to obtain the total balance of all debit notes; a first reconciliation unit, configured to reconcile the general ledger balance with the total balance of all debit notes via the reconciliation system; and a second reconciliation unit, configured to, when the general ledger balance and the total balance of all debit notes are the same, acquire period-end account information from the general ledger system via the reconciliation system and reconcile the period-end balance in the period-end account information with the general ledger balance to obtain a first reconciliation result.
[0014] According to another aspect of the present invention, a computer storage medium is also provided for storing a program, wherein the program, when running, controls the device where the computer storage medium is located to perform an account reconciliation method.
[0015] According to another aspect of the present invention, an electronic device is also provided, comprising one or more processors and a memory; the memory stores computer-readable instructions, and the processor is configured to execute the computer-readable instructions, wherein the computer-readable instructions, when executed, perform an account reconciliation method.
[0016] This application employs the following steps: The verification system obtains the target sub-account account information from the transaction system and the general ledger information from the transaction system. The target sub-account account information includes the account balances of each debit note, and the general ledger information is the total account information for all debit notes, containing at least the total account balance. The verification system calculates the total account balance of all debit notes in the target sub-account account information to obtain the total balance of all debit notes. The verification system reconciles the total account balance with the total balance of all debit notes. If the total account balance and the total balance of all debit notes are the same, the verification system obtains the period-end account information from the general ledger system and reconciles the period-end balance in the period-end account information with the total account balance to obtain the first verification result. This solves the problem of low efficiency and accuracy in manually checking the consistency of data between systems in related technologies. By verifying the total balance within the transaction system, the accuracy of the general ledger information is ensured. The general ledger information is then reconciled with the period-end ledger information, thereby guaranteeing the consistency and accuracy of the accounts in the transaction system and the general ledger system. This achieves the effect of quickly and accurately verifying whether the data between the systems are the same. Attached Figure Description
[0017] The accompanying drawings, which form part of this application, are used to provide a further understanding of this application. The illustrative embodiments and descriptions of this application are used to explain this application and do not constitute an undue limitation of this application. In the drawings:
[0018] Figure 1 This is a flowchart of the account reconciliation method provided according to the embodiments of this application;
[0019] Figure 2 This is a flowchart of an optional account reconciliation method provided according to an embodiment of this application;
[0020] Figure 3 This is a schematic diagram of an account reconciliation device provided according to an embodiment of this application. Detailed Implementation
[0021] It should be noted that, unless otherwise specified, the embodiments and features described in this application can be combined with each other. This application will now be described in detail with reference to the accompanying drawings and embodiments.
[0022] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort should fall within the scope of protection of the present application.
[0023] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate for the embodiments of this application described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.
[0024] It should be noted that all information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for display, data used for analysis, etc.) involved in this disclosure are information and data authorized by the user or fully authorized by all parties. For example, this system has an interface with relevant users or organizations. Before obtaining relevant information, it is necessary to send an acquisition request to the aforementioned user or organization through the interface, and obtain the relevant information after receiving consent information from the aforementioned user or organization.
[0025] It should be noted that the account reconciliation methods, devices, storage media and electronic devices defined in this disclosure can be used in the financial technology field, or in any field other than the financial technology field. The application fields of the account reconciliation methods, devices, storage media and electronic devices defined in this disclosure are not limited.
[0026] According to an embodiment of this application, an account reconciliation method is provided.
[0027] Figure 1 This is a flowchart of an account reconciliation method provided according to an embodiment of this application. For example... Figure 1 As shown, the method includes the following steps:
[0028] Step S102: Verify the target sub-account information obtained from the transaction system and obtain the total account information from the transaction system. The target sub-account information includes the account balance of each debit note, and the total account information is the total account information of all debit notes. The total account information includes at least the total account balance.
[0029] Specifically, the verification system can be used to verify large amounts of data to determine whether the data in multiple systems are completely identical. The target account information can be the sum of all the loan information in the transaction system and classified according to accounting subjects. For example, the debit balance in the principal account of loan A is A1, the credit balance in the interest account of loan A is A2, etc. Therefore, the target account information can store the current account balance and debit / credit direction of all the loan information in the transaction system.
[0030] To obtain accurate target account information, optionally, in the account verification method provided in this application embodiment, before obtaining the target account information in the transaction system, the method further includes: verifying the journal entry information within a preset period determined by the system, wherein the journal entry information includes multiple transaction account information, which is used to record account changes that occur in the transaction system; classifying the multiple transaction account information in the journal entry information according to the account type to obtain multiple sets of transaction account information; and adding each set of transaction account information to the initial account information of the corresponding account type to obtain the target account information.
[0031] Specifically, the preset period can be a full day, and the journal entries within that period can be all the debit card information for that day. The journal entries can be the occurrence information of the debit cards; that is, when a debit card is generated in the transaction system, a new debit card occurrence record, i.e., transaction account information, will be added to the journal entries. Each account information corresponds to a different accounting subject for the debit card. Therefore, when adding journal entries to the target sub-account information, multiple debit cards need to be categorized according to their accounting subjects to obtain multiple sets of debit cards, i.e., multiple sets of transaction account information. The debit cards are then added to the corresponding storage location in the target sub-account information according to the accounting subject of each set.
[0032] For example, when adding a loan receipt to the target account's ledger information, it needs to be added to the loan column of the target account's ledger information to ensure data consistency when calculating the total amount of the account.
[0033] To accurately determine the general ledger information, optionally, in the account reconciliation method provided in this application embodiment, the general ledger information further includes: the first transaction amount and the number of first transactions for all promissory notes within a preset period. Before obtaining the general ledger information in the transaction system, the method further includes: verifying the journal entry information within a preset period determined by the system, wherein the journal entry information includes multiple transaction account information, and the transaction account information is used to record account changes that occur in the transaction system; counting the number of transaction account information in the journal entry information to obtain the number of first transactions; calculating the total transaction volume of all transaction account information in the journal entry information to obtain the first transaction amount; adding the first transaction amount to the initial account balance to obtain the total ledger balance; and determining the number of first transactions, the first transaction amount, and the total ledger balance as the general ledger information.
[0034] Specifically, the preset period can be a full day, and the journal entries within the preset period can be all the loan receipts for that day. The total amount of all loan receipts for that day can be used as the number of transactions for the first transaction, and the total transaction amount for that day, i.e., the debit and credit balances for that day, can be used as the amount of the first transaction. The debit and credit balances for that day are then added to the total balance calculated from the previous day to obtain the total balance for that day. Thus, the number of transactions for the first transaction, the amount of the first transaction, and the total balance can be used to determine the total ledger information.
[0035] Step S104: Verify the total balance of all debit notes in the target account information calculated by the system to obtain the total balance of all debit notes.
[0036] Optionally, in the account reconciliation method provided in this application embodiment, calculating the total balance of all debit notes in the target sub-account account information to obtain the total balance of the target sub-account account information includes: calculating the total balance in each group of transaction account information, and adding the total balances in all groups of transaction account information to obtain the total balance of the target sub-account account information.
[0037] Specifically, after obtaining the debit information for each accounting subject, the debit balance and credit balance corresponding to each accounting subject can be calculated, and the debit balances corresponding to each accounting subject can be summed to obtain the debit balance of all debits. Similarly, the credit balances corresponding to each accounting subject can be summed to obtain the credit balance of all debits. The total balance of the debit and credit balances of all debits is determined as the total balance of the target sub-account information.
[0038] Furthermore, the transaction system also includes general ledger information, which includes the first transaction amount and number of first transactions for all debit notes within a preset period, as well as the general ledger balance. Specifically, by account, date, and institution, the details of debit notes within a preset period (e.g., the current day) are summarized to obtain the total debit and credit amounts, as well as the number of debit and credit transactions. Simultaneously, yesterday's debit balance plus today's debit amount equals today's debit balance, and yesterday's credit balance plus today's credit amount equals today's credit balance, thus obtaining the general ledger balance.
[0039] Step S106: The verification system reconciles the total account balance with the total balance of all debit notes.
[0040] Specifically, after obtaining the total balance of all debit notes through the target account information and the total account balance through the general account information, the total balance can be compared with the debit balance in the general account balance, and the credit balance can also be compared. If the debit balance and the credit balance are the same, it can be determined that the accounting statistics in the transaction system are correct. If one or two of the debit balance and the credit balance are different after verification, it is considered that there is an anomaly in the transaction system.
[0041] Optionally, in the account reconciliation method provided in this application embodiment, after the reconciliation system reconciles the total account balance in the general account information with the total balance of the target sub-account information to obtain the first reconciliation result, the method further includes: if the general account balance and the total balance are different, determining that an anomaly has occurred in the transaction system and generating alarm information for the transaction system.
[0042] Specifically, in the event of an anomaly within the trading system, alarm information indicating an anomaly can be displayed to operations and maintenance personnel, showing whether the debit or credit balance is abnormal. This allows operations and maintenance personnel to accurately pinpoint the location of the anomaly and promptly perform data verification to identify the abnormal transaction.
[0043] Step S108: If the general ledger balance and the total balance of all debit notes are the same, the verification system obtains the period-end account information from the general ledger system and verifies the period-end balance in the period-end account information with the general ledger balance to obtain the first verification result.
[0044] Specifically, if the general ledger balance and the total balance of all debit notes are the same, it indicates that the internal accounts of the transaction system are correct. In this case, the general ledger information of the transaction system can be compared with the period-end account information in the general ledger system to obtain the comparison result.
[0045] It should be noted that the period-end account information in the general ledger system can be the sum of the period-end account information of the previous day and the new account information added today. The new account information added today can be obtained from the journal entry information in the transaction system. The journal entry information can be added to the period-end account information of the previous day to obtain the period-end account information of today.
[0046] After obtaining the period-end accounting information, the period-end balance in the period-end accounting information can be reconciled with the general ledger balance. This includes comparing the period-end credit balance with the credit balance in the general ledger information, as well as comparing the period-end debit balance with the debit balance in the general ledger information, in order to determine whether there are any abnormalities in the accounts of the general ledger system and the transaction system.
[0047] To improve the accuracy of the verification results, optionally, in the account verification method provided in this application embodiment, the period-end account information further includes: the second transaction amount and the second transaction number of all borrowers within a preset period. After verifying the period-end balance in the period-end account information with the total account balance to obtain a first verification result, the method further includes: verifying the first transaction amount and the second transaction amount to obtain a second verification result; verifying the first transaction number and the second transaction number to obtain a third verification result; and combining the first verification result, the second verification result, and the third verification result to obtain the verification result of the period-end balance and the total account balance.
[0048] Specifically, the end-of-period account information also includes: the second transaction amount and the number of second transactions for all debit notes within the preset period. After comparing the total balance, the first transaction amount and the second transaction amount can also be compared, as well as the first transaction number and the second transaction number, thereby ensuring that the daily journal entries are consistent in the two systems, thus ensuring the consistency of information between the transaction system and the general ledger system.
[0049] The account reconciliation method provided in this application embodiment obtains target sub-account account information and general ledger information from the transaction system through a reconciliation system. The target sub-account account information includes the account balances of each debit note, and the general ledger information includes the total account balance of all debit notes, at least containing the total account balance. The reconciliation system calculates the total account balance of all debit notes in the target sub-account account information to obtain the total account balance of all debit notes. The reconciliation system reconciles the total account balance with the total account balance of all debit notes. If the total account balance and the total account balance are the same, the reconciliation system obtains the period-end account information from the general ledger system and reconciles the period-end balance in the period-end account information with the total account balance to obtain a first reconciliation result. This solves the problem of low efficiency and accuracy in manually checking the consistency of data between systems in related technologies. By verifying the total balance within the transaction system, the accuracy of the general ledger information is ensured. The general ledger information is then reconciled with the period-end ledger information, thereby guaranteeing the consistency and accuracy of the accounts in the transaction system and the general ledger system. This achieves the effect of quickly and accurately verifying whether the data between the systems are the same.
[0050] Optionally, in the account reconciliation method provided in this application embodiment, after reconciling the ending balance in the ending account information with the general ledger balance to obtain a first reconciliation result, the method further includes: the transaction system determining whether the second reconciliation result is abnormal, wherein the abnormality of the second reconciliation result indicates that the general ledger information and the general ledger information are different; if the second reconciliation result is abnormal, it is determined that the general ledger system has an abnormality and an alarm message for the general ledger system is generated.
[0051] Specifically, since the first verification result is confirmed to be correct when the second verification result is obtained, the general ledger information provided by the transaction system can be guaranteed to be accurate. Therefore, if the second verification result is abnormal, it can be determined that there is an anomaly in the period-end ledger information in the general ledger system. Thus, an alarm message indicating an anomaly in the general ledger system can be displayed to the maintenance personnel, showing whether the debit balance or credit balance is abnormal, or whether the amount or number of the second transaction is abnormal. This allows the maintenance personnel to accurately determine the point of anomaly and promptly perform data verification to identify the abnormal transaction.
[0052] Figure 2 This is a flowchart of an optional account reconciliation method provided according to an embodiment of this application, such as... Figure 2 As shown, the journal entry information is first added to the target sub-account information in real time according to the update of the loan receipts, and then all the journal entry information for the day is added to the general ledger information at the end of the day.
[0053] Furthermore, the general ledger balance is first reconciled with the total balance of all promissory notes to obtain the first reconciliation result. If the total balance and the general ledger balance are the same, it is determined that there is no abnormality in the transaction system. Then, the general ledger information is compared with the ending balance information. The ending balance information is the account information obtained by consolidating the beginning balance information with the journal entries of the day. If the comparison result between the general ledger information and the ending balance information is normal, it is determined that there is no abnormality in the accounts.
[0054] It should be noted that if an anomaly is found when reconciling the general ledger balance with the total balance of all promissory notes, it indicates an accounting error in the transaction system, and the transaction system will issue an alarm. Similarly, if an anomaly is found when reconciling the general ledger information with the period-end balance information, it indicates an accounting error in the general ledger system, and the general ledger system will issue an alarm. This allows for accurate identification of the anomaly points, thereby solving the problem of low efficiency and accuracy in manually checking the consistency of data between systems in related technologies.
[0055] It should be noted that the steps shown in the flowchart in the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although a logical order is shown in the flowchart, in some cases the steps shown or described may be executed in a different order than that shown here.
[0056] This application also provides an account reconciliation device. It should be noted that the account reconciliation device of this application can be used to execute the account reconciliation method provided in this application. The account reconciliation device provided in this application is described below.
[0057] Figure 3 This is a schematic diagram of an account reconciliation device provided according to an embodiment of this application. For example... Figure 3 As shown, the device includes: an acquisition unit 31, a first calculation unit 32, a first verification unit 33, and a second verification unit 34.
[0058] The acquisition unit 31 is used to acquire the target sub-account information in the transaction system through the verification system and to acquire the total account information in the transaction system. The target sub-account information includes the account balance of each debit note, and the total account information is the total account information of all debit notes. The total account information includes at least the total account balance.
[0059] The first calculation unit 32 is used to calculate the total balance of all debit cards in the target account information by verifying the system, and to obtain the total balance of all debit cards.
[0060] The first verification unit 33 is used to verify the total account balance and the total balance of all debit notes through the verification system.
[0061] The second verification unit 34 is used to verify the period-end account information in the general ledger system when the general ledger balance and the total balance of all debit notes are the same, and to verify the period-end balance in the period-end account information with the general ledger balance to obtain the first verification result.
[0062] The account reconciliation device provided in this application embodiment includes an acquisition unit 31, which acquires target sub-account information and total account information from the transaction system through a reconciliation system. The target sub-account information includes the account balances of each loan receipt, and the total account information includes the total account information of all loan receipts, containing at least the total account balance. A first calculation unit 32 calculates the total account balances of all loan receipts in the target sub-account information through the reconciliation system to obtain the total account balance of all loan receipts. A first reconciliation unit 33 reconciles the total account balance with the total account balance of all loan receipts through the reconciliation system. A second reconciliation unit 34, when the total account balance and the total account balance are the same, acquires the period-end account information from the general ledger system and reconciles the period-end balance in the period-end account information with the total account balance to obtain a first reconciliation result. This solves the problem of low efficiency and accuracy in manually checking the consistency of data between systems in related technologies. By verifying the total balance within the transaction system, the accuracy of the general ledger information is ensured. The general ledger information is then reconciled with the period-end ledger information, thereby guaranteeing the consistency and accuracy of the accounts in the transaction system and the general ledger system. This achieves the effect of quickly and accurately verifying whether the data between the systems are the same.
[0063] Optionally, in the account reconciliation device provided in this application embodiment, the total account information further includes: the first transaction amount and the number of first transactions for all IOUs within a preset period. Before obtaining the total account information in the transaction system, the device further includes: a third reconciliation unit, used to reconcile the journal entry information within a preset period determined by the system, wherein the journal entry information includes multiple transaction account information, and the transaction account information is used to record account changes that occur in the transaction system; a statistics unit, used to count the number of transaction account information in the journal entry information to obtain the number of first transactions; a second calculation unit, used to calculate the total transaction volume of all transaction account information in the journal entry information to obtain the first transaction amount; a third calculation unit, used to add the first transaction amount to the initial account balance to obtain the total account balance; and a first determination unit, used to determine the number of first transactions, the first transaction amount, and the total account balance as the total account information.
[0064] Optionally, in the account reconciliation device provided in this application embodiment, before obtaining the target sub-account information in the transaction system, the device further includes: a fourth reconciliation unit, used to reconcile the journal entry information within a preset period determined by the system, wherein the journal entry information includes multiple transaction account information, and the transaction account information is used to record account changes that occur in the transaction system; a classification unit, used to classify the multiple transaction account information in the journal entry information according to the account type to obtain multiple sets of transaction account information; and an adding unit, used to add each set of transaction account information to the initial sub-account information of the corresponding account type to obtain the target sub-account information.
[0065] Optionally, in the account reconciliation device provided in this application embodiment, the first calculation unit 32 includes: a calculation module, used to calculate the total balance in each group of transaction account information, and to add the total balance in all groups of transaction account information to obtain the total balance of the target sub-account account information.
[0066] Optionally, in the account reconciliation device provided in this application embodiment, after the reconciliation system reconciles the total account balance in the general account information with the total balance of the target sub-account account information to obtain the first reconciliation result, the device further includes: a second determining unit, used to determine that an anomaly has occurred in the transaction system when the general account balance and the total balance are different, and to generate an alarm message for the transaction system.
[0067] Optionally, in the account reconciliation device provided in this application embodiment, after reconciling the ending balance in the ending account information with the total account balance to obtain a first reconciliation result, the device further includes: a judgment unit, used by the transaction system to judge whether the second reconciliation result is abnormal, wherein the abnormality of the second reconciliation result indicates that the total account information and the total account information are different; and a third determination unit, used to determine that an abnormality has occurred in the general ledger system when the second reconciliation result is abnormal, and to generate alarm information for the general ledger system.
[0068] Optionally, in the account reconciliation device provided in this application embodiment, the period-end account information further includes: the second transaction amount and the second transaction number of all IOUs within a preset period. After reconciling the period-end balance in the period-end account information with the total account balance to obtain a first reconciliation result, the device further includes: a fifth reconciliation unit, used to reconcile the first transaction amount and the second transaction amount to obtain a second reconciliation result; a sixth reconciliation unit, used to reconcile the first transaction number and the second transaction number to obtain a third reconciliation result; and a combination unit, used to combine the first reconciliation result, the second reconciliation result, and the third reconciliation result into a reconciliation result of the period-end balance and the total account balance.
[0069] The aforementioned account reconciliation device includes a processor and a memory. The aforementioned acquisition unit 31, first calculation unit 32, first verification unit 33, second verification unit 34, etc., are all stored in the memory as program units. The processor executes the aforementioned program units stored in the memory to realize the corresponding functions.
[0070] The processor contains a kernel, which retrieves the corresponding program units from memory. One or more kernels can be configured, and adjusting kernel parameters can address the low efficiency and accuracy issues in manual data consistency checks between systems in related technologies.
[0071] The memory may include non-permanent memory in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM, and the memory includes at least one memory chip.
[0072] This invention provides a computer-readable storage medium having a program stored thereon, which, when executed by a processor, implements the account reconciliation method.
[0073] This invention provides a processor for running a program, wherein the program executes the account reconciliation method during runtime.
[0074] This invention provides an electronic device, including a processor, a memory, and a program stored in the memory and executable on the processor. When the processor executes the program, it performs the following steps: A verification system obtains target sub-account information from a transaction system and obtains general ledger information from the transaction system. The target sub-account information includes the account balances of each debit note, and the general ledger information is the total account information of all debit notes, containing at least the total account balance. The verification system calculates the total account balances of all debit notes in the target sub-account information to obtain the total account balance of all debit notes. The verification system reconciles the total account balance with the total account balance of all debit notes. If the total account balance and the total account balance are the same, the verification system obtains the period-end account information from the general ledger system and reconciles the period-end balance in the period-end account information with the total account balance to obtain a first verification result. The device described herein can be a server, PC, PAD, mobile phone, etc.
[0075] This application also provides a computer program product, which, when executed on a data processing device, is suitable for executing an initialization program with the following method steps: A verification system obtains target sub-account information from a transaction system and obtains general ledger information from the transaction system, wherein the target sub-account information includes the account balances of each debit note, and the general ledger information is the total account information of all debit notes, which at least includes the total account balance; the verification system calculates the total amount of the account balances of all debit notes in the target sub-account information to obtain the total balance of all debit notes; the verification system verifies the total account balance and the total balance of all debit notes; if the total account balance and the total balance of all debit notes are the same, the verification system obtains the period-end account information from the general ledger system and verifies the period-end balance in the period-end account information with the total account balance to obtain a first verification result.
[0076] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can 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, etc.) containing computer-usable program code.
[0077] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can 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, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0078] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0079] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.
[0080] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0081] Memory may include non-persistent memory in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of computer-readable media.
[0082] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can store information using any method or technology. Information can be computer-readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transferable medium that can be used to store information accessible by a computing device. As defined herein, computer-readable media does not include transient computer-readable media, such as modulated data signals and carrier waves.
[0083] It should also be noted that the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article, or apparatus. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element.
[0084] The above are merely embodiments of this application and are not intended to limit the scope of this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the scope of the claims of this application.
Claims
1. A method for reconciling accounts, characterized in that, include: The verification system obtains the target sub-account account information from the transaction system and obtains the total account information from the transaction system. The target sub-account account information includes the account balance of each loan receipt, and the total account information is the total account information of all the loan receipts. The total account information includes at least the total account balance. The verification system calculates the total balance of all debit notes in the target account information to obtain the total balance of all debit notes; The reconciliation system reconciles the total account balance with the total balance of all the loan receipts; When the total ledger balance and the total balance of all the promissory notes are the same, the verification system obtains the period-end account information in the general ledger system and verifies the period-end balance in the period-end account information with the total ledger balance to obtain a first verification result. The period-end account information in the general ledger system includes: the sum of the period-end account information of the previous day and the account information added today. The period-end account information also includes: the second transaction amount and the second transaction number of all IOUs within a preset period. After reconciling the period-end balance in the period-end account information with the total account balance to obtain a first reconciliation result, the method further includes: reconciling the first transaction amount and the second transaction amount to obtain a second reconciliation result; reconciling the first transaction number and the second transaction number to obtain a third reconciliation result; and combining the first reconciliation result, the second reconciliation result, and the third reconciliation result into a reconciliation result of the period-end balance and the total account balance.
2. The method according to claim 1, characterized in that, The general ledger information also includes: the first transaction amount and the number of first transactions for all promissory notes within a preset period. Before obtaining the general ledger information from the transaction system, the method further includes: The verification system determines the journal entry information within the preset period, wherein the journal entry information includes multiple transaction account information, and the transaction account information is used to record account changes that occur in the transaction system; The number of transaction entries in the journal entries is counted to obtain the number of the first transaction. Calculate the total transaction volume of all transaction entries in the journal entry information to obtain the first transaction amount; The total account balance is obtained by adding the amount of the first transaction to the initial account balance. The number of the first transactions, the amount of the first transactions, and the total account balance are determined as the total account information.
3. The method according to claim 1, characterized in that, Before obtaining the target sub-account information from the transaction system, the method further includes: The verification system determines the journal entries within a preset period, wherein the journal entries include multiple transaction records, and the transaction records are used to record changes to the accounts that occur in the transaction system. The multiple transaction account information in the journal entries are classified according to the account type to obtain multiple sets of transaction account information; Each group of transaction account information is added to the initial sub-account account information of the corresponding account type to obtain the target sub-account account information.
4. The method according to claim 3, characterized in that, Calculate the total balance of all the debit notes in the target sub-account's account information to obtain the total balance of the target sub-account's account information, which includes: Calculate the total balance in each group of transaction account information, and sum the total balances in all groups of transaction account information to obtain the total balance of the target sub-account account information.
5. The method according to claim 1, characterized in that, After the verification system reconciles the total account balance in the general ledger information with the total balance of the target sub-account information to obtain a first verification result, the method further includes: If the total account balance and the total balance are not the same, it is determined that the transaction system has malfunctioned, and an alarm message for the transaction system is generated.
6. The method according to claim 1, characterized in that, After reconciling the ending balance in the period-end account information with the total account balance to obtain a first reconciliation result, the method further includes: The transaction system determines whether the second verification result is abnormal, wherein the abnormality of the second verification result indicates that the general ledger information and the general ledger information are different; If the second verification result is abnormal, it is determined that the general ledger system has malfunctioned, and an alarm message for the general ledger system is generated.
7. An account reconciliation device, characterized in that, include: The acquisition unit is used to acquire target sub-account information in the transaction system through the verification system, and to acquire total account information in the transaction system. The target sub-account information includes the account balance of each loan receipt, and the total account information is the total account information of all the loan receipts. The total account information includes at least the total account balance. The first calculation unit is used to calculate the total balance of all debit notes in the target sub-account accounting information through the verification system, so as to obtain the total balance of all debit notes; The first verification unit is used to verify the total account balance and the total balance of all the loan receipts through the verification system; The second verification unit is used to, when the total ledger balance and the total balance of all the loan receipts are the same, obtain the period-end account information in the general ledger system and verify the period-end balance in the period-end account information with the total ledger balance to obtain a first verification result. The period-end account information in the general ledger system includes: the sum of the period-end account information of the previous day and the account information added today. The period-end account information also includes: the second transaction amount and the second transaction number of all IOUs within a preset period. After verifying the period-end balance in the period-end account information with the total account balance to obtain a first verification result, the verification device further includes: a fifth verification unit for verifying the first transaction amount and the second transaction amount to obtain a second verification result; a sixth verification unit for verifying the first transaction number and the second transaction number to obtain a third verification result; and a combination unit for combining the first verification result, the second verification result, and the third verification result into a verification result of the period-end balance and the total account balance.
8. A computer storage medium, characterized in that, The computer storage medium is used to store a program, wherein the program, when running, controls the device where the computer storage medium is located to execute the account reconciliation method according to any one of claims 1 to 6.
9. An electronic device, characterized in that, It includes one or more processors and a memory, the memory being used to store one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors cause the one or more processors to implement the account reconciliation method of any one of claims 1 to 6.