Digital Financial Reporting

OMG will hold the first meeting of the Semantic Workbook (SXLM) Working Group at their Boston meeting in June.  You can see mention of the semantic workbook in the July 2019 meeting notes of the OMG Amsterdam meeting:

(Click image to open meeting notes)

As part of the OMG Standard Business Report Model (SBRM) we discussed the idea of the "semantic spreadsheet and semantic pivot table".  See page 2, the section "Business Usability" of this two page summary of SBRM.

This is excellent news!

We discussed the idea of a semantic spreadsheet and pivot table when I worked at UBMatrix way back in 2005 or 2006 or so during the time when we were creating XBRL Dimensions.  Essentially, that is what an XBRL-based report is when the report is created using XBRL Dimensions, a semantic spreadsheet.

Here is the set of semantic spreadsheets, or fact tables, that make up the Microsoft 2017 10-K.  Here is the full report provided in the form of the XBRL Cloud Evidence Package that is used to review XBRL-based reports.

The Microsoft 2017 10-K is really 194 separate "hypercubes" of information.

I forget which meeting it was, but at one of the XBRL International meetings I bumped into someone from Microsoft who happened to be on the Excel team.  I explained why they needed to create the capabilities to edit an XBRL-based semantic spreadsheet in Excel.  The guy looked like me as if I were crazy and last I looked, Excel did not have that functionality.

Semantic spreadsheets have been a discussion topic on my blog many times: Deductive Spreadsheet, Vision of the Semantic Spreadsheet, the "cell store" and NOLAP, digital report being a cross between a spreadsheet and pivot table and BI, the need for a global standard spreadsheet alternative, death of the electronic spreadsheet, time for a new take on spreadsheets, semantic spreadsheet, XBRL ends spreadsheet hell.

Besides the term "semantic spreadsheet", I really like the term "logical spreadsheet". That is really what is going on. This presentation, this book, this article, and this really good article all discuss logical spreadsheets.

I first used a spreadsheet in 1982, VisaCalc.  I suspect that Microsoft Excel will ultimately have semantic spreadsheet capabilities.  I would imagine it being a separate type of "sheet" that you could add, the traditional presentation-based spreadsheet is still very useful and will not go away. Sort of like a Power Pivot sheet.  It would be a core part of Excel eventually.

Wouldn't that be nice!  Anyone know someone on the Microsoft Excel team?

The digital age of accounting, reporting, auditing, and analysis is going to be so cool!!!

Andrew Noble and I wrote the essay below and seem to each reach two conclusions:

• Financial reporting more naturally belongs in a computer assisted digital world than in a paper-based or what amounts to “e-paper” based world.  (Also, maybe loose the report and embrace the information hypercube.  Algorithmic regulation is an idea whose time has come.)
• XBRL-based reports enhanced by SBRM logic and the notion of a powerful but safe and reliable logical system model provides an excellent foundation for what amounts to an “Enterprise Common Business Reporting Model”.

Here is the full essay:

A general purpose financial statement is itself not an “economic entity”.  This is similar to how a “map” is not the same thing as the territory the map represents.

A general purpose financial statement is a high-fidelity representation of information about an economic entity that tries to be as true and fair as possible following a set of agreed upon accounting assumptions (e.g. going concern, recognition, measurement, and so forth).  The general purpose financial report is a model that represents the financial position and financial condition of that economic entity. 

Businesses, banks that provide businesses capital, equity markets that provide capital, and regulators have been using this financial reporting “system”, "the model", for quite some time.  And so, over the years they have been agreeing on and tuning this model.  This has been going on for years and years.  Standards setters act as referees.

The model is not perfect.  Stakeholders within this system have complaints.  For example, the historical cost assumption is questioned because of the big gap in book values as contrast to market value.  Or, the equity markets say they want more information about non-financial items.  As such, the standards setters make adjustments to the rules such as adding fair value measurement rules to the system.  No stakeholder of this systems gets 100% of what they desire, but the system works fairly well and is slowly adjusted to make the system work better.

And so, the system and the model exist in a state of perpetual refinement.

What we are doing with XBRL is to take this model which here-to-for has been represented on a piece of paper or a piece of “e-paper” and putting that existing model into machine-readable form.  XBRL is a purpose-built syntax for representing financial or nonfinancial information in machine-readable form.  XBRL is not the only syntax that can do this.  The semantic web stack’s RDF/OWL/SHACL could be used, or Prolog, or other ontology-like thing.  To be effective, that syntax needs to be able to capture the currently used model effectively and, in some way, make the system better, faster, and cheaper.

What is particularly interesting with respect to the model of a financial report is that it has a lot of very nice “features” that make it incredibly amenable to being represented logically using a model and worked on with a computer. First, the model is based on the “double-entry bookkeeping model” (DEBITS = CREDITS) which provides what amounts to a parity check that can be used to detect errors and distinguish an unintended error from an intended error (i.e. fraud).  Second, the model is based on the accounting equation, “Assets = Liabilities + Equity” which adheres to that same double entry bookkeeping model which provides what can be called “scaffolding” or “keystones” for the financial reporting model.  Third, every financial reporting scheme created provides a conceptual framework (i.e. US GAAP, IFRS, IPSAS, GAS, FAS, FRF for SMEs, etc.) which defines a set of core “elements of a financial statement” used within that financial reporting scheme (e.g. assets, liabilities, equity, comprehensive income, investments by owners, distributions to owners, revenues, expenses, gains, losses) that reconcile to the accounting equation, expand that high-level scaffolding as required by that financial reporting scheme, intentionally interrelated those core elements which cause what is referred to as “articulation[4]” where the core financial statements (balance sheet, income statement, changes in equity, cash flow statement) are all carefully “intertwined” which provides yet another layer of quality control.

