CN114581064A

CN114581064A - Automatic checking method, device, electronic equipment, medium and computer program product

Info

Publication number: CN114581064A
Application number: CN202210266668.5A
Authority: CN
Inventors: 王诗章; 郭丽; 杨柳; 杨冰寒
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2022-03-17
Filing date: 2022-03-17
Publication date: 2022-06-03

Abstract

The present disclosure provides a method, an apparatus, an electronic device, a medium, and a computer program product for automatic checking of a posted account. The method and the device can be used in the technical field of artificial intelligence. The automatic checking method of the account hanging comprises the following steps: acquiring data information of the account hanging file; analyzing data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first party account records and n second party account records; according to the m first side account records and the n second side account records, r first side account records capable of realizing the tie-out in the m first side account records are determined to be used as first target account records, and k second side account records capable of realizing the tie-out in the n second side account records are determined to be used as second target account records; and outputting the first target account book and the second target account book to the associated data processing system.

Description

Automatic collation method, apparatus, electronic device, medium, and computer program product

Technical Field

The present disclosure relates to the field of artificial intelligence technologies, and in particular, to an automatic checking method and apparatus for an account, an electronic device, a medium, and a computer program product.

Background

The daily final account is the most core content of the accounting system in the bank field, in order to know the daily account processing condition in time and discover the account problem, the accounting final batch provides the account checking function of the whole core host, and generates a complete account hanging list aiming at the daily account data. The method is classified according to the reason of generating the account hanging, and the types of the daily and final account hanging can be divided into four types, namely machine account hanging, active account hanging, self-balancing account hanging and general account dividing. Machine account hanging is a type of account hanging with complex business situation and difficult positioning of specific reasons in daily terminal account hanging.

The machine account-checking refers to the step of gathering and checking all transactions of a network point, and after the lender is found to be uneven, the batch program carries out account-checking of the difference. The daily end system performs trial balance by taking an accounting network as a dimensionality, generates a hanging account and accounts into a machine hanging account of the network when the amount of a borrower of the network is not equal to the amount of the lender according to the principle that the borrower has enough credit and the borrower has enough balance, and automatically scans all suspicious transactions possibly damaging the trial balance under the network and forms a corresponding machine hanging account list. The common reasons for generating machine account checking include unilateral operation of business, abnormal state of parameters or clients, program problems, etc. The transaction causing machine posting cannot be found manually and requires a separate batch procedure to locate.

Disclosure of Invention

In view of the above, the present disclosure provides a high-accuracy and efficient automatic checking method and apparatus for account posting, an electronic device, a computer-readable storage medium, and a computer program product.

One aspect of the present disclosure provides an automatic checking method of a posted account, including: acquiring data information of the account hanging file; analyzing the data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first party account records and n second party account records, and m and n are integers more than or equal to 1; according to the m first side account records and the n second side account records, determining r first side account records capable of realizing the balance in the m first side account records as first target account records, and determining k second side account records capable of realizing the balance in the n second side account records as second target account records, wherein r and k are integers more than or equal to 0; and outputting the first target account book and the second target account book to an associated data processing system.

According to the automatic checking method of the account hanging, m first party account hanging records and n second party account hanging records are obtained by analyzing the data information of the account hanging file, and then r first party account hanging records capable of realizing the account hanging in the m first party account hanging records are determined to be used as first target account hanging records, k second party account hanging records capable of realizing the account hanging in the n second party account hanging records are determined to be used as second target account hanging records, so that the transaction rolling difference analysis can be carried out on the machine account hanging transaction, and compared with the prior art which relies on a manual transaction rolling difference analysis, the accuracy is greatly improved.

In addition, the first target account hanging record and the second target account hanging record are output to the associated data processing system, the problems that in the prior art, after the host is downloaded in daily end batch, manual processing is relied on for tabulation, account hanging data are distributed to corresponding responsible persons, timeliness is poor and the like are solved, the account hanging records which can possibly achieve account balancing can be automatically distributed to relevant business personnel, reference is provided for the business personnel, the first target account hanging record and the second target account hanging record are rechecked, and therefore effectiveness is greatly improved.

In some embodiments, the determining, according to the m first side account records and the n second side account records, r first side account records of the m first side account records, which can achieve tie-out, as first target account records, and k second side account records of the n second side account records, which can achieve tie-out, as second target account records, specifically includes: adding, arranging and combining the m first party account records; adding, arranging and combining the n second party account records; determining the arrangement and combination condition that the sum of the m first party account records and the n second party account records is equal; taking the r first party account records involved in the arrangement and combination condition with equal summation as a first target account record; and taking the k second party account records involved in the arrangement combination condition of the equal summation as second target account records.

In some embodiments, the m first-party billing records include debit balances and/or debit occurrences, and the n second-party billing records include credit balances and/or credit occurrences.

