A Case Study On C Group Consolidated Financial Statements Accounting System Based On Data Warehouse

The consolidated financial statements are the financial statements of the Group's overall financial position,operating results and cash flows,and its preparation has become increasingly difficult and complex with the development of the Group.At present,many domestic group companies still use Excel or report software to support the manual method to prepare consolidated financial statements,which is inefficient and inaccurate.As part of accounting information construction,the consolidated reporting system should also accelerate the pace of construction.With the development of data warehousing technology,many developers have developed a data warehouse-based,consolidated reporting system that is independent of the ERP business environment and has an integrated data relationship with the ERP system,integrating multiple sources and multiple types of data.Achieve multidimensional data analysis,support systems for comprehensive management of report consolidation,comprehensive budget management,and fund management.With the deepening of management accounting concepts,more and more group companies have begun to build a consolidated financial statement system based on data warehouse.In early 2017,C Group began to build a group-level consolidated financial statement system based on data warehouse technology.After one year of construction,it began to be put into use in 2018.After the system is launched,a unified and standardized financial data integration process is established,and the consolidated reporting period is shortened and the accuracy is improved.The problems of difficult preparation of consolidated financial statements,untimely reports,and inaccuracy are solved.With the support of data warehouse technology,it can support flexible and changeable organizational structure,subject and other dimensions,automatic and efficient reconciliation platform,issue external financial statements and analytical reports,data sources traceable,safe and efficient,and make the group consolidated financial The reporting system has become a powerful tool for group management.Based on the current situation of the construction and application of the consolidated financial statements of C Group,this paper uses the case study method to study the application of the consolidated financial statement system based on data warehouse in C Group.This paper first discusses the consolidated financial statement system based on data warehouse and its characteristics.It describes the application status of C Group's consolidated data reporting system based on data warehouse as much as possible.Based on this,the application results are analyzed and summarized.Apply experience and discover some meaningful revelations.After research,the following conclusions are obtained: Firstly,the consolidated reporting system based on data warehouse can integrate with massive data of ERP system,use ETL tools to process data,and support complete consolidated financial statements from automatic issuance of single report to automatic cancellation of internal transaction.Preparation process.Secondly,it is concluded that the application of the consolidated reporting system must meet the actual needs of the enterprise,the consolidation system should meet the multi-level requirements,and the complete merger management process should be established by means of the system.The successful application of the system depends on the high-quality implementation,and the construction of the large-scale group merger system should consider the whole.Experience in information construction.Finally,from the application of new technology improvements,improve the management level of the business,benefit costs support the use of new technologies,large group companies suitable for the use of data warehouse technology,must pay attention to the implementation process of the system,the construction of information systems with planning and forward-looking and other inspiration.The innovation of this paper lies in the large scale of the research object C group,the large number of companies and the complicated business volume.The research on the consolidated financial statement system is rare;it is different from the traditional consolidated system based on report items.How the reporting system utilizes the characteristics of data warehousing technology to solve the pain points and difficulties of compiling consolidated reports.Due to the limitations of its own knowledge level and vision,the understanding of the accounting consolidation system at home and abroad is not deep enough,and the experience of implementing the application system is insufficient.It is only summarized through this application,and the depth of the article needs to be improved.