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 in Financial integrity (3)

Benefits of Financial Integrity

My last blog post helps to provide a definition of what I am calling financial integrity. The post before that helps see how financial integrity is achieved differently on the medium paper than it is with the medium XBRL. In this blog post I endeavor to show how financial integrity can be leveraged because it is expressed in a manner usable by software applications.

Imagine having a job on the starship Enterprise and working with James T. Kirk, its captain. Imagine that you were on the accounting staff (I am sure there were accountants in Startrek) and that Kirk needed a financial statement so he could see how he was doing relative to his budget.  What would that financial statement look like?

You may not need to imagine this for long. Consider this Wired story about how the tablet will change the world.

Imagine that some of the knowledge of accounting and financial reporting was in a form that computers could read and understand. Imagine that a computer application could help you read that financial statement, leveraging the accounting information. Think pivot table. Think visualization. Consider the graphic below and how you might move from place to place in a financial report, from summary information to detail information, leveraging the financial integrity of a financial statement. Or if you were comparing financial information between periods or between companies.

From Wikipedia

None of this is done using magic. If you ever used a navigation system in your car or used Google Earth or Google Body Browser or other such tools.  How do those things work? Structured information. Meta data. Standards. No magic involved. Take a look at this page. Look at the geometric diagrams on the page. Notice the red dots in many of the diagrams. Those dots are connections. Computers can leverage those connections to achieve things like the rotating diagram above.  All we need to do is establish the connections.

We accountants are pretty good at expressing financial information with financial integrity on paper. We will learn to do the same thing using the XBRL medium. When we do and when software leverages the financial integrity, we will have new interesting and useful functionality at our disposal.

 

Defining Financial Integrity

In my last post I pointed out that financial integrity needs to exist in financial reports whether the financial report exists in the medium of paper or in the medium of XBRL.

In this post I want to elaborate on what financial integrity is.

I want to look at defining "financial integrity" by summarizing all the different inputs I have, looking at them, and then coming up with one concise definition.  These are the inputs I have.

 

A Broad Definition

Financial integrity can be broadly defined as making sure a financial report is correct, consistent, complete, accurate and other such overarching terms. While these terms do encompass a great deal, this definition is still too vague.

 

Taking an XBRL Validation Perspective

Drilling down a little more and taking more of an XBRL perspective of financial integrity, I put together a list of the different types of XBRL validation which needs to be performed in order to make sure financial information expressed in the medium XBRL is correct, consistent, complete, and accurate. Below I have provided that list, a brief explanation of the item, and reconciled the list item to the overarching terms: 

  • Edgar filer manual (EFM) validation. Tends to be more syntax related, meta data related, some light semantics. (Relates to: correctness, consistency, completeness)
  • US GAAP Taxonomy information model validation. Tests to be sure you are creating this such as your [Table]s, [Roll Forward]s, roll ups, and hierarchies consistent with the US GAAP Taxonomy. (Relates to: consistency)
  • US GAAP Taxonomy extension points and extensibility rules validation. Tests to see if where you are extending the US GAAP Taxonomy is appropriate and if you are creating logical extensions. (Relates to: consistency)
  • US GAAP financial integrity validation within a [Table]. Tests to be sure that each [Table], be that [Table] explicitly defined or implied, is "internally consistent and correct". (Relates to: correctness, consistency, completeness, accuracy)
  • US GAAP financial integrity validation between [Table]s. Tests to be sure that explicit/implicit [Table]s are properly related to one another. (Relates to: correctness, consistency, accuracy)
  • Industry standards validation. Are industry practices being followed if the applicable industry is different than US GAAP. (Relates to: correctness, consistency, completeness)
  • SEC previewer rendering validation. Test to see how the XBRL instance renders within the SEC previewer. (Relates to: consistency)
  • Comparability validation. Tests to see how well an XBRL filing can be compared to a similar XBRL filing. (Relates to: consistency)
  • Business rules validation. Tests to be sure all computations are expressed and work correctly including roll ups, roll forwards, dimensional aggregations, and other more complex computations. (Relates to: accuracy)
  • Disclosure checklist validation. Tests to be sure that all required disclosures exist. (Relates to: completeness)
  • Key performance indicators validation. Tests for wild fluctuations against internal benchmarks and industry averages.  Much like an auditor's variance analysis. (Relates to: correctness, consistency, accuracy)
  • Comparison to prior period filings validation. Tests to see if the current period filing beginning balances tie to the prior period filing ending balances. (Relates to: correctness, consistency, completeness, accuracy)
  • Best practices validation. Other common practices. (Relates to: correctness, consistency, completeness, accuracy)

 

