80 likes | 185 Vues
This presentation discusses the implementation of formulas within the CAS taxonomy to improve financial information quality. It highlights issues with the current calculation linkbase, such as the inability to calculate cross-context data and perform element multiplications. Use case analyses demonstrate commonly executed calculations like total sub-category accounts and movement analysis. Additionally, the presentation covers formula design for consistency assertions and automation at the axis level for accurate financial reporting, addressing key challenges in modern financial data management.
E N D
21st XBRL International Conference“One Language, Common Vision: Role of XBRL Technology in the Post Crisis Era19-21 October 2010Beijing, China Technology Track TECH 8. Implementation of Formula in CAS taxonomy Bing Leng, Chao Li 20 Oct 2010
Background • One of the important goal of CAS taxonomy is to enhance the quality of financial information • Calculation linkbase is far from sufficient in terms of representing the inherent logic and dependency of financial reporting data, i.e. • lack of ability to calculate cross context • lack of ability to multiply between elements
Use Case Analysis • Some most commonly used calculation on financial reporting data includes: • Total of sub category accounts • Movement analysis, i.e. beginning balance + increase – decrease = ending balance • Converting between currency exchanges • All these can’t be achieved via calculation linkbase.
Formula Design Illustration • Total of sub category accounts • Dimension table – Changes of inventories
Formula Design Illustration • Total of sub category accounts • Consistency assertion is used • Setup at Axis level, calculation of all line items can be iterated automatically • Overview of formula design as following:
Formula Design Illustration • Total of sub category accounts • Consistency assertion • setting
Formula Design Illustration • Total of sub category accounts • Formula setting
Formula Design Illustration • Total of sub category accounts • Sum variables setting