XBRL GL Inside Standardizing ERP Data Exchanges with the Global Ledger Framework - PowerPoint PPT Presentation

1 / 115
About This Presentation
Title:

XBRL GL Inside Standardizing ERP Data Exchanges with the Global Ledger Framework

Description:

XBRL GL Inside? Standardizing 'ERP' Data Exchanges with the ... Monto Monetario. Fecha de Asignaci n/Ingreso. ??????. ???????. ??. ????. Account# Description ... – PowerPoint PPT presentation

Number of Views:227
Avg rating:3.0/5.0
Slides: 116
Provided by: xbrl2
Category:

less

Transcript and Presenter's Notes

Title: XBRL GL Inside Standardizing ERP Data Exchanges with the Global Ledger Framework


1
 XBRL GL Inside? Standardizing ERP Data
Exchanges with the Global Ledger Framework    
  • PwC/XBRL Outreach, 22 August 2007
  • Eric E. Cohen, PricewaterhouseCoopers
  • eric.e.cohen_at_us.pwc.com

2
Agenda
  • Background on XBRL
  • Focus on XBRL Global Ledger Framework
  • Call to Action
  • Questions
  • Informal discussion

3
Assumption
  • Background in XBRL
  • Understanding of NTP
  • http//www.xbrl-ntp.nl

4
Introduction to XBRL
  • XBRL is
  • XBRL International Inc. Over 500 organizations
    globally collaborating to improve business
    reporting to the benefit of all
  • Technical agreement on creating the vocabularies
    of business and simplified and standardized data
    exchange
  • Collaborative efforts to standardized specific
    reports or flows of business reporting data
  • XML specifically designed for business reporting

5
Business Reporting Supply Chain
Processes
Investors
Financial Publishers and Data Aggregators
Companies
Central Banks
Participants
Regulators and Administrators
External Auditors
Internal Auditors
Management Accountants
Trading Partners
Software Vendors and Service Providers
6
http//www.xbrl-ntp.nl
7
Uses of XBRL
  • Financial reporting
  • US GAAP, IFRS, Canadian, Japanese, German
  • Statutory filings
  • US FDIC, CEBS Basel II
  • Tax filings
  • HMRC and
  • Pan-governmental reporting
  • Netherlands (NTP), Australia
  • Internal integration and reporting
  • XBRLs Global Ledger Framework
  • Sustainability
  • GRI G3

8
XBRL is Making Waves
  • Bottom up
  • Top down
  • Somewhere in the middle
  • BPM, SOA and other efforts all need semantics

9
XBRL and IFRS
NO
SE
FI
NL
DE
CZ
DK
RU
PL
LU
IASB
HU
CA
SI
UK
AT
UA
IE
BE
TR
SP
US
CN
GR
FR
PT
JP
LB
KR
IT
CH
IN
MT
VZ
HK
UAE
CO
SG
BR
Established Jurisdictions
AU
ZA
Provisional Jurisdictions
NZ
AR
in Construction in Project
Countries that require or permit IFRSs
Countries seeking convergence with the IASB on
pursuing adoption of IFRSs
10
XML
  • XML Recommendations
  • XML
  • XML Namespaces
  • XML Schema
  • XLink

11
XML Alone
  • XML solves many integration challenges
  • Numbers
  • Dates
  • Expected format
  • Syntax without semantics
  • Turning old legacy data into

12
XML Describes, XBRL Defines
  • Agreement on human readable labels and
    definitions
  • Pointers to authoritative resources and practical
    guidance
  • Documentation of multiple interrelationships

13
Whats New (Technical)
  • Versioning
  • Formulas
  • Rendering
  • Other extensions to the Specification

14
Focus on the Global Ledger Framework
Reporting
Transactions
Ledger
Spreadsheet
Subsidiary countries
Consolidation
15
How Do You Improve the Input?
Financial Statements
  • Improve quality of source data
  • Increase speed of collection of underlying data
  • Facilitate gathering and movement of greater
    amounts of detail
  • Facilitate reconciliations between different
    reporting
  • Concentrate on both the tip of the iceberg and
    the rest.