In some embodiments, the file valid information further comprises a transaction code, the method further comprising: acquiring storage information of a hanging account file, wherein the storage information comprises a file name and a file size; matching the transaction code with a pre-constructed uploading file information table, wherein the uploading file information table comprises the transaction code and an uploading file name corresponding to the transaction code; when the transaction codes are matched in the uploading file information table, file names which are consistent with the uploading file names corresponding to the transaction codes are determined; and when the file size corresponding to the file name is zero and the first party account register record and the second party account register record are both zero, determining that the account register reason corresponding to the transaction code is that at least part of the files are missed.

In some embodiments, the file valid information further comprises a transaction code, the method further comprising: matching the transaction code with a pre-constructed unilateral transaction configuration table; and when the transaction codes are matched in the one-side transaction configuration table, determining the account hanging reason corresponding to the transaction codes as one-side transaction account hanging.

In some embodiments, the file valid information further comprises at least one of a region, a site, a currency, and a transaction code, the method further comprising: and outputting the file valid information.

In some embodiments, the method further comprises: acquiring path information of the account hanging file; analyzing the path information according to a file division rule to obtain a source name, a natural date and a data generation date; and outputting the source name, the natural date, and the data generation date.

Another aspect of the present disclosure provides an automatic checking apparatus for a posted account, including: the acquisition module is used for executing the acquisition of the data information of the account hanging file; the analysis module is used for analyzing the data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first party account records and n second party account records, and m and n are integers greater than or equal to 1; a determining module, configured to perform, according to the m first party account records and the n second party account records, determining, as a first target account record, r first party account records that can achieve tie account in the m first party account records, and determining, as a second target account record, k second party account records that can achieve tie account in the n second party account records, where r and k are integers greater than or equal to 0; and the output module is used for outputting the first target account book and the second target account book to an associated data processing system.

Another aspect of the present disclosure provides an electronic device comprising one or more processors and one or more memories, wherein the memories are configured to store executable instructions that, when executed by the processors, implement the method as described above.

Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions for implementing the method as described above when executed.

Another aspect of the disclosure provides a computer program product comprising a computer program comprising computer executable instructions for implementing the method as described above when executed.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments of the present disclosure with reference to the accompanying drawings, in which:

fig. 1 schematically illustrates an exemplary system architecture to which the methods, apparatus, and methods may be applied, in accordance with an embodiment of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a method of automatic reconciliation of posted accounts according to an embodiment of the present disclosure;

fig. 3 schematically illustrates a flowchart of determining r first side accounting records capable of realizing tie-out from m first side accounting records as first target accounting records and k second side accounting records capable of realizing tie-out from n second side accounting records as second target accounting records according to m first side accounting records and n second side accounting records according to an embodiment of the present disclosure;

FIG. 4 schematically illustrates a flow chart of a method of automatic reconciliation of posted accounts according to an embodiment of the present disclosure;

FIG. 5 schematically illustrates a flow chart of a method of automatic reconciliation of posted accounts according to an embodiment of the present disclosure;

FIG. 6 schematically illustrates a flow chart of a method of automatic reconciliation of posted accounts according to an embodiment of the present disclosure;

FIG. 7 schematically illustrates a flow chart of a method of automatic reconciliation of posted accounts according to an embodiment of the present disclosure;

fig. 8 is a block diagram schematically showing the configuration of an automatic reconciliation apparatus for posted accounts according to an embodiment of the present disclosure;

FIG. 9 schematically illustrates an overall architecture diagram of an automatic reconciliation device in accordance with an embodiment of the present disclosure;

FIG. 10 schematically illustrates a logic flow diagram for analyzing trade netting that causes uneven lending according to an embodiment of the present disclosure;

FIG. 11 schematically shows a block diagram of an electronic device according to an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.

In the technical scheme of the disclosure, the acquisition, storage, application and the like of the personal information of the related user all accord with the regulations of related laws and regulations, necessary security measures are taken, and the customs of the public order is not violated. In the technical scheme of the disclosure, the data acquisition, collection, storage, use, processing, transmission, provision, disclosure, application and other processing are all in accordance with the regulations of relevant laws and regulations, necessary security measures are taken, and the public order and good custom are not violated.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

Where a convention analogous to "A, B or at least one of C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B or C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). The terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, features defined as "first", "second", may explicitly or implicitly include one or more of the described features.

The daily final account is the most core content of the accounting system in the bank field, in order to know the daily account processing condition in time and discover the account problem, the accounting final batch provides the account checking function of the whole core host, and generates a complete account hanging list aiming at the daily account data. The method is classified according to the reason of generating account hanging, and the types of daily and final account hanging can be divided into four types, namely machine account hanging, active account hanging, self-balancing account hanging and general account uneven. Machine account hanging is a type of account hanging with complex business situation and difficult positioning of specific reasons in daily terminal account hanging.

