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 from November 1, 2017 - November 30, 2017
Unifying Logic Framework for Business
One tactic that I use to understand something is to compare and contrast what I want to understand to something else. I compared and contrasted the Semantic Web Stack and the XBRL stack. What became very apparent is the need for a Unifying Logic Framework for Business.
Let me explain. First, here are some things about what I call the Unifying Logic Framework for Business that you should understand. The framework itself is for expressing business logic, it is not the business logic itself. This is what the framework would achieve:
- a global standard logic framework for business (a global standard to use if you want)
- represent logic at a high enough level so that business professionals can understand the logic (as close to business logic as possible)
- approachable by business professionals (as easy to use as possible)
- represented using a controlled natural language format (as readable as English)
- built in but perhaps optional multidimensional model that does not force the use of OLAP, but usable with OLAP or OLTP (similar to a spreadsheet or pivot table really because it is dynamic)
- enables interoperability between technology stacks (works the same in all software applications)
- enables interoperability between XBRL, GLEI, FIBO (Financial Industry Business Ontology), FRO (Financial Regulation Ontology), the US GAAP XBRL Taxonomy, the IFRS XBRL Taxonomy, etc. (information technology professionals can integrate everything)
- built based on the logic framework of the Semantic Web Stack which has been evolving for 25 or so years (as powerful as possible, but safely implementable in software)
What would a business professional's interaction with something built using this framework look like? Basically, it would be very similar to interacting with a spreadsheet or a pivot table. This is achieved using proven software creation techniques, the concept is proven to be feasible. In the past I have described this as a semantic spreadsheet or NOLAP. The business logic glues things together, not presentation artifacts.
What form would such a Unifying Logic Framework for Business take? Does such a framework already exist? What do business professionals lose by not having such a framework? Who chooses what the framework is from the alphabet soup of ISO/IEC, OMG, W3C, and XBRL International standards? Is the unified logic defined by:
- ISO/IEC Common Logic (CL)?
- OMG Semantics of Business Vocabulary and Business Rules (SBVR)?
- W3C RDFS + OWL + RIF/SWRL syntax logic? (SWRL is not a recommendation, only a submission, RIF and SWRL seem to have issues)
- W3C RDFS + OWL + SHACL syntax logic which specifies closed world assumption and unique names assumption?
- Industry Initiative RuleLog which is designed to be appropriately expressive for supporting knowledge representation in complex domains and yet to be efficiently implementable?
- Industry Initiative RuleML which allows for partially constrained logic profiles and fully-specified logic semantics?
- XBRL Formula? (which has known deficiencies)
Could a de facto Unifying Logic Framework for Business be sufficient? More to come...stay tuned.




Financial Regulation Ontology
Well this is really interesting. Check out the Financial Regulation Ontology. More information here.
The creator of the Financial Regulation Ontology describes it as follows:
FRO is a foundational part of a Semantic Web approach to regulatory compliance for financial institutions . Ontology Web Language (OWL) is a W3C standard with proven scalability, handling complexity in Bio and Medical field. In the ontology everything is a triple: data, schema, mapping, transformations, rules, … everything is stored a uniform cells of subject-predicate-object.
Yes, this is very interesting. More to come I am certain.




