1 / 19

December 6, 2006 Makoto Koizumi Koizumi.Makoto@jp.fujitsu

December 6, 2006 Makoto Koizumi Koizumi.Makoto@jp.fujitsu.com. INRPT07: Comprehensive Financial Data Modeling. - FR, GL, and Internal Control Taxonomy -. Basic Concept (1/2). Corporate Financial Data Model Binding FR and GL Describe Business Process (IC) in XBRL Risks in business process

obelia
Download Presentation

December 6, 2006 Makoto Koizumi Koizumi.Makoto@jp.fujitsu

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. December 6, 2006Makoto KoizumiKoizumi.Makoto@jp.fujitsu.com INRPT07: Comprehensive Financial Data Modeling - FR, GL, and Internal Control Taxonomy -

  2. 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

  3. Organization Management Financial Statement (XBRL-FS) (Material Accounting Item) Ex: Total Asset (BS) Ex: Sales (PL) Ex: Profit before tax (PL) General Ledged (XBRL-GL) (Legion): (Detail accounting item) Ex: Sales ⇒ Head Office : Sales Accounting (Software) Account Management Internal Control(XBRL-IC) Business Process: Sales Process Activity(1:n)⇒Attribute(O,F,C) (1:n) Risk(1:n) Control Objective(1:1) Control Activity(1:n) Key Control(1:1) Test Effect/ Evaluation (1:n) IT General Control Business Process Management Basic Concept (2/2)

  4. 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.

  5. 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 Control’s definition or evaluation among Business Process Owner, Internal Control Department, and external auditor.

  6. ＦＲ Taxonomy ＧＬ Taxonomy ＩＣ Taxonomy sales ＦＲ Instance ＧＬ Instance ＩＣ Instance Summary xbrlinfo 01000 Related accounts Binding FR-GL-IC (1/2)

  7. Location x Detail account 拠点・詳細科目 （半導体・本社） 拠点・詳細科目 （半導体・本社） n 拠点・詳細科目 （半導体・本社） Sub Process （Inbound） Location x Detail account 拠点・詳細科目 （半導体・本社） 拠点・詳細科目 （半導体・本社） n 拠点・詳細科目 （半導体・本社） Sub Process （Operations） Sub Process （Process Account Receivable） n Binding FR-GL-IC (2/2) Significant account Business Process （Sales）

  8. 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

  9. Risk-Control Evaluation Data Model (1/3)

  10. Risk-Control Evaluation Data Model (2/3)

  11. Risk-Control Evaluation Data Model (3/3)

  12. Process coso:Process Related Accounts coso:Activity COSO cartridge Activity coso:SubActivity coso:ControlObjectives SubActivity Control Objectives Control Objectives Attribute coso:Risk Risks Assertions Controls Tests Control Activities Test Results - Score Key Control Test Results - Narrative Substitution Group tuple item attribute Remediation Plan IC Taxonomy Data Model

  13. Internal Control Taxonomy - Company-A Salary R&D Sales CostAccounting Purchase FixedAsset Taxation Investment & Loan FinancialReporting COSO Taxonomy 21/Activity : PROCESS BENEFITS AND RETIREE INFORMATION 22/Activity : PROCESS PAYROLL 23/Activity : PROCESS TAX COMPLIANCE 24/Activity : PROCESS PRODUCT COSTS 25/Activity : PROVIDE FINANCIAL AND MANAGEMENT REPORTING 11/Activity : PROVIDE ADMINISTRATIVE SERVICES 12/Activity : MANAGE INFORMATION TECHNOLOGY 13/Activity : MANAGE RISKS 14/Activity : MANAGE LEGAL AFFAIRS 15/Activity : PLAN 16/Activity : PROCESS ACCOUNTS PAYABLE 17/Activity : PROCESS ACCOUNTS RECEIVABLE 18/Activity : PROCESS FUNDS 19/Activity : PROCESS FIXED ASSETS 20/Activity : ANALYZE AND RECONCILE 1/Activity : INBOUND 2/Activity : OPERATIONS 3/Activity : OUTBOUND 4/Activity : MARKETING AND SALES 5/Activity : SERVICE 6/Activity : PROCUREMENT 7/Activity : TECHNOLOGY DEVELOPMENT 8/Activity : HUMAN RESOURCES 9/Activity : MANAGE THE ENTERPRISE 10/Activity : MANAGE EXTERNAL RELATIONS COSO Cartridge

  14. Process taxonomy COSO frame taxonomy Activity Related Accounts(multiple) Sub Activity Control Objective Control Objective Attribute Risk Operation Financial Reporting Compli- ance String String String String Boolean Boolean Boolean String String Boolean Boolean Boolean String String String Boolean Boolean Boolean String String Boolean Boolean Boolean String COSO の各章ごとにフレームワーク に準拠してタクソノミとして作成 Import COSO frame taxonomy where necessary String Palette activities that compose Sub-process Pre-defined section of Internal controls Taxonomy Development Approach (1/2)

  15. Control Key Control Assertion 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 Elements in a taxonomy 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 Test Results - Score Test Results - Narrative Remediation Plan Data in an Instance doc. Data in an Instance doc. 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 GAP remediation Taxonomy Development Approach (2/2)

  16. Concepts Internal Control Terms Elements (ctrl) COSO Framework Terms Elements (coso) Inbound Terms Elements (inbound) Outbound Terms Elements (outbound) Process Terms Elements (proc) Template Company Extension Relationships Process Terms Relationships (proc) COSO Framework Terms Relationships (coso) Internal Control Terms Relationships (ctrl) Inbound Terms Relationships (inbound) Outbound Terms Relationships (outbound) IC DTS Diagram - Overall

  17. Concepts Internal Control Terms Elements (ctrl) COSO Framework Terms Elements (coso) Process Terms Elements (proc) Template Relationships Process Terms Relationships (proc) COSO Framework Terms Relationships (coso) Internal Control Terms Relationships (ctrl) IC DTS Diagram - Template

  18. Concepts Internal Control Terms Elements (ctrl) COSO Framework Terms Elements (coso) Inbound Terms Elements (inbound) Outbound Terms Elements (outbound) Process Terms Elements (proc) Company Extension Relationships Internal Control Terms Relationships (ctrl) Inbound Terms Relationships (inbound) Outbound Terms Relationships (outbound) IC DTS Diagram – A Company

  19. Demo FR to GL Top page to Financial Report GL to IC

More Related