CN112685471A - Accounting and analyzing method for financial data based on non-tree detail classification label system - Google Patents
Accounting and analyzing method for financial data based on non-tree detail classification label system Download PDFInfo
- Publication number
- CN112685471A CN112685471A CN202011581134.9A CN202011581134A CN112685471A CN 112685471 A CN112685471 A CN 112685471A CN 202011581134 A CN202011581134 A CN 202011581134A CN 112685471 A CN112685471 A CN 112685471A
- Authority
- CN
- China
- Prior art keywords
- data
- financial
- analysis
- accounting
- business
- 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 35
- 238000004458 analytical method Methods 0.000 claims abstract description 46
- 238000007405 data analysis Methods 0.000 claims abstract description 16
- 238000005516 engineering process Methods 0.000 claims abstract description 7
- 230000001172 regenerating effect Effects 0.000 claims abstract description 6
- 238000004141 dimensional analysis Methods 0.000 claims abstract description 5
- 230000008859 change Effects 0.000 claims description 9
- 238000007796 conventional method Methods 0.000 claims description 7
- 238000004519 manufacturing process Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 239000000047 product Substances 0.000 description 2
- 238000012827 research and development Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000006227 byproduct Substances 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a financial accounting and data analysis method based on a non-tree detail classification label system, relates to the technical field of financial accounting and analysis, is applied to the analysis of the existing financial system, and comprises the following steps: extracting relevant data from financial software to generate a new database; redefining a subject or an analysis tag system; regenerating analysis data according to the defined label system rule; based on the detailed subject labels, a graphQL technology is adopted to provide a financial analysis tool for managing accounting to perform real-time multi-dimensional analysis of financial and business data, and a new financial and business information table is generated to perform financial and business analysis. According to the invention, after the related data are extracted to the new database, the unnecessary and worthless data are removed, and a set of new financial or business information data based on the non-tree detail classification label is generated, so that the evolvable capacity of an accounting information system and a business management information system is improved, and the utilization value of the financial data is improved.
Description
Technical Field
The invention relates to the technical field of financial accounting and analysis, in particular to a financial data accounting and analysis method based on a non-tree detail classification label system.
Background
In order to meet the requirements of more refined accounting and management, in the work of making accounting documents and registering accounts, the commonly used method at present is to further classify classified subjects and provide more detailed and more specific accounting information subjects, namely, to set up detailed classified subject tables. Because the accounting title table must be a strict tree structure, the conventional method inevitably imposes a hierarchical structure on different service attribute categories which do not have a hierarchical logical relationship originally, and finally, the defects of limited financial analysis view angle, rigid operation management structure and the like are inevitably brought.
Such as: the service charge, as occurred by the management department, is recorded as "management charge-service charge"; the production department records the production cost, the business admission fee, the labor cost and the business admission fee; the sales department records the sales cost-service hospitalization cost, and cannot carry out deep analysis according to the service properties on the whole service entity level;
for another example, in the sales income subsidiary book, there is no hierarchical logic relationship in the original business attribute categories such as sales channels, product types, sales regions, etc., however, according to the conventional detail classification subject table method, the hierarchical relationship is forced to the business attributes, corresponding to the business attributes, when analyzing business data through the accounting book, the unnecessary hierarchical relationship brings huge technical burden to the data statistical analysis; particularly, as business develops, detailed subjects change quite frequently, so that when the business change trend is analyzed, either additional logic complexity is added or the real-time performance of statistical data is affected (both are usually achieved), and the defects are obvious. In addition, in the process of adapting to the development of the society and the market, the enterprise (or non-enterprise organization) needs to frequently adjust the operation management organization mode, for example, when the enterprise upgrades from the traditional production sales type to the modern research and development service type, the sales sub-companies divided by regions are cancelled and adjusted to the research and development, production, sales and service product line cause cluster organized by product lines, and if the account recording method is classified according to the conventional details, the accounting information system and the business management information system can hardly adapt to the change.
Meanwhile, in traditional financial software such as friends and golden butterfly, due to system architecture, after accounting action is executed, a tree-structured subject balance list can be generated for data analysis, data cannot respond in real time, so that data analysis results are delayed seriously, and development of financial service business is not facilitated.
Disclosure of Invention
In order to solve the problems in the prior art, the invention generates a set of new financial or business information data based on a non-tree detail classification label by extracting related data to a new database based on traditional accounting or business information data, eliminating detail classification subject hierarchy logical relations which are unnecessary and worthless, even distorting the original characteristics of business information, thereby improving the evolvable capability of an accounting information system and a business management information system, improving the utilization value of the financial data (especially under the conditions of spanning a longer period and frequent business change) and supporting enterprises (and non-enterprise organizations) to adapt to the high-speed development of society and market.
In order to achieve the above effects, the invention specifically adopts the following technical scheme:
a financial data accounting and analyzing method based on a non-tree detail classification label system comprises the following steps:
s1: extracting relevant data from financial software to generate a new redundant database;
s2: redefining a subject or an analysis tag system;
s3: regenerating analysis data according to the defined label system rule;
s4: based on the detailed subject label, a financial analysis tool in the aspect of managing accounting is provided by adopting the GraphQL technology to perform multi-dimensional analysis on real-time business data and generate a new financial and business information table (such as a new voucher table);
s5: and performing real-time financial and business analysis by using the newly generated financial and business information table.
Further, the related data in S1 includes one or more of accounting title table, voucher table, department, personnel, project data, and the related data is not processed again.
Further, the step S2 is that the principle of redefining the subject or analyzing the label system includes setting a general classification subject table according to the corresponding accounting criteria for the relatively stable general subjects and sub-subjects belonging to the high-level abstract information hierarchy in the business information, and generating a general classification account according to the corresponding accounting criteria, that is, the conventional method is still adopted in the aspect of financial accounting;
the principle of redefining the subject or analyzing the label system described in S2 further includes setting a subject label library according to the original logical relationship of the service attribute categories for the subject attributes frequently changed and belonging to the specific service information hierarchy, so as to replace the detailed subject classification table in the conventional method, thereby meeting the requirements of more detail and flexibility in managing accounting.
Further, the step of regenerating the multidimensional analysis data set according to the defined label system rule in S3 is to detect whether the extracted data changes, if so, to perform calculation and update on the changed data and the newly added data before performing analysis and call each time; and if the change does not occur, adopting an incremental updating mode.
Further, according to the analysis data regenerated according to the redefined label system rule described in S3 (if the analysis data is applied to a new financial or business system, the relevant label system rule is directly embodied in the work of making accounting documents), the business attribute is automatically identified and the corresponding detailed item label is matched according to the business scenario through the informatization technology, the account book is automatically registered, and the general ledger is automatically updated.
The financial and business multidimensional dataset based on the non-tree detail classification label system generated in the step S4 is a single analysis dataset, and is continuously updated along with changes of the source data (real-time updating when analysis is invoked).
Further, according to the financial service data set updated in real time in S5, the real-time financial service information recorded based on each system can be realized, and the related data analysis can be performed without similar operations such as accounting and checkout, which greatly enhances the real-time performance of data analysis.
The further proposal is that the analysis method can realize the report merging operation of a plurality of business entities (companies), integrate the business financial data of different entities into a database and carry out secondary multidimensional analysis.
The method comprises the following steps of combining reports, wherein the report operation comprises the steps of pulling and generating financial data of each unit, adding unit name code fields in a data table, storing a database table in addition, inputting, combining and offsetting entry data, and storing the data as an offsetting entry data table in addition; combining the two data table data to generate combined report data:
and then performing data analysis based on the combined report.
The invention has the beneficial effects that:
the financial data analysis method provided by the invention is based on the traditional financial data or the bookkeeping method, and eliminates the meaningless and worthless detail subject hierarchy logic relationship, so that more detailed and more specific business information can be freely merged into an accounting information system, namely, the accounting information system can use detailed and real-time business data.
Interference of meaningless hierarchical logical relations is eliminated, so that financial analysis can be observed from more dimensions more conveniently.
After the financial data analysis method provided by the invention is adopted, the accounting information system and the business information system can be completely fused in a more natural mode, and the corresponding speed of the information system adapting to frequent change is improved.
Drawings
Fig. 1 is a flowchart of a financial data accounting and analyzing method based on a non-tree detail classification label system according to an embodiment of the present invention.
Detailed Description
The technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention.
As shown in fig. 1, an embodiment of the present invention discloses a method for accounting and analyzing financial data based on a non-tree detail classification label system, which comprises the following steps:
s1: extracting relevant data from financial software to generate a new redundant database;
s2: redefining subjects or analyzing tag systems (or directly defining the subjects and the tag systems by the newly customized financial software by adopting the method);
s3: regenerating analysis data according to the defined label system rule;
s4: based on the detailed subject label, a financial analysis tool in the aspect of managing accounting is provided by adopting the GraphQL technology to perform multi-dimensional analysis on real-time business data and generate a new financial and business information table (such as a new voucher table);
s5: and performing real-time financial and business analysis by using the newly generated financial and business information table.
In this embodiment, the related data in S1 includes one or more of accounting title table, voucher table, department, personnel and project data, and the related data is not processed again.
In this embodiment, the principle of redefining the subject or analyzing the label system in S2 includes setting a general classification subject table according to the corresponding accounting criteria for the relatively stable general subjects and sub-subjects belonging to the high-level abstract information hierarchy in the business information, and generating a general classification account according to the corresponding accounting criteria, that is, the conventional method is still adopted in the aspect of financial accounting;
the principle of redefining the subject or analyzing the label system of S2 further includes setting a subject label library according to the original logical relationship of the service attribute categories for the subject attributes frequently changed and belonging to the specific service information hierarchy, so as to replace the detailed subject classification table in the conventional method, thereby adapting to the more detailed and flexible requirements in managing accounting. If the method is adopted to develop financial software, the accounting subject system and the analysis tag system can be directly and synchronously defined.
In this embodiment, in S3, the multidimensional analysis data set according to the defined label system rule is regenerated, and for each time before analysis call is performed, whether the extracted data changes, if so, the extracted data is calculated and updated for all the changed data and the newly added data; and if the change does not occur, adopting an incremental updating mode.
In this embodiment, the general ledger is automatically updated by automatically identifying the business attributes and matching the corresponding detailed item labels according to the business scenario through the informatization technology according to the analysis data regenerated in S3 according to the redefined label system rule (if the analysis data is applied to a new financial or business system, the relevant label system rule is directly embodied in the work of making accounting documents).
The financial and business multidimensional dataset based on the non-tree detail classification label system generated in the step S4 is a single analysis dataset, and is continuously updated along with changes of the source data (real-time updating when analysis is invoked).
In this embodiment, according to the financial transaction data set updated in S5 in real time, the real-time financial transaction information that has been recorded based on each system can be realized, and the related data analysis can be performed without similar operations such as accounting and checkout, which greatly enhances the real-time performance of data analysis.
In this embodiment, the analysis method can realize the report merging operation of multiple business entities (companies), integrate the business financial data of different entities into one database, and perform secondary multidimensional analysis.
In this embodiment, the report merging operation step is to pull and generate financial data of each unit, add a unit name code field in a data table, store a database table in addition, enter and merge and offset entry data, and store the offset entry data table in addition; combining the two data table data to generate combined report data:
and then performing data analysis based on the combined report.
The financial data analysis method provided by the invention is based on the traditional financial data or the accounting method, and eliminates the meaningless and worthless detailed subject hierarchy logical relationship, so that more detailed and more specific business information can be freely merged into an accounting information system, namely, the accounting information system can use detailed and real-time business data.
Interference of meaningless hierarchical logical relations is eliminated, so that financial analysis can be observed from more dimensions more conveniently.
After the financial data analysis method provided by the invention is adopted, the accounting information system and the business information system can be completely fused in a more natural mode, and the corresponding speed of the information system adapting to frequent change is improved.
Finally, only specific embodiments of the present invention have been described in detail above. The invention is not limited to the specific embodiments described above. Equivalent modifications and substitutions by those skilled in the art are also within the scope of the present invention. Accordingly, equivalent alterations and modifications are intended to be included within the scope of the invention, without departing from the spirit and scope of the invention.
Claims (8)
1. A financial data accounting and analyzing method based on a non-tree detail classification label system is characterized in that: the method comprises the following steps:
s1: extracting relevant data from financial software to generate a new redundant database;
s2: redefining a subject or an analysis tag system;
s3: regenerating analysis data according to the defined label system rule;
s4: based on the detailed subject label, a financial analysis tool in the aspect of managing accounting is provided by adopting the GraphQL technology to perform multi-dimensional analysis on real-time business data and generate a new financial and business information table (such as a new voucher table);
s5: and performing real-time financial and business analysis by using the newly generated financial and business information table.
2. The method of claim 1, wherein the method comprises the steps of:
the related data in S1 includes one or more of accounting title table, voucher table, department, personnel, project data, and the related data is not processed for the second time.
3. The method of claim 1, wherein the method comprises the steps of:
the principle of redefining the subject or analyzing the label system described in S2 includes setting a general classification subject table according to the corresponding accounting criteria for the general subjects and sub-subjects which are relatively stable and belong to the high-level abstract information hierarchy in the business information, and generating a general classification account according to the corresponding accounting criteria, that is, the conventional method is still adopted in the aspect of financial accounting;
the principle of redefining the subject or analyzing the label system described in S2 further includes setting a subject label library according to the original logical relationship of the service attribute categories for the subject attributes frequently changed and belonging to the specific service information hierarchy, so as to replace the detailed subject classification table in the conventional method, thereby meeting the requirements of more detail and flexibility in managing accounting.
4. The method of claim 1, wherein the method comprises the steps of:
regenerating a multidimensional analysis data set according to a defined label system rule in S3, detecting whether the extracted data changes or not before analysis and calling each time, if so, calculating and updating the changed data and newly added data; and if the change does not occur, adopting an incremental updating mode.
5. The method of claim 1, wherein the method comprises the steps of:
and according to the analysis data regenerated in the step S3 and according to the redefined label system rule, automatically identifying the service attribute according to the service scene and matching the corresponding detailed account label through an information technology, automatically registering the account book and automatically updating the general ledger.
The financial and business multidimensional dataset based on the non-tree detail classification label system generated in the step S4 is a single analysis dataset, and is continuously updated along with changes of the source data (real-time updating when analysis is invoked).
6. The method of claim 1, wherein the method comprises the steps of:
according to the financial service data set updated in real time in the step S5, the real-time financial service information recorded based on each system can be realized, the related data analysis can be carried out without similar operations such as accounting and checkout, and the real-time performance of the data analysis is greatly enhanced.
7. A method according to any one of claims 1 to 6, wherein the method comprises the steps of:
the analysis method can realize the report form merging operation of a plurality of business entities (companies), integrates the business financial data of different entities into one database, and performs secondary multi-dimensional analysis.
8. The method of claim 7, wherein the method comprises the steps of:
the report form merging operation step is to pull and generate financial data of each unit, add unit name code fields in a data table, store a database table in addition, record and merge and offset entry data, and store the entry offset data table in addition; combining the two data table data to generate combined report data:
and then performing data analysis based on the combined report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011581134.9A CN112685471A (en) | 2020-12-28 | 2020-12-28 | Accounting and analyzing method for financial data based on non-tree detail classification label system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011581134.9A CN112685471A (en) | 2020-12-28 | 2020-12-28 | Accounting and analyzing method for financial data based on non-tree detail classification label system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112685471A true CN112685471A (en) | 2021-04-20 |
Family
ID=75453555
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011581134.9A Pending CN112685471A (en) | 2020-12-28 | 2020-12-28 | Accounting and analyzing method for financial data based on non-tree detail classification label system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112685471A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101141754A (en) * | 2006-09-05 | 2008-03-12 | 中兴通讯股份有限公司 | Value-added service analysis and method thereof |
| CN101379525A (en) * | 2006-02-16 | 2009-03-04 | 咨询服务支持公司 | Configuring system and method for accelerating financial analysis |
| CN104391986A (en) * | 2014-12-10 | 2015-03-04 | 用友软件股份有限公司 | Business reclassification device and business reclassification method |
| CN106228439A (en) * | 2016-07-22 | 2016-12-14 | 李丹 | A kind of financial data management method and system |
| CN110555026A (en) * | 2019-03-08 | 2019-12-10 | 原仓(广州)文化科技有限公司 | IP data intelligent management system |
| CN111444248A (en) * | 2019-01-17 | 2020-07-24 | 上海铁锹信息科技有限公司 | Method for checking and analyzing enterprise operation data |
-
2020
- 2020-12-28 CN CN202011581134.9A patent/CN112685471A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101379525A (en) * | 2006-02-16 | 2009-03-04 | 咨询服务支持公司 | Configuring system and method for accelerating financial analysis |
| CN101141754A (en) * | 2006-09-05 | 2008-03-12 | 中兴通讯股份有限公司 | Value-added service analysis and method thereof |
| CN104391986A (en) * | 2014-12-10 | 2015-03-04 | 用友软件股份有限公司 | Business reclassification device and business reclassification method |
| CN106228439A (en) * | 2016-07-22 | 2016-12-14 | 李丹 | A kind of financial data management method and system |
| CN111444248A (en) * | 2019-01-17 | 2020-07-24 | 上海铁锹信息科技有限公司 | Method for checking and analyzing enterprise operation data |
| CN110555026A (en) * | 2019-03-08 | 2019-12-10 | 原仓(广州)文化科技有限公司 | IP data intelligent management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Diba et al. | Extraction, correlation, and abstraction of event data for process mining | |
| US9542424B2 (en) | Lifecycle-based horizontal partitioning | |
| US8392460B2 (en) | Relationship data management | |
| US20110119300A1 (en) | Method Of Generating An Analytical Data Set For Input Into An Analytical Model | |
| JP2665407B2 (en) | Data classification method and device | |
| US8484157B2 (en) | Compensating for unbalanced hierarchies when generating OLAP queries from report specifications | |
| US20120005153A1 (en) | Creation of a data store | |
| KR20080002941A (en) | Adaptive data cleaning | |
| Shahid et al. | Application of data warehouse in real life: State-of-the-art survey from user preferences’ perspective | |
| CN114880405A (en) | Data lake-based data processing method and system | |
| US11762820B2 (en) | Automatic conversion of data models using data model annotations | |
| US20080222189A1 (en) | Associating multidimensional data models | |
| US10922328B2 (en) | Method and system for implementing an on-demand data warehouse | |
| Vogelgesang et al. | Celonis PQL: A query language for process mining | |
| CN107562949B (en) | Method for writing merged report Excel template into database | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| CN112685471A (en) | Accounting and analyzing method for financial data based on non-tree detail classification label system | |
| CN115878623A (en) | Logistics industry data asset catalog management method and system | |
| Dong et al. | Scene-based big data quality management framework | |
| CN112258151B (en) | Pampas-based account checking method, device, computer equipment and storage medium | |
| CN114969125A (en) | General data query and statistics method and system | |
| Trabelsi et al. | User-Centred Application for Modeling Journeys in Digital Libraries | |
| CN111324625A (en) | Upper computer data report application method | |
| Mohania et al. | Active, Real-Time, and Intellective Data Warehousing. | |
| Moses et al. | Multidimensional Analysis and Mining of Call Detail Records Using Pattern Cube Algorithm |
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: 20210420 |