Lean Accounting with Event Types

In a period of economic downturn, competitive advantage goes to those companies that can reduce their expenses and operate more efficiently than their competitors. The purpose of this post is to investigate how companies can reduce their bookkeeping expenses, a burden that is common to every business in existence. Can most financial recording be made simple enough that it does not require a skilled financial worker to perform the chore and can it be done with a minimal amount of data-entry labor?

For most transactions within a typical company, the answer is an obvious “yes.” This is evidenced by the use of modern Point-of-Service (POS, i.e. cash registers) that are implemented with software that automatically records the critical accounting data of each revenue transaction as it occurs. Thousands of transactions are fully recorded for the company’s accounting system with the mere push of a button by a relatively untrained clerk at a check-out counter. Many business transactions are already fully automated and are nearly costless to the business.

But, there are many other forms of business transactions than the revenue-generating operations that occur essentially within a cash register. Expenses, capital investments, depreciation, and payment of credit are just some of the transactions that cannot be handled by the modern cash register. However, as we will see, these less automated transactions can also be reduced to a minimum effort by people who have no bookkeeping skills.

How can advanced bookkeeping be accomplished by people who do not understand debits and credits? To fully satisfy all of the requirements of the Generally Accepted Accounting Practices, the only thing that a worker would have to do is enter the amount of a transaction and select the type of event that the transaction represents. The selection process would be made easy with a user interface that presents the various “Event Types” in an intuitive and foolproof manner.

Hidden within each “Event Type” would be the identity of the accounts that are credited and debited. The person doing the bookkeeping could be an untrained clerk who has been given a simple introduction to the few Event Types that are affected by his role in the company. The selection of debit and credit is transparent to him, making the bookkeeping process simple.

The person entering data would also have control to set the date, but the default of the current date would suffice in the vast majority of cases. The Event Type would supply a default note about the transaction, which the user could also edit at his own will.

In summary, very advanced bookkeeping could be performed by the unskilled by simply selecting the type of the event and entering the amount. The particular Event Types and the accounts that they affect could be tailored to fit any business model in any industry. The resulting effect of the use of Event Types would be to reduce the most challenging bookkeeping operations to an operation requiring less skill than the operation of a cash register.

21. Finance is all about Flow

Essentially, double-entry bookkeeping is a process by which business entities track the flow of resources from one place to another. However, because accounting reports were developed when computational tools were limited or nonexistent, they do not report a measurement of this all important flow.

Contrary to myth, the recording of each transaction in two places is not a method of error checking; each of the two data entries of an accounting transaction has a specific meaning that allows businesses to maintain a record of their dynamic activity, rather than mere static positions. The two entries of double-entry bookkeeping, of course, are called “credit” and “debit.” The credit entry represents a withdrawal from the source of the transfer and the debit entry represents a deposit in the transaction’s ultimate destination. By entering both the credit and debit ends of resource transfer, the bookkeeper is actually producing a complete record of a movement of financial resources, a “flow” of resources from one place to another.

The standard GAAP reports are all produced from the balances that remain at the various source and destination accounts. With the exception of the Cash Flow Statement, they do not report the important record of what is originally recorded by the bookkeeper – the actual flow of resources that occurs between various accounts. This is surely a product of the crude and limited computational tools that were available to the originators of the reports. Perhaps with the recent invention of the Cash Flow Statement, however, this limitation is beginning to change.

The Cash Flow Statement represents a leap forward in accounting practices. It reports more than the existing balances within various accounts; it actually attempts to track the flow that changed those balances during a period. The Cash Flow Statement, however, is limited to only those flows that affect the Cash account, but it perhaps points to the potentially much greater amount of information that can be produced with modern automation.

With modern automation and data structures, the Cash Flow Statement, or even a more general flow report, should be the easiest to produce. That fact that it is problematic for most accounting departments is a result of the fact that financial reports are produced from the resulting balances in accounts rather than the potentially trivial process of measuring flow by simply totaling all transactions by the combination of the account that they credit and the account that they debit.

A complete report of the total amount of flow between all of the accounts can be done easily with modern data warehouse architecture and, from these total flows, we can measure the changes of balances that they cause and thereby produce all of the other GAAP reports. Furthermore, we can keep a database of daily flows that would allow us to produce dynamic reports for arbitrary windows of time, rather than the current practice of generating reports for specific periods only.

20. Credits are Negative Debits

This entry is a short excursion into elementary number theory, an area of mathematics that would appear to have little to do with financial data, but which, in fact, lies at the heart of very heart of the process of keeping financial records.

