CN114820204A - Financial report processing method and system and financial business processing system - Google Patents

Abstract

The invention discloses a financial statement processing method, a financial statement processing system and a financial business processing system, wherein a first instruction is acquired, and the first instruction is a demand instruction for a user to handle business; calling a first form based on the first instruction; acquiring the user delivery information through the first form to acquire a second form; and performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, marking the information not meeting the verification rule until the contents of all cells pass the verification rule to obtain a third form, and inserting the third form into a database for storage. The invention has the advantages that the processing of the form is converted into the program of automatic processing of the computer, so that the accuracy of data processing and the efficiency of data processing can be improved; the statistical analysis meeting various parameter indexes can be realized through flexible configuration combination.

Description

Financial report processing method and system and financial business processing system

Technical Field

The invention relates to the technical field of financial data processing, in particular to a financial statement processing method and system and a financial business processing system.

Background

The green finance refers to financial services provided for project investment and financing, project operation, risk management and the like in the fields of environmental protection, energy conservation, clean energy, green traffic, green buildings and the like, and the economic activities of supporting environment improvement, coping with climate change and resource saving and efficient utilization are realized. The green finance can promote environmental protection and treatment, and guide resources to flow from high-pollution and high-energy-consumption industries to departments with advanced concepts and technologies. The current green financial policy in China is steadily promoted, and the method has great development in the fields of credit, bond, fund and the like.

However, in the prior art, when the report is processed by the green finance, the filled report is manually processed correspondingly, but when the report is processed manually by the method for a long time, the accuracy of data for processing a large number of reports is low, and the processing efficiency is not high.

In view of this, the present application is specifically made.

Disclosure of Invention

The technical problem to be solved by the invention is that in the prior art, the timeliness of manual form processing is poor, and the precision is not high, and the invention aims to provide a financial statement processing method, a financial statement processing system and a financial business processing system, which can improve the form processing speed and increase the form processing efficiency.

The invention is realized by the following technical scheme:

a financial statement processing method comprises the following steps:

s1: acquiring a first instruction, wherein the first instruction is a requirement instruction for a user to handle a service;

s2: based on the first instruction, calling a first form;

s3: acquiring the user submission information through the first form to acquire a second form;

s4: and performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, marking the information which does not meet the verification rule, returning to the step S3 until the contents of all the cells pass the verification rule, obtaining a third form, and inserting the third form into a database for storage.

In the traditional business field of financial statement processing, when a form filled by a user is processed, the manual checking and processing process is usually adopted, and the long-term adoption of the method for processing the form can cause the low processing efficiency and the low processing precision; the invention provides a financial statement processing method, which improves the processing speed of the form and increases the efficiency of form processing by automatically verifying the called and filled form and storing the verified form.

Preferably, the first form includes a brief description, a number, a specified bank organization structure, a report posting exel template, a dynamic report database field, a specified type, and a report posting frequency classification.

Preferably, the sub-step of step S4 includes:

mapping the second form into an Excel form to obtain the Excel form;

selecting any line in the Excel form, reading the field of the line, judging whether the field accords with the check rule, if so, mapping the field of the line into another Excel form, otherwise, returning to the step S3;

obtaining a third form until all the line data in the Excel form are traversed and all the line data meet the check rule;

and inserting the third list into a database for storage.

Preferably, the determining whether the field conforms to the check rule specifically includes:

selecting the content in any cell and identifying the content in the cell;

if the cell type is a drop-down list, judging whether the content in the cell is matched with first data, if so, conforming to a verification rule, wherein the first data is dictionary information in a database;

if the cell type is date, judging whether the cell content is the content which needs to be filled, if not, passing the verification rule, if so, verifying the content, and if passing the verification, conforming to the verification rule.

If the cell type is a number, an amount or a character, judging whether the cell content accords with the character, if so, performing regular expression or logic operation or addition and subtraction operation on the cell content to verify, and if the cell type passes the verification, conforming to a verification rule.

Preferably, the verification of the regular expression is to input the cell contents into java for identification verification, and the verification of the logical operation and the verification of the addition and subtraction operation are to introduce and verify a javascript library specification grammar.

Preferably, in step S4, the sub-step of inserting the third form into a database for storage includes:

