Inventory Calculator — COGS & Usage

Track beginning inventory, purchases, and ending inventory to automatically calculate usage (Cost of Goods Sold) and cost % vs net sales. Use the quick calculator below or preview the full Google Sheets template.

Quick Inventory Calculator

Enter your inventory values for the period. The calculator will automatically compute your usage (COGS) and cost percentage.

Value of inventory at start of period (last period's ending inventory)

Total cost of food/beverage bought during this period (from invoices)

Value of inventory at end of period (from physical count)

Total sales after discounts, comps, refunds (exclude tax and tips)

Usage / COGS ($)
$0.00

Formula: Beginning + Purchases − Ending

Cost %
0.0%

Formula: Usage ÷ Net Sales

How It Works

  • Beginning Inventory: What you had at the start (last period's ending)
  • Purchases: Everything you bought during the period
  • Ending Inventory: What you have left (from physical count)
  • Usage/COGS: What you actually used/sold during the period
  • Cost %: Your cost as a percentage of sales (lower is better)

Live Google Sheets Preview

Interact with the full template below. The complete version includes separate tabs for Food and Beverage inventory with item-level tracking, categories, and automatic calculations.

Tip: Download the Excel version from The Vault to customize with your own items and categories.