Historically, numbers have represented magnitudes. The quantities of sheep in a flock, fish in a basket, or wives belonging to a rich husband were all magnitudes that required the invention of numbers to communicate. As a number, quantities were expressed simply as amounts, volumes, or other positive magnitudes. They had no meaning other than as positive amounts and they could only be combined with other positive amounts to produce new positive amounts, or compared with positive amounts, resulting in a ratio that was always positive.

All magnitudes can be fully expressed as positive numbers. The number zero is not needed because there is no such thing as a non-quantity. In a like manner, negative numbers are not needed to express magnitude because there simply is no such thing as a negative quantity. Historically, this purpose of expressing magnitudes defined what numbers were and determined the boundaries of numbers that made sense.

Eventually, the number zero was added as a place holder when larger numbers became expressed with a positional notation that aligned them in columns. This first occurred in India and eventually spread to Europe and became our modern number system. However, for centuries, only the concept of zero was added to positive numbers as they continued to only represent the magnitude of quantities.

Numbers continued to exist as positive expressions of magnitude until the nineteenth century when numbers, including integers, fractions (rational numbers), and amounts exacted with decimal points (“real” numbers), all morphed into something that has both a magnitude and a direction, a very elementary one-dimensional form of what engineers refer to as a vector. Today’s numbers have the magnitude that is expressed as the size of the number and a direction that is expressed as the number’s “sign.” A modern number has a sign that designates it as a positive or negative value, the negative values being those that are less than zero.

The significance of the revolution that gave the modern number a direction to go with its magnitude is that it is far more flexible and powerful to use. Where it once could only measure positive quantities and be combined and compared to other positive quantities, it can now be used to combine and compare opposition. The electrical engineer can use formulas that work with electricity of both positive and negative charge; the structural engineer can find the resulting force that is composed of both a left and right component, and the mathematician can find a valid answer when a larger sum is subtracted from a smaller. The modern idea of a number has given our industrial society a technical sophistication that was not possible with the numbers used by Isaac Newton and Galileo.

But, in the area of financial analysis, the idea of a number remains locked in its ancient manifestation as a magnitude without direction. The numbers that move our equity markets and shake our governments are the balances of accounts that are without a sign (until when a loss is reported to a general public that fully comprehends the negative direction of a number). Financial numbers come from obfuscating algorithms that are only necessary to compensate for the lack of numeric direction and that only accountants understand. The simplest and most intuitive business concepts are made difficult and obscure because modern accounting was invented before we gave numbers direction and they remain unchanged because of traditions and practices that are long past rendering a service to the world of information.

A credit is a withdrawal and is the negative of a debit that represents a deposit. Given its proper representation as a modern number the financial balance becomes a simple and intuitive concept that opens a whole new world of information to the information starved decision-maker.

18. Obscuring the Obvious

Accounting is an intuitive and easy to understand subject when it is taught from its original principles. Its underlying mechanics, double-entry bookkeeping, is simply the process of recording both the source and destination of any flow of financial resources. Each financial transaction is recorded as a withdrawal from some account and a deposit into another.

In addition, the formal structure built atop double-entry bookkeeping, the financial reports proscribed by GAAP, is simply the sum of deposits and withdrawals into various categories of the accounts. These categories are based upon the basic concepts of business and finance. Revenue represents the money that was received by customers, expense accounts represent payments and obligations of the company in the course of earning revenue, and the difference between revenue and expenses represents the earnings of the company. These are things that every business person already works with and that the commercially naïve can grasped easily.

However, accounting, as it is taught in schools, is a difficult subject that cannot be comprehended logically and requires large amounts of rote memorization to be mastered. Why? Because today’s accounting teachers have learned the subject through rote memorization and have therefore fail to provide students the original meanings of the subject.

For example, Accounting students are taught that debit and credit simply mean respectively “left” and “right” and that any further reading into these concepts is unproductive. The bookkeeper must enter a “left” entry someplace as well as a “right” entry someplace else. Having no other meanings to guide him, he must memorize where to make the left entry and the right entry for every type of business transaction that the company enters into. In fact, debit has a Latin origin which specifies it as the destination of a flow of resources and credit, in turn, indicates the source of the flow.

This confusion is compounded by the so-called “accounting equation.” The accounting equation is, in fact, mathematically incorrect and its imprecision further obscures the bookkeeping process and the ultimate meaning of the data produced by bookkeepers and accountants. One of the unfortunate products of the accounting equation is that, like any equation, it has an equal sign with various terms on each side of the equal sign, and bookkeepers are told that the side of the equal sign that a term is on determines when to make the “left” and “right” entries for a transaction. Not only is the poor student required to memorize when to left and when to right, but he must memorize where an account is within the accounting equation to change left to right and right to left. In reality, the left entry indicates a deposit of resources and this meaning never changes. Likewise, the right entry indicates a withdrawal, regardless of the erroneous equation. See http://accounting-equation.blogspot.com.

