Inventory Write-Downs: When and How to Record Them

An inventory write-down is an accounting entry that reduces the recorded value of stock when the company expects to recover less than it paid, and it is the point at which a planning problem becomes a profit-and-loss problem. This guide is part of demand planning and inventory optimization, follows how inventory decisions affect cash flow and excess and obsolete inventory, and leads to markdown planning and inventory aging reports. A write-down does not cause the loss. The loss happened when the stock became unsellable at the expected price, whether through a forecast that was too high, a product that went out of fashion or a spoilage event. The write-down recognizes the loss in the accounts. This guide explains when a write-down is needed, how to estimate the recoverable amount, how the entries work, how they affect margin and cash, what differs between accounting frameworks at a high level and how planners can prevent them. It is written for operations and finance leaders and is general information, not accounting advice: apply the standards that govern your company and agree your policy with your auditors. The cash side is covered in cash flow management.

The principle

Inventory is generally carried at the lower of its cost and its net realizable value. Net realizable value is the estimated selling price in the ordinary course of business, less the estimated costs of completion and the costs necessary to make the sale. If net realizable value falls below cost, the inventory is written down to net realizable value. The reasoning is that an asset should not be carried at more than the amount it is expected to bring in. The details of measurement differ by framework and method (for example, how the standards treat certain cost methods), which is a reason to agree your policy with your accountants.

Triggers

Common reasons to consider a write-down include:

• Excess quantities. Stock well beyond what can be sold at current prices within a reasonable period.
• Obsolescence. Discontinued, superseded or out-of-fashion products.
• Damage or deterioration. Physical damage, spoilage and expiry.
• Price declines. A market price drop or planned markdown that takes the selling price below cost.
• Cost increases to complete a product that is not yet finished.
• Shrinkage. Counting differences that show less stock than the books.
• Regulatory or quality issues. Recalls, failed inspections or non-compliant stock.

Planners and finance should review for these triggers at least quarterly, and whenever a major event occurs.

Estimating net realizable value

Use the best available evidence of what the stock will realize. For items to be sold through normal channels at a discount, use the expected discounted price, less selling costs. For items to be liquidated, use broker quotes or recent recoveries. For items that will be scrapped, use zero less disposal cost. Document the evidence: price lists, quotes, sales history of similar clearances and approved markdown plans. Estimates should be consistent from period to period and based on facts, not on optimism.

A worked example

A company has 1,000 units of a product on hand with a cost of $20 each, a total of $20,000 (illustrative). The planned clearance price is $14. Selling costs (commission and freight) are expected to be $2 a unit.

• Net realizable value per unit: 14 - 2 = $12
• Write-down per unit: 20 - 12 = $8
• Total write-down: 1,000 × 8 = $8,000
• Revised carrying value: 1,000 × 12 = $12,000

The journal entry, in simplified form, debits cost of goods sold (or a separate inventory write-down expense line) by $8,000 and credits inventory, or an inventory reserve account, by $8,000. The profit effect appears in the period in which the write-down is recorded, not when the stock is eventually sold. If the stock is later sold at $14 less $2 of cost, the margin on that sale is zero relative to the written-down cost of $12, and the earlier recognition of the loss means the later period shows no further loss.

Effect on margin

Suppose the company has quarterly revenue of $1,000,000 and a gross margin of 40 percent, or $400,000, before the write-down (illustrative). After recording the $8,000 write-down in cost of goods sold, gross margin is 400,000 - 8,000 = $392,000, or 39.2 percent. A write-down of 0.8 points of margin from this one item is visible to lenders and investors. Write-downs that are lumpy, such as a large year-end adjustment, distort quarterly trends. Smooth recognition through regular reviews and sensible reserve methods, and explain unusual items clearly. If the company has loan covenants based on earnings, a write-down can matter for compliance, so check the definitions in your credit agreement and see how lenders evaluate your cash flow and working capital.

Reserves and methods

Many companies maintain a reserve for excess and obsolete stock, adjusted each period based on a formula, such as a percentage of inventory by age band, a comparison of on-hand with forward demand, or an item-by-item review. The method should be written down, applied consistently, tested against actual outcomes and agreed with your auditors. A reserve is only as good as its inputs. If the demand forecast is optimistic, the reserve will be too low. See excess and obsolete inventory for an example by age band.

Reversals

Frameworks differ on whether a write-down can be reversed if the net realizable value later recovers. Under some standards, reversal is allowed up to the amount of the original write-down. Under others, the written-down amount becomes the new cost basis and cannot be reversed. This is a technical point to confirm with your accountants, and it influences how aggressive a company can be in its estimates.

Tax

Tax treatment of write-downs varies. Some jurisdictions allow a deduction when the stock is written down, others only when it is sold or disposed of, and some require evidence such as a documented sale at a reduced price. Do not assume that the accounting write-down gives an immediate tax deduction. Consult a tax adviser.

Cash and the real cost

A write-down is a non-cash entry in the period it is recorded. The cash was spent earlier, when the stock was bought. The actual cash effect is the recovery when the stock is cleared, compared with the cost. In the example, if the stock sells for $12 net, the company recovers $12,000 of the $20,000 it spent, and the cash loss of $8,000 occurred in effect when the goods were bought. This is why planning, not accounting, determines the economic loss. A company that buys closer to demand has fewer write-downs. See forecast bias.