The machine account-checking refers to the step of gathering and checking the account of all transactions of a network point, and after the lending party is found to be uneven, the batch procedure is used for carrying out account-checking on the balance. The daily end system performs trial balance by taking an accounting network as a dimensionality, generates a hanging account and accounts into a machine hanging account of the network when the amount of a borrower of the network is not equal to the amount of the lender according to the principle that the borrower has enough credit and the borrower has enough balance, and automatically scans all suspicious transactions possibly damaging the trial balance under the network and forms a corresponding machine hanging account list. The reasons for generating machine account registration generally include unilateral operation of business, abnormal state of parameters or clients, program problems, and the like. The transaction causing machine posting cannot be found manually and requires a separate batch procedure to locate.

The old process of machine account-hanging analysis has some problems in timeliness and accuracy. (1) In the aspect of timeliness, the prokaryotic convection process depends on manual processing to prepare a table after the host is downloaded in batch at the end of a day, and account hanging data are distributed to corresponding responsible persons, so that the timeliness is poor; (2) in the aspect of accuracy, when the original process carries out transaction difference analysis on machine account-hanging transactions, the transaction difference analysis is carried out in a manual mode, and the accuracy cannot be guaranteed.

Embodiments of the present disclosure provide an automatic checking method, apparatus, electronic device, computer-readable storage medium, and computer program product for posted accounts. The automatic checking method of the account hanging comprises the following steps: acquiring data information of the account hanging file; analyzing data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first party account records and n second party account records, and m and n are integers more than or equal to 1; according to the m first side account records and the n second side account records, r first side account records capable of realizing the tie-out in the m first side account records are determined to be used as first target account records, k second side account records capable of realizing the tie-out in the n second side account records are determined to be used as second target account records, wherein r and k are integers which are more than or equal to 0; and outputting the first target account book and the second target account book to the associated data processing system.

It should be noted that the automatic checking method, apparatus, electronic device, computer-readable storage medium, and computer program product for account checking according to the present disclosure may be used in the field of artificial intelligence technology, and may also be used in any field other than the field of artificial intelligence, for example, in the field of finance, and the field of the present disclosure is not limited herein.

Fig. 1 schematically illustrates an exemplary system architecture 100 of an automatic reconciliation method, apparatus, electronic device, computer-readable storage medium and computer program product, to which a posting may be applied, according to embodiments of the present disclosure. It should be noted that fig. 1 is only an example of a system architecture to which the embodiments of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, and does not mean that the embodiments of the present disclosure may not be applied to other devices, systems, environments or scenarios.

As shown in fig. 1, the system architecture 100 according to this embodiment may include

terminal devices

101, 102, 103, a network 104 and a server 105. Network 104 is the medium used to provide communication links between

terminal devices

101, 102, 103 and server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.

A user may use

terminal devices

101, 102, 103 to interact with a server 105 over a network 104 to receive or send messages or the like. The

terminal devices

101, 102, 103 may have installed thereon various communication client applications, such as shopping-like applications, web browser applications, search-like applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only).

The

terminal devices

101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (for example only) providing support for websites browsed by users using the

terminal devices

101, 102, 103. The background management server may analyze and perform other processing on the received data such as the user request, and feed back a processing result (e.g., a webpage, information, or data obtained or generated according to the user request) to the terminal device.

It should be noted that the automatic checking method for account checking provided by the embodiment of the present disclosure may be generally executed by the server 105. Accordingly, the automatic checking device for posting provided by the embodiment of the present disclosure may be generally disposed in the server 105. The automatic checking method for posting provided by the embodiment of the present disclosure may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the

terminal devices

101, 102, 103 and/or the server 105. Accordingly, the automatic checking device for checking out of account provided by the embodiment of the present disclosure may also be provided in a server or a server cluster different from the server 105 and capable of communicating with the

terminal devices

101, 102, 103 and/or the server 105.

It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The automatic checking method of the posted account according to the embodiment of the present disclosure will be described in detail below with reference to fig. 2 to 7 based on the scenario described in fig. 1.

Fig. 2 schematically shows a flowchart of an automatic reconciliation method according to an embodiment of the present disclosure.

As shown in fig. 2, the automatic reconciliation method for posting of this embodiment includes operations S210 to S240.

In operation S210, data information of a posting file is acquired. The data information may be understood as specific content information of the account hanging file, such as fields included in the file and business data under the fields.

In operation S220, the data information is analyzed according to a pre-established file organization rule to obtain effective file information, where the effective file information includes m first party posting records and n second party posting records, and m and n are integers greater than or equal to 1. The file organization rule defines field length, field meaning, field type and the like, so that fields in the data information and service data under the fields can be analyzed according to the file organization rule.