reading the content in the third form, judging the value type in the content, and converting the character string type into the date type if the content is the date; if the content is a floating point, converting the character string type into a floating point type; if the content is integer, converting the character string type into an integer type; setting corresponding sql preprocessing sentences for each converted type;

if the content is empty or the content is a character string, directly setting an sql preprocessing sentence;

and executing the set sql preprocessing statement, and inserting the third form into a database for storage.

The invention also provides a financial report processing system, which comprises an instruction acquisition module, a form calling module, an information acquisition module and a verification module,

the instruction acquisition module is used for acquiring a first instruction, wherein the first instruction is a requirement instruction for a user to handle a service;

the form calling module is used for calling a first form based on the first instruction;

the information acquisition module is used for acquiring the user submission information through the first form and acquiring a second form;

and the verification module is used for performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, inputting the line of data into the information acquisition module until the contents of all the cells pass the verification rule, acquiring a third form, and inserting the third form into a database for storage.

The invention also provides a financial business processing system, which comprises a report processing module, a data storage module, a statistical analysis module and a display,

the statement processing module includes the financial statement processing system of claim 7 for handling business requirements for the user;

the data storage module is used for storing a third list and data for processing the third list and sending the stored data to the statistical analysis module for analysis;

and the statistical analysis module is used for performing statistical analysis on the stored data and transmitting the analyzed structure to the display for displaying.

Preferably, the service processing system further comprises a permission and log module, wherein the permission and log module is used for storing an operation flow when the report processing module processes the service requirement of the user, and the operation flow comprises all processes of obtaining a third form; and transmitting the operation flow to the statistical analysis module, wherein the statistical analysis module is used for transmitting an analysis structure to a display for displaying after analyzing the operation flow.

Preferably, the service processing system further includes an intelligent identification module, and the intelligent identification module is configured to obtain a third form stored in the data storage module, identify whether the third form is a green project, and transmit a result to the data storage module for storage.

Compared with the prior art, the invention has the following advantages and beneficial effects:

1. according to the financial statement processing method, system and financial business processing system provided by the embodiment of the invention, the processing of the form is converted into a program for automatic processing by a computer, so that the accuracy of data processing and the efficiency of data processing can be improved;

2. the financial report processing method, the financial report processing system and the financial business processing system provided by the embodiment of the invention can quickly design a data acquisition task and a template through simple and flexible configuration so as to adapt to the addition and the change of business requirements; statistical analysis meeting various parameter indexes can be realized through flexible configuration combination; the flexible adjustment of the service module authority can be realized through parameter configuration.

Drawings

In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present invention, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and that for those skilled in the art, other related drawings can be obtained from these drawings without inventive effort.

FIG. 1 is a diagram illustrating a report processing method

FIG. 2 is a schematic diagram of a business processing system

FIG. 3 is a business architecture diagram

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail below with reference to examples and the accompanying drawings, and the exemplary embodiments and descriptions thereof are only used for explaining the present invention and are not used as limiting the present invention.

In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. However, it will be apparent to one of ordinary skill in the art that: it is not necessary to employ these specific details to practice the present invention. In other instances, well-known structures, circuits, materials, or methods have not been described in detail so as not to obscure the present invention.

Throughout the specification, reference to "one embodiment," "an embodiment," "one example," or "an example" means: the particular features, structures, or characteristics described in connection with the embodiment or example are included in at least one embodiment of the invention. Thus, the appearances of the phrases "one embodiment," "an embodiment," "one example" or "an example" in various places throughout this specification are not necessarily all referring to the same embodiment or example. Furthermore, the particular features, structures, or characteristics may be combined in any suitable combination and/or sub-combination in one or more embodiments or examples. Further, those of ordinary skill in the art will appreciate that the illustrations provided herein are for illustrative purposes and are not necessarily drawn to scale. As used herein, the term "and/or" includes any and all combinations of one or more of the associated listed items.

In the description of the present invention, the terms "front", "rear", "left", "right", "upper", "lower", "vertical", "horizontal", "upper", "lower", "inner", "outer", etc. indicate orientations or positional relationships based on the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the referred device or element must have a specific orientation, be constructed in a specific orientation, and be operated, and thus should not be construed as limiting the scope of the present invention.

