The bank I was working with recognized that they had numerous reporting systems dealing with the details of various customers. These details weren’t in the General Ledger, but they were maintained in other, ancillary systems. And these other systems weren’t built to the standards of a general ledger. Rather, often they were made to reconcile to some portion of the general ledger, perhaps after the fact, with adjustments made in numerous places. The finance organization had a single-minded determination to build a system capable of keeping these details.
With time, it became clear that the general ledger could not be expanded to keep all these details. Numerous discussions were had about the required form of the system. The technical team pointed out that any system that can maintain the details is capable of being the source for the summary. Yet to the finance team, the notion of a finance system without a general ledger, or a general ledger which is so radically different from anything owned by any other company, was just a bit too risky. Thus the idea of the Arrangement Ledger (AL) was born.
In a very similar manner to the General Ledger, the AL takes in journal entries, and posts them to the Arrangement Ledger. This might be done by simply adding an additional key, called the Arrangement ID, to the list of fields above to each journal entry and to the ledger.
Arrangement Defined
What is an arrangement ID? This could be a very lengthy discussion in some circles, but for our purposes, let’s describe it as a specific customer contract. For example, if my company takes out a loan from the bank, that creates an arrangement. The arrangement ID might be simply composed of an ID from the source system that holds my loan details1, and the loan number.2
By adding an arrangement ID onto the journals and the ledger, the balances accumulated now represent the balances for my loan. Within this same ledger, balances for any other loan are simply another set of rows.
Millions of “Ledgers”
The addition of this key has transformed the system from something containing a set of rows describing point in time balances for the entire company, or perhaps more accurately sets of rows describing each of the legal entities or companies, into a set of rows which describe an individual customer contract.
Let’s be clear; there is not just one row for each customer contract. There are multiple rows for each customer contract because each customer contract is composed of multiple balances. There is a row that represents the principle of the loan, another for the interest payable, another for the fee revenue, another for accrued taxes. Typically, the General Ledger account, in combination with the arrangement ID would make each row of the Arrangement Ledger unique.3
Thus the Arrangement Ledger would contain millions even tens or hundreds of millions of tiny little ledgers, each reflecting the position of an individual customer contract as of a point in time.
Transactions Versus Balances
But wait, you say; this sounds like a summary structure of some kind. And you would be right. Producing all the financial information from the transactions is unrealistic for a large bank. Insurance companies, even the largest, may be able to do so. This is because the business events with customers occur on average a few times a year. But banking transactions often occur multiple times each day, even each hour. In these instances, the volume is simply too high. Also, unlike insurance which requires tracking trends over longer periods of time, the value of the historical transaction data to banking is lower and diminishes very quickly.
Yet by creating an Arrangement Ledger, summarizing as an accommodation of the machine capacities, provides most of the benefits of the transaction data. Using the concepts explained in Movements is critical to managing the size of the Arrangement Ledger data store. Maintaining arrangement details with a pure balance based approach for a large organization is likely impossible, and likely too expensive for any but the smallest organizations.
Additional Attributes
Remember that by summarizing by a selected set of attributes – like the accounting code block in the general ledger above – we eliminate other views of the data. Thus creating these tiny ledgers is not very transformative in itself. The additional attributes that describe the customer and the contract are the items of interest for so many other types of financial reporting.
If, in addition to the accounting code block we use in the general ledger, we attempt to summarize by all the other attributes, we (1) begin to store the same values on multiple records, because the contract and customer attributes describe the entire arrangement, not the individual balances, (2) we create a “reclassification” nightmare as the attributes change, needing to move balances between these attributes, (3) we destroy the ability to show the values historically.
Our choice of the customer contract level – the arrangement level – is not by mistake. Rather, by summarizing to his level, we have preserved the ability to capture and report all these metrics, every summarized balance, by any attribute which describes the customer or contract.
For example, if the following were the balances for a simple General Ledger:
At the General Ledger level, data is at a summarized level; the arrangement ID is not meaningful. This shows us that for account 60010, cost center 887, and the rest of the values, the balances as of this 9/10/2009 is 984,309.82.
The arrangement balances that make up this single summary balance might be the following. Note that there are three different arrangements, each with the same set of attributes that make up this one balance.
By just adding an Arrangement ID to the record, additional attributes can be stored in the arrangement ledger, without causing the balance to be shifted each time one of these other attributes changes. Because Arrangement ID must be unique, they can be used to link to additional information as is shown below on the Standard Arrangement Layout, or SAL records.
Then it would be possible to combine the amounts in the arrangement ledger, and the SAL, and produce a view of the arrangement balances such as this:
By organizing our arrangement ledger in this manner, we have created a single system capable of producing thousands of summaries from the same consistent, controlled set of numbers that feeds today’s highly respected financial systems.
Parent Topic: Part 6. The Platform