For example, fields such as the amount of the borrower, the amount of the borrower's occurrence, the amount of the lender's occurrence, and the amount of the lender's occurrence may be included in the data message. Therefore, as a possible implementation manner, the file valid information obtained by the parsing includes m first-party account records and n second-party account records, where the m first-party account records may include the debit balance and/or the debit generation amount, and the n second-party account records may include the credit balance and/or the credit generation amount. In other words, the m first party account records may be the balance of the borrower, the m first party account records may also be the amount of the borrower, and the m first party account records may also be the balance of the borrower partially, and the other part is the amount of the borrower. Similarly, the n second-party account records may be all credit balance, the n second-party account records may also be all credit generation amount, and part of the n second-party account records may also be credit balance, and the other part may be credit generation amount.

By using the debit balance and/or the debit generation amount as the first party account registration record and using the credit balance and/or the credit generation amount as the second party account registration record, it is convenient to determine r first party account registration records capable of realizing account balancing in the m first party account registration records as the first target account registration record and k second party account registration records capable of realizing account balancing in the n second party account registration records as the second target account registration record according to the m first party account registration records and the n second party account registration records in operation S230 below.

In operation S230, according to m first party account records and n second party account records, r first party account records that can achieve tie-out among the m first party account records are determined as first target account records, and k second party account records that can achieve tie-out among the n second party account records are determined as second target account records, where r and k are integers greater than or equal to 0.

As an implementable manner, as shown in fig. 3, operation S230 determines, according to m first party posting records and n second party posting records, r first party posting records that can achieve tie-out in the m first party posting records as first target posting records, and k second party posting records that can achieve tie-out in the n second party posting records as second target posting records, which specifically includes operation S231 to operation S235.

In operation S231, m first-party ledger records are subjected to addition and permutation combination. The possible permutation and combination modes in the m first-party account records can be determined, taking the first-party account record including the debit balance or the debit generation amount as an example, and then the sum of each permutation and combination can be calculated.

In operation S232, the n second party posting records are added and arranged. The possible permutation and combination modes in the n second-party account records can be determined, taking the second-party account record including the credit balance or the credit generation amount as an example, and then the sum of each permutation and combination can be calculated.

In operation S233, a permutation combination case where m first party ledger records and n second party ledger records are added and equal is determined. For example, m first party posting records are a, b, c, d, e, f, and so on; the n first party posting records are A, B, C, D, E, F, and so on. Assuming that the determined arrangement combination condition that the sum of m first party account records and n second party account records is equal is as follows: a + B ═ C + D and a + C + f ═ B + E.

In operation S234, the r first-party ledger records involved in the case of the permutation combination of which the sums are equal are taken as the first target ledger record. According to operation S233, the first target ledger records may be determined as a, b, c, and f.

In operation S235, the k second party' S posting records involved in the case of the permutation combination of which the sums are equal are taken as the second destination posting record. According to operation S233, the second target posting records may be determined as B, C, D and E.

Therefore, r first side account records capable of realizing the tie-out in the m first side account records can be determined as first target account records and k second side account records capable of realizing the tie-out in the n second side account records can be determined as second target account records according to the m first side account records and the n second side account records through the operation S231 to the operation S235.

In operation S240, the first target posting record and the second target posting record are output to the associated data processing system. It should be noted that, the associated data system may be a business system used by a business person who handles the first target account hanging record and the second target account hanging record, so that the account hanging record which may realize account balancing can be automatically distributed to the relevant business person, a reference is provided for the business person, and the first target account hanging record and the second target account hanging record are reviewed.

In some embodiments of the present disclosure, the first party posting record may further include an accounting subject corresponding to the debit balance or the debit occurrence; the second party billing record may also include accounting entries corresponding to credit balances or credit occurrences. It is to be understood that each first party posting record may correspond to an accounting subject and each second party posting record may correspond to an accounting subject. Therefore, after the first target account hanging record and the second target account hanging record are output to the associated data processing system, related business personnel can better check accounts through accounting.

According to some embodiments of the present disclosure, the file valid information may further include a transaction code, and as shown in fig. 4, the automatic reconciliation method for posting further includes operations S310 to S340.

In operation S310, storage information of the hanging account file is acquired, wherein the storage information includes a file name and a file size. It should be noted that the machine account files of the host may be sent to the designated directory of the file storage server in a transmission tool, for example, in an FTP manner, and the designated directory format of the file storage needs to be managed in a standard manner, that is, the file name of the designated directory needs to be consistent with the file name. When the account-hanging file is sent up, a file name is generated according to the name of the transmission tool, the serial number of the host system, the natural date (or the system date). Therefore, the file name and the file size of the account hanging file can be obtained after the account hanging file is uploaded.

In operation S320, the transaction code is matched with a pre-constructed upload file information table including the transaction code and the upload file name corresponding to the transaction code.

In operation S330, when the transaction code is matched in the upload file information table, a file name identical to the upload file name corresponding to the transaction code is determined. Because the data information and the storage information both belong to the same account hanging file, the transaction code analyzed through the data information corresponds to the file name.

