How to Track Handmade Materials Cost per Item

If you make things to sell, the hardest number to pin down is usually what the materials in one item actually cost. You buy yarn by the skein, wax by the pound, and fabric by the yard, then use a little of each. Here is a simple way to turn bulk purchases into a reliable cost per item, so your prices and profit numbers rest on real figures.

Step 1: Keep a materials list with unit costs

For every material you buy, write down four things:

• Material (for example, soy wax)
• What you paid, including shipping and tax on the order
• How much you got (in the unit you measure with: grams, ounces, yards, pieces)
• Cost per unit = what you paid ÷ how much you got

When you restock at a different price, update the row (or average the old and new price if you still have old stock).

Step 2: Write a "recipe" for each product

List how much of each material one finished item uses. Measure it once carefully, by weighing or counting, rather than guessing.

Example, one 8 oz candle:

These numbers are made up for illustration. Use your own receipts.

Step 3: Add the small stuff and waste

Small things add up: labels, glue, thread, tape, test pieces, and the bit of material that ends up in the trash. Two easy ways to handle them:

• Give them their own rows if you can measure them (one label = $0.12).
• Or add a waste/consumables buffer of a few percent on top of materials. Check it against your real purchases every few months and adjust.

Step 4: Keep packaging separate

Boxes, tissue, mailers, and thank-you cards are real costs, but they depend on how an order ships, not on the item. Track them as packaging per order so a two-item order doesn't count them twice.

Step 5: Re-check after each restock

Supplier prices change. Each time you restock, update the unit cost and see which products' material cost moved. A small rise on a material you use in everything can quietly eat your margin.

Using the number

Material cost per item is the starting point for pricing. Add your time, packaging, overhead, and selling fees, then compare with the market. Our free guide on how to price handmade products walks through that next step, and Etsy fees explained covers the fees side.

Common mistakes

• Leaving shipping off the supply order, so unit costs look lower than they are.
• Guessing amounts instead of weighing one batch.
• Forgetting test pieces and failed items.
• Never updating unit costs after prices go up.

If you want a head start: the Product Pricing Calculator ($7) has a materials list where you enter what you paid and how many units a pack makes, so cost per unit calculates, then builds each product from up to 4 materials plus labor minutes and packaging. To track supply purchases and sales by month, the Side Hustle Income & Expense Tracker ($7) logs purchases, sales and fees so you can see real monthly profit.

Related template: Product Pricing Calculator. Also see: Side Hustle Income & Expense Tracker

See all Cedar & Ledger templates

Try the free markup vs. margin calculator →

Also see: Small shop inventory count