Method and apparatus for managing bills, electronic device, and storage medium
By establishing a bill directory and performing image recognition and information updates, the problem of low bill checking efficiency in financial business is solved, and the automated management of bill collection and search is realized, which improves work efficiency.
Patent Information
- Application Number
- CN202210530932.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-05-16
- Publication Date
- 2025-07-18
- Estimated Expiration
- 2042-05-16
AI Technical Summary
In the prior art, bill checking efficiency in financial business is low and requires manual processing, resulting in low efficiency in bill collection and search, and the total-to-to-to-to-the-month method cannot be realized, and the work efficiency is low.
Establish a bill directory for the target financial products, scan and upload bill files to the preset document platform, perform image recognition, obtain file identification information and attribute information, and update file identification and attribute information based on platform identification and financial account information to achieve automated management.
Significantly reduce the management process of manual participation, reduce the workload of manual processing, improve the efficiency of bill collection and search, realize online automated processing, and improve the efficiency of total-to-to-to-to-to-to-element docking.
Smart Images

Figure CN114842479B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of fintech, and in particular, to a method and device for managing bills, an electronic device, and a storage medium. Background Art
[0002] Currently, due to the lack of a common infrastructure in the market, when reconciling bills in financial operations (such as a managed product investing in an open-ended fund), the reconciliation efficiency is relatively low. In related technologies, after receiving the statement, business personnel generally use manual processing methods. First, they send it to the business supervisor, who centrally stores it offline and sets up folder sharing. Business personnel access the shared folder and manually search through thousands of statements one by one according to the combination division of labor and reconcile them with the statements.
[0003] However, for customers with regular audit requirements (such as railway bureaus, basic pensions, social security, etc.), it is also necessary to collect and provide statements from thousands of statements according to the combination dimension. For decentralized combinations, in order for financial subsidiaries to obtain statements, they need to execute an account change process to change the statement email, or the financial institution distributes them manually after receiving them.
[0004] Therefore, in related technologies, financial institutions and multiple financial subsidiaries need to separately contact the statement email of multiple opening institutions repeatedly, collect them one by one, store them one by one, and manually search through them one by one, which cannot achieve the total-to-total method, resulting in low work efficiency. Moreover, the process of storing files offline, manually searching through them disorderly and repeatedly, and communicating between the head office and branches is less efficient.
[0005] In view of the above problems, no effective solution has been proposed yet. Summary of the Invention
[0006] Embodiments of the present invention provide a method and device for managing bills, an electronic device, and a storage medium, so as to at least solve the technical problem in related technologies that manual management of bill files leads to low efficiency in bill collection and search.
[0007] According to one aspect of an embodiment of the present invention, a method for managing bills is provided, including: establishing a bill directory for a target financial product, where at least the following are included under the bill directory: a plurality of bill files; scanning the bill directory, uploading the bill files to a preset document platform, and storing file identification information and file attribute information in a preset verification system, where the file identification information is the identification information obtained after image recognition of the bill files, and at least the following is included in the file attribute information: a platform identifier; obtaining the bill files that have not been recognized from the preset document platform indicated by the platform identifier to obtain target bill files; identifying the target bill files to obtain the financial account information corresponding to the target bill files; and updating the file identification information and the file attribute information based on the platform identifier and the financial account information.
[0008] Optionally, the step of establishing a bill directory for a target financial product includes: establishing the bill directory for the target financial product based on a preset establishment strategy, where at least the following are included in the bill directory: a reconciliation date and an opening institution identifier; determining the opening institution identifier corresponding to the opening institution information carried by the bill file to obtain a target opening institution identifier; and uploading the bill file to the bill directory indicated by the target opening institution identifier.
[0009] Optionally, after scanning the bill directory and uploading the bill files to a preset document platform, the following is further included: in the case where the upload of the bill file to the preset document platform is successful, adding first record information to the file identification information and adding second record information to the file attribute information, where the first record information includes at least one of the following: an identification serial number, a platform identifier, an unbound status, and an operation time, and the second record information includes at least one of the following: a file number, a file path, a file name, an upload date, a platform identifier, an uploaded status, and an identification serial number; in the case where the upload of the bill file to the preset document platform fails, adding third record information to the file identification information and adding fourth record information to the file attribute information, where the third record information includes at least one of the following: an identification serial number, an unbound status, and an operation time, and the fourth record information includes at least one of the following: a file number, a file path, a file name, an upload date, a non-uploaded status, and an identification serial number.
[0010] Optionally, the step of obtaining the bill files that have not been recognized from the preset document platform indicated by the platform identifier to obtain target bill files includes: scanning the file attribute information to determine the bill files in the file attribute information whose upload status is the uploaded status and whose platform identifier is not empty; and obtaining the target bill files from the preset document platform indicated by the platform identifier.
[0011] Optionally, after identifying the target bill file and obtaining the financial account information corresponding to the target bill file, the method further includes: when the identification of the target bill file is successful, updating the first information in the file attribute information and the second information in the file identification information, where the identification status in the first information is updated to the parsed status, the financial account information is added to the first information, the number of identifications in the first information is increased by a preset value, the identification start time and the identification end time are added to the first information, and the financial account information is added to the second information; when the identification of the target bill file fails, updating the third information in the file attribute information, where the identification status in the third information is updated to the uploaded status, the number of identifications in the third information is increased by the preset value, the identification start time, the identification end time, and the error information are added to the third information.
[0012] Optionally, the step of updating the file identification information and the file attribute information based on the platform identifier and the financial account information includes: querying, based on the platform identifier, the file directory of the bill file corresponding to the platform identifier in the file attribute information; querying the account opening institution identifier in the file directory, and updating the institution code in the file identification information based on the institution code of the account opening institution indicated by the account opening institution identifier.
[0013] Optionally, the step of updating the file identification information and the file attribute information based on the platform identifier and the financial account information further includes: judging whether the financial account is empty based on the financial account information; when the financial account is empty, updating the binding status in the file identification information to the unbound status and updating the reconciliation date in the file identification information; when the financial account is not empty, judging whether the user account corresponding to the financial account information exists; when the user account does not exist, updating the binding status in the file identification information to the unbound status and updating the reconciliation date in the file identification information; when the user account exists, judging whether the financial portfolio corresponding to the user account is unique; when the financial portfolio is unique, updating the financial portfolio code, the institution code, and the region code in the file identification information, and updating the binding status in the file identification information to the bound status; when the financial portfolio is not unique, determining the combined information corresponding to the common account filing records of the multiple financial portfolios; based on the combined information, updating the financial portfolio code, the institution code, and the region code in the file identification information, and updating the binding status in the file identification information to the bound status.
[0014] Optionally, after updating the file identification information and the file attribute information based on the platform identification and the financial account information, the method further includes: receiving a verification request, where the verification request is a request configured through a pre-configured front-end menu, and the verification request at least includes: a user account identification, a reconciliation date, and a settlement institution identification; based on the verification request, matching the user account identification, the reconciliation date, and the settlement institution identification with the financial combination identification, the reconciliation date, and the account opening institution identification in the file identification information to obtain a matching result; and determining that the verification is successful when the matching result indicates a successful match.
[0015] According to another aspect of the embodiments of the present invention, there is also provided a bill management device, including: a establishing unit, configured to establish a bill directory of a target financial product, where the bill directory at least includes: a plurality of bill files; an uploading unit, configured to scan the bill directory, upload the bill files to a preset document platform, and store the file identification information and the file attribute information in a preset verification system, where the file identification information is the identification information obtained after performing image recognition on the bill files, and the file attribute information at least includes: a platform identification; an obtaining unit, configured to obtain the bill files that have not been recognized from the preset document platform indicated by the platform identification to obtain target bill files; an identifying unit, configured to identify the target bill files to obtain the financial account information corresponding to the target bill files; and an updating unit, configured to update the file identification information and the file attribute information based on the platform identification and the financial account information.
[0016] Optionally, the establishing unit includes: a first establishing module, configured to establish the bill directory of the target financial product based on a preset establishing strategy, where the bill directory at least includes: a reconciliation date and an account opening institution identification; a first determining module, configured to determine the account opening institution identification corresponding to the account opening institution information carried by the bill files to obtain a target account opening institution identification; and a first uploading module, configured to upload the bill files to the bill directory indicated by the target account opening institution identification.
[0017] Optionally, the management device further includes: a first adding module, configured to, after scanning the bill directory and uploading the bill file to a preset document platform, when the uploading of the bill file to the preset document platform is successful, add first record information to the file identification information and add second record information to the file attribute information, where the first record information includes at least one of the following: identification serial number, platform identifier, unbound status, operation time, and the second record information includes at least one of the following: file number, file path, file name, upload date, platform identifier, uploaded status, identification serial number; a second adding module, configured to, when the uploading of the bill file to the preset document platform fails, add third record information to the file identification information and add fourth record information to the file attribute information, where the third record information includes at least one of the following: identification serial number, unbound status, operation time, and the fourth record information includes at least one of the following: file number, file path, file name, upload date, non-uploaded status, identification serial number.
[0018] Optionally, the obtaining unit includes: a second determining module, configured to scan the file attribute information to determine the bill file whose upload status in the file attribute information is the uploaded status and whose platform identifier is not empty; a first obtaining module, configured to obtain the target bill file in the preset document platform indicated by the platform identifier.
[0019] Optionally, the management device further includes: a first updating module, configured to, after identifying the target bill file and obtaining the financial account information corresponding to the target bill file, when the identification of the target bill file is successful, update the first information in the file attribute information and update the second information in the file identification information, where the identification status in the first information is updated to the parsed status, the financial account information is added to the first information, the identification times in the first information are increased by a preset value, the identification start time and the identification end time are added to the first information, and the financial account information is added to the second information; a second updating module, configured to, when the identification of the target bill file fails, update the third information in the file attribute information, where the identification status in the third information is updated to the uploaded status, the identification times in the third information are increased by the preset value, the identification start time, the identification end time, and the error information are added to the third information.
[0020] Optionally, the updating unit includes: a first query module, configured to query, based on the platform identifier, a file directory of the bill file corresponding to the platform identifier in the file attribute information; a third updating module, configured to query an account opening institution identifier in the file directory, and update the institution code in the file identification information based on the institution code of the account opening institution indicated by the account opening institution identifier.
[0021] Optionally, the updating unit further includes: a first determination module, configured to determine, based on the financial account information, whether the financial account is empty; a fourth updating module, configured to, when the financial account is empty, update the binding status in the file identification information to an unbound status, and update the reconciliation date in the file identification information; a second determination module, configured to, when the financial account is not empty, determine whether a user account corresponding to the financial account information exists; a fifth updating module, configured to, when the user account does not exist, update the binding status in the file identification information to an unbound status, and update the reconciliation date in the file identification information; a third determination module, configured to, when the user account exists, determine whether a financial portfolio corresponding to the user account is unique; a sixth updating module, configured to, when the financial portfolio is unique, update the financial portfolio code, institution code, and region code in the file identification information, and update the binding status in the file identification information to a bound status; a third determination module, configured to, when the financial portfolio is not unique, determine combined information corresponding to a common account filing record of multiple financial portfolios; a seventh updating module, configured to update the financial portfolio code, institution code, and region code in the file identification information based on the combined information, and update the binding status in the file identification information to a bound status.
[0022] Optionally, the management device further includes: a first receiving module, configured to receive a verification request after updating the file identification information and the file attribute information based on the platform identifier and the financial account information, where the verification request is a request configured through a pre-configured front-end menu, and the verification request at least includes: a user account identifier, a reconciliation date, and a settlement institution identifier; a first matching module, configured to match, based on the verification request, the user account identifier, the reconciliation date, and the settlement institution identifier with the financial portfolio identifier, reconciliation date, and account opening institution identifier in the file identification information to obtain a matching result; a fourth determination module, configured to determine that the verification is successful when the matching result indicates a successful match.
[0023] According to another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium, which includes a stored computer program. When the computer program runs, it controls the device where the computer-readable storage medium is located to execute the above-mentioned bill management method.
[0024] According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including one or more processors and a memory. The memory is used to store one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the above-mentioned bill management method.
[0025] In the present disclosure, a bill directory of a target financial product is established, the bill directory is scanned, the bill file is uploaded to a preset document platform, and the file identification information and file attribute information are stored in a preset verification system. The unrecognized bill file is obtained from the preset document platform indicated by the platform identifier to obtain a target bill file. The target bill file is recognized to obtain the financial account information corresponding to the target bill file. Based on the platform identifier and the financial account information, the file identification information and the file attribute information are updated. In the present application, the bill file can be uploaded to the preset document platform by scanning the bill directory, and the file identification information and file attribute information of the bill file are stored in the preset verification system. After that, the unrecognized bill files in the historical process can be recognized to obtain the corresponding financial account information, and the file identification information and file attribute information are automatically updated according to the platform identifier and the financial account information. This can significantly reduce the management process involving manual participation, greatly reduce the workload of manual processing, and at the same time, improve the efficiency of bill collection and search, thereby solving the technical problem in the related art that manual management of bill files leads to low efficiency of bill collection and search. BRIEF DESCRIPTION OF THE DRAWINGS
[0026] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The illustrative embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation to the present invention. In the drawings:
[0027] Figure 1 is a flowchart of an optional bill management method according to an embodiment of the present invention;
[0028] Figure 2 is a schematic diagram of an optional bill management device according to an embodiment of the present invention;
[0029] Figure 3 is a hardware structure block diagram of an electronic device (or mobile device) for a bill management method according to an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0030] In order to enable those skilled in the art to better understand the solution of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.
[0031] It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and do not necessarily need to be used to describe a specific order or sequence. It should be understood that such data can be interchanged under appropriate circumstances so that the embodiments of the present invention described here can be implemented in an order other than those illustrated or described here. In addition, the terms "comprising" and "having" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device comprising a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but may include other steps or units not clearly listed or inherent to these processes, methods, products or devices.
[0032] To facilitate the understanding of the present invention by those skilled in the art, the following explanations are made for some terms or nouns involved in the embodiments of the present invention:
[0033] Optical Character Recognition (OCR for short) can perform general text recognition.
[0034] Open-end fund statement: A service item of account report regularly provided by a fund company to investors. It records the shareholdings of each fund and all transaction details of the investor during that period, and is an important means and tool for investors to understand the trading situation of the funds they invest in.
[0035] It should be noted that the bill management method and its device in the present disclosure can be used in the case of bill management in the field of fintech, and can also be used in any field other than the field of fintech in the case of bill management. The application field of the bill management method and its device in the present disclosure is not limited.
[0036] It should be noted that the relevant information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for display, data for analysis, etc.) involved in this disclosure are all information and data authorized by the user or fully authorized by all parties. For example, an interface is set up between this system and relevant users or institutions. Before obtaining relevant information, a request for obtaining information needs to be sent to the aforementioned users or institutions through the interface, and after receiving the consent information feedback from the aforementioned users or institutions, the relevant information can be obtained.
[0037] The following embodiments of the present invention can be applied to various systems / applications / devices for managing various statements, and can achieve automated statement management. The present invention adjusts the process of processing statements such as manual storage, search, verification, classification, distribution, etc. from offline to online. The statement files are batch uploaded to the statement electronic image and document service platform, and based on OCR automatic recognition, the data is automatically integrated and processed by the business rule system. At the same time, online retrieval, verification, classification are carried out according to business rules, and automatic information distribution is achieved through mail rule configuration, which can effectively reduce the processing process involving manual participation, reduce the workload of manual processing, and at the same time, can effectively improve the efficiency of statement collection and search.
[0038] The present invention will be described in detail below in conjunction with each embodiment.
[0039] Embodiment 1
[0040] According to an embodiment of the present invention, an embodiment of a method for managing statements is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although the logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in a different order than here.
[0041] Figure 1 is a flowchart of an optional method for managing statements according to an embodiment of the present invention, as Figure 1 shown, the method includes the following steps:
[0042] Step S101, establish a statement directory for the target financial product, where at least the following are included under the statement directory: a plurality of statement files.
[0043] Step S102, scan the statement directory, upload the statement files to a preset document platform, and store the file recognition information and file attribute information in a preset verification system, where the file recognition information is the recognition information obtained after image recognition of the statement file, and at least the following is included in the file attribute information: platform identifier.
[0044] Step S103: Obtain the unrecognized bill file from the preset document platform indicated by the platform identifier to obtain the target bill file.
[0045] Step S104: Identify the target bill file to obtain the financial account information corresponding to the target bill file.
[0046] Step S105: Update the file identification information and the file attribute information based on the platform identifier and the financial account information.
[0047] Through the above steps, a bill directory of the target financial product can be established, the bill directory can be scanned, the bill file can be uploaded to the preset document platform, and the file identification information and the file attribute information can be stored in the preset verification system. The unrecognized bill file is obtained from the preset document platform indicated by the platform identifier to obtain the target bill file, the target bill file is identified to obtain the financial account information corresponding to the target bill file, and the file identification information and the file attribute information are updated based on the platform identifier and the financial account information. In the embodiment of the present invention, the bill file can be uploaded to the preset document platform by scanning the bill directory, and the file identification information and the file attribute information of the bill file can be stored in the preset verification system. After that, the bill files that have not been recognized in the historical process can be recognized to obtain the corresponding financial account information, and the file identification information and the file attribute information can be automatically updated according to the platform identifier and the financial account information, which can significantly reduce the management process involving manual participation, greatly reduce the workload of manual processing, and at the same time, can improve the efficiency of bill collection and search, thereby solving the technical problem in the related art that manual management of bill files leads to low efficiency of bill collection and search.
[0048] The embodiments of the present invention will be described in detail below in combination with the above steps.
[0049] Step S101: Establish a bill directory of the target financial product, where the bill directory includes at least: a plurality of bill files.
[0050] In the embodiment of the present invention, a statement directory (i.e., the bill directory in this embodiment) of the target financial product (such as a fund) can be newly created on a server (such as an FTP (File Transfer Protocol Server) server), and the bill directory includes: a plurality of bill files (i.e., statement files).
[0051] Optionally, the steps of establishing a bill directory for the target financial product include: establishing a bill directory for the target financial product based on a preset establishment strategy, where the bill directory at least includes: reconciliation date, and identification of the opening institution; determining the identification of the opening institution corresponding to the opening institution information carried in the bill file to obtain the target opening institution identification; and uploading the bill file to the bill directory indicated by the target opening institution identification.
[0052] In an embodiment of the present invention, based on a preset establishment strategy (for example, a bill directory can be constructed with the reconciliation date (for example, the last day of each quarter) and the name of the opening institution), a bill directory for the target financial product is established. The bill directory may include: reconciliation date, identification of the opening institution, etc. Subsequently, the identification of the opening institution corresponding to the opening institution information carried in the bill file can be determined to obtain the target opening institution identification, and the bill file is uploaded to the bill directory indicated by the target opening institution identification (that is, the statement file can be uploaded to the bill directory of the corresponding opening institution name).
[0053] Step S102: Scan the bill directory, upload the bill file to a preset document platform, and store the file identification information and file attribute information in a preset verification system, where the file identification information is the identification information obtained after image recognition of the bill file, and the file attribute information at least includes: platform identification.
[0054] In an embodiment of the present invention, a timed automatic execution job can be added to scan the bill directory on the server according to business rules (for example, scan every day in the first month of each quarter, and on the last working day of each week in non-first months of each quarter), and upload the corresponding bill file to the electronic image and document service platform (i.e., the preset document platform), which can realize online statement archiving. At the same time, relevant reconciliation dates, file directories, file names, and electronic image and document service platform information can be stored in the preset verification system (that is, the file identification information and file attribute information are stored in the preset verification system. The file identification information is the identification information obtained after image recognition of the bill file, and the file attribute information includes: platform identification, etc.), which can facilitate business personnel to download and view files at any time.
[0055] Optionally, after scanning the bill catalog and uploading the bill file to a preset document platform, it further includes: when the bill file is successfully uploaded to the preset document platform, adding first record information to the file identification information and adding second record information to the file attribute information, where the first record information includes at least one of the following: identification serial number, platform identifier, unbound status, operation time, and the second record information includes at least one of the following: file number, file path, file name, upload date, platform identifier, uploaded status, identification serial number; when the bill file fails to be uploaded to the preset document platform, adding third record information to the file identification information and adding fourth record information to the file attribute information, where the third record information includes at least one of the following: identification serial number, unbound status, operation time, and the fourth record information includes at least one of the following: file number, file path, file name, upload date, non-uploaded status, identification serial number.
[0056] In an embodiment of the present invention, when the bill file is successfully uploaded to the preset document platform, a record information (i.e., the first record information) can be newly added to the file identification information (such as the Dat_trd_acc_openfund table), and this information includes at least one of the following: seq (identification serial number), busiid (i.e., the platform identifier, the information identifier stored in the electronic image and document service platform, and the corresponding file can be found on the system through this identifier), binding_statu (identified by 0 as unbound) (i.e., setting the binding status to unbound), opt_time (operation time), etc.; a record information (i.e., the second record information) is newly added to the file attribute information (such as the Dat_trd_acc_openfund_file table), and this information includes at least one of the following: file_id (file number), file_dir (file path, i.e., the newly added directory), file_name (file name), data_date (upload date), busiid (platform identifier), status (identified by 1 as having uploaded to the electronic image and document service platform) (i.e., setting the upload status to the uploaded status), seq (identification serial number), etc.
[0057] In the case where the bill file fails to be uploaded to the preset document platform, a record information (i.e., the third record information) is added to the file identification information (such as the Dat_trd_acc_openfund table), and this information includes at least one of the following: seq (identification serial number), binding_statu (identified by 0 as unbound) (i.e., setting the binding status to the unbound status), opt_time (operation time), etc.; a record information (i.e., the fourth record information) is added to the file attribute information (such as the Dat_trd_acc_openfund_file table), and this information includes at least one of the following: file_id (file number), file_dir (file path, i.e., the newly added directory), file_name (file name), data_date (upload date), status (identified by 5 as failed to upload to the electronic image and document service platform) (i.e., setting the upload status to the unuploaded status), seq (identification serial number), etc.
[0058] Step S103, obtain the unrecognized bill file from the preset document platform indicated by the platform identifier to obtain the target bill file.
[0059] Optionally, the step of obtaining the unrecognized bill file from the preset document platform indicated by the platform identifier to obtain the target bill file includes: scanning the file attribute information to determine the bill file with the upload status as the uploaded status and the platform identifier not being empty in the file attribute information; obtaining the target bill file in the preset document platform indicated by the platform identifier.
[0060] In the embodiment of the present invention, the records that have not been OCR-recognized in the system can be automatically scanned (i.e., by scanning the file attribute information to determine the bill file with the upload status as the uploaded status and the platform identifier not being empty in the file attribute information), and then, the target bill file (i.e., the bill file that has not been OCR-recognized) in the preset document platform indicated by the platform identifier is obtained.
[0061] Step S104, recognize the target bill file to obtain the financial account information corresponding to the target bill file.
[0062] In the embodiment of the present invention, the target bill file can be uploaded to the OCR recognition system for recognition through the platform identifier. The OCR recognition system will obtain the corresponding bill file from the electronic image and document service platform according to the platform identifier. In this embodiment, the recognition rule can be set to recognize the characters (for example, digital type characters) after "financial account" in the bill file, and extract and return the financial account information (recoid) in the document.
[0063] Optionally, after identifying the target bill file and obtaining the financial account information corresponding to the target bill file, it further includes: when the identification of the target bill file is successful, updating the first information in the file attribute information and updating the second information in the file identification information, where the identification status in the first information is updated to the parsed status, adding the financial account information to the first information, increasing the identification times in the first information by a preset value, adding the identification start time and the identification end time to the first information, and adding the financial account information to the second information; when the identification of the target bill file fails, updating the third information in the file attribute information, where the identification status in the third information is updated to the uploaded status, increasing the identification times in the third information by a preset value, adding the identification start time, the identification end time, and the error information to the third information.
[0064] In an embodiment of the present invention, when the identification of the target bill file is successful, the first information in the file attribute information (such as Dat_trd_acc_openfund_file) is updated, and this information includes at least one of the following: status (identified by 4 for ocr parsed) (i.e., the identification status is updated to the parsed status), recoid (the identified financial account information), ocr_times (the identification times are increased by a preset value (which can be set to 1)), ocr_stimes (the start time of ocr identification), ocr_etimes (the end time of ocr identification), etc.; the second information in the file identification information (such as Dat_trd_acc_openfund) is updated, and this information includes at least one of the following: invest_acnt (the identified financial account information), etc.
[0065] In the case where the identification of the target bill file fails, the third information in the file attribute information (such as Dat_trd_acc_openfund_file) is updated, and this information includes at least one of the following: status (identified by 2 for ocr uploaded ocr) (i.e., the identification status is updated to the uploaded status), ocr_times (the identification times are increased by a preset value), ocr_stimes (the start time of ocr identification), ocr_etimes (the end time of ocr identification), err_msg (the error information), etc.
[0066] Step S105, based on the platform identifier and the financial account information, update the file identification information and the file attribute information.
[0067] Optionally, the step of updating the file identification information and the file attribute information based on the platform identifier and the financial account information includes: querying, based on the platform identifier, the file directory of the bill file corresponding to the platform identifier in the file attribute information; querying the account opening institution identifier in the file directory, and updating the institution code in the file identification information based on the institution code of the account opening institution indicated by the account opening institution identifier.
[0068] In the embodiment of the present invention, processing can be performed according to the incoming parameters (the busiid electronic image and document service platform key value and the financial account information identified by invest_acnt) (that is, the file identification information and the file attribute information can be updated based on the platform identifier and the financial account information). Specifically, the corresponding file directory can be found in the file attribute information through the platform identifier (that is, querying the file directory of the bill file corresponding to the platform identifier in the file attribute information), querying the account opening institution name in the directory (that is, querying the account opening institution identifier in the file directory), and correspondingly finding the account opening institution code to update the pset account opening institution code in the file identification information (that is, updating the institution code in the file identification information based on the institution code of the account opening institution indicated by the account opening institution identifier).
[0069] Optionally, the step of updating the file identification information and the file attribute information based on the platform identifier and the financial account information further includes: judging, based on the financial account information, whether the financial account is empty; in the case where the financial account is empty, updating the binding status in the file identification information to the unbound status and updating the reconciliation date in the file identification information; in the case where the financial account is not empty, judging whether the user account corresponding to the financial account information exists; in the case where the user account does not exist, updating the binding status in the file identification information to the unbound status and updating the reconciliation date in the file identification information; in the case where the user account exists, judging whether the financial portfolio corresponding to the user account is unique; in the case where the financial portfolio is unique, updating the financial portfolio code, institution code, and region code in the file identification information, and updating the binding status in the file identification information to the bound status; in the case where the financial portfolio is not unique, determining the combined information corresponding to the common account filing records of multiple financial portfolios; based on the combined information, updating the financial portfolio code, institution code, and region code in the file identification information, and updating the binding status in the file identification information to the bound status.
[0070] In an embodiment of the present invention, based on the financial account information, it can be determined whether the financial account is empty (i.e., determine whether the financial account identified by invest_acnt is empty). When it is empty, update the binding_status (identified by 0 for unbound) and rcheckdate (reconciliation date, sub-directory name of the file directory) of dat_trd_acc_openfund (when the financial account is empty, update the binding status in the file identification information to the unbound status and update the reconciliation date in the file identification information); when it is not empty, determine whether the customer account corresponding to the financial account exists (i.e., when the financial account is not empty, determine whether the user account corresponding to the financial account information exists).
[0071] In the case where the user account does not exist, update the binding status in the file identification information to the unbound status and update the reconciliation date in the file identification information. When it exists, then determine whether the combination corresponding to the customer account is unique (i.e., when the user account exists, determine whether the financial combination corresponding to the user account is unique).
[0072] When the financial combination is unique, update the fund_code (combination code), organ_code (corresponding manager of the combination), binding_status (bound), and area_code (corresponding area of the combination) in dat_trd_acc_openfund (i.e., when the financial combination is unique, update the financial combination code, institution code, and area code in the file identification information and update the binding status in the file identification information to the bound status). When the combination is not unique, the combination information corresponding to the common account filing record of multiple financial combinations can be determined; based on the combination information, update the financial combination code, institution code, and area code in the file identification information and update the binding status in the file identification information to the bound status. For example, for the reconciliation of fund products, specifically, based on the securities held by the combination, in the valuation table of the combination on the query date, take the securities with the market being the "open-end fund market" and the security type being "fund" or "fund special account", and when the number of accounts in its accounting is not 0, if there are multiple combinations in the combination, then add a record corresponding to the combination in dat_trd_acc_openfund; if the number of accounts in the accounting is 0, then find the combination information corresponding to the corresponding common account filing record and update the fund_code (combination code), organ_code (corresponding manager of the combination), binding_status (bound), and area_code (corresponding area of the combination) in dat_trd_acc_openfund.
[0073] Optionally, after updating the file identification information and file attribute information based on the platform identifier and financial account information, the method further includes: receiving a verification request, where the verification request is a request configured through a pre-configured front-end menu, and the verification request at least includes: user account identifier, reconciliation date, and settlement institution identifier; based on the verification request, matching the user account identifier, reconciliation date, and settlement institution identifier with the financial combination identifier, reconciliation date, and account-opening institution identifier in the file identification information to obtain a matching result; and determining that the verification is successful when the matching result indicates a successful match.
[0074] In an embodiment of the present invention, a front-end menu can be added to facilitate business personnel to query, upload, modify, and export statement files at any time, receive verification requests configured through the front-end menu (user account identifier, reconciliation date, settlement institution identifier, etc. can be configured), and then, according to the user account identifier, reconciliation date, and settlement institution identifier, match the same "financial combination identifier, reconciliation date, and account-opening institution identifier" in the "corresponding" records in the "open-ended fund statement" menu. When the matching result indicates a successful match, it is determined that the verification is successful. It is also possible to perform data linkage with the "securities balance reconciliation" in the menu to facilitate business personnel to verify information online.
[0075] Optionally, configure a preset email template, where the preset email template at least includes: sender mailbox parameters, recipient mailbox parameters, and attachment parameters; construct a to-be-sent email based on the preset email template and the bill file; and send the to-be-sent email based on a preset configuration policy.
[0076] In an embodiment of the present invention, corresponding email template configurations (i.e., configure a preset email template) can be set in the email sending template. The configured preset email template includes email sending-related parameters such as the sender mailbox, recipient mailbox, and attachment. Then, based on the preset email template and the bill file, a to-be-sent email can be constructed, and the system will send the to-be-sent email regularly according to the configuration rules (i.e., the preset configuration policy).
[0077] The following will be described in detail in combination with another optional specific implementation manner.
[0078] An embodiment of the present invention provides a statement verification method based on OCR recognition, including: an electronic image and document service platform module, an OCR recognition module, a statement information processing module, and a sending email configuration module, where
[0079] (1), the electronic image and document service platform module;
[0080] A statement reconciliation directory can be newly created on a server (e.g., an FTP (File Transfer Protocol Server)), and the directory rule can be set as the statement reconciliation date (e.g., the last day of each quarter) and the name of the account opening institution. After that, the statement reconciliation files are uploaded to the statement reconciliation directory corresponding to the name of the account opening institution.
[0081] By adding an asset custody accounting valuation scheduled automatic execution job, the statement reconciliation directory on the server can be scanned according to business rules (e.g., scanning every day in the first month of each quarter, and the last working day of each week in non - first months of each quarter), and the corresponding statement reconciliation files are uploaded to the electronic imaging and document service platform to achieve online statement reconciliation archiving. At the same time, the relevant statement reconciliation date, file directory, file name, and electronic imaging and document service platform information are stored in the system (e.g., an OCR recognition information table for statement reconciliations can be set to store OCR recognition - related information, and a statement reconciliation file table can be set to store file information), which can facilitate business personnel to download and view the files at any time.
[0082] 1), when the upload to the electronic imaging and document service platform is successful:
[0083] A new record can be added to the Dat_trd_acc_openfund table (i.e., the identification information table), and the information includes at least one of the following: seq (identification serial number), busiid (information identifier stored in the electronic imaging and document service platform, and the corresponding file can be found in the system through this identifier), binding_statu (identified by 0 for unbound), opt_time (operation time).
[0084] A new record can be added to the Dat_trd_acc_openfund_file table (i.e., the statement reconciliation file table), and the information includes at least one of the following: file_id (file number), file_dir (file path, i.e., the newly added directory), file_name (file name), data_date (upload date), busiid (platform identifier), status (1 - uploaded to the electronic imaging and document service platform) (i.e., setting the upload status to the uploaded status), seq (identification serial number).
[0085] 2), when the upload to the electronic imaging and document service platform fails:
[0086] A new record can be added to the Dat_trd_acc_openfund table, and the information includes at least one of the following: seq (identification serial number), binding_statu (identified by 0 for unbound) (i.e., setting the binding status to the unbound status), opt_time (operation time).
[0087] A new record can be added to the Dat_trd_acc_openfund_file table, and this information includes at least one of the following: file_id (file number), file_dir (file path, i.e., the newly added directory), file_name (file name), data_date (upload date), status (identified by 5 for failure to upload to the electronic image and document service platform) (i.e., setting the upload status to the non-uploaded status), seq (identification serial number).
[0088] (2), OCR recognition module;
[0089] The asset custody accounting valuation scheduled job can automatically scan the records in the system that have not undergone OCR recognition (i.e., the records in Dat_trd_acc_openfund_file with the upload status being the uploaded status (i.e., status being successful in uploading to the electronic image and document service platform) and the platform identifier not being empty (i.e., busiid not being empty)).
[0090] The statement file can be uploaded to the OCR recognition system for recognition through the platform identifier busiid. The OCR recognition system can obtain the corresponding statement file from the electronic image and document service platform based on busiid. The recognition rule can be set to recognize the characters after "financial account" in the statement file, extract and return the account information recoid in the document, and can recognize digital type information. In the case of special character scenarios, the account content does not need to be returned.
[0091] 1), Recognition successful:
[0092] The status in Dat_trd_acc_openfund_file can be updated (identified by 4 for ocr having been parsed) (i.e., the recognition status is updated to the parsed status), recoid (recognized financial account information), ocr_times (the recognition times are increased by a preset value (which can be set to 1)), ocr_stimes (the start time of ocr recognition), ocr_etimes (the end time of ocr recognition), etc.
[0093] The invest_acnt (recognized financial account information), etc. in Dat_trd_acc_openfund can be updated.
[0094] 2), Recognition failed:
[0095] It is possible to update the status (identified by 2 for OCR uploaded) in Dat_trd_acc_openfund_file (i.e., update the recognition status to the uploaded status), ocr_times (increase the recognition times by a preset value), ocr_stimes (start time of OCR recognition), ocr_etimes (end time of OCR recognition), err_msg (error message), etc.
[0096] (3), the statement information processing module;
[0097] The asset custody accounting valuation stored procedure can be processed according to the parameters passed in by the OCR recognition module (i.e., the busiid electronic image and document service platform key value and the financial account information recognized by invest_acnt).
[0098] It is possible to find the corresponding file directory in dat_trd_acc_openfund_file through the platform identifier busiid. The name of the last layer of the directory inside is the name of the account opening institution, and the account opening institution code can be found correspondingly to update the pset account opening institution code in dat_trd_acc_openfund.
[0099] Judge whether the financial account number recognized by invest_acnt is empty. When it is empty, update the binding_status in dat_trd_acc_openfund (identified by 0 for unbound) and rcheckdate (reconciliation date, the secondary directory name of the file directory); when it is not empty, judge whether the corresponding customer account number of the financial account exists.
[0100] In the case where the user account does not exist, update the binding_status (0 for unbound) and rcheckdate (reconciliation date, the secondary directory name of the file directory) in dat_trd_acc_openfund; when it exists, then judge whether the corresponding combination of the customer account number is unique.
[0101] When the combination is unique, update fund_code (combination code), organ_code (corresponding manager of the combination), binding_status (already bound), and area_code (corresponding area of the combination) in dat_trd_acc_openfund; when the combination is not unique, taking the fund statement as an example, based on the securities held by the combination, in the valuation table of the combination on the query date, for securities with the market being the "open-end fund market" and the security type being "fund" or "fund special account", when the quantity in its accounting account is not 0, if there are multiple combinations, new records corresponding to the combinations are added in dat_trd_acc_openfund; when the quantity in the accounting account is 0, find the combination information corresponding to the corresponding shared account filing record and update fund_code (combination code), organ_code (corresponding manager of the combination), binding_status (already bound), and area_code (corresponding area of the combination) in dat_trd_acc_openfund.
[0102] In this embodiment, a front-end menu can also be added to facilitate business personnel to query, upload, modify, and export statement files at any time, receive reconciliation requests configured through the front-end menu (user account identification, reconciliation date, settlement institution identification, etc. can be configured). After that, according to the user account identification, reconciliation date, and settlement institution identification, match the same "financial combination identification, reconciliation date, opening institution identification" in the "already corresponding" records in the "open-end fund statement" menu. When the matching result indicates successful matching, it is determined that the reconciliation is successful. Data linkage can also be performed with the "securities balance reconciliation" in the same menu to facilitate business personnel to reconcile information online.
[0103] (4), the email sending configuration module;
[0104] Corresponding email template configurations can be set in the email sending template, mainly involving email sending-related parameter configurations such as the sender's mailbox, recipient's mailbox, and attachments. The system will send corresponding emails regularly according to the configuration rules.
[0105] In the embodiment of the present invention, by increasing the OCR requirements for open-end fund statements, online statement archiving can be achieved, and the workload of manual collection, sorting, reconciliation, and distribution of statements can also be reduced, which is beneficial to improving the efficiency of statement collection, search, and distribution, and laying a foundation for the total-to-total docking between financial institutions and opening institutions and improving the management efficiency of financial institutions.
[0106] Embodiment Two
[0107] A statement management device provided in this embodiment includes multiple implementation units, and each implementation unit corresponds to each implementation step in Embodiment One above.
[0108] Figure 2 It is a schematic diagram of an optional bill management device according to an embodiment of the present invention. As Figure 2 shown, the management device may include: a creation unit 20, an upload unit 21, a retrieval unit 22, an identification unit 23, and an update unit 24. Among them,
[0109] The creation unit 20 is used to create a bill directory for the target financial product. Among them, the bill directory at least includes: a plurality of bill files;
[0110] The upload unit 21 is used to scan the bill directory, upload the bill files to a preset document platform, and store the file identification information and file attribute information in a preset verification system. Among them, the file identification information is the identification information obtained after performing image recognition on the bill files, and the file attribute information at least includes: a platform identifier;
[0111] The retrieval unit 22 is used to retrieve the unrecognized bill files from the preset document platform indicated by the platform identifier to obtain the target bill files;
[0112] The identification unit 23 is used to identify the target bill files to obtain the financial account information corresponding to the target bill files;
[0113] The update unit 24 is used to update the file identification information and the file attribute information based on the platform identifier and the financial account information.
[0114] The above management device can create a bill directory for the target financial product through the creation unit 20, scan the bill directory through the upload unit 21, upload the bill files to a preset document platform, and store the file identification information and file attribute information in a preset verification system. Through the retrieval unit 22, retrieve the unrecognized bill files from the preset document platform indicated by the platform identifier to obtain the target bill files. Through the identification unit 23, identify the target bill files to obtain the financial account information corresponding to the target bill files. Through the update unit 24, update the file identification information and the file attribute information based on the platform identifier and the financial account information. In the embodiment of the present invention, the bill files can be uploaded to the preset document platform by scanning the bill directory, and the file identification information and file attribute information of the bill files can be stored in the preset verification system. After that, the unrecognized bill files in the historical process can be identified to obtain the corresponding financial account information, and the file identification information and file attribute information can be automatically updated according to the platform identifier and the financial account information. This can significantly reduce the management process involving manual participation, greatly reduce the workload of manual processing, and at the same time, improve the efficiency of bill collection and search, thereby solving the technical problem in the related art that manual management of bill files leads to low efficiency of bill collection and search.
[0115] Optionally, the establishment unit includes: a first establishment module, configured to establish a bill directory of a target financial product based on a preset establishment policy, where the bill directory at least includes: a reconciliation date and an opening institution identifier; a first determination module, configured to determine an opening institution identifier corresponding to the opening institution information carried in the bill file to obtain a target opening institution identifier; and a first upload module, configured to upload the bill file to the bill directory indicated by the target opening institution identifier.
[0116] Optionally, the management device further includes: a first addition module, configured to, after scanning the bill directory and uploading the bill file to a preset document platform, and in the case of successfully uploading the bill file to the preset document platform, add first record information to the file identification information and add second record information to the file attribute information, where the first record information includes at least one of the following: an identification serial number, a platform identifier, an unbounded status, and an operation time, and the second record information includes at least one of the following: a file number, a file path, a file name, an upload date, a platform identifier, an uploaded status, and an identification serial number; a second addition module, configured to, in the case of failing to upload the bill file to the preset document platform, add third record information to the file identification information and add fourth record information to the file attribute information, where the third record information includes at least one of the following: an identification serial number, an unbounded status, and an operation time, and the fourth record information includes at least one of the following: a file number, a file path, a file name, an upload date, a non-uploaded status, and an identification serial number.
[0117] Optionally, the acquisition unit includes: a second determination module, configured to scan the file attribute information to determine a bill file whose upload status in the file attribute information is an uploaded status and whose platform identifier is not empty; and a first acquisition module, configured to acquire a target bill file in the preset document platform indicated by the platform identifier.
[0118] Optionally, the management device further includes: a first update module, configured to, after identifying the target bill file and obtaining financial account information corresponding to the target bill file, and in the case of successfully identifying the target bill file, update first information in the file attribute information and update second information in the file identification information, where the identification status in the first information is updated to a parsed status, financial account information is added to the first information, the identification times in the first information are increased by a preset value, an identification start time and an identification end time are added to the first information, and financial account information is added to the second information; a second update module, configured to, in the case of failing to identify the target bill file, update third information in the file attribute information, where the identification status in the third information is updated to an uploaded status, the identification times in the third information are increased by a preset value, an identification start time, an identification end time, and error information are added to the third information.
[0119] Optionally, the update unit includes: a first query module, configured to query, based on the platform identifier, a file directory of a bill file corresponding to the platform identifier in the file attribute information; a third update module, configured to query an account opening institution identifier in the file directory, and update an institution code in the file identification information based on an institution code of the account opening institution indicated by the account opening institution identifier.
[0120] Optionally, the update unit further includes: a first determination module, configured to determine, based on the financial account information, whether the financial account is empty; a fourth update module, configured to, when the financial account is empty, update a binding status in the file identification information to an unbound status, and update a reconciliation date in the file identification information; a second determination module, configured to, when the financial account is not empty, determine whether a user account corresponding to the financial account information exists; a fifth update module, configured to, when the user account does not exist, update the binding status in the file identification information to the unbound status, and update the reconciliation date in the file identification information; a third determination module, configured to, when the user account exists, determine whether a financial portfolio corresponding to the user account is unique; a sixth update module, configured to, when the financial portfolio is unique, update a financial portfolio code, an institution code, and a region code in the file identification information, and update the binding status in the file identification information to a bound status; a third determination module, configured to, when the financial portfolio is not unique, determine combined information corresponding to a common account filing record of multiple financial portfolios; a seventh update module, configured to update the financial portfolio code, the institution code, and the region code in the file identification information based on the combined information, and update the binding status in the file identification information to the bound status.
[0121] Optionally, the management device further includes: a first setting module, configured to set a front-end menu after updating the file identification information and the file attribute information based on the platform identifier and the financial account information; a first receiving module, configured to receive a verification request, where the verification request is a request configured through a pre-configured front-end menu, and the verification request at least includes: a user account identifier, a reconciliation date, and a settlement institution identifier; a first matching module, configured to match, based on the verification request, the user account identifier, the reconciliation date, and the settlement institution identifier with a financial portfolio identifier, a reconciliation date, and an account opening institution identifier in the file identification information to obtain a matching result; a fourth determination module, configured to determine that the verification is successful when the matching result indicates a successful match.
[0122] The above management device may further include a processor and a memory. The above establishment unit 20, upload unit 21, acquisition unit 22, identification unit 23, update unit 24, etc. are all stored in the memory as program units, and the processor executes the above program units stored in the memory to implement corresponding functions.
[0123] The above-mentioned processor includes a kernel, which retrieves corresponding program units from the memory. One or more kernels can be set, and by adjusting the kernel parameters, the file identification information and file attribute information are updated based on the platform identifier and the financial account information.
[0124] The above-mentioned memory may include non-permanent memory in a computer-readable medium, in the form of random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash memory (flash RAM), and the memory includes at least one storage chip.
[0125] The present application also provides a computer program product, which is adapted to execute a program initialized with the following method steps when executed on a data processing device: establishing a bill directory of a target financial product, scanning the bill directory, uploading bill files to a preset document platform, storing the file identification information and file attribute information in a preset verification system, obtaining an unrecognized bill file from the preset document platform indicated by the platform identifier to obtain a target bill file, identifying the target bill file to obtain the financial account information corresponding to the target bill file, and updating the file identification information and file attribute information based on the platform identifier and the financial account information.
[0126] According to another aspect of an embodiment of the present invention, there is also provided a computer-readable storage medium, which includes a stored computer program, wherein when the computer program runs, it controls the device where the computer-readable storage medium is located to execute the above-mentioned bill management method.
[0127] According to another aspect of an embodiment of the present invention, there is also provided an electronic device, including one or more processors and a memory, where the memory is used to store one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the above-mentioned bill management method.
[0128] Figure 3 is a hardware structural block diagram of an electronic device (or mobile device) for a bill management method according to an embodiment of the present invention. As Figure 3 shown, the electronic device may include one or more (shown as 102a, 102b,..., 102n in the figure) processors 102 (the processor 102 may include, but is not limited to, a processing device such as a microprocessor MCU or a field programmable gate array FPGA), and a memory 104 for storing data. In addition, it may further include: a display, an input / output interface (I / O interface), a universal serial bus (USB) port (which may be included as one of the ports of the I / O interface), a network interface, a keyboard, a power supply, and / or a camera. Those of ordinary skill in the art can understand, Figure 3The structure shown is only illustrative and does not limit the structure of the above-mentioned electronic device. For example, the electronic device may also include more or fewer components than those shown in Figure 3 or have a different configuration from that shown in Figure 3 .
[0129] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.
[0130] In the above embodiments of the present invention, the descriptions of the respective embodiments have their own emphases. For parts not detailed in a certain embodiment, reference may be made to the relevant descriptions of other embodiments.
[0131] In the several embodiments provided by the present application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only illustrative. For example, the division of the units can be a logical function division. In actual implementation, there may be other division methods. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the displayed or discussed couplings or direct couplings or communication connections to each other can be through some interfaces. The indirect couplings or communication connections of the units or modules can be in electrical or other forms.
[0132] The units described as separate components may or may not be physically separated. The components shown as units may or may not be physical units, that is, they can be located in one place or distributed to multiple units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0133] In addition, the functional units in the various embodiments of the present invention can be integrated in a processing unit, or each unit can exist physically alone, or two or more units can be integrated in one unit. The above integrated units can be implemented in the form of hardware or in the form of software functional units.
[0134] When the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: various media that can store program codes, such as USB flash drives, read-only memories (ROMs), random access memories (RAMs), mobile hard disks, magnetic disks, or optical discs.
[0135] The foregoing are only the preferred embodiments of the present invention. It should be noted that for those of ordinary skill in the art, without departing from the principle of the present invention, several improvements and refinements can be made, and these improvements and refinements should also be regarded as the protection scope of the present invention.
Claims
1. A method for managing bills, characterized in that, Including: Establish a bill directory for the target financial product, where at least the following are included in the bill directory: multiple bill files; Scan the bill directory, upload the bill files to a preset document platform, and store the file identification information and file attribute information in a preset verification system, where the file identification information is the identification information obtained after image recognition of the bill files, and at least the following is included in the file attribute information: platform identifier; Obtain the unrecognized bill files from the preset document platform indicated by the platform identifier to obtain target bill files; Identify the target bill files to obtain the financial account information corresponding to the target bill files; Update the file identification information and the file attribute information based on the platform identifier and the financial account information; The step of updating the file identification information and the file attribute information based on the platform identifier and the financial account information includes: Based on the financial account information, determine whether the financial account is empty; In the case where the financial account is empty, update the binding status in the file identification information to the unbound status and update the reconciliation date in the file identification information; in the case where the financial account is not empty, determine whether the user account corresponding to the financial account information exists; In the case where the user account does not exist, update the binding status in the file identification information to the unbound status and update the reconciliation date in the file identification information; in the case where the user account exists, determine whether the financial portfolio corresponding to the user account is unique; In the case where the financial portfolio is unique, update the financial portfolio code, institution code, and region code in the file identification information, and update the binding status in the file identification information to the bound status; in the case where the financial portfolio is not unique, determine the combined information corresponding to the common account filing records of the multiple financial portfolios; Based on the combined information, update the financial portfolio code, institution code, and region code in the file identification information, and update the binding status in the file identification information to the bound status.
2. The management method according to claim 1, characterized in that, The step of establishing a bill directory for the target financial product includes: Based on a preset establishment strategy, establish the bill directory for the target financial product, where at least the following are included in the bill directory: reconciliation date, opening institution identifier; Determine the opening institution identifier corresponding to the opening institution information carried by the bill file to obtain the target opening institution identifier; Upload the bill files to the bill directory indicated by the target opening institution identifier.
3. The management method according to claim 1, wherein After scanning the bill directory and uploading the bill files to a preset document platform, it further includes: In the case where the bill file is successfully uploaded to the preset document platform, add first record information to the file identification information and add second record information to the file attribute information, where the first record information includes at least one of the following: identification serial number, platform identifier, unbound status, operation time, and the second record information includes at least one of the following: file number, file path, file name, upload date, platform identifier, uploaded status, identification serial number; In the case where the bill file fails to be uploaded to the preset document platform, add third record information to the file identification information and add fourth record information to the file attribute information, where the third record information includes at least one of the following: identification serial number, unbound status, operation time, and the fourth record information includes at least one of the following: file number, file path, file name, upload date, non-uploaded status, identification serial number.
4. The management method according to claim 1, characterized in that, The steps of obtaining the target bill file by retrieving the unrecognized bill file from the preset document platform indicated by the platform identifier include: Scanning the file attribute information to determine the bill file with the upload status as the uploaded status and the platform identifier not being empty in the file attribute information; Retrieving the target bill file from the preset document platform indicated by the platform identifier.
5. The management method according to claim 1, wherein After identifying the target bill file and obtaining the financial account information corresponding to the target bill file, it further includes: In the case where the target bill file is successfully identified, update the first information in the file attribute information and update the second information in the file identification information, where update the identification status in the first information to the parsed status, add the financial account information to the first information, increase the number of identification times in the first information by a preset value, add the identification start time and identification end time to the first information, and add the financial account information to the second information; In the case where the target bill file is identified as failed, update the third information in the file attribute information, where update the identification status in the third information to the uploaded status, increase the number of identification times in the third information by the preset value, and add the identification start time, identification end time, and error information to the third information.
6. The management method according to claim 1, characterized in that, The steps of updating the file identification information and the file attribute information based on the platform identifier and the financial account information include: Based on the platform identifier, query the file directory of the bill file corresponding to the platform identifier in the file attribute information; Query the opening institution identifier in the file directory, and update the institution code in the file identification information based on the institution code of the opening institution indicated by the opening institution identifier.
7. The management method according to claim 1, characterized in that, After updating the file identification information and the file attribute information based on the platform identifier and the financial account information, it further includes: Receive a verification request, where the verification request is a request configured through a pre-configured front-end menu, and the verification request at least includes: a user account identifier, a reconciliation date, and a settlement institution identifier; Based on the verification request, match the user account identifier, the reconciliation date, and the settlement institution identifier with the financial combination identifier, the reconciliation date, and the account-opening institution identifier in the document identification information to obtain a matching result; When the matching result indicates successful matching, determine that the verification is successful.
8. A bill management device, characterized in that, Include: A establishing unit, configured to establish a bill directory of a target financial product, where at least the following are included under the bill directory: a plurality of bill files; An uploading unit, configured to scan the bill directory, upload the bill files to a preset document platform, and store the document identification information and the document attribute information in a preset verification system, where the document identification information is identification information obtained after image recognition of the bill files, and at least the following is included in the document attribute information: a platform identifier; A obtaining unit, configured to obtain the bill files that have not been recognized from the preset document platform indicated by the platform identifier to obtain target bill files; An identifying unit, configured to identify the target bill files to obtain financial account information corresponding to the target bill files; An updating unit, configured to update the document identification information and the document attribute information based on the platform identifier and the financial account information; The updating unit includes: a first judgment module, configured to judge whether a financial account is empty based on the financial account information; a fourth updating module, configured to, when the financial account is empty, update the binding status in the document identification information to an unbound status and update the reconciliation date in the document identification information; a second judgment module, configured to, when the financial account is not empty, judge whether a user account corresponding to the financial account information exists; a fifth updating module, configured to, when the user account does not exist, update the binding status in the document identification information to an unbound status and update the reconciliation date in the document identification information; a third judgment module, configured to, when the user account exists, judge whether the financial combination corresponding to the user account is unique; a sixth updating module, configured to, when the financial combination is unique, update the financial combination code, institution code, and region code in the document identification information and update the binding status in the document identification information to a bound status; a third determination module, configured to, when the financial combination is not unique, determine combination information corresponding to a common account filing record of multiple financial combinations; a seventh updating module, configured to update the financial combination code, institution code, and region code in the document identification information based on the combination information and update the binding status in the document identification information to a bound status.
9. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored computer program, where when the computer program runs, it controls the device where the computer-readable storage medium is located to execute the bill management method according to any one of claims 1 to 7.
10. An electronic device, characterized in that, Comprising one or more processors and a memory, the memory being used to store one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method for managing a bill according to any one of claims 1 to 7.
Citation Information
Patent Citations
Bill management method and electronic equipment
CN111199222A