Taxes
Underlying Details
16
The Global Ledger In Brief
  • What
  • An, extensible holistic standardized XML-based
    (and XBRL) framework for representing data that
    flows from trade transactions and other business
    events to end reporting a generic representation
    of the setup files, master files, transaction
    files and history files of an ERP system
  • Not
  • A standard chart of accounts
  • Limited to the content of a General Ledger
  • Country or use specific

17
The Global Ledger In Brief
  • How
  • We hope to encourage all vendors to implement as
    an import/export, Web services and data view
    format
  • Can be used today with many middleware products
  • When
  • Today
  • XBRL GLs major modules are in place and full
    RECOMMENDATIONS from XII refinements and
    extensions are modularly added
  • Basic detailed needs met today

18
FR compared to GL
  • FR is about summarized, aggregated, filtered
    data, primarily shared externally according to
    rules and practices
  • GL is about the detail and summaries found in the
    underlying operational, business and accounting
    databases
  • FR is about VIEWS of data
  • GL is standardizing the underlying DATA
  • Supporting business
  • Supporting financial, tax, sustainability,
    statutory, statistics
  • Supporting audit and data interchange

19
Data and Views of Data
Report Writer
Business data
SELECT information from database(s), including
joins
Report
FORMULAS create new data fields
FILTER the record set
Add headers/footers, CONDITIONALS with record
groupings, derived totals based on sorts
Concentration Detailed Data, Data Fields
Concentration Information Concepts
Provide visual FORMATTING rules, like cross-tab
20
Like the Human Genome Project
  • identify all the approximately 20,000-25,000
    genes in human DNA,
  • determine the sequences of the 3 billion chemical
    base pairs that make up human DNA,
  • store this information in databases,
  • improve tools for data analysis,
  • transfer related technologies to the private
    sector, and
  • address the ethical, legal, and social issues
    (ELSI) that may arise from the project.

21
XBRL GL Project
  • identify the thousands of common fields in
    typical and industry ERP,
  • determine the sequences of the logical
    combinations that make up typical ERP,
  • store this information in databases,
  • improve tools for data analysis,
  • transfer related technologies to the private
    sector, and
  • address the ethical, legal, and social issues
    (ELSI) that may arise from the project.

22
Need
  • Improving the flow of data throughout the
    Business Reporting Supply Chain
  • Developing holistic, global solutions (thinking
    globally) while meeting local needs (acting
    locally)
  • Doing this without undue burden on certain parties

23
The Good News About Standards
  • Is that there are so many of them
  • Friendly competition / warring factions
  • Turning old legacy data into new legacy data

24
Challenges
  • Too many standards at the transaction layer
  • Fierce competition
  • Core components ownership
  • Too complex
  • Too specific, not reusable
  • XML doesnt solve everything
  • Format, not semantics

25
Proprietary Formats XML Alone
Point A
Point B
... Point n1
qbxml
qbxml
smbxml
smbxml
Intacct xml
Intacct xml
SAP
SAP
Peoplesoft xml
Peoplesoft xml
Oracle
26
Overcoming N2
  • Or at least N (N-1) (N-2)
  • Without agreements on semantics

UN/CEFACT
ANSI X12
SWIFT
MISMO
QBXML
ACORD
UBL
27
How Is Your Standards Vision?
DE FACTO DE JURE DE CLARED DE STROYED
28
Friendly Competition/Warring Factions
The Good News About Standards
  • Cross-domain organizations
  • ANSI X12
  • ISO (e.g., ISO 20022)
  • OAGI
  • OASIS (e.g., UBL)
  • OECD
  • OMG (UML, SOA Consortium)
  • UN/CEFACT Forum
  • W3C (e.g., XML)
  • XBRL (e.g., XBRL GL WG)
  • Domain-specific organizations
  • ACORD (insurance)
  • HR-XML (payroll/HR)
  • MISMO (mortgages)
  • and many others
  • Proprietary efforts
  • Tax
  • Invoicing
  • Payments

Who claims to be the voice of Governments to
standards-space?
29
How Do We Encourage Interoperability?
30
New World
BPM Stream Processing CEP - (Complex Events
Processing)
Web services Service-Oriented Architecture Enterpr
ise Services Bus
Communications Connectivity Content Commonality Co
ordination
Facilitated by Standard payload
31
Facilitating Interoperability
  • Through Influence
  • Through Unification Efforts
  • Through BRSC Adoption of Interoperable
    Frameworks