These are the beginnings of serious obscurities that have kept the all-important financial data produced by accounting from investors, managers, and other resource allocators. We can make these concepts simpler by returning to their original meanings and doing so will make our economy more efficient while not changing the fundamental mechanics of double-entry bookkeeping.

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.

15. Financial History

Double-entry bookkeeping has been the traditional way of keeping track of a company’s revenue, expenses, and other financial categories for over five-hundred years. Proven by the test of time, double-entry bookkeeping is a powerful technique for recording the dynamic activity of trading wealth.

The importance of double-entry bookkeeping cannot be overstated. Because it allows the activity of trading to be accurately recorded, it actually makes trading more efficient and productive. As trading is made easier, the productivity of an economy is increased because its members are more able to exploit divisions of labor and the other comparative advantages that trading makes possible.

Why has double-entry bookkeeping been such an important part of our economic reasoning and why will continue to be in the future? Because the “double” in double-entry bookkeeping supports the recording of dynamic processes as opposed to simple static states. By relating each single transaction to two of its critical dimension, the bookkeeper memorializes the activity that occurs during a trade. Rather than just measuring the amount of wealth at a given location with single entries, double-entry measures the actual activity that occurs as financial resources are moved from one place to another.

The two entries that make up the double-entry record both the source and destination of a flow of resources (a trade). The entries record from where the resources are withdrawn (the “credit” entry) and to where they are deposited (the “debit” entry). From these two entries, enough information is recorded to allow an analyst to unwind a company’s history to any point in its existence. While a single entry may be sufficient to keep track of the balance in our checking account, two entries are necessary to keep track of the activity that creates those balances (see The Tao of Financial Information).

In later posts to this blog, double-entry bookkeeping will be explored as the foundation of our knowledge of commercial trades. Rather than question the efficacy of double-entry bookkeeping, we will show how this powerful technique can be expanded in the age of the computer to further empower the “knowledge is the business” company.

13. Daily Account Balances

In the preceding post, the production of a trial balance on a daily basis was proposed. By simply using the power of the computer to add a few numbers together, a complete trial balance should be available as soon as the business transactions are recorded. It was also shown how to-date earnings and other information could be produced at little or no cost from this trial balance.

A trial balance, however, has the formality of being part of the official quarterly report preparation process and, since we are just trying to get critical information quickly to the company’s executives, we get dispense with formalities and just talk about producing real information on a real-time basis. Balance sheets, trial balances, and income statements aren’t as important as the information contained in them, and we can produce that information as easily as the dashboards in our car produce current information about speed and mileage. There is no reason why every detail of a company’s financial data could not be made available to corporate leaders on a daily basis.

The general ledger is made up of accounts; each account has entries in it that represent deposits (debits) or withdrawals (credits); and each account has a balance that represents the sum of the deposits and withdrawals. The account balances of the general ledger are really all that is needed to easily produce the information found in the formal GAAP reports.

Because this is the twenty-first century, we can assume that the general ledger is automated and that the entries in each account are recorded by a program. As easy as it is for the program to record the entry, it can also keep the running balance of the account, adding a ten dollar debit entry could automatically update the running balance ten dollars in the debit direction. An automated running balance means that the balance of every account in the General Ledger (representing all of the financial data in the company) is available to us as quickly as the data is posted.

This means that for any company large enough to have its bookkeeping on a machine of laptop power or greater, the account balances should be always available. The account balances are the details of the trail balance that was discussed in the previous post, so we are essentially where we were in the previous post, having the ability to present all of the critical GAAP quarterly report information to executives on a daily basis (see previous post).

More essentially, it can be shown that if we have the account balances available to us, it is simply a matter of grammar school arithmetic to produce totals of assets, liabilities, revenues, expenses, and earnings (revenues less expenses).

Quarterly reports can be converted into real-time dashboard information by simply performing trivial arithmetic on the ledger account balances that should be available and current at any point in time. Greater sophistication can be made real-time by making accrual entries daily (this will be the subject of a later post).

4. Virtual Balances

The smallest operations can now afford financial control programs that
account for their finances with greater speed and sophistication that even the
largest corporations could have achieved through their production hierarchies a
few decades ago.

James Dale Davidson and Lord William Rees-Mogg

