How to Track Cost of Goods Sold for Handmade Items

What cost of goods sold means for a maker

For handmade businesses, cost of goods sold usually centers on the materials and direct production inputs that go into each item. If you are selling candles, jewelry, crochet goods, paper goods, or sewn products, your COGS should reflect the true direct cost of making those items.

That means your ingredient list matters. So does the quantity you actually use, not just the pack size you bought at the store.

The data you need to track COGS well

You do not need an enterprise inventory system. You do need consistency. The more repeatable your pantry and recipe records are, the easier it becomes to understand cost of goods sold later.

• What each supply cost when you bought it
• How much of that supply goes into one product
• Whether a product has packaging or insert costs
• Whether costs changed between one purchase and the next

Why spreadsheets start to break down

Spreadsheets are fine for an early draft, but they get shaky once you have many materials, many product variations, and changing supply costs. One stale cell can quietly distort the whole picture.

The harder part is not entering the first number. It is trusting the numbers six weeks later after your pantry has changed.

A better workflow for handmade COGS

The most useful workflow is recipe-based: keep a pantry of current materials, then connect those materials to saved product recipes. That gives you a repeatable way to calculate make cost today and revisit it later when new purchases change your blended cost.

This is especially helpful if you sell the same product repeatedly or carry product variations built from similar materials.