In the previous chapter, tentative financial statements were prepared directly from a trial balance. However, a caution was issued about adjustments that may be needed to prepare a truly correct and up-to-date set of financial statements. This occurs because of multi-period items (revenue and expense items that relate to more than one accounting period) and accrued items (revenue and expense items that have been earned or incurred in a given period, but not yet entered into the accounting records). The latter are commonly called accruals.
In other words, the ongoing business activity brings about changes in account balances that have not been captured by a journal entry. Time brings about change, and an adjusting process is needed to cause the accounts to appropriately reflect those changes. These adjustments typically occur at the end of each accounting period, and are akin to temporarily cutting off the flow through the business pipeline to take a measurement of what is in the pipeline. This is consistent with the revenue and expense recognition rules described in the preceding portion of this chapter.
There is simply no way to catalog every potential adjustment that a business may need to make. What is required is a firm understanding of a particular business’s operations, along with a good handle on accounting measurement principles. The following discussion describes typical adjustments. Strive to develop a conceptual understanding of these examples. Critical thinking skills will then allow extension of these basic principles to most any situation. The specific examples relate to:
It is quite common to pay for goods and services in advance. One has probably purchased insurance this way, perhaps prepaying for an annual or semi-annual policy. Or, rent on a building may be paid ahead of its intended use (e.g., most landlords require monthly rent to be paid at the beginning of each month). Another example of prepaid expense relates to supplies that are purchased and stored in advance of actually needing them.
At the time of purchase, such prepaid amounts represent future economic benefits that are acquired in exchange for cash payments. As such, the initial expenditure gives rise to an asset. As time passes, the asset is diminished. This means that adjustments are needed to reduce the asset account and transfer the consumption of the asset’s cost to an appropriate expense account.
As a general representation of this process, assume that one prepays $300 on June 1 to receive three months of lawn mowing service. As shown in the following illustration, this transaction initially gives rise to a $300 asset on the June 1 balance sheet. As each month passes, $100 is removed from the balance sheet account and transferred to expense (think: an asset is reduced and expense is increased, giving rise to lower income and equity).
$300 is paid in advance on June 1 for three months of lawn mowing service
Examine the journal entries for this illustration, and take note of the impact on the balance sheet account for Prepaid Mowing (as shown by the T-accounts at right):
ILLUSTRATION OF PREPAID INSURANCE:
Insurance policies are usually purchased in advance. Cash is paid up front to cover a future period of protection. Assume a three-year insurance policy was purchased on January 1, 20X1, for $9,000. By December 31, 20X1, $3,000 of insurance coverage would have expired (one of three years, or 1/3 of $9,000). The following entries would be needed to record the transaction on January 1 and the adjustment on December 31:
As a result of the above entry and adjusting entry, the income statement for 20X1 would report insurance expense of $3,000, and the balance sheet at the end of 20X1 would report prepaid insurance of $6,000 ($9,000 debit less $3,000 credit). The remaining $6,000 amount would be transferred to expense over the next two years by preparing similar adjusting entries at the end of 20X2 and 20X3.
ILLUSTRATION OF PREPAID RENT:
Assume a two-month lease is entered and rent paid in advance on March 1, 20X1, for $3,000. By March 31, 20X1, half of the rental period has lapsed, and financial statements are to be prepared. The following entries would be needed to record the transaction on March 1, and adjust rent expense and prepaid rent on March 31:
HOW OFTEN ARE ADJUSTMENTS NEEDED?
In the illustration for insurance, the adjustment was applied at the end of December, but the rent adjustment occurred at the end of March. What’s the difference? What was not stated in the first illustration was an assumption that financial statements were only being prepared at the end of the year, in which case the adjustments were only needed at that time. In the second illustration, it was explicitly stated that financial statements were to be prepared at the end of March, and that necessitated an end of March adjustment. There is a moral to this: adjustments should be made every time financial statements are prepared, and the goal of the adjustments is to correctly assign the appropriate amount of expense to the time period in question (leaving the remainder in a balance sheet account to carry over to the next time period(s)). Every situation will be somewhat unique, and careful analysis and thoughtful consideration must be brought to bear to determine the correct amount of adjustment.
ILLUSTRATION OF SUPPLIES
The initial purchase of supplies is recorded by debiting Supplies and crediting Cash. Supplies Expense should subsequently be debited and Supplies credited for the amount used. This results in expense on the income statement being equal to the amount of supplies used, while the remaining balance of supplies on hand is reported as an asset. The following illustrates the purchase of $900 of supplies. Subsequently, $700 of this amount is used, leaving $200 of supplies on hand in the Supplies account:
One might find it necessary to”back in”to the calculation of supplies used. Assume $200 of supplies in a storage room are physically counted at the end of the period. Since the account has a $900 balance from the December 8 entry, one “backs in” to the $700 adjustment on December 31. In other words, since $900 of supplies were purchased, but only $200 were left over, then $700 must have been used.
The following year is slightly more challenging. If an additional $1,000 of supplies is purchased during 20X2, and the ending balance at December 31, 20X2, is $300, then these entries would be needed:
The $1,000 amount is clear enough, but what about the $900 of expense? One must take into account that 20X2 started with a $200 beginning balance (last year’s”leftovers”), purchases were an additional $1,000 (giving the total available for the period at $1,200), and the year ended with $300 of supplies on hand. Thus, $900 was used up during the period:
Long-lived assets like buildings and equipment will provide productive benefits to a number of periods. Thus, a portion of their cost is allocated to each period. This process is called depreciation. A subsequent chapter will cover depreciation in great detail. However, one simple approach is called the straight-line method, where an equal amount of asset cost is assigned to each year of service life.
By way of example, if a $150,000 truck with an 3-year life was purchased on January 1 of Year 1, depreciation expense would be $50,000 per year ($150,000/3 = $50,000). This expense would be reported on each year’s income statement. The annual entry involves a debit to Depreciation Expense and a credit to Accumulated Depreciation (rather than crediting the asset account directly):
Accumulated depreciation is a unique account. It is reported on the balance sheet as a contra asset. A contra account is an account that is subtracted from a related account. As a result, contra accounts have opposite debit/credit rules In other words, accumulated deprecation is increased with a credit, because the associated asset normally has a debit balance. The following statements show how accumulated depreciation and depreciation expense would appear for each year:
As one can see on each year’s balance sheet, the asset continues to be reported at its $150,000 cost. However, it is also reduced each year by the ever-growing accumulated depreciation. The asset cost minus accumulated depreciation is known as the book value (or “net book value”) of the asset. For example, at December 31, 20X2, the net book value of the truck is $50,000, consisting of $150,000 cost less $100,000 of accumulated depreciation. By the end of the asset’s life, its cost has been fully depreciated and its net book value has been reduced to zero. Customarily the asset could then be removed from the accounts, presuming it is then fully used up and retired.
Often, a business will collect monies in advance of providing goods or services. For example, a magazine publisher may sell a multi-year subscription and collect the full payment at or near the beginning of the subscription period. Such payments received in advance are initially recorded as a debit to Cash and a credit to unearned Revenue. Unearned revenue is reported as a liability, reflecting the company’s obligation to deliver product in the future. Remember, revenue cannot be recognized in the income statement until the earnings process is complete.
As goods and services are delivered (e.g., the magazines are delivered), the unearned Revenue is reduced (debited) and Revenue is increased (credited). The balance sheet at the end of an accounting period would include the remaining unearned revenue for those goods and services not yet delivered. This amount reflects the entity’s obligation for future performance. Equally important, the reported revenue only reflects goods and services actually delivered. Following are illustrative entries for the accounting for unearned revenues:
Another type of adjusting journal entry pertains to the accrual of unrecorded expenses and revenues. Accruals are expenses and revenues that gradually accumulate throughout an accounting period. Accrued expenses relate to such things as salaries, interest, rent, utilities, and so forth. Accrued revenues might relate to such events as client services that are based on hours worked.
Few, if any, businesses have daily payroll. Typically, businesses will pay employees once or twice per month. Suppose a business has employees that collectively earn $1,000 per day. The last payday occurred on December 26, as shown in the 20X8 calendar that follows. Employees worked three days the following week, but would not be paid for this time until January 9, 20X9. As of the end of the accounting period, the company owes employees $3,000 (pertaining to December 29, 30, and 31). As a result, the adjusting entry to record the accrued payroll would appear as follows:
Before moving on to the next topic, consider the entry that will be needed on the next payday (January 9, 20X9). Suppose the total payroll on that date is $10,000 ($3,000 relating to the prior year (20X8) and another $7,000 for an additional seven work days in 20X9). The journal entry on the actual payday needs to reflect that the $10,000 is partially for expense and partially to extinguish a previously established liability:
Most loans include charges for interest. The amount of interest therefore depends on the amount of the borrowing (“principal”), the interest rate (“rate”), and the length of the borrowing period (“time”). The total amount of interest on a loan is calculated as Principal X Rate X Time. For example, if $100,000 is borrowed at 6% per year for 18 months, the total interest will amount to $9,000 ($100,000 X 6% X 1.5 years). However, even if the interest is not payable until the end of the loan, it is still logical and appropriate to accrue the interest as time passes. This is necessary to assign the correct interest cost to each accounting period. Assume that an 18-month loan was taken out on July 1, 20X1, and was due on December 31, 20X2. The accounting for the loan on the various dates (assume a December year end, with an appropriate year-end adjusting entry for the accrued interest) would be as follows:
Accrued rent is the opposite of prepaid rent discussed earlier. Recall that prepaid rent related to rent that was paid in advance. In contrast, accrued rent relates to rent that has not yet been paid, even though utilization of the asset has already occurred. For example, assume that office space is leased, and the terms of the agreement stipulate that rent will be paid within 10 days after the end of each month at the rate of $400 per month. During December of 20X1, Cabul Company occupied the lease space, and the appropriate adjusting entry for December follows:
When the rent is paid on January 10, 20X2, this entry would be needed:
Many businesses provide services to clients under an understanding that they will be periodically billed for the hours (or other units) of service provided. For example, an accounting firm may track hours worked on various projects for their clients. These hours are likely accumulated and billed each month, with the periodic billing occurring in the month following the month in which the service is provided. As a result, money has been earned during a month, even though it won’t be billed until the following month. Accrual accounting concepts dictate that such revenues be recorded when earned. The following entry would be needed at the end of December to accrue revenue for services rendered to date (even though the physical billing of the client may not occur until January):
Recap of adjusting:
The preceding discussion of adjustments has been presented in great detail because it is imperative to grasp the underlying income measurement principles. Perhaps the single most important element of accounting judgment is to develop an appreciation for the correct measurement of revenues and expenses. These processes can be fairly straightforward, as in the preceding illustrations. At other times, the measurements can grow very complex. A business process rarely starts and stops at the beginning and end of a month, quarter or year – yet the accounting process necessarily divides that flowing business process into measurement periods.
ADJUSTED TRIAL BALANCE:
Keep in mind that the trial balance introduced in the previous chapter was prepared before considering adjusting entries. Subsequent to the adjustment process, another trial balance can be prepared. This adjusted trial balance demonstrates the equality of debits and credits after recording adjusting entries. Therefore, correct financial statements can be prepared directly from the adjusted trial balance. The next chapter provides a detailed look at the adjusted trial balance.
The mechanics of accounting for prepaid expenses and unearned revenues can be carried out in several ways. At left below is a “balance sheet approach” for Prepaid Insurance. The expenditure was initially recorded into a prepaid account on the balance sheet. The alternative approach is the “income statement approach,” wherein the Expense account is debited at the time of purchase. The appropriate end-of-period adjusting entry establishes the Prepaid Expense account with a debit for the amount relating to future periods. The offsetting credit reduces the expense to an amount equal to the amount consumed during the period. Note that Insurance Expense and Prepaid Insurance accounts have identical balances at December 31 under either approach.
Accounting for unearned revenue can also follow a balance sheet or income statement approach. The balance sheet approach for unearned revenue is presented at left below. At right is the income statement approach, wherein the initial receipt is recorded entirely to a Revenue account. Subsequent end-of-period adjusting entries reduce Revenue by the amount not yet earned and increase unearned Revenue. Again, both approaches produce the same financial statement results.
The income statement approach does have an advantage if the entire prepaid item or unearned revenue is fully consumed or earned by the end of an accounting period. No adjusting entry would be needed because the expense or revenue was fully recorded at the date of the original transaction.
Expense recognition will typically follow one of three approaches, depending on the nature of the cost:
Associating cause and effect: Many costs are linked to the revenue they help produce. For example, a sales commission owed to an employee is based on the amount of a sale. Therefore, commission expense should be recorded in the same accounting period as the sale. Likewise, the cost of inventory delivered to a customer should be expensed when the sale is recognized. This is what is meant by associating cause and effect, and is also referred to as the matching principle.
Systematic and rational allocation: In the absence of a clear link between a cost and revenue item, other expense recognition schemes must be employed. Some costs benefit many periods. Stated differently, these costs expire over time. For example, a truck may last many years; determining how much cost is attributable to a particular year is difficult. In such cases, accountants may use a systematic and rational allocation scheme to spread a portion of the total cost to each period of use (in the case of a truck, through a process known as depreciation).
Immediate recognition: Last, some costs cannot be linked to any production of revenue, and do not benefit future periods either. These costs are recognized immediately. An example would be severance pay to a fired employee, which would be expensed when the employee is terminated.
PAYMENT vs. RECOGNITION:
It is important to note that receiving or making payments are not criteria for initial revenue or expense recognition. Revenues are recognized at the point of sale, whether that sale is for cash or a receivable. Expenses are based on one of the approaches just described, no matter when payment occurs. Recall the earlier definitions of revenue and expense, noting that they contemplate something more than simply reflecting cash receipts and payments. Much business activity is conducted on credit, and severe misrepresentations of income could result if the focus was simply on cash flow.
To recognize an item is to record it into the accounting records. Revenue recognition normally occurs at the time services are rendered or when goods are sold and delivered. The conditions for revenue recognition are (a) an exchange transaction, and (b) the earnings process being complete.
For a manufactured product, should revenue be recognized when the item rolls off of the assembly line? The answer is no! Although production may be complete, the product has not been sold in an exchange transaction. Both conditions must be met. In the alternative, if a customer ordered a product that was to be produced, would revenue be recognized at the time of the order? Again, the answer is no! For revenue to be recognized, the product must be manufactured and delivered.
Modern business transactions frequently involve complex terms, bundled items (e.g., a cell phone with a service contract), intangibles (e.g. a software user license), order routing (e.g., an online retailer may route an order to the manufacturer for direct shipment), and so forth. It is no wonder that many accounting failures involve misapplication of revenue recognition concepts. The USA Securities and Exchange Commission has additional guidance, noting that revenue recognition would normally be appropriate only when there is persuasive evidence of an arrangement, delivery has occurred (or services rendered), the seller’s price is fixed or determinable, and collectibility is reasonably assured.
Business activity is fluid. Revenue and expense generating activities are in constant motion. Just because it is time to turn a page on a calendar does not mean that all business activity ceases. But, for purposes of measuring performance, it is necessary to draw a line in the sand of time. A periodicity assumption is made that business activity can be divided into measurement intervals, such as months, quarters, and years.
Accounting must divide the continuous business process, and produce periodic reports. An annual reporting period may follow the calendar year by running from January 1 through December 31. Annual periods are usually further divided into quarterly periods containing activity for three months.
In the alternative, a fiscal year may be adopted, running from any point of beginning to one year later. Fiscal years often attempt to follow natural business year cycles, such as in the retail business where a fiscal year may end on January 31 (allowing all of the holiday rush, and corresponding returns, to cycle through). Note in the following illustration that the “20X8 Fiscal Year” is so named because it ends in 20X8:
Also consider that internal reports may be prepared on even more frequent monthly intervals. As a general rule, the more narrowly defined a reporting period, the more challenging it becomes to capture and measure business activity.
This results because continuous business activity must be divided and apportioned among periods; the more periods, the more likely that ongoing transactionsmust be allocated to more than one reporting period. Once a measurement period is adopted, the accountant’s task is to apply the various rules and procedures of generally accepted accounting principles (GAAP) to assign revenues and expenses to the reporting period. This process is called accrual-basis accounting. Accrue means to come about as a natural growth or increase. Thus, accrual-basis accounting is reflective of measuring revenues as earned and expenses as incurred.
Correctly assigning revenues and expenses to time periods is pivotal in the determination of income. It probably goes without saying that reported income is of great concern to investors and creditors, and its proper determination is crucial. These measurement issues can become highly complex. For example, if a software company sells a product for $25,000 (in year 20X1), and agrees to provide updates at no cost to the customer for 20X2 and 20X3, then how much revenue is “earned” in 20X1, 20X2, and 20X3? Such questions are vexing, and they make accounting far more challenging than most realize. At this point, suffice it to say that one would need more information about the software company to answer their specific question. But, there are several basic rules about revenue and expense recognition that should be understood, and they will be introduced in the following sections.
Before moving away from the periodicity assumption, and its accounting implications, there is one important factor to note. If accounting did not require periodic measurement, and instead, took the view that one could report only at the end of a process, measurement would be easy. For example, if the software company were to report income for the three-year period 20X1 through 20X3, then revenue of $25,000 would be easy to measure. It is the periodicity assumption that muddies the water. Why not just wait? Two reasons: first, one might wait a long time for activities to close and become measurable with certainty, and second, investors cannot wait long periods of time before learning how a business is doing. Timeliness of data is critical to its relevance for decision making. Therefore, procedures and assumptions are needed to produce timely data, and that is why the periodicity assumption is put in play.
Economists refer to income as a measure of “better-offness.” Thus, economic income represents an increase in command over goods and services. Such notions of income capture operating successes, as well as good fortune from holding assets that may increase in value. In contrast, accounting income tends to focus on the effects of transactions and events that are evidenced by exchange transactions. For example, land is recorded at its purchase price.
In recent years, however, accounting rules around the globe have increasingly reflected greater acceptance of fair value measurements for selected financial statement elements. Whether and when accounting should measure changes in value has long been a source of debate. This debate is ongoing, and rules that establish measurement principles will continually evolve.
Generalizing: (a) accounting measurements tend to be based on historical cost determined by reference to an exchange transaction with another party (e.g., a purchase) and (b) income is”revenues” minus “expenses” as determined by reference to those transactions. More specifically:
Revenues — Inflows and enhancements from delivery of goods and services that constitute central ongoing operations
Expenses — Outflows and obligations arising from the production of goods and services that constitute central ongoing operations
Gains/Losses — Like revenues/expenses, but from peripheral transactions or events
Thus, it may be more precisely said that income is equal to Revenues + Gains – Expenses – Losses. Be aware that in some countries revenues is an all-inclusive term, including both revenues and gains.
Although accounting income will typically focus on recording transactions and events that are exchange based, note that some items must be recorded even though there is not an identifiable exchange between the company and some external party. What types of non exchange events logically should be recorded to prepare correct financial statements? How about the loss of an uninsured building from fire or storm? Clearly, the asset is gone, so it logically should be removed from the accounting records. This would be recorded as an immediate loss. Even more challenging may be to consider the journal entry: debit a loss (losses are increased with debits since they are like expenses), and credit the asset account (the asset is gone and is reduced with a credit).
A useful tool for demonstrating certain transactions and events is the T-account. Importantly, one would not use T-accounts for actually maintaining the accounts of a business. Instead, they are just a quick and simple way to figure out how a small number of transactions and events will impact a company. T-accounts would quickly become unwieldy in an enlarged business setting. In essence, T-accounts are just a “scratch pad” for account analysis. They are useful communication devices to discuss, illustrate, and think about the impact of transactions. The physical shape of a T-account is a “T,” and debits are on the left and credits on the right. The “balance” is the amount by which debits exceed credits (or vice versa).
Below is the T-account for Cash for the transactions and events of Xao Corporation. Carefully compare this T-account to the actual running balance ledger account which is also shown (notice that the debits in black total to $33,800, the credits in red total to $7,500, and the excess of debits over credits is $26,300 — which is the resulting account balance shown in blue).
Notice that much of the material in this chapter involves mundane processing. Once the initial journal entry is prepared, the data are merely being manipulated to produce the ledger, trial balance, and financial statements. It is no wonder that the first business applications that were computerized years ago related to transaction processing. In short, the only “analytics” relate to the initial transaction recordation. All of the subsequent steps are merely mechanical, and are aptly suited to computers.
Many companies produce accounting software. These packages range from the simple to the complex. Some basic products for a small business may be purchased for under $100. In large organizations, millions may be spent hiring consultants to install large enterprise-wide packages. Recently, some software companies have even offered accounting systems maintained on their own network, with the customers utilizing the internet to enter data and produce their reports.
How Do They Work?
As one might expect, the look, feel, and function of software-based packages varies significantly. Following is a very typical data entry screen. It should look quite familiar. After the data are input, the subsequent processing (posting, etc.) is totally automated.
Each company’s product must be studied to understand its unique attributes. Accounting software packages generally:
Attempt to simplify and automate data entry (e.g., a point-of-sale terminal may actually become a data entry device into the accounting system).
Divide the accounting process into modules related to functional areas such as sales/collection, purchasing/payment, and others.
Attempt to be “user-friendly” by providing data entry blanks that are easily understood in relation to the underlying transactions.
Attempt to minimize key-strokes by using “pick lists,” automatic call-up functions, and auto-complete type technology.
Are built on data-base logic, allowing transaction data to be sorted and processed based on any query structure (e.g., produce an income statement for July).
Provide up-to-date data that may be accessed by key business decision makers.
Are capable of producing numerous specialized reports.
Despite each product’s own look and feel, the persons primarily responsible for the maintenance and operation of the accounting function must still understand accounting basics such as those introduced in this chapter: accounts, debits and credits, journal entries, etc. Without that intrinsic knowledge, the data input decisions will quickly go astray, and the output of the computerized accounting system will become hopelessly trashed. This knowledge is essential in the successful implementation and use of most any computerized accounting product, and the reports they produce.
After all transactions have been posted from the journal to the ledger, it is a good practice to prepare a trial balance. A trial balance is simply a listing of the ledger accounts along with their respective debit or credit balances. The trial balance is not a formal financial statement, but rather a self-check to determine that debits equal credits. Following is the trial balance prepared from the general ledger of Xao Corporation.
Debits Equal Credits
Since each transaction was journalized in a way that insured that debits equaled credits, one would expect that this equality would be maintained throughout the ledger and trial balance. If the trial balance fails to balance, an error has occurred and must be located. It is much better to be careful as one proceeds, rather than having to go back and locate an error after the fact. Be aware that a “balanced” trial balance is no guarantee of correctness. For example, failing to record a transaction, recording the same transaction twice, or posting an amount to the wrong account would produce a balanced (but incorrect) trial balance.
Financial Statements From The Trial Balance
The next chapter reveals additional adjustments that may be needed to prepare a truly correct and up-to-date set of financial statements. But, for now, a tentative set of financial statements could be prepared based on the trial balance. The basic process is to transfer amounts from the general ledger to the trial balance, then into the financial statements:
In reviewing the following financial statements for Xao, notice that italics are used to draw attention to the items taken directly from the previously shown trial balance. The other line items and amounts simply relate to totals and derived amounts within the statements.
Chart of Accounts
A listing of all accounts in use by a particular company is called the chart of accounts. Individual accounts are often given a specific reference number. The numbering scheme helps keep up with the accounts in use and the classification of accounts. For example, all assets may begin with “1″ (e.g., 101 for Cash, 102 for Accounts Receivable, etc.), liabilities with “2,” and so forth. The assignment of a numerical value to each account assists in data management, in much the same way as zip codes help move mail more efficiently. many computerized systems allow rapid entry of accounts by reference number rather than by entering a full account description. A simple chart of accounts for Xao Corporation might appear as follows:
No. 101: Cash
No. 102: Accounts Receivable
No. 103: Land
No. 201: Accounts Payable
No. 202: Notes Payable
No. 301: Capital Stock
No. 401: Service Revenue
No. 501: Advertising Expense
No. 502: Utilities Expense
Another benefit is that each account can be further subdivided in subsets. For instance, if Accounts Receivable bears the account number 102, one would expect to find that individual customers might be numbered as 102.001, 102.002, 102.003, etc. This facilitates the maintenance of “subsidiary” account records which are the subject of the next section of this chapter.
Control and Subsidiary Accounts
Some general ledger accounts are made of many sub-components. For instance, a company may have total accounts receivable of $19,000, consisting of amounts due from Compton, Fisher, and Moore. The accounting system must be sufficient to reveal the total receivables, as well as amounts due from each customer. Therefore, sub-accounts are used. For instance, in addition to the regular general ledger account, separate auxiliary receivable accounts would be maintained for each customer, as shown in the following illustration:
The total receivables are the sum of all the individual receivable amounts. Thus, the Accounts Receivable general ledger account total is said to be the control account or control ledger, as it represents the total of all individual subsidiary account balances. It is simply imperative that a company be able to reconcile subsidiary accounts to the broader control account that is found in the general ledger. Here, computers can be particularly helpful in maintaining the detailed and aggregated data in perfect harmony.