In operation S340, when the file size corresponding to the file name is zero and both the first party posting record and the second party posting record are zero, it is determined that the posting reason corresponding to the transaction code is that at least part of the file is missed.

Through the operation S310 to the operation S340, the account hanging reason of missing at least part of the files can be conveniently and automatically positioned, so that the accounting core is automatic and intelligent to the flow; initiating technical analysis aiming at a specific business scene to realize accurate classification and deep excavation of financial risks; by means of the method, investment of account checking cost is effectively saved, and the working efficiency is improved while human resources are saved.

According to some embodiments of the present disclosure, the file valid information may further include a transaction code, and as shown in fig. 5, the automatic reconciliation method for posting further includes operation S410 and operation S420.

In operation S410, the transaction code is matched with a pre-constructed one-sided transaction configuration table.

In operation S420, when the transaction code is matched in the one-sided transaction configuration table, the posting reason corresponding to the transaction code is determined as one-sided transaction posting. Similarly, the account hanging reason of the unilateral transaction account hanging can be conveniently and automatically positioned through the operation S410 and the operation S420, so that the accounting core is automatic and intelligent to the flow; initiating technical analysis aiming at a specific business scene to realize accurate classification and deep excavation of financial risks; by means of the method, investment of account checking cost is effectively saved, human resources are saved, and meanwhile work efficiency is improved.

In some embodiments of the present disclosure, the file valid information may further include at least one of a region, a website, a currency, and a transaction code, and as shown in fig. 6, the automatic checking method for posting further includes operation S510: and outputting the file valid information. Therefore, at least one of the region, the network point, the currency and the transaction code can provide relevant reference information for relevant business personnel, and the relevant business personnel can conveniently check accounts.

In some embodiments of the present disclosure, as shown in fig. 7, the automatic reconciliation method for posting further includes operations S610 to S630.

In operation S610, path information of the posting file is acquired, wherein the path information may include, but is not limited to, a system name of a posting file source system, a data generation date, a natural date when uploading, and the like.

In operation S620, the path information is parsed according to the file division rule to obtain a source name, a natural date, and a data generation date, where the source name is also a system name of the source system of the posted file.

In operation S630, a source name, a natural date, and a data generation date are output. Therefore, the source name, the natural date and the data generation date can provide relevant reference information for relevant business personnel, and the relevant business personnel can conveniently check accounts.

Based on the automatic checking method of the account hanging, the disclosure also provides an automatic checking device 10 of the account hanging. The automatic checking apparatus 10 for posting will be described in detail below with reference to fig. 8.

Fig. 8 schematically shows a block diagram of the structure of the automatic collation apparatus 10 for posting according to the embodiment of the present disclosure.

The automatic checking device 10 for account checking includes an acquisition module 1, an analysis module 2, a determination module 3, and an output module 4.

An obtaining module 1, where the obtaining module 1 is configured to perform operation S210: and acquiring data information of the account hanging file.

The parsing module 2, the parsing module 2 is configured to perform operation S220: and analyzing the data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first side account records and n second side account records, and m and n are integers more than or equal to 1.

A determination module 3, the determination module 3 being configured to perform operation S230: according to the m first side account records and the n second side account records, r first side account records capable of realizing the tie-out in the m first side account records are determined to be used as first target account records, k second side account records capable of realizing the tie-out in the n second side account records are determined to be used as second target account records, wherein r and k are integers which are more than or equal to 0.

An output module 4, the output module 4 being configured to perform operation S240: and outputting the first target account-hanging record and the second target account-hanging record to an associated data processing system.

According to the automatic checking device for the account hanging, m first party account hanging records and n second party account hanging records are obtained by analyzing the data information of the account hanging file, and then r first party account hanging records capable of realizing the account hanging in the m first party account hanging records are determined to be used as first target account hanging records, k second party account hanging records capable of realizing the account hanging in the n second party account hanging records are determined to be used as second target account hanging records, so that the transaction rolling difference analysis can be carried out on machine account hanging transactions, and the transaction rolling difference analysis is carried out in a manual mode in comparison with the prior art, and the accuracy is greatly improved.

In addition, according to the embodiment of the present disclosure, any plurality of the obtaining module 1, the parsing module 2, the determining module 3, and the outputting module 4 may be combined and implemented in one module, or any one of the modules may be split into a plurality of modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of the other modules and implemented in one module.

According to an embodiment of the present disclosure, at least one of the obtaining module 1, the parsing module 2, the determining module 3, and the outputting module 4 may be implemented at least partially as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented by hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or may be implemented by any one of three implementations of software, hardware, and firmware, or any suitable combination of any of them.

Alternatively, at least one of the obtaining module 1, the parsing module 2, the determining module 3 and the output module 4 may be at least partially implemented as a computer program module, which when executed may perform a corresponding function.

The automatic checking apparatus for posting according to the embodiment of the present disclosure is described in detail below with reference to fig. 9 to 10. It is to be understood that the following description is illustrative only and is not intended to be in any way limiting of the present disclosure.

