Why this is mistaken
Days in inventory is an estimate calculated from aggregate accounting amounts. It does not tell you how long each item has been held. The same limitation applies to days sales outstanding and days payable: they are not individual invoice timelines.
Distinguish a ratio from an age record
Days in inventory divides the days in the reporting period by inventory turnover. Turnover uses Cost of Goods Sold and average inventory. Neither input records the purchase and sale dates of each unit.
A company can hold fast-selling and slow-selling products at the same time. Its single days-in-inventory result combines their accounting amounts. An inventory write-down can lower that result even though every item remains in the warehouse for exactly as long as before the adjustment.
To find actual holding times, inspect inventory age records or the receipt and sale dates of particular goods. For customer invoices, compare invoice and collection dates; for supplier invoices, compare the relevant purchase and payment dates.
Check your reasoning: calculated days in inventory falls after a write-down, with no purchases or sales. Did the goods spend less time in storage?
No. Their physical holding time did not change. The write-down reduced average recorded inventory, changing the ratio used to estimate days.
See how a write-down changes turnover and days for the before-and-after calculation.
When this mistake may appear
- A turnover ratio is converted to days.
- A result contains a fractional number of days.
Your work may contain this mistake if:
- Says every invoice was collected in the reported DSO.
- Treats DIO as the age of each physical unit.