An Auditor's Perspective

I used to be an auditor long, long ago. One of the final steps in issuing a financial report is making sure all the pieces tie together. This is my short list of the types of things I would have to look for.

  • Balance sheet. Does the balance sheet balance? Does everything foot? Does equity tie to the statement of changes in equity. Does cash tie to the cash flow statement?
  • Income statement. Does everything foot? Does net income tie to the statement of changes in equity? Does net income tie to the cash flow statement?
  • Cash flow statement. Does everything foot? Does cash tie to the balance sheet. Does net income tie to the income statement? Do the increases (decreases) in current assets and liabilities tie to the balance sheet changes?
  • Statement of changes in equity.  Does everything foot? Does equity tie to the balance sheet? Does net income tie to the income statement?

Again, this is a the short list, but you should get the point.

 

FDIC Validation Process

This may seem odd, but I think this should be included.  I learned a lot about verifying financial reports from working on the XBRL implementation by the FDIC (US Federal Deposit Insurance Corporation). The FDIC has somewhere between 1800 and 3600 business rules (I have heard both numbers, not sure which is right) that every bank call report must pass before the report is even excepted by the FDIC as a submission.  This is in addition to all the XBRL syntax validation and the other FDIC filing requirements.  Some of these business rules are made available to filers, others are "secret" rules that the FDIC uses for regulation purposes and does not make available to filing banks. Another class of rule the FDIC has is something they call "reportability rules". Those rules are driven by the type of filer.  Things like, "If you are this type of filer, then you have to report this...." and "If you report this....; then you have to report this...."

 

Defining Financial Integrity

OK, so this is my take on the definition of financial integrity. Sure, things need to be complete, consistent, correct, and accurate. But first you need a framework to work within. When you build a boat you start by building laying the keel.  When you build a house you start by laying the foundation. If the keel of the boat is sound or the foundation of the house is sound, then you are off to a good start.  But if you don't lay that keel correctly or lay a true foundation to a house, you will never be able to create a good boat or a architecturally sound house.