?
?
standard!
?
Business Reporting Supply Chain
32
Influence and Unification
Facilitating Interoperability
  • Pick and Promote
  • OASIS Tax XML is a group of tax administrations
    (Australia, Canada, Germany, Netherlands, US, UK)
    and business people with an interest in promoting
    interoperability, harmonization and success in
    standards relevant to the market.
  • UNIFI, but dont Homogenize
  • UNIFI (ISO 20022 UNIversal Financial Industry
    message scheme) recognizes that you cant make
    IFX, SWIFT, ACORD and other consortiums all agree
    immediately, but you can promote a common
    standardization approach (i.e., co-existence) and
    work toward eventual convergence.

33
UNIFI How does it fit into the ISO structure?
ISO Technical Committee TC68 Financial Services
SC7 Banking
SC4 Securities
SC2 Security
UNIFI RMG
RA
RMG members nominated by P-member countries and
A-liaison organisations SEG members nominated by
all member countries and liaison organisations
SEG Securities
SEG Trade Services
SEG Payments
SEG FX
Source www.iso20022.org
34
Consistent e-business Documents Across
Applications and Countries
  • eInvoicing and ePI (electronic payment initiator)
  • UBL approach
  • iECM? (AIIM)
  • XBRL (Extensible Business Reporting Language)

35
XBRL Global Ledger Framework
  • It's not your grandfather's XBRL nor is it your
    grandfathers General Ledger. It is not limited
    to or optimized for sharing data with
    stockholders, tax administrations or securities
    regulators, but it can facilitate all of those
    things. XBRL can help reduce redundant entry
    related to your ERP systems. XBRL's Global Ledger
    Framework (XBRL GL) integration means more
    timely, accurate and detailed information -
    today!  

36
(No Transcript)
37
More Than
  • XBRL GL is more than
  • The General Ledger in XML
  • An end of year interchange format
  • XML
  • A data drill-down tool for XBRL FR
  • One country or one organizations needs
  • XBRL GL
  • The ERP Genome Project
  • Global

38
XBRL GL Representation of a GLOBAL Ledger
documentInfo
accountingEntries
entityInformation
entryHeader
entryDetail
39
Global Ledger Holds More
40
Why?
  • Do you need more efficient internal systems?
  • Design, implement, and manage internal systems
    that support effective decisions.
  • Challenges include
  • Leveraging existing assets while maximizing
    investment in new systems
  • With major focus on controls
  • Reducing non-value-added processes related to
    internal systems while promoting interoperability
    and reusability
  • Stretching budgets while facing increased
    requirements related to financial and tax
    reporting
  • Getting disparate systems to communicate

41
XBRL GL Can Represent
  • The chart of accounts, representing both posting
    accounts and customers, vendors, or other items
    that may be assigned an account in an
    international sense of the word
  • Journal entries, both from subsystems and within
    the General Ledger or financial reporter
  • Document summaries, with generic representations
    of the information that is presented on
    standardized business documents
  • Descriptions of customers, vendors, employees and
    banks, either in connection with the chart of
    accounts (European style) or independently (US
    style)
  • Descriptions of inventory items, performance
    metrics or other quantifiable items
  • Status documents, including listings of
    receivables still owing, payables yet owed,
    inventory in stock, as well as
  • Standard accounting summaries such as trial
    balances, general ledger, source journals and
    other accounting-oriented summaries.

42
An Approach
  • A standards-based approach
  • Helps face all of the challenges
  • Leads to better decision making
  • Establishes a more agile systems environment
  • An investment in a standards-based approach
  • Costs no more today than proprietary approaches
  • Pays off consistently
  • Helps you get information on a timely basis in a
    more usable format
  • XBRL's Global Ledger Framework
  • Ready today to help make this possible
  • Facilitates standardizing on standards and
    leverage technology, rather than standardizing on
    technology

