---
title: "Days in Inventory Calculator + Inventory Turnover Ratio"
description: "Enter cost of goods sold and beginning and ending inventory to get inventory turnover and days in inventory: how long stock sits before it sells. Free."
url: "https://mcc-solutionsnj.com/bookkeeping/inventory-turnover-and-days-of-inventory-calculator"
---

Free tool

# Inventory turnover and days of inventory calculator

## Overview

See how many times you sell through your stock and how long it sits.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software)

Cost of goods sold for the period ($)

Inventory at the start ($ at cost)

Inventory at the end ($ at cost)

Days in the period

Excel workbook · $34

### Inventory Tracker and Reorder Workbook

Log what comes in and goes out and see what you have, what it is worth, what to reorder and what has not sold.

[See what is inside ($34)](/toolkits/inventory-tracker-reorder-workbook)14-day full refund

Share

## Put this tool on your own site

Free to use. Paste this where you want it to appear. It runs in the visitor's browser, so nothing they enter is sent to us.

[See every calculator you can embed](/embed)

How it works

## How it works

**Average inventory = (beginning + ending inventory) divided by 2.** **Inventory turnover = cost of goods sold divided by average inventory.** **Days of inventory = days in the period divided by turnover.** Use cost, not selling price, for both inventory and cost of goods sold.

Want a second pair of eyes on your books? [A free bookkeeping health check](/bookkeeping/health-check).

FAQ

## About this calculator

**Is a higher turnover always better?**

Not always. Very high turnover can mean stockouts and lost sales. Very low can mean cash tied up in slow stock. Compare your own periods and similar businesses.

**Why use cost instead of price?**

Inventory is recorded at cost, so cost of goods sold is the matching figure.

**What if my stock is seasonal?**

Use a full year or average several month-end counts, because one low or high month can skew the result.

**Is anything saved?**

No. The math runs in your browser and nothing you enter is sent to us.

**Is this tax or financial advice?**

No. It is a calculator for general information. Check the numbers against your own records, and ask an accountant before you act on them.

Related: [reorder point and safety stock calculator](/bookkeeping/reorder-point-and-safety-stock-calculator), [economic order quantity calculator](/bookkeeping/economic-order-quantity-calculator), [inventory tracker reorder workbook](/toolkits/inventory-tracker-reorder-workbook). See [all free tools](/free-tools). More free tools: [MCC Personal Finance Suite](/bookkeeping/personal-finance-suite), [Wrenfold personal finance software](/bookkeeping/mcc-personal-finance-software), [Gig driver earnings per mile calculator](/bookkeeping/gig-driver-earnings-per-mile-calculator), or [see all free tools](/free-tools).

Free

### Month-End Close Checklist (PDF)

The five-day close, one page to print. Enter your email and we send a link to confirm it is yours, then the download. We may email you about new toolkits, and every email has an unsubscribe link.

General information, not tax or legal advice. [How we write and check our tools](/editorial-standards).

Excel workbook

### Inventory Tracker and Reorder Workbook

Log what comes in and goes out and see what you have, what it is worth, what to reorder and what has not sold.

[See what is inside ($34)](/toolkits/inventory-tracker-reorder-workbook)

Also in the [Product Seller Bundle](/toolkits/product-seller-bundle): 3 products for $65 instead of $82 separately.

Tallyfinch

### Books you keep on your own computer

Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries.

[See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software)

## Want your books and numbers handled?

[Free health check](/bookkeeping/health-check)[Call (908) 444-6373](tel:+19084446373)