1 / 47

XBRL Discussion Material

XBRL Discussion Material. A summary of discussions to date related to the components of a taxonomy for SEC EDGAR filing purposes. SEC XBRL Filing. An SEC XBRL filing is composed of company specific taxonomy files and an instance file. Taxonomy.

tamika
Download Presentation

XBRL Discussion Material

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 Discussion Material A summary of discussions to date related to the components of a taxonomy for SEC EDGAR filing purposes.

  2. SEC XBRL Filing • An SEC XBRL filing is composed of company specific taxonomy files and an instance file.

  3. Taxonomy • A taxonomy is a collection of schema and linkbase files. A taxonomy can be as complex as the US-GAAP taxonomy (15,000 elements), or as simple as a company-specific taxonomy (100+ elements) submitted to the SEC as part of a filing.

  4. Taxonomy: Schema • A schema defines elements and roles and may “call in” external schema and linkbase files which may then be referenced. • An example of an import command in a schema file, importing the US-GAAP taxonomy: <import namespace="http://xbrl.us/us-gaap/2009-01-31" schemaLocation="http://taxonomies.xbrl.us/us-gaap/2009/elts/us-gaap-2009-01-31.xsd" />

  5. Taxonomy: Element • An element is a fact or “code” that contains some meaning. Its definition in a schema will include an identifying name, type (i.e. monetary, shares, string, etc), period type (instant, duration), balance (debit, credit) and whether or not is an abstract value (a header).

  6. Taxonomy: Element • An example of an element definition in a schema file: <element name="IncreaseDecreaseInUnearnedRevenue" id="msft_IncreaseDecreaseInUnearnedRevenue" type="xbrli:monetaryItemType" abstract="false" xbrli:periodType="duration" xbrli:balance="debit" nillable="true" substitutionGroup="xbrli:item" />

  7. What defines an element? Period Type Balance Instant, Duration, Blank Debit, Credit, Blank Element Type Is Abstract? Monetary, Shares, Decimals, etc Yes/No

  8. Mixing element types • Instant and duration period type elements do not mix within calculation relationships (like oil and water!) • Abstract elements are just text strings and do not have a balance attribute and are generally considered to have durational period types

  9. Taxonomy: Element • XBRL US is a non-profit organization which has built a taxonomy of 15,000 elements relating to line items or facts used by companies in US-GAAP compliant financial reports. These are the “codes” the SEC wishes filers to associate values with for easy identification.

  10. Taxonomy: Role • A role is a grouping of elements for use in a Calculation, Presentation, or Definition linkbase. For example, we would create the role “Balance Sheet” and have it appear in both the Calculation and Presentation linkbases which would contain the display and “roll up” relationships for this group respectively.

  11. Taxonomy: Role • An example of a role defined in a schema file: <link:roleType roleURI="http://www.microsoft.com/taxonomy/role/StatementOfFinancialPositionClassified" id="IMetrix_StatementOfFinancialPositionClassified"> <link:definition>104 - Statement - BALANCE SHEETS</link:definition> <link:usedOn>link:calculationLink</link:usedOn> <link:usedOn>link:presentationLink</link:usedOn> <link:usedOn>link:definitionLink</link:usedOn> </link:roleType>

  12. Taxonomy: Linkbase • A linkbase is a file containing specific information in relation to the schema. There are five kinds of linkbases, each serving a different purpose. These include Presentation, Calculation, Label, Definition, and Reference.

  13. Taxonomy: Linkbase • Presentation Linkbase: describes how elements should be displayed on screen, including both ordering and nesting. A schema may contain 100 elements, but if only 50 are included in this linkbase only those 50 will appear when rendered with a viewer.

  14. Taxonomy: Linkbase • Calculation Linkbase: describes how elements are “rolled up” or added together. This linkbase makes it possible for XBRL validators to compare tagged facts to their expected calculations, and provide errors or warnings where appropriate.

  15. Taxonomy: Linkbase • Label Linkbase: contains a “database” of labels that can be referenced when elements are displayed. An element can have multiple label types associated with it. Labels in this linkbase can override labels defined in linkbases of imported schemas.

  16. Taxonomy: Linkbase • Definition Linkbase: contains information related to dimensional tables. Dimensional tables are those that require more than just a date and element to uniquely identify a fact. An equity table is an example of a dimension table as it typically contains column headers that provide further detail in relation to a number (i.e. Retained Earnings).

  17. Taxonomy: Linkbase • Reference Linkbase: contains references to official accounting documentation that help bring meaning to an element. For example, the element “Cash” has an official meaning in relation to US-GAAP; this linkbase would explain this meaning. This linkbase is not typically submitted in conjunction with an EDGAR XBRL filing.

  18. US-GAAP Taxonomy • Contains thousands of elements for face financial statements (Balance Sheet, Income Statement, etc) and disclosures (financial notes). • Includes linkbases that describe default presentation and calculation relationships and collections of default labels.

  19. IFRS Taxonomy • The IFRS (International Financial Reporting Standards) taxonomy is similar in purpose to the US-GAAP taxonomy but contains only elements related to the international standard. It is much smaller than the US-GAAP taxonomy and simpler in structure as well. Canadian companies will start using IFRS in January, 2011.

  20. Document and Entity (DEI) Taxonomy • Contains a small collection of elements relating to the filing and/or company. For example, company name, cik, form type, accelerated filing status, etc are all elements that appear in this taxonomy. • The SEC requires that values for a number of these elements be part of every EDGAR XBRL filing.

  21. Company-Specific Taxonomy • Contains a customized schema and linkbase files that meet the reporting requirements of a given company. • Will reference an external taxonomy (i.e. US-GAAP) and where appropriate, include elements defined there in its respective linkbase files.

  22. Company-Specific Taxonomy • A company will place any specialized custom elements in its schema file and describe how facts in an instance file should be presented and calculated in its respective Presentation and Calculation linkbases. Relationships defined in these linkbases will override those available in imported taxonomies.

  23. Company-Specific Taxonomy • A company will create a collection of custom labels and include these in the Label linkbase. • The company-specific taxonomy files are submitted to EDGAR as exhibits in a filing template, along with official HTML documents.

  24. Instance File • Contains facts (numbers) tagged with elements, units, and contexts. • Every tagged fact references a unit, context, and decimals attribute. An example is: <us-gaap:CashAndCashEquivalentsAtCarryingValue contextRef="eol_PE8528----1010-Q0005_STD_0_20081231_0" unitRef="iso4217_USD" decimals="-6">8346000000</us-gaap:CashAndCashEquivalentsAtCarryingValue>

  25. Precision / Decimals • Tagged numbers must be complete in the instance file (for example, one million must be 1000000). However, through setting the decimals attribute for the tagged item in the instance file you can request it be displayed in tens, thousands, etc. A decimal value of -3 means knock off three zeros.

  26. Contexts • Contexts defined in the instance file describe date and dimension information related to a tagged fact through the contextRef attribute. • A context can only relate to an instant (point in time) or duration (a period), not both. • A duration context cannot be applied to a value tagged using an instant type element, and vice-versa.

  27. Units • Units are defined in the instance file (i.e. US Dollars, Shares, US Dollars per Share, etc). • A unit is applied to each tagged fact through the unitRef attribute. A share type unit cannot be applied to a monetary type element and vice versa.

  28. REF DEF LAB PRE CAL The company specific taxonomy files (may remain unchanged from period to period). The term “taxonomy” does not typically include the instance file. US-GAAP Instance file containing a collection of tagged facts; contains the actual numbers being reported. Generated for each report. XML Schema Import DEI Schema file containing links to linkbases, imported schemas, a list of roles, and custom elements. The GLUE that holds an XBRL taxonomy together. IFRS XSD Official taxonomies located on the web which are loaded into a company taxonomy for potential reference. Each of these taxonomies typically has its own set of linkbase files, which are overridden by the ones in the company specific taxonomy. Link REF DEF LAB PRE CAL Contains links to accounting regulations, bringing official meaning to an element. Not part of a company specific taxonomy for EDGAR filing purposes. Describes dimension related data for tables requiring additional column headers (i.e. equity table) Contains a database of custom element labels which overwrite imported defaults. Describes how elements should be displayed in relation to ordering and nesting. Elements will only be displayed if they are in this linkbase. Describes how elements should be “rolled up” or added when comparing calculated values to reported values. The company specific XBRL files to be submitted as exhibits in an EDGAR template to meet the EDGAR XBRL requirements.

  29. Parenthetical Data • Some financial tables contain data in label values that the SEC requires be tagged using specific XBRL elements (i.e. common stock authorized). • “Parenthetical” roles are created in a schema that contain these elements. For example, a typical XBRL filing would contain Balance Sheet and Balance Sheet (Parenthetical) roles.

  30. Null Values • Tagging null values will often result in these values not displaying in most viewers. This means that some rows tagged and submitted in instance files may not show up when viewed in the SEC’s XBRL viewer. Using zeros “0” instead of null values may avoid this issue.

  31. Instants and Durations • Each element is coded as either an instant or a duration in a schema file. Each context is either an instant or duration. These cannot be mixed together in the calculation linkbase. • A balance sheet contains only instant type elements while the income statement, cash flow statement, and equity statements predominantly contain duration type elements.

  32. Instants and Durations • Text blocks for containing HTML code for notes are duration type elements representing the period of the report.

  33. Debits and Credits • An element is defined as either a debit or credit. While accounting oriented, the debit/credit value of a custom element can generally be determined by considering elements that appear next to or close to it in the statement in question (i.e. assets vs. liabilities, revenue vs. expenses).

  34. Debits and Credits • The debit or credit value is important when XBRL is using the Calculation linkbase to calculate totals. If a debit and a credit are being added up to equal a credit, the debit value must be given a weight attribute of “-1”. Likewise, if these two elements are being added up to equal a debit, the credit value must be given a “-1” weight. • The weight is defined in conjunction with the relationship of these elements within the Calculation linkbase.

  35. Negating Labels • A special “negating” label can be defined in the Label linkbase and applied to an element in the Presentation linkbase. This will flip the sign of the value when it is displayed in an XBRL viewer. • Negating labels are needed – particularly in the cash flow statement – to properly display values that are internally represented as the opposite sign.

  36. Negated Labels XBRL elements have a “balance” attribute which, if defined, can be set to either credit or debit. The balance of an element follows accounting rules. Neither is inherently negative or positive – it depends on their respective relationships in a given scenario. Negated labels allow you to flip the sign of an element when viewed to match the presentation intended while avoiding internal XBRL inconsistency errors. • Credit • Credit • Credit • Debit (-1) • Credit • Debit • Debit • Debit • Credit (-1) • Debit • Undefined • Debit • Debit • Credit • Debit The weight attribute, set within the calculation linkbase

  37. Negated Labels • Revenues (credit) • Oil and Gas Revenue (credit) • Professional Services Revenue (credit) • Cost of Goods Sold (debit) • Credit • Credit • Credit • Debit (-1)

  38. Negated Labels • Revenues $300 • Oil and Gas $200 • Consulting $200 • COGS $100 • Revenues $300 • Oil and Gas $200 • Consulting $200 • COGS $(100) Works fine! Inconsistency error! Tag $100 and configure a negated label for COGS

  39. SEC Filing Requirements • All face financial statements (balance sheet, income statement, cash flow statement, and equity statement) must be coded on a line item basis where notes can be tagged as block text (chunks of HTML code). • The bulk of Newsfile domestic (i.e. 10-Q filers) clients must begin filing in XBRL starting August, 2011.

  40. SEC Filing Requirements • The bulk of Newsfile foreign issuer clients will need to file XBRL with their 20-F or 40-F starting in spring of 2012. • After August 2012, the bulk of Newsfile clients will need to tag notes on a line item basis, significantly increasing the time and cost related to preparing an XBRL filing.

  41. Thoughts • How do we best configure our software solution to handle all of the XBRL requirements in a simple manner? • How well does our software solution work in relation to interpreting and producing taxonomy and instance files?

  42. Next Steps • Construct a simple taxonomy using the taxonomy builder. • Begin working with the tagging software.

  43. Working with the Taxonomy Builder • The following slides provide hits and tips relating to the structure of the face financials and the use of debit and credit items.

  44. Balance Sheet Instant Assets Debit Liabilities and Stockholder’s Equity Liabilities Assets = Liabilities + Stockholder’s Equity (what you have is what you own and what you owe others) Credit Stockholder’s Equity Credit

  45. Income Statement Duration Revenue Credit Cost of Revenue / Cost of Goods Sold (COGS) Watch out for sign reversals in line items! Debit Gross Profit Credit Operating Expenses Gross Profit = Revenue – Cost of Revenue Net Income = Gross Profit - Expenses Debit Nonoperating Expenses Debit Net Income Credit

  46. Watch out for sign reversals in line items! Cash Flow Statement Duration Cash Flows from Operating Activities Some line items may be duplicated from income statement Adjustments to Noncash Items Incoming Cash Flow (gain / revenue) = Credit Outgoing Cash Flow (expense) = Debit Unique line items beginning with “IncreaseDecrease” Increase / Decrease in Operating Assets and Liabilities Operating Asset = Credit Operating Liability = Debit All Credits should have negating label applied Cash Flows from Investing Activities Outgoing Cash Flow = Credit Incoming Cash Flow = Debit Cash Flows from Financing Activities Outgoing Cash Flow = Credit Incoming Cash Flow = Debit

  47. Balance rows are instant type elements (StockhodersEquity)! Stockholder’s Equity Duration Balance (Beginning of Period) Increase in Equity = Credit Decrease in Equity = Debit Repeat section for each Period Issuance of Stock Exercise of Stock Options Net Income Dividends Balance (End of Period) Only create a single instance of each element Create a detailed duration custom tag to capture share issue specifics No need to create “Total” dimension

More Related