CN112348652A - Enterprise financial statement generation system based on original certificate data - Google Patents
Enterprise financial statement generation system based on original certificate data Download PDFInfo
- Publication number
- CN112348652A CN112348652A CN202011372903.4A CN202011372903A CN112348652A CN 112348652 A CN112348652 A CN 112348652A CN 202011372903 A CN202011372903 A CN 202011372903A CN 112348652 A CN112348652 A CN 112348652A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- module
- statement
- calculation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses an enterprise financial statement generating system based on original certificate data, which comprises a statement configuration module, a template management module, a certificate data processing module, a statement data calculation module, a statement data display module and a database. This patent adopts the technical scheme of data dictionary combination free configuration statement rule, has solved the problem that financial staff calculates financial statement complicacy and easily make mistakes, adopts the statement rule technical scheme that can freely configure, simplifies financial staff's work and guarantees the accuracy of statement data.
Description
Technical Field
The invention relates to the technical field of computers, in particular to an enterprise financial statement generating system based on original certificate data.
Background
The financial statements reflect the financial status, the operational results and the cash flow of the enterprises in a period of time. By analyzing the financial statement data, the enterprise operator can know the completion condition of each task index of the enterprise, and the enterprise operator can find problems in time and adjust the operation direction and strategy. Nowadays, the enterprise financial management system has the characteristics of complex accounting criteria, small enterprise business diversity, a large amount of to-be-processed original voucher information, checking relationship between tables and the like, so that financial staff are complex in calculation and time-consuming when generating financial reports.
In order to solve the problems, most of the existing report generation methods adopt a preset complete set of report templates, and a user can generate report data corresponding to the templates by directly filling data; or providing a report form calculation formula editing function or separating an operation formula from data, and calculating the original certificate data according to the calculation formula. The complete report template method can only generate financial report data according to the provided template, is lack of flexibility and cannot meet the diversity requirements of enterprise business; the method for editing the calculation formula ensures that financial staff need to edit a large number of complicated formulas, thereby increasing the complexity of work, and the method for separating the calculation formula from the report data has the precondition of ensuring the correctness of input data, otherwise, the method for generating the whole report is influenced by the fact that an accurate calculation formula cannot be obtained.
Disclosure of Invention
In order to solve the technical problems, the invention provides an enterprise financial statement generating system based on original voucher data, a statement rule term familiar to financial staff is adopted to form a data dictionary, and when the financial staff configures the calculation rule for each calculation cell of a statement, the financial staff can easily configure the rule only by calling the data dictionary through the system. After the report rule is configured, the system automatically pulls the original certificate information of the certificate system to generate financial report data, no financial staff participates in the calculation process, the human intervention is eliminated, the accuracy of the report data is guaranteed, and the financial staff only need to obtain the required financial report through a management platform of the system.
In order to achieve the technical effects, the invention adopts the following technical scheme:
an enterprise financial statement generating system based on original certificate data comprises a statement configuration module, a template management module, a certificate data processing module, a statement data calculation module, a statement data display module and a database;
the report configuration module is used for providing new functions of different types of reports for users and adding required configuration items for the new reports;
the template management module is used for uploading and configuring a template for the calculation type report and editing rules required by the calculation of the report cells;
the voucher data processing module is used for analyzing original voucher data according to a voucher access rule and dividing the original voucher data into basic voucher data in the forms of a voucher head and a voucher line for storage when the original voucher data generated after automatic accounting or manual accounting is subjected to message notification;
the report data calculation module is used for taking the basic voucher data and calculating the report data by using the configuration items and the stored rules;
the report display module is used for receiving a user query request to acquire report data and displaying the report data;
the database is used for storing report basic information, configuration item information, template information, rule information, basic certificate data and calculated report data.
The further technical scheme is that the configuration items of the newly added report in the report configuration module comprise access rules and filtering items; the access rule comprises an access mode and an access logic item, wherein the access mode is used for judging whether the newly added report data needs to be obtained by calculation according to the rule, and is edited by the calculation type report rule; the filtering items comprise filtering conditions required by acquiring the report data of the calculation class and the detail class.
The further technical scheme is that the configuration items of the report configuration module also comprise report data display fields and display style information.
The further technical scheme is that the template management module has a template configuration function and a rule editing function; the template configuration function is used for uploading report templates for the calculation type reports, uploading a plurality of templates and distributing different templates for different accounting units; and the rule editing function is used for editing the uploaded template according to the rules of calculating the amount of the unit cell.
The further technical scheme is that when the user edits the rule, the template management module calls the report configuration module to acquire the access mode and the access logic item of the report for the user to select.
After the rule is edited, the template management module calls a report data calculation module to generate corresponding report data; after the rule is changed, the user can recalculate the report data through the page refreshing function.
The report display module can acquire report data according to the filter items, the display fields and the display styles.
The report display module also has a data refreshing function.
When the original certificate data is notified, the report data calculation module calls the report configuration module to acquire the configuration item information and search for the calculation type report, searches for the distributed template according to the accounting unit in the original certificate data to acquire the rule configured by the template to calculate the report data, and stores the calculation result in the database.
Compared with the prior art, the invention has the following beneficial effects: the invention designs a financial statement generating system with universality and flexibility based on data provided by an original certificate generating system by means of a computer technology. The system provides a function that each report of each enterprise can be independently configured with calculation rules, forms a data dictionary with report rule terms familiar to financial staff, and enables the financial staff to call the data dictionary to configure the calculation rules of each calculation cell of the report through the system. The system converts the report rule configured by the financial staff into a mathematical expression for storage, and is used for calculating the generation of report data. The invention provides a simple and understandable operation interface for financial staff, greatly reduces the labor and time of enterprises, and simultaneously ensures the accuracy of financial statements.
Drawings
FIG. 1 is a schematic diagram of the system of the present invention;
FIG. 2 is a flow chart of the present invention.
Detailed Description
The invention will be further explained and explained with reference to the drawings and the embodiments.
Example 1
As shown in fig. 1, the invention provides an enterprise financial statement generating system based on original voucher data, which comprises a statement configuration module, a template management module, a voucher data processing module, a statement data calculation module, a statement data display module and a database.
The report configuration module provides functions of adding new reports and adding configuration items for the reports for users. The newly added report function provides functions of selecting different accounting units and adding respective report information under the accounting units, and the selectable configuration item information comprises access rules, filtering items, report data display fields, display style information and the like. The access rule comprises an access mode and an access logic item, wherein the access mode is used for judging whether the newly added report data needs to be obtained by calculation according to the rule, and is edited by the calculation type report rule; the filtering items comprise filtering conditions required by acquiring the report data of the calculation class and the detail class.
The access rule configured for the report by the report configuration module comprises whether report data needs to be obtained by calculation according to the rule, an access mode edited by a calculation type report rule and a filter item when detail type report data is obtained. Meanwhile, the configuration item also comprises report data display fields and styles, and a voucher value rule and a processing mode of canceling the voucher during the data processing of the original voucher.
The report configuration module also comprises a data dictionary formed by the configuration item information and financial rule terms, and a basis is provided for report rule configuration.
The module management module is divided into a template uploading function and a rule editing function. The template uploading function is used for uploading a report template for the calculation type report, a plurality of templates can be uploaded, and different templates can be distributed for different accounting units; and the rule editing function is used for editing the uploaded template according to the rules of the calculation of the amount of the unit grid, and calling the report configuration module to acquire the access mode and the access logic item of the edited report during the rule editing. Calling a report data calculation module to generate corresponding report data after the editing is finished; after the rule is changed, the user can send a data refreshing request to the report data display module to recalculate the corresponding report data.
And the voucher data processing module is used for analyzing the original voucher data according to a voucher access rule and dividing the original voucher data into basic voucher data in the form of a voucher head and a voucher line for storage when the original voucher data generated after automatic accounting or manual accounting is subjected to message notification.
And the report data calculation module is used for taking basic voucher data stored by the voucher data processing module when the original voucher data is notified, acquiring the configuration item information, searching for a calculation type report, searching for the distributed template according to the accounting unit in the basic voucher data to acquire the rule configured by the template, calculating the report data, and storing the calculation result. And the report data calculation module also provides a historical data processing function after the template rule is changed.
The report display module provides a page operation function for a user, the user sends a data acquisition request to the report display module, and the report display module acquires report data according to a series of screening conditions and displays the data according to a style configured by the user. And also provides a report data refreshing function to recalculate the report data within the selected range.
The database is used for storing report basic information, configuration item information, template information, rule information, basic certificate data and calculated report data.
FIG. 2 is a flowchart of an enterprise financial statement generating system based on original credential data according to the present invention. The operation process comprises the following steps:
1) after entering the financial statement management platform, a user sends a request to the statement configuration module through the management platform, a new financial statement is added, the basic information comprises a statement name and the like, and whether statement data needs to be calculated, and statement field display and display styles are configured for the financial statement. If the report is configured as a calculation type report, a data fetching mode and data fetching logic need to be configured for the report.
2) If the newly added financial statement is a calculation financial statement, a user sends a request to the template management module through the management platform, a plurality of templates can be uploaded simultaneously for uploading the templates of the calculation financial statement, independent templates are distributed for different accounting units, and the service life of the templates is set after the templates are uploaded successfully. And aiming at each template, a user sends a rule editing request to the template management module, and configures rules according to the unit grids of the template, wherein the rules comprise parameters such as a data acquisition mode, subjects, data acquisition and the like. After the rules are edited, the template management module sends a request to the report data calculation module, and the report data calculation module starts multithreading according to the accounting unit and calculates the financial report data based on the existing basic voucher data and stores the financial report data in the database.
3) When an original certificate is notified, the certificate data processing module analyzes original certificate data according to the access rule and stores the original certificate data in a database in a storage form of a certificate head and a certificate row.
4) After the voucher data processing module finishes processing the original voucher data, the report data calculation module calls the report configuration module to acquire the configured information, searches for a calculation type report, acquires the basic voucher data, searches for the rule configured by the distributed template acquisition template according to the accounting unit in the voucher data to calculate the report data, and stores the calculation result in the database.
5) And the report display module returns report data to be displayed according to the filtering item, the requested report name and the requested parameter.
6) When the rule allocated by the template is changed, the user can send a data refreshing request to the report display module through the management platform, and the report display module calls the report data calculation module to recalculate the report data according to the newly edited rule.
Although the present invention has been described herein with reference to the illustrated embodiments thereof, which are intended to be preferred embodiments of the present invention, it is to be understood that the invention is not limited thereto, and that numerous other modifications and embodiments can be devised by those skilled in the art that will fall within the spirit and scope of the principles of this disclosure.
Claims (9)
1. An enterprise financial statement generating system based on original certificate data is characterized by comprising a statement configuration module, a template management module, a certificate data processing module, a statement data calculation module, a statement data display module and a database;
the report configuration module is used for providing new functions of different types of reports for users and adding required configuration items for the new reports;
the template management module is used for uploading and configuring a template for the calculation type report and editing rules required by the calculation of the report cells;
the voucher data processing module is used for analyzing original voucher data according to a voucher access rule and dividing the original voucher data into basic voucher data in the forms of a voucher head and a voucher line for storage when the original voucher data generated after automatic accounting or manual accounting is subjected to message notification;
the report data calculation module is used for taking the basic voucher data and calculating the report data by using the configuration items and the stored rules;
the report display module is used for receiving a user query request to acquire report data and displaying the report data;
the database is used for storing report basic information, configuration item information, template information, rule information, basic certificate data and calculated report data.
2. The system according to claim 1, wherein the configuration items of the new added report in the report configuration module include access rules and filtering items; the access rule comprises an access mode and an access logic item, wherein the access mode is used for judging whether the newly added report data needs to be obtained by calculation according to the rule, and is edited by the calculation type report rule; the filtering items comprise filtering conditions required by acquiring the report data of the calculation class and the detail class.
3. The system of claim 2, wherein the configuration items of the report configuration module further comprise report data presentation fields and presentation style information.
4. The enterprise financial statement generating system based on original voucher data as recited in claim 1 wherein the template management module has a template configuration function and a rule editing function; the template configuration function is used for uploading report templates for the calculation type reports, uploading a plurality of templates and distributing different templates for different accounting units; and the rule editing function is used for editing the uploaded template according to the rules of calculating the amount of the unit cell.
5. The system of claim 4 in which the template management module invokes the report configuration module to obtain the access terms and access logic terms for the report for the user to select when the user edits the rules.
6. The enterprise financial statement generating system based on original voucher data as recited in claim 4, wherein the template management module invokes the statement data calculation module to generate corresponding statement data after the rules are edited; after the rule is changed, the user can recalculate the report data through the page refreshing function.
7. The system of claim 1, wherein the report display module obtains the report data according to the filter term, the display field, and the display style.
8. The enterprise financial statement generating system based on the original voucher data as recited in claim 1, wherein the statement display module further comprises a data refreshing function.
9. The system according to claim 1, wherein when notified by the original credential data, the report data calculation module invokes the report configuration module to obtain the configuration item information and search for a calculation-based report, searches for the allocated template according to the accounting units in the original credential data to obtain the rules configured by the template to calculate the report data, and stores the calculation result in the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011372903.4A CN112348652A (en) | 2020-11-30 | 2020-11-30 | Enterprise financial statement generation system based on original certificate data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011372903.4A CN112348652A (en) | 2020-11-30 | 2020-11-30 | Enterprise financial statement generation system based on original certificate data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112348652A true CN112348652A (en) | 2021-02-09 |
Family
ID=74365189
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011372903.4A Pending CN112348652A (en) | 2020-11-30 | 2020-11-30 | Enterprise financial statement generation system based on original certificate data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112348652A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN106504079A (en) * | 2016-09-22 | 2017-03-15 | 江苏富山企业服务有限公司 | A kind of composite type financial management method and its management platform |
| CN107679026A (en) * | 2017-09-28 | 2018-02-09 | 东莞嘉泰钟表有限公司 | A kind of method of self-defined accounting statement |
-
2020
- 2020-11-30 CN CN202011372903.4A patent/CN112348652A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN106504079A (en) * | 2016-09-22 | 2017-03-15 | 江苏富山企业服务有限公司 | A kind of composite type financial management method and its management platform |
| CN107679026A (en) * | 2017-09-28 | 2018-02-09 | 东莞嘉泰钟表有限公司 | A kind of method of self-defined accounting statement |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6360188B1 (en) | Time-based modeling | |
| CN112395325A (en) | Data management method, system, terminal equipment and storage medium | |
| WO2019184123A1 (en) | Method for automatically generating financial document, device, computer apparatus, and storage medium | |
| CN102279848A (en) | Method and device for generating report template | |
| WO2015077216A1 (en) | Efficient data mapping requirements establishment and reference | |
| US20180018066A1 (en) | Data visualization configuration system and method | |
| US20200167738A1 (en) | Support for maintenance of a fleet of vehicles with intuitive display of repair analytics | |
| CN112016287A (en) | Data management method, platform, storage medium and electronic device | |
| CN113191127A (en) | Nuclear power management information-based user-defined form system and method | |
| CN111897866A (en) | Remote sensing monitoring pattern spot docking system and using method thereof | |
| CN109254901A (en) | A kind of Monitoring Indexes method and system | |
| CN112749846A (en) | Big data platform-based financial cloud picture construction analysis method for electric power system | |
| CN115329728A (en) | Working data low-acquisition high-multiplexing cooperative office report communication system and method | |
| CN111190814A (en) | Software test case generation method and device, storage medium and terminal | |
| US7912809B2 (en) | Data management system for manufacturing enterprise and related methods | |
| CN112348652A (en) | Enterprise financial statement generation system based on original certificate data | |
| CN116431611A (en) | Automatic data processing module development method based on custom rules | |
| CN115859935A (en) | Data analysis report template generation system and method based on index library | |
| CN116136880A (en) | Data display method and device, electronic equipment and storage medium | |
| CN112800128B (en) | Multifunctional and easy-to-use laboratory execution system | |
| RU2736851C1 (en) | Enterprise information system control method | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| CN114218226A (en) | Report information system | |
| CN117350266B (en) | Method and system for automatically generating document | |
| US20080082379A1 (en) | Technical performance measures management process and system |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210209 |