A rapid financial statement merging system and method based on a data warehouse

Abstract

The invention discloses a rapid financial statement merging system and method based on a data warehouse, and relates to the technical field of financial statement merging. The system comprises a setting release module which is used for setting an account type, a currency type, a business type and a certificate type; an account processing module and a collaborative account module which are used fordefining collaborative business receipts and collaborative rules of internal associated businesses; and a merging and offsetting module which is used for offsetting rule setting, internal associatedtransaction business identification, reconciliation record extraction and associated offsetting vouchers generation. According to the present invention, the standard accounting rules are set and issued; the daily accounting business processing is carried out on the standard accounting rules; the internal association business co-processing and the internal association transaction combination offsetting are carried out in the daily accounting business; and finally, a generation and query system of the combined report is constructed, so that the compilation chain for overall planning and combination of the financial report is shortened, the steps are simplified and the report compilation efficiency is improved.

Description

Technical field [0001] The invention belongs to the technical field of financial statement consolidation, and particularly relates to a data warehouse-based rapid financial statement consolidation system and method. Background technique [0002] The consolidated financial statements reflect the overall financial status and operating results of the enterprise group, and the objects reflected are usually accounting entities composed of several legal persons. Most of the existing financial software or financial information systems mainly adopt the method of "reporting by statement" when preparing consolidated financial statements. The individual financial statements are reported layer by layer and collected to the group company. Based on the individual financial statements, the group company prepares a consolidated working paper based on the group's internal transactions and long-term equity investment, and performs offset entries and related adjustment entries. , And then calculat...

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a fast financial statement merging system and method based on a data warehouse, by setting and publishing standard accounting rules; carrying out daily accounting business processing on the standard accounting rules; internal related business in daily accounting business Collaborative processing and merger and offsetting of internal related transactions; finally, the generation and query system of consolidated statements is constructed, which realizes the fast, efficient and accurate consolidation of financial statements, and solves the problem of long preparation chains, cumbersome steps, and difficulty in the consolidation of existing financial statements. Errors and low compilation efficiency

Images