Inventory & COGS Calculator (Excel + Google Sheets)

Built for makers (candles, soap, jewellery, ceramics, print shops). List your materials and what goes into one unit; the sheet works out cost of goods per product including your labour and sales fees, tells you the price you need for your target margin, deducts stock when you make a batch, and flags what to reorder.

What you get:

• Materials: on hand, weighted-average cost per unit (incl. shipping), stock value, REORDER flag
• Purchases: every supply order; drives average cost and stock in
• Recipes: how much of each material goes into ONE unit of each product (any unit: g, ml, oz, each...)
• Products: materials + labour + packaging = COGS per unit; fees per sale; profit; margin; price for target margin; 'Below target' warning
• Made: log batches; materials are deducted automatically. Sales: units sold give monthly COGS and gross profit
• Stock count adjustment column for when your count differs
• Dashboard: raw stock value, finished goods value, items to reorder, average margin, gross profit; charts
• Cost method stated up front (weighted average), the method most small makers' accountants expect

Included files:

• Inventory and COGS Calculator.xlsx (blank)
• Inventory and COGS Calculator - SAMPLE.xlsx (candle-business demo data)
• 'Start here' instructions tab

Works in: Microsoft Excel 2019, 2021, Microsoft 365 (Windows and Mac), Google Sheets (free), LibreOffice. One .xlsx file for both Excel and Google Sheets; no separate versions to mix up.

After purchase you get an instant download link by email (Payhip). This is a DIGITAL DOWNLOAD. Nothing physical will be shipped.

Refunds: because this is an instantly downloadable file, sales are final, but if the file doesn't open or a formula misbehaves, email me and I will fix it or refund you.

Designed, built and tested by me. I used AI tools to help write formulas and copy; every formula was recalculated and checked against hand calculations before listing.

This is a planning and record-keeping tool, not legal, tax or accounting advice.