The automatic checking device for the hanging account mainly comprises three parts: a host file analysis unit 001, a hanging account reason positioning unit 002 and a target data import unit 003. The host file analysis unit 001 is responsible for analyzing batch account files generated by the accounting system throughout the day, importing the analyzed data and persisting the data to the local; the account hanging reason positioning unit 002 analyzes and processes specific account hanging data, and preliminarily positions account hanging reasons according to a certain algorithm rule; the target data importing unit 003 integrates the information of the fields related to the account hanging reasons on the basis of the original data fields, generates target data and writes the target data into the database. The overall architecture diagram of the automatic checking apparatus for daily end posting of the present disclosure is shown in fig. 9.

The host file analysis unit 001: the unit is responsible for analyzing machine account files generated by the accounting system in batches at the end of a day and writing original account data into a local database. The system comprises the following three processing modules: a file path analysis module 101, a file content processing module 102 and a raw data import module 103.

The file path analysis module 101: the machine account-hanging file of the host machine day end is downloaded to a specified directory of the intermediate file storage server in an FTP mode, and certain standard requirements are made on the target directory format of file storage. Specifically, the specification of "\\ ftphemoe \ host system number \ natural date (system date) \ hanging file name" is satisfied, where test environment information is attached to the host system number. The file path is divided by using \ "and effective information such as testing environment, natural date, system date and the like can be obtained by matching according to the sequence.

The file content processing module 102: and analyzing the machine account files according to file organization rules of the machine account files, wherein the method mainly comprises a field intercepting step and a code system converting step. The file organization rule defines information of field meaning, field type, field length and the like contained in the file. By comparing with the rule, the host file can be analyzed to obtain effective information. However, some fields (such as money classes) in the file generated by the host system are encoded by EBCDIC, which cannot be directly solved, and corresponding code system conversion is required to meet the use requirement.

The raw data import module 103: after the processing of the previous module, effective information including areas, network points, currencies, account numbers, yesterday debit balances, yesterday credit balances, the current day debit generation amounts, the current day credit generation amounts, the current day debit balances, the current day credit balances, transaction codes and the like can be obtained for machine account hanging data, and the module writes the original information into a local platform database, persists to the local and waits for further processing.

Account hanging reason positioning unit 002: the unit analyzes account hanging reasons according to the original account hanging data obtained by the last unit. The system comprises the following three processing modules: the system comprises a file missing judgment module 201, a trade rolling difference analysis module 202 and a unilateral trade confirmation module 203.

The file missing judgment module 201: the judgment of the module is based on an application uploading file information table, and a peripheral application corresponding to a certain transaction code and a file name of a corresponding uploading accounting system are recorded in the table. Therefore, the primary positioning of the account hanging reason can be carried out by downloading all the file lists under the file path at the end of the calendar day. The specific strategy is as follows: reading the daily terminal machine account data, acquiring the transaction code field of the data, searching an application uploading file information table according to the transaction code, and determining the file name. Judging whether the uploading files of each peripheral application in the current date are empty, if the file size is 0 and the loan amount is 0, writing account hanging reasons into 'program problem, missing all files'; if the file size is not 0, the borrowing is not 0 and the borrowing is not equal, the account hanging reason is written into 'program problem, part of files are missed'; the rest of the cases write null.

Transaction rolling difference analysis module 202: on the basis of the file missing judgment module 201, the transaction condition causing uneven loan is further analyzed by using the module. The specific processing logic used is shown in fig. 10.

In the first step, the debit amount and the credit amount of all machine account data are obtained, and the debit amount list1 and the credit amount list2 are respectively formed.

And secondly, respectively calculating the permutation and combination condition (without duplication removal) of the sum of the debit amount list1 and the credit amount list2 according to a permutation and combination formula, and storing the debit amount combination list3 and the credit amount combination list 4.

Third, the same value is found from the debit amount combination list3 and the credit amount combination list4 and stored in list 5.

Fourthly, traversing a certain accumulated sum value in the list5, and finding various possible combination modes from the debit amount list1 and the credit amount list2 by adopting a depth-first search strategy based on a backtracking method, and respectively storing the combination modes into the debit specific combination list6 and the credit specific combination list 7.

And fifthly, respectively searching each debit/credit value of a certain combination result according to the obtained debit specific combination list6 and the credit specific combination list7, and marking as a debit specific amount list8 and a credit specific amount list 9.

At step 6, the accounting title corresponding to the debit amount in list8 and list9 is recorded and stored in the accounting title list 10.

Through the steps, account-hanging records which cause uneven borrowing and lending can be analyzed to be account-hanging transaction components under which accounting subjects, and then business personnel are assisted to position the subjects and account-hanging amount information which cause the account-hanging records to correspond. Therefore, on the basis that the reason why the file missing judgment module 201 locates the 'program problem, missing file', the module supplements the rolling difference information: "borrowing: list10, loan: list10 trade netting is 0 ".

