XBRL GL to XBRL FR: The Power of Integration

1
XBRL GL to XBRL FRThe Power of Integration

• Eric E. Cohen
• Founder, XBRL GL Working Group
• Co-chair, XBRL GL-FR Subcommittee

2
Agenda

• Brief overview XBRL GL
• XBRL GLs role in integrating the business
  reporting/audit reporting supply chain
• Demonstration
• Issues under discussion in our GL-FR efforts
• Call to action

3
It's not
It's not
Other views of data
but it is
But it is
UBL
UBL
Statutory Filings
ACORD
ACORD
Statistics
Tax Returns
EDI
EDI
Financial Statements
Master Files Operational Details Journal
Entries Trial Balances Setup Files and more
4
Scope and role of XBRL
XBRL GL, the Journal Taxonomy
XBRL Financial Reporting
External Business Reporting
Business Operations
Internal Business Reporting
Investment, Lending, Regulation
Economic Policymaking
Processes
Investors
Financial Publishers and Data Aggregators
Companies
Central Banks
Participants
Auditors
Trading Partners
Regulators
Management Accountants
Software Vendors
5
EECs Vision

• A piece of business information, once entered
  into any system, anywhere, never has to get
  retyped as it flows along the information supply
  chain.
• Managers vision drill down from end reporting
  to underlying detail
• Auditors vision easy access to the original
  source document, tracking full authorization of
  entries (accountability)

6
With XBRL GL

• You can associate accounts, documents, entries to
  end reporting concepts anywhere along the audit
  reporting supply chain
• Facts can be associated with multiple reporting
  concepts simultaneously
• You can track multiple sets of books
• Tracking book to tax differences (FAS 109/IAS 12)
  comes standard

7
Integration From Detail to Reporting

• With inspiration from the leading financial
  reporting extender
• Assignment of accounts to reporting
• Reporting trees
• Reporting calendars

8
Assignment of Accounts to Reporting

• Accounts in all their varieties
• Traditional accounts
• Customer, employees, banks, jobs

9
The xbrlInfo Structure

• xbrlInclude
• Label roles
• Matching to appropriate elements
• summaryReportingElement
• detailMatchingElement

Time Sheet 100 hrs _at_ 10 1000
ltmeasurableQuantitygt
ltamountgt
10
Assignment xbrlInfo
Balance Sheet Assets Cash
XBRL GL ltxbrlInfogt ltxbrlIncludegtending_balance lts
ummaryReportingElementgtCash lt/xbrlinfogt ltxbrlInfo
gt ltxbrlIncludegtperiod_change ltsummaryReportingElem
entgtChangeInCash lt/xbrlinfogt
Statement of Changes Changes in Cash
11
Multi-GAAP Reporting
US GAAP
XBRL GL ltxbrlInfogt ltxbrlIncludegtending_balance lts
ummaryReportingElementgtusfr-ptCash lt/xbrlinfogt lt
xbrlInfogt ltxbrlIncludegtending_balance ltsummaryRepo
rtingElementgtifrs-gpCash lt/xbrlinfogt ltxbrlInfogt
ltxbrlIncludegtending_balance ltsummaryReportingEleme
ntgtirs-1120Cash lt/xbrlinfogt ltxbrlInfogt ltxbrlIncl
udegtending_balance ltsummaryReportingElementgtxyz-fr
Cash lt/xbrlinfogt
IFRS
US Tax
Management Reporting
12
Glossary of Drilling Concepts

• Drill down
• Starting with summarized information, moving
  towards underlying detail, eventually back to the
  source document and original entry. Focusing on
  one fact and finding more information on that
  fact.
• Drill up
• Starting with detail, moving toward summarization
  of that detail, eventually to the end assertion.
  An action that removes the children and focuses
  on the parent.
• Drill around
• Being able to change direction and move up or
  down a different path than the original drill
  down or drill path

A concept I was introduced to by Navision.
13
Drill Up, Drill Down, Drill (All) Around
XBRL GL ltxbrlInfogt ltxbrlIncludegtending_balance lts
ummaryReportingElementgtusfr-ptCash lt/xbrlinfogt lt
xbrlInfogt ltxbrlIncludegtending_balance ltsummaryRepo
rtingElementgtirs-1120Cash lt/xbrlinfogt ltxbrlInfogt
ltxbrlIncludegtending_balance ltsummaryReportingElem
entgtxyz-frCash lt/xbrlinfogt
US GAAP
US Tax
Management Reporting
14
Reporting Trees
Northeast
Lynn Jones
Bill LePage
Americas
Northwest
United States
Mary Epp
Southeast
Mary ODonnelly
Southwest
15
XBRL GLs Sophisticated Accounts
segmentParentTuple - parentSubaccountCode -
parentSubaccountType - reportingTreeIdentifier -
parentSubaccountProportion
Parent Account
Account
Multiple reporting trees Fractional allocation
16
Reporting Calendars
For aggregation For column headings For cut-offs

• Days
• Weeks
• Months
• Quarters
• Years
• Calendar
• Custom

17
Demonstration
XBRL GL
18
Integration Additional Proposed Solutions

• Limit XBRL GL
• Virtual limitations through profiles
• Hard code end reporting hints

19
Conclusion

• The power of integration is
• Bringing together detail from disparate systems
  anywhere along the information supply chain
• Drill up, drill down, drill around
• All of the support for reporting in one place
• Enabled today, more powerful tomorrow
• The facilitator for the seamless audit trail

20
Feedback

• Requirements
• Please share
• xbrlgl_at_xbrl.org
• http//groups.yahoo.com/group/xbrl-gl-public
• Your speaker
• Eric E. Cohen
• XBRL Global Technical Leader, PwC
• Eric.E.Cohen_at_us.pwc.com
• 1-585-271-4070