Inventory Turnover Calculator: How Long Does Stock Sit?
Calculate inventory turnover and days in inventory using your own costs. See how a gift shop found slow-moving stock before its next reorder.


A gift shop has one handmade mug left and fourteen boxes of winter candles on the shelf. The buyer has enough cash for one reorder. Last month’s sales report shows the two lines brought in similar revenue. Which shelf should get the money?
Open the free inventory turnover calculator
Inventory turnover measures how many times the cost of goods sold during a period covers the average inventory at cost. Days in inventory expresses the same relationship in days. The free calculator at the end of this guide works for a month, a quarter, or a year. Run it once for each product line before you place the order.
The three figures to pull from your books
Beginning inventory is the value of the items you held at the start of the period. Ending inventory is their value at the close. Use your recorded inventory cost for both. A mug priced at $30 that cost the shop $12 contributes $12 to the inventory balance. Use the same product group, location, and valuation basis throughout.
Cost of goods sold (COGS) is the recorded cost of the goods sold during those dates. It differs from sales revenue and from the amount you spent purchasing stock. A shipment can arrive this month and remain on the shelf until next month. Taking the purchase invoice total as COGS would make unsold stock look as if it had already moved.
How to calculate inventory turnover and days in inventory
Average inventory = (beginning inventory + ending inventory) ÷ 2. Divide the period’s COGS by that average to get turns for the period. Divide the actual number of days in the period by those turns to estimate days in inventory. Use 30 for a 30-day month, 91 for a 91-day quarter, and the actual day count for a year.
Suppose the gift shop’s mugs started a 30-day period at $2,400 in inventory and ended at $1,200. Their average inventory was $1,800. With $3,600 in mug COGS, the line turned twice in that month. Thirty days divided by two gives 15 days in inventory.
The candles started at $4,500 and closed at $4,500. With $1,500 in candle COGS, the same month produced one-third of a turn and 90 days in inventory. Ninety days is possible in a 30-day report. It means the average inventory equaled roughly three months of cost flowing out at that month’s pace. It does not tell you the age of any individual candle.
Make the next buying decision
For the mugs, check the supplier’s lead time, orders already placed, and units reserved for customers. If the next shipment takes three weeks and the remaining mug is already promised, waiting for month-end may cost a sale. Count current units and review recent demand before choosing the order size. Days in inventory measures past activity. It is a different question from how long today’s remaining stock will last.
For candles, inspect which scents and pack sizes remain. A popular scent may be out of stock while several slow lines hide in the category average. Before discounting everything, look at units sold by variant, gross margin, display placement, and supplier return terms. A single shelf move followed by a weekly unit count can be a cheaper experiment than a store-wide markdown.
When the average can mislead you
A holiday shipment that arrived and sold between the opening and closing dates can be invisible in a two-balance average. If stock fluctuates sharply, compare the result with an average of regularly spaced daily or weekly balances. Compare like seasons and product groups. A bakery selling perishable goods and a furniture shop waiting on special orders have different operating rhythms.
If COGS is zero and average stock is positive, the period has zero turns and no finite days estimate. If both opening and closing inventory are zero despite recorded sales, two snapshots cannot support this ratio. Review interim balances. Negative inventory, an unposted vendor receipt, or an unrecorded customer return also deserves a closer look before using the result to approve a reorder.
Where to start in QuickBooks or your POS
Choose one reporting period first. Pull the inventory valuation at the end of the day before the period begins and again at period end. Match the period’s COGS to the same items. If your bookkeeping reports only show store-wide COGS, run a whole-store calculation first. For a category calculation, use item-level costs from a reconciled inventory or POS report. Combining a category’s shelf value with the entire store’s COGS will overstate its turnover.
If the figures disagree, bring the two valuations, the period’s COGS report, and your latest count to a free bookkeeping consultation. You can also start with the Free Books Health Score. For background on the formula, see AccountingCoach’s financial ratio guide.
Try the free inventory turnover calculator
Use the sample mug figures first. Then replace them with one product line from your own books. Record the dates alongside the result so you can repeat the comparison next month.

Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States
Get in touch
LiveFixPro Bookkeeping & Accounting Services LLC is an independent firm. Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.