19. Inventing Double-Entry Financial Analysis

All of the financial information in the world comes from double-entry data. Regardless if we are quantifying earnings, assets, or liquidity ratios, the underlying data that is the basis of our analysis is made up of the records of double-entry bookkeepers.

Accounting has been called the “language of business.” This business for which accounting provides a language is an activity, an ongoing process of trading goods and services to others. To serve as the language of business, accounting must provide the record of an activity rather than a simple status. The activity that is measured by the financial records of accountants is the flow of financial resources from one place to another. The purchase of a retail item involves the flow of cash from a customer into the company’s assets and the flow of inventory from the company’s stocks to the consumer. The payment of an expense involves the flow of cash, or its equivalent, for a service provided the company. All double-entry data is the record of the activity of financial resources flowing from one place to another.

The “double” in double-entry is the critical tracking of the flow of financial resources. Each transactions involves the record of a withdrawal (“credit”) from one place and a corresponding deposit (“debit”) to another. If bookkeepers are only going to keep the record of certain financial balances, single-entry bookkeeping would be sufficient, but, if they are going to keep track of an activity, they need to maintain a record of the “before” and “after” images of the financial state. This “double” in double-entry provides the record of an activity – the activity known as business.

However, because of a lack of automation, the summaries of these financial flows have been historically limited to the report of static balances and the changes to those balances occurring during certain time periods. The Balance Sheet reports the surplus of deposits over withdrawals in all of the permanent accounts. The Income Statement reports the differences between the balances accrued to the revenue accounts and those accrued to the expense accounts. Each statement reports the amount of accumulation in each account rather than the actual flow that has occurred between the accounts and was faithfully reported by the bookkeeper. While the data recorded is of dynamic flows, the reports that run our economy are of static balances.

With the age of automation and the ability to more finely summarize the double-entry record of flows, we have gained some insight into financial flows. In the 1980’s, the Cash Flow Statement was introduced, showing the sources and destinations of resources flowing into and out of the cash account. However, for no other reason than the clumsy methods of traditionally producing financial reports by hand, the Cash Flow Statement has been difficult for most companies to produce. This difficulty can be simply overcome by the application of appropriate information design techniques. With modern information technology, not only can the Cash Flow Statement be produced with a trivial single database command, but the quantifying of all flow, not just cash, can be reported and analyzed.

The technique of producing a summary of all of the flows in an accounting system will revolutionize financial information in the twenty-first century. A single database query can produce a report showing all of resources that have gone from every account to any other account. This simple process can provide not only a Cash Flow Statement and all the other standard reports, but also the financial profile of the complete activity of the business. Accounting, as it is recorded, is the language of business, but now, with modern automation and wise information design, it can also produce reports that will be the language of business – the true power of double-entry bookkeeping can be unleashed by double-entry reporting.

17. Ancient Data Warehousing

Although it only now has become a common term as the core of business intelligence, the practice of data warehousing has been with us for over five-hundred years. Since the early Italian renaissance, merchants have kept databases of their business transactions wherein each transaction was related to the critical dimensions that characterized its type and the effect that it had on the business.

More specifically, each transaction, representing a transfer of financial resources from one place to another, was related to the source and destination of the transfer. Each transactions was related to the place from which it was withdrawn and the place to which it was deposited in what has come to be known as double-entry bookkeeping. The record of the withdrawal was referred to as the “credit” entry and the record of the deposit was referred to as the “debit” entry.

Like all data warehouses, each of transactions was also related to the date of its occurrence, allowing the merchant to sort and sum the transactions to measure the activity of the business during given periods of time. Furthermore, the financial state of a business could be determined by summing the deposits to a given account, then summing the withdrawals from the same, and finding the account’s “balance,” or state, by subtracting the withdrawals from the deposits.

This process of relating transactions to its critical factors (“dimensions”) and summing the transactions according to these critical factors is exactly how a modern data warehouse is used. The data warehouse, the central focus of the field of business intelligence, is universally implemented as a multidimensional database. The multidimensional database, like the bookkeeper’s journal, is made up of chronologically ordered records that represent business transactions with each transaction related to the customers, products, accounts, dates, and other “dimensions” of its existence. The data warehouse is, in effect, a journal of business transactions in the same way that the accountant’s book of original entry (his “journal”) is.

So, what is the difference between a traditional bookkeeping journal and a modern data warehouse? Only the existence of the SQL language (or some equivalent database query language). The modern query language, allows the user to sum and sort transactions by any combination of its many dimensions, including the transactions date and its debit and credit accounts.

Because the renaissance bookkeeper did not have modern database automation, he needed to first sort the transactions into individual databases (called “ledger accounts”) and then sort them again into rigid time frames (called “reporting periods”). Because of these once necessary and arduous sorting tasks, the business intelligence of times past was slow, expensive, error-prone, and untimely. And because we have not integrated financial reporting and analysis into common business intelligence practices, financial information has continued to be untimely to this day.

6. The On-Demand Cash Flow Statement

The cash account should always have a debit balance or be equal [zero balance].
Otherwise, the account will be in error.
Luca Paciolo, Particularis de Computis et Scripturis

The Cash Flow Statement is nothing more than a summary of activity in the company’s cash account. It summarizes how the cash account was debited and credited by the company’s operating, investing, and financial activities during a particular period of time. The debits are referred to as “input” in the report while the credits are therein referred to as “output.”

Typically, a Cash Flow Statement, like an Income Statement, summarizes activity for a particular fiscal period. However, unlike the Income Statement, the Cash Flow Statement does not require that the company’s books be closed before its preparation. This means that, although the Cash Flow Statement summarizes a time period, it is not locked into the constraints of a fixed fiscal period such as the Income Statement is. A Cash Flow Statement could, theoretically, be prepared at any time without the closing of the books and the use of temporary accounts that exist only for the company’s fiscal period.

The Cash Flow Statement could be prepared on a weekly, monthly, or even daily basis. The only impediment to this powerful ability to create useful information is the intensive labor that is required to create the Cash Flow Statement and the only solution to this impediment is to store all of the financial transactions in a data warehouse. A Cash Flow Statement for any time period desired can be prepared effortlessly in seconds with a simple command to a well-designed financial data warehouse.

The use of a data warehouse to back up an accounting system (or be the accounting system) is the key to producing real-time financial statements for arbitrary time periods. This fact is most apparent in the case of the Cash Flow Statement and its growing importance within the company. See Banking the Past, p. 169.