CN117993372A - Excel-like financial statement generation method and system - Google Patents

Excel-like financial statement generation method and system Download PDF

Info

Publication number
CN117993372A
CN117993372A CN202311843483.7A CN202311843483A CN117993372A CN 117993372 A CN117993372 A CN 117993372A CN 202311843483 A CN202311843483 A CN 202311843483A CN 117993372 A CN117993372 A CN 117993372A
Authority
CN
China
Prior art keywords
financial statement
financial
file
template
server
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
Application number
CN202311843483.7A
Other languages
Chinese (zh)
Inventor
杨辉
黄家昌
陈振鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Ecan Information Technology Co ltd
Original Assignee
Fujian Ecan Information Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian Ecan Information Technology Co ltd filed Critical Fujian Ecan Information Technology Co ltd
Priority to CN202311843483.7A priority Critical patent/CN117993372A/en
Publication of CN117993372A publication Critical patent/CN117993372A/en
Pending legal-status Critical Current

Links

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention provides a exce l-like financial statement generation method and a exce l-like financial statement generation system in the technical field of financial statement management, wherein the method comprises the following steps: s1, accessing a server through a browser and carrying out authentication, and configuring a financial statement template on the server; s2, defining a plurality of financial number taking formulas in the financial statement template through a formula guide page; s3, adding a control group in the financial statement template; s4, after naming the financial statement template, generating a financial statement file in a specified format, and storing the financial statement file to a specified path; and S5, accessing the appointed path of the server through a browser to perform online management including addition, deletion, modification, inquiry, export and printing on the financial report file. The invention has the advantages that: the convenience, the instantaneity and the reusability of the financial statement generation are greatly improved.

Description