Common Denominator is Business Logic
Ultimately systems need to interoperate. This is particularly true today in our networked world in our Digital Age. The common denominator is business logic.
John F. Sowa put it this way in the conclusion of his paper Fads and Fallacies about Logic: (page 6)
"In summary, logic can be used with commercial systems by people who have no formal training in logic. The fads and fallacies that block such use are the disdain by logicians for readable notations, the fear of logic by nonlogicians, and the lack of any coherent policy for integrating all development tools. The logic-based languages of the Semantic Web are useful, but they are not integrated with the SQL language of relational databases, the UML diagrams for software design and development, or the legacy systems that will not disappear for many decades to come. A better integration is possible with tools based on logic at the core, diagrams and controlled natural languages at the human interfaces, and compiler technology for mapping logic to both new and legacy software."
A reality is that people will always come up with their own approaches to doing certain things. As such, single-stack architectures might exist within one very small organization; but when you look at organizations of any size or when you have one organization interoperating with another organization you will have multi-stack architectures and each of those architectures need to interoperate.
One architecture stack which has matured very significantly over the past 25 years is the Semantic Web Stack. As I understand it, in the early days of the semantic web, things were pretty much designed to work one way, the way academics saw the world. But now, those designing business systems have been heard and there are alternative approaches that satisfy the needs of academics and of those designing business systems. There is one area of uncertainty. Will the semantic web stack use RDF, OWL, RIF, and SWRL which was created by academics; or will it use RDF, OWL, and SHACL which was created by more business systems designers.
There are many, many important fundamental details related to business logic and logic in general that one needs to get right when designing parts of a stack. For example, here are the Use Cases and Requirements of SHACL. UC16 discusses things like the "closed world assumption" and the "unique name assumption". These are critical things that make the eyes of most business professionals glaze over and what is becoming very obvious is that the average software developer is not familiar with these critically important issues.
Because of the lack of interest of business professionals and the lack of understanding of the average software developer, design mistakes creep into technical architectures that cause fundamental problems.
But, multi-stack architectures that need to interoperate are a reality, as pointed out by Michael Kifer, Jos de Bruijn, Harold Boley, and Dieter Fensel, in their paper A Realistic Architecture for the Semantic Web:
"In this paper we provided an in-depth discussion of the multi-stack architecture (MSA) for the Semantic Web and argued that a stack of rule-based languages, complete with default negation, should exist side-by-side with the ontology stack based on OWL."
What does all this mean for XBRL and the XBRL technical stack?
This is how I see it based on my 20 years of experience trying to figure out how to best employ XBRL for digital financial reporting.
First, XBRL clearly does not get to redefine business logic or logic in general. Logic in general and business logic in particular, such as the business logic of US GAAP which has been around and tuned for many years, simply cannot be changed by XBRL or any other technical syntax. Business logic is the common denominator between technical implementations. Each technical implemenation must us the same business logic. How they implement that business logic is up to them; but they cannot simply change or ignore business logic. To be clear, I am NOT saying that XBRL is changing business logic.
Second, all that "stuff" exists in the semantic web stack for a reason. If similar "stuff" does not exist in the XBRL stack then XBRL will have missing capabilities and users of the XBRL stack will be unfulfilled.
There are two critical issues or areas that XBRL falls short that I can see:
- The clear definition of the business logic of a business report which is a fundamental layer of business logic. Evidence of this is the XBRL-based financial reports of public companies which are created and then submitted to the SEC. While the vast majority of information reported does follow the business logic that I would expect for a business report, a small minority of the information disclosed does not.
- The ability of those representing business logic within a business report, such as a financial report, to clearly describe that business logic to themselves so that they can get their report consistent with that logic and to users of the report so that the user of the report can understand the meaning conveyed by the business information reported.
These issues reveal themselves as quality problems within the information conveyed by the report. And it is not so much that one cannot do both #1 and #2 above. You can. How do I know? Because I can do both of these things within financial reports. Here is my business logic. Here is how I represent logic within a financial report. The result is financial reports with no errors. The problem is that there is no agreed standard way to represent business logic within XBRL and that most business professionals seem to be unaware of the ramifications of NOT representing this business logic. Thus the quality issues.
Important to understanding the above is an understanding of the fundamental strengths or capabilities of computers and the major obstacles that have to be overcome to leverage those strengths/capabilities. This explains WHY you need standards and WHAT you need those standards to do. These strengths and obstacles are summarized well by Andrew D. Spear in his document, Ontology for the Twenty First Century: An Introduction with Recommendations, page 4:
Fundamental strengths/capabilities of computers:
- store tremendous amounts of information reliably and efficiently
- retrieve tremendous amounts of information reliably and efficiently
- process stored information reliably and efficiently, mechanically repeating the same process over and over
- make information instantly accessible to individuals and more importantly other machine-based processes anywhere on the planet in real time
Major obstacles to harnessing the power of computers:
- business professional idiosyncrasies; different business professionals use different terminologies to refer to exactly the same thing
- information technology idiosyncrasies; information technology professionals use different technology options, techniques, and formats to encode information and store exactly the same information
- inconsistent domain understanding of and technology's limitations in expressing interconnections
- computers are dumb beasts; computers don't understand themselves, the programs they run, or the information that they work with
Information business professionals are trying to store and make use of is becoming more complex than what they have been storing in relational databases or spreadsheets for the past 50 years. A financial report is complex information.
Information is not just a long list of facts, but rather these facts are logically, mechanically, mathematically interconnected and generally used within sets which can be dynamic and used one way by one business professional and some other way by another business professional or by the same business professional at some different point in time. These relations are many times more detailed and complex than the typical computer database can handle. Business professionals sometimes do not understand that certain relations even exist.




