Comprehensive financial data modeling - FR, GL, and Internal Control Taxonomy -

1
(No Transcript)
2
Comprehensive financial data modeling- FR, GL,
and Internal Control Taxonomy -

• Yuji Furusho
• yfurusho_at_jp.fujitsu.com
• Fujitsu Limited

3
Basic Concept (1/2)

• Corporate Financial Data Model
• Binding FR and GL
• Describe Business Process (IC) in XBRL
• Risks in business process
• Controls to mitigate the risks
• Binding GL and IC

4
Basic Concept (2/2)
5
The Merit of Internal Control Taxonomy

• Comprehensive corporate data model to provide
• Risk management to identify material weakness in
  internal controls and supports to plan act
  accordingly with materiality of deficiencies.
• Business Process Management based on materiality
  of business process with relation to financial
  reports.
• Possible management dashboard for top management
  to understand areas of risks.

6
Why XBRL Taxonomy?

• Integrity with financial information
• Flexibility and Extensibility
• Defines corporate-specific risks and controls
  using COSO template.
• Data management and workflow
• Facilitates information sharing regarding
  Internal Controls definition or evaluation among
  Business Process Owner, Internal Control
  Department, and external auditor.

7
Binding FR-GL-IC (1/2)
8
Binding FR-GL-IC (2/2)
Significant account
Business Process (Sales)
9
Risk-Control evaluation workflow
Step 1 BPO
Step 2 Internal Auditor
Step 3 BPO
Document Internal Controls On Business Process
Test Internal Controls And Report
Evaluate Report And Plan Remediation
10
Risk-Control evaluation data model (1/3)
Activity Related Accounts(multiple) Sub Activity Control Objective Control Objective Attribute Control Objective Attribute Control Objective Attribute Risk
Activity Related Accounts(multiple) Sub Activity Control Objective Operation Financial Reporting Compli- ance Risk
String String String String Boolean Boolean Boolean String
String String String String Boolean Boolean Boolean String
String String String String Boolean Boolean Boolean String
String String String String Boolean Boolean Boolean String
String String String String Boolean Boolean Boolean String
Pre-defined section of Internal controls Pre-defined section of Internal controls Pre-defined section of Internal controls Pre-defined section of Internal controls Pre-defined section of Internal controls Pre-defined section of Internal controls Pre-defined section of Internal controls Pre-defined section of Internal controls
11
Risk-Control evaluation data model (2/3)
Control Key Control Assertion Assertion Assertion Assertion Assertion
Control Key Control E/O C V/A R/O P/D
String Boolean Numeric Numeric Numeric Numeric Numeric
String Boolean Numeric Numeric Numeric Numeric Numeric
String Boolean Numeric Numeric Numeric Numeric Numeric
String Boolean Numeric Numeric Numeric Numeric Numeric
String Boolean Numeric Numeric Numeric Numeric Numeric
String Boolean Numeric Numeric Numeric Numeric Numeric
String Boolean Numeric Numeric Numeric Numeric Numeric
Internal controls documentation Internal controls documentation Internal controls documentation Internal controls documentation Internal controls documentation Internal controls documentation Internal controls documentation
12
Risk-Control evaluation data model (3/3)
Test Results - Score Test Results - Narrative Remediation Plan
Numeric String String
Numeric String String
Numeric String String
Numeric String String
Numeric String String
Numeric String String
Numeric String String
Test Internal controls evaluation Test Internal controls evaluation GAP remediation
13
IC Taxonomy Data Model
14
COSO Cartridge
15
Taxonomy Creation Approach (1/2)
16
Taxonomy Creation Approach (1/2)
17
IC DTS Diagram - Overall
18
IC DTS Diagram - Template
19
IC DTS Diagram - A Company
20
Demo
FR to GL
Top page to Financial Report
GL to IC