® xbrl gl and external reporting walter hamscher (walter@hamscher.com)walter@hamscher.com vice...

®

XBRL GL and External Reporting

Walter Hamscher (walter@hamscher.com)Vice Chair, XBRL InternationalConsultant to PricewaterhouseCoopers

®

Or,Finding the Missing Link

Walter Hamscher (walter@hamscher.com)Vice Chair, XBRL InternationalConsultant to PricewaterhouseCoopers

®

Summary

The Business Reporting Supply-Chain GL for External Reporting Purposes of Internal Reporting Reporting as Pivoting Directions

®

The business reporting supply-chain

ExternalFinancialReporting

BusinessOperations

InternalFinancialReporting

Investment,Lending, andRegulation

Processes

Participants

AuditorsTradingPartners

Investors

FinancialPublishersand Data

Aggregators

Regulators

Software Vendors

ManagementAccountants

Companies

XBRLXBRLXBRLXBRLXBRLXBRL

® Strategic Framework

InternalFinancialReporting

ExternalFinancial

Reporting

InternalBusiness

OperationsReporting

ExternalBusiness

PerformanceReporting

InternalInternalExternalExternal

FinancialFinancial

OperationalOperational

Today:XML Rendering

of existing GAAPReporting Standards

Future:XML supportingStandardized

Business EventVocabularies

Near Future:XML supporting

G/L LevelInformationExchangeStandards

Far Future:XML supporting

Emerging BusinessPerformance

Metrics

®

Example of a typical FCCregulatory report

®

Example of same report using XML

®

Relationship to other standards

External reporting to different targets

ExternalReporting

TradeExecution

InvestmentDecision Making

Regulation

InformationAggregation

XBRL US/UK GAAP Taxonomies: Capture precise business performance detail data

FIX, FIXML, IFX, OFX, FpML: Execute

decisions

RIXML, NewsML:Manage many documents

MDDL:Convey price

data

®

Relationship to other Standards

Business events (buying, selling, hiring, trading) give rise to transactions that are recorded in an accounting system.

Human Resources

General Ledger

InternalReporting

Purchasing

Sales

Inter-Enterprise Business

Operations

Trading

Purpose of FIX, OFX, IFX, HR-XML, ACORD, many other standards in different industries.

Other Systems

Purpose of XBRL GL:Exclusively exchange GL

data in a comprehensive way

Purpose of OAG and OMG:Message sets cover GL

incidentally; mainly for other system-to-system interfaces

®

ExternalFinancialReporting

BusinessOperations

InternalFinancialReporting

Investment,Lending, andRegulation

Processes

Participants

AuditorsTradingPartners

Investors

FinancialPublishersand Data

Aggregators

Regulators

Software VendorsSoftware Vendors

ManagementAccountants

Companies

XBRL XBRLXBRL

XBRLFinancial Statements

XBRL-GL

TheJournal

Standard

IndustrySpecific

---e.g.

ACORD

The Business Reporting Supply Chain

®

®

Summary

The Business Reporting Supply-Chain GL for External Reporting Purposes of Internal Reporting Reporting as Pivoting Directions

®

Internal Reporting: Purpose

Review past results Review forecast results Identify exception conditions Answer specific questions Inputs to further calculations/modeling Inputs to other processes

Thanks to Rob Zwiebach, Oracle Corporation

®

Internal Reporting: Audience

Executive Financial Analyst LOB Manager

Thanks to Rob Zwiebach, Oracle Corporation

®

Internal Reporting: Level of Detail

Corporate Line of Business Geographic Departmental

Thanks to Rob Zwiebach, Oracle Corporation

®

Internal Reporting: Timeframe

Daily Weekly Monthly Quarterly Yearly Comparative Ad hoc

Thanks to Rob Zwiebach, Oracle Corporation

®

Internal Reporting: Type

Static Interactive Ad hoc

Thanks to Rob Zwiebach, Oracle Corporation

®

XBRL Sweet Spot

Purpose: Inputs to Further Calculations/Modeling, Input to Other Processes

Audience: Financial Analysts Level of Detail: Any Timeframe: Any Type: Static

Thanks to Rob Zwiebach, Oracle Corporation

®

AnalysisReporting

NotXBRL

XBRLDoc

NotXBRL

XBRLDoc

Do Something

Mapping Mapping

®

®

®

Summary

The Business Reporting Supply-Chain GL for External Reporting Purposes of Internal Reporting Reporting as Pivoting Directions

®

XBRL GL instance as seen by Excel

Thanks to David Scott Stokes, IT Specialist Chartered Accountant FCA PMP MACS

®

Reporting as Pivoting

Thanks to David Scott Stokes, IT Specialist Chartered Accountant FCA PMP MACS

®

Summary

The Business Reporting Supply-Chain GL for External Reporting Purposes of Internal Reporting Reporting as Pivoting Directions

®

BusinessUnit A

BusinessUnit B

CompanyC

CompanyD1, D2...

CompanyE

AnalystsG1, G2...

CompanyD

XBRL-GL ARLedger

XBRL-GL TrialBalances

Statements withEliminations

ConsolidatedStatements

CompanyF

®

Wacoal: XBRL GL Auto Journalizing System

Copyright 2004 Hitachi

XiRUTE

®

XBRLXBRLTaxonomyTaxonomy

XBRLXBRLTaxonomyTaxonomy

XBRL-GLTaxonomy

XBRLTaxonomy

CompanyCustom

Jp-commerce

Core

USK

Business

Multi-CurrencyHitachi ERP Package

GEMPLANET/Lite

XBRLOutput

XBRL-GLOutput

ERPERPPackagePackage

ERPERPPackagePackage

F/SInstance

Journal SlipInstance

Beginning BalanceInstance

XBRLXBRLInstanceInstance

XBRLXBRLInstanceInstance

Link

BalanceInstance

PresentationPresentationPresentationPresentation

FinancialAnalysis

All Rights Reserved Copyright© 2002,Hitachi,Ltd. ／ Hitachi Systems & Services,Ltd

GenerateGeneral Ledger

GenerateF/S

drill down

Balance Sheet

Income Statement

ROE,ROA and other financial ratio

Detail Information(Segment/Account)

Generate Presentation Information from XBRL-Taxonomy

XBRLTaxonomy

®

®

®

®

®

Thanks to CaseWare IDEA

®

Thanks to CaseWare IDEA

®

Thanks to CaseWare IDEA

®

®

Thanks to CaseWare IDEA

®

XBRL GL and External Reporting

Walter Hamscher (walter@hamscher.com)Vice Chair, XBRL InternationalConsultant to PricewaterhouseCoopers

®

Summary

The Business Reporting Supply-Chain GL for External Reporting Purposes of Internal Reporting Reporting as Pivoting Directions

®

Abstract(Duration: 30 minutes) Automation of the business reporting supply chain

will benefit all participants, but most of the information content of that supply chain resides inside of organizations, and only a tiny subset is released to the outside world. With the release of GL 2005, an XBRL taxonomy for recording ledger entries, we will soon have the tools in hand to accelerate the integration of disparate systems inside of companies and government agencies large and small. This talk will illustrate ways in which GL 2005 instances could be used in the preparation of external reports.