Excel-like financial statement generation method and system
Technical Field
The invention relates to the technical field of financial statement management, in particular to a method and a system for generating an excel-like financial statement.
Background
The financial report is an accounting report reflecting the fund and profit conditions of enterprises or budget units in a certain period, and is one of the most important reports of each enterprise and unit. Conventionally, in order to generate a financial statement, first, financial statement generating software, such as office or WPS, needs to be installed on a computer, then corresponding data is entered in the financial statement generating software, and the entered data is manually checked, which has the following drawbacks:
1. Related software needs to be installed locally, and a user is required to design and edit financial reports by himself, so that the cost of the user's hands is high; 2. when the data of the financial report is updated, the associated data needs to be manually updated, so that the real-time property of the data is poor; 3. the reusability of the financial statement is poor, and corresponding adjustment is needed to be carried out manually; 4. the financial statement cannot be remotely checked and modified, and inconvenience is brought to management of the financial statement.
Therefore, how to provide a method and a system for generating a financial statement similar to excel, so as to improve convenience, instantaneity and reusability of generating the financial statement, is a technical problem to be solved urgently.
Disclosure of Invention
The invention aims to solve the technical problem of providing an excel-like financial statement generation method and system, and the convenience, instantaneity and reusability of financial statement generation are improved.
In a first aspect, the invention provides an excel-like financial statement generation method, which comprises the following steps:
S1, accessing a server through a browser and carrying out authentication, and configuring a financial statement template on the server;
s2, defining a plurality of financial number taking formulas in the financial statement template through a formula guide page;
S3, adding a control group in the financial statement template;
S4, after naming the financial statement template, generating a financial statement file in a specified format, and storing the financial statement file to a specified path;
And S5, accessing the appointed path of the server through a browser to perform online management including addition, deletion, modification, inquiry, export and printing on the financial report file.
Further, the step S1 specifically includes:
Sending an access request carrying a signature to a server through a browser, analyzing the received access request by the server to obtain the signature, and feeding back an access permission response to the browser after verifying the signature;
The browser establishes connection with the server based on the access permission response, and configures a financial statement template on the server in a mode of copying, pasting or importing files;
the copy-paste supports operating only the content or simultaneously operating the content and format; the financial statement template at least supports the functions of format brushing, cell batch copying, mouse dragging for rapidly filling cell content, batch searching, batch replacing and functions.
Further, the step S2 specifically includes:
Through the formula guide page provided with the number taking formula, the formula type, the accounting subjects, the number taking years and the formula preview, a plurality of financial number taking formulas for acquiring data from a database or a designated financial report file are defined at designated positions in the financial report template.
Further, the step S3 specifically includes:
adding a control group comprising a time interaction control, a tree control and a query control into the financial statement template;
the time interaction control is used for inquiring data of specified time in the financial report file; the tree control is used for displaying the logic relation among the data; the query control is used for carrying out data query according to the query conditions.
Further, the step S4 specifically includes:
and after naming the financial statement template, generating a financial statement file in a specified format based on a save button or a save instruction triggered by a save shortcut, encrypting the financial statement file by using a cryptographic algorithm, and saving the encrypted financial statement file to a specified path.
In a second aspect, the invention provides an excel-like financial statement generation system, which comprises the following modules:
The financial statement template configuration module is used for configuring a financial statement template on the server after the server is accessed and authenticated through the browser;
The financial get formula definition module is used for defining a plurality of financial get formulas in the financial statement template through a formula guide page;
The control group adding module is used for adding a control group in the financial statement template;
The financial statement file generation module is used for generating a financial statement file in a specified format after naming the financial statement template, and storing the financial statement file to a specified path;
and the financial statement file management module is used for accessing the appointed path of the server through a browser so as to perform online management including addition, deletion, modification, inquiry, export and printing on the financial statement file.
Further, the financial statement template configuration module is specifically configured to:
Sending an access request carrying a signature to a server through a browser, analyzing the received access request by the server to obtain the signature, and feeding back an access permission response to the browser after verifying the signature;
The browser establishes connection with the server based on the access permission response, and configures a financial statement template on the server in a mode of copying, pasting or importing files;
the copy-paste supports operating only the content or simultaneously operating the content and format; the financial statement template at least supports the functions of format brushing, cell batch copying, mouse dragging for rapidly filling cell content, batch searching, batch replacing and functions.
Further, the financial access formula definition module is specifically configured to:
Through the formula guide page provided with the number taking formula, the formula type, the accounting subjects, the number taking years and the formula preview, a plurality of financial number taking formulas for acquiring data from a database or a designated financial report file are defined at designated positions in the financial report template.
Further, the control group adding module is specifically configured to:
adding a control group comprising a time interaction control, a tree control and a query control into the financial statement template;
the time interaction control is used for inquiring data of specified time in the financial report file; the tree control is used for displaying the logic relation among the data; the query control is used for carrying out data query according to the query conditions.
Further, the financial report file generation module is specifically configured to:
and after naming the financial statement template, generating a financial statement file in a specified format based on a save button or a save instruction triggered by a save shortcut, encrypting the financial statement file by using a cryptographic algorithm, and saving the encrypted financial statement file to a specified path.
The invention has the advantages that:
After accessing a server through a browser and authenticating, configuring a financial statement template in the server, defining a plurality of financial number taking formulas in the financial statement template through a formula guide page, adding a control group in the financial statement template, naming the financial statement template, generating a financial statement file in a specified format, storing the financial statement file in a specified path, and finally accessing the specified path of the server through the browser to perform online management including addition, deletion, modification, inquiry, export and printing on the financial statement file; the financial statement file can be generated through the browser without installing financial statement generating software locally through the browser, and the financial statement file can be subjected to online management including addition, deletion, modification, inquiry, export and printing, and the financial statement file is generated based on a financial statement template, so that the cost of the user on hand is greatly reduced; by defining a financial taking formula, when source data change, corresponding data in a financial report file can be updated in real time without manually checking the data; by adding the control group comprising the time interaction control, the tree control and the query control, related data can be quickly queried and reused through the control group, and convenience, instantaneity and reusability of financial statement generation are greatly improved finally.
Drawings
The invention will be further described with reference to examples of embodiments with reference to the accompanying drawings.
FIG. 1 is a flow chart of an excel-like financial statement generation method of the present invention.
FIG. 2 is a schematic diagram of an excel-like financial statement generating system of the present invention.
FIG. 3 is a schematic interface diagram of the financial reporting model of the present invention.
FIG. 4 is a schematic interface diagram of a formula wizard page of the present invention.
FIG. 5 is a schematic diagram of an interface for defining a financial access formula in accordance with the present invention.
FIG. 6 is a schematic interface diagram of an add control group of the present invention.
FIG. 7 is a schematic diagram of an interface for storing financial statement files in accordance with the present invention.
FIG. 8 is a schematic diagram of an interface for querying a financial statement file in accordance with the present invention.
Detailed Description
The technical scheme in the embodiment of the application has the following overall thought: the financial statement file generation and on-line management can be performed through the browser without locally installing financial statement generation software through the browser, the user' S hand cost is reduced through generating the financial statement file based on the financial statement template, corresponding data in the financial statement file is updated in real time through defining a financial number formula, and related data are queried and reused through adding a control group comprising a time interaction control, a tree control and a query control, so that convenience, instantaneity and reusability of financial statement generation are improved.
Referring to fig. 1 to 8, a preferred embodiment of an excel-like financial statement generation method of the present invention includes the following steps:
S1, accessing a server through a browser and carrying out authentication, and configuring a financial statement template on the server;
S2, defining a plurality of financial number taking formulas in the financial statement template through a formula guide page; the built-in financial number formula has a certain expansibility in logic, and can be expanded and adjusted according to different demand scenes;
S3, adding a control group in the financial statement template;
S4, after naming the financial statement template, generating a financial statement file in a specified format, and storing the financial statement file to a specified path;
And S5, accessing the appointed path of the server through a browser to perform online management including addition, deletion, modification, inquiry, export and printing on the financial report file.
The step S1 specifically comprises the following steps:
Sending an access request carrying a signature to a server through a browser, analyzing the received access request by the server to obtain the signature, and feeding back an access permission response to the browser after verifying the signature;
The browser establishes connection with the server based on the access permission response, and configures a financial statement template on the server in a mode of copying, pasting or importing files;
the copy-paste supports operating only the content or simultaneously operating the content and format; the financial statement template at least supports the functions of format brushing, cell batch copying, mouse dragging for rapidly filling cell content, batch searching, batch replacing and functions.
And the financial statement template leaves white in the cells needing to be filled with data. For excel files with multiple sheets, multiple copy-and-paste is also a nuisance, so that import files are also supported, and form areas of the financial reporting templates are automatically parsed and displayed back.
The step S2 specifically comprises the following steps:
Through the formula guide page provided with the number taking formula, the formula type, the accounting subjects, the number taking years and the formula preview, a plurality of financial number taking formulas for acquiring data from a database or a designated financial report file are defined at designated positions in the financial report template.
For example, define a financial score formula KMNC (subject number, year) for dynamically obtaining the initial year of the specified subject under the condition of the specified year, and return a result value of 3 after inputting = SUM (1, 2) in excel; when the formula is input on the financial statement, help information of the formula can be displayed, and the result value of the formula can be dynamically displayed back after the input is finished. The expected result value can be obtained only by inputting the financial number formula, so that the efficiency is improved to a great extent, and meanwhile, compared with the traditional manual check data, the data calculated by the program has higher accuracy. Because the financial number formula is a built-in formula, learning cost is unavoidable for a user who uses the formula for the first time, and therefore, the formula is provided for assisting in generating the financial number formula by the formula wizard page. In consideration of the fact that certain relevance may exist among data of different financial reports, a formula capable of acquiring specified sheet specified cells of specified reports under specified conditions is added to a basic data query formula, so that the check of financial audit relations among the financial reports is facilitated.
The step S3 specifically comprises the following steps:
adding a control group comprising a time interaction control, a tree control and a query control into the financial statement template;
The time interaction control is used for inquiring data of specified time in the financial statement file, and financial statement adjustment is not needed; the tree control is used for displaying the logic relation among the data; the query control is used for carrying out data query according to query conditions, and preventing single control from being touched by mistake or multiple invalid queries triggered under a scene requiring multi-condition combined query.
The step S4 specifically includes:
And after naming the financial statement template, generating a financial statement file in a specified format based on a save button or a save instruction triggered by a save shortcut, encrypting the financial statement file by using a cryptographic algorithm, and saving the encrypted financial statement file to a specified path. The preservation shortcut is selected as ctrl+s; the specified format at least comprises an excel format or a pdf format. And naming the financial statement template is convenient for later retrieval and inquiry.
The preferred embodiment of the excel-like financial statement generation system comprises the following modules:
The financial statement template configuration module is used for configuring a financial statement template on the server after the server is accessed and authenticated through the browser;
the financial get formula definition module is used for defining a plurality of financial get formulas in the financial statement template through a formula guide page; the built-in financial number formula has a certain expansibility in logic, and can be expanded and adjusted according to different demand scenes;
The control group adding module is used for adding a control group in the financial statement template;
The financial statement file generation module is used for generating a financial statement file in a specified format after naming the financial statement template, and storing the financial statement file to a specified path;
and the financial statement file management module is used for accessing the appointed path of the server through a browser so as to perform online management including addition, deletion, modification, inquiry, export and printing on the financial statement file.
The financial statement template configuration module is specifically used for:
Sending an access request carrying a signature to a server through a browser, analyzing the received access request by the server to obtain the signature, and feeding back an access permission response to the browser after verifying the signature;
The browser establishes connection with the server based on the access permission response, and configures a financial statement template on the server in a mode of copying, pasting or importing files;
the copy-paste supports operating only the content or simultaneously operating the content and format; the financial statement template at least supports the functions of format brushing, cell batch copying, mouse dragging for rapidly filling cell content, batch searching, batch replacing and functions.
And the financial statement template leaves white in the cells needing to be filled with data. For excel files with multiple sheets, multiple copy-and-paste is also a nuisance, so that import files are also supported, and form areas of the financial reporting templates are automatically parsed and displayed back.
The financial access formula definition module is specifically used for:
Through the formula guide page provided with the number taking formula, the formula type, the accounting subjects, the number taking years and the formula preview, a plurality of financial number taking formulas for acquiring data from a database or a designated financial report file are defined at designated positions in the financial report template.
For example, define a financial score formula KMNC (subject number, year) for dynamically obtaining the initial year of the specified subject under the condition of the specified year, and return a result value of 3 after inputting = SUM (1, 2) in excel; when the formula is input on the financial statement, help information of the formula can be displayed, and the result value of the formula can be dynamically displayed back after the input is finished. The expected result value can be obtained only by inputting the financial number formula, so that the efficiency is improved to a great extent, and meanwhile, compared with the traditional manual check data, the data calculated by the program has higher accuracy. Because the financial number formula is a built-in formula, learning cost is unavoidable for a user who uses the formula for the first time, and therefore, the formula is provided for assisting in generating the financial number formula by the formula wizard page. In consideration of the fact that certain relevance may exist among data of different financial reports, a formula capable of acquiring specified sheet specified cells of specified reports under specified conditions is added to a basic data query formula, so that the check of financial audit relations among the financial reports is facilitated.
The control group adding module is specifically configured to:
adding a control group comprising a time interaction control, a tree control and a query control into the financial statement template;
The time interaction control is used for inquiring data of specified time in the financial statement file, and financial statement adjustment is not needed; the tree control is used for displaying the logic relation among the data; the query control is used for carrying out data query according to query conditions, and preventing single control from being touched by mistake or multiple invalid queries triggered under a scene requiring multi-condition combined query.
The financial statement file generation module is specifically used for:
And after naming the financial statement template, generating a financial statement file in a specified format based on a save button or a save instruction triggered by a save shortcut, encrypting the financial statement file by using a cryptographic algorithm, and saving the encrypted financial statement file to a specified path. The preservation shortcut is selected as ctrl+s; the specified format at least comprises an excel format or a pdf format. And naming the financial statement template is convenient for later retrieval and inquiry.
In summary, the invention has the advantages that:
After accessing a server through a browser and authenticating, configuring a financial statement template in the server, defining a plurality of financial number taking formulas in the financial statement template through a formula guide page, adding a control group in the financial statement template, naming the financial statement template, generating a financial statement file in a specified format, storing the financial statement file in a specified path, and finally accessing the specified path of the server through the browser to perform online management including addition, deletion, modification, inquiry, export and printing on the financial statement file; the financial statement file can be generated through the browser without installing financial statement generating software locally through the browser, and the financial statement file can be subjected to online management including addition, deletion, modification, inquiry, export and printing, and the financial statement file is generated based on a financial statement template, so that the cost of the user on hand is greatly reduced; by defining a financial taking formula, when source data change, corresponding data in a financial report file can be updated in real time without manually checking the data; by adding the control group comprising the time interaction control, the tree control and the query control, related data can be quickly queried and reused through the control group, and convenience, instantaneity and reusability of financial statement generation are greatly improved finally.
While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that the specific embodiments described are illustrative only and not intended to limit the scope of the invention, and that equivalent modifications and variations of the invention in light of the spirit of the invention will be covered by the claims of the present invention.

