• Solutions
    • FERC XBRL Reporting
    • FDTA Financial Reporting
    • SEC Compliance
    • Windows Clipboard Management
    • Legato Scripting
  • Products
    • GoFiler Suite
    • XBRLworks
    • SEC Exhibit Explorer
    • SEC Extractor
    • Clipboard Scout
    • Legato
  • Education
    • Training
    • SEC and EDGAR Compliance
    • Legato Developers
  • Blog
  • Support
  • Skip to blog entries
  • Skip to archive page
  • Skip to right sidebar

Tuesday, July 19. 2016

Rounding and XBRL Data Quality

In XBRL as in other data reporting systems, calculations show relationships among data. Since XBRL defines calculations in this way without validating the accuracy of their results, it is important to examine the results of calculations in XBRL filings. Many preparers may assume that when a calculation does not add up, it is due to rounding, but this may not be a safe assumption.


Round-off errors and XBRLRounding is almost unavoidable when reporting computations, and round-off error can propagate and increase in a series of mathematical operations. Error can be reduced by rounding with both the appropriate rounding method and at the appropriate point in a calculation or a sequence of calculations. There are multiple methods of rounding numerical values and for dealing with scenarios where there is a “tie” between rounding up or rounding down. XBRL uses the half to nearest even method as a tie-breaker where if the fractional part of a numerical value is 0.5, the value becomes the nearest even integer. An advantage of this method is that it treats positive and negative values symmetrically and is thus free of sign bias (as consistently rounding half up creates more positive results, for instance). However, this may not be the rounding method employed by financial preparation or spreadsheet software packages. It is important to ensure a correct, consistent rounding method is used throughout the preparation process so that reported results match what would be reached performing the calculations using the data reported in the XBRL filing.


Perhaps even more important than sticking to a standard method of rounding, the rounding itself needs to be completed at the correct point in the calculation. When computing a sum, for example, rounding the addends before performing the addition can produce a different answer than leaving the addends unrounded and instead rounding the sum. In most cases, rounding the numbers involved in an arithmetic operation before performing the operation is preferable to rounding the result.


Rounding is one of the many important aspects in maintaining control over data quality. Ideally errors are avoided by taking care to round before XBRL statements are prepared. It is up to the preparer to ensure rounding practices are consistent and precision is maintained to the acceptable number of significant digits for numerical values.Because incorrect calculation results do not generate errors with the SEC, the results should be inspected for accuracy (as can be done with GoFiler’s validation tool). Depending on the size of the error, improper rounding could be the cause. It is important not to assume automatically that round-off error is the source of the problem, however. In addition, if errors are found, it is important not to address the issue in only the XBRL as it will then fail to match the HTML. If the data fails to add up, registrants should make sure the calculations are correct; likewise, filing agents should check with their clients to determine the best way to remedy this situation.



Posted by
The Novaworks Team
in SEC Filing Help, XBRL at 09:49
Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)
No comments
The author does not allow comments to this entry

Quicksearch

Categories

  • XML Accounting
  • XML AICPA News
  • XML FASB News
  • XML GASB News
  • XML IASB News
  • XML Development
  • XML Events
  • XML FERC
  • XML eForms News
  • XML FERC Filing Help
  • XML Filing Technology
  • XML Information Technology
  • XML Investor Education
  • XML MSRB
  • XML EMMA News
  • XML FDTA
  • XML MSRB Filing Help
  • XML Novaworks News
  • XML GoFiler Online Updates
  • XML GoFiler Updates
  • XML XBRLworks Updates
  • XML SEC
  • XML Corporation Finance
  • XML DERA
  • XML EDGAR News
  • XML Investment Management
  • XML SEC Filing Help
  • XML XBRL
  • XML Data Quality Committee
  • XML GRIP Taxonomy
  • XML IFRS Taxonomy
  • XML US GAAP Taxonomy

Calendar

Back May '25 Forward
Mo Tu We Th Fr Sa Su
Saturday, May 17. 2025
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

Feeds

  • XML
Sign Up Now
Get SEC news articles and blog posts delivered monthly to your inbox!
Based on the s9y Bulletproof template framework

Compliance

  • FERC
  • EDGAR
  • EMMA

Software

  • GoFiler Suite
  • SEC Exhibit Explorer
  • SEC Extractor
  • XBRLworks
  • Legato Scripting

Company

  • About Novaworks
  • News
  • Site Map
  • Support

Follow Us:

  • LinkedIn
  • YouTube
  • RSS
  • Newsletter
  • © 2024 Novaworks, LLC
  • Privacy
  • Terms of Use
  • Trademarks and Patents
  • Contact Us