CN110674131A - Financial statement data processing method and device, computer equipment and storage medium - Google Patents
Financial statement data processing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110674131A CN110674131A CN201910819004.5A CN201910819004A CN110674131A CN 110674131 A CN110674131 A CN 110674131A CN 201910819004 A CN201910819004 A CN 201910819004A CN 110674131 A CN110674131 A CN 110674131A
- Authority
- CN
- China
- Prior art keywords
- financial
- data
- statement
- report
- preset
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title abstract description 17
- 238000004458 analytical method Methods 0.000 claims abstract description 129
- 238000000034 method Methods 0.000 claims abstract description 25
- 238000012545 processing Methods 0.000 claims description 25
- 238000000605 extraction Methods 0.000 claims description 20
- 238000004590 computer program Methods 0.000 claims description 12
- 238000013507 mapping Methods 0.000 claims description 12
- 238000012216 screening Methods 0.000 claims description 7
- 238000004364 calculation method Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 9
- 230000011218 segmentation Effects 0.000 description 5
- 230000008569 process Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013145 classification model Methods 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 210000000697 sensory organ Anatomy 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Educational Administration (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application relates to the technical field of cloud services, and provides a financial statement data processing method and device, computer equipment and a storage medium. The method comprises the following steps: receiving financial statement data, wherein the financial statement data comprises legal financial data and illegal financial data; extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data; according to the report subjects, removing illegal financial data in the financial report data to obtain financial index information; calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, and calculating to obtain a financial index value corresponding to the financial index information through the financial analysis formula; and generating and displaying a financial statement analysis report according to the financial index value. By adopting the method, the accuracy of the financial statement can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method and an apparatus for processing financial statement data, a computer device, and a storage medium.
Background
When the financial statement analysis system analyzes the annual report of an enterprise, the system generally processes the data related to the imported financial statement of the user. However, because there are many data irrelevant to the financial statements in the related data of the financial statements, and the traditional technology cannot remove the irrelevant data when processing the financial statements, all the data in the financial statements are directly processed, which easily results in low accuracy of the final generated financial statements.
Disclosure of Invention
In view of the above, it is necessary to provide a financial statement data processing method, apparatus, computer device and storage medium capable of improving accuracy of financial statements.
A financial statement data processing method comprises the following steps:
receiving financial statement data, wherein the financial statement data comprises legal financial data and illegal financial data;
extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data;
according to the report subjects, removing illegal financial data in the financial report data to obtain financial index information;
calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, and calculating to obtain a financial index value corresponding to the financial index information through the financial analysis formula;
and generating and displaying a financial statement analysis report according to the financial index value.
In one embodiment, before the text content extraction of the financial statement data, the method further comprises: analyzing the data format of the financial statement file corresponding to the financial statement data to obtain a corresponding financial statement file format; judging whether the format of the financial statement file meets a preset data format condition, if so, performing text content extraction on the financial statement data; if not, format revision is carried out on the financial statement file corresponding to the financial statement data until the financial statement file corresponding to the financial statement data meets the preset data format condition.
In one embodiment, the text content extraction of the financial statement data to obtain a statement subject corresponding to the financial statement data includes: acquiring financial text content in the financial statement data; segmenting the financial text content to obtain a plurality of words; and screening the words according to a preset report subject dictionary to obtain the report subject corresponding to the financial report data.
In one embodiment, the removing illegal financial data in the financial statement data according to the statement subject to obtain the financial index information includes: acquiring a preset financial statement subject pool, wherein the preset financial statement subject pool comprises a legal statement subject pool; when the report subject is not in the preset financial report subject pool, determining that the report subject is an illegal report subject, determining financial data corresponding to the report subject as illegal financial data, discarding the illegal financial data, taking residual financial data in the financial report data as legal financial data, and acquiring financial index information corresponding to the legal financial data.
In one embodiment, the method for calling the financial analysis formula corresponding to the financial index information from the preset financial analysis formula library comprises the following steps: acquiring a field corresponding to the financial index information; acquiring a preset financial analysis formula library, wherein the preset financial analysis formula library comprises a mapping relation between a preset field and a corresponding financial analysis formula; and inquiring from a preset financial analysis formula library according to the field corresponding to the financial index information to obtain a corresponding financial analysis formula.
In one embodiment, generating and displaying a financial statement analysis report based on the financial index value comprises: converting the financial index value data corresponding to the financial index value into corresponding financial index webpage data; displaying a financial statement analysis report in a webpage according to the financial index webpage data; and/or converting the financial index value data corresponding to the financial index value into corresponding financial index display data; and displaying the financial statement analysis report in the document according to the financial index display data.
A financial statement data processing apparatus, the apparatus comprising:
the receiving module is used for receiving financial statement data, and the financial statement data comprises legal financial data and illegal financial data;
the extraction module is used for extracting the text content of the financial statement data to obtain a statement subject corresponding to the financial statement data;
the rejecting module is used for rejecting illegal financial data in the financial statement data according to the statement subjects to obtain financial index information;
the calculation module is used for calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library and calculating a financial index value corresponding to the financial index information through the financial analysis formula;
and the generating module is used for generating and displaying the financial statement analysis report according to the financial index value.
A computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:
receiving financial statement data, wherein the financial statement data comprises legal financial data and illegal financial data;
extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data;
according to the report subjects, removing illegal financial data in the financial report data to obtain financial index information;
calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, and calculating to obtain a financial index value corresponding to the financial index information through the financial analysis formula;
and generating and displaying a financial statement analysis report according to the financial index value.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
receiving financial statement data, wherein the financial statement data comprises legal financial data and illegal financial data;
extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data;
according to the report subjects, removing illegal financial data in the financial report data to obtain financial index information;
calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, and calculating to obtain a financial index value corresponding to the financial index information through the financial analysis formula;
and generating and displaying a financial statement analysis report according to the financial index value.
According to the financial statement data processing method, the financial statement data processing device, the computer equipment and the storage medium, after the financial statement data are received, the financial statement data are processed, illegal financial data in the financial statement data are removed, financial index information is obtained, a corresponding financial analysis formula is called according to the financial index information, a corresponding financial index value is obtained through calculation of the financial analysis formula, and finally a financial statement analysis report is automatically generated according to the financial index value. By processing the financial statement data, the illegal financial data irrelevant to the financial statement is removed, the financial index information is kept, the financial statement analysis report is further generated, and the influence on the final generated financial statement analysis report due to the illegal financial data is avoided, so that the accuracy of the financial statement is improved.
Drawings
FIG. 1 is a diagram illustrating an exemplary scenario for a method for processing financial statement data;
FIG. 2 is a flowchart illustrating a method for processing financial statement data according to an embodiment;
FIG. 3 is a flowchart illustrating a method for processing financial statement data according to another embodiment;
FIG. 4 is a flowchart illustrating the text content extraction step of the financial statement data in one embodiment;
FIG. 5 is a flowchart illustrating the illegal financial data extraction step according to one embodiment;
FIG. 6 is a flowchart illustrating the steps of invoking a financial analysis formula from a library of predetermined financial analysis formulas in one embodiment;
FIG. 7 is a flowchart illustrating the steps of generating and displaying a financial statement analysis report based on financial index values in one embodiment;
FIG. 8 is a flowchart illustrating the steps of generating and displaying a financial statement analysis report based on financial index values according to another embodiment;
FIG. 9 is a block diagram showing the construction of a financial statement data processing apparatus according to an embodiment;
FIG. 10 is a block diagram showing the construction of a financial statement data processing apparatus according to another embodiment;
FIG. 11 is a block diagram showing the structure of an extraction module in another embodiment;
FIG. 12 is a block diagram of the culling module in one embodiment;
FIG. 13 is a block diagram of a computing module in one embodiment;
FIG. 14 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The financial statement data processing method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
Specifically, the server 104 may extract text content of the financial statement data to obtain a statement subject corresponding to the financial statement data, remove the illegal financial data in the financial statement data according to the statement subject to obtain financial index information, call a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, calculate a financial index value corresponding to the financial index information through the financial analysis formula, and generate and display a financial statement analysis report according to the financial index value. Further, the generated financial statement analysis report may be sent to the terminal 102, and the terminal 102 receives and displays the financial statement analysis report.
In one embodiment, as shown in fig. 2, a financial statement data processing method is provided, which is described by taking the method as an example applied to the terminal in fig. 1, and includes the following steps:
The financial statement data refers to information related to a financial statement, and the financial statement is an accounting statement reflecting capital and profit conditions of an enterprise or a budget unit in a certain period. The financial statement data can comprise an asset liability statement, a cash flow table and a profit and loss table, wherein the asset load table is also called a financial condition table and represents a main accounting statement of the financial condition of an enterprise on a certain date; the cash flow table is one of three basic reports of financial statements, and expresses the increase and decrease change of cash of an organization in a fixed period; the profit-loss table is a report reflecting the operation results of the enterprise in a certain period. The financial statement data comprises legal financial data and illegal financial data, the legal financial data refers to data related to finance in the financial statement data, and the illegal financial data is a relative concept of the legal financial data and refers to data related to financial five sense organs in the financial statement data.
The enterprise operation condition can be known by using the balance sheet in the financial statement data; the cash flow table in the financial statement data can reflect the influence of each item in the balance sheet on cash flow, and the cash flow table is divided into three activity categories of operation, investment and financing according to the application; the profit and loss table in the financial statement data can be used for evaluating the operation achievement and investment efficiency of an enterprise and analyzing the profit capacity of the enterprise and the profit trend of the enterprise in a certain period in the future.
And step 204, extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data.
The text refers to the expression form of written language and is used in any language, the text content extraction refers to the extraction of the text in the financial statement data, the statement subjects refer to all units of the financial statement data, and the financial statement data comprises a plurality of statement subjects.
The method for extracting the text content of the financial statement data can be customized, and the customization can be realized by firstly acquiring all the text content in the financial statement data and then segmenting the acquired text content to obtain a plurality of words. And then, screening the words obtained by word segmentation by means of a preset report subject dictionary to obtain report subjects corresponding to the financial report data. The self-definition can also be realized by classifying the financial statement data by means of a trained statement subject classification model to obtain a statement subject corresponding to the financial statement data.
And step 206, removing the illegal financial data in the financial statement data according to the statement subjects to obtain financial index information.
The financial index information refers to information related to financial data, corresponding financial index information exists in each financial data, the terminal acquires illegal report subjects corresponding to illegal financial data from the report subjects after obtaining the report subjects corresponding to the financial report data, and the illegal report subjects corresponding to illegal financial data can be filtered or discarded in order to improve accuracy of financial report analysis reports because the illegal financial data do not belong to financial related data, and the remaining report subjects in the report subjects are taken as legal report subjects. And acquiring financial index information corresponding to each legal statement subject. The obtaining of the financial index information corresponding to each legal statement subject may specifically be obtaining the financial index information according to a keyword in the legal statement subject, for example, taking the keyword in the legal statement subject as the corresponding financial index information.
And step 208, calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, and calculating to obtain a financial index value corresponding to the financial index information through the financial analysis formula.
The financial index information is information related to financial data, corresponding financial index information exists in each financial data, the financial index information corresponding to each financial data is firstly obtained, corresponding financial analysis formulas are called from a preset financial analysis formula library according to the financial index information, the preset financial analysis formula library is composed of a plurality of financial analysis formulas, and the financial analysis formulas are used for calculating financial index values corresponding to the financial index information. Specifically, after the financial index information corresponding to the financial index data is obtained, the corresponding financial analysis formula is called from the preset financial analysis formula library according to the financial index information, and the financial index value corresponding to each piece of financial index information is automatically calculated by calling the corresponding financial analysis formula.
And step 210, generating and displaying a financial statement analysis report according to the financial index value.
Specifically, after the financial index value corresponding to each piece of financial index information is calculated, a financial statement analysis report is generated and displayed according to the financial index value. And automatically filling the financial index value into the content corresponding to the initial financial statement analysis report so as to generate the financial statement analysis report. The financial statement analysis report can be displayed in a webpage form or a word document form.
According to the financial statement data processing method, after the financial statement data are received, the financial statement data are processed, illegal financial data in the financial statement data are removed, financial index information is obtained, a corresponding financial analysis formula is called according to the financial index information, a corresponding financial index value is obtained through calculation of the financial analysis formula, and finally a financial statement analysis report is automatically generated according to the financial index value. By processing the financial statement data, the illegal financial data irrelevant to the financial statement is removed, the financial index information is kept, the financial statement analysis report is further generated, and the influence on the final generated financial statement analysis report due to the illegal financial data is avoided, so that the accuracy of the financial statement is improved.
In one embodiment, as shown in fig. 3, before the text content extraction of the financial statement data, the method further includes:
and step 302, performing data format analysis on the financial statement file corresponding to the financial statement data to obtain a corresponding financial statement file format.
The data format is a rule describing that data is stored in a file or record. The data format here may be a text format in the form of characters, or a compressed format in the form of binary data. Specifically, the data format of the financial statement data can be analyzed, and the data formats of a plurality of financial statements are different, so that the processing of the financial statements can be influenced, the data formats of the financial statements can be processed, the unification of the data formats of the financial statements can be ensured, specifically, a financial statement file corresponding to the financial statement data is obtained, and the data format of the obtained financial statement file is analyzed to obtain the corresponding financial statement file format.
And step 304, judging whether the format of the financial statement file meets the preset data format condition, and if so, performing text content extraction on the financial statement data.
And step 306, if the format of the financial statement file corresponding to the financial statement data is not met, revising the format of the financial statement file corresponding to the financial statement data until the financial statement file corresponding to the financial statement data meets the preset data format condition.
The preset data format condition is a preset condition for judging whether the financial statement file format is analyzed correctly, the preset data format condition can be defined by users, and the definition can be set according to actual application scenes or business needs. Specifically, after the data format of the financial statement file corresponding to the financial statement data is analyzed to obtain the corresponding financial statement file format, in order to ensure the accuracy of data format analysis and the accuracy of the final financial statement analysis report, therefore, whether the format of the financial statement file meets the preset data format condition can be judged, if so, entering a step of text content extraction of the financial statement data, otherwise, if the text content is not satisfied, format revision is required to be carried out on the financial statement file corresponding to the financial statement data until the financial statement file corresponding to the financial statement data meets the preset data format condition, thus ensuring that the financial statement data in any format is converted into the financial statement meeting the preset data format condition, therefore, the financial statement data in any format can be processed, and the situation that the financial statement cannot be processed due to the data format is avoided.
In an embodiment, as shown in fig. 4, extracting text content from the financial reporting data to obtain a reporting subject corresponding to the financial reporting data includes:
The text content extraction is to extract all text contents in the financial statement data, and specifically, all the financial text contents in the financial statement data can be obtained by means of a text content extraction model, and the text content extraction model can be a word2vec model and the like. In one embodiment, the financial statement data is input into a trained text content extraction model, and the financial text content in the financial statement data is extracted through the text content extraction model to obtain all the financial text content in the financial statement data.
Since the financial text content is generally a comment or an article in the form of a sentence, the financial text content needs to be segmented to obtain a plurality of segmented words. Specifically, after the financial text content is obtained, the financial text content is segmented according to a certain rule to obtain a plurality of words. The segmentation rule can be segmented according to the components of the words in the sentences, the parts of speech of the words and the collocation habits of the words.
And 406, screening the words according to a preset report subject dictionary to obtain report subjects corresponding to the financial report data.
The preset report subject dictionary is a set consisting of various legal report subjects. Various legal report subjects can be obtained in advance, and the legal report subjects form report subject words and are stored to the local. And after the financial text content is segmented to obtain a plurality of words, screening the words according to a preset report subject dictionary to obtain report subjects corresponding to the financial report data, wherein the screening mode can be customized, and the customization can be realized by calculating the similarity between the words obtained after word segmentation and each report subject in the preset financial report subject dictionary and determining the report subjects corresponding to the financial report data according to the similarity. The self-definition can also be the matching degree of the words after word segmentation and each report subject in a preset financial report subject dictionary, the report subject corresponding to the financial report data is determined according to the matching degree, and the like.
In an embodiment, as shown in fig. 5, the removing illegal financial data in the financial statement data according to the statement subject to obtain the financial index information includes:
And step 504, when the report subject is not in the preset financial report subject pool, determining the report subject as an illegal report subject, determining the financial data corresponding to the report subject as illegal financial data, discarding the illegal financial data, taking the residual financial data in the financial report data as legal financial data, and acquiring financial index information corresponding to the legal financial data.
The report subjects refer to all units of the financial report, and the financial report data comprises a plurality of report subjects. The corresponding report subject can be obtained according to the financial report data, wherein the financial report data can comprise at least one report subject. The acquiring of the corresponding report subject according to the financial report data may be extracting a keyword from the financial report data, and using the extracted keyword as the report subject corresponding to the financial report data.
The terminal can store each legal report subject in the preset report subject pool in advance, after the report subjects in each financial report data are obtained, the report subjects are matched with each preset financial report subject pool in the preset report subject pool, the report subjects in the obtained financial report data are classified, and some report subjects do not exist in the preset financial report subject pool, so that the report subjects are classified as unmatched report subjects. Otherwise, the report is classified into the matched report subject. The matched report subject means that the report subject in the financial report data is a legal report subject and is in a preset financial report subject pool. And the unmatched report subject refers to a non-legal report subject and is not in the preset financial report subject pool.
In an embodiment, for the matched report subject, the financial index data corresponding to the matched report subject can be obtained according to a preset financial index mapping relation table, where the preset financial index mapping relation table includes a mapping relation between the report subject and the financial index, and the report subject and the financial index information in the preset financial index mapping relation table are in a one-to-one correspondence relationship. And the terminal can bind the preset report subjects with the financial index information to form a preset financial index mapping relation table. And after a legal report subject is obtained from the preset financial report subject pool, the Lima matches the preset financial index mapping relation table according to the report subject to obtain corresponding financial index information.
In one embodiment, when the report subject is not in the preset financial report subject pool, the report subject can be directly determined to be an illegal report subject, the financial data corresponding to the report subject is determined to be illegal financial data, the illegal financial data is discarded, the residual financial data in the financial report data is used as legal financial data, and the financial index information corresponding to the legal financial data is obtained.
In one embodiment, when the report subject is not in the preset financial report subject pool, the unmatched report subject pool is processed through a regular term expression, where the regular term expression is a rule for processing the unmatched report subject, and the processing includes, but is not limited to, correction processing or keyword extraction processing, so that the processed report subject exists in the preset financial report subject pool. Namely, the unmatched report subjects are changed into matched report subjects. And when the unmatched report subjects become matched report subjects after being processed by the regular term expression, matching the report subjects according to a preset report subject pool until the unmatched report subjects are obtained. By processing the unmatched report subjects, the unmatched report subjects are changed into the matched report subjects after processing, the report subjects can be maximally applied, waste of the unmatched report subjects is reduced, and the accuracy of the final financial report analysis report can be guaranteed by changing the unmatched report subjects into the matched report subjects.
In one embodiment, as shown in fig. 6, the invoking of the financial analysis formula corresponding to the financial index information from the preset financial analysis formula library includes:
And 606, inquiring a preset financial analysis formula library according to the field corresponding to the financial index information to obtain a corresponding financial analysis formula.
The fields are used for identifying the financial index information, the mapping relation between the preset fields and the corresponding financial analysis formulas can be established in the financial analysis formula library in advance, the financial index information has corresponding unique fields, the corresponding financial index information can be obtained through the fields, and the corresponding fields can be obtained through the financial index information.
And searching the matched financial analysis formula from the mapping relation between the field in the preset financial analysis library and the financial analysis formula according to the field corresponding to the financial index information when the field corresponding to the financial index information is obtained. Specifically, a target field matched with a field corresponding to the financial index information is searched from a preset financial analysis library, a financial analysis formula corresponding to the target field is obtained, and the obtained financial analysis formula is used as the financial analysis formula corresponding to the financial index information.
In one embodiment, as shown in FIG. 7, generating and displaying a financial statement analysis report based on financial index values includes:
And step 704, displaying the financial statement analysis report in the webpage according to the financial index webpage data.
When the financial statement analysis report is generated and displayed according to the financial index value, the display data for displaying the financial statement analysis report can be displayed only after being processed, and the financial index value data corresponding to the financial index value needs to be converted into corresponding financial index webpage data. The financial index webpage data refers to financial statement data which can be displayed on a webpage. And after the financial index value data corresponding to the financial index value is converted into corresponding financial index webpage data, a financial statement analysis report can be displayed on a webpage according to the financial index webpage data, so that financial related personnel can audit the financial statement or carry out the next work according to the financial index webpage data.
In one embodiment, as shown in FIG. 8, generating and displaying a financial statement analysis report based on financial index values includes:
and step 802, converting the financial index value data corresponding to the financial index value into corresponding financial index display data.
And step 804, displaying a financial statement analysis report in the document according to the financial index display data.
The financial statement analysis report can be displayed on the webpage, and can also be displayed on the document, and because the data format displayed by the webpage and the data format displayed by the document are different, the financial statement analysis report is displayed on the document, the financial index value data corresponding to the financial index value needs to be converted into the corresponding financial index display data, and then the financial statement analysis report is displayed in the document according to the financial index display data. The financial index display data refers to financial report data which can be displayed on a document, wherein the document can be but is not limited to a word document in office software office.
It should be understood that, although the steps in the above-described flowcharts are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in the above-described flowcharts may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or the stages is not necessarily sequential, but may be performed alternately or alternatingly with other steps or at least a portion of the sub-steps or stages of other steps.
In one embodiment, as shown in FIG. 9, there is provided a financial reporting data processing apparatus 900, wherein:
the receiving module 902 is configured to receive financial statement data, where the financial statement data includes legal financial data and illegal financial data.
And the extraction module 904 is configured to extract text content of the financial statement data to obtain a statement subject corresponding to the financial statement data.
And the removing module 906 is used for removing the illegal financial data in the financial statement data according to the statement subjects to obtain the financial index information.
And the calculating module 908 is configured to call a financial analysis formula corresponding to the financial index information from the preset financial analysis formula library, and calculate a financial index value corresponding to the financial index information through the financial analysis formula.
And the generating module 910 is configured to generate and display a financial statement analysis report according to the financial index value.
In one embodiment, as shown in FIG. 10, the financial statement data processing apparatus 900 further comprises:
and the analyzing module 912 is configured to analyze the data format of the financial statement file corresponding to the financial statement data to obtain a corresponding financial statement file format.
The judging module 914 is configured to judge whether the format of the financial statement file meets a preset data format condition, and if so, perform a step of extracting text content of the financial statement data.
The determining module 914 is further configured to revise the format of the financial reporting file corresponding to the financial reporting data if the format of the financial reporting file is not met, until the financial reporting file corresponding to the financial reporting data meets a preset data format condition.
In one embodiment, as shown in FIG. 11, the extraction module 904 includes:
and the financial text content acquisition unit 904a is used for acquiring the financial text content in the financial statement data.
And a financial text content segmentation unit 904b, configured to segment the financial text content to obtain a plurality of words.
And the financial text content screening unit 904c is configured to screen the report subjects corresponding to the financial report data from the words according to a preset report subject dictionary.
In one embodiment, as shown in FIG. 12, the culling module 906 includes:
the subject pool obtaining unit 906a is configured to obtain a preset financial statement subject pool, where the preset financial statement subject pool includes a legal statement subject.
The subject pool processing unit 906b is configured to determine that the report subject is an illegal report subject when the report subject is not in the preset financial report subject pool, determine financial data corresponding to the report subject as illegal financial data, discard the illegal financial data, use remaining financial data in the financial report data as legal financial data, and acquire financial index information corresponding to the legal financial data.
In one embodiment, as shown in FIG. 13, the calculation module 908 comprises:
the field obtaining unit 908a is configured to obtain a field corresponding to the financial index information.
The formula library obtaining unit 908b is configured to obtain a preset financial analysis formula library, where the preset financial analysis formula library includes a mapping relationship between a preset field and a corresponding financial analysis formula.
And the analysis formula calling unit 908c is configured to query the preset financial analysis formula library according to the field corresponding to the financial index information to obtain the corresponding financial analysis formula.
In one embodiment, the generating module 910 is further configured to convert the financial index value data corresponding to the financial index value into corresponding financial index webpage data; displaying a financial statement analysis report in a webpage according to the financial index webpage data; and/or converting the financial index value data corresponding to the financial index value into corresponding financial index display data; and displaying the financial statement analysis report in the document according to the financial index display data.
For the specific limitations of the financial statement data processing apparatus, reference may be made to the above limitations of the financial statement data processing method, which are not described herein again. All or part of the modules in the financial statement data processing device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 14. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a financial statement data processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 14 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to perform the steps of the above-described financial statement data processing method. The steps of the financial statement data processing method herein may be the steps of the financial statement data processing method of the various embodiments described above.
In one embodiment, a computer readable storage medium is provided, which stores a computer program that, when executed by a processor, causes the processor to perform the steps of the above-mentioned financial statement data processing method. The steps of the financial statement data processing method herein may be the steps of the financial statement data processing method of the various embodiments described above.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method of financial statement data processing, the method comprising:
receiving financial statement data, wherein the financial statement data comprises legal financial data and illegal financial data;
extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data;
according to the report subjects, removing illegal financial data in the financial report data to obtain financial index information;
calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library, and calculating to obtain a financial index value corresponding to the financial index information through the financial analysis formula;
and generating and displaying a financial statement analysis report according to the financial index value.
2. The method of claim 1, prior to the extracting the text content of the financial statement data, further comprising:
analyzing the data format of the financial statement file corresponding to the financial statement data to obtain a corresponding financial statement file format;
judging whether the format of the financial statement file meets a preset data format condition, if so, entering the step of extracting the text content of the financial statement data;
and if not, format revision is carried out on the financial statement file corresponding to the financial statement data until the financial statement file corresponding to the financial statement data meets the preset data format condition.
3. The method of claim 1, wherein the extracting the text content of the financial reporting data to obtain the reporting subject corresponding to the financial reporting data comprises:
acquiring financial text content in the financial statement data;
segmenting the financial text content to obtain a plurality of words;
and screening the words according to a preset report subject dictionary to obtain the report subject corresponding to the financial report data.
4. The method according to claim 1, wherein the removing illegal financial data in the financial reporting data according to the reporting subject to obtain financial index information comprises:
acquiring a preset financial statement subject pool, wherein the preset financial statement subject pool comprises legal statement subjects;
and when the report subject is not in the preset financial report subject pool, determining that the report subject is an illegal report subject, determining financial data corresponding to the report subject as illegal financial data, discarding the illegal financial data, taking residual financial data in the financial report data as legal financial data, and acquiring financial index information corresponding to the legal financial data.
5. The method according to claim 1, wherein the calling the financial analysis formula corresponding to the financial index information from a preset financial analysis formula library comprises:
acquiring a field corresponding to the financial index information;
acquiring a preset financial analysis formula library, wherein the preset financial analysis formula library comprises a mapping relation between a preset field and a corresponding financial analysis formula;
and inquiring the preset financial analysis formula library according to the field corresponding to the financial index information to obtain a corresponding financial analysis formula.
6. The method of claim 1, wherein generating and displaying a financial statement analysis report based on the financial index value comprises:
converting the financial index value data corresponding to the financial index value into corresponding financial index webpage data;
displaying the financial statement analysis report in a webpage according to the financial index webpage data; and/or
Converting the financial index value data corresponding to the financial index value into corresponding financial index display data;
and displaying the financial statement analysis report in a document according to the financial index display data.
7. A financial statement data processing apparatus, characterized in that the apparatus comprises:
the receiving module is used for receiving financial statement data, and the financial statement data comprises legal financial data and illegal financial data;
the extraction module is used for extracting text contents of the financial statement data to obtain statement subjects corresponding to the financial statement data;
the rejecting module is used for rejecting illegal financial data in the financial statement data according to the statement subjects to obtain financial index information;
the calculation module is used for calling a financial analysis formula corresponding to the financial index information from a preset financial analysis formula library and calculating a financial index value corresponding to the financial index information through the financial analysis formula;
and the generating module is used for generating and displaying a financial statement analysis report according to the financial index value.
8. The apparatus of claim 7, further comprising:
the analysis module is used for analyzing the data format of the financial statement file corresponding to the financial statement data to obtain the corresponding financial statement file format;
the judging module is used for judging whether the format of the financial statement file meets a preset data format condition, and if so, entering the step of extracting the text content of the financial statement data;
and the judging module is also used for revising the format of the financial statement file corresponding to the financial statement data if the format of the financial statement file is not met until the financial statement file corresponding to the financial statement data meets the preset data format condition.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 6 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910819004.5A CN110674131A (en) | 2019-08-30 | 2019-08-30 | Financial statement data processing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910819004.5A CN110674131A (en) | 2019-08-30 | 2019-08-30 | Financial statement data processing method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110674131A true CN110674131A (en) | 2020-01-10 |
Family
ID=69075817
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910819004.5A Pending CN110674131A (en) | 2019-08-30 | 2019-08-30 | Financial statement data processing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110674131A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111369370A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Estimation table processing method, device, server and storage medium |
| CN112559604A (en) * | 2020-11-24 | 2021-03-26 | 杭州零弌科技有限公司 | Report management system |
| CN113158988A (en) * | 2021-05-19 | 2021-07-23 | 上海云从企业发展有限公司 | Financial statement processing method and device and computer readable storage medium |
| CN113177396A (en) * | 2021-04-30 | 2021-07-27 | 平安证券股份有限公司 | Report generation method and device, computer equipment and storage medium |
| CN113297302A (en) * | 2021-05-27 | 2021-08-24 | 上海商汤智能科技有限公司 | Financial data display method and device, electronic equipment and storage medium |
| CN116542800A (en) * | 2023-06-29 | 2023-08-04 | 天津星耀九洲科技有限公司 | Intelligent financial statement analysis system based on cloud AI technology |
| CN117150348A (en) * | 2023-10-30 | 2023-12-01 | 宁德时代新能源科技股份有限公司 | Battery external damage data processing method, system, electronic equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN106339365A (en) * | 2016-08-26 | 2017-01-18 | 深圳市永兴元科技有限公司 | Report form management method |
| CN106599200A (en) * | 2016-12-14 | 2017-04-26 | 陕西学前师范学院 | Intelligent remote financial data anti-cheating system and anti-cheating method thereof |
| CN107301593A (en) * | 2017-06-19 | 2017-10-27 | 安徽爱普科技有限公司 | A kind of financial information system |
| CN107862603A (en) * | 2017-11-27 | 2018-03-30 | 北京艾信运通技术有限公司 | A kind of financial statement credibility evaluation method and device |
| CN109447769A (en) * | 2018-09-07 | 2019-03-08 | 杭州小番网络科技有限公司 | A kind for the treatment of method and apparatus of financial data |
| CN109558441A (en) * | 2018-10-25 | 2019-04-02 | 平安科技（深圳）有限公司 | Financial index automatic monitoring method, device, computer equipment and storage medium |
-
2019
- 2019-08-30 CN CN201910819004.5A patent/CN110674131A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN106339365A (en) * | 2016-08-26 | 2017-01-18 | 深圳市永兴元科技有限公司 | Report form management method |
| CN106599200A (en) * | 2016-12-14 | 2017-04-26 | 陕西学前师范学院 | Intelligent remote financial data anti-cheating system and anti-cheating method thereof |
| CN107301593A (en) * | 2017-06-19 | 2017-10-27 | 安徽爱普科技有限公司 | A kind of financial information system |
| CN107862603A (en) * | 2017-11-27 | 2018-03-30 | 北京艾信运通技术有限公司 | A kind of financial statement credibility evaluation method and device |
| CN109447769A (en) * | 2018-09-07 | 2019-03-08 | 杭州小番网络科技有限公司 | A kind for the treatment of method and apparatus of financial data |
| CN109558441A (en) * | 2018-10-25 | 2019-04-02 | 平安科技（深圳）有限公司 | Financial index automatic monitoring method, device, computer equipment and storage medium |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111369370A (en) * | 2020-03-31 | 2020-07-03 | 中国建设银行股份有限公司 | Estimation table processing method, device, server and storage medium |
| CN111369370B (en) * | 2020-03-31 | 2024-03-19 | 中国建设银行股份有限公司 | Evaluation list processing method, device, server and storage medium |
| CN112559604A (en) * | 2020-11-24 | 2021-03-26 | 杭州零弌科技有限公司 | Report management system |
| CN113177396A (en) * | 2021-04-30 | 2021-07-27 | 平安证券股份有限公司 | Report generation method and device, computer equipment and storage medium |
| CN113158988A (en) * | 2021-05-19 | 2021-07-23 | 上海云从企业发展有限公司 | Financial statement processing method and device and computer readable storage medium |
| CN113158988B (en) * | 2021-05-19 | 2024-04-05 | 上海云从企业发展有限公司 | Financial statement processing method, device and computer readable storage medium |
| CN113297302A (en) * | 2021-05-27 | 2021-08-24 | 上海商汤智能科技有限公司 | Financial data display method and device, electronic equipment and storage medium |
| CN116542800A (en) * | 2023-06-29 | 2023-08-04 | 天津星耀九洲科技有限公司 | Intelligent financial statement analysis system based on cloud AI technology |
| CN117150348A (en) * | 2023-10-30 | 2023-12-01 | 宁德时代新能源科技股份有限公司 | Battery external damage data processing method, system, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110674131A (en) | Financial statement data processing method and device, computer equipment and storage medium | |
| CN110765763B (en) | Error correction method and device for voice recognition text, computer equipment and storage medium | |
| CN108876133B (en) | Risk assessment processing method, device, server and medium based on business information | |
| CN110489520B (en) | Knowledge graph-based event processing method, device, equipment and storage medium | |
| CN110457431B (en) | Knowledge graph-based question and answer method and device, computer equipment and storage medium | |
| CN108509485B (en) | Data preprocessing method and device, computer equipment and storage medium | |
| CN109858010B (en) | Method and device for recognizing new words in field, computer equipment and storage medium | |
| CN109543925B (en) | Risk prediction method and device based on machine learning, computer equipment and storage medium | |
| CN109063217B (en) | Work order classification method and device in electric power marketing system and related equipment thereof | |
| CN110765265A (en) | Information classification extraction method and device, computer equipment and storage medium | |
| CN110569500A (en) | Text semantic recognition method and device, computer equipment and storage medium | |
| CN109815333A (en) | Information acquisition method, device, computer equipment and storage medium | |
| WO2020057021A1 (en) | Data table processing method and device, computer device and storage medium | |
| CN108664595B (en) | Domain knowledge base construction method and device, computer equipment and storage medium | |
| CN110008250B (en) | Social security data processing method and device based on data mining and computer equipment | |
| CN109829629A (en) | Generation method, device, computer equipment and the storage medium of risk analysis reports | |
| US11972217B2 (en) | Systems and methods for dynamically displaying a user interface of an evaluation system processing textual data | |
| CN110362798B (en) | Method, apparatus, computer device and storage medium for judging information retrieval analysis | |
| CN110377558A (en) | Document searching method, device, computer equipment and storage medium | |
| CN112395500A (en) | Content data recommendation method and device, computer equipment and storage medium | |
| CN109542956A (en) | Report form generation method, device, computer equipment and storage medium | |
| CN111190946A (en) | Report generation method and device, computer equipment and storage medium | |
| CN109033427B (en) | Stock screening method and device, computer equipment and readable storage medium | |
| CN110781380A (en) | Information pushing method and device, computer equipment and storage medium | |
| CN111324716A (en) | Index data acquisition method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20240202 |