Example one

In the traditional business of financial statement processing, when the business is used for processing the business statement, the form is generally allocated or processed by manual operation, but when a large number of forms need to be processed, if the forms are continuously processed by manual operation, the processing speed is low and slow, and the processing efficiency is not high;

the embodiment discloses a financial statement processing method, as shown in fig. 1, the method includes the steps of:

s1: acquiring a first instruction, wherein the first instruction is a requirement instruction for a user to handle a service;

in step S1, when the user needs to transact financial services, the user selects corresponding services and fills in corresponding forms according to the prompt on the terminal, each service corresponds to a form that needs to be filled in, and the form is stored in the database of the corresponding service, when the user needs to transact the corresponding service, the user correspondingly pops up the corresponding form by triggering the service, and in step S1, the obtained first instruction is a trigger instruction for selecting which type on the terminal.

S2: based on the first instruction, calling a first form;

in step S2, after receiving an instruction triggered by a user, directly calling a form of a corresponding template from a corresponding database, and sending the form to a client, where the first form includes an introduction, a serial number, a designated bank organization structure, a report exel template, a dynamic report database field, a designated type, and a report frequency classification.

S3: acquiring the user submission information through the first form to acquire a second form;

in step S3, after the first form is displayed on the terminal, the user fills in the relevant content information on the form according to the form, and on the terminal, the content filled in when the user needs to submit can be directly obtained.

S4: and performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, marking the information which does not meet the verification rule, returning to the step S3 until the contents of all the cells pass the verification rule, obtaining a third form, and inserting the third form into a database for storage.

In step S4, when the second form is mapped into the Excel form, the content in the second form will be presented by the data content in each line, the data in each line needs to be verified, when the content meets the verification rule, the verification is passed, if the content does not meet the verification rule, the wrong information needs to be labeled, and the labeled information is returned to the terminal to obtain useful related information again, which specifically includes:

mapping the second form into an Excel form to obtain the Excel form;

selecting any line in the Excel form, reading the field of the line, judging whether the field accords with the check rule, if so, mapping the field of the line into another Excel form, otherwise, returning to the step S3;

obtaining a third form until all the line data in the Excel form are traversed and all the line data meet the check rule;

and inserting the third list into a database for storage.

The terminal obtains dynamic database fields according to the basic report form, displays the form according to the front end of the dynamic database fields, a user fills in the form according to the dynamic form, verifies whether each row of data is correct or not according to the fields of the dynamic form obtained by the basic information table after filling in, and independently stores another table with the fields corresponding to the database table names according to verification rules, wherein the verification rules comprise regular expressions, addition and subtraction, logical operation and the like. And if the dynamic form submitted by the user passes the dynamic verification rule, inserting the dynamic form into the database, and if the dynamic form does not pass the dynamic verification rule, returning the submitted excel form and marking error information which should be modified in the excel form.

The step of judging whether the field meets the check rule specifically includes:

selecting the content in any cell and identifying the content in the cell;

if the cell type is a drop-down list, judging whether the content in the cell is matched with first data, if so, conforming to a verification rule, wherein the first data is dictionary information in a database; when the cell is defined as a drop-down list in the database rule, whether the excel cell needs to be filled is firstly verified, and if the excel cell needs to be filled, relevant information is not filled. Returning error information, otherwise, continuing to verify; if the cell is a drop-down list, reading dictionary information in the database to match with the value in the cell, if not, prompting error information, otherwise, passing verification

If the cell type is date, judging whether the cell content is the necessary filling content, if not, passing the verification rule, if yes, verifying the content, and if so, conforming to the verification rule. If the database defines that the type of the unit qualification is the date type, judging whether the unit lattice needs to be filled or not, if not, passing, otherwise, continuously verifying whether the date is legal or not according to the rule, prompting error information if not, otherwise, passing;

if the cell type is a number, an amount or a character, judging whether the cell content accords with the character, if so, performing regular expression or logic operation or addition and subtraction operation on the cell content to verify, and if the cell type passes the verification, conforming to a verification rule. If the database defines that the type of the unit is a number or sum or a character, firstly judging whether the character is the character and the length of the character passes (the set character length), if not, prompting an error, and if the character passes the recognition rule, continuing to recognize the rule;

