Transcript XBRL GL and External Reporting

XBRL GL and
External Reporting
®
Walter Hamscher ([email protected])
Vice Chair, XBRL International
Consultant to PricewaterhouseCoopers
Or,
Finding the
Missing Link
®
Walter Hamscher ([email protected])
Vice Chair, XBRL International
Consultant 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
Processes
Business
Operations
XBRL
Internal
Financial
Reporting
Externa
l
Financi
al
Reporti
ng
XBRL
XBRL
Financial
Publishers
and Data
Aggregators
Companies
Participants
Trading
Partners
Management
Accountants
Investment,
Lending, and
Regulation
Auditors
Software Vendors
Investors
Regulators
Strategic Framework
External
Today:
XML Rendering
of existing GAAP
Reporting Standards
Internal
External
Financial
Reporting
Internal
Financial
Reporting
External
Business
Performance
Reporting
Internal
Business
Operations
Reporting
®
Near Future:
XML supporting
G/L Level
Information
Exchange
Standards
Financial
Operational
Far Future:
XML supporting
Emerging Business
Performance
Metrics
Future:
XML supporting
Standardized
Business Event
Vocabularies
Example of a typical FCC
regulatory report
®
®
Example of same report using XML
®
Relationship to other standards
 External reporting to different targets
RIXML, NewsML:
Manage many documents
Information
Aggregation
MDDL:
Convey price
data
Investment
Decision
Making
External
Reporting
XBRL US/UK GAAP Taxonomies:
Capture precise business
performance detail data
Regulation
Trade
Execution
FIX, FIXML, IFX, OFX,
FpML: Execute
decisions
®
Relationship to other Standards
 Business events (buying, selling, hiring,
trading) give rise to transactions that are
recorded in an accounting system.
Human
Resources
InterEnterprise
Business
Operations
Purpose of FIX, OFX,
IFX, HR-XML, ACORD,
many other standards
in different industries.
Purpose of OAG and OMG:
Message sets cover GL
incidentally; mainly for other
system-to-system interfaces
Purchasing
Other
Systems
Internal
Reporting
Sales
Trading
General
Ledger
Purpose of XBRL GL:
Exclusively exchange GL
data in a comprehensive way
®
The Business Reporting
Supply Chain
Processes
Industry
Specific
Business
--Operations
e.g.
ACORD
XBRL
XBRL-GL
Internal
Financial
The
Reporting
Journal
Standard
External
XBRL Investment,
Financial
Lending, and
Financial
Statements
Reporting
Regulation
XBRL
XBRL
Financial
Publishers
and Data
Aggregators
Companies
Participants
Trading
Partners
Management
Accountants
Auditors
Software Vendors
Regulators
Investors
®
®
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
®
XBRL
Doc
Do Something
XBRL
Doc
Mapping
Mapping
Not
XBRL
Not
XBRL
Analysis
Reporting
®
®
®
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
®
Business
Unit A
Company
C
Business
Unit B
Company
D
Company
D1, D2...
Analysts
G1, G2...
Company
E
Company
F
XBRL-GL AR
Ledger
XBRL-GL Trial
Balances
Statements with
Eliminations
Consolidated
Statements
®
Wacoal:
XBRL GL Auto Journalizing System
XiRUTE
Copyright 2004 Hitachi
®
XBRL
Taxonomy
ERP
Package
XBRL
Instance
Beginning
Balance
Instance
XBRL-GL
Taxonomy
XBRL-GL
Output
Core
Balance
Instance
Business
Multi-Currency
Hitachi ERP Package
GEMPLANET/Lite
XBRL
Output
Jp-commerce
Company
Custom
Generate
General Ledger
Link
F/S
Instance
Detail Information
(Segment/Accoun
t)
drill down
Journal Slip
Instance
USK
XBRL
Taxonomy
Presentation
Generate
F/S
Balance Sheet
Income
Statement
XBRL
Taxonomy
Generate Presentation
Information from XBRLTaxonomy
Financial
Analysis
ROE,ROA and other financial
ratio& Services,L
All Rights Reserved Copyright© 2002,Hitachi,Ltd.／Hitachi Systems
®
®
®
®
®
Thanks to CaseWare IDEA
®
Thanks to CaseWare IDEA
®
Thanks to CaseWare IDEA
®
®
Thanks to CaseWare IDEA
XBRL GL and
External Reporting
®
Walter Hamscher ([email protected])
Vice Chair, XBRL International
Consultant 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.
®