« Experiment: Research and Development Expense, Top 100 Companies | Main | SEC XBRL Data Extraction Experiment »

Analysis of 5525 SEC XBRL Financial Filings

In order to better understand how to create SEC XBRL financial filings and XBRL instances and taxonomies in general, I analyzied 5525 SEC XBRL financial filings.  This analysis builds on another analysis which I did several months back of 1474 SEC XBRL financial filings which pointed out four common areas of confusion in the US GAAP taxonomy and therefore inconsistencies in SEC XBRL financial filings. This post helps to understand and resolve those areas of confusion.

This new analysis of the additional filers, about four times as many, shows the same consistent patterns in filings.  For example:

  • The concept us-gaap:Assets is reported by 99% of all filers. The other 1% can be explained. Some filers have only us-gaap:AssetsCurrent and do not provide the concept us-gaap:Assets.  Others report using a net assets presentation format. So basically, there is a 100% complete set of the possibilities, which was expected.
  • As you might expect, because the balance sheet balances, the concept us-gaap:LiabilitiesAndStockholdersEquity likewise appears with regularity, again about 99% of the time.  But because some filers are partnerships, the concept us-gaap:LiabilitiesAndPartnersCapital is reported.  Again, 100% of cases can be accounted for.
  • The concept us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease (net change in cash on the cash flow statement) appears with regularity, 95% of the time.  The 5% balance are filers which either do not report a cash flow statement for some reason, use a different concept such as us-gaap:CashPeriodIncreaseDecrease or they create an extension concept for some strange reason or erroneously use the wrong concept.  Again, 100% of all possibilities can be accounted for.
  • The income statement is less consistent, but still more consistent than not.  The highest area of variability where one might expect consistency is the reporting of net income (loss).  There are three concepts which are used somewhat inconsistently due to ambiguity in the US GAAP taxonomy it appears.  There are three possible "candidate" concepts which could be chosen, different filers are reaching different conclusions as to which is the appropriate choice.

So what does this mean? My interest is not really the analysis of financial filings but rather the creation of financial filings.  However, as the ability to use of the information within the financial filings is a driving characteristic of financial information; I am indirectly interested in the analysis of the information.

But what I am more interested in is the consistency of the semantics for the purpose of using that consistency to drive the creation of financial reports.  That has been my interest in XML in financial reporting since back in 1998 when I first started to get people interested in XBRL.

That is why this SEC XBRL financial information set is so interesting to me, it basically proves my long held hypothesis.

However, one thing is a bit disappointing to me.  I actually believed that the "individual investor" could and would actually make use of the SEC XBRL information directly.  That will simply not be the case. Despite what many XBRL zealots say, I don't see the SEC XBRL information as being usable by individual investors any time soon, if ever for the following reasons:

  1. Because US GAAP is not a "form".  There is simply too much variability allowed for the average person to overcome.  At the same time the variability is not so great that it cannot be overcome with some work. The SEC could improve the situation by revising regulation S-X. Others have called for the SEC to make such revisions even before the creation of the US GAAP Taxonomy. While the SEC does not need to turn US GAAP into a "form", some structure is necessary in order to help the average person use this SEC XBRL financial information.
  2. Other variability in financial reports.  One of the biggest is the fiscal period.  The fact that periods can end at different times and things like the 52/53 week year end make using information harder.  There are other things such as this.
  3. US GAAP taxonomy ambiguities.  There will likely always be ambiguities in the US GAAP taxonomy. That is just the nature of the beast.  Some will be addressed, others never will.

Those are the realities. You can wish the world were different, but it is not. While I am no expert, my database skills, XML skills, Excel skills, Access skills are likely better than the average investor.  This does NOT mean that the SEC XBRL information is a waste of time. What it means is simply that these average investors are going to need some help by others to organize that data set to make it easy enough for them to use.  That will definitely happen.  Maybe these denormalized and more useable sets will be free, maybe users will be charged some fee; hard to say, probably both.

So there are two lessons here. 

The first lesson is that using SEC financial information can be challenging and the challenges really have little to do with XBRL.  Some, but not really that much.

The second lesson is that if you want to build a system and you want your data set to be easy to use, dig deep into the SEC XBRL financial information because it offers many, many clues which you can use to make your system work better.

Posted on Thursday, August 25, 2011 at 08:15AM 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.