1 / 67

XBRL: The Extensible Business Reporting Language

XBRL: The Extensible Business Reporting Language. Rhode Island Society of CPA ’ s 13-May-2002. Dr. Saeed Roohani Chairman, Accounting Department Bryant College Neal J. Hannon XBRL International Education Work Group Chair XBRL Educational Resource Center at Bryant College

dorian-phelps
Download Presentation

XBRL: The Extensible Business Reporting Language

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. XBRL: The Extensible Business Reporting Language Rhode Island Society of CPA’s 13-May-2002 Dr. Saeed Roohani Chairman, Accounting Department Bryant College Neal J. Hannon XBRL International Education Work Group Chair XBRL Educational Resource Center at Bryant College sroohani@bryant.edunhannon@bryant.edu

  2. Agenda • XBRL Update – who talks about it • XML  XBRL • XBRL General Ledger • Government XBRL Reporting • The Future of Digital Reporting

  3. XBRL UPDATE • FDIC to run pilot program for Call Sheets • Proof of concept is complete • RFQ in second quarter of 2002 • Pilot program for 2003 • APRA: XBRL in use for all required filings in banking and insurance industry in Australia • Microsoft and Reuters publish in XBRL

  4. XBRL Update • The Bank of America/ Moody’s Connection • Dressner and Deutsche Bank • GE Financial (consolidations) • Inland Revenue • 260 people attended Berlin, Germany conference • Over 50 Japanese companies members of XBRL-Japan • Total consortium membership projected to exceed 200 by 2003

  5. XBRL – The Organization • History • Founded by the AICPA in 1998 (13) • Spin Out into International Organization in 2002 (>140) • Organizational Matters • Structure of XBRL • Liaison work • Next International Meeting in Toronto June 17 – 21, 2002 • Jurisdictional Growth • Active: Australia, Canada, Germany, IASB, Japan, UK, US, Singapore • Development: Belgium, Hong Kong, India, Ireland, Netherlands, New Zealand, South Africa, Spain, Sweden, Taiwan

  6. Board of Directors (Trustees) 2nd VC …Hong Kong… Netherlands Spain Sitting Members Provisional Members Finance/Audit Committee Nominating Committee Grants Executive Committee International Steering Committee Chair At Large ISC Members 4th 3rd 1st 2nd Web site Committee XBRL Management CEO Supply Chain Participants Jurisdictions International Working Groups 1st Vice Chair Preparer, Private Sector Specification Accounting * Standing Developers AU CA Intermediaries IASB* DE Liaison Software & Services SG JP Mktg & Comm Investors/Creditors UK US Education Analyst Research Regulators Academic General Ledger Public Sector Preparers

  7. XBRL InternationalGovernance & Operational Structure Board of Directors (Trustees) At Large ISC Members OPEN OPEN Coffin Hamscher 2nd VC – Schnitzer Hong Kong Netherlands Spain Members Sitting Members Provisional Finance/Audit Committee Chair - Ramin Nominating Committee Chair - Cuthbertson Grants - Watson Executive Committee International Steering Committee Chair - Hamscher Web site Committee Chair - Watson XBRL Management CEO (Acting) – Louis Matherne Supply Chain Participants Jurisdictions International Working Groups 1st Vice Chair – Kurt Ramin Preparer, Private Sector - OPEN Specification - Hampton Accounting - Willis * Standing AU -Hardidge Developers - OPEN CA - Cuthbertson Intermediaries - Watson DE - Fuhrmann Liaison – Coffin (Acting) Software & Services - Blake IASB* - Ramin JP - Watanabe Mktg & Comm. - Colgren SG - Tang Investors/Creditors - Flickinger Education - Hannon UK - Rodgers Analyst - Schnitzer US - Matherne Research - Srivastava Regulators - Walenga Academic - OPEN GL - Cohen Public Sector Preparers - OPEN

  8. XBRL – Taxonomies • IASB Commercial & Industrial • IASB Commercial & Industrial for AU, NZ, SG, UK, HK, • Japan Statutory Accounts • Germany Statutory Accounts • International General Ledger • U.S. Commercial & Industrial • U.S. Investment Management • U.S. Federal Government General Ledger (KPMG developed) • U.S. Non-Profit Form 990 • Other specific sector based taxonomies under development.

  9. XBRL Support “I would like to see you develop valuation models that result in consistent, comparable and fair values of assets and liabilities. I would like to see you hone specific, but plain English definitions for the types of information you believe should be included in public disclosure. I would like to see you take your XBRL project a step further, providing account classifications for companies in common industries. In short, I challenge you to turn all of this data into meaningful information for investors.” - Arthur Levitt, Chairman, U.S. Securities & Exchange Commission October 24, 2000, at the Fall Council of the AICPA (Las Vegas, Nevada)

  10. Microsoft CFO on XBRL • "Through Internet delivery, XBRL will also provide analysts and investors with extensible financial data to make informed decisions about the company. We see XBRL as not only the future standard for publishing, delivery and use of financial information over the Web, but also as a logical business choice." John Connors, Chief Financial Officer, Microsoft

  11. The Capital Markets • “NASDAQ joins shoulder to shoulder in the effort of the XBRL Consortium to adopt this new, freely available technology because it feels that improving the distribution and analysis of corporate results, especially for the 10,000 companies not covered by Wall Street analysts will broaden the market for NASDAQ’s own trading services” Michael Sanderson, CEO NASDAQ Europe

  12. Transparency in Financial Reporting • “Reuters’ reputation stands on its ability to communicate and the extensible business reporting language standard it has employed this week to publish accounts online is amongst the most significant of developments in promoting transparency in financial information” Accountancy Age, 1 November 2001

  13. Message to Congress on Post Enron Environment • “One large scale and potentially revolutionary private sector initiative that already is underway is a collaboration of growing companies, accounting firms and the AICPA to develop a common “tagging” system for various financial accounts, which goes under the acronym “XBRL”. … I would urge the SEC (and if necessary, urge the Committee to urge the SEC) to encourage this project… One possibility: require EDGAR submissions to be in XBRL by a specific date.” • Bob Litan, Brookings Institution & Bear Stearns testimony to U.S. Senate Banking Committee on post-Enron, March 14, 2002

  14. Implementations/Vendors • ACCPAC • Caseware • Creative Solutions • Enumerate • FRSolutions • MSFT/Great Plains/Navision • Fujitsu • Hitachi • Hyperion • KPMG Columbus • Moody’s • NewTec • SAP • Semansys • Software AG • UBMatrix • APRA • FDIC • UK Inland Revenue • GRE – Credit & RM • General Electric • Morgan Stanley • Reuters • Microsoft • Edgar-OnLine • Moody’s • Edgarscan

  15. XML and XBRL • XBRL is: • NOT a new accounting standards but enhances the distribution and usability of existing financial statement information

  16. eXtensible Markup Language (XML) • ……is a meta markup language the World Wide Web Consortium (W3C) considers a universal standard for describing both structured data and the behavior of applications that process the language.

  17. Windows Unix Macintosh Mainframe Linux Example: <DATE>July 26, 1998</DATE> Describes the information, not the presentation Format neutral XML is Platform Independent Self-Describing

  18. XML Simplified XML Context DATA Net income: Company Currency Period Rounding Roll-up 1,000 XBRL

  19. XML Markup: What Does it Look Like? Michael M. Miller 8080 Hill Circle Lincoln, MA 01738 +1 (617) 515-1424 Birthdate: 19 October 58 <name>Michael M. Miller</name> <address> <street>8080 Hill Circle</street> <city>Lincoln</city> <state>Massachusetts</state> <country>United States of America</country> <postcode>01738</postcode> </address> <telephone>6175151424</telephone> <birthdate>19/10/1958</birthdate> Ordinary information Metadata: Information about information

  20. Industry Taxonomy Development <cash> Financial (XBRL) Chemical Industry <SYMBOL> Human Resources (HRML) <resume> Music Industry <RECORD-LABEL> Aerospace <PROGRAM> Astronomy <PLANET>

  21. Who’s Building Taxonomies?

  22. Structured Content allowsData reuse, comparability, aggregation Regulatory filings Tax Return Explanatory text Document (Data with Metadata) Bank filings Accounting system Other information Website sources Printed Financials Schemas (Standard Definitions)

  23. Structured Content allowsData reuse, comparability, aggregation Regulatory filings Explanatory text Tax Return XBRL Instance Accounting system Bank filings Website Other information sources Printed Financials XBRL Taxonomies Investor Analytics

  24. XML is Expandable • Whereas • HTML has a fixed set of tags (<H1>, <B>, <PRE>) aimed at data presentation • XML lets you create your own tags • <sugary-substance> • <Shakespearean-character> • <cash-equivalent> • The key focus is on content, not presentation

  25. The XML Puzzle XML Document Industry Specific Vocabularies Company Specific Vocabulary Core Schema Transformation Tools

  26. What is XBRL? • XBRL is a freely available electronic language for financial reporting • XML-Standards based method to : • Prepare, • Reliably Extract, • Exchange on a system to system basis • Publish company financial data • Potential for extensive use in government accounting

  27. XBRL Builds on XML and SGML Industry Developed, Supported XBRL 2001 XML and XML enabling technologies X-Link, X-Schema W3C Supported 1998 ISO Standard SGML Standard Generalized Markup Language 1986

  28. Innovation Technology Evolution to Web Services Program the Web Web Services Browse the Web Web Pages Text Files Automation FTP, E-Mail,Gopher Presentation Connectivity TCP/IP HTML XML

  29. How XBRL Solves Problems Improves the way companies -- and applications -- share business reporting information 5. XBRL data is used in the government application and/or other comparable programs 3. XBRL information flows freely across the Internet or VPN, LAN and WAN 1. Client Specific Data Financial data; multiple systems FDIC Call Report XML/XBRL translator XML/XBRL translator Common XBRL Vocabulary Client COA to FDIC Taxonomy FDIC Taxonomy 2. Application data is selected, cleaned and tagged in XBRL 4. XBRL-tagged data is mapped into applications specific data such the FDIC’s Call Reports

  30. What software ‘sees’ is the differentiator and drives benefits

  31. Benefits • XBRL is: • NOT a new accounting standards but enhances the distribution and usability of existing financial statement information • Enabler and an extension for native-XML database functionality* for all financial statement information • *Can be stored as a form or a separate financial fact

  32. Raw XBRL <numericContext id="rg.cy00.jpy" cwa="false" precision="4"> <entity> <identifier scheme=“Ticker">rg</identifier> </entity> <period> <startDate>2000-01-01</startDate> <endDate>2000-12-31</endDate> </period> <unit> <measure>iso4217:jpy</measure> </unit> </numericContext> Rock Gravel Corp. Period from 1 Jan 2000 to 31 Dec 2000, In Yen Precise to 4 digits

  33. XBRL as a Translator • Accounting is fragmented • Hundreds of accounting software packages • Many correct ways to interpret GAAP and Governmental accounting • XBRL as common denominator • Each set of financial data can conform to a single taxonomy.

  34. Tags are defined by industry consortiums Each industry’s standard tags are commonly referred to as a taxonomy Who defines the tags?

  35. XBRL Taxonomies in 2002 • Best practices • e.g. ast.amz.goodwill = Amortization of Goodwill • e.g. Assets have “current” & “non current” children • e.g. Reusable common components taxonomy • Focused development efforts • IAS Taxonomy: Core financials, Core + Notes • US GAAP C&I Taxonomy • UK GAAP C&I Taxonomy • Inland Revenue “Computation” Taxonomy • FDIC Taxonomy (US) • Canadian GAAP, others.

  36. XBRL for General Ledger Developing an international core for reporting general ledger transactions

  37. XBRL.org Specifications XBRL for FinancialStatements XBRL for General Ledger XBRL for EDGAR Filings Business Operations Internal Financial Reporting External Financial Reporting Investment and Lending Analysis Processes XBRL for Business Event Reporting XBRL for Audit Schedules XBRL for Tax Filings Companies Financial Publishers and Data Aggregators Investors Participants Trading Partners Management Accountants Auditors Regulators Software Vendors

  38. XBRL- General Ledger Goal • A cross-jurisdictional, cross-industry fact-gatherer for representing the information found in a “General Ledger”, internationally. Bringing “standardization” to

  39. Requirements for XBRL GL A Standard Format for: • 3rd party software to create journal entries to pull into client GL system • To move unposted and posted GL information from divisions to consolidating systems, budgeting ,forecasting, reporting tools, and back • To upload general ledger information, payables, receivable files and open balances for system migration or interfacing with Internet ASP

  40. Requirements for XBRL GL Standard Format to move information • From client's systems to CPA • From one CPA system (eg, write-up) to another (eg, tax) in an international context. • Open receivables, open payables, inventory balances, and other asset-based measures for sharing with banks • Detail drill-down for performance measurement reporting items Standard Format to Represent

  41. Requirements for XBRL GL • Extensible for any type of mandatory audit trail • Extensible for meeting any "sub-ledger" need • Designed as XBRL spec-compliant but for easy translation to other uses • Cannot assume that XBRL period, entity, unit and other context (numeric, nonnumeric) will automatically be there.

  42. Tax Regulators Investors Creditors Lenders Website Aggregators One way One way XBRL BUSINESS REPORTING XBRL GL Ledger Taxonomy BUSINESS ERP G/L Packages CRM Transaction Creation 2-way 2-way (e-)Business x.12, EDIFACT, XML INITIATIVES Suppliers Customers • Orders • A/P • Delivery • Orders • A/R • Delivery Accounting: Bridging eBusiness and Financial Reporting Detail Accounting Recognition

  43. XBRL-GL: From Business Transactions to Financial Statements XBRL For Financial Statements Recommended status 3/15/02 XBRL GL Core Unique to each organization XBRL GL Custom Business Transactions Not XBRL; function of other consortiums

  44. “General Ledger” Holds MoreValuable Information

  45. Overview of the Structure of the GL Taxonomy Three Primary Levels accountingEntries entryHeader entryDetail GL Journal Batches Target and Source Application Creator Organization GL Journal Header Journal Identifiers Entered by Entry Date Posting Date Hash Totals GL Journal Detail Lines Detail Identifiers Line Number Amount Account XBRL Reference

  46. XBRL-GL • Files and more information can be found at: www.xbrl.org/gl/gl.htm

  47. Government XBRL Applications

  48. XBRL – US Federal Agencies • Joint Financial Management Improvement Program (JFMIP) 2001 report • JFMIP includes Department of Treasury, General Accounting Office, Office of Management and Budget, and the Office of Personnel Management. • “Core Financial System Requirements” states: ”To meet JFMIP interoperability requirements, the Core Financial system should: support emerging XML-based specifications for the exchange of financial data such as Extensible Business Reporting Language (XBRL).” • http://www.jfmip.gov/jfmip/.

More Related