Financial sums are most essentially the finished product of an arithmetic process. For example, the balance of a particular account is really the result of adding all of the deposits (debits) and subtracting all of the withdrawals (credits). It is just a matter of addition and subtraction, an operation that humans do laboriously and erratically but which is done effortlessly and flawlessly my machines.

The same can be said for the other monetary amounts that we use to determine the value of a business and its success or failure. Income is the sum of all of the revenues and expenses that occur to a business during a given period of time; the term “assets” is the sum of all of the resources available to the company; and the term “retained earnings” is the owner’s book value based upon the simple sum of the company’s assets and liabilities (liabilities are actually subtracted from the company’s assets). Financial data is basically the finished product of some very simple arithmetic operations.

The importance of this observation lies in the disparity between the computer’s ability to perform millions of arithmetic operations perfectly each second while humans must struggle to do the same in many months of effort with a paper and pencil. Because of computer’s computational power, the value of the finished product of the arithmetic approaches zero. If you can perform a million operations effortlessly and in virtually no time, you can perform those same operations again and again at no cost, making the value of sums as free as air. The sums of the operations become valueless while the value of the input data to those operations (the amounts of simple financial transactions) increases in value (since they can be reused effortlessly in many different combinations to produce unique new sums).

In the twenty-first century, only the simple data that summarizes the simple atomic financial transactions needs to be stored in the computer. The sums and balances that affect our financial markets will be produced upon demand by machines that are imbued with the intelligence of how those sums and balances can be produced from the rawest of data.

3. Double-Entry Bookkeeping

Double-entry bookkeeping allows merchants to categorize historical events in such a manner that they can be quantified and numerically analyzed as a dynamic process. It preserves the before-and-after character of the events in such a manner that allows a previous financial state to be completely reproduced by the analyst.

Because of the invention of double-entry bookkeeping, financial information has become time-dimensional, giving us historical snapshots that can be sorted and summed into the analytical forms that we know as financial statements – the headlines that produce a quick snapshot of a company’s financial flow of resources.

We can maintain a financial balance by making single-entries in a ledger, in a manner similar to how we keep a balance in our checkbooks. However, to be able to identify and analyze the changes to our financial state over time, such as we do when we determine earnings and income, it is necessary for us to record both the origin and destination of a financial movement. The origin is what we refer to as the “credited” account and the destination is what we refer to as the “debited” account. See p. 65, The Tao of Financial Information.

2. Debit and Credit

Although the financial information that has so much power over our lives is ultimately recorded in the binary language of debits and credits, very few people, including many accountants, actually understand what these terms mean.

For most accounting departments in academia, it is sufficient to disregard any meaning that the inventors of double-entry bookkeeping may have intended for the concepts of debit and credit and to have their students simply memorize the position where the debits and credits are placed in the books. No regard is made for the possibility that the terms were selected by the ancients because of a true conceptual significance.

The term “debit” is derived from a Latin root that means “to owe,” while the term “credit” is from a Latin root meaning “to be owed.” As this etymology indicates, the debit of a transaction is applied to the account that receives a financial resource and a credit is applied to the account that is the source of that financial resource, the “debtor” and “creditor” respectfully.

During the time when a business is viable, the accounts that represent the resources that are available to the business, it assets, are net receivers of resources. The company has existing assets because it has received more than it has distributed – it is a net receiver and the accounts that represent what it has received typically have debit balances.

During this time of business viability, the outside world is the source of the company’s assets, either through ownership contribution, loans, sales, or some other form of internal flow of resources into the company. The accounts that represent these outside sources therefore have net credit balances, indicating that they have served as sources and, in the case of the business’s liquidation, may possibly have returned what they contributed and are owed as “creditors” or “owners.” See The Tao of Financial Information.

1. The Accounting Equation

The accounting equation, which forms the basis all of our financial reporting, contradicts the basic tenants of double-entry bookkeeping. If we follow the principles of double-entry accounting, we violate the accounting equation, and, if we follow the directions implied by the accounting equation, we violate the principles of double-entry accounting.

The accounting equation states that resources available to the business (its assets) must be equal to the claims of its financial sources (its equities). In algebraic terms, it is generally expressed as:

Assets = Liabilities + Owner’s Equity

The Assets term represents the resources available for the company to make use of, typically buildings, equipment, and other valuables. The terms on the right of the equation, the Liabilities and the Owner’s Equity terms, represent the claims of parties outside the company to the assets of the company. The Liabilities term represents the claims of creditors upon the company’s assets and the Owner’s Equity term, as its name implies, represents the claims of the owners to the assets that remain after the creditors have been satisfied. For simplicity of expression, we will combine these two terms, referring to them as the “External Claims” or, more simply, “Externals.” This leaves the accounting equation as this simple expression:

