Inventory and COGS Template
A free Excel template to reconcile inventory counts, build landed product costs, calculate COGS by SKU, and value what is on your shelves.
What's inside
Quantity reconciliation
Compare beginning counts, units received, units sold, and known losses against your actual end count, so every SKU's difference is calculated and you can note what caused it.
Product cost catalog
Build a landed cost for each SKU by adding buy cost, shipping, taxes and tariffs, and packaging, so your COGS reflects what it truly took to get each product on the shelf.
Shipping allocation example
An invoice sample shows how to spread one shipment's freight across every SKU on the order by its share of the total, turning a single shipping charge into a per-unit cost.
COGS calculator
Multiply units sold by unit cost for each master SKU, with columns to map matching Amazon ASINs and Shopify SKUs, and get a total COGS figure for the period.
Physical inventory valuation
Add up counts from your own warehouse and your 3PL for each SKU, then multiply by cost to get the total value of inventory on hand for your balance sheet.