43
Standards-based Data Interchange
XBRL GL
qbxml
qbxml
smbxml
smbxml
Intacct xml
Intacct xml
SAP
SAP
Peoplesoft xml
Peoplesoft xml
Oracle
Industry transactional XML
44
Scenario with POI
45
Scenario with XBRL GL
XBRL GL
46
XBRL GL Enabling Quickbooks
47
Demo Inventory Accounting
XBRL GL
48
Feeding Google
49
Demo Google OneBox
XBRL GL
50
Google OneBox
51
XBRLs Standardized Global Ledger
  • XBRL Global Ledger (GL) Framework is
  • Part of the broader world of XBRL
  • An evolving, generic representation of the files
    in a typical ERP system
  • An XML-based standard that can be used for
    import/export, Web services payload
  • The bridge from transactions to end reporting
  • Different than any other similar effort
  • Openly developed (EDI is openly developed?)
  • XML-based (Transaction standards are XML-based?)
  • Holistic useful for audit and data-interchange
  • Generic, Global and Cross-industry
  • XBRL-compliant provides drill down for XBRL FR
  • Reconciled sets of books (FAS 109/IAS 12, et al)

52
Can We Talk?
  • Automation and integration
  • Audit trail and controls
  • Hybrid reporting

53
ROUTERS
XBRL GL
Copier / Scanner / Fax
54
An XBRL Goal
  • 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)

55
XBRL Global Ledger
  • With a goal of a single, seamless audit trail,
    the Global Ledger Framework is XBRL's
    contribution to bridging business transactions
    and end reporting with a single, holistic,
    generic, standardized XML-based vocabulary

56
A Bridge
  • From Transactions through to Reporting

57
XBRL GL Span the GAP
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
58
Every System as XBRL
Across language Across data definitions Across
file formats
System 3
System 1
System 2
XBRL GL
XBRL GL
XBRL GL
Identificador de la Cuenta Descripción Principal
de la Cuenta Monto Monetario Fecha de
Asignación/Ingreso
?????? ??????? ?? ????
Account Description Amount PostDate
accountMainID accountMainDescription amount po
stingDate
accountMainID accountMainDescription amount po
stingDate
accountMainID accountMainDescription amount po
stingDate
59
Freeing Up the Data in ERP
MS, MRP, CRP
PLANNING
jobs
CONTROL
Job Cost/Shop Floor Control AP, IM, PO, PR
sales orders
purchase orders
OE AR, IM
PO AP, IM
customers
vendors
items
employees
assets
master files
AR
IM bomp
AP
PR
FA
sub-ledgers
check reconciliation
GENERAL LEDGER
REPORTING
60
Modular Taxonomies
  • Recommended
  • CORE
  • Business
  • US/UK advanced
  • Multicurrency
  • TAF alliance
  • PWD
  • SRCD
  • In development

61
Framework
1 .. 8
1 .. 8
  • ltxbrlgt
  • Container for all XBRL instances

ltaccountingEntriesgt
1
  • ltaccountingEntriesgt
  • Sub-container for XBRL GL

ltxbrlgt
ltdocumentInfogt Information about this particular
batch ltentityInformationgt Information related to
the company whose data is being
reported ltentryHeadergt Where operational details
go
62
READ and LeaPResources Events Accounts Documents
Links People
Events Orders, invoices, checks and others
Resources Inventory, supplies, services,
processes, fixed assets
Accounts Ledger, Customer, Bank and
others Local, consolidating, tax, counterbalance
Documents Numbers, dates, references,
descriptions
People Customers, Vendors, Employees, Other
Links Account to Account, Taxonomy to Taxonomy,
Account to Taxonomy Vendor to Inventory,
63
Modular Semantics Generic Building Blocks
Accounts
Documents
Resources
People and organizations
Entries
XBRL and XML Schema
64
Building Blocks
  • By agreeing on how these assemblies work
    together, information from transaction to final
    reports can be represented in the desired level
    of granularity

accountingEntries
entryHeader
entryDetail
65
XBRL GL Can Be Used For
  • XBRL GL aids
  • Data integration from disparate systems
  • Data Collection
  • Top Level Journaling
  • Data Validations
  • Process Management
  • Audit Trails
  • Lays down path for better environment
  • Software developers
  • Emerging XML security
  • Controls environment
  • Meets far more than the Trial Balance
  • Support Notes to the Financial Statement
  • Not just monetary, but amount/quantity and
    qualitative support