Claims (10)

1. A kind of excel financial statement generation method is characterized in that: the method comprises the following steps:
S1, accessing a server through a browser and carrying out authentication, and configuring a financial statement template on the server;
s2, defining a plurality of financial number taking formulas in the financial statement template through a formula guide page;
S3, adding a control group in the financial statement template;
S4, after naming the financial statement template, generating a financial statement file in a specified format, and storing the financial statement file to a specified path;
And S5, accessing the appointed path of the server through a browser to perform online management including addition, deletion, modification, inquiry, export and printing on the financial report file.
2. An excel-like financial statement generation method as set forth in claim 1, characterized in that: the step S1 specifically comprises the following steps:
Sending an access request carrying a signature to a server through a browser, analyzing the received access request by the server to obtain the signature, and feeding back an access permission response to the browser after verifying the signature;
The browser establishes connection with the server based on the access permission response, and configures a financial statement template on the server in a mode of copying, pasting or importing files;
the copy-paste supports operating only the content or simultaneously operating the content and format; the financial statement template at least supports the functions of format brushing, cell batch copying, mouse dragging for rapidly filling cell content, batch searching, batch replacing and functions.
3. An excel-like financial statement generation method as set forth in claim 1, characterized in that: the step S2 specifically comprises the following steps:
Through the formula guide page provided with the number taking formula, the formula type, the accounting subjects, the number taking years and the formula preview, a plurality of financial number taking formulas for acquiring data from a database or a designated financial report file are defined at designated positions in the financial report template.
4. An excel-like financial statement generation method as set forth in claim 1, characterized in that: the step S3 specifically comprises the following steps:
adding a control group comprising a time interaction control, a tree control and a query control into the financial statement template;
the time interaction control is used for inquiring data of specified time in the financial report file; the tree control is used for displaying the logic relation among the data; the query control is used for carrying out data query according to the query conditions.
5. An excel-like financial statement generation method as set forth in claim 1, characterized in that: the step S4 specifically includes:
and after naming the financial statement template, generating a financial statement file in a specified format based on a save button or a save instruction triggered by a save shortcut, encrypting the financial statement file by using a cryptographic algorithm, and saving the encrypted financial statement file to a specified path.
6. An excel-like financial statement generation system, which is characterized in that: the device comprises the following modules:
The financial statement template configuration module is used for configuring a financial statement template on the server after the server is accessed and authenticated through the browser;
The financial get formula definition module is used for defining a plurality of financial get formulas in the financial statement template through a formula guide page;
The control group adding module is used for adding a control group in the financial statement template;
The financial statement file generation module is used for generating a financial statement file in a specified format after naming the financial statement template, and storing the financial statement file to a specified path;
and the financial statement file management module is used for accessing the appointed path of the server through a browser so as to perform online management including addition, deletion, modification, inquiry, export and printing on the financial statement file.
7. An excel-like financial statement generation system in accordance with claim 6, wherein: the financial statement template configuration module is specifically used for:
Sending an access request carrying a signature to a server through a browser, analyzing the received access request by the server to obtain the signature, and feeding back an access permission response to the browser after verifying the signature;
The browser establishes connection with the server based on the access permission response, and configures a financial statement template on the server in a mode of copying, pasting or importing files;
the copy-paste supports operating only the content or simultaneously operating the content and format; the financial statement template at least supports the functions of format brushing, cell batch copying, mouse dragging for rapidly filling cell content, batch searching, batch replacing and functions.
8. An excel-like financial statement generation system in accordance with claim 6, wherein: the financial access formula definition module is specifically used for:
Through the formula guide page provided with the number taking formula, the formula type, the accounting subjects, the number taking years and the formula preview, a plurality of financial number taking formulas for acquiring data from a database or a designated financial report file are defined at designated positions in the financial report template.
9. An excel-like financial statement generation system in accordance with claim 6, wherein: the control group adding module is specifically configured to:
adding a control group comprising a time interaction control, a tree control and a query control into the financial statement template;
the time interaction control is used for inquiring data of specified time in the financial report file; the tree control is used for displaying the logic relation among the data; the query control is used for carrying out data query according to the query conditions.
10. An excel-like financial statement generation system in accordance with claim 6, wherein: the financial statement file generation module is specifically used for:
and after naming the financial statement template, generating a financial statement file in a specified format based on a save button or a save instruction triggered by a save shortcut, encrypting the financial statement file by using a cryptographic algorithm, and saving the encrypted financial statement file to a specified path.
CN202311843483.7A 2023-12-29 2023-12-29 Excel-like financial statement generation method and system Pending CN117993372A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311843483.7A CN117993372A (en) 2023-12-29 2023-12-29 Excel-like financial statement generation method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311843483.7A CN117993372A (en) 2023-12-29 2023-12-29 Excel-like financial statement generation method and system