This is the foundation of a financial report (this is for US GAAP):

  • Balance sheet. The balance sheet always has the concepts "Assets" and "Liabilities and Equity". The value of both of those concepts MUST have the same value (i.e. the balance sheet balances.). Depending on the industry you might have "Current Assets" and "Current Liabilities" (i.e. a classified balance sheet). The computations for "Assets" and "Liabilities and Equity" foot. (In XBRL terms, you have XBRL calculations which prove that the balance sheet computations add up correctly, things roll up.) One could hang other things off the "Assets" and "Liabilities and Equity"; but you definitely have those two concepts and anything that does hang off those concepts adds up correctly.
  • Income statement. It seems that there are two concepts what every company will always have: (1) "Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, Extraordinary Items, Cumulative Effects of Changes in Accounting Principles, Noncontrolling Interest", (2) "Earnings Per Share, Basic".  There is a "step down" in the income statement, companies only have the steps if they have that component.  The components are: Income from Equity Method Investments, Discontinued Operations, Extraordinary Items, Cumulative Effect of Change in Accounting Principle.  If you have a noncontrolling interest, then net income is also broken down by what goes to the parent and what goes to the noncontrolling interest. If you have preferred dividends you need to break those out.  You may, or may not, break Income from Continuing Operations out for Gross Profit.  But, it seems that (a) one always has Income from Continuing Operations (i.e. if they don't, are they a viable business?), (b) some easy to figure out step down of net income, and (c) earnings per basic share.  (If I am wrong on this, this is the statement where I am probably making a mistake.  There may be a better way of explaining this.)
  • Cash flow statement. Every company has the concept "Cash and Cash Equivalents, Period Increase (Decrease)" (per the US GAAP Taxonomy) or I call it "Net Cash Flows".  That concept can be broken down into three other concepts: Net cash flows from operating activities, Net cash flows from investing activities, and Net Cash Flows from Financing Activities.  Companies will highly likely have operating cash flows, it could be that they have no financing or investing cash flows.  It is conceivable that they don't have operating cash flows because they are not operating companies. There are two other things which could be included in "Net Cash Flows": Effect of exchange rate on Cash and Net Cash Flows from discontinued operations.  Now, discontinued operations could be configured in a number of different ways, but it is always a part of "Net Cash Flows".  Effect of exchange rate on cash is a different story, I am getting two different messages.  Fine, one must be true.  Either it is ALWAYS part of "Net Cash Flows" (this is what I see in 99% of filings) or it could be part of the reconciliation of cash (i.e. not part of "Net Cash Flow").  Whatever concept is used for "cash" in the cash flow statement must be the same concept used on the balance sheet. This business rule is ALWAYS true: "Beginning Cash + Net Cash Flows = Ending Cash".  (Or, alternatively, if exchange gain is NOT part of "Net Cash Flows"; then: "Beginning Cash + Net Cash Flows + Effect of Exchange Rate on Cash = Ending Cash")
  • Statement of Changes in Equity. The beginning and ending balances tie to the balance sheet. Net income shown in this roll forward ties to the income statement.  (All the statement of changes in equity is, is a bunch of [Roll Forward]s.  There is a [Roll Forward] for every equity account and shares and there is a [Roll Forward] for all the periods shown on the balance sheet.
  • Policies. Some policies relate to financial statement line items.  Some don't. If they do tie to a line item, the fact that it does tie should be expressed.
  • Disclosures. Some disclosures relate to financial statement line items.  Some don't.  The ones that do tie to those line items (i.e. they are the same XBRL concept in the statement and in the disclosure). If the disclosure is supposed to foot, some business rule exists to show that (either an XBRL calculation or an XBRL formula).  Things that should be tied together are tied together, be they because they relate to the same class of stock, same entity, same class of some other line item, or in some other thing which should be tied together.

So that is the "keel" or "foundation" of a financial report, be that report expressed in the medium "paper" or in the medium "XBRL".  Clearly, whatever medium is used, XBRL or paper, the information communicated must be interpreted the same by the user of the information because it is the same information.  If that cannot happen, XBRL will never be able to replace paper and therefore paper will always need to exist.

Maybe I don't have the foundation properly expressed or 100% adequately expressed. That is not really the point here.  If I don't have it right or adequate, fine, define it correctly and define it adequately and let that be the foundation.  If there is no foundation, comparability will never happen.  And if comparability cannot happen, what is the point of tagging all this information in XBRL?  Seems to me that is the goal here, to enable easier comparability at some level.  I am not really trying to define the level of comparability.  The marketplace will do that.  But, it seems to me that this base is pretty hard to dispute. This is pretty much meat and potatoes, it seems to me.

If I am wrong and US GAAP is not even comparability at this level, then it seems we have other issues to deal with.

So that is what I see.  What are your thoughts? Do you have a better definition of financial integrity or believe that financial integrity is not important?  Post a comment.

Achieving Financial Integrity: Contrasting Paper and XBRL

A financial statement is not an arbitrary set of numbers/text. A financial statement has what I refer to as "financial integrity". By financial integrity I mean that the relations within a financial statement are sound.  For example, the balance sheet balances, the statement of changes in equity beginning and ending balances tie to the balance sheet, net income per the income statement ties to the statement of changes in equity and the cash flow statement, the proper policies and disclosures exist for line items which are used on the primary financials, and so forth.

These relations are so ingrained in accountants that they tend to disappear into the background when an accountant thinks about financial statements.  Of course the financial report ticks, ties, foots, cross casts; otherwise it would not be a financial statement.

But how does a financial report become sound, having financial integrity as I have described above? When a financial statement is created using Microsoft Word, is it Word which makes sure all the relations are sound and that financial integrity exists? No. Word knows nothing about financial reports other than how to format them and organize them into tables.  Word understands how to present things.

Microsoft Word and the printed paper report do nothing to enforce financial integrity.  An accountant who understands the relations uses the paper report to read the numbers and other contents and then uses his/her skills in accounting and usually a calculator to make sure everything adds up. Why does the accountant need to manually go through this process?  Because Word cannot help and the medium paper cannot help, other than show the accountant the information of the report.

This changes significantly with XBRL. In fact, because of the way XBRL is created after the paper or HTML version of the financial report today; XBRL is seen more of a nuisance than a helpful asset.

Here is what changes: 

  1. First off, XBRL is a different type of medium. The XBRL medium has different characteristics than paper. One of the characteristics is that computer programs can read the information in the XBRL and understand what the information means. Because computer programs can read and understand the information; the computer program can enforce financial integrity rules rather than an accountant having to do it in many cases.
  2. Because the financial information is expressed in the XBRL medium an accountant has to either (a) understands the rules of using the medium or (b) have a piece of computer software which understands the rules of the medium in order to articulate the financial information in the XBRL medium correctly. Clearly the paper financial report and the XBRL financial report need to communicate the same meaning.
  3. Because computer applications can read the information and the business rules which make sure the information has financial integrity; investors and analysts can use those same rules within analysis software to help them analyze financial information.

Again, when I say financial integrity and business rules, I am not talking about XBRL syntax rules such as "all ampersands within a text block need to be double escaped." These sorts of syntax rules and even some business semantics rules enforced by say SEC Edgar filer manual validation such as XBRL Cloud are critical; but business users should never need to deal with these sorts of things. These rules should be hidden deeply in software which simply will not let users generate the wrong syntax.

What I mean by financial integrity relates to things such as the correctness, accuracy, consistency, and completeness of the financial information. Consider this sample SEC XBRL filing which I have created. I have taken great care to make sure the HTML has financial integrity. The XBRL medium version of the report must likewise have financial integrity.

I have taken great care in creating the XBRL version. Regretfully, like most other software out there these days the software does not really help you create the XBRL with financial integrity.  Instead, I have to run validation reports to test the report after it is created.

What validation did I perform? Here is a list:

  • Edgar Filer Manual validation (complements of XBRL Cloud), which shows that I have zero errors.
  • XBRL calculations validation (complements of UBmatrix) which shows that certain computations add up.
  • XBRL formulas validation (complements of UBmatrix) which shows that other more complex computations add up such as roll forwards and aggregations of dimensional information. (Note that there are 24 such business rules.)
  • XBRL US consistency checks (complements of XBRL US) which checks for internal consistency of the information. (I don't have a physical report yet, hoping to get that. When my XBRL instance was first run against these consistency checks I discovered that my outstanding shares and issued shares of common stock did not properly relate and that I did not include earnings per share in my example which is a required disclosure for public companies). I still may have some errors in this category, this testing is not 100% complete as of yet.)
  • Manual review. There is still that manual review that needs to take place, cannot get around that.

While achieving financial integrity today can be challenging because these sorts of business rules are not broadly available, few software applications support things like XBRL Formula validation (there are some), and the XBRL medium is not well understood by accountants; it is possible to do substantially better than most SEC XBRL filers are doing today. The first step is realizing that this not only can but must be achieved to make the information useful to those using the information for analysis.

In my next blog post I will provide an explanation of specific financial integrity rules at the high levels of a financial report.  If you look at the XBRL Formula linkbase file of the example you can see most of these rules. The problem with that is the raw formulas can be challenging for accountants to read. Don't worry about that in the long term, software will make that much easier.