Assets = Externals

However, for the purpose of this paper, this expression is preferred because of its simplicity and the fact that the distinction between different types of external claims does not change the underlying problem with the equation itself.

The importance of this accounting equation cannot be overstated. The balance found between the two sides of the equal sign forms the foundation of the balance sheet financial statement. Furthermore, the other traditional financial statements are also derivations of this critical mathematical expression.

Despite its critical importance to the financial world, the accounting equation is invalid and this invalidity can be illustrated by a simple example of an investment made by an owner of a business. In this example, the owner of the business invests $100.00 in cash to his business. His accountant keeps track of the transaction by making an entry in his journal. Following the rules of double-entry accounting, the journal reflects the following changes to the financial state of the company:

• The Cash account is debited $100.00, and
• The Owner's Equity account is credited $100.00.

Together, these changes assure us that the balance of all of the accounts in the business are equal to zero – a debit made to the Cash account is balanced by a credit to the Owner's Equity account. Double-entry accounting assures us that the books remain in balance because every debit made to one account is countered by a credit made to some other account -- subtracting all of the credits from the debits leaves a total balance of zero. This pure balance of zero maintained on the accounting books reflects the grace and credibility of double-entry bookkeeping.

However, the accounting equation contradicts this. According to the equation, the transaction in our example should have reflected the following changes to the financial state of the company:

• The Cash account is debited $100.00, and
• The Owner's Equity account is debited $100.00.

According to the accounting equation, both accounts must be debited to properly record the owner's investment in his business and here is why:

• Again, the accounting equation states the following:

Assets = Externals

• According to the rules of algebra, the equality of the equation remains valid after I have added new terms to the equation as long as I add the same terms to each side of the equation. "When thinking about equations, consider an old-fashioned balance scale. To keep the scale balanced, whatever you do to one side must be done to the other. If you add 2 pounds to one side, you must add 2 pounds to the other." [Brita Immergut and Jean Burr Smith, Arithmetic and Algebra ... Again (New York: McGraw-Hill, 1994) p. 198] Applying this mathematical principle to the accounting equation, I can do the following:

Assets + 1 = Externals + 1

• More to the point, I can, following the rules of algebra, do the following:

Assets + Debit = Externals + Debit

• However, what I cannot do is the following:

Assets + Debit = Externals + Credit

This last expression cannot be done using the rules of algebra. We can change an equation by doing equal things to both side of the equal sign, but we cannot do unequal things to both sides of an equal sign and maintain the state of equality. But this last expression is exactly what is done in double-entry accounting, leaving us with only one of two possible conclusions, either:

1. the accounting equation is a correct application of algebra and we must abandon double-entry accounting, or
2. there is something wrong with the accounting equation and double-entry accounting remains unchallenged and as credible as ever.

We can relax in the comfort of knowing that the problem is not with double-entry accounting -- the contradiction found between it and the equation can be resolved by recognizing that it is the equation that is wrong. The expression:

Assets = Externals

appears correct only because it is comparing the quantities of the Assets and Externals and ignoring the fact that they are opposing qualities -- the Assets are normally debit in nature while the Externals are normally credit in nature. By disregarding the opposing natures on each side of the equation, accountants have assumed equality where equality has never existed.

If Assets are not equal to Externals because they are in opposing directions (debits vs. credits), what is the correct form of the accounting equation? Since debits and credits are opposite in direction from each other and cancel each other out in accounting's use of arithmetic, the proper form of the accounting equation is as follows:

Assets + Externals = 0

This expression states correctly that the two terms are equal in magnitude but opposite in direction. They cancel each other out and leave the books in the state of perfect balance at zero.

Furthermore, when we perform the double-entry bookkeeping of our example, we make the following algebraic manipulation:

Assets + Externals + (Debit + Credit) = 0 + (Debit + Credit)

which again means that, after we cancel out the effects of our debit and credit additions, we are left stating that Assets and Externals remain equal in magnitude but opposite in direction:

Assets + Externals = 0

This form of the accounting equation is correct algebraically and it supports the double-entry accounting process, assuring us that, regardless of the type of commercial transaction we record, the amount of resources available to a business is equal in magnitude to the claims upon its financial sources. The financial world remains secure in knowing that a properly maintained accounting system will always have a perfect balance – the sum of all of its accounts will always equal zero. See The Tao of Financial Information.