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.”

Groucho Marx

There are two approaches to learning:

  1. Learning by making mistakes.
  2. 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:


Happy learning!

Posted on Thursday, December 15, 2016 at 09:26AM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

XBRL-based Digital Financial Report Principles

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)

Posted on Wednesday, November 30, 2016 at 04:34PM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

Public Company Quality Continues to Improve, 9 Quality Leaders

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:

  1. The creator of the XBRL-based financial report made a mistake. To correct this mistake, the report must be fixed.
  2. The creator/maintainer of the US GAAP XBRL taxonomy made a mistake. To correct this mistake, the US GAAP XBRL Taxonomy must be fixed.
  3. 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: 

(Click image for larger view)

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.

Posted on Monday, November 28, 2016 at 08:23AM by Registered CommenterCharlie | CommentsPost a Comment | EmailEmail | PrintPrint

Understanding Disclosure Mechanics

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.

Posted on Thursday, November 17, 2016 at 02:15PM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint

Updated XBRL-based, Machine-Readable Financial Reporting Checklist

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.

# Disclosure
1 Document Information [Hierarchy]
2 Entity Information, by Legal Entity [Hierarchy]
3 Document and Entity Information [Hierarchy]
4 Balance Sheet
5 Income Statement, by Legal Entity [Roll Up]
6 Statement of Comprehensive Income
7 Cash Flow Statement [Roll Forward]
8 Statement of Changes in Equity [Roll Forward]
9 Nature of Operations Note [Note Level]
10 Basis of Reporting Note [Note Level]
11 Significant Accounting Policies Note [Note Level]
12 Revenue Recognition Policy [Policy Text Block]
13 Inventory, Net (Current) [Roll Up]
14 Property, Plant and Equipment Useful Lives, by Type [Hierarchy]
15 Property, Plant and Equipment, Net, by Type [Roll Up]
16 Property, Plant and Equipment, Net, by Type [Roll Up] (Axis/Member style)
17 Intangible Assets, Finite-lived, Future Amortization Expense [Roll Up]
18 Intangible Assets, Finite-lived, Net, by Major Class [Roll Up]
19 Intangible Assets, Indefinite-lived [Roll Forward]
20 Finite-lived Intangible Assets, Estimated Useful Lives, by Major Class [Hierarchy]
21 Intangible Assets, Indefinite-lived, by Major Class [Roll Up]
22 Goodwill [Roll Forward]
23 Restructuring Reserve, by Type of Cost [Table Text Block]
24 Asset Retirement Obligation, by Legal Entity [Roll Forward]
25 Product Warranty Liability [Roll Forward]
26 Restructuring Reserve [Roll Forward]
27 Long-term Debt Instruments, by Instrument [Hierarchy]
28 Long-term Debt Maturities [Roll Up]
29 Long-term Debt Maturities [Hierarchy]
30 Income Tax Expense (Benefit) Details [Roll Up]
31 Income Tax Contingency, Unrecognized Tax Benefits [Roll Forward]
32 Effective Income Tax Rate, Continuing Operations, Tax Rate Reconciliation [Roll Up]
33 Income before Income Tax, Domestic and Foreign [Roll Up]
34 Deferred Tax Assets and Liabilities [Roll Up]
35 Allocation of Plan Assets [Table Text Block]
36 Fair Value, Assets Measured on Recurring Basis, Unobservable Input Reconciliation [Roll Forward]
37 Unrecognized Tax Benefits, Excluding Amounts Pertaining to Examined Tax Returns [Roll Forward]
38 Defined Benefit Plan, Change in Fair Value of Plan Assets [Roll Forward]
39 Defined Benefit Plan, Change in Benefit Obligation, by Plan [Roll Forward]
40 Accumulated and Projected Benefit Obligations [Roll Forward]
41 Pension Plans or Other Employee Benefit Plans Assumptions Used, by Plan [Hierarchy]
42 Projected Benefit Obligations, Changes In [Roll Forward]
43 Expected Benefit Payments [Roll Up]
44 Net Periodic Benefit Costs, by Plan [Roll Up]
45 Accumulated Other Comprehensive Income (Loss), by Equity Component [Roll Forward]
46 Future Minimum Payments Receivable of Operating Leases of Lessor [Roll Up]
47 Future Minimum Payments Due under Operating Leases of Lessee [Roll Up]
48 Future Minimum Payments, Present Value of Net Minimum Payments, Noncancelable Capital Leases, Lessor [Roll Up]
49 Future Minimum Payments Receivable of Capital Leases, Lessor [Roll Up]
50 Geographic Areas, Long-Lived Assets in Individual Foreign Countries, by Country [Roll Up]
51 Geographic Areas, Revenue from External Customers Attributed to Foreign Countries, by Geographic Area [Table Text Block]
52 Earnings Per Share, Basic and Diluted [Roll Up]
53 Share-based Payment Award, Stock Options, Valuation Assumptions [Hierarchy]
54 Share-based Compensation, Restricted Stock Units Award Activity, Weighted Average Price [Roll Forward Info]
55 Share-based Compensation Arrangements, by Award [Abstract]


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.

More to come...

Posted on Wednesday, November 16, 2016 at 03:57PM by Registered CommenterCharlie in | CommentsPost a Comment | EmailEmail | PrintPrint