1 / 26

XBRL SEC Filer Experience

XBRL SEC Filer Experience. October 6, 2010 Eric Evans VP, Business Development EDGAR Online, Inc. Agenda. Planning for XBRL reporting Best Practices Avoiding common errors Results to Date from first XBRL filings Resources Available. Planning – Lessons Learned Tier 1 & 2 Filers.

aram
Download Presentation

XBRL SEC Filer Experience

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 SEC Filer Experience October 6, 2010 Eric Evans VP, Business Development EDGAR Online, Inc.

  2. Agenda • Planning for XBRL reporting • Best Practices • Avoiding common errors • Results to Date from first XBRL filings • Resources Available

  3. Planning – Lessons Learned Tier 1 & 2 Filers

  4. Planning - Stakeholders involved External reporting – education and build in more time for review! Legal Counsel - (Internal or External) Audit committee - may need to alter meeting dates down the road Auditors – (Internal or External) - get them involved earlier if needed Investor relations – posting of XBRL on web site Information Technology – installing any software (self tagging) Special project team Consultants Others - Educate senior staff on timing and not to focus on SEC rendering

  5. BOTH Support – hours, what form Training, FAQ’s, Webinars Does block tagging Does detailed tagging Handling Edits/Changes Provides rendering preview Has a repeatable process Security policies Maintains user groups Provides validation Taxonomy handling or expertise Considerations when choosing self tagging tool or outsourcing • In-house/Software tool only • Speed of taxonomy loading • Web based, ASP, PC-based? • File size if PC-based • Handling changes to taxonomy • Software updates • Processing times • Is Support time extra ($$) • Outsource/Service only • Turnaround times • Quality Control levels • SAS70 certified • Level of mistakes or errors • Provides alternative tag options • Version control between EDGAR HTML & XBRL process

  6. Best Practices for SEC Filers – Start Early!! • Prepare Primary Financial Statement s and Block Tagged Notes at least 1-2 quarters ahead of your mandated timeframe even if they are not formally filed with the SEC #1 – On-boarding: Initial Template set up – take as filed 10-Q #2 – Dry Run XBRL: test timing & review with concurrent EDGAR filing #3 – Repeat above for 10-K if desired (some issuers have opted to do as well) • Detailed footnotes: Examine the structure and presentation of your company’s financial disclosure Companies are starting to decrease narrative and create data tables • Focus on XBRL data creation and NOT on rendering issues, including the SEC’s site. • Fully review and don’t submit partial reviews (different from EDGAR process) • Iterative changes don’t save time = more rounds • Data vs. Print world = not EDGR, not typeset, XBRL requires more time for changes

  7. Extensions - where to extend or not extend? SEC Staff Feedback published in May’09: When choosing between two US-GAAP Standard Tags (narrow vs. broad), narrow is preferred When choosing between an existing Standard and Custom/Extension Tag, every effort should be made to utilize existing US GAAP tag found in taxonomy Tags may cross industry classifications Clients could review their tags against peer tags for comparison Best Practices for SEC Filers – cont’d

  8. Best Practice - Taxonomy ReviewPeer Tag Comparison Report

  9. Best Practices - Instance document creation • Focus on the mapping and taxonomy extension - Element selection documentation and a well crafted custom company taxonomy will greatly simplify the XBRL document creation process • Stick to the workflow - Jumping ahead often results in dead ends and rework. Avoid the idea of building the company taxonomy on the fly • Create new relationship groups for your company financial statements, each disclosure, and parentheticals – this will provide a taxonomy that is easier to work with and validate • Use existing elements from the XBRL US GAAP Taxonomies if it represents the appropriate financial concept regardless of its location • Create company “standard labels” for all elements – use terse labels where needed for repeating captions. Labels should correspond to the filer’s “print” report • Validate early and often – errors accumulate and are hard to fix

  10. Best Practice - Key Quality Assurance Steps • Mapping Document Thorough documentation and review of element selection and creation with intended associations • Tagging Report or a Reviewer’s Guide Review ‘tagging report’ to assure proper financial statement fact to element association with correct attributes. • Rendering Use SEC Submission Previewer: https://datapreview.sec.gov/previewer/ • Test Submission with SEC The final arbiter for validation

  11. Avoiding Common Errors • Most common errors identified in submitted filings: • Negative value when should be positive • Value required to be reported when another value is reported • Value reported when it should be zero • Value should be zero if another value is not reported * Stats provided by XBRL.US

  12. Avoiding Common Errors • 64% errors were incorrect negatives • Example: Plastic materials and chemical company reported “DividendsCommonStockCash” as negative • Example: Insurance company reported “InterestPaid” as negative and “PaymentsForOriginationOfMortgageLoansHeldForSale” as negative * Stats & Examples provided by XBRL.US

  13. Avoiding Common Errors • Pitfalls to avoid in element selection and extension creation: • New element created, but a standard element appears appropriate OR • Standard element used, but a new element should have been created • New elements created by filers should not include period-specific information in their name. • New monetary elements created for amounts appearing on the balance sheet or income statement must have a “debit” or “credit” balance attribute. • All extensions must have a definition

  14. Avoiding Common Errors – Sample Validation Problems • Invalid ASCII characters – ‘smart quotes’ and other traps • Incorrect file names • Mixed decimal attributes in a group • Same standard labels on different elements • Elements in the extension but not in a presentation group • Calculation inconsistencies

  15. Results to date • 3,370+ XBRL submissions to date • Tier1:500 Tier2: 1,200 Tier3: 8,000 coming • More than 70% used a service provider • Companies submitting 2+ filings typically used same service/provider • Average 8% of elements are extensions • Extensions range from 0 to 52% • DFN’s – not easy & complex, questions rose significantly from dozens (PFS) to hundreds • Small group opted to use Grace Period 7% * Some Stats provided by XBRL.US

  16. Results to dateExtensions as a % of concepts used Statistics provided by XBRL.US

  17. Results to date • Extensions should be created to: • Aggregate elements not available in the taxonomy – creating a new element that captures several elements added together • Develop new elements that are more specific than what is available (i.e. MSFT Xbox revenue) • Comply with recent accounting changes/FASB pronouncements not reflected in 2009 release • Reflect industry specific extensions not yet covered in the taxonomy

  18. Results to date • Rendering XBRL data • “Filers should be aware that there is no requirement that the rendered files appear identical to the HTML/ASCII filing . . . In addition, filers should not deviate from the guidance in the rule release and EFM (Edgar Filer Manual) (e.g., change, delete, or summarize information in the Interactive Data File) solely in an attempt to correct rendering issues.” -- U.S. Securities and Exchange Commission

  19. Resources • Canada: Xbrl.ca, Xbrl.ca.blogspot.com, IFRS.org • US: Xbrl.us • Brix – IPhone app by US labs: displays XBRL filer and # of tags. Search tags • Software and Services Comparison Matrix http://xbrl.us/Learn/Pages/ToolsAndServices.aspx • Taxonomy http://xbrl.us/taxonomies/Pages/US-GAAP2009.aspx • Case studies http://xbrl.us/Learn/Pages/CaseStudies.aspx • Newsletter signup http://xbrl.us/News/pages/newsletter.aspx • US: SEC’s XBRL information portal: http://xbrl.sec.gov • View XBRL-formatted financial statements http://www.sec.gov/spotlight/xbrl/filings-and-feeds.shtml • SEC’s XBRL Submission Previewer https://datapreview.sec.gov/previewer/ • SEC’s Information for EDGAR Filers (EDGAR Filer Manual) http://www.sec.gov/info/edgar/edmanuals.htm • Staff Observations from Review of Interactive Data Financial Statements http://www.sec.gov/spotlight/xbrl/staff-review-observations.shtml • Contact SEC: Email: Ask-OID@sec.gov Ted Uhlinger

  20. Timing FILERS NEED TO GET STARTED EARLY BEFORE THEIR MANDATED LIVE FILING!! Filings may take days not hours due to review & signoff Filers need to build in more time for review Educate all the stakeholders Change Audit Committee or Filing date if needed Collaborative Process – no longer just formatting Start building teams and assigning responsibility Validate and Double Check Takeaways

  21. Eric Evans VP, Business Development EDGAR Online, Inc. eevans@edgar-online.com 212-457-8203 Questions

More Related