Finally, such a financial reporting scheme is a very narrow use case as contrast to a broad general use case.  Those that operate within this system using this model within this very narrow and well-defined domain are all highly trained “experts”.  Certified Public Accountants (CPAs) or Chartered Accountants (CAs) have four or more years of specific university training and are required to take a national certification exam and are certified.  Certified Financial Analysts (CFAs), likewise take many of the same university courses as CPAs and also pass a rigorous and comprehensive certification exam.  Further, these experts have been honing, and honing, and honing their common understanding of “terms” and “associations between terms” and “structures” and “assertions” for over a hundred years now.  All this information has been documented in the Accounting Standards Codification (ASC) for US GAAP or the IFRS standards for IFRS, etc.  If you compare and contrast the different financial reporting schemes, they are far more similar than they are different.

What I am pointing out here is that financial reporting is not like all other reporting domains or others trying to exchange information within their respective domain.  There are other domains that likewise have experts within their domains, good boundaries, etc.  And there are other domain still where the users are not experts, they have no specific common training, and the domains they are trying to represent with ontology-like things are very broad and so they tend to struggle to create a common model.  And because the user base is so broad, the domain is so broad, it is no wonder that they cannot agree on a model, believe that there is no “perfect way to represent the truth…”, and are not really motivated by any specific goal or objective to agree so they tend to get stuck in philosophical debates. 

Users of financial reporting schemes already understand that the goal is to agree and to create something that works.  The financial reporting model already works.  What is different now is that before the agreement was achieved using best practices and paper-based reports that were not machine-readable.  But now, many of these reports are readable by machines and a skillful craftsman using the right tools can poke and prod financial reports and understand things that were impossible to understand before because performing tasks manually was so time consuming and costly.  This opens up a whole new world of possibilities.

Something that seems to be true is that this financial reporting system appears to have been designed for something like a computer all along.  But computers did not exist in 1211 when double entry bookkeeping was invented, or in 1494 when it was documented by Luca Pacioli, or in 1929 after the stock market crash when US GAAP was established, or computers were not widely used in 1973 when they began creating IFRS.  So, financial reporting was being practiced using paper or what amounts to “e-paper” which is not machine readable.  But financial reporting schemes have now found their rightful home here in the digital age or information age or what some people are calling the fourth industrial revolution or the age of artificial intelligence.

It is far more natural for financial reporting to be practiced using computers than using paper.

Financial reporting is central to all enterprise reporting. This is because enterprises live or die based on their financial performance. Enterprise information systems are primarily configured to capture the activities of the enterprise and in general, all enterprise activities ultimately trickle down to being reportable activities. Even if reporting is not explicitly financial reporting, information contained in the reports should conform to the general enterprise information model and the reports should be structured in a semantically consistent manner for each and within each enterprise. It's therefore imperative that any reporting model consider the flow of information through an enterprise and ensure that the model is general enough to handle the reporting of all enterprise information and is specific enough to handle the special case requirements of financial reporting.

It would be absurd for each individual enterprise to be forced to use one common semantic model for all of their internal and external reporting.  It would be likewise absurd for each individual enterprise to develop their own unique reporting model.  A middle ground is for all three needs to be met with one common reporting scheme that was configurable for each individual enterprise, a proven and rock-solid model that each enterprise did not have to independently invent, and a global open standard model that met the needs of the enterprise but also the needs of the global financial reporting supply chains that exist.

XBRL plus the ideas of the Standard Business Report Model (SBRM) could be that enterprise global standard common business report model. That model does not require the use of the XBRL technical syntax internally, but it does allow it and for the logical model of whatever syntax is used, say RDF/OWL/SHACL or Prolog or really any other syntax, to be converted to the same logical model used by XBRL.  That is what the Special Theory of Machine-based Automated Communication of Semantic Information of Financial Statements tries to point out.

(Click image for larger view)

To understand more, consider watching the video playlist that helps you understand the financial report logical system.  Or, maybe read this.

#################################

Tim O'Reilly, Open Data and Algorithmic Regulation

SECFly Reporting

XBRLogic.com published their Q4 quality scores.  The bottom line is that there has been no change really.  Business as usual. This PDF provides a summary of this information, details, and explanations.

Why did I stop providing my fundamental accounting concepts quality score?  Because (a) XBRLogic is providing something quite similar and (b) all those who wanted to fix their issues did so.  Here was my last post, March 31, 2019.

Harvard Business Review published an excellent article, Artificial Intelligence for the Real World, by Thomas H. Davenport and Rajeev Ronanki.  The article provides a very nice summary of both the benefits and challenges of artificial intelligence: (best to go to the article to read the tables)

Benefits:

Challenges: