« Understanding Knowledge Based Systems | Main | World's First Expert System for Creating Financial Reports »

High Quality Examples of Errors in XBRL-based Financial Reports

Below are links to PDF files that have high-quality documentation of approximately 380 errors that exist in XBRL-based financial reports of public companies which and been submitted to the SEC as of March 1, 2017. I detected these errors as part of my measurement of the fundamental accounting concept relations and the continuity errors discovered as part of those cross-checks.

Examining and understanding these errors can help professional accountants improve their skills in working with XBRL-based digital financial reports and software developers create software useful to business professionals that help them not make these sorts of mistakes.

I created this information so that I could provide it to professional accountants who were not detecting these errors when they created their XBRL-based financial reports.  Over the past several years I have made this information available to filing agents and software vendors which they used to understand and fix these sorts of errors.  These 380 errors are about one quarter of the remaining high-level errors in the set of about 7,000 public company financial reports.

These errors tend to be very uncontroversial.  Proof of that is that software vendors and filing agents, once they are made aware of these errors; fix these errors.  For example between 2015 and 2017; Merrill went from 55% consistent to 97% consistent; RR Donnelley went from 73% to 98% consistent; DataTracks went from 62% to 98% consistent. (See the comparison of periods here.)

All of these errors were detected using processes that have been implemented in commercial software. For example, here is a tool provided by XBRL Cloud which they make available on their Edgar Dashboard.

None of these errors are related to the XBRL techical syntax.  The errors all relate to employing XBRL to convey meaning.  These are logical, mechanical, and mathematical mistakes made by the creators of the reports.  Software needs to support the functionallity to detect these sorts of errors.  Here are a few examples of the patterns of errors that you find in the XBRL-based financial reports of public companies: (documented by the PDFs provided below)

  • Reporting contradictory/conflicting information. For example, reporting "revenues" facts that contradict one another.
  • Using concepts incorrectly relative to other concepts. For example, WHOLE/PART relations that are wrong such as using "us-gaap:CostOfRevenues" (DIRECT operating expenses) as a PART OF "us-gaap:OperatingExpenses" (INDIRECT operating expenses) when they should have used the concept "us-gaap:CostsAndExpenses" (TOTAL DIRECT + INDIRECT operating expenses)
  • Simply using the wrong concept.  For example, a common error that you will see is using a concept that relates to "Other comprehensive Income" to represent a line item related to "Comprehensive income" because an incorrect concept was mistakenly selected.
  • Creating completely XBRL valid relations, but the relations either is inconsistent with the US GAAP XBRL taxonomy or literally CHANGES THE MEANING of US GAAP.
  • Creating unjustifiable extension concepts.  For example, a handful of public companies create the extension concept "my:TotalAssets".  Really?

Each of these errors are logical errors, mechanical errors, or mathematical errors which have NOTHING to do with XBRL technical syntax.  Each error was represented using PERFECT XBRL technical syntax; but the information conveyed was just wrong.

Principles help you think about something thoroughly and consistently.  As a result of my measurement of the fundamental accounting concept relations, I created the XBRL-based digital financial reporting principles.  They help you think about XBRL-based reports.

This information should be very helpful to professional accountants creating XBRL-based reports and software developers building tools those professional accountants use.  There are those reports grouped by audit firm.  I am not saying that any of these audit firms have responsibility for any of these inconsistencies, I am simply making this information available in this form because I also sent this information to each audit form to help them understand these sorts of errors. (April 2017)

Happy learning! Oh, if you are wondering why I am taking time to put together the business rules for discovering there errors; have a look at the components of an expert system and/or check out my little expert system for creating financial reports. The rules contribute to making the expert system work.

Posted on Saturday, April 29, 2017 at 10:59AM by Registered CommenterCharlie in | CommentsPost a Comment

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
All HTML will be escaped. Hyperlinks will be created for URLs automatically.