Putting the Expertise into an XBRL-based Knowledge Based System for Creating Financial Reports
As someone put it, rather than "paving the goat path" and replicating existing inefficiencies related to old-school paper-based reporting in XBRL-based digital financial reporting software; we chose a different path.
One type of practical knowledge is know-how; how to accomplish something.
Creating a knowledge based system involves the transformation of machine-readable instructions in such a way as to explain to a machine how a system works and how to make a system work the way you want that system to work.
Then, brick-by-brick, much like building a house, business domain experts and software engineers can create tools that automate certain types of tasks in that process. Humans encode information, represent knowledge, and share meaning using machine-readable patterns, languages, and logic. That will be the way an increasing number of work tasks will be performed in the Digital Age of accounting, reporting, and auditing. The result will be more efficient processes.
A software engineer and I tested the feasibility of creating an expert system for creating XBRL-based structured financial reports to prove the concept. We are making that software available free of charge until March 31, 2018.
We also provided information about the techniques we used to create this working proof of concept. The document, Putting the Expertise into an XBRL-based Knowledge Based System for Creating Financial Reports, provides this information.
We will be making this software available free of charge to filing agents, software vendors, accountants, and public companies as part of my Campaign to Improve Disclosure Quality of XBRL-based Public Company Financial Reports Submitted to the SEC. This is an excellent opportunity to understand the explicit knowledge and the tacit knowledge needed, the know how, to build such a system and how that system needs to work in order to be considered useful by professional accountants.
The software engineer that is collaborating with me on this and his colleagues won the prize of 9th XBRL Global Academic Competition 2008-2009, which was held in Bryant University, USA.
In addition, another software vendor has implemented these ideas in a product that is commercially available. This is explained in the document, Process for Verifying Quality of an XBRL-based Financial Report, which helps one understand how to create a reliable, repeatable process for creating quality XBRL-based financial reports.
We believe this will be an industry changing technology, disrupting the process of creating financial reports. Most people don't recognize this yet because they don't understand the paradigm shift that is occurring. But, we do.
If you don't want to follow the same old goat path, read PART 1 to understand the general approach to what we are doing and PART 2 to better understand the conceptual model of an intelligent XBRL-based digital financial report.




Will Accountants Be Replaced By Robots (And What Can You Do About It)?
This is an excellent video, Will Accountants Be Replaced By Robots (And What Can You Do About It)? It is an hour and six minutes long, so a bit of an investment, but it is worth watching. Interestingly, it was published in 2015.
The most interesting thing about this video to me was this person's statement that accountants should control the business logic of systems, not the IT department. No system should be a "black box" or require the accounting department to rely on the IT department to change business logic or processes.
I completely agree with that statement. As artificial ingelligence us employed to automate more and more things over the next 30 years, professional accountants need to take back what they gave away during the last 50 years. Understanding business logic and tools for working with that logic are key.
Accounting existed before writing and numbers, invented 10,000 years ago. Like writing and numbers, computers are just a tool. A very powerful tool, but a tool none-the-less. Do you really want the tool makers controlling your craft?



