BLOG: Digital Financial Reporting
This is a blog for information relating to digital financial reporting. It is for innovators and early adopters who are ushering in a new era of digital financial reporting.
Much of the information contained in this blog is summarized, condensed, better organized and articulated in my book XBRL for Dummies and in the three documents on this digital financial reporting page.
Understanding Logical, Mechanical, and Mathematical Accounting Relations in XBRL-based Digital Financial Reports
“Learn from the mistakes of others. You can never live long enough to make them all yourself.”
There are two approaches to learning:
- Learning by making mistakes.
- Learning from the mistakes of others.
Approach #1 is the noble way to learn, make mistakes yourself. But it can be time consuming. Approach #2 is the wise way. It is very efficient to learn from the mistakes of others.
I have accumulated documentation of about 200 errors in XBRL-based digital financial reports. To professional accountants and others who want to learn about XBRL-based digital financial reports, particularly those who want to create ZERO DEFECT reports, this information is extremely valuable. It is this sort of information that helped the 9 quality leaders, the software vendors/filing agents that got to the point where most of the reports they create are error-free per my mesaurement of the fundamental accounting concept relations.
Here are those summaries:
- Issues in XBRL-based Digital Financial Reports (September 28, 2016)
- More Issues in XBRL-based Digital Financial Reports (December 15, 2016)
- Summary of Issues of Quality Leaders
- Issues in XBRL-based Digital Financial Reports for 480 Public Companies that use the INTBX-BSU-CF1-ISS-IEMIX-OILN Reporting Style
- Preliminary Analysis of 20 disclosures (February 14, 2017)
- Analysis by audit firm (April 2017)
I added a section to a revision to the document Digital Financial Reporting Manifesto which outlines a set of XBRL-based digital financial report principles. (see page 24)
Nine quality leaders have laid the foundation for semantic interoperability and established a clear path to zero defect XBRL-based financial reports. A significant milestone was reached this month. The total number of filings that had inconsistencies dropped below 1000, currently only 953 have errors while 5,281 public companies are consistent with the fundamental accounting concept relations.
The document, Summary of Issues of Quality Leaders, inventories the complete list of fundamental accounting concept relations inconsistencies of every quality leader. In so doing, the document lays a path from the current high quality levels to zero defect levels. Remember, there are exactly three reasons for inconsistencies to be reported:
- The creator of the XBRL-based financial report made a mistake. To correct this mistake, the report must be fixed.
- The creator/maintainer of the US GAAP XBRL taxonomy made a mistake. To correct this mistake, the US GAAP XBRL Taxonomy must be fixed.
- The creator/maintainer of the fundamental accounting concept relations business rules made a mistake. To correct this mistake, the business rules must be fixed.
It really is that simple. The document mentioned above shows every inconsistency. Most of those 80 inconsistencies in the 69 reports are not disputed, filing agents/software vendors agree that they have made a mistake and they will fix the public company XBRL-based financial report. But they don't agree with all of the inconsistencies. What then? Who serves as the referee to establish what must be fixed: the filing, the taxonomy, or the business rule? This remains a bit vague.
But as the number of errors is reduced, the areas of disagreement begin to reveal themselves in the XBRL-based financial reports. The vast majority of inconsistencies are not disputed. While the quality leaders have fixed their mistakes, the quality laggards have not.
This ZIP archive contains an Excel spreadsheet that contains a listing of all 1,433 inconsistencies which exist in the 953 public company XBRL-based financial reports. If each of the inconsistencies were corrected by fixing the filing, the US GAAP XBRL Taxonomy, or the business rules; then the XBRL-based financial information would have zero defects as articulated by the business rules. While the rules I have provided are necessary (i.e. they are fundamental relationships) those rules are not sufficient. I have already pointed out that the disclosure mechanics rules also need to be passed.
The point is this: there is a self-evident connection between "quality" and "business rules". All you need to do is read the document which summarizes the remaining issues of the quality leaders and you cannot help to see this important connection.
How hard is it to fix mistakes? If you go back and look at prior testing results you would see that EDGARfilings PROfile went from 76% consistency in March 31, 2016 to 98% consistency in November 27, 2016. This graphic shows their improvement in quality. Merrill went from 55% consistency in March 31, 2015 to 97% consistency in March 31, 2016. Here is Merrill's graphic. Fixing mistakes just takes effort. Good tools can help too.
Here is the summary of consistency with the fundamental accounting concept relations business rules as of November 27, 2016:
Nice work to the quality leaders who have worked so hard to dial in their XBRL-based digital financial reports! Collectively, the 9 quality leaders have reached Sigma Level 4 and I expect them to reach Sigma Level 5 within the next three months. You quality laggards need to get to work fixing your mistakes.
* * * PRIOR RESULTS * * *
Previous fundamental accounting concept relations consistency results reported: August 31, 2016; June 30, 2016; March 31, 2016; February 29, 2016; January 31, 2016; December 31, 3015; November 30, 2015; October 31, 2015; September 30, 2015; August 31, 2015; July 31, 2015; June 30, 2015; May 29, 2015; April 1, 2015; November 29, 2014.
This blog post points you to resources which explain the disclosure mechanics piece of the Zero Defects XBRL-based digital financial report. The document Understanding Disclosure Mechanics provides a high-level overview of what is meant by the term disclosure mechanics.
This blog post provides a list of the 55 disclosures for which I am using for testing purposes.
Here is an update to my world's first XBRL-based, machine-readable financial reporting checklist. (No one has refuted my claim that this the world's first)
I have now added machine-readable business rules for the 55 disclosures listed below. This is still only considered a working prototype because this (a) has not been completely tuned yet and (b) is not yet implemented in commercial software (it currently only runs using my custom made software). This document shows the results I am getting for the first 25 disclosures I implemented. The other 30 that I added are getting similar results. The document also walks you through the tests that I am currently running.
What is becoming increasingly apparent is the utility of these business rules not only for after-the-fact validation of XBRL-based financial reports; but also to drive guidance-based digital financial report creating software, queries of reported information (look at the mappings), etc.