66
What is XBRL GL Good For?
  • XBRL GL aids
  • Data integration from disparate systems
  • Data Collection
  • Top Level Journaling
  • Data Validations
  • Process Management
  • Audit Trails
  • Lays down path for better environment
  • Software developers
  • Emerging XML security
  • Controls environment

67
What is XBRL GL Good For?
  • Data archival
  • Serving as a standard backup format so
    information can be drawn from any system in the
    audit supply chain and maintained in a format
    that will be useful without regard to what system
    the data was drawn from and what system the data
    might sometime be required to be used in.
  • Data migration
  • Providing a more efficient way to move data from
    one system to another, whether that movement is
    as simple as moving information into a
    spreadsheet for analysis and adjustment and
    then back into the system as appropriate, or as
    sophisticated as moving all of the content in one
    ERP system to another ERP system as part of the
    implementation of a new system.
  • Data consolidation
  • Bringing together the data from many disparate
    systems into one as part of the consolidation
    process.
  • Data drill-down
  • Whether using XBRL for financial reporting or a
    standardized XML schema of a proprietary nature
    for tax reporting, XBRL GL has been designed to
    provide a bridge to end reporting, facilitating
    drilling down from an end report to the
    underlying detail.
  • Seamless audit trail
  • Serving as the glue between any business
    documents and their summaries, facilitating
    vouching and tracing and providing traceability.

68
Two Dozen (Additional) Uses of XBRL GL
  • Exchange data with an internal or external
    auditor in (near) real-time
  • Receive adjustments back from bookkeepers,
    accountants and auditors
  • Exchange data with a bank in detail as part of a
    loan covenant
  • Exchange data with an external tax advisor for
    their ongoing analysis
  • Exchange data with an information trading partner
    (customer, vendor, landlord)
  • Move data into management dashboards for better
    oversight
  • Exchange detailed information for budgeting and
    forecast
  • Keep a standardized backup of data in an online
    (ASP) accounting system should all go wrong
  • Move data from a local accounting system to an
    online ASP
  • Move data from a centralized accounting system to
    a new accounting system when a division is rolled
    out from a company and begins a new company
  • Move data from a company being acquired into the
    acquirers system
  • Integrate the data from a company being acquired
    into an acquirers system for consolidation
    purposes without having to give up using the
    original data
  • Move operational data through services to do
    better logistics, check addresses and freight
    information, do credit checks, keep data cleaner
  • Move accounting/financial data for allocations,
    confirmations to speed up period end processing
  • Bring together data from throughout an
    organization to more quickly analyze for fraud
  • Use standardized data to compare
    intra-organizational information and better
    reconcile information for eliminations (such as
    the US Government trying to reconcile
    intra-agency budgets and financial management).
  • Communicating a corporate/government chart of
    accounts and authorized transaction listings
    (such as the US Governments USSGL, providing
    potential validation capabilities of actual
    versus allowable).
  • Move inventory information between primary and
    secondary systems, such as online merchant
    servers, eBay, etc.
  • Duplicating the setup of one implementation in
    one accounting product into another
    implementation. Providing the stream of data
    necessary for continuous monitoring and auditing
    functions.
  • Provide a standardized format for expressing all
    business events for archiving to external
    parties/DVD-ROM as a business black box.
  • Providing the underlying detail for any XML-based
    end business report.
  • Provide a standard export format from a data
    warehouse.
  • Provide a standard schema/format for anyone who
    uses spreadsheets for standard data entry.
  • Develop standards for repeating entries,
    expectations for purchases and communicate them
    in XBRL GL as a single standard down to divisions
    and departments where it can be imported into the
    systems.

69
Cross Industry Value
  • Internal and operational reporting
  • Data integration and software applications
    interoperability
  • Audit trail management
  • Automated generation and reconciliation of
    summarized reporting represented with one or more
    XBRL taxonomy or XML schema.

70
Example Need of Wholesale/Distribution
  • Represent multi-dimensional, many-to-many
    relationships
  • Between multi-location warehouses, locations,
    clients, vendors, inventory items etc.
  • In a non-proprietary, application-independent,
    format.

