Home / International tools

Inventory & COGS Tracker

Inventory spreadsheet with weighted-average cost of goods sold and gross margin.

  • Stock on hand for up to 200 SKUs
  • Weighted-average unit cost, automatic
  • LOW / OUT reorder alerts
  • Cost of goods sold per sale and month
  • COGS formula check (balances to zero)
  • Stock value and gross margin dashboard
Buy on our Etsy shop · from $10.99

Instant download (.xlsx) · Excel, Google Sheets & LibreOffice · Secure checkout

Inventory & COGS Tracker

How it works

  1. 1Add products with opening stock and cost
  2. 2Log purchases as stock arrives
  3. 3Log sales: COGS calculated per sale
  4. 4Reorder LOW items, read your margins

Good to know: SheetBoss tools are organisational tools, not tax, legal or accounting advice. Formula cells are protected (no password) so you can't break them by accident. Licence: one person or one business. Refund policy.