XBRL intelligent report platform based statement consolidation data extraction method

Abstract

The invention relates to a financial statement generation technology and aims to solve the problems of high workload and high error rate in a process of obtaining existing financial statement consolidation data. The invention provides an XBRL intelligent report platform based statement consolidation data extraction method. The method comprises the following steps: firstly, obtaining fixed dimensions and row dimensions from a statement configuration table, a statement row configuration table and a statement column configuration table, generating and executing a dynamic SQL, automatically retrieving data available for a current statement from a statement consolidation fact table, and inserting the data into a fact middle table; secondly, performing Cartesian join on the statement row configuration table and the statement column configuration table through statement IDs, generating a dynamic SQL of extracted data, inserting the dynamic SQL into a row-column dynamic SQL temporary table, obtaining path and fact value information, and inserting the path and fact value information into a fact value table; and finally, performing circulation on each statement to obtain complete fact value table data identifiable for an XBRL platform, and storing the complete fact value table data in a statement value table. The method is suitable for extracting statement consolidation data of the XBRL intelligent report platform.

Description

technical field [0001] The invention relates to a financial statement generation technology, in particular to a method for extracting consolidated statement data based on an XBRL intelligent report platform. Background technique [0002] XBRL eXtensible Business Reporting Language is an Internet-based, cross-platform computer language that is specially used for the preparation, disclosure and use of financial reports. After an enterprise edits taxonomy standards and instance files, it needs a lot of manual operations to generate instance data files. [0003] With the increasing use of the XBRL platform, financial personnel also exposed some disadvantages when using the XBRL platform to manually import report data: [0004] (1) When reporting the financial report, it is necessary to download the relevant report data from the consolidated report system, which is repetitive work. [0005] (2) It is necessary to sort out the reports and correspond to the items of the instance ...

AI Technical Summary

Problems solved by technology

[0004] (1) When reporting the financial report, it is necessary to download the relevant report data from the consolidated report system, repetitive work

[0005] (2) It is necessary to sort out the reports and correspond to the items of the instance documents, which is cumbersome and error-prone

[0006] (3) It is necessary to manually import the XBRL platform. If the imported information is wrong, it has to be imported again

[0007] (4) It is processed manually and is only used to report very few financial reports. When a large number of financial reports are required, the workload of financial personnel will be extremely large