wen0715のブログ

Based authoring of digital financial reports leveraging the xbrl medium


This web site provides information on how to use xbrl to help business users exchange business information.Business information incluldes both financial and nonfinancial information.Everything on this site made available to all under a creative commons license.Everything may be reused however one sees fit.All we ask is that you give credit where credit is due.

I had this idea for an analysis to perform on the sec xbrl filings in order to see what they were looking like and to test some things i was fiddling with.The analysis vastly exceeded my expectations in terms of information it provides and it is incredibly useful to seeing the types of issues accountants are going to have to deal with.This blog post summarizes the results of that analysis.I have a detailed document which provides additional insight, if you want a copy of that send me an email and i may be able to get that detail to you.

The analysis looks at 408 sec filings of 10q's all filed after july 1, 2009.This list came from xbrl cloud's list of sec filings.

I established a hypothesis that if i ran an xbrl formula through each sec xbrl instance(10Qs)That the formula(Business rule) should either support the fact that cash reconciles or there should be some reasonThat the formuladoes not support that and there would be a specific reason as to why.Another way to state this is to say that"Beginning balance of cash + changes in cash = ending balance of cash".The us gaap taxonomy states this, although implicitly;You can see that here in the us gaap taxonomy ci entry point. (What i mean by implicitly is that there is no official business rule which states this and there is only the implicitly way that a [roll forward] is created which unofficially implies this, it could be explicit though. )

So, i created this business ruleusing xbrl formulas.One of the first thing i recognized was that filers were using two different us gaap taxonomies(2009 and 2008)So i had to create another xbrl formulafor the second taxonomy.I then used the complete list of sec filings(Mentioned above)And created a little batch file which grabbed the sec xbrl instance from the list, applied the business rule, and spit out a validation report in xml which i then converted to html.I did this using the ubmatrix xbrl processing engine.This is a summary of the raw validation results.

The really interesting thing is that of the 408 filings, 358 passed validation first time through!I was truly amazed.That mean that 358 of the 408 filers provided the concepts specified by the us gaap taxonomy, that the numbers added up correctly, and that there were two periods reported.This part took very little effort to set up, it is just creating the formula, getting the list of filings to run the formula against and generate the batch file to automate the entire process.

The hard part was figuring out why the other 50 did not validate.That was the really interesting part o this analysis, but also rather time consuming.

Before i get to the observations there is something that i want to point out.While i did this analysis for the cash flow statement, the same type of analysis could be performed in other areas of the taxonomy.But if the analysis were to be performed, i speculate that the types of issues you would discover would be quite similar to the issues uncovered by my simple analysis.Keep this in the back of your mind as you read these observations.

High level observations

Here are the observations which i made:

Of 408 filings, the cash flow statement was extremely consistent at this high level.For example, all but 6 filers of the 408 total filings had used the concept"Usgaap:Cashandcashequivalentsperiodincreasedecrease"Specified by the us gaap taxonomy for net increases or decreases to cash reported on the cash flow statement.

Of the 408 filings, the vast majority of the filers followed the us gaap taxonomy which calls for the concept"Usgaap:Cashandcashequivalentsatcarryingvalue"To be used on the cash flow statement. (358 plus, did not to an actual count)Only 5 filers created extension concepts for the balance of cash.Of those, 4 created extension concepts which were different for the beginning and ending balance.One concept for the beginning balance, a different concept for the ending balance).This is a big nono in my book and the fact that only a hand full did this and that this is never done in the us gaap taxonomy itself is pretty good evidence that creating two different concepts for the beginning and ending balance is not the way to go.

The vast majority of filers followed the us Gaap taxonomy calculation and included the changes in cash related to exchange gains and discontinued operations within the concept"Gaap:Cashandcashequivalentsperiodincreasedecrease";However, there were a hand full which did not include cash changes from exchange gains or discontinued operations within that concept, rather they were additional reconciling items in calculating the total change.In is hard to believe that calculating this total change in cash should be done in two different ways, but that my just be me.

One filer had an additional reconciling item for vie related changes to cash(Papa johns international inc).It may be the case that this concept needs to be added to the us gaap taxonomy.

Two filers(Dte energy, ppl corporation)Has"Assets reclassified as held for sale"Included in changes to cash.This may need to be added to the us gaap taxonomy.I do recall from my work with the ifrs taxonomy that this concept is part of the cash flow statement as these to filers reported.

Two filers(Symantec corporation, nvidia corporation)Had a 52/53 period year end and used the wrong startdate which did not match to the instant reported, therefore the xbrl formulas did not fire.When the michael kors online shop deutsch startdate was corrected and the validation was rerun, the validation worked correctly.These are pretty obvious errors.

Of the 408 filings, only 2 filings had"Rounding issues"Which caused the computations to not add up correctly for this one formula.Personally, i belive that filers should make all these adjustments before they put their numbers in the xbrl instance because sure, it may be some additional work for the filer, but it will be even more work for all the analysts who make use of this information, trying to deal with these rounding issues.Again, that is my personal view.

It seems thAt compArABility would Be extremely eAsy to Achieve for the high level of the Cash flow stAtement.The Biggest issue to compArABility Are(A)The use By a minority of filers of different concepts to represent the Balance of"Cash"Than the us gaap taxonomy calls for and(B)Where the exchange gains and discontinued operations really should be in the computation of the net change in cash.These are both accounting issues, not technical issues.

Further, looking one level deeper into the cash flow statement, a high percentage of filers(Over 95%)Report the concepts:Usgaap: NetCashProvidedByUsedInInvestingActivities,Usgaap: NetCashProvidedByUsedInFinancingActivities,Usgaap:Netcashprovidedbyusedinoperatingactivities.I may do some additional work to see more precicely what is going on with these concepts.

Example of issues accountants will have to deal with

Ok, so now to the example of issues accountants will need to deal with.I have my personal opinion on these, but clearly this is not my call.Someone will need to deal with these issues however.Not doing anything is an option, but i don't really thing it is the best option.

TAke the issue of where the exChAnge gAins And losses reAlAting to CAsh Are totAlled, there seem to Be the following options: (A)ForCe everyone to use the us gaap taxonomy Computation,(B)Allow for filers to Change the Computation But Clearly doCument that Change,(C)Do nothing which is really implying that option"B"Is the right choice.What sort of comparability should be provided?Who decides?

If someone does move the computation of"Usgaap:Cashandcashequivalentsperiodincreasedecrease", should they create a new concept or simply change the definition of the existing concept?This debate has existed for years in the xbrl community.

Should prepares be required to report the concept"Usgaap:Cashandcashequivalentsatcarryingvalue"In their cash flow statement, even though they use some other cash concepts on their balance sheet and don't show that concept at all?

Should the iaelorstasen concepts for the changes in assets held for sale and vie related changes be added to the us gaap taxonomy?

Again, those are just a few examples.And remember from the point i made above, while the concepts you might be looking at and the considerations will be different in different areas of the us gaap taxonomy, these issues from the cash flow statement are likely quite similar to issues which will be discovered in other areas of sec xbrl filings.These issues are not just for specific concepts, but more over arching principles which should be applied throughout the entire us gaap taxonomy.

Related Links:
http://qqw0715.spazioblog.it/216293/Hola+soy+nuevo+michael+kors+sale+online.html
http://www.blog-construction.com/qqw0715/165945-nouveau-message.aspx
http://qqw0715.foodblog.com/post/393948/protection_michael_kors_outlet_berlin.html