BLOG: Digital Financial Reporting
This is a blog for information relating to digital financial reporting. This blog is basically my "lab notebook" for experimenting and learning about XBRL-based digital financial reporting. This is my brain storming platform. This is where I think out loud (i.e. publicly) about digital financial reporting. This information is for innovators and early adopters who are ushering in a new era of accounting, reporting, auditing, and analysis in a digital environment.
Much of the information contained in this blog is synthasized, summarized, condensed, better organized and articulated in my book XBRL for Dummies and in the chapters of Intelligent XBRL-based Digital Financial Reporting. If you have any questions, feel free to contact me.
Entries in Statement of Changes in Equity (1)
US GAAP Statement of Changes in Equity is Very Odd
It is my personal view that the Statement of Changes in Equity in the US GAAP Taxonomy is very odd and will not work properly for the reasons I will list in a moment. The information in this blog post is to help accountants understand this section of the US GAAP Taxonomy better, help you understand other sections of the taxonomy better because of a better understanding of the statement of changes in equity, and to empower accountants to provide better input so that a better statement of changes in equity can be modeled in the US GAAP taxonomy.
First off, let me give you a few links to help you to go and look at the statement of changes in equity. I am using the commercial and industrial companies (CI) version of network 148600 - Statement of Shareholders' Equity and Other Comprehensive Income. Here is a link to the taxonomy viewer provided by the US GAAP Taxonomy. This is the same information presented in a slightly different way, a flat list that you can view rather than a hierarchy which you need to open. There are other statements of changes in equity in the US GAAP Taxonomy. The ideas in this analysis apply to every one of those.
I am looking at this statement from the perspective of an accountant. I do understand the XBRL better than most accountants, I realize that. This is the point of the statement that this is odd. If more accountants undersood these things, I specualte that they would agree with me. Here is my list of reasons why the statement of changes in equity is very odd:
- Nothing else in the US GAAP Taxonomy is modeled in this manner. There is nothing else in the US GAAP Taxonomy that is modeled in the manner that the statement of changes in equity is modeled. Sure, the word [Roll Forward] is in some of the concepts, but it looks like no other [Roll Forward]. This makes the statement of changes in equity harder to understand. Basically the approach used is to have a bunch of [Line Items] and the funky axis "Statement, Equity Components [Axis]" (which you can see here or here) and the intersection of the line item and the axis is the "cell" into which the fact value would go. Semantically, this is NOT how a statement of changes in equity works.
- The statement of changes in equity is a collection of [Roll Forward]s. This goes with the first statement in that there are a lot of things in the US GAAP Taxonomy which are similar to the statement of changes in equity; all the other [Roll Forward]s. That is what the statement of changes in equity is, changes from a balance on one date to the balance on another date. That is what every [Roll Forward] articulates. Why does this statement not follow that pattern?
- You get lots of strange contexts which makes validating computations significantly more difficult. The resulting "cells" of information have different XBRL Dimensions information within the context. This causes two things to happen. First, you cannot use XBRL calculations to validate a simple calculation which can be validated in normal [Roll Forwards] (the changes piece) and XBRL Formulas to validate the changes in the balance are likewise more challenging to construct.
- You have no idea which combination of [Line Items] and [Axis] are allowed. It is not the case that every [Line Item] can be within any or every equity component. Because of the way this is modeled, additional rules have to be created to tell you which [Axis] is allowed on which [Line Items]. This is unnecessary with other [Roll Forward]s, the [Roll Forward] provides you with the list of useable concepts. (Again, this is why this statement should be modeled as a [Roll Forward].
- Concepts used in this statement don't "fit" into other areas of the XBRL instance. The statement of changes in equity contains lots of things which are used in other areas of an XBRL instance. For example, Net Income (Loss) from the income statement; dividends paid which are disclosed on the cash flow statement, those sorts of things. And there are a lot of them. All these pieces can fit nicely together if a taxonomy is modeled correctly. The strange axis "Statement, Equity Components [Axis]" used on this statement makes that impossible. You will see this when you try and model your XBRL instance.
- Not everything has a class of stock, so why the [Axis]. People don't seem to grasp the fact that the [Axis] of a [Table] apply to all [Line Items] in a [Table]. The class of stock [Axis] (which you can see here or here), modeled in this statement, means that EVERY line item has a class of stock. Semantically, this is simply not the case from an accounting perspective.
There are some other issues that I have with the statement of changes in equity such as that it cannot handle restatements caused by prior period adjustments due to changes in accounting policies or corrections of an error. But I will save this for another day. I want to focus on the fundamental modeling of the statement, not additional things which need to be added to the model.
Part of the reason that the statement is modeled the way it is in my view is because there is a miscommunication between the technical people and the domain people when it comes to this statement. Many accountants give the misperception that there is an infinite number of things that can go into the statement of changes in equity and this is simply not the case. Further, it is not the case that the [Line Items] can go under various equity components in an arbitrary manner. Where things go is not arbitrary at all and filers have little control of where to put things, US GAAP tells them where things go. And so should the model of the statement of changes in equity.
Another part of the reason certain modeling decisions are made, and incorrectly in my view, is that accountants are obsessed by how things are presented and they don't fully understand the connection between presentation and the modeling of the taxonomy. Key points missed are that the best thing for presentation is to do things consistently and logically, focusing on semantics, not XBRL syntax. But as this understanding becomes better as a result of seeing working SEC XBRL filings and filings that don't work so well, practices will drift to the proper effective result. The sooner and the more accountants understand how XBRL works, the faster we will get there.
Some clues as to how things do work in XBRL can be seen in some things that I had laying around from several years ago (about 2005 time frame) which were used to test the IFRS GP taxonomy. I could not decide if providing these would be more helpful to people or confusing. If you focus on the right things you can get the true points. At the risk of confusing people, I will make these things available. The point here is to see another model of a statement of changes in equity, how it works, and contrast that to how the US GAAP Taxonomy statement of changes in equity works. This has nothing to do with comparing IFRS and US GAAP. This is about how to model information and the results which you derive from modeling things in specific ways. So, I make this available in that light. Please don't read the wrong things into what is being shown. Further, realize that the 2005 IFRS GP was done in 2005. I learned a lot from that taxonomy. It is not an example of how a taxonomy should be created today in my view. That said, there are certain aspects that are created correctly. That is what I want to focus on.
So first off, here is the end result of my testing: This PDF. The PDF may seem a little odd, but the point was to PROVE that the IFRS taxonomy was constructed correctly. What the PDF shows is what is called a [Roll Forward] (IFRS calls it a movement analysis) for EVERY equity line item. EVERY type of change is shown.
This is the XBRL instancefrom which the PDF is created. Again, this is test data. But, the same idea applies whether you are creating a test financial expressed in XBRL or a real one: do ALL the computations add up? How do you know that they add up?
Well, we used the XBRL calculations and XBRL Formulas to test the computations. There are three types of computations:
- The columns add up to what is shown in the right most column which is "Equity, Total". XBRL calculations are used to express those computations.
- The total changes adds up, that is the second row from the bottom, "Total Changes for Period" in the PDF. Each column needs to add up. (Even though this number may not be shown on the actual statement of changes in equity).
- The roll forward (or movement needs to add up. For each column, the first row which is "Balance at December 31, 2003" + the second to the last column "Total Changes for Period" = the last row which is "Balance at December 31, 2004". XBRL calculations cannot perform this test.
Here are the two validation reports which test EVERY ONE of these computations: XBRL Calculations and the XBRL Formulasvalidation results. The calculations validation comes from the XBRL calculations expressed with the IFRS GP taxonomy, see this calculation linkbase. The XBRL Formulas come from a formula linkbase I created. Originally back in 2005 when I was testing this I used a proprietary version of XBRL Formulas which UBmatrix created. I updated those formulas to the XBRL Formula 2008 specification, which you can see here. These calculations and formula validation results can be a little hard to read because they are not organized as an accountant would want to see them. But, all the information is there. Again, the point is that EVERY computation is validated. I KNOW that everything adds up.
Another important point on the PDF is that if you look at the numbers, they have the correct "polarity" (whether they are shown as positive or negative). What I mean is this. Look at the fifth column from the right which is "Treasury Shares". Notice how the number in the first column is -1,100. Now, some accountants would say that should be shown as positive, not a negative. No worries. Simply change the style sheet which renders this information. You can see the style sheet here. If you know how to read the XSLT you can see that it is very easy to flip the number from a positive to a negative by changing this XSLT:
<xsl:value-of select="format-number(/xbrli:xbrl/ifrs-gp:TreasuryShares[@contextRef='I-2003'] * -1,'#,##0','base')" />
All you would do is change the -1 to a 1 and the value from the XBRL instance would be shown as positive, rather than negative. People obsessed with wanting to show this as either positive or negative are missing the point that people should be able to show this HOWEVER THEY WANT TO. XBRL provides what is needed in order to achieve this flexibility.
Conclusions
Here are my conclusions. Take a look at the evidence above and consider all the other things which my might feel appropriate to consiser and reach your on conclusion. But my own personal conclusion is this:
- The statements of changes in equity are [Roll Forward]s and they should be modeled as such. This would make understanding how to create a statement of equity in XBRL a whole lot easier.
- Accountants are going to want to validate their computations to be sure the fact values expressed in the XBRL instance properly foot and cross-cast. All of them, even the reconciliation of the beginning and ending balances.
- The taxonomy should express the proper financial reporting and accounting semantics. Not everything in a statement of equity has a "class of stock", so that [Axis] is NOT appropriate in the statement of equity. It would be very approprate for certain pieces of the statement of equity, but not for the entire statement of equity. This means that rather than modeling one big herky [Roll Forward], the it would be more appropriate to model each [Roll Forward] separately.
- The side benefit of number 3 is that you know which concepts you should use in which columns of the statement of equity.
- The IFRS GP taxonomy of 2005 proves that this can work. You can see for yourself in the links above. You can also see how this works and can see that it is, in fact, nothing more than a [Roll Forward].
- Modeling the taxonomy and rendering the information in the XBRL instance are two different things. A taxonomy with a consistent information model, the base and any extension, is easy to render.
As more and more SEC XBRL filings get made with the statement of changes in equity more and more filers will have to grapple with this statement.
If someone sees a better way to model the statement of changes in equity I would love to know about it. But you need to provide a well thought out prototype so you can think through all these pieces, rather than providing "vapor XBRL instances and taxonomies" which may not work like you think they would work. Run what I am showing through the ringer. Heck, if you have something better let's us that approach. All I personally care about is that this works for financial reporting.