CN113553819A - Financial statement generation method and system - Google Patents
Financial statement generation method and system Download PDFInfo
- Publication number
- CN113553819A CN113553819A CN202110815713.3A CN202110815713A CN113553819A CN 113553819 A CN113553819 A CN 113553819A CN 202110815713 A CN202110815713 A CN 202110815713A CN 113553819 A CN113553819 A CN 113553819A
- Authority
- CN
- China
- Prior art keywords
- financial statement
- data
- statement
- user
- financial
- 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.)
- Withdrawn
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/51—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/583—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
- G06N3/00—Computing arrangements based on biological models
- G06N3/02—Neural networks
-
- 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
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Finance (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Databases & Information Systems (AREA)
- Library & Information Science (AREA)
- Computer Security & Cryptography (AREA)
- Technology Law (AREA)
- Computer Hardware Design (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Biomedical Technology (AREA)
- Biophysics (AREA)
- Evolutionary Computation (AREA)
- Molecular Biology (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Development Economics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a method and a system for generating financial statements, and relates to the technical field of data management. The method comprises the following steps: s1: a user login request is detected. S2: and acquiring identity information input by a user. S3: and entering a user operation interface. S4: and when the report generation option is clicked, opening the Excel report template. S5: and setting the data format of each financial statement. S6: determining a calculation formula and a required data type of each cell according to the data format, extracting specific data corresponding to the data type consistent with the required data type in the database, and inputting the processed specific data into the cells. S7: repeating S6 until all cells in the financial statement template are filled. Therefore, the calculation and filling of the cells are not required to be carried out by manually inquiring the business document, the complex work of financial staff for making the financial statement is reduced, the efficiency of making the financial statement is improved, the condition of data filling errors is prevented, and the accuracy of the financial statement is ensured.
Description
Technical Field
The invention relates to the technical field of data management, in particular to a method and a system for generating a financial statement.
Background
Professional high-efficiency operation and comprehensive service coverage of enterprises can greatly increase the service bill usage amount of the enterprises. Financial staff need to process a large amount of business documents at the end of a month to provide financial statements, such as an asset liability statement, a cash flow statement, a financial condition change statement, a profit and loss statement, reflecting the enterprise operation condition and the asset liability condition for the enterprise operation managers. The enterprise operation manager improves the operation management of the enterprise according to the financial statement. Therefore, the financial statement is a necessary form for the operation of each enterprise, and the financial department needs to make a judgment and decision according to the statement, but the financial data in the financial statement has the characteristics of complexity, accuracy and diversified formats, and the states of various business data in different business documents are different, and the presentation forms in the financial document corresponding to the business document are also different, so that the financial staff is complicated in the process of making the financial statement, and the accuracy of the data statement cannot be ensured.
Disclosure of Invention
The invention aims to provide a method and a system for generating a financial statement, which are used for solving the problems that in the prior art, the financial staff is complicated in financial statement making process and cannot ensure the accuracy of a data statement.
The embodiment of the invention is realized by the following steps:
in a first aspect, an embodiment of the present application provides a method for generating a financial statement, which includes the following steps: s1: a user login request is detected. S2: when a user requests to log in, identity information input by the user is acquired. S3: and comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information. S4: when a user clicks a report generation option on the user operation interface, the Application component of the Excel opens the Excel report template. S5: and setting the data format of each financial statement in the Excel statement template according to the financial statement type to obtain the corresponding financial statement template. S6: determining a calculation formula and a required data type of each cell according to the data format, sequentially comparing the data types in the database according to the required data types, extracting specific data corresponding to the data types consistent with the required data types in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data into the corresponding cell. S7: repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement.
In some embodiments of the present invention, the step of opening the Excel report template by the Application component of the Excel includes: an Application component referencing Excel generates an Application form instance. And opening an Excel report template by utilizing the Application form example.
In some embodiments of the present invention, before the steps of determining the calculation formula and the required data type of each cell according to the data format, and sequentially comparing the data types in the database according to the required data types, the method further includes: and acquiring a document scanning image uploaded by a user, and inputting the document scanning image into a trained data extraction model to obtain specific data and a corresponding data type. And storing the specific data, the data type corresponding to the specific data and the document scanning image into a database.
In some embodiments of the present invention, before the step of acquiring a document scan image uploaded by a user, the method further includes: and scanning the business document to obtain a document scanning image. And clicking a document uploading option on the user operation interface by the user to upload the scanned document image.
In some embodiments of the present invention, before the step of opening the Excel report template by the Application component of Excel when the user clicks the report generation option on the user operation interface, the method further includes: and making an Excel report template.
In some embodiments of the present invention, after the step of repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement, the method further includes: and saving the corresponding financial statement to a database.
In some embodiments of the invention, the financial statement types include profit statements, asset liability statements, cash flow statements, and financial condition change statements.
In a second aspect, an embodiment of the present application provides a system for generating a financial statement, including: and the login request detection module is used for detecting a user login request. And the identity information acquisition module is used for acquiring the identity information input by the user when the user requests to log in. And the identity verification module is used for comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information. And the Excel report template opening module is used for opening the Excel report template by the Application component of the Excel when the user clicks the report generation option on the user operation interface. And the corresponding financial statement template obtaining module is used for setting the data format of each financial statement in the Excel statement template according to the financial statement type so as to obtain the corresponding financial statement template. And the cell data calculation module is used for determining a calculation formula and a required data type of each cell according to the data format, sequentially comparing the data types in the database according to the required data type, extracting specific data corresponding to the data type consistent with the required data type in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data to the corresponding cell. And the corresponding financial statement acquisition module is used for repeatedly using the cell data calculation module until all the cells in the corresponding financial statement template are filled up so as to obtain a corresponding financial statement.
In some embodiments of the present invention, the Excel report template opening module includes: and the form example generating unit is used for generating an Application form example by referring to the Application component of the Excel. And the Excel report template opening unit is used for opening the Excel report template by utilizing the Application form example.
In some embodiments of the present invention, the system for generating a financial statement further includes: and the document data extraction module is used for acquiring a document scanning image uploaded by a user and inputting the document scanning image into the trained data extraction model so as to obtain specific data and a corresponding data type. And the document storage module is used for storing the specific data, the data type corresponding to the specific data and the document scanning image into a database.
In some embodiments of the present invention, the system for generating a financial statement further includes: and the document scanning module is used for scanning the business document to obtain a document scanning image. And the scanned image uploading module is used for the user to click the bill uploading option on the user operation interface and upload the scanned image of the bill.
In some embodiments of the present invention, the system for generating a financial statement further includes: and the report template making module is used for making the Excel report template.
In some embodiments of the present invention, the system for generating a financial statement further includes: and the corresponding financial statement storage module is used for storing the corresponding financial statement to the database.
In some embodiments of the invention, the financial statement types include profit statements, asset liability statements, cash flow statements, and financial condition change statements.
In a third aspect, an embodiment of the present application provides an electronic device, which includes a memory for storing one or more programs; a processor. The program or programs, when executed by a processor, implement the method of any of the first aspects as described above.
In a fourth aspect, embodiments of the present application provide a computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the method according to any one of the first aspect described above.
Compared with the prior art, the embodiment of the invention has at least the following advantages or beneficial effects:
the invention provides a method and a system for generating financial statements, which comprises the following steps: s1: a user login request is detected. S2: when a user requests to log in, identity information input by the user is acquired. S3: and comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information. S4: when a user clicks a report generation option on the user operation interface, the Application component of the Excel opens the Excel report template. S5: and setting the data format of each financial statement in the Excel statement template according to the financial statement type to obtain the corresponding financial statement template. S6: determining a calculation formula and a required data type of each cell according to the data format, sequentially comparing the data types in the database according to the required data types, extracting specific data corresponding to the data types consistent with the required data types in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data into the corresponding cell. S7: repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement. The method and the system detect the input response of the user in real time, and pop up an identity authentication window to acquire the identity information input by the user when the user requests to log in. And comparing the identity information with a plurality of preset information one by one to carry out identity verification. And if the preset information consistent with the identity information input by the user exists, jumping to a user operation interface. And if the preset information consistent with the identity information input by the user does not exist, prompting the user to input the identity information again. And then can prevent that data from revealing, guaranteed the security of user operation. When a user clicks a report generation option on the user operation interface, an Application component of the Excel can open the Excel report template. And setting the data format of each financial statement in the Excel statement template according to the specific financial statement type in consideration of different data formats required by different financial statement types, and further using different financial statement templates for different financial statements so as to enable the generated financial statements to have pertinence. For any financial statement type, the calculation formula for each cell and the required data type involved in the calculation formula can be determined according to the data format of the financial statement. Comparing any required data type with the data types in the database one by one, extracting specific data corresponding to the data types consistent with the required data types in the database, inputting the specific data into a corresponding calculation formula to obtain a processing result, and inputting the processing result into a corresponding cell. And repeating the steps to fill all the cells in the corresponding financial statement template so as to obtain the corresponding financial statement. According to the method and the system for generating the financial statement, the user does not need to manually inquire the business documents one by one to calculate and fill in the cells, so that the tedious work of financial staff for making the financial statement is reduced, the efficiency of making the financial statement is improved, the condition of data filling errors can be prevented, and the accuracy of the financial statement is ensured.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed 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 for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a flowchart of a method for generating a financial statement according to an embodiment of the present invention;
fig. 2 is a block diagram of a system for generating financial statements according to an embodiment of the present invention;
fig. 3 is a schematic structural block diagram of an electronic device according to an embodiment of the present invention.
Icon: 100-a financial statement generating system; 110-login request detection module; 120-identity information acquisition module; 130-an identity verification module; 140-an Excel report template opening module; 150-obtaining a module corresponding to the financial statement template; 160-cell data calculation module; 170-corresponding financial statement acquisition module; 101-a memory; 102-a processor; 103-communication interface.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only for distinguishing the description, and are not construed as indicating or implying relative importance.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, the presence of an element identified by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
In the description of the present application, it should be noted that if the terms "upper", "lower", "inner", "outer", etc. are used to indicate an orientation or positional relationship based on that shown in the drawings or that the application product is usually placed in use, the description is merely for convenience and simplicity, and it is not intended to indicate or imply that the referred device or element must have a specific orientation, be constructed in a specific orientation, and be operated, and therefore should not be construed as limiting the present application.
In the description of the present application, it should also be noted that, unless otherwise explicitly stated or limited, the terms "disposed" and "connected" should be interpreted broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meaning of the above terms in the present application can be understood in a specific case by those of ordinary skill in the art.
Some embodiments of the present application will be described in detail below with reference to the accompanying drawings. The embodiments described below and the individual features of the embodiments can be combined with one another without conflict.
Examples
Referring to fig. 1, fig. 1 is a flowchart illustrating a method for generating a financial statement according to an embodiment of the present application. A method for generating financial statements comprises the following steps:
s1: detecting a user login request;
specifically, the input response of the user is detected in real time, so as to detect whether the user requests to log in.
S2: when a user requests to log in, acquiring identity information input by the user;
specifically, when the user requests to log in, an authentication window is popped up to remind the user to input identity information for authentication. After the user inputs the identity information, the identity information input by the user can be acquired in time.
S3: comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information;
specifically, the identity information is compared with a plurality of preset information one by one to perform identity authentication. And if the preset information consistent with the identity information input by the user exists, jumping to a user operation interface. And if the preset information which is consistent with the identity information input by the user does not exist, popping up the information of 'identity information error' and prompting the user to input the identity information again. And then can prevent that data from revealing, guaranteed the security of user operation. For example, the preset information may be identity information of a plurality of responsible persons.
S4: when a user clicks a report generation option on a user operation interface, an Application component of the Excel opens an Excel report template;
specifically, when a user needs to generate a financial report, the user can click a report generation option on an operation interface of the user, so that an Application component of the Excel can generate an Application form example, the financial report in the Excel report template can be inquired through the Application form example, and the Excel report template is opened. The Application component comprises a table, a cell and the like.
S5: setting the data format of each financial statement in the Excel statement template according to the financial statement type to obtain a corresponding financial statement template;
specifically, the financial statement types include a profit statement, an asset balance statement, a cash flow statement, a financial condition change statement, and the like. Different financial statement types require different data formats. And setting the data format of each financial statement in the Excel statement template according to the specific financial statement type to obtain the financial statement templates corresponding to the profit statement, the asset liability statement, the cash flow statement and the financial condition change statement respectively. Different financial statement templates are used for different financial statements, so that the generated financial statements are more targeted.
S6: determining a calculation formula and a required data type of each cell according to a data format, sequentially comparing the data types in the database according to the required data types, extracting specific data corresponding to the data types consistent with the required data types in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data into the corresponding cell;
specifically, for any financial statement type, the calculation formula of each cell and the required data type involved in the calculation formula can be determined according to the data format of the financial statement. Comparing any required data type with the data types in the database one by one, extracting specific data corresponding to the data types consistent with the required data types in the database, inputting the specific data into a corresponding calculation formula to process the specific data to obtain a processing result, and inputting the processing result into a corresponding cell. Therefore, the user does not need to manually inquire the business documents one by one to calculate and fill the cells, the tedious work of financial staff for making financial statements is reduced, and the efficiency of making the financial statements is improved.
S7: repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement.
Specifically, when one of the cells is completely filled, the next unfilled cell in the same column may be automatically detected in the column detection order, or the next unfilled cell in the same row may be automatically detected in the row detection order. The calculation formula for the cell and the desired data type involved in the calculation formula are obtained. Comparing any required data type with the data types in the database one by one, extracting specific data corresponding to the data types consistent with the required data types in the database, inputting the specific data into a calculation formula to obtain a processing result, and inputting the processing result into the cell. And repeating the steps until all the cells in the corresponding financial statement template are filled, thereby obtaining the corresponding financial statement. The financial statement generating method not only reduces the tedious work of financial staff for making financial statements, improves the efficiency for making financial statements, but also can prevent the condition of data filling errors, and ensures the accuracy of the financial statements.
In the implementation process, the input response of the user is detected in real time, and when the user requests to log in, an identity authentication window is popped up to obtain the identity information input by the user. And comparing the identity information with a plurality of preset information one by one to carry out identity verification. And if the preset information consistent with the identity information input by the user exists, jumping to a user operation interface. And if the preset information consistent with the identity information input by the user does not exist, prompting the user to input the identity information again. And then can prevent that data from revealing, guaranteed the security of user operation. When a user clicks a report generation option on the user operation interface, an Application component of the Excel can open the Excel report template. And setting the data format of each financial statement in the Excel statement template according to the specific financial statement type in consideration of different data formats required by different financial statement types, and further using different financial statement templates for different financial statements so as to enable the generated financial statements to have pertinence. For any financial statement type, the calculation formula for each cell and the required data type involved in the calculation formula can be determined according to the data format of the financial statement. Comparing any required data type with the data types in the database one by one, extracting specific data corresponding to the data types consistent with the required data types in the database, inputting the specific data into a corresponding calculation formula to obtain a processing result, and inputting the processing result into a corresponding cell. And repeating the steps to fill all the cells in the corresponding financial statement template so as to obtain the corresponding financial statement. According to the method for generating the financial statement, the user does not need to manually inquire the business documents one by one to calculate and fill in the cells, so that the tedious work of financial staff for making the financial statement is reduced, the efficiency of making the financial statement is improved, the condition of data filling errors can be prevented, and the accuracy of the financial statement is ensured.
In some implementations of this embodiment, cells for which no numerical value exists may be identified as a slash, e.g., "\".
In some embodiments of the present embodiment, the step of opening the Excel report template by the Application component of Excel includes: an Application component referencing Excel generates an Application form instance. And opening an Excel report template by utilizing the Application form example. Specifically, an Application form instance can be generated through an Application component of Excel, and the Application form instance can query a financial statement in an Excel statement template, so that the Excel statement template is opened.
In some embodiments of this embodiment, before the step of determining the calculation formula and the required data type of each cell according to the data format and sequentially comparing the data types in the database according to the required data types, the method further includes: and acquiring a document scanning image uploaded by a user, and inputting the document scanning image into a trained data extraction model to obtain specific data and a corresponding data type. And storing the specific data, the data type corresponding to the specific data and the document scanning image into a database. Specifically, the document scanning image uploaded by the user is input into the trained data extraction model, and the data extraction model can extract specific data in the document scanning image and judge the data type of the specific data. And storing the specific data obtained by the document scanning image and the data extraction model and the data type corresponding to the specific data into a database. When the user makes the financial statement, the data required by the financial statement is directly acquired from the database. Therefore, the loss of the business document can be prevented, the business document can be processed in advance before the financial statement is made, and the financial statement can be generated conveniently.
In some embodiments of the present embodiment, a data extraction initial network model is first established, and the data extraction initial network model may be a neural network model. And then obtaining a plurality of samples, wherein the samples are a plurality of business documents. And extracting the initial network model by using the plurality of business document training data to obtain a trained data extraction model.
In some embodiments of this embodiment, before the step of acquiring a document scan image uploaded by a user, the method further includes: and scanning the business document to obtain a document scanning image. And clicking a document uploading option on the user operation interface by the user to upload the scanned document image. Specifically, when the business document is a paper document, the business document is scanned to obtain a document scanning image, and the document scanning image is uploaded to achieve the purpose of obtaining the document scanning image.
In some embodiments of the present embodiment, before the step of opening the Excel report template by the Application component of Excel when the user clicks the report generation option on the user operation interface, the method further includes: and making an Excel report template. Specifically, the Excel report template is made, namely the content filled in each row and each column of each financial report in the Excel report template is determined, and the part of each financial report, which needs to acquire data from the database, is set to be null. The Excel report template can be artificially made.
In some embodiments of this embodiment, after the step of repeating S6 until all cells in the corresponding financial statement template are filled up to obtain the corresponding financial statement, the method further includes: and saving the corresponding financial statement to a database. And saving the corresponding financial statements and saving the generation time of the corresponding financial statements, thereby facilitating the user to check all the financial statements.
In some embodiments of this embodiment, the financial statement types include a profit statement, a balance statement, a cash flow statement, and a financial condition change statement.
Referring to fig. 2, fig. 2 is a block diagram illustrating a system 100 for generating financial statements according to an embodiment of the present disclosure. A financial statement generation system 100, comprising: a login request detection module 110, configured to detect a user login request. The identity information obtaining module 120 is configured to obtain the identity information input by the user when the user requests to log in. The identity verification module 130 is configured to compare the identity information with a plurality of preset information, and enter a user operation interface if the preset information is consistent with the identity information. The Excel report template opening module 140 is used for opening the Excel report template by the Application component of the Excel when the user clicks the report generation option on the user operation interface. And the corresponding financial statement template obtaining module 150 is used for setting the data format of each financial statement in the Excel statement template according to the financial statement type so as to obtain the corresponding financial statement template. The cell data calculation module 160 is configured to determine a calculation formula and a required data type of each cell according to the data format, sequentially compare the data types in the database according to the required data type, extract specific data corresponding to the data type in the database that is consistent with the required data type, process the specific data according to the corresponding calculation formula, and input the processed specific data to the corresponding cell. And the corresponding financial statement acquisition module 170 is configured to reuse the cell data calculation module 160 until all the cells in the corresponding financial statement template are filled up, so as to obtain a corresponding financial statement. Specifically, the login request detection module 110 detects an input response of the user in real time, and the identity information acquisition module 120 pops up an identity authentication window to acquire the identity information input by the user when the user requests to login. The identity information is compared with a plurality of preset information one by one through the identity verification module 130 to perform identity verification. And if the preset information consistent with the identity information input by the user exists, jumping to a user operation interface. When the user clicks the report generation option on the user operation interface through the Excel report template opening module 140, the Excel report template can be opened through the Application component of the Excel. Considering that the data formats required by different financial statement types are different, the data formats of the financial statements in the Excel statement template are set according to the specific financial statement types through the corresponding financial statement template obtaining module 150, and then different financial statement templates are used for different financial statements, so that the generated financial statements are more targeted. For any financial statement type, the calculation formula for each cell and the required data type involved in the calculation formula can be determined according to the data format of the financial statement. Comparing any required data type with the data types in the database one by one, extracting specific data corresponding to the data types consistent with the required data types in the database, inputting the specific data into a corresponding calculation formula to obtain a processing result, and inputting the processing result into a corresponding cell. And repeating the steps to fill all the cells in the corresponding financial statement template so as to obtain the corresponding financial statement. Therefore, the generating system 100 of the financial statement does not need a user to manually inquire the business documents one by one to calculate and fill in the cells, thereby not only reducing the tedious work of financial staff for making the financial statement and improving the efficiency for making the financial statement, but also preventing the condition of data filling errors and ensuring the accuracy of the financial statement.
In some embodiments of this embodiment, the Excel report template opening module 140 includes: and the form example generating unit is used for generating an Application form example by referring to the Application component of the Excel. And the Excel report template opening unit is used for opening the Excel report template by utilizing the Application form example. Specifically, the Application form instance can query the financial statement in the Excel statement template, so that the Excel statement template is opened.
In some embodiments of this embodiment, the system 100 for generating a financial statement further includes: and the document data extraction module is used for acquiring a document scanning image uploaded by a user and inputting the document scanning image into the trained data extraction model so as to obtain specific data and a corresponding data type. And the document storage module is used for storing the specific data, the data type corresponding to the specific data and the document scanning image into a database. Specifically, a document scanning image uploaded by a user is input to a trained data extraction model through a document data extraction module so as to extract specific data and data types of the specific data in the document scanning image. And the document storage module stores specific data obtained by scanning the image and the data extraction model and data types corresponding to the specific data into the database. When the user makes the financial statement, the user can directly acquire the data required by the financial statement from the database, so that the loss of the business document can be prevented, and the business document can be processed in advance before the financial statement is made, so that the financial statement can be conveniently generated.
In some embodiments of this embodiment, the system 100 for generating a financial statement further includes: and the document scanning module is used for scanning the business document to obtain a document scanning image. And the scanned image uploading module is used for the user to click the bill uploading option on the user operation interface and upload the scanned image of the bill. Specifically, when the business document is a paper document, the business document is scanned by the document scanning module to obtain a document scanning image, and the document scanning image is uploaded by the scanning image uploading module to achieve the purpose of obtaining the document scanning image.
In some embodiments of this embodiment, the system 100 for generating a financial statement further includes: and the report template making module is used for making the Excel report template. And manufacturing an Excel report template through a report template manufacturing module, namely determining the content filled in each row and each column of each financial report in the Excel report template, and setting the part of each financial report, which needs to acquire data from the database, as null.
In some embodiments of this embodiment, the system 100 for generating a financial statement further includes: and the corresponding financial statement storage module is used for storing the corresponding financial statement to the database. Therefore, the user can conveniently check all financial statements.
In some embodiments of this embodiment, the financial statement types include a profit statement, a balance statement, a cash flow statement, and a financial condition change statement.
Referring to fig. 3, fig. 3 is a schematic structural block diagram of an electronic device according to an embodiment of the present disclosure. The electronic device comprises a memory 101, a processor 102 and a communication interface 103, wherein the memory 101, the processor 102 and the communication interface 103 are electrically connected to each other directly or indirectly to realize data transmission or interaction. For example, the components may be electrically connected to each other via one or more communication buses or signal lines. The memory 101 may be used to store software programs and modules, such as program instructions/modules corresponding to the system 100 for generating financial statements provided in the embodiments of the present application, and the processor 102 executes the software programs and modules stored in the memory 101 to perform various functional applications and data processing. The communication interface 103 may be used for communicating signaling or data with other node devices.
The Memory 101 may be, but is not limited to, a Random Access Memory 101 (RAM), a Read Only Memory 101 (ROM), a Programmable Read Only Memory 101 (PROM), an Erasable Read Only Memory 101 (EPROM), an electrically Erasable Read Only Memory 101 (EEPROM), and the like.
The processor 102 may be an integrated circuit chip having signal processing capabilities. The Processor 102 may be a general-purpose Processor 102, including a Central Processing Unit (CPU) 102, a Network Processor 102 (NP), and the like; but may also be a Digital Signal processor 102 (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware components.
It will be appreciated that the configuration shown in fig. 3 is merely illustrative and that the electronic device may include more or fewer components than shown in fig. 3 or have a different configuration than shown in fig. 3. The components shown in fig. 3 may be implemented in hardware, software, or a combination thereof.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. The apparatus embodiments described above are merely illustrative, and for example, the flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, functional modules in the embodiments of the present application may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application or portions thereof that substantially contribute to the prior art may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory 101 (ROM), a Random Access Memory 101 (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
To sum up, the method and system for generating a financial statement provided by the embodiment of the present application includes the following steps: s1: a user login request is detected. S2: when a user requests to log in, identity information input by the user is acquired. S3: and comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information. S4: when a user clicks a report generation option on the user operation interface, the Application component of the Excel opens the Excel report template. S5: and setting the data format of each financial statement in the Excel statement template according to the financial statement type to obtain the corresponding financial statement template. S6: determining a calculation formula and a required data type of each cell according to the data format, sequentially comparing the data types in the database according to the required data types, extracting specific data corresponding to the data types consistent with the required data types in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data into the corresponding cell. S7: repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement. The method and the system detect the input response of the user in real time, and pop up an identity authentication window to acquire the identity information input by the user when the user requests to log in. And comparing the identity information with a plurality of preset information one by one to carry out identity verification. And if the preset information consistent with the identity information input by the user exists, jumping to a user operation interface. And if the preset information consistent with the identity information input by the user does not exist, prompting the user to input the identity information again. And then can prevent that data from revealing, guaranteed the security of user operation. When a user clicks a report generation option on the user operation interface, an Application component of the Excel can open the Excel report template. And setting the data format of each financial statement in the Excel statement template according to the specific financial statement type in consideration of different data formats required by different financial statement types, and further using different financial statement templates for different financial statements so as to enable the generated financial statements to have pertinence. For any financial statement type, the calculation formula for each cell and the required data type involved in the calculation formula can be determined according to the data format of the financial statement. Comparing any required data type with the data types in the database one by one, extracting specific data corresponding to the data types consistent with the required data types in the database, inputting the specific data into a corresponding calculation formula to obtain a processing result, and inputting the processing result into a corresponding cell. And repeating the steps to fill all the cells in the corresponding financial statement template so as to obtain the corresponding financial statement. According to the method and the system for generating the financial statement, the user does not need to manually inquire the business documents one by one to calculate and fill in the cells, so that the tedious work of financial staff for making the financial statement is reduced, the efficiency of making the financial statement is improved, the condition of data filling errors can be prevented, and the accuracy of the financial statement is ensured.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
It will be evident to those skilled in the art that the present application is not limited to the details of the foregoing illustrative embodiments, and that the present application may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the application being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned.
Claims (10)
1. A method for generating financial statements is characterized by comprising the following steps:
s1: detecting a user login request;
s2: when a user requests to log in, acquiring identity information input by the user;
s3: comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information;
s4: when a user clicks a report generation option on a user operation interface, an Application component of the Excel opens an Excel report template;
s5: setting the data format of each financial statement in the Excel statement template according to the financial statement type to obtain a corresponding financial statement template;
s6: determining a calculation formula and a required data type of each cell according to the data format, sequentially comparing the data types in the database according to the required data types, extracting specific data corresponding to the data types consistent with the required data types in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data into the corresponding cell;
s7: repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement.
2. A financial statement generation method according to claim 1 wherein said Excel Application component opens an Excel statement template comprising:
an Application component of the Excel is quoted to generate an Application form example;
and opening an Excel report template by utilizing the Application form example.
3. A method for generating a financial statement according to claim 1 wherein, prior to the step of determining the calculation formula and the required data type for each cell based on said data format and comparing the data types in the database in sequence based on the required data types, said method further comprises:
acquiring a document scanning image uploaded by a user, and inputting the document scanning image into a trained data extraction model to obtain specific data and a corresponding data type;
and storing the specific data, the data type corresponding to the specific data and the document scanning image into a database.
4. A method of generating a financial statement according to claim 3 wherein, prior to said step of obtaining a scanned image of a document uploaded by a user, said method further comprises:
scanning the business document to obtain a document scanning image;
and clicking a bill uploading option on a user operation interface by a user, and uploading the scanned bill image.
5. A method for generating a financial statement according to claim 1 wherein when the user clicks on the statement generation option on the user interface, the Application component of Excel opens the Excel statement template before the step of:
and making an Excel report template.
6. The method for generating financial statements according to claim 1 wherein, after said step of repeating S6 until all cells in the corresponding financial statement template are filled to obtain the corresponding financial statement, said method further comprises:
and saving the corresponding financial statement to a database.
7. A method of generating a financial statement according to claim 1 wherein said financial statement types include profit statement, balance statement, cash flow statement and financial condition change statement.
8. A system for generating financial statements, comprising:
the login request detection module is used for detecting a user login request;
the identity information acquisition module is used for acquiring the identity information input by the user when the user requests to log in;
the identity authentication module is used for comparing the identity information with a plurality of preset information, and entering a user operation interface if the preset information is consistent with the identity information;
the Excel report template opening module is used for opening the Excel report template by an Application component of the Excel when a user clicks a report generation option on a user operation interface;
the corresponding financial statement template obtaining module is used for setting the data format of each financial statement in the Excel statement template according to the financial statement type so as to obtain the corresponding financial statement template;
the cell data calculation module is used for determining a calculation formula and a required data type of each cell according to the data format, sequentially comparing the data types in the database according to the required data types, extracting specific data corresponding to the data types consistent with the required data types in the database, processing the specific data according to the corresponding calculation formula, and inputting the processed specific data into the corresponding cell;
and the corresponding financial statement acquisition module is used for repeatedly using the cell data calculation module until all the cells in the corresponding financial statement template are filled up so as to obtain a corresponding financial statement.
9. An electronic device, comprising:
a memory for storing one or more programs;
a processor;
the one or more programs, when executed by the processor, implement the method of any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110815713.3A CN113553819A (en) | 2021-07-19 | 2021-07-19 | Financial statement generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110815713.3A CN113553819A (en) | 2021-07-19 | 2021-07-19 | Financial statement generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113553819A true CN113553819A (en) | 2021-10-26 |
Family
ID=78103418
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110815713.3A Withdrawn CN113553819A (en) | 2021-07-19 | 2021-07-19 | Financial statement generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113553819A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114239532A (en) * | 2021-12-21 | 2022-03-25 | 中国建设银行股份有限公司 | Report generation method and device |
| CN115204126A (en) * | 2022-09-19 | 2022-10-18 | 北京必盈特信息技术有限公司 | Data filling method and device by utilizing online Excel |
-
2021
- 2021-07-19 CN CN202110815713.3A patent/CN113553819A/en not_active Withdrawn
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114239532A (en) * | 2021-12-21 | 2022-03-25 | 中国建设银行股份有限公司 | Report generation method and device |
| CN115204126A (en) * | 2022-09-19 | 2022-10-18 | 北京必盈特信息技术有限公司 | Data filling method and device by utilizing online Excel |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Link et al. | On the robustness of N‐mixture models | |
| CN110659318B (en) | Big data-based policy pushing method, system and computer equipment | |
| CN109934554A (en) | A kind of method, electric terminal and storage medium for examining invoice | |
| CN113553819A (en) | Financial statement generation method and system | |
| MXPA05011245A (en) | Realizing legally binding business contracts through service management models. | |
| US20200111188A1 (en) | Digitized test management center | |
| US9449285B2 (en) | System and method for using pattern recognition to monitor and maintain status quo | |
| US20150213460A1 (en) | Continuing-education certificate validation | |
| CN107741954B (en) | Declaration and entry method of electronic document, server and storage medium | |
| CN114331315A (en) | Social security service processing method and device combining RPA and AI | |
| CN112131131A (en) | Automatic interface testing framework system for pre-constructed domain name and request body | |
| CN117036073A (en) | Invoice auditing and automatic reimbursement system based on Internet | |
| US20200111379A1 (en) | Mitigating variance in standardized test administration using machine learning | |
| US11816112B1 (en) | Systems and methods for automated process discovery | |
| CN117150233B (en) | Power grid abnormal data management method, system, equipment and medium | |
| CN114238148A (en) | Business system login test method, device, equipment and medium | |
| CN114154712A (en) | Data management method, data management device, equipment and storage medium | |
| US20240070570A1 (en) | Intelligent document processing in enterprise resource planning | |
| CN113051257B (en) | Service data cleaning method and device | |
| Maiti | Capturing, Eliciting, and Prioritizing (CEP) Non-Functional Requirements Metadata during the Early Stages of Agile Software Development | |
| CN110781142B (en) | Data import method and device, server and storage medium | |
| CN114298649A (en) | Report data processing method and device, electronic equipment and storage medium | |
| US20240143919A1 (en) | Systems and methods for extracting data from documents | |
| Kollu | Smart budget assistant | |
| CN118644350A (en) | Method for generating policy, computing device 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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20211026 |