Unilateral transaction confirmation module 203: based on the file missing judgment module 201 and the transaction rolling difference analysis module 202, the module confirms which account-hanging records are caused by single-side transaction and relate to records of single-side transaction codes according to a single-side transaction configuration table, and fills the single-side transaction in the account-hanging reason column. And if the rest of account hanging reasons cannot be positioned through the three modules, the account hanging reasons are marked as 'abnormal account hanging'.

Target data import unit 003: the unit receives the processing results of the host file analyzing unit 001 and the account-hanging reason positioning unit 002, and integrates the analysis of the account-hanging reason positioning unit 002 to obtain the information of the relevant fields of the account-hanging reason and writes the information into the database target table on the basis of processing the original data fields. The system specifically comprises the following two modules: a raw data processing module 301 and a journal reason additional recording module 302.

Raw data processing module 301: the processing steps of the module are divided into two steps: firstly, translating key fields (such as accounting subjects, transaction codes and the like) in original data according to a data dictionary to increase the readability of the data; the second step is that: and associating the information of the personnel department configuration table, and acquiring a responsible department and a responsible person corresponding to a certain account data, so as to be convenient for the distribution and tracking of the subsequent account data.

The hanging account reason additional recording module 302: the module additionally records the account hanging reason information analyzed by the account hanging reason positioning unit 002 into the corresponding specific account hanging data, so as to obtain complete account hanging data information, and persists the information into the database target table.

Therefore, the method and the device can realize the positioning and analysis of account hanging reasons of a large amount of machine account hanging data in the end of day. The reason is analyzed from three aspects of missing host batch files from the periphery, unilateral transaction, automatic transaction error, and the like, so that accounting subject information causing account hanging is provided for business personnel, deep analysis is facilitated, and the work quality of account checking is stably improved.

Among them, this disclosure has realized guaranteeing from the technical side that the financial affairs are checked high quality and high efficiency. The main embodiment is as follows: the platform actively analyzes and positions the accounting risk, and the automation and intellectualization of the flow of accounting core are promoted; initiating technical analysis aiming at a specific business scene to realize accurate classification and deep excavation of financial risks; by means of the method, investment of account checking cost is effectively saved, human resources are saved, and meanwhile work efficiency is improved.

In addition, the risk prevention capability of the account-related application system is improved. The method successfully discovers multiple high-risk program defects including noble metal service account hanging, batch compensation abnormity of a personal area network, active account hanging of personal settlement and the like, effectively improves the service quality of scientific and technological innovation on the service side, and effectively improves the production risk prevention capability of account-related application systems.

By means of the automatic checking method of daily terminal machine account hanging, automation and intellectualization of account checking analysis are realized, and the method has important significance for guaranteeing the station checking quality of a bank system, preventing the occurrence of account risks and improving the business service quality.

Fig. 11 schematically shows a block diagram of an electronic device adapted to implement the above method according to an embodiment of the present disclosure.

As shown in fig. 11, an electronic apparatus 900 according to an embodiment of the present disclosure includes a processor 901 which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)902 or a program loaded from a storage portion 908 into a Random Access Memory (RAM) 903. Processor 901 may comprise, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or associated chipset, and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), among others. The processor 901 may also include on-board memory for caching purposes. The processor 901 may comprise a single processing unit or a plurality of processing units for performing the different actions of the method flows according to embodiments of the present disclosure.

In the RAM 903, various programs and data necessary for the operation of the electronic apparatus 900 are stored. The processor 901, the ROM 902, and the RAM 903 are connected to each other through a bus 904. The processor 901 performs various operations of the method flows according to the embodiments of the present disclosure by executing programs in the ROM 902 and/or the RAM 903. Note that the programs may also be stored in one or more memories other than the ROM 902 and the RAM 903. The processor 901 may also perform various operations of the method flows according to embodiments of the present disclosure by executing programs stored in the one or more memories.

Electronic device 900 may also include input/output (I/O) interface 905, input/output (I/O) interface 905 also connected to bus 904, according to an embodiment of the present disclosure. The electronic device 900 may also include one or more of the following components connected to the I/O interface 905: an input portion 906 including a keyboard, a mouse, and the like; an output section 907 including components such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 908 including a hard disk and the like; and a communication section 909 including a network interface card such as a LAN card, a modem, or the like. The communication section 909 performs communication processing via a network such as the internet. The driver 910 is also connected to an input/output (I/O) interface 905 as necessary. A removable medium 911 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 910 as necessary, so that a computer program read out therefrom is mounted into the storage section 908 as necessary.

The present disclosure also provides a computer-readable storage medium, which may be contained in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, a computer-readable storage medium may include the ROM 902 and/or the RAM 903 described above and/or one or more memories other than the ROM 902 and the RAM 903.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the method illustrated in the flow chart. The program code is for causing a computer system to perform the methods of the embodiments of the disclosure when the computer program product is run on the computer system.