and the verification of the regular expression is to input the cell contents into java for identification verification, and the verification of the logic operation and the addition and subtraction operation is to introduce and verify the canonical grammar of a javascript library.

If the identified database definition is a regular expression, loading the regular expression into java for identification. And (3) taking the value of the cell, judging whether the cell is empty or not, judging whether the cell is matched with the regular expression or not, prompting an error if the cell is not matched with the regular expression, converting the dynamic data operation result of the javascript into a java type through the identified fact that if the definition of the database is addition and subtraction operation or logic operation and verifying if the cell is matched with the regular expression, finally obtaining whether the result is matched with the rule or not, and prompting the error if the cell is matched with the regular expression.

Finally, error information is obtained, and the corresponding error information is arranged into the corresponding cell to be displayed to a user as a mark; asynchronously analyzing and storing the error excel to a place where a system folder is convenient for a user to download and modify the error by the user, and then the user submits the error excel again and verifies the error excel again after modifying the document according to the error prompt; and regularly clearing up error excel and deleting.

In step S4, the sub-step of inserting the third form into a database for storage includes:

reading the content in the third form, judging the value type in the content, and converting the character string type into the date type if the content is the date; if the content is a floating point, converting the character string type into a floating point type; if the content is integer, converting the character string type into an integer type; setting corresponding sql preprocessing sentences for each converted type;

if the content is empty or the content is a character string, directly setting an sql preprocessing statement;

and executing the set sql preprocessing statement, and inserting the third form into a database for storage.

According to the financial statement processing method provided by the embodiment, the processing of the form is converted into the program of automatic processing of the computer, so that the accuracy of data processing and the efficiency of data processing can be improved.

Example two

The embodiment discloses a financial report processing system, which implements the financial report processing method in the first embodiment, and comprises an instruction acquisition module, a form calling module, an information acquisition module and a verification module,

the instruction acquisition module is used for acquiring a first instruction, wherein the first instruction is a requirement instruction for a user to handle a service;

the form calling module is used for calling a first form based on the first instruction;

the information acquisition module is used for acquiring the user submission information through the first form and acquiring a second form;

and the verification module is used for performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, inputting the line of data into the information acquisition module until the contents of all the cells pass the verification rule, acquiring a third form, and inserting the third form into a database for storage.

EXAMPLE III

This embodiment discloses a financial transaction processing system, as shown in fig. 2 and fig. 3, fig. 3 is an architecture diagram of the whole financial transaction processing, the financial transaction processing system belongs to the technical support layer in fig. 3, and includes a report processing module, a data storage module, a statistical analysis module and a display,

the report processing module comprises a financial report processing system disclosed by the second embodiment and is used for processing business requirements of users;

the data storage module is used for storing a third form and data for processing the third form, and sending the stored data to the statistical analysis module for analysis;

and the statistical analysis module is used for performing statistical analysis on the stored data and transmitting the analyzed structure to the display for displaying.

The business processing system also comprises an authority and log module, wherein the authority and log module is used for storing an operation flow when the report processing module processes the business requirements of the user, and the operation flow comprises the whole process of obtaining a third form; and transmitting the operation flow to the statistical analysis module, wherein the statistical analysis module is used for transmitting an analysis structure to a display for displaying after analyzing the operation flow.

The business processing system also comprises an intelligent identification module, wherein the intelligent identification module is used for acquiring a third form stored by the data storage module, identifying whether the third form is a green project or not, and transmitting a result to the data storage module for storage. The application layer focuses on the integration of artificial intelligence and various fields of various industries. The technology layer is algorithm, model and technology development. The base layer is then the computing power and data resources.

The financial business processing system provided by this embodiment can be accurate the relevant data of processing, and the timeliness is high, and degree of digitization is high, and the system has good hardware platform expanding capability, and the system architecture can support the server cluster well, expands system's ability in a flexible way as required. The platform supports access connection among multiple data sources, supports multiple interface protocols and can be conveniently integrated with other related application systems; the method supports the transverse expansion of the database by adding a new host, so that the single-point fault of the database host is eliminated, and the construction cost and the capacity expansion cost of the data platform are reduced.

The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are merely exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims (10)

