Counting Inventory in a Perpetual System

Question: In a periodic inventory system, a physical count is always taken at or near the end of the fiscal year. This procedure is essential in determining the final inventory figure and, hence, cost of goods sold for the period. When a company uses a perpetual system, is a count of the goods on hand still needed since both the inventory balance and cost of goods sold are maintained and available in the accounting records?

Answer: A physical inventory is necessary even if a company has invested the effort and cost to install a perpetual system. Merchandise can be lost, broken, or stolen. Errors can occur in the record keeping. Thus, a count is taken on a regular basis simply to ensure that subsidiary and general ledger balances are kept in alignment with the actual items held. Unless differences become material, this physical inventory can take place at a convenient time rather than at the end of the year. For example, assume that a company sells snow ski apparel. If an efficient perpetual system is in use, the merchandise could be inspected and counted by employees in May when quantities are low and damaged goods easier to spot.

An adjustment is necessary when the count does not agree with perpetual inventory figures. To illustrate, assume that company records indicate that 65 ski jackets are currently in stock costing $70 apiece. The physical inventory finds that only 63 items are actually on hand. The inventory account is reduced (credited) by $140 to mirror the shortfall (two missing units at $70 each).

The other half of the adjusting entry depends on the perceived cause of the shortage. For example, officials might have reason to believe that errors took place in the accounting process during the period. When merchandise is bought and sold, recording miscues do occur. Possibly two ski jackets were sold on a busy afternoon. The clerk got distracted and the cost of this merchandise was never reclassified to expense. This type of mistake means that the cost of goods sold figure is too low. The balance reported for these two jackets is moved to the expense account to rectify the mistake.

Figure 8.9 Adjusting Entry—To Bring Perpetual Inventory Records in Line with Physical Count, a Recording Error Is Assumed

Conversely, if differences between actual and recorded inventory amounts occur because of damage, loss, or theft, the reported balance for cost of goods sold should not bear the cost of these items. The two jackets were not sold. Instead, a loss occurred.

If the assumption is made that the missing jackets were lost or stolen, rather than sold, the following alternative adjustment is appropriate.

Figure 8.10 Adjusting Entry—To Bring Perpetual Inventory Records in Line with Physical Count, Theft or Loss Is Assumed

In practice, when an inventory count is made and the results differ from the amount of recorded merchandise, the exact cause is often impossible to identify. Whether a loss is reported or a change is made in reporting cost of goods sold, the impact on net income is the same. In such cases, construction of the adjustment is at the discretion of company officials. Normally, consistent application from year to year is the major objective.

Estimating the Amount of Inventory on Hand

Question: A periodic system is cheap and easy to operate. However, the lack of available information does present some practical problems. Assume that a company experiences a fire, flood, or other disaster and is attempting to gather evidence—for insurance or tax purposes—as to the amount of merchandise that was destroyed. If a periodic system has been used, how can the company support its claim? Or assume a company wants to produce interim financial statements for a single month or quarter (rather than a full year) without going to the cost and trouble of taking a complete physical inventory count. If the information is needed, how can a reasonable approximation of inventory on hand be derived when a periodic system is in use?

Answer: One entire branch of accounting—known as forensic accountingA branch of accounting specializing in investigating and reporting on situations where important information is limited or unavailable.—specializes in investigations where information is limited or not available (or has even been purposely altered to be misleading). For example, assume that a hurricane floods a retail clothing store in Charleston, South Carolina. Only a portion of the merchandise costing $80,000 is salvaged.For a full description of forensic accounting, see Frank J. Grippo and J. W. (Ted) Ibex, “Introduction to Forensic Accounting,” The National Public Accountant, June 2003. In trying to determine the resulting loss, the amount of inventory in the building prior to the storm needs to be calculated. A forensic accountant might be hired, by either the owner of the store or the insurance company, to produce a reasonable estimate of the merchandise on hand at the time of the flood. Obviously, if the company had used a perpetual rather than a periodic system, the need to hire the services of an accounting expert would be less likely unless fraud was suspected.

In some cases, arriving at a probable inventory balance is not extremely complicated even if periodic inventory procedures are utilized. When historical trends can be determined with assurance, a valid estimation of the goods on hand is possible at any point in time without the benefit of perpetual records. To illustrate, assume that the general ledger for the Charleston store is located after the disaster. A periodic system was in use and the T-account balances provide the following information.

Figure 8.11 Estimating Inventory—General Ledger Balances

If no sales had taken place prior to the flood, the inventory on hand would have cost $571,000 as shown by these ledger accounts. However, sales had occurred, and a significant amount of merchandise was removed by customers as a result of those transactions. The $480,000 balance shown in the sales T-account does not reflect the cost of inventory items that were surrendered. It is a retail amount, the summation of the price charged for all sales during the year to date.

To determine the cost of inventory held at the time of the catastrophe, cost of goods sold for the current year has to be approximated and then removed from the $571,000 total. Many companies use a fairly standard markup percentage to set retail prices. By looking at previously reported balances, the forensic accountant is often able to make a reasonable determination of that markup. For example, assume that in the preceding year, this company reported sales revenue of $500,000 along with cost of goods sold of $300,000 and, hence, gross profit of $200,000. In this earlier period, cost of goods sold was 60 percent of sales revenue ($300,000/$500,000) while gross profit was 40 percent ($200,000/$500,000).

If available evidence does not indicate any significant changes this year in the method used to set retail prices, the accountant can assume that cost of goods sold during the period prior to the storm was about $288,000 ($480,000 sales revenue × 60 percent). Because the cost of all inventory was $571,000, approximately $283,000 of those goods were still in stock at the store when the hurricane hit Charleston ($571,000 total cost less $288,000 estimated cost of goods sold). This residual figure then serves as the basis for the insurance or tax claim. Only goods costing $80,000 were saved. Thus, the estimated loss was $203,000 ($283,000 inventory in stock less $80,000 inventory saved).

An identical set of procedures could also be used if the company was preparing financial statements for a period of time of less than a year (for example, a month or a quarter). For such interim reporting, companies often determine inventory and cost of goods sold based on estimations to avoid the cost of frequent physical counts.

The biggest obstacle in this type calculation is the validity of the cost and markup percentages. Many companies offer an eclectic variety of products, each with its own typical gross margin. Other companies change their markups frequently based on market conditions. In these cases, determining a reliable percentage can be difficult and the accuracy of the resulting estimation is much more questionable.