The computer program performs the above-described functions defined in the system/apparatus of the embodiments of the present disclosure when executed by the processor 901. The systems, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.

In one embodiment, the computer program may be hosted on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed in the form of a signal on a network medium, and downloaded and installed through the communication section 909 and/or installed from the removable medium 911. The computer program containing program code may be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 909, and/or installed from the removable medium 911. The computer program, when executed by the processor 901, performs the above-described functions defined in the system of the embodiment of the present disclosure. The systems, devices, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.

In accordance with embodiments of the present disclosure, program code for executing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, these computer programs may be implemented using high level procedural and/or object oriented programming languages, and/or assembly/machine languages. The programming language includes, but is not limited to, programming languages such as Java, C + +, python, the "C" language, or the like. The program code may execute entirely on the user computing device, partly on the user device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Those skilled in the art will appreciate that various combinations and/or combinations of features recited in the various embodiments and/or claims of the present disclosure can be made, even if such combinations or combinations are not expressly recited in the present disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments and/or claims of the present disclosure may be made without departing from the spirit or teaching of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.

The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.

Claims

1. An automatic checking method of account hanging is characterized by comprising the following steps:

acquiring data information of the account hanging file;

analyzing the data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first party account records and n second party account records, and m and n are integers more than or equal to 1;

according to the m first side account records and the n second side account records, determining r first side account records capable of realizing the balance in the m first side account records as first target account records, and determining k second side account records capable of realizing the balance in the n second side account records as second target account records, wherein r and k are integers more than or equal to 0; and

and outputting the first target account book and the second target account book to an associated data processing system.

2. The method according to claim 1, wherein the determining, according to the m first side account records and the n second side account records, r first side account records that can achieve tie-out from the m first side account records as first target account records, and k second side account records that can achieve tie-out from the n second side account records as second target account records, specifically comprises:

adding, arranging and combining the m first party account records;

adding, arranging and combining the n second party account records;

determining the arrangement and combination condition that the sum of the m first side account records and the n second side account records is equal;

taking the r first party account records involved in the arrangement and combination condition with equal summation as a first target account record; and

and taking the k second party account records involved in the arrangement combination condition with equal summation as second target account records.

3. The method of claim 1, wherein the m first party's billing records include debit balances and/or debit generation amounts, and wherein the n second party's billing records include credit balances and/or credit generation amounts.

4. The method of claim 3, wherein the file valid information further comprises a transaction code, the method further comprising:

acquiring storage information of a hanging account file, wherein the storage information comprises a file name and a file size;

matching the transaction code with a pre-constructed uploading file information table, wherein the uploading file information table comprises the transaction code and an uploading file name corresponding to the transaction code;

when the transaction codes are matched in the uploading file information table, file names which are consistent with the uploading file names corresponding to the transaction codes are determined; and

and when the file size corresponding to the file name is zero and the first party account register record and the second party account register record are both zero, determining that the account register reason corresponding to the transaction code is to miss at least part of the file.

5. The method of claim 1, wherein the file valid information further comprises a transaction code, the method further comprising:

matching the transaction code with a pre-constructed unilateral transaction configuration table; and

and when the transaction codes are matched in the unilateral transaction configuration table, determining account hanging reasons corresponding to the transaction codes as unilateral transaction account hanging.

6. The method of claim 1, wherein the file valid information further comprises at least one of a region, a website, a currency, and a transaction code, the method further comprising: and outputting the file valid information.

7. The method of any one of claims 1-6, further comprising:

acquiring path information of the account hanging file;

analyzing the path information according to a file division rule to obtain a source name, a natural date and a data generation date; and

outputting the source name, the natural date, and the data generation date.

8. An automatic reconciliation device for posted accounts, comprising:

the acquisition module is used for executing the acquisition of the data information of the account hanging file;

the analysis module is used for analyzing the data information according to a preset file organization rule to obtain effective file information, wherein the effective file information comprises m first party account records and n second party account records, and m and n are integers greater than or equal to 1;

a determining module, configured to perform, according to the m first party account records and the n second party account records, determining, as a first target account record, r first party account records that can achieve tie account in the m first party account records, and determining, as a second target account record, k second party account records that can achieve tie account in the n second party account records, where r and k are integers greater than or equal to 0; and

and the output module is used for outputting the first target account book and the second target account book to an associated data processing system.

9. An electronic device, comprising:

one or more processors;

one or more memories for storing executable instructions that, when executed by the processor, implement the method of any of claims 1-7.

10. A computer-readable storage medium having stored thereon executable instructions that when executed by a processor implement a method according to any one of claims 1 to 7.

11. A computer program product comprising a computer program comprising one or more executable instructions which, when executed by a processor, implement a method according to any one of claims 1 to 7.