71
Integration Needs
  • Logistics
  • Outsourcing
  • Web integration (B2B, B2C, B2etc.)
  • PO/SO

72
SRCD The GL/FR Link
73
SRCD
  • Summary Reporting
  • The information necessary to link from more
    detailed XBRL GL instances to more summarized
    reporting, typically in FR instances, but also
    to other schema-based reporting.
  • Contextual Data
  • Primarily to provide new guidance in how to link
    to the information found in FR contexts
    (identifier/entity/segment, period, scenario) and
    units.
  • But also providing new, more powerful selection
    and filtering tools

74
The Link Today xbrlInfo
  • Pointers to element(s) in XML Schema
  • summaryReportingElement identifies the target
    element for the summarization, not just XBRL
  • Can associate with information in XBRL GL
    instance implicitly or explicitly
  • detailMatchingElement communicates which XBRL
    GL element contains the content that will be used
    for the summarization process
  • By default, amount
  • Provides some additional contextual guidance
  • xbrlInclude provides guidance on the point of
    time/duration nature of the fact

Time Sheet 100 hrs _at_ 10 1000
ltmeasurableQuantitygt
ltamountgt
75
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
76
Multi-GAAP Reporting
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
US GAAP
IFRS
US Tax
Management Reporting
77
SRCD Expanding on xbrlInfo
  • Unambiguous linking
  • Here (in the GL instance) is the exact content
    you would find in the associated summarized fact
    found in the FR instance.
  • Sophisticated selection and filtering
  • Here are some patterns and filters to guide
    queries that associate the GL data with the
    associated FR data (or help drive the
    summarization from GL to create an FR instance.

78
(No Transcript)
79
(No Transcript)
80
The FR target instance document, rendered
81
FR Target
GL Source
The target FR instance represents a Statement of
Activities (like an Income Statement), so the
value of xbrlInclude is set to period_change.
This has no direct impact on the target instance
itself, but it is useful information for
consuming applications.
82
FR Target
GL Source
gl-corsummaryReportingElement indicates the
Qname of the target Element in the FR instance
to which the specific line in the GL instance is
summarized to. The associated namespace and the
actual schema file would be noted in the open
ltxbrlgt tag in the namespace declarations and
would be discoverable by the application.
83
FR Target
GL Source
The summaryPrecisionDecimals structure provides
the value of precision and decimals for the
summarized value in the target FR element when
there is no certainty that all the items that
summarize to that element have the same values of
precision and decimals in the GL instance.
84
FR Target
GL Source
The summaryContext structure is used to hard
code values for the context associated with the
target FR fact, when they are not determined
programmatically from other elements of the GL
framework.
85
FR Target
GL Source
The summaryEntity structure holds information
about the organization whose information is being
reported, in this case, the identifier and the
scheme.
86
FR Target
GL Source
summaryPeriod can hold hard coded information
about the time period associated with the target
FR fact when the user chooses not to infer it
automatically from the many dates that XBRL GL
allows to be associate to transactions.
87
FR Target
GL Source
summaryScenario stores the hard coded value for
the target FR scenario, again when the user
chooses not to extract it from the elements of
XBRL GL that directly or indirectly provide the
same information.
88
FR Target
GL Source
Similarily, summaryUnit can be used to store
the hard coded value for the target FR unit.
89
ROUTERS
XBRL GL
Copier / Scanner / Fax
90
Ready Today 
  • XBRL GL is ready today, with readily available
    application support, to integrate disparate
    systems, support the flow of management
    information, and improve controls environments    

91
Built For Tomorrow
92
Assurance and XBRL GL
  • Facilitating interoperability and integration
  • Reduced manual (re)entry
  • Better controls
  • Better communication

93
Audit Evidence, Tests, Findings
Audit Documentation Framework
Standards-based input Standards-based
processes Standards-based output
94
Fully Integrated Audit Supply Chain
Audit Documentation Framework
95
Uses of the Global Ledger
  • Data Level Assurance
  • Continuous Monitoring, Control and Auditing
  • Real-time reporting
  • Process-oriented accounting
  • Probabilistic reporting
  • Integrated information supply chains
  • The end of Summarized Reporting as we know it
  • Quantum Business Reporting

96
  • Routers
  • Route internet/intranet traffic
  • Include new capabilities including
  • Encryption/decryption
  • Rules
  • Can convert information to XML/XBRL using
    external software
  • Compression

97
Going Real-time and Discrete
Business Discussion
Business Communication
Business Action
Business Accounting
Business Decision
Business Recording
Business Analysis/ Estimate
FIN 48 Fair Market
SOx 409, ASX 3
IRC 6011
FD
98
Discreteness Necessary?
  • Real Time Pressures
  • Real time reporting is different. Reporting
    systems without period-end closes are like a
    clock without hands we are missing natural
    stopping points, familiar periods to work on
    things, acceptable points to stop and take stock.

Going quantum ...
99
Security
  • XML Signature
  • XML Encryption
  • Web Services security
  • Selective unfolding
  • Turning text into databases

100
Call to Action
  • Review and feedback
  • PWD
  • Helpful materials
  • Webcasts
  • Informational documents
  • Join us
  • Influence others (its all about the benefits)

101
Leveraging XML Solutions
  • Middleware
  • Mappers
  • Modellers
  • And more!

102
XBRL GL Implemented
103
Final Points - Misconceptions corrected
  • The Global Ledger
  • is NOT a standard chart of accounts
  • is NOT for layout and presentation
  • does NOT only contain data summarized and posted
    to the General Ledger
  • makes sense even without XML
  • The Global Ledger is
  • a standard, platform-independent file containing
    financial transactions and other detailed and
    summarized business facts as an import/export
    format.
  • These files can be used for auditing, data
    transfer, data archival and many other purposes.
  • GLOBAL LEDGER, not (just) General Ledger
  • different things, different places

104
NNTED2!
  • What does this all mean?
  • No need to enter data twice! (NNTED2)
  • Do you retype information that came from one
    computer into another computer?
  • You can map it instead with
  • Greater control
  • Greater efficiency
  • Greater reuse
  • Are you mapping to some vendors requirement?
  • Their needs and your need of them, will change
  • A standard is a standard!

105
 Resources     
  • XBRL
  • http//www.xbrl.org
  • XBRL Global Ledger Framework
  • http//www.xbrl.org/GLTaxonomy
  • GaLaPaGoS
  • httpgl.iphix.net
  • Strategic Finance Magazine
  • Gianluca Garbellotto's XBRL columns
  • SEC website
  • http//www.sec.gov/spotlight/xbrl.htm

106
(No Transcript)
107
(No Transcript)
108
(No Transcript)
109
(No Transcript)
110
(No Transcript)
111
Lend Your Support
Call to Action
Investigate Influence Involvement Integrate In
novate
  • Investigate and prioritize
  • Join
  • Support
  • Drive
  • Adopt/embrace
  • Encourage others
  • Make it happen

112
Questions?
  • Does this make sense?
  • Are these benefits worth fighting for?
  • Can you make a difference?

113
More Questions?
lt/presentationgt
  • Eric E. Cohen
  • PricewaterhouseCoopers
  • eric.e.cohen_at_us.pwc.com
  • (585) 271-4070
  • Find out more
  • www.xbrl.org
  • www.pwc.com/xbrl

114
XBRL GL Philosophy
  • Represent what is found in the databases of
    accounting and operational systems. Stay away
    from calculated fields.
  • Represent both the exact content (audit) of those
    databases while allowing for normalization of key
    fields (data transfer).
  • Allow both modular and monolithic approaches to
    data representation
  • Use a generic and reusable approach where
    appropriate
  • Specialize only where absolutely needed
  • The originating document is key to the audit
  • The primary amount is key to the audit
  • XBRL GL should not be used for transactions
  • XBRL GL should leverage the power of XBRL but be
    familiar to non-XBRL experts

115
How XML Compares with Other Reusable Formats
Note PDF is a very popular document exchange
format, but is primarily designed for human, and
not computer, consumption. Likewise, TIF, GIF,
JPG, BMP and other binary graphics formats.
Note 2 UNICODE is an update to ASCII more
useful in the international context.
weakness
strength
workaround
Write a Comment
User Comments (0)
About PowerShow.com