Creating Zero Defect XBRL-based Digital Financial Reports
Tuesday, November 8, 2016 at 06:34AM
Charlie in Becoming an XBRL Master Craftsman

I have been looking at the problem I have been trying to solve exactly backwards.

Business rule driven XBRL-based financial report creation uses the same philosophy as what Agile programming calls test driven development for creating software.  Agile financial report creation yields XBRL-based financial reports which are free from XBRL technical syntax defects, model structure defects, mathematical relations defects, logical defects, and mechanical defects.

This simple example explains the difference between the current approach used to create XBRL-based financial reports which yields quality problems and a better business rules driven approach which yields zero defects, guaranteed.

Current approach:

Give the steps above, what prevents the creator of a financial report from creating the fact "Assets" with a value of say 1,000; creating the fact "Liabilities and equity" with a value of "1,500"; and then submitting that report to the SEC or other regulator?  Nothing prevents the report error above from being submitted to a regulator, even though the report violates the accounting equation.  And that is exactly the sort of thing that is going on with XBRL-based public company financial filings to the SEC.

Business rules driven approach:

The business rule prevents facts that would violate the accounting equation from inadvertently being created.  Software uses the business rule created in Step 1 to monitor the report creation process. Given these steps above, it is impossible to create a financial report that violates the logical relationship specified by the accounting equation, the fundamental rule of accounting.  Now, this one rule is provided only as a basic and easy to understand example.  Clearly you need more rules.  But what rules?

Here are the machine-readable business rules you need:

I think that is about it for the logical, mechanical, and mathematical relations type rules.  There are other rules that are specific to more detailed areas of financial reporting and accounting.  These rules start to get into the compliance/noncompliance of regulatory rules.  I don't want to go down that path right now.

Think about it this way:  It is not about looking at the pieces of a digital financial report and finding pieces that are wrong.  It is about looking at the pieces of a digital financial report and proving that all the pieces are right.

This list of rules might seem like a lot, and it is.  Professional accountants creating reports and financial analysts using reports will not need to concern themselves with most of these rules.  For example, software deals with base XBRL technical specification and XBRL Dimensions conformance.  That is low-level stuff business professionals will never need to deal with.

If you want to understand more, please read the document Comprehensive Introduction to Business Rules for Professional Accountants.

Article originally appeared on XBRL-based structured digital financial reporting (http://xbrl.squarespace.com/).
See website for complete article licensing information.