Publications (1)

Publication Number Publication Date
CN117993372A true CN117993372A (en) 2024-05-07

Family

ID=90896737

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311843483.7A Pending CN117993372A (en) 2023-12-29 2023-12-29 Excel-like financial statement generation method and system

Country Status (1)

Country Link
CN (1) CN117993372A (en)

Similar Documents

Publication Publication Date Title
US20200334412A1 (en) Data storage medium having a computer program executable to generate a detail document
US9721016B2 (en) System and method to search and generate reports from semi-structured data including dynamic metadata
US7444332B2 (en) Strict validation of inference rule based on abstraction environment
US8996559B2 (en) Assisted query formation, validation, and result previewing in a database having a complex schema
US7689578B2 (en) Dealing with annotation versioning through multiple versioning policies and management thereof
US8234562B1 (en) Error checking for data entry
CN110325961A (en) Software application exploitation based on electrical form
US20070112827A1 (en) Abstract rule sets
US20110066643A1 (en) System and method for assembling, verifying, and distibuting financial information
US20100063971A1 (en) Universal annotation configuration and deployment
US20080301108A1 (en) Dynamic discovery of abstract rule set required inputs
US20110066645A1 (en) System and method for assembling, verifying, and distibuting financial information
CN111563200A (en) Information display method, device, equipment and medium
WO2021169300A1 (en) Method and apparatus for exporting database table structure, and terminal device
CN116541372A (en) Data asset management method and system
CN103426049A (en) WEB-based compound management method and system
US11526367B1 (en) Systems and methods for translation of a digital document to an equivalent interactive user interface
US20110066644A1 (en) System and method for assembling, verifying, and distibuting financial information
CN111950976A (en) Engineering project review system and method
CN117993372A (en) Excel-like financial statement generation method and system
US20230195792A1 (en) Database management methods and associated apparatus
CN112800127B (en) Data mining analysis method and device based on transaction bill
CN101576917A (en) System for analyzing human factors of unsafe events in aviation
US11507628B1 (en) Process automation platform using document database
CN113377367B (en) Data collection method, 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