Prevention

1. Remove forecast bias and tie purchases to the plan.
2. Review aged and excess stock monthly and act early, when options are widest.
3. Plan product transitions and last buys.
4. Use open-to-buy limits and staged commitments for seasonal items.
5. Negotiate returns and exchange rights with suppliers.
6. Monitor shelf life and rotate stock.
7. Share the excess report with finance so that reserves are informed.

A routine

Each quarter, planning and finance review a list of items flagged by coverage, age, status and quality, agree the estimated recoveries, calculate the required write-down or reserve movement, document the evidence and take the entry. After the quarter, compare actual recoveries with estimates to improve the method. Report to leadership the amount and the causes, and link to actions upstream.

A reserve by age band

Many companies use a formula reserve as the baseline, then adjust for specific items. Using the same inventory profile as the aging report example (illustrative), suppose the company applies these reserve rates by band:

Check: 900,000 × 0.05 = 45,000; 600,000 × 0.25 = 150,000; 400,000 × 0.60 = 240,000; and 45,000 + 150,000 + 240,000 = 435,000. The reserve is 435,000 / 5,000,000 = 8.7 percent of inventory. If last quarter's reserve was $380,000, the quarter's charge to cost of goods sold is 435,000 - 380,000 = $55,000, before any usage of the reserve for stock that was actually scrapped or sold below cost. The reserve rates are assumptions, and they should be tested against what the company actually recovers when it clears aged stock. If the company recovers 55 cents on the dollar for stock over 365 days, a 60 percent reserve rate is consistent with the evidence, because it leaves a carrying value of 40 percent against a recovery of 55 percent. If it recovers only 20 cents, the rate is too low.

Working with finance and auditors

Auditors will usually ask for the method, the data behind it and evidence that the estimates have proven reasonable. The planning team can help by keeping a clear record: the list of items flagged and why, the demand forecast used to judge coverage, the approved markdown or clearance plans, quotes from liquidators and the actual recoveries after the fact. A write-down policy that lives in one person's head cannot be audited. A short written policy that names the triggers, the bands, the reserve rates, the approval levels and the review frequency usually saves a great deal of time at year-end. It also helps planners understand that an optimistic forecast has an accounting consequence, since the forecast is often the basis for deciding whether stock is excess.

Write-down timing and the planning cycle

Write-downs have a habit of arriving at awkward moments, usually at quarter-end or year-end when the numbers are being closed. The remedy is to move the conversation earlier. In the monthly S&OP cycle, include a standing item for items at risk, with the expected recovery and the proposed action. When the decision to clear an item is made in March, the markdown and the loss are recognized in March, not in a surprise adjustment in December. Early action also tends to cost less, because the options are wider: a transfer to another region, a bundle or a planned promotion can recover more than a distress sale at year-end. See markdown planning.

Communicating write-downs

Leadership should hear about a write-down as a cause and an action, not just a number. A useful summary says how much was written down, which categories and products, what caused it (a forecast that was too high, a launch that underperformed, a quality issue), what is being done to recover value and what has changed upstream to prevent a repeat. Lenders and investors generally react better to a company that identifies and explains a write-down early than to one that is surprised by it. If the write-down is large enough to affect covenants, talk to the lender before the compliance certificate is due.

Partial recoveries and channel choice

Net realizable value is not a single number for all of the stock. A lot of 1,000 units might be cleared in several ways, each with a different recovery. Suppose 400 units can be sold through an outlet channel at $14 net of costs, 400 units to a liquidator at $8 and 200 units are damaged and will be scrapped at a disposal cost of $1 each (illustrative). The expected recovery is 400 × 14 + 400 × 8 - 200 × 1 = 5,600 + 3,200 - 200 = $8,600, or an average of $8.60 per unit. At a cost of $20, the write-down is 20,000 - 8,600 = $11,400. Valuing the whole lot at the outlet price would have understated the loss by 400 × (14 - 8) + 200 × (14 + 1) = 2,400 + 3,000 = $5,400 for these quantities. Segment the stock by likely disposition and value each segment on its own evidence.

Common mistakes

1. Delaying recognition until year-end.
2. Optimistic selling price estimates.
3. Forgetting selling costs in net realizable value.
4. Inconsistent methods between periods.
5. Treating the write-down as the end of the problem.
6. Not feeding the cause back to planning and buying.

FAQs

What is an inventory write-down?

An accounting entry that reduces the recorded value of inventory to its net realizable value when the expected recovery is lower than cost.

How do you calculate a write-down?

Subtract net realizable value (expected selling price less selling and completion costs) from cost, and multiply by the quantity.

Where does a write-down appear in the accounts?

As an expense, often within cost of goods sold, and a reduction in the inventory balance or an increase in the inventory reserve.

Is a write-down the same as a write-off?

A write-down reduces value partly. A write-off reduces it to zero, typically when the stock is scrapped or has no value.

Can a write-down be reversed?

It depends on the accounting standards you follow. Check with your accountants.