CN114971591A - Multi-level reporting and summarizing system and method for enterprise annual budget - Google Patents
Multi-level reporting and summarizing system and method for enterprise annual budget Download PDFInfo
- Publication number
- CN114971591A CN114971591A CN202210889487.8A CN202210889487A CN114971591A CN 114971591 A CN114971591 A CN 114971591A CN 202210889487 A CN202210889487 A CN 202210889487A CN 114971591 A CN114971591 A CN 114971591A
- Authority
- CN
- China
- Prior art keywords
- data
- budget
- information
- filling
- authority
- 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
- 238000000034 method Methods 0.000 title claims abstract description 94
- 230000008569 process Effects 0.000 claims abstract description 62
- 230000006870 function Effects 0.000 claims abstract description 28
- 230000008859 change Effects 0.000 claims abstract description 27
- 238000003860 storage Methods 0.000 claims abstract description 15
- 238000013500 data storage Methods 0.000 claims abstract description 10
- 238000012986 modification Methods 0.000 claims description 24
- 230000004048 modification Effects 0.000 claims description 24
- 238000012545 processing Methods 0.000 claims description 22
- 238000004364 calculation method Methods 0.000 claims description 19
- 238000012552 review Methods 0.000 claims description 17
- 239000003999 initiator Substances 0.000 claims description 10
- 238000013499 data model Methods 0.000 claims description 7
- 238000013461 design Methods 0.000 claims description 4
- 238000009825 accumulation Methods 0.000 claims description 3
- 238000012546 transfer Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 claims description 2
- 238000004458 analytical method Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 238000009877 rendering Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Technology Law (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a system and a method for multistage reporting and summarizing of enterprise annual budget, which comprises a configuration device, a front-end functional module and a storage device, wherein the configuration device comprises a budget form configuration device, a budget role authority configuration device and a budget process configuration device, the functional modules comprise a budget declaration functional module, a data self-definition functional module and a budget multistage auditing functional module, and the storage device comprises a budget data storage device, a budget data change recording device and a budget table data summarizing device. The method and the system can meet the function of carrying out multi-level reporting and summarizing on data among enterprises, can dynamically issue templates, fill in data, carry out intermediate approval and summarize the budget whole process, can record the intermediate process and the system whole data, and support the functions of data backtracking, change information comparison and the like.
Description
Technical Field
The invention relates to the technical field of data processing systems and methods, in particular to a system and a method for multistage reporting and summarizing of enterprise annual budget.
Background
With the current social development, more and more large-scale enterprises and units are provided with various branches and multi-level departments, and based on the existing organizational scheme, in annual budget work or project data summarization, data reporting to higher-level departments by lower-level departments often occurs, and generally, the reporting styles are various: mail, instant messaging instrument, enterprise office system etc. because the transfer format often is inconsistent, the not enough scheduling problem of data standardization, can lead to higher level department to carry out data collection and cause the error more easily, when higher level department step is more, lower department changes each time, all personnel that lead to uploading in the step all will carry out the data modification, often last statistics summarizer, the work load can be very big, file, the condition that data loss can appear in the storage data, data summarization information can't go back to, the change record does not have historical retention, make the personnel that summarize can not scientifically effectual carry out all-round analysis to budget data.
Disclosure of Invention
In order to overcome the defects, the invention aims to provide a system and a method for multistage reporting and summarizing of enterprise annual budgets, which can meet the requirement of completely customized budget filling templates among different enterprises, can perform multistage reporting and summarizing, realize a method and a system for integrating budget full processes of template issuing, data filling, intermediate approval and final summarizing, can record intermediate processes and system full data, and can support functions of data backtracking, change information comparison and the like.
The technical scheme adopted by the invention for solving the technical problems is as follows: a system for multistage reporting and summarizing of enterprise annual budgets comprises a configuration device, a front-end function module and a storage device, wherein the configuration device comprises a budget form configuration device, a budget role authority configuration device and a budget process configuration device, the function modules comprise a budget declaration function module, a data self-definition function module and a budget multistage auditing function module, and the storage device comprises a budget data storage device, a budget data change recording device and a budget table data summarizing device;
the budget form configuration device is used for a budget initiator to configure multi-level filling information according to actual needs, the budget role authority configuration device is used for configuring filling information which is associated with and can be checked by different levels of personnel, and the budget process configuration device is used for reporting branch flow directions of all levels and approval and data authority of the associated personnel;
the budget declaration functional module is used for displaying form information to be filled and performing budget information filing on a front-end page by a declaration person, the data custom configuration module is used for self-assembling part data modules according to certain requirements by related budget roles in the reporting process, and the budget multi-stage auditing functional module is used for processing different persons and different approval process trends of different levels of departments;
the budget data storage device is positioned in the database and used for storing original record information uploaded by each filling template file and filling personnel, the budget data change recording device is used for processing record modification change records of different personnel on the same filling form module in different time periods, and the budget table data summarization device is used for merging and progressively processing and summarizing data of each sub-information module in multiple levels and generating uniform data capable of being stored and displayed in multiple dimensions.
A method for multistage reporting and summarizing of enterprise annual budget comprises the following steps:
a budget sponsor configures a budget form, budget role authority and a budget process, the budget sponsor designs summarized data in a budget form configuration device through an online form editor, and an abstract data model which meets requirements, namely the budget form, is formulated;
dynamically distributing the budget information to the configured budget role authority configuration information according to the configured budget process, wherein the budget role comprises budget filling personnel, budget approval personnel, data review personnel and data summarization processing personnel, and the configuration information comprises data access authority, data filling authority, data modification authority and data summarization authority;
and each budget role carries out multilevel filling, auditing and summarizing procedures according to a budget process, each budget role in a program intermediate link checks corresponding data information according to the authority information of the current node, when the budget roles have data filling authority, data modification authority and data summarizing authority, the corresponding data filling, data modification and current node data summarizing need to be carried out, then the budget roles are transferred to a higher-level budget role for approval, finally the budget roles are transferred to a final summarizing person of a company, all data information of lower-level departments is verified and summarized, summarized data with different formats is formed, and the summarized data is stored and displayed on a foreground.
Preferably, the budget role authority, the budget form and the budget process are configured when the budget initiator initiates budget, and the budget form and the budget process are changed according to requirements in the auditing and summarizing processes.
Preferably, the budget form is various data tables, and is divided into a fill-in form, an intermediate processing form, and a final summary form, where the budget form may store actual budget data and budget information, and record views with different time and different actions need to be generated in a multi-level summary, and the record views include the intermediate processing form, version information modified by each record form, and version information of multiple summary results, and are recorded in the budget data change recording device, and according to a data table structural information definition of the budget form, a summary calculation rule among the data tables, and necessary association information, metadata of the data tables is formed, and the metadata includes data table structural information, data table summary calculation rule, and data table association information.
Preferably, the data table structured information is obtained by storing style information and data information in a fill-in form, a middle form and a summary form in an abstract data format, the data table structured information includes a plurality of different data blocks, a data block is data structure information which can be stored, modified and rendered in the table structured information, and the data block includes information mainly including: the data block type, the data block configuration information, the data block association information and the data block summarizing and calculating rule.
Preferably, the type of the data block may be divided into description data, normal data, fixed form data, and extensible form data, the type of the data block is divided into description data, normal data, fixed form data, and extensible form data, the normal data is to-be-filled data with variable parameters, the fixed form data is a form with a fixed header and a row and column number within certain limits, the data block configuration information of the fixed form data includes header configuration information, column and row split merge information, table data information, and summary area information, the header configuration information needs to list header information of the form, unique codes are set for different columns, when the header is a complex header, header format configuration needs to be recorded, the column split merge information is configuration information that needs to record cross data except for a single row and a single column in the form, the table data information is details of data actually filled in the form, according to the report requirement, a data summary row or a data summary column with accumulation or other calculation modes exists, the partial data is set as summary area information, the configuration information of the data block of the expandable table data further comprises header configuration information, row and column splitting and merging information, table data information, summary area information and configuration area information, and a data element in the table data information is a basic data unit and consists of a row identification code, a column identification code, display information, storage information and data calculation logic.
Preferably, the budget filling staff distributes according to different filling departments and has corresponding authority for filling information, the authority for filling information has data changing and reporting functions, the budget approving staff has approval authority in the data viewing authority, the approval authority and the summarizing authority of the programs of the data checking, the approval and the summarizing authority of the filling staff of the corresponding departments, the data rechecker and the data summarizing staff have data viewing and summarizing authority of the departments to be rechecked and summarized, and the budget data authority of the budget filling staff and the budget approving staff is fine to the data elements.
Preferably, the budget process configuration is provided with multiple approval modes, supports single approval and review, supports review, automatically circulates budget roles, combines the specific content of filled information, controls the process trend, has multiple node types in the budget process, comprises approval nodes, filling nodes and copying nodes, has a branch judgment rule function, enters a branch according to matching priority and data meeting formulated rules after the branch is created in the process, can configure node field authority control, has different field authorities for different process participants, and has different visible authorities for the field of a node principal.
Preferably, after the budget declaration function logs in the system in the corresponding budget role, user permission configuration information and a budget form are acquired, a budget form style to be filled is displayed on a login page, data filling is performed on line, when user-defined configuration information exists, a user-defined configuration module is loaded in filled data, and on the premise that data accuracy and reporting and summarizing are guaranteed, filling personnel perform row-column expansion on an existing data model according to actual needs, add tables or other additional information, and need to verify and complete addition of user-defined summary data and additional effective data.
Preferably, the data of the filling part is temporarily stored in the whole filling, auditing and summarizing program, real-time modification can be carried out, finally, when the data is perfect, the data is submitted and transferred to the budget approver of the next step, when the data is not approved by the budget approver of the next step, the data can be withdrawn, and when the data is rejected, the data can be modified again and submitted.
Preferably, the budget data storage device completes data query and incremental modification based on a combination of Mysql + Redis, and the budget data change recording device is configured to process record modification change records of the same budget filling form for different budget roles in different time periods, where the types of different types of data change are as follows: the common data are divided into initialization data, filling data, submitted data, modified data, summarized data and final data according to a flow sequence, the summarized data are divided into initial data, intermediate summarized data and final summarized data according to a time sequence, and the difference data comprise previous version data, current version data and difference data obtained through calculation according to the previous version data and the current version data.
Preferably, the difference data can be compared in a user-defined mode, historical data tracing is conducted, and the historical data tracing method includes the steps of selecting 2 time nodes, obtaining data element structures of data tables corresponding to the time nodes, extracting data organization, conducting comparison, and obtaining initial level department information during summarizing.
The invention has the following beneficial effects: the method and the system can meet the function of carrying out multi-level reporting and summarizing on data among enterprises, can dynamically issue templates, fill in data, carry out intermediate approval and summarize the budget whole process, can record the intermediate process and the system whole data, and support the functions of data backtracking, change information comparison and the like.
Drawings
FIG. 1 is a block diagram of the system architecture of the present invention.
FIG. 2 is a flowchart illustrating a multi-level approval process for budgeting according to an embodiment of the present invention.
Fig. 3 is a flowchart of intra-department reporting according to an embodiment of the present invention.
Fig. 4 is a flowchart of a multi-level summary report according to an embodiment of the present invention.
FIG. 5 is a final summary flow chart of an embodiment of the present invention.
Detailed Description
The present invention will now be described in further detail with reference to the accompanying drawings.
The system for multistage reporting and summarizing of enterprise annual budgets shown in fig. 1 comprises a configuration device, a front-end functional module and a storage device, wherein the configuration device comprises a budget form configuration device, a budget role authority configuration device and a budget process configuration device, the functional modules comprise a budget declaration functional module, a data self-definition functional module and a budget multistage auditing functional module, and the storage device comprises a budget data storage device, a budget data change recording device and a budget table data summarizing device;
the budget form configuration device is used for a budget initiator to configure multi-level filling information according to actual needs, the budget role authority configuration device is used for configuring filling information which is associated with and can be checked by different levels of personnel, and the budget process configuration device is used for reporting branch flow directions of all levels and approval and data authority of the associated personnel;
the budget declaration functional module is used for displaying form information to be filled and performing budget information filing on a front-end page by a declaration person, the data custom configuration module is used for self-assembling part data modules according to certain requirements by related budget roles in the reporting process, and the budget multi-stage auditing functional module is used for processing different persons and different approval process trends of different levels of departments;
the budget data storage device is positioned in the database and used for storing original record information uploaded by each filling template file and filling personnel, the budget data change recording device is used for processing record modification change records of different personnel on the same filling form module in different time periods, and the budget table data summarization device is used for merging and progressively processing and summarizing data of each sub-information module in multiple levels and generating uniform data capable of being stored and displayed in multiple dimensions.
A method for multistage reporting and summarizing of enterprise annual budget comprises the following steps:
a budget initiator configures a budget form, budget role authority and a budget process, the budget initiator designs summarized data in a budget form configuration device through an online form editor, and an abstract data model meeting requirements, namely the budget form, is formulated;
dynamically distributing the budget roles to configuration information of configured budget role permissions according to a configured budget process, wherein the budget roles comprise budget filling personnel, budget approval personnel, data review personnel and data summarization processing personnel, and the configuration information comprises data access permissions, data filling permissions, data modification permissions and data summarization permissions;
and each budget role carries out multilevel filling, auditing and summarizing procedures according to a budget process, each budget role in a program intermediate link checks corresponding data information according to the authority information of the current node, when the budget roles have data filling authority, data modification authority and data summarizing authority, the corresponding data filling, data modification and current node data summarizing need to be carried out, then the budget roles are transferred to a higher-level budget role for approval, finally the budget roles are transferred to a final summarizing person of a company, all data information of lower-level departments is verified and summarized, summarized data with different formats is formed, and the summarized data is stored and displayed on a foreground.
Preferably, the budget role authority, the budget form and the budget process are configured when the budget initiator initiates budget, and the budget form and the budget process are changed according to requirements in the auditing and summarizing processes.
Preferably, the budget form includes a fill-in form, an intermediate processing form, and a final summary form, where the budget form may store actual budget data and budget information, record views with different actions and different times need to be generated in a multi-level summary, and the record views include the intermediate processing form, version information modified by each record form, and version information of multiple summary results to ensure actual demands of different personnel on data, and the final summary form is the most effective data record required by an enterprise, and a general budget form is a summary form including a plurality of different EXCEL forms, and is organized into a summary form through summary statistics, and any data form needs to be abstracted into unique data form metadata, and recorded in the budget data change recording device, and the online form editor performs data design, analysis of data form structural information definition of each form, and a final summary form, And summarizing calculation rules and necessary association information among the data tables to form metadata of the data tables, wherein the metadata comprises data table structural information, data table summarizing calculation rules and data table association information.
Preferably, the data table structured information stores style information and data information in the fill-in form, the intermediate form and the summary form in an abstract data format, so as to facilitate storage of the corresponding data format and presentation of front-end page styles, the data table structured information includes a plurality of different data blocks, a data block is data structure information which can be stored, modified and rendered in the table structured information, and the data block includes information mainly: data block type, data block configuration information, data block association information, data block summarizing calculation rules and the like;
the data block type can be divided into description data, common data, fixed table data and expandable table data, the description data can be plain text and accessory description information commonly, the common data is mainly data to be filled with variable parameters, the fixed table data is a table with a fixed table head and a fixed table column number within certain limits, the expandable table data can be added with the number of the table columns or can adjust other table styles according to user definition, the data block configuration information is mainly determined by the data block type, the display and information storage modes of different types of data blocks are different, the data block association information and the data block summarization calculation rule provide a basis for data fusion of different data blocks in the same or different data table metadata;
the data block configuration information of the fixed table data should be as follows: header configuration information, row and column split merging information, table data information and summary area information, wherein the header configuration information needs to list header information of a table, unique codes are set for different columns, header format configuration needs to be recorded when the header is a complex header, the row and column split merging information needs to record configuration information of cross data except for a single row and a single column in the table, summary matching and front-end data rendering are facilitated, the table data information is data details of the table which is actually filled, a data summary row or a data summary column with an accumulation or other calculation mode exists according to report requirements, and the part of data is set as summary area information;
the configuration information of the data block of the extensible table data should be as follows: header configuration information, row and column split merge information, table data information, summary area information, and configuration area information;
the data elements in the table data information are basic data units and are composed of row identification codes, column identification codes, display information, storage information, data calculation logic and the like.
Preferably, the information of budget form configuration is stored in a database, a front-end function module is used in an online editor, the front-end function module is mainly developed based on Element UI + Vue, the Element is a set of desktop component library prepared for developers, designers and product managers and based on vue2.0, vue.js is a set of progressive JavaScript frame for constructing user interface, and different from other large frames, Vue is designed to be applied layer by layer from bottom to top, and supports online report editing based on the above technology, and a visual Web builder provides a custom area and custom style extension, can simply and conveniently define own form, supports various HTML (hypertext markup language) Element components, and mainly comprises text boxes, multi-line texts, pull-down menus, single selection boxes, check boxes, and other configurable forms, complex headers, a plurality of forms, a plurality of elements, and a display screen, And information such as logic calculation and the like, enterprise personnel can directly configure related data of the summary data table on a webpage.
Preferably, the budget Role authority configuration device is based on the authority Access Control designed by RBAC (Role-based Access Control), and is used for configuring data Access authorities of different persons and data authority filling, the authority is associated with the roles, and the user obtains the authority of the roles by becoming members of proper roles, so that the management of the authority is greatly simplified, the budget roles are mainly divided into budget filling personnel, budget approval personnel, data review personnel, data summarization processing personnel and the like, the budget filling personnel are distributed according to different filling departments, have the corresponding authority of filling information, and can perform functions of data change, reporting and the like, the budget approval personnel have the data viewing authority filled by the filling personnel of the corresponding departments and the approval authority in the reporting process, and the data review personnel and the data summarization personnel have the data viewing authority of the departments to be reviewed and summarized, And summarizing the authority, wherein the budget data authority of the budget filling personnel and the budget approving personnel is refined to data elements, the data elements are filled in by a complete Web page end, and the historical modification and version difference information of each node is completely recorded in the process of matching with the controllable approval process of the multi-level budget approving personnel, so that the summarized report data in a standardized format is generated.
Preferably, the budget process configuration device is used for reporting the branch flow directions of each level and the approval and data authority of related personnel, is provided with a plurality of approval modes, supports single approval and review, can automatically transfer personnel, has flexible and various process configurations, and the trend of the process can be controlled according to the requirements of different personnel and different departments by combining the specific content of the filling information, the budget process has a plurality of node types including examination and approval nodes, filling nodes, copying nodes and the like, selecting corresponding types according to the nodes, meeting the task requirements of different stages, having the function of branch judgment rules, after a branch is created in the process, the branch can be entered according to the matching priority and the data which meets the established rule, the field authority control of the nodes can be configured, different process participants have different field authorities, and the node responsible persons have different visible authorities to the fields.
Preferably, the budget declaration functional module logs in a system in a corresponding budget role, acquires information such as user authority configuration and an abstract data model to perform data rendering, displays a data sheet style to be filled in on a Web page, can perform data filling online, loads the custom configuration module in the filled data when custom configuration information exists, and can perform row-column expansion on the existing data model, add tables or other additional information and check and complete addition of custom summarized data and additional effective data according to actual needs by a filling person on the premise of ensuring data accuracy and reporting and summarizing.
Preferably, part of data can be filled in the whole filling, auditing and summarizing program for temporary storage or real-time modification, and finally when the data is complete, the data can be submitted and transferred to the budget approver in the next step, and when the data is not approved by the budget approver in the next step, the data can be withdrawn and can be revised and submitted again after being rejected.
Preferably, the budget data storage device is located in the database, and is configured to store original record information uploaded by each form filling template file and form filling staff, complete data query and add, delete and modify based on a combination of Mysql + Redis, and ensure efficient data query and system performance, and the budget data change recording device is configured to process record modification change records of different budget roles for the same form filling module in different time periods, where change types of different types of data are as follows: the general data are divided into initialization data, filling data, submitted data, modified data, summarized data and final data according to a flow sequence, the summarized data are divided into initial data, intermediate summarized data and final summarized data according to a time sequence, the differential data comprise previous version data, current version data and differential data obtained by calculation according to the previous version data and the current version data, the differential data can be subjected to custom comparison and historical data tracing, the historical data tracing method comprises the steps of selecting 2 time nodes, obtaining a data element structure of a data table corresponding to the time nodes, extracting data organization for comparison, and obtaining initial-level department information during summarizing, wherein the process comprises the following steps: the system provides a powerful summarization function, can quickly extract related data from mass data and analyze the data from multiple angles according to needs, thereby mining the deep value of the data, enabling complex reports which are difficult to realize in the past to be easy to realize, avoiding mass programming and early-stage data preparation, realizing the realization of low-code business logic, and easily manufacturing the summarization information required by enterprises through the application of function calculation and hierarchical information search.
Specific embodiment, as shown in one embodiment flow diagram of fig. 2, fig. 3, fig. 4 and fig. 5,
step 1, budget sponsor configuration information, namely, budget forms, budget role authorities and budget processes of a plurality of departments are configured, such as departments 1 to n shown in fig. 2, and then filling in each department respectively;
step 2, intra-department filling, wherein if a budget filling person in a department 1 fills a corresponding data table 1 to a data table n respectively, the budget filling person is submitted to a budget approver in the department for approval after filling, if the budget approver needs to be modified after approval, the budget filling person returns to the budget filling person for modification, the budget filling person is submitted to the approver in the budget of the department again after modification for approval, if the budget approving person does not need to be modified, the budget filling person completes approval, and the budget filling person submits to a multi-level summary report position for summary report, wherein a plurality of data tables in each department are reported to a corresponding multi-level summary report position for summary;
step 3, the multi-level summary reporting positions are subjected to summary reporting, budget filling personnel at the multi-level summary reporting positions are filled, then the budget filling personnel are reported to a second-level summary reporting position, the budget filling personnel are sent to the n-level summary reporting positions after intermediate steps, after corresponding budget approvers are approved, if the budget approvers are rejected, the budget filling personnel returned to the multi-level summary reporting positions are filled again, then the budget filling personnel are submitted step by step, until the budget approvers at the last-level summary reporting positions are approved, a summary intermediate table capable of being summarized is formed, and the summary table is submitted to a final summary position for summary statistics;
and 4, submitting the intermediate summary table to a final summary position, submitting the intermediate summary table to a data review personnel for review, if the review is unqualified, returning the designated data to a specific node for modification, submitting final summary examination and approval after the review is successful, if the review is passed, ending to form a final summary table, if the review needs data modification, returning to the summary statistical position of the level for filling the data again, and going through the review process of the level until the review is qualified to form the final summary table.
The present invention is not limited to the above embodiments, and any structural changes made under the teaching of the present invention shall fall within the protection scope of the present invention, which is similar or similar to the technical solutions of the present invention.
The techniques, shapes, and configurations not described in detail in the present invention are all known techniques.
Claims (10)
1. A multi-level reporting and summarizing method for enterprise annual budget is characterized in that: the method comprises the following steps:
a budget initiator configures a budget form, budget role authority and a budget process, the budget initiator designs summarized data in a budget form configuration device through an online form editor, and an abstract data model meeting requirements, namely the budget form, is formulated;
dynamically distributing the budget roles to configuration information of configured budget role permissions according to a configured budget process, wherein the budget roles comprise budget filling personnel, budget approval personnel, data review personnel and data summarization processing personnel, and the configuration information comprises data access permissions, data filling permissions, data modification permissions and data summarization permissions;
and each budget role carries out multilevel filling, auditing and summarizing procedures according to a budget process, each budget role in a program intermediate link checks corresponding data information according to the authority information of the current node, when the budget roles have data filling authority, data modification authority and data summarizing authority, the corresponding data filling, data modification and current node data summarizing need to be carried out, then the budget roles are transferred to a higher-level budget role for approval, finally the budget roles are transferred to a final summarizing person of a company, all data information of lower-level departments is verified and summarized, summarized data with different formats is formed, and the summarized data is stored and displayed on a foreground.
2. The method according to claim 1, wherein the method comprises: the budget role authority, the budget form and the budget process are configured when a budget initiator initiates budget, and the budget form and the budget process are changed according to requirements in the auditing and summarizing processes.
3. The method according to claim 1, wherein the method comprises: the budget form is various data tables and is divided into a filling form, an intermediate processing form and a final summary form, wherein the budget form can store actual budget data and budget information, record views with different moments and different actions need to be generated in multi-level summary, the record views comprise the intermediate processing form, version information modified by each record form and version information of multiple summary results, the intermediate processing form, the version information modified by each record form and the version information of multiple summary results are recorded in a budget data change recording device, metadata of the data tables are formed according to data table structural information definitions of the budget form, summary calculation rules among the data tables and necessary associated information, and the metadata comprises data table structural information, data table summary calculation rules and data table associated information.
4. The method according to claim 3, wherein the method comprises: the data table structured information is obtained by storing style information and data information in a filling form, a middle form and a summary form in an abstract data format, the data table structured information comprises a plurality of different data blocks, the data blocks are data structure information which can be stored, modified and rendered in the table structured information, and the data blocks mainly comprise the following information: the data block type, the data block configuration information, the data block association information and the data block summarizing and calculating rule.
5. The method according to claim 4, wherein the method comprises: the data block type can be divided into description data, common data, fixed form data and expandable form data, the data block type is divided into description data, common data, fixed form data and expandable form data, the common data is data to be filled with variable parameters, the fixed form data is a form with a fixed header and rows and columns within certain limits, the data block configuration information of the fixed form data comprises header configuration information, row and column split combination information, table data information and summary area information, the header configuration information needs to list header information of the form, unique codes are set for different columns, when the data block configuration information is a complex header, header format configuration needs to be recorded, the row and column split combination information needs to record configuration information of cross data except for one row and one column in the form, and the table data information is data details of an actually filled form, according to the report requirement, a data summary row or a data summary column with accumulation or other calculation modes exists, the part of data is set as summary area information, the configuration information of the data block of the expandable table data further comprises header configuration information, row and column split merge information, table data information, summary area information and configuration area information, and data elements in the table data information are basic data units and are composed of row identification codes, column identification codes, display information, storage information and data calculation logic.
6. The method according to claim 1, wherein the method comprises: the budget filling personnel are distributed according to different filling departments and have corresponding filling information authority, the filling information authority has data changing and reporting functions, the budget approving personnel has approval authority in data viewing authority, auditing authority and summarizing program of filling personnel of corresponding departments, the data rechecker and the data summarizing personnel have data viewing and summarizing authority of departments to be rechecked and summarized, and the budget data authority of the budget filling personnel and the budget approving personnel is fine to data elements.
7. The method according to claim 1, wherein the method comprises: the budget process is configured with various approval modes, supports single approval and review, automatically transfers budget roles, combines the specific content of filled information, controls the trend of the process, has various node types in the budget process, comprises approval nodes, filling nodes and copying nodes, has the function of branch judgment rules, enters a branch according to matching priority and data conforming to formulated rules after the branch is created in the process, can be configured with node field authority control, has different field authorities for different process participants, and has different visible authorities for the field by a node principal.
8. A system according to any one of claims 1 to 7, wherein the system comprises: the budget management system comprises a configuration device, a front-end function module and a storage device, wherein the configuration device comprises a budget form configuration device, a budget role authority configuration device and a budget process configuration device, the function modules comprise a budget declaration function module, a data self-definition function module and a budget multi-level auditing function module, and the storage device comprises a budget data storage device, a budget data change recording device and a budget table data summarizing device;
the budget form configuration device is used for a budget initiator to configure multi-level filling information according to actual needs, the budget role authority configuration device is used for configuring filling information which is associated with and can be checked by different levels of personnel, and the budget process configuration device is used for reporting branch flow directions of all levels and approval and data authority of the associated personnel;
the budget reporting function module is used for displaying form information to be filled and reporting budget information of a reporting person on a front-end page, the data custom configuration module is used for self-assembling partial data modules according to certain requirements by related budget roles in the reporting process, and the budget multi-level auditing function module is used for processing different personnel and different approval process trends of different levels of departments;
the budget data storage device is positioned in the database and used for storing original record information uploaded by each filling template file and filling personnel, the budget data change recording device is used for processing record modification change records of different personnel on the same filling form module in different time periods, and the budget table data summarization device is used for merging and progressively processing and summarizing data of each sub-information module in multiple levels and generating uniform data capable of being stored and displayed in multiple dimensions.
9. The system according to claim 8, wherein the system comprises: the budget declaration functional module acquires user authority configuration information and a budget form after a corresponding budget role logs in a system, a budget form style needing to be filled is displayed on a login page, data filling is carried out on line, when user-defined configuration information exists, the user-defined configuration module is loaded in filled data, on the premise that data accuracy and reporting and summarizing are guaranteed, filling personnel expand the existing data model in rows and columns according to actual needs, add tables or other additional information, and need to check and complete adding of user-defined summarized data and additional effective data.
10. The system according to claim 8, wherein the system comprises: the budget data storage device completes data query and increasing, deleting and modifying based on the combination of Mysql and Redis, the budget data change recording device is used for processing the record modification change records of the same budget filling form in different time periods by different budget roles, and the types of the different types of data change are as follows: the common data are divided into initialization data, filling data, submitted data, modified data, summarized data and final data according to a flow sequence, the summarized data are divided into initial data, intermediate summarized data and final summarized data according to a time sequence, and the difference data comprise previous version data, current version data and difference data obtained through calculation according to the previous version data and the current version data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210889487.8A CN114971591A (en) | 2022-07-27 | 2022-07-27 | Multi-level reporting and summarizing system and method for enterprise annual budget |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210889487.8A CN114971591A (en) | 2022-07-27 | 2022-07-27 | Multi-level reporting and summarizing system and method for enterprise annual budget |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114971591A true CN114971591A (en) | 2022-08-30 |
Family
ID=82968597
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210889487.8A Pending CN114971591A (en) | 2022-07-27 | 2022-07-27 | Multi-level reporting and summarizing system and method for enterprise annual budget |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114971591A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115169302A (en) * | 2022-09-08 | 2022-10-11 | 天津联想协同科技有限公司 | Data collection method and device based on online form document and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111815168A (en) * | 2020-07-09 | 2020-10-23 | 北京中百信信息技术股份有限公司 | Information system engineering supervision project quality management system |
| CN113256243A (en) * | 2021-04-30 | 2021-08-13 | 厦门国际银行股份有限公司 | Project budget full life cycle management device and method |
| CN113487279A (en) * | 2021-07-02 | 2021-10-08 | ***机关及驻外机构服务中心(***机关及驻外机构服务局) | Financial centralized management system for financial fusion |
-
2022
- 2022-07-27 CN CN202210889487.8A patent/CN114971591A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111815168A (en) * | 2020-07-09 | 2020-10-23 | 北京中百信信息技术股份有限公司 | Information system engineering supervision project quality management system |
| CN113256243A (en) * | 2021-04-30 | 2021-08-13 | 厦门国际银行股份有限公司 | Project budget full life cycle management device and method |
| CN113487279A (en) * | 2021-07-02 | 2021-10-08 | ***机关及驻外机构服务中心(***机关及驻外机构服务局) | Financial centralized management system for financial fusion |
Non-Patent Citations (1)
| Title |
|---|
| 赵小雨: "构建基于 NC57 ***的资金预算", 《办公自动化》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115169302A (en) * | 2022-09-08 | 2022-10-11 | 天津联想协同科技有限公司 | Data collection method and device based on online form document and storage medium |
| CN115169302B (en) * | 2022-09-08 | 2022-12-09 | 天津联想协同科技有限公司 | Data collection method and device based on online form document and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10324609B2 (en) | System for providing dynamic linked panels in user interface | |
| US6647390B2 (en) | System and methods for standardizing data for design review comparisons | |
| Bartram et al. | Untidy data: The unreasonable effectiveness of tables | |
| US20110016448A1 (en) | System and method for rapid development of software applications | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| Blanning | The functions of a decision support system | |
| Khan et al. | Data tweening: incremental visualization of data transforms | |
| JPH06208592A (en) | Automatic layout generator for data base system use interface and its generating method | |
| US20110225484A1 (en) | Cloud based modeling for enhancing spreadsheets | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN108363776A (en) | A kind of self-defined display methods of table field | |
| CN114971591A (en) | Multi-level reporting and summarizing system and method for enterprise annual budget | |
| US11636162B2 (en) | Multi-database document search system architecture | |
| CN109614143B (en) | Development method for automatically generating fault flow chart in IETM browser | |
| Wu | The application and management system of scientific research projects based on PHP and MySQL | |
| CN1973285A (en) | Document processing method and device | |
| CN114722789B (en) | Data report integrating method, device, electronic equipment and storage medium | |
| Hodel et al. | Dynamic collaborative business processes within documents | |
| Oyetoke | Leveraging information technology in automating school management and student activities by successfully integrating a java-based school management application software | |
| Bârjovanu et al. | Usage of Data Bases of Microsoft Office in the Perspective of National Economies for the Effect of Globalization. | |
| Santoso | Academic Decision Support System for Top Management | |
| JP7316060B2 (en) | Application screen display program implementation method | |
| Egger et al. | SAP Business Intelligence | |
| Vaidya et al. | Business intelligence system for banking and finance | |
| US8244763B1 (en) | Wiki-facilitated enterprise architecture repository |
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 |
Application publication date: 20220830 |
|
| RJ01 | Rejection of invention patent application after publication |