Inventory Turnover (ITR)

How many times the average inventory is sold and replaced in the period. 365 divided by the annual figure gives days of inventory on hand.
Finance
Efficiency

Inventory Turnover formula

\[ \dfrac{\text{Cost of sales}}{\text{Average inventory}} \]

Terms

  • Cost of sales, period total: Direct cost of the goods and services sold in the period.
  • Inventory, average of opening and closing: Raw materials, work in progress, finished goods and goods for resale, at cost.

Result

Inventory Turnover is a ratio. Higher is better.

Target

There is no general target; compare with the company’s own history and with peers in the same industry.

Inventory Turnover pitfalls

  • The numerator is cost of sales, not revenue: inventory is carried at cost, so dividing revenue by it inflates the turnover by the margin.

Inventory Turnover in Business Central

10 posting accounts in total.

The full account list is on the Cost of sales page.

  • Category Inventory (6) and every category below it

12 posting accounts in total.

The full account list is on the Inventory page.

More efficiency metrics

  • Equity Turnover: How much revenue the owners’ capital generates. Together with return on sales it explains return on equity: ROE ≈ return on sales × equity turnover, before the difference between operating and net profit.

Add Inventory Turnover to a Power BI report

I build Power BI finance reports on Business Central data, with Inventory Turnover, its trend and, where it helps, a forecast with a likely range. See it on your data

Back to top