Research On Consolidated Financial Statement In ERP Base On B Company

The consolidated financial statement is a difficult problem in account field. How to make consolidated financial statements correctly and quickly to show the real operating result of the enterprise group is a great challenge for domestic enterprise,most of the group companies are used to use Excel as tools to make consolidated report based on financial accounting data in practice. Once the business data is to be adjusted or reformed, it requires exporting data from domestic ERP system again to revise the consolidated working papers. It consumes more time; also it is low in efficiency, and result in high error rate. Obviously, this method of base on the static data to prepare the consolidated financial statements cannot meet the requirement of modern enterprise management. Although most of the domestic group company with local ERP with its own consolidated financial statements module, but most of them are not good because the standards of consolidated accounting statements is difficult to understand for domestic ERP designer, and the current domestic ERP consolidated statements module design is also to be simulated with the manual process of preparing the consolidated financial statements; therefore the majority of enterprises cannot use ERP system make the consolidated financial statements efficiently.As to the problems, this thesis took B Company as a case, to analysis the method of preparing consolidated financial statements and point out the problem existing in the preparation of the consolidated financial statements in ERP system. Then generate a new model to prepare the consolidated financial statements, which identify the inter business data of group from the beginning of business, mark them, then make offset automatically. By this method, we can get the basis offsetting data of consolidated statements. At the same time we need to establish a virtual ADJ account in the ERP system( "adjusting entries account ") to input special adjusted data to offset internal business. Then through the ERP report system or EXCEL tool, we can get the data across company account in the ERP database system directly to prepare consolidated financial statements, which can improve the efficiency of preparing consolidated financial statements, if you find errors in subsidiary accounting entries change it and refresh the report, and mistake can be solved. By the way, it can refresh data of consolidated financial statements from "static" to "dynamic", greatly improving theWork efficiency. Of course, in order to realize the dynamic consolidated data, we need to initialize definition of ERP system, mark internal transaction data to be adjusted in ERP system.In this thesis, it firstly introduces the theory of consolidated financial statement and ERP, and study the feasibility of this new method under the ERP from the theoretical level of the consolidated financial statements, study the case of B Company, generate new suggestions for the problem existing in the preparation method of the consolidated financial statements of company B. Finally, it summarizes and advices on how to improve the quality and efficacy of consolidated financial statements under the ERP system.