1. A financial statement processing method is characterized by comprising the following steps:

s1: acquiring a first instruction, wherein the first instruction is a requirement instruction for a user to handle a service;

s2: based on the first instruction, calling a first form;

s3: acquiring the user submission information through the first form to acquire a second form;

s4: and performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, marking the information which does not meet the verification rule, returning to the step S3 until the contents of all the cells pass the verification rule, obtaining a third form, and inserting the third form into a database for storage.

2. The financial statement processing method according to claim 1, wherein the first form includes a profile, a number, a specified bank organizational structure, a posted statement exel template, a dynamic statement database field, a specified type, and a posted frequency classification.

3. The financial statement processing method according to claim 1, wherein the substep of step S4 comprises:

mapping the second form into an Excel form to obtain the Excel form;

selecting any line in the Excel form, reading the field of the line, judging whether the field accords with the check rule, if so, mapping the field of the line into another Excel form, otherwise, returning to the step S3;

obtaining a third form until all the line data in the Excel form are traversed and all the line data meet the check rule;

and inserting the third list into a database for storage.

4. The financial statement processing method according to claim 3, wherein said determining whether the field complies with the validation rules specifically comprises:

selecting the content in any cell and identifying the content in the cell;

if the cell type is a drop-down list, judging whether the content in the cell is matched with first data, if so, conforming to a verification rule, wherein the first data is dictionary information in a database;

if the cell type is date, judging whether the cell content is the content which needs to be filled, if not, passing the verification rule, if so, verifying the content, and if so, conforming to the verification rule;

if the cell type is a number, an amount or a character, judging whether the cell content accords with the character, if so, performing regular expression or logic operation or addition and subtraction operation on the cell content to verify, and if the cell type passes the verification, conforming to a verification rule.

5. The financial statement processing method according to claim 4, wherein the verification of the regular expression is to input the cell contents into java for identification verification, and the verification of the logical operation and the verification of the addition and subtraction operation are to introduce and verify a javascript library specification grammar.

6. The financial statement processing method according to claim 1, wherein the sub-step of inserting the third form into a database for storage in step S4 includes:

reading the content in the third form, judging the value type in the content, and converting the character string type into the date type if the content is the date; if the content is a floating point, converting the character string type into a floating point type; if the content is integer, converting the character string type into an integer type; setting corresponding sql preprocessing sentences for each converted type;

if the content is empty or the content is a character string, directly setting an sql preprocessing statement;

and executing the set sql preprocessing statement, and inserting the third form into a database for storage.

7. A financial report processing system is characterized by comprising an instruction acquisition module, a form calling module, an information acquisition module and a verification module,

the instruction acquisition module is used for acquiring a first instruction, wherein the first instruction is a requirement instruction for a user to handle a service;

the form calling module is used for calling a first form based on the first instruction;

the information acquisition module is used for acquiring the user submission information through the first form and acquiring a second form;

and the verification module is used for performing line-by-line verification on the contents in the second form, mapping the data contents meeting the verification rule into an Excel form if the data of the contents in the form meet the verification rule, otherwise, inputting the line of data into the information acquisition module until the contents of all the cells pass the verification rule, acquiring a third form, and inserting the third form into a database for storage.

8. A financial business processing system is characterized by comprising a report processing module, a data storage module, a statistical analysis module and a display,

the statement processing module includes the financial statement processing system of claim 7 for handling business requirements for the user;

the data storage module is used for storing a third list and data for processing the third list and sending the stored data to the statistical analysis module for analysis;

and the statistical analysis module is used for performing statistical analysis on the stored data and transmitting the analyzed structure to the display for displaying.

9. The financial transaction system of claim 8, wherein the transaction system further comprises a permission and log module, the permission and log module is configured to store an operation flow when the report processing module processes the transaction requirement of the user, the operation flow includes all processes of obtaining a third form; and transmitting the operation flow to the statistical analysis module, wherein the statistical analysis module is used for transmitting an analysis structure to a display for displaying after analyzing the operation flow.

10. The system of claim 9, further comprising an intelligent recognition module, wherein the intelligent recognition module is configured to obtain a third form stored in the data storage module, recognize whether the third form is a green item, and transmit the result to the data storage module for storage.

Images