- Use one SKU or variant. Keep all quantities tied to the same inventory item.
- Enter starting stock and additions. Add units made or received during the period.
- Subtract sales and losses. Record sold, damaged, or otherwise unavailable units.
- Enter reserved stock. Reserved units remain physically present but are not available for new orders.
- Add unit cost and period length. These inputs produce inventory value and days-of-cover estimates.
- Review sellable stock. Reconcile the result with a physical count before making large purchasing decisions.
Etsy Inventory Calculator
The Etsy Inventory Calculator estimates sellable units on hand, inventory value, and the number of days current stock may last at the recent sales pace. It combines starting stock, receipts, sales, damaged units, and reserved units into one inventory position.
The result supports production planning and listing quantity decisions for physical products. It is most useful when the inputs cover the same SKU and period; combining unrelated variants can hide shortages in one item behind excess stock in another.
Calculator inputs
$
days
Result
—
sellable units available
Physical units on hand—
Sellable units—
Sellable inventory value—
Estimated days of cover—
Physical on hand = Starting units + Units received − Units sold − Damaged units
Sellable units = max(0, Physical on hand − Reserved units)
Days of cover = Sellable units ÷ (Units sold ÷ Period days)
Inventory value = Sellable units × Unit cost
Days of cover assumes the recent average sales pace continues and does not account for open purchase orders or seasonal demand shifts.
What the result means
The main result is the quantity available to sell after sales, losses, and reservations.
A zero-sales period cannot produce a finite days-of-cover estimate.
Given: Starting stock 180, receipts 75, sales 92, damaged units 3, reserved units 10, unit cost $8.40, and a 30-day sales period.
Calculation: Physical on hand = 180 + 75 − 92 − 3 = 160. Sellable units = 160 − 10 = 150. Daily sales = 92 ÷ 30 = 3.07. Days of cover = 150 ÷ 3.07 = 48.9 days.
Result: The shop has 150 sellable units valued at $1,260 and about 48.9 days of stock at the recent pace.
Should made-to-order capacity be counted as inventory?
Only count completed or reliably available units. Production capacity is better tracked separately because it is not yet sellable stock.
What belongs in reserved units?
Include units committed to open orders, replacements, samples, or other uses that prevent them from being sold again.
Why can days of cover be misleading?
It assumes average recent sales continue. Holiday demand, promotions, stockouts, and trend changes can make future sales materially different.
Should unit cost include labor?
Use the cost definition that supports your decision. For inventory valuation, follow your accounting method; for operating planning, a fuller landed cost may be more useful.
Can I combine multiple variants?
You can, but aggregate stock may conceal a shortage in a popular size or color. Variant-level calculations are more actionable for replenishment.