CN114298804A - Intelligent account checking method, system and computer readable storage medium - Google Patents
Intelligent account checking method, system and computer readable storage medium Download PDFInfo
- Publication number
- CN114298804A CN114298804A CN202111535009.9A CN202111535009A CN114298804A CN 114298804 A CN114298804 A CN 114298804A CN 202111535009 A CN202111535009 A CN 202111535009A CN 114298804 A CN114298804 A CN 114298804A
- Authority
- CN
- China
- Prior art keywords
- reconciliation
- data
- financial data
- bill
- intelligent
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The present application relates to a method, system, and computer-readable storage medium. The method comprises the following steps: setting a financial data reconciliation rule and carrying out initialization configuration on an intelligent reconciliation component; importing financial data by using the intelligent reconciliation component, and preprocessing the financial data; on the basis of an account checking rule, performing account checking on the financial data and generating an account checking result; and displaying or exporting the reconciliation result. By adopting the method, the account checking of the transaction file can be quickly realized, and the account checking result is displayed.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to an intelligent reconciliation method, system and computer-readable storage medium.
Background
The existing reconciliation of banks and enterprises is to calculate related cost data according to the banks and the enterprises respectively, then carry out reconciliation according to calculation results, mainly manually configure reconciliation rules, convert a business data format to be accounted to generate reconciliation data, and then carry out reconciliation processing on each reconciliation data according to the configured reconciliation rules.
The existing account checking system has the following problems: the first is that: the account checking rules used by each bank and the enterprise are different, so when a new bank is docked, the account checking rules need to be manually configured every time the docking bank is newly added according to different identifications of each bank, and the account checking needs to be performed according to the account checking rules, so that developers need to know and familiarize the original account checking rules and reconfigure the new account checking rules. Secondly, the following steps: any form of bill data may change due to different enterprises or banks, and when the traditional account checking method and system face the change of the bill data format, the system cannot be adjusted in time, and the only solution is that technical developers intervene, which consumes a large amount of manpower. Thirdly, the method comprises the following steps: in the process of checking account of the bill data, when the account checking system encounters an overlarge bill file, the file cannot be processed, and the faults of account checking system blocking and crash are often caused by memory overflow. Fourthly, the method comprises the following steps: in the account checking process of the system, human-computer interaction cannot be carried out. Therefore, it is urgently needed to provide an intelligent reconciliation method and system to solve the above problems in the prior art.
Disclosure of Invention
In view of the above, there is a need for an intelligent reconciliation method, system and computer-readable storage medium that overcome or at least alleviate at least one of the above-mentioned deficiencies in the prior art.
In one aspect, an intelligent reconciliation method is provided, which comprises the following steps: step S01, setting a financial data reconciliation rule and carrying out initialization configuration on the intelligent reconciliation component; step S02, importing financial data by using the intelligent reconciliation component, and preprocessing the financial data; step S03, checking the financial data based on the checking rule and generating a checking result; and step S04, displaying or exporting the reconciliation result.
In one embodiment, the financial data comprises: business billing data and channel billing data.
In one embodiment, the preprocessing the finance comprises: analyzing and checking financial data, and filtering, extracting and converting the financial data; wherein: the financial data analysis and verification comprises the following steps: carrying out total score checking, money conversion and filtering replacement on the financial data; the financial data filtering extraction and conversion comprises the following steps: and performing daily cutting processing, non-physical transaction fee extraction, expanded field processing and data format conversion on the financial data.
In one embodiment, the reconciling the financial data and generating the reconciliation result includes: step 031, compare said business bill data and said channel bill data one by one; step S032, if inconsistent bill data exists between the business bill data and the channel bill data, skipping the inconsistent bill data; step 033, generating a reconciliation result; wherein: and the reconciliation result is stored in a split storage mode.
In one embodiment, the reconciliation result includes: account checking result state, error entry detail, bill generation party detail and non-conforming data detail.
In one embodiment, the importing form of the financial data includes: manual import, database view import and FTP import; sources of the financial data include: SFTP, HTTP, VOS and DB; the format of the financial data comprises: CSV format, TXT format, json format, and RSA encrypted file format.
In another aspect, an intelligent reconciliation system is provided, which comprises a reconciliation manager and a financial data receiving manager, wherein the reconciliation data receiving manager is in communication connection with the reconciliation manager and is used for receiving channel bill data and business bill data; the financial data preprocessor is in communication connection with the reconciliation data receiving manager and is used for preprocessing the channel bill data and the business bill data based on reconciliation rules; the account checking executor is in communication connection with the financial data preprocessor and is used for carrying out bill comparison on the business bill data and the channel bill data and generating an account checking result; and the account checking result storage is in communication connection with the account checking executor and is used for storing and displaying the account checking result.
In one embodiment, the tie-out executor includes: the financial data scanning module is used for scanning and comparing the channel bill data and the business bill data; and the financial data filtering module is used for filtering the inconsistent data between the channel bill data and the business bill data.
In one embodiment, the system further comprises: the reconciliation trigger is in communication connection with the reconciliation executor and is used for setting a reconciliation time point to trigger the reconciliation executor to perform reconciliation processing on the business bill data and the channel bill data; the human-computer interaction interface is in communication connection with the financial data receiving manager and is used for re-uploading financial data when the business bill data and/or the channel bill data have problems; the human-computer interaction interface is in communication connection with the reconciliation result storage and is used for checking and downloading the reconciliation result.
In yet another aspect, a computer-readable storage medium is provided, having stored thereon a computer program which, when executed by a processor, performs the steps of: step S01, setting a financial data reconciliation rule and carrying out initialization configuration on the intelligent reconciliation component; step S02, importing financial data by using the intelligent reconciliation component, and preprocessing the financial data; step S03, checking the financial data based on the checking rule and generating a checking result; and step S04, displaying or exporting the reconciliation result.
In one embodiment, the computer program when executed by the processor further performs the steps of: analyzing and checking financial data, and filtering, extracting and converting the financial data; wherein: the financial data analysis and verification comprises the following steps: carrying out total score checking, money conversion and filtering replacement on the financial data; the financial data filtering extraction and conversion comprises the following steps: and performing daily cutting processing, non-physical transaction fee extraction, expanded field processing and data format conversion on the financial data.
In one embodiment, the computer program when executed by the processor further performs the steps of: step 031, compare said business bill data and said channel bill data one by one; step S032, if inconsistent bill data exists between the business bill data and the channel bill data, skipping the inconsistent bill data; step 033, generating a reconciliation result; wherein: and the reconciliation result is stored in a split storage mode.
The intelligent account checking method, the system and the computer readable storage medium set the financial data account checking rule and carry out the initialization configuration of the intelligent account checking component; importing financial data by using the intelligent reconciliation component, and preprocessing the financial data; on the basis of an account checking rule, performing account checking on the financial data and generating an account checking result; and finally, the reconciliation result can be displayed or exported. The method has the advantages that various reconciliation data sources are supported, multi-fund main body sum total score checking is supported, monetary unit conversion is supported, many-to-many file reconciliation is supported, reconciliation files in various formats are supported, daily cutting configuration is supported, cross-daily verification is supported, refund compensation caused by repeated deduction is supported, regular expression filtering, replacement, skipping and other operations are supported, reconciliation of large files is supported, channel transaction commission charge and other special extension fields are supported, and reports can be automatically generated for financial checking according to reconciliation results and differences; and the reconciliation intermediate data can be stored in a split storage mode, so that the memory overflow is prevented. In addition, if a new channel is accessed for account checking, the intelligent account checking method and the intelligent account checking system can be realized only by adding corresponding configuration, and code development and online processes are not required.
Drawings
FIG. 1 is a diagram of an application environment of an intelligent reconciliation method in one embodiment;
FIG. 2 is a flow chart of an intelligent reconciliation method in one embodiment (I);
FIG. 3 is a flow chart of an intelligent reconciliation method in one embodiment (II);
FIG. 4 is a block diagram of an intelligent reconciliation system in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
Example one
The intelligent reconciliation method provided by the application can be applied to the application environment shown in FIG. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In one embodiment, as shown in fig. 2 to 3, an intelligent reconciliation method is provided, which is described by taking the method as an example applied to the terminal in fig. 1, and includes the following steps:
step S01, setting a financial data reconciliation rule and carrying out initialization configuration on the intelligent reconciliation component;
step S02, importing financial data by using the intelligent reconciliation component, and preprocessing the financial data; the intelligent reconciliation component can read and store financial data in real time and can also lead financial data into the intelligent reconciliation component by financial staff in a man-machine interaction mode. Further, the import form of the financial data can be any one or more of a manual import, a database view import, or an FTP import. The format for the financial data uploaded to the intelligent reconciliation component may be: CSV format, TXT format, json format, or RSA encrypted file format. Sources of financial data include SFTP, HTTP, VOS, and DB.
In a specific embodiment, the process of preprocessing the financial data comprises: analyzing and checking financial data, and filtering, extracting and converting the financial data; wherein: the financial data analysis and verification comprises the following steps: carrying out total score checking, money conversion and filtering replacement on the financial data; the financial data filtering extraction and conversion comprises the following steps: and performing daily cutting processing, non-physical transaction fee extraction, expanded field processing and data format conversion on the financial data. Wherein: the total score check is as follows: checking principal, interest, penalty, commission and total transaction amount of each funding subject. And the amount conversion is amount unit conversion, and when the units of the business bill data and the channel bill data are inconsistent, the two bill data are subjected to unit conversion to be consistent. And the daily cutting processing is to configure the business bill data or the channel bill data according to daily cutting time, and automatically extract corresponding transactions for reconciliation.
Step S03, checking the financial data based on the checking rule and generating a checking result; in a specific embodiment, the reconciling the financial data and generating the reconciliation result includes the following steps: step 031, compare said business bill data and said channel bill data one by one; step S032, if inconsistent bill data exists between the business bill data and the channel bill data, skipping the inconsistent bill data; step 033, generating a reconciliation result; wherein: and the reconciliation result is stored in a split storage mode.
Step S04, displaying or exporting the reconciliation result; wherein: the account checking result comprises the following steps: account checking result state, error entry detail, bill generation party detail and non-conforming data detail. And automatically generating a report form according to the account checking result and the account checking result difference for a special financial staff to check. And the account checking file can be downloaded, edited and re-uploaded through the operation background to perform account checking.
It should be understood that although the various steps in the flow charts of fig. 2-3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. Unless explicitly stated otherwise herein, the steps are not performed in a strict order, and may be performed in other orders or some of the steps may be performed in a parallel process. Moreover, at least some of the steps in fig. 2-3 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternating with other steps or at least some of the sub-steps or stages of other steps.
Example two
In one embodiment, as shown in fig. 4, an intelligent reconciliation system is provided to implement the intelligent reconciliation method according to the first embodiment, including: a reconciliation manager; the financial data receiving manager is in communication connection with the reconciliation manager and is used for receiving channel bill data and business bill data; the financial data preprocessor is in communication connection with the reconciliation data receiving manager and is used for preprocessing the channel bill data and the business bill data based on reconciliation rules; the account checking executor is in communication connection with the financial data preprocessor and is used for carrying out bill comparison on the business bill data and the channel bill data and generating an account checking result; and the account checking result storage is in communication connection with the account checking executor and is used for storing and displaying the account checking result.
In a specific embodiment, the reconciliation actuator comprises: the financial data scanning module is used for scanning and comparing the channel bill data and the business bill data; and the financial data filtering module is used for filtering the inconsistent data between the channel bill data and the business bill data.
In a specific embodiment, the system further comprises: the reconciliation trigger is in communication connection with the reconciliation executor and is used for setting a reconciliation time point to trigger the reconciliation executor to perform reconciliation processing on the business bill data and the channel bill data; the human-computer interaction interface is in communication connection with the financial data receiving manager and is used for re-uploading financial data when the business bill data and/or the channel bill data have problems; the human-computer interaction interface is in communication connection with the reconciliation result storage and is used for checking and downloading the reconciliation result.
For specific definition of the intelligent reconciliation system, reference may be made to the definition of the intelligent reconciliation method in the foregoing, and details are not described herein again. The modules in the intelligent reconciliation system can be wholly or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
Those skilled in the art will appreciate that the architecture shown in fig. 4 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
EXAMPLE III
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: step S01, setting a financial data reconciliation rule and carrying out initialization configuration on the intelligent reconciliation component; step S02, importing financial data by using the intelligent reconciliation component, and preprocessing the financial data; step S03, checking the financial data based on the checking rule and generating a checking result; and step S04, displaying or exporting the reconciliation result.
In one embodiment, the computer program when executed by the processor further performs the steps of: step 031, compare said business bill data and said channel bill data one by one; step S032, if inconsistent bill data exists between the business bill data and the channel bill data, skipping the inconsistent bill data; step 033, generating a reconciliation result; wherein: and the reconciliation result is stored in a split storage mode.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. An intelligent account checking method is characterized by comprising the following steps:
step S01, setting a financial data reconciliation rule and carrying out initialization configuration on the intelligent reconciliation component;
step S02, importing financial data by using the intelligent reconciliation component, and preprocessing the financial data;
step S03, checking the financial data based on the checking rule and generating a checking result;
and step S04, displaying or exporting the reconciliation result.
2. The intelligent reconciliation method of claim 1 wherein the financial data comprises: business billing data and channel billing data.
3. The intelligent reconciliation method of claim 1 wherein the pre-processing the finance comprises: analyzing and checking financial data, and filtering, extracting and converting the financial data;
wherein:
the financial data analysis and verification comprises the following steps: carrying out total score checking, money conversion and filtering replacement on the financial data;
the financial data filtering extraction and conversion comprises the following steps: and performing daily cutting processing, non-physical transaction fee extraction, expanded field processing and data format conversion on the financial data.
4. The intelligent reconciliation method of claim 2 wherein the reconciling the financial data and generating a reconciliation result comprises the steps of:
step 031, compare said business bill data and said channel bill data one by one;
step S032, if inconsistent bill data exists between the business bill data and the channel bill data, skipping the inconsistent bill data;
step 033, generating a reconciliation result;
wherein: and the reconciliation result is stored in a split storage mode.
5. The intelligent reconciliation method of claim 4, wherein the reconciliation result comprises: account checking result state, error entry detail, bill generation party detail and non-conforming data detail.
6. The intelligent reconciliation method of claim 1 wherein the imported form of financial data comprises: manual import, database view import and FTP import;
sources of the financial data include: SFTP, HTTP, VOS and DB;
the format of the financial data comprises: CSV format, TXT format, json format, and RSA encrypted file format.
7. An intelligent reconciliation system comprising a reconciliation manager, wherein the system further comprises:
the financial data receiving manager is in communication connection with the reconciliation manager and is used for receiving channel bill data and business bill data;
the financial data preprocessor is in communication connection with the reconciliation data receiving manager and is used for preprocessing the channel bill data and the business bill data based on reconciliation rules;
the account checking executor is in communication connection with the financial data preprocessor and is used for carrying out bill comparison on the business bill data and the channel bill data and generating an account checking result;
and the account checking result storage is in communication connection with the account checking executor and is used for storing and displaying the account checking result.
8. The intelligent reconciliation system of claim 7 wherein the reconciliation actuator comprises:
the financial data scanning module is used for scanning and comparing the channel bill data and the business bill data;
and the financial data filtering module is used for filtering the inconsistent data between the channel bill data and the business bill data.
9. The intelligent reconciliation system of claim 7 wherein the system further comprises:
the reconciliation trigger is in communication connection with the reconciliation executor and is used for setting a reconciliation time point to trigger the reconciliation executor to perform reconciliation processing on the business bill data and the channel bill data;
the human-computer interaction interface is in communication connection with the financial data receiving manager and is used for re-uploading financial data when the business bill data and/or the channel bill data have problems; the human-computer interaction interface is in communication connection with the reconciliation result storage and is used for checking and downloading the reconciliation result.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111535009.9A CN114298804A (en) | 2021-12-15 | 2021-12-15 | Intelligent account checking method, system and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111535009.9A CN114298804A (en) | 2021-12-15 | 2021-12-15 | Intelligent account checking method, system and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114298804A true CN114298804A (en) | 2022-04-08 |
Family
ID=80966865
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111535009.9A Pending CN114298804A (en) | 2021-12-15 | 2021-12-15 | Intelligent account checking method, system and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114298804A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115934301A (en) * | 2023-03-03 | 2023-04-07 | 北京集度科技有限公司 | Account checking method, configuration method, terminal equipment and computer program product |
| CN116012178A (en) * | 2022-12-15 | 2023-04-25 | 广西电网有限责任公司 | Automatic financial accounting method based on artificial intelligence |
| CN117350880A (en) * | 2023-12-06 | 2024-01-05 | 杭州乒乓智能技术有限公司 | Full-link account checking method, device, equipment and medium based on snowflake algorithm |
-
2021
- 2021-12-15 CN CN202111535009.9A patent/CN114298804A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116012178A (en) * | 2022-12-15 | 2023-04-25 | 广西电网有限责任公司 | Automatic financial accounting method based on artificial intelligence |
| CN116012178B (en) * | 2022-12-15 | 2023-10-27 | 广西电网有限责任公司 | Automatic financial accounting method based on artificial intelligence |
| CN115934301A (en) * | 2023-03-03 | 2023-04-07 | 北京集度科技有限公司 | Account checking method, configuration method, terminal equipment and computer program product |
| CN117350880A (en) * | 2023-12-06 | 2024-01-05 | 杭州乒乓智能技术有限公司 | Full-link account checking method, device, equipment and medium based on snowflake algorithm |
| CN117350880B (en) * | 2023-12-06 | 2024-02-23 | 杭州乒乓智能技术有限公司 | Full-link account checking method, device, equipment and medium based on snowflake algorithm |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108876133B (en) | Risk assessment processing method, device, server and medium based on business information | |
| CN109858737B (en) | Grading model adjustment method and device based on model deployment and computer equipment | |
| CN114298804A (en) | Intelligent account checking method, system and computer readable storage medium | |
| EP3627759A1 (en) | Method and apparatus for encrypting data, method and apparatus for training machine learning model, and electronic device | |
| US20050080821A1 (en) | System and method for managing collections accounts | |
| CN110782240A (en) | Service data processing method and device, computer equipment and storage medium | |
| CN112308710B (en) | Loan data processing method, loan data processing device, computer equipment and storage medium | |
| CN110503564B (en) | Security case processing method, system, equipment and storage medium based on big data | |
| CN111192144A (en) | Financial data prediction method, device, equipment and storage medium | |
| CN110766275A (en) | Data verification method and device, computer equipment and storage medium | |
| CN112232818A (en) | Data reconciliation method and device, computer equipment and storage medium | |
| CN115409590A (en) | Unified account checking method, device, equipment and storage medium | |
| CN113095408A (en) | Risk determination method and device and server | |
| CN115936895A (en) | Risk assessment method, device and equipment based on artificial intelligence and storage medium | |
| CN110472895B (en) | Financial system wind control method and device, computer equipment and storage medium | |
| CN117057794A (en) | Block chain-based intelligent payment gateway transaction method, system, equipment and medium | |
| CN106708869B (en) | Group data processing method and device | |
| CN116860805A (en) | Data processing method, device, computer equipment and storage medium | |
| CN116681045A (en) | Report generation method, report generation device, computer equipment and storage medium | |
| CN116957828A (en) | Method, equipment, storage medium and device for checking account | |
| CN114358903A (en) | RPA-based multi-system accounting checking method and device and computer equipment | |
| CN110377269B (en) | Service approval system collocation method, device and storage medium | |
| CN113888337A (en) | Capital settlement method, device, equipment and storage medium based on big data | |
| CN116934512A (en) | Financial month knot auditing method and device, computer equipment and storage medium | |
| CN114331713A (en